\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>
S08 <\/td>\n\t\t\t\t\t	4X4X7 <\/td>\n\t\t\t\t\t	$1290.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\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":"1290.00","deposit":"2580.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 13:42:05","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":["C201668","PERSONAL","Mr","IFJznknx6dxYYha0iUJOUQ==","tvBroQ544rqjp41J\/9wlgQ==","","\/CUeJq+EDZmIZDV\/Ld5MeA==","gufkaQ2Ufnj6imDmUDMBd4rr\/dGi\/QVFBqG0tw2Wqdc=","u+mqQs1QPdF7TROd+RBPvwn7TicB8LSDT0gL7XHO+jQiVnhXn4f1st4YW70eGrhzwSiosM3htaHdlzZXdix65w==","AsPBRSHbwbXfc0NOH8mI6w==",null,"gufkaQ2Ufnj6imDmUDMBd4rr\/dGi\/QVFBqG0tw2Wqdc=","HUO4IM\/b3pbCR5ee8mh4nA==","2","2020-07-11 13:42:04","2","2020-07-11 13:42:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 13:42: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","1","3",1668,"NEW","A18-CT208379",1290,1290,2580,0,"12","12",14973,18060,14973,"2020-07-11 13:42:06","0",null,null,null,"2020-07-13","2021-07-12","12 months contract. Special offer 50% off for the first 3 months. Storage rental fee and deposit paid by EPS on Jul 11, 2020. Smartcard provided on the same day.","2020-07-13","16",0,null,3087,"3087.00","2","2020-07-11 13:42:04","2","2020-07-11 13:42:04","EPS","","","","EPS","","","",null,0,"","C201668","PERSONAL","Mr","IFJznknx6dxYYha0iUJOUQ==","tvBroQ544rqjp41J\/9wlgQ==","","u+mqQs1QPdF7TROd+RBPvwn7TicB8LSDT0gL7XHO+jQiVnhXn4f1st4YW70eGrhzwSiosM3htaHdlzZXdix65w==","\/CUeJq+EDZmIZDV\/Ld5MeA==","gufkaQ2Ufnj6imDmUDMBd4rr\/dGi\/QVFBqG0tw2Wqdc=","AsPBRSHbwbXfc0NOH8mI6w==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 13:42: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":["8379","849","1290.0","1290.00","2","2020-07-11 13:42:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 13:42: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-07-13","2021-07-12","849"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-11 13:42: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":["8379","A18-D205539","PAID",2580,0,"2021-07-12","2020-07-11 13:42:04","2020-07-11 13:42:04","2","2020-07-11 13:42:04","2","2020-07-11 13:42:04",1668]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 13:42: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":["8379",1668,"SETTLED","A18-I208708","2020-07-11 13:42:04","2020-07-13","2","2020-07-11 13:42:04","2","2020-07-11 13:42:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 13:42: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":["8708","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-07-11 13:42:04","2","2020-07-11 13:42:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 13:42: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":["8708","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-07-11 13:42:04","2","2020-07-11 13:42:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 13:42: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":["8708","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,783,"MO","1",783,"2","2020-07-11 13:42:04","2","2020-07-11 13:42:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 13:42: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":["8708","RENT","\u9810\u7e73\u79df\u91d1",4,1290,"MO","1",1290,"2","2020-07-11 13:42:04","2","2020-07-11 13:42:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 13:42: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":["8708","RENT","\u9810\u7e73\u79df\u91d1",5,1290,"MO","1",1290,"2","2020-07-11 13:42:04","2","2020-07-11 13:42:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 13:42: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":["8708","RENT","\u9810\u7e73\u79df\u91d1",6,1290,"MO","1",1290,"2","2020-07-11 13:42:04","2","2020-07-11 13:42:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 13:42: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":["8708","RENT","\u9810\u7e73\u79df\u91d1",7,1290,"MO","1",1290,"2","2020-07-11 13:42:04","2","2020-07-11 13:42:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 13:42: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":["8708","RENT","\u9810\u7e73\u79df\u91d1",8,1290,"MO","1",1290,"2","2020-07-11 13:42:04","2","2020-07-11 13:42:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 13:42: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":["8708","RENT","\u9810\u7e73\u79df\u91d1",9,1290,"MO","1",1290,"2","2020-07-11 13:42:04","2","2020-07-11 13:42:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 13:42: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":["8708","RENT","\u9810\u7e73\u79df\u91d1",10,1290,"MO","1",1290,"2","2020-07-11 13:42:04","2","2020-07-11 13:42:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 13:42: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":["8708","RENT","\u9810\u7e73\u79df\u91d1",11,1290,"MO","1",1290,"2","2020-07-11 13:42:04","2","2020-07-11 13:42:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 13:42: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":["8708","RENT","\u9810\u7e73\u79df\u91d1",12,1290,"MO","1",1290,"2","2020-07-11 13:42:04","2","2020-07-11 13:42:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 13:42:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[12393,0,"8708"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-11 13:42: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":[1668,"EPS","","","","EPS","","","","PAID","P208351","2020-07-11 13:42:04",14973,"2","2020-07-11 13:42:04","2","2020-07-11 13:42:04","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 13:42: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":["8351","DEPOSIT","5539","PAID","2020-07-11 13:42:04",2580,"2","2020-07-11 13:42:04","2","2020-07-11 13:42:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 13:42: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":["8351","INVOICE","8708","PAID","2020-07-11 13:42:04",12393,"2","2020-07-11 13:42:04","2","2020-07-11 13:42:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 13:51:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 14:25:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 14:25:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 14:33:47","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=986&filter3=undefined","floor_plan_rent_room":[{"room_id":"1328","master_room_id":"167","room_code":"C15-022"}],"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> C15-022 <\/td>\r\n\t\t\t\t\t 4X3X6.5 <\/td>\r\n\t\t\t\t\t $810.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"M464214(2)","title":"Mr","lastname":"MOROZ","firstname":"Alexander","companyname":"","email":"alex.moroz.hk@gmail.com","tel":"55315948","address":"294 King's Road, Fortress Hill","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"408","master_room_id":"167","discount_type":"%","price":"810.00","disocunted_price":"770.00","discount":"4.94","monthly_deduct":40.014,"room_id":"1328","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1328","room_code":"C15-022","retail_price":"810.0","discounted_price":770,"location_id":"6"}],"roughly_size":"12","total_retail_price":810,"total_discounted_price":770,"deposit":810,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3120,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-13","rent_from":"2020-07-13","rent_to":"2020-10-12","delivery_service":"0","remark":"3 months contract. Storage rental and deposit paid by EPS on Jul 11, 2020. Smart card provided on the same day.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":0,"order_total":3120,"final_order_total":3120,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012453396","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"770.00","deposit":"810.00","total_retail_price":"810.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 14:33:48","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":["C201669","PERSONAL","Mr","uTphChxZa2KpyCL3GnRFIw==","qLvwQmoyJjbnHvCwQbU7EQ==","","uxa8Ms9BcPq65sApZQQ3Cg==","kP0wHhbg8JHv7+husBf2nomz0dqxJQEQ+8HkHpqTNp0=","wIfWxzB7p3oAPQAXbgG3f1HdX4RcktVpV00xTfwIBBA=","oZPVEVkoUqWhoBz9Ae+VTQ==",null,"kP0wHhbg8JHv7+husBf2nomz0dqxJQEQ+8HkHpqTNp0=","zfF6lltK1RKR9IIEhKft7g==","2","2020-07-11 14:33:47","2","2020-07-11 14:33:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 14:33:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","3","6",1669,"NEW","C15-CT208380",810,770,810,0,"3","3",3120,3120,3120,"2020-07-11 14:33:49","0",null,null,null,"2020-07-13","2020-10-12","3 months contract. Storage rental and deposit paid by EPS on Jul 11, 2020. Smart card provided on the same day.","2020-07-13","12",0,null,0,"0","2","2020-07-11 14:33:47","2","2020-07-11 14:33:47","EPS","","","","EPS","","","",null,0,"'0012453396","C201669","PERSONAL","Mr","uTphChxZa2KpyCL3GnRFIw==","qLvwQmoyJjbnHvCwQbU7EQ==","","wIfWxzB7p3oAPQAXbgG3f1HdX4RcktVpV00xTfwIBBA=","uxa8Ms9BcPq65sApZQQ3Cg==","kP0wHhbg8JHv7+husBf2nomz0dqxJQEQ+8HkHpqTNp0=","oZPVEVkoUqWhoBz9Ae+VTQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 14:33:49","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":["8380","408","167","1328","%","4.94",40.014,"2","2020-07-11 14:33:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 14:33:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8380","1328","810.0",770,"2","2020-07-11 14:33:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 14:33:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-13","2020-10-12","1328"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-11 14:33:49","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":["8380","C15-D205540","PAID",810,0,"2020-10-12","2020-07-11 14:33:47","2020-07-11 14:33:47","2","2020-07-11 14:33:47","2","2020-07-11 14:33:47",1669]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 14:33:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8380",1669,"SETTLED","C15-I208709","2020-07-11 14:33:47","2020-07-13","2","2020-07-11 14:33:47","2","2020-07-11 14:33:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 14:33:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8709","RENT","\u9810\u7e73\u79df\u91d1",1,770,"MO","1",770,"2","2020-07-11 14:33:47","2","2020-07-11 14:33:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 14:33:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8709","RENT","\u9810\u7e73\u79df\u91d1",2,770,"MO","1",770,"2","2020-07-11 14:33:47","2","2020-07-11 14:33:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 14:33:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8709","RENT","\u9810\u7e73\u79df\u91d1",3,770,"MO","1",770,"2","2020-07-11 14:33:47","2","2020-07-11 14:33:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 14:33:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2310,0,"8709"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-11 14:33:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1669,"EPS","","","","EPS","","","","PAID","P208352","2020-07-11 14:33:47",3120,"2","2020-07-11 14:33:47","2","2020-07-11 14:33:47","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 14:33:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8352","DEPOSIT","5540","PAID","2020-07-11 14:33:47",810,"2","2020-07-11 14:33:47","2","2020-07-11 14:33:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 14:33:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8352","INVOICE","8709","PAID","2020-07-11 14:33:47",2310,"2","2020-07-11 14:33:47","2","2020-07-11 14:33:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 14:52:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 15:48:56","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1648","master_room_id":"210","room_code":"A16-157"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":722,"customer_code":"C180722","identity_type":"PERSONAL","identity_id":"A133698(6)","title":"Ms","lastname":"\u7f85","firstname":"\u9999","companyname":"","email":null,"tel":"93427793","address":"29A, Tower 17, South Horizons, Ap Lei Chau, H.K.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1162.0","renew_rent_month":"6","renew_warehousing_date":"2020-07-15","renew_room_key":"054,55445","renew_remark":"6 months contract. Storage rental paid by cash deposit on January 9, 2020. Storage deposit transferred from agreement A18-CT195507 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT206987, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[{"master_room_discount_id":"250","master_room_id":"91","discount_type":"%","price":"1290.00","disocunted_price":"1161.00","discount":"10.00","monthly_deduct":129,"room_id":"866","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"866","room_code":"T10","retail_price":"1290.0","discounted_price":1161,"location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6972,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-15","rent_from":"2020-07-15","rent_to":"2021-01-14","delivery_service":"0","remark":"6 months contract. Storage rental paid by EPS on Jul 11, 2020. Storage deposit transferred from agreement A18-CT206987 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":6972,"final_order_total":6972,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,55445","order_product":[],"pass":true}},"first_order_id":"4199","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> T10 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1162.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 15:48:57","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",722,"NEW","A18-CT208381",1290,1162,0,0,"6","6",6972,6972,6972,"2020-07-11 15:48:57","0",null,null,null,"2020-07-15","2021-01-14","6 months contract. Storage rental paid by EPS on Jul 11, 2020. Storage deposit transferred from agreement A18-CT206987 to this agreement.\r\n","2020-07-15","16",0,null,0,"0","2","2020-07-11 15:48:56","2","2020-07-11 15:48:56","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"054,55445","C180722","PERSONAL","Ms","PTwslGSpub9wDSFuSfDB6A==","UIh\/PML63l06OHzCxAIM8w==","","HJc4s+et2VEvm7xD0O4s5L4OJsMTv2SBuq5RQgSw8Wyw5+nIvt6pAznrp72KoaD8eUBoTVF042xCTRJJwbbhAA==","U\/vSjw1DZoYdGaaDKTEQDA==",null,"nKB5JRkOMmzP6BzoYGlN8w==",null,1,"4199"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 15:48:57","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":["8381","250","91","866","%","10.00",129,"2","2020-07-11 15:48:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 15:48:57","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":["8381","866","1290.0",1161,"2","2020-07-11 15:48:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 15:48:57","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-15","2021-01-14","866"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-11 15:48:57","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":["8381",722,"SETTLED","A18-I208710","2020-07-11 15:48:56","2020-07-15","2","2020-07-11 15:48:56","2","2020-07-11 15:48:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 15:48:57","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":["8710","RENT","\u9810\u7e73\u79df\u91d1",1,1162,"MO","1",1162,"2","2020-07-11 15:48:56","2","2020-07-11 15:48:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 15:48:57","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":["8710","RENT","\u9810\u7e73\u79df\u91d1",2,1162,"MO","1",1162,"2","2020-07-11 15:48:56","2","2020-07-11 15:48:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 15:48:57","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":["8710","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-07-11 15:48:56","2","2020-07-11 15:48:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 15:48:57","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":["8710","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-07-11 15:48:56","2","2020-07-11 15:48:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 15:48:57","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":["8710","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-07-11 15:48:56","2","2020-07-11 15:48:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 15:48:57","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":["8710","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-07-11 15:48:56","2","2020-07-11 15:48:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 15:48:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6972,0,"8710"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-11 15:48:57","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":[722,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P208353","2020-07-11 15:48:56",6972,"2","2020-07-11 15:48:56","2","2020-07-11 15:48:56","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 15:48:57","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":["8353","DEPOSIT",null,"PAID","2020-07-11 15:48:56",0,"2","2020-07-11 15:48:56","2","2020-07-11 15:48:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 15:48:57","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":["8353","INVOICE","8710","PAID","2020-07-11 15:48:56",6972,"2","2020-07-11 15:48:56","2","2020-07-11 15:48:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 15:53:25","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":[{"room_id":"1648","master_room_id":"210","room_code":"A16-157"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":722,"customer_code":"C180722","identity_type":"PERSONAL","identity_id":"A133698(6)","title":"Ms","lastname":"\u7f85","firstname":"\u9999","companyname":"","email":null,"tel":"93427793","address":"29A, Tower 17, South Horizons, Ap Lei Chau, H.K.","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1162.0","renew_rent_month":"6","renew_warehousing_date":"2021-01-15","renew_room_key":"054,55445","renew_remark":"6 months contract. Storage rental paid by EPS on Jul 11, 2020. Storage deposit transferred from agreement A18-CT206987 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT208381, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"866","room_code":"T10","retail_price":"1290.0","discounted_price":"1161.00","location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":2580,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-15","rent_from":"2020-07-15","rent_to":"2020-09-14","delivery_service":"0","remark":"2 months contract. Storage rental paid by EPS on Jul 11, 2020. Storage deposit transferred from agreement A18-CT206987 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":2580,"final_order_total":2580,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,55445","order_product":[],"pass":true}},"first_order_id":"4199","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> T10 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1290.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 15:53:26","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",722,"NEW","A18-CT208382",1290,1290,0,0,"2","2",2580,2580,2580,"2020-07-11 15:53:26","0",null,null,null,"2020-07-15","2020-09-14","2 months contract. Storage rental paid by EPS on Jul 11, 2020. Storage deposit transferred from agreement A18-CT206987 to this agreement.\r\n","2020-07-15","16",0,null,0,"0","2","2020-07-11 15:53:25","2","2020-07-11 15:53:25","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"054,55445","C180722","PERSONAL","Ms","PTwslGSpub9wDSFuSfDB6A==","UIh\/PML63l06OHzCxAIM8w==","","HJc4s+et2VEvm7xD0O4s5L4OJsMTv2SBuq5RQgSw8Wyw5+nIvt6pAznrp72KoaD8eUBoTVF042xCTRJJwbbhAA==","U\/vSjw1DZoYdGaaDKTEQDA==",null,"nKB5JRkOMmzP6BzoYGlN8w==",null,1,"4199"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 15:53:26","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":["8382","866","1290.0","1161.00","2","2020-07-11 15:53:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 15:53:26","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-15","2020-09-14","866"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-11 15:53:26","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":["8382",722,"SETTLED","A18-I208711","2020-07-11 15:53:25","2020-07-15","2","2020-07-11 15:53:25","2","2020-07-11 15:53:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 15:53:26","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":["8711","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-07-11 15:53:25","2","2020-07-11 15:53:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 15:53:26","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":["8711","RENT","\u9810\u7e73\u79df\u91d1",2,1290,"MO","1",1290,"2","2020-07-11 15:53:25","2","2020-07-11 15:53:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 15:53:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2580,0,"8711"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-11 15:53:26","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":[722,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P208354","2020-07-11 15:53:25",2580,"2","2020-07-11 15:53:25","2","2020-07-11 15:53:25","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 15:53:26","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":["8354","DEPOSIT",null,"PAID","2020-07-11 15:53:25",0,"2","2020-07-11 15:53:25","2","2020-07-11 15:53:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 15:53:26","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":["8354","INVOICE","8711","PAID","2020-07-11 15:53:25",2580,"2","2020-07-11 15:53:25","2","2020-07-11 15:53:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 16:05:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 16:05:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 16:10:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 16:38:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 17:02:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 17:20:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-11 18:13:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****