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

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

\u5009\u5eab\u7de8\u865f<\/td>\n	\u5c3a\u5bf8<\/td>\n	\u539f\u50f9(\u6708)<\/td>\n	\u512a\u60e0\u50f9(\u6708)<\/td>\n	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n	\u50f9\u683c<\/td>\n	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n	<\/td>\n <\/tr>
B01-087 <\/td>\n\t\t\t\t\t	4X4X7 <\/td>\n\t\t\t\t\t	$1112.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"16","total_discounted_price":"1112.00","deposit":"2224.00","total_retail_price":"1112.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 11:13:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","2","5","1699","NEW","B01-CT208584",1112,1112,2224,0,"2","2",4338,4508,4398,"2020-08-05 11:13:06","0",null,null,null,"2020-08-10","2020-10-09","2 months contract. Special \u201drent now\u201d offer 5 % off. Storage rental and deposit paid by cash on 5 Aug, 2020. Smart card provided on the same day.","2020-08-10","16",0,null,110,"110.00","2","2020-08-05 11:13:05","2","2020-08-05 11:13:05","CASH","","","","CASH","","","",null,0,"088,28826","C201699","PERSONAL","Ms","zDvqCdrrhut06RU0EaNhrQ==","wtXe3F1rqyx\/NkkNOLs7pg==","","CjzJxpV3MF6j4eMEgaHo3FYGo2KuBBRzSJEU5sLPywwGDfgF4OELDUVoNe5Wj9yT","KPLfsc6RF+MS+ZjU2o5tCg==","Rbf0UURnCO81dZfP19T60g==","iPdAs6daeSQTcnqaY7zcwQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 11:13:06","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":["8584","1699","11","1","60.0",60,"2","2020-08-05 11:13:05","2","2020-08-05 11:13:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 11:13:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"8584"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-08-05 11:13:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8584","1277","1112.0","1112.00","2","2020-08-05 11:13:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 11:13:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-10","2020-10-09","1277"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-05 11:13:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["8584","B01-D205586","PAID",2224,0,"2020-10-09","2020-08-05 11:13:05","2020-08-05 11:13:05","2","2020-08-05 11:13:05","2","2020-08-05 11:13:05","1699"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 11:13:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8584","1699","SETTLED","B01-I208913","2020-08-05 11:13:05","2020-08-10","2","2020-08-05 11:13:05","2","2020-08-05 11:13:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 11:13:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8913","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,1002,"MO","1",1002,"2","2020-08-05 11:13:05","2","2020-08-05 11:13:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 11:13:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8913","RENT","\u9810\u7e73\u79df\u91d1",2,1112,"MO","1",1112,"2","2020-08-05 11:13:05","2","2020-08-05 11:13:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 11:13:06","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":["8913","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-08-05 11:13:05","2","2020-08-05 11:13:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 11:13:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2174,0,"8913"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-05 11:13:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["1699","CASH","","","","CASH","","","","PAID","P208556","2020-08-05 11:13:05",4398,"2","2020-08-05 11:13:05","2","2020-08-05 11:13:05","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 11:13:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8556","DEPOSIT","5586","PAID","2020-08-05 11:13:05",2224,"2","2020-08-05 11:13:05","2","2020-08-05 11:13:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 11:13:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8556","INVOICE","8913","PAID","2020-08-05 11:13:05",2174,"2","2020-08-05 11:13:05","2","2020-08-05 11:13:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 11:16:48","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","190,15858","2 months contract. Special \u201drent now\u201d offer 5 % off. Storage rental and deposit paid by cash on 5 Aug, 2020. Smart card provided on the same day.","2020-08-05 11:16:48","2","wtXe3F1rqyx\/NkkNOLs7pg==","zDvqCdrrhut06RU0EaNhrQ==","Rbf0UURnCO81dZfP19T60g==","KPLfsc6RF+MS+ZjU2o5tCg==","CjzJxpV3MF6j4eMEgaHo3FYGo2KuBBRzSJEU5sLPywwGDfgF4OELDUVoNe5Wj9yT",8584]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 11:31:31","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","053,57784,055,49261","3 months contract. Storage rental paid by bank transfer on August 04, 2020. Storage deposit transferred from agreement A12-CT208091 to this agreement.\r\n","2020-08-05 11:31:31","2","H9gmHz05\/Te4s1\/V+q8XVg==","91\/laaizCwPmpW9Kp7VfpQ==","89NMk5xkAVgN7m2oNV6RkxT9h8K4NzHWFs3mEXMgHMY=","BiBf1UPmN8aaS3XWB1RrSQ==","65X9bXQhfMS5Sw3s18SCYnlHuJ74GEdJyMMi7ZWpUt\/xzahhd5USFse9zIrw+zM344D4e5mlnLBzwvdEJf5l0w==",8581]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 11:33:14","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","053,57784,055,49261","3 months contract. Storage rental paid by bank transfer on August 05, 2020. Storage deposit transferred from agreement A12-CT208091 to this agreement.\r\n","2020-08-05 11:33:14","2","H9gmHz05\/Te4s1\/V+q8XVg==","91\/laaizCwPmpW9Kp7VfpQ==","89NMk5xkAVgN7m2oNV6RkxT9h8K4NzHWFs3mEXMgHMY=","BiBf1UPmN8aaS3XWB1RrSQ==","65X9bXQhfMS5Sw3s18SCYnlHuJ74GEdJyMMi7ZWpUt\/xzahhd5USFse9zIrw+zM344D4e5mlnLBzwvdEJf5l0w==",8581]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 11:35:08","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","053,57784,055,49261","3 months contract. Storage rental paid $500 by bank transfer on Jul 21. The balance paid by bank transfer on Aug 05, 2020. Storage deposit transferred from agreement A12-CT208094 to this agreement. ","2020-08-05 11:35:08","2","H9gmHz05\/Te4s1\/V+q8XVg==","91\/laaizCwPmpW9Kp7VfpQ==","89NMk5xkAVgN7m2oNV6RkxT9h8K4NzHWFs3mEXMgHMY=","BiBf1UPmN8aaS3XWB1RrSQ==","65X9bXQhfMS5Sw3s18SCYnlHuJ74GEdJyMMi7ZWpUt\/xzahhd5USFse9zIrw+zM344D4e5mlnLBzwvdEJf5l0w==",8581]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:01:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:13: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=%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","floor_plan_rent_room":[{"room_id":"822","master_room_id":"106","room_code":"Q19"}],"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> Q19 <\/td>\r\n\t\t\t\t\t 4X4.5X7 <\/td>\r\n\t\t\t\t\t $1.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","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"M258495(3)","title":"Mr","lastname":"YANG","firstname":"Diao","companyname":"","email":"skyd1933@aliyun.com","tel":"63129823","address":"Room 1805, 18\/F, Block C, Causeway Centre, No.28 Harbour Road, Wan Chai Hong Kong ","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"822","room_code":"Q19","retail_price":"1.0","discounted_price":"1.00","location_id":"3"}],"roughly_size":"18","total_retail_price":1,"total_discounted_price":568,"deposit":1196,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2900,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-08-04","rent_from":"2020-08-04","rent_to":"2020-11-03","delivery_service":"0","remark":"3 months contract. Storage rental and deposit $2102 and $798 paid by bank transfer on Aug 04, 2020. Smart card provided by mail on the same day.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2900,"final_order_total":2900,"location_id":"3","branch_id":"1","company_id":"1","room_key":"190, 39747","order_product":[],"pass":true}},"roughly_size":"18","total_discounted_price":"568.00","deposit":"1196.00","total_retail_price":"1.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:13:47","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":["C201700","PERSONAL","Mr","qCScY6UfjyMiGOl6hds7CA==","ch5RTqSd49z177L3nG78qg==","","GWFwLDpz\/r49PIuSeWz2Yw==","BqxqVWDZtJqkNU0pRZTy+PlD09FVGOlNnATGCYVwr8E=","XC59fzvLvh9Hua2\/3uzH5ponY1HzIITYcavX7cDtyI8WuKy+AXIzQu6EWH73da7aoCmdA+odJZgOcuv9fo7HURADKE3V4dhW0TLmefw5N9lDBiHQ0HlsWSaCO98uJSMn","NGVeC21ox\/nD+jsQrlO9zA==",null,"BqxqVWDZtJqkNU0pRZTy+PlD09FVGOlNnATGCYVwr8E=","aMla0V2rYFxR5kbmVxeGoQ==","2","2020-08-05 12:13:46","2","2020-08-05 12:13:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:13:48","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","3",1700,"NEW","A18-CT208585",1,568,1196,0,"3","3",2900,2900,2900,"2020-08-05 12:13:48","0",null,null,null,"2020-08-04","2020-11-03","3 months contract. Storage rental and deposit $2102 and $798 paid by bank transfer on Aug 04, 2020. Smart card provided by mail on the same day.","2020-08-04","18",0,null,0,"0.00","2","2020-08-05 12:13:46","2","2020-08-05 12:13:46","BANKIN","","","","BANKIN","","","",null,0,"190, 39747","C201700","PERSONAL","Mr","qCScY6UfjyMiGOl6hds7CA==","ch5RTqSd49z177L3nG78qg==","","XC59fzvLvh9Hua2\/3uzH5ponY1HzIITYcavX7cDtyI8WuKy+AXIzQu6EWH73da7aoCmdA+odJZgOcuv9fo7HURADKE3V4dhW0TLmefw5N9lDBiHQ0HlsWSaCO98uJSMn","GWFwLDpz\/r49PIuSeWz2Yw==","BqxqVWDZtJqkNU0pRZTy+PlD09FVGOlNnATGCYVwr8E=","NGVeC21ox\/nD+jsQrlO9zA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:13:48","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":["8585","822","1.0","1.00","2","2020-08-05 12:13:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:13:48","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-08-04","2020-11-03","822"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-05 12:13:48","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":["8585","A18-D205587","PAID",1196,0,"2020-11-03","2020-08-05 12:13:46","2020-08-05 12:13:46","2","2020-08-05 12:13:46","2","2020-08-05 12:13:46",1700]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:13:48","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":["8585",1700,"SETTLED","A18-I208914","2020-08-05 12:13:46","2020-08-04","2","2020-08-05 12:13:46","2","2020-08-05 12:13:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:13:48","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":["8914","RENT","\u9810\u7e73\u79df\u91d1",1,568,"MO","1",568,"2","2020-08-05 12:13:46","2","2020-08-05 12:13:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:13:48","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":["8914","RENT","\u9810\u7e73\u79df\u91d1",2,568,"MO","1",568,"2","2020-08-05 12:13:46","2","2020-08-05 12:13:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:13:48","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":["8914","RENT","\u9810\u7e73\u79df\u91d1",3,568,"MO","1",568,"2","2020-08-05 12:13:46","2","2020-08-05 12:13:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:13:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1704,0,"8914"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-05 12:13:48","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":[1700,"BANKIN","","","","BANKIN","","","","PAID","P208557","2020-08-05 12:13:46",2900,"2","2020-08-05 12:13:46","2","2020-08-05 12:13:46","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:13:48","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":["8557","DEPOSIT","5587","PAID","2020-08-05 12:13:46",1196,"2","2020-08-05 12:13:46","2","2020-08-05 12:13:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:13:48","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":["8557","INVOICE","8914","PAID","2020-08-05 12:13:46",1704,"2","2020-08-05 12:13:46","2","2020-08-05 12:13:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:17:21","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1168&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1168,"customer_code":"C191168","identity_type":"PERSONAL","identity_id":"D531931(6)","title":"Ms","lastname":"Tam","firstname":"Siu Ngun","companyname":"","email":"doristam3@gmail.com","tel":"94757199","address":"22E, Block 11, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1247.0","renew_rent_month":"6","renew_warehousing_date":"2020-07-05","renew_room_key":"0012490559,0012490690","renew_remark":"6 months contract. Storage rental paid by PPS on February 4, 2020. Storage deposit $2768 transferred from agreement A05-CT195634 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT207119, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"125","order_discount":[{"master_room_discount_id":"283","master_room_id":"125","discount_type":"%","price":"1384.00","disocunted_price":"1245.60","discount":"10.00","monthly_deduct":138.4,"room_id":"1043","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1043","room_code":"A05-041","retail_price":"1384.0","discounted_price":1245.6,"location_id":"4"}],"roughly_size":"18","total_retail_price":1384,"total_discounted_price":1247,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":7482,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-05","rent_from":"2020-07-05","rent_to":"2021-01-04","delivery_service":"0","remark":"6 months contract. Storage rental paid by PPS on Aug 4, 2020. Storage deposit $2768 transferred from agreement A05-CT207119 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":7482,"final_order_total":7482,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012490559,0012490690","order_product":[],"pass":true}},"first_order_id":"4097","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-041 <\/td>\r\n\t\t\t\t\t 6X3X7 <\/td>\r\n\t\t\t\t\t $1384.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"18","total_discounted_price":"1247.0","deposit":"0","total_retail_price":"1384.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:17:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1168,"NEW","A05-CT208586",1384,1247,0,0,"6","6",7482,7482,7482,"2020-08-05 12:17:22","0",null,null,null,"2020-07-05","2021-01-04","6 months contract. Storage rental paid by PPS on Aug 4, 2020. Storage deposit $2768 transferred from agreement A05-CT207119 to this agreement.\r\n","2020-07-05","18",0,null,0,"0","2","2020-08-05 12:17:21","2","2020-08-05 12:17:21","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0012490559,0012490690","C191168","PERSONAL","Ms","80gnAMOvXv15zv\/CZ0Eqhw==","RAqogkelEKt1q5b\/6Neu\/g==","","Ut6wsoIDAljQJ6kQfCQSwE1wSnsPD\/fsEXrkRDwQG3A6U3eu5pWNV02cKJQSxPwWYYATzlFQ2\/TR66ZFjxzxyA==","J0s5BNrvxP8Nsmss73R5Xg==","ALwu41SaKL6NQKUA4wKaTDEEKRUmzMmPVvr4yQ1ufN4=","R28gHn90bFttZIUfQCAybA==",null,1,"4097"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:17:22","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":["8586","283","125","1043","%","10.00",138.4,"2","2020-08-05 12:17:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:17:22","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":["8586","1043","1384.0",1245.6,"2","2020-08-05 12:17:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:17:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-05","2021-01-04","1043"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-05 12:17:22","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":["8586",1168,"SETTLED","A05-I208915","2020-08-05 12:17:21","2020-07-05","2","2020-08-05 12:17:21","2","2020-08-05 12:17:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:17:22","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":["8915","RENT","\u9810\u7e73\u79df\u91d1",1,1247,"MO","1",1247,"2","2020-08-05 12:17:21","2","2020-08-05 12:17:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:17:22","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":["8915","RENT","\u9810\u7e73\u79df\u91d1",2,1247,"MO","1",1247,"2","2020-08-05 12:17:21","2","2020-08-05 12:17:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:17:22","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":["8915","RENT","\u9810\u7e73\u79df\u91d1",3,1247,"MO","1",1247,"2","2020-08-05 12:17:21","2","2020-08-05 12:17:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:17:22","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":["8915","RENT","\u9810\u7e73\u79df\u91d1",4,1247,"MO","1",1247,"2","2020-08-05 12:17:21","2","2020-08-05 12:17:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:17:22","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":["8915","RENT","\u9810\u7e73\u79df\u91d1",5,1247,"MO","1",1247,"2","2020-08-05 12:17:21","2","2020-08-05 12:17:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:17:22","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":["8915","RENT","\u9810\u7e73\u79df\u91d1",6,1247,"MO","1",1247,"2","2020-08-05 12:17:21","2","2020-08-05 12:17:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:17:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7482,0,"8915"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-05 12:17:22","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":[1168,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208558","2020-08-05 12:17:21",7482,"2","2020-08-05 12:17:21","2","2020-08-05 12:17:21","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:17:22","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":["8558","DEPOSIT",null,"PAID","2020-08-05 12:17:21",0,"2","2020-08-05 12:17:21","2","2020-08-05 12:17:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:17:22","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":["8558","INVOICE","8915","PAID","2020-08-05 12:17:21",7482,"2","2020-08-05 12:17:21","2","2020-08-05 12:17:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:25:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:31:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:42:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:52:55","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"822","master_room_id":"106","room_code":"Q19"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":629,"customer_code":"C170629","identity_type":"PERSONAL","identity_id":"D676258(2)","title":"Ms","lastname":"Chan","firstname":"Wai King Dicky","companyname":"","email":"kelly@tiptoptours.com.hk","tel":"91207071","address":"Flat C, 38\/F, Block 19, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1195.0","renew_rent_month":"1","renew_warehousing_date":"2020-07-02","renew_room_key":"052,40523","renew_remark":"1 month contract. Storage rental paid by bank transfer on July 17, 2020. Storage deposit transferred from agreement A18-CT208056 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT208418, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"107","order_discount":[],"order_room":[{"room_id":"815","room_code":"Q12","retail_price":"1195.0","discounted_price":"1195.00","location_id":"3"}],"roughly_size":"18","total_retail_price":1195,"total_discounted_price":1195,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1195,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-07-02","rent_from":"2020-07-02","rent_to":"2020-08-01","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on August 05, 2020. Storage deposit transferred from agreement A18-CT208418 to this agreement.\r\n\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1195,"final_order_total":1195,"location_id":"3","branch_id":"1","company_id":"1","room_key":"052,40523","order_product":[],"pass":true}},"first_order_id":"4694","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> Q12 <\/td>\r\n\t\t\t\t\t 3X6X7 <\/td>\r\n\t\t\t\t\t $1195.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"18","total_discounted_price":"1195.00","deposit":"0.00","total_retail_price":"1195.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:52:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",629,"NEW","A18-CT208587",1195,1195,0,0,"1","1",1195,1195,1195,"2020-08-05 12:52:55","0",null,null,null,"2020-07-02","2020-08-01","1 month contract. Storage rental paid by bank transfer on August 05, 2020. Storage deposit transferred from agreement A18-CT208418 to this agreement.\r\n\r\n","2020-07-02","18",0,null,0,"0.00","2","2020-08-05 12:52:55","2","2020-08-05 12:52:55","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,40523","C170629","PERSONAL","Ms","RpXGKsWvjdIh2zpNpZGQoQ==","U9yoE9KqV1v8YlRkf7Q2yg==","","36wRGpAjwc\/0wlF+nTn2W4D7sbMVDfrQcRaUEETc94CbdXOD165sYiJ4w9a0XWwUmn9HdLUPAL5jHBLCynFDtA==","c1f20bJNL7v6HlqVb6xwiw==","09G8cY6xfbNmNlWHMFOaw2MNgdv38UQbp6+QiEm\/fmg=","fShBvH+qXdfrGzN7M8+\/Eg==",null,1,"4694"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:52:55","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":["8587","815","1195.0","1195.00","2","2020-08-05 12:52:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:52:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-02","2020-08-01","815"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-05 12:52:55","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":["8587",629,"SETTLED","A18-I208916","2020-08-05 12:52:55","2020-07-02","2","2020-08-05 12:52:55","2","2020-08-05 12:52:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:52:55","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":["8916","RENT","\u9810\u7e73\u79df\u91d1",1,1195,"MO","1",1195,"2","2020-08-05 12:52:55","2","2020-08-05 12:52:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:52:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1195,0,"8916"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-05 12:52:55","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":[629,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208559","2020-08-05 12:52:55",1195,"2","2020-08-05 12:52:55","2","2020-08-05 12:52:55","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:52:55","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":["8559","DEPOSIT",null,"PAID","2020-08-05 12:52:55",0,"2","2020-08-05 12:52:55","2","2020-08-05 12:52:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 12:52:55","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":["8559","INVOICE","8916","PAID","2020-08-05 12:52:55",1195,"2","2020-08-05 12:52:55","2","2020-08-05 12:52:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 13:10:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 13:19:47","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 13:24:06","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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1313,"customer_code":"C191313","identity_type":"PERSONAL","identity_id":"V004606(A)","title":"Mr","lastname":"Tung","firstname":"Shing Edgar","companyname":"","email":"edgar.tung@gmail.com","tel":"90913266","address":"Flat B, 14\/F, Carnation Court, 43 Tai Hang Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2455.0","renew_rent_month":"13","renew_warehousing_date":"2020-08-04","renew_room_key":"189,28966","renew_remark":"13 months contract. Special offer, $2278 discounted rate for 12 months, one month free and $300 discount for Apple Storage customers, extra $200 Maxim's cake vouchers. Storage rental and deposit paid by bank transfer on June 24, 2019. Smartcard provided on or before July 4, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT195311, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $5456.0","renew_master_room_id":"212","order_discount":[],"order_room":[{"room_id":"1643","room_code":"A16-152","retail_price":"1290.0","discounted_price":"1290.00","location_id":"7"},{"room_id":"1642","room_code":"A16-151","retail_price":"1605.0","discounted_price":"1605.00","location_id":"7"}],"roughly_size":"36","total_retail_price":2895,"total_discounted_price":2455,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":29460,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2455.00","warehousing_date":"2020-08-04","rent_from":"2020-08-04","rent_to":"2021-09-03","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free and extra $200 Maxim's cake vouchers. Storage rental paid by bank transfer on Aug 5, 2020. Storage deposit $5456 transferred from agreement A16-CT195311 to this agreement. Smartcard provided on or before July 4, 2019. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":2455,"order_total":31915,"final_order_total":29460,"location_id":"7","branch_id":"1","company_id":"1","room_key":"189,28966","order_product":[],"pass":true}},"first_order_id":5311,"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\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A16-152 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/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> A16-151 <\/td>\r\n\t\t\t\t\t 5X4X7 <\/td>\r\n\t\t\t\t\t $1605.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":"36","total_discounted_price":"2455.0","deposit":"0","total_retail_price":"2895.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 13:24: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","7",1313,"NEW","A16-CT208588",2895,2455,0,0,"13","13",29460,31915,29460,"2020-08-05 13:24:07","0",null,null,null,"2020-08-04","2021-09-03","13 months contract. Special offer the 13th month free and extra $200 Maxim's cake vouchers. Storage rental paid by bank transfer on Aug 5, 2020. Storage deposit $5456 transferred from agreement A16-CT195311 to this agreement. Smartcard provided on or before July 4, 2019. \r\n","2020-08-04","36",0,null,2455,"2455.00","2","2020-08-05 13:24:06","2","2020-08-05 13:24:06","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"189,28966","C191313","PERSONAL","Mr","qoN3Fq0L\/It\/laPVi23G\/Q==","INIqO3p6N\/stXk+6gk8Omw==","","tdUkPTirIp7PPcY8xz4jmBSRkUOpGBCGmm4kXq2Na5lEpoUhQVOYoR+b+4SrX\/Fvz5eJSMdtdOZuCSgjdjyVvg==","oqomjv5uDSdKY3bMrTqb+g==","6s5JZxUUfRrdYfNDZNIfRX2Jro0r65BLzeUyYL8RDrw=","7Wk0Ih0GKw\/Me4iTAWrxOA==",null,1,5311]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 13:24: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":["8588","1643","1290.0","1290.00","2","2020-08-05 13:24:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 13:24: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-08-04","2021-09-03","1643"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-05 13:24: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":["8588","1642","1605.0","1605.00","2","2020-08-05 13:24:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 13:24: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-08-04","2021-09-03","1642"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-05 13:24: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":["8588",1313,"SETTLED","A16-I208917","2020-08-05 13:24:06","2020-08-04","2","2020-08-05 13:24:06","2","2020-08-05 13:24:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 13:24: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":["8917","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,2455,"MO","1",2455,"2","2020-08-05 13:24:06","2","2020-08-05 13:24:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 13:24: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":["8917","RENT","\u9810\u7e73\u79df\u91d1",3,2455,"MO","1",2455,"2","2020-08-05 13:24:06","2","2020-08-05 13:24:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 13:24: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":["8917","RENT","\u9810\u7e73\u79df\u91d1",4,2455,"MO","1",2455,"2","2020-08-05 13:24:06","2","2020-08-05 13:24:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 13:24: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":["8917","RENT","\u9810\u7e73\u79df\u91d1",5,2455,"MO","1",2455,"2","2020-08-05 13:24:06","2","2020-08-05 13:24:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 13:24: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":["8917","RENT","\u9810\u7e73\u79df\u91d1",6,2455,"MO","1",2455,"2","2020-08-05 13:24:06","2","2020-08-05 13:24:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 13:24: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":["8917","RENT","\u9810\u7e73\u79df\u91d1",7,2455,"MO","1",2455,"2","2020-08-05 13:24:06","2","2020-08-05 13:24:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 13:24: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":["8917","RENT","\u9810\u7e73\u79df\u91d1",8,2455,"MO","1",2455,"2","2020-08-05 13:24:06","2","2020-08-05 13:24:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 13:24: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":["8917","RENT","\u9810\u7e73\u79df\u91d1",9,2455,"MO","1",2455,"2","2020-08-05 13:24:06","2","2020-08-05 13:24:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 13:24: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":["8917","RENT","\u9810\u7e73\u79df\u91d1",10,2455,"MO","1",2455,"2","2020-08-05 13:24:06","2","2020-08-05 13:24:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 13:24: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":["8917","RENT","\u9810\u7e73\u79df\u91d1",11,2455,"MO","1",2455,"2","2020-08-05 13:24:06","2","2020-08-05 13:24:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 13:24: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":["8917","RENT","\u9810\u7e73\u79df\u91d1",12,2455,"MO","1",2455,"2","2020-08-05 13:24:06","2","2020-08-05 13:24:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 13:24: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":["8917","RENT","\u9810\u7e73\u79df\u91d1",13,2455,"MO","1",2455,"2","2020-08-05 13:24:06","2","2020-08-05 13:24:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 13:24:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[29460,0,"8917"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-05 13:24: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":[1313,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208560","2020-08-05 13:24:06",29460,"2","2020-08-05 13:24:06","2","2020-08-05 13:24:06","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 13:24: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":["8560","DEPOSIT",null,"PAID","2020-08-05 13:24:06",0,"2","2020-08-05 13:24:06","2","2020-08-05 13:24:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 13:24: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":["8560","INVOICE","8917","PAID","2020-08-05 13:24:06",29460,"2","2020-08-05 13:24:06","2","2020-08-05 13:24:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 13:33:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 14:40:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 15:32:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 15:33:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 15:53:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 15:56:18","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=281&filter3=undefined","floor_plan_rent_room":[{"room_id":"822","master_room_id":"106","room_code":"Q19"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":686,"customer_code":"C180686","identity_type":"PERSONAL","identity_id":"K515042(6)","title":"Mr","lastname":"Chan","firstname":"Wing Lung","companyname":"","email":"arifchan128@gmail.com","tel":"94383806","address":"Flat A, 7\/F, Nga Yuen, 66-68 Village Road, Happy Valley, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"981.0","renew_rent_month":"13","renew_warehousing_date":"2020-08-04","renew_room_key":"055,55693","renew_remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by bank transfer on June 23, 2019. Storage deposit transferred from agreement A18-CT183993 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195302, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"77","order_discount":[],"order_room":[{"room_id":"812","room_code":"Q09","retail_price":"1090.0","discounted_price":"1090.00","location_id":"3"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":981,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5886,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-08-04","rent_from":"2020-08-04","rent_to":"2021-02-03","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on August 05, 2020. Storage deposit transferred from agreement A18-CT195302 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5886,"final_order_total":5886,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,55693","order_product":[],"pass":true}},"first_order_id":"3993","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> Q09 <\/td>\r\n\t\t\t\t\t 3X4X7 <\/td>\r\n\t\t\t\t\t $1090.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":"981.00","deposit":"0.00","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 15:56:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",686,"NEW","A18-CT208589",1090,981,0,0,"6","6",5886,5886,5886,"2020-08-05 15:56:18","0",null,null,null,"2020-08-04","2021-02-03","6 months contract. Storage rental paid by bank transfer on August 05, 2020. Storage deposit transferred from agreement A18-CT195302 to this agreement.\r\n","2020-08-04","12",0,null,0,"0.00","2","2020-08-05 15:56:18","2","2020-08-05 15:56:18","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,55693","C180686","PERSONAL","Mr","qyKVbQfwpDIe+UaT45Rhlg==","U9yoE9KqV1v8YlRkf7Q2yg==","","GkeOC2dgrzaNDQPdddgO0FiHRL+YMGFNGtE92rrr3emdPdBdyH3emYLTdg4zZrjeX2xAwowqIx1TGQwBsbTQcb86+Z97UO5X7AGZbaKhmAc=","DlIQKz0s6wyEPzyUqXaoWg==","GN7lMOwd9orARlMkQ+L3zQPmyYVzN7ZFx7NrjyoTPFw=","7fCrQsOP74FpW02FPS2gGg==",null,1,"3993"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 15:56:18","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":["8589","812","1090.0","1090.00","2","2020-08-05 15:56:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 15:56:18","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-08-04","2021-02-03","812"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-05 15:56:18","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":["8589",686,"SETTLED","A18-I208918","2020-08-05 15:56:18","2020-08-04","2","2020-08-05 15:56:18","2","2020-08-05 15:56:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 15:56:18","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":["8918","RENT","\u9810\u7e73\u79df\u91d1",1,981,"MO","1",981,"2","2020-08-05 15:56:18","2","2020-08-05 15:56:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 15:56:18","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":["8918","RENT","\u9810\u7e73\u79df\u91d1",2,981,"MO","1",981,"2","2020-08-05 15:56:18","2","2020-08-05 15:56:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 15:56:18","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":["8918","RENT","\u9810\u7e73\u79df\u91d1",3,981,"MO","1",981,"2","2020-08-05 15:56:18","2","2020-08-05 15:56:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 15:56:18","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":["8918","RENT","\u9810\u7e73\u79df\u91d1",4,981,"MO","1",981,"2","2020-08-05 15:56:18","2","2020-08-05 15:56:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 15:56:18","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":["8918","RENT","\u9810\u7e73\u79df\u91d1",5,981,"MO","1",981,"2","2020-08-05 15:56:18","2","2020-08-05 15:56:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 15:56:18","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":["8918","RENT","\u9810\u7e73\u79df\u91d1",6,981,"MO","1",981,"2","2020-08-05 15:56:18","2","2020-08-05 15:56:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 15:56:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5886,0,"8918"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-05 15:56:18","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":[686,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208561","2020-08-05 15:56:18",5886,"2","2020-08-05 15:56:18","2","2020-08-05 15:56:18","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 15:56:18","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":["8561","DEPOSIT",null,"PAID","2020-08-05 15:56:18",0,"2","2020-08-05 15:56:18","2","2020-08-05 15:56:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 15:56:18","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":["8561","INVOICE","8918","PAID","2020-08-05 15:56:18",5886,"2","2020-08-05 15:56:18","2","2020-08-05 15:56:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:01:06","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:08:35","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:20:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:28:51","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":"","floor_plan_rent_room":[{"room_id":"822","master_room_id":"106","room_code":"Q19"},{"room_id":"877","master_room_id":"77","room_code":"Y06"}],"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\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> Q19 <\/td>\r\n\t\t\t\t\t 4X4.5X7 <\/td>\r\n\t\t\t\t\t $1.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> Y06 <\/td>\r\n\t\t\t\t\t 3X4X7 <\/td>\r\n\t\t\t\t\t $1090.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","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"Z014521(2)","title":"Mr","lastname":"SHIM","firstname":"Kwun Yue","companyname":"","email":"skyfish@hotmail.com","tel":"54843111","address":"20C, Block 2, University Heights Pokfiled Toad, Kennedy Town, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"822","room_code":"Q19","retail_price":"1.0","discounted_price":"1.00","location_id":"3"},{"room_id":"877","room_code":"Y06","retail_price":"1090.0","discounted_price":"1090.00","location_id":"3"}],"roughly_size":"22","total_retail_price":1091,"total_discounted_price":1351,"deposit":3776,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":19988,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-10-08","rent_from":"2020-10-08","rent_to":"2021-10-07","delivery_service":"0","remark":"12 months contract. 50% off for the first 3 months. Deposit $500 paid by payme transfer on Jul 22.2020. The balance of storage rental and deposit $19488 paid by bank transfer on Aug 05,2020. Smart card provided by mail on the same day.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":19988,"final_order_total":19988,"location_id":"3","branch_id":"1","company_id":"1","room_key":"190,38721","order_product":[],"pass":true}},"roughly_size":"22","total_discounted_price":"1351.00","deposit":"3776.00","total_retail_price":"1091.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:28:52","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":["C201701","PERSONAL","Mr","q8DvUqWcmm6W9Hgo61s5FA==","EeKU6QiKY39Ow+TFN4bRdw==","","x9D8i4YI8D8iwitQ9xGbGQ==","IPvC1GHfnVh5eO5o+qCAa2sh\/Ah9noPtReEblgLwE6w=","T7gmIyNUxrFHsQQjJ5esusFqTyvyEejz7u9ZHkveNlB4nG76\/h3HSsVZgIpp7It02t6x6rlWS+Dl2qI4jAiqSSA\/CA2ZkX5rWIFJzj7C\/cM=","H5yzxL\/TPLAE4PeLTfW9+w==",null,"IPvC1GHfnVh5eO5o+qCAa2sh\/Ah9noPtReEblgLwE6w=","R47BKgofo5JkRoKhbCV1rQ==","2","2020-08-05 16:28:51","2","2020-08-05 16:28:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:28:52","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","3",1701,"NEW","A18-CT208590",1091,1351,3776,0,"12","12",19988,19988,19988,"2020-08-05 16:28:52","0",null,null,null,"2020-10-08","2021-10-07","12 months contract. 50% off for the first 3 months. Deposit $500 paid by payme transfer on Jul 22.2020. The balance of storage rental and deposit $19488 paid by bank transfer on Aug 05,2020. Smart card provided by mail on the same day.","2020-10-08","22",0,null,0,"0.00","2","2020-08-05 16:28:51","2","2020-08-05 16:28:51","BANKIN","","","","BANKIN","","","",null,0,"190,38721","C201701","PERSONAL","Mr","q8DvUqWcmm6W9Hgo61s5FA==","EeKU6QiKY39Ow+TFN4bRdw==","","T7gmIyNUxrFHsQQjJ5esusFqTyvyEejz7u9ZHkveNlB4nG76\/h3HSsVZgIpp7It02t6x6rlWS+Dl2qI4jAiqSSA\/CA2ZkX5rWIFJzj7C\/cM=","x9D8i4YI8D8iwitQ9xGbGQ==","IPvC1GHfnVh5eO5o+qCAa2sh\/Ah9noPtReEblgLwE6w=","H5yzxL\/TPLAE4PeLTfW9+w==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:28:52","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":["8590","822","1.0","1.00","2","2020-08-05 16:28:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:28:52","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-10-08","2021-10-07","822"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-05 16:28:52","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":["8590","877","1090.0","1090.00","2","2020-08-05 16:28:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:28:52","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-10-08","2021-10-07","877"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-05 16:28:52","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":["8590","A18-D205588","PAID",3776,0,"2021-10-07","2020-08-05 16:28:51","2020-08-05 16:28:51","2","2020-08-05 16:28:51","2","2020-08-05 16:28:51",1701]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:28:52","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":["8590",1701,"SETTLED","A18-I208919","2020-08-05 16:28:51","2020-10-08","2","2020-08-05 16:28:51","2","2020-08-05 16:28:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:28:52","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":["8919","RENT","\u9810\u7e73\u79df\u91d1",1,1351,"MO","1",1351,"2","2020-08-05 16:28:51","2","2020-08-05 16:28:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:28:52","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":["8919","RENT","\u9810\u7e73\u79df\u91d1",2,1351,"MO","1",1351,"2","2020-08-05 16:28:51","2","2020-08-05 16:28:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:28:52","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":["8919","RENT","\u9810\u7e73\u79df\u91d1",3,1351,"MO","1",1351,"2","2020-08-05 16:28:51","2","2020-08-05 16:28:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:28:52","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":["8919","RENT","\u9810\u7e73\u79df\u91d1",4,1351,"MO","1",1351,"2","2020-08-05 16:28:51","2","2020-08-05 16:28:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:28:52","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":["8919","RENT","\u9810\u7e73\u79df\u91d1",5,1351,"MO","1",1351,"2","2020-08-05 16:28:51","2","2020-08-05 16:28:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:28:52","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":["8919","RENT","\u9810\u7e73\u79df\u91d1",6,1351,"MO","1",1351,"2","2020-08-05 16:28:51","2","2020-08-05 16:28:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:28:52","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":["8919","RENT","\u9810\u7e73\u79df\u91d1",7,1351,"MO","1",1351,"2","2020-08-05 16:28:51","2","2020-08-05 16:28:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:28:52","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":["8919","RENT","\u9810\u7e73\u79df\u91d1",8,1351,"MO","1",1351,"2","2020-08-05 16:28:51","2","2020-08-05 16:28:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:28:52","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":["8919","RENT","\u9810\u7e73\u79df\u91d1",9,1351,"MO","1",1351,"2","2020-08-05 16:28:51","2","2020-08-05 16:28:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:28:52","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":["8919","RENT","\u9810\u7e73\u79df\u91d1",10,1351,"MO","1",1351,"2","2020-08-05 16:28:51","2","2020-08-05 16:28:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:28:52","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":["8919","RENT","\u9810\u7e73\u79df\u91d1",11,1351,"MO","1",1351,"2","2020-08-05 16:28:51","2","2020-08-05 16:28:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:28:52","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":["8919","RENT","\u9810\u7e73\u79df\u91d1",12,1351,"MO","1",1351,"2","2020-08-05 16:28:51","2","2020-08-05 16:28:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:28:52","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[16212,0,"8919"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-05 16:28:52","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":[1701,"BANKIN","","","","BANKIN","","","","PAID","P208562","2020-08-05 16:28:51",19988,"2","2020-08-05 16:28:51","2","2020-08-05 16:28:51","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:28:52","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":["8562","DEPOSIT","5588","PAID","2020-08-05 16:28:51",3776,"2","2020-08-05 16:28:51","2","2020-08-05 16:28:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:28:52","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":["8562","INVOICE","8919","PAID","2020-08-05 16:28:51",16212,"2","2020-08-05 16:28:51","2","2020-08-05 16:28:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:35:04","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","190,38721","12 months contract. 50% off for the first 3 months. Deposit $500 paid by payme transfer on Jul 22.2020. The balance of storage rental and deposit $19488 paid by bank transfer on Aug 05,2020. Smart card provided by mail on the same day.","2020-08-05 16:35:04","2","EeKU6QiKY39Ow+TFN4bRdw==","q8DvUqWcmm6W9Hgo61s5FA==","IPvC1GHfnVh5eO5o+qCAa2sh\/Ah9noPtReEblgLwE6w=","x9D8i4YI8D8iwitQ9xGbGQ==","T7gmIyNUxrFHsQQjJ5esusFqTyvyEejz7u9ZHkveNlB4nG76\/h3HSsVZgIpp7It02t6x6rlWS+Dl2qI4jAiqSSA\/CA2ZkX5rWIFJzj7C\/cM=",8590]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:39: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=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":{"1":{"room_id":"877","master_room_id":"77","room_code":"Y06"}},"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":754,"customer_code":"C180754","identity_type":"PERSONAL","identity_id":"D276420(3)","title":"Ms","lastname":"Lee","firstname":"Yuen Yu","companyname":"","email":null,"tel":"98127099","address":"Flat 708, 7\/F, Pik Yuet House, Shek Pai Wan Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"6","renew_warehousing_date":"2020-08-12","renew_room_key":"055,36498(lost),111,43397","renew_remark":"6 months contract. Storage rental paid by cheque on February 7, 2020. Storage deposit transferred from agreement A14-CT195673 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207140, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"626","room_code":"M37","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.00","warehousing_date":"2020-08-12","rent_from":"2020-08-12","rent_to":"2021-02-11","delivery_service":"0","remark":"6 months contract. Storage rental paid by cheque on August 05, 2020. Storage deposit transferred from agreement A14-CT207140 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,36498(lost),111,43397","order_product":[],"pass":true}},"first_order_id":"4279","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> M37 <\/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.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:39: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",754,"NEW","A14-CT208591",598,538,0,0,"6","6",3228,3228,3228,"2020-08-05 16:39:46","0",null,null,null,"2020-08-12","2021-02-11","6 months contract. Storage rental paid by cheque on August 05, 2020. Storage deposit transferred from agreement A14-CT207140 to this agreement.\r\n","2020-08-12","12",0,null,0,"0.00","2","2020-08-05 16:39:45","2","2020-08-05 16:39:45","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"055,36498(lost),111,43397","C180754","PERSONAL","Ms","e523\/E6u0vj8cQujTfOdLg==","kiriEIqhcx866RNZiMXdKQ==","","xlcdUTq9chMErwT1\/LubxtrE7FZIYtP6lTyqzIyIJkq9PrSKz8iEIciEeI24fvi3NreVmso+xebWDeKTxe9ZpyPh4EoSgH9Mra9LiJ\/dpzU=","Sf4DjxDkDZX4ytVGAQtmRg==",null,"gSn\/q1Pf60Yx2h79w5\/azQ==",null,1,"4279"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:39: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":["8591","626","598.0","598.00","2","2020-08-05 16:39:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:39: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-08-12","2021-02-11","626"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-05 16:39: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":["8591",754,"SETTLED","A14-I208920","2020-08-05 16:39:45","2020-08-12","2","2020-08-05 16:39:45","2","2020-08-05 16:39:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:39: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":["8920","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-08-05 16:39:45","2","2020-08-05 16:39:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:39: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":["8920","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-08-05 16:39:45","2","2020-08-05 16:39:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:39: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":["8920","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-08-05 16:39:45","2","2020-08-05 16:39:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:39: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":["8920","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-08-05 16:39:45","2","2020-08-05 16:39:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:39: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":["8920","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-08-05 16:39:45","2","2020-08-05 16:39:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:39: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":["8920","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-08-05 16:39:45","2","2020-08-05 16:39:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:39:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"8920"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-05 16:39: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":[754,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P208563","2020-08-05 16:39:45",3228,"2","2020-08-05 16:39:45","2","2020-08-05 16:39:45","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:39: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":["8563","DEPOSIT",null,"PAID","2020-08-05 16:39:45",0,"2","2020-08-05 16:39:45","2","2020-08-05 16:39:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:39: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":["8563","INVOICE","8920","PAID","2020-08-05 16:39:45",3228,"2","2020-08-05 16:39:45","2","2020-08-05 16:39:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:56: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":"","floor_plan_rent_room":[],"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> Y06 <\/td>\r\n\t\t\t\t\t 3X4X7 <\/td>\r\n\t\t\t\t\t $1090.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","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"Z014521(2)","title":"Mr","lastname":"SHIM","firstname":"Kwun Yue","companyname":"","email":"skyfish@hotmail.com","tel":"54843111","address":"20C, Block 2, University Heights Pokfiled Toad, Kennedy Town, Hong Kong","pass":true,"customer_id":"1701","customer_code":"C201701","customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"877","room_code":"Y06","retail_price":"1090.0","discounted_price":"1090.00","location_id":"3"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":1351,"deposit":3776,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":19988,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-08-10","rent_from":"2020-08-10","rent_to":"2021-08-09","delivery_service":"0","remark":"12 months contract. 50% off for the first 3 months. Deposit $500 paid by payme transfer on Jul 22.2020.The balance of storage rental and deposit $19488 paid by bank transfer on Aug 05,2020. Smart card provided by mail on the same day.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":19988,"final_order_total":19988,"location_id":"3","branch_id":"1","company_id":"1","room_key":"190,38721","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"1351.00","deposit":"3776.00","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:56:48","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","3","1701","NEW","A18-CT208592",1090,1351,3776,0,"12","12",19988,19988,19988,"2020-08-05 16:56:48","0",null,null,null,"2020-08-10","2021-08-09","12 months contract. 50% off for the first 3 months. Deposit $500 paid by payme transfer on Jul 22.2020.The balance of storage rental and deposit $19488 paid by bank transfer on Aug 05,2020. Smart card provided by mail on the same day.","2020-08-10","12",0,null,0,"0.00","2","2020-08-05 16:56:48","2","2020-08-05 16:56:48","BANKIN","","","","BANKIN","","","",null,0,"190,38721","C201701","PERSONAL","Mr","q8DvUqWcmm6W9Hgo61s5FA==","EeKU6QiKY39Ow+TFN4bRdw==","","T7gmIyNUxrFHsQQjJ5esusFqTyvyEejz7u9ZHkveNlB4nG76\/h3HSsVZgIpp7It02t6x6rlWS+Dl2qI4jAiqSSA\/CA2ZkX5rWIFJzj7C\/cM=","x9D8i4YI8D8iwitQ9xGbGQ==","IPvC1GHfnVh5eO5o+qCAa2sh\/Ah9noPtReEblgLwE6w=","H5yzxL\/TPLAE4PeLTfW9+w==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:56:48","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":["8592","877","1090.0","1090.00","2","2020-08-05 16:56:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:56:48","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-08-10","2021-08-09","877"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-05 16:56:48","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":["8592","A18-D205589","PAID",3776,0,"2021-08-09","2020-08-05 16:56:48","2020-08-05 16:56:48","2","2020-08-05 16:56:48","2","2020-08-05 16:56:48","1701"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:56:48","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":["8592","1701","SETTLED","A18-I208921","2020-08-05 16:56:48","2020-08-10","2","2020-08-05 16:56:48","2","2020-08-05 16:56:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:56:48","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":["8921","RENT","\u9810\u7e73\u79df\u91d1",1,1351,"MO","1",1351,"2","2020-08-05 16:56:48","2","2020-08-05 16:56:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:56:48","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":["8921","RENT","\u9810\u7e73\u79df\u91d1",2,1351,"MO","1",1351,"2","2020-08-05 16:56:48","2","2020-08-05 16:56:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:56:48","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":["8921","RENT","\u9810\u7e73\u79df\u91d1",3,1351,"MO","1",1351,"2","2020-08-05 16:56:48","2","2020-08-05 16:56:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:56:48","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":["8921","RENT","\u9810\u7e73\u79df\u91d1",4,1351,"MO","1",1351,"2","2020-08-05 16:56:48","2","2020-08-05 16:56:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:56:48","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":["8921","RENT","\u9810\u7e73\u79df\u91d1",5,1351,"MO","1",1351,"2","2020-08-05 16:56:48","2","2020-08-05 16:56:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:56:48","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":["8921","RENT","\u9810\u7e73\u79df\u91d1",6,1351,"MO","1",1351,"2","2020-08-05 16:56:48","2","2020-08-05 16:56:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:56:48","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":["8921","RENT","\u9810\u7e73\u79df\u91d1",7,1351,"MO","1",1351,"2","2020-08-05 16:56:48","2","2020-08-05 16:56:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:56:48","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":["8921","RENT","\u9810\u7e73\u79df\u91d1",8,1351,"MO","1",1351,"2","2020-08-05 16:56:48","2","2020-08-05 16:56:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:56:48","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":["8921","RENT","\u9810\u7e73\u79df\u91d1",9,1351,"MO","1",1351,"2","2020-08-05 16:56:48","2","2020-08-05 16:56:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:56:48","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":["8921","RENT","\u9810\u7e73\u79df\u91d1",10,1351,"MO","1",1351,"2","2020-08-05 16:56:48","2","2020-08-05 16:56:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:56:48","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":["8921","RENT","\u9810\u7e73\u79df\u91d1",11,1351,"MO","1",1351,"2","2020-08-05 16:56:48","2","2020-08-05 16:56:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:56:48","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":["8921","RENT","\u9810\u7e73\u79df\u91d1",12,1351,"MO","1",1351,"2","2020-08-05 16:56:48","2","2020-08-05 16:56:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:56:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[16212,0,"8921"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-05 16:56:48","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":["1701","BANKIN","","","","BANKIN","","","","PAID","P208564","2020-08-05 16:56:48",19988,"2","2020-08-05 16:56:48","2","2020-08-05 16:56:48","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:56:48","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":["8564","DEPOSIT","5589","PAID","2020-08-05 16:56:48",3776,"2","2020-08-05 16:56:48","2","2020-08-05 16:56:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 16:56:48","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":["8564","INVOICE","8921","PAID","2020-08-05 16:56:48",16212,"2","2020-08-05 16:56:48","2","2020-08-05 16:56:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 17:00:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 17:05:33","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","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":421,"customer_code":"C170421","identity_type":"PERSONAL","identity_id":"D707448(5)","title":"Ms","lastname":"Wong ","firstname":"Sin Ki","companyname":"","email":"christina@hosanna-logistics.com.hk","tel":"91416461","address":"Flat B, 7\/F, Block 13A, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1286.0","renew_rent_month":"1","renew_warehousing_date":"2020-07-10","renew_room_key":"055,19257","renew_remark":"1 months contract. Storage rental paid by bank transfer on JUNE 11, 2020. Storage deposit transferred from agreement A12-CT207500 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT208110, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"104","room_code":"B52","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1205,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3615,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-07-10","rent_from":"2020-07-10","rent_to":"2020-10-09","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on August 05, 2020. Storage deposit transferred from agreement A12-CT208110 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3615,"final_order_total":3615,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,19257","order_product":[],"pass":true}},"first_order_id":"4375","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> B52 <\/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":"1205.00","deposit":"0.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 17:05:33","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",421,"NEW","A12-CT208593",1528,1205,0,0,"3","3",3615,3615,3615,"2020-08-05 17:05:33","0",null,null,null,"2020-07-10","2020-10-09","3 months contract. Storage rental paid by bank transfer on August 05, 2020. Storage deposit transferred from agreement A12-CT208110 to this agreement.\r\n","2020-07-10","20",0,null,0,"0.00","2","2020-08-05 17:05:33","2","2020-08-05 17:05:33","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,19257","C170421","PERSONAL","Ms","Dk9bBvlTPdGIOfoj7ri85A==","DgLsCGM4faTvgwjKBW9M0A==","","IUtdGG37s++PUSJZlCWKuBwcM28OdF\/d0j1ZjFQeEmDgKryHJBNyu2CieqYiuU\/y+c+G1RIhRrB8umGMOsjJyQ==","7DiteIEa1DPNOaaxNkf4mA==","A8BZ7J\/yEFhvrC5fYB+XyBI8opG5QqCCAo9vuQjXgjk40k95i4FQnkejOoWjX3QX","dkR0lxZSK9Sd6ZEZ1+nFrA==",null,1,"4375"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 17:05:33","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":["8593","104","1528.0","1528.00","2","2020-08-05 17:05:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 17:05:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-10","2020-10-09","104"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-05 17:05:33","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":["8593",421,"SETTLED","A12-I208922","2020-08-05 17:05:33","2020-07-10","2","2020-08-05 17:05:33","2","2020-08-05 17:05:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 17:05:33","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":["8922","RENT","\u9810\u7e73\u79df\u91d1",1,1205,"MO","1",1205,"2","2020-08-05 17:05:33","2","2020-08-05 17:05:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 17:05:33","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":["8922","RENT","\u9810\u7e73\u79df\u91d1",2,1205,"MO","1",1205,"2","2020-08-05 17:05:33","2","2020-08-05 17:05:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 17:05:33","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":["8922","RENT","\u9810\u7e73\u79df\u91d1",3,1205,"MO","1",1205,"2","2020-08-05 17:05:33","2","2020-08-05 17:05:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 17:05:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3615,0,"8922"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-05 17:05:33","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":[421,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208565","2020-08-05 17:05:33",3615,"2","2020-08-05 17:05:33","2","2020-08-05 17:05:33","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 17:05:33","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":["8565","DEPOSIT",null,"PAID","2020-08-05 17:05:33",0,"2","2020-08-05 17:05:33","2","2020-08-05 17:05:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 17:05:33","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":["8565","INVOICE","8922","PAID","2020-08-05 17:05:33",3615,"2","2020-08-05 17:05:33","2","2020-08-05 17:05:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 17:14:13","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","190,38721","12 months contract. 50% off for the first 3 months. Deposit $500 paid by payme transfer on Jul 22.2020.The balance of storage rental and deposit $19488 paid by bank transfer on Aug 05,2020. Smart card provided by mail on the same day.","2020-08-05 17:14:13","2","EeKU6QiKY39Ow+TFN4bRdw==","q8DvUqWcmm6W9Hgo61s5FA==","IPvC1GHfnVh5eO5o+qCAa2sh\/Ah9noPtReEblgLwE6w=","x9D8i4YI8D8iwitQ9xGbGQ==","T7gmIyNUxrFHsQQjJ5esusFqTyvyEejz7u9ZHkveNlB4nG76\/h3HSsVZgIpp7It02t6x6rlWS+Dl2qI4jAiqSSA\/CA2ZkX5rWIFJzj7C\/cM=",8592]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 17:31:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:10:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:33:45","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:41:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:46:37","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","190, 39747","3 months contract. Storage rental and deposit $2102 and $798 paid by bank transfer on Aug 04, 2020. Smart card provided by mail on the same day.","2020-08-05 18:46:37","2","ch5RTqSd49z177L3nG78qg==","qCScY6UfjyMiGOl6hds7CA==","BqxqVWDZtJqkNU0pRZTy+PlD09FVGOlNnATGCYVwr8E=","GWFwLDpz\/r49PIuSeWz2Yw==","XC59fzvLvh9Hua2\/3uzH5ponY1HzIITYcavX7cDtyI8WuKy+AXIzQu6EWH73da7aoCmdA+odJZgOcuv9fo7HURADKE3V4dhW0TLmefw5N9lDBiHQ0HlsWSaCO98uJSMn",8585]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:54:00","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","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":"0","customer_id":"1700","customer_code":"C201700","identity_type":"PERSONAL","identity_id":"M258495(3)","title":"Mr","lastname":"YANG","firstname":"Diao","companyname":"","email":"skyd1933@aliyun.com","tel":"63129823","address":"Room 1805, 18\/F, Block C, Causeway Centre, No.28 Harbour Road, Wan Chai Hong Kong ","pass":true,"customer_first_order":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1945.0","renew_rent_month":"13","renew_warehousing_date":"2020-07-23","renew_room_key":"191,03256","renew_remark":"13 months contract. Special offer, 5% discount and one month free. Storage rental and deposit paid by cheque on June 19, 2019. Smartcard provided on June 19, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT195278, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $4322.0","renew_master_room_id":"118","order_discount":[],"order_room":[{"room_id":"822","room_code":"Q19","retail_price":"1.0","discounted_price":"1.00","location_id":"3"}],"roughly_size":"18","total_retail_price":1,"total_discounted_price":654,"deposit":1376,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3338,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-08-04","rent_from":"2020-08-04","rent_to":"2020-11-03","delivery_service":"0","remark":"3 months contract. Storage rental and deposit $2102 and $798 paid by bank transfer on Aug 04, 2020. $438 paid by bank transfer on Aug 05, 2020. Smart card provided by mail on the same day.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3338,"final_order_total":3338,"location_id":"3","branch_id":"1","company_id":"1","room_key":"190, 39747","order_product":[],"pass":true}},"first_order_id":5278,"selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\t\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\t\t\t\t \n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t \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> Q19 <\/td>\n\t\t\t\t\t 4X4.5X7 <\/td>\n\t\t\t\t\t $1.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","roughly_size":"18","total_discounted_price":"654.00","deposit":"1376.00","total_retail_price":"1.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:54:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3","1700","NEW","A18-CT208594",1,654,1376,0,"3","3",3338,3338,3338,"2020-08-05 18:54:01","0",null,null,null,"2020-08-04","2020-11-03","3 months contract. Storage rental and deposit $2102 and $798 paid by bank transfer on Aug 04, 2020. $438 paid by bank transfer on Aug 05, 2020. Smart card provided by mail on the same day.","2020-08-04","18",0,null,0,"0","2","2020-08-05 18:54:00","2","2020-08-05 18:54:00","BANKIN","","","","BANKIN","","","",null,0,"190, 39747","C201700","PERSONAL","Mr","qCScY6UfjyMiGOl6hds7CA==","ch5RTqSd49z177L3nG78qg==","","XC59fzvLvh9Hua2\/3uzH5ponY1HzIITYcavX7cDtyI8WuKy+AXIzQu6EWH73da7aoCmdA+odJZgOcuv9fo7HURADKE3V4dhW0TLmefw5N9lDBiHQ0HlsWSaCO98uJSMn","GWFwLDpz\/r49PIuSeWz2Yw==","BqxqVWDZtJqkNU0pRZTy+PlD09FVGOlNnATGCYVwr8E=","NGVeC21ox\/nD+jsQrlO9zA==",null,1,5278]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:54:01","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":["8594","822","1.0","1.00","2","2020-08-05 18:54:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:54:01","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-08-04","2020-11-03","822"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-05 18:54:01","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":["8594","A18-D205590","PAID",1376,0,"2020-11-03","2020-08-05 18:54:00","2020-08-05 18:54:00","2","2020-08-05 18:54:00","2","2020-08-05 18:54:00","1700"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:54:01","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":["8594","1700","SETTLED","A18-I208923","2020-08-05 18:54:00","2020-08-04","2","2020-08-05 18:54:00","2","2020-08-05 18:54:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:54:01","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":["8923","RENT","\u9810\u7e73\u79df\u91d1",1,654,"MO","1",654,"2","2020-08-05 18:54:00","2","2020-08-05 18:54:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:54:01","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":["8923","RENT","\u9810\u7e73\u79df\u91d1",2,654,"MO","1",654,"2","2020-08-05 18:54:00","2","2020-08-05 18:54:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:54:01","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":["8923","RENT","\u9810\u7e73\u79df\u91d1",3,654,"MO","1",654,"2","2020-08-05 18:54:00","2","2020-08-05 18:54:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:54:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1962,0,"8923"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-05 18:54:01","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":["1700","BANKIN","","","","BANKIN","","","","PAID","P208566","2020-08-05 18:54:00",3338,"2","2020-08-05 18:54:00","2","2020-08-05 18:54:00","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:54:01","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":["8566","DEPOSIT","5590","PAID","2020-08-05 18:54:00",1376,"2","2020-08-05 18:54:00","2","2020-08-05 18:54:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:54:01","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":["8566","INVOICE","8923","PAID","2020-08-05 18:54:00",1962,"2","2020-08-05 18:54:00","2","2020-08-05 18:54:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:55:07","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":"877","master_room_id":"77","room_code":"Y06"}],"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> Y06 <\/td>\r\n\t\t\t\t\t 3X4X7 <\/td>\r\n\t\t\t\t\t $1090.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","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"Z014521(2)","title":"Mr","lastname":"SHIM","firstname":"Kwun Yue","companyname":"","email":"skyfish@hotmail.com","tel":"54843111","address":"20C, Block 2, University Heights Pokfiled Toad, Kennedy Town, Hong Kong","pass":true,"customer_id":"1701","customer_code":"C201701","customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"877","room_code":"Y06","retail_price":"1090.0","discounted_price":"1090.00","location_id":"3"}],"roughly_size":"22","total_retail_price":1090,"total_discounted_price":1688,"deposit":3776,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":19988,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"4044.00","warehousing_date":"2020-08-10","rent_from":"2020-08-10","rent_to":"2021-08-09","delivery_service":"0","remark":"12 months contract. 50% off for the first 3 months. Deposit $500 paid by payme transfer on Jul 22.2020. The balance of storage rental and deposit $19488 paid by bank transfer on Aug 05,2020. Smart card provided by mail on the same day.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":4044,"order_total":24032,"final_order_total":19988,"location_id":"3","branch_id":"1","company_id":"1","room_key":"190,38721","order_product":[],"pass":true}},"roughly_size":"22","total_discounted_price":"1688.00","deposit":"3776.00","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:55:08","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","3","1701","NEW","A18-CT208595",1090,1688,3776,0,"12","12",19988,24032,19988,"2020-08-05 18:55:08","0",null,null,null,"2020-08-10","2021-08-09","12 months contract. 50% off for the first 3 months. Deposit $500 paid by payme transfer on Jul 22.2020. The balance of storage rental and deposit $19488 paid by bank transfer on Aug 05,2020. Smart card provided by mail on the same day.","2020-08-10","22",0,null,4044,"4044.00","2","2020-08-05 18:55:07","2","2020-08-05 18:55:07","BANKIN","","","","BANKIN","","","",null,0,"190,38721","C201701","PERSONAL","Mr","q8DvUqWcmm6W9Hgo61s5FA==","EeKU6QiKY39Ow+TFN4bRdw==","","T7gmIyNUxrFHsQQjJ5esusFqTyvyEejz7u9ZHkveNlB4nG76\/h3HSsVZgIpp7It02t6x6rlWS+Dl2qI4jAiqSSA\/CA2ZkX5rWIFJzj7C\/cM=","x9D8i4YI8D8iwitQ9xGbGQ==","IPvC1GHfnVh5eO5o+qCAa2sh\/Ah9noPtReEblgLwE6w=","H5yzxL\/TPLAE4PeLTfW9+w==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:55:08","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":["8595","877","1090.0","1090.00","2","2020-08-05 18:55:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:55:08","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-08-10","2021-08-09","877"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-08-05 18:55:08","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":["8595","A18-D205591","PAID",3776,0,"2021-08-09","2020-08-05 18:55:07","2020-08-05 18:55:07","2","2020-08-05 18:55:07","2","2020-08-05 18:55:07","1701"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:55:08","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":["8595","1701","SETTLED","A18-I208924","2020-08-05 18:55:07","2020-08-10","2","2020-08-05 18:55:07","2","2020-08-05 18:55:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:55:08","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":["8924","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-08-05 18:55:07","2","2020-08-05 18:55:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:55:08","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":["8924","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-08-05 18:55:07","2","2020-08-05 18:55:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:55:08","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":["8924","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,1020,"MO","1",1020,"2","2020-08-05 18:55:07","2","2020-08-05 18:55:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:55:08","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":["8924","RENT","\u9810\u7e73\u79df\u91d1",4,1688,"MO","1",1688,"2","2020-08-05 18:55:07","2","2020-08-05 18:55:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:55:08","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":["8924","RENT","\u9810\u7e73\u79df\u91d1",5,1688,"MO","1",1688,"2","2020-08-05 18:55:07","2","2020-08-05 18:55:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:55:08","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":["8924","RENT","\u9810\u7e73\u79df\u91d1",6,1688,"MO","1",1688,"2","2020-08-05 18:55:07","2","2020-08-05 18:55:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:55:08","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":["8924","RENT","\u9810\u7e73\u79df\u91d1",7,1688,"MO","1",1688,"2","2020-08-05 18:55:07","2","2020-08-05 18:55:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:55:08","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":["8924","RENT","\u9810\u7e73\u79df\u91d1",8,1688,"MO","1",1688,"2","2020-08-05 18:55:07","2","2020-08-05 18:55:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:55:08","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":["8924","RENT","\u9810\u7e73\u79df\u91d1",9,1688,"MO","1",1688,"2","2020-08-05 18:55:07","2","2020-08-05 18:55:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:55:08","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":["8924","RENT","\u9810\u7e73\u79df\u91d1",10,1688,"MO","1",1688,"2","2020-08-05 18:55:07","2","2020-08-05 18:55:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:55:08","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":["8924","RENT","\u9810\u7e73\u79df\u91d1",11,1688,"MO","1",1688,"2","2020-08-05 18:55:07","2","2020-08-05 18:55:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:55:08","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":["8924","RENT","\u9810\u7e73\u79df\u91d1",12,1688,"MO","1",1688,"2","2020-08-05 18:55:07","2","2020-08-05 18:55:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:55:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[16212,0,"8924"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-08-05 18:55:08","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":["1701","BANKIN","","","","BANKIN","","","","PAID","P208567","2020-08-05 18:55:07",19988,"2","2020-08-05 18:55:07","2","2020-08-05 18:55:07","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:55:08","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":["8567","DEPOSIT","5591","PAID","2020-08-05 18:55:07",3776,"2","2020-08-05 18:55:07","2","2020-08-05 18:55:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-08-05 18:55:08","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":["8567","INVOICE","8924","PAID","2020-08-05 18:55:07",16212,"2","2020-08-05 18:55:07","2","2020-08-05 18:55:07"]},"data_before":[],"data_after":[],"step":1} *****