Warning: Invalid argument supplied for foreach() in /home/ryokan/public_html/LibClass/JtbAPI.class.php on line 90

Warning: Invalid argument supplied for foreach() in /home/ryokan/public_html/LibClass/JtbAPI.class.php on line 90

Warning: Invalid argument supplied for foreach() in /home/ryokan/public_html/LibClass/JtbAPI.class.php on line 90

Warning: Invalid argument supplied for foreach() in /home/ryokan/public_html/LibClass/JtbAPI.class.php on line 90

Warning: Invalid argument supplied for foreach() in /home/ryokan/public_html/LibClass/JtbAPI.class.php on line 90

Warning: Invalid argument supplied for foreach() in /home/ryokan/public_html/LibClass/JtbAPI.class.php on line 90

Warning: Invalid argument supplied for foreach() in /home/ryokan/public_html/LibClass/JtbAPI.class.php on line 90

Warning: Invalid argument supplied for foreach() in /home/ryokan/public_html/LibClass/JtbAPI.class.php on line 90

Warning: Invalid argument supplied for foreach() in /home/ryokan/public_html/LibClass/JtbAPI.class.php on line 90

오키나와현 숙박지 (검색결과 86개) 검색

체크인 2020-09-17, 객실 1, 성인 2, 아동 0

    Warning: Illegal string offset 'price_low' in /home/ryokan/public_tour38m/hotel/inventory.html on line 166

    Warning: Illegal string offset 'price_low' in /home/ryokan/public_tour38m/hotel/inventory.html on line 167

    Warning: A non-numeric value encountered in /home/ryokan/public_html/Lib/to_hotel.lib.php on line 5804

    Warning: Illegal string offset 'price_low' in /home/ryokan/public_tour38m/hotel/inventory.html on line 167

    Warning: number_format() expects parameter 1 to be float, string given in /home/ryokan/public_tour38m/hotel/inventory.html on line 167

    Warning: Illegal string offset 'hseq' in /home/ryokan/public_tour38m/hotel/inventory.html on line 174

    Warning: Illegal string offset 'hotel_code' in /home/ryokan/public_tour38m/hotel/inventory.html on line 180

    Warning: Illegal string offset 'mc_str' in /home/ryokan/public_tour38m/hotel/inventory.html on line 193

    Warning: Illegal string offset 'sc_str' in /home/ryokan/public_tour38m/hotel/inventory.html on line 193

    Warning: Illegal string offset 'm_name' in /home/ryokan/public_tour38m/hotel/inventory.html on line 195

    Warning: Illegal string offset 's_name' in /home/ryokan/public_tour38m/hotel/inventory.html on line 195

    Warning: Illegal string offset 'ryokan_sale_type' in /home/ryokan/public_tour38m/hotel/inventory.html on line 199

    Warning: Illegal string offset 'ryokan_sale_charge' in /home/ryokan/public_tour38m/hotel/inventory.html on line 200
  •  -/5 (이용후기:
    Warning: Illegal string offset 'review_cnt' in /home/ryokan/public_tour38m/hotel/inventory.html on line 218
    y개)
    y 〉 y

    Warning: Illegal string offset 'hotel_nm' in /home/ryokan/public_tour38m/hotel/inventory.html on line 222
    y -
    Warning: Illegal string offset 'hotel_nm_eng' in /home/ryokan/public_tour38m/hotel/inventory.html on line 222
    y

    Warning: Illegal string offset 'hotel_brief' in /home/ryokan/public_tour38m/hotel/inventory.html on line 223
    y

    Warning: Illegal string offset 'price_low' in /home/ryokan/public_tour38m/hotel/inventory.html on line 224
    객실최저가(수시변동)0원 (엔)

    Warning: Illegal string offset 'hseq' in /home/ryokan/public_tour38m/hotel/inventory.html on line 237
    • 상품명
      총상품가격
    • ( select 1 as room_no, t2.dtid, t2.r_idx, sum(t2.total_price) as total_price, t2.date_type_nm, t2.max_adult, t2.res_type , t2.h_seq, t2.date_type_nm_jpy, t2.package_type, t2.date_type_info, t2.date_type_info_text, t2.max_school, t2.max_child , t2.dt_sdate, t2.dt_edate, t2.deadline , t2.sel_agent, t2.dt_mode, sum(t2.price_sell) as price_sell, sum(t2.price_school) as price_school , sum(t2.price_child) as price_child, sum(t2.price_baby) as price_baby , t2.bed_type, t2.room_disp from ( select t1.dtid, t1.r_idx, t1.dt_sdate, t1.dt_edate, hd.room_date, hd.price_sell, hd.price_school, hd.price_child, hd.price_baby , (hd.price_sell * 2 ) as total_price , t1.date_type_nm, t1.max_adult, t1.res_type, t1.h_seq, t1.date_type_nm_jpy, t1.package_type, t1.date_type_info, t1.date_type_info_text , t1.max_school, t1.max_child, t1.sel_agent, t1.dt_mode, t1.deadline, hr.disp_yn as room_disp, hr.bed_type as bed_type from TB_HOTEL_DATE_TYPE as t1 left outer join TB_HOTEL_DATE as hd on hd.h_seq = t1.h_seq and hd.dtid = t1.dtid and hd.r_idx = t1.r_idx and hd.room_date between '2020-09-17' and '2020-09-16' and hd.price_sell > 0 and hd.del_flag='N' left outer join TB_HOTEL_ROOMTYPE as hr on hr.h_seq = t1.h_seq and hr.ridx=t1.r_idx where t1.h_seq = y and t1.disp_yn = 'Y' and t1.xml_date_type_gubun='R' and t1.max_adult = 2 and hd.price_sell > 0 and t1.dt_sdate <= '2020-09-17' and t1.dt_edate >= '2020-09-16' and hd.dtid in ( select dtid from ( select dtid, sum(cnt) as price_cnt from ( select dtid, count(*) as cnt from TB_HOTEL_DATE where h_seq=y and room_date between '2020-09-17' and '2020-09-16' and price_sell > 0 and del_flag='N' group by dtid, room_date ) as temp group by dtid having price_cnt =0 ) as temp ) and t1.stay_day<=0 and t1.stay_day_max > 0 and t1.res_type = 'RR' and hr.disp_yn='Y' and t1.r_idx in (select r_idx from (select r_idx, sum(cnt) as lodg_count from (select r_idx, start_date, count(*) as cnt from TB_HOTEL_BLOCK where r_idx in (select r_idx from TB_HOTEL_DATE_TYPE where h_seq = y and disp_yn = 'Y' and max_adult = 2 and CURDATE() BETWEEN dt_sdate AND dt_edate and stay_day<=0 and stay_day_max > 0 and res_type = 'RR' and dt_sdate <= '2020-09-17' and dt_edate >= '2020-09-16' ) and start_date between '2020-09-17' and '2020-09-16' and del_flag='N' and (abs(total_seat) - abs(left_seat)) > 0 AND start_date>=curdate() group by r_idx, start_date) as temp group by r_idx having lodg_count >= 0 ) as temp ) ) t2 group by t2.dtid, t2.r_idx ) order by total_price asc, res_type desc, max_adult asc

      1054 : Unknown column 'y' in 'where clause'

      error file : /hotel/inventory.html