\n \n \n\t\t\t\t\t

\u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n

\u5009\u5eab\u7de8\u865f<\/td>\n	\u5c3a\u5bf8<\/td>\n	\u539f\u50f9(\u6708)<\/td>\n	\u512a\u60e0\u50f9(\u6708)<\/td>\n	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n	\u50f9\u683c<\/td>\n	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n	<\/td>\n <\/tr>
O04 <\/td>\n\t\t\t\t\t	4X3X8 <\/td>\n\t\t\t\t\t	$998.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"12","total_discounted_price":"899.00","deposit":"1996.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 10:53:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2","1638","NEW","A14-CT208204",998,899,1996,0,"13","13",12244,13683,12244,"2020-06-23 10:53:09","0",null,null,null,"2020-06-26","2021-07-25","13 months contract. Special offer the 13th month free and 5% rent now discount. Storage rental and deposit paid by EPS on June 23,2020. Smart card and padlock provided on the same day.","2020-06-26","12",0,null,1439,"1439.00","2","2020-06-23 10:53:08","2","2020-06-23 10:53:08","EPS","","","","EPS","","","",null,0,"190,39795","C201638","PERSONAL","Ms","LCohVq7FQuoGpXsJ9zntow==","EFJ\/EVT44ongyRfYhod9mw==","","kzE27nGzYlLPmkRlipngIOpajWdnYIqAc89Y\/Y9ZfRGsE2Ui3\/WbjNVTCVqjLnrd","X160kdONhnM8Ty8tKpF2YA==","cebUU0KeGp9rv9lfVuKtSA4O3LkV09pPHvlOdrdw0wY=","KwEA0eZdOQlvjWlQHvaV9g==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 10:53:09","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":["8204","728","998.0","998.00","2","2020-06-23 10:53:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 10:53:09","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-26","2021-07-25","728"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-23 10:53:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["8204","A14-D205496","PAID",1996,0,"2021-07-25","2020-06-23 10:53:08","2020-06-23 10:53:08","2","2020-06-23 10:53:08","2","2020-06-23 10:53:08","1638"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 10:53:09","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":["8204","1638","SETTLED","A14-I208533","2020-06-23 10:53:08","2020-06-26","2","2020-06-23 10:53:08","2","2020-06-23 10:53:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 10:53:09","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":["8533","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-23 10:53:08","2","2020-06-23 10:53:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 10:53:09","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":["8533","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,359,"MO","1",359,"2","2020-06-23 10:53:08","2","2020-06-23 10:53:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 10:53:09","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":["8533","RENT","\u9810\u7e73\u79df\u91d1",3,899,"MO","1",899,"2","2020-06-23 10:53:08","2","2020-06-23 10:53:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 10:53:09","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":["8533","RENT","\u9810\u7e73\u79df\u91d1",4,899,"MO","1",899,"2","2020-06-23 10:53:08","2","2020-06-23 10:53:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 10:53:09","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":["8533","RENT","\u9810\u7e73\u79df\u91d1",5,899,"MO","1",899,"2","2020-06-23 10:53:08","2","2020-06-23 10:53:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 10:53:09","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":["8533","RENT","\u9810\u7e73\u79df\u91d1",6,899,"MO","1",899,"2","2020-06-23 10:53:08","2","2020-06-23 10:53:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 10:53:09","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":["8533","RENT","\u9810\u7e73\u79df\u91d1",7,899,"MO","1",899,"2","2020-06-23 10:53:08","2","2020-06-23 10:53:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 10:53:09","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":["8533","RENT","\u9810\u7e73\u79df\u91d1",8,899,"MO","1",899,"2","2020-06-23 10:53:08","2","2020-06-23 10:53:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 10:53:09","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":["8533","RENT","\u9810\u7e73\u79df\u91d1",9,899,"MO","1",899,"2","2020-06-23 10:53:08","2","2020-06-23 10:53:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 10:53:09","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":["8533","RENT","\u9810\u7e73\u79df\u91d1",10,899,"MO","1",899,"2","2020-06-23 10:53:08","2","2020-06-23 10:53:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 10:53:09","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":["8533","RENT","\u9810\u7e73\u79df\u91d1",11,899,"MO","1",899,"2","2020-06-23 10:53:08","2","2020-06-23 10:53:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 10:53:09","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":["8533","RENT","\u9810\u7e73\u79df\u91d1",12,899,"MO","1",899,"2","2020-06-23 10:53:08","2","2020-06-23 10:53:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 10:53:09","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":["8533","RENT","\u9810\u7e73\u79df\u91d1",13,899,"MO","1",899,"2","2020-06-23 10:53:08","2","2020-06-23 10:53:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 10:53:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10248,0,"8533"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-23 10:53:09","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":["1638","EPS","","","","EPS","","","","PAID","P208176","2020-06-23 10:53:08",12244,"2","2020-06-23 10:53:08","2","2020-06-23 10:53:08","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 10:53:09","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":["8176","DEPOSIT","5496","PAID","2020-06-23 10:53:08",1996,"2","2020-06-23 10:53:08","2","2020-06-23 10:53:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 10:53:09","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":["8176","INVOICE","8533","PAID","2020-06-23 10:53:08",10248,"2","2020-06-23 10:53:08","2","2020-06-23 10:53:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 12:42:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 12:44:50","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":654,"customer_code":"C170654","identity_type":"PERSONAL","identity_id":"D262052(A)","title":"Ms","lastname":"Leung ","firstname":"Lai Sim ","companyname":"","email":"alex1719971122@gmail.com","tel":"93682369","address":"Flat 5, 6\/F, Block D, 14 Nam Ning Street, Aberdeen Centre, Hong Kong ","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"981.0","renew_rent_month":"6","renew_warehousing_date":"2021-06-29","renew_room_key":"055,21009","renew_remark":"6 months contract. Storage rental paid by cash on December 23, 2019. Storage deposit transferred from agreement A18-CT195319 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196762, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"77","order_discount":[],"order_room":[{"room_id":"883","room_code":"Y12","retail_price":"1090.0","discounted_price":"1090.00","location_id":"3"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":981,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5886,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-29","rent_from":"2020-06-29","rent_to":"2020-12-28","delivery_service":"0","remark":"6 months contract. Storage rental paid by cash on June 23, 2020. Storage deposit transferred from agreement A18-CT196762 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":5886,"final_order_total":5886,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,21009","order_product":[],"pass":true}},"first_order_id":"3950","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> Y12 <\/td>\r\n\t\t\t\t\t 3X4X7 <\/td>\r\n\t\t\t\t\t $1090.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"981.0","deposit":"0","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 12:44:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",654,"NEW","A18-CT208205",1090,981,0,0,"6","6",5886,5886,5886,"2020-06-23 12:44:51","0",null,null,null,"2020-06-29","2020-12-28","6 months contract. Storage rental paid by cash on June 23, 2020. Storage deposit transferred from agreement A18-CT196762 to this agreement.","2020-06-29","12",0,null,0,"0","2","2020-06-23 12:44:50","2","2020-06-23 12:44:50","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"055,21009","C170654","PERSONAL","Ms","MOSClpJj5as3RXhHins3wg==","EU9enA5\/vY58OMUDrd7sSw==","","qBXHZDuwONF14CIqfr9zbQPYC39nysRRkIt4yBySAMUGParaYTbGDzvL6giYK11DpktuED8YkBToD2SavAVqZHCydarpCc0X+VXP5DURZYs=","8qSLYTaCdkRF13xkgzofBA==","mMRoKN7dyNkD5422RLIjB4FKUkcoCNWqh6oCUMj6TRc=","GZdnwyBg7e5cmXI4vLzh3w==",null,1,"3950"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 12:44:51","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":["8205","883","1090.0","1090.00","2","2020-06-23 12:44:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 12:44:51","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-29","2020-12-28","883"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-23 12:44:51","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":["8205",654,"SETTLED","A18-I208534","2020-06-23 12:44:50","2020-06-29","2","2020-06-23 12:44:50","2","2020-06-23 12:44:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 12:44:51","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":["8534","RENT","\u9810\u7e73\u79df\u91d1",1,981,"MO","1",981,"2","2020-06-23 12:44:50","2","2020-06-23 12:44:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 12:44:51","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":["8534","RENT","\u9810\u7e73\u79df\u91d1",2,981,"MO","1",981,"2","2020-06-23 12:44:50","2","2020-06-23 12:44:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 12:44:51","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":["8534","RENT","\u9810\u7e73\u79df\u91d1",3,981,"MO","1",981,"2","2020-06-23 12:44:50","2","2020-06-23 12:44:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 12:44:51","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":["8534","RENT","\u9810\u7e73\u79df\u91d1",4,981,"MO","1",981,"2","2020-06-23 12:44:50","2","2020-06-23 12:44:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 12:44:51","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":["8534","RENT","\u9810\u7e73\u79df\u91d1",5,981,"MO","1",981,"2","2020-06-23 12:44:50","2","2020-06-23 12:44:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 12:44:51","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":["8534","RENT","\u9810\u7e73\u79df\u91d1",6,981,"MO","1",981,"2","2020-06-23 12:44:50","2","2020-06-23 12:44:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 12:44:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5886,0,"8534"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-23 12:44:51","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":[654,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P208177","2020-06-23 12:44:50",5886,"2","2020-06-23 12:44:50","2","2020-06-23 12:44:50","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 12:44:51","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":["8177","DEPOSIT",null,"PAID","2020-06-23 12:44:50",0,"2","2020-06-23 12:44:50","2","2020-06-23 12:44:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 12:44:51","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":["8177","INVOICE","8534","PAID","2020-06-23 12:44:50",5886,"2","2020-06-23 12:44:50","2","2020-06-23 12:44:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 13:01: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":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1564,"customer_code":"C201564","identity_type":"PERSONAL","identity_id":"D231595(6)","title":"Ms","lastname":"LIU","firstname":"Pui Yee","companyname":"","email":"tammgliu888@yahoo.com","tel":"94016895","address":"Flat 914, Wah Kin House, Wah Fu Est, Pok Fu Lam, South District.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1286.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-20","renew_room_key":"190,26664","renew_remark":"1 month contract. Storage rental and deposit paid by bank transfer on May 20, 2020. Storage deposit $2572 transferred from agreement A12-CT207668 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207904, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"61","room_code":"B09","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1286,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1286,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-20","rent_from":"2020-06-20","rent_to":"2020-07-19","delivery_service":"0","remark":"1 month contract. Storage rental and deposit paid by bank transfer on June 20, 2020. Storage deposit $2572 transferred from agreement A12-CT207904 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1286,"final_order_total":1286,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190,26664","order_product":[],"pass":true}},"first_order_id":"7668","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> B09 <\/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":"1286.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 13:01: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",1564,"NEW","A12-CT208206",1528,1286,0,0,"1","1",1286,1286,1286,"2020-06-23 13:01:16","0",null,null,null,"2020-06-20","2020-07-19","1 month contract. Storage rental and deposit paid by bank transfer on June 20, 2020. Storage deposit $2572 transferred from agreement A12-CT207904 to this agreement. ","2020-06-20","20",0,null,0,"0","2","2020-06-23 13:01:16","2","2020-06-23 13:01:16","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190,26664","C201564","PERSONAL","Ms","pW1T\/bCpncDmYxmrSj5N3Q==","wtXe3F1rqyx\/NkkNOLs7pg==","","BgslglUH0r+MGDNMVR4ODLjLIekcdNYutpHNMKcJTdrat5CTYwp+Fhe5w6yhrvR0cHFxKswLh535kpcAoSEfSvDIf7aqVNHnYcIjpS7j\/kY=","5MBoUUrP0SuSZ8JjZjyPvw==","VpKfghnYmCAk6qGCqxoxbQJSaV0E+kVERKvj9qrtcLU=","5e+N+acflaaaW7mYFvh\/JQ==",null,1,"7668"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 13:01: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":["8206","61","1528.0","1528.00","2","2020-06-23 13:01:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 13:01: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-06-20","2020-07-19","61"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-23 13:01: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":["8206",1564,"SETTLED","A12-I208535","2020-06-23 13:01:16","2020-06-20","2","2020-06-23 13:01:16","2","2020-06-23 13:01:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 13:01: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":["8535","RENT","\u9810\u7e73\u79df\u91d1",1,1286,"MO","1",1286,"2","2020-06-23 13:01:16","2","2020-06-23 13:01:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 13:01:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1286,0,"8535"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-23 13:01: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":[1564,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208178","2020-06-23 13:01:16",1286,"2","2020-06-23 13:01:16","2","2020-06-23 13:01:16","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 13:01: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":["8178","DEPOSIT",null,"PAID","2020-06-23 13:01:16",0,"2","2020-06-23 13:01:16","2","2020-06-23 13:01:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 13:01: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":["8178","INVOICE","8535","PAID","2020-06-23 13:01:16",1286,"2","2020-06-23 13:01:16","2","2020-06-23 13:01:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 13:11:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:17:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:49: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":"filter1=2&filter2=476&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"595","master_room_id":"28","room_code":"M06"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1268,"customer_code":"C191268","identity_type":"PERSONAL","identity_id":"K602297(9)","title":"Mr","lastname":"Chow","firstname":"Chun Ming","companyname":"","email":"chowgary@me.com","tel":"90869929","address":"Flat 5, 13\/F, Block B, ABBA House, 227 Aberdeen Main Road, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1162.0","renew_rent_month":"13","renew_warehousing_date":"2020-06-27","renew_room_key":"189,29061","renew_remark":"13 months contract. Special offer, one month free. Paid $1000 deposit by cash on May 15, 2019. Remaining storage rental and deposit (ttl:$15524) paid by cheque on May 16, 2019. Smartcard and padlock keys provided on May 16, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT194960, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2580.0","renew_master_room_id":"202","order_discount":[],"order_room":[{"room_id":"1518","room_code":"A16-027","retail_price":"1290.0","discounted_price":"1290.00","location_id":"7"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6972,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-27","rent_from":"2020-06-27","rent_to":"2020-12-26","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on June 23, 2020. Storage dpeosit $2580 transferred from agreement A16-CT194960 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6972,"final_order_total":6972,"location_id":"7","branch_id":"1","company_id":"1","room_key":"189,29061","order_product":[],"pass":true}},"first_order_id":4960,"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-027 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1162.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:49: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","7",1268,"NEW","A16-CT208207",1290,1162,0,0,"6","6",6972,6972,6972,"2020-06-23 15:49:05","0",null,null,null,"2020-06-27","2020-12-26","6 months contract. Storage rental paid by bank transfer on June 23, 2020. Storage dpeosit $2580 transferred from agreement A16-CT194960 to this agreement. \r\n","2020-06-27","16",0,null,0,"0","2","2020-06-23 15:49:05","2","2020-06-23 15:49:05","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"189,29061","C191268","PERSONAL","Mr","6XCd49Pl1v58hCQUvXs7MQ==","anq5M29vFb7FteUGD1jgrQ==","","ETXblyMGxw1tnpk\/bAfJc\/k7K3djuaT3hTwkt15lUzsDauSeb7tLjsxgn+eqkh0wxwG6LCpUdrtWpmyGKYDhiNDObFYBUTu+WzBJNl44Qu0=","8CVF264mZSktxKD01uTqNQ==","UDeCzus1ch0NaRhU4g7kCg==","iznnr\/SzM\/cgnk\/\/t5YoJQ==",null,1,4960]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:49: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":["8207","1518","1290.0","1290.00","2","2020-06-23 15:49:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:49: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-06-27","2020-12-26","1518"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-23 15:49: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":["8207",1268,"SETTLED","A16-I208536","2020-06-23 15:49:05","2020-06-27","2","2020-06-23 15:49:05","2","2020-06-23 15:49:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:49: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":["8536","RENT","\u9810\u7e73\u79df\u91d1",1,1162,"MO","1",1162,"2","2020-06-23 15:49:05","2","2020-06-23 15:49:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:49: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":["8536","RENT","\u9810\u7e73\u79df\u91d1",2,1162,"MO","1",1162,"2","2020-06-23 15:49:05","2","2020-06-23 15:49:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:49: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":["8536","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-06-23 15:49:05","2","2020-06-23 15:49:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:49: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":["8536","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-06-23 15:49:05","2","2020-06-23 15:49:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:49: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":["8536","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-06-23 15:49:05","2","2020-06-23 15:49:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:49: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":["8536","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-06-23 15:49:05","2","2020-06-23 15:49:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:49:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6972,0,"8536"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-23 15:49: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":[1268,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208179","2020-06-23 15:49:05",6972,"2","2020-06-23 15:49:05","2","2020-06-23 15:49:05","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:49: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":["8179","DEPOSIT",null,"PAID","2020-06-23 15:49:05",0,"2","2020-06-23 15:49:05","2","2020-06-23 15:49:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:49: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":["8179","INVOICE","8536","PAID","2020-06-23 15:49:05",6972,"2","2020-06-23 15:49:05","2","2020-06-23 15:49:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:52:13","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=476&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"595","master_room_id":"28","room_code":"M06"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":98,"customer_code":"C160098","identity_type":"PERSONAL","identity_id":"D451776(9)","title":"Mr","lastname":"Tang","firstname":"Kin Chor","companyname":"","email":"candicetsui@hotmail.com","tel":"91551038","address":"Flat C ,13\/F ,Block 2 , Kwong Fung Terrace,163 Third Street , Sai Ying Pun , HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3318.0","renew_rent_month":"6","renew_warehousing_date":"2020-07-01","renew_room_key":"055,04510","renew_remark":"6 months contract. Storage rental paid by bank transfer on December 27, 2019. Storage deposit $8976 transferred from agreement A12-CT195325 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT206936, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"70","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"898.60","discount":"9.96","monthly_deduct":99.4008,"room_id":"339","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"70","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"898.60","discount":"9.96","monthly_deduct":99.4008,"room_id":"338","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"350","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"349","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"339","room_code":"F24","retail_price":"998.0","discounted_price":898.6,"location_id":"1"},{"room_id":"338","room_code":"F23","retail_price":"998.0","discounted_price":898.6,"location_id":"1"},{"room_id":"349","room_code":"F34","retail_price":"1098.0","discounted_price":989,"location_id":"1"},{"room_id":"350","room_code":"F35","retail_price":"1098.0","discounted_price":989,"location_id":"1"}],"roughly_size":"56","total_retail_price":4192,"total_discounted_price":3318,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":19908,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-01","rent_from":"2020-07-01","rent_to":"2020-12-31","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on June 23, 2020. Storage deposit $8976 transferred from agreement A12-CT206936 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":19908,"final_order_total":19908,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,04510","order_product":[],"pass":true}},"first_order_id":"3988","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\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> F24 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> F23 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> F34 <\/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> F35 <\/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":"56","total_discounted_price":"3318.0","deposit":"0","total_retail_price":"4192.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:52:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",98,"NEW","A12-CT208208",4192,3318,0,0,"6","6",19908,19908,19908,"2020-06-23 15:52:13","0",null,null,null,"2020-07-01","2020-12-31","6 months contract. Storage rental paid by bank transfer on June 23, 2020. Storage deposit $8976 transferred from agreement A12-CT206936 to this agreement.\r\n","2020-07-01","56",0,null,0,"0","2","2020-06-23 15:52:13","2","2020-06-23 15:52:13","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,04510","C160098","PERSONAL","Mr","LVCjHjOMA6DXeqjD+hjzKg==","M7CfcmE2OSMlZOkNgaoDmQ==","","WccXyqQlkfkMVl0xfvKm2cV\/RDuzr8asW1LnfWSo6JGnQ5uqK\/oVn7e4DNUBMpe8qXmt0fapnVXtsmCSfROzf71LvMWzFnAiAvZiPY\/HLTk=","6vSowiyV+fvPLovUkHBLGw==","oxjSz78510uxC2GGCzUY5hc1bsdZtzHwSE6OEqWLXT0=","QEBgUIFDXQjignzLItQ10g==",null,1,"3988"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:52:13","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":["8208","70","6","339","%","9.96",99.4008,"2","2020-06-23 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:52:13","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":["8208","70","6","338","%","9.96",99.4008,"2","2020-06-23 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:52:13","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":["8208","72","8","350","%","9.93",109.0314,"2","2020-06-23 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:52:13","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":["8208","72","8","349","%","9.93",109.0314,"2","2020-06-23 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:52:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8208","339","998.0",898.6,"2","2020-06-23 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:52:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-01","2020-12-31","339"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-23 15:52:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8208","338","998.0",898.6,"2","2020-06-23 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:52:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-01","2020-12-31","338"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-23 15:52:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8208","349","1098.0",989,"2","2020-06-23 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:52:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-01","2020-12-31","349"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-23 15:52:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8208","350","1098.0",989,"2","2020-06-23 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:52:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-01","2020-12-31","350"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-23 15:52:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8208",98,"SETTLED","A12-I208537","2020-06-23 15:52:13","2020-07-01","2","2020-06-23 15:52:13","2","2020-06-23 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:52:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8537","RENT","\u9810\u7e73\u79df\u91d1",1,3318,"MO","1",3318,"2","2020-06-23 15:52:13","2","2020-06-23 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:52:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8537","RENT","\u9810\u7e73\u79df\u91d1",2,3318,"MO","1",3318,"2","2020-06-23 15:52:13","2","2020-06-23 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:52:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8537","RENT","\u9810\u7e73\u79df\u91d1",3,3318,"MO","1",3318,"2","2020-06-23 15:52:13","2","2020-06-23 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:52:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8537","RENT","\u9810\u7e73\u79df\u91d1",4,3318,"MO","1",3318,"2","2020-06-23 15:52:13","2","2020-06-23 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:52:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8537","RENT","\u9810\u7e73\u79df\u91d1",5,3318,"MO","1",3318,"2","2020-06-23 15:52:13","2","2020-06-23 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:52:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8537","RENT","\u9810\u7e73\u79df\u91d1",6,3318,"MO","1",3318,"2","2020-06-23 15:52:13","2","2020-06-23 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:52:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[19908,0,"8537"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-23 15:52:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[98,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208180","2020-06-23 15:52:13",19908,"2","2020-06-23 15:52:13","2","2020-06-23 15:52:13","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:52:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8180","DEPOSIT",null,"PAID","2020-06-23 15:52:13",0,"2","2020-06-23 15:52:13","2","2020-06-23 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 15:52:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8180","INVOICE","8537","PAID","2020-06-23 15:52:13",19908,"2","2020-06-23 15:52:13","2","2020-06-23 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 16:15:30","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=476&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"595","master_room_id":"28","room_code":"M06"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":655,"customer_code":"C170655","identity_type":"PERSONAL","identity_id":"D332597(1)","title":"Ms","lastname":"Mak","firstname":"Po Chu Ellen","companyname":"","email":"polungto2@netvigator.com","tel":"90700870","address":"Flat 1414, Wah Yin House, Wah Kwai Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1162.0","renew_rent_month":"6","renew_warehousing_date":"2020-06-30","renew_room_key":"053,60186","renew_remark":"6 months contract. Storage rental by EPS on Dec 27,2019. Storage deposit transferred from agreement A18-CT195318 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196801, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[{"master_room_discount_id":"250","master_room_id":"91","discount_type":"%","price":"1290.00","disocunted_price":"1161.00","discount":"10.00","monthly_deduct":129,"room_id":"984","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"984","room_code":"X09","retail_price":"1290.0","discounted_price":1161,"location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6972,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-30","rent_from":"2020-06-30","rent_to":"2020-12-29","delivery_service":"0","remark":"6 months contract. Storage rental by EPS on June 23, 2020. Storage deposit transferred from agreement A18-CT196801 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":6972,"final_order_total":6972,"location_id":"3","branch_id":"1","company_id":"1","room_key":"053,60186","order_product":[],"pass":true}},"first_order_id":6801,"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> X09 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1162.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 16:15:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",655,"NEW","A18-CT208209",1290,1162,0,0,"6","6",6972,6972,6972,"2020-06-23 16:15:31","0",null,null,null,"2020-06-30","2020-12-29","6 months contract. Storage rental by EPS on June 23, 2020. Storage deposit transferred from agreement A18-CT196801 to this agreement.\r\n","2020-06-30","16",0,null,0,"0","2","2020-06-23 16:15:30","2","2020-06-23 16:15:30","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"053,60186","C170655","PERSONAL","Ms","0NwLI\/8QHhL7VcLoftFR1Q==","DGNg\/pKHJ\/mTaSVRFTWCKw==","","xEDEKUui0NEliiFxfwqAAfPPr+iKSiEJx8tIu6MpkeXHRYLfN2esb5n6s7\/w8YdWGSicP5xSheFZATRbtBhLnQ==","utyi9k+CT0DGTDCt0\/C\/CQ==","jeu3hzXqUDKZ98DwfdDYTni84K0Esxx\/wrq\/fCqpj4s=","i+Rgl1m46wHpwigjAPWLaQ==",null,1,6801]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 16:15:31","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":["8209","250","91","984","%","10.00",129,"2","2020-06-23 16:15:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 16:15:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8209","984","1290.0",1161,"2","2020-06-23 16:15:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 16:15:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-30","2020-12-29","984"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-23 16:15:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8209",655,"SETTLED","A18-I208538","2020-06-23 16:15:30","2020-06-30","2","2020-06-23 16:15:30","2","2020-06-23 16:15:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 16:15:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8538","RENT","\u9810\u7e73\u79df\u91d1",1,1162,"MO","1",1162,"2","2020-06-23 16:15:30","2","2020-06-23 16:15:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 16:15:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8538","RENT","\u9810\u7e73\u79df\u91d1",2,1162,"MO","1",1162,"2","2020-06-23 16:15:30","2","2020-06-23 16:15:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 16:15:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8538","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-06-23 16:15:30","2","2020-06-23 16:15:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 16:15:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8538","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-06-23 16:15:30","2","2020-06-23 16:15:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 16:15:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8538","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-06-23 16:15:30","2","2020-06-23 16:15:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 16:15:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8538","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-06-23 16:15:30","2","2020-06-23 16:15:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 16:15:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6972,0,"8538"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-23 16:15:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[655,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P208181","2020-06-23 16:15:30",6972,"2","2020-06-23 16:15:30","2","2020-06-23 16:15:30","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 16:15:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8181","DEPOSIT",null,"PAID","2020-06-23 16:15:30",0,"2","2020-06-23 16:15:30","2","2020-06-23 16:15:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 16:15:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8181","INVOICE","8538","PAID","2020-06-23 16:15:30",6972,"2","2020-06-23 16:15:30","2","2020-06-23 16:15:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:12:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:30:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:40: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=392&filter3=undefined","floor_plan_rent_room":[{"room_id":"595","master_room_id":"28","room_code":"M06"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":550,"customer_code":"C170550","identity_type":"PERSONAL","identity_id":"D703955(8)","title":"Mr","lastname":"Cheng","firstname":"Ming Fai","companyname":"","email":"wilkencheng@yahoo.com","tel":"91702025","address":"Flat \/Rm B, Port Centre,38 Chength Road,Aberdeen ","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"568.0","renew_rent_month":"3","renew_warehousing_date":"2020-06-19","renew_room_key":"054,19790","renew_remark":"3 months contract. Storage rental paid by PPS on March 19, 2020. Storage deposit transferred from agreement A14-CT196752 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207458, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"603","room_code":"M14","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":568,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":1704,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-19","rent_from":"2020-06-19","rent_to":"2020-09-18","delivery_service":"0","remark":"3 months contract. Storage rental paid by PPS on June 17, 2020. Storage deposit transferred from agreement A14-CT207458 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1704,"final_order_total":1704,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,19790","order_product":[],"pass":true}},"first_order_id":"4715","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> M14 <\/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":"568.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:40: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","2",550,"NEW","A14-CT208210",598,568,0,0,"3","3",1704,1704,1704,"2020-06-23 17:40:23","0",null,null,null,"2020-06-19","2020-09-18","3 months contract. Storage rental paid by PPS on June 17, 2020. Storage deposit transferred from agreement A14-CT207458 to this agreement.","2020-06-19","12",0,null,0,"0","2","2020-06-23 17:40:22","2","2020-06-23 17:40:22","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,19790","C170550","PERSONAL","Mr","ltCiTyDjJ0Gdz4KiVHpL3w==","UCPBCXrBLI9U7KKsPqgmNA==","","qHa7kQtdphHngo6GIUc8vMRL2hQTJzY5xRW8sweni0ym3gDQFWl3QJd+ivZN5GvsOoEh8tJhpsL55ryTWcEgAg==","\/0JTPSKr2ND2GvxtuABawQ==","CaF+JgbveygWKEgCnzczUIoa61uqMqQtfY2IocaSJuM=","ggKB4vMm7RYdspOrqrvfqA==",null,1,"4715"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:40: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":["8210","603","598.0","598.00","2","2020-06-23 17:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:40: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-06-19","2020-09-18","603"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-23 17:40: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":["8210",550,"SETTLED","A14-I208539","2020-06-23 17:40:22","2020-06-19","2","2020-06-23 17:40:22","2","2020-06-23 17:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:40: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":["8539","RENT","\u9810\u7e73\u79df\u91d1",1,568,"MO","1",568,"2","2020-06-23 17:40:22","2","2020-06-23 17:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:40: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":["8539","RENT","\u9810\u7e73\u79df\u91d1",2,568,"MO","1",568,"2","2020-06-23 17:40:22","2","2020-06-23 17:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:40: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":["8539","RENT","\u9810\u7e73\u79df\u91d1",3,568,"MO","1",568,"2","2020-06-23 17:40:22","2","2020-06-23 17:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:40:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1704,0,"8539"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-23 17:40: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":[550,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208182","2020-06-23 17:40:22",1704,"2","2020-06-23 17:40:22","2","2020-06-23 17:40:22","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:40: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":["8182","DEPOSIT",null,"PAID","2020-06-23 17:40:22",0,"2","2020-06-23 17:40:22","2","2020-06-23 17:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:40: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":["8182","INVOICE","8539","PAID","2020-06-23 17:40:22",1704,"2","2020-06-23 17:40:22","2","2020-06-23 17:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:42:58","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=392&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"595","master_room_id":"28","room_code":"M06"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":852,"customer_code":"C180852","identity_type":"BUSINESS","identity_id":"33657674-000-03-18-7","title":"Mr","lastname":"Lau","firstname":"Gerald","companyname":"Pacific Sky Holdings Limited","email":"phoenix@laufamilyoffice.com","tel":"98809440","address":"Flat 1604, Tai Tung Bldg., 8 Fleming Road, Wan Chai, H.K.","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4138.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-17","renew_room_key":"190,39679 , 191 05287","renew_remark":"1 month contract. Storage rental paid by PPS on May 14, 2020. Storage deposit transferred from agreement A14-CT207241 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207856, \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":"751","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"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":"752","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"434","master_room_id":"35","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"762","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"434","master_room_id":"35","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"763","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"763","room_code":"O39","retail_price":"1098.0","discounted_price":1043.4,"location_id":"2"},{"room_id":"762","room_code":"O38","retail_price":"1098.0","discounted_price":1043.4,"location_id":"2"},{"room_id":"752","room_code":"O28","retail_price":"998.0","discounted_price":949,"location_id":"2"},{"room_id":"751","room_code":"O27","retail_price":"998.0","discounted_price":949,"location_id":"2"}],"roughly_size":"56","total_retail_price":4192,"total_discounted_price":3931,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":11793,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-17","rent_from":"2020-06-17","rent_to":"2020-09-16","delivery_service":"0","remark":"3 months contract. Storage rental paid by PPS on June 17, 2020. Storage deposit transferred from agreement A14-CT207856 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":11793,"final_order_total":11793,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190,39679 , 191 05287","order_product":[],"pass":true}},"first_order_id":"3672","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\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> O39 <\/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> O38 <\/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> O28 <\/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> O27 <\/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":"56","total_discounted_price":"3931.00","deposit":"0.00","total_retail_price":"4192.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:42:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",852,"NEW","A14-CT208211",4192,3931,0,0,"3","3",11793,11793,11793,"2020-06-23 17:42:59","0",null,null,null,"2020-06-17","2020-09-16","3 months contract. Storage rental paid by PPS on June 17, 2020. Storage deposit transferred from agreement A14-CT207856 to this agreement.\r\n","2020-06-17","56",0,null,0,"0","2","2020-06-23 17:42:58","2","2020-06-23 17:42:58","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"190,39679 , 191 05287","C180852","BUSINESS","Mr","8Sg5HEYOjjrQdMyK1+QWDA==","oe4emdjBwqJ3qUpOcI17hw==","Pacific Sky Holdings Limited","IIKRaaGPL2HpnfgJAUJhCj8+x0hKi5DNcx6YIYwtlZEVlqlzxdoWKu0w1522L4DfmIdFoJkBhGa6ZfmacJM6dg==","c1K4BLKclEz9E3nuvvIo3A==","\/nCaUx+Hqmx6yjXW1XYmc6GmvIbzzej1NbJ+mu4tneg=",null,"LrVQNy2nb4HilGXMHPXLx0dpSDyGUkQVOQmMveXzVow=",1,"3672"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:42:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["8211","470","34","751","%","4.91",49.0018,"2","2020-06-23 17:42:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:42:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["8211","470","34","752","%","4.91",49.0018,"2","2020-06-23 17:42:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:42:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["8211","434","35","762","%","4.97",54.5706,"2","2020-06-23 17:42:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:42:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["8211","434","35","763","%","4.97",54.5706,"2","2020-06-23 17:42:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:42:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8211","763","1098.0",1043.4,"2","2020-06-23 17:42:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:42:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-17","2020-09-16","763"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-23 17:42:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8211","762","1098.0",1043.4,"2","2020-06-23 17:42:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:42:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-17","2020-09-16","762"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-23 17:42:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8211","752","998.0",949,"2","2020-06-23 17:42:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:42:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-17","2020-09-16","752"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-23 17:42:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8211","751","998.0",949,"2","2020-06-23 17:42:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:42:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-17","2020-09-16","751"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-23 17:42:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8211",852,"SETTLED","A14-I208540","2020-06-23 17:42:58","2020-06-17","2","2020-06-23 17:42:58","2","2020-06-23 17:42:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:42:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8540","RENT","\u9810\u7e73\u79df\u91d1",1,3931,"MO","1",3931,"2","2020-06-23 17:42:58","2","2020-06-23 17:42:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:42:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8540","RENT","\u9810\u7e73\u79df\u91d1",2,3931,"MO","1",3931,"2","2020-06-23 17:42:58","2","2020-06-23 17:42:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:42:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8540","RENT","\u9810\u7e73\u79df\u91d1",3,3931,"MO","1",3931,"2","2020-06-23 17:42:58","2","2020-06-23 17:42:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:42:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11793,0,"8540"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-23 17:42:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[852,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208183","2020-06-23 17:42:58",11793,"2","2020-06-23 17:42:58","2","2020-06-23 17:42:58","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:42:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8183","DEPOSIT",null,"PAID","2020-06-23 17:42:58",0,"2","2020-06-23 17:42:58","2","2020-06-23 17:42:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:42:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8183","INVOICE","8540","PAID","2020-06-23 17:42:58",11793,"2","2020-06-23 17:42:58","2","2020-06-23 17:42:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:58:33","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=392&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"595","master_room_id":"28","room_code":"M06"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":828,"customer_code":"C180828","identity_type":"PERSONAL","identity_id":"K902681(9)","title":"Mr","lastname":"Sit","firstname":"Ming Cheung Alvin","companyname":"","email":"alvin.sit@hotmail.com","tel":"94773256","address":"Flat G, 20\/F, Block 23, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"981.0","renew_rent_month":"13","renew_warehousing_date":"2020-05-18","renew_room_key":"054,46427","renew_remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by PPS on May 7, 2019. Storage deposit transferred from agreement A18-CT183326 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT194929, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"77","order_discount":[],"order_room":[{"room_id":"875","room_code":"Y04","retail_price":"1090.0","discounted_price":"1090.00","location_id":"3"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":981,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":11772,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"981.00","warehousing_date":"2020-05-18","rent_from":"2020-05-18","rent_to":"2021-06-17","delivery_service":"0","remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by PPS on June 22, 2020. Storage deposit transferred from agreement A18-CT194929 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":981,"order_total":12753,"final_order_total":11772,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,46427","order_product":[],"pass":true}},"first_order_id":"3326","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> Y04 <\/td>\r\n\t\t\t\t\t 3X4X7 <\/td>\r\n\t\t\t\t\t $1090.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"981.0","deposit":"0","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:58: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","3",828,"NEW","A18-CT208212",1090,981,0,0,"13","13",11772,12753,11772,"2020-06-23 17:58:33","0",null,null,null,"2020-05-18","2021-06-17","13 months contract. Special renewal offer, one month free. Storage rental paid by PPS on June 22, 2020. Storage deposit transferred from agreement A18-CT194929 to this agreement.\r\n","2020-05-18","12",0,null,981,"981.00","2","2020-06-23 17:58:33","2","2020-06-23 17:58:33","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,46427","C180828","PERSONAL","Mr","Xd9TtCLlON98qtgVMZJ8qW0WxyLc7+\/wtnfEtrEAW4c=","o14r+J6Wc4r+98jvXX0xSQ==","","0B8cLHOf6C\/Kvk83A2p19pgI5LznUJ4Z1U6syM2EkEhUk5PSvVon\/nZo5037PzhW89cNyqX0xPEtKh21fxxgQg==","P7tn1YAThYwHlih48i6ClA==","9GDNJAcyndrnsq+QAdgAwyRRL0oE0HWomZqDI4UhTJU=","7reusC30IwYQEFfOCQpoNw==",null,1,"3326"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:58: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":["8212","875","1090.0","1090.00","2","2020-06-23 17:58:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:58: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-18","2021-06-17","875"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-23 17:58: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":["8212",828,"SETTLED","A18-I208541","2020-06-23 17:58:33","2020-05-18","2","2020-06-23 17:58:33","2","2020-06-23 17:58:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:58: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":["8541","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,981,"MO","1",981,"2","2020-06-23 17:58:33","2","2020-06-23 17:58:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:58: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":["8541","RENT","\u9810\u7e73\u79df\u91d1",3,981,"MO","1",981,"2","2020-06-23 17:58:33","2","2020-06-23 17:58:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:58: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":["8541","RENT","\u9810\u7e73\u79df\u91d1",4,981,"MO","1",981,"2","2020-06-23 17:58:33","2","2020-06-23 17:58:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:58: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":["8541","RENT","\u9810\u7e73\u79df\u91d1",5,981,"MO","1",981,"2","2020-06-23 17:58:33","2","2020-06-23 17:58:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:58: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":["8541","RENT","\u9810\u7e73\u79df\u91d1",6,981,"MO","1",981,"2","2020-06-23 17:58:33","2","2020-06-23 17:58:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:58: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":["8541","RENT","\u9810\u7e73\u79df\u91d1",7,981,"MO","1",981,"2","2020-06-23 17:58:33","2","2020-06-23 17:58:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:58: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":["8541","RENT","\u9810\u7e73\u79df\u91d1",8,981,"MO","1",981,"2","2020-06-23 17:58:33","2","2020-06-23 17:58:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:58: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":["8541","RENT","\u9810\u7e73\u79df\u91d1",9,981,"MO","1",981,"2","2020-06-23 17:58:33","2","2020-06-23 17:58:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:58: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":["8541","RENT","\u9810\u7e73\u79df\u91d1",10,981,"MO","1",981,"2","2020-06-23 17:58:33","2","2020-06-23 17:58:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:58: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":["8541","RENT","\u9810\u7e73\u79df\u91d1",11,981,"MO","1",981,"2","2020-06-23 17:58:33","2","2020-06-23 17:58:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:58: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":["8541","RENT","\u9810\u7e73\u79df\u91d1",12,981,"MO","1",981,"2","2020-06-23 17:58:33","2","2020-06-23 17:58:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:58: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":["8541","RENT","\u9810\u7e73\u79df\u91d1",13,981,"MO","1",981,"2","2020-06-23 17:58:33","2","2020-06-23 17:58:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:58:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11772,0,"8541"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-23 17:58: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":[828,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208184","2020-06-23 17:58:33",11772,"2","2020-06-23 17:58:33","2","2020-06-23 17:58:33","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:58: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":["8184","DEPOSIT",null,"PAID","2020-06-23 17:58:33",0,"2","2020-06-23 17:58:33","2","2020-06-23 17:58:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 17:58: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":["8184","INVOICE","8541","PAID","2020-06-23 17:58:33",11772,"2","2020-06-23 17:58:33","2","2020-06-23 17:58:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-23 18:59:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201639","PERSONAL","Mr","ufXvNRUeTRljqgACPZsDTw==","ddrfzAYTmkL\/QNu3psjONQ==","","eY\/pJrM0jQu7tDmE3HqRBg==",null,"Rxj7yg2saEM7kFyM+UVWpOEB9DTZR4ltJ07DeNNlvrs=","GdyuY9yXus+qmbYp1EHImQ==","",null,"tvHTbWKO88FGKY0bJGkPFQ==","2","2020-06-23 18:59:23","2","2020-06-23 18:59:23"]},"data_before":[],"data_after":[],"step":1} *****