/[openfoncier]/trunk/sql/pgsql/evenement.form.inc.php
ViewVC logotype

Diff of /trunk/sql/pgsql/evenement.form.inc.php

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

revision 1506 by fmichon, Tue Mar 19 17:19:40 2013 UTC revision 1543 by fmichon, Thu Mar 21 07:41:17 2013 UTC
# Line 10  $sep = (isset($_GET['action']) && Line 10  $sep = (isset($_GET['action']) &&
10    
11  $champs=array(  $champs=array(
12      "evenement.evenement",      "evenement.evenement",
13      "libelle",      "evenement.libelle",
14        "evenement.type",
15        "array_to_string(array_agg(transition.etat ORDER BY transition.etat), '$sep') as etats_depuis_lequel_l_evenement_est_disponible",
16      "array_to_string(array_agg(dossier_instruction_type ORDER BY dossier_instruction_type), '$sep') as dossier_instruction_type",      "array_to_string(array_agg(dossier_instruction_type ORDER BY dossier_instruction_type), '$sep') as dossier_instruction_type",
17      "restriction",      "evenement.restriction",
18      "action",      "evenement.action",
19      "etat",      "evenement.etat",
20      "delai",      "evenement.delai",
21      "accord_tacite",      "evenement.accord_tacite",
22      "evenement_suivant_tacite",      "evenement.delai_notification",
23      "delai_notification",      "evenement.avis_decision",
24      "evenement_retour_ar",      "evenement.evenement_suivant_tacite",
25      "lettretype",      "evenement.evenement_retour_ar",
26      "consultation",      "evenement.lettretype",
27      "avis_decision",      "evenement.consultation",
28      "type",  
29  );  );
30    
31  $tableSelect = DB_PREFIXE."evenement  $tableSelect = DB_PREFIXE."evenement
32                  LEFT JOIN  LEFT JOIN ".DB_PREFIXE."lien_dossier_instruction_type_evenement
33                      ".DB_PREFIXE."lien_dossier_instruction_type_evenement      ON lien_dossier_instruction_type_evenement.evenement=evenement.evenement
34                      ON  LEFT JOIN ".DB_PREFIXE."transition
35                          lien_dossier_instruction_type_evenement.evenement=evenement.evenement";      ON transition.evenement=evenement.evenement";
36    
37  $selection = " GROUP BY evenement.evenement,libelle";  $selection = " GROUP BY evenement.evenement,libelle";
38    
# Line 67  $sql_avis_decision="SELECT avis_decision Line 69  $sql_avis_decision="SELECT avis_decision
69  $sql_evenement_retour_ar="SELECT evenement.evenement, evenement.libelle as lib FROM ".DB_PREFIXE."evenement ORDER BY lib";  $sql_evenement_retour_ar="SELECT evenement.evenement, evenement.libelle as lib FROM ".DB_PREFIXE."evenement ORDER BY lib";
70  $sql_evenement_suivant_tacite="SELECT evenement.evenement, evenement.libelle as lib FROM ".DB_PREFIXE."evenement ORDER BY lib";  $sql_evenement_suivant_tacite="SELECT evenement.evenement, evenement.libelle as lib FROM ".DB_PREFIXE."evenement ORDER BY lib";
71    
72    $sql_etats_depuis_lequel_l_evenement_est_disponible="SELECT
73    etat.etat,
74    etat.libelle as lib
75    FROM ".DB_PREFIXE."etat
76    ORDER BY lib";
77    $sql_etats_depuis_lequel_l_evenement_est_disponible_by_id = "SELECT
78    etat.etat,
79    etat.libelle as lib
80    FROM ".DB_PREFIXE."etat
81    WHERE etat.etat IN (<idx>)
82    ORDER BY lib";
83    
84  ?>  ?>
Legend:
Removed from v.1506  
changed lines
  Added in v.1543
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26