| 48 |
LEFT JOIN ".DB_PREFIXE."avis_decision |
LEFT JOIN ".DB_PREFIXE."avis_decision |
| 49 |
ON avis_decision.avis_decision=dossier.avis_decision |
ON avis_decision.avis_decision=dossier.avis_decision |
| 50 |
LEFT JOIN ".DB_PREFIXE."arrondissement |
LEFT JOIN ".DB_PREFIXE."arrondissement |
| 51 |
ON dossier.terrain_adresse_code_postal=arrondissement.code_postal"; |
ON dossier.terrain_adresse_code_postal=arrondissement.code_postal |
| 52 |
|
LEFT JOIN ".DB_PREFIXE."etat |
| 53 |
|
ON dossier.etat = etat.etat"; |
| 54 |
|
|
| 55 |
/*Champs du début de la requête*/ |
/*Champs du début de la requête*/ |
| 56 |
$champAffiche_debut_commun = array( |
$champAffiche_debut_commun = array( |
| 63 |
'to_char(dossier.date_complet ,\'DD/MM/YYYY\') as "'._("date_complet").'"', |
'to_char(dossier.date_complet ,\'DD/MM/YYYY\') as "'._("date_complet").'"', |
| 64 |
'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").'"', |
| 65 |
'to_char(dossier.date_limite ,\'DD/MM/YYYY\') as "'._("date_limite").'"', |
'to_char(dossier.date_limite ,\'DD/MM/YYYY\') as "'._("date_limite").'"', |
| 66 |
'dossier.etat as "'._("etat").'"', |
'etat.libelle as "'._("etat").'"', |
| 67 |
); |
); |
| 68 |
|
|
| 69 |
/*Champs de la fin de la requête*/ |
/*Champs de la fin de la requête*/ |
Parent Directory
| 
Revision Log
| 
Patch