/[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 2029 by nhaye, Wed May 29 10:46:53 2013 UTC revision 2030 by softime, Thu Jun 20 11:51:39 2013 UTC
# Line 1  Line 1 
1  <?php  <?php
2  //$Id$  //$Id$
3  //gen openMairie le 29/05/2013 11:23  //gen openMairie le 20/06/2013 12:21
4    
5  $DEBUG=0;  $DEBUG=0;
6  $serie=15;  $serie=15;
# Line 30  $table = DB_PREFIXE."instruction Line 30  $table = DB_PREFIXE."instruction
30          ON instruction.archive_evenement_suivant_tacite_incompletude=evenement3.evenement          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 as etat6      LEFT JOIN ".DB_PREFIXE."etat as etat7
38          ON instruction.etat=etat6.etat          ON instruction.etat=etat7.etat
39      LEFT JOIN ".DB_PREFIXE."evenement as evenement7      LEFT JOIN ".DB_PREFIXE."evenement as evenement8
40          ON instruction.evenement=evenement7.evenement          ON instruction.evenement=evenement8.evenement
41      LEFT JOIN ".DB_PREFIXE."signataire_arrete      LEFT JOIN ".DB_PREFIXE."signataire_arrete
42          ON instruction.signataire_arrete=signataire_arrete.signataire_arrete ";          ON instruction.signataire_arrete=signataire_arrete.signataire_arrete ";
43  // SELECT  // SELECT
# Line 43  $champAffiche = array( Line 45  $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      'evenement7.libelle as "'._("evenement").'"',      'evenement8.libelle as "'._("evenement").'"',
49      'instruction.lettretype as "'._("lettretype").'"',      'instruction.lettretype as "'._("lettretype").'"',
50      'dossier.annee 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      'etat6.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 84  $champAffiche = array( Line 86  $champAffiche = array(
86      'instruction.code_barres as "'._("code_barres").'"',      'instruction.code_barres as "'._("code_barres").'"',
87      'instruction.om_fichier_instruction as "'._("om_fichier_instruction").'"',      '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")."\"",      "case instruction.om_final_instruction when 't' then 'Oui' else 'Non' end as \""._("om_final_instruction")."\"",
89      'instruction.document_arrete as "'._("document_arrete").'"',      'document_numerise.uid as "'._("document_numerise").'"',
90      );      );
91  //  //
92  $champNonAffiche = array(  $champNonAffiche = array(
# Line 108  $champNonAffiche = array( Line 110  $champNonAffiche = array(
110  $champRecherche = array(  $champRecherche = array(
111      'instruction.instruction as "'._("instruction").'"',      'instruction.instruction as "'._("instruction").'"',
112      'instruction.destinataire as "'._("destinataire").'"',      'instruction.destinataire as "'._("destinataire").'"',
113      'evenement7.libelle as "'._("evenement").'"',      'evenement8.libelle as "'._("evenement").'"',
114      'instruction.lettretype as "'._("lettretype").'"',      'instruction.lettretype as "'._("lettretype").'"',
115      'dossier.annee as "'._("dossier").'"',      'dossier.annee as "'._("dossier").'"',
116      'action.libelle as "'._("action").'"',      'action.libelle as "'._("action").'"',
117      'instruction.delai as "'._("delai").'"',      'instruction.delai as "'._("delai").'"',
118      'etat6.libelle as "'._("etat").'"',      'etat7.libelle as "'._("etat").'"',
119      'instruction.accord_tacite as "'._("accord_tacite").'"',      'instruction.accord_tacite as "'._("accord_tacite").'"',
120      'instruction.delai_notification as "'._("delai_notification").'"',      'instruction.delai_notification as "'._("delai_notification").'"',
121      'instruction.archive_delai as "'._("archive_delai").'"',      'instruction.archive_delai as "'._("archive_delai").'"',
# Line 129  $champRecherche = array( Line 131  $champRecherche = array(
131      'instruction.archive_delai_incompletude as "'._("archive_delai_incompletude").'"',      'instruction.archive_delai_incompletude as "'._("archive_delai_incompletude").'"',
132      'instruction.code_barres as "'._("code_barres").'"',      'instruction.code_barres as "'._("code_barres").'"',
133      'instruction.om_fichier_instruction as "'._("om_fichier_instruction").'"',      'instruction.om_fichier_instruction as "'._("om_fichier_instruction").'"',
134      'instruction.document_arrete as "'._("document_arrete").'"',      'document_numerise.uid as "'._("document_numerise").'"',
135      );      );
136  $tri="ORDER BY instruction.destinataire ASC NULLS LAST";  $tri="ORDER BY instruction.destinataire ASC NULLS LAST";
137  $edition="instruction";  $edition="instruction";
# Line 146  if ($retourformulaire== 'evenement') { Line 148  if ($retourformulaire== 'evenement') {
148  if ($retourformulaire== 'avis_decision') {  if ($retourformulaire== 'avis_decision') {
149      $selection=" WHERE (instruction.avis_decision ='".$idx."')";      $selection=" WHERE (instruction.avis_decision ='".$idx."')";
150  }  }
151    if ($retourformulaire== 'document_numerise') {
152        $selection=" WHERE (instruction.document_numerise ='".$idx."')";
153    }
154  if ($retourformulaire== 'dossier') {  if ($retourformulaire== 'dossier') {
155      $selection=" WHERE (instruction.dossier ='".$idx."')";      $selection=" WHERE (instruction.dossier ='".$idx."')";
156  }  }
Legend:
Removed from v.2029  
changed lines
  Added in v.2030
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26