\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>
W05 <\/td>\n\t\t\t\t\t	4X4X7 <\/td>\n\t\t\t\t\t	$1290.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"16","total_discounted_price":"1162.00","deposit":"2580.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:13:11","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":["C201493","PERSONAL","Mr","s+RsFIBqdm4fJlZRBF2Lvw==","GTJpW1vFNeM2BJtajf1+yQ==","","z+xPZxkl4H6eGcBxitxX\/Q==","NMVDiRZk9v++3WIFhgN0BE5cegkKLnrzkq+WEqtIeDg=","OeX539ewl\/4ULa2GJpj+T40suvjVApg9E1PC4mBd\/hFJv5F6cQd96scnhaGwyo8To+pr1Cd2SN6\/edRmDfe\/Xw==","Gzo74oE4VPbm9K4AE+Lmpw==",null,"NMVDiRZk9v++3WIFhgN0BE5cegkKLnrzkq+WEqtIeDg=","AZd72IzBwwxulo5oDC6kMA==","2","2020-01-21 15:13:09","2","2020-01-21 15:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:13: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` = ?","parameters":["1","1","3",1493,"NEW","A18-CT207017",1290,1162,2580,0,"13","13",15828,17686,15828,"2020-01-21 15:13:11","0",null,null,null,"2020-02-01","2021-02-28","13 months contract. Special offer the 13th month free and 5% \"Rent Now\" discount. Storage deposit $500 paid by EPS on January 7, 2020. Remaining balance $15328 paid by cheque on January 21, 2020. Smartcard and padlock provided on January 21, 2020. ","2020-02-01","16",0,null,1858,"1858.00","2","2020-01-21 15:13:09","2","2020-01-21 15:13:09","CHEQUE","","","","CHEQUE","","","",null,0,"190,18273","C201493","PERSONAL","Mr","s+RsFIBqdm4fJlZRBF2Lvw==","GTJpW1vFNeM2BJtajf1+yQ==","","OeX539ewl\/4ULa2GJpj+T40suvjVApg9E1PC4mBd\/hFJv5F6cQd96scnhaGwyo8To+pr1Cd2SN6\/edRmDfe\/Xw==","z+xPZxkl4H6eGcBxitxX\/Q==","NMVDiRZk9v++3WIFhgN0BE5cegkKLnrzkq+WEqtIeDg=","Gzo74oE4VPbm9K4AE+Lmpw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:13: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":["7017","960","1290.0","1290.00","2","2020-01-21 15:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:13: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-02-01","2021-02-28","960"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-21 15:13:11","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":["7017","A18-D205262","PAID",2580,0,"2021-02-28","2020-01-21 15:13:09","2020-01-21 15:13:09","2","2020-01-21 15:13:09","2","2020-01-21 15:13:09",1493]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:13: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":["7017",1493,"SETTLED","A18-I207345","2020-01-21 15:13:09","2020-02-01","2","2020-01-21 15:13:09","2","2020-01-21 15:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:13: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":["7345","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-01-21 15:13:09","2","2020-01-21 15:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:13: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":["7345","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,466,"MO","1",466,"2","2020-01-21 15:13:09","2","2020-01-21 15:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:13: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":["7345","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-01-21 15:13:09","2","2020-01-21 15:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:13: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":["7345","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-01-21 15:13:09","2","2020-01-21 15:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:13: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":["7345","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-01-21 15:13:09","2","2020-01-21 15:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:13: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":["7345","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-01-21 15:13:09","2","2020-01-21 15:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:13: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":["7345","RENT","\u9810\u7e73\u79df\u91d1",7,1162,"MO","1",1162,"2","2020-01-21 15:13:09","2","2020-01-21 15:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:13: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":["7345","RENT","\u9810\u7e73\u79df\u91d1",8,1162,"MO","1",1162,"2","2020-01-21 15:13:09","2","2020-01-21 15:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:13: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":["7345","RENT","\u9810\u7e73\u79df\u91d1",9,1162,"MO","1",1162,"2","2020-01-21 15:13:09","2","2020-01-21 15:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:13: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":["7345","RENT","\u9810\u7e73\u79df\u91d1",10,1162,"MO","1",1162,"2","2020-01-21 15:13:09","2","2020-01-21 15:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:13: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":["7345","RENT","\u9810\u7e73\u79df\u91d1",11,1162,"MO","1",1162,"2","2020-01-21 15:13:09","2","2020-01-21 15:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:13: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":["7345","RENT","\u9810\u7e73\u79df\u91d1",12,1162,"MO","1",1162,"2","2020-01-21 15:13:09","2","2020-01-21 15:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:13: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":["7345","RENT","\u9810\u7e73\u79df\u91d1",13,1162,"MO","1",1162,"2","2020-01-21 15:13:09","2","2020-01-21 15:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:13:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13248,0,"7345"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-21 15:13: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":[1493,"CHEQUE","","","","CHEQUE","","","","PAID","P206994","2020-01-21 15:13:09",15828,"2","2020-01-21 15:13:09","2","2020-01-21 15:13:09","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:13: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":["6994","DEPOSIT","5262","PAID","2020-01-21 15:13:09",2580,"2","2020-01-21 15:13:09","2","2020-01-21 15:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:13: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":["6994","INVOICE","7345","PAID","2020-01-21 15:13:09",13248,"2","2020-01-21 15:13:09","2","2020-01-21 15:13:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:25:31","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":"all=1&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":834,"customer_code":"C180834","identity_type":"PERSONAL","identity_id":"K291879(A)","title":"Ms","lastname":"Chan","firstname":"Li Ying","companyname":"","email":"hihizoe@yahoo.com","tel":"94271513","address":"Flat B, 9\/F, Mainly House, 105-113 Main Street, Apleichau, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"568.0","renew_rent_month":"3","renew_warehousing_date":"2020-01-28","renew_room_key":"134,30221","renew_remark":"3 months contract. Storage rental paid by bank transfer on October 24, 2019. Storage deposit transferred from agreement A12-CT195603 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196218, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"1","order_discount":[],"order_room":[{"room_id":"203","room_code":"D07","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":568,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":1704,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-28","rent_from":"2020-01-28","rent_to":"2020-04-27","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on January 21, 2020. Storage deposit transferred from agreement A12-CT196218 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1704,"final_order_total":1704,"location_id":"1","branch_id":"1","company_id":"1","room_key":"134,30221","order_product":[],"pass":true}},"first_order_id":"4849","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> D07 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"568.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:25:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",834,"NEW","A12-CT207018",598,568,0,0,"3","3",1704,1704,1704,"2020-01-21 15:25:31","0",null,null,null,"2020-01-28","2020-04-27","3 months contract. Storage rental paid by bank transfer on January 21, 2020. Storage deposit transferred from agreement A12-CT196218 to this agreement.\r\n","2020-01-28","12",0,null,0,"0","2","2020-01-21 15:25:31","2","2020-01-21 15:25:31","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"134,30221","C180834","PERSONAL","Ms","G2xqKoaAB4yeR+cf9ZGMdg==","U9yoE9KqV1v8YlRkf7Q2yg==","","nLjhSMtekhxQpcfX8SNans875\/V7aIHDhPlCmQHH9uNbzt8DFEAO7N2hfazru6UUlTBTViJjKiBDh+oaLnxYwQ==","arpZc1qFqpaOpcxV\/MnJQQ==","rCRtqQSRWqiXITT\/u46s526Wgky9rIcrW67drVdGPXw=","E8DFyj493b9lDECElzTPsQ==",null,1,"4849"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:25:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7018","203","598.0","598.00","2","2020-01-21 15:25:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:25:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-28","2020-04-27","203"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-21 15:25:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7018",834,"SETTLED","A12-I207346","2020-01-21 15:25:31","2020-01-28","2","2020-01-21 15:25:31","2","2020-01-21 15:25:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:25:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7346","RENT","\u9810\u7e73\u79df\u91d1",1,568,"MO","1",568,"2","2020-01-21 15:25:31","2","2020-01-21 15:25:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:25:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7346","RENT","\u9810\u7e73\u79df\u91d1",2,568,"MO","1",568,"2","2020-01-21 15:25:31","2","2020-01-21 15:25:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:25:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7346","RENT","\u9810\u7e73\u79df\u91d1",3,568,"MO","1",568,"2","2020-01-21 15:25:31","2","2020-01-21 15:25:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:25:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1704,0,"7346"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-21 15:25:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[834,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206995","2020-01-21 15:25:31",1704,"2","2020-01-21 15:25:31","2","2020-01-21 15:25:31","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:25:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6995","DEPOSIT",null,"PAID","2020-01-21 15:25:31",0,"2","2020-01-21 15:25:31","2","2020-01-21 15:25:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 15:25:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6995","INVOICE","7346","PAID","2020-01-21 15:25:31",1704,"2","2020-01-21 15:25:31","2","2020-01-21 15:25:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 16:29:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 17:04:11","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=1171&filter3=undefined&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"warehousing":{"1":{"new_customer":0,"identity_type":"BUSINESS","identity_id":"63137444-000-04-19-9","title":"Mr","lastname":"LEUNG","firstname":"Siu Hung","companyname":"E-Board Construction Limited","email":"hung91940040@yahoo.com.hk","tel":"91940040","address":"Room 606, Tsui Ning House, Tsui Wan Estate, Chai Wan, Hong Kong.","pass":true,"customer_id":1231,"customer_code":"C191231","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"411","master_room_id":"159","discount_type":"%","price":"720.00","disocunted_price":"684.00","discount":"5.00","monthly_deduct":36,"room_id":"1400","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"684.0","renew_rent_month":"3","renew_warehousing_date":"2019-12-26","renew_room_key":"'0012465782","renew_remark":"3 months contract. Storage rental paid by bank transfer on Nov 19, 2019. Deposit $720 transferred from agreement C15-CT194648 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT196474, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"159","order_room":[{"room_id":"1400","room_code":"C15-094","retail_price":"720.0","discounted_price":684,"location_id":"6"}],"roughly_size":"9","total_retail_price":720,"total_discounted_price":684,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2052,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-26","rent_from":"2019-12-26","rent_to":"2020-03-25","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on Jan 21,2020. Deposit $720 transferred from agreement C15-CT196474 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2052,"final_order_total":2052,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012465782","order_product":[],"pass":true}},"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-094 <\/td>\r\n\t\t\t\t\t 3X3X6.5 <\/td>\r\n\t\t\t\t\t $720.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\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","renew":1,"first_order_id":"4648","roughly_size":"9","total_discounted_price":"684.0","deposit":"0","total_retail_price":"720.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 17:04:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1231,"NEW","C15-CT207019",720,684,0,0,"3","3",2052,2052,2052,"2020-01-21 17:04:12","0",null,null,null,"2019-12-26","2020-03-25","3 months contract. Storage rental paid by bank transfer on Jan 21,2020. Deposit $720 transferred from agreement C15-CT196474 to this agreement.","2019-12-26","9",0,null,0,"0","2","2020-01-21 17:04:11","2","2020-01-21 17:04:11","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0012465782","C191231","BUSINESS","Mr","cKQuXkw+QX5W9kWyedDIMQ==","yXKc2lCF323ApRADrjNaSg==","E-Board Construction Limited","mUajGax6tlCJpSmxJm6NqFr6L52xbXs2tmmlNxzVvGLfYqKtndbhVPfWdP78Qr\/Kep+QxPBCaHSKiWPK7elr1iQMxnXx+e6KPIeRRwScI8Y=","AuUPgOiCb57sL53kxfWXZw==","neD4RJ9Xps0JfAJm4eyVSwJjZSuQzyU927SqmEYs2xE=",null,"r4Yf8AUupRy8x6rdET56NMVu61ggTOBt7kcj9DUHePc=",1,"4648"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 17:04:12","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":["7019","411","159","1400","%","5.00",36,"2","2020-01-21 17:04:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 17:04:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7019","1400","720.0",684,"2","2020-01-21 17:04:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 17:04:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-26","2020-03-25","1400"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-21 17:04:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7019",1231,"SETTLED","C15-I207347","2020-01-21 17:04:11","2019-12-26","2","2020-01-21 17:04:11","2","2020-01-21 17:04:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 17:04:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7347","RENT","\u9810\u7e73\u79df\u91d1",1,684,"MO","1",684,"2","2020-01-21 17:04:11","2","2020-01-21 17:04:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 17:04:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7347","RENT","\u9810\u7e73\u79df\u91d1",2,684,"MO","1",684,"2","2020-01-21 17:04:11","2","2020-01-21 17:04:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 17:04:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7347","RENT","\u9810\u7e73\u79df\u91d1",3,684,"MO","1",684,"2","2020-01-21 17:04:11","2","2020-01-21 17:04:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 17:04:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2052,0,"7347"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-21 17:04:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1231,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206996","2020-01-21 17:04:11",2052,"2","2020-01-21 17:04:11","2","2020-01-21 17:04:11","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 17:04:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6996","DEPOSIT",null,"PAID","2020-01-21 17:04:11",0,"2","2020-01-21 17:04:11","2","2020-01-21 17:04:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 17:04:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6996","INVOICE","7347","PAID","2020-01-21 17:04:11",2052,"2","2020-01-21 17:04:11","2","2020-01-21 17:04:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 18:30:31","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","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1187,"customer_code":"C191187","identity_type":"PERSONAL","identity_id":"G099391(2)","title":"Mr","lastname":"Lee","firstname":"Wan Tong","companyname":"","email":"williamwt@yahoo.com.hk","tel":"97108899","address":"\u67f4\u6e7e\u5c0f\u897f\u6e7e\u4f73\u7fe0\u82d1\u8000\u7fe0\u95a3707\u5ba4","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"710.0","renew_rent_month":"12","renew_warehousing_date":"2020-02-01","renew_room_key":"0012522849","renew_remark":" 12 months contract. Special promotion offered, 2 months free of charge. Storage rental and deposit paid by EPS on 26 JAN 2019. Smartcard provided on 26 JAN 2019.\u5373\u79df\u512a\u60755%(\u6e1b$350)\\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT194247, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1816.0","renew_master_room_id":"136","order_discount":[],"order_room":[{"room_id":"1291","room_code":"B01-101","retail_price":"908.0","discounted_price":"908.00","location_id":"5"}],"roughly_size":"12","total_retail_price":908,"total_discounted_price":709,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":8508,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-01","rent_from":"2020-02-01","rent_to":"2021-01-31","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on Jan 21,2020. Deposit $1816 transferred from B01-CT194247 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":8508,"final_order_total":8508,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0012522849","order_product":[],"pass":true}},"first_order_id":4247,"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> B01-101 <\/td>\r\n\t\t\t\t\t 3X4X7 <\/td>\r\n\t\t\t\t\t $908.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":"709.00","deposit":"0","total_retail_price":"908.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 18:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","2","5",1187,"NEW","B01-CT207020",908,709,0,0,"12","12",8508,8508,8508,"2020-01-21 18:30:31","0",null,null,null,"2020-02-01","2021-01-31","12 months contract. Storage rental paid by bank transfer on Jan 21,2020. Deposit $1816 transferred from B01-CT194247 to this agreement.","2020-02-01","12",0,null,0,"0","2","2020-01-21 18:30:31","2","2020-01-21 18:30:31","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012522849","C191187","PERSONAL","Mr","sIsSSkOLLpB+yrCcSqJ4rg==","kiriEIqhcx866RNZiMXdKQ==","","N0QxOrpWXUnCSyjUHnBCNj\/rhOGEPEQUItrH4180lm1r2cRGPnMAI61smsicdJyW","iOgTKQIJ55PAtZ0T+ZWwpQ==","vljhOZMT9ccMmi+eVV9EU1YTLTWiat2VWFUjvXGcF0g=","Z81K8w0oERPTR\/twtwmJyA==",null,1,4247]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 18:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7020","1291","908.0","908.00","2","2020-01-21 18:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 18:30:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2021-01-31","1291"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-21 18:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7020",1187,"SETTLED","B01-I207348","2020-01-21 18:30:31","2020-02-01","2","2020-01-21 18:30:31","2","2020-01-21 18:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 18:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7348","RENT","\u9810\u7e73\u79df\u91d1",1,709,"MO","1",709,"2","2020-01-21 18:30:31","2","2020-01-21 18:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 18:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7348","RENT","\u9810\u7e73\u79df\u91d1",2,709,"MO","1",709,"2","2020-01-21 18:30:31","2","2020-01-21 18:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 18:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7348","RENT","\u9810\u7e73\u79df\u91d1",3,709,"MO","1",709,"2","2020-01-21 18:30:31","2","2020-01-21 18:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 18:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7348","RENT","\u9810\u7e73\u79df\u91d1",4,709,"MO","1",709,"2","2020-01-21 18:30:31","2","2020-01-21 18:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 18:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7348","RENT","\u9810\u7e73\u79df\u91d1",5,709,"MO","1",709,"2","2020-01-21 18:30:31","2","2020-01-21 18:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 18:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7348","RENT","\u9810\u7e73\u79df\u91d1",6,709,"MO","1",709,"2","2020-01-21 18:30:31","2","2020-01-21 18:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 18:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7348","RENT","\u9810\u7e73\u79df\u91d1",7,709,"MO","1",709,"2","2020-01-21 18:30:31","2","2020-01-21 18:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 18:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7348","RENT","\u9810\u7e73\u79df\u91d1",8,709,"MO","1",709,"2","2020-01-21 18:30:31","2","2020-01-21 18:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 18:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7348","RENT","\u9810\u7e73\u79df\u91d1",9,709,"MO","1",709,"2","2020-01-21 18:30:31","2","2020-01-21 18:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 18:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7348","RENT","\u9810\u7e73\u79df\u91d1",10,709,"MO","1",709,"2","2020-01-21 18:30:31","2","2020-01-21 18:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 18:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7348","RENT","\u9810\u7e73\u79df\u91d1",11,709,"MO","1",709,"2","2020-01-21 18:30:31","2","2020-01-21 18:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 18:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7348","RENT","\u9810\u7e73\u79df\u91d1",12,709,"MO","1",709,"2","2020-01-21 18:30:31","2","2020-01-21 18:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 18:30:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8508,0,"7348"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-21 18:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1187,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206997","2020-01-21 18:30:31",8508,"2","2020-01-21 18:30:31","2","2020-01-21 18:30:31","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 18:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6997","DEPOSIT",null,"PAID","2020-01-21 18:30:31",0,"2","2020-01-21 18:30:31","2","2020-01-21 18:30:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-21 18:30:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6997","INVOICE","7348","PAID","2020-01-21 18:30:31",8508,"2","2020-01-21 18:30:31","2","2020-01-21 18:30:31"]},"data_before":[],"data_after":[],"step":1} *****