1 |
<?php |
<?php |
2 |
//$Id$ |
//$Id$ |
3 |
//gen openMairie le 28/06/2012 16:26 |
//gen openMairie le 20/09/2012 10:43 |
4 |
|
|
5 |
require_once ("../obj/om_dbform.class.php"); |
require_once ("../obj/om_dbform.class.php"); |
6 |
|
|
7 |
class om_widget_gen extends om_dbform { |
class om_widget_gen extends om_dbform { |
8 |
var $table="om_widget"; |
var $table="om_widget"; |
9 |
var $clePrimaire="om_widget"; |
var $clePrimaire="om_widget"; |
10 |
var $typeCle="N"; |
var $typeCle="N"; |
11 |
|
var $required_field=array( |
12 |
|
"om_widget", |
13 |
|
"om_collectivite", |
14 |
|
"libelle", |
15 |
|
"lien", |
16 |
|
"texte" |
17 |
|
); |
18 |
var $retourformulaire; |
var $retourformulaire; |
19 |
|
|
20 |
function setvalF($val) { |
function setvalF($val) { |
21 |
//affectation valeur formulaire |
//affectation valeur formulaire |
22 |
if(!is_numeric($val['om_widget'])) |
if(!is_numeric($val['om_widget'])) { |
23 |
unset($this->valF['om_widget']); |
unset($this->valF['om_widget']); |
24 |
else |
} else { |
25 |
$this->valF['om_widget'] = $val['om_widget']; |
$this->valF['om_widget'] = $val['om_widget']; |
26 |
if(!is_numeric($val['om_collectivite'])) |
} |
27 |
|
if(!is_numeric($val['om_collectivite'])) { |
28 |
unset($this->valF['om_collectivite']); |
unset($this->valF['om_collectivite']); |
29 |
else |
} else { |
30 |
$this->valF['om_collectivite'] = $val['om_collectivite']; |
if($_SESSION['niveau']==1) { |
31 |
|
$this->valF['om_collectivite'] = $_SESSION['collectivite']; |
32 |
|
} else { |
33 |
|
$this->valF['om_collectivite'] = $val['om_collectivite']; |
34 |
|
} |
35 |
|
} |
36 |
$this->valF['libelle'] = $val['libelle']; |
$this->valF['libelle'] = $val['libelle']; |
37 |
$this->valF['lien'] = $val['lien']; |
$this->valF['lien'] = $val['lien']; |
38 |
$this->valF['texte'] = $val['texte']; |
$this->valF['texte'] = $val['texte']; |
45 |
|
|
46 |
function setId(&$db) { |
function setId(&$db) { |
47 |
//numero automatique |
//numero automatique |
48 |
$this->valF[$this->table] = $db->nextId(DB_PREFIXE.$this->table); |
$this->valF[$this->clePrimaire] = $db->nextId(DB_PREFIXE.$this->table); |
49 |
} |
} |
50 |
|
|
51 |
function setValFAjout($val) { |
function setValFAjout($val) { |
56 |
//numero automatique -> pas de verfication de cle primaire |
//numero automatique -> pas de verfication de cle primaire |
57 |
} |
} |
58 |
|
|
|
//==================================== |
|
|
// verifier avant validation [verify] |
|
|
//===================================== |
|
|
/** |
|
|
* Methode verifier |
|
|
*/ |
|
|
function verifier($val = array(), &$db = NULL, $DEBUG = false) { |
|
|
// On appelle la methode de la classe parent |
|
|
parent::verifier($val, $db, $DEBUG); |
|
|
// On verifie si le champ n'est pas vide |
|
|
if ($this->valF['om_collectivite'] == "") { |
|
|
$this->correct = false; |
|
|
$this->addToMessage(_("Le champ")." "._("om_collectivite")." "._("est obligatoire")); |
|
|
} |
|
|
} |
|
|
|
|
|
|
|
59 |
//========================== |
//========================== |
60 |
// Formulaire [form] |
// Formulaire [form] |
61 |
//========================== |
//========================== |
65 |
if ($maj==0){ //ajout |
if ($maj==0){ //ajout |
66 |
$form->setType('om_widget','hidden');// cle automatique |
$form->setType('om_widget','hidden');// cle automatique |
67 |
if($this->retourformulaire=='om_collectivite') |
if($this->retourformulaire=='om_collectivite') |
68 |
$form->setType('om_collectivite','hiddenstatic'); |
if($_SESSION['niveau']==2) { |
69 |
|
$form->setType('om_collectivite','selecthiddenstatic'); |
70 |
|
} else { |
71 |
|
$form->setType('om_collectivite','hidden'); |
72 |
|
} |
73 |
else |
else |
74 |
if($_SESSION['niveau']==2) |
if($_SESSION['niveau']==2) |
75 |
$form->setType('om_collectivite','select'); |
$form->setType('om_collectivite','select'); |
76 |
else |
else |
77 |
$form->setType('om_collectivite','hiddenstatic'); |
$form->setType('om_collectivite','hidden'); |
78 |
$form->setType('libelle','text'); |
$form->setType('libelle','text'); |
79 |
$form->setType('lien','text'); |
$form->setType('lien','text'); |
80 |
$form->setType('texte','textarea'); |
$form->setType('texte','textarea'); |
81 |
if($this->retourformulaire=='om_profil') |
|
82 |
$form->setType('om_profil','hiddenstatic'); |
if($this->retourformulaire=='om_profil' |
83 |
else |
and $form->val['om_profil'] == $this->getParameter('idxformulaire')) { |
84 |
|
$form->setType('om_profil','selecthiddenstatic'); |
85 |
|
} else { |
86 |
$form->setType('om_profil','select'); |
$form->setType('om_profil','select'); |
87 |
|
} |
88 |
}// fin ajout |
}// fin ajout |
89 |
if ($maj==1){ //modifier |
if ($maj==1){ //modifier |
90 |
$form->setType('om_widget','hiddenstatic'); |
$form->setType('om_widget','hiddenstatic'); |
91 |
if($this->retourformulaire=='om_collectivite') |
if($this->retourformulaire=='om_collectivite') |
92 |
$form->setType('om_collectivite','hiddenstatic'); |
if($_SESSION['niveau']==2) { |
93 |
|
$form->setType('om_collectivite','selecthiddenstatic'); |
94 |
|
} else { |
95 |
|
$form->setType('om_collectivite','hidden'); |
96 |
|
} |
97 |
else |
else |
98 |
if($_SESSION['niveau']==2) |
if($_SESSION['niveau']==2) |
99 |
$form->setType('om_collectivite','select'); |
$form->setType('om_collectivite','select'); |
100 |
else |
else |
101 |
$form->setType('om_collectivite','hiddenstatic'); |
$form->setType('om_collectivite','hidden'); |
102 |
$form->setType('libelle','text'); |
$form->setType('libelle','text'); |
103 |
$form->setType('lien','text'); |
$form->setType('lien','text'); |
104 |
$form->setType('texte','textarea'); |
$form->setType('texte','textarea'); |
105 |
if($this->retourformulaire=='om_profil') |
|
106 |
$form->setType('om_profil','hiddenstatic'); |
if($this->retourformulaire=='om_profil' |
107 |
else |
and $form->val['om_profil'] == $this->getParameter('idxformulaire')) { |
108 |
|
$form->setType('om_profil','selecthiddenstatic'); |
109 |
|
} else { |
110 |
$form->setType('om_profil','select'); |
$form->setType('om_profil','select'); |
111 |
|
} |
112 |
}// fin modifier |
}// fin modifier |
113 |
if ($maj==2){ //supprimer |
if ($maj==2){ //supprimer |
114 |
$form->setType('om_widget','hiddenstatic'); |
$form->setType('om_widget','hiddenstatic'); |
115 |
$form->setType('om_collectivite','hiddenstatic'); |
if($_SESSION['niveau']==2) { |
116 |
|
$form->setType('om_collectivite','selectstatic'); |
117 |
|
} else { |
118 |
|
$form->setType('om_collectivite','hidden'); |
119 |
|
} |
120 |
$form->setType('libelle','hiddenstatic'); |
$form->setType('libelle','hiddenstatic'); |
121 |
$form->setType('lien','hiddenstatic'); |
$form->setType('lien','hiddenstatic'); |
122 |
$form->setType('texte','hiddenstatic'); |
$form->setType('texte','hiddenstatic'); |
123 |
$form->setType('om_profil','hiddenstatic'); |
$form->setType('om_profil','selectstatic'); |
124 |
}//fin supprimer |
}//fin supprimer |
125 |
|
if ($maj==3){ //consulter |
126 |
|
$form->setType('om_widget','static'); |
127 |
|
if($this->retourformulaire=='om_collectivite') |
128 |
|
if($_SESSION['niveau']==2) { |
129 |
|
$form->setType('om_collectivite','selectstatic'); |
130 |
|
} else { |
131 |
|
$form->setType('om_collectivite','hidden'); |
132 |
|
} |
133 |
|
else |
134 |
|
if($_SESSION['niveau']==2) |
135 |
|
$form->setType('om_collectivite','selectstatic'); |
136 |
|
else |
137 |
|
$form->setType('om_collectivite','hidden'); |
138 |
|
$form->setType('libelle','static'); |
139 |
|
$form->setType('lien','static'); |
140 |
|
$form->setType('texte','textareastatic'); |
141 |
|
$form->setType('om_profil','selectstatic'); |
142 |
|
}//fin consulter |
143 |
} |
} |
144 |
|
|
145 |
function setOnchange(&$form,$maj) { |
function setOnchange(&$form,$maj) { |
187 |
include ("../sql/".$db->phptype."/".$this->table.".form.inc.php"); |
include ("../sql/".$db->phptype."/".$this->table.".form.inc.php"); |
188 |
elseif(file_exists ("../sql/".$db->phptype."/".$this->table.".form.inc")) |
elseif(file_exists ("../sql/".$db->phptype."/".$this->table.".form.inc")) |
189 |
include ("../sql/".$db->phptype."/".$this->table.".form.inc"); |
include ("../sql/".$db->phptype."/".$this->table.".form.inc"); |
190 |
if($maj<2){ |
|
191 |
// om_collectivite |
// om_collectivite |
192 |
$contenu=array(); |
$this->init_select($form, $db, $maj, $debug, "om_collectivite", |
193 |
$res = $db->query($sql_om_collectivite); |
$sql_om_collectivite, $sql_om_collectivite_by_id, false); |
194 |
// Logger |
|
195 |
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_om_collectivite."\");", VERBOSE_MODE); |
// om_profil |
196 |
if (database::isError($res)) |
$this->init_select($form, $db, $maj, $debug, "om_profil", |
197 |
die($res->getMessage().$sql_om_collectivite); |
$sql_om_profil, $sql_om_profil_by_id, false); |
|
else{ |
|
|
if ($debug == 1) |
|
|
echo " la requete ".$sql_om_collectivite." est executee<br>"; |
|
|
$contenu[0][0]=''; |
|
|
$contenu[1][0]=_('choisir')." "._('om_collectivite'); |
|
|
$k=1; |
|
|
while ($row=& $res->fetchRow()){ |
|
|
$contenu[0][$k]=$row[0]; |
|
|
$contenu[1][$k]=$row[1]; |
|
|
$k++; |
|
|
} |
|
|
$form->setSelect('om_collectivite',$contenu); |
|
|
}// fin error db |
|
|
// om_profil |
|
|
$contenu=array(); |
|
|
$res = $db->query($sql_om_profil); |
|
|
// Logger |
|
|
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_om_profil."\");", VERBOSE_MODE); |
|
|
if (database::isError($res)) |
|
|
die($res->getMessage().$sql_om_profil); |
|
|
else{ |
|
|
if ($debug == 1) |
|
|
echo " la requete ".$sql_om_profil." est executee<br>"; |
|
|
$contenu[0][0]=''; |
|
|
$contenu[1][0]=_('choisir')." "._('om_profil'); |
|
|
$k=1; |
|
|
while ($row=& $res->fetchRow()){ |
|
|
$contenu[0][$k]=$row[0]; |
|
|
$contenu[1][$k]=$row[1]; |
|
|
$k++; |
|
|
} |
|
|
$form->setSelect('om_profil',$contenu); |
|
|
}// fin error db |
|
|
}// fin maj |
|
198 |
}// fin select |
}// fin select |
199 |
|
|
200 |
function setVal(&$form,$maj,$validation,&$db,$DEBUG=null){ |
function setVal(&$form,$maj,$validation,&$db,$DEBUG=null){ |
209 |
|
|
210 |
function setValsousformulaire(&$form,$maj,$validation,$idxformulaire,$retourformulaire,$typeformulaire,&$db,$DEBUG=null){ |
function setValsousformulaire(&$form,$maj,$validation,$idxformulaire,$retourformulaire,$typeformulaire,&$db,$DEBUG=null){ |
211 |
$this->retourformulaire = $retourformulaire; |
$this->retourformulaire = $retourformulaire; |
212 |
if($validation==0) { |
if($validation==0 and $maj==0 and $_SESSION['niveau']==1) { |
213 |
|
$form->setVal('om_collectivite', $_SESSION['collectivite']); |
214 |
|
}// fin validation |
215 |
|
if($validation == 0) { |
216 |
if($retourformulaire =='om_collectivite') |
if($retourformulaire =='om_collectivite') |
217 |
$form->setVal('om_collectivite', $idxformulaire); |
$form->setVal('om_collectivite', $idxformulaire); |
218 |
if($retourformulaire =='om_profil') |
if($retourformulaire =='om_profil') |