2 |
//$Id$ |
//$Id$ |
3 |
//gen openMairie le 10/02/2011 20:34 |
//gen openMairie le 10/02/2011 20:34 |
4 |
include('../gen/sql/pgsql/instruction.inc.php'); |
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 |
|
$champAffiche=array("instruction as no", |
10 |
|
"instruction.lettretype", |
11 |
|
"libelle", |
12 |
|
"to_char(date_evenement ,'DD/MM/YYYY') as date_evenement", |
13 |
|
"instruction.etat", |
14 |
|
"dossier" |
15 |
|
); |
16 |
|
$champRecherche=array("libelle"); |
17 |
|
$tri= " order by instruction "; |
18 |
|
if(isset($idx)){ |
19 |
|
$selection=" where dossier like '".$idx."'"; |
20 |
|
}else{ |
21 |
|
$selection=""; |
22 |
|
} |
23 |
?> |
?> |