\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>
A16-015 <\/td>\n\t\t\t\t\t	4X6X7 <\/td>\n\t\t\t\t\t	$1857.00 <\/td>\n\t\t\t\t	- <\/td>	<\/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":"24","total_discounted_price":"1672.00","deposit":"3714.00","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:03:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201549","PERSONAL","Ms","55AsgeTZCpmwc+4RUYfFDQ==","ddrfzAYTmkL\/QNu3psjONQ==","","s1htKPn66zgVjvodrzrQnA==","UzpXnixvHVdyDqloYMJ5Q338lqb7FvVBzp6xk3dnz1I=","1f9zgPGbe+mIo1BpgK\/tOlv8UP0ultrs2ICuq3rJ29kE6KxFI4ytU3l9G52WqWIftDRZlXxQIj4dVRC0j1f9EP4oYgCtkC5ESs0d7wcAnuM=","0TBlTRqK76OGJ2asfNHQLA==",null,"UzpXnixvHVdyDqloYMJ5Q338lqb7FvVBzp6xk3dnz1I=","BrQaaJ\/8VtiS\/uqSpGZXmw==","2","2020-03-30 16:03:32","2","2020-03-30 16:03:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:03: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` = ?","parameters":["1","1","7",1549,"NEW","A16-CT207525",1857,1672,3714,0,"13","13",22782,25450,22782,"2020-03-30 16:03:33","0",null,null,null,"2020-04-10","2021-05-09","13 months contract. Special offer 5% discount and the 13th month free. Storage rental and deposit paid by EPS on Mar 30,2020. Smart card provided on Mar 30,2020.","2020-04-10","24",0,null,2668,"2668.00","2","2020-03-30 16:03:32","2","2020-03-30 16:03:32","EPS","","","","EPS","","","",null,0,"089,52343","C201549","PERSONAL","Ms","55AsgeTZCpmwc+4RUYfFDQ==","ddrfzAYTmkL\/QNu3psjONQ==","","1f9zgPGbe+mIo1BpgK\/tOlv8UP0ultrs2ICuq3rJ29kE6KxFI4ytU3l9G52WqWIftDRZlXxQIj4dVRC0j1f9EP4oYgCtkC5ESs0d7wcAnuM=","s1htKPn66zgVjvodrzrQnA==","UzpXnixvHVdyDqloYMJ5Q338lqb7FvVBzp6xk3dnz1I=","0TBlTRqK76OGJ2asfNHQLA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:03: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":["7525","1506","1857.0","1857.00","2","2020-03-30 16:03:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:03: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-10","2021-05-09","1506"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-30 16:03:33","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":["7525","A16-D205348","PAID",3714,0,"2021-05-09","2020-03-30 16:03:32","2020-03-30 16:03:32","2","2020-03-30 16:03:32","2","2020-03-30 16:03:32",1549]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:03: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":["7525",1549,"SETTLED","A16-I207853","2020-03-30 16:03:32","2020-04-10","2","2020-03-30 16:03:32","2","2020-03-30 16:03:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:03: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":["7853","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-03-30 16:03:32","2","2020-03-30 16:03:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:03: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":["7853","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,676,"MO","1",676,"2","2020-03-30 16:03:32","2","2020-03-30 16:03:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:03: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":["7853","RENT","\u9810\u7e73\u79df\u91d1",3,1672,"MO","1",1672,"2","2020-03-30 16:03:32","2","2020-03-30 16:03:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:03: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":["7853","RENT","\u9810\u7e73\u79df\u91d1",4,1672,"MO","1",1672,"2","2020-03-30 16:03:32","2","2020-03-30 16:03:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:03: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":["7853","RENT","\u9810\u7e73\u79df\u91d1",5,1672,"MO","1",1672,"2","2020-03-30 16:03:32","2","2020-03-30 16:03:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:03: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":["7853","RENT","\u9810\u7e73\u79df\u91d1",6,1672,"MO","1",1672,"2","2020-03-30 16:03:32","2","2020-03-30 16:03:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:03: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":["7853","RENT","\u9810\u7e73\u79df\u91d1",7,1672,"MO","1",1672,"2","2020-03-30 16:03:32","2","2020-03-30 16:03:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:03: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":["7853","RENT","\u9810\u7e73\u79df\u91d1",8,1672,"MO","1",1672,"2","2020-03-30 16:03:32","2","2020-03-30 16:03:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:03: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":["7853","RENT","\u9810\u7e73\u79df\u91d1",9,1672,"MO","1",1672,"2","2020-03-30 16:03:32","2","2020-03-30 16:03:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:03: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":["7853","RENT","\u9810\u7e73\u79df\u91d1",10,1672,"MO","1",1672,"2","2020-03-30 16:03:32","2","2020-03-30 16:03:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:03: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":["7853","RENT","\u9810\u7e73\u79df\u91d1",11,1672,"MO","1",1672,"2","2020-03-30 16:03:32","2","2020-03-30 16:03:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:03: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":["7853","RENT","\u9810\u7e73\u79df\u91d1",12,1672,"MO","1",1672,"2","2020-03-30 16:03:32","2","2020-03-30 16:03:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:03: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":["7853","RENT","\u9810\u7e73\u79df\u91d1",13,1672,"MO","1",1672,"2","2020-03-30 16:03:32","2","2020-03-30 16:03:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:03:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[19068,0,"7853"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-30 16:03: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":[1549,"EPS","","","","EPS","","","","PAID","P207500","2020-03-30 16:03:32",22782,"2","2020-03-30 16:03:32","2","2020-03-30 16:03:32","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:03: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":["7500","DEPOSIT","5348","PAID","2020-03-30 16:03:32",3714,"2","2020-03-30 16:03:32","2","2020-03-30 16:03:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:03: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":["7500","INVOICE","7853","PAID","2020-03-30 16:03:32",19068,"2","2020-03-30 16:03:32","2","2020-03-30 16:03:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:32:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:54:42","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=57&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&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":"1525","master_room_id":"205","room_code":"A16-034"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A16-034 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1857.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"E586631(A)","title":"Mr","lastname":"CHAN","firstname":"James","companyname":"","email":"","tel":"94692300","address":"20B, Ho King View, 2 Braemar Hill, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1525","room_code":"A16-034","retail_price":"1857.0","discounted_price":"1857.00","location_id":"7"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1672,"deposit":3714,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":21549,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3901.00","warehousing_date":"2020-04-01","rent_from":"2020-04-01","rent_to":"2021-04-30","delivery_service":"0","remark":"13 months contract. Special offer the first 3 months 50% off, and the 13th month free. Storage rental and deposit paid by bank transfer on March 30, 2020. Smartcard and padlock provided on March 30, 2020. ","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":3901,"order_total":25450,"final_order_total":21549,"location_id":"7","branch_id":"1","company_id":"1","room_key":"189, 02135, 092, 17385, 190, 39943","order_product":[],"pass":true}},"roughly_size":"24","total_discounted_price":"1672.00","deposit":"3714.00","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:54:44","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":["C201550","PERSONAL","Mr","Vbhc36BHBpCBvR4mU0+\/OA==","8BEgNhGpCR8jGkzUtrIcXg==","","hJmAftCQb\/nRe8sc1K2rKg==",null,"Md65Nl8tPuQIwrI7ccdrpB2PKi\/27iO76QcD8NqT1LuVfNy6AKA4uyMOjpvg6uBc","ZzEtvEXZOtfxcZugGlxq4w==",null,null,"CsAVj77ptleeSlaG38oGzQ==","2","2020-03-30 16:54:42","2","2020-03-30 16:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:54: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` = ?","parameters":["1","1","7",1550,"NEW","A16-CT207526",1857,1672,3714,0,"13","13",21549,25450,21549,"2020-03-30 16:54:44","0",null,null,null,"2020-04-01","2021-04-30","13 months contract. Special offer the first 3 months 50% off, and the 13th month free. Storage rental and deposit paid by bank transfer on March 30, 2020. Smartcard and padlock provided on March 30, 2020. ","2020-04-01","24",0,null,3901,"3901.00","2","2020-03-30 16:54:42","2","2020-03-30 16:54:42","BANKIN","","","","BANKIN","","","",null,0,"189, 02135, 092, 17385, 190, 39943","C201550","PERSONAL","Mr","Vbhc36BHBpCBvR4mU0+\/OA==","8BEgNhGpCR8jGkzUtrIcXg==","","Md65Nl8tPuQIwrI7ccdrpB2PKi\/27iO76QcD8NqT1LuVfNy6AKA4uyMOjpvg6uBc","hJmAftCQb\/nRe8sc1K2rKg==",null,"ZzEtvEXZOtfxcZugGlxq4w==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:54: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":["7526","1525","1857.0","1857.00","2","2020-03-30 16:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:54: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-04-01","2021-04-30","1525"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-30 16:54:44","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":["7526","A16-D205349","PAID",3714,0,"2021-04-30","2020-03-30 16:54:42","2020-03-30 16:54:42","2","2020-03-30 16:54:42","2","2020-03-30 16:54:42",1550]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:54: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":["7526",1550,"SETTLED","A16-I207854","2020-03-30 16:54:42","2020-04-01","2","2020-03-30 16:54:42","2","2020-03-30 16:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:54: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":["7854","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-03-30 16:54:42","2","2020-03-30 16:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:54: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":["7854","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-03-30 16:54:42","2","2020-03-30 16:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:54: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":["7854","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,1115,"MO","1",1115,"2","2020-03-30 16:54:42","2","2020-03-30 16:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:54: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":["7854","RENT","\u9810\u7e73\u79df\u91d1",4,1672,"MO","1",1672,"2","2020-03-30 16:54:42","2","2020-03-30 16:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:54: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":["7854","RENT","\u9810\u7e73\u79df\u91d1",5,1672,"MO","1",1672,"2","2020-03-30 16:54:42","2","2020-03-30 16:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:54: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":["7854","RENT","\u9810\u7e73\u79df\u91d1",6,1672,"MO","1",1672,"2","2020-03-30 16:54:42","2","2020-03-30 16:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:54: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":["7854","RENT","\u9810\u7e73\u79df\u91d1",7,1672,"MO","1",1672,"2","2020-03-30 16:54:42","2","2020-03-30 16:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:54: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":["7854","RENT","\u9810\u7e73\u79df\u91d1",8,1672,"MO","1",1672,"2","2020-03-30 16:54:42","2","2020-03-30 16:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:54: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":["7854","RENT","\u9810\u7e73\u79df\u91d1",9,1672,"MO","1",1672,"2","2020-03-30 16:54:42","2","2020-03-30 16:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:54: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":["7854","RENT","\u9810\u7e73\u79df\u91d1",10,1672,"MO","1",1672,"2","2020-03-30 16:54:42","2","2020-03-30 16:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:54: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":["7854","RENT","\u9810\u7e73\u79df\u91d1",11,1672,"MO","1",1672,"2","2020-03-30 16:54:42","2","2020-03-30 16:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:54: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":["7854","RENT","\u9810\u7e73\u79df\u91d1",12,1672,"MO","1",1672,"2","2020-03-30 16:54:42","2","2020-03-30 16:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:54: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":["7854","RENT","\u9810\u7e73\u79df\u91d1",13,1672,"MO","1",1672,"2","2020-03-30 16:54:42","2","2020-03-30 16:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:54:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[17835,0,"7854"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-30 16:54: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":[1550,"BANKIN","","","","BANKIN","","","","PAID","P207501","2020-03-30 16:54:42",21549,"2","2020-03-30 16:54:42","2","2020-03-30 16:54:42","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:54: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":["7501","DEPOSIT","5349","PAID","2020-03-30 16:54:42",3714,"2","2020-03-30 16:54:42","2","2020-03-30 16:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 16:54: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":["7501","INVOICE","7854","PAID","2020-03-30 16:54:42",17835,"2","2020-03-30 16:54:42","2","2020-03-30 16:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:22:45","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=57&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1525","master_room_id":"205","room_code":"A16-034"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":371,"customer_code":"C170371","identity_type":"PERSONAL","identity_id":"K478697(1)","title":"Ms","lastname":"Lo","firstname":"Pui Sze Percy","companyname":"","email":"percy1130@yahoo.com.hk","tel":"97005393","address":"Flat 4,Floor 4,Kong Tai Court,Aberdeen Centre,Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1286.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-26","renew_room_key":"022,43967","renew_remark":"1 month contract. Storage rental paid by bank transfer on February 28, 2020. Storage deposit transferred from agreement A14-CT207087 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207274, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"38","order_discount":[],"order_room":[{"room_id":"431","room_code":"J13","retail_price":"1528.0","discounted_price":"1528.00","location_id":"2"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1286,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1286,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-26","rent_from":"2020-03-26","rent_to":"2020-04-25","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on March 30, 2020. Storage deposit transferred from agreement A14-CT207274 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1286,"final_order_total":1286,"location_id":"2","branch_id":"1","company_id":"1","room_key":"022,43967","order_product":[],"pass":true}},"first_order_id":"4690","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> J13 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1286.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:22:45","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",371,"NEW","A14-CT207527",1528,1286,0,0,"1","1",1286,1286,1286,"2020-03-30 17:22:45","0",null,null,null,"2020-03-26","2020-04-25","1 month contract. Storage rental paid by bank transfer on March 30, 2020. Storage deposit transferred from agreement A14-CT207274 to this agreement.","2020-03-26","20",0,null,0,"0","2","2020-03-30 17:22:45","2","2020-03-30 17:22:45","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"022,43967","C170371","PERSONAL","Ms","B\/tdI8SvtJ2XkpuhaqFRHg==","4w4biS+jM\/Q3DAzxHdf3pA==","","2hmhWBGvkZIoHzGPbhzhSV6dSCxka+bMmL61\/e5rYZ6q+VIutsM4dRc02qnIl242Nc1Cz9+dp5H16cfhITISeg==","kdkzIc7hmXA6w1V4sk35iQ==","egNDm5Rzw1wK2LSqnrwi\/s0PIzZXIWm1\/8FqKLRyLEw=","872ubrLnQzXtn1bx6f+nkg==",null,1,"4690"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:22:45","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":["7527","431","1528.0","1528.00","2","2020-03-30 17:22:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:22:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-26","2020-04-25","431"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-30 17:22:45","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":["7527",371,"SETTLED","A14-I207855","2020-03-30 17:22:45","2020-03-26","2","2020-03-30 17:22:45","2","2020-03-30 17:22:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:22:45","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":["7855","RENT","\u9810\u7e73\u79df\u91d1",1,1286,"MO","1",1286,"2","2020-03-30 17:22:45","2","2020-03-30 17:22:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:22:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1286,0,"7855"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-30 17:22:45","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":[371,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207502","2020-03-30 17:22:45",1286,"2","2020-03-30 17:22:45","2","2020-03-30 17:22:45","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:22:45","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":["7502","DEPOSIT",null,"PAID","2020-03-30 17:22:45",0,"2","2020-03-30 17:22:45","2","2020-03-30 17:22:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:22:45","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":["7502","INVOICE","7855","PAID","2020-03-30 17:22:45",1286,"2","2020-03-30 17:22:45","2","2020-03-30 17:22:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:33:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:45:59","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=57&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1165","master_room_id":"123","room_code":"A05-163"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-163 <\/td>\r\n\t\t\t\t\t 5X7X7 <\/td>\r\n\t\t\t\t\t $2528.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","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"R127281(A)","title":"Ms","lastname":"PAN","firstname":"Xiang Zhen","companyname":"","email":"JANEPAN88@hotmail.com","tel":"62902980","address":"Flat A, 7\/F, South Tower 7, Residence Bel-Air, 38 Bel-Air Avenue, Pok Fu Lam, Hong Kong","pass":true,"customer_id":"1066","customer_code":"C181066","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1165","room_code":"A05-163","retail_price":"2528.0","discounted_price":"2528.00","location_id":"4"}],"roughly_size":"35","total_retail_price":2528,"total_discounted_price":2390,"deposit":5310,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":32610,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3770.00","warehousing_date":"2020-04-01","rent_from":"2020-04-01","rent_to":"2021-04-30","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental and deposit paid by EPS on March 30, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":3770,"order_total":36380,"final_order_total":32610,"location_id":"4","branch_id":"1","company_id":"1","room_key":"12435009","order_product":[],"pass":true}},"roughly_size":"35","total_discounted_price":"2390.00","deposit":"5310.00","total_retail_price":"2528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:45: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","1","4","1066","NEW","A05-CT207528",2528,2390,5310,0,"13","13",32610,36380,32610,"2020-03-30 17:45:59","0",null,null,null,"2020-04-01","2021-04-30","13 months contract. Special offer the 13th month free. Storage rental and deposit paid by EPS on March 30, 2020. ","2020-04-01","35",0,null,3770,"3770.00","2","2020-03-30 17:45:59","2","2020-03-30 17:45:59","EPS","","","","EPS","","","",null,0,"12435009","C181066","PERSONAL","Ms","hNqnWaJz6n77Y2WIvkv+DA==","Eh\/5gpi9GwbDYS\/9mpLqTw==","","sdyaIhZHKcCC4XVHExOeVDNdCqqoAkfDZ6I0YjvKmsIa+3cWYGFEZgZ8nKY8cr43taQ+f4YU0hMpKx32\/CE32MVaFuCPt54p2tzRAr35coivOC0jUiFEto5mJYHdIpVN","71qlb0Y4t6GCBpOgcwQ96g==","lxhqDU3jnCU\/UD9RHWTxPM+8ARuRXsDBZTHEDaK1Sz4=","NdoXOxPt7OD1yz9cYJIKkg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:45: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":["7528","1165","2528.0","2528.00","2","2020-03-30 17:45:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:45: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-01","2021-04-30","1165"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-30 17:45: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":["7528","A05-D205350","PAID",5310,0,"2021-04-30","2020-03-30 17:45:59","2020-03-30 17:45:59","2","2020-03-30 17:45:59","2","2020-03-30 17:45:59","1066"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:45: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":["7528","1066","SETTLED","A05-I207856","2020-03-30 17:45:59","2020-04-01","2","2020-03-30 17:45:59","2","2020-03-30 17:45:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:45: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":["7856","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-03-30 17:45:59","2","2020-03-30 17:45:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:45: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":["7856","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1010,"MO","1",1010,"2","2020-03-30 17:45:59","2","2020-03-30 17:45:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:45: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":["7856","RENT","\u9810\u7e73\u79df\u91d1",3,2390,"MO","1",2390,"2","2020-03-30 17:45:59","2","2020-03-30 17:45:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:45: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":["7856","RENT","\u9810\u7e73\u79df\u91d1",4,2390,"MO","1",2390,"2","2020-03-30 17:45:59","2","2020-03-30 17:45:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:45: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":["7856","RENT","\u9810\u7e73\u79df\u91d1",5,2390,"MO","1",2390,"2","2020-03-30 17:45:59","2","2020-03-30 17:45:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:45: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":["7856","RENT","\u9810\u7e73\u79df\u91d1",6,2390,"MO","1",2390,"2","2020-03-30 17:45:59","2","2020-03-30 17:45:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:45: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":["7856","RENT","\u9810\u7e73\u79df\u91d1",7,2390,"MO","1",2390,"2","2020-03-30 17:45:59","2","2020-03-30 17:45:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:45: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":["7856","RENT","\u9810\u7e73\u79df\u91d1",8,2390,"MO","1",2390,"2","2020-03-30 17:45:59","2","2020-03-30 17:45:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:45: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":["7856","RENT","\u9810\u7e73\u79df\u91d1",9,2390,"MO","1",2390,"2","2020-03-30 17:45:59","2","2020-03-30 17:45:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:45: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":["7856","RENT","\u9810\u7e73\u79df\u91d1",10,2390,"MO","1",2390,"2","2020-03-30 17:45:59","2","2020-03-30 17:45:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:45: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":["7856","RENT","\u9810\u7e73\u79df\u91d1",11,2390,"MO","1",2390,"2","2020-03-30 17:45:59","2","2020-03-30 17:45:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:45: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":["7856","RENT","\u9810\u7e73\u79df\u91d1",12,2390,"MO","1",2390,"2","2020-03-30 17:45:59","2","2020-03-30 17:45:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:45: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":["7856","RENT","\u9810\u7e73\u79df\u91d1",13,2390,"MO","1",2390,"2","2020-03-30 17:45:59","2","2020-03-30 17:45:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:45:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[27300,0,"7856"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-30 17:45: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":["1066","EPS","","","","EPS","","","","PAID","P207503","2020-03-30 17:45:59",32610,"2","2020-03-30 17:45:59","2","2020-03-30 17:45:59","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:45: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":["7503","DEPOSIT","5350","PAID","2020-03-30 17:45:59",5310,"2","2020-03-30 17:45:59","2","2020-03-30 17:45:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:45: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":["7503","INVOICE","7856","PAID","2020-03-30 17:45:59",27300,"2","2020-03-30 17:45:59","2","2020-03-30 17:45:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 17:57:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 18:30:01","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 18:32:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 18:39:51","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 18:54:07","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":["A05-118","OPEN","114","STORAGE","2","2020-03-30 18:54:07","1120"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 18:54:07","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":["A05-119","OPEN","114","STORAGE","2","2020-03-30 18:54:07","1121"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 18:54:07","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":["A05-125","OPEN","114","STORAGE","2","2020-03-30 18:54:07","1127"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-30 18:54:07","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":["A05-126","OPEN","114","STORAGE","2","2020-03-30 18:54:07","1128"]},"data_before":[],"data_after":[],"step":1} *****