/[openfoncier]/trunk/gen/sql/pgsql/instruction.inc.php
ViewVC logotype

Diff of /trunk/gen/sql/pgsql/instruction.inc.php

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

revision 342 by fraynaud, Mon Jul 2 09:36:56 2012 UTC revision 2099 by nhaye, Thu Jul 18 09:33:06 2013 UTC
# Line 1  Line 1 
1  <?php  <?php
2  //$Id$  //$Id$
3  //gen openMairie le 28/06/2012 16:26  //gen openMairie le 17/07/2013 18:52
4    
5  $DEBUG=0;  $DEBUG=0;
6  $serie=15;  $serie=15;
7  $ico="../img/ico_application.png";  $ico="../img/ico_application.png";
# Line 11  if(!isset($tricolsf)) $tricolsf=''; Line 12  if(!isset($tricolsf)) $tricolsf='';
12  if(!isset($premiersf)) $premiersf='';  if(!isset($premiersf)) $premiersf='';
13  if(!isset($selection)) $selection='';  if(!isset($selection)) $selection='';
14  if(!isset($retourformulaire)) $retourformulaire='';  if(!isset($retourformulaire)) $retourformulaire='';
15  if(isset($idx)){  if (isset($idx) && $idx != ']' && trim($idx) != '') {
16      if($idx != ']')      $ent .= "->&nbsp;".$idx."&nbsp;";
17      if (trim($idx!=''))  }
18          $ent = $ent."-><font id='idz1'>&nbsp;".$idx."&nbsp;</font>";  if (isset($idz) && trim($idz) != '') {
19      }      $ent .= "&nbsp;".strtoupper($idz)."&nbsp;";
20      if(isset($idz) ){  }
21      if (trim($idz!=''))  // FROM
22          $ent = $ent."&nbsp;<font id='idz1'>&nbsp;".strtoupper($idz)."&nbsp;</font>";  $table = DB_PREFIXE."instruction
23  }      LEFT JOIN ".DB_PREFIXE."action
24  $table=DB_PREFIXE."instruction";          ON instruction.action=action.action
25  $champAffiche=array(      LEFT JOIN ".DB_PREFIXE."etat as etat1
26      'instruction as "'._("instruction").'"',          ON instruction.archive_etat_pendant_incompletude=etat1.etat
27      'destinataire as "'._("destinataire").'"',      LEFT JOIN ".DB_PREFIXE."evenement as evenement2
28      'to_char(datecourrier ,\'DD/MM/YYYY\') as "'._("datecourrier").'"',          ON instruction.archive_evenement_suivant_tacite=evenement2.evenement
29      'evenement as "'._("evenement").'"',      LEFT JOIN ".DB_PREFIXE."evenement as evenement3
30      'lettretype as "'._("lettretype").'"',          ON instruction.archive_evenement_suivant_tacite_incompletude=evenement3.evenement
31      'dossier as "'._("dossier").'"',      LEFT JOIN ".DB_PREFIXE."avis_decision
32      'action as "'._("action").'"',          ON instruction.avis_decision=avis_decision.avis_decision
33      'delai as "'._("delai").'"',      LEFT JOIN ".DB_PREFIXE."document_numerise
34      'etat as "'._("etat").'"',          ON instruction.document_numerise=document_numerise.document_numerise
35      'accord_tacite as "'._("accord_tacite").'"',      LEFT JOIN ".DB_PREFIXE."dossier
36      'delai_notification as "'._("delai_notification").'"',          ON instruction.dossier=dossier.dossier
37      'avis as "'._("avis").'"',      LEFT JOIN ".DB_PREFIXE."etat as etat7
38      'archive_delai as "'._("archive_delai").'"',          ON instruction.etat=etat7.etat
39      'to_char(archive_date_complet ,\'DD/MM/YYYY\') as "'._("archive_date_complet").'"',      LEFT JOIN ".DB_PREFIXE."evenement as evenement8
40      'to_char(archive_date_rejet ,\'DD/MM/YYYY\') as "'._("archive_date_rejet").'"',          ON instruction.evenement=evenement8.evenement
41      'to_char(archive_date_limite ,\'DD/MM/YYYY\') as "'._("archive_date_limite").'"',      LEFT JOIN ".DB_PREFIXE."signataire_arrete
42      'to_char(archive_date_notification_delai ,\'DD/MM/YYYY\') as "'._("archive_date_notification_delai").'"',          ON instruction.signataire_arrete=signataire_arrete.signataire_arrete ";
43      'archive_accord_tacite as "'._("archive_accord_tacite").'"',  // SELECT
44      'archive_etat as "'._("archive_etat").'"',  $champAffiche = array(
45      'to_char(archive_date_decision ,\'DD/MM/YYYY\') as "'._("archive_date_decision").'"',      'instruction.instruction as "'._("instruction").'"',
46      'archive_avis as "'._("archive_avis").'"',      'instruction.destinataire as "'._("destinataire").'"',
47      'to_char(archive_date_validite ,\'DD/MM/YYYY\') as "'._("archive_date_validite").'"',      'to_char(instruction.date_evenement ,\'DD/MM/YYYY\') as "'._("date_evenement").'"',
48      'to_char(archive_date_achevement ,\'DD/MM/YYYY\') as "'._("archive_date_achevement").'"',      'evenement8.libelle as "'._("evenement").'"',
49      'to_char(archive_date_chantier ,\'DD/MM/YYYY\') as "'._("archive_date_chantier").'"',      'instruction.lettretype as "'._("lettretype").'"',
50      'to_char(archive_date_conformite ,\'DD/MM/YYYY\') as "'._("archive_date_conformite").'"'      'dossier.annee as "'._("dossier").'"',
51        'action.libelle as "'._("action").'"',
52        'instruction.delai as "'._("delai").'"',
53        'etat7.libelle as "'._("etat").'"',
54        'instruction.accord_tacite as "'._("accord_tacite").'"',
55        'instruction.delai_notification as "'._("delai_notification").'"',
56        'instruction.archive_delai as "'._("archive_delai").'"',
57        'to_char(instruction.archive_date_complet ,\'DD/MM/YYYY\') as "'._("archive_date_complet").'"',
58        'to_char(instruction.archive_date_rejet ,\'DD/MM/YYYY\') as "'._("archive_date_rejet").'"',
59        'to_char(instruction.archive_date_limite ,\'DD/MM/YYYY\') as "'._("archive_date_limite").'"',
60        'to_char(instruction.archive_date_notification_delai ,\'DD/MM/YYYY\') as "'._("archive_date_notification_delai").'"',
61        'instruction.archive_accord_tacite as "'._("archive_accord_tacite").'"',
62        'instruction.archive_etat as "'._("archive_etat").'"',
63        'to_char(instruction.archive_date_decision ,\'DD/MM/YYYY\') as "'._("archive_date_decision").'"',
64        'instruction.archive_avis as "'._("archive_avis").'"',
65        'to_char(instruction.archive_date_validite ,\'DD/MM/YYYY\') as "'._("archive_date_validite").'"',
66        'to_char(instruction.archive_date_achevement ,\'DD/MM/YYYY\') as "'._("archive_date_achevement").'"',
67        'to_char(instruction.archive_date_chantier ,\'DD/MM/YYYY\') as "'._("archive_date_chantier").'"',
68        'to_char(instruction.archive_date_conformite ,\'DD/MM/YYYY\') as "'._("archive_date_conformite").'"',
69        'avis_decision.libelle as "'._("avis_decision").'"',
70        'to_char(instruction.date_finalisation_courrier ,\'DD/MM/YYYY\') as "'._("date_finalisation_courrier").'"',
71        'to_char(instruction.date_envoi_signature ,\'DD/MM/YYYY\') as "'._("date_envoi_signature").'"',
72        'to_char(instruction.date_retour_signature ,\'DD/MM/YYYY\') as "'._("date_retour_signature").'"',
73        'to_char(instruction.date_envoi_rar ,\'DD/MM/YYYY\') as "'._("date_envoi_rar").'"',
74        'to_char(instruction.date_retour_rar ,\'DD/MM/YYYY\') as "'._("date_retour_rar").'"',
75        'to_char(instruction.date_envoi_controle_legalite ,\'DD/MM/YYYY\') as "'._("date_envoi_controle_legalite").'"',
76        'to_char(instruction.date_retour_controle_legalite ,\'DD/MM/YYYY\') as "'._("date_retour_controle_legalite").'"',
77        'signataire_arrete.civilite as "'._("signataire_arrete").'"',
78        'instruction.numero_arrete as "'._("numero_arrete").'"',
79        'to_char(instruction.archive_date_dernier_depot ,\'DD/MM/YYYY\') as "'._("archive_date_dernier_depot").'"',
80        "case instruction.archive_incompletude when 't' then 'Oui' else 'Non' end as \""._("archive_incompletude")."\"",
81        'evenement2.libelle as "'._("archive_evenement_suivant_tacite").'"',
82        'evenement3.libelle as "'._("archive_evenement_suivant_tacite_incompletude").'"',
83        'etat1.libelle as "'._("archive_etat_pendant_incompletude").'"',
84        'to_char(instruction.archive_date_limite_incompletude ,\'DD/MM/YYYY\') as "'._("archive_date_limite_incompletude").'"',
85        'instruction.archive_delai_incompletude as "'._("archive_delai_incompletude").'"',
86        'instruction.code_barres as "'._("code_barres").'"',
87        'instruction.om_fichier_instruction as "'._("om_fichier_instruction").'"',
88        "case instruction.om_final_instruction when 't' then 'Oui' else 'Non' end as \""._("om_final_instruction")."\"",
89        'document_numerise.uid as "'._("document_numerise").'"',
90        'instruction.archive_autorite_competente as "'._("archive_autorite_competente").'"',
91      );      );
92  $champNonAffiche=array(  //
93      'complement as "'._("complement").'"',  $champNonAffiche = array(
94      'complement2 as "'._("complement2").'"',      'instruction.complement as "'._("complement").'"',
95      'complement3 as "'._("complement3").'"',      'instruction.complement2 as "'._("complement2").'"',
96      'complement4 as "'._("complement4").'"',      'instruction.complement3 as "'._("complement3").'"',
97      'complement5 as "'._("complement5").'"',      'instruction.complement4 as "'._("complement4").'"',
98      'complement6 as "'._("complement6").'"',      'instruction.complement5 as "'._("complement5").'"',
99      'complement7 as "'._("complement7").'"',      'instruction.complement6 as "'._("complement6").'"',
100      'complement8 as "'._("complement8").'"',      'instruction.complement7 as "'._("complement7").'"',
101      'complement9 as "'._("complement9").'"',      'instruction.complement8 as "'._("complement8").'"',
102      'complement10 as "'._("complement10").'"',      'instruction.complement9 as "'._("complement9").'"',
103      'complement11 as "'._("complement11").'"',      'instruction.complement10 as "'._("complement10").'"',
104      'complement12 as "'._("complement12").'"',      'instruction.complement11 as "'._("complement11").'"',
105      'complement13 as "'._("complement13").'"',      'instruction.complement12 as "'._("complement12").'"',
106      'complement14 as "'._("complement14").'"',      'instruction.complement13 as "'._("complement13").'"',
107      'complement15 as "'._("complement15").'"'      'instruction.complement14 as "'._("complement14").'"',
108        'instruction.complement15 as "'._("complement15").'"',
109      );      );
110  $champRecherche=array(  //
111      'destinataire as "'._("destinataire").'"',  $champRecherche = array(
112      'lettretype as "'._("lettretype").'"',      'instruction.instruction as "'._("instruction").'"',
113      'dossier as "'._("dossier").'"',      'instruction.destinataire as "'._("destinataire").'"',
114      'action as "'._("action").'"',      'evenement8.libelle as "'._("evenement").'"',
115      'etat as "'._("etat").'"',      'instruction.lettretype as "'._("lettretype").'"',
116      'avis as "'._("avis").'"',      'dossier.annee as "'._("dossier").'"',
117      'archive_etat as "'._("archive_etat").'"',      'action.libelle as "'._("action").'"',
118      'archive_avis as "'._("archive_avis").'"'      'instruction.delai as "'._("delai").'"',
119        'etat7.libelle as "'._("etat").'"',
120        'instruction.accord_tacite as "'._("accord_tacite").'"',
121        'instruction.delai_notification as "'._("delai_notification").'"',
122        'instruction.archive_delai as "'._("archive_delai").'"',
123        'instruction.archive_accord_tacite as "'._("archive_accord_tacite").'"',
124        'instruction.archive_etat as "'._("archive_etat").'"',
125        'instruction.archive_avis as "'._("archive_avis").'"',
126        'avis_decision.libelle as "'._("avis_decision").'"',
127        'signataire_arrete.civilite as "'._("signataire_arrete").'"',
128        'instruction.numero_arrete as "'._("numero_arrete").'"',
129        'evenement2.libelle as "'._("archive_evenement_suivant_tacite").'"',
130        'evenement3.libelle as "'._("archive_evenement_suivant_tacite_incompletude").'"',
131        'etat1.libelle as "'._("archive_etat_pendant_incompletude").'"',
132        'instruction.archive_delai_incompletude as "'._("archive_delai_incompletude").'"',
133        'instruction.code_barres as "'._("code_barres").'"',
134        'instruction.om_fichier_instruction as "'._("om_fichier_instruction").'"',
135        'document_numerise.uid as "'._("document_numerise").'"',
136        'instruction.archive_autorite_competente as "'._("archive_autorite_competente").'"',
137      );      );
138  $tri="";  $tri="ORDER BY instruction.destinataire ASC NULLS LAST";
139  $edition="instruction";  $edition="instruction";
140  $selection='';  $selection='';
141  if ($retourformulaire== 'evenement')  if ($retourformulaire== 'action') {
142      $selection=" where instruction.evenement ='".$idx."'";      $selection=" WHERE (instruction.action ='".$idx."')";
143  if ($retourformulaire== 'dossier')  }
144      $selection=" where instruction.dossier ='".$idx."'";  if ($retourformulaire== 'etat') {
145  if ($retourformulaire== 'action')      $selection=" WHERE (instruction.archive_etat_pendant_incompletude ='".$idx."' OR instruction.etat ='".$idx."')";
146      $selection=" where instruction.action ='".$idx."'";  }
147  if ($retourformulaire== 'etat')  if ($retourformulaire== 'evenement') {
148      $selection=" where instruction.etat ='".$idx."'";      $selection=" WHERE (instruction.archive_evenement_suivant_tacite ='".$idx."' OR instruction.archive_evenement_suivant_tacite_incompletude ='".$idx."' OR instruction.evenement ='".$idx."')";
149  if ($retourformulaire== 'avis')  }
150      $selection=" where instruction.avis ='".$idx."'";  if ($retourformulaire== 'avis_decision') {
151        $selection=" WHERE (instruction.avis_decision ='".$idx."')";
152    }
153    if ($retourformulaire== 'document_numerise') {
154        $selection=" WHERE (instruction.document_numerise ='".$idx."')";
155    }
156    if ($retourformulaire== 'dossier') {
157        $selection=" WHERE (instruction.dossier ='".$idx."')";
158    }
159    if ($retourformulaire== 'signataire_arrete') {
160        $selection=" WHERE (instruction.signataire_arrete ='".$idx."')";
161    }
162    $sousformulaire = array(
163        'demande',);
164  ?>  ?>
Legend:
Removed from v.342  
changed lines
  Added in v.2099
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26