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	fraynaud	4	<?php
2			//$Id$
3			//gen openMairie le 10/02/2011 22:10
4			include('../gen/sql/pgsql/etat.form.inc.php');
5	vpihour	1130
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	vpihour	1133	$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	fraynaud	4	?>