debug get_dg_package_choix> initialisation
15/09/2025 01:59:51 [ get_dg_package_choix.php ] #35 => _SESSION[ 'nb_entites' ]=1
15/09/2025 01:59:51 [ inc_search_num_glo.php ] #14 => data1[z] =><0300---
15/09/2025 01:59:51 [ inc_recherche_date_sla.php ] #9 => data_z=  <03:00---
15/09/2025 01:59:51 [ inc_recherche_date_sla.php ] #23 => soul_n= 0---
15/09/2025 01:59:51 [ inc_recherche_date_sla.php ] #208 => date_reconstitue = <03:00---
15/09/2025 01:59:51 [ inc_recherche_date_sla.php ] #209 => date_sla_c = <03:00---
15/09/2025 01:59:51 [ inc_recherche_date_sla.php ] #215 => sla_n = 0---
15/09/2025 01:59:51 [ inc_recherche_date_sla.php ] #216 => deux_pt_n = 1---
15/09/2025 01:59:51 [ inc_recherche_date_sla.php ] #228 => date_recherche =  < '<03:00' ---
15/09/2025 01:59:51 [ inc_reche_entite_geo.php ] #38 => code_pays_rech = FRA
15/09/2025 01:59:51 [ inc_reche_entite_geo.php ] #39 => region_rech = alpes cote de provence
15/09/2025 01:59:51 [ inc_reche_entite_geo.php ] #40 => ville_rech = Marseille
15/09/2025 01:59:51 [ inc_reche_entite_geo.php ] #41 => quartier_rech = 
15/09/2025 01:59: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'  
15/09/2025 01:59: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'  
15/09/2025 01:59:51 [ inc_recherche_longi_lati.php ] #166 => sql_latitude =  AND lati_dd BETWEEN 41.47696599982 AND 45.07700200018 
15/09/2025 01:59:51 [ inc_recherche_longi_lati.php ] #167 => sql_longitude =  AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
15/09/2025 01:59:51 [ inc_reche_entite_geo.php ] #175 => QUERY154 = 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 = 6
           
         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 41.47696599982 AND 45.07700200018 
           AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
          
         AND di_options.mode_tva_tf <> '2'
15/09/2025 01:59:51 [ inc_reche_entite_geo.php ] #210 => sql_fk_entite_glo='ridba002'
15/09/2025 01:59:51 [ inc_reche_entite_geo.php ] #211 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02'
15/09/2025 01:59:51 [ inc_reche_entite_geo.php ] #212 => cum_fk_pac_glo='cruise-A1','cruise-A2','cruise-A3','cruise-A4','cruise-A5','cruise-A6','cruise-A7','cruise-A8','cruise-A9','cruise-A10'
15/09/2025 01:59:51 [ inc_cherche_liste_options.php ] #27 => row['fk_entite']=ridba002
15/09/2025 01:59:51 [ inc_cherche_liste_options.php ] #28 => nb_jrs_option_mosai=1
15/09/2025 01:59:51 [ inc_cherche_liste_options.php ] #29 => rech_mosai=
15/09/2025 01:59:51 [ inc_sum_hor_pax.php ] #83 => 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 rofl0364_xpr.du_cat_type_heb JOIN (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)
          ON rofl0364_xpr.du_cat_type_heb.cat_type_heb = dg_type_heb.cat_type_heb
        WHERE dg_calendrier.dt_resa_cal BETWEEN '20250905' AND '20250906'
        
        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 rofl0364_xpr.du_cat_type_heb.cat_type_rech = 6
        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
debug get_dg_package_choix> # 10-1634 Temps : 2.9394 sec, Mémoire 5868 Ko

debug get_dg_package_choix> initialisation
15/09/2025 02:04:23 [ get_dg_package_choix.php ] #35 => _SESSION[ 'nb_entites' ]=1
15/09/2025 02:04:23 [ inc_search_num_glo.php ] #14 => data1[z] =><0300---
15/09/2025 02:04:23 [ inc_recherche_date_sla.php ] #9 => data_z=  <03:00---
15/09/2025 02:04:23 [ inc_recherche_date_sla.php ] #23 => soul_n= 0---
15/09/2025 02:04:23 [ inc_recherche_date_sla.php ] #209 => date_reconstitue = 03:00---
15/09/2025 02:04:23 [ inc_recherche_date_sla.php ] #210 => date_sla_c = <03:00---
15/09/2025 02:04:23 [ inc_recherche_date_sla.php ] #216 => sla_n = 0---
15/09/2025 02:04:23 [ inc_recherche_date_sla.php ] #217 => deux_pt_n = 1---
15/09/2025 02:04:23 [ inc_recherche_date_sla.php ] #229 => date_recherche =  < '03:00' ---
15/09/2025 02:04:23 [ inc_reche_entite_geo.php ] #38 => code_pays_rech = FRA
15/09/2025 02:04:23 [ inc_reche_entite_geo.php ] #39 => region_rech = alpes cote de provence
15/09/2025 02:04:23 [ inc_reche_entite_geo.php ] #40 => ville_rech = Marseille
15/09/2025 02:04:23 [ inc_reche_entite_geo.php ] #41 => quartier_rech = 
15/09/2025 02:04:23 [ 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'  
15/09/2025 02:04:23 [ 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'  
15/09/2025 02:04:23 [ inc_recherche_longi_lati.php ] #166 => sql_latitude =  AND lati_dd BETWEEN 41.47696599982 AND 45.07700200018 
15/09/2025 02:04:23 [ inc_recherche_longi_lati.php ] #167 => sql_longitude =  AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
15/09/2025 02:04:23 [ inc_reche_entite_geo.php ] #175 => QUERY154 = 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 = 6
           
         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 41.47696599982 AND 45.07700200018 
           AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
          
         AND di_options.mode_tva_tf <> '2'
15/09/2025 02:04:23 [ inc_reche_entite_geo.php ] #210 => sql_fk_entite_glo='ridba002'
15/09/2025 02:04:23 [ inc_reche_entite_geo.php ] #211 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02'
15/09/2025 02:04:23 [ inc_reche_entite_geo.php ] #212 => cum_fk_pac_glo='cruise-A1','cruise-A2','cruise-A3','cruise-A4','cruise-A5','cruise-A6','cruise-A7','cruise-A8','cruise-A9','cruise-A10'
15/09/2025 02:04:23 [ inc_cherche_liste_options.php ] #27 => row['fk_entite']=ridba002
15/09/2025 02:04:23 [ inc_cherche_liste_options.php ] #28 => nb_jrs_option_mosai=1
15/09/2025 02:04:23 [ inc_cherche_liste_options.php ] #29 => rech_mosai=
15/09/2025 02:04:23 [ inc_sum_hor_pax.php ] #83 => 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 rofl0364_xpr.du_cat_type_heb JOIN (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)
          ON rofl0364_xpr.du_cat_type_heb.cat_type_heb = dg_type_heb.cat_type_heb
        WHERE dg_calendrier.dt_resa_cal BETWEEN '20250905' AND '20250906'
        
        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 rofl0364_xpr.du_cat_type_heb.cat_type_rech = 6
        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
debug get_dg_package_choix> # 10-1634 Temps : 3.0027 sec, Mémoire 5888 Ko

debug get_dg_package_choix> initialisation
15/09/2025 02:05:48 [ get_dg_package_choix.php ] #35 => _SESSION[ 'nb_entites' ]=1
15/09/2025 02:05:48 [ inc_search_num_glo.php ] #14 => data1[z] =><0315---
15/09/2025 02:05:48 [ inc_recherche_date_sla.php ] #9 => data_z=  <03:15---
15/09/2025 02:05:48 [ inc_recherche_date_sla.php ] #23 => soul_n= 0---
15/09/2025 02:05:48 [ inc_recherche_date_sla.php ] #209 => date_reconstitue = 03:15---
15/09/2025 02:05:48 [ inc_recherche_date_sla.php ] #210 => date_sla_c = <03:15---
15/09/2025 02:05:48 [ inc_recherche_date_sla.php ] #216 => sla_n = 0---
15/09/2025 02:05:48 [ inc_recherche_date_sla.php ] #217 => deux_pt_n = 1---
15/09/2025 02:05:48 [ inc_recherche_date_sla.php ] #229 => date_recherche =  < '03:15' ---
15/09/2025 02:05:49 [ inc_reche_entite_geo.php ] #38 => code_pays_rech = FRA
15/09/2025 02:05:49 [ inc_reche_entite_geo.php ] #39 => region_rech = alpes cote de provence
15/09/2025 02:05:49 [ inc_reche_entite_geo.php ] #40 => ville_rech = Marseille
15/09/2025 02:05:49 [ inc_reche_entite_geo.php ] #41 => quartier_rech = 
15/09/2025 02:05:49 [ 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'  
15/09/2025 02:05:49 [ 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'  
15/09/2025 02:05:49 [ inc_recherche_longi_lati.php ] #166 => sql_latitude =  AND lati_dd BETWEEN 41.47696599982 AND 45.07700200018 
15/09/2025 02:05:49 [ inc_recherche_longi_lati.php ] #167 => sql_longitude =  AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
15/09/2025 02:05:49 [ inc_reche_entite_geo.php ] #175 => QUERY154 = 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 = 6
           
         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 41.47696599982 AND 45.07700200018 
           AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
          
         AND di_options.mode_tva_tf <> '2'
15/09/2025 02:05:49 [ inc_reche_entite_geo.php ] #210 => sql_fk_entite_glo='ridba002'
15/09/2025 02:05:49 [ inc_reche_entite_geo.php ] #211 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02'
15/09/2025 02:05:49 [ inc_reche_entite_geo.php ] #212 => cum_fk_pac_glo='cruise-A1','cruise-A2','cruise-A3','cruise-A4','cruise-A5','cruise-A6','cruise-A7','cruise-A8','cruise-A9','cruise-A10'
15/09/2025 02:05:49 [ inc_cherche_liste_options.php ] #27 => row['fk_entite']=ridba002
15/09/2025 02:05:49 [ inc_cherche_liste_options.php ] #28 => nb_jrs_option_mosai=1
15/09/2025 02:05:49 [ inc_cherche_liste_options.php ] #29 => rech_mosai=
15/09/2025 02:05:49 [ inc_sum_hor_pax.php ] #83 => 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 rofl0364_xpr.du_cat_type_heb JOIN (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)
          ON rofl0364_xpr.du_cat_type_heb.cat_type_heb = dg_type_heb.cat_type_heb
        WHERE dg_calendrier.dt_resa_cal BETWEEN '20250905' AND '20250906'
        
        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 rofl0364_xpr.du_cat_type_heb.cat_type_rech = 6
        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
debug get_dg_package_choix> # 10-1634 Temps : 2.4908 sec, Mémoire 5888 Ko

debug get_dg_package_choix> initialisation
15/09/2025 02:06:00 [ get_dg_package_choix.php ] #35 => _SESSION[ 'nb_entites' ]=1
15/09/2025 02:06:00 [ inc_search_num_glo.php ] #14 => data1[z] =><=0315---
15/09/2025 02:06:00 [ inc_recherche_date_sla.php ] #9 => data_z=  <=03:15---
15/09/2025 02:06:00 [ inc_recherche_date_sla.php ] #23 => soul_n= 0---
15/09/2025 02:06:00 [ inc_recherche_date_sla.php ] #209 => date_reconstitue = 03:15---
15/09/2025 02:06:00 [ inc_recherche_date_sla.php ] #210 => date_sla_c = <=03:15---
15/09/2025 02:06:00 [ inc_recherche_date_sla.php ] #216 => sla_n = 0---
15/09/2025 02:06:00 [ inc_recherche_date_sla.php ] #217 => deux_pt_n = 1---
15/09/2025 02:06:00 [ inc_recherche_date_sla.php ] #229 => date_recherche =  <= '03:15' ---
15/09/2025 02:06:00 [ inc_reche_entite_geo.php ] #38 => code_pays_rech = FRA
15/09/2025 02:06:00 [ inc_reche_entite_geo.php ] #39 => region_rech = alpes cote de provence
15/09/2025 02:06:00 [ inc_reche_entite_geo.php ] #40 => ville_rech = Marseille
15/09/2025 02:06:00 [ inc_reche_entite_geo.php ] #41 => quartier_rech = 
15/09/2025 02:06:00 [ 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'  
15/09/2025 02:06:00 [ 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'  
15/09/2025 02:06:00 [ inc_recherche_longi_lati.php ] #166 => sql_latitude =  AND lati_dd BETWEEN 41.47696599982 AND 45.07700200018 
15/09/2025 02:06:00 [ inc_recherche_longi_lati.php ] #167 => sql_longitude =  AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
15/09/2025 02:06:00 [ inc_reche_entite_geo.php ] #175 => QUERY154 = 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 = 6
           
         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 41.47696599982 AND 45.07700200018 
           AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
          
         AND di_options.mode_tva_tf <> '2'
15/09/2025 02:06:00 [ inc_reche_entite_geo.php ] #210 => sql_fk_entite_glo='ridba002'
15/09/2025 02:06:00 [ inc_reche_entite_geo.php ] #211 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02'
15/09/2025 02:06:00 [ inc_reche_entite_geo.php ] #212 => cum_fk_pac_glo='cruise-A1','cruise-A2','cruise-A3','cruise-A4','cruise-A5','cruise-A6','cruise-A7','cruise-A8','cruise-A9','cruise-A10'
15/09/2025 02:06:00 [ inc_cherche_liste_options.php ] #27 => row['fk_entite']=ridba002
15/09/2025 02:06:00 [ inc_cherche_liste_options.php ] #28 => nb_jrs_option_mosai=1
15/09/2025 02:06:00 [ inc_cherche_liste_options.php ] #29 => rech_mosai=
15/09/2025 02:06:00 [ inc_sum_hor_pax.php ] #83 => 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 rofl0364_xpr.du_cat_type_heb JOIN (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)
          ON rofl0364_xpr.du_cat_type_heb.cat_type_heb = dg_type_heb.cat_type_heb
        WHERE dg_calendrier.dt_resa_cal BETWEEN '20250905' AND '20250906'
        
        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 rofl0364_xpr.du_cat_type_heb.cat_type_rech = 6
        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
debug get_dg_package_choix> # 10-1634 Temps : 2.4292 sec, Mémoire 5898 Ko

debug get_dg_package_choix> initialisation
15/09/2025 02:07:44 [ get_dg_package_choix.php ] #35 => _SESSION[ 'nb_entites' ]=1
15/09/2025 02:07:44 [ inc_search_num_glo.php ] #14 => data1[z] =>>05092025---
15/09/2025 02:07:44 [ inc_search_num_glo.php ] #14 => data1[z] =><=0315---
15/09/2025 02:07:44 [ inc_recherche_date_sla.php ] #9 => data_z=  <=03:15---
15/09/2025 02:07:44 [ inc_recherche_date_sla.php ] #23 => soul_n= 0---
15/09/2025 02:07:44 [ inc_recherche_date_sla.php ] #209 => date_reconstitue = 03:15---
15/09/2025 02:07:44 [ inc_recherche_date_sla.php ] #210 => date_sla_c = <=03:15---
15/09/2025 02:07:44 [ inc_recherche_date_sla.php ] #216 => sla_n = 0---
15/09/2025 02:07:44 [ inc_recherche_date_sla.php ] #217 => deux_pt_n = 1---
15/09/2025 02:07:44 [ inc_recherche_date_sla.php ] #229 => date_recherche =  <= '03:15' ---
15/09/2025 02:07:44 [ inc_reche_entite_geo.php ] #38 => code_pays_rech = FRA
15/09/2025 02:07:44 [ inc_reche_entite_geo.php ] #39 => region_rech = alpes cote de provence
15/09/2025 02:07:44 [ inc_reche_entite_geo.php ] #40 => ville_rech = Marseille
15/09/2025 02:07:44 [ inc_reche_entite_geo.php ] #41 => quartier_rech = 
15/09/2025 02:07: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'  
15/09/2025 02:07: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'  
15/09/2025 02:07:44 [ inc_recherche_longi_lati.php ] #166 => sql_latitude =  AND lati_dd BETWEEN 41.47696599982 AND 45.07700200018 
15/09/2025 02:07:44 [ inc_recherche_longi_lati.php ] #167 => sql_longitude =  AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
15/09/2025 02:07:44 [ inc_reche_entite_geo.php ] #175 => QUERY154 = 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 = 6
           
         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 41.47696599982 AND 45.07700200018 
           AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
          
         AND di_options.mode_tva_tf <> '2'
15/09/2025 02:07:44 [ inc_reche_entite_geo.php ] #210 => sql_fk_entite_glo='ridba002'
15/09/2025 02:07:44 [ inc_reche_entite_geo.php ] #211 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02'
15/09/2025 02:07:44 [ inc_reche_entite_geo.php ] #212 => cum_fk_pac_glo='cruise-A1','cruise-A2','cruise-A3','cruise-A4','cruise-A5','cruise-A6','cruise-A7','cruise-A8','cruise-A9','cruise-A10'
15/09/2025 02:07:44 [ inc_cherche_liste_options.php ] #27 => row['fk_entite']=ridba002
15/09/2025 02:07:44 [ inc_cherche_liste_options.php ] #28 => nb_jrs_option_mosai=1
15/09/2025 02:07:44 [ inc_cherche_liste_options.php ] #29 => rech_mosai=
15/09/2025 02:07:44 [ inc_sum_hor_pax.php ] #83 => 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 rofl0364_xpr.du_cat_type_heb JOIN (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)
          ON rofl0364_xpr.du_cat_type_heb.cat_type_heb = dg_type_heb.cat_type_heb
        WHERE dg_calendrier.dt_resa_cal BETWEEN '20250905' AND '20250906'
        
        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 rofl0364_xpr.du_cat_type_heb.cat_type_rech = 6
        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
debug get_dg_package_choix> # 10-1634 Temps : 2.3302 sec, Mémoire 5899 Ko

debug get_dg_package_choix> initialisation
15/09/2025 02:18:34 [ get_dg_package_choix.php ] #35 => _SESSION[ 'nb_entites' ]=1
15/09/2025 02:18:34 [ inc_search_num_glo.php ] #14 => data1[z] =>>05092025---
15/09/2025 02:18:34 [ inc_search_num_glo.php ] #14 => data1[z] =><=0315---
15/09/2025 02:18:34 [ inc_recherche_date_sla.php ] #9 => data_z=  <=03:15---
15/09/2025 02:18:34 [ inc_recherche_date_sla.php ] #23 => soul_n= 0---
15/09/2025 02:18:34 [ inc_recherche_date_sla.php ] #209 => date_reconstitue = 03:15---
15/09/2025 02:18:34 [ inc_recherche_date_sla.php ] #210 => date_sla_c = <=03:15---
15/09/2025 02:18:34 [ inc_recherche_date_sla.php ] #216 => sla_n = 0---
15/09/2025 02:18:34 [ inc_recherche_date_sla.php ] #217 => deux_pt_n = 1---
15/09/2025 02:18:34 [ inc_recherche_date_sla.php ] #229 => date_recherche =  <= '03:15' ---
15/09/2025 02:18:34 [ get_dg_package_choix.php ] #82 => cum_jr_sem=
15/09/2025 02:18:34 [ inc_reche_entite_geo.php ] #38 => code_pays_rech = FRA
15/09/2025 02:18:34 [ inc_reche_entite_geo.php ] #39 => region_rech = alpes cote de provence
15/09/2025 02:18:34 [ inc_reche_entite_geo.php ] #40 => ville_rech = Marseille
15/09/2025 02:18:34 [ inc_reche_entite_geo.php ] #41 => quartier_rech = 
15/09/2025 02:18: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'  
15/09/2025 02:18: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'  
15/09/2025 02:18:34 [ inc_recherche_longi_lati.php ] #166 => sql_latitude =  AND lati_dd BETWEEN 41.47696599982 AND 45.07700200018 
15/09/2025 02:18:34 [ inc_recherche_longi_lati.php ] #167 => sql_longitude =  AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
15/09/2025 02:18:34 [ inc_reche_entite_geo.php ] #175 => QUERY154 = 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 = 6
           
         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 41.47696599982 AND 45.07700200018 
           AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
          
         AND di_options.mode_tva_tf <> '2'
15/09/2025 02:18:34 [ inc_reche_entite_geo.php ] #210 => sql_fk_entite_glo='ridba002'
15/09/2025 02:18:34 [ inc_reche_entite_geo.php ] #211 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02'
15/09/2025 02:18:34 [ inc_reche_entite_geo.php ] #212 => cum_fk_pac_glo='cruise-A1','cruise-A2','cruise-A3','cruise-A4','cruise-A5','cruise-A6','cruise-A7','cruise-A8','cruise-A9','cruise-A10'
15/09/2025 02:18:34 [ inc_cherche_liste_options.php ] #27 => row['fk_entite']=ridba002
15/09/2025 02:18:34 [ inc_cherche_liste_options.php ] #28 => nb_jrs_option_mosai=1
15/09/2025 02:18:34 [ inc_cherche_liste_options.php ] #29 => rech_mosai=
15/09/2025 02:18:34 [ inc_sum_hor_pax.php ] #83 => 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 rofl0364_xpr.du_cat_type_heb JOIN (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)
          ON rofl0364_xpr.du_cat_type_heb.cat_type_heb = dg_type_heb.cat_type_heb
        WHERE dg_calendrier.dt_resa_cal BETWEEN '20250905' AND '20250906'
        
        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 rofl0364_xpr.du_cat_type_heb.cat_type_rech = 6
        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
debug get_dg_package_choix> # 10-1637 Temps : 2.9219 sec, Mémoire 5899 Ko

debug get_dg_package_choix> initialisation
15/09/2025 02:18:46 [ get_dg_package_choix.php ] #35 => _SESSION[ 'nb_entites' ]=1
15/09/2025 02:18:46 [ get_dg_package_choix.php ] #82 => cum_jr_sem=
15/09/2025 02:18:46 [ inc_reche_entite_geo.php ] #38 => code_pays_rech = FRA
15/09/2025 02:18:46 [ inc_reche_entite_geo.php ] #39 => region_rech = alpes cote de provence
15/09/2025 02:18:46 [ inc_reche_entite_geo.php ] #40 => ville_rech = Marseille
15/09/2025 02:18:46 [ inc_reche_entite_geo.php ] #41 => quartier_rech = 
15/09/2025 02:18:46 [ 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'  
15/09/2025 02:18:46 [ 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'  
15/09/2025 02:18:46 [ inc_recherche_longi_lati.php ] #166 => sql_latitude =  AND lati_dd BETWEEN 41.47696599982 AND 45.07700200018 
15/09/2025 02:18:46 [ inc_recherche_longi_lati.php ] #167 => sql_longitude =  AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
15/09/2025 02:18:46 [ inc_reche_entite_geo.php ] #175 => QUERY154 = 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 = 6
           
         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 41.47696599982 AND 45.07700200018 
           AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
          
         AND di_options.mode_tva_tf <> '2'
15/09/2025 02:18:46 [ inc_reche_entite_geo.php ] #210 => sql_fk_entite_glo='ridba002'
15/09/2025 02:18:46 [ inc_reche_entite_geo.php ] #211 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02'
15/09/2025 02:18:46 [ inc_reche_entite_geo.php ] #212 => cum_fk_pac_glo='cruise-A1','cruise-A2','cruise-A3','cruise-A4','cruise-A5','cruise-A6','cruise-A7','cruise-A8','cruise-A9','cruise-A10'
15/09/2025 02:18:46 [ inc_cherche_liste_options.php ] #27 => row['fk_entite']=ridba002
15/09/2025 02:18:46 [ inc_cherche_liste_options.php ] #28 => nb_jrs_option_mosai=1
15/09/2025 02:18:46 [ inc_cherche_liste_options.php ] #29 => rech_mosai=
15/09/2025 02:18:46 [ inc_sum_hor_pax.php ] #83 => 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 rofl0364_xpr.du_cat_type_heb JOIN (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)
          ON rofl0364_xpr.du_cat_type_heb.cat_type_heb = dg_type_heb.cat_type_heb
        WHERE dg_calendrier.dt_resa_cal BETWEEN '20250905' AND '20250906'
        
        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 rofl0364_xpr.du_cat_type_heb.cat_type_rech = 6
        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
debug get_dg_package_choix> # 10-1637 Temps : 2.4094 sec, Mémoire 5969 Ko

debug get_dg_package_choix> initialisation
15/09/2025 02:19:08 [ get_dg_package_choix.php ] #35 => _SESSION[ 'nb_entites' ]=1
15/09/2025 02:19:08 [ inc_search_num_glo.php ] #14 => data1[z] =>>05092025---
15/09/2025 02:19:08 [ inc_recherche_date_sla.php ] #9 => data_z=  >05/09/2025---
15/09/2025 02:19:08 [ inc_recherche_date_sla.php ] #23 => soul_n= 0---
15/09/2025 02:19:08 [ inc_recherche_date_sla.php ] #140 => date_recherche = ---
15/09/2025 02:19:08 [ inc_recherche_date_sla.php ] #216 => sla_n = 2---
15/09/2025 02:19:08 [ inc_recherche_date_sla.php ] #217 => deux_pt_n = 0---
15/09/2025 02:19:08 [ inc_recherche_date_sla.php ] #229 => date_recherche =  > '20250905' ---
15/09/2025 02:19:08 [ get_dg_package_choix.php ] #82 => cum_jr_sem=
15/09/2025 02:19:08 [ inc_reche_entite_geo.php ] #38 => code_pays_rech = FRA
15/09/2025 02:19:08 [ inc_reche_entite_geo.php ] #39 => region_rech = alpes cote de provence
15/09/2025 02:19:08 [ inc_reche_entite_geo.php ] #40 => ville_rech = Marseille
15/09/2025 02:19:08 [ inc_reche_entite_geo.php ] #41 => quartier_rech = 
15/09/2025 02:19:08 [ 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'  
15/09/2025 02:19:08 [ 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'  
15/09/2025 02:19:08 [ inc_recherche_longi_lati.php ] #166 => sql_latitude =  AND lati_dd BETWEEN 41.47696599982 AND 45.07700200018 
15/09/2025 02:19:08 [ inc_recherche_longi_lati.php ] #167 => sql_longitude =  AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
15/09/2025 02:19:08 [ inc_reche_entite_geo.php ] #175 => QUERY154 = 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 = 6
           
         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 41.47696599982 AND 45.07700200018 
           AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
          
         AND di_options.mode_tva_tf <> '2'
15/09/2025 02:19:08 [ inc_reche_entite_geo.php ] #210 => sql_fk_entite_glo='ridba002'
15/09/2025 02:19:08 [ inc_reche_entite_geo.php ] #211 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02'
15/09/2025 02:19:08 [ inc_reche_entite_geo.php ] #212 => cum_fk_pac_glo='cruise-A1','cruise-A2','cruise-A3','cruise-A4','cruise-A5','cruise-A6','cruise-A7','cruise-A8','cruise-A9','cruise-A10'
15/09/2025 02:19:08 [ inc_cherche_liste_options.php ] #27 => row['fk_entite']=ridba002
15/09/2025 02:19:08 [ inc_cherche_liste_options.php ] #28 => nb_jrs_option_mosai=1
15/09/2025 02:19:08 [ inc_cherche_liste_options.php ] #29 => rech_mosai=
15/09/2025 02:19:08 [ inc_sum_hor_pax.php ] #83 => 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 rofl0364_xpr.du_cat_type_heb JOIN (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)
          ON rofl0364_xpr.du_cat_type_heb.cat_type_heb = dg_type_heb.cat_type_heb
        WHERE dg_calendrier.dt_resa_cal BETWEEN '20250905' AND '20250906'
        
        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 rofl0364_xpr.du_cat_type_heb.cat_type_rech = 6
        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
debug get_dg_package_choix> # 10-1637 Temps : 2.3467 sec, Mémoire 5923 Ko

debug get_dg_package_choix> initialisation
15/09/2025 02:19:27 [ get_dg_package_choix.php ] #35 => _SESSION[ 'nb_entites' ]=1
15/09/2025 02:19:27 [ inc_search_num_glo.php ] #14 => data1[z] =>>05092025---
15/09/2025 02:19:27 [ inc_search_num_glo.php ] #14 => data1[z] =><0300---
15/09/2025 02:19:27 [ inc_recherche_date_sla.php ] #9 => data_z=  >05/09/2025---
15/09/2025 02:19:27 [ inc_recherche_date_sla.php ] #23 => soul_n= 0---
15/09/2025 02:19:27 [ inc_recherche_date_sla.php ] #140 => date_recherche = ---
15/09/2025 02:19:27 [ inc_recherche_date_sla.php ] #216 => sla_n = 2---
15/09/2025 02:19:27 [ inc_recherche_date_sla.php ] #217 => deux_pt_n = 0---
15/09/2025 02:19:27 [ inc_recherche_date_sla.php ] #229 => date_recherche =  > '20250905' ---
15/09/2025 02:19:27 [ inc_recherche_date_sla.php ] #9 => data_z=  <03:00---
15/09/2025 02:19:27 [ inc_recherche_date_sla.php ] #23 => soul_n= 0---
15/09/2025 02:19:27 [ inc_recherche_date_sla.php ] #209 => date_reconstitue = 03:00---
15/09/2025 02:19:27 [ inc_recherche_date_sla.php ] #210 => date_sla_c = <03:00---
15/09/2025 02:19:27 [ inc_recherche_date_sla.php ] #216 => sla_n = 0---
15/09/2025 02:19:27 [ inc_recherche_date_sla.php ] #217 => deux_pt_n = 1---
15/09/2025 02:19:27 [ inc_recherche_date_sla.php ] #229 => date_recherche =  < '03:00' ---
15/09/2025 02:19:27 [ get_dg_package_choix.php ] #82 => cum_jr_sem=
15/09/2025 02:19:27 [ inc_reche_entite_geo.php ] #38 => code_pays_rech = FRA
15/09/2025 02:19:27 [ inc_reche_entite_geo.php ] #39 => region_rech = alpes cote de provence
15/09/2025 02:19:27 [ inc_reche_entite_geo.php ] #40 => ville_rech = Marseille
15/09/2025 02:19:27 [ inc_reche_entite_geo.php ] #41 => quartier_rech = 
15/09/2025 02:19: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'  
15/09/2025 02:19: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'  
15/09/2025 02:19:27 [ inc_recherche_longi_lati.php ] #166 => sql_latitude =  AND lati_dd BETWEEN 41.47696599982 AND 45.07700200018 
15/09/2025 02:19:27 [ inc_recherche_longi_lati.php ] #167 => sql_longitude =  AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
15/09/2025 02:19:27 [ inc_reche_entite_geo.php ] #175 => QUERY154 = 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 = 6
           
         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 41.47696599982 AND 45.07700200018 
           AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
          
         AND di_options.mode_tva_tf <> '2'
15/09/2025 02:19:27 [ inc_reche_entite_geo.php ] #210 => sql_fk_entite_glo='ridba002'
15/09/2025 02:19:27 [ inc_reche_entite_geo.php ] #211 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02'
15/09/2025 02:19:27 [ inc_reche_entite_geo.php ] #212 => cum_fk_pac_glo='cruise-A1','cruise-A2','cruise-A3','cruise-A4','cruise-A5','cruise-A6','cruise-A7','cruise-A8','cruise-A9','cruise-A10'
15/09/2025 02:19:27 [ inc_cherche_liste_options.php ] #27 => row['fk_entite']=ridba002
15/09/2025 02:19:27 [ inc_cherche_liste_options.php ] #28 => nb_jrs_option_mosai=1
15/09/2025 02:19:27 [ inc_cherche_liste_options.php ] #29 => rech_mosai=
15/09/2025 02:19:27 [ inc_sum_hor_pax.php ] #83 => 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 rofl0364_xpr.du_cat_type_heb JOIN (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)
          ON rofl0364_xpr.du_cat_type_heb.cat_type_heb = dg_type_heb.cat_type_heb
        WHERE dg_calendrier.dt_resa_cal BETWEEN '20250905' AND '20250906'
        
        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 rofl0364_xpr.du_cat_type_heb.cat_type_rech = 6
        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
debug get_dg_package_choix> # 10-1637 Temps : 2.8207 sec, Mémoire 5894 Ko