| 1 |
<?php |
| 2 |
$reqmo['libelle']="dossier_travaux_entre_2_dates"; |
| 3 |
|
| 4 |
$reqmo["sql"]= "select dossier, [dossier.etat as etat], |
| 5 |
[to_char(date_depot,'DD/MM/YYYY') as date_depot], |
| 6 |
[to_char(date_decision,'DD/MM/YYYY') as date_decision], |
| 7 |
[avis.libelle as avis], |
| 8 |
[to_char(date_chantier,'DD/MM/YYYY') as date_chantier], |
| 9 |
[to_char(date_achevement,'DD/MM/YYYY') as date_achevement], |
| 10 |
[terrain_numero||' '||terrain_numero_complement||' '||terrain_adresse||' '||terrain_adresse_complement as adresse_terrain], |
| 11 |
[parcelle], |
| 12 |
[parcelle_lot_lotissement], |
| 13 |
[shon], |
| 14 |
[shob], |
| 15 |
travaux.libelle as libelle, description from ". |
| 16 |
DB_PREFIXE."dossier left join ". |
| 17 |
DB_PREFIXE."travaux on dossier.travaux=travaux.travaux left join ". |
| 18 |
DB_PREFIXE."avis on dossier.avis=avis.avis "; |
| 19 |
$reqmo["sql"].= " where dossier.nature = '[selection]' |
| 20 |
and date_decision > '[depart_AAAA-MM-JJ]' |
| 21 |
and date_decision < '[fin_AAAA-MM-JJ]'"; |
| 22 |
$reqmo["sql"].= " order by [tri]"; |
| 23 |
|
| 24 |
|
| 25 |
|
| 26 |
$reqmo['etat']='checked'; |
| 27 |
$reqmo['date_depot']='checked'; |
| 28 |
$reqmo['date_decision']='checked'; |
| 29 |
$reqmo['avis']='checked'; |
| 30 |
$reqmo['date_chantier']='checked'; |
| 31 |
$reqmo['date_achevement']='checked'; |
| 32 |
$reqmo['adresse_terrain']='checked'; |
| 33 |
$reqmo['parcelle']='checked'; |
| 34 |
$reqmo['parcelle_lot_lotissement']='checked'; |
| 35 |
$reqmo['shon']='checked'; |
| 36 |
$reqmo['shob']='checked'; |
| 37 |
$reqmo['selection']= array('PC','PD','DP','PA','CU'); |
| 38 |
$reqmo['tri']= array('dossier', 'date_decision'); |
| 39 |
|
| 40 |
|
| 41 |
|
| 42 |
?> |
Parent Directory
| 
Revision Log