{"created_at":"2020-07-02 10:57:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:02:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:02:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:09: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","floor_plan_rent_room":[{"room_id":"1704","master_room_id":"202","room_code":"A16-213"}],"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-213 <\/td>\r\n\t\t\t\t\t	4X4X7 <\/td>\r\n\t\t\t\t\t	$1290.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\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":"D258003(A)","title":"Mr","lastname":"LUI","firstname":"Koon Kau","companyname":"","email":"Vincentlckui@hotmail.com","tel":"90919262","address":"Flat C, 14\/F, 38 Kennedy Town Praya, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1704","room_code":"A16-213","retail_price":"1290.0","discounted_price":"1290.00","location_id":"7"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1368,"deposit":2736,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":15436,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"5084.00","warehousing_date":"2020-07-06","rent_from":"2020-07-06","rent_to":"2021-08-05","delivery_service":"0","remark":"13 months contract. Special offer 50% off for the first 3 months and the 13th month free for the first contract. Storage rental and deposit paid by cheque on a Jul 2,2020. Smart card paid and provided on the same day.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":5084,"order_total":20580,"final_order_total":15496,"location_id":"7","branch_id":"1","company_id":"1","room_key":"\u20180012438324; \u20180005014269","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"pass":true}},"roughly_size":"16","total_discounted_price":"1368.00","deposit":"2736.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:09:38","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":["C201652","PERSONAL","Mr","b\/0TkiOUaAE8yFCvkw2q4A==","NX9r7kCwACTU3C1ZLG97rA==","","Bhl\/F5xZjTsc+rNTJiCLhA==","FyTz\/yrbXi2Zs1CECK8fV9p0n7FiF8h6yPrmRJloRy4=","BdykSYiEs7\/Ofrkyxf8qJg8q\/RsNsfX0LW1XC0XdC8Eeom6hfHwcwNUFH\/tcARax","txrViBxIbg9wuOcbBjolzw==",null,"FyTz\/yrbXi2Zs1CECK8fV9p0n7FiF8h6yPrmRJloRy4=","pK5W4MZ198uzaIG4mydKaw==","2","2020-07-02 11:09:36","2","2020-07-02 11:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:09:38","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",1652,"NEW","A16-CT208267",1290,1368,2736,0,"13","13",15436,20580,15496,"2020-07-02 11:09:38","0",null,null,null,"2020-07-06","2021-08-05","13 months contract. Special offer 50% off for the first 3 months and the 13th month free for the first contract. Storage rental and deposit paid by cheque on a Jul 2,2020. Smart card paid and provided on the same day.","2020-07-06","16",0,null,5084,"5084.00","2","2020-07-02 11:09:36","2","2020-07-02 11:09:36","CHEQUE","","","","CHEQUE","","","",null,0,"\u20180012438324; \u20180005014269","C201652","PERSONAL","Mr","b\/0TkiOUaAE8yFCvkw2q4A==","NX9r7kCwACTU3C1ZLG97rA==","","BdykSYiEs7\/Ofrkyxf8qJg8q\/RsNsfX0LW1XC0XdC8Eeom6hfHwcwNUFH\/tcARax","Bhl\/F5xZjTsc+rNTJiCLhA==","FyTz\/yrbXi2Zs1CECK8fV9p0n7FiF8h6yPrmRJloRy4=","txrViBxIbg9wuOcbBjolzw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:09:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8267",1652,"11","1","60.0",60,"2","2020-07-02 11:09:36","2","2020-07-02 11:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:09:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"8267"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-07-02 11:09:38","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":["8267","1704","1290.0","1290.00","2","2020-07-02 11:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:09:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-06","2021-08-05","1704"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-02 11:09:39","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":["8267","A16-D205515","PAID",2736,0,"2021-08-05","2020-07-02 11:09:36","2020-07-02 11:09:36","2","2020-07-02 11:09:36","2","2020-07-02 11:09:36",1652]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:09:39","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":["8267",1652,"SETTLED","A16-I208596","2020-07-02 11:09:36","2020-07-06","2","2020-07-02 11:09:36","2","2020-07-02 11:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:09:39","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":["8596","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-07-02 11:09:36","2","2020-07-02 11:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:09:39","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":["8596","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-07-02 11:09:36","2","2020-07-02 11:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:09:39","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":["8596","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,0,"MO","1",0,"2","2020-07-02 11:09:36","2","2020-07-02 11:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:09:39","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":["8596","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",4,388,"MO","1",388,"2","2020-07-02 11:09:36","2","2020-07-02 11:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:09:39","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":["8596","RENT","\u9810\u7e73\u79df\u91d1",5,1368,"MO","1",1368,"2","2020-07-02 11:09:36","2","2020-07-02 11:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:09:39","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":["8596","RENT","\u9810\u7e73\u79df\u91d1",6,1368,"MO","1",1368,"2","2020-07-02 11:09:36","2","2020-07-02 11:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:09:39","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":["8596","RENT","\u9810\u7e73\u79df\u91d1",7,1368,"MO","1",1368,"2","2020-07-02 11:09:36","2","2020-07-02 11:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:09:39","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":["8596","RENT","\u9810\u7e73\u79df\u91d1",8,1368,"MO","1",1368,"2","2020-07-02 11:09:36","2","2020-07-02 11:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:09:39","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":["8596","RENT","\u9810\u7e73\u79df\u91d1",9,1368,"MO","1",1368,"2","2020-07-02 11:09:36","2","2020-07-02 11:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:09:39","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":["8596","RENT","\u9810\u7e73\u79df\u91d1",10,1368,"MO","1",1368,"2","2020-07-02 11:09:36","2","2020-07-02 11:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:09:39","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":["8596","RENT","\u9810\u7e73\u79df\u91d1",11,1368,"MO","1",1368,"2","2020-07-02 11:09:36","2","2020-07-02 11:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:09:39","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":["8596","RENT","\u9810\u7e73\u79df\u91d1",12,1368,"MO","1",1368,"2","2020-07-02 11:09:36","2","2020-07-02 11:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:09:39","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":["8596","RENT","\u9810\u7e73\u79df\u91d1",13,1368,"MO","1",1368,"2","2020-07-02 11:09:36","2","2020-07-02 11:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:09:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8596","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-07-02 11:09:36","2","2020-07-02 11:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:09:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[12760,0,"8596"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-02 11:09:39","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":[1652,"CHEQUE","","","","CHEQUE","","","","PAID","P208239","2020-07-02 11:09:36",15496,"2","2020-07-02 11:09:36","2","2020-07-02 11:09:36","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:09:39","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":["8239","DEPOSIT","5515","PAID","2020-07-02 11:09:36",2736,"2","2020-07-02 11:09:36","2","2020-07-02 11:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:09:39","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":["8239","INVOICE","8596","PAID","2020-07-02 11:09:36",12760,"2","2020-07-02 11:09:36","2","2020-07-02 11:09:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:24:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:24:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:33:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:34:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 11:34:35","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:33:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:44:44","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":"","warehousing":{"1":{"new_customer":0,"identity_type":"PERSONAL","identity_id":"K474882(4)","title":"Mr","lastname":"Chau","firstname":"Pak Wing","companyname":"","email":"ryuchau2002@yahoo.com.hk","tel":"93430664","address":"3102 ,Tung Ping House Lei Tung Estate ,Aplei chau","pass":true,"customer_id":23,"customer_code":"C150023","customer_first_order":false},"2":{"order_discount":[],"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"2","renew_warehousing_date":"2020-06-01","renew_room_key":"054,43987","renew_remark":"2 months contract. Storage rental $2,074 paid by bank transfer on April 23, 2020. Remaining balance $2 transferred from A12-CT207302 to this agreement. Storage deposit transferred from agreement A12-CT207302 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207708, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_room":[{"room_id":"11","room_code":"A11","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1038,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":2076,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-01","rent_from":"2020-06-01","rent_to":"2020-07-31","delivery_service":"0","remark":"2 months contract. Storage rental paid by bank transfer on July 2, 2020. Storage deposit transferred from A12-CT207708 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2076,"final_order_total":2076,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,43987","order_product":[],"pass":true}},"renew":1,"first_order_id":"4412","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> A11 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:44:45","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",23,"NEW","A12-CT208268",1098,1038,0,0,"2","2",2076,2076,2076,"2020-07-02 13:44:45","0",null,null,null,"2020-06-01","2020-07-31","2 months contract. Storage rental paid by bank transfer on July 2, 2020. Storage deposit transferred from A12-CT207708 to this agreement. \r\n","2020-06-01","16",0,null,0,"0","2","2020-07-02 13:44:44","2","2020-07-02 13:44:44","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,43987","C150023","PERSONAL","Mr","B0ssw1oIHiki\/Mlb0\/ZDSA==","kOK3vHUlGE9qjoVnzYRDGA==","","PMBzwNQFgvH59lb5Tkl4pvuUMLbNYb\/kdCEBfa2Rd1BuIU1Im27uZJ2kVFx8y4u9KSaRxbwqsPYl3\/wAUgZh7A==","bdymBw6yNxCy25GcBqnAeg==","Yy\/IhnBFwxEgMvMojm6H7pEUv5uRc+ZriXItPiCRhkk=","rpqpQ1cQv7jbufDPn4zVZw==",null,1,"4412"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:44:45","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":["8268","11","1098.0","1098.00","2","2020-07-02 13:44:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:44:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-07-31","11"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-02 13:44:45","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":["8268",23,"SETTLED","A12-I208597","2020-07-02 13:44:44","2020-06-01","2","2020-07-02 13:44:44","2","2020-07-02 13:44:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:44:45","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":["8597","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-07-02 13:44:44","2","2020-07-02 13:44:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:44:45","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":["8597","RENT","\u9810\u7e73\u79df\u91d1",2,1038,"MO","1",1038,"2","2020-07-02 13:44:44","2","2020-07-02 13:44:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:44:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2076,0,"8597"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-02 13:44:45","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":[23,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208240","2020-07-02 13:44:44",2076,"2","2020-07-02 13:44:44","2","2020-07-02 13:44:44","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:44:45","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":["8240","DEPOSIT",null,"PAID","2020-07-02 13:44:44",0,"2","2020-07-02 13:44:44","2","2020-07-02 13:44:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:44:45","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":["8240","INVOICE","8597","PAID","2020-07-02 13:44:44",2076,"2","2020-07-02 13:44:44","2","2020-07-02 13:44:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:46:12","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1237,"customer_code":"C191237","identity_type":"PERSONAL","identity_id":"P559566(9)","title":"Ms","lastname":"Leung","firstname":"Fung Sin","companyname":"","email":"ann6811608@gmail.com","tel":"97780111","address":"DD 129 Lot Fu Cho Deep Bay Road, Lau Fo Shan, Yuen Long, New Territories","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-01","renew_room_key":"076,34910","renew_remark":"1 month contract. Storage rental paid by bank transfer on Apr 30, 2020. Deposit $1638 transferred from agreement A14-CT207572 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207756, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"690","room_code":"N07","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-01","rent_from":"2020-06-01","rent_to":"2020-06-30","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on July 2, 2020. Storage deposit transferred from agreement A14-CT207756 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,34910","order_product":[],"pass":true}},"first_order_id":"6047","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> N07 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:46:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",1237,"NEW","A14-CT208269",598,598,0,0,"1","1",598,598,598,"2020-07-02 13:46:12","0",null,null,null,"2020-06-01","2020-06-30","1 month contract. Storage rental paid by bank transfer on July 2, 2020. Storage deposit transferred from agreement A14-CT207756 to this agreement. \r\n","2020-06-01","12",0,null,0,"0","2","2020-07-02 13:46:12","2","2020-07-02 13:46:12","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,34910","C191237","PERSONAL","Ms","Mp1uQYBOKjCa3MjeNTcq3A==","xEf2h2aoyRQ71ZVgBH+9WQ==","","iW47FVp7s8TaEAMIorm0fGFj9skS6ydpaz9yZj+INMKJBmGfo988uGIjotbmyMfP2KQgH8yFjAojrqrHAGBn6MgcYUYvWbTLv+DzFp74hsI=","PTohJuR+UgjG7jslfxI4rw==","cH16fP4YQ5zYD3D2dgGxK3fdRCDVqpQpUvgIFEG73lQ=","8oqTJK9vVVGqI+5lGb64IA==",null,1,"6047"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:46:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8269","690","598.0","598.00","2","2020-07-02 13:46:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:46:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-06-30","690"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-02 13:46:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8269",1237,"SETTLED","A14-I208598","2020-07-02 13:46:12","2020-06-01","2","2020-07-02 13:46:12","2","2020-07-02 13:46:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:46:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8598","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-07-02 13:46:12","2","2020-07-02 13:46:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:46:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8598"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-02 13:46:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1237,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208241","2020-07-02 13:46:12",598,"2","2020-07-02 13:46:12","2","2020-07-02 13:46:12","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:46:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8241","DEPOSIT",null,"PAID","2020-07-02 13:46:12",0,"2","2020-07-02 13:46:12","2","2020-07-02 13:46:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:46:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8241","INVOICE","8598","PAID","2020-07-02 13:46:12",598,"2","2020-07-02 13:46:12","2","2020-07-02 13:46:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:48:05","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","092,18279","3 months contract. Storage rental paid by bank transfer on June 29, 2020. Storage deposit $5310 transferred from agreement A16-CT207523 to this agreement.","2020-07-02 13:48:05","2","Zzv1eRCimQisUlUlw\/fpjg==","aSBBtAs7bqfl5dV3rXfGGg==","Ab\/R2lan0QiDbiz1yaOXWb4qMLUpURe9bMyZ\/fyH\/H4=","pXFnlcoNY7GMI6BDQ45dxg==","h5v2Pg1mCLlXA0AVqqJe6SsiFmZQWsyMqFhy1J+Jon5aY0mQue9+rKOKV7fTKsoY","Asian Capital Partners (HK) Limited",8258]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:56:42","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":226,"customer_code":"C160226","identity_type":"PERSONAL","identity_id":"K763385(8)","title":"Mr","lastname":"Chan","firstname":"Ching Pong","companyname":"","email":"volvoc@netvigator.com","tel":"93330970","address":"Room 301, Pik Yuet House, Shek Pai Wan Estate, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1788.0","renew_rent_month":"12","renew_warehousing_date":"2020-07-06","renew_room_key":"052,42064","renew_remark":"12 months contract. Special renewal offer, $300 Maxim's Cake voucher offered. Storage rental paid by bank transfer on July 2, 2019. Storage deposit transferred from agreement A12-CT183987 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195370, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"14","order_discount":[{"master_room_discount_id":"85","master_room_id":"14","discount_type":"%","price":"2318.00","disocunted_price":"1926.50","discount":"16.89","monthly_deduct":391.5102,"room_id":"7","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"7","room_code":"A07","retail_price":"2318.0","discounted_price":1926.5,"location_id":"1"}],"roughly_size":"32","total_retail_price":2318,"total_discounted_price":1788,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":21456,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-06","rent_from":"2020-07-06","rent_to":"2021-07-05","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on July 2, 2020. Storage deposit transferred from agreement A12-CT195370 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":21456,"final_order_total":21456,"location_id":"1","branch_id":"1","company_id":"1","room_key":"052,42064","order_product":[],"pass":true}},"first_order_id":"3987","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> A07 <\/td>\r\n\t\t\t\t\t 4X8X8 <\/td>\r\n\t\t\t\t\t $2318.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":"32","total_discounted_price":"1788.0","deposit":"0","total_retail_price":"2318.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:56:42","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",226,"NEW","A12-CT208270",2318,1788,0,0,"12","12",21456,21456,21456,"2020-07-02 13:56:42","0",null,null,null,"2020-07-06","2021-07-05","12 months contract. Storage rental paid by bank transfer on July 2, 2020. Storage deposit transferred from agreement A12-CT195370 to this agreement.","2020-07-06","32",0,null,0,"0","2","2020-07-02 13:56:42","2","2020-07-02 13:56:42","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,42064","C160226","PERSONAL","Mr","njfS4ZZ0b8tQ+qVTmpL\/6Q==","U9yoE9KqV1v8YlRkf7Q2yg==","","yV0JysIU6kEfP4u6DJ9MNGNI6do5Z5BVda3y+\/YPPJcH4EBFXDSI2MoijJMpdSjOY3HRopCOZEZv0mMUodSh3Q==","Gy8BxZ75TVB3TH42ke0UNQ==","o77XJrG4ALAjRdDi2iyNlY58C2WNnF5V\/GDzorX\/ZHk=","CZq27ziN1itOlH6iz8j7Vw==",null,1,"3987"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:56:42","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":["8270","85","14","7","%","16.89",391.5102,"2","2020-07-02 13:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:56:42","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":["8270","7","2318.0",1926.5,"2","2020-07-02 13:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:56:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-06","2021-07-05","7"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-02 13:56:42","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":["8270",226,"SETTLED","A12-I208599","2020-07-02 13:56:42","2020-07-06","2","2020-07-02 13:56:42","2","2020-07-02 13:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:56:42","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":["8599","RENT","\u9810\u7e73\u79df\u91d1",1,1788,"MO","1",1788,"2","2020-07-02 13:56:42","2","2020-07-02 13:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:56:42","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":["8599","RENT","\u9810\u7e73\u79df\u91d1",2,1788,"MO","1",1788,"2","2020-07-02 13:56:42","2","2020-07-02 13:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:56:42","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":["8599","RENT","\u9810\u7e73\u79df\u91d1",3,1788,"MO","1",1788,"2","2020-07-02 13:56:42","2","2020-07-02 13:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:56:42","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":["8599","RENT","\u9810\u7e73\u79df\u91d1",4,1788,"MO","1",1788,"2","2020-07-02 13:56:42","2","2020-07-02 13:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:56:42","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":["8599","RENT","\u9810\u7e73\u79df\u91d1",5,1788,"MO","1",1788,"2","2020-07-02 13:56:42","2","2020-07-02 13:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:56:42","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":["8599","RENT","\u9810\u7e73\u79df\u91d1",6,1788,"MO","1",1788,"2","2020-07-02 13:56:42","2","2020-07-02 13:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:56:42","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":["8599","RENT","\u9810\u7e73\u79df\u91d1",7,1788,"MO","1",1788,"2","2020-07-02 13:56:42","2","2020-07-02 13:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:56:42","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":["8599","RENT","\u9810\u7e73\u79df\u91d1",8,1788,"MO","1",1788,"2","2020-07-02 13:56:42","2","2020-07-02 13:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:56:42","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":["8599","RENT","\u9810\u7e73\u79df\u91d1",9,1788,"MO","1",1788,"2","2020-07-02 13:56:42","2","2020-07-02 13:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:56:42","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":["8599","RENT","\u9810\u7e73\u79df\u91d1",10,1788,"MO","1",1788,"2","2020-07-02 13:56:42","2","2020-07-02 13:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:56:42","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":["8599","RENT","\u9810\u7e73\u79df\u91d1",11,1788,"MO","1",1788,"2","2020-07-02 13:56:42","2","2020-07-02 13:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:56:42","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":["8599","RENT","\u9810\u7e73\u79df\u91d1",12,1788,"MO","1",1788,"2","2020-07-02 13:56:42","2","2020-07-02 13:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:56:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[21456,0,"8599"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-02 13:56:42","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":[226,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208242","2020-07-02 13:56:42",21456,"2","2020-07-02 13:56:42","2","2020-07-02 13:56:42","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:56:42","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":["8242","DEPOSIT",null,"PAID","2020-07-02 13:56:42",0,"2","2020-07-02 13:56:42","2","2020-07-02 13:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:56:42","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":["8242","INVOICE","8599","PAID","2020-07-02 13:56:42",21456,"2","2020-07-02 13:56:42","2","2020-07-02 13:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:59:11","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":702,"customer_code":"C180702","identity_type":"PERSONAL","identity_id":"G034567(8)","title":"Mr","lastname":"Chum","firstname":"Kwok Leung Clement","companyname":"","email":"clementklchum@gmail.com","tel":"93332460","address":"Room 1403, Wah Shun House, Wah Fu Estate, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1445.0","renew_rent_month":"6","renew_warehousing_date":"2020-07-06","renew_room_key":"136,62564","renew_remark":"6 months contract. Storage rental paid by cheque deposit on January 4, 2020. Storage deposit transferred from agreement A18-CT195385 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT206870, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"78","order_discount":[{"master_room_discount_id":"254","master_room_id":"78","discount_type":"%","price":"1605.00","disocunted_price":"1444.50","discount":"10.00","monthly_deduct":160.5,"room_id":"910","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"910","room_code":"U11","retail_price":"1605.0","discounted_price":1444.5,"location_id":"3"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1445,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":8670,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-06","rent_from":"2020-07-06","rent_to":"2021-01-05","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on July 2, 2020. Storage deposit transferred from agreement A18-CT206870 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":8670,"final_order_total":8670,"location_id":"3","branch_id":"1","company_id":"1","room_key":"136,62564","order_product":[],"pass":true}},"first_order_id":"4058","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> U11 <\/td>\r\n\t\t\t\t\t 4X5X7 <\/td>\r\n\t\t\t\t\t $1605.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":"20","total_discounted_price":"1445.0","deposit":"0","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:59:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",702,"NEW","A18-CT208271",1605,1445,0,0,"6","6",8670,8670,8670,"2020-07-02 13:59:11","0",null,null,null,"2020-07-06","2021-01-05","6 months contract. Storage rental paid by bank transfer on July 2, 2020. Storage deposit transferred from agreement A18-CT206870 to this agreement.","2020-07-06","20",0,null,0,"0","2","2020-07-02 13:59:10","2","2020-07-02 13:59:10","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"136,62564","C180702","PERSONAL","Mr","qOBeY8pBdnZK7Wfi37j1Vc+wBUyTRpMiJdxfTxspOeY=","njl5Lx5qDFHpqhsximKa\/w==","","GcLlLlLemvn8j\/urkh17rLlKoLqySTMMvt2M953LUhlQjowYkpYdIVbx16A6\/eX60IIcmfvltSPsesv1T4L89g==","6xdSyD3MgYfUvphJ2qbRaw==","HU\/zNv3mqeyoHam1BSGa6KVCyrmviBCLA7MPth8wD2o=","uZhy+woih1UP5YA7yyH2Mg==",null,1,"4058"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:59:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["8271","254","78","910","%","10.00",160.5,"2","2020-07-02 13:59:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:59:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8271","910","1605.0",1444.5,"2","2020-07-02 13:59:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:59:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-06","2021-01-05","910"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-02 13:59:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8271",702,"SETTLED","A18-I208600","2020-07-02 13:59:10","2020-07-06","2","2020-07-02 13:59:10","2","2020-07-02 13:59:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:59:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8600","RENT","\u9810\u7e73\u79df\u91d1",1,1445,"MO","1",1445,"2","2020-07-02 13:59:10","2","2020-07-02 13:59:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:59:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8600","RENT","\u9810\u7e73\u79df\u91d1",2,1445,"MO","1",1445,"2","2020-07-02 13:59:10","2","2020-07-02 13:59:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:59:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8600","RENT","\u9810\u7e73\u79df\u91d1",3,1445,"MO","1",1445,"2","2020-07-02 13:59:10","2","2020-07-02 13:59:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:59:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8600","RENT","\u9810\u7e73\u79df\u91d1",4,1445,"MO","1",1445,"2","2020-07-02 13:59:10","2","2020-07-02 13:59:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:59:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8600","RENT","\u9810\u7e73\u79df\u91d1",5,1445,"MO","1",1445,"2","2020-07-02 13:59:10","2","2020-07-02 13:59:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:59:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8600","RENT","\u9810\u7e73\u79df\u91d1",6,1445,"MO","1",1445,"2","2020-07-02 13:59:10","2","2020-07-02 13:59:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:59:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8670,0,"8600"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-02 13:59:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[702,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208243","2020-07-02 13:59:10",8670,"2","2020-07-02 13:59:10","2","2020-07-02 13:59:10","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:59:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8243","DEPOSIT",null,"PAID","2020-07-02 13:59:10",0,"2","2020-07-02 13:59:10","2","2020-07-02 13:59:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 13:59:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8243","INVOICE","8600","PAID","2020-07-02 13:59:10",8670,"2","2020-07-02 13:59:10","2","2020-07-02 13:59:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 14:01:03","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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":60,"customer_code":"C160060","identity_type":"PERSONAL","identity_id":"G180394(7)","title":"Mr","lastname":"Cheung","firstname":"Hui Wah","companyname":"","email":"alfredcheung3@gmail.com","tel":"90833311","address":"Flat G ,18\/F.,Tower 13A, South Horizons Apleichau HK","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1788.0","renew_rent_month":"6","renew_warehousing_date":"2020-06-01","renew_room_key":"054,09131","renew_remark":"6 months contract. Storage rental paid by EPS on January 6, 2020. Storage deposit transferred from agreement A12-CT195818 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT206868, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"137","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"151","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"151","room_code":"C27","retail_price":"1098.0","discounted_price":989,"location_id":"1"},{"room_id":"137","room_code":"C13","retail_price":"1098.0","discounted_price":989,"location_id":"1"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":1788,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":10728,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-01","rent_from":"2020-06-01","rent_to":"2020-11-30","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on July 2, 2020. Storage deposit transferred from agreement A12-CT206868 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":10728,"final_order_total":10728,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,09131","order_product":[],"pass":true}},"first_order_id":"4525","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C27 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> C13 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"1788.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 14:01:04","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",60,"NEW","A12-CT208272",2196,1788,0,0,"6","6",10728,10728,10728,"2020-07-02 14:01:04","0",null,null,null,"2020-06-01","2020-11-30","6 months contract. Storage rental paid by bank transfer on July 2, 2020. Storage deposit transferred from agreement A12-CT206868 to this agreement.\r\n","2020-06-01","32",0,null,0,"0","2","2020-07-02 14:01:03","2","2020-07-02 14:01:03","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,09131","C160060","PERSONAL","Mr","\/81wQS3F2mq9tQdVdXB8cQ==","vCxOlXQuvOQaoL822H2o\/Q==","","\/ICHAfZJhtwhZA5reMeSD7Ws2wsSqn7PzAEiwMxgA6y0DiFZX4g\/0Hi97UBJg2b4PjRzZPL1+T0YPglHNUw4Tw==","8I7V5dQ3eccEOtZs3Vnu5g==","efc4ViIfxHNHVNeT8zMlq9zbhu2jG2\/nwizbHi8huYU=","O+jz4fRqyC29a5UiODe3sA==",null,1,"4525"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 14:01:04","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":["8272","72","8","137","%","9.93",109.0314,"2","2020-07-02 14:01:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 14:01:04","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":["8272","72","8","151","%","9.93",109.0314,"2","2020-07-02 14:01:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 14:01:04","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":["8272","151","1098.0",989,"2","2020-07-02 14:01:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 14:01:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-11-30","151"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-02 14:01:04","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":["8272","137","1098.0",989,"2","2020-07-02 14:01:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 14:01:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-11-30","137"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-02 14:01:04","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":["8272",60,"SETTLED","A12-I208601","2020-07-02 14:01:03","2020-06-01","2","2020-07-02 14:01:03","2","2020-07-02 14:01:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 14:01:04","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":["8601","RENT","\u9810\u7e73\u79df\u91d1",1,1788,"MO","1",1788,"2","2020-07-02 14:01:03","2","2020-07-02 14:01:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 14:01:04","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":["8601","RENT","\u9810\u7e73\u79df\u91d1",2,1788,"MO","1",1788,"2","2020-07-02 14:01:03","2","2020-07-02 14:01:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 14:01:04","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":["8601","RENT","\u9810\u7e73\u79df\u91d1",3,1788,"MO","1",1788,"2","2020-07-02 14:01:03","2","2020-07-02 14:01:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 14:01:04","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":["8601","RENT","\u9810\u7e73\u79df\u91d1",4,1788,"MO","1",1788,"2","2020-07-02 14:01:03","2","2020-07-02 14:01:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 14:01:04","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":["8601","RENT","\u9810\u7e73\u79df\u91d1",5,1788,"MO","1",1788,"2","2020-07-02 14:01:03","2","2020-07-02 14:01:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 14:01:04","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":["8601","RENT","\u9810\u7e73\u79df\u91d1",6,1788,"MO","1",1788,"2","2020-07-02 14:01:03","2","2020-07-02 14:01:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 14:01:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10728,0,"8601"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-02 14:01:04","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":[60,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208244","2020-07-02 14:01:03",10728,"2","2020-07-02 14:01:03","2","2020-07-02 14:01:03","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 14:01:04","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":["8244","DEPOSIT",null,"PAID","2020-07-02 14:01:03",0,"2","2020-07-02 14:01:03","2","2020-07-02 14:01:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 14:01:04","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":["8244","INVOICE","8601","PAID","2020-07-02 14:01:03",10728,"2","2020-07-02 14:01:03","2","2020-07-02 14:01:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 14:44:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 14:59:45","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 16:32:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 16:38: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","floor_plan_rent_room":[{"room_id":"1","master_room_id":"13","room_code":"A01"}],"index_url_parameter":"filter1=2&filter2=818&filter3=undefined&msg=%E5%8F%96%E6%B6%88","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> A01 <\/td>\r\n\t\t\t\t\t 4X7X8 <\/td>\r\n\t\t\t\t\t $2058.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"R095931(7)","title":"Mr","lastname":"Chan","firstname":"Chi Tak","companyname":"","email":"","tel":"69008280","address":"Room I, 15\/F, Hoi Tsing Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1","room_code":"A01","retail_price":"2058.0","discounted_price":"2058.00","location_id":"1"}],"roughly_size":"28","total_retail_price":2058,"total_discounted_price":2058,"deposit":4116,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":7203,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3087.00","warehousing_date":"2020-06-05","rent_from":"2020-06-05","rent_to":"2020-09-04","delivery_service":"0","remark":"3 months contract. Special offer 50% off. Storage rental and deposit paid by cash on July 2, 2020. ","paymethod":"CASH","paymethod2":"CASH","discount_deduct":3087,"order_total":10290,"final_order_total":7203,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190, 37118","order_product":[],"pass":true}},"roughly_size":"28","total_discounted_price":"2058.00","deposit":"4116.00","total_retail_price":"2058.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 16:38:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201653","PERSONAL","Mr","6kEvdBg9zGg5TDeiYf4BKw==","U9yoE9KqV1v8YlRkf7Q2yg==","","9TNgwUVUWhYLeCnR3G2qOQ==",null,"CNXbyhTnNIapzro6icAF3DXHSd76KHIfZBj+ZcWHITTZYCD\/x952b5WgRniN5Oz3ALT3Z5X0cyNjSgnOIif3y\/pfiwMZ6En10VpSXKkUwi8=","OnLQbbQxX++C7wngnQpgvg==",null,null,"2NWkPheD9nvh7WEkijpO2A==","2","2020-07-02 16:38:33","2","2020-07-02 16:38:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 16:38:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1",1653,"NEW","A12-CT208273",2058,2058,4116,0,"3","3",7203,10290,7203,"2020-07-02 16:38:35","0",null,null,null,"2020-06-05","2020-09-04","3 months contract. Special offer 50% off. Storage rental and deposit paid by cash on July 2, 2020. ","2020-06-05","28",0,null,3087,"3087.00","2","2020-07-02 16:38:33","2","2020-07-02 16:38:33","CASH","","","","CASH","","","",null,0,"190, 37118","C201653","PERSONAL","Mr","6kEvdBg9zGg5TDeiYf4BKw==","U9yoE9KqV1v8YlRkf7Q2yg==","","CNXbyhTnNIapzro6icAF3DXHSd76KHIfZBj+ZcWHITTZYCD\/x952b5WgRniN5Oz3ALT3Z5X0cyNjSgnOIif3y\/pfiwMZ6En10VpSXKkUwi8=","9TNgwUVUWhYLeCnR3G2qOQ==",null,"OnLQbbQxX++C7wngnQpgvg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 16:38:35","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":["8273","1","2058.0","2058.00","2","2020-07-02 16:38:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 16:38:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-05","2020-09-04","1"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-02 16:38:35","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":["8273","A12-D205516","PAID",4116,0,"2020-09-04","2020-07-02 16:38:33","2020-07-02 16:38:33","2","2020-07-02 16:38:33","2","2020-07-02 16:38:33",1653]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 16:38:35","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":["8273",1653,"SETTLED","A12-I208602","2020-07-02 16:38:33","2020-06-05","2","2020-07-02 16:38:33","2","2020-07-02 16:38:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 16:38:35","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":["8602","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-07-02 16:38:33","2","2020-07-02 16:38:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 16:38:35","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":["8602","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1029,"MO","1",1029,"2","2020-07-02 16:38:33","2","2020-07-02 16:38:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 16:38:35","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":["8602","RENT","\u9810\u7e73\u79df\u91d1",3,2058,"MO","1",2058,"2","2020-07-02 16:38:33","2","2020-07-02 16:38:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 16:38:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3087,0,"8602"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-02 16:38:35","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":[1653,"CASH","","","","CASH","","","","PAID","P208245","2020-07-02 16:38:33",7203,"2","2020-07-02 16:38:33","2","2020-07-02 16:38:33","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 16:38:35","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":["8245","DEPOSIT","5516","PAID","2020-07-02 16:38:33",4116,"2","2020-07-02 16:38:33","2","2020-07-02 16:38:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 16:38:35","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":["8245","INVOICE","8602","PAID","2020-07-02 16:38:33",3087,"2","2020-07-02 16:38:33","2","2020-07-02 16:38:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 16:45:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 16:47:06","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","\u20180012438325; \u20180005014269","13 months contract. Special offer 50% off for the first 3 months and the 13th month free for the first contract. Storage rental and deposit paid by cheque on a Jul 2,2020. Smart card paid and provided on the same day.","2020-07-02 16:47:06","2","NX9r7kCwACTU3C1ZLG97rA==","b\/0TkiOUaAE8yFCvkw2q4A==","RTk7meUGcvoVx2\/Jl7Banr9C9ZWYdWtAchHQElCJ8ys=","Bhl\/F5xZjTsc+rNTJiCLhA==","BdykSYiEs7\/Ofrkyxf8qJg8q\/RsNsfX0LW1XC0XdC8Eeom6hfHwcwNUFH\/tcARax",8267]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 16:49:55","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","189,29060","1 month contract. Storage deposit $8418 paid by bank transfer on May 27, 2019. Storage rental $8418 paid by bank transfer on June 14, 2019. Smartcard and padlock keys provided.","2020-07-02 16:49:55","2","7KCehmxbvwRMb+U8lHGoVA==","IyrQf6t6JfnW7BAmSp2D0A==","PZm75BriBKRZ9OGMGYU3sQ==","zL28W0XJvDd2rMjsvLBJGQ==","BflFHqfgX4Ci4okWTFhihGPiRCm6dCvblEg5CjAnC\/nCmwEKvNT2R1a6cvGgbLEfHIl4m+iTgE9EPIbi6kTwlw==","Le Quinze Vins ltd",5420]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 17:00:18","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 17:10:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 17:34:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 17:46: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","floor_plan_rent_room":[{"room_id":"1504","master_room_id":"205","room_code":"A16-013"}],"index_url_parameter":"filter1=2&filter2=818&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","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-013 <\/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":"1","identity_type":"PERSONAL","identity_id":"Z055044(3)","title":"Ms","lastname":"LEE","firstname":"Kin Yan Jenny","companyname":"","email":"","tel":"92318618","address":"Room 861, 17 Chi Fu Road, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1504","room_code":"A16-013","retail_price":"1857.0","discounted_price":"1857.00","location_id":"7"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1857,"deposit":3714,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":6500,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2785.00","warehousing_date":"2020-07-10","rent_from":"2020-07-10","rent_to":"2020-10-09","delivery_service":"0","remark":"3 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit paid by EPS on July 10, 2020. Smartcard provided on July 2, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":2785,"order_total":9285,"final_order_total":6500,"location_id":"7","branch_id":"1","company_id":"1","room_key":"189, 12078","order_product":[],"pass":true}},"roughly_size":"24","total_discounted_price":"1857.00","deposit":"3714.00","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 17:46:57","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":["C201654","PERSONAL","Ms","WnQNwTWtPN0NlkdSWDoYkA==","brgGVGuPrfoSjI4k+kLGow==","","BQOv3ZZA73v9+zkvYmirhQ==",null,"uqHU40jZTmynu\/PnWZP31hEMC1MxHAkGX01YHUOuxTBthB1OrGJQqjI4MKQ53e2y","9fjYTp5CZIG992Wt9dLg6Q==",null,null,"m6s5WgorTZFkKhP\/c5wHsA==","2","2020-07-02 17:46:56","2","2020-07-02 17:46:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 17:46:58","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",1654,"NEW","A16-CT208274",1857,1857,3714,0,"3","3",6500,9285,6500,"2020-07-02 17:46:58","0",null,null,null,"2020-07-10","2020-10-09","3 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit paid by EPS on July 10, 2020. Smartcard provided on July 2, 2020. ","2020-07-10","24",0,null,2785,"2785.00","2","2020-07-02 17:46:56","2","2020-07-02 17:46:56","EPS","","","","EPS","","","",null,0,"189, 12078","C201654","PERSONAL","Ms","WnQNwTWtPN0NlkdSWDoYkA==","brgGVGuPrfoSjI4k+kLGow==","","uqHU40jZTmynu\/PnWZP31hEMC1MxHAkGX01YHUOuxTBthB1OrGJQqjI4MKQ53e2y","BQOv3ZZA73v9+zkvYmirhQ==",null,"9fjYTp5CZIG992Wt9dLg6Q==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 17:46:58","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":["8274","1504","1857.0","1857.00","2","2020-07-02 17:46:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 17:46:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-10","2020-10-09","1504"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-02 17:46:58","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":["8274","A16-D205517","PAID",3714,0,"2020-10-09","2020-07-02 17:46:56","2020-07-02 17:46:56","2","2020-07-02 17:46:56","2","2020-07-02 17:46:56",1654]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 17:46:58","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":["8274",1654,"SETTLED","A16-I208603","2020-07-02 17:46:56","2020-07-10","2","2020-07-02 17:46:56","2","2020-07-02 17:46:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 17:46:58","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":["8603","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-07-02 17:46:56","2","2020-07-02 17:46:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 17:46:58","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":["8603","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,929,"MO","1",929,"2","2020-07-02 17:46:56","2","2020-07-02 17:46:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 17:46:58","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":["8603","RENT","\u9810\u7e73\u79df\u91d1",3,1857,"MO","1",1857,"2","2020-07-02 17:46:56","2","2020-07-02 17:46:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 17:46:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2786,0,"8603"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-02 17:46:58","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":[1654,"EPS","","","","EPS","","","","PAID","P208246","2020-07-02 17:46:56",6500,"2","2020-07-02 17:46:56","2","2020-07-02 17:46:56","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 17:46:58","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":["8246","DEPOSIT","5517","PAID","2020-07-02 17:46:56",3714,"2","2020-07-02 17:46:56","2","2020-07-02 17:46:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 17:46:58","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":["8246","INVOICE","8603","PAID","2020-07-02 17:46:56",2786,"2","2020-07-02 17:46:56","2","2020-07-02 17:46:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 18:30:09","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":685,"customer_code":"C180685","identity_type":"PERSONAL","identity_id":"Z136565(8)","title":"Mr","lastname":"Tam","firstname":"Wai Hung","companyname":"","email":null,"tel":"61102922","address":"Room 210, Wah Lai House, Wah Kwai Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2298.0","renew_rent_month":"1","renew_warehousing_date":"2020-07-01","renew_room_key":"053,56239","renew_remark":"1 month contract. Storage rental $2300 paid by cash on June 1, 2020. Storage deposit transferred from agreement A18-CT207767 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT208003, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"81","order_discount":[],"order_room":[{"room_id":"857","room_code":"T01","retail_price":"2298.0","discounted_price":"2298.00","location_id":"3"}],"roughly_size":"30","total_retail_price":2298,"total_discounted_price":2298,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2298,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-01","rent_from":"2020-07-01","rent_to":"2020-07-31","delivery_service":"0","remark":"1 month contract. Storage rental $2300 paid by bank transfer on June 02, 2020. Storage deposit transferred from agreement A18-CT208003 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2298,"final_order_total":2298,"location_id":"3","branch_id":"1","company_id":"1","room_key":"053,56239","order_product":[],"pass":true}},"first_order_id":"4879","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> T01 <\/td>\r\n\t\t\t\t\t 5X6X7 <\/td>\r\n\t\t\t\t\t $2298.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":"30","total_discounted_price":"2298.0","deposit":"0","total_retail_price":"2298.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 18:30:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",685,"NEW","A18-CT208275",2298,2298,0,0,"1","1",2298,2298,2298,"2020-07-02 18:30:09","0",null,null,null,"2020-07-01","2020-07-31","1 month contract. Storage rental $2300 paid by bank transfer on June 02, 2020. Storage deposit transferred from agreement A18-CT208003 to this agreement.","2020-07-01","30",0,null,0,"0","2","2020-07-02 18:30:08","2","2020-07-02 18:30:08","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"053,56239","C180685","PERSONAL","Mr","Vy30hO8KRRcWAyFHMj+GkQ==","RAqogkelEKt1q5b\/6Neu\/g==","","T1rrupXx2a84nbfDVVe7dRZNixC4wynq7dBDu6A1cSJX7dG0wQgUJ6ZUu1fBgxwDKFNAcVyti6Of6RFkiuBYCg==","\/abipioEOeirm5gkDUnYEA==",null,"HSRQWr1h55jzD6yUUsYl4g==",null,1,"4879"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 18:30:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8275","857","2298.0","2298.00","2","2020-07-02 18:30:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 18:30:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-01","2020-07-31","857"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-02 18:30:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8275",685,"SETTLED","A18-I208604","2020-07-02 18:30:08","2020-07-01","2","2020-07-02 18:30:08","2","2020-07-02 18:30:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 18:30:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8604","RENT","\u9810\u7e73\u79df\u91d1",1,2298,"MO","1",2298,"2","2020-07-02 18:30:08","2","2020-07-02 18:30:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 18:30:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2298,0,"8604"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-02 18:30:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[685,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208247","2020-07-02 18:30:08",2298,"2","2020-07-02 18:30:08","2","2020-07-02 18:30:08","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 18:30:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8247","DEPOSIT",null,"PAID","2020-07-02 18:30:08",0,"2","2020-07-02 18:30:08","2","2020-07-02 18:30:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 18:30:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8247","INVOICE","8604","PAID","2020-07-02 18:30:08",2298,"2","2020-07-02 18:30:08","2","2020-07-02 18:30:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 18:31:19","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","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":239,"customer_code":"C160239","identity_type":"PERSONAL","identity_id":"K149084(2)","title":"Ms","lastname":"Tam","firstname":"Amy Pui Kwan ","companyname":"","email":"aim_tam@yahoo.com.hk","tel":"98312061","address":"Apartment 3E,Excelsior Court,83 Robinson Road, Midlevels, Hong Kong.","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-07-24","renew_room_key":"055,16844","renew_remark":"6 months contract. Storage rental paid by bank transfer on February 29 and March 6, 2020. Storage deposit transferred from agreement A12-CT195846 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207342, \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":"399","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"399","room_code":"H09","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-07-24","rent_from":"2020-07-24","rent_to":"2021-01-23","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on July 02, 2020. Storage deposit transferred from agreement A12-CT207342 to this agreement.","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,16844","order_product":[],"pass":true}},"first_order_id":"4223","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> H09 <\/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-07-02 18:31:19","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",239,"NEW","A12-CT208276",998,899,0,0,"6","6",5394,5394,5394,"2020-07-02 18:31:19","0",null,null,null,"2020-07-24","2021-01-23","6 months contract. Storage rental paid by bank transfer on July 02, 2020. Storage deposit transferred from agreement A12-CT207342 to this agreement.","2020-07-24","12",0,null,0,"0","2","2020-07-02 18:31:19","2","2020-07-02 18:31:19","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,16844","C160239","PERSONAL","Ms","M5vdADLTBeiF29sUGkKK1w==","RAqogkelEKt1q5b\/6Neu\/g==","","QLHiRGHQriLojsMSHPCnflBkwJ22Np0\/xSSMDaRs2fLkzevfwx9h4YJ\/MjtmWX+5+lLXcgdINfh20qqhCugamQNw7VwgvbG4DNl0cMf4u7Y=","nGEvjnwo2UYVNM8WTcV0aQ==","V1MZpux\/uUnoXj1E6gpMBMg58cUgvmD8SomqXE9M9YE=","X81avobeHvzbxPDOS9C4IA==",null,1,"4223"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 18:31:19","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":["8276","70","6","399","%","9.96",99.4008,"2","2020-07-02 18:31:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 18:31:19","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":["8276","399","998.0",898.6,"2","2020-07-02 18:31:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 18:31:19","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-24","2021-01-23","399"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-02 18:31:19","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":["8276",239,"SETTLED","A12-I208605","2020-07-02 18:31:19","2020-07-24","2","2020-07-02 18:31:19","2","2020-07-02 18:31:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 18:31:19","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":["8605","RENT","\u9810\u7e73\u79df\u91d1",1,899,"MO","1",899,"2","2020-07-02 18:31:19","2","2020-07-02 18:31:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 18:31:19","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":["8605","RENT","\u9810\u7e73\u79df\u91d1",2,899,"MO","1",899,"2","2020-07-02 18:31:19","2","2020-07-02 18:31:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 18:31:19","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":["8605","RENT","\u9810\u7e73\u79df\u91d1",3,899,"MO","1",899,"2","2020-07-02 18:31:19","2","2020-07-02 18:31:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 18:31:19","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":["8605","RENT","\u9810\u7e73\u79df\u91d1",4,899,"MO","1",899,"2","2020-07-02 18:31:19","2","2020-07-02 18:31:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 18:31:19","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":["8605","RENT","\u9810\u7e73\u79df\u91d1",5,899,"MO","1",899,"2","2020-07-02 18:31:19","2","2020-07-02 18:31:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 18:31:19","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":["8605","RENT","\u9810\u7e73\u79df\u91d1",6,899,"MO","1",899,"2","2020-07-02 18:31:19","2","2020-07-02 18:31:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 18:31:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5394,0,"8605"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-02 18:31:19","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":[239,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208248","2020-07-02 18:31:19",5394,"2","2020-07-02 18:31:19","2","2020-07-02 18:31:19","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 18:31:19","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":["8248","DEPOSIT",null,"PAID","2020-07-02 18:31:19",0,"2","2020-07-02 18:31:19","2","2020-07-02 18:31:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 18:31:19","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":["8248","INVOICE","8605","PAID","2020-07-02 18:31:19",5394,"2","2020-07-02 18:31:19","2","2020-07-02 18:31:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 18:57:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 19:13:58","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1231,"customer_code":"C191231","identity_type":"BUSINESS","identity_id":"63137444-000-04-19-9","title":"Mr","lastname":"LEUNG","firstname":"Siu Hung","companyname":"E-Board Construction Limited","email":"hung91940040@yahoo.com.hk","tel":"91940040","address":"Room 606, Tsui Ning House, Tsui Wan Estate, Chai Wan, Hong Kong.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"684.0","renew_rent_month":"3","renew_warehousing_date":"2020-06-26","renew_room_key":"'0012465782","renew_remark":"3 months contract. Storage rental paid by bank transfer on Apr 08,2020. Deposit $720 transferred from agreement C15-CT207019 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT207582, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"159","order_discount":[{"master_room_discount_id":"411","master_room_id":"159","discount_type":"%","price":"720.00","disocunted_price":"684.00","discount":"5.00","monthly_deduct":36,"room_id":"1400","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1400","room_code":"C15-094","retail_price":"720.0","discounted_price":684,"location_id":"6"}],"roughly_size":"9","total_retail_price":720,"total_discounted_price":684,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2052,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-26","rent_from":"2020-06-26","rent_to":"2020-09-25","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on Jul 02,2020. Deposit $720 transferred from agreement C15-CT207582 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2052,"final_order_total":2052,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012465782","order_product":[],"pass":true}},"first_order_id":"4648","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> C15-094 <\/td>\r\n\t\t\t\t\t 3X3X6.5 <\/td>\r\n\t\t\t\t\t $720.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":"9","total_discounted_price":"684.0","deposit":"0","total_retail_price":"720.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 19:13:58","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","3","6",1231,"NEW","C15-CT208277",720,684,0,0,"3","3",2052,2052,2052,"2020-07-02 19:13:58","0",null,null,null,"2020-06-26","2020-09-25","3 months contract. Storage rental paid by bank transfer on Jul 02,2020. Deposit $720 transferred from agreement C15-CT207582 to this agreement.","2020-06-26","9",0,null,0,"0","2","2020-07-02 19:13:58","2","2020-07-02 19:13:58","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0012465782","C191231","BUSINESS","Mr","cKQuXkw+QX5W9kWyedDIMQ==","yXKc2lCF323ApRADrjNaSg==","E-Board Construction Limited","mUajGax6tlCJpSmxJm6NqFr6L52xbXs2tmmlNxzVvGLfYqKtndbhVPfWdP78Qr\/Kep+QxPBCaHSKiWPK7elr1iQMxnXx+e6KPIeRRwScI8Y=","AuUPgOiCb57sL53kxfWXZw==","neD4RJ9Xps0JfAJm4eyVSwJjZSuQzyU927SqmEYs2xE=",null,"r4Yf8AUupRy8x6rdET56NMVu61ggTOBt7kcj9DUHePc=",1,"4648"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 19:13:58","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":["8277","411","159","1400","%","5.00",36,"2","2020-07-02 19:13:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 19:13:58","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":["8277","1400","720.0",684,"2","2020-07-02 19:13:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 19:13:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-26","2020-09-25","1400"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-02 19:13:58","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":["8277",1231,"SETTLED","C15-I208606","2020-07-02 19:13:58","2020-06-26","2","2020-07-02 19:13:58","2","2020-07-02 19:13:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 19:13:58","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":["8606","RENT","\u9810\u7e73\u79df\u91d1",1,684,"MO","1",684,"2","2020-07-02 19:13:58","2","2020-07-02 19:13:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 19:13:58","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":["8606","RENT","\u9810\u7e73\u79df\u91d1",2,684,"MO","1",684,"2","2020-07-02 19:13:58","2","2020-07-02 19:13:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 19:13:58","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":["8606","RENT","\u9810\u7e73\u79df\u91d1",3,684,"MO","1",684,"2","2020-07-02 19:13:58","2","2020-07-02 19:13:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 19:13:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2052,0,"8606"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-02 19:13:58","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":[1231,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208249","2020-07-02 19:13:58",2052,"2","2020-07-02 19:13:58","2","2020-07-02 19:13:58","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 19:13:58","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":["8249","DEPOSIT",null,"PAID","2020-07-02 19:13:58",0,"2","2020-07-02 19:13:58","2","2020-07-02 19:13:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 19:13:58","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":["8249","INVOICE","8606","PAID","2020-07-02 19:13:58",2052,"2","2020-07-02 19:13:58","2","2020-07-02 19:13:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 19:20:20","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":423,"customer_code":"C170423","identity_type":"PERSONAL","identity_id":"E417712(A)","title":"Mrs","lastname":"Kwok Shiu","firstname":"Siu Lay Shirley","companyname":"","email":"se-kwok@hotmail.com","tel":"91904490","address":"18B, 52 Mount Davis Rd ,Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1528.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-25","renew_room_key":"055,32590","renew_remark":"1 month contract. Storage rental paid by bank transfer on May 29, 2020. Storage deposit transferred from agreement A14-CT207900 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT208011, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"38","order_discount":[],"order_room":[{"room_id":"449","room_code":"J31","retail_price":"1528.0","discounted_price":"1528.00","location_id":"2"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1528,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1528,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-25","rent_from":"2020-06-25","rent_to":"2020-07-24","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on June 27, 2020. Storage deposit transferred from agreement A14-CT208011 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1528,"final_order_total":1528,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,32590","order_product":[],"pass":true}},"first_order_id":"4833","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> J31 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1528.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 19:20:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",423,"NEW","A14-CT208278",1528,1528,0,0,"1","1",1528,1528,1528,"2020-07-02 19:20:21","0",null,null,null,"2020-06-25","2020-07-24","1 month contract. Storage rental paid by bank transfer on June 27, 2020. Storage deposit transferred from agreement A14-CT208011 to this agreement.","2020-06-25","20",0,null,0,"0","2","2020-07-02 19:20:20","2","2020-07-02 19:20:20","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,32590","C170423","PERSONAL","Mrs","+cSauOfzf4UKH6i9E\/o3Ow==","9BE1lGM5+6cl7FB3cBYT\/Q==","","QuHHgcx1ghORfe6aPTL+cwHs9gJpW87+Y84Si6oTDbtaPpyzLd7Q86Xo4RoVzL1i","uWe4YUxvL5KuigFTIBklFw==","CBE2gpTh\/+LjBRyyCUBxTx7oEtKfkCZ0NTTPgR4mc0Q=","I\/c6FTBu+Cf57wsquAGAzA==",null,1,"4833"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 19:20:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8278","449","1528.0","1528.00","2","2020-07-02 19:20:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 19:20:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-25","2020-07-24","449"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-02 19:20:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8278",423,"SETTLED","A14-I208607","2020-07-02 19:20:20","2020-06-25","2","2020-07-02 19:20:20","2","2020-07-02 19:20:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 19:20:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8607","RENT","\u9810\u7e73\u79df\u91d1",1,1528,"MO","1",1528,"2","2020-07-02 19:20:20","2","2020-07-02 19:20:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 19:20:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1528,0,"8607"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-02 19:20:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[423,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208250","2020-07-02 19:20:20",1528,"2","2020-07-02 19:20:20","2","2020-07-02 19:20:20","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 19:20:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8250","DEPOSIT",null,"PAID","2020-07-02 19:20:20",0,"2","2020-07-02 19:20:20","2","2020-07-02 19:20:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-02 19:20:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8250","INVOICE","8607","PAID","2020-07-02 19:20:20",1528,"2","2020-07-02 19:20:20","2","2020-07-02 19:20:20"]},"data_before":[],"data_after":[],"step":1} *****