\r\n\t\t\t\t\tL23 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":"32","total_discounted_price":"2336.0","deposit":"0","total_retail_price":"2440.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 09:28:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",525,"NEW","A14-CT207021",2440,2336,0,0,"1","1",2336,2336,2336,"2020-01-22 09:28:19","0",null,null,null,"2020-01-21","2020-02-20","1 month contract. Storage rental paid by bank transfer on January 20, 2020. Storage deposit transferred from agreement A14-CT196729 to this agreement.\r\n","2020-01-21","32",0,null,0,"0","2","2020-01-22 09:28:18","2","2020-01-22 09:28:18","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"056,13866","C170525","PERSONAL","Ms","ibYrH9hZ8AxKQwoDOyRf7g==","1iB+Fi5mVPBhoP\/ei\/0Bag==","","6FEfBp4QinpFgaVk\/XySHjwYeKgnpkSt7nsZEe9qVfgX7gsIGumX1P5i\/O8D1hN0","kjGiWZ21y1YpwaPjV74WsA==","qyZUZxcd5Fov\/z6YWfj+Qzvwf4EvFlsT926fUqJ1c+g=","CTeh4\/H1iVpxG8qx2JRcpg==",null,1,"4877"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 09:28: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":["7021","544","1342.0","1342.00","2","2020-01-22 09:28:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 09:28: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-01-21","2020-02-20","544"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-22 09:28: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":["7021","545","1098.0","1098.00","2","2020-01-22 09:28:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 09:28: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-01-21","2020-02-20","545"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-22 09:28: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":["7021",525,"SETTLED","A14-I207349","2020-01-22 09:28:18","2020-01-21","2","2020-01-22 09:28:18","2","2020-01-22 09:28:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 09:28: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":["7349","RENT","\u9810\u7e73\u79df\u91d1",1,2336,"MO","1",2336,"2","2020-01-22 09:28:18","2","2020-01-22 09:28:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 09:28:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2336,0,"7349"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-22 09:28: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":[525,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206998","2020-01-22 09:28:18",2336,"2","2020-01-22 09:28:18","2","2020-01-22 09:28:18","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 09:28: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":["6998","DEPOSIT",null,"PAID","2020-01-22 09:28:18",0,"2","2020-01-22 09:28:18","2","2020-01-22 09:28:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 09:28: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":["6998","INVOICE","7349","PAID","2020-01-22 09:28:18",2336,"2","2020-01-22 09:28:18","2","2020-01-22 09:28:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 09:44:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 11:20:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 11:35:23","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"type=INVOICE","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":193,"customer_code":"C160193","identity_type":"PERSONAL","identity_id":"K727396(7)","title":"Mr","lastname":"Lau","firstname":"Wing Kan","companyname":"","email":null,"tel":"63488822","address":"\u9d28\u8137\u6d32\u5229\u6771\u90a8\u6771\u5e73\u6a13417\u5ba4","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1286.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-19","renew_room_key":"190,40484","renew_remark":"1 month contract. Storage rental paid by cash on Nov 19, 2019. Storage deposit transferred from agreement A12-CT196211 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196439, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"371","room_code":"G12","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1286,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":2572,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-19","rent_from":"2019-12-19","rent_to":"2020-02-18","delivery_service":"0","remark":"2 months contract. Storage rental paid by cash on Jan 22,2020. Storage deposit transferred from agreement A12-CT196439 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":2572,"final_order_total":2572,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190,40484","order_product":[],"pass":true}},"first_order_id":"4777","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\tG12 4X5X8 $1528.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1286.00","deposit":"0.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 11:35:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",193,"NEW","A12-CT207022",1528,1286,0,0,"2","2",2572,2572,2572,"2020-01-22 11:35:23","0",null,null,null,"2019-12-19","2020-02-18","2 months contract. Storage rental paid by cash on Jan 22,2020. Storage deposit transferred from agreement A12-CT196439 to this agreement.","2019-12-19","20",0,null,0,"0","2","2020-01-22 11:35:23","2","2020-01-22 11:35:23","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"190,40484","C160193","PERSONAL","Mr","6PbxGXCeHIo\/MzWTc4fcRg==","oe4emdjBwqJ3qUpOcI17hw==","","JP4Rs\/ygk7B5+4qY1O\/77n4G4SUpGWQ1R+59le4zwir8onzHxmiKA5kLXAeJHhuO","3GH4gAMvtTCKkEWDOO\/eWw==",null,"m393lxqgH7t7KDeHWstXmg==",null,1,"4777"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 11:35:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7022","371","1528.0","1528.00","2","2020-01-22 11:35:23"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 11:35:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-19","2020-02-18","371"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-22 11:35:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7022",193,"SETTLED","A12-I207350","2020-01-22 11:35:23","2019-12-19","2","2020-01-22 11:35:23","2","2020-01-22 11:35:23"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 11:35:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7350","RENT","\u9810\u7e73\u79df\u91d1",1,1286,"MO","1",1286,"2","2020-01-22 11:35:23","2","2020-01-22 11:35:23"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 11:35:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7350","RENT","\u9810\u7e73\u79df\u91d1",2,1286,"MO","1",1286,"2","2020-01-22 11:35:23","2","2020-01-22 11:35:23"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 11:35:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2572,0,"7350"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-22 11:35:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[193,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P206999","2020-01-22 11:35:23",2572,"2","2020-01-22 11:35:23","2","2020-01-22 11:35:23","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 11:35:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6999","DEPOSIT",null,"PAID","2020-01-22 11:35:23",0,"2","2020-01-22 11:35:23","2","2020-01-22 11:35:23"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 11:35:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6999","INVOICE","7350","PAID","2020-01-22 11:35:23",2572,"2","2020-01-22 11:35:23","2","2020-01-22 11:35:23"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 11:37: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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1166,"customer_code":"C191166","identity_type":"PERSONAL","identity_id":"K502726(8)","title":"Mr","lastname":"Wong","firstname":"Tat Kwan","companyname":"","email":null,"tel":"90505534","address":"Flat 2408, 24\/F, Tung King House, Tung Yuk Court, Phase 2, Shau Kei Wan, Hong Kong","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1098.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-28","renew_room_key":"190,62228","renew_remark":"1 month contract. Storage rental and deposit paid by cash on Dec 27,2019. Smartcard and padlock provided on Dec 27,2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196784, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2196.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"131","room_code":"C07","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1098,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1098,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-28","rent_from":"2020-01-28","rent_to":"2020-02-27","delivery_service":"0","remark":"1 month contract. Storage rental and deposit paid by cash on Jan 22,2020. Deposit $2196 transferred from agreement A12-CT196784 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":1098,"final_order_total":1098,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190,62228","order_product":[],"pass":true}},"first_order_id":6784,"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\tC07 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","roughly_size":"16","total_discounted_price":"1098.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 11:37: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","1",1166,"NEW","A12-CT207023",1098,1098,0,0,"1","1",1098,1098,1098,"2020-01-22 11:37:27","0",null,null,null,"2020-01-28","2020-02-27","1 month contract. Storage rental and deposit paid by cash on Jan 22,2020. Deposit $2196 transferred from agreement A12-CT196784 to this agreement. ","2020-01-28","16",0,null,0,"0","2","2020-01-22 11:37:26","2","2020-01-22 11:37:26","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"190,62228","C191166","PERSONAL","Mr","TOLRxvUKxkv3FR+CrWNciw==","hULSwM2MvFtpeV9\/z+er8Q==","","EZdQK44R19ZIQ2x2+ucr3zcQWC5VB7GvV8H+1dD0dARNVscaaxgOY2f7pxLgI7FvpHq2cB9pdtEOTEwBB1HVK5ViympAGaoV1HEkKdVg58TpTpscCRayh5zum7jXGyI5","dHv876yOnAi+9lXqK09fKQ==",null,"7RdCDU\/kQkFcP9umd8iCjg==",null,1,6784]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 11:37: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":["7023","131","1098.0","1098.00","2","2020-01-22 11:37:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 11:37: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-01-28","2020-02-27","131"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-22 11:37: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":["7023",1166,"SETTLED","A12-I207351","2020-01-22 11:37:26","2020-01-28","2","2020-01-22 11:37:26","2","2020-01-22 11:37:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 11:37: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":["7351","RENT","\u9810\u7e73\u79df\u91d1",1,1098,"MO","1",1098,"2","2020-01-22 11:37:26","2","2020-01-22 11:37:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 11:37:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1098,0,"7351"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-22 11:37: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":[1166,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207000","2020-01-22 11:37:26",1098,"2","2020-01-22 11:37:26","2","2020-01-22 11:37:26","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 11:37: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":["7000","DEPOSIT",null,"PAID","2020-01-22 11:37:26",0,"2","2020-01-22 11:37:26","2","2020-01-22 11:37:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 11:37: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":["7000","INVOICE","7351","PAID","2020-01-22 11:37:26",1098,"2","2020-01-22 11:37:26","2","2020-01-22 11:37:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 13:27:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 13:31:18","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":"P673965(6)","title":"Ms","lastname":"POON","firstname":"Amy Kar Yee","companyname":"","email":"amypoon@me.com","tel":"98683095","address":"TBC","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"453 available_room_list_input","master_room_id":"163","discount_type":"%","price":"530.00","disocunted_price":"398.00","discount":"24.91","monthly_deduct":132.023,"room_id":"1443","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1443","room_code":"C15-137","retail_price":"530.0","discounted_price":398,"location_id":"6"}],"roughly_size":"10.8","total_retail_price":530,"total_discounted_price":477,"deposit":530,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":5300,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"954.00","warehousing_date":"2020-01-23","rent_from":"2020-01-23","rent_to":"2021-01-22","delivery_service":"0","remark":"12 months contract. Special offer the 11th and 12th month free. Storage rental and deposit paid by EPS on Jan 22,2020. Smartcard provided on Jan 22,2020.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":954,"order_total":6254,"final_order_total":5300,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0005763998","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\tC15-137 4X2.7X3 $530.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":"10.8","total_discounted_price":"477.00","deposit":"530.00","total_retail_price":"530.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 13:31: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":["C201494","PERSONAL","Ms","YbUbbnbJzVQlPEhxD3rAbg==","nQ0P3urF7MQlYHXgjzt5kA==","","8xGGQJImXTUI2GlYB6biUg==","vfkeSlzY5i7ZiOQE2JAuwA==","6F88GPSmmnGXsPk2ZyJKWg==","zJQ+LHYuTj\/R4pCc01YWJg==",null,"vfkeSlzY5i7ZiOQE2JAuwA==","RVgYQSmiKSzxv4Iwkus1vw==","2","2020-01-22 13:31:18","2","2020-01-22 13:31:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 13:31: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","3","6",1494,"NEW","C15-CT207024",530,477,530,0,"12","12",5300,6254,5300,"2020-01-22 13:31:19","0",null,null,null,"2020-01-23","2021-01-22","12 months contract. Special offer the 11th and 12th month free. Storage rental and deposit paid by EPS on Jan 22,2020. Smartcard provided on Jan 22,2020.","2020-01-23","10.8",0,null,954,"954.00","2","2020-01-22 13:31:18","2","2020-01-22 13:31:18","EPS","","","","EPS","","","",null,0,"0005763998","C201494","PERSONAL","Ms","YbUbbnbJzVQlPEhxD3rAbg==","nQ0P3urF7MQlYHXgjzt5kA==","","6F88GPSmmnGXsPk2ZyJKWg==","8xGGQJImXTUI2GlYB6biUg==","vfkeSlzY5i7ZiOQE2JAuwA==","zJQ+LHYuTj\/R4pCc01YWJg==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 13:31: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":["7024","453 available_room_list_input","163","1443","%","24.91",132.023,"2","2020-01-22 13:31:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 13:31: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":["7024","1443","530.0",398,"2","2020-01-22 13:31:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 13:31: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-01-23","2021-01-22","1443"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-22 13:31: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":["7024","C15-D205263","PAID",530,0,"2021-01-22","2020-01-22 13:31:18","2020-01-22 13:31:18","2","2020-01-22 13:31:18","2","2020-01-22 13:31:18",1494]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 13:31: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":["7024",1494,"SETTLED","C15-I207352","2020-01-22 13:31:18","2020-01-23","2","2020-01-22 13:31:18","2","2020-01-22 13:31:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 13:31: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":["7352","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-01-22 13:31:18","2","2020-01-22 13:31:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 13:31: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":["7352","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,477,"MO","1",477,"2","2020-01-22 13:31:18","2","2020-01-22 13:31:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 13:31: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":["7352","RENT","\u9810\u7e73\u79df\u91d1",4,477,"MO","1",477,"2","2020-01-22 13:31:18","2","2020-01-22 13:31:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 13:31: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":["7352","RENT","\u9810\u7e73\u79df\u91d1",5,477,"MO","1",477,"2","2020-01-22 13:31:18","2","2020-01-22 13:31:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 13:31: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":["7352","RENT","\u9810\u7e73\u79df\u91d1",6,477,"MO","1",477,"2","2020-01-22 13:31:18","2","2020-01-22 13:31:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 13:31: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":["7352","RENT","\u9810\u7e73\u79df\u91d1",7,477,"MO","1",477,"2","2020-01-22 13:31:18","2","2020-01-22 13:31:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 13:31: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":["7352","RENT","\u9810\u7e73\u79df\u91d1",8,477,"MO","1",477,"2","2020-01-22 13:31:18","2","2020-01-22 13:31:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 13:31: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":["7352","RENT","\u9810\u7e73\u79df\u91d1",9,477,"MO","1",477,"2","2020-01-22 13:31:18","2","2020-01-22 13:31:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 13:31: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":["7352","RENT","\u9810\u7e73\u79df\u91d1",10,477,"MO","1",477,"2","2020-01-22 13:31:18","2","2020-01-22 13:31:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 13:31: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":["7352","RENT","\u9810\u7e73\u79df\u91d1",11,477,"MO","1",477,"2","2020-01-22 13:31:18","2","2020-01-22 13:31:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 13:31: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":["7352","RENT","\u9810\u7e73\u79df\u91d1",12,477,"MO","1",477,"2","2020-01-22 13:31:18","2","2020-01-22 13:31:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 13:31:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4770,0,"7352"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-22 13:31: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":[1494,"EPS","","","","EPS","","","","PAID","P207001","2020-01-22 13:31:18",5300,"2","2020-01-22 13:31:18","2","2020-01-22 13:31:18","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 13:31: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":["7001","DEPOSIT","5263","PAID","2020-01-22 13:31:18",530,"2","2020-01-22 13:31:18","2","2020-01-22 13:31:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 13:31: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":["7001","INVOICE","7352","PAID","2020-01-22 13:31:18",4770,"2","2020-01-22 13:31:18","2","2020-01-22 13:31:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 14:39:12","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","054,56155","3 months contract. Storage rental paid by bank transfer on Dec 21,2020. Storage deposit $2176 transferred from agreement A18-CT195990 to this agreement.","2020-01-22 14:39:12","2","U9yoE9KqV1v8YlRkf7Q2yg==","63mqRTB60+F8S2c3OwetCA==","bLtMq3KDaf9NP+w4BNhoWg==","mVxu34\/ADgIroa2ReV6UNfkRhQTfP2t1QMlYHDwC5ZECnVBQ0w7fwHSSTCc1HE46Vj2nWeh+3nvp5Trc8xnlmJ3ABStXSUSe0DlMVITvG6c=",6772]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 14:39:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 14:43:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 14:44:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 16:17:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 17:56:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 18:07:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 18:07:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 18:09:43","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":["VOID","054,49879","6 months contract. Transferred remaining balance $1818 of N22 to M66. M66 Remaining balance $430 paid by EPS on Nov 23,2019.","2020-01-22 18:09:43","2","sQFQFKDK2lCJDg4WUvEEAw==","hfq0epaldO4u8qe3yw39Tw==","TUJtTH7zt04ZVBtwmdz2ihk+kzfQgN8TC8ErMyaqqLU=","2Lxd7jAl\/cRaioA4rUm\/iA==","ydqXO1I4J3Lrhb9V4nDz9HMWZupmOPJBpUthHFU9\/JkWwA6pGC7ol3F7+iZbOHDOXmo2GNMRh1HXDZ5MU6xI2IO+oo2Rv1qakNU7MR2jlpTG2PNIs8Q+AAarsOg\/pOt\/","Pureness Beauty Hong Kong Limited",6489]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 18:19:24","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=786&filter3=undefined","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":"0","customer_id":"786","customer_code":"C180786","identity_type":"PERSONAL","identity_id":"TBC","title":"Ms","lastname":"Chiu","firstname":"Shuk Ching","companyname":"","email":"info@pureness.com.hk","tel":"68187889","address":"Unit 2302, 23\/F, New World, Tower 1, 18 Queen's Road Central, Central, Hong Kong","pass":true,"customer_first_order":false},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"698.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-23","renew_room_key":"054,49879","renew_remark":"6 months contract. Transferred remaining balance $1818 of N22 to M66. M66 Remaining balance $430 paid by EPS on Nov 23,2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196489, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1550.0","renew_master_room_id":"30","order_discount":[],"order_room":[{"room_id":"655","room_code":"M66","retail_price":"775.0","discounted_price":"775.00","location_id":"2"}],"roughly_size":"9","total_retail_price":775,"total_discounted_price":698,"deposit":1550,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3920,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1818.00","warehousing_date":"2019-11-23","rent_from":"2019-11-23","rent_to":"2020-05-22","delivery_service":"0","remark":"6 months contract. Remaining balance $1818 of N22 transferred from agreement SD14-CT181891 to this agreement. Remaining balance $430 paid by EPS on Nov 23,2019, $698 paid by bank transfer on Dec 17,2019. $2792 paid by 4 promissory notes($698\/pc) on Jan 22,2020.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":1818,"order_total":5738,"final_order_total":3920,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,49879","order_product":[],"pass":true}},"first_order_id":6489,"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\tM66 3X3X8 $775.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":"9","total_discounted_price":"698.00","deposit":"1550.00","total_retail_price":"775.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 18:19:24","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","786","NEW","A14-CT207025",775,698,1550,0,"6","6",3920,5738,3920,"2020-01-22 18:19:24","0",null,null,null,"2019-11-23","2020-05-22","6 months contract. Remaining balance $1818 of N22 transferred from agreement SD14-CT181891 to this agreement. Remaining balance $430 paid by EPS on Nov 23,2019, $698 paid by bank transfer on Dec 17,2019. $2792 paid by 4 promissory notes($698\/pc) on Jan 22,2020.","2019-11-23","9",0,null,1818,"1818.00","2","2020-01-22 18:19:24","2","2020-01-22 18:19:24","CHEQUE","","","","CHEQUE","","","",null,0,"054,49879","C180786","PERSONAL","Ms","hfq0epaldO4u8qe3yw39Tw==","sQFQFKDK2lCJDg4WUvEEAw==","","ydqXO1I4J3Lrhb9V4nDz9HMWZupmOPJBpUthHFU9\/JkWwA6pGC7ol3F7+iZbOHDOXmo2GNMRh1HXDZ5MU6xI2IO+oo2Rv1qakNU7MR2jlpTG2PNIs8Q+AAarsOg\/pOt\/","2Lxd7jAl\/cRaioA4rUm\/iA==","TUJtTH7zt04ZVBtwmdz2ihk+kzfQgN8TC8ErMyaqqLU=","6F88GPSmmnGXsPk2ZyJKWg==",null,1,6489]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 18:19:24","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":["7025","655","775.0","775.00","2","2020-01-22 18:19:24"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 18:19:24","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":["2019-11-23","2020-05-22","655"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-22 18:19:24","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":["7025","A14-D205264","PAID",1550,0,"2020-05-22","2020-01-22 18:19:24","2020-01-22 18:19:24","2","2020-01-22 18:19:24","2","2020-01-22 18:19:24","786"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 18:19:24","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":["7025","786","SETTLED","A14-I207353","2020-01-22 18:19:24","2019-11-23","2","2020-01-22 18:19:24","2","2020-01-22 18:19:24"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 18:19:24","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":["7353","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-01-22 18:19:24","2","2020-01-22 18:19:24"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 18:19:24","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":["7353","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-01-22 18:19:24","2","2020-01-22 18:19:24"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 18:19:24","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":["7353","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,276,"MO","1",276,"2","2020-01-22 18:19:24","2","2020-01-22 18:19:24"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 18:19:24","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":["7353","RENT","\u9810\u7e73\u79df\u91d1",4,698,"MO","1",698,"2","2020-01-22 18:19:24","2","2020-01-22 18:19:24"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 18:19:24","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":["7353","RENT","\u9810\u7e73\u79df\u91d1",5,698,"MO","1",698,"2","2020-01-22 18:19:24","2","2020-01-22 18:19:24"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 18:19:24","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":["7353","RENT","\u9810\u7e73\u79df\u91d1",6,698,"MO","1",698,"2","2020-01-22 18:19:24","2","2020-01-22 18:19:24"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 18:19:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2370,0,"7353"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-22 18:19:24","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":["786","CHEQUE","","","","CHEQUE","","","","PAID","P207002","2020-01-22 18:19:24",3920,"2","2020-01-22 18:19:24","2","2020-01-22 18:19:24","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 18:19:24","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":["7002","DEPOSIT","5264","PAID","2020-01-22 18:19:24",1550,"2","2020-01-22 18:19:24","2","2020-01-22 18:19:24"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 18:19:24","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":["7002","INVOICE","7353","PAID","2020-01-22 18:19:24",2370,"2","2020-01-22 18:19:24","2","2020-01-22 18:19:24"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-22 18:30:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****