{"created_at":"2020-05-21 00:53:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:07:22","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=835&filter3=undefined","floor_plan_rent_room":{"1":{"room_id":"1725","master_room_id":"243","room_code":"WC-32"}},"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":275,"customer_code":"C170275","identity_type":"PERSONAL","identity_id":"P935426(7)","title":"Ms","lastname":"Au","firstname":"Shing San","companyname":"","email":null,"tel":"68750303","address":"\u77f3\u6392\u7063\u90a8\u78a7\u8f1d\u6a13707\u5ba4","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1535.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-19","renew_room_key":"133,2756","renew_remark":"1 month contract. Storage rental paid by cash on April 21, 2020. Storage deposit transferred from agreement A12-CT207236 to this agreement.
\u820a\u5408\u7d04\u7de8\u865f: A12-CT207427, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207683, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"11","order_discount":[],"order_room":[{"room_id":"373","room_code":"G14","retail_price":"1768.0","discounted_price":"1768.00","location_id":"1"}],"roughly_size":"24","total_retail_price":1768,"total_discounted_price":1535,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1535,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-19","rent_from":"2020-05-19","rent_to":"2020-06-18","delivery_service":"0","remark":"1 month contract. Storage rental paid by cash on May 21, 2020. Storage deposit transferred from agreement A12-CT207683 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":1535,"final_order_total":1535,"location_id":"1","branch_id":"1","company_id":"1","room_key":"133,2756","order_product":[],"pass":true}},"first_order_id":"4776","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>
G14 <\/td>\r\n\t\t\t\t\t	4X6X8 <\/td>\r\n\t\t\t\t\t	$1768.00 <\/td>\r\n\t\t\t\t	N\/A <\/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":"24","total_discounted_price":"1535.0","deposit":"0","total_retail_price":"1768.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:07:23","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",275,"NEW","A12-CT207909",1768,1535,0,0,"1","1",1535,1535,1535,"2020-05-21 10:07:23","0",null,null,null,"2020-05-19","2020-06-18","1 month contract. Storage rental paid by cash on May 21, 2020. Storage deposit transferred from agreement A12-CT207683 to this agreement.","2020-05-19","24",0,null,0,"0","2","2020-05-21 10:07:22","2","2020-05-21 10:07:22","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"133,2756","C170275","PERSONAL","Ms","EFxpJJXvWP6pxqsrB6e4rw==","egeOlBPCZ2i\/hzcvvQMisg==","","cfhLoHunuImSyfV\/aZ+b9adtcjA+s\/\/16tHC7+KYDRk=","rzzwlkWLr5BLkj5wjDqTZQ==",null,"djxx0GEU1zjEGX4LvLIgug==",null,1,"4776"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:07:23","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":["7909","373","1768.0","1768.00","2","2020-05-21 10:07:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:07:23","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-05-19","2020-06-18","373"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-21 10:07:23","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":["7909",275,"SETTLED","A12-I208238","2020-05-21 10:07:22","2020-05-19","2","2020-05-21 10:07:22","2","2020-05-21 10:07:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:07:23","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":["8238","RENT","\u9810\u7e73\u79df\u91d1",1,1535,"MO","1",1535,"2","2020-05-21 10:07:22","2","2020-05-21 10:07:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:07:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1535,0,"8238"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-21 10:07:23","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":[275,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207882","2020-05-21 10:07:22",1535,"2","2020-05-21 10:07:22","2","2020-05-21 10:07:22","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:07:23","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":["7882","DEPOSIT",null,"PAID","2020-05-21 10:07:22",0,"2","2020-05-21 10:07:22","2","2020-05-21 10:07:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:07:23","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":["7882","INVOICE","8238","PAID","2020-05-21 10:07:22",1535,"2","2020-05-21 10:07:22","2","2020-05-21 10:07:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:35: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":"filter1=2&filter2=835&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":{"1":{"room_id":"1725","master_room_id":"243","room_code":"WC-32"}},"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":352,"customer_code":"C170352","identity_type":"PERSONAL","identity_id":"D191319(1)","title":"Mr","lastname":"Wong","firstname":"Wai Tung","companyname":"","email":null,"tel":"93328739","address":"\u9999\u6e2f\u4ed4\u7530\u7063\u6f01\u7372\u88571B\u5730\u4e0b","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1286.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-19","renew_room_key":"137,15409","renew_remark":"1 month contract. Storage rental paid by bank transfer on April 21, 2020. Storage deposit transferred from agreement A12-CT207030 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207690, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"363","room_code":"G04","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1205,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3615,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-19","rent_from":"2020-05-19","rent_to":"2020-08-18","delivery_service":"0","remark":"3 month contract. One special renewal gift. Storage rental paid by bank transfer on May 20, 2020. Storage deposit transferred from agreement A12-CT207690 to this agreement.\r\n\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3615,"final_order_total":3615,"location_id":"1","branch_id":"1","company_id":"1","room_key":"137,15409","order_product":[],"pass":true}},"first_order_id":"4204","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> G04 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/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":"20","total_discounted_price":"1205.00","deposit":"0.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:35: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",352,"NEW","A12-CT207910",1528,1205,0,0,"3","3",3615,3615,3615,"2020-05-21 10:35:12","0",null,null,null,"2020-05-19","2020-08-18","3 month contract. One special renewal gift. Storage rental paid by bank transfer on May 20, 2020. Storage deposit transferred from agreement A12-CT207690 to this agreement.\r\n\r\n","2020-05-19","20",0,null,0,"0","2","2020-05-21 10:35:12","2","2020-05-21 10:35:12","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"137,15409","C170352","PERSONAL","Mr","pWrJOV90xuuT\/EsMi5zpRQ==","hULSwM2MvFtpeV9\/z+er8Q==","","43c0wx7jnHnQaf25o1D24omsNW+NEZgIX2w74kCKE40OIxx1GWQaur5hnqjVXQj2","H2VJhOiErpJD6+CKFX26Dg==",null,"XHOvAEI8sL85yYAiFwYkGw==",null,1,"4204"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:35: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":["7910","363","1528.0","1528.00","2","2020-05-21 10:35:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:35: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-05-19","2020-08-18","363"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-21 10:35: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":["7910",352,"SETTLED","A12-I208239","2020-05-21 10:35:12","2020-05-19","2","2020-05-21 10:35:12","2","2020-05-21 10:35:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:35: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":["8239","RENT","\u9810\u7e73\u79df\u91d1",1,1205,"MO","1",1205,"2","2020-05-21 10:35:12","2","2020-05-21 10:35:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:35: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":["8239","RENT","\u9810\u7e73\u79df\u91d1",2,1205,"MO","1",1205,"2","2020-05-21 10:35:12","2","2020-05-21 10:35:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:35: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":["8239","RENT","\u9810\u7e73\u79df\u91d1",3,1205,"MO","1",1205,"2","2020-05-21 10:35:12","2","2020-05-21 10:35:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:35:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3615,0,"8239"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-21 10:35: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":[352,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207883","2020-05-21 10:35:12",3615,"2","2020-05-21 10:35:12","2","2020-05-21 10:35:12","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:35: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":["7883","DEPOSIT",null,"PAID","2020-05-21 10:35:12",0,"2","2020-05-21 10:35:12","2","2020-05-21 10:35:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:35: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":["7883","INVOICE","8239","PAID","2020-05-21 10:35:12",3615,"2","2020-05-21 10:35:12","2","2020-05-21 10:35:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:40:44","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=835&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":{"1":{"room_id":"1725","master_room_id":"243","room_code":"WC-32"}},"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":565,"customer_code":"C170565","identity_type":"PERSONAL","identity_id":"H308480","title":"Ms","lastname":"Lam","firstname":"Mei Chan","companyname":"","email":null,"tel":"61281018","address":"Room 1314,Tin Kin House,Tin Wan Estate ,Aberdeen , HK","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1139.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-24","renew_room_key":"054,18962,189,28766","renew_remark":"6 months contract. Storage rental paid by cash on Nov 23, 2019. Storage deposit transferred from agreement A14-CT195047 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196493, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"38","order_discount":[],"order_room":[{"room_id":"434","room_code":"J16","retail_price":"1528.0","discounted_price":"1528.00","location_id":"2"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1139,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6834,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-24","rent_from":"2020-05-24","rent_to":"2020-11-23","delivery_service":"0","remark":"6 months contract. Storage rental paid by cash on May 21, 2020. Storage deposit transferred from agreement A14-CT196493 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":6834,"final_order_total":6834,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,18962,189,28766","order_product":[],"pass":true}},"first_order_id":"3653","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> J16 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.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":"20","total_discounted_price":"1139.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:40: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",565,"NEW","A14-CT207911",1528,1139,0,0,"6","6",6834,6834,6834,"2020-05-21 10:40:45","0",null,null,null,"2020-05-24","2020-11-23","6 months contract. Storage rental paid by cash on May 21, 2020. Storage deposit transferred from agreement A14-CT196493 to this agreement.\r\n","2020-05-24","20",0,null,0,"0","2","2020-05-21 10:40:44","2","2020-05-21 10:40:44","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"054,18962,189,28766","C170565","PERSONAL","Ms","rM86ey2RcH6QLNDvCHIYQQ==","0JxYUqbNPOvgfMwVa0l0NA==","","WZ7RFKY1La2JChA9UoKupds6ez4VlawZfnPC8GB6\/JgeagWPF8q+8PTYpBgQlQqFhvXqKXBLp795bR7\/9qSPhw==","dhkrZLpk+aKJk8OoKtak5Q==",null,"IOvHTv8X8yVWycq+30wM5A==",null,1,"3653"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:40: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":["7911","434","1528.0","1528.00","2","2020-05-21 10:40:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:40: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-05-24","2020-11-23","434"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-21 10:40: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":["7911",565,"SETTLED","A14-I208240","2020-05-21 10:40:44","2020-05-24","2","2020-05-21 10:40:44","2","2020-05-21 10:40:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:40: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":["8240","RENT","\u9810\u7e73\u79df\u91d1",1,1139,"MO","1",1139,"2","2020-05-21 10:40:44","2","2020-05-21 10:40:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:40: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":["8240","RENT","\u9810\u7e73\u79df\u91d1",2,1139,"MO","1",1139,"2","2020-05-21 10:40:44","2","2020-05-21 10:40:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:40: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":["8240","RENT","\u9810\u7e73\u79df\u91d1",3,1139,"MO","1",1139,"2","2020-05-21 10:40:44","2","2020-05-21 10:40:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:40: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":["8240","RENT","\u9810\u7e73\u79df\u91d1",4,1139,"MO","1",1139,"2","2020-05-21 10:40:44","2","2020-05-21 10:40:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:40: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":["8240","RENT","\u9810\u7e73\u79df\u91d1",5,1139,"MO","1",1139,"2","2020-05-21 10:40:44","2","2020-05-21 10:40:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:40: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":["8240","RENT","\u9810\u7e73\u79df\u91d1",6,1139,"MO","1",1139,"2","2020-05-21 10:40:44","2","2020-05-21 10:40:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:40:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6834,0,"8240"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-21 10:40: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":[565,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207884","2020-05-21 10:40:44",6834,"2","2020-05-21 10:40:44","2","2020-05-21 10:40:44","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:40: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":["7884","DEPOSIT",null,"PAID","2020-05-21 10:40:44",0,"2","2020-05-21 10:40:44","2","2020-05-21 10:40:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:40: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":["7884","INVOICE","8240","PAID","2020-05-21 10:40:44",6834,"2","2020-05-21 10:40:44","2","2020-05-21 10:40:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:44:17","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=835&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":{"1":{"room_id":"1725","master_room_id":"243","room_code":"WC-32"}},"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":798,"customer_code":"C180798","identity_type":"PERSONAL","identity_id":"Z916749(9)","title":"Mr","lastname":"Lo","firstname":"Ka Chun","companyname":"","email":"loka0039@gmai.com","tel":"96670730","address":"Flat 3107, 31\/F, Tin Chak House, Tin Wan Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-21","renew_room_key":"055,32980","renew_remark":"1 month contract. Storage rental paid by bank transfer on March 20, 2020. Storage deposit transferred from agreement A12-CT207237 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207454, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"279","room_code":"E06","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":1038,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":2076,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-21","rent_from":"2020-04-21","rent_to":"2020-06-20","delivery_service":"0","remark":"2 month contract. Storage rental paid by bank transfer on April 21 and May 21, 2020. Storage deposit transferred from agreement A12-CT207454 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2076,"final_order_total":2076,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,32980","order_product":[],"pass":true}},"first_order_id":"4789","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> E06 <\/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":"1038.00","deposit":"0.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:44:17","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",798,"NEW","A12-CT207912",998,1038,0,0,"2","2",2076,2076,2076,"2020-05-21 10:44:17","0",null,null,null,"2020-04-21","2020-06-20","2 month contract. Storage rental paid by bank transfer on April 21 and May 21, 2020. Storage deposit transferred from agreement A12-CT207454 to this agreement.\r\n","2020-04-21","12",0,null,0,"0","2","2020-05-21 10:44:17","2","2020-05-21 10:44:17","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,32980","C180798","PERSONAL","Mr","51MA8AWBJt370WUqsUeCnw==","4w4biS+jM\/Q3DAzxHdf3pA==","","mMzQ1c7IXnG31el3pMn+cAlVmwOEO8RAHQZJFRSLNV\/SmYFvT5hQ\/KG4Is71QjPxXCoAkN9ubgFw5NXyRPui2oMB3Uo2T5sIHAA\/TnArqac=","iu3rJGYyixnPHEo1U9vPkA==","vSxCV4H9VfvlX9eKdpf+03ZOzigLaCc\/nH8UtdLNTfM=","L8wtX\/W+agotXtDfSAWTVA==",null,1,"4789"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:44:17","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":["7912","279","998.0","998.00","2","2020-05-21 10:44:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:44:17","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-21","2020-06-20","279"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-21 10:44:17","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":["7912",798,"SETTLED","A12-I208241","2020-05-21 10:44:17","2020-04-21","2","2020-05-21 10:44:17","2","2020-05-21 10:44:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:44:17","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":["8241","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-05-21 10:44:17","2","2020-05-21 10:44:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:44:17","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":["8241","RENT","\u9810\u7e73\u79df\u91d1",2,1038,"MO","1",1038,"2","2020-05-21 10:44:17","2","2020-05-21 10:44:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:44:17","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2076,0,"8241"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-21 10:44:17","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":[798,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207885","2020-05-21 10:44:17",2076,"2","2020-05-21 10:44:17","2","2020-05-21 10:44:17","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:44:17","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":["7885","DEPOSIT",null,"PAID","2020-05-21 10:44:17",0,"2","2020-05-21 10:44:17","2","2020-05-21 10:44:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 10:44:17","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":["7885","INVOICE","8241","PAID","2020-05-21 10:44:17",2076,"2","2020-05-21 10:44:17","2","2020-05-21 10:44:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:03: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":"filter1=2&filter2=835&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":{"1":{"room_id":"1725","master_room_id":"243","room_code":"WC-32"}},"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":473,"customer_code":"C170473","identity_type":"BUSINESS","identity_id":"62956473","title":"Mr","lastname":"Sherer","firstname":"Christopher Graeme","companyname":"The Standing Desk Company Limited ","email":null,"tel":"54343654","address":"Flat B,17\/F, Tower 2 ,Victoria Garden ,301 Victoria Road, Pokfulam","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1788.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-27","renew_room_key":"136,43924","renew_remark":"6 months contract. Storage rental paid by bank transfer on December 12, 2018. Storage deposit transferred from agreement A12-CT183490 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196684, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"33","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"34","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"34","room_code":"A34","retail_price":"1098.0","discounted_price":989,"location_id":"1"},{"room_id":"33","room_code":"A33","retail_price":"1098.0","discounted_price":989,"location_id":"1"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":1788,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":10728,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-27","rent_from":"2020-05-27","rent_to":"2020-11-26","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on May 20, 2020. Storage deposit transferred from agreement A12-CT196684 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":10728,"final_order_total":10728,"location_id":"1","branch_id":"1","company_id":"1","room_key":"136,43924","order_product":[],"pass":true}},"first_order_id":"3490","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> A34 <\/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> A33 <\/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>\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":"32","total_discounted_price":"1788.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:03:59","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",473,"NEW","A12-CT207913",2196,1788,0,0,"6","6",10728,10728,10728,"2020-05-21 11:03:59","0",null,null,null,"2020-05-27","2020-11-26","6 months contract. Storage rental paid by bank transfer on May 20, 2020. Storage deposit transferred from agreement A12-CT196684 to this agreement.\r\n","2020-05-27","32",0,null,0,"0","2","2020-05-21 11:03:59","2","2020-05-21 11:03:59","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"136,43924","C170473","BUSINESS","Mr","1rb0nEgOlze\/p9C\/7bvKfDEMclPxlmTY5C3bwRjG18I=","SbnQ6bHKYaFNN5Jdk\/cmiw==","The Standing Desk Company Limited ","UCFP5ulLSQBHA9YjFE8ClSoB4Utyjqeg87aNUtxv2nMyjqvaIRLVv5V57h6nv7O48Ahaq+TthG3Wgzjm+qW3e2INHdHG+Lrc2KepjEO6jNU=","C0E1XQ8sY1IrDlv\/xMfmTQ==",null,null,"PPHvnmE7WOdWBKMit2aXxQ==",1,"3490"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:03:59","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":["7913","72","8","33","%","9.93",109.0314,"2","2020-05-21 11:03:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:03:59","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":["7913","72","8","34","%","9.93",109.0314,"2","2020-05-21 11:03:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:03:59","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":["7913","34","1098.0",989,"2","2020-05-21 11:03:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:03:59","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-05-27","2020-11-26","34"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-21 11:03:59","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":["7913","33","1098.0",989,"2","2020-05-21 11:03:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:03:59","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-05-27","2020-11-26","33"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-21 11:03:59","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":["7913",473,"SETTLED","A12-I208242","2020-05-21 11:03:59","2020-05-27","2","2020-05-21 11:03:59","2","2020-05-21 11:03:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:03:59","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":["8242","RENT","\u9810\u7e73\u79df\u91d1",1,1788,"MO","1",1788,"2","2020-05-21 11:03:59","2","2020-05-21 11:03:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:03:59","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":["8242","RENT","\u9810\u7e73\u79df\u91d1",2,1788,"MO","1",1788,"2","2020-05-21 11:03:59","2","2020-05-21 11:03:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:03:59","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":["8242","RENT","\u9810\u7e73\u79df\u91d1",3,1788,"MO","1",1788,"2","2020-05-21 11:03:59","2","2020-05-21 11:03:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:03:59","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":["8242","RENT","\u9810\u7e73\u79df\u91d1",4,1788,"MO","1",1788,"2","2020-05-21 11:03:59","2","2020-05-21 11:03:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:03:59","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":["8242","RENT","\u9810\u7e73\u79df\u91d1",5,1788,"MO","1",1788,"2","2020-05-21 11:03:59","2","2020-05-21 11:03:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:03:59","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":["8242","RENT","\u9810\u7e73\u79df\u91d1",6,1788,"MO","1",1788,"2","2020-05-21 11:03:59","2","2020-05-21 11:03:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:03:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10728,0,"8242"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-21 11:03:59","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":[473,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207886","2020-05-21 11:03:59",10728,"2","2020-05-21 11:03:59","2","2020-05-21 11:03:59","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:03:59","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":["7886","DEPOSIT",null,"PAID","2020-05-21 11:03:59",0,"2","2020-05-21 11:03:59","2","2020-05-21 11:03:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:03:59","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":["7886","INVOICE","8242","PAID","2020-05-21 11:03:59",10728,"2","2020-05-21 11:03:59","2","2020-05-21 11:03:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:16:05","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":"type=INVOICE","floor_plan_rent_room":{"1":{"room_id":"1725","master_room_id":"243","room_code":"WC-32"}},"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1123,"customer_code":"C181123","identity_type":"PERSONAL","identity_id":"D520836(0)","title":"Ms","lastname":"Wong","firstname":"Chi Ying Celia","companyname":"","email":"celiacwg@yahoo.com.hk","tel":"93038865","address":"14B, Kong Kai Building, 184 Aberdeen Main Road, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"981.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-26","renew_room_key":"0012401521","renew_remark":"12 months contract. Storage rental paid by bank transfer on November 20, 2019. Storage deposit $2180 transferred from agreement A05-CT183738 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196461, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"113","order_discount":[],"order_room":[{"room_id":"1108","room_code":"A05-106","retail_price":"1090.0","discounted_price":"1090.00","location_id":"4"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":981,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":11772,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"981.00","warehousing_date":"2020-05-26","rent_from":"2020-05-26","rent_to":"2021-06-25","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free and 2 special renewal gifts. Storage rental paid by bank transfer on May 19 & 20, 2020. Storage deposit $2180 transferred from agreement A05-CT196461 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":981,"order_total":12753,"final_order_total":11772,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012401521","order_product":[],"pass":true}},"first_order_id":"3738","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> A05-106 <\/td>\r\n\t\t\t\t\t 4X3X7 <\/td>\r\n\t\t\t\t\t $1090.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":"12","total_discounted_price":"981.00","deposit":"0.00","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:16:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1123,"NEW","A05-CT207914",1090,981,0,0,"13","13",11772,12753,11772,"2020-05-21 11:16:05","0",null,null,null,"2020-05-26","2021-06-25","13 months contract. Special offer the 13th month free and 2 special renewal gifts. Storage rental paid by bank transfer on May 19 & 20, 2020. Storage deposit $2180 transferred from agreement A05-CT196461 to this agreement. \r\n","2020-05-26","12",0,null,981,"981.00","2","2020-05-21 11:16:05","2","2020-05-21 11:16:05","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012401521","C181123","PERSONAL","Ms","ks8SgmwXVf+xp+UqH7ZTCA==","hULSwM2MvFtpeV9\/z+er8Q==","","yFcmwa\/5+MTdt4xpOZ2wQF3gvOfq7cRS3tgAt69WcnEmMMUBYpcfbzasGV+gwg9msqHgIjNWygosK7dq\/nxm4oQSHDtj970VPXkSKTabnGI=","XAFWgNivujmLugeeqWZTXQ==","E\/A3TMeR40xDT9BlPNhsWiMC9\/l\/c8OuYgf1+\/zRz7c=","YzFCld6wIavN96Mg3GXO7Q==",null,1,"3738"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:16:05","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":["7914","1108","1090.0","1090.00","2","2020-05-21 11:16:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:16:05","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-05-26","2021-06-25","1108"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-21 11:16:05","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":["7914",1123,"SETTLED","A05-I208243","2020-05-21 11:16:05","2020-05-26","2","2020-05-21 11:16:05","2","2020-05-21 11:16:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:16:05","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":["8243","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,981,"MO","1",981,"2","2020-05-21 11:16:05","2","2020-05-21 11:16:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:16:05","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":["8243","RENT","\u9810\u7e73\u79df\u91d1",3,981,"MO","1",981,"2","2020-05-21 11:16:05","2","2020-05-21 11:16:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:16:05","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":["8243","RENT","\u9810\u7e73\u79df\u91d1",4,981,"MO","1",981,"2","2020-05-21 11:16:05","2","2020-05-21 11:16:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:16:05","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":["8243","RENT","\u9810\u7e73\u79df\u91d1",5,981,"MO","1",981,"2","2020-05-21 11:16:05","2","2020-05-21 11:16:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:16:05","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":["8243","RENT","\u9810\u7e73\u79df\u91d1",6,981,"MO","1",981,"2","2020-05-21 11:16:05","2","2020-05-21 11:16:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:16:05","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":["8243","RENT","\u9810\u7e73\u79df\u91d1",7,981,"MO","1",981,"2","2020-05-21 11:16:05","2","2020-05-21 11:16:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:16:05","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":["8243","RENT","\u9810\u7e73\u79df\u91d1",8,981,"MO","1",981,"2","2020-05-21 11:16:05","2","2020-05-21 11:16:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:16:05","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":["8243","RENT","\u9810\u7e73\u79df\u91d1",9,981,"MO","1",981,"2","2020-05-21 11:16:05","2","2020-05-21 11:16:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:16:05","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":["8243","RENT","\u9810\u7e73\u79df\u91d1",10,981,"MO","1",981,"2","2020-05-21 11:16:05","2","2020-05-21 11:16:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:16:05","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":["8243","RENT","\u9810\u7e73\u79df\u91d1",11,981,"MO","1",981,"2","2020-05-21 11:16:05","2","2020-05-21 11:16:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:16:05","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":["8243","RENT","\u9810\u7e73\u79df\u91d1",12,981,"MO","1",981,"2","2020-05-21 11:16:05","2","2020-05-21 11:16:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:16:05","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":["8243","RENT","\u9810\u7e73\u79df\u91d1",13,981,"MO","1",981,"2","2020-05-21 11:16:05","2","2020-05-21 11:16:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:16:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11772,0,"8243"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-21 11:16:05","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":[1123,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207887","2020-05-21 11:16:05",11772,"2","2020-05-21 11:16:05","2","2020-05-21 11:16:05","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:16:05","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":["7887","DEPOSIT",null,"PAID","2020-05-21 11:16:05",0,"2","2020-05-21 11:16:05","2","2020-05-21 11:16:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 11:16:05","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":["7887","INVOICE","8243","PAID","2020-05-21 11:16:05",11772,"2","2020-05-21 11:16:05","2","2020-05-21 11:16:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:03:02","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","floor_plan_rent_room":{"1":{"room_id":"1725","master_room_id":"243","room_code":"WC-32"}},"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":380,"customer_code":"C170380","identity_type":"PERSONAL","identity_id":"K579139(1)","title":"Ms","lastname":"Chu","firstname":"Nga Hang Shirley","companyname":"","email":"chengtaib@yahoo.com.hk","tel":"92183530","address":"Flat C, 11\/F, BAYSHORE APARTMENTS, ABERDEEN","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"899.0","renew_rent_month":"13","renew_warehousing_date":"2020-05-23","renew_room_key":"053,56645","renew_remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by EPS on April 11, 2019. Storage deposit transferred from agreement A14-CT183349 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT194739, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"551","room_code":"L29","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":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":10788,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"899.00","warehousing_date":"2020-05-23","rent_from":"2020-05-23","rent_to":"2021-06-22","delivery_service":"0","remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by bank transfer on May 21, 2020. Storage deposit transferred from agreement A14-CT194739 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":899,"order_total":11687,"final_order_total":10788,"location_id":"2","branch_id":"1","company_id":"1","room_key":"053,56645","order_product":[],"pass":true}},"first_order_id":4739,"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> L29 <\/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\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.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:03:03","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",380,"NEW","A14-CT207915",998,899,0,0,"13","13",10788,11687,10788,"2020-05-21 13:03:03","0",null,null,null,"2020-05-23","2021-06-22","13 months contract. Special renewal offer, one month free. Storage rental paid by bank transfer on May 21, 2020. Storage deposit transferred from agreement A14-CT194739 to this agreement.\r\n","2020-05-23","12",0,null,899,"899.00","2","2020-05-21 13:03:02","2","2020-05-21 13:03:02","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"053,56645","C170380","PERSONAL","Ms","t5jCZKbtXLJEdrfvaT8aF2x02nlGV4Z+IgTkdNa4dU0=","uwdKi3S38jh5+tBibXKG4A==","","\/c5flL8uQOZubi9YEbSzcszd8VsiNuL0NukI84XQ4neLwC5aac2PlvfwPae5JpNA","mSxyqi9uP3V70lzenk7zLA==","V0HV9J3GBcWJtO5t+wKMA7Qt9EfBMLzTohKQCbSMexg=","DtwqsDe9FR1tEFeLOh21+w==",null,1,4739]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:03:03","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":["7915","551","998.0","998.00","2","2020-05-21 13:03:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:03:03","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-05-23","2021-06-22","551"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-21 13:03:03","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":["7915",380,"SETTLED","A14-I208244","2020-05-21 13:03:02","2020-05-23","2","2020-05-21 13:03:02","2","2020-05-21 13:03:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:03:03","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":["8244","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,899,"MO","1",899,"2","2020-05-21 13:03:02","2","2020-05-21 13:03:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:03:03","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":["8244","RENT","\u9810\u7e73\u79df\u91d1",3,899,"MO","1",899,"2","2020-05-21 13:03:02","2","2020-05-21 13:03:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:03:03","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":["8244","RENT","\u9810\u7e73\u79df\u91d1",4,899,"MO","1",899,"2","2020-05-21 13:03:02","2","2020-05-21 13:03:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:03:03","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":["8244","RENT","\u9810\u7e73\u79df\u91d1",5,899,"MO","1",899,"2","2020-05-21 13:03:02","2","2020-05-21 13:03:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:03:03","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":["8244","RENT","\u9810\u7e73\u79df\u91d1",6,899,"MO","1",899,"2","2020-05-21 13:03:02","2","2020-05-21 13:03:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:03:03","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":["8244","RENT","\u9810\u7e73\u79df\u91d1",7,899,"MO","1",899,"2","2020-05-21 13:03:02","2","2020-05-21 13:03:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:03:03","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":["8244","RENT","\u9810\u7e73\u79df\u91d1",8,899,"MO","1",899,"2","2020-05-21 13:03:02","2","2020-05-21 13:03:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:03:03","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":["8244","RENT","\u9810\u7e73\u79df\u91d1",9,899,"MO","1",899,"2","2020-05-21 13:03:02","2","2020-05-21 13:03:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:03:03","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":["8244","RENT","\u9810\u7e73\u79df\u91d1",10,899,"MO","1",899,"2","2020-05-21 13:03:02","2","2020-05-21 13:03:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:03:03","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":["8244","RENT","\u9810\u7e73\u79df\u91d1",11,899,"MO","1",899,"2","2020-05-21 13:03:02","2","2020-05-21 13:03:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:03:03","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":["8244","RENT","\u9810\u7e73\u79df\u91d1",12,899,"MO","1",899,"2","2020-05-21 13:03:02","2","2020-05-21 13:03:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:03:03","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":["8244","RENT","\u9810\u7e73\u79df\u91d1",13,899,"MO","1",899,"2","2020-05-21 13:03:02","2","2020-05-21 13:03:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:03:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10788,0,"8244"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-21 13:03:03","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":[380,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207888","2020-05-21 13:03:02",10788,"2","2020-05-21 13:03:02","2","2020-05-21 13:03:02","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:03:03","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":["7888","DEPOSIT",null,"PAID","2020-05-21 13:03:02",0,"2","2020-05-21 13:03:02","2","2020-05-21 13:03:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:03:03","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":["7888","INVOICE","8244","PAID","2020-05-21 13:03:02",10788,"2","2020-05-21 13:03:02","2","2020-05-21 13:03:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:47:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:47:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:53:56","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=1095&filter3=undefined","floor_plan_rent_room":{"1":{"room_id":"1725","master_room_id":"243","room_code":"WC-32"}},"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1095,"customer_code":"C181095","identity_type":"PERSONAL","identity_id":"R793663(9)","title":"Mr","lastname":"Sun","firstname":"Yiqian","companyname":"","email":"martysun@hotmail.com","tel":"92283757","address":"26B, Tower 3, Bel-Air On The Peak, 68 Bel-Air Peak Avenue, Pok Fu Lam, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3467.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-24","renew_room_key":"0012436780","renew_remark":"6 months contract. Storage rental paid by bank transfer on November 25, 2019. Storage deposit $7704 transferred from agreement A05-CT183687 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196508, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"117","order_discount":[],"order_room":[{"room_id":"1171","room_code":"A05-169","retail_price":"1857.0","discounted_price":"1857.00","location_id":"4"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1857,"deposit":5847,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":0,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"7704.00","warehousing_date":"2020-05-24","rent_from":"2020-05-24","rent_to":"2020-06-23","delivery_service":"0","remark":"1 month contract. Change unit from A05-169 170 to A05-169. Storage rental and deposit $7704 transferred from agreement A05-CT196508 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":7704,"order_total":7704,"final_order_total":0,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012436780","order_product":[],"pass":true}},"first_order_id":"3687","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\t\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\t\t\t\t \n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-169 <\/td>\n\t\t\t\t\t 4X6X7 <\/td>\n\t\t\t\t\t $1857.00 <\/td>\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\u522a\u9664<\/button>\n\t\t\t\t\t<\/td><\/tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\n\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1857.00","deposit":"5847.00","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:53: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","4",1095,"NEW","A05-CT207916",1857,1857,5847,0,"1","1",0,7704,0,"2020-05-21 13:53:57","0",null,null,null,"2020-05-24","2020-06-23","1 month contract. Change unit from A05-169 170 to A05-169. Storage rental and deposit $7704 transferred from agreement A05-CT196508 to this agreement. \r\n","2020-05-24","24",0,null,7704,"7704.00","2","2020-05-21 13:53:56","2","2020-05-21 13:53:56","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"0012436780","C181095","PERSONAL","Mr","qqjRDdjWhiqUdPPU41104Q==","LzP9SHKo1Nrvy+TUkpLNZA==","","j+d20gnWrVp1PCz4xLmN0lkAyq1cCNGJGcST5aCzQ52yqc735JBFs\/9E3f7j50aJ6TThQyNJUyrQ4lDzeCM0QoFKL8pxs1ZUXcppheZciQoPEkgWVVjWU+ECO80JSLCq","BSdqyE\/XLSz9sVAsKHmzRw==","MofAvfV12fBdZmc6n7NCVu4bRxwzHU+wkxsSp+YkAwY=","nBpBwuN2XCD\/Et4vTNP3SA==",null,1,"3687"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:53: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":["7916","1171","1857.0","1857.00","2","2020-05-21 13:53:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:53: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-05-24","2020-06-23","1171"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-21 13:53:57","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":["7916","A05-D205419","PAID",5847,0,"2020-06-23","2020-05-21 13:53:56","2020-05-21 13:53:56","2","2020-05-21 13:53:56","2","2020-05-21 13:53:56",1095]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:53: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":["7916",1095,"SETTLED","A05-I208245","2020-05-21 13:53:56","2020-05-24","2","2020-05-21 13:53:56","2","2020-05-21 13:53:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:53: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":["8245","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-21 13:53:56","2","2020-05-21 13:53:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:53:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[0,0,"8245"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-21 13:53: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":[1095,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207889","2020-05-21 13:53:56",5847,"2","2020-05-21 13:53:56","2","2020-05-21 13:53:56","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:53: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":["7889","DEPOSIT","5419","PAID","2020-05-21 13:53:56",5847,"2","2020-05-21 13:53:56","2","2020-05-21 13:53:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 13:53: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":["7889","INVOICE","8245","PAID","2020-05-21 13:53:56",0,"2","2020-05-21 13:53:56","2","2020-05-21 13:53:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 14:12:18","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=1095&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":{"1":{"room_id":"1725","master_room_id":"243","room_code":"WC-32"}},"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1425,"customer_code":"C191425","identity_type":"BUSINESS","identity_id":"2519978","title":"Mr","lastname":"Wong ","firstname":"Man Cheung","companyname":"Serene Capital Limited","email":"philipwong@certproperty.co.uk","tel":"90941892","address":"16A, 16\/F Chung Hing Commercial Building, 62 Connaught Road Central, Central, H.K.","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-17","renew_room_key":"0012450069","renew_remark":"1 month contract. Storage rental paid by PPS on April 22, 2020. Storage deposit $1196 transferred from agreement A12-CT207459 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207720, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"1","order_discount":[],"order_room":[{"room_id":"213","room_code":"D17","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-17","rent_from":"2020-05-17","rent_to":"2020-06-16","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on May 19, 2020. Storage deposit $1196 transferred from agreement A12-CT207720 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"1","branch_id":"1","company_id":"1","room_key":"0012450069","order_product":[],"pass":true}},"first_order_id":"3347","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> D17 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/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":"12","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 14:12: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","1",1425,"NEW","A12-CT207917",598,598,0,0,"1","1",598,598,598,"2020-05-21 14:12:19","0",null,null,null,"2020-05-17","2020-06-16","1 month contract. Storage rental paid by PPS on May 19, 2020. Storage deposit $1196 transferred from agreement A12-CT207720 to this agreement. \r\n","2020-05-17","12",0,null,0,"0","2","2020-05-21 14:12:18","2","2020-05-21 14:12:18","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0012450069","C191425","BUSINESS","Mr","G+w65JkR7AS+JT7hCDD+yg==","DgLsCGM4faTvgwjKBW9M0A==","Serene Capital Limited","S4o9AXA7eRky9fl+GI6ii2+TMoCmBDuByzpKzUF7jpxGD0QmypETmhNR0PVTCj612a7mYANU+Sc3i0encOiszMwjCriyODNCJhdNRzJhCfKfqggF6Ry9Getc\/0LKYKRN","CL6e4EkMiRzRr0Rve85mrw==","eLkWayCc4RkCZg6CrTQmBSr+4xmx9fTzOhnQ35wQOzA=",null,"JdjeYwtWISTCzDjjVIKzVw==",1,"3347"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 14:12: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":["7917","213","598.0","598.00","2","2020-05-21 14:12:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 14:12: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-05-17","2020-06-16","213"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-21 14:12: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":["7917",1425,"SETTLED","A12-I208246","2020-05-21 14:12:18","2020-05-17","2","2020-05-21 14:12:18","2","2020-05-21 14:12:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 14:12: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":["8246","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-05-21 14:12:18","2","2020-05-21 14:12:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 14:12:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8246"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-21 14:12: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":[1425,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207890","2020-05-21 14:12:18",598,"2","2020-05-21 14:12:18","2","2020-05-21 14:12:18","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 14:12: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":["7890","DEPOSIT",null,"PAID","2020-05-21 14:12:18",0,"2","2020-05-21 14:12:18","2","2020-05-21 14:12:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 14:12: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":["7890","INVOICE","8246","PAID","2020-05-21 14:12:18",598,"2","2020-05-21 14:12:18","2","2020-05-21 14:12:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 14:40:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 15:49:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 16:30:30","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=1399&filter3=undefined","floor_plan_rent_room":{"1":{"room_id":"1725","master_room_id":"243","room_code":"WC-32"}},"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1096,"customer_code":"C181096","identity_type":"PERSONAL","identity_id":"Z705774(2)","title":"Ms","lastname":"Hung","firstname":"Wan Fong","companyname":"","email":"iamraye@gmail.com","tel":"63895204","address":"Flat 2, 4\/F, Mei Fai Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"OTHER","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1162.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-17","renew_room_key":"0012476571","renew_remark":"6 months contract. Storage rental paid by PayMe on November 19, 2019. Storage deposit $6323 transferred from agreement A05-CT183640 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196548, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"114","order_discount":[],"order_room":[{"room_id":"1132","room_code":"A05-130","retail_price":"1290.0","discounted_price":"1290.00","location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":13944,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1162.00","warehousing_date":"2020-05-17","rent_from":"2020-05-17","rent_to":"2021-06-16","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. And 2 special renewal gifts. Storage rental paid by PPS on May 20, 2020. Storage deposit $6323 transferred from agreement A05-CT196548 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":1162,"order_total":15106,"final_order_total":13944,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012476571","order_product":[],"pass":true}},"first_order_id":"3640","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> A05-130 <\/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":"1162.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 16:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1096,"NEW","A05-CT207918",1290,1162,0,0,"13","13",13944,15106,13944,"2020-05-21 16:30:31","0",null,null,null,"2020-05-17","2021-06-16","13 months contract. Special offer the 13th month free. And 2 special renewal gifts. Storage rental paid by PPS on May 20, 2020. Storage deposit $6323 transferred from agreement A05-CT196548 to this agreement. \r\n","2020-05-17","16",0,null,1162,"1162.00","2","2020-05-21 16:30:30","2","2020-05-21 16:30:30","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0012476571","C181096","PERSONAL","Ms","mkLm3+uB2dZC6CizuguRmg==","jzEP8l3uGLPRnAeTDrWy2A==","","JpKitPDyzxuF1rTr3EZnw46sf7KsWzvmcZ5lrSnlcGwXI3a1mVhsvdcBzR\/kpdTIe9XOEihEpyDt8KQdo3EwYqD5y6A4rVD+1bzyIROF2ms=","mYq+\/D53WM9D3OkmEhEmeg==","dcP38zZF7UIc7rbNTrSqnEKr7ygGXpUZ0nrZltZ+P00=","2CXg7CskqyDMvZXdEaJxGg==",null,1,"3640"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 16:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7918","1132","1290.0","1290.00","2","2020-05-21 16:30:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 16:30:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-17","2021-06-16","1132"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-21 16:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7918",1096,"SETTLED","A05-I208247","2020-05-21 16:30:30","2020-05-17","2","2020-05-21 16:30:30","2","2020-05-21 16:30:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 16:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8247","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1162,"MO","1",1162,"2","2020-05-21 16:30:30","2","2020-05-21 16:30:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 16:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8247","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-05-21 16:30:30","2","2020-05-21 16:30:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 16:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8247","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-05-21 16:30:30","2","2020-05-21 16:30:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 16:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8247","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-05-21 16:30:30","2","2020-05-21 16:30:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 16:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8247","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-05-21 16:30:30","2","2020-05-21 16:30:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 16:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8247","RENT","\u9810\u7e73\u79df\u91d1",7,1162,"MO","1",1162,"2","2020-05-21 16:30:30","2","2020-05-21 16:30:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 16:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8247","RENT","\u9810\u7e73\u79df\u91d1",8,1162,"MO","1",1162,"2","2020-05-21 16:30:30","2","2020-05-21 16:30:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 16:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8247","RENT","\u9810\u7e73\u79df\u91d1",9,1162,"MO","1",1162,"2","2020-05-21 16:30:30","2","2020-05-21 16:30:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 16:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8247","RENT","\u9810\u7e73\u79df\u91d1",10,1162,"MO","1",1162,"2","2020-05-21 16:30:30","2","2020-05-21 16:30:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 16:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8247","RENT","\u9810\u7e73\u79df\u91d1",11,1162,"MO","1",1162,"2","2020-05-21 16:30:30","2","2020-05-21 16:30:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 16:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8247","RENT","\u9810\u7e73\u79df\u91d1",12,1162,"MO","1",1162,"2","2020-05-21 16:30:30","2","2020-05-21 16:30:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 16:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8247","RENT","\u9810\u7e73\u79df\u91d1",13,1162,"MO","1",1162,"2","2020-05-21 16:30:30","2","2020-05-21 16:30:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 16:30:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13944,0,"8247"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-21 16:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1096,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207891","2020-05-21 16:30:30",13944,"2","2020-05-21 16:30:30","2","2020-05-21 16:30:30","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 16:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7891","DEPOSIT",null,"PAID","2020-05-21 16:30:30",0,"2","2020-05-21 16:30:30","2","2020-05-21 16:30:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 16:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7891","INVOICE","8247","PAID","2020-05-21 16:30:30",13944,"2","2020-05-21 16:30:30","2","2020-05-21 16:30:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 16:57:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 17:01:58","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1454,"customer_code":"C191454","identity_type":"PERSONAL","identity_id":"Z105370(2)","title":"Ms","lastname":"CHAN","firstname":"Yuen Man Mandy","companyname":"","email":"kikibearymc@hotmail.com","tel":"64626114","address":"Rm 505,5\/F, Low Blk, Lei Moon Hse, Apleichau, HK","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"981.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-24","renew_room_key":"190,39670","renew_remark":"6 months contract. Special offer 5% discount. Storage rental and deposit paid by EPS on Nov 23,2019. Smartcard and padlock provided on Nov 23,2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT196491, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2180.0","renew_master_room_id":"201","order_discount":[],"order_room":[{"room_id":"1536","room_code":"A16-045","retail_price":"1090.0","discounted_price":"1090.00","location_id":"7"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":981,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5886,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-24","rent_from":"2020-05-24","rent_to":"2020-11-23","delivery_service":"0","remark":"6 months contract. Storage rental paid by EPS on May 21,2020. Storage deposit $2180 transferred from agreement A16-CT196491 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":5886,"final_order_total":5886,"location_id":"7","branch_id":"1","company_id":"1","room_key":"190,39670","order_product":[],"pass":true}},"first_order_id":6491,"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> A16-045 <\/td>\r\n\t\t\t\t\t 4X3X7 <\/td>\r\n\t\t\t\t\t $1090.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":"981.0","deposit":"0","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 17:01:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","7",1454,"NEW","A16-CT207919",1090,981,0,0,"6","6",5886,5886,5886,"2020-05-21 17:01:58","0",null,null,null,"2020-05-24","2020-11-23","6 months contract. Storage rental paid by EPS on May 21,2020. Storage deposit $2180 transferred from agreement A16-CT196491 to this agreement.","2020-05-24","12",0,null,0,"0","2","2020-05-21 17:01:58","2","2020-05-21 17:01:58","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"190,39670","C191454","PERSONAL","Ms","LFTJJ+mXvs43fWe0QMfFDA==","8BEgNhGpCR8jGkzUtrIcXg==","","eYkiTTltIR9bLdL+JteMB8GHygecLlnuHyhs6xfGR3K+\/FZk4azz1JgPmhOSYBiBRgPAA+2w+CQ25iRZkBa1cg==","q6VjeQaXcIReaGTiyFoCmw==","nLetdzflYweA5oGMwccunPHynHnNBbY8oRmAM+mL4Gs=","xVbwZgiDNJGlhqipSoRkzg==",null,1,6491]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 17:01:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7919","1536","1090.0","1090.00","2","2020-05-21 17:01:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 17:01:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-24","2020-11-23","1536"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-21 17:01:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7919",1454,"SETTLED","A16-I208248","2020-05-21 17:01:58","2020-05-24","2","2020-05-21 17:01:58","2","2020-05-21 17:01:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 17:01:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8248","RENT","\u9810\u7e73\u79df\u91d1",1,981,"MO","1",981,"2","2020-05-21 17:01:58","2","2020-05-21 17:01:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 17:01:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8248","RENT","\u9810\u7e73\u79df\u91d1",2,981,"MO","1",981,"2","2020-05-21 17:01:58","2","2020-05-21 17:01:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 17:01:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8248","RENT","\u9810\u7e73\u79df\u91d1",3,981,"MO","1",981,"2","2020-05-21 17:01:58","2","2020-05-21 17:01:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 17:01:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8248","RENT","\u9810\u7e73\u79df\u91d1",4,981,"MO","1",981,"2","2020-05-21 17:01:58","2","2020-05-21 17:01:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 17:01:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8248","RENT","\u9810\u7e73\u79df\u91d1",5,981,"MO","1",981,"2","2020-05-21 17:01:58","2","2020-05-21 17:01:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 17:01:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8248","RENT","\u9810\u7e73\u79df\u91d1",6,981,"MO","1",981,"2","2020-05-21 17:01:58","2","2020-05-21 17:01:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 17:01:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5886,0,"8248"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-21 17:01:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1454,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207892","2020-05-21 17:01:58",5886,"2","2020-05-21 17:01:58","2","2020-05-21 17:01:58","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 17:01:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7892","DEPOSIT",null,"PAID","2020-05-21 17:01:58",0,"2","2020-05-21 17:01:58","2","2020-05-21 17:01:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 17:01:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7892","INVOICE","8248","PAID","2020-05-21 17:01:58",5886,"2","2020-05-21 17:01:58","2","2020-05-21 17:01:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 18:10:48","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=1399&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":{"1":{"room_id":"1725","master_room_id":"243","room_code":"WC-32"}},"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":458,"customer_code":"C170458","identity_type":"PERSONAL","identity_id":"D254945(0)","title":"Mr","lastname":"Wong","firstname":"Tat Cheong","companyname":"","email":"tcwong@hotmail.com","tel":"91332981","address":"24FL,Flat F,Comfort Centre,108 Old Main Street","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1139.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-21","renew_room_key":"054,44788,190,62117","renew_remark":"6 months contract. Storage rental paid by PPS on November 20, 2019. Storage deposit transferred from agreement A14-CT195030 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196472, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"69","order_discount":[],"order_room":[{"room_id":"777","room_code":"P11","retail_price":"1250.0","discounted_price":"1250.00","location_id":"2"}],"roughly_size":"18","total_retail_price":1250,"total_discounted_price":1139,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6834,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-21","rent_from":"2020-05-21","rent_to":"2020-11-20","delivery_service":"0","remark":"6 months contract. Storage rental paid by PPS on May 20, 2020. Storage deposit transferred from agreement A14-CT196472 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":6834,"final_order_total":6834,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,44788,190,62117","order_product":[],"pass":true}},"first_order_id":"3659","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> P11 <\/td>\r\n\t\t\t\t\t 4X4.5X8 <\/td>\r\n\t\t\t\t\t $1250.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":"18","total_discounted_price":"1139.0","deposit":"0","total_retail_price":"1250.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 18:10: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",458,"NEW","A14-CT207920",1250,1139,0,0,"6","6",6834,6834,6834,"2020-05-21 18:10:49","0",null,null,null,"2020-05-21","2020-11-20","6 months contract. Storage rental paid by PPS on May 20, 2020. Storage deposit transferred from agreement A14-CT196472 to this agreement.\r\n","2020-05-21","18",0,null,0,"0","2","2020-05-21 18:10:48","2","2020-05-21 18:10:48","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,44788,190,62117","C170458","PERSONAL","Mr","e9x5+PfuQqWy\/l\/HsXK8pQ==","hULSwM2MvFtpeV9\/z+er8Q==","","3DEZRr98ulgkgXrUn7JCaH+gY51DajfHMVEe\/J0AGuZqWVfqUxtxbhkITvtMlLsm","xo\/+xeCxPubQAJx1A\/60iw==","prET2AyIMM71Rc63xmVdk0VXoKwjlF9mMB1J3o7OdoI=","NtgXBU8GNIMdRNEBJnEudQ==",null,1,"3659"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 18:10: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":["7920","777","1250.0","1250.00","2","2020-05-21 18:10:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 18:10: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-05-21","2020-11-20","777"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-21 18:10: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":["7920",458,"SETTLED","A14-I208249","2020-05-21 18:10:48","2020-05-21","2","2020-05-21 18:10:48","2","2020-05-21 18:10:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 18:10: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":["8249","RENT","\u9810\u7e73\u79df\u91d1",1,1139,"MO","1",1139,"2","2020-05-21 18:10:48","2","2020-05-21 18:10:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 18:10: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":["8249","RENT","\u9810\u7e73\u79df\u91d1",2,1139,"MO","1",1139,"2","2020-05-21 18:10:48","2","2020-05-21 18:10:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 18:10: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":["8249","RENT","\u9810\u7e73\u79df\u91d1",3,1139,"MO","1",1139,"2","2020-05-21 18:10:48","2","2020-05-21 18:10:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 18:10: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":["8249","RENT","\u9810\u7e73\u79df\u91d1",4,1139,"MO","1",1139,"2","2020-05-21 18:10:48","2","2020-05-21 18:10:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 18:10: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":["8249","RENT","\u9810\u7e73\u79df\u91d1",5,1139,"MO","1",1139,"2","2020-05-21 18:10:48","2","2020-05-21 18:10:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 18:10: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":["8249","RENT","\u9810\u7e73\u79df\u91d1",6,1139,"MO","1",1139,"2","2020-05-21 18:10:48","2","2020-05-21 18:10:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 18:10:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6834,0,"8249"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-21 18:10: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":[458,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207893","2020-05-21 18:10:48",6834,"2","2020-05-21 18:10:48","2","2020-05-21 18:10:48","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 18:10: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":["7893","DEPOSIT",null,"PAID","2020-05-21 18:10:48",0,"2","2020-05-21 18:10:48","2","2020-05-21 18:10:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 18:10: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":["7893","INVOICE","8249","PAID","2020-05-21 18:10:48",6834,"2","2020-05-21 18:10:48","2","2020-05-21 18:10:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 19:22: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":"filter1=2&filter2=1399&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":{"1":{"room_id":"1725","master_room_id":"243","room_code":"WC-32"}},"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":373,"customer_code":"C170373","identity_type":"PERSONAL","identity_id":"A810524(6)","title":"Ms","lastname":"Tang","firstname":"Wai Fong","companyname":"","email":"tang222888@hotmail.com","tel":"92668877","address":"Flat A,13\/F,Kaning Mansion,Aberdeen,Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3784.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-20","renew_room_key":"055,46666","renew_remark":"1 month contract. Storage rental paid by PPS on April 16, 2020. Storage deposit transferred from agreement A12-CT207414 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207660, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"409","room_code":"H19","retail_price":"1938.0","discounted_price":"1938.00","location_id":"1"},{"room_id":"86","room_code":"B34","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"62.5","total_retail_price":3466,"total_discounted_price":3784,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":3784,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-20","rent_from":"2020-04-20","rent_to":"2020-05-19","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on May 20, 2020. Storage deposit transferred from agreement A12-CT207660 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":3784,"final_order_total":3784,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,46666","order_product":[],"pass":true}},"first_order_id":"4881","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> H19 <\/td>\r\n\t\t\t\t\t 5X8.5X8 <\/td>\r\n\t\t\t\t\t $1938.00 <\/td>\r\n\t\t\t\t N\/A <\/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> B34 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/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":"62.5","total_discounted_price":"3784.0","deposit":"0","total_retail_price":"3466.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 19:22: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","1",373,"NEW","A12-CT207921",3466,3784,0,0,"1","1",3784,3784,3784,"2020-05-21 19:22:32","0",null,null,null,"2020-04-20","2020-05-19","1 month contract. Storage rental paid by PPS on May 20, 2020. Storage deposit transferred from agreement A12-CT207660 to this agreement.\r\n","2020-04-20","62.5",0,null,0,"0","2","2020-05-21 19:22:32","2","2020-05-21 19:22:32","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,46666","C170373","PERSONAL","Ms","nTGfHLdEIudAzJAvttiE\/g==","M7CfcmE2OSMlZOkNgaoDmQ==","","BXgfEt9fXMpUNvxC+2X229VwwYS6rNmHtxMS+n23vDnbhk3n3xs6q6u0V\/EvTko5","HCKjEGhRJ8yb3ZyyPfmQag==","jQ4ob3N7+u9PyWPiMEH+PWHdZ55bC9BctdRu99koSsw=","QQr8JjuTNOLQNSu7eSLB1g==",null,1,"4881"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 19:22: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":["7921","409","1938.0","1938.00","2","2020-05-21 19:22:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 19:22: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-20","2020-05-19","409"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-21 19:22: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":["7921","86","1528.0","1528.00","2","2020-05-21 19:22:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 19:22: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-20","2020-05-19","86"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-21 19:22: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":["7921",373,"SETTLED","A12-I208250","2020-05-21 19:22:32","2020-04-20","2","2020-05-21 19:22:32","2","2020-05-21 19:22:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 19:22: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":["8250","RENT","\u9810\u7e73\u79df\u91d1",1,3784,"MO","1",3784,"2","2020-05-21 19:22:32","2","2020-05-21 19:22:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 19:22:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3784,0,"8250"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-21 19:22: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":[373,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207894","2020-05-21 19:22:32",3784,"2","2020-05-21 19:22:32","2","2020-05-21 19:22:32","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 19:22: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":["7894","DEPOSIT",null,"PAID","2020-05-21 19:22:32",0,"2","2020-05-21 19:22:32","2","2020-05-21 19:22:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 19:22: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":["7894","INVOICE","8250","PAID","2020-05-21 19:22:32",3784,"2","2020-05-21 19:22:32","2","2020-05-21 19:22:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 19:33:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-21 19:33:35","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****