08/10/2025 14:34:35 [ ajax_login.php ] #138 => _SESSION['multi_entites']=2---
08/10/2025 20:34:39 [ get_da_alertinfos.php ] #624 => nbLignesTab=39---

debug get_dg_package_choix> initialisation
08/10/2025 20:57:34 [ get_dg_package_choix.php ] #152 => rech_resa_fin=20251004
08/10/2025 20:57:34 [ get_dg_package_choix.php ] #154 => nb_nuites_dem=4
08/10/2025 20:57:34 [ inc_reche_entite_geo.php ] #38 => code_pays_rech = FRA
08/10/2025 20:57:34 [ inc_reche_entite_geo.php ] #39 => region_rech = alpes cote de provence
08/10/2025 20:57:34 [ inc_reche_entite_geo.php ] #40 => ville_rech = Marseille
08/10/2025 20:57:34 [ inc_reche_entite_geo.php ] #41 => quartier_rech = 
08/10/2025 20:57:34 [ 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'  
08/10/2025 20:57:34 [ 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'  
08/10/2025 20:57:34 [ inc_recherche_longi_lati.php ] #166 => sql_latitude =  AND lati_dd BETWEEN 41.47696599982 AND 45.07700200018 
08/10/2025 20:57:34 [ inc_recherche_longi_lati.php ] #167 => sql_longitude =  AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
08/10/2025 20:57:34 [ 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'
08/10/2025 20:57:34 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_04
08/10/2025 20:57:34 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo=
08/10/2025 20:57:34 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01
08/10/2025 20:57:34 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04',
08/10/2025 20:57:34 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01
08/10/2025 20:57:34 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01',
08/10/2025 20:57:34 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_02
08/10/2025 20:57:34 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01',
08/10/2025 20:57:34 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01
08/10/2025 20:57:34 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02',
08/10/2025 20:57:34 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01
08/10/2025 20:57:34 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02',
08/10/2025 20:57:34 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01
08/10/2025 20:57:34 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02',
08/10/2025 20:57:34 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01
08/10/2025 20:57:34 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02',
08/10/2025 20:57:34 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01
08/10/2025 20:57:34 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02',
08/10/2025 20:57:34 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01
08/10/2025 20:57:34 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02',
08/10/2025 20:57:34 [ inc_reche_entite_geo.php ] #266 => sql_fk_entite_glo='ridba002'
08/10/2025 20:57:34 [ inc_reche_entite_geo.php ] #267 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02'
08/10/2025 20:57:34 [ 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'
08/10/2025 20:57:35 [ inc_cherche_liste_options.php ] #34 => row['fk_entite']=ridba002
08/10/2025 20:57:35 [ inc_cherche_liste_options.php ] #35 => nb_jrs_option_mosai=1
08/10/2025 20:57:35 [ inc_cherche_liste_options.php ] #36 => rech_mosai=
08/10/2025 20:57:35 [ inc_sum_hor_pax.php ] #12 => query=SELECT horaires 
      FROM dg_horaires_cal
      
08/10/2025 20:57:35 [ get_dg_package_choix.php ] #889 => plateforme=3
08/10/2025 20:57:35 [ get_dg_package_choix.php ] #910 => 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
08/10/2025 20:57:35 [ get_dg_package_choix.php ] #943 => 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_68e65a4fbb023
    WHERE partie = 2
08/10/2025 20:57:35 [ get_dg_package_choix.php ] #943 => 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_68e65a4fbb023
    WHERE partie = 2
08/10/2025 20:57:35 [ get_dg_package_choix.php ] #943 => 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_68e65a4fbb023
    WHERE partie = 2
debug get_dg_package_choix> # 10-1694 Temps : 0.5398 sec, Mémoire 4022 Ko
08/10/2025 20:57:43 [ get_essai.php ] #24 => num_jr=3---
08/10/2025 20:57:43 [ get_essai.php ] #79 => code_devise=USD---
08/10/2025 20:57:43 [ get_essai.php ] #80 => acompte_resa=169.33---
08/10/2025 20:57:43 [ get_essai.php ] #86 => nom_court=---

debug get_dg_package_choix> initialisation
08/10/2025 20:58:04 [ get_dg_package_choix.php ] #152 => rech_resa_fin=20251004
08/10/2025 20:58:04 [ get_dg_package_choix.php ] #154 => nb_nuites_dem=4
08/10/2025 20:58:04 [ inc_reche_entite_geo.php ] #38 => code_pays_rech = FRA
08/10/2025 20:58:04 [ inc_reche_entite_geo.php ] #39 => region_rech = alpes cote de provence
08/10/2025 20:58:04 [ inc_reche_entite_geo.php ] #40 => ville_rech = Marseille
08/10/2025 20:58:04 [ inc_reche_entite_geo.php ] #41 => quartier_rech = 
08/10/2025 20:58:04 [ 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'  
08/10/2025 20:58:04 [ 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'  
08/10/2025 20:58:04 [ inc_recherche_longi_lati.php ] #166 => sql_latitude =  AND lati_dd BETWEEN 41.47696599982 AND 45.07700200018 
08/10/2025 20:58:04 [ inc_recherche_longi_lati.php ] #167 => sql_longitude =  AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
08/10/2025 20:58:04 [ 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'
08/10/2025 20:58:04 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_04
08/10/2025 20:58:04 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo=
08/10/2025 20:58:04 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01
08/10/2025 20:58:04 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04',
08/10/2025 20:58:04 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01
08/10/2025 20:58:04 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01',
08/10/2025 20:58:04 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_02
08/10/2025 20:58:04 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01',
08/10/2025 20:58:04 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01
08/10/2025 20:58:04 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02',
08/10/2025 20:58:04 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01
08/10/2025 20:58:04 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02',
08/10/2025 20:58:04 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01
08/10/2025 20:58:04 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02',
08/10/2025 20:58:04 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01
08/10/2025 20:58:04 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02',
08/10/2025 20:58:04 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01
08/10/2025 20:58:04 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02',
08/10/2025 20:58:04 [ inc_reche_entite_geo.php ] #242 => row_ent_xpr['ent_geo']=ridba002_01
08/10/2025 20:58:04 [ inc_reche_entite_geo.php ] #243 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02',
08/10/2025 20:58:04 [ inc_reche_entite_geo.php ] #266 => sql_fk_entite_glo='ridba002'
08/10/2025 20:58:04 [ inc_reche_entite_geo.php ] #267 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02'
08/10/2025 20:58:04 [ 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'
08/10/2025 20:58:04 [ inc_cherche_liste_options.php ] #34 => row['fk_entite']=ridba002
08/10/2025 20:58:04 [ inc_cherche_liste_options.php ] #35 => nb_jrs_option_mosai=1
08/10/2025 20:58:04 [ inc_cherche_liste_options.php ] #36 => rech_mosai=
08/10/2025 20:58:04 [ inc_sum_hor_pax.php ] #12 => query=SELECT horaires 
      FROM dg_horaires_cal
      
08/10/2025 20:58:09 [ get_dg_package_choix.php ] #889 => plateforme=3
08/10/2025 20:58:09 [ get_dg_package_choix.php ] #910 => 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
08/10/2025 20:58:09 [ get_dg_package_choix.php ] #943 => 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_68e65a4fbb023
    WHERE partie = 2
08/10/2025 20:58:09 [ get_dg_package_choix.php ] #943 => 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_68e65a4fbb023
    WHERE partie = 2
08/10/2025 20:58:09 [ get_dg_package_choix.php ] #943 => 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_68e65a4fbb023
    WHERE partie = 2
debug get_dg_package_choix> # 10-1694 Temps : 4.6403 sec, Mémoire 7544 Ko