[2025-06-13 16:49:46] megaresort.INFO: REQUEST: 
{"method":"GET","uri":"http://hotel.absystem.id/api/public/kalender-kamar/1?start=2025-06-01T00%3A00%3A00%2B07%3A00&end=2025-07-13T00%3A00%3A00%2B07%3A00","endpoint":"/api/public/kalender-kamar/1","headers":{"HTTP_ACCEPT":["application/json, text/javascript, */*; q=0.01"],"HTTP_ACCEPT_ENCODING":["gzip, br"],"HTTP_ACCEPT_LANGUAGE":["en-US,en;q=0.9,id;q=0.8,zh-CN;q=0.7,zh;q=0.6"],"HTTP_AUTHORIZATION":[""],"HTTP_CDN_LOOP":["cloudflare; loops=1"],"HTTP_CF_CONNECTING_IP":["2001:448a:4022:16b4:c156:c0ec:47cc:d60f"],"HTTP_CF_IPCOUNTRY":["ID"],"HTTP_CF_RAY":["94f0ae147a418343-SIN"],"HTTP_CF_VISITOR":["{\"scheme\":\"https\"}"],"HTTP_COOKIE":["cf_clearance=._0QONLMtUSKhSgRg38WqnrjTfduZ7QutemUA5jl8b0-1745371707-1.2.1.1-56gF9x0gCU0plKysyxA6a68FAfp3K4HaOBvVnjm4pNvqDmtWFkYRfFlout6FzHR2qMf7agfsZIfPu7ZschVOkJZ.Ha.hgOv71kTbcVoUgFA3oHgj8l9G4i_kcgoKrmPgZvr.9Xm79V7MvM9BZK3k5JS9kYf0Tv9iWui5NcNM44.kknjc4D4Ha3i9ECObtbIdQr2AHsljmJUn1niqK47MkMHZIte3ceJxMuzfYxe8KRI87xahDgwe1XMXL91kljvQA_chb1KZh5mCIAvCtXzUwtY9C6w_5LcBAwo8IGX2qo1SikaJh3HFilUO1WbE.wYiF0y7byEGm467SVsC9xM9VQo.YhJahusF2HaWwDtHbSE; PHPSESSID=3e61627e548869cd817f17b0aa4f292b; cf_clearance=FHKKoK0GBrObpCeSSK2XleV4sfalpFp7G3D0cWZWo2I-1749808112-1.2.1.1-GrXvKkQ1J_NHJ65zOYpS.gHuNL7uGqGPFbcKwGQibrlDTVfkpIhB7vyemdh8jYtnbYK32tz_Cyp84H.7mn0_Zpdo38203VH2KAAkstw5gqein7rwhS_v2_kpFbgkr.GL3XqmRn4MzRwivh6fr36BATFk_8CJLcFYHMjrfOL53fm.RI__09mEQfAqMuOsMD6kFOJj7Obq4bF3SI.CfW5BGQffZU3OIXN6p_gwkX6quI9Ao.1eZhtkB1w51EuyVkK.DnEpbLKpTEiuJ0XY4i.Zl4tjHvw9cvsi5GPReb.uw86JM3GjcbOAERXoKj_7fQ9zdvIFP0t9IXdXaqLjOVbkOyy7CREjTMkapgZsCrdseJM"],"HTTP_HOST":["hotel.absystem.id"],"HTTP_PRIORITY":["u=1, i"],"HTTP_REFERER":["https://hotel.absystem.id/detailkamar.php?id=1"],"HTTP_SEC_CH_UA":["\"Google Chrome\";v=\"137\", \"Chromium\";v=\"137\", \"Not/A)Brand\";v=\"24\""],"HTTP_SEC_CH_UA_MOBILE":["?0"],"HTTP_SEC_CH_UA_PLATFORM":["\"macOS\""],"HTTP_SEC_FETCH_DEST":["empty"],"HTTP_SEC_FETCH_MODE":["cors"],"HTTP_SEC_FETCH_SITE":["same-origin"],"HTTP_USER_AGENT":["Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36"],"HTTP_X_FORWARDED_FOR":["2001:448a:4022:16b4:c156:c0ec:47cc:d60f"],"HTTP_X_FORWARDED_PROTO":["https"],"HTTP_X_REQUESTED_WITH":["XMLHttpRequest"]},"body":""}
[2025-06-13 16:49:46] megaresort.INFO: RESPONSE: 
{"status":200,"headers":{"Content-Type":["application/json"]},"body":[{"title":"IDR 6.000.000","start":"2025-06-01","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-02","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-03","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-04","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-05","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-06","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-07","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-08","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-09","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-10","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-11","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-12","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-13","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-14","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-15","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-16","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-17","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-18","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-19","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-20","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-21","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-22","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-23","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-24","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-25","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-26","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-27","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-28","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-29","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-06-30","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-07-01","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-07-02","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-07-03","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-07-04","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-07-05","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-07-06","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-07-07","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-07-08","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-07-09","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-07-10","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-07-11","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-07-12","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"},{"title":"IDR 6.000.000","start":"2025-07-13","backgroundColor":"#FFF3E0","borderColor":"#FFE0B2","textColor":"#000000"}]}
[2025-06-13 16:49:46] megaresort.INFO: ==============================================END==============================================

[2025-06-13 16:49:46] megaresort.INFO: REQUEST: 
{"method":"GET","uri":"http://hotel.absystem.id/api/public/cekbooking?req=getskpertipe&jmlkamar=1&extrabed=undefined&dewasa=1&anak=0&idtipekamar=1&tglawal=13-06-2025&tglakhir=14-06-2025&h=1","endpoint":"/api/public/cekbooking","headers":{"HTTP_ACCEPT":["*/*"],"HTTP_ACCEPT_ENCODING":["gzip, br"],"HTTP_ACCEPT_LANGUAGE":["en-US,en;q=0.9,id;q=0.8,zh-CN;q=0.7,zh;q=0.6"],"HTTP_AUTHORIZATION":[""],"HTTP_CDN_LOOP":["cloudflare; loops=1"],"HTTP_CF_CONNECTING_IP":["2001:448a:4022:16b4:c156:c0ec:47cc:d60f"],"HTTP_CF_IPCOUNTRY":["ID"],"HTTP_CF_RAY":["94f0ae153a538343-SIN"],"HTTP_CF_VISITOR":["{\"scheme\":\"https\"}"],"HTTP_COOKIE":["cf_clearance=._0QONLMtUSKhSgRg38WqnrjTfduZ7QutemUA5jl8b0-1745371707-1.2.1.1-56gF9x0gCU0plKysyxA6a68FAfp3K4HaOBvVnjm4pNvqDmtWFkYRfFlout6FzHR2qMf7agfsZIfPu7ZschVOkJZ.Ha.hgOv71kTbcVoUgFA3oHgj8l9G4i_kcgoKrmPgZvr.9Xm79V7MvM9BZK3k5JS9kYf0Tv9iWui5NcNM44.kknjc4D4Ha3i9ECObtbIdQr2AHsljmJUn1niqK47MkMHZIte3ceJxMuzfYxe8KRI87xahDgwe1XMXL91kljvQA_chb1KZh5mCIAvCtXzUwtY9C6w_5LcBAwo8IGX2qo1SikaJh3HFilUO1WbE.wYiF0y7byEGm467SVsC9xM9VQo.YhJahusF2HaWwDtHbSE; PHPSESSID=3e61627e548869cd817f17b0aa4f292b; cf_clearance=FHKKoK0GBrObpCeSSK2XleV4sfalpFp7G3D0cWZWo2I-1749808112-1.2.1.1-GrXvKkQ1J_NHJ65zOYpS.gHuNL7uGqGPFbcKwGQibrlDTVfkpIhB7vyemdh8jYtnbYK32tz_Cyp84H.7mn0_Zpdo38203VH2KAAkstw5gqein7rwhS_v2_kpFbgkr.GL3XqmRn4MzRwivh6fr36BATFk_8CJLcFYHMjrfOL53fm.RI__09mEQfAqMuOsMD6kFOJj7Obq4bF3SI.CfW5BGQffZU3OIXN6p_gwkX6quI9Ao.1eZhtkB1w51EuyVkK.DnEpbLKpTEiuJ0XY4i.Zl4tjHvw9cvsi5GPReb.uw86JM3GjcbOAERXoKj_7fQ9zdvIFP0t9IXdXaqLjOVbkOyy7CREjTMkapgZsCrdseJM"],"HTTP_HOST":["hotel.absystem.id"],"HTTP_PRIORITY":["u=1, i"],"HTTP_REFERER":["https://hotel.absystem.id/detailkamar.php?id=1"],"HTTP_SEC_CH_UA":["\"Google Chrome\";v=\"137\", \"Chromium\";v=\"137\", \"Not/A)Brand\";v=\"24\""],"HTTP_SEC_CH_UA_MOBILE":["?0"],"HTTP_SEC_CH_UA_PLATFORM":["\"macOS\""],"HTTP_SEC_FETCH_DEST":["empty"],"HTTP_SEC_FETCH_MODE":["cors"],"HTTP_SEC_FETCH_SITE":["same-origin"],"HTTP_USER_AGENT":["Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36"],"HTTP_X_FORWARDED_FOR":["2001:448a:4022:16b4:c156:c0ec:47cc:d60f"],"HTTP_X_FORWARDED_PROTO":["https"]},"body":""}
[2025-06-13 16:49:46] megaresort.INFO: RESPONSE: 
{"status":200,"headers":{"Content-Type":["application/json"]},"body":{"pesanerror":"","id":"1","sql":"select distinct t.id,t.tipekamar, '13-06-2025' as tanggal, bd.tanggalcheckin, bd.tanggalcheckout, ifnull(bd.jumlahkamar,0) jumlah, 

\t   ifnull(sum(bd.jumlahkamar) OVER (PARTITION BY t.tipekamar),0) AS terbooking,

\t   count(bc.id) OVER (PARTITION BY bd.idtipekamar) AS checkin, t.id as idtipekamar,

\t   t.harga, t.hargarefundable,t.hargatanpamakan,t.hargaextrabed,t.jmlextrabed,t.standarpemakai,t.gambar

\t   from tipekamar t 

\t   left join bookingdetail bd on t.id=bd.idtipekamar and (bd.tanggalcheckin>=date('2025-06-13') and bd.tanggalcheckin<=date('2025-06-13')

\t   or bd.tanggalcheckout>=date('2025-06-13') and bd.tanggalcheckout<date('2025-06-13'))

\t   left join booking b on b.id=bd.idbooking and b.idstatusbayar<>'1'

\t   left join kamar k on bd.idtipekamar=k.id

\t   left join bookingcheckin bc on bc.idbookingdetail=bd.id and bc.idkamar=k.id where t.id='1' order by id","start":"2025-06-13","end":"2025-06-14","jmlhari":1,"jumlahkamar":"14","sisakamar":14,"isikamar":"2","kebutuhankamar":0,"extrabed":"undefined","harga":"6.000.000","hargaextrabed":"1.000.000"}}
[2025-06-13 16:49:46] megaresort.INFO: ==============================================END==============================================

[2025-06-13 16:50:32] megaresort.INFO: REQUEST: 
{"method":"GET","uri":"http://hotel.absystem.id/api/public/cekbooking?req=getskpertipe&jmlkamar=1&extrabed=undefined&dewasa=1&anak=0&idtipekamar=1&tglawal=13-06-2025&tglakhir=14-06-2025&h=1","endpoint":"/api/public/cekbooking","headers":{"HTTP_ACCEPT":["*/*"],"HTTP_ACCEPT_ENCODING":["gzip, br"],"HTTP_ACCEPT_LANGUAGE":["en-US,en;q=0.9,id;q=0.8,zh-CN;q=0.7,zh;q=0.6"],"HTTP_AUTHORIZATION":[""],"HTTP_CDN_LOOP":["cloudflare; loops=1"],"HTTP_CF_CONNECTING_IP":["2001:448a:4022:16b4:c156:c0ec:47cc:d60f"],"HTTP_CF_IPCOUNTRY":["ID"],"HTTP_CF_RAY":["94f0af35fa138343-SIN"],"HTTP_CF_VISITOR":["{\"scheme\":\"https\"}"],"HTTP_COOKIE":["cf_clearance=._0QONLMtUSKhSgRg38WqnrjTfduZ7QutemUA5jl8b0-1745371707-1.2.1.1-56gF9x0gCU0plKysyxA6a68FAfp3K4HaOBvVnjm4pNvqDmtWFkYRfFlout6FzHR2qMf7agfsZIfPu7ZschVOkJZ.Ha.hgOv71kTbcVoUgFA3oHgj8l9G4i_kcgoKrmPgZvr.9Xm79V7MvM9BZK3k5JS9kYf0Tv9iWui5NcNM44.kknjc4D4Ha3i9ECObtbIdQr2AHsljmJUn1niqK47MkMHZIte3ceJxMuzfYxe8KRI87xahDgwe1XMXL91kljvQA_chb1KZh5mCIAvCtXzUwtY9C6w_5LcBAwo8IGX2qo1SikaJh3HFilUO1WbE.wYiF0y7byEGm467SVsC9xM9VQo.YhJahusF2HaWwDtHbSE; PHPSESSID=3e61627e548869cd817f17b0aa4f292b; cf_clearance=FHKKoK0GBrObpCeSSK2XleV4sfalpFp7G3D0cWZWo2I-1749808112-1.2.1.1-GrXvKkQ1J_NHJ65zOYpS.gHuNL7uGqGPFbcKwGQibrlDTVfkpIhB7vyemdh8jYtnbYK32tz_Cyp84H.7mn0_Zpdo38203VH2KAAkstw5gqein7rwhS_v2_kpFbgkr.GL3XqmRn4MzRwivh6fr36BATFk_8CJLcFYHMjrfOL53fm.RI__09mEQfAqMuOsMD6kFOJj7Obq4bF3SI.CfW5BGQffZU3OIXN6p_gwkX6quI9Ao.1eZhtkB1w51EuyVkK.DnEpbLKpTEiuJ0XY4i.Zl4tjHvw9cvsi5GPReb.uw86JM3GjcbOAERXoKj_7fQ9zdvIFP0t9IXdXaqLjOVbkOyy7CREjTMkapgZsCrdseJM"],"HTTP_HOST":["hotel.absystem.id"],"HTTP_PRIORITY":["u=1, i"],"HTTP_REFERER":["https://hotel.absystem.id/detailkamar.php?id=1"],"HTTP_SEC_CH_UA":["\"Google Chrome\";v=\"137\", \"Chromium\";v=\"137\", \"Not/A)Brand\";v=\"24\""],"HTTP_SEC_CH_UA_MOBILE":["?0"],"HTTP_SEC_CH_UA_PLATFORM":["\"macOS\""],"HTTP_SEC_FETCH_DEST":["empty"],"HTTP_SEC_FETCH_MODE":["cors"],"HTTP_SEC_FETCH_SITE":["same-origin"],"HTTP_USER_AGENT":["Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36"],"HTTP_X_FORWARDED_FOR":["2001:448a:4022:16b4:c156:c0ec:47cc:d60f"],"HTTP_X_FORWARDED_PROTO":["https"]},"body":""}
[2025-06-13 16:50:32] megaresort.INFO: RESPONSE: 
{"status":200,"headers":{"Content-Type":["application/json"]},"body":{"pesanerror":"","id":"1","sql":"select distinct t.id,t.tipekamar, '13-06-2025' as tanggal, bd.tanggalcheckin, bd.tanggalcheckout, ifnull(bd.jumlahkamar,0) jumlah, 

\t   ifnull(sum(bd.jumlahkamar) OVER (PARTITION BY t.tipekamar),0) AS terbooking,

\t   count(bc.id) OVER (PARTITION BY bd.idtipekamar) AS checkin, t.id as idtipekamar,

\t   t.harga, t.hargarefundable,t.hargatanpamakan,t.hargaextrabed,t.jmlextrabed,t.standarpemakai,t.gambar

\t   from tipekamar t 

\t   left join bookingdetail bd on t.id=bd.idtipekamar and (bd.tanggalcheckin>=date('2025-06-13') and bd.tanggalcheckin<=date('2025-06-13')

\t   or bd.tanggalcheckout>=date('2025-06-13') and bd.tanggalcheckout<date('2025-06-13'))

\t   left join booking b on b.id=bd.idbooking and b.idstatusbayar<>'1'

\t   left join kamar k on bd.idtipekamar=k.id

\t   left join bookingcheckin bc on bc.idbookingdetail=bd.id and bc.idkamar=k.id where t.id='1' order by id","start":"2025-06-13","end":"2025-06-14","jmlhari":1,"jumlahkamar":"14","sisakamar":14,"isikamar":"2","kebutuhankamar":0,"extrabed":"undefined","harga":"6.000.000","hargaextrabed":"1.000.000"}}
[2025-06-13 16:50:32] megaresort.INFO: ==============================================END==============================================