1 |
<?php |
<?php |
2 |
//$Id$ |
//$Id$ |
3 |
//gen openMairie le 30/11/2011 19:33 |
//gen openMairie le 28/03/2012 16:49 |
4 |
require_once (PATH_OPENMAIRIE."dbformdyn.class.php"); |
require_once ("../obj/om_dbform.class.php"); |
5 |
|
|
6 |
class dossier_gen extends dbForm { |
class dossier_gen extends om_dbform { |
7 |
var $table="dossier"; |
var $table="dossier"; |
8 |
var $clePrimaire="dossier"; |
var $clePrimaire="dossier"; |
9 |
var $typeCle="A"; |
var $typeCle="A"; |
10 |
var $retourformulaire; |
var $retourformulaire; |
11 |
|
|
12 |
function setvalF($val) { |
function setvalF($val) { |
13 |
//affectation valeur formulaire |
//affectation valeur formulaire |
14 |
$this->valF['dossier'] = $val['dossier']; |
$this->valF['dossier'] = $val['dossier']; |
15 |
$this->valF['nature'] = $val['nature']; |
$this->valF['nature'] = $val['nature']; |
16 |
$this->valF['annee'] = $val['annee']; |
$this->valF['annee'] = $val['annee']; |
17 |
$this->valF['etat'] = $val['etat']; |
$this->valF['etat'] = $val['etat']; |
18 |
$this->valF['types'] = $val['types']; |
$this->valF['types'] = $val['types']; |
19 |
$this->valF['objet_dossier'] = $val['objet_dossier']; |
$this->valF['objet_dossier'] = $val['objet_dossier']; |
20 |
$this->valF['instructeur'] = $val['instructeur']; |
$this->valF['instructeur'] = $val['instructeur']; |
21 |
if($val['date_demande']!=""){ |
if($val['date_demande']!=""){ |
22 |
$this->valF['date_demande'] = $this->dateDB($val['date_demande']); |
$this->valF['date_demande'] = $this->dateDB($val['date_demande']); |
23 |
} |
} |
24 |
if($val['date_depot']!=""){ |
if($val['date_depot']!=""){ |
25 |
$this->valF['date_depot'] = $this->dateDB($val['date_depot']); |
$this->valF['date_depot'] = $this->dateDB($val['date_depot']); |
26 |
} |
} |
27 |
if($val['date_complet']!=""){ |
if($val['date_complet']!=""){ |
28 |
$this->valF['date_complet'] = $this->dateDB($val['date_complet']); |
$this->valF['date_complet'] = $this->dateDB($val['date_complet']); |
29 |
} |
} |
30 |
if($val['date_rejet']!=""){ |
if($val['date_rejet']!=""){ |
31 |
$this->valF['date_rejet'] = $this->dateDB($val['date_rejet']); |
$this->valF['date_rejet'] = $this->dateDB($val['date_rejet']); |
32 |
} |
} |
33 |
if($val['date_notification_delai']!=""){ |
if($val['date_notification_delai']!=""){ |
34 |
$this->valF['date_notification_delai'] = $this->dateDB($val['date_notification_delai']); |
$this->valF['date_notification_delai'] = $this->dateDB($val['date_notification_delai']); |
35 |
} |
} |
36 |
$this->valF['delai'] = $val['delai']; |
$this->valF['delai'] = $val['delai']; |
37 |
if($val['date_limite']!=""){ |
if($val['date_limite']!=""){ |
38 |
$this->valF['date_limite'] = $this->dateDB($val['date_limite']); |
$this->valF['date_limite'] = $this->dateDB($val['date_limite']); |
39 |
} |
} |
40 |
$this->valF['accord_tacite'] = $val['accord_tacite']; |
$this->valF['accord_tacite'] = $val['accord_tacite']; |
41 |
if($val['date_decision']!=""){ |
if($val['date_decision']!=""){ |
42 |
$this->valF['date_decision'] = $this->dateDB($val['date_decision']); |
$this->valF['date_decision'] = $this->dateDB($val['date_decision']); |
43 |
} |
} |
44 |
$this->valF['avis'] = $val['avis']; |
$this->valF['avis'] = $val['avis']; |
45 |
if($val['date_validite']!=""){ |
if($val['date_validite']!=""){ |
46 |
$this->valF['date_validite'] = $this->dateDB($val['date_validite']); |
$this->valF['date_validite'] = $this->dateDB($val['date_validite']); |
47 |
} |
} |
48 |
if($val['date_chantier']!=""){ |
if($val['date_chantier']!=""){ |
49 |
$this->valF['date_chantier'] = $this->dateDB($val['date_chantier']); |
$this->valF['date_chantier'] = $this->dateDB($val['date_chantier']); |
50 |
} |
} |
51 |
if($val['date_achevement']!=""){ |
if($val['date_achevement']!=""){ |
52 |
$this->valF['date_achevement'] = $this->dateDB($val['date_achevement']); |
$this->valF['date_achevement'] = $this->dateDB($val['date_achevement']); |
53 |
} |
} |
54 |
if($val['date_conformite']!=""){ |
if($val['date_conformite']!=""){ |
55 |
$this->valF['date_conformite'] = $this->dateDB($val['date_conformite']); |
$this->valF['date_conformite'] = $this->dateDB($val['date_conformite']); |
56 |
} |
} |
57 |
$this->valF['demandeur_civilite'] = $val['demandeur_civilite']; |
$this->valF['demandeur_civilite'] = $val['demandeur_civilite']; |
58 |
$this->valF['demandeur_nom'] = $val['demandeur_nom']; |
$this->valF['demandeur_nom'] = $val['demandeur_nom']; |
59 |
$this->valF['demandeur_societe'] = $val['demandeur_societe']; |
$this->valF['demandeur_societe'] = $val['demandeur_societe']; |
60 |
$this->valF['demandeur_adresse'] = $val['demandeur_adresse']; |
$this->valF['demandeur_adresse'] = $val['demandeur_adresse']; |
61 |
$this->valF['demandeur_cp'] = $val['demandeur_cp']; |
$this->valF['demandeur_cp'] = $val['demandeur_cp']; |
62 |
$this->valF['demandeur_ville'] = $val['demandeur_ville']; |
$this->valF['demandeur_ville'] = $val['demandeur_ville']; |
63 |
$this->valF['demandeur_pays'] = $val['demandeur_pays']; |
$this->valF['demandeur_pays'] = $val['demandeur_pays']; |
64 |
$this->valF['demandeur_telephone'] = $val['demandeur_telephone']; |
$this->valF['demandeur_telephone'] = $val['demandeur_telephone']; |
65 |
$this->valF['demandeur_email'] = $val['demandeur_email']; |
$this->valF['demandeur_email'] = $val['demandeur_email']; |
66 |
$this->valF['demandeur_categorie'] = $val['demandeur_categorie']; |
$this->valF['demandeur_categorie'] = $val['demandeur_categorie']; |
67 |
$this->valF['delegataire'] = $val['delegataire']; |
$this->valF['delegataire'] = $val['delegataire']; |
68 |
$this->valF['delegataire_civilite'] = $val['delegataire_civilite']; |
$this->valF['delegataire_civilite'] = $val['delegataire_civilite']; |
69 |
$this->valF['delegataire_nom'] = $val['delegataire_nom']; |
$this->valF['delegataire_nom'] = $val['delegataire_nom']; |
70 |
$this->valF['delegataire_societe'] = $val['delegataire_societe']; |
$this->valF['delegataire_societe'] = $val['delegataire_societe']; |
71 |
$this->valF['delegataire_adresse'] = $val['delegataire_adresse']; |
$this->valF['delegataire_adresse'] = $val['delegataire_adresse']; |
72 |
$this->valF['delegataire_cp'] = $val['delegataire_cp']; |
$this->valF['delegataire_cp'] = $val['delegataire_cp']; |
73 |
$this->valF['delegataire_ville'] = $val['delegataire_ville']; |
$this->valF['delegataire_ville'] = $val['delegataire_ville']; |
74 |
$this->valF['delegataire_pays'] = $val['delegataire_pays']; |
$this->valF['delegataire_pays'] = $val['delegataire_pays']; |
75 |
$this->valF['delegataire_telephone'] = $val['delegataire_telephone']; |
$this->valF['delegataire_telephone'] = $val['delegataire_telephone']; |
76 |
$this->valF['delegataire_email'] = $val['delegataire_email']; |
$this->valF['delegataire_email'] = $val['delegataire_email']; |
77 |
$this->valF['terrain_numero'] = $val['terrain_numero']; |
$this->valF['terrain_numero'] = $val['terrain_numero']; |
78 |
$this->valF['terrain_numero_complement'] = $val['terrain_numero_complement']; |
$this->valF['terrain_numero_complement'] = $val['terrain_numero_complement']; |
79 |
$this->valF['terrain_adresse'] = $val['terrain_adresse']; |
$this->valF['terrain_adresse'] = $val['terrain_adresse']; |
80 |
$this->valF['terrain_adresse_complement'] = $val['terrain_adresse_complement']; |
$this->valF['terrain_adresse_complement'] = $val['terrain_adresse_complement']; |
81 |
$this->valF['terrain_cp'] = $val['terrain_cp']; |
$this->valF['terrain_cp'] = $val['terrain_cp']; |
82 |
$this->valF['terrain_ville'] = $val['terrain_ville']; |
$this->valF['terrain_ville'] = $val['terrain_ville']; |
83 |
$this->valF['architecte'] = $val['architecte']; |
$this->valF['architecte'] = $val['architecte']; |
84 |
$this->valF['terrain_surface'] = $val['terrain_surface']; |
$this->valF['terrain_surface'] = $val['terrain_surface']; |
85 |
$this->valF['terrain_surface_calcul'] = $val['terrain_surface_calcul']; |
$this->valF['terrain_surface_calcul'] = $val['terrain_surface_calcul']; |
86 |
$this->valF['rivoli'] = $val['rivoli']; |
$this->valF['rivoli'] = $val['rivoli']; |
87 |
$this->valF['travaux'] = $val['travaux']; |
$this->valF['travaux'] = $val['travaux']; |
88 |
$this->valF['parcelle'] = $val['parcelle']; |
$this->valF['parcelle'] = $val['parcelle']; |
89 |
$this->valF['pos'] = $val['pos']; |
$this->valF['pos'] = $val['pos']; |
90 |
$this->valF['sig'] = $val['sig']; |
$this->valF['sig'] = $val['sig']; |
91 |
$this->valF['batiment_nombre'] = $val['batiment_nombre']; |
$this->valF['batiment_nombre'] = $val['batiment_nombre']; |
92 |
$this->valF['logement_nombre'] = $val['logement_nombre']; |
$this->valF['logement_nombre'] = $val['logement_nombre']; |
93 |
$this->valF['shon'] = $val['shon']; |
$this->valF['shon'] = $val['shon']; |
94 |
$this->valF['shon_calcul'] = $val['shon_calcul']; |
$this->valF['shon_calcul'] = $val['shon_calcul']; |
95 |
$this->valF['shob'] = $val['shob']; |
$this->valF['shob'] = $val['shob']; |
96 |
$this->valF['lot'] = $val['lot']; |
$this->valF['lot'] = $val['lot']; |
97 |
$this->valF['hauteur'] = $val['hauteur']; |
$this->valF['hauteur'] = $val['hauteur']; |
98 |
$this->valF['piece_nombre'] = $val['piece_nombre']; |
$this->valF['piece_nombre'] = $val['piece_nombre']; |
99 |
$this->valF['amenagement'] = $val['amenagement']; |
$this->valF['amenagement'] = $val['amenagement']; |
100 |
$this->valF['parcelle_lot'] = $val['parcelle_lot']; |
$this->valF['parcelle_lot'] = $val['parcelle_lot']; |
101 |
$this->valF['parcelle_lot_lotissement'] = $val['parcelle_lot_lotissement']; |
$this->valF['parcelle_lot_lotissement'] = $val['parcelle_lot_lotissement']; |
102 |
$this->valF['description'] = $val['description']; |
$this->valF['description'] = $val['description']; |
103 |
$this->valF['temp1'] = $val['temp1']; |
$this->valF['temp1'] = $val['temp1']; |
104 |
$this->valF['temp2'] = $val['temp2']; |
$this->valF['temp2'] = $val['temp2']; |
105 |
$this->valF['temp3'] = $val['temp3']; |
$this->valF['temp3'] = $val['temp3']; |
106 |
$this->valF['temp4'] = $val['temp4']; |
$this->valF['temp4'] = $val['temp4']; |
107 |
$this->valF['temp5'] = $val['temp5']; |
$this->valF['temp5'] = $val['temp5']; |
108 |
$this->valF['servitude'] = $val['servitude']; |
$this->valF['servitude'] = $val['servitude']; |
109 |
$this->valF['geom'] = $val['geom']; |
$this->valF['geom'] = $val['geom']; |
110 |
} |
$this->valF['travaux_complement'] = $val['travaux_complement']; |
111 |
|
} |
112 |
//==================================== |
|
113 |
// verifier avant validation [verify] |
//==================================== |
114 |
//===================================== |
// verifier avant validation [verify] |
115 |
|
//===================================== |
116 |
/** |
/** |
117 |
* Methode verifier |
* Methode verifier |
118 |
*/ |
*/ |
127 |
} |
} |
128 |
|
|
129 |
|
|
130 |
//========================== |
//========================== |
131 |
// Formulaire [form] |
// Formulaire [form] |
132 |
//========================== |
//========================== |
133 |
|
|
134 |
function setType(&$form,$maj) { |
function setType(&$form,$maj) { |
135 |
//type |
//type |
136 |
if ($maj==0){ //ajout |
if ($maj==0){ //ajout |
137 |
$form->setType('dossier','text'); |
$form->setType('dossier','text'); |
138 |
if($this->retourformulaire=='nature') |
if($this->retourformulaire=='nature') |
139 |
$form->setType('nature','hiddenstatic'); |
$form->setType('nature','hiddenstatic'); |
140 |
else |
else |
141 |
$form->setType('nature','select'); |
$form->setType('nature','select'); |
142 |
$form->setType('annee','text'); |
$form->setType('annee','text'); |
143 |
if($this->retourformulaire=='etat') |
if($this->retourformulaire=='etat') |
144 |
$form->setType('etat','hiddenstatic'); |
$form->setType('etat','hiddenstatic'); |
145 |
else |
else |
146 |
$form->setType('etat','select'); |
$form->setType('etat','select'); |
147 |
$form->setType('types','text'); |
$form->setType('types','text'); |
148 |
$form->setType('objet_dossier','text'); |
$form->setType('objet_dossier','text'); |
149 |
$form->setType('instructeur','text'); |
$form->setType('instructeur','text'); |
150 |
if($this->retourformulaire=='') |
if($this->retourformulaire=='') |
151 |
$form->setType('date_demande','date'); |
$form->setType('date_demande','date'); |
152 |
else |
else |
153 |
$form->setType('date_demande','date2'); |
$form->setType('date_demande','date2'); |
154 |
if($this->retourformulaire=='') |
if($this->retourformulaire=='') |
155 |
$form->setType('date_depot','date'); |
$form->setType('date_depot','date'); |
156 |
else |
else |
157 |
$form->setType('date_depot','date2'); |
$form->setType('date_depot','date2'); |
158 |
if($this->retourformulaire=='') |
if($this->retourformulaire=='') |
159 |
$form->setType('date_complet','date'); |
$form->setType('date_complet','date'); |
160 |
else |
else |
161 |
$form->setType('date_complet','date2'); |
$form->setType('date_complet','date2'); |
162 |
if($this->retourformulaire=='') |
if($this->retourformulaire=='') |
163 |
$form->setType('date_rejet','date'); |
$form->setType('date_rejet','date'); |
164 |
else |
else |
165 |
$form->setType('date_rejet','date2'); |
$form->setType('date_rejet','date2'); |
166 |
if($this->retourformulaire=='') |
if($this->retourformulaire=='') |
167 |
$form->setType('date_notification_delai','date'); |
$form->setType('date_notification_delai','date'); |
168 |
else |
else |
169 |
$form->setType('date_notification_delai','date2'); |
$form->setType('date_notification_delai','date2'); |
170 |
$form->setType('delai','text'); |
$form->setType('delai','text'); |
171 |
if($this->retourformulaire=='') |
if($this->retourformulaire=='') |
172 |
$form->setType('date_limite','date'); |
$form->setType('date_limite','date'); |
173 |
else |
else |
174 |
$form->setType('date_limite','date2'); |
$form->setType('date_limite','date2'); |
175 |
$form->setType('accord_tacite','text'); |
$form->setType('accord_tacite','text'); |
176 |
if($this->retourformulaire=='') |
if($this->retourformulaire=='') |
177 |
$form->setType('date_decision','date'); |
$form->setType('date_decision','date'); |
178 |
else |
else |
179 |
$form->setType('date_decision','date2'); |
$form->setType('date_decision','date2'); |
180 |
if($this->retourformulaire=='avis') |
if($this->retourformulaire=='avis') |
181 |
$form->setType('avis','hiddenstatic'); |
$form->setType('avis','hiddenstatic'); |
182 |
else |
else |
183 |
$form->setType('avis','select'); |
$form->setType('avis','select'); |
184 |
if($this->retourformulaire=='') |
if($this->retourformulaire=='') |
185 |
$form->setType('date_validite','date'); |
$form->setType('date_validite','date'); |
186 |
else |
else |
187 |
$form->setType('date_validite','date2'); |
$form->setType('date_validite','date2'); |
188 |
if($this->retourformulaire=='') |
if($this->retourformulaire=='') |
189 |
$form->setType('date_chantier','date'); |
$form->setType('date_chantier','date'); |
190 |
else |
else |
191 |
$form->setType('date_chantier','date2'); |
$form->setType('date_chantier','date2'); |
192 |
if($this->retourformulaire=='') |
if($this->retourformulaire=='') |
193 |
$form->setType('date_achevement','date'); |
$form->setType('date_achevement','date'); |
194 |
else |
else |
195 |
$form->setType('date_achevement','date2'); |
$form->setType('date_achevement','date2'); |
196 |
if($this->retourformulaire=='') |
if($this->retourformulaire=='') |
197 |
$form->setType('date_conformite','date'); |
$form->setType('date_conformite','date'); |
198 |
else |
else |
199 |
$form->setType('date_conformite','date2'); |
$form->setType('date_conformite','date2'); |
200 |
$form->setType('demandeur_civilite','text'); |
$form->setType('demandeur_civilite','text'); |
201 |
$form->setType('demandeur_nom','text'); |
$form->setType('demandeur_nom','text'); |
202 |
$form->setType('demandeur_societe','text'); |
$form->setType('demandeur_societe','text'); |
203 |
$form->setType('demandeur_adresse','text'); |
$form->setType('demandeur_adresse','text'); |
204 |
$form->setType('demandeur_cp','text'); |
$form->setType('demandeur_cp','text'); |
205 |
$form->setType('demandeur_ville','text'); |
$form->setType('demandeur_ville','text'); |
206 |
$form->setType('demandeur_pays','text'); |
$form->setType('demandeur_pays','text'); |
207 |
$form->setType('demandeur_telephone','text'); |
$form->setType('demandeur_telephone','text'); |
208 |
$form->setType('demandeur_email','text'); |
$form->setType('demandeur_email','text'); |
209 |
$form->setType('demandeur_categorie','text'); |
$form->setType('demandeur_categorie','text'); |
210 |
$form->setType('delegataire','text'); |
$form->setType('delegataire','text'); |
211 |
$form->setType('delegataire_civilite','text'); |
$form->setType('delegataire_civilite','text'); |
212 |
$form->setType('delegataire_nom','text'); |
$form->setType('delegataire_nom','text'); |
213 |
$form->setType('delegataire_societe','text'); |
$form->setType('delegataire_societe','text'); |
214 |
$form->setType('delegataire_adresse','text'); |
$form->setType('delegataire_adresse','text'); |
215 |
$form->setType('delegataire_cp','text'); |
$form->setType('delegataire_cp','text'); |
216 |
$form->setType('delegataire_ville','text'); |
$form->setType('delegataire_ville','text'); |
217 |
$form->setType('delegataire_pays','text'); |
$form->setType('delegataire_pays','text'); |
218 |
$form->setType('delegataire_telephone','text'); |
$form->setType('delegataire_telephone','text'); |
219 |
$form->setType('delegataire_email','text'); |
$form->setType('delegataire_email','text'); |
220 |
$form->setType('terrain_numero','text'); |
$form->setType('terrain_numero','text'); |
221 |
$form->setType('terrain_numero_complement','text'); |
$form->setType('terrain_numero_complement','text'); |
222 |
$form->setType('terrain_adresse','text'); |
$form->setType('terrain_adresse','text'); |
223 |
$form->setType('terrain_adresse_complement','text'); |
$form->setType('terrain_adresse_complement','text'); |
224 |
$form->setType('terrain_cp','text'); |
$form->setType('terrain_cp','text'); |
225 |
$form->setType('terrain_ville','text'); |
$form->setType('terrain_ville','text'); |
226 |
if($this->retourformulaire=='architecte') |
if($this->retourformulaire=='architecte') |
227 |
$form->setType('architecte','hiddenstatic'); |
$form->setType('architecte','hiddenstatic'); |
228 |
else |
else |
229 |
$form->setType('architecte','select'); |
$form->setType('architecte','select'); |
230 |
$form->setType('terrain_surface','text'); |
$form->setType('terrain_surface','text'); |
231 |
$form->setType('terrain_surface_calcul','text'); |
$form->setType('terrain_surface_calcul','text'); |
232 |
if($this->retourformulaire=='rivoli') |
if($this->retourformulaire=='rivoli') |
233 |
$form->setType('rivoli','hiddenstatic'); |
$form->setType('rivoli','hiddenstatic'); |
234 |
else |
else |
235 |
$form->setType('rivoli','select'); |
$form->setType('rivoli','select'); |
236 |
if($this->retourformulaire=='travaux') |
if($this->retourformulaire=='travaux') |
237 |
$form->setType('travaux','hiddenstatic'); |
$form->setType('travaux','hiddenstatic'); |
238 |
else |
else |
239 |
$form->setType('travaux','select'); |
$form->setType('travaux','select'); |
240 |
if($this->retourformulaire=='parcelle') |
if($this->retourformulaire=='parcelle') |
241 |
$form->setType('parcelle','hiddenstatic'); |
$form->setType('parcelle','hiddenstatic'); |
242 |
else |
else |
243 |
$form->setType('parcelle','select'); |
$form->setType('parcelle','select'); |
244 |
if($this->retourformulaire=='pos') |
if($this->retourformulaire=='pos') |
245 |
$form->setType('pos','hiddenstatic'); |
$form->setType('pos','hiddenstatic'); |
246 |
else |
else |
247 |
$form->setType('pos','select'); |
$form->setType('pos','select'); |
248 |
$form->setType('sig','text'); |
$form->setType('sig','text'); |
249 |
$form->setType('batiment_nombre','text'); |
$form->setType('batiment_nombre','text'); |
250 |
$form->setType('logement_nombre','text'); |
$form->setType('logement_nombre','text'); |
251 |
$form->setType('shon','text'); |
$form->setType('shon','text'); |
252 |
$form->setType('shon_calcul','text'); |
$form->setType('shon_calcul','text'); |
253 |
$form->setType('shob','text'); |
$form->setType('shob','text'); |
254 |
$form->setType('lot','text'); |
$form->setType('lot','text'); |
255 |
$form->setType('hauteur','text'); |
$form->setType('hauteur','text'); |
256 |
$form->setType('piece_nombre','text'); |
$form->setType('piece_nombre','text'); |
257 |
$form->setType('amenagement','text'); |
$form->setType('amenagement','text'); |
258 |
if($this->retourformulaire=='parcelle_lot') |
if($this->retourformulaire=='parcelle_lot') |
259 |
$form->setType('parcelle_lot','hiddenstatic'); |
$form->setType('parcelle_lot','hiddenstatic'); |
260 |
else |
else |
261 |
$form->setType('parcelle_lot','select'); |
$form->setType('parcelle_lot','select'); |
262 |
$form->setType('parcelle_lot_lotissement','text'); |
$form->setType('parcelle_lot_lotissement','text'); |
263 |
$form->setType('description','textarea'); |
$form->setType('description','textarea'); |
264 |
$form->setType('temp1','text'); |
$form->setType('temp1','text'); |
265 |
$form->setType('temp2','text'); |
$form->setType('temp2','text'); |
266 |
$form->setType('temp3','text'); |
$form->setType('temp3','text'); |
267 |
$form->setType('temp4','text'); |
$form->setType('temp4','text'); |
268 |
$form->setType('temp5','text'); |
$form->setType('temp5','text'); |
269 |
$form->setType('servitude','textarea'); |
$form->setType('servitude','textarea'); |
270 |
$form->setType('geom','text'); |
$form->setType('geom','text'); |
271 |
}// fin ajout |
$form->setType('travaux_complement','text'); |
272 |
if ($maj==1){ //modifier |
}// fin ajout |
273 |
$form->setType('dossier','hiddenstatic'); |
if ($maj==1){ //modifier |
274 |
if($this->retourformulaire=='nature') |
$form->setType('dossier','hiddenstatic'); |
275 |
$form->setType('nature','hiddenstatic'); |
if($this->retourformulaire=='nature') |
276 |
else |
$form->setType('nature','hiddenstatic'); |
277 |
$form->setType('nature','select'); |
else |
278 |
$form->setType('annee','text'); |
$form->setType('nature','select'); |
279 |
if($this->retourformulaire=='etat') |
$form->setType('annee','text'); |
280 |
$form->setType('etat','hiddenstatic'); |
if($this->retourformulaire=='etat') |
281 |
else |
$form->setType('etat','hiddenstatic'); |
282 |
$form->setType('etat','select'); |
else |
283 |
$form->setType('types','text'); |
$form->setType('etat','select'); |
284 |
$form->setType('objet_dossier','text'); |
$form->setType('types','text'); |
285 |
$form->setType('instructeur','text'); |
$form->setType('objet_dossier','text'); |
286 |
if($this->retourformulaire=='') |
$form->setType('instructeur','text'); |
287 |
$form->setType('date_demande','date'); |
if($this->retourformulaire=='') |
288 |
else |
$form->setType('date_demande','date'); |
289 |
$form->setType('date_demande','date2'); |
else |
290 |
if($this->retourformulaire=='') |
$form->setType('date_demande','date2'); |
291 |
$form->setType('date_depot','date'); |
if($this->retourformulaire=='') |
292 |
else |
$form->setType('date_depot','date'); |
293 |
$form->setType('date_depot','date2'); |
else |
294 |
if($this->retourformulaire=='') |
$form->setType('date_depot','date2'); |
295 |
$form->setType('date_complet','date'); |
if($this->retourformulaire=='') |
296 |
else |
$form->setType('date_complet','date'); |
297 |
$form->setType('date_complet','date2'); |
else |
298 |
if($this->retourformulaire=='') |
$form->setType('date_complet','date2'); |
299 |
$form->setType('date_rejet','date'); |
if($this->retourformulaire=='') |
300 |
else |
$form->setType('date_rejet','date'); |
301 |
$form->setType('date_rejet','date2'); |
else |
302 |
if($this->retourformulaire=='') |
$form->setType('date_rejet','date2'); |
303 |
$form->setType('date_notification_delai','date'); |
if($this->retourformulaire=='') |
304 |
else |
$form->setType('date_notification_delai','date'); |
305 |
$form->setType('date_notification_delai','date2'); |
else |
306 |
$form->setType('delai','text'); |
$form->setType('date_notification_delai','date2'); |
307 |
if($this->retourformulaire=='') |
$form->setType('delai','text'); |
308 |
$form->setType('date_limite','date'); |
if($this->retourformulaire=='') |
309 |
else |
$form->setType('date_limite','date'); |
310 |
$form->setType('date_limite','date2'); |
else |
311 |
$form->setType('accord_tacite','text'); |
$form->setType('date_limite','date2'); |
312 |
if($this->retourformulaire=='') |
$form->setType('accord_tacite','text'); |
313 |
$form->setType('date_decision','date'); |
if($this->retourformulaire=='') |
314 |
else |
$form->setType('date_decision','date'); |
315 |
$form->setType('date_decision','date2'); |
else |
316 |
if($this->retourformulaire=='avis') |
$form->setType('date_decision','date2'); |
317 |
$form->setType('avis','hiddenstatic'); |
if($this->retourformulaire=='avis') |
318 |
else |
$form->setType('avis','hiddenstatic'); |
319 |
$form->setType('avis','select'); |
else |
320 |
if($this->retourformulaire=='') |
$form->setType('avis','select'); |
321 |
$form->setType('date_validite','date'); |
if($this->retourformulaire=='') |
322 |
else |
$form->setType('date_validite','date'); |
323 |
$form->setType('date_validite','date2'); |
else |
324 |
if($this->retourformulaire=='') |
$form->setType('date_validite','date2'); |
325 |
$form->setType('date_chantier','date'); |
if($this->retourformulaire=='') |
326 |
else |
$form->setType('date_chantier','date'); |
327 |
$form->setType('date_chantier','date2'); |
else |
328 |
if($this->retourformulaire=='') |
$form->setType('date_chantier','date2'); |
329 |
$form->setType('date_achevement','date'); |
if($this->retourformulaire=='') |
330 |
else |
$form->setType('date_achevement','date'); |
331 |
$form->setType('date_achevement','date2'); |
else |
332 |
if($this->retourformulaire=='') |
$form->setType('date_achevement','date2'); |
333 |
$form->setType('date_conformite','date'); |
if($this->retourformulaire=='') |
334 |
else |
$form->setType('date_conformite','date'); |
335 |
$form->setType('date_conformite','date2'); |
else |
336 |
$form->setType('demandeur_civilite','text'); |
$form->setType('date_conformite','date2'); |
337 |
$form->setType('demandeur_nom','text'); |
$form->setType('demandeur_civilite','text'); |
338 |
$form->setType('demandeur_societe','text'); |
$form->setType('demandeur_nom','text'); |
339 |
$form->setType('demandeur_adresse','text'); |
$form->setType('demandeur_societe','text'); |
340 |
$form->setType('demandeur_cp','text'); |
$form->setType('demandeur_adresse','text'); |
341 |
$form->setType('demandeur_ville','text'); |
$form->setType('demandeur_cp','text'); |
342 |
$form->setType('demandeur_pays','text'); |
$form->setType('demandeur_ville','text'); |
343 |
$form->setType('demandeur_telephone','text'); |
$form->setType('demandeur_pays','text'); |
344 |
$form->setType('demandeur_email','text'); |
$form->setType('demandeur_telephone','text'); |
345 |
$form->setType('demandeur_categorie','text'); |
$form->setType('demandeur_email','text'); |
346 |
$form->setType('delegataire','text'); |
$form->setType('demandeur_categorie','text'); |
347 |
$form->setType('delegataire_civilite','text'); |
$form->setType('delegataire','text'); |
348 |
$form->setType('delegataire_nom','text'); |
$form->setType('delegataire_civilite','text'); |
349 |
$form->setType('delegataire_societe','text'); |
$form->setType('delegataire_nom','text'); |
350 |
$form->setType('delegataire_adresse','text'); |
$form->setType('delegataire_societe','text'); |
351 |
$form->setType('delegataire_cp','text'); |
$form->setType('delegataire_adresse','text'); |
352 |
$form->setType('delegataire_ville','text'); |
$form->setType('delegataire_cp','text'); |
353 |
$form->setType('delegataire_pays','text'); |
$form->setType('delegataire_ville','text'); |
354 |
$form->setType('delegataire_telephone','text'); |
$form->setType('delegataire_pays','text'); |
355 |
$form->setType('delegataire_email','text'); |
$form->setType('delegataire_telephone','text'); |
356 |
$form->setType('terrain_numero','text'); |
$form->setType('delegataire_email','text'); |
357 |
$form->setType('terrain_numero_complement','text'); |
$form->setType('terrain_numero','text'); |
358 |
$form->setType('terrain_adresse','text'); |
$form->setType('terrain_numero_complement','text'); |
359 |
$form->setType('terrain_adresse_complement','text'); |
$form->setType('terrain_adresse','text'); |
360 |
$form->setType('terrain_cp','text'); |
$form->setType('terrain_adresse_complement','text'); |
361 |
$form->setType('terrain_ville','text'); |
$form->setType('terrain_cp','text'); |
362 |
if($this->retourformulaire=='architecte') |
$form->setType('terrain_ville','text'); |
363 |
$form->setType('architecte','hiddenstatic'); |
if($this->retourformulaire=='architecte') |
364 |
else |
$form->setType('architecte','hiddenstatic'); |
365 |
$form->setType('architecte','select'); |
else |
366 |
$form->setType('terrain_surface','text'); |
$form->setType('architecte','select'); |
367 |
$form->setType('terrain_surface_calcul','text'); |
$form->setType('terrain_surface','text'); |
368 |
if($this->retourformulaire=='rivoli') |
$form->setType('terrain_surface_calcul','text'); |
369 |
$form->setType('rivoli','hiddenstatic'); |
if($this->retourformulaire=='rivoli') |
370 |
else |
$form->setType('rivoli','hiddenstatic'); |
371 |
$form->setType('rivoli','select'); |
else |
372 |
if($this->retourformulaire=='travaux') |
$form->setType('rivoli','select'); |
373 |
$form->setType('travaux','hiddenstatic'); |
if($this->retourformulaire=='travaux') |
374 |
else |
$form->setType('travaux','hiddenstatic'); |
375 |
$form->setType('travaux','select'); |
else |
376 |
if($this->retourformulaire=='parcelle') |
$form->setType('travaux','select'); |
377 |
$form->setType('parcelle','hiddenstatic'); |
if($this->retourformulaire=='parcelle') |
378 |
else |
$form->setType('parcelle','hiddenstatic'); |
379 |
$form->setType('parcelle','select'); |
else |
380 |
if($this->retourformulaire=='pos') |
$form->setType('parcelle','select'); |
381 |
$form->setType('pos','hiddenstatic'); |
if($this->retourformulaire=='pos') |
382 |
else |
$form->setType('pos','hiddenstatic'); |
383 |
$form->setType('pos','select'); |
else |
384 |
$form->setType('sig','text'); |
$form->setType('pos','select'); |
385 |
$form->setType('batiment_nombre','text'); |
$form->setType('sig','text'); |
386 |
$form->setType('logement_nombre','text'); |
$form->setType('batiment_nombre','text'); |
387 |
$form->setType('shon','text'); |
$form->setType('logement_nombre','text'); |
388 |
$form->setType('shon_calcul','text'); |
$form->setType('shon','text'); |
389 |
$form->setType('shob','text'); |
$form->setType('shon_calcul','text'); |
390 |
$form->setType('lot','text'); |
$form->setType('shob','text'); |
391 |
$form->setType('hauteur','text'); |
$form->setType('lot','text'); |
392 |
$form->setType('piece_nombre','text'); |
$form->setType('hauteur','text'); |
393 |
$form->setType('amenagement','text'); |
$form->setType('piece_nombre','text'); |
394 |
if($this->retourformulaire=='parcelle_lot') |
$form->setType('amenagement','text'); |
395 |
$form->setType('parcelle_lot','hiddenstatic'); |
if($this->retourformulaire=='parcelle_lot') |
396 |
else |
$form->setType('parcelle_lot','hiddenstatic'); |
397 |
$form->setType('parcelle_lot','select'); |
else |
398 |
$form->setType('parcelle_lot_lotissement','text'); |
$form->setType('parcelle_lot','select'); |
399 |
$form->setType('description','textarea'); |
$form->setType('parcelle_lot_lotissement','text'); |
400 |
$form->setType('temp1','text'); |
$form->setType('description','textarea'); |
401 |
$form->setType('temp2','text'); |
$form->setType('temp1','text'); |
402 |
$form->setType('temp3','text'); |
$form->setType('temp2','text'); |
403 |
$form->setType('temp4','text'); |
$form->setType('temp3','text'); |
404 |
$form->setType('temp5','text'); |
$form->setType('temp4','text'); |
405 |
$form->setType('servitude','textarea'); |
$form->setType('temp5','text'); |
406 |
$form->setType('geom','text'); |
$form->setType('servitude','textarea'); |
407 |
}// fin modifier |
$form->setType('geom','text'); |
408 |
if ($maj==2){ //supprimer |
$form->setType('travaux_complement','text'); |
409 |
$form->setType('dossier','hiddenstatic'); |
}// fin modifier |
410 |
$form->setType('nature','hiddenstatic'); |
if ($maj==2){ //supprimer |
411 |
$form->setType('annee','hiddenstatic'); |
$form->setType('dossier','hiddenstatic'); |
412 |
$form->setType('etat','hiddenstatic'); |
$form->setType('nature','hiddenstatic'); |
413 |
$form->setType('types','hiddenstatic'); |
$form->setType('annee','hiddenstatic'); |
414 |
$form->setType('objet_dossier','hiddenstatic'); |
$form->setType('etat','hiddenstatic'); |
415 |
$form->setType('instructeur','hiddenstatic'); |
$form->setType('types','hiddenstatic'); |
416 |
$form->setType('date_demande','hiddenstatic'); |
$form->setType('objet_dossier','hiddenstatic'); |
417 |
$form->setType('date_depot','hiddenstatic'); |
$form->setType('instructeur','hiddenstatic'); |
418 |
$form->setType('date_complet','hiddenstatic'); |
$form->setType('date_demande','hiddenstatic'); |
419 |
$form->setType('date_rejet','hiddenstatic'); |
$form->setType('date_depot','hiddenstatic'); |
420 |
$form->setType('date_notification_delai','hiddenstatic'); |
$form->setType('date_complet','hiddenstatic'); |
421 |
$form->setType('delai','hiddenstatic'); |
$form->setType('date_rejet','hiddenstatic'); |
422 |
$form->setType('date_limite','hiddenstatic'); |
$form->setType('date_notification_delai','hiddenstatic'); |
423 |
$form->setType('accord_tacite','hiddenstatic'); |
$form->setType('delai','hiddenstatic'); |
424 |
$form->setType('date_decision','hiddenstatic'); |
$form->setType('date_limite','hiddenstatic'); |
425 |
$form->setType('avis','hiddenstatic'); |
$form->setType('accord_tacite','hiddenstatic'); |
426 |
$form->setType('date_validite','hiddenstatic'); |
$form->setType('date_decision','hiddenstatic'); |
427 |
$form->setType('date_chantier','hiddenstatic'); |
$form->setType('avis','hiddenstatic'); |
428 |
$form->setType('date_achevement','hiddenstatic'); |
$form->setType('date_validite','hiddenstatic'); |
429 |
$form->setType('date_conformite','hiddenstatic'); |
$form->setType('date_chantier','hiddenstatic'); |
430 |
$form->setType('demandeur_civilite','hiddenstatic'); |
$form->setType('date_achevement','hiddenstatic'); |
431 |
$form->setType('demandeur_nom','hiddenstatic'); |
$form->setType('date_conformite','hiddenstatic'); |
432 |
$form->setType('demandeur_societe','hiddenstatic'); |
$form->setType('demandeur_civilite','hiddenstatic'); |
433 |
$form->setType('demandeur_adresse','hiddenstatic'); |
$form->setType('demandeur_nom','hiddenstatic'); |
434 |
$form->setType('demandeur_cp','hiddenstatic'); |
$form->setType('demandeur_societe','hiddenstatic'); |
435 |
$form->setType('demandeur_ville','hiddenstatic'); |
$form->setType('demandeur_adresse','hiddenstatic'); |
436 |
$form->setType('demandeur_pays','hiddenstatic'); |
$form->setType('demandeur_cp','hiddenstatic'); |
437 |
$form->setType('demandeur_telephone','hiddenstatic'); |
$form->setType('demandeur_ville','hiddenstatic'); |
438 |
$form->setType('demandeur_email','hiddenstatic'); |
$form->setType('demandeur_pays','hiddenstatic'); |
439 |
$form->setType('demandeur_categorie','hiddenstatic'); |
$form->setType('demandeur_telephone','hiddenstatic'); |
440 |
$form->setType('delegataire','hiddenstatic'); |
$form->setType('demandeur_email','hiddenstatic'); |
441 |
$form->setType('delegataire_civilite','hiddenstatic'); |
$form->setType('demandeur_categorie','hiddenstatic'); |
442 |
$form->setType('delegataire_nom','hiddenstatic'); |
$form->setType('delegataire','hiddenstatic'); |
443 |
$form->setType('delegataire_societe','hiddenstatic'); |
$form->setType('delegataire_civilite','hiddenstatic'); |
444 |
$form->setType('delegataire_adresse','hiddenstatic'); |
$form->setType('delegataire_nom','hiddenstatic'); |
445 |
$form->setType('delegataire_cp','hiddenstatic'); |
$form->setType('delegataire_societe','hiddenstatic'); |
446 |
$form->setType('delegataire_ville','hiddenstatic'); |
$form->setType('delegataire_adresse','hiddenstatic'); |
447 |
$form->setType('delegataire_pays','hiddenstatic'); |
$form->setType('delegataire_cp','hiddenstatic'); |
448 |
$form->setType('delegataire_telephone','hiddenstatic'); |
$form->setType('delegataire_ville','hiddenstatic'); |
449 |
$form->setType('delegataire_email','hiddenstatic'); |
$form->setType('delegataire_pays','hiddenstatic'); |
450 |
$form->setType('terrain_numero','hiddenstatic'); |
$form->setType('delegataire_telephone','hiddenstatic'); |
451 |
$form->setType('terrain_numero_complement','hiddenstatic'); |
$form->setType('delegataire_email','hiddenstatic'); |
452 |
$form->setType('terrain_adresse','hiddenstatic'); |
$form->setType('terrain_numero','hiddenstatic'); |
453 |
$form->setType('terrain_adresse_complement','hiddenstatic'); |
$form->setType('terrain_numero_complement','hiddenstatic'); |
454 |
$form->setType('terrain_cp','hiddenstatic'); |
$form->setType('terrain_adresse','hiddenstatic'); |
455 |
$form->setType('terrain_ville','hiddenstatic'); |
$form->setType('terrain_adresse_complement','hiddenstatic'); |
456 |
$form->setType('architecte','hiddenstatic'); |
$form->setType('terrain_cp','hiddenstatic'); |
457 |
$form->setType('terrain_surface','hiddenstatic'); |
$form->setType('terrain_ville','hiddenstatic'); |
458 |
$form->setType('terrain_surface_calcul','hiddenstatic'); |
$form->setType('architecte','hiddenstatic'); |
459 |
$form->setType('rivoli','hiddenstatic'); |
$form->setType('terrain_surface','hiddenstatic'); |
460 |
$form->setType('travaux','hiddenstatic'); |
$form->setType('terrain_surface_calcul','hiddenstatic'); |
461 |
$form->setType('parcelle','hiddenstatic'); |
$form->setType('rivoli','hiddenstatic'); |
462 |
$form->setType('pos','hiddenstatic'); |
$form->setType('travaux','hiddenstatic'); |
463 |
$form->setType('sig','hiddenstatic'); |
$form->setType('parcelle','hiddenstatic'); |
464 |
$form->setType('batiment_nombre','hiddenstatic'); |
$form->setType('pos','hiddenstatic'); |
465 |
$form->setType('logement_nombre','hiddenstatic'); |
$form->setType('sig','hiddenstatic'); |
466 |
$form->setType('shon','hiddenstatic'); |
$form->setType('batiment_nombre','hiddenstatic'); |
467 |
$form->setType('shon_calcul','hiddenstatic'); |
$form->setType('logement_nombre','hiddenstatic'); |
468 |
$form->setType('shob','hiddenstatic'); |
$form->setType('shon','hiddenstatic'); |
469 |
$form->setType('lot','hiddenstatic'); |
$form->setType('shon_calcul','hiddenstatic'); |
470 |
$form->setType('hauteur','hiddenstatic'); |
$form->setType('shob','hiddenstatic'); |
471 |
$form->setType('piece_nombre','hiddenstatic'); |
$form->setType('lot','hiddenstatic'); |
472 |
$form->setType('amenagement','hiddenstatic'); |
$form->setType('hauteur','hiddenstatic'); |
473 |
$form->setType('parcelle_lot','hiddenstatic'); |
$form->setType('piece_nombre','hiddenstatic'); |
474 |
$form->setType('parcelle_lot_lotissement','hiddenstatic'); |
$form->setType('amenagement','hiddenstatic'); |
475 |
$form->setType('description','hiddenstatic'); |
$form->setType('parcelle_lot','hiddenstatic'); |
476 |
$form->setType('temp1','hiddenstatic'); |
$form->setType('parcelle_lot_lotissement','hiddenstatic'); |
477 |
$form->setType('temp2','hiddenstatic'); |
$form->setType('description','hiddenstatic'); |
478 |
$form->setType('temp3','hiddenstatic'); |
$form->setType('temp1','hiddenstatic'); |
479 |
$form->setType('temp4','hiddenstatic'); |
$form->setType('temp2','hiddenstatic'); |
480 |
$form->setType('temp5','hiddenstatic'); |
$form->setType('temp3','hiddenstatic'); |
481 |
$form->setType('servitude','hiddenstatic'); |
$form->setType('temp4','hiddenstatic'); |
482 |
$form->setType('geom','hiddenstatic'); |
$form->setType('temp5','hiddenstatic'); |
483 |
}//fin supprimer |
$form->setType('servitude','hiddenstatic'); |
484 |
} |
$form->setType('geom','hiddenstatic'); |
485 |
|
$form->setType('travaux_complement','hiddenstatic'); |
486 |
function setOnchange(&$form,$maj) { |
}//fin supprimer |
487 |
//javascript controle client |
} |
488 |
$form->setOnchange('instructeur','VerifNum(this)'); |
|
489 |
$form->setOnchange('date_demande','fdate(this)'); |
function setOnchange(&$form,$maj) { |
490 |
$form->setOnchange('date_depot','fdate(this)'); |
//javascript controle client |
491 |
$form->setOnchange('date_complet','fdate(this)'); |
$form->setOnchange('instructeur','VerifNum(this)'); |
492 |
$form->setOnchange('date_rejet','fdate(this)'); |
$form->setOnchange('date_demande','fdate(this)'); |
493 |
$form->setOnchange('date_notification_delai','fdate(this)'); |
$form->setOnchange('date_depot','fdate(this)'); |
494 |
$form->setOnchange('delai','VerifNum(this)'); |
$form->setOnchange('date_complet','fdate(this)'); |
495 |
$form->setOnchange('date_limite','fdate(this)'); |
$form->setOnchange('date_rejet','fdate(this)'); |
496 |
$form->setOnchange('date_decision','fdate(this)'); |
$form->setOnchange('date_notification_delai','fdate(this)'); |
497 |
$form->setOnchange('date_validite','fdate(this)'); |
$form->setOnchange('delai','VerifNum(this)'); |
498 |
$form->setOnchange('date_chantier','fdate(this)'); |
$form->setOnchange('date_limite','fdate(this)'); |
499 |
$form->setOnchange('date_achevement','fdate(this)'); |
$form->setOnchange('date_decision','fdate(this)'); |
500 |
$form->setOnchange('date_conformite','fdate(this)'); |
$form->setOnchange('date_validite','fdate(this)'); |
501 |
$form->setOnchange('demandeur_categorie','VerifNum(this)'); |
$form->setOnchange('date_chantier','fdate(this)'); |
502 |
$form->setOnchange('architecte','VerifNum(this)'); |
$form->setOnchange('date_achevement','fdate(this)'); |
503 |
$form->setOnchange('terrain_surface','VerifNum(this)'); |
$form->setOnchange('date_conformite','fdate(this)'); |
504 |
$form->setOnchange('terrain_surface_calcul','VerifNum(this)'); |
$form->setOnchange('demandeur_categorie','VerifNum(this)'); |
505 |
$form->setOnchange('travaux','VerifNum(this)'); |
$form->setOnchange('architecte','VerifNum(this)'); |
506 |
$form->setOnchange('batiment_nombre','VerifNum(this)'); |
$form->setOnchange('travaux','VerifNum(this)'); |
507 |
$form->setOnchange('logement_nombre','VerifNum(this)'); |
$form->setOnchange('batiment_nombre','VerifNum(this)'); |
508 |
$form->setOnchange('shon','VerifNum(this)'); |
$form->setOnchange('logement_nombre','VerifNum(this)'); |
509 |
$form->setOnchange('shon_calcul','VerifNum(this)'); |
$form->setOnchange('lot','VerifNum(this)'); |
510 |
$form->setOnchange('shob','VerifNum(this)'); |
$form->setOnchange('piece_nombre','VerifNum(this)'); |
511 |
$form->setOnchange('lot','VerifNum(this)'); |
$form->setOnchange('parcelle_lot','VerifNum(this)'); |
512 |
$form->setOnchange('hauteur','VerifNum(this)'); |
} |
513 |
$form->setOnchange('piece_nombre','VerifNum(this)'); |
/** |
514 |
$form->setOnchange('parcelle_lot','VerifNum(this)'); |
* Methode setTaille |
515 |
} |
*/ |
516 |
|
function setTaille(&$form, $maj) { |
517 |
function setTaille(&$form,$maj) { |
$form->setTaille("dossier", 12); |
518 |
//taille des champs affiches (text) |
$form->setTaille("nature", 10); |
519 |
$form->setTaille('dossier',11); |
$form->setTaille("annee", 10); |
520 |
$form->setTaille('nature',20); |
$form->setTaille("etat", 20); |
521 |
$form->setTaille('annee',20); |
$form->setTaille("types", 12); |
522 |
$form->setTaille('etat',11); |
$form->setTaille("objet_dossier", 20); |
523 |
$form->setTaille('types',11); |
$form->setTaille("instructeur", 4); |
524 |
$form->setTaille('objet_dossier',20); |
$form->setTaille("date_demande", 12); |
525 |
$form->setTaille('instructeur',4); |
$form->setTaille("date_depot", 12); |
526 |
$form->setTaille('date_demande',12); |
$form->setTaille("date_complet", 12); |
527 |
$form->setTaille('date_depot',12); |
$form->setTaille("date_rejet", 12); |
528 |
$form->setTaille('date_complet',12); |
$form->setTaille("date_notification_delai", 12); |
529 |
$form->setTaille('date_rejet',12); |
$form->setTaille("delai", 4); |
530 |
$form->setTaille('date_notification_delai',12); |
$form->setTaille("date_limite", 12); |
531 |
$form->setTaille('delai',4); |
$form->setTaille("accord_tacite", 10); |
532 |
$form->setTaille('date_limite',12); |
$form->setTaille("date_decision", 12); |
533 |
$form->setTaille('accord_tacite',20); |
$form->setTaille("avis", 10); |
534 |
$form->setTaille('date_decision',12); |
$form->setTaille("date_validite", 12); |
535 |
$form->setTaille('avis',20); |
$form->setTaille("date_chantier", 12); |
536 |
$form->setTaille('date_validite',12); |
$form->setTaille("date_achevement", 12); |
537 |
$form->setTaille('date_chantier',12); |
$form->setTaille("date_conformite", 12); |
538 |
$form->setTaille('date_achevement',12); |
$form->setTaille("demandeur_civilite", 10); |
539 |
$form->setTaille('date_conformite',12); |
$form->setTaille("demandeur_nom", 30); |
540 |
$form->setTaille('demandeur_civilite',20); |
$form->setTaille("demandeur_societe", 30); |
541 |
$form->setTaille('demandeur_nom',20); |
$form->setTaille("demandeur_adresse", 30); |
542 |
$form->setTaille('demandeur_societe',20); |
$form->setTaille("demandeur_cp", 10); |
543 |
$form->setTaille('demandeur_adresse',20); |
$form->setTaille("demandeur_ville", 30); |
544 |
$form->setTaille('demandeur_cp',20); |
$form->setTaille("demandeur_pays", 30); |
545 |
$form->setTaille('demandeur_ville',20); |
$form->setTaille("demandeur_telephone", 14); |
546 |
$form->setTaille('demandeur_pays',20); |
$form->setTaille("demandeur_email", 30); |
547 |
$form->setTaille('demandeur_telephone',20); |
$form->setTaille("demandeur_categorie", 4); |
548 |
$form->setTaille('demandeur_email',20); |
$form->setTaille("delegataire", 10); |
549 |
$form->setTaille('demandeur_categorie',4); |
$form->setTaille("delegataire_civilite", 10); |
550 |
$form->setTaille('delegataire',20); |
$form->setTaille("delegataire_nom", 30); |
551 |
$form->setTaille('delegataire_civilite',20); |
$form->setTaille("delegataire_societe", 30); |
552 |
$form->setTaille('delegataire_nom',20); |
$form->setTaille("delegataire_adresse", 30); |
553 |
$form->setTaille('delegataire_societe',20); |
$form->setTaille("delegataire_cp", 10); |
554 |
$form->setTaille('delegataire_adresse',20); |
$form->setTaille("delegataire_ville", 30); |
555 |
$form->setTaille('delegataire_cp',20); |
$form->setTaille("delegataire_pays", 30); |
556 |
$form->setTaille('delegataire_ville',20); |
$form->setTaille("delegataire_telephone", 14); |
557 |
$form->setTaille('delegataire_pays',20); |
$form->setTaille("delegataire_email", 30); |
558 |
$form->setTaille('delegataire_telephone',20); |
$form->setTaille("terrain_numero", 10); |
559 |
$form->setTaille('delegataire_email',20); |
$form->setTaille("terrain_numero_complement", 10); |
560 |
$form->setTaille('terrain_numero',20); |
$form->setTaille("terrain_adresse", 30); |
561 |
$form->setTaille('terrain_numero_complement',20); |
$form->setTaille("terrain_adresse_complement", 30); |
562 |
$form->setTaille('terrain_adresse',18); |
$form->setTaille("terrain_cp", 10); |
563 |
$form->setTaille('terrain_adresse_complement',20); |
$form->setTaille("terrain_ville", 30); |
564 |
$form->setTaille('terrain_cp',20); |
$form->setTaille("architecte", 4); |
565 |
$form->setTaille('terrain_ville',20); |
$form->setTaille("terrain_surface", 8); |
566 |
$form->setTaille('architecte',4); |
$form->setTaille("terrain_surface_calcul", 8); |
567 |
$form->setTaille('terrain_surface',8); |
$form->setTaille("rivoli", 10); |
568 |
$form->setTaille('terrain_surface_calcul',8); |
$form->setTaille("travaux", 4); |
569 |
$form->setTaille('rivoli',20); |
$form->setTaille("parcelle", 20); |
570 |
$form->setTaille('travaux',4); |
$form->setTaille("pos", 10); |
571 |
$form->setTaille('parcelle',20); |
$form->setTaille("sig", 10); |
572 |
$form->setTaille('pos',20); |
$form->setTaille("batiment_nombre", 4); |
573 |
$form->setTaille('sig',20); |
$form->setTaille("logement_nombre", 4); |
574 |
$form->setTaille('batiment_nombre',4); |
$form->setTaille("shon", 8); |
575 |
$form->setTaille('logement_nombre',4); |
$form->setTaille("shon_calcul", 8); |
576 |
$form->setTaille('shon',8); |
$form->setTaille("shob", 8); |
577 |
$form->setTaille('shon_calcul',8); |
$form->setTaille("lot", 4); |
578 |
$form->setTaille('shob',8); |
$form->setTaille("hauteur", 8); |
579 |
$form->setTaille('lot',4); |
$form->setTaille("piece_nombre", 4); |
580 |
$form->setTaille('hauteur',8); |
$form->setTaille("amenagement", 12); |
581 |
$form->setTaille('piece_nombre',4); |
$form->setTaille("parcelle_lot", 4); |
582 |
$form->setTaille('amenagement',20); |
$form->setTaille("parcelle_lot_lotissement", 30); |
583 |
$form->setTaille('parcelle_lot',4); |
$form->setTaille("description", 80); |
584 |
$form->setTaille('parcelle_lot_lotissement',21); |
$form->setTaille("temp1", 30); |
585 |
$form->setTaille('description',80); |
$form->setTaille("temp2", 30); |
586 |
$form->setTaille('temp1',20); |
$form->setTaille("temp3", 30); |
587 |
$form->setTaille('temp2',20); |
$form->setTaille("temp4", 30); |
588 |
$form->setTaille('temp3',20); |
$form->setTaille("temp5", 30); |
589 |
$form->setTaille('temp4',20); |
$form->setTaille("servitude", 80); |
590 |
$form->setTaille('temp5',20); |
$form->setTaille("geom", 10); |
591 |
$form->setTaille('servitude',80); |
$form->setTaille("travaux_complement", 30); |
592 |
$form->setTaille('geom',50); |
} |
593 |
} |
|
594 |
|
/** |
595 |
function setMax(&$form,$maj) { |
* Methode setMax |
596 |
//longueur max en saisie (text) |
*/ |
597 |
$form->setMax('dossier',11); |
function setMax(&$form, $maj) { |
598 |
$form->setMax('nature',20); |
$form->setMax("dossier", 12); |
599 |
$form->setMax('annee',20); |
$form->setMax("nature", 2); |
600 |
$form->setMax('etat',11); |
$form->setMax("annee", 2); |
601 |
$form->setMax('types',11); |
$form->setMax("etat", 20); |
602 |
$form->setMax('objet_dossier',20); |
$form->setMax("types", 12); |
603 |
$form->setMax('instructeur',4); |
$form->setMax("objet_dossier", 20); |
604 |
$form->setMax('date_demande',12); |
$form->setMax("instructeur", 4); |
605 |
$form->setMax('date_depot',12); |
$form->setMax("date_demande", 12); |
606 |
$form->setMax('date_complet',12); |
$form->setMax("date_depot", 12); |
607 |
$form->setMax('date_rejet',12); |
$form->setMax("date_complet", 12); |
608 |
$form->setMax('date_notification_delai',12); |
$form->setMax("date_rejet", 12); |
609 |
$form->setMax('delai',4); |
$form->setMax("date_notification_delai", 12); |
610 |
$form->setMax('date_limite',12); |
$form->setMax("delai", 4); |
611 |
$form->setMax('accord_tacite',20); |
$form->setMax("date_limite", 12); |
612 |
$form->setMax('date_decision',12); |
$form->setMax("accord_tacite", 3); |
613 |
$form->setMax('avis',20); |
$form->setMax("date_decision", 12); |
614 |
$form->setMax('date_validite',12); |
$form->setMax("avis", 2); |
615 |
$form->setMax('date_chantier',12); |
$form->setMax("date_validite", 12); |
616 |
$form->setMax('date_achevement',12); |
$form->setMax("date_chantier", 12); |
617 |
$form->setMax('date_conformite',12); |
$form->setMax("date_achevement", 12); |
618 |
$form->setMax('demandeur_civilite',20); |
$form->setMax("date_conformite", 12); |
619 |
$form->setMax('demandeur_nom',20); |
$form->setMax("demandeur_civilite", 10); |
620 |
$form->setMax('demandeur_societe',20); |
$form->setMax("demandeur_nom", 80); |
621 |
$form->setMax('demandeur_adresse',20); |
$form->setMax("demandeur_societe", 80); |
622 |
$form->setMax('demandeur_cp',20); |
$form->setMax("demandeur_adresse", 80); |
623 |
$form->setMax('demandeur_ville',20); |
$form->setMax("demandeur_cp", 5); |
624 |
$form->setMax('demandeur_pays',20); |
$form->setMax("demandeur_ville", 30); |
625 |
$form->setMax('demandeur_telephone',20); |
$form->setMax("demandeur_pays", 40); |
626 |
$form->setMax('demandeur_email',20); |
$form->setMax("demandeur_telephone", 14); |
627 |
$form->setMax('demandeur_categorie',4); |
$form->setMax("demandeur_email", 40); |
628 |
$form->setMax('delegataire',20); |
$form->setMax("demandeur_categorie", 4); |
629 |
$form->setMax('delegataire_civilite',20); |
$form->setMax("delegataire", 3); |
630 |
$form->setMax('delegataire_nom',20); |
$form->setMax("delegataire_civilite", 10); |
631 |
$form->setMax('delegataire_societe',20); |
$form->setMax("delegataire_nom", 80); |
632 |
$form->setMax('delegataire_adresse',20); |
$form->setMax("delegataire_societe", 80); |
633 |
$form->setMax('delegataire_cp',20); |
$form->setMax("delegataire_adresse", 80); |
634 |
$form->setMax('delegataire_ville',20); |
$form->setMax("delegataire_cp", 5); |
635 |
$form->setMax('delegataire_pays',20); |
$form->setMax("delegataire_ville", 30); |
636 |
$form->setMax('delegataire_telephone',20); |
$form->setMax("delegataire_pays", 40); |
637 |
$form->setMax('delegataire_email',20); |
$form->setMax("delegataire_telephone", 14); |
638 |
$form->setMax('terrain_numero',20); |
$form->setMax("delegataire_email", 40); |
639 |
$form->setMax('terrain_numero_complement',20); |
$form->setMax("terrain_numero", 4); |
640 |
$form->setMax('terrain_adresse',18); |
$form->setMax("terrain_numero_complement", 5); |
641 |
$form->setMax('terrain_adresse_complement',20); |
$form->setMax("terrain_adresse", 80); |
642 |
$form->setMax('terrain_cp',20); |
$form->setMax("terrain_adresse_complement", 80); |
643 |
$form->setMax('terrain_ville',20); |
$form->setMax("terrain_cp", 5); |
644 |
$form->setMax('architecte',4); |
$form->setMax("terrain_ville", 30); |
645 |
$form->setMax('terrain_surface',8); |
$form->setMax("architecte", 4); |
646 |
$form->setMax('terrain_surface_calcul',8); |
$form->setMax("terrain_surface", 8); |
647 |
$form->setMax('rivoli',20); |
$form->setMax("terrain_surface_calcul", 8); |
648 |
$form->setMax('travaux',4); |
$form->setMax("rivoli", 4); |
649 |
$form->setMax('parcelle',20); |
$form->setMax("travaux", 4); |
650 |
$form->setMax('pos',20); |
$form->setMax("parcelle", 20); |
651 |
$form->setMax('sig',20); |
$form->setMax("pos", 10); |
652 |
$form->setMax('batiment_nombre',4); |
$form->setMax("sig", 3); |
653 |
$form->setMax('logement_nombre',4); |
$form->setMax("batiment_nombre", 4); |
654 |
$form->setMax('shon',8); |
$form->setMax("logement_nombre", 4); |
655 |
$form->setMax('shon_calcul',8); |
$form->setMax("shon", 8); |
656 |
$form->setMax('shob',8); |
$form->setMax("shon_calcul", 8); |
657 |
$form->setMax('lot',4); |
$form->setMax("shob", 8); |
658 |
$form->setMax('hauteur',8); |
$form->setMax("lot", 4); |
659 |
$form->setMax('piece_nombre',4); |
$form->setMax("hauteur", 8); |
660 |
$form->setMax('amenagement',20); |
$form->setMax("piece_nombre", 4); |
661 |
$form->setMax('parcelle_lot',4); |
$form->setMax("amenagement", 12); |
662 |
$form->setMax('parcelle_lot_lotissement',21); |
$form->setMax("parcelle_lot", 4); |
663 |
$form->setMax('description',6); |
$form->setMax("parcelle_lot_lotissement", 60); |
664 |
$form->setMax('temp1',20); |
$form->setMax("description", 6); |
665 |
$form->setMax('temp2',20); |
$form->setMax("temp1", 100); |
666 |
$form->setMax('temp3',20); |
$form->setMax("temp2", 100); |
667 |
$form->setMax('temp4',20); |
$form->setMax("temp3", 100); |
668 |
$form->setMax('temp5',20); |
$form->setMax("temp4", 100); |
669 |
$form->setMax('servitude',6); |
$form->setMax("temp5", 100); |
670 |
$form->setMax('geom',50); |
$form->setMax("servitude", 6); |
671 |
} |
$form->setMax("geom", -5); |
672 |
|
$form->setMax("travaux_complement", 100); |
673 |
function setLib(&$form,$maj) { |
} |
674 |
//libelle des champs |
|
675 |
$form->setLib('dossier',_('dossier')); |
|
676 |
$form->setLib('nature',_('nature')); |
function setLib(&$form,$maj) { |
677 |
$form->setLib('annee',_('annee')); |
//libelle des champs |
678 |
$form->setLib('etat',_('etat')); |
$form->setLib('dossier',_('dossier')); |
679 |
$form->setLib('types',_('types')); |
$form->setLib('nature',_('nature')); |
680 |
$form->setLib('objet_dossier',_('objet_dossier')); |
$form->setLib('annee',_('annee')); |
681 |
$form->setLib('instructeur',_('instructeur')); |
$form->setLib('etat',_('etat')); |
682 |
$form->setLib('date_demande',_('date_demande')); |
$form->setLib('types',_('types')); |
683 |
$form->setLib('date_depot',_('date_depot')); |
$form->setLib('objet_dossier',_('objet_dossier')); |
684 |
$form->setLib('date_complet',_('date_complet')); |
$form->setLib('instructeur',_('instructeur')); |
685 |
$form->setLib('date_rejet',_('date_rejet')); |
$form->setLib('date_demande',_('date_demande')); |
686 |
$form->setLib('date_notification_delai',_('date_notification_delai')); |
$form->setLib('date_depot',_('date_depot')); |
687 |
$form->setLib('delai',_('delai')); |
$form->setLib('date_complet',_('date_complet')); |
688 |
$form->setLib('date_limite',_('date_limite')); |
$form->setLib('date_rejet',_('date_rejet')); |
689 |
$form->setLib('accord_tacite',_('accord_tacite')); |
$form->setLib('date_notification_delai',_('date_notification_delai')); |
690 |
$form->setLib('date_decision',_('date_decision')); |
$form->setLib('delai',_('delai')); |
691 |
$form->setLib('avis',_('avis')); |
$form->setLib('date_limite',_('date_limite')); |
692 |
$form->setLib('date_validite',_('date_validite')); |
$form->setLib('accord_tacite',_('accord_tacite')); |
693 |
$form->setLib('date_chantier',_('date_chantier')); |
$form->setLib('date_decision',_('date_decision')); |
694 |
$form->setLib('date_achevement',_('date_achevement')); |
$form->setLib('avis',_('avis')); |
695 |
$form->setLib('date_conformite',_('date_conformite')); |
$form->setLib('date_validite',_('date_validite')); |
696 |
$form->setLib('demandeur_civilite',_('demandeur_civilite')); |
$form->setLib('date_chantier',_('date_chantier')); |
697 |
$form->setLib('demandeur_nom',_('demandeur_nom')); |
$form->setLib('date_achevement',_('date_achevement')); |
698 |
$form->setLib('demandeur_societe',_('demandeur_societe')); |
$form->setLib('date_conformite',_('date_conformite')); |
699 |
$form->setLib('demandeur_adresse',_('demandeur_adresse')); |
$form->setLib('demandeur_civilite',_('demandeur_civilite')); |
700 |
$form->setLib('demandeur_cp',_('demandeur_cp')); |
$form->setLib('demandeur_nom',_('demandeur_nom')); |
701 |
$form->setLib('demandeur_ville',_('demandeur_ville')); |
$form->setLib('demandeur_societe',_('demandeur_societe')); |
702 |
$form->setLib('demandeur_pays',_('demandeur_pays')); |
$form->setLib('demandeur_adresse',_('demandeur_adresse')); |
703 |
$form->setLib('demandeur_telephone',_('demandeur_telephone')); |
$form->setLib('demandeur_cp',_('demandeur_cp')); |
704 |
$form->setLib('demandeur_email',_('demandeur_email')); |
$form->setLib('demandeur_ville',_('demandeur_ville')); |
705 |
$form->setLib('demandeur_categorie',_('demandeur_categorie')); |
$form->setLib('demandeur_pays',_('demandeur_pays')); |
706 |
$form->setLib('delegataire',_('delegataire')); |
$form->setLib('demandeur_telephone',_('demandeur_telephone')); |
707 |
$form->setLib('delegataire_civilite',_('delegataire_civilite')); |
$form->setLib('demandeur_email',_('demandeur_email')); |
708 |
$form->setLib('delegataire_nom',_('delegataire_nom')); |
$form->setLib('demandeur_categorie',_('demandeur_categorie')); |
709 |
$form->setLib('delegataire_societe',_('delegataire_societe')); |
$form->setLib('delegataire',_('delegataire')); |
710 |
$form->setLib('delegataire_adresse',_('delegataire_adresse')); |
$form->setLib('delegataire_civilite',_('delegataire_civilite')); |
711 |
$form->setLib('delegataire_cp',_('delegataire_cp')); |
$form->setLib('delegataire_nom',_('delegataire_nom')); |
712 |
$form->setLib('delegataire_ville',_('delegataire_ville')); |
$form->setLib('delegataire_societe',_('delegataire_societe')); |
713 |
$form->setLib('delegataire_pays',_('delegataire_pays')); |
$form->setLib('delegataire_adresse',_('delegataire_adresse')); |
714 |
$form->setLib('delegataire_telephone',_('delegataire_telephone')); |
$form->setLib('delegataire_cp',_('delegataire_cp')); |
715 |
$form->setLib('delegataire_email',_('delegataire_email')); |
$form->setLib('delegataire_ville',_('delegataire_ville')); |
716 |
$form->setLib('terrain_numero',_('terrain_numero')); |
$form->setLib('delegataire_pays',_('delegataire_pays')); |
717 |
$form->setLib('terrain_numero_complement',_('terrain_numero_complement')); |
$form->setLib('delegataire_telephone',_('delegataire_telephone')); |
718 |
$form->setLib('terrain_adresse',_('terrain_adresse')); |
$form->setLib('delegataire_email',_('delegataire_email')); |
719 |
$form->setLib('terrain_adresse_complement',_('terrain_adresse_complement')); |
$form->setLib('terrain_numero',_('terrain_numero')); |
720 |
$form->setLib('terrain_cp',_('terrain_cp')); |
$form->setLib('terrain_numero_complement',_('terrain_numero_complement')); |
721 |
$form->setLib('terrain_ville',_('terrain_ville')); |
$form->setLib('terrain_adresse',_('terrain_adresse')); |
722 |
$form->setLib('architecte',_('architecte')); |
$form->setLib('terrain_adresse_complement',_('terrain_adresse_complement')); |
723 |
$form->setLib('terrain_surface',_('terrain_surface')); |
$form->setLib('terrain_cp',_('terrain_cp')); |
724 |
$form->setLib('terrain_surface_calcul',_('terrain_surface_calcul')); |
$form->setLib('terrain_ville',_('terrain_ville')); |
725 |
$form->setLib('rivoli',_('rivoli')); |
$form->setLib('architecte',_('architecte')); |
726 |
$form->setLib('travaux',_('travaux')); |
$form->setLib('terrain_surface',_('terrain_surface')); |
727 |
$form->setLib('parcelle',_('parcelle')); |
$form->setLib('terrain_surface_calcul',_('terrain_surface_calcul')); |
728 |
$form->setLib('pos',_('pos')); |
$form->setLib('rivoli',_('rivoli')); |
729 |
$form->setLib('sig',_('sig')); |
$form->setLib('travaux',_('travaux')); |
730 |
$form->setLib('batiment_nombre',_('batiment_nombre')); |
$form->setLib('parcelle',_('parcelle')); |
731 |
$form->setLib('logement_nombre',_('logement_nombre')); |
$form->setLib('pos',_('pos')); |
732 |
$form->setLib('shon',_('shon')); |
$form->setLib('sig',_('sig')); |
733 |
$form->setLib('shon_calcul',_('shon_calcul')); |
$form->setLib('batiment_nombre',_('batiment_nombre')); |
734 |
$form->setLib('shob',_('shob')); |
$form->setLib('logement_nombre',_('logement_nombre')); |
735 |
$form->setLib('lot',_('lot')); |
$form->setLib('shon',_('shon')); |
736 |
$form->setLib('hauteur',_('hauteur')); |
$form->setLib('shon_calcul',_('shon_calcul')); |
737 |
$form->setLib('piece_nombre',_('piece_nombre')); |
$form->setLib('shob',_('shob')); |
738 |
$form->setLib('amenagement',_('amenagement')); |
$form->setLib('lot',_('lot')); |
739 |
$form->setLib('parcelle_lot',_('parcelle_lot')); |
$form->setLib('hauteur',_('hauteur')); |
740 |
$form->setLib('parcelle_lot_lotissement',_('parcelle_lot_lotissement')); |
$form->setLib('piece_nombre',_('piece_nombre')); |
741 |
$form->setLib('description',_('description')); |
$form->setLib('amenagement',_('amenagement')); |
742 |
$form->setLib('temp1',_('temp1')); |
$form->setLib('parcelle_lot',_('parcelle_lot')); |
743 |
$form->setLib('temp2',_('temp2')); |
$form->setLib('parcelle_lot_lotissement',_('parcelle_lot_lotissement')); |
744 |
$form->setLib('temp3',_('temp3')); |
$form->setLib('description',_('description')); |
745 |
$form->setLib('temp4',_('temp4')); |
$form->setLib('temp1',_('temp1')); |
746 |
$form->setLib('temp5',_('temp5')); |
$form->setLib('temp2',_('temp2')); |
747 |
$form->setLib('servitude',_('servitude')); |
$form->setLib('temp3',_('temp3')); |
748 |
$form->setLib('geom',_('geom')); |
$form->setLib('temp4',_('temp4')); |
749 |
} |
$form->setLib('temp5',_('temp5')); |
750 |
|
$form->setLib('servitude',_('servitude')); |
751 |
function setSelect(&$form, $maj,&$db,$debug) { |
$form->setLib('geom',_('geom')); |
752 |
if(file_exists ("../sql/".$db->phptype."/".$this->table.".form.inc")) |
$form->setLib('travaux_complement',_('travaux_complement')); |
753 |
include ("../sql/".$db->phptype."/".$this->table.".form.inc"); |
} |
754 |
if($maj<2){ |
|
755 |
// nature |
function setSelect(&$form, $maj,&$db,$debug) { |
756 |
$contenu=array(); |
if(file_exists ("../sql/".$db->phptype."/".$this->table.".form.inc.php")) |
757 |
$res = $db->query($sql_nature); |
include ("../sql/".$db->phptype."/".$this->table.".form.inc.php"); |
758 |
// Logger |
elseif(file_exists ("../sql/".$db->phptype."/".$this->table.".form.inc")) |
759 |
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_nature."\");", VERBOSE_MODE); |
include ("../sql/".$db->phptype."/".$this->table.".form.inc"); |
760 |
if (database::isError($res)) |
if($maj<2){ |
761 |
die($res->getMessage().$sql_nature); |
// nature |
762 |
else{ |
$contenu=array(); |
763 |
if ($debug == 1) |
$res = $db->query($sql_nature); |
764 |
echo " la requete ".$sql_nature." est executee<br>"; |
// Logger |
765 |
$contenu[0][0]=''; |
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_nature."\");", VERBOSE_MODE); |
766 |
$contenu[1][0]=_('choisir')." "._('nature'); |
if (database::isError($res)) |
767 |
$k=1; |
die($res->getMessage().$sql_nature); |
768 |
while ($row=& $res->fetchRow()){ |
else{ |
769 |
$contenu[0][$k]=$row[0]; |
if ($debug == 1) |
770 |
$contenu[1][$k]=$row[1]; |
echo " la requete ".$sql_nature." est executee<br>"; |
771 |
$k++; |
$contenu[0][0]=''; |
772 |
} |
$contenu[1][0]=_('choisir')." "._('nature'); |
773 |
$form->setSelect('nature',$contenu); |
$k=1; |
774 |
}// fin error db |
while ($row=& $res->fetchRow()){ |
775 |
// etat |
$contenu[0][$k]=$row[0]; |
776 |
$contenu=array(); |
$contenu[1][$k]=$row[1]; |
777 |
$res = $db->query($sql_etat); |
$k++; |
778 |
// Logger |
} |
779 |
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_etat."\");", VERBOSE_MODE); |
$form->setSelect('nature',$contenu); |
780 |
if (database::isError($res)) |
}// fin error db |
781 |
die($res->getMessage().$sql_etat); |
// etat |
782 |
else{ |
$contenu=array(); |
783 |
if ($debug == 1) |
$res = $db->query($sql_etat); |
784 |
echo " la requete ".$sql_etat." est executee<br>"; |
// Logger |
785 |
$contenu[0][0]=''; |
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_etat."\");", VERBOSE_MODE); |
786 |
$contenu[1][0]=_('choisir')." "._('etat'); |
if (database::isError($res)) |
787 |
$k=1; |
die($res->getMessage().$sql_etat); |
788 |
while ($row=& $res->fetchRow()){ |
else{ |
789 |
$contenu[0][$k]=$row[0]; |
if ($debug == 1) |
790 |
$contenu[1][$k]=$row[1]; |
echo " la requete ".$sql_etat." est executee<br>"; |
791 |
$k++; |
$contenu[0][0]=''; |
792 |
} |
$contenu[1][0]=_('choisir')." "._('etat'); |
793 |
$form->setSelect('etat',$contenu); |
$k=1; |
794 |
}// fin error db |
while ($row=& $res->fetchRow()){ |
795 |
// avis |
$contenu[0][$k]=$row[0]; |
796 |
$contenu=array(); |
$contenu[1][$k]=$row[1]; |
797 |
$res = $db->query($sql_avis); |
$k++; |
798 |
// Logger |
} |
799 |
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_avis."\");", VERBOSE_MODE); |
$form->setSelect('etat',$contenu); |
800 |
if (database::isError($res)) |
}// fin error db |
801 |
die($res->getMessage().$sql_avis); |
// avis |
802 |
else{ |
$contenu=array(); |
803 |
if ($debug == 1) |
$res = $db->query($sql_avis); |
804 |
echo " la requete ".$sql_avis." est executee<br>"; |
// Logger |
805 |
$contenu[0][0]=''; |
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_avis."\");", VERBOSE_MODE); |
806 |
$contenu[1][0]=_('choisir')." "._('avis'); |
if (database::isError($res)) |
807 |
$k=1; |
die($res->getMessage().$sql_avis); |
808 |
while ($row=& $res->fetchRow()){ |
else{ |
809 |
$contenu[0][$k]=$row[0]; |
if ($debug == 1) |
810 |
$contenu[1][$k]=$row[1]; |
echo " la requete ".$sql_avis." est executee<br>"; |
811 |
$k++; |
$contenu[0][0]=''; |
812 |
} |
$contenu[1][0]=_('choisir')." "._('avis'); |
813 |
$form->setSelect('avis',$contenu); |
$k=1; |
814 |
}// fin error db |
while ($row=& $res->fetchRow()){ |
815 |
// architecte |
$contenu[0][$k]=$row[0]; |
816 |
$contenu=array(); |
$contenu[1][$k]=$row[1]; |
817 |
$res = $db->query($sql_architecte); |
$k++; |
818 |
// Logger |
} |
819 |
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_architecte."\");", VERBOSE_MODE); |
$form->setSelect('avis',$contenu); |
820 |
if (database::isError($res)) |
}// fin error db |
821 |
die($res->getMessage().$sql_architecte); |
// architecte |
822 |
else{ |
$contenu=array(); |
823 |
if ($debug == 1) |
$res = $db->query($sql_architecte); |
824 |
echo " la requete ".$sql_architecte." est executee<br>"; |
// Logger |
825 |
$contenu[0][0]=''; |
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_architecte."\");", VERBOSE_MODE); |
826 |
$contenu[1][0]=_('choisir')." "._('architecte'); |
if (database::isError($res)) |
827 |
$k=1; |
die($res->getMessage().$sql_architecte); |
828 |
while ($row=& $res->fetchRow()){ |
else{ |
829 |
$contenu[0][$k]=$row[0]; |
if ($debug == 1) |
830 |
$contenu[1][$k]=$row[1]; |
echo " la requete ".$sql_architecte." est executee<br>"; |
831 |
$k++; |
$contenu[0][0]=''; |
832 |
} |
$contenu[1][0]=_('choisir')." "._('architecte'); |
833 |
$form->setSelect('architecte',$contenu); |
$k=1; |
834 |
}// fin error db |
while ($row=& $res->fetchRow()){ |
835 |
// rivoli |
$contenu[0][$k]=$row[0]; |
836 |
$contenu=array(); |
$contenu[1][$k]=$row[1]; |
837 |
$res = $db->query($sql_rivoli); |
$k++; |
838 |
// Logger |
} |
839 |
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_rivoli."\");", VERBOSE_MODE); |
$form->setSelect('architecte',$contenu); |
840 |
if (database::isError($res)) |
}// fin error db |
841 |
die($res->getMessage().$sql_rivoli); |
// rivoli |
842 |
else{ |
$contenu=array(); |
843 |
if ($debug == 1) |
$res = $db->query($sql_rivoli); |
844 |
echo " la requete ".$sql_rivoli." est executee<br>"; |
// Logger |
845 |
$contenu[0][0]=''; |
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_rivoli."\");", VERBOSE_MODE); |
846 |
$contenu[1][0]=_('choisir')." "._('rivoli'); |
if (database::isError($res)) |
847 |
$k=1; |
die($res->getMessage().$sql_rivoli); |
848 |
while ($row=& $res->fetchRow()){ |
else{ |
849 |
$contenu[0][$k]=$row[0]; |
if ($debug == 1) |
850 |
$contenu[1][$k]=$row[1]; |
echo " la requete ".$sql_rivoli." est executee<br>"; |
851 |
$k++; |
$contenu[0][0]=''; |
852 |
} |
$contenu[1][0]=_('choisir')." "._('rivoli'); |
853 |
$form->setSelect('rivoli',$contenu); |
$k=1; |
854 |
}// fin error db |
while ($row=& $res->fetchRow()){ |
855 |
// travaux |
$contenu[0][$k]=$row[0]; |
856 |
$contenu=array(); |
$contenu[1][$k]=$row[1]; |
857 |
$res = $db->query($sql_travaux); |
$k++; |
858 |
// Logger |
} |
859 |
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_travaux."\");", VERBOSE_MODE); |
$form->setSelect('rivoli',$contenu); |
860 |
if (database::isError($res)) |
}// fin error db |
861 |
die($res->getMessage().$sql_travaux); |
// travaux |
862 |
else{ |
$contenu=array(); |
863 |
if ($debug == 1) |
$res = $db->query($sql_travaux); |
864 |
echo " la requete ".$sql_travaux." est executee<br>"; |
// Logger |
865 |
$contenu[0][0]=''; |
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_travaux."\");", VERBOSE_MODE); |
866 |
$contenu[1][0]=_('choisir')." "._('travaux'); |
if (database::isError($res)) |
867 |
$k=1; |
die($res->getMessage().$sql_travaux); |
868 |
while ($row=& $res->fetchRow()){ |
else{ |
869 |
$contenu[0][$k]=$row[0]; |
if ($debug == 1) |
870 |
$contenu[1][$k]=$row[1]; |
echo " la requete ".$sql_travaux." est executee<br>"; |
871 |
$k++; |
$contenu[0][0]=''; |
872 |
} |
$contenu[1][0]=_('choisir')." "._('travaux'); |
873 |
$form->setSelect('travaux',$contenu); |
$k=1; |
874 |
}// fin error db |
while ($row=& $res->fetchRow()){ |
875 |
// parcelle |
$contenu[0][$k]=$row[0]; |
876 |
$contenu=array(); |
$contenu[1][$k]=$row[1]; |
877 |
$res = $db->query($sql_parcelle); |
$k++; |
878 |
// Logger |
} |
879 |
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_parcelle."\");", VERBOSE_MODE); |
$form->setSelect('travaux',$contenu); |
880 |
if (database::isError($res)) |
}// fin error db |
881 |
die($res->getMessage().$sql_parcelle); |
// parcelle |
882 |
else{ |
$contenu=array(); |
883 |
if ($debug == 1) |
$res = $db->query($sql_parcelle); |
884 |
echo " la requete ".$sql_parcelle." est executee<br>"; |
// Logger |
885 |
$contenu[0][0]=''; |
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_parcelle."\");", VERBOSE_MODE); |
886 |
$contenu[1][0]=_('choisir')." "._('parcelle'); |
if (database::isError($res)) |
887 |
$k=1; |
die($res->getMessage().$sql_parcelle); |
888 |
while ($row=& $res->fetchRow()){ |
else{ |
889 |
$contenu[0][$k]=$row[0]; |
if ($debug == 1) |
890 |
$contenu[1][$k]=$row[1]; |
echo " la requete ".$sql_parcelle." est executee<br>"; |
891 |
$k++; |
$contenu[0][0]=''; |
892 |
} |
$contenu[1][0]=_('choisir')." "._('parcelle'); |
893 |
$form->setSelect('parcelle',$contenu); |
$k=1; |
894 |
}// fin error db |
while ($row=& $res->fetchRow()){ |
895 |
// pos |
$contenu[0][$k]=$row[0]; |
896 |
$contenu=array(); |
$contenu[1][$k]=$row[1]; |
897 |
$res = $db->query($sql_pos); |
$k++; |
898 |
// Logger |
} |
899 |
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_pos."\");", VERBOSE_MODE); |
$form->setSelect('parcelle',$contenu); |
900 |
if (database::isError($res)) |
}// fin error db |
901 |
die($res->getMessage().$sql_pos); |
// pos |
902 |
else{ |
$contenu=array(); |
903 |
if ($debug == 1) |
$res = $db->query($sql_pos); |
904 |
echo " la requete ".$sql_pos." est executee<br>"; |
// Logger |
905 |
$contenu[0][0]=''; |
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_pos."\");", VERBOSE_MODE); |
906 |
$contenu[1][0]=_('choisir')." "._('pos'); |
if (database::isError($res)) |
907 |
$k=1; |
die($res->getMessage().$sql_pos); |
908 |
while ($row=& $res->fetchRow()){ |
else{ |
909 |
$contenu[0][$k]=$row[0]; |
if ($debug == 1) |
910 |
$contenu[1][$k]=$row[1]; |
echo " la requete ".$sql_pos." est executee<br>"; |
911 |
$k++; |
$contenu[0][0]=''; |
912 |
} |
$contenu[1][0]=_('choisir')." "._('pos'); |
913 |
$form->setSelect('pos',$contenu); |
$k=1; |
914 |
}// fin error db |
while ($row=& $res->fetchRow()){ |
915 |
// parcelle_lot |
$contenu[0][$k]=$row[0]; |
916 |
$contenu=array(); |
$contenu[1][$k]=$row[1]; |
917 |
$res = $db->query($sql_parcelle_lot); |
$k++; |
918 |
// Logger |
} |
919 |
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_parcelle_lot."\");", VERBOSE_MODE); |
$form->setSelect('pos',$contenu); |
920 |
if (database::isError($res)) |
}// fin error db |
921 |
die($res->getMessage().$sql_parcelle_lot); |
// parcelle_lot |
922 |
else{ |
$contenu=array(); |
923 |
if ($debug == 1) |
$res = $db->query($sql_parcelle_lot); |
924 |
echo " la requete ".$sql_parcelle_lot." est executee<br>"; |
// Logger |
925 |
$contenu[0][0]=''; |
$this->addToLog("setSelect()[gen/obj]: db->query(\"".$sql_parcelle_lot."\");", VERBOSE_MODE); |
926 |
$contenu[1][0]=_('choisir')." "._('parcelle_lot'); |
if (database::isError($res)) |
927 |
$k=1; |
die($res->getMessage().$sql_parcelle_lot); |
928 |
while ($row=& $res->fetchRow()){ |
else{ |
929 |
$contenu[0][$k]=$row[0]; |
if ($debug == 1) |
930 |
$contenu[1][$k]=$row[1]; |
echo " la requete ".$sql_parcelle_lot." est executee<br>"; |
931 |
$k++; |
$contenu[0][0]=''; |
932 |
} |
$contenu[1][0]=_('choisir')." "._('parcelle_lot'); |
933 |
$form->setSelect('parcelle_lot',$contenu); |
$k=1; |
934 |
}// fin error db |
while ($row=& $res->fetchRow()){ |
935 |
}// fin maj |
$contenu[0][$k]=$row[0]; |
936 |
}// fin select |
$contenu[1][$k]=$row[1]; |
937 |
|
$k++; |
938 |
//================================== |
} |
939 |
// sous Formulaire [subform] |
$form->setSelect('parcelle_lot',$contenu); |
940 |
//================================== |
}// fin error db |
941 |
|
}// fin maj |
942 |
function setValsousformulaire(&$form,$maj,$validation,$idxformulaire,$retourformulaire,$typeformulaire,&$db,$DEBUG=null){ |
}// fin select |
943 |
$this->retourformulaire = $retourformulaire; |
|
944 |
if($validation==0) { |
//================================== |
945 |
if($retourformulaire =='nature') |
// sous Formulaire [subform] |
946 |
$form->setVal('nature', $idxformulaire); |
//================================== |
947 |
if($retourformulaire =='etat') |
|
948 |
$form->setVal('etat', $idxformulaire); |
function setValsousformulaire(&$form,$maj,$validation,$idxformulaire,$retourformulaire,$typeformulaire,&$db,$DEBUG=null){ |
949 |
if($retourformulaire =='avis') |
$this->retourformulaire = $retourformulaire; |
950 |
$form->setVal('avis', $idxformulaire); |
if($validation==0) { |
951 |
if($retourformulaire =='architecte') |
if($retourformulaire =='nature') |
952 |
$form->setVal('architecte', $idxformulaire); |
$form->setVal('nature', $idxformulaire); |
953 |
if($retourformulaire =='rivoli') |
if($retourformulaire =='etat') |
954 |
$form->setVal('rivoli', $idxformulaire); |
$form->setVal('etat', $idxformulaire); |
955 |
if($retourformulaire =='travaux') |
if($retourformulaire =='avis') |
956 |
$form->setVal('travaux', $idxformulaire); |
$form->setVal('avis', $idxformulaire); |
957 |
if($retourformulaire =='parcelle') |
if($retourformulaire =='architecte') |
958 |
$form->setVal('parcelle', $idxformulaire); |
$form->setVal('architecte', $idxformulaire); |
959 |
if($retourformulaire =='pos') |
if($retourformulaire =='rivoli') |
960 |
$form->setVal('pos', $idxformulaire); |
$form->setVal('rivoli', $idxformulaire); |
961 |
if($retourformulaire =='parcelle_lot') |
if($retourformulaire =='travaux') |
962 |
$form->setVal('parcelle_lot', $idxformulaire); |
$form->setVal('travaux', $idxformulaire); |
963 |
}// fin validation |
if($retourformulaire =='parcelle') |
964 |
}// fin setValsousformulaire |
$form->setVal('parcelle', $idxformulaire); |
965 |
|
if($retourformulaire =='pos') |
966 |
//================================== |
$form->setVal('pos', $idxformulaire); |
967 |
// cle secondaire [secondary key] |
if($retourformulaire =='parcelle_lot') |
968 |
//================================== |
$form->setVal('parcelle_lot', $idxformulaire); |
969 |
|
}// fin validation |
970 |
|
}// fin setValsousformulaire |
971 |
|
|
972 |
|
//================================== |
973 |
|
// cle secondaire [secondary key] |
974 |
|
//================================== |
975 |
/** |
/** |
976 |
* Methode clesecondaire |
* Methode clesecondaire |
977 |
*/ |
*/ |
980 |
parent::cleSecondaire($id, $db, $val, $DEBUG); |
parent::cleSecondaire($id, $db, $val, $DEBUG); |
981 |
// Verification de la cle secondaire : blocnote |
// Verification de la cle secondaire : blocnote |
982 |
$this->rechercheTable($db, "blocnote", "dossier", $id); |
$this->rechercheTable($db, "blocnote", "dossier", $id); |
983 |
// Verification de la cle secondaire : consultation |
// Verification de la cle secondaire : terrain |
984 |
$this->rechercheTable($db, "consultation", "dossier", $id); |
$this->rechercheTable($db, "terrain", "dossier", $id); |
|
// Verification de la cle secondaire : destination_shon |
|
|
$this->rechercheTable($db, "destination_shon", "dossier", $id); |
|
985 |
// Verification de la cle secondaire : instruction |
// Verification de la cle secondaire : instruction |
986 |
$this->rechercheTable($db, "instruction", "dossier", $id); |
$this->rechercheTable($db, "instruction", "dossier", $id); |
987 |
// Verification de la cle secondaire : statistique |
// Verification de la cle secondaire : statistique |
988 |
$this->rechercheTable($db, "statistique", "dossier", $id); |
$this->rechercheTable($db, "statistique", "dossier", $id); |
989 |
// Verification de la cle secondaire : terrain |
// Verification de la cle secondaire : consultation |
990 |
$this->rechercheTable($db, "terrain", "dossier", $id); |
$this->rechercheTable($db, "consultation", "dossier", $id); |
991 |
|
// Verification de la cle secondaire : destination_shon |
992 |
|
$this->rechercheTable($db, "destination_shon", "dossier", $id); |
993 |
} |
} |
994 |
|
|
995 |
|
|