sql/pgsql/instruction.inc.php

<?php
//$Id$ 
//gen openMairie le 10/02/2011 20:34 
include('../gen/sql/pgsql/instruction.inc.php');
// =======================================================
// href special edition instruction
// =======================================================
$table="instruction inner join evenement on instruction.evenement=evenement.evenement";
$champAffiche=array("instruction as no",
                    "instruction.lettretype",
                    "libelle",
                    "to_char(datecourrier ,'DD/MM/YYYY') as datecourrier",
                    "instruction.etat"
                    );
$champRecherche=array("libelle");
$tri= " order by instruction ";
if(isset($idx)){
    $selection=" where dossier ='".$idx."'";
}else{
   $selection="";
}   
//if(isset($objsf) and isset($idx)){
    $href[3]['lien'] = "../spc/pdflettretype_instruction.php?idx=";
    $href[3]['id']= "";
    $href[3]['lib']= "<img src='../img/ico_pdf.png' border=0>";
//}else
//    $href=array();
?>
1	<?php
2	//$Id$
3	//gen openMairie le 10/02/2011 20:34
4	include('../gen/sql/pgsql/instruction.inc.php');
5	// =======================================================
6	// href special edition instruction
7	// =======================================================
8	$table="instruction inner join evenement on instruction.evenement=evenement.evenement";
9	$champAffiche=array("instruction as no",
10	"instruction.lettretype",
11	"libelle",
12	"to_char(datecourrier ,'DD/MM/YYYY') as datecourrier",
13	"instruction.etat"
14	);
15	$champRecherche=array("libelle");
16	$tri= " order by instruction ";
17	if(isset($idx)){
18	$selection=" where dossier ='".$idx."'";
19	}else{
20	$selection="";
21	}
22	//if(isset($objsf) and isset($idx)){
23	$href[3]['lien'] = "../spc/pdflettretype_instruction.php?idx=";
24	$href[3]['id']= "";
25	$href[3]['lib']= "<img src='../img/ico_pdf.png' border=0>";
26	//}else
27	// $href=array();
28	?>