/[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 1571 by nhaye, Thu Mar 28 12:22:00 2013 UTC revision 1717 by nhaye, Thu Apr 18 09:23:52 2013 UTC
# Line 1  Line 1 
1  <?php  <?php
2  //$Id$  //$Id$
3  //gen openMairie le 28/03/2013 11:42  //gen openMairie le 18/04/2013 11:08
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."dossier      LEFT JOIN ".DB_PREFIXE."dossier
34          ON instruction.dossier=dossier.dossier          ON instruction.dossier=dossier.dossier
35      LEFT JOIN ".DB_PREFIXE."etat      LEFT JOIN ".DB_PREFIXE."etat as etat6
36          ON instruction.etat=etat.etat          ON instruction.etat=etat6.etat
37      LEFT JOIN ".DB_PREFIXE."evenement      LEFT JOIN ".DB_PREFIXE."evenement as evenement7
38          ON instruction.evenement=evenement.evenement          ON instruction.evenement=evenement7.evenement
39      LEFT JOIN ".DB_PREFIXE."signataire_arrete      LEFT JOIN ".DB_PREFIXE."signataire_arrete
40          ON instruction.signataire_arrete=signataire_arrete.signataire_arrete ";          ON instruction.signataire_arrete=signataire_arrete.signataire_arrete ";
41  // SELECT  // SELECT
# Line 37  $champAffiche = array( Line 43  $champAffiche = array(
43      'instruction.instruction as "'._("instruction").'"',      'instruction.instruction as "'._("instruction").'"',
44      'instruction.destinataire as "'._("destinataire").'"',      'instruction.destinataire as "'._("destinataire").'"',
45      'to_char(instruction.date_evenement ,\'DD/MM/YYYY\') as "'._("date_evenement").'"',      'to_char(instruction.date_evenement ,\'DD/MM/YYYY\') as "'._("date_evenement").'"',
46      'evenement.libelle as "'._("evenement").'"',      'evenement7.libelle as "'._("evenement").'"',
47      'instruction.lettretype as "'._("lettretype").'"',      'instruction.lettretype as "'._("lettretype").'"',
48      'dossier.annee as "'._("dossier").'"',      'dossier.annee as "'._("dossier").'"',
49      'action.libelle as "'._("action").'"',      'action.libelle as "'._("action").'"',
50      'instruction.delai as "'._("delai").'"',      'instruction.delai as "'._("delai").'"',
51      'etat.libelle as "'._("etat").'"',      'etat6.libelle as "'._("etat").'"',
52      'instruction.accord_tacite as "'._("accord_tacite").'"',      'instruction.accord_tacite as "'._("accord_tacite").'"',
53      'instruction.delai_notification as "'._("delai_notification").'"',      'instruction.delai_notification as "'._("delai_notification").'"',
54      'instruction.archive_delai as "'._("archive_delai").'"',      'instruction.archive_delai as "'._("archive_delai").'"',
# Line 69  $champAffiche = array( Line 75  $champAffiche = array(
75      'signataire_arrete.civilite as "'._("signataire_arrete").'"',      'signataire_arrete.civilite as "'._("signataire_arrete").'"',
76      'instruction.numero_arrete as "'._("numero_arrete").'"',      'instruction.numero_arrete as "'._("numero_arrete").'"',
77      'to_char(instruction.archive_date_dernier_depot ,\'DD/MM/YYYY\') as "'._("archive_date_dernier_depot").'"',      'to_char(instruction.archive_date_dernier_depot ,\'DD/MM/YYYY\') as "'._("archive_date_dernier_depot").'"',
78        "case instruction.archive_incompletude when 't' then 'Oui' else 'Non' end as \""._("archive_incompletude")."\"",
79        'evenement2.libelle as "'._("archive_evenement_suivant_tacite").'"',
80        'evenement3.libelle as "'._("archive_evenement_suivant_tacite_incompletude").'"',
81        'etat1.libelle as "'._("archive_etat_pendant_incompletude").'"',
82        'to_char(instruction.archive_date_limite_incompletude ,\'DD/MM/YYYY\') as "'._("archive_date_limite_incompletude").'"',
83        'instruction.archive_delai_incompletude as "'._("archive_delai_incompletude").'"',
84      );      );
85  //  //
86  $champNonAffiche = array(  $champNonAffiche = array(
# Line 92  $champNonAffiche = array( Line 104  $champNonAffiche = array(
104  $champRecherche = array(  $champRecherche = array(
105      'instruction.instruction as "'._("instruction").'"',      'instruction.instruction as "'._("instruction").'"',
106      'instruction.destinataire as "'._("destinataire").'"',      'instruction.destinataire as "'._("destinataire").'"',
107      'evenement.libelle as "'._("evenement").'"',      'evenement7.libelle as "'._("evenement").'"',
108      'instruction.lettretype as "'._("lettretype").'"',      'instruction.lettretype as "'._("lettretype").'"',
109      'dossier.annee as "'._("dossier").'"',      'dossier.annee as "'._("dossier").'"',
110      'action.libelle as "'._("action").'"',      'action.libelle as "'._("action").'"',
111      'instruction.delai as "'._("delai").'"',      'instruction.delai as "'._("delai").'"',
112      'etat.libelle as "'._("etat").'"',      'etat6.libelle as "'._("etat").'"',
113      'instruction.accord_tacite as "'._("accord_tacite").'"',      'instruction.accord_tacite as "'._("accord_tacite").'"',
114      'instruction.delai_notification as "'._("delai_notification").'"',      'instruction.delai_notification as "'._("delai_notification").'"',
115      'instruction.archive_delai as "'._("archive_delai").'"',      'instruction.archive_delai as "'._("archive_delai").'"',
# Line 107  $champRecherche = array( Line 119  $champRecherche = array(
119      'avis_decision.libelle as "'._("avis_decision").'"',      'avis_decision.libelle as "'._("avis_decision").'"',
120      'signataire_arrete.civilite as "'._("signataire_arrete").'"',      'signataire_arrete.civilite as "'._("signataire_arrete").'"',
121      'instruction.numero_arrete as "'._("numero_arrete").'"',      'instruction.numero_arrete as "'._("numero_arrete").'"',
122        'evenement2.libelle as "'._("archive_evenement_suivant_tacite").'"',
123        'evenement3.libelle as "'._("archive_evenement_suivant_tacite_incompletude").'"',
124        'etat1.libelle as "'._("archive_etat_pendant_incompletude").'"',
125        'instruction.archive_delai_incompletude as "'._("archive_delai_incompletude").'"',
126      );      );
127  $tri="ORDER BY instruction.destinataire ASC NULLS LAST";  $tri="ORDER BY instruction.destinataire ASC NULLS LAST";
128  $edition="instruction";  $edition="instruction";
# Line 114  $selection=''; Line 130  $selection='';
130  if ($retourformulaire== 'action') {  if ($retourformulaire== 'action') {
131      $selection=" WHERE (instruction.action ='".$idx."')";      $selection=" WHERE (instruction.action ='".$idx."')";
132  }  }
133    if ($retourformulaire== 'etat') {
134        $selection=" WHERE (instruction.archive_etat_pendant_incompletude ='".$idx."' OR instruction.etat ='".$idx."')";
135    }
136    if ($retourformulaire== 'evenement') {
137        $selection=" WHERE (instruction.archive_evenement_suivant_tacite ='".$idx."' OR instruction.archive_evenement_suivant_tacite_incompletude ='".$idx."' OR instruction.evenement ='".$idx."')";
138    }
139  if ($retourformulaire== 'avis_decision') {  if ($retourformulaire== 'avis_decision') {
140      $selection=" WHERE (instruction.avis_decision ='".$idx."')";      $selection=" WHERE (instruction.avis_decision ='".$idx."')";
141  }  }
142  if ($retourformulaire== 'dossier') {  if ($retourformulaire== 'dossier') {
143      $selection=" WHERE (instruction.dossier ='".$idx."')";      $selection=" WHERE (instruction.dossier ='".$idx."')";
144  }  }
 if ($retourformulaire== 'etat') {  
     $selection=" WHERE (instruction.etat ='".$idx."')";  
 }  
 if ($retourformulaire== 'evenement') {  
     $selection=" WHERE (instruction.evenement ='".$idx."')";  
 }  
145  if ($retourformulaire== 'signataire_arrete') {  if ($retourformulaire== 'signataire_arrete') {
146      $selection=" WHERE (instruction.signataire_arrete ='".$idx."')";      $selection=" WHERE (instruction.signataire_arrete ='".$idx."')";
147  }  }
Legend:
Removed from v.1571  
changed lines
  Added in v.1717
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26