/[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 1502 by fmichon, Mon Mar 18 22:55:18 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      "action",      "evenement.type",
15      "etat",      "array_to_string(array_agg(transition.etat ORDER BY transition.etat), '$sep') as etats_depuis_lequel_l_evenement_est_disponible",
16      "delai",      "array_to_string(array_agg(dossier_instruction_type ORDER BY dossier_instruction_type), '$sep') as dossier_instruction_type",
17      "accord_tacite",      "evenement.restriction",
18      "delai_notification",      "evenement.action",
19      "lettretype",      "evenement.etat",
20      "consultation",      "evenement.delai",
21      "avis_decision",      "evenement.accord_tacite",
22      "restriction",      "evenement.delai_notification",
23      "type",      "evenement.avis_decision",
24      "evenement_retour_ar",      "evenement.evenement_suivant_tacite",
25      "evenement_suivant_tacite",      "evenement.evenement_retour_ar",
26      "array_to_string(array_agg(dossier_instruction_type ORDER BY dossier_instruction_type), '$sep') as dossier_instruction_type");      "evenement.lettretype",
27        "evenement.consultation",
28    
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 66  $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.1502  
changed lines
  Added in v.1543
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26