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.form.inc.php'); |
include('../gen/sql/pgsql/instruction.form.inc.php'); |
5 |
$tableSelect="instruction inner join evenement on instruction.evenement=evenement.evenement"; |
$tableSelect=DB_PREFIXE."instruction inner join ".DB_PREFIXE."evenement on instruction.evenement=evenement.evenement"; |
6 |
$champs=array("instruction", |
$champs=array("instruction", |
7 |
"destinataire", |
"destinataire", |
8 |
"instruction.evenement", |
"instruction.evenement", |
54 |
"archive_date_chantier", |
"archive_date_chantier", |
55 |
); |
); |
56 |
$sql_transition = "select evenement,(libelle||' ['||evenement.action||']') as lib |
$sql_transition = "select evenement,(libelle||' ['||evenement.action||']') as lib |
57 |
from evenement inner join transition on evenement.action = transition.action"; |
from ".DB_PREFIXE."evenement inner join ".DB_PREFIXE."transition on evenement.action = transition.action"; |
|
//$sql_transition = "select evenement,evenement.action as lib |
|
|
// from evenement "; |
|
|
|
|
58 |
|
|
59 |
?> |
?> |