28 |
|
|
29 |
// Configuration du bouton retour |
// Configuration du bouton retour |
30 |
if($retour != "" AND $retour != "tab") { |
if($retour != "" AND $retour != "tab") { |
31 |
$bouton_retour = "<a class=\"retour\" |
$bouton_retour = "<a class=\"retour\"". |
32 |
href=\"../scr/form.php?obj=dossier_instruction&idx=".$retour."&action=3 |
"href=\"../scr/form.php?obj=dossier_instruction&idx=".$retour."&action=3". |
33 |
&premier=30&tricol=&recherche=&selectioncol=&advs_id=&valide=#ui-tabs-0\">". |
"&premier=".$premier."&tricol=".$tricol."&recherche=".$recherche. |
34 |
|
"&selectioncol=".$selectioncol."&advs_id=&valide=#ui-tabs-0\">". |
35 |
_("Retour")."</a>"; |
_("Retour")."</a>"; |
36 |
} else { |
} else { |
37 |
$bouton_retour = "<a class=\"retour\" |
$bouton_retour = "<a class=\"retour\" |
147 |
) as \"description_projet\", |
) as \"description_projet\", |
148 |
REGEXP_REPLACE(CONCAT( |
REGEXP_REPLACE(CONCAT( |
149 |
CASE |
CASE |
150 |
WHEN donnees_techniques.su_trsf_shon1 IS NULL |
WHEN donnees_techniques.su_cstr_shon1 IS NULL |
151 |
THEN '' |
THEN '' |
152 |
ELSE CONCAT('Habitation - ', donnees_techniques.su_trsf_shon1, ' m² <br/>') |
ELSE CONCAT('Habitation - ', donnees_techniques.su_cstr_shon1, ' m² <br/>') |
153 |
END, |
END, |
154 |
CASE |
CASE |
155 |
WHEN donnees_techniques.su_trsf_shon2 IS NULL |
WHEN donnees_techniques.su_cstr_shon2 IS NULL |
156 |
THEN '' |
THEN '' |
157 |
ELSE CONCAT('Hébergement hôtelier - ', donnees_techniques.su_trsf_shon2, ' m² <br/>') |
ELSE CONCAT('Hébergement hôtelier - ', donnees_techniques.su_cstr_shon2, ' m² <br/>') |
158 |
END, |
END, |
159 |
CASE |
CASE |
160 |
WHEN donnees_techniques.su_trsf_shon3 IS NULL |
WHEN donnees_techniques.su_cstr_shon3 IS NULL |
161 |
THEN '' |
THEN '' |
162 |
ELSE CONCAT('Bureaux - ', donnees_techniques.su_trsf_shon3, ' m² <br/>') |
ELSE CONCAT('Bureaux - ', donnees_techniques.su_cstr_shon3, ' m² <br/>') |
163 |
END, |
END, |
164 |
CASE |
CASE |
165 |
WHEN donnees_techniques.su_trsf_shon4 IS NULL |
WHEN donnees_techniques.su_cstr_shon4 IS NULL |
166 |
THEN '' |
THEN '' |
167 |
ELSE CONCAT('Commerce - ', donnees_techniques.su_trsf_shon4, ' m² <br/>') |
ELSE CONCAT('Commerce - ', donnees_techniques.su_cstr_shon4, ' m² <br/>') |
168 |
END, |
END, |
169 |
CASE |
CASE |
170 |
WHEN donnees_techniques.su_trsf_shon5 IS NULL |
WHEN donnees_techniques.su_cstr_shon5 IS NULL |
171 |
THEN '' |
THEN '' |
172 |
ELSE CONCAT('Artisanat - ', donnees_techniques.su_trsf_shon5, ' m² <br/>') |
ELSE CONCAT('Artisanat - ', donnees_techniques.su_cstr_shon5, ' m² <br/>') |
173 |
END, |
END, |
174 |
CASE |
CASE |
175 |
WHEN donnees_techniques.su_trsf_shon6 IS NULL |
WHEN donnees_techniques.su_cstr_shon6 IS NULL |
176 |
THEN '' |
THEN '' |
177 |
ELSE CONCAT('Industrie - ', donnees_techniques.su_trsf_shon6, ' m² <br/>') |
ELSE CONCAT('Industrie - ', donnees_techniques.su_cstr_shon6, ' m² <br/>') |
178 |
END, |
END, |
179 |
CASE |
CASE |
180 |
WHEN donnees_techniques.su_trsf_shon7 IS NULL |
WHEN donnees_techniques.su_cstr_shon7 IS NULL |
181 |
THEN '' |
THEN '' |
182 |
ELSE CONCAT('Exploitation agricole ou forestière - ', donnees_techniques.su_trsf_shon7, ' m² <br/>') |
ELSE CONCAT('Exploitation agricole ou forestière - ', donnees_techniques.su_cstr_shon7, ' m² <br/>') |
183 |
END, |
END, |
184 |
CASE |
CASE |
185 |
WHEN donnees_techniques.su_trsf_shon8 IS NULL |
WHEN donnees_techniques.su_cstr_shon8 IS NULL |
186 |
THEN '' |
THEN '' |
187 |
ELSE CONCAT('Entrepôt - ', donnees_techniques.su_trsf_shon8, ' m² <br/>') |
ELSE CONCAT('Entrepôt - ', donnees_techniques.su_cstr_shon8, ' m² <br/>') |
188 |
END, |
END, |
189 |
CASE |
CASE |
190 |
WHEN donnees_techniques.su_trsf_shon9 IS NULL |
WHEN donnees_techniques.su_cstr_shon9 IS NULL |
191 |
THEN '' |
THEN '' |
192 |
ELSE CONCAT('Service public ou d''intérêt collectif - ', donnees_techniques.su_trsf_shon9, ' m²') |
ELSE CONCAT('Service public ou d''intérêt collectif - ', donnees_techniques.su_cstr_shon9, ' m²') |
193 |
END |
END |
194 |
), ' <br/>$', '') as \"surface\", |
), ' <br/>$', '') as \"surface\", |
195 |
co_tot_ind_nb as \"nombre_logement_crees_individuel\", |
co_tot_ind_nb as \"nombre_logement_crees_individuel\", |
350 |
) as \"description_projet\", |
) as \"description_projet\", |
351 |
REGEXP_REPLACE(CONCAT( |
REGEXP_REPLACE(CONCAT( |
352 |
CASE |
CASE |
353 |
WHEN donnees_techniques.su_trsf_shon1 IS NULL |
WHEN donnees_techniques.su_cstr_shon1 IS NULL |
354 |
THEN '' |
THEN '' |
355 |
ELSE CONCAT('Habitation - ', donnees_techniques.su_trsf_shon1, ' m² <br/>') |
ELSE CONCAT('Habitation - ', donnees_techniques.su_cstr_shon1, ' m² <br/>') |
356 |
END, |
END, |
357 |
CASE |
CASE |
358 |
WHEN donnees_techniques.su_trsf_shon2 IS NULL |
WHEN donnees_techniques.su_cstr_shon2 IS NULL |
359 |
THEN '' |
THEN '' |
360 |
ELSE CONCAT('Hébergement hôtelier - ', donnees_techniques.su_trsf_shon2, ' m² <br/>') |
ELSE CONCAT('Hébergement hôtelier - ', donnees_techniques.su_cstr_shon2, ' m² <br/>') |
361 |
END, |
END, |
362 |
CASE |
CASE |
363 |
WHEN donnees_techniques.su_trsf_shon3 IS NULL |
WHEN donnees_techniques.su_cstr_shon3 IS NULL |
364 |
THEN '' |
THEN '' |
365 |
ELSE CONCAT('Bureaux - ', donnees_techniques.su_trsf_shon3, ' m² <br/>') |
ELSE CONCAT('Bureaux - ', donnees_techniques.su_cstr_shon3, ' m² <br/>') |
366 |
END, |
END, |
367 |
CASE |
CASE |
368 |
WHEN donnees_techniques.su_trsf_shon4 IS NULL |
WHEN donnees_techniques.su_cstr_shon4 IS NULL |
369 |
THEN '' |
THEN '' |
370 |
ELSE CONCAT('Commerce - ', donnees_techniques.su_trsf_shon4, ' m² <br/>') |
ELSE CONCAT('Commerce - ', donnees_techniques.su_cstr_shon4, ' m² <br/>') |
371 |
END, |
END, |
372 |
CASE |
CASE |
373 |
WHEN donnees_techniques.su_trsf_shon5 IS NULL |
WHEN donnees_techniques.su_cstr_shon5 IS NULL |
374 |
THEN '' |
THEN '' |
375 |
ELSE CONCAT('Artisanat - ', donnees_techniques.su_trsf_shon5, ' m² <br/>') |
ELSE CONCAT('Artisanat - ', donnees_techniques.su_cstr_shon5, ' m² <br/>') |
376 |
END, |
END, |
377 |
CASE |
CASE |
378 |
WHEN donnees_techniques.su_trsf_shon6 IS NULL |
WHEN donnees_techniques.su_cstr_shon6 IS NULL |
379 |
THEN '' |
THEN '' |
380 |
ELSE CONCAT('Industrie - ', donnees_techniques.su_trsf_shon6, ' m² <br/>') |
ELSE CONCAT('Industrie - ', donnees_techniques.su_cstr_shon6, ' m² <br/>') |
381 |
END, |
END, |
382 |
CASE |
CASE |
383 |
WHEN donnees_techniques.su_trsf_shon7 IS NULL |
WHEN donnees_techniques.su_cstr_shon7 IS NULL |
384 |
THEN '' |
THEN '' |
385 |
ELSE CONCAT('Exploitation agricole ou forestière - ', donnees_techniques.su_trsf_shon7, ' m² <br/>') |
ELSE CONCAT('Exploitation agricole ou forestière - ', donnees_techniques.su_cstr_shon7, ' m² <br/>') |
386 |
END, |
END, |
387 |
CASE |
CASE |
388 |
WHEN donnees_techniques.su_trsf_shon8 IS NULL |
WHEN donnees_techniques.su_cstr_shon8 IS NULL |
389 |
THEN '' |
THEN '' |
390 |
ELSE CONCAT('Entrepôt - ', donnees_techniques.su_trsf_shon8, ' m² <br/>') |
ELSE CONCAT('Entrepôt - ', donnees_techniques.su_cstr_shon8, ' m² <br/>') |
391 |
END, |
END, |
392 |
CASE |
CASE |
393 |
WHEN donnees_techniques.su_trsf_shon9 IS NULL |
WHEN donnees_techniques.su_cstr_shon9 IS NULL |
394 |
THEN '' |
THEN '' |
395 |
ELSE CONCAT('Service public ou d''intérêt collectif - ', donnees_techniques.su_trsf_shon9, ' m²') |
ELSE CONCAT('Service public ou d''intérêt collectif - ', donnees_techniques.su_cstr_shon9, ' m²') |
396 |
END |
END |
397 |
), ' <br/>$', '') as \"surface\", |
), ' <br/>$', '') as \"surface\", |
398 |
co_tot_ind_nb as \"nombre_logement_crees_individuel\", |
co_tot_ind_nb as \"nombre_logement_crees_individuel\", |
514 |
$form->setLib("demandeur", _("Demandeur principal")); |
$form->setLib("demandeur", _("Demandeur principal")); |
515 |
$form->setLib("infos_localisation_terrain", _("infos_localisation_terrain")); |
$form->setLib("infos_localisation_terrain", _("infos_localisation_terrain")); |
516 |
$form->setLib("depot_initial", _("Depot initial")); |
$form->setLib("depot_initial", _("Depot initial")); |
517 |
$form->setLib("date_decision", _("Date de decision")); |
$form->setLib("date_decision", _("Decision initiale")); |
518 |
$form->setLib("date_validite", _("Date de validite")); |
$form->setLib("date_validite", _("Date de validite")); |
519 |
$form->setLib("date_depot_DAACT", _("Date de depot de la DAACT")); |
$form->setLib("date_depot_DAACT", _("Date de depot de la DAACT")); |
520 |
$form->setLib("date_depot_DOC", _("Date de depot de la DOC")); |
$form->setLib("date_depot_DOC", _("Date de depot de la DOC")); |