\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>
A16-002 <\/td>\n\t\t\t\t\t	4X3X3.5 <\/td>\n\t\t\t\t\t	$668.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":"12","total_discounted_price":"602.00","deposit":"1336.00","total_retail_price":"668.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 11:56:10","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":["C201655","PERSONAL","Mr","VWqY0RR+CtF8xicRi19aVw==","LhNKcjkbNjDjM7JhWTilMlSer4NN0NA7DH5izwHVtjw=","","yUp4+UjM\/SZOXhuDGKMdkg==","\/3y4cDG9NDPwYWapyehg3fFQkwpXeZJ6gjUohN6IzLo=","sOCDaDZwH6jHw7SfMQhdzOleYbWEH6GBGp4N7qKHJm3Evu5w0iKZCTwsdP0\/xuUw","3Xk+tssAHV+mkNCPuYAIBA==",null,"\/3y4cDG9NDPwYWapyehg3fFQkwpXeZJ6gjUohN6IzLo=","0Seh2PDWwed4s6EWaJ3ddQ==","2","2020-07-03 11:56:09","2","2020-07-03 11:56:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 11:56:11","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",1655,"NEW","A16-CT208279",668,602,1336,0,"12","12",8560,8560,8560,"2020-07-03 11:56:11","0",null,null,null,"2020-07-09","2021-07-08","12 months contract, Storage rental and deposit paid by EPS on July 3, 2020. Smartcard provided on July 3, 2020.","2020-07-09","12",0,null,0,"0","2","2020-07-03 11:56:09","2","2020-07-03 11:56:09","EPS","","","","EPS","","","",null,0,"189,12121","C201655","PERSONAL","Mr","VWqY0RR+CtF8xicRi19aVw==","LhNKcjkbNjDjM7JhWTilMlSer4NN0NA7DH5izwHVtjw=","","sOCDaDZwH6jHw7SfMQhdzOleYbWEH6GBGp4N7qKHJm3Evu5w0iKZCTwsdP0\/xuUw","yUp4+UjM\/SZOXhuDGKMdkg==","\/3y4cDG9NDPwYWapyehg3fFQkwpXeZJ6gjUohN6IzLo=","3Xk+tssAHV+mkNCPuYAIBA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 11:56:11","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":["8279","475 available_room_list_input","200","1493","%","16.89",112.8252,"2","2020-07-03 11:56:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 11:56:11","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":["8279","1493","668.0",555.2,"2","2020-07-03 11:56:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 11:56:11","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-07-09","2021-07-08","1493"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-03 11:56:11","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":["8279","A16-D205518","PAID",1336,0,"2021-07-08","2020-07-03 11:56:09","2020-07-03 11:56:09","2","2020-07-03 11:56:09","2","2020-07-03 11:56:09",1655]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 11:56:11","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":["8279",1655,"SETTLED","A16-I208608","2020-07-03 11:56:09","2020-07-09","2","2020-07-03 11:56:09","2","2020-07-03 11:56:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 11:56:11","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":["8608","RENT","\u9810\u7e73\u79df\u91d1",1,602,"MO","1",602,"2","2020-07-03 11:56:09","2","2020-07-03 11:56:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 11:56:11","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":["8608","RENT","\u9810\u7e73\u79df\u91d1",2,602,"MO","1",602,"2","2020-07-03 11:56:09","2","2020-07-03 11:56:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 11:56:11","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":["8608","RENT","\u9810\u7e73\u79df\u91d1",3,602,"MO","1",602,"2","2020-07-03 11:56:09","2","2020-07-03 11:56:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 11:56:11","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":["8608","RENT","\u9810\u7e73\u79df\u91d1",4,602,"MO","1",602,"2","2020-07-03 11:56:09","2","2020-07-03 11:56:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 11:56:11","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":["8608","RENT","\u9810\u7e73\u79df\u91d1",5,602,"MO","1",602,"2","2020-07-03 11:56:09","2","2020-07-03 11:56:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 11:56:11","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":["8608","RENT","\u9810\u7e73\u79df\u91d1",6,602,"MO","1",602,"2","2020-07-03 11:56:09","2","2020-07-03 11:56:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 11:56:11","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":["8608","RENT","\u9810\u7e73\u79df\u91d1",7,602,"MO","1",602,"2","2020-07-03 11:56:09","2","2020-07-03 11:56:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 11:56:11","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":["8608","RENT","\u9810\u7e73\u79df\u91d1",8,602,"MO","1",602,"2","2020-07-03 11:56:09","2","2020-07-03 11:56:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 11:56:11","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":["8608","RENT","\u9810\u7e73\u79df\u91d1",9,602,"MO","1",602,"2","2020-07-03 11:56:09","2","2020-07-03 11:56:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 11:56:11","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":["8608","RENT","\u9810\u7e73\u79df\u91d1",10,602,"MO","1",602,"2","2020-07-03 11:56:09","2","2020-07-03 11:56:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 11:56:11","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":["8608","RENT","\u9810\u7e73\u79df\u91d1",11,602,"MO","1",602,"2","2020-07-03 11:56:09","2","2020-07-03 11:56:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 11:56:11","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":["8608","RENT","\u9810\u7e73\u79df\u91d1",12,602,"MO","1",602,"2","2020-07-03 11:56:09","2","2020-07-03 11:56:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 11:56:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7224,0,"8608"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-03 11:56:11","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":[1655,"EPS","","","","EPS","","","","PAID","P208251","2020-07-03 11:56:09",8560,"2","2020-07-03 11:56:09","2","2020-07-03 11:56:09","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 11:56:11","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":["8251","DEPOSIT","5518","PAID","2020-07-03 11:56:09",1336,"2","2020-07-03 11:56:09","2","2020-07-03 11:56:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 11:56:11","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":["8251","INVOICE","8608","PAID","2020-07-03 11:56:09",7224,"2","2020-07-03 11:56:09","2","2020-07-03 11:56:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 12:09:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 12:09:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 13:47:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 13:48:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 13:48:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 13:48:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:03:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:08:09","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":"type=INVOICE&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1288,"customer_code":"C191288","identity_type":"PERSONAL","identity_id":"D505014(7)","title":"Ms","lastname":"Ng","firstname":"Sau Fong","companyname":"","email":null,"tel":"62882524","address":"Flat 3101, Tsz On House, Yue On Court, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1672.0","renew_rent_month":"13","renew_warehousing_date":"2020-07-09","renew_room_key":"076,39330","renew_remark":"13 month contract. Special offer, one month free and $500 leaflet voucher. Storage rental and deposit paid by EPS on June 8, 2019. Smartcard and padlock keys provided on June 8, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT195175, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $3714.0","renew_master_room_id":"205","order_discount":[],"order_room":[{"room_id":"1686","room_code":"A16-195","retail_price":"1857.0","discounted_price":"1857.00","location_id":"7"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1672,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":20064,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1672.00","warehousing_date":"2020-07-09","rent_from":"2020-07-09","rent_to":"2021-08-08","delivery_service":"0","remark":"13 month contract. Special offer, one month free. Storage rental paid by EPS on July 3, 2020. Storage Deposit transferred from A16-CT195175 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":1672,"order_total":21736,"final_order_total":20064,"location_id":"7","branch_id":"1","company_id":"1","room_key":"076,39330","order_product":[],"pass":true}},"first_order_id":5175,"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> A16-195 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1857.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1672.00","deposit":"0.00","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:08:10","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","7",1288,"NEW","A16-CT208280",1857,1672,0,0,"13","13",20064,21736,20064,"2020-07-03 14:08:10","0",null,null,null,"2020-07-09","2021-08-08","13 month contract. Special offer, one month free. Storage rental paid by EPS on July 3, 2020. Storage Deposit transferred from A16-CT195175 to this agreement.\r\n","2020-07-09","24",0,null,1672,"1672.00","2","2020-07-03 14:08:09","2","2020-07-03 14:08:09","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"076,39330","C191288","PERSONAL","Ms","NVnq23ari72NYKD\/5D2OYg==","cxr02xsD1tXvJ4ihJHZKWw==","","o40Xhn1WGgB7CfRgrDvf586vOpIyARt0II9x4rpniSte9FZgBzKz3GtzKWeZHjd9uYQz+SzCLxQL\/C8uu2Ry3A==","20RbPuIpxMu0LPupZA6rMA==",null,"Wbfxu7AKmCVDLUjZhoTtjw==",null,1,5175]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:08:10","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":["8280","1686","1857.0","1857.00","2","2020-07-03 14:08:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:08:10","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-07-09","2021-08-08","1686"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-03 14:08:10","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":["8280",1288,"SETTLED","A16-I208609","2020-07-03 14:08:09","2020-07-09","2","2020-07-03 14:08:09","2","2020-07-03 14:08:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:08:10","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":["8609","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1672,"MO","1",1672,"2","2020-07-03 14:08:09","2","2020-07-03 14:08:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:08:10","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":["8609","RENT","\u9810\u7e73\u79df\u91d1",3,1672,"MO","1",1672,"2","2020-07-03 14:08:09","2","2020-07-03 14:08:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:08:10","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":["8609","RENT","\u9810\u7e73\u79df\u91d1",4,1672,"MO","1",1672,"2","2020-07-03 14:08:09","2","2020-07-03 14:08:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:08:10","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":["8609","RENT","\u9810\u7e73\u79df\u91d1",5,1672,"MO","1",1672,"2","2020-07-03 14:08:09","2","2020-07-03 14:08:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:08:10","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":["8609","RENT","\u9810\u7e73\u79df\u91d1",6,1672,"MO","1",1672,"2","2020-07-03 14:08:09","2","2020-07-03 14:08:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:08:10","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":["8609","RENT","\u9810\u7e73\u79df\u91d1",7,1672,"MO","1",1672,"2","2020-07-03 14:08:09","2","2020-07-03 14:08:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:08:10","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":["8609","RENT","\u9810\u7e73\u79df\u91d1",8,1672,"MO","1",1672,"2","2020-07-03 14:08:09","2","2020-07-03 14:08:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:08:10","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":["8609","RENT","\u9810\u7e73\u79df\u91d1",9,1672,"MO","1",1672,"2","2020-07-03 14:08:09","2","2020-07-03 14:08:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:08:10","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":["8609","RENT","\u9810\u7e73\u79df\u91d1",10,1672,"MO","1",1672,"2","2020-07-03 14:08:09","2","2020-07-03 14:08:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:08:10","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":["8609","RENT","\u9810\u7e73\u79df\u91d1",11,1672,"MO","1",1672,"2","2020-07-03 14:08:09","2","2020-07-03 14:08:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:08:10","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":["8609","RENT","\u9810\u7e73\u79df\u91d1",12,1672,"MO","1",1672,"2","2020-07-03 14:08:09","2","2020-07-03 14:08:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:08:10","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":["8609","RENT","\u9810\u7e73\u79df\u91d1",13,1672,"MO","1",1672,"2","2020-07-03 14:08:09","2","2020-07-03 14:08:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:08:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[20064,0,"8609"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-03 14:08:10","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":[1288,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P208252","2020-07-03 14:08:09",20064,"2","2020-07-03 14:08:09","2","2020-07-03 14:08:09","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:08:10","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":["8252","DEPOSIT",null,"PAID","2020-07-03 14:08:09",0,"2","2020-07-03 14:08:09","2","2020-07-03 14:08:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:08:10","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":["8252","INVOICE","8609","PAID","2020-07-03 14:08:09",20064,"2","2020-07-03 14:08:09","2","2020-07-03 14:08:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:28:15","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","189,12121","12 months contract, Storage rental and deposit paid by EPS on July 3, 2020. Smartcard provided on July 3, 2020.","2020-07-03 14:28:15","2","LhNKcjkbNjDjM7JhWTilMjE6E50Ybil9oJiCxRrq3d0=","VWqY0RR+CtF8xicRi19aVw==","\/3y4cDG9NDPwYWapyehg3fFQkwpXeZJ6gjUohN6IzLo=","yUp4+UjM\/SZOXhuDGKMdkg==","sOCDaDZwH6jHw7SfMQhdzK54bLc3MrXeMrOJHf8iIYNeUoM+E\/Yndh1r+A97KXBc",8279]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:55:11","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&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":"0","customer_id":"1605","customer_code":"C201605","identity_type":"BUSINESS","identity_id":"68595948","title":"Ms","lastname":"WONG","firstname":"Ms","companyname":"Loyal Wealthy International Limited","email":"xjqxjq988@gmail.com","tel":"31112602","address":"Unit A, 8\/F Emperor Watch and Jewellery Centre,8 Russell Street, Causeway Bay Hong Kong","pass":true,"customer_first_order":false},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1430.0","renew_rent_month":"12","renew_warehousing_date":"2020-05-23","renew_room_key":"056,16409","renew_remark":"12 months contract. Special renewal offer, $100 cake voucher offered. Storage rental paid by cheque deposit on May 31, 2019. Storage deposit transferred from agreement A14-CT183848 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195123, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"49","order_discount":[{"master_room_discount_id":"341","master_room_id":"140","discount_type":"%","price":"1308.00","disocunted_price":"1308.00","discount":"34.90","monthly_deduct":456.492,"room_id":"1204","is_final_discount":"0","payment_term":"PREPAID_12_MO"},{"master_room_discount_id":"341 available_room_list_input","master_room_id":"140","discount_type":"%","price":"1112.00","disocunted_price":"1112.00","discount":"34.90","monthly_deduct":388.088,"room_id":"1211","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1211","room_code":"B01-021","retail_price":"1112.0","discounted_price":723.9,"location_id":"5"},{"room_id":"1204","room_code":"B01-014","retail_price":"1308.0","discounted_price":851.5,"location_id":"5"}],"roughly_size":"36","total_retail_price":2420,"total_discounted_price":1692,"deposit":4336,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":24640,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-06","rent_from":"2020-07-06","rent_to":"2021-07-05","delivery_service":"0","remark":"12 months contract. Storage rental and deposit paid by cheque deposit on Jul 03,2020.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":24640,"final_order_total":24640,"location_id":"5","branch_id":"2","company_id":"1","room_key":"'0012492375","order_product":[],"pass":true}},"first_order_id":"3848","selected_room_tr":"\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\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> B01-021 <\/td>\n\t\t\t\t\t 4X4X7 <\/td>\n\t\t\t\t\t $1112.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr> B01-014 <\/td>\n\t\t\t\t\t 4X5X7 <\/td>\n\t\t\t\t\t $1308.00 <\/td>\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\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","floor_plan_rent_room":[{"room_id":"1204","master_room_id":"141","room_code":"B01-014"}],"roughly_size":"36","total_discounted_price":"1692","deposit":"4336.00","total_retail_price":"2420.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:55:12","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","2","5","1605","NEW","B01-CT208281",2420,1692,4336,0,"12","12",24640,24640,24640,"2020-07-03 14:55:12","0",null,null,null,"2020-07-06","2021-07-05","12 months contract. Storage rental and deposit paid by cheque deposit on Jul 03,2020.","2020-07-06","36",0,null,0,"0","2","2020-07-03 14:55:11","2","2020-07-03 14:55:11","BANKIN","","","","BANKIN","","","",null,0,"'0012492375","C201605","BUSINESS","Ms","VEr4RtjrPyCEI5wmpFKxTA==","ddrfzAYTmkL\/QNu3psjONQ==","Loyal Wealthy International Limited","tIB0p3kqu0cxirOY4SYbOohAN5sWtQAI7kNtytbFdGxBc5ppKLFHPaaLJ45knemndo1jLs88m9rf322LOoQCDsYmpwZVJoBRP5IrvN668QxXnLGwKHj4CbDQOVncCXPs","6vVhnNE9a+WnP+kudBnf9Q==","T38ux9tVoBcPpsL1ss6dhL+yW0JF1s9l1wQtsfOhtkE=",null,"+JbWCAHyu3pTd+hjr7jzrw==",1,"3848"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:55:12","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":["8281","341","140","1204","%","34.90",456.492,"2","2020-07-03 14:55:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:55:12","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":["8281","341 available_room_list_input","140","1211","%","34.90",388.088,"2","2020-07-03 14:55:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:55:12","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":["8281","1211","1112.0",723.9,"2","2020-07-03 14:55:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:55:12","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-07-06","2021-07-05","1211"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-03 14:55:12","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":["8281","1204","1308.0",851.5,"2","2020-07-03 14:55:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:55:12","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-07-06","2021-07-05","1204"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-03 14:55:12","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":["8281","B01-D205519","PAID",4336,0,"2021-07-05","2020-07-03 14:55:11","2020-07-03 14:55:11","2","2020-07-03 14:55:11","2","2020-07-03 14:55:11","1605"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:55:12","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":["8281","1605","SETTLED","B01-I208610","2020-07-03 14:55:11","2020-07-06","2","2020-07-03 14:55:11","2","2020-07-03 14:55:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:55:12","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":["8610","RENT","\u9810\u7e73\u79df\u91d1",1,1692,"MO","1",1692,"2","2020-07-03 14:55:11","2","2020-07-03 14:55:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:55:12","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":["8610","RENT","\u9810\u7e73\u79df\u91d1",2,1692,"MO","1",1692,"2","2020-07-03 14:55:11","2","2020-07-03 14:55:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:55:12","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":["8610","RENT","\u9810\u7e73\u79df\u91d1",3,1692,"MO","1",1692,"2","2020-07-03 14:55:11","2","2020-07-03 14:55:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:55:12","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":["8610","RENT","\u9810\u7e73\u79df\u91d1",4,1692,"MO","1",1692,"2","2020-07-03 14:55:11","2","2020-07-03 14:55:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:55:12","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":["8610","RENT","\u9810\u7e73\u79df\u91d1",5,1692,"MO","1",1692,"2","2020-07-03 14:55:11","2","2020-07-03 14:55:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:55:12","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":["8610","RENT","\u9810\u7e73\u79df\u91d1",6,1692,"MO","1",1692,"2","2020-07-03 14:55:11","2","2020-07-03 14:55:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:55:12","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":["8610","RENT","\u9810\u7e73\u79df\u91d1",7,1692,"MO","1",1692,"2","2020-07-03 14:55:11","2","2020-07-03 14:55:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:55:12","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":["8610","RENT","\u9810\u7e73\u79df\u91d1",8,1692,"MO","1",1692,"2","2020-07-03 14:55:11","2","2020-07-03 14:55:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:55:12","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":["8610","RENT","\u9810\u7e73\u79df\u91d1",9,1692,"MO","1",1692,"2","2020-07-03 14:55:11","2","2020-07-03 14:55:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:55:12","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":["8610","RENT","\u9810\u7e73\u79df\u91d1",10,1692,"MO","1",1692,"2","2020-07-03 14:55:11","2","2020-07-03 14:55:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:55:12","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":["8610","RENT","\u9810\u7e73\u79df\u91d1",11,1692,"MO","1",1692,"2","2020-07-03 14:55:11","2","2020-07-03 14:55:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:55:12","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":["8610","RENT","\u9810\u7e73\u79df\u91d1",12,1692,"MO","1",1692,"2","2020-07-03 14:55:11","2","2020-07-03 14:55:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:55:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[20304,0,"8610"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-03 14:55:12","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":["1605","BANKIN","","","","BANKIN","","","","PAID","P208253","2020-07-03 14:55:11",24640,"2","2020-07-03 14:55:11","2","2020-07-03 14:55:11","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:55:12","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":["8253","DEPOSIT","5519","PAID","2020-07-03 14:55:11",4336,"2","2020-07-03 14:55:11","2","2020-07-03 14:55:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 14:55:12","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":["8253","INVOICE","8610","PAID","2020-07-03 14:55:11",20304,"2","2020-07-03 14:55:11","2","2020-07-03 14:55:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 15:24:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 15:26:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 15:38:43","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":"type=INVOICE&filter1=0&filter2=1242&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1204","master_room_id":"141","room_code":"B01-014"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":600,"customer_code":"C170600","identity_type":"PERSONAL","identity_id":"D396947(A)","title":"Ms","lastname":"Yu","firstname":"Alice","companyname":"","email":"ayualice@gmail.com","tel":"91919705","address":"Block 33A, 30\/F, Flat B, South Horizons, Ap Lei Chau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1162.0","renew_rent_month":"13","renew_warehousing_date":"2020-07-16","renew_room_key":"134, 31163","renew_remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by bank transfer on June 4, 2019. Storage deposit transferred from agreement A18-CT183798 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195153, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"851","room_code":"S10","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":13944,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-16","rent_from":"2020-07-16","rent_to":"2021-07-15","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on July 03,2020. Storage deposit transferred from agreement A18-CT195153 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":13944,"final_order_total":13944,"location_id":"3","branch_id":"1","company_id":"1","room_key":"134, 31163","order_product":[],"pass":true}},"first_order_id":"3798","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> S10 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.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":"1162.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 15:38:44","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","3",600,"NEW","A18-CT208282",1290,1162,0,0,"12","12",13944,13944,13944,"2020-07-03 15:38:44","0",null,null,null,"2020-07-16","2021-07-15","12 months contract. Storage rental paid by bank transfer on July 03,2020. Storage deposit transferred from agreement A18-CT195153 to this agreement.","2020-07-16","16",0,null,0,"0","2","2020-07-03 15:38:43","2","2020-07-03 15:38:43","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"134, 31163","C170600","PERSONAL","Ms","DZUBVXrhsSYmMUBbroHD0g==","thtRZ5CDeQ9OOuodTdr1ng==","","rh9xtiYy\/QmtHMk+X90Xlt654v\/5zHpMIItgaTAW+kn3XB5Uon6yCvRT3gwvnAGTN+B7a1OhoAbTWNmbsiHv5A==","O+rbNA0q6j1wmXMNSVQERA==","z+pBVq9KbP+BFeqUWjM7klFMdy\/34B99z+eFkD2dAtY=","CaYQMgw4gIi75jtqnftYVw==",null,1,"3798"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 15:38:44","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":["8282","851","1290.0","1290.00","2","2020-07-03 15:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 15:38:44","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-07-16","2021-07-15","851"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-03 15:38:44","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":["8282",600,"SETTLED","A18-I208611","2020-07-03 15:38:43","2020-07-16","2","2020-07-03 15:38:43","2","2020-07-03 15:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 15:38:44","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":["8611","RENT","\u9810\u7e73\u79df\u91d1",1,1162,"MO","1",1162,"2","2020-07-03 15:38:43","2","2020-07-03 15:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 15:38:44","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":["8611","RENT","\u9810\u7e73\u79df\u91d1",2,1162,"MO","1",1162,"2","2020-07-03 15:38:43","2","2020-07-03 15:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 15:38:44","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":["8611","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-07-03 15:38:43","2","2020-07-03 15:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 15:38:44","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":["8611","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-07-03 15:38:43","2","2020-07-03 15:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 15:38:44","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":["8611","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-07-03 15:38:43","2","2020-07-03 15:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 15:38:44","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":["8611","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-07-03 15:38:43","2","2020-07-03 15:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 15:38:44","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":["8611","RENT","\u9810\u7e73\u79df\u91d1",7,1162,"MO","1",1162,"2","2020-07-03 15:38:43","2","2020-07-03 15:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 15:38:44","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":["8611","RENT","\u9810\u7e73\u79df\u91d1",8,1162,"MO","1",1162,"2","2020-07-03 15:38:43","2","2020-07-03 15:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 15:38:44","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":["8611","RENT","\u9810\u7e73\u79df\u91d1",9,1162,"MO","1",1162,"2","2020-07-03 15:38:43","2","2020-07-03 15:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 15:38:44","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":["8611","RENT","\u9810\u7e73\u79df\u91d1",10,1162,"MO","1",1162,"2","2020-07-03 15:38:43","2","2020-07-03 15:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 15:38:44","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":["8611","RENT","\u9810\u7e73\u79df\u91d1",11,1162,"MO","1",1162,"2","2020-07-03 15:38:43","2","2020-07-03 15:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 15:38:44","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":["8611","RENT","\u9810\u7e73\u79df\u91d1",12,1162,"MO","1",1162,"2","2020-07-03 15:38:43","2","2020-07-03 15:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 15:38:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13944,0,"8611"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-03 15:38:44","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":[600,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208254","2020-07-03 15:38:43",13944,"2","2020-07-03 15:38:43","2","2020-07-03 15:38:43","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 15:38:44","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":["8254","DEPOSIT",null,"PAID","2020-07-03 15:38:43",0,"2","2020-07-03 15:38:43","2","2020-07-03 15:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 15:38:44","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":["8254","INVOICE","8611","PAID","2020-07-03 15:38:43",13944,"2","2020-07-03 15:38:43","2","2020-07-03 15:38:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 15:41:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:08:11","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=2&filter2=1539&filter3=undefined","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1204","master_room_id":"141","room_code":"B01-014"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":755,"customer_code":"C180755","identity_type":"PERSONAL","identity_id":"D674816(4)","title":"Ms","lastname":"Lee","firstname":"Kam Mui","companyname":"","email":null,"tel":"54998807","address":"Flat F, 25\/F, Kam Fat Building, 145 Lee Chi Road, Apleichau, Hong Kong","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-07-06","renew_room_key":"136,32469","renew_remark":"1 month contract. Storage rental paid by bank transfer on May 31, 2020. Storage deposit transferred from agreement A14-CT207753 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT208000, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"628","room_code":"M39","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"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","warehousing_date":"2020-07-06","rent_from":"2020-07-06","rent_to":"2020-08-05","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Jul 03, 2020. Storage deposit transferred from agreement A14-CT208000 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"136,32469","order_product":[],"pass":true}},"first_order_id":"4693","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> M39 <\/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> <\/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.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:08:12","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",755,"NEW","A14-CT208283",598,598,0,0,"1","1",598,598,598,"2020-07-03 16:08:12","0",null,null,null,"2020-07-06","2020-08-05","1 month contract. Storage rental paid by bank transfer on Jul 03, 2020. Storage deposit transferred from agreement A14-CT208000 to this agreement.","2020-07-06","12",0,null,0,"0","2","2020-07-03 16:08:11","2","2020-07-03 16:08:11","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"136,32469","C180755","PERSONAL","Ms","Bz\/rX4ASIpNafqhGM12E+g==","kiriEIqhcx866RNZiMXdKQ==","","J+qxNwNZZDybuSy0bJS1H3QTc7\/evdtOLUtQc4ivvsWPxn+cqVkhkN\/TohPrTXWpxmb7Nhoov\/XjNXxhd0djX6hEDvZ74IuDZYu9myZVwCs=","uTqJ0Kzbi8lcDPgXUMT73Q==",null,"fFKAofifZnWz0Rnx1R5aUA==",null,1,"4693"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:08:12","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":["8283","628","598.0","598.00","2","2020-07-03 16:08:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:08:12","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-07-06","2020-08-05","628"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-03 16:08:12","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":["8283",755,"SETTLED","A14-I208612","2020-07-03 16:08:11","2020-07-06","2","2020-07-03 16:08:11","2","2020-07-03 16:08:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:08:12","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":["8612","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-07-03 16:08:11","2","2020-07-03 16:08:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:08:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8612"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-03 16:08:12","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":[755,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208255","2020-07-03 16:08:11",598,"2","2020-07-03 16:08:11","2","2020-07-03 16:08:11","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:08:12","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":["8255","DEPOSIT",null,"PAID","2020-07-03 16:08:11",0,"2","2020-07-03 16:08:11","2","2020-07-03 16:08:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:08:12","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":["8255","INVOICE","8612","PAID","2020-07-03 16:08:11",598,"2","2020-07-03 16:08:11","2","2020-07-03 16:08:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:09:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:34:21","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=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1204","master_room_id":"141","room_code":"B01-014"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":673,"customer_code":"C170673","identity_type":"PERSONAL","identity_id":"Y085423(7)","title":"Mr","lastname":"Li","firstname":"Pui Wing","companyname":"","email":"wing022090@hotmail.com","tel":"65002249","address":"Flat A, 6\/F. Albert House, 26 Cheng Tu Rd, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"568.0","renew_rent_month":"3","renew_warehousing_date":"2020-07-01","renew_room_key":"054,58226,076,35816","renew_remark":"3 months contract. Storage rental paid by bank transfer on March 27, 2020. Storage deposit transferred from agreement A14-CT207155 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207511, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"620","room_code":"M31","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":568,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":1704,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-01","rent_from":"2020-07-01","rent_to":"2020-09-30","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on Jul 03, 2020. Storage deposit transferred from agreement A14-CT207511 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1704,"final_order_total":1704,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,58226,076,35816","order_product":[],"pass":true}},"first_order_id":"4685","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> M31 <\/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> <\/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":"568.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:34:21","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",673,"NEW","A14-CT208284",598,568,0,0,"3","3",1704,1704,1704,"2020-07-03 16:34:21","0",null,null,null,"2020-07-01","2020-09-30","3 months contract. Storage rental paid by bank transfer on Jul 03, 2020. Storage deposit transferred from agreement A14-CT207511 to this agreement.","2020-07-01","12",0,null,0,"0","2","2020-07-03 16:34:21","2","2020-07-03 16:34:21","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,58226,076,35816","C170673","PERSONAL","Mr","ITD2Z30msP76kNRsYAQJdA==","7KCehmxbvwRMb+U8lHGoVA==","","HdXbjSMvv+ZR14503QlGfIIJx53YwiSYo18C3zg2iAsoCVGYQ5WI8DdHfRG1zNaPWkGvmtKZhfECBhHRiUVkSg==","7i41GG+VMMQ0anZ5o5qU1A==","CYmwmTN8U9iiSrWcIU95bF9znWI7Bh\/wdBd3p1sJ\/Ew=","V8J6VCsbvmxznZr8ycizJA==",null,1,"4685"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:34:21","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":["8284","620","598.0","598.00","2","2020-07-03 16:34:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:34:21","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-07-01","2020-09-30","620"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-03 16:34:21","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":["8284",673,"SETTLED","A14-I208613","2020-07-03 16:34:21","2020-07-01","2","2020-07-03 16:34:21","2","2020-07-03 16:34:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:34:21","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":["8613","RENT","\u9810\u7e73\u79df\u91d1",1,568,"MO","1",568,"2","2020-07-03 16:34:21","2","2020-07-03 16:34:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:34:21","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":["8613","RENT","\u9810\u7e73\u79df\u91d1",2,568,"MO","1",568,"2","2020-07-03 16:34:21","2","2020-07-03 16:34:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:34:21","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":["8613","RENT","\u9810\u7e73\u79df\u91d1",3,568,"MO","1",568,"2","2020-07-03 16:34:21","2","2020-07-03 16:34:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:34:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1704,0,"8613"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-03 16:34:21","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":[673,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208256","2020-07-03 16:34:21",1704,"2","2020-07-03 16:34:21","2","2020-07-03 16:34:21","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:34:21","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":["8256","DEPOSIT",null,"PAID","2020-07-03 16:34:21",0,"2","2020-07-03 16:34:21","2","2020-07-03 16:34:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:34:21","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":["8256","INVOICE","8613","PAID","2020-07-03 16:34:21",1704,"2","2020-07-03 16:34:21","2","2020-07-03 16:34:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:37:05","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=2&filter2=1539&filter3=undefined&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1204","master_room_id":"141","room_code":"B01-014"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1135,"customer_code":"C181135","identity_type":"PERSONAL","identity_id":"K123974(0)","title":"Ms","lastname":"YIP","firstname":"Kwan Kuen","companyname":"","email":null,"tel":"94232316","address":"\u9999\u6e2f\u4ed4\u9806\u8c50\u6a13320\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1043.0","renew_rent_month":"3","renew_warehousing_date":"2020-06-25","renew_room_key":"0012414168 189,27864","renew_remark":"3 months contract. Storage rental paid by bank transfer on April 5, 2020. Storage deposit $2196 transferred from agreement A12-CT207253 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207567, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"135","room_code":"C11","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1098,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1098,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-25","rent_from":"2020-06-25","rent_to":"2020-07-24","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Jul 02, 2020. Storage deposit $2196 transferred from agreement A12-CT207567 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1098,"final_order_total":1098,"location_id":"1","branch_id":"1","company_id":"1","room_key":"0012414168 189,27864","order_product":[],"pass":true}},"first_order_id":"4637","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> C11 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\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":"1098.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:37:05","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",1135,"NEW","A12-CT208285",1098,1098,0,0,"1","1",1098,1098,1098,"2020-07-03 16:37:05","0",null,null,null,"2020-06-25","2020-07-24","1 month contract. Storage rental paid by bank transfer on Jul 02, 2020. Storage deposit $2196 transferred from agreement A12-CT207567 to this agreement.","2020-06-25","16",0,null,0,"0","2","2020-07-03 16:37:04","2","2020-07-03 16:37:04","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012414168 189,27864","C181135","PERSONAL","Ms","YrK7xYiPDtkMYU6D45Tr8Q==","\/H+5BvS7nufXH+HNSFtUFw==","","Gh1quo4AOq3NZ7nCRE3ecUTd3FoLVRReHyYdoGum+Hc=","qslH87NUGX5cGJ3PfAXAxw==",null,"Fa0VudXty0a8wbaMZfW3wg==",null,1,"4637"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:37:05","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":["8285","135","1098.0","1098.00","2","2020-07-03 16:37:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:37:05","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-06-25","2020-07-24","135"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-03 16:37:05","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":["8285",1135,"SETTLED","A12-I208614","2020-07-03 16:37:04","2020-06-25","2","2020-07-03 16:37:04","2","2020-07-03 16:37:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:37:05","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":["8614","RENT","\u9810\u7e73\u79df\u91d1",1,1098,"MO","1",1098,"2","2020-07-03 16:37:04","2","2020-07-03 16:37:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:37:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1098,0,"8614"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-03 16:37:05","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":[1135,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208257","2020-07-03 16:37:04",1098,"2","2020-07-03 16:37:04","2","2020-07-03 16:37:04","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:37:05","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":["8257","DEPOSIT",null,"PAID","2020-07-03 16:37:04",0,"2","2020-07-03 16:37:04","2","2020-07-03 16:37:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:37:05","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":["8257","INVOICE","8614","PAID","2020-07-03 16:37:04",1098,"2","2020-07-03 16:37:04","2","2020-07-03 16:37:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:41:47","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:43:09","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":"type=INVOICE&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":887,"customer_code":"C180887","identity_type":"PERSONAL","identity_id":"D700367(7)","title":"Ms","lastname":"Au","firstname":"Tsz Hing","companyname":"","email":null,"tel":"94250615","address":"Flat D, 10\/F, Tower 1, Pokfulam Gardens, Pok Fu Lam, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1945.0","renew_rent_month":"6","renew_warehousing_date":"2020-07-07","renew_room_key":"0005795938","renew_remark":"6 months contract. Storage rental paid by cheque on Jan 03,2020. Storage deposit transferred from agreement A05-CT195373 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT206837, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"118","order_discount":[{"master_room_discount_id":"259","master_room_id":"118","discount_type":"%","price":"2161.00","disocunted_price":"1944.90","discount":"10.00","monthly_deduct":216.1,"room_id":"1169","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1169","room_code":"A05-167","retail_price":"2161.0","discounted_price":1944.9,"location_id":"4"}],"roughly_size":"28","total_retail_price":2161,"total_discounted_price":1945,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":11670,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-07","rent_from":"2020-07-07","rent_to":"2021-01-06","delivery_service":"0","remark":"6 months contract. Storage rental paid by cheque on July 03,2020. Storage deposit transferred from agreement A05-CT206837 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":11670,"final_order_total":11670,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0005795938","order_product":[],"pass":true}},"first_order_id":"4072","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-167 <\/td>\r\n\t\t\t\t\t 4X7X7 <\/td>\r\n\t\t\t\t\t $2161.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":"28","total_discounted_price":"1945.0","deposit":"0","total_retail_price":"2161.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:43:09","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",887,"NEW","A05-CT208286",2161,1945,0,0,"6","6",11670,11670,11670,"2020-07-03 16:43:09","0",null,null,null,"2020-07-07","2021-01-06","6 months contract. Storage rental paid by cheque on July 03,2020. Storage deposit transferred from agreement A05-CT206837 to this agreement.\r\n","2020-07-07","28",0,null,0,"0","2","2020-07-03 16:43:09","2","2020-07-03 16:43:09","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"0005795938","C180887","PERSONAL","Ms","+Ro13lrbS8sZMstQwA98LA==","egeOlBPCZ2i\/hzcvvQMisg==","","T\/fbduJ\/rmHt7UF36XgQJYoLAPHdCIizhkVYYBKB3TQNISxYGhmm5t6dq0KFShH6fZejJVq+\/gx0bWvzc6Cukw==","gn5ZcXDJ7z0z2luN7xK3MQ==",null,"jBNzki5Xwpnx++BgldB2OA==",null,1,"4072"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:43:09","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":["8286","259","118","1169","%","10.00",216.1,"2","2020-07-03 16:43:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:43:09","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":["8286","1169","2161.0",1944.9,"2","2020-07-03 16:43:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:43:09","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-07-07","2021-01-06","1169"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-03 16:43:09","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":["8286",887,"SETTLED","A05-I208615","2020-07-03 16:43:09","2020-07-07","2","2020-07-03 16:43:09","2","2020-07-03 16:43:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:43:09","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":["8615","RENT","\u9810\u7e73\u79df\u91d1",1,1945,"MO","1",1945,"2","2020-07-03 16:43:09","2","2020-07-03 16:43:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:43:09","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":["8615","RENT","\u9810\u7e73\u79df\u91d1",2,1945,"MO","1",1945,"2","2020-07-03 16:43:09","2","2020-07-03 16:43:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:43:09","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":["8615","RENT","\u9810\u7e73\u79df\u91d1",3,1945,"MO","1",1945,"2","2020-07-03 16:43:09","2","2020-07-03 16:43:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:43:09","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":["8615","RENT","\u9810\u7e73\u79df\u91d1",4,1945,"MO","1",1945,"2","2020-07-03 16:43:09","2","2020-07-03 16:43:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:43:09","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":["8615","RENT","\u9810\u7e73\u79df\u91d1",5,1945,"MO","1",1945,"2","2020-07-03 16:43:09","2","2020-07-03 16:43:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:43:09","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":["8615","RENT","\u9810\u7e73\u79df\u91d1",6,1945,"MO","1",1945,"2","2020-07-03 16:43:09","2","2020-07-03 16:43:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:43:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11670,0,"8615"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-03 16:43:09","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":[887,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P208258","2020-07-03 16:43:09",11670,"2","2020-07-03 16:43:09","2","2020-07-03 16:43:09","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:43:09","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":["8258","DEPOSIT",null,"PAID","2020-07-03 16:43:09",0,"2","2020-07-03 16:43:09","2","2020-07-03 16:43:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:43:09","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":["8258","INVOICE","8615","PAID","2020-07-03 16:43:09",11670,"2","2020-07-03 16:43:09","2","2020-07-03 16:43:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:44:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:45:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:45:44","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","076,39330","13 month contract. Special offer, one month free. Storage rental paid by EPS on July 3, 2020. Storage Deposit transferred from A16-CT195175 to this agreement.\r\n","2020-07-03 16:45:44","2","cxr02xsD1tXvJ4ihJHZKWw==","NVnq23ari72NYKD\/5D2OYg==","20RbPuIpxMu0LPupZA6rMA==","o40Xhn1WGgB7CfRgrDvf586vOpIyARt0II9x4rpniSte9FZgBzKz3GtzKWeZHjd9uYQz+SzCLxQL\/C8uu2Ry3A==",8280]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:50:09","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":"type=INVOICE","_payment_type":"INVOICE","floor_plan_rent_room":[],"warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"D505014(7)","title":"Ms","lastname":"Ng","firstname":"Sau Fong","companyname":"","email":"","tel":"62882524","address":"Flat 3101, Tsz On House, Yue On Court, Apleichau, Hong Kong","pass":true,"customer_id":"1288","customer_code":"C191288","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1686","room_code":"A16-195","retail_price":"1857.0","discounted_price":"1857.00","location_id":"7"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1672,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":20064,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1672.00","warehousing_date":"2020-07-09","rent_from":"2020-07-09","rent_to":"2021-08-08","delivery_service":"0","remark":"13 months contract. Special renewal offer the 13th month free. Storage rental paid by EPS on Jul 03,2020. Storage deposit transferred from agreement A16-CT195175 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":1672,"order_total":21736,"final_order_total":20064,"location_id":"7","branch_id":"1","company_id":"1","room_key":"076,39330","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n\n \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> A16-195 <\/td>\n\t\t\t\t\t 4X6X7 <\/td>\n\t\t\t\t\t $1857.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>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"24","total_discounted_price":"1672.00","deposit":"0.00","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:50:10","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","1288","NEW","A16-CT208287",1857,1672,0,0,"13","13",20064,21736,20064,"2020-07-03 16:50:10","0",null,null,null,"2020-07-09","2021-08-08","13 months contract. Special renewal offer the 13th month free. Storage rental paid by EPS on Jul 03,2020. Storage deposit transferred from agreement A16-CT195175 to this agreement.","2020-07-09","24",0,null,1672,"1672.00","2","2020-07-03 16:50:09","2","2020-07-03 16:50:09","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"076,39330","C191288","PERSONAL","Ms","NVnq23ari72NYKD\/5D2OYg==","cxr02xsD1tXvJ4ihJHZKWw==","","o40Xhn1WGgB7CfRgrDvf586vOpIyARt0II9x4rpniSte9FZgBzKz3GtzKWeZHjd9uYQz+SzCLxQL\/C8uu2Ry3A==","20RbPuIpxMu0LPupZA6rMA==",null,"Wbfxu7AKmCVDLUjZhoTtjw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:50:10","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":["8287","1686","1857.0","1857.00","2","2020-07-03 16:50:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:50:10","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-07-09","2021-08-08","1686"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-03 16:50:10","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":["8287","1288","SETTLED","A16-I208616","2020-07-03 16:50:09","2020-07-09","2","2020-07-03 16:50:09","2","2020-07-03 16:50:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:50:10","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":["8616","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1672,"MO","1",1672,"2","2020-07-03 16:50:09","2","2020-07-03 16:50:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:50:10","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":["8616","RENT","\u9810\u7e73\u79df\u91d1",3,1672,"MO","1",1672,"2","2020-07-03 16:50:09","2","2020-07-03 16:50:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:50:10","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":["8616","RENT","\u9810\u7e73\u79df\u91d1",4,1672,"MO","1",1672,"2","2020-07-03 16:50:09","2","2020-07-03 16:50:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:50:10","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":["8616","RENT","\u9810\u7e73\u79df\u91d1",5,1672,"MO","1",1672,"2","2020-07-03 16:50:09","2","2020-07-03 16:50:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:50:10","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":["8616","RENT","\u9810\u7e73\u79df\u91d1",6,1672,"MO","1",1672,"2","2020-07-03 16:50:09","2","2020-07-03 16:50:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:50:10","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":["8616","RENT","\u9810\u7e73\u79df\u91d1",7,1672,"MO","1",1672,"2","2020-07-03 16:50:09","2","2020-07-03 16:50:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:50:10","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":["8616","RENT","\u9810\u7e73\u79df\u91d1",8,1672,"MO","1",1672,"2","2020-07-03 16:50:09","2","2020-07-03 16:50:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:50:10","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":["8616","RENT","\u9810\u7e73\u79df\u91d1",9,1672,"MO","1",1672,"2","2020-07-03 16:50:09","2","2020-07-03 16:50:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:50:10","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":["8616","RENT","\u9810\u7e73\u79df\u91d1",10,1672,"MO","1",1672,"2","2020-07-03 16:50:09","2","2020-07-03 16:50:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:50:10","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":["8616","RENT","\u9810\u7e73\u79df\u91d1",11,1672,"MO","1",1672,"2","2020-07-03 16:50:09","2","2020-07-03 16:50:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:50:10","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":["8616","RENT","\u9810\u7e73\u79df\u91d1",12,1672,"MO","1",1672,"2","2020-07-03 16:50:09","2","2020-07-03 16:50:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:50:10","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":["8616","RENT","\u9810\u7e73\u79df\u91d1",13,1672,"MO","1",1672,"2","2020-07-03 16:50:09","2","2020-07-03 16:50:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:50:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[20064,0,"8616"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-03 16:50:10","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":["1288","NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P208259","2020-07-03 16:50:09",20064,"2","2020-07-03 16:50:09","2","2020-07-03 16:50:09","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:50:10","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":["8259","DEPOSIT",null,"PAID","2020-07-03 16:50:09",0,"2","2020-07-03 16:50:09","2","2020-07-03 16:50:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 16:50:10","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":["8259","INVOICE","8616","PAID","2020-07-03 16:50:09",20064,"2","2020-07-03 16:50:09","2","2020-07-03 16:50:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 17:56:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 18:15:04","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":["VOID","","13 months contract. Special offer the 13th month free and 50% off for the first 3 months. Storage rental and deposit will pay by bank transfer.","2020-07-03 18:15:04","2","UoUJou5X7pavudwgDyvCJA==","ZoBN66ljb8LQgHh4BqVBDg==","nOA7YGE9szbZ5hT5PXEbXw==","w\/2dl6ITSYSDFlV5c5+Bgw==","k9G75b1uy\/8wi8mVvzSJ8t1xo2vv4QwjDIlU\/5IQXU2PX\/DgJXSHUoudpIbbHNJi",8173]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-03 19:10:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****