\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>
B01-061 <\/td>\n\t\t\t\t\t	4X4X7 <\/td>\n\t\t\t\t\t	$1112.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\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":"16","total_discounted_price":"868.00","deposit":"2224.00","total_retail_price":"1112.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:13: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` = ?","parameters":["1","2","5","1551","NEW","B01-CT207703",1112,868,2224,0,"12","12",10904,12700,10964,"2020-04-23 11:13:59","0",null,null,null,"2020-04-08","2021-04-07","12 months contract. Special offer the 11th and 12th months free. Storage rental and deposit paid by bank transfer on Apr 02,2020. Smart card paid on the same day. Smart card provided on Apr 22,2020.","2020-04-08","16",0,null,1736,"1736.00","2","2020-04-23 11:13:59","2","2020-04-23 11:13:59","BANKIN","","","","BANKIN","","","",null,0,"'0005763927","C201551","PERSONAL","Ms","IGFZP+fjajzeRCuuGCn1bg==","cehTPCv0LSZ1f3zKZGLhBA==","","ChCdC9OG+HtgN3rpvXsYQR1fMAfL5nRZy8dFzzCcb0jswyykQtUZD6O1HQ6Y6xKu8Hcz5o2c00g5Bl8c\/831Hg==","ZOUmooCBOLidmanOdiw1Sg==",null,"jgn6D7EeOKaLd2E4BNcEmg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:13: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":["7703","341 available_room_list_input","140","1251","%","34.90",388.088,"2","2020-04-23 11:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:13:59","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":["7703","1551","11","1","60.0",60,"2","2020-04-23 11:13:59","2","2020-04-23 11:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:13:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"7703"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-04-23 11:13: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":["7703","1251","1112.0",723.9,"2","2020-04-23 11:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:13: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-04-08","2021-04-07","1251"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-23 11:13:59","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":["7703","B01-D205384","PAID",2224,0,"2021-04-07","2020-04-23 11:13:59","2020-04-23 11:13:59","2","2020-04-23 11:13:59","2","2020-04-23 11:13:59","1551"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:13: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":["7703","1551","SETTLED","B01-I208031","2020-04-23 11:13:59","2020-04-08","2","2020-04-23 11:13:59","2","2020-04-23 11:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:13: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":["8031","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-04-23 11:13:59","2","2020-04-23 11:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:13: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":["8031","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,868,"MO","1",868,"2","2020-04-23 11:13:59","2","2020-04-23 11:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:13: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":["8031","RENT","\u9810\u7e73\u79df\u91d1",4,868,"MO","1",868,"2","2020-04-23 11:13:59","2","2020-04-23 11:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:13: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":["8031","RENT","\u9810\u7e73\u79df\u91d1",5,868,"MO","1",868,"2","2020-04-23 11:13:59","2","2020-04-23 11:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:13: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":["8031","RENT","\u9810\u7e73\u79df\u91d1",6,868,"MO","1",868,"2","2020-04-23 11:13:59","2","2020-04-23 11:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:13: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":["8031","RENT","\u9810\u7e73\u79df\u91d1",7,868,"MO","1",868,"2","2020-04-23 11:13:59","2","2020-04-23 11:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:13: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":["8031","RENT","\u9810\u7e73\u79df\u91d1",8,868,"MO","1",868,"2","2020-04-23 11:13:59","2","2020-04-23 11:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:13: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":["8031","RENT","\u9810\u7e73\u79df\u91d1",9,868,"MO","1",868,"2","2020-04-23 11:13:59","2","2020-04-23 11:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:13: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":["8031","RENT","\u9810\u7e73\u79df\u91d1",10,868,"MO","1",868,"2","2020-04-23 11:13:59","2","2020-04-23 11:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:13: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":["8031","RENT","\u9810\u7e73\u79df\u91d1",11,868,"MO","1",868,"2","2020-04-23 11:13:59","2","2020-04-23 11:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:13: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":["8031","RENT","\u9810\u7e73\u79df\u91d1",12,868,"MO","1",868,"2","2020-04-23 11:13:59","2","2020-04-23 11:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:13:59","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":["8031","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-04-23 11:13:59","2","2020-04-23 11:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:13:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8740,0,"8031"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-23 11:13: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":["1551","BANKIN","","","","BANKIN","","","","PAID","P207677","2020-04-23 11:13:59",10964,"2","2020-04-23 11:13:59","2","2020-04-23 11:13:59","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:13: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":["7677","DEPOSIT","5384","PAID","2020-04-23 11:13:59",2224,"2","2020-04-23 11:13:59","2","2020-04-23 11:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:13: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":["7677","INVOICE","8031","PAID","2020-04-23 11:13:59",8740,"2","2020-04-23 11:13:59","2","2020-04-23 11:13:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:27:32","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","'0005763927","12 months contract. Special offer the 11th and 12th month free. Storage rental and deposit paid by bank transfer on Apr 02,2020. Smartcard paid on the same day. Smart card mailed out on Apr 03,2020.","2020-04-23 11:27:32","2","cehTPCv0LSZ1f3zKZGLhBA==","IGFZP+fjajzeRCuuGCn1bg==","ZOUmooCBOLidmanOdiw1Sg==","ChCdC9OG+HtgN3rpvXsYQR1fMAfL5nRZy8dFzzCcb0jswyykQtUZD6O1HQ6Y6xKu8Hcz5o2c00g5Bl8c\/831Hg==",7563]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:33:10","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":"","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1541,"customer_code":"C201541","identity_type":"PERSONAL","identity_id":"R067540(6)","title":"Ms","lastname":"CHENG","firstname":"Oi Ying Andrea","companyname":"","email":"andrea@senreve.com","tel":"63834224","address":"10\/F, WeWork, 33 Lockhart Road, Wan Chai, HK.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1768.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-23","renew_room_key":"191,03188","renew_remark":"1 month contract. Special offer 5% discount. Storage rental and deposit paid by bank transfer on Mar 20,2020. Smart card mailed out on the same day.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207460, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $3536.0","renew_master_room_id":"11","order_discount":[],"order_room":[{"room_id":"379","room_code":"G20","retail_price":"1768.0","discounted_price":"1768.00","location_id":"1"}],"roughly_size":"24","total_retail_price":1768,"total_discounted_price":1768,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1768,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-23","rent_from":"2020-04-23","rent_to":"2020-05-22","delivery_service":"0","remark":"1 month contract. Storage rental and deposit paid by bank transfer on April 22,2020.Storage deposit transferred from agreement A12-CT207460 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1768,"final_order_total":1768,"location_id":"1","branch_id":"1","company_id":"1","room_key":"191,03188","order_product":[],"pass":true}},"first_order_id":7460,"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> G20 <\/td>\r\n\t\t\t\t\t 4X6X8 <\/td>\r\n\t\t\t\t\t $1768.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1768.0","deposit":"0.00","total_retail_price":"1768.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:33:11","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",1541,"NEW","A12-CT207704",1768,1768,0,0,"1","1",1768,1768,1768,"2020-04-23 11:33:11","0",null,null,null,"2020-04-23","2020-05-22","1 month contract. Storage rental and deposit paid by bank transfer on April 22,2020.Storage deposit transferred from agreement A12-CT207460 to this agreement.\r\n","2020-04-23","24",0,null,0,"0","2","2020-04-23 11:33:10","2","2020-04-23 11:33:10","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"191,03188","C201541","PERSONAL","Ms","tC7uPunajh0MRBsyfcX7gw==","+DIqoIiVKYgoYtcxzTTCmw==","","eyxC82qUseKWnLp4mebzuglMoPDApORAHfh7k9cbwIPiP1NTghgf25md1+thXRh5","28+P2\/aXUQjCETOiwFwJGg==","ymnNl12u9uxxHzvQb5vAeAeyQ6RAYV6r6UCAdCjC10I=","6B+IEP7FH0F6giORvS3q+Q==",null,1,7460]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:33:11","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":["7704","379","1768.0","1768.00","2","2020-04-23 11:33:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:33:11","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-23","2020-05-22","379"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-23 11:33:11","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":["7704",1541,"SETTLED","A12-I208032","2020-04-23 11:33:10","2020-04-23","2","2020-04-23 11:33:10","2","2020-04-23 11:33:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:33:11","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":["8032","RENT","\u9810\u7e73\u79df\u91d1",1,1768,"MO","1",1768,"2","2020-04-23 11:33:10","2","2020-04-23 11:33:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:33:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1768,0,"8032"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-23 11:33:11","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":[1541,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207678","2020-04-23 11:33:10",1768,"2","2020-04-23 11:33:10","2","2020-04-23 11:33:10","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:33:11","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":["7678","DEPOSIT",null,"PAID","2020-04-23 11:33:10",0,"2","2020-04-23 11:33:10","2","2020-04-23 11:33:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:33:11","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":["7678","INVOICE","8032","PAID","2020-04-23 11:33:10",1768,"2","2020-04-23 11:33:10","2","2020-04-23 11:33:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:44:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:44:29","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","\u20180012489009\u2019","12 months contract. Special offer the 11th & 12th months free and extra 5% discount. Storage rental and deposit paid by bank transfer on Apr 21,2020. Smart card was given on Apr 22,2020.","2020-04-23 11:44:29","2","6iEwAEulQQ5kKFL3ldVmmg==","o2EIBQ5L0V+W9LA6gIA5vw==","KWdojZtS16kg4xegG9NKSLpWrDnAbg3eJaBRSO9EugI=","ySu6obc\/oEYd7heM0CBoIA==","oA+\/aueZVHwRAIN\/ukTH4SJLXrUROhNys\/4gQU+gJ32FyAEexhxXbeSRVMwSPKs8xYctnucrNg8zSRNGwYxJkUQ\/70NP3Z+Sf2EFlrlf188\/L0xi9AR8cQTTYmuUkekq",7699]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:47:17","login_id":"2","controller":"room_modify.php","function":"update query","input":{"sql":"update room set code = ?, status = ?, master_room_id = ?, typeid = ?, lastupby = ?, lastupdate = ? where id = ?","parameters":["A41","OPEN","8","STORAGE","2","2020-04-23 11:47:17","41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:47:17","login_id":"2","controller":"room_modify.php","function":"update query","input":{"sql":"update room set code = ?, status = ?, master_room_id = ?, typeid = ?, lastupby = ?, lastupdate = ? where id = ?","parameters":["A42","OPEN","8","STORAGE","2","2020-04-23 11:47:17","42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 11:47:17","login_id":"2","controller":"room_modify.php","function":"update query","input":{"sql":"update room set code = ?, status = ?, master_room_id = ?, typeid = ?, lastupby = ?, lastupdate = ? where id = ?","parameters":["A43","OPEN","8","STORAGE","2","2020-04-23 11:47:17","43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:04:27","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":"","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":387,"customer_code":"C170387","identity_type":"PERSONAL","identity_id":"E589151(9)","title":"Mr","lastname":"Yip","firstname":"Kam Wah","companyname":"","email":"kwip1954@gmail.com","tel":"56688982","address":"Flat C, Blk 6, 27\/F , Pokfulam Gardens, Pokfulam, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1358.0","renew_rent_month":"6","renew_warehousing_date":"2020-04-28","renew_room_key":"055,37597","renew_remark":"6 months contract. Storage rental paid by bank transfer on October 16, 2019. Storage deposit transferred from agreement A12-CT194844 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196153, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"11","order_discount":[{"master_room_discount_id":"80","master_room_id":"11","discount_type":"%","price":"1768.00","disocunted_price":"1592.10","discount":"9.95","monthly_deduct":175.916,"room_id":"385","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"385","room_code":"G26","retail_price":"1768.0","discounted_price":1592.1,"location_id":"1"}],"roughly_size":"24","total_retail_price":1768,"total_discounted_price":1358,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":8148,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-28","rent_from":"2020-04-28","rent_to":"2020-10-27","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on April 23, 2020. Storage deposit transferred from agreement A12-CT196153 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":8148,"final_order_total":8148,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,37597","order_product":[],"pass":true}},"first_order_id":"4844","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> G26 <\/td>\r\n\t\t\t\t\t 4X6X8 <\/td>\r\n\t\t\t\t\t $1768.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1358.0","deposit":"0.00","total_retail_price":"1768.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:04:28","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",387,"NEW","A12-CT207705",1768,1358,0,0,"6","6",8148,8148,8148,"2020-04-23 12:04:28","0",null,null,null,"2020-04-28","2020-10-27","6 months contract. Storage rental paid by bank transfer on April 23, 2020. Storage deposit transferred from agreement A12-CT196153 to this agreement.\r\n","2020-04-28","24",0,null,0,"0","2","2020-04-23 12:04:27","2","2020-04-23 12:04:27","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,37597","C170387","PERSONAL","Mr","xqUSxgCDmfjSDF9dbsoBww==","H9gmHz05\/Te4s1\/V+q8XVg==","","LSCb9E4o8NnQjMgHMCl6ohqJAptHPKO30+6lIoVVOsVVK4vTdv5U2cmm+\/yok5QE5unTVsF\/EGOOdG3lYUNzwg==","66lDx1EnC8bsMtjff\/Wo2A==","jEck1Znrcy73qnm1\/XFN9QKKLAA\/JpVsNZqOV0\/7Hvs=","KBDKq5Rrgno7616eY9H9RA==",null,1,"4844"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:04:28","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":["7705","80","11","385","%","9.95",175.916,"2","2020-04-23 12:04:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:04:28","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":["7705","385","1768.0",1592.1,"2","2020-04-23 12:04:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:04:28","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-28","2020-10-27","385"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-23 12:04:28","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":["7705",387,"SETTLED","A12-I208033","2020-04-23 12:04:27","2020-04-28","2","2020-04-23 12:04:27","2","2020-04-23 12:04:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:04:28","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":["8033","RENT","\u9810\u7e73\u79df\u91d1",1,1358,"MO","1",1358,"2","2020-04-23 12:04:27","2","2020-04-23 12:04:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:04:28","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":["8033","RENT","\u9810\u7e73\u79df\u91d1",2,1358,"MO","1",1358,"2","2020-04-23 12:04:27","2","2020-04-23 12:04:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:04:28","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":["8033","RENT","\u9810\u7e73\u79df\u91d1",3,1358,"MO","1",1358,"2","2020-04-23 12:04:27","2","2020-04-23 12:04:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:04:28","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":["8033","RENT","\u9810\u7e73\u79df\u91d1",4,1358,"MO","1",1358,"2","2020-04-23 12:04:27","2","2020-04-23 12:04:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:04:28","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":["8033","RENT","\u9810\u7e73\u79df\u91d1",5,1358,"MO","1",1358,"2","2020-04-23 12:04:27","2","2020-04-23 12:04:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:04:28","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":["8033","RENT","\u9810\u7e73\u79df\u91d1",6,1358,"MO","1",1358,"2","2020-04-23 12:04:27","2","2020-04-23 12:04:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:04:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8148,0,"8033"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-23 12:04:28","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":[387,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207679","2020-04-23 12:04:27",8148,"2","2020-04-23 12:04:27","2","2020-04-23 12:04:27","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:04:28","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":["7679","DEPOSIT",null,"PAID","2020-04-23 12:04:27",0,"2","2020-04-23 12:04:27","2","2020-04-23 12:04:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:04:28","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":["7679","INVOICE","8033","PAID","2020-04-23 12:04:27",8148,"2","2020-04-23 12:04:27","2","2020-04-23 12:04:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:11:00","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"41","master_room_id":"8","room_code":"A41"},{"room_id":"42","master_room_id":"8","room_code":"A42"},{"room_id":"43","master_room_id":"8","room_code":"A43"}],"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\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> A41 <\/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> A42 <\/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> A43 <\/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","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"D850870(5)","title":"Mr","lastname":"CHAN","firstname":"Enocn","companyname":"","email":"","tel":"68166820","address":"Aberdeen center, Hong Kong ","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"41","room_code":"A41","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"},{"room_id":"42","room_code":"A42","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"},{"room_id":"43","room_code":"A43","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"48","total_retail_price":3294,"total_discounted_price":2964,"deposit":5928,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":37050,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"7410.00","warehousing_date":"2020-05-01","rent_from":"2020-05-01","rent_to":"2021-05-31","delivery_service":"0","remark":"13 months contract. Special offer 50% off foe the first 3 months and the 13th month free. Storage deposit $1000 paid by EPS on April 14, 2020. Remaining deposit and rental paid by bank transfer on April 23, 2020. Smartcard and padlock will be provided on April 24, 2020. ","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":7410,"order_total":44460,"final_order_total":37050,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190, 22184","order_product":[],"pass":true}},"roughly_size":"48","total_discounted_price":"2964.00","deposit":"5928.00","total_retail_price":"3294.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:11:01","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":["C201568","PERSONAL","Mr","obfJ++xkfrtjhh8pDqzUZw==","8BEgNhGpCR8jGkzUtrIcXg==","","JH6EXFaXq0A\/hSc18bAbEA==",null,"EeavrSZSEcvMVDJSepwBCoKuX08g\/ZyfQWGqRrhY0zY=","zMhJp6GxmdeaHe79ZDE2bA==",null,null,"v5dA575JCPb6bIOcMRkzDA==","2","2020-04-23 12:11:00","2","2020-04-23 12:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:11: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` = ?","parameters":["1","1","1",1568,"NEW","A12-CT207706",3294,2964,5928,0,"13","13",37050,44460,37050,"2020-04-23 12:11:01","0",null,null,null,"2020-05-01","2021-05-31","13 months contract. Special offer 50% off foe the first 3 months and the 13th month free. Storage deposit $1000 paid by EPS on April 14, 2020. Remaining deposit and rental paid by bank transfer on April 23, 2020. Smartcard and padlock will be provided on April 24, 2020. ","2020-05-01","48",0,null,7410,"7410.00","2","2020-04-23 12:11:00","2","2020-04-23 12:11:00","BANKIN","","","","BANKIN","","","",null,0,"190, 22184","C201568","PERSONAL","Mr","obfJ++xkfrtjhh8pDqzUZw==","8BEgNhGpCR8jGkzUtrIcXg==","","EeavrSZSEcvMVDJSepwBCoKuX08g\/ZyfQWGqRrhY0zY=","JH6EXFaXq0A\/hSc18bAbEA==",null,"zMhJp6GxmdeaHe79ZDE2bA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:11: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":["7706","41","1098.0","1098.00","2","2020-04-23 12:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:11: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-05-01","2021-05-31","41"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-23 12:11: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":["7706","42","1098.0","1098.00","2","2020-04-23 12:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:11: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-05-01","2021-05-31","42"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-23 12:11: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":["7706","43","1098.0","1098.00","2","2020-04-23 12:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:11: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-05-01","2021-05-31","43"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-23 12:11:01","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":["7706","A12-D205385","PAID",5928,0,"2021-05-31","2020-04-23 12:11:00","2020-04-23 12:11:00","2","2020-04-23 12:11:00","2","2020-04-23 12:11:00",1568]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:11: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":["7706",1568,"SETTLED","A12-I208034","2020-04-23 12:11:00","2020-05-01","2","2020-04-23 12:11:00","2","2020-04-23 12:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:11: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":["8034","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-04-23 12:11:00","2","2020-04-23 12:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:11: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":["8034","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-04-23 12:11:00","2","2020-04-23 12:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:11: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":["8034","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,1482,"MO","1",1482,"2","2020-04-23 12:11:00","2","2020-04-23 12:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:11: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":["8034","RENT","\u9810\u7e73\u79df\u91d1",4,2964,"MO","1",2964,"2","2020-04-23 12:11:00","2","2020-04-23 12:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:11: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":["8034","RENT","\u9810\u7e73\u79df\u91d1",5,2964,"MO","1",2964,"2","2020-04-23 12:11:00","2","2020-04-23 12:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:11: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":["8034","RENT","\u9810\u7e73\u79df\u91d1",6,2964,"MO","1",2964,"2","2020-04-23 12:11:00","2","2020-04-23 12:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:11: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":["8034","RENT","\u9810\u7e73\u79df\u91d1",7,2964,"MO","1",2964,"2","2020-04-23 12:11:00","2","2020-04-23 12:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:11: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":["8034","RENT","\u9810\u7e73\u79df\u91d1",8,2964,"MO","1",2964,"2","2020-04-23 12:11:00","2","2020-04-23 12:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:11: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":["8034","RENT","\u9810\u7e73\u79df\u91d1",9,2964,"MO","1",2964,"2","2020-04-23 12:11:00","2","2020-04-23 12:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:11: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":["8034","RENT","\u9810\u7e73\u79df\u91d1",10,2964,"MO","1",2964,"2","2020-04-23 12:11:00","2","2020-04-23 12:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:11: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":["8034","RENT","\u9810\u7e73\u79df\u91d1",11,2964,"MO","1",2964,"2","2020-04-23 12:11:00","2","2020-04-23 12:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:11: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":["8034","RENT","\u9810\u7e73\u79df\u91d1",12,2964,"MO","1",2964,"2","2020-04-23 12:11:00","2","2020-04-23 12:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:11: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":["8034","RENT","\u9810\u7e73\u79df\u91d1",13,2964,"MO","1",2964,"2","2020-04-23 12:11:00","2","2020-04-23 12:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:11:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[31122,0,"8034"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-23 12:11:02","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":[1568,"BANKIN","","","","BANKIN","","","","PAID","P207680","2020-04-23 12:11:00",37050,"2","2020-04-23 12:11:00","2","2020-04-23 12:11:00","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:11:02","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":["7680","DEPOSIT","5385","PAID","2020-04-23 12:11:00",5928,"2","2020-04-23 12:11:00","2","2020-04-23 12:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:11:02","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":["7680","INVOICE","8034","PAID","2020-04-23 12:11:00",31122,"2","2020-04-23 12:11:00","2","2020-04-23 12:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 12:11:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 13:10:44","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&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":"25","master_room_id":"8","room_code":"A25"}],"selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> O31 <\/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> O42 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":383,"customer_code":"C170383","identity_type":"PERSONAL","identity_id":"K194533(5)","title":"Mr","lastname":"Shum","firstname":"Ka Fai","companyname":"","email":"garyshum1@yahoo.com.hk","tel":"92602568","address":"Flat H,25\/F,Hoi Ngar Court,South Horizons, Ap Lei Chau, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1607.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-01","renew_room_key":"054,57712","renew_remark":"6 months contract. Storage rental paid by EPS on October 30, 2019. Storage deposit transferred from agreement A14-CT194817 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196258, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"755","room_code":"O31","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"766","room_code":"O42","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"28","total_retail_price":2096,"total_discounted_price":1607,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":19284,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-01","rent_from":"2020-05-01","rent_to":"2021-04-30","delivery_service":"0","remark":"12 months contract. $300 Maxim coupon offered. Storage rental paid by EPS on Apr 23,2020. Storage deposit transferred from agreement A14-CT196258 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":19284,"final_order_total":19284,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,57712","order_product":[],"pass":true}},"first_order_id":"4817","roughly_size":"28","total_discounted_price":"1607.00","deposit":"0.00","total_retail_price":"2096.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 13:10:44","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",383,"NEW","A14-CT207707",2096,1607,0,0,"12","12",19284,19284,19284,"2020-04-23 13:10:44","0",null,null,null,"2020-05-01","2021-04-30","12 months contract. $300 Maxim coupon offered. Storage rental paid by EPS on Apr 23,2020. Storage deposit transferred from agreement A14-CT196258 to this agreement.","2020-05-01","28",0,null,0,"0","2","2020-04-23 13:10:44","2","2020-04-23 13:10:44","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"054,57712","C170383","PERSONAL","Mr","zVlEiKadi4uPrN2vxEA9pw==","AGEJY9amJjL8XQTelTay2w==","","0sIqFrcDtcUUMrpN3VvlKx\/jxiwEgZ80Z6OcFENJnN7NR4p\/PkQ4X2D+FB1ANqgAFORDk5lIcpKTVTWllND2lwvACOl0SNpekl9spWPN0u0=","\/ZNiwY\/zWLgHiGCAuX5vxQ==","wmAkibrd2u6D14IgCG9ZO+363Qg7HmxcOuIq8bIhazA=","4Xp\/TdjXIO2MRWkLHG2tBQ==",null,1,"4817"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 13:10:44","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":["7707","755","998.0","998.00","2","2020-04-23 13:10:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 13:10:44","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-01","2021-04-30","755"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-23 13:10:44","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":["7707","766","1098.0","1098.00","2","2020-04-23 13:10:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 13:10:44","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-01","2021-04-30","766"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-23 13:10:44","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":["7707",383,"SETTLED","A14-I208035","2020-04-23 13:10:44","2020-05-01","2","2020-04-23 13:10:44","2","2020-04-23 13:10:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 13:10:44","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":["8035","RENT","\u9810\u7e73\u79df\u91d1",1,1607,"MO","1",1607,"2","2020-04-23 13:10:44","2","2020-04-23 13:10:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 13:10:44","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":["8035","RENT","\u9810\u7e73\u79df\u91d1",2,1607,"MO","1",1607,"2","2020-04-23 13:10:44","2","2020-04-23 13:10:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 13:10:44","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":["8035","RENT","\u9810\u7e73\u79df\u91d1",3,1607,"MO","1",1607,"2","2020-04-23 13:10:44","2","2020-04-23 13:10:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 13:10:44","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":["8035","RENT","\u9810\u7e73\u79df\u91d1",4,1607,"MO","1",1607,"2","2020-04-23 13:10:44","2","2020-04-23 13:10:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 13:10:44","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":["8035","RENT","\u9810\u7e73\u79df\u91d1",5,1607,"MO","1",1607,"2","2020-04-23 13:10:44","2","2020-04-23 13:10:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 13:10:44","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":["8035","RENT","\u9810\u7e73\u79df\u91d1",6,1607,"MO","1",1607,"2","2020-04-23 13:10:44","2","2020-04-23 13:10:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 13:10:44","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":["8035","RENT","\u9810\u7e73\u79df\u91d1",7,1607,"MO","1",1607,"2","2020-04-23 13:10:44","2","2020-04-23 13:10:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 13:10:44","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":["8035","RENT","\u9810\u7e73\u79df\u91d1",8,1607,"MO","1",1607,"2","2020-04-23 13:10:44","2","2020-04-23 13:10:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 13:10:44","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":["8035","RENT","\u9810\u7e73\u79df\u91d1",9,1607,"MO","1",1607,"2","2020-04-23 13:10:44","2","2020-04-23 13:10:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 13:10:44","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":["8035","RENT","\u9810\u7e73\u79df\u91d1",10,1607,"MO","1",1607,"2","2020-04-23 13:10:44","2","2020-04-23 13:10:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 13:10:44","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":["8035","RENT","\u9810\u7e73\u79df\u91d1",11,1607,"MO","1",1607,"2","2020-04-23 13:10:44","2","2020-04-23 13:10:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 13:10:44","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":["8035","RENT","\u9810\u7e73\u79df\u91d1",12,1607,"MO","1",1607,"2","2020-04-23 13:10:44","2","2020-04-23 13:10:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 13:10:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[19284,0,"8035"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-23 13:10:44","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":[383,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207681","2020-04-23 13:10:44",19284,"2","2020-04-23 13:10:44","2","2020-04-23 13:10:44","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 13:10:44","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":["7681","DEPOSIT",null,"PAID","2020-04-23 13:10:44",0,"2","2020-04-23 13:10:44","2","2020-04-23 13:10:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 13:10:44","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":["7681","INVOICE","8035","PAID","2020-04-23 13:10:44",19284,"2","2020-04-23 13:10:44","2","2020-04-23 13:10:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:28:38","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":23,"customer_code":"C150023","identity_type":"PERSONAL","identity_id":"K474882(4)","title":"Mr","lastname":"Chau","firstname":"Pak Wing","companyname":"","email":"ryuchau2002@yahoo.com.hk","tel":"93430664","address":"3102 ,Tung Ping House Lei Tung Estate ,Aplei chau","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":"2","renew_warehousing_date":"2020-04-01","renew_room_key":"054,43987","renew_remark":"2 months contract. Storage rental $2078 paid by bank transfer on March 2, 2020. Extra $2 will be transferred to next agreement. Storage deposit transferred from agreement A12-CT196811 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207302, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"11","room_code":"A11","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":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":2076,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-01","rent_from":"2020-04-01","rent_to":"2020-05-31","delivery_service":"0","remark":"2 months contract. Storage rental $2,074 paid by bank transfer on April 23, 2020. Remaining balance $2 transferred from A12-CT207302 to this agreement. Storage deposit transferred from agreement A12-CT207302 to this agreement.\r\n\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2076,"final_order_total":2076,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,43987","order_product":[],"pass":true}},"first_order_id":"4412","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> A11 <\/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.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:28:39","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",23,"NEW","A12-CT207708",1098,1038,0,0,"2","2",2076,2076,2076,"2020-04-23 14:28:39","0",null,null,null,"2020-04-01","2020-05-31","2 months contract. Storage rental $2,074 paid by bank transfer on April 23, 2020. Remaining balance $2 transferred from A12-CT207302 to this agreement. Storage deposit transferred from agreement A12-CT207302 to this agreement.\r\n\r\n","2020-04-01","16",0,null,0,"0","2","2020-04-23 14:28:38","2","2020-04-23 14:28:38","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,43987","C150023","PERSONAL","Mr","B0ssw1oIHiki\/Mlb0\/ZDSA==","kOK3vHUlGE9qjoVnzYRDGA==","","PMBzwNQFgvH59lb5Tkl4pvuUMLbNYb\/kdCEBfa2Rd1BuIU1Im27uZJ2kVFx8y4u9KSaRxbwqsPYl3\/wAUgZh7A==","bdymBw6yNxCy25GcBqnAeg==","Yy\/IhnBFwxEgMvMojm6H7pEUv5uRc+ZriXItPiCRhkk=","rpqpQ1cQv7jbufDPn4zVZw==",null,1,"4412"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:28:39","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":["7708","11","1098.0","1098.00","2","2020-04-23 14:28:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:28:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-01","2020-05-31","11"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-23 14:28:39","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":["7708",23,"SETTLED","A12-I208036","2020-04-23 14:28:38","2020-04-01","2","2020-04-23 14:28:38","2","2020-04-23 14:28:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:28:39","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":["8036","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-04-23 14:28:38","2","2020-04-23 14:28:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:28:39","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":["8036","RENT","\u9810\u7e73\u79df\u91d1",2,1038,"MO","1",1038,"2","2020-04-23 14:28:38","2","2020-04-23 14:28:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:28:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2076,0,"8036"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-23 14:28:39","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":[23,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207682","2020-04-23 14:28:38",2076,"2","2020-04-23 14:28:38","2","2020-04-23 14:28:38","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:28:39","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":["7682","DEPOSIT",null,"PAID","2020-04-23 14:28:38",0,"2","2020-04-23 14:28:38","2","2020-04-23 14:28:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:28:39","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":["7682","INVOICE","8036","PAID","2020-04-23 14:28:38",2076,"2","2020-04-23 14:28:38","2","2020-04-23 14:28:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:35: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":"","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":469,"customer_code":"C170469","identity_type":"PERSONAL","identity_id":"E562535(5)","title":"Mr","lastname":"Poon ","firstname":"Yin Ming","companyname":"","email":null,"tel":"67039272","address":"Rm1403,14\/F,Ming Cheun House,Shui Chuen O Estate,Sha Tin","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-24","renew_room_key":"133,33462","renew_remark":"1 month contract. Storage rental paid by bank transfer on March 24, 2020. Storage deposit transferred from agreement A14-CT207279 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207476, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"625","room_code":"M36","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-24","rent_from":"2020-04-24","rent_to":"2020-05-23","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on April 23, 2020. Storage deposit transferred from agreement A14-CT207476 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"133,33462","order_product":[],"pass":true}},"first_order_id":"4725","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> M36 <\/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":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:35: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","2",469,"NEW","A14-CT207709",598,598,0,0,"1","1",598,598,598,"2020-04-23 14:35:33","0",null,null,null,"2020-04-24","2020-05-23","1 month contract. Storage rental paid by bank transfer on April 23, 2020. Storage deposit transferred from agreement A14-CT207476 to this agreement.\r\n","2020-04-24","12",0,null,0,"0","2","2020-04-23 14:35:32","2","2020-04-23 14:35:32","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"133,33462","C170469","PERSONAL","Mr","7zuhiU2fzaatGP2D2mnAJA==","c9CkZ4cZzKCidNu3YYjrkw==","","QJ5AY46e6jExLz0oVTYEajr8ICB272rxLBtUMHgM2LeYYJatyO4QCPJb6GJOXbbZ2qJarCJxAoCZti1Uif3gKw==","2+3VDW\/cQQxeWAv\/Fi3w0Q==",null,"So0zSsBwxE4\/4T3R4c76WA==",null,1,"4725"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:35: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":["7709","625","598.0","598.00","2","2020-04-23 14:35:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:35: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-04-24","2020-05-23","625"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-23 14:35: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":["7709",469,"SETTLED","A14-I208037","2020-04-23 14:35:32","2020-04-24","2","2020-04-23 14:35:32","2","2020-04-23 14:35:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:35: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":["8037","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-04-23 14:35:32","2","2020-04-23 14:35:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:35:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8037"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-23 14:35: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":[469,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207683","2020-04-23 14:35:32",598,"2","2020-04-23 14:35:32","2","2020-04-23 14:35:32","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:35: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":["7683","DEPOSIT",null,"PAID","2020-04-23 14:35:32",0,"2","2020-04-23 14:35:32","2","2020-04-23 14:35:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:35: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":["7683","INVOICE","8037","PAID","2020-04-23 14:35:32",598,"2","2020-04-23 14:35:32","2","2020-04-23 14:35:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:38:36","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":"","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":996,"customer_code":"C180996","identity_type":"PERSONAL","identity_id":"K597299(A)","title":"Ms","lastname":"LI","firstname":"Shu Ngar","companyname":"","email":"alice_sn_li@hotmail.com","tel":"90995304","address":"Flat 615, Block F, Kornhill, Quarry Bay , H.K","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"742.0","renew_rent_month":"12","renew_warehousing_date":"2020-04-27","renew_room_key":"'0005942002","renew_remark":"12 months contract. Storage rental paid by Bank transfer on April 28, 2019. Storage deposit $1796 transferred from agreement C15-CT183302 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT194824, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"167","order_discount":[],"order_room":[{"room_id":"1329","room_code":"C15-023","retail_price":"810.0","discounted_price":"810.00","location_id":"6"}],"roughly_size":"12","total_retail_price":810,"total_discounted_price":742,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":8904,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-27","rent_from":"2020-04-27","rent_to":"2021-04-26","delivery_service":"0","remark":"12 months contract. Storage rental paid by Bank transfer on April 23, 2020. Storage deposit transferred from agreement C15-CT194824 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":8904,"final_order_total":8904,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0005942002","order_product":[],"pass":true}},"first_order_id":4824,"selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-023 <\/td>\r\n\t\t\t\t\t 4X3X6.5 <\/td>\r\n\t\t\t\t\t $810.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"742.0","deposit":"0.00","total_retail_price":"810.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:38:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",996,"NEW","C15-CT207710",810,742,0,0,"12","12",8904,8904,8904,"2020-04-23 14:38:36","0",null,null,null,"2020-04-27","2021-04-26","12 months contract. Storage rental paid by Bank transfer on April 23, 2020. Storage deposit transferred from agreement C15-CT194824 to this agreement. \r\n","2020-04-27","12",0,null,0,"0","2","2020-04-23 14:38:36","2","2020-04-23 14:38:36","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0005942002","C180996","PERSONAL","Ms","sLqnKk3DvAoZ\/et\/KML+Pw==","hbkan9PC5SCnBxQh2lhA4w==","","4oRUgnEpw68ZIBUGJUTf8JSSwsuRzdUBFZiAZxoVKofGAs9c5xMAWn60J3QLzIy3","h1OhF1+iCJSgOT1s1AY5WQ==","ljXHueLktYAG7NcJ3yl6t0bMWFov5jd\/37Qf\/6eOo4g=","I0WSPriKhM9Yc34mQnDJxQ==",null,1,4824]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:38:36","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":["7710","1329","810.0","810.00","2","2020-04-23 14:38:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:38:36","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-27","2021-04-26","1329"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-23 14:38:36","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":["7710",996,"SETTLED","C15-I208038","2020-04-23 14:38:36","2020-04-27","2","2020-04-23 14:38:36","2","2020-04-23 14:38:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:38:36","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":["8038","RENT","\u9810\u7e73\u79df\u91d1",1,742,"MO","1",742,"2","2020-04-23 14:38:36","2","2020-04-23 14:38:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:38:36","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":["8038","RENT","\u9810\u7e73\u79df\u91d1",2,742,"MO","1",742,"2","2020-04-23 14:38:36","2","2020-04-23 14:38:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:38:36","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":["8038","RENT","\u9810\u7e73\u79df\u91d1",3,742,"MO","1",742,"2","2020-04-23 14:38:36","2","2020-04-23 14:38:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:38:36","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":["8038","RENT","\u9810\u7e73\u79df\u91d1",4,742,"MO","1",742,"2","2020-04-23 14:38:36","2","2020-04-23 14:38:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:38:36","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":["8038","RENT","\u9810\u7e73\u79df\u91d1",5,742,"MO","1",742,"2","2020-04-23 14:38:36","2","2020-04-23 14:38:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:38:36","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":["8038","RENT","\u9810\u7e73\u79df\u91d1",6,742,"MO","1",742,"2","2020-04-23 14:38:36","2","2020-04-23 14:38:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:38:36","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":["8038","RENT","\u9810\u7e73\u79df\u91d1",7,742,"MO","1",742,"2","2020-04-23 14:38:36","2","2020-04-23 14:38:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:38:36","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":["8038","RENT","\u9810\u7e73\u79df\u91d1",8,742,"MO","1",742,"2","2020-04-23 14:38:36","2","2020-04-23 14:38:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:38:36","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":["8038","RENT","\u9810\u7e73\u79df\u91d1",9,742,"MO","1",742,"2","2020-04-23 14:38:36","2","2020-04-23 14:38:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:38:36","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":["8038","RENT","\u9810\u7e73\u79df\u91d1",10,742,"MO","1",742,"2","2020-04-23 14:38:36","2","2020-04-23 14:38:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:38:36","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":["8038","RENT","\u9810\u7e73\u79df\u91d1",11,742,"MO","1",742,"2","2020-04-23 14:38:36","2","2020-04-23 14:38:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:38:36","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":["8038","RENT","\u9810\u7e73\u79df\u91d1",12,742,"MO","1",742,"2","2020-04-23 14:38:36","2","2020-04-23 14:38:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:38:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8904,0,"8038"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-23 14:38:36","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":[996,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207684","2020-04-23 14:38:36",8904,"2","2020-04-23 14:38:36","2","2020-04-23 14:38:36","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:38:36","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":["7684","DEPOSIT",null,"PAID","2020-04-23 14:38:36",0,"2","2020-04-23 14:38:36","2","2020-04-23 14:38:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 14:38:36","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":["7684","INVOICE","8038","PAID","2020-04-23 14:38:36",8904,"2","2020-04-23 14:38:36","2","2020-04-23 14:38:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 15:25:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 15:28:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 15:30:35","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 15:35:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 16:17:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 16:35:28","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=819&filter3=undefined","floor_plan_rent_room":[{"room_id":"25","master_room_id":"8","room_code":"A25"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1238,"customer_code":"C191238","identity_type":"BUSINESS","identity_id":"CR#869699","title":"Mr","lastname":"CHUNG","firstname":"Ka Hung Mike","companyname":"Talent Hues Management Limited","email":"mchungkh@netvigator.com","tel":"91418888","address":"Flat C, 5\/F, Block 19, Baguio Villa, 555 Victoria Road, Pofulam, H.K.","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2862.0","renew_rent_month":"12","renew_warehousing_date":"2020-04-07","renew_room_key":"0005951161","renew_remark":"12 months contract. Special offer 1 month free. Storage rental and deposit paid by cheque on April 6, 2019. Smartcard and padlock provided on April 6, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT194705, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $6360.0","renew_master_room_id":"129","order_discount":[{"master_room_discount_id":"293","master_room_id":"129","discount_type":"%","price":"3180.00","disocunted_price":"3021.00","discount":"5.00","monthly_deduct":159,"room_id":"1164","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1164","room_code":"A05-162","retail_price":"3180.0","discounted_price":3021,"location_id":"4"}],"roughly_size":"42","total_retail_price":3180,"total_discounted_price":3021,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":9063,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-07","rent_from":"2020-04-07","rent_to":"2020-07-06","delivery_service":"0","remark":"3 months contract. Storage rental and deposit paid by cheque on April 23, 2020. Storage deposit $6360 transferred from agreement A05-CT194705 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":9063,"final_order_total":9063,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0005951161","order_product":[],"pass":true}},"first_order_id":4705,"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-162 <\/td>\r\n\t\t\t\t\t 6X7X7 <\/td>\r\n\t\t\t\t\t $3180.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":"42","total_discounted_price":"3021.00","deposit":"00.00","total_retail_price":"3180.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 16:35:29","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",1238,"NEW","A05-CT207711",3180,3021,0,0,"3","3",9063,9063,9063,"2020-04-23 16:35:29","0",null,null,null,"2020-04-07","2020-07-06","3 months contract. Storage rental and deposit paid by cheque on April 23, 2020. Storage deposit $6360 transferred from agreement A05-CT194705 to this agreement. ","2020-04-07","42",0,null,0,"0","2","2020-04-23 16:35:28","2","2020-04-23 16:35:28","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"0005951161","C191238","BUSINESS","Mr","LDd+YpLwC09g0O05qBNHow==","7t8bqgcU0SGVnDs8IIr2pQ==","Talent Hues Management Limited","wPhdA\/XS00zJNwlbX9dqA6RLVIooO6aB5r2BGCPTa4yhiAljyHOceLUGC6C8fI6lm4+0hA6DczBgrwVBvwvaZ2HTUHA2Qf\/H5bnxnn7vouo=","yyRfyQXdQ2mo5Fg4V\/\/bHg==","uEqMnrg4z0d3f35bnlWw7bL1NIrYXXfHlvY7fhOdv90=",null,"IJZGX3uEfBFD5HF8Iviu\/A==",1,4705]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 16:35:29","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":["7711","293","129","1164","%","5.00",159,"2","2020-04-23 16:35:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 16:35:29","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":["7711","1164","3180.0",3021,"2","2020-04-23 16:35:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 16:35:29","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-07","2020-07-06","1164"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-23 16:35:29","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":["7711",1238,"SETTLED","A05-I208039","2020-04-23 16:35:28","2020-04-07","2","2020-04-23 16:35:28","2","2020-04-23 16:35:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 16:35:29","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":["8039","RENT","\u9810\u7e73\u79df\u91d1",1,3021,"MO","1",3021,"2","2020-04-23 16:35:28","2","2020-04-23 16:35:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 16:35:29","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":["8039","RENT","\u9810\u7e73\u79df\u91d1",2,3021,"MO","1",3021,"2","2020-04-23 16:35:28","2","2020-04-23 16:35:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 16:35:29","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":["8039","RENT","\u9810\u7e73\u79df\u91d1",3,3021,"MO","1",3021,"2","2020-04-23 16:35:28","2","2020-04-23 16:35:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 16:35:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[9063,0,"8039"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-23 16:35:29","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":[1238,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207685","2020-04-23 16:35:28",9063,"2","2020-04-23 16:35:28","2","2020-04-23 16:35:28","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 16:35:29","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":["7685","DEPOSIT",null,"PAID","2020-04-23 16:35:28",0,"2","2020-04-23 16:35:28","2","2020-04-23 16:35:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 16:35:29","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":["7685","INVOICE","8039","PAID","2020-04-23 16:35:28",9063,"2","2020-04-23 16:35:28","2","2020-04-23 16:35:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 16:42:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 17:02:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 17:13:36","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":"","_payment_type":"INVOICE","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"Z766216(6)","title":"Ms","lastname":"HO","firstname":"Man Sze","companyname":"","email":"catherineho33@yahoo.com.hk","tel":"95585099","address":"Rm 1703, Mei Fai Court, Aberdeen Centre, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"434 available_room_list_input","master_room_id":"35","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"564","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"564","room_code":"L42","retail_price":"1098.0","discounted_price":1043.4,"location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1038,"deposit":2076,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3633,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1557.00","warehousing_date":"2020-04-25","rent_from":"2020-04-25","rent_to":"2020-07-24","delivery_service":"0","remark":"3 months contract, special offer 50% off for the first three months. Storage rental and deposit paid by EPS on April 23, 2020. Smart card provided on April 23, 2020.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":1557,"order_total":5190,"final_order_total":3633,"location_id":"2","branch_id":"1","company_id":"1","room_key":"189, 27926","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n\n \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> L42 <\/td>\n\t\t\t\t\t 4X4X8 <\/td>\n\t\t\t\t\t $1098.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":"16","total_discounted_price":"1038.00","deposit":"2076.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 17:13:38","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":["C201569","PERSONAL","Ms","0yWXTQxTaP+ZZAdKFYEkYw==","Zzv1eRCimQisUlUlw\/fpjg==","","DXK\/sQ3nxSpozTdqhpNwOA==","YEaGTgUIBG33gjMYWi98W8lEfY5yiv4v+wo4cktGs+8=","k9hqrSScrS\/VpX6Aj46Hn7+AEsUUfKeLWpV9D\/HVmwWsihAPIJD97RfJmnBvrSzI","dqtu2PQoYvEz4bfRptSbdA==",null,"YEaGTgUIBG33gjMYWi98W8lEfY5yiv4v+wo4cktGs+8=","N8IRiY6ssafqwxED\/5KbMg==","2","2020-04-23 17:13:36","2","2020-04-23 17:13:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 17:13:38","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",1569,"NEW","A14-CT207712",1098,1038,2076,0,"3","3",3633,5190,3633,"2020-04-23 17:13:38","0",null,null,null,"2020-04-25","2020-07-24","3 months contract, special offer 50% off for the first three months. Storage rental and deposit paid by EPS on April 23, 2020. Smart card provided on April 23, 2020.","2020-04-25","16",0,null,1557,"1557.00","2","2020-04-23 17:13:36","2","2020-04-23 17:13:36","EPS","","","","EPS","","","",null,0,"189, 27926","C201569","PERSONAL","Ms","0yWXTQxTaP+ZZAdKFYEkYw==","Zzv1eRCimQisUlUlw\/fpjg==","","k9hqrSScrS\/VpX6Aj46Hn7+AEsUUfKeLWpV9D\/HVmwWsihAPIJD97RfJmnBvrSzI","DXK\/sQ3nxSpozTdqhpNwOA==","YEaGTgUIBG33gjMYWi98W8lEfY5yiv4v+wo4cktGs+8=","dqtu2PQoYvEz4bfRptSbdA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 17:13:38","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":["7712","434 available_room_list_input","35","564","%","4.97",54.5706,"2","2020-04-23 17:13:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 17:13:38","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":["7712","564","1098.0",1043.4,"2","2020-04-23 17:13:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 17:13:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-25","2020-07-24","564"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-23 17:13:38","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":["7712","A14-D205386","PAID",2076,0,"2020-07-24","2020-04-23 17:13:36","2020-04-23 17:13:36","2","2020-04-23 17:13:36","2","2020-04-23 17:13:36",1569]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 17:13:38","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":["7712",1569,"SETTLED","A14-I208040","2020-04-23 17:13:36","2020-04-25","2","2020-04-23 17:13:36","2","2020-04-23 17:13:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 17:13:38","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":["8040","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-04-23 17:13:36","2","2020-04-23 17:13:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 17:13:38","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":["8040","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,519,"MO","1",519,"2","2020-04-23 17:13:36","2","2020-04-23 17:13:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 17:13:38","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":["8040","RENT","\u9810\u7e73\u79df\u91d1",3,1038,"MO","1",1038,"2","2020-04-23 17:13:36","2","2020-04-23 17:13:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 17:13:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1557,0,"8040"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-23 17:13:38","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":[1569,"EPS","","","","EPS","","","","PAID","P207686","2020-04-23 17:13:36",3633,"2","2020-04-23 17:13:36","2","2020-04-23 17:13:36","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 17:13:38","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":["7686","DEPOSIT","5386","PAID","2020-04-23 17:13:36",2076,"2","2020-04-23 17:13:36","2","2020-04-23 17:13:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 17:13:38","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":["7686","INVOICE","8040","PAID","2020-04-23 17:13:36",1557,"2","2020-04-23 17:13:36","2","2020-04-23 17:13:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-23 17:26:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****