\r\n\t\t\t\t\tG16 4X6X8 $1768.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":"24","total_discounted_price":"1592.0","deposit":"0","total_retail_price":"1768.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 10:51:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",734,"NEW","A12-CT206966",1768,1592,0,0,"6","6",9552,9552,9552,"2020-01-15 10:51:37","0",null,null,null,"2020-01-20","2020-07-19","6 months contract. Storage rental paid by bank transfer on January 14, 2020. Storage deposit transferred from agreement A12-CT195457 to this agreement.\r\n","2020-01-20","24",0,null,0,"0","2","2020-01-15 10:51:37","2","2020-01-15 10:51:37","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,41420","C180734","PERSONAL","Mr","BbtSDv0kU+Rb+kf3Qx2hEw==","BiEAQ5B\/TtRrchEiA1Q8dg==","","Dr5FcqfcO\/zvrT0\/usvDd752\/tJnonvLB5w4MwCyhKQ9moBfXw+UiIB8WtYMwO2DA2wIoQ3ng9fhO\/nWeBAkAA==","Gra68+EXReu0Z++VDw7eGg==","u4bDQ1SRR8ttTwMXD8K1cWvZtURZJEFvwKx2ud91J7U=","XmIHieNPPEbNx6G8E3pTqg==",null,1,"4106"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 10:51:37","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":["6966","80","11","375","%","9.95",175.916,"2","2020-01-15 10:51:37"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 10:51:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6966","375","1768.0",1592.1,"2","2020-01-15 10:51:37"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 10:51:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-20","2020-07-19","375"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-15 10:51:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6966",734,"SETTLED","A12-I207294","2020-01-15 10:51:37","2020-01-20","2","2020-01-15 10:51:37","2","2020-01-15 10:51:37"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 10:51:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7294","RENT","\u9810\u7e73\u79df\u91d1",1,1592,"MO","1",1592,"2","2020-01-15 10:51:37","2","2020-01-15 10:51:37"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 10:51:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7294","RENT","\u9810\u7e73\u79df\u91d1",2,1592,"MO","1",1592,"2","2020-01-15 10:51:37","2","2020-01-15 10:51:37"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 10:51:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7294","RENT","\u9810\u7e73\u79df\u91d1",3,1592,"MO","1",1592,"2","2020-01-15 10:51:37","2","2020-01-15 10:51:37"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 10:51:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7294","RENT","\u9810\u7e73\u79df\u91d1",4,1592,"MO","1",1592,"2","2020-01-15 10:51:37","2","2020-01-15 10:51:37"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 10:51:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7294","RENT","\u9810\u7e73\u79df\u91d1",5,1592,"MO","1",1592,"2","2020-01-15 10:51:37","2","2020-01-15 10:51:37"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 10:51:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7294","RENT","\u9810\u7e73\u79df\u91d1",6,1592,"MO","1",1592,"2","2020-01-15 10:51:37","2","2020-01-15 10:51:37"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 10:51:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[9552,0,"7294"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-15 10:51:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[734,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206943","2020-01-15 10:51:37",9552,"2","2020-01-15 10:51:37","2","2020-01-15 10:51:37","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 10:51:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6943","DEPOSIT",null,"PAID","2020-01-15 10:51:37",0,"2","2020-01-15 10:51:37","2","2020-01-15 10:51:37"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 10:51:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6943","INVOICE","7294","PAID","2020-01-15 10:51:37",9552,"2","2020-01-15 10:51:37","2","2020-01-15 10:51:37"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 11:15:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 11:31: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` = ? where id = ?","parameters":["NEW","191,03185","1 month contract. Special offer $4400\/mth. Storage rental and deposit paid by bank transfer on Oct 30,2019. Smartcard provided on Oct 30,2019.","2020-01-15 11:31:43","2","sFvIMVuF8ZsYisXFtwlNOg==","jvk7zrBnQZbXfX1dgEQlHe0RI1vs\/c8ofCzDIiHPduw=","7\/fswsslxCR3F+g7ADa9g4yKLXXfxh\/ahCBs9eZsvJo=","WkO2u9lqQEjRnfUKLBy+6Q==","voDtSK9PGGTovDOARqXC4\/CqVs\/FW\/EFt+7Y8XgoNXnKX\/oYLjrZhZIszuJBDn5WLlxnxR+ombwIyw2An8MxBSJza\/jcybdtGn9ZStmQV6U=",6263]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 11:32:27","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","","1 month contract. Special price $3920\/mth. Storage rental and deposit paid by EPS on Oct 31,2019. Padlock provided on Oct 31,2019.","2020-01-15 11:32:27","2","sFvIMVuF8ZsYisXFtwlNOg==","jvk7zrBnQZbXfX1dgEQlHe0RI1vs\/c8ofCzDIiHPduw=","7\/fswsslxCR3F+g7ADa9g4yKLXXfxh\/ahCBs9eZsvJo=","WkO2u9lqQEjRnfUKLBy+6Q==","voDtSK9PGGTovDOARqXC4\/CqVs\/FW\/EFt+7Y8XgoNXnKX\/oYLjrZhZIszuJBDn5WLlxnxR+ombwIyw2An8MxBSJza\/jcybdtGn9ZStmQV6U=",6272]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 12:47:30","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=1442&filter3=undefined","floor_plan_rent_room":[{"room_id":"1758","master_room_id":"232","room_code":"WC-11"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> \r\n\t\t\t\t\tWC-11 2.5X2.5X4 $798.00 N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"BUSINESS","identity_id":"21475836","title":"Ms","lastname":"WONG","firstname":"Sharon","companyname":"The Boston Consulting Group International GmbH","email":"hkgreception@bcg.com","tel":"25062111","address":"Rm 04-06, Blk 1, 35\/F, One Taikoo Place, 979 King's Road, Quarry Bay, HK","pass":true,"customer_id":"1442","customer_code":"C191442","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1758","room_code":"WC-11","retail_price":"798.0","discounted_price":"798.00","location_id":"8"}],"roughly_size":"6.25","total_retail_price":798,"total_discounted_price":200,"deposit":798,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":998,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-15","rent_from":"2020-01-15","rent_to":"2020-02-14","delivery_service":"0","remark":"5 days contrct. Storage deposit $798 and $700 transportation paid by bank transfer on November 13, 2019. Storage rental $200 and $700 transportation fee paid by bank transfer on January 14, 2020.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":998,"final_order_total":998,"location_id":"8","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"roughly_size":"6.25","total_discounted_price":"200.00","deposit":"798.00","total_retail_price":"798.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 12:47:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","8","1442","NEW","WC-CT206967",798,200,798,0,"1","1",998,998,998,"2020-01-15 12:47:30","0",null,null,null,"2020-01-15","2020-02-14","5 days contrct. Storage deposit $798 and $700 transportation paid by bank transfer on November 13, 2019. Storage rental $200 and $700 transportation fee paid by bank transfer on January 14, 2020.","2020-01-15","6.25",0,null,0,"0","2","2020-01-15 12:47:30","2","2020-01-15 12:47:30","BANKIN","","","","BANKIN","","","",null,0,"","C191442","BUSINESS","Ms","0617evtUu23ydgHgD1bPZw==","ddrfzAYTmkL\/QNu3psjONQ==","The Boston Consulting Group International GmbH","k1NoSEplglbiVLw69Ed3se7RBz8LyxqwMVSRX2Fiwhzs38M3rvNETVMjDJiV3+dYsO1AUSHmLC6dIjUQV+Ww7lxrmgpqLE5jIKqlFd5pCIU=","EY7XW+PMFh75wMV5bVPltw==","ONwYtAzN+YW7FfA1ykdTGpPX+XNW+49hJjiu4XreQOU=",null,"2xzAQtF7eibn2lCPTUHbuQ=="]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 12:47:30","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":["6967","1758","798.0","798.00","2","2020-01-15 12:47:30"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 12:47:30","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-15","2020-02-14","1758"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-15 12:47:30","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":["6967","WC-D205253","PAID",798,0,"2020-02-14","2020-01-15 12:47:30","2020-01-15 12:47:30","2","2020-01-15 12:47:30","2","2020-01-15 12:47:30","1442"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 12:47:30","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":["6967","1442","SETTLED","WC-I207295","2020-01-15 12:47:30","2020-01-15","2","2020-01-15 12:47:30","2","2020-01-15 12:47:30"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 12:47:30","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":["7295","RENT","\u9810\u7e73\u79df\u91d1",1,200,"MO","1",200,"2","2020-01-15 12:47:30","2","2020-01-15 12:47:30"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 12:47:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[200,0,"7295"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-15 12:47:30","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":["1442","BANKIN","","","","BANKIN","","","","PAID","P206944","2020-01-15 12:47:30",998,"2","2020-01-15 12:47:30","2","2020-01-15 12:47:30","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 12:47:30","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":["6944","DEPOSIT","5253","PAID","2020-01-15 12:47:30",798,"2","2020-01-15 12:47:30","2","2020-01-15 12:47:30"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 12:47:30","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":["6944","INVOICE","7295","PAID","2020-01-15 12:47:30",200,"2","2020-01-15 12:47:30","2","2020-01-15 12:47:30"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 13:16:39","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":"","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":986,"customer_code":"C180986","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},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"863.0","renew_rent_month":"3","renew_warehousing_date":"2020-01-11","renew_room_key":"'0012435026","renew_remark":"3 months contract. Storage rental paid by bank transfer on Nov 16, 2019. Deposit $1816 transferred from agreement B01-CT195875 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT196444, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"138","order_discount":[],"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","warehousing_date":"2020-01-11","rent_from":"2020-01-11","rent_to":"2020-02-10","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Jan 15,2020. Deposit $1816 transferred from agreement B01-CT196444 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}},"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.00","deposit":"0.00","total_retail_price":"908.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 13:16:39","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-CT206968",908,908,0,0,"1","1",908,908,908,"2020-01-15 13:16:39","0",null,null,null,"2020-01-11","2020-02-10","1 month contract. Storage rental paid by bank transfer on Jan 15,2020. Deposit $1816 transferred from agreement B01-CT196444 to this agreement.","2020-01-11","12",0,null,0,"0","2","2020-01-15 13:16:39","2","2020-01-15 13:16:39","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-01-15 13:16:39","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":["6968","1219","908.0","908.00","2","2020-01-15 13:16:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 13:16:39","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-11","2020-02-10","1219"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-15 13:16:39","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":["6968",986,"SETTLED","B01-I207296","2020-01-15 13:16:39","2020-01-11","2","2020-01-15 13:16:39","2","2020-01-15 13:16:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 13:16:39","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":["7296","RENT","\u9810\u7e73\u79df\u91d1",1,908,"MO","1",908,"2","2020-01-15 13:16:39","2","2020-01-15 13:16:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 13:16:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[908,0,"7296"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-15 13:16:39","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","P206945","2020-01-15 13:16:39",908,"2","2020-01-15 13:16:39","2","2020-01-15 13:16:39","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 13:16:39","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":["6945","DEPOSIT",null,"PAID","2020-01-15 13:16:39",0,"2","2020-01-15 13:16:39","2","2020-01-15 13:16:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 13:16:39","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":["6945","INVOICE","7296","PAID","2020-01-15 13:16:39",908,"2","2020-01-15 13:16:39","2","2020-01-15 13:16:39"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:13:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:22:33","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":693,"customer_code":"C180693","identity_type":"PERSONAL","identity_id":"D565129(9)","title":"Ms","lastname":"Leung","firstname":"Kwai Fong","companyname":"","email":"jessicakfleung@hotmail.com","tel":"96728663","address":"Flat C, 1\/F, Tower 15, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1226.0","renew_rent_month":"3","renew_warehousing_date":"2020-01-15","renew_room_key":"054,48522","renew_remark":"3 months contract. Storage rental paid by bank transfer on October 21, 2019. Storage deposit transferred from agreement A18-CT194761 to this agreement.\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> \r\n\t\t\t\t\tU17 4X4X7 $1290.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1226.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:22: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",693,"NEW","A18-CT206969",1290,1226,0,0,"3","3",3678,3678,3678,"2020-01-15 14:22:33","0",null,null,null,"2020-01-15","2020-04-14","3 months contract. Storage rental paid by bank transfer on January 15, 2020. Storage deposit transferred from agreement A18-CT196196 to this agreement.\r\n","2020-01-15","16",0,null,0,"0","2","2020-01-15 14:22:33","2","2020-01-15 14:22:33","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,48522","C180693","PERSONAL","Ms","ZDrpquwkwPpy9nQ\/hoLvWg==","xEf2h2aoyRQ71ZVgBH+9WQ==","","lRcsKhHA4vEMmQFs8Z1xVl14ZyKY7zea3KIuIvH2+8tOR0ubeSGQy4fGa4Mn6UEeJiaB1uB\/ralIZd0z2dtCwQ==","Cr1sInxdrsZ\/KrsFTopt5g==","gk9EaWdpCIuN4GRKj6ECgMCv+1T9s97pJxDpLsccXGw=","KQG6Ym4ctwdq+9V9SC\/\/Rg==",null,1,"4761"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:22:33","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":["6969","248","91","916","%","4.97",64.113,"2","2020-01-15 14:22:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:22: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":["6969","916","1290.0",1225.9,"2","2020-01-15 14:22:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:22: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":["2020-01-15","2020-04-14","916"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-15 14:22: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":["6969",693,"SETTLED","A18-I207297","2020-01-15 14:22:33","2020-01-15","2","2020-01-15 14:22:33","2","2020-01-15 14:22:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:22: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":["7297","RENT","\u9810\u7e73\u79df\u91d1",1,1226,"MO","1",1226,"2","2020-01-15 14:22:33","2","2020-01-15 14:22:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:22: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":["7297","RENT","\u9810\u7e73\u79df\u91d1",2,1226,"MO","1",1226,"2","2020-01-15 14:22:33","2","2020-01-15 14:22:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:22: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":["7297","RENT","\u9810\u7e73\u79df\u91d1",3,1226,"MO","1",1226,"2","2020-01-15 14:22:33","2","2020-01-15 14:22:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:22:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3678,0,"7297"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-15 14:22: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":[693,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206946","2020-01-15 14:22:33",3678,"2","2020-01-15 14:22:33","2","2020-01-15 14:22:33","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:22: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":["6946","DEPOSIT",null,"PAID","2020-01-15 14:22:33",0,"2","2020-01-15 14:22:33","2","2020-01-15 14:22:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:22: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":["6946","INVOICE","7297","PAID","2020-01-15 14:22:33",3678,"2","2020-01-15 14:22:33","2","2020-01-15 14:22:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:28:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:33:44","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":894,"customer_code":"C180894","identity_type":"PERSONAL","identity_id":"Z651203(9)","title":"Ms","lastname":"Tse","firstname":"Sui Ying","companyname":"","email":"gracetsesy@gmail.com","tel":"95158005","address":"Room 2408, King Fai House, Yue Fai Court, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1106.0","renew_rent_month":"12","renew_warehousing_date":"2020-01-16","renew_room_key":"190,39702","renew_remark":"12 months contract. Storage rental paid by bank transfer on January 7, 2019. Storage deposit transferred from agreement A14-CT182654 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT194108, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"492","room_code":"K29","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1106,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":13272,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1106","warehousing_date":"2020-01-16","rent_from":"2020-01-16","rent_to":"2021-02-15","delivery_service":"0","remark":"13 months contract.Special offer the 13th month free. Storage rental paid by bank transfer on January 14, 2020. Storage deposit transferred from agreement A14-CT194108 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":1106,"order_total":14378,"final_order_total":13272,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190,39702","order_product":[],"pass":true}},"first_order_id":4108,"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\tK29 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":"16","total_discounted_price":"1106","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:33:44","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",894,"NEW","A14-CT206970",1098,1106,0,0,"13","13",13272,14378,13272,"2020-01-15 14:33:44","0",null,null,null,"2020-01-16","2021-02-15","13 months contract.Special offer the 13th month free. Storage rental paid by bank transfer on January 14, 2020. Storage deposit transferred from agreement A14-CT194108 to this agreement.\r\n","2020-01-16","16",0,null,1106,"1106","2","2020-01-15 14:33:44","2","2020-01-15 14:33:44","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190,39702","C180894","PERSONAL","Ms","\/tkopWEKMCd66juGogKOKQ==","JbA4gcU0oX0prLybEfuQ0g==","","C1d6FYRUAXTtEDlgdujBOTkA0lOZ4BQSmaDwE0ijWZeVEIAijJOPPVDK94CDNUheKzT7BEMSFE2nU9ss49Rr4Q==","F7o+sqRvXmgPjcgDtTT4Ag==","q0PCJxzNEGvK87Sf9U9C9i2+BibnNRI2QlGWwgJ5Zng=","8qEeXnOzENA07vfV8M+nhg==",null,1,4108]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:33:44","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":["6970","492","1098.0","1098.00","2","2020-01-15 14:33:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:33:44","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-16","2021-02-15","492"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-15 14:33:44","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":["6970",894,"SETTLED","A14-I207298","2020-01-15 14:33:44","2020-01-16","2","2020-01-15 14:33:44","2","2020-01-15 14:33:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:33:44","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":["7298","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1106,"MO","1",1106,"2","2020-01-15 14:33:44","2","2020-01-15 14:33:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:33:44","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":["7298","RENT","\u9810\u7e73\u79df\u91d1",3,1106,"MO","1",1106,"2","2020-01-15 14:33:44","2","2020-01-15 14:33:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:33:44","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":["7298","RENT","\u9810\u7e73\u79df\u91d1",4,1106,"MO","1",1106,"2","2020-01-15 14:33:44","2","2020-01-15 14:33:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:33:44","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":["7298","RENT","\u9810\u7e73\u79df\u91d1",5,1106,"MO","1",1106,"2","2020-01-15 14:33:44","2","2020-01-15 14:33:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:33:44","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":["7298","RENT","\u9810\u7e73\u79df\u91d1",6,1106,"MO","1",1106,"2","2020-01-15 14:33:44","2","2020-01-15 14:33:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:33:44","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":["7298","RENT","\u9810\u7e73\u79df\u91d1",7,1106,"MO","1",1106,"2","2020-01-15 14:33:44","2","2020-01-15 14:33:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:33:44","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":["7298","RENT","\u9810\u7e73\u79df\u91d1",8,1106,"MO","1",1106,"2","2020-01-15 14:33:44","2","2020-01-15 14:33:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:33:44","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":["7298","RENT","\u9810\u7e73\u79df\u91d1",9,1106,"MO","1",1106,"2","2020-01-15 14:33:44","2","2020-01-15 14:33:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:33:44","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":["7298","RENT","\u9810\u7e73\u79df\u91d1",10,1106,"MO","1",1106,"2","2020-01-15 14:33:44","2","2020-01-15 14:33:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:33:44","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":["7298","RENT","\u9810\u7e73\u79df\u91d1",11,1106,"MO","1",1106,"2","2020-01-15 14:33:44","2","2020-01-15 14:33:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:33:44","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":["7298","RENT","\u9810\u7e73\u79df\u91d1",12,1106,"MO","1",1106,"2","2020-01-15 14:33:44","2","2020-01-15 14:33:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:33:44","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":["7298","RENT","\u9810\u7e73\u79df\u91d1",13,1106,"MO","1",1106,"2","2020-01-15 14:33:44","2","2020-01-15 14:33:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:33:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13272,0,"7298"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-15 14:33:44","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":[894,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206947","2020-01-15 14:33:44",13272,"2","2020-01-15 14:33:44","2","2020-01-15 14:33:44","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:33:44","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":["6947","DEPOSIT",null,"PAID","2020-01-15 14:33:44",0,"2","2020-01-15 14:33:44","2","2020-01-15 14:33:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:33:44","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":["6947","INVOICE","7298","PAID","2020-01-15 14:33:44",13272,"2","2020-01-15 14:33:44","2","2020-01-15 14:33:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:40:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 14:45:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 15:15:07","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","floor_plan_rent_room":[{"room_id":"1758","master_room_id":"232","room_code":"WC-11"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1301,"customer_code":"C191301","identity_type":"PERSONAL","identity_id":"K08388(5)","title":"Ms","lastname":"Kwan","firstname":"Yuen Yee Amy","companyname":"","email":"akyyhk@yahoo.com","tel":"92750360","address":"Flat L, 9\/F, Blk 5, Hong Sing Garden, Tseung Kwan O, N.T.","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-16","renew_room_key":"111,40893","renew_remark":"1 month contract. Storage rental paid by PPS on December 16, 2019. Storage deposit transferred from agreement A16-CT195950 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT196719, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"202","order_discount":[],"order_room":[{"room_id":"1519","room_code":"A16-028","retail_price":"1290.0","discounted_price":"1290.00","location_id":"7"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1290,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-16","rent_from":"2020-01-16","rent_to":"2020-02-15","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on January 14, 2019. Storage deposit transferred from agreement A16-CT196719 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"7","branch_id":"1","company_id":"1","room_key":"111,40893","order_product":[],"pass":true}},"first_order_id":"5235","selected_room_tr":"\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> \r\n\t\t\t\t\tA16-028 4X4X7 $1290.00 N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1290.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 15:15:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","7",1301,"NEW","A16-CT206971",1290,1290,0,0,"1","1",1290,1290,1290,"2020-01-15 15:15:07","0",null,null,null,"2020-01-16","2020-02-15","1 month contract. Storage rental paid by PPS on January 14, 2019. Storage deposit transferred from agreement A16-CT196719 to this agreement.","2020-01-16","16",0,null,0,"0","2","2020-01-15 15:15:07","2","2020-01-15 15:15:07","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"111,40893","C191301","PERSONAL","Ms","5wigC8kzb56lGRRSAEYGsw==","iNwdG3Dj3OBaAQ6MRfBM1w==","","\/Ewh1holgp6WSTJa\/JHYhYvoqKRvnYtpL3yQk4vYZf\/xWDWin6QHzWL6hMnAUJ4T8XbSzfh5jMoFXOktD1XRYw==","YESwwapoFqF3cRsBQ+uG6A==","G8w9ZbnhyRcx0XoYCRwUCjIw8+4PSVsFNffrrS+i8x4=","kt7RlFLP4CUDPa9sfSXSrg==",null,1,"5235"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 15:15:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6971","1519","1290.0","1290.00","2","2020-01-15 15:15:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 15:15:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-16","2020-02-15","1519"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-15 15:15:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6971",1301,"SETTLED","A16-I207299","2020-01-15 15:15:07","2020-01-16","2","2020-01-15 15:15:07","2","2020-01-15 15:15:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 15:15:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7299","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-01-15 15:15:07","2","2020-01-15 15:15:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 15:15:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"7299"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-15 15:15:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1301,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P206948","2020-01-15 15:15:07",1290,"2","2020-01-15 15:15:07","2","2020-01-15 15:15:07","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 15:15:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6948","DEPOSIT",null,"PAID","2020-01-15 15:15:07",0,"2","2020-01-15 15:15:07","2","2020-01-15 15:15:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 15:15:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6948","INVOICE","7299","PAID","2020-01-15 15:15:07",1290,"2","2020-01-15 15:15:07","2","2020-01-15 15:15:07"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 16:21:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 17:32:35","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 17:55:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-15 18:43:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****