{"created_at":"2020-07-16 09:45:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 10:03:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 10:18:31","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 11:50:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 11:51:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 11:54:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 11:59:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 12:41:02","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=0&filter2=7448&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"48","master_room_id":"9","room_code":"A48"}],"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>
A48 <\/td>\r\n\t\t\t\t\t	5X7X8 <\/td>\r\n\t\t\t\t\t	$2528.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","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"K311651(4)","title":"Ms","lastname":"CHAN","firstname":"Pui Ling","companyname":"","email":"queenie82628@yahoo.com.hk","tel":"94695826","address":"Flat H, 32\/F, Kam Fung Bldg, 171 Aberdeen Main Rd, ABD.","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"48","room_code":"A48","retail_price":"2528.0","discounted_price":"2528.00","location_id":"1"}],"roughly_size":"35","total_retail_price":2528,"total_discounted_price":2528,"deposit":5056,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":8848,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3792.00","warehousing_date":"2020-07-17","rent_from":"2020-07-17","rent_to":"2020-10-16","delivery_service":"0","remark":"3 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit paid by EPS on July 16, 2020.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":3792,"order_total":12640,"final_order_total":8848,"location_id":"1","branch_id":"1","company_id":"1","room_key":"189,28962","order_product":[],"pass":true}},"roughly_size":"35","total_discounted_price":"2528.00","deposit":"5056.00","total_retail_price":"2528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 12:41:04","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":["C201674","PERSONAL","Ms","jTnLRoC8OpQWT7VpoUvyvg==","8BEgNhGpCR8jGkzUtrIcXg==","","z9pnshRZBpPTQi\/vrNp5Xw==","7n4U3p+VVdjtlRlt\/6r6CVwWG7LqMQtVZBhQNugu5qU=","qcGN53hOtJ2zLPhY7vqQztd3TiVEOHnk9b7\/ee4R7gvQqlapnbY+SgCjPnozFZZPoDzjLkU8xU+H+yWqYBKoWw==","vPuhfLeHdE8Nfn4ddPnC6A==",null,"7n4U3p+VVdjtlRlt\/6r6CVwWG7LqMQtVZBhQNugu5qU=","g4NX0onWowyzXqE3V20pug==","2","2020-07-16 12:41:02","2","2020-07-16 12:41:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 12:41:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1",1674,"NEW","A12-CT208404",2528,2528,5056,0,"3","3",8848,12640,8848,"2020-07-16 12:41:05","0",null,null,null,"2020-07-17","2020-10-16","3 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit paid by EPS on July 16, 2020.","2020-07-17","35",0,null,3792,"3792.00","2","2020-07-16 12:41:02","2","2020-07-16 12:41:02","EPS","","","","EPS","","","",null,0,"189,28962","C201674","PERSONAL","Ms","jTnLRoC8OpQWT7VpoUvyvg==","8BEgNhGpCR8jGkzUtrIcXg==","","qcGN53hOtJ2zLPhY7vqQztd3TiVEOHnk9b7\/ee4R7gvQqlapnbY+SgCjPnozFZZPoDzjLkU8xU+H+yWqYBKoWw==","z9pnshRZBpPTQi\/vrNp5Xw==","7n4U3p+VVdjtlRlt\/6r6CVwWG7LqMQtVZBhQNugu5qU=","vPuhfLeHdE8Nfn4ddPnC6A==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 12:41:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8404","48","2528.0","2528.00","2","2020-07-16 12:41:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 12:41:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-17","2020-10-16","48"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-16 12:41:05","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":["8404","A12-D205548","PAID",5056,0,"2020-10-16","2020-07-16 12:41:02","2020-07-16 12:41:02","2","2020-07-16 12:41:02","2","2020-07-16 12:41:02",1674]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 12:41:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8404",1674,"SETTLED","A12-I208733","2020-07-16 12:41:02","2020-07-17","2","2020-07-16 12:41:02","2","2020-07-16 12:41:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 12:41:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8733","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-07-16 12:41:02","2","2020-07-16 12:41:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 12:41:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8733","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1264,"MO","1",1264,"2","2020-07-16 12:41:02","2","2020-07-16 12:41:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 12:41:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8733","RENT","\u9810\u7e73\u79df\u91d1",3,2528,"MO","1",2528,"2","2020-07-16 12:41:02","2","2020-07-16 12:41:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 12:41:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3792,0,"8733"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-16 12:41:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1674,"EPS","","","","EPS","","","","PAID","P208376","2020-07-16 12:41:02",8848,"2","2020-07-16 12:41:02","2","2020-07-16 12:41:02","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 12:41:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8376","DEPOSIT","5548","PAID","2020-07-16 12:41:02",5056,"2","2020-07-16 12:41:02","2","2020-07-16 12:41:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 12:41:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8376","INVOICE","8733","PAID","2020-07-16 12:41:02",3792,"2","2020-07-16 12:41:02","2","2020-07-16 12:41:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 14:09:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 15:22:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 15:25:38","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1309,"customer_code":"C191309","identity_type":"PERSONAL","identity_id":"D359872(2)","title":"Ms","lastname":"Chan","firstname":"Sau Wan Anny","companyname":"","email":"aswc3803@yahoo.com.hk","tel":"63923155","address":"Flat 210, 2\/F, Tung Hing House, Lei Tung Estate, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"906.0","renew_rent_month":"13","renew_warehousing_date":"2020-07-21","renew_room_key":"191,03240,190,01133","renew_remark":"13 months contract. Special offer, 5% discount and 1 months free. Storage rental and deposit paid by EPS on June 20, 2019. One smartcard paid by cash on June 20, 2019. Smartcards provided on June 20, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT195286, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2012.0","renew_master_room_id":"108","order_discount":[],"order_room":[{"room_id":"1061","room_code":"A05-059","retail_price":"1006.0","discounted_price":"1006.00","location_id":"4"}],"roughly_size":"9","total_retail_price":1006,"total_discounted_price":906,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":10872,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-21","rent_from":"2020-07-21","rent_to":"2021-07-20","delivery_service":"0","remark":"12 months contract. Storage rental paid by EPS on Jul 16, 2020. Storage deposit $2012.0 is transferred from \r\nA05-CT195286 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":10872,"final_order_total":10872,"location_id":"4","branch_id":"1","company_id":"1","room_key":"191,03240,190,01133","order_product":[],"pass":true}},"first_order_id":5286,"selected_room_tr":"	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-059 <\/td>\r\n\t\t\t\t\t 3X3X7 <\/td>\r\n\t\t\t\t\t $1006.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"9","total_discounted_price":"906.00","deposit":"0.00","total_retail_price":"1006.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 15:25:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1309,"NEW","A05-CT208405",1006,906,0,0,"12","12",10872,10872,10872,"2020-07-16 15:25:39","0",null,null,null,"2020-07-21","2021-07-20","12 months contract. Storage rental paid by EPS on Jul 16, 2020. Storage deposit $2012.0 is transferred from \r\nA05-CT195286 to this agreement.","2020-07-21","9",0,null,0,"0","2","2020-07-16 15:25:38","2","2020-07-16 15:25:38","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"191,03240,190,01133","C191309","PERSONAL","Ms","kyj90ATAEqQYW09d22kamQ==","U9yoE9KqV1v8YlRkf7Q2yg==","","wn1wk\/0pMeLxIjDX99rgMT7b0aCfMVNhH29WRQ8BEeFGsw26PGRQ7nwM5SlewBNyLn8QkxXZZFHnOn1BSWOn8QuHMDt7oqELylPytQPRlT0=","OAXPAnGs9N8FECjsj+KK6g==","aeRfDDd+N8QKB26E4Dr3XiS1yhX8oa61tCM4AL+3Ups=","CHZjao9s5rCqIqIOJABflA==",null,1,5286]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 15:25:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8405","1061","1006.0","1006.00","2","2020-07-16 15:25:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 15:25:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-21","2021-07-20","1061"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-16 15:25:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8405",1309,"SETTLED","A05-I208734","2020-07-16 15:25:38","2020-07-21","2","2020-07-16 15:25:38","2","2020-07-16 15:25:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 15:25:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8734","RENT","\u9810\u7e73\u79df\u91d1",1,906,"MO","1",906,"2","2020-07-16 15:25:38","2","2020-07-16 15:25:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 15:25:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8734","RENT","\u9810\u7e73\u79df\u91d1",2,906,"MO","1",906,"2","2020-07-16 15:25:38","2","2020-07-16 15:25:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 15:25:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8734","RENT","\u9810\u7e73\u79df\u91d1",3,906,"MO","1",906,"2","2020-07-16 15:25:38","2","2020-07-16 15:25:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 15:25:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8734","RENT","\u9810\u7e73\u79df\u91d1",4,906,"MO","1",906,"2","2020-07-16 15:25:38","2","2020-07-16 15:25:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 15:25:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8734","RENT","\u9810\u7e73\u79df\u91d1",5,906,"MO","1",906,"2","2020-07-16 15:25:38","2","2020-07-16 15:25:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 15:25:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8734","RENT","\u9810\u7e73\u79df\u91d1",6,906,"MO","1",906,"2","2020-07-16 15:25:38","2","2020-07-16 15:25:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 15:25:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8734","RENT","\u9810\u7e73\u79df\u91d1",7,906,"MO","1",906,"2","2020-07-16 15:25:38","2","2020-07-16 15:25:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 15:25:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8734","RENT","\u9810\u7e73\u79df\u91d1",8,906,"MO","1",906,"2","2020-07-16 15:25:38","2","2020-07-16 15:25:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 15:25:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8734","RENT","\u9810\u7e73\u79df\u91d1",9,906,"MO","1",906,"2","2020-07-16 15:25:38","2","2020-07-16 15:25:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 15:25:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8734","RENT","\u9810\u7e73\u79df\u91d1",10,906,"MO","1",906,"2","2020-07-16 15:25:38","2","2020-07-16 15:25:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 15:25:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8734","RENT","\u9810\u7e73\u79df\u91d1",11,906,"MO","1",906,"2","2020-07-16 15:25:38","2","2020-07-16 15:25:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 15:25:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8734","RENT","\u9810\u7e73\u79df\u91d1",12,906,"MO","1",906,"2","2020-07-16 15:25:38","2","2020-07-16 15:25:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 15:25:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10872,0,"8734"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-16 15:25:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1309,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P208377","2020-07-16 15:25:38",10872,"2","2020-07-16 15:25:38","2","2020-07-16 15:25:38","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 15:25:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8377","DEPOSIT",null,"PAID","2020-07-16 15:25:38",0,"2","2020-07-16 15:25:38","2","2020-07-16 15:25:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 15:25:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8377","INVOICE","8734","PAID","2020-07-16 15:25:38",10872,"2","2020-07-16 15:25:38","2","2020-07-16 15:25:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 15:26:06","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 16:05:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 16:38:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 16:39:38","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","floor_plan_rent_room":{"1":{"room_id":"206","master_room_id":"1","room_code":"D10"}},"selected_room_tr":"\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n\t\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\t\t\t\t \n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> D10 <\/td>\n\t\t\t\t\t 4X3X4 <\/td>\n\t\t\t\t\t $598.00 <\/td>\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\u522a\u9664<\/button>\n\t\t\t\t\t<\/td><\/tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\n\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"D409324(1)","title":"Ms","lastname":"AU-YEUNG","firstname":"Pui Yuk","companyname":"","email":"","tel":"98325338","address":"\u8dd1\u99ac\u5730\u666f\u5149\u88575\u865f\u666f\u7965\u5927\u5ec87\u6a13K\u5ea7","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"206","room_code":"D10","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":568,"deposit":1196,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2900,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-17","rent_from":"2020-07-17","rent_to":"2020-10-16","delivery_service":"0","remark":"3 months contract. Storage rental and deposit paid by bank transfer on Jul 16, 2020. Smart card provided on the same day.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2900,"final_order_total":2900,"location_id":"1","branch_id":"1","company_id":"1","room_key":"056,08304","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"568.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 16:39:40","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":["C201675","PERSONAL","Ms","z+UKVuMZVqXW8xpd5cwrVQ==","oKr5RgIk53x4Jb+MBdD\/cA==","","fd1M+fjAoTUWB2DEctjkIA==",null,"ZdtdMpSb6XBeNgOr\/lcDlxkleE154yEp4aEJ7gDiKOuDcq9Aw4iHAGXslXXHzGTm","cwTQznxf4yxg7MToKOi6eA==",null,null,"vIqCOE1Fr0pS1Rhxe+kvyg==","2","2020-07-16 16:39:38","2","2020-07-16 16:39:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 16:39:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1",1675,"NEW","A12-CT208406",598,568,1196,0,"3","3",2900,2900,2900,"2020-07-16 16:39:41","0",null,null,null,"2020-07-17","2020-10-16","3 months contract. Storage rental and deposit paid by bank transfer on Jul 16, 2020. Smart card provided on the same day.","2020-07-17","12",0,null,0,"0","2","2020-07-16 16:39:38","2","2020-07-16 16:39:38","BANKIN","","","","BANKIN","","","",null,0,"056,08304","C201675","PERSONAL","Ms","z+UKVuMZVqXW8xpd5cwrVQ==","oKr5RgIk53x4Jb+MBdD\/cA==","","ZdtdMpSb6XBeNgOr\/lcDlxkleE154yEp4aEJ7gDiKOuDcq9Aw4iHAGXslXXHzGTm","fd1M+fjAoTUWB2DEctjkIA==",null,"cwTQznxf4yxg7MToKOi6eA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 16:39:41","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":["8406","206","598.0","598.00","2","2020-07-16 16:39:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 16:39:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-17","2020-10-16","206"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-16 16:39:41","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":["8406","A12-D205549","PAID",1196,0,"2020-10-16","2020-07-16 16:39:38","2020-07-16 16:39:38","2","2020-07-16 16:39:38","2","2020-07-16 16:39:38",1675]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 16:39:41","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":["8406",1675,"SETTLED","A12-I208735","2020-07-16 16:39:38","2020-07-17","2","2020-07-16 16:39:38","2","2020-07-16 16:39:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 16:39:41","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":["8735","RENT","\u9810\u7e73\u79df\u91d1",1,568,"MO","1",568,"2","2020-07-16 16:39:38","2","2020-07-16 16:39:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 16:39:41","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":["8735","RENT","\u9810\u7e73\u79df\u91d1",2,568,"MO","1",568,"2","2020-07-16 16:39:38","2","2020-07-16 16:39:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 16:39:41","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":["8735","RENT","\u9810\u7e73\u79df\u91d1",3,568,"MO","1",568,"2","2020-07-16 16:39:38","2","2020-07-16 16:39:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 16:39:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1704,0,"8735"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-16 16:39:41","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":[1675,"BANKIN","","","","BANKIN","","","","PAID","P208378","2020-07-16 16:39:38",2900,"2","2020-07-16 16:39:38","2","2020-07-16 16:39:38","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 16:39:41","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":["8378","DEPOSIT","5549","PAID","2020-07-16 16:39:38",1196,"2","2020-07-16 16:39:38","2","2020-07-16 16:39:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 16:39:41","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":["8378","INVOICE","8735","PAID","2020-07-16 16:39:38",1704,"2","2020-07-16 16:39:38","2","2020-07-16 16:39:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 16:54:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:05:36","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1184&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\t\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\t\t\t\t \n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> I05 <\/td>\n\t\t\t\t\t 2.5X4X8 <\/td>\n\t\t\t\t\t $848.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\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\n\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"R370487(3)","title":"Ms","lastname":"FUNG","firstname":"Man Yee","companyname":"","email":"fungmanyee2011@yahoo.com.hk","tel":"61295040","address":"Flat 218, 2F, Pik Yuen House, Shek Pik Wan Estate, Aberdeen","pass":true,"customer_id":"1645","customer_code":"C201645","customer_first_order":false},"2":{"order_discount":[],"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"935.0","renew_rent_month":"6","renew_warehousing_date":"2021-01-21","renew_room_key":"032,25724","renew_remark":"6 months contract. Storage rental paid by EPS on Jul 15, 2020. Storage deposit $1856 transferred from agreement A12-CT207233 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT208402, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_room":[{"room_id":"414","room_code":"I05","retail_price":"848.0","discounted_price":"848.00","location_id":"2"}],"roughly_size":"10","total_retail_price":848,"total_discounted_price":848,"deposit":1696,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2968,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1272.00","warehousing_date":"2020-07-17","rent_from":"2020-07-17","rent_to":"2020-10-16","delivery_service":"0","remark":"3 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit paid by EPS on Jul 16, 2020. Smart card provided on the same day.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":1272,"order_total":4240,"final_order_total":2968,"location_id":"2","branch_id":"1","company_id":"1","room_key":"189, 12168","order_product":[],"pass":true}},"renew":1,"first_order_id":"4158","_payment_type":"INVOICE","roughly_size":"10","total_discounted_price":"848.00","deposit":"1696.00","total_retail_price":"848.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:05:37","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","1645","NEW","A14-CT208407",848,848,1696,0,"3","3",2968,4240,2968,"2020-07-16 17:05:37","0",null,null,null,"2020-07-17","2020-10-16","3 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit paid by EPS on Jul 16, 2020. Smart card provided on the same day.","2020-07-17","10",0,null,1272,"1272.00","2","2020-07-16 17:05:36","2","2020-07-16 17:05:36","EPS","","","","EPS","","","",null,0,"189, 12168","C201645","PERSONAL","Ms","7Wnb8ujWtKDLtFcJ1EFeBg==","cyZbjLKMtXmsqxQPpU0UpA==","","Euxdmq8m1aidbLGmv+uJnDSdnO8E5RbiblHu7yqSOo9E+eUAd8kTSVitx6hR4Hn5aXzAT6FV10SBGM5LK38OFA==","cNGNOLx1bVVNY42O+UqmGw==","Tr8mwvOlHr13HI80FCWvLgaT2saUpGsxG8RihNKjYKY=","HYRW+ZIZlfyXBV6Vvra3uw==",null,1,"4158"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:05:37","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":["8407","414","848.0","848.00","2","2020-07-16 17:05:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:05:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-17","2020-10-16","414"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-16 17:05:37","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":["8407","A14-D205550","PAID",1696,0,"2020-10-16","2020-07-16 17:05:36","2020-07-16 17:05:36","2","2020-07-16 17:05:36","2","2020-07-16 17:05:36","1645"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:05:37","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":["8407","1645","SETTLED","A14-I208736","2020-07-16 17:05:36","2020-07-17","2","2020-07-16 17:05:36","2","2020-07-16 17:05:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:05:37","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":["8736","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-07-16 17:05:36","2","2020-07-16 17:05:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:05:37","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":["8736","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,424,"MO","1",424,"2","2020-07-16 17:05:36","2","2020-07-16 17:05:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:05:37","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":["8736","RENT","\u9810\u7e73\u79df\u91d1",3,848,"MO","1",848,"2","2020-07-16 17:05:36","2","2020-07-16 17:05:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:05:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1272,0,"8736"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-16 17:05:37","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":["1645","EPS","","","","EPS","","","","PAID","P208379","2020-07-16 17:05:36",2968,"2","2020-07-16 17:05:36","2","2020-07-16 17:05:36","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:05:37","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":["8379","DEPOSIT","5550","PAID","2020-07-16 17:05:36",1696,"2","2020-07-16 17:05:36","2","2020-07-16 17:05:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:05:37","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":["8379","INVOICE","8736","PAID","2020-07-16 17:05:36",1272,"2","2020-07-16 17:05:36","2","2020-07-16 17:05:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:06:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:09:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:19:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:19:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:20:07","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","056,08304","3 months contract. Storage rental and deposit paid by bank transfer on Jul 16, 2020. Smart card provided on the same day.","2020-07-16 17:20:07","2","oKr5RgIk53x4Jb+MBdD\/cA==","z+UKVuMZVqXW8xpd5cwrVQ==","fd1M+fjAoTUWB2DEctjkIA==","ZdtdMpSb6XBeNgOr\/lcDlxkleE154yEp4aEJ7gDiKOuDcq9Aw4iHAGXslXXHzGTm",8406]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:21:01","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:21:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:22:02","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":"","floor_plan_rent_room":{"1":{"room_id":"206","master_room_id":"1","room_code":"D10"}},"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> D10 <\/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","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"D409324(1)","title":"Ms","lastname":"AU-YEUNG","firstname":"Pui Yuk","companyname":"","email":"","tel":"98325338","address":"\u8dd1\u99ac\u5730\u666f\u5149\u88575\u865f\u666f\u7965\u5927\u5ec87\u6a13K\u5ea7","pass":true,"customer_id":"1675","customer_code":"C201675","customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"206","room_code":"D10","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":1196,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1794,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-17","rent_from":"2020-07-17","rent_to":"2020-08-16","delivery_service":"0","remark":"1 month contract. Storage rental and deposit paid by bank transfer on Jul 16, 2020. Smart card provided on the same day.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1794,"final_order_total":1794,"location_id":"1","branch_id":"1","company_id":"1","room_key":"056,08304","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"598.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:22:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1","1675","NEW","A12-CT208408",598,598,1196,0,"1","1",1794,1794,1794,"2020-07-16 17:22:02","0",null,null,null,"2020-07-17","2020-08-16","1 month contract. Storage rental and deposit paid by bank transfer on Jul 16, 2020. Smart card provided on the same day.","2020-07-17","12",0,null,0,"0","2","2020-07-16 17:22:02","2","2020-07-16 17:22:02","BANKIN","","","","BANKIN","","","",null,0,"056,08304","C201675","PERSONAL","Ms","z+UKVuMZVqXW8xpd5cwrVQ==","oKr5RgIk53x4Jb+MBdD\/cA==","","ZdtdMpSb6XBeNgOr\/lcDlxkleE154yEp4aEJ7gDiKOuDcq9Aw4iHAGXslXXHzGTm","fd1M+fjAoTUWB2DEctjkIA==",null,"cwTQznxf4yxg7MToKOi6eA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:22:02","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":["8408","206","598.0","598.00","2","2020-07-16 17:22:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:22:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-17","2020-08-16","206"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-16 17:22:02","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":["8408","A12-D205551","PAID",1196,0,"2020-08-16","2020-07-16 17:22:02","2020-07-16 17:22:02","2","2020-07-16 17:22:02","2","2020-07-16 17:22:02","1675"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:22:02","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":["8408","1675","SETTLED","A12-I208737","2020-07-16 17:22:02","2020-07-17","2","2020-07-16 17:22:02","2","2020-07-16 17:22:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:22:02","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":["8737","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-07-16 17:22:02","2","2020-07-16 17:22:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:22:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8737"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-16 17:22:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["1675","BANKIN","","","","BANKIN","","","","PAID","P208380","2020-07-16 17:22:02",1794,"2","2020-07-16 17:22:02","2","2020-07-16 17:22:02","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:22:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8380","DEPOSIT","5551","PAID","2020-07-16 17:22:02",1196,"2","2020-07-16 17:22:02","2","2020-07-16 17:22:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:22:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8380","INVOICE","8737","PAID","2020-07-16 17:22:02",598,"2","2020-07-16 17:22:02","2","2020-07-16 17:22:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:28:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:38:39","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":{"1":{"room_id":"206","master_room_id":"1","room_code":"D10"}},"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1146,"customer_code":"C181146","identity_type":"PERSONAL","identity_id":"D103036(2)","title":"Ms","lastname":"Leung ","firstname":"Lai Yee","companyname":"","email":null,"tel":"93069953","address":"28\/C , Block 10 , Nam Fung Sun Cheun, Quarry Bay","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1798.0","renew_rent_month":"1","renew_warehousing_date":"2020-07-11","renew_room_key":"0012403799","renew_remark":"1 month contract. Storage rental paid by cheque on June 16,2020. Deposit transferred from agreement C15-CT207984 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT208141, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"170","order_discount":[],"order_room":[{"room_id":"1354","room_code":"C15-048","retail_price":"1108.0","discounted_price":"1108.00","location_id":"6"},{"room_id":"1353","room_code":"C15-047","retail_price":"1108.0","discounted_price":"1108.00","location_id":"6"}],"roughly_size":"32","total_retail_price":2216,"total_discounted_price":1798,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1798,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-11","rent_from":"2020-07-11","rent_to":"2020-08-10","delivery_service":"0","remark":"1 month contract. Storage rental paid by cheque on Jul 16,2020. Deposit transferred from agreement C15-CT208141 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":1798,"final_order_total":1798,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012403799","order_product":[],"pass":true}},"first_order_id":"4293","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-048 <\/td>\r\n\t\t\t\t\t 4X4X6.5 <\/td>\r\n\t\t\t\t\t $1108.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> C15-047 <\/td>\r\n\t\t\t\t\t 4X4X6.5 <\/td>\r\n\t\t\t\t\t $1108.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"1798.0","deposit":"0","total_retail_price":"2216.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:38:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1146,"NEW","C15-CT208409",2216,1798,0,0,"1","1",1798,1798,1798,"2020-07-16 17:38:39","0",null,null,null,"2020-07-11","2020-08-10","1 month contract. Storage rental paid by cheque on Jul 16,2020. Deposit transferred from agreement C15-CT208141 to this agreement.\r\n","2020-07-11","32",0,null,0,"0","2","2020-07-16 17:38:39","2","2020-07-16 17:38:39","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"0012403799","C181146","PERSONAL","Ms","gjSpyhqyAa7WiwccZ+QVeQ==","EU9enA5\/vY58OMUDrd7sSw==","","dX+zJ458tDKiugVFVeBzNhNApFHtw42VR0\/lPFKhmiYTCTEHyOZIjDuovvRjZrW6gZiRuj2LsbRWS9nBvW\/ZuQ==","iaEkitfo+RiWiRQ1VJ1bPg==",null,"S1RRDrlG6v7bZDT0Ztugpw==",null,1,"4293"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:38:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8409","1354","1108.0","1108.00","2","2020-07-16 17:38:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:38:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-11","2020-08-10","1354"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-16 17:38:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8409","1353","1108.0","1108.00","2","2020-07-16 17:38:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:38:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-11","2020-08-10","1353"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-16 17:38:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8409",1146,"SETTLED","C15-I208738","2020-07-16 17:38:39","2020-07-11","2","2020-07-16 17:38:39","2","2020-07-16 17:38:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:38:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8738","RENT","\u9810\u7e73\u79df\u91d1",1,1798,"MO","1",1798,"2","2020-07-16 17:38:39","2","2020-07-16 17:38:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:38:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1798,0,"8738"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-16 17:38:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1146,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P208381","2020-07-16 17:38:39",1798,"2","2020-07-16 17:38:39","2","2020-07-16 17:38:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:38:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8381","DEPOSIT",null,"PAID","2020-07-16 17:38:39",0,"2","2020-07-16 17:38:39","2","2020-07-16 17:38:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:38:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8381","INVOICE","8738","PAID","2020-07-16 17:38:39",1798,"2","2020-07-16 17:38:39","2","2020-07-16 17:38:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:41:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 17:46:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 18:05:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 18:19:35","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 18:35:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 18:38:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 18:47:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 18:55:37","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":"","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1137,"customer_code":"C181137","identity_type":"PERSONAL","identity_id":"D511733(0)","title":"Ms","lastname":"Cheung","firstname":"Mei Ping","companyname":"","email":null,"tel":"54034230","address":"Flat 3, 23\/F, Block Q, Mei Fai Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-07-08","renew_room_key":"0007305364","renew_remark":"1 month contract. Storage rental paid by bank transfer on June 16, 2020. Storage deposit transferred from agreement A05-CT207841 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT208149, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"110","order_discount":[],"order_room":[{"room_id":"1087","room_code":"A05-085","retail_price":"598.0","discounted_price":"598.00","location_id":"4"}],"roughly_size":"8","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-08","rent_from":"2020-07-08","rent_to":"2020-08-07","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Jul 16, 2020. Storage deposit transferred from agreement A05-CT208149 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0007305364","order_product":[],"pass":true}},"first_order_id":"4717","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-085 <\/td>\r\n\t\t\t\t\t 4X2X3.5 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \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":"8","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 18:55:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1137,"NEW","A05-CT208410",598,598,0,0,"1","1",598,598,598,"2020-07-16 18:55:38","0",null,null,null,"2020-07-08","2020-08-07","1 month contract. Storage rental paid by bank transfer on Jul 16, 2020. Storage deposit transferred from agreement A05-CT208149 to this agreement.","2020-07-08","8",0,null,0,"0","2","2020-07-16 18:55:37","2","2020-07-16 18:55:37","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0007305364","C181137","PERSONAL","Ms","ov4itGGMhitaTATk31YbvA==","vCxOlXQuvOQaoL822H2o\/Q==","","E1vSnV3\/zTD\/COo0L4lGPzFMAscGCZXb3LMO+qHc4+tCAMOAjpkWSa444NxIRpkUETecgSZwbVUPrOe8jXLqvSR8eOGI+jndWcBFCAJnBXs=","pvHbwmM2tVjF9UsDRGbtTQ==",null,"itJoZuSGBd5W3YULMxGxDQ==",null,1,"4717"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 18:55:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8410","1087","598.0","598.00","2","2020-07-16 18:55:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 18:55:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-08","2020-08-07","1087"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-16 18:55:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8410",1137,"SETTLED","A05-I208739","2020-07-16 18:55:37","2020-07-08","2","2020-07-16 18:55:37","2","2020-07-16 18:55:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 18:55:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8739","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-07-16 18:55:37","2","2020-07-16 18:55:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 18:55:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8739"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-16 18:55:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1137,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208382","2020-07-16 18:55:37",598,"2","2020-07-16 18:55:37","2","2020-07-16 18:55:37","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 18:55:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8382","DEPOSIT",null,"PAID","2020-07-16 18:55:37",0,"2","2020-07-16 18:55:37","2","2020-07-16 18:55:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-16 18:55:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8382","INVOICE","8739","PAID","2020-07-16 18:55:37",598,"2","2020-07-16 18:55:37","2","2020-07-16 18:55:37"]},"data_before":[],"data_after":[],"step":1} *****