<?php
$reqmo['libelle']="dossier_validite_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_validite,'DD/MM/YYYY') as date_validite],
                [round((date_validite - date_decision)/365.25) as annee],
                [to_char(date_chantier,'DD/MM/YYYY') as date_chantier],
                [to_char(date_achevement,'DD/MM/YYYY') as date_achevement] 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"].= " and date_chantier is null and etat = 'accepter' ";
$reqmo["sql"].= " order by [tri]";


$reqmo['etat']='checked';
$reqmo['date_depot']='checked';
$reqmo['date_decision']='checked';
$reqmo['date_validite']='checked';
$reqmo['annee']='checked';
$reqmo['avis']='checked';
$reqmo['date_chantier']='checked';
$reqmo['date_achevement']='checked';
$reqmo['selection']= array('PC','PD','DP','PA','CU');
$reqmo['tri']= array('dossier', 'date_decision');


?>