debug get_dg_package_choix> initialisation
10/11/2025 03:13:22 [ get_dg_package_choix.php ] #80 => concat_in_where=
10/11/2025 03:13:22 [ get_dg_package_choix.php ] #157 => rech_resa_fin=20251017
10/11/2025 03:13:22 [ get_dg_package_choix.php ] #159 => nb_nuites_dem=3
10/11/2025 03:13:22 [ inc_reche_entite_geo.php ] #38 => code_pays_rech = FRA
10/11/2025 03:13:22 [ inc_reche_entite_geo.php ] #39 => region_rech = alpes cote de provence
10/11/2025 03:13:22 [ inc_reche_entite_geo.php ] #40 => ville_rech = Marseille
10/11/2025 03:13:22 [ inc_reche_entite_geo.php ] #41 => quartier_rech = 
10/11/2025 03:13:22 [ 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'  
10/11/2025 03:13:22 [ 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'  
10/11/2025 03:13:22 [ inc_recherche_longi_lati.php ] #166 => sql_latitude =  AND lati_dd BETWEEN 41.47696599982 AND 45.07700200018 
10/11/2025 03:13:22 [ inc_recherche_longi_lati.php ] #167 => sql_longitude =  AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
10/11/2025 03:13:22 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
10/11/2025 03:13:22 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo=
10/11/2025 03:13:22 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
10/11/2025 03:13:22 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo='ridba002_01',
10/11/2025 03:13:22 [ inc_reche_entite_geo.php ] #186 => sql_fk_entite_glo='ridba002'
10/11/2025 03:13:22 [ inc_reche_entite_geo.php ] #187 => cum_fk_ent_geo='ridba002_01'
10/11/2025 03:13:22 [ inc_reche_entite_geo.php ] #188 => cum_fk_pac_glo='AAAA1','AAAA2'
10/11/2025 03:13:22 [ get_dg_package_choix.php ] #717 => query_tarif600=SELECT dg_package_hor.fk_entite, dg_type_heb_rows.fk_ent_geo, 
  temp_package_choix_690f89a999414.code_pac AS fk_code_pac, temp_package_choix_690f89a999414.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_690f89a999414
    ON dg_package_hor.fk_code_pac = temp_package_choix_690f89a999414.code_pac )
    ON dg_type_heb_rows.type_heb = temp_package_choix_690f89a999414.fk_type_heb      
  WHERE jr_sem IN ( '2','3','4' )  
  AND partie = 2
  AND temp_package_choix_690f89a999414.fk_entite IN ( 'ridba002' )
  AND dg_package_hor.fk_entite IN ( 'ridba002' )
  AND dg_type_heb_rows.fk_entite IN ( 'ridba002' )
10/11/2025 03:13:22 [ inc_cherche_liste_options.php ] #34 => row['fk_entite']=ridba002
10/11/2025 03:13:22 [ inc_cherche_liste_options.php ] #35 => nb_jrs_option_mosai=1
10/11/2025 03:13:22 [ inc_cherche_liste_options.php ] #36 => rech_mosai=
10/11/2025 03:13:22 [ get_dg_package_choix.php ] #1069 => fk_entite_pac=ridba002
10/11/2025 03:13:22 [ get_dg_package_choix.php ] #1078 => nb_nts_max=2
10/11/2025 03:13:22 [ get_dg_package_choix.php ] #1091 => cum_dates_package='20251015','20251016'
10/11/2025 03:13:22 [ get_dg_package_choix.php ] #1092 => fk_entite_pac=ridba002
debug get_dg_package_choix> # 10-1673 Temps : 0.3599 sec, Mémoire 2965 Ko

debug get_dg_package_choix> initialisation
10/11/2025 03:27:58 [ get_dg_package_choix.php ] #80 => concat_in_where=
10/11/2025 03:27:58 [ get_dg_package_choix.php ] #157 => rech_resa_fin=20251017
10/11/2025 03:27:58 [ get_dg_package_choix.php ] #159 => nb_nuites_dem=3
10/11/2025 03:27:58 [ inc_reche_entite_geo.php ] #38 => code_pays_rech = FRA
10/11/2025 03:27:58 [ inc_reche_entite_geo.php ] #39 => region_rech = alpes cote de provence
10/11/2025 03:27:58 [ inc_reche_entite_geo.php ] #40 => ville_rech = Marseille
10/11/2025 03:27:58 [ inc_reche_entite_geo.php ] #41 => quartier_rech = 
10/11/2025 03:27:58 [ 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'  
10/11/2025 03:27:58 [ 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'  
10/11/2025 03:27:58 [ inc_recherche_longi_lati.php ] #166 => sql_latitude =  AND lati_dd BETWEEN 41.47696599982 AND 45.07700200018 
10/11/2025 03:27:58 [ inc_recherche_longi_lati.php ] #167 => sql_longitude =  AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
10/11/2025 03:27:58 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
10/11/2025 03:27:58 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo=
10/11/2025 03:27:58 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
10/11/2025 03:27:58 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo='ridba002_01',
10/11/2025 03:27:58 [ inc_reche_entite_geo.php ] #186 => sql_fk_entite_glo='ridba002'
10/11/2025 03:27:58 [ inc_reche_entite_geo.php ] #187 => cum_fk_ent_geo='ridba002_01'
10/11/2025 03:27:58 [ inc_reche_entite_geo.php ] #188 => cum_fk_pac_glo='AAAA1','AAAA2'
10/11/2025 03:27:58 [ get_dg_package_choix.php ] #718 => query_tarif600=SELECT dg_package_hor.fk_entite, dg_type_heb_rows.fk_ent_geo, 
  temp_package_choix_690f89a999414.code_pac AS fk_code_pac, temp_package_choix_690f89a999414.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_690f89a999414
    ON dg_package_hor.fk_code_pac = temp_package_choix_690f89a999414.code_pac )
    ON dg_type_heb_rows.type_heb = temp_package_choix_690f89a999414.fk_type_heb      
  WHERE jr_sem IN ( '2','3','4' )  
  AND partie = 2
  AND temp_package_choix_690f89a999414.fk_entite IN ( 'ridba002' )
  AND dg_package_hor.fk_entite IN ( 'ridba002' )
  AND dg_type_heb_rows.fk_entite IN ( 'ridba002' )
10/11/2025 03:27:58 [ get_dg_package_choix.php ] #720 => nb_pac_hor=0
10/11/2025 03:27:58 [ inc_cherche_liste_options.php ] #34 => row['fk_entite']=ridba002
10/11/2025 03:27:58 [ inc_cherche_liste_options.php ] #35 => nb_jrs_option_mosai=1
10/11/2025 03:27:58 [ inc_cherche_liste_options.php ] #36 => rech_mosai=
10/11/2025 03:27:58 [ get_dg_package_choix.php ] #1070 => fk_entite_pac=ridba002
10/11/2025 03:27:58 [ get_dg_package_choix.php ] #1079 => nb_nts_max=2
10/11/2025 03:27:58 [ get_dg_package_choix.php ] #1092 => cum_dates_package='20251015','20251016'
10/11/2025 03:27:58 [ get_dg_package_choix.php ] #1093 => fk_entite_pac=ridba002
debug get_dg_package_choix> # 10-1674 Temps : 0.3598 sec, Mémoire 3036 Ko

debug get_dg_package_choix> initialisation
10/11/2025 03:38:40 [ get_dg_package_choix.php ] #80 => concat_in_where=
10/11/2025 03:38:40 [ get_dg_package_choix.php ] #157 => rech_resa_fin=20251017
10/11/2025 03:38:40 [ get_dg_package_choix.php ] #159 => nb_nuites_dem=3
10/11/2025 03:38:40 [ inc_reche_entite_geo.php ] #38 => code_pays_rech = FRA
10/11/2025 03:38:40 [ inc_reche_entite_geo.php ] #39 => region_rech = alpes cote de provence
10/11/2025 03:38:40 [ inc_reche_entite_geo.php ] #40 => ville_rech = Marseille
10/11/2025 03:38:40 [ inc_reche_entite_geo.php ] #41 => quartier_rech = 
10/11/2025 03:38:40 [ 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'  
10/11/2025 03:38:40 [ 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'  
10/11/2025 03:38:40 [ inc_recherche_longi_lati.php ] #166 => sql_latitude =  AND lati_dd BETWEEN 41.47696599982 AND 45.07700200018 
10/11/2025 03:38:40 [ inc_recherche_longi_lati.php ] #167 => sql_longitude =  AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
10/11/2025 03:38:40 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
10/11/2025 03:38:40 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo=
10/11/2025 03:38:40 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
10/11/2025 03:38:40 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo='ridba002_01',
10/11/2025 03:38:40 [ inc_reche_entite_geo.php ] #186 => sql_fk_entite_glo='ridba002'
10/11/2025 03:38:40 [ inc_reche_entite_geo.php ] #187 => cum_fk_ent_geo='ridba002_01'
10/11/2025 03:38:40 [ inc_reche_entite_geo.php ] #188 => cum_fk_pac_glo='AAAA1','AAAA2'
10/11/2025 03:38:41 [ get_dg_package_choix.php ] #718 => query_tarif600=SELECT dg_package_hor.fk_entite, dg_type_heb_rows.fk_ent_geo, 
  temp_package_choix_690f89a999414.code_pac AS fk_code_pac, temp_package_choix_690f89a999414.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_690f89a999414
    ON dg_package_hor.fk_code_pac = temp_package_choix_690f89a999414.code_pac )
    ON dg_type_heb_rows.type_heb = temp_package_choix_690f89a999414.fk_type_heb      
  WHERE jr_sem IN ( '2','3','4' )  
  AND partie = 2
  AND temp_package_choix_690f89a999414.fk_entite IN ( 'ridba002' )
  AND dg_package_hor.fk_entite IN ( 'ridba002' )
  AND dg_type_heb_rows.fk_entite IN ( 'ridba002' )
10/11/2025 03:38:41 [ get_dg_package_choix.php ] #720 => nb_pac_hor=0
debug get_dg_package_choix> # 10-1675 Temps : 0.1376 sec, Mémoire 1700 Ko

debug get_dg_package_choix> initialisation
10/11/2025 03:41:47 [ get_dg_package_choix.php ] #80 => concat_in_where=
10/11/2025 03:41:47 [ get_dg_package_choix.php ] #157 => rech_resa_fin=20251017
10/11/2025 03:41:47 [ get_dg_package_choix.php ] #159 => nb_nuites_dem=3
10/11/2025 03:41:47 [ inc_reche_entite_geo.php ] #38 => code_pays_rech = FRA
10/11/2025 03:41:47 [ inc_reche_entite_geo.php ] #39 => region_rech = alpes cote de provence
10/11/2025 03:41:47 [ inc_reche_entite_geo.php ] #40 => ville_rech = Marseille
10/11/2025 03:41:47 [ inc_reche_entite_geo.php ] #41 => quartier_rech = 
10/11/2025 03:41:47 [ 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'  
10/11/2025 03:41:47 [ 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'  
10/11/2025 03:41:47 [ inc_recherche_longi_lati.php ] #166 => sql_latitude =  AND lati_dd BETWEEN 41.47696599982 AND 45.07700200018 
10/11/2025 03:41:47 [ inc_recherche_longi_lati.php ] #167 => sql_longitude =  AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
10/11/2025 03:41:47 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
10/11/2025 03:41:47 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo=
10/11/2025 03:41:47 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
10/11/2025 03:41:47 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo='ridba002_01',
10/11/2025 03:41:47 [ inc_reche_entite_geo.php ] #186 => sql_fk_entite_glo='ridba002'
10/11/2025 03:41:47 [ inc_reche_entite_geo.php ] #187 => cum_fk_ent_geo='ridba002_01'
10/11/2025 03:41:47 [ inc_reche_entite_geo.php ] #188 => cum_fk_pac_glo='AAAA1','AAAA2'
10/11/2025 03:41:47 [ get_dg_package_choix.php ] #718 => query_tarif600=SELECT dg_package_hor.fk_entite, dg_type_heb_rows.fk_ent_geo, 
  temp_package_choix_690f89a999414.code_pac AS fk_code_pac, temp_package_choix_690f89a999414.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_690f89a999414
    ON dg_package_hor.fk_code_pac = temp_package_choix_690f89a999414.code_pac )
    ON dg_type_heb_rows.type_heb = temp_package_choix_690f89a999414.fk_type_heb      
  WHERE jr_sem IN ( '2','3','4' )  
  AND partie = 2
  AND temp_package_choix_690f89a999414.fk_entite IN ( 'ridba002' )
  AND dg_package_hor.fk_entite IN ( 'ridba002' )
  AND dg_type_heb_rows.fk_entite IN ( 'ridba002' )
10/11/2025 03:41:47 [ get_dg_package_choix.php ] #720 => nb_pac_hor=0
10/11/2025 03:41:47 [ get_dg_package_choix.php ] #745 => nb_pac_horAV=0
debug get_dg_package_choix> # 10-1677 Temps : 0.1403 sec, Mémoire 1700 Ko

debug get_dg_package_choix> initialisation
10/11/2025 07:48:11 [ get_dg_package_choix.php ] #80 => concat_in_where=
10/11/2025 07:48:11 [ get_dg_package_choix.php ] #157 => rech_resa_fin=20251017
10/11/2025 07:48:11 [ get_dg_package_choix.php ] #159 => nb_nuites_dem=3
10/11/2025 07:48:11 [ inc_reche_entite_geo.php ] #38 => code_pays_rech = FRA
10/11/2025 07:48:11 [ inc_reche_entite_geo.php ] #39 => region_rech = alpes cote de provence
10/11/2025 07:48:11 [ inc_reche_entite_geo.php ] #40 => ville_rech = Marseille
10/11/2025 07:48:11 [ inc_reche_entite_geo.php ] #41 => quartier_rech = 
10/11/2025 07:48:11 [ 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'  
10/11/2025 07:48:11 [ 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'  
10/11/2025 07:48:11 [ inc_recherche_longi_lati.php ] #166 => sql_latitude =  AND lati_dd BETWEEN 41.47696599982 AND 45.07700200018 
10/11/2025 07:48:11 [ inc_recherche_longi_lati.php ] #167 => sql_longitude =  AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
10/11/2025 07:48:11 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
10/11/2025 07:48:11 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo=
10/11/2025 07:48:11 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
10/11/2025 07:48:11 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo='ridba002_01',
10/11/2025 07:48:11 [ inc_reche_entite_geo.php ] #186 => sql_fk_entite_glo='ridba002'
10/11/2025 07:48:11 [ inc_reche_entite_geo.php ] #187 => cum_fk_ent_geo='ridba002_01'
10/11/2025 07:48:11 [ inc_reche_entite_geo.php ] #188 => cum_fk_pac_glo='AAAA1','AAAA2'
10/11/2025 07:48:12 [ get_dg_package_choix.php ] #722 => query_tarif600=SELECT dg_package_hor.fk_entite, dg_type_heb_rows.fk_ent_geo, 
  temp_package_choix_690f89a999414.code_pac AS fk_code_pac, temp_package_choix_690f89a999414.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_690f89a999414
    ON dg_package_hor.fk_code_pac = temp_package_choix_690f89a999414.code_pac )
    ON dg_type_heb_rows.type_heb = temp_package_choix_690f89a999414.fk_type_heb      
  WHERE jr_sem IN ( '2','3','4' )  
  AND partie = 2
  AND temp_package_choix_690f89a999414.fk_entite IN ( 'ridba002' )
  AND dg_package_hor.fk_entite IN ( 'ridba002' )
  AND dg_type_heb_rows.fk_entite IN ( 'ridba002' )
10/11/2025 07:48:12 [ get_dg_package_choix.php ] #724 => nb_pac_hor=0
10/11/2025 07:48:12 [ get_dg_package_choix.php ] #749 => nb_pac_horAV=0
debug get_dg_package_choix> # 10-1681 Temps : 0.1920 sec, Mémoire 1707 Ko

debug get_dg_package_choix> initialisation
10/11/2025 07:49:01 [ get_dg_package_choix.php ] #80 => concat_in_where=
10/11/2025 07:49:01 [ get_dg_package_choix.php ] #157 => rech_resa_fin=20251017
10/11/2025 07:49:01 [ get_dg_package_choix.php ] #159 => nb_nuites_dem=3
10/11/2025 07:49:01 [ inc_reche_entite_geo.php ] #38 => code_pays_rech = FRA
10/11/2025 07:49:01 [ inc_reche_entite_geo.php ] #39 => region_rech = alpes cote de provence
10/11/2025 07:49:01 [ inc_reche_entite_geo.php ] #40 => ville_rech = Marseille
10/11/2025 07:49:01 [ inc_reche_entite_geo.php ] #41 => quartier_rech = 
10/11/2025 07:49:01 [ 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'  
10/11/2025 07:49:01 [ 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'  
10/11/2025 07:49:01 [ inc_recherche_longi_lati.php ] #166 => sql_latitude =  AND lati_dd BETWEEN 41.47696599982 AND 45.07700200018 
10/11/2025 07:49:01 [ inc_recherche_longi_lati.php ] #167 => sql_longitude =  AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
10/11/2025 07:49:01 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
10/11/2025 07:49:01 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo=
10/11/2025 07:49:01 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
10/11/2025 07:49:01 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo='ridba002_01',
10/11/2025 07:49:01 [ inc_reche_entite_geo.php ] #186 => sql_fk_entite_glo='ridba002'
10/11/2025 07:49:01 [ inc_reche_entite_geo.php ] #187 => cum_fk_ent_geo='ridba002_01'
10/11/2025 07:49:01 [ inc_reche_entite_geo.php ] #188 => cum_fk_pac_glo='AAAA1','AAAA2'
10/11/2025 07:49:01 [ get_dg_package_choix.php ] #722 => query_tarif600=SELECT dg_package_hor.fk_entite, dg_type_heb_rows.fk_ent_geo, 
  temp_package_choix_690f89a999414.code_pac AS fk_code_pac, temp_package_choix_690f89a999414.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_690f89a999414
    ON dg_package_hor.fk_code_pac = temp_package_choix_690f89a999414.code_pac )
    ON dg_type_heb_rows.type_heb = temp_package_choix_690f89a999414.fk_type_heb      
  WHERE jr_sem IN ( '2','3','4' )  
  AND partie = 2
  AND temp_package_choix_690f89a999414.fk_entite IN ( 'ridba002' )
  AND dg_package_hor.fk_entite IN ( 'ridba002' )
  AND dg_type_heb_rows.fk_entite IN ( 'ridba002' )
10/11/2025 07:49:01 [ get_dg_package_choix.php ] #724 => nb_pac_hor=0
10/11/2025 07:49:01 [ get_dg_package_choix.php ] #749 => nb_pac_horAV=0
10/11/2025 07:49:01 [ get_dg_package_choix.php ] #753 => nb_pac_horAP=0
10/11/2025 07:49:01 [ inc_cherche_liste_options.php ] #34 => row['fk_entite']=ridba002
10/11/2025 07:49:01 [ inc_cherche_liste_options.php ] #35 => nb_jrs_option_mosai=1
10/11/2025 07:49:01 [ inc_cherche_liste_options.php ] #36 => rech_mosai=
10/11/2025 07:49:01 [ get_dg_package_choix.php ] #1078 => fk_entite_pac=ridba002
10/11/2025 07:49:01 [ get_dg_package_choix.php ] #1087 => nb_nts_max=2
10/11/2025 07:49:01 [ get_dg_package_choix.php ] #1100 => cum_dates_package='20251015','20251016'
10/11/2025 07:49:01 [ get_dg_package_choix.php ] #1101 => fk_entite_pac=ridba002
debug get_dg_package_choix> # 10-1681 Temps : 0.3642 sec, Mémoire 3041 Ko

debug get_dg_package_choix> initialisation
10/11/2025 08:03:09 [ get_dg_package_choix.php ] #80 => concat_in_where=
10/11/2025 08:03:09 [ get_dg_package_choix.php ] #157 => rech_resa_fin=20251017
10/11/2025 08:03:09 [ get_dg_package_choix.php ] #159 => nb_nuites_dem=3
10/11/2025 08:03:09 [ inc_reche_entite_geo.php ] #38 => code_pays_rech = FRA
10/11/2025 08:03:09 [ inc_reche_entite_geo.php ] #39 => region_rech = alpes cote de provence
10/11/2025 08:03:09 [ inc_reche_entite_geo.php ] #40 => ville_rech = Marseille
10/11/2025 08:03:09 [ inc_reche_entite_geo.php ] #41 => quartier_rech = 
10/11/2025 08:03:09 [ 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'  
10/11/2025 08:03:09 [ 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'  
10/11/2025 08:03:09 [ inc_recherche_longi_lati.php ] #166 => sql_latitude =  AND lati_dd BETWEEN 41.47696599982 AND 45.07700200018 
10/11/2025 08:03:09 [ inc_recherche_longi_lati.php ] #167 => sql_longitude =  AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
10/11/2025 08:03:09 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
10/11/2025 08:03:09 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo=
10/11/2025 08:03:09 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
10/11/2025 08:03:09 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo='ridba002_01',
10/11/2025 08:03:09 [ inc_reche_entite_geo.php ] #186 => sql_fk_entite_glo='ridba002'
10/11/2025 08:03:09 [ inc_reche_entite_geo.php ] #187 => cum_fk_ent_geo='ridba002_01'
10/11/2025 08:03:09 [ inc_reche_entite_geo.php ] #188 => cum_fk_pac_glo='AAAA1','AAAA2'
10/11/2025 08:03:09 [ get_dg_package_choix.php ] #725 => query_tarif600=SELECT dg_package_hor.fk_entite, dg_type_heb_rows.fk_ent_geo, 
  temp_package_choix_690f89a999414.code_pac AS fk_code_pac, temp_package_choix_690f89a999414.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_690f89a999414
    ON dg_package_hor.fk_code_pac = temp_package_choix_690f89a999414.code_pac )
    ON dg_type_heb_rows.type_heb = temp_package_choix_690f89a999414.fk_type_heb      
  WHERE jr_sem IN ( '2','3','4' )  
  AND partie = 2
  AND nuitee_horaire = ?
  AND temp_package_choix_690f89a999414.fk_entite IN ( 'ridba002' )
  AND dg_package_hor.fk_entite IN ( 'ridba002' )
  AND dg_type_heb_rows.fk_entite IN ( 'ridba002' )
10/11/2025 08:03:09 [ get_dg_package_choix.php ] #727 => nb_pac_hor=0
10/11/2025 08:03:09 [ get_dg_package_choix.php ] #752 => nb_pac_horAV=0
10/11/2025 08:03:09 [ get_dg_package_choix.php ] #756 => nb_pac_horAP=0
10/11/2025 08:03:09 [ inc_cherche_liste_options.php ] #34 => row['fk_entite']=ridba002
10/11/2025 08:03:09 [ inc_cherche_liste_options.php ] #35 => nb_jrs_option_mosai=1
10/11/2025 08:03:09 [ inc_cherche_liste_options.php ] #36 => rech_mosai=
10/11/2025 08:03:10 [ get_dg_package_choix.php ] #1081 => fk_entite_pac=ridba002
10/11/2025 08:03:10 [ get_dg_package_choix.php ] #1090 => nb_nts_max=2
10/11/2025 08:03:10 [ get_dg_package_choix.php ] #1103 => cum_dates_package='20251015','20251016'
10/11/2025 08:03:10 [ get_dg_package_choix.php ] #1104 => fk_entite_pac=ridba002
debug get_dg_package_choix> # 10-1684 Temps : 0.3216 sec, Mémoire 3046 Ko

debug get_dg_package_choix> initialisation
10/11/2025 08:12:36 [ get_dg_package_choix.php ] #80 => concat_in_where=
10/11/2025 08:12:36 [ get_dg_package_choix.php ] #158 => rech_resa_fin=20251017
10/11/2025 08:12:36 [ get_dg_package_choix.php ] #160 => nb_nuites_dem=3
10/11/2025 08:12:36 [ inc_reche_entite_geo.php ] #38 => code_pays_rech = FRA
10/11/2025 08:12:36 [ inc_reche_entite_geo.php ] #39 => region_rech = alpes cote de provence
10/11/2025 08:12:36 [ inc_reche_entite_geo.php ] #40 => ville_rech = Marseille
10/11/2025 08:12:36 [ inc_reche_entite_geo.php ] #41 => quartier_rech = 
10/11/2025 08:12:36 [ 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'  
10/11/2025 08:12:36 [ 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'  
10/11/2025 08:12:36 [ inc_recherche_longi_lati.php ] #166 => sql_latitude =  AND lati_dd BETWEEN 41.47696599982 AND 45.07700200018 
10/11/2025 08:12:36 [ inc_recherche_longi_lati.php ] #167 => sql_longitude =  AND longi_dd BETWEEN 2.9320034807907 AND 7.8767805192093 
10/11/2025 08:12:36 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
10/11/2025 08:12:36 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo=
10/11/2025 08:12:36 [ inc_reche_entite_geo.php ] #162 => row_ent_xpr['ent_geo']=ridba002_01
10/11/2025 08:12:36 [ inc_reche_entite_geo.php ] #163 => cum_fk_ent_geo='ridba002_01',
10/11/2025 08:12:36 [ inc_reche_entite_geo.php ] #186 => sql_fk_entite_glo='ridba002'
10/11/2025 08:12:36 [ inc_reche_entite_geo.php ] #187 => cum_fk_ent_geo='ridba002_01'
10/11/2025 08:12:36 [ inc_reche_entite_geo.php ] #188 => cum_fk_pac_glo='AAAA1','AAAA2'
10/11/2025 08:12:36 [ get_dg_package_choix.php ] #728 => query_tarif600=SELECT dg_package_hor.fk_entite, dg_type_heb_rows.fk_ent_geo, 
  temp_package_choix_690f89a999414.code_pac AS fk_code_pac, temp_package_choix_690f89a999414.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_690f89a999414
    ON dg_package_hor.fk_code_pac = temp_package_choix_690f89a999414.code_pac )
    ON dg_type_heb_rows.type_heb = temp_package_choix_690f89a999414.fk_type_heb      
  WHERE jr_sem IN ( '2','3','4' )  
  AND partie = 2
  
  AND temp_package_choix_690f89a999414.fk_entite IN ( 'ridba002' )
  AND dg_package_hor.fk_entite IN ( 'ridba002' )
  AND dg_type_heb_rows.fk_entite IN ( 'ridba002' )
10/11/2025 08:12:36 [ get_dg_package_choix.php ] #730 => nb_pac_hor=0
10/11/2025 08:12:36 [ get_dg_package_choix.php ] #755 => nb_pac_horAV=0
10/11/2025 08:12:36 [ get_dg_package_choix.php ] #759 => nb_pac_horAP=0
10/11/2025 08:12:36 [ inc_cherche_liste_options.php ] #34 => row['fk_entite']=ridba002
10/11/2025 08:12:36 [ inc_cherche_liste_options.php ] #35 => nb_jrs_option_mosai=1
10/11/2025 08:12:36 [ inc_cherche_liste_options.php ] #36 => rech_mosai=
debug get_dg_package_choix> # 10-1687 Temps : 0.2114 sec, Mémoire 2404 Ko