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