\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>
A16-055 <\/td>\n\t\t\t\t\t	4X3X7 <\/td>\n\t\t\t\t\t	$1090.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\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"12","total_discounted_price":"899.00","deposit":"1996.00","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 15:17:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7","1571","NEW","A16-CT207715",1090,899,1996,0,"6","6",7390,7390,7390,"2020-04-24 15:17:06","0",null,null,null,"2020-05-01","2020-10-31","6 months contract. Storage rental and deposit paid by EPS on Apr 24,2020. Smart card and padlock provided on the same day.","2020-05-01","12",0,null,0,"0","2","2020-04-24 15:17:06","2","2020-04-24 15:17:06","EPS","","","","EPS","","","",null,0,"191,03186","C201571","PERSONAL","Mr","YVRBzziJKHPG+AdW7vor1g==","BxzCT5OGas7BCbwmbXAF7w==","","skwvLGyhr6Tazt51wOw81lyHgDc5RQzcpIO+HUEPh4rq9zzthVKccHfmWfIYen2c","Vn4MERb9IZyRUbECD2uCkg==","6\/MOUMKUm+Jw3lfIfwSl3YzIL0TQuXugFUow8Sak0o0=","QcyGJu\/kd8bZY+6n0voRsg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 15:17:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7715","1546","1090.0","1090.00","2","2020-04-24 15:17:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 15:17:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-01","2020-10-31","1546"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-24 15:17:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["7715","A16-D205389","PAID",1996,0,"2020-10-31","2020-04-24 15:17:06","2020-04-24 15:17:06","2","2020-04-24 15:17:06","2","2020-04-24 15:17:06","1571"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 15:17:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7715","1571","SETTLED","A16-I208043","2020-04-24 15:17:06","2020-05-01","2","2020-04-24 15:17:06","2","2020-04-24 15:17:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 15:17:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8043","RENT","\u9810\u7e73\u79df\u91d1",1,899,"MO","1",899,"2","2020-04-24 15:17:06","2","2020-04-24 15:17:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 15:17:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8043","RENT","\u9810\u7e73\u79df\u91d1",2,899,"MO","1",899,"2","2020-04-24 15:17:06","2","2020-04-24 15:17:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 15:17:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8043","RENT","\u9810\u7e73\u79df\u91d1",3,899,"MO","1",899,"2","2020-04-24 15:17:06","2","2020-04-24 15:17:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 15:17:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8043","RENT","\u9810\u7e73\u79df\u91d1",4,899,"MO","1",899,"2","2020-04-24 15:17:06","2","2020-04-24 15:17:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 15:17:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8043","RENT","\u9810\u7e73\u79df\u91d1",5,899,"MO","1",899,"2","2020-04-24 15:17:06","2","2020-04-24 15:17:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 15:17:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8043","RENT","\u9810\u7e73\u79df\u91d1",6,899,"MO","1",899,"2","2020-04-24 15:17:06","2","2020-04-24 15:17:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 15:17:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5394,0,"8043"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-24 15:17:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["1571","EPS","","","","EPS","","","","PAID","P207689","2020-04-24 15:17:06",7390,"2","2020-04-24 15:17:06","2","2020-04-24 15:17:06","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 15:17:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7689","DEPOSIT","5389","PAID","2020-04-24 15:17:06",1996,"2","2020-04-24 15:17:06","2","2020-04-24 15:17:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 15:17:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7689","INVOICE","8043","PAID","2020-04-24 15:17:06",5394,"2","2020-04-24 15:17:06","2","2020-04-24 15:17:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:11: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":"page=2","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1455","master_room_id":"170","room_code":"C15-149"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":358,"customer_code":"C170358","identity_type":"PERSONAL","identity_id":"K871057(0)","title":"Ms","lastname":"Chan","firstname":"Yin Kiu","companyname":"","email":"fionchan921@yahoo.com.hk","tel":"92740946","address":"\u9d28\u8137\u6d32\u6d77\u6021\u534a\u5cf65\u5ea72\u6a13G\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1788.0","renew_rent_month":"13","renew_warehousing_date":"2020-05-04","renew_room_key":"052,53583","renew_remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by bank transfer on April 12, 2019. Storage deposit transferred from agreement A12-CT183292 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT194756, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"37","room_code":"A37","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"},{"room_id":"36","room_code":"A36","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":1788,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":23244,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-04","rent_from":"2020-05-04","rent_to":"2021-06-03","delivery_service":"0","remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by cash on April 24, 2020. Storage deposit transferred from agreement A12-CT194756 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":23244,"final_order_total":23244,"location_id":"1","branch_id":"1","company_id":"1","room_key":"052,53583","order_product":[],"pass":true}},"first_order_id":4756,"selected_room_tr":"	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A37 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> A36 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"1788.0","deposit":"0.00","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:11:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",358,"NEW","A12-CT207716",2196,1788,0,0,"13","13",23244,23244,23244,"2020-04-24 16:11:22","0",null,null,null,"2020-05-04","2021-06-03","13 months contract. Special renewal offer, one month free. Storage rental paid by cash on April 24, 2020. Storage deposit transferred from agreement A12-CT194756 to this agreement.\r\n","2020-05-04","32",0,null,0,"0","2","2020-04-24 16:11:21","2","2020-04-24 16:11:21","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"052,53583","C170358","PERSONAL","Ms","TAHMIJkkAd1LSvj823UvjA==","U9yoE9KqV1v8YlRkf7Q2yg==","","xztHH5TbzA5tZa+5WtBZHazBBBtPAs2Y1v4ySjHLHaS+Elr4dxfULYk3o6B0oz00","giim5VrjpqR\/byyZo6VQww==","pSGpeXMtooOE1auJvDCFkvClrX2dF1eSwo6+TjNOTKg=","KoOg0nXOp48ocsHbLqClGQ==",null,1,4756]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:11:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7716","37","1098.0","1098.00","2","2020-04-24 16:11:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:11:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-04","2021-06-03","37"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-24 16:11:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7716","36","1098.0","1098.00","2","2020-04-24 16:11:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:11:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-04","2021-06-03","36"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-24 16:11:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7716",358,"SETTLED","A12-I208044","2020-04-24 16:11:21","2020-05-04","2","2020-04-24 16:11:21","2","2020-04-24 16:11:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:11:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8044","RENT","\u9810\u7e73\u79df\u91d1",1,1788,"MO","1",1788,"2","2020-04-24 16:11:21","2","2020-04-24 16:11:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:11:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8044","RENT","\u9810\u7e73\u79df\u91d1",2,1788,"MO","1",1788,"2","2020-04-24 16:11:21","2","2020-04-24 16:11:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:11:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8044","RENT","\u9810\u7e73\u79df\u91d1",3,1788,"MO","1",1788,"2","2020-04-24 16:11:21","2","2020-04-24 16:11:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:11:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8044","RENT","\u9810\u7e73\u79df\u91d1",4,1788,"MO","1",1788,"2","2020-04-24 16:11:21","2","2020-04-24 16:11:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:11:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8044","RENT","\u9810\u7e73\u79df\u91d1",5,1788,"MO","1",1788,"2","2020-04-24 16:11:21","2","2020-04-24 16:11:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:11:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8044","RENT","\u9810\u7e73\u79df\u91d1",6,1788,"MO","1",1788,"2","2020-04-24 16:11:21","2","2020-04-24 16:11:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:11:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8044","RENT","\u9810\u7e73\u79df\u91d1",7,1788,"MO","1",1788,"2","2020-04-24 16:11:21","2","2020-04-24 16:11:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:11:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8044","RENT","\u9810\u7e73\u79df\u91d1",8,1788,"MO","1",1788,"2","2020-04-24 16:11:21","2","2020-04-24 16:11:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:11:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8044","RENT","\u9810\u7e73\u79df\u91d1",9,1788,"MO","1",1788,"2","2020-04-24 16:11:21","2","2020-04-24 16:11:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:11:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8044","RENT","\u9810\u7e73\u79df\u91d1",10,1788,"MO","1",1788,"2","2020-04-24 16:11:21","2","2020-04-24 16:11:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:11:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8044","RENT","\u9810\u7e73\u79df\u91d1",11,1788,"MO","1",1788,"2","2020-04-24 16:11:21","2","2020-04-24 16:11:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:11:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8044","RENT","\u9810\u7e73\u79df\u91d1",12,1788,"MO","1",1788,"2","2020-04-24 16:11:21","2","2020-04-24 16:11:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:11:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8044","RENT","\u9810\u7e73\u79df\u91d1",13,1788,"MO","1",1788,"2","2020-04-24 16:11:21","2","2020-04-24 16:11:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:11:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[23244,0,"8044"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-24 16:11:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[358,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207690","2020-04-24 16:11:21",23244,"2","2020-04-24 16:11:21","2","2020-04-24 16:11:21","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:11:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7690","DEPOSIT",null,"PAID","2020-04-24 16:11:21",0,"2","2020-04-24 16:11:21","2","2020-04-24 16:11:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:11:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7690","INVOICE","8044","PAID","2020-04-24 16:11:21",23244,"2","2020-04-24 16:11:21","2","2020-04-24 16:11:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:12:28","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","052,53583","13 months contract. Special renewal offer, one month free. Storage rental paid by cash on April 24, 2020. Storage deposit transferred from agreement A12-CT194756 to this agreement.\r\n","2020-04-24 16:12:28","2","U9yoE9KqV1v8YlRkf7Q2yg==","TAHMIJkkAd1LSvj823UvjA==","pSGpeXMtooOE1auJvDCFkvClrX2dF1eSwo6+TjNOTKg=","giim5VrjpqR\/byyZo6VQww==","xztHH5TbzA5tZa+5WtBZHazBBBtPAs2Y1v4ySjHLHaS+Elr4dxfULYk3o6B0oz00",7716]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:15:26","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":"36","master_room_id":"8","room_code":"A36"},{"room_id":"37","master_room_id":"8","room_code":"A37"}],"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> A36 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> A37 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"K871057(0)","title":"Ms","lastname":"Chan","firstname":"Yin Kiu","companyname":"","email":"fionchan921@yahoo.com.hk","tel":"92740946","address":"\u9d28\u8137\u6d32\u6d77\u6021\u534a\u5cf65\u5ea72\u6a13G\u5ba4","pass":true,"customer_id":"358","customer_code":"C170358","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"73","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"913.00","discount":"16.85","monthly_deduct":185.013,"room_id":"36","is_final_discount":"0","payment_term":"PREPAID_12_MO"},{"master_room_discount_id":"73","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"913.00","discount":"16.85","monthly_deduct":185.013,"room_id":"37","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"36","room_code":"A36","retail_price":"1098.0","discounted_price":913,"location_id":"1"},{"room_id":"37","room_code":"A37","retail_price":"1098.0","discounted_price":913,"location_id":"1"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":1788,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":21456,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-04","rent_from":"2020-05-04","rent_to":"2021-05-03","delivery_service":"0","remark":"12 months contract. Special offer $300 Maxim's voucher. Storage rental paid by cash on April 24, 2020. Storage deposit transferred from agreement A12-CT194756 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":21456,"final_order_total":21456,"location_id":"1","branch_id":"1","company_id":"1","room_key":"052,53583","order_product":[],"pass":true}},"roughly_size":"32","total_discounted_price":"1788.00","deposit":"0.00","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:15:27","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","358","NEW","A12-CT207717",2196,1788,0,0,"12","12",21456,21456,21456,"2020-04-24 16:15:27","0",null,null,null,"2020-05-04","2021-05-03","12 months contract. Special offer $300 Maxim's voucher. Storage rental paid by cash on April 24, 2020. Storage deposit transferred from agreement A12-CT194756 to this agreement.","2020-05-04","32",0,null,0,"0","2","2020-04-24 16:15:26","2","2020-04-24 16:15:26","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"052,53583","C170358","PERSONAL","Ms","TAHMIJkkAd1LSvj823UvjA==","U9yoE9KqV1v8YlRkf7Q2yg==","","xztHH5TbzA5tZa+5WtBZHazBBBtPAs2Y1v4ySjHLHaS+Elr4dxfULYk3o6B0oz00","giim5VrjpqR\/byyZo6VQww==","pSGpeXMtooOE1auJvDCFkvClrX2dF1eSwo6+TjNOTKg=","KoOg0nXOp48ocsHbLqClGQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:15:27","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":["7717","73","8","36","%","16.85",185.013,"2","2020-04-24 16:15:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:15:27","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":["7717","73","8","37","%","16.85",185.013,"2","2020-04-24 16:15:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:15:27","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":["7717","36","1098.0",913,"2","2020-04-24 16:15:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:15:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-04","2021-05-03","36"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-24 16:15:27","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":["7717","37","1098.0",913,"2","2020-04-24 16:15:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:15:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-04","2021-05-03","37"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-24 16:15:27","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":["7717","358","SETTLED","A12-I208045","2020-04-24 16:15:26","2020-05-04","2","2020-04-24 16:15:26","2","2020-04-24 16:15:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:15:27","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":["8045","RENT","\u9810\u7e73\u79df\u91d1",1,1788,"MO","1",1788,"2","2020-04-24 16:15:26","2","2020-04-24 16:15:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:15:27","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":["8045","RENT","\u9810\u7e73\u79df\u91d1",2,1788,"MO","1",1788,"2","2020-04-24 16:15:26","2","2020-04-24 16:15:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:15:27","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":["8045","RENT","\u9810\u7e73\u79df\u91d1",3,1788,"MO","1",1788,"2","2020-04-24 16:15:26","2","2020-04-24 16:15:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:15:27","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":["8045","RENT","\u9810\u7e73\u79df\u91d1",4,1788,"MO","1",1788,"2","2020-04-24 16:15:26","2","2020-04-24 16:15:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:15:27","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":["8045","RENT","\u9810\u7e73\u79df\u91d1",5,1788,"MO","1",1788,"2","2020-04-24 16:15:26","2","2020-04-24 16:15:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:15:27","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":["8045","RENT","\u9810\u7e73\u79df\u91d1",6,1788,"MO","1",1788,"2","2020-04-24 16:15:26","2","2020-04-24 16:15:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:15:27","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":["8045","RENT","\u9810\u7e73\u79df\u91d1",7,1788,"MO","1",1788,"2","2020-04-24 16:15:26","2","2020-04-24 16:15:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:15:27","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":["8045","RENT","\u9810\u7e73\u79df\u91d1",8,1788,"MO","1",1788,"2","2020-04-24 16:15:26","2","2020-04-24 16:15:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:15:27","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":["8045","RENT","\u9810\u7e73\u79df\u91d1",9,1788,"MO","1",1788,"2","2020-04-24 16:15:26","2","2020-04-24 16:15:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:15:27","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":["8045","RENT","\u9810\u7e73\u79df\u91d1",10,1788,"MO","1",1788,"2","2020-04-24 16:15:26","2","2020-04-24 16:15:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:15:27","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":["8045","RENT","\u9810\u7e73\u79df\u91d1",11,1788,"MO","1",1788,"2","2020-04-24 16:15:26","2","2020-04-24 16:15:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:15:27","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":["8045","RENT","\u9810\u7e73\u79df\u91d1",12,1788,"MO","1",1788,"2","2020-04-24 16:15:26","2","2020-04-24 16:15:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:15:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[21456,0,"8045"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-24 16:15:27","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":["358","NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207691","2020-04-24 16:15:26",21456,"2","2020-04-24 16:15:26","2","2020-04-24 16:15:26","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:15:27","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":["7691","DEPOSIT",null,"PAID","2020-04-24 16:15:26",0,"2","2020-04-24 16:15:26","2","2020-04-24 16:15:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 16:15:27","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":["7691","INVOICE","8045","PAID","2020-04-24 16:15:26",21456,"2","2020-04-24 16:15:26","2","2020-04-24 16:15:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 17:51:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 18:02:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 18:02:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 18:50:18","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 18:56:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:04:56","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","floor_plan_rent_room":[{"room_id":"784","master_room_id":"44","room_code":"P18"}],"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> P18 <\/td>\r\n\t\t\t\t\t 4X6X8 <\/td>\r\n\t\t\t\t\t $1768.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":"C633471(5)","title":"Ms","lastname":"Ng","firstname":"Hiu Tan","companyname":"","email":"","tel":"91704988","address":"Flat A, 30\/F, Tower 3, Marinella, 9 Welfare Road, Wong Chuk Hang, Hong Kong","pass":true,"customer_id":"969","customer_code":"C180969","customer_first_order":false},"2":{"order_discount":[],"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"935.0","renew_rent_month":"6","renew_warehousing_date":"2020-04-25","renew_room_key":"136,19054 \/135,27708","renew_remark":"6 months contract. Storage rental paid by bank transfer on October 24, 2019. Storage deposit transferred from agreement A14-CT194792 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196217, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_room":[{"room_id":"784","room_code":"P18","retail_price":"1768.0","discounted_price":"1768.00","location_id":"2"}],"roughly_size":"24","total_retail_price":1768,"total_discounted_price":1592,"deposit":3536,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":22640,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1592.00","warehousing_date":"2020-04-20","rent_from":"2020-04-20","rent_to":"2021-05-19","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage deposit and rental paid by bank transfer on April 24, 2020. ","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":1592,"order_total":24232,"final_order_total":22640,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,40089,076,49432","order_product":[],"pass":true}},"renew":1,"first_order_id":"4792","roughly_size":"24","total_discounted_price":"1592.00","deposit":"3536.00","total_retail_price":"1768.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:04:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2","969","NEW","A14-CT207718",1768,1592,3536,0,"13","13",22640,24232,22640,"2020-04-24 19:04:57","0",null,null,null,"2020-04-20","2021-05-19","13 months contract. Special offer the 13th month free. Storage deposit and rental paid by bank transfer on April 24, 2020. ","2020-04-20","24",0,null,1592,"1592.00","2","2020-04-24 19:04:56","2","2020-04-24 19:04:56","BANKIN","","","","BANKIN","","","",null,0,"076,40089,076,49432","C180969","PERSONAL","Ms","EjdJsy5VEwJLjCCQ6WNs+g==","cxr02xsD1tXvJ4ihJHZKWw==","","eVDPbX5Bu0EQgjydh0Nz3ogb0moEtmLPllwIgTfrvGkGdtHz9i2W+lf5xJbOffoaRsPCtDEEhLqivifHeQcYqCayG6ooW3ZNfgnCxh1QYGw=","NsoeXllnDwXK9214ebFM4g==",null,"7\/glOjJX0TsHJ3ixbsnxOA==",null,1,"4792"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:04:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7718","784","1768.0","1768.00","2","2020-04-24 19:04:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:04:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-20","2021-05-19","784"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-24 19:04:57","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":["7718","A14-D205390","PAID",3536,0,"2021-05-19","2020-04-24 19:04:56","2020-04-24 19:04:56","2","2020-04-24 19:04:56","2","2020-04-24 19:04:56","969"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:04:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7718","969","SETTLED","A14-I208046","2020-04-24 19:04:56","2020-04-20","2","2020-04-24 19:04:56","2","2020-04-24 19:04:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:04:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8046","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1592,"MO","1",1592,"2","2020-04-24 19:04:56","2","2020-04-24 19:04:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:04:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8046","RENT","\u9810\u7e73\u79df\u91d1",3,1592,"MO","1",1592,"2","2020-04-24 19:04:56","2","2020-04-24 19:04:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:04:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8046","RENT","\u9810\u7e73\u79df\u91d1",4,1592,"MO","1",1592,"2","2020-04-24 19:04:56","2","2020-04-24 19:04:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:04:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8046","RENT","\u9810\u7e73\u79df\u91d1",5,1592,"MO","1",1592,"2","2020-04-24 19:04:56","2","2020-04-24 19:04:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:04:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8046","RENT","\u9810\u7e73\u79df\u91d1",6,1592,"MO","1",1592,"2","2020-04-24 19:04:56","2","2020-04-24 19:04:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:04:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8046","RENT","\u9810\u7e73\u79df\u91d1",7,1592,"MO","1",1592,"2","2020-04-24 19:04:56","2","2020-04-24 19:04:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:04:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8046","RENT","\u9810\u7e73\u79df\u91d1",8,1592,"MO","1",1592,"2","2020-04-24 19:04:56","2","2020-04-24 19:04:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:04:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8046","RENT","\u9810\u7e73\u79df\u91d1",9,1592,"MO","1",1592,"2","2020-04-24 19:04:56","2","2020-04-24 19:04:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:04:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8046","RENT","\u9810\u7e73\u79df\u91d1",10,1592,"MO","1",1592,"2","2020-04-24 19:04:56","2","2020-04-24 19:04:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:04:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8046","RENT","\u9810\u7e73\u79df\u91d1",11,1592,"MO","1",1592,"2","2020-04-24 19:04:56","2","2020-04-24 19:04:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:04:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8046","RENT","\u9810\u7e73\u79df\u91d1",12,1592,"MO","1",1592,"2","2020-04-24 19:04:56","2","2020-04-24 19:04:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:04:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8046","RENT","\u9810\u7e73\u79df\u91d1",13,1592,"MO","1",1592,"2","2020-04-24 19:04:56","2","2020-04-24 19:04:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:04:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[19104,0,"8046"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-24 19:04:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["969","BANKIN","","","","BANKIN","","","","PAID","P207692","2020-04-24 19:04:56",22640,"2","2020-04-24 19:04:56","2","2020-04-24 19:04:56","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:04:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7692","DEPOSIT","5390","PAID","2020-04-24 19:04:56",3536,"2","2020-04-24 19:04:56","2","2020-04-24 19:04:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:04:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7692","INVOICE","8046","PAID","2020-04-24 19:04:56",19104,"2","2020-04-24 19:04:56","2","2020-04-24 19:04:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:09:23","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":"784","master_room_id":"44","room_code":"P18"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":327,"customer_code":"C170327","identity_type":"PERSONAL","identity_id":"Z011471(6)","title":"Mrs","lastname":"TING ","firstname":"Sze Ling","companyname":"","email":null,"tel":"98820088","address":"Flat 4,Floor 4,Kong Tai Court,Aberdeen ","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"935.0","renew_rent_month":"6","renew_warehousing_date":"2020-04-25","renew_room_key":"136,19054 \/135,27708","renew_remark":"6 months contract. Storage rental paid by bank transfer on October 24, 2019. Storage deposit transferred from agreement A14-CT194792 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196217, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"484","room_code":"K21","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":935,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5610,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-25","rent_from":"2020-04-25","rent_to":"2020-10-24","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on April 24, 2020. Storage deposit transferred from agreement A14-CT196217 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5610,"final_order_total":5610,"location_id":"2","branch_id":"1","company_id":"1","room_key":"136,19054 \/135,27708","order_product":[],"pass":true}},"first_order_id":"4792","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> K21 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"935.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:09:23","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",327,"NEW","A14-CT207719",1098,935,0,0,"6","6",5610,5610,5610,"2020-04-24 19:09:23","0",null,null,null,"2020-04-25","2020-10-24","6 months contract. Storage rental paid by bank transfer on April 24, 2020. Storage deposit transferred from agreement A14-CT196217 to this agreement.\r\n","2020-04-25","16",0,null,0,"0","2","2020-04-24 19:09:23","2","2020-04-24 19:09:23","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"136,19054 \/135,27708","C170327","PERSONAL","Mrs","Jf7zEqHXl7\/pwrPYRoFwjw==","YopYTve\/2OD75skoAnqbtw==","","2hmhWBGvkZIoHzGPbhzhSV6dSCxka+bMmL61\/e5rYZ6lGw+kCxcBNmaCmzRgrkyP","m5wmdN\/FF1tGOIpFvAACTw==",null,"f4EFtxT9gNPepf5OEOPvDA==",null,1,"4792"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:09:23","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":["7719","484","1098.0","1098.00","2","2020-04-24 19:09:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:09:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-25","2020-10-24","484"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-24 19:09:23","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":["7719",327,"SETTLED","A14-I208047","2020-04-24 19:09:23","2020-04-25","2","2020-04-24 19:09:23","2","2020-04-24 19:09:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:09:23","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":["8047","RENT","\u9810\u7e73\u79df\u91d1",1,935,"MO","1",935,"2","2020-04-24 19:09:23","2","2020-04-24 19:09:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:09:23","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":["8047","RENT","\u9810\u7e73\u79df\u91d1",2,935,"MO","1",935,"2","2020-04-24 19:09:23","2","2020-04-24 19:09:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:09:23","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":["8047","RENT","\u9810\u7e73\u79df\u91d1",3,935,"MO","1",935,"2","2020-04-24 19:09:23","2","2020-04-24 19:09:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:09:23","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":["8047","RENT","\u9810\u7e73\u79df\u91d1",4,935,"MO","1",935,"2","2020-04-24 19:09:23","2","2020-04-24 19:09:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:09:23","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":["8047","RENT","\u9810\u7e73\u79df\u91d1",5,935,"MO","1",935,"2","2020-04-24 19:09:23","2","2020-04-24 19:09:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:09:23","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":["8047","RENT","\u9810\u7e73\u79df\u91d1",6,935,"MO","1",935,"2","2020-04-24 19:09:23","2","2020-04-24 19:09:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:09:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5610,0,"8047"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-24 19:09:23","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":[327,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207693","2020-04-24 19:09:23",5610,"2","2020-04-24 19:09:23","2","2020-04-24 19:09:23","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:09:23","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":["7693","DEPOSIT",null,"PAID","2020-04-24 19:09:23",0,"2","2020-04-24 19:09:23","2","2020-04-24 19:09:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:09:23","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":["7693","INVOICE","8047","PAID","2020-04-24 19:09:23",5610,"2","2020-04-24 19:09:23","2","2020-04-24 19:09:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:15:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-24 19:15:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****