/[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 6565 - (show annotations)
Fri Apr 21 16:14:15 2017 UTC (7 years, 7 months ago) by softime
File size: 43239 byte(s)
Error occurred while calculating annotation data. 
Merge de la version 4.0.0
1 <?php
2 //$Id$
3 //gen openMairie le 01/02/2017 17:23
4
5 $DEBUG=0;
6 $serie=15;
7 $ico="../img/ico_application.png";
8 $ent = _("application")." -> "._("cerfa");
9 $om_validite = true;
10 if(!isset($premier)) $premier='';
11 if(!isset($recherche1)) $recherche1='';
12 if(!isset($tricolsf)) $tricolsf='';
13 if(!isset($premiersf)) $premiersf='';
14 if(!isset($selection)) $selection='';
15 if(!isset($retourformulaire)) $retourformulaire='';
16 if (!isset($idxformulaire)) {
17 $idxformulaire = '';
18 }
19 if (!isset($selectioncol)) {
20 $selectioncol = '';
21 }
22 if (!isset($tricol)) {
23 $tricol = '';
24 }
25 if (!isset($valide)) {
26 $valide = '';
27 }
28 if (!isset($recherche)) {
29 $recherche = '';
30 }
31 if (isset($idx) && $idx != ']' && trim($idx) != '') {
32 $ent .= "->&nbsp;".$idx."&nbsp;";
33 }
34 if (isset($idz) && trim($idz) != '') {
35 $ent .= "&nbsp;".strtoupper($idz)."&nbsp;";
36 }
37 // FROM
38 $table = DB_PREFIXE."cerfa";
39 // SELECT
40 $champAffiche = array(
41 'cerfa.cerfa as "'._("cerfa").'"',
42 'cerfa.libelle as "'._("libelle").'"',
43 'cerfa.code as "'._("code").'"',
44 'to_char(cerfa.om_validite_debut ,\'DD/MM/YYYY\') as "'._("om_validite_debut").'"',
45 'to_char(cerfa.om_validite_fin ,\'DD/MM/YYYY\') as "'._("om_validite_fin").'"',
46 "case cerfa.am_lotiss when 't' then 'Oui' else 'Non' end as \""._("am_lotiss")."\"",
47 "case cerfa.am_autre_div when 't' then 'Oui' else 'Non' end as \""._("am_autre_div")."\"",
48 "case cerfa.am_camping when 't' then 'Oui' else 'Non' end as \""._("am_camping")."\"",
49 "case cerfa.am_caravane when 't' then 'Oui' else 'Non' end as \""._("am_caravane")."\"",
50 "case cerfa.am_carav_duree when 't' then 'Oui' else 'Non' end as \""._("am_carav_duree")."\"",
51 "case cerfa.am_statio when 't' then 'Oui' else 'Non' end as \""._("am_statio")."\"",
52 "case cerfa.am_statio_cont when 't' then 'Oui' else 'Non' end as \""._("am_statio_cont")."\"",
53 "case cerfa.am_affou_exhau when 't' then 'Oui' else 'Non' end as \""._("am_affou_exhau")."\"",
54 "case cerfa.am_affou_exhau_sup when 't' then 'Oui' else 'Non' end as \""._("am_affou_exhau_sup")."\"",
55 "case cerfa.am_affou_prof when 't' then 'Oui' else 'Non' end as \""._("am_affou_prof")."\"",
56 "case cerfa.am_exhau_haut when 't' then 'Oui' else 'Non' end as \""._("am_exhau_haut")."\"",
57 "case cerfa.am_coupe_abat when 't' then 'Oui' else 'Non' end as \""._("am_coupe_abat")."\"",
58 "case cerfa.am_prot_plu when 't' then 'Oui' else 'Non' end as \""._("am_prot_plu")."\"",
59 "case cerfa.am_prot_muni when 't' then 'Oui' else 'Non' end as \""._("am_prot_muni")."\"",
60 "case cerfa.am_mobil_voyage when 't' then 'Oui' else 'Non' end as \""._("am_mobil_voyage")."\"",
61 "case cerfa.am_aire_voyage when 't' then 'Oui' else 'Non' end as \""._("am_aire_voyage")."\"",
62 "case cerfa.am_rememb_afu when 't' then 'Oui' else 'Non' end as \""._("am_rememb_afu")."\"",
63 "case cerfa.am_parc_resid_loi when 't' then 'Oui' else 'Non' end as \""._("am_parc_resid_loi")."\"",
64 "case cerfa.am_sport_moto when 't' then 'Oui' else 'Non' end as \""._("am_sport_moto")."\"",
65 "case cerfa.am_sport_attrac when 't' then 'Oui' else 'Non' end as \""._("am_sport_attrac")."\"",
66 "case cerfa.am_sport_golf when 't' then 'Oui' else 'Non' end as \""._("am_sport_golf")."\"",
67 "case cerfa.am_mob_art when 't' then 'Oui' else 'Non' end as \""._("am_mob_art")."\"",
68 "case cerfa.am_modif_voie_esp when 't' then 'Oui' else 'Non' end as \""._("am_modif_voie_esp")."\"",
69 "case cerfa.am_plant_voie_esp when 't' then 'Oui' else 'Non' end as \""._("am_plant_voie_esp")."\"",
70 "case cerfa.am_chem_ouv_esp when 't' then 'Oui' else 'Non' end as \""._("am_chem_ouv_esp")."\"",
71 "case cerfa.am_agri_peche when 't' then 'Oui' else 'Non' end as \""._("am_agri_peche")."\"",
72 "case cerfa.am_crea_voie when 't' then 'Oui' else 'Non' end as \""._("am_crea_voie")."\"",
73 "case cerfa.am_modif_voie_exist when 't' then 'Oui' else 'Non' end as \""._("am_modif_voie_exist")."\"",
74 "case cerfa.am_crea_esp_sauv when 't' then 'Oui' else 'Non' end as \""._("am_crea_esp_sauv")."\"",
75 "case cerfa.am_crea_esp_class when 't' then 'Oui' else 'Non' end as \""._("am_crea_esp_class")."\"",
76 "case cerfa.am_projet_desc when 't' then 'Oui' else 'Non' end as \""._("am_projet_desc")."\"",
77 "case cerfa.am_terr_surf when 't' then 'Oui' else 'Non' end as \""._("am_terr_surf")."\"",
78 "case cerfa.am_tranche_desc when 't' then 'Oui' else 'Non' end as \""._("am_tranche_desc")."\"",
79 "case cerfa.am_lot_max_nb when 't' then 'Oui' else 'Non' end as \""._("am_lot_max_nb")."\"",
80 "case cerfa.am_lot_max_shon when 't' then 'Oui' else 'Non' end as \""._("am_lot_max_shon")."\"",
81 "case cerfa.am_lot_cstr_cos when 't' then 'Oui' else 'Non' end as \""._("am_lot_cstr_cos")."\"",
82 "case cerfa.am_lot_cstr_plan when 't' then 'Oui' else 'Non' end as \""._("am_lot_cstr_plan")."\"",
83 "case cerfa.am_lot_cstr_vente when 't' then 'Oui' else 'Non' end as \""._("am_lot_cstr_vente")."\"",
84 "case cerfa.am_lot_fin_diff when 't' then 'Oui' else 'Non' end as \""._("am_lot_fin_diff")."\"",
85 "case cerfa.am_lot_consign when 't' then 'Oui' else 'Non' end as \""._("am_lot_consign")."\"",
86 "case cerfa.am_lot_gar_achev when 't' then 'Oui' else 'Non' end as \""._("am_lot_gar_achev")."\"",
87 "case cerfa.am_lot_vente_ant when 't' then 'Oui' else 'Non' end as \""._("am_lot_vente_ant")."\"",
88 "case cerfa.am_empl_nb when 't' then 'Oui' else 'Non' end as \""._("am_empl_nb")."\"",
89 "case cerfa.am_tente_nb when 't' then 'Oui' else 'Non' end as \""._("am_tente_nb")."\"",
90 "case cerfa.am_carav_nb when 't' then 'Oui' else 'Non' end as \""._("am_carav_nb")."\"",
91 "case cerfa.am_mobil_nb when 't' then 'Oui' else 'Non' end as \""._("am_mobil_nb")."\"",
92 "case cerfa.am_pers_nb when 't' then 'Oui' else 'Non' end as \""._("am_pers_nb")."\"",
93 "case cerfa.am_empl_hll_nb when 't' then 'Oui' else 'Non' end as \""._("am_empl_hll_nb")."\"",
94 "case cerfa.am_hll_shon when 't' then 'Oui' else 'Non' end as \""._("am_hll_shon")."\"",
95 "case cerfa.am_periode_exploit when 't' then 'Oui' else 'Non' end as \""._("am_periode_exploit")."\"",
96 "case cerfa.am_exist_agrand when 't' then 'Oui' else 'Non' end as \""._("am_exist_agrand")."\"",
97 "case cerfa.am_exist_date when 't' then 'Oui' else 'Non' end as \""._("am_exist_date")."\"",
98 "case cerfa.am_exist_num when 't' then 'Oui' else 'Non' end as \""._("am_exist_num")."\"",
99 "case cerfa.am_exist_nb_avant when 't' then 'Oui' else 'Non' end as \""._("am_exist_nb_avant")."\"",
100 "case cerfa.am_exist_nb_apres when 't' then 'Oui' else 'Non' end as \""._("am_exist_nb_apres")."\"",
101 "case cerfa.am_coupe_bois when 't' then 'Oui' else 'Non' end as \""._("am_coupe_bois")."\"",
102 "case cerfa.am_coupe_parc when 't' then 'Oui' else 'Non' end as \""._("am_coupe_parc")."\"",
103 "case cerfa.am_coupe_align when 't' then 'Oui' else 'Non' end as \""._("am_coupe_align")."\"",
104 "case cerfa.am_coupe_ess when 't' then 'Oui' else 'Non' end as \""._("am_coupe_ess")."\"",
105 "case cerfa.am_coupe_age when 't' then 'Oui' else 'Non' end as \""._("am_coupe_age")."\"",
106 "case cerfa.am_coupe_dens when 't' then 'Oui' else 'Non' end as \""._("am_coupe_dens")."\"",
107 "case cerfa.am_coupe_qual when 't' then 'Oui' else 'Non' end as \""._("am_coupe_qual")."\"",
108 "case cerfa.am_coupe_trait when 't' then 'Oui' else 'Non' end as \""._("am_coupe_trait")."\"",
109 "case cerfa.am_coupe_autr when 't' then 'Oui' else 'Non' end as \""._("am_coupe_autr")."\"",
110 "case cerfa.co_archi_recours when 't' then 'Oui' else 'Non' end as \""._("co_archi_recours")."\"",
111 "case cerfa.co_cstr_nouv when 't' then 'Oui' else 'Non' end as \""._("co_cstr_nouv")."\"",
112 "case cerfa.co_cstr_exist when 't' then 'Oui' else 'Non' end as \""._("co_cstr_exist")."\"",
113 "case cerfa.co_cloture when 't' then 'Oui' else 'Non' end as \""._("co_cloture")."\"",
114 "case cerfa.co_elec_tension when 't' then 'Oui' else 'Non' end as \""._("co_elec_tension")."\"",
115 "case cerfa.co_div_terr when 't' then 'Oui' else 'Non' end as \""._("co_div_terr")."\"",
116 "case cerfa.co_projet_desc when 't' then 'Oui' else 'Non' end as \""._("co_projet_desc")."\"",
117 "case cerfa.co_anx_pisc when 't' then 'Oui' else 'Non' end as \""._("co_anx_pisc")."\"",
118 "case cerfa.co_anx_gara when 't' then 'Oui' else 'Non' end as \""._("co_anx_gara")."\"",
119 "case cerfa.co_anx_veran when 't' then 'Oui' else 'Non' end as \""._("co_anx_veran")."\"",
120 "case cerfa.co_anx_abri when 't' then 'Oui' else 'Non' end as \""._("co_anx_abri")."\"",
121 "case cerfa.co_anx_autr when 't' then 'Oui' else 'Non' end as \""._("co_anx_autr")."\"",
122 "case cerfa.co_anx_autr_desc when 't' then 'Oui' else 'Non' end as \""._("co_anx_autr_desc")."\"",
123 "case cerfa.co_tot_log_nb when 't' then 'Oui' else 'Non' end as \""._("co_tot_log_nb")."\"",
124 "case cerfa.co_tot_ind_nb when 't' then 'Oui' else 'Non' end as \""._("co_tot_ind_nb")."\"",
125 "case cerfa.co_tot_coll_nb when 't' then 'Oui' else 'Non' end as \""._("co_tot_coll_nb")."\"",
126 "case cerfa.co_mais_piece_nb when 't' then 'Oui' else 'Non' end as \""._("co_mais_piece_nb")."\"",
127 "case cerfa.co_mais_niv_nb when 't' then 'Oui' else 'Non' end as \""._("co_mais_niv_nb")."\"",
128 "case cerfa.co_fin_lls_nb when 't' then 'Oui' else 'Non' end as \""._("co_fin_lls_nb")."\"",
129 "case cerfa.co_fin_aa_nb when 't' then 'Oui' else 'Non' end as \""._("co_fin_aa_nb")."\"",
130 "case cerfa.co_fin_ptz_nb when 't' then 'Oui' else 'Non' end as \""._("co_fin_ptz_nb")."\"",
131 "case cerfa.co_fin_autr_nb when 't' then 'Oui' else 'Non' end as \""._("co_fin_autr_nb")."\"",
132 "case cerfa.co_fin_autr_desc when 't' then 'Oui' else 'Non' end as \""._("co_fin_autr_desc")."\"",
133 "case cerfa.co_mais_contrat_ind when 't' then 'Oui' else 'Non' end as \""._("co_mais_contrat_ind")."\"",
134 "case cerfa.co_uti_pers when 't' then 'Oui' else 'Non' end as \""._("co_uti_pers")."\"",
135 "case cerfa.co_uti_vente when 't' then 'Oui' else 'Non' end as \""._("co_uti_vente")."\"",
136 "case cerfa.co_uti_loc when 't' then 'Oui' else 'Non' end as \""._("co_uti_loc")."\"",
137 "case cerfa.co_uti_princ when 't' then 'Oui' else 'Non' end as \""._("co_uti_princ")."\"",
138 "case cerfa.co_uti_secon when 't' then 'Oui' else 'Non' end as \""._("co_uti_secon")."\"",
139 "case cerfa.co_resid_agees when 't' then 'Oui' else 'Non' end as \""._("co_resid_agees")."\"",
140 "case cerfa.co_resid_etud when 't' then 'Oui' else 'Non' end as \""._("co_resid_etud")."\"",
141 "case cerfa.co_resid_tourism when 't' then 'Oui' else 'Non' end as \""._("co_resid_tourism")."\"",
142 "case cerfa.co_resid_hot_soc when 't' then 'Oui' else 'Non' end as \""._("co_resid_hot_soc")."\"",
143 "case cerfa.co_resid_soc when 't' then 'Oui' else 'Non' end as \""._("co_resid_soc")."\"",
144 "case cerfa.co_resid_hand when 't' then 'Oui' else 'Non' end as \""._("co_resid_hand")."\"",
145 "case cerfa.co_resid_autr when 't' then 'Oui' else 'Non' end as \""._("co_resid_autr")."\"",
146 "case cerfa.co_resid_autr_desc when 't' then 'Oui' else 'Non' end as \""._("co_resid_autr_desc")."\"",
147 "case cerfa.co_foyer_chamb_nb when 't' then 'Oui' else 'Non' end as \""._("co_foyer_chamb_nb")."\"",
148 "case cerfa.co_log_1p_nb when 't' then 'Oui' else 'Non' end as \""._("co_log_1p_nb")."\"",
149 "case cerfa.co_log_2p_nb when 't' then 'Oui' else 'Non' end as \""._("co_log_2p_nb")."\"",
150 "case cerfa.co_log_3p_nb when 't' then 'Oui' else 'Non' end as \""._("co_log_3p_nb")."\"",
151 "case cerfa.co_log_4p_nb when 't' then 'Oui' else 'Non' end as \""._("co_log_4p_nb")."\"",
152 "case cerfa.co_log_5p_nb when 't' then 'Oui' else 'Non' end as \""._("co_log_5p_nb")."\"",
153 "case cerfa.co_log_6p_nb when 't' then 'Oui' else 'Non' end as \""._("co_log_6p_nb")."\"",
154 "case cerfa.co_bat_niv_nb when 't' then 'Oui' else 'Non' end as \""._("co_bat_niv_nb")."\"",
155 "case cerfa.co_trx_exten when 't' then 'Oui' else 'Non' end as \""._("co_trx_exten")."\"",
156 "case cerfa.co_trx_surelev when 't' then 'Oui' else 'Non' end as \""._("co_trx_surelev")."\"",
157 "case cerfa.co_trx_nivsup when 't' then 'Oui' else 'Non' end as \""._("co_trx_nivsup")."\"",
158 "case cerfa.co_demont_periode when 't' then 'Oui' else 'Non' end as \""._("co_demont_periode")."\"",
159 "case cerfa.co_sp_transport when 't' then 'Oui' else 'Non' end as \""._("co_sp_transport")."\"",
160 "case cerfa.co_sp_enseign when 't' then 'Oui' else 'Non' end as \""._("co_sp_enseign")."\"",
161 "case cerfa.co_sp_act_soc when 't' then 'Oui' else 'Non' end as \""._("co_sp_act_soc")."\"",
162 "case cerfa.co_sp_ouvr_spe when 't' then 'Oui' else 'Non' end as \""._("co_sp_ouvr_spe")."\"",
163 "case cerfa.co_sp_sante when 't' then 'Oui' else 'Non' end as \""._("co_sp_sante")."\"",
164 "case cerfa.co_sp_culture when 't' then 'Oui' else 'Non' end as \""._("co_sp_culture")."\"",
165 "case cerfa.co_statio_avt_nb when 't' then 'Oui' else 'Non' end as \""._("co_statio_avt_nb")."\"",
166 "case cerfa.co_statio_apr_nb when 't' then 'Oui' else 'Non' end as \""._("co_statio_apr_nb")."\"",
167 "case cerfa.co_statio_adr when 't' then 'Oui' else 'Non' end as \""._("co_statio_adr")."\"",
168 "case cerfa.co_statio_place_nb when 't' then 'Oui' else 'Non' end as \""._("co_statio_place_nb")."\"",
169 "case cerfa.co_statio_tot_surf when 't' then 'Oui' else 'Non' end as \""._("co_statio_tot_surf")."\"",
170 "case cerfa.co_statio_tot_shob when 't' then 'Oui' else 'Non' end as \""._("co_statio_tot_shob")."\"",
171 "case cerfa.co_statio_comm_cin_surf when 't' then 'Oui' else 'Non' end as \""._("co_statio_comm_cin_surf")."\"",
172 'cerfa.tab_surface as "'._("tab_surface").'"',
173 "case cerfa.dm_constr_dates when 't' then 'Oui' else 'Non' end as \""._("dm_constr_dates")."\"",
174 "case cerfa.dm_total when 't' then 'Oui' else 'Non' end as \""._("dm_total")."\"",
175 "case cerfa.dm_partiel when 't' then 'Oui' else 'Non' end as \""._("dm_partiel")."\"",
176 "case cerfa.dm_projet_desc when 't' then 'Oui' else 'Non' end as \""._("dm_projet_desc")."\"",
177 "case cerfa.dm_tot_log_nb when 't' then 'Oui' else 'Non' end as \""._("dm_tot_log_nb")."\"",
178 "case cerfa.tax_surf_tot when 't' then 'Oui' else 'Non' end as \""._("tax_surf_tot")."\"",
179 "case cerfa.tax_surf when 't' then 'Oui' else 'Non' end as \""._("tax_surf")."\"",
180 "case cerfa.tax_surf_suppr_mod when 't' then 'Oui' else 'Non' end as \""._("tax_surf_suppr_mod")."\"",
181 'cerfa.tab_tax_su_princ as "'._("tab_tax_su_princ").'"',
182 'cerfa.tab_tax_su_heber as "'._("tab_tax_su_heber").'"',
183 'cerfa.tab_tax_su_secon as "'._("tab_tax_su_secon").'"',
184 'cerfa.tab_tax_su_tot as "'._("tab_tax_su_tot").'"',
185 "case cerfa.tax_ext_pret when 't' then 'Oui' else 'Non' end as \""._("tax_ext_pret")."\"",
186 "case cerfa.tax_ext_desc when 't' then 'Oui' else 'Non' end as \""._("tax_ext_desc")."\"",
187 "case cerfa.tax_surf_tax_exist_cons when 't' then 'Oui' else 'Non' end as \""._("tax_surf_tax_exist_cons")."\"",
188 "case cerfa.tax_log_exist_nb when 't' then 'Oui' else 'Non' end as \""._("tax_log_exist_nb")."\"",
189 "case cerfa.tax_trx_presc_ppr when 't' then 'Oui' else 'Non' end as \""._("tax_trx_presc_ppr")."\"",
190 "case cerfa.tax_monu_hist when 't' then 'Oui' else 'Non' end as \""._("tax_monu_hist")."\"",
191 "case cerfa.tax_comm_nb when 't' then 'Oui' else 'Non' end as \""._("tax_comm_nb")."\"",
192 'cerfa.tab_tax_su_non_habit_surf as "'._("tab_tax_su_non_habit_surf").'"',
193 'cerfa.tab_tax_am as "'._("tab_tax_am").'"',
194 "case cerfa.vsd_surf_planch_smd when 't' then 'Oui' else 'Non' end as \""._("vsd_surf_planch_smd")."\"",
195 "case cerfa.vsd_unit_fonc_sup when 't' then 'Oui' else 'Non' end as \""._("vsd_unit_fonc_sup")."\"",
196 "case cerfa.vsd_unit_fonc_constr_sup when 't' then 'Oui' else 'Non' end as \""._("vsd_unit_fonc_constr_sup")."\"",
197 "case cerfa.vsd_val_terr when 't' then 'Oui' else 'Non' end as \""._("vsd_val_terr")."\"",
198 "case cerfa.vsd_const_sxist_non_dem_surf when 't' then 'Oui' else 'Non' end as \""._("vsd_const_sxist_non_dem_surf")."\"",
199 "case cerfa.vsd_rescr_fisc when 't' then 'Oui' else 'Non' end as \""._("vsd_rescr_fisc")."\"",
200 "case cerfa.pld_val_terr when 't' then 'Oui' else 'Non' end as \""._("pld_val_terr")."\"",
201 "case cerfa.pld_const_exist_dem when 't' then 'Oui' else 'Non' end as \""._("pld_const_exist_dem")."\"",
202 "case cerfa.pld_const_exist_dem_surf when 't' then 'Oui' else 'Non' end as \""._("pld_const_exist_dem_surf")."\"",
203 "case cerfa.code_cnil when 't' then 'Oui' else 'Non' end as \""._("code_cnil")."\"",
204 "case cerfa.terr_juri_titul when 't' then 'Oui' else 'Non' end as \""._("terr_juri_titul")."\"",
205 "case cerfa.terr_juri_lot when 't' then 'Oui' else 'Non' end as \""._("terr_juri_lot")."\"",
206 "case cerfa.terr_juri_zac when 't' then 'Oui' else 'Non' end as \""._("terr_juri_zac")."\"",
207 "case cerfa.terr_juri_afu when 't' then 'Oui' else 'Non' end as \""._("terr_juri_afu")."\"",
208 "case cerfa.terr_juri_pup when 't' then 'Oui' else 'Non' end as \""._("terr_juri_pup")."\"",
209 "case cerfa.terr_juri_oin when 't' then 'Oui' else 'Non' end as \""._("terr_juri_oin")."\"",
210 "case cerfa.terr_juri_desc when 't' then 'Oui' else 'Non' end as \""._("terr_juri_desc")."\"",
211 "case cerfa.terr_div_surf_etab when 't' then 'Oui' else 'Non' end as \""._("terr_div_surf_etab")."\"",
212 "case cerfa.terr_div_surf_av_div when 't' then 'Oui' else 'Non' end as \""._("terr_div_surf_av_div")."\"",
213 "case cerfa.doc_date when 't' then 'Oui' else 'Non' end as \""._("doc_date")."\"",
214 "case cerfa.doc_tot_trav when 't' then 'Oui' else 'Non' end as \""._("doc_tot_trav")."\"",
215 "case cerfa.doc_tranche_trav when 't' then 'Oui' else 'Non' end as \""._("doc_tranche_trav")."\"",
216 "case cerfa.doc_tranche_trav_desc when 't' then 'Oui' else 'Non' end as \""._("doc_tranche_trav_desc")."\"",
217 "case cerfa.doc_surf when 't' then 'Oui' else 'Non' end as \""._("doc_surf")."\"",
218 "case cerfa.doc_nb_log when 't' then 'Oui' else 'Non' end as \""._("doc_nb_log")."\"",
219 "case cerfa.doc_nb_log_indiv when 't' then 'Oui' else 'Non' end as \""._("doc_nb_log_indiv")."\"",
220 "case cerfa.doc_nb_log_coll when 't' then 'Oui' else 'Non' end as \""._("doc_nb_log_coll")."\"",
221 "case cerfa.doc_nb_log_lls when 't' then 'Oui' else 'Non' end as \""._("doc_nb_log_lls")."\"",
222 "case cerfa.doc_nb_log_aa when 't' then 'Oui' else 'Non' end as \""._("doc_nb_log_aa")."\"",
223 "case cerfa.doc_nb_log_ptz when 't' then 'Oui' else 'Non' end as \""._("doc_nb_log_ptz")."\"",
224 "case cerfa.doc_nb_log_autre when 't' then 'Oui' else 'Non' end as \""._("doc_nb_log_autre")."\"",
225 "case cerfa.daact_date when 't' then 'Oui' else 'Non' end as \""._("daact_date")."\"",
226 "case cerfa.daact_date_chgmt_dest when 't' then 'Oui' else 'Non' end as \""._("daact_date_chgmt_dest")."\"",
227 "case cerfa.daact_tot_trav when 't' then 'Oui' else 'Non' end as \""._("daact_tot_trav")."\"",
228 "case cerfa.daact_tranche_trav when 't' then 'Oui' else 'Non' end as \""._("daact_tranche_trav")."\"",
229 "case cerfa.daact_tranche_trav_desc when 't' then 'Oui' else 'Non' end as \""._("daact_tranche_trav_desc")."\"",
230 "case cerfa.daact_surf when 't' then 'Oui' else 'Non' end as \""._("daact_surf")."\"",
231 "case cerfa.daact_nb_log when 't' then 'Oui' else 'Non' end as \""._("daact_nb_log")."\"",
232 "case cerfa.daact_nb_log_indiv when 't' then 'Oui' else 'Non' end as \""._("daact_nb_log_indiv")."\"",
233 "case cerfa.daact_nb_log_coll when 't' then 'Oui' else 'Non' end as \""._("daact_nb_log_coll")."\"",
234 "case cerfa.daact_nb_log_lls when 't' then 'Oui' else 'Non' end as \""._("daact_nb_log_lls")."\"",
235 "case cerfa.daact_nb_log_aa when 't' then 'Oui' else 'Non' end as \""._("daact_nb_log_aa")."\"",
236 "case cerfa.daact_nb_log_ptz when 't' then 'Oui' else 'Non' end as \""._("daact_nb_log_ptz")."\"",
237 "case cerfa.daact_nb_log_autre when 't' then 'Oui' else 'Non' end as \""._("daact_nb_log_autre")."\"",
238 "case cerfa.am_div_mun when 't' then 'Oui' else 'Non' end as \""._("am_div_mun")."\"",
239 "case cerfa.co_perf_energ when 't' then 'Oui' else 'Non' end as \""._("co_perf_energ")."\"",
240 "case cerfa.architecte when 't' then 'Oui' else 'Non' end as \""._("architecte")."\"",
241 "case cerfa.co_statio_avt_shob when 't' then 'Oui' else 'Non' end as \""._("co_statio_avt_shob")."\"",
242 "case cerfa.co_statio_apr_shob when 't' then 'Oui' else 'Non' end as \""._("co_statio_apr_shob")."\"",
243 "case cerfa.co_statio_avt_surf when 't' then 'Oui' else 'Non' end as \""._("co_statio_avt_surf")."\"",
244 "case cerfa.co_statio_apr_surf when 't' then 'Oui' else 'Non' end as \""._("co_statio_apr_surf")."\"",
245 "case cerfa.co_trx_amgt when 't' then 'Oui' else 'Non' end as \""._("co_trx_amgt")."\"",
246 "case cerfa.co_modif_aspect when 't' then 'Oui' else 'Non' end as \""._("co_modif_aspect")."\"",
247 "case cerfa.co_modif_struct when 't' then 'Oui' else 'Non' end as \""._("co_modif_struct")."\"",
248 "case cerfa.co_ouvr_elec when 't' then 'Oui' else 'Non' end as \""._("co_ouvr_elec")."\"",
249 "case cerfa.co_ouvr_infra when 't' then 'Oui' else 'Non' end as \""._("co_ouvr_infra")."\"",
250 "case cerfa.co_trx_imm when 't' then 'Oui' else 'Non' end as \""._("co_trx_imm")."\"",
251 "case cerfa.co_cstr_shob when 't' then 'Oui' else 'Non' end as \""._("co_cstr_shob")."\"",
252 "case cerfa.am_voyage_deb when 't' then 'Oui' else 'Non' end as \""._("am_voyage_deb")."\"",
253 "case cerfa.am_voyage_fin when 't' then 'Oui' else 'Non' end as \""._("am_voyage_fin")."\"",
254 "case cerfa.am_modif_amgt when 't' then 'Oui' else 'Non' end as \""._("am_modif_amgt")."\"",
255 "case cerfa.am_lot_max_shob when 't' then 'Oui' else 'Non' end as \""._("am_lot_max_shob")."\"",
256 "case cerfa.mod_desc when 't' then 'Oui' else 'Non' end as \""._("mod_desc")."\"",
257 "case cerfa.tr_total when 't' then 'Oui' else 'Non' end as \""._("tr_total")."\"",
258 "case cerfa.tr_partiel when 't' then 'Oui' else 'Non' end as \""._("tr_partiel")."\"",
259 "case cerfa.tr_desc when 't' then 'Oui' else 'Non' end as \""._("tr_desc")."\"",
260 "case cerfa.avap_co_elt_pro when 't' then 'Oui' else 'Non' end as \""._("avap_co_elt_pro")."\"",
261 "case cerfa.avap_nouv_haut_surf when 't' then 'Oui' else 'Non' end as \""._("avap_nouv_haut_surf")."\"",
262 "case cerfa.avap_co_clot when 't' then 'Oui' else 'Non' end as \""._("avap_co_clot")."\"",
263 "case cerfa.avap_aut_coup_aba_arb when 't' then 'Oui' else 'Non' end as \""._("avap_aut_coup_aba_arb")."\"",
264 "case cerfa.avap_ouv_infra when 't' then 'Oui' else 'Non' end as \""._("avap_ouv_infra")."\"",
265 "case cerfa.avap_aut_inst_mob when 't' then 'Oui' else 'Non' end as \""._("avap_aut_inst_mob")."\"",
266 "case cerfa.avap_aut_plant when 't' then 'Oui' else 'Non' end as \""._("avap_aut_plant")."\"",
267 "case cerfa.avap_aut_auv_elec when 't' then 'Oui' else 'Non' end as \""._("avap_aut_auv_elec")."\"",
268 "case cerfa.tax_dest_loc_tr when 't' then 'Oui' else 'Non' end as \""._("tax_dest_loc_tr")."\"",
269 "case cerfa.ope_proj_desc when 't' then 'Oui' else 'Non' end as \""._("ope_proj_desc")."\"",
270 "case cerfa.tax_surf_tot_cstr when 't' then 'Oui' else 'Non' end as \""._("tax_surf_tot_cstr")."\"",
271 "case cerfa.tax_surf_loc_stat when 't' then 'Oui' else 'Non' end as \""._("tax_surf_loc_stat")."\"",
272 "case cerfa.tax_log_ap_trvx_nb when 't' then 'Oui' else 'Non' end as \""._("tax_log_ap_trvx_nb")."\"",
273 "case cerfa.tax_am_statio_ext_cr when 't' then 'Oui' else 'Non' end as \""._("tax_am_statio_ext_cr")."\"",
274 "case cerfa.tax_sup_bass_pisc_cr when 't' then 'Oui' else 'Non' end as \""._("tax_sup_bass_pisc_cr")."\"",
275 "case cerfa.tax_empl_ten_carav_mobil_nb_cr when 't' then 'Oui' else 'Non' end as \""._("tax_empl_ten_carav_mobil_nb_cr")."\"",
276 "case cerfa.tax_empl_hll_nb_cr when 't' then 'Oui' else 'Non' end as \""._("tax_empl_hll_nb_cr")."\"",
277 "case cerfa.tax_eol_haut_nb_cr when 't' then 'Oui' else 'Non' end as \""._("tax_eol_haut_nb_cr")."\"",
278 "case cerfa.tax_pann_volt_sup_cr when 't' then 'Oui' else 'Non' end as \""._("tax_pann_volt_sup_cr")."\"",
279 "case cerfa.tax_surf_loc_arch when 't' then 'Oui' else 'Non' end as \""._("tax_surf_loc_arch")."\"",
280 "case cerfa.tax_surf_pisc_arch when 't' then 'Oui' else 'Non' end as \""._("tax_surf_pisc_arch")."\"",
281 "case cerfa.tax_am_statio_ext_arch when 't' then 'Oui' else 'Non' end as \""._("tax_am_statio_ext_arch")."\"",
282 'cerfa.tab_tax_su_parc_statio_expl_comm as "'._("tab_tax_su_parc_statio_expl_comm").'"',
283 "case cerfa.tax_empl_ten_carav_mobil_nb_arch when 't' then 'Oui' else 'Non' end as \""._("tax_empl_ten_carav_mobil_nb_arch")."\"",
284 "case cerfa.tax_empl_hll_nb_arch when 't' then 'Oui' else 'Non' end as \""._("tax_empl_hll_nb_arch")."\"",
285 "case cerfa.tax_eol_haut_nb_arch when 't' then 'Oui' else 'Non' end as \""._("tax_eol_haut_nb_arch")."\"",
286 "case cerfa.ope_proj_div_co when 't' then 'Oui' else 'Non' end as \""._("ope_proj_div_co")."\"",
287 "case cerfa.ope_proj_div_contr when 't' then 'Oui' else 'Non' end as \""._("ope_proj_div_contr")."\"",
288 "case cerfa.tax_desc when 't' then 'Oui' else 'Non' end as \""._("tax_desc")."\"",
289 "case cerfa.erp_cstr_neuve when 't' then 'Oui' else 'Non' end as \""._("erp_cstr_neuve")."\"",
290 "case cerfa.erp_trvx_acc when 't' then 'Oui' else 'Non' end as \""._("erp_trvx_acc")."\"",
291 "case cerfa.erp_extension when 't' then 'Oui' else 'Non' end as \""._("erp_extension")."\"",
292 "case cerfa.erp_rehab when 't' then 'Oui' else 'Non' end as \""._("erp_rehab")."\"",
293 "case cerfa.erp_trvx_am when 't' then 'Oui' else 'Non' end as \""._("erp_trvx_am")."\"",
294 "case cerfa.erp_vol_nouv_exist when 't' then 'Oui' else 'Non' end as \""._("erp_vol_nouv_exist")."\"",
295 'cerfa.tab_erp_eff as "'._("tab_erp_eff").'"',
296 "case cerfa.erp_class_cat when 't' then 'Oui' else 'Non' end as \""._("erp_class_cat")."\"",
297 "case cerfa.erp_class_type when 't' then 'Oui' else 'Non' end as \""._("erp_class_type")."\"",
298 "case cerfa.tax_surf_abr_jard_pig_colom when 't' then 'Oui' else 'Non' end as \""._("tax_surf_abr_jard_pig_colom")."\"",
299 "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")."\"",
300 "case cerfa.dia_imm_non_bati when 't' then 'Oui' else 'Non' end as \""._("dia_imm_non_bati")."\"",
301 "case cerfa.dia_imm_bati_terr_propr when 't' then 'Oui' else 'Non' end as \""._("dia_imm_bati_terr_propr")."\"",
302 "case cerfa.dia_imm_bati_terr_autr when 't' then 'Oui' else 'Non' end as \""._("dia_imm_bati_terr_autr")."\"",
303 "case cerfa.dia_imm_bati_terr_autr_desc when 't' then 'Oui' else 'Non' end as \""._("dia_imm_bati_terr_autr_desc")."\"",
304 "case cerfa.dia_bat_copro when 't' then 'Oui' else 'Non' end as \""._("dia_bat_copro")."\"",
305 "case cerfa.dia_bat_copro_desc when 't' then 'Oui' else 'Non' end as \""._("dia_bat_copro_desc")."\"",
306 "case cerfa.dia_lot_numero when 't' then 'Oui' else 'Non' end as \""._("dia_lot_numero")."\"",
307 "case cerfa.dia_lot_bat when 't' then 'Oui' else 'Non' end as \""._("dia_lot_bat")."\"",
308 "case cerfa.dia_lot_etage when 't' then 'Oui' else 'Non' end as \""._("dia_lot_etage")."\"",
309 "case cerfa.dia_lot_quote_part when 't' then 'Oui' else 'Non' end as \""._("dia_lot_quote_part")."\"",
310 "case cerfa.dia_us_hab when 't' then 'Oui' else 'Non' end as \""._("dia_us_hab")."\"",
311 "case cerfa.dia_us_pro when 't' then 'Oui' else 'Non' end as \""._("dia_us_pro")."\"",
312 "case cerfa.dia_us_mixte when 't' then 'Oui' else 'Non' end as \""._("dia_us_mixte")."\"",
313 "case cerfa.dia_us_comm when 't' then 'Oui' else 'Non' end as \""._("dia_us_comm")."\"",
314 "case cerfa.dia_us_agr when 't' then 'Oui' else 'Non' end as \""._("dia_us_agr")."\"",
315 "case cerfa.dia_us_autre when 't' then 'Oui' else 'Non' end as \""._("dia_us_autre")."\"",
316 "case cerfa.dia_us_autre_prec when 't' then 'Oui' else 'Non' end as \""._("dia_us_autre_prec")."\"",
317 "case cerfa.dia_occ_prop when 't' then 'Oui' else 'Non' end as \""._("dia_occ_prop")."\"",
318 "case cerfa.dia_occ_loc when 't' then 'Oui' else 'Non' end as \""._("dia_occ_loc")."\"",
319 "case cerfa.dia_occ_sans_occ when 't' then 'Oui' else 'Non' end as \""._("dia_occ_sans_occ")."\"",
320 "case cerfa.dia_occ_autre when 't' then 'Oui' else 'Non' end as \""._("dia_occ_autre")."\"",
321 "case cerfa.dia_occ_autre_prec when 't' then 'Oui' else 'Non' end as \""._("dia_occ_autre_prec")."\"",
322 "case cerfa.dia_mod_cess_prix_vente when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_prix_vente")."\"",
323 "case cerfa.dia_mod_cess_prix_vente_mob when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_prix_vente_mob")."\"",
324 "case cerfa.dia_mod_cess_prix_vente_cheptel when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_prix_vente_cheptel")."\"",
325 "case cerfa.dia_mod_cess_prix_vente_recol when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_prix_vente_recol")."\"",
326 "case cerfa.dia_mod_cess_prix_vente_autre when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_prix_vente_autre")."\"",
327 "case cerfa.dia_mod_cess_commi when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_commi")."\"",
328 "case cerfa.dia_mod_cess_commi_ttc when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_commi_ttc")."\"",
329 "case cerfa.dia_mod_cess_commi_ht when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_commi_ht")."\"",
330 "case cerfa.dia_acquereur_nom_prenom when 't' then 'Oui' else 'Non' end as \""._("dia_acquereur_nom_prenom")."\"",
331 "case cerfa.dia_acquereur_adr_num_voie when 't' then 'Oui' else 'Non' end as \""._("dia_acquereur_adr_num_voie")."\"",
332 "case cerfa.dia_acquereur_adr_ext when 't' then 'Oui' else 'Non' end as \""._("dia_acquereur_adr_ext")."\"",
333 "case cerfa.dia_acquereur_adr_type_voie when 't' then 'Oui' else 'Non' end as \""._("dia_acquereur_adr_type_voie")."\"",
334 "case cerfa.dia_acquereur_adr_nom_voie when 't' then 'Oui' else 'Non' end as \""._("dia_acquereur_adr_nom_voie")."\"",
335 "case cerfa.dia_acquereur_adr_lieu_dit_bp when 't' then 'Oui' else 'Non' end as \""._("dia_acquereur_adr_lieu_dit_bp")."\"",
336 "case cerfa.dia_acquereur_adr_cp when 't' then 'Oui' else 'Non' end as \""._("dia_acquereur_adr_cp")."\"",
337 "case cerfa.dia_acquereur_adr_localite when 't' then 'Oui' else 'Non' end as \""._("dia_acquereur_adr_localite")."\"",
338 "case cerfa.dia_observation when 't' then 'Oui' else 'Non' end as \""._("dia_observation")."\"",
339 'cerfa.tab_surface2 as "'._("tab_surface2").'"',
340 "case cerfa.dia_occ_sol_su_terre when 't' then 'Oui' else 'Non' end as \""._("dia_occ_sol_su_terre")."\"",
341 "case cerfa.dia_occ_sol_su_pres when 't' then 'Oui' else 'Non' end as \""._("dia_occ_sol_su_pres")."\"",
342 "case cerfa.dia_occ_sol_su_verger when 't' then 'Oui' else 'Non' end as \""._("dia_occ_sol_su_verger")."\"",
343 "case cerfa.dia_occ_sol_su_vigne when 't' then 'Oui' else 'Non' end as \""._("dia_occ_sol_su_vigne")."\"",
344 "case cerfa.dia_occ_sol_su_bois when 't' then 'Oui' else 'Non' end as \""._("dia_occ_sol_su_bois")."\"",
345 "case cerfa.dia_occ_sol_su_lande when 't' then 'Oui' else 'Non' end as \""._("dia_occ_sol_su_lande")."\"",
346 "case cerfa.dia_occ_sol_su_carriere when 't' then 'Oui' else 'Non' end as \""._("dia_occ_sol_su_carriere")."\"",
347 "case cerfa.dia_occ_sol_su_eau_cadastree when 't' then 'Oui' else 'Non' end as \""._("dia_occ_sol_su_eau_cadastree")."\"",
348 "case cerfa.dia_occ_sol_su_jardin when 't' then 'Oui' else 'Non' end as \""._("dia_occ_sol_su_jardin")."\"",
349 "case cerfa.dia_occ_sol_su_terr_batir when 't' then 'Oui' else 'Non' end as \""._("dia_occ_sol_su_terr_batir")."\"",
350 "case cerfa.dia_occ_sol_su_terr_agr when 't' then 'Oui' else 'Non' end as \""._("dia_occ_sol_su_terr_agr")."\"",
351 "case cerfa.dia_occ_sol_su_sol when 't' then 'Oui' else 'Non' end as \""._("dia_occ_sol_su_sol")."\"",
352 "case cerfa.dia_bati_vend_tot when 't' then 'Oui' else 'Non' end as \""._("dia_bati_vend_tot")."\"",
353 "case cerfa.dia_bati_vend_tot_txt when 't' then 'Oui' else 'Non' end as \""._("dia_bati_vend_tot_txt")."\"",
354 "case cerfa.dia_su_co_sol when 't' then 'Oui' else 'Non' end as \""._("dia_su_co_sol")."\"",
355 "case cerfa.dia_su_util_hab when 't' then 'Oui' else 'Non' end as \""._("dia_su_util_hab")."\"",
356 "case cerfa.dia_nb_niv when 't' then 'Oui' else 'Non' end as \""._("dia_nb_niv")."\"",
357 "case cerfa.dia_nb_appart when 't' then 'Oui' else 'Non' end as \""._("dia_nb_appart")."\"",
358 "case cerfa.dia_nb_autre_loc when 't' then 'Oui' else 'Non' end as \""._("dia_nb_autre_loc")."\"",
359 "case cerfa.dia_vente_lot_volume when 't' then 'Oui' else 'Non' end as \""._("dia_vente_lot_volume")."\"",
360 "case cerfa.dia_vente_lot_volume_txt when 't' then 'Oui' else 'Non' end as \""._("dia_vente_lot_volume_txt")."\"",
361 "case cerfa.dia_lot_nat_su when 't' then 'Oui' else 'Non' end as \""._("dia_lot_nat_su")."\"",
362 "case cerfa.dia_lot_bat_achv_plus_10 when 't' then 'Oui' else 'Non' end as \""._("dia_lot_bat_achv_plus_10")."\"",
363 "case cerfa.dia_lot_bat_achv_moins_10 when 't' then 'Oui' else 'Non' end as \""._("dia_lot_bat_achv_moins_10")."\"",
364 "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")."\"",
365 "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")."\"",
366 "case cerfa.dia_indivi_quote_part when 't' then 'Oui' else 'Non' end as \""._("dia_indivi_quote_part")."\"",
367 "case cerfa.dia_design_societe when 't' then 'Oui' else 'Non' end as \""._("dia_design_societe")."\"",
368 "case cerfa.dia_design_droit when 't' then 'Oui' else 'Non' end as \""._("dia_design_droit")."\"",
369 "case cerfa.dia_droit_soc_nat when 't' then 'Oui' else 'Non' end as \""._("dia_droit_soc_nat")."\"",
370 "case cerfa.dia_droit_soc_nb when 't' then 'Oui' else 'Non' end as \""._("dia_droit_soc_nb")."\"",
371 "case cerfa.dia_droit_soc_num_part when 't' then 'Oui' else 'Non' end as \""._("dia_droit_soc_num_part")."\"",
372 "case cerfa.dia_droit_reel_perso_grevant_bien_oui when 't' then 'Oui' else 'Non' end as \""._("dia_droit_reel_perso_grevant_bien_oui")."\"",
373 "case cerfa.dia_droit_reel_perso_grevant_bien_non when 't' then 'Oui' else 'Non' end as \""._("dia_droit_reel_perso_grevant_bien_non")."\"",
374 "case cerfa.dia_droit_reel_perso_nat when 't' then 'Oui' else 'Non' end as \""._("dia_droit_reel_perso_nat")."\"",
375 "case cerfa.dia_droit_reel_perso_viag when 't' then 'Oui' else 'Non' end as \""._("dia_droit_reel_perso_viag")."\"",
376 "case cerfa.dia_mod_cess_adr when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_adr")."\"",
377 "case cerfa.dia_mod_cess_sign_act_auth when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_sign_act_auth")."\"",
378 "case cerfa.dia_mod_cess_terme when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_terme")."\"",
379 "case cerfa.dia_mod_cess_terme_prec when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_terme_prec")."\"",
380 "case cerfa.dia_mod_cess_bene_acquereur when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_bene_acquereur")."\"",
381 "case cerfa.dia_mod_cess_bene_vendeur when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_bene_vendeur")."\"",
382 "case cerfa.dia_mod_cess_paie_nat when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_paie_nat")."\"",
383 "case cerfa.dia_mod_cess_design_contr_alien when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_design_contr_alien")."\"",
384 "case cerfa.dia_mod_cess_eval_contr when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_eval_contr")."\"",
385 "case cerfa.dia_mod_cess_rente_viag when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_rente_viag")."\"",
386 "case cerfa.dia_mod_cess_mnt_an when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_mnt_an")."\"",
387 "case cerfa.dia_mod_cess_mnt_compt when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_mnt_compt")."\"",
388 "case cerfa.dia_mod_cess_bene_rente when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_bene_rente")."\"",
389 "case cerfa.dia_mod_cess_droit_usa_hab when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_droit_usa_hab")."\"",
390 "case cerfa.dia_mod_cess_droit_usa_hab_prec when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_droit_usa_hab_prec")."\"",
391 "case cerfa.dia_mod_cess_eval_usa_usufruit when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_eval_usa_usufruit")."\"",
392 "case cerfa.dia_mod_cess_vente_nue_prop when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_vente_nue_prop")."\"",
393 "case cerfa.dia_mod_cess_vente_nue_prop_prec when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_vente_nue_prop_prec")."\"",
394 "case cerfa.dia_mod_cess_echange when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_echange")."\"",
395 "case cerfa.dia_mod_cess_design_bien_recus_ech when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_design_bien_recus_ech")."\"",
396 "case cerfa.dia_mod_cess_mnt_soulte when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_mnt_soulte")."\"",
397 "case cerfa.dia_mod_cess_prop_contre_echan when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_prop_contre_echan")."\"",
398 "case cerfa.dia_mod_cess_apport_societe when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_apport_societe")."\"",
399 "case cerfa.dia_mod_cess_bene when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_bene")."\"",
400 "case cerfa.dia_mod_cess_esti_bien when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_esti_bien")."\"",
401 "case cerfa.dia_mod_cess_cess_terr_loc_co when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_cess_terr_loc_co")."\"",
402 "case cerfa.dia_mod_cess_esti_terr when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_esti_terr")."\"",
403 "case cerfa.dia_mod_cess_esti_loc when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_esti_loc")."\"",
404 "case cerfa.dia_mod_cess_esti_imm_loca when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_esti_imm_loca")."\"",
405 "case cerfa.dia_mod_cess_adju_vol when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_adju_vol")."\"",
406 "case cerfa.dia_mod_cess_adju_obl when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_adju_obl")."\"",
407 "case cerfa.dia_mod_cess_adju_fin_indivi when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_adju_fin_indivi")."\"",
408 "case cerfa.dia_mod_cess_adju_date_lieu when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_adju_date_lieu")."\"",
409 "case cerfa.dia_mod_cess_mnt_mise_prix when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_mnt_mise_prix")."\"",
410 "case cerfa.dia_prop_titu_prix_indique when 't' then 'Oui' else 'Non' end as \""._("dia_prop_titu_prix_indique")."\"",
411 "case cerfa.dia_prop_recherche_acqu_prix_indique when 't' then 'Oui' else 'Non' end as \""._("dia_prop_recherche_acqu_prix_indique")."\"",
412 "case cerfa.dia_acquereur_prof when 't' then 'Oui' else 'Non' end as \""._("dia_acquereur_prof")."\"",
413 "case cerfa.dia_indic_compl_ope when 't' then 'Oui' else 'Non' end as \""._("dia_indic_compl_ope")."\"",
414 "case cerfa.dia_vente_adju when 't' then 'Oui' else 'Non' end as \""._("dia_vente_adju")."\"",
415 "case cerfa.am_terr_res_demon when 't' then 'Oui' else 'Non' end as \""._("am_terr_res_demon")."\"",
416 "case cerfa.am_air_terr_res_mob when 't' then 'Oui' else 'Non' end as \""._("am_air_terr_res_mob")."\"",
417 "case cerfa.ctx_objet_recours when 't' then 'Oui' else 'Non' end as \""._("ctx_objet_recours")."\"",
418 "case cerfa.ctx_moyen_souleve when 't' then 'Oui' else 'Non' end as \""._("ctx_moyen_souleve")."\"",
419 "case cerfa.ctx_moyen_retenu_juge when 't' then 'Oui' else 'Non' end as \""._("ctx_moyen_retenu_juge")."\"",
420 "case cerfa.ctx_reference_sagace when 't' then 'Oui' else 'Non' end as \""._("ctx_reference_sagace")."\"",
421 "case cerfa.ctx_nature_travaux_infra_om_html when 't' then 'Oui' else 'Non' end as \""._("ctx_nature_travaux_infra_om_html")."\"",
422 "case cerfa.ctx_synthese_nti when 't' then 'Oui' else 'Non' end as \""._("ctx_synthese_nti")."\"",
423 "case cerfa.ctx_article_non_resp_om_html when 't' then 'Oui' else 'Non' end as \""._("ctx_article_non_resp_om_html")."\"",
424 "case cerfa.ctx_synthese_anr when 't' then 'Oui' else 'Non' end as \""._("ctx_synthese_anr")."\"",
425 "case cerfa.ctx_reference_parquet when 't' then 'Oui' else 'Non' end as \""._("ctx_reference_parquet")."\"",
426 "case cerfa.ctx_element_taxation when 't' then 'Oui' else 'Non' end as \""._("ctx_element_taxation")."\"",
427 "case cerfa.ctx_infraction when 't' then 'Oui' else 'Non' end as \""._("ctx_infraction")."\"",
428 "case cerfa.ctx_regularisable when 't' then 'Oui' else 'Non' end as \""._("ctx_regularisable")."\"",
429 "case cerfa.ctx_reference_courrier when 't' then 'Oui' else 'Non' end as \""._("ctx_reference_courrier")."\"",
430 "case cerfa.ctx_date_audience when 't' then 'Oui' else 'Non' end as \""._("ctx_date_audience")."\"",
431 "case cerfa.ctx_date_ajournement when 't' then 'Oui' else 'Non' end as \""._("ctx_date_ajournement")."\"",
432 );
433 //
434 $champNonAffiche = array(
435 );
436 //
437 $champRecherche = array(
438 'cerfa.cerfa as "'._("cerfa").'"',
439 'cerfa.libelle as "'._("libelle").'"',
440 'cerfa.code as "'._("code").'"',
441 'cerfa.tab_surface as "'._("tab_surface").'"',
442 'cerfa.tab_tax_su_princ as "'._("tab_tax_su_princ").'"',
443 'cerfa.tab_tax_su_heber as "'._("tab_tax_su_heber").'"',
444 'cerfa.tab_tax_su_secon as "'._("tab_tax_su_secon").'"',
445 'cerfa.tab_tax_su_tot as "'._("tab_tax_su_tot").'"',
446 'cerfa.tab_tax_su_non_habit_surf as "'._("tab_tax_su_non_habit_surf").'"',
447 'cerfa.tab_tax_am as "'._("tab_tax_am").'"',
448 'cerfa.tab_tax_su_parc_statio_expl_comm as "'._("tab_tax_su_parc_statio_expl_comm").'"',
449 'cerfa.tab_erp_eff as "'._("tab_erp_eff").'"',
450 'cerfa.tab_surface2 as "'._("tab_surface2").'"',
451 );
452 $tri="ORDER BY cerfa.libelle ASC NULLS LAST";
453 $edition="cerfa";
454 /**
455 * Gestion de la clause WHERE => $selection
456 */
457 // Filtre listing standard
458 $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)))";
459 $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)))";
460 // Gestion OMValidité - Suppression du filtre si paramètre
461 if (isset($_GET["valide"]) and $_GET["valide"] == "false") {
462 if (!isset($where_om_validite)
463 or (isset($where_om_validite) and $where_om_validite == "")) {
464 if (trim($selection) != "") {
465 $selection = "";
466 }
467 } else {
468 $selection = trim(str_replace($where_om_validite, "", $selection));
469 }
470 }
471
472 /**
473 * Gestion SOUSFORMULAIRE => $sousformulaire
474 */
475 $sousformulaire = array(
476 'dossier_autorisation_type_detaille',
477 );
478
479 ?>
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26