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

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

\u5009\u5eab\u7de8\u865f<\/td>\n	\u5c3a\u5bf8<\/td>\n	\u539f\u50f9(\u6708)<\/td>\n	\u512a\u60e0\u50f9(\u6708)<\/td>\n	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n	\u50f9\u683c<\/td>\n	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n	<\/td>\n <\/tr>
B01-051 <\/td>\n\t\t\t\t\t	4X6X7 <\/td>\n\t\t\t\t\t	$1488.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"24","total_discounted_price":"1310.00","deposit":"2976.00","total_retail_price":"1488.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 13:24:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","2","5","1637","NEW","B01-CT208194",1488,1310,2976,0,"6","6",10246,10896,10306,"2020-06-22 13:24:18","0",null,null,null,"2020-06-29","2020-12-28","6 months contract. Special offer 5% \"Rent Now\" discount and $200 \"switch to us\". Storage rental and deposit paid by EPS on June 22, 2020. Smartcard paid by EPS on June 22, 2020. ","2020-06-29","24",0,null,590,"590.00","2","2020-06-22 13:24:17","2","2020-06-22 13:24:17","EPS","","","","EPS","","","",null,0,"0012516858","C201637","PERSONAL","Mr","yvbO0GZNpEhCYtVAa\/5wFw==","ts1WQ6NWxfSAyKGz8YWojw==","","rlJDn35ptLLUJlvgLypVKZrC0OZ2GjjxgprsdMzFHUBfZLgqll7+jrbXuLj\/nQW6aM2Y93IgirdjN8XPm1c7FA==","O+GUyqtHYTQdA15mzXJBkw==","gVs3TPQVx1aVX68qxWVOCm4LkjaGgx0zHXLv1WxaWqU=","OeS3CGyEjmtqYlFfp8iEnA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 13:24:18","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":["8194","325 available_room_list_input","143","1241","%","26.62",396.1056,"2","2020-06-22 13:24:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 13:24:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8194","1637","11","1","60.0",60,"2","2020-06-22 13:24:17","2","2020-06-22 13:24:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 13:24:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"8194"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-06-22 13:24:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8194","1241","1488.0",1091.9,"2","2020-06-22 13:24:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 13:24:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-29","2020-12-28","1241"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-22 13:24:18","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":["8194","B01-D205491","PAID",2976,0,"2020-12-28","2020-06-22 13:24:17","2020-06-22 13:24:17","2","2020-06-22 13:24:17","2","2020-06-22 13:24:17","1637"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 13:24:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8194","1637","SETTLED","B01-I208523","2020-06-22 13:24:17","2020-06-29","2","2020-06-22 13:24:17","2","2020-06-22 13:24:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 13:24:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8523","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,720,"MO","1",720,"2","2020-06-22 13:24:17","2","2020-06-22 13:24:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 13:24:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8523","RENT","\u9810\u7e73\u79df\u91d1",2,1310,"MO","1",1310,"2","2020-06-22 13:24:17","2","2020-06-22 13:24:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 13:24:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8523","RENT","\u9810\u7e73\u79df\u91d1",3,1310,"MO","1",1310,"2","2020-06-22 13:24:17","2","2020-06-22 13:24:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 13:24:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8523","RENT","\u9810\u7e73\u79df\u91d1",4,1310,"MO","1",1310,"2","2020-06-22 13:24:17","2","2020-06-22 13:24:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 13:24:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8523","RENT","\u9810\u7e73\u79df\u91d1",5,1310,"MO","1",1310,"2","2020-06-22 13:24:17","2","2020-06-22 13:24:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 13:24:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8523","RENT","\u9810\u7e73\u79df\u91d1",6,1310,"MO","1",1310,"2","2020-06-22 13:24:17","2","2020-06-22 13:24:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 13:24:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8523","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-06-22 13:24:17","2","2020-06-22 13:24:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 13:24:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7330,0,"8523"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-22 13:24:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["1637","EPS","","","","EPS","","","","PAID","P208166","2020-06-22 13:24:17",10306,"2","2020-06-22 13:24:17","2","2020-06-22 13:24:17","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 13:24:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8166","DEPOSIT","5491","PAID","2020-06-22 13:24:17",2976,"2","2020-06-22 13:24:17","2","2020-06-22 13:24:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 13:24:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8166","INVOICE","8523","PAID","2020-06-22 13:24:17",7330,"2","2020-06-22 13:24:17","2","2020-06-22 13:24:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 13:50:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 14:37:47","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"1094","master_room_id":"117","room_code":"A05-092"},{"room_id":"1093","master_room_id":"117","room_code":"A05-091"}],"index_url_parameter":"filter1=2&filter2=1533&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_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\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-092 <\/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> A05-091 <\/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","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"P030927(7)","title":"Ms","lastname":"Chia","firstname":"Jacqueline Brigitte","companyname":"","email":"jackie_tjia@hotmail.com","tel":"97552210","address":"G\/F, Flat A, Albany Court, 5`1-53 Bisney Rd, Pok Fu Lam","pass":true,"customer_id":"780","customer_code":"C180780","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1094","room_code":"A05-092","retail_price":"1857.0","discounted_price":"1857.00","location_id":"4"},{"room_id":"1093","room_code":"A05-091","retail_price":"1857.0","discounted_price":"1857.00","location_id":"4"}],"roughly_size":"48","total_retail_price":3714,"total_discounted_price":3852,"deposit":7704,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":23883,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"6933.00","warehousing_date":"2020-07-01","rent_from":"2020-07-01","rent_to":"2020-12-31","delivery_service":"0","remark":"6 months contract. Special offer 50% off for first 3 months. Storage rental and deposit paid by EPS on June 22, 2020. Smart card provided on June 22, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":6933,"order_total":30816,"final_order_total":23883,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012488908","order_product":[],"pass":true}},"roughly_size":"48","total_discounted_price":"3852.00","deposit":"7704.00","total_retail_price":"3714.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 14:37:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","4","780","NEW","A05-CT208195",3714,3852,7704,0,"6","6",23883,30816,23883,"2020-06-22 14:37:48","0",null,null,null,"2020-07-01","2020-12-31","6 months contract. Special offer 50% off for first 3 months. Storage rental and deposit paid by EPS on June 22, 2020. Smart card provided on June 22, 2020. ","2020-07-01","48",0,null,6933,"6933.00","2","2020-06-22 14:37:47","2","2020-06-22 14:37:47","EPS","","","","EPS","","","",null,0,"0012488908","C180780","PERSONAL","Ms","1p7bDYDtTmM07v7ySaTkXOrEUVbL32JckPPqsCIbv\/w=","gqpBPhMXyxdjxQDjxaJzUw==","","vHATtF\/CIkXJXwV7irRZIMik8cgv4FFFjnDOP9GLR95qpvw7qcrDzBySpWQmcW5kAPLAacaoCktKa2J57XXg+A==","\/cSBTdAZw3bbIY7dhadNDA==","EBpA6lMjhOOSeSc7CI4FDz7o0RRi+YJRUiB6C6GSE\/M=","2VksV5Z1w1U+T3QEB+uYFQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 14:37: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":["8195","1094","1857.0","1857.00","2","2020-06-22 14:37:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 14:37: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-07-01","2020-12-31","1094"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-22 14:37: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":["8195","1093","1857.0","1857.00","2","2020-06-22 14:37:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 14:37: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-07-01","2020-12-31","1093"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-22 14:37:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["8195","A05-D205492","PAID",7704,0,"2020-12-31","2020-06-22 14:37:47","2020-06-22 14:37:47","2","2020-06-22 14:37:47","2","2020-06-22 14:37:47","780"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 14:37: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":["8195","780","SETTLED","A05-I208524","2020-06-22 14:37:47","2020-07-01","2","2020-06-22 14:37:47","2","2020-06-22 14:37:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 14:37: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":["8524","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-22 14:37:47","2","2020-06-22 14:37:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 14:37: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":["8524","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,771,"MO","1",771,"2","2020-06-22 14:37:47","2","2020-06-22 14:37:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 14:37: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":["8524","RENT","\u9810\u7e73\u79df\u91d1",3,3852,"MO","1",3852,"2","2020-06-22 14:37:47","2","2020-06-22 14:37:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 14:37: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":["8524","RENT","\u9810\u7e73\u79df\u91d1",4,3852,"MO","1",3852,"2","2020-06-22 14:37:47","2","2020-06-22 14:37:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 14:37: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":["8524","RENT","\u9810\u7e73\u79df\u91d1",5,3852,"MO","1",3852,"2","2020-06-22 14:37:47","2","2020-06-22 14:37:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 14:37: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":["8524","RENT","\u9810\u7e73\u79df\u91d1",6,3852,"MO","1",3852,"2","2020-06-22 14:37:47","2","2020-06-22 14:37:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 14:37:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[16179,0,"8524"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-22 14:37: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":["780","EPS","","","","EPS","","","","PAID","P208167","2020-06-22 14:37:47",23883,"2","2020-06-22 14:37:47","2","2020-06-22 14:37:47","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 14:37: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":["8167","DEPOSIT","5492","PAID","2020-06-22 14:37:47",7704,"2","2020-06-22 14:37:47","2","2020-06-22 14:37:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 14:37: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":["8167","INVOICE","8524","PAID","2020-06-22 14:37:47",16179,"2","2020-06-22 14:37:47","2","2020-06-22 14:37:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 15:24:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 15:38:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 15:42:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 16:22:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 16:29:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 16:58:39","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":607,"customer_code":"C170607","identity_type":"BUSINESS","identity_id":"34332225","title":"Mr","lastname":"Lam","firstname":"Jacky","companyname":"Taxwise Decoration Design Ltd.","email":null,"tel":"98833795","address":"Shop 516, 5\/F, Chi Fu Landmark, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1139.0","renew_rent_month":"6","renew_warehousing_date":"2020-06-16","renew_room_key":"055,14232","renew_remark":"6 months contract. Storage rental paid by cheque on December 20, 2019. Storage deposit transferred from agreement A14-CT195181 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196753, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"38","order_discount":[],"order_room":[{"room_id":"440","room_code":"J22","retail_price":"1528.0","discounted_price":"1528.00","location_id":"2"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1139,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6834,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-16","rent_from":"2020-06-16","rent_to":"2020-12-15","delivery_service":"0","remark":"6 months contract. Storage rental paid by cheque on June 22,2020. Storage deposit transferred from agreement A14-CT196753 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":6834,"final_order_total":6834,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,14232","order_product":[],"pass":true}},"first_order_id":"3892","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> J22 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1139.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 16:58:39","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",607,"NEW","A14-CT208196",1528,1139,0,0,"6","6",6834,6834,6834,"2020-06-22 16:58:39","0",null,null,null,"2020-06-16","2020-12-15","6 months contract. Storage rental paid by cheque on June 22,2020. Storage deposit transferred from agreement A14-CT196753 to this agreement.","2020-06-16","20",0,null,0,"0","2","2020-06-22 16:58:38","2","2020-06-22 16:58:38","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"055,14232","C170607","BUSINESS","Mr","1v4orkqLQ4k85\/SuEwnhhQ==","0JxYUqbNPOvgfMwVa0l0NA==","Taxwise Decoration Design Ltd.","S5RHrnuCe+8YS9L8iJEQsDrKDQt1pytS\/4VtQh0gSBe9D5ble5nYMnlRBDkcv4h6","HA525dRqfwMp+WB6CjtY8Q==",null,null,"ms0\/PcHzoIpW4AUFDYli0A==",1,"3892"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 16:58:39","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":["8196","440","1528.0","1528.00","2","2020-06-22 16:58:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 16:58:39","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-16","2020-12-15","440"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-22 16:58:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8196",607,"SETTLED","A14-I208525","2020-06-22 16:58:38","2020-06-16","2","2020-06-22 16:58:38","2","2020-06-22 16:58:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 16:58:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8525","RENT","\u9810\u7e73\u79df\u91d1",1,1139,"MO","1",1139,"2","2020-06-22 16:58:38","2","2020-06-22 16:58:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 16:58:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8525","RENT","\u9810\u7e73\u79df\u91d1",2,1139,"MO","1",1139,"2","2020-06-22 16:58:38","2","2020-06-22 16:58:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 16:58:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8525","RENT","\u9810\u7e73\u79df\u91d1",3,1139,"MO","1",1139,"2","2020-06-22 16:58:38","2","2020-06-22 16:58:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 16:58:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8525","RENT","\u9810\u7e73\u79df\u91d1",4,1139,"MO","1",1139,"2","2020-06-22 16:58:38","2","2020-06-22 16:58:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 16:58:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8525","RENT","\u9810\u7e73\u79df\u91d1",5,1139,"MO","1",1139,"2","2020-06-22 16:58:38","2","2020-06-22 16:58:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 16:58:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8525","RENT","\u9810\u7e73\u79df\u91d1",6,1139,"MO","1",1139,"2","2020-06-22 16:58:38","2","2020-06-22 16:58:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 16:58:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6834,0,"8525"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-22 16:58:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[607,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P208168","2020-06-22 16:58:38",6834,"2","2020-06-22 16:58:38","2","2020-06-22 16:58:38","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 16:58:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8168","DEPOSIT",null,"PAID","2020-06-22 16:58:38",0,"2","2020-06-22 16:58:38","2","2020-06-22 16:58:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 16:58:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8168","INVOICE","8525","PAID","2020-06-22 16:58:38",6834,"2","2020-06-22 16:58:38","2","2020-06-22 16:58:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 17:30:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 17:47:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 17:52:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:13:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:16:21","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&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":"699","master_room_id":"28","room_code":"N16"}],"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> N16 <\/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","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"D421709(9)","title":"Ms","lastname":"To","firstname":"Lai Na Linna","companyname":"","email":"","tel":"67601866","address":"\u9999\u6e2f\u9285\u947c\u7063\u6d77\u90fd\u5927\u5ec81\/F,G Room","pass":true,"customer_id":"268","customer_code":"C170268","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"699","room_code":"N16","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-05-01","rent_from":"2020-05-01","rent_to":"2020-07-31","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on June 22, 2020. Storage deposit $1196 transferred from agreement A14-CT208102 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":"135,20949","order_product":[],"pass":true}},"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-06-22 18:16:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2","268","NEW","A14-CT208197",598,568,0,0,"3","3",1704,1704,1704,"2020-06-22 18:16:21","0",null,null,null,"2020-05-01","2020-07-31","3 months contract. Storage rental paid by bank transfer on June 22, 2020. Storage deposit $1196 transferred from agreement A14-CT208102 to this agreement. ","2020-05-01","12",0,null,0,"0","2","2020-06-22 18:16:21","2","2020-06-22 18:16:21","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"135,20949","C170268","PERSONAL","Ms","tBQgDidK\/yVQr0lAqq5LPA==","ME1HgmDJnR5612zeAsjIHA==","","qpPAjyxsJ0n\/Kv7FGiRhvC+xFVuWjCcB9CtF7z1+Ool5R5f5x36ghU9yZVbmUHmP","G\/s3K1J7FjoHpr9g4onXlQ==",null,"AeHqveSHk3PK4RctlagJHg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:16:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8197","699","598.0","598.00","2","2020-06-22 18:16:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:16:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-01","2020-07-31","699"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-22 18:16:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8197","268","SETTLED","A14-I208526","2020-06-22 18:16:21","2020-05-01","2","2020-06-22 18:16:21","2","2020-06-22 18:16:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:16:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8526","RENT","\u9810\u7e73\u79df\u91d1",1,568,"MO","1",568,"2","2020-06-22 18:16:21","2","2020-06-22 18:16:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:16:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8526","RENT","\u9810\u7e73\u79df\u91d1",2,568,"MO","1",568,"2","2020-06-22 18:16:21","2","2020-06-22 18:16:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:16:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8526","RENT","\u9810\u7e73\u79df\u91d1",3,568,"MO","1",568,"2","2020-06-22 18:16:21","2","2020-06-22 18:16:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:16:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1704,0,"8526"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-22 18:16:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["268","NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208169","2020-06-22 18:16:21",1704,"2","2020-06-22 18:16:21","2","2020-06-22 18:16:21","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:16:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8169","DEPOSIT",null,"PAID","2020-06-22 18:16:21",0,"2","2020-06-22 18:16:21","2","2020-06-22 18:16:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:16:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8169","INVOICE","8526","PAID","2020-06-22 18:16:21",1704,"2","2020-06-22 18:16:21","2","2020-06-22 18:16:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:18:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:45: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":"","floor_plan_rent_room":[{"room_id":"699","master_room_id":"28","room_code":"N16"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":687,"customer_code":"C180687","identity_type":"PERSONAL","identity_id":"D675603(5)","title":"Ms","lastname":"Wong","firstname":"Lok Yi Candy","companyname":"","email":null,"tel":"90268152","address":"Flat C, 20\/F, Tower 1, Sham Wan Towers, Ap Lei Chau, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1036.0","renew_rent_month":"3","renew_warehousing_date":"2020-06-08","renew_room_key":"134,16041","renew_remark":"3 months contract. Storage rental paid by bank transferred on March 9, 2020. Storage deposit $2180 transferred from agreement A18-CT196756 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207363, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"77","order_discount":[],"order_room":[{"room_id":"882","room_code":"Y11","retail_price":"1090.0","discounted_price":"1090.00","location_id":"3"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":1036,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3108,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-08","rent_from":"2020-06-08","rent_to":"2020-09-07","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on June 22, 2020. Storage deposit $2180 transferred from agreement A18-CT207363 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3108,"final_order_total":3108,"location_id":"3","branch_id":"1","company_id":"1","room_key":"134,16041","order_product":[],"pass":true}},"first_order_id":"4800","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> Y11 <\/td>\r\n\t\t\t\t\t 3X4X7 <\/td>\r\n\t\t\t\t\t $1090.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"1036.0","deposit":"0","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:45:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",687,"NEW","A18-CT208198",1090,1036,0,0,"3","3",3108,3108,3108,"2020-06-22 18:45:26","0",null,null,null,"2020-06-08","2020-09-07","3 months contract. Storage rental paid by bank transfer on June 22, 2020. Storage deposit $2180 transferred from agreement A18-CT207363 to this agreement.","2020-06-08","12",0,null,0,"0","2","2020-06-22 18:45:25","2","2020-06-22 18:45:25","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"134,16041","C180687","PERSONAL","Ms","yV\/SioaJMiWMQj9QbjvBQw==","hULSwM2MvFtpeV9\/z+er8Q==","","gZZjKoytf7\/aMjBy24riG3+7FKQXKWQeN4c5ayDE3FZzZykIuMJePBDOg97SQO1Yv1Kx0L1KbejhBRZVd4rB7g==","6SPyQv\/GcjNiW8cG9Kb1XQ==",null,"h69NujE8OrYG3xO38t2f7w==",null,1,"4800"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:45:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8198","882","1090.0","1090.00","2","2020-06-22 18:45:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:45:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-08","2020-09-07","882"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-22 18:45:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8198",687,"SETTLED","A18-I208527","2020-06-22 18:45:25","2020-06-08","2","2020-06-22 18:45:25","2","2020-06-22 18:45:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:45:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8527","RENT","\u9810\u7e73\u79df\u91d1",1,1036,"MO","1",1036,"2","2020-06-22 18:45:25","2","2020-06-22 18:45:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:45:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8527","RENT","\u9810\u7e73\u79df\u91d1",2,1036,"MO","1",1036,"2","2020-06-22 18:45:25","2","2020-06-22 18:45:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:45:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8527","RENT","\u9810\u7e73\u79df\u91d1",3,1036,"MO","1",1036,"2","2020-06-22 18:45:25","2","2020-06-22 18:45:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:45:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3108,0,"8527"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-22 18:45:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[687,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208170","2020-06-22 18:45:25",3108,"2","2020-06-22 18:45:25","2","2020-06-22 18:45:25","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:45:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8170","DEPOSIT",null,"PAID","2020-06-22 18:45:25",0,"2","2020-06-22 18:45:25","2","2020-06-22 18:45:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:45:26","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8170","INVOICE","8527","PAID","2020-06-22 18:45:25",3108,"2","2020-06-22 18:45:25","2","2020-06-22 18:45:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:46:42","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"699","master_room_id":"28","room_code":"N16"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1165,"customer_code":"C191165","identity_type":"PERSONAL","identity_id":"D488336(6)","title":"Ms","lastname":"CHIU","firstname":"Man Kwan","companyname":"","email":"candichiu@hotmail.com","tel":"96512360","address":"Flat1003, 10\/F, Tai Hang Terrace, 5 Chu Fa RD, Tai Hang, 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-07-03","renew_room_key":"189,17463","renew_remark":"6 months contact. Storage rental paid by bank transfer on January 7, 2020. Storage deposit $1196 transferred from agreementA14-CT195368 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT206899, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"594","room_code":"M05","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-07-03","rent_from":"2020-07-03","rent_to":"2021-01-02","delivery_service":"0","remark":"6 months contract. Storage rental paid by EPS on January 7, 2020. Storage deposit $1196 transferred from agreement A14-CT206899 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"2","branch_id":"1","company_id":"1","room_key":"189,17463","order_product":[],"pass":true}},"first_order_id":"4078","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> M05 <\/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.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:46:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",1165,"NEW","A14-CT208199",598,538,0,0,"6","6",3228,3228,3228,"2020-06-22 18:46:42","0",null,null,null,"2020-07-03","2021-01-02","6 months contract. Storage rental paid by EPS on January 7, 2020. Storage deposit $1196 transferred from agreement A14-CT206899 to this agreement.","2020-07-03","12",0,null,0,"0","2","2020-06-22 18:46:42","2","2020-06-22 18:46:42","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"189,17463","C191165","PERSONAL","Ms","nc3fEXXJHnulVM\/GUMaHew==","+2U\/KB65ELBPajGnn0cBQw==","","urfXjI4Jimo1Uj91IXd8YLSPFD4+wAYUJfk3OjTs4g80p4DA436fWMJxbleLKDJhblfxiGIMV1pPw+ZwYtQduQ==","OmcRTHhYzrQ1CZc5esvItA==","vueNpHpcFC84z2RjGUE6F+92Jm6vaDCSwqvwsdA1ecg=","fs+3rtDIEM41Zps0NSod4Q==",null,1,"4078"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:46:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8199","594","598.0","598.00","2","2020-06-22 18:46:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:46:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-03","2021-01-02","594"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-22 18:46:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8199",1165,"SETTLED","A14-I208528","2020-06-22 18:46:42","2020-07-03","2","2020-06-22 18:46:42","2","2020-06-22 18:46:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:46:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8528","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-06-22 18:46:42","2","2020-06-22 18:46:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:46:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8528","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-06-22 18:46:42","2","2020-06-22 18:46:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:46:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8528","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-06-22 18:46:42","2","2020-06-22 18:46:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:46:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8528","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-06-22 18:46:42","2","2020-06-22 18:46:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:46:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8528","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-06-22 18:46:42","2","2020-06-22 18:46:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:46:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8528","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-06-22 18:46:42","2","2020-06-22 18:46:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:46:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"8528"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-22 18:46:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1165,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P208171","2020-06-22 18:46:42",3228,"2","2020-06-22 18:46:42","2","2020-06-22 18:46:42","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:46:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8171","DEPOSIT",null,"PAID","2020-06-22 18:46:42",0,"2","2020-06-22 18:46:42","2","2020-06-22 18:46:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:46:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8171","INVOICE","8528","PAID","2020-06-22 18:46:42",3228,"2","2020-06-22 18:46:42","2","2020-06-22 18:46:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:51:15","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":[],"selected_room_tr":"\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n\t\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\t\t\t\t \n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> M06 <\/td>\n\t\t\t\t\t 4X3X4 <\/td>\n\t\t\t\t\t $598.00 <\/td>\n\t\t\t\t - <\/td> <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\n\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"D488336(6)","title":"Ms","lastname":"CHIU","firstname":"Man Kwan","companyname":"","email":"candichiu@hotmail.com","tel":"96512360","address":"Flat1003, 10\/F, Tai Hang Terrace, 5 Chu Fa RD, Tai Hang, HK","pass":true,"customer_id":"1165","customer_code":"C191165","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"595","room_code":"M06","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":1196,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1794,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-22","rent_from":"2020-06-22","rent_to":"2020-07-21","delivery_service":"0","remark":"1 month contract. $500 deposit paid by cash. Remaining storage renal and deposit paid by EPS on June 22, 2020. Smartcard and padlock provided on June 22, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":0,"order_total":1794,"final_order_total":1794,"location_id":"2","branch_id":"1","company_id":"1","room_key":"189, 63728","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"598.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:51:16","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","1165","NEW","A14-CT208200",598,598,1196,0,"1","1",1794,1794,1794,"2020-06-22 18:51:16","0",null,null,null,"2020-06-22","2020-07-21","1 month contract. $500 deposit paid by cash. Remaining storage renal and deposit paid by EPS on June 22, 2020. Smartcard and padlock provided on June 22, 2020. ","2020-06-22","12",0,null,0,"0","2","2020-06-22 18:51:15","2","2020-06-22 18:51:15","EPS","","","","EPS","","","",null,0,"189, 63728","C191165","PERSONAL","Ms","nc3fEXXJHnulVM\/GUMaHew==","+2U\/KB65ELBPajGnn0cBQw==","","urfXjI4Jimo1Uj91IXd8YLSPFD4+wAYUJfk3OjTs4g80p4DA436fWMJxbleLKDJhblfxiGIMV1pPw+ZwYtQduQ==","OmcRTHhYzrQ1CZc5esvItA==","vueNpHpcFC84z2RjGUE6F+92Jm6vaDCSwqvwsdA1ecg=","fs+3rtDIEM41Zps0NSod4Q==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:51:16","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":["8200","595","598.0","598.00","2","2020-06-22 18:51:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:51:16","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-22","2020-07-21","595"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-22 18:51:16","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":["8200","A14-D205493","PAID",1196,0,"2020-07-21","2020-06-22 18:51:15","2020-06-22 18:51:15","2","2020-06-22 18:51:15","2","2020-06-22 18:51:15","1165"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:51:16","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":["8200","1165","SETTLED","A14-I208529","2020-06-22 18:51:15","2020-06-22","2","2020-06-22 18:51:15","2","2020-06-22 18:51:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:51:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8529","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-06-22 18:51:15","2","2020-06-22 18:51:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:51:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8529"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-22 18:51:16","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":["1165","EPS","","","","EPS","","","","PAID","P208172","2020-06-22 18:51:15",1794,"2","2020-06-22 18:51:15","2","2020-06-22 18:51:15","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:51:16","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":["8172","DEPOSIT","5493","PAID","2020-06-22 18:51:15",1196,"2","2020-06-22 18:51:15","2","2020-06-22 18:51:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:51:16","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":["8172","INVOICE","8529","PAID","2020-06-22 18:51:15",598,"2","2020-06-22 18:51:15","2","2020-06-22 18:51:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:54:29","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","189, 63728","1 month contract. $500 deposit paid by cash. Remaining storage renal and deposit paid by EPS on June 22, 2020. Smartcard and padlock provided on June 22, 2020. ","2020-06-22 18:54:29","2","+2U\/KB65ELBPajGnn0cBQw==","nc3fEXXJHnulVM\/GUMaHew==","vueNpHpcFC84z2RjGUE6F+92Jm6vaDCSwqvwsdA1ecg=","OmcRTHhYzrQ1CZc5esvItA==","urfXjI4Jimo1Uj91IXd8YLSPFD4+wAYUJfk3OjTs4g80p4DA436fWMJxbleLKDJhblfxiGIMV1pPw+ZwYtQduQ==",8200]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:55:35","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","floor_plan_rent_room":[{"room_id":"595","master_room_id":"28","room_code":"M06"}],"_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> M06 <\/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","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"D488336(6)","title":"Ms","lastname":"CHIU","firstname":"Man Kwan","companyname":"","email":"candichiu@hotmail.com","tel":"96512360","address":"Flat1003, 10\/F, Tai Hang Terrace, 5 Chu Fa RD, Tai Hang, HK","pass":true,"customer_id":"1165","customer_code":"C191165","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"595","room_code":"M06","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":1196,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1794,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-27","rent_from":"2020-06-27","rent_to":"2020-07-26","delivery_service":"0","remark":"1 month contract. $500 deposit paid by cash. Remaining storage renal and deposit paid by EPS on June 22, 2020. Smartcard and padlock provided on June 22, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":0,"order_total":1794,"final_order_total":1794,"location_id":"2","branch_id":"1","company_id":"1","room_key":"189, 63728","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"598.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:55:36","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","1165","NEW","A14-CT208201",598,598,1196,0,"1","1",1794,1794,1794,"2020-06-22 18:55:36","0",null,null,null,"2020-06-27","2020-07-26","1 month contract. $500 deposit paid by cash. Remaining storage renal and deposit paid by EPS on June 22, 2020. Smartcard and padlock provided on June 22, 2020. ","2020-06-27","12",0,null,0,"0","2","2020-06-22 18:55:35","2","2020-06-22 18:55:35","EPS","","","","EPS","","","",null,0,"189, 63728","C191165","PERSONAL","Ms","nc3fEXXJHnulVM\/GUMaHew==","+2U\/KB65ELBPajGnn0cBQw==","","urfXjI4Jimo1Uj91IXd8YLSPFD4+wAYUJfk3OjTs4g80p4DA436fWMJxbleLKDJhblfxiGIMV1pPw+ZwYtQduQ==","OmcRTHhYzrQ1CZc5esvItA==","vueNpHpcFC84z2RjGUE6F+92Jm6vaDCSwqvwsdA1ecg=","fs+3rtDIEM41Zps0NSod4Q==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:55:36","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":["8201","595","598.0","598.00","2","2020-06-22 18:55:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:55:36","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-27","2020-07-26","595"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-22 18:55:36","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":["8201","A14-D205494","PAID",1196,0,"2020-07-26","2020-06-22 18:55:35","2020-06-22 18:55:35","2","2020-06-22 18:55:35","2","2020-06-22 18:55:35","1165"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:55:36","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":["8201","1165","SETTLED","A14-I208530","2020-06-22 18:55:35","2020-06-27","2","2020-06-22 18:55:35","2","2020-06-22 18:55:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:55:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8530","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-06-22 18:55:35","2","2020-06-22 18:55:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:55:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8530"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-22 18:55:36","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":["1165","EPS","","","","EPS","","","","PAID","P208173","2020-06-22 18:55:35",1794,"2","2020-06-22 18:55:35","2","2020-06-22 18:55:35","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:55:36","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":["8173","DEPOSIT","5494","PAID","2020-06-22 18:55:35",1196,"2","2020-06-22 18:55:35","2","2020-06-22 18:55:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 18:55:36","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":["8173","INVOICE","8530","PAID","2020-06-22 18:55:35",598,"2","2020-06-22 18:55:35","2","2020-06-22 18:55:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 19:17:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 19:19:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 19:22:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 19:51:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-22 19:52:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****