{"created_at":"2020-05-22 10:09:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 10:48:52","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1747","master_room_id":"232","room_code":"WC-22"}],"_payment_type":"INVOICE","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>
WC-22 <\/td>\r\n\t\t\t\t\t	2.5X2.5X4 <\/td>\r\n\t\t\t\t\t	$798.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":"M088787(6)","title":"Mr","lastname":"WILLIAMS","firstname":"Alexander Ackerl","companyname":"","email":"alexwilliams88@gmail.com","tel":"96884261","address":"2808 China Resources Building, 26 Harbour Road, Wan Chai, H.K.","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1747","room_code":"WC-22","retail_price":"798.0","discounted_price":"798.00","location_id":"8"}],"roughly_size":"6.25","total_retail_price":798,"total_discounted_price":798,"deposit":1596,"rent_month":"14","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"14","prepaid_amount":11172,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1596.00","warehousing_date":"2020-05-22","rent_from":"2020-05-22","rent_to":"2021-07-21","delivery_service":"0","remark":"14 months contract. Special offer the 13th & 14th months free. Storage rental and deposit paid by EPS on May 22, 2020. Access card and password lock provided on May 22, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":1596,"order_total":12768,"final_order_total":11172,"location_id":"8","branch_id":"1","company_id":"1","room_key":"190, 40543","order_product":[],"pass":true}},"roughly_size":"6.25","total_discounted_price":"798.00","deposit":"1596.00","total_retail_price":"798.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 10:48:53","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":["C201587","PERSONAL","Mr","HOc7mXovV77WybUL\/yFT9nidmeCwVnaVNJscZzr2svg=","nHj9qHmAi0HhE6EYu7cSig==","","azCy8ft1G8cIjHhQdx4R8Q==","FZVlfDOu7EIxqsDknyOtJZFhXPqHbOU3qiLm2k8v3V4=","5bZ\/4fQ6Ho9SHhG6vZYHxfbLYLAgNHkSh+U6i2ojGkY3oE6HaDLYbqwvIreAb4QHdDWuLst8ak+Sg1gUHIYRnw==","+yW+ljDLQjwTZ865j8SyBQ==",null,"FZVlfDOu7EIxqsDknyOtJZFhXPqHbOU3qiLm2k8v3V4=","cHXBPlJRr1hceXsBY1uZaA==","2","2020-05-22 10:48:52","2","2020-05-22 10:48:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 10:48:54","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","8",1587,"NEW","WC-CT207922",798,798,1596,0,"14","14",11172,12768,11172,"2020-05-22 10:48:54","0",null,null,null,"2020-05-22","2021-07-21","14 months contract. Special offer the 13th & 14th months free. Storage rental and deposit paid by EPS on May 22, 2020. Access card and password lock provided on May 22, 2020. ","2020-05-22","6.25",0,null,1596,"1596.00","2","2020-05-22 10:48:52","2","2020-05-22 10:48:52","EPS","","","","EPS","","","",null,0,"190, 40543","C201587","PERSONAL","Mr","HOc7mXovV77WybUL\/yFT9nidmeCwVnaVNJscZzr2svg=","nHj9qHmAi0HhE6EYu7cSig==","","5bZ\/4fQ6Ho9SHhG6vZYHxfbLYLAgNHkSh+U6i2ojGkY3oE6HaDLYbqwvIreAb4QHdDWuLst8ak+Sg1gUHIYRnw==","azCy8ft1G8cIjHhQdx4R8Q==","FZVlfDOu7EIxqsDknyOtJZFhXPqHbOU3qiLm2k8v3V4=","+yW+ljDLQjwTZ865j8SyBQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 10:48:54","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":["7922","1747","798.0","798.00","2","2020-05-22 10:48:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 10:48:54","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-05-22","2021-07-21","1747"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-22 10:48:54","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":["7922","WC-D205420","PAID",1596,0,"2021-07-21","2020-05-22 10:48:52","2020-05-22 10:48:52","2","2020-05-22 10:48:52","2","2020-05-22 10:48:52",1587]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 10:48:54","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":["7922",1587,"SETTLED","WC-I208251","2020-05-22 10:48:52","2020-05-22","2","2020-05-22 10:48:52","2","2020-05-22 10:48:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 10:48:54","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":["8251","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-22 10:48:52","2","2020-05-22 10:48:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 10:48:54","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":["8251","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,798,"MO","1",798,"2","2020-05-22 10:48:52","2","2020-05-22 10:48:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 10:48:54","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":["8251","RENT","\u9810\u7e73\u79df\u91d1",4,798,"MO","1",798,"2","2020-05-22 10:48:52","2","2020-05-22 10:48:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 10:48:54","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":["8251","RENT","\u9810\u7e73\u79df\u91d1",5,798,"MO","1",798,"2","2020-05-22 10:48:52","2","2020-05-22 10:48:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 10:48:54","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":["8251","RENT","\u9810\u7e73\u79df\u91d1",6,798,"MO","1",798,"2","2020-05-22 10:48:52","2","2020-05-22 10:48:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 10:48:54","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":["8251","RENT","\u9810\u7e73\u79df\u91d1",7,798,"MO","1",798,"2","2020-05-22 10:48:52","2","2020-05-22 10:48:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 10:48:54","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":["8251","RENT","\u9810\u7e73\u79df\u91d1",8,798,"MO","1",798,"2","2020-05-22 10:48:52","2","2020-05-22 10:48:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 10:48:54","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":["8251","RENT","\u9810\u7e73\u79df\u91d1",9,798,"MO","1",798,"2","2020-05-22 10:48:52","2","2020-05-22 10:48:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 10:48:54","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":["8251","RENT","\u9810\u7e73\u79df\u91d1",10,798,"MO","1",798,"2","2020-05-22 10:48:52","2","2020-05-22 10:48:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 10:48:54","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":["8251","RENT","\u9810\u7e73\u79df\u91d1",11,798,"MO","1",798,"2","2020-05-22 10:48:52","2","2020-05-22 10:48:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 10:48:54","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":["8251","RENT","\u9810\u7e73\u79df\u91d1",12,798,"MO","1",798,"2","2020-05-22 10:48:52","2","2020-05-22 10:48:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 10:48:54","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":["8251","RENT","\u9810\u7e73\u79df\u91d1",13,798,"MO","1",798,"2","2020-05-22 10:48:52","2","2020-05-22 10:48:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 10:48:54","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":["8251","RENT","\u9810\u7e73\u79df\u91d1",14,798,"MO","1",798,"2","2020-05-22 10:48:52","2","2020-05-22 10:48:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 10:48:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[9576,0,"8251"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-22 10:48:54","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":[1587,"EPS","","","","EPS","","","","PAID","P207895","2020-05-22 10:48:52",11172,"2","2020-05-22 10:48:52","2","2020-05-22 10:48:52","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 10:48:54","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":["7895","DEPOSIT","5420","PAID","2020-05-22 10:48:52",1596,"2","2020-05-22 10:48:52","2","2020-05-22 10:48:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 10:48:54","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":["7895","INVOICE","8251","PAID","2020-05-22 10:48:52",9576,"2","2020-05-22 10:48:52","2","2020-05-22 10:48:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 11:29:22","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"753","master_room_id":"34","room_code":"O29"}],"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> O29 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"K494506(9)","title":"Mr","lastname":"YUE","firstname":"Kin Hang","companyname":"","email":"yokenkoyo@gmail.com","tel":"57918881","address":"Flat H, 8\/F, Block 5, New Jade Garden, Chai Wan","pass":true,"customer_id":"1467","customer_code":"C191467","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"753","room_code":"O29","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":899,"deposit":1996,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5840,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1550.00","warehousing_date":"2020-06-14","rent_from":"2020-06-14","rent_to":"2020-12-13","delivery_service":"0","remark":"6 months contract. Change unit from M67 to O29. Storage deposit $1550 transferred from agreement A14-CT196665 to this agreement. Deposit $500 paid by PPS on May 06,2020. The balance of storage rental and deposit $5340 paid by EPS on May 22,2020.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":1550,"order_total":7390,"final_order_total":5840,"location_id":"2","branch_id":"1","company_id":"1","room_key":"191, 05288","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"899.00","deposit":"1996.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 11:29:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2","1467","NEW","A14-CT207923",998,899,1996,0,"6","6",5840,7390,5840,"2020-05-22 11:29:22","0",null,null,null,"2020-06-14","2020-12-13","6 months contract. Change unit from M67 to O29. Storage deposit $1550 transferred from agreement A14-CT196665 to this agreement. Deposit $500 paid by PPS on May 06,2020. The balance of storage rental and deposit $5340 paid by EPS on May 22,2020.","2020-06-14","12",0,null,1550,"1550.00","2","2020-05-22 11:29:22","2","2020-05-22 11:29:22","EPS","","","","EPS","","","",null,0,"191, 05288","C191467","PERSONAL","Mr","kTcsgy8ZGSq2a5ruB8dG1w==","4yTQcEBZNABiF4rq79LzLQ==","","PWSpKG6nNFJWN2zJkttNpSqXtrxtCm+j+Su3dt35U+qhoernM4mXmP9AgxefSEm0","BDiTf1k0\/ZAxx7WVrZVfJA==","R8WSiTRtDcI\/5Niu7P+lqDccQvRz8PEyhUvX7\/m8s0Y=","Bq1rNXbKgBuNwBVb0TwBNQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 11:29:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7923","753","998.0","998.00","2","2020-05-22 11:29:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 11:29:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-14","2020-12-13","753"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-22 11:29:22","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":["7923","A14-D205421","PAID",1996,0,"2020-12-13","2020-05-22 11:29:22","2020-05-22 11:29:22","2","2020-05-22 11:29:22","2","2020-05-22 11:29:22","1467"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 11:29:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7923","1467","SETTLED","A14-I208252","2020-05-22 11:29:22","2020-06-14","2","2020-05-22 11:29:22","2","2020-05-22 11:29:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 11:29:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8252","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-22 11:29:22","2","2020-05-22 11:29:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 11:29:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8252","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,248,"MO","1",248,"2","2020-05-22 11:29:22","2","2020-05-22 11:29:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 11:29:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8252","RENT","\u9810\u7e73\u79df\u91d1",3,899,"MO","1",899,"2","2020-05-22 11:29:22","2","2020-05-22 11:29:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 11:29:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8252","RENT","\u9810\u7e73\u79df\u91d1",4,899,"MO","1",899,"2","2020-05-22 11:29:22","2","2020-05-22 11:29:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 11:29:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8252","RENT","\u9810\u7e73\u79df\u91d1",5,899,"MO","1",899,"2","2020-05-22 11:29:22","2","2020-05-22 11:29:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 11:29:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8252","RENT","\u9810\u7e73\u79df\u91d1",6,899,"MO","1",899,"2","2020-05-22 11:29:22","2","2020-05-22 11:29:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 11:29:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3844,0,"8252"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-22 11:29:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["1467","EPS","","","","EPS","","","","PAID","P207896","2020-05-22 11:29:22",5840,"2","2020-05-22 11:29:22","2","2020-05-22 11:29:22","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 11:29:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7896","DEPOSIT","5421","PAID","2020-05-22 11:29:22",1996,"2","2020-05-22 11:29:22","2","2020-05-22 11:29:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 11:29:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7896","INVOICE","8252","PAID","2020-05-22 11:29:22",3844,"2","2020-05-22 11:29:22","2","2020-05-22 11:29:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 12:58:14","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1747","master_room_id":"232","room_code":"WC-22"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":354,"customer_code":"C170354","identity_type":"PERSONAL","identity_id":"K462882(9)","title":"Ms","lastname":"Lu","firstname":"Carolyn Anne","companyname":"","email":"carolynlu@msn.com","tel":"90921676","address":"GPO 4665 Central, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3478.0","renew_rent_month":"13","renew_warehousing_date":"2020-05-18","renew_room_key":"052,54246\/053.60965","renew_remark":"13 months contract. Special renewal offer, one month free. Storage rental $20868 paid by cheque on April 12, 2019. Remaining storage rental $20868 paid by cheque on May 28, 2019. Storage deposit transferred from agreement A14-CT183295 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195078, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"569","room_code":"L47","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"568","room_code":"L46","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"558","room_code":"L36","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"557","room_code":"L35","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"64","total_retail_price":4392,"total_discounted_price":3478,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":41736,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3478.00","warehousing_date":"2020-05-18","rent_from":"2020-05-18","rent_to":"2021-06-17","delivery_service":"0","remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by bank transfer on May, 2020. Storage deposit transferred from agreement A14-CT195078 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":3478,"order_total":45214,"final_order_total":41736,"location_id":"2","branch_id":"1","company_id":"1","room_key":"052,54246\/053.60965","order_product":[],"pass":true}},"first_order_id":5078,"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\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> L47 <\/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\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> L46 <\/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\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> L36 <\/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\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> L35 <\/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\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":"64","total_discounted_price":"3478.0","deposit":"0","total_retail_price":"4392.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 12:58:15","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",354,"NEW","A14-CT207924",4392,3478,0,0,"13","13",41736,45214,41736,"2020-05-22 12:58:15","0",null,null,null,"2020-05-18","2021-06-17","13 months contract. Special renewal offer, one month free. Storage rental paid by bank transfer on May, 2020. Storage deposit transferred from agreement A14-CT195078 to this agreement.\r\n","2020-05-18","64",0,null,3478,"3478.00","2","2020-05-22 12:58:14","2","2020-05-22 12:58:14","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,54246\/053.60965","C170354","PERSONAL","Ms","SKvfucG\/tCfpXCUBojATTw==","dr1K55uYcFnlHe0eeOO63w==","","+YKnOdB1TZIvLmLK9Am4PRBFiOFdsssLjbJ5wKaSQC4=","U8H7T0s2ifxERegT+k9cPw==","As+95zI\/u357l4HdLfTAaXZe9KbMymuH1\/tRJFJNe1Q=","CXkx0vdr5QUdv+bQBj3bDg==",null,1,5078]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 12:58:15","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":["7924","569","1098.0","1098.00","2","2020-05-22 12:58:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 12:58:15","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-05-18","2021-06-17","569"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-22 12:58:15","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":["7924","568","1098.0","1098.00","2","2020-05-22 12:58:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 12:58:15","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-05-18","2021-06-17","568"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-22 12:58:15","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":["7924","558","1098.0","1098.00","2","2020-05-22 12:58:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 12:58:15","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-05-18","2021-06-17","558"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-22 12:58:15","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":["7924","557","1098.0","1098.00","2","2020-05-22 12:58:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 12:58:15","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-05-18","2021-06-17","557"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-22 12:58:15","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":["7924",354,"SETTLED","A14-I208253","2020-05-22 12:58:14","2020-05-18","2","2020-05-22 12:58:14","2","2020-05-22 12:58:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 12:58:15","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":["8253","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,3478,"MO","1",3478,"2","2020-05-22 12:58:14","2","2020-05-22 12:58:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 12:58:15","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":["8253","RENT","\u9810\u7e73\u79df\u91d1",3,3478,"MO","1",3478,"2","2020-05-22 12:58:14","2","2020-05-22 12:58:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 12:58:15","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":["8253","RENT","\u9810\u7e73\u79df\u91d1",4,3478,"MO","1",3478,"2","2020-05-22 12:58:14","2","2020-05-22 12:58:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 12:58:15","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":["8253","RENT","\u9810\u7e73\u79df\u91d1",5,3478,"MO","1",3478,"2","2020-05-22 12:58:14","2","2020-05-22 12:58:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 12:58:15","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":["8253","RENT","\u9810\u7e73\u79df\u91d1",6,3478,"MO","1",3478,"2","2020-05-22 12:58:14","2","2020-05-22 12:58:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 12:58:15","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":["8253","RENT","\u9810\u7e73\u79df\u91d1",7,3478,"MO","1",3478,"2","2020-05-22 12:58:14","2","2020-05-22 12:58:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 12:58:15","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":["8253","RENT","\u9810\u7e73\u79df\u91d1",8,3478,"MO","1",3478,"2","2020-05-22 12:58:14","2","2020-05-22 12:58:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 12:58:15","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":["8253","RENT","\u9810\u7e73\u79df\u91d1",9,3478,"MO","1",3478,"2","2020-05-22 12:58:14","2","2020-05-22 12:58:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 12:58:15","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":["8253","RENT","\u9810\u7e73\u79df\u91d1",10,3478,"MO","1",3478,"2","2020-05-22 12:58:14","2","2020-05-22 12:58:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 12:58:15","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":["8253","RENT","\u9810\u7e73\u79df\u91d1",11,3478,"MO","1",3478,"2","2020-05-22 12:58:14","2","2020-05-22 12:58:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 12:58:15","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":["8253","RENT","\u9810\u7e73\u79df\u91d1",12,3478,"MO","1",3478,"2","2020-05-22 12:58:14","2","2020-05-22 12:58:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 12:58:15","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":["8253","RENT","\u9810\u7e73\u79df\u91d1",13,3478,"MO","1",3478,"2","2020-05-22 12:58:14","2","2020-05-22 12:58:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 12:58:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[41736,0,"8253"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-22 12:58:15","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":[354,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207897","2020-05-22 12:58:14",41736,"2","2020-05-22 12:58:14","2","2020-05-22 12:58:14","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 12:58:15","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":["7897","DEPOSIT",null,"PAID","2020-05-22 12:58:14",0,"2","2020-05-22 12:58:14","2","2020-05-22 12:58:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 12:58:15","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":["7897","INVOICE","8253","PAID","2020-05-22 12:58:14",41736,"2","2020-05-22 12:58:14","2","2020-05-22 12:58:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 13:00:08","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1747","master_room_id":"232","room_code":"WC-22"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1000,"customer_code":"C181000","identity_type":"BUSINESS","identity_id":"69808784","title":"Mr","lastname":"Halliday","firstname":"David Jeffrey","companyname":"Lancashire Decorating Limited","email":"hallid@hotmail.com","tel":"63247121","address":"Unit 305-7, 3\/F, Laford Centre, 838 Lai Chi Kok Road, Cheung Sha Wan, Kowloon","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1857.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-22","renew_room_key":"0012385366","renew_remark":"1 month contract. Storage rental paid by bank transfer on April 20, 2020. Storage Deposit $3714 transferred from agreement A05-CT207455 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT207672, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"117","order_discount":[],"order_room":[{"room_id":"1032","room_code":"A05-030","retail_price":"1857.0","discounted_price":"1857.00","location_id":"4"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1857,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1857,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-22","rent_from":"2020-05-22","rent_to":"2020-06-21","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on May 20, 2020. Storage Deposit $3714 transferred from agreement A05-CT207672 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1857,"final_order_total":1857,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012385366","order_product":[],"pass":true}},"first_order_id":"6943","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-030 <\/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> \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":"24","total_discounted_price":"1857.0","deposit":"0","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 13:00: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","4",1000,"NEW","A05-CT207925",1857,1857,0,0,"1","1",1857,1857,1857,"2020-05-22 13:00:09","0",null,null,null,"2020-05-22","2020-06-21","1 month contract. Storage rental paid by bank transfer on May 20, 2020. Storage Deposit $3714 transferred from agreement A05-CT207672 to this agreement. \r\n","2020-05-22","24",0,null,0,"0","2","2020-05-22 13:00:08","2","2020-05-22 13:00:08","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012385366","C181000","BUSINESS","Mr","uH6SR3Usr5pjl15fgk2xBQ==","3hC5jWxTyseC0UGI0aOkAg==","Lancashire Decorating Limited","2Z3GrSs8TtWmHfqJQHcTHSj5PkrfAJG3icQpP+dHb4pR6r6gZDlFua9f0SQRB4T7nesXzD6ZQbIz9hPFFQWgZxCafnJaWissyZGlcu8xHaw=","6vfNYC\/zokp3t8YiOOVHSg==","hDQSd3rKdaAlD3TTnjhsvRH6brF\/H73VmPFKao018qs=",null,"c4A7Vexe0m66GXy70hIIWA==",1,"6943"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 13:00: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":["7925","1032","1857.0","1857.00","2","2020-05-22 13:00:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 13:00: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-05-22","2020-06-21","1032"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-22 13:00: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":["7925",1000,"SETTLED","A05-I208254","2020-05-22 13:00:08","2020-05-22","2","2020-05-22 13:00:08","2","2020-05-22 13:00:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 13:00: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":["8254","RENT","\u9810\u7e73\u79df\u91d1",1,1857,"MO","1",1857,"2","2020-05-22 13:00:08","2","2020-05-22 13:00:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 13:00:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1857,0,"8254"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-22 13:00: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":[1000,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207898","2020-05-22 13:00:08",1857,"2","2020-05-22 13:00:08","2","2020-05-22 13:00:08","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 13:00: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":["7898","DEPOSIT",null,"PAID","2020-05-22 13:00:08",0,"2","2020-05-22 13:00:08","2","2020-05-22 13:00:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 13:00: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":["7898","INVOICE","8254","PAID","2020-05-22 13:00:08",1857,"2","2020-05-22 13:00:08","2","2020-05-22 13:00:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 13:27:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 14:10:59","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1747","master_room_id":"232","room_code":"WC-22"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1443,"customer_code":"C191443","identity_type":"PERSONAL","identity_id":"D412513(5)","title":"Ms","lastname":"YUEN","firstname":"Siu Ping","companyname":"","email":null,"tel":"56877552","address":"PO Box 24203, Aberdeen Post Office, Hong Kong (Tin Wan Estate)","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"568.0","renew_rent_month":"3","renew_warehousing_date":"2020-05-22","renew_room_key":"189, 51986","renew_remark":"3 months contract. Storage rental paid by cash on February 19, 2020. Deposit $1196 transferred from agreement A16-CT196397 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT207226, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"196","order_discount":[],"order_room":[{"room_id":"1512","room_code":"A16-021","retail_price":"598.0","discounted_price":"598.00","location_id":"7"}],"roughly_size":"8","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-22","rent_from":"2020-05-22","rent_to":"2020-11-21","delivery_service":"0","remark":"6 months contract. Special renewal gift. Storage rental paid by cash on May 22, 2020. Deposit $1196 transferred from agreement A16-CT207226 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"7","branch_id":"1","company_id":"1","room_key":"189, 51986","order_product":[],"pass":true}},"first_order_id":"6397","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> A16-021 <\/td>\r\n\t\t\t\t\t 4X2X3.5 <\/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":"8","total_discounted_price":"538.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 14:10:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","7",1443,"NEW","A16-CT207926",598,538,0,0,"6","6",3228,3228,3228,"2020-05-22 14:10:59","0",null,null,null,"2020-05-22","2020-11-21","6 months contract. Special renewal gift. Storage rental paid by cash on May 22, 2020. Deposit $1196 transferred from agreement A16-CT207226 to this agreement. \r\n","2020-05-22","8",0,null,0,"0","2","2020-05-22 14:10:59","2","2020-05-22 14:10:59","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"189, 51986","C191443","PERSONAL","Ms","cFmyi84\/8cOtadX9t1nKXw==","Z\/P5RghDgz0XwoQL70fUUQ==","","QlLQGC+zetyMAKi29dGFPjipjilS4QGkcCL31TUK6G2pYti3O+7vw86f+Dbei2786BN3XiUf9S1BtpOkhgR9xQ==","BwrXzyOEg37+mGF9SkxBng==",null,"2miB0cPPtBdrJpDRWjuscQ==",null,1,"6397"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 14:10:59","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":["7926","1512","598.0","598.00","2","2020-05-22 14:10:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 14:10:59","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-05-22","2020-11-21","1512"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-22 14:10:59","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":["7926",1443,"SETTLED","A16-I208255","2020-05-22 14:10:59","2020-05-22","2","2020-05-22 14:10:59","2","2020-05-22 14:10:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 14:10:59","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":["8255","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-05-22 14:10:59","2","2020-05-22 14:10:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 14:10:59","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":["8255","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-05-22 14:10:59","2","2020-05-22 14:10:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 14:10:59","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":["8255","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-05-22 14:10:59","2","2020-05-22 14:10:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 14:10:59","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":["8255","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-05-22 14:10:59","2","2020-05-22 14:10:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 14:10:59","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":["8255","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-05-22 14:10:59","2","2020-05-22 14:10:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 14:10:59","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":["8255","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-05-22 14:10:59","2","2020-05-22 14:10:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 14:10:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"8255"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-22 14:10:59","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":[1443,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207899","2020-05-22 14:10:59",3228,"2","2020-05-22 14:10:59","2","2020-05-22 14:10:59","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 14:10:59","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":["7899","DEPOSIT",null,"PAID","2020-05-22 14:10:59",0,"2","2020-05-22 14:10:59","2","2020-05-22 14:10:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 14:10:59","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":["7899","INVOICE","8255","PAID","2020-05-22 14:10:59",3228,"2","2020-05-22 14:10:59","2","2020-05-22 14:10:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 14:46:01","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&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1747","master_room_id":"232","room_code":"WC-22"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1355,"customer_code":"C191355","identity_type":"PERSONAL","identity_id":"D260822(8)","title":"Mr","lastname":"Lau","firstname":"Ka Ho David","companyname":"","email":"lkhdavid@yahoo.com.hk","tel":"92023125","address":"5\/F, Harrow Mansion, 170-172 Aberdeen Main Rd, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2188.0","renew_rent_month":"2","renew_warehousing_date":"2020-04-04","renew_room_key":"076,48044","renew_remark":"2 months contract. Storage rental $2188\/month. Storage rental paid by bank transfer on March 31, 2020. Storage deposit $4376 transferred from agreement A12-CT207368 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207541, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"4","order_discount":[],"order_room":[{"room_id":"297","room_code":"E24","retail_price":"1138.0","discounted_price":"946.00","location_id":"1"},{"room_id":"308","room_code":"E35","retail_price":"1138.0","discounted_price":"946.00","location_id":"1"}],"roughly_size":"30","total_retail_price":2276,"total_discounted_price":2188,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2188,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-04","rent_from":"2020-04-04","rent_to":"2020-05-03","delivery_service":"0","remark":"2 months contract. Storage rental $2188\/month. Storage rental paid by bank transfer on May 22, 2020. Storage deposit $4376 transferred from agreement A12-CT207541 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2188,"final_order_total":2188,"location_id":"1","branch_id":"1","company_id":"1","room_key":"076,48044","order_product":[],"pass":true}},"first_order_id":"5625","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> E24 <\/td>\r\n\t\t\t\t\t 3X5X8 <\/td>\r\n\t\t\t\t\t $1138.00 <\/td>\r\n\t\t\t\t $946.0 <\/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> E35 <\/td>\r\n\t\t\t\t\t 3X5X8 <\/td>\r\n\t\t\t\t\t $1138.00 <\/td>\r\n\t\t\t\t $946.0 <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"30","total_discounted_price":"2188.00","deposit":"0.00","total_retail_price":"2276.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 14:46:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",1355,"NEW","A12-CT207927",2276,2188,0,0,"1","1",2188,2188,2188,"2020-05-22 14:46:01","0",null,null,null,"2020-04-04","2020-05-03","2 months contract. Storage rental $2188\/month. Storage rental paid by bank transfer on May 22, 2020. Storage deposit $4376 transferred from agreement A12-CT207541 to this agreement.\r\n","2020-04-04","30",0,null,0,"0","2","2020-05-22 14:46:00","2","2020-05-22 14:46:00","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,48044","C191355","PERSONAL","Mr","byNdTNcCLo6aLQN435WZZQ==","oe4emdjBwqJ3qUpOcI17hw==","","mLjIS1gL5SfHxNCxPFPye21mGzNX+ITzU4qVF+K6L0jbVek9r3oaeRQYRWuk5L45CjWLjqP\/\/6VUESa\/Ue5xcw==","LjaeJ3csMFHue8wAtOK+sQ==","HYtOeAa2oajm09cLWUO73jrw++DhYubmcByxwcfKdrU=","ks+B19crkUr8NVNksxwxyg==",null,1,"5625"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 14:46:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7927","297","1138.0","946.00","2","2020-05-22 14:46:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 14:46:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-04","2020-05-03","297"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-22 14:46:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7927","308","1138.0","946.00","2","2020-05-22 14:46:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 14:46:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-04","2020-05-03","308"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-22 14:46:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7927",1355,"SETTLED","A12-I208256","2020-05-22 14:46:00","2020-04-04","2","2020-05-22 14:46:00","2","2020-05-22 14:46:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 14:46:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8256","RENT","\u9810\u7e73\u79df\u91d1",1,2188,"MO","1",2188,"2","2020-05-22 14:46:00","2","2020-05-22 14:46:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 14:46:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2188,0,"8256"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-22 14:46:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1355,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207900","2020-05-22 14:46:00",2188,"2","2020-05-22 14:46:00","2","2020-05-22 14:46:00","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 14:46:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7900","DEPOSIT",null,"PAID","2020-05-22 14:46:00",0,"2","2020-05-22 14:46:00","2","2020-05-22 14:46:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 14:46:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7900","INVOICE","8256","PAID","2020-05-22 14:46:00",2188,"2","2020-05-22 14:46:00","2","2020-05-22 14:46:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 15:55:25","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=525&filter3=undefined","floor_plan_rent_room":[{"room_id":"1747","master_room_id":"232","room_code":"WC-22"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":525,"customer_code":"C170525","identity_type":"PERSONAL","identity_id":"G161193(2)","title":"Ms","lastname":"Man","firstname":"Fung Yi Roni","companyname":"","email":"manroni@kawinghong.com","tel":"54362045","address":"\u9999\u6e2f\u8d64\u67f1\u9f8d\u5fb7\u82d1\u6649\u5fb7\u95a32\u6a1313\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2336.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-21","renew_room_key":"056,13866","renew_remark":"1 month contract. Storage rental paid by bank transfer on April 18, 2020. Storage deposit transferred from agreement A14-CT207242 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207671, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"544","room_code":"L22(\u670d\u88dd\u5009)","retail_price":"1342.0","discounted_price":"1342.00","location_id":"2"},{"room_id":"545","room_code":"L23","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"32","total_retail_price":2440,"total_discounted_price":2336,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2336,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-21","rent_from":"2020-04-21","rent_to":"2020-05-20","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on March 18, 2020. Storage deposit transferred from agreement A14-CT207671 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2336,"final_order_total":2336,"location_id":"2","branch_id":"1","company_id":"1","room_key":"056,13866","order_product":[],"pass":true}},"first_order_id":"4877","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> L22(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1342.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> L23 <\/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\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":"2336.0","deposit":"0","total_retail_price":"2440.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 15:55:25","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",525,"NEW","A14-CT207928",2440,2336,0,0,"1","1",2336,2336,2336,"2020-05-22 15:55:25","0",null,null,null,"2020-04-21","2020-05-20","1 month contract. Storage rental paid by bank transfer on March 18, 2020. Storage deposit transferred from agreement A14-CT207671 to this agreement.\r\n","2020-04-21","32",0,null,0,"0","2","2020-05-22 15:55:25","2","2020-05-22 15:55:25","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"056,13866","C170525","PERSONAL","Ms","ibYrH9hZ8AxKQwoDOyRf7g==","1iB+Fi5mVPBhoP\/ei\/0Bag==","","6FEfBp4QinpFgaVk\/XySHjwYeKgnpkSt7nsZEe9qVfgX7gsIGumX1P5i\/O8D1hN0","kjGiWZ21y1YpwaPjV74WsA==","qyZUZxcd5Fov\/z6YWfj+Qzvwf4EvFlsT926fUqJ1c+g=","CTeh4\/H1iVpxG8qx2JRcpg==",null,1,"4877"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 15:55:25","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":["7928","544","1342.0","1342.00","2","2020-05-22 15:55:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 15:55:25","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-04-21","2020-05-20","544"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-22 15:55:25","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":["7928","545","1098.0","1098.00","2","2020-05-22 15:55:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 15:55:25","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-04-21","2020-05-20","545"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-22 15:55:25","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":["7928",525,"SETTLED","A14-I208257","2020-05-22 15:55:25","2020-04-21","2","2020-05-22 15:55:25","2","2020-05-22 15:55:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 15:55:25","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":["8257","RENT","\u9810\u7e73\u79df\u91d1",1,2336,"MO","1",2336,"2","2020-05-22 15:55:25","2","2020-05-22 15:55:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 15:55:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2336,0,"8257"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-22 15:55:25","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":[525,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207901","2020-05-22 15:55:25",2336,"2","2020-05-22 15:55:25","2","2020-05-22 15:55:25","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 15:55:25","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":["7901","DEPOSIT",null,"PAID","2020-05-22 15:55:25",0,"2","2020-05-22 15:55:25","2","2020-05-22 15:55:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 15:55:25","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":["7901","INVOICE","8257","PAID","2020-05-22 15:55:25",2336,"2","2020-05-22 15:55:25","2","2020-05-22 15:55:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:13:45","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=469&filter3=undefined","floor_plan_rent_room":[{"room_id":"1747","master_room_id":"232","room_code":"WC-22"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":149,"customer_code":"C160149","identity_type":"PERSONAL","identity_id":"D442312(8)","title":"Mr","lastname":"Chan","firstname":"Tak Fung","companyname":"","email":"takfungchan@hotmail.com","tel":"96507732","address":"Flat 7,5\/F, Kung Fai House,Yue Fai Court, Aberdeen","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"935.0","renew_rent_month":"12","renew_warehousing_date":"2020-05-25","renew_room_key":"055,29097","renew_remark":"12 months contract. Storage rental paid by cheque on May 16, 2019. Storage deposit transferred from agreement A12-CT183662 to this agreement. \u820a\u5408\u7d04\u7de8\u865f: A12-CT183662, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT194962, \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":"133","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"133","room_code":"C09","retail_price":"1098.0","discounted_price":989,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":935,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5610,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-25","rent_from":"2020-05-25","rent_to":"2020-11-24","delivery_service":"0","remark":"6 months contract. Storage rental paid by cheque on May 22, 2020. Storage deposit transferred from agreement A12-CT194962 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":5610,"final_order_total":5610,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,29097","order_product":[],"pass":true}},"first_order_id":"3662","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> C09 <\/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":"935.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:13: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",149,"NEW","A12-CT207929",1098,935,0,0,"6","6",5610,5610,5610,"2020-05-22 16:13:45","0",null,null,null,"2020-05-25","2020-11-24","6 months contract. Storage rental paid by cheque on May 22, 2020. Storage deposit transferred from agreement A12-CT194962 to this agreement.\r\n","2020-05-25","16",0,null,0,"0","2","2020-05-22 16:13:45","2","2020-05-22 16:13:45","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"055,29097","C160149","PERSONAL","Mr","roFO0QLa6j\/8XOth2LcpdQ==","U9yoE9KqV1v8YlRkf7Q2yg==","","XM08DCYE8nOSGu022CAGJZLsLAT2hPaFYKbfEnImYmz1IWqzz2E3+X89WRaNFcBgU5nD2JMZvwLBbbpFhN+2mg==","GsY1eUkHYsKKo4ysjSGBRQ==","zZUiQBXqwoVVWtKVJkNDuM21OZSMZgVD17fzSoIR6G8=","m8aBOchk3mRyapfCDDyo4g==",null,1,"3662"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:13:45","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":["7929","72","8","133","%","9.93",109.0314,"2","2020-05-22 16:13:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:13: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":["7929","133","1098.0",989,"2","2020-05-22 16:13:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:13: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-05-25","2020-11-24","133"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-22 16:13: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":["7929",149,"SETTLED","A12-I208258","2020-05-22 16:13:45","2020-05-25","2","2020-05-22 16:13:45","2","2020-05-22 16:13:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:13: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":["8258","RENT","\u9810\u7e73\u79df\u91d1",1,935,"MO","1",935,"2","2020-05-22 16:13:45","2","2020-05-22 16:13:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:13: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":["8258","RENT","\u9810\u7e73\u79df\u91d1",2,935,"MO","1",935,"2","2020-05-22 16:13:45","2","2020-05-22 16:13:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:13: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":["8258","RENT","\u9810\u7e73\u79df\u91d1",3,935,"MO","1",935,"2","2020-05-22 16:13:45","2","2020-05-22 16:13:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:13: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":["8258","RENT","\u9810\u7e73\u79df\u91d1",4,935,"MO","1",935,"2","2020-05-22 16:13:45","2","2020-05-22 16:13:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:13: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":["8258","RENT","\u9810\u7e73\u79df\u91d1",5,935,"MO","1",935,"2","2020-05-22 16:13:45","2","2020-05-22 16:13:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:13: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":["8258","RENT","\u9810\u7e73\u79df\u91d1",6,935,"MO","1",935,"2","2020-05-22 16:13:45","2","2020-05-22 16:13:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:13:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5610,0,"8258"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-22 16:13: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":[149,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207902","2020-05-22 16:13:45",5610,"2","2020-05-22 16:13:45","2","2020-05-22 16:13:45","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:13: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":["7902","DEPOSIT",null,"PAID","2020-05-22 16:13:45",0,"2","2020-05-22 16:13:45","2","2020-05-22 16:13:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:13: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":["7902","INVOICE","8258","PAID","2020-05-22 16:13:45",5610,"2","2020-05-22 16:13:45","2","2020-05-22 16:13:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:50:33","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=469&filter3=undefined","floor_plan_rent_room":[{"room_id":"1747","master_room_id":"232","room_code":"WC-22"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":501,"customer_code":"C170501","identity_type":"PERSONAL","identity_id":"K835176(7)","title":"Mr","lastname":"Mak","firstname":"Kwong Yiu","companyname":"","email":"leemak2013@gmail.com","tel":"60161222","address":"Room 1707, King Fai Hse , Yu Fai Court, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"6","renew_warehousing_date":"2020-04-29","renew_room_key":"054,00711","renew_remark":"6 months contract. Storage rental paid by bank transfer on Nov 03, 2019. Storage deposit transferred from agreement A14-CT195783 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196296, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"618","room_code":"M29","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":568,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":1704,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-29","rent_from":"2020-04-29","rent_to":"2020-07-28","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on May 5, 2020. Storage deposit transferred from agreement A14-CT196296 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1704,"final_order_total":1704,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,00711","order_product":[],"pass":true}},"first_order_id":"4349","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> M29 <\/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":"568.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:50:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",501,"NEW","A14-CT207930",598,568,0,0,"3","3",1704,1704,1704,"2020-05-22 16:50:34","0",null,null,null,"2020-04-29","2020-07-28","3 months contract. Storage rental paid by bank transfer on May 5, 2020. Storage deposit transferred from agreement A14-CT196296 to this agreement.","2020-04-29","12",0,null,0,"0","2","2020-05-22 16:50:33","2","2020-05-22 16:50:33","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,00711","C170501","PERSONAL","Mr","or+eKfBEd+XRRc6l5QHw4g==","DGNg\/pKHJ\/mTaSVRFTWCKw==","","SlSWkk9PZOqIuL+nnLRDw+adE8qgC7+PdETxHTpor3KyaZorBEO0wt5SkrKqfAr8mZqbksRFFSWnPzPsuJTJrQ==","gOxn2TMWn+Bfmttky7oNCg==","RBC9aEYho\/0SLG3fYdj7peBVko3TjRcJAxFUg\/ZlR7M=","S5noRr22pauI\/7OLPVs6Xg==",null,1,"4349"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:50:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7930","618","598.0","598.00","2","2020-05-22 16:50:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:50:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-29","2020-07-28","618"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-22 16:50:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7930",501,"SETTLED","A14-I208259","2020-05-22 16:50:33","2020-04-29","2","2020-05-22 16:50:33","2","2020-05-22 16:50:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:50:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8259","RENT","\u9810\u7e73\u79df\u91d1",1,568,"MO","1",568,"2","2020-05-22 16:50:33","2","2020-05-22 16:50:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:50:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8259","RENT","\u9810\u7e73\u79df\u91d1",2,568,"MO","1",568,"2","2020-05-22 16:50:33","2","2020-05-22 16:50:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:50:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8259","RENT","\u9810\u7e73\u79df\u91d1",3,568,"MO","1",568,"2","2020-05-22 16:50:33","2","2020-05-22 16:50:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:50:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1704,0,"8259"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-22 16:50:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[501,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207903","2020-05-22 16:50:33",1704,"2","2020-05-22 16:50:33","2","2020-05-22 16:50:33","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:50:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7903","DEPOSIT",null,"PAID","2020-05-22 16:50:33",0,"2","2020-05-22 16:50:33","2","2020-05-22 16:50:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:50:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7903","INVOICE","8259","PAID","2020-05-22 16:50:33",1704,"2","2020-05-22 16:50:33","2","2020-05-22 16:50:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:52:37","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=469&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1747","master_room_id":"232","room_code":"WC-22"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1320,"customer_code":"C191320","identity_type":"PERSONAL","identity_id":"Z071705(4)","title":"Ms","lastname":"Tsui","firstname":"Wai Ting","companyname":"","email":"lilian_tsui2003@hotmail.com","tel":"96651398","address":"Flat 1, 20\/F, Block B, Yue Fai Court, Aberdeen, Hong Kong","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-05-04","renew_room_key":"076,47738","renew_remark":"1 month contract. Storage rental paid by bank transfer on April 2, 2020. Storage deposit transferred from agreement A14-CT207303 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207557, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"629","room_code":"M40","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-05-04","rent_from":"2020-05-04","rent_to":"2020-06-03","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on May 2, 2020. Storage deposit transferred from agreement A14-CT207557 to this agreement.","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,47738","order_product":[],"pass":true}},"first_order_id":"5394","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> M40 <\/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-05-22 16:52:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",1320,"NEW","A14-CT207931",598,598,0,0,"1","1",598,598,598,"2020-05-22 16:52:37","0",null,null,null,"2020-05-04","2020-06-03","1 month contract. Storage rental paid by bank transfer on May 2, 2020. Storage deposit transferred from agreement A14-CT207557 to this agreement.","2020-05-04","12",0,null,0,"0","2","2020-05-22 16:52:36","2","2020-05-22 16:52:36","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,47738","C191320","PERSONAL","Ms","JgAavgpIkIT+QrZDjc3BRA==","iFBOFA5ozF+SaoxW1fJyqg==","","nS2AiTTeQuxhPG679Pwsq8kB6U8sV32RDbPuHYq7+uZFSa7VZrGSkrkHoVfookObAopb4zx1arlGt2IOtgLjog==","zL50AC1II2U4KbzngrxU9w==","LPBlaIsAU5KUY5TZ0ddhbjaTC47xq2aEL17KEpHG6hM=","EknxojvrXMxgxEofwXXtVQ==",null,1,"5394"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:52:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7931","629","598.0","598.00","2","2020-05-22 16:52:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:52:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-04","2020-06-03","629"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-22 16:52:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7931",1320,"SETTLED","A14-I208260","2020-05-22 16:52:36","2020-05-04","2","2020-05-22 16:52:36","2","2020-05-22 16:52:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:52:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8260","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-05-22 16:52:36","2","2020-05-22 16:52:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:52:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8260"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-22 16:52:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1320,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207904","2020-05-22 16:52:36",598,"2","2020-05-22 16:52:36","2","2020-05-22 16:52:36","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:52:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7904","DEPOSIT",null,"PAID","2020-05-22 16:52:36",0,"2","2020-05-22 16:52:36","2","2020-05-22 16:52:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:52:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7904","INVOICE","8260","PAID","2020-05-22 16:52:36",598,"2","2020-05-22 16:52:36","2","2020-05-22 16:52:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:58:04","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=826&filter3=undefined","floor_plan_rent_room":[{"room_id":"1747","master_room_id":"232","room_code":"WC-22"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":141,"customer_code":"C160141","identity_type":"PERSONAL","identity_id":"Z121208(8)","title":"Ms","lastname":"CHAN","firstname":"HAY WAN DAWN HELEN","companyname":"","email":"helloivy@yahoo.com","tel":"61006761","address":"room 330,wah ming house,wah fu estate,HK","pass":true},"2":{"renew_paymethod2":"OTHER","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-02","renew_room_key":"055,17749","renew_remark":"6 months contract. Storage rental paid by PayMe on Nov 04, 2019. Storage deposit transferred from agreement A12-CT194852 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196298, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"1","order_discount":[{"master_room_discount_id":"68","master_room_id":"1","discount_type":"%","price":"598.00","disocunted_price":"538.20","discount":"10.00","monthly_deduct":59.8,"room_id":"215","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"215","room_code":"D19","retail_price":"598.0","discounted_price":538.2,"location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-02","rent_from":"2020-05-02","rent_to":"2020-11-01","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on May 5, 2020. Storage deposit transferred from agreement A12-CT196298 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,17749","order_product":[],"pass":true}},"first_order_id":"4852","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> D19 <\/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> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"538.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:58: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",141,"NEW","A12-CT207932",598,538,0,0,"6","6",3228,3228,3228,"2020-05-22 16:58:04","0",null,null,null,"2020-05-02","2020-11-01","6 months contract. Storage rental paid by bank transfer on May 5, 2020. Storage deposit transferred from agreement A12-CT196298 to this agreement.\r\n","2020-05-02","12",0,null,0,"0","2","2020-05-22 16:58:04","2","2020-05-22 16:58:04","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,17749","C160141","PERSONAL","Ms","WjjHxkf3altg66NDuIHHz7bQwempoZYkRL+TM1nQUi0=","8BEgNhGpCR8jGkzUtrIcXg==","","w2YdSP1ofIaktbQpXrBfzZnjA+ndnK5m6zsx0e3znvbKKrVsQByWOdobpSUygkZB","mo18OCalWNwWRixP8RtJSg==","wG+UOt8ZsTRMxPBjb\/nCGD+gjtzVi1IiV93W91fBw5E=","mce\/E1BPkCLLTr8gwT7y7w==",null,1,"4852"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:58: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":["7932","68","1","215","%","10.00",59.8,"2","2020-05-22 16:58:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:58: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":["7932","215","598.0",538.2,"2","2020-05-22 16:58:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:58: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-05-02","2020-11-01","215"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-22 16:58: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":["7932",141,"SETTLED","A12-I208261","2020-05-22 16:58:04","2020-05-02","2","2020-05-22 16:58:04","2","2020-05-22 16:58:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:58: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":["8261","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-05-22 16:58:04","2","2020-05-22 16:58:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:58: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":["8261","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-05-22 16:58:04","2","2020-05-22 16:58:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:58: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":["8261","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-05-22 16:58:04","2","2020-05-22 16:58:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:58: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":["8261","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-05-22 16:58:04","2","2020-05-22 16:58:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:58: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":["8261","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-05-22 16:58:04","2","2020-05-22 16:58:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:58: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":["8261","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-05-22 16:58:04","2","2020-05-22 16:58:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:58:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"8261"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-22 16:58: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":[141,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207905","2020-05-22 16:58:04",3228,"2","2020-05-22 16:58:04","2","2020-05-22 16:58:04","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:58: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":["7905","DEPOSIT",null,"PAID","2020-05-22 16:58:04",0,"2","2020-05-22 16:58:04","2","2020-05-22 16:58:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 16:58: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":["7905","INVOICE","8261","PAID","2020-05-22 16:58:04",3228,"2","2020-05-22 16:58:04","2","2020-05-22 16:58:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 17:16:48","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=826&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1747","master_room_id":"232","room_code":"WC-22"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":451,"customer_code":"C170451","identity_type":"PERSONAL","identity_id":"D228002(8)","title":"Ms","lastname":"Wong","firstname":"Mei Kuen Eva","companyname":"","email":"ew267833@yahoo.com.hk","tel":"98337347","address":"Rm 5, 22\/F Hoi Tsing Court, Aberdeen Centre,Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"12","renew_warehousing_date":"2020-05-22","renew_room_key":"055,18562","renew_remark":"12 months contract. Special renewal offer, $100 cake voucher offered. Storage rental paid by PPS on June 3, 2019. Storage deposit transferred from agreement A14-CT183678 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195150, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"593","room_code":"M04","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-22","rent_from":"2020-05-22","rent_to":"2020-11-21","delivery_service":"0","remark":"6 months contract. Storage rental paid by PPS on May 21, 2020. Storage deposit transferred from agreement A14-CT195150 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,18562","order_product":[],"pass":true}},"first_order_id":"3678","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> M04 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"538.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 17:16:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",451,"NEW","A14-CT207933",598,538,0,0,"6","6",3228,3228,3228,"2020-05-22 17:16:48","0",null,null,null,"2020-05-22","2020-11-21","6 months contract. Storage rental paid by PPS on May 21, 2020. Storage deposit transferred from agreement A14-CT195150 to this agreement.\r\n","2020-05-22","12",0,null,0,"0","2","2020-05-22 17:16:48","2","2020-05-22 17:16:48","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,18562","C170451","PERSONAL","Ms","sCV9iLp\/zknWqT18bhd2Tg==","hULSwM2MvFtpeV9\/z+er8Q==","","9PQZv2TsAQY5uVGVGvBKmtE\/E\/nrLwdsV+Ux5w1b9+PaNyIGqT7PqwRK+qZo68xQH+wCyTmPOcwZ6mmBqpKjVg==","t+eTcnGLbHbvQcXwUhWPLw==","0daZprgv7O3n19FVGhLXHvWeJ49QnGbLm7wysxgJctQ=","\/j7zCMqsdKcOjHIJTg9jug==",null,1,"3678"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 17:16:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7933","593","598.0","598.00","2","2020-05-22 17:16:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 17:16:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-22","2020-11-21","593"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-22 17:16:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7933",451,"SETTLED","A14-I208262","2020-05-22 17:16:48","2020-05-22","2","2020-05-22 17:16:48","2","2020-05-22 17:16:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 17:16:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8262","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-05-22 17:16:48","2","2020-05-22 17:16:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 17:16:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8262","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-05-22 17:16:48","2","2020-05-22 17:16:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 17:16:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8262","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-05-22 17:16:48","2","2020-05-22 17:16:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 17:16:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8262","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-05-22 17:16:48","2","2020-05-22 17:16:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 17:16:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8262","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-05-22 17:16:48","2","2020-05-22 17:16:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 17:16:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8262","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-05-22 17:16:48","2","2020-05-22 17:16:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 17:16:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"8262"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-22 17:16:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[451,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207906","2020-05-22 17:16:48",3228,"2","2020-05-22 17:16:48","2","2020-05-22 17:16:48","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 17:16:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7906","DEPOSIT",null,"PAID","2020-05-22 17:16:48",0,"2","2020-05-22 17:16:48","2","2020-05-22 17:16:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 17:16:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7906","INVOICE","8262","PAID","2020-05-22 17:16:48",3228,"2","2020-05-22 17:16:48","2","2020-05-22 17:16:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 18:48:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 18:49:29","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":"753","master_room_id":"34","room_code":"O29"}],"index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1558,"customer_code":"C201558","identity_type":"PERSONAL","identity_id":"Z022867(3)","title":"Mr","lastname":"CHEUNG","firstname":"Wai Kuen","companyname":"","email":"alexandling@yahoo.com.hk","tel":"91665461","address":"\u9999\u6e2f\u7063\u4ed4\u76e7\u62bc\u90531\u865f10H","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2022.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-15","renew_room_key":"189,27847","renew_remark":"1 month contract. Storage rental and deposit paid by cash on Apr 15,2020. Smart card and padlock provided on the same day.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207627, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $4044.0","renew_master_room_id":"14","order_discount":[],"order_room":[{"room_id":"6","room_code":"A06","retail_price":"2318.0","discounted_price":"2318.00","location_id":"1"}],"roughly_size":"32","total_retail_price":2318,"total_discounted_price":2022,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2022,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-15","rent_from":"2020-05-15","rent_to":"2020-06-14","delivery_service":"0","remark":"1 month contract. Storage rental and deposit paid by PPS on May 21,2020. Storage deposit $4044 transferred from agreement A12-CT207627 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":2022,"final_order_total":2022,"location_id":"1","branch_id":"1","company_id":"1","room_key":"189,27847","order_product":[],"pass":true}},"first_order_id":7627,"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> A06 <\/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":"2022.0","deposit":"0","total_retail_price":"2318.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 18:49:30","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",1558,"NEW","A12-CT207934",2318,2022,0,0,"1","1",2022,2022,2022,"2020-05-22 18:49:30","0",null,null,null,"2020-05-15","2020-06-14","1 month contract. Storage rental and deposit paid by PPS on May 21,2020. Storage deposit $4044 transferred from agreement A12-CT207627 to this agreement.","2020-05-15","32",0,null,0,"0","2","2020-05-22 18:49:29","2","2020-05-22 18:49:29","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"189,27847","C201558","PERSONAL","Mr","5aOxCxukxb0+7NooBdnwuw==","ts1WQ6NWxfSAyKGz8YWojw==","","divCAd7vXBrFsEq37+IrUebZkd2rCyBptOzEcfnHz6Q=","WwQ6tIVSO1vm7KalqAOukA==","efYV0c63qr6rYumGpZlKgwD+Het1xLruDoo0bHw8mOE=","g5jc0Z+msob5McKlnN+YOg==",null,1,7627]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 18:49:30","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":["7934","6","2318.0","2318.00","2","2020-05-22 18:49:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 18:49:30","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-05-15","2020-06-14","6"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-22 18:49:30","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":["7934",1558,"SETTLED","A12-I208263","2020-05-22 18:49:29","2020-05-15","2","2020-05-22 18:49:29","2","2020-05-22 18:49:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 18:49:30","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":["8263","RENT","\u9810\u7e73\u79df\u91d1",1,2022,"MO","1",2022,"2","2020-05-22 18:49:29","2","2020-05-22 18:49:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 18:49:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2022,0,"8263"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-22 18:49:30","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":[1558,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207907","2020-05-22 18:49:29",2022,"2","2020-05-22 18:49:29","2","2020-05-22 18:49:29","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 18:49:30","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":["7907","DEPOSIT",null,"PAID","2020-05-22 18:49:29",0,"2","2020-05-22 18:49:29","2","2020-05-22 18:49:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-22 18:49:30","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":["7907","INVOICE","8263","PAID","2020-05-22 18:49:29",2022,"2","2020-05-22 18:49:29","2","2020-05-22 18:49:29"]},"data_before":[],"data_after":[],"step":1} *****