<?php
$reqmo['libelle']="dossier";
$reqmo['sql']="select dossier,
                      [dossier.nature as nature],
                      [etat],
                      [types],
                      [objet_dossier],
                      [instructeur],
                      [to_char(date_demande,'DD/MM/YYYY') as date_demande],
                      [to_char(date_depot,'DD/MM/YYYY') as date_depot],
                      [to_char(date_complet,'DD/MM/YYYY') as date_complet],
                      [to_char(date_rejet,'DD/MM/YYYY') as date_rejet],
                      [to_char(date_notification_delai,'DD/MM/YYYY') as date_notification_delai],
                      [delai],
                      [to_char(date_limite,'DD/MM/YYYY') as date_limite],
                      [accord_tacite],
                      [to_char(date_decision,'DD/MM/YYYY') as date_decision],
                      [avis],
                      [to_char(date_validite,'DD/MM/YYYY') as date_validite],
                      [to_char(date_chantier,'DD/MM/YYYY') as date_chantier],
                      [to_char(date_achevement,'DD/MM/YYYY') as date_achevement],
                      [to_char(date_conformite,'DD/MM/YYYY') as date_conformite],
                      [demandeur_civilite],
                      [demandeur_nom],
                      [demandeur_societe],
                      [demandeur_adresse],
                      [demandeur_cp],
                      [demandeur_ville],
                      [demandeur_pays],
                      [demandeur_telephone],
                      [demandeur_email],
                      [delegataire_civilite],
                      [delegataire_nom],
                      [delegataire_societe],
                      [delegataire_adresse],
                      [delegataire_cp],
                      [delegataire_ville],
                      [delegataire_pays],
                      [delegataire_telephone],
                      [delegataire_email],
                      [terrain_numero],
                      [terrain_numero_complement],
                      [terrain_adresse],
                      [terrain_adresse_complement],
                      [terrain_cp],
                      [terrain_ville],
                      [terrain_surface],                                                                       [terrain_surface_calcul],
                      [rivoli],
                      [travaux.libelle as travaux],
                      [parcelle],
                      [batiment_nombre],
                      [logement_nombre],
                      [shon],
                      [shon_calcul],                                                 
                      [shob],  
                      [lot],
                      [hauteur],
                      [piece_nombre],                                                
                      [amenagement]                             
                       from ".DB_PREFIXE."dossier left join ".DB_PREFIXE."travaux on travaux.travaux = dossier.travaux
                       where dossier.nature = '[selection]' and logement_nombre >= [logement_nombre_superieur]                  
                       order by [tri]";

$reqmo['selection']= array('PC','PA');
$reqmo['logement_nombre_superieur']= array('0','1','2','3','4','5','10','20');
$reqmo['tri']= array('dossier','etat','demandeur_nom');
//

$reqmo['nature']="checked";
$reqmo['etat']="checked";
$reqmo['types']="checked";
$reqmo['objet_dossier']="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['avis']="checked";
$reqmo['date_validite']="checked";
$reqmo['date_chantier']="checked";
$reqmo['date_achevement']="checked";
$reqmo['date_conformite']="checked";
$reqmo['demandeur_civilite']="checked";
$reqmo['demandeur_nom']="checked";
$reqmo['demandeur_societe']="checked";
$reqmo['demandeur_adresse']="checked";
$reqmo['demandeur_cp']="checked";
$reqmo['demandeur_ville']="checked";
$reqmo['demandeur_pays']="checked";
$reqmo['demandeur_telephone']="checked";
$reqmo['demandeur_email']="checked";
$reqmo['delegataire_civilite']="checked";
$reqmo['delegataire_nom']="checked";
$reqmo['delegataire_societe']="checked";
$reqmo['delegataire_adresse']="checked";
$reqmo['delegataire_cp']="checked";
$reqmo['delegataire_ville']="checked";
$reqmo['delegataire_pays']="checked";
$reqmo['delegataire_telephone']="checked";
$reqmo['delegataire_email']="checked";
$reqmo['terrain_numero']="checked";
$reqmo['terrain_numero_complement']="checked";
$reqmo['terrain_adresse']="checked";
$reqmo['terrain_adresse_complement']="checked";
$reqmo['terrain_cp']="checked";
$reqmo['terrain_ville']="checked";
$reqmo['terrain_surface']="checked";
$reqmo['terrain_surface_calcul']="checked";
$reqmo['rivoli']="checked";
$reqmo['travaux']="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";  
?>