\r\n\t\t\t\t\tM40 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":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 10:25:49","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",1320,"NEW","A14-CT207557",598,598,0,0,"1","1",598,598,598,"2020-04-03 10:25:49","0",null,null,null,"2020-04-04","2020-05-03","1 month contract. Storage rental paid by bank transfer on April 2, 2020. Storage deposit transferred from agreement A14-CT207303 to this agreement.","2020-04-04","12",0,null,0,"0","2","2020-04-03 10:25:48","2","2020-04-03 10:25:48","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,47738","C191320","PERSONAL","Ms","JgAavgpIkIT+QrZDjc3BRA==","iFBOFA5ozF+SaoxW1fJyqg==","","nS2AiTTeQuxhPG679Pwsq8kB6U8sV32RDbPuHYq7+uZFSa7VZrGSkrkHoVfookObAopb4zx1arlGt2IOtgLjog==","zL50AC1II2U4KbzngrxU9w==","LPBlaIsAU5KUY5TZ0ddhbjaTC47xq2aEL17KEpHG6hM=","EknxojvrXMxgxEofwXXtVQ==",null,1,"5394"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 10:25:49","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":["7557","629","598.0","598.00","2","2020-04-03 10:25:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 10:25:49","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-04","2020-05-03","629"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-03 10:25:49","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":["7557",1320,"SETTLED","A14-I207885","2020-04-03 10:25:48","2020-04-04","2","2020-04-03 10:25:48","2","2020-04-03 10:25:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 10:25:49","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":["7885","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-04-03 10:25:48","2","2020-04-03 10:25:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 10:25:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7885"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-04-03 10:25:49","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":[1320,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207532","2020-04-03 10:25:48",598,"2","2020-04-03 10:25:48","2","2020-04-03 10:25:48","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 10:25:49","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":["7532","DEPOSIT",null,"PAID","2020-04-03 10:25:48",0,"2","2020-04-03 10:25:48","2","2020-04-03 10:25:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 10:25:49","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":["7532","INVOICE","7885","PAID","2020-04-03 10:25:48",598,"2","2020-04-03 10:25:48","2","2020-04-03 10:25:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 10:53:32","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","floor_plan_rent_room":[{"room_id":"1165","master_room_id":"123","room_code":"A05-163"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":690,"customer_code":"C180690","identity_type":"PERSONAL","identity_id":"D705175(2)","title":"Mr","lastname":"Won","firstname":"Siu Fai","companyname":"","email":"cwsfz01@ha.org.hk","tel":"91225716","address":"Room 511, Wah Mei House, Wah Fu Estate, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1226.0","renew_rent_month":"3","renew_warehousing_date":"2020-04-06","renew_room_key":"134,25576","renew_remark":"3 months contract. Storage rental paid by bank transfer on January 4, 2020. Storage deposit transferred from agreement A18-CT196081 to this agreement.\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> \r\n\t\t\t\t\tW03 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":"1226.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 10:53:32","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",690,"NEW","A18-CT207558",1290,1226,0,0,"3","3",3678,3678,3678,"2020-04-03 10:53:32","0",null,null,null,"2020-04-06","2020-07-05","3 months contract. Storage rental paid by bank transfer on April 2, 2020. Storage deposit transferred from agreement A18-CT206859 to this agreement.\r\n","2020-04-06","16",0,null,0,"0","2","2020-04-03 10:53:32","2","2020-04-03 10:53:32","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"134,25576","C180690","PERSONAL","Mr","oMVGeCm8WBCR2o0n0feOIA==","qpk4ojzePwRudjj9aJKrXw==","","7xSGioytLcEU12Rk9BKOgR87yALsOrFitCmjogNY1TKJKAMhVU7acUwfpCUyoZsBFOpPFSijnS1N8IN8ErkAag==","RWNAm\/lx9kQBOf03gYh1\/g==","i6mloX6eyZE8uEg94TGtWDRJeSKUjYDwskVYR7fURWo=","1e3Wb4gTw9zwpSjLHWvFbg==",null,1,"4695"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 10:53:32","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":["7558","248","91","958","%","4.97",64.113,"2","2020-04-03 10:53:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 10:53:32","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":["7558","958","1290.0",1225.9,"2","2020-04-03 10:53:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 10:53:32","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-06","2020-07-05","958"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-03 10:53:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7558",690,"SETTLED","A18-I207886","2020-04-03 10:53:32","2020-04-06","2","2020-04-03 10:53:32","2","2020-04-03 10:53:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 10:53:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7886","RENT","\u9810\u7e73\u79df\u91d1",1,1226,"MO","1",1226,"2","2020-04-03 10:53:32","2","2020-04-03 10:53:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 10:53:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7886","RENT","\u9810\u7e73\u79df\u91d1",2,1226,"MO","1",1226,"2","2020-04-03 10:53:32","2","2020-04-03 10:53:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 10:53:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7886","RENT","\u9810\u7e73\u79df\u91d1",3,1226,"MO","1",1226,"2","2020-04-03 10:53:32","2","2020-04-03 10:53:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 10:53:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3678,0,"7886"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-04-03 10:53:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[690,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207533","2020-04-03 10:53:32",3678,"2","2020-04-03 10:53:32","2","2020-04-03 10:53:32","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 10:53:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7533","DEPOSIT",null,"PAID","2020-04-03 10:53:32",0,"2","2020-04-03 10:53:32","2","2020-04-03 10:53:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 10:53:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7533","INVOICE","7886","PAID","2020-04-03 10:53:32",3678,"2","2020-04-03 10:53:32","2","2020-04-03 10:53:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 11:01:19","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1165","master_room_id":"123","room_code":"A05-163"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":429,"customer_code":"C170429","identity_type":"PERSONAL","identity_id":"D701200(A)","title":"Ms","lastname":"Lau","firstname":"Ching Yee Camilla","companyname":"","email":null,"tel":"54028235","address":"Flat 7, 21\/F, Yee Hong House, Hong Wah Court, 2 Lin Tak Road, Lam Tin, Kowloon","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"949.0","renew_rent_month":"3","renew_warehousing_date":"2020-02-12","renew_room_key":"133,31933","renew_remark":"3 months contract. Storage rental paid by bank transfer on December 23, 2019. Storage deposit transferred from agreement A14-CT195162 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196770, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"748","room_code":"O24","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"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-12","rent_from":"2020-02-12","rent_to":"2020-08-11","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on April 2, 2020. Storage deposit transferred from agreement A14-CT196770 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":"2","branch_id":"1","company_id":"1","room_key":"133,31933","order_product":[],"pass":true}},"first_order_id":"4007","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\tO24 4X3X8 $998.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":"899.00","deposit":"0.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 11:01:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",429,"NEW","A14-CT207559",998,899,0,0,"6","6",5394,5394,5394,"2020-04-03 11:01:19","0",null,null,null,"2020-02-12","2020-08-11","6 months contract. Storage rental paid by bank transfer on April 2, 2020. Storage deposit transferred from agreement A14-CT196770 to this agreement.\r\n","2020-02-12","12",0,null,0,"0","2","2020-04-03 11:01:19","2","2020-04-03 11:01:19","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"133,31933","C170429","PERSONAL","Ms","yq94NVeoeX9jcQoo5V+k7uIokK796dSEWe+sS0IW50Y=","oe4emdjBwqJ3qUpOcI17hw==","","DM7yxTtohyGTbGNePDGNakub+skxtq4\/+vS0JwykSd6Ts34VhrLbPhIsq2UNAmboV2LG\/ir1iGELd4rhVc+XHjwq1eNzCYa\/skfwZPq62FA=","9k1gV3KPXFWWMUITVh8EIg==",null,"aP+LOVIwBPQQ+i8sD3+I+g==",null,1,"4007"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 11:01:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7559","748","998.0","998.00","2","2020-04-03 11:01:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 11:01:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-12","2020-08-11","748"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-03 11:01:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7559",429,"SETTLED","A14-I207887","2020-04-03 11:01:19","2020-02-12","2","2020-04-03 11:01:19","2","2020-04-03 11:01:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 11:01:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7887","RENT","\u9810\u7e73\u79df\u91d1",1,899,"MO","1",899,"2","2020-04-03 11:01:19","2","2020-04-03 11:01:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 11:01:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7887","RENT","\u9810\u7e73\u79df\u91d1",2,899,"MO","1",899,"2","2020-04-03 11:01:19","2","2020-04-03 11:01:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 11:01:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7887","RENT","\u9810\u7e73\u79df\u91d1",3,899,"MO","1",899,"2","2020-04-03 11:01:19","2","2020-04-03 11:01:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 11:01:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7887","RENT","\u9810\u7e73\u79df\u91d1",4,899,"MO","1",899,"2","2020-04-03 11:01:19","2","2020-04-03 11:01:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 11:01:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7887","RENT","\u9810\u7e73\u79df\u91d1",5,899,"MO","1",899,"2","2020-04-03 11:01:19","2","2020-04-03 11:01:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 11:01:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7887","RENT","\u9810\u7e73\u79df\u91d1",6,899,"MO","1",899,"2","2020-04-03 11:01:19","2","2020-04-03 11:01:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 11:01:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5394,0,"7887"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-04-03 11:01:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[429,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207534","2020-04-03 11:01:19",5394,"2","2020-04-03 11:01:19","2","2020-04-03 11:01:19","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 11:01:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7534","DEPOSIT",null,"PAID","2020-04-03 11:01:19",0,"2","2020-04-03 11:01:19","2","2020-04-03 11:01:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 11:01:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7534","INVOICE","7887","PAID","2020-04-03 11:01:19",5394,"2","2020-04-03 11:01:19","2","2020-04-03 11:01:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 11:04:34","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","floor_plan_rent_room":[{"room_id":"1165","master_room_id":"123","room_code":"A05-163"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":877,"customer_code":"C180877","identity_type":"PERSONAL","identity_id":"R938804(3)","title":"Ms","lastname":"Cameron","firstname":"Ekaterina","companyname":"","email":"info@nasonpearl.com","tel":"97337317","address":"Flat 2135, 21\/F, Tower 5, Hong Kong Parkview, 88 Tai Tam Reservoir Road, Hong Kong ","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3462.0","renew_rent_month":"2","renew_warehousing_date":"2020-03-01","renew_room_key":"190,40465,189,29022","renew_remark":"2 months contract. Storage rental paid by bank transfer on February 14, 2020. Storage deposit transferred from agreement A18-CT196516 to this agreement.\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> \r\n\t\t\t\t\tS05 4X6X7 $1857.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\tQ07 4X5X7 $1605.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"44","total_discounted_price":"3462.00","deposit":"0.00","total_retail_price":"3462.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 11:04:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",877,"NEW","A18-CT207560",3462,3462,0,0,"1","1",3462,3462,3462,"2020-04-03 11:04:34","0",null,null,null,"2020-03-01","2020-03-31","1 months contract. Storage rental paid by bank transfer on April 2, 2020. Storage deposit transferred from agreement A18-CT207193 to this agreement.\r\n","2020-03-01","44",0,null,0,"0","2","2020-04-03 11:04:34","2","2020-04-03 11:04:34","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190,40465,189,29022","C180877","PERSONAL","Ms","RPthaial2IFX5OTQVN1g+A==","5j4q6ReeucnDk5XYC2qhww==","","rRXmSas1C74UhCIMAl4XVBNkmNxuyBYhPciKj+xVXn2vQd37Gl4JOgs8HGkmy+xJFTDVdTpVVL4FPjZ3S+Pjo17HXHrjXmDiJKqKzjzyVmbMcgqz6jBEyLIHEHGxlwsr","c+0bwcSjwgphezD5fySi+g==","k2\/+w1ZaM4nSEX\/8U65t74fzkbo4RpcfhFOMFpzQU3M=","2SUKxPo6VxWobmWOngKfJg==",null,1,"4121"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 11:04: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":["7560","846","1857.0","1857.00","2","2020-04-03 11:04:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 11:04: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-03-31","846"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-03 11:04: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":["7560","810","1605.0","1605.00","2","2020-04-03 11:04:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 11:04: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-03-31","810"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-03 11:04: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":["7560",877,"SETTLED","A18-I207888","2020-04-03 11:04:34","2020-03-01","2","2020-04-03 11:04:34","2","2020-04-03 11:04:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 11:04: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":["7888","RENT","\u9810\u7e73\u79df\u91d1",1,3462,"MO","1",3462,"2","2020-04-03 11:04:34","2","2020-04-03 11:04:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 11:04:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3462,0,"7888"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-04-03 11:04: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":[877,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207535","2020-04-03 11:04:34",3462,"2","2020-04-03 11:04:34","2","2020-04-03 11:04:34","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 11:04: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":["7535","DEPOSIT",null,"PAID","2020-04-03 11:04:34",0,"2","2020-04-03 11:04:34","2","2020-04-03 11:04:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 11:04: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":["7535","INVOICE","7888","PAID","2020-04-03 11:04:34",3462,"2","2020-04-03 11:04:34","2","2020-04-03 11:04:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 11:12:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 11:55:45","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 14:58:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 15:07:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 15:08:57","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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":683,"customer_code":"C180683","identity_type":"PERSONAL","identity_id":"C296561(3)","title":"Mr","lastname":"Yu","firstname":"Shek Chi Pack","companyname":"","email":"diefattuen@gmail.com","tel":"96506596","address":"5, 24\/F, On Fai House, Yue Fai Court, Aberdeen","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1764.0","renew_rent_month":"3","renew_warehousing_date":"2020-04-03","renew_room_key":"042, 54145","renew_remark":"3 months contract. Storage rental paid by cash on Jan 9, 2020. Storage deposit transferred from agreement \tA18-CT196074 to this agreement.\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> \r\n\t\t\t\t\tR04 4X6X7 $1857.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":"24","total_discounted_price":"1764.0","deposit":"0","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 15:08:57","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",683,"NEW","A18-CT207561",1857,1764,0,0,"3","3",5292,5292,5292,"2020-04-03 15:08:57","0",null,null,null,"2020-04-03","2020-07-02","3 months contract. Storage rental paid by EPS on Apr 3, 2020. Storage deposit transferred from agreement \tA18-CT206916 to this agreement.\r\n","2020-04-03","24",0,null,0,"0","2","2020-04-03 15:08:57","2","2020-04-03 15:08:57","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"042, 54145","C180683","PERSONAL","Mr","xtZSHTD915TFuAy\/s3sBhA==","thtRZ5CDeQ9OOuodTdr1ng==","","C5oTsyuyqTxVHkMPFgHty10nBsHMbbmG4XxsHE5vDrVx+DP1RmCsFA6TKWjB7M9z","g7a+bPKtyWONirfAtn6jNw==","BKZ53JbQrrubaM8RsgM4rxgkTKfjpF9DEAaZUAfU2ws=","nH4tF+iocioYKgKiZm0GXA==",null,1,"4702"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 15:08:57","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":["7561","256","79","830","%","5.00",92.85,"2","2020-04-03 15:08:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 15:08:57","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":["7561","830","1857.0",1764.2,"2","2020-04-03 15:08:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 15:08:57","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-03","2020-07-02","830"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-03 15:08:57","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":["7561",683,"SETTLED","A18-I207889","2020-04-03 15:08:57","2020-04-03","2","2020-04-03 15:08:57","2","2020-04-03 15:08:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 15:08:57","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":["7889","RENT","\u9810\u7e73\u79df\u91d1",1,1764,"MO","1",1764,"2","2020-04-03 15:08:57","2","2020-04-03 15:08:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 15:08:57","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":["7889","RENT","\u9810\u7e73\u79df\u91d1",2,1764,"MO","1",1764,"2","2020-04-03 15:08:57","2","2020-04-03 15:08:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 15:08:57","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":["7889","RENT","\u9810\u7e73\u79df\u91d1",3,1764,"MO","1",1764,"2","2020-04-03 15:08:57","2","2020-04-03 15:08:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 15:08:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5292,0,"7889"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-04-03 15:08:57","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":[683,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207536","2020-04-03 15:08:57",5292,"2","2020-04-03 15:08:57","2","2020-04-03 15:08:57","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 15:08:57","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":["7536","DEPOSIT",null,"PAID","2020-04-03 15:08:57",0,"2","2020-04-03 15:08:57","2","2020-04-03 15:08:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 15:08:57","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":["7536","INVOICE","7889","PAID","2020-04-03 15:08:57",5292,"2","2020-04-03 15:08:57","2","2020-04-03 15:08:57"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 15:11:45","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":297,"customer_code":"C170297","identity_type":"BUSINESS","identity_id":"K091158(5)","title":"Ms","lastname":"Li","firstname":"Sin Ming","companyname":"AKRX Limited","email":"sinming_li@yahoo.com.hk","tel":"94570963","address":"Flat 2252, 22\/F, Yan's Tower, 25-27 Wong Chuk Hang Road, Wong Chuk Hang, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"935.0","renew_rent_month":"6","renew_warehousing_date":"2020-04-05","renew_room_key":"137, 05399 (609)","renew_remark":"6 months contract. Storage rental paid by cheque on Oct 09, 2019. Storage deposit transferred from agreement A14-CT194703 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196109, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"745","room_code":"O21","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":935,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5610,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-05","rent_from":"2020-04-05","rent_to":"2020-10-04","delivery_service":"0","remark":"6 months contract. Storage rental paid by cheque on Apr 3, 2020. Storage deposit transferred from agreement A14-CT196109 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":5610,"final_order_total":5610,"location_id":"2","branch_id":"1","company_id":"1","room_key":"137, 05399 (609)","order_product":[],"pass":true}},"first_order_id":"4703","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\tO21 4X4X8 $1098.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"935.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 15:11:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",297,"NEW","A14-CT207562",1098,935,0,0,"6","6",5610,5610,5610,"2020-04-03 15:11:45","0",null,null,null,"2020-04-05","2020-10-04","6 months contract. Storage rental paid by cheque on Apr 3, 2020. Storage deposit transferred from agreement A14-CT196109 to this agreement.\r\n","2020-04-05","16",0,null,0,"0","2","2020-04-03 15:11:45","2","2020-04-03 15:11:45","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"137, 05399 (609)","C170297","BUSINESS","Ms","V82Bk7sZ8oEuTUpOQ0yJcQ==","7KCehmxbvwRMb+U8lHGoVA==","AKRX Limited","\/t8kBlKxuUw1qMv40xy5tDVCZsx3TwkiOJbSUPMqWMyXyz8rHFckT1JvUlwOuBPgiNn8ktGUFG+AFs8dyIE7V8m6twJH\/jZlN569lPpApiCvJ3vrAmgL0OeIUT\/fgj58","mDc4dfYNYawnG5QOr5SWbQ==","DbzEZaHoFGfm0Gwwdl7ei7CZcGFIkso6gubPQILuBCg=",null,"uNEDkHhu7ADVW9Kv09kUtQ==",1,"4703"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 15:11:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7562","745","1098.0","1098.00","2","2020-04-03 15:11:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 15:11:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-05","2020-10-04","745"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-03 15:11:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7562",297,"SETTLED","A14-I207890","2020-04-03 15:11:45","2020-04-05","2","2020-04-03 15:11:45","2","2020-04-03 15:11:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 15:11:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7890","RENT","\u9810\u7e73\u79df\u91d1",1,935,"MO","1",935,"2","2020-04-03 15:11:45","2","2020-04-03 15:11:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 15:11:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7890","RENT","\u9810\u7e73\u79df\u91d1",2,935,"MO","1",935,"2","2020-04-03 15:11:45","2","2020-04-03 15:11:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 15:11:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7890","RENT","\u9810\u7e73\u79df\u91d1",3,935,"MO","1",935,"2","2020-04-03 15:11:45","2","2020-04-03 15:11:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 15:11:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7890","RENT","\u9810\u7e73\u79df\u91d1",4,935,"MO","1",935,"2","2020-04-03 15:11:45","2","2020-04-03 15:11:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 15:11:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7890","RENT","\u9810\u7e73\u79df\u91d1",5,935,"MO","1",935,"2","2020-04-03 15:11:45","2","2020-04-03 15:11:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 15:11:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7890","RENT","\u9810\u7e73\u79df\u91d1",6,935,"MO","1",935,"2","2020-04-03 15:11:45","2","2020-04-03 15:11:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 15:11:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5610,0,"7890"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-04-03 15:11:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[297,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207537","2020-04-03 15:11:45",5610,"2","2020-04-03 15:11:45","2","2020-04-03 15:11:45","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 15:11:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7537","DEPOSIT",null,"PAID","2020-04-03 15:11:45",0,"2","2020-04-03 15:11:45","2","2020-04-03 15:11:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 15:11:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7537","INVOICE","7890","PAID","2020-04-03 15:11:45",5610,"2","2020-04-03 15:11:45","2","2020-04-03 15:11:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 16:45:53","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1233&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1257","master_room_id":"136","room_code":"B01-067"}],"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\tB01-067 3X4X7 $908.00 N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"K869450(8)","title":"Ms","lastname":"YEUNG","firstname":"Choi Ha Suki","companyname":"","email":"","tel":"63337242","address":"53B,Tower 9, Island Restort, 28 Siu Sai Wan Road, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1257","room_code":"B01-067","retail_price":"908.0","discounted_price":"908.00","location_id":"5"}],"roughly_size":"12","total_retail_price":908,"total_discounted_price":709,"deposit":1816,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":8906,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1418.00","warehousing_date":"2020-04-08","rent_from":"2020-04-08","rent_to":"2021-04-07","delivery_service":"0","remark":"12 months contract. Special offer the 11th and 12th month free. Storage rental and deposit paid by bank transfer on Apr 02,2020. Smartcard paid on the same day. Smart card mailed out on Apr 03,2020.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":1418,"order_total":10384,"final_order_total":8966,"location_id":"5","branch_id":"2","company_id":"1","room_key":"'0005013192","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"pass":true}},"roughly_size":"12","total_discounted_price":"709.00","deposit":"1816.00","total_retail_price":"908.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 16:45:54","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":["C201551","PERSONAL","Ms","IGFZP+fjajzeRCuuGCn1bg==","cehTPCv0LSZ1f3zKZGLhBA==","","ZOUmooCBOLidmanOdiw1Sg==",null,"ChCdC9OG+HtgN3rpvXsYQR1fMAfL5nRZy8dFzzCcb0jswyykQtUZD6O1HQ6Y6xKu8Hcz5o2c00g5Bl8c\/831Hg==","jgn6D7EeOKaLd2E4BNcEmg==",null,null,"G0dMBFDmtnlGSX\/Ddtl4Bg==","2","2020-04-03 16:45:53","2","2020-04-03 16:45:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 16:45:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","2","5",1551,"NEW","B01-CT207563",908,709,1816,0,"12","12",8906,10384,8966,"2020-04-03 16:45:54","0",null,null,null,"2020-04-08","2021-04-07","12 months contract. Special offer the 11th and 12th month free. Storage rental and deposit paid by bank transfer on Apr 02,2020. Smartcard paid on the same day. Smart card mailed out on Apr 03,2020.","2020-04-08","12",0,null,1418,"1418.00","2","2020-04-03 16:45:53","2","2020-04-03 16:45:53","BANKIN","","","","BANKIN","","","",null,0,"'0005013192","C201551","PERSONAL","Ms","IGFZP+fjajzeRCuuGCn1bg==","cehTPCv0LSZ1f3zKZGLhBA==","","ChCdC9OG+HtgN3rpvXsYQR1fMAfL5nRZy8dFzzCcb0jswyykQtUZD6O1HQ6Y6xKu8Hcz5o2c00g5Bl8c\/831Hg==","ZOUmooCBOLidmanOdiw1Sg==",null,"jgn6D7EeOKaLd2E4BNcEmg==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 16:45:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7563",1551,"11","1","60.0",60,"2","2020-04-03 16:45:53","2","2020-04-03 16:45:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 16:45:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"7563"]},"data_before":[],"data_after":[],"step":4}
*****
{"created_at":"2020-04-03 16:45:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7563","1257","908.0","908.00","2","2020-04-03 16:45:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 16:45:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-08","2021-04-07","1257"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-03 16:45:54","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":["7563","B01-D205351","PAID",1816,0,"2021-04-07","2020-04-03 16:45:53","2020-04-03 16:45:53","2","2020-04-03 16:45:53","2","2020-04-03 16:45:53",1551]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 16:45:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7563",1551,"SETTLED","B01-I207891","2020-04-03 16:45:53","2020-04-08","2","2020-04-03 16:45:53","2","2020-04-03 16:45:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 16:45:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7891","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-04-03 16:45:53","2","2020-04-03 16:45:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 16:45:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7891","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,709,"MO","1",709,"2","2020-04-03 16:45:53","2","2020-04-03 16:45:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 16:45:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7891","RENT","\u9810\u7e73\u79df\u91d1",4,709,"MO","1",709,"2","2020-04-03 16:45:53","2","2020-04-03 16:45:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 16:45:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7891","RENT","\u9810\u7e73\u79df\u91d1",5,709,"MO","1",709,"2","2020-04-03 16:45:53","2","2020-04-03 16:45:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 16:45:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7891","RENT","\u9810\u7e73\u79df\u91d1",6,709,"MO","1",709,"2","2020-04-03 16:45:53","2","2020-04-03 16:45:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 16:45:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7891","RENT","\u9810\u7e73\u79df\u91d1",7,709,"MO","1",709,"2","2020-04-03 16:45:53","2","2020-04-03 16:45:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 16:45:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7891","RENT","\u9810\u7e73\u79df\u91d1",8,709,"MO","1",709,"2","2020-04-03 16:45:53","2","2020-04-03 16:45:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 16:45:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7891","RENT","\u9810\u7e73\u79df\u91d1",9,709,"MO","1",709,"2","2020-04-03 16:45:53","2","2020-04-03 16:45:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 16:45:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7891","RENT","\u9810\u7e73\u79df\u91d1",10,709,"MO","1",709,"2","2020-04-03 16:45:53","2","2020-04-03 16:45:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 16:45:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7891","RENT","\u9810\u7e73\u79df\u91d1",11,709,"MO","1",709,"2","2020-04-03 16:45:53","2","2020-04-03 16:45:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 16:45:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7891","RENT","\u9810\u7e73\u79df\u91d1",12,709,"MO","1",709,"2","2020-04-03 16:45:53","2","2020-04-03 16:45:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 16:45:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7891","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-04-03 16:45:53","2","2020-04-03 16:45:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 16:45:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7150,0,"7891"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-04-03 16:45:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1551,"BANKIN","","","","BANKIN","","","","PAID","P207538","2020-04-03 16:45:53",8966,"2","2020-04-03 16:45:53","2","2020-04-03 16:45:53","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 16:45:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7538","DEPOSIT","5351","PAID","2020-04-03 16:45:53",1816,"2","2020-04-03 16:45:53","2","2020-04-03 16:45:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 16:45:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7538","INVOICE","7891","PAID","2020-04-03 16:45:53",7150,"2","2020-04-03 16:45:53","2","2020-04-03 16:45:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:00:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:03:12","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1165","master_room_id":"123","room_code":"A05-163"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":724,"customer_code":"C180724","identity_type":"PERSONAL","identity_id":"D488390(0)","title":"Mr","lastname":"Chan","firstname":"Kai Ming Johnny","companyname":"","email":"ckmjohnny@gmail.com","tel":"92855920","address":"Room 922, Wah Cheong House, Wah Fu Estate, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2058.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-05","renew_room_key":"054,32853","renew_remark":"1 month contract. Storage rental paid by PPS on February 3, 2020. Storage deposit transferred from agreement A12-CT207092 to this agreement.\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> \r\n\t\t\t\t\tF06 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\tF17 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":"28","total_discounted_price":"2058.0","deposit":"0","total_retail_price":"2096.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:03:12","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",724,"NEW","A12-CT207564",2096,2058,0,0,"1","1",2058,2058,2058,"2020-04-03 18:03:12","0",null,null,null,"2020-04-05","2020-05-04","1 month contract. Storage rental paid by PPS on April 2, 2020. Storage deposit transferred from agreement A12-CT207323 to this agreement.\r\n","2020-04-05","28",0,null,0,"0","2","2020-04-03 18:03:12","2","2020-04-03 18:03:12","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,32853","C180724","PERSONAL","Mr","S2Y\/+hrua6snugCiRVXC+g==","U9yoE9KqV1v8YlRkf7Q2yg==","","k+e0QYxm9l5HuoQuXakgBNnw8UW4n+ZLcCG9eEWYCG3GGUVs8OcyHqJxZXBRIAQ7e4G25Jwv46TjFMKIeqmD6Q==","uIJTfVK37Ukw\/PebwnT1DA==","HVGIbYlde5F3OKyLRPpR9QsuoR+xNkr5wlpbBQugV6E=","tHG2eMtIkTmRjccZ2JJ3PQ==",null,1,"4888"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:03:12","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":["7564","321","998.0","998.00","2","2020-04-03 18:03:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:03:12","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-05","2020-05-04","321"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-03 18:03:12","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":["7564","332","1098.0","1098.00","2","2020-04-03 18:03:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:03:12","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-05","2020-05-04","332"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-03 18:03:12","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":["7564",724,"SETTLED","A12-I207892","2020-04-03 18:03:12","2020-04-05","2","2020-04-03 18:03:12","2","2020-04-03 18:03:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:03:12","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":["7892","RENT","\u9810\u7e73\u79df\u91d1",1,2058,"MO","1",2058,"2","2020-04-03 18:03:12","2","2020-04-03 18:03:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:03:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2058,0,"7892"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-04-03 18:03:12","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":[724,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207539","2020-04-03 18:03:12",2058,"2","2020-04-03 18:03:12","2","2020-04-03 18:03:12","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:03:12","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":["7539","DEPOSIT",null,"PAID","2020-04-03 18:03:12",0,"2","2020-04-03 18:03:12","2","2020-04-03 18:03:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:03:12","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":["7539","INVOICE","7892","PAID","2020-04-03 18:03:12",2058,"2","2020-04-03 18:03:12","2","2020-04-03 18:03:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:06: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&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":"1165","master_room_id":"123","room_code":"A05-163"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":688,"customer_code":"C180688","identity_type":"PERSONAL","identity_id":"K122210(4)","title":"Mr","lastname":"Cheung","firstname":"Wai Yung","companyname":"","email":"yung912@gmail.com","tel":"92637806","address":"Rm A, 20\/F, Block 20, Mei Cheung Court, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1090.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-08","renew_room_key":"054,60450","renew_remark":"1 month contract. Storage rental paid by PPS on March 2, 2020. Storage deposit transferred from agreement A18-CT207137 to this agreement.\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> \r\n\t\t\t\t\tQ10 3X4X7 $1090.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":"1090.0","deposit":"0","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:06:07","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",688,"NEW","A18-CT207565",1090,1090,0,0,"1","1",1090,1090,1090,"2020-04-03 18:06:07","0",null,null,null,"2020-04-08","2020-05-07","1 month contract. Storage rental paid by PPS on April 2, 2020. Storage deposit transferred from agreement A18-CT207310 to this agreement.\r\n","2020-04-08","12",0,null,0,"0","2","2020-04-03 18:06:06","2","2020-04-03 18:06:06","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,60450","C180688","PERSONAL","Mr","w+3oxtOYocerQ225PhLj2Q==","vCxOlXQuvOQaoL822H2o\/Q==","","QvNFWPnZK2SY5iOuJxtofiF6G+A71It3PRUQIo0auvIWzvBTZRm2wfB\/VYgB4L2eWR9M0rvXLhbVNAUw9JyOPpQPVCto6YLfO\/ESHYYW+OA=","+JEnloGcmAHQH7QI0dDDrg==","KssyFPR1OHCnH1SYGPPT\/JDvr7I47++6Ndv+5eVj1fE=","OGIBS1CZsN25WARbNGD97w==",null,1,"4769"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:06:07","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":["7565","813","1090.0","1090.00","2","2020-04-03 18:06:06"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:06:07","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-08","2020-05-07","813"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-03 18:06:07","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":["7565",688,"SETTLED","A18-I207893","2020-04-03 18:06:06","2020-04-08","2","2020-04-03 18:06:06","2","2020-04-03 18:06:06"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:06:07","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":["7893","RENT","\u9810\u7e73\u79df\u91d1",1,1090,"MO","1",1090,"2","2020-04-03 18:06:06","2","2020-04-03 18:06:06"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:06:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1090,0,"7893"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-04-03 18:06:07","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":[688,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207540","2020-04-03 18:06:06",1090,"2","2020-04-03 18:06:06","2","2020-04-03 18:06:06","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:06:07","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":["7540","DEPOSIT",null,"PAID","2020-04-03 18:06:06",0,"2","2020-04-03 18:06:06","2","2020-04-03 18:06:06"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:06:07","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":["7540","INVOICE","7893","PAID","2020-04-03 18:06:06",1090,"2","2020-04-03 18:06:06","2","2020-04-03 18:06:06"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:19:59","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":"page=3&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"D322801(1)","title":"Mr","lastname":"CHAN","firstname":"Wai Tak","companyname":"","email":"","tel":"93671961","address":"Flat 4, 14\/F, Tin Fai House, Yue Fai Court, 45 Yue Kwong Road, Aberdeen, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"425","room_code":"J07","retail_price":"2888.0","discounted_price":"2888.00","location_id":"2"}],"roughly_size":"40","total_retail_price":2888,"total_discounted_price":2888,"deposit":5776,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":10108,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"4332.00","warehousing_date":"2020-04-25","rent_from":"2020-04-25","rent_to":"2020-07-24","delivery_service":"0","remark":"3 months contract. Special offer 50% off. Storage rental and deposit paid by EPS on Apr 03,2020. Smart card and padlock provided on Apr 03,2020.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":4332,"order_total":14440,"final_order_total":10108,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,60455","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> \n\t\t\t\t\tJ07 5X8X8 $2888.00 - <\/td> \u9810\u4ed812\u500b\u6708 \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"40","total_discounted_price":"2888.00","deposit":"5776.00","total_retail_price":"2888.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:20:00","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":["C201552","PERSONAL","Mr","X1ExqbuzNFFDVwHk7F5T+w==","8BEgNhGpCR8jGkzUtrIcXg==","","jry3VOXwXj0Jcb2\/ILZf+g==",null,"tBOh7tXr0tteyxT\/86ywtluUlGOeN\/67HIK9kAPxncklsvj+H85ZXflYn9\/K19YT1ietImfa+PaQXtjU98rC8JSAxZ+ppJ+A0IkLwt9hoDU=","zRGJ9kmt3fWZSC3dAz3\/Zg==",null,null,"GOC0FE9rVd3ohotbVXbRxw==","2","2020-04-03 18:19:59","2","2020-04-03 18:19:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:20: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` = ?","parameters":["1","1","2",1552,"NEW","A14-CT207566",2888,2888,5776,0,"3","3",10108,14440,10108,"2020-04-03 18:20:01","0",null,null,null,"2020-04-25","2020-07-24","3 months contract. Special offer 50% off. Storage rental and deposit paid by EPS on Apr 03,2020. Smart card and padlock provided on Apr 03,2020.","2020-04-25","40",0,null,4332,"4332.00","2","2020-04-03 18:19:59","2","2020-04-03 18:19:59","EPS","","","","EPS","","","",null,0,"054,60455","C201552","PERSONAL","Mr","X1ExqbuzNFFDVwHk7F5T+w==","8BEgNhGpCR8jGkzUtrIcXg==","","tBOh7tXr0tteyxT\/86ywtluUlGOeN\/67HIK9kAPxncklsvj+H85ZXflYn9\/K19YT1ietImfa+PaQXtjU98rC8JSAxZ+ppJ+A0IkLwt9hoDU=","jry3VOXwXj0Jcb2\/ILZf+g==",null,"zRGJ9kmt3fWZSC3dAz3\/Zg==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:20: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":["7566","425","2888.0","2888.00","2","2020-04-03 18:19:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:20: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-04-25","2020-07-24","425"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-04-03 18:20:01","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":["7566","A14-D205352","PAID",5776,0,"2020-07-24","2020-04-03 18:19:59","2020-04-03 18:19:59","2","2020-04-03 18:19:59","2","2020-04-03 18:19:59",1552]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:20: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":["7566",1552,"SETTLED","A14-I207894","2020-04-03 18:19:59","2020-04-25","2","2020-04-03 18:19:59","2","2020-04-03 18:19:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:20: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":["7894","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-04-03 18:19:59","2","2020-04-03 18:19:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:20: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":["7894","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1444,"MO","1",1444,"2","2020-04-03 18:19:59","2","2020-04-03 18:19:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:20: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":["7894","RENT","\u9810\u7e73\u79df\u91d1",3,2888,"MO","1",2888,"2","2020-04-03 18:19:59","2","2020-04-03 18:19:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:20:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4332,0,"7894"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-04-03 18:20: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":[1552,"EPS","","","","EPS","","","","PAID","P207541","2020-04-03 18:19:59",10108,"2","2020-04-03 18:19:59","2","2020-04-03 18:19:59","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:20: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":["7541","DEPOSIT","5352","PAID","2020-04-03 18:19:59",5776,"2","2020-04-03 18:19:59","2","2020-04-03 18:19:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-04-03 18:20: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":["7541","INVOICE","7894","PAID","2020-04-03 18:19:59",4332,"2","2020-04-03 18:19:59","2","2020-04-03 18:19:59"]},"data_before":[],"data_after":[],"step":1}
*****