{"created_at":"2020-01-20 09:53:35","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 10:07:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 11:27:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 11:51:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 12:33:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 13:46:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 13:56:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 14:04:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 14:25:48","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 14:33:22","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1179&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1507","master_room_id":"205","room_code":"A16-016"}],"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>
A16-016 <\/td>\r\n\t\t\t\t\t	4X6X7 <\/td>\r\n\t\t\t\t\t	$1857.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"K922593(0)","title":"Mr","lastname":"SIU","firstname":"Ho Tung Gerald Jr.","companyname":"","email":"mail@93292222.com","tel":"93292222","address":"3B Repulse Bay Towers, 119A Repulse Bay Road, Hong Kong","pass":true,"customer_id":"1489","customer_code":"C201489","customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1507","room_code":"A16-016","retail_price":"1857.0","discounted_price":"1857.00","location_id":"7"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1672,"deposit":3714,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":22770,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2680.00","warehousing_date":"2020-01-20","rent_from":"2020-01-20","rent_to":"2021-02-19","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free and 5% \"rent now\" discount. $500 storage deposit paid by PayMe on January 16, 2020. Remaining balance paid by bank transfer on January 17, 2020. Smartcard and padlock provided on January 20, 2020. ","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":2680,"order_total":25450,"final_order_total":22770,"location_id":"7","branch_id":"1","company_id":"1","room_key":"111,41192","order_product":[],"pass":true}},"roughly_size":"24","total_discounted_price":"1672.00","deposit":"3714.00","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 14:33:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7","1489","NEW","A16-CT207008",1857,1672,3714,0,"13","13",22770,25450,22770,"2020-01-20 14:33:23","0",null,null,null,"2020-01-20","2021-02-19","13 months contract. Special offer the 13th month free and 5% \"rent now\" discount. $500 storage deposit paid by PayMe on January 16, 2020. Remaining balance paid by bank transfer on January 17, 2020. Smartcard and padlock provided on January 20, 2020. ","2020-01-20","24",0,null,2680,"2680.00","2","2020-01-20 14:33:22","2","2020-01-20 14:33:22","BANKIN","","","","BANKIN","","","",null,0,"111,41192","C201489","PERSONAL","Mr","VWZUs9LfydOgVvGpEzQt\/+n7Yttm8uJE4MTUa\/IWrSs=","fwsebH2az17gKNdZ18K8Cg==","","v5egprKy0yBPcF4TjmPdku4Xad\/M78p2GOJoPkHfcFIUAbUfdDG83fhg17nWr+vLS4xwoQ21qZrkMPiBAzQsxw==","i5UNF+hORtbrMSTxurSRnA==","5rIdeQMBXq2gB2IZv5pLzoZ4BwK+3uKPKuj3XjSW2gM=","OS6XMnlF7T8Nc3uzK63XkQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 14:33:23","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":["7008","1507","1857.0","1857.00","2","2020-01-20 14:33:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 14:33:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-20","2021-02-19","1507"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-20 14:33:23","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":["7008","A16-D205260","PAID",3714,0,"2021-02-19","2020-01-20 14:33:22","2020-01-20 14:33:22","2","2020-01-20 14:33:22","2","2020-01-20 14:33:22","1489"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 14:33:23","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":["7008","1489","SETTLED","A16-I207336","2020-01-20 14:33:22","2020-01-20","2","2020-01-20 14:33:22","2","2020-01-20 14:33:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 14:33:23","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":["7336","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-01-20 14:33:22","2","2020-01-20 14:33:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 14:33:23","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":["7336","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,664,"MO","1",664,"2","2020-01-20 14:33:22","2","2020-01-20 14:33:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 14:33:23","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":["7336","RENT","\u9810\u7e73\u79df\u91d1",3,1672,"MO","1",1672,"2","2020-01-20 14:33:22","2","2020-01-20 14:33:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 14:33:23","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":["7336","RENT","\u9810\u7e73\u79df\u91d1",4,1672,"MO","1",1672,"2","2020-01-20 14:33:22","2","2020-01-20 14:33:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 14:33:23","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":["7336","RENT","\u9810\u7e73\u79df\u91d1",5,1672,"MO","1",1672,"2","2020-01-20 14:33:22","2","2020-01-20 14:33:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 14:33:23","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":["7336","RENT","\u9810\u7e73\u79df\u91d1",6,1672,"MO","1",1672,"2","2020-01-20 14:33:22","2","2020-01-20 14:33:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 14:33:23","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":["7336","RENT","\u9810\u7e73\u79df\u91d1",7,1672,"MO","1",1672,"2","2020-01-20 14:33:22","2","2020-01-20 14:33:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 14:33:23","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":["7336","RENT","\u9810\u7e73\u79df\u91d1",8,1672,"MO","1",1672,"2","2020-01-20 14:33:22","2","2020-01-20 14:33:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 14:33:23","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":["7336","RENT","\u9810\u7e73\u79df\u91d1",9,1672,"MO","1",1672,"2","2020-01-20 14:33:22","2","2020-01-20 14:33:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 14:33:23","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":["7336","RENT","\u9810\u7e73\u79df\u91d1",10,1672,"MO","1",1672,"2","2020-01-20 14:33:22","2","2020-01-20 14:33:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 14:33:23","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":["7336","RENT","\u9810\u7e73\u79df\u91d1",11,1672,"MO","1",1672,"2","2020-01-20 14:33:22","2","2020-01-20 14:33:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 14:33:23","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":["7336","RENT","\u9810\u7e73\u79df\u91d1",12,1672,"MO","1",1672,"2","2020-01-20 14:33:22","2","2020-01-20 14:33:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 14:33:23","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":["7336","RENT","\u9810\u7e73\u79df\u91d1",13,1672,"MO","1",1672,"2","2020-01-20 14:33:22","2","2020-01-20 14:33:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 14:33:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[19056,0,"7336"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-20 14:33:23","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":["1489","BANKIN","","","","BANKIN","","","","PAID","P206985","2020-01-20 14:33:22",22770,"2","2020-01-20 14:33:22","2","2020-01-20 14:33:22","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 14:33:23","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":["6985","DEPOSIT","5260","PAID","2020-01-20 14:33:22",3714,"2","2020-01-20 14:33:22","2","2020-01-20 14:33:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 14:33:23","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":["6985","INVOICE","7336","PAID","2020-01-20 14:33:22",19056,"2","2020-01-20 14:33:22","2","2020-01-20 14:33:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 14:51:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 14:56:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 15:09:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 15:14:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 15:18:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 15:20:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 16:09:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 16:14:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 16:15:00","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ?, `customer_companyname` = ? where id = ?","parameters":["NEW","0012522842","12 months contract. Special promotion offered, 2 months free of charge. Storage rental and deposit paid by Cheque on 18 JAN 2019. Smartcard provided on 18 JAN 2019.\r\n\u514d\u667a\u80fd\u9580\u5361\u548c\u5009\u9396\u5319","2020-01-20 16:15:00","2","+OMw4na84noO2Yxlmuy2lA==","CoUYtq1h8\/G9hWhlx0TFKA==","n4fzxoKJVVwTgp0VhG1pmjiE5DStXULnLXeK3mDJsvM=","jb9ffJd82Zr8xLw5JHXmyQ==","USpHHXGlS2J\/LZVBAz1s86eFQLcse6x4tnjah35SssQRcfJkeXeqCx4DXjZpItPM8MVA4adQh7Tp4simTQOC4s2dM2yU35sRrOdkmUPQwuktNDFmOlkc9\/8mNmRXcawdBq5nIRVL7QviJf9K2RhlVQ==","EAST METALS H.K. LIMITED",4198]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 16:23:11","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 16:47:53","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1179&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1507","master_room_id":"205","room_code":"A16-016"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":671,"customer_code":"C170671","identity_type":"PERSONAL","identity_id":"Z138538(1)","title":"Ms","lastname":"Tung","firstname":"Ji Yen Alexandra","companyname":"","email":"tungalex@gmail.com","tel":"25704477","address":"B4, Dragon View, 5 Dragon Terrace, Causeway Bay, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"934.0","renew_rent_month":"12","renew_warehousing_date":"2020-01-04","renew_room_key":"054,62898","renew_remark":"12 months contract. Storage rental paid by bank transfer on January 5, 2019. storage deposit transferred from agreement A18-CT182756 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT194113, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"77","order_discount":[],"order_room":[{"room_id":"862","room_code":"T06","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":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":11772,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"981.00","warehousing_date":"2020-01-04","rent_from":"2020-01-04","rent_to":"2021-02-03","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by bank transfer on January 20, 2020. Storage deposit transferred from agreement A18-CT194113 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":981,"order_total":12753,"final_order_total":11772,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,62898","order_product":[],"pass":true}},"first_order_id":4113,"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> T06 <\/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-01-20 16:47:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",671,"NEW","A18-CT207009",1090,981,0,0,"13","13",11772,12753,11772,"2020-01-20 16:47:53","0",null,null,null,"2020-01-04","2021-02-03","13 months contract. Special offer the 13th month free. Storage rental paid by bank transfer on January 20, 2020. Storage deposit transferred from agreement A18-CT194113 to this agreement.\r\n","2020-01-04","12",0,null,981,"981.00","2","2020-01-20 16:47:53","2","2020-01-20 16:47:53","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,62898","C170671","PERSONAL","Ms","Q28Y8wjSWkkQwNrK5zJEYV1e9gyaxILX\/+HIbhuh6\/w=","INIqO3p6N\/stXk+6gk8Omw==","","7BRxnCl3Pqi\/qavXNlqbEPcO9tgJBlWRIbU2e2syWYgoCihK8s2EkciBsnVoZgkCVn79x+8rO\/HPYxjIpY5rmA==","GTKZpMIPDYFuqg275fxvhw==","vetohuPeP0NRUjgkddmESpYtyeHwS3M6IN0f11De4Tk=","NsMy4oUdDrcmmKUWQ4Ym3Q==",null,1,4113]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 16:47:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7009","862","1090.0","1090.00","2","2020-01-20 16:47:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 16:47:53","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-04","2021-02-03","862"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-20 16:47:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7009",671,"SETTLED","A18-I207337","2020-01-20 16:47:53","2020-01-04","2","2020-01-20 16:47:53","2","2020-01-20 16:47:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 16:47:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7337","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,981,"MO","1",981,"2","2020-01-20 16:47:53","2","2020-01-20 16:47:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 16:47:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7337","RENT","\u9810\u7e73\u79df\u91d1",3,981,"MO","1",981,"2","2020-01-20 16:47:53","2","2020-01-20 16:47:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 16:47:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7337","RENT","\u9810\u7e73\u79df\u91d1",4,981,"MO","1",981,"2","2020-01-20 16:47:53","2","2020-01-20 16:47:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 16:47:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7337","RENT","\u9810\u7e73\u79df\u91d1",5,981,"MO","1",981,"2","2020-01-20 16:47:53","2","2020-01-20 16:47:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 16:47:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7337","RENT","\u9810\u7e73\u79df\u91d1",6,981,"MO","1",981,"2","2020-01-20 16:47:53","2","2020-01-20 16:47:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 16:47:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7337","RENT","\u9810\u7e73\u79df\u91d1",7,981,"MO","1",981,"2","2020-01-20 16:47:53","2","2020-01-20 16:47:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 16:47:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7337","RENT","\u9810\u7e73\u79df\u91d1",8,981,"MO","1",981,"2","2020-01-20 16:47:53","2","2020-01-20 16:47:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 16:47:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7337","RENT","\u9810\u7e73\u79df\u91d1",9,981,"MO","1",981,"2","2020-01-20 16:47:53","2","2020-01-20 16:47:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 16:47:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7337","RENT","\u9810\u7e73\u79df\u91d1",10,981,"MO","1",981,"2","2020-01-20 16:47:53","2","2020-01-20 16:47:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 16:47:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7337","RENT","\u9810\u7e73\u79df\u91d1",11,981,"MO","1",981,"2","2020-01-20 16:47:53","2","2020-01-20 16:47:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 16:47:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7337","RENT","\u9810\u7e73\u79df\u91d1",12,981,"MO","1",981,"2","2020-01-20 16:47:53","2","2020-01-20 16:47:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 16:47:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7337","RENT","\u9810\u7e73\u79df\u91d1",13,981,"MO","1",981,"2","2020-01-20 16:47:53","2","2020-01-20 16:47:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 16:47:53","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11772,0,"7337"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-20 16:47:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[671,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206986","2020-01-20 16:47:53",11772,"2","2020-01-20 16:47:53","2","2020-01-20 16:47:53","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 16:47:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6986","DEPOSIT",null,"PAID","2020-01-20 16:47:53",0,"2","2020-01-20 16:47:53","2","2020-01-20 16:47:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 16:47:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6986","INVOICE","7337","PAID","2020-01-20 16:47:53",11772,"2","2020-01-20 16:47:53","2","2020-01-20 16:47:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 17:02:36","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=721&filter3=undefined","floor_plan_rent_room":[{"room_id":"1507","master_room_id":"205","room_code":"A16-016"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":721,"customer_code":"C180721","identity_type":"PERSONAL","identity_id":"E991573(0)","title":"Ms","lastname":"Tse","firstname":"Sai Ying","companyname":"","email":"joannetse147@yahoo.com.hk","tel":"97240293","address":"Flat 1, 12\/F, Hoi Chu Court, Aberdeen Centre, Aberdeen, 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":"6","renew_warehousing_date":"2020-01-20","renew_room_key":"0003596643 054,57699","renew_remark":"6 months contract. Storage rental paid by bank transfer on July 28, 2019. Storage deposit transferred from agreement A05-CT194095 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT195576, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"113","order_discount":[],"order_room":[{"room_id":"1037","room_code":"A05-035","retail_price":"1090.0","discounted_price":"1090.00","location_id":"4"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":981,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":11772,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"981.00","warehousing_date":"2020-01-20","rent_from":"2020-01-20","rent_to":"2021-02-19","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by PPS on January 16, 2020. Storage deposit transferred from agreement A05-CT195576 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":981,"order_total":12753,"final_order_total":11772,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0003596643 054,57699","order_product":[],"pass":true}},"first_order_id":"4095","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-035 <\/td>\r\n\t\t\t\t\t 4X3X7 <\/td>\r\n\t\t\t\t\t $1090.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":"12","total_discounted_price":"981.00","deposit":"0.00","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 17:02:37","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",721,"NEW","A05-CT207010",1090,981,0,0,"13","13",11772,12753,11772,"2020-01-20 17:02:37","0",null,null,null,"2020-01-20","2021-02-19","13 months contract. Special offer the 13th month free. Storage rental paid by PPS on January 16, 2020. Storage deposit transferred from agreement A05-CT195576 to this agreement.","2020-01-20","12",0,null,981,"981.00","2","2020-01-20 17:02:36","2","2020-01-20 17:02:36","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0003596643 054,57699","C180721","PERSONAL","Ms","7c7LSFY0sbZ+ELB+WM+FqA==","JbA4gcU0oX0prLybEfuQ0g==","","Z9RU5eFNjXUj192+ToOlpULkPIS9GzwIsuxSf+CJcuWgby5vuNVTH2BHBUOMwN478yHQXnUkmMLxKVBIHg8a+\/LKtgp5oqfrzoMsOuCgTmc=","VOUshTs8CQhiRVHT0V2JbQ==","mPLu\/\/ZX6byBo9xKYV0dyLwVj8r7PogTYkrhkk7wPXw=","Y54tJy79wMcP5Y6VZwzKEw==",null,1,"4095"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 17:02:37","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":["7010","1037","1090.0","1090.00","2","2020-01-20 17:02:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 17:02:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-20","2021-02-19","1037"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-20 17:02:37","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":["7010",721,"SETTLED","A05-I207338","2020-01-20 17:02:36","2020-01-20","2","2020-01-20 17:02:36","2","2020-01-20 17:02:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 17:02:37","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":["7338","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,981,"MO","1",981,"2","2020-01-20 17:02:36","2","2020-01-20 17:02:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 17:02:37","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":["7338","RENT","\u9810\u7e73\u79df\u91d1",3,981,"MO","1",981,"2","2020-01-20 17:02:36","2","2020-01-20 17:02:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 17:02:37","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":["7338","RENT","\u9810\u7e73\u79df\u91d1",4,981,"MO","1",981,"2","2020-01-20 17:02:36","2","2020-01-20 17:02:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 17:02:37","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":["7338","RENT","\u9810\u7e73\u79df\u91d1",5,981,"MO","1",981,"2","2020-01-20 17:02:36","2","2020-01-20 17:02:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 17:02:37","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":["7338","RENT","\u9810\u7e73\u79df\u91d1",6,981,"MO","1",981,"2","2020-01-20 17:02:36","2","2020-01-20 17:02:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 17:02:37","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":["7338","RENT","\u9810\u7e73\u79df\u91d1",7,981,"MO","1",981,"2","2020-01-20 17:02:36","2","2020-01-20 17:02:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 17:02:37","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":["7338","RENT","\u9810\u7e73\u79df\u91d1",8,981,"MO","1",981,"2","2020-01-20 17:02:36","2","2020-01-20 17:02:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 17:02:37","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":["7338","RENT","\u9810\u7e73\u79df\u91d1",9,981,"MO","1",981,"2","2020-01-20 17:02:36","2","2020-01-20 17:02:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 17:02:37","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":["7338","RENT","\u9810\u7e73\u79df\u91d1",10,981,"MO","1",981,"2","2020-01-20 17:02:36","2","2020-01-20 17:02:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 17:02:37","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":["7338","RENT","\u9810\u7e73\u79df\u91d1",11,981,"MO","1",981,"2","2020-01-20 17:02:36","2","2020-01-20 17:02:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 17:02:37","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":["7338","RENT","\u9810\u7e73\u79df\u91d1",12,981,"MO","1",981,"2","2020-01-20 17:02:36","2","2020-01-20 17:02:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 17:02:37","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":["7338","RENT","\u9810\u7e73\u79df\u91d1",13,981,"MO","1",981,"2","2020-01-20 17:02:36","2","2020-01-20 17:02:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 17:02:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11772,0,"7338"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-20 17:02:37","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":[721,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P206987","2020-01-20 17:02:36",11772,"2","2020-01-20 17:02:36","2","2020-01-20 17:02:36","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 17:02:37","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":["6987","DEPOSIT",null,"PAID","2020-01-20 17:02:36",0,"2","2020-01-20 17:02:36","2","2020-01-20 17:02:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 17:02:37","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":["6987","INVOICE","7338","PAID","2020-01-20 17:02:36",11772,"2","2020-01-20 17:02:36","2","2020-01-20 17:02:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 17:10:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 17:12:32","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","189,28747","13 months contract. Special offer the 13th month free and 5% \"Rent Now\" discount. Storage rental and deposit paid by EPS on December 30, 2019. Smartcard and padlock provided on December 30, 2019. ","2020-01-20 17:12:32","2","nQ0P3urF7MQlYHXgjzt5kA==","nTGfHLdEIudAzJAvttiE\/g==","w6nqbYp32KQPR9iltH1kvGq1dJJ1F8pYDVS81YkNHVM=","F22NhsX0kJs0Lq\/6E61WEQ==","yxS3w8ydgZH0MWUcw0HMqoJCtRPPlhXlEKRtNR7F1r1PLmJ4\/ebuwJvX17ubYKoICaFjR99rfrmzd8DDq47z0kNveYzH4BEwVPzFM7tlzEw=",6809]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 17:17:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 17:51:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 17:56:41","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","191,03185","1 month contract. Special offer $4400\/mth. Storage rental and deposit paid by bank transfer on Oct 30,2019. Smartcard provided on Oct 30,2019.","2020-01-20 17:56:41","2","sFvIMVuF8ZsYisXFtwlNOg==","jvk7zrBnQZbXfX1dgEQlHe0RI1vs\/c8ofCzDIiHPduw=","WfnjLYwTfgHTPaehcdhvGWTDmhNfxmwxxekvQ0TBxrg=","WkO2u9lqQEjRnfUKLBy+6Q==","voDtSK9PGGTovDOARqXC4\/CqVs\/FW\/EFt+7Y8XgoNXnKX\/oYLjrZhZIszuJBDn5WLlxnxR+ombwIyw2An8MxBSJza\/jcybdtGn9ZStmQV6U=",6263]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 18:13:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 18:25:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 18:27: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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":272,"customer_code":"C170272","identity_type":"PERSONAL","identity_id":"Z807467(5)","title":"Mr","lastname":"Yip","firstname":"Chung Man","companyname":"","email":"markyip05@gmail.com","tel":"60741425","address":"Room 805,8\/F,Wah Yin Hse,Wah Kwai Est,HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"899.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-21","renew_room_key":"055,42838","renew_remark":"6 months contract. Storage rental paid by bank transfer on July 17, 2019. Storage deposit transferred from agreement A12-CT194181 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195503, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[{"master_room_discount_id":"70","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"898.60","discount":"9.96","monthly_deduct":99.4008,"room_id":"408","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"408","room_code":"H18","retail_price":"998.0","discounted_price":898.6,"location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":899,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5394,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-21","rent_from":"2020-01-21","rent_to":"2020-07-20","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on January 20, 2020. Storage deposit transferred from agreement A12-CT195503to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5394,"final_order_total":5394,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,42838","order_product":[],"pass":true}},"first_order_id":"4181","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> H18 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"899.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 18:27:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",272,"NEW","A12-CT207011",998,899,0,0,"6","6",5394,5394,5394,"2020-01-20 18:27:34","0",null,null,null,"2020-01-21","2020-07-20","6 months contract. Storage rental paid by bank transfer on January 20, 2020. Storage deposit transferred from agreement A12-CT195503to this agreement.\r\n","2020-01-21","12",0,null,0,"0","2","2020-01-20 18:27:33","2","2020-01-20 18:27:33","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,42838","C170272","PERSONAL","Mr","QD8pVcTButN\/77LR6NQPxQ==","H9gmHz05\/Te4s1\/V+q8XVg==","","iaVPZaTt40W47FdAhgjK9uJJ0se103YslVWE9Htmzsfa24sDxps0IR1RSNoEVCfV","r1r70SW3tdgqs3N\/0jfuRA==","+rQJv+XkJsYKOAjh6LKjIPjkql5yJIQFHULSzgHlJaU=","IiVjTgCi0zdCLuw6adCIVA==",null,1,"4181"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 18:27:34","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":["7011","70","6","408","%","9.96",99.4008,"2","2020-01-20 18:27:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 18:27:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7011","408","998.0",898.6,"2","2020-01-20 18:27:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 18:27:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-21","2020-07-20","408"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-20 18:27:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7011",272,"SETTLED","A12-I207339","2020-01-20 18:27:33","2020-01-21","2","2020-01-20 18:27:33","2","2020-01-20 18:27:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 18:27:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7339","RENT","\u9810\u7e73\u79df\u91d1",1,899,"MO","1",899,"2","2020-01-20 18:27:33","2","2020-01-20 18:27:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 18:27:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7339","RENT","\u9810\u7e73\u79df\u91d1",2,899,"MO","1",899,"2","2020-01-20 18:27:33","2","2020-01-20 18:27:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 18:27:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7339","RENT","\u9810\u7e73\u79df\u91d1",3,899,"MO","1",899,"2","2020-01-20 18:27:33","2","2020-01-20 18:27:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 18:27:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7339","RENT","\u9810\u7e73\u79df\u91d1",4,899,"MO","1",899,"2","2020-01-20 18:27:33","2","2020-01-20 18:27:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 18:27:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7339","RENT","\u9810\u7e73\u79df\u91d1",5,899,"MO","1",899,"2","2020-01-20 18:27:33","2","2020-01-20 18:27:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 18:27:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7339","RENT","\u9810\u7e73\u79df\u91d1",6,899,"MO","1",899,"2","2020-01-20 18:27:33","2","2020-01-20 18:27:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 18:27:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5394,0,"7339"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-20 18:27:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[272,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206988","2020-01-20 18:27:33",5394,"2","2020-01-20 18:27:33","2","2020-01-20 18:27:33","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 18:27:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6988","DEPOSIT",null,"PAID","2020-01-20 18:27:33",0,"2","2020-01-20 18:27:33","2","2020-01-20 18:27:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-20 18:27:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6988","INVOICE","7339","PAID","2020-01-20 18:27:33",5394,"2","2020-01-20 18:27:33","2","2020-01-20 18:27:33"]},"data_before":[],"data_after":[],"step":1} *****