debug get_dg_package_choix> initialisation 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #35 => _SESSION[ 'nb_entites' ]=1 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #142 => rech_resa_arr=20250905 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #143 => num_jr=4 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #145 => dt_fin_dem=20250909 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #146 => nb_nuites_dem=5 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #147 => nb_nuites_dem=5 03/09/2025 00:42:44 [ inc_reche_entite_geo.php ] #38 => code_pays_rech = FRA 03/09/2025 00:42:44 [ inc_reche_entite_geo.php ] #39 => region_rech = alpes cote de provence 03/09/2025 00:42:44 [ inc_reche_entite_geo.php ] #40 => ville_rech = Marseille 03/09/2025 00:42:44 [ inc_reche_entite_geo.php ] #41 => quartier_rech = 03/09/2025 00:42:44 [ inc_recherche_longi_lati.php ] #29 => query_gps =>SELECT MAX( longi_dd ) AS max_longi, MIN( longi_dd ) AS min_longi, MAX( lati_dd ) AS max_lati, MIN( lati_dd ) AS min_lati FROM xpr_dg_entites WHERE act <> 'I' AND fk_status <> 'DLT' AND xpr_dg_entites.fk_pays = 'FRA' AND xpr_dg_entites.etat_region = 'alpes cote de provence' AND xpr_dg_entites.ville = 'Marseille' 03/09/2025 00:42:44 [ inc_recherche_longi_lati.php ] #34 => query_gps =>SELECT MAX( longi_dd ) AS max_longi, MIN( longi_dd ) AS min_longi, MAX( lati_dd ) AS max_lati, MIN( lati_dd ) AS min_lati FROM xpr_dg_entites WHERE act <> 'I' AND fk_status <> 'DLT' AND xpr_dg_entites.fk_pays = 'FRA' AND xpr_dg_entites.etat_region = 'alpes cote de provence' AND xpr_dg_entites.ville = 'Marseille' 03/09/2025 00:42:44 [ inc_recherche_longi_lati.php ] #166 => sql_latitude = AND lati_dd BETWEEN 40.126952499685 AND 46.427015500315 03/09/2025 00:42:44 [ inc_recherche_longi_lati.php ] #167 => sql_longitude = AND longi_dd BETWEEN 1.0777120913837 AND 9.7310719086163 03/09/2025 00:42:44 [ inc_reche_entite_geo.php ] #174 => QUERY = SELECT xpr_dg_entites.entite, xpr_dg_entites.ent_geo, dg_package.code_pac, dg_type_heb.cat_type_heb FROM du_cat_type_heb JOIN ( dg_type_heb JOIN ( dg_package JOIN ( xpr_dg_entites JOIN di_options ON xpr_dg_entites.entite = di_options.fk_entite ) ON xpr_dg_entites.ent_geo = dg_package.fk_ent_geo ) ON dg_package.fk_type_heb = dg_type_heb.type_heb ) ON du_cat_type_heb.cat_type_heb = dg_type_heb.cat_type_heb WHERE du_cat_type_heb.cat_type_rech = 4 AND dg_package.nb_pax = 3 AND xpr_dg_entites.act <> 'I' AND xpr_dg_entites.fk_status <> 'DLT' AND du_cat_type_heb.act <> 'I' AND du_cat_type_heb.fk_status <> 'DLT' AND dg_package.act <> 'I' AND dg_package.fk_status <> 'DLT' AND lati_dd BETWEEN 40.126952499685 AND 46.427015500315 AND longi_dd BETWEEN 1.0777120913837 AND 9.7310719086163 AND di_options.mode_tva_tf <> '2' 03/09/2025 00:42:44 [ inc_reche_entite_geo.php ] #209 => sql_fk_entite_glo='ridba002' 03/09/2025 00:42:44 [ inc_reche_entite_geo.php ] #210 => cum_fk_ent_geo= 03/09/2025 00:42:44 [ inc_reche_entite_geo.php ] #211 => cum_fk_pac_glo= 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #216 => sql_fk_ent_geo= AND dg_package.fk_ent_geo IN ( ) 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #217 => sql_temp_pac_ent_geo= AND temp_package_choix_68b6c27e8b719.fk_ent_geo IN ( ) 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #218 => sql_fk_pac_glo= AND dg_package.code_pac IN ( ) 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #297 => sql_fk_entite_glo='ridba002'--- 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #298 => sql_package_plateforme= AND dg_package.site_web = '1' --- 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #299 => sql_fk_ent_geo= AND dg_package.fk_ent_geo IN ( ) --- 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #300 => sql_fk_pac_glo= AND dg_package.code_pac IN ( ) --- 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #457 => QUERY387=(SELECT dg_package.fk_entite, dg_package.fk_ent_geo, dg_package.cpt_promo, dg_package.compteur_tf, dg_package.code_pac, dg_package.nb_nts, dg_package.nb_pax, dg_package.fk_type_heb, dg_type_heb_lang.intitule AS intitule_type_heb, dg_package_lang.intitule AS intitule_pac, dg_package_lang.descro AS descro_pac, '' AS date_debut, '' AS date_fin FROM dg_package_lang JOIN ( dg_type_heb_lang JOIN (dg_package JOIN dg_type_heb ON dg_package.fk_type_heb = dg_type_heb.type_heb) ON dg_package.fk_type_heb = dg_type_heb_lang.type_heb) ON dg_package.code_pac = dg_package_lang.fk_code_pac WHERE dg_package.fk_entite = dg_package_lang.fk_entite AND dg_package.fk_entite IN ( 'ridba002' ) AND dg_package_lang.fk_entite IN ( 'ridba002' ) AND dg_type_heb.fk_entite IN ( 'ridba002' ) AND dg_package.site_web = '1' AND dg_package.fk_ent_geo IN ( ) AND dg_package.code_pac IN ( ) AND dg_package.pas_de_solu = '0' AND dg_package.periodes_tf = '0' AND ( dg_package.compteur_tf = '0' OR ( dg_package.compteur_tf = '1' AND dg_package.cpt_promo > 1 ) ) AND dg_type_heb_lang.lang = 'FR' AND dg_package_lang.lang = 'FR' AND dg_package.act <> 'I' AND dg_type_heb.act <> 'I' AND dg_package.fk_status NOT IN ( 'DLT', 'ACT' ) AND dg_package_lang.fk_status NOT IN ( 'DLT' ) AND dg_type_heb.fk_status NOT IN ( 'DLT' ) AND dg_type_heb_lang.fk_status NOT IN ( 'DLT' ) AND dg_package.nb_pax = 3 AND dg_package.nb_nts <= 5 ) UNION ( SELECT dg_package.fk_entite, dg_package.fk_ent_geo, dg_package.cpt_promo, dg_package.compteur_tf, dg_package.code_pac, dg_package.nb_nts, dg_package.nb_pax, dg_package.fk_type_heb, dg_type_heb_lang.intitule, dg_package_lang.intitule AS intitule_pac, dg_package_lang.descro AS descro_pac, dg_package_periodes.date_debut, dg_package_periodes.date_fin FROM dg_package_lang JOIN ( dg_type_heb_lang JOIN ( dg_type_heb JOIN ( dg_package JOIN dg_package_periodes ON dg_package.code_pac = dg_package_periodes.fk_code_pac ) ON dg_package.fk_type_heb = dg_type_heb.type_heb ) ON dg_package.fk_type_heb = dg_type_heb_lang.type_heb ) ON dg_package.code_pac = dg_package_lang.fk_code_pac WHERE dg_package.fk_entite = dg_package_lang.fk_entite AND dg_package.fk_entite = dg_package_periodes.fk_entite AND dg_package_periodes.fk_status <> 'DLT' AND dg_type_heb.fk_status NOT IN ( 'DLT' ) AND dg_type_heb_lang.fk_status NOT IN ( 'DLT' ) AND dg_package.fk_entite IN ( 'ridba002' ) AND dg_package_lang.fk_entite IN ( 'ridba002' ) AND dg_package_periodes.fk_entite IN ( 'ridba002' ) AND dg_type_heb.fk_entite IN ( 'ridba002' ) AND dg_package.site_web = '1' AND dg_package.fk_ent_geo IN ( ) AND dg_package.code_pac IN ( ) AND dg_package.pas_de_solu = '0' AND dg_package.periodes_tf = '1' AND ( dg_package.compteur_tf = '0' OR ( dg_package.compteur_tf = '1' AND dg_package.cpt_promo > 1 ) ) AND dg_type_heb_lang.lang = 'FR' AND dg_package_lang.lang = 'FR' AND dg_package.act <> 'I' AND dg_type_heb.act <> 'I' AND dg_package.fk_status NOT IN ( 'DLT', 'ACT' ) AND dg_package_lang.fk_status NOT IN ( 'DLT' ) AND dg_package.nb_pax = 3 AND dg_package.nb_nts <= 5 ) ORDER BY fk_entite, code_pac, date_debut 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #459 => sql_fk_pac_glo1= AND dg_package.code_pac IN ( ) --- 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #562 => sql_fk_pac_glo3= AND dg_package.code_pac IN ( ) --- 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #622 => sql_cum_type_heb_pac= AND dg_type_heb.type_heb IN ( ) 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #647 => query_tarif=SELECT dg_package_hor.fk_entite, dg_package_hor.fk_ent_geo, temp_package_choix_68b6c27e8b719.code_pac AS fk_code_pac, temp_package_choix_68b6c27e8b719.fk_type_heb, hor_deb_bas, hor_fin_bas, hor_deb_hte, hor_fin_hte, hor_deb_tha, hor_fin_tha FROM dg_package_hor JOIN temp_package_choix_68b6c27e8b719 ON dg_package_hor.fk_code_pac = temp_package_choix_68b6c27e8b719.code_pac WHERE jr_sem = ? AND partie = 2 AND temp_package_choix_68b6c27e8b719.fk_entite IN ( 'ridba002' ) AND dg_package_hor.fk_entite IN ( 'ridba002' ) 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #648 => num_jr=4 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #649 => nb_pac_hor=0 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #671 => nb_pac_hor=0 03/09/2025 00:42:44 [ inc_cherche_liste_options.php ] #27 => row['fk_entite']=ridba002 03/09/2025 00:42:44 [ inc_cherche_liste_options.php ] #28 => nb_jrs_option_mosai=1 03/09/2025 00:42:44 [ inc_cherche_liste_options.php ] #29 => rech_mosai= 03/09/2025 00:42:44 [ inc_ins_temp_jrs_libre.php ] #73 => hor_resa_tf= 03/09/2025 00:42:44 [ inc_ins_temp_jrs_libre.php ] #151 => query_change=SELECT val_achat AS val_change FROM dg_change WHERE code_devise = 'USD' AND val_banque <> 0 ORDER BY date_change DESC LIMIT 1 03/09/2025 00:42:44 [ inc_ins_temp_jrs_libre.php ] #168 => hor_resa_tf= 03/09/2025 00:42:44 [ inc_ins_temp_jrs_libre.php ] #211 => hor_resa_tf= 03/09/2025 00:42:44 [ inc_ins_temp_jrs_libre.php ] #262 => query_tarif=SELECT dg_tarifs.fk_entite, dg_tarifs.fk_type_heb, dg_type_heb.pers_forfait, dg_tarifs.px_bas_heb, dg_tarifs.c_px_bas_heb, dg_tarifs.px_hte_heb, dg_tarifs.c_px_hte_heb, dg_tarifs.px_tha_heb, dg_tarifs.c_px_tha_heb, dg_tarifs.px_bas_hor, dg_tarifs.c_px_bas_hor, dg_tarifs.px_hte_hor, dg_tarifs.c_px_hte_hor, dg_tarifs.px_tha_hor, dg_tarifs.c_px_tha_hor FROM rofl0364_xpr.du_cat_type_heb JOIN ( dg_tarifs JOIN dg_type_heb ON dg_tarifs.fk_type_heb = dg_type_heb.type_heb ) ON rofl0364_xpr.du_cat_type_heb.cat_type_heb = dg_type_heb.cat_type_heb WHERE dg_type_heb.act <> 'I' AND rofl0364_xpr.du_cat_type_heb.act <> 'I' AND dg_type_heb.fk_status NOT IN ( 'DLT' ) AND dg_tarifs.fk_status NOT IN ( 'DLT' ) AND rofl0364_xpr.du_cat_type_heb.fk_status NOT IN ( 'DLT' ) AND dg_tarifs.fk_entite IN ( 'ridba002' ) AND dg_type_heb.fk_entite IN ( 'ridba002' ) AND rofl0364_xpr.du_cat_type_heb.cat_type_rech = 4 03/09/2025 00:42:44 [ inc_ins_temp_jrs_libre.php ] #286 => code_package= 03/09/2025 00:42:44 [ inc_ins_temp_jrs_libre.php ] #287 => query_tarif=SELECT dg_tarifs.fk_entite, dg_tarifs.fk_type_heb, dg_type_heb.pers_forfait, dg_tarifs.px_bas_heb, dg_tarifs.c_px_bas_heb, dg_tarifs.px_hte_heb, dg_tarifs.c_px_hte_heb, dg_tarifs.px_tha_heb, dg_tarifs.c_px_tha_heb, dg_tarifs.px_bas_hor, dg_tarifs.c_px_bas_hor, dg_tarifs.px_hte_hor, dg_tarifs.c_px_hte_hor, dg_tarifs.px_tha_hor, dg_tarifs.c_px_tha_hor FROM rofl0364_xpr.du_cat_type_heb JOIN ( dg_tarifs JOIN dg_type_heb ON dg_tarifs.fk_type_heb = dg_type_heb.type_heb ) ON rofl0364_xpr.du_cat_type_heb.cat_type_heb = dg_type_heb.cat_type_heb WHERE dg_type_heb.act <> 'I' AND rofl0364_xpr.du_cat_type_heb.act <> 'I' AND dg_type_heb.fk_status NOT IN ( 'DLT' ) AND dg_tarifs.fk_status NOT IN ( 'DLT' ) AND rofl0364_xpr.du_cat_type_heb.fk_status NOT IN ( 'DLT' ) AND dg_tarifs.fk_entite IN ( 'ridba002' ) AND dg_type_heb.fk_entite IN ( 'ridba002' ) AND rofl0364_xpr.du_cat_type_heb.cat_type_rech = 4 03/09/2025 00:42:44 [ inc_ins_temp_jrs_libre.php ] #288 => nb_type_heb=0 03/09/2025 00:42:44 [ inc_ins_temp_jrs_libre.php ] #315 => jrs_dates_package= 03/09/2025 00:42:44 [ inc_ins_temp_jrs_libre.php ] #316 => val_jrs_dates_package=Array 03/09/2025 00:42:44 [ inc_ins_temp_jrs_libre.php ] #357 => query=SELECT dg_package.fk_entite, dg_package.code_pac, dg_package.fk_type_heb, dg_package.pers_forfait, dg_package_tarif.px_bas_pac, dg_package_tarif.c_px_bas_pac, dg_package_tarif.px_hte_pac, dg_package_tarif.c_px_hte_pac, dg_package_tarif.px_tha_pac, dg_package_tarif.c_px_tha_pac FROM rofl0364_xpr.du_cat_type_heb JOIN ( dg_package_tarif JOIN (dg_package JOIN dg_type_heb ON dg_package.fk_type_heb = dg_type_heb.type_heb) ON dg_package_tarif.fk_code_pac = dg_package.code_pac) ON rofl0364_xpr.du_cat_type_heb.cat_type_heb = dg_type_heb.cat_type_heb WHERE dg_type_heb.act <> 'I' AND dg_package.nuitee_horaire = '1' AND rofl0364_xpr.du_cat_type_heb.act <> 'I' AND dg_package.fk_status NOT IN ( 'DLT' ) AND dg_package_tarif.fk_status NOT IN ( 'DLT' ) AND dg_type_heb.fk_status NOT IN ( 'DLT' ) AND rofl0364_xpr.du_cat_type_heb.fk_status NOT IN ( 'DLT' ) AND dg_package.fk_entite IN ( 'ridba002' ) AND dg_type_heb.fk_entite IN ( 'ridba002' ) AND dg_package_tarif.fk_entite IN ( 'ridba002' ) AND rofl0364_xpr.du_cat_type_heb.cat_type_rech = 4 03/09/2025 00:42:44 [ inc_ins_temp_jrs_libre.php ] #387 => query=SELECT dg_package.fk_entite, dg_package.code_pac, dg_package.fk_type_heb, dg_package.pers_forfait, dg_package_tarif.px_bas_pac, dg_package_tarif.c_px_bas_pac, dg_package_tarif.px_hte_pac, dg_package_tarif.c_px_hte_pac, dg_package_tarif.px_tha_pac, dg_package_tarif.c_px_tha_pac FROM rofl0364_xpr.du_cat_type_heb JOIN ( dg_package_tarif JOIN (dg_package JOIN dg_type_heb ON dg_package.fk_type_heb = dg_type_heb.type_heb) ON dg_package_tarif.fk_code_pac = dg_package.code_pac) ON rofl0364_xpr.du_cat_type_heb.cat_type_heb = dg_type_heb.cat_type_heb WHERE dg_type_heb.act <> 'I' AND dg_package.nuitee_horaire = '1' AND rofl0364_xpr.du_cat_type_heb.act <> 'I' AND dg_package.fk_status NOT IN ( 'DLT' ) AND dg_package_tarif.fk_status NOT IN ( 'DLT' ) AND dg_type_heb.fk_status NOT IN ( 'DLT' ) AND rofl0364_xpr.du_cat_type_heb.fk_status NOT IN ( 'DLT' ) AND dg_package.fk_entite IN ( 'ridba002' ) AND dg_type_heb.fk_entite IN ( 'ridba002' ) AND dg_package_tarif.fk_entite IN ( 'ridba002' ) AND rofl0364_xpr.du_cat_type_heb.cat_type_rech = 4 03/09/2025 00:42:44 [ inc_ins_temp_jrs_libre.php ] #563 => sql_reche_type_heb= 03/09/2025 00:42:44 [ inc_ins_temp_jrs_libre.php ] #577 => sql_reche_hors_ota= AND dg_type_heb_rows.alloc_ota = '0' 03/09/2025 00:42:44 [ inc_ins_temp_jrs_libre.php ] #591 => hor_resa_tf= 03/09/2025 00:42:44 [ inc_ins_temp_jrs_libre.php ] #593 => rech_resa_arr2=20250905 03/09/2025 00:42:44 [ inc_ins_temp_jrs_libre.php ] #595 => rech_resa_arr2=20250905 03/09/2025 00:42:44 [ inc_ins_temp_jrs_libre.php ] #606 => query=SELECT 'ridba002' AS fk_entite , jrs_cal, saison, fermeture FROM dg_jrs_calendrier WHERE fermeture <> '1' AND jrs_cal BETWEEN '20250905' AND '20250909' 03/09/2025 00:42:44 [ inc_ins_temp_jrs_libre.php ] #637 => w=5 03/09/2025 00:42:44 [ inc_ins_temp_jrs_libre.php ] #677 => query=SELECT dg_calendrier.fk_entite, dg_calendrier.dt_resa_cal, dg_type_heb_rows.code_heb, '' AS hor_resa_cal, 0 AS sum_nb_pax FROM dg_type_heb_rows JOIN dg_calendrier ON dg_type_heb_rows.code_heb = dg_calendrier.fk_code_heb WHERE dg_calendrier.dt_resa_cal BETWEEN '20250905' AND '20250909' AND dg_calendrier.fk_facture NOT LIKE '%T%' AND dg_type_heb_rows.fk_status NOT IN ( 'DLT' ) AND dg_calendrier.fk_code_status NOT IN ( 'CAN', 'LIT', 'CFR', 'PRS', 'DLT' ) 03/09/2025 00:42:44 [ inc_ins_temp_jrs_libre.php ] #703 => sql_cum_type_heb_pac= AND dg_type_heb.type_heb IN ( ) 03/09/2025 00:42:44 [ inc_ins_temp_jrs_libre.php ] #707 => sql_cum_type_heb_pac= AND dg_type_heb.type_heb IN ( ) 03/09/2025 00:42:44 [ inc_ins_temp_jrs_libre.php ] #708 => sql_nuit_hor= 03/09/2025 00:42:44 [ inc_ins_temp_jrs_libre.php ] #743 => query=SELECT dg_type_heb_rows.fk_entite, dg_type_heb_rows.type_heb, dg_type_heb_rows.code_heb, dg_type_heb_rows.fk_ent_geo, dg_type_heb_rows.code_interne, dg_type_heb_rows.mode_sld, dg_type_heb.nb_pax_std, dg_type_heb.nb_pax_max, dg_type_heb.standing, dg_type_heb.enf_auto, dg_type_heb_rows.ord_aff_code, dg_type_heb_rows.alloc_ota, dg_type_heb_rows.groupage_heb, dg_type_heb_rows.grand_heb, dg_type_heb_rows.zone_gpa, dg_type_heb_rows.etage FROM rofl0364_xpr.du_cat_type_heb JOIN ( dg_type_heb JOIN dg_type_heb_rows ON dg_type_heb.type_heb = dg_type_heb_rows.type_heb ) ON rofl0364_xpr.du_cat_type_heb.cat_type_heb = dg_type_heb.cat_type_heb WHERE dg_type_heb_rows.act <> 'I' AND rofl0364_xpr.du_cat_type_heb.act <> 'I' AND dg_type_heb_rows.fk_status NOT IN ( 'DLT' ) AND dg_type_heb.fk_status NOT IN ( 'DLT' ) AND rofl0364_xpr.du_cat_type_heb.fk_status NOT IN ( 'DLT' ) AND rofl0364_xpr.du_cat_type_heb.cat_type_rech = 4 AND dg_type_heb_rows.mode_sld = '0' AND dg_package.nuitee_horaire = '1' AND dg_type_heb.type_heb IN ( ) AND dg_type_heb_rows.alloc_ota = '0' ORDER BY dg_type_heb_rows.ord_aff_code 03/09/2025 00:42:44 [ inc_ins_temp_jrs_libre.php ] #747 => returned_rows=16 03/09/2025 00:42:44 [ inc_ins_temp_jrs_libre.php ] #1631 => plateforme1=2 03/09/2025 00:42:44 [ inc_ins_temp_jrs_libre.php ] #1633 => plateforme2=2 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #689 => money_local= 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #690 => money_cial= 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #691 => val_change= 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #693 => AAprix_dvs_ttcA= 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #694 => nb_type_heb_pac=0 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #695 => hor_resa_tf= 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #870 => nb_nuites_dem=5 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #1133 => hor_resa_tf= 03/09/2025 00:42:44 [ get_dg_package_choix.php ] #1235 => hor_resa_tf= debug get_dg_package_choix> # 10-1433 Temps : 0.2139 sec, Mémoire 2212 Ko