3 |
//gen openMairie le 10/02/2011 20:39 |
//gen openMairie le 10/02/2011 20:39 |
4 |
include('../gen/sql/pgsql/dossier.inc.php'); |
include('../gen/sql/pgsql/dossier.inc.php'); |
5 |
$table=DB_PREFIXE."dossier left join ". |
$table=DB_PREFIXE."dossier left join ". |
6 |
DB_PREFIXE."om_utilisateur on dossier.instructeur = om_utilisateur.om_utilisateur left join ". |
DB_PREFIXE."instructeur on dossier.instructeur = instructeur.instructeur left join ". |
7 |
DB_PREFIXE."avis on avis.avis=dossier.avis"; |
DB_PREFIXE."om_utilisateur on instructeur.om_utilisateur = om_utilisateur.om_utilisateur left join ". |
8 |
|
DB_PREFIXE."avis_decision on avis_decision.avis_decision=dossier.avis_decision"; |
9 |
$champAffiche=array( |
$champAffiche=array( |
10 |
'dossier.dossier as "'._("dossier").'"', |
'dossier.dossier as "'._("dossier").'"', |
11 |
'dossier.demandeur_nom as "'._("demandeur_nom").'"', |
'dossier.demandeur_nom as "'._("demandeur_nom").'"', |
12 |
'om_utilisateur.nom as "'._("instructeur").'"', |
'instructeur.nom as "'._("instructeur").'"', |
13 |
'to_char(dossier.date_demande ,\'DD/MM/YYYY\') as "'._("date_demande").'"', |
'to_char(dossier.date_demande ,\'DD/MM/YYYY\') as "'._("date_demande").'"', |
14 |
'to_char(dossier.date_depot ,\'DD/MM/YYYY\') as "'._("date_depot").'"', |
'to_char(dossier.date_depot ,\'DD/MM/YYYY\') as "'._("date_depot").'"', |
15 |
'to_char(dossier.date_complet ,\'DD/MM/YYYY\') as "'._("date_complet").'"', |
'to_char(dossier.date_complet ,\'DD/MM/YYYY\') as "'._("date_complet").'"', |
16 |
'to_char(dossier.date_notification_delai ,\'DD/MM/YYYY\') as "'._("date_notification_delai").'"', |
'to_char(dossier.date_notification_delai ,\'DD/MM/YYYY\') as "'._("date_notification_delai").'"', |
17 |
'to_char(dossier.date_limite ,\'DD/MM/YYYY\') as "'._("date_limite").'"', |
'to_char(dossier.date_limite ,\'DD/MM/YYYY\') as "'._("date_limite").'"', |
18 |
'etat as "'._("etat").'"', |
'etat as "'._("etat").'"', |
19 |
'avis.libelle as "'._("avis").'"', |
'avis_decision.libelle as "'._("avis_decision").'"', |
20 |
|
'CASE WHEN dossier.enjeu_erp IS TRUE AND dossier.enjeu_urba IS TRUE THEN \'Tous\' ELSE |
21 |
|
CASE WHEN dossier.enjeu_erp IS TRUE THEN \'Erp\' ELSE |
22 |
|
CASE WHEN dossier.enjeu_urba IS TRUE THEN \'Urba\' END END END as "'._("enjeu").'"', |
23 |
); |
); |
24 |
|
|
25 |
$tri= "order by dossier.dossier"; |
$tri= "order by dossier.dossier"; |
283 |
"terrain", |
"terrain", |
284 |
"blocnote", |
"blocnote", |
285 |
"destination_shon", |
"destination_shon", |
286 |
"statistique"); |
"statistique", |
287 |
|
"messages"); |
288 |
?> |
?> |