\r\n\t\t\t\t\tC15-006 4X2.5X6.5 $773.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":"10","total_discounted_price":"735.0","deposit":"0","total_retail_price":"773.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 10:23:40","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","3","6",1424,"NEW","C15-CT207788",773,735,0,0,"3","3",2205,2205,2205,"2020-05-06 10:23:40","0",null,null,null,"2020-05-04","2020-08-03","3 months contract. Storage rental paid by bank transfer on May 06,2020. Deposit $773 transferred from agreement C15-CT207102 to this agreement.","2020-05-04","10",0,null,0,"0","2","2020-05-06 10:23:39","2","2020-05-06 10:23:39","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0012489016","C191424","PERSONAL","Ms","AAX9PhWQNYbujKJ0Pa5iWQ==","JKNOKuxB8y\/wxkNzxEIjjQ==","","8WYXZRvXIf\/ZXNnXiEVMrtm8XrHbFzF\/WqhOXIomMWGV8NDtfsTiZAwuDfasGmus+IPaMXgBboAgbQM2EkkEJw==","+EAg0QD+zYfhd+1wDAP9eA==",null,"ry2sS1VYP3hAQBXXwRrxmg==",null,1,"6150"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 10:23:40","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":["7788","1312","773.0","773.00","2","2020-05-06 10:23:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 10:23:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-04","2020-08-03","1312"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-05-06 10:23:40","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":["7788",1424,"SETTLED","C15-I208117","2020-05-06 10:23:39","2020-05-04","2","2020-05-06 10:23:39","2","2020-05-06 10:23:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 10:23:40","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":["8117","RENT","\u9810\u7e73\u79df\u91d1",1,735,"MO","1",735,"2","2020-05-06 10:23:39","2","2020-05-06 10:23:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 10:23:40","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":["8117","RENT","\u9810\u7e73\u79df\u91d1",2,735,"MO","1",735,"2","2020-05-06 10:23:39","2","2020-05-06 10:23:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 10:23:40","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":["8117","RENT","\u9810\u7e73\u79df\u91d1",3,735,"MO","1",735,"2","2020-05-06 10:23:39","2","2020-05-06 10:23:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 10:23:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2205,0,"8117"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-05-06 10:23:40","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":[1424,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207762","2020-05-06 10:23:39",2205,"2","2020-05-06 10:23:39","2","2020-05-06 10:23:39","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 10:23:40","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":["7762","DEPOSIT",null,"PAID","2020-05-06 10:23:39",0,"2","2020-05-06 10:23:39","2","2020-05-06 10:23:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 10:23:40","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":["7762","INVOICE","8117","PAID","2020-05-06 10:23:39",2205,"2","2020-05-06 10:23:39","2","2020-05-06 10:23:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 10:40:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 11:19:47","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 11:23:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 11:25:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 11:49:00","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","190,26650","12 months contract. Special offer 5% discount and the 11th, 12th months free of charge. Storage rental and deposit paid by bank transfer on April 29,2020. ","2020-05-06 11:49:00","2","5SiBtHhK6HckOrH\/MZv9Sw==","F8H1Hlk3LobqKcRLjVrCxg==","mkRvBasLTuCBEl2lhLCkOkZoGWiAOUqAfCg5C3nYQZs=","5rtD6J2OPtEufCSD6\/WFGA==","mo+KbGzXS+k2iPHMOiZNhW6ZaHW45edCafWWSZmGNqQypZqcrXtsbdLnjIDBltfg",7746]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 11:53: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","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1397","master_room_id":"159","room_code":"C15-091"}],"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\tC15-091 3X3X6.5 $720.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":"G028615(9)","title":"Ms","lastname":"WOO","firstname":"Agnes Wai Man","companyname":"","email":"jjddwoo@yahoo.com","tel":"61282763","address":"A2, 2\/F, 18 Cape Drive, Hong Kong","pass":true,"customer_id":"1559","customer_code":"C201559","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1397","room_code":"C15-091","retail_price":"720.0","discounted_price":"720.00","location_id":"6"}],"roughly_size":"9","total_retail_price":720,"total_discounted_price":648,"deposit":720,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":6880,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1616.00","warehousing_date":"2020-04-29","rent_from":"2020-04-29","rent_to":"2021-04-28","delivery_service":"0","remark":"12 months contract. Special offer 5% discount and the 11th & 12th months free of charge. Storage rental and deposit paid by bank transfer on Apr 29,2020.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":1616,"order_total":8496,"final_order_total":6880,"location_id":"6","branch_id":"3","company_id":"1","room_key":"190,26650","order_product":[],"pass":true}},"roughly_size":"9","total_discounted_price":"648.00","deposit":"720.00","total_retail_price":"720.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 11:53: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","3","6","1559","NEW","C15-CT207789",720,648,720,0,"12","12",6880,8496,6880,"2020-05-06 11:53:14","0",null,null,null,"2020-04-29","2021-04-28","12 months contract. Special offer 5% discount and the 11th & 12th months free of charge. Storage rental and deposit paid by bank transfer on Apr 29,2020.","2020-04-29","9",0,null,1616,"1616.00","2","2020-05-06 11:53:13","2","2020-05-06 11:53:13","BANKIN","","","","BANKIN","","","",null,0,"190,26650","C201559","PERSONAL","Ms","F8H1Hlk3LobqKcRLjVrCxg==","5SiBtHhK6HckOrH\/MZv9Sw==","","mo+KbGzXS+k2iPHMOiZNhW6ZaHW45edCafWWSZmGNqQypZqcrXtsbdLnjIDBltfg","5rtD6J2OPtEufCSD6\/WFGA==","mkRvBasLTuCBEl2lhLCkOkZoGWiAOUqAfCg5C3nYQZs=","lBqq4OxHnOwpeGhqVg3Ijg==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 11:53: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":["7789","1397","720.0","720.00","2","2020-05-06 11:53:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 11:53: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-04-29","2021-04-28","1397"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-05-06 11:53: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":["7789","C15-D205399","PAID",720,0,"2021-04-28","2020-05-06 11:53:13","2020-05-06 11:53:13","2","2020-05-06 11:53:13","2","2020-05-06 11:53:13","1559"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 11:53: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":["7789","1559","SETTLED","C15-I208118","2020-05-06 11:53:13","2020-04-29","2","2020-05-06 11:53:13","2","2020-05-06 11:53:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 11:53: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":["8118","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-06 11:53:13","2","2020-05-06 11:53:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 11:53: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":["8118","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-05-06 11:53:13","2","2020-05-06 11:53:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 11:53: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":["8118","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,328,"MO","1",328,"2","2020-05-06 11:53:13","2","2020-05-06 11:53:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 11:53: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":["8118","RENT","\u9810\u7e73\u79df\u91d1",4,648,"MO","1",648,"2","2020-05-06 11:53:13","2","2020-05-06 11:53:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 11:53: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":["8118","RENT","\u9810\u7e73\u79df\u91d1",5,648,"MO","1",648,"2","2020-05-06 11:53:13","2","2020-05-06 11:53:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 11:53: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":["8118","RENT","\u9810\u7e73\u79df\u91d1",6,648,"MO","1",648,"2","2020-05-06 11:53:13","2","2020-05-06 11:53:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 11:53: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":["8118","RENT","\u9810\u7e73\u79df\u91d1",7,648,"MO","1",648,"2","2020-05-06 11:53:13","2","2020-05-06 11:53:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 11:53: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":["8118","RENT","\u9810\u7e73\u79df\u91d1",8,648,"MO","1",648,"2","2020-05-06 11:53:13","2","2020-05-06 11:53:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 11:53: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":["8118","RENT","\u9810\u7e73\u79df\u91d1",9,648,"MO","1",648,"2","2020-05-06 11:53:13","2","2020-05-06 11:53:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 11:53: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":["8118","RENT","\u9810\u7e73\u79df\u91d1",10,648,"MO","1",648,"2","2020-05-06 11:53:13","2","2020-05-06 11:53:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 11:53: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":["8118","RENT","\u9810\u7e73\u79df\u91d1",11,648,"MO","1",648,"2","2020-05-06 11:53:13","2","2020-05-06 11:53:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 11:53: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":["8118","RENT","\u9810\u7e73\u79df\u91d1",12,648,"MO","1",648,"2","2020-05-06 11:53:13","2","2020-05-06 11:53:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 11:53:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6160,0,"8118"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-05-06 11:53: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":["1559","BANKIN","","","","BANKIN","","","","PAID","P207763","2020-05-06 11:53:13",6880,"2","2020-05-06 11:53:13","2","2020-05-06 11:53:13","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 11:53: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":["7763","DEPOSIT","5399","PAID","2020-05-06 11:53:13",720,"2","2020-05-06 11:53:13","2","2020-05-06 11:53:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 11:53: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":["7763","INVOICE","8118","PAID","2020-05-06 11:53:13",6160,"2","2020-05-06 11:53:13","2","2020-05-06 11:53:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 12:10:19","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","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1397","master_room_id":"159","room_code":"C15-091"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":144,"customer_code":"C160144","identity_type":"PERSONAL","identity_id":"K507522(A)","title":"Ms","lastname":"Li","firstname":"Sui Fun","companyname":"","email":"fun1822@yahoo.com.hk","tel":"98439626","address":"\u9999\u6e2f\u9d28\u8137\u6d32\u5927\u885725\u81f331\u865f21\u6a13C\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"568.0","renew_rent_month":"3","renew_warehousing_date":"2020-05-05","renew_room_key":"190.62095","renew_remark":"3 months contract. Special price $568\/mth. Storage rental paid by bank transfer on February 5, 2020. Storage deposit $1336 transferred from agreement A16-CT196186 to this agreement. \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\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-125 4X3X3.5 $668.00 N\/A <\/td> \u9810\u4ed86\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","roughly_size":"12","total_discounted_price":"538.00","deposit":"0.00","total_retail_price":"668.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 12:10:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","7",144,"NEW","A16-CT207790",668,538,0,0,"6","6",3228,3228,3228,"2020-05-06 12:10:19","0",null,null,null,"2020-05-05","2020-11-04","6 months contract. Storage rental paid by EPS on May 06,2020. Renewal gift offered on the same day. Storage deposit $1336 transferred from agreement A16-CT207117 to this agreement. ","2020-05-05","12",0,null,0,"0","2","2020-05-06 12:10:19","2","2020-05-06 12:10:19","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"190.62095","C160144","PERSONAL","Ms","NxYEwDa2SVUNtmZ7dPBuRA==","7KCehmxbvwRMb+U8lHGoVA==","","9sE7+exGq8Ow29Gw2EAuRJA4mmc+1uezYkiuIO440EH06wvaiykS7J1smlLN9c3H","J9KL\/+eXCgUVH2qD0NEeSA==","8MTxTI3MVhNHjLnNzEu6J1lo006wo9tWXdlnFhOAJs8=","egTZsJjvVbZENoVq8znvxg==",null,1,"6186"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 12:10:19","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":["7790","474","200","1616","%","10.04",67.0672,"2","2020-05-06 12:10:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 12:10:19","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":["7790","1616","668.0",600.9,"2","2020-05-06 12:10:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 12:10:19","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-05","2020-11-04","1616"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-05-06 12:10:19","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":["7790",144,"SETTLED","A16-I208119","2020-05-06 12:10:19","2020-05-05","2","2020-05-06 12:10:19","2","2020-05-06 12:10:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 12:10:19","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":["8119","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-05-06 12:10:19","2","2020-05-06 12:10:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 12:10:19","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":["8119","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-05-06 12:10:19","2","2020-05-06 12:10:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 12:10:19","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":["8119","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-05-06 12:10:19","2","2020-05-06 12:10:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 12:10:19","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":["8119","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-05-06 12:10:19","2","2020-05-06 12:10:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 12:10:19","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":["8119","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-05-06 12:10:19","2","2020-05-06 12:10:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 12:10:19","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":["8119","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-05-06 12:10:19","2","2020-05-06 12:10:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 12:10:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"8119"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-05-06 12:10:19","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":[144,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207764","2020-05-06 12:10:19",3228,"2","2020-05-06 12:10:19","2","2020-05-06 12:10:19","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 12:10:19","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":["7764","DEPOSIT",null,"PAID","2020-05-06 12:10:19",0,"2","2020-05-06 12:10:19","2","2020-05-06 12:10:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 12:10:19","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":["7764","INVOICE","8119","PAID","2020-05-06 12:10:19",3228,"2","2020-05-06 12:10:19","2","2020-05-06 12:10:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 12:35:27","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1032&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":520,"customer_code":"C170520","identity_type":"PERSONAL","identity_id":"Z821468(A)","title":"Ms","lastname":"Yim","firstname":"Po Kwan","companyname":"","email":"fire_zilia@yahoo.com.hk","tel":"92476466","address":"Room 407,4\/F, Wah Lim House, Wah Kwai Est ","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1234.0","renew_rent_month":"3","renew_warehousing_date":"2020-04-23","renew_room_key":"054,59251","renew_remark":"3 months contract. Storage rental paid by cash on February 6, 2020. Storage deposit transferred from agreement A14-CT196330 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207126, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"68","order_discount":[],"order_room":[{"room_id":"466","room_code":"K03(\u670d\u88dd\u5009)","retail_price":"1342.0","discounted_price":"1342.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1342,"total_discounted_price":1234,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3702,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-23","rent_from":"2020-04-23","rent_to":"2020-07-22","delivery_service":"0","remark":"3 months contract. Storage rental paid by EPS on May 6, 2020. Storage deposit transferred from agreement A14-CT207126 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":3702,"final_order_total":3702,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,59251","order_product":[],"pass":true}},"first_order_id":"4876","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\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\tK03(\u670d\u88dd\u5009) 4X4X8 $1342.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":"16","total_discounted_price":"1234.0","deposit":"0","total_retail_price":"1342.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 12:35:28","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",520,"NEW","A14-CT207791",1342,1234,0,0,"3","3",3702,3702,3702,"2020-05-06 12:35:28","0",null,null,null,"2020-04-23","2020-07-22","3 months contract. Storage rental paid by EPS on May 6, 2020. Storage deposit transferred from agreement A14-CT207126 to this agreement.\r\n","2020-04-23","16",0,null,0,"0","2","2020-05-06 12:35:27","2","2020-05-06 12:35:27","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"054,59251","C170520","PERSONAL","Ms","+EYie6vniw1jBR9PN+A3cw==","D1lS+QYsXUkrz2nLRw\/QvA==","","jNRYdcVpwvcI+YZRXwePHevy0O7zp1xWIXXAEAhjt4W6ly2eAycj7nZo5LUyJDzm","awU72\/W1MrxjaSwCL0TzBA==","C0oT\/WZ07hy\/4HTZnKbNWCUaBi8RotOQQnTYZGNkyrw=","UkrIp5E2TfMSYxOMIphQGw==",null,1,"4876"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 12:35:28","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":["7791","466","1342.0","1342.00","2","2020-05-06 12:35:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 12:35:28","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-23","2020-07-22","466"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-05-06 12:35:28","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":["7791",520,"SETTLED","A14-I208120","2020-05-06 12:35:27","2020-04-23","2","2020-05-06 12:35:27","2","2020-05-06 12:35:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 12:35:28","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":["8120","RENT","\u9810\u7e73\u79df\u91d1",1,1234,"MO","1",1234,"2","2020-05-06 12:35:27","2","2020-05-06 12:35:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 12:35:28","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":["8120","RENT","\u9810\u7e73\u79df\u91d1",2,1234,"MO","1",1234,"2","2020-05-06 12:35:27","2","2020-05-06 12:35:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 12:35:28","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":["8120","RENT","\u9810\u7e73\u79df\u91d1",3,1234,"MO","1",1234,"2","2020-05-06 12:35:27","2","2020-05-06 12:35:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 12:35:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3702,0,"8120"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-05-06 12:35:28","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":[520,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207765","2020-05-06 12:35:27",3702,"2","2020-05-06 12:35:27","2","2020-05-06 12:35:27","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 12:35:28","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":["7765","DEPOSIT",null,"PAID","2020-05-06 12:35:27",0,"2","2020-05-06 12:35:27","2","2020-05-06 12:35:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 12:35:28","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":["7765","INVOICE","8120","PAID","2020-05-06 12:35:27",3702,"2","2020-05-06 12:35:27","2","2020-05-06 12:35:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 13:54:31","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 14:55:48","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 20:00:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 20:01:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 20:07:57","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1032&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":413,"customer_code":"C170413","identity_type":"PERSONAL","identity_id":"D480402(4)","title":"Ms","lastname":"Lee","firstname":"Wai Kwan, Cecilia","companyname":"","email":"wkclee127@gmail.com","tel":"97166228","address":"Flat E, 19\/F, Block 5, Pokfulam Gardens, 180 Pokfulam Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1139.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-07","renew_room_key":"134, 59921","renew_remark":"6 months contract. Storage rental paid by bank transfer on November 8, 2019. Storage deposit transferred from agreement A14-CT195069 to this agreement.\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\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\tL01 4X5X8 $1528.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":"20","total_discounted_price":"1139.00","deposit":"0.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 20:07: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",413,"NEW","A14-CT207792",1528,1139,0,0,"12","12",13668,13668,13668,"2020-05-06 20:07:57","0",null,null,null,"2020-05-07","2021-05-06","12 months contract. Special offer $300 Maxim's voucher. Storage rental paid by bank transfer on May 6, 2020. Storage deposit transferred from agreement A14-CT196329 to this agreement.\r\n","2020-05-07","20",0,null,0,"0","2","2020-05-06 20:07:57","2","2020-05-06 20:07:57","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"134, 59921","C170413","PERSONAL","Ms","EZ61z\/j6vOurkA4gYZXosQypvOHpnBtHHMUGGvdFI1w=","kiriEIqhcx866RNZiMXdKQ==","","2Cwrnow\/Aa0\/2h\/MRqpekeAjt7NwOiKuLdElE2iaCTMTJOyKjA5NtgJofIEkRraBmoBaxWUqbN3qYAxtzYJwkAzjLOKxEtuWpAKrey1MBYM=","kvUeIxAHXRafLIQLNcvUgw==","IjufPohfxq4s3KRVpTP7g5qWL+AqFLmpkbOoH+z8TKA=","inAYzSAKo\/SqB+w75HlyNw==",null,1,"3600"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 20:07: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":["7792","523","1528.0","1528.00","2","2020-05-06 20:07:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 20:07: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-05-07","2021-05-06","523"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-05-06 20:07: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":["7792",413,"SETTLED","A14-I208121","2020-05-06 20:07:57","2020-05-07","2","2020-05-06 20:07:57","2","2020-05-06 20:07:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 20:07: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":["8121","RENT","\u9810\u7e73\u79df\u91d1",1,1139,"MO","1",1139,"2","2020-05-06 20:07:57","2","2020-05-06 20:07:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 20:07: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":["8121","RENT","\u9810\u7e73\u79df\u91d1",2,1139,"MO","1",1139,"2","2020-05-06 20:07:57","2","2020-05-06 20:07:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 20:07: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":["8121","RENT","\u9810\u7e73\u79df\u91d1",3,1139,"MO","1",1139,"2","2020-05-06 20:07:57","2","2020-05-06 20:07:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 20:07: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":["8121","RENT","\u9810\u7e73\u79df\u91d1",4,1139,"MO","1",1139,"2","2020-05-06 20:07:57","2","2020-05-06 20:07:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 20:07: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":["8121","RENT","\u9810\u7e73\u79df\u91d1",5,1139,"MO","1",1139,"2","2020-05-06 20:07:57","2","2020-05-06 20:07:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 20:07: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":["8121","RENT","\u9810\u7e73\u79df\u91d1",6,1139,"MO","1",1139,"2","2020-05-06 20:07:57","2","2020-05-06 20:07:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 20:07: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":["8121","RENT","\u9810\u7e73\u79df\u91d1",7,1139,"MO","1",1139,"2","2020-05-06 20:07:57","2","2020-05-06 20:07:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 20:07: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":["8121","RENT","\u9810\u7e73\u79df\u91d1",8,1139,"MO","1",1139,"2","2020-05-06 20:07:57","2","2020-05-06 20:07:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 20:07: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":["8121","RENT","\u9810\u7e73\u79df\u91d1",9,1139,"MO","1",1139,"2","2020-05-06 20:07:57","2","2020-05-06 20:07:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 20:07: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":["8121","RENT","\u9810\u7e73\u79df\u91d1",10,1139,"MO","1",1139,"2","2020-05-06 20:07:57","2","2020-05-06 20:07:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 20:07: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":["8121","RENT","\u9810\u7e73\u79df\u91d1",11,1139,"MO","1",1139,"2","2020-05-06 20:07:57","2","2020-05-06 20:07:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 20:07: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":["8121","RENT","\u9810\u7e73\u79df\u91d1",12,1139,"MO","1",1139,"2","2020-05-06 20:07:57","2","2020-05-06 20:07:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 20:07:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13668,0,"8121"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-05-06 20:07: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":[413,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207766","2020-05-06 20:07:57",13668,"2","2020-05-06 20:07:57","2","2020-05-06 20:07:57","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 20:07: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":["7766","DEPOSIT",null,"PAID","2020-05-06 20:07:57",0,"2","2020-05-06 20:07:57","2","2020-05-06 20:07:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 20:07: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":["7766","INVOICE","8121","PAID","2020-05-06 20:07:57",13668,"2","2020-05-06 20:07:57","2","2020-05-06 20:07:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-05-06 20:08:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****