\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>
C15-018 <\/td>\n\t\t\t\t\t	4X3X6.5 <\/td>\n\t\t\t\t\t	$810.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\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":"729.00","deposit":"810.00","total_retail_price":"810.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:06:33","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":["C201554","PERSONAL","Mr","XNe+Iz\/0eyR8GlPYrGuJ4A==","uwdKi3S38jh5+tBibXKG4A==","","u+2tSFamy2ZQu7iHPks7Tw==","JsI3EG89WO7DSHLpC8AVuBgDMCroDgaOPAZ3+SpmPGk=","3LMYIIoeaYwzOAMmd4l9D7\/55XYq224H5KTm8PR7KdE39SUeY1nJ2l99nCaSURDMUKRcY7UTiDWPf97iMLXI6w==","UKeLBCiGh\/K9xb0f5J\/lhg==",null,"JsI3EG89WO7DSHLpC8AVuBgDMCroDgaOPAZ3+SpmPGk=","plO1JtXNRaTSZ2nQXvAe6g==","2","2020-04-09 18:06:32","2","2020-04-09 18:06:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:06:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","3","6",1554,"NEW","C15-CT207594",810,729,810,0,"12","12",7128,9618,7188,"2020-04-09 18:06:34","0",null,null,null,"2020-04-10","2021-04-09","12 months contract. Special offer the 11th & 12th month free, 50% discount for the first 3 months. Storage rental and deposit paid by bank transfer on Apr 09,2020. Smart card will mail out on Apr 14,2020.","2020-04-10","12",0,null,2430,"2430.00","2","2020-04-09 18:06:32","2","2020-04-09 18:06:32","BANKIN","","","","BANKIN","","","",null,0,"'0005028932","C201554","PERSONAL","Mr","XNe+Iz\/0eyR8GlPYrGuJ4A==","uwdKi3S38jh5+tBibXKG4A==","","3LMYIIoeaYwzOAMmd4l9D7\/55XYq224H5KTm8PR7KdE39SUeY1nJ2l99nCaSURDMUKRcY7UTiDWPf97iMLXI6w==","u+2tSFamy2ZQu7iHPks7Tw==","JsI3EG89WO7DSHLpC8AVuBgDMCroDgaOPAZ3+SpmPGk=","UKeLBCiGh\/K9xb0f5J\/lhg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:06:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7594",1554,"11","1","60.0",60,"2","2020-04-09 18:06:32","2","2020-04-09 18:06:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:06:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"7594"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-04-09 18:06:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7594","1324","810.0","810.00","2","2020-04-09 18:06:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:06:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-10","2021-04-09","1324"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-09 18:06:34","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":["7594","C15-D205354","PAID",810,0,"2021-04-09","2020-04-09 18:06:32","2020-04-09 18:06:32","2","2020-04-09 18:06:32","2","2020-04-09 18:06:32",1554]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:06:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7594",1554,"SETTLED","C15-I207922","2020-04-09 18:06:32","2020-04-10","2","2020-04-09 18:06:32","2","2020-04-09 18:06:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:06:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7922","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-04-09 18:06:32","2","2020-04-09 18:06:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:06:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7922","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-04-09 18:06:32","2","2020-04-09 18:06:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:06:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7922","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,0,"MO","1",0,"2","2020-04-09 18:06:32","2","2020-04-09 18:06:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:06:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7922","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",4,486,"MO","1",486,"2","2020-04-09 18:06:32","2","2020-04-09 18:06:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:06:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7922","RENT","\u9810\u7e73\u79df\u91d1",5,729,"MO","1",729,"2","2020-04-09 18:06:32","2","2020-04-09 18:06:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:06:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7922","RENT","\u9810\u7e73\u79df\u91d1",6,729,"MO","1",729,"2","2020-04-09 18:06:32","2","2020-04-09 18:06:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:06:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7922","RENT","\u9810\u7e73\u79df\u91d1",7,729,"MO","1",729,"2","2020-04-09 18:06:32","2","2020-04-09 18:06:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:06:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7922","RENT","\u9810\u7e73\u79df\u91d1",8,729,"MO","1",729,"2","2020-04-09 18:06:32","2","2020-04-09 18:06:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:06:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7922","RENT","\u9810\u7e73\u79df\u91d1",9,729,"MO","1",729,"2","2020-04-09 18:06:32","2","2020-04-09 18:06:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:06:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7922","RENT","\u9810\u7e73\u79df\u91d1",10,729,"MO","1",729,"2","2020-04-09 18:06:32","2","2020-04-09 18:06:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:06:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7922","RENT","\u9810\u7e73\u79df\u91d1",11,729,"MO","1",729,"2","2020-04-09 18:06:32","2","2020-04-09 18:06:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:06:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7922","RENT","\u9810\u7e73\u79df\u91d1",12,729,"MO","1",729,"2","2020-04-09 18:06:32","2","2020-04-09 18:06:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:06:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7922","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-04-09 18:06:32","2","2020-04-09 18:06:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:06:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6378,0,"7922"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-09 18:06:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1554,"BANKIN","","","","BANKIN","","","","PAID","P207569","2020-04-09 18:06:32",7188,"2","2020-04-09 18:06:32","2","2020-04-09 18:06:32","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:06:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7569","DEPOSIT","5354","PAID","2020-04-09 18:06:32",810,"2","2020-04-09 18:06:32","2","2020-04-09 18:06:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:06:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7569","INVOICE","7922","PAID","2020-04-09 18:06:32",6378,"2","2020-04-09 18:06:32","2","2020-04-09 18:06:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:31:01","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=806&filter3=undefined","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":574,"customer_code":"C170574","identity_type":"BUSINESS","identity_id":"67544417-000","title":"Ms","lastname":"Kwok","firstname":"Yuet Wah Albertina","companyname":"Boba Cafe 128","email":"tinaywk33@hotmail.com","tel":"66871716","address":"G\/F, Shop 1, 128 Ap Lei Chau Main Road, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-03","renew_room_key":"055,07586","renew_remark":"1 month contract. Storage rental paid by bank transfer on March 17, 2020. Storage deposit transferred from agreement A12-CT207122 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207423, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"144","room_code":"C20","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-03","rent_from":"2020-03-03","rent_to":"2020-04-02","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on April 3, 2020. Storage deposit transferred from agreement A12-CT207423 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,07586","order_product":[],"pass":true}},"first_order_id":"4722","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> C20 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:31:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",574,"NEW","A12-CT207595",1098,1038,0,0,"1","1",1038,1038,1038,"2020-04-09 18:31:01","0",null,null,null,"2020-03-03","2020-04-02","1 month contract. Storage rental paid by bank transfer on April 3, 2020. Storage deposit transferred from agreement A12-CT207423 to this agreement.","2020-03-03","16",0,null,0,"0","2","2020-04-09 18:31:01","2","2020-04-09 18:31:01","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,07586","C170574","BUSINESS","Ms","A+uRj8p7tDqEbQijhd95GjDFnFB7Op1AqPZ9q\/ChjGU=","+pNULpsInm3siHASV0hIrg==","Boba Cafe 128","Isk4kzOjkF6xeDXceSf25KVcGBgp\/FxQCSbLWl0WDEisZ9I5jVSpGA0hu4eHP+cqW9lXYIwIK1KYgWa8VI8QkA==","cqSYrPZcLGU6olheKS6TwQ==","HyiE2BUsNgIyg65jh\/6C9e6snrjutNDWNVbS\/MDm\/20=",null,"O33I8t0JzOwsECFDTsBzRw==",1,"4722"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:31:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7595","144","1098.0","1098.00","2","2020-04-09 18:31:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:31:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-03","2020-04-02","144"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-09 18:31:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7595",574,"SETTLED","A12-I207923","2020-04-09 18:31:01","2020-03-03","2","2020-04-09 18:31:01","2","2020-04-09 18:31:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:31:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7923","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-04-09 18:31:01","2","2020-04-09 18:31:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:31:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"7923"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-09 18:31:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[574,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207570","2020-04-09 18:31:01",1038,"2","2020-04-09 18:31:01","2","2020-04-09 18:31:01","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:31:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7570","DEPOSIT",null,"PAID","2020-04-09 18:31:01",0,"2","2020-04-09 18:31:01","2","2020-04-09 18:31:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:31:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7570","INVOICE","7923","PAID","2020-04-09 18:31:01",1038,"2","2020-04-09 18:31:01","2","2020-04-09 18:31:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:35:51","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=806&filter3=undefined&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1217,"customer_code":"C191217","identity_type":"PERSONAL","identity_id":"D447759(7)","title":"Ms","lastname":"HUI","firstname":"Mei Ying","companyname":"","email":"florahui23@gmail.com","tel":"91760388","address":"21B, Kam Fat Bldg, 145 Lee Chi Rd, Apleichau, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-14","renew_room_key":"'0006047753","renew_remark":"1 month contract. Storage rental paid by bank transfer on March 4, 2020. Storage deposit transferred from agreement A05-CT207097 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT207322, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"114","order_discount":[],"order_room":[{"room_id":"1010","room_code":"A05-008","retail_price":"1290.0","discounted_price":"1290.00","location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1290,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-14","rent_from":"2020-04-14","rent_to":"2020-05-13","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on April 9, 2020. Storage deposit transferred from agreement A05-CT207322 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0006047753","order_product":[],"pass":true}},"first_order_id":"4509","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-008 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1290.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:35: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","4",1217,"NEW","A05-CT207596",1290,1290,0,0,"1","1",1290,1290,1290,"2020-04-09 18:35:51","0",null,null,null,"2020-04-14","2020-05-13","1 month contract. Storage rental paid by bank transfer on April 9, 2020. Storage deposit transferred from agreement A05-CT207322 to this agreement.\r\n","2020-04-14","16",0,null,0,"0","2","2020-04-09 18:35:51","2","2020-04-09 18:35:51","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0006047753","C191217","PERSONAL","Ms","itB3q7EVO34a2hxkwiPhKw==","SLPJ+c2smshjwdK17xoj0w==","","ueCxoUZm7SuNCZWvZfej2KDREwW7lwoKDTTNZzTAoaO5sqnLfLBRCkfNGM8f7yinGogt7bT6sVG5LxuicUK9\/w==","6zI+PZPtByw9BmzFx6tCzA==","YTLujwAtYb1\/RI+1mL1DaVX7TvWW5ErARjMcxpk9WYA=","vm7DP84yeg7qminXe9MP\/Q==",null,1,"4509"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:35: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":["7596","1010","1290.0","1290.00","2","2020-04-09 18:35:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:35: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-04-14","2020-05-13","1010"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-09 18:35: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":["7596",1217,"SETTLED","A05-I207924","2020-04-09 18:35:51","2020-04-14","2","2020-04-09 18:35:51","2","2020-04-09 18:35:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:35: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":["7924","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-04-09 18:35:51","2","2020-04-09 18:35:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:35:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"7924"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-09 18:35: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":[1217,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207571","2020-04-09 18:35:51",1290,"2","2020-04-09 18:35:51","2","2020-04-09 18:35:51","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:35: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":["7571","DEPOSIT",null,"PAID","2020-04-09 18:35:51",0,"2","2020-04-09 18:35:51","2","2020-04-09 18:35:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:35: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":["7571","INVOICE","7924","PAID","2020-04-09 18:35:51",1290,"2","2020-04-09 18:35:51","2","2020-04-09 18:35:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18: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=806&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":423,"customer_code":"C170423","identity_type":"PERSONAL","identity_id":"E417712(A)","title":"Mrs","lastname":"Kwok Shiu","firstname":"Siu Lay Shirley","companyname":"","email":"se-kwok@hotmail.com","tel":"91904490","address":"18B, 52 Mount Davis Rd ,Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4499.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-10","renew_room_key":"055,32590","renew_remark":"1 month contract. Storage rental paid by bank transfer on March 9, 2020. Storage deposit transferred from agreement A14-CT207184 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207366, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"44","order_discount":[],"order_room":[{"room_id":"522","room_code":"K59","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"521","room_code":"K58","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"520","room_code":"K57","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"519","room_code":"K56","retail_price":"1768.0","discounted_price":"1768.00","location_id":"2"}],"roughly_size":"72","total_retail_price":5062,"total_discounted_price":4499,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":4499,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-10","rent_from":"2020-04-10","rent_to":"2020-05-09","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on April 8, 2020. Storage deposit transferred from agreement A14-CT207366 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4499,"final_order_total":4499,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,32590","order_product":[],"pass":true}},"first_order_id":"4832","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> K59 <\/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> K58 <\/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> K57 <\/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> K56 <\/td>\r\n\t\t\t\t\t 4X6X8 <\/td>\r\n\t\t\t\t\t $1768.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/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":"72","total_discounted_price":"4499.0","deposit":"0","total_retail_price":"5062.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:40:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",423,"NEW","A14-CT207597",5062,4499,0,0,"1","1",4499,4499,4499,"2020-04-09 18:40:22","0",null,null,null,"2020-04-10","2020-05-09","1 month contract. Storage rental paid by bank transfer on April 8, 2020. Storage deposit transferred from agreement A14-CT207366 to this agreement.\r\n","2020-04-10","72",0,null,0,"0","2","2020-04-09 18:40:22","2","2020-04-09 18:40:22","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,32590","C170423","PERSONAL","Mrs","+cSauOfzf4UKH6i9E\/o3Ow==","9BE1lGM5+6cl7FB3cBYT\/Q==","","QuHHgcx1ghORfe6aPTL+cwHs9gJpW87+Y84Si6oTDbtaPpyzLd7Q86Xo4RoVzL1i","uWe4YUxvL5KuigFTIBklFw==","CBE2gpTh\/+LjBRyyCUBxTx7oEtKfkCZ0NTTPgR4mc0Q=","I\/c6FTBu+Cf57wsquAGAzA==",null,1,"4832"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:40:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7597","522","1098.0","1098.00","2","2020-04-09 18:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:40:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-10","2020-05-09","522"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-09 18:40:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7597","521","1098.0","1098.00","2","2020-04-09 18:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:40:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-10","2020-05-09","521"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-09 18:40:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7597","520","1098.0","1098.00","2","2020-04-09 18:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:40:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-10","2020-05-09","520"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-09 18:40:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7597","519","1768.0","1768.00","2","2020-04-09 18:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:40:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-10","2020-05-09","519"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-09 18:40:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7597",423,"SETTLED","A14-I207925","2020-04-09 18:40:22","2020-04-10","2","2020-04-09 18:40:22","2","2020-04-09 18:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:40:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7925","RENT","\u9810\u7e73\u79df\u91d1",1,4499,"MO","1",4499,"2","2020-04-09 18:40:22","2","2020-04-09 18:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:40:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4499,0,"7925"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-09 18:40:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[423,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207572","2020-04-09 18:40:22",4499,"2","2020-04-09 18:40:22","2","2020-04-09 18:40:22","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:40:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7572","DEPOSIT",null,"PAID","2020-04-09 18:40:22",0,"2","2020-04-09 18:40:22","2","2020-04-09 18:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:40:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7572","INVOICE","7925","PAID","2020-04-09 18:40:22",4499,"2","2020-04-09 18:40:22","2","2020-04-09 18:40:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:42:32","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=806&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":814,"customer_code":"C180814","identity_type":"PERSONAL","identity_id":"D552760(1)","title":"Ms","lastname":"Cheng","firstname":"Lai Fun","companyname":"","email":"tracy_chenghk@yahoo.com","tel":"62791100","address":"Flat F, 12\/F, Tower 23, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"6","renew_warehousing_date":"2020-04-08","renew_room_key":"054,57998","renew_remark":"6 months contract. Storage rental paid by bank transfer on October 7, 2019. Storage deposit transferred from agreement A14-CT194711 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196091, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"621","room_code":"M32","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-08","rent_from":"2020-04-08","rent_to":"2020-10-07","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on April 8, 2020. Storage deposit transferred from agreement A14-CT196091 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,57998","order_product":[],"pass":true}},"first_order_id":"4711","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> M32 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"538.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:42:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",814,"NEW","A14-CT207598",598,538,0,0,"6","6",3228,3228,3228,"2020-04-09 18:42:32","0",null,null,null,"2020-04-08","2020-10-07","6 months contract. Storage rental paid by bank transfer on April 8, 2020. Storage deposit transferred from agreement A14-CT196091 to this agreement.\r\n","2020-04-08","12",0,null,0,"0","2","2020-04-09 18:42:32","2","2020-04-09 18:42:32","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,57998","C180814","PERSONAL","Ms","fAFtEXzytqncy09Fx4kO+Q==","UCPBCXrBLI9U7KKsPqgmNA==","","ErRLu+55kiyH4Scnav6flupG6Er\/5cSDMhLoZ\/FM634egvgBZy330tUn5vhk1hxWi1oX\/6uAqsu4\/baJ8VqSJw==","81xhikyJD5dC\/9hsp1CYfg==","rnnJZPkqJpkFRJ9WWOHayBnia0XkMXNuMVNxwwFq4PQ=","6\/3n7LAVL4C3cFCN9+A34Q==",null,1,"4711"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:42:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7598","621","598.0","598.00","2","2020-04-09 18:42:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:42:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-08","2020-10-07","621"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-09 18:42:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7598",814,"SETTLED","A14-I207926","2020-04-09 18:42:32","2020-04-08","2","2020-04-09 18:42:32","2","2020-04-09 18:42:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:42:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7926","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-04-09 18:42:32","2","2020-04-09 18:42:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:42:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7926","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-04-09 18:42:32","2","2020-04-09 18:42:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:42:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7926","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-04-09 18:42:32","2","2020-04-09 18:42:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:42:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7926","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-04-09 18:42:32","2","2020-04-09 18:42:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:42:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7926","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-04-09 18:42:32","2","2020-04-09 18:42:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:42:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7926","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-04-09 18:42:32","2","2020-04-09 18:42:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:42:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"7926"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-09 18:42:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[814,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207573","2020-04-09 18:42:32",3228,"2","2020-04-09 18:42:32","2","2020-04-09 18:42:32","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:42:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7573","DEPOSIT",null,"PAID","2020-04-09 18:42:32",0,"2","2020-04-09 18:42:32","2","2020-04-09 18:42:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:42:32","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7573","INVOICE","7926","PAID","2020-04-09 18:42:32",3228,"2","2020-04-09 18:42:32","2","2020-04-09 18:42:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:48:48","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=806&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","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"412","master_room_id":"34","room_code":"I03"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\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> I03 <\/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","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"E977043(0)","title":"Ms","lastname":"Chan","firstname":"Mei Wah Ven","companyname":"","email":"venchan@gmail.com","tel":"91990353","address":"D1002,44 Guildford Road,villa Verde, The Peak,H.K","pass":true,"customer_id":"145","customer_code":"C160145","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"412","room_code":"I03","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":12000,"deposit":12000,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":52800,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"31200.00","warehousing_date":"2020-04-09","rent_from":"2020-04-09","rent_to":"2020-10-08","delivery_service":"0","remark":"6 months contract. Special offer $6800\/month and one month deposit only. Storage rental $40800 paid by bank transfer on April 9, 2020. Storage deposit $12000 will be paid on April 14, 2020.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":31200,"order_total":84000,"final_order_total":52800,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190,01580","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"12000.00","deposit":"12000.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:48:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2","145","NEW","A14-CT207599",998,12000,12000,0,"6","6",52800,84000,52800,"2020-04-09 18:48:49","0",null,null,null,"2020-04-09","2020-10-08","6 months contract. Special offer $6800\/month and one month deposit only. Storage rental $40800 paid by bank transfer on April 9, 2020. Storage deposit $12000 will be paid on April 14, 2020.","2020-04-09","12",0,null,31200,"31200.00","2","2020-04-09 18:48:48","2","2020-04-09 18:48:48","CHEQUE","","","","BANKIN","","","",null,0,"190,01580","C160145","PERSONAL","Ms","Ps58cFxueaE7i8yv5nEb5Q==","U9yoE9KqV1v8YlRkf7Q2yg==","","r4NOiYQfJocJuIEUFQeqswRDdEiILoicLAYF2kqSLC08kR7nKRQvG904KN\/nFMsaVesFym3ag0gRazQs9YGaqw==","8hkW3TK7c\/RoJvICplCJeg==","LZhn04scSbSrqCOnaaqgidipvbajvnVdNFVlZYnA4WU=","u7SfxKyCnqMBHuorykGupw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:48:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7599","412","998.0","998.00","2","2020-04-09 18:48:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:48:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-09","2020-10-08","412"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-09 18:48:49","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":["7599","A14-D205355","PAID",12000,0,"2020-10-08","2020-04-09 18:48:48","2020-04-09 18:48:48","2","2020-04-09 18:48:48","2","2020-04-09 18:48:48","145"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:48:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7599","145","SETTLED","A14-I207927","2020-04-09 18:48:48","2020-04-09","2","2020-04-09 18:48:48","2","2020-04-09 18:48:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:48:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7927","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-04-09 18:48:48","2","2020-04-09 18:48:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:48:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7927","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-04-09 18:48:48","2","2020-04-09 18:48:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:48:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7927","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,4800,"MO","1",4800,"2","2020-04-09 18:48:48","2","2020-04-09 18:48:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:48:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7927","RENT","\u9810\u7e73\u79df\u91d1",4,12000,"MO","1",12000,"2","2020-04-09 18:48:48","2","2020-04-09 18:48:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:48:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7927","RENT","\u9810\u7e73\u79df\u91d1",5,12000,"MO","1",12000,"2","2020-04-09 18:48:48","2","2020-04-09 18:48:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:48:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7927","RENT","\u9810\u7e73\u79df\u91d1",6,12000,"MO","1",12000,"2","2020-04-09 18:48:48","2","2020-04-09 18:48:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:48:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[40800,0,"7927"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-09 18:48:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["145","CHEQUE","","","","BANKIN","","","","PAID","P207574","2020-04-09 18:48:48",52800,"2","2020-04-09 18:48:48","2","2020-04-09 18:48:48","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:48:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7574","DEPOSIT","5355","PAID","2020-04-09 18:48:48",12000,"2","2020-04-09 18:48:48","2","2020-04-09 18:48:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 18:48:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7574","INVOICE","7927","PAID","2020-04-09 18:48:48",40800,"2","2020-04-09 18:48:48","2","2020-04-09 18:48:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 19:02:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-09 19:40:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****