/[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 1127 by vpihour, Thu Dec 27 15:07:37 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 27/12/2012 12:52  //gen openMairie le 17/07/2013 18:52
4    
5  $DEBUG=0;  $DEBUG=0;
6  $serie=15;  $serie=15;
# Line 22  if (isset($idz) && trim($idz) != '') { Line 22  if (isset($idz) && trim($idz) != '') {
22  $table = DB_PREFIXE."instruction  $table = DB_PREFIXE."instruction
23      LEFT JOIN ".DB_PREFIXE."action      LEFT JOIN ".DB_PREFIXE."action
24          ON instruction.action=action.action          ON instruction.action=action.action
25        LEFT JOIN ".DB_PREFIXE."etat as etat1
26            ON instruction.archive_etat_pendant_incompletude=etat1.etat
27        LEFT JOIN ".DB_PREFIXE."evenement as evenement2
28            ON instruction.archive_evenement_suivant_tacite=evenement2.evenement
29        LEFT JOIN ".DB_PREFIXE."evenement as evenement3
30            ON instruction.archive_evenement_suivant_tacite_incompletude=evenement3.evenement
31      LEFT JOIN ".DB_PREFIXE."avis_decision      LEFT JOIN ".DB_PREFIXE."avis_decision
32          ON instruction.avis_decision=avis_decision.avis_decision          ON instruction.avis_decision=avis_decision.avis_decision
33        LEFT JOIN ".DB_PREFIXE."document_numerise
34            ON instruction.document_numerise=document_numerise.document_numerise
35      LEFT JOIN ".DB_PREFIXE."dossier      LEFT JOIN ".DB_PREFIXE."dossier
36          ON instruction.dossier=dossier.dossier          ON instruction.dossier=dossier.dossier
37      LEFT JOIN ".DB_PREFIXE."etat      LEFT JOIN ".DB_PREFIXE."etat as etat7
38          ON instruction.etat=etat.etat          ON instruction.etat=etat7.etat
39      LEFT JOIN ".DB_PREFIXE."evenement      LEFT JOIN ".DB_PREFIXE."evenement as evenement8
40          ON instruction.evenement=evenement.evenement ";          ON instruction.evenement=evenement8.evenement
41        LEFT JOIN ".DB_PREFIXE."signataire_arrete
42            ON instruction.signataire_arrete=signataire_arrete.signataire_arrete ";
43  // SELECT  // SELECT
44  $champAffiche = array(  $champAffiche = array(
45      'instruction.instruction as "'._("instruction").'"',      'instruction.instruction as "'._("instruction").'"',
46      'instruction.destinataire as "'._("destinataire").'"',      'instruction.destinataire as "'._("destinataire").'"',
47      'to_char(instruction.date_evenement ,\'DD/MM/YYYY\') as "'._("date_evenement").'"',      'to_char(instruction.date_evenement ,\'DD/MM/YYYY\') as "'._("date_evenement").'"',
48      'evenement.libelle as "'._("evenement").'"',      'evenement8.libelle as "'._("evenement").'"',
49      'instruction.lettretype as "'._("lettretype").'"',      'instruction.lettretype as "'._("lettretype").'"',
50      'dossier.nature as "'._("dossier").'"',      'dossier.annee as "'._("dossier").'"',
51      'action.libelle as "'._("action").'"',      'action.libelle as "'._("action").'"',
52      'instruction.delai as "'._("delai").'"',      'instruction.delai as "'._("delai").'"',
53      'etat.libelle as "'._("etat").'"',      'etat7.libelle as "'._("etat").'"',
54      'instruction.accord_tacite as "'._("accord_tacite").'"',      'instruction.accord_tacite as "'._("accord_tacite").'"',
55      'instruction.delai_notification as "'._("delai_notification").'"',      'instruction.delai_notification as "'._("delai_notification").'"',
56      'instruction.archive_delai as "'._("archive_delai").'"',      'instruction.archive_delai as "'._("archive_delai").'"',
# Line 57  $champAffiche = array( Line 67  $champAffiche = array(
67      'to_char(instruction.archive_date_chantier ,\'DD/MM/YYYY\') as "'._("archive_date_chantier").'"',      '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").'"',      'to_char(instruction.archive_date_conformite ,\'DD/MM/YYYY\') as "'._("archive_date_conformite").'"',
69      'avis_decision.libelle as "'._("avis_decision").'"',      'avis_decision.libelle as "'._("avis_decision").'"',
70      'to_char(instruction.date_finaliasation_courrier ,\'DD/MM/YYYY\') as "'._("date_finaliasation_courrier").'"',      '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").'"',      '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").'"',      '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").'"',      '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").'"',      '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").'"',      '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").'"',      '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  //  //
93  $champNonAffiche = array(  $champNonAffiche = array(
# Line 87  $champNonAffiche = array( Line 111  $champNonAffiche = array(
111  $champRecherche = array(  $champRecherche = array(
112      'instruction.instruction as "'._("instruction").'"',      'instruction.instruction as "'._("instruction").'"',
113      'instruction.destinataire as "'._("destinataire").'"',      'instruction.destinataire as "'._("destinataire").'"',
114      'evenement.libelle as "'._("evenement").'"',      'evenement8.libelle as "'._("evenement").'"',
115      'instruction.lettretype as "'._("lettretype").'"',      'instruction.lettretype as "'._("lettretype").'"',
116      'dossier.libelle as "'._("dossier").'"',      'dossier.annee as "'._("dossier").'"',
117      'action.libelle as "'._("action").'"',      'action.libelle as "'._("action").'"',
118      'instruction.delai as "'._("delai").'"',      'instruction.delai as "'._("delai").'"',
119      'etat.libelle as "'._("etat").'"',      'etat7.libelle as "'._("etat").'"',
120      'instruction.accord_tacite as "'._("accord_tacite").'"',      'instruction.accord_tacite as "'._("accord_tacite").'"',
121      'instruction.delai_notification as "'._("delai_notification").'"',      'instruction.delai_notification as "'._("delai_notification").'"',
122      'instruction.archive_delai as "'._("archive_delai").'"',      'instruction.archive_delai as "'._("archive_delai").'"',
# Line 100  $champRecherche = array( Line 124  $champRecherche = array(
124      'instruction.archive_etat as "'._("archive_etat").'"',      'instruction.archive_etat as "'._("archive_etat").'"',
125      'instruction.archive_avis as "'._("archive_avis").'"',      'instruction.archive_avis as "'._("archive_avis").'"',
126      'avis_decision.libelle as "'._("avis_decision").'"',      '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="ORDER BY instruction.destinataire ASC NULLS LAST";  $tri="ORDER BY instruction.destinataire ASC NULLS LAST";
139  $edition="instruction";  $edition="instruction";
# Line 107  $selection=''; Line 141  $selection='';
141  if ($retourformulaire== 'action') {  if ($retourformulaire== 'action') {
142      $selection=" WHERE (instruction.action ='".$idx."')";      $selection=" WHERE (instruction.action ='".$idx."')";
143  }  }
144    if ($retourformulaire== 'etat') {
145        $selection=" WHERE (instruction.archive_etat_pendant_incompletude ='".$idx."' OR instruction.etat ='".$idx."')";
146    }
147    if ($retourformulaire== 'evenement') {
148        $selection=" WHERE (instruction.archive_evenement_suivant_tacite ='".$idx."' OR instruction.archive_evenement_suivant_tacite_incompletude ='".$idx."' OR instruction.evenement ='".$idx."')";
149    }
150  if ($retourformulaire== 'avis_decision') {  if ($retourformulaire== 'avis_decision') {
151      $selection=" WHERE (instruction.avis_decision ='".$idx."')";      $selection=" WHERE (instruction.avis_decision ='".$idx."')";
152  }  }
153    if ($retourformulaire== 'document_numerise') {
154        $selection=" WHERE (instruction.document_numerise ='".$idx."')";
155    }
156  if ($retourformulaire== 'dossier') {  if ($retourformulaire== 'dossier') {
157      $selection=" WHERE (instruction.dossier ='".$idx."')";      $selection=" WHERE (instruction.dossier ='".$idx."')";
158  }  }
159  if ($retourformulaire== 'etat') {  if ($retourformulaire== 'signataire_arrete') {
160      $selection=" WHERE (instruction.etat ='".$idx."')";      $selection=" WHERE (instruction.signataire_arrete ='".$idx."')";
 }  
 if ($retourformulaire== 'evenement') {  
     $selection=" WHERE (instruction.evenement ='".$idx."')";  
161  }  }
162  $sousformulaire = array(  $sousformulaire = array(
163      'demande',);      'demande',);
Legend:
Removed from v.1127  
changed lines
  Added in v.2099
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26