".__("donnees_techniques"); if(!isset($premier)) $premier=''; if(!isset($tricolsf)) $tricolsf=''; if(!isset($premiersf)) $premiersf=''; if(!isset($selection)) $selection=''; if(!isset($retourformulaire)) $retourformulaire=''; if (!isset($idxformulaire)) { $idxformulaire = ''; } if (!isset($tricol)) { $tricol = ''; } if (!isset($valide)) { $valide = ''; } // FROM $table = DB_PREFIXE."donnees_techniques LEFT JOIN ".DB_PREFIXE."architecte ON donnees_techniques.architecte=architecte.architecte LEFT JOIN ".DB_PREFIXE."objet_recours ON donnees_techniques.ctx_objet_recours=objet_recours.objet_recours LEFT JOIN ".DB_PREFIXE."dossier_autorisation ON donnees_techniques.dossier_autorisation=dossier_autorisation.dossier_autorisation LEFT JOIN ".DB_PREFIXE."dossier ON donnees_techniques.dossier_instruction=dossier.dossier LEFT JOIN ".DB_PREFIXE."lot ON donnees_techniques.lot=lot.lot "; // SELECT $champAffiche = array( 'donnees_techniques.donnees_techniques as "'.__("donnees_techniques").'"', 'dossier.annee as "'.__("dossier_instruction").'"', 'lot.libelle as "'.__("lot").'"', "case donnees_techniques.am_lotiss when 't' then 'Oui' else 'Non' end as \"".__("am_lotiss")."\"", "case donnees_techniques.am_autre_div when 't' then 'Oui' else 'Non' end as \"".__("am_autre_div")."\"", "case donnees_techniques.am_camping when 't' then 'Oui' else 'Non' end as \"".__("am_camping")."\"", "case donnees_techniques.am_caravane when 't' then 'Oui' else 'Non' end as \"".__("am_caravane")."\"", 'donnees_techniques.am_carav_duree as "'.__("am_carav_duree").'"', "case donnees_techniques.am_statio when 't' then 'Oui' else 'Non' end as \"".__("am_statio")."\"", 'donnees_techniques.am_statio_cont as "'.__("am_statio_cont").'"', "case donnees_techniques.am_affou_exhau when 't' then 'Oui' else 'Non' end as \"".__("am_affou_exhau")."\"", 'donnees_techniques.am_affou_exhau_sup as "'.__("am_affou_exhau_sup").'"', 'donnees_techniques.am_affou_prof as "'.__("am_affou_prof").'"', 'donnees_techniques.am_exhau_haut as "'.__("am_exhau_haut").'"', "case donnees_techniques.am_coupe_abat when 't' then 'Oui' else 'Non' end as \"".__("am_coupe_abat")."\"", "case donnees_techniques.am_prot_plu when 't' then 'Oui' else 'Non' end as \"".__("am_prot_plu")."\"", "case donnees_techniques.am_prot_muni when 't' then 'Oui' else 'Non' end as \"".__("am_prot_muni")."\"", "case donnees_techniques.am_mobil_voyage when 't' then 'Oui' else 'Non' end as \"".__("am_mobil_voyage")."\"", "case donnees_techniques.am_aire_voyage when 't' then 'Oui' else 'Non' end as \"".__("am_aire_voyage")."\"", "case donnees_techniques.am_rememb_afu when 't' then 'Oui' else 'Non' end as \"".__("am_rememb_afu")."\"", "case donnees_techniques.am_parc_resid_loi when 't' then 'Oui' else 'Non' end as \"".__("am_parc_resid_loi")."\"", "case donnees_techniques.am_sport_moto when 't' then 'Oui' else 'Non' end as \"".__("am_sport_moto")."\"", "case donnees_techniques.am_sport_attrac when 't' then 'Oui' else 'Non' end as \"".__("am_sport_attrac")."\"", "case donnees_techniques.am_sport_golf when 't' then 'Oui' else 'Non' end as \"".__("am_sport_golf")."\"", "case donnees_techniques.am_mob_art when 't' then 'Oui' else 'Non' end as \"".__("am_mob_art")."\"", "case donnees_techniques.am_modif_voie_esp when 't' then 'Oui' else 'Non' end as \"".__("am_modif_voie_esp")."\"", "case donnees_techniques.am_plant_voie_esp when 't' then 'Oui' else 'Non' end as \"".__("am_plant_voie_esp")."\"", "case donnees_techniques.am_chem_ouv_esp when 't' then 'Oui' else 'Non' end as \"".__("am_chem_ouv_esp")."\"", "case donnees_techniques.am_agri_peche when 't' then 'Oui' else 'Non' end as \"".__("am_agri_peche")."\"", "case donnees_techniques.am_crea_voie when 't' then 'Oui' else 'Non' end as \"".__("am_crea_voie")."\"", "case donnees_techniques.am_modif_voie_exist when 't' then 'Oui' else 'Non' end as \"".__("am_modif_voie_exist")."\"", "case donnees_techniques.am_crea_esp_sauv when 't' then 'Oui' else 'Non' end as \"".__("am_crea_esp_sauv")."\"", "case donnees_techniques.am_crea_esp_class when 't' then 'Oui' else 'Non' end as \"".__("am_crea_esp_class")."\"", 'donnees_techniques.am_terr_surf as "'.__("am_terr_surf").'"', 'donnees_techniques.am_lot_max_nb as "'.__("am_lot_max_nb").'"', 'donnees_techniques.am_lot_max_shon as "'.__("am_lot_max_shon").'"', "case donnees_techniques.am_lot_cstr_cos when 't' then 'Oui' else 'Non' end as \"".__("am_lot_cstr_cos")."\"", "case donnees_techniques.am_lot_cstr_plan when 't' then 'Oui' else 'Non' end as \"".__("am_lot_cstr_plan")."\"", "case donnees_techniques.am_lot_cstr_vente when 't' then 'Oui' else 'Non' end as \"".__("am_lot_cstr_vente")."\"", "case donnees_techniques.am_lot_fin_diff when 't' then 'Oui' else 'Non' end as \"".__("am_lot_fin_diff")."\"", "case donnees_techniques.am_lot_consign when 't' then 'Oui' else 'Non' end as \"".__("am_lot_consign")."\"", "case donnees_techniques.am_lot_gar_achev when 't' then 'Oui' else 'Non' end as \"".__("am_lot_gar_achev")."\"", "case donnees_techniques.am_lot_vente_ant when 't' then 'Oui' else 'Non' end as \"".__("am_lot_vente_ant")."\"", 'donnees_techniques.am_empl_nb as "'.__("am_empl_nb").'"', 'donnees_techniques.am_tente_nb as "'.__("am_tente_nb").'"', 'donnees_techniques.am_carav_nb as "'.__("am_carav_nb").'"', 'donnees_techniques.am_mobil_nb as "'.__("am_mobil_nb").'"', 'donnees_techniques.am_pers_nb as "'.__("am_pers_nb").'"', 'donnees_techniques.am_empl_hll_nb as "'.__("am_empl_hll_nb").'"', 'donnees_techniques.am_hll_shon as "'.__("am_hll_shon").'"', "case donnees_techniques.am_exist_agrand when 't' then 'Oui' else 'Non' end as \"".__("am_exist_agrand")."\"", 'donnees_techniques.am_exist_date as "'.__("am_exist_date").'"', 'donnees_techniques.am_exist_num as "'.__("am_exist_num").'"', 'donnees_techniques.am_exist_nb_avant as "'.__("am_exist_nb_avant").'"', 'donnees_techniques.am_exist_nb_apres as "'.__("am_exist_nb_apres").'"', "case donnees_techniques.am_coupe_bois when 't' then 'Oui' else 'Non' end as \"".__("am_coupe_bois")."\"", "case donnees_techniques.am_coupe_parc when 't' then 'Oui' else 'Non' end as \"".__("am_coupe_parc")."\"", "case donnees_techniques.am_coupe_align when 't' then 'Oui' else 'Non' end as \"".__("am_coupe_align")."\"", 'donnees_techniques.am_coupe_ess as "'.__("am_coupe_ess").'"', 'donnees_techniques.am_coupe_age as "'.__("am_coupe_age").'"', 'donnees_techniques.am_coupe_dens as "'.__("am_coupe_dens").'"', 'donnees_techniques.am_coupe_qual as "'.__("am_coupe_qual").'"', 'donnees_techniques.am_coupe_trait as "'.__("am_coupe_trait").'"', 'donnees_techniques.am_coupe_autr as "'.__("am_coupe_autr").'"', "case donnees_techniques.co_archi_recours when 't' then 'Oui' else 'Non' end as \"".__("co_archi_recours")."\"", "case donnees_techniques.co_cstr_nouv when 't' then 'Oui' else 'Non' end as \"".__("co_cstr_nouv")."\"", "case donnees_techniques.co_cstr_exist when 't' then 'Oui' else 'Non' end as \"".__("co_cstr_exist")."\"", "case donnees_techniques.co_cloture when 't' then 'Oui' else 'Non' end as \"".__("co_cloture")."\"", 'donnees_techniques.co_elec_tension as "'.__("co_elec_tension").'"', "case donnees_techniques.co_div_terr when 't' then 'Oui' else 'Non' end as \"".__("co_div_terr")."\"", "case donnees_techniques.co_anx_pisc when 't' then 'Oui' else 'Non' end as \"".__("co_anx_pisc")."\"", "case donnees_techniques.co_anx_gara when 't' then 'Oui' else 'Non' end as \"".__("co_anx_gara")."\"", "case donnees_techniques.co_anx_veran when 't' then 'Oui' else 'Non' end as \"".__("co_anx_veran")."\"", "case donnees_techniques.co_anx_abri when 't' then 'Oui' else 'Non' end as \"".__("co_anx_abri")."\"", "case donnees_techniques.co_anx_autr when 't' then 'Oui' else 'Non' end as \"".__("co_anx_autr")."\"", 'donnees_techniques.co_tot_log_nb as "'.__("co_tot_log_nb").'"', 'donnees_techniques.co_tot_ind_nb as "'.__("co_tot_ind_nb").'"', 'donnees_techniques.co_tot_coll_nb as "'.__("co_tot_coll_nb").'"', 'donnees_techniques.co_mais_piece_nb as "'.__("co_mais_piece_nb").'"', 'donnees_techniques.co_mais_niv_nb as "'.__("co_mais_niv_nb").'"', 'donnees_techniques.co_fin_lls_nb as "'.__("co_fin_lls_nb").'"', 'donnees_techniques.co_fin_aa_nb as "'.__("co_fin_aa_nb").'"', 'donnees_techniques.co_fin_ptz_nb as "'.__("co_fin_ptz_nb").'"', 'donnees_techniques.co_fin_autr_nb as "'.__("co_fin_autr_nb").'"', "case donnees_techniques.co_mais_contrat_ind when 't' then 'Oui' else 'Non' end as \"".__("co_mais_contrat_ind")."\"", "case donnees_techniques.co_uti_pers when 't' then 'Oui' else 'Non' end as \"".__("co_uti_pers")."\"", "case donnees_techniques.co_uti_vente when 't' then 'Oui' else 'Non' end as \"".__("co_uti_vente")."\"", "case donnees_techniques.co_uti_loc when 't' then 'Oui' else 'Non' end as \"".__("co_uti_loc")."\"", "case donnees_techniques.co_uti_princ when 't' then 'Oui' else 'Non' end as \"".__("co_uti_princ")."\"", "case donnees_techniques.co_uti_secon when 't' then 'Oui' else 'Non' end as \"".__("co_uti_secon")."\"", "case donnees_techniques.co_resid_agees when 't' then 'Oui' else 'Non' end as \"".__("co_resid_agees")."\"", "case donnees_techniques.co_resid_etud when 't' then 'Oui' else 'Non' end as \"".__("co_resid_etud")."\"", "case donnees_techniques.co_resid_tourism when 't' then 'Oui' else 'Non' end as \"".__("co_resid_tourism")."\"", "case donnees_techniques.co_resid_hot_soc when 't' then 'Oui' else 'Non' end as \"".__("co_resid_hot_soc")."\"", "case donnees_techniques.co_resid_soc when 't' then 'Oui' else 'Non' end as \"".__("co_resid_soc")."\"", "case donnees_techniques.co_resid_hand when 't' then 'Oui' else 'Non' end as \"".__("co_resid_hand")."\"", "case donnees_techniques.co_resid_autr when 't' then 'Oui' else 'Non' end as \"".__("co_resid_autr")."\"", 'donnees_techniques.co_foyer_chamb_nb as "'.__("co_foyer_chamb_nb").'"', 'donnees_techniques.co_log_1p_nb as "'.__("co_log_1p_nb").'"', 'donnees_techniques.co_log_2p_nb as "'.__("co_log_2p_nb").'"', 'donnees_techniques.co_log_3p_nb as "'.__("co_log_3p_nb").'"', 'donnees_techniques.co_log_4p_nb as "'.__("co_log_4p_nb").'"', 'donnees_techniques.co_log_5p_nb as "'.__("co_log_5p_nb").'"', 'donnees_techniques.co_log_6p_nb as "'.__("co_log_6p_nb").'"', 'donnees_techniques.co_bat_niv_nb as "'.__("co_bat_niv_nb").'"', "case donnees_techniques.co_trx_exten when 't' then 'Oui' else 'Non' end as \"".__("co_trx_exten")."\"", "case donnees_techniques.co_trx_surelev when 't' then 'Oui' else 'Non' end as \"".__("co_trx_surelev")."\"", "case donnees_techniques.co_trx_nivsup when 't' then 'Oui' else 'Non' end as \"".__("co_trx_nivsup")."\"", "case donnees_techniques.co_sp_transport when 't' then 'Oui' else 'Non' end as \"".__("co_sp_transport")."\"", "case donnees_techniques.co_sp_enseign when 't' then 'Oui' else 'Non' end as \"".__("co_sp_enseign")."\"", "case donnees_techniques.co_sp_act_soc when 't' then 'Oui' else 'Non' end as \"".__("co_sp_act_soc")."\"", "case donnees_techniques.co_sp_ouvr_spe when 't' then 'Oui' else 'Non' end as \"".__("co_sp_ouvr_spe")."\"", "case donnees_techniques.co_sp_sante when 't' then 'Oui' else 'Non' end as \"".__("co_sp_sante")."\"", "case donnees_techniques.co_sp_culture when 't' then 'Oui' else 'Non' end as \"".__("co_sp_culture")."\"", 'donnees_techniques.co_statio_avt_nb as "'.__("co_statio_avt_nb").'"', 'donnees_techniques.co_statio_apr_nb as "'.__("co_statio_apr_nb").'"', 'donnees_techniques.co_statio_place_nb as "'.__("co_statio_place_nb").'"', 'donnees_techniques.co_statio_tot_surf as "'.__("co_statio_tot_surf").'"', 'donnees_techniques.co_statio_tot_shob as "'.__("co_statio_tot_shob").'"', 'donnees_techniques.co_statio_comm_cin_surf as "'.__("co_statio_comm_cin_surf").'"', 'donnees_techniques.su_avt_shon1 as "'.__("su_avt_shon1").'"', 'donnees_techniques.su_avt_shon2 as "'.__("su_avt_shon2").'"', 'donnees_techniques.su_avt_shon3 as "'.__("su_avt_shon3").'"', 'donnees_techniques.su_avt_shon4 as "'.__("su_avt_shon4").'"', 'donnees_techniques.su_avt_shon5 as "'.__("su_avt_shon5").'"', 'donnees_techniques.su_avt_shon6 as "'.__("su_avt_shon6").'"', 'donnees_techniques.su_avt_shon7 as "'.__("su_avt_shon7").'"', 'donnees_techniques.su_avt_shon8 as "'.__("su_avt_shon8").'"', 'donnees_techniques.su_avt_shon9 as "'.__("su_avt_shon9").'"', 'donnees_techniques.su_cstr_shon1 as "'.__("su_cstr_shon1").'"', 'donnees_techniques.su_cstr_shon2 as "'.__("su_cstr_shon2").'"', 'donnees_techniques.su_cstr_shon3 as "'.__("su_cstr_shon3").'"', 'donnees_techniques.su_cstr_shon4 as "'.__("su_cstr_shon4").'"', 'donnees_techniques.su_cstr_shon5 as "'.__("su_cstr_shon5").'"', 'donnees_techniques.su_cstr_shon6 as "'.__("su_cstr_shon6").'"', 'donnees_techniques.su_cstr_shon7 as "'.__("su_cstr_shon7").'"', 'donnees_techniques.su_cstr_shon8 as "'.__("su_cstr_shon8").'"', 'donnees_techniques.su_cstr_shon9 as "'.__("su_cstr_shon9").'"', 'donnees_techniques.su_trsf_shon1 as "'.__("su_trsf_shon1").'"', 'donnees_techniques.su_trsf_shon2 as "'.__("su_trsf_shon2").'"', 'donnees_techniques.su_trsf_shon3 as "'.__("su_trsf_shon3").'"', 'donnees_techniques.su_trsf_shon4 as "'.__("su_trsf_shon4").'"', 'donnees_techniques.su_trsf_shon5 as "'.__("su_trsf_shon5").'"', 'donnees_techniques.su_trsf_shon6 as "'.__("su_trsf_shon6").'"', 'donnees_techniques.su_trsf_shon7 as "'.__("su_trsf_shon7").'"', 'donnees_techniques.su_trsf_shon8 as "'.__("su_trsf_shon8").'"', 'donnees_techniques.su_trsf_shon9 as "'.__("su_trsf_shon9").'"', 'donnees_techniques.su_chge_shon1 as "'.__("su_chge_shon1").'"', 'donnees_techniques.su_chge_shon2 as "'.__("su_chge_shon2").'"', 'donnees_techniques.su_chge_shon3 as "'.__("su_chge_shon3").'"', 'donnees_techniques.su_chge_shon4 as "'.__("su_chge_shon4").'"', 'donnees_techniques.su_chge_shon5 as "'.__("su_chge_shon5").'"', 'donnees_techniques.su_chge_shon6 as "'.__("su_chge_shon6").'"', 'donnees_techniques.su_chge_shon7 as "'.__("su_chge_shon7").'"', 'donnees_techniques.su_chge_shon8 as "'.__("su_chge_shon8").'"', 'donnees_techniques.su_chge_shon9 as "'.__("su_chge_shon9").'"', 'donnees_techniques.su_demo_shon1 as "'.__("su_demo_shon1").'"', 'donnees_techniques.su_demo_shon2 as "'.__("su_demo_shon2").'"', 'donnees_techniques.su_demo_shon3 as "'.__("su_demo_shon3").'"', 'donnees_techniques.su_demo_shon4 as "'.__("su_demo_shon4").'"', 'donnees_techniques.su_demo_shon5 as "'.__("su_demo_shon5").'"', 'donnees_techniques.su_demo_shon6 as "'.__("su_demo_shon6").'"', 'donnees_techniques.su_demo_shon7 as "'.__("su_demo_shon7").'"', 'donnees_techniques.su_demo_shon8 as "'.__("su_demo_shon8").'"', 'donnees_techniques.su_demo_shon9 as "'.__("su_demo_shon9").'"', 'donnees_techniques.su_sup_shon1 as "'.__("su_sup_shon1").'"', 'donnees_techniques.su_sup_shon2 as "'.__("su_sup_shon2").'"', 'donnees_techniques.su_sup_shon3 as "'.__("su_sup_shon3").'"', 'donnees_techniques.su_sup_shon4 as "'.__("su_sup_shon4").'"', 'donnees_techniques.su_sup_shon5 as "'.__("su_sup_shon5").'"', 'donnees_techniques.su_sup_shon6 as "'.__("su_sup_shon6").'"', 'donnees_techniques.su_sup_shon7 as "'.__("su_sup_shon7").'"', 'donnees_techniques.su_sup_shon8 as "'.__("su_sup_shon8").'"', 'donnees_techniques.su_sup_shon9 as "'.__("su_sup_shon9").'"', 'donnees_techniques.su_tot_shon1 as "'.__("su_tot_shon1").'"', 'donnees_techniques.su_tot_shon2 as "'.__("su_tot_shon2").'"', 'donnees_techniques.su_tot_shon3 as "'.__("su_tot_shon3").'"', 'donnees_techniques.su_tot_shon4 as "'.__("su_tot_shon4").'"', 'donnees_techniques.su_tot_shon5 as "'.__("su_tot_shon5").'"', 'donnees_techniques.su_tot_shon6 as "'.__("su_tot_shon6").'"', 'donnees_techniques.su_tot_shon7 as "'.__("su_tot_shon7").'"', 'donnees_techniques.su_tot_shon8 as "'.__("su_tot_shon8").'"', 'donnees_techniques.su_tot_shon9 as "'.__("su_tot_shon9").'"', 'donnees_techniques.su_avt_shon_tot as "'.__("su_avt_shon_tot").'"', 'donnees_techniques.su_cstr_shon_tot as "'.__("su_cstr_shon_tot").'"', 'donnees_techniques.su_trsf_shon_tot as "'.__("su_trsf_shon_tot").'"', 'donnees_techniques.su_chge_shon_tot as "'.__("su_chge_shon_tot").'"', 'donnees_techniques.su_demo_shon_tot as "'.__("su_demo_shon_tot").'"', 'donnees_techniques.su_sup_shon_tot as "'.__("su_sup_shon_tot").'"', 'donnees_techniques.su_tot_shon_tot as "'.__("su_tot_shon_tot").'"', "case donnees_techniques.dm_total when 't' then 'Oui' else 'Non' end as \"".__("dm_total")."\"", "case donnees_techniques.dm_partiel when 't' then 'Oui' else 'Non' end as \"".__("dm_partiel")."\"", 'donnees_techniques.dm_tot_log_nb as "'.__("dm_tot_log_nb").'"', 'donnees_techniques.tax_surf_tot as "'.__("tax_surf_tot").'"', 'donnees_techniques.tax_surf as "'.__("tax_surf").'"', 'donnees_techniques.tax_surf_suppr_mod as "'.__("tax_surf_suppr_mod").'"', 'donnees_techniques.tax_su_princ_log_nb1 as "'.__("tax_su_princ_log_nb1").'"', 'donnees_techniques.tax_su_princ_log_nb2 as "'.__("tax_su_princ_log_nb2").'"', 'donnees_techniques.tax_su_princ_log_nb3 as "'.__("tax_su_princ_log_nb3").'"', 'donnees_techniques.tax_su_princ_log_nb4 as "'.__("tax_su_princ_log_nb4").'"', 'donnees_techniques.tax_su_princ_log_nb_tot1 as "'.__("tax_su_princ_log_nb_tot1").'"', 'donnees_techniques.tax_su_princ_log_nb_tot2 as "'.__("tax_su_princ_log_nb_tot2").'"', 'donnees_techniques.tax_su_princ_log_nb_tot3 as "'.__("tax_su_princ_log_nb_tot3").'"', 'donnees_techniques.tax_su_princ_log_nb_tot4 as "'.__("tax_su_princ_log_nb_tot4").'"', 'donnees_techniques.tax_su_princ_surf1 as "'.__("tax_su_princ_surf1").'"', 'donnees_techniques.tax_su_princ_surf2 as "'.__("tax_su_princ_surf2").'"', 'donnees_techniques.tax_su_princ_surf3 as "'.__("tax_su_princ_surf3").'"', 'donnees_techniques.tax_su_princ_surf4 as "'.__("tax_su_princ_surf4").'"', 'donnees_techniques.tax_su_princ_surf_sup1 as "'.__("tax_su_princ_surf_sup1").'"', 'donnees_techniques.tax_su_princ_surf_sup2 as "'.__("tax_su_princ_surf_sup2").'"', 'donnees_techniques.tax_su_princ_surf_sup3 as "'.__("tax_su_princ_surf_sup3").'"', 'donnees_techniques.tax_su_princ_surf_sup4 as "'.__("tax_su_princ_surf_sup4").'"', 'donnees_techniques.tax_su_heber_log_nb1 as "'.__("tax_su_heber_log_nb1").'"', 'donnees_techniques.tax_su_heber_log_nb2 as "'.__("tax_su_heber_log_nb2").'"', 'donnees_techniques.tax_su_heber_log_nb3 as "'.__("tax_su_heber_log_nb3").'"', 'donnees_techniques.tax_su_heber_log_nb_tot1 as "'.__("tax_su_heber_log_nb_tot1").'"', 'donnees_techniques.tax_su_heber_log_nb_tot2 as "'.__("tax_su_heber_log_nb_tot2").'"', 'donnees_techniques.tax_su_heber_log_nb_tot3 as "'.__("tax_su_heber_log_nb_tot3").'"', 'donnees_techniques.tax_su_heber_surf1 as "'.__("tax_su_heber_surf1").'"', 'donnees_techniques.tax_su_heber_surf2 as "'.__("tax_su_heber_surf2").'"', 'donnees_techniques.tax_su_heber_surf3 as "'.__("tax_su_heber_surf3").'"', 'donnees_techniques.tax_su_heber_surf_sup1 as "'.__("tax_su_heber_surf_sup1").'"', 'donnees_techniques.tax_su_heber_surf_sup2 as "'.__("tax_su_heber_surf_sup2").'"', 'donnees_techniques.tax_su_heber_surf_sup3 as "'.__("tax_su_heber_surf_sup3").'"', 'donnees_techniques.tax_su_secon_log_nb as "'.__("tax_su_secon_log_nb").'"', 'donnees_techniques.tax_su_tot_log_nb as "'.__("tax_su_tot_log_nb").'"', 'donnees_techniques.tax_su_secon_log_nb_tot as "'.__("tax_su_secon_log_nb_tot").'"', 'donnees_techniques.tax_su_tot_log_nb_tot as "'.__("tax_su_tot_log_nb_tot").'"', 'donnees_techniques.tax_su_secon_surf as "'.__("tax_su_secon_surf").'"', 'donnees_techniques.tax_su_tot_surf as "'.__("tax_su_tot_surf").'"', 'donnees_techniques.tax_su_secon_surf_sup as "'.__("tax_su_secon_surf_sup").'"', 'donnees_techniques.tax_su_tot_surf_sup as "'.__("tax_su_tot_surf_sup").'"', "case donnees_techniques.tax_ext_pret when 't' then 'Oui' else 'Non' end as \"".__("tax_ext_pret")."\"", 'donnees_techniques.tax_surf_tax_exist_cons as "'.__("tax_surf_tax_exist_cons").'"', 'donnees_techniques.tax_log_exist_nb as "'.__("tax_log_exist_nb").'"', 'donnees_techniques.tax_am_statio_ext as "'.__("tax_am_statio_ext").'"', 'donnees_techniques.tax_sup_bass_pisc as "'.__("tax_sup_bass_pisc").'"', 'donnees_techniques.tax_empl_ten_carav_mobil_nb as "'.__("tax_empl_ten_carav_mobil_nb").'"', 'donnees_techniques.tax_empl_hll_nb as "'.__("tax_empl_hll_nb").'"', 'donnees_techniques.tax_eol_haut_nb as "'.__("tax_eol_haut_nb").'"', 'donnees_techniques.tax_pann_volt_sup as "'.__("tax_pann_volt_sup").'"', 'donnees_techniques.tax_am_statio_ext_sup as "'.__("tax_am_statio_ext_sup").'"', 'donnees_techniques.tax_sup_bass_pisc_sup as "'.__("tax_sup_bass_pisc_sup").'"', 'donnees_techniques.tax_empl_ten_carav_mobil_nb_sup as "'.__("tax_empl_ten_carav_mobil_nb_sup").'"', 'donnees_techniques.tax_empl_hll_nb_sup as "'.__("tax_empl_hll_nb_sup").'"', 'donnees_techniques.tax_eol_haut_nb_sup as "'.__("tax_eol_haut_nb_sup").'"', 'donnees_techniques.tax_pann_volt_sup_sup as "'.__("tax_pann_volt_sup_sup").'"', "case donnees_techniques.tax_trx_presc_ppr when 't' then 'Oui' else 'Non' end as \"".__("tax_trx_presc_ppr")."\"", "case donnees_techniques.tax_monu_hist when 't' then 'Oui' else 'Non' end as \"".__("tax_monu_hist")."\"", 'donnees_techniques.tax_comm_nb as "'.__("tax_comm_nb").'"', 'donnees_techniques.tax_su_non_habit_surf1 as "'.__("tax_su_non_habit_surf1").'"', 'donnees_techniques.tax_su_non_habit_surf2 as "'.__("tax_su_non_habit_surf2").'"', 'donnees_techniques.tax_su_non_habit_surf3 as "'.__("tax_su_non_habit_surf3").'"', 'donnees_techniques.tax_su_non_habit_surf4 as "'.__("tax_su_non_habit_surf4").'"', 'donnees_techniques.tax_su_non_habit_surf5 as "'.__("tax_su_non_habit_surf5").'"', 'donnees_techniques.tax_su_non_habit_surf6 as "'.__("tax_su_non_habit_surf6").'"', 'donnees_techniques.tax_su_non_habit_surf7 as "'.__("tax_su_non_habit_surf7").'"', 'donnees_techniques.tax_su_non_habit_surf_sup1 as "'.__("tax_su_non_habit_surf_sup1").'"', 'donnees_techniques.tax_su_non_habit_surf_sup2 as "'.__("tax_su_non_habit_surf_sup2").'"', 'donnees_techniques.tax_su_non_habit_surf_sup3 as "'.__("tax_su_non_habit_surf_sup3").'"', 'donnees_techniques.tax_su_non_habit_surf_sup4 as "'.__("tax_su_non_habit_surf_sup4").'"', 'donnees_techniques.tax_su_non_habit_surf_sup5 as "'.__("tax_su_non_habit_surf_sup5").'"', 'donnees_techniques.tax_su_non_habit_surf_sup6 as "'.__("tax_su_non_habit_surf_sup6").'"', 'donnees_techniques.tax_su_non_habit_surf_sup7 as "'.__("tax_su_non_habit_surf_sup7").'"', "case donnees_techniques.vsd_surf_planch_smd when 't' then 'Oui' else 'Non' end as \"".__("vsd_surf_planch_smd")."\"", 'donnees_techniques.vsd_unit_fonc_sup as "'.__("vsd_unit_fonc_sup").'"', 'donnees_techniques.vsd_unit_fonc_constr_sup as "'.__("vsd_unit_fonc_constr_sup").'"', 'donnees_techniques.vsd_val_terr as "'.__("vsd_val_terr").'"', 'donnees_techniques.vsd_const_sxist_non_dem_surf as "'.__("vsd_const_sxist_non_dem_surf").'"', 'to_char(donnees_techniques.vsd_rescr_fisc ,\'DD/MM/YYYY\') as "'.__("vsd_rescr_fisc").'"', 'donnees_techniques.pld_val_terr as "'.__("pld_val_terr").'"', "case donnees_techniques.pld_const_exist_dem when 't' then 'Oui' else 'Non' end as \"".__("pld_const_exist_dem")."\"", 'donnees_techniques.pld_const_exist_dem_surf as "'.__("pld_const_exist_dem_surf").'"', "case donnees_techniques.code_cnil when 't' then 'Oui' else 'Non' end as \"".__("code_cnil")."\"", 'donnees_techniques.terr_juri_titul as "'.__("terr_juri_titul").'"', 'donnees_techniques.terr_juri_lot as "'.__("terr_juri_lot").'"', 'donnees_techniques.terr_juri_zac as "'.__("terr_juri_zac").'"', 'donnees_techniques.terr_juri_afu as "'.__("terr_juri_afu").'"', 'donnees_techniques.terr_juri_pup as "'.__("terr_juri_pup").'"', 'donnees_techniques.terr_juri_oin as "'.__("terr_juri_oin").'"', 'donnees_techniques.terr_div_surf_etab as "'.__("terr_div_surf_etab").'"', 'donnees_techniques.terr_div_surf_av_div as "'.__("terr_div_surf_av_div").'"', 'to_char(donnees_techniques.doc_date ,\'DD/MM/YYYY\') as "'.__("doc_date").'"', "case donnees_techniques.doc_tot_trav when 't' then 'Oui' else 'Non' end as \"".__("doc_tot_trav")."\"", "case donnees_techniques.doc_tranche_trav when 't' then 'Oui' else 'Non' end as \"".__("doc_tranche_trav")."\"", 'donnees_techniques.doc_surf as "'.__("doc_surf").'"', 'donnees_techniques.doc_nb_log as "'.__("doc_nb_log").'"', 'donnees_techniques.doc_nb_log_indiv as "'.__("doc_nb_log_indiv").'"', 'donnees_techniques.doc_nb_log_coll as "'.__("doc_nb_log_coll").'"', 'donnees_techniques.doc_nb_log_lls as "'.__("doc_nb_log_lls").'"', 'donnees_techniques.doc_nb_log_aa as "'.__("doc_nb_log_aa").'"', 'donnees_techniques.doc_nb_log_ptz as "'.__("doc_nb_log_ptz").'"', 'donnees_techniques.doc_nb_log_autre as "'.__("doc_nb_log_autre").'"', 'to_char(donnees_techniques.daact_date ,\'DD/MM/YYYY\') as "'.__("daact_date").'"', 'to_char(donnees_techniques.daact_date_chgmt_dest ,\'DD/MM/YYYY\') as "'.__("daact_date_chgmt_dest").'"', "case donnees_techniques.daact_tot_trav when 't' then 'Oui' else 'Non' end as \"".__("daact_tot_trav")."\"", "case donnees_techniques.daact_tranche_trav when 't' then 'Oui' else 'Non' end as \"".__("daact_tranche_trav")."\"", 'donnees_techniques.daact_surf as "'.__("daact_surf").'"', 'donnees_techniques.daact_nb_log as "'.__("daact_nb_log").'"', 'donnees_techniques.daact_nb_log_indiv as "'.__("daact_nb_log_indiv").'"', 'donnees_techniques.daact_nb_log_coll as "'.__("daact_nb_log_coll").'"', 'donnees_techniques.daact_nb_log_lls as "'.__("daact_nb_log_lls").'"', 'donnees_techniques.daact_nb_log_aa as "'.__("daact_nb_log_aa").'"', 'donnees_techniques.daact_nb_log_ptz as "'.__("daact_nb_log_ptz").'"', 'donnees_techniques.daact_nb_log_autre as "'.__("daact_nb_log_autre").'"', 'dossier_autorisation.dossier_autorisation_type_detaille as "'.__("dossier_autorisation").'"', "case donnees_techniques.am_div_mun when 't' then 'Oui' else 'Non' end as \"".__("am_div_mun")."\"", 'donnees_techniques.co_perf_energ as "'.__("co_perf_energ").'"', 'architecte.nom as "'.__("architecte").'"', 'donnees_techniques.co_statio_avt_shob as "'.__("co_statio_avt_shob").'"', 'donnees_techniques.co_statio_apr_shob as "'.__("co_statio_apr_shob").'"', 'donnees_techniques.co_statio_avt_surf as "'.__("co_statio_avt_surf").'"', 'donnees_techniques.co_statio_apr_surf as "'.__("co_statio_apr_surf").'"', 'donnees_techniques.co_trx_amgt as "'.__("co_trx_amgt").'"', 'donnees_techniques.co_modif_aspect as "'.__("co_modif_aspect").'"', 'donnees_techniques.co_modif_struct as "'.__("co_modif_struct").'"', "case donnees_techniques.co_ouvr_elec when 't' then 'Oui' else 'Non' end as \"".__("co_ouvr_elec")."\"", "case donnees_techniques.co_ouvr_infra when 't' then 'Oui' else 'Non' end as \"".__("co_ouvr_infra")."\"", 'donnees_techniques.co_trx_imm as "'.__("co_trx_imm").'"', 'donnees_techniques.co_cstr_shob as "'.__("co_cstr_shob").'"', 'donnees_techniques.am_voyage_deb as "'.__("am_voyage_deb").'"', 'donnees_techniques.am_voyage_fin as "'.__("am_voyage_fin").'"', 'donnees_techniques.am_modif_amgt as "'.__("am_modif_amgt").'"', 'donnees_techniques.am_lot_max_shob as "'.__("am_lot_max_shob").'"', 'donnees_techniques.mod_desc as "'.__("mod_desc").'"', 'donnees_techniques.tr_total as "'.__("tr_total").'"', 'donnees_techniques.tr_partiel as "'.__("tr_partiel").'"', 'donnees_techniques.tr_desc as "'.__("tr_desc").'"', "case donnees_techniques.avap_co_elt_pro when 't' then 'Oui' else 'Non' end as \"".__("avap_co_elt_pro")."\"", "case donnees_techniques.avap_nouv_haut_surf when 't' then 'Oui' else 'Non' end as \"".__("avap_nouv_haut_surf")."\"", 'donnees_techniques.avap_co_clot as "'.__("avap_co_clot").'"', 'donnees_techniques.avap_aut_coup_aba_arb as "'.__("avap_aut_coup_aba_arb").'"', 'donnees_techniques.avap_ouv_infra as "'.__("avap_ouv_infra").'"', 'donnees_techniques.avap_aut_inst_mob as "'.__("avap_aut_inst_mob").'"', 'donnees_techniques.avap_aut_plant as "'.__("avap_aut_plant").'"', 'donnees_techniques.avap_aut_auv_elec as "'.__("avap_aut_auv_elec").'"', 'donnees_techniques.tax_dest_loc_tr as "'.__("tax_dest_loc_tr").'"', 'donnees_techniques.tax_surf_tot_cstr as "'.__("tax_surf_tot_cstr").'"', 'donnees_techniques.cerfa as "'.__("cerfa").'"', 'donnees_techniques.tax_surf_loc_stat as "'.__("tax_surf_loc_stat").'"', 'donnees_techniques.tax_su_princ_surf_stat1 as "'.__("tax_su_princ_surf_stat1").'"', 'donnees_techniques.tax_su_princ_surf_stat2 as "'.__("tax_su_princ_surf_stat2").'"', 'donnees_techniques.tax_su_princ_surf_stat3 as "'.__("tax_su_princ_surf_stat3").'"', 'donnees_techniques.tax_su_princ_surf_stat4 as "'.__("tax_su_princ_surf_stat4").'"', 'donnees_techniques.tax_su_secon_surf_stat as "'.__("tax_su_secon_surf_stat").'"', 'donnees_techniques.tax_su_heber_surf_stat1 as "'.__("tax_su_heber_surf_stat1").'"', 'donnees_techniques.tax_su_heber_surf_stat2 as "'.__("tax_su_heber_surf_stat2").'"', 'donnees_techniques.tax_su_heber_surf_stat3 as "'.__("tax_su_heber_surf_stat3").'"', 'donnees_techniques.tax_su_tot_surf_stat as "'.__("tax_su_tot_surf_stat").'"', 'donnees_techniques.tax_su_non_habit_surf_stat1 as "'.__("tax_su_non_habit_surf_stat1").'"', 'donnees_techniques.tax_su_non_habit_surf_stat2 as "'.__("tax_su_non_habit_surf_stat2").'"', 'donnees_techniques.tax_su_non_habit_surf_stat3 as "'.__("tax_su_non_habit_surf_stat3").'"', 'donnees_techniques.tax_su_non_habit_surf_stat4 as "'.__("tax_su_non_habit_surf_stat4").'"', 'donnees_techniques.tax_su_non_habit_surf_stat5 as "'.__("tax_su_non_habit_surf_stat5").'"', 'donnees_techniques.tax_su_non_habit_surf_stat6 as "'.__("tax_su_non_habit_surf_stat6").'"', 'donnees_techniques.tax_su_non_habit_surf_stat7 as "'.__("tax_su_non_habit_surf_stat7").'"', 'donnees_techniques.tax_su_parc_statio_expl_comm_surf as "'.__("tax_su_parc_statio_expl_comm_surf").'"', 'donnees_techniques.tax_log_ap_trvx_nb as "'.__("tax_log_ap_trvx_nb").'"', 'donnees_techniques.tax_am_statio_ext_cr as "'.__("tax_am_statio_ext_cr").'"', 'donnees_techniques.tax_sup_bass_pisc_cr as "'.__("tax_sup_bass_pisc_cr").'"', 'donnees_techniques.tax_empl_ten_carav_mobil_nb_cr as "'.__("tax_empl_ten_carav_mobil_nb_cr").'"', 'donnees_techniques.tax_empl_hll_nb_cr as "'.__("tax_empl_hll_nb_cr").'"', 'donnees_techniques.tax_eol_haut_nb_cr as "'.__("tax_eol_haut_nb_cr").'"', 'donnees_techniques.tax_pann_volt_sup_cr as "'.__("tax_pann_volt_sup_cr").'"', 'donnees_techniques.tax_surf_loc_arch as "'.__("tax_surf_loc_arch").'"', 'donnees_techniques.tax_surf_pisc_arch as "'.__("tax_surf_pisc_arch").'"', 'donnees_techniques.tax_am_statio_ext_arch as "'.__("tax_am_statio_ext_arch").'"', 'donnees_techniques.tax_empl_ten_carav_mobil_nb_arch as "'.__("tax_empl_ten_carav_mobil_nb_arch").'"', 'donnees_techniques.tax_empl_hll_nb_arch as "'.__("tax_empl_hll_nb_arch").'"', 'donnees_techniques.tax_eol_haut_nb_arch as "'.__("tax_eol_haut_nb_arch").'"', "case donnees_techniques.ope_proj_div_co when 't' then 'Oui' else 'Non' end as \"".__("ope_proj_div_co")."\"", "case donnees_techniques.ope_proj_div_contr when 't' then 'Oui' else 'Non' end as \"".__("ope_proj_div_contr")."\"", "case donnees_techniques.erp_cstr_neuve when 't' then 'Oui' else 'Non' end as \"".__("erp_cstr_neuve")."\"", "case donnees_techniques.erp_trvx_acc when 't' then 'Oui' else 'Non' end as \"".__("erp_trvx_acc")."\"", "case donnees_techniques.erp_extension when 't' then 'Oui' else 'Non' end as \"".__("erp_extension")."\"", "case donnees_techniques.erp_rehab when 't' then 'Oui' else 'Non' end as \"".__("erp_rehab")."\"", "case donnees_techniques.erp_trvx_am when 't' then 'Oui' else 'Non' end as \"".__("erp_trvx_am")."\"", "case donnees_techniques.erp_vol_nouv_exist when 't' then 'Oui' else 'Non' end as \"".__("erp_vol_nouv_exist")."\"", 'donnees_techniques.erp_loc_eff1 as "'.__("erp_loc_eff1").'"', 'donnees_techniques.erp_loc_eff2 as "'.__("erp_loc_eff2").'"', 'donnees_techniques.erp_loc_eff3 as "'.__("erp_loc_eff3").'"', 'donnees_techniques.erp_loc_eff4 as "'.__("erp_loc_eff4").'"', 'donnees_techniques.erp_loc_eff5 as "'.__("erp_loc_eff5").'"', 'donnees_techniques.erp_loc_eff_tot as "'.__("erp_loc_eff_tot").'"', 'donnees_techniques.erp_public_eff1 as "'.__("erp_public_eff1").'"', 'donnees_techniques.erp_public_eff2 as "'.__("erp_public_eff2").'"', 'donnees_techniques.erp_public_eff3 as "'.__("erp_public_eff3").'"', 'donnees_techniques.erp_public_eff4 as "'.__("erp_public_eff4").'"', 'donnees_techniques.erp_public_eff5 as "'.__("erp_public_eff5").'"', 'donnees_techniques.erp_public_eff_tot as "'.__("erp_public_eff_tot").'"', 'donnees_techniques.erp_perso_eff1 as "'.__("erp_perso_eff1").'"', 'donnees_techniques.erp_perso_eff2 as "'.__("erp_perso_eff2").'"', 'donnees_techniques.erp_perso_eff3 as "'.__("erp_perso_eff3").'"', 'donnees_techniques.erp_perso_eff4 as "'.__("erp_perso_eff4").'"', 'donnees_techniques.erp_perso_eff5 as "'.__("erp_perso_eff5").'"', 'donnees_techniques.erp_perso_eff_tot as "'.__("erp_perso_eff_tot").'"', 'donnees_techniques.erp_tot_eff1 as "'.__("erp_tot_eff1").'"', 'donnees_techniques.erp_tot_eff2 as "'.__("erp_tot_eff2").'"', 'donnees_techniques.erp_tot_eff3 as "'.__("erp_tot_eff3").'"', 'donnees_techniques.erp_tot_eff4 as "'.__("erp_tot_eff4").'"', 'donnees_techniques.erp_tot_eff5 as "'.__("erp_tot_eff5").'"', 'donnees_techniques.erp_tot_eff_tot as "'.__("erp_tot_eff_tot").'"', 'donnees_techniques.erp_class_cat as "'.__("erp_class_cat").'"', 'donnees_techniques.erp_class_type as "'.__("erp_class_type").'"', 'donnees_techniques.tax_surf_abr_jard_pig_colom as "'.__("tax_surf_abr_jard_pig_colom").'"', 'donnees_techniques.tax_su_non_habit_abr_jard_pig_colom as "'.__("tax_su_non_habit_abr_jard_pig_colom").'"', "case donnees_techniques.dia_imm_non_bati when 't' then 'Oui' else 'Non' end as \"".__("dia_imm_non_bati")."\"", "case donnees_techniques.dia_imm_bati_terr_propr when 't' then 'Oui' else 'Non' end as \"".__("dia_imm_bati_terr_propr")."\"", "case donnees_techniques.dia_imm_bati_terr_autr when 't' then 'Oui' else 'Non' end as \"".__("dia_imm_bati_terr_autr")."\"", "case donnees_techniques.dia_bat_copro when 't' then 'Oui' else 'Non' end as \"".__("dia_bat_copro")."\"", "case donnees_techniques.dia_us_hab when 't' then 'Oui' else 'Non' end as \"".__("dia_us_hab")."\"", "case donnees_techniques.dia_us_pro when 't' then 'Oui' else 'Non' end as \"".__("dia_us_pro")."\"", "case donnees_techniques.dia_us_mixte when 't' then 'Oui' else 'Non' end as \"".__("dia_us_mixte")."\"", "case donnees_techniques.dia_us_comm when 't' then 'Oui' else 'Non' end as \"".__("dia_us_comm")."\"", "case donnees_techniques.dia_us_agr when 't' then 'Oui' else 'Non' end as \"".__("dia_us_agr")."\"", "case donnees_techniques.dia_us_autre when 't' then 'Oui' else 'Non' end as \"".__("dia_us_autre")."\"", "case donnees_techniques.dia_occ_prop when 't' then 'Oui' else 'Non' end as \"".__("dia_occ_prop")."\"", "case donnees_techniques.dia_occ_loc when 't' then 'Oui' else 'Non' end as \"".__("dia_occ_loc")."\"", "case donnees_techniques.dia_occ_sans_occ when 't' then 'Oui' else 'Non' end as \"".__("dia_occ_sans_occ")."\"", "case donnees_techniques.dia_occ_autre when 't' then 'Oui' else 'Non' end as \"".__("dia_occ_autre")."\"", 'donnees_techniques.dia_mod_cess_prix_vente as "'.__("dia_mod_cess_prix_vente").'"', 'donnees_techniques.dia_mod_cess_prix_vente_mob as "'.__("dia_mod_cess_prix_vente_mob").'"', 'donnees_techniques.dia_mod_cess_prix_vente_cheptel as "'.__("dia_mod_cess_prix_vente_cheptel").'"', 'donnees_techniques.dia_mod_cess_prix_vente_recol as "'.__("dia_mod_cess_prix_vente_recol").'"', 'donnees_techniques.dia_mod_cess_prix_vente_autre as "'.__("dia_mod_cess_prix_vente_autre").'"', "case donnees_techniques.dia_mod_cess_commi when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_commi")."\"", 'donnees_techniques.dia_mod_cess_commi_ttc as "'.__("dia_mod_cess_commi_ttc").'"', 'donnees_techniques.dia_mod_cess_commi_ht as "'.__("dia_mod_cess_commi_ht").'"', 'donnees_techniques.dia_acquereur_nom_prenom as "'.__("dia_acquereur_nom_prenom").'"', 'donnees_techniques.dia_acquereur_adr_num_voie as "'.__("dia_acquereur_adr_num_voie").'"', 'donnees_techniques.dia_acquereur_adr_ext as "'.__("dia_acquereur_adr_ext").'"', 'donnees_techniques.dia_acquereur_adr_type_voie as "'.__("dia_acquereur_adr_type_voie").'"', 'donnees_techniques.dia_acquereur_adr_nom_voie as "'.__("dia_acquereur_adr_nom_voie").'"', 'donnees_techniques.dia_acquereur_adr_lieu_dit_bp as "'.__("dia_acquereur_adr_lieu_dit_bp").'"', 'donnees_techniques.dia_acquereur_adr_cp as "'.__("dia_acquereur_adr_cp").'"', 'donnees_techniques.dia_acquereur_adr_localite as "'.__("dia_acquereur_adr_localite").'"', 'donnees_techniques.su2_avt_shon1 as "'.__("su2_avt_shon1").'"', 'donnees_techniques.su2_avt_shon2 as "'.__("su2_avt_shon2").'"', 'donnees_techniques.su2_avt_shon3 as "'.__("su2_avt_shon3").'"', 'donnees_techniques.su2_avt_shon4 as "'.__("su2_avt_shon4").'"', 'donnees_techniques.su2_avt_shon5 as "'.__("su2_avt_shon5").'"', 'donnees_techniques.su2_avt_shon6 as "'.__("su2_avt_shon6").'"', 'donnees_techniques.su2_avt_shon7 as "'.__("su2_avt_shon7").'"', 'donnees_techniques.su2_avt_shon8 as "'.__("su2_avt_shon8").'"', 'donnees_techniques.su2_avt_shon9 as "'.__("su2_avt_shon9").'"', 'donnees_techniques.su2_avt_shon10 as "'.__("su2_avt_shon10").'"', 'donnees_techniques.su2_avt_shon11 as "'.__("su2_avt_shon11").'"', 'donnees_techniques.su2_avt_shon12 as "'.__("su2_avt_shon12").'"', 'donnees_techniques.su2_avt_shon13 as "'.__("su2_avt_shon13").'"', 'donnees_techniques.su2_avt_shon14 as "'.__("su2_avt_shon14").'"', 'donnees_techniques.su2_avt_shon15 as "'.__("su2_avt_shon15").'"', 'donnees_techniques.su2_avt_shon16 as "'.__("su2_avt_shon16").'"', 'donnees_techniques.su2_avt_shon17 as "'.__("su2_avt_shon17").'"', 'donnees_techniques.su2_avt_shon18 as "'.__("su2_avt_shon18").'"', 'donnees_techniques.su2_avt_shon19 as "'.__("su2_avt_shon19").'"', 'donnees_techniques.su2_avt_shon20 as "'.__("su2_avt_shon20").'"', 'donnees_techniques.su2_avt_shon_tot as "'.__("su2_avt_shon_tot").'"', 'donnees_techniques.su2_cstr_shon1 as "'.__("su2_cstr_shon1").'"', 'donnees_techniques.su2_cstr_shon2 as "'.__("su2_cstr_shon2").'"', 'donnees_techniques.su2_cstr_shon3 as "'.__("su2_cstr_shon3").'"', 'donnees_techniques.su2_cstr_shon4 as "'.__("su2_cstr_shon4").'"', 'donnees_techniques.su2_cstr_shon5 as "'.__("su2_cstr_shon5").'"', 'donnees_techniques.su2_cstr_shon6 as "'.__("su2_cstr_shon6").'"', 'donnees_techniques.su2_cstr_shon7 as "'.__("su2_cstr_shon7").'"', 'donnees_techniques.su2_cstr_shon8 as "'.__("su2_cstr_shon8").'"', 'donnees_techniques.su2_cstr_shon9 as "'.__("su2_cstr_shon9").'"', 'donnees_techniques.su2_cstr_shon10 as "'.__("su2_cstr_shon10").'"', 'donnees_techniques.su2_cstr_shon11 as "'.__("su2_cstr_shon11").'"', 'donnees_techniques.su2_cstr_shon12 as "'.__("su2_cstr_shon12").'"', 'donnees_techniques.su2_cstr_shon13 as "'.__("su2_cstr_shon13").'"', 'donnees_techniques.su2_cstr_shon14 as "'.__("su2_cstr_shon14").'"', 'donnees_techniques.su2_cstr_shon15 as "'.__("su2_cstr_shon15").'"', 'donnees_techniques.su2_cstr_shon16 as "'.__("su2_cstr_shon16").'"', 'donnees_techniques.su2_cstr_shon17 as "'.__("su2_cstr_shon17").'"', 'donnees_techniques.su2_cstr_shon18 as "'.__("su2_cstr_shon18").'"', 'donnees_techniques.su2_cstr_shon19 as "'.__("su2_cstr_shon19").'"', 'donnees_techniques.su2_cstr_shon20 as "'.__("su2_cstr_shon20").'"', 'donnees_techniques.su2_cstr_shon_tot as "'.__("su2_cstr_shon_tot").'"', 'donnees_techniques.su2_chge_shon1 as "'.__("su2_chge_shon1").'"', 'donnees_techniques.su2_chge_shon2 as "'.__("su2_chge_shon2").'"', 'donnees_techniques.su2_chge_shon3 as "'.__("su2_chge_shon3").'"', 'donnees_techniques.su2_chge_shon4 as "'.__("su2_chge_shon4").'"', 'donnees_techniques.su2_chge_shon5 as "'.__("su2_chge_shon5").'"', 'donnees_techniques.su2_chge_shon6 as "'.__("su2_chge_shon6").'"', 'donnees_techniques.su2_chge_shon7 as "'.__("su2_chge_shon7").'"', 'donnees_techniques.su2_chge_shon8 as "'.__("su2_chge_shon8").'"', 'donnees_techniques.su2_chge_shon9 as "'.__("su2_chge_shon9").'"', 'donnees_techniques.su2_chge_shon10 as "'.__("su2_chge_shon10").'"', 'donnees_techniques.su2_chge_shon11 as "'.__("su2_chge_shon11").'"', 'donnees_techniques.su2_chge_shon12 as "'.__("su2_chge_shon12").'"', 'donnees_techniques.su2_chge_shon13 as "'.__("su2_chge_shon13").'"', 'donnees_techniques.su2_chge_shon14 as "'.__("su2_chge_shon14").'"', 'donnees_techniques.su2_chge_shon15 as "'.__("su2_chge_shon15").'"', 'donnees_techniques.su2_chge_shon16 as "'.__("su2_chge_shon16").'"', 'donnees_techniques.su2_chge_shon17 as "'.__("su2_chge_shon17").'"', 'donnees_techniques.su2_chge_shon18 as "'.__("su2_chge_shon18").'"', 'donnees_techniques.su2_chge_shon19 as "'.__("su2_chge_shon19").'"', 'donnees_techniques.su2_chge_shon20 as "'.__("su2_chge_shon20").'"', 'donnees_techniques.su2_chge_shon_tot as "'.__("su2_chge_shon_tot").'"', 'donnees_techniques.su2_demo_shon1 as "'.__("su2_demo_shon1").'"', 'donnees_techniques.su2_demo_shon2 as "'.__("su2_demo_shon2").'"', 'donnees_techniques.su2_demo_shon3 as "'.__("su2_demo_shon3").'"', 'donnees_techniques.su2_demo_shon4 as "'.__("su2_demo_shon4").'"', 'donnees_techniques.su2_demo_shon5 as "'.__("su2_demo_shon5").'"', 'donnees_techniques.su2_demo_shon6 as "'.__("su2_demo_shon6").'"', 'donnees_techniques.su2_demo_shon7 as "'.__("su2_demo_shon7").'"', 'donnees_techniques.su2_demo_shon8 as "'.__("su2_demo_shon8").'"', 'donnees_techniques.su2_demo_shon9 as "'.__("su2_demo_shon9").'"', 'donnees_techniques.su2_demo_shon10 as "'.__("su2_demo_shon10").'"', 'donnees_techniques.su2_demo_shon11 as "'.__("su2_demo_shon11").'"', 'donnees_techniques.su2_demo_shon12 as "'.__("su2_demo_shon12").'"', 'donnees_techniques.su2_demo_shon13 as "'.__("su2_demo_shon13").'"', 'donnees_techniques.su2_demo_shon14 as "'.__("su2_demo_shon14").'"', 'donnees_techniques.su2_demo_shon15 as "'.__("su2_demo_shon15").'"', 'donnees_techniques.su2_demo_shon16 as "'.__("su2_demo_shon16").'"', 'donnees_techniques.su2_demo_shon17 as "'.__("su2_demo_shon17").'"', 'donnees_techniques.su2_demo_shon18 as "'.__("su2_demo_shon18").'"', 'donnees_techniques.su2_demo_shon19 as "'.__("su2_demo_shon19").'"', 'donnees_techniques.su2_demo_shon20 as "'.__("su2_demo_shon20").'"', 'donnees_techniques.su2_demo_shon_tot as "'.__("su2_demo_shon_tot").'"', 'donnees_techniques.su2_sup_shon1 as "'.__("su2_sup_shon1").'"', 'donnees_techniques.su2_sup_shon2 as "'.__("su2_sup_shon2").'"', 'donnees_techniques.su2_sup_shon3 as "'.__("su2_sup_shon3").'"', 'donnees_techniques.su2_sup_shon4 as "'.__("su2_sup_shon4").'"', 'donnees_techniques.su2_sup_shon5 as "'.__("su2_sup_shon5").'"', 'donnees_techniques.su2_sup_shon6 as "'.__("su2_sup_shon6").'"', 'donnees_techniques.su2_sup_shon7 as "'.__("su2_sup_shon7").'"', 'donnees_techniques.su2_sup_shon8 as "'.__("su2_sup_shon8").'"', 'donnees_techniques.su2_sup_shon9 as "'.__("su2_sup_shon9").'"', 'donnees_techniques.su2_sup_shon10 as "'.__("su2_sup_shon10").'"', 'donnees_techniques.su2_sup_shon11 as "'.__("su2_sup_shon11").'"', 'donnees_techniques.su2_sup_shon12 as "'.__("su2_sup_shon12").'"', 'donnees_techniques.su2_sup_shon13 as "'.__("su2_sup_shon13").'"', 'donnees_techniques.su2_sup_shon14 as "'.__("su2_sup_shon14").'"', 'donnees_techniques.su2_sup_shon15 as "'.__("su2_sup_shon15").'"', 'donnees_techniques.su2_sup_shon16 as "'.__("su2_sup_shon16").'"', 'donnees_techniques.su2_sup_shon17 as "'.__("su2_sup_shon17").'"', 'donnees_techniques.su2_sup_shon18 as "'.__("su2_sup_shon18").'"', 'donnees_techniques.su2_sup_shon19 as "'.__("su2_sup_shon19").'"', 'donnees_techniques.su2_sup_shon20 as "'.__("su2_sup_shon20").'"', 'donnees_techniques.su2_sup_shon_tot as "'.__("su2_sup_shon_tot").'"', 'donnees_techniques.su2_tot_shon1 as "'.__("su2_tot_shon1").'"', 'donnees_techniques.su2_tot_shon2 as "'.__("su2_tot_shon2").'"', 'donnees_techniques.su2_tot_shon3 as "'.__("su2_tot_shon3").'"', 'donnees_techniques.su2_tot_shon4 as "'.__("su2_tot_shon4").'"', 'donnees_techniques.su2_tot_shon5 as "'.__("su2_tot_shon5").'"', 'donnees_techniques.su2_tot_shon6 as "'.__("su2_tot_shon6").'"', 'donnees_techniques.su2_tot_shon7 as "'.__("su2_tot_shon7").'"', 'donnees_techniques.su2_tot_shon8 as "'.__("su2_tot_shon8").'"', 'donnees_techniques.su2_tot_shon9 as "'.__("su2_tot_shon9").'"', 'donnees_techniques.su2_tot_shon10 as "'.__("su2_tot_shon10").'"', 'donnees_techniques.su2_tot_shon11 as "'.__("su2_tot_shon11").'"', 'donnees_techniques.su2_tot_shon12 as "'.__("su2_tot_shon12").'"', 'donnees_techniques.su2_tot_shon13 as "'.__("su2_tot_shon13").'"', 'donnees_techniques.su2_tot_shon14 as "'.__("su2_tot_shon14").'"', 'donnees_techniques.su2_tot_shon15 as "'.__("su2_tot_shon15").'"', 'donnees_techniques.su2_tot_shon16 as "'.__("su2_tot_shon16").'"', 'donnees_techniques.su2_tot_shon17 as "'.__("su2_tot_shon17").'"', 'donnees_techniques.su2_tot_shon18 as "'.__("su2_tot_shon18").'"', 'donnees_techniques.su2_tot_shon19 as "'.__("su2_tot_shon19").'"', 'donnees_techniques.su2_tot_shon20 as "'.__("su2_tot_shon20").'"', 'donnees_techniques.su2_tot_shon_tot as "'.__("su2_tot_shon_tot").'"', "case donnees_techniques.dia_bati_vend_tot when 't' then 'Oui' else 'Non' end as \"".__("dia_bati_vend_tot")."\"", "case donnees_techniques.dia_vente_lot_volume when 't' then 'Oui' else 'Non' end as \"".__("dia_vente_lot_volume")."\"", "case donnees_techniques.dia_lot_bat_achv_plus_10 when 't' then 'Oui' else 'Non' end as \"".__("dia_lot_bat_achv_plus_10")."\"", "case donnees_techniques.dia_lot_bat_achv_moins_10 when 't' then 'Oui' else 'Non' end as \"".__("dia_lot_bat_achv_moins_10")."\"", "case donnees_techniques.dia_lot_regl_copro_publ_hypo_plus_10 when 't' then 'Oui' else 'Non' end as \"".__("dia_lot_regl_copro_publ_hypo_plus_10")."\"", "case donnees_techniques.dia_lot_regl_copro_publ_hypo_moins_10 when 't' then 'Oui' else 'Non' end as \"".__("dia_lot_regl_copro_publ_hypo_moins_10")."\"", "case donnees_techniques.dia_droit_reel_perso_grevant_bien_oui when 't' then 'Oui' else 'Non' end as \"".__("dia_droit_reel_perso_grevant_bien_oui")."\"", "case donnees_techniques.dia_droit_reel_perso_grevant_bien_non when 't' then 'Oui' else 'Non' end as \"".__("dia_droit_reel_perso_grevant_bien_non")."\"", "case donnees_techniques.dia_mod_cess_sign_act_auth when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_sign_act_auth")."\"", "case donnees_techniques.dia_mod_cess_terme when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_terme")."\"", "case donnees_techniques.dia_mod_cess_bene_acquereur when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_bene_acquereur")."\"", "case donnees_techniques.dia_mod_cess_bene_vendeur when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_bene_vendeur")."\"", "case donnees_techniques.dia_mod_cess_paie_nat when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_paie_nat")."\"", "case donnees_techniques.dia_mod_cess_rente_viag when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_rente_viag")."\"", "case donnees_techniques.dia_mod_cess_droit_usa_hab when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_droit_usa_hab")."\"", "case donnees_techniques.dia_mod_cess_vente_nue_prop when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_vente_nue_prop")."\"", "case donnees_techniques.dia_mod_cess_echange when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_echange")."\"", "case donnees_techniques.dia_mod_cess_cess_terr_loc_co when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_cess_terr_loc_co")."\"", "case donnees_techniques.dia_mod_cess_esti_imm_loca when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_esti_imm_loca")."\"", "case donnees_techniques.dia_mod_cess_adju_vol when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_adju_vol")."\"", "case donnees_techniques.dia_mod_cess_adju_obl when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_adju_obl")."\"", "case donnees_techniques.dia_mod_cess_adju_fin_indivi when 't' then 'Oui' else 'Non' end as \"".__("dia_mod_cess_adju_fin_indivi")."\"", "case donnees_techniques.dia_prop_titu_prix_indique when 't' then 'Oui' else 'Non' end as \"".__("dia_prop_titu_prix_indique")."\"", "case donnees_techniques.dia_prop_recherche_acqu_prix_indique when 't' then 'Oui' else 'Non' end as \"".__("dia_prop_recherche_acqu_prix_indique")."\"", "case donnees_techniques.dia_vente_adju when 't' then 'Oui' else 'Non' end as \"".__("dia_vente_adju")."\"", "case donnees_techniques.am_terr_res_demon when 't' then 'Oui' else 'Non' end as \"".__("am_terr_res_demon")."\"", "case donnees_techniques.am_air_terr_res_mob when 't' then 'Oui' else 'Non' end as \"".__("am_air_terr_res_mob")."\"", 'objet_recours.libelle as "'.__("ctx_objet_recours").'"', 'donnees_techniques.ctx_reference_sagace as "'.__("ctx_reference_sagace").'"', 'donnees_techniques.ctx_reference_parquet as "'.__("ctx_reference_parquet").'"', 'donnees_techniques.ctx_element_taxation as "'.__("ctx_element_taxation").'"', "case donnees_techniques.ctx_infraction when 't' then 'Oui' else 'Non' end as \"".__("ctx_infraction")."\"", "case donnees_techniques.ctx_regularisable when 't' then 'Oui' else 'Non' end as \"".__("ctx_regularisable")."\"", 'donnees_techniques.ctx_reference_courrier as "'.__("ctx_reference_courrier").'"', 'to_char(donnees_techniques.ctx_date_audience ,\'DD/MM/YYYY\') as "'.__("ctx_date_audience").'"', 'to_char(donnees_techniques.ctx_date_ajournement ,\'DD/MM/YYYY\') as "'.__("ctx_date_ajournement").'"', "case donnees_techniques.exo_facul_1 when 't' then 'Oui' else 'Non' end as \"".__("exo_facul_1")."\"", "case donnees_techniques.exo_facul_2 when 't' then 'Oui' else 'Non' end as \"".__("exo_facul_2")."\"", "case donnees_techniques.exo_facul_3 when 't' then 'Oui' else 'Non' end as \"".__("exo_facul_3")."\"", "case donnees_techniques.exo_facul_4 when 't' then 'Oui' else 'Non' end as \"".__("exo_facul_4")."\"", "case donnees_techniques.exo_facul_5 when 't' then 'Oui' else 'Non' end as \"".__("exo_facul_5")."\"", "case donnees_techniques.exo_facul_6 when 't' then 'Oui' else 'Non' end as \"".__("exo_facul_6")."\"", "case donnees_techniques.exo_facul_7 when 't' then 'Oui' else 'Non' end as \"".__("exo_facul_7")."\"", "case donnees_techniques.exo_facul_8 when 't' then 'Oui' else 'Non' end as \"".__("exo_facul_8")."\"", "case donnees_techniques.exo_facul_9 when 't' then 'Oui' else 'Non' end as \"".__("exo_facul_9")."\"", "case donnees_techniques.exo_ta_1 when 't' then 'Oui' else 'Non' end as \"".__("exo_ta_1")."\"", "case donnees_techniques.exo_ta_2 when 't' then 'Oui' else 'Non' end as \"".__("exo_ta_2")."\"", "case donnees_techniques.exo_ta_3 when 't' then 'Oui' else 'Non' end as \"".__("exo_ta_3")."\"", "case donnees_techniques.exo_ta_4 when 't' then 'Oui' else 'Non' end as \"".__("exo_ta_4")."\"", "case donnees_techniques.exo_ta_5 when 't' then 'Oui' else 'Non' end as \"".__("exo_ta_5")."\"", "case donnees_techniques.exo_ta_6 when 't' then 'Oui' else 'Non' end as \"".__("exo_ta_6")."\"", "case donnees_techniques.exo_ta_7 when 't' then 'Oui' else 'Non' end as \"".__("exo_ta_7")."\"", "case donnees_techniques.exo_ta_8 when 't' then 'Oui' else 'Non' end as \"".__("exo_ta_8")."\"", "case donnees_techniques.exo_ta_9 when 't' then 'Oui' else 'Non' end as \"".__("exo_ta_9")."\"", "case donnees_techniques.exo_rap_1 when 't' then 'Oui' else 'Non' end as \"".__("exo_rap_1")."\"", "case donnees_techniques.exo_rap_2 when 't' then 'Oui' else 'Non' end as \"".__("exo_rap_2")."\"", "case donnees_techniques.exo_rap_3 when 't' then 'Oui' else 'Non' end as \"".__("exo_rap_3")."\"", "case donnees_techniques.exo_rap_4 when 't' then 'Oui' else 'Non' end as \"".__("exo_rap_4")."\"", "case donnees_techniques.exo_rap_5 when 't' then 'Oui' else 'Non' end as \"".__("exo_rap_5")."\"", "case donnees_techniques.exo_rap_6 when 't' then 'Oui' else 'Non' end as \"".__("exo_rap_6")."\"", "case donnees_techniques.exo_rap_7 when 't' then 'Oui' else 'Non' end as \"".__("exo_rap_7")."\"", "case donnees_techniques.exo_rap_8 when 't' then 'Oui' else 'Non' end as \"".__("exo_rap_8")."\"", 'donnees_techniques.mtn_exo_ta_part_commu as "'.__("mtn_exo_ta_part_commu").'"', 'donnees_techniques.mtn_exo_ta_part_depart as "'.__("mtn_exo_ta_part_depart").'"', 'donnees_techniques.mtn_exo_ta_part_reg as "'.__("mtn_exo_ta_part_reg").'"', 'donnees_techniques.mtn_exo_rap as "'.__("mtn_exo_rap").'"', 'donnees_techniques.dpc_type as "'.__("dpc_type").'"', "case donnees_techniques.dpc_desig_comm_arti when 't' then 'Oui' else 'Non' end as \"".__("dpc_desig_comm_arti")."\"", "case donnees_techniques.dpc_desig_loc_hab when 't' then 'Oui' else 'Non' end as \"".__("dpc_desig_loc_hab")."\"", "case donnees_techniques.dpc_desig_loc_ann when 't' then 'Oui' else 'Non' end as \"".__("dpc_desig_loc_ann")."\"", 'to_char(donnees_techniques.dpc_bail_comm_date ,\'DD/MM/YYYY\') as "'.__("dpc_bail_comm_date").'"', "case donnees_techniques.dpc_moda_cess_vente_am when 't' then 'Oui' else 'Non' end as \"".__("dpc_moda_cess_vente_am")."\"", "case donnees_techniques.dpc_moda_cess_adj when 't' then 'Oui' else 'Non' end as \"".__("dpc_moda_cess_adj")."\"", 'to_char(donnees_techniques.dpc_moda_cess_adj_date ,\'DD/MM/YYYY\') as "'.__("dpc_moda_cess_adj_date").'"', "case donnees_techniques.dpc_moda_cess_paie_comp when 't' then 'Oui' else 'Non' end as \"".__("dpc_moda_cess_paie_comp")."\"", "case donnees_techniques.dpc_moda_cess_paie_terme when 't' then 'Oui' else 'Non' end as \"".__("dpc_moda_cess_paie_terme")."\"", "case donnees_techniques.dpc_moda_cess_paie_nat when 't' then 'Oui' else 'Non' end as \"".__("dpc_moda_cess_paie_nat")."\"", "case donnees_techniques.dpc_moda_cess_paie_nat_desig_alien when 't' then 'Oui' else 'Non' end as \"".__("dpc_moda_cess_paie_nat_desig_alien")."\"", "case donnees_techniques.dpc_moda_cess_paie_nat_eval when 't' then 'Oui' else 'Non' end as \"".__("dpc_moda_cess_paie_nat_eval")."\"", "case donnees_techniques.dpc_moda_cess_paie_aut when 't' then 'Oui' else 'Non' end as \"".__("dpc_moda_cess_paie_aut")."\"", "case donnees_techniques.dpc_ss_signe_demande_acqu when 't' then 'Oui' else 'Non' end as \"".__("dpc_ss_signe_demande_acqu")."\"", "case donnees_techniques.dpc_ss_signe_recher_trouv_acqu when 't' then 'Oui' else 'Non' end as \"".__("dpc_ss_signe_recher_trouv_acqu")."\"", "case donnees_techniques.dpc_notif_adr_prop when 't' then 'Oui' else 'Non' end as \"".__("dpc_notif_adr_prop")."\"", "case donnees_techniques.dpc_notif_adr_manda when 't' then 'Oui' else 'Non' end as \"".__("dpc_notif_adr_manda")."\"", "case donnees_techniques.co_peri_site_patri_remar when 't' then 'Oui' else 'Non' end as \"".__("co_peri_site_patri_remar")."\"", "case donnees_techniques.co_abo_monu_hist when 't' then 'Oui' else 'Non' end as \"".__("co_abo_monu_hist")."\"", "case donnees_techniques.co_inst_ouvr_trav_act_code_envir when 't' then 'Oui' else 'Non' end as \"".__("co_inst_ouvr_trav_act_code_envir")."\"", "case donnees_techniques.co_trav_auto_env when 't' then 'Oui' else 'Non' end as \"".__("co_trav_auto_env")."\"", "case donnees_techniques.co_derog_esp_prot when 't' then 'Oui' else 'Non' end as \"".__("co_derog_esp_prot")."\"", 'donnees_techniques.ctx_reference_dsj as "'.__("ctx_reference_dsj").'"', "case donnees_techniques.co_piscine when 't' then 'Oui' else 'Non' end as \"".__("co_piscine")."\"", "case donnees_techniques.co_fin_lls when 't' then 'Oui' else 'Non' end as \"".__("co_fin_lls")."\"", "case donnees_techniques.co_fin_aa when 't' then 'Oui' else 'Non' end as \"".__("co_fin_aa")."\"", "case donnees_techniques.co_fin_ptz when 't' then 'Oui' else 'Non' end as \"".__("co_fin_ptz")."\"", 'to_char(donnees_techniques.dia_ss_date ,\'DD/MM/YYYY\') as "'.__("dia_ss_date").'"', 'donnees_techniques.dia_ss_lieu as "'.__("dia_ss_lieu").'"', 'donnees_techniques.enga_decla_lieu as "'.__("enga_decla_lieu").'"', 'to_char(donnees_techniques.enga_decla_date ,\'DD/MM/YYYY\') as "'.__("enga_decla_date").'"', "case donnees_techniques.co_archi_attest_honneur when 't' then 'Oui' else 'Non' end as \"".__("co_archi_attest_honneur")."\"", 'donnees_techniques.co_bat_niv_dessous_nb as "'.__("co_bat_niv_dessous_nb").'"', "case donnees_techniques.co_install_classe when 't' then 'Oui' else 'Non' end as \"".__("co_install_classe")."\"", "case donnees_techniques.co_derog_innov when 't' then 'Oui' else 'Non' end as \"".__("co_derog_innov")."\"", "case donnees_techniques.co_avis_abf when 't' then 'Oui' else 'Non' end as \"".__("co_avis_abf")."\"", 'donnees_techniques.tax_surf_tot_demo as "'.__("tax_surf_tot_demo").'"', 'donnees_techniques.tax_surf_tax_demo as "'.__("tax_surf_tax_demo").'"', 'donnees_techniques.tax_su_non_habit_surf8 as "'.__("tax_su_non_habit_surf8").'"', 'donnees_techniques.tax_su_non_habit_surf_stat8 as "'.__("tax_su_non_habit_surf_stat8").'"', 'donnees_techniques.tax_su_non_habit_surf9 as "'.__("tax_su_non_habit_surf9").'"', 'donnees_techniques.tax_su_non_habit_surf_stat9 as "'.__("tax_su_non_habit_surf_stat9").'"', "case donnees_techniques.tax_terrassement_arch when 't' then 'Oui' else 'Non' end as \"".__("tax_terrassement_arch")."\"", 'donnees_techniques.tax_adresse_future_numero as "'.__("tax_adresse_future_numero").'"', 'donnees_techniques.tax_adresse_future_voie as "'.__("tax_adresse_future_voie").'"', 'donnees_techniques.tax_adresse_future_lieudit as "'.__("tax_adresse_future_lieudit").'"', 'donnees_techniques.tax_adresse_future_localite as "'.__("tax_adresse_future_localite").'"', 'donnees_techniques.tax_adresse_future_cp as "'.__("tax_adresse_future_cp").'"', 'donnees_techniques.tax_adresse_future_bp as "'.__("tax_adresse_future_bp").'"', 'donnees_techniques.tax_adresse_future_cedex as "'.__("tax_adresse_future_cedex").'"', 'donnees_techniques.tax_adresse_future_pays as "'.__("tax_adresse_future_pays").'"', 'donnees_techniques.tax_adresse_future_division as "'.__("tax_adresse_future_division").'"', 'to_char(donnees_techniques.terr_juri_titul_date ,\'DD/MM/YYYY\') as "'.__("terr_juri_titul_date").'"', "case donnees_techniques.co_autre when 't' then 'Oui' else 'Non' end as \"".__("co_autre")."\"", "case donnees_techniques.erp_modif_facades when 't' then 'Oui' else 'Non' end as \"".__("erp_modif_facades")."\"", "case donnees_techniques.erp_trvx_adap when 't' then 'Oui' else 'Non' end as \"".__("erp_trvx_adap")."\"", 'donnees_techniques.erp_trvx_adap_numero as "'.__("erp_trvx_adap_numero").'"', 'to_char(donnees_techniques.erp_trvx_adap_valid ,\'DD/MM/YYYY\') as "'.__("erp_trvx_adap_valid").'"', "case donnees_techniques.erp_prod_dangereux when 't' then 'Oui' else 'Non' end as \"".__("erp_prod_dangereux")."\"", 'donnees_techniques.co_trav_supp_dessus as "'.__("co_trav_supp_dessus").'"', 'donnees_techniques.co_trav_supp_dessous as "'.__("co_trav_supp_dessous").'"', 'donnees_techniques.tax_su_habit_abr_jard_pig_colom as "'.__("tax_su_habit_abr_jard_pig_colom").'"', "case donnees_techniques.enga_decla_donnees_nomi_comm when 't' then 'Oui' else 'Non' end as \"".__("enga_decla_donnees_nomi_comm")."\"", ); // $champNonAffiche = array( 'donnees_techniques.am_projet_desc as "'.__("am_projet_desc").'"', 'donnees_techniques.am_tranche_desc as "'.__("am_tranche_desc").'"', 'donnees_techniques.am_periode_exploit as "'.__("am_periode_exploit").'"', 'donnees_techniques.co_projet_desc as "'.__("co_projet_desc").'"', 'donnees_techniques.co_anx_autr_desc as "'.__("co_anx_autr_desc").'"', 'donnees_techniques.co_fin_autr_desc as "'.__("co_fin_autr_desc").'"', 'donnees_techniques.co_resid_autr_desc as "'.__("co_resid_autr_desc").'"', 'donnees_techniques.co_demont_periode as "'.__("co_demont_periode").'"', 'donnees_techniques.co_statio_adr as "'.__("co_statio_adr").'"', 'donnees_techniques.dm_constr_dates as "'.__("dm_constr_dates").'"', 'donnees_techniques.dm_projet_desc as "'.__("dm_projet_desc").'"', 'donnees_techniques.tax_ext_desc as "'.__("tax_ext_desc").'"', 'donnees_techniques.terr_juri_desc as "'.__("terr_juri_desc").'"', 'donnees_techniques.doc_tranche_trav_desc as "'.__("doc_tranche_trav_desc").'"', 'donnees_techniques.daact_tranche_trav_desc as "'.__("daact_tranche_trav_desc").'"', 'donnees_techniques.ope_proj_desc as "'.__("ope_proj_desc").'"', 'donnees_techniques.tax_desc as "'.__("tax_desc").'"', 'donnees_techniques.dia_imm_bati_terr_autr_desc as "'.__("dia_imm_bati_terr_autr_desc").'"', 'donnees_techniques.dia_bat_copro_desc as "'.__("dia_bat_copro_desc").'"', 'donnees_techniques.dia_lot_numero as "'.__("dia_lot_numero").'"', 'donnees_techniques.dia_lot_bat as "'.__("dia_lot_bat").'"', 'donnees_techniques.dia_lot_etage as "'.__("dia_lot_etage").'"', 'donnees_techniques.dia_lot_quote_part as "'.__("dia_lot_quote_part").'"', 'donnees_techniques.dia_us_autre_prec as "'.__("dia_us_autre_prec").'"', 'donnees_techniques.dia_occ_autre_prec as "'.__("dia_occ_autre_prec").'"', 'donnees_techniques.dia_observation as "'.__("dia_observation").'"', 'donnees_techniques.dia_occ_sol_su_terre as "'.__("dia_occ_sol_su_terre").'"', 'donnees_techniques.dia_occ_sol_su_pres as "'.__("dia_occ_sol_su_pres").'"', 'donnees_techniques.dia_occ_sol_su_verger as "'.__("dia_occ_sol_su_verger").'"', 'donnees_techniques.dia_occ_sol_su_vigne as "'.__("dia_occ_sol_su_vigne").'"', 'donnees_techniques.dia_occ_sol_su_bois as "'.__("dia_occ_sol_su_bois").'"', 'donnees_techniques.dia_occ_sol_su_lande as "'.__("dia_occ_sol_su_lande").'"', 'donnees_techniques.dia_occ_sol_su_carriere as "'.__("dia_occ_sol_su_carriere").'"', 'donnees_techniques.dia_occ_sol_su_eau_cadastree as "'.__("dia_occ_sol_su_eau_cadastree").'"', 'donnees_techniques.dia_occ_sol_su_jardin as "'.__("dia_occ_sol_su_jardin").'"', 'donnees_techniques.dia_occ_sol_su_terr_batir as "'.__("dia_occ_sol_su_terr_batir").'"', 'donnees_techniques.dia_occ_sol_su_terr_agr as "'.__("dia_occ_sol_su_terr_agr").'"', 'donnees_techniques.dia_occ_sol_su_sol as "'.__("dia_occ_sol_su_sol").'"', 'donnees_techniques.dia_bati_vend_tot_txt as "'.__("dia_bati_vend_tot_txt").'"', 'donnees_techniques.dia_su_co_sol as "'.__("dia_su_co_sol").'"', 'donnees_techniques.dia_su_util_hab as "'.__("dia_su_util_hab").'"', 'donnees_techniques.dia_nb_niv as "'.__("dia_nb_niv").'"', 'donnees_techniques.dia_nb_appart as "'.__("dia_nb_appart").'"', 'donnees_techniques.dia_nb_autre_loc as "'.__("dia_nb_autre_loc").'"', 'donnees_techniques.dia_vente_lot_volume_txt as "'.__("dia_vente_lot_volume_txt").'"', 'donnees_techniques.dia_lot_nat_su as "'.__("dia_lot_nat_su").'"', 'donnees_techniques.dia_indivi_quote_part as "'.__("dia_indivi_quote_part").'"', 'donnees_techniques.dia_design_societe as "'.__("dia_design_societe").'"', 'donnees_techniques.dia_design_droit as "'.__("dia_design_droit").'"', 'donnees_techniques.dia_droit_soc_nat as "'.__("dia_droit_soc_nat").'"', 'donnees_techniques.dia_droit_soc_nb as "'.__("dia_droit_soc_nb").'"', 'donnees_techniques.dia_droit_soc_num_part as "'.__("dia_droit_soc_num_part").'"', 'donnees_techniques.dia_droit_reel_perso_nat as "'.__("dia_droit_reel_perso_nat").'"', 'donnees_techniques.dia_droit_reel_perso_viag as "'.__("dia_droit_reel_perso_viag").'"', 'donnees_techniques.dia_mod_cess_adr as "'.__("dia_mod_cess_adr").'"', 'donnees_techniques.dia_mod_cess_terme_prec as "'.__("dia_mod_cess_terme_prec").'"', 'donnees_techniques.dia_mod_cess_design_contr_alien as "'.__("dia_mod_cess_design_contr_alien").'"', 'donnees_techniques.dia_mod_cess_eval_contr as "'.__("dia_mod_cess_eval_contr").'"', 'donnees_techniques.dia_mod_cess_mnt_an as "'.__("dia_mod_cess_mnt_an").'"', 'donnees_techniques.dia_mod_cess_mnt_compt as "'.__("dia_mod_cess_mnt_compt").'"', 'donnees_techniques.dia_mod_cess_bene_rente as "'.__("dia_mod_cess_bene_rente").'"', 'donnees_techniques.dia_mod_cess_droit_usa_hab_prec as "'.__("dia_mod_cess_droit_usa_hab_prec").'"', 'donnees_techniques.dia_mod_cess_eval_usa_usufruit as "'.__("dia_mod_cess_eval_usa_usufruit").'"', 'donnees_techniques.dia_mod_cess_vente_nue_prop_prec as "'.__("dia_mod_cess_vente_nue_prop_prec").'"', 'donnees_techniques.dia_mod_cess_design_bien_recus_ech as "'.__("dia_mod_cess_design_bien_recus_ech").'"', 'donnees_techniques.dia_mod_cess_mnt_soulte as "'.__("dia_mod_cess_mnt_soulte").'"', 'donnees_techniques.dia_mod_cess_prop_contre_echan as "'.__("dia_mod_cess_prop_contre_echan").'"', 'donnees_techniques.dia_mod_cess_apport_societe as "'.__("dia_mod_cess_apport_societe").'"', 'donnees_techniques.dia_mod_cess_bene as "'.__("dia_mod_cess_bene").'"', 'donnees_techniques.dia_mod_cess_esti_bien as "'.__("dia_mod_cess_esti_bien").'"', 'donnees_techniques.dia_mod_cess_esti_terr as "'.__("dia_mod_cess_esti_terr").'"', 'donnees_techniques.dia_mod_cess_esti_loc as "'.__("dia_mod_cess_esti_loc").'"', 'donnees_techniques.dia_mod_cess_adju_date_lieu as "'.__("dia_mod_cess_adju_date_lieu").'"', 'donnees_techniques.dia_mod_cess_mnt_mise_prix as "'.__("dia_mod_cess_mnt_mise_prix").'"', 'donnees_techniques.dia_acquereur_prof as "'.__("dia_acquereur_prof").'"', 'donnees_techniques.dia_indic_compl_ope as "'.__("dia_indic_compl_ope").'"', 'donnees_techniques.ctx_nature_travaux_infra_om_html as "'.__("ctx_nature_travaux_infra_om_html").'"', 'donnees_techniques.ctx_synthese_nti as "'.__("ctx_synthese_nti").'"', 'donnees_techniques.ctx_article_non_resp_om_html as "'.__("ctx_article_non_resp_om_html").'"', 'donnees_techniques.ctx_synthese_anr as "'.__("ctx_synthese_anr").'"', 'donnees_techniques.dpc_desc_actv_ex as "'.__("dpc_desc_actv_ex").'"', 'donnees_techniques.dpc_desc_ca as "'.__("dpc_desc_ca").'"', 'donnees_techniques.dpc_desc_aut_prec as "'.__("dpc_desc_aut_prec").'"', 'donnees_techniques.dpc_desig_loc_ann_prec as "'.__("dpc_desig_loc_ann_prec").'"', 'donnees_techniques.dpc_bail_comm_loyer as "'.__("dpc_bail_comm_loyer").'"', 'donnees_techniques.dpc_actv_acqu as "'.__("dpc_actv_acqu").'"', 'donnees_techniques.dpc_nb_sala_di as "'.__("dpc_nb_sala_di").'"', 'donnees_techniques.dpc_nb_sala_dd as "'.__("dpc_nb_sala_dd").'"', 'donnees_techniques.dpc_nb_sala_tc as "'.__("dpc_nb_sala_tc").'"', 'donnees_techniques.dpc_nb_sala_tp as "'.__("dpc_nb_sala_tp").'"', 'donnees_techniques.dpc_moda_cess_prix as "'.__("dpc_moda_cess_prix").'"', 'donnees_techniques.dpc_moda_cess_adj_prec as "'.__("dpc_moda_cess_adj_prec").'"', 'donnees_techniques.dpc_moda_cess_paie_terme_prec as "'.__("dpc_moda_cess_paie_terme_prec").'"', 'donnees_techniques.dpc_moda_cess_paie_nat_desig_alien_prec as "'.__("dpc_moda_cess_paie_nat_desig_alien_prec").'"', 'donnees_techniques.dpc_moda_cess_paie_nat_eval_prec as "'.__("dpc_moda_cess_paie_nat_eval_prec").'"', 'donnees_techniques.dpc_moda_cess_paie_aut_prec as "'.__("dpc_moda_cess_paie_aut_prec").'"', 'donnees_techniques.dpc_obs as "'.__("dpc_obs").'"', 'donnees_techniques.co_fin_autr as "'.__("co_fin_autr").'"', 'donnees_techniques.co_bat_projete as "'.__("co_bat_projete").'"', 'donnees_techniques.co_bat_existant as "'.__("co_bat_existant").'"', 'donnees_techniques.co_bat_nature as "'.__("co_bat_nature").'"', 'donnees_techniques.co_autre_desc as "'.__("co_autre_desc").'"', 'donnees_techniques.co_trx_autre as "'.__("co_trx_autre").'"', ); // $champRecherche = array( 'donnees_techniques.donnees_techniques as "'.__("donnees_techniques").'"', 'dossier.annee as "'.__("dossier_instruction").'"', 'lot.libelle as "'.__("lot").'"', 'donnees_techniques.am_carav_duree as "'.__("am_carav_duree").'"', 'donnees_techniques.am_statio_cont as "'.__("am_statio_cont").'"', 'donnees_techniques.am_affou_exhau_sup as "'.__("am_affou_exhau_sup").'"', 'donnees_techniques.am_affou_prof as "'.__("am_affou_prof").'"', 'donnees_techniques.am_exhau_haut as "'.__("am_exhau_haut").'"', 'donnees_techniques.am_terr_surf as "'.__("am_terr_surf").'"', 'donnees_techniques.am_lot_max_nb as "'.__("am_lot_max_nb").'"', 'donnees_techniques.am_lot_max_shon as "'.__("am_lot_max_shon").'"', 'donnees_techniques.am_empl_nb as "'.__("am_empl_nb").'"', 'donnees_techniques.am_tente_nb as "'.__("am_tente_nb").'"', 'donnees_techniques.am_carav_nb as "'.__("am_carav_nb").'"', 'donnees_techniques.am_mobil_nb as "'.__("am_mobil_nb").'"', 'donnees_techniques.am_pers_nb as "'.__("am_pers_nb").'"', 'donnees_techniques.am_empl_hll_nb as "'.__("am_empl_hll_nb").'"', 'donnees_techniques.am_hll_shon as "'.__("am_hll_shon").'"', 'donnees_techniques.am_exist_date as "'.__("am_exist_date").'"', 'donnees_techniques.am_exist_num as "'.__("am_exist_num").'"', 'donnees_techniques.am_exist_nb_avant as "'.__("am_exist_nb_avant").'"', 'donnees_techniques.am_exist_nb_apres as "'.__("am_exist_nb_apres").'"', 'donnees_techniques.am_coupe_ess as "'.__("am_coupe_ess").'"', 'donnees_techniques.am_coupe_age as "'.__("am_coupe_age").'"', 'donnees_techniques.am_coupe_dens as "'.__("am_coupe_dens").'"', 'donnees_techniques.am_coupe_qual as "'.__("am_coupe_qual").'"', 'donnees_techniques.am_coupe_trait as "'.__("am_coupe_trait").'"', 'donnees_techniques.am_coupe_autr as "'.__("am_coupe_autr").'"', 'donnees_techniques.co_elec_tension as "'.__("co_elec_tension").'"', 'donnees_techniques.co_tot_log_nb as "'.__("co_tot_log_nb").'"', 'donnees_techniques.co_tot_ind_nb as "'.__("co_tot_ind_nb").'"', 'donnees_techniques.co_tot_coll_nb as "'.__("co_tot_coll_nb").'"', 'donnees_techniques.co_mais_piece_nb as "'.__("co_mais_piece_nb").'"', 'donnees_techniques.co_mais_niv_nb as "'.__("co_mais_niv_nb").'"', 'donnees_techniques.co_fin_lls_nb as "'.__("co_fin_lls_nb").'"', 'donnees_techniques.co_fin_aa_nb as "'.__("co_fin_aa_nb").'"', 'donnees_techniques.co_fin_ptz_nb as "'.__("co_fin_ptz_nb").'"', 'donnees_techniques.co_fin_autr_nb as "'.__("co_fin_autr_nb").'"', 'donnees_techniques.co_foyer_chamb_nb as "'.__("co_foyer_chamb_nb").'"', 'donnees_techniques.co_log_1p_nb as "'.__("co_log_1p_nb").'"', 'donnees_techniques.co_log_2p_nb as "'.__("co_log_2p_nb").'"', 'donnees_techniques.co_log_3p_nb as "'.__("co_log_3p_nb").'"', 'donnees_techniques.co_log_4p_nb as "'.__("co_log_4p_nb").'"', 'donnees_techniques.co_log_5p_nb as "'.__("co_log_5p_nb").'"', 'donnees_techniques.co_log_6p_nb as "'.__("co_log_6p_nb").'"', 'donnees_techniques.co_bat_niv_nb as "'.__("co_bat_niv_nb").'"', 'donnees_techniques.co_statio_avt_nb as "'.__("co_statio_avt_nb").'"', 'donnees_techniques.co_statio_apr_nb as "'.__("co_statio_apr_nb").'"', 'donnees_techniques.co_statio_place_nb as "'.__("co_statio_place_nb").'"', 'donnees_techniques.co_statio_tot_surf as "'.__("co_statio_tot_surf").'"', 'donnees_techniques.co_statio_tot_shob as "'.__("co_statio_tot_shob").'"', 'donnees_techniques.co_statio_comm_cin_surf as "'.__("co_statio_comm_cin_surf").'"', 'donnees_techniques.su_avt_shon1 as "'.__("su_avt_shon1").'"', 'donnees_techniques.su_avt_shon2 as "'.__("su_avt_shon2").'"', 'donnees_techniques.su_avt_shon3 as "'.__("su_avt_shon3").'"', 'donnees_techniques.su_avt_shon4 as "'.__("su_avt_shon4").'"', 'donnees_techniques.su_avt_shon5 as "'.__("su_avt_shon5").'"', 'donnees_techniques.su_avt_shon6 as "'.__("su_avt_shon6").'"', 'donnees_techniques.su_avt_shon7 as "'.__("su_avt_shon7").'"', 'donnees_techniques.su_avt_shon8 as "'.__("su_avt_shon8").'"', 'donnees_techniques.su_avt_shon9 as "'.__("su_avt_shon9").'"', 'donnees_techniques.su_cstr_shon1 as "'.__("su_cstr_shon1").'"', 'donnees_techniques.su_cstr_shon2 as "'.__("su_cstr_shon2").'"', 'donnees_techniques.su_cstr_shon3 as "'.__("su_cstr_shon3").'"', 'donnees_techniques.su_cstr_shon4 as "'.__("su_cstr_shon4").'"', 'donnees_techniques.su_cstr_shon5 as "'.__("su_cstr_shon5").'"', 'donnees_techniques.su_cstr_shon6 as "'.__("su_cstr_shon6").'"', 'donnees_techniques.su_cstr_shon7 as "'.__("su_cstr_shon7").'"', 'donnees_techniques.su_cstr_shon8 as "'.__("su_cstr_shon8").'"', 'donnees_techniques.su_cstr_shon9 as "'.__("su_cstr_shon9").'"', 'donnees_techniques.su_trsf_shon1 as "'.__("su_trsf_shon1").'"', 'donnees_techniques.su_trsf_shon2 as "'.__("su_trsf_shon2").'"', 'donnees_techniques.su_trsf_shon3 as "'.__("su_trsf_shon3").'"', 'donnees_techniques.su_trsf_shon4 as "'.__("su_trsf_shon4").'"', 'donnees_techniques.su_trsf_shon5 as "'.__("su_trsf_shon5").'"', 'donnees_techniques.su_trsf_shon6 as "'.__("su_trsf_shon6").'"', 'donnees_techniques.su_trsf_shon7 as "'.__("su_trsf_shon7").'"', 'donnees_techniques.su_trsf_shon8 as "'.__("su_trsf_shon8").'"', 'donnees_techniques.su_trsf_shon9 as "'.__("su_trsf_shon9").'"', 'donnees_techniques.su_chge_shon1 as "'.__("su_chge_shon1").'"', 'donnees_techniques.su_chge_shon2 as "'.__("su_chge_shon2").'"', 'donnees_techniques.su_chge_shon3 as "'.__("su_chge_shon3").'"', 'donnees_techniques.su_chge_shon4 as "'.__("su_chge_shon4").'"', 'donnees_techniques.su_chge_shon5 as "'.__("su_chge_shon5").'"', 'donnees_techniques.su_chge_shon6 as "'.__("su_chge_shon6").'"', 'donnees_techniques.su_chge_shon7 as "'.__("su_chge_shon7").'"', 'donnees_techniques.su_chge_shon8 as "'.__("su_chge_shon8").'"', 'donnees_techniques.su_chge_shon9 as "'.__("su_chge_shon9").'"', 'donnees_techniques.su_demo_shon1 as "'.__("su_demo_shon1").'"', 'donnees_techniques.su_demo_shon2 as "'.__("su_demo_shon2").'"', 'donnees_techniques.su_demo_shon3 as "'.__("su_demo_shon3").'"', 'donnees_techniques.su_demo_shon4 as "'.__("su_demo_shon4").'"', 'donnees_techniques.su_demo_shon5 as "'.__("su_demo_shon5").'"', 'donnees_techniques.su_demo_shon6 as "'.__("su_demo_shon6").'"', 'donnees_techniques.su_demo_shon7 as "'.__("su_demo_shon7").'"', 'donnees_techniques.su_demo_shon8 as "'.__("su_demo_shon8").'"', 'donnees_techniques.su_demo_shon9 as "'.__("su_demo_shon9").'"', 'donnees_techniques.su_sup_shon1 as "'.__("su_sup_shon1").'"', 'donnees_techniques.su_sup_shon2 as "'.__("su_sup_shon2").'"', 'donnees_techniques.su_sup_shon3 as "'.__("su_sup_shon3").'"', 'donnees_techniques.su_sup_shon4 as "'.__("su_sup_shon4").'"', 'donnees_techniques.su_sup_shon5 as "'.__("su_sup_shon5").'"', 'donnees_techniques.su_sup_shon6 as "'.__("su_sup_shon6").'"', 'donnees_techniques.su_sup_shon7 as "'.__("su_sup_shon7").'"', 'donnees_techniques.su_sup_shon8 as "'.__("su_sup_shon8").'"', 'donnees_techniques.su_sup_shon9 as "'.__("su_sup_shon9").'"', 'donnees_techniques.su_tot_shon1 as "'.__("su_tot_shon1").'"', 'donnees_techniques.su_tot_shon2 as "'.__("su_tot_shon2").'"', 'donnees_techniques.su_tot_shon3 as "'.__("su_tot_shon3").'"', 'donnees_techniques.su_tot_shon4 as "'.__("su_tot_shon4").'"', 'donnees_techniques.su_tot_shon5 as "'.__("su_tot_shon5").'"', 'donnees_techniques.su_tot_shon6 as "'.__("su_tot_shon6").'"', 'donnees_techniques.su_tot_shon7 as "'.__("su_tot_shon7").'"', 'donnees_techniques.su_tot_shon8 as "'.__("su_tot_shon8").'"', 'donnees_techniques.su_tot_shon9 as "'.__("su_tot_shon9").'"', 'donnees_techniques.su_avt_shon_tot as "'.__("su_avt_shon_tot").'"', 'donnees_techniques.su_cstr_shon_tot as "'.__("su_cstr_shon_tot").'"', 'donnees_techniques.su_trsf_shon_tot as "'.__("su_trsf_shon_tot").'"', 'donnees_techniques.su_chge_shon_tot as "'.__("su_chge_shon_tot").'"', 'donnees_techniques.su_demo_shon_tot as "'.__("su_demo_shon_tot").'"', 'donnees_techniques.su_sup_shon_tot as "'.__("su_sup_shon_tot").'"', 'donnees_techniques.su_tot_shon_tot as "'.__("su_tot_shon_tot").'"', 'donnees_techniques.dm_tot_log_nb as "'.__("dm_tot_log_nb").'"', 'donnees_techniques.tax_surf_tot as "'.__("tax_surf_tot").'"', 'donnees_techniques.tax_surf as "'.__("tax_surf").'"', 'donnees_techniques.tax_surf_suppr_mod as "'.__("tax_surf_suppr_mod").'"', 'donnees_techniques.tax_su_princ_log_nb1 as "'.__("tax_su_princ_log_nb1").'"', 'donnees_techniques.tax_su_princ_log_nb2 as "'.__("tax_su_princ_log_nb2").'"', 'donnees_techniques.tax_su_princ_log_nb3 as "'.__("tax_su_princ_log_nb3").'"', 'donnees_techniques.tax_su_princ_log_nb4 as "'.__("tax_su_princ_log_nb4").'"', 'donnees_techniques.tax_su_princ_log_nb_tot1 as "'.__("tax_su_princ_log_nb_tot1").'"', 'donnees_techniques.tax_su_princ_log_nb_tot2 as "'.__("tax_su_princ_log_nb_tot2").'"', 'donnees_techniques.tax_su_princ_log_nb_tot3 as "'.__("tax_su_princ_log_nb_tot3").'"', 'donnees_techniques.tax_su_princ_log_nb_tot4 as "'.__("tax_su_princ_log_nb_tot4").'"', 'donnees_techniques.tax_su_princ_surf1 as "'.__("tax_su_princ_surf1").'"', 'donnees_techniques.tax_su_princ_surf2 as "'.__("tax_su_princ_surf2").'"', 'donnees_techniques.tax_su_princ_surf3 as "'.__("tax_su_princ_surf3").'"', 'donnees_techniques.tax_su_princ_surf4 as "'.__("tax_su_princ_surf4").'"', 'donnees_techniques.tax_su_princ_surf_sup1 as "'.__("tax_su_princ_surf_sup1").'"', 'donnees_techniques.tax_su_princ_surf_sup2 as "'.__("tax_su_princ_surf_sup2").'"', 'donnees_techniques.tax_su_princ_surf_sup3 as "'.__("tax_su_princ_surf_sup3").'"', 'donnees_techniques.tax_su_princ_surf_sup4 as "'.__("tax_su_princ_surf_sup4").'"', 'donnees_techniques.tax_su_heber_log_nb1 as "'.__("tax_su_heber_log_nb1").'"', 'donnees_techniques.tax_su_heber_log_nb2 as "'.__("tax_su_heber_log_nb2").'"', 'donnees_techniques.tax_su_heber_log_nb3 as "'.__("tax_su_heber_log_nb3").'"', 'donnees_techniques.tax_su_heber_log_nb_tot1 as "'.__("tax_su_heber_log_nb_tot1").'"', 'donnees_techniques.tax_su_heber_log_nb_tot2 as "'.__("tax_su_heber_log_nb_tot2").'"', 'donnees_techniques.tax_su_heber_log_nb_tot3 as "'.__("tax_su_heber_log_nb_tot3").'"', 'donnees_techniques.tax_su_heber_surf1 as "'.__("tax_su_heber_surf1").'"', 'donnees_techniques.tax_su_heber_surf2 as "'.__("tax_su_heber_surf2").'"', 'donnees_techniques.tax_su_heber_surf3 as "'.__("tax_su_heber_surf3").'"', 'donnees_techniques.tax_su_heber_surf_sup1 as "'.__("tax_su_heber_surf_sup1").'"', 'donnees_techniques.tax_su_heber_surf_sup2 as "'.__("tax_su_heber_surf_sup2").'"', 'donnees_techniques.tax_su_heber_surf_sup3 as "'.__("tax_su_heber_surf_sup3").'"', 'donnees_techniques.tax_su_secon_log_nb as "'.__("tax_su_secon_log_nb").'"', 'donnees_techniques.tax_su_tot_log_nb as "'.__("tax_su_tot_log_nb").'"', 'donnees_techniques.tax_su_secon_log_nb_tot as "'.__("tax_su_secon_log_nb_tot").'"', 'donnees_techniques.tax_su_tot_log_nb_tot as "'.__("tax_su_tot_log_nb_tot").'"', 'donnees_techniques.tax_su_secon_surf as "'.__("tax_su_secon_surf").'"', 'donnees_techniques.tax_su_tot_surf as "'.__("tax_su_tot_surf").'"', 'donnees_techniques.tax_su_secon_surf_sup as "'.__("tax_su_secon_surf_sup").'"', 'donnees_techniques.tax_su_tot_surf_sup as "'.__("tax_su_tot_surf_sup").'"', 'donnees_techniques.tax_surf_tax_exist_cons as "'.__("tax_surf_tax_exist_cons").'"', 'donnees_techniques.tax_log_exist_nb as "'.__("tax_log_exist_nb").'"', 'donnees_techniques.tax_am_statio_ext as "'.__("tax_am_statio_ext").'"', 'donnees_techniques.tax_sup_bass_pisc as "'.__("tax_sup_bass_pisc").'"', 'donnees_techniques.tax_empl_ten_carav_mobil_nb as "'.__("tax_empl_ten_carav_mobil_nb").'"', 'donnees_techniques.tax_empl_hll_nb as "'.__("tax_empl_hll_nb").'"', 'donnees_techniques.tax_eol_haut_nb as "'.__("tax_eol_haut_nb").'"', 'donnees_techniques.tax_pann_volt_sup as "'.__("tax_pann_volt_sup").'"', 'donnees_techniques.tax_am_statio_ext_sup as "'.__("tax_am_statio_ext_sup").'"', 'donnees_techniques.tax_sup_bass_pisc_sup as "'.__("tax_sup_bass_pisc_sup").'"', 'donnees_techniques.tax_empl_ten_carav_mobil_nb_sup as "'.__("tax_empl_ten_carav_mobil_nb_sup").'"', 'donnees_techniques.tax_empl_hll_nb_sup as "'.__("tax_empl_hll_nb_sup").'"', 'donnees_techniques.tax_eol_haut_nb_sup as "'.__("tax_eol_haut_nb_sup").'"', 'donnees_techniques.tax_pann_volt_sup_sup as "'.__("tax_pann_volt_sup_sup").'"', 'donnees_techniques.tax_comm_nb as "'.__("tax_comm_nb").'"', 'donnees_techniques.tax_su_non_habit_surf1 as "'.__("tax_su_non_habit_surf1").'"', 'donnees_techniques.tax_su_non_habit_surf2 as "'.__("tax_su_non_habit_surf2").'"', 'donnees_techniques.tax_su_non_habit_surf3 as "'.__("tax_su_non_habit_surf3").'"', 'donnees_techniques.tax_su_non_habit_surf4 as "'.__("tax_su_non_habit_surf4").'"', 'donnees_techniques.tax_su_non_habit_surf5 as "'.__("tax_su_non_habit_surf5").'"', 'donnees_techniques.tax_su_non_habit_surf6 as "'.__("tax_su_non_habit_surf6").'"', 'donnees_techniques.tax_su_non_habit_surf7 as "'.__("tax_su_non_habit_surf7").'"', 'donnees_techniques.tax_su_non_habit_surf_sup1 as "'.__("tax_su_non_habit_surf_sup1").'"', 'donnees_techniques.tax_su_non_habit_surf_sup2 as "'.__("tax_su_non_habit_surf_sup2").'"', 'donnees_techniques.tax_su_non_habit_surf_sup3 as "'.__("tax_su_non_habit_surf_sup3").'"', 'donnees_techniques.tax_su_non_habit_surf_sup4 as "'.__("tax_su_non_habit_surf_sup4").'"', 'donnees_techniques.tax_su_non_habit_surf_sup5 as "'.__("tax_su_non_habit_surf_sup5").'"', 'donnees_techniques.tax_su_non_habit_surf_sup6 as "'.__("tax_su_non_habit_surf_sup6").'"', 'donnees_techniques.tax_su_non_habit_surf_sup7 as "'.__("tax_su_non_habit_surf_sup7").'"', 'donnees_techniques.vsd_unit_fonc_sup as "'.__("vsd_unit_fonc_sup").'"', 'donnees_techniques.vsd_unit_fonc_constr_sup as "'.__("vsd_unit_fonc_constr_sup").'"', 'donnees_techniques.vsd_val_terr as "'.__("vsd_val_terr").'"', 'donnees_techniques.vsd_const_sxist_non_dem_surf as "'.__("vsd_const_sxist_non_dem_surf").'"', 'donnees_techniques.pld_val_terr as "'.__("pld_val_terr").'"', 'donnees_techniques.pld_const_exist_dem_surf as "'.__("pld_const_exist_dem_surf").'"', 'donnees_techniques.terr_juri_titul as "'.__("terr_juri_titul").'"', 'donnees_techniques.terr_juri_lot as "'.__("terr_juri_lot").'"', 'donnees_techniques.terr_juri_zac as "'.__("terr_juri_zac").'"', 'donnees_techniques.terr_juri_afu as "'.__("terr_juri_afu").'"', 'donnees_techniques.terr_juri_pup as "'.__("terr_juri_pup").'"', 'donnees_techniques.terr_juri_oin as "'.__("terr_juri_oin").'"', 'donnees_techniques.terr_div_surf_etab as "'.__("terr_div_surf_etab").'"', 'donnees_techniques.terr_div_surf_av_div as "'.__("terr_div_surf_av_div").'"', 'donnees_techniques.doc_surf as "'.__("doc_surf").'"', 'donnees_techniques.doc_nb_log as "'.__("doc_nb_log").'"', 'donnees_techniques.doc_nb_log_indiv as "'.__("doc_nb_log_indiv").'"', 'donnees_techniques.doc_nb_log_coll as "'.__("doc_nb_log_coll").'"', 'donnees_techniques.doc_nb_log_lls as "'.__("doc_nb_log_lls").'"', 'donnees_techniques.doc_nb_log_aa as "'.__("doc_nb_log_aa").'"', 'donnees_techniques.doc_nb_log_ptz as "'.__("doc_nb_log_ptz").'"', 'donnees_techniques.doc_nb_log_autre as "'.__("doc_nb_log_autre").'"', 'donnees_techniques.daact_surf as "'.__("daact_surf").'"', 'donnees_techniques.daact_nb_log as "'.__("daact_nb_log").'"', 'donnees_techniques.daact_nb_log_indiv as "'.__("daact_nb_log_indiv").'"', 'donnees_techniques.daact_nb_log_coll as "'.__("daact_nb_log_coll").'"', 'donnees_techniques.daact_nb_log_lls as "'.__("daact_nb_log_lls").'"', 'donnees_techniques.daact_nb_log_aa as "'.__("daact_nb_log_aa").'"', 'donnees_techniques.daact_nb_log_ptz as "'.__("daact_nb_log_ptz").'"', 'donnees_techniques.daact_nb_log_autre as "'.__("daact_nb_log_autre").'"', 'dossier_autorisation.dossier_autorisation_type_detaille as "'.__("dossier_autorisation").'"', 'donnees_techniques.co_perf_energ as "'.__("co_perf_energ").'"', 'architecte.nom as "'.__("architecte").'"', 'donnees_techniques.co_statio_avt_shob as "'.__("co_statio_avt_shob").'"', 'donnees_techniques.co_statio_apr_shob as "'.__("co_statio_apr_shob").'"', 'donnees_techniques.co_statio_avt_surf as "'.__("co_statio_avt_surf").'"', 'donnees_techniques.co_statio_apr_surf as "'.__("co_statio_apr_surf").'"', 'donnees_techniques.co_trx_amgt as "'.__("co_trx_amgt").'"', 'donnees_techniques.co_modif_aspect as "'.__("co_modif_aspect").'"', 'donnees_techniques.co_modif_struct as "'.__("co_modif_struct").'"', 'donnees_techniques.co_trx_imm as "'.__("co_trx_imm").'"', 'donnees_techniques.co_cstr_shob as "'.__("co_cstr_shob").'"', 'donnees_techniques.am_voyage_deb as "'.__("am_voyage_deb").'"', 'donnees_techniques.am_voyage_fin as "'.__("am_voyage_fin").'"', 'donnees_techniques.am_modif_amgt as "'.__("am_modif_amgt").'"', 'donnees_techniques.am_lot_max_shob as "'.__("am_lot_max_shob").'"', 'donnees_techniques.mod_desc as "'.__("mod_desc").'"', 'donnees_techniques.tr_total as "'.__("tr_total").'"', 'donnees_techniques.tr_partiel as "'.__("tr_partiel").'"', 'donnees_techniques.tr_desc as "'.__("tr_desc").'"', 'donnees_techniques.avap_co_clot as "'.__("avap_co_clot").'"', 'donnees_techniques.avap_aut_coup_aba_arb as "'.__("avap_aut_coup_aba_arb").'"', 'donnees_techniques.avap_ouv_infra as "'.__("avap_ouv_infra").'"', 'donnees_techniques.avap_aut_inst_mob as "'.__("avap_aut_inst_mob").'"', 'donnees_techniques.avap_aut_plant as "'.__("avap_aut_plant").'"', 'donnees_techniques.avap_aut_auv_elec as "'.__("avap_aut_auv_elec").'"', 'donnees_techniques.tax_dest_loc_tr as "'.__("tax_dest_loc_tr").'"', 'donnees_techniques.tax_surf_tot_cstr as "'.__("tax_surf_tot_cstr").'"', 'donnees_techniques.cerfa as "'.__("cerfa").'"', 'donnees_techniques.tax_surf_loc_stat as "'.__("tax_surf_loc_stat").'"', 'donnees_techniques.tax_su_princ_surf_stat1 as "'.__("tax_su_princ_surf_stat1").'"', 'donnees_techniques.tax_su_princ_surf_stat2 as "'.__("tax_su_princ_surf_stat2").'"', 'donnees_techniques.tax_su_princ_surf_stat3 as "'.__("tax_su_princ_surf_stat3").'"', 'donnees_techniques.tax_su_princ_surf_stat4 as "'.__("tax_su_princ_surf_stat4").'"', 'donnees_techniques.tax_su_secon_surf_stat as "'.__("tax_su_secon_surf_stat").'"', 'donnees_techniques.tax_su_heber_surf_stat1 as "'.__("tax_su_heber_surf_stat1").'"', 'donnees_techniques.tax_su_heber_surf_stat2 as "'.__("tax_su_heber_surf_stat2").'"', 'donnees_techniques.tax_su_heber_surf_stat3 as "'.__("tax_su_heber_surf_stat3").'"', 'donnees_techniques.tax_su_tot_surf_stat as "'.__("tax_su_tot_surf_stat").'"', 'donnees_techniques.tax_su_non_habit_surf_stat1 as "'.__("tax_su_non_habit_surf_stat1").'"', 'donnees_techniques.tax_su_non_habit_surf_stat2 as "'.__("tax_su_non_habit_surf_stat2").'"', 'donnees_techniques.tax_su_non_habit_surf_stat3 as "'.__("tax_su_non_habit_surf_stat3").'"', 'donnees_techniques.tax_su_non_habit_surf_stat4 as "'.__("tax_su_non_habit_surf_stat4").'"', 'donnees_techniques.tax_su_non_habit_surf_stat5 as "'.__("tax_su_non_habit_surf_stat5").'"', 'donnees_techniques.tax_su_non_habit_surf_stat6 as "'.__("tax_su_non_habit_surf_stat6").'"', 'donnees_techniques.tax_su_non_habit_surf_stat7 as "'.__("tax_su_non_habit_surf_stat7").'"', 'donnees_techniques.tax_su_parc_statio_expl_comm_surf as "'.__("tax_su_parc_statio_expl_comm_surf").'"', 'donnees_techniques.tax_log_ap_trvx_nb as "'.__("tax_log_ap_trvx_nb").'"', 'donnees_techniques.tax_am_statio_ext_cr as "'.__("tax_am_statio_ext_cr").'"', 'donnees_techniques.tax_sup_bass_pisc_cr as "'.__("tax_sup_bass_pisc_cr").'"', 'donnees_techniques.tax_empl_ten_carav_mobil_nb_cr as "'.__("tax_empl_ten_carav_mobil_nb_cr").'"', 'donnees_techniques.tax_empl_hll_nb_cr as "'.__("tax_empl_hll_nb_cr").'"', 'donnees_techniques.tax_eol_haut_nb_cr as "'.__("tax_eol_haut_nb_cr").'"', 'donnees_techniques.tax_pann_volt_sup_cr as "'.__("tax_pann_volt_sup_cr").'"', 'donnees_techniques.tax_surf_loc_arch as "'.__("tax_surf_loc_arch").'"', 'donnees_techniques.tax_surf_pisc_arch as "'.__("tax_surf_pisc_arch").'"', 'donnees_techniques.tax_am_statio_ext_arch as "'.__("tax_am_statio_ext_arch").'"', 'donnees_techniques.tax_empl_ten_carav_mobil_nb_arch as "'.__("tax_empl_ten_carav_mobil_nb_arch").'"', 'donnees_techniques.tax_empl_hll_nb_arch as "'.__("tax_empl_hll_nb_arch").'"', 'donnees_techniques.tax_eol_haut_nb_arch as "'.__("tax_eol_haut_nb_arch").'"', 'donnees_techniques.erp_loc_eff1 as "'.__("erp_loc_eff1").'"', 'donnees_techniques.erp_loc_eff2 as "'.__("erp_loc_eff2").'"', 'donnees_techniques.erp_loc_eff3 as "'.__("erp_loc_eff3").'"', 'donnees_techniques.erp_loc_eff4 as "'.__("erp_loc_eff4").'"', 'donnees_techniques.erp_loc_eff5 as "'.__("erp_loc_eff5").'"', 'donnees_techniques.erp_loc_eff_tot as "'.__("erp_loc_eff_tot").'"', 'donnees_techniques.erp_public_eff1 as "'.__("erp_public_eff1").'"', 'donnees_techniques.erp_public_eff2 as "'.__("erp_public_eff2").'"', 'donnees_techniques.erp_public_eff3 as "'.__("erp_public_eff3").'"', 'donnees_techniques.erp_public_eff4 as "'.__("erp_public_eff4").'"', 'donnees_techniques.erp_public_eff5 as "'.__("erp_public_eff5").'"', 'donnees_techniques.erp_public_eff_tot as "'.__("erp_public_eff_tot").'"', 'donnees_techniques.erp_perso_eff1 as "'.__("erp_perso_eff1").'"', 'donnees_techniques.erp_perso_eff2 as "'.__("erp_perso_eff2").'"', 'donnees_techniques.erp_perso_eff3 as "'.__("erp_perso_eff3").'"', 'donnees_techniques.erp_perso_eff4 as "'.__("erp_perso_eff4").'"', 'donnees_techniques.erp_perso_eff5 as "'.__("erp_perso_eff5").'"', 'donnees_techniques.erp_perso_eff_tot as "'.__("erp_perso_eff_tot").'"', 'donnees_techniques.erp_tot_eff1 as "'.__("erp_tot_eff1").'"', 'donnees_techniques.erp_tot_eff2 as "'.__("erp_tot_eff2").'"', 'donnees_techniques.erp_tot_eff3 as "'.__("erp_tot_eff3").'"', 'donnees_techniques.erp_tot_eff4 as "'.__("erp_tot_eff4").'"', 'donnees_techniques.erp_tot_eff5 as "'.__("erp_tot_eff5").'"', 'donnees_techniques.erp_tot_eff_tot as "'.__("erp_tot_eff_tot").'"', 'donnees_techniques.erp_class_cat as "'.__("erp_class_cat").'"', 'donnees_techniques.erp_class_type as "'.__("erp_class_type").'"', 'donnees_techniques.tax_surf_abr_jard_pig_colom as "'.__("tax_surf_abr_jard_pig_colom").'"', 'donnees_techniques.tax_su_non_habit_abr_jard_pig_colom as "'.__("tax_su_non_habit_abr_jard_pig_colom").'"', 'donnees_techniques.dia_mod_cess_prix_vente as "'.__("dia_mod_cess_prix_vente").'"', 'donnees_techniques.dia_mod_cess_prix_vente_mob as "'.__("dia_mod_cess_prix_vente_mob").'"', 'donnees_techniques.dia_mod_cess_prix_vente_cheptel as "'.__("dia_mod_cess_prix_vente_cheptel").'"', 'donnees_techniques.dia_mod_cess_prix_vente_recol as "'.__("dia_mod_cess_prix_vente_recol").'"', 'donnees_techniques.dia_mod_cess_prix_vente_autre as "'.__("dia_mod_cess_prix_vente_autre").'"', 'donnees_techniques.dia_mod_cess_commi_ttc as "'.__("dia_mod_cess_commi_ttc").'"', 'donnees_techniques.dia_mod_cess_commi_ht as "'.__("dia_mod_cess_commi_ht").'"', 'donnees_techniques.dia_acquereur_nom_prenom as "'.__("dia_acquereur_nom_prenom").'"', 'donnees_techniques.dia_acquereur_adr_num_voie as "'.__("dia_acquereur_adr_num_voie").'"', 'donnees_techniques.dia_acquereur_adr_ext as "'.__("dia_acquereur_adr_ext").'"', 'donnees_techniques.dia_acquereur_adr_type_voie as "'.__("dia_acquereur_adr_type_voie").'"', 'donnees_techniques.dia_acquereur_adr_nom_voie as "'.__("dia_acquereur_adr_nom_voie").'"', 'donnees_techniques.dia_acquereur_adr_lieu_dit_bp as "'.__("dia_acquereur_adr_lieu_dit_bp").'"', 'donnees_techniques.dia_acquereur_adr_cp as "'.__("dia_acquereur_adr_cp").'"', 'donnees_techniques.dia_acquereur_adr_localite as "'.__("dia_acquereur_adr_localite").'"', 'donnees_techniques.su2_avt_shon1 as "'.__("su2_avt_shon1").'"', 'donnees_techniques.su2_avt_shon2 as "'.__("su2_avt_shon2").'"', 'donnees_techniques.su2_avt_shon3 as "'.__("su2_avt_shon3").'"', 'donnees_techniques.su2_avt_shon4 as "'.__("su2_avt_shon4").'"', 'donnees_techniques.su2_avt_shon5 as "'.__("su2_avt_shon5").'"', 'donnees_techniques.su2_avt_shon6 as "'.__("su2_avt_shon6").'"', 'donnees_techniques.su2_avt_shon7 as "'.__("su2_avt_shon7").'"', 'donnees_techniques.su2_avt_shon8 as "'.__("su2_avt_shon8").'"', 'donnees_techniques.su2_avt_shon9 as "'.__("su2_avt_shon9").'"', 'donnees_techniques.su2_avt_shon10 as "'.__("su2_avt_shon10").'"', 'donnees_techniques.su2_avt_shon11 as "'.__("su2_avt_shon11").'"', 'donnees_techniques.su2_avt_shon12 as "'.__("su2_avt_shon12").'"', 'donnees_techniques.su2_avt_shon13 as "'.__("su2_avt_shon13").'"', 'donnees_techniques.su2_avt_shon14 as "'.__("su2_avt_shon14").'"', 'donnees_techniques.su2_avt_shon15 as "'.__("su2_avt_shon15").'"', 'donnees_techniques.su2_avt_shon16 as "'.__("su2_avt_shon16").'"', 'donnees_techniques.su2_avt_shon17 as "'.__("su2_avt_shon17").'"', 'donnees_techniques.su2_avt_shon18 as "'.__("su2_avt_shon18").'"', 'donnees_techniques.su2_avt_shon19 as "'.__("su2_avt_shon19").'"', 'donnees_techniques.su2_avt_shon20 as "'.__("su2_avt_shon20").'"', 'donnees_techniques.su2_avt_shon_tot as "'.__("su2_avt_shon_tot").'"', 'donnees_techniques.su2_cstr_shon1 as "'.__("su2_cstr_shon1").'"', 'donnees_techniques.su2_cstr_shon2 as "'.__("su2_cstr_shon2").'"', 'donnees_techniques.su2_cstr_shon3 as "'.__("su2_cstr_shon3").'"', 'donnees_techniques.su2_cstr_shon4 as "'.__("su2_cstr_shon4").'"', 'donnees_techniques.su2_cstr_shon5 as "'.__("su2_cstr_shon5").'"', 'donnees_techniques.su2_cstr_shon6 as "'.__("su2_cstr_shon6").'"', 'donnees_techniques.su2_cstr_shon7 as "'.__("su2_cstr_shon7").'"', 'donnees_techniques.su2_cstr_shon8 as "'.__("su2_cstr_shon8").'"', 'donnees_techniques.su2_cstr_shon9 as "'.__("su2_cstr_shon9").'"', 'donnees_techniques.su2_cstr_shon10 as "'.__("su2_cstr_shon10").'"', 'donnees_techniques.su2_cstr_shon11 as "'.__("su2_cstr_shon11").'"', 'donnees_techniques.su2_cstr_shon12 as "'.__("su2_cstr_shon12").'"', 'donnees_techniques.su2_cstr_shon13 as "'.__("su2_cstr_shon13").'"', 'donnees_techniques.su2_cstr_shon14 as "'.__("su2_cstr_shon14").'"', 'donnees_techniques.su2_cstr_shon15 as "'.__("su2_cstr_shon15").'"', 'donnees_techniques.su2_cstr_shon16 as "'.__("su2_cstr_shon16").'"', 'donnees_techniques.su2_cstr_shon17 as "'.__("su2_cstr_shon17").'"', 'donnees_techniques.su2_cstr_shon18 as "'.__("su2_cstr_shon18").'"', 'donnees_techniques.su2_cstr_shon19 as "'.__("su2_cstr_shon19").'"', 'donnees_techniques.su2_cstr_shon20 as "'.__("su2_cstr_shon20").'"', 'donnees_techniques.su2_cstr_shon_tot as "'.__("su2_cstr_shon_tot").'"', 'donnees_techniques.su2_chge_shon1 as "'.__("su2_chge_shon1").'"', 'donnees_techniques.su2_chge_shon2 as "'.__("su2_chge_shon2").'"', 'donnees_techniques.su2_chge_shon3 as "'.__("su2_chge_shon3").'"', 'donnees_techniques.su2_chge_shon4 as "'.__("su2_chge_shon4").'"', 'donnees_techniques.su2_chge_shon5 as "'.__("su2_chge_shon5").'"', 'donnees_techniques.su2_chge_shon6 as "'.__("su2_chge_shon6").'"', 'donnees_techniques.su2_chge_shon7 as "'.__("su2_chge_shon7").'"', 'donnees_techniques.su2_chge_shon8 as "'.__("su2_chge_shon8").'"', 'donnees_techniques.su2_chge_shon9 as "'.__("su2_chge_shon9").'"', 'donnees_techniques.su2_chge_shon10 as "'.__("su2_chge_shon10").'"', 'donnees_techniques.su2_chge_shon11 as "'.__("su2_chge_shon11").'"', 'donnees_techniques.su2_chge_shon12 as "'.__("su2_chge_shon12").'"', 'donnees_techniques.su2_chge_shon13 as "'.__("su2_chge_shon13").'"', 'donnees_techniques.su2_chge_shon14 as "'.__("su2_chge_shon14").'"', 'donnees_techniques.su2_chge_shon15 as "'.__("su2_chge_shon15").'"', 'donnees_techniques.su2_chge_shon16 as "'.__("su2_chge_shon16").'"', 'donnees_techniques.su2_chge_shon17 as "'.__("su2_chge_shon17").'"', 'donnees_techniques.su2_chge_shon18 as "'.__("su2_chge_shon18").'"', 'donnees_techniques.su2_chge_shon19 as "'.__("su2_chge_shon19").'"', 'donnees_techniques.su2_chge_shon20 as "'.__("su2_chge_shon20").'"', 'donnees_techniques.su2_chge_shon_tot as "'.__("su2_chge_shon_tot").'"', 'donnees_techniques.su2_demo_shon1 as "'.__("su2_demo_shon1").'"', 'donnees_techniques.su2_demo_shon2 as "'.__("su2_demo_shon2").'"', 'donnees_techniques.su2_demo_shon3 as "'.__("su2_demo_shon3").'"', 'donnees_techniques.su2_demo_shon4 as "'.__("su2_demo_shon4").'"', 'donnees_techniques.su2_demo_shon5 as "'.__("su2_demo_shon5").'"', 'donnees_techniques.su2_demo_shon6 as "'.__("su2_demo_shon6").'"', 'donnees_techniques.su2_demo_shon7 as "'.__("su2_demo_shon7").'"', 'donnees_techniques.su2_demo_shon8 as "'.__("su2_demo_shon8").'"', 'donnees_techniques.su2_demo_shon9 as "'.__("su2_demo_shon9").'"', 'donnees_techniques.su2_demo_shon10 as "'.__("su2_demo_shon10").'"', 'donnees_techniques.su2_demo_shon11 as "'.__("su2_demo_shon11").'"', 'donnees_techniques.su2_demo_shon12 as "'.__("su2_demo_shon12").'"', 'donnees_techniques.su2_demo_shon13 as "'.__("su2_demo_shon13").'"', 'donnees_techniques.su2_demo_shon14 as "'.__("su2_demo_shon14").'"', 'donnees_techniques.su2_demo_shon15 as "'.__("su2_demo_shon15").'"', 'donnees_techniques.su2_demo_shon16 as "'.__("su2_demo_shon16").'"', 'donnees_techniques.su2_demo_shon17 as "'.__("su2_demo_shon17").'"', 'donnees_techniques.su2_demo_shon18 as "'.__("su2_demo_shon18").'"', 'donnees_techniques.su2_demo_shon19 as "'.__("su2_demo_shon19").'"', 'donnees_techniques.su2_demo_shon20 as "'.__("su2_demo_shon20").'"', 'donnees_techniques.su2_demo_shon_tot as "'.__("su2_demo_shon_tot").'"', 'donnees_techniques.su2_sup_shon1 as "'.__("su2_sup_shon1").'"', 'donnees_techniques.su2_sup_shon2 as "'.__("su2_sup_shon2").'"', 'donnees_techniques.su2_sup_shon3 as "'.__("su2_sup_shon3").'"', 'donnees_techniques.su2_sup_shon4 as "'.__("su2_sup_shon4").'"', 'donnees_techniques.su2_sup_shon5 as "'.__("su2_sup_shon5").'"', 'donnees_techniques.su2_sup_shon6 as "'.__("su2_sup_shon6").'"', 'donnees_techniques.su2_sup_shon7 as "'.__("su2_sup_shon7").'"', 'donnees_techniques.su2_sup_shon8 as "'.__("su2_sup_shon8").'"', 'donnees_techniques.su2_sup_shon9 as "'.__("su2_sup_shon9").'"', 'donnees_techniques.su2_sup_shon10 as "'.__("su2_sup_shon10").'"', 'donnees_techniques.su2_sup_shon11 as "'.__("su2_sup_shon11").'"', 'donnees_techniques.su2_sup_shon12 as "'.__("su2_sup_shon12").'"', 'donnees_techniques.su2_sup_shon13 as "'.__("su2_sup_shon13").'"', 'donnees_techniques.su2_sup_shon14 as "'.__("su2_sup_shon14").'"', 'donnees_techniques.su2_sup_shon15 as "'.__("su2_sup_shon15").'"', 'donnees_techniques.su2_sup_shon16 as "'.__("su2_sup_shon16").'"', 'donnees_techniques.su2_sup_shon17 as "'.__("su2_sup_shon17").'"', 'donnees_techniques.su2_sup_shon18 as "'.__("su2_sup_shon18").'"', 'donnees_techniques.su2_sup_shon19 as "'.__("su2_sup_shon19").'"', 'donnees_techniques.su2_sup_shon20 as "'.__("su2_sup_shon20").'"', 'donnees_techniques.su2_sup_shon_tot as "'.__("su2_sup_shon_tot").'"', 'donnees_techniques.su2_tot_shon1 as "'.__("su2_tot_shon1").'"', 'donnees_techniques.su2_tot_shon2 as "'.__("su2_tot_shon2").'"', 'donnees_techniques.su2_tot_shon3 as "'.__("su2_tot_shon3").'"', 'donnees_techniques.su2_tot_shon4 as "'.__("su2_tot_shon4").'"', 'donnees_techniques.su2_tot_shon5 as "'.__("su2_tot_shon5").'"', 'donnees_techniques.su2_tot_shon6 as "'.__("su2_tot_shon6").'"', 'donnees_techniques.su2_tot_shon7 as "'.__("su2_tot_shon7").'"', 'donnees_techniques.su2_tot_shon8 as "'.__("su2_tot_shon8").'"', 'donnees_techniques.su2_tot_shon9 as "'.__("su2_tot_shon9").'"', 'donnees_techniques.su2_tot_shon10 as "'.__("su2_tot_shon10").'"', 'donnees_techniques.su2_tot_shon11 as "'.__("su2_tot_shon11").'"', 'donnees_techniques.su2_tot_shon12 as "'.__("su2_tot_shon12").'"', 'donnees_techniques.su2_tot_shon13 as "'.__("su2_tot_shon13").'"', 'donnees_techniques.su2_tot_shon14 as "'.__("su2_tot_shon14").'"', 'donnees_techniques.su2_tot_shon15 as "'.__("su2_tot_shon15").'"', 'donnees_techniques.su2_tot_shon16 as "'.__("su2_tot_shon16").'"', 'donnees_techniques.su2_tot_shon17 as "'.__("su2_tot_shon17").'"', 'donnees_techniques.su2_tot_shon18 as "'.__("su2_tot_shon18").'"', 'donnees_techniques.su2_tot_shon19 as "'.__("su2_tot_shon19").'"', 'donnees_techniques.su2_tot_shon20 as "'.__("su2_tot_shon20").'"', 'donnees_techniques.su2_tot_shon_tot as "'.__("su2_tot_shon_tot").'"', 'objet_recours.libelle as "'.__("ctx_objet_recours").'"', 'donnees_techniques.ctx_reference_sagace as "'.__("ctx_reference_sagace").'"', 'donnees_techniques.ctx_reference_parquet as "'.__("ctx_reference_parquet").'"', 'donnees_techniques.ctx_element_taxation as "'.__("ctx_element_taxation").'"', 'donnees_techniques.ctx_reference_courrier as "'.__("ctx_reference_courrier").'"', 'donnees_techniques.mtn_exo_ta_part_commu as "'.__("mtn_exo_ta_part_commu").'"', 'donnees_techniques.mtn_exo_ta_part_depart as "'.__("mtn_exo_ta_part_depart").'"', 'donnees_techniques.mtn_exo_ta_part_reg as "'.__("mtn_exo_ta_part_reg").'"', 'donnees_techniques.mtn_exo_rap as "'.__("mtn_exo_rap").'"', 'donnees_techniques.dpc_type as "'.__("dpc_type").'"', 'donnees_techniques.ctx_reference_dsj as "'.__("ctx_reference_dsj").'"', 'donnees_techniques.dia_ss_lieu as "'.__("dia_ss_lieu").'"', 'donnees_techniques.enga_decla_lieu as "'.__("enga_decla_lieu").'"', 'donnees_techniques.co_bat_niv_dessous_nb as "'.__("co_bat_niv_dessous_nb").'"', 'donnees_techniques.tax_surf_tot_demo as "'.__("tax_surf_tot_demo").'"', 'donnees_techniques.tax_surf_tax_demo as "'.__("tax_surf_tax_demo").'"', 'donnees_techniques.tax_su_non_habit_surf8 as "'.__("tax_su_non_habit_surf8").'"', 'donnees_techniques.tax_su_non_habit_surf_stat8 as "'.__("tax_su_non_habit_surf_stat8").'"', 'donnees_techniques.tax_su_non_habit_surf9 as "'.__("tax_su_non_habit_surf9").'"', 'donnees_techniques.tax_su_non_habit_surf_stat9 as "'.__("tax_su_non_habit_surf_stat9").'"', 'donnees_techniques.tax_adresse_future_numero as "'.__("tax_adresse_future_numero").'"', 'donnees_techniques.tax_adresse_future_voie as "'.__("tax_adresse_future_voie").'"', 'donnees_techniques.tax_adresse_future_lieudit as "'.__("tax_adresse_future_lieudit").'"', 'donnees_techniques.tax_adresse_future_localite as "'.__("tax_adresse_future_localite").'"', 'donnees_techniques.tax_adresse_future_cp as "'.__("tax_adresse_future_cp").'"', 'donnees_techniques.tax_adresse_future_bp as "'.__("tax_adresse_future_bp").'"', 'donnees_techniques.tax_adresse_future_cedex as "'.__("tax_adresse_future_cedex").'"', 'donnees_techniques.tax_adresse_future_pays as "'.__("tax_adresse_future_pays").'"', 'donnees_techniques.tax_adresse_future_division as "'.__("tax_adresse_future_division").'"', 'donnees_techniques.erp_trvx_adap_numero as "'.__("erp_trvx_adap_numero").'"', 'donnees_techniques.co_trav_supp_dessus as "'.__("co_trav_supp_dessus").'"', 'donnees_techniques.co_trav_supp_dessous as "'.__("co_trav_supp_dessous").'"', 'donnees_techniques.tax_su_habit_abr_jard_pig_colom as "'.__("tax_su_habit_abr_jard_pig_colom").'"', ); $tri="ORDER BY dossier.annee ASC NULLS LAST"; $edition="donnees_techniques"; /** * Gestion de la clause WHERE => $selection */ // Filtre listing standard $selection = ""; // Liste des clés étrangères avec leurs éventuelles surcharges $foreign_keys_extended = array( "architecte" => array("architecte", ), "objet_recours" => array("objet_recours", ), "dossier_autorisation" => array("dossier_autorisation", ), "dossier" => array("dossier", "dossier_instruction", "dossier_instruction_mes_encours", "dossier_instruction_tous_encours", "dossier_instruction_mes_clotures", "dossier_instruction_tous_clotures", "dossier_contentieux", "dossier_contentieux_mes_infractions", "dossier_contentieux_toutes_infractions", "dossier_contentieux_mes_recours", "dossier_contentieux_tous_recours", ), "lot" => array("lot", ), ); // Filtre listing sous formulaire - architecte if (in_array($retourformulaire, $foreign_keys_extended["architecte"])) { $selection = " WHERE (donnees_techniques.architecte = ".intval($idxformulaire).") "; } // Filtre listing sous formulaire - objet_recours if (in_array($retourformulaire, $foreign_keys_extended["objet_recours"])) { $selection = " WHERE (donnees_techniques.ctx_objet_recours = ".intval($idxformulaire).") "; } // Filtre listing sous formulaire - dossier_autorisation if (in_array($retourformulaire, $foreign_keys_extended["dossier_autorisation"])) { $selection = " WHERE (donnees_techniques.dossier_autorisation = '".$f->db->escapeSimple($idxformulaire)."') "; } // Filtre listing sous formulaire - dossier if (in_array($retourformulaire, $foreign_keys_extended["dossier"])) { $selection = " WHERE (donnees_techniques.dossier_instruction = '".$f->db->escapeSimple($idxformulaire)."') "; } // Filtre listing sous formulaire - lot if (in_array($retourformulaire, $foreign_keys_extended["lot"])) { $selection = " WHERE (donnees_techniques.lot = ".intval($idxformulaire).") "; } /** * Gestion SOUSFORMULAIRE => $sousformulaire */ $sousformulaire = array( 'lien_donnees_techniques_moyen_retenu_juge', 'lien_donnees_techniques_moyen_souleve', );