19 |
DB_PREFIXE."om_utilisateur on dossier.instructeur = om_utilisateur.om_utilisateur left join ". |
DB_PREFIXE."om_utilisateur on dossier.instructeur = om_utilisateur.om_utilisateur left join ". |
20 |
DB_PREFIXE."avis on avis.avis=dossier.avis"; |
DB_PREFIXE."avis on avis.avis=dossier.avis"; |
21 |
$champAffiche=array("dossier", |
$champAffiche=array("dossier", |
|
"om_utilisateur.nom as instructeur", |
|
22 |
"demandeur_nom as nom", |
"demandeur_nom as nom", |
23 |
|
"om_utilisateur.nom as instructeur", |
24 |
"to_char(date_demande,'DD/MM/YYYY') as demande", |
"to_char(date_demande,'DD/MM/YYYY') as demande", |
25 |
"to_char(date_depot,'DD/MM/YYYY') as depot", |
"to_char(date_depot,'DD/MM/YYYY') as depot", |
26 |
"to_char(date_complet,'DD/MM/YYYY') as complet", |
"to_char(date_complet,'DD/MM/YYYY') as complet", |