\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>
G20 <\/td>\n\t\t\t\t\t	4X6X8 <\/td>\n\t\t\t\t\t	$1768.00 <\/td>\n\t\t\t\t	- <\/td>	\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":"24","total_discounted_price":"1768.00","deposit":"3536.00","total_retail_price":"1768.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:06:05","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":["C201837","PERSONAL","Mr","XmPNwMhSwzrlJzmTzrWaPQ==","ddrfzAYTmkL\/QNu3psjONQ==","","ZveWkyMdG\/2DDeidsVqyWQ==","nwCcL5WefP9E6em7wSj09889z7Wx79b7\/E5LXtv81d4=","PMB\/a6V5e2MaqHF8+KqtN+NjzS2c52+G3QiLclZf01xV1AVgtDuFczTzYWyETj5I","OioRGr2z32QS\/F6zHlk+gA==",null,"nwCcL5WefP9E6em7wSj09889z7Wx79b7\/E5LXtv81d4=","m8BAe2xw+xJ6JURTjmfH0g==","2","2020-10-29 16:06:04","2","2020-10-29 16:06:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:06:06","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","1","1",1837,"NEW","A12-CT209393",1768,1768,3536,0,"3","3",6188,8840,6188,"2020-10-29 16:06:06","0",null,null,null,"2020-11-01","2021-01-31","3 months contract. Special offered 50%off discount for the first 3 months. Storage rental $2652 and deposit $3536 paid by bank transfer on 29 Oct 2020 (ttl: $6188). Smart card and padlock provided on the same day.","2020-11-01","24",0,null,2652,"2652.00","2","2020-10-29 16:06:04","2","2020-10-29 16:06:04","BANKIN","","","","BANKIN","","","",null,0,"190,26601","C201837","PERSONAL","Mr","XmPNwMhSwzrlJzmTzrWaPQ==","ddrfzAYTmkL\/QNu3psjONQ==","","PMB\/a6V5e2MaqHF8+KqtN+NjzS2c52+G3QiLclZf01xV1AVgtDuFczTzYWyETj5I","ZveWkyMdG\/2DDeidsVqyWQ==","nwCcL5WefP9E6em7wSj09889z7Wx79b7\/E5LXtv81d4=","OioRGr2z32QS\/F6zHlk+gA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:06:06","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":["9393","379","1768.0","1768.00","2","2020-10-29 16:06:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:06:06","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":["2020-11-01","2021-01-31","379"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-10-29 16:06:06","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":["9393","A12-D205825","PAID",3536,0,"2021-01-31","2020-10-29 16:06:04","2020-10-29 16:06:04","2","2020-10-29 16:06:04","2","2020-10-29 16:06:04",1837]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:06:06","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":["9393",1837,"SETTLED","A12-I209722","2020-10-29 16:06:04","2020-11-01","2","2020-10-29 16:06:04","2","2020-10-29 16:06:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:06:06","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":["9722","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-10-29 16:06:04","2","2020-10-29 16:06:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:06:06","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":["9722","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,884,"MO","1",884,"2","2020-10-29 16:06:04","2","2020-10-29 16:06:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:06:06","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":["9722","RENT","\u9810\u7e73\u79df\u91d1",3,1768,"MO","1",1768,"2","2020-10-29 16:06:04","2","2020-10-29 16:06:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:06:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2652,0,"9722"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-10-29 16:06:06","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":[1837,"BANKIN","","","","BANKIN","","","","PAID","P209361","2020-10-29 16:06:04",6188,"2","2020-10-29 16:06:04","2","2020-10-29 16:06:04","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:06:06","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":["9361","DEPOSIT","5825","PAID","2020-10-29 16:06:04",3536,"2","2020-10-29 16:06:04","2","2020-10-29 16:06:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:06:06","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":["9361","INVOICE","9722","PAID","2020-10-29 16:06:04",2652,"2","2020-10-29 16:06:04","2","2020-10-29 16:06:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:06: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","2020-10-29 16:06:06","OPEN_FOR_INTERNAL","2020-10-29 16:06:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:06: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","2020-10-29 16:06:06","OPEN_FOR_INTERNAL","2020-10-29 16:06:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:06: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","2020-10-29 16:06:55","OPEN_FOR_INTERNAL","2020-10-29 16:06:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:06:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:15: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","2020-10-29 16:15:52","OPEN_FOR_INTERNAL","2020-10-29 16:15:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:15:53","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","2020-10-29 16:15:53","OPEN_FOR_INTERNAL","2020-10-29 16:15:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:16:09","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","2020-10-29 16:16:09","OPEN_FOR_INTERNAL","2020-10-29 16:16:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:16:09","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","2020-10-29 16:16:09","OPEN_FOR_INTERNAL","2020-10-29 16:16:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:16:09","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:16: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","2020-10-29 16:16:12","OPEN_FOR_INTERNAL","2020-10-29 16:16:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:18:03","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","2020-10-29 16:18:03","OPEN_FOR_INTERNAL","2020-10-29 16:18:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:18: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","2020-10-29 16:18:11","OPEN_FOR_INTERNAL","2020-10-29 16:18:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:19: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","2020-10-29 16:19:15","OPEN_FOR_INTERNAL","2020-10-29 16:19:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:19: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","2020-10-29 16:19:16","OPEN_FOR_INTERNAL","2020-10-29 16:19:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:19: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","2020-10-29 16:19:24","OPEN_FOR_INTERNAL","2020-10-29 16:19:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:19: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","2020-10-29 16:19:28","OPEN_FOR_INTERNAL","2020-10-29 16:19:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:21:57","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","2020-10-29 16:21:57","OPEN_FOR_INTERNAL","2020-10-29 16:21:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:21:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:22: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","2020-10-29 16:22:51","OPEN_FOR_INTERNAL","2020-10-29 16:22:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:22:51","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:22: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","2020-10-29 16:22:52","OPEN_FOR_INTERNAL","2020-10-29 16:22:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:22:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:23:00","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","2020-10-29 16:23:00","OPEN_FOR_INTERNAL","2020-10-29 16:23:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:23:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:23:50","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","2020-10-29 16:23:50","OPEN_FOR_INTERNAL","2020-10-29 16:23:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:23:50","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","2020-10-29 16:23:50","OPEN_FOR_INTERNAL","2020-10-29 16:23:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:23:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:35:01","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","2020-10-29 16:35:01","OPEN_FOR_INTERNAL","2020-10-29 16:35:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:35:05","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","2020-10-29 16:35:05","OPEN_FOR_INTERNAL","2020-10-29 16:35:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:49:04","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","2020-10-29 16:49:04","OPEN_FOR_INTERNAL","2020-10-29 16:49:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:49:04","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","2020-10-29 16:49:04","OPEN_FOR_INTERNAL","2020-10-29 16:49:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:49:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:49:09","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","2020-10-29 16:49:09","OPEN_FOR_INTERNAL","2020-10-29 16:49:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:49:09","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","2020-10-29 16:49:09","OPEN_FOR_INTERNAL","2020-10-29 16:49:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:49: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","2020-10-29 16:49:15","OPEN_FOR_INTERNAL","2020-10-29 16:49:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:49: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","2020-10-29 16:49:20","OPEN_FOR_INTERNAL","2020-10-29 16:49:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 16:49: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","2020-10-29 16:49:22","OPEN_FOR_INTERNAL","2020-10-29 16:49:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:05: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","2020-10-29 17:05:25","OPEN_FOR_INTERNAL","2020-10-29 17:05:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:05:26","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","2020-10-29 17:05:26","OPEN_FOR_INTERNAL","2020-10-29 17:05:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:05: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","2020-10-29 17:05:51","OPEN_FOR_INTERNAL","2020-10-29 17:05:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:08: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","2020-10-29 17:08:31","OPEN_FOR_INTERNAL","2020-10-29 17:08:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:09: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","2020-10-29 17:09:22","OPEN_FOR_INTERNAL","2020-10-29 17:09:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:15: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","2020-10-29 17:15:36","OPEN_FOR_INTERNAL","2020-10-29 17:15:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:15:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:25:46","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","2020-10-29 17:25:46","OPEN_FOR_INTERNAL","2020-10-29 17:25:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17: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","2020-10-29 17:32:13","OPEN_FOR_INTERNAL","2020-10-29 17:32:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:32:13","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","076,34807","1 month contract. Storage deposit $8276 transferred from agreement A14-CT209005 to this agreement. Change unit from O25, 26, 36, 37 to O25 and O36. Deposit of O25, 26, 36, 37 (A14-CT209391) will transfer to O25 and O36 for both deposit and storage rental fee ($8276-$6954 [Deposit and storage rental of O25 and O36, $2318*3]=$1322). The difference of 1 month rental for O25, 26, 36, 37 is paid by the remaining deposit balance ($1322) of O25, 26, 36, 37 and EPS ($2816) on Oct 29, 2020. \r\n","2020-10-29 17:32:13","2","8fTzWS+7t1nmEnG1fQtiRw==","ATneOtMIe0LYAurw32wHyQ==","nW1wxJuhGSp1hffXbm1TmkEK7G4kgckFWfZtR+HR6Hk=","wLWBoYhI1qKia2rkJxrObg==","JuoZJFFpvrPqF\/07IdfIHtLby15JiIS13nkfz0Bi3G3Ij\/lO63BV2WemTW4T97d1hLIoJeuGN4NgiOa9lHKg9w==",9391]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17: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","2020-10-29 17:32:13","OPEN_FOR_INTERNAL","2020-10-29 17:32:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:32: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","2020-10-29 17:32:23","OPEN_FOR_INTERNAL","2020-10-29 17:32:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:32: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","2020-10-29 17:32:36","OPEN_FOR_INTERNAL","2020-10-29 17:32:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:33:44","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","2020-10-29 17:33:44","OPEN_FOR_INTERNAL","2020-10-29 17:33:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:33:48","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","2020-10-29 17:33:48","OPEN_FOR_INTERNAL","2020-10-29 17:33:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:33:48","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","2020-10-29 17:33:48","OPEN_FOR_INTERNAL","2020-10-29 17:33:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:33:49","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","2020-10-29 17:33:49","OPEN_FOR_INTERNAL","2020-10-29 17:33:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:33:49","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","2020-10-29 17:33:49","OPEN_FOR_INTERNAL","2020-10-29 17:33:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:33:49","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","2020-10-29 17:33:49","OPEN_FOR_INTERNAL","2020-10-29 17:33:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:33:49","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","2020-10-29 17:33:49","OPEN_FOR_INTERNAL","2020-10-29 17:33:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:33:49","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","2020-10-29 17:33:49","OPEN_FOR_INTERNAL","2020-10-29 17:33:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:33:49","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","2020-10-29 17:33:49","OPEN_FOR_INTERNAL","2020-10-29 17:33:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:33:49","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","2020-10-29 17:33:49","OPEN_FOR_INTERNAL","2020-10-29 17:33:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:33:49","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","2020-10-29 17:33:49","OPEN_FOR_INTERNAL","2020-10-29 17:33:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:33:49","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","2020-10-29 17:33:49","OPEN_FOR_INTERNAL","2020-10-29 17:33:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:33:49","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","2020-10-29 17:33:49","OPEN_FOR_INTERNAL","2020-10-29 17:33:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:33:49","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","2020-10-29 17:33:49","OPEN_FOR_INTERNAL","2020-10-29 17:33:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:33:59","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","2020-10-29 17:33:59","OPEN_FOR_INTERNAL","2020-10-29 17:33:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:33:59","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","2020-10-29 17:33:59","OPEN_FOR_INTERNAL","2020-10-29 17:33:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17: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","2020-10-29 17:34:02","OPEN_FOR_INTERNAL","2020-10-29 17:34:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:35:46","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","2020-10-29 17:35:46","OPEN_FOR_INTERNAL","2020-10-29 17:35:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:35:48","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","2020-10-29 17:35:48","OPEN_FOR_INTERNAL","2020-10-29 17:35:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:35:59","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","2020-10-29 17:35:59","OPEN_FOR_INTERNAL","2020-10-29 17:35:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:35:59","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","2020-10-29 17:35:59","OPEN_FOR_INTERNAL","2020-10-29 17:35:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:36: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","2020-10-29 17:36:06","OPEN_FOR_INTERNAL","2020-10-29 17:36:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:36: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","2020-10-29 17:36:06","OPEN_FOR_INTERNAL","2020-10-29 17:36:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:36:09","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","2020-10-29 17:36:09","OPEN_FOR_INTERNAL","2020-10-29 17:36:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:36:09","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","2020-10-29 17:36:09","OPEN_FOR_INTERNAL","2020-10-29 17:36:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17: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","2020-10-29 17:36:10","OPEN_FOR_INTERNAL","2020-10-29 17:36:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:36:14","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","2020-10-29 17:36:14","OPEN_FOR_INTERNAL","2020-10-29 17:36:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:36:33","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","2020-10-29 17:36:33","OPEN_FOR_INTERNAL","2020-10-29 17:36:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:36:33","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","2020-10-29 17:36:33","OPEN_FOR_INTERNAL","2020-10-29 17:36:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:36:33","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","2020-10-29 17:36:33","OPEN_FOR_INTERNAL","2020-10-29 17:36:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:36:33","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","2020-10-29 17:36:33","OPEN_FOR_INTERNAL","2020-10-29 17:36:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:36: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","2020-10-29 17:36:34","OPEN_FOR_INTERNAL","2020-10-29 17:36:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:36: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","2020-10-29 17:36:34","OPEN_FOR_INTERNAL","2020-10-29 17:36:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:36: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","2020-10-29 17:36:34","OPEN_FOR_INTERNAL","2020-10-29 17:36:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:36: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","2020-10-29 17:36:36","OPEN_FOR_INTERNAL","2020-10-29 17:36:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:36:46","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","2020-10-29 17:36:46","OPEN_FOR_INTERNAL","2020-10-29 17:36:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:36:46","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","2020-10-29 17:36:46","OPEN_FOR_INTERNAL","2020-10-29 17:36:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:36:48","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","2020-10-29 17:36:48","OPEN_FOR_INTERNAL","2020-10-29 17:36:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:36:48","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","2020-10-29 17:36:48","OPEN_FOR_INTERNAL","2020-10-29 17:36:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:36:48","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","2020-10-29 17:36:48","OPEN_FOR_INTERNAL","2020-10-29 17:36:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:36:49","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","2020-10-29 17:36:49","OPEN_FOR_INTERNAL","2020-10-29 17:36:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:36:49","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","2020-10-29 17:36:49","OPEN_FOR_INTERNAL","2020-10-29 17:36:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:36:49","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","2020-10-29 17:36:49","OPEN_FOR_INTERNAL","2020-10-29 17:36:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:37:00","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","2020-10-29 17:37:00","OPEN_FOR_INTERNAL","2020-10-29 17:37:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:37:00","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","2020-10-29 17:37:00","OPEN_FOR_INTERNAL","2020-10-29 17:37:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:37:00","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","2020-10-29 17:37:00","OPEN_FOR_INTERNAL","2020-10-29 17:37:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:37:00","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","2020-10-29 17:37:00","OPEN_FOR_INTERNAL","2020-10-29 17:37:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:37:01","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","2020-10-29 17:37:01","OPEN_FOR_INTERNAL","2020-10-29 17:37:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:37:01","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","2020-10-29 17:37:01","OPEN_FOR_INTERNAL","2020-10-29 17:37:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:37:01","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","2020-10-29 17:37:01","OPEN_FOR_INTERNAL","2020-10-29 17:37:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:37: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","2020-10-29 17:37:17","OPEN_FOR_INTERNAL","2020-10-29 17:37:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:38:46","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","2020-10-29 17:38:46","OPEN_FOR_INTERNAL","2020-10-29 17:38:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:38:46","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","2020-10-29 17:38:46","OPEN_FOR_INTERNAL","2020-10-29 17:38:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:38: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","2020-10-29 17:38:47","OPEN_FOR_INTERNAL","2020-10-29 17:38:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:38:56","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","2020-10-29 17:38:56","OPEN_FOR_INTERNAL","2020-10-29 17:38:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:38:56","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","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1255,"customer_code":"C191255","identity_type":"PERSONAL","identity_id":"R857926(0)","title":"Ms","lastname":"Mostashari","firstname":"Yas","companyname":"","email":"yass@mostashari.co.uk","tel":"96873290","address":"Flat A6, Guildford Court, 5 Guildford Road, The Peak, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4192.0","renew_rent_month":"1","renew_warehousing_date":"2020-10-29","renew_room_key":"076,34807","renew_remark":"1 month contract. Storage deposit $8276 transferred from agreement A14-CT209005 to this agreement. Change unit from O25, 26, 36, 37 to O25 and O36. Deposit of O25, 26, 36, 37 (A14-CT209391) will transfer to O25 and O36 for both deposit and storage rental fee ($8276-$6954 [Deposit and storage rental of O25 and O36, $2318*3]=$1322). The difference of 1 month rental for O25, 26, 36, 37 is paid by the remaining deposit balance ($1322) of O25, 26, 36, 37 and EPS ($2816) on Oct 29, 2020. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT209391, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"760","room_code":"O36","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"749","room_code":"O25","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"32","total_retail_price":2096,"total_discounted_price":2318,"deposit":4636,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":0,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"6954.00","warehousing_date":"2020-10-29","rent_from":"2020-10-29","rent_to":"2020-11-28","delivery_service":"0","remark":"1 month contract. Storage deposit $8276 transferred from agreement A14-CT209391 to this agreement. Change unit from O25, 26, 36, 37 to O25 and O36. Deposit of O25, 26, 36, 37 (A14-CT209391) is transferred to O25 and O36 for both deposit and storage rental fee ($8276-$6954 [Deposit and storage rental of O25 and O36, $2318*3]=$1322). The difference of 1 month rental for O25, 26, 36, 37 is paid by the remaining deposit balance ($1322) of O25, 26, 36, 37 and EPS ($2816) on Oct 29, 2020. \r\n\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":6954,"order_total":6954,"final_order_total":0,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,34807","order_product":[],"pass":true}},"first_order_id":"4818","selected_room_tr":"	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\t\t\t\t\t\t\t\t\t\t\t	\n\t\t\t\t\t\t\t\t\t\t\t\t \n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> O36 <\/td>\n\t\t\t\t\t 4X4X8 <\/td>\n\t\t\t\t\t $1098.00 <\/td>\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\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> \n\t\t\t\t\t\t\u522a\u9664<\/button>\n\t\t\t\t\t<\/td><\/tr> O25 <\/td>\n\t\t\t\t\t 4X3X8 <\/td>\n\t\t\t\t\t $998.00 <\/td>\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\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> \n\t\t\t\t\t\t\u522a\u9664<\/button>\n\t\t\t\t\t<\/td><\/tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\n\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"2318.00","deposit":"4636.00","total_retail_price":"2096.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:38:57","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","2",1255,"NEW","A14-CT209394",2096,2318,4636,0,"1","1",0,6954,0,"2020-10-29 17:38:57","0",null,null,null,"2020-10-29","2020-11-28","1 month contract. Storage deposit $8276 transferred from agreement A14-CT209391 to this agreement. Change unit from O25, 26, 36, 37 to O25 and O36. Deposit of O25, 26, 36, 37 (A14-CT209391) is transferred to O25 and O36 for both deposit and storage rental fee ($8276-$6954 [Deposit and storage rental of O25 and O36, $2318*3]=$1322). The difference of 1 month rental for O25, 26, 36, 37 is paid by the remaining deposit balance ($1322) of O25, 26, 36, 37 and EPS ($2816) on Oct 29, 2020. \r\n\r\n","2020-10-29","32",0,null,6954,"6954.00","2","2020-10-29 17:38:56","2","2020-10-29 17:38:56","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"076,34807","C191255","PERSONAL","Ms","ATneOtMIe0LYAurw32wHyQ==","8fTzWS+7t1nmEnG1fQtiRw==","","JuoZJFFpvrPqF\/07IdfIHtLby15JiIS13nkfz0Bi3G3Ij\/lO63BV2WemTW4T97d1hLIoJeuGN4NgiOa9lHKg9w==","wLWBoYhI1qKia2rkJxrObg==","nW1wxJuhGSp1hffXbm1TmkEK7G4kgckFWfZtR+HR6Hk=","qCm4RuBGDh5cFKNczNFPwQ==",null,1,"4818"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:38:57","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":["9394","760","1098.0","1098.00","2","2020-10-29 17:38:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:38:57","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":["2020-10-29","2020-11-28","760"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-10-29 17:38:57","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":["9394","749","998.0","998.00","2","2020-10-29 17:38:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:38:57","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":["2020-10-29","2020-11-28","749"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-10-29 17:38:57","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":["9394","A14-D205826","PAID",4636,0,"2020-11-28","2020-10-29 17:38:56","2020-10-29 17:38:56","2","2020-10-29 17:38:56","2","2020-10-29 17:38:56",1255]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:38:57","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":["9394",1255,"SETTLED","A14-I209723","2020-10-29 17:38:56","2020-10-29","2","2020-10-29 17:38:56","2","2020-10-29 17:38:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:38:57","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":["9723","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-10-29 17:38:56","2","2020-10-29 17:38:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:38:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[0,0,"9723"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-10-29 17:38:57","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":[1255,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P209362","2020-10-29 17:38:56",4636,"2","2020-10-29 17:38:56","2","2020-10-29 17:38:56","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:38:57","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":["9362","DEPOSIT","5826","PAID","2020-10-29 17:38:56",4636,"2","2020-10-29 17:38:56","2","2020-10-29 17:38:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:38:57","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":["9362","INVOICE","9723","PAID","2020-10-29 17:38:56",0,"2","2020-10-29 17:38:56","2","2020-10-29 17:38:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:38:57","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","2020-10-29 17:38:57","OPEN_FOR_INTERNAL","2020-10-29 17:38:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:38:57","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","2020-10-29 17:38:57","OPEN_FOR_INTERNAL","2020-10-29 17:38:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:41:04","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","2020-10-29 17:41:04","OPEN_FOR_INTERNAL","2020-10-29 17:41:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:41:04","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","2020-10-29 17:41:04","OPEN_FOR_INTERNAL","2020-10-29 17:41:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:41:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:41:09","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","2020-10-29 17:41:09","OPEN_FOR_INTERNAL","2020-10-29 17:41:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:41:09","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","2020-10-29 17:41:09","OPEN_FOR_INTERNAL","2020-10-29 17:41:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:41:14","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","2020-10-29 17:41:14","OPEN_FOR_INTERNAL","2020-10-29 17:41:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:43:09","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","2020-10-29 17:43:09","OPEN_FOR_INTERNAL","2020-10-29 17:43:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:43:09","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","076,34807","1 month contract. Storage deposit $8276 transferred from agreement A14-CT209391 to this agreement. Change unit from O25, 26, 36, 37 to O25 and O36. Deposit and storage rental of O25 and O36 are covered by deposit of O25, 26, 36, 37 (A14-CT209391) ($8276-$6954 [Deposit and storage rental of O25 and O36, $2318*3]=$1322 remaining). \r\n\r\n","2020-10-29 17:43:09","2","8fTzWS+7t1nmEnG1fQtiRw==","ATneOtMIe0LYAurw32wHyQ==","nW1wxJuhGSp1hffXbm1TmkEK7G4kgckFWfZtR+HR6Hk=","wLWBoYhI1qKia2rkJxrObg==","JuoZJFFpvrPqF\/07IdfIHtLby15JiIS13nkfz0Bi3G3Ij\/lO63BV2WemTW4T97d1hLIoJeuGN4NgiOa9lHKg9w==",9394]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:43:09","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","2020-10-29 17:43:09","OPEN_FOR_INTERNAL","2020-10-29 17:43:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:46: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","2020-10-29 17:46:06","OPEN_FOR_INTERNAL","2020-10-29 17:46:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:46: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","2020-10-29 17:46:06","OPEN_FOR_INTERNAL","2020-10-29 17:46:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:46:08","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","2020-10-29 17:46:08","OPEN_FOR_INTERNAL","2020-10-29 17:46:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:46:09","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","2020-10-29 17:46:08","OPEN_FOR_INTERNAL","2020-10-29 17:46:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:46:56","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","2020-10-29 17:46:56","OPEN_FOR_INTERNAL","2020-10-29 17:46:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:49:03","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","2020-10-29 17:49:03","OPEN_FOR_INTERNAL","2020-10-29 17:49:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:49: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","2020-10-29 17:49:06","OPEN_FOR_INTERNAL","2020-10-29 17:49:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:58: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","2020-10-29 17:58:18","OPEN_FOR_INTERNAL","2020-10-29 17:58:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:58: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","2020-10-29 17:58:31","OPEN_FOR_INTERNAL","2020-10-29 17:58:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:58:31","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","076,34807","1 month contract. Storage deposit $8276 transferred from agreement A14-CT209005 to this agreement. Change unit from O25, 26, 36, 37 to O25 and O36. Deposit of O25, 26, 36, 37 (A14-CT209391) will transfer to O25 and O36 for both deposit and storage rental fee ($8276-$6954 [Deposit and storage rental of O25 and O36, $2318*3]=$1322 remaining). The difference of 1 month rental for O25, 26, 36, 37 is covered by the remaining deposit balance ($1322) and paid by EPS ($2816) on Oct 29, 2020. \r\n","2020-10-29 17:58:31","2","8fTzWS+7t1nmEnG1fQtiRw==","ATneOtMIe0LYAurw32wHyQ==","nW1wxJuhGSp1hffXbm1TmkEK7G4kgckFWfZtR+HR6Hk=","wLWBoYhI1qKia2rkJxrObg==","JuoZJFFpvrPqF\/07IdfIHtLby15JiIS13nkfz0Bi3G3Ij\/lO63BV2WemTW4T97d1hLIoJeuGN4NgiOa9lHKg9w==",9391]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:58: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","2020-10-29 17:58:31","OPEN_FOR_INTERNAL","2020-10-29 17:58:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 17:59:50","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","2020-10-29 17:59:50","OPEN_FOR_INTERNAL","2020-10-29 17:59:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:01: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","2020-10-29 18:01:31","OPEN_FOR_INTERNAL","2020-10-29 18:01:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:01:38","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","2020-10-29 18:01:38","OPEN_FOR_INTERNAL","2020-10-29 18:01:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:01: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","2020-10-29 18:01:39","OPEN_FOR_INTERNAL","2020-10-29 18:01:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:10: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","2020-10-29 18:10:06","OPEN_FOR_INTERNAL","2020-10-29 18:10:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:10:06","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:10:09","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","2020-10-29 18:10:09","OPEN_FOR_INTERNAL","2020-10-29 18:10:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:11: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","2020-10-29 18:11:15","OPEN_FOR_INTERNAL","2020-10-29 18:11:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:15: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","2020-10-29 18:15:52","OPEN_FOR_INTERNAL","2020-10-29 18:15:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:16: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","2020-10-29 18:16:42","OPEN_FOR_INTERNAL","2020-10-29 18:16:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:16: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","2020-10-29 18:16:55","OPEN_FOR_INTERNAL","2020-10-29 18:16:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:17: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","2020-10-29 18:17:10","OPEN_FOR_INTERNAL","2020-10-29 18:17:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:17: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","2020-10-29 18:17:24","OPEN_FOR_INTERNAL","2020-10-29 18:17:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:17: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","2020-10-29 18:17:40","OPEN_FOR_INTERNAL","2020-10-29 18:17:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:17:44","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","2020-10-29 18:17:44","OPEN_FOR_INTERNAL","2020-10-29 18:17:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:18: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","2020-10-29 18:18:17","OPEN_FOR_INTERNAL","2020-10-29 18:18:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:18:26","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","2020-10-29 18:18:26","OPEN_FOR_INTERNAL","2020-10-29 18:18:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:18:48","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","2020-10-29 18:18:48","OPEN_FOR_INTERNAL","2020-10-29 18:18:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:19: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","2020-10-29 18:19:02","OPEN_FOR_INTERNAL","2020-10-29 18:19:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:19: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","2020-10-29 18:19:36","OPEN_FOR_INTERNAL","2020-10-29 18:19:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:19: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","2020-10-29 18:19:40","OPEN_FOR_INTERNAL","2020-10-29 18:19:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:19: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","2020-10-29 18:19:52","OPEN_FOR_INTERNAL","2020-10-29 18:19:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:19:56","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","2020-10-29 18:19:56","OPEN_FOR_INTERNAL","2020-10-29 18:19:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:20: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","2020-10-29 18:20:13","OPEN_FOR_INTERNAL","2020-10-29 18:20:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:20: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","2020-10-29 18:20:17","OPEN_FOR_INTERNAL","2020-10-29 18:20:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:23:14","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","2020-10-29 18:23:14","OPEN_FOR_INTERNAL","2020-10-29 18:23:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:23: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","2020-10-29 18:23:17","OPEN_FOR_INTERNAL","2020-10-29 18:23:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:26:04","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","2020-10-29 18:26:04","OPEN_FOR_INTERNAL","2020-10-29 18:26:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:30: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","2020-10-29 18:30:51","OPEN_FOR_INTERNAL","2020-10-29 18:30:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 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","2020-10-29 18:30:52","OPEN_FOR_INTERNAL","2020-10-29 18:30:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:41: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","2020-10-29 18:41:06","OPEN_FOR_INTERNAL","2020-10-29 18:41:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:41: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","2020-10-29 18:41:47","OPEN_FOR_INTERNAL","2020-10-29 18:41:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:46: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","2020-10-29 18:46:12","OPEN_FOR_INTERNAL","2020-10-29 18:46:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:47: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","2020-10-29 18:47:24","OPEN_FOR_INTERNAL","2020-10-29 18:47:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:48:41","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","2020-10-29 18:48:41","OPEN_FOR_INTERNAL","2020-10-29 18:48:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:48:49","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","2020-10-29 18:48:49","OPEN_FOR_INTERNAL","2020-10-29 18:48:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:48:49","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","2020-10-29 18:48:49","OPEN_FOR_INTERNAL","2020-10-29 18:48:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:48:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:48: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","2020-10-29 18:48:52","OPEN_FOR_INTERNAL","2020-10-29 18:48:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:48: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","2020-10-29 18:48:52","OPEN_FOR_INTERNAL","2020-10-29 18:48:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:48: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","2020-10-29 18:48:55","OPEN_FOR_INTERNAL","2020-10-29 18:48:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:49:09","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","2020-10-29 18:49:09","OPEN_FOR_INTERNAL","2020-10-29 18:49:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:49: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","2020-10-29 18:49:11","OPEN_FOR_INTERNAL","2020-10-29 18:49:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:49:11","login_id":"2","controller":"_ajax.php","function":"update_room","input":{"post":{"room_code":"H03","room_id":"393","master_room_id":"8","room_status":"ENDING"},"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1461&filter3=undefined"},"sql":"update room set status = ?, master_room_id = ?, lastupby = ?, lastupdate = ? where id = ?","parameters":["ENDING","8","2","2020-10-29 18:49:11","393"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:49: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","2020-10-29 18:49:17","OPEN_FOR_INTERNAL","2020-10-29 18:49:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:49:38","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","2020-10-29 18:49:38","OPEN_FOR_INTERNAL","2020-10-29 18:49:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:59: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","2020-10-29 18:59:25","OPEN_FOR_INTERNAL","2020-10-29 18:59:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:59: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","2020-10-29 18:59:25","OPEN_FOR_INTERNAL","2020-10-29 18:59:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:59:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:59: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","2020-10-29 18:59:28","OPEN_FOR_INTERNAL","2020-10-29 18:59:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:59: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","2020-10-29 18:59:28","OPEN_FOR_INTERNAL","2020-10-29 18:59:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 18:59: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","2020-10-29 18:59:30","OPEN_FOR_INTERNAL","2020-10-29 18:59:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-10-29 19:00: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","2020-10-29 19:00:02","OPEN_FOR_INTERNAL","2020-10-29 19:00:02"]},"data_before":[],"data_after":[],"step":1} *****