/[openfoncier]/trunk/sql/pgsql/evenement_avis.reqmo.inc.php
ViewVC logotype

Diff of /trunk/sql/pgsql/evenement_avis.reqmo.inc.php

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 312 by atreal, Wed Mar 28 17:19:49 2012 UTC revision 1138 by nhaye, Thu Jan 3 15:18:21 2013 UTC
# Line 3  Line 3 
3  //gen openMairie le 10/02/2011 20:33  //gen openMairie le 10/02/2011 20:33
4  $reqmo['libelle']=' public.evenement';  $reqmo['libelle']=' public.evenement';
5  $reqmo['reqmo_libelle']=' public.evenement';  $reqmo['reqmo_libelle']=' public.evenement';
6  $reqmo['sql']="select  [evenement], [libelle], [nature], [action], [etat], [delai], [accord_tacite], [delai_notification], [lettretype], [consultation] from ".DB_PREFIXE."evenement where avis = '[avis]' order by [tri]";  $reqmo['sql']="select [evenement.evenement as evenement],
7                            [evenement.libelle as libelle],
8                            [dossier_autorisation_type_detaille.code as nature],
9                            [action],
10                            [etat],
11                            [delai],
12                            [accord_tacite],
13                            [delai_notification],
14                            [lettretype],
15                            [consultation]
16                    from ".DB_PREFIXE."evenement
17                    INNER JOIN ".DB_PREFIXE."lien_dossier_instruction_type_evenement ON
18                        evenement.evenement=lien_dossier_instruction_type_evenement.evenement
19                    INNER JOIN ".DB_PREFIXE."dossier_instruction_type ON
20                        lien_dossier_instruction_type_evenement.dossier_instruction_type =
21                        dossier_instruction_type.dossier_instruction_type
22                    INNER JOIN ".DB_PREFIXE."dossier_autorisation_type_detaille ON
23                        dossier_instruction_type.dossier_autorisation_type_detaille =
24                        dossier_autorisation_type_detaille.dossier_autorisation_type_detaille
25                    where avis_decision = '[avis_decision]' order by [tri]";
26  $reqmo['evenement']='checked';  $reqmo['evenement']='checked';
27  $reqmo['libelle']='checked';  $reqmo['libelle']='checked';
28  $reqmo['nature']='checked';  $reqmo['nature']='checked';
# Line 12  $reqmo['etat']='checked'; Line 31  $reqmo['etat']='checked';
31  $reqmo['delai']='checked';  $reqmo['delai']='checked';
32  $reqmo['accord_tacite']='checked';  $reqmo['accord_tacite']='checked';
33  $reqmo['delai_notification']='checked';  $reqmo['delai_notification']='checked';
34  $reqmo['avis']="select * from ".DB_PREFIXE."avis";  $reqmo['avis_decision']="select avis_decision,libelle from ".DB_PREFIXE."avis_decision";
35  $reqmo['lettretype']='checked';  $reqmo['lettretype']='checked';
36  $reqmo['consultation']='checked';  $reqmo['consultation']='checked';
37  $reqmo['tri']=array('evenement','libelle','nature','action','etat','delai','accord_tacite','delai_notification','lettretype','consultation');  $reqmo['tri']=array('evenement','libelle','nature','action','etat','delai','accord_tacite','delai_notification','lettretype','consultation');
Legend:
Removed from v.312  
changed lines
  Added in v.1138
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26