<?php
$reqmo['libelle']="dossier_travaux_entre_2_dates";

$reqmo["sql"]= "select dossier, [dossier.etat as etat],
                [to_char(date_depot,'DD/MM/YYYY') as date_depot],    
                [to_char(date_decision,'DD/MM/YYYY') as date_decision],
                [avis.libelle as avis],
                [to_char(date_chantier,'DD/MM/YYYY') as date_chantier],
                [to_char(date_achevement,'DD/MM/YYYY') as date_achevement],
                [terrain_numero||' '||terrain_numero_complement||' '||terrain_adresse||' '||terrain_adresse_complement as adresse_terrain],
                [parcelle],
                [parcelle_lot_lotissement],
                [shon],
                [shob],
                travaux.libelle as libelle, description from ".
            DB_PREFIXE."dossier left join ".
            DB_PREFIXE."travaux on dossier.travaux=travaux.travaux left join ".
            DB_PREFIXE."avis on dossier.avis=avis.avis ";
$reqmo["sql"].= " where dossier.nature = '[selection]'
                        and date_decision > '[depart_AAAA-MM-JJ]' 
                        and date_decision < '[fin_AAAA-MM-JJ]'";
$reqmo["sql"].= " order by [tri]";


$reqmo['etat']='checked';
$reqmo['date_depot']='checked';
$reqmo['date_decision']='checked';
$reqmo['avis']='checked';
$reqmo['date_chantier']='checked';
$reqmo['date_achevement']='checked';
$reqmo['adresse_terrain']='checked';
$reqmo['parcelle']='checked';
$reqmo['parcelle_lot_lotissement']='checked';
$reqmo['shon']='checked';
$reqmo['shob']='checked';
$reqmo['selection']= array('PC','PD','DP','PA','CU');
$reqmo['tri']= array('dossier', 'date_decision');


?>