\r\n\t\t\t\t\tM25 4X3X4 $598.00 N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"538.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:15:10","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",853,"NEW","A14-CT207385",598,538,0,0,"6","6",3228,3228,3228,"2020-03-12 10:15:10","0",null,null,null,"2020-03-19","2020-09-18","6 months contract. Storage rental paid by bank transfer on March 11, 2020. Storage deposit transferred from agreement A14-CT196288 to this agreement.","2020-03-19","12",0,null,0,"0","2","2020-03-12 10:15:09","2","2020-03-12 10:15:09","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190,38680","C180853","PERSONAL","Ms","bZZlpTfoZv4jxjnf0a6E0w==","7KCehmxbvwRMb+U8lHGoVA==","","0t8TKhNBx\/Ojv9Z3njXb9tDQTK62h9j4qOW5\/RyaVVhC3z6vtbGQ75zzVnjSTYSvMkZog4iK\/gHlCyudWyLIh+bSf2J8PNeLrR\/h6PFbfHo=","+HAboy5hEtPIjb0yOKs9BA==","GKFHA4\/d\/JSq\/kIXXTjTrJZLNPi5C4e9jYk3f2E4Sns=","JbChnpLj64p1y+J4v\/86zg==",null,1,"3605"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:15:10","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":["7385","614","598.0","598.00","2","2020-03-12 10:15:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:15:10","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-19","2020-09-18","614"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-12 10:15:10","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":["7385",853,"SETTLED","A14-I207713","2020-03-12 10:15:09","2020-03-19","2","2020-03-12 10:15:09","2","2020-03-12 10:15:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:15:10","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":["7713","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-03-12 10:15:09","2","2020-03-12 10:15:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:15:10","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":["7713","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-03-12 10:15:09","2","2020-03-12 10:15:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:15:10","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":["7713","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-03-12 10:15:09","2","2020-03-12 10:15:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:15:10","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":["7713","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-03-12 10:15:09","2","2020-03-12 10:15:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:15:10","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":["7713","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-03-12 10:15:09","2","2020-03-12 10:15:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:15:10","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":["7713","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-03-12 10:15:09","2","2020-03-12 10:15:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:15:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"7713"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-12 10:15:10","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":[853,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207361","2020-03-12 10:15:09",3228,"2","2020-03-12 10:15:09","2","2020-03-12 10:15:09","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:15:10","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":["7361","DEPOSIT",null,"PAID","2020-03-12 10:15:09",0,"2","2020-03-12 10:15:09","2","2020-03-12 10:15:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:15:10","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":["7361","INVOICE","7713","PAID","2020-03-12 10:15:09",3228,"2","2020-03-12 10:15:09","2","2020-03-12 10:15:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:39:58","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":"all=1&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":813,"customer_code":"C180813","identity_type":"PERSONAL","identity_id":"K777408(7)","title":"Ms","lastname":"Lau","firstname":"Sau Han Joey","companyname":"","email":"becca@victoriaasia.com","tel":"63583555","address":"House B7, 5 Mount Kellett Road, The Peak, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2455.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-07","renew_room_key":"055,27494,055, 38332","renew_remark":"6 months contract. Storage rental paid by cheque deposit. Storage deposit $5456 transferred from agreement A18-CT194931 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195812, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"82","order_discount":[],"order_room":[{"room_id":"831","room_code":"R05","retail_price":"2728.0","discounted_price":"2728.00","location_id":"3"}],"roughly_size":"36","total_retail_price":2728,"total_discounted_price":2728,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":5456,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-07","rent_from":"2020-01-07","rent_to":"2020-03-06","delivery_service":"0","remark":"2 months contract. Storage rental paid by cheque deposit on March 12, 2020. Storage deposit $5456 transferred from agreement A18-CT195812 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":5456,"final_order_total":5456,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,27494,055, 38332","order_product":[],"pass":true}},"first_order_id":"4498","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\tR05 6X6X7 $2728.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":"36","total_discounted_price":"2728.00","deposit":"0.00","total_retail_price":"2728.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:39:58","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",813,"NEW","A18-CT207386",2728,2728,0,0,"2","2",5456,5456,5456,"2020-03-12 10:39:58","0",null,null,null,"2020-01-07","2020-03-06","2 months contract. Storage rental paid by cheque deposit on March 12, 2020. Storage deposit $5456 transferred from agreement A18-CT195812 to this agreement.\r\n","2020-01-07","36",0,null,0,"0","2","2020-03-12 10:39:58","2","2020-03-12 10:39:58","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"055,27494,055, 38332","C180813","PERSONAL","Ms","rdHb5jBG8UUOKoMQuzTWOw==","oe4emdjBwqJ3qUpOcI17hw==","","v+SxnZ4QOm7r6RDaE120xLgcB8DU\/73wO2nWmhfbYAX042A0CICGwIT4zlN7KYl1RQguNhWA1t5FTcVzwXOo\/w==","1K9rOQ81Toj3T6e5S5Yxwg==","ubte31Tr0sF1eL7qQ43m8ScE1Zo47Syz8zEeya8RSV0=","sPxzUsM7TPrp596mePETjA==",null,1,"4498"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:39:58","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":["7386","831","2728.0","2728.00","2","2020-03-12 10:39:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:39:58","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-07","2020-03-06","831"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-12 10:39:58","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":["7386",813,"SETTLED","A18-I207714","2020-03-12 10:39:58","2020-01-07","2","2020-03-12 10:39:58","2","2020-03-12 10:39:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:39:58","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":["7714","RENT","\u9810\u7e73\u79df\u91d1",1,2728,"MO","1",2728,"2","2020-03-12 10:39:58","2","2020-03-12 10:39:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:39:58","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":["7714","RENT","\u9810\u7e73\u79df\u91d1",2,2728,"MO","1",2728,"2","2020-03-12 10:39:58","2","2020-03-12 10:39:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:39:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5456,0,"7714"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-12 10:39:58","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":[813,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207362","2020-03-12 10:39:58",5456,"2","2020-03-12 10:39:58","2","2020-03-12 10:39:58","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:39:58","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":["7362","DEPOSIT",null,"PAID","2020-03-12 10:39:58",0,"2","2020-03-12 10:39:58","2","2020-03-12 10:39:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:39:58","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":["7362","INVOICE","7714","PAID","2020-03-12 10:39:58",5456,"2","2020-03-12 10:39:58","2","2020-03-12 10:39:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:42:29","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":"all=1&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":813,"customer_code":"C180813","identity_type":"PERSONAL","identity_id":"K777408(7)","title":"Ms","lastname":"Lau","firstname":"Sau Han Joey","companyname":"","email":"becca@victoriaasia.com","tel":"63583555","address":"House B7, 5 Mount Kellett Road, The Peak, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"5832.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-10","renew_room_key":"055,27494,055, 38332","renew_remark":"6 months contract. Storage rental paid by cheque deposit. Storage deposit transferred from agreement A18-CT194932 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195811, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"89","order_discount":[],"order_room":[{"room_id":"839","room_code":"R13","retail_price":"6800.0","discounted_price":"6800.00","location_id":"3"}],"roughly_size":"85","total_retail_price":6800,"total_discounted_price":6480,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":12960,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-10","rent_from":"2020-01-10","rent_to":"2020-03-09","delivery_service":"0","remark":"2 months contract. Storage rental paid by cheque on March 12, 2020. Storage deposit transferred from agreement A18-CT195811 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":12960,"final_order_total":12960,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,27494,055, 38332","order_product":[],"pass":true}},"first_order_id":"4497","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\tR13 8.5X10X7 $6800.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":"85","total_discounted_price":"6480.00","deposit":"0.00","total_retail_price":"6800.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:42:29","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",813,"NEW","A18-CT207387",6800,6480,0,0,"2","2",12960,12960,12960,"2020-03-12 10:42:29","0",null,null,null,"2020-01-10","2020-03-09","2 months contract. Storage rental paid by cheque on March 12, 2020. Storage deposit transferred from agreement A18-CT195811 to this agreement.","2020-01-10","85",0,null,0,"0","2","2020-03-12 10:42:29","2","2020-03-12 10:42:29","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"055,27494,055, 38332","C180813","PERSONAL","Ms","rdHb5jBG8UUOKoMQuzTWOw==","oe4emdjBwqJ3qUpOcI17hw==","","v+SxnZ4QOm7r6RDaE120xLgcB8DU\/73wO2nWmhfbYAX042A0CICGwIT4zlN7KYl1RQguNhWA1t5FTcVzwXOo\/w==","1K9rOQ81Toj3T6e5S5Yxwg==","ubte31Tr0sF1eL7qQ43m8ScE1Zo47Syz8zEeya8RSV0=","sPxzUsM7TPrp596mePETjA==",null,1,"4497"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:42:29","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":["7387","839","6800.0","6800.00","2","2020-03-12 10:42:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:42:29","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-10","2020-03-09","839"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-12 10:42:29","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":["7387",813,"SETTLED","A18-I207715","2020-03-12 10:42:29","2020-01-10","2","2020-03-12 10:42:29","2","2020-03-12 10:42:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:42:29","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":["7715","RENT","\u9810\u7e73\u79df\u91d1",1,6480,"MO","1",6480,"2","2020-03-12 10:42:29","2","2020-03-12 10:42:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:42:29","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":["7715","RENT","\u9810\u7e73\u79df\u91d1",2,6480,"MO","1",6480,"2","2020-03-12 10:42:29","2","2020-03-12 10:42:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:42:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[12960,0,"7715"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-12 10:42:29","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":[813,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207363","2020-03-12 10:42:29",12960,"2","2020-03-12 10:42:29","2","2020-03-12 10:42:29","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:42:29","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":["7363","DEPOSIT",null,"PAID","2020-03-12 10:42:29",0,"2","2020-03-12 10:42:29","2","2020-03-12 10:42:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 10:42:29","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":["7363","INVOICE","7715","PAID","2020-03-12 10:42:29",12960,"2","2020-03-12 10:42:29","2","2020-03-12 10:42:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 11:46:33","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=813&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1090","master_room_id":"110","room_code":"A05-088"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> \r\n\t\t\t\t\tA05-088 4X2X3.5 $598.00 N\/A <\/td> \u9810\u4ed812\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","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"P802352(6)","title":"Ms","lastname":"WONG","firstname":"Choi Luen","companyname":"","email":"","tel":"61673592","address":"Room 1501, Pik Wai House, Shek Pai Wan Estate, Aberdeen","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1090","room_code":"A05-088","retail_price":"598.0","discounted_price":"598.00","location_id":"4"}],"roughly_size":"8","total_retail_price":598,"total_discounted_price":568,"deposit":1196,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2816,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"84.00","warehousing_date":"2020-04-01","rent_from":"2020-04-01","rent_to":"2020-06-30","delivery_service":"0","remark":"3 months contract. Special offer 5% \"Rent Now\" offer. Storage rental and deposit paid by EPS on March 12, 2020. Smartcard and padlock provided on March 12, 2020.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":84,"order_total":2900,"final_order_total":2816,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0012490500","order_product":[],"pass":true}},"roughly_size":"8","total_discounted_price":"568.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 11:46:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201533","PERSONAL","Ms","JMVWt3CyKrafueEWkwZZIw==","ddrfzAYTmkL\/QNu3psjONQ==","","BYH7+0IhLp4PoWiD8Ejpcw==",null,"WFJCkjdaM2RSrvK1AinG32mDxn2gHEd4HrJuZlFaUWWGDI\/SepIqGC8k0ctE0VZ8zWkOf\/XinZmai5UgLuw8IA==","xPOKOULZUNrHkRmebUEC0A==",null,null,"ZNGhQEYBbCt17Bkik+dwqQ==","2","2020-03-12 11:46:33","2","2020-03-12 11:46:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 11:46:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","4",1533,"NEW","A05-CT207388",598,568,1196,0,"3","3",2816,2900,2816,"2020-03-12 11:46:35","0",null,null,null,"2020-04-01","2020-06-30","3 months contract. Special offer 5% \"Rent Now\" offer. Storage rental and deposit paid by EPS on March 12, 2020. Smartcard and padlock provided on March 12, 2020.","2020-04-01","8",0,null,84,"84.00","2","2020-03-12 11:46:33","2","2020-03-12 11:46:33","EPS","","","","EPS","","","",null,0,"'0012490500","C201533","PERSONAL","Ms","JMVWt3CyKrafueEWkwZZIw==","ddrfzAYTmkL\/QNu3psjONQ==","","WFJCkjdaM2RSrvK1AinG32mDxn2gHEd4HrJuZlFaUWWGDI\/SepIqGC8k0ctE0VZ8zWkOf\/XinZmai5UgLuw8IA==","BYH7+0IhLp4PoWiD8Ejpcw==",null,"xPOKOULZUNrHkRmebUEC0A==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 11:46:35","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":["7388","1090","598.0","598.00","2","2020-03-12 11:46:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 11:46:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-01","2020-06-30","1090"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-12 11:46:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["7388","A05-D205317","PAID",1196,0,"2020-06-30","2020-03-12 11:46:33","2020-03-12 11:46:33","2","2020-03-12 11:46:33","2","2020-03-12 11:46:33",1533]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 11:46:35","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":["7388",1533,"SETTLED","A05-I207716","2020-03-12 11:46:33","2020-04-01","2","2020-03-12 11:46:33","2","2020-03-12 11:46:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 11:46:35","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":["7716","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,484,"MO","1",484,"2","2020-03-12 11:46:33","2","2020-03-12 11:46:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 11:46:35","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":["7716","RENT","\u9810\u7e73\u79df\u91d1",2,568,"MO","1",568,"2","2020-03-12 11:46:33","2","2020-03-12 11:46:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 11:46:35","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":["7716","RENT","\u9810\u7e73\u79df\u91d1",3,568,"MO","1",568,"2","2020-03-12 11:46:33","2","2020-03-12 11:46:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 11:46:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1620,0,"7716"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-12 11:46:35","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":[1533,"EPS","","","","EPS","","","","PAID","P207364","2020-03-12 11:46:33",2816,"2","2020-03-12 11:46:33","2","2020-03-12 11:46:33","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 11:46:35","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":["7364","DEPOSIT","5317","PAID","2020-03-12 11:46:33",1196,"2","2020-03-12 11:46:33","2","2020-03-12 11:46:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 11:46:35","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":["7364","INVOICE","7716","PAID","2020-03-12 11:46:33",1620,"2","2020-03-12 11:46:33","2","2020-03-12 11:46:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 12:10:26","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=813&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","floor_plan_rent_room":[{"room_id":"1090","master_room_id":"110","room_code":"A05-088"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":56,"customer_code":"C160056","identity_type":"PERSONAL","identity_id":"D363039(1)","title":"Ms","lastname":"Cheng","firstname":"Siu Wah","companyname":"","email":null,"tel":"93023823","address":"Flat H,20\/F,Block 8,South Horizons,Apleichau,HK","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3724.0","renew_rent_month":"6","renew_warehousing_date":"2020-03-01","renew_room_key":"137,10172","renew_remark":"6 months contract. Storage rental paid by EPS on August 31, 2019. Storage deposit transferred from agreement A12-CT194432 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195842, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[{"master_room_discount_id":"469","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"949.00","discount":"4.91","monthly_deduct":49.0018,"room_id":"316","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"469","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"949.00","discount":"4.91","monthly_deduct":49.0018,"room_id":"317","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"433","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"327","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"433","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"328","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"328","room_code":"F13","retail_price":"1098.0","discounted_price":1043.4,"location_id":"1"},{"room_id":"327","room_code":"F12","retail_price":"1098.0","discounted_price":1043.4,"location_id":"1"},{"room_id":"317","room_code":"F02","retail_price":"998.0","discounted_price":949,"location_id":"1"},{"room_id":"316","room_code":"F01","retail_price":"998.0","discounted_price":949,"location_id":"1"}],"roughly_size":"56","total_retail_price":4192,"total_discounted_price":3931,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":11793,"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-05-31","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on March 11, 2020. Storage deposit transferred from agreement A12-CT195842 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":11793,"final_order_total":11793,"location_id":"1","branch_id":"1","company_id":"1","room_key":"137,10172","order_product":[],"pass":true}},"first_order_id":"4432","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\tF13 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\tF12 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\tF02 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\tF01 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":"56","total_discounted_price":"3931.00","deposit":"0.00","total_retail_price":"4192.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 12:10:27","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",56,"NEW","A12-CT207389",4192,3931,0,0,"3","3",11793,11793,11793,"2020-03-12 12:10:27","0",null,null,null,"2020-03-01","2020-05-31","3 months contract. Storage rental paid by bank transfer on March 11, 2020. Storage deposit transferred from agreement A12-CT195842 to this agreement.\r\n","2020-03-01","56",0,null,0,"0","2","2020-03-12 12:10:26","2","2020-03-12 12:10:26","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"137,10172","C160056","PERSONAL","Ms","3JNLQh67h8IOVnWCv04Dcw==","UCPBCXrBLI9U7KKsPqgmNA==","","c\/qlJ3I9OCovfWTKMrcB7t6M1c7nu6l4g1e0X7WRU7KOMQQnbhPCZfXz1v8EeDB\/","5c7Zu7RDH\/sQT4o2hvLHLw==",null,"2dJIVFsAxuVxnHgf9sYNKg==",null,1,"4432"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 12:10:27","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":["7389","469","6","316","%","4.91",49.0018,"2","2020-03-12 12:10:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 12:10:27","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":["7389","469","6","317","%","4.91",49.0018,"2","2020-03-12 12:10:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 12:10:27","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":["7389","433","8","327","%","4.97",54.5706,"2","2020-03-12 12:10:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 12:10:27","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":["7389","433","8","328","%","4.97",54.5706,"2","2020-03-12 12:10:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 12:10:27","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":["7389","328","1098.0",1043.4,"2","2020-03-12 12:10:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 12:10:27","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-05-31","328"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-12 12:10:27","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":["7389","327","1098.0",1043.4,"2","2020-03-12 12:10:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 12:10:27","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-05-31","327"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-12 12:10:27","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":["7389","317","998.0",949,"2","2020-03-12 12:10:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 12:10:27","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-05-31","317"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-12 12:10:27","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":["7389","316","998.0",949,"2","2020-03-12 12:10:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 12:10:27","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-05-31","316"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-12 12:10:27","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":["7389",56,"SETTLED","A12-I207717","2020-03-12 12:10:26","2020-03-01","2","2020-03-12 12:10:26","2","2020-03-12 12:10:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 12:10:27","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":["7717","RENT","\u9810\u7e73\u79df\u91d1",1,3931,"MO","1",3931,"2","2020-03-12 12:10:26","2","2020-03-12 12:10:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 12:10:27","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":["7717","RENT","\u9810\u7e73\u79df\u91d1",2,3931,"MO","1",3931,"2","2020-03-12 12:10:26","2","2020-03-12 12:10:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 12:10:27","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":["7717","RENT","\u9810\u7e73\u79df\u91d1",3,3931,"MO","1",3931,"2","2020-03-12 12:10:26","2","2020-03-12 12:10:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 12:10:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11793,0,"7717"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-12 12:10:27","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":[56,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207365","2020-03-12 12:10:26",11793,"2","2020-03-12 12:10:26","2","2020-03-12 12:10:26","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 12:10:27","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":["7365","DEPOSIT",null,"PAID","2020-03-12 12:10:26",0,"2","2020-03-12 12:10:26","2","2020-03-12 12:10:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 12:10:27","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":["7365","INVOICE","7717","PAID","2020-03-12 12:10:26",11793,"2","2020-03-12 12:10:26","2","2020-03-12 12:10:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 12:13:09","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":1191,"customer_code":"C191191","identity_type":"PERSONAL","identity_id":"M738692(9)","title":"Mr","lastname":"MAI","firstname":"Bosco Khoi","companyname":"","email":"bosco.mai@gmail.com","tel":"67614440","address":"Block A, Flat 15, Wah Lee Building, Tsung Man St. Aberdeen","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1098.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-01","renew_room_key":"089,00345","renew_remark":"1 month contract. Storage rental paid by bank transfer on February 8, 2020. Storage deposit transferred from agreement A12-CT196777 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207148, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"5","room_code":"A05","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1098,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1098,"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 Mar 10, 2020. Storage deposit transferred from agreement A12-CT207148 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1098,"final_order_total":1098,"location_id":"1","branch_id":"1","company_id":"1","room_key":"089,00345","order_product":[],"pass":true}},"first_order_id":"4686","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 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":"16","total_discounted_price":"1098.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 12:13:10","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",1191,"NEW","A12-CT207390",1098,1098,0,0,"1","1",1098,1098,1098,"2020-03-12 12:13:10","0",null,null,null,"2020-03-01","2020-03-31","1 month contract. Storage rental paid by bank transfer on Mar 10, 2020. Storage deposit transferred from agreement A12-CT207148 to this agreement.","2020-03-01","16",0,null,0,"0","2","2020-03-12 12:13:09","2","2020-03-12 12:13:09","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"089,00345","C191191","PERSONAL","Mr","0soiKCD7NjJcZw48G3GvfA==","MvdRz7N0iNyy9YO2DdpHMA==","","NcpK5OrfF8\/ElyhXm5yH2xQ9zY+h9560LUlyXGmaKZfQ1gIMmhqC+OiOd\/MDfL7LWoyplf\/sWugxqiR3ggITpg==","1y6MGBuYIscSst\/RcREtDQ==","xaZ\/yoblidF8zejY4KpifA94CHlEn27CqR\/97lOoGjk=","wcyFUD6Pm8bwB7ut4Ratqg==",null,1,"4686"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 12:13:10","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":["7390","5","1098.0","1098.00","2","2020-03-12 12:13:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 12:13:10","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","5"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-12 12:13:10","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":["7390",1191,"SETTLED","A12-I207718","2020-03-12 12:13:09","2020-03-01","2","2020-03-12 12:13:09","2","2020-03-12 12:13:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 12:13:10","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":["7718","RENT","\u9810\u7e73\u79df\u91d1",1,1098,"MO","1",1098,"2","2020-03-12 12:13:09","2","2020-03-12 12:13:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 12:13:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1098,0,"7718"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-12 12:13:10","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":[1191,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207366","2020-03-12 12:13:09",1098,"2","2020-03-12 12:13:09","2","2020-03-12 12:13:09","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 12:13:10","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":["7366","DEPOSIT",null,"PAID","2020-03-12 12:13:09",0,"2","2020-03-12 12:13:09","2","2020-03-12 12:13:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 12:13:10","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":["7366","INVOICE","7718","PAID","2020-03-12 12:13:09",1098,"2","2020-03-12 12:13:09","2","2020-03-12 12:13:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 12:29:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 18:20:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 19:05:31","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":"all=1","floor_plan_rent_room":[{"room_id":"1090","master_room_id":"110","room_code":"A05-088"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":741,"customer_code":"C180741","identity_type":"PERSONAL","identity_id":"Z622893(4)","title":"Ms","lastname":"Cheung","firstname":"Yuk Ling","companyname":"","email":"tanyacheung.designer2016@gmail.com","tel":"96363298","address":"Flat F, 19\/F, Coble Court, 129 Main Street, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1162.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-29","renew_room_key":"055,40308","renew_remark":"6 months contract. Storage rental paid by bank transfer on August 3, 2019. Storage deposit transferred from agreement A18-CT194638 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195636, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"947","room_code":"V21","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":2580,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-29","rent_from":"2020-01-29","rent_to":"2020-03-28","delivery_service":"0","remark":"2 months contract. Storage rental paid by bank transfer on March 12, 2020. Storage deposit transferred from agreement A18-CT195636 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2580,"final_order_total":2580,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,40308","order_product":[],"pass":true}},"first_order_id":"4638","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\tV21 4X4X7 $1290.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1290.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 19:05: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","3",741,"NEW","A18-CT207391",1290,1290,0,0,"2","2",2580,2580,2580,"2020-03-12 19:05:31","0",null,null,null,"2020-01-29","2020-03-28","2 months contract. Storage rental paid by bank transfer on March 12, 2020. Storage deposit transferred from agreement A18-CT195636 to this agreement.","2020-01-29","16",0,null,0,"0","2","2020-03-12 19:05:31","2","2020-03-12 19:05:31","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,40308","C180741","PERSONAL","Ms","ZzRtsket6p7WIKEqrfiAQw==","vCxOlXQuvOQaoL822H2o\/Q==","","yDYdX75kPKR4h\/gYs3BYJcJobIZypCc6KDWaulXh9iC7\/8poXjgUbAlck\/ycmA1gcP\/UhsJZyApxazyvlJtyCBK2\/uqGCn9LbAHsuK91+GA=","Na16j9m2d0V89RhVftbEpQ==","plAC52phWS0ywiVvxgdktlSZxJNjClLZggqIQskk\/F01jxqEL1gr\/cVBokSBHyue","+DpQJBg1w6vmawvzQNj5JA==",null,1,"4638"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 19:05: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":["7391","947","1290.0","1290.00","2","2020-03-12 19:05:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 19:05: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-01-29","2020-03-28","947"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-12 19:05:31","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":["7391",741,"SETTLED","A18-I207719","2020-03-12 19:05:31","2020-01-29","2","2020-03-12 19:05:31","2","2020-03-12 19:05:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 19:05:31","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":["7719","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-03-12 19:05:31","2","2020-03-12 19:05:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 19:05:31","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":["7719","RENT","\u9810\u7e73\u79df\u91d1",2,1290,"MO","1",1290,"2","2020-03-12 19:05:31","2","2020-03-12 19:05:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 19:05:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2580,0,"7719"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-12 19:05:31","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":[741,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207367","2020-03-12 19:05:31",2580,"2","2020-03-12 19:05:31","2","2020-03-12 19:05:31","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 19:05:31","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":["7367","DEPOSIT",null,"PAID","2020-03-12 19:05:31",0,"2","2020-03-12 19:05:31","2","2020-03-12 19:05:31"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-12 19:05:31","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":["7367","INVOICE","7719","PAID","2020-03-12 19:05:31",2580,"2","2020-03-12 19:05:31","2","2020-03-12 19:05:31"]},"data_before":[],"data_after":[],"step":1}
*****