\r\n\t\t\t\t\tA50 4X5X8 $1528.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\tA51 4X5X8 $1528.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","index_url_parameter":"filter1=2&filter2=798&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","roughly_size":"40","total_discounted_price":"2599.0","deposit":"0","total_retail_price":"3056.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:14:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",743,"NEW","A12-CT208443",3056,2599,0,0,"6","6",15594,15594,15594,"2020-07-22 11:14:09","0",null,null,null,"2020-07-27","2021-01-26","6 months contract. Storage rental $15194 paid by bank transfer on Jul 22, 2020. Balance credit $400 transferred from agreement A12-CT207065 to this agreement. Storage deposit transferred from agreement A12-CT207065 to this agreement.\r\n","2020-07-27","40",0,null,0,"0","2","2020-07-22 11:14:08","2","2020-07-22 11:14:08","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,31724","C180743","PERSONAL","Ms","xl8YzARxqobFgu5qdGYK\/UKKy9YMjmZPHfDbg0Whf0Q=","egeOlBPCZ2i\/hzcvvQMisg==","","zOiUQ1zuE2bBEwRXqfGyNTtJD61RCK8YTYzoqLJdXJYfgcSMVA1w\/e4XTVfDnXV+","R0Ztz7XeRUrQ\/mTdU5vTSA==","\/ytZWViSG2AayMUuWpEVv8idOg4tboq\/mmpHpGZTXno=","Fcrb5K\/Y0MOVHHe1zXw\/Mg==",null,1,"4215"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:14:09","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":["8443","76","10","51","%","9.95",152.036,"2","2020-07-22 11:14:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:14:09","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":["8443","76","10","50","%","9.95",152.036,"2","2020-07-22 11:14:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:14:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8443","50","1528.0",1376,"2","2020-07-22 11:14:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:14:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-27","2021-01-26","50"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-22 11:14:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8443","51","1528.0",1376,"2","2020-07-22 11:14:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:14:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-27","2021-01-26","51"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-22 11:14:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8443",743,"SETTLED","A12-I208772","2020-07-22 11:14:08","2020-07-27","2","2020-07-22 11:14:08","2","2020-07-22 11:14:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:14:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8772","RENT","\u9810\u7e73\u79df\u91d1",1,2599,"MO","1",2599,"2","2020-07-22 11:14:08","2","2020-07-22 11:14:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:14:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8772","RENT","\u9810\u7e73\u79df\u91d1",2,2599,"MO","1",2599,"2","2020-07-22 11:14:08","2","2020-07-22 11:14:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:14:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8772","RENT","\u9810\u7e73\u79df\u91d1",3,2599,"MO","1",2599,"2","2020-07-22 11:14:08","2","2020-07-22 11:14:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:14:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8772","RENT","\u9810\u7e73\u79df\u91d1",4,2599,"MO","1",2599,"2","2020-07-22 11:14:08","2","2020-07-22 11:14:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:14:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8772","RENT","\u9810\u7e73\u79df\u91d1",5,2599,"MO","1",2599,"2","2020-07-22 11:14:08","2","2020-07-22 11:14:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:14:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8772","RENT","\u9810\u7e73\u79df\u91d1",6,2599,"MO","1",2599,"2","2020-07-22 11:14:08","2","2020-07-22 11:14:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:14:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[15594,0,"8772"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-07-22 11:14:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[743,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208415","2020-07-22 11:14:08",15594,"2","2020-07-22 11:14:08","2","2020-07-22 11:14:08","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:14:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8415","DEPOSIT",null,"PAID","2020-07-22 11:14:08",0,"2","2020-07-22 11:14:08","2","2020-07-22 11:14:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:14:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8415","INVOICE","8772","PAID","2020-07-22 11:14:08",15594,"2","2020-07-22 11:14:08","2","2020-07-22 11:14:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:21:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:24:06","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:27:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:29:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:34:50","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=798&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":1160,"customer_code":"C181160","identity_type":"PERSONAL","identity_id":"D462569(3)","title":"Mr","lastname":"Choy","firstname":"Sze Chung Jojo","companyname":"","email":"jojochoy@gmail.com","tel":"91903216","address":"15B Evelyn Towers, 38 Cloud View RD, North Point , Hk","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1134.0","renew_rent_month":"6","renew_warehousing_date":"2020-07-15","renew_room_key":"'0006046794,","renew_remark":"6 months contract. Storage rental paid by bank transfer on Jan 14,2020. Deposit $1260 transferred from agreement C15-CT184027 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT206958, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"182","order_discount":[{"master_room_discount_id":"422","master_room_id":"182","discount_type":"%","price":"1518.00","disocunted_price":"1139.90","discount":"24.91","monthly_deduct":378.1338,"room_id":"1486","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1486","room_code":"C15-180","retail_price":"1518.0","discounted_price":1139.9,"location_id":"6"}],"roughly_size":"25","total_retail_price":1518,"total_discounted_price":1134,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6804,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-15","rent_from":"2020-07-15","rent_to":"2021-01-14","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on Jul 21, 2020. Deposit $1260 transferred from agreement C15-CT206958 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6804,"final_order_total":6804,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0006046794,","order_product":[],"pass":true}},"first_order_id":"4027","selected_room_tr":"\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> \r\n\t\t\t\t\tC15-180 5X5X6.5 $1518.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":"25","total_discounted_price":"1134.0","deposit":"0","total_retail_price":"1518.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:34:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1160,"NEW","C15-CT208444",1518,1134,0,0,"6","6",6804,6804,6804,"2020-07-22 11:34:50","0",null,null,null,"2020-07-15","2021-01-14","6 months contract. Storage rental paid by bank transfer on Jul 21, 2020. Deposit $1260 transferred from agreement C15-CT206958 to this agreement.\r\n","2020-07-15","25",0,null,0,"0","2","2020-07-22 11:34:50","2","2020-07-22 11:34:50","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0006046794,","C181160","PERSONAL","Mr","XogQYsqczoWnr4VqdZowjw==","UrsMAvfb5x9QBcnJ8435JA==","","QgzO2FLBPgqXVT2HNRCQ87I3YqoXNoOgHsBhrNpLCnw+Wn3ZACwNZzmxjIX1MXiYgE3IDkBWxCs7UQ6zi7VCeQ==","jf7soTnmPMmSkegQolte2g==","nBE2d105hijLGGJB19HZKpSsodmdGDDNS1ARH0VsypU=","9Bm8p6PA+pgd+C4g7PSY5w==",null,1,"4027"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:34:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["8444","422","182","1486","%","24.91",378.1338,"2","2020-07-22 11:34:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:34:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8444","1486","1518.0",1139.9,"2","2020-07-22 11:34:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:34:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-15","2021-01-14","1486"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-22 11:34:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8444",1160,"SETTLED","C15-I208773","2020-07-22 11:34:50","2020-07-15","2","2020-07-22 11:34:50","2","2020-07-22 11:34:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:34:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8773","RENT","\u9810\u7e73\u79df\u91d1",1,1134,"MO","1",1134,"2","2020-07-22 11:34:50","2","2020-07-22 11:34:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:34:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8773","RENT","\u9810\u7e73\u79df\u91d1",2,1134,"MO","1",1134,"2","2020-07-22 11:34:50","2","2020-07-22 11:34:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:34:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8773","RENT","\u9810\u7e73\u79df\u91d1",3,1134,"MO","1",1134,"2","2020-07-22 11:34:50","2","2020-07-22 11:34:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:34:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8773","RENT","\u9810\u7e73\u79df\u91d1",4,1134,"MO","1",1134,"2","2020-07-22 11:34:50","2","2020-07-22 11:34:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:34:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8773","RENT","\u9810\u7e73\u79df\u91d1",5,1134,"MO","1",1134,"2","2020-07-22 11:34:50","2","2020-07-22 11:34:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:34:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8773","RENT","\u9810\u7e73\u79df\u91d1",6,1134,"MO","1",1134,"2","2020-07-22 11:34:50","2","2020-07-22 11:34:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:34:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6804,0,"8773"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-07-22 11:34:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1160,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208416","2020-07-22 11:34:50",6804,"2","2020-07-22 11:34:50","2","2020-07-22 11:34:50","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:34:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8416","DEPOSIT",null,"PAID","2020-07-22 11:34:50",0,"2","2020-07-22 11:34:50","2","2020-07-22 11:34:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:34:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8416","INVOICE","8773","PAID","2020-07-22 11:34:50",6804,"2","2020-07-22 11:34:50","2","2020-07-22 11:34:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:41:35","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:41:51","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:42:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 11:49:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 12:02:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 12:09:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 12:25:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 12:45:01","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13: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":"","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1336,"customer_code":"C191336","identity_type":"PERSONAL","identity_id":"K691330(A)","title":"Ms","lastname":"Sy","firstname":"Din Eng","companyname":"","email":"alice_sy_hk@yahoo.com","tel":"94148795","address":"Flat C, 23\/F Tower 1, Marble Garden, 33 Marble Road, North Point, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"696.0","renew_rent_month":"12","renew_warehousing_date":"2020-07-20","renew_room_key":"0012491580","renew_remark":"12 months contract. Special offer 2 months free, 5% "rent now" and $200 discount. Storage deposit $300 paid by cash on 18 July,2019. Remaining balance $6945 paid by bank transfer on 19 July,2019. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT195514, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $773.0","renew_master_room_id":"164","order_discount":[],"order_room":[{"room_id":"1309","room_code":"C15-003","retail_price":"773.0","discounted_price":"773.00","location_id":"6"}],"roughly_size":"10","total_retail_price":773,"total_discounted_price":696,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":8152,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"200.00","warehousing_date":"2020-07-20","rent_from":"2020-07-20","rent_to":"2021-07-19","delivery_service":"0","remark":"12 months contract. Special offer $200 referral bonus (C15-090). Storage rental paid by bank transfer on Jul 22, 2020. Storage deposit $773 transferred from agreement C15-CT195514 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":200,"order_total":8352,"final_order_total":8152,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012491580","order_product":[],"pass":true}},"first_order_id":5514,"selected_room_tr":"\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> \r\n\t\t\t\t\tC15-003 4X2.5X6.5 $773.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":"10","total_discounted_price":"696.0","deposit":"0","total_retail_price":"773.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13: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","3","6",1336,"NEW","C15-CT208445",773,696,0,0,"12","12",8152,8352,8152,"2020-07-22 13:00:45","0",null,null,null,"2020-07-20","2021-07-19","12 months contract. Special offer $200 referral bonus (C15-090). Storage rental paid by bank transfer on Jul 22, 2020. Storage deposit $773 transferred from agreement C15-CT195514 to this agreement.","2020-07-20","10",0,null,200,"200.00","2","2020-07-22 13:00:44","2","2020-07-22 13:00:44","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012491580","C191336","PERSONAL","Ms","2HJA7MGpJOM+TtOEOJsb7g==","G\/ETWmCcN3WzR5h1m2TgXQ==","","dM4qChSsQBcdxsbC3u8+L1zyUATNF2keFfzKgJget4EB80arRWntITGbOnxSdF75mKmQx5xXYwGsgHvmIJfWbamlersDWnT16UHEGPFY5yA=","qtz0koF0BdQ07yBabqQsdg==","naW7Hj\/rkdComTh3Jdm4UdHu5zBx6Btw2xYFYsrCdNs=","LigBGu1ZgirBAWF0LsWUrQ==",null,1,5514]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13: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":["8445","1309","773.0","773.00","2","2020-07-22 13:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13: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-07-20","2021-07-19","1309"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-22 13: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":["8445",1336,"SETTLED","C15-I208774","2020-07-22 13:00:44","2020-07-20","2","2020-07-22 13:00:44","2","2020-07-22 13:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13: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":["8774","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,496,"MO","1",496,"2","2020-07-22 13:00:44","2","2020-07-22 13:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13: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":["8774","RENT","\u9810\u7e73\u79df\u91d1",2,696,"MO","1",696,"2","2020-07-22 13:00:44","2","2020-07-22 13:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13: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":["8774","RENT","\u9810\u7e73\u79df\u91d1",3,696,"MO","1",696,"2","2020-07-22 13:00:44","2","2020-07-22 13:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13: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":["8774","RENT","\u9810\u7e73\u79df\u91d1",4,696,"MO","1",696,"2","2020-07-22 13:00:44","2","2020-07-22 13:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13: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":["8774","RENT","\u9810\u7e73\u79df\u91d1",5,696,"MO","1",696,"2","2020-07-22 13:00:44","2","2020-07-22 13:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13: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":["8774","RENT","\u9810\u7e73\u79df\u91d1",6,696,"MO","1",696,"2","2020-07-22 13:00:44","2","2020-07-22 13:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13: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":["8774","RENT","\u9810\u7e73\u79df\u91d1",7,696,"MO","1",696,"2","2020-07-22 13:00:44","2","2020-07-22 13:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13: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":["8774","RENT","\u9810\u7e73\u79df\u91d1",8,696,"MO","1",696,"2","2020-07-22 13:00:44","2","2020-07-22 13:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13: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":["8774","RENT","\u9810\u7e73\u79df\u91d1",9,696,"MO","1",696,"2","2020-07-22 13:00:44","2","2020-07-22 13:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13: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":["8774","RENT","\u9810\u7e73\u79df\u91d1",10,696,"MO","1",696,"2","2020-07-22 13:00:44","2","2020-07-22 13:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13: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":["8774","RENT","\u9810\u7e73\u79df\u91d1",11,696,"MO","1",696,"2","2020-07-22 13:00:44","2","2020-07-22 13:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13: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":["8774","RENT","\u9810\u7e73\u79df\u91d1",12,696,"MO","1",696,"2","2020-07-22 13:00:44","2","2020-07-22 13:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13:00:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8152,0,"8774"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-07-22 13: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":[1336,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208417","2020-07-22 13:00:44",8152,"2","2020-07-22 13:00:44","2","2020-07-22 13:00:44","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13: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":["8417","DEPOSIT",null,"PAID","2020-07-22 13:00:44",0,"2","2020-07-22 13:00:44","2","2020-07-22 13:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13: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":["8417","INVOICE","8774","PAID","2020-07-22 13:00:44",8152,"2","2020-07-22 13:00:44","2","2020-07-22 13:00:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13:26:14","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":[{"room_id":"819","master_room_id":"88","room_code":"Q16"}],"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\tQ16 5X3X7 $1195.00 N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"Z519869(1)","title":"Mr","lastname":"CHOW","firstname":"Che Chung Edo","companyname":"","email":"edoplanet@gmail.com","tel":"96817127","address":"On Lee Apartment, 2 Mount Davis Road, FL2E, Pokfulam, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"819","room_code":"Q16","retail_price":"1195.0","discounted_price":"1195.00","location_id":"3"}],"roughly_size":"15","total_retail_price":1195,"total_discounted_price":3538,"deposit":7076,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":12383,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"5307.00","warehousing_date":"2020-08-24","rent_from":"2020-08-24","rent_to":"2020-11-23","delivery_service":"0","remark":"3 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit $7076 paid by bank transfer on Jul 22, 2020. Smart card provided by mail on the same day.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":5307,"order_total":17690,"final_order_total":12383,"location_id":"3","branch_id":"1","company_id":"1","room_key":"190,40463","order_product":[],"pass":true}},"roughly_size":"15","total_discounted_price":"3538.00","deposit":"7076.00","total_retail_price":"1195.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13:26:15","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201681","PERSONAL","Mr","A382zuCjoZZ4zIssZJb7eg==","3093ZJqm0DslwzntIOZxaw==","","UAC4jsd2IsXBsyP1xF2l5A==","h8iBwEgnw9JGJVS8cccvqea2fi9GZ84TJRmBPeHmhHw=","v8+QIE2lffLbENSNQu6+83Swdlg5gH2sjx7Hy6\/6xrh7fLOtQ418Gt14OEsppWT2\/PQ6jX\/2A5pmeGYbc1hZOA==","9QpciHLy\/Blt5QBdCU9s4g==",null,"h8iBwEgnw9JGJVS8cccvqea2fi9GZ84TJRmBPeHmhHw=","sDI62qdPCYJdElpGemwMrA==","2","2020-07-22 13:26:14","2","2020-07-22 13:26:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13:26:16","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","3",1681,"NEW","A18-CT208446",1195,3538,7076,0,"3","3",12383,17690,12383,"2020-07-22 13:26:16","0",null,null,null,"2020-08-24","2020-11-23","3 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit $7076 paid by bank transfer on Jul 22, 2020. Smart card provided by mail on the same day.","2020-08-24","15",0,null,5307,"5307.00","2","2020-07-22 13:26:14","2","2020-07-22 13:26:14","BANKIN","","","","BANKIN","","","",null,0,"190,40463","C201681","PERSONAL","Mr","A382zuCjoZZ4zIssZJb7eg==","3093ZJqm0DslwzntIOZxaw==","","v8+QIE2lffLbENSNQu6+83Swdlg5gH2sjx7Hy6\/6xrh7fLOtQ418Gt14OEsppWT2\/PQ6jX\/2A5pmeGYbc1hZOA==","UAC4jsd2IsXBsyP1xF2l5A==","h8iBwEgnw9JGJVS8cccvqea2fi9GZ84TJRmBPeHmhHw=","9QpciHLy\/Blt5QBdCU9s4g==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13:26:16","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":["8446","819","1195.0","1195.00","2","2020-07-22 13:26:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13:26:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-24","2020-11-23","819"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-22 13:26:16","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":["8446","A18-D205558","PAID",7076,0,"2020-11-23","2020-07-22 13:26:14","2020-07-22 13:26:14","2","2020-07-22 13:26:14","2","2020-07-22 13:26:14",1681]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13:26:16","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":["8446",1681,"SETTLED","A18-I208775","2020-07-22 13:26:14","2020-08-24","2","2020-07-22 13:26:14","2","2020-07-22 13:26:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13:26:16","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":["8775","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-07-22 13:26:14","2","2020-07-22 13:26:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13:26:16","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":["8775","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1769,"MO","1",1769,"2","2020-07-22 13:26:14","2","2020-07-22 13:26:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13:26:16","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":["8775","RENT","\u9810\u7e73\u79df\u91d1",3,3538,"MO","1",3538,"2","2020-07-22 13:26:14","2","2020-07-22 13:26:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13:26:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5307,0,"8775"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-07-22 13:26:16","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":[1681,"BANKIN","","","","BANKIN","","","","PAID","P208418","2020-07-22 13:26:14",12383,"2","2020-07-22 13:26:14","2","2020-07-22 13:26:14","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13:26:16","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":["8418","DEPOSIT","5558","PAID","2020-07-22 13:26:14",7076,"2","2020-07-22 13:26:14","2","2020-07-22 13:26:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13:26:16","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":["8418","INVOICE","8775","PAID","2020-07-22 13:26:14",5307,"2","2020-07-22 13:26:14","2","2020-07-22 13:26:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13:34:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 13:49:54","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","189, 28819","3 months contract. Special offer first 3 month 50% off. Storage deposit $500 paid by cash on March 10, 2020. remaining balance paid by EPS on March 21, 2020. Smartcard provided on March 21, 2020. ","2020-07-22 13:49:54","2","BvPqeOM4V79b5HJQ7Cm1Gg==","O83HOPioQNjXAGW\/eMFZ4g==","TdePixtfMM5E\/fanbbX2ZGz3V5U+PhOnBvdswERRPWA=","E+gm\/ytDvQrNa0oPH2aPRQ==","vRtovc3VlnDgaQsC\/UrBBd1QnOK7TmBTPzDzTsWeuXM2CB5sPiTaX8L1isvDTwJImTzOLBZDQihW3bz0flMaiQ==",7463]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 15:06:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 15:27:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 15:30:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 15:59:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 16:00:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 16:37:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 16:47:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 16:48:01","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 16:51:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 16:55:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 17:17: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":"filter1=2&filter2=663&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":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":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2020-07-01","renew_room_key":"055,06790","renew_remark":"1 month contract. Storage rental paid by bank transfer on 05 May, 2020. Storage deposit transferred from agreement A18-CT208015 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\tX14 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-07-22 17:17:34","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-CT208447",1290,1290,0,0,"1","1",1290,1290,1290,"2020-07-22 17:17:34","0",null,null,null,"2020-07-01","2020-07-31","1 month contract. Storage rental paid by bank transfer on July 06, 2020. Storage deposit transferred from agreement A18-CT208330 to this agreement.\r\n","2020-07-01","16",0,null,0,"0","2","2020-07-22 17:17:33","2","2020-07-22 17:17:33","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,"4345"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 17:17:34","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":["8447","989","1290.0","1290.00","2","2020-07-22 17:17:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 17:17:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-01","2020-07-31","989"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-22 17:17:34","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":["8447",663,"SETTLED","A18-I208776","2020-07-22 17:17:33","2020-07-01","2","2020-07-22 17:17:33","2","2020-07-22 17:17:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 17:17:34","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":["8776","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-07-22 17:17:33","2","2020-07-22 17:17:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 17:17:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"8776"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-07-22 17:17:34","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","P208419","2020-07-22 17:17:33",1290,"2","2020-07-22 17:17:33","2","2020-07-22 17:17:33","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 17:17:34","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":["8419","DEPOSIT",null,"PAID","2020-07-22 17:17:33",0,"2","2020-07-22 17:17:33","2","2020-07-22 17:17:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 17:17:34","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":["8419","INVOICE","8776","PAID","2020-07-22 17:17:33",1290,"2","2020-07-22 17:17:33","2","2020-07-22 17:17:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 17:22:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 17:40:04","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"D229644(7)","title":"Ms","lastname":"NG","firstname":"Siu Lin","companyname":"","email":"","tel":"60954074","address":"14C, Li Chit Garden, 1 Li Chit Street, Wan Chai","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1228","room_code":"B01-038","retail_price":"908.0","discounted_price":"908.00","location_id":"5"},{"room_id":"1227","room_code":"B01-037","retail_price":"908.0","discounted_price":"908.00","location_id":"5"}],"roughly_size":"24","total_retail_price":1816,"total_discounted_price":1488,"deposit":2976,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":4464,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-08-01","rent_from":"2020-08-01","rent_to":"2020-08-31","delivery_service":"0","remark":"1 month contract. Storage rental and deposit $2976 paid by bank transfer on Jul 20, 2020. Smart card provided by mail on the same day.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4464,"final_order_total":4464,"location_id":"5","branch_id":"2","company_id":"1","room_key":"'0012492236","order_product":[],"pass":true}},"floor_plan_rent_room":[{"room_id":"1227","master_room_id":"136","room_code":"B01-037"}],"selected_room_tr":"\n\t\t\t\t\t\t\t\t\t\t\t\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n\t\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\t\t\t\t\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>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u5009\u5eab\u7de8\u865f<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> \n\t\t\t\t\tB01-038 3X4X7 $908.00 - <\/td> <\/td> \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\t\t\t\t\tB01-037 3X4X7 $908.00 N\/A <\/td> <\/td> \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\n\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1488.00","deposit":"2976.00","total_retail_price":"1816.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 17:40:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201682","PERSONAL","Ms","NcrgknvHTwAsMvMjr6dxdg==","yXKLXTtbNpECaRVTZxF\/Rw==","","GmJBgvb7oRy6d8ou36zOLg==",null,"eOQYQeaSsD3d+hJWSkhBYPgoCwDex4R1filnSacGJnpYf9ucUnwbsAKrH4CKWZGU","teXEMWJvdr3ws1oIVT446Q==",null,null,"kjqdC92VB7mzjuLuEx11ww==","2","2020-07-22 17:40:04","2","2020-07-22 17:40:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 17:40:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","2","5",1682,"NEW","B01-CT208448",1816,1488,2976,0,"1","1",4464,4464,4464,"2020-07-22 17:40:05","0",null,null,null,"2020-08-01","2020-08-31","1 month contract. Storage rental and deposit $2976 paid by bank transfer on Jul 20, 2020. Smart card provided by mail on the same day.","2020-08-01","24",0,null,0,"0","2","2020-07-22 17:40:04","2","2020-07-22 17:40:04","BANKIN","","","","BANKIN","","","",null,0,"'0012492236","C201682","PERSONAL","Ms","NcrgknvHTwAsMvMjr6dxdg==","yXKLXTtbNpECaRVTZxF\/Rw==","","eOQYQeaSsD3d+hJWSkhBYPgoCwDex4R1filnSacGJnpYf9ucUnwbsAKrH4CKWZGU","GmJBgvb7oRy6d8ou36zOLg==",null,"teXEMWJvdr3ws1oIVT446Q==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 17:40:05","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":["8448","1228","908.0","908.00","2","2020-07-22 17:40:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 17:40:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-01","2020-08-31","1228"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-22 17:40:05","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":["8448","1227","908.0","908.00","2","2020-07-22 17:40:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 17:40:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-01","2020-08-31","1227"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-07-22 17:40:05","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":["8448","B01-D205559","PAID",2976,0,"2020-08-31","2020-07-22 17:40:04","2020-07-22 17:40:04","2","2020-07-22 17:40:04","2","2020-07-22 17:40:04",1682]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 17:40:05","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":["8448",1682,"SETTLED","B01-I208777","2020-07-22 17:40:04","2020-08-01","2","2020-07-22 17:40:04","2","2020-07-22 17:40:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 17:40:05","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":["8777","RENT","\u9810\u7e73\u79df\u91d1",1,1488,"MO","1",1488,"2","2020-07-22 17:40:04","2","2020-07-22 17:40:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 17:40:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1488,0,"8777"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-07-22 17:40:05","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":[1682,"BANKIN","","","","BANKIN","","","","PAID","P208420","2020-07-22 17:40:04",4464,"2","2020-07-22 17:40:04","2","2020-07-22 17:40:04","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 17:40:05","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":["8420","DEPOSIT","5559","PAID","2020-07-22 17:40:04",2976,"2","2020-07-22 17:40:04","2","2020-07-22 17:40:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 17:40:05","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":["8420","INVOICE","8777","PAID","2020-07-22 17:40:04",1488,"2","2020-07-22 17:40:04","2","2020-07-22 17:40:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 17:42:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 17:43:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 17:48:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-07-22 18:35:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****