25/09/2025 15:44:12 [ ajax_login.php ] #138 => _SESSION['multi_entites']=2--- 25/09/2025 21:44:16 [ get_da_alertinfos.php ] #617 => nbLignesTab=38--- debug get_dg_package_choix> initialisation 25/09/2025 22:14:06 [ get_dg_package_choix.php ] #35 => _SESSION[ 'nb_entites' ]=3 25/09/2025 22:14:06 [ get_dg_package_choix.php ] #83 => cum_jr_sem= 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #38 => code_pays_rech = FRA 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #39 => region_rech = alpes cote de provence 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #40 => ville_rech = Marseille 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #41 => quartier_rech = 25/09/2025 22:14:06 [ 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' 25/09/2025 22:14:06 [ 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' 25/09/2025 22:14:06 [ inc_recherche_longi_lati.php ] #166 => sql_latitude = AND lati_dd BETWEEN 41.47696599982 AND 45.07700200018 25/09/2025 22:14:06 [ inc_recherche_longi_lati.php ] #167 => sql_longitude = AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #222 => QUERY=SELECT xpr_dg_entites.entite, xpr_dg_entites.ent_geo, dg_package.code_pac, dg_type_heb.cat_type_heb FROM 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 WHERE dg_type_heb.cat_type_heb IN ( '8' ) AND (( dg_type_heb.multi_fact = '0' AND dg_package.nb_pax = 3 ) OR dg_type_heb.multi_fact = '1' ) AND xpr_dg_entites.act <> 'I' AND xpr_dg_entites.fk_status <> 'DLT' AND dg_package.act <> 'I' AND dg_package.fk_status <> 'DLT' AND lati_dd BETWEEN 41.47696599982 AND 45.07700200018 AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 AND di_options.mode_tva_tf <> '2' 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_04 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo= 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04', 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01', 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_02 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01', 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02', 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02', 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02', 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02', 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02', 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02', 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #266 => sql_fk_entite_glo='ridba002' 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #267 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02' 25/09/2025 22:14:06 [ inc_reche_entite_geo.php ] #268 => cum_fk_pac_glo='cruise-A1','cruise-A2','cruise-A3','cruise-A4','cruise-A5','cruise-A6','cruise-A7','cruise-A8','cruise-A9','cruise-A10' 25/09/2025 22:14:06 [ get_dg_package_choix.php ] #711 => query_tarif600=SELECT dg_package_hor.fk_entite, dg_type_heb_rows.fk_ent_geo, temp_package_choix_68d547224bc7c.code_pac AS fk_code_pac, temp_package_choix_68d547224bc7c.fk_type_heb, dg_type_heb_rows.code_heb, dg_package_hor.jr_sem, hor_deb_bas, hor_fin_bas, hor_deb_hte, hor_fin_hte, hor_deb_tha, hor_fin_tha FROM dg_type_heb_rows JOIN ( dg_package_hor JOIN temp_package_choix_68d547224bc7c ON dg_package_hor.fk_code_pac = temp_package_choix_68d547224bc7c.code_pac ) ON dg_type_heb_rows.type_heb = temp_package_choix_68d547224bc7c.fk_type_heb WHERE jr_sem IN ( '3','4' ) AND partie = 2 AND temp_package_choix_68d547224bc7c.fk_entite IN ( 'ridba002' ) AND dg_package_hor.fk_entite IN ( 'ridba002' ) AND dg_type_heb_rows.fk_entite IN ( 'ridba002' ) 25/09/2025 22:14:06 [ inc_cherche_liste_options.php ] #34 => row['fk_entite']=ridba002 25/09/2025 22:14:06 [ inc_cherche_liste_options.php ] #35 => nb_jrs_option_mosai=1 25/09/2025 22:14:06 [ inc_cherche_liste_options.php ] #36 => rech_mosai= 25/09/2025 22:14:06 [ inc_ins_temp_jrs_libre.php ] #213 => 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 dg_tarifs JOIN dg_type_heb ON dg_tarifs.fk_type_heb = dg_type_heb.type_heb WHERE dg_type_heb.act <> 'I' AND dg_type_heb.fk_status NOT IN ( 'DLT' ) AND dg_tarifs.fk_status NOT IN ( 'DLT' ) AND dg_tarifs.fk_entite IN ( 'ridba002' ) AND dg_type_heb.fk_entite IN ( 'ridba002' ) AND dg_type_heb.cat_type_heb IN ( '8' ) 25/09/2025 22:14:06 [ inc_ins_temp_jrs_libre.php ] #335 => 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 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 WHERE dg_type_heb.act <> 'I' AND dg_package.nuitee_horaire = '0' 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 dg_package.fk_entite IN ( 'ridba002' ) AND dg_type_heb.fk_entite IN ( 'ridba002' ) AND dg_package_tarif.fk_entite IN ( 'ridba002' ) AND dg_type_heb.cat_type_heb IN ( '8' ) 25/09/2025 22:14:06 [ inc_sum_hor_pax.php ] #100 => query=SELECT dg_calendrier.fk_entite, dg_calendrier.code_pac, dg_calendrier.dt_resa_cal, dg_calendrier.hor_resa_deb, dg_calendrier.hor_resa_fin, dg_type_heb_rows.type_heb, dg_type_heb_rows.code_heb, dg_type_heb.nb_pax_std, SUM(dg_calendrier.nb_pax ) AS sum_nb_cal FROM dg_type_heb JOIN ( dg_type_heb_rows JOIN dg_calendrier ON dg_type_heb_rows.code_heb = dg_calendrier.fk_code_heb) ON dg_type_heb.type_heb = dg_calendrier.fk_type_heb WHERE dg_calendrier.dt_resa_cal BETWEEN '20250925' AND '20250926' 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' ) AND dg_type_heb.cat_type_heb IN ( '8' ) GROUP BY dg_calendrier.fk_entite, dg_calendrier.code_pac, dg_calendrier.dt_resa_cal, dg_calendrier.hor_resa_deb, dg_calendrier.hor_resa_fin, dg_type_heb_rows.type_heb, dg_type_heb_rows.code_heb, dg_type_heb.nb_pax_std 25/09/2025 22:14:06 [ inc_ins_temp_jrs_libre.php ] #594 => query=SELECT 'ridba002' AS fk_entite , jrs_cal, saison, fermeture FROM dg_jrs_calendrier WHERE fermeture <> '1' AND jrs_cal BETWEEN '20250925' AND '20250926' 25/09/2025 22:14:06 [ inc_ins_temp_jrs_libre.php ] #667 => query=SELECT fk_entite, dt_resa_cal, hor_resa_cal, code_heb, SUM(sum_nb_pax) AS sum_nb_pax FROM temp_sum_hor_pax_68d547224bc7c GROUP BY fk_entite, dt_resa_cal, hor_resa_cal, code_heb ORDER BY code_heb, hor_resa_cal 25/09/2025 22:14:06 [ inc_ins_temp_jrs_libre.php ] #823 => 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_package.code_pac, dg_type_heb.multi_fact, 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 dg_package JOIN ( dg_type_heb JOIN dg_type_heb_rows ON dg_type_heb.type_heb = dg_type_heb_rows.type_heb ) ON dg_type_heb_rows.fk_ent_geo = dg_package.fk_ent_geo WHERE dg_type_heb_rows.act <> 'I' AND dg_type_heb_rows.fk_status NOT IN ( 'DLT' ) AND dg_type_heb.fk_status NOT IN ( 'DLT' ) AND dg_type_heb.cat_type_heb IN ( '8' ) AND dg_package.cat_type_heb IN ( '8' ) AND dg_package.fk_status NOT IN ( 'DLT' ) AND dg_type_heb_rows.mode_sld = '0' AND dg_type_heb.type_heb IN ( 'ridba002-BT-STB','ridba002-BT-STG','ridba002-BT-STD','ridba002-BT-STD','ridba002-BT-STA','ridba002-BT-STD','ridba002-BT-STC','ridba002-BT-STE','ridba002-BT-STE','ridba002-BT-STF' ) AND dg_type_heb_rows.alloc_ota = '0' ORDER BY dg_type_heb_rows.ord_aff_code 25/09/2025 22:14:06 [ inc_ins_temp_jrs_libre.php ] #827 => returned_rows=18 25/09/2025 22:14:06 [ get_dg_package_choix.php ] #760 => hor_resa_tf=1 debug get_dg_package_choix> # 10-1664 Temps : 0.4645 sec, Mémoire 3590 Ko 25/09/2025 22:14:13 [ get_essai.php ] #24 => num_jr=3--- 25/09/2025 22:14:13 [ get_essai.php ] #46 => rech_resa_fin=20250609 12:15:00--- debug get_dg_package_choix> initialisation 25/09/2025 22:14:27 [ get_dg_package_choix.php ] #35 => _SESSION[ 'nb_entites' ]=1 25/09/2025 22:14:27 [ get_dg_package_choix.php ] #83 => cum_jr_sem= 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #38 => code_pays_rech = FRA 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #39 => region_rech = alpes cote de provence 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #40 => ville_rech = Marseille 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #41 => quartier_rech = 25/09/2025 22:14:27 [ 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' 25/09/2025 22:14:27 [ 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' 25/09/2025 22:14:27 [ inc_recherche_longi_lati.php ] #166 => sql_latitude = AND lati_dd BETWEEN 41.47696599982 AND 45.07700200018 25/09/2025 22:14:27 [ inc_recherche_longi_lati.php ] #167 => sql_longitude = AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #222 => QUERY=SELECT xpr_dg_entites.entite, xpr_dg_entites.ent_geo, dg_package.code_pac, dg_type_heb.cat_type_heb FROM 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 WHERE dg_type_heb.cat_type_heb IN ( '8' ) AND (( dg_type_heb.multi_fact = '0' AND dg_package.nb_pax = 3 ) OR dg_type_heb.multi_fact = '1' ) AND xpr_dg_entites.act <> 'I' AND xpr_dg_entites.fk_status <> 'DLT' AND dg_package.act <> 'I' AND dg_package.fk_status <> 'DLT' AND lati_dd BETWEEN 41.47696599982 AND 45.07700200018 AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 AND di_options.mode_tva_tf <> '2' 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_04 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo= 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04', 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01', 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_02 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01', 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02', 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02', 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02', 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02', 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02', 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02', 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #266 => sql_fk_entite_glo='ridba002' 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #267 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02' 25/09/2025 22:14:27 [ inc_reche_entite_geo.php ] #268 => cum_fk_pac_glo='cruise-A1','cruise-A2','cruise-A3','cruise-A4','cruise-A5','cruise-A6','cruise-A7','cruise-A8','cruise-A9','cruise-A10' 25/09/2025 22:14:27 [ get_dg_package_choix.php ] #711 => query_tarif600=SELECT dg_package_hor.fk_entite, dg_type_heb_rows.fk_ent_geo, temp_package_choix_68d547224bc7c.code_pac AS fk_code_pac, temp_package_choix_68d547224bc7c.fk_type_heb, dg_type_heb_rows.code_heb, dg_package_hor.jr_sem, hor_deb_bas, hor_fin_bas, hor_deb_hte, hor_fin_hte, hor_deb_tha, hor_fin_tha FROM dg_type_heb_rows JOIN ( dg_package_hor JOIN temp_package_choix_68d547224bc7c ON dg_package_hor.fk_code_pac = temp_package_choix_68d547224bc7c.code_pac ) ON dg_type_heb_rows.type_heb = temp_package_choix_68d547224bc7c.fk_type_heb WHERE jr_sem IN ( '3','4' ) AND partie = 2 AND temp_package_choix_68d547224bc7c.fk_entite IN ( 'ridba002' ) AND dg_package_hor.fk_entite IN ( 'ridba002' ) AND dg_type_heb_rows.fk_entite IN ( 'ridba002' ) 25/09/2025 22:14:27 [ inc_cherche_liste_options.php ] #34 => row['fk_entite']=ridba002 25/09/2025 22:14:27 [ inc_cherche_liste_options.php ] #35 => nb_jrs_option_mosai=1 25/09/2025 22:14:27 [ inc_cherche_liste_options.php ] #36 => rech_mosai= 25/09/2025 22:14:27 [ inc_ins_temp_jrs_libre.php ] #213 => 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 dg_tarifs JOIN dg_type_heb ON dg_tarifs.fk_type_heb = dg_type_heb.type_heb WHERE dg_type_heb.act <> 'I' AND dg_type_heb.fk_status NOT IN ( 'DLT' ) AND dg_tarifs.fk_status NOT IN ( 'DLT' ) AND dg_tarifs.fk_entite IN ( 'ridba002' ) AND dg_type_heb.fk_entite IN ( 'ridba002' ) AND dg_type_heb.cat_type_heb IN ( '8' ) 25/09/2025 22:14:27 [ inc_ins_temp_jrs_libre.php ] #335 => 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 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 WHERE dg_type_heb.act <> 'I' AND dg_package.nuitee_horaire = '0' 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 dg_package.fk_entite IN ( 'ridba002' ) AND dg_type_heb.fk_entite IN ( 'ridba002' ) AND dg_package_tarif.fk_entite IN ( 'ridba002' ) AND dg_type_heb.cat_type_heb IN ( '8' ) 25/09/2025 22:14:27 [ inc_sum_hor_pax.php ] #100 => query=SELECT dg_calendrier.fk_entite, dg_calendrier.code_pac, dg_calendrier.dt_resa_cal, dg_calendrier.hor_resa_deb, dg_calendrier.hor_resa_fin, dg_type_heb_rows.type_heb, dg_type_heb_rows.code_heb, dg_type_heb.nb_pax_std, SUM(dg_calendrier.nb_pax ) AS sum_nb_cal FROM dg_type_heb JOIN ( dg_type_heb_rows JOIN dg_calendrier ON dg_type_heb_rows.code_heb = dg_calendrier.fk_code_heb) ON dg_type_heb.type_heb = dg_calendrier.fk_type_heb WHERE dg_calendrier.dt_resa_cal BETWEEN '20250925' AND '20250926' 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' ) AND dg_type_heb.cat_type_heb IN ( '8' ) GROUP BY dg_calendrier.fk_entite, dg_calendrier.code_pac, dg_calendrier.dt_resa_cal, dg_calendrier.hor_resa_deb, dg_calendrier.hor_resa_fin, dg_type_heb_rows.type_heb, dg_type_heb_rows.code_heb, dg_type_heb.nb_pax_std 25/09/2025 22:14:27 [ inc_ins_temp_jrs_libre.php ] #594 => query=SELECT 'ridba002' AS fk_entite , jrs_cal, saison, fermeture FROM dg_jrs_calendrier WHERE fermeture <> '1' AND jrs_cal BETWEEN '20250925' AND '20250926' 25/09/2025 22:14:27 [ inc_ins_temp_jrs_libre.php ] #667 => query=SELECT fk_entite, dt_resa_cal, hor_resa_cal, code_heb, SUM(sum_nb_pax) AS sum_nb_pax FROM temp_sum_hor_pax_68d547224bc7c GROUP BY fk_entite, dt_resa_cal, hor_resa_cal, code_heb ORDER BY code_heb, hor_resa_cal 25/09/2025 22:14:27 [ inc_ins_temp_jrs_libre.php ] #823 => 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_package.code_pac, dg_type_heb.multi_fact, 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 dg_package JOIN ( dg_type_heb JOIN dg_type_heb_rows ON dg_type_heb.type_heb = dg_type_heb_rows.type_heb ) ON dg_type_heb_rows.fk_ent_geo = dg_package.fk_ent_geo WHERE dg_type_heb_rows.act <> 'I' AND dg_type_heb_rows.fk_status NOT IN ( 'DLT' ) AND dg_type_heb.fk_status NOT IN ( 'DLT' ) AND dg_type_heb.cat_type_heb IN ( '8' ) AND dg_package.cat_type_heb IN ( '8' ) AND dg_package.fk_status NOT IN ( 'DLT' ) AND dg_type_heb_rows.mode_sld = '0' AND dg_type_heb.type_heb IN ( 'ridba002-BT-STB','ridba002-BT-STG','ridba002-BT-STD','ridba002-BT-STD','ridba002-BT-STA','ridba002-BT-STD','ridba002-BT-STC','ridba002-BT-STE','ridba002-BT-STE','ridba002-BT-STF' ) AND dg_type_heb_rows.alloc_ota = '0' ORDER BY dg_type_heb_rows.ord_aff_code 25/09/2025 22:14:27 [ inc_ins_temp_jrs_libre.php ] #827 => returned_rows=42 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #760 => hor_resa_tf=1 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1004 => row['hor_resa_deb']=08:45 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1005 => row['hor_resa_fin']=19:00 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1004 => row['hor_resa_deb']=08:45 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1005 => row['hor_resa_fin']=12:00 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1004 => row['hor_resa_deb']=14:00 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1005 => row['hor_resa_fin']=19:00 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1004 => row['hor_resa_deb']=20:30 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1005 => row['hor_resa_fin']=22:30 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1004 => row['hor_resa_deb']=08:45 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1005 => row['hor_resa_fin']=19:00 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1004 => row['hor_resa_deb']=08:45 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1005 => row['hor_resa_fin']=19:00 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1004 => row['hor_resa_deb']=14:00 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1005 => row['hor_resa_fin']=19:00 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1004 => row['hor_resa_deb']=08:45 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1005 => row['hor_resa_fin']=19:00 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1004 => row['hor_resa_deb']=08:45 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1005 => row['hor_resa_fin']=19:00 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1004 => row['hor_resa_deb']=08:45 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1005 => row['hor_resa_fin']=12:00 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1004 => row['hor_resa_deb']=14:00 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1005 => row['hor_resa_fin']=19:00 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1004 => row['hor_resa_deb']=20:30 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1005 => row['hor_resa_fin']=22:30 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1004 => row['hor_resa_deb']=08:45 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1005 => row['hor_resa_fin']=19:00 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1004 => row['hor_resa_deb']=08:45 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1005 => row['hor_resa_fin']=19:00 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1004 => row['hor_resa_deb']=14:00 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1005 => row['hor_resa_fin']=19:00 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1004 => row['hor_resa_deb']=08:45 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1005 => row['hor_resa_fin']=19:00 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1004 => row['hor_resa_deb']=08:45 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1005 => row['hor_resa_fin']=19:00 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1004 => row['hor_resa_deb']=08:45 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1005 => row['hor_resa_fin']=19:00 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1004 => row['hor_resa_deb']=08:45 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1005 => row['hor_resa_fin']=19:00 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1004 => row['hor_resa_deb']=08:45 25/09/2025 22:14:30 [ get_dg_package_choix.php ] #1005 => row['hor_resa_fin']=19:00 debug get_dg_package_choix> # 10-1664 Temps : 2.9565 sec, Mémoire 5714 Ko debug cherche_resa_et1> initialisation 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #270 => rech_resa_adu=3--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #271 => rech_hor_arr=20:30--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #294 => hor_resa_tf=1--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #295 => code_package=cruise-A5--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #296 => nb_nuites_dem=1--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #297 => rech_resa_adu=3--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #308 => code_package=cruise-A5--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #309 => fk_entite=ridba002--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #310 => plateforme=2--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #326 => rech_type_heb=ridba002-BT-STD--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #327 => rech_code_heb=--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #338 => id_agent=2--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #352 => id_agent=2--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #353 => plateforme=2--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #354 => id_tab_pac=26--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #355 => rech_mosai=0--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #380 => hor_resa_tf => "1" 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #382 => data_et1_prec => "" 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #383 => data_et1 => "" 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #384 => plateforme => "2" 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #385 => rech_resa_arr => "20250925" 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #386 => rech_resa_dep => "20250926" 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #387 => rech_resa_curr => "USD" 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #388 => rech_resa_standing => "A,B,C" 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #389 => rech_code_heb => "" 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #390 => rech_type_heb => "ridba002-BT-STD" 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #391 => rech_resa_adu => "3" 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #392 => rech_resa_enf => "" 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #393 => rech_resa_nb_heb => "1" 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #394 => rech_prix_saisi => "0" 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #451 => sql_fk_entite_glo='ridba002' 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #463 => sql_fk_entite_glo='ridba002' 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #464 => sql_fk_entite_glo = 'ridba002' 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #465 => data_choix_entite_glo = ridba002 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #474 => sql_fk_entite_glo='ridba002' 25/09/2025 22:14:47 [ inc_cherche_liste_options.php ] #34 => row['fk_entite']=ridba002 25/09/2025 22:14:47 [ inc_cherche_liste_options.php ] #35 => nb_jrs_option_mosai=1 25/09/2025 22:14:47 [ inc_cherche_liste_options.php ] #36 => rech_mosai=0 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #486 => pack_horaire=1 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #505 => plateforme=2 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #506 => nb_ent_geo_select= 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #507 => rech_plac_multi_entite=1 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #508 => code_package=cruise-A5 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #620 => AENTRE_2 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #625 => sql_fk_entite_glo='ridba002'--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #626 => data_choix_entite_glo=ridba002_01--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #630 => Adata_choix_entite=Array--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #634 => err_disct_compt_tf=--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #878 => hor_resa_tf 857=>1 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #879 => sql_fk_entite_glo 857=>'ridba002' 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #898 => QHERY870=>SELECT fk_entite, fk_code_conso, prix_ht, prix_ttc, taux_tva, nb_gratuit FROM dg_heb_cout_interne WHERE act <> 'I' AND hor_tf = 1 AND fk_status NOT IN ( 'DLT' ) AND fk_code_conso IN ( 'RCH-SA-', 'RCH-SE-', 'RCM-MS-' ) AND fk_entite IN ( 'ridba002' ) 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #1055 => sql_choix_standing=--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #32 => row['nb']=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #32 => row['nb']=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #32 => row['nb']=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #32 => row['nb']=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #32 => row['nb']=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #32 => row['nb']=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #32 => row['nb']=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #32 => row['nb']=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #32 => row['nb']=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #32 => row['nb']=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #32 => row['nb']=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #32 => row['nb']=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #32 => row['nb']=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #32 => row['nb']=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #32 => row['nb']=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #32 => row['nb']=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #32 => row['nb']=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #32 => row['nb']=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #32 => row['nb']=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #32 => row['nb']=1--- 25/09/2025 22:14:47 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #1093 => rech_code_heb=--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #1094 => cpt_temp_jours_libre=20--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #1095 => rech_code_heb=--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #1170 => QUERY1120=SELECT ord_aff_code, code_heb, nb_pax_std, code_package FROM temp_jrs_libre_68d547224bc7c WHERE fini_prep = 1 AND nb_pax_std >= 3 AND code_package = 'cruise-A5' ORDER BY ord_aff_code LIMIT 1 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #1172 => AAdby->returned_rows=1--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #1185 => hor_resa_tf=1--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #1186 => priorite_code_heb=1--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #1320 => cpt_temp_jours_libre=20--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #1419 => nbdata=2--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #1428 => compteur_placement_std_opt=1--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #1449 => rech_code_heb=--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #1450 => compteur_placement_std_opt=1--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #1465 => compteur_placement_std_opt=1--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #1466 => nbdata=2--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #1467 => z=0--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #1473 => nb_heb_compteur=0--- 25/09/2025 22:14:47 [ cherche_resa_et1.php ] #1475 => hypo_fk_entite=--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1491 => nb_heb_compteur=0--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1494 => recal_hypo_placement_std=0--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1521 => recal_hypo_placement_std=0--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1522 => compteur_placement_std_opt=1--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1523 => continuer_boucle_grp=1--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1524 => nb_heb_compteur=0--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1525 => rech_resa_nb_heb=1--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1533 => hypo_fk_entite=--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1534 => continuer_boucle_grp=1--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1539 => recal_hypo_placement_std=0--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1547 => prc_deposit1=50--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1556 => hypo_fk_entite=ridba002--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1557 => nb_heb_compteur=0--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1558 => rech_resa_nb_heb=1--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1563 => nb_heb_compteur=0--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1564 => continuer_boucle_grp=1--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1565 => hypo_fk_entite=ridba002--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1574 => continuer_boucle_grp=1--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1580 => rech_resa_nb_heb=1--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1581 => rech_resa_nb_heb=1--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1582 => nb_heb_compteur=0--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1583 => grp_lineaire=1--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1584 => plateforme=2--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1585 => rech_code_heb=--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1586 => rech_type_heb=ridba002-BT-STD--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1587 => compteur_placement_std_opt=1--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1588 => grp=1--- 25/09/2025 22:14:48 [ inc_placement_lineaire_standard.php ] #158 => QUERY141=SELECT code_heb, ord_aff_code FROM temp_jrs_libre_68d547224bc7c WHERE fk_ent_geo = 'ridba002_01' AND code_package = 'cruise-A5' AND dt_resa = '20250926' AND fini_prep = '1' AND grp = 0 AND nb_sel_code_heb >= 1 AND groupage3 = 1 ORDER BY nb_sel_code_heb DESC, ord_aff_code, nb_pax_std DESC, opt_facult DESC 25/09/2025 22:14:48 [ inc_placement_lineaire_standard.php ] #160 => BBdby->returned_rows=1--- 25/09/2025 22:14:48 [ inc_placement_lineaire_standard.php ] #185 => CCdby->returned_rows=1--- 25/09/2025 22:14:48 [ inc_placement_lineaire_standard.php ] #217 => QUERY204=SELECT code_heb, nb_pax_std, nb_pax_max, code_package, standing, nom_court_ent AS hotel_court FROM temp_jrs_libre_68d547224bc7c WHERE fk_ent_geo = 'ridba002_01' AND fini_prep = '1' AND code_heb = 'ridba002-BT-STD-01' AND grp = 0 AND segment_accepte = 1 AND groupage3 = 1 25/09/2025 22:14:48 [ inc_placement_lineaire_standard.php ] #219 => dby->returned_rows=1 25/09/2025 22:14:48 [ inc_placement_lineaire_standard.php ] #235 => reste=3--- 25/09/2025 22:14:48 [ inc_placement_lineaire_standard.php ] #236 => pax_compteur=3--- 25/09/2025 22:14:48 [ inc_placement_lineaire_standard.php ] #238 => hypo_fk_entite_geo=ridba002_01--- 25/09/2025 22:14:48 [ inc_placement_lineaire_standard.php ] #239 => row_code_heb['code_heb']=ridba002-BT-STD-01--- 25/09/2025 22:14:48 [ inc_placement_lineaire_standard.php ] #240 => row_libre['code_package']=cruise-A5--- 25/09/2025 22:14:48 [ inc_placement_lineaire_standard.php ] #287 => enregistrement_BLO_FIN 25/09/2025 22:14:48 [ inc_placement_lineaire_standard.php ] #290 => enregistrement_BLO 25/09/2025 22:14:48 [ inc_placement_lineaire_standard.php ] #321 => continuer_boucle_grp=1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1598 => hypo_fk_entite=ridba002--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1599 => rech_mosai_sys_av=0--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1629 => rech_mosai_sys_ap=0--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1640 => trouve_placement_lineaire=1--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1641 => continuer_boucle_grp=1--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1642 => compteur_placement_std_opt=1--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1643 => rech_mosai=0--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1644 => rech_mosai_sys=0--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1645 => hypo_fk_entite=ridba002--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1646 => grp=1--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2291 => pax_compteur=-6 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2307 => dby->returned_rows=1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2314 => QUERY11=SELECT COUNT( dt_resa ) AS nb_jrs_trouve FROM temp_jrs_libre_68d547224bc7c WHERE fk_ent_geo = 'ridba002_01' AND fini_prep = '1' AND choix_propos = 1 AND grp = 1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2327 => nb_nuites_dem=1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2328 => nb_jrs_trouve_grp=1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2339 => nb_heb_compteur=1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2422 => pax_compteur=-6 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2428 => continuer_boucle_grp=1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2429 => hypo_fk_entite_geo37=ridba002_01 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2433 => pax_compteur=-6 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2434 => propos_compteur=1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2514 => hypo_fk_entite=ridba002 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2515 => row_syn['fk_entite']=ridba002 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2530 => nb_pax_nh=3 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2540 => row_syn['code_package']=cruise-A5 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2541 => propos_compteur=1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2542 => row_syn['cout_heb_loc_ttc']=474.5000 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2543 => nb_pax_nh=3 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2544 => cout_heb_dvsAV= 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2551 => cout_heb_dvsAP=1467.5259 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2553 => row_syn['nb_pax']=3 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2554 => hor_resa_tf=1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2565 => dev_decs_dem=2 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2567 => row_syn['par_pers']=1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2645 => row_syn['code_package']=cruise-A5 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2653 => cpt_mosaique_gloQQ=0 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2654 => code_packageQQ=cruise-A5 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2655 => cpt_jr_promoQQ= 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2656 => cpt_saisonQQ= 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2814 => pack_horaire22=1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2815 => row_saison['montant']22=489.1753 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2816 => row_saison['montant_loc']22=474.5000 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2817 => rech_resa_adu22=3 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2818 => row_saison['code_package']22=cruise-A5 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2857 => montant_dvs_tot22=1467.5259 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2858 => montant_loc_tot22=1423.5 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2958 => continuer_boucle_grp=1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #2963 => continuer_boucle_grp=1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3014 => hypo_fk_entite=ridba002 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3015 => row_syn['fk_entite']=ridba002 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3189 => nb_heb_cout_interne =>2 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3215 => cum_rech_resa_enf => 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3216 => row_min_max['max_grp_ent'] =>1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3217 => row_adu_ent_lit['fk_entite'] =>ridba002 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3218 => cpt_entite_enfant =>1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3219 => propos_compteur =>1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3220 => row_min_max['cnt_fk_entite'] => 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3221 => nb_lin_max =>1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3265 => row_adu_ent_lit['fk_entite']=ridba002 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3268 => val_chg=0.97 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3269 => cout_lit_enf_loc_ht/val_chg=10.751134020619 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3292 => propos_compteur=1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3293 => row_adu_ent_lit['fk_entite']=ridba002 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3296 => pax_compteur=-6 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3489 => propos_compteur=1--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3490 => rech_resa_adu=3--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3491 => sum_nb_pax=3--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3557 => propos_compteur_exit_oop=1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3559 => propos_compteur=1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3560 => pax_compteur=-6 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3561 => rech_resa_nb_heb=1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3667 => continuer_boucle_grp=1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3668 => pax_compteur=-6 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3676 => lit_adu_en_supplement=0 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3677 => lit_adu_en_supplement_glo=0 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3678 => lit_adu_en_supplement_ori=0 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3679 => compteur_placement_std_opt=1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3680 => recal_hypo_placement_std=0 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3739 => pax_compteur=-6 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3741 => continuer_propos =>1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3742 => compteur_placement_std_opt =>1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3744 => continuer_propos =>1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3745 => compteur_placement_std_opt =>1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3746 => hypo_fk_entite =>ridba002 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3748 => compteur_placement_std_opt =>1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3749 => hypo_fk_entite =>ridba002 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3820 => continuer_boucle_grp=1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3821 => pax_compteur=-6 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3830 => hypo_fk_entite=ridba002 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3831 => continuer_propos => 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3838 => continuer_boucle_grp= 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3839 => pax_compteur=-6 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3840 => propos_compteur=2 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3851 => compteur_placement_std_opt=1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3852 => code_package=cruise-A5 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3854 => recal_hypo_placement_std=0 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3855 => continuer_boucle_grp= 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3856 => pax_compteur=-6 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3857 => propos_compteur=2 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3858 => propos_compteur---------------------------------- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1428 => compteur_placement_std_opt=2--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1449 => rech_code_heb=--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1450 => compteur_placement_std_opt=2--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1465 => compteur_placement_std_opt=2--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1466 => nbdata=2--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #1467 => z=1--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3851 => compteur_placement_std_opt=2 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3852 => code_package=cruise-A5 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3854 => recal_hypo_placement_std=0 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3855 => continuer_boucle_grp=1 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3856 => pax_compteur=-6 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3857 => propos_compteur=2 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3858 => propos_compteur---------------------------------- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3893 => pax_compteur=-6 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #3894 => plateforme=2--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #4116 => QUERY4000=SELECT fk_ent_geo, choix_propos, nb_lit_spl_adu FROM temp_reche_syn_68d547224bc7c WHERE nb_lit_spl_adu > 0 GROUP BY fk_ent_geo, choix_propos, nb_lit_spl_adu ORDER BY fk_ent_geo, choix_propos, nb_lit_spl_adu 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #4248 => sum_ae=--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #4689 => plateforme=2--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #4694 => plateforme=2--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #4805 => query =>SELECT temp_reche_syn_68d547224bc7c.fk_entite, temp_reche_syn_68d547224bc7c.type_heb, dg_type_heb_lang.intitule, dg_type_heb_lang.descro FROM temp_reche_syn_68d547224bc7c JOIN dg_type_heb_lang ON temp_reche_syn_68d547224bc7c.fk_entite = dg_type_heb_lang.fk_entite WHERE temp_reche_syn_68d547224bc7c.type_heb = dg_type_heb_lang.type_heb AND dg_type_heb_lang.fk_entite IN ( 'ridba002' ) AND dg_type_heb_lang.lang = 'FR' AND dg_type_heb_lang.fk_status NOT IN ( 'DLT' ) GROUP BY temp_reche_syn_68d547224bc7c.fk_entite, temp_reche_syn_68d547224bc7c.type_heb, dg_type_heb_lang.intitule, dg_type_heb_lang.descro--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #4806 => nb_heb_trouve =>1--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #4874 => row['val_change'] =>0.97--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #4893 => nb_enf_gratuit =>1--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #4908 => cout_lit_enf_spl_dvs =>0--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #4960 => row_pu_pac['prix_pac'] =>489.18--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #4961 => row_pu_pac['code_package'] =>--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #5216 => taux_tva_chg =>0--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #5267 => QUERY =>SELECT code_heb_intitule, code_heb_descro, standing_nom, standing, COUNT(code_heb_intitule) AS nb_intitule FROM temp_reche_syn_68d547224bc7c WHERE hypo_tf = '1' AND hypo_unique = 1 AND choix_propos = 1 AND fk_entite = 'ridba002' GROUP BY code_heb_intitule, code_heb_descro, standing_nom, standing 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #5287 => standing_code =>C--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #5288 => row1['choix_propos'] =>1--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #5289 => row1['fk_entite'] =>ridba002--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #5388 => row_1['depo_ent_min_loc_pre'] =>711.750000--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #5393 => row_1['fk_entite'] =>ridba002--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #5394 => deposit_tot_ent =>711.75--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #5416 => row_1['choix_propos'] =>1--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #5417 => row_1['fk_ent_geo'] =>ridba002_01--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #5418 => row_2['grp'] =>1--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #5419 => deposit_grp_ent_loc =>711.75--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #5420 => sql_code_package_sel =>--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #5435 => cum_deposit =>711.75--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #5436 => grp_dernier =>1--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #5445 => acompte_diff =>0--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #5457 => inc =>711.75--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #5469 => row_1['choix_propos'] =>1--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #5470 => row_1['fk_ent_geo'] =>ridba002_01--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #5471 => grp_dernier =>1--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #5472 => (acompte_diff + inc) =>711.75--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #5500 => row['cout_dis_min_grp_loc'] =>711.75--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #5501 => row['dvs_decs'] =>2--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #5545 => row['dev_loc_decs'] =>2--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #5546 => row['dvs'] =>733.76--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #6286 => nb_resultats=1--- 25/09/2025 22:14:48 [ cherche_resa_et1.php ] #6666 => resultat fin=>trouvé en site heb--- debug cherche_resa_et1> # 130-6668 Temps : 0.3690 sec, Mémoire 3021 Ko