[2025-06-22 11:43:30] megaresort.INFO: REQUEST: 
{"method":"GET","uri":"http://hotel.absystem.id/api/public/kalender-kamar/1?start=2025-06-01T00%3A00%3A00%2B08%3A00&end=2025-07-13T00%3A00%3A00%2B08%3A00","endpoint":"/api/public/kalender-kamar/1","headers":{"HTTP_ACCEPT":["text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8"],"HTTP_ACCEPT_ENCODING":["gzip, br"],"HTTP_ACCEPT_LANGUAGE":["en-US,en;q=0.9"],"HTTP_AUTHORIZATION":[""],"HTTP_CDN_LOOP":["cloudflare; loops=1"],"HTTP_CF_CONNECTING_IP":["154.205.156.6"],"HTTP_CF_IPCOUNTRY":["BR"],"HTTP_CF_RAY":["953915d2bcfda519-GRU"],"HTTP_CF_VISITOR":["{\"scheme\":\"https\"}"],"HTTP_COOKIE":["PHPSESSID=683f128864e69fe38f83c8c7b3a15c16; cf_clearance=edcCiatf3bambN4w_tTgPx.qWPPc7RO5S6s8zgaEo2Q-1750567233-1.2.1.1-zUxWjv8aHrYTX9UAbVOJ97uEfLnOgh1n..BvaMerWs66VQyAT3Aw9kjooRY1Apm9Yp1mH69nDU9h4djFKdzbyMcVP1cDKv3Jg1fqw0bYF0SRxzjUSDTIeKgWRI2td5Ok8n0MR4PtV0DJ0w.a9DfevleGTd31.ZEudNYmd2fEGfArycr3JEVs0dr1hhOyyGAIlbFBNQukS6nNODyFh7IkFpZfGfZ3FdrHehQS9y1kcbRqAUs9i.oe4ilQxF35rVDjEvDufWDx2K4zMwwuQStdW3FjpizgO8OF8FlwKR28u3msYKEZKaLRxNPG29SNt1JWPCuo7pgx89PEsCZLAleYaRsIz9OsTeQvIaAIEKmqkag"],"HTTP_DNT":["0"],"HTTP_HOST":["hotel.absystem.id"],"HTTP_PRIORITY":["u=1, i"],"HTTP_REFERER":["https://www.google.com/"],"HTTP_SEC_CH_UA":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"HTTP_SEC_CH_UA_MOBILE":["?0"],"HTTP_SEC_CH_UA_PLATFORM":["\"Linux\""],"HTTP_SEC_FETCH_DEST":["empty"],"HTTP_SEC_FETCH_MODE":["cors"],"HTTP_SEC_FETCH_SITE":["same-origin"],"HTTP_USER_AGENT":["Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36"],"HTTP_X_FORWARDED_FOR":["127.0.0.1,154.205.156.6"],"HTTP_X_FORWARDED_PROTO":["https"],"HTTP_X_ORIGINATING_IP":["127.0.0.1"],"HTTP_X_REMOTE_ADDR":["127.0.0.1"],"HTTP_X_REMOTE_IP":["127.0.0.1"],"HTTP_X_REQUESTED_WITH":["XMLHttpRequest"]},"body":""}
[2025-06-22 11:43:30] 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-22 11:43:30] megaresort.INFO: ==============================================END==============================================

[2025-06-22 11:43:31] 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=22-06-2025&tglakhir=23-06-2025&h=1","endpoint":"/api/public/cekbooking","headers":{"HTTP_ACCEPT":["text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8"],"HTTP_ACCEPT_ENCODING":["gzip, br"],"HTTP_ACCEPT_LANGUAGE":["en-US,en;q=0.9"],"HTTP_AUTHORIZATION":[""],"HTTP_CDN_LOOP":["cloudflare; loops=1"],"HTTP_CF_CONNECTING_IP":["154.205.156.6"],"HTTP_CF_IPCOUNTRY":["BR"],"HTTP_CF_RAY":["953915d9bd3ea519-GRU"],"HTTP_CF_VISITOR":["{\"scheme\":\"https\"}"],"HTTP_COOKIE":["PHPSESSID=683f128864e69fe38f83c8c7b3a15c16; cf_clearance=edcCiatf3bambN4w_tTgPx.qWPPc7RO5S6s8zgaEo2Q-1750567233-1.2.1.1-zUxWjv8aHrYTX9UAbVOJ97uEfLnOgh1n..BvaMerWs66VQyAT3Aw9kjooRY1Apm9Yp1mH69nDU9h4djFKdzbyMcVP1cDKv3Jg1fqw0bYF0SRxzjUSDTIeKgWRI2td5Ok8n0MR4PtV0DJ0w.a9DfevleGTd31.ZEudNYmd2fEGfArycr3JEVs0dr1hhOyyGAIlbFBNQukS6nNODyFh7IkFpZfGfZ3FdrHehQS9y1kcbRqAUs9i.oe4ilQxF35rVDjEvDufWDx2K4zMwwuQStdW3FjpizgO8OF8FlwKR28u3msYKEZKaLRxNPG29SNt1JWPCuo7pgx89PEsCZLAleYaRsIz9OsTeQvIaAIEKmqkag"],"HTTP_DNT":["0"],"HTTP_HOST":["hotel.absystem.id"],"HTTP_PRIORITY":["u=1, i"],"HTTP_REFERER":["https://www.google.com/"],"HTTP_SEC_CH_UA":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"HTTP_SEC_CH_UA_MOBILE":["?0"],"HTTP_SEC_CH_UA_PLATFORM":["\"Linux\""],"HTTP_SEC_FETCH_DEST":["empty"],"HTTP_SEC_FETCH_MODE":["cors"],"HTTP_SEC_FETCH_SITE":["same-origin"],"HTTP_USER_AGENT":["Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36"],"HTTP_X_FORWARDED_FOR":["127.0.0.1,154.205.156.6"],"HTTP_X_FORWARDED_PROTO":["https"],"HTTP_X_ORIGINATING_IP":["127.0.0.1"],"HTTP_X_REMOTE_ADDR":["127.0.0.1"],"HTTP_X_REMOTE_IP":["127.0.0.1"]},"body":""}
[2025-06-22 11:43:31] megaresort.INFO: RESPONSE: 
{"status":200,"headers":{"Content-Type":["application/json"]},"body":{"pesanerror":"","id":"1","sql":"select distinct t.id,t.tipekamar, '22-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-22') and bd.tanggalcheckin<=date('2025-06-22')

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

\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-22","end":"2025-06-23","jmlhari":1,"jumlahkamar":"14","sisakamar":14,"isikamar":"2","kebutuhankamar":0,"extrabed":"undefined","harga":"6.000.000","hargaextrabed":"1.000.000"}}
[2025-06-22 11:43:31] megaresort.INFO: ==============================================END==============================================