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=DB_PREFIXE."instruction inner join ".DB_PREFIXE."evenement on instruction.evenement=evenement.evenement 
    LEFT JOIN ".DB_PREFIXE."signataire_arrete 
        ON instruction.signataire_arrete=signataire_arrete.signataire_arrete";
$champAffiche=array("instruction as no",
                    "instruction.lettretype",
                    "signataire_arrete.nom as \""._("signataire_arrete")."\"",
                    "libelle",
                    "to_char(date_evenement ,'DD/MM/YYYY') as date_evenement",
                    "instruction.etat",
                    "dossier"
                    );
$champRecherche=array("libelle");
$tri= " order by instruction ";
if(isset($idx)){
    $selection=" where dossier like '".$idx."'";
}else{
   $selection="";
}   
?>
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=DB_PREFIXE."instruction inner join ".DB_PREFIXE."evenement on instruction.evenement=evenement.evenement
9	LEFT JOIN ".DB_PREFIXE."signataire_arrete
10	ON instruction.signataire_arrete=signataire_arrete.signataire_arrete";
11	$champAffiche=array("instruction as no",
12	"instruction.lettretype",
13	"signataire_arrete.nom as \""._("signataire_arrete")."\"",
14	"libelle",
15	"to_char(date_evenement ,'DD/MM/YYYY') as date_evenement",
16	"instruction.etat",
17	"dossier"
18	);
19	$champRecherche=array("libelle");
20	$tri= " order by instruction ";
21	if(isset($idx)){
22	$selection=" where dossier like '".$idx."'";
23	}else{
24	$selection="";
25	}
26	?>