\r\n\t\t\t\t\tM31 4X3X4 $598.00 N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"568.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 10:52: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","2",673,"NEW","A14-CT207511",598,568,0,0,"3","3",1704,1704,1704,"2020-03-28 10:52:01","0",null,null,null,"2020-04-01","2020-06-30","3 months contract. Storage rental paid by bank transfer on March 27, 2020. Storage deposit transferred from agreement A14-CT207155 to this agreement.\r\n","2020-04-01","12",0,null,0,"0","2","2020-03-28 10:52:01","2","2020-03-28 10:52:01","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,58226,076,35816","C170673","PERSONAL","Mr","ITD2Z30msP76kNRsYAQJdA==","7KCehmxbvwRMb+U8lHGoVA==","","HdXbjSMvv+ZR14503QlGfIIJx53YwiSYo18C3zg2iAsoCVGYQ5WI8DdHfRG1zNaPWkGvmtKZhfECBhHRiUVkSg==","7i41GG+VMMQ0anZ5o5qU1A==","CYmwmTN8U9iiSrWcIU95bF9znWI7Bh\/wdBd3p1sJ\/Ew=","V8J6VCsbvmxznZr8ycizJA==",null,1,"4685"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 10:52: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":["7511","620","598.0","598.00","2","2020-03-28 10:52:01"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 10:52:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-01","2020-06-30","620"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-28 10:52: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":["7511",673,"SETTLED","A14-I207839","2020-03-28 10:52:01","2020-04-01","2","2020-03-28 10:52:01","2","2020-03-28 10:52:01"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 10:52: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":["7839","RENT","\u9810\u7e73\u79df\u91d1",1,568,"MO","1",568,"2","2020-03-28 10:52:01","2","2020-03-28 10:52:01"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 10:52: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":["7839","RENT","\u9810\u7e73\u79df\u91d1",2,568,"MO","1",568,"2","2020-03-28 10:52:01","2","2020-03-28 10:52:01"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 10:52: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":["7839","RENT","\u9810\u7e73\u79df\u91d1",3,568,"MO","1",568,"2","2020-03-28 10:52:01","2","2020-03-28 10:52:01"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 10:52:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1704,0,"7839"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-28 10:52: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":[673,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207486","2020-03-28 10:52:01",1704,"2","2020-03-28 10:52:01","2","2020-03-28 10:52:01","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 10:52: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":["7486","DEPOSIT",null,"PAID","2020-03-28 10:52:01",0,"2","2020-03-28 10:52:01","2","2020-03-28 10:52:01"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 10:52: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":["7486","INVOICE","7839","PAID","2020-03-28 10:52:01",1704,"2","2020-03-28 10:52:01","2","2020-03-28 10:52:01"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 11:44:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 11:55:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 11:57:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 11:59:09","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:00:22","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"all=1&page=2&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"561","master_room_id":"48","room_code":"L39"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tL39 4X8X8 $2318.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"D612256(7)","title":"Mr","lastname":"YU","firstname":"Chun Yip","companyname":"","email":"","tel":"98729311","address":"Flat E, 7\/F, Fu Hing Yuen, Block 20, Chi Fu Fa Yuen, Pok Fu Lam, Hong Kong","pass":true,"customer_id":"1514","customer_code":"C201514","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"216","master_room_id":"48","discount_type":"%","price":"2318.00","disocunted_price":"2202.10","discount":"5.00","monthly_deduct":115.9,"room_id":"561","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"561","room_code":"L39","retail_price":"2318.0","discounted_price":2202.1,"location_id":"2"}],"roughly_size":"32","total_retail_price":2318,"total_discounted_price":2202,"deposit":4636,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":8113,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3129.00","warehousing_date":"2020-04-10","rent_from":"2020-04-10","rent_to":"2020-07-09","delivery_service":"0","remark":"3 months contract. Special offer first 3 months 50% off. Storage rental and deposit paid by EPS on March 28, 2020. Smartcard and padlock provided on March 28, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":3129,"order_total":11242,"final_order_total":8113,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076, 33825","order_product":[],"pass":true}},"roughly_size":"32","total_discounted_price":"2202.00","deposit":"4636.00","total_retail_price":"2318.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:00: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` = ?","parameters":["1","1","2","1514","NEW","A14-CT207512",2318,2202,4636,0,"3","3",8113,11242,8113,"2020-03-28 12:00:23","0",null,null,null,"2020-04-10","2020-07-09","3 months contract. Special offer first 3 months 50% off. Storage rental and deposit paid by EPS on March 28, 2020. Smartcard and padlock provided on March 28, 2020. ","2020-04-10","32",0,null,3129,"3129.00","2","2020-03-28 12:00:22","2","2020-03-28 12:00:22","EPS","","","","EPS","","","",null,0,"076, 33825","C201514","PERSONAL","Mr","hRdzpULvXqZc8yZLO430Jg==","4sZhlLfrmxrYN8eefiQ6Rg==","","hgKKZ\/pua0x41ySlpXfhxF1xcpxInmqku\/txM4dEpdZYc+7rYpScQcLYEwNCebrzd+4FGMTSE\/LYmonAI8aKgIGnZE+zk3nYoSwB7TFjl6Q=","TJG7aCKq7ZN5hCZlYEVwiw==",null,"bjZTHYGuzKcejIqUDuUGiw==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:00:23","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":["7512","216","48","561","%","5.00",115.9,"2","2020-03-28 12:00:22"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:00: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":["7512","561","2318.0",2202.1,"2","2020-03-28 12:00:22"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:00: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-10","2020-07-09","561"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-28 12:00:23","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":["7512","A14-D205342","PAID",4636,0,"2020-07-09","2020-03-28 12:00:22","2020-03-28 12:00:22","2","2020-03-28 12:00:22","2","2020-03-28 12:00:22","1514"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:00: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":["7512","1514","SETTLED","A14-I207840","2020-03-28 12:00:22","2020-04-10","2","2020-03-28 12:00:22","2","2020-03-28 12:00:22"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:00: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":["7840","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-03-28 12:00:22","2","2020-03-28 12:00:22"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:00: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":["7840","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1275,"MO","1",1275,"2","2020-03-28 12:00:22","2","2020-03-28 12:00:22"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:00: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":["7840","RENT","\u9810\u7e73\u79df\u91d1",3,2202,"MO","1",2202,"2","2020-03-28 12:00:22","2","2020-03-28 12:00:22"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:00:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3477,0,"7840"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-28 12:00: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":["1514","EPS","","","","EPS","","","","PAID","P207487","2020-03-28 12:00:22",8113,"2","2020-03-28 12:00:22","2","2020-03-28 12:00:22","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:00: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":["7487","DEPOSIT","5342","PAID","2020-03-28 12:00:22",4636,"2","2020-03-28 12:00:22","2","2020-03-28 12:00:22"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:00: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":["7487","INVOICE","7840","PAID","2020-03-28 12:00:22",3477,"2","2020-03-28 12:00:22","2","2020-03-28 12:00:22"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:04:51","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":"Y190882(3)","title":"Ms","lastname":"Ying","firstname":"Man Yan","companyname":"","email":"habeying@gmail.com","tel":"92758858","address":"Flat 1001, Wah Tai House, Wah Fu Estate, Aberdeen","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"70 available_room_list_input","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"898.60","discount":"9.96","monthly_deduct":99.4008,"room_id":"395","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"395","room_code":"H05","retail_price":"998.0","discounted_price":898.6,"location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":899,"deposit":1996,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":7390,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-05","rent_from":"2020-04-05","rent_to":"2020-10-04","delivery_service":"0","remark":"","paymethod":"EPS","paymethod2":"EPS","discount_deduct":0,"order_total":7390,"final_order_total":7390,"location_id":"1","branch_id":"1","company_id":"1","room_key":"0067","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \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> \n\t\t\t\t\tH05 4X3X8 $998.00 - <\/td> \u9810\u4ed83\u500b\u6708 \n\t\t\t\t\t\t \n\t\t\t\t\t\t \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":"998.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:04:52","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":["C201546","PERSONAL","Ms","DEsjf\/hIHAhqvhzJu3OiFw==","a5E+yNbaWqTnkftXSQVfxQ==","","qszZNWNzYXkRrgL\/3TAxUw==","N8T2O5c2De5TxVJ6PoSTEObuAo3Xd9Sb3fNiU1SPOPo=","ohDdmf6xsR4042\/Mo9qDArG+NxMoUFTz8uLzpvCbYAfgcTPAy2H1jf10BwjjU0DUl1qx7gyITGWJ5MYz1V\/CIg==","UX6ozue2qQsHxsW4980xMQ==",null,"N8T2O5c2De5TxVJ6PoSTEObuAo3Xd9Sb3fNiU1SPOPo=","8G9tH1Soo+u\/Yqw\/VzCKvQ==","2","2020-03-28 12:04:51","2","2020-03-28 12:04:51"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:04:52","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",1546,"NEW","A12-CT207513",998,899,1996,0,"6","6",7390,7390,7390,"2020-03-28 12:04:52","0",null,null,null,"2020-04-05","2020-10-04","","2020-04-05","12",0,null,0,"0","2","2020-03-28 12:04:51","2","2020-03-28 12:04:51","EPS","","","","EPS","","","",null,0,"0067","C201546","PERSONAL","Ms","DEsjf\/hIHAhqvhzJu3OiFw==","a5E+yNbaWqTnkftXSQVfxQ==","","ohDdmf6xsR4042\/Mo9qDArG+NxMoUFTz8uLzpvCbYAfgcTPAy2H1jf10BwjjU0DUl1qx7gyITGWJ5MYz1V\/CIg==","qszZNWNzYXkRrgL\/3TAxUw==","N8T2O5c2De5TxVJ6PoSTEObuAo3Xd9Sb3fNiU1SPOPo=","UX6ozue2qQsHxsW4980xMQ==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:04:52","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":["7513","70 available_room_list_input","6","395","%","9.96",99.4008,"2","2020-03-28 12:04:51"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:04:52","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":["7513","395","998.0",898.6,"2","2020-03-28 12:04:51"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:04:52","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-05","2020-10-04","395"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-28 12:04:52","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":["7513","A12-D205343","PAID",1996,0,"2020-10-04","2020-03-28 12:04:51","2020-03-28 12:04:51","2","2020-03-28 12:04:51","2","2020-03-28 12:04:51",1546]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:04:52","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":["7513",1546,"SETTLED","A12-I207841","2020-03-28 12:04:51","2020-04-05","2","2020-03-28 12:04:51","2","2020-03-28 12:04:51"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:04:52","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":["7841","RENT","\u9810\u7e73\u79df\u91d1",1,899,"MO","1",899,"2","2020-03-28 12:04:51","2","2020-03-28 12:04:51"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:04:52","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":["7841","RENT","\u9810\u7e73\u79df\u91d1",2,899,"MO","1",899,"2","2020-03-28 12:04:51","2","2020-03-28 12:04:51"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:04:52","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":["7841","RENT","\u9810\u7e73\u79df\u91d1",3,899,"MO","1",899,"2","2020-03-28 12:04:51","2","2020-03-28 12:04:51"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:04:52","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":["7841","RENT","\u9810\u7e73\u79df\u91d1",4,899,"MO","1",899,"2","2020-03-28 12:04:51","2","2020-03-28 12:04:51"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:04:52","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":["7841","RENT","\u9810\u7e73\u79df\u91d1",5,899,"MO","1",899,"2","2020-03-28 12:04:51","2","2020-03-28 12:04:51"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:04:52","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":["7841","RENT","\u9810\u7e73\u79df\u91d1",6,899,"MO","1",899,"2","2020-03-28 12:04:51","2","2020-03-28 12:04:51"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:04:52","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5394,0,"7841"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-28 12:04:52","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":[1546,"EPS","","","","EPS","","","","PAID","P207488","2020-03-28 12:04:51",7390,"2","2020-03-28 12:04:51","2","2020-03-28 12:04:51","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:04:52","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":["7488","DEPOSIT","5343","PAID","2020-03-28 12:04:51",1996,"2","2020-03-28 12:04:51","2","2020-03-28 12:04:51"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:04:52","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":["7488","INVOICE","7841","PAID","2020-03-28 12:04:51",5394,"2","2020-03-28 12:04:51","2","2020-03-28 12:04:51"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:05:13","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"1502","master_room_id":"214","room_code":"A16-011"}],"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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tA16-011 5X6X7 $2298.00 N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"K080615(3)","title":"Ms","lastname":"SIU","firstname":"Yuen King","companyname":"","email":"Sylvia_syk@yahoo.com.hk","tel":"92126342","address":"Flat 3, 5\/F, Blk L, Hoi Ying Court, Aberdeen Centre, Aberdeen.","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1502","room_code":"A16-011","retail_price":"2298.0","discounted_price":"2298.00","location_id":"7"}],"roughly_size":"30","total_retail_price":2298,"total_discounted_price":2068,"deposit":4596,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":29412,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2068.00","warehousing_date":"2020-03-29","rent_from":"2020-03-29","rent_to":"2021-04-28","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental, deposit(ttl: $29412) and credit card charge $882 (ttl: $30294) paid by credit card on Mar 28,2020. Smart card provided on Mar 28,2020.","paymethod":"CREDIT_CARD","paymethod2":"CREDIT_CARD","discount_deduct":2068,"order_total":31480,"final_order_total":29412,"location_id":"7","branch_id":"1","company_id":"1","room_key":"190,01567","order_product":[],"pass":true}},"roughly_size":"30","total_discounted_price":"2068.00","deposit":"4596.00","total_retail_price":"2298.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:05:14","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":["C201547","PERSONAL","Ms","koJUQxXjpCHmEotZmQnrHA==","fwsebH2az17gKNdZ18K8Cg==","","hAbEDy8tU5qdxsn\/57V3dg==","e9Y0rWYMeB+6lUdGrZcfv7QJ1cITQqeuIfdBnH6kdn8=","yNt9rH7ti3GskAJXGwpPmpV0RKhxxLVJ0Y2DxZvFeNUug11treMSiv6NXjA5U88bfD2frhuGurVP9t5fml7lSQ==","r6\/o2jThG2pMAKemIvXNQg==",null,"e9Y0rWYMeB+6lUdGrZcfv7QJ1cITQqeuIfdBnH6kdn8=","XD9+LIqQJX1\/zr1z7vVslw==","2","2020-03-28 12:05:13","2","2020-03-28 12:05:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:05:14","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",1547,"NEW","A16-CT207514",2298,2068,4596,0,"13","13",29412,31480,29412,"2020-03-28 12:05:14","0",null,null,null,"2020-03-29","2021-04-28","13 months contract. Special offer the 13th month free. Storage rental, deposit(ttl: $29412) and credit card charge $882 (ttl: $30294) paid by credit card on Mar 28,2020. Smart card provided on Mar 28,2020.","2020-03-29","30",0,null,2068,"2068.00","2","2020-03-28 12:05:13","2","2020-03-28 12:05:13","CREDIT_CARD","","","","CREDIT_CARD","","","",null,0,"190,01567","C201547","PERSONAL","Ms","koJUQxXjpCHmEotZmQnrHA==","fwsebH2az17gKNdZ18K8Cg==","","yNt9rH7ti3GskAJXGwpPmpV0RKhxxLVJ0Y2DxZvFeNUug11treMSiv6NXjA5U88bfD2frhuGurVP9t5fml7lSQ==","hAbEDy8tU5qdxsn\/57V3dg==","e9Y0rWYMeB+6lUdGrZcfv7QJ1cITQqeuIfdBnH6kdn8=","r6\/o2jThG2pMAKemIvXNQg==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:05:14","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":["7514","1502","2298.0","2298.00","2","2020-03-28 12:05:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:05:14","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-03-29","2021-04-28","1502"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-28 12:05:14","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":["7514","A16-D205344","PAID",4596,0,"2021-04-28","2020-03-28 12:05:13","2020-03-28 12:05:13","2","2020-03-28 12:05:13","2","2020-03-28 12:05:13",1547]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:05:14","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":["7514",1547,"SETTLED","A16-I207842","2020-03-28 12:05:13","2020-03-29","2","2020-03-28 12:05:13","2","2020-03-28 12:05:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:05:14","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":["7842","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,2068,"MO","1",2068,"2","2020-03-28 12:05:13","2","2020-03-28 12:05:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:05:14","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":["7842","RENT","\u9810\u7e73\u79df\u91d1",3,2068,"MO","1",2068,"2","2020-03-28 12:05:13","2","2020-03-28 12:05:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:05:14","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":["7842","RENT","\u9810\u7e73\u79df\u91d1",4,2068,"MO","1",2068,"2","2020-03-28 12:05:13","2","2020-03-28 12:05:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:05:14","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":["7842","RENT","\u9810\u7e73\u79df\u91d1",5,2068,"MO","1",2068,"2","2020-03-28 12:05:13","2","2020-03-28 12:05:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:05:14","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":["7842","RENT","\u9810\u7e73\u79df\u91d1",6,2068,"MO","1",2068,"2","2020-03-28 12:05:13","2","2020-03-28 12:05:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:05:14","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":["7842","RENT","\u9810\u7e73\u79df\u91d1",7,2068,"MO","1",2068,"2","2020-03-28 12:05:13","2","2020-03-28 12:05:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:05:14","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":["7842","RENT","\u9810\u7e73\u79df\u91d1",8,2068,"MO","1",2068,"2","2020-03-28 12:05:13","2","2020-03-28 12:05:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:05:14","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":["7842","RENT","\u9810\u7e73\u79df\u91d1",9,2068,"MO","1",2068,"2","2020-03-28 12:05:13","2","2020-03-28 12:05:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:05:14","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":["7842","RENT","\u9810\u7e73\u79df\u91d1",10,2068,"MO","1",2068,"2","2020-03-28 12:05:13","2","2020-03-28 12:05:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:05:14","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":["7842","RENT","\u9810\u7e73\u79df\u91d1",11,2068,"MO","1",2068,"2","2020-03-28 12:05:13","2","2020-03-28 12:05:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:05:14","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":["7842","RENT","\u9810\u7e73\u79df\u91d1",12,2068,"MO","1",2068,"2","2020-03-28 12:05:13","2","2020-03-28 12:05:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:05:14","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":["7842","RENT","\u9810\u7e73\u79df\u91d1",13,2068,"MO","1",2068,"2","2020-03-28 12:05:13","2","2020-03-28 12:05:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:05:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[24816,0,"7842"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-28 12:05:14","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":[1547,"CREDIT_CARD","","","","CREDIT_CARD","","","","PAID","P207489","2020-03-28 12:05:13",29412,"2","2020-03-28 12:05:13","2","2020-03-28 12:05:13","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:05:14","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":["7489","DEPOSIT","5344","PAID","2020-03-28 12:05:13",4596,"2","2020-03-28 12:05:13","2","2020-03-28 12:05:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:05:14","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":["7489","INVOICE","7842","PAID","2020-03-28 12:05:13",24816,"2","2020-03-28 12:05:13","2","2020-03-28 12:05:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-28 12:11:12","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","190,01567, 289, 56362","13 months contract. Special offer the 13th month free. Storage rental, deposit(ttl: $29412) and credit card charge $882 (ttl: $30294) paid by credit card on Mar 28,2020. Smart card provided on Mar 28,2020.","2020-03-28 12:11:12","2","fwsebH2az17gKNdZ18K8Cg==","koJUQxXjpCHmEotZmQnrHA==","e9Y0rWYMeB+6lUdGrZcfv7QJ1cITQqeuIfdBnH6kdn8=","hAbEDy8tU5qdxsn\/57V3dg==","yNt9rH7ti3GskAJXGwpPmpV0RKhxxLVJ0Y2DxZvFeNUug11treMSiv6NXjA5U88bfD2frhuGurVP9t5fml7lSQ==",7514]},"data_before":[],"data_after":[],"step":1}
*****