".__("dossiers")." -> ".__("cerfa"); $om_validite = true; 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."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").'"', ); // $champNonAffiche = array( 'cerfa.am_lotiss as "'.__("am_lotiss").'"', 'cerfa.am_autre_div as "'.__("am_autre_div").'"', 'cerfa.am_camping as "'.__("am_camping").'"', 'cerfa.am_caravane as "'.__("am_caravane").'"', 'cerfa.am_carav_duree as "'.__("am_carav_duree").'"', 'cerfa.am_statio as "'.__("am_statio").'"', 'cerfa.am_statio_cont as "'.__("am_statio_cont").'"', 'cerfa.am_affou_exhau as "'.__("am_affou_exhau").'"', 'cerfa.am_affou_exhau_sup as "'.__("am_affou_exhau_sup").'"', 'cerfa.am_affou_prof as "'.__("am_affou_prof").'"', 'cerfa.am_exhau_haut as "'.__("am_exhau_haut").'"', 'cerfa.am_coupe_abat as "'.__("am_coupe_abat").'"', 'cerfa.am_prot_plu as "'.__("am_prot_plu").'"', 'cerfa.am_prot_muni as "'.__("am_prot_muni").'"', 'cerfa.am_mobil_voyage as "'.__("am_mobil_voyage").'"', 'cerfa.am_aire_voyage as "'.__("am_aire_voyage").'"', 'cerfa.am_rememb_afu as "'.__("am_rememb_afu").'"', 'cerfa.am_parc_resid_loi as "'.__("am_parc_resid_loi").'"', 'cerfa.am_sport_moto as "'.__("am_sport_moto").'"', 'cerfa.am_sport_attrac as "'.__("am_sport_attrac").'"', 'cerfa.am_sport_golf as "'.__("am_sport_golf").'"', 'cerfa.am_mob_art as "'.__("am_mob_art").'"', 'cerfa.am_modif_voie_esp as "'.__("am_modif_voie_esp").'"', 'cerfa.am_plant_voie_esp as "'.__("am_plant_voie_esp").'"', 'cerfa.am_chem_ouv_esp as "'.__("am_chem_ouv_esp").'"', 'cerfa.am_agri_peche as "'.__("am_agri_peche").'"', 'cerfa.am_crea_voie as "'.__("am_crea_voie").'"', 'cerfa.am_modif_voie_exist as "'.__("am_modif_voie_exist").'"', 'cerfa.am_crea_esp_sauv as "'.__("am_crea_esp_sauv").'"', 'cerfa.am_crea_esp_class as "'.__("am_crea_esp_class").'"', 'cerfa.am_projet_desc as "'.__("am_projet_desc").'"', 'cerfa.am_terr_surf as "'.__("am_terr_surf").'"', 'cerfa.am_tranche_desc as "'.__("am_tranche_desc").'"', 'cerfa.am_lot_max_nb as "'.__("am_lot_max_nb").'"', 'cerfa.am_lot_max_shon as "'.__("am_lot_max_shon").'"', 'cerfa.am_lot_cstr_cos as "'.__("am_lot_cstr_cos").'"', 'cerfa.am_lot_cstr_plan as "'.__("am_lot_cstr_plan").'"', 'cerfa.am_lot_cstr_vente as "'.__("am_lot_cstr_vente").'"', 'cerfa.am_lot_fin_diff as "'.__("am_lot_fin_diff").'"', 'cerfa.am_lot_consign as "'.__("am_lot_consign").'"', 'cerfa.am_lot_gar_achev as "'.__("am_lot_gar_achev").'"', 'cerfa.am_lot_vente_ant as "'.__("am_lot_vente_ant").'"', 'cerfa.am_empl_nb as "'.__("am_empl_nb").'"', 'cerfa.am_tente_nb as "'.__("am_tente_nb").'"', 'cerfa.am_carav_nb as "'.__("am_carav_nb").'"', 'cerfa.am_mobil_nb as "'.__("am_mobil_nb").'"', 'cerfa.am_pers_nb as "'.__("am_pers_nb").'"', 'cerfa.am_empl_hll_nb as "'.__("am_empl_hll_nb").'"', 'cerfa.am_hll_shon as "'.__("am_hll_shon").'"', 'cerfa.am_periode_exploit as "'.__("am_periode_exploit").'"', 'cerfa.am_exist_agrand as "'.__("am_exist_agrand").'"', 'cerfa.am_exist_date as "'.__("am_exist_date").'"', 'cerfa.am_exist_num as "'.__("am_exist_num").'"', 'cerfa.am_exist_nb_avant as "'.__("am_exist_nb_avant").'"', 'cerfa.am_exist_nb_apres as "'.__("am_exist_nb_apres").'"', 'cerfa.am_coupe_bois as "'.__("am_coupe_bois").'"', 'cerfa.am_coupe_parc as "'.__("am_coupe_parc").'"', 'cerfa.am_coupe_align as "'.__("am_coupe_align").'"', 'cerfa.am_coupe_ess as "'.__("am_coupe_ess").'"', 'cerfa.am_coupe_age as "'.__("am_coupe_age").'"', 'cerfa.am_coupe_dens as "'.__("am_coupe_dens").'"', 'cerfa.am_coupe_qual as "'.__("am_coupe_qual").'"', 'cerfa.am_coupe_trait as "'.__("am_coupe_trait").'"', 'cerfa.am_coupe_autr as "'.__("am_coupe_autr").'"', 'cerfa.co_archi_recours as "'.__("co_archi_recours").'"', 'cerfa.co_cstr_nouv as "'.__("co_cstr_nouv").'"', 'cerfa.co_cstr_exist as "'.__("co_cstr_exist").'"', 'cerfa.co_cloture as "'.__("co_cloture").'"', 'cerfa.co_elec_tension as "'.__("co_elec_tension").'"', 'cerfa.co_div_terr as "'.__("co_div_terr").'"', 'cerfa.co_projet_desc as "'.__("co_projet_desc").'"', 'cerfa.co_anx_pisc as "'.__("co_anx_pisc").'"', 'cerfa.co_anx_gara as "'.__("co_anx_gara").'"', 'cerfa.co_anx_veran as "'.__("co_anx_veran").'"', 'cerfa.co_anx_abri as "'.__("co_anx_abri").'"', 'cerfa.co_anx_autr as "'.__("co_anx_autr").'"', 'cerfa.co_anx_autr_desc as "'.__("co_anx_autr_desc").'"', 'cerfa.co_tot_log_nb as "'.__("co_tot_log_nb").'"', 'cerfa.co_tot_ind_nb as "'.__("co_tot_ind_nb").'"', 'cerfa.co_tot_coll_nb as "'.__("co_tot_coll_nb").'"', 'cerfa.co_mais_piece_nb as "'.__("co_mais_piece_nb").'"', 'cerfa.co_mais_niv_nb as "'.__("co_mais_niv_nb").'"', 'cerfa.co_fin_lls_nb as "'.__("co_fin_lls_nb").'"', 'cerfa.co_fin_aa_nb as "'.__("co_fin_aa_nb").'"', 'cerfa.co_fin_ptz_nb as "'.__("co_fin_ptz_nb").'"', 'cerfa.co_fin_autr_nb as "'.__("co_fin_autr_nb").'"', 'cerfa.co_fin_autr_desc as "'.__("co_fin_autr_desc").'"', 'cerfa.co_mais_contrat_ind as "'.__("co_mais_contrat_ind").'"', 'cerfa.co_uti_pers as "'.__("co_uti_pers").'"', 'cerfa.co_uti_vente as "'.__("co_uti_vente").'"', 'cerfa.co_uti_loc as "'.__("co_uti_loc").'"', 'cerfa.co_uti_princ as "'.__("co_uti_princ").'"', 'cerfa.co_uti_secon as "'.__("co_uti_secon").'"', 'cerfa.co_resid_agees as "'.__("co_resid_agees").'"', 'cerfa.co_resid_etud as "'.__("co_resid_etud").'"', 'cerfa.co_resid_tourism as "'.__("co_resid_tourism").'"', 'cerfa.co_resid_hot_soc as "'.__("co_resid_hot_soc").'"', 'cerfa.co_resid_soc as "'.__("co_resid_soc").'"', 'cerfa.co_resid_hand as "'.__("co_resid_hand").'"', 'cerfa.co_resid_autr as "'.__("co_resid_autr").'"', 'cerfa.co_resid_autr_desc as "'.__("co_resid_autr_desc").'"', 'cerfa.co_foyer_chamb_nb as "'.__("co_foyer_chamb_nb").'"', 'cerfa.co_log_1p_nb as "'.__("co_log_1p_nb").'"', 'cerfa.co_log_2p_nb as "'.__("co_log_2p_nb").'"', 'cerfa.co_log_3p_nb as "'.__("co_log_3p_nb").'"', 'cerfa.co_log_4p_nb as "'.__("co_log_4p_nb").'"', 'cerfa.co_log_5p_nb as "'.__("co_log_5p_nb").'"', 'cerfa.co_log_6p_nb as "'.__("co_log_6p_nb").'"', 'cerfa.co_bat_niv_nb as "'.__("co_bat_niv_nb").'"', 'cerfa.co_trx_exten as "'.__("co_trx_exten").'"', 'cerfa.co_trx_surelev as "'.__("co_trx_surelev").'"', 'cerfa.co_trx_nivsup as "'.__("co_trx_nivsup").'"', 'cerfa.co_demont_periode as "'.__("co_demont_periode").'"', 'cerfa.co_sp_transport as "'.__("co_sp_transport").'"', 'cerfa.co_sp_enseign as "'.__("co_sp_enseign").'"', 'cerfa.co_sp_act_soc as "'.__("co_sp_act_soc").'"', 'cerfa.co_sp_ouvr_spe as "'.__("co_sp_ouvr_spe").'"', 'cerfa.co_sp_sante as "'.__("co_sp_sante").'"', 'cerfa.co_sp_culture as "'.__("co_sp_culture").'"', 'cerfa.co_statio_avt_nb as "'.__("co_statio_avt_nb").'"', 'cerfa.co_statio_apr_nb as "'.__("co_statio_apr_nb").'"', 'cerfa.co_statio_adr as "'.__("co_statio_adr").'"', 'cerfa.co_statio_place_nb as "'.__("co_statio_place_nb").'"', 'cerfa.co_statio_tot_surf as "'.__("co_statio_tot_surf").'"', 'cerfa.co_statio_tot_shob as "'.__("co_statio_tot_shob").'"', 'cerfa.co_statio_comm_cin_surf as "'.__("co_statio_comm_cin_surf").'"', 'cerfa.tab_surface as "'.__("tab_surface").'"', 'cerfa.dm_constr_dates as "'.__("dm_constr_dates").'"', 'cerfa.dm_total as "'.__("dm_total").'"', 'cerfa.dm_partiel as "'.__("dm_partiel").'"', 'cerfa.dm_projet_desc as "'.__("dm_projet_desc").'"', 'cerfa.dm_tot_log_nb as "'.__("dm_tot_log_nb").'"', 'cerfa.tax_surf_tot as "'.__("tax_surf_tot").'"', 'cerfa.tax_surf as "'.__("tax_surf").'"', 'cerfa.tax_surf_suppr_mod 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").'"', 'cerfa.tax_ext_pret as "'.__("tax_ext_pret").'"', 'cerfa.tax_ext_desc as "'.__("tax_ext_desc").'"', 'cerfa.tax_surf_tax_exist_cons as "'.__("tax_surf_tax_exist_cons").'"', 'cerfa.tax_log_exist_nb as "'.__("tax_log_exist_nb").'"', 'cerfa.tax_trx_presc_ppr as "'.__("tax_trx_presc_ppr").'"', 'cerfa.tax_monu_hist as "'.__("tax_monu_hist").'"', 'cerfa.tax_comm_nb 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").'"', 'cerfa.vsd_surf_planch_smd as "'.__("vsd_surf_planch_smd").'"', 'cerfa.vsd_unit_fonc_sup as "'.__("vsd_unit_fonc_sup").'"', 'cerfa.vsd_unit_fonc_constr_sup as "'.__("vsd_unit_fonc_constr_sup").'"', 'cerfa.vsd_val_terr as "'.__("vsd_val_terr").'"', 'cerfa.vsd_const_sxist_non_dem_surf as "'.__("vsd_const_sxist_non_dem_surf").'"', 'cerfa.vsd_rescr_fisc as "'.__("vsd_rescr_fisc").'"', 'cerfa.pld_val_terr as "'.__("pld_val_terr").'"', 'cerfa.pld_const_exist_dem as "'.__("pld_const_exist_dem").'"', 'cerfa.pld_const_exist_dem_surf as "'.__("pld_const_exist_dem_surf").'"', 'cerfa.code_cnil as "'.__("code_cnil").'"', 'cerfa.terr_juri_titul as "'.__("terr_juri_titul").'"', 'cerfa.terr_juri_lot as "'.__("terr_juri_lot").'"', 'cerfa.terr_juri_zac as "'.__("terr_juri_zac").'"', 'cerfa.terr_juri_afu as "'.__("terr_juri_afu").'"', 'cerfa.terr_juri_pup as "'.__("terr_juri_pup").'"', 'cerfa.terr_juri_oin as "'.__("terr_juri_oin").'"', 'cerfa.terr_juri_desc as "'.__("terr_juri_desc").'"', 'cerfa.terr_div_surf_etab as "'.__("terr_div_surf_etab").'"', 'cerfa.terr_div_surf_av_div as "'.__("terr_div_surf_av_div").'"', 'cerfa.doc_date as "'.__("doc_date").'"', 'cerfa.doc_tot_trav as "'.__("doc_tot_trav").'"', 'cerfa.doc_tranche_trav as "'.__("doc_tranche_trav").'"', 'cerfa.doc_tranche_trav_desc as "'.__("doc_tranche_trav_desc").'"', 'cerfa.doc_surf as "'.__("doc_surf").'"', 'cerfa.doc_nb_log as "'.__("doc_nb_log").'"', 'cerfa.doc_nb_log_indiv as "'.__("doc_nb_log_indiv").'"', 'cerfa.doc_nb_log_coll as "'.__("doc_nb_log_coll").'"', 'cerfa.doc_nb_log_lls as "'.__("doc_nb_log_lls").'"', 'cerfa.doc_nb_log_aa as "'.__("doc_nb_log_aa").'"', 'cerfa.doc_nb_log_ptz as "'.__("doc_nb_log_ptz").'"', 'cerfa.doc_nb_log_autre as "'.__("doc_nb_log_autre").'"', 'cerfa.daact_date as "'.__("daact_date").'"', 'cerfa.daact_date_chgmt_dest as "'.__("daact_date_chgmt_dest").'"', 'cerfa.daact_tot_trav as "'.__("daact_tot_trav").'"', 'cerfa.daact_tranche_trav as "'.__("daact_tranche_trav").'"', 'cerfa.daact_tranche_trav_desc as "'.__("daact_tranche_trav_desc").'"', 'cerfa.daact_surf as "'.__("daact_surf").'"', 'cerfa.daact_nb_log as "'.__("daact_nb_log").'"', 'cerfa.daact_nb_log_indiv as "'.__("daact_nb_log_indiv").'"', 'cerfa.daact_nb_log_coll as "'.__("daact_nb_log_coll").'"', 'cerfa.daact_nb_log_lls as "'.__("daact_nb_log_lls").'"', 'cerfa.daact_nb_log_aa as "'.__("daact_nb_log_aa").'"', 'cerfa.daact_nb_log_ptz as "'.__("daact_nb_log_ptz").'"', 'cerfa.daact_nb_log_autre as "'.__("daact_nb_log_autre").'"', 'cerfa.am_div_mun as "'.__("am_div_mun").'"', 'cerfa.co_perf_energ as "'.__("co_perf_energ").'"', 'cerfa.architecte as "'.__("architecte").'"', 'cerfa.co_statio_avt_shob as "'.__("co_statio_avt_shob").'"', 'cerfa.co_statio_apr_shob as "'.__("co_statio_apr_shob").'"', 'cerfa.co_statio_avt_surf as "'.__("co_statio_avt_surf").'"', 'cerfa.co_statio_apr_surf as "'.__("co_statio_apr_surf").'"', 'cerfa.co_trx_amgt as "'.__("co_trx_amgt").'"', 'cerfa.co_modif_aspect as "'.__("co_modif_aspect").'"', 'cerfa.co_modif_struct as "'.__("co_modif_struct").'"', 'cerfa.co_ouvr_elec as "'.__("co_ouvr_elec").'"', 'cerfa.co_ouvr_infra as "'.__("co_ouvr_infra").'"', 'cerfa.co_trx_imm as "'.__("co_trx_imm").'"', 'cerfa.co_cstr_shob as "'.__("co_cstr_shob").'"', 'cerfa.am_voyage_deb as "'.__("am_voyage_deb").'"', 'cerfa.am_voyage_fin as "'.__("am_voyage_fin").'"', 'cerfa.am_modif_amgt as "'.__("am_modif_amgt").'"', 'cerfa.am_lot_max_shob as "'.__("am_lot_max_shob").'"', 'cerfa.mod_desc as "'.__("mod_desc").'"', 'cerfa.tr_total as "'.__("tr_total").'"', 'cerfa.tr_partiel as "'.__("tr_partiel").'"', 'cerfa.tr_desc as "'.__("tr_desc").'"', 'cerfa.avap_co_elt_pro as "'.__("avap_co_elt_pro").'"', 'cerfa.avap_nouv_haut_surf as "'.__("avap_nouv_haut_surf").'"', 'cerfa.avap_co_clot as "'.__("avap_co_clot").'"', 'cerfa.avap_aut_coup_aba_arb as "'.__("avap_aut_coup_aba_arb").'"', 'cerfa.avap_ouv_infra as "'.__("avap_ouv_infra").'"', 'cerfa.avap_aut_inst_mob as "'.__("avap_aut_inst_mob").'"', 'cerfa.avap_aut_plant as "'.__("avap_aut_plant").'"', 'cerfa.avap_aut_auv_elec as "'.__("avap_aut_auv_elec").'"', 'cerfa.tax_dest_loc_tr as "'.__("tax_dest_loc_tr").'"', 'cerfa.ope_proj_desc as "'.__("ope_proj_desc").'"', 'cerfa.tax_surf_tot_cstr as "'.__("tax_surf_tot_cstr").'"', 'cerfa.tax_surf_loc_stat as "'.__("tax_surf_loc_stat").'"', 'cerfa.tax_log_ap_trvx_nb as "'.__("tax_log_ap_trvx_nb").'"', 'cerfa.tax_am_statio_ext_cr as "'.__("tax_am_statio_ext_cr").'"', 'cerfa.tax_sup_bass_pisc_cr as "'.__("tax_sup_bass_pisc_cr").'"', 'cerfa.tax_empl_ten_carav_mobil_nb_cr as "'.__("tax_empl_ten_carav_mobil_nb_cr").'"', 'cerfa.tax_empl_hll_nb_cr as "'.__("tax_empl_hll_nb_cr").'"', 'cerfa.tax_eol_haut_nb_cr as "'.__("tax_eol_haut_nb_cr").'"', 'cerfa.tax_pann_volt_sup_cr as "'.__("tax_pann_volt_sup_cr").'"', 'cerfa.tax_surf_loc_arch as "'.__("tax_surf_loc_arch").'"', 'cerfa.tax_surf_pisc_arch as "'.__("tax_surf_pisc_arch").'"', 'cerfa.tax_am_statio_ext_arch as "'.__("tax_am_statio_ext_arch").'"', 'cerfa.tab_tax_su_parc_statio_expl_comm as "'.__("tab_tax_su_parc_statio_expl_comm").'"', 'cerfa.tax_empl_ten_carav_mobil_nb_arch as "'.__("tax_empl_ten_carav_mobil_nb_arch").'"', 'cerfa.tax_empl_hll_nb_arch as "'.__("tax_empl_hll_nb_arch").'"', 'cerfa.tax_eol_haut_nb_arch as "'.__("tax_eol_haut_nb_arch").'"', 'cerfa.ope_proj_div_co as "'.__("ope_proj_div_co").'"', 'cerfa.ope_proj_div_contr as "'.__("ope_proj_div_contr").'"', 'cerfa.tax_desc as "'.__("tax_desc").'"', 'cerfa.erp_cstr_neuve as "'.__("erp_cstr_neuve").'"', 'cerfa.erp_trvx_acc as "'.__("erp_trvx_acc").'"', 'cerfa.erp_extension as "'.__("erp_extension").'"', 'cerfa.erp_rehab as "'.__("erp_rehab").'"', 'cerfa.erp_trvx_am as "'.__("erp_trvx_am").'"', 'cerfa.erp_vol_nouv_exist as "'.__("erp_vol_nouv_exist").'"', 'cerfa.tab_erp_eff as "'.__("tab_erp_eff").'"', 'cerfa.erp_class_cat as "'.__("erp_class_cat").'"', 'cerfa.erp_class_type as "'.__("erp_class_type").'"', 'cerfa.tax_surf_abr_jard_pig_colom as "'.__("tax_surf_abr_jard_pig_colom").'"', 'cerfa.tax_su_non_habit_abr_jard_pig_colom as "'.__("tax_su_non_habit_abr_jard_pig_colom").'"', 'cerfa.dia_imm_non_bati as "'.__("dia_imm_non_bati").'"', 'cerfa.dia_imm_bati_terr_propr as "'.__("dia_imm_bati_terr_propr").'"', 'cerfa.dia_imm_bati_terr_autr as "'.__("dia_imm_bati_terr_autr").'"', 'cerfa.dia_imm_bati_terr_autr_desc as "'.__("dia_imm_bati_terr_autr_desc").'"', 'cerfa.dia_bat_copro as "'.__("dia_bat_copro").'"', 'cerfa.dia_bat_copro_desc as "'.__("dia_bat_copro_desc").'"', 'cerfa.dia_lot_numero as "'.__("dia_lot_numero").'"', 'cerfa.dia_lot_bat as "'.__("dia_lot_bat").'"', 'cerfa.dia_lot_etage as "'.__("dia_lot_etage").'"', 'cerfa.dia_lot_quote_part as "'.__("dia_lot_quote_part").'"', 'cerfa.dia_us_hab as "'.__("dia_us_hab").'"', 'cerfa.dia_us_pro as "'.__("dia_us_pro").'"', 'cerfa.dia_us_mixte as "'.__("dia_us_mixte").'"', 'cerfa.dia_us_comm as "'.__("dia_us_comm").'"', 'cerfa.dia_us_agr as "'.__("dia_us_agr").'"', 'cerfa.dia_us_autre as "'.__("dia_us_autre").'"', 'cerfa.dia_us_autre_prec as "'.__("dia_us_autre_prec").'"', 'cerfa.dia_occ_prop as "'.__("dia_occ_prop").'"', 'cerfa.dia_occ_loc as "'.__("dia_occ_loc").'"', 'cerfa.dia_occ_sans_occ as "'.__("dia_occ_sans_occ").'"', 'cerfa.dia_occ_autre as "'.__("dia_occ_autre").'"', 'cerfa.dia_occ_autre_prec as "'.__("dia_occ_autre_prec").'"', 'cerfa.dia_mod_cess_prix_vente as "'.__("dia_mod_cess_prix_vente").'"', 'cerfa.dia_mod_cess_prix_vente_mob as "'.__("dia_mod_cess_prix_vente_mob").'"', 'cerfa.dia_mod_cess_prix_vente_cheptel as "'.__("dia_mod_cess_prix_vente_cheptel").'"', 'cerfa.dia_mod_cess_prix_vente_recol as "'.__("dia_mod_cess_prix_vente_recol").'"', 'cerfa.dia_mod_cess_prix_vente_autre as "'.__("dia_mod_cess_prix_vente_autre").'"', 'cerfa.dia_mod_cess_commi as "'.__("dia_mod_cess_commi").'"', 'cerfa.dia_mod_cess_commi_ttc as "'.__("dia_mod_cess_commi_ttc").'"', 'cerfa.dia_mod_cess_commi_ht as "'.__("dia_mod_cess_commi_ht").'"', 'cerfa.dia_acquereur_nom_prenom as "'.__("dia_acquereur_nom_prenom").'"', 'cerfa.dia_acquereur_adr_num_voie as "'.__("dia_acquereur_adr_num_voie").'"', 'cerfa.dia_acquereur_adr_ext as "'.__("dia_acquereur_adr_ext").'"', 'cerfa.dia_acquereur_adr_type_voie as "'.__("dia_acquereur_adr_type_voie").'"', 'cerfa.dia_acquereur_adr_nom_voie as "'.__("dia_acquereur_adr_nom_voie").'"', 'cerfa.dia_acquereur_adr_lieu_dit_bp as "'.__("dia_acquereur_adr_lieu_dit_bp").'"', 'cerfa.dia_acquereur_adr_cp as "'.__("dia_acquereur_adr_cp").'"', 'cerfa.dia_acquereur_adr_localite as "'.__("dia_acquereur_adr_localite").'"', 'cerfa.dia_observation as "'.__("dia_observation").'"', 'cerfa.tab_surface2 as "'.__("tab_surface2").'"', 'cerfa.dia_occ_sol_su_terre as "'.__("dia_occ_sol_su_terre").'"', 'cerfa.dia_occ_sol_su_pres as "'.__("dia_occ_sol_su_pres").'"', 'cerfa.dia_occ_sol_su_verger as "'.__("dia_occ_sol_su_verger").'"', 'cerfa.dia_occ_sol_su_vigne as "'.__("dia_occ_sol_su_vigne").'"', 'cerfa.dia_occ_sol_su_bois as "'.__("dia_occ_sol_su_bois").'"', 'cerfa.dia_occ_sol_su_lande as "'.__("dia_occ_sol_su_lande").'"', 'cerfa.dia_occ_sol_su_carriere as "'.__("dia_occ_sol_su_carriere").'"', 'cerfa.dia_occ_sol_su_eau_cadastree as "'.__("dia_occ_sol_su_eau_cadastree").'"', 'cerfa.dia_occ_sol_su_jardin as "'.__("dia_occ_sol_su_jardin").'"', 'cerfa.dia_occ_sol_su_terr_batir as "'.__("dia_occ_sol_su_terr_batir").'"', 'cerfa.dia_occ_sol_su_terr_agr as "'.__("dia_occ_sol_su_terr_agr").'"', 'cerfa.dia_occ_sol_su_sol as "'.__("dia_occ_sol_su_sol").'"', 'cerfa.dia_bati_vend_tot as "'.__("dia_bati_vend_tot").'"', 'cerfa.dia_bati_vend_tot_txt as "'.__("dia_bati_vend_tot_txt").'"', 'cerfa.dia_su_co_sol as "'.__("dia_su_co_sol").'"', 'cerfa.dia_su_util_hab as "'.__("dia_su_util_hab").'"', 'cerfa.dia_nb_niv as "'.__("dia_nb_niv").'"', 'cerfa.dia_nb_appart as "'.__("dia_nb_appart").'"', 'cerfa.dia_nb_autre_loc as "'.__("dia_nb_autre_loc").'"', 'cerfa.dia_vente_lot_volume as "'.__("dia_vente_lot_volume").'"', 'cerfa.dia_vente_lot_volume_txt as "'.__("dia_vente_lot_volume_txt").'"', 'cerfa.dia_lot_nat_su as "'.__("dia_lot_nat_su").'"', 'cerfa.dia_lot_bat_achv_plus_10 as "'.__("dia_lot_bat_achv_plus_10").'"', 'cerfa.dia_lot_bat_achv_moins_10 as "'.__("dia_lot_bat_achv_moins_10").'"', 'cerfa.dia_lot_regl_copro_publ_hypo_plus_10 as "'.__("dia_lot_regl_copro_publ_hypo_plus_10").'"', 'cerfa.dia_lot_regl_copro_publ_hypo_moins_10 as "'.__("dia_lot_regl_copro_publ_hypo_moins_10").'"', 'cerfa.dia_indivi_quote_part as "'.__("dia_indivi_quote_part").'"', 'cerfa.dia_design_societe as "'.__("dia_design_societe").'"', 'cerfa.dia_design_droit as "'.__("dia_design_droit").'"', 'cerfa.dia_droit_soc_nat as "'.__("dia_droit_soc_nat").'"', 'cerfa.dia_droit_soc_nb as "'.__("dia_droit_soc_nb").'"', 'cerfa.dia_droit_soc_num_part as "'.__("dia_droit_soc_num_part").'"', 'cerfa.dia_droit_reel_perso_grevant_bien_oui as "'.__("dia_droit_reel_perso_grevant_bien_oui").'"', 'cerfa.dia_droit_reel_perso_grevant_bien_non as "'.__("dia_droit_reel_perso_grevant_bien_non").'"', 'cerfa.dia_droit_reel_perso_nat as "'.__("dia_droit_reel_perso_nat").'"', 'cerfa.dia_droit_reel_perso_viag as "'.__("dia_droit_reel_perso_viag").'"', 'cerfa.dia_mod_cess_adr as "'.__("dia_mod_cess_adr").'"', 'cerfa.dia_mod_cess_sign_act_auth as "'.__("dia_mod_cess_sign_act_auth").'"', 'cerfa.dia_mod_cess_terme as "'.__("dia_mod_cess_terme").'"', 'cerfa.dia_mod_cess_terme_prec as "'.__("dia_mod_cess_terme_prec").'"', 'cerfa.dia_mod_cess_bene_acquereur as "'.__("dia_mod_cess_bene_acquereur").'"', 'cerfa.dia_mod_cess_bene_vendeur as "'.__("dia_mod_cess_bene_vendeur").'"', 'cerfa.dia_mod_cess_paie_nat as "'.__("dia_mod_cess_paie_nat").'"', 'cerfa.dia_mod_cess_design_contr_alien as "'.__("dia_mod_cess_design_contr_alien").'"', 'cerfa.dia_mod_cess_eval_contr as "'.__("dia_mod_cess_eval_contr").'"', 'cerfa.dia_mod_cess_rente_viag as "'.__("dia_mod_cess_rente_viag").'"', 'cerfa.dia_mod_cess_mnt_an as "'.__("dia_mod_cess_mnt_an").'"', 'cerfa.dia_mod_cess_mnt_compt as "'.__("dia_mod_cess_mnt_compt").'"', 'cerfa.dia_mod_cess_bene_rente as "'.__("dia_mod_cess_bene_rente").'"', 'cerfa.dia_mod_cess_droit_usa_hab as "'.__("dia_mod_cess_droit_usa_hab").'"', 'cerfa.dia_mod_cess_droit_usa_hab_prec as "'.__("dia_mod_cess_droit_usa_hab_prec").'"', 'cerfa.dia_mod_cess_eval_usa_usufruit as "'.__("dia_mod_cess_eval_usa_usufruit").'"', 'cerfa.dia_mod_cess_vente_nue_prop as "'.__("dia_mod_cess_vente_nue_prop").'"', 'cerfa.dia_mod_cess_vente_nue_prop_prec as "'.__("dia_mod_cess_vente_nue_prop_prec").'"', 'cerfa.dia_mod_cess_echange as "'.__("dia_mod_cess_echange").'"', 'cerfa.dia_mod_cess_design_bien_recus_ech as "'.__("dia_mod_cess_design_bien_recus_ech").'"', 'cerfa.dia_mod_cess_mnt_soulte as "'.__("dia_mod_cess_mnt_soulte").'"', 'cerfa.dia_mod_cess_prop_contre_echan as "'.__("dia_mod_cess_prop_contre_echan").'"', 'cerfa.dia_mod_cess_apport_societe as "'.__("dia_mod_cess_apport_societe").'"', 'cerfa.dia_mod_cess_bene as "'.__("dia_mod_cess_bene").'"', 'cerfa.dia_mod_cess_esti_bien as "'.__("dia_mod_cess_esti_bien").'"', 'cerfa.dia_mod_cess_cess_terr_loc_co as "'.__("dia_mod_cess_cess_terr_loc_co").'"', 'cerfa.dia_mod_cess_esti_terr as "'.__("dia_mod_cess_esti_terr").'"', 'cerfa.dia_mod_cess_esti_loc as "'.__("dia_mod_cess_esti_loc").'"', 'cerfa.dia_mod_cess_esti_imm_loca as "'.__("dia_mod_cess_esti_imm_loca").'"', 'cerfa.dia_mod_cess_adju_vol as "'.__("dia_mod_cess_adju_vol").'"', 'cerfa.dia_mod_cess_adju_obl as "'.__("dia_mod_cess_adju_obl").'"', 'cerfa.dia_mod_cess_adju_fin_indivi as "'.__("dia_mod_cess_adju_fin_indivi").'"', 'cerfa.dia_mod_cess_adju_date_lieu as "'.__("dia_mod_cess_adju_date_lieu").'"', 'cerfa.dia_mod_cess_mnt_mise_prix as "'.__("dia_mod_cess_mnt_mise_prix").'"', 'cerfa.dia_prop_titu_prix_indique as "'.__("dia_prop_titu_prix_indique").'"', 'cerfa.dia_prop_recherche_acqu_prix_indique as "'.__("dia_prop_recherche_acqu_prix_indique").'"', 'cerfa.dia_acquereur_prof as "'.__("dia_acquereur_prof").'"', 'cerfa.dia_indic_compl_ope as "'.__("dia_indic_compl_ope").'"', 'cerfa.dia_vente_adju as "'.__("dia_vente_adju").'"', 'cerfa.am_terr_res_demon as "'.__("am_terr_res_demon").'"', 'cerfa.am_air_terr_res_mob as "'.__("am_air_terr_res_mob").'"', 'cerfa.ctx_objet_recours as "'.__("ctx_objet_recours").'"', 'cerfa.ctx_moyen_souleve as "'.__("ctx_moyen_souleve").'"', 'cerfa.ctx_moyen_retenu_juge as "'.__("ctx_moyen_retenu_juge").'"', 'cerfa.ctx_reference_sagace as "'.__("ctx_reference_sagace").'"', 'cerfa.ctx_nature_travaux_infra_om_html as "'.__("ctx_nature_travaux_infra_om_html").'"', 'cerfa.ctx_synthese_nti as "'.__("ctx_synthese_nti").'"', 'cerfa.ctx_article_non_resp_om_html as "'.__("ctx_article_non_resp_om_html").'"', 'cerfa.ctx_synthese_anr as "'.__("ctx_synthese_anr").'"', 'cerfa.ctx_reference_parquet as "'.__("ctx_reference_parquet").'"', 'cerfa.ctx_element_taxation as "'.__("ctx_element_taxation").'"', 'cerfa.ctx_infraction as "'.__("ctx_infraction").'"', 'cerfa.ctx_regularisable as "'.__("ctx_regularisable").'"', 'cerfa.ctx_reference_courrier as "'.__("ctx_reference_courrier").'"', 'cerfa.ctx_date_audience as "'.__("ctx_date_audience").'"', 'cerfa.ctx_date_ajournement as "'.__("ctx_date_ajournement").'"', 'cerfa.exo_facul_1 as "'.__("exo_facul_1").'"', 'cerfa.exo_facul_2 as "'.__("exo_facul_2").'"', 'cerfa.exo_facul_3 as "'.__("exo_facul_3").'"', 'cerfa.exo_facul_4 as "'.__("exo_facul_4").'"', 'cerfa.exo_facul_5 as "'.__("exo_facul_5").'"', 'cerfa.exo_facul_6 as "'.__("exo_facul_6").'"', 'cerfa.exo_facul_7 as "'.__("exo_facul_7").'"', 'cerfa.exo_facul_8 as "'.__("exo_facul_8").'"', 'cerfa.exo_facul_9 as "'.__("exo_facul_9").'"', 'cerfa.exo_ta_1 as "'.__("exo_ta_1").'"', 'cerfa.exo_ta_2 as "'.__("exo_ta_2").'"', 'cerfa.exo_ta_3 as "'.__("exo_ta_3").'"', 'cerfa.exo_ta_4 as "'.__("exo_ta_4").'"', 'cerfa.exo_ta_5 as "'.__("exo_ta_5").'"', 'cerfa.exo_ta_6 as "'.__("exo_ta_6").'"', 'cerfa.exo_ta_7 as "'.__("exo_ta_7").'"', 'cerfa.exo_ta_8 as "'.__("exo_ta_8").'"', 'cerfa.exo_ta_9 as "'.__("exo_ta_9").'"', 'cerfa.exo_rap_1 as "'.__("exo_rap_1").'"', 'cerfa.exo_rap_2 as "'.__("exo_rap_2").'"', 'cerfa.exo_rap_3 as "'.__("exo_rap_3").'"', 'cerfa.exo_rap_4 as "'.__("exo_rap_4").'"', 'cerfa.exo_rap_5 as "'.__("exo_rap_5").'"', 'cerfa.exo_rap_6 as "'.__("exo_rap_6").'"', 'cerfa.exo_rap_7 as "'.__("exo_rap_7").'"', 'cerfa.exo_rap_8 as "'.__("exo_rap_8").'"', 'cerfa.mtn_exo_ta_part_commu as "'.__("mtn_exo_ta_part_commu").'"', 'cerfa.mtn_exo_ta_part_depart as "'.__("mtn_exo_ta_part_depart").'"', 'cerfa.mtn_exo_ta_part_reg as "'.__("mtn_exo_ta_part_reg").'"', 'cerfa.mtn_exo_rap as "'.__("mtn_exo_rap").'"', 'cerfa.dpc_type as "'.__("dpc_type").'"', 'cerfa.dpc_desc_actv_ex as "'.__("dpc_desc_actv_ex").'"', 'cerfa.dpc_desc_ca as "'.__("dpc_desc_ca").'"', 'cerfa.dpc_desc_aut_prec as "'.__("dpc_desc_aut_prec").'"', 'cerfa.dpc_desig_comm_arti as "'.__("dpc_desig_comm_arti").'"', 'cerfa.dpc_desig_loc_hab as "'.__("dpc_desig_loc_hab").'"', 'cerfa.dpc_desig_loc_ann as "'.__("dpc_desig_loc_ann").'"', 'cerfa.dpc_desig_loc_ann_prec as "'.__("dpc_desig_loc_ann_prec").'"', 'cerfa.dpc_bail_comm_date as "'.__("dpc_bail_comm_date").'"', 'cerfa.dpc_bail_comm_loyer as "'.__("dpc_bail_comm_loyer").'"', 'cerfa.dpc_actv_acqu as "'.__("dpc_actv_acqu").'"', 'cerfa.dpc_nb_sala_di as "'.__("dpc_nb_sala_di").'"', 'cerfa.dpc_nb_sala_dd as "'.__("dpc_nb_sala_dd").'"', 'cerfa.dpc_nb_sala_tc as "'.__("dpc_nb_sala_tc").'"', 'cerfa.dpc_nb_sala_tp as "'.__("dpc_nb_sala_tp").'"', 'cerfa.dpc_moda_cess_vente_am as "'.__("dpc_moda_cess_vente_am").'"', 'cerfa.dpc_moda_cess_adj as "'.__("dpc_moda_cess_adj").'"', 'cerfa.dpc_moda_cess_prix as "'.__("dpc_moda_cess_prix").'"', 'cerfa.dpc_moda_cess_adj_date as "'.__("dpc_moda_cess_adj_date").'"', 'cerfa.dpc_moda_cess_adj_prec as "'.__("dpc_moda_cess_adj_prec").'"', 'cerfa.dpc_moda_cess_paie_comp as "'.__("dpc_moda_cess_paie_comp").'"', 'cerfa.dpc_moda_cess_paie_terme as "'.__("dpc_moda_cess_paie_terme").'"', 'cerfa.dpc_moda_cess_paie_terme_prec as "'.__("dpc_moda_cess_paie_terme_prec").'"', 'cerfa.dpc_moda_cess_paie_nat as "'.__("dpc_moda_cess_paie_nat").'"', 'cerfa.dpc_moda_cess_paie_nat_desig_alien as "'.__("dpc_moda_cess_paie_nat_desig_alien").'"', 'cerfa.dpc_moda_cess_paie_nat_desig_alien_prec as "'.__("dpc_moda_cess_paie_nat_desig_alien_prec").'"', 'cerfa.dpc_moda_cess_paie_nat_eval as "'.__("dpc_moda_cess_paie_nat_eval").'"', 'cerfa.dpc_moda_cess_paie_nat_eval_prec as "'.__("dpc_moda_cess_paie_nat_eval_prec").'"', 'cerfa.dpc_moda_cess_paie_aut as "'.__("dpc_moda_cess_paie_aut").'"', 'cerfa.dpc_moda_cess_paie_aut_prec as "'.__("dpc_moda_cess_paie_aut_prec").'"', 'cerfa.dpc_ss_signe_demande_acqu as "'.__("dpc_ss_signe_demande_acqu").'"', 'cerfa.dpc_ss_signe_recher_trouv_acqu as "'.__("dpc_ss_signe_recher_trouv_acqu").'"', 'cerfa.dpc_notif_adr_prop as "'.__("dpc_notif_adr_prop").'"', 'cerfa.dpc_notif_adr_manda as "'.__("dpc_notif_adr_manda").'"', 'cerfa.dpc_obs as "'.__("dpc_obs").'"', 'cerfa.co_peri_site_patri_remar as "'.__("co_peri_site_patri_remar").'"', 'cerfa.co_abo_monu_hist as "'.__("co_abo_monu_hist").'"', 'cerfa.co_inst_ouvr_trav_act_code_envir as "'.__("co_inst_ouvr_trav_act_code_envir").'"', 'cerfa.co_trav_auto_env as "'.__("co_trav_auto_env").'"', 'cerfa.co_derog_esp_prot as "'.__("co_derog_esp_prot").'"', 'cerfa.ctx_reference_dsj as "'.__("ctx_reference_dsj").'"', ); // $champRecherche = array( 'cerfa.cerfa as "'.__("cerfa").'"', 'cerfa.libelle as "'.__("libelle").'"', 'cerfa.code as "'.__("code").'"', ); $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', );