debug cherche_resa_et1> initialisation
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #262 => rech_resa_adu=3---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #263 => rech_hor_arr=08:45---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #300 => hor_resa_tf=1---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #301 => code_package=cruise-A2---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #302 => nb_nuites_dem=1---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #303 => rech_resa_adu=3---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #314 => code_package=cruise-A2---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #315 => fk_entite=ridba002---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #316 => plateforme=2---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #332 => rech_type_heb=ridba002-BT-STD---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #333 => rech_code_heb=---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #344 => id_agent=2---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #358 => id_agent=2---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #359 => plateforme=2---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #360 => id_tab_pac=13---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #361 => rech_mosai=0---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #386 => hor_resa_tf => "1"
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #388 => data_et1_prec => ""
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #389 => data_et1 => ""
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #390 => plateforme => "2"
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #391 => rech_resa_arr => "20250905"
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #392 => rech_resa_dep => "20250906"
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #393 => rech_resa_curr => "USD"
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #394 => rech_resa_standing => "A,B,C"
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #395 => rech_code_heb => ""
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #396 => rech_type_heb => "ridba002-BT-STD"
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #397 => rech_resa_adu => "3"
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #398 => rech_resa_enf => ""
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #399 => rech_resa_nb_heb => "1"
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #400 => rech_prix_saisi => "0"
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #457 => sql_fk_entite_glo='ridba002'
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #469 => sql_fk_entite_glo='ridba002'
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #470 => sql_fk_entite_glo = 'ridba002'
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #471 => data_choix_entite_glo = ridba002
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #480 => sql_fk_entite_glo='ridba002'
17/09/2025 18:14:00 [ inc_cherche_liste_options.php ] #34 => row['fk_entite']=ridba002
17/09/2025 18:14:00 [ inc_cherche_liste_options.php ] #35 => nb_jrs_option_mosai=1
17/09/2025 18:14:00 [ inc_cherche_liste_options.php ] #36 => rech_mosai=0
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #492 => pack_horaire=1
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #510 => plateforme=2
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #511 => nb_ent_geo_select=
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #512 => rech_plac_multi_entite=1
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #513 => code_package=cruise-A2
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #625 => AENTRE_2
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #630 => sql_fk_entite_glo='ridba002'---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #631 => data_choix_entite_glo=ridba002_01---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #635 => Adata_choix_entite=Array---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #639 => err_disct_compt_tf=---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #883 => hor_resa_tf 857=>1
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #884 => sql_fk_entite_glo 857=>'ridba002'
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #903 => QHERY870=>SELECT fk_entite, fk_code_conso, prix_ht, prix_ttc, taux_tva, nb_gratuit 
  FROM dg_heb_cout_interne
  WHERE act <> 'I'
  AND hor_tf = 1
  AND fk_status NOT IN ( 'DLT' )
  AND fk_code_conso IN ( 'RCH-SA-', 'RCH-SE-', 'RCM-MS-' )
  AND fk_entite IN ( 'ridba002' )
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1060 => sql_choix_standing=---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #32 => row['nb']=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #32 => row['nb']=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #32 => row['nb']=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #32 => row['nb']=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #32 => row['nb']=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #32 => row['nb']=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #32 => row['nb']=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #32 => row['nb']=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #32 => row['nb']=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #32 => row['nb']=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #32 => row['nb']=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #32 => row['nb']=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #32 => row['nb']=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #32 => row['nb']=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #32 => row['nb']=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #32 => row['nb']=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #32 => row['nb']=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #32 => row['nb']=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #32 => row['nb']=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #32 => row['nb']=1---
17/09/2025 18:14:00 [ inc_segments_capacite.php ] #33 => nb_jrs_sejour_min=1---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1098 => rech_code_heb=---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1099 => cpt_temp_jours_libre=20---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1100 => rech_code_heb=---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1175 => QUERY1120=SELECT ord_aff_code, code_heb, nb_pax_std, code_package
    FROM temp_jrs_libre_68ca7b6bd19de
    WHERE fini_prep = 1 AND nb_pax_std >= 3  AND code_package = 'cruise-A2'   
    ORDER BY ord_aff_code
    LIMIT 1
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1177 => AAdby->returned_rows=1---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1190 => hor_resa_tf=1---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1191 => priorite_code_heb=1---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1318 => cpt_temp_jours_libre=20---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1417 => nbdata=2---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1426 => compteur_placement_std_opt=1---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1447 => rech_code_heb=---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1448 => compteur_placement_std_opt=1---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1461 => compteur_placement_std_opt=1---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1462 => nbdata=2---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1463 => z=0---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1469 => nb_heb_compteur=0---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1471 => hypo_fk_entite=---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1487 => nb_heb_compteur=0---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1490 => recal_hypo_placement_std=0---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1517 => recal_hypo_placement_std=0---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1518 => compteur_placement_std_opt=1---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1519 => continuer_boucle_grp=1---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1520 => nb_heb_compteur=0---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1521 => rech_resa_nb_heb=1---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1529 => hypo_fk_entite=---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1530 => continuer_boucle_grp=1---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1535 => recal_hypo_placement_std=0---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1543 => prc_deposit1=50---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1552 => hypo_fk_entite=ridba002---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1553 => nb_heb_compteur=0---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1554 => rech_resa_nb_heb=1---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1559 => nb_heb_compteur=0---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1560 => continuer_boucle_grp=1---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1561 => hypo_fk_entite=ridba002---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1570 => continuer_boucle_grp=1---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1576 => rech_resa_nb_heb=1---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1577 => rech_resa_nb_heb=1---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1578 => nb_heb_compteur=0---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1579 => grp_lineaire=1---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1580 => plateforme=2---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1581 => rech_code_heb=---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1582 => rech_type_heb=ridba002-BT-STD---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1583 => compteur_placement_std_opt=1---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1584 => grp=1---
17/09/2025 18:14:00 [ inc_placement_lineaire_standard.php ] #156 => QUERY141=SELECT code_heb, ord_aff_code
  FROM temp_jrs_libre_68ca7b6bd19de
  WHERE fk_ent_geo = 'ridba002_01'    AND code_package = 'cruise-A2'  
    AND fini_prep = '1'
    AND grp = 0
    AND nb_sel_code_heb >= 1
    AND groupage3 = 1 ORDER BY nb_sel_code_heb DESC, ord_aff_code, nb_pax_std DESC, opt_facult DESC
17/09/2025 18:14:00 [ inc_placement_lineaire_standard.php ] #158 => BBdby->returned_rows=2---
17/09/2025 18:14:00 [ inc_placement_lineaire_standard.php ] #182 => CCdby->returned_rows=2---
17/09/2025 18:14:00 [ inc_placement_lineaire_standard.php ] #212 => QUERY204=SELECT code_heb, nb_pax_std, nb_pax_max, code_package, standing, nom_court_ent AS hotel_court
    FROM temp_jrs_libre_68ca7b6bd19de 
    WHERE fk_ent_geo = 'ridba002_01'           
    AND fini_prep = '1'
    AND code_heb = 'ridba002-BT-STD-01' 
    AND grp = 0 					
    AND segment_accepte = 1
    AND groupage3 = 1
17/09/2025 18:14:00 [ inc_placement_lineaire_standard.php ] #214 => dby->returned_rows=6
17/09/2025 18:14:00 [ inc_placement_lineaire_standard.php ] #230 => reste=3---
17/09/2025 18:14:00 [ inc_placement_lineaire_standard.php ] #231 => pax_compteur=3---
17/09/2025 18:14:00 [ inc_placement_lineaire_standard.php ] #233 => hypo_fk_entite_geo=ridba002_01---
17/09/2025 18:14:00 [ inc_placement_lineaire_standard.php ] #234 => row_code_heb['code_heb']=ridba002-BT-STD-01---
17/09/2025 18:14:00 [ inc_placement_lineaire_standard.php ] #235 => row_libre['code_package']=cruise-A2---
17/09/2025 18:14:00 [ inc_placement_lineaire_standard.php ] #282 => enregistrement_BLO_FIN
17/09/2025 18:14:00 [ inc_placement_lineaire_standard.php ] #285 => enregistrement_BLO
17/09/2025 18:14:00 [ inc_placement_lineaire_standard.php ] #316 => continuer_boucle_grp=1
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1594 => hypo_fk_entite=ridba002---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1595 => rech_mosai_sys_av=0---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1625 => rech_mosai_sys_ap=0---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1636 => trouve_placement_lineaire=1---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1637 => continuer_boucle_grp=1---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1638 => compteur_placement_std_opt=1---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1639 => rech_mosai=0---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1640 => rech_mosai_sys=0---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1641 => hypo_fk_entite=ridba002---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #1642 => grp=1---
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #2287 => pax_compteur=-3
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #2303 => dby->returned_rows=1
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #2310 => QUERY11=SELECT COUNT( dt_resa ) AS nb_jrs_trouve
        FROM temp_jrs_libre_68ca7b6bd19de
        WHERE fk_ent_geo = 'ridba002_01'
          AND fini_prep = '1'
          AND choix_propos = 1
          AND grp = 1
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #2323 => nb_nuites_dem=1
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #2324 => nb_jrs_trouve_grp=1
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #2335 => nb_heb_compteur=1
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #2418 => pax_compteur=-3
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #2424 => continuer_boucle_grp=1
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #2425 => hypo_fk_entite_geo37=ridba002_01
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #2429 => pax_compteur=-3
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #2430 => propos_compteur=1
17/09/2025 18:14:00 [ cherche_resa_et1.php ] #2490 => QUERY_1=SELECT fk_entite, fk_ent_geo, nom_long_ent, ville, grp, grp_lineaire, code_heb,
            code_interne, hor_resa_deb, hor_resa_fin, nb_pax_std, nb_pax_std_ori, nb_pax_max, nb_pax, grp_cpt, 
            standing, id_agent, alloc_ota, nom_agent, ppc, hotel_court, taux_tva_heb, prix_saisi, 
            prix_saisi_loc, val_change, par_pers, distance_km, ordre_entite, capa_mg, 
            dev_loc_decs, code_dev_loc, dev_dvs_decs, code_package,
            SUM( cout_heb_dvs_ht ) AS cout_heb_dvs_ht, 
            SUM( cout_heb_loc_ht ) AS cout_heb_loc_ht, 
            SUM( cout_heb ) AS cout_heb_dvs_ttc, 
            SUM( cout_heb_loc ) AS cout_heb_loc_ttc, 
            SUM( prix_saisi ) AS cout_saisi, 
            SUM( prix_saisi_loc ) AS cout_saisi_loc,
            MIN( dt_resa ) AS dt_resa_min, 
            MAX( dt_resa ) AS dt_resa_max
          FROM temp_jrs_libre_68ca7b6bd19de
          WHERE fk_ent_geo = 'ridba002_01'
            AND fini_prep = '1'
            AND choix_propos = 1
            AND grp = 1
            AND code_status = 'BLO'
          GROUP BY fk_entite, nom_long_ent, ville, grp, grp_lineaire, code_heb, 
          code_interne, nb_pax_std, nb_pax_std_ori, nb_pax_max, nb_pax, grp_cpt, 
          standing, id_agent, alloc_ota, nom_agent, ppc, hotel_court, taux_tva_heb, prix_saisi, prix_saisi_loc, 
          val_change, par_pers, distance_km, ordre_entite, capa_mg, 
          dev_loc_decs, code_dev_loc, dev_dvs_decs, code_package
          ORDER BY grp_lineaire, grp_cpt