<?php
$reqmo['libelle']="dossier_accorde";
$reqmo['sql']="SELECT dossier,
                      [dossier_autorisation_type_detaille.code as nature],
                      [dossier.etat as etat],
                      to_char(dossier.date_demande,'DD/MM/YYYY') as date_demande,
                      to_char(dossier.date_depot,'DD/MM/YYYY') as date_depot,
                      to_char(dossier.date_complet,'DD/MM/YYYY') as date_complet,
                      to_char(dossier.date_rejet,'DD/MM/YYYY') as date_rejet,
                      to_char(dossier.date_notification_delai,'DD/MM/YYYY') as date_notification_delai,
                      [dossier.delai],
                      to_char(dossier.date_limite,'DD/MM/YYYY') as date_limite,
                      [dossier.accord_tacite],
                      to_char(dossier.date_decision,'DD/MM/YYYY') as date_decision,
                      to_char(dossier.date_validite,'DD/MM/YYYY') as date_validite,
                      to_char(dossier.date_chantier,'DD/MM/YYYY') as date_chantier,
                      to_char(dossier.date_achevement,'DD/MM/YYYY') as date_achevement,
                      to_char(dossier.date_conformite,'DD/MM/YYYY') as date_conformite,
                      [dossier.parcelle],
                      [dossier.batiment_nombre],
                      [dossier.logement_nombre],
                      [dossier.shon],
                      [dossier.shon_calcul],
                      [dossier.shob],
                      [dossier.lot],
                      [dossier.hauteur],
                      [dossier.piece_nombre],
                      [dossier.amenagement],
                      [dossier.pos],
                      [temp1]
                        FROM ".DB_PREFIXE."dossier
                        INNER JOIN ".DB_PREFIXE."dossier_autorisation
                        ON dossier.dossier_autorisation=dossier_autorisation.dossier_autorisation
                      INNER JOIN ".DB_PREFIXE."dossier_autorisation_type_detaille
                        ON dossier_autorisation.dossier_autorisation_type_detaille 
                        = dossier_autorisation_type_detaille.dossier_autorisation_type_detaille
                        left join ".DB_PREFIXE."avis_decision on avis_decision.avis_decision=dossier.avis_decision	
                       WHERE dossier_autorisation_type_detaille.code = '[selection]'
                        and to_char(date_depot,'YYYY') = '[annee]' 
                        and to_char(date_depot,'MM')  >= '[moisdebut]'
                        and to_char(date_depot,'MM')  <= '[moisfin]'
                        and typeavis like '[avis_decision]'	
                        order by [tri]";


$reqmo['selection']= array('PCI','PCA','PD','DP','PA','CU','AZ','DAT');
$reqmo['avis_decision']= "select distinct(typeavis), typeavis from ".DB_PREFIXE."avis_decision where typeavis <> ''";
$reqmo['tri']= array('dossier','etat','demandeur_nom','date_depot', 'date_decision', 'date_chantier', 'date_achevement', 'date_conformite');
$reqmo['annee']= array(date('Y'),date('Y')-1,date('Y')-2,date('Y')-3);
$reqmo['moisdebut']= array('01','02','03','04','05','06','07','08','09','10','11','12');
$reqmo['moisfin']= array('12','11','10','09','08','07','06','05','04','03','02','01');
$reqmo['nature']="checked";
$reqmo['etat']="checked";
$reqmo['date_demande']="checked";
$reqmo['date_complet']="checked";
$reqmo['date_rejet']="checked";
$reqmo['date_notification_delai']="checked";
$reqmo['delai']="checked";
$reqmo['date_limite']="checked";
$reqmo['accord_tacite']="checked";
// pour eviter le tri en francais = erreur dans le tri
//$reqmo['date_depot']="checked";
//$reqmo['date_decision']="checked";
$reqmo['date_validite']="checked";
//$reqmo['date_chantier']="checked";
//$reqmo['date_achevement']="checked";
//$reqmo['date_conformite']="checked";
$reqmo['parcelle']="checked";
$reqmo['batiment_nombre']="checked";
$reqmo['logement_nombre']="checked";
$reqmo['shon']="checked";
$reqmo['shon_calcul']="checked";
$reqmo['shob']="checked";
$reqmo['lot']="checked";
$reqmo['hauteur']="checked";
$reqmo['piece_nombre']="checked";
$reqmo['amenagement']="checked";
$reqmo['pos']="checked";
$reqmo['temp1']="checked";
?>