/[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 312 by atreal, Wed Mar 28 17:19:49 2012 UTC revision 2099 by nhaye, Thu Jul 18 09:33:06 2013 UTC
# Line 1  Line 1 
1  <?php  <?php
 //$Id$  
 //gen openMairie le 10/02/2011 20:33  
 include('../gen/sql/pgsql/evenement.form.inc.php');  
 $sql_om_lettretype="select id,(id||' '||libelle) as libelle from ".  
                     DB_PREFIXE."om_lettretype";  
 ?>  
2    /**
3     *
4     *
5     * @package openfoncier
6     * @version SVN : $Id$
7     */
8    
9    //
10    include "../gen/sql/pgsql/evenement.form.inc.php";
11    
12    //
13    $sep = (isset($_GET['action']) && ($_GET['action'] == 1 || $_GET['action'] == 0 )) ? ';' : ',' ;
14    
15    //
16    $champs = array(
17        "evenement.evenement",
18        "evenement.libelle",
19        "evenement.type",
20        "array_to_string(array_agg(transition.etat ORDER BY transition.etat), '$sep') as etats_depuis_lequel_l_evenement_est_disponible",
21        "array_to_string(array_agg(dossier_instruction_type ORDER BY dossier_instruction_type), '$sep') as dossier_instruction_type",
22        "evenement.restriction",
23        "evenement.action",
24        "evenement.etat",
25        "evenement.delai",
26        "evenement.accord_tacite",
27        "evenement.delai_notification",
28        "evenement.avis_decision",
29        "evenement.lettretype",
30        "evenement.consultation",
31        "evenement.autorite_competente",
32        "evenement.evenement_suivant_tacite",
33        "evenement.evenement_retour_ar",
34        "evenement.evenement_retour_signature",
35    );
36    
37    //
38    $tableSelect = "
39    ".DB_PREFIXE."evenement
40      LEFT JOIN ".DB_PREFIXE."lien_dossier_instruction_type_evenement
41        ON lien_dossier_instruction_type_evenement.evenement=evenement.evenement
42      LEFT JOIN ".DB_PREFIXE."transition
43        ON transition.evenement=evenement.evenement";
44    
45    //
46    $selection = " GROUP BY evenement.evenement, evenement.libelle ";
47    
48    // FKEY - OM_LETTRETYPE
49    $sql_om_lettretype = "
50    SELECT
51      id,
52      (id||' '||libelle) as lib
53    FROM ".DB_PREFIXE."om_lettretype
54    ORDER BY lib";
55    
56    $sql_action="SELECT action.action, action.libelle as lib FROM ".DB_PREFIXE."action ORDER BY lib";
57    $sql_etat="SELECT etat.etat, etat.libelle as lib FROM ".DB_PREFIXE."etat ORDER BY lib";
58    $sql_avis_decision="SELECT avis_decision.avis_decision, avis_decision.libelle as lib FROM ".DB_PREFIXE."avis_decision ORDER BY lib";
59    $sql_evenement_retour_ar="SELECT evenement.evenement, evenement.libelle as lib FROM ".DB_PREFIXE."evenement ORDER BY lib";
60    $sql_evenement_suivant_tacite="SELECT evenement.evenement, evenement.libelle as lib FROM ".DB_PREFIXE."evenement ORDER BY lib";
61    $sql_evenement_retour_signature="SELECT evenement.evenement, evenement.libelle as lib FROM ".DB_PREFIXE."evenement ORDER BY lib";
62    
63    
64    // LIAISON NaN - DOSSIER_INSTRUCTION_TYPE (LIEN_DOSSIER_INSTRUCTION_TYPE_EVENEMENT)
65    $sql_dossier_instruction_type = "
66    SELECT
67      dossier_instruction_type.dossier_instruction_type,
68      CONCAT(dossier_autorisation_type_detaille.code,' - ',dossier_instruction_type.code,' - ',dossier_instruction_type.libelle) as lib
69    FROM ".DB_PREFIXE."dossier_instruction_type
70      LEFT JOIN ".DB_PREFIXE."dossier_autorisation_type_detaille
71        ON dossier_instruction_type.dossier_autorisation_type_detaille=dossier_autorisation_type_detaille.dossier_autorisation_type_detaille
72    ORDER BY dossier_autorisation_type_detaille.code";
73    $sql_dossier_instruction_type_by_id = "
74    SELECT
75      dossier_instruction_type.dossier_instruction_type,
76      CONCAT(dossier_autorisation_type_detaille.code,' - ',dossier_instruction_type.code,' - ',dossier_instruction_type.libelle) as lib
77    FROM ".DB_PREFIXE."dossier_instruction_type
78      LEFT JOIN ".DB_PREFIXE."dossier_autorisation_type_detaille
79        ON dossier_instruction_type.dossier_autorisation_type_detaille=dossier_autorisation_type_detaille.dossier_autorisation_type_detaille
80    WHERE dossier_instruction_type IN (<idx>)
81    ORDER BY dossier_autorisation_type_detaille.code";
82    
83    // LIAISON NaN - ETAT (TRANSITION)
84    $sql_etats_depuis_lequel_l_evenement_est_disponible = "
85    SELECT
86      etat.etat,
87      etat.libelle as lib
88    FROM ".DB_PREFIXE."etat
89    ORDER BY lib";
90    $sql_etats_depuis_lequel_l_evenement_est_disponible_by_id = "
91    SELECT
92      etat.etat,
93      etat.libelle as lib
94    FROM ".DB_PREFIXE."etat
95    WHERE etat.etat IN (<idx>)
96    ORDER BY lib";
97    
98    ?>
Legend:
Removed from v.312  
changed lines
  Added in v.2099
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26