sql/pgsql/etat.form.inc.php

<?php
//$Id$ 
//gen openMairie le 10/02/2011 22:10 
include('../gen/sql/pgsql/etat.form.inc.php');

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

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

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

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

$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	//$Id$
3	//gen openMairie le 10/02/2011 22:10
4	include('../gen/sql/pgsql/etat.form.inc.php');
5
6	$sep = (isset($_GET['action']) &&
7	($_GET['action'] == 1 \|\| $_GET['action'] == 0 )) ? ';' : ',' ;
8
9	$champs = array (
10	"etat.etat as etat",
11	"libelle",
12	"statut",
13	"array_to_string(array_agg(evenement ORDER BY evenement), '$sep') as evenement"
14	);
15
16	$tableSelect = DB_PREFIXE."etat LEFT JOIN ".DB_PREFIXE."transition ON transition.etat=etat.etat";
17
18	$selection = " GROUP BY etat.etat,libelle,statut";
19
20	$sql_evenement="SELECT
21	evenement.evenement, evenement.libelle
22	FROM
23	".DB_PREFIXE."evenement
24	ORDER BY
25	evenement.libelle";
26	$sql_evenement_by_id = "SELECT
27	evenement.evenement, evenement.libelle
28	FROM
29	".DB_PREFIXE."evenement
30	WHERE
31	evenement IN (<idx>)
32	ORDER BY
33	evenement.libelle";
34	?>