sql/pgsql/om_etat.form.inc.php

<?php
//$Id: om_etat.form.inc.php 2146 2013-03-11 11:33:46Z fmichon $ 
//gen openMairie le 04/11/2010 17:47 
include('../gen/sql/pgsql/om_etat.form.inc.php');

$tableSelect .= " LEFT JOIN ".DB_PREFIXE."om_requete ";
$tableSelect .= " ON om_etat.om_sql=om_requete.id ";

$champs=array(
    "om_etat",
    "om_collectivite",
    "om_etat.id",
    "om_etat.libelle",
    "actif",
    "orientation",
    "format",
    "logo",
    "logoleft",
    "logotop",
    "titre",
    "titreleft",
    "titretop",
    "titrelargeur",
    "titrehauteur",
    "titrefont",
    "titreattribut",
    "titretaille",
    "titrebordure",
    "titrealign",
    "corps",
    "corpsleft",
    "corpstop",
    "corpslargeur",
    "corpshauteur",
    "corpsfont",
    "corpsattribut",
    "corpstaille",
    "corpsbordure",
    "corpsalign",
    "om_sql",
    "merge_fields",
    "sousetat",
    "se_font",
    "se_margeleft",
    "se_margetop",
    "se_margeright",
    "se_couleurtexte");

$sql_om_sousetat="select id, (id||' '||libelle) from ".DB_PREFIXE."om_sousetat";
$sql_om_sousetat.=" where actif IS TRUE and om_collectivite=".$_SESSION['collectivite'];
$sql_om_sousetat.=" order by libelle";

$sql_om_sousetat_by_id="select id, (id||' '||libelle) from ".DB_PREFIXE."om_sousetat";
$sql_om_sousetat_by_id.=" ";

$sql_om_logo="select id, (libelle||' ('||id||')') from ".DB_PREFIXE."om_logo";
$sql_om_logo.=" where actif IS TRUE and om_collectivite=".$_SESSION['collectivite'];
$sql_om_logo.=" order by libelle";

$sql_om_logo_by_id="select id, (libelle||' ('||id||')') from ".DB_PREFIXE."om_logo";
$sql_om_logo_by_id.=" WHERE id = '<idx>'";
?>
1	fraynaud	3	<?php
2	fmichon	1357	//$Id: om_etat.form.inc.php 2146 2013-03-11 11:33:46Z fmichon $
3	fraynaud	3	//gen openMairie le 04/11/2010 17:47
4			include('../gen/sql/pgsql/om_etat.form.inc.php');
5	fmichon	1357
6			$tableSelect .= " LEFT JOIN ".DB_PREFIXE."om_requete ";
7			$tableSelect .= " ON om_etat.om_sql=om_requete.id ";
8
9			$champs=array(
10			"om_etat",
11			"om_collectivite",
12			"om_etat.id",
13			"om_etat.libelle",
14			"actif",
15			"orientation",
16			"format",
17			"logo",
18			"logoleft",
19			"logotop",
20			"titre",
21			"titreleft",
22			"titretop",
23			"titrelargeur",
24			"titrehauteur",
25			"titrefont",
26			"titreattribut",
27			"titretaille",
28			"titrebordure",
29			"titrealign",
30			"corps",
31			"corpsleft",
32			"corpstop",
33			"corpslargeur",
34			"corpshauteur",
35			"corpsfont",
36			"corpsattribut",
37			"corpstaille",
38			"corpsbordure",
39			"corpsalign",
40			"om_sql",
41			"merge_fields",
42			"sousetat",
43			"se_font",
44			"se_margeleft",
45			"se_margetop",
46			"se_margeright",
47			"se_couleurtexte");
48
49	fraynaud	3	$sql_om_sousetat="select id, (id\|\|' '\|\|libelle) from ".DB_PREFIXE."om_sousetat";
50	nhaye	391	$sql_om_sousetat.=" where actif IS TRUE and om_collectivite=".$_SESSION['collectivite'];
51	fraynaud	3	$sql_om_sousetat.=" order by libelle";
52	fmichon	1357
53			$sql_om_sousetat_by_id="select id, (id\|\|' '\|\|libelle) from ".DB_PREFIXE."om_sousetat";
54			$sql_om_sousetat_by_id.=" ";
55
56			$sql_om_logo="select id, (libelle\|\|' ('\|\|id\|\|')') from ".DB_PREFIXE."om_logo";
57			$sql_om_logo.=" where actif IS TRUE and om_collectivite=".$_SESSION['collectivite'];
58			$sql_om_logo.=" order by libelle";
59
60			$sql_om_logo_by_id="select id, (libelle\|\|' ('\|\|id\|\|')') from ".DB_PREFIXE."om_logo";
61			$sql_om_logo_by_id.=" WHERE id = '<idx>'";
62			?>