{"created_at":"2020-05-19 10:40:51","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":{"1":{"room_id":"1725","master_room_id":"243","room_code":"WC-32"}},"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":768,"customer_code":"C180768","identity_type":"PERSONAL","identity_id":"D555729(2)","title":"Ms","lastname":"Hui","firstname":"So Lan","companyname":"","email":null,"tel":"98016877","address":"Room 3225, Pik Ngan House, Shek Pai 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":"538.0","renew_rent_month":"6","renew_warehousing_date":"2020-04-09","renew_room_key":"137,10293","renew_remark":"6 months contract. Storage rental paid by bank transfer on November 24, 2019. Storage deposit transferred from agreement A14-CT195017 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196500, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"687","room_code":"N04","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-09","rent_from":"2020-04-09","rent_to":"2020-10-08","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on May 16, 2020. Storage deposit transferred from agreement A14-CT196500 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"2","branch_id":"1","company_id":"1","room_key":"137,10293","order_product":[],"pass":true}},"first_order_id":"3772","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>
N04 <\/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>	<\/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":"538.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 10:40:52","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",768,"NEW","A14-CT207891",598,538,0,0,"6","6",3228,3228,3228,"2020-05-19 10:40:52","0",null,null,null,"2020-04-09","2020-10-08","6 months contract. Storage rental paid by bank transfer on May 16, 2020. Storage deposit transferred from agreement A14-CT196500 to this agreement.\r\n","2020-04-09","12",0,null,0,"0","2","2020-05-19 10:40:51","2","2020-05-19 10:40:51","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"137,10293","C180768","PERSONAL","Ms","paDtpZrrMcGjNKeGi79MGg==","Uu\/X0ZeZROrQW5FJIWd7Ww==","","4XCGurGbYy3boRwTvr4mojADy0z2VnJpo3mEHEK1f\/U8y59e3gbMFBCoHQvLjGGI1EmTRGkL9PMYPyewNXGXoIhDCE3hflNqnPU5amiULd4=","O4GEwx88gSturFR4rz0v5w==",null,"6uriqWo9DisLZeaOE9qIgw==",null,1,"3772"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 10:40:52","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":["7891","687","598.0","598.00","2","2020-05-19 10:40:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 10:40:52","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-09","2020-10-08","687"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-19 10:40:52","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":["7891",768,"SETTLED","A14-I208220","2020-05-19 10:40:51","2020-04-09","2","2020-05-19 10:40:51","2","2020-05-19 10:40:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 10:40:52","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":["8220","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-05-19 10:40:51","2","2020-05-19 10:40:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 10:40:52","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":["8220","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-05-19 10:40:51","2","2020-05-19 10:40:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 10:40:52","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":["8220","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-05-19 10:40:51","2","2020-05-19 10:40:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 10:40:52","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":["8220","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-05-19 10:40:51","2","2020-05-19 10:40:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 10:40:52","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":["8220","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-05-19 10:40:51","2","2020-05-19 10:40:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 10:40:52","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":["8220","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-05-19 10:40:51","2","2020-05-19 10:40:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 10:40:52","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"8220"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-19 10:40:52","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":[768,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207864","2020-05-19 10:40:51",3228,"2","2020-05-19 10:40:51","2","2020-05-19 10:40:51","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 10:40:52","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":["7864","DEPOSIT",null,"PAID","2020-05-19 10:40:51",0,"2","2020-05-19 10:40:51","2","2020-05-19 10:40:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 10:40:52","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":["7864","INVOICE","8220","PAID","2020-05-19 10:40:51",3228,"2","2020-05-19 10:40:51","2","2020-05-19 10:40:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 10:43:51","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 10:45: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":"&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":768,"customer_code":"C180768","identity_type":"PERSONAL","identity_id":"D555729(2)","title":"Ms","lastname":"Hui","firstname":"So Lan","companyname":"","email":null,"tel":"98016877","address":"Room 3225, Pik Ngan House, Shek Pai 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":"538.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-11","renew_room_key":"137,10293","renew_remark":"6 months contract. Storage rental paid by bank transfer on November 24, 2019. Storage deposit transferred from agreement A14-CT195018 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196501, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"630","room_code":"M41","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-11","rent_from":"2020-05-11","rent_to":"2020-11-10","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on May 16, 2020. Storage deposit transferred from agreement A14-CT196501 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"2","branch_id":"1","company_id":"1","room_key":"137,10293","order_product":[],"pass":true}},"first_order_id":"3771","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> M41 <\/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> <\/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":"538.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 10:45: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","2",768,"NEW","A14-CT207892",598,538,0,0,"6","6",3228,3228,3228,"2020-05-19 10:45:05","0",null,null,null,"2020-05-11","2020-11-10","6 months contract. Storage rental paid by bank transfer on May 16, 2020. Storage deposit transferred from agreement A14-CT196501 to this agreement.\r\n","2020-05-11","12",0,null,0,"0","2","2020-05-19 10:45:05","2","2020-05-19 10:45:05","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"137,10293","C180768","PERSONAL","Ms","paDtpZrrMcGjNKeGi79MGg==","Uu\/X0ZeZROrQW5FJIWd7Ww==","","4XCGurGbYy3boRwTvr4mojADy0z2VnJpo3mEHEK1f\/U8y59e3gbMFBCoHQvLjGGI1EmTRGkL9PMYPyewNXGXoIhDCE3hflNqnPU5amiULd4=","O4GEwx88gSturFR4rz0v5w==",null,"6uriqWo9DisLZeaOE9qIgw==",null,1,"3771"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 10:45: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":["7892","630","598.0","598.00","2","2020-05-19 10:45:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 10:45: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-11","2020-11-10","630"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-19 10:45: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":["7892",768,"SETTLED","A14-I208221","2020-05-19 10:45:05","2020-05-11","2","2020-05-19 10:45:05","2","2020-05-19 10:45:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 10:45: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":["8221","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-05-19 10:45:05","2","2020-05-19 10:45:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 10:45: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":["8221","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-05-19 10:45:05","2","2020-05-19 10:45:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 10:45: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":["8221","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-05-19 10:45:05","2","2020-05-19 10:45:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 10:45: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":["8221","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-05-19 10:45:05","2","2020-05-19 10:45:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 10:45: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":["8221","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-05-19 10:45:05","2","2020-05-19 10:45:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 10:45: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":["8221","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-05-19 10:45:05","2","2020-05-19 10:45:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 10:45:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"8221"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-19 10:45: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":[768,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207865","2020-05-19 10:45:05",3228,"2","2020-05-19 10:45:05","2","2020-05-19 10:45:05","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 10:45: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":["7865","DEPOSIT",null,"PAID","2020-05-19 10:45:05",0,"2","2020-05-19 10:45:05","2","2020-05-19 10:45:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 10:45: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":["7865","INVOICE","8221","PAID","2020-05-19 10:45:05",3228,"2","2020-05-19 10:45:05","2","2020-05-19 10:45:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:15: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=1581&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":54,"customer_code":"C160054","identity_type":"PERSONAL","identity_id":"D339237(7)","title":"Mr","lastname":"Wong","firstname":"Siu Wai","companyname":"","email":"artsadvco@yahoo.com.hk","tel":"97588797","address":"\u9999\u6e2f\u4ed4\u6f01\u5149\u905345\u865f\u6f01\u6689\u82d1\u7f8e\u6689\u95a37\u5b57\u645f","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1286.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-15","renew_room_key":"138,29741","renew_remark":"1 month contract. Storage rental paid by PPS on April 6, 2020. Storage deposit transferred from agreement A12-CT207280 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207589, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[{"master_room_discount_id":"76","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1376.00","discount":"9.95","monthly_deduct":152.036,"room_id":"125","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"125","room_code":"C01","retail_price":"1528.0","discounted_price":1376,"location_id":"1"}],"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-04-15","rent_from":"2020-04-15","rent_to":"2020-10-14","delivery_service":"0","remark":"6 months contract. Storage rental paid by PPS on April 18, 2020. Storage deposit transferred from agreement A12-CT207589 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":6834,"final_order_total":6834,"location_id":"1","branch_id":"1","company_id":"1","room_key":"138,29741","order_product":[],"pass":true}},"first_order_id":"4407","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> C01 <\/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":"1139.00","deposit":"0.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:15: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",54,"NEW","A12-CT207893",1528,1139,0,0,"6","6",6834,6834,6834,"2020-05-19 13:15:23","0",null,null,null,"2020-04-15","2020-10-14","6 months contract. Storage rental paid by PPS on April 18, 2020. Storage deposit transferred from agreement A12-CT207589 to this agreement.\r\n","2020-04-15","20",0,null,0,"0","2","2020-05-19 13:15:22","2","2020-05-19 13:15:22","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"138,29741","C160054","PERSONAL","Mr","mMV5J7Rfft6JJpDQA9XypQ==","hULSwM2MvFtpeV9\/z+er8Q==","","eD6tjqVeKfxAQSMYm9AHnBkJ5hIG+AW0TS9NTrTNPmy8sb4gGLrOVGrxrpyRxTO4GzKuKO8TvjuGMWhra7oPug==","uQre4vjMJEjZYCpftinh0Q==","oTJWSVWZRAKoy\/KSfvVPXM4ckwr7o\/yBdit4khJKFMc=","rD1nW9Kk4kNwxMXbuMBBAQ==",null,1,"4407"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:15:23","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":["7893","76","10","125","%","9.95",152.036,"2","2020-05-19 13:15:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:15: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":["7893","125","1528.0",1376,"2","2020-05-19 13:15:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:15: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-04-15","2020-10-14","125"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-19 13:15: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":["7893",54,"SETTLED","A12-I208222","2020-05-19 13:15:22","2020-04-15","2","2020-05-19 13:15:22","2","2020-05-19 13:15:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:15: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":["8222","RENT","\u9810\u7e73\u79df\u91d1",1,1139,"MO","1",1139,"2","2020-05-19 13:15:22","2","2020-05-19 13:15:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:15: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":["8222","RENT","\u9810\u7e73\u79df\u91d1",2,1139,"MO","1",1139,"2","2020-05-19 13:15:22","2","2020-05-19 13:15:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:15: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":["8222","RENT","\u9810\u7e73\u79df\u91d1",3,1139,"MO","1",1139,"2","2020-05-19 13:15:22","2","2020-05-19 13:15:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:15: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":["8222","RENT","\u9810\u7e73\u79df\u91d1",4,1139,"MO","1",1139,"2","2020-05-19 13:15:22","2","2020-05-19 13:15:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:15: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":["8222","RENT","\u9810\u7e73\u79df\u91d1",5,1139,"MO","1",1139,"2","2020-05-19 13:15:22","2","2020-05-19 13:15:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:15: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":["8222","RENT","\u9810\u7e73\u79df\u91d1",6,1139,"MO","1",1139,"2","2020-05-19 13:15:22","2","2020-05-19 13:15:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:15:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6834,0,"8222"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-19 13:15: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":[54,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207866","2020-05-19 13:15:22",6834,"2","2020-05-19 13:15:22","2","2020-05-19 13:15:22","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:15: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":["7866","DEPOSIT",null,"PAID","2020-05-19 13:15:22",0,"2","2020-05-19 13:15:22","2","2020-05-19 13:15:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:15: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":["7866","INVOICE","8222","PAID","2020-05-19 13:15:22",6834,"2","2020-05-19 13:15:22","2","2020-05-19 13:15:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:20: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=1581&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":189,"customer_code":"C160189","identity_type":"PERSONAL","identity_id":"C613283(7)","title":"Mr","lastname":"Wong","firstname":"Chi Keung","companyname":"","email":"denniswongchikeung@gmail.com","tel":"94382594","address":"Flat A,5\/F, Keswick Court,3 Keswick Street,Causeway Bay, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"935.0","renew_rent_month":"13","renew_warehousing_date":"2020-05-20","renew_room_key":"055,04165","renew_remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by PPS on April 17, 2019. Storage deposit transferred from agreement A12-CT183320 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT194795, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"73","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"913.00","discount":"16.85","monthly_deduct":185.013,"room_id":"357","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"357","room_code":"F42","retail_price":"1098.0","discounted_price":913,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":935,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":11220,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-20","rent_from":"2020-05-20","rent_to":"2021-05-19","delivery_service":"0","remark":"12 months contract. Special renewal offer $300 Maxim's voucher. Storage rental paid by PPS on May 18, 2020. Storage deposit transferred from agreement A12-CT194795 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":11220,"final_order_total":11220,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,04165","order_product":[],"pass":true}},"first_order_id":4795,"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> F42 <\/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":"16","total_discounted_price":"935.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:20:33","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",189,"NEW","A12-CT207894",1098,935,0,0,"12","12",11220,11220,11220,"2020-05-19 13:20:33","0",null,null,null,"2020-05-20","2021-05-19","12 months contract. Special renewal offer $300 Maxim's voucher. Storage rental paid by PPS on May 18, 2020. Storage deposit transferred from agreement A12-CT194795 to this agreement.\r\n","2020-05-20","16",0,null,0,"0","2","2020-05-19 13:20:32","2","2020-05-19 13:20:32","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,04165","C160189","PERSONAL","Mr","0YVp7yRC0+J+gLHSYaOTYw==","hULSwM2MvFtpeV9\/z+er8Q==","","PznoC6muAEwVrOM\/vGjinH12x5hwlDLdt7JlYX8kpgtEXgTHKwZIhmCspBVP\/MUWBSJF6R7\/d9x7hHxfe8c5ENlhDI2ucjMkvU73Y5dA9ZA=","2KjZPe1UCIL9zYxul\/Dqkg==","2Sptn8t147VdhTBfqiEId1kAWbzDCH2FVFiHgxnwDo0=","CK4YQDsrW61lLkdh2r+n0Q==",null,1,4795]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:20:33","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":["7894","73","8","357","%","16.85",185.013,"2","2020-05-19 13:20:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:20:33","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":["7894","357","1098.0",913,"2","2020-05-19 13:20:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:20:33","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-20","2021-05-19","357"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-19 13:20:33","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":["7894",189,"SETTLED","A12-I208223","2020-05-19 13:20:32","2020-05-20","2","2020-05-19 13:20:32","2","2020-05-19 13:20:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:20:33","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":["8223","RENT","\u9810\u7e73\u79df\u91d1",1,935,"MO","1",935,"2","2020-05-19 13:20:32","2","2020-05-19 13:20:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:20:33","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":["8223","RENT","\u9810\u7e73\u79df\u91d1",2,935,"MO","1",935,"2","2020-05-19 13:20:32","2","2020-05-19 13:20:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:20:33","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":["8223","RENT","\u9810\u7e73\u79df\u91d1",3,935,"MO","1",935,"2","2020-05-19 13:20:32","2","2020-05-19 13:20:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:20:33","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":["8223","RENT","\u9810\u7e73\u79df\u91d1",4,935,"MO","1",935,"2","2020-05-19 13:20:32","2","2020-05-19 13:20:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:20:33","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":["8223","RENT","\u9810\u7e73\u79df\u91d1",5,935,"MO","1",935,"2","2020-05-19 13:20:32","2","2020-05-19 13:20:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:20:33","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":["8223","RENT","\u9810\u7e73\u79df\u91d1",6,935,"MO","1",935,"2","2020-05-19 13:20:32","2","2020-05-19 13:20:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:20:33","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":["8223","RENT","\u9810\u7e73\u79df\u91d1",7,935,"MO","1",935,"2","2020-05-19 13:20:32","2","2020-05-19 13:20:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:20:33","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":["8223","RENT","\u9810\u7e73\u79df\u91d1",8,935,"MO","1",935,"2","2020-05-19 13:20:32","2","2020-05-19 13:20:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:20:33","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":["8223","RENT","\u9810\u7e73\u79df\u91d1",9,935,"MO","1",935,"2","2020-05-19 13:20:32","2","2020-05-19 13:20:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:20:33","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":["8223","RENT","\u9810\u7e73\u79df\u91d1",10,935,"MO","1",935,"2","2020-05-19 13:20:32","2","2020-05-19 13:20:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:20:33","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":["8223","RENT","\u9810\u7e73\u79df\u91d1",11,935,"MO","1",935,"2","2020-05-19 13:20:32","2","2020-05-19 13:20:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:20:33","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":["8223","RENT","\u9810\u7e73\u79df\u91d1",12,935,"MO","1",935,"2","2020-05-19 13:20:32","2","2020-05-19 13:20:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:20:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11220,0,"8223"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-19 13:20:33","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":[189,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207867","2020-05-19 13:20:32",11220,"2","2020-05-19 13:20:32","2","2020-05-19 13:20:32","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:20:33","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":["7867","DEPOSIT",null,"PAID","2020-05-19 13:20:32",0,"2","2020-05-19 13:20:32","2","2020-05-19 13:20:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 13:20:33","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":["7867","INVOICE","8223","PAID","2020-05-19 13:20:32",11220,"2","2020-05-19 13:20:32","2","2020-05-19 13:20:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:04:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:13:35","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=1&filter2=1271&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":1271,"customer_code":"C191271","identity_type":"PERSONAL","identity_id":"K712755(3)","title":"Mr","lastname":"LAM","firstname":"Chi Wai","companyname":"","email":null,"tel":"92164311","address":"Room 2101, Ching Fai House, Tsz Ching Estate, Tsz Wan Shan, Kowloon ","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1619.0","renew_rent_month":"12","renew_warehousing_date":"2020-05-17","renew_room_key":"'0012449154","renew_remark":"12 months contract. Special offer 2 months free. Storage rental and deposit paid by bank transfer on May 14, 2019. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT194999, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1798.0","renew_master_room_id":"175","order_discount":[],"order_room":[{"room_id":"1352","room_code":"C15-046","retail_price":"1798.0","discounted_price":"1798.00","location_id":"6"}],"roughly_size":"32","total_retail_price":1798,"total_discounted_price":1798,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1798,"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 18, 2020. Storage deposit $1798 transferred from agreement C15-CT194999 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1798,"final_order_total":1798,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012449154","order_product":[],"pass":true}},"first_order_id":4999,"selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-046 <\/td>\r\n\t\t\t\t\t 4X8X6.5 <\/td>\r\n\t\t\t\t\t $1798.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":"32","total_discounted_price":"1798.00","deposit":"0.00","total_retail_price":"1798.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:13:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1271,"NEW","C15-CT207895",1798,1798,0,0,"1","1",1798,1798,1798,"2020-05-19 14:13:35","0",null,null,null,"2020-05-17","2020-06-16","1 month contract. Storage rental paid by PPS on May 18, 2020. Storage deposit $1798 transferred from agreement C15-CT194999 to this agreement. \r\n","2020-05-17","32",0,null,0,"0","2","2020-05-19 14:13:35","2","2020-05-19 14:13:35","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"'0012449154","C191271","PERSONAL","Mr","gRYbQt3pC62mUupe40WPwQ==","BLxWt7e4owYJMFkn6\/eeMQ==","","TRjEyvIacLdlB3\/BTvMBQ8s+Hedp2neB9QwS8\/VtPvYoFFhsPhCivmgyYY0I0p4pmtPDggtb2uBFb9BrJYjHC86L6DWB3nraLGtOU\/Zg+IA=","+Lhrg0tS4jJm1n1j9ILS9A==",null,"EqHubtgeNEG24y4Oi2L10g==",null,1,4999]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:13:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7895","1352","1798.0","1798.00","2","2020-05-19 14:13:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:13:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-17","2020-06-16","1352"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-19 14:13:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7895",1271,"SETTLED","C15-I208224","2020-05-19 14:13:35","2020-05-17","2","2020-05-19 14:13:35","2","2020-05-19 14:13:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:13:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8224","RENT","\u9810\u7e73\u79df\u91d1",1,1798,"MO","1",1798,"2","2020-05-19 14:13:35","2","2020-05-19 14:13:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:13:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1798,0,"8224"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-19 14:13:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1271,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207868","2020-05-19 14:13:35",1798,"2","2020-05-19 14:13:35","2","2020-05-19 14:13:35","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:13:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7868","DEPOSIT",null,"PAID","2020-05-19 14:13:35",0,"2","2020-05-19 14:13:35","2","2020-05-19 14:13:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:13:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7868","INVOICE","8224","PAID","2020-05-19 14:13:35",1798,"2","2020-05-19 14:13:35","2","2020-05-19 14:13:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:29: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=1581&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":311,"customer_code":"C170311","identity_type":"PERSONAL","identity_id":"K465007(7)","title":"Mr","lastname":"Lo","firstname":"Ho Yin Owen","companyname":"","email":"aumanoh@gmail.com","tel":"94816466","address":"Rm 1, 15\/F, Kong Tai Court, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"998.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-18","renew_room_key":"054,46524","renew_remark":"1 month contract. Storage rental paid by PPS on April 6, 2020. Storage deposit $1396 transferred from agreement A14-CT207338 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207590, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[{"master_room_discount_id":"470","master_room_id":"34","discount_type":"%","price":"998.00","disocunted_price":"949.00","discount":"4.91","monthly_deduct":49.0018,"room_id":"731","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"731","room_code":"O07","retail_price":"998.0","discounted_price":949,"location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":949,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2847,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-18","rent_from":"2020-04-18","rent_to":"2020-07-17","delivery_service":"0","remark":"3 month contract. Storage rental paid by PPS on May 18, 2020. Storage deposit $1396 transferred from agreement A14-CT207590 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":2847,"final_order_total":2847,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,46524","order_product":[],"pass":true}},"first_order_id":"4521","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> O07 <\/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":"949.00","deposit":"0.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:29:22","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",311,"NEW","A14-CT207896",998,949,0,0,"3","3",2847,2847,2847,"2020-05-19 14:29:22","0",null,null,null,"2020-04-18","2020-07-17","3 month contract. Storage rental paid by PPS on May 18, 2020. Storage deposit $1396 transferred from agreement A14-CT207590 to this agreement.\r\n","2020-04-18","12",0,null,0,"0","2","2020-05-19 14:29:22","2","2020-05-19 14:29:22","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,46524","C170311","PERSONAL","Mr","rCN1lNVsvQUEIb4CpJx1nQ==","4w4biS+jM\/Q3DAzxHdf3pA==","","UucV8Ifr0A3QD8t\/j4UcOkwkrTPm33ceBZgTGHCMj6A\/O47vut2lT34hVu5UQZtV","jhz+YIyFB3NZsNn7IDpl4g==","BsQLPUdVMtvEb+TZbZnmUf9xqaiffRvcCnuR9msGho8=","1b5I8lCuen+0vvfOkqGOwA==",null,1,"4521"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:29:22","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":["7896","470","34","731","%","4.91",49.0018,"2","2020-05-19 14:29:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:29:22","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":["7896","731","998.0",949,"2","2020-05-19 14:29:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:29:22","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-18","2020-07-17","731"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-19 14:29:22","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":["7896",311,"SETTLED","A14-I208225","2020-05-19 14:29:22","2020-04-18","2","2020-05-19 14:29:22","2","2020-05-19 14:29:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:29:22","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":["8225","RENT","\u9810\u7e73\u79df\u91d1",1,949,"MO","1",949,"2","2020-05-19 14:29:22","2","2020-05-19 14:29:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:29:22","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":["8225","RENT","\u9810\u7e73\u79df\u91d1",2,949,"MO","1",949,"2","2020-05-19 14:29:22","2","2020-05-19 14:29:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:29:22","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":["8225","RENT","\u9810\u7e73\u79df\u91d1",3,949,"MO","1",949,"2","2020-05-19 14:29:22","2","2020-05-19 14:29:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:29:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2847,0,"8225"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-19 14:29:22","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":[311,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207869","2020-05-19 14:29:22",2847,"2","2020-05-19 14:29:22","2","2020-05-19 14:29:22","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:29:22","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":["7869","DEPOSIT",null,"PAID","2020-05-19 14:29:22",0,"2","2020-05-19 14:29:22","2","2020-05-19 14:29:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:29:22","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":["7869","INVOICE","8225","PAID","2020-05-19 14:29:22",2847,"2","2020-05-19 14:29:22","2","2020-05-19 14:29:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:54: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=681&filter3=undefined&page=2","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":205,"customer_code":"C160205","identity_type":"PERSONAL","identity_id":"A840286(0)","title":"Mr","lastname":"Kong","firstname":"Yeung Nam","companyname":"","email":null,"tel":"94396670","address":"\u9d28\u8137\u6d32\u5229\u6771\u90a8\u6771\u696d\u6a132718\u5ba4","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-21","renew_room_key":"054,11647","renew_remark":"6 months contract. Storage rental paid by cash on Nov 30, 2019. Storage deposit transferred from agreement A12-CT195020 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196552, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[{"master_room_discount_id":"76","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1376.00","discount":"9.95","monthly_deduct":152.036,"room_id":"54","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"54","room_code":"B02","retail_price":"1528.0","discounted_price":1376,"location_id":"1"}],"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-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 18, 2020. Storage deposit transferred from agreement A12-CT196552 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":6834,"final_order_total":6834,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,11647","order_product":[],"pass":true}},"first_order_id":"4166","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> B02 <\/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":"1139.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:54:18","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",205,"NEW","A12-CT207897",1528,1139,0,0,"6","6",6834,6834,6834,"2020-05-19 14:54:18","0",null,null,null,"2020-05-21","2020-11-20","6 months contract. Storage rental paid by PPS on May 18, 2020. Storage deposit transferred from agreement A12-CT196552 to this agreement.\r\n","2020-05-21","20",0,null,0,"0","2","2020-05-19 14:54:17","2","2020-05-19 14:54:17","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,11647","C160205","PERSONAL","Mr","+CEasm6M1CVfSBTcrdC0qg==","F5uIWSqx2McFcjiJ4bOqSw==","","JP4Rs\/ygk7B5+4qY1O\/77rw5vJXpI+cNXpr\/SGV4DsdkBj+uF31GYiRkfRM+Ko+G","5hVl36OQKHYFGuX3eVtspw==",null,"\/4MaY1f7Gy3zoaOtvuKuLw==",null,1,"4166"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:54:18","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":["7897","76","10","54","%","9.95",152.036,"2","2020-05-19 14:54:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:54:18","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":["7897","54","1528.0",1376,"2","2020-05-19 14:54:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:54:18","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","54"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-19 14:54:18","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":["7897",205,"SETTLED","A12-I208226","2020-05-19 14:54:17","2020-05-21","2","2020-05-19 14:54:17","2","2020-05-19 14:54:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:54:18","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":["8226","RENT","\u9810\u7e73\u79df\u91d1",1,1139,"MO","1",1139,"2","2020-05-19 14:54:17","2","2020-05-19 14:54:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:54:18","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":["8226","RENT","\u9810\u7e73\u79df\u91d1",2,1139,"MO","1",1139,"2","2020-05-19 14:54:17","2","2020-05-19 14:54:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:54:18","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":["8226","RENT","\u9810\u7e73\u79df\u91d1",3,1139,"MO","1",1139,"2","2020-05-19 14:54:17","2","2020-05-19 14:54:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:54:18","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":["8226","RENT","\u9810\u7e73\u79df\u91d1",4,1139,"MO","1",1139,"2","2020-05-19 14:54:17","2","2020-05-19 14:54:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:54:18","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":["8226","RENT","\u9810\u7e73\u79df\u91d1",5,1139,"MO","1",1139,"2","2020-05-19 14:54:17","2","2020-05-19 14:54:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:54:18","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":["8226","RENT","\u9810\u7e73\u79df\u91d1",6,1139,"MO","1",1139,"2","2020-05-19 14:54:17","2","2020-05-19 14:54:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:54:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6834,0,"8226"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-19 14:54:18","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":[205,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207870","2020-05-19 14:54:17",6834,"2","2020-05-19 14:54:17","2","2020-05-19 14:54:17","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:54:18","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":["7870","DEPOSIT",null,"PAID","2020-05-19 14:54:17",0,"2","2020-05-19 14:54:17","2","2020-05-19 14:54:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 14:54:18","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":["7870","INVOICE","8226","PAID","2020-05-19 14:54:17",6834,"2","2020-05-19 14:54:17","2","2020-05-19 14:54:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:06:26","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1190&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":1190,"customer_code":"C191190","identity_type":"PERSONAL","identity_id":"Y542390(0)","title":"Ms","lastname":"YAU","firstname":"Hoi Ching","companyname":"","email":"hoichingyau@yahoo.com.hk","tel":"98286010","address":"Flat 2703, 27\/F, Hoi Tin Court, Aberdeen Centre, H.K.","pass":true},"2":{"renew_paymethod2":"OTHER","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1857.0","renew_rent_month":"3","renew_warehousing_date":"2020-06-01","renew_room_key":"","renew_remark":"3 months contract. Storage rental paid by PPS on April 15, 2020. Storage deposit $3714 transferred from agreement A16-CT207036 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT207620, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"205","order_discount":[],"order_room":[{"room_id":"1524","room_code":"A16-033","retail_price":"1857.0","discounted_price":"1857.00","location_id":"7"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1857,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1857,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-01","rent_from":"2020-06-01","rent_to":"2020-06-30","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on May 18, 2020. Storage deposit $3714 transferred from agreement A16-CT207620 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1857,"final_order_total":1857,"location_id":"7","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"first_order_id":"6282","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-033 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1857.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":"24","total_discounted_price":"1857.00","deposit":"0.00","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:06:26","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",1190,"NEW","A16-CT207898",1857,1857,0,0,"1","1",1857,1857,1857,"2020-05-19 15:06:26","0",null,null,null,"2020-06-01","2020-06-30","1 month contract. Storage rental paid by PPS on May 18, 2020. Storage deposit $3714 transferred from agreement A16-CT207620 to this agreement. \r\n","2020-06-01","24",0,null,0,"0","2","2020-05-19 15:06:26","2","2020-05-19 15:06:26","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"","C191190","PERSONAL","Ms","6xj4DbIC8gpxDREqt\/B+EA==","UVY\/HEZSKUPvom9zK4XPwQ==","","2DxST9L++AVFDrp9kqOR+yNcCTgvrEFAbuJgJ13c5xMM6Bt6nxgGJLr69i4wti8HSiFkei69OG3Sr5mAjbh9ww==","iYQqKb+DhKHyc7lRAXgFTQ==","ta5gSuJOiqrW0ihrVIPASVaAT6MyRLxzqFuCiH8tgNQ=","KjAi6kd8noXu\/72l80Vugg==",null,1,"6282"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:06:26","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":["7898","1524","1857.0","1857.00","2","2020-05-19 15:06:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:06:26","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-06-01","2020-06-30","1524"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-19 15:06:26","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":["7898",1190,"SETTLED","A16-I208227","2020-05-19 15:06:26","2020-06-01","2","2020-05-19 15:06:26","2","2020-05-19 15:06:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:06:26","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":["8227","RENT","\u9810\u7e73\u79df\u91d1",1,1857,"MO","1",1857,"2","2020-05-19 15:06:26","2","2020-05-19 15:06:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:06:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1857,0,"8227"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-19 15:06:26","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":[1190,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207871","2020-05-19 15:06:26",1857,"2","2020-05-19 15:06:26","2","2020-05-19 15:06:26","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:06:26","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":["7871","DEPOSIT",null,"PAID","2020-05-19 15:06:26",0,"2","2020-05-19 15:06:26","2","2020-05-19 15:06:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:06:26","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":["7871","INVOICE","8227","PAID","2020-05-19 15:06:26",1857,"2","2020-05-19 15:06:26","2","2020-05-19 15:06:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:36:16","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=1&filter2=1190&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":290,"customer_code":"C170290","identity_type":"PERSONAL","identity_id":"G683435(2)","title":"Mr","lastname":"Cheung","firstname":"Sai Yiu","companyname":"","email":"leosycheung@netvigator.com","tel":"91036345","address":"Flat C, 6\/F, Tower 10, Grand Yoho, 9 Long Yat Road, Yuen Long, NT, HK ","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1887.0","renew_rent_month":"3","renew_warehousing_date":"2020-05-25","renew_room_key":"55, 24359","renew_remark":"3 months contract. Storage rental paid by PPS on February 17, 2020. Storage deposit transferred from agreement A12-CT196473 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207218, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"433","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"181","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"433","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"192","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"192","room_code":"C68","retail_price":"1098.0","discounted_price":1043.4,"location_id":"1"},{"room_id":"181","room_code":"C57","retail_price":"1098.0","discounted_price":1043.4,"location_id":"1"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":1887,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":5661,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-25","rent_from":"2020-05-25","rent_to":"2020-08-24","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on May 19, 2020. Storage deposit transferred from agreement A12-CT207218 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":5661,"final_order_total":5661,"location_id":"1","branch_id":"1","company_id":"1","room_key":"55, 24359","order_product":[],"pass":true}},"first_order_id":"4390","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> C68 <\/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> C57 <\/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":"1887.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:36:16","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",290,"NEW","A12-CT207899",2196,1887,0,0,"3","3",5661,5661,5661,"2020-05-19 15:36:16","0",null,null,null,"2020-05-25","2020-08-24","3 months contract. Storage rental paid by bank transfer on May 19, 2020. Storage deposit transferred from agreement A12-CT207218 to this agreement.\r\n","2020-05-25","32",0,null,0,"0","2","2020-05-19 15:36:16","2","2020-05-19 15:36:16","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"55, 24359","C170290","PERSONAL","Mr","+m7AdbAN1WsKKht+JZSaJQ==","vCxOlXQuvOQaoL822H2o\/Q==","","s+tdPbtKddtBtaV3zBKye3ZjQJ7CcLDLDIJHNmyA3JVftU9z8jrwQnOn6FuueVLQKrD1BpmxJy4f2jCIZcnJPHAqeaRmkIGjM0yLlH88xw8=","+RHeMCJYuOZuC8aAQkm2jA==","47sg70e8qTY4uR2FyNDr867LMn2R3L2cH5c2x6+7VfY=","kd+EYnRfPcJ\/+u7iwjgo4w==",null,1,"4390"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:36:16","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":["7899","433","8","181","%","4.97",54.5706,"2","2020-05-19 15:36:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:36:16","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":["7899","433","8","192","%","4.97",54.5706,"2","2020-05-19 15:36:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:36:16","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":["7899","192","1098.0",1043.4,"2","2020-05-19 15:36:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:36:16","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-25","2020-08-24","192"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-19 15:36:16","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":["7899","181","1098.0",1043.4,"2","2020-05-19 15:36:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:36:16","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-25","2020-08-24","181"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-19 15:36:16","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":["7899",290,"SETTLED","A12-I208228","2020-05-19 15:36:16","2020-05-25","2","2020-05-19 15:36:16","2","2020-05-19 15:36:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:36:16","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":["8228","RENT","\u9810\u7e73\u79df\u91d1",1,1887,"MO","1",1887,"2","2020-05-19 15:36:16","2","2020-05-19 15:36:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:36:16","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":["8228","RENT","\u9810\u7e73\u79df\u91d1",2,1887,"MO","1",1887,"2","2020-05-19 15:36:16","2","2020-05-19 15:36:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:36:16","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":["8228","RENT","\u9810\u7e73\u79df\u91d1",3,1887,"MO","1",1887,"2","2020-05-19 15:36:16","2","2020-05-19 15:36:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:36:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5661,0,"8228"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-19 15:36:16","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":[290,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207872","2020-05-19 15:36:16",5661,"2","2020-05-19 15:36:16","2","2020-05-19 15:36:16","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:36:16","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":["7872","DEPOSIT",null,"PAID","2020-05-19 15:36:16",0,"2","2020-05-19 15:36:16","2","2020-05-19 15:36:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:36:16","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":["7872","INVOICE","8228","PAID","2020-05-19 15:36:16",5661,"2","2020-05-19 15:36:16","2","2020-05-19 15:36:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:41:00","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=1&filter2=1190&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":423,"customer_code":"C170423","identity_type":"PERSONAL","identity_id":"E417712(A)","title":"Mrs","lastname":"Kwok Shiu","firstname":"Siu Lay Shirley","companyname":"","email":"se-kwok@hotmail.com","tel":"91904490","address":"18B, 52 Mount Davis Rd ,Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1528.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-25","renew_room_key":"055,32590","renew_remark":"1 month contract. Storage rental paid by bank transfer on March 27, 2020. Storage deposit transferred from agreement A14-CT207312 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207506, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"38","order_discount":[],"order_room":[{"room_id":"449","room_code":"J31","retail_price":"1528.0","discounted_price":"1528.00","location_id":"2"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1528,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1528,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-25","rent_from":"2020-04-25","rent_to":"2020-05-24","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on May 19, 2020. Storage deposit transferred from agreement A14-CT207506 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1528,"final_order_total":1528,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,32590","order_product":[],"pass":true}},"first_order_id":"4833","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> J31 <\/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":"1528.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:41:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",423,"NEW","A14-CT207900",1528,1528,0,0,"1","1",1528,1528,1528,"2020-05-19 15:41:01","0",null,null,null,"2020-04-25","2020-05-24","1 month contract. Storage rental paid by bank transfer on May 19, 2020. Storage deposit transferred from agreement A14-CT207506 to this agreement.\r\n","2020-04-25","20",0,null,0,"0","2","2020-05-19 15:41:00","2","2020-05-19 15:41:00","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,32590","C170423","PERSONAL","Mrs","+cSauOfzf4UKH6i9E\/o3Ow==","9BE1lGM5+6cl7FB3cBYT\/Q==","","QuHHgcx1ghORfe6aPTL+cwHs9gJpW87+Y84Si6oTDbtaPpyzLd7Q86Xo4RoVzL1i","uWe4YUxvL5KuigFTIBklFw==","CBE2gpTh\/+LjBRyyCUBxTx7oEtKfkCZ0NTTPgR4mc0Q=","I\/c6FTBu+Cf57wsquAGAzA==",null,1,"4833"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:41:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7900","449","1528.0","1528.00","2","2020-05-19 15:41:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:41:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-25","2020-05-24","449"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-19 15:41:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7900",423,"SETTLED","A14-I208229","2020-05-19 15:41:00","2020-04-25","2","2020-05-19 15:41:00","2","2020-05-19 15:41:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:41:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8229","RENT","\u9810\u7e73\u79df\u91d1",1,1528,"MO","1",1528,"2","2020-05-19 15:41:00","2","2020-05-19 15:41:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:41:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1528,0,"8229"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-19 15:41:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[423,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207873","2020-05-19 15:41:00",1528,"2","2020-05-19 15:41:00","2","2020-05-19 15:41:00","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:41:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7873","DEPOSIT",null,"PAID","2020-05-19 15:41:00",0,"2","2020-05-19 15:41:00","2","2020-05-19 15:41:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:41:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7873","INVOICE","8229","PAID","2020-05-19 15:41:00",1528,"2","2020-05-19 15:41:00","2","2020-05-19 15:41:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:52:01","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 15:52:01","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 16:22: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=1&filter2=1190&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":357,"customer_code":"C170357","identity_type":"PERSONAL","identity_id":"K200528(A)","title":"Ms","lastname":"So","firstname":"Bik Yan","companyname":"","email":"Bettyso2010@hotmail.com","tel":"61890200","address":"\u9999\u6e2f\u4ed4\u9d28\u8137\u6d32\u897f\u6751\u5229\u798f\u6a13\u9ad8\u5ea79\u6a1312\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"989.0","renew_rent_month":"3","renew_warehousing_date":"2020-05-14","renew_room_key":"052,56559\/054,01889","renew_remark":"3 months contract. Storage rental paid by bank transfer on March 20, 2020. Storage deposit transferred from agreement A14-CT206931 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207465, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"514","room_code":"K51","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":935,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":11220,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-14","rent_from":"2020-05-14","rent_to":"2021-05-13","delivery_service":"0","remark":"12 months contract. Special offer $300 Maxim's voucher and 3 renewal gifts. Storage rental paid by bank transfer on May 19, 2020. Storage deposit transferred from agreement A14-CT207465 to this agreement.\r\n\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":11220,"final_order_total":11220,"location_id":"2","branch_id":"1","company_id":"1","room_key":"052,56559\/054,01889","order_product":[],"pass":true}},"first_order_id":"3602","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> K51 <\/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\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":"16","total_discounted_price":"935.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 16:22:22","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",357,"NEW","A14-CT207901",1098,935,0,0,"12","12",11220,11220,11220,"2020-05-19 16:22:22","0",null,null,null,"2020-05-14","2021-05-13","12 months contract. Special offer $300 Maxim's voucher and 3 renewal gifts. Storage rental paid by bank transfer on May 19, 2020. Storage deposit transferred from agreement A14-CT207465 to this agreement.\r\n\r\n","2020-05-14","16",0,null,0,"0","2","2020-05-19 16:22:22","2","2020-05-19 16:22:22","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,56559\/054,01889","C170357","PERSONAL","Ms","Xm\/QexF8eZtTsSb8L38jDQ==","4x5vYEKSVRSuDm5I8YHOGA==","","iaMKHy8smhToDNlD2lpct7apbVifxmEzETQX4zzdkIWbv1n1\/bqXIgSPJ9SuXJYQpspqWP8NAGG1MTx8\/3lieQ==","+3tfr98clfpe3pm59uql3Q==","oYq5\/GECL57LsJqAl8dH7KilbaFGbc5z+OZxfLZDi7A=","LEynVVsVuI2leNikh3mN3A==",null,1,"3602"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 16:22:22","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":["7901","514","1098.0","1098.00","2","2020-05-19 16:22:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 16:22:22","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-14","2021-05-13","514"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-19 16:22:22","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":["7901",357,"SETTLED","A14-I208230","2020-05-19 16:22:22","2020-05-14","2","2020-05-19 16:22:22","2","2020-05-19 16:22:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 16:22:22","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":["8230","RENT","\u9810\u7e73\u79df\u91d1",1,935,"MO","1",935,"2","2020-05-19 16:22:22","2","2020-05-19 16:22:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 16:22:22","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":["8230","RENT","\u9810\u7e73\u79df\u91d1",2,935,"MO","1",935,"2","2020-05-19 16:22:22","2","2020-05-19 16:22:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 16:22:22","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":["8230","RENT","\u9810\u7e73\u79df\u91d1",3,935,"MO","1",935,"2","2020-05-19 16:22:22","2","2020-05-19 16:22:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 16:22:22","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":["8230","RENT","\u9810\u7e73\u79df\u91d1",4,935,"MO","1",935,"2","2020-05-19 16:22:22","2","2020-05-19 16:22:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 16:22:22","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":["8230","RENT","\u9810\u7e73\u79df\u91d1",5,935,"MO","1",935,"2","2020-05-19 16:22:22","2","2020-05-19 16:22:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 16:22:22","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":["8230","RENT","\u9810\u7e73\u79df\u91d1",6,935,"MO","1",935,"2","2020-05-19 16:22:22","2","2020-05-19 16:22:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 16:22:22","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":["8230","RENT","\u9810\u7e73\u79df\u91d1",7,935,"MO","1",935,"2","2020-05-19 16:22:22","2","2020-05-19 16:22:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 16:22:22","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":["8230","RENT","\u9810\u7e73\u79df\u91d1",8,935,"MO","1",935,"2","2020-05-19 16:22:22","2","2020-05-19 16:22:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 16:22:22","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":["8230","RENT","\u9810\u7e73\u79df\u91d1",9,935,"MO","1",935,"2","2020-05-19 16:22:22","2","2020-05-19 16:22:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 16:22:22","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":["8230","RENT","\u9810\u7e73\u79df\u91d1",10,935,"MO","1",935,"2","2020-05-19 16:22:22","2","2020-05-19 16:22:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 16:22:22","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":["8230","RENT","\u9810\u7e73\u79df\u91d1",11,935,"MO","1",935,"2","2020-05-19 16:22:22","2","2020-05-19 16:22:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 16:22:22","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":["8230","RENT","\u9810\u7e73\u79df\u91d1",12,935,"MO","1",935,"2","2020-05-19 16:22:22","2","2020-05-19 16:22:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 16:22:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11220,0,"8230"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-19 16:22:22","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":[357,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207874","2020-05-19 16:22:22",11220,"2","2020-05-19 16:22:22","2","2020-05-19 16:22:22","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 16:22:22","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":["7874","DEPOSIT",null,"PAID","2020-05-19 16:22:22",0,"2","2020-05-19 16:22:22","2","2020-05-19 16:22:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 16:22:22","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":["7874","INVOICE","8230","PAID","2020-05-19 16:22:22",11220,"2","2020-05-19 16:22:22","2","2020-05-19 16:22:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-19 17:39:06","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****