1 |
<?php |
2 |
//$Id: regle.class.php 5616 2015-12-15 10:53:32Z nmeucci $ |
3 |
//gen openMairie le 15/12/2015 11:49 |
4 |
|
5 |
require_once "../obj/om_dbform.class.php"; |
6 |
|
7 |
class regle_gen extends om_dbform { |
8 |
|
9 |
var $table = "regle"; |
10 |
var $clePrimaire = "regle"; |
11 |
var $typeCle = "N"; |
12 |
var $required_field = array( |
13 |
"champ", |
14 |
"message", |
15 |
"operateur", |
16 |
"ordre", |
17 |
"regle", |
18 |
"sens", |
19 |
"valeur" |
20 |
); |
21 |
|
22 |
var $foreign_keys_extended = array( |
23 |
); |
24 |
|
25 |
|
26 |
|
27 |
function setvalF($val) { |
28 |
//affectation valeur formulaire |
29 |
if (!is_numeric($val['regle'])) { |
30 |
$this->valF['regle'] = ""; // -> requis |
31 |
} else { |
32 |
$this->valF['regle'] = $val['regle']; |
33 |
} |
34 |
$this->valF['sens'] = $val['sens']; |
35 |
if (!is_numeric($val['ordre'])) { |
36 |
$this->valF['ordre'] = ""; // -> requis |
37 |
} else { |
38 |
$this->valF['ordre'] = $val['ordre']; |
39 |
} |
40 |
if ($val['controle'] == "") { |
41 |
$this->valF['controle'] = ""; // -> default |
42 |
} else { |
43 |
$this->valF['controle'] = $val['controle']; |
44 |
} |
45 |
if (!is_numeric($val['id'])) { |
46 |
$this->valF['id'] = 0; // -> default |
47 |
} else { |
48 |
$this->valF['id'] = $val['id']; |
49 |
} |
50 |
$this->valF['champ'] = $val['champ']; |
51 |
$this->valF['operateur'] = $val['operateur']; |
52 |
if (!is_numeric($val['valeur'])) { |
53 |
$this->valF['valeur'] = ""; // -> requis |
54 |
} else { |
55 |
$this->valF['valeur'] = $val['valeur']; |
56 |
} |
57 |
$this->valF['message'] = $val['message']; |
58 |
} |
59 |
|
60 |
//================================================= |
61 |
//cle primaire automatique [automatic primary key] |
62 |
//================================================== |
63 |
|
64 |
function setId(&$dnu1 = null) { |
65 |
//numero automatique |
66 |
$this->valF[$this->clePrimaire] = $this->f->db->nextId(DB_PREFIXE.$this->table); |
67 |
} |
68 |
|
69 |
function setValFAjout($val) { |
70 |
//numero automatique -> pas de controle ajout cle primaire |
71 |
} |
72 |
|
73 |
function verifierAjout() { |
74 |
//numero automatique -> pas de verfication de cle primaire |
75 |
} |
76 |
|
77 |
//========================== |
78 |
// Formulaire [form] |
79 |
//========================== |
80 |
/** |
81 |
* |
82 |
*/ |
83 |
function setType(&$form, $maj) { |
84 |
// Récupération du mode de l'action |
85 |
$crud = $this->get_action_crud($maj); |
86 |
|
87 |
// MODE AJOUTER |
88 |
if ($maj == 0 || $crud == 'create') { |
89 |
$form->setType("regle", "hidden"); |
90 |
$form->setType("sens", "text"); |
91 |
$form->setType("ordre", "text"); |
92 |
$form->setType("controle", "text"); |
93 |
$form->setType("id", "text"); |
94 |
$form->setType("champ", "text"); |
95 |
$form->setType("operateur", "text"); |
96 |
$form->setType("valeur", "text"); |
97 |
$form->setType("message", "text"); |
98 |
} |
99 |
|
100 |
// MDOE MODIFIER |
101 |
if ($maj == 1 || $crud == 'update') { |
102 |
$form->setType("regle", "hiddenstatic"); |
103 |
$form->setType("sens", "text"); |
104 |
$form->setType("ordre", "text"); |
105 |
$form->setType("controle", "text"); |
106 |
$form->setType("id", "text"); |
107 |
$form->setType("champ", "text"); |
108 |
$form->setType("operateur", "text"); |
109 |
$form->setType("valeur", "text"); |
110 |
$form->setType("message", "text"); |
111 |
} |
112 |
|
113 |
// MODE SUPPRIMER |
114 |
if ($maj == 2 || $crud == 'delete') { |
115 |
$form->setType("regle", "hiddenstatic"); |
116 |
$form->setType("sens", "hiddenstatic"); |
117 |
$form->setType("ordre", "hiddenstatic"); |
118 |
$form->setType("controle", "hiddenstatic"); |
119 |
$form->setType("id", "hiddenstatic"); |
120 |
$form->setType("champ", "hiddenstatic"); |
121 |
$form->setType("operateur", "hiddenstatic"); |
122 |
$form->setType("valeur", "hiddenstatic"); |
123 |
$form->setType("message", "hiddenstatic"); |
124 |
} |
125 |
|
126 |
// MODE CONSULTER |
127 |
if ($maj == 3 || $crud == 'read') { |
128 |
$form->setType("regle", "static"); |
129 |
$form->setType("sens", "static"); |
130 |
$form->setType("ordre", "static"); |
131 |
$form->setType("controle", "static"); |
132 |
$form->setType("id", "static"); |
133 |
$form->setType("champ", "static"); |
134 |
$form->setType("operateur", "static"); |
135 |
$form->setType("valeur", "static"); |
136 |
$form->setType("message", "static"); |
137 |
} |
138 |
|
139 |
} |
140 |
|
141 |
|
142 |
function setOnchange(&$form, $maj) { |
143 |
//javascript controle client |
144 |
$form->setOnchange('regle','VerifNum(this)'); |
145 |
$form->setOnchange('ordre','VerifNum(this)'); |
146 |
$form->setOnchange('id','VerifNum(this)'); |
147 |
$form->setOnchange('valeur','VerifFloat(this)'); |
148 |
} |
149 |
/** |
150 |
* Methode setTaille |
151 |
*/ |
152 |
function setTaille(&$form, $maj) { |
153 |
$form->setTaille("regle", 11); |
154 |
$form->setTaille("sens", 10); |
155 |
$form->setTaille("ordre", 11); |
156 |
$form->setTaille("controle", 20); |
157 |
$form->setTaille("id", 11); |
158 |
$form->setTaille("champ", 30); |
159 |
$form->setTaille("operateur", 10); |
160 |
$form->setTaille("valeur", 20); |
161 |
$form->setTaille("message", 30); |
162 |
} |
163 |
|
164 |
/** |
165 |
* Methode setMax |
166 |
*/ |
167 |
function setMax(&$form, $maj) { |
168 |
$form->setMax("regle", 11); |
169 |
$form->setMax("sens", 5); |
170 |
$form->setMax("ordre", 11); |
171 |
$form->setMax("controle", 20); |
172 |
$form->setMax("id", 11); |
173 |
$form->setMax("champ", 30); |
174 |
$form->setMax("operateur", 2); |
175 |
$form->setMax("valeur", 20); |
176 |
$form->setMax("message", 80); |
177 |
} |
178 |
|
179 |
|
180 |
function setLib(&$form, $maj) { |
181 |
//libelle des champs |
182 |
$form->setLib('regle',_('regle')); |
183 |
$form->setLib('sens',_('sens')); |
184 |
$form->setLib('ordre',_('ordre')); |
185 |
$form->setLib('controle',_('controle')); |
186 |
$form->setLib('id',_('id')); |
187 |
$form->setLib('champ',_('champ')); |
188 |
$form->setLib('operateur',_('operateur')); |
189 |
$form->setLib('valeur',_('valeur')); |
190 |
$form->setLib('message',_('message')); |
191 |
} |
192 |
/** |
193 |
* |
194 |
*/ |
195 |
function setSelect(&$form, $maj, &$dnu1 = null, $dnu2 = null) { |
196 |
|
197 |
// Inclusion du fichier de requêtes |
198 |
if (file_exists("../sql/".OM_DB_PHPTYPE."/".$this->table.".form.inc.php")) { |
199 |
include "../sql/".OM_DB_PHPTYPE."/".$this->table.".form.inc.php"; |
200 |
} elseif (file_exists("../sql/".OM_DB_PHPTYPE."/".$this->table.".form.inc")) { |
201 |
include "../sql/".OM_DB_PHPTYPE."/".$this->table.".form.inc"; |
202 |
} |
203 |
|
204 |
} |
205 |
|
206 |
|
207 |
//================================== |
208 |
// sous Formulaire |
209 |
//================================== |
210 |
|
211 |
|
212 |
function setValsousformulaire(&$form, $maj, $validation, $idxformulaire, $retourformulaire, $typeformulaire, &$dnu1 = null, $dnu2 = null) { |
213 |
$this->retourformulaire = $retourformulaire; |
214 |
$this->set_form_default_values($form, $maj, $validation); |
215 |
}// fin setValsousformulaire |
216 |
|
217 |
//================================== |
218 |
// cle secondaire |
219 |
//================================== |
220 |
|
221 |
|
222 |
} |
223 |
|
224 |
?> |