\r\n\t\t\t\t\tD26 4X3X8 $998.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"949.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 10:17:41","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",428,"NEW","A12-CT207189",998,949,0,0,"3","3",2847,2847,2847,"2020-02-14 10:17:41","0",null,null,null,"2020-02-18","2020-05-17","3 months contract. Storage rental paid by bank transfer on February 13, 2020. Storage deposit $1996 transferred from agreement A12-CT196355 to this agreement. ","2020-02-18","12",0,null,0,"0","2","2020-02-14 10:17:41","2","2020-02-14 10:17:41","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"053,57784,055,49261","C170428","PERSONAL","Mr","91\/laaizCwPmpW9Kp7VfpQ==","H9gmHz05\/Te4s1\/V+q8XVg==","","65X9bXQhfMS5Sw3s18SCYnlHuJ74GEdJyMMi7ZWpUt\/xzahhd5USFse9zIrw+zM344D4e5mlnLBzwvdEJf5l0w==","BiBf1UPmN8aaS3XWB1RrSQ==","89NMk5xkAVgN7m2oNV6RkxT9h8K4NzHWFs3mEXMgHMY=","sMhsPbXldtAIhN9s+8njNA==",null,1,6355]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 10:17:41","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":["7189","469","6","222","%","4.91",49.0018,"2","2020-02-14 10:17:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 10:17:41","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":["7189","222","998.0",949,"2","2020-02-14 10:17:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 10:17:41","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-02-18","2020-05-17","222"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-02-14 10:17:41","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":["7189",428,"SETTLED","A12-I207517","2020-02-14 10:17:41","2020-02-18","2","2020-02-14 10:17:41","2","2020-02-14 10:17:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 10:17:41","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":["7517","RENT","\u9810\u7e73\u79df\u91d1",1,949,"MO","1",949,"2","2020-02-14 10:17:41","2","2020-02-14 10:17:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 10:17:41","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":["7517","RENT","\u9810\u7e73\u79df\u91d1",2,949,"MO","1",949,"2","2020-02-14 10:17:41","2","2020-02-14 10:17:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 10:17:41","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":["7517","RENT","\u9810\u7e73\u79df\u91d1",3,949,"MO","1",949,"2","2020-02-14 10:17:41","2","2020-02-14 10:17:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 10:17:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2847,0,"7517"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-02-14 10:17:41","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":[428,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207165","2020-02-14 10:17:41",2847,"2","2020-02-14 10:17:41","2","2020-02-14 10:17:41","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 10:17:41","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":["7165","DEPOSIT",null,"PAID","2020-02-14 10:17:41",0,"2","2020-02-14 10:17:41","2","2020-02-14 10:17:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 10:17:41","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":["7165","INVOICE","7517","PAID","2020-02-14 10:17:41",2847,"2","2020-02-14 10:17:41","2","2020-02-14 10:17:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 10:20:11","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 10:22:27","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=443&filter3=undefined&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&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"727","master_room_id":"34","room_code":"O03"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":767,"customer_code":"C180767","identity_type":"PERSONAL","identity_id":"D837480(6)","title":"Ms","lastname":"Wong","firstname":"Wing Suen Anita","companyname":"","email":"siufeiwong@gmail.com","tel":"96653332","address":"Flat A1, 10\/F, Bay View Mansion, Causeway Bay, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1376.0","renew_rent_month":"6","renew_warehousing_date":"2020-02-14","renew_room_key":"137,00215","renew_remark":"6 months contract. Storage rental paid by bank transfer on August 15, 2019. Storage deposit transferred from agreement A12-CT194398 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195760, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[{"master_room_discount_id":"76","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1376.00","discount":"9.95","monthly_deduct":152.036,"room_id":"380","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"380","room_code":"G21","retail_price":"1528.0","discounted_price":1376,"location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1376,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":8256,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-14","rent_from":"2020-02-14","rent_to":"2020-08-13","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on February 13, 2020. Storage deposit transferred from agreement A12-CT195760 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":8256,"final_order_total":8256,"location_id":"1","branch_id":"1","company_id":"1","room_key":"137,00215","order_product":[],"pass":true}},"first_order_id":"4398","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\tG21 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":"1376.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 10:22: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",767,"NEW","A12-CT207190",1528,1376,0,0,"6","6",8256,8256,8256,"2020-02-14 10:22:27","0",null,null,null,"2020-02-14","2020-08-13","6 months contract. Storage rental paid by bank transfer on February 13, 2020. Storage deposit transferred from agreement A12-CT195760 to this agreement.\r\n","2020-02-14","20",0,null,0,"0","2","2020-02-14 10:22:27","2","2020-02-14 10:22:27","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"137,00215","C180767","PERSONAL","Ms","KlWBRTJkaFhdkNkvt9FAHA==","hULSwM2MvFtpeV9\/z+er8Q==","","y4NxhMAd\/Uwm1\/harJp8uBOIEZJWhWgozQ7tdXXhz\/N72Q5Cw6c3Qpy0xFqYHVDxGLnNoloeuDYcZLeElEBJ6Q==","GgWX+lSsixXdW288aLfd7g==","ez6mBmrNlb2YbfOLD8F7RYi5UwRJCo+Sx6tEm+WH27I=","yz8uB8gyhdGb3OHcZISA6w==",null,1,"4398"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 10:22: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":["7190","76","10","380","%","9.95",152.036,"2","2020-02-14 10:22:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 10:22: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":["7190","380","1528.0",1376,"2","2020-02-14 10:22:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 10:22: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-02-14","2020-08-13","380"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-02-14 10:22: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":["7190",767,"SETTLED","A12-I207518","2020-02-14 10:22:27","2020-02-14","2","2020-02-14 10:22:27","2","2020-02-14 10:22:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 10:22: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":["7518","RENT","\u9810\u7e73\u79df\u91d1",1,1376,"MO","1",1376,"2","2020-02-14 10:22:27","2","2020-02-14 10:22:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 10:22: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":["7518","RENT","\u9810\u7e73\u79df\u91d1",2,1376,"MO","1",1376,"2","2020-02-14 10:22:27","2","2020-02-14 10:22:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 10:22: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":["7518","RENT","\u9810\u7e73\u79df\u91d1",3,1376,"MO","1",1376,"2","2020-02-14 10:22:27","2","2020-02-14 10:22:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 10:22: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":["7518","RENT","\u9810\u7e73\u79df\u91d1",4,1376,"MO","1",1376,"2","2020-02-14 10:22:27","2","2020-02-14 10:22:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 10:22: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":["7518","RENT","\u9810\u7e73\u79df\u91d1",5,1376,"MO","1",1376,"2","2020-02-14 10:22:27","2","2020-02-14 10:22:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 10:22: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":["7518","RENT","\u9810\u7e73\u79df\u91d1",6,1376,"MO","1",1376,"2","2020-02-14 10:22:27","2","2020-02-14 10:22:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 10:22:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8256,0,"7518"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-02-14 10:22: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":[767,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207166","2020-02-14 10:22:27",8256,"2","2020-02-14 10:22:27","2","2020-02-14 10:22:27","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 10:22: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":["7166","DEPOSIT",null,"PAID","2020-02-14 10:22:27",0,"2","2020-02-14 10:22:27","2","2020-02-14 10:22:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 10:22: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":["7166","INVOICE","7518","PAID","2020-02-14 10:22:27",8256,"2","2020-02-14 10:22:27","2","2020-02-14 10:22:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 14:14: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","floor_plan_rent_room":[],"index_url_parameter":"type=INVOICE&filter1=0&filter2=476&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","warehousing":{"1":{"new_customer":0,"identity_type":"PERSONAL","identity_id":"R950235(0)","title":"Mr","lastname":"Mok ","firstname":"Wai Keung","companyname":"","email":"a2488729950@gmail.com","tel":"68457227","address":"Rm2307 ,Sui Ming Hse, Siu Sai Wan Est, Siu Sai Wan, Chai Wan , H.K","pass":true,"customer_id":986,"customer_code":"C180986","customer_first_order":false},"2":{"order_discount":[],"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"908.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-11","renew_room_key":"'0012435026","renew_remark":"1 month contract. Storage rental paid by bank transfer on Jan 15,2020. Deposit $1816 transferred from agreement B01-CT196444 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT206968, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"138","order_room":[{"room_id":"1219","room_code":"B01-029","retail_price":"908.0","discounted_price":"908.00","location_id":"5"}],"roughly_size":"12","total_retail_price":908,"total_discounted_price":908,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":908,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-02-11","rent_from":"2020-02-11","rent_to":"2020-03-10","delivery_service":"0","remark":"1 month contract. Storage rental $903 paid by bank transfer on Feb 14,2020. Outstanding $5 will pay in next contract. Deposit $1816 transferred from agreement B01-CT206968 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":908,"final_order_total":908,"location_id":"5","branch_id":"2","company_id":"1","room_key":"'0012435026","order_product":[],"pass":true}},"renew":1,"first_order_id":"3247","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\tB01-029 4X3X7 $908.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":"12","total_discounted_price":"908.0","deposit":"0","total_retail_price":"908.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 14:14:47","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","2","5",986,"NEW","B01-CT207191",908,908,0,0,"1","1",908,908,908,"2020-02-14 14:14:47","0",null,null,null,"2020-02-11","2020-03-10","1 month contract. Storage rental $903 paid by bank transfer on Feb 14,2020. Outstanding $5 will pay in next contract. Deposit $1816 transferred from agreement B01-CT206968 to this agreement.","2020-02-11","12",0,null,0,"0.00","2","2020-02-14 14:14:46","2","2020-02-14 14:14:46","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0012435026","C180986","PERSONAL","Mr","31Y0XoaFobtCMxnm6mvlFA==","ytgkiE+Fm0DVDP\/K9BuKZg==","","\/xjwgidCRjbnJPBKCuo\/12pqSl6LNrA3NlsIMUsH9BNKaKZYzR6Q54z4PxEVPTW2DvAjTp5DGzVXkPgWrYcHBUDozThZzReTLDf\/mHLbaeQ=","AU0eLXU29TAY\/BkeJ1YrcA==","ngNTmQ\/HB0cYMtP4VGLH4jDsPYe75zJZad7lIY9miHQ=","g+ya6MKmjABbrezVh9RtHw==",null,1,"3247"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 14:14:47","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":["7191","1219","908.0","908.00","2","2020-02-14 14:14:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 14:14:47","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-02-11","2020-03-10","1219"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-02-14 14:14:47","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":["7191",986,"SETTLED","B01-I207519","2020-02-14 14:14:46","2020-02-11","2","2020-02-14 14:14:46","2","2020-02-14 14:14:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 14:14:47","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":["7519","RENT","\u9810\u7e73\u79df\u91d1",1,908,"MO","1",908,"2","2020-02-14 14:14:46","2","2020-02-14 14:14:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 14:14:47","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[908,0,"7519"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-02-14 14:14:47","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":[986,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207167","2020-02-14 14:14:46",908,"2","2020-02-14 14:14:46","2","2020-02-14 14:14:46","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 14:14:47","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":["7167","DEPOSIT",null,"PAID","2020-02-14 14:14:46",0,"2","2020-02-14 14:14:46","2","2020-02-14 14:14:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 14:14:47","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":["7167","INVOICE","7519","PAID","2020-02-14 14:14:46",908,"2","2020-02-14 14:14:46","2","2020-02-14 14:14:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 17:35:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 17:42:10","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=443&filter3=undefined&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&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","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"727","master_room_id":"34","room_code":"O03"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":649,"customer_code":"C170649","identity_type":"PERSONAL","identity_id":"D658788(8)","title":"Mr","lastname":"Wong","firstname":"Shing Kwan Gordon ","companyname":"","email":"gq1310@yahoo.com.hk","tel":"53030469","address":"\u9999\u6e2f\u4ed4\u9038\u6e2f\u5c451\u5ea74\u6a13D\u5ea7","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1525.0","renew_rent_month":"3","renew_warehousing_date":"2019-12-28","renew_room_key":"133,32874","renew_remark":"3 months contract. Storage rental paid by bank transfer on Nov 04, 2019. Storage deposit transferred from agreement A18-CT195555 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196351, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"78","order_discount":[{"master_room_discount_id":"252","master_room_id":"78","discount_type":"%","price":"1605.00","disocunted_price":"1524.80","discount":"5.00","monthly_deduct":80.25,"room_id":"940","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"940","room_code":"V14","retail_price":"1605.0","discounted_price":1524.8,"location_id":"3"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1525,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":4575,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-28","rent_from":"2019-12-28","rent_to":"2020-03-27","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on February 14, 2020. Storage deposit transferred from agreement A18-CT196351 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4575,"final_order_total":4575,"location_id":"3","branch_id":"1","company_id":"1","room_key":"133,32874","order_product":[],"pass":true}},"first_order_id":"4409","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\tV14 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":"1525.0","deposit":"0","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 17:42:11","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",649,"NEW","A18-CT207192",1605,1525,0,0,"3","3",4575,4575,4575,"2020-02-14 17:42:11","0",null,null,null,"2019-12-28","2020-03-27","3 months contract. Storage rental paid by bank transfer on February 14, 2020. Storage deposit transferred from agreement A18-CT196351 to this agreement.","2019-12-28","20",0,null,0,"0","2","2020-02-14 17:42:10","2","2020-02-14 17:42:10","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"133,32874","C170649","PERSONAL","Mr","v4dwfZbWgztWwOO0+DKLqvngLlMYAWBIg5hFuO5UkcI=","hULSwM2MvFtpeV9\/z+er8Q==","","MzIxaThTlSRnM0LX9AJI\/z2u9jCD1+Cmf\/ICago4BP8=","DUwkHg2aCYBYFtwLlrWQSw==","0sqIy\/hJ4IVsR5jpqD48Fg3uig8eD35E9eH8wPbBohA=","wDbeWC0+yorX7t2b+1ST5g==",null,1,"4409"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 17:42:11","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":["7192","252","78","940","%","5.00",80.25,"2","2020-02-14 17:42:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 17:42:11","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":["7192","940","1605.0",1524.8,"2","2020-02-14 17:42:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 17:42:11","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-28","2020-03-27","940"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-02-14 17:42:11","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":["7192",649,"SETTLED","A18-I207520","2020-02-14 17:42:10","2019-12-28","2","2020-02-14 17:42:10","2","2020-02-14 17:42:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 17:42:11","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":["7520","RENT","\u9810\u7e73\u79df\u91d1",1,1525,"MO","1",1525,"2","2020-02-14 17:42:10","2","2020-02-14 17:42:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 17:42:11","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":["7520","RENT","\u9810\u7e73\u79df\u91d1",2,1525,"MO","1",1525,"2","2020-02-14 17:42:10","2","2020-02-14 17:42:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 17:42:11","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":["7520","RENT","\u9810\u7e73\u79df\u91d1",3,1525,"MO","1",1525,"2","2020-02-14 17:42:10","2","2020-02-14 17:42:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 17:42:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4575,0,"7520"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-02-14 17:42:11","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":[649,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207168","2020-02-14 17:42:10",4575,"2","2020-02-14 17:42:10","2","2020-02-14 17:42:10","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 17:42:11","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":["7168","DEPOSIT",null,"PAID","2020-02-14 17:42:10",0,"2","2020-02-14 17:42:10","2","2020-02-14 17:42:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 17:42:11","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":["7168","INVOICE","7520","PAID","2020-02-14 17:42:10",4575,"2","2020-02-14 17:42:10","2","2020-02-14 17:42:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 17:45:32","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=443&filter3=undefined&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&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&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"727","master_room_id":"34","room_code":"O03"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":877,"customer_code":"C180877","identity_type":"PERSONAL","identity_id":"R938804(3)","title":"Ms","lastname":"Cameron","firstname":"Ekaterina","companyname":"","email":"info@nasonpearl.com","tel":"97337317","address":"Flat 2135, 21\/F, Tower 5, Hong Kong Parkview, 88 Tai Tam Reservoir Road, Hong Kong ","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3462.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-30","renew_room_key":"190,40465,189,29022","renew_remark":"1 month contract. Storage rental paid by bank transfer on November 26, 2019. Storage deposit transferred from agreement A18-CT196270 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196516, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"78","order_discount":[],"order_room":[{"room_id":"846","room_code":"S05","retail_price":"1857.0","discounted_price":"1857.00","location_id":"3"},{"room_id":"810","room_code":"Q07","retail_price":"1605.0","discounted_price":"1605.00","location_id":"3"}],"roughly_size":"44","total_retail_price":3462,"total_discounted_price":3462,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":6924,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-30","rent_from":"2019-12-30","rent_to":"2020-02-29","delivery_service":"0","remark":"2 months contract. Storage rental paid by bank transfer on February 14, 2020. Storage deposit transferred from agreement A18-CT196516 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6924,"final_order_total":6924,"location_id":"3","branch_id":"1","company_id":"1","room_key":"190,40465,189,29022","order_product":[],"pass":true}},"first_order_id":"4121","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\tS05 4X6X7 $1857.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\tQ07 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":"44","total_discounted_price":"3462.00","deposit":"0.00","total_retail_price":"3462.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 17:45:33","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",877,"NEW","A18-CT207193",3462,3462,0,0,"2","2",6924,6924,6924,"2020-02-14 17:45:33","0",null,null,null,"2019-12-30","2020-02-29","2 months contract. Storage rental paid by bank transfer on February 14, 2020. Storage deposit transferred from agreement A18-CT196516 to this agreement.\r\n","2019-12-30","44",0,null,0,"0","2","2020-02-14 17:45:32","2","2020-02-14 17:45:32","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190,40465,189,29022","C180877","PERSONAL","Ms","RPthaial2IFX5OTQVN1g+A==","5j4q6ReeucnDk5XYC2qhww==","","rRXmSas1C74UhCIMAl4XVBNkmNxuyBYhPciKj+xVXn2vQd37Gl4JOgs8HGkmy+xJFTDVdTpVVL4FPjZ3S+Pjo17HXHrjXmDiJKqKzjzyVmbMcgqz6jBEyLIHEHGxlwsr","c+0bwcSjwgphezD5fySi+g==","k2\/+w1ZaM4nSEX\/8U65t74fzkbo4RpcfhFOMFpzQU3M=","2SUKxPo6VxWobmWOngKfJg==",null,1,"4121"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 17:45:33","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":["7193","846","1857.0","1857.00","2","2020-02-14 17:45:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 17:45:33","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-30","2020-02-29","846"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-02-14 17:45:33","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":["7193","810","1605.0","1605.00","2","2020-02-14 17:45:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 17:45:33","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-30","2020-02-29","810"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-02-14 17:45:33","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":["7193",877,"SETTLED","A18-I207521","2020-02-14 17:45:32","2019-12-30","2","2020-02-14 17:45:32","2","2020-02-14 17:45:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 17:45:33","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":["7521","RENT","\u9810\u7e73\u79df\u91d1",1,3462,"MO","1",3462,"2","2020-02-14 17:45:32","2","2020-02-14 17:45:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 17:45:33","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":["7521","RENT","\u9810\u7e73\u79df\u91d1",2,3462,"MO","1",3462,"2","2020-02-14 17:45:32","2","2020-02-14 17:45:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 17:45:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6924,0,"7521"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-02-14 17:45:33","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":[877,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207169","2020-02-14 17:45:32",6924,"2","2020-02-14 17:45:32","2","2020-02-14 17:45:32","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 17:45:33","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":["7169","DEPOSIT",null,"PAID","2020-02-14 17:45:32",0,"2","2020-02-14 17:45:32","2","2020-02-14 17:45:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 17:45:33","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":["7169","INVOICE","7521","PAID","2020-02-14 17:45:32",6924,"2","2020-02-14 17:45:32","2","2020-02-14 17:45:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 18:02:35","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":"type=INVOICE&filter1=0&filter2=476&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":922,"customer_code":"C180922","identity_type":"PERSONAL","identity_id":"R093780(A)","title":"Mr","lastname":"Lem","firstname":"Lester","companyname":"","email":null,"tel":"98341337","address":"33 Villase Road, Claymore Mansion 8C Happy Volley","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1395.0","renew_rent_month":"3","renew_warehousing_date":"2020-02-06","renew_room_key":"0005832634","renew_remark":"3 months contract. Storage rental paid by bank transfer on Dec 16, 2019. Storage deposit $2936 transferred from agreement C15-CT196368 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT196709, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"173","order_discount":[{"master_room_discount_id":"419","master_room_id":"173","discount_type":"%","price":"1322.00","disocunted_price":"1255.90","discount":"5.00","monthly_deduct":66.1,"room_id":"1425","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1425","room_code":"C15-119","retail_price":"1322.0","discounted_price":1255.9,"location_id":"6"}],"roughly_size":"24","total_retail_price":1322,"total_discounted_price":1395,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":4185,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-06","rent_from":"2020-02-06","rent_to":"2020-05-05","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on Feb 14,2020. Storage deposit $2936 transferred from agreement C15-CT196709 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4185,"final_order_total":4185,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0005832634","order_product":[],"pass":true}},"first_order_id":"2855","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\tC15-119 4X6X6.5 $1322.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":"24","total_discounted_price":"1395.0","deposit":"0","total_retail_price":"1322.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 18:02:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",922,"NEW","C15-CT207194",1322,1395,0,0,"3","3",4185,4185,4185,"2020-02-14 18:02:36","0",null,null,null,"2020-02-06","2020-05-05","3 months contract. Storage rental paid by bank transfer on Feb 14,2020. Storage deposit $2936 transferred from agreement C15-CT196709 to this agreement.","2020-02-06","24",0,null,0,"0","2","2020-02-14 18:02:35","2","2020-02-14 18:02:35","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005832634","C180922","PERSONAL","Mr","Dzha9dlScOIWPzjcGWfv0g==","GDfCku5DBU5ET7jsJQ4uSQ==","","bQCpfJ6yuCpVED58eFfu55EZKHMm0nCgt7IVHKzBwaIa51jlt0kQdafLHlY\/JF\/mKGWIu5GFpOyI4wUK5Tl5hg==","BsdtSBOUNtjWiYn3vo9VfQ==",null,"j6psOFF4hXAVFDu1lsSO7g==",null,1,"2855"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 18:02:36","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":["7194","419","173","1425","%","5.00",66.1,"2","2020-02-14 18:02:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 18:02:36","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":["7194","1425","1322.0",1255.9,"2","2020-02-14 18:02:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 18:02:36","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-02-06","2020-05-05","1425"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-02-14 18:02:36","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":["7194",922,"SETTLED","C15-I207522","2020-02-14 18:02:35","2020-02-06","2","2020-02-14 18:02:35","2","2020-02-14 18:02:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 18:02:36","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":["7522","RENT","\u9810\u7e73\u79df\u91d1",1,1395,"MO","1",1395,"2","2020-02-14 18:02:35","2","2020-02-14 18:02:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 18:02:36","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":["7522","RENT","\u9810\u7e73\u79df\u91d1",2,1395,"MO","1",1395,"2","2020-02-14 18:02:35","2","2020-02-14 18:02:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 18:02:36","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":["7522","RENT","\u9810\u7e73\u79df\u91d1",3,1395,"MO","1",1395,"2","2020-02-14 18:02:35","2","2020-02-14 18:02:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 18:02:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4185,0,"7522"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-02-14 18:02:36","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":[922,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207170","2020-02-14 18:02:35",4185,"2","2020-02-14 18:02:35","2","2020-02-14 18:02:35","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 18:02:36","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":["7170","DEPOSIT",null,"PAID","2020-02-14 18:02:35",0,"2","2020-02-14 18:02:35","2","2020-02-14 18:02:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 18:02:36","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":["7170","INVOICE","7522","PAID","2020-02-14 18:02:35",4185,"2","2020-02-14 18:02:35","2","2020-02-14 18:02:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-14 18:52:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****