3 |
//gen openMairie le 10/02/2011 20:32 |
//gen openMairie le 10/02/2011 20:32 |
4 |
include('../gen/sql/pgsql/consultation.form.inc.php'); |
include('../gen/sql/pgsql/consultation.form.inc.php'); |
5 |
|
|
6 |
|
// |
7 |
|
$tableSelect .= " |
8 |
|
LEFT JOIN ".DB_PREFIXE."dossier |
9 |
|
ON consultation.dossier = dossier.dossier"; |
10 |
|
|
11 |
|
// |
12 |
$champs=array("consultation", |
$champs=array("consultation", |
13 |
"dossier", |
"dossier.dossier", |
14 |
|
"dossier_libelle", |
15 |
"service", |
"service", |
16 |
"to_char(consultation.date_envoi ,'DD/MM/YYYY') as \"date_envoi\"", |
"to_char(consultation.date_envoi ,'DD/MM/YYYY') as \"date_envoi\"", |
17 |
"to_char(consultation.date_reception ,'DD/MM/YYYY') as \"date_reception\"", |
"to_char(consultation.date_reception ,'DD/MM/YYYY') as \"date_reception\"", |