\n \n \n\t\t\t\t\t

\u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n

\u5009\u5eab\u7de8\u865f<\/td>\n	\u5c3a\u5bf8<\/td>\n	\u539f\u50f9(\u6708)<\/td>\n	\u512a\u60e0\u50f9(\u6708)<\/td>\n	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n	\u50f9\u683c<\/td>\n	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n	<\/td>\n <\/tr>
B01-064 <\/td>\n\t\t\t\t\t	4X4X7 <\/td>\n\t\t\t\t\t	$1112.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"16","total_discounted_price":"868.00","deposit":"2224.00","total_retail_price":"1112.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:44:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C212135","PERSONAL","Mr","iFIjEo5o8GXJFFISEEEOgQzRfmTfXaQe+QoC\/WRHE3M=","yXKLXTtbNpECaRVTZxF\/Rw==","","GTat37BrRKKFgWnrFpcDsA==",null,"H7T18BlWVWFNHWPKfeSM1BBxj8j+fnR56jO16TBU\/W8ioeaQRGmIf9xt1LKFC2ST5GAnjCpPZE0T8Xh+EFwXrg==","UU+KChM6Q+vt3iUAmGQ+\/Q==",null,null,"RSp50NNezXsjZSM6LRDqwQ==","2","2021-03-21 17:44:39","2","2021-03-21 17:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","2","5",2135,"NEW","B01-CT2110904",1112,868,2224,0,"12","12",11704,12640,11704,"2021-03-21 17:44:42","0",null,null,null,"2021-04-01","2022-03-31","12 months contract. First 3 months with 50% off for new costumer. Storage rental $9480 and deposit $2224 paid by EPS on 21 Mar, 2021. Smart card and lock provided on the same day.(FACEBOOK PROMOTION)","2021-04-01","16",0,null,936,"936.00","2","2021-03-21 17:44:39","2","2021-03-21 17:44:39","EPS","","","","EPS","","","",null,0,"189,28780;189,48820","C212135","PERSONAL","Mr","iFIjEo5o8GXJFFISEEEOgQzRfmTfXaQe+QoC\/WRHE3M=","yXKLXTtbNpECaRVTZxF\/Rw==","","H7T18BlWVWFNHWPKfeSM1BBxj8j+fnR56jO16TBU\/W8ioeaQRGmIf9xt1LKFC2ST5GAnjCpPZE0T8Xh+EFwXrg==","GTat37BrRKKFgWnrFpcDsA==",null,"UU+KChM6Q+vt3iUAmGQ+\/Q==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["10904","787 available_room_list_input","140","1254","%","10.00",111.2,"2","2021-03-21 17:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["10904","1254","1112.0",1000.8,"2","2021-03-21 17:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:44:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2021-04-01","2022-03-31","1254"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2021-03-21 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["10904","B01-D216247","PAID",2224,0,"2022-03-31","2021-03-21 17:44:39","2021-03-21 17:44:39","2","2021-03-21 17:44:39","2","2021-03-21 17:44:39",2135]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10904",2135,"SETTLED","B01-I2111233","2021-03-21 17:44:39","2021-04-01","2","2021-03-21 17:44:39","2","2021-03-21 17:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11233","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2021-03-21 17:44:39","2","2021-03-21 17:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11233","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,800,"MO","1",800,"2","2021-03-21 17:44:39","2","2021-03-21 17:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11233","RENT","\u9810\u7e73\u79df\u91d1",3,868,"MO","1",868,"2","2021-03-21 17:44:39","2","2021-03-21 17:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11233","RENT","\u9810\u7e73\u79df\u91d1",4,868,"MO","1",868,"2","2021-03-21 17:44:39","2","2021-03-21 17:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11233","RENT","\u9810\u7e73\u79df\u91d1",5,868,"MO","1",868,"2","2021-03-21 17:44:39","2","2021-03-21 17:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11233","RENT","\u9810\u7e73\u79df\u91d1",6,868,"MO","1",868,"2","2021-03-21 17:44:39","2","2021-03-21 17:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11233","RENT","\u9810\u7e73\u79df\u91d1",7,868,"MO","1",868,"2","2021-03-21 17:44:39","2","2021-03-21 17:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11233","RENT","\u9810\u7e73\u79df\u91d1",8,868,"MO","1",868,"2","2021-03-21 17:44:39","2","2021-03-21 17:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11233","RENT","\u9810\u7e73\u79df\u91d1",9,868,"MO","1",868,"2","2021-03-21 17:44:39","2","2021-03-21 17:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11233","RENT","\u9810\u7e73\u79df\u91d1",10,868,"MO","1",868,"2","2021-03-21 17:44:39","2","2021-03-21 17:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11233","RENT","\u9810\u7e73\u79df\u91d1",11,868,"MO","1",868,"2","2021-03-21 17:44:39","2","2021-03-21 17:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11233","RENT","\u9810\u7e73\u79df\u91d1",12,868,"MO","1",868,"2","2021-03-21 17:44:39","2","2021-03-21 17:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:44:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[9480,0,"11233"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2021-03-21 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[2135,"EPS","","","","EPS","","","","PAID","P2110866","2021-03-21 17:44:39",11704,"2","2021-03-21 17:44:39","2","2021-03-21 17:44:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10866","DEPOSIT","6247","PAID","2021-03-21 17:44:39",2224,"2","2021-03-21 17:44:39","2","2021-03-21 17:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:44:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10866","INVOICE","11233","PAID","2021-03-21 17:44:39",9480,"2","2021-03-21 17:44:39","2","2021-03-21 17:44:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:44:42","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 17:44:42","OPEN_FOR_INTERNAL","2021-03-21 17:44:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:44:42","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 17:44:42","OPEN_FOR_INTERNAL","2021-03-21 17:44:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:53:19","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 17:53:19","OPEN_FOR_INTERNAL","2021-03-21 17:53:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:53:20","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 17:53:20","OPEN_FOR_INTERNAL","2021-03-21 17:53:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:53:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:53:24","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 17:53:24","OPEN_FOR_INTERNAL","2021-03-21 17:53:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:53:24","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 17:53:24","OPEN_FOR_INTERNAL","2021-03-21 17:53:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:53:30","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 17:53:30","OPEN_FOR_INTERNAL","2021-03-21 17:53:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 17:53:31","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 17:53:31","OPEN_FOR_INTERNAL","2021-03-21 17:53:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:02:34","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:02:34","OPEN_FOR_INTERNAL","2021-03-21 18:02:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:02:51","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:02:51","OPEN_FOR_INTERNAL","2021-03-21 18:02:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:03:36","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:03:36","OPEN_FOR_INTERNAL","2021-03-21 18:03:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:21:25","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:21:25","OPEN_FOR_INTERNAL","2021-03-21 18:21:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:21:25","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:21:25","OPEN_FOR_INTERNAL","2021-03-21 18:21:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:21:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:21:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:21:27","OPEN_FOR_INTERNAL","2021-03-21 18:21:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:21:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:21:39","OPEN_FOR_INTERNAL","2021-03-21 18:21:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:21:47","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:21:47","OPEN_FOR_INTERNAL","2021-03-21 18:21:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:23:40","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:23:40","OPEN_FOR_INTERNAL","2021-03-21 18:23:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:23:40","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","189,28780;189,48820;0012415084;0012435124","12 months contract. First 3 months with 50% off for new costumer. Storage rental $9480 and deposit $2224 paid by EPS on 21 Mar, 2021. Smart card and lock provided on the same day.(FACEBOOK PROMOTION)","2021-03-21 18:23:40","2","yXKLXTtbNpECaRVTZxF\/Rw==","iFIjEo5o8GXJFFISEEEOgQzRfmTfXaQe+QoC\/WRHE3M=","GTat37BrRKKFgWnrFpcDsA==","H7T18BlWVWFNHWPKfeSM1BBxj8j+fnR56jO16TBU\/W8ioeaQRGmIf9xt1LKFC2ST5GAnjCpPZE0T8Xh+EFwXrg==",10904]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:23:40","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:23:40","OPEN_FOR_INTERNAL","2021-03-21 18:23:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:23:55","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:23:55","OPEN_FOR_INTERNAL","2021-03-21 18:23:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:24:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:24:15","OPEN_FOR_INTERNAL","2021-03-21 18:24:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:26:39","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:26:39","OPEN_FOR_INTERNAL","2021-03-21 18:26:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:27:16","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:27:16","OPEN_FOR_INTERNAL","2021-03-21 18:27:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:27:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:27:28","OPEN_FOR_INTERNAL","2021-03-21 18:27:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:28:43","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:28:43","OPEN_FOR_INTERNAL","2021-03-21 18:28:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:29:16","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:29:16","OPEN_FOR_INTERNAL","2021-03-21 18:29:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:30:25","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:30:25","OPEN_FOR_INTERNAL","2021-03-21 18:30:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:30:29","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:30:29","OPEN_FOR_INTERNAL","2021-03-21 18:30:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:30:40","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:30:40","OPEN_FOR_INTERNAL","2021-03-21 18:30:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:30:52","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:30:52","OPEN_FOR_INTERNAL","2021-03-21 18:30:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:31:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:31:27","OPEN_FOR_INTERNAL","2021-03-21 18:31:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:32:07","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:32:07","OPEN_FOR_INTERNAL","2021-03-21 18:32:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:32:07","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:32:07","OPEN_FOR_INTERNAL","2021-03-21 18:32:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:32:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:32:13","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:32:13","OPEN_FOR_INTERNAL","2021-03-21 18:32:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:32:30","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:32:30","OPEN_FOR_INTERNAL","2021-03-21 18:32:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:33:02","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:33:02","OPEN_FOR_INTERNAL","2021-03-21 18:33:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:33:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:33:15","OPEN_FOR_INTERNAL","2021-03-21 18:33:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:33:58","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:33:58","OPEN_FOR_INTERNAL","2021-03-21 18:33:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:33:58","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:33:58","OPEN_FOR_INTERNAL","2021-03-21 18:33:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:33:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:02","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:02","OPEN_FOR_INTERNAL","2021-03-21 18:34:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:02","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:02","OPEN_FOR_INTERNAL","2021-03-21 18:34:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:06","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:06","OPEN_FOR_INTERNAL","2021-03-21 18:34:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:11","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:11","OPEN_FOR_INTERNAL","2021-03-21 18:34:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:12","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:12","OPEN_FOR_INTERNAL","2021-03-21 18:34:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:13","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:13","OPEN_FOR_INTERNAL","2021-03-21 18:34:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:13","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:13","OPEN_FOR_INTERNAL","2021-03-21 18:34:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:13","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:13","OPEN_FOR_INTERNAL","2021-03-21 18:34:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:13","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:13","OPEN_FOR_INTERNAL","2021-03-21 18:34:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:13","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:13","OPEN_FOR_INTERNAL","2021-03-21 18:34:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:13","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:13","OPEN_FOR_INTERNAL","2021-03-21 18:34:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:13","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:13","OPEN_FOR_INTERNAL","2021-03-21 18:34:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:13","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:13","OPEN_FOR_INTERNAL","2021-03-21 18:34:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:13","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:13","OPEN_FOR_INTERNAL","2021-03-21 18:34:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:13","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:13","OPEN_FOR_INTERNAL","2021-03-21 18:34:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:13","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:13","OPEN_FOR_INTERNAL","2021-03-21 18:34:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:13","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:13","OPEN_FOR_INTERNAL","2021-03-21 18:34:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:13","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:13","OPEN_FOR_INTERNAL","2021-03-21 18:34:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:18","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:18","OPEN_FOR_INTERNAL","2021-03-21 18:34:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:18","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:18","OPEN_FOR_INTERNAL","2021-03-21 18:34:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:19","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:19","OPEN_FOR_INTERNAL","2021-03-21 18:34:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:19","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:19","OPEN_FOR_INTERNAL","2021-03-21 18:34:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:21","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:21","OPEN_FOR_INTERNAL","2021-03-21 18:34:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:21","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:21","OPEN_FOR_INTERNAL","2021-03-21 18:34:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:22","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:22","OPEN_FOR_INTERNAL","2021-03-21 18:34:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:22","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:22","OPEN_FOR_INTERNAL","2021-03-21 18:34:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:23","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:23","OPEN_FOR_INTERNAL","2021-03-21 18:34:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:23","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:23","OPEN_FOR_INTERNAL","2021-03-21 18:34:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:23","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:23","OPEN_FOR_INTERNAL","2021-03-21 18:34:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:34:25","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:34:25","OPEN_FOR_INTERNAL","2021-03-21 18:34:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:35:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:35:10","OPEN_FOR_INTERNAL","2021-03-21 18:35:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:35:11","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:35:11","OPEN_FOR_INTERNAL","2021-03-21 18:35:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:35:11","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:35:11","OPEN_FOR_INTERNAL","2021-03-21 18:35:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:35:16","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:35:16","OPEN_FOR_INTERNAL","2021-03-21 18:35:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:35:16","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":{"1":{"room_id":"1918","master_room_id":"294","room_code":"E10-44"}},"index_url_parameter":"filter1=5&filter2=2021-03-21&filter3=2021-03-22","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":116,"customer_code":"C160116","identity_type":"PERSONAL","identity_id":"Z412240(3)","title":"Mr","lastname":"Yip","firstname":"Chun Yin, Christopher","companyname":"","email":"ycyt2011@gmail.com","tel":"97310791","address":"Flat A, 11\/F, Block 5, Chi Fu Fa Yuen, Poklulam, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1592.0","renew_rent_month":"6","renew_warehousing_date":"2021-04-06","renew_room_key":"189, 28869","renew_remark":"6 months contract. Storage rental and deposit paid by bank transfer on OCT 3, 2020. Storage deposit transferred from agreement A12-CT207726 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT209097, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"11","order_discount":[{"master_room_discount_id":"80","master_room_id":"11","discount_type":"%","price":"1768.00","disocunted_price":"1592.10","discount":"9.95","monthly_deduct":175.916,"room_id":"401","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"401","room_code":"H11","retail_price":"1768.0","discounted_price":1592.1,"location_id":"1"}],"roughly_size":"24","total_retail_price":1768,"total_discounted_price":1592,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":9552,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2021-04-06","rent_from":"2021-04-06","rent_to":"2021-10-05","delivery_service":"0","remark":"6 months contract. Storage rental and deposit paid by bank transfer on 21 Mar, 2021. Storage deposit transferred from agreement A12-CT209097 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":9552,"final_order_total":9552,"location_id":"1","branch_id":"1","company_id":"1","room_key":"189, 28869","order_product":[],"pass":true}},"first_order_id":"6879","selected_room_tr":"	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> H11 <\/td>\r\n\t\t\t\t\t 4X6X8 <\/td>\r\n\t\t\t\t\t $1768.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1592.00","deposit":"0.00","total_retail_price":"1768.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:35:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",116,"NEW","A12-CT2110905",1768,1592,0,0,"6","6",9552,9552,9552,"2021-03-21 18:35:17","0",null,null,null,"2021-04-06","2021-10-05","6 months contract. Storage rental and deposit paid by bank transfer on 21 Mar, 2021. Storage deposit transferred from agreement A12-CT209097 to this agreement.","2021-04-06","24",0,null,0,"0.00","2","2021-03-21 18:35:16","2","2021-03-21 18:35:16","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"189, 28869","C160116","PERSONAL","Mr","yBFqv3yedRm2dETwD480TsPV5T10uYontNxIrtMH+RQ=","H9gmHz05\/Te4s1\/V+q8XVg==","","fxfvZGmYkWyEb2\/fmXzVldmSmfr3OShFZUvCpaWMGYKDRsp\/i1TISueLKkEc\/7oK7y7MgPbVf5txYIAa1gDoFQ==","YwB44nyrK\/Fvoj4xrTDqSg==","lqpOAiJW76MOGoDiZdB+W5b5+A4TRBjkBjXXuYGKu4c=","dHU4XMO25fV5vF8UUQ0A0w==",null,1,"6879"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:35:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["10905","80","11","401","%","9.95",175.916,"2","2021-03-21 18:35:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:35:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["10905","401","1768.0",1592.1,"2","2021-03-21 18:35:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:35:17","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2021-04-06","2021-10-05","401"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2021-03-21 18:35:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10905",116,"SETTLED","A12-I2111234","2021-03-21 18:35:16","2021-04-06","2","2021-03-21 18:35:16","2","2021-03-21 18:35:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:35:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11234","RENT","\u9810\u7e73\u79df\u91d1",1,1592,"MO","1",1592,"2","2021-03-21 18:35:16","2","2021-03-21 18:35:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:35:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11234","RENT","\u9810\u7e73\u79df\u91d1",2,1592,"MO","1",1592,"2","2021-03-21 18:35:16","2","2021-03-21 18:35:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:35:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11234","RENT","\u9810\u7e73\u79df\u91d1",3,1592,"MO","1",1592,"2","2021-03-21 18:35:16","2","2021-03-21 18:35:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:35:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11234","RENT","\u9810\u7e73\u79df\u91d1",4,1592,"MO","1",1592,"2","2021-03-21 18:35:16","2","2021-03-21 18:35:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:35:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11234","RENT","\u9810\u7e73\u79df\u91d1",5,1592,"MO","1",1592,"2","2021-03-21 18:35:16","2","2021-03-21 18:35:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:35:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["11234","RENT","\u9810\u7e73\u79df\u91d1",6,1592,"MO","1",1592,"2","2021-03-21 18:35:16","2","2021-03-21 18:35:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:35:17","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[9552,0,"11234"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2021-03-21 18:35:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[116,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P2110867","2021-03-21 18:35:16",9552,"2","2021-03-21 18:35:16","2","2021-03-21 18:35:16","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:35:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10867","DEPOSIT",null,"PAID","2021-03-21 18:35:16",0,"2","2021-03-21 18:35:16","2","2021-03-21 18:35:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:35:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10867","INVOICE","11234","PAID","2021-03-21 18:35:16",9552,"2","2021-03-21 18:35:16","2","2021-03-21 18:35:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:35:17","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:35:17","OPEN_FOR_INTERNAL","2021-03-21 18:35:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:35:17","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:35:17","OPEN_FOR_INTERNAL","2021-03-21 18:35:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:36:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:36:10","OPEN_FOR_INTERNAL","2021-03-21 18:36:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2021-03-21 18:54:06","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2021-03-21 18:54:06","OPEN_FOR_INTERNAL","2021-03-21 18:54:06"]},"data_before":[],"data_after":[],"step":1} *****