debug get_dg_package_choix> initialisation
22/08/2025 01:25:43 [ get_dg_package_choix.php ] #35 => _SESSION[ 'nb_entites' ]=1
22/08/2025 01:25:43 [ get_dg_package_choix.php ] #142 => rech_resa_arr=20250824
22/08/2025 01:25:43 [ get_dg_package_choix.php ] #143 => num_jr=0
22/08/2025 01:25:43 [ get_dg_package_choix.php ] #145 => dt_fin_dem=20250824
22/08/2025 01:25:43 [ get_dg_package_choix.php ] #146 => nb_nuites_dem=1
22/08/2025 01:25:43 [ get_dg_package_choix.php ] #147 => nb_nuites_dem=1
22/08/2025 01:25:43 [ inc_reche_entite_geo.php ] #38 => code_pays_rech = FRA
22/08/2025 01:25:43 [ inc_reche_entite_geo.php ] #39 => region_rech = alpes cote de provence
22/08/2025 01:25:43 [ inc_reche_entite_geo.php ] #40 => ville_rech = Marseille
22/08/2025 01:25:43 [ inc_reche_entite_geo.php ] #41 => quartier_rech = 
22/08/2025 01:25:43 [ 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'  
22/08/2025 01:25:43 [ 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'  
22/08/2025 01:25:43 [ inc_recherche_longi_lati.php ] #166 => sql_latitude =  AND lati_dd BETWEEN 40.126952499685 AND 46.427015500315 
22/08/2025 01:25:43 [ inc_recherche_longi_lati.php ] #167 => sql_longitude =  AND longi_dd BETWEEN 1.0777120913837 AND 9.7310719086163 
22/08/2025 01:25:43 [ inc_reche_entite_geo.php ] #174 => QUERY = SELECT xpr_dg_entites.entite, xpr_dg_entites.ent_geo, dg_package.code_pac, dg_type_heb.cat_type_heb
        FROM du_cat_type_heb JOIN 
          ( dg_type_heb JOIN 
            ( dg_package JOIN 
              ( xpr_dg_entites JOIN di_options 
              ON xpr_dg_entites.entite = di_options.fk_entite )
              ON xpr_dg_entites.ent_geo = dg_package.fk_ent_geo )
              ON dg_package.fk_type_heb = dg_type_heb.type_heb )
              ON du_cat_type_heb.cat_type_heb = dg_type_heb.cat_type_heb
        WHERE du_cat_type_heb.cat_type_rech = 4
           
         AND xpr_dg_entites.act <> 'I'   
         AND xpr_dg_entites.fk_status <> 'DLT'
         AND du_cat_type_heb.act <> 'I'
         AND du_cat_type_heb.fk_status <> 'DLT'
         AND dg_package.act <> 'I'
         AND dg_package.fk_status <> 'DLT'         
           AND lati_dd BETWEEN 40.126952499685 AND 46.427015500315 
           AND longi_dd BETWEEN 1.0777120913837 AND 9.7310719086163 
          
         AND di_options.mode_tva_tf <> '2'
22/08/2025 01:25:43 [ inc_reche_entite_geo.php ] #209 => sql_fk_entite_glo='ridba002'
22/08/2025 01:25:43 [ inc_reche_entite_geo.php ] #210 => cum_fk_ent_geo='ridba002_04','ridba002_01','ridba002_02'
22/08/2025 01:25:43 [ inc_reche_entite_geo.php ] #211 => cum_fk_pac_glo='cruise-A1','cruise-A2','cruise-A3','cruise-A4','cruise-A5','cruise-A6','cruise-A7','cruise-A8','cruise-A9','cruise-A10'
22/08/2025 01:25:43 [ get_dg_package_choix.php ] #216 => sql_fk_ent_geo= AND dg_package.fk_ent_geo IN ( 'ridba002_04','ridba002_01','ridba002_02' ) 
22/08/2025 01:25:43 [ get_dg_package_choix.php ] #217 => sql_temp_pac_ent_geo= AND temp_package_choix_68a6fa9cba0b0.fk_ent_geo IN ( 'ridba002_04','ridba002_01','ridba002_02' ) 
22/08/2025 01:25:43 [ get_dg_package_choix.php ] #218 => sql_fk_pac_glo= AND dg_package.code_pac IN ( 'cruise-A1','cruise-A2','cruise-A3','cruise-A4','cruise-A5','cruise-A6','cruise-A7','cruise-A8','cruise-A9','cruise-A10' ) 
22/08/2025 01:25:43 [ get_dg_package_choix.php ] #297 => sql_fk_entite_glo='ridba002'---
22/08/2025 01:25:43 [ get_dg_package_choix.php ] #298 => sql_package_plateforme= AND dg_package.site_web = '1' ---
22/08/2025 01:25:43 [ get_dg_package_choix.php ] #299 => sql_fk_ent_geo= AND dg_package.fk_ent_geo IN ( 'ridba002_04','ridba002_01','ridba002_02' ) ---
22/08/2025 01:25:43 [ get_dg_package_choix.php ] #300 => sql_fk_pac_glo= AND dg_package.code_pac IN ( 'cruise-A1','cruise-A2','cruise-A3','cruise-A4','cruise-A5','cruise-A6','cruise-A7','cruise-A8','cruise-A9','cruise-A10' ) ---
22/08/2025 01:25:43 [ get_dg_package_choix.php ] #387 => sql_fk_pac_glo1= AND dg_package.code_pac IN ( 'cruise-A1','cruise-A2','cruise-A3','cruise-A4','cruise-A5','cruise-A6','cruise-A7','cruise-A8','cruise-A9','cruise-A10' ) ---
22/08/2025 01:25:43 [ get_dg_package_choix.php ] #389 => sql_fk_pac_glo2= AND dg_package.code_pac IN ( 'cruise-A1','cruise-A2','cruise-A3','cruise-A4','cruise-A5','cruise-A6','cruise-A7','cruise-A8','cruise-A9','cruise-A10' ) ---
22/08/2025 01:25:43 [ get_dg_package_choix.php ] #490 => sql_fk_pac_glo3= AND dg_package.code_pac IN ( 'cruise-A1','cruise-A2','cruise-A3','cruise-A4','cruise-A5','cruise-A6','cruise-A7','cruise-A8','cruise-A9','cruise-A10' ) ---
22/08/2025 01:25:43 [ get_dg_package_choix.php ] #492 => sql_fk_pac_glo4= AND dg_package.code_pac IN ( 'cruise-A1','cruise-A2','cruise-A3','cruise-A4','cruise-A5','cruise-A6','cruise-A7','cruise-A8','cruise-A9','cruise-A10' ) ---
22/08/2025 01:25:43 [ get_dg_package_choix.php ] #550 => sql_cum_type_heb_pac= 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' ) 
22/08/2025 01:25:43 [ get_dg_package_choix.php ] #575 => query_tarif=SELECT dg_package_hor.fk_entite, dg_package_hor.fk_ent_geo, 
temp_package_choix_68a6fa9cba0b0.code_pac AS fk_code_pac, temp_package_choix_68a6fa9cba0b0.fk_type_heb, 
hor_deb_bas, hor_fin_bas, hor_deb_hte, hor_fin_hte, hor_deb_tha, hor_fin_tha
FROM dg_package_hor JOIN temp_package_choix_68a6fa9cba0b0
  ON dg_package_hor.fk_code_pac = temp_package_choix_68a6fa9cba0b0.code_pac      
WHERE jr_sem = ?  
AND partie = 2
AND temp_package_choix_68a6fa9cba0b0.fk_entite IN ( 'ridba002' )
AND dg_package_hor.fk_entite IN ( 'ridba002' )
22/08/2025 01:25:43 [ get_dg_package_choix.php ] #576 => num_jr=0
22/08/2025 01:25:43 [ get_dg_package_choix.php ] #577 => nb_pac_hor=0
22/08/2025 01:25:43 [ inc_cherche_liste_options.php ] #26 => row['fk_entite']=ridba002
22/08/2025 01:25:43 [ inc_cherche_liste_options.php ] #27 => nb_jrs_option_mosai=1
22/08/2025 01:25:43 [ inc_cherche_liste_options.php ] #28 => rech_mosai=
22/08/2025 01:25:43 [ inc_ins_temp_jrs_libre.php ] #8 => hor_resa_tf=