<?php
$reqmo['libelle']="dossier depose";
$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],
                      [dossier.avis_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";
$reqmo['sql'].= " where dossier_autorisation_type_detaille.code = '[selection]'";
$reqmo['sql'].= " and date_depot>='[datedebut]'";
$reqmo['sql'].= " and date_depot<='[datefin]'";

/*
                       where dossier.nature = '[selection]' and types ='initial'
                       and (avis_decision like 'F%' or avis_decision like 'T%')
                       order by [tri]";
*/
/*
$sousetat['sql']="SELECT  concat('".$commune."','    ',dossier) as dossier,concat(substring(date_depot,9,2),'-',substring(date_depot,6,2),'-',substring(date_depot,1,4)) as date_depot,concat(demandeur_civilite,' ',demandeur_nom) as nom_demandeur,";
$sousetat['sql']=$sousetat['sql']." concat(terrain_numero,' ',terrain_numero_complement,' ',terrain_adresse,' ',terrain_adresse_complement,' ',terrain_cp,' ',terrain_ville) as adresse_terrain,";
$sousetat['sql']=$sousetat['sql']." shon as SHON,logement_nombre as nb_logt";
$sousetat['sql']=$sousetat['sql']." FROM dossier";
$sousetat['sql']=$sousetat['sql']." WHERE ";
if ($_GET["nature"]=='tous'){
  $sousetat['sql']=$sousetat['sql']." date_depot>='".substr($_GET["datedebut"],6,4)."-".substr($_GET["datedebut"],3,2)."-".substr($_GET["datedebut"],0,2)."'";
  $sousetat['sql']=$sousetat['sql']." AND date_depot<='".substr($_GET["datefin"],6,4)."-".substr($_GET["datefin"],3,2)."-".substr($_GET["datefin"],0,2)."'";
}else{
  $sousetat['sql']=$sousetat['sql']." nature='".$_GET["nature"]."'";
  $sousetat['sql']=$sousetat['sql']." AND (date_depot>='".substr($_GET["datedebut"],6,4)."-".substr($_GET["datedebut"],3,2)."-".substr($_GET["datedebut"],0,2)."'";
  $sousetat['sql']=$sousetat['sql']." AND date_depot<='".substr($_GET["datefin"],6,4)."-".substr($_GET["datefin"],3,2)."-".substr($_GET["datefin"],0,2)."')";
} 
 
*/ 

$reqmo['selection']= array('PCI','PCA','PD','DP','PA','CU','AZ','DAT');
$reqmo['tri']= array('dossier','etat','demandeur_nom');
//
$reqmo['nature']="checked";
$reqmo['etat']="checked";
$reqmo['date_demande']="checked";
$reqmo['date_depot']="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";
$reqmo['date_decision']="checked";
$reqmo['avis_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";
//$reqmo['datedebut']="";
//$reqmo['datefin']="";
?>