sql/pgsql/evenement.form.inc.php

<?php
/**
 *
 *
 * @package openfoncier
 * @version SVN : $Id$
 */

//
include "../gen/sql/pgsql/evenement.form.inc.php";

//
$sep = (isset($_GET['action']) && ($_GET['action'] == 1 || $_GET['action'] == 0 )) ? ';' : ',' ;

//
$champs = array(
    "evenement.evenement",
    "evenement.libelle",
    "evenement.type",
    "array_to_string(array_agg(transition.etat ORDER BY transition.etat), '$sep') as etats_depuis_lequel_l_evenement_est_disponible",
    "array_to_string(array_agg(dossier_instruction_type ORDER BY dossier_instruction_type), '$sep') as dossier_instruction_type",
    "evenement.restriction",
    "evenement.action",
    "evenement.etat",
    "evenement.delai",
    "evenement.accord_tacite",
    "evenement.delai_notification",
    "evenement.avis_decision",
    "evenement.lettretype",
    "evenement.consultation",
    "evenement.autorite_competente",
    "evenement.evenement_suivant_tacite",
    "evenement.evenement_retour_ar",
    "evenement.evenement_retour_signature",
);

//
$tableSelect = "
".DB_PREFIXE."evenement 
  LEFT JOIN ".DB_PREFIXE."lien_dossier_instruction_type_evenement 
    ON lien_dossier_instruction_type_evenement.evenement=evenement.evenement
  LEFT JOIN ".DB_PREFIXE."transition 
    ON transition.evenement=evenement.evenement";

//
$selection = " GROUP BY evenement.evenement, evenement.libelle ";

// FKEY - OM_LETTRETYPE
$sql_om_lettretype = "
SELECT
  id,
  (id||' '||libelle) as lib
FROM ".DB_PREFIXE."om_lettretype
ORDER BY lib";

$sql_action="SELECT action.action, action.libelle as lib FROM ".DB_PREFIXE."action ORDER BY lib";
$sql_etat="SELECT etat.etat, etat.libelle as lib FROM ".DB_PREFIXE."etat ORDER BY lib";
$sql_avis_decision="SELECT avis_decision.avis_decision, avis_decision.libelle as lib FROM ".DB_PREFIXE."avis_decision ORDER BY lib";
$sql_evenement_retour_ar="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";
$sql_evenement_retour_signature="SELECT evenement.evenement, evenement.libelle as lib FROM ".DB_PREFIXE."evenement ORDER BY lib";


// LIAISON NaN - DOSSIER_INSTRUCTION_TYPE (LIEN_DOSSIER_INSTRUCTION_TYPE_EVENEMENT)
$sql_dossier_instruction_type = "
SELECT 
  dossier_instruction_type.dossier_instruction_type, 
  CONCAT(dossier_autorisation_type_detaille.code,' - ',dossier_instruction_type.code,' - ',dossier_instruction_type.libelle) as lib
FROM ".DB_PREFIXE."dossier_instruction_type 
  LEFT JOIN ".DB_PREFIXE."dossier_autorisation_type_detaille
    ON dossier_instruction_type.dossier_autorisation_type_detaille=dossier_autorisation_type_detaille.dossier_autorisation_type_detaille
ORDER BY dossier_autorisation_type_detaille.code";
$sql_dossier_instruction_type_by_id = "
SELECT 
  dossier_instruction_type.dossier_instruction_type, 
  CONCAT(dossier_autorisation_type_detaille.code,' - ',dossier_instruction_type.code,' - ',dossier_instruction_type.libelle) as lib
FROM ".DB_PREFIXE."dossier_instruction_type 
  LEFT JOIN ".DB_PREFIXE."dossier_autorisation_type_detaille
    ON dossier_instruction_type.dossier_autorisation_type_detaille=dossier_autorisation_type_detaille.dossier_autorisation_type_detaille
WHERE dossier_instruction_type IN (<idx>) 
ORDER BY dossier_autorisation_type_detaille.code";

// LIAISON NaN - ETAT (TRANSITION)
$sql_etats_depuis_lequel_l_evenement_est_disponible = "
SELECT
  etat.etat,
  etat.libelle as lib
FROM ".DB_PREFIXE."etat
ORDER BY lib";
$sql_etats_depuis_lequel_l_evenement_est_disponible_by_id = "
SELECT
  etat.etat,
  etat.libelle as lib
FROM ".DB_PREFIXE."etat 
WHERE etat.etat IN (<idx>) 
ORDER BY lib";

?>
1	fraynaud	3	<?php
2	fmichon	1549	/**
3			*
4			*
5			* @package openfoncier
6			* @version SVN : $Id$
7			*/
8	vpihour	1133
9	fmichon	1549	//
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	vpihour	1133	"evenement.evenement",
18	fmichon	1540	"evenement.libelle",
19	fmichon	1543	"evenement.type",
20	fmichon	1540	"array_to_string(array_agg(transition.etat ORDER BY transition.etat), '$sep') as etats_depuis_lequel_l_evenement_est_disponible",
21	fmichon	1506	"array_to_string(array_agg(dossier_instruction_type ORDER BY dossier_instruction_type), '$sep') as dossier_instruction_type",
22	fmichon	1540	"evenement.restriction",
23			"evenement.action",
24			"evenement.etat",
25			"evenement.delai",
26			"evenement.accord_tacite",
27	fmichon	1543	"evenement.delai_notification",
28			"evenement.avis_decision",
29	fmichon	1544	"evenement.lettretype",
30			"evenement.consultation",
31	nhaye	2099	"evenement.autorite_competente",
32	fmichon	1540	"evenement.evenement_suivant_tacite",
33			"evenement.evenement_retour_ar",
34	nhaye	1564	"evenement.evenement_retour_signature",
35	fmichon	1506	);
36	vpihour	1133
37	fmichon	1549	//
38			$tableSelect = "
39			".DB_PREFIXE."evenement
40			LEFT JOIN ".DB_PREFIXE."lien_dossier_instruction_type_evenement
41	fmichon	1540	ON lien_dossier_instruction_type_evenement.evenement=evenement.evenement
42	fmichon	1549	LEFT JOIN ".DB_PREFIXE."transition
43	fmichon	1540	ON transition.evenement=evenement.evenement";
44	vpihour	1133
45	fmichon	1549	//
46			$selection = " GROUP BY evenement.evenement, evenement.libelle ";
47	vpihour	1133
48	fmichon	1549	// 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	fmichon	1502
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	nhaye	1569	$sql_evenement_retour_signature="SELECT evenement.evenement, evenement.libelle as lib FROM ".DB_PREFIXE."evenement ORDER BY lib";
62	fmichon	1502
63	nhaye	1569
64	fmichon	1549	// 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	fmichon	1540	FROM ".DB_PREFIXE."etat
89			ORDER BY lib";
90	fmichon	1549	$sql_etats_depuis_lequel_l_evenement_est_disponible_by_id = "
91			SELECT
92			etat.etat,
93			etat.libelle as lib
94	fmichon	1540	FROM ".DB_PREFIXE."etat
95			WHERE etat.etat IN (<idx>)
96			ORDER BY lib";
97
98	fmichon	1549	?>