\r\n\t\t\t\t\tD33 4X3X8 $998.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"899.00","deposit":"0.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:10:04","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",1368,"NEW","A12-CT207195",998,899,0,0,"13","13",10788,11687,10788,"2020-02-15 12:10:04","0",null,null,null,"2020-03-01","2021-03-31","12 months contract. Special Offer the 13th month free. Storage rental paid by EPS on February 14, 2020. Storage deposit $1996 transferred from agreement A12-CT195733 to this agreement. ","2020-03-01","12",0,null,899,"899.00","2","2020-02-15 12:10:03","2","2020-02-15 12:10:03","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"189,51764","C191368","PERSONAL","Ms","UAnQqB5xPx86pKWsweyq1Q==","0JxYUqbNPOvgfMwVa0l0NA==","","ahjARwdHhrLKtccjVhQqYj\/5AHBWcLnUDTK2W8HIhS0VJZaic4CKN0dD9xVkgpkzAmKuwHCyk5pOFCaXjFiZwg==","ZGj5kOD+ZaXEQtPjY\/NU1A==","Fp5qb0MzdwaCRTuhn0M967POaRscpJwHv9Pbyt\/w180=","SZ8ShP8qiWsLpxDH\/ApfPQ==",null,1,5733]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:10:04","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":["7195","229","998.0","998.00","2","2020-02-15 12:10:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:10:04","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","2021-03-31","229"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-02-15 12:10:04","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":["7195",1368,"SETTLED","A12-I207523","2020-02-15 12:10:03","2020-03-01","2","2020-02-15 12:10:03","2","2020-02-15 12:10:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:10:04","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":["7523","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,899,"MO","1",899,"2","2020-02-15 12:10:03","2","2020-02-15 12:10:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:10:04","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":["7523","RENT","\u9810\u7e73\u79df\u91d1",3,899,"MO","1",899,"2","2020-02-15 12:10:03","2","2020-02-15 12:10:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:10:04","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":["7523","RENT","\u9810\u7e73\u79df\u91d1",4,899,"MO","1",899,"2","2020-02-15 12:10:03","2","2020-02-15 12:10:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:10:04","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":["7523","RENT","\u9810\u7e73\u79df\u91d1",5,899,"MO","1",899,"2","2020-02-15 12:10:03","2","2020-02-15 12:10:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:10:04","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":["7523","RENT","\u9810\u7e73\u79df\u91d1",6,899,"MO","1",899,"2","2020-02-15 12:10:03","2","2020-02-15 12:10:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:10:04","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":["7523","RENT","\u9810\u7e73\u79df\u91d1",7,899,"MO","1",899,"2","2020-02-15 12:10:03","2","2020-02-15 12:10:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:10:04","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":["7523","RENT","\u9810\u7e73\u79df\u91d1",8,899,"MO","1",899,"2","2020-02-15 12:10:03","2","2020-02-15 12:10:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:10:04","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":["7523","RENT","\u9810\u7e73\u79df\u91d1",9,899,"MO","1",899,"2","2020-02-15 12:10:03","2","2020-02-15 12:10:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:10:04","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":["7523","RENT","\u9810\u7e73\u79df\u91d1",10,899,"MO","1",899,"2","2020-02-15 12:10:03","2","2020-02-15 12:10:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:10:04","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":["7523","RENT","\u9810\u7e73\u79df\u91d1",11,899,"MO","1",899,"2","2020-02-15 12:10:03","2","2020-02-15 12:10:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:10:04","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":["7523","RENT","\u9810\u7e73\u79df\u91d1",12,899,"MO","1",899,"2","2020-02-15 12:10:03","2","2020-02-15 12:10:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:10:04","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":["7523","RENT","\u9810\u7e73\u79df\u91d1",13,899,"MO","1",899,"2","2020-02-15 12:10:03","2","2020-02-15 12:10:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:10:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10788,0,"7523"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-02-15 12:10:04","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":[1368,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207171","2020-02-15 12:10:03",10788,"2","2020-02-15 12:10:03","2","2020-02-15 12:10:03","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:10:04","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":["7171","DEPOSIT",null,"PAID","2020-02-15 12:10:03",0,"2","2020-02-15 12:10:03","2","2020-02-15 12:10:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:10:04","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":["7171","INVOICE","7523","PAID","2020-02-15 12:10:03",10788,"2","2020-02-15 12:10:03","2","2020-02-15 12:10:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:26:06","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1203,"customer_code":"C191203","identity_type":"PERSONAL","identity_id":"D122203(2)","title":"Ms","lastname":"MUI","firstname":"Miu Chu","companyname":"","email":null,"tel":"91472812","address":"\u9999\u6e2f\u4ed4\u820a\u5927\u885764-70\u865f\u6d77\u6d0b\u5927\u5ec88\/F D\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"981.0","renew_rent_month":"6","renew_warehousing_date":"2020-02-19","renew_room_key":"0006046764","renew_remark":"6 months contract. Storage rental paid by bank transfer on Aug 14, 2019. Deposit $2180 transferred from A05-CT194387 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT195716, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"113","order_discount":[{"master_room_discount_id":"245","master_room_id":"113","discount_type":"%","price":"1090.00","disocunted_price":"981.00","discount":"10.00","monthly_deduct":109,"room_id":"1046","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1046","room_code":"A05-044","retail_price":"1090.0","discounted_price":981,"location_id":"4"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":981,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5886,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-19","rent_from":"2020-02-19","rent_to":"2020-08-18","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on February 15, 2020. Deposit $2180 transferred from A05-CT195716 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5886,"final_order_total":5886,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0006046764","order_product":[],"pass":true}},"first_order_id":"4387","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-044 4X3X7 $1090.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"981.0","deposit":"0","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:26:06","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",1203,"NEW","A05-CT207196",1090,981,0,0,"6","6",5886,5886,5886,"2020-02-15 12:26:06","0",null,null,null,"2020-02-19","2020-08-18","6 months contract. Storage rental paid by bank transfer on February 15, 2020. Deposit $2180 transferred from A05-CT195716 to this agreement.\r\n","2020-02-19","12",0,null,0,"0","2","2020-02-15 12:26:06","2","2020-02-15 12:26:06","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0006046764","C191203","PERSONAL","Ms","lnMWSxIJ\/TwB3hUcKtnQNw==","IgQlq8MS7boHKFNXljEZbQ==","","+97LJ6GdzfH7z6EWZQAAnKlqL4SbWvHALdbCFamFcpHOCOexp5HxSMs3CCbXZL7j","RX4\/Aa4i8j4OqeZbH\/SKAQ==",null,"0lSs5TdZCWPnoYSDC3znSA==",null,1,"4387"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:26:06","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":["7196","245","113","1046","%","10.00",109,"2","2020-02-15 12:26:06"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:26:06","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":["7196","1046","1090.0",981,"2","2020-02-15 12:26:06"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:26:06","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-19","2020-08-18","1046"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-02-15 12:26:06","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":["7196",1203,"SETTLED","A05-I207524","2020-02-15 12:26:06","2020-02-19","2","2020-02-15 12:26:06","2","2020-02-15 12:26:06"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:26:06","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":["7524","RENT","\u9810\u7e73\u79df\u91d1",1,981,"MO","1",981,"2","2020-02-15 12:26:06","2","2020-02-15 12:26:06"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:26:06","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":["7524","RENT","\u9810\u7e73\u79df\u91d1",2,981,"MO","1",981,"2","2020-02-15 12:26:06","2","2020-02-15 12:26:06"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:26:06","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":["7524","RENT","\u9810\u7e73\u79df\u91d1",3,981,"MO","1",981,"2","2020-02-15 12:26:06","2","2020-02-15 12:26:06"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:26:06","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":["7524","RENT","\u9810\u7e73\u79df\u91d1",4,981,"MO","1",981,"2","2020-02-15 12:26:06","2","2020-02-15 12:26:06"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:26:06","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":["7524","RENT","\u9810\u7e73\u79df\u91d1",5,981,"MO","1",981,"2","2020-02-15 12:26:06","2","2020-02-15 12:26:06"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:26:06","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":["7524","RENT","\u9810\u7e73\u79df\u91d1",6,981,"MO","1",981,"2","2020-02-15 12:26:06","2","2020-02-15 12:26:06"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:26:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5886,0,"7524"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-02-15 12:26:06","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":[1203,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207172","2020-02-15 12:26:06",5886,"2","2020-02-15 12:26:06","2","2020-02-15 12:26:06","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:26:06","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":["7172","DEPOSIT",null,"PAID","2020-02-15 12:26:06",0,"2","2020-02-15 12:26:06","2","2020-02-15 12:26:06"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:26:06","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":["7172","INVOICE","7524","PAID","2020-02-15 12:26:06",5886,"2","2020-02-15 12:26:06","2","2020-02-15 12:26:06"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:31:01","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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":148,"customer_code":"C160148","identity_type":"PERSONAL","identity_id":"K496262(1)","title":"Ms","lastname":"Kwok","firstname":"Fung Lin","companyname":"","email":"naomikfl@gmail.com","tel":"98608122","address":"Flat A6,5\/F, Abba House,225 Aberdeen Main Road,Aberdeen,HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"899.0","renew_rent_month":"6","renew_warehousing_date":"2020-02-20","renew_room_key":"054,11178","renew_remark":"6 month contract. Storage rental paid by bank transfer on August 16, 2019. Storage deposit transferred from agreement A12-CT194394 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195754, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[{"master_room_discount_id":"70","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"898.60","discount":"9.96","monthly_deduct":99.4008,"room_id":"226","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"226","room_code":"D30","retail_price":"998.0","discounted_price":898.6,"location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":899,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5394,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-20","rent_from":"2020-02-20","rent_to":"2020-08-19","delivery_service":"0","remark":"6 month contract. Storage rental paid by bank transfer on February 14, 2020. Storage deposit transferred from agreement A12-CT195754 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5394,"final_order_total":5394,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,11178","order_product":[],"pass":true}},"first_order_id":"4394","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\tD30 4X3X8 $998.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"899.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:31:01","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",148,"NEW","A12-CT207197",998,899,0,0,"6","6",5394,5394,5394,"2020-02-15 12:31:01","0",null,null,null,"2020-02-20","2020-08-19","6 month contract. Storage rental paid by bank transfer on February 14, 2020. Storage deposit transferred from agreement A12-CT195754 to this agreement.\r\n","2020-02-20","12",0,null,0,"0","2","2020-02-15 12:31:01","2","2020-02-15 12:31:01","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,11178","C160148","PERSONAL","Ms","Rp\/lVdvXjUr497BcMcmlRQ==","+pNULpsInm3siHASV0hIrg==","","QaqrVhQ9SAL1lppF9AnmsXtunZ1F1BrnIz3eKFAp+dlMu8aGy0Sx7vjU4LApkteBBjweLwSREE66oUVy9Slt5g==","ZmLpDe4lneio5w14G9ZV0Q==","ErSGISn76Pj485BGDi3blCSg4+wxcs5f9HOvxOSBuqY=","SRf99W1EHjmQZGWdOU4fnA==",null,1,"4394"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:31:01","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":["7197","70","6","226","%","9.96",99.4008,"2","2020-02-15 12:31:01"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:31:01","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":["7197","226","998.0",898.6,"2","2020-02-15 12:31:01"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:31:01","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-20","2020-08-19","226"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-02-15 12:31:01","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":["7197",148,"SETTLED","A12-I207525","2020-02-15 12:31:01","2020-02-20","2","2020-02-15 12:31:01","2","2020-02-15 12:31:01"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:31:01","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":["7525","RENT","\u9810\u7e73\u79df\u91d1",1,899,"MO","1",899,"2","2020-02-15 12:31:01","2","2020-02-15 12:31:01"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:31:01","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":["7525","RENT","\u9810\u7e73\u79df\u91d1",2,899,"MO","1",899,"2","2020-02-15 12:31:01","2","2020-02-15 12:31:01"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:31:01","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":["7525","RENT","\u9810\u7e73\u79df\u91d1",3,899,"MO","1",899,"2","2020-02-15 12:31:01","2","2020-02-15 12:31:01"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:31:01","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":["7525","RENT","\u9810\u7e73\u79df\u91d1",4,899,"MO","1",899,"2","2020-02-15 12:31:01","2","2020-02-15 12:31:01"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:31:01","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":["7525","RENT","\u9810\u7e73\u79df\u91d1",5,899,"MO","1",899,"2","2020-02-15 12:31:01","2","2020-02-15 12:31:01"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:31:01","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":["7525","RENT","\u9810\u7e73\u79df\u91d1",6,899,"MO","1",899,"2","2020-02-15 12:31:01","2","2020-02-15 12:31:01"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:31:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5394,0,"7525"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-02-15 12:31:01","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":[148,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207173","2020-02-15 12:31:01",5394,"2","2020-02-15 12:31:01","2","2020-02-15 12:31:01","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:31:01","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":["7173","DEPOSIT",null,"PAID","2020-02-15 12:31:01",0,"2","2020-02-15 12:31:01","2","2020-02-15 12:31:01"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 12:31:01","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":["7173","INVOICE","7525","PAID","2020-02-15 12:31:01",5394,"2","2020-02-15 12:31:01","2","2020-02-15 12:31:01"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 14:15:33","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":235,"customer_code":"C160235","identity_type":"BUSINESS","identity_id":"G509092(9)","title":"Mr","lastname":"Lam","firstname":"Chun Ming Gordon","companyname":"Vive Group Limited","email":"gordon@vivegroup.net","tel":"93273388","address":"Suite 1203,12\/F, Shanghai Industrial Investment Building,60 Hennessy Road, Wanchai, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3478.0","renew_rent_month":"6","renew_warehousing_date":"2020-03-01","renew_room_key":"055,46759","renew_remark":"6 months contract. Storage rental paid by bank transfer on August 31, 2019. Storage deposit transferred from agreement A12-CT194528 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195848, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"196","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"195","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"184","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"185","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"196","room_code":"C72","retail_price":"1098.0","discounted_price":989,"location_id":"1"},{"room_id":"195","room_code":"C71","retail_price":"1098.0","discounted_price":989,"location_id":"1"},{"room_id":"185","room_code":"C61","retail_price":"1098.0","discounted_price":989,"location_id":"1"},{"room_id":"184","room_code":"C60","retail_price":"1098.0","discounted_price":989,"location_id":"1"}],"roughly_size":"64","total_retail_price":4392,"total_discounted_price":3478,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":20868,"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-08-31","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on February 15, 2020. Storage deposit transferred from agreement A12-CT195848 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":20868,"final_order_total":20868,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,46759","order_product":[],"pass":true}},"first_order_id":"4528","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\tC72 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\tC71 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\tC61 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\tC60 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\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"64","total_discounted_price":"3478.0","deposit":"0","total_retail_price":"4392.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 14:15: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","1",235,"NEW","A12-CT207198",4392,3478,0,0,"6","6",20868,20868,20868,"2020-02-15 14:15:34","0",null,null,null,"2020-03-01","2020-08-31","6 months contract. Storage rental paid by bank transfer on February 15, 2020. Storage deposit transferred from agreement A12-CT195848 to this agreement.","2020-03-01","64",0,null,0,"0","2","2020-02-15 14:15:33","2","2020-02-15 14:15:33","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,46759","C160235","BUSINESS","Mr","CWG2IqQYFGfKnRVGZl7TKaAXe9HudlzWqrodjU5xl0g=","0JxYUqbNPOvgfMwVa0l0NA==","Vive Group Limited","dYWikRr5QLoLtj1qpnL7n6sjxWTPShomNVcQ81xSzJeRdWV4zFMDGK2Gj0IZq2Y4HEXDTIkQc3cFnwwsLmiEDZkl4BBFwgJl4m4Gqdqd3H1mUDkJUzIjbzFiE2ipMD4q","4P1Ad4Z8s2+SqXm+IY\/KcQ==","02Z0l+7mEDkkk5M\/W+je6rXVXtvRBEk4xV+eH3xzb8w=",null,"lKyie8BvG2\/5++D\/nPLJ8g==",1,"4528"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 14:15:34","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":["7198","72","8","196","%","9.93",109.0314,"2","2020-02-15 14:15:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 14:15:34","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":["7198","72","8","195","%","9.93",109.0314,"2","2020-02-15 14:15:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 14:15:34","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":["7198","72","8","184","%","9.93",109.0314,"2","2020-02-15 14:15:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 14:15:34","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":["7198","72","8","185","%","9.93",109.0314,"2","2020-02-15 14:15:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 14:15: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":["7198","196","1098.0",989,"2","2020-02-15 14:15:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 14:15: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-03-01","2020-08-31","196"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-02-15 14:15: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":["7198","195","1098.0",989,"2","2020-02-15 14:15:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 14:15: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-03-01","2020-08-31","195"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-02-15 14:15: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":["7198","185","1098.0",989,"2","2020-02-15 14:15:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 14:15: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-03-01","2020-08-31","185"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-02-15 14:15: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":["7198","184","1098.0",989,"2","2020-02-15 14:15:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 14:15: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-03-01","2020-08-31","184"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-02-15 14:15: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":["7198",235,"SETTLED","A12-I207526","2020-02-15 14:15:33","2020-03-01","2","2020-02-15 14:15:33","2","2020-02-15 14:15:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 14:15: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":["7526","RENT","\u9810\u7e73\u79df\u91d1",1,3478,"MO","1",3478,"2","2020-02-15 14:15:33","2","2020-02-15 14:15:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 14:15: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":["7526","RENT","\u9810\u7e73\u79df\u91d1",2,3478,"MO","1",3478,"2","2020-02-15 14:15:33","2","2020-02-15 14:15:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 14:15: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":["7526","RENT","\u9810\u7e73\u79df\u91d1",3,3478,"MO","1",3478,"2","2020-02-15 14:15:33","2","2020-02-15 14:15:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 14:15: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":["7526","RENT","\u9810\u7e73\u79df\u91d1",4,3478,"MO","1",3478,"2","2020-02-15 14:15:33","2","2020-02-15 14:15:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 14:15: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":["7526","RENT","\u9810\u7e73\u79df\u91d1",5,3478,"MO","1",3478,"2","2020-02-15 14:15:33","2","2020-02-15 14:15:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 14:15: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":["7526","RENT","\u9810\u7e73\u79df\u91d1",6,3478,"MO","1",3478,"2","2020-02-15 14:15:33","2","2020-02-15 14:15:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 14:15:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[20868,0,"7526"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-02-15 14:15: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":[235,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207174","2020-02-15 14:15:33",20868,"2","2020-02-15 14:15:33","2","2020-02-15 14:15:33","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 14:15: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":["7174","DEPOSIT",null,"PAID","2020-02-15 14:15:33",0,"2","2020-02-15 14:15:33","2","2020-02-15 14:15:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-02-15 14:15: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":["7174","INVOICE","7526","PAID","2020-02-15 14:15:33",20868,"2","2020-02-15 14:15:33","2","2020-02-15 14:15:33"]},"data_before":[],"data_after":[],"step":1}
*****