sql/pgsql/evenement.form.inc.php

<?php
//$Id$ 
//gen openMairie le 20/09/2012 17:06

$DEBUG=0;
$ico="../img/ico_application.png";
$ent = _("application")." -> "._("evenement");
$tableSelect=DB_PREFIXE."evenement";
$champs=array(
    "evenement",
    "libelle",
    "nature",
    "action",
    "etat",
    "delai",
    "accord_tacite",
    "delai_notification",
    "avis",
    "lettretype",
    "pour_consultation");
//champs select
$sql_nature="SELECT nature.nature, nature.libelle FROM ".DB_PREFIXE."nature";
$sql_nature_by_id = "SELECT nature.nature, nature.libelle FROM ".DB_PREFIXE."nature WHERE nature = '<idx>'";
$sql_action="SELECT action.action, action.libelle FROM ".DB_PREFIXE."action";
$sql_action_by_id = "SELECT action.action, action.libelle FROM ".DB_PREFIXE."action WHERE action = '<idx>'";
$sql_etat="SELECT etat.etat, etat.libelle FROM ".DB_PREFIXE."etat";
$sql_etat_by_id = "SELECT etat.etat, etat.libelle FROM ".DB_PREFIXE."etat WHERE etat = '<idx>'";
$sql_avis="SELECT avis.avis, avis.libelle FROM ".DB_PREFIXE."avis";
$sql_avis_by_id = "SELECT avis.avis, avis.libelle FROM ".DB_PREFIXE."avis WHERE avis = '<idx>'";
?>
1	fraynaud	3	<?php
2			//$Id$
3	nhaye	403	//gen openMairie le 20/09/2012 17:06
4
5	fraynaud	3	$DEBUG=0;
6			$ico="../img/ico_application.png";
7	atreal	307	$ent = _("application")." -> "._("evenement");
8	fraynaud	3	$tableSelect=DB_PREFIXE."evenement";
9	atreal	307	$champs=array(
10			"evenement",
11			"libelle",
12			"nature",
13			"action",
14			"etat",
15			"delai",
16			"accord_tacite",
17			"delai_notification",
18			"avis",
19			"lettretype",
20	nhaye	403	"pour_consultation");
21	fraynaud	3	//champs select
22	nhaye	403	$sql_nature="SELECT nature.nature, nature.libelle FROM ".DB_PREFIXE."nature";
23			$sql_nature_by_id = "SELECT nature.nature, nature.libelle FROM ".DB_PREFIXE."nature WHERE nature = '<idx>'";
24			$sql_action="SELECT action.action, action.libelle FROM ".DB_PREFIXE."action";
25			$sql_action_by_id = "SELECT action.action, action.libelle FROM ".DB_PREFIXE."action WHERE action = '<idx>'";
26			$sql_etat="SELECT etat.etat, etat.libelle FROM ".DB_PREFIXE."etat";
27			$sql_etat_by_id = "SELECT etat.etat, etat.libelle FROM ".DB_PREFIXE."etat WHERE etat = '<idx>'";
28			$sql_avis="SELECT avis.avis, avis.libelle FROM ".DB_PREFIXE."avis";
29			$sql_avis_by_id = "SELECT avis.avis, avis.libelle FROM ".DB_PREFIXE."avis WHERE avis = '<idx>'";
30	fraynaud	3	?>