sql/pgsql/etat.form.inc.php

<?php
/**
 *
 *
 * @package openfoncier
 * @version SVN : $Id: etat.form.inc.php 4418 2015-02-24 17:30:28Z tbenita $
 */

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

//
$champs = array (
    "etat.etat",
    "etat.libelle",
    "etat.statut",
    "array_to_string(array_agg(transition.evenement ORDER BY transition.evenement), ';') as evenement",
);

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

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

// LIAISON NaN - EVENEMENT (TRANSITION)
$sql_evenement="SELECT 
evenement.evenement,
evenement.libelle 
FROM ".DB_PREFIXE."evenement 
ORDER BY evenement.libelle";
$sql_evenement_by_id = "SELECT 
evenement.evenement,
evenement.libelle
FROM ".DB_PREFIXE."evenement 
WHERE evenement IN (<idx>) 
ORDER BY evenement.libelle";

?>
1	<?php
2	/**
3	*
4	*
5	* @package openfoncier
6	* @version SVN : $Id: etat.form.inc.php 4418 2015-02-24 17:30:28Z tbenita $
7	*/
8
9	//
10	include "../gen/sql/pgsql/etat.form.inc.php";
11
12	//
13	$champs = array (
14	"etat.etat",
15	"etat.libelle",
16	"etat.statut",
17	"array_to_string(array_agg(transition.evenement ORDER BY transition.evenement), ';') as evenement",
18	);
19
20	//
21	$tableSelect = DB_PREFIXE."etat
22	LEFT JOIN ".DB_PREFIXE."transition
23	ON transition.etat=etat.etat";
24
25	//
26	$selection = " GROUP BY etat.etat, libelle ";
27
28	// LIAISON NaN - EVENEMENT (TRANSITION)
29	$sql_evenement="SELECT
30	evenement.evenement,
31	evenement.libelle
32	FROM ".DB_PREFIXE."evenement
33	ORDER BY evenement.libelle";
34	$sql_evenement_by_id = "SELECT
35	evenement.evenement,
36	evenement.libelle
37	FROM ".DB_PREFIXE."evenement
38	WHERE evenement IN (<idx>)
39	ORDER BY evenement.libelle";
40
41	?>