/[openfoncier]/trunk/sql/pgsql/cerfa.form.inc.php
ViewVC logotype

Contents of /trunk/sql/pgsql/cerfa.form.inc.php

Parent Directory Parent Directory | Revision Log Revision Log


Revision 4417 - (show annotations)
Tue Jun 7 13:47:38 2016 UTC (8 years, 7 months ago) by softime
File size: 11368 byte(s)
* Ajout des champs du cerfa 10072*02 dans la table cerfa et dans la
  table donnees_techniques.
1 <?php
2 //$Id: cerfa.form.inc.php 5856 2016-02-03 11:35:25Z stimezouaght $
3 //gen openMairie le 13/02/2013 14:41
4
5 include('../gen/sql/pgsql/cerfa.form.inc.php');
6
7 //Affiche les champs dans l'ordre souhaité
8 $champs=array(
9 "cerfa",
10 "libelle",
11 "code",
12 "om_validite_debut",
13 "om_validite_fin",
14 //Début fieldset 3
15 "terr_juri_titul",
16 "terr_juri_lot",
17 "terr_juri_zac",
18 "terr_juri_afu",
19 "terr_juri_pup",
20 "terr_juri_oin",
21 "terr_juri_desc",
22 "terr_div_surf_etab",
23 "terr_div_surf_av_div",
24 "ope_proj_desc",
25 "ope_proj_div_co",
26 "ope_proj_div_contr",
27
28 // ERP
29 "erp_class_cat",
30 "erp_class_type",
31 "erp_cstr_neuve",
32 "erp_trvx_acc",
33 "erp_extension",
34 "erp_rehab",
35 "erp_trvx_am",
36 "erp_vol_nouv_exist",
37 "tab_erp_eff",
38
39 //Debut premier bloc 4.1
40 "am_lotiss",
41 "am_div_mun",
42 "am_autre_div",
43 "am_camping",
44 "am_parc_resid_loi",
45 "am_sport_moto",
46 "am_sport_attrac",
47 "am_sport_golf",
48 "am_caravane",
49 "am_carav_duree",
50 "am_statio",
51 "am_statio_cont",
52 "am_affou_exhau",
53 "am_affou_exhau_sup",
54 "am_affou_prof",
55 "am_exhau_haut",
56 "am_chem_ouv_esp",
57 "am_agri_peche",
58 "am_crea_voie",
59 "am_modif_voie_exist",
60 "am_crea_esp_sauv",
61 "am_crea_esp_class",
62 "am_coupe_abat",
63 "am_prot_plu",
64 "am_prot_muni",
65 "am_mobil_voyage",
66 "am_aire_voyage",
67 "am_rememb_afu",
68 "co_ouvr_infra",
69 "am_mob_art",
70 "am_modif_voie_esp",
71 "am_plant_voie_esp",
72 "co_ouvr_elec",
73
74 //Autre champ du premier bloc, ancien cerfa
75 "am_projet_desc",
76 "am_terr_surf",
77 "am_tranche_desc",
78
79 //Fin premier bloc
80
81 //Début second bloc 4.2
82 "am_lot_max_nb",
83 "am_lot_max_shon",
84 "am_lot_cstr_cos",
85 "am_lot_cstr_plan",
86 "am_lot_cstr_vente",
87 "am_lot_fin_diff",
88 "am_lot_consign",
89 "am_lot_gar_achev",
90 "am_lot_vente_ant",
91
92
93 //Fin second bloc
94
95 //Début troisième bloc 4.3
96 "am_exist_agrand",
97 "am_exist_date",
98 "am_exist_num",
99 "am_exist_nb_avant",
100 "am_exist_nb_apres",
101 "am_empl_nb",
102 "am_tente_nb",
103 "am_carav_nb",
104 "am_mobil_nb",
105 "am_pers_nb",
106 "am_empl_hll_nb",
107 "am_hll_shon",
108 "am_periode_exploit",
109
110 "am_coupe_bois",
111 "am_coupe_parc",
112 "am_coupe_align",
113 "am_coupe_ess",
114 "am_coupe_age",
115 "am_coupe_dens",
116 "am_coupe_qual",
117 "am_coupe_trait",
118 "am_coupe_autr",
119
120
121 //Fin troisième bloc
122 //Fin premier fieldset
123 //
124 ////Début second fieldset
125 //Début premier bloc 5.1
126 "co_archi_recours",
127 "architecte",
128 //Fin premier bloc
129
130 //Début second bloc 5.2
131 "co_cstr_nouv",
132 "avap_co_elt_pro",
133 "avap_nouv_haut_surf",
134 "co_cstr_exist",
135 "co_div_terr",
136 "co_cloture",
137 "co_projet_desc",
138 "co_elec_tension",
139
140 //Fin autre champ du second fieldset, ancien cerfa
141
142 //Fin second bloc
143
144 //Début troisième bloc 5.3
145 "co_tot_log_nb",
146 "co_tot_ind_nb",
147 "co_tot_coll_nb",
148 "co_mais_piece_nb",
149 "co_mais_niv_nb",
150 "co_fin_lls_nb",
151 "co_fin_aa_nb",
152 "co_fin_ptz_nb",
153 "co_fin_autr_nb",
154 "co_fin_autr_desc",
155 "co_mais_contrat_ind",
156 "co_uti_pers",
157 "co_uti_vente",
158 "co_uti_loc",
159 "co_uti_princ",
160 "co_uti_secon",
161
162 "co_anx_pisc",
163 "co_anx_gara",
164 "co_anx_veran",
165 "co_anx_abri",
166 "co_anx_autr",
167 "co_anx_autr_desc",
168
169 "co_resid_agees",
170 "co_resid_etud",
171 "co_resid_tourism",
172 "co_resid_hot_soc",
173 "co_resid_soc",
174 "co_resid_hand",
175 "co_resid_autr",
176 "co_resid_autr_desc",
177 "co_foyer_chamb_nb",
178 "co_log_1p_nb",
179 "co_log_2p_nb",
180 "co_log_3p_nb",
181 "co_log_4p_nb",
182 "co_log_5p_nb",
183 "co_log_6p_nb",
184 "co_bat_niv_nb",
185 "co_trx_exten",
186 "co_trx_surelev",
187 "co_trx_nivsup",
188
189 //Fin autre champ du troisième fieldset, ancien cerfa
190
191 //Fin troisième bloc
192
193 //Début quatrième bloc 5.4
194 "co_demont_periode",
195 //Fin quatrième bloc
196
197 //Début cinquième bloc 5.5
198 "tab_surface",
199 "co_sp_transport",
200 "co_sp_enseign",
201 "co_sp_act_soc",
202 "co_sp_ouvr_spe",
203 "co_sp_sante",
204 "co_sp_culture",
205 //Fin cinquième bloc
206
207 //Début sixième bloc 5.6
208 //Fin sixième bloc
209
210 //Début septième bloc 5.7
211 "co_statio_avt_nb",
212 "co_statio_apr_nb",
213 "co_statio_adr",
214 "co_statio_place_nb",
215 "co_statio_tot_surf",
216 "co_statio_tot_shob",
217 "co_statio_comm_cin_surf",
218 "co_perf_energ",
219
220 //Fin septième bloc
221 //Fin second fieldset
222
223 //Fin septième bloc
224 //Fin second fieldset
225 //Début troisième fieldset
226 //Début premier bloc
227 "dm_constr_dates",
228 "dm_total",
229 "dm_partiel",
230 "dm_projet_desc",
231 "dm_tot_log_nb",
232 //Fin premier bloc
233 //Fin troisième fieldset
234 // Doc/Daact
235 "doc_date",
236 "doc_tot_trav",
237 "doc_tranche_trav",
238 "doc_tranche_trav_desc",
239 "doc_surf",
240 "doc_nb_log",
241 "doc_nb_log_indiv",
242 "doc_nb_log_coll",
243 "doc_nb_log_lls",
244 "doc_nb_log_aa",
245 "doc_nb_log_ptz",
246 "doc_nb_log_autre",
247 "daact_date",
248 "daact_date_chgmt_dest",
249 "daact_tot_trav",
250 "daact_tranche_trav",
251 "daact_tranche_trav_desc",
252 "daact_surf",
253 "daact_nb_log",
254 "daact_nb_log_indiv",
255 "daact_nb_log_coll",
256 "daact_nb_log_lls",
257 "daact_nb_log_aa",
258 "daact_nb_log_ptz",
259 "daact_nb_log_autre",
260
261 // Début DIA
262 "dia_imm_non_bati",
263 "dia_imm_bati_terr_propr",
264 "dia_imm_bati_terr_autr",
265 "dia_imm_bati_terr_autr_desc",
266 "dia_bat_copro",
267 "dia_bat_copro_desc",
268 "dia_lot_numero",
269 "dia_lot_bat",
270 "dia_lot_etage",
271 "dia_lot_quote_part",
272 "dia_us_hab",
273 "dia_us_pro",
274 "dia_us_mixte",
275 "dia_us_comm",
276 "dia_us_agr",
277 "dia_us_autre",
278 "dia_us_autre_prec",
279 "dia_occ_prop",
280 "dia_occ_loc",
281 "dia_occ_sans_occ",
282 "dia_occ_autre",
283 "dia_occ_autre_prec",
284 "dia_mod_cess_prix_vente",
285 "dia_mod_cess_prix_vente_mob",
286 "dia_mod_cess_prix_vente_cheptel",
287 "dia_mod_cess_prix_vente_recol",
288 "dia_mod_cess_prix_vente_autre",
289 "dia_mod_cess_commi",
290 "dia_mod_cess_commi_ttc",
291 "dia_mod_cess_commi_ht",
292 "dia_acquereur_nom_prenom",
293 "dia_acquereur_adr_num_voie",
294 "dia_acquereur_adr_ext",
295 "dia_acquereur_adr_type_voie",
296 "dia_acquereur_adr_nom_voie",
297 "dia_acquereur_adr_lieu_dit_bp",
298 "dia_acquereur_adr_cp",
299 "dia_acquereur_adr_localite",
300 "dia_observation",
301 // Fin DIA
302
303 "code_cnil",
304 //Début fieldset 1 des taxes
305 //Bloc 1.1
306 "tax_surf_tot_cstr",
307 "tax_surf_loc_stat",
308 "tax_surf_tot",
309 "tax_surf",
310 "tax_surf_suppr_mod",
311 //Fin bloc 1.1
312 //Bloc 1.2
313 //Bloc 1.2.1
314 "tab_tax_su_princ",
315 "tab_tax_su_secon",
316 "tab_tax_su_heber",
317 "tab_tax_su_tot",
318 //Fin bloc 1.2.1
319 //Bloc 1.2.2
320 "tax_ext_pret",
321 "tax_ext_desc",
322 "tax_surf_tax_exist_cons",
323 "tax_log_exist_nb",
324 "tax_log_ap_trvx_nb",
325 "tax_surf_abr_jard_pig_colom",
326 // Fin bloc 1.2.2
327 //Bloc 1.2.3
328 "tax_comm_nb",
329 "tab_tax_su_non_habit_surf",
330 "tab_tax_su_parc_statio_expl_comm",
331 "tax_su_non_habit_abr_jard_pig_colom",
332 //Fin bloc 1.2.3
333 //Bloc 1.3
334 "tab_tax_am",
335 "tax_am_statio_ext_cr",
336 "tax_sup_bass_pisc_cr",
337 "tax_empl_ten_carav_mobil_nb_cr",
338 "tax_empl_hll_nb_cr",
339 "tax_eol_haut_nb_cr",
340 "tax_pann_volt_sup_cr",
341 //Fin bloc 1.3
342 //Bloc 1.4
343 "tax_surf_loc_arch",
344 "tax_surf_pisc_arch",
345 "tax_am_statio_ext_arch",
346 "tax_empl_ten_carav_mobil_nb_arch",
347 "tax_empl_hll_nb_arch",
348 "tax_eol_haut_nb_arch",
349 //Fin bloc 1.4
350 //Bloc 1.5
351 "tax_trx_presc_ppr",
352 "tax_monu_hist",
353 //Fin bloc 1.5
354 //Fieldset 2 taxes
355 //Bloc 2.1
356 "vsd_surf_planch_smd",
357 "vsd_unit_fonc_sup",
358 "vsd_unit_fonc_constr_sup",
359 "vsd_val_terr",
360 "vsd_const_sxist_non_dem_surf",
361 "vsd_rescr_fisc",
362 //Fin Bloc 2.1
363 //Bloc 2.2
364 "pld_val_terr",
365 "pld_const_exist_dem",
366 "pld_const_exist_dem_surf",
367 // Autres renseignements
368 "tax_desc",
369
370 // Anciens champs
371 "co_statio_avt_shob",
372 "co_statio_apr_shob",
373 "co_statio_avt_surf",
374 "co_statio_apr_surf",
375 "co_trx_amgt",
376 "co_modif_aspect",
377 "co_modif_struct",
378 "co_trx_imm",
379 "co_cstr_shob",
380 "am_voyage_deb",
381 "am_voyage_fin",
382 "am_modif_amgt",
383 "am_lot_max_shob",
384 "mod_desc",
385 "tr_total",
386 "tr_partiel",
387 "tr_desc",
388 "avap_co_clot",
389 "avap_aut_coup_aba_arb",
390 "avap_ouv_infra",
391 "avap_aut_inst_mob",
392 "avap_aut_plant",
393 "avap_aut_auv_elec",
394 "tax_dest_loc_tr",
395 );
396
397 // liste des tableaux de surfaces
398 $tab_surface = array("" => _("Ne pas afficher cet element"), 13409 => _("Tableau du cerfa numero 13409*02"));
399 $tab_tax_su_princ = array("" => _("Ne pas afficher cet element"), 13409 => _("Tableau du cerfa numero 13409*02"), 1340903 => _("Tableau du cerfa numero 13409*03"));
400 $tab_tax_su_heber = array("" => _("Ne pas afficher cet element"), 13409 => _("Tableau du cerfa numero 13409*02"), 1340903 => _("Tableau du cerfa numero 13409*03"));
401 $tab_tax_su_secon = array("" => _("Ne pas afficher cet element"), 13409 => _("Tableau du cerfa numero 13409*02"), 1340903 => _("Tableau du cerfa numero 13409*03"));
402 $tab_tax_su_tot = array("" => _("Ne pas afficher cet element"), 13409 => _("Tableau du cerfa numero 13409*02"), 1340903 => _("Tableau du cerfa numero 13409*03"));
403 $tab_tax_su_non_habit_surf = array("" => _("Ne pas afficher cet element"), 13409 => _("Tableau du cerfa numero 13409*02"), 1340903 => _("Tableau du cerfa numero 13409*03"));
404 $tab_tax_su_parc_statio_expl_comm = array("" => _("Ne pas afficher cet element"), 1340903 => _("Tableau du cerfa numero 13409*03"));
405 $tab_tax_am = array("" => _("Ne pas afficher cet element"), 13409 => _("Tableau du cerfa numero 13409*02"));
406 $tab_erp_eff = array("" => _("Ne pas afficher cet element"), 1382403 => _("Tableau du cerfa numero 13824*03"));
407 ?>

[email protected]
ViewVC Help
Powered by ViewVC 1.1.26