/[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 8477 - (show annotations)
Fri Dec 14 10:14:10 2018 UTC (5 years, 11 months ago) by softime
File size: 50692 byte(s) 
* Merge de la branche d'intégration 4.9.0-develop vers le trunk
1 <?php
2 //$Id$
3 //gen openMairie le 26/11/2018 16:03
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 );
490 //
491 $champNonAffiche = array(
492 );
493 //
494 $champRecherche = array(
495 'cerfa.cerfa as "'.__("cerfa").'"',
496 'cerfa.libelle as "'.__("libelle").'"',
497 'cerfa.code as "'.__("code").'"',
498 'cerfa.tab_surface as "'.__("tab_surface").'"',
499 'cerfa.tab_tax_su_princ as "'.__("tab_tax_su_princ").'"',
500 'cerfa.tab_tax_su_heber as "'.__("tab_tax_su_heber").'"',
501 'cerfa.tab_tax_su_secon as "'.__("tab_tax_su_secon").'"',
502 'cerfa.tab_tax_su_tot as "'.__("tab_tax_su_tot").'"',
503 'cerfa.tab_tax_su_non_habit_surf as "'.__("tab_tax_su_non_habit_surf").'"',
504 'cerfa.tab_tax_am as "'.__("tab_tax_am").'"',
505 'cerfa.tab_tax_su_parc_statio_expl_comm as "'.__("tab_tax_su_parc_statio_expl_comm").'"',
506 'cerfa.tab_erp_eff as "'.__("tab_erp_eff").'"',
507 'cerfa.tab_surface2 as "'.__("tab_surface2").'"',
508 );
509 $tri="ORDER BY cerfa.libelle ASC NULLS LAST";
510 $edition="cerfa";
511 /**
512 * Gestion de la clause WHERE => $selection
513 */
514 // Filtre listing standard
515 $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)))";
516 $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)))";
517 // Gestion OMValidité - Suppression du filtre si paramètre
518 if (isset($_GET["valide"]) and $_GET["valide"] == "false") {
519 if (!isset($where_om_validite)
520 or (isset($where_om_validite) and $where_om_validite == "")) {
521 if (trim($selection) != "") {
522 $selection = "";
523 }
524 } else {
525 $selection = trim(str_replace($where_om_validite, "", $selection));
526 }
527 }
528
529 /**
530 * Gestion SOUSFORMULAIRE => $sousformulaire
531 */
532 $sousformulaire = array(
533 'dossier_autorisation_type_detaille',
534 );
535

Properties

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