\n \n \n\t\t\t\t\t\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>
A16-159 <\/td>\n\t\t\t\t\t	4X3X7 <\/td>\n\t\t\t\t\t	$1090.00 <\/td>\n\t\t\t\t	- <\/td>	<\/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>
A16-161 <\/td>\n\t\t\t\t\t	8X8X7 <\/td>\n\t\t\t\t\t	$5038.00 <\/td>\n\t\t\t\t	- <\/td>	\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":"76","total_discounted_price":"6128.00","deposit":"12256.00","total_retail_price":"6128.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 13:34:42","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":["C201747","PERSONAL","Ms","K6CZ9UUjtQcq2bBPDY0Brg==","yXKLXTtbNpECaRVTZxF\/Rw==","","5gU2uZA3LfEkac4yL2Y\/QQ==","0Ql8UkUk7p0lGJS9ifh0iiziRr86h00v50mnJchQjbc=","JLpc7at18rZk4H15apx0a+dUoEjGj3schJNhrqcquAK5JJX9j9vD9BMQNG6m45+6G20nWKJKOEVN\/O7mKO793g==","ue3YkA\/gqhfIjzjSakQ58Q==",null,"0Ql8UkUk7p0lGJS9ifh0iiziRr86h00v50mnJchQjbc=","H9hB2wf0X4p6+VyvDFePhw==","2","2020-09-05 13:34:41","2","2020-09-05 13:34:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 13:34:43","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","7",1747,"NEW","A16-CT208866",6128,6128,12256,0,"3","3",21448,30640,21448,"2020-09-05 13:34:43","0",null,null,null,"2020-09-15","2020-12-14","3 months contract. Special offered 50% off for the first 3 months. Storage rental and deposit paid by EPS on 5 Sep 2020. Smart card provided on the same day.","2020-09-15","76",0,null,9192,"9192.00","2","2020-09-05 13:34:41","2","2020-09-05 13:34:41","EPS","","","","EPS","","","",null,0,"189,63729","C201747","PERSONAL","Ms","K6CZ9UUjtQcq2bBPDY0Brg==","yXKLXTtbNpECaRVTZxF\/Rw==","","JLpc7at18rZk4H15apx0a+dUoEjGj3schJNhrqcquAK5JJX9j9vD9BMQNG6m45+6G20nWKJKOEVN\/O7mKO793g==","5gU2uZA3LfEkac4yL2Y\/QQ==","0Ql8UkUk7p0lGJS9ifh0iiziRr86h00v50mnJchQjbc=","ue3YkA\/gqhfIjzjSakQ58Q==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 13:34:43","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":["8866","1650","1090.0","1090.00","2","2020-09-05 13:34:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 13:34:43","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-09-15","2020-12-14","1650"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-09-05 13:34:43","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":["8866","1652","5038.0","5038.00","2","2020-09-05 13:34:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 13:34:43","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-09-15","2020-12-14","1652"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-09-05 13:34:43","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":["8866","A16-D205659","PAID",12256,0,"2020-12-14","2020-09-05 13:34:41","2020-09-05 13:34:41","2","2020-09-05 13:34:41","2","2020-09-05 13:34:41",1747]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 13:34:43","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":["8866",1747,"SETTLED","A16-I209195","2020-09-05 13:34:41","2020-09-15","2","2020-09-05 13:34:41","2","2020-09-05 13:34:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 13:34:43","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":["9195","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-09-05 13:34:41","2","2020-09-05 13:34:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 13:34:43","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":["9195","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,3064,"MO","1",3064,"2","2020-09-05 13:34:41","2","2020-09-05 13:34:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 13:34:43","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":["9195","RENT","\u9810\u7e73\u79df\u91d1",3,6128,"MO","1",6128,"2","2020-09-05 13:34:41","2","2020-09-05 13:34:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 13:34:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[9192,0,"9195"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-09-05 13:34:43","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":[1747,"EPS","","","","EPS","","","","PAID","P208838","2020-09-05 13:34:41",21448,"2","2020-09-05 13:34:41","2","2020-09-05 13:34:41","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 13:34:43","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":["8838","DEPOSIT","5659","PAID","2020-09-05 13:34:41",12256,"2","2020-09-05 13:34:41","2","2020-09-05 13:34:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 13:34:43","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":["8838","INVOICE","9195","PAID","2020-09-05 13:34:41",9192,"2","2020-09-05 13:34:41","2","2020-09-05 13:34:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 13:34:43","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-05 13:34:43","OPEN_FOR_INTERNAL","2020-09-05 13:34:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 13:34:43","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-05 13:34:43","OPEN_FOR_INTERNAL","2020-09-05 13:34:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 13:39: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-09-05 13:39:53","OPEN_FOR_INTERNAL","2020-09-05 13:39:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 13:40:07","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-05 13:40:07","OPEN_FOR_INTERNAL","2020-09-05 13:40:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 13:40:07","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-05 13:40:07","OPEN_FOR_INTERNAL","2020-09-05 13:40:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 13:40: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-09-05 13:40:10","OPEN_FOR_INTERNAL","2020-09-05 13:40:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 13:40: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-09-05 13:40:11","OPEN_FOR_INTERNAL","2020-09-05 13:40:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 13:40: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-09-05 13:40:25","OPEN_FOR_INTERNAL","2020-09-05 13:40:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 13:44: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-09-05 13:44:26","OPEN_FOR_INTERNAL","2020-09-05 13:44:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 13:44: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-09-05 13:44:36","OPEN_FOR_INTERNAL","2020-09-05 13:44:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 13:44: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-09-05 13:44:41","OPEN_FOR_INTERNAL","2020-09-05 13:44:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 13:53: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-09-05 13:53:33","OPEN_FOR_INTERNAL","2020-09-05 13:53:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 13: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-09-05 13:58:31","OPEN_FOR_INTERNAL","2020-09-05 13:58:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 13:59: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-09-05 13:59:01","OPEN_FOR_INTERNAL","2020-09-05 13:59:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:16:35","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-09-05 14:16:35","OPEN_FOR_INTERNAL","2020-09-05 14:16:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:16: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-09-05 14:16:44","OPEN_FOR_INTERNAL","2020-09-05 14:16:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:16: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-09-05 14:16:50","OPEN_FOR_INTERNAL","2020-09-05 14:16:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:16: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-09-05 14:16:50","OPEN_FOR_INTERNAL","2020-09-05 14:16:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:16: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-09-05 14:16:51","OPEN_FOR_INTERNAL","2020-09-05 14:16:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:16: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-09-05 14:16:51","OPEN_FOR_INTERNAL","2020-09-05 14:16:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:16: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-09-05 14:16:51","OPEN_FOR_INTERNAL","2020-09-05 14:16:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:16: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-09-05 14:16:51","OPEN_FOR_INTERNAL","2020-09-05 14:16:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:16: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-09-05 14:16:51","OPEN_FOR_INTERNAL","2020-09-05 14:16:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:16: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-09-05 14:16:51","OPEN_FOR_INTERNAL","2020-09-05 14:16:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:16: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-09-05 14:16:51","OPEN_FOR_INTERNAL","2020-09-05 14:16:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:16: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-09-05 14:16:51","OPEN_FOR_INTERNAL","2020-09-05 14:16:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:16: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-09-05 14:16:51","OPEN_FOR_INTERNAL","2020-09-05 14:16:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:16: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-09-05 14:16:51","OPEN_FOR_INTERNAL","2020-09-05 14:16:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:16: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-09-05 14:16:51","OPEN_FOR_INTERNAL","2020-09-05 14:16:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:16: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-09-05 14:16:51","OPEN_FOR_INTERNAL","2020-09-05 14:16:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17: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-09-05 14:17:03","OPEN_FOR_INTERNAL","2020-09-05 14:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17: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-09-05 14:17:03","OPEN_FOR_INTERNAL","2020-09-05 14:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17: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-09-05 14:17:04","OPEN_FOR_INTERNAL","2020-09-05 14:17:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17: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-09-05 14:17:04","OPEN_FOR_INTERNAL","2020-09-05 14:17:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17: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-09-05 14:17:04","OPEN_FOR_INTERNAL","2020-09-05 14:17:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17: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-09-05 14:17:06","OPEN_FOR_INTERNAL","2020-09-05 14:17:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17:07","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-05 14:17:07","OPEN_FOR_INTERNAL","2020-09-05 14:17:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17:07","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-05 14:17:07","OPEN_FOR_INTERNAL","2020-09-05 14:17:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17:07","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-05 14:17:07","OPEN_FOR_INTERNAL","2020-09-05 14:17:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17: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-09-05 14:17:08","OPEN_FOR_INTERNAL","2020-09-05 14:17:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17: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-09-05 14:17:08","OPEN_FOR_INTERNAL","2020-09-05 14:17:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17: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-09-05 14:17:08","OPEN_FOR_INTERNAL","2020-09-05 14:17:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17:29","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-05 14:17:29","OPEN_FOR_INTERNAL","2020-09-05 14:17:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17:29","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-05 14:17:29","OPEN_FOR_INTERNAL","2020-09-05 14:17:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17:32","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-09-05 14:17:32","OPEN_FOR_INTERNAL","2020-09-05 14:17:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17:32","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-09-05 14:17:32","OPEN_FOR_INTERNAL","2020-09-05 14:17:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17: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-09-05 14:17:34","OPEN_FOR_INTERNAL","2020-09-05 14:17:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17: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-09-05 14:17:34","OPEN_FOR_INTERNAL","2020-09-05 14:17:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17: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-09-05 14:17:34","OPEN_FOR_INTERNAL","2020-09-05 14:17:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17: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-09-05 14:17:34","OPEN_FOR_INTERNAL","2020-09-05 14:17:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17:37","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-09-05 14:17:37","OPEN_FOR_INTERNAL","2020-09-05 14:17:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17:37","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":"","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":62,"customer_code":"C160062","identity_type":"PERSONAL","identity_id":"K228082(5)","title":"Mr","lastname":"Yuen","firstname":"Kwok On, Mark","companyname":"","email":"ym6128@yahoo.com.hk","tel":"61287967","address":"Flat 7,20\/F ,Blk E, Yue Fai Court,Aberdeen","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-09-14","renew_room_key":"254,19454","renew_remark":"1 month contract. Storage rental $600 paid by cash deposit on Aug 06, 2020. Storage deposit transferred from agreement A12-CT208389 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT208668, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"1","order_discount":[],"order_room":[{"room_id":"214","room_code":"D18","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-09-14","rent_from":"2020-09-14","rent_to":"2020-10-13","delivery_service":"0","remark":"1 month contract. Storage rental $600 paid by cash deposit on 5 Sep 2020. Storage deposit transferred from agreement A12-CT208668 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"1","branch_id":"1","company_id":"1","room_key":"254,19454","order_product":[],"pass":true}},"first_order_id":"4763","selected_room_tr":"	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> D18 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",62,"NEW","A12-CT208867",598,598,0,0,"1","1",598,598,598,"2020-09-05 14:17:38","0",null,null,null,"2020-09-14","2020-10-13","1 month contract. Storage rental $600 paid by cash deposit on 5 Sep 2020. Storage deposit transferred from agreement A12-CT208668 to this agreement.","2020-09-14","12",0,null,0,"0.00","2","2020-09-05 14:17:37","2","2020-09-05 14:17:37","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"254,19454","C160062","PERSONAL","Mr","Tq2aGqdc3HaJ2Dhv1kivng==","DtbrOSvE4C7BOu5x4dBFtg==","","2dywE7m0E1QsxnoSSYjXYNGzam8BrQqJlW4yfvPMcgEUuu+U\/Cd9GXzTFUxRV\/Gk","ALSdg5RJw2nKsrdRoyKl+w==","IHWbmboe0mGIN08sR8rCSx94uDCuEAuXNvmkUE\/zPAQ=","CPbHg76fKF8UJ5bblGTxzg==",null,1,"4763"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17:38","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":["8867","214","598.0","598.00","2","2020-09-05 14:17:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17:38","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-09-14","2020-10-13","214"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-09-05 14:17:38","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":["8867",62,"SETTLED","A12-I209196","2020-09-05 14:17:37","2020-09-14","2","2020-09-05 14:17:37","2","2020-09-05 14:17:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17:38","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":["9196","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-09-05 14:17:37","2","2020-09-05 14:17:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"9196"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-09-05 14:17:38","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":[62,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208839","2020-09-05 14:17:37",598,"2","2020-09-05 14:17:37","2","2020-09-05 14:17:37","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17:38","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":["8839","DEPOSIT",null,"PAID","2020-09-05 14:17:37",0,"2","2020-09-05 14:17:37","2","2020-09-05 14:17:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17:38","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":["8839","INVOICE","9196","PAID","2020-09-05 14:17:37",598,"2","2020-09-05 14:17:37","2","2020-09-05 14:17:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17: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-09-05 14:17:38","OPEN_FOR_INTERNAL","2020-09-05 14:17:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:17: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-09-05 14:17:39","OPEN_FOR_INTERNAL","2020-09-05 14:17:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:18:07","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-05 14:18:07","OPEN_FOR_INTERNAL","2020-09-05 14:18:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:23: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-09-05 14:23:16","OPEN_FOR_INTERNAL","2020-09-05 14:23:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:29: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-09-05 14:29:26","OPEN_FOR_INTERNAL","2020-09-05 14:29:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:29: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-09-05 14:29:26","OPEN_FOR_INTERNAL","2020-09-05 14:29:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:29:29","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-05 14:29:29","OPEN_FOR_INTERNAL","2020-09-05 14:29:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:29:29","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-05 14:29:29","OPEN_FOR_INTERNAL","2020-09-05 14:29:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:42: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-09-05 14:42:16","OPEN_FOR_INTERNAL","2020-09-05 14:42:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:42: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-09-05 14:42:16","OPEN_FOR_INTERNAL","2020-09-05 14:42:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:42:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:42: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-09-05 14:42:20","OPEN_FOR_INTERNAL","2020-09-05 14:42:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 14:42:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-05 14:42:27","OPEN_FOR_INTERNAL","2020-09-05 14:42:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:09:43","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-05 15:09:43","OPEN_FOR_INTERNAL","2020-09-05 15:09:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:09:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:11: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-09-05 15:11:34","OPEN_FOR_INTERNAL","2020-09-05 15:11:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:14: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-09-05 15:14:23","OPEN_FOR_INTERNAL","2020-09-05 15:14:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:14: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-09-05 15:14:23","OPEN_FOR_INTERNAL","2020-09-05 15:14:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:14:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-05 15:14:27","OPEN_FOR_INTERNAL","2020-09-05 15:14:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:15: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-09-05 15:15:12","OPEN_FOR_INTERNAL","2020-09-05 15:15:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:15: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-09-05 15:15:49","OPEN_FOR_INTERNAL","2020-09-05 15:15:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:15: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-09-05 15:15:57","OPEN_FOR_INTERNAL","2020-09-05 15:15:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:18: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-09-05 15:18:46","OPEN_FOR_INTERNAL","2020-09-05 15:18:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:18: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-09-05 15:18:52","OPEN_FOR_INTERNAL","2020-09-05 15:18:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:18: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-09-05 15:18:52","OPEN_FOR_INTERNAL","2020-09-05 15:18:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:18: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-09-05 15:18:53","OPEN_FOR_INTERNAL","2020-09-05 15:18:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:18: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-09-05 15:18:53","OPEN_FOR_INTERNAL","2020-09-05 15:18:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:18: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-09-05 15:18:53","OPEN_FOR_INTERNAL","2020-09-05 15:18:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:18: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-09-05 15:18:53","OPEN_FOR_INTERNAL","2020-09-05 15:18:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:18: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-09-05 15:18:53","OPEN_FOR_INTERNAL","2020-09-05 15:18:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:18: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-09-05 15:18:53","OPEN_FOR_INTERNAL","2020-09-05 15:18:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:18: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-09-05 15:18:53","OPEN_FOR_INTERNAL","2020-09-05 15:18:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:18: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-09-05 15:18:53","OPEN_FOR_INTERNAL","2020-09-05 15:18:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:18: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-09-05 15:18:53","OPEN_FOR_INTERNAL","2020-09-05 15:18:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:18: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-09-05 15:18:53","OPEN_FOR_INTERNAL","2020-09-05 15:18:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:18: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-09-05 15:18:53","OPEN_FOR_INTERNAL","2020-09-05 15:18:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:18: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-09-05 15:18:55","OPEN_FOR_INTERNAL","2020-09-05 15:18:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:18: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-09-05 15:18:55","OPEN_FOR_INTERNAL","2020-09-05 15:18:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:18: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-09-05 15:18:55","OPEN_FOR_INTERNAL","2020-09-05 15:18:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:18: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-09-05 15:18:55","OPEN_FOR_INTERNAL","2020-09-05 15:18:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:18: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-09-05 15:18:55","OPEN_FOR_INTERNAL","2020-09-05 15:18:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:18: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-09-05 15:18:55","OPEN_FOR_INTERNAL","2020-09-05 15:18:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:18:58","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-05 15:18:58","OPEN_FOR_INTERNAL","2020-09-05 15:18:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:18:58","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-05 15:18:58","OPEN_FOR_INTERNAL","2020-09-05 15:18:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:18:58","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-05 15:18:58","OPEN_FOR_INTERNAL","2020-09-05 15:18:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:18:58","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-05 15:18:58","OPEN_FOR_INTERNAL","2020-09-05 15:18:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:18: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-09-05 15:18:59","OPEN_FOR_INTERNAL","2020-09-05 15:18:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:19: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-09-05 15:19:00","OPEN_FOR_INTERNAL","2020-09-05 15:19:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:19: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-09-05 15:19:00","OPEN_FOR_INTERNAL","2020-09-05 15:19:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:19: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-09-05 15:19:00","OPEN_FOR_INTERNAL","2020-09-05 15:19:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:19: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-09-05 15:19:48","OPEN_FOR_INTERNAL","2020-09-05 15:19:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:19: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-09-05 15:19:48","OPEN_FOR_INTERNAL","2020-09-05 15:19:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:19: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-09-05 15:19:48","OPEN_FOR_INTERNAL","2020-09-05 15:19:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15: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-09-05 15:19:52","OPEN_FOR_INTERNAL","2020-09-05 15:19:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:19:52","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":"filter1=1&filter2=1398&filter3=undefined&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":927,"customer_code":"C180927","identity_type":"PERSONAL","identity_id":"D666143(3)","title":"Ms","lastname":"Wong","firstname":"Suk Fong","companyname":"","email":null,"tel":"91683606","address":"Room 1301, Lei Tin House, Ap Lei Chau Estate, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1269.0","renew_rent_month":"13","renew_warehousing_date":"2020-09-12","renew_room_key":"0012473904","renew_remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by EPS on August 3, 2019. Storage deposit $2820 transferred from agreement A05-CT194286 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT195628, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"115","order_discount":[{"master_room_discount_id":"247","master_room_id":"115","discount_type":"%","price":"1410.00","disocunted_price":"1269.00","discount":"10.00","monthly_deduct":141,"room_id":"1158","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1158","room_code":"A05-156(\u670d\u88dd\u5009)","retail_price":"1410.0","discounted_price":1269,"location_id":"4"}],"roughly_size":"16","total_retail_price":1410,"total_discounted_price":1269,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":7614,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-09-12","rent_from":"2020-09-12","rent_to":"2021-03-11","delivery_service":"0","remark":"6 months contract. Storage rental paid by EPS on 5 Sep 2020. Storage deposit $2820 transferred from agreement A05-CT195628 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":7614,"final_order_total":7614,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012473904","order_product":[],"pass":true}},"first_order_id":"4286","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-156(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1410.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1269.00","deposit":"0.00","total_retail_price":"1410.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:19:53","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","4",927,"NEW","A05-CT208868",1410,1269,0,0,"6","6",7614,7614,7614,"2020-09-05 15:19:53","0",null,null,null,"2020-09-12","2021-03-11","6 months contract. Storage rental paid by EPS on 5 Sep 2020. Storage deposit $2820 transferred from agreement A05-CT195628 to this agreement.","2020-09-12","16",0,null,0,"0.00","2","2020-09-05 15:19:52","2","2020-09-05 15:19:52","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"0012473904","C180927","PERSONAL","Ms","RuVfL5bwQLIgNmfuYGybyg==","hULSwM2MvFtpeV9\/z+er8Q==","","\/noqmiuDb\/hjRj1eYE4trVPZoOKjXdyhUSrUupwZKPza\/7s6H3GlvFNpxvpKT21fWPgIReSQG38AX8dmimU1wRCbwWnBj1I1k3J0SVXXVTE=","p59Q2E6nuIjMUPe0+p7LLw==",null,"L53wlyOpMEKhaIG7t3tP+A==",null,1,"4286"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:19:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["8868","247","115","1158","%","10.00",141,"2","2020-09-05 15:19:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:19:53","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":["8868","1158","1410.0",1269,"2","2020-09-05 15:19:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:19:53","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-09-12","2021-03-11","1158"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-09-05 15:19:53","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":["8868",927,"SETTLED","A05-I209197","2020-09-05 15:19:52","2020-09-12","2","2020-09-05 15:19:52","2","2020-09-05 15:19:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:19:53","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":["9197","RENT","\u9810\u7e73\u79df\u91d1",1,1269,"MO","1",1269,"2","2020-09-05 15:19:52","2","2020-09-05 15:19:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:19:53","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":["9197","RENT","\u9810\u7e73\u79df\u91d1",2,1269,"MO","1",1269,"2","2020-09-05 15:19:52","2","2020-09-05 15:19:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:19:53","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":["9197","RENT","\u9810\u7e73\u79df\u91d1",3,1269,"MO","1",1269,"2","2020-09-05 15:19:52","2","2020-09-05 15:19:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:19:53","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":["9197","RENT","\u9810\u7e73\u79df\u91d1",4,1269,"MO","1",1269,"2","2020-09-05 15:19:52","2","2020-09-05 15:19:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:19:53","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":["9197","RENT","\u9810\u7e73\u79df\u91d1",5,1269,"MO","1",1269,"2","2020-09-05 15:19:52","2","2020-09-05 15:19:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:19:53","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":["9197","RENT","\u9810\u7e73\u79df\u91d1",6,1269,"MO","1",1269,"2","2020-09-05 15:19:52","2","2020-09-05 15:19:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:19:53","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7614,0,"9197"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-09-05 15:19:53","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":[927,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P208840","2020-09-05 15:19:52",7614,"2","2020-09-05 15:19:52","2","2020-09-05 15:19:52","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:19:53","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":["8840","DEPOSIT",null,"PAID","2020-09-05 15:19:52",0,"2","2020-09-05 15:19:52","2","2020-09-05 15:19:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:19:53","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":["8840","INVOICE","9197","PAID","2020-09-05 15:19:52",7614,"2","2020-09-05 15:19:52","2","2020-09-05 15:19:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:19: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-09-05 15:19:53","OPEN_FOR_INTERNAL","2020-09-05 15:19:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:19:54","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-09-05 15:19:54","OPEN_FOR_INTERNAL","2020-09-05 15:19:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:24: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-09-05 15:24:34","OPEN_FOR_INTERNAL","2020-09-05 15:24:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:25:21","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-05 15:25:21","OPEN_FOR_INTERNAL","2020-09-05 15:25:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:32: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-09-05 15:32:22","OPEN_FOR_INTERNAL","2020-09-05 15:32:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:32:32","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-09-05 15:32:32","OPEN_FOR_INTERNAL","2020-09-05 15:32:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:33:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-05 15:33:27","OPEN_FOR_INTERNAL","2020-09-05 15:33:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:33:43","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-05 15:33:43","OPEN_FOR_INTERNAL","2020-09-05 15:33:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:34:19","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-05 15:34:19","OPEN_FOR_INTERNAL","2020-09-05 15:34:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15: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-09-05 15:35:05","OPEN_FOR_INTERNAL","2020-09-05 15:35:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:39: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-09-05 15:39:38","OPEN_FOR_INTERNAL","2020-09-05 15:39:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:54: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-09-05 15:54:31","OPEN_FOR_INTERNAL","2020-09-05 15:54:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:54: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-09-05 15:54:31","OPEN_FOR_INTERNAL","2020-09-05 15:54:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:54: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-09-05 15:54:33","OPEN_FOR_INTERNAL","2020-09-05 15:54:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:54: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-09-05 15:54:34","OPEN_FOR_INTERNAL","2020-09-05 15:54:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:54:43","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-09-05 15:54:43","OPEN_FOR_INTERNAL","2020-09-05 15:54:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:54: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-09-05 15:54:53","OPEN_FOR_INTERNAL","2020-09-05 15:54:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:55: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-09-05 15:55:24","OPEN_FOR_INTERNAL","2020-09-05 15:55:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-05 15:55: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-09-05 15:55:28","OPEN_FOR_INTERNAL","2020-09-05 15:55:28"]},"data_before":[],"data_after":[],"step":1} *****