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

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

Parent Directory Parent Directory | Revision Log Revision Log

Revision 14064 - (show annotations)
Thu Feb 16 22:52:47 2023 UTC (21 months, 2 weeks ago) by softime
File size: 69254 byte(s) 
chore(branch): fusion de la branche d'intégration 5.16.0-develop dans le trunk
1 <?php
2 //$Id$
3 //gen openMairie le 05/01/2023 17:39
4
5 $DEBUG=0;
6 $serie=15;
7 $ent = __("application")." -> ".__("cerfa");
8 $om_validite = true;
9 if(!isset($premier)) $premier='';
10 if(!isset($tricolsf)) $tricolsf='';
11 if(!isset($premiersf)) $premiersf='';
12 if(!isset($selection)) $selection='';
13 if(!isset($retourformulaire)) $retourformulaire='';
14 if (!isset($idxformulaire)) {
15 $idxformulaire = '';
16 }
17 if (!isset($tricol)) {
18 $tricol = '';
19 }
20 if (!isset($valide)) {
21 $valide = '';
22 }
23 // FROM
24 $table = DB_PREFIXE."cerfa";
25 // SELECT
26 $champAffiche = array(
27 'cerfa.cerfa as "'.__("cerfa").'"',
28 'cerfa.libelle as "'.__("libelle").'"',
29 'cerfa.code as "'.__("code").'"',
30 'to_char(cerfa.om_validite_debut ,\'DD/MM/YYYY\') as "'.__("om_validite_debut").'"',
31 'to_char(cerfa.om_validite_fin ,\'DD/MM/YYYY\') as "'.__("om_validite_fin").'"',
32 "case cerfa.am_lotiss when 't' then 'Oui' else 'Non' end as \"".__("am_lotiss")."\"",
33 "case cerfa.am_autre_div when 't' then 'Oui' else 'Non' end as \"".__("am_autre_div")."\"",
34 "case cerfa.am_camping when 't' then 'Oui' else 'Non' end as \"".__("am_camping")."\"",
35 "case cerfa.am_caravane when 't' then 'Oui' else 'Non' end as \"".__("am_caravane")."\"",
36 "case cerfa.am_carav_duree when 't' then 'Oui' else 'Non' end as \"".__("am_carav_duree")."\"",
37 "case cerfa.am_statio when 't' then 'Oui' else 'Non' end as \"".__("am_statio")."\"",
38 "case cerfa.am_statio_cont when 't' then 'Oui' else 'Non' end as \"".__("am_statio_cont")."\"",
39 "case cerfa.am_affou_exhau when 't' then 'Oui' else 'Non' end as \"".__("am_affou_exhau")."\"",
40 "case cerfa.am_affou_exhau_sup when 't' then 'Oui' else 'Non' end as \"".__("am_affou_exhau_sup")."\"",
41 "case cerfa.am_affou_prof when 't' then 'Oui' else 'Non' end as \"".__("am_affou_prof")."\"",
42 "case cerfa.am_exhau_haut when 't' then 'Oui' else 'Non' end as \"".__("am_exhau_haut")."\"",
43 "case cerfa.am_coupe_abat when 't' then 'Oui' else 'Non' end as \"".__("am_coupe_abat")."\"",
44 "case cerfa.am_prot_plu when 't' then 'Oui' else 'Non' end as \"".__("am_prot_plu")."\"",
45 "case cerfa.am_prot_muni when 't' then 'Oui' else 'Non' end as \"".__("am_prot_muni")."\"",
46 "case cerfa.am_mobil_voyage when 't' then 'Oui' else 'Non' end as \"".__("am_mobil_voyage")."\"",
47 "case cerfa.am_aire_voyage when 't' then 'Oui' else 'Non' end as \"".__("am_aire_voyage")."\"",
48 "case cerfa.am_rememb_afu when 't' then 'Oui' else 'Non' end as \"".__("am_rememb_afu")."\"",
49 "case cerfa.am_parc_resid_loi when 't' then 'Oui' else 'Non' end as \"".__("am_parc_resid_loi")."\"",
50 "case cerfa.am_sport_moto when 't' then 'Oui' else 'Non' end as \"".__("am_sport_moto")."\"",
51 "case cerfa.am_sport_attrac when 't' then 'Oui' else 'Non' end as \"".__("am_sport_attrac")."\"",
52 "case cerfa.am_sport_golf when 't' then 'Oui' else 'Non' end as \"".__("am_sport_golf")."\"",
53 "case cerfa.am_mob_art when 't' then 'Oui' else 'Non' end as \"".__("am_mob_art")."\"",
54 "case cerfa.am_modif_voie_esp when 't' then 'Oui' else 'Non' end as \"".__("am_modif_voie_esp")."\"",
55 "case cerfa.am_plant_voie_esp when 't' then 'Oui' else 'Non' end as \"".__("am_plant_voie_esp")."\"",
56 "case cerfa.am_chem_ouv_esp when 't' then 'Oui' else 'Non' end as \"".__("am_chem_ouv_esp")."\"",
57 "case cerfa.am_agri_peche when 't' then 'Oui' else 'Non' end as \"".__("am_agri_peche")."\"",
58 "case cerfa.am_crea_voie when 't' then 'Oui' else 'Non' end as \"".__("am_crea_voie")."\"",
59 "case cerfa.am_modif_voie_exist when 't' then 'Oui' else 'Non' end as \"".__("am_modif_voie_exist")."\"",
60 "case cerfa.am_crea_esp_sauv when 't' then 'Oui' else 'Non' end as \"".__("am_crea_esp_sauv")."\"",
61 "case cerfa.am_crea_esp_class when 't' then 'Oui' else 'Non' end as \"".__("am_crea_esp_class")."\"",
62 "case cerfa.am_projet_desc when 't' then 'Oui' else 'Non' end as \"".__("am_projet_desc")."\"",
63 "case cerfa.am_terr_surf when 't' then 'Oui' else 'Non' end as \"".__("am_terr_surf")."\"",
64 "case cerfa.am_tranche_desc when 't' then 'Oui' else 'Non' end as \"".__("am_tranche_desc")."\"",
65 "case cerfa.am_lot_max_nb when 't' then 'Oui' else 'Non' end as \"".__("am_lot_max_nb")."\"",
66 "case cerfa.am_lot_max_shon when 't' then 'Oui' else 'Non' end as \"".__("am_lot_max_shon")."\"",
67 "case cerfa.am_lot_cstr_cos when 't' then 'Oui' else 'Non' end as \"".__("am_lot_cstr_cos")."\"",
68 "case cerfa.am_lot_cstr_plan when 't' then 'Oui' else 'Non' end as \"".__("am_lot_cstr_plan")."\"",
69 "case cerfa.am_lot_cstr_vente when 't' then 'Oui' else 'Non' end as \"".__("am_lot_cstr_vente")."\"",
70 "case cerfa.am_lot_fin_diff when 't' then 'Oui' else 'Non' end as \"".__("am_lot_fin_diff")."\"",
71 "case cerfa.am_lot_consign when 't' then 'Oui' else 'Non' end as \"".__("am_lot_consign")."\"",
72 "case cerfa.am_lot_gar_achev when 't' then 'Oui' else 'Non' end as \"".__("am_lot_gar_achev")."\"",
73 "case cerfa.am_lot_vente_ant when 't' then 'Oui' else 'Non' end as \"".__("am_lot_vente_ant")."\"",
74 "case cerfa.am_empl_nb when 't' then 'Oui' else 'Non' end as \"".__("am_empl_nb")."\"",
75 "case cerfa.am_tente_nb when 't' then 'Oui' else 'Non' end as \"".__("am_tente_nb")."\"",
76 "case cerfa.am_carav_nb when 't' then 'Oui' else 'Non' end as \"".__("am_carav_nb")."\"",
77 "case cerfa.am_mobil_nb when 't' then 'Oui' else 'Non' end as \"".__("am_mobil_nb")."\"",
78 "case cerfa.am_pers_nb when 't' then 'Oui' else 'Non' end as \"".__("am_pers_nb")."\"",
79 "case cerfa.am_empl_hll_nb when 't' then 'Oui' else 'Non' end as \"".__("am_empl_hll_nb")."\"",
80 "case cerfa.am_hll_shon when 't' then 'Oui' else 'Non' end as \"".__("am_hll_shon")."\"",
81 "case cerfa.am_periode_exploit when 't' then 'Oui' else 'Non' end as \"".__("am_periode_exploit")."\"",
82 "case cerfa.am_exist_agrand when 't' then 'Oui' else 'Non' end as \"".__("am_exist_agrand")."\"",
83 "case cerfa.am_exist_date when 't' then 'Oui' else 'Non' end as \"".__("am_exist_date")."\"",
84 "case cerfa.am_exist_num when 't' then 'Oui' else 'Non' end as \"".__("am_exist_num")."\"",
85 "case cerfa.am_exist_nb_avant when 't' then 'Oui' else 'Non' end as \"".__("am_exist_nb_avant")."\"",
86 "case cerfa.am_exist_nb_apres when 't' then 'Oui' else 'Non' end as \"".__("am_exist_nb_apres")."\"",
87 "case cerfa.am_coupe_bois when 't' then 'Oui' else 'Non' end as \"".__("am_coupe_bois")."\"",
88 "case cerfa.am_coupe_parc when 't' then 'Oui' else 'Non' end as \"".__("am_coupe_parc")."\"",
89 "case cerfa.am_coupe_align when 't' then 'Oui' else 'Non' end as \"".__("am_coupe_align")."\"",
90 "case cerfa.am_coupe_ess when 't' then 'Oui' else 'Non' end as \"".__("am_coupe_ess")."\"",
91 "case cerfa.am_coupe_age when 't' then 'Oui' else 'Non' end as \"".__("am_coupe_age")."\"",
92 "case cerfa.am_coupe_dens when 't' then 'Oui' else 'Non' end as \"".__("am_coupe_dens")."\"",
93 "case cerfa.am_coupe_qual when 't' then 'Oui' else 'Non' end as \"".__("am_coupe_qual")."\"",
94 "case cerfa.am_coupe_trait when 't' then 'Oui' else 'Non' end as \"".__("am_coupe_trait")."\"",
95 "case cerfa.am_coupe_autr when 't' then 'Oui' else 'Non' end as \"".__("am_coupe_autr")."\"",
96 "case cerfa.co_archi_recours when 't' then 'Oui' else 'Non' end as \"".__("co_archi_recours")."\"",
97 "case cerfa.co_cstr_nouv when 't' then 'Oui' else 'Non' end as \"".__("co_cstr_nouv")."\"",
98 "case cerfa.co_cstr_exist when 't' then 'Oui' else 'Non' end as \"".__("co_cstr_exist")."\"",
99 "case cerfa.co_cloture when 't' then 'Oui' else 'Non' end as \"".__("co_cloture")."\"",
100 "case cerfa.co_elec_tension when 't' then 'Oui' else 'Non' end as \"".__("co_elec_tension")."\"",
101 "case cerfa.co_div_terr when 't' then 'Oui' else 'Non' end as \"".__("co_div_terr")."\"",
102 "case cerfa.co_projet_desc when 't' then 'Oui' else 'Non' end as \"".__("co_projet_desc")."\"",
103 "case cerfa.co_anx_pisc when 't' then 'Oui' else 'Non' end as \"".__("co_anx_pisc")."\"",
104 "case cerfa.co_anx_gara when 't' then 'Oui' else 'Non' end as \"".__("co_anx_gara")."\"",
105 "case cerfa.co_anx_veran when 't' then 'Oui' else 'Non' end as \"".__("co_anx_veran")."\"",
106 "case cerfa.co_anx_abri when 't' then 'Oui' else 'Non' end as \"".__("co_anx_abri")."\"",
107 "case cerfa.co_anx_autr when 't' then 'Oui' else 'Non' end as \"".__("co_anx_autr")."\"",
108 "case cerfa.co_anx_autr_desc when 't' then 'Oui' else 'Non' end as \"".__("co_anx_autr_desc")."\"",
109 "case cerfa.co_tot_log_nb when 't' then 'Oui' else 'Non' end as \"".__("co_tot_log_nb")."\"",
110 "case cerfa.co_tot_ind_nb when 't' then 'Oui' else 'Non' end as \"".__("co_tot_ind_nb")."\"",
111 "case cerfa.co_tot_coll_nb when 't' then 'Oui' else 'Non' end as \"".__("co_tot_coll_nb")."\"",
112 "case cerfa.co_mais_piece_nb when 't' then 'Oui' else 'Non' end as \"".__("co_mais_piece_nb")."\"",
113 "case cerfa.co_mais_niv_nb when 't' then 'Oui' else 'Non' end as \"".__("co_mais_niv_nb")."\"",
114 "case cerfa.co_fin_lls_nb when 't' then 'Oui' else 'Non' end as \"".__("co_fin_lls_nb")."\"",
115 "case cerfa.co_fin_aa_nb when 't' then 'Oui' else 'Non' end as \"".__("co_fin_aa_nb")."\"",
116 "case cerfa.co_fin_ptz_nb when 't' then 'Oui' else 'Non' end as \"".__("co_fin_ptz_nb")."\"",
117 "case cerfa.co_fin_autr_nb when 't' then 'Oui' else 'Non' end as \"".__("co_fin_autr_nb")."\"",
118 "case cerfa.co_fin_autr_desc when 't' then 'Oui' else 'Non' end as \"".__("co_fin_autr_desc")."\"",
119 "case cerfa.co_mais_contrat_ind when 't' then 'Oui' else 'Non' end as \"".__("co_mais_contrat_ind")."\"",
120 "case cerfa.co_uti_pers when 't' then 'Oui' else 'Non' end as \"".__("co_uti_pers")."\"",
121 "case cerfa.co_uti_vente when 't' then 'Oui' else 'Non' end as \"".__("co_uti_vente")."\"",
122 "case cerfa.co_uti_loc when 't' then 'Oui' else 'Non' end as \"".__("co_uti_loc")."\"",
123 "case cerfa.co_uti_princ when 't' then 'Oui' else 'Non' end as \"".__("co_uti_princ")."\"",
124 "case cerfa.co_uti_secon when 't' then 'Oui' else 'Non' end as \"".__("co_uti_secon")."\"",
125 "case cerfa.co_resid_agees when 't' then 'Oui' else 'Non' end as \"".__("co_resid_agees")."\"",
126 "case cerfa.co_resid_etud when 't' then 'Oui' else 'Non' end as \"".__("co_resid_etud")."\"",
127 "case cerfa.co_resid_tourism when 't' then 'Oui' else 'Non' end as \"".__("co_resid_tourism")."\"",
128 "case cerfa.co_resid_hot_soc when 't' then 'Oui' else 'Non' end as \"".__("co_resid_hot_soc")."\"",
129 "case cerfa.co_resid_soc when 't' then 'Oui' else 'Non' end as \"".__("co_resid_soc")."\"",
130 "case cerfa.co_resid_hand when 't' then 'Oui' else 'Non' end as \"".__("co_resid_hand")."\"",
131 "case cerfa.co_resid_autr when 't' then 'Oui' else 'Non' end as \"".__("co_resid_autr")."\"",
132 "case cerfa.co_resid_autr_desc when 't' then 'Oui' else 'Non' end as \"".__("co_resid_autr_desc")."\"",
133 "case cerfa.co_foyer_chamb_nb when 't' then 'Oui' else 'Non' end as \"".__("co_foyer_chamb_nb")."\"",
134 "case cerfa.co_log_1p_nb when 't' then 'Oui' else 'Non' end as \"".__("co_log_1p_nb")."\"",
135 "case cerfa.co_log_2p_nb when 't' then 'Oui' else 'Non' end as \"".__("co_log_2p_nb")."\"",
136 "case cerfa.co_log_3p_nb when 't' then 'Oui' else 'Non' end as \"".__("co_log_3p_nb")."\"",
137 "case cerfa.co_log_4p_nb when 't' then 'Oui' else 'Non' end as \"".__("co_log_4p_nb")."\"",
138 "case cerfa.co_log_5p_nb when 't' then 'Oui' else 'Non' end as \"".__("co_log_5p_nb")."\"",
139 "case cerfa.co_log_6p_nb when 't' then 'Oui' else 'Non' end as \"".__("co_log_6p_nb")."\"",
140 "case cerfa.co_bat_niv_nb when 't' then 'Oui' else 'Non' end as \"".__("co_bat_niv_nb")."\"",
141 "case cerfa.co_trx_exten when 't' then 'Oui' else 'Non' end as \"".__("co_trx_exten")."\"",
142 "case cerfa.co_trx_surelev when 't' then 'Oui' else 'Non' end as \"".__("co_trx_surelev")."\"",
143 "case cerfa.co_trx_nivsup when 't' then 'Oui' else 'Non' end as \"".__("co_trx_nivsup")."\"",
144 "case cerfa.co_demont_periode when 't' then 'Oui' else 'Non' end as \"".__("co_demont_periode")."\"",
145 "case cerfa.co_sp_transport when 't' then 'Oui' else 'Non' end as \"".__("co_sp_transport")."\"",
146 "case cerfa.co_sp_enseign when 't' then 'Oui' else 'Non' end as \"".__("co_sp_enseign")."\"",
147 "case cerfa.co_sp_act_soc when 't' then 'Oui' else 'Non' end as \"".__("co_sp_act_soc")."\"",
148 "case cerfa.co_sp_ouvr_spe when 't' then 'Oui' else 'Non' end as \"".__("co_sp_ouvr_spe")."\"",
149 "case cerfa.co_sp_sante when 't' then 'Oui' else 'Non' end as \"".__("co_sp_sante")."\"",
150 "case cerfa.co_sp_culture when 't' then 'Oui' else 'Non' end as \"".__("co_sp_culture")."\"",
151 "case cerfa.co_statio_avt_nb when 't' then 'Oui' else 'Non' end as \"".__("co_statio_avt_nb")."\"",
152 "case cerfa.co_statio_apr_nb when 't' then 'Oui' else 'Non' end as \"".__("co_statio_apr_nb")."\"",
153 "case cerfa.co_statio_adr when 't' then 'Oui' else 'Non' end as \"".__("co_statio_adr")."\"",
154 "case cerfa.co_statio_place_nb when 't' then 'Oui' else 'Non' end as \"".__("co_statio_place_nb")."\"",
155 "case cerfa.co_statio_tot_surf when 't' then 'Oui' else 'Non' end as \"".__("co_statio_tot_surf")."\"",
156 "case cerfa.co_statio_tot_shob when 't' then 'Oui' else 'Non' end as \"".__("co_statio_tot_shob")."\"",
157 "case cerfa.co_statio_comm_cin_surf when 't' then 'Oui' else 'Non' end as \"".__("co_statio_comm_cin_surf")."\"",
158 'cerfa.tab_surface as "'.__("tab_surface").'"',
159 "case cerfa.dm_constr_dates when 't' then 'Oui' else 'Non' end as \"".__("dm_constr_dates")."\"",
160 "case cerfa.dm_total when 't' then 'Oui' else 'Non' end as \"".__("dm_total")."\"",
161 "case cerfa.dm_partiel when 't' then 'Oui' else 'Non' end as \"".__("dm_partiel")."\"",
162 "case cerfa.dm_projet_desc when 't' then 'Oui' else 'Non' end as \"".__("dm_projet_desc")."\"",
163 "case cerfa.dm_tot_log_nb when 't' then 'Oui' else 'Non' end as \"".__("dm_tot_log_nb")."\"",
164 "case cerfa.tax_surf_tot when 't' then 'Oui' else 'Non' end as \"".__("tax_surf_tot")."\"",
165 "case cerfa.tax_surf when 't' then 'Oui' else 'Non' end as \"".__("tax_surf")."\"",
166 "case cerfa.tax_surf_suppr_mod when 't' then 'Oui' else 'Non' end as \"".__("tax_surf_suppr_mod")."\"",
167 'cerfa.tab_tax_su_princ as "'.__("tab_tax_su_princ").'"',
168 'cerfa.tab_tax_su_heber as "'.__("tab_tax_su_heber").'"',
169 'cerfa.tab_tax_su_secon as "'.__("tab_tax_su_secon").'"',
170 'cerfa.tab_tax_su_tot as "'.__("tab_tax_su_tot").'"',
171 "case cerfa.tax_ext_pret when 't' then 'Oui' else 'Non' end as \"".__("tax_ext_pret")."\"",
172 "case cerfa.tax_ext_desc when 't' then 'Oui' else 'Non' end as \"".__("tax_ext_desc")."\"",
173 "case cerfa.tax_surf_tax_exist_cons when 't' then 'Oui' else 'Non' end as \"".__("tax_surf_tax_exist_cons")."\"",
174 "case cerfa.tax_log_exist_nb when 't' then 'Oui' else 'Non' end as \"".__("tax_log_exist_nb")."\"",
175 "case cerfa.tax_trx_presc_ppr when 't' then 'Oui' else 'Non' end as \"".__("tax_trx_presc_ppr")."\"",
176 "case cerfa.tax_monu_hist when 't' then 'Oui' else 'Non' end as \"".__("tax_monu_hist")."\"",
177 "case cerfa.tax_comm_nb when 't' then 'Oui' else 'Non' end as \"".__("tax_comm_nb")."\"",
178 'cerfa.tab_tax_su_non_habit_surf as "'.__("tab_tax_su_non_habit_surf").'"',
179 'cerfa.tab_tax_am as "'.__("tab_tax_am").'"',
180 "case cerfa.vsd_surf_planch_smd when 't' then 'Oui' else 'Non' end as \"".__("vsd_surf_planch_smd")."\"",
181 "case cerfa.vsd_unit_fonc_sup when 't' then 'Oui' else 'Non' end as \"".__("vsd_unit_fonc_sup")."\"",
182 "case cerfa.vsd_unit_fonc_constr_sup when 't' then 'Oui' else 'Non' end as \"".__("vsd_unit_fonc_constr_sup")."\"",
183 "case cerfa.vsd_val_terr when 't' then 'Oui' else 'Non' end as \"".__("vsd_val_terr")."\"",
184 "case cerfa.vsd_const_sxist_non_dem_surf when 't' then 'Oui' else 'Non' end as \"".__("vsd_const_sxist_non_dem_surf")."\"",
185 "case cerfa.vsd_rescr_fisc when 't' then 'Oui' else 'Non' end as \"".__("vsd_rescr_fisc")."\"",
186 "case cerfa.pld_val_terr when 't' then 'Oui' else 'Non' end as \"".__("pld_val_terr")."\"",
187 "case cerfa.pld_const_exist_dem when 't' then 'Oui' else 'Non' end as \"".__("pld_const_exist_dem")."\"",
188 "case cerfa.pld_const_exist_dem_surf when 't' then 'Oui' else 'Non' end as \"".__("pld_const_exist_dem_surf")."\"",
189 "case cerfa.code_cnil when 't' then 'Oui' else 'Non' end as \"".__("code_cnil")."\"",
190 "case cerfa.terr_juri_titul when 't' then 'Oui' else 'Non' end as \"".__("terr_juri_titul")."\"",
191 "case cerfa.terr_juri_lot when 't' then 'Oui' else 'Non' end as \"".__("terr_juri_lot")."\"",
192 "case cerfa.terr_juri_zac when 't' then 'Oui' else 'Non' end as \"".__("terr_juri_zac")."\"",
193 "case cerfa.terr_juri_afu when 't' then 'Oui' else 'Non' end as \"".__("terr_juri_afu")."\"",
194 "case cerfa.terr_juri_pup when 't' then 'Oui' else 'Non' end as \"".__("terr_juri_pup")."\"",
195 "case cerfa.terr_juri_oin when 't' then 'Oui' else 'Non' end as \"".__("terr_juri_oin")."\"",
196 "case cerfa.terr_juri_desc when 't' then 'Oui' else 'Non' end as \"".__("terr_juri_desc")."\"",
197 "case cerfa.terr_div_surf_etab when 't' then 'Oui' else 'Non' end as \"".__("terr_div_surf_etab")."\"",
198 "case cerfa.terr_div_surf_av_div when 't' then 'Oui' else 'Non' end as \"".__("terr_div_surf_av_div")."\"",
199 "case cerfa.doc_date when 't' then 'Oui' else 'Non' end as \"".__("doc_date")."\"",
200 "case cerfa.doc_tot_trav when 't' then 'Oui' else 'Non' end as \"".__("doc_tot_trav")."\"",
201 "case cerfa.doc_tranche_trav when 't' then 'Oui' else 'Non' end as \"".__("doc_tranche_trav")."\"",
202 "case cerfa.doc_tranche_trav_desc when 't' then 'Oui' else 'Non' end as \"".__("doc_tranche_trav_desc")."\"",
203 "case cerfa.doc_surf when 't' then 'Oui' else 'Non' end as \"".__("doc_surf")."\"",
204 "case cerfa.doc_nb_log when 't' then 'Oui' else 'Non' end as \"".__("doc_nb_log")."\"",
205 "case cerfa.doc_nb_log_indiv when 't' then 'Oui' else 'Non' end as \"".__("doc_nb_log_indiv")."\"",
206 "case cerfa.doc_nb_log_coll when 't' then 'Oui' else 'Non' end as \"".__("doc_nb_log_coll")."\"",
207 "case cerfa.doc_nb_log_lls when 't' then 'Oui' else 'Non' end as \"".__("doc_nb_log_lls")."\"",
208 "case cerfa.doc_nb_log_aa when 't' then 'Oui' else 'Non' end as \"".__("doc_nb_log_aa")."\"",
209 "case cerfa.doc_nb_log_ptz when 't' then 'Oui' else 'Non' end as \"".__("doc_nb_log_ptz")."\"",
210 "case cerfa.doc_nb_log_autre when 't' then 'Oui' else 'Non' end as \"".__("doc_nb_log_autre")."\"",
211 "case cerfa.daact_date when 't' then 'Oui' else 'Non' end as \"".__("daact_date")."\"",
212 "case cerfa.daact_date_chgmt_dest when 't' then 'Oui' else 'Non' end as \"".__("daact_date_chgmt_dest")."\"",
213 "case cerfa.daact_tot_trav when 't' then 'Oui' else 'Non' end as \"".__("daact_tot_trav")."\"",
214 "case cerfa.daact_tranche_trav when 't' then 'Oui' else 'Non' end as \"".__("daact_tranche_trav")."\"",
215 "case cerfa.daact_tranche_trav_desc when 't' then 'Oui' else 'Non' end as \"".__("daact_tranche_trav_desc")."\"",
216 "case cerfa.daact_surf when 't' then 'Oui' else 'Non' end as \"".__("daact_surf")."\"",
217 "case cerfa.daact_nb_log when 't' then 'Oui' else 'Non' end as \"".__("daact_nb_log")."\"",
218 "case cerfa.daact_nb_log_indiv when 't' then 'Oui' else 'Non' end as \"".__("daact_nb_log_indiv")."\"",
219 "case cerfa.daact_nb_log_coll when 't' then 'Oui' else 'Non' end as \"".__("daact_nb_log_coll")."\"",
220 "case cerfa.daact_nb_log_lls when 't' then 'Oui' else 'Non' end as \"".__("daact_nb_log_lls")."\"",
221 "case cerfa.daact_nb_log_aa when 't' then 'Oui' else 'Non' end as \"".__("daact_nb_log_aa")."\"",
222 "case cerfa.daact_nb_log_ptz when 't' then 'Oui' else 'Non' end as \"".__("daact_nb_log_ptz")."\"",
223 "case cerfa.daact_nb_log_autre when 't' then 'Oui' else 'Non' end as \"".__("daact_nb_log_autre")."\"",
224 "case cerfa.am_div_mun when 't' then 'Oui' else 'Non' end as \"".__("am_div_mun")."\"",
225 "case cerfa.co_perf_energ when 't' then 'Oui' else 'Non' end as \"".__("co_perf_energ")."\"",
226 "case cerfa.architecte when 't' then 'Oui' else 'Non' end as \"".__("architecte")."\"",
227 "case cerfa.co_statio_avt_shob when 't' then 'Oui' else 'Non' end as \"".__("co_statio_avt_shob")."\"",
228 "case cerfa.co_statio_apr_shob when 't' then 'Oui' else 'Non' end as \"".__("co_statio_apr_shob")."\"",
229 "case cerfa.co_statio_avt_surf when 't' then 'Oui' else 'Non' end as \"".__("co_statio_avt_surf")."\"",
230 "case cerfa.co_statio_apr_surf when 't' then 'Oui' else 'Non' end as \"".__("co_statio_apr_surf")."\"",
231 "case cerfa.co_trx_amgt when 't' then 'Oui' else 'Non' end as \"".__("co_trx_amgt")."\"",
232 "case cerfa.co_modif_aspect when 't' then 'Oui' else 'Non' end as \"".__("co_modif_aspect")."\"",
233 "case cerfa.co_modif_struct when 't' then 'Oui' else 'Non' end as \"".__("co_modif_struct")."\"",
234 "case cerfa.co_ouvr_elec when 't' then 'Oui' else 'Non' end as \"".__("co_ouvr_elec")."\"",
235 "case cerfa.co_ouvr_infra when 't' then 'Oui' else 'Non' end as \"".__("co_ouvr_infra")."\"",
236 "case cerfa.co_trx_imm when 't' then 'Oui' else 'Non' end as \"".__("co_trx_imm")."\"",
237 "case cerfa.co_cstr_shob when 't' then 'Oui' else 'Non' end as \"".__("co_cstr_shob")."\"",
238 "case cerfa.am_voyage_deb when 't' then 'Oui' else 'Non' end as \"".__("am_voyage_deb")."\"",
239 "case cerfa.am_voyage_fin when 't' then 'Oui' else 'Non' end as \"".__("am_voyage_fin")."\"",
240 "case cerfa.am_modif_amgt when 't' then 'Oui' else 'Non' end as \"".__("am_modif_amgt")."\"",
241 "case cerfa.am_lot_max_shob when 't' then 'Oui' else 'Non' end as \"".__("am_lot_max_shob")."\"",
242 "case cerfa.mod_desc when 't' then 'Oui' else 'Non' end as \"".__("mod_desc")."\"",
243 "case cerfa.tr_total when 't' then 'Oui' else 'Non' end as \"".__("tr_total")."\"",
244 "case cerfa.tr_partiel when 't' then 'Oui' else 'Non' end as \"".__("tr_partiel")."\"",
245 "case cerfa.tr_desc when 't' then 'Oui' else 'Non' end as \"".__("tr_desc")."\"",
246 "case cerfa.avap_co_elt_pro when 't' then 'Oui' else 'Non' end as \"".__("avap_co_elt_pro")."\"",
247 "case cerfa.avap_nouv_haut_surf when 't' then 'Oui' else 'Non' end as \"".__("avap_nouv_haut_surf")."\"",
248 "case cerfa.avap_co_clot when 't' then 'Oui' else 'Non' end as \"".__("avap_co_clot")."\"",
249 "case cerfa.avap_aut_coup_aba_arb when 't' then 'Oui' else 'Non' end as \"".__("avap_aut_coup_aba_arb")."\"",
250 "case cerfa.avap_ouv_infra when 't' then 'Oui' else 'Non' end as \"".__("avap_ouv_infra")."\"",
251 "case cerfa.avap_aut_inst_mob when 't' then 'Oui' else 'Non' end as \"".__("avap_aut_inst_mob")."\"",
252 "case cerfa.avap_aut_plant when 't' then 'Oui' else 'Non' end as \"".__("avap_aut_plant")."\"",
253 "case cerfa.avap_aut_auv_elec when 't' then 'Oui' else 'Non' end as \"".__("avap_aut_auv_elec")."\"",
254 "case cerfa.tax_dest_loc_tr when 't' then 'Oui' else 'Non' end as \"".__("tax_dest_loc_tr")."\"",
255 "case cerfa.ope_proj_desc when 't' then 'Oui' else 'Non' end as \"".__("ope_proj_desc")."\"",
256 "case cerfa.tax_surf_tot_cstr when 't' then 'Oui' else 'Non' end as \"".__("tax_surf_tot_cstr")."\"",
257 "case cerfa.tax_surf_loc_stat when 't' then 'Oui' else 'Non' end as \"".__("tax_surf_loc_stat")."\"",
258 "case cerfa.tax_log_ap_trvx_nb when 't' then 'Oui' else 'Non' end as \"".__("tax_log_ap_trvx_nb")."\"",
259 "case cerfa.tax_am_statio_ext_cr when 't' then 'Oui' else 'Non' end as \"".__("tax_am_statio_ext_cr")."\"",
260 "case cerfa.tax_sup_bass_pisc_cr when 't' then 'Oui' else 'Non' end as \"".__("tax_sup_bass_pisc_cr")."\"",
261 "case cerfa.tax_empl_ten_carav_mobil_nb_cr when 't' then 'Oui' else 'Non' end as \"".__("tax_empl_ten_carav_mobil_nb_cr")."\"",
262 "case cerfa.tax_empl_hll_nb_cr when 't' then 'Oui' else 'Non' end as \"".__("tax_empl_hll_nb_cr")."\"",
263 "case cerfa.tax_eol_haut_nb_cr when 't' then 'Oui' else 'Non' end as \"".__("tax_eol_haut_nb_cr")."\"",
264 "case cerfa.tax_pann_volt_sup_cr when 't' then 'Oui' else 'Non' end as \"".__("tax_pann_volt_sup_cr")."\"",
265 "case cerfa.tax_surf_loc_arch when 't' then 'Oui' else 'Non' end as \"".__("tax_surf_loc_arch")."\"",
266 "case cerfa.tax_surf_pisc_arch when 't' then 'Oui' else 'Non' end as \"".__("tax_surf_pisc_arch")."\"",
267 "case cerfa.tax_am_statio_ext_arch when 't' then 'Oui' else 'Non' end as \"".__("tax_am_statio_ext_arch")."\"",
268 'cerfa.tab_tax_su_parc_statio_expl_comm as "'.__("tab_tax_su_parc_statio_expl_comm").'"',
269 "case cerfa.tax_empl_ten_carav_mobil_nb_arch when 't' then 'Oui' else 'Non' end as \"".__("tax_empl_ten_carav_mobil_nb_arch")."\"",
270 "case cerfa.tax_empl_hll_nb_arch when 't' then 'Oui' else 'Non' end as \"".__("tax_empl_hll_nb_arch")."\"",
271 "case cerfa.tax_eol_haut_nb_arch when 't' then 'Oui' else 'Non' end as \"".__("tax_eol_haut_nb_arch")."\"",
272 "case cerfa.ope_proj_div_co when 't' then 'Oui' else 'Non' end as \"".__("ope_proj_div_co")."\"",
273 "case cerfa.ope_proj_div_contr when 't' then 'Oui' else 'Non' end as \"".__("ope_proj_div_contr")."\"",
274 "case cerfa.tax_desc when 't' then 'Oui' else 'Non' end as \"".__("tax_desc")."\"",
275 "case cerfa.erp_cstr_neuve when 't' then 'Oui' else 'Non' end as \"".__("erp_cstr_neuve")."\"",
276 "case cerfa.erp_trvx_acc when 't' then 'Oui' else 'Non' end as \"".__("erp_trvx_acc")."\"",
277 "case cerfa.erp_extension when 't' then 'Oui' else 'Non' end as \"".__("erp_extension")."\"",
278 "case cerfa.erp_rehab when 't' then 'Oui' else 'Non' end as \"".__("erp_rehab")."\"",
279 "case cerfa.erp_trvx_am when 't' then 'Oui' else 'Non' end as \"".__("erp_trvx_am")."\"",
280 "case cerfa.erp_vol_nouv_exist when 't' then 'Oui' else 'Non' end as \"".__("erp_vol_nouv_exist")."\"",
281 'cerfa.tab_erp_eff as "'.__("tab_erp_eff").'"',
282 "case cerfa.erp_class_cat when 't' then 'Oui' else 'Non' end as \"".__("erp_class_cat")."\"",
283 "case cerfa.erp_class_type when 't' then 'Oui' else 'Non' end as \"".__("erp_class_type")."\"",
284 "case cerfa.tax_surf_abr_jard_pig_colom when 't' then 'Oui' else 'Non' end as \"".__("tax_surf_abr_jard_pig_colom")."\"",
285 "case cerfa.tax_su_non_habit_abr_jard_pig_colom when 't' then 'Oui' else 'Non' end as \"".__("tax_su_non_habit_abr_jard_pig_colom")."\"",
286 "case cerfa.dia_imm_non_bati when 't' then 'Oui' else 'Non' end as \"".__("dia_imm_non_bati")."\"",
287 "case cerfa.dia_imm_bati_terr_propr when 't' then 'Oui' else 'Non' end as \"".__("dia_imm_bati_terr_propr")."\"",
288 "case cerfa.dia_imm_bati_terr_autr when 't' then 'Oui' else 'Non' end as \"".__("dia_imm_bati_terr_autr")."\"",
289 "case cerfa.dia_imm_bati_terr_autr_desc when 't' then 'Oui' else 'Non' end as \"".__("dia_imm_bati_terr_autr_desc")."\"",
290 "case cerfa.dia_bat_copro when 't' then 'Oui' else 'Non' end as \"".__("dia_bat_copro")."\"",
291 "case cerfa.dia_bat_copro_desc when 't' then 'Oui' else 'Non' end as \"".__("dia_bat_copro_desc")."\"",
292 "case cerfa.dia_lot_numero when 't' then 'Oui' else 'Non' end as \"".__("dia_lot_numero")."\"",
293 "case cerfa.dia_lot_bat when 't' then 'Oui' else 'Non' end as \"".__("dia_lot_bat")."\"",
294 "case cerfa.dia_lot_etage when 't' then 'Oui' else 'Non' end as \"".__("dia_lot_etage")."\"",
295 "case cerfa.dia_lot_quote_part when 't' then 'Oui' else 'Non' end as \"".__("dia_lot_quote_part")."\"",
296 "case cerfa.dia_us_hab when 't' then 'Oui' else 'Non' end as \"".__("dia_us_hab")."\"",
297 "case cerfa.dia_us_pro when 't' then 'Oui' else 'Non' end as \"".__("dia_us_pro")."\"",
298 "case cerfa.dia_us_mixte when 't' then 'Oui' else 'Non' end as \"".__("dia_us_mixte")."\"",
299 "case cerfa.dia_us_comm when 't' then 'Oui' else 'Non' end as \"".__("dia_us_comm")."\"",
300 "case cerfa.dia_us_agr when 't' then 'Oui' else 'Non' end as \"".__("dia_us_agr")."\"",
301 "case cerfa.dia_us_autre when 't' then 'Oui' else 'Non' end as \"".__("dia_us_autre")."\"",
302 "case cerfa.dia_us_autre_prec when 't' then 'Oui' else 'Non' end as \"".__("dia_us_autre_prec")."\"",
303 "case cerfa.dia_occ_prop when 't' then 'Oui' else 'Non' end as \"".__("dia_occ_prop")."\"",
304 "case cerfa.dia_occ_loc when 't' then 'Oui' else 'Non' end as \"".__("dia_occ_loc")."\"",
305 "case cerfa.dia_occ_sans_occ when 't' then 'Oui' else 'Non' end as \"".__("dia_occ_sans_occ")."\"",
306 "case cerfa.dia_occ_autre when 't' then 'Oui' else 'Non' end as \"".__("dia_occ_autre")."\"",
307 "case cerfa.dia_occ_autre_prec when 't' then 'Oui' else 'Non' end as \"".__("dia_occ_autre_prec")."\"",
308 "case cerfa.dia_mod_cess_prix_vente when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_prix_vente")."\"",
309 "case cerfa.dia_mod_cess_prix_vente_mob when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_prix_vente_mob")."\"",
310 "case cerfa.dia_mod_cess_prix_vente_cheptel when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_prix_vente_cheptel")."\"",
311 "case cerfa.dia_mod_cess_prix_vente_recol when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_prix_vente_recol")."\"",
312 "case cerfa.dia_mod_cess_prix_vente_autre when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_prix_vente_autre")."\"",
313 "case cerfa.dia_mod_cess_commi when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_commi")."\"",
314 "case cerfa.dia_mod_cess_commi_ttc when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_commi_ttc")."\"",
315 "case cerfa.dia_mod_cess_commi_ht when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_commi_ht")."\"",
316 "case cerfa.dia_acquereur_nom_prenom when 't' then 'Oui' else 'Non' end as \"".__("dia_acquereur_nom_prenom")."\"",
317 "case cerfa.dia_acquereur_adr_num_voie when 't' then 'Oui' else 'Non' end as \"".__("dia_acquereur_adr_num_voie")."\"",
318 "case cerfa.dia_acquereur_adr_ext when 't' then 'Oui' else 'Non' end as \"".__("dia_acquereur_adr_ext")."\"",
319 "case cerfa.dia_acquereur_adr_type_voie when 't' then 'Oui' else 'Non' end as \"".__("dia_acquereur_adr_type_voie")."\"",
320 "case cerfa.dia_acquereur_adr_nom_voie when 't' then 'Oui' else 'Non' end as \"".__("dia_acquereur_adr_nom_voie")."\"",
321 "case cerfa.dia_acquereur_adr_lieu_dit_bp when 't' then 'Oui' else 'Non' end as \"".__("dia_acquereur_adr_lieu_dit_bp")."\"",
322 "case cerfa.dia_acquereur_adr_cp when 't' then 'Oui' else 'Non' end as \"".__("dia_acquereur_adr_cp")."\"",
323 "case cerfa.dia_acquereur_adr_localite when 't' then 'Oui' else 'Non' end as \"".__("dia_acquereur_adr_localite")."\"",
324 "case cerfa.dia_observation when 't' then 'Oui' else 'Non' end as \"".__("dia_observation")."\"",
325 'cerfa.tab_surface2 as "'.__("tab_surface2").'"',
326 "case cerfa.dia_occ_sol_su_terre when 't' then 'Oui' else 'Non' end as \"".__("dia_occ_sol_su_terre")."\"",
327 "case cerfa.dia_occ_sol_su_pres when 't' then 'Oui' else 'Non' end as \"".__("dia_occ_sol_su_pres")."\"",
328 "case cerfa.dia_occ_sol_su_verger when 't' then 'Oui' else 'Non' end as \"".__("dia_occ_sol_su_verger")."\"",
329 "case cerfa.dia_occ_sol_su_vigne when 't' then 'Oui' else 'Non' end as \"".__("dia_occ_sol_su_vigne")."\"",
330 "case cerfa.dia_occ_sol_su_bois when 't' then 'Oui' else 'Non' end as \"".__("dia_occ_sol_su_bois")."\"",
331 "case cerfa.dia_occ_sol_su_lande when 't' then 'Oui' else 'Non' end as \"".__("dia_occ_sol_su_lande")."\"",
332 "case cerfa.dia_occ_sol_su_carriere when 't' then 'Oui' else 'Non' end as \"".__("dia_occ_sol_su_carriere")."\"",
333 "case cerfa.dia_occ_sol_su_eau_cadastree when 't' then 'Oui' else 'Non' end as \"".__("dia_occ_sol_su_eau_cadastree")."\"",
334 "case cerfa.dia_occ_sol_su_jardin when 't' then 'Oui' else 'Non' end as \"".__("dia_occ_sol_su_jardin")."\"",
335 "case cerfa.dia_occ_sol_su_terr_batir when 't' then 'Oui' else 'Non' end as \"".__("dia_occ_sol_su_terr_batir")."\"",
336 "case cerfa.dia_occ_sol_su_terr_agr when 't' then 'Oui' else 'Non' end as \"".__("dia_occ_sol_su_terr_agr")."\"",
337 "case cerfa.dia_occ_sol_su_sol when 't' then 'Oui' else 'Non' end as \"".__("dia_occ_sol_su_sol")."\"",
338 "case cerfa.dia_bati_vend_tot when 't' then 'Oui' else 'Non' end as \"".__("dia_bati_vend_tot")."\"",
339 "case cerfa.dia_bati_vend_tot_txt when 't' then 'Oui' else 'Non' end as \"".__("dia_bati_vend_tot_txt")."\"",
340 "case cerfa.dia_su_co_sol when 't' then 'Oui' else 'Non' end as \"".__("dia_su_co_sol")."\"",
341 "case cerfa.dia_su_util_hab when 't' then 'Oui' else 'Non' end as \"".__("dia_su_util_hab")."\"",
342 "case cerfa.dia_nb_niv when 't' then 'Oui' else 'Non' end as \"".__("dia_nb_niv")."\"",
343 "case cerfa.dia_nb_appart when 't' then 'Oui' else 'Non' end as \"".__("dia_nb_appart")."\"",
344 "case cerfa.dia_nb_autre_loc when 't' then 'Oui' else 'Non' end as \"".__("dia_nb_autre_loc")."\"",
345 "case cerfa.dia_vente_lot_volume when 't' then 'Oui' else 'Non' end as \"".__("dia_vente_lot_volume")."\"",
346 "case cerfa.dia_vente_lot_volume_txt when 't' then 'Oui' else 'Non' end as \"".__("dia_vente_lot_volume_txt")."\"",
347 "case cerfa.dia_lot_nat_su when 't' then 'Oui' else 'Non' end as \"".__("dia_lot_nat_su")."\"",
348 "case cerfa.dia_lot_bat_achv_plus_10 when 't' then 'Oui' else 'Non' end as \"".__("dia_lot_bat_achv_plus_10")."\"",
349 "case cerfa.dia_lot_bat_achv_moins_10 when 't' then 'Oui' else 'Non' end as \"".__("dia_lot_bat_achv_moins_10")."\"",
350 "case cerfa.dia_lot_regl_copro_publ_hypo_plus_10 when 't' then 'Oui' else 'Non' end as \"".__("dia_lot_regl_copro_publ_hypo_plus_10")."\"",
351 "case cerfa.dia_lot_regl_copro_publ_hypo_moins_10 when 't' then 'Oui' else 'Non' end as \"".__("dia_lot_regl_copro_publ_hypo_moins_10")."\"",
352 "case cerfa.dia_indivi_quote_part when 't' then 'Oui' else 'Non' end as \"".__("dia_indivi_quote_part")."\"",
353 "case cerfa.dia_design_societe when 't' then 'Oui' else 'Non' end as \"".__("dia_design_societe")."\"",
354 "case cerfa.dia_design_droit when 't' then 'Oui' else 'Non' end as \"".__("dia_design_droit")."\"",
355 "case cerfa.dia_droit_soc_nat when 't' then 'Oui' else 'Non' end as \"".__("dia_droit_soc_nat")."\"",
356 "case cerfa.dia_droit_soc_nb when 't' then 'Oui' else 'Non' end as \"".__("dia_droit_soc_nb")."\"",
357 "case cerfa.dia_droit_soc_num_part when 't' then 'Oui' else 'Non' end as \"".__("dia_droit_soc_num_part")."\"",
358 "case cerfa.dia_droit_reel_perso_grevant_bien_oui when 't' then 'Oui' else 'Non' end as \"".__("dia_droit_reel_perso_grevant_bien_oui")."\"",
359 "case cerfa.dia_droit_reel_perso_grevant_bien_non when 't' then 'Oui' else 'Non' end as \"".__("dia_droit_reel_perso_grevant_bien_non")."\"",
360 "case cerfa.dia_droit_reel_perso_nat when 't' then 'Oui' else 'Non' end as \"".__("dia_droit_reel_perso_nat")."\"",
361 "case cerfa.dia_droit_reel_perso_viag when 't' then 'Oui' else 'Non' end as \"".__("dia_droit_reel_perso_viag")."\"",
362 "case cerfa.dia_mod_cess_adr when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_adr")."\"",
363 "case cerfa.dia_mod_cess_sign_act_auth when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_sign_act_auth")."\"",
364 "case cerfa.dia_mod_cess_terme when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_terme")."\"",
365 "case cerfa.dia_mod_cess_terme_prec when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_terme_prec")."\"",
366 "case cerfa.dia_mod_cess_bene_acquereur when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_bene_acquereur")."\"",
367 "case cerfa.dia_mod_cess_bene_vendeur when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_bene_vendeur")."\"",
368 "case cerfa.dia_mod_cess_paie_nat when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_paie_nat")."\"",
369 "case cerfa.dia_mod_cess_design_contr_alien when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_design_contr_alien")."\"",
370 "case cerfa.dia_mod_cess_eval_contr when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_eval_contr")."\"",
371 "case cerfa.dia_mod_cess_rente_viag when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_rente_viag")."\"",
372 "case cerfa.dia_mod_cess_mnt_an when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_mnt_an")."\"",
373 "case cerfa.dia_mod_cess_mnt_compt when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_mnt_compt")."\"",
374 "case cerfa.dia_mod_cess_bene_rente when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_bene_rente")."\"",
375 "case cerfa.dia_mod_cess_droit_usa_hab when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_droit_usa_hab")."\"",
376 "case cerfa.dia_mod_cess_droit_usa_hab_prec when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_droit_usa_hab_prec")."\"",
377 "case cerfa.dia_mod_cess_eval_usa_usufruit when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_eval_usa_usufruit")."\"",
378 "case cerfa.dia_mod_cess_vente_nue_prop when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_vente_nue_prop")."\"",
379 "case cerfa.dia_mod_cess_vente_nue_prop_prec when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_vente_nue_prop_prec")."\"",
380 "case cerfa.dia_mod_cess_echange when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_echange")."\"",
381 "case cerfa.dia_mod_cess_design_bien_recus_ech when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_design_bien_recus_ech")."\"",
382 "case cerfa.dia_mod_cess_mnt_soulte when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_mnt_soulte")."\"",
383 "case cerfa.dia_mod_cess_prop_contre_echan when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_prop_contre_echan")."\"",
384 "case cerfa.dia_mod_cess_apport_societe when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_apport_societe")."\"",
385 "case cerfa.dia_mod_cess_bene when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_bene")."\"",
386 "case cerfa.dia_mod_cess_esti_bien when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_esti_bien")."\"",
387 "case cerfa.dia_mod_cess_cess_terr_loc_co when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_cess_terr_loc_co")."\"",
388 "case cerfa.dia_mod_cess_esti_terr when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_esti_terr")."\"",
389 "case cerfa.dia_mod_cess_esti_loc when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_esti_loc")."\"",
390 "case cerfa.dia_mod_cess_esti_imm_loca when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_esti_imm_loca")."\"",
391 "case cerfa.dia_mod_cess_adju_vol when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_adju_vol")."\"",
392 "case cerfa.dia_mod_cess_adju_obl when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_adju_obl")."\"",
393 "case cerfa.dia_mod_cess_adju_fin_indivi when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_adju_fin_indivi")."\"",
394 "case cerfa.dia_mod_cess_adju_date_lieu when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_adju_date_lieu")."\"",
395 "case cerfa.dia_mod_cess_mnt_mise_prix when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_mnt_mise_prix")."\"",
396 "case cerfa.dia_prop_titu_prix_indique when 't' then 'Oui' else 'Non' end as \"".__("dia_prop_titu_prix_indique")."\"",
397 "case cerfa.dia_prop_recherche_acqu_prix_indique when 't' then 'Oui' else 'Non' end as \"".__("dia_prop_recherche_acqu_prix_indique")."\"",
398 "case cerfa.dia_acquereur_prof when 't' then 'Oui' else 'Non' end as \"".__("dia_acquereur_prof")."\"",
399 "case cerfa.dia_indic_compl_ope when 't' then 'Oui' else 'Non' end as \"".__("dia_indic_compl_ope")."\"",
400 "case cerfa.dia_vente_adju when 't' then 'Oui' else 'Non' end as \"".__("dia_vente_adju")."\"",
401 "case cerfa.am_terr_res_demon when 't' then 'Oui' else 'Non' end as \"".__("am_terr_res_demon")."\"",
402 "case cerfa.am_air_terr_res_mob when 't' then 'Oui' else 'Non' end as \"".__("am_air_terr_res_mob")."\"",
403 "case cerfa.ctx_objet_recours when 't' then 'Oui' else 'Non' end as \"".__("ctx_objet_recours")."\"",
404 "case cerfa.ctx_moyen_souleve when 't' then 'Oui' else 'Non' end as \"".__("ctx_moyen_souleve")."\"",
405 "case cerfa.ctx_moyen_retenu_juge when 't' then 'Oui' else 'Non' end as \"".__("ctx_moyen_retenu_juge")."\"",
406 "case cerfa.ctx_reference_sagace when 't' then 'Oui' else 'Non' end as \"".__("ctx_reference_sagace")."\"",
407 "case cerfa.ctx_nature_travaux_infra_om_html when 't' then 'Oui' else 'Non' end as \"".__("ctx_nature_travaux_infra_om_html")."\"",
408 "case cerfa.ctx_synthese_nti when 't' then 'Oui' else 'Non' end as \"".__("ctx_synthese_nti")."\"",
409 "case cerfa.ctx_article_non_resp_om_html when 't' then 'Oui' else 'Non' end as \"".__("ctx_article_non_resp_om_html")."\"",
410 "case cerfa.ctx_synthese_anr when 't' then 'Oui' else 'Non' end as \"".__("ctx_synthese_anr")."\"",
411 "case cerfa.ctx_reference_parquet when 't' then 'Oui' else 'Non' end as \"".__("ctx_reference_parquet")."\"",
412 "case cerfa.ctx_element_taxation when 't' then 'Oui' else 'Non' end as \"".__("ctx_element_taxation")."\"",
413 "case cerfa.ctx_infraction when 't' then 'Oui' else 'Non' end as \"".__("ctx_infraction")."\"",
414 "case cerfa.ctx_regularisable when 't' then 'Oui' else 'Non' end as \"".__("ctx_regularisable")."\"",
415 "case cerfa.ctx_reference_courrier when 't' then 'Oui' else 'Non' end as \"".__("ctx_reference_courrier")."\"",
416 "case cerfa.ctx_date_audience when 't' then 'Oui' else 'Non' end as \"".__("ctx_date_audience")."\"",
417 "case cerfa.ctx_date_ajournement when 't' then 'Oui' else 'Non' end as \"".__("ctx_date_ajournement")."\"",
418 "case cerfa.exo_facul_1 when 't' then 'Oui' else 'Non' end as \"".__("exo_facul_1")."\"",
419 "case cerfa.exo_facul_2 when 't' then 'Oui' else 'Non' end as \"".__("exo_facul_2")."\"",
420 "case cerfa.exo_facul_3 when 't' then 'Oui' else 'Non' end as \"".__("exo_facul_3")."\"",
421 "case cerfa.exo_facul_4 when 't' then 'Oui' else 'Non' end as \"".__("exo_facul_4")."\"",
422 "case cerfa.exo_facul_5 when 't' then 'Oui' else 'Non' end as \"".__("exo_facul_5")."\"",
423 "case cerfa.exo_facul_6 when 't' then 'Oui' else 'Non' end as \"".__("exo_facul_6")."\"",
424 "case cerfa.exo_facul_7 when 't' then 'Oui' else 'Non' end as \"".__("exo_facul_7")."\"",
425 "case cerfa.exo_facul_8 when 't' then 'Oui' else 'Non' end as \"".__("exo_facul_8")."\"",
426 "case cerfa.exo_facul_9 when 't' then 'Oui' else 'Non' end as \"".__("exo_facul_9")."\"",
427 "case cerfa.exo_ta_1 when 't' then 'Oui' else 'Non' end as \"".__("exo_ta_1")."\"",
428 "case cerfa.exo_ta_2 when 't' then 'Oui' else 'Non' end as \"".__("exo_ta_2")."\"",
429 "case cerfa.exo_ta_3 when 't' then 'Oui' else 'Non' end as \"".__("exo_ta_3")."\"",
430 "case cerfa.exo_ta_4 when 't' then 'Oui' else 'Non' end as \"".__("exo_ta_4")."\"",
431 "case cerfa.exo_ta_5 when 't' then 'Oui' else 'Non' end as \"".__("exo_ta_5")."\"",
432 "case cerfa.exo_ta_6 when 't' then 'Oui' else 'Non' end as \"".__("exo_ta_6")."\"",
433 "case cerfa.exo_ta_7 when 't' then 'Oui' else 'Non' end as \"".__("exo_ta_7")."\"",
434 "case cerfa.exo_ta_8 when 't' then 'Oui' else 'Non' end as \"".__("exo_ta_8")."\"",
435 "case cerfa.exo_ta_9 when 't' then 'Oui' else 'Non' end as \"".__("exo_ta_9")."\"",
436 "case cerfa.exo_rap_1 when 't' then 'Oui' else 'Non' end as \"".__("exo_rap_1")."\"",
437 "case cerfa.exo_rap_2 when 't' then 'Oui' else 'Non' end as \"".__("exo_rap_2")."\"",
438 "case cerfa.exo_rap_3 when 't' then 'Oui' else 'Non' end as \"".__("exo_rap_3")."\"",
439 "case cerfa.exo_rap_4 when 't' then 'Oui' else 'Non' end as \"".__("exo_rap_4")."\"",
440 "case cerfa.exo_rap_5 when 't' then 'Oui' else 'Non' end as \"".__("exo_rap_5")."\"",
441 "case cerfa.exo_rap_6 when 't' then 'Oui' else 'Non' end as \"".__("exo_rap_6")."\"",
442 "case cerfa.exo_rap_7 when 't' then 'Oui' else 'Non' end as \"".__("exo_rap_7")."\"",
443 "case cerfa.exo_rap_8 when 't' then 'Oui' else 'Non' end as \"".__("exo_rap_8")."\"",
444 "case cerfa.mtn_exo_ta_part_commu when 't' then 'Oui' else 'Non' end as \"".__("mtn_exo_ta_part_commu")."\"",
445 "case cerfa.mtn_exo_ta_part_depart when 't' then 'Oui' else 'Non' end as \"".__("mtn_exo_ta_part_depart")."\"",
446 "case cerfa.mtn_exo_ta_part_reg when 't' then 'Oui' else 'Non' end as \"".__("mtn_exo_ta_part_reg")."\"",
447 "case cerfa.mtn_exo_rap when 't' then 'Oui' else 'Non' end as \"".__("mtn_exo_rap")."\"",
448 "case cerfa.dpc_type when 't' then 'Oui' else 'Non' end as \"".__("dpc_type")."\"",
449 "case cerfa.dpc_desc_actv_ex when 't' then 'Oui' else 'Non' end as \"".__("dpc_desc_actv_ex")."\"",
450 "case cerfa.dpc_desc_ca when 't' then 'Oui' else 'Non' end as \"".__("dpc_desc_ca")."\"",
451 "case cerfa.dpc_desc_aut_prec when 't' then 'Oui' else 'Non' end as \"".__("dpc_desc_aut_prec")."\"",
452 "case cerfa.dpc_desig_comm_arti when 't' then 'Oui' else 'Non' end as \"".__("dpc_desig_comm_arti")."\"",
453 "case cerfa.dpc_desig_loc_hab when 't' then 'Oui' else 'Non' end as \"".__("dpc_desig_loc_hab")."\"",
454 "case cerfa.dpc_desig_loc_ann when 't' then 'Oui' else 'Non' end as \"".__("dpc_desig_loc_ann")."\"",
455 "case cerfa.dpc_desig_loc_ann_prec when 't' then 'Oui' else 'Non' end as \"".__("dpc_desig_loc_ann_prec")."\"",
456 "case cerfa.dpc_bail_comm_date when 't' then 'Oui' else 'Non' end as \"".__("dpc_bail_comm_date")."\"",
457 "case cerfa.dpc_bail_comm_loyer when 't' then 'Oui' else 'Non' end as \"".__("dpc_bail_comm_loyer")."\"",
458 "case cerfa.dpc_actv_acqu when 't' then 'Oui' else 'Non' end as \"".__("dpc_actv_acqu")."\"",
459 "case cerfa.dpc_nb_sala_di when 't' then 'Oui' else 'Non' end as \"".__("dpc_nb_sala_di")."\"",
460 "case cerfa.dpc_nb_sala_dd when 't' then 'Oui' else 'Non' end as \"".__("dpc_nb_sala_dd")."\"",
461 "case cerfa.dpc_nb_sala_tc when 't' then 'Oui' else 'Non' end as \"".__("dpc_nb_sala_tc")."\"",
462 "case cerfa.dpc_nb_sala_tp when 't' then 'Oui' else 'Non' end as \"".__("dpc_nb_sala_tp")."\"",
463 "case cerfa.dpc_moda_cess_vente_am when 't' then 'Oui' else 'Non' end as \"".__("dpc_moda_cess_vente_am")."\"",
464 "case cerfa.dpc_moda_cess_adj when 't' then 'Oui' else 'Non' end as \"".__("dpc_moda_cess_adj")."\"",
465 "case cerfa.dpc_moda_cess_prix when 't' then 'Oui' else 'Non' end as \"".__("dpc_moda_cess_prix")."\"",
466 "case cerfa.dpc_moda_cess_adj_date when 't' then 'Oui' else 'Non' end as \"".__("dpc_moda_cess_adj_date")."\"",
467 "case cerfa.dpc_moda_cess_adj_prec when 't' then 'Oui' else 'Non' end as \"".__("dpc_moda_cess_adj_prec")."\"",
468 "case cerfa.dpc_moda_cess_paie_comp when 't' then 'Oui' else 'Non' end as \"".__("dpc_moda_cess_paie_comp")."\"",
469 "case cerfa.dpc_moda_cess_paie_terme when 't' then 'Oui' else 'Non' end as \"".__("dpc_moda_cess_paie_terme")."\"",
470 "case cerfa.dpc_moda_cess_paie_terme_prec when 't' then 'Oui' else 'Non' end as \"".__("dpc_moda_cess_paie_terme_prec")."\"",
471 "case cerfa.dpc_moda_cess_paie_nat when 't' then 'Oui' else 'Non' end as \"".__("dpc_moda_cess_paie_nat")."\"",
472 "case cerfa.dpc_moda_cess_paie_nat_desig_alien when 't' then 'Oui' else 'Non' end as \"".__("dpc_moda_cess_paie_nat_desig_alien")."\"",
473 "case cerfa.dpc_moda_cess_paie_nat_desig_alien_prec when 't' then 'Oui' else 'Non' end as \"".__("dpc_moda_cess_paie_nat_desig_alien_prec")."\"",
474 "case cerfa.dpc_moda_cess_paie_nat_eval when 't' then 'Oui' else 'Non' end as \"".__("dpc_moda_cess_paie_nat_eval")."\"",
475 "case cerfa.dpc_moda_cess_paie_nat_eval_prec when 't' then 'Oui' else 'Non' end as \"".__("dpc_moda_cess_paie_nat_eval_prec")."\"",
476 "case cerfa.dpc_moda_cess_paie_aut when 't' then 'Oui' else 'Non' end as \"".__("dpc_moda_cess_paie_aut")."\"",
477 "case cerfa.dpc_moda_cess_paie_aut_prec when 't' then 'Oui' else 'Non' end as \"".__("dpc_moda_cess_paie_aut_prec")."\"",
478 "case cerfa.dpc_ss_signe_demande_acqu when 't' then 'Oui' else 'Non' end as \"".__("dpc_ss_signe_demande_acqu")."\"",
479 "case cerfa.dpc_ss_signe_recher_trouv_acqu when 't' then 'Oui' else 'Non' end as \"".__("dpc_ss_signe_recher_trouv_acqu")."\"",
480 "case cerfa.dpc_notif_adr_prop when 't' then 'Oui' else 'Non' end as \"".__("dpc_notif_adr_prop")."\"",
481 "case cerfa.dpc_notif_adr_manda when 't' then 'Oui' else 'Non' end as \"".__("dpc_notif_adr_manda")."\"",
482 "case cerfa.dpc_obs when 't' then 'Oui' else 'Non' end as \"".__("dpc_obs")."\"",
483 "case cerfa.co_peri_site_patri_remar when 't' then 'Oui' else 'Non' end as \"".__("co_peri_site_patri_remar")."\"",
484 "case cerfa.co_abo_monu_hist when 't' then 'Oui' else 'Non' end as \"".__("co_abo_monu_hist")."\"",
485 "case cerfa.co_inst_ouvr_trav_act_code_envir when 't' then 'Oui' else 'Non' end as \"".__("co_inst_ouvr_trav_act_code_envir")."\"",
486 "case cerfa.co_trav_auto_env when 't' then 'Oui' else 'Non' end as \"".__("co_trav_auto_env")."\"",
487 "case cerfa.co_derog_esp_prot when 't' then 'Oui' else 'Non' end as \"".__("co_derog_esp_prot")."\"",
488 "case cerfa.ctx_reference_dsj when 't' then 'Oui' else 'Non' end as \"".__("ctx_reference_dsj")."\"",
489 "case cerfa.co_piscine when 't' then 'Oui' else 'Non' end as \"".__("co_piscine")."\"",
490 "case cerfa.co_fin_lls when 't' then 'Oui' else 'Non' end as \"".__("co_fin_lls")."\"",
491 "case cerfa.co_fin_aa when 't' then 'Oui' else 'Non' end as \"".__("co_fin_aa")."\"",
492 "case cerfa.co_fin_ptz when 't' then 'Oui' else 'Non' end as \"".__("co_fin_ptz")."\"",
493 "case cerfa.co_fin_autr when 't' then 'Oui' else 'Non' end as \"".__("co_fin_autr")."\"",
494 "case cerfa.dia_ss_date when 't' then 'Oui' else 'Non' end as \"".__("dia_ss_date")."\"",
495 "case cerfa.dia_ss_lieu when 't' then 'Oui' else 'Non' end as \"".__("dia_ss_lieu")."\"",
496 "case cerfa.enga_decla_lieu when 't' then 'Oui' else 'Non' end as \"".__("enga_decla_lieu")."\"",
497 "case cerfa.enga_decla_date when 't' then 'Oui' else 'Non' end as \"".__("enga_decla_date")."\"",
498 "case cerfa.co_archi_attest_honneur when 't' then 'Oui' else 'Non' end as \"".__("co_archi_attest_honneur")."\"",
499 "case cerfa.co_bat_niv_dessous_nb when 't' then 'Oui' else 'Non' end as \"".__("co_bat_niv_dessous_nb")."\"",
500 "case cerfa.co_install_classe when 't' then 'Oui' else 'Non' end as \"".__("co_install_classe")."\"",
501 "case cerfa.co_derog_innov when 't' then 'Oui' else 'Non' end as \"".__("co_derog_innov")."\"",
502 "case cerfa.co_avis_abf when 't' then 'Oui' else 'Non' end as \"".__("co_avis_abf")."\"",
503 "case cerfa.tax_surf_tot_demo when 't' then 'Oui' else 'Non' end as \"".__("tax_surf_tot_demo")."\"",
504 "case cerfa.tax_surf_tax_demo when 't' then 'Oui' else 'Non' end as \"".__("tax_surf_tax_demo")."\"",
505 "case cerfa.tax_terrassement_arch when 't' then 'Oui' else 'Non' end as \"".__("tax_terrassement_arch")."\"",
506 "case cerfa.tax_adresse_future_numero when 't' then 'Oui' else 'Non' end as \"".__("tax_adresse_future_numero")."\"",
507 "case cerfa.tax_adresse_future_voie when 't' then 'Oui' else 'Non' end as \"".__("tax_adresse_future_voie")."\"",
508 "case cerfa.tax_adresse_future_lieudit when 't' then 'Oui' else 'Non' end as \"".__("tax_adresse_future_lieudit")."\"",
509 "case cerfa.tax_adresse_future_localite when 't' then 'Oui' else 'Non' end as \"".__("tax_adresse_future_localite")."\"",
510 "case cerfa.tax_adresse_future_cp when 't' then 'Oui' else 'Non' end as \"".__("tax_adresse_future_cp")."\"",
511 "case cerfa.tax_adresse_future_bp when 't' then 'Oui' else 'Non' end as \"".__("tax_adresse_future_bp")."\"",
512 "case cerfa.tax_adresse_future_cedex when 't' then 'Oui' else 'Non' end as \"".__("tax_adresse_future_cedex")."\"",
513 "case cerfa.tax_adresse_future_pays when 't' then 'Oui' else 'Non' end as \"".__("tax_adresse_future_pays")."\"",
514 "case cerfa.tax_adresse_future_division when 't' then 'Oui' else 'Non' end as \"".__("tax_adresse_future_division")."\"",
515 "case cerfa.co_bat_projete when 't' then 'Oui' else 'Non' end as \"".__("co_bat_projete")."\"",
516 "case cerfa.co_bat_existant when 't' then 'Oui' else 'Non' end as \"".__("co_bat_existant")."\"",
517 "case cerfa.co_bat_nature when 't' then 'Oui' else 'Non' end as \"".__("co_bat_nature")."\"",
518 "case cerfa.terr_juri_titul_date when 't' then 'Oui' else 'Non' end as \"".__("terr_juri_titul_date")."\"",
519 "case cerfa.co_autre_desc when 't' then 'Oui' else 'Non' end as \"".__("co_autre_desc")."\"",
520 "case cerfa.co_trx_autre when 't' then 'Oui' else 'Non' end as \"".__("co_trx_autre")."\"",
521 "case cerfa.co_autre when 't' then 'Oui' else 'Non' end as \"".__("co_autre")."\"",
522 "case cerfa.erp_modif_facades when 't' then 'Oui' else 'Non' end as \"".__("erp_modif_facades")."\"",
523 "case cerfa.erp_trvx_adap when 't' then 'Oui' else 'Non' end as \"".__("erp_trvx_adap")."\"",
524 "case cerfa.erp_trvx_adap_numero when 't' then 'Oui' else 'Non' end as \"".__("erp_trvx_adap_numero")."\"",
525 "case cerfa.erp_trvx_adap_valid when 't' then 'Oui' else 'Non' end as \"".__("erp_trvx_adap_valid")."\"",
526 "case cerfa.erp_prod_dangereux when 't' then 'Oui' else 'Non' end as \"".__("erp_prod_dangereux")."\"",
527 "case cerfa.co_trav_supp_dessus when 't' then 'Oui' else 'Non' end as \"".__("co_trav_supp_dessus")."\"",
528 "case cerfa.co_trav_supp_dessous when 't' then 'Oui' else 'Non' end as \"".__("co_trav_supp_dessous")."\"",
529 "case cerfa.tax_su_habit_abr_jard_pig_colom when 't' then 'Oui' else 'Non' end as \"".__("tax_su_habit_abr_jard_pig_colom")."\"",
530 "case cerfa.enga_decla_donnees_nomi_comm when 't' then 'Oui' else 'Non' end as \"".__("enga_decla_donnees_nomi_comm")."\"",
531 "case cerfa.x1l_legislation when 't' then 'Oui' else 'Non' end as \"".__("x1l_legislation")."\"",
532 "case cerfa.x1p_precisions when 't' then 'Oui' else 'Non' end as \"".__("x1p_precisions")."\"",
533 "case cerfa.x1u_raccordement when 't' then 'Oui' else 'Non' end as \"".__("x1u_raccordement")."\"",
534 "case cerfa.x2m_inscritmh when 't' then 'Oui' else 'Non' end as \"".__("x2m_inscritmh")."\"",
535 "case cerfa.s1na1_numero when 't' then 'Oui' else 'Non' end as \"".__("s1na1_numero")."\"",
536 "case cerfa.s1va1_voie when 't' then 'Oui' else 'Non' end as \"".__("s1va1_voie")."\"",
537 "case cerfa.s1wa1_lieudit when 't' then 'Oui' else 'Non' end as \"".__("s1wa1_lieudit")."\"",
538 "case cerfa.s1la1_localite when 't' then 'Oui' else 'Non' end as \"".__("s1la1_localite")."\"",
539 "case cerfa.s1pa1_codepostal when 't' then 'Oui' else 'Non' end as \"".__("s1pa1_codepostal")."\"",
540 "case cerfa.s1na2_numero when 't' then 'Oui' else 'Non' end as \"".__("s1na2_numero")."\"",
541 "case cerfa.s1va2_voie when 't' then 'Oui' else 'Non' end as \"".__("s1va2_voie")."\"",
542 "case cerfa.s1wa2_lieudit when 't' then 'Oui' else 'Non' end as \"".__("s1wa2_lieudit")."\"",
543 "case cerfa.s1la2_localite when 't' then 'Oui' else 'Non' end as \"".__("s1la2_localite")."\"",
544 "case cerfa.s1pa2_codepostal when 't' then 'Oui' else 'Non' end as \"".__("s1pa2_codepostal")."\"",
545 "case cerfa.e3c_certification when 't' then 'Oui' else 'Non' end as \"".__("e3c_certification")."\"",
546 "case cerfa.e3a_competence when 't' then 'Oui' else 'Non' end as \"".__("e3a_competence")."\"",
547 "case cerfa.a4d_description when 't' then 'Oui' else 'Non' end as \"".__("a4d_description")."\"",
548 "case cerfa.m2b_abf when 't' then 'Oui' else 'Non' end as \"".__("m2b_abf")."\"",
549 "case cerfa.m2j_pn when 't' then 'Oui' else 'Non' end as \"".__("m2j_pn")."\"",
550 "case cerfa.m2r_cdac when 't' then 'Oui' else 'Non' end as \"".__("m2r_cdac")."\"",
551 "case cerfa.m2r_cnac when 't' then 'Oui' else 'Non' end as \"".__("m2r_cnac")."\"",
552 "case cerfa.u3a_voirieoui when 't' then 'Oui' else 'Non' end as \"".__("u3a_voirieoui")."\"",
553 "case cerfa.u3f_voirienon when 't' then 'Oui' else 'Non' end as \"".__("u3f_voirienon")."\"",
554 "case cerfa.u3c_eauoui when 't' then 'Oui' else 'Non' end as \"".__("u3c_eauoui")."\"",
555 "case cerfa.u3h_eaunon when 't' then 'Oui' else 'Non' end as \"".__("u3h_eaunon")."\"",
556 "case cerfa.u3g_assainissementoui when 't' then 'Oui' else 'Non' end as \"".__("u3g_assainissementoui")."\"",
557 "case cerfa.u3n_assainissementnon when 't' then 'Oui' else 'Non' end as \"".__("u3n_assainissementnon")."\"",
558 "case cerfa.u3m_electriciteoui when 't' then 'Oui' else 'Non' end as \"".__("u3m_electriciteoui")."\"",
559 "case cerfa.u3b_electricitenon when 't' then 'Oui' else 'Non' end as \"".__("u3b_electricitenon")."\"",
560 "case cerfa.u3t_observations when 't' then 'Oui' else 'Non' end as \"".__("u3t_observations")."\"",
561 "case cerfa.u1a_voirieoui when 't' then 'Oui' else 'Non' end as \"".__("u1a_voirieoui")."\"",
562 "case cerfa.u1v_voirienon when 't' then 'Oui' else 'Non' end as \"".__("u1v_voirienon")."\"",
563 "case cerfa.u1q_voirieconcessionnaire when 't' then 'Oui' else 'Non' end as \"".__("u1q_voirieconcessionnaire")."\"",
564 "case cerfa.u1b_voirieavant when 't' then 'Oui' else 'Non' end as \"".__("u1b_voirieavant")."\"",
565 "case cerfa.u1j_eauoui when 't' then 'Oui' else 'Non' end as \"".__("u1j_eauoui")."\"",
566 "case cerfa.u1t_eaunon when 't' then 'Oui' else 'Non' end as \"".__("u1t_eaunon")."\"",
567 "case cerfa.u1e_eauconcessionnaire when 't' then 'Oui' else 'Non' end as \"".__("u1e_eauconcessionnaire")."\"",
568 "case cerfa.u1k_eauavant when 't' then 'Oui' else 'Non' end as \"".__("u1k_eauavant")."\"",
569 "case cerfa.u1s_assainissementoui when 't' then 'Oui' else 'Non' end as \"".__("u1s_assainissementoui")."\"",
570 "case cerfa.u1d_assainissementnon when 't' then 'Oui' else 'Non' end as \"".__("u1d_assainissementnon")."\"",
571 "case cerfa.u1l_assainissementconcessionnaire when 't' then 'Oui' else 'Non' end as \"".__("u1l_assainissementconcessionnaire")."\"",
572 "case cerfa.u1r_assainissementavant when 't' then 'Oui' else 'Non' end as \"".__("u1r_assainissementavant")."\"",
573 "case cerfa.u1c_electriciteoui when 't' then 'Oui' else 'Non' end as \"".__("u1c_electriciteoui")."\"",
574 "case cerfa.u1u_electricitenon when 't' then 'Oui' else 'Non' end as \"".__("u1u_electricitenon")."\"",
575 "case cerfa.u1m_electriciteconcessionnaire when 't' then 'Oui' else 'Non' end as \"".__("u1m_electriciteconcessionnaire")."\"",
576 "case cerfa.u1f_electriciteavant when 't' then 'Oui' else 'Non' end as \"".__("u1f_electriciteavant")."\"",
577 "case cerfa.u2a_observations when 't' then 'Oui' else 'Non' end as \"".__("u2a_observations")."\"",
578 "case cerfa.f1ts4_surftaxestation when 't' then 'Oui' else 'Non' end as \"".__("f1ts4_surftaxestation")."\"",
579 "case cerfa.f1ut1_surfcree when 't' then 'Oui' else 'Non' end as \"".__("f1ut1_surfcree")."\"",
580 "case cerfa.f9d_date when 't' then 'Oui' else 'Non' end as \"".__("f9d_date")."\"",
581 "case cerfa.f9n_nom when 't' then 'Oui' else 'Non' end as \"".__("f9n_nom")."\"",
582 "case cerfa.dia_droit_reel_perso_grevant_bien_desc when 't' then 'Oui' else 'Non' end as \"".__("dia_droit_reel_perso_grevant_bien_desc")."\"",
583 "case cerfa.dia_mod_cess_paie_nat_desc when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_paie_nat_desc")."\"",
584 "case cerfa.dia_mod_cess_rente_viag_desc when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_rente_viag_desc")."\"",
585 "case cerfa.dia_mod_cess_echange_desc when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_echange_desc")."\"",
586 "case cerfa.dia_mod_cess_apport_societe_desc when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_apport_societe_desc")."\"",
587 "case cerfa.dia_mod_cess_cess_terr_loc_co_desc when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_cess_terr_loc_co_desc")."\"",
588 "case cerfa.dia_mod_cess_esti_imm_loca_desc when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_esti_imm_loca_desc")."\"",
589 "case cerfa.dia_mod_cess_adju_obl_desc when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_adju_obl_desc")."\"",
590 "case cerfa.dia_mod_cess_adju_fin_indivi_desc when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_adju_fin_indivi_desc")."\"",
591 "case cerfa.dia_cadre_titul_droit_prempt when 't' then 'Oui' else 'Non' end as \"".__("dia_cadre_titul_droit_prempt")."\"",
592 "case cerfa.dia_mairie_prix_moyen when 't' then 'Oui' else 'Non' end as \"".__("dia_mairie_prix_moyen")."\"",
593 "case cerfa.dia_propri_indivi when 't' then 'Oui' else 'Non' end as \"".__("dia_propri_indivi")."\"",
594 "case cerfa.dia_situa_bien_plan_cadas_oui when 't' then 'Oui' else 'Non' end as \"".__("dia_situa_bien_plan_cadas_oui")."\"",
595 "case cerfa.dia_situa_bien_plan_cadas_non when 't' then 'Oui' else 'Non' end as \"".__("dia_situa_bien_plan_cadas_non")."\"",
596 "case cerfa.dia_notif_dec_titul_adr_prop when 't' then 'Oui' else 'Non' end as \"".__("dia_notif_dec_titul_adr_prop")."\"",
597 "case cerfa.dia_notif_dec_titul_adr_prop_desc when 't' then 'Oui' else 'Non' end as \"".__("dia_notif_dec_titul_adr_prop_desc")."\"",
598 "case cerfa.dia_notif_dec_titul_adr_manda when 't' then 'Oui' else 'Non' end as \"".__("dia_notif_dec_titul_adr_manda")."\"",
599 "case cerfa.dia_notif_dec_titul_adr_manda_desc when 't' then 'Oui' else 'Non' end as \"".__("dia_notif_dec_titul_adr_manda_desc")."\"",
600 "case cerfa.dia_dia_dpu when 't' then 'Oui' else 'Non' end as \"".__("dia_dia_dpu")."\"",
601 "case cerfa.dia_dia_zad when 't' then 'Oui' else 'Non' end as \"".__("dia_dia_zad")."\"",
602 "case cerfa.dia_dia_zone_preempt_esp_natu_sensi when 't' then 'Oui' else 'Non' end as \"".__("dia_dia_zone_preempt_esp_natu_sensi")."\"",
603 "case cerfa.dia_dab_dpu when 't' then 'Oui' else 'Non' end as \"".__("dia_dab_dpu")."\"",
604 "case cerfa.dia_dab_zad when 't' then 'Oui' else 'Non' end as \"".__("dia_dab_zad")."\"",
605 "case cerfa.dia_mod_cess_commi_mnt when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_commi_mnt")."\"",
606 "case cerfa.dia_mod_cess_commi_mnt_ttc when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_commi_mnt_ttc")."\"",
607 "case cerfa.dia_mod_cess_commi_mnt_ht when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_commi_mnt_ht")."\"",
608 "case cerfa.dia_mod_cess_prix_vente_num when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_prix_vente_num")."\"",
609 "case cerfa.dia_mod_cess_prix_vente_mob_num when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_prix_vente_mob_num")."\"",
610 "case cerfa.dia_mod_cess_prix_vente_cheptel_num when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_prix_vente_cheptel_num")."\"",
611 "case cerfa.dia_mod_cess_prix_vente_recol_num when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_prix_vente_recol_num")."\"",
612 "case cerfa.dia_mod_cess_prix_vente_autre_num when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_prix_vente_autre_num")."\"",
613 "case cerfa.dia_su_co_sol_num when 't' then 'Oui' else 'Non' end as \"".__("dia_su_co_sol_num")."\"",
614 "case cerfa.dia_su_util_hab_num when 't' then 'Oui' else 'Non' end as \"".__("dia_su_util_hab_num")."\"",
615 "case cerfa.dia_mod_cess_mnt_an_num when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_mnt_an_num")."\"",
616 "case cerfa.dia_mod_cess_mnt_compt_num when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_mnt_compt_num")."\"",
617 "case cerfa.dia_mod_cess_mnt_soulte_num when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_mnt_soulte_num")."\"",
618 "case cerfa.dia_comp_prix_vente when 't' then 'Oui' else 'Non' end as \"".__("dia_comp_prix_vente")."\"",
619 "case cerfa.dia_comp_surface when 't' then 'Oui' else 'Non' end as \"".__("dia_comp_surface")."\"",
620 "case cerfa.dia_comp_total_frais when 't' then 'Oui' else 'Non' end as \"".__("dia_comp_total_frais")."\"",
621 "case cerfa.dia_comp_mtn_total when 't' then 'Oui' else 'Non' end as \"".__("dia_comp_mtn_total")."\"",
622 "case cerfa.dia_comp_valeur_m2 when 't' then 'Oui' else 'Non' end as \"".__("dia_comp_valeur_m2")."\"",
623 "case cerfa.dia_esti_prix_france_dom when 't' then 'Oui' else 'Non' end as \"".__("dia_esti_prix_france_dom")."\"",
624 "case cerfa.dia_prop_collectivite when 't' then 'Oui' else 'Non' end as \"".__("dia_prop_collectivite")."\"",
625 "case cerfa.dia_delegataire_denomination when 't' then 'Oui' else 'Non' end as \"".__("dia_delegataire_denomination")."\"",
626 "case cerfa.dia_delegataire_raison_sociale when 't' then 'Oui' else 'Non' end as \"".__("dia_delegataire_raison_sociale")."\"",
627 "case cerfa.dia_delegataire_siret when 't' then 'Oui' else 'Non' end as \"".__("dia_delegataire_siret")."\"",
628 "case cerfa.dia_delegataire_categorie_juridique when 't' then 'Oui' else 'Non' end as \"".__("dia_delegataire_categorie_juridique")."\"",
629 "case cerfa.dia_delegataire_representant_nom when 't' then 'Oui' else 'Non' end as \"".__("dia_delegataire_representant_nom")."\"",
630 "case cerfa.dia_delegataire_representant_prenom when 't' then 'Oui' else 'Non' end as \"".__("dia_delegataire_representant_prenom")."\"",
631 "case cerfa.dia_delegataire_adresse_numero when 't' then 'Oui' else 'Non' end as \"".__("dia_delegataire_adresse_numero")."\"",
632 "case cerfa.dia_delegataire_adresse_voie when 't' then 'Oui' else 'Non' end as \"".__("dia_delegataire_adresse_voie")."\"",
633 "case cerfa.dia_delegataire_adresse_complement when 't' then 'Oui' else 'Non' end as \"".__("dia_delegataire_adresse_complement")."\"",
634 "case cerfa.dia_delegataire_adresse_lieu_dit when 't' then 'Oui' else 'Non' end as \"".__("dia_delegataire_adresse_lieu_dit")."\"",
635 "case cerfa.dia_delegataire_adresse_localite when 't' then 'Oui' else 'Non' end as \"".__("dia_delegataire_adresse_localite")."\"",
636 "case cerfa.dia_delegataire_adresse_code_postal when 't' then 'Oui' else 'Non' end as \"".__("dia_delegataire_adresse_code_postal")."\"",
637 "case cerfa.dia_delegataire_adresse_bp when 't' then 'Oui' else 'Non' end as \"".__("dia_delegataire_adresse_bp")."\"",
638 "case cerfa.dia_delegataire_adresse_cedex when 't' then 'Oui' else 'Non' end as \"".__("dia_delegataire_adresse_cedex")."\"",
639 "case cerfa.dia_delegataire_adresse_pays when 't' then 'Oui' else 'Non' end as \"".__("dia_delegataire_adresse_pays")."\"",
640 "case cerfa.dia_delegataire_telephone_fixe when 't' then 'Oui' else 'Non' end as \"".__("dia_delegataire_telephone_fixe")."\"",
641 "case cerfa.dia_delegataire_telephone_mobile when 't' then 'Oui' else 'Non' end as \"".__("dia_delegataire_telephone_mobile")."\"",
642 "case cerfa.dia_delegataire_telephone_mobile_indicatif when 't' then 'Oui' else 'Non' end as \"".__("dia_delegataire_telephone_mobile_indicatif")."\"",
643 "case cerfa.dia_delegataire_courriel when 't' then 'Oui' else 'Non' end as \"".__("dia_delegataire_courriel")."\"",
644 "case cerfa.dia_delegataire_fax when 't' then 'Oui' else 'Non' end as \"".__("dia_delegataire_fax")."\"",
645 "case cerfa.dia_entree_jouissance_type when 't' then 'Oui' else 'Non' end as \"".__("dia_entree_jouissance_type")."\"",
646 "case cerfa.dia_entree_jouissance_date when 't' then 'Oui' else 'Non' end as \"".__("dia_entree_jouissance_date")."\"",
647 "case cerfa.dia_entree_jouissance_date_effet when 't' then 'Oui' else 'Non' end as \"".__("dia_entree_jouissance_date_effet")."\"",
648 "case cerfa.dia_entree_jouissance_com when 't' then 'Oui' else 'Non' end as \"".__("dia_entree_jouissance_com")."\"",
649 "case cerfa.dia_remise_bien_date_effet when 't' then 'Oui' else 'Non' end as \"".__("dia_remise_bien_date_effet")."\"",
650 "case cerfa.dia_remise_bien_com when 't' then 'Oui' else 'Non' end as \"".__("dia_remise_bien_com")."\"",
651 "case cerfa.c2zp1_crete when 't' then 'Oui' else 'Non' end as \"".__("c2zp1_crete")."\"",
652 "case cerfa.c2zr1_destination when 't' then 'Oui' else 'Non' end as \"".__("c2zr1_destination")."\"",
653 );
654 //
655 $champNonAffiche = array(
656 );
657 //
658 $champRecherche = array(
659 'cerfa.cerfa as "'.__("cerfa").'"',
660 'cerfa.libelle as "'.__("libelle").'"',
661 'cerfa.code as "'.__("code").'"',
662 'cerfa.tab_surface as "'.__("tab_surface").'"',
663 'cerfa.tab_tax_su_princ as "'.__("tab_tax_su_princ").'"',
664 'cerfa.tab_tax_su_heber as "'.__("tab_tax_su_heber").'"',
665 'cerfa.tab_tax_su_secon as "'.__("tab_tax_su_secon").'"',
666 'cerfa.tab_tax_su_tot as "'.__("tab_tax_su_tot").'"',
667 'cerfa.tab_tax_su_non_habit_surf as "'.__("tab_tax_su_non_habit_surf").'"',
668 'cerfa.tab_tax_am as "'.__("tab_tax_am").'"',
669 'cerfa.tab_tax_su_parc_statio_expl_comm as "'.__("tab_tax_su_parc_statio_expl_comm").'"',
670 'cerfa.tab_erp_eff as "'.__("tab_erp_eff").'"',
671 'cerfa.tab_surface2 as "'.__("tab_surface2").'"',
672 );
673 $tri="ORDER BY cerfa.libelle ASC NULLS LAST";
674 $edition="cerfa";
675 /**
676 * Gestion de la clause WHERE => $selection
677 */
678 // Filtre listing standard
679 $selection = " WHERE ((cerfa.om_validite_debut IS NULL AND (cerfa.om_validite_fin IS NULL OR cerfa.om_validite_fin > CURRENT_DATE)) OR (cerfa.om_validite_debut <= CURRENT_DATE AND (cerfa.om_validite_fin IS NULL OR cerfa.om_validite_fin > CURRENT_DATE)))";
680 $where_om_validite = " WHERE ((cerfa.om_validite_debut IS NULL AND (cerfa.om_validite_fin IS NULL OR cerfa.om_validite_fin > CURRENT_DATE)) OR (cerfa.om_validite_debut <= CURRENT_DATE AND (cerfa.om_validite_fin IS NULL OR cerfa.om_validite_fin > CURRENT_DATE)))";
681 // Gestion OMValidité - Suppression du filtre si paramètre
682 if (isset($_GET["valide"]) and $_GET["valide"] == "false") {
683 if (!isset($where_om_validite)
684 or (isset($where_om_validite) and $where_om_validite == "")) {
685 if (trim($selection) != "") {
686 $selection = "";
687 }
688 } else {
689 $selection = trim(str_replace($where_om_validite, "", $selection));
690 }
691 }
692
693 /**
694 * Gestion SOUSFORMULAIRE => $sousformulaire
695 */
696 $sousformulaire = array(
697 'dossier_autorisation_type_detaille',
698 );
699

Properties

Name Value
svn:keywords "Id"
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26