sql/pgsql/dossier_validite.reqmo.inc.php

<?php
$reqmo['libelle']="dossier_validite_reqmo";
$reqmo['sql']="select dossier,
                      [dossier.nature as nature],
                      [etat],
                      [accord_tacite],
                      [concat(substring(date_decision,9,2),'/',substring(date_decision,6,2),'/',substring(date_decision,1,4)) as date_decision],
                      [avis],
                      concat(substring(date_validite,9,2),'/',substring(date_validite,6,2),'/',substring(date_validite,1,4)) 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 substring(date_validite,1,4) = '[annee]'
                       and substring(date_validite,6,2)  = '[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	<?php
2	$reqmo['libelle']="dossier_validite_reqmo";
3	$reqmo['sql']="select dossier,
4	[dossier.nature as nature],
5	[etat],
6	[accord_tacite],
7	[concat(substring(date_decision,9,2),'/',substring(date_decision,6,2),'/',substring(date_decision,1,4)) as date_decision],
8	[avis],
9	concat(substring(date_validite,9,2),'/',substring(date_validite,6,2),'/',substring(date_validite,1,4)) as date_validite,
10	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	and substring(date_validite,1,4) = '[annee]'
23	and substring(date_validite,6,2) = '[mois]'
24	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	?>