\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>
K50 <\/td>\n\t\t\t\t\t	4X4X8 <\/td>\n\t\t\t\t\t	$1098.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"16","total_discounted_price":"1098.00","deposit":"2196.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 13:57: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":["C201670","PERSONAL","Ms","fKsudVAMlCHBiMQoxbSquw==","yXKLXTtbNpECaRVTZxF\/Rw==","","TVqPTe22rdA3nzhO1jWvLQ==",null,"ncDBNiaejmDiRJn51l8rt+AibcAQ8SoBCf8O5wmBWIO9ddehZqHN0k+tsIpZbjUc","viD\/ezrEw77S0LrBlQJVyQ==",null,null,"4nACHgwC0PjTXbf4zyyTkA==","2","2020-07-13 13:57:51","2","2020-07-13 13:57:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 13:57:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2",1670,"NEW","A14-CT208387",1098,1098,2196,0,"6","6",6810,8784,6810,"2020-07-13 13:57:53","0",null,null,null,"2020-07-20","2021-01-19","6 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit paid by EPS on Jul 13, 2020. Smart card and padlock provided on the same day.","2020-07-20","16",0,null,1974,"1974.00","2","2020-07-13 13:57:51","2","2020-07-13 13:57:51","EPS","","","","EPS","","","",null,0,"189, 12413","C201670","PERSONAL","Ms","fKsudVAMlCHBiMQoxbSquw==","yXKLXTtbNpECaRVTZxF\/Rw==","","ncDBNiaejmDiRJn51l8rt+AibcAQ8SoBCf8O5wmBWIO9ddehZqHN0k+tsIpZbjUc","TVqPTe22rdA3nzhO1jWvLQ==",null,"viD\/ezrEw77S0LrBlQJVyQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 13:57:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8387","513","1098.0","1098.00","2","2020-07-13 13:57:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 13:57:53","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-20","2021-01-19","513"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-13 13:57:53","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":["8387","A14-D205542","PAID",2196,0,"2021-01-19","2020-07-13 13:57:51","2020-07-13 13:57:51","2","2020-07-13 13:57:51","2","2020-07-13 13:57:51",1670]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 13:57:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8387",1670,"SETTLED","A14-I208716","2020-07-13 13:57:51","2020-07-20","2","2020-07-13 13:57:51","2","2020-07-13 13:57:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 13:57:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8716","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-07-13 13:57:51","2","2020-07-13 13:57:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 13:57:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8716","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,222,"MO","1",222,"2","2020-07-13 13:57:51","2","2020-07-13 13:57:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 13:57:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8716","RENT","\u9810\u7e73\u79df\u91d1",3,1098,"MO","1",1098,"2","2020-07-13 13:57:51","2","2020-07-13 13:57:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 13:57:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8716","RENT","\u9810\u7e73\u79df\u91d1",4,1098,"MO","1",1098,"2","2020-07-13 13:57:51","2","2020-07-13 13:57:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 13:57:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8716","RENT","\u9810\u7e73\u79df\u91d1",5,1098,"MO","1",1098,"2","2020-07-13 13:57:51","2","2020-07-13 13:57:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 13:57:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8716","RENT","\u9810\u7e73\u79df\u91d1",6,1098,"MO","1",1098,"2","2020-07-13 13:57:51","2","2020-07-13 13:57:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 13:57:53","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4614,0,"8716"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-13 13:57:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1670,"EPS","","","","EPS","","","","PAID","P208359","2020-07-13 13:57:51",6810,"2","2020-07-13 13:57:51","2","2020-07-13 13:57:51","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 13:57:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8359","DEPOSIT","5542","PAID","2020-07-13 13:57:51",2196,"2","2020-07-13 13:57:51","2","2020-07-13 13:57:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 13:57:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8359","INVOICE","8716","PAID","2020-07-13 13:57:51",4614,"2","2020-07-13 13:57:51","2","2020-07-13 13:57:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 15:17:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 15:17:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 15:32:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 16:06:00","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","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"Y107268(2)","title":"Ms","lastname":"Lam","firstname":"Sau Man","companyname":"","email":"lamsauman@hotmail.com","tel":"96318743","address":"Flat abc","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"68 available_room_list_input","master_room_id":"1","discount_type":"%","price":"598.00","disocunted_price":"538.20","discount":"10.00","monthly_deduct":59.8,"room_id":"206","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"206","room_code":"D10","retail_price":"598.0","discounted_price":538.2,"location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":1196,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":4268,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"156.00","warehousing_date":"2020-07-14","rent_from":"2020-07-14","rent_to":"2021-01-13","delivery_service":"0","remark":"","paymethod":"CREDIT_CARD","paymethod2":"CREDIT_CARD","discount_deduct":156,"order_total":4424,"final_order_total":4268,"location_id":"1","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"floor_plan_rent_room":[{"room_id":"228","master_room_id":"6","room_code":"D32"}],"selected_room_tr":"\n	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n	\n \n\n \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> D10 <\/td>\n\t\t\t\t\t 4X3X4 <\/td>\n\t\t\t\t\t $598.00 <\/td>\n\t\t\t\t - <\/td> \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":"12","total_discounted_price":"538.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 16:06:01","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":["C201671","PERSONAL","Ms","jqj780Uc5vHrwRXwkPiv7Q==","0JxYUqbNPOvgfMwVa0l0NA==","","REUzZHgSqL91l1f\/Wz0zpw==","jj3G9tZGoJsks6MoDIvD6zOf24FrOcI47zW3SafqdkY=","M3W6wConfDXeVW11peMSmQ==","oe8vo0zNpv4LsKKKVj0rgw==",null,"jj3G9tZGoJsks6MoDIvD6zOf24FrOcI47zW3SafqdkY=","g5x75O8bfSI6pyDndH+nBA==","2","2020-07-13 16:06:00","2","2020-07-13 16:06:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 16:06:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1",1671,"NEW","A12-CT208388",598,538,1196,0,"6","6",4268,4424,4268,"2020-07-13 16:06:02","0",null,null,null,"2020-07-14","2021-01-13","","2020-07-14","12",0,null,156,"156.00","2","2020-07-13 16:06:00","2","2020-07-13 16:06:00","CREDIT_CARD","","","","CREDIT_CARD","","","",null,0,"","C201671","PERSONAL","Ms","jqj780Uc5vHrwRXwkPiv7Q==","0JxYUqbNPOvgfMwVa0l0NA==","","M3W6wConfDXeVW11peMSmQ==","REUzZHgSqL91l1f\/Wz0zpw==","jj3G9tZGoJsks6MoDIvD6zOf24FrOcI47zW3SafqdkY=","oe8vo0zNpv4LsKKKVj0rgw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 16:06:02","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":["8388","68 available_room_list_input","1","206","%","10.00",59.8,"2","2020-07-13 16:06:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 16:06:02","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":["8388","206","598.0",538.2,"2","2020-07-13 16:06:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 16:06:02","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-14","2021-01-13","206"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-13 16:06:02","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":["8388","A12-D205543","PAID",1196,0,"2021-01-13","2020-07-13 16:06:00","2020-07-13 16:06:00","2","2020-07-13 16:06:00","2","2020-07-13 16:06:00",1671]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 16:06:02","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":["8388",1671,"SETTLED","A12-I208717","2020-07-13 16:06:00","2020-07-14","2","2020-07-13 16:06:00","2","2020-07-13 16:06:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 16:06:02","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":["8717","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,382,"MO","1",382,"2","2020-07-13 16:06:00","2","2020-07-13 16:06:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 16:06:02","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":["8717","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-07-13 16:06:00","2","2020-07-13 16:06:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 16:06:02","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":["8717","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-07-13 16:06:00","2","2020-07-13 16:06:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 16:06:02","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":["8717","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-07-13 16:06:00","2","2020-07-13 16:06:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 16:06:02","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":["8717","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-07-13 16:06:00","2","2020-07-13 16:06:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 16:06:02","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":["8717","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-07-13 16:06:00","2","2020-07-13 16:06:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 16:06:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3072,0,"8717"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-13 16:06:02","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":[1671,"CREDIT_CARD","","","","CREDIT_CARD","","","","PAID","P208360","2020-07-13 16:06:00",4268,"2","2020-07-13 16:06:00","2","2020-07-13 16:06:00","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 16:06:02","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":["8360","DEPOSIT","5543","PAID","2020-07-13 16:06:00",1196,"2","2020-07-13 16:06:00","2","2020-07-13 16:06:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 16:06:02","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":["8360","INVOICE","8717","PAID","2020-07-13 16:06:00",3072,"2","2020-07-13 16:06:00","2","2020-07-13 16:06:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 16:17:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 16:44:21","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","","","2020-07-13 16:44:21","2","0JxYUqbNPOvgfMwVa0l0NA==","jqj780Uc5vHrwRXwkPiv7Q==","jj3G9tZGoJsks6MoDIvD6zOf24FrOcI47zW3SafqdkY=","REUzZHgSqL91l1f\/Wz0zpw==","M3W6wConfDXeVW11peMSmQ==",8388]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 16:45:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 16:48:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 17:26:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 17:36:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 17:55:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 18:46:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 18:59: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":"","floor_plan_rent_room":[{"room_id":"1648","master_room_id":"210","room_code":"A16-157"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":62,"customer_code":"C160062","identity_type":"PERSONAL","identity_id":"K228082(5)","title":"Mr","lastname":"Yuen","firstname":"Kwok On, Mark","companyname":"","email":"ym6128@yahoo.com.hk","tel":"61287967","address":"Flat 7,20\/F ,Blk E, Yue Fai Court,Aberdeen","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-07-14","renew_room_key":"254,19454","renew_remark":"1 month contract. Storage rental $600 paid by cash deposit on June 09, 2020. Storage deposit transferred from agreement A12-CT207802 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT208083, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"1","order_discount":[],"order_room":[{"room_id":"214","room_code":"D18","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"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-07-14","rent_from":"2020-07-14","rent_to":"2020-08-13","delivery_service":"0","remark":"1 month contract. Storage rental $600 paid by cash deposit on Jul 13, 2020. Storage deposit transferred from agreement A12-CT208083 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"1","branch_id":"1","company_id":"1","room_key":"254,19454","order_product":[],"pass":true}},"first_order_id":"4763","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> D18 <\/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":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 18:59: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",62,"NEW","A12-CT208389",598,598,0,0,"1","1",598,598,598,"2020-07-13 18:59:01","0",null,null,null,"2020-07-14","2020-08-13","1 month contract. Storage rental $600 paid by cash deposit on Jul 13, 2020. Storage deposit transferred from agreement A12-CT208083 to this agreement.\r\n","2020-07-14","12",0,null,0,"0","2","2020-07-13 18:59:01","2","2020-07-13 18:59:01","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"254,19454","C160062","PERSONAL","Mr","Tq2aGqdc3HaJ2Dhv1kivng==","DtbrOSvE4C7BOu5x4dBFtg==","","2dywE7m0E1QsxnoSSYjXYNGzam8BrQqJlW4yfvPMcgEUuu+U\/Cd9GXzTFUxRV\/Gk","ALSdg5RJw2nKsrdRoyKl+w==","IHWbmboe0mGIN08sR8rCSx94uDCuEAuXNvmkUE\/zPAQ=","CPbHg76fKF8UJ5bblGTxzg==",null,1,"4763"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 18:59: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":["8389","214","598.0","598.00","2","2020-07-13 18:59:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 18:59: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-07-14","2020-08-13","214"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-13 18:59: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":["8389",62,"SETTLED","A12-I208718","2020-07-13 18:59:01","2020-07-14","2","2020-07-13 18:59:01","2","2020-07-13 18:59:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 18:59: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":["8718","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-07-13 18:59:01","2","2020-07-13 18:59:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 18:59:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8718"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-13 18:59: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":[62,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208361","2020-07-13 18:59:01",598,"2","2020-07-13 18:59:01","2","2020-07-13 18:59:01","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 18:59: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":["8361","DEPOSIT",null,"PAID","2020-07-13 18:59:01",0,"2","2020-07-13 18:59:01","2","2020-07-13 18:59:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 18:59: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":["8361","INVOICE","8718","PAID","2020-07-13 18:59:01",598,"2","2020-07-13 18:59:01","2","2020-07-13 18:59:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 19:01:50","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1648","master_room_id":"210","room_code":"A16-157"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":861,"customer_code":"C180861","identity_type":"PERSONAL","identity_id":"Z647966(A)","title":"Ms","lastname":"Lee ","firstname":"Sophia Antonia","companyname":"","email":"Sophialeehk@outlook.com","tel":"66899737","address":"Flat D, 21st Floor, 31 Robinson Road, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"934.0","renew_rent_month":"6","renew_warehousing_date":"2020-06-08","renew_room_key":"189,27905","renew_remark":"6 months contract. Storage rental paid by bank transfer on January 8, 2020. Storage deposit transferred from agreement A14-CT195327 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT206913, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"756","room_code":"O32","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":934,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5604,"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-12-07","delivery_service":"0","remark":"6 months contract. Storage rental fee paid by bank transfer on Jul 13, 2020. Storage deposit transferred from agreement A14-CT206913 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5604,"final_order_total":5604,"location_id":"2","branch_id":"1","company_id":"1","room_key":"189,27905","order_product":[],"pass":true}},"first_order_id":"3820","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> O32 <\/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","roughly_size":"12","total_discounted_price":"934.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 19:01:51","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",861,"NEW","A14-CT208390",998,934,0,0,"6","6",5604,5604,5604,"2020-07-13 19:01:51","0",null,null,null,"2020-06-08","2020-12-07","6 months contract. Storage rental fee paid by bank transfer on Jul 13, 2020. Storage deposit transferred from agreement A14-CT206913 to this agreement.\r\n","2020-06-08","12",0,null,0,"0","2","2020-07-13 19:01:50","2","2020-07-13 19:01:50","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"189,27905","C180861","PERSONAL","Ms","uJv8wdO1apOB27biwhzk+w==","TXvO5dZhVvXkdspfvdLgcA==","","FS0WuNUe1ZbozUFy0S8oNmzBeAiK6nEuoSDo9gAt8k5rZ6PJU28XbCmns6DsT9Jk","S8WzLrluA9mWX34OteXbLw==","8gH2Hgugm4zmcshoa1tXBefSemACGAS2A+q+w0Ku27I=","nsHrFfCGaaBCjdkvHzdMVw==",null,1,"3820"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 19:01:51","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":["8390","756","998.0","998.00","2","2020-07-13 19:01:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 19:01:51","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-12-07","756"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-13 19:01:51","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":["8390",861,"SETTLED","A14-I208719","2020-07-13 19:01:50","2020-06-08","2","2020-07-13 19:01:50","2","2020-07-13 19:01:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 19:01:51","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":["8719","RENT","\u9810\u7e73\u79df\u91d1",1,934,"MO","1",934,"2","2020-07-13 19:01:50","2","2020-07-13 19:01:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 19:01:51","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":["8719","RENT","\u9810\u7e73\u79df\u91d1",2,934,"MO","1",934,"2","2020-07-13 19:01:50","2","2020-07-13 19:01:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 19:01:51","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":["8719","RENT","\u9810\u7e73\u79df\u91d1",3,934,"MO","1",934,"2","2020-07-13 19:01:50","2","2020-07-13 19:01:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 19:01:51","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":["8719","RENT","\u9810\u7e73\u79df\u91d1",4,934,"MO","1",934,"2","2020-07-13 19:01:50","2","2020-07-13 19:01:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 19:01:51","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":["8719","RENT","\u9810\u7e73\u79df\u91d1",5,934,"MO","1",934,"2","2020-07-13 19:01:50","2","2020-07-13 19:01:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 19:01:51","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":["8719","RENT","\u9810\u7e73\u79df\u91d1",6,934,"MO","1",934,"2","2020-07-13 19:01:50","2","2020-07-13 19:01:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 19:01:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5604,0,"8719"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-13 19:01:51","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":[861,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208362","2020-07-13 19:01:50",5604,"2","2020-07-13 19:01:50","2","2020-07-13 19:01:50","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 19:01:51","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":["8362","DEPOSIT",null,"PAID","2020-07-13 19:01:50",0,"2","2020-07-13 19:01:50","2","2020-07-13 19:01:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 19:01:51","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":["8362","INVOICE","8719","PAID","2020-07-13 19:01:50",5604,"2","2020-07-13 19:01:50","2","2020-07-13 19:01:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 19:12:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-13 21:16:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****