\r\n\t\t\t\t\tC01 4X5X8 $1528.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1286.00","deposit":"0.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 15:46:31","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",54,"NEW","A12-CT207280",1528,1286,0,0,"1","1",1286,1286,1286,"2020-03-01 15:46:31","0",null,null,null,"2020-02-15","2020-03-14","1 month contract. Storage rental paid by PPS on March 1, 2020. Storage deposit transferred from agreement A12-CT196660 to this agreement.\r\n","2020-02-15","20",0,null,0,"0","2","2020-03-01 15:46:31","2","2020-03-01 15:46:31","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"138,29741","C160054","PERSONAL","Mr","mMV5J7Rfft6JJpDQA9XypQ==","hULSwM2MvFtpeV9\/z+er8Q==","","eD6tjqVeKfxAQSMYm9AHnBkJ5hIG+AW0TS9NTrTNPmy8sb4gGLrOVGrxrpyRxTO4GzKuKO8TvjuGMWhra7oPug==","uQre4vjMJEjZYCpftinh0Q==","oTJWSVWZRAKoy\/KSfvVPXM4ckwr7o\/yBdit4khJKFMc=","rD1nW9Kk4kNwxMXbuMBBAQ==",null,1,"4407"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 15:46:31","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":["7280","125","1528.0","1528.00","2","2020-03-01 15:46:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 15:46:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-15","2020-03-14","125"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-01 15:46:32","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":["7280",54,"SETTLED","A12-I207608","2020-03-01 15:46:31","2020-02-15","2","2020-03-01 15:46:31","2","2020-03-01 15:46:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 15:46:32","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":["7608","RENT","\u9810\u7e73\u79df\u91d1",1,1286,"MO","1",1286,"2","2020-03-01 15:46:31","2","2020-03-01 15:46:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 15:46:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1286,0,"7608"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-01 15:46:32","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":[54,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207256","2020-03-01 15:46:31",1286,"2","2020-03-01 15:46:31","2","2020-03-01 15:46:31","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 15:46:32","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":["7256","DEPOSIT",null,"PAID","2020-03-01 15:46:31",0,"2","2020-03-01 15:46:31","2","2020-03-01 15:46:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 15:46:32","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":["7256","INVOICE","7608","PAID","2020-03-01 15:46:31",1286,"2","2020-03-01 15:46:31","2","2020-03-01 15:46:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 15:49:54","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=1125&filter3=undefined&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":807,"customer_code":"C180807","identity_type":"PERSONAL","identity_id":"K546620(2)","title":"Mr","lastname":"Choy","firstname":"Chung Kit","companyname":"","email":"chung.greatoo@gmail.com","tel":"65722444","address":"Flat F, 17\/F, Pokfulam Gardens, Pok Fu Lam, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1342.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-26","renew_room_key":"072,57038","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 31, 2020. Storage deposit transferred from agreement A14-CT206849 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207080, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"68","order_discount":[],"order_room":[{"room_id":"526","room_code":"L04(\u670d\u88dd\u5009)","retail_price":"1342.0","discounted_price":"1342.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1342,"total_discounted_price":1342,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1342,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-26","rent_from":"2020-02-26","rent_to":"2020-03-25","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on March 1, 2020. Storage deposit transferred from agreement A14-CT207080 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1342,"final_order_total":1342,"location_id":"2","branch_id":"1","company_id":"1","room_key":"072,57038","order_product":[],"pass":true}},"first_order_id":"4859","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\tL04(\u670d\u88dd\u5009) 4X4X8 $1342.00 N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1342.0","deposit":"0","total_retail_price":"1342.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 15:49: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","2",807,"NEW","A14-CT207281",1342,1342,0,0,"1","1",1342,1342,1342,"2020-03-01 15:49:54","0",null,null,null,"2020-02-26","2020-03-25","1 month contract. Storage rental paid by bank transfer on March 1, 2020. Storage deposit transferred from agreement A14-CT207080 to this agreement.\r\n","2020-02-26","16",0,null,0,"0","2","2020-03-01 15:49:54","2","2020-03-01 15:49:54","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"072,57038","C180807","PERSONAL","Mr","UrB+L8vaPiEMZevupuoWEA==","UrsMAvfb5x9QBcnJ8435JA==","","ME0hoxN9uZ9kGpx7EDhDMplFp1dDf6LAd2zTCgZuVMA07NK1aBM+okfJHxxQhQeMEGMyIA8TbBMZxd3bYkNlpA==","yzkFlVLEWHluqrSaK6I+5w==","D5Tn0rsTf6KebW06OoCf5+7qkW80yY20kTJlXh0yutU=","SXzqecVFjMModfNH2tMtyQ==",null,1,"4859"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 15:49: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":["7281","526","1342.0","1342.00","2","2020-03-01 15:49:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 15:49: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-02-26","2020-03-25","526"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-01 15:49: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":["7281",807,"SETTLED","A14-I207609","2020-03-01 15:49:54","2020-02-26","2","2020-03-01 15:49:54","2","2020-03-01 15:49:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 15:49: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":["7609","RENT","\u9810\u7e73\u79df\u91d1",1,1342,"MO","1",1342,"2","2020-03-01 15:49:54","2","2020-03-01 15:49:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 15:49:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1342,0,"7609"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-01 15:49: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":[807,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207257","2020-03-01 15:49:54",1342,"2","2020-03-01 15:49:54","2","2020-03-01 15:49:54","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 15:49: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":["7257","DEPOSIT",null,"PAID","2020-03-01 15:49:54",0,"2","2020-03-01 15:49:54","2","2020-03-01 15:49:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 15:49: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":["7257","INVOICE","7609","PAID","2020-03-01 15:49:54",1342,"2","2020-03-01 15:49:54","2","2020-03-01 15:49:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 15:59:11","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=1125&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":298,"customer_code":"C170298","identity_type":"PERSONAL","identity_id":"k484939(6)","title":"Mr","lastname":"Cheng","firstname":"Man Ho","companyname":"","email":null,"tel":"91305008","address":"\u9d28\u8137\u6d32\u5229\u6771\u90a8\u6771\u5e73\u6a13410\u5ba4","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"989.0","renew_rent_month":"3","renew_warehousing_date":"2020-03-05","renew_room_key":"054,60335","renew_remark":"3 months contract. Storage rental paid by PPS on December 3, 2019. Storage deposit transferred from agreement A14-CT195868 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196628, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[{"master_room_discount_id":"434","master_room_id":"35","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"741","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"741","room_code":"O17","retail_price":"1098.0","discounted_price":1043.4,"location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":989,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2967,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-05","rent_from":"2020-03-05","rent_to":"2020-06-04","delivery_service":"0","remark":"3 months contract. Storage rental paid by PPS on March 1, 2020. Storage deposit transferred from agreement A14-CT196628 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":2967,"final_order_total":2967,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,60335","order_product":[],"pass":true}},"first_order_id":"4491","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\tO17 4X4X8 $1098.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"989.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 15:59:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",298,"NEW","A14-CT207282",1098,989,0,0,"3","3",2967,2967,2967,"2020-03-01 15:59:11","0",null,null,null,"2020-03-05","2020-06-04","3 months contract. Storage rental paid by PPS on March 1, 2020. Storage deposit transferred from agreement A14-CT196628 to this agreement.\r\n","2020-03-05","16",0,null,0,"0","2","2020-03-01 15:59:11","2","2020-03-01 15:59:11","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,60335","C170298","PERSONAL","Mr","jGP6SPxDvmecJxk7lZKF\/A==","UCPBCXrBLI9U7KKsPqgmNA==","","JP4Rs\/ygk7B5+4qY1O\/77sO4cSgE6DyV78DXbBtpGzLv1kaM0\/v3Sy90AKoVl6+m","wTaA4qMQYmlEjCjDpDuThA==",null,"v4paaOPw\/N97VaGmBv\/AGw==",null,1,"4491"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 15:59:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["7282","434","35","741","%","4.97",54.5706,"2","2020-03-01 15:59:11"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 15:59:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7282","741","1098.0",1043.4,"2","2020-03-01 15:59:11"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 15:59:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-05","2020-06-04","741"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-01 15:59:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7282",298,"SETTLED","A14-I207610","2020-03-01 15:59:11","2020-03-05","2","2020-03-01 15:59:11","2","2020-03-01 15:59:11"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 15:59:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7610","RENT","\u9810\u7e73\u79df\u91d1",1,989,"MO","1",989,"2","2020-03-01 15:59:11","2","2020-03-01 15:59:11"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 15:59:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7610","RENT","\u9810\u7e73\u79df\u91d1",2,989,"MO","1",989,"2","2020-03-01 15:59:11","2","2020-03-01 15:59:11"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 15:59:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7610","RENT","\u9810\u7e73\u79df\u91d1",3,989,"MO","1",989,"2","2020-03-01 15:59:11","2","2020-03-01 15:59:11"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 15:59:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2967,0,"7610"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-01 15:59:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[298,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207258","2020-03-01 15:59:11",2967,"2","2020-03-01 15:59:11","2","2020-03-01 15:59:11","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 15:59:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7258","DEPOSIT",null,"PAID","2020-03-01 15:59:11",0,"2","2020-03-01 15:59:11","2","2020-03-01 15:59:11"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 15:59:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7258","INVOICE","7610","PAID","2020-03-01 15:59:11",2967,"2","2020-03-01 15:59:11","2","2020-03-01 15:59:11"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:02:35","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1125&filter3=undefined&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":1144,"customer_code":"C181144","identity_type":"PERSONAL","identity_id":"P119862(2)","title":"Ms","lastname":"LYNCH","firstname":"Katherine Louise","companyname":"","email":"klynch@hku.hk","tel":"98612015","address":"B1 Rodrigues Court, 350 victoria road","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1384.0","renew_rent_month":"4","renew_warehousing_date":"2020-01-11","renew_room_key":"5031144","renew_remark":"4 months contract, storage rental paid by bank transfer on November 20, 2019. Storage deposit $2768 transferred from agreement A05-CT195336 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196465, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"125","order_discount":[],"order_room":[{"room_id":"1071","room_code":"A05-069","retail_price":"1384.0","discounted_price":"1384.00","location_id":"4"}],"roughly_size":"18","total_retail_price":1384,"total_discounted_price":1384,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1384,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-11","rent_from":"2020-01-11","rent_to":"2020-02-10","delivery_service":"0","remark":"1 month contract, storage rental paid by bank transfer on March 1, 2020. Storage deposit $2768 transferred from agreement A05-CT196465 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1384,"final_order_total":1384,"location_id":"4","branch_id":"1","company_id":"1","room_key":"5031144","order_product":[],"pass":true}},"first_order_id":"3869","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\tA05-069 6X3X7 $1384.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":"18","total_discounted_price":"1384.00","deposit":"0.00","total_retail_price":"1384.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:02:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1144,"NEW","A05-CT207283",1384,1384,0,0,"1","1",1384,1384,1384,"2020-03-01 16:02:36","0",null,null,null,"2020-01-11","2020-02-10","1 month contract, storage rental paid by bank transfer on March 1, 2020. Storage deposit $2768 transferred from agreement A05-CT196465 to this agreement.\r\n","2020-01-11","18",0,null,0,"0","2","2020-03-01 16:02:35","2","2020-03-01 16:02:35","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"5031144","C181144","PERSONAL","Ms","pRvUckqUjedhSuP6hjHyd5QcjY8WOyYJRiCMTzrg9pE=","xVGlP\/lp0XHja2WftDhyNg==","","pYnB+qIPhSqfQ2JGXAdViVz+EXg\/ZsKZsp\/iIfVHhTTtjDLnDck+UXDdARxX7IYM","2+MoVDFHBMIU42dUrGhIfw==","yhgITzrJz7y3NuhRNEqCbg==","eToWdLrvi7IkAIlkcwzGQA==",null,1,"3869"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:02:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7283","1071","1384.0","1384.00","2","2020-03-01 16:02:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:02:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-11","2020-02-10","1071"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-01 16:02:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7283",1144,"SETTLED","A05-I207611","2020-03-01 16:02:35","2020-01-11","2","2020-03-01 16:02:35","2","2020-03-01 16:02:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:02:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7611","RENT","\u9810\u7e73\u79df\u91d1",1,1384,"MO","1",1384,"2","2020-03-01 16:02:35","2","2020-03-01 16:02:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:02:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1384,0,"7611"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-01 16:02:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1144,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207259","2020-03-01 16:02:35",1384,"2","2020-03-01 16:02:35","2","2020-03-01 16:02:35","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:02:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7259","DEPOSIT",null,"PAID","2020-03-01 16:02:35",0,"2","2020-03-01 16:02:35","2","2020-03-01 16:02:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:02:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7259","INVOICE","7611","PAID","2020-03-01 16:02:35",1384,"2","2020-03-01 16:02:35","2","2020-03-01 16:02:35"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:07:02","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=1125&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":560,"customer_code":"C170560","identity_type":"PERSONAL","identity_id":"C454277(9)","title":"Mr","lastname":"Li","firstname":"Kwok Choi","companyname":"","email":"benjaminkcli@gmail.com","tel":"91211868","address":"Tower 20-D,34\/F,South Horizons,Apleichau,HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1860.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-01","renew_room_key":"054,16918","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 31, 2020. Storage deposit transferred from agreement A12-CT196819 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207081, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"335","room_code":"F20","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"},{"room_id":"324","room_code":"F09","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"28","total_retail_price":2096,"total_discounted_price":1860,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1860,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-01","rent_from":"2020-03-01","rent_to":"2020-03-31","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on March 1, 2020. Storage deposit transferred from agreement A12-CT207081 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1860,"final_order_total":1860,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,16918","order_product":[],"pass":true}},"first_order_id":"4811","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\tF20 4X4X8 $1098.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\tF09 4X3X8 $998.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"28","total_discounted_price":"1860.0","deposit":"0","total_retail_price":"2096.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:07:02","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",560,"NEW","A12-CT207284",2096,1860,0,0,"1","1",1860,1860,1860,"2020-03-01 16:07:02","0",null,null,null,"2020-03-01","2020-03-31","1 month contract. Storage rental paid by bank transfer on March 1, 2020. Storage deposit transferred from agreement A12-CT207081 to this agreement.\r\n","2020-03-01","28",0,null,0,"0","2","2020-03-01 16:07:02","2","2020-03-01 16:07:02","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,16918","C170560","PERSONAL","Mr","K1x\/9w0o0rKJd7wz8qK7pg==","7KCehmxbvwRMb+U8lHGoVA==","","FtBAyqdJB9YVbXi504FRZc\/Jt3mzCqv\/xe\/RY0+A7wVOOPyXv8dxE4H5XZLFEXzC","4QMR+NS4lG0kYGIev9anRw==","ZR5GFjUu0SZOy4e7QYAXd00ul0qCow7bN10OYhy9E+I=","Yd8HrzCK1iQ9KWTKpSyu0w==",null,1,"4811"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:07:02","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":["7284","335","1098.0","1098.00","2","2020-03-01 16:07:02"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:07:02","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-01","2020-03-31","335"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-01 16:07:02","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":["7284","324","998.0","998.00","2","2020-03-01 16:07:02"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:07:02","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-01","2020-03-31","324"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-01 16:07:02","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":["7284",560,"SETTLED","A12-I207612","2020-03-01 16:07:02","2020-03-01","2","2020-03-01 16:07:02","2","2020-03-01 16:07:02"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:07:02","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":["7612","RENT","\u9810\u7e73\u79df\u91d1",1,1860,"MO","1",1860,"2","2020-03-01 16:07:02","2","2020-03-01 16:07:02"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:07:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1860,0,"7612"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-01 16:07:02","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":[560,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207260","2020-03-01 16:07:02",1860,"2","2020-03-01 16:07:02","2","2020-03-01 16:07:02","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:07:02","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":["7260","DEPOSIT",null,"PAID","2020-03-01 16:07:02",0,"2","2020-03-01 16:07:02","2","2020-03-01 16:07:02"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:07:02","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":["7260","INVOICE","7612","PAID","2020-03-01 16:07:02",1860,"2","2020-03-01 16:07:02","2","2020-03-01 16:07:02"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:30:24","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1182&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":681,"customer_code":"C180681","identity_type":"PERSONAL","identity_id":"K087413(2)","title":"Mr","lastname":"Chung","firstname":"Ka Po","companyname":"","email":"patrickbobofamily@gmail.com","tel":"63336887","address":"3\/F, Siu Fung Hong Building, 239-241 Wing Lok Street, Sheung Wan, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"965.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-02","renew_room_key":"056,05555","renew_remark":"1 month contract. Storage rental paid by PPS on January 31, 2020. Storage deposit transferred from agreement A18-CT206853 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\tU07 2X4X7 $965.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":"8","total_discounted_price":"965.0","deposit":"0","total_retail_price":"965.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:30: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",681,"NEW","A18-CT207285",965,965,0,0,"1","1",965,965,965,"2020-03-01 16:30:25","0",null,null,null,"2020-03-02","2020-04-01","1 month contract. Storage rental paid by PPS on March 1, 2020. Storage deposit transferred from agreement A18-CT207085 to this agreement.\r\n","2020-03-02","8",0,null,0,"0","2","2020-03-01 16:30:24","2","2020-03-01 16:30:24","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"056,05555","C180681","PERSONAL","Mr","WpXUsGIV5ZMagl9ab+XsmA==","ThKwrAIcvgN3JqAg+7\/isg==","","MfbxfJxu6rnCI3QT7TKkp941rf6ZLqXK4FI5VbVzAJiJni8uQnXc2gGJQSsyflI200jM1kVIWfocMiR8ixEVuOtN59H0aUN3N6cpSW\/Zb8g=","uk+aBM1pdnZq7uENadbWLg==","AlXt3dY1\/1B81wXwqLajny8WQO2W1oXWizWY\/cvTtlY=","ikLrZy69X3qkMVAoKWXxnQ==",null,1,"4704"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:30: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":["7285","906","965.0","965.00","2","2020-03-01 16:30:24"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:30: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-03-02","2020-04-01","906"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-01 16:30: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":["7285",681,"SETTLED","A18-I207613","2020-03-01 16:30:24","2020-03-02","2","2020-03-01 16:30:24","2","2020-03-01 16:30:24"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:30: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":["7613","RENT","\u9810\u7e73\u79df\u91d1",1,965,"MO","1",965,"2","2020-03-01 16:30:24","2","2020-03-01 16:30:24"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:30:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[965,0,"7613"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-01 16:30: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":[681,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207261","2020-03-01 16:30:24",965,"2","2020-03-01 16:30:24","2","2020-03-01 16:30:24","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:30: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":["7261","DEPOSIT",null,"PAID","2020-03-01 16:30:24",0,"2","2020-03-01 16:30:24","2","2020-03-01 16:30:24"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:30: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":["7261","INVOICE","7613","PAID","2020-03-01 16:30:24",965,"2","2020-03-01 16:30:24","2","2020-03-01 16:30:24"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:50:13","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=1125&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":717,"customer_code":"C180717","identity_type":"PERSONAL","identity_id":"Y323150(8)","title":"Mr","lastname":"Amerine","firstname":"Julian Steven Anthony","companyname":"","email":"julian.amerine@gmail.com","tel":"97302001","address":"Flat 503, Wah Oi House, Wah Kwai Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1605.0","renew_rent_month":"2","renew_warehousing_date":"2020-02-14","renew_room_key":"055,16508","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 28, 2020. Storage deposit transferred from agreement A18-CT196530 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207049, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"78","order_discount":[],"order_room":[{"room_id":"904","room_code":"U05","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-02-14","rent_from":"2020-02-14","rent_to":"2020-03-13","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on March 1, 2020. Storage deposit transferred from agreement A18-CT207049 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1605,"final_order_total":1605,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,16508","order_product":[],"pass":true}},"first_order_id":"4839","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\tU05 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.00","deposit":"0.00","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:50:14","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",717,"NEW","A18-CT207286",1605,1605,0,0,"1","1",1605,1605,1605,"2020-03-01 16:50:14","0",null,null,null,"2020-02-14","2020-03-13","1 month contract. Storage rental paid by bank transfer on March 1, 2020. Storage deposit transferred from agreement A18-CT207049 to this agreement.\r\n","2020-02-14","20",0,null,0,"0","2","2020-03-01 16:50:13","2","2020-03-01 16:50:13","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,16508","C180717","PERSONAL","Mr","ilVMtNKmhMv6VE7c5KYxeztG+MwYykSvCMt0zdIzHQ8=","jMvdnb6vnm7OQ3LZeY9TvA==","","tbf9qMYQ0X2kmdqBrxFeo3U2\/AVNuE51tDZAfcqBDrxcDLMrKjPy\/OI6UJNDPcMlekQpWPiGcb3Vf3oPzlvW8g==","mgiBsvordu5SgovUygNEdQ==","oplb81J2vLHxZ4GCh7eLLYvnbYcLrPelLzmcVjcZCTA=","o+ttpCoGmWwr+zclHXAYFQ==",null,1,"4839"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:50:14","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":["7286","904","1605.0","1605.00","2","2020-03-01 16:50:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:50:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-14","2020-03-13","904"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-01 16:50:14","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":["7286",717,"SETTLED","A18-I207614","2020-03-01 16:50:13","2020-02-14","2","2020-03-01 16:50:13","2","2020-03-01 16:50:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:50:14","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":["7614","RENT","\u9810\u7e73\u79df\u91d1",1,1605,"MO","1",1605,"2","2020-03-01 16:50:13","2","2020-03-01 16:50:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:50:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1605,0,"7614"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-01 16:50:14","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":[717,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207262","2020-03-01 16:50:13",1605,"2","2020-03-01 16:50:13","2","2020-03-01 16:50:13","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:50:14","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":["7262","DEPOSIT",null,"PAID","2020-03-01 16:50:13",0,"2","2020-03-01 16:50:13","2","2020-03-01 16:50:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 16:50:14","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":["7262","INVOICE","7614","PAID","2020-03-01 16:50:13",1605,"2","2020-03-01 16:50:13","2","2020-03-01 16:50:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 21:29:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 21:30:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-01 21:48:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****