\r\n\t\t\t\t\tK24 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\tK23 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\tK22 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":"48","total_discounted_price":"2668.0","deposit":"0","total_retail_price":"3294.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 10:24:42","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",391,"NEW","A14-CT207734",3294,2668,0,0,"6","6",16008,16008,16008,"2020-04-28 10:24:42","0",null,null,null,"2020-05-03","2020-11-02","6 months contract. Storage rental paid by bank transfer on April 28, 2020. Storage deposit transferred from agreement A14-CT196301 to this agreement.\r\n","2020-05-03","48",0,null,0,"0","2","2020-04-28 10:24:42","2","2020-04-28 10:24:42","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,48078,054,17907","C170391","PERSONAL","Ms","dEx5dsgBTxGzonZa2Qumow==","7PGf6Czv54Blcj1KiNtZiA==","","HDOEKkUBaGFmZa3J0FFSqFjVql6C6mPa369L\/cY3rRN\/c+ucypmlTMx9dAKpc5GS","O5Xvlwf5UNo9HnSwNcJonw==",null,"lpBQidunfo6Svg8P537vKA==",null,1,"4889"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 10:24:42","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":["7734","487","1098.0","1098.00","2","2020-04-28 10:24:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 10:24:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-03","2020-11-02","487"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-28 10:24:42","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":["7734","486","1098.0","1098.00","2","2020-04-28 10:24:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 10:24:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-03","2020-11-02","486"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-28 10:24:42","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":["7734","485","1098.0","1098.00","2","2020-04-28 10:24:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 10:24:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-03","2020-11-02","485"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-28 10:24:42","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":["7734",391,"SETTLED","A14-I208062","2020-04-28 10:24:42","2020-05-03","2","2020-04-28 10:24:42","2","2020-04-28 10:24:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 10:24:42","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":["8062","RENT","\u9810\u7e73\u79df\u91d1",1,2668,"MO","1",2668,"2","2020-04-28 10:24:42","2","2020-04-28 10:24:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 10:24:42","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":["8062","RENT","\u9810\u7e73\u79df\u91d1",2,2668,"MO","1",2668,"2","2020-04-28 10:24:42","2","2020-04-28 10:24:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 10:24:42","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":["8062","RENT","\u9810\u7e73\u79df\u91d1",3,2668,"MO","1",2668,"2","2020-04-28 10:24:42","2","2020-04-28 10:24:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 10:24:42","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":["8062","RENT","\u9810\u7e73\u79df\u91d1",4,2668,"MO","1",2668,"2","2020-04-28 10:24:42","2","2020-04-28 10:24:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 10:24:42","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":["8062","RENT","\u9810\u7e73\u79df\u91d1",5,2668,"MO","1",2668,"2","2020-04-28 10:24:42","2","2020-04-28 10:24:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 10:24:42","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":["8062","RENT","\u9810\u7e73\u79df\u91d1",6,2668,"MO","1",2668,"2","2020-04-28 10:24:42","2","2020-04-28 10:24:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 10:24:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[16008,0,"8062"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-04-28 10:24:42","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":[391,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207708","2020-04-28 10:24:42",16008,"2","2020-04-28 10:24:42","2","2020-04-28 10:24:42","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 10:24:42","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":["7708","DEPOSIT",null,"PAID","2020-04-28 10:24:42",0,"2","2020-04-28 10:24:42","2","2020-04-28 10:24:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 10:24:42","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":["7708","INVOICE","8062","PAID","2020-04-28 10:24:42",16008,"2","2020-04-28 10:24:42","2","2020-04-28 10:24:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 13:11:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 13:17:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 15:00: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=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1251,"customer_code":"C191251","identity_type":"PERSONAL","identity_id":"D855037(A)","title":"Mr","lastname":"YUEN","firstname":"Lik Ling Hamilton","companyname":"","email":"veryvulgar@hotmail.com","tel":"90450380","address":"15A Mount Davis 33, 33 Ka Wai Man Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3064.0","renew_rent_month":"12","renew_warehousing_date":"2020-04-27","renew_room_key":"0005012136","renew_remark":"12 months contract. Special offer 2 months free and $400 transfer discount. Storage rental and deposit paid by bank transfer on April 16, 2019. Smartcard will provided before the move-in day. \\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT194765, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $7856.0","renew_master_room_id":"140","order_discount":[{"master_room_discount_id":"341","master_room_id":"140","discount_type":"%","price":"1112.00","disocunted_price":"723.90","discount":"34.90","monthly_deduct":388.088,"room_id":"1289","is_final_discount":"0","payment_term":"PREPAID_12_MO"},{"master_room_discount_id":"341","master_room_id":"140","discount_type":"%","price":"1112.00","disocunted_price":"723.90","discount":"34.90","monthly_deduct":388.088,"room_id":"1283","is_final_discount":"0","payment_term":"PREPAID_12_MO"},{"master_room_discount_id":"341","master_room_id":"140","discount_type":"%","price":"1112.00","disocunted_price":"723.90","discount":"34.90","monthly_deduct":388.088,"room_id":"1282","is_final_discount":"0","payment_term":"PREPAID_12_MO"},{"master_room_discount_id":"341","master_room_id":"140","discount_type":"%","price":"1112.00","disocunted_price":"723.90","discount":"34.90","monthly_deduct":388.088,"room_id":"1288","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1282","room_code":"B01-092","retail_price":"1112.0","discounted_price":723.9,"location_id":"5"},{"room_id":"1283","room_code":"B01-093","retail_price":"1112.0","discounted_price":723.9,"location_id":"5"},{"room_id":"1288","room_code":"B01-098","retail_price":"1112.0","discounted_price":723.9,"location_id":"5"},{"room_id":"1289","room_code":"B01-099","retail_price":"1112.0","discounted_price":723.9,"location_id":"5"}],"roughly_size":"64","total_retail_price":4448,"total_discounted_price":2868,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":34416,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-27","rent_from":"2020-04-27","rent_to":"2021-04-26","delivery_service":"0","remark":"12 months contract. Prepay 12 months, special offer $2868\/month. Storage rental paid by bank transfer on Apr 28,2020. Storage deposit $7856 transferred from agreement B01-CT194765 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":34416,"final_order_total":34416,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0005012136","order_product":[],"pass":true}},"first_order_id":4765,"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-092 4X4X7 $1112.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\tB01-093 4X4X7 $1112.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\tB01-098 4X4X7 $1112.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\tB01-099 4X4X7 $1112.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":"64","total_discounted_price":"2868.00","deposit":"0","total_retail_price":"4448.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 15:00:45","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",1251,"NEW","B01-CT207735",4448,2868,0,0,"12","12",34416,34416,34416,"2020-04-28 15:00:45","0",null,null,null,"2020-04-27","2021-04-26","12 months contract. Prepay 12 months, special offer $2868\/month. Storage rental paid by bank transfer on Apr 28,2020. Storage deposit $7856 transferred from agreement B01-CT194765 to this agreement.","2020-04-27","64",0,null,0,"0","2","2020-04-28 15:00:44","2","2020-04-28 15:00:44","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005012136","C191251","PERSONAL","Mr","TRrio\/vJ5yTgwids8zPGVZ2OSAJCCLmCoa7vmsM62Y0=","Z\/P5RghDgz0XwoQL70fUUQ==","","h+JyMA9KJKJ2L1Wkeh\/KzhHh8Or+4KmhhV4g8FIHT50I2Y76E70w5ut3k3Q7jn0rf9bBKGZHEs9RQ0vV6rrzDw==","R8OixKfJrK3qLBwuRXgieQ==","SOQxGFgIwNu4osbOPljK+18YF0nouyAwSi8PRO7V8+I=","GgOTXHuHp+otQ5nfOFfUPQ==",null,1,4765]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 15:00:45","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":["7735","341","140","1289","%","34.90",388.088,"2","2020-04-28 15:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 15:00:45","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":["7735","341","140","1283","%","34.90",388.088,"2","2020-04-28 15:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 15:00:45","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":["7735","341","140","1282","%","34.90",388.088,"2","2020-04-28 15:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 15:00:45","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":["7735","341","140","1288","%","34.90",388.088,"2","2020-04-28 15:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 15:00:45","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":["7735","1282","1112.0",723.9,"2","2020-04-28 15:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 15:00:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-27","2021-04-26","1282"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-28 15:00:45","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":["7735","1283","1112.0",723.9,"2","2020-04-28 15:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 15:00:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-27","2021-04-26","1283"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-28 15:00:45","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":["7735","1288","1112.0",723.9,"2","2020-04-28 15:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 15:00:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-27","2021-04-26","1288"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-28 15:00:45","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":["7735","1289","1112.0",723.9,"2","2020-04-28 15:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 15:00:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-27","2021-04-26","1289"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-28 15:00:45","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":["7735",1251,"SETTLED","B01-I208063","2020-04-28 15:00:44","2020-04-27","2","2020-04-28 15:00:44","2","2020-04-28 15:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 15:00:45","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":["8063","RENT","\u9810\u7e73\u79df\u91d1",1,2868,"MO","1",2868,"2","2020-04-28 15:00:44","2","2020-04-28 15:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 15:00:45","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":["8063","RENT","\u9810\u7e73\u79df\u91d1",2,2868,"MO","1",2868,"2","2020-04-28 15:00:44","2","2020-04-28 15:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 15:00:45","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":["8063","RENT","\u9810\u7e73\u79df\u91d1",3,2868,"MO","1",2868,"2","2020-04-28 15:00:44","2","2020-04-28 15:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 15:00:45","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":["8063","RENT","\u9810\u7e73\u79df\u91d1",4,2868,"MO","1",2868,"2","2020-04-28 15:00:44","2","2020-04-28 15:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 15:00:45","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":["8063","RENT","\u9810\u7e73\u79df\u91d1",5,2868,"MO","1",2868,"2","2020-04-28 15:00:44","2","2020-04-28 15:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 15:00:45","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":["8063","RENT","\u9810\u7e73\u79df\u91d1",6,2868,"MO","1",2868,"2","2020-04-28 15:00:44","2","2020-04-28 15:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 15:00:45","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":["8063","RENT","\u9810\u7e73\u79df\u91d1",7,2868,"MO","1",2868,"2","2020-04-28 15:00:44","2","2020-04-28 15:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 15:00:45","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":["8063","RENT","\u9810\u7e73\u79df\u91d1",8,2868,"MO","1",2868,"2","2020-04-28 15:00:44","2","2020-04-28 15:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 15:00:45","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":["8063","RENT","\u9810\u7e73\u79df\u91d1",9,2868,"MO","1",2868,"2","2020-04-28 15:00:44","2","2020-04-28 15:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 15:00:45","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":["8063","RENT","\u9810\u7e73\u79df\u91d1",10,2868,"MO","1",2868,"2","2020-04-28 15:00:44","2","2020-04-28 15:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 15:00:45","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":["8063","RENT","\u9810\u7e73\u79df\u91d1",11,2868,"MO","1",2868,"2","2020-04-28 15:00:44","2","2020-04-28 15:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 15:00:45","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":["8063","RENT","\u9810\u7e73\u79df\u91d1",12,2868,"MO","1",2868,"2","2020-04-28 15:00:44","2","2020-04-28 15:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 15:00:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[34416,0,"8063"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-04-28 15:00:45","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":[1251,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207709","2020-04-28 15:00:44",34416,"2","2020-04-28 15:00:44","2","2020-04-28 15:00:44","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 15:00:45","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":["7709","DEPOSIT",null,"PAID","2020-04-28 15:00:44",0,"2","2020-04-28 15:00:44","2","2020-04-28 15:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 15:00:45","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":["7709","INVOICE","8063","PAID","2020-04-28 15:00:44",34416,"2","2020-04-28 15:00:44","2","2020-04-28 15:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 15:40:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 16:05:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 17:43:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 17:44:15","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ?, `customer_companyname` = ? where id = ?","parameters":["NEW","076,47844","1 month contract. Storage rental paid by bank transfer on April 10, 2020. Storage deposit $4322 transferred form agreement A16-CT207520 to this agreement. \r\n","2020-04-28 17:44:15","2","+pNULpsInm3siHASV0hIrg==","UnAuVv7vF8jhvFzl3xSCmg==","YWYp2e5RTnHURnlliiVCoZfRQjqOlQ4Jschx6rAjv1w=","Gfho0rh19G9JYZxq3cLhUw==","Vz2ejyARH5zcH5e4QlFSq51bZp23xF3kJ5RJpCNl57lAk8+AWULPwqnFcIQcG5ZBdUxERR9syaCIcEtZgd+HqAaztaF6lZ3cM+VjkllU2B0=","Happy Concepts Asia Limited",7612]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 17:52:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:00:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:03:23","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=999&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":999,"customer_code":"C180999","identity_type":"PERSONAL","identity_id":"K209079(1)","title":"Mr","lastname":"Ho","firstname":"Ka Man","companyname":"","email":"hokaman1973@gmail.com","tel":"93080512","address":"Rm517, Chak Tsui Hse, Wan Tsui Estate, Chai Wan","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1678.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-28","renew_room_key":"0005821195","renew_remark":"1 month contract. Storage rental paid by PPS on March 30, 2020. Storage deposit $1678 transferred from agreement C15-CT207306 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\tC15-166 3.5X8X6.5 $1678.00 N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"28","total_discounted_price":"1678.0","deposit":"0","total_retail_price":"1678.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:03:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",999,"NEW","C15-CT207736",1678,1678,0,0,"1","1",1678,1678,1678,"2020-04-28 18:03:24","0",null,null,null,"2020-04-28","2020-05-27","1 month contract. Storage rental paid by PPS on April 27, 2020. Storage deposit $1678 transferred from agreement C15-CT207531 to this agreement. \r\n","2020-04-28","28",0,null,0,"0","2","2020-04-28 18:03:23","2","2020-04-28 18:03:23","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0005821195","C180999","PERSONAL","Mr","mpGDaYSZYMm5Nv4dlC\/AXA==","D\/skxQ5s\/L5yyRWaDK\/iSg==","","s+jJD+PTKIcV6TFUbKAjZeaR7whyPq\/zYSwZaQ3P71eVxgGVseccbnTawUyuMcS0","6hDDMUpiAw3i7Vyi+5LUuw==","O5CaJhqkZvhJIkWAmdNjem53qQvwEVnuhSQx55cm2I4=","lBWb6eJ9jDFkCCTNwsJ4wA==",null,1,"5351"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:03:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7736","1472","1678.0","1678.00","2","2020-04-28 18:03:23"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:03:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-28","2020-05-27","1472"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-28 18:03:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7736",999,"SETTLED","C15-I208064","2020-04-28 18:03:23","2020-04-28","2","2020-04-28 18:03:23","2","2020-04-28 18:03:23"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:03:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8064","RENT","\u9810\u7e73\u79df\u91d1",1,1678,"MO","1",1678,"2","2020-04-28 18:03:23","2","2020-04-28 18:03:23"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:03:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1678,0,"8064"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-04-28 18:03:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[999,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207710","2020-04-28 18:03:23",1678,"2","2020-04-28 18:03:23","2","2020-04-28 18:03:23","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:03:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7710","DEPOSIT",null,"PAID","2020-04-28 18:03:23",0,"2","2020-04-28 18:03:23","2","2020-04-28 18:03:23"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:03:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7710","INVOICE","8064","PAID","2020-04-28 18:03:23",1678,"2","2020-04-28 18:03:23","2","2020-04-28 18:03:23"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:18:19","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=999&filter3=undefined&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1525,"customer_code":"C201525","identity_type":"PERSONAL","identity_id":"D627443(A)","title":"Mr","lastname":"CHOI","firstname":"Four Hing Franki","companyname":"","email":"cflgh@msn.com","tel":"90988941","address":"\u5357\u5be7\u88577-11\u865f\u9999\u6e2f\u4ed4\u4e2d\u5fc32\u671f2\/F, 7A","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-01","renew_room_key":"189,29014","renew_remark":"1 month contract. Storage rental paid by PPS on March 25, 2020. Storage deposit $2580 transferred from agreement A18-CT207268 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207495, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"961","room_code":"W06","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"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-05-01","rent_from":"2020-05-01","rent_to":"2020-05-31","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on April 27, 2020. Storage deposit $2580 transferred from agreement A18-CT207495 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"3","branch_id":"1","company_id":"1","room_key":"189,29014","order_product":[],"pass":true}},"first_order_id":"7268","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\tW06 4X4X7 $1290.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1290.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:18:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",1525,"NEW","A18-CT207737",1290,1290,0,0,"1","1",1290,1290,1290,"2020-04-28 18:18:19","0",null,null,null,"2020-05-01","2020-05-31","1 month contract. Storage rental paid by PPS on April 27, 2020. Storage deposit $2580 transferred from agreement A18-CT207495 to this agreement. \r\n","2020-05-01","16",0,null,0,"0","2","2020-04-28 18:18:19","2","2020-04-28 18:18:19","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"189,29014","C201525","PERSONAL","Mr","vIS8IXZkRCz\/4DSJEmIinoenG6ZUfvhRmXtzZy6KRoQ=","U3iGX7U0CkjAKcdgZ04K6A==","","20f7aMgpRV51FiOUQ6KXK6mkR6c4knVkEjw08eLXIZ9w9x4z60rU\/ZG\/wTtfSJoa","Qy93BhGnEO1KQrhkwq1v1A==","zHs7gYv08db9ZpNBd4xf+g==","QaEoWHg\/xDsQ4hnCUpRbZg==",null,1,"7268"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:18:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7737","961","1290.0","1290.00","2","2020-04-28 18:18:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:18:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-01","2020-05-31","961"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-28 18:18:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7737",1525,"SETTLED","A18-I208065","2020-04-28 18:18:19","2020-05-01","2","2020-04-28 18:18:19","2","2020-04-28 18:18:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:18:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8065","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-04-28 18:18:19","2","2020-04-28 18:18:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:18:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"8065"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-04-28 18:18:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1525,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207711","2020-04-28 18:18:19",1290,"2","2020-04-28 18:18:19","2","2020-04-28 18:18:19","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:18:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7711","DEPOSIT",null,"PAID","2020-04-28 18:18:19",0,"2","2020-04-28 18:18:19","2","2020-04-28 18:18:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:18:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7711","INVOICE","8065","PAID","2020-04-28 18:18:19",1290,"2","2020-04-28 18:18:19","2","2020-04-28 18:18:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:18:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:31:53","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":555,"customer_code":"C170555","identity_type":"PERSONAL","identity_id":"D841834(A)","title":"Ms","lastname":"Chan","firstname":"Man Tung","companyname":"","email":"eggcelen@netvigator.com","tel":"98881338","address":"8B, Tower 1, Larvotto, 8 Ap Lei Chau Praya Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1162.0","renew_rent_month":"13","renew_warehousing_date":"2020-05-10","renew_room_key":"053, 51057","renew_remark":"13 months, special renewal offer, one month free. Storage rental paid by bank transfer on April 9, 2019. Storage deposit transferred from agreement A18-CT183162 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT194727, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"852","room_code":"S11","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":13944,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1162","warehousing_date":"2020-05-10","rent_from":"2020-05-10","rent_to":"2021-06-09","delivery_service":"0","remark":"13 months, special renewal offer, one month free. Storage rental paid by bank transfer on April 28, 2020. Storage deposit transferred from agreement A18-CT194727 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":1162,"order_total":15106,"final_order_total":13944,"location_id":"3","branch_id":"1","company_id":"1","room_key":"053, 51057","order_product":[],"pass":true}},"first_order_id":4727,"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\tS11 4X4X7 $1290.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1162.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:31:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",555,"NEW","A18-CT207738",1290,1162,0,0,"13","13",13944,15106,13944,"2020-04-28 18:31:54","0",null,null,null,"2020-05-10","2021-06-09","13 months, special renewal offer, one month free. Storage rental paid by bank transfer on April 28, 2020. Storage deposit transferred from agreement A18-CT194727 to this agreement.\r\n","2020-05-10","16",0,null,1162,"1162","2","2020-04-28 18:31:53","2","2020-04-28 18:31:53","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"053, 51057","C170555","PERSONAL","Ms","XgmPVwNIT2zXio5+RGJTig==","U9yoE9KqV1v8YlRkf7Q2yg==","","Kt6As1pcPafszPQLmAjLNo+e4n61uZF36xYOqAqSZgHq0GXqp0hCzCYRbjRamhQiu\/lvMvabSEqcVjxTm63zyQ==","oEwur2\/C1Jc1RjF29C7vOw==","xUvgKkPJQsUih19aJqmbFv3j+UbZPzUBQTSwwVzphKE=","6kSNywGTUTHRhwHlQbw1bQ==",null,1,4727]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:31:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7738","852","1290.0","1290.00","2","2020-04-28 18:31:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:31:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-10","2021-06-09","852"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-28 18:31:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7738",555,"SETTLED","A18-I208066","2020-04-28 18:31:53","2020-05-10","2","2020-04-28 18:31:53","2","2020-04-28 18:31:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:31:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8066","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1162,"MO","1",1162,"2","2020-04-28 18:31:53","2","2020-04-28 18:31:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:31:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8066","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-04-28 18:31:53","2","2020-04-28 18:31:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:31:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8066","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-04-28 18:31:53","2","2020-04-28 18:31:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:31:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8066","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-04-28 18:31:53","2","2020-04-28 18:31:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:31:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8066","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-04-28 18:31:53","2","2020-04-28 18:31:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:31:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8066","RENT","\u9810\u7e73\u79df\u91d1",7,1162,"MO","1",1162,"2","2020-04-28 18:31:53","2","2020-04-28 18:31:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:31:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8066","RENT","\u9810\u7e73\u79df\u91d1",8,1162,"MO","1",1162,"2","2020-04-28 18:31:53","2","2020-04-28 18:31:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:31:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8066","RENT","\u9810\u7e73\u79df\u91d1",9,1162,"MO","1",1162,"2","2020-04-28 18:31:53","2","2020-04-28 18:31:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:31:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8066","RENT","\u9810\u7e73\u79df\u91d1",10,1162,"MO","1",1162,"2","2020-04-28 18:31:53","2","2020-04-28 18:31:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:31:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8066","RENT","\u9810\u7e73\u79df\u91d1",11,1162,"MO","1",1162,"2","2020-04-28 18:31:53","2","2020-04-28 18:31:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:31:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8066","RENT","\u9810\u7e73\u79df\u91d1",12,1162,"MO","1",1162,"2","2020-04-28 18:31:53","2","2020-04-28 18:31:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:31:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8066","RENT","\u9810\u7e73\u79df\u91d1",13,1162,"MO","1",1162,"2","2020-04-28 18:31:53","2","2020-04-28 18:31:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:31:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13944,0,"8066"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-04-28 18:31:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[555,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207712","2020-04-28 18:31:53",13944,"2","2020-04-28 18:31:53","2","2020-04-28 18:31:53","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:31:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7712","DEPOSIT",null,"PAID","2020-04-28 18:31:53",0,"2","2020-04-28 18:31:53","2","2020-04-28 18:31:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:31:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7712","INVOICE","8066","PAID","2020-04-28 18:31:53",13944,"2","2020-04-28 18:31:53","2","2020-04-28 18:31:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:35:24","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":663,"customer_code":"C170663","identity_type":"PERSONAL","identity_id":"D302826(8)","title":"Ms","lastname":"Chu","firstname":"Lai Ngan ","companyname":"","email":null,"tel":"91216789","address":"Flat E, 13\/F, Tower 8, South Horizons, Ap Lei Chau","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1605.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-27","renew_room_key":"055,06790","renew_remark":"1 month contract. Storage rental and deposit paid by cheque on March 26,2020.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207493, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $3210.0","renew_master_room_id":"78","order_discount":[],"order_room":[{"room_id":"939","room_code":"V13","retail_price":"1605.0","discounted_price":"1605.00","location_id":"3"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1605,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1605,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-27","rent_from":"2020-04-27","rent_to":"2020-05-26","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on April 27, 2020. Storage deposit transferred from agreement A18-CT207493 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":1605,"final_order_total":1605,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,06790","order_product":[],"pass":true,"paymethod_other2":""}},"first_order_id":7493,"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\tV13 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":"1605.0","deposit":"0","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:35:25","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",663,"NEW","A18-CT207739",1605,1605,0,0,"1","1",1605,1605,1605,"2020-04-28 18:35:25","0",null,null,null,"2020-04-27","2020-05-26","1 month contract. Storage rental paid by bank transfer on April 27, 2020. Storage deposit transferred from agreement A18-CT207493 to this agreement.","2020-04-27","20",0,null,0,"0","2","2020-04-28 18:35:24","2","2020-04-28 18:35:24","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,06790","C170663","PERSONAL","Ms","+hf2BdEzeyuAlJ9o86BQkA==","uwdKi3S38jh5+tBibXKG4A==","","ZkyPYW\/X9p1lPTh\/bKU+\/PiAtXClt+yHReh+airMmSnG6Uwc2BRo5SF4sycqncKB\/EoNyhigJWrejarCTwNPAg==","q3\/rgHjoH\/vhcz82yJ8JGA==",null,"x7LEi0saK+ePsbHhJKXpDQ==",null,1,7493]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:35:25","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":["7739","939","1605.0","1605.00","2","2020-04-28 18:35:24"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:35:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-27","2020-05-26","939"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-28 18:35:25","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":["7739",663,"SETTLED","A18-I208067","2020-04-28 18:35:24","2020-04-27","2","2020-04-28 18:35:24","2","2020-04-28 18:35:24"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:35:25","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":["8067","RENT","\u9810\u7e73\u79df\u91d1",1,1605,"MO","1",1605,"2","2020-04-28 18:35:24","2","2020-04-28 18:35:24"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:35:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1605,0,"8067"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-04-28 18:35:25","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":[663,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207713","2020-04-28 18:35:24",1605,"2","2020-04-28 18:35:24","2","2020-04-28 18:35:24","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:35:25","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":["7713","DEPOSIT",null,"PAID","2020-04-28 18:35:24",0,"2","2020-04-28 18:35:24","2","2020-04-28 18:35:24"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:35:25","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":["7713","INVOICE","8067","PAID","2020-04-28 18:35:24",1605,"2","2020-04-28 18:35:24","2","2020-04-28 18:35:24"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:43:53","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=999&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1297,"customer_code":"C191297","identity_type":"PERSONAL","identity_id":"P944331(6)","title":"Ms","lastname":"Choi","firstname":"Tsz Yan","companyname":"","email":null,"tel":"92211924","address":"Flat 731, Wah Mei House, Wah Fu Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"6","renew_warehousing_date":"2020-03-18","renew_room_key":"076,32310","renew_remark":"6 months contract. Storage rental paid by bank transfer on November 21, 2019. Storage deposit $1196 transferred from agreement A14-CT195215 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196464, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"590","room_code":"M01","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-18","rent_from":"2020-03-18","rent_to":"2020-09-17","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on April 28, 2020. Storage deposit $1196 transferred from agreement A14-CT196464 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,32310","order_product":[],"pass":true}},"first_order_id":"5215","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\tM01 4X3X4 $598.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":"12","total_discounted_price":"538.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:43:53","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",1297,"NEW","A14-CT207740",598,538,0,0,"6","6",3228,3228,3228,"2020-04-28 18:43:53","0",null,null,null,"2020-03-18","2020-09-17","6 months contract. Storage rental paid by bank transfer on April 28, 2020. Storage deposit $1196 transferred from agreement A14-CT196464 to this agreement.","2020-03-18","12",0,null,0,"0","2","2020-04-28 18:43:53","2","2020-04-28 18:43:53","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,32310","C191297","PERSONAL","Ms","m0oACJBPwZ9jtM\/CyN0h8Q==","CjNWoAe1K\/KTKwcji6SOMg==","","RyzwFSZFXlSr90FQrsOvlJIsnUCOJwNdE9Sfr7KC+9xt24wsxZ2hnijiU6iFLyv7FZbSSZMNKaBKA6gaA5z0yA==","Z+tUEuaMAx1CyG9logY75A==",null,"RLtjJp0El2X\/ZAYmjWweyw==",null,1,"5215"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:43:53","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":["7740","590","598.0","598.00","2","2020-04-28 18:43:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:43:53","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-03-18","2020-09-17","590"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-28 18:43:53","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":["7740",1297,"SETTLED","A14-I208068","2020-04-28 18:43:53","2020-03-18","2","2020-04-28 18:43:53","2","2020-04-28 18:43:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:43:53","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":["8068","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-04-28 18:43:53","2","2020-04-28 18:43:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:43:53","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":["8068","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-04-28 18:43:53","2","2020-04-28 18:43:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:43:53","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":["8068","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-04-28 18:43:53","2","2020-04-28 18:43:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:43:53","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":["8068","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-04-28 18:43:53","2","2020-04-28 18:43:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:43:53","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":["8068","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-04-28 18:43:53","2","2020-04-28 18:43:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:43:53","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":["8068","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-04-28 18:43:53","2","2020-04-28 18:43:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:43:53","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"8068"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-04-28 18:43:53","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":[1297,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207714","2020-04-28 18:43:53",3228,"2","2020-04-28 18:43:53","2","2020-04-28 18:43:53","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:43:53","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":["7714","DEPOSIT",null,"PAID","2020-04-28 18:43:53",0,"2","2020-04-28 18:43:53","2","2020-04-28 18:43:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:43:53","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":["7714","INVOICE","8068","PAID","2020-04-28 18:43:53",3228,"2","2020-04-28 18:43:53","2","2020-04-28 18:43:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 18:54:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-28 19:39:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****