sql/pgsql/dossier_validite.reqmo.inc

<?php
$reqmo['libelle']="dossier_validite_reqmo";
$reqmo['sql']="select dossier,
                      [dossier.nature as nature],
                      [etat],
                      [accord_tacite],
                      [to_char(date_decision,'DD/MM/YYYY') as date_decision],
                      [avis],
                      to_char(date_validite,'DD/MM/YYYY') as date_validite,
                      demandeur_civilite,
                      demandeur_nom,
                      demandeur_societe,
                      demandeur_adresse,
                      demandeur_cp,
                      demandeur_ville,
                      [demandeur_pays],
                      [demandeur_telephone],
                      [demandeur_email]
                       from dossier left join travaux on travaux.travaux = dossier.travaux
                       left join categorie_demandeur on categorie_demandeur.categorie_demandeur= dossier.demandeur_categorie
                       where dossier.nature = '[selection]'
                       and to_char(date_validite,'YYYY') = '[annee]'
                       and to_char(date_validite,'MM')  = '[mois]'
                       and etat='accepter'
                       order by [tri]";

$reqmo['selection']= array('PC','PD','DP','PA','CU');
$reqmo['mois']= array('01','02','03','04','05','06','07','08','09','10','11','12');
$reqmo['annee']= array(date('Y'),date('Y')+1,date('Y')+2,date('Y')+3,date('Y')+4);
$reqmo['tri']= array('dossier','etat','demandeur_nom');
//

$reqmo['nature']="checked";
$reqmo['etat']="checked";
$reqmo['accord_tacite']="checked";
$reqmo['date_decision']="checked";
$reqmo['avis']="checked";
$reqmo['date_validite']="checked";
$reqmo['demandeur_pays']="checked";
$reqmo['demandeur_telephone']="checked";
$reqmo['demandeur_email']="checked";

?>
1	fraynaud	3	<?php
2			$reqmo['libelle']="dossier_validite_reqmo";
3			$reqmo['sql']="select dossier,
4			[dossier.nature as nature],
5			[etat],
6			[accord_tacite],
7	fraynaud	200	[to_char(date_decision,'DD/MM/YYYY') as date_decision],
8	fraynaud	3	[avis],
9	fraynaud	200	to_char(date_validite,'DD/MM/YYYY') as date_validite,
10	fraynaud	3	demandeur_civilite,
11			demandeur_nom,
12			demandeur_societe,
13			demandeur_adresse,
14			demandeur_cp,
15			demandeur_ville,
16			[demandeur_pays],
17			[demandeur_telephone],
18			[demandeur_email]
19			from dossier left join travaux on travaux.travaux = dossier.travaux
20			left join categorie_demandeur on categorie_demandeur.categorie_demandeur= dossier.demandeur_categorie
21			where dossier.nature = '[selection]'
22	fraynaud	200	and to_char(date_validite,'YYYY') = '[annee]'
23			and to_char(date_validite,'MM') = '[mois]'
24	fraynaud	3	and etat='accepter'
25			order by [tri]";
26
27			$reqmo['selection']= array('PC','PD','DP','PA','CU');
28			$reqmo['mois']= array('01','02','03','04','05','06','07','08','09','10','11','12');
29			$reqmo['annee']= array(date('Y'),date('Y')+1,date('Y')+2,date('Y')+3,date('Y')+4);
30			$reqmo['tri']= array('dossier','etat','demandeur_nom');
31			//
32
33			$reqmo['nature']="checked";
34			$reqmo['etat']="checked";
35			$reqmo['accord_tacite']="checked";
36			$reqmo['date_decision']="checked";
37			$reqmo['avis']="checked";
38			$reqmo['date_validite']="checked";
39			$reqmo['demandeur_pays']="checked";
40			$reqmo['demandeur_telephone']="checked";
41			$reqmo['demandeur_email']="checked";
42
43			?>