\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-105 <\/td>\n\t\t\t\t\t	4X4X7 <\/td>\n\t\t\t\t\t	$1290.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":"16","total_discounted_price":"1290.00","deposit":"2580.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 13:17:34","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":["C201511","PERSONAL","Mr","\/WXUeEjAILPyqoia1xuz2w==","8BEgNhGpCR8jGkzUtrIcXg==","","\/dbag0ZQDx+X2+3Ryg\/XlA==",null,"hI6IrHjcy5pLAjEBRvfJ49TZ1mC\/a0Z4rNZTYpJrhkn30OZAw5VTrmRYldiiiKp\/","K3xNwsT+BzDMGMVFCcNZow==",null,null,"Y8TqiF8mGLFsYkfSzKtW\/A==","2","2020-02-17 13:17:32","2","2020-02-17 13:17:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 13:17:34","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",1511,"NEW","A16-CT207202",1290,1290,2580,0,"3","3",4515,6450,4515,"2020-02-17 13:17:34","0",null,null,null,"2020-02-24","2020-05-23","3 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit paid by EPS on Feb 17,2020. Smart card and padlock provided on Feb 17,2020.","2020-02-24","16",0,null,1935,"1935.00","2","2020-02-17 13:17:32","2","2020-02-17 13:17:32","EPS","","","","EPS","","","",null,0,"189,29023","C201511","PERSONAL","Mr","\/WXUeEjAILPyqoia1xuz2w==","8BEgNhGpCR8jGkzUtrIcXg==","","hI6IrHjcy5pLAjEBRvfJ49TZ1mC\/a0Z4rNZTYpJrhkn30OZAw5VTrmRYldiiiKp\/","\/dbag0ZQDx+X2+3Ryg\/XlA==",null,"K3xNwsT+BzDMGMVFCcNZow==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 13:17:34","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":["7202","1596","1290.0","1290.00","2","2020-02-17 13:17:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 13:17:34","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-02-24","2020-05-23","1596"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-17 13:17:34","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":["7202","A16-D205287","PAID",2580,0,"2020-05-23","2020-02-17 13:17:32","2020-02-17 13:17:32","2","2020-02-17 13:17:32","2","2020-02-17 13:17:32",1511]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 13:17:34","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":["7202",1511,"SETTLED","A16-I207530","2020-02-17 13:17:32","2020-02-24","2","2020-02-17 13:17:32","2","2020-02-17 13:17:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 13:17:34","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":["7530","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-02-17 13:17:32","2","2020-02-17 13:17:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 13:17:34","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":["7530","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,645,"MO","1",645,"2","2020-02-17 13:17:32","2","2020-02-17 13:17:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 13:17:34","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":["7530","RENT","\u9810\u7e73\u79df\u91d1",3,1290,"MO","1",1290,"2","2020-02-17 13:17:32","2","2020-02-17 13:17:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 13:17:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1935,0,"7530"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-17 13:17:34","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":[1511,"EPS","","","","EPS","","","","PAID","P207178","2020-02-17 13:17:32",4515,"2","2020-02-17 13:17:32","2","2020-02-17 13:17:32","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 13:17:34","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":["7178","DEPOSIT","5287","PAID","2020-02-17 13:17:32",2580,"2","2020-02-17 13:17:32","2","2020-02-17 13:17:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 13:17:34","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":["7178","INVOICE","7530","PAID","2020-02-17 13:17:32",1935,"2","2020-02-17 13:17:32","2","2020-02-17 13:17:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 13:30:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 13:53:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 14:02:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 14:21:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 14:38:48","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&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":18,"customer_code":"C150018","identity_type":"PERSONAL","identity_id":"D191657(3)","title":"Ms","lastname":"Wong","firstname":"Hoi Chi","companyname":"","email":null,"tel":"98855112","address":"\u77f3\u6392\u7063\u78a7\u5c71\u6a133\u6a13303\u5ba4","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1860.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-18","renew_room_key":"055,34812","renew_remark":"1 month contract. Storage rental paid by cheque on January 18, 2020. Storage deposit transferred from agreement A12-CT196736 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT206998, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"13","order_discount":[],"order_room":[{"room_id":"2","room_code":"A02","retail_price":"2058.0","discounted_price":"2058.00","location_id":"1"}],"roughly_size":"28","total_retail_price":2058,"total_discounted_price":1860,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1860,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-18","rent_from":"2020-02-18","rent_to":"2020-03-17","delivery_service":"0","remark":"1 month contract. Storage rental paid by cheque on February 17, 2020. Storage deposit transferred from agreement A12-CT206998 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":1860,"final_order_total":1860,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,34812","order_product":[],"pass":true}},"first_order_id":"4773","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> A02 <\/td>\r\n\t\t\t\t\t 4X7X8 <\/td>\r\n\t\t\t\t\t $2058.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"28","total_discounted_price":"1860.0","deposit":"0","total_retail_price":"2058.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 14:38:49","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",18,"NEW","A12-CT207203",2058,1860,0,0,"1","1",1860,1860,1860,"2020-02-17 14:38:49","0",null,null,null,"2020-02-18","2020-03-17","1 month contract. Storage rental paid by cheque on February 17, 2020. Storage deposit transferred from agreement A12-CT206998 to this agreement.\r\n","2020-02-18","28",0,null,0,"0","2","2020-02-17 14:38:48","2","2020-02-17 14:38:48","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"055,34812","C150018","PERSONAL","Ms","Wf\/obv2attkTYKMJ\/vWT9A==","hULSwM2MvFtpeV9\/z+er8Q==","","\/W3QUjKWE3CC73zLiOhBi2cNYO8UXtn0ViOT+SD0I4Y=","ErI4QcMFcZ94m4Lf9PgLBg==",null,"1f1y9zugJv2nxoT+IuBxXw==",null,1,"4773"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 14:38:49","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":["7203","2","2058.0","2058.00","2","2020-02-17 14:38:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 14:38:49","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-02-18","2020-03-17","2"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-17 14:38:49","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":["7203",18,"SETTLED","A12-I207531","2020-02-17 14:38:48","2020-02-18","2","2020-02-17 14:38:48","2","2020-02-17 14:38:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 14:38:49","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":["7531","RENT","\u9810\u7e73\u79df\u91d1",1,1860,"MO","1",1860,"2","2020-02-17 14:38:48","2","2020-02-17 14:38:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 14:38:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1860,0,"7531"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-17 14:38:49","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":[18,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207179","2020-02-17 14:38:48",1860,"2","2020-02-17 14:38:48","2","2020-02-17 14:38:48","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 14:38:49","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":["7179","DEPOSIT",null,"PAID","2020-02-17 14:38:48",0,"2","2020-02-17 14:38:48","2","2020-02-17 14:38:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 14:38:49","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":["7179","INVOICE","7531","PAID","2020-02-17 14:38:48",1860,"2","2020-02-17 14:38:48","2","2020-02-17 14:38:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 14:40:28","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&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":18,"customer_code":"C150018","identity_type":"PERSONAL","identity_id":"D191657(3)","title":"Ms","lastname":"Wong","firstname":"Hoi Chi","companyname":"","email":null,"tel":"98855112","address":"\u77f3\u6392\u7063\u78a7\u5c71\u6a133\u6a13303\u5ba4","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-02","renew_room_key":"053,34812","renew_remark":"1 month contract. Storage rental paid by cheque on January 18, 2020. Storage deposit transferred from agreement A12-CT196737 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT206997, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"141","room_code":"C17","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-02","rent_from":"2020-02-02","rent_to":"2020-03-01","delivery_service":"0","remark":"1 month contract. Storage rental paid by cheque on February 17, 2020. Storage deposit transferred from agreement A12-CT206997 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"053,34812","order_product":[],"pass":true}},"first_order_id":"4773","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> C17 <\/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":"1038.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 14:40:29","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",18,"NEW","A12-CT207204",1098,1038,0,0,"1","1",1038,1038,1038,"2020-02-17 14:40:29","0",null,null,null,"2020-02-02","2020-03-01","1 month contract. Storage rental paid by cheque on February 17, 2020. Storage deposit transferred from agreement A12-CT206997 to this agreement.","2020-02-02","16",0,null,0,"0","2","2020-02-17 14:40:28","2","2020-02-17 14:40:28","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"053,34812","C150018","PERSONAL","Ms","Wf\/obv2attkTYKMJ\/vWT9A==","hULSwM2MvFtpeV9\/z+er8Q==","","\/W3QUjKWE3CC73zLiOhBi2cNYO8UXtn0ViOT+SD0I4Y=","ErI4QcMFcZ94m4Lf9PgLBg==",null,"1f1y9zugJv2nxoT+IuBxXw==",null,1,"4773"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 14:40:29","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":["7204","141","1098.0","1098.00","2","2020-02-17 14:40:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 14:40:29","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-02-02","2020-03-01","141"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-17 14:40:29","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":["7204",18,"SETTLED","A12-I207532","2020-02-17 14:40:28","2020-02-02","2","2020-02-17 14:40:28","2","2020-02-17 14:40:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 14:40:29","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":["7532","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-02-17 14:40:28","2","2020-02-17 14:40:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 14:40:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"7532"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-17 14:40:29","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":[18,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207180","2020-02-17 14:40:28",1038,"2","2020-02-17 14:40:28","2","2020-02-17 14:40:28","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 14:40:29","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":["7180","DEPOSIT",null,"PAID","2020-02-17 14:40:28",0,"2","2020-02-17 14:40:28","2","2020-02-17 14:40:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 14:40:29","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":["7180","INVOICE","7532","PAID","2020-02-17 14:40:28",1038,"2","2020-02-17 14:40:28","2","2020-02-17 14:40:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 15:24:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 15:58:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 16:05:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 16:13:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 16:16: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","floor_plan_rent_room":[{"room_id":"398","master_room_id":"6","room_code":"H08"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\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> H08 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.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","warehousing":{"1":{"new_customer":"0","identity_type":"BUSINESS","identity_id":"68513895","title":"Ms","lastname":"NG","firstname":"Hau Yee Natalie","companyname":"Kiddie Town Limited","email":"kiddletownhk@gmail.com","tel":"53006299","address":"Rm 07, 24\/F, Block A, Apleichou Centre, 138 Lee Chi Rd, Apleichou, HK","pass":true,"customer_id":"1389","customer_code":"C191389","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"469","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"949.00","discount":"4.91","monthly_deduct":49.0018,"room_id":"398","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"398","room_code":"H08","retail_price":"998.0","discounted_price":949,"location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":949,"deposit":1996,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":4843,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-17","rent_from":"2020-02-17","rent_to":"2020-05-16","delivery_service":"0","remark":"3 months contract. Storage rental and deposit paid by EPS on Feb17,2020.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":0,"order_total":4843,"final_order_total":4843,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190,1654,190,40496","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"949.00","deposit":"1996.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 16:16: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` = ?","parameters":["1","1","1","1389","NEW","A12-CT207205",998,949,1996,0,"3","3",4843,4843,4843,"2020-02-17 16:16:44","0",null,null,null,"2020-02-17","2020-05-16","3 months contract. Storage rental and deposit paid by EPS on Feb17,2020.","2020-02-17","12",0,null,0,"0","2","2020-02-17 16:16:43","2","2020-02-17 16:16:43","EPS","","","","EPS","","","",null,0,"190,1654,190,40496","C191389","BUSINESS","Ms","bzI2ymAqRhND+s7nIvjOTg==","yXKLXTtbNpECaRVTZxF\/Rw==","Kiddie Town Limited","ZvOTqlyKP3iMCYADHRci\/TH7o+43ncMcTiy214AdKA2KuzQoRAAlnkfxgcbN\/VAXfKSYNyO3LdkuzPpV5m5laO9b49UEsrE\/1XKYPAOZgbk=","Og6U0dK51G6\/ReO9I+LIoA==","6ds6OIk0tVxyWwUoIPkGB5zxddyIXIk5gYhajRbuNRc=",null,"\/YC80JTYlLeaKfDYCHetBA=="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 16:16:44","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":["7205","469","6","398","%","4.91",49.0018,"2","2020-02-17 16:16:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 16:16: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":["7205","398","998.0",949,"2","2020-02-17 16:16:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 16:16: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-02-17","2020-05-16","398"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-17 16:16:44","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":["7205","A12-D205288","PAID",1996,0,"2020-05-16","2020-02-17 16:16:43","2020-02-17 16:16:43","2","2020-02-17 16:16:43","2","2020-02-17 16:16:43","1389"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 16:16: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":["7205","1389","SETTLED","A12-I207533","2020-02-17 16:16:43","2020-02-17","2","2020-02-17 16:16:43","2","2020-02-17 16:16:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 16:16: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":["7533","RENT","\u9810\u7e73\u79df\u91d1",1,949,"MO","1",949,"2","2020-02-17 16:16:43","2","2020-02-17 16:16:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 16:16: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":["7533","RENT","\u9810\u7e73\u79df\u91d1",2,949,"MO","1",949,"2","2020-02-17 16:16:43","2","2020-02-17 16:16:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 16:16: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":["7533","RENT","\u9810\u7e73\u79df\u91d1",3,949,"MO","1",949,"2","2020-02-17 16:16:43","2","2020-02-17 16:16:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 16:16:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2847,0,"7533"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-17 16:16: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":["1389","EPS","","","","EPS","","","","PAID","P207181","2020-02-17 16:16:43",4843,"2","2020-02-17 16:16:43","2","2020-02-17 16:16:43","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 16:16: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":["7181","DEPOSIT","5288","PAID","2020-02-17 16:16:43",1996,"2","2020-02-17 16:16:43","2","2020-02-17 16:16:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 16:16: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":["7181","INVOICE","7533","PAID","2020-02-17 16:16:43",2847,"2","2020-02-17 16:16:43","2","2020-02-17 16:16:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 16:24:13","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ?, `customer_companyname` = ? where id = ?","parameters":["VOID","190,1654,190,40496","3 months contract. Storage rental and deposit paid by EPS on Feb17,2020.","2020-02-17 16:24:13","2","yXKLXTtbNpECaRVTZxF\/Rw==","bzI2ymAqRhND+s7nIvjOTg==","6ds6OIk0tVxyWwUoIPkGB5zxddyIXIk5gYhajRbuNRc=","Og6U0dK51G6\/ReO9I+LIoA==","ZvOTqlyKP3iMCYADHRci\/TH7o+43ncMcTiy214AdKA2KuzQoRAAlnkfxgcbN\/VAXfKSYNyO3LdkuzPpV5m5laO9b49UEsrE\/1XKYPAOZgbk=","Kiddie Town Limited",7205]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 16:25:50","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"398","master_room_id":"6","room_code":"H08"}],"index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\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> H08 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.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","warehousing":{"1":{"new_customer":"0","identity_type":"BUSINESS","identity_id":"68513895","title":"Ms","lastname":"NG","firstname":"Hau Yee Natalie","companyname":"Kiddie Town Limited","email":"kiddletownhk@gmail.com","tel":"53006299","address":"Rm 07, 24\/F, Block A, Apleichou Centre, 138 Lee Chi Rd, Apleichou, HK","pass":true,"customer_id":"1389","customer_code":"C191389","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"469","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"949.00","discount":"4.91","monthly_deduct":49.0018,"room_id":"398","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"398","room_code":"H08","retail_price":"998.0","discounted_price":949,"location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":949,"deposit":1996,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3421,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1422.00","warehousing_date":"2020-02-17","rent_from":"2020-02-17","rent_to":"2020-05-16","delivery_service":"0","remark":"3 months contract. Special offer 50% off. Storage rental and deposit paid by cash on Feb 17,2020. Padlock provided on Feb 17,2020.","paymethod":"CASH","paymethod2":"CASH","discount_deduct":1422,"order_total":4843,"final_order_total":3421,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190,1654,190,40496","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"949.00","deposit":"1996.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 16:25:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1","1389","NEW","A12-CT207206",998,949,1996,0,"3","3",3421,4843,3421,"2020-02-17 16:25:50","0",null,null,null,"2020-02-17","2020-05-16","3 months contract. Special offer 50% off. Storage rental and deposit paid by cash on Feb 17,2020. Padlock provided on Feb 17,2020.","2020-02-17","12",0,null,1422,"1422.00","2","2020-02-17 16:25:50","2","2020-02-17 16:25:50","CASH","","","","CASH","","","",null,0,"190,1654,190,40496","C191389","BUSINESS","Ms","bzI2ymAqRhND+s7nIvjOTg==","yXKLXTtbNpECaRVTZxF\/Rw==","Kiddie Town Limited","ZvOTqlyKP3iMCYADHRci\/TH7o+43ncMcTiy214AdKA2KuzQoRAAlnkfxgcbN\/VAXfKSYNyO3LdkuzPpV5m5laO9b49UEsrE\/1XKYPAOZgbk=","Og6U0dK51G6\/ReO9I+LIoA==","6ds6OIk0tVxyWwUoIPkGB5zxddyIXIk5gYhajRbuNRc=",null,"\/YC80JTYlLeaKfDYCHetBA=="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 16:25:50","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":["7206","469","6","398","%","4.91",49.0018,"2","2020-02-17 16:25:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 16:25:50","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":["7206","398","998.0",949,"2","2020-02-17 16:25:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 16:25:50","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-02-17","2020-05-16","398"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-17 16:25:50","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":["7206","A12-D205289","PAID",1996,0,"2020-05-16","2020-02-17 16:25:50","2020-02-17 16:25:50","2","2020-02-17 16:25:50","2","2020-02-17 16:25:50","1389"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 16:25:50","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":["7206","1389","SETTLED","A12-I207534","2020-02-17 16:25:50","2020-02-17","2","2020-02-17 16:25:50","2","2020-02-17 16:25:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 16:25:50","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":["7534","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-02-17 16:25:50","2","2020-02-17 16:25:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 16:25:50","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":["7534","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,476,"MO","1",476,"2","2020-02-17 16:25:50","2","2020-02-17 16:25:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 16:25:50","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":["7534","RENT","\u9810\u7e73\u79df\u91d1",3,949,"MO","1",949,"2","2020-02-17 16:25:50","2","2020-02-17 16:25:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 16:25:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1425,0,"7534"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-17 16:25:50","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":["1389","CASH","","","","CASH","","","","PAID","P207182","2020-02-17 16:25:50",3421,"2","2020-02-17 16:25:50","2","2020-02-17 16:25:50","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 16:25:50","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":["7182","DEPOSIT","5289","PAID","2020-02-17 16:25:50",1996,"2","2020-02-17 16:25:50","2","2020-02-17 16:25:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 16:25:50","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":["7182","INVOICE","7534","PAID","2020-02-17 16:25:50",1425,"2","2020-02-17 16:25:50","2","2020-02-17 16:25:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:00:10","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":"","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1192,"customer_code":"C191192","identity_type":"PERSONAL","identity_id":"D627437(5)","title":"Ms","lastname":"Leung","firstname":"Suk Mun","companyname":"","email":"sukmunchan@yahoo.com.hk","tel":"98361723","address":"29\/F, Flate, Blk 6, Harmony Garden, Siu Sai Wan, HK","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"800.0","renew_rent_month":"6","renew_warehousing_date":"2020-02-16","renew_room_key":"0012522931","renew_remark":"6 months contract. Storage rental paid by cheque on August 11, 2019. Storage deposit $1816 transferred from agreement B01-CT194288 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT195711, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"136","order_discount":[],"order_room":[{"room_id":"1256","room_code":"B01-066","retail_price":"908.0","discounted_price":"908.00","location_id":"5"}],"roughly_size":"12","total_retail_price":908,"total_discounted_price":800,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":4800,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-16","rent_from":"2020-02-16","rent_to":"2020-08-15","delivery_service":"0","remark":"6 months contract. Storage rental paid by cheque on February 17, 2020. Storage deposit $1816 transferred from agreement B01-CT195711 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":4800,"final_order_total":4800,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0012522931","order_product":[],"pass":true}},"first_order_id":"4288","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> B01-066 <\/td>\r\n\t\t\t\t\t 3X4X7 <\/td>\r\n\t\t\t\t\t $908.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":"800.0","deposit":"0","total_retail_price":"908.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:00: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","2","5",1192,"NEW","B01-CT207207",908,800,0,0,"6","6",4800,4800,4800,"2020-02-17 17:00:10","0",null,null,null,"2020-02-16","2020-08-15","6 months contract. Storage rental paid by cheque on February 17, 2020. Storage deposit $1816 transferred from agreement B01-CT195711 to this agreement. ","2020-02-16","12",0,null,0,"0","2","2020-02-17 17:00:10","2","2020-02-17 17:00:10","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"0012522931","C191192","PERSONAL","Ms","tFW+XmSHIrylglqHdwZMIg==","xEf2h2aoyRQ71ZVgBH+9WQ==","","1oqxLmCeRZYqCzDXOd1FX6sqjvRVuwwPHd7Jtz0pT4EQ2Z7hFRIQGIuCSibSUdQZrJDXTH4mtGFCqa8t7aqYtg==","9hBf9k5LDhtQiFA3jh7o1Q==","5VDdNa1OrE10yLvQTZNpaECcf2Wlvstb1cLzlFFC+lQ=","dBrql0n33OEAzkQUQn8Y9w==",null,1,"4288"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:00: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":["7207","1256","908.0","908.00","2","2020-02-17 17:00:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:00: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-02-16","2020-08-15","1256"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-17 17:00: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":["7207",1192,"SETTLED","B01-I207535","2020-02-17 17:00:10","2020-02-16","2","2020-02-17 17:00:10","2","2020-02-17 17:00:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:00: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":["7535","RENT","\u9810\u7e73\u79df\u91d1",1,800,"MO","1",800,"2","2020-02-17 17:00:10","2","2020-02-17 17:00:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:00: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":["7535","RENT","\u9810\u7e73\u79df\u91d1",2,800,"MO","1",800,"2","2020-02-17 17:00:10","2","2020-02-17 17:00:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:00: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":["7535","RENT","\u9810\u7e73\u79df\u91d1",3,800,"MO","1",800,"2","2020-02-17 17:00:10","2","2020-02-17 17:00:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:00: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":["7535","RENT","\u9810\u7e73\u79df\u91d1",4,800,"MO","1",800,"2","2020-02-17 17:00:10","2","2020-02-17 17:00:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:00: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":["7535","RENT","\u9810\u7e73\u79df\u91d1",5,800,"MO","1",800,"2","2020-02-17 17:00:10","2","2020-02-17 17:00:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:00: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":["7535","RENT","\u9810\u7e73\u79df\u91d1",6,800,"MO","1",800,"2","2020-02-17 17:00:10","2","2020-02-17 17:00:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:00:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4800,0,"7535"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-17 17:00: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":[1192,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207183","2020-02-17 17:00:10",4800,"2","2020-02-17 17:00:10","2","2020-02-17 17:00:10","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:00: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":["7183","DEPOSIT",null,"PAID","2020-02-17 17:00:10",0,"2","2020-02-17 17:00:10","2","2020-02-17 17:00:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:00: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":["7183","INVOICE","7535","PAID","2020-02-17 17:00:10",4800,"2","2020-02-17 17:00:10","2","2020-02-17 17:00:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:27:18","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:46:45","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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":209,"customer_code":"C160209","identity_type":"PERSONAL","identity_id":"D705150(7)","title":"Ms","lastname":"Lam","firstname":"Lai Ping","companyname":"","email":null,"tel":"94086527","address":"18D Pelene Mansion, 5 Yue Ko St., Aberdeen, HK.","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1139.0","renew_rent_month":"6","renew_warehousing_date":"2020-02-24","renew_room_key":"056,12862","renew_remark":"6 months contract. Storage rental paid by cheque on Aug 17, 2019. Storage deposit transferred from agreement A12-CT194378 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195731, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[{"master_room_discount_id":"76","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1376.00","discount":"9.95","monthly_deduct":152.036,"room_id":"58","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"58","room_code":"B06","retail_price":"1528.0","discounted_price":1376,"location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1139,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6834,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-24","rent_from":"2020-02-24","rent_to":"2020-08-23","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on February 17, 2020. Storage deposit transferred from agreement A12-CT195731 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6834,"final_order_total":6834,"location_id":"1","branch_id":"1","company_id":"1","room_key":"056,12862","order_product":[],"pass":true}},"first_order_id":"4378","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> B06 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1139.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:46:46","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",209,"NEW","A12-CT207208",1528,1139,0,0,"6","6",6834,6834,6834,"2020-02-17 17:46:46","0",null,null,null,"2020-02-24","2020-08-23","6 months contract. Storage rental paid by bank transfer on February 17, 2020. Storage deposit transferred from agreement A12-CT195731 to this agreement.\r\n","2020-02-24","20",0,null,0,"0","2","2020-02-17 17:46:45","2","2020-02-17 17:46:45","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"056,12862","C160209","PERSONAL","Ms","dlaL1UFZswmoS6GEDlxarA==","0JxYUqbNPOvgfMwVa0l0NA==","","rtXzWI5NpbdkytAJGDu\/W9n2aBcvO+foM4oeh4pERgZsPqvWbbeiEMklmvmhj\/GJ","XD\/QFo6PkWYAVrA\/Gdy5Ug==",null,"T8UE\/Ag3PhtWWIVtsD7AGA==",null,1,"4378"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:46:46","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":["7208","76","10","58","%","9.95",152.036,"2","2020-02-17 17:46:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:46:46","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":["7208","58","1528.0",1376,"2","2020-02-17 17:46:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:46:46","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-02-24","2020-08-23","58"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-17 17:46:46","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":["7208",209,"SETTLED","A12-I207536","2020-02-17 17:46:45","2020-02-24","2","2020-02-17 17:46:45","2","2020-02-17 17:46:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:46:46","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":["7536","RENT","\u9810\u7e73\u79df\u91d1",1,1139,"MO","1",1139,"2","2020-02-17 17:46:45","2","2020-02-17 17:46:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:46:46","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":["7536","RENT","\u9810\u7e73\u79df\u91d1",2,1139,"MO","1",1139,"2","2020-02-17 17:46:45","2","2020-02-17 17:46:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:46:46","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":["7536","RENT","\u9810\u7e73\u79df\u91d1",3,1139,"MO","1",1139,"2","2020-02-17 17:46:45","2","2020-02-17 17:46:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:46:46","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":["7536","RENT","\u9810\u7e73\u79df\u91d1",4,1139,"MO","1",1139,"2","2020-02-17 17:46:45","2","2020-02-17 17:46:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:46:46","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":["7536","RENT","\u9810\u7e73\u79df\u91d1",5,1139,"MO","1",1139,"2","2020-02-17 17:46:45","2","2020-02-17 17:46:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:46:46","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":["7536","RENT","\u9810\u7e73\u79df\u91d1",6,1139,"MO","1",1139,"2","2020-02-17 17:46:45","2","2020-02-17 17:46:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:46:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6834,0,"7536"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-17 17:46:46","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":[209,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207184","2020-02-17 17:46:45",6834,"2","2020-02-17 17:46:45","2","2020-02-17 17:46:45","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:46:46","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":["7184","DEPOSIT",null,"PAID","2020-02-17 17:46:45",0,"2","2020-02-17 17:46:45","2","2020-02-17 17:46:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:46:46","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":["7184","INVOICE","7536","PAID","2020-02-17 17:46:45",6834,"2","2020-02-17 17:46:45","2","2020-02-17 17:46:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:48:46","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&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1202,"customer_code":"C191202","identity_type":"PERSONAL","identity_id":"P305243(9)","title":"Mr","lastname":"LO","firstname":"TAK FU","companyname":"","email":"takfu130@yahoo.com.hk","tel":"96878889","address":"Rm 325,3\/F, Wah Lok House, Wah Fu Estate, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"6","renew_warehousing_date":"2020-02-21","renew_room_key":"191,03084","renew_remark":"6 months contract. Storage rental paid by bank transfer on August 12, 2019. Storage deposit $1196 transferred from agreement A14-CT194822 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195705, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"611","room_code":"M22","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-21","rent_from":"2020-02-21","rent_to":"2020-08-20","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on February 17, 2020. Storage deposit $1196 transferred from agreement A14-CT195705 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"2","branch_id":"1","company_id":"1","room_key":"191,03084","order_product":[],"pass":true}},"first_order_id":"4822","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> M22 <\/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":"538.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:48:46","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",1202,"NEW","A14-CT207209",598,538,0,0,"6","6",3228,3228,3228,"2020-02-17 17:48:46","0",null,null,null,"2020-02-21","2020-08-20","6 months contract. Storage rental paid by bank transfer on February 17, 2020. Storage deposit $1196 transferred from agreement A14-CT195705 to this agreement.\r\n","2020-02-21","12",0,null,0,"0","2","2020-02-17 17:48:46","2","2020-02-17 17:48:46","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"191,03084","C191202","PERSONAL","Mr","47XB6Z8T6h0NcRpALtEM6Q==","DyZn7f2tPwMiXMp09gXvdg==","","c7MAq0pm3G0TPz\/pfQGQTrf3ki4L67aqVxGZauylhCeZyQcL0tOBHU7dP+qRmWAJ","+bQTqkbYGoti2d1yLqEXuQ==","Po5TX5dgRsWPmV8peiEJnJkSrRGdymtvrm1bUQAP3p4=","wUdMS7Q3HDjiptN4pj20pQ==",null,1,"4822"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:48:46","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":["7209","611","598.0","598.00","2","2020-02-17 17:48:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:48:46","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-02-21","2020-08-20","611"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-17 17:48:46","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":["7209",1202,"SETTLED","A14-I207537","2020-02-17 17:48:46","2020-02-21","2","2020-02-17 17:48:46","2","2020-02-17 17:48:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:48:46","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":["7537","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-02-17 17:48:46","2","2020-02-17 17:48:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:48:46","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":["7537","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-02-17 17:48:46","2","2020-02-17 17:48:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:48:46","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":["7537","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-02-17 17:48:46","2","2020-02-17 17:48:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:48:46","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":["7537","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-02-17 17:48:46","2","2020-02-17 17:48:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:48:46","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":["7537","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-02-17 17:48:46","2","2020-02-17 17:48:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:48:46","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":["7537","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-02-17 17:48:46","2","2020-02-17 17:48:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:48:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"7537"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-17 17:48:46","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":[1202,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207185","2020-02-17 17:48:46",3228,"2","2020-02-17 17:48:46","2","2020-02-17 17:48:46","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:48:46","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":["7185","DEPOSIT",null,"PAID","2020-02-17 17:48:46",0,"2","2020-02-17 17:48:46","2","2020-02-17 17:48:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 17:48:46","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":["7185","INVOICE","7537","PAID","2020-02-17 17:48:46",3228,"2","2020-02-17 17:48:46","2","2020-02-17 17:48:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 18:19:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 18:32:08","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1102","master_room_id":"112","room_code":"A05-100"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\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-100(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X2.5X7 <\/td>\r\n\t\t\t\t\t $1058.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","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"Y235373(1)","title":"Ms","lastname":"SO","firstname":"Yin Ting","companyname":"","email":"","tel":"66856438","address":"Room 1118, Pik Yuen House, Shek Pai Wan Estate, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"243","master_room_id":"112","discount_type":"%","price":"1058.00","disocunted_price":"952.20","discount":"10.00","monthly_deduct":105.8,"room_id":"1102","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1102","room_code":"A05-100(\u670d\u88dd\u5009)","retail_price":"1058.0","discounted_price":952.2,"location_id":"4"}],"roughly_size":"10","total_retail_price":1058,"total_discounted_price":953,"deposit":2116,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6562,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1272.00","warehousing_date":"2020-02-23","rent_from":"2020-02-23","rent_to":"2020-08-22","delivery_service":"0","remark":"6 months contract. Special offer first 3 months 50% off. Storage rental and deposit paid by EPS on February 17, 2020. Smartcard provided on February 17, 2020.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":1272,"order_total":7834,"final_order_total":6562,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0012392301","order_product":[],"pass":true}},"roughly_size":"10","total_discounted_price":"953.00","deposit":"2116.00","total_retail_price":"1058.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 18:32:09","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":["C201512","PERSONAL","Ms","o5B8ysPNd3zF612jZ6fFEg==","mOWsGT2TzOPDdjq14yV0zw==","","jY+LZzZMok7H2BUjz4Rj8w==",null,"3RnX3g31pzUtnY3CMy1dtIJS6g5JDu1C2FnkellwKXBMGKu8KVIo+NVBz2EhXYUAJPM9GQ0SNO5E7Re\/yYYGrQ==","Tvl2gIkCITVAqm9CEabzRQ==",null,null,"cuYwN5TBvsJjI8RawB+jhg==","2","2020-02-17 18:32:08","2","2020-02-17 18:32:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 18:32: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` = ?","parameters":["1","1","4",1512,"NEW","A05-CT207210",1058,953,2116,0,"6","6",6562,7834,6562,"2020-02-17 18:32:09","0",null,null,null,"2020-02-23","2020-08-22","6 months contract. Special offer first 3 months 50% off. Storage rental and deposit paid by EPS on February 17, 2020. Smartcard provided on February 17, 2020.","2020-02-23","10",0,null,1272,"1272.00","2","2020-02-17 18:32:08","2","2020-02-17 18:32:08","EPS","","","","EPS","","","",null,0,"'0012392301","C201512","PERSONAL","Ms","o5B8ysPNd3zF612jZ6fFEg==","mOWsGT2TzOPDdjq14yV0zw==","","3RnX3g31pzUtnY3CMy1dtIJS6g5JDu1C2FnkellwKXBMGKu8KVIo+NVBz2EhXYUAJPM9GQ0SNO5E7Re\/yYYGrQ==","jY+LZzZMok7H2BUjz4Rj8w==",null,"Tvl2gIkCITVAqm9CEabzRQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 18:32: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":["7210","243","112","1102","%","10.00",105.8,"2","2020-02-17 18:32:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 18:32: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":["7210","1102","1058.0",952.2,"2","2020-02-17 18:32:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 18:32: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-02-23","2020-08-22","1102"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-17 18:32:09","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":["7210","A05-D205290","PAID",2116,0,"2020-08-22","2020-02-17 18:32:08","2020-02-17 18:32:08","2","2020-02-17 18:32:08","2","2020-02-17 18:32:08",1512]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 18:32: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":["7210",1512,"SETTLED","A05-I207538","2020-02-17 18:32:08","2020-02-23","2","2020-02-17 18:32:08","2","2020-02-17 18:32:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 18:32: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":["7538","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-02-17 18:32:08","2","2020-02-17 18:32:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 18:32: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":["7538","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,634,"MO","1",634,"2","2020-02-17 18:32:08","2","2020-02-17 18:32:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 18:32: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":["7538","RENT","\u9810\u7e73\u79df\u91d1",3,953,"MO","1",953,"2","2020-02-17 18:32:08","2","2020-02-17 18:32:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 18:32: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":["7538","RENT","\u9810\u7e73\u79df\u91d1",4,953,"MO","1",953,"2","2020-02-17 18:32:08","2","2020-02-17 18:32:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 18:32: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":["7538","RENT","\u9810\u7e73\u79df\u91d1",5,953,"MO","1",953,"2","2020-02-17 18:32:08","2","2020-02-17 18:32:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 18:32: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":["7538","RENT","\u9810\u7e73\u79df\u91d1",6,953,"MO","1",953,"2","2020-02-17 18:32:08","2","2020-02-17 18:32:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 18:32:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4446,0,"7538"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-17 18:32: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":[1512,"EPS","","","","EPS","","","","PAID","P207186","2020-02-17 18:32:08",6562,"2","2020-02-17 18:32:08","2","2020-02-17 18:32:08","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 18:32: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":["7186","DEPOSIT","5290","PAID","2020-02-17 18:32:08",2116,"2","2020-02-17 18:32:08","2","2020-02-17 18:32:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 18:32: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":["7186","INVOICE","7538","PAID","2020-02-17 18:32:08",4446,"2","2020-02-17 18:32:08","2","2020-02-17 18:32:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 18:40:02","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":"1102","master_room_id":"112","room_code":"A05-100"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":533,"customer_code":"C170533","identity_type":"PERSONAL","identity_id":"D702226(2)","title":"Mr","lastname":"Leung","firstname":"Ming Fai","companyname":"","email":"leungmingfai@hotmail.com","tel":"62805618","address":"Flat G,9\/F, Kam Fung Mansion, 171 Aberdeen Main Rd, Aberdeen ","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-18","renew_room_key":"136,58083","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 17, 2020. Storage deposit transferred from agreement A14-CT196685 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT206995, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"754","room_code":"O30","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-18","rent_from":"2020-01-18","rent_to":"2020-02-17","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on February 17, 2020. Storage deposit transferred from agreement A14-CT206995 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"2","branch_id":"1","company_id":"1","room_key":"136,58083","order_product":[],"pass":true}},"first_order_id":"4566","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> O30 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \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":"12","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 18:40:03","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",533,"NEW","A14-CT207211",998,1038,0,0,"1","1",1038,1038,1038,"2020-02-17 18:40:03","0",null,null,null,"2020-01-18","2020-02-17","1 month contract. Storage rental paid by bank transfer on February 17, 2020. Storage deposit transferred from agreement A14-CT206995 to this agreement.\r\n","2020-01-18","12",0,null,0,"0","2","2020-02-17 18:40:02","2","2020-02-17 18:40:02","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"136,58083","C170533","PERSONAL","Mr","ltCiTyDjJ0Gdz4KiVHpL3w==","xEf2h2aoyRQ71ZVgBH+9WQ==","","oxxB92pGHSI9I6dk86NeV50fIKbJm7OHBHlNQ0XlFwdi0YrCU3uueNLGwLXtYZ27jc2ffcQTK04oDV5uyRKmsw==","65I9HJH8Lb0dMm8MBuRKKw==","UoHdQ18xnvupRvjCY9wtS6MZZ24DKjVuPgYYyCDQhRU=","IiBGQKIxd9Yo4PXXqWkRIg==",null,1,"4566"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 18:40:03","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":["7211","754","998.0","998.00","2","2020-02-17 18:40:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 18:40:03","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-01-18","2020-02-17","754"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-17 18:40:03","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":["7211",533,"SETTLED","A14-I207539","2020-02-17 18:40:02","2020-01-18","2","2020-02-17 18:40:02","2","2020-02-17 18:40:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 18:40:03","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":["7539","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-02-17 18:40:02","2","2020-02-17 18:40:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 18:40:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"7539"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-17 18:40:03","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":[533,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207187","2020-02-17 18:40:02",1038,"2","2020-02-17 18:40:02","2","2020-02-17 18:40:02","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 18:40:03","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":["7187","DEPOSIT",null,"PAID","2020-02-17 18:40:02",0,"2","2020-02-17 18:40:02","2","2020-02-17 18:40:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 18:40:03","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":["7187","INVOICE","7539","PAID","2020-02-17 18:40:02",1038,"2","2020-02-17 18:40:02","2","2020-02-17 18:40:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 18:58:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 19:14:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 19:20: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","floor_plan_rent_room":[],"index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","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 \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> C15-086 <\/td>\n\t\t\t\t\t 8.9X4.5X6.5 <\/td>\n\t\t\t\t\t $2168.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\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","warehousing":{"1":{"new_customer":"1","identity_type":"BUSINESS","identity_id":"69924770","title":"Mr","lastname":"CHAN","firstname":"Mr","companyname":"Fancy House Design Limited","email":"","tel":"67375443","address":"\u67f4\u7063\u674f\u82b1\u90a88\u5ea71108\u5ba4","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1392","room_code":"C15-086","retail_price":"2168.0","discounted_price":"2168.00","location_id":"6"}],"roughly_size":"40.05","total_retail_price":2168,"total_discounted_price":2168,"deposit":2168,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":5420,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3252.00","warehousing_date":"2020-02-17","rent_from":"2020-02-17","rent_to":"2020-05-16","delivery_service":"0","remark":"3 months contract. Special offer the 50% discount. Storage rental and deposit paid by bank transfer on Feb 17,2020. Smartcard mailed out on the same day.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":3252,"order_total":8732,"final_order_total":5480,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012490507","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"pass":true}},"roughly_size":"40.05","total_discounted_price":"2168.00","deposit":"2168.00","total_retail_price":"2168.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 19:20:07","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":["C201513","BUSINESS","Mr","uUmG+7bwaQqrpbWycwrVZg==","8BEgNhGpCR8jGkzUtrIcXg==","Fancy House Design Limited","YXkKpMa8eCs9FfIRIBWZqA==",null,"e3MviWPFrJz9k2PTF8m73m0352bo\/O51B5gHht4NbR4=",null,"vZrlLn84bCgnCknMD7StvQ==",null,"uUyFOus8Yu7C0B8JUWjh0Q==","2","2020-02-17 19:20:05","2","2020-02-17 19:20:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 19:20:07","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","3","6",1513,"NEW","C15-CT207212",2168,2168,2168,0,"3","3",5420,8732,5480,"2020-02-17 19:20:07","0",null,null,null,"2020-02-17","2020-05-16","3 months contract. Special offer the 50% discount. Storage rental and deposit paid by bank transfer on Feb 17,2020. Smartcard mailed out on the same day.","2020-02-17","40.05",0,null,3252,"3252.00","2","2020-02-17 19:20:05","2","2020-02-17 19:20:05","BANKIN","","","","BANKIN","","","",null,0,"0012490507","C201513","BUSINESS","Mr","uUmG+7bwaQqrpbWycwrVZg==","8BEgNhGpCR8jGkzUtrIcXg==","Fancy House Design Limited","e3MviWPFrJz9k2PTF8m73m0352bo\/O51B5gHht4NbR4=","YXkKpMa8eCs9FfIRIBWZqA==",null,null,"vZrlLn84bCgnCknMD7StvQ=="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 19:20:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7212",1513,"11","1","60.0",60,"2","2020-02-17 19:20:05","2","2020-02-17 19:20:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 19:20:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"7212"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-02-17 19:20:07","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":["7212","1392","2168.0","2168.00","2","2020-02-17 19:20:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 19:20:07","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-02-17","2020-05-16","1392"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-17 19:20:07","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":["7212","C15-D205291","PAID",2168,0,"2020-05-16","2020-02-17 19:20:05","2020-02-17 19:20:05","2","2020-02-17 19:20:05","2","2020-02-17 19:20:05",1513]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 19:20:07","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":["7212",1513,"SETTLED","C15-I207540","2020-02-17 19:20:05","2020-02-17","2","2020-02-17 19:20:05","2","2020-02-17 19:20:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 19:20:07","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":["7540","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-02-17 19:20:05","2","2020-02-17 19:20:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 19:20:07","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":["7540","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1084,"MO","1",1084,"2","2020-02-17 19:20:05","2","2020-02-17 19:20:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 19:20:07","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":["7540","RENT","\u9810\u7e73\u79df\u91d1",3,2168,"MO","1",2168,"2","2020-02-17 19:20:05","2","2020-02-17 19:20:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 19:20:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7540","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-02-17 19:20:05","2","2020-02-17 19:20:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 19:20:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3312,0,"7540"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-17 19:20:07","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":[1513,"BANKIN","","","","BANKIN","","","","PAID","P207188","2020-02-17 19:20:05",5480,"2","2020-02-17 19:20:05","2","2020-02-17 19:20:05","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 19:20:07","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":["7188","DEPOSIT","5291","PAID","2020-02-17 19:20:05",2168,"2","2020-02-17 19:20:05","2","2020-02-17 19:20:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 19:20:07","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":["7188","INVOICE","7540","PAID","2020-02-17 19:20:05",3312,"2","2020-02-17 19:20:05","2","2020-02-17 19:20:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-17 19:21:12","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` = ?, `customer_companyname` = ? where id = ?","parameters":["NEW","0012490507","3 months contract. Special offer the 50% discount. Storage rental and deposit paid by bank transfer on Feb 17,2020. Smartcard mailed out on the same day.","2020-02-17 19:21:12","2","yXKLXTtbNpECaRVTZxF\/Rw==","uUmG+7bwaQqrpbWycwrVZg==","YXkKpMa8eCs9FfIRIBWZqA==","e3MviWPFrJz9k2PTF8m73m0352bo\/O51B5gHht4NbR4=","Fancy House Design Limited",7212]},"data_before":[],"data_after":[],"step":1} *****