\r\n\t\t\t\t\tU07 2X4X7 $965.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":"8","total_discounted_price":"965.0","deposit":"0","total_retail_price":"965.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:14:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",681,"NEW","A18-CT208248",965,965,0,0,"1","1",965,965,965,"2020-06-30 10:14:54","0",null,null,null,"2020-07-02","2020-08-01","1 month contract. Storage rental paid by PPS on June 30, 2020. Storage deposit transferred from agreement A18-CT208020 to this agreement.\r\n","2020-07-02","8",0,null,0,"0","2","2020-06-30 10:14:53","2","2020-06-30 10:14:53","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"056,05555","C180681","PERSONAL","Mr","WpXUsGIV5ZMagl9ab+XsmA==","ThKwrAIcvgN3JqAg+7\/isg==","","MfbxfJxu6rnCI3QT7TKkp941rf6ZLqXK4FI5VbVzAJiJni8uQnXc2gGJQSsyflI200jM1kVIWfocMiR8ixEVuOtN59H0aUN3N6cpSW\/Zb8g=","uk+aBM1pdnZq7uENadbWLg==","AlXt3dY1\/1B81wXwqLajny8WQO2W1oXWizWY\/cvTtlY=","ikLrZy69X3qkMVAoKWXxnQ==",null,1,"4704"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:14:54","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":["8248","906","965.0","965.00","2","2020-06-30 10:14:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:14:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-02","2020-08-01","906"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-30 10:14:54","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":["8248",681,"SETTLED","A18-I208577","2020-06-30 10:14:53","2020-07-02","2","2020-06-30 10:14:53","2","2020-06-30 10:14:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:14:54","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":["8577","RENT","\u9810\u7e73\u79df\u91d1",1,965,"MO","1",965,"2","2020-06-30 10:14:53","2","2020-06-30 10:14:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:14:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[965,0,"8577"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-30 10:14:54","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":[681,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208220","2020-06-30 10:14:53",965,"2","2020-06-30 10:14:53","2","2020-06-30 10:14:53","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:14:54","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":["8220","DEPOSIT",null,"PAID","2020-06-30 10:14:53",0,"2","2020-06-30 10:14:53","2","2020-06-30 10:14:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:14:54","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":["8220","INVOICE","8577","PAID","2020-06-30 10:14:53",965,"2","2020-06-30 10:14:53","2","2020-06-30 10:14:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:30:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:33:36","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1525,"customer_code":"C201525","identity_type":"PERSONAL","identity_id":"D627443(A)","title":"Mr","lastname":"CHOI","firstname":"Four Hing Franki","companyname":"","email":"cflgh@msn.com","tel":"90988941","address":"\u5357\u5be7\u88577-11\u865f\u9999\u6e2f\u4ed4\u4e2d\u5fc32\u671f2\/F, 7A","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2020-07-01","renew_room_key":"189,29014","renew_remark":"1 month contract. Storage rental paid by PPS on May 29, 2020. Storage deposit $2580 transferred from agreement A18-CT207737 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\tW06 4X4X7 $1290.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","roughly_size":"16","total_discounted_price":"1290.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:33:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",1525,"NEW","A18-CT208249",1290,1290,0,0,"1","1",1290,1290,1290,"2020-06-30 10:33:37","0",null,null,null,"2020-07-01","2020-07-31","1 month contract. Storage rental paid by PPS on June 30, 2020. Storage deposit $2580 transferred from agreement A18-CT208023 to this agreement. \r\n","2020-07-01","16",0,null,0,"0","2","2020-06-30 10:33:36","2","2020-06-30 10:33:36","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"189,29014","C201525","PERSONAL","Mr","vIS8IXZkRCz\/4DSJEmIinoenG6ZUfvhRmXtzZy6KRoQ=","U3iGX7U0CkjAKcdgZ04K6A==","","20f7aMgpRV51FiOUQ6KXK6mkR6c4knVkEjw08eLXIZ9w9x4z60rU\/ZG\/wTtfSJoa","Qy93BhGnEO1KQrhkwq1v1A==","zHs7gYv08db9ZpNBd4xf+g==","QaEoWHg\/xDsQ4hnCUpRbZg==",null,1,"7268"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:33:37","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":["8249","961","1290.0","1290.00","2","2020-06-30 10:33:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:33:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-01","2020-07-31","961"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-30 10:33:37","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":["8249",1525,"SETTLED","A18-I208578","2020-06-30 10:33:36","2020-07-01","2","2020-06-30 10:33:36","2","2020-06-30 10:33:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:33:37","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":["8578","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-06-30 10:33:36","2","2020-06-30 10:33:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:33:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"8578"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-30 10:33:37","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":[1525,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208221","2020-06-30 10:33:36",1290,"2","2020-06-30 10:33:36","2","2020-06-30 10:33:36","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:33:37","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":["8221","DEPOSIT",null,"PAID","2020-06-30 10:33:36",0,"2","2020-06-30 10:33:36","2","2020-06-30 10:33:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:33:37","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":["8221","INVOICE","8578","PAID","2020-06-30 10:33:36",1290,"2","2020-06-30 10:33:36","2","2020-06-30 10:33:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:41:31","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":669,"customer_code":"C170669","identity_type":"PERSONAL","identity_id":"D390354(1)","title":"Ms","lastname":"Man","firstname":"Yee Mee Margaret","companyname":"","email":"margaretman421@yahoo.com.hk","tel":"96401484","address":"Flat F, 36\/F, Tower 19, Mei Hong Court, South Horizons, Ap Lei Chau, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1162.0","renew_rent_month":"6","renew_warehousing_date":"2020-07-06","renew_room_key":"052,32864","renew_remark":"6 months contract. Storage rental paid by PPS on December 31, 2019. Storage deposit transferred from agreement A18-CT195382 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT206845, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[{"master_room_discount_id":"250","master_room_id":"91","discount_type":"%","price":"1290.00","disocunted_price":"1161.00","discount":"10.00","monthly_deduct":129,"room_id":"977","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"977","room_code":"X02","retail_price":"1290.0","discounted_price":1161,"location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6972,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-06","rent_from":"2020-07-06","rent_to":"2021-01-05","delivery_service":"0","remark":"6 months contract. Storage rental paid by PPS on June 29, 2020. Storage deposit transferred from agreement A18-CT206845 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":6972,"final_order_total":6972,"location_id":"3","branch_id":"1","company_id":"1","room_key":"052,32864","order_product":[],"pass":true}},"first_order_id":"3965","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\tX02 4X4X7 $1290.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","roughly_size":"16","total_discounted_price":"1162.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:41:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",669,"NEW","A18-CT208250",1290,1162,0,0,"6","6",6972,6972,6972,"2020-06-30 10:41:31","0",null,null,null,"2020-07-06","2021-01-05","6 months contract. Storage rental paid by PPS on June 29, 2020. Storage deposit transferred from agreement A18-CT206845 to this agreement.\r\n","2020-07-06","16",0,null,0,"0","2","2020-06-30 10:41:31","2","2020-06-30 10:41:31","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"052,32864","C170669","PERSONAL","Ms","WTdybooyo5dkai8EPWuedAOI8AcUs7ScbJECB6DQWP8=","1iB+Fi5mVPBhoP\/ei\/0Bag==","","gKyZUDLj+iHp6tX0l5OAvwiPrR5FtzhxJ3aX2JYZ6aEF2pfyOuIoH83oECyR7xcPQgJgw3iFz7us09k\/7ZghiP4ZWM22U1Tlmj5KyQiknwk=","UYGBaucSgTKZu2ZJVFqD2g==","o6QoP9ShibahGpNiJ4C3JrBml\/lGPqwwwUDKuJZLwAc=","yJghpllrKO6ACi4BQrEcuA==",null,1,"3965"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:41:31","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":["8250","250","91","977","%","10.00",129,"2","2020-06-30 10:41:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:41:31","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":["8250","977","1290.0",1161,"2","2020-06-30 10:41:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:41:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-06","2021-01-05","977"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-30 10:41:31","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":["8250",669,"SETTLED","A18-I208579","2020-06-30 10:41:31","2020-07-06","2","2020-06-30 10:41:31","2","2020-06-30 10:41:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:41:31","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":["8579","RENT","\u9810\u7e73\u79df\u91d1",1,1162,"MO","1",1162,"2","2020-06-30 10:41:31","2","2020-06-30 10:41:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:41:31","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":["8579","RENT","\u9810\u7e73\u79df\u91d1",2,1162,"MO","1",1162,"2","2020-06-30 10:41:31","2","2020-06-30 10:41:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:41:31","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":["8579","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-06-30 10:41:31","2","2020-06-30 10:41:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:41:31","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":["8579","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-06-30 10:41:31","2","2020-06-30 10:41:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:41:31","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":["8579","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-06-30 10:41:31","2","2020-06-30 10:41:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:41:31","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":["8579","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-06-30 10:41:31","2","2020-06-30 10:41:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:41:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6972,0,"8579"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-30 10:41:31","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":[669,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208222","2020-06-30 10:41:31",6972,"2","2020-06-30 10:41:31","2","2020-06-30 10:41:31","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:41:31","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":["8222","DEPOSIT",null,"PAID","2020-06-30 10:41:31",0,"2","2020-06-30 10:41:31","2","2020-06-30 10:41:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:41:31","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":["8222","INVOICE","8579","PAID","2020-06-30 10:41:31",6972,"2","2020-06-30 10:41:31","2","2020-06-30 10:41:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:44:26","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":647,"customer_code":"C170647","identity_type":"PERSONAL","identity_id":"D327863(9)","title":"Mr","lastname":"Yiu","firstname":"King Hang ","companyname":"","email":"tonykhyiu@i-cable.com","tel":"96209102","address":"Flat 1, 25\/f, Ngan On House, Yue On Court, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1445.0","renew_rent_month":"6","renew_warehousing_date":"2020-07-01","renew_room_key":"053,39842","renew_remark":"6 months contract. Storage rental paid by bank transfer on Dec 30, 2019. Storage deposit transferred from agreement A18-CT195355 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196803, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"78","order_discount":[{"master_room_discount_id":"254","master_room_id":"78","discount_type":"%","price":"1605.00","disocunted_price":"1444.50","discount":"10.00","monthly_deduct":160.5,"room_id":"975","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"975","room_code":"W20","retail_price":"1605.0","discounted_price":1444.5,"location_id":"3"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1445,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":8670,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-01","rent_from":"2020-07-01","rent_to":"2020-12-31","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on June 30, 2020. Storage deposit transferred from agreement A18-CT196803 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":8670,"final_order_total":8670,"location_id":"3","branch_id":"1","company_id":"1","room_key":"053,39842","order_product":[],"pass":true}},"first_order_id":"4039","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\tW20 4X5X7 $1605.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","roughly_size":"20","total_discounted_price":"1445.0","deposit":"0","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:44:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",647,"NEW","A18-CT208251",1605,1445,0,0,"6","6",8670,8670,8670,"2020-06-30 10:44:27","0",null,null,null,"2020-07-01","2020-12-31","6 months contract. Storage rental paid by bank transfer on June 30, 2020. Storage deposit transferred from agreement A18-CT196803 to this agreement.\r\n","2020-07-01","20",0,null,0,"0","2","2020-06-30 10:44:26","2","2020-06-30 10:44:26","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"053,39842","C170647","PERSONAL","Mr","6qA50jnnvqzzU9rA8ad9Eg==","izJVo3RcQVJ02PBMypGKnQ==","","E1F7\/N\/w4HTkeV+XNpwX\/PTp9puGQVhCZvZ9Z8KrdOTs9IVcXjJPq6IgyWLuHev8","yjsUam6Kc6HoAmxK8aBR5w==","PlH1zU7FqAQzI3K0Uv78IJupc9ttgHGNzSJaIH+r\/PA=","BlXQq0pDW5o0+DtLM4Bc\/Q==",null,1,"4039"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:44:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["8251","254","78","975","%","10.00",160.5,"2","2020-06-30 10:44:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:44:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8251","975","1605.0",1444.5,"2","2020-06-30 10:44:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:44:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-01","2020-12-31","975"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-30 10:44:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8251",647,"SETTLED","A18-I208580","2020-06-30 10:44:26","2020-07-01","2","2020-06-30 10:44:26","2","2020-06-30 10:44:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:44:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8580","RENT","\u9810\u7e73\u79df\u91d1",1,1445,"MO","1",1445,"2","2020-06-30 10:44:26","2","2020-06-30 10:44:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:44:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8580","RENT","\u9810\u7e73\u79df\u91d1",2,1445,"MO","1",1445,"2","2020-06-30 10:44:26","2","2020-06-30 10:44:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:44:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8580","RENT","\u9810\u7e73\u79df\u91d1",3,1445,"MO","1",1445,"2","2020-06-30 10:44:26","2","2020-06-30 10:44:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:44:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8580","RENT","\u9810\u7e73\u79df\u91d1",4,1445,"MO","1",1445,"2","2020-06-30 10:44:26","2","2020-06-30 10:44:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:44:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8580","RENT","\u9810\u7e73\u79df\u91d1",5,1445,"MO","1",1445,"2","2020-06-30 10:44:26","2","2020-06-30 10:44:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:44:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8580","RENT","\u9810\u7e73\u79df\u91d1",6,1445,"MO","1",1445,"2","2020-06-30 10:44:26","2","2020-06-30 10:44:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:44:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8670,0,"8580"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-30 10:44:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[647,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208223","2020-06-30 10:44:26",8670,"2","2020-06-30 10:44:26","2","2020-06-30 10:44:26","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:44:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8223","DEPOSIT",null,"PAID","2020-06-30 10:44:26",0,"2","2020-06-30 10:44:26","2","2020-06-30 10:44:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:44:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8223","INVOICE","8580","PAID","2020-06-30 10:44:26",8670,"2","2020-06-30 10:44:26","2","2020-06-30 10:44:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:47:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:51:07","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=1433&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1433,"customer_code":"C191433","identity_type":"PERSONAL","identity_id":"K186942(6)","title":"Ms","lastname":"CHONG","firstname":"Hiu Sai Stephanie","companyname":"","email":"kaczorowski@netvigator.com","tel":"96159015","address":"Flat B, 18\/F, TWR 10, Larvotto, 8 Ap Lei Chau Praya Rd, Ap Lei Chau, HK.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4400.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-01","renew_room_key":"191,03185","renew_remark":"1 month contract. Special offer $4400\/mth. Storage rental paid by bank transfer on June 8, 2020. Deposit $4400 transferred from A14-CT207600 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\tL57 4X4X8 $1098.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\tL56 4X4X8 $1098.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\tL55 4X4X8 $1098.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\tL67 4X4X8 $1098.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\tL66 4X4X8 $1098.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\tL65 4X4X8 $1098.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","roughly_size":"96","total_discounted_price":"4400.0","deposit":"0","total_retail_price":"6588.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:51:07","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",1433,"NEW","A14-CT208252",6588,4400,0,0,"1","1",4400,4400,4400,"2020-06-30 10:51:07","0",null,null,null,"2020-05-01","2020-05-31","1 month contract. Storage rental paid by bank transfer on June 30, 2020. Deposit $4400 transferred from A14-CT208095 to this agreement.\r\n","2020-05-01","96",0,null,0,"0","2","2020-06-30 10:51:07","2","2020-06-30 10:51:07","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"191,03185","C191433","PERSONAL","Ms","jvk7zrBnQZbXfX1dgEQlHe0RI1vs\/c8ofCzDIiHPduw=","sFvIMVuF8ZsYisXFtwlNOg==","","voDtSK9PGGTovDOARqXC4\/CqVs\/FW\/EFt+7Y8XgoNXnKX\/oYLjrZhZIszuJBDn5WLlxnxR+ombwIyw2An8MxBSJza\/jcybdtGn9ZStmQV6U=","WkO2u9lqQEjRnfUKLBy+6Q==","WfnjLYwTfgHTPaehcdhvGWTDmhNfxmwxxekvQ0TBxrg=","F4vjEMLSruInVObtV1LPJw==",null,1,"6263"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:51:07","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":["8252","579","1098.0","1098.00","2","2020-06-30 10:51:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:51:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-01","2020-05-31","579"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-30 10:51:07","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":["8252","578","1098.0","1098.00","2","2020-06-30 10:51:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:51:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-01","2020-05-31","578"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-30 10:51:07","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":["8252","577","1098.0","1098.00","2","2020-06-30 10:51:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:51:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-01","2020-05-31","577"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-30 10:51:07","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":["8252","589","1098.0","1098.00","2","2020-06-30 10:51:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:51:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-01","2020-05-31","589"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-30 10:51:07","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":["8252","588","1098.0","1098.00","2","2020-06-30 10:51:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:51:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-01","2020-05-31","588"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-30 10:51:07","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":["8252","587","1098.0","1098.00","2","2020-06-30 10:51:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:51:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-01","2020-05-31","587"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-30 10:51:07","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":["8252",1433,"SETTLED","A14-I208581","2020-06-30 10:51:07","2020-05-01","2","2020-06-30 10:51:07","2","2020-06-30 10:51:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:51:07","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":["8581","RENT","\u9810\u7e73\u79df\u91d1",1,4400,"MO","1",4400,"2","2020-06-30 10:51:07","2","2020-06-30 10:51:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:51:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4400,0,"8581"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-30 10:51:07","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":[1433,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208224","2020-06-30 10:51:07",4400,"2","2020-06-30 10:51:07","2","2020-06-30 10:51:07","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:51:07","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":["8224","DEPOSIT",null,"PAID","2020-06-30 10:51:07",0,"2","2020-06-30 10:51:07","2","2020-06-30 10:51:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:51:07","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":["8224","INVOICE","8581","PAID","2020-06-30 10:51:07",4400,"2","2020-06-30 10:51:07","2","2020-06-30 10:51:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:53: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=1433&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1433,"customer_code":"C191433","identity_type":"PERSONAL","identity_id":"K186942(6)","title":"Ms","lastname":"CHONG","firstname":"Hiu Sai Stephanie","companyname":"","email":"kaczorowski@netvigator.com","tel":"96159015","address":"Flat B, 18\/F, TWR 10, Larvotto, 8 Ap Lei Chau Praya Rd, Ap Lei Chau, HK.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3920.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-01","renew_room_key":"191,03185","renew_remark":"1 month contract. Special price $3920\/mth. Storage rental paid by bank transfer on June 8, 2020. Deposit $3920 transferred from agreement A14-CT207601 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\tM94 4X3X8 $998.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\tM93 4X3X8 $998.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\tM92 4X3X8 $998.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\tM83 4X3X8 $998.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\tM82 4X3X8 $998.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\tM81 4X3X8 $998.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","roughly_size":"72","total_discounted_price":"3920.0","deposit":"0","total_retail_price":"5988.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:53: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",1433,"NEW","A14-CT208253",5988,3920,0,0,"1","1",3920,3920,3920,"2020-06-30 10:53:57","0",null,null,null,"2020-05-01","2020-05-31","1 month contract. Storage rental paid by bank transfer on June 30, 2020. Deposit $3920 transferred from agreement A14-CT208096 to this agreement.\r\n","2020-05-01","72",0,null,0,"0","2","2020-06-30 10:53:57","2","2020-06-30 10:53:57","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"191,03185","C191433","PERSONAL","Ms","jvk7zrBnQZbXfX1dgEQlHe0RI1vs\/c8ofCzDIiHPduw=","sFvIMVuF8ZsYisXFtwlNOg==","","voDtSK9PGGTovDOARqXC4\/CqVs\/FW\/EFt+7Y8XgoNXnKX\/oYLjrZhZIszuJBDn5WLlxnxR+ombwIyw2An8MxBSJza\/jcybdtGn9ZStmQV6U=","WkO2u9lqQEjRnfUKLBy+6Q==","WfnjLYwTfgHTPaehcdhvGWTDmhNfxmwxxekvQ0TBxrg=","F4vjEMLSruInVObtV1LPJw==",null,1,"6272"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:53: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":["8253","683","998.0","998.00","2","2020-06-30 10:53:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:53: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-01","2020-05-31","683"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-30 10:53: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":["8253","682","998.0","998.00","2","2020-06-30 10:53:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:53: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-01","2020-05-31","682"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-30 10:53: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":["8253","681","998.0","998.00","2","2020-06-30 10:53:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:53: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-01","2020-05-31","681"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-30 10:53: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":["8253","672","998.0","998.00","2","2020-06-30 10:53:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:53: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-01","2020-05-31","672"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-30 10:53: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":["8253","671","998.0","998.00","2","2020-06-30 10:53:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:53: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-01","2020-05-31","671"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-30 10:53: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":["8253","670","998.0","998.00","2","2020-06-30 10:53:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:53: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-01","2020-05-31","670"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-30 10:53: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":["8253",1433,"SETTLED","A14-I208582","2020-06-30 10:53:57","2020-05-01","2","2020-06-30 10:53:57","2","2020-06-30 10:53:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:53: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":["8582","RENT","\u9810\u7e73\u79df\u91d1",1,3920,"MO","1",3920,"2","2020-06-30 10:53:57","2","2020-06-30 10:53:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:53:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3920,0,"8582"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-30 10:53: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":[1433,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208225","2020-06-30 10:53:57",3920,"2","2020-06-30 10:53:57","2","2020-06-30 10:53:57","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:53: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":["8225","DEPOSIT",null,"PAID","2020-06-30 10:53:57",0,"2","2020-06-30 10:53:57","2","2020-06-30 10:53:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 10:53: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":["8225","INVOICE","8582","PAID","2020-06-30 10:53:57",3920,"2","2020-06-30 10:53:57","2","2020-06-30 10:53:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 11:48:17","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":"type=INVOICE&filter1=0&filter2=1539&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"358","master_room_id":"8","room_code":"F43"}],"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\tF43 4X4X8 $1098.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","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"K241484(8)","title":"Mr","lastname":"CHEUNG","firstname":"Tat Cheung","companyname":"","email":"cheung9448@yahoo.com.hk","tel":"63051500","address":"Flat F, 17\/F, On Fail Building, 82 Old Main Street, Aberdeen","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"433","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"358","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"358","room_code":"F43","retail_price":"1098.0","discounted_price":1043.4,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1038,"deposit":2076,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3633,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1557.00","warehousing_date":"2020-08-01","rent_from":"2020-08-01","rent_to":"2020-10-31","delivery_service":"0","remark":"3 months contract. Special offer 50% off for the first 3 months based on the renewal price. Deposit $500 paid by cash on June 3,2020. The balance of storage rental and deposit $3133 paid by cash on June 30,2020. Smart card provided on the same day.","paymethod":"CASH","paymethod2":"CASH","discount_deduct":1557,"order_total":5190,"final_order_total":3633,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190,39767","order_product":[],"pass":true}},"roughly_size":"16","total_discounted_price":"1038.00","deposit":"2076.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 11:48:19","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":["C201646","PERSONAL","Mr","TOTVPnTz7ue6UWGVQRvq5A==","ts1WQ6NWxfSAyKGz8YWojw==","","8yGw+xXu5FKLps5a7HiOlA==","f9jioISMLeaTQAw92PUqzCGgC9\/XawMmy+wLVsu8jj8=","Q9A\/Gfxj22BKzPuMt2VPLlVyrDMSjkrdxqHXq1ByaIVuoqx10oxX9AbzHRaFMq5xXhX3xQ557a0ITC8beosVbg==","9G4V9ij4DxS1d\/S65ucyEw==",null,"f9jioISMLeaTQAw92PUqzCGgC9\/XawMmy+wLVsu8jj8=","h8MEBFJjBczDA7QyM1uZrg==","2","2020-06-30 11:48:17","2","2020-06-30 11:48:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 11:48: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` = ?","parameters":["1","1","1",1646,"NEW","A12-CT208254",1098,1038,2076,0,"3","3",3633,5190,3633,"2020-06-30 11:48:19","0",null,null,null,"2020-08-01","2020-10-31","3 months contract. Special offer 50% off for the first 3 months based on the renewal price. Deposit $500 paid by cash on June 3,2020. The balance of storage rental and deposit $3133 paid by cash on June 30,2020. Smart card provided on the same day.","2020-08-01","16",0,null,1557,"1557.00","2","2020-06-30 11:48:17","2","2020-06-30 11:48:17","CASH","","","","CASH","","","",null,0,"190,39767","C201646","PERSONAL","Mr","TOTVPnTz7ue6UWGVQRvq5A==","ts1WQ6NWxfSAyKGz8YWojw==","","Q9A\/Gfxj22BKzPuMt2VPLlVyrDMSjkrdxqHXq1ByaIVuoqx10oxX9AbzHRaFMq5xXhX3xQ557a0ITC8beosVbg==","8yGw+xXu5FKLps5a7HiOlA==","f9jioISMLeaTQAw92PUqzCGgC9\/XawMmy+wLVsu8jj8=","9G4V9ij4DxS1d\/S65ucyEw==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 11:48: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":["8254","433","8","358","%","4.97",54.5706,"2","2020-06-30 11:48:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 11:48: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":["8254","358","1098.0",1043.4,"2","2020-06-30 11:48:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 11:48: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-08-01","2020-10-31","358"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-30 11:48:19","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":["8254","A12-D205509","PAID",2076,0,"2020-10-31","2020-06-30 11:48:17","2020-06-30 11:48:17","2","2020-06-30 11:48:17","2","2020-06-30 11:48:17",1646]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 11:48: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":["8254",1646,"SETTLED","A12-I208583","2020-06-30 11:48:17","2020-08-01","2","2020-06-30 11:48:17","2","2020-06-30 11:48:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 11:48: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":["8583","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-30 11:48:17","2","2020-06-30 11:48:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 11:48: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":["8583","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,519,"MO","1",519,"2","2020-06-30 11:48:17","2","2020-06-30 11:48:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 11:48: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":["8583","RENT","\u9810\u7e73\u79df\u91d1",3,1038,"MO","1",1038,"2","2020-06-30 11:48:17","2","2020-06-30 11:48:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 11:48:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1557,0,"8583"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-30 11:48: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":[1646,"CASH","","","","CASH","","","","PAID","P208226","2020-06-30 11:48:17",3633,"2","2020-06-30 11:48:17","2","2020-06-30 11:48:17","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 11:48: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":["8226","DEPOSIT","5509","PAID","2020-06-30 11:48:17",2076,"2","2020-06-30 11:48:17","2","2020-06-30 11:48:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 11:48: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":["8226","INVOICE","8583","PAID","2020-06-30 11:48:17",1557,"2","2020-06-30 11:48:17","2","2020-06-30 11:48:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 12:13:01","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 14:02:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 14:20:47","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 14:21:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 14:25: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","floor_plan_rent_room":[],"index_url_parameter":"filter1=2&filter2=1595&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1328,"customer_code":"C191328","identity_type":"PERSONAL","identity_id":"440102198405092318","title":"Mr","lastname":"Chan","firstname":"Hao","companyname":"","email":null,"tel":"53932439","address":"Flat A, 4\/F, 116 Nam Cheong Street, Sham Shui Po, Kowloon","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1081.0","renew_rent_month":"3","renew_warehousing_date":"2020-06-24","renew_room_key":"076,38766,190,40541","renew_remark":"3 months contract. Storage rental paid by cash on March 27, 2020. Storage deposit $2276 transferred from agreement A12-CT196774 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207508, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"4","order_discount":[],"order_room":[{"room_id":"361","room_code":"G02","retail_price":"1138.0","discounted_price":"946.00","location_id":"1"}],"roughly_size":"15","total_retail_price":1138,"total_discounted_price":1081,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3243,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-24","rent_from":"2020-06-24","rent_to":"2020-09-23","delivery_service":"0","remark":"3 months contract. Storage rental paid by cash on June 30, 2020. Storage deposit $2276 transferred from agreement A12-CT207508 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":3243,"final_order_total":3243,"location_id":"1","branch_id":"1","company_id":"1","room_key":"076,38766,190,40541","order_product":[],"pass":true}},"first_order_id":"6774","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\tG02 3X5X8 $1138.00 $946.0 <\/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":"15","total_discounted_price":"1081.0","deposit":"0","total_retail_price":"1138.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 14:25:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",1328,"NEW","A12-CT208255",1138,1081,0,0,"3","3",3243,3243,3243,"2020-06-30 14:25:58","0",null,null,null,"2020-06-24","2020-09-23","3 months contract. Storage rental paid by cash on June 30, 2020. Storage deposit $2276 transferred from agreement A12-CT207508 to this agreement. ","2020-06-24","15",0,null,0,"0","2","2020-06-30 14:25:57","2","2020-06-30 14:25:57","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"076,38766,190,40541","C191328","PERSONAL","Mr","YPwLezUtdvq6tloDb+ZMSQ==","U9yoE9KqV1v8YlRkf7Q2yg==","","EW7Hg6MarHElMe1j\/aDfrAv3BJlFEqjirJYMQHzxol5rntrzhzLcXFumM9YUWcYh+yeSqrdMW9i84LHuXNCc8Q==","RctOYZmzwwBCja+bKgEcTw==",null,"nxcjh+1vmoy\/o3RRwn9vGH16PbsfFyjL3uM9ZzyfrtA=",null,1,"6774"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 14:25:58","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":["8255","361","1138.0","946.00","2","2020-06-30 14:25:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 14:25:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-24","2020-09-23","361"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-30 14:25:58","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":["8255",1328,"SETTLED","A12-I208584","2020-06-30 14:25:57","2020-06-24","2","2020-06-30 14:25:57","2","2020-06-30 14:25:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 14:25:58","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":["8584","RENT","\u9810\u7e73\u79df\u91d1",1,1081,"MO","1",1081,"2","2020-06-30 14:25:57","2","2020-06-30 14:25:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 14:25:58","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":["8584","RENT","\u9810\u7e73\u79df\u91d1",2,1081,"MO","1",1081,"2","2020-06-30 14:25:57","2","2020-06-30 14:25:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 14:25:58","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":["8584","RENT","\u9810\u7e73\u79df\u91d1",3,1081,"MO","1",1081,"2","2020-06-30 14:25:57","2","2020-06-30 14:25:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 14:25:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3243,0,"8584"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-30 14:25:58","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":[1328,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P208227","2020-06-30 14:25:57",3243,"2","2020-06-30 14:25:57","2","2020-06-30 14:25:57","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 14:25:58","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":["8227","DEPOSIT",null,"PAID","2020-06-30 14:25:57",0,"2","2020-06-30 14:25:57","2","2020-06-30 14:25:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 14:25:58","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":["8227","INVOICE","8584","PAID","2020-06-30 14:25:57",3243,"2","2020-06-30 14:25:57","2","2020-06-30 14:25:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:20:15","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"type=INVOICE&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"358","master_room_id":"8","room_code":"F43"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":664,"customer_code":"C170664","identity_type":"PERSONAL","identity_id":"A954180(5)","title":"Mr","lastname":"Yim","firstname":"Fu Cheong","companyname":"","email":null,"tel":"95362131","address":"Flat B, 7\/F, 31 Third Street, Hong Kong","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1226.0","renew_rent_month":"3","renew_warehousing_date":"2020-07-01","renew_room_key":"055,40406","renew_remark":"3 months contract. Storage rental paid by cash on Mar 27,2020. Storage deposit transferred from agreement A18-CT196778 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207509, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[{"master_room_discount_id":"248","master_room_id":"91","discount_type":"%","price":"1290.00","disocunted_price":"1225.90","discount":"4.97","monthly_deduct":64.113,"room_id":"985","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"985","room_code":"X10","retail_price":"1290.0","discounted_price":1225.9,"location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1226,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3678,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-01","rent_from":"2020-07-01","rent_to":"2020-09-30","delivery_service":"0","remark":"3 months contract. Storage rental paid by cash on June 30,2020. Storage deposit transferred from agreement A18-CT207509 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":3678,"final_order_total":3678,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,40406","order_product":[],"pass":true}},"first_order_id":"4656","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\tX10 4X4X7 $1290.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","roughly_size":"16","total_discounted_price":"1226.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:20:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",664,"NEW","A18-CT208256",1290,1226,0,0,"3","3",3678,3678,3678,"2020-06-30 15:20:15","0",null,null,null,"2020-07-01","2020-09-30","3 months contract. Storage rental paid by cash on June 30,2020. Storage deposit transferred from agreement A18-CT207509 to this agreement.","2020-07-01","16",0,null,0,"0","2","2020-06-30 15:20:15","2","2020-06-30 15:20:15","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"055,40406","C170664","PERSONAL","Mr","p\/DS6GERxgctN1XhF804Lg==","D1lS+QYsXUkrz2nLRw\/QvA==","","GN54SRzU629vuYlg6sDSMS7gNK3t7g2aFOqD1KkRgEPEglFZC8otggLI0ZXIIrkU","jEetVuFowEj9E04Nc7n\/4A==",null,"e3VK5W3jZOnVX7BBi9Fxag==",null,1,"4656"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:20:15","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":["8256","248","91","985","%","4.97",64.113,"2","2020-06-30 15:20:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:20:15","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":["8256","985","1290.0",1225.9,"2","2020-06-30 15:20:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:20:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-01","2020-09-30","985"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-30 15:20:15","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":["8256",664,"SETTLED","A18-I208585","2020-06-30 15:20:15","2020-07-01","2","2020-06-30 15:20:15","2","2020-06-30 15:20:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:20:15","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":["8585","RENT","\u9810\u7e73\u79df\u91d1",1,1226,"MO","1",1226,"2","2020-06-30 15:20:15","2","2020-06-30 15:20:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:20:15","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":["8585","RENT","\u9810\u7e73\u79df\u91d1",2,1226,"MO","1",1226,"2","2020-06-30 15:20:15","2","2020-06-30 15:20:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:20:15","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":["8585","RENT","\u9810\u7e73\u79df\u91d1",3,1226,"MO","1",1226,"2","2020-06-30 15:20:15","2","2020-06-30 15:20:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:20:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3678,0,"8585"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-30 15:20:15","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":[664,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P208228","2020-06-30 15:20:15",3678,"2","2020-06-30 15:20:15","2","2020-06-30 15:20:15","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:20:15","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":["8228","DEPOSIT",null,"PAID","2020-06-30 15:20:15",0,"2","2020-06-30 15:20:15","2","2020-06-30 15:20:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:20:15","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":["8228","INVOICE","8585","PAID","2020-06-30 15:20:15",3678,"2","2020-06-30 15:20:15","2","2020-06-30 15:20:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:47:41","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":"type=INVOICE&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"D405178(6)","title":"Ms","lastname":"LAM","firstname":"May Yee","companyname":"","email":"forbamrj@gmail.com","tel":"63175408","address":"Full Silver Garden, 2\/F, Blk 23, 50 Yuen Kong Sam Tsuen, Yuen Long, N.T.","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1278","room_code":"B01-088","retail_price":"908.0","discounted_price":"908.00","location_id":"5"}],"roughly_size":"12","total_retail_price":908,"total_discounted_price":709,"deposit":1816,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":10324,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-01","rent_from":"2020-07-01","rent_to":"2021-06-30","delivery_service":"0","remark":"12 months contract. Deposit $1000 paid by bank transfer on June 29,2020. The balance of storage rental and deposit $9384 paid by cheque on June 30,2020. Smart card paid and provided on the same day.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":10384,"final_order_total":10384,"location_id":"5","branch_id":"2","company_id":"1","room_key":"'0012522666","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"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\tB01-088 3X4X7 $908.00 - <\/td> <\/td> \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":"709.00","deposit":"1816.00","total_retail_price":"908.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:47:42","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":["C201647","PERSONAL","Ms","85kLYQn5e5TeH5HVp5BlFg==","BLxWt7e4owYJMFkn6\/eeMQ==","","AuZ3tn+kwldCvfe\/cOJxnw==","VxFAAXxU7MK4d8CtzqEeDEWCF+5ypuMjAj1ZiKNoYpQ=","J2SdONMjwi8XPzG9UCYrNGIzobXj\/tBYjQ7h0nZtEu7JUGq2sTH43K72dQl+ofY3hH9HSmsW+kF5P5mRoJtgUhw2OB81dpT437DpLCIQXW8=","QBKHDxFhxSjhoGFwYhTRSA==",null,"VxFAAXxU7MK4d8CtzqEeDEWCF+5ypuMjAj1ZiKNoYpQ=","UAK85y+NaC1IH4PlmgvSSQ==","2","2020-06-30 15:47:41","2","2020-06-30 15:47:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:47:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","2","5",1647,"NEW","B01-CT208257",908,709,1816,0,"12","12",10324,10384,10384,"2020-06-30 15:47:43","0",null,null,null,"2020-07-01","2021-06-30","12 months contract. Deposit $1000 paid by bank transfer on June 29,2020. The balance of storage rental and deposit $9384 paid by cheque on June 30,2020. Smart card paid and provided on the same day.","2020-07-01","12",0,null,0,"0","2","2020-06-30 15:47:41","2","2020-06-30 15:47:41","CHEQUE","","","","CHEQUE","","","",null,0,"'0012522666","C201647","PERSONAL","Ms","85kLYQn5e5TeH5HVp5BlFg==","BLxWt7e4owYJMFkn6\/eeMQ==","","J2SdONMjwi8XPzG9UCYrNGIzobXj\/tBYjQ7h0nZtEu7JUGq2sTH43K72dQl+ofY3hH9HSmsW+kF5P5mRoJtgUhw2OB81dpT437DpLCIQXW8=","AuZ3tn+kwldCvfe\/cOJxnw==","VxFAAXxU7MK4d8CtzqEeDEWCF+5ypuMjAj1ZiKNoYpQ=","QBKHDxFhxSjhoGFwYhTRSA==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:47:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8257",1647,"11","1","60.0",60,"2","2020-06-30 15:47:41","2","2020-06-30 15:47:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:47:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"8257"]},"data_before":[],"data_after":[],"step":4}
*****
{"created_at":"2020-06-30 15:47:43","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":["8257","1278","908.0","908.00","2","2020-06-30 15:47:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:47:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-01","2021-06-30","1278"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-30 15:47:43","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":["8257","B01-D205510","PAID",1816,0,"2021-06-30","2020-06-30 15:47:41","2020-06-30 15:47:41","2","2020-06-30 15:47:41","2","2020-06-30 15:47:41",1647]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:47:43","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":["8257",1647,"SETTLED","B01-I208586","2020-06-30 15:47:41","2020-07-01","2","2020-06-30 15:47:41","2","2020-06-30 15:47:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:47:43","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":["8586","RENT","\u9810\u7e73\u79df\u91d1",1,709,"MO","1",709,"2","2020-06-30 15:47:41","2","2020-06-30 15:47:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:47:43","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":["8586","RENT","\u9810\u7e73\u79df\u91d1",2,709,"MO","1",709,"2","2020-06-30 15:47:41","2","2020-06-30 15:47:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:47:43","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":["8586","RENT","\u9810\u7e73\u79df\u91d1",3,709,"MO","1",709,"2","2020-06-30 15:47:41","2","2020-06-30 15:47:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:47:43","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":["8586","RENT","\u9810\u7e73\u79df\u91d1",4,709,"MO","1",709,"2","2020-06-30 15:47:41","2","2020-06-30 15:47:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:47:43","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":["8586","RENT","\u9810\u7e73\u79df\u91d1",5,709,"MO","1",709,"2","2020-06-30 15:47:41","2","2020-06-30 15:47:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:47:43","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":["8586","RENT","\u9810\u7e73\u79df\u91d1",6,709,"MO","1",709,"2","2020-06-30 15:47:41","2","2020-06-30 15:47:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:47:43","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":["8586","RENT","\u9810\u7e73\u79df\u91d1",7,709,"MO","1",709,"2","2020-06-30 15:47:41","2","2020-06-30 15:47:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:47:43","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":["8586","RENT","\u9810\u7e73\u79df\u91d1",8,709,"MO","1",709,"2","2020-06-30 15:47:41","2","2020-06-30 15:47:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:47:43","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":["8586","RENT","\u9810\u7e73\u79df\u91d1",9,709,"MO","1",709,"2","2020-06-30 15:47:41","2","2020-06-30 15:47:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:47:43","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":["8586","RENT","\u9810\u7e73\u79df\u91d1",10,709,"MO","1",709,"2","2020-06-30 15:47:41","2","2020-06-30 15:47:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:47:43","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":["8586","RENT","\u9810\u7e73\u79df\u91d1",11,709,"MO","1",709,"2","2020-06-30 15:47:41","2","2020-06-30 15:47:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:47:43","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":["8586","RENT","\u9810\u7e73\u79df\u91d1",12,709,"MO","1",709,"2","2020-06-30 15:47:41","2","2020-06-30 15:47:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:47:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8586","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-06-30 15:47:41","2","2020-06-30 15:47:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:47:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8568,0,"8586"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-30 15:47:43","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":[1647,"CHEQUE","","","","CHEQUE","","","","PAID","P208229","2020-06-30 15:47:41",10384,"2","2020-06-30 15:47:41","2","2020-06-30 15:47:41","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:47:43","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":["8229","DEPOSIT","5510","PAID","2020-06-30 15:47:41",1816,"2","2020-06-30 15:47:41","2","2020-06-30 15:47:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:47:43","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":["8229","INVOICE","8586","PAID","2020-06-30 15:47:41",8568,"2","2020-06-30 15:47:41","2","2020-06-30 15:47:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 15:52:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 16:14:09","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":"type=INVOICE&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1548,"customer_code":"C201548","identity_type":"BUSINESS","identity_id":"16886254-000-07-19-8","title":"Ms","lastname":"HO","firstname":"Ada","companyname":"Asian Capital Partners (HK) Limited","email":"ada_ho@asiancap.com","tel":"28269513","address":"Room 609-611, 6\/F, 100 QRC, 100 Queen's Road Central, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2522.0","renew_rent_month":"3","renew_warehousing_date":"2020-07-01","renew_room_key":"092,18279","renew_remark":"3 months contract. Special offer 5% discount. Storage rental and deposit paid by bank transfer on Mar 30,2020. Smart card provided on Mar 30,2020. \\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT207523, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $5310.0","renew_master_room_id":"215","order_discount":[],"order_room":[{"room_id":"1637","room_code":"A16-146","retail_price":"2655.0","discounted_price":"2655.00","location_id":"7"}],"roughly_size":"35","total_retail_price":2655,"total_discounted_price":2522,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":7566,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-01","rent_from":"2020-07-01","rent_to":"2020-09-30","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on June 29, 2020. Storage deposit $5310 transferred from agreement A16-CT207523 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":7566,"final_order_total":7566,"location_id":"7","branch_id":"1","company_id":"1","room_key":"092,18279","order_product":[],"pass":true}},"first_order_id":7523,"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\tA16-146 5X7X7 $2655.00 N\/A <\/td> \u9810\u4ed812\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":"35","total_discounted_price":"2522.0","deposit":"0","total_retail_price":"2655.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 16:14:09","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",1548,"NEW","A16-CT208258",2655,2522,0,0,"3","3",7566,7566,7566,"2020-06-30 16:14:09","0",null,null,null,"2020-07-01","2020-09-30","3 months contract. Storage rental paid by bank transfer on June 29, 2020. Storage deposit $5310 transferred from agreement A16-CT207523 to this agreement.","2020-07-01","35",0,null,0,"0","2","2020-06-30 16:14:09","2","2020-06-30 16:14:09","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"092,18279","C201548","BUSINESS","Ms","aSBBtAs7bqfl5dV3rXfGGg==","Zzv1eRCimQisUlUlw\/fpjg==","Asian Capital Partners (HK) Limited","hskERICFqnUSxpPvrYyIbvnh2j\/Ruuxpx60XpClCW7Yjkbu943PO0i4CuuJ8ViXwARNST+oZX9lFp9aZ25G5dg==","pXFnlcoNY7GMI6BDQ45dxg==","Ab\/R2lan0QiDbiz1yaOXWb4qMLUpURe9bMyZ\/fyH\/H4=",null,"TnSFvuNUtiDUAkE2C4GjRC7tIsVLPn0UrQaqOaeoCUg=",1,7523]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 16:14:09","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":["8258","1637","2655.0","2655.00","2","2020-06-30 16:14:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 16:14:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-01","2020-09-30","1637"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-30 16:14:09","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":["8258",1548,"SETTLED","A16-I208587","2020-06-30 16:14:09","2020-07-01","2","2020-06-30 16:14:09","2","2020-06-30 16:14:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 16:14:09","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":["8587","RENT","\u9810\u7e73\u79df\u91d1",1,2522,"MO","1",2522,"2","2020-06-30 16:14:09","2","2020-06-30 16:14:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 16:14:09","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":["8587","RENT","\u9810\u7e73\u79df\u91d1",2,2522,"MO","1",2522,"2","2020-06-30 16:14:09","2","2020-06-30 16:14:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 16:14:09","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":["8587","RENT","\u9810\u7e73\u79df\u91d1",3,2522,"MO","1",2522,"2","2020-06-30 16:14:09","2","2020-06-30 16:14:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 16:14:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7566,0,"8587"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-30 16:14:09","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":[1548,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208230","2020-06-30 16:14:09",7566,"2","2020-06-30 16:14:09","2","2020-06-30 16:14:09","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 16:14:09","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":["8230","DEPOSIT",null,"PAID","2020-06-30 16:14:09",0,"2","2020-06-30 16:14:09","2","2020-06-30 16:14:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 16:14:09","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":["8230","INVOICE","8587","PAID","2020-06-30 16:14:09",7566,"2","2020-06-30 16:14:09","2","2020-06-30 16:14:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 16:38:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 16:41:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 16:48:09","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:02:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:15:50","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1257&filter3=undefined&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":627,"customer_code":"C170627","identity_type":"PERSONAL","identity_id":"Z079353(2)","title":"Mr","lastname":"Cheung","firstname":"Wang Kong","companyname":"","email":"kongivan_2003@yahoo.com.hk","tel":"61001525","address":"Room 2, 12\/F, Block A, 130 Lee Chi Road, Apleichau, HK","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1445.0","renew_rent_month":"6","renew_warehousing_date":"2020-07-01","renew_room_key":"052,31365","renew_remark":"6 months contract. Storage rental paid by PPS on January 2, 2020. Storage deposit $3210 transferred from agreement A18-CT195234 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\tV15 4X5X7 $1605.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","roughly_size":"20","total_discounted_price":"1445.0","deposit":"0","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:15:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",627,"NEW","A18-CT208259",1605,1445,0,0,"6","6",8670,8670,8670,"2020-06-30 17:15:51","0",null,null,null,"2020-07-01","2020-12-31","6 months contract. Storage rental paid by bank transfer on June 30, 2020. Storage deposit $3210 transferred from agreement A18-CT206856 to this agreement. \r\n","2020-07-01","20",0,null,0,"0","2","2020-06-30 17:15:50","2","2020-06-30 17:15:50","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,31365","C170627","PERSONAL","Mr","+RfVUrmRrDMrbjgajP6zWQ==","vCxOlXQuvOQaoL822H2o\/Q==","","Q3bOEKUdjDbL9ql97HN3ApNUbhIxLI0vxJhLZpv4KECLoYMJYNwwZoJaWLdZ7d3PJmzBONRwndvB9byW\/xR4TQ==","GJlS7e2umTYaaf1DOWpuow==","uVvRwBdUCZUAj1PA7K+fdE8Kjo\/F4QYapcovPAq7Rfc=","ijs+RAeH7f2qmo+3pCsjug==",null,1,"5234"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:15:51","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":["8259","254","78","941","%","10.00",160.5,"2","2020-06-30 17:15:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:15:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8259","941","1605.0",1444.5,"2","2020-06-30 17:15:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:15:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-01","2020-12-31","941"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-30 17:15:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8259",627,"SETTLED","A18-I208588","2020-06-30 17:15:50","2020-07-01","2","2020-06-30 17:15:50","2","2020-06-30 17:15:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:15:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8588","RENT","\u9810\u7e73\u79df\u91d1",1,1445,"MO","1",1445,"2","2020-06-30 17:15:50","2","2020-06-30 17:15:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:15:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8588","RENT","\u9810\u7e73\u79df\u91d1",2,1445,"MO","1",1445,"2","2020-06-30 17:15:50","2","2020-06-30 17:15:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:15:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8588","RENT","\u9810\u7e73\u79df\u91d1",3,1445,"MO","1",1445,"2","2020-06-30 17:15:50","2","2020-06-30 17:15:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:15:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8588","RENT","\u9810\u7e73\u79df\u91d1",4,1445,"MO","1",1445,"2","2020-06-30 17:15:50","2","2020-06-30 17:15:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:15:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8588","RENT","\u9810\u7e73\u79df\u91d1",5,1445,"MO","1",1445,"2","2020-06-30 17:15:50","2","2020-06-30 17:15:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:15:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8588","RENT","\u9810\u7e73\u79df\u91d1",6,1445,"MO","1",1445,"2","2020-06-30 17:15:50","2","2020-06-30 17:15:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:15:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8670,0,"8588"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-30 17:15:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[627,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208231","2020-06-30 17:15:50",8670,"2","2020-06-30 17:15:50","2","2020-06-30 17:15:50","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:15:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8231","DEPOSIT",null,"PAID","2020-06-30 17:15:50",0,"2","2020-06-30 17:15:50","2","2020-06-30 17:15:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:15:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8231","INVOICE","8588","PAID","2020-06-30 17:15:50",8670,"2","2020-06-30 17:15:50","2","2020-06-30 17:15:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:19:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:24:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:24:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:25:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:26:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:43:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:50:41","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":"1713","master_room_id":"197","room_code":"A16-222"}],"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-222 4X2X7 $965.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":"BUSINESS","identity_id":"69947164","title":"Ms","lastname":"MUI","firstname":"Yuen Yi","companyname":"JMC Wild Forest Limited","email":"Janniemui@jmcwildforest.com","tel":"67579091","address":"913, 9F, Radio City, 505 Hennessy Road, Causeway Bay, H.K.","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1713","room_code":"A16-222","retail_price":"965.0","discounted_price":"965.00","location_id":"7"}],"roughly_size":"8","total_retail_price":965,"total_discounted_price":998,"deposit":1996,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3493,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1497.00","warehousing_date":"2020-07-10","rent_from":"2020-07-10","rent_to":"2020-10-09","delivery_service":"0","remark":"3 months contract. Storage rental and deposit paid by bank transfer on June 30, 2020. Smart card provided on June 30, 2020. ","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":1497,"order_total":4990,"final_order_total":3493,"location_id":"7","branch_id":"1","company_id":"1","room_key":"076, 49726","order_product":[],"pass":true}},"roughly_size":"8","total_discounted_price":"998.00","deposit":"1996.00","total_retail_price":"965.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:50:42","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":["C201648","BUSINESS","Ms","gZIYclSIylbtkN3gWXuuuA==","IgQlq8MS7boHKFNXljEZbQ==","JMC Wild Forest Limited","uCjMg4Xnu1HX27n1m22k3Q==","IhTelow2\/+v\/Ow4DB\/5ZMhlAD\/M9WXNGmwMScgUrNzc=","2wJPbOO\/vVf9bLDaA2zdwZNEgEoj7v9ohBkGUSlGkVVJTSaW7QUah6Tr5ATKSd4AGaoM00LwgUx0OElqrQDMWQ==",null,"3Y3ZXRVlw2ujVqdvptt3sw==","IhTelow2\/+v\/Ow4DB\/5ZMhlAD\/M9WXNGmwMScgUrNzc=","dIyJSxZ0eqXqiM9DK+iXvQ==","2","2020-06-30 17:50:41","2","2020-06-30 17:50:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:50:43","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",1648,"NEW","A16-CT208260",965,998,1996,0,"3","3",3493,4990,3493,"2020-06-30 17:50:43","0",null,null,null,"2020-07-10","2020-10-09","3 months contract. Storage rental and deposit paid by bank transfer on June 30, 2020. Smart card provided on June 30, 2020. ","2020-07-10","8",0,null,1497,"1497.00","2","2020-06-30 17:50:41","2","2020-06-30 17:50:41","BANKIN","","","","BANKIN","","","",null,0,"076, 49726","C201648","BUSINESS","Ms","gZIYclSIylbtkN3gWXuuuA==","IgQlq8MS7boHKFNXljEZbQ==","JMC Wild Forest Limited","2wJPbOO\/vVf9bLDaA2zdwZNEgEoj7v9ohBkGUSlGkVVJTSaW7QUah6Tr5ATKSd4AGaoM00LwgUx0OElqrQDMWQ==","uCjMg4Xnu1HX27n1m22k3Q==","IhTelow2\/+v\/Ow4DB\/5ZMhlAD\/M9WXNGmwMScgUrNzc=",null,"3Y3ZXRVlw2ujVqdvptt3sw=="]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:50:43","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":["8260","1713","965.0","965.00","2","2020-06-30 17:50:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:50:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-10","2020-10-09","1713"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-30 17:50:43","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":["8260","A16-D205511","PAID",1996,0,"2020-10-09","2020-06-30 17:50:41","2020-06-30 17:50:41","2","2020-06-30 17:50:41","2","2020-06-30 17:50:41",1648]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:50:43","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":["8260",1648,"SETTLED","A16-I208589","2020-06-30 17:50:41","2020-07-10","2","2020-06-30 17:50:41","2","2020-06-30 17:50:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:50:43","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":["8589","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-30 17:50:41","2","2020-06-30 17:50:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:50:43","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":["8589","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,499,"MO","1",499,"2","2020-06-30 17:50:41","2","2020-06-30 17:50:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:50:43","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":["8589","RENT","\u9810\u7e73\u79df\u91d1",3,998,"MO","1",998,"2","2020-06-30 17:50:41","2","2020-06-30 17:50:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:50:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1497,0,"8589"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-30 17:50:43","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":[1648,"BANKIN","","","","BANKIN","","","","PAID","P208232","2020-06-30 17:50:41",3493,"2","2020-06-30 17:50:41","2","2020-06-30 17:50:41","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:50:43","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":["8232","DEPOSIT","5511","PAID","2020-06-30 17:50:41",1996,"2","2020-06-30 17:50:41","2","2020-06-30 17:50:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:50:43","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":["8232","INVOICE","8589","PAID","2020-06-30 17:50:41",1497,"2","2020-06-30 17:50:41","2","2020-06-30 17:50:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 17:52:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:00:48","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` = ?, `customer_companyname` = ? where id = ?","parameters":["NEW","076, 49726, 076, 34826","3 months contract. Storage rental and deposit paid by bank transfer on June 30, 2020. Smart card provided on June 30, 2020. ","2020-06-30 18:00:48","2","IgQlq8MS7boHKFNXljEZbQ==","gZIYclSIylbtkN3gWXuuuA==","IhTelow2\/+v\/Ow4DB\/5ZMhlAD\/M9WXNGmwMScgUrNzc=","uCjMg4Xnu1HX27n1m22k3Q==","2wJPbOO\/vVf9bLDaA2zdwZNEgEoj7v9ohBkGUSlGkVVJTSaW7QUah6Tr5ATKSd4AGaoM00LwgUx0OElqrQDMWQ==","JMC Wild Forest Limited",8260]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:01:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:11:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:30:02","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":"1712","master_room_id":"197","room_code":"A16-221"}],"index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","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-221 4X2X7 $965.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":"A972344(A)","title":"Ms","lastname":"YUEN","firstname":"Lan ","companyname":"","email":"","tel":"97362363","address":"Room 17, 16\/F, King Tsui Court, Fung Wah Estate, Chai Wan, H.K.","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1712","room_code":"A16-221","retail_price":"965.0","discounted_price":"965.00","location_id":"7"}],"roughly_size":"8","total_retail_price":965,"total_discounted_price":3538,"deposit":7076,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":12383,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"5307.00","warehousing_date":"2020-06-30","rent_from":"2020-06-30","rent_to":"2020-09-29","delivery_service":"0","remark":"3 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit paid by cash on June 29, 2020. Smart card provided on June 30, 2020. ","paymethod":"CASH","paymethod2":"CASH","discount_deduct":5307,"order_total":17690,"final_order_total":12383,"location_id":"7","branch_id":"1","company_id":"1","room_key":"076, 34580","order_product":[],"pass":true}},"roughly_size":"8","total_discounted_price":"3538.00","deposit":"7076.00","total_retail_price":"965.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:30:03","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":["C201649","PERSONAL","Ms","As3VmKjcZZhfRLH0SnMZKg==","Z\/P5RghDgz0XwoQL70fUUQ==","","hDMu6a9SHxGub9yjgb3G8Q==",null,"1E+Z3jQC5rxpCIXY0zLEluSH0O1uGcJRjz9a1eyT7fh8Zz7MlDDvtHgkAguGOvHM0u2D81lnDpcxRVDckOiesw==","FvzBmTcomcA7WgsMVIRvSg==",null,null,"KVuJoh6ysSqehOdEZ7dblA==","2","2020-06-30 18:30:02","2","2020-06-30 18:30:02"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:30:04","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",1649,"NEW","A16-CT208261",965,3538,7076,0,"3","3",12383,17690,12383,"2020-06-30 18:30:04","0",null,null,null,"2020-06-30","2020-09-29","3 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit paid by cash on June 29, 2020. Smart card provided on June 30, 2020. ","2020-06-30","8",0,null,5307,"5307.00","2","2020-06-30 18:30:02","2","2020-06-30 18:30:02","CASH","","","","CASH","","","",null,0,"076, 34580","C201649","PERSONAL","Ms","As3VmKjcZZhfRLH0SnMZKg==","Z\/P5RghDgz0XwoQL70fUUQ==","","1E+Z3jQC5rxpCIXY0zLEluSH0O1uGcJRjz9a1eyT7fh8Zz7MlDDvtHgkAguGOvHM0u2D81lnDpcxRVDckOiesw==","hDMu6a9SHxGub9yjgb3G8Q==",null,"FvzBmTcomcA7WgsMVIRvSg==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:30:04","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":["8261","1712","965.0","965.00","2","2020-06-30 18:30:02"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:30:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-30","2020-09-29","1712"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-30 18:30:04","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":["8261","A16-D205512","PAID",7076,0,"2020-09-29","2020-06-30 18:30:02","2020-06-30 18:30:02","2","2020-06-30 18:30:02","2","2020-06-30 18:30:02",1649]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:30:04","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":["8261",1649,"SETTLED","A16-I208590","2020-06-30 18:30:02","2020-06-30","2","2020-06-30 18:30:02","2","2020-06-30 18:30:02"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:30:04","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":["8590","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-30 18:30:02","2","2020-06-30 18:30:02"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:30:04","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":["8590","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1769,"MO","1",1769,"2","2020-06-30 18:30:02","2","2020-06-30 18:30:02"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:30:04","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":["8590","RENT","\u9810\u7e73\u79df\u91d1",3,3538,"MO","1",3538,"2","2020-06-30 18:30:02","2","2020-06-30 18:30:02"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:30:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5307,0,"8590"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-30 18:30:04","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":[1649,"CASH","","","","CASH","","","","PAID","P208233","2020-06-30 18:30:02",12383,"2","2020-06-30 18:30:02","2","2020-06-30 18:30:02","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:30:04","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":["8233","DEPOSIT","5512","PAID","2020-06-30 18:30:02",7076,"2","2020-06-30 18:30:02","2","2020-06-30 18:30:02"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:30:04","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":["8233","INVOICE","8590","PAID","2020-06-30 18:30:02",5307,"2","2020-06-30 18:30:02","2","2020-06-30 18:30:02"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:30:43","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":719,"customer_code":"C180719","identity_type":"PERSONAL","identity_id":"D358328(8)","title":"Mr","lastname":"Man","firstname":"Ka Lai","companyname":"","email":null,"tel":"94842848","address":"Flat 14C, Tower 9, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1945.0","renew_rent_month":"6","renew_warehousing_date":"2020-06-13","renew_room_key":"054,63451","renew_remark":"6 months contract. storage rental paid by bank transfer on Jan 01,2020. Storage deposit transferred from agreement A18-CT195345 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT206822, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"83","order_discount":[],"order_room":[{"room_id":"998","room_code":"X23","retail_price":"2161.0","discounted_price":"2161.00","location_id":"3"}],"roughly_size":"28","total_retail_price":2161,"total_discounted_price":1945,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":11670,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-13","rent_from":"2020-06-13","rent_to":"2020-12-12","delivery_service":"0","remark":"6 months contract. storage rental paid by EPS on Jun 30,2020. Storage deposit transferred from agreement A18-CT206822 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":11670,"final_order_total":11670,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,63451","order_product":[],"pass":true}},"first_order_id":"3966","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\tX23 7X4X7 $2161.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":"28","total_discounted_price":"1945.0","deposit":"0","total_retail_price":"2161.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:30:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",719,"NEW","A18-CT208262",2161,1945,0,0,"6","6",11670,11670,11670,"2020-06-30 18:30:43","0",null,null,null,"2020-06-13","2020-12-12","6 months contract. storage rental paid by EPS on Jun 30,2020. Storage deposit transferred from agreement A18-CT206822 to this agreement.\r\n","2020-06-13","28",0,null,0,"0","2","2020-06-30 18:30:43","2","2020-06-30 18:30:43","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"054,63451","C180719","PERSONAL","Mr","SaxzxleWxcSHOGUHY\/uThg==","1iB+Fi5mVPBhoP\/ei\/0Bag==","","931R+pDZsNU1OLZDcPG2kjJ7ovBswAeYPGoYPGdvvr+0yhPcZ\/YS109\/Jbr8ocRur08md7TUIimfbnuFaFzOcg==","w2ld8Xv9K4wRDmJrGGApqw==",null,"cmsfXb2q81cIiVCE1IzWhg==",null,1,"3966"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:30:43","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":["8262","998","2161.0","2161.00","2","2020-06-30 18:30:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:30:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-13","2020-12-12","998"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-30 18:30:43","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":["8262",719,"SETTLED","A18-I208591","2020-06-30 18:30:43","2020-06-13","2","2020-06-30 18:30:43","2","2020-06-30 18:30:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:30:43","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":["8591","RENT","\u9810\u7e73\u79df\u91d1",1,1945,"MO","1",1945,"2","2020-06-30 18:30:43","2","2020-06-30 18:30:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:30:43","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":["8591","RENT","\u9810\u7e73\u79df\u91d1",2,1945,"MO","1",1945,"2","2020-06-30 18:30:43","2","2020-06-30 18:30:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:30:43","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":["8591","RENT","\u9810\u7e73\u79df\u91d1",3,1945,"MO","1",1945,"2","2020-06-30 18:30:43","2","2020-06-30 18:30:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:30:43","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":["8591","RENT","\u9810\u7e73\u79df\u91d1",4,1945,"MO","1",1945,"2","2020-06-30 18:30:43","2","2020-06-30 18:30:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:30:43","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":["8591","RENT","\u9810\u7e73\u79df\u91d1",5,1945,"MO","1",1945,"2","2020-06-30 18:30:43","2","2020-06-30 18:30:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:30:43","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":["8591","RENT","\u9810\u7e73\u79df\u91d1",6,1945,"MO","1",1945,"2","2020-06-30 18:30:43","2","2020-06-30 18:30:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:30:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11670,0,"8591"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-30 18:30:43","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":[719,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P208234","2020-06-30 18:30:43",11670,"2","2020-06-30 18:30:43","2","2020-06-30 18:30:43","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:30:43","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":["8234","DEPOSIT",null,"PAID","2020-06-30 18:30:43",0,"2","2020-06-30 18:30:43","2","2020-06-30 18:30:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:30:43","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":["8234","INVOICE","8591","PAID","2020-06-30 18:30:43",11670,"2","2020-06-30 18:30:43","2","2020-06-30 18:30:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:32:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:41:48","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":"type=INVOICE&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"Y169795(A)","title":"Mr","lastname":"LAW","firstname":"Kit Man","companyname":"","email":"killgod1991@gmai.com","tel":"64973666","address":"Rm 706, Wah Yin House, Wah Kwai Estate, South, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"463 available_room_list_input","master_room_id":"53","discount_type":"%","price":"2188.00","disocunted_price":"2078.60","discount":"5.00","monthly_deduct":109.4,"room_id":"461","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"461","room_code":"J43","retail_price":"2188.0","discounted_price":2078.6,"location_id":"2"}],"roughly_size":"30","total_retail_price":2188,"total_discounted_price":2188,"deposit":4376,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":7658,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3282.00","warehousing_date":"2020-07-06","rent_from":"2020-07-06","rent_to":"2020-10-05","delivery_service":"0","remark":"3 months contract. Special offer 50% off for the first 3 months based on the original price. Storage rental and deposit paid by bank transfer on June 28,2020. Smart card and padlock provided on June 30,2020.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":3282,"order_total":10940,"final_order_total":7658,"location_id":"2","branch_id":"1","company_id":"1","room_key":"189, 28975","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\tJ43 5X6X8 $2188.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":"30","total_discounted_price":"2188.00","deposit":"4376.00","total_retail_price":"2188.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:41:49","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":["C201650","PERSONAL","Mr","4D0fjYrvzyIdBjdmTtWTIw==","enGRI1kYXjmIiGhoi15EYA==","","sqaLhpAnSc17VcpHVKZ+8Q==","\/zU1liJxkJmlzFVyEgkK2em1\/sAmxfSKiA1U\/4xRGRI=","JOD+Av5Jy1OD\/BsgklCDNc2aE\/m8afCMMMa+oqJvO3iUnbre+NKKFrOYacrEzok0vhHQR8APndrcW5IYrp4akw==","\/Lfk6WJlgwuwJOgZnS1jmQ==",null,"\/zU1liJxkJmlzFVyEgkK2em1\/sAmxfSKiA1U\/4xRGRI=","\/Ajklp08IfQ41laUEE8F5g==","2","2020-06-30 18:41:48","2","2020-06-30 18:41:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:41:50","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",1650,"NEW","A14-CT208263",2188,2188,4376,0,"3","3",7658,10940,7658,"2020-06-30 18:41:50","0",null,null,null,"2020-07-06","2020-10-05","3 months contract. Special offer 50% off for the first 3 months based on the original price. Storage rental and deposit paid by bank transfer on June 28,2020. Smart card and padlock provided on June 30,2020.","2020-07-06","30",0,null,3282,"3282.00","2","2020-06-30 18:41:48","2","2020-06-30 18:41:48","BANKIN","","","","BANKIN","","","",null,0,"189, 28975","C201650","PERSONAL","Mr","4D0fjYrvzyIdBjdmTtWTIw==","enGRI1kYXjmIiGhoi15EYA==","","JOD+Av5Jy1OD\/BsgklCDNc2aE\/m8afCMMMa+oqJvO3iUnbre+NKKFrOYacrEzok0vhHQR8APndrcW5IYrp4akw==","sqaLhpAnSc17VcpHVKZ+8Q==","\/zU1liJxkJmlzFVyEgkK2em1\/sAmxfSKiA1U\/4xRGRI=","\/Lfk6WJlgwuwJOgZnS1jmQ==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:41:50","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":["8263","463 available_room_list_input","53","461","%","5.00",109.4,"2","2020-06-30 18:41:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:41:50","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":["8263","461","2188.0",2078.6,"2","2020-06-30 18:41:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:41:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-06","2020-10-05","461"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-30 18:41:50","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":["8263","A14-D205513","PAID",4376,0,"2020-10-05","2020-06-30 18:41:48","2020-06-30 18:41:48","2","2020-06-30 18:41:48","2","2020-06-30 18:41:48",1650]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:41:50","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":["8263",1650,"SETTLED","A14-I208592","2020-06-30 18:41:48","2020-07-06","2","2020-06-30 18:41:48","2","2020-06-30 18:41:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:41:50","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":["8592","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-30 18:41:48","2","2020-06-30 18:41:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:41:50","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":["8592","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1094,"MO","1",1094,"2","2020-06-30 18:41:48","2","2020-06-30 18:41:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:41:50","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":["8592","RENT","\u9810\u7e73\u79df\u91d1",3,2188,"MO","1",2188,"2","2020-06-30 18:41:48","2","2020-06-30 18:41:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:41:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3282,0,"8592"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-30 18:41:50","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":[1650,"BANKIN","","","","BANKIN","","","","PAID","P208235","2020-06-30 18:41:48",7658,"2","2020-06-30 18:41:48","2","2020-06-30 18:41:48","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:41:50","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":["8235","DEPOSIT","5513","PAID","2020-06-30 18:41:48",4376,"2","2020-06-30 18:41:48","2","2020-06-30 18:41:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:41:50","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":["8235","INVOICE","8592","PAID","2020-06-30 18:41:48",3282,"2","2020-06-30 18:41:48","2","2020-06-30 18:41:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 18:48:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 19:09:46","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":"type=INVOICE&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"P910064(8)","title":"Ms","lastname":"CHEUNG","firstname":"Wing Pui","companyname":"","email":"","tel":"92353948","address":"\u4e0a\u74b0\u65b0\u8857\u5927\u5ec82\u6a13B\u5ba4","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1575","room_code":"A16-084","retail_price":"1410.0","discounted_price":"1410.00","location_id":"7"}],"roughly_size":"16","total_retail_price":1410,"total_discounted_price":1410,"deposit":2820,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":4935,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2115.00","warehousing_date":"2020-06-27","rent_from":"2020-06-27","rent_to":"2020-09-26","delivery_service":"0","remark":"3 months contract. Special offer 50% off for the first 3 months based on the original price. Storage rental and deposit paid by bank transfer on June 27, 2020. Smart card and padlock provided on June 30,2020.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":2115,"order_total":7050,"final_order_total":4935,"location_id":"7","branch_id":"1","company_id":"1","room_key":"189,12153","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\tA16-084 4X4X7 $1410.00 - <\/td> <\/td> \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":"16","total_discounted_price":"1410.00","deposit":"2820.00","total_retail_price":"1410.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 19:09:48","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":["C201651","PERSONAL","Ms","KvQKrLkkvFC0LNSmuebPAA==","ts1WQ6NWxfSAyKGz8YWojw==","","DqqA1dZEPRh9ge\/WYalU1g==",null,"NuzT09ySLoTN+ijnW\/4pNWDNwugFit7ygj2TQdm3\/no=","hPJB7S56nibwDh2K8\/izhg==",null,null,"HACQMjfjLMxusacyWG68MQ==","2","2020-06-30 19:09:46","2","2020-06-30 19:09:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 19:09:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7",1651,"NEW","A16-CT208264",1410,1410,2820,0,"3","3",4935,7050,4935,"2020-06-30 19:09:48","0",null,null,null,"2020-06-27","2020-09-26","3 months contract. Special offer 50% off for the first 3 months based on the original price. Storage rental and deposit paid by bank transfer on June 27, 2020. Smart card and padlock provided on June 30,2020.","2020-06-27","16",0,null,2115,"2115.00","2","2020-06-30 19:09:46","2","2020-06-30 19:09:46","BANKIN","","","","BANKIN","","","",null,0,"189,12153","C201651","PERSONAL","Ms","KvQKrLkkvFC0LNSmuebPAA==","ts1WQ6NWxfSAyKGz8YWojw==","","NuzT09ySLoTN+ijnW\/4pNWDNwugFit7ygj2TQdm3\/no=","DqqA1dZEPRh9ge\/WYalU1g==",null,"hPJB7S56nibwDh2K8\/izhg==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 19:09:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8264","1575","1410.0","1410.00","2","2020-06-30 19:09:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 19:09:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-27","2020-09-26","1575"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-30 19:09:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["8264","A16-D205514","PAID",2820,0,"2020-09-26","2020-06-30 19:09:46","2020-06-30 19:09:46","2","2020-06-30 19:09:46","2","2020-06-30 19:09:46",1651]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 19:09:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8264",1651,"SETTLED","A16-I208593","2020-06-30 19:09:46","2020-06-27","2","2020-06-30 19:09:46","2","2020-06-30 19:09:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 19:09:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8593","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-30 19:09:46","2","2020-06-30 19:09:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 19:09:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8593","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,705,"MO","1",705,"2","2020-06-30 19:09:46","2","2020-06-30 19:09:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 19:09:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8593","RENT","\u9810\u7e73\u79df\u91d1",3,1410,"MO","1",1410,"2","2020-06-30 19:09:46","2","2020-06-30 19:09:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 19:09:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2115,0,"8593"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-30 19:09:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1651,"BANKIN","","","","BANKIN","","","","PAID","P208236","2020-06-30 19:09:46",4935,"2","2020-06-30 19:09:46","2","2020-06-30 19:09:46","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 19:09:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8236","DEPOSIT","5514","PAID","2020-06-30 19:09:46",2820,"2","2020-06-30 19:09:46","2","2020-06-30 19:09:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 19:09:48","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8236","INVOICE","8593","PAID","2020-06-30 19:09:46",2115,"2","2020-06-30 19:09:46","2","2020-06-30 19:09:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-30 20:48:48","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****