13/10/2025 19:16:15 [ ajax_login.php ] #138 => _SESSION['multi_entites']=2---
14/10/2025 01:16:19 [ get_da_alertinfos.php ] #624 => nbLignesTab=38---
14/10/2025 01:16:26 [ get_essai.php ] #24 => num_jr=3---
14/10/2025 01:16:26 [ get_essai.php ] #79 => code_devise=USD---
14/10/2025 01:16:26 [ get_essai.php ] #80 => acompte_resa=169.33---
14/10/2025 01:16:26 [ get_essai.php ] #86 => nom_court=---

debug get_dg_package_choix> initialisation
14/10/2025 01:16:35 [ get_dg_package_choix.php ] #148 => rech_resa_fin=20251004
14/10/2025 01:16:35 [ get_dg_package_choix.php ] #150 => nb_nuites_dem=4
14/10/2025 01:16:35 [ inc_reche_entite_geo.php ] #38 => code_pays_rech = FRA
14/10/2025 01:16:35 [ inc_reche_entite_geo.php ] #39 => region_rech = alpes cote de provence
14/10/2025 01:16:35 [ inc_reche_entite_geo.php ] #40 => ville_rech = Marseille
14/10/2025 01:16:35 [ inc_reche_entite_geo.php ] #41 => quartier_rech = 
14/10/2025 01:16:35 [ 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'  
14/10/2025 01:16:35 [ 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'  
14/10/2025 01:16:35 [ inc_recherche_longi_lati.php ] #166 => sql_latitude =  AND lati_dd BETWEEN 41.47696599982 AND 45.07700200018 
14/10/2025 01:16:35 [ inc_recherche_longi_lati.php ] #167 => sql_longitude =  AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
14/10/2025 01:16:35 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_04
14/10/2025 01:16:35 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo=
14/10/2025 01:16:35 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
14/10/2025 01:16:35 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo='ridba002_04',
14/10/2025 01:16:35 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
14/10/2025 01:16:35 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo='ridba002_04','ridba002_01',
14/10/2025 01:16:35 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_02
14/10/2025 01:16:35 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo='ridba002_04','ridba002_01',
14/10/2025 01:16:35 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
14/10/2025 01:16:35 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02',
14/10/2025 01:16:35 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
14/10/2025 01:16:35 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02',
14/10/2025 01:16:35 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
14/10/2025 01:16:35 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02',
14/10/2025 01:16:35 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
14/10/2025 01:16:35 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02',
14/10/2025 01:16:35 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
14/10/2025 01:16:35 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02',
14/10/2025 01:16:35 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
14/10/2025 01:16:35 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02',
14/10/2025 01:16:35 [ inc_reche_entite_geo.php ] #186 => sql_fk_entite_glo='ridba002'
14/10/2025 01:16:35 [ inc_reche_entite_geo.php ] #187 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02'
14/10/2025 01:16:35 [ inc_reche_entite_geo.php ] #188 => cum_fk_pac_glo='cruise-A1','cruise-A2','cruise-A3','cruise-A4','cruise-A5','cruise-A6','cruise-A7','cruise-A8','cruise-A9','cruise-A10'
14/10/2025 01:16:36 [ inc_cherche_liste_options.php ] #34 => row['fk_entite']=ridba002
14/10/2025 01:16:36 [ inc_cherche_liste_options.php ] #35 => nb_jrs_option_mosai=1
14/10/2025 01:16:36 [ inc_cherche_liste_options.php ] #36 => rech_mosai=
14/10/2025 01:16:36 [ inc_sum_hor_pax.php ] #13 => query=SELECT horaires 
      FROM dg_horaires_cal
      
14/10/2025 01:16:40 [ get_dg_package_choix.php ] #887 => plateforme=3
14/10/2025 01:16:41 [ get_dg_package_choix.php ] #908 => query=SELECT jrs_cal AS date_hor
  FROM dg_jrs_calendrier
  WHERE jrs_cal BETWEEN '20251001' AND '20251004'
  AND jrs_cal NOT IN ( '20251001' )
  GROUP BY jrs_cal
  ORDER BY jrs_cal
14/10/2025 01:16:41 [ get_dg_package_choix.php ] #941 => QUERY=SELECT fk_entite, nom_court, fk_ent_geo, ordre_entite,
    distance_km, pack_horaire, par_pers, rem_pac_alea_prc, adresse_ville,
    nom_long, partie, code_pac, nb_nts,
    sej_nts, nb_pax, pac_promo_tf, pac_promo_nb,
    pac_promo_nb_fin, nb_pac_libre, multi_fact, prix_pac,
    prix_pac_loc, symbole_loc, symbole_dem, code_devise_loc,
    code_devise_dem, fk_type_heb, intitule_type_heb, intitule_pac,
    descro_pac, hor_deb, hor_fin, 
    date_debut, date_fin, dt_deb_sej, dt_fin_sej,
    rech_resa_adu, rech_resa_enf, rech_resa_nb_heb, rech_resa_curr,
    cat_type_rech
    FROM temp_package_choix_68ed33d81fd2a
    WHERE partie = 2
14/10/2025 01:16:41 [ get_dg_package_choix.php ] #941 => QUERY=SELECT fk_entite, nom_court, fk_ent_geo, ordre_entite,
    distance_km, pack_horaire, par_pers, rem_pac_alea_prc, adresse_ville,
    nom_long, partie, code_pac, nb_nts,
    sej_nts, nb_pax, pac_promo_tf, pac_promo_nb,
    pac_promo_nb_fin, nb_pac_libre, multi_fact, prix_pac,
    prix_pac_loc, symbole_loc, symbole_dem, code_devise_loc,
    code_devise_dem, fk_type_heb, intitule_type_heb, intitule_pac,
    descro_pac, hor_deb, hor_fin, 
    date_debut, date_fin, dt_deb_sej, dt_fin_sej,
    rech_resa_adu, rech_resa_enf, rech_resa_nb_heb, rech_resa_curr,
    cat_type_rech
    FROM temp_package_choix_68ed33d81fd2a
    WHERE partie = 2
14/10/2025 01:16:41 [ get_dg_package_choix.php ] #941 => QUERY=SELECT fk_entite, nom_court, fk_ent_geo, ordre_entite,
    distance_km, pack_horaire, par_pers, rem_pac_alea_prc, adresse_ville,
    nom_long, partie, code_pac, nb_nts,
    sej_nts, nb_pax, pac_promo_tf, pac_promo_nb,
    pac_promo_nb_fin, nb_pac_libre, multi_fact, prix_pac,
    prix_pac_loc, symbole_loc, symbole_dem, code_devise_loc,
    code_devise_dem, fk_type_heb, intitule_type_heb, intitule_pac,
    descro_pac, hor_deb, hor_fin, 
    date_debut, date_fin, dt_deb_sej, dt_fin_sej,
    rech_resa_adu, rech_resa_enf, rech_resa_nb_heb, rech_resa_curr,
    cat_type_rech
    FROM temp_package_choix_68ed33d81fd2a
    WHERE partie = 2
debug get_dg_package_choix> # 10-1692 Temps : 5.1037 sec, Mémoire 6980 Ko

debug get_dg_package_choix> initialisation
14/10/2025 01:22:51 [ get_dg_package_choix.php ] #148 => rech_resa_fin=20251004
14/10/2025 01:22:51 [ get_dg_package_choix.php ] #150 => nb_nuites_dem=4
14/10/2025 01:22:51 [ inc_reche_entite_geo.php ] #38 => code_pays_rech = FRA
14/10/2025 01:22:51 [ inc_reche_entite_geo.php ] #39 => region_rech = alpes cote de provence
14/10/2025 01:22:51 [ inc_reche_entite_geo.php ] #40 => ville_rech = Marseille
14/10/2025 01:22:51 [ inc_reche_entite_geo.php ] #41 => quartier_rech = 
14/10/2025 01:22:51 [ 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'  
14/10/2025 01:22:51 [ 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'  
14/10/2025 01:22:51 [ inc_recherche_longi_lati.php ] #166 => sql_latitude =  AND lati_dd BETWEEN 41.47696599982 AND 45.07700200018 
14/10/2025 01:22:51 [ inc_recherche_longi_lati.php ] #167 => sql_longitude =  AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
14/10/2025 01:22:51 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_04
14/10/2025 01:22:51 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo=
14/10/2025 01:22:51 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
14/10/2025 01:22:51 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo='ridba002_04',
14/10/2025 01:22:51 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
14/10/2025 01:22:51 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo='ridba002_04','ridba002_01',
14/10/2025 01:22:51 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_02
14/10/2025 01:22:51 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo='ridba002_04','ridba002_01',
14/10/2025 01:22:51 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
14/10/2025 01:22:51 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02',
14/10/2025 01:22:51 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
14/10/2025 01:22:51 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02',
14/10/2025 01:22:51 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
14/10/2025 01:22:51 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02',
14/10/2025 01:22:51 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
14/10/2025 01:22:51 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02',
14/10/2025 01:22:51 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
14/10/2025 01:22:51 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02',
14/10/2025 01:22:51 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
14/10/2025 01:22:51 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02',
14/10/2025 01:22:51 [ inc_reche_entite_geo.php ] #186 => sql_fk_entite_glo='ridba002'
14/10/2025 01:22:51 [ inc_reche_entite_geo.php ] #187 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02'
14/10/2025 01:22:51 [ inc_reche_entite_geo.php ] #188 => cum_fk_pac_glo='cruise-A1','cruise-A2','cruise-A3','cruise-A4','cruise-A5','cruise-A6','cruise-A7','cruise-A8','cruise-A9','cruise-A10'
14/10/2025 01:22:51 [ inc_cherche_liste_options.php ] #34 => row['fk_entite']=ridba002
14/10/2025 01:22:51 [ inc_cherche_liste_options.php ] #35 => nb_jrs_option_mosai=1
14/10/2025 01:22:51 [ inc_cherche_liste_options.php ] #36 => rech_mosai=
14/10/2025 01:22:51 [ inc_sum_hor_pax.php ] #13 => query=SELECT horaires 
      FROM dg_horaires_cal
      
14/10/2025 01:22:56 [ get_dg_package_choix.php ] #887 => plateforme=3
14/10/2025 01:22:56 [ get_dg_package_choix.php ] #908 => query=SELECT jrs_cal AS date_hor
  FROM dg_jrs_calendrier
  WHERE jrs_cal BETWEEN '20251001' AND '20251004'
  AND jrs_cal NOT IN ( '20251001' )
  GROUP BY jrs_cal
  ORDER BY jrs_cal
14/10/2025 01:22:56 [ get_dg_package_choix.php ] #941 => QUERY=SELECT fk_entite, nom_court, fk_ent_geo, ordre_entite,
    distance_km, pack_horaire, par_pers, rem_pac_alea_prc, adresse_ville,
    nom_long, partie, code_pac, nb_nts,
    sej_nts, nb_pax, pac_promo_tf, pac_promo_nb,
    pac_promo_nb_fin, nb_pac_libre, multi_fact, prix_pac,
    prix_pac_loc, symbole_loc, symbole_dem, code_devise_loc,
    code_devise_dem, fk_type_heb, intitule_type_heb, intitule_pac,
    descro_pac, hor_deb, hor_fin, 
    date_debut, date_fin, dt_deb_sej, dt_fin_sej,
    rech_resa_adu, rech_resa_enf, rech_resa_nb_heb, rech_resa_curr,
    cat_type_rech
    FROM temp_package_choix_68ed33d81fd2a
    WHERE partie = 2
14/10/2025 01:22:56 [ get_dg_package_choix.php ] #941 => QUERY=SELECT fk_entite, nom_court, fk_ent_geo, ordre_entite,
    distance_km, pack_horaire, par_pers, rem_pac_alea_prc, adresse_ville,
    nom_long, partie, code_pac, nb_nts,
    sej_nts, nb_pax, pac_promo_tf, pac_promo_nb,
    pac_promo_nb_fin, nb_pac_libre, multi_fact, prix_pac,
    prix_pac_loc, symbole_loc, symbole_dem, code_devise_loc,
    code_devise_dem, fk_type_heb, intitule_type_heb, intitule_pac,
    descro_pac, hor_deb, hor_fin, 
    date_debut, date_fin, dt_deb_sej, dt_fin_sej,
    rech_resa_adu, rech_resa_enf, rech_resa_nb_heb, rech_resa_curr,
    cat_type_rech
    FROM temp_package_choix_68ed33d81fd2a
    WHERE partie = 2
14/10/2025 01:22:56 [ get_dg_package_choix.php ] #941 => QUERY=SELECT fk_entite, nom_court, fk_ent_geo, ordre_entite,
    distance_km, pack_horaire, par_pers, rem_pac_alea_prc, adresse_ville,
    nom_long, partie, code_pac, nb_nts,
    sej_nts, nb_pax, pac_promo_tf, pac_promo_nb,
    pac_promo_nb_fin, nb_pac_libre, multi_fact, prix_pac,
    prix_pac_loc, symbole_loc, symbole_dem, code_devise_loc,
    code_devise_dem, fk_type_heb, intitule_type_heb, intitule_pac,
    descro_pac, hor_deb, hor_fin, 
    date_debut, date_fin, dt_deb_sej, dt_fin_sej,
    rech_resa_adu, rech_resa_enf, rech_resa_nb_heb, rech_resa_curr,
    cat_type_rech
    FROM temp_package_choix_68ed33d81fd2a
    WHERE partie = 2
debug get_dg_package_choix> # 10-1692 Temps : 5.0898 sec, Mémoire 6980 Ko