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

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

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

revision 1136 by vpihour, Wed Jan 2 15:02:10 2013 UTC revision 1141 by nhaye, Thu Jan 3 17:20:39 2013 UTC
# Line 71  $champs=array("instruction", Line 71  $champs=array("instruction",
71                "date_envoi_controle_legalite",                "date_envoi_controle_legalite",
72                "date_retour_controle_legalite"                "date_retour_controle_legalite"
73                );                );
74  $sql_transition = "select evenement.evenement,(libelle||' ['||evenement.action||']') as lib  $sql_transition = "select evenement.evenement,(evenement.libelle||' ['||evenement.action||']') as lib
75        from ".DB_PREFIXE."evenement inner join ".DB_PREFIXE."transition on evenement.evenement = transition.evenement";        from ".DB_PREFIXE."evenement
76          inner join ".DB_PREFIXE."transition on evenement.evenement = transition.evenement
77          INNER JOIN ".DB_PREFIXE."lien_dossier_instruction_type_evenement ON
78                evenement.evenement=lien_dossier_instruction_type_evenement.evenement
79            INNER JOIN ".DB_PREFIXE."dossier_instruction_type ON
80                lien_dossier_instruction_type_evenement.dossier_instruction_type =
81                dossier_instruction_type.dossier_instruction_type
82            INNER JOIN ".DB_PREFIXE."dossier_autorisation_type_detaille ON
83                dossier_instruction_type.dossier_autorisation_type_detaille=
84                dossier_autorisation_type_detaille.dossier_autorisation_type_detaille";
85                
86                
87  $sql_transition_by_id = "select evenement.evenement,(libelle||' ['||evenement.action||']') as lib  $sql_transition_by_id = "select evenement.evenement,(evenementlibelle||' ['||evenement.action||']') as lib
88        from ".DB_PREFIXE."evenement inner join ".DB_PREFIXE."transition on evenement.evenement = transition.evenement        from ".DB_PREFIXE."evenement
89          inner join ".DB_PREFIXE."transition on evenement.evenement = transition.evenement
90          INNER JOIN ".DB_PREFIXE."lien_dossier_instruction_type_evenement ON
91                evenement.evenement=lien_dossier_instruction_type_evenement.evenement
92            INNER JOIN ".DB_PREFIXE."dossier_instruction_type ON
93                lien_dossier_instruction_type_evenement.dossier_instruction_type =
94                dossier_instruction_type.dossier_instruction_type
95            INNER JOIN ".DB_PREFIXE."dossier_autorisation_type_detaille ON
96                dossier_instruction_type.dossier_autorisation_type_detaille=
97                dossier_autorisation_type_detaille.dossier_autorisation_type_detaille
98            where evenement=<idx>";            where evenement=<idx>";
99    
100  $portlet_actions['pdfetat'] =  $portlet_actions['pdfetat'] =
Legend:
Removed from v.1136  
changed lines
  Added in v.1141
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26