15 |
DB_PREFIXE."avis on avis.avis=dossier.avis"; |
DB_PREFIXE."avis on avis.avis=dossier.avis"; |
16 |
$champAffiche=array("dossier", |
$champAffiche=array("dossier", |
17 |
"om_utilisateur.nom as instructeur", |
"om_utilisateur.nom as instructeur", |
18 |
"demandeur_nom", |
"demandeur_nom as nom", |
19 |
"to_char(date_demande,'DD/MM/YYYY') as date_demande", |
"to_char(date_demande,'DD/MM/YYYY') as demande", |
20 |
"to_char(date_depot,'DD/MM/YYYY') as date_depot", |
"to_char(date_depot,'DD/MM/YYYY') as depot", |
21 |
"to_char(date_complet,'DD/MM/YYYY') as date_complet", |
"to_char(date_complet,'DD/MM/YYYY') as complet", |
22 |
"to_char(date_notification_delai,'DD/MM/YYYY') as date_notification_delai", |
"to_char(date_notification_delai,'DD/MM/YYYY') as delai", |
23 |
"to_char(date_limite,'DD/MM/YYYY') as date_limite", |
"to_char(date_limite,'DD/MM/YYYY') as limite", |
24 |
"etat","avis.libelle as avis" |
"etat","avis.libelle as avis" |
25 |
); |
); |
26 |
$champRecherche=array("dossier","demandeur_nom"); |
$champRecherche=array("dossier","demandeur_nom"); |