sql/pgsql/om_etat.form.inc.php

<?php
//$Id$ 
//gen openMairie le 04/11/2010 17:47 
include('../gen/sql/pgsql/om_etat.form.inc.php');
$champs=array("om_etat","om_collectivite","'lettretype.png' as image",
              "id","libelle", 'actif',
              "orientation","format",
              "footerfont","footerattribut","footertaille",
              "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",
              "'' as om_sousetat","sousetat", //*** specific
              "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='Oui' and om_collectivite=".$_SESSION['collectivite'];
$sql_om_sousetat.=" order by libelle";
// restriction collectivite si multi
?>
1	fraynaud	3	<?php
2			//$Id$
3			//gen openMairie le 04/11/2010 17:47
4			include('../gen/sql/pgsql/om_etat.form.inc.php');
5			$champs=array("om_etat","om_collectivite","'lettretype.png' as image",
6			"id","libelle", 'actif',
7			"orientation","format",
8			"footerfont","footerattribut","footertaille",
9			"logo","logoleft","logotop",
10			"titre","titreleft","titretop","titrelargeur","titrehauteur",
11			"titrefont","titreattribut","titretaille","titrebordure","titrealign",
12			"corps","corpsleft","corpstop","corpslargeur","corpshauteur",
13			"corpsfont","corpsattribut","corpstaille","corpsbordure","corpsalign",
14			"om_sql",
15			"'' as om_sousetat","sousetat", //*** specific
16			"se_font","se_margeleft","se_margetop","se_margeright","se_couleurtexte");
17			$sql_om_sousetat="select id, (id\|\|' '\|\|libelle) from ".DB_PREFIXE."om_sousetat";
18			$sql_om_sousetat.=" where actif='Oui' and om_collectivite=".$_SESSION['collectivite'];
19			$sql_om_sousetat.=" order by libelle";
20			// restriction collectivite si multi
21			?>