| 1 |
<?php |
| 2 |
//$Id$ |
| 3 |
//gen openMairie le 10/02/2011 20:34 |
| 4 |
include('../gen/sql/pgsql/instruction.form.inc.php'); |
| 5 |
$tableSelect="instruction inner join evenement on instruction.evenement=evenement.evenement"; |
| 6 |
$champs=array("instruction", |
| 7 |
"destinataire", |
| 8 |
"instruction.evenement", |
| 9 |
"libelle", |
| 10 |
"datecourrier", |
| 11 |
"instruction.lettretype", |
| 12 |
"complement", |
| 13 |
"'' as bible_auto", |
| 14 |
"'' as bible", |
| 15 |
"complement2", |
| 16 |
"'' as bible2", |
| 17 |
"complement3", |
| 18 |
"'' as bible3", |
| 19 |
"complement4", |
| 20 |
"'' as bible4", |
| 21 |
"complement5", |
| 22 |
"'' as bible5", |
| 23 |
"complement6", |
| 24 |
"'' as bible6", |
| 25 |
"complement7", |
| 26 |
"'' as bible7", |
| 27 |
"complement8", |
| 28 |
"'' as bible8", |
| 29 |
"complement9", |
| 30 |
"'' as bible9", |
| 31 |
"complement10", |
| 32 |
"'' as bible10", |
| 33 |
"complement11", |
| 34 |
"'' as bible11", |
| 35 |
"dossier", |
| 36 |
"instruction.action", |
| 37 |
"instruction.delai", |
| 38 |
"instruction.etat", |
| 39 |
"instruction.accord_tacite", |
| 40 |
"instruction.delai_notification", |
| 41 |
"instruction.avis", |
| 42 |
"archive_delai", |
| 43 |
"archive_accord_tacite", |
| 44 |
"archive_etat", |
| 45 |
"archive_avis", |
| 46 |
"archive_date_complet", |
| 47 |
"archive_date_rejet", |
| 48 |
"archive_date_limite", |
| 49 |
"archive_date_notification_delai", |
| 50 |
"archive_date_decision", |
| 51 |
"archive_date_validite", |
| 52 |
"archive_date_achevement", |
| 53 |
"archive_date_conformite", |
| 54 |
"archive_date_chantier", |
| 55 |
); |
| 56 |
$sql_transition = "select evenement,(libelle||' ['||evenement.action||']') as lib |
| 57 |
from evenement inner join transition on evenement.action = transition.action"; |
| 58 |
//$sql_transition = "select evenement,evenement.action as lib |
| 59 |
// from evenement "; |
| 60 |
|
| 61 |
|
| 62 |
?> |
Parent Directory
| 
Revision Log