{"created_at":"2020-04-01 10:17:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:33:54","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=57&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&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":560,"customer_code":"C170560","identity_type":"PERSONAL","identity_id":"C454277(9)","title":"Mr","lastname":"Li","firstname":"Kwok Choi","companyname":"","email":"benjaminkcli@gmail.com","tel":"91211868","address":"Tower 20-D,34\/F,South Horizons,Apleichau,HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1860.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-01","renew_room_key":"054,16918","renew_remark":"1 month contract. Storage rental paid by bank transfer on March 1, 2020. Storage deposit transferred from agreement A12-CT207081 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207284, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"335","room_code":"F20","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"},{"room_id":"324","room_code":"F09","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"28","total_retail_price":2096,"total_discounted_price":1860,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1860,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-01","rent_from":"2020-04-01","rent_to":"2020-04-30","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on March 31, 2020. Storage deposit transferred from agreement A12-CT207284 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1860,"final_order_total":1860,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,16918","order_product":[],"pass":true}},"first_order_id":"4811","selected_room_tr":"\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t

---

\r\n\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\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\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

\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>
F20 <\/td>\r\n\t\t\t\t\t	4X4X8 <\/td>\r\n\t\t\t\t\t	$1098.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>
F09 <\/td>\r\n\t\t\t\t\t	4X3X8 <\/td>\r\n\t\t\t\t\t	$998.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"28","total_discounted_price":"1860.0","deposit":"0","total_retail_price":"2096.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:33:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",560,"NEW","A12-CT207539",2096,1860,0,0,"1","1",1860,1860,1860,"2020-04-01 11:33:54","0",null,null,null,"2020-04-01","2020-04-30","1 month contract. Storage rental paid by bank transfer on March 31, 2020. Storage deposit transferred from agreement A12-CT207284 to this agreement.","2020-04-01","28",0,null,0,"0","2","2020-04-01 11:33:53","2","2020-04-01 11:33:53","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,16918","C170560","PERSONAL","Mr","K1x\/9w0o0rKJd7wz8qK7pg==","7KCehmxbvwRMb+U8lHGoVA==","","FtBAyqdJB9YVbXi504FRZc\/Jt3mzCqv\/xe\/RY0+A7wVOOPyXv8dxE4H5XZLFEXzC","4QMR+NS4lG0kYGIev9anRw==","ZR5GFjUu0SZOy4e7QYAXd00ul0qCow7bN10OYhy9E+I=","Yd8HrzCK1iQ9KWTKpSyu0w==",null,1,"4811"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:33: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":["7539","335","1098.0","1098.00","2","2020-04-01 11:33:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:33: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-01","2020-04-30","335"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-01 11:33: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":["7539","324","998.0","998.00","2","2020-04-01 11:33:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:33: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-01","2020-04-30","324"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-01 11:33: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":["7539",560,"SETTLED","A12-I207867","2020-04-01 11:33:53","2020-04-01","2","2020-04-01 11:33:53","2","2020-04-01 11:33:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:33: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":["7867","RENT","\u9810\u7e73\u79df\u91d1",1,1860,"MO","1",1860,"2","2020-04-01 11:33:53","2","2020-04-01 11:33:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:33:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1860,0,"7867"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-01 11:33: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":[560,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207514","2020-04-01 11:33:53",1860,"2","2020-04-01 11:33:53","2","2020-04-01 11:33:53","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:33: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":["7514","DEPOSIT",null,"PAID","2020-04-01 11:33:53",0,"2","2020-04-01 11:33:53","2","2020-04-01 11:33:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:33: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":["7514","INVOICE","7867","PAID","2020-04-01 11:33:53",1860,"2","2020-04-01 11:33:53","2","2020-04-01 11:33:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:37:13","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=57&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&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&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":744,"customer_code":"C180744","identity_type":"PERSONAL","identity_id":"P048772(8)","title":"Ms","lastname":"Ho","firstname":"Mo Ching Cathy","companyname":"","email":"mchooo@gmail.com","tel":"93554406","address":"Flat C, 33\/F, Bayshore Apartment, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"867.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-27","renew_room_key":"055,17315","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 29, 2020. Storage deposit transferred from agreement A18-CT195572 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207055, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"100","order_discount":[],"order_room":[{"room_id":"928","room_code":"V02(\u670d\u88dd\u5009)","retail_price":"867.0","discounted_price":"867.00","location_id":"3"}],"roughly_size":"7.2","total_retail_price":867,"total_discounted_price":824,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2472,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-27","rent_from":"2020-02-27","rent_to":"2020-05-26","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on Mar 31, 2020. Storage deposit transferred from agreement A18-CT207055 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2472,"final_order_total":2472,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,17315","order_product":[],"pass":true}},"first_order_id":"4189","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\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\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\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 \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> V02(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 3X2.4X7 <\/td>\r\n\t\t\t\t\t $867.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \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":"7.2","total_discounted_price":"824.00","deposit":"0.00","total_retail_price":"867.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:37:13","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",744,"NEW","A18-CT207540",867,824,0,0,"3","3",2472,2472,2472,"2020-04-01 11:37:13","0",null,null,null,"2020-02-27","2020-05-26","3 months contract. Storage rental paid by bank transfer on Mar 31, 2020. Storage deposit transferred from agreement A18-CT207055 to this agreement.","2020-02-27","7.2",0,null,0,"0","2","2020-04-01 11:37:13","2","2020-04-01 11:37:13","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,17315","C180744","PERSONAL","Ms","EUjkCpsubVvF1qfSw9fseg==","D\/skxQ5s\/L5yyRWaDK\/iSg==","","t3z\/tBJVx9zUBsPV2QLEKP\/AqBedWM1pqHTyFCmhZMxE9j81xPq6zAWG2opPZD62551Q3nqkNQ4SQQVLAi\/ebQ==","nLgH3bybWamCUHRAkIxQVw==","Uhq9I4m8wi2lpFRkgjzbiBcMCEEf9\/MkY3ZKL8CyO+Q=","wH9Lv4oBE\/XdyEdxYi0AIQ==",null,1,"4189"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:37:13","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":["7540","928","867.0","867.00","2","2020-04-01 11:37:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:37:13","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-27","2020-05-26","928"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-01 11:37:13","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":["7540",744,"SETTLED","A18-I207868","2020-04-01 11:37:13","2020-02-27","2","2020-04-01 11:37:13","2","2020-04-01 11:37:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:37:13","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":["7868","RENT","\u9810\u7e73\u79df\u91d1",1,824,"MO","1",824,"2","2020-04-01 11:37:13","2","2020-04-01 11:37:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:37:13","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":["7868","RENT","\u9810\u7e73\u79df\u91d1",2,824,"MO","1",824,"2","2020-04-01 11:37:13","2","2020-04-01 11:37:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:37:13","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":["7868","RENT","\u9810\u7e73\u79df\u91d1",3,824,"MO","1",824,"2","2020-04-01 11:37:13","2","2020-04-01 11:37:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:37:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2472,0,"7868"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-01 11:37:13","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":[744,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207515","2020-04-01 11:37:13",2472,"2","2020-04-01 11:37:13","2","2020-04-01 11:37:13","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:37:13","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":["7515","DEPOSIT",null,"PAID","2020-04-01 11:37:13",0,"2","2020-04-01 11:37:13","2","2020-04-01 11:37:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:37:13","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":["7515","INVOICE","7868","PAID","2020-04-01 11:37:13",2472,"2","2020-04-01 11:37:13","2","2020-04-01 11:37:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:41:46","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=57&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&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&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":1355,"customer_code":"C191355","identity_type":"PERSONAL","identity_id":"D260822(8)","title":"Mr","lastname":"Lau","firstname":"Ka Ho David","companyname":"","email":"lkhdavid@yahoo.com.hk","tel":"92023125","address":"5\/F, Harrow Mansion, 170-172 Aberdeen Main Rd, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2188.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-04","renew_room_key":"076,48044","renew_remark":"1 month contract. Storage rental paid by bank transfer on March 4, 2020. Storage deposit $4376 transferred from agreement A12-CT207164 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207368, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"4","order_discount":[],"order_room":[{"room_id":"297","room_code":"E24","retail_price":"1138.0","discounted_price":"946.00","location_id":"1"},{"room_id":"308","room_code":"E35","retail_price":"1138.0","discounted_price":"946.00","location_id":"1"}],"roughly_size":"30","total_retail_price":2276,"total_discounted_price":2188,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":4376,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-04","rent_from":"2020-02-04","rent_to":"2020-04-03","delivery_service":"0","remark":"2 months contract. Storage rental $2188\/month. Storage rental paid by bank transfer on March 31, 2020. Storage deposit $4376 transferred from agreement A12-CT207368 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4376,"final_order_total":4376,"location_id":"1","branch_id":"1","company_id":"1","room_key":"076,48044","order_product":[],"pass":true}},"first_order_id":"5625","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\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\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\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 \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> E24 <\/td>\r\n\t\t\t\t\t 3X5X8 <\/td>\r\n\t\t\t\t\t $1138.00 <\/td>\r\n\t\t\t\t $946.0 <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> E35 <\/td>\r\n\t\t\t\t\t 3X5X8 <\/td>\r\n\t\t\t\t\t $1138.00 <\/td>\r\n\t\t\t\t $946.0 <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \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":"30","total_discounted_price":"2188.00","deposit":"0.00","total_retail_price":"2276.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:41:46","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",1355,"NEW","A12-CT207541",2276,2188,0,0,"2","2",4376,4376,4376,"2020-04-01 11:41:46","0",null,null,null,"2020-02-04","2020-04-03","2 months contract. Storage rental $2188\/month. Storage rental paid by bank transfer on March 31, 2020. Storage deposit $4376 transferred from agreement A12-CT207368 to this agreement.","2020-02-04","30",0,null,0,"0","2","2020-04-01 11:41:46","2","2020-04-01 11:41:46","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,48044","C191355","PERSONAL","Mr","byNdTNcCLo6aLQN435WZZQ==","oe4emdjBwqJ3qUpOcI17hw==","","mLjIS1gL5SfHxNCxPFPye21mGzNX+ITzU4qVF+K6L0jbVek9r3oaeRQYRWuk5L45CjWLjqP\/\/6VUESa\/Ue5xcw==","LjaeJ3csMFHue8wAtOK+sQ==","HYtOeAa2oajm09cLWUO73jrw++DhYubmcByxwcfKdrU=","ks+B19crkUr8NVNksxwxyg==",null,1,"5625"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:41:46","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":["7541","297","1138.0","946.00","2","2020-04-01 11:41:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:41:46","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-04","2020-04-03","297"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-01 11:41:46","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":["7541","308","1138.0","946.00","2","2020-04-01 11:41:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:41:46","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-04","2020-04-03","308"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-01 11:41:46","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":["7541",1355,"SETTLED","A12-I207869","2020-04-01 11:41:46","2020-02-04","2","2020-04-01 11:41:46","2","2020-04-01 11:41:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:41:46","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":["7869","RENT","\u9810\u7e73\u79df\u91d1",1,2188,"MO","1",2188,"2","2020-04-01 11:41:46","2","2020-04-01 11:41:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:41:46","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":["7869","RENT","\u9810\u7e73\u79df\u91d1",2,2188,"MO","1",2188,"2","2020-04-01 11:41:46","2","2020-04-01 11:41:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:41:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4376,0,"7869"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-01 11:41:46","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":[1355,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207516","2020-04-01 11:41:46",4376,"2","2020-04-01 11:41:46","2","2020-04-01 11:41:46","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:41:46","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":["7516","DEPOSIT",null,"PAID","2020-04-01 11:41:46",0,"2","2020-04-01 11:41:46","2","2020-04-01 11:41:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:41:46","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":["7516","INVOICE","7869","PAID","2020-04-01 11:41:46",4376,"2","2020-04-01 11:41:46","2","2020-04-01 11:41:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 11:42:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 12:13:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 13:47:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 16:42:21","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=441&filter3=undefined","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":663,"customer_code":"C170663","identity_type":"PERSONAL","identity_id":"D302826(8)","title":"Ms","lastname":"Chu","firstname":"Lai Ngan ","companyname":"","email":null,"tel":"91216789","address":"Flat E, 13\/F, Tower 8, South Horizons, Ap Lei Chau","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-01","renew_room_key":"055,06790","renew_remark":"1 month contract. Storage rental paid by bank transfer on March 5, 2020. Storage deposit transferred from agreement A18-CT207079 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207331, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"989","room_code":"X14","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1290,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-01","rent_from":"2020-04-01","rent_to":"2020-04-30","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Apr 01, 2020. Storage deposit transferred from agreement A18-CT207331 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,06790","order_product":[],"pass":true}},"first_order_id":"4345","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\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\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\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 \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> X14 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1290.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 16:42:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",663,"NEW","A18-CT207542",1290,1290,0,0,"1","1",1290,1290,1290,"2020-04-01 16:42:21","0",null,null,null,"2020-04-01","2020-04-30","1 month contract. Storage rental paid by bank transfer on Apr 01, 2020. Storage deposit transferred from agreement A18-CT207331 to this agreement.","2020-04-01","16",0,null,0,"0","2","2020-04-01 16:42:20","2","2020-04-01 16:42:20","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,06790","C170663","PERSONAL","Ms","+hf2BdEzeyuAlJ9o86BQkA==","uwdKi3S38jh5+tBibXKG4A==","","ZkyPYW\/X9p1lPTh\/bKU+\/PiAtXClt+yHReh+airMmSnG6Uwc2BRo5SF4sycqncKB\/EoNyhigJWrejarCTwNPAg==","q3\/rgHjoH\/vhcz82yJ8JGA==",null,"x7LEi0saK+ePsbHhJKXpDQ==",null,1,"4345"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 16:42:21","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":["7542","989","1290.0","1290.00","2","2020-04-01 16:42:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 16:42:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-01","2020-04-30","989"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-01 16:42:21","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":["7542",663,"SETTLED","A18-I207870","2020-04-01 16:42:20","2020-04-01","2","2020-04-01 16:42:20","2","2020-04-01 16:42:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 16:42:21","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":["7870","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-04-01 16:42:20","2","2020-04-01 16:42:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 16:42:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"7870"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-01 16:42:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[663,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207517","2020-04-01 16:42:20",1290,"2","2020-04-01 16:42:20","2","2020-04-01 16:42:20","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 16:42:21","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":["7517","DEPOSIT",null,"PAID","2020-04-01 16:42:20",0,"2","2020-04-01 16:42:20","2","2020-04-01 16:42:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 16:42:21","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":["7517","INVOICE","7870","PAID","2020-04-01 16:42:20",1290,"2","2020-04-01 16:42:20","2","2020-04-01 16:42:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 16:46:23","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=441&filter3=undefined&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":974,"customer_code":"C180974","identity_type":"PERSONAL","identity_id":"D243596(A)","title":"Ms","lastname":"NG","firstname":"PUI KI PEGGY","companyname":"","email":null,"tel":"94019112","address":"Flat C, 12\/F, Block 11, Nam Fung Sun Chuen, 17 Creig Crescent, Quarry Bay, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"899.0","renew_rent_month":"6","renew_warehousing_date":"2020-04-08","renew_room_key":"0005832816","renew_remark":"6 months contract. Storage rental paid by bank transfer on Oct, 4. Storage deposit $1996 transferred from agreement C15-CT195419 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT196079, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"168","order_discount":[],"order_room":[{"room_id":"1398","room_code":"C15-092","retail_price":"900.0","discounted_price":"900.00","location_id":"6"}],"roughly_size":"12","total_retail_price":900,"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-04-08","rent_from":"2020-04-08","rent_to":"2020-10-07","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on Mar 31,2020. Storage deposit $1996 transferred from agreement C15-CT196079 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5394,"final_order_total":5394,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0005832816","order_product":[],"pass":true}},"first_order_id":"4646","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\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\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\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 \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> C15-092 <\/td>\r\n\t\t\t\t\t 4X3X6.5 <\/td>\r\n\t\t\t\t\t $900.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"899.0","deposit":"0","total_retail_price":"900.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 16:46:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",974,"NEW","C15-CT207543",900,899,0,0,"6","6",5394,5394,5394,"2020-04-01 16:46:24","0",null,null,null,"2020-04-08","2020-10-07","6 months contract. Storage rental paid by bank transfer on Mar 31,2020. Storage deposit $1996 transferred from agreement C15-CT196079 to this agreement. ","2020-04-08","12",0,null,0,"0","2","2020-04-01 16:46:23","2","2020-04-01 16:46:23","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005832816","C180974","PERSONAL","Ms","V7NqjP8QYGus0h2MAuSnjQ==","yXKLXTtbNpECaRVTZxF\/Rw==","","o6gdoLgvO4gNBlKxbnZ\/\/Tsst3tOfsCzgpynpIf4EhkyGyERW8MeXg8QM+yc0A67kkJU\/Yy+rLYBNV7fkQfSeHye8bu28LnMRPT60N5IwfsWZr1uwpnNRBwu4+7NRN+K","gaGJYwLTDkF74OZ+8u\/DcQ==",null,"bxi6ZOUniHCXl5o6QpXfCA==",null,1,"4646"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 16:46:24","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":["7543","1398","900.0","900.00","2","2020-04-01 16:46:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 16:46:24","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-10-07","1398"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-01 16:46:24","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":["7543",974,"SETTLED","C15-I207871","2020-04-01 16:46:23","2020-04-08","2","2020-04-01 16:46:23","2","2020-04-01 16:46:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 16:46:24","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":["7871","RENT","\u9810\u7e73\u79df\u91d1",1,899,"MO","1",899,"2","2020-04-01 16:46:23","2","2020-04-01 16:46:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 16:46:24","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":["7871","RENT","\u9810\u7e73\u79df\u91d1",2,899,"MO","1",899,"2","2020-04-01 16:46:23","2","2020-04-01 16:46:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 16:46:24","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":["7871","RENT","\u9810\u7e73\u79df\u91d1",3,899,"MO","1",899,"2","2020-04-01 16:46:23","2","2020-04-01 16:46:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 16:46:24","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":["7871","RENT","\u9810\u7e73\u79df\u91d1",4,899,"MO","1",899,"2","2020-04-01 16:46:23","2","2020-04-01 16:46:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 16:46:24","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":["7871","RENT","\u9810\u7e73\u79df\u91d1",5,899,"MO","1",899,"2","2020-04-01 16:46:23","2","2020-04-01 16:46:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 16:46:24","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":["7871","RENT","\u9810\u7e73\u79df\u91d1",6,899,"MO","1",899,"2","2020-04-01 16:46:23","2","2020-04-01 16:46:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 16:46:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5394,0,"7871"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-01 16:46:24","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":[974,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207518","2020-04-01 16:46:23",5394,"2","2020-04-01 16:46:23","2","2020-04-01 16:46:23","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 16:46:24","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":["7518","DEPOSIT",null,"PAID","2020-04-01 16:46:23",0,"2","2020-04-01 16:46:23","2","2020-04-01 16:46:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 16:46:24","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":["7518","INVOICE","7871","PAID","2020-04-01 16:46:23",5394,"2","2020-04-01 16:46:23","2","2020-04-01 16:46:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 18:40: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=441&filter3=undefined&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":255,"customer_code":"C160255","identity_type":"PERSONAL","identity_id":"z621367(8)","title":"Mr","lastname":"Yeung","firstname":"Chung Bo","companyname":"","email":"hungfuyeung@hotmail.com","tel":"67442523","address":"Room,G 3\/F King's House 971,King's Road Quarry Bay Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"899.0","renew_rent_month":"6","renew_warehousing_date":"2020-04-03","renew_room_key":"053,05260","renew_remark":"6 months contract. Storage rental paid by cash deposit on September 30, 2019. Storage deposit transferred from agreement A12-CT194696 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196170, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[{"master_room_discount_id":"71","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"829.90","discount":"16.84","monthly_deduct":168.0632,"room_id":"251","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"251","room_code":"D55","retail_price":"998.0","discounted_price":829.9,"location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":899,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":10788,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-03","rent_from":"2020-04-03","rent_to":"2021-04-02","delivery_service":"0","remark":"12 months contract. $300 Maxim coupon will be provided. Storage rental $10800 paid by bank transfer on Apr 01,2020. Extra $12 will count into the next contract. Storage deposit transferred from agreement A12-CT196170 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":10788,"final_order_total":10788,"location_id":"1","branch_id":"1","company_id":"1","room_key":"053,05260","order_product":[],"pass":true}},"first_order_id":"4696","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\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\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\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 \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> D55 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \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-01 18:40:53","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",255,"NEW","A12-CT207544",998,899,0,0,"12","12",10788,10788,10788,"2020-04-01 18:40:53","0",null,null,null,"2020-04-03","2021-04-02","12 months contract. $300 Maxim coupon will be provided. Storage rental $10800 paid by bank transfer on Apr 01,2020. Extra $12 will count into the next contract. Storage deposit transferred from agreement A12-CT196170 to this agreement.","2020-04-03","12",0,null,0,"0","2","2020-04-01 18:40:53","2","2020-04-01 18:40:53","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"053,05260","C160255","PERSONAL","Mr","+X90jh0S+STlWTkQgJHq9A==","0IE6jeWdSRK4n3kDzgwX0g==","","Tv0pyDcZDb6AsTuL6ZwhZKpIokSfPLtSjYZ8z\/JuLLlGSM\/7kd287CJfZq9V9F4dtJx23gg1eWN3707md2pmjw==","agbCTbJPLQF0ijbu\/LvlcQ==","6ejsJ0fbra934lrwunopRDHHtZFmZPF0H3ZLUyp4PfM=","io3eXkek9csMPHdkgJw1ZQ==",null,1,"4696"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 18:40:53","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":["7544","71","6","251","%","16.84",168.0632,"2","2020-04-01 18:40:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 18:40:53","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":["7544","251","998.0",829.9,"2","2020-04-01 18:40:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 18:40:53","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","2021-04-02","251"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-01 18:40:53","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":["7544",255,"SETTLED","A12-I207872","2020-04-01 18:40:53","2020-04-03","2","2020-04-01 18:40:53","2","2020-04-01 18:40:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 18:40:53","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":["7872","RENT","\u9810\u7e73\u79df\u91d1",1,899,"MO","1",899,"2","2020-04-01 18:40:53","2","2020-04-01 18:40:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 18:40:53","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":["7872","RENT","\u9810\u7e73\u79df\u91d1",2,899,"MO","1",899,"2","2020-04-01 18:40:53","2","2020-04-01 18:40:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 18:40:53","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":["7872","RENT","\u9810\u7e73\u79df\u91d1",3,899,"MO","1",899,"2","2020-04-01 18:40:53","2","2020-04-01 18:40:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 18:40:53","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":["7872","RENT","\u9810\u7e73\u79df\u91d1",4,899,"MO","1",899,"2","2020-04-01 18:40:53","2","2020-04-01 18:40:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 18:40:53","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":["7872","RENT","\u9810\u7e73\u79df\u91d1",5,899,"MO","1",899,"2","2020-04-01 18:40:53","2","2020-04-01 18:40:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 18:40:53","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":["7872","RENT","\u9810\u7e73\u79df\u91d1",6,899,"MO","1",899,"2","2020-04-01 18:40:53","2","2020-04-01 18:40:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 18:40:53","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":["7872","RENT","\u9810\u7e73\u79df\u91d1",7,899,"MO","1",899,"2","2020-04-01 18:40:53","2","2020-04-01 18:40:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 18:40:53","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":["7872","RENT","\u9810\u7e73\u79df\u91d1",8,899,"MO","1",899,"2","2020-04-01 18:40:53","2","2020-04-01 18:40:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 18:40:53","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":["7872","RENT","\u9810\u7e73\u79df\u91d1",9,899,"MO","1",899,"2","2020-04-01 18:40:53","2","2020-04-01 18:40:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 18:40:53","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":["7872","RENT","\u9810\u7e73\u79df\u91d1",10,899,"MO","1",899,"2","2020-04-01 18:40:53","2","2020-04-01 18:40:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 18:40:53","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":["7872","RENT","\u9810\u7e73\u79df\u91d1",11,899,"MO","1",899,"2","2020-04-01 18:40:53","2","2020-04-01 18:40:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 18:40:53","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":["7872","RENT","\u9810\u7e73\u79df\u91d1",12,899,"MO","1",899,"2","2020-04-01 18:40:53","2","2020-04-01 18:40:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 18:40:53","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10788,0,"7872"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-01 18:40:53","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":[255,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207519","2020-04-01 18:40:53",10788,"2","2020-04-01 18:40:53","2","2020-04-01 18:40:53","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 18:40:53","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":["7519","DEPOSIT",null,"PAID","2020-04-01 18:40:53",0,"2","2020-04-01 18:40:53","2","2020-04-01 18:40:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-01 18:40:53","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":["7519","INVOICE","7872","PAID","2020-04-01 18:40:53",10788,"2","2020-04-01 18:40:53","2","2020-04-01 18:40:53"]},"data_before":[],"data_after":[],"step":1} *****