"._("cerfa"); $om_validite = true; 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."cerfa"; // SELECT $champAffiche = array( 'cerfa.cerfa as "'._("cerfa").'"', 'cerfa.libelle as "'._("libelle").'"', 'cerfa.code as "'._("code").'"', 'to_char(cerfa.om_validite_debut ,\'DD/MM/YYYY\') as "'._("om_validite_debut").'"', 'to_char(cerfa.om_validite_fin ,\'DD/MM/YYYY\') as "'._("om_validite_fin").'"', "case cerfa.am_lotiss when 't' then 'Oui' else 'Non' end as \""._("am_lotiss")."\"", "case cerfa.am_autre_div when 't' then 'Oui' else 'Non' end as \""._("am_autre_div")."\"", "case cerfa.am_camping when 't' then 'Oui' else 'Non' end as \""._("am_camping")."\"", "case cerfa.am_caravane when 't' then 'Oui' else 'Non' end as \""._("am_caravane")."\"", "case cerfa.am_carav_duree when 't' then 'Oui' else 'Non' end as \""._("am_carav_duree")."\"", "case cerfa.am_statio when 't' then 'Oui' else 'Non' end as \""._("am_statio")."\"", "case cerfa.am_statio_cont when 't' then 'Oui' else 'Non' end as \""._("am_statio_cont")."\"", "case cerfa.am_affou_exhau when 't' then 'Oui' else 'Non' end as \""._("am_affou_exhau")."\"", "case cerfa.am_affou_exhau_sup when 't' then 'Oui' else 'Non' end as \""._("am_affou_exhau_sup")."\"", "case cerfa.am_affou_prof when 't' then 'Oui' else 'Non' end as \""._("am_affou_prof")."\"", "case cerfa.am_exhau_haut when 't' then 'Oui' else 'Non' end as \""._("am_exhau_haut")."\"", "case cerfa.am_coupe_abat when 't' then 'Oui' else 'Non' end as \""._("am_coupe_abat")."\"", "case cerfa.am_prot_plu when 't' then 'Oui' else 'Non' end as \""._("am_prot_plu")."\"", "case cerfa.am_prot_muni when 't' then 'Oui' else 'Non' end as \""._("am_prot_muni")."\"", "case cerfa.am_mobil_voyage when 't' then 'Oui' else 'Non' end as \""._("am_mobil_voyage")."\"", "case cerfa.am_aire_voyage when 't' then 'Oui' else 'Non' end as \""._("am_aire_voyage")."\"", "case cerfa.am_rememb_afu when 't' then 'Oui' else 'Non' end as \""._("am_rememb_afu")."\"", "case cerfa.am_parc_resid_loi when 't' then 'Oui' else 'Non' end as \""._("am_parc_resid_loi")."\"", "case cerfa.am_sport_moto when 't' then 'Oui' else 'Non' end as \""._("am_sport_moto")."\"", "case cerfa.am_sport_attrac when 't' then 'Oui' else 'Non' end as \""._("am_sport_attrac")."\"", "case cerfa.am_sport_golf when 't' then 'Oui' else 'Non' end as \""._("am_sport_golf")."\"", "case cerfa.am_mob_art when 't' then 'Oui' else 'Non' end as \""._("am_mob_art")."\"", "case cerfa.am_modif_voie_esp when 't' then 'Oui' else 'Non' end as \""._("am_modif_voie_esp")."\"", "case cerfa.am_plant_voie_esp when 't' then 'Oui' else 'Non' end as \""._("am_plant_voie_esp")."\"", "case cerfa.am_chem_ouv_esp when 't' then 'Oui' else 'Non' end as \""._("am_chem_ouv_esp")."\"", "case cerfa.am_agri_peche when 't' then 'Oui' else 'Non' end as \""._("am_agri_peche")."\"", "case cerfa.am_crea_voie when 't' then 'Oui' else 'Non' end as \""._("am_crea_voie")."\"", "case cerfa.am_modif_voie_exist when 't' then 'Oui' else 'Non' end as \""._("am_modif_voie_exist")."\"", "case cerfa.am_crea_esp_sauv when 't' then 'Oui' else 'Non' end as \""._("am_crea_esp_sauv")."\"", "case cerfa.am_crea_esp_class when 't' then 'Oui' else 'Non' end as \""._("am_crea_esp_class")."\"", "case cerfa.am_projet_desc when 't' then 'Oui' else 'Non' end as \""._("am_projet_desc")."\"", "case cerfa.am_terr_surf when 't' then 'Oui' else 'Non' end as \""._("am_terr_surf")."\"", "case cerfa.am_tranche_desc when 't' then 'Oui' else 'Non' end as \""._("am_tranche_desc")."\"", "case cerfa.am_lot_max_nb when 't' then 'Oui' else 'Non' end as \""._("am_lot_max_nb")."\"", "case cerfa.am_lot_max_shon when 't' then 'Oui' else 'Non' end as \""._("am_lot_max_shon")."\"", "case cerfa.am_lot_cstr_cos when 't' then 'Oui' else 'Non' end as \""._("am_lot_cstr_cos")."\"", "case cerfa.am_lot_cstr_plan when 't' then 'Oui' else 'Non' end as \""._("am_lot_cstr_plan")."\"", "case cerfa.am_lot_cstr_vente when 't' then 'Oui' else 'Non' end as \""._("am_lot_cstr_vente")."\"", "case cerfa.am_lot_fin_diff when 't' then 'Oui' else 'Non' end as \""._("am_lot_fin_diff")."\"", "case cerfa.am_lot_consign when 't' then 'Oui' else 'Non' end as \""._("am_lot_consign")."\"", "case cerfa.am_lot_gar_achev when 't' then 'Oui' else 'Non' end as \""._("am_lot_gar_achev")."\"", "case cerfa.am_lot_vente_ant when 't' then 'Oui' else 'Non' end as \""._("am_lot_vente_ant")."\"", "case cerfa.am_empl_nb when 't' then 'Oui' else 'Non' end as \""._("am_empl_nb")."\"", "case cerfa.am_tente_nb when 't' then 'Oui' else 'Non' end as \""._("am_tente_nb")."\"", "case cerfa.am_carav_nb when 't' then 'Oui' else 'Non' end as \""._("am_carav_nb")."\"", "case cerfa.am_mobil_nb when 't' then 'Oui' else 'Non' end as \""._("am_mobil_nb")."\"", "case cerfa.am_pers_nb when 't' then 'Oui' else 'Non' end as \""._("am_pers_nb")."\"", "case cerfa.am_empl_hll_nb when 't' then 'Oui' else 'Non' end as \""._("am_empl_hll_nb")."\"", "case cerfa.am_hll_shon when 't' then 'Oui' else 'Non' end as \""._("am_hll_shon")."\"", "case cerfa.am_periode_exploit when 't' then 'Oui' else 'Non' end as \""._("am_periode_exploit")."\"", "case cerfa.am_exist_agrand when 't' then 'Oui' else 'Non' end as \""._("am_exist_agrand")."\"", "case cerfa.am_exist_date when 't' then 'Oui' else 'Non' end as \""._("am_exist_date")."\"", "case cerfa.am_exist_num when 't' then 'Oui' else 'Non' end as \""._("am_exist_num")."\"", "case cerfa.am_exist_nb_avant when 't' then 'Oui' else 'Non' end as \""._("am_exist_nb_avant")."\"", "case cerfa.am_exist_nb_apres when 't' then 'Oui' else 'Non' end as \""._("am_exist_nb_apres")."\"", "case cerfa.am_coupe_bois when 't' then 'Oui' else 'Non' end as \""._("am_coupe_bois")."\"", "case cerfa.am_coupe_parc when 't' then 'Oui' else 'Non' end as \""._("am_coupe_parc")."\"", "case cerfa.am_coupe_align when 't' then 'Oui' else 'Non' end as \""._("am_coupe_align")."\"", "case cerfa.am_coupe_ess when 't' then 'Oui' else 'Non' end as \""._("am_coupe_ess")."\"", "case cerfa.am_coupe_age when 't' then 'Oui' else 'Non' end as \""._("am_coupe_age")."\"", "case cerfa.am_coupe_dens when 't' then 'Oui' else 'Non' end as \""._("am_coupe_dens")."\"", "case cerfa.am_coupe_qual when 't' then 'Oui' else 'Non' end as \""._("am_coupe_qual")."\"", "case cerfa.am_coupe_trait when 't' then 'Oui' else 'Non' end as \""._("am_coupe_trait")."\"", "case cerfa.am_coupe_autr when 't' then 'Oui' else 'Non' end as \""._("am_coupe_autr")."\"", "case cerfa.co_archi_recours when 't' then 'Oui' else 'Non' end as \""._("co_archi_recours")."\"", "case cerfa.co_cstr_nouv when 't' then 'Oui' else 'Non' end as \""._("co_cstr_nouv")."\"", "case cerfa.co_cstr_exist when 't' then 'Oui' else 'Non' end as \""._("co_cstr_exist")."\"", "case cerfa.co_cloture when 't' then 'Oui' else 'Non' end as \""._("co_cloture")."\"", "case cerfa.co_elec_tension when 't' then 'Oui' else 'Non' end as \""._("co_elec_tension")."\"", "case cerfa.co_div_terr when 't' then 'Oui' else 'Non' end as \""._("co_div_terr")."\"", "case cerfa.co_projet_desc when 't' then 'Oui' else 'Non' end as \""._("co_projet_desc")."\"", "case cerfa.co_anx_pisc when 't' then 'Oui' else 'Non' end as \""._("co_anx_pisc")."\"", "case cerfa.co_anx_gara when 't' then 'Oui' else 'Non' end as \""._("co_anx_gara")."\"", "case cerfa.co_anx_veran when 't' then 'Oui' else 'Non' end as \""._("co_anx_veran")."\"", "case cerfa.co_anx_abri when 't' then 'Oui' else 'Non' end as \""._("co_anx_abri")."\"", "case cerfa.co_anx_autr when 't' then 'Oui' else 'Non' end as \""._("co_anx_autr")."\"", "case cerfa.co_anx_autr_desc when 't' then 'Oui' else 'Non' end as \""._("co_anx_autr_desc")."\"", "case cerfa.co_tot_log_nb when 't' then 'Oui' else 'Non' end as \""._("co_tot_log_nb")."\"", "case cerfa.co_tot_ind_nb when 't' then 'Oui' else 'Non' end as \""._("co_tot_ind_nb")."\"", "case cerfa.co_tot_coll_nb when 't' then 'Oui' else 'Non' end as \""._("co_tot_coll_nb")."\"", "case cerfa.co_mais_piece_nb when 't' then 'Oui' else 'Non' end as \""._("co_mais_piece_nb")."\"", "case cerfa.co_mais_niv_nb when 't' then 'Oui' else 'Non' end as \""._("co_mais_niv_nb")."\"", "case cerfa.co_fin_lls_nb when 't' then 'Oui' else 'Non' end as \""._("co_fin_lls_nb")."\"", "case cerfa.co_fin_aa_nb when 't' then 'Oui' else 'Non' end as \""._("co_fin_aa_nb")."\"", "case cerfa.co_fin_ptz_nb when 't' then 'Oui' else 'Non' end as \""._("co_fin_ptz_nb")."\"", "case cerfa.co_fin_autr_nb when 't' then 'Oui' else 'Non' end as \""._("co_fin_autr_nb")."\"", "case cerfa.co_fin_autr_desc when 't' then 'Oui' else 'Non' end as \""._("co_fin_autr_desc")."\"", "case cerfa.co_mais_contrat_ind when 't' then 'Oui' else 'Non' end as \""._("co_mais_contrat_ind")."\"", "case cerfa.co_uti_pers when 't' then 'Oui' else 'Non' end as \""._("co_uti_pers")."\"", "case cerfa.co_uti_vente when 't' then 'Oui' else 'Non' end as \""._("co_uti_vente")."\"", "case cerfa.co_uti_loc when 't' then 'Oui' else 'Non' end as \""._("co_uti_loc")."\"", "case cerfa.co_uti_princ when 't' then 'Oui' else 'Non' end as \""._("co_uti_princ")."\"", "case cerfa.co_uti_secon when 't' then 'Oui' else 'Non' end as \""._("co_uti_secon")."\"", "case cerfa.co_resid_agees when 't' then 'Oui' else 'Non' end as \""._("co_resid_agees")."\"", "case cerfa.co_resid_etud when 't' then 'Oui' else 'Non' end as \""._("co_resid_etud")."\"", "case cerfa.co_resid_tourism when 't' then 'Oui' else 'Non' end as \""._("co_resid_tourism")."\"", "case cerfa.co_resid_hot_soc when 't' then 'Oui' else 'Non' end as \""._("co_resid_hot_soc")."\"", "case cerfa.co_resid_soc when 't' then 'Oui' else 'Non' end as \""._("co_resid_soc")."\"", "case cerfa.co_resid_hand when 't' then 'Oui' else 'Non' end as \""._("co_resid_hand")."\"", "case cerfa.co_resid_autr when 't' then 'Oui' else 'Non' end as \""._("co_resid_autr")."\"", "case cerfa.co_resid_autr_desc when 't' then 'Oui' else 'Non' end as \""._("co_resid_autr_desc")."\"", "case cerfa.co_foyer_chamb_nb when 't' then 'Oui' else 'Non' end as \""._("co_foyer_chamb_nb")."\"", "case cerfa.co_log_1p_nb when 't' then 'Oui' else 'Non' end as \""._("co_log_1p_nb")."\"", "case cerfa.co_log_2p_nb when 't' then 'Oui' else 'Non' end as \""._("co_log_2p_nb")."\"", "case cerfa.co_log_3p_nb when 't' then 'Oui' else 'Non' end as \""._("co_log_3p_nb")."\"", "case cerfa.co_log_4p_nb when 't' then 'Oui' else 'Non' end as \""._("co_log_4p_nb")."\"", "case cerfa.co_log_5p_nb when 't' then 'Oui' else 'Non' end as \""._("co_log_5p_nb")."\"", "case cerfa.co_log_6p_nb when 't' then 'Oui' else 'Non' end as \""._("co_log_6p_nb")."\"", "case cerfa.co_bat_niv_nb when 't' then 'Oui' else 'Non' end as \""._("co_bat_niv_nb")."\"", "case cerfa.co_trx_exten when 't' then 'Oui' else 'Non' end as \""._("co_trx_exten")."\"", "case cerfa.co_trx_surelev when 't' then 'Oui' else 'Non' end as \""._("co_trx_surelev")."\"", "case cerfa.co_trx_nivsup when 't' then 'Oui' else 'Non' end as \""._("co_trx_nivsup")."\"", "case cerfa.co_demont_periode when 't' then 'Oui' else 'Non' end as \""._("co_demont_periode")."\"", "case cerfa.co_sp_transport when 't' then 'Oui' else 'Non' end as \""._("co_sp_transport")."\"", "case cerfa.co_sp_enseign when 't' then 'Oui' else 'Non' end as \""._("co_sp_enseign")."\"", "case cerfa.co_sp_act_soc when 't' then 'Oui' else 'Non' end as \""._("co_sp_act_soc")."\"", "case cerfa.co_sp_ouvr_spe when 't' then 'Oui' else 'Non' end as \""._("co_sp_ouvr_spe")."\"", "case cerfa.co_sp_sante when 't' then 'Oui' else 'Non' end as \""._("co_sp_sante")."\"", "case cerfa.co_sp_culture when 't' then 'Oui' else 'Non' end as \""._("co_sp_culture")."\"", "case cerfa.co_statio_avt_nb when 't' then 'Oui' else 'Non' end as \""._("co_statio_avt_nb")."\"", "case cerfa.co_statio_apr_nb when 't' then 'Oui' else 'Non' end as \""._("co_statio_apr_nb")."\"", "case cerfa.co_statio_adr when 't' then 'Oui' else 'Non' end as \""._("co_statio_adr")."\"", "case cerfa.co_statio_place_nb when 't' then 'Oui' else 'Non' end as \""._("co_statio_place_nb")."\"", "case cerfa.co_statio_tot_surf when 't' then 'Oui' else 'Non' end as \""._("co_statio_tot_surf")."\"", "case cerfa.co_statio_tot_shob when 't' then 'Oui' else 'Non' end as \""._("co_statio_tot_shob")."\"", "case cerfa.co_statio_comm_cin_surf when 't' then 'Oui' else 'Non' end as \""._("co_statio_comm_cin_surf")."\"", 'cerfa.tab_surface as "'._("tab_surface").'"', "case cerfa.dm_constr_dates when 't' then 'Oui' else 'Non' end as \""._("dm_constr_dates")."\"", "case cerfa.dm_total when 't' then 'Oui' else 'Non' end as \""._("dm_total")."\"", "case cerfa.dm_partiel when 't' then 'Oui' else 'Non' end as \""._("dm_partiel")."\"", "case cerfa.dm_projet_desc when 't' then 'Oui' else 'Non' end as \""._("dm_projet_desc")."\"", "case cerfa.dm_tot_log_nb when 't' then 'Oui' else 'Non' end as \""._("dm_tot_log_nb")."\"", "case cerfa.tax_surf_tot when 't' then 'Oui' else 'Non' end as \""._("tax_surf_tot")."\"", "case cerfa.tax_surf when 't' then 'Oui' else 'Non' end as \""._("tax_surf")."\"", "case cerfa.tax_surf_suppr_mod when 't' then 'Oui' else 'Non' end as \""._("tax_surf_suppr_mod")."\"", 'cerfa.tab_tax_su_princ as "'._("tab_tax_su_princ").'"', 'cerfa.tab_tax_su_heber as "'._("tab_tax_su_heber").'"', 'cerfa.tab_tax_su_secon as "'._("tab_tax_su_secon").'"', 'cerfa.tab_tax_su_tot as "'._("tab_tax_su_tot").'"', "case cerfa.tax_ext_pret when 't' then 'Oui' else 'Non' end as \""._("tax_ext_pret")."\"", "case cerfa.tax_ext_desc when 't' then 'Oui' else 'Non' end as \""._("tax_ext_desc")."\"", "case cerfa.tax_surf_tax_exist_cons when 't' then 'Oui' else 'Non' end as \""._("tax_surf_tax_exist_cons")."\"", "case cerfa.tax_log_exist_nb when 't' then 'Oui' else 'Non' end as \""._("tax_log_exist_nb")."\"", "case cerfa.tax_trx_presc_ppr when 't' then 'Oui' else 'Non' end as \""._("tax_trx_presc_ppr")."\"", "case cerfa.tax_monu_hist when 't' then 'Oui' else 'Non' end as \""._("tax_monu_hist")."\"", "case cerfa.tax_comm_nb when 't' then 'Oui' else 'Non' end as \""._("tax_comm_nb")."\"", 'cerfa.tab_tax_su_non_habit_surf as "'._("tab_tax_su_non_habit_surf").'"', 'cerfa.tab_tax_am as "'._("tab_tax_am").'"', "case cerfa.vsd_surf_planch_smd when 't' then 'Oui' else 'Non' end as \""._("vsd_surf_planch_smd")."\"", "case cerfa.vsd_unit_fonc_sup when 't' then 'Oui' else 'Non' end as \""._("vsd_unit_fonc_sup")."\"", "case cerfa.vsd_unit_fonc_constr_sup when 't' then 'Oui' else 'Non' end as \""._("vsd_unit_fonc_constr_sup")."\"", "case cerfa.vsd_val_terr when 't' then 'Oui' else 'Non' end as \""._("vsd_val_terr")."\"", "case cerfa.vsd_const_sxist_non_dem_surf when 't' then 'Oui' else 'Non' end as \""._("vsd_const_sxist_non_dem_surf")."\"", "case cerfa.vsd_rescr_fisc when 't' then 'Oui' else 'Non' end as \""._("vsd_rescr_fisc")."\"", "case cerfa.pld_val_terr when 't' then 'Oui' else 'Non' end as \""._("pld_val_terr")."\"", "case cerfa.pld_const_exist_dem when 't' then 'Oui' else 'Non' end as \""._("pld_const_exist_dem")."\"", "case cerfa.pld_const_exist_dem_surf when 't' then 'Oui' else 'Non' end as \""._("pld_const_exist_dem_surf")."\"", "case cerfa.code_cnil when 't' then 'Oui' else 'Non' end as \""._("code_cnil")."\"", "case cerfa.terr_juri_titul when 't' then 'Oui' else 'Non' end as \""._("terr_juri_titul")."\"", "case cerfa.terr_juri_lot when 't' then 'Oui' else 'Non' end as \""._("terr_juri_lot")."\"", "case cerfa.terr_juri_zac when 't' then 'Oui' else 'Non' end as \""._("terr_juri_zac")."\"", "case cerfa.terr_juri_afu when 't' then 'Oui' else 'Non' end as \""._("terr_juri_afu")."\"", "case cerfa.terr_juri_pup when 't' then 'Oui' else 'Non' end as \""._("terr_juri_pup")."\"", "case cerfa.terr_juri_oin when 't' then 'Oui' else 'Non' end as \""._("terr_juri_oin")."\"", "case cerfa.terr_juri_desc when 't' then 'Oui' else 'Non' end as \""._("terr_juri_desc")."\"", "case cerfa.terr_div_surf_etab when 't' then 'Oui' else 'Non' end as \""._("terr_div_surf_etab")."\"", "case cerfa.terr_div_surf_av_div when 't' then 'Oui' else 'Non' end as \""._("terr_div_surf_av_div")."\"", "case cerfa.doc_date when 't' then 'Oui' else 'Non' end as \""._("doc_date")."\"", "case cerfa.doc_tot_trav when 't' then 'Oui' else 'Non' end as \""._("doc_tot_trav")."\"", "case cerfa.doc_tranche_trav when 't' then 'Oui' else 'Non' end as \""._("doc_tranche_trav")."\"", "case cerfa.doc_tranche_trav_desc when 't' then 'Oui' else 'Non' end as \""._("doc_tranche_trav_desc")."\"", "case cerfa.doc_surf when 't' then 'Oui' else 'Non' end as \""._("doc_surf")."\"", "case cerfa.doc_nb_log when 't' then 'Oui' else 'Non' end as \""._("doc_nb_log")."\"", "case cerfa.doc_nb_log_indiv when 't' then 'Oui' else 'Non' end as \""._("doc_nb_log_indiv")."\"", "case cerfa.doc_nb_log_coll when 't' then 'Oui' else 'Non' end as \""._("doc_nb_log_coll")."\"", "case cerfa.doc_nb_log_lls when 't' then 'Oui' else 'Non' end as \""._("doc_nb_log_lls")."\"", "case cerfa.doc_nb_log_aa when 't' then 'Oui' else 'Non' end as \""._("doc_nb_log_aa")."\"", "case cerfa.doc_nb_log_ptz when 't' then 'Oui' else 'Non' end as \""._("doc_nb_log_ptz")."\"", "case cerfa.doc_nb_log_autre when 't' then 'Oui' else 'Non' end as \""._("doc_nb_log_autre")."\"", "case cerfa.daact_date when 't' then 'Oui' else 'Non' end as \""._("daact_date")."\"", "case cerfa.daact_date_chgmt_dest when 't' then 'Oui' else 'Non' end as \""._("daact_date_chgmt_dest")."\"", "case cerfa.daact_tot_trav when 't' then 'Oui' else 'Non' end as \""._("daact_tot_trav")."\"", "case cerfa.daact_tranche_trav when 't' then 'Oui' else 'Non' end as \""._("daact_tranche_trav")."\"", "case cerfa.daact_tranche_trav_desc when 't' then 'Oui' else 'Non' end as \""._("daact_tranche_trav_desc")."\"", "case cerfa.daact_surf when 't' then 'Oui' else 'Non' end as \""._("daact_surf")."\"", "case cerfa.daact_nb_log when 't' then 'Oui' else 'Non' end as \""._("daact_nb_log")."\"", "case cerfa.daact_nb_log_indiv when 't' then 'Oui' else 'Non' end as \""._("daact_nb_log_indiv")."\"", "case cerfa.daact_nb_log_coll when 't' then 'Oui' else 'Non' end as \""._("daact_nb_log_coll")."\"", "case cerfa.daact_nb_log_lls when 't' then 'Oui' else 'Non' end as \""._("daact_nb_log_lls")."\"", "case cerfa.daact_nb_log_aa when 't' then 'Oui' else 'Non' end as \""._("daact_nb_log_aa")."\"", "case cerfa.daact_nb_log_ptz when 't' then 'Oui' else 'Non' end as \""._("daact_nb_log_ptz")."\"", "case cerfa.daact_nb_log_autre when 't' then 'Oui' else 'Non' end as \""._("daact_nb_log_autre")."\"", "case cerfa.am_div_mun when 't' then 'Oui' else 'Non' end as \""._("am_div_mun")."\"", "case cerfa.co_perf_energ when 't' then 'Oui' else 'Non' end as \""._("co_perf_energ")."\"", "case cerfa.architecte when 't' then 'Oui' else 'Non' end as \""._("architecte")."\"", "case cerfa.co_statio_avt_shob when 't' then 'Oui' else 'Non' end as \""._("co_statio_avt_shob")."\"", "case cerfa.co_statio_apr_shob when 't' then 'Oui' else 'Non' end as \""._("co_statio_apr_shob")."\"", "case cerfa.co_statio_avt_surf when 't' then 'Oui' else 'Non' end as \""._("co_statio_avt_surf")."\"", "case cerfa.co_statio_apr_surf when 't' then 'Oui' else 'Non' end as \""._("co_statio_apr_surf")."\"", "case cerfa.co_trx_amgt when 't' then 'Oui' else 'Non' end as \""._("co_trx_amgt")."\"", "case cerfa.co_modif_aspect when 't' then 'Oui' else 'Non' end as \""._("co_modif_aspect")."\"", "case cerfa.co_modif_struct when 't' then 'Oui' else 'Non' end as \""._("co_modif_struct")."\"", "case cerfa.co_ouvr_elec when 't' then 'Oui' else 'Non' end as \""._("co_ouvr_elec")."\"", "case cerfa.co_ouvr_infra when 't' then 'Oui' else 'Non' end as \""._("co_ouvr_infra")."\"", "case cerfa.co_trx_imm when 't' then 'Oui' else 'Non' end as \""._("co_trx_imm")."\"", "case cerfa.co_cstr_shob when 't' then 'Oui' else 'Non' end as \""._("co_cstr_shob")."\"", "case cerfa.am_voyage_deb when 't' then 'Oui' else 'Non' end as \""._("am_voyage_deb")."\"", "case cerfa.am_voyage_fin when 't' then 'Oui' else 'Non' end as \""._("am_voyage_fin")."\"", "case cerfa.am_modif_amgt when 't' then 'Oui' else 'Non' end as \""._("am_modif_amgt")."\"", "case cerfa.am_lot_max_shob when 't' then 'Oui' else 'Non' end as \""._("am_lot_max_shob")."\"", "case cerfa.mod_desc when 't' then 'Oui' else 'Non' end as \""._("mod_desc")."\"", "case cerfa.tr_total when 't' then 'Oui' else 'Non' end as \""._("tr_total")."\"", "case cerfa.tr_partiel when 't' then 'Oui' else 'Non' end as \""._("tr_partiel")."\"", "case cerfa.tr_desc when 't' then 'Oui' else 'Non' end as \""._("tr_desc")."\"", "case cerfa.avap_co_elt_pro when 't' then 'Oui' else 'Non' end as \""._("avap_co_elt_pro")."\"", "case cerfa.avap_nouv_haut_surf when 't' then 'Oui' else 'Non' end as \""._("avap_nouv_haut_surf")."\"", "case cerfa.avap_co_clot when 't' then 'Oui' else 'Non' end as \""._("avap_co_clot")."\"", "case cerfa.avap_aut_coup_aba_arb when 't' then 'Oui' else 'Non' end as \""._("avap_aut_coup_aba_arb")."\"", "case cerfa.avap_ouv_infra when 't' then 'Oui' else 'Non' end as \""._("avap_ouv_infra")."\"", "case cerfa.avap_aut_inst_mob when 't' then 'Oui' else 'Non' end as \""._("avap_aut_inst_mob")."\"", "case cerfa.avap_aut_plant when 't' then 'Oui' else 'Non' end as \""._("avap_aut_plant")."\"", "case cerfa.avap_aut_auv_elec when 't' then 'Oui' else 'Non' end as \""._("avap_aut_auv_elec")."\"", "case cerfa.tax_dest_loc_tr when 't' then 'Oui' else 'Non' end as \""._("tax_dest_loc_tr")."\"", "case cerfa.ope_proj_desc when 't' then 'Oui' else 'Non' end as \""._("ope_proj_desc")."\"", "case cerfa.tax_surf_tot_cstr when 't' then 'Oui' else 'Non' end as \""._("tax_surf_tot_cstr")."\"", "case cerfa.tax_surf_loc_stat when 't' then 'Oui' else 'Non' end as \""._("tax_surf_loc_stat")."\"", "case cerfa.tax_log_ap_trvx_nb when 't' then 'Oui' else 'Non' end as \""._("tax_log_ap_trvx_nb")."\"", "case cerfa.tax_am_statio_ext_cr when 't' then 'Oui' else 'Non' end as \""._("tax_am_statio_ext_cr")."\"", "case cerfa.tax_sup_bass_pisc_cr when 't' then 'Oui' else 'Non' end as \""._("tax_sup_bass_pisc_cr")."\"", "case cerfa.tax_empl_ten_carav_mobil_nb_cr when 't' then 'Oui' else 'Non' end as \""._("tax_empl_ten_carav_mobil_nb_cr")."\"", "case cerfa.tax_empl_hll_nb_cr when 't' then 'Oui' else 'Non' end as \""._("tax_empl_hll_nb_cr")."\"", "case cerfa.tax_eol_haut_nb_cr when 't' then 'Oui' else 'Non' end as \""._("tax_eol_haut_nb_cr")."\"", "case cerfa.tax_pann_volt_sup_cr when 't' then 'Oui' else 'Non' end as \""._("tax_pann_volt_sup_cr")."\"", "case cerfa.tax_surf_loc_arch when 't' then 'Oui' else 'Non' end as \""._("tax_surf_loc_arch")."\"", "case cerfa.tax_surf_pisc_arch when 't' then 'Oui' else 'Non' end as \""._("tax_surf_pisc_arch")."\"", "case cerfa.tax_am_statio_ext_arch when 't' then 'Oui' else 'Non' end as \""._("tax_am_statio_ext_arch")."\"", 'cerfa.tab_tax_su_parc_statio_expl_comm as "'._("tab_tax_su_parc_statio_expl_comm").'"', "case cerfa.tax_empl_ten_carav_mobil_nb_arch when 't' then 'Oui' else 'Non' end as \""._("tax_empl_ten_carav_mobil_nb_arch")."\"", "case cerfa.tax_empl_hll_nb_arch when 't' then 'Oui' else 'Non' end as \""._("tax_empl_hll_nb_arch")."\"", "case cerfa.tax_eol_haut_nb_arch when 't' then 'Oui' else 'Non' end as \""._("tax_eol_haut_nb_arch")."\"", "case cerfa.ope_proj_div_co when 't' then 'Oui' else 'Non' end as \""._("ope_proj_div_co")."\"", "case cerfa.ope_proj_div_contr when 't' then 'Oui' else 'Non' end as \""._("ope_proj_div_contr")."\"", "case cerfa.tax_desc when 't' then 'Oui' else 'Non' end as \""._("tax_desc")."\"", "case cerfa.erp_cstr_neuve when 't' then 'Oui' else 'Non' end as \""._("erp_cstr_neuve")."\"", "case cerfa.erp_trvx_acc when 't' then 'Oui' else 'Non' end as \""._("erp_trvx_acc")."\"", "case cerfa.erp_extension when 't' then 'Oui' else 'Non' end as \""._("erp_extension")."\"", "case cerfa.erp_rehab when 't' then 'Oui' else 'Non' end as \""._("erp_rehab")."\"", "case cerfa.erp_trvx_am when 't' then 'Oui' else 'Non' end as \""._("erp_trvx_am")."\"", "case cerfa.erp_vol_nouv_exist when 't' then 'Oui' else 'Non' end as \""._("erp_vol_nouv_exist")."\"", 'cerfa.tab_erp_eff as "'._("tab_erp_eff").'"', "case cerfa.erp_class_cat when 't' then 'Oui' else 'Non' end as \""._("erp_class_cat")."\"", "case cerfa.erp_class_type when 't' then 'Oui' else 'Non' end as \""._("erp_class_type")."\"", "case cerfa.tax_surf_abr_jard_pig_colom when 't' then 'Oui' else 'Non' end as \""._("tax_surf_abr_jard_pig_colom")."\"", "case cerfa.tax_su_non_habit_abr_jard_pig_colom when 't' then 'Oui' else 'Non' end as \""._("tax_su_non_habit_abr_jard_pig_colom")."\"", "case cerfa.dia_imm_non_bati when 't' then 'Oui' else 'Non' end as \""._("dia_imm_non_bati")."\"", "case cerfa.dia_imm_bati_terr_propr when 't' then 'Oui' else 'Non' end as \""._("dia_imm_bati_terr_propr")."\"", "case cerfa.dia_imm_bati_terr_autr when 't' then 'Oui' else 'Non' end as \""._("dia_imm_bati_terr_autr")."\"", "case cerfa.dia_imm_bati_terr_autr_desc when 't' then 'Oui' else 'Non' end as \""._("dia_imm_bati_terr_autr_desc")."\"", "case cerfa.dia_bat_copro when 't' then 'Oui' else 'Non' end as \""._("dia_bat_copro")."\"", "case cerfa.dia_bat_copro_desc when 't' then 'Oui' else 'Non' end as \""._("dia_bat_copro_desc")."\"", "case cerfa.dia_lot_numero when 't' then 'Oui' else 'Non' end as \""._("dia_lot_numero")."\"", "case cerfa.dia_lot_bat when 't' then 'Oui' else 'Non' end as \""._("dia_lot_bat")."\"", "case cerfa.dia_lot_etage when 't' then 'Oui' else 'Non' end as \""._("dia_lot_etage")."\"", "case cerfa.dia_lot_quote_part when 't' then 'Oui' else 'Non' end as \""._("dia_lot_quote_part")."\"", "case cerfa.dia_us_hab when 't' then 'Oui' else 'Non' end as \""._("dia_us_hab")."\"", "case cerfa.dia_us_pro when 't' then 'Oui' else 'Non' end as \""._("dia_us_pro")."\"", "case cerfa.dia_us_mixte when 't' then 'Oui' else 'Non' end as \""._("dia_us_mixte")."\"", "case cerfa.dia_us_comm when 't' then 'Oui' else 'Non' end as \""._("dia_us_comm")."\"", "case cerfa.dia_us_agr when 't' then 'Oui' else 'Non' end as \""._("dia_us_agr")."\"", "case cerfa.dia_us_autre when 't' then 'Oui' else 'Non' end as \""._("dia_us_autre")."\"", "case cerfa.dia_us_autre_prec when 't' then 'Oui' else 'Non' end as \""._("dia_us_autre_prec")."\"", "case cerfa.dia_occ_prop when 't' then 'Oui' else 'Non' end as \""._("dia_occ_prop")."\"", "case cerfa.dia_occ_loc when 't' then 'Oui' else 'Non' end as \""._("dia_occ_loc")."\"", "case cerfa.dia_occ_sans_occ when 't' then 'Oui' else 'Non' end as \""._("dia_occ_sans_occ")."\"", "case cerfa.dia_occ_autre when 't' then 'Oui' else 'Non' end as \""._("dia_occ_autre")."\"", "case cerfa.dia_occ_autre_prec when 't' then 'Oui' else 'Non' end as \""._("dia_occ_autre_prec")."\"", "case cerfa.dia_mod_cess_prix_vente when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_prix_vente")."\"", "case cerfa.dia_mod_cess_prix_vente_mob when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_prix_vente_mob")."\"", "case cerfa.dia_mod_cess_prix_vente_cheptel when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_prix_vente_cheptel")."\"", "case cerfa.dia_mod_cess_prix_vente_recol when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_prix_vente_recol")."\"", "case cerfa.dia_mod_cess_prix_vente_autre when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_prix_vente_autre")."\"", "case cerfa.dia_mod_cess_commi when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_commi")."\"", "case cerfa.dia_mod_cess_commi_ttc when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_commi_ttc")."\"", "case cerfa.dia_mod_cess_commi_ht when 't' then 'Oui' else 'Non' end as \""._("dia_mod_cess_commi_ht")."\"", "case cerfa.dia_acquereur_nom_prenom when 't' then 'Oui' else 'Non' end as \""._("dia_acquereur_nom_prenom")."\"", "case cerfa.dia_acquereur_adr_num_voie when 't' then 'Oui' else 'Non' end as \""._("dia_acquereur_adr_num_voie")."\"", "case cerfa.dia_acquereur_adr_ext when 't' then 'Oui' else 'Non' end as \""._("dia_acquereur_adr_ext")."\"", "case cerfa.dia_acquereur_adr_type_voie when 't' then 'Oui' else 'Non' end as \""._("dia_acquereur_adr_type_voie")."\"", "case cerfa.dia_acquereur_adr_nom_voie when 't' then 'Oui' else 'Non' end as \""._("dia_acquereur_adr_nom_voie")."\"", "case cerfa.dia_acquereur_adr_lieu_dit_bp when 't' then 'Oui' else 'Non' end as \""._("dia_acquereur_adr_lieu_dit_bp")."\"", "case cerfa.dia_acquereur_adr_cp when 't' then 'Oui' else 'Non' end as \""._("dia_acquereur_adr_cp")."\"", "case cerfa.dia_acquereur_adr_localite when 't' then 'Oui' else 'Non' end as \""._("dia_acquereur_adr_localite")."\"", "case cerfa.dia_observation when 't' then 'Oui' else 'Non' end as \""._("dia_observation")."\"", ); // $champNonAffiche = array( ); // $champRecherche = array( 'cerfa.cerfa as "'._("cerfa").'"', 'cerfa.libelle as "'._("libelle").'"', 'cerfa.code as "'._("code").'"', 'cerfa.tab_surface as "'._("tab_surface").'"', 'cerfa.tab_tax_su_princ as "'._("tab_tax_su_princ").'"', 'cerfa.tab_tax_su_heber as "'._("tab_tax_su_heber").'"', 'cerfa.tab_tax_su_secon as "'._("tab_tax_su_secon").'"', 'cerfa.tab_tax_su_tot as "'._("tab_tax_su_tot").'"', 'cerfa.tab_tax_su_non_habit_surf as "'._("tab_tax_su_non_habit_surf").'"', 'cerfa.tab_tax_am as "'._("tab_tax_am").'"', 'cerfa.tab_tax_su_parc_statio_expl_comm as "'._("tab_tax_su_parc_statio_expl_comm").'"', 'cerfa.tab_erp_eff as "'._("tab_erp_eff").'"', ); $tri="ORDER BY cerfa.libelle ASC NULLS LAST"; $edition="cerfa"; /** * Gestion de la clause WHERE => $selection */ // Filtre listing standard $selection = " WHERE ((cerfa.om_validite_debut IS NULL AND (cerfa.om_validite_fin IS NULL OR cerfa.om_validite_fin > CURRENT_DATE)) OR (cerfa.om_validite_debut <= CURRENT_DATE AND (cerfa.om_validite_fin IS NULL OR cerfa.om_validite_fin > CURRENT_DATE)))"; $where_om_validite = " WHERE ((cerfa.om_validite_debut IS NULL AND (cerfa.om_validite_fin IS NULL OR cerfa.om_validite_fin > CURRENT_DATE)) OR (cerfa.om_validite_debut <= CURRENT_DATE AND (cerfa.om_validite_fin IS NULL OR cerfa.om_validite_fin > CURRENT_DATE)))"; // Gestion OMValidité - Suppression du filtre si paramètre if (isset($_GET["valide"]) and $_GET["valide"] == "false") { if (!isset($where_om_validite) or (isset($where_om_validite) and $where_om_validite == "")) { if (trim($selection) != "") { $selection = ""; } } else { $selection = trim(str_replace($where_om_validite, "", $selection)); } } /** * Gestion SOUSFORMULAIRE => $sousformulaire */ $sousformulaire = array( 'dossier_autorisation_type_detaille', ); ?>