"._("donnees_techniques"); if(!isset($premier)) $premier=''; if(!isset($recherche1)) $recherche1=''; if(!isset($tricolsf)) $tricolsf=''; if(!isset($premiersf)) $premiersf=''; if(!isset($selection)) $selection=''; if(!isset($retourformulaire)) $retourformulaire=''; if (isset($idx) && $idx != ']' && trim($idx) != '') { $ent .= "-> ".$idx." "; } if (isset($idz) && trim($idz) != '') { $ent .= " ".strtoupper($idz)." "; } // FROM $table = DB_PREFIXE."donnees_techniques LEFT JOIN ".DB_PREFIXE."architecte ON donnees_techniques.architecte=architecte.architecte 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")."\"", 'to_char(donnees_techniques.am_exist_date ,\'DD/MM/YYYY\') 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")."\"", ); // $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").'"', ); // $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_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").'"', ); $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", ), "dossier_autorisation" => array("dossier_autorisation", ), "dossier" => array("dossier", ), "lot" => array("lot", ), ); // Filtre listing sous formulaire - architecte if (in_array($retourformulaire, $foreign_keys_extended["architecte"])) { $selection = " WHERE (donnees_techniques.architecte = '".$idx."') "; } // Filtre listing sous formulaire - dossier_autorisation if (in_array($retourformulaire, $foreign_keys_extended["dossier_autorisation"])) { $selection = " WHERE (donnees_techniques.dossier_autorisation = '".$idx."') "; } // Filtre listing sous formulaire - dossier if (in_array($retourformulaire, $foreign_keys_extended["dossier"])) { $selection = " WHERE (donnees_techniques.dossier_instruction = '".$idx."') "; } // Filtre listing sous formulaire - lot if (in_array($retourformulaire, $foreign_keys_extended["lot"])) { $selection = " WHERE (donnees_techniques.lot = '".$idx."') "; } ?>