<?php
$reqmo['libelle']="dossier";
$reqmo['sql']="SELECT [dossier.dossier as dossier],
[dossier_autorisation_type_detaille.code as nature],
[dossier.annee as annee],
[dossier.etat as etat],
[dossier.instructeur as instructeur],
[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 as delai],
[to_char(dossier.date_limite, 'DD/MM/YYYY') as date_limite],
[dossier.accord_tacite as 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 as parcelle],
[dossier.batiment_nombre as batiment_nombre],
[dossier.logement_nombre as logement_nombre],
[dossier.shon as shon],
[dossier.shon_calcul as shon_calcul],
[dossier.shob as shob],
[dossier.lot as lot],
[dossier.hauteur as hauteur],
[dossier.piece_nombre as piece_nombre],
[dossier.amenagement as amenagement]
                      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
                       WHERE dossier_autorisation_type_detaille.code = '[selection]'
                       and logement_nombre >= [logement_nombre_superieur]                  
                       order by [tri]";
$reqmo['selection']= array('PCI','PCA','PA');
$reqmo['logement_nombre_superieur']= array('0','1','2','3','4','5','10','20');
$reqmo['tri']= array('dossier','etat','demandeur_nom');
//

$reqmo['dossier']='checked';
$reqmo['nature']='checked';
$reqmo['annee']='checked';
$reqmo['etat']='checked';
$reqmo['instructeur']='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['date_validite']='checked';
$reqmo['date_chantier']='checked';
$reqmo['date_achevement']='checked';
$reqmo['date_conformite']='checked';
$reqmo['parcelle']='checked';
$reqmo['pos']='checked';
$reqmo['sig']='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';
?>