\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>
WC-10 <\/td>\n\t\t\t\t\t	2.5X2.5X4 <\/td>\n\t\t\t\t\t	$798.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":"6.25","total_discounted_price":"798.00","deposit":"1596.00","total_retail_price":"798.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:19:09","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":["C201484","PERSONAL","Ms","ulxPE\/i+0Li58z\/G7+BHVw==","mJZgQWLNPorid69RkYFo+A==","","r4+64FeQebbKKcrtaKrXTA==","jO14k8Dbc4NiPxgEg+FrL6fCpOLLGFkB8uKr2C8cZT8=","6F88GPSmmnGXsPk2ZyJKWg==","8FVfkyy0eczEt2ty44jRQA==",null,"jO14k8Dbc4NiPxgEg+FrL6fCpOLLGFkB8uKr2C8cZT8=","hqv0HbqKLh+zdjMcT81lpg==","2","2020-01-09 11:19:08","2","2020-01-09 11:19:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:19:10","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","8",1484,"NEW","WC-CT206908",798,798,1596,0,"16","16",11970,14364,11970,"2020-01-09 11:19:10","0",null,null,null,"2020-01-09","2021-05-08","16-month contract. Special offer: 3 months free. Storage rental and deposit by by EPS on 9 Jan 2020. Smart card and padlock are given on 9 Jan 2020.","2020-01-09","6.25",0,null,2394,"2394","2","2020-01-09 11:19:08","2","2020-01-09 11:19:08","EPS","","","","EPS","","","",null,0,"","C201484","PERSONAL","Ms","ulxPE\/i+0Li58z\/G7+BHVw==","mJZgQWLNPorid69RkYFo+A==","","6F88GPSmmnGXsPk2ZyJKWg==","r4+64FeQebbKKcrtaKrXTA==","jO14k8Dbc4NiPxgEg+FrL6fCpOLLGFkB8uKr2C8cZT8=","8FVfkyy0eczEt2ty44jRQA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:19:10","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":["6908","1759","798.0","798.00","2","2020-01-09 11:19:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:19:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-09","2021-05-08","1759"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-09 11:19:10","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":["6908","WC-D205241","PAID",1596,0,"2021-05-08","2020-01-09 11:19:08","2020-01-09 11:19:08","2","2020-01-09 11:19:08","2","2020-01-09 11:19:08",1484]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:19:10","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":["6908",1484,"SETTLED","WC-I207236","2020-01-09 11:19:08","2020-01-09","2","2020-01-09 11:19:08","2","2020-01-09 11:19:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:19:10","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":["7236","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-01-09 11:19:08","2","2020-01-09 11:19:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:19:10","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":["7236","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-01-09 11:19:08","2","2020-01-09 11:19:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:19:10","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":["7236","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",4,798,"MO","1",798,"2","2020-01-09 11:19:08","2","2020-01-09 11:19:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:19:10","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":["7236","RENT","\u9810\u7e73\u79df\u91d1",5,798,"MO","1",798,"2","2020-01-09 11:19:08","2","2020-01-09 11:19:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:19:10","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":["7236","RENT","\u9810\u7e73\u79df\u91d1",6,798,"MO","1",798,"2","2020-01-09 11:19:08","2","2020-01-09 11:19:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:19:10","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":["7236","RENT","\u9810\u7e73\u79df\u91d1",7,798,"MO","1",798,"2","2020-01-09 11:19:08","2","2020-01-09 11:19:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:19:10","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":["7236","RENT","\u9810\u7e73\u79df\u91d1",8,798,"MO","1",798,"2","2020-01-09 11:19:08","2","2020-01-09 11:19:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:19:10","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":["7236","RENT","\u9810\u7e73\u79df\u91d1",9,798,"MO","1",798,"2","2020-01-09 11:19:08","2","2020-01-09 11:19:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:19:10","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":["7236","RENT","\u9810\u7e73\u79df\u91d1",10,798,"MO","1",798,"2","2020-01-09 11:19:08","2","2020-01-09 11:19:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:19:10","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":["7236","RENT","\u9810\u7e73\u79df\u91d1",11,798,"MO","1",798,"2","2020-01-09 11:19:08","2","2020-01-09 11:19:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:19:10","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":["7236","RENT","\u9810\u7e73\u79df\u91d1",12,798,"MO","1",798,"2","2020-01-09 11:19:08","2","2020-01-09 11:19:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:19:10","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":["7236","RENT","\u9810\u7e73\u79df\u91d1",13,798,"MO","1",798,"2","2020-01-09 11:19:08","2","2020-01-09 11:19:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:19:10","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":["7236","RENT","\u9810\u7e73\u79df\u91d1",14,798,"MO","1",798,"2","2020-01-09 11:19:08","2","2020-01-09 11:19:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:19:10","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":["7236","RENT","\u9810\u7e73\u79df\u91d1",15,798,"MO","1",798,"2","2020-01-09 11:19:08","2","2020-01-09 11:19:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:19:10","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":["7236","RENT","\u9810\u7e73\u79df\u91d1",16,798,"MO","1",798,"2","2020-01-09 11:19:08","2","2020-01-09 11:19:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:19:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10374,0,"7236"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-09 11:19:10","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":[1484,"EPS","","","","EPS","","","","PAID","P206886","2020-01-09 11:19:08",11970,"2","2020-01-09 11:19:08","2","2020-01-09 11:19:08","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:19:10","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":["6886","DEPOSIT","5241","PAID","2020-01-09 11:19:08",1596,"2","2020-01-09 11:19:08","2","2020-01-09 11:19:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:19:10","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":["6886","INVOICE","7236","PAID","2020-01-09 11:19:08",10374,"2","2020-01-09 11:19:08","2","2020-01-09 11:19:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:23:05","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"all=1&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":"333","master_room_id":"8","room_code":"F18"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1252,"customer_code":"C191252","identity_type":"PERSONAL","identity_id":"R477781(5)","title":"Ms","lastname":"Shah","firstname":"Seema Bagri","companyname":"","email":"sbsrjs@gmail.com","tel":"68941280","address":"House 12, 51-55 Deep Water Bay Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2390.0","renew_rent_month":"6","renew_warehousing_date":"2019-11-29","renew_room_key":"111,30976","renew_remark":"6 months contract. change from unit B03 to X27. Storage deposit deduct rental fee 17\/5-28\/5 ($3056 - $51*12 = $2444) transferred from agreement A12-CT195096 to this agreement. Remaining storage rental and deposit (ttl:$17206) paid by bank transfer on May 29, 2019. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195097, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $5310.0","renew_master_room_id":"98","order_discount":[],"order_room":[{"room_id":"1002","room_code":"X27","retail_price":"2655.0","discounted_price":"2389.80","location_id":"3"}],"roughly_size":"35","total_retail_price":2655,"total_discounted_price":2390,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":28680,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2390","warehousing_date":"2019-11-29","rent_from":"2019-11-29","rent_to":"2020-12-28","delivery_service":"0","remark":"13 months contract. special offer the 13th month free . Storage rental paid by bank transfer on 8 January 2020. transferred from agreement A18-CT195097 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":2390,"order_total":31070,"final_order_total":28680,"location_id":"3","branch_id":"1","company_id":"1","room_key":"111,30976","order_product":[],"pass":true}},"first_order_id":5097,"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> X27 <\/td>\r\n\t\t\t\t\t 5X7X7 <\/td>\r\n\t\t\t\t\t $2655.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","roughly_size":"35","total_discounted_price":"2390","deposit":"0.00","total_retail_price":"2655.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:23: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",1252,"NEW","A18-CT206909",2655,2390,0,0,"13","13",28680,31070,28680,"2020-01-09 11:23:05","0",null,null,null,"2019-11-29","2020-12-28","13 months contract. special offer the 13th month free . Storage rental paid by bank transfer on 8 January 2020. transferred from agreement A18-CT195097 to this agreement. ","2019-11-29","35",0,null,2390,"2390","2","2020-01-09 11:23:05","2","2020-01-09 11:23:05","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"111,30976","C191252","PERSONAL","Ms","oElOxOkmTD4wVBasD0\/1rQ==","XRoCUPFEI2MQTDE13ujtkQ==","","uF0miTWHUWHCX0dXUfJWb9twDVvhl\/bnEomT72vyVv0Ey0s97JAzTM9p\/wxnPsUF","hsgig0WRe1O1rHWzIEjJ8Q==","BRTCaQh3N4DuXXJeAwnSWMJJaN+3xTOFf8cyE8b2z1Q=","O+xoPrlRO2rHomJhdXjmYQ==",null,1,5097]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:23: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":["6909","1002","2655.0","2389.80","2","2020-01-09 11:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:23: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":["2019-11-29","2020-12-28","1002"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-09 11:23: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":["6909",1252,"SETTLED","A18-I207237","2020-01-09 11:23:05","2019-11-29","2","2020-01-09 11:23:05","2","2020-01-09 11:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:23: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":["7237","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,2390,"MO","1",2390,"2","2020-01-09 11:23:05","2","2020-01-09 11:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:23: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":["7237","RENT","\u9810\u7e73\u79df\u91d1",3,2390,"MO","1",2390,"2","2020-01-09 11:23:05","2","2020-01-09 11:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:23: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":["7237","RENT","\u9810\u7e73\u79df\u91d1",4,2390,"MO","1",2390,"2","2020-01-09 11:23:05","2","2020-01-09 11:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:23: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":["7237","RENT","\u9810\u7e73\u79df\u91d1",5,2390,"MO","1",2390,"2","2020-01-09 11:23:05","2","2020-01-09 11:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:23: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":["7237","RENT","\u9810\u7e73\u79df\u91d1",6,2390,"MO","1",2390,"2","2020-01-09 11:23:05","2","2020-01-09 11:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:23: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":["7237","RENT","\u9810\u7e73\u79df\u91d1",7,2390,"MO","1",2390,"2","2020-01-09 11:23:05","2","2020-01-09 11:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:23: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":["7237","RENT","\u9810\u7e73\u79df\u91d1",8,2390,"MO","1",2390,"2","2020-01-09 11:23:05","2","2020-01-09 11:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:23: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":["7237","RENT","\u9810\u7e73\u79df\u91d1",9,2390,"MO","1",2390,"2","2020-01-09 11:23:05","2","2020-01-09 11:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:23: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":["7237","RENT","\u9810\u7e73\u79df\u91d1",10,2390,"MO","1",2390,"2","2020-01-09 11:23:05","2","2020-01-09 11:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:23: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":["7237","RENT","\u9810\u7e73\u79df\u91d1",11,2390,"MO","1",2390,"2","2020-01-09 11:23:05","2","2020-01-09 11:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:23: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":["7237","RENT","\u9810\u7e73\u79df\u91d1",12,2390,"MO","1",2390,"2","2020-01-09 11:23:05","2","2020-01-09 11:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:23: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":["7237","RENT","\u9810\u7e73\u79df\u91d1",13,2390,"MO","1",2390,"2","2020-01-09 11:23:05","2","2020-01-09 11:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:23:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[28680,0,"7237"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-09 11:23: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":[1252,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206887","2020-01-09 11:23:05",28680,"2","2020-01-09 11:23:05","2","2020-01-09 11:23:05","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:23: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":["6887","DEPOSIT",null,"PAID","2020-01-09 11:23:05",0,"2","2020-01-09 11:23:05","2","2020-01-09 11:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:23: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":["6887","INVOICE","7237","PAID","2020-01-09 11:23:05",28680,"2","2020-01-09 11:23:05","2","2020-01-09 11:23:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:44:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:44:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:46:55","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"all=1&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":{"1":{"room_id":"705","master_room_id":"67","room_code":"N22"}},"_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> N22(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $1118.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":"D668940(0)","title":"Ms","lastname":"FUNG","firstname":"Wai Kam Fanny","companyname":"","email":"wshinhb@gmail.com","tel":"93282377","address":"\u9999\u6e2f\u4ed4\u4e2d\u5fc3H\u5ea73\u6a134\u5ba4","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"705","room_code":"N22(\u670d\u88dd\u5009)","retail_price":"1118.0","discounted_price":"1118.00","location_id":"2"}],"roughly_size":"12","total_retail_price":1118,"total_discounted_price":1007,"deposit":2236,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":14120,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1207","warehousing_date":"2020-01-11","rent_from":"2020-01-11","rent_to":"2021-02-10","delivery_service":"0","remark":"13 months contract. special offer the 13th month free and $200 referral bonus. Storage rental and deposit paid by EPS on 9 January 2020. Smarcard provided on Jan 09,2020.\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n","paymethod":"EPS","paymethod2":"EPS","discount_deduct":1207,"order_total":15327,"final_order_total":14120,"location_id":"2","branch_id":"1","company_id":"1","room_key":"189,63618","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"1007.00","deposit":"2236.00","total_retail_price":"1118.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:46:57","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":["C201485","PERSONAL","Ms","nVuXy5ozv5bjVtPnjmc73w==","cyZbjLKMtXmsqxQPpU0UpA==","","vsHAlBB+RLLiNlXZt4rlmQ==","sOlfid1msJHeYfPnps09DmsVgbEAZCt4IlOkpB+Qifk=","48oz7aackVYZGeJMbH3NtyjuGspM1gVGFDqE8CqxYxs=","jFm8A0ZoPUasIKnbiHq9FA==",null,"sOlfid1msJHeYfPnps09DmsVgbEAZCt4IlOkpB+Qifk=","\/\/yNSZiBkjezb0NMYuUb\/Q==","2","2020-01-09 11:46:55","2","2020-01-09 11:46:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:46:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2",1485,"NEW","A14-CT206910",1118,1007,2236,0,"13","13",14120,15327,14120,"2020-01-09 11:46:58","0",null,null,null,"2020-01-11","2021-02-10","13 months contract. special offer the 13th month free and $200 referral bonus. Storage rental and deposit paid by EPS on 9 January 2020. Smarcard provided on Jan 09,2020.\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n","2020-01-11","12",0,null,1207,"1207","2","2020-01-09 11:46:55","2","2020-01-09 11:46:55","EPS","","","","EPS","","","",null,0,"189,63618","C201485","PERSONAL","Ms","nVuXy5ozv5bjVtPnjmc73w==","cyZbjLKMtXmsqxQPpU0UpA==","","48oz7aackVYZGeJMbH3NtyjuGspM1gVGFDqE8CqxYxs=","vsHAlBB+RLLiNlXZt4rlmQ==","sOlfid1msJHeYfPnps09DmsVgbEAZCt4IlOkpB+Qifk=","jFm8A0ZoPUasIKnbiHq9FA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:46:58","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":["6910","705","1118.0","1118.00","2","2020-01-09 11:46:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:46:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-11","2021-02-10","705"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-09 11:46:58","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":["6910","A14-D205242","PAID",2236,0,"2021-02-10","2020-01-09 11:46:55","2020-01-09 11:46:55","2","2020-01-09 11:46:55","2","2020-01-09 11:46:55",1485]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:46:58","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":["6910",1485,"SETTLED","A14-I207238","2020-01-09 11:46:55","2020-01-11","2","2020-01-09 11:46:55","2","2020-01-09 11:46:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:46:58","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":["7238","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-01-09 11:46:55","2","2020-01-09 11:46:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:46:58","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":["7238","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,807,"MO","1",807,"2","2020-01-09 11:46:55","2","2020-01-09 11:46:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:46:58","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":["7238","RENT","\u9810\u7e73\u79df\u91d1",3,1007,"MO","1",1007,"2","2020-01-09 11:46:55","2","2020-01-09 11:46:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:46:58","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":["7238","RENT","\u9810\u7e73\u79df\u91d1",4,1007,"MO","1",1007,"2","2020-01-09 11:46:55","2","2020-01-09 11:46:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:46:58","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":["7238","RENT","\u9810\u7e73\u79df\u91d1",5,1007,"MO","1",1007,"2","2020-01-09 11:46:55","2","2020-01-09 11:46:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:46:58","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":["7238","RENT","\u9810\u7e73\u79df\u91d1",6,1007,"MO","1",1007,"2","2020-01-09 11:46:55","2","2020-01-09 11:46:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:46:58","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":["7238","RENT","\u9810\u7e73\u79df\u91d1",7,1007,"MO","1",1007,"2","2020-01-09 11:46:55","2","2020-01-09 11:46:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:46:58","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":["7238","RENT","\u9810\u7e73\u79df\u91d1",8,1007,"MO","1",1007,"2","2020-01-09 11:46:55","2","2020-01-09 11:46:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:46:58","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":["7238","RENT","\u9810\u7e73\u79df\u91d1",9,1007,"MO","1",1007,"2","2020-01-09 11:46:55","2","2020-01-09 11:46:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:46:58","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":["7238","RENT","\u9810\u7e73\u79df\u91d1",10,1007,"MO","1",1007,"2","2020-01-09 11:46:55","2","2020-01-09 11:46:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:46:58","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":["7238","RENT","\u9810\u7e73\u79df\u91d1",11,1007,"MO","1",1007,"2","2020-01-09 11:46:55","2","2020-01-09 11:46:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:46:58","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":["7238","RENT","\u9810\u7e73\u79df\u91d1",12,1007,"MO","1",1007,"2","2020-01-09 11:46:55","2","2020-01-09 11:46:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:46:58","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":["7238","RENT","\u9810\u7e73\u79df\u91d1",13,1007,"MO","1",1007,"2","2020-01-09 11:46:55","2","2020-01-09 11:46:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:46:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11884,0,"7238"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-09 11:46:58","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":[1485,"EPS","","","","EPS","","","","PAID","P206888","2020-01-09 11:46:55",14120,"2","2020-01-09 11:46:55","2","2020-01-09 11:46:55","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:46:58","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":["6888","DEPOSIT","5242","PAID","2020-01-09 11:46:55",2236,"2","2020-01-09 11:46:55","2","2020-01-09 11:46:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 11:46:58","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":["6888","INVOICE","7238","PAID","2020-01-09 11:46:55",11884,"2","2020-01-09 11:46:55","2","2020-01-09 11:46:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:03:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:07:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:07:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:08:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:09:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:10:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:30:08","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":"","warehousing":{"1":{"new_customer":"1","identity_type":"BUSINESS","identity_id":"70722040-000-05-19-3","title":"Mr","lastname":"Lika","firstname":".","companyname":"Galiat Electronics Limited","email":"","tel":"33762106242","address":"Flat C, Level 7 World Trust Tower, 50 Stanley Street, Central","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1508","room_code":"A16-017","retail_price":"598.0","discounted_price":"598.00","location_id":"7"}],"roughly_size":"8","total_retail_price":598,"total_discounted_price":538,"deposit":1196,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":7652,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"538","warehousing_date":"2020-01-10","rent_from":"2020-01-10","rent_to":"2021-02-09","delivery_service":"0","remark":"13 months contract. special offer the 13th month free. First month storage rental and deposit $1734 paid by cash on 9 January 2020. Balance $7652 paid by cash on 10 January 2020. Smart card provided on Jan 10,2020.\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n","paymethod":"CASH","paymethod2":"CASH","discount_deduct":538,"order_total":8190,"final_order_total":7652,"location_id":"7","branch_id":"1","company_id":"1","room_key":"189,51803","order_product":[],"pass":true}},"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-017 <\/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> <\/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","floor_plan_rent_room":[{"room_id":"1508","master_room_id":"196","room_code":"A16-017"}],"roughly_size":"8","total_discounted_price":"538.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:30:10","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":["C201486","BUSINESS","Mr","K2KrE1o44++lBMjvhOt77g==","Q+PorclQj7jE8TlwKMO7YA==","Galiat Electronics Limited","YMxM5yBElK7kyXIRndAgGQ==",null,"5mrb3JNeyV477mH0\/O\/jIZrjrJEPQ5B\/Oax+Fv1fX5M76ndaBdCu2lZX45PANDQV3YsCZ5P2jerPOmNGH414JQ==",null,"\/uxtJWJNOACYEDwuMgubWnrjg2EH+Cw\/lre3fq03Fmk=",null,"h\/J0zzyU1ggNmOr5RRO3pw==","2","2020-01-09 12:30:08","2","2020-01-09 12:30:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:30:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7",1486,"NEW","A16-CT206911",598,538,1196,0,"13","13",7652,8190,7652,"2020-01-09 12:30:11","0",null,null,null,"2020-01-10","2021-02-09","13 months contract. special offer the 13th month free. First month storage rental and deposit $1734 paid by cash on 9 January 2020. Balance $7652 paid by cash on 10 January 2020. Smart card provided on Jan 10,2020.\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n","2020-01-10","8",0,null,538,"538","2","2020-01-09 12:30:08","2","2020-01-09 12:30:08","CASH","","","","CASH","","","",null,0,"189,51803","C201486","BUSINESS","Mr","K2KrE1o44++lBMjvhOt77g==","Q+PorclQj7jE8TlwKMO7YA==","Galiat Electronics Limited","5mrb3JNeyV477mH0\/O\/jIZrjrJEPQ5B\/Oax+Fv1fX5M76ndaBdCu2lZX45PANDQV3YsCZ5P2jerPOmNGH414JQ==","YMxM5yBElK7kyXIRndAgGQ==",null,null,"\/uxtJWJNOACYEDwuMgubWnrjg2EH+Cw\/lre3fq03Fmk="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:30:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6911","1508","598.0","598.00","2","2020-01-09 12:30:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:30:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-10","2021-02-09","1508"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-09 12:30:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["6911","A16-D205243","PAID",1196,0,"2021-02-09","2020-01-09 12:30:08","2020-01-09 12:30:08","2","2020-01-09 12:30:08","2","2020-01-09 12:30:08",1486]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:30:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6911",1486,"SETTLED","A16-I207239","2020-01-09 12:30:08","2020-01-10","2","2020-01-09 12:30:08","2","2020-01-09 12:30:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:30:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7239","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,538,"MO","1",538,"2","2020-01-09 12:30:08","2","2020-01-09 12:30:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:30:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7239","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-01-09 12:30:08","2","2020-01-09 12:30:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:30:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7239","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-01-09 12:30:08","2","2020-01-09 12:30:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:30:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7239","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-01-09 12:30:08","2","2020-01-09 12:30:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:30:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7239","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-01-09 12:30:08","2","2020-01-09 12:30:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:30:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7239","RENT","\u9810\u7e73\u79df\u91d1",7,538,"MO","1",538,"2","2020-01-09 12:30:08","2","2020-01-09 12:30:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:30:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7239","RENT","\u9810\u7e73\u79df\u91d1",8,538,"MO","1",538,"2","2020-01-09 12:30:08","2","2020-01-09 12:30:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:30:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7239","RENT","\u9810\u7e73\u79df\u91d1",9,538,"MO","1",538,"2","2020-01-09 12:30:08","2","2020-01-09 12:30:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:30:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7239","RENT","\u9810\u7e73\u79df\u91d1",10,538,"MO","1",538,"2","2020-01-09 12:30:08","2","2020-01-09 12:30:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:30:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7239","RENT","\u9810\u7e73\u79df\u91d1",11,538,"MO","1",538,"2","2020-01-09 12:30:08","2","2020-01-09 12:30:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:30:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7239","RENT","\u9810\u7e73\u79df\u91d1",12,538,"MO","1",538,"2","2020-01-09 12:30:08","2","2020-01-09 12:30:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:30:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7239","RENT","\u9810\u7e73\u79df\u91d1",13,538,"MO","1",538,"2","2020-01-09 12:30:08","2","2020-01-09 12:30:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:30:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6456,0,"7239"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-09 12:30:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1486,"CASH","","","","CASH","","","","PAID","P206889","2020-01-09 12:30:08",7652,"2","2020-01-09 12:30:08","2","2020-01-09 12:30:08","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:30:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6889","DEPOSIT","5243","PAID","2020-01-09 12:30:08",1196,"2","2020-01-09 12:30:08","2","2020-01-09 12:30:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:30:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6889","INVOICE","7239","PAID","2020-01-09 12:30:08",6456,"2","2020-01-09 12:30:08","2","2020-01-09 12:30:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:33:21","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"filter1=1&filter2=709&filter3=undefined","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":709,"customer_code":"C180709","identity_type":"PERSONAL","identity_id":"D295817(2)","title":"Ms","lastname":"Ho","firstname":"Lai Wan Vicky","companyname":"","email":"vickylwlee@gmail.com","tel":"60553246","address":"19C, Block 8, Chi Fu Fa Yuen, Pok Fu Lam, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"981.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-11","renew_room_key":"055,47998","renew_remark":"6 months contract. Storage rental paid by PPS on July 18, 2019. Storage deposit transferred from agreement A18-CT194182 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195530, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"77","order_discount":[],"order_room":[{"room_id":"881","room_code":"Y10","retail_price":"1090.0","discounted_price":"1090.00","location_id":"3"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":981,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5886,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-11","rent_from":"2020-01-11","rent_to":"2020-07-10","delivery_service":"0","remark":"6 months contract. Storage rental paid by PPS on January 8, 2020. Storage deposit transferred from agreement A18-CT195530 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":5886,"final_order_total":5886,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,47998","order_product":[],"pass":true}},"first_order_id":"4182","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> Y10 <\/td>\r\n\t\t\t\t\t 3X4X7 <\/td>\r\n\t\t\t\t\t $1090.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"981.0","deposit":"0","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:33:21","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","3",709,"NEW","A18-CT206912",1090,981,0,0,"6","6",5886,5886,5886,"2020-01-09 12:33:21","0",null,null,null,"2020-01-11","2020-07-10","6 months contract. Storage rental paid by PPS on January 8, 2020. Storage deposit transferred from agreement A18-CT195530 to this agreement.\r\n","2020-01-11","12",0,null,0,"0","2","2020-01-09 12:33:21","2","2020-01-09 12:33:21","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,47998","C180709","PERSONAL","Ms","ZwrXh5rV6OLSih1dH7f\/ZA==","D\/skxQ5s\/L5yyRWaDK\/iSg==","","S7nRqtCcgtzEvo2qqzWGj61z8XkX5xrvZyeu0HVk4MHPRt3GRokXdMa4JZC8MuvlxjaBGGzj71qa3eGG89KPZQ==","f7xI11MSy3hbYo\/QtVhqwg==","rAxmwdaDt5\/FAC++SQitSlBfduHeveU\/CC6MFf69FmU=","gooAJmGI9oVJm0LX4JlY0g==",null,1,"4182"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:33:21","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":["6912","881","1090.0","1090.00","2","2020-01-09 12:33:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:33:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-11","2020-07-10","881"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-09 12:33:21","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":["6912",709,"SETTLED","A18-I207240","2020-01-09 12:33:21","2020-01-11","2","2020-01-09 12:33:21","2","2020-01-09 12:33:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:33:21","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":["7240","RENT","\u9810\u7e73\u79df\u91d1",1,981,"MO","1",981,"2","2020-01-09 12:33:21","2","2020-01-09 12:33:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:33:21","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":["7240","RENT","\u9810\u7e73\u79df\u91d1",2,981,"MO","1",981,"2","2020-01-09 12:33:21","2","2020-01-09 12:33:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:33:21","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":["7240","RENT","\u9810\u7e73\u79df\u91d1",3,981,"MO","1",981,"2","2020-01-09 12:33:21","2","2020-01-09 12:33:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:33:21","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":["7240","RENT","\u9810\u7e73\u79df\u91d1",4,981,"MO","1",981,"2","2020-01-09 12:33:21","2","2020-01-09 12:33:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:33:21","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":["7240","RENT","\u9810\u7e73\u79df\u91d1",5,981,"MO","1",981,"2","2020-01-09 12:33:21","2","2020-01-09 12:33:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:33:21","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":["7240","RENT","\u9810\u7e73\u79df\u91d1",6,981,"MO","1",981,"2","2020-01-09 12:33:21","2","2020-01-09 12:33:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:33:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5886,0,"7240"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-09 12:33:21","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":[709,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P206890","2020-01-09 12:33:21",5886,"2","2020-01-09 12:33:21","2","2020-01-09 12:33:21","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:33:21","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":["6890","DEPOSIT",null,"PAID","2020-01-09 12:33:21",0,"2","2020-01-09 12:33:21","2","2020-01-09 12:33:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:33:21","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":["6890","INVOICE","7240","PAID","2020-01-09 12:33:21",5886,"2","2020-01-09 12:33:21","2","2020-01-09 12:33:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:35:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:46:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:52:56","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"filter1=1&filter2=709&filter3=undefined","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":861,"customer_code":"C180861","identity_type":"PERSONAL","identity_id":"Z647966(A)","title":"Ms","lastname":"Lee ","firstname":"Sophia Antonia","companyname":"","email":"Sophialeehk@outlook.com","tel":"66899737","address":"Flat D, 21st Floor, 31 Robinson Road, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"934.0","renew_rent_month":"6","renew_warehousing_date":"2019-12-08","renew_room_key":"189,27905","renew_remark":"6 months contract. Storage rental paid by bank transfer on June 26, 2019. Storage deposit transferred from agreement A14-CT183820 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195327, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"756","room_code":"O32","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":934,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5604,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-08","rent_from":"2019-12-08","rent_to":"2020-06-07","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on January 8, 2020. Storage deposit transferred from agreement A14-CT195327 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5604,"final_order_total":5604,"location_id":"2","branch_id":"1","company_id":"1","room_key":"189,27905","order_product":[],"pass":true}},"first_order_id":"3820","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> O32 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"934.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:52:56","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",861,"NEW","A14-CT206913",998,934,0,0,"6","6",5604,5604,5604,"2020-01-09 12:52:56","0",null,null,null,"2019-12-08","2020-06-07","6 months contract. Storage rental paid by bank transfer on January 8, 2020. Storage deposit transferred from agreement A14-CT195327 to this agreement.\r\n","2019-12-08","12",0,null,0,"0","2","2020-01-09 12:52:56","2","2020-01-09 12:52:56","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"189,27905","C180861","PERSONAL","Ms","uJv8wdO1apOB27biwhzk+w==","TXvO5dZhVvXkdspfvdLgcA==","","FS0WuNUe1ZbozUFy0S8oNmzBeAiK6nEuoSDo9gAt8k5rZ6PJU28XbCmns6DsT9Jk","S8WzLrluA9mWX34OteXbLw==","8gH2Hgugm4zmcshoa1tXBefSemACGAS2A+q+w0Ku27I=","nsHrFfCGaaBCjdkvHzdMVw==",null,1,"3820"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:52:56","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":["6913","756","998.0","998.00","2","2020-01-09 12:52:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:52:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-08","2020-06-07","756"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-09 12:52:56","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":["6913",861,"SETTLED","A14-I207241","2020-01-09 12:52:56","2019-12-08","2","2020-01-09 12:52:56","2","2020-01-09 12:52:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:52:56","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":["7241","RENT","\u9810\u7e73\u79df\u91d1",1,934,"MO","1",934,"2","2020-01-09 12:52:56","2","2020-01-09 12:52:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:52:56","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":["7241","RENT","\u9810\u7e73\u79df\u91d1",2,934,"MO","1",934,"2","2020-01-09 12:52:56","2","2020-01-09 12:52:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:52:56","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":["7241","RENT","\u9810\u7e73\u79df\u91d1",3,934,"MO","1",934,"2","2020-01-09 12:52:56","2","2020-01-09 12:52:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:52:56","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":["7241","RENT","\u9810\u7e73\u79df\u91d1",4,934,"MO","1",934,"2","2020-01-09 12:52:56","2","2020-01-09 12:52:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:52:56","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":["7241","RENT","\u9810\u7e73\u79df\u91d1",5,934,"MO","1",934,"2","2020-01-09 12:52:56","2","2020-01-09 12:52:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:52:56","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":["7241","RENT","\u9810\u7e73\u79df\u91d1",6,934,"MO","1",934,"2","2020-01-09 12:52:56","2","2020-01-09 12:52:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:52:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5604,0,"7241"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-09 12:52:56","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":[861,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206891","2020-01-09 12:52:56",5604,"2","2020-01-09 12:52:56","2","2020-01-09 12:52:56","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:52:56","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":["6891","DEPOSIT",null,"PAID","2020-01-09 12:52:56",0,"2","2020-01-09 12:52:56","2","2020-01-09 12:52:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:52:56","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":["6891","INVOICE","7241","PAID","2020-01-09 12:52:56",5604,"2","2020-01-09 12:52:56","2","2020-01-09 12:52:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:58:19","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"filter1=1&filter2=709&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":57,"customer_code":"C160057","identity_type":"PERSONAL","identity_id":"D381525(1)","title":"Mr","lastname":"\u9127","firstname":"\u8000\u660e","companyname":"","email":null,"tel":"68489863","address":"\u9d28\u8137\u6d32\u5229\u6771\u90a8\u6771\u5e73\u645f1110\u5ba4","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-01-09","renew_room_key":"052,49830,076,49433","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 10, 2019. Storage deposit transferred from agreement A14-CT196360 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196655, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"602","room_code":"M13","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-09","rent_from":"2020-01-09","rent_to":"2020-02-08","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 8, 2020. Storage deposit transferred from agreement A14-CT196655 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"052,49830,076,49433","order_product":[],"pass":true}},"first_order_id":"4958","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> M13 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:58:20","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",57,"NEW","A14-CT206914",598,598,0,0,"1","1",598,598,598,"2020-01-09 12:58:20","0",null,null,null,"2020-01-09","2020-02-08","1 month contract. Storage rental paid by bank transfer on January 8, 2020. Storage deposit transferred from agreement A14-CT196655 to this agreement.\r\n","2020-01-09","12",0,null,0,"0","2","2020-01-09 12:58:19","2","2020-01-09 12:58:19","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,49830,076,49433","C160057","PERSONAL","Mr","GHEZv6RA43AKRnpR7gdqTA==","ftyCfj5J4cq7h24D9vkkBg==","","JP4Rs\/ygk7B5+4qY1O\/77gceoVCmBBEAI1MNVkcYqRQaD8gtNd7xtSE8vzgCel7k","OOTdNyqzZ+qPxvEtd7WOtg==",null,"o7k6DvJxqJphRuRJvr6JDg==",null,1,"4958"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:58:20","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":["6914","602","598.0","598.00","2","2020-01-09 12:58:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:58:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-09","2020-02-08","602"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-09 12:58:20","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":["6914",57,"SETTLED","A14-I207242","2020-01-09 12:58:19","2020-01-09","2","2020-01-09 12:58:19","2","2020-01-09 12:58:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:58:20","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":["7242","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-01-09 12:58:19","2","2020-01-09 12:58:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:58:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7242"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-09 12:58:20","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":[57,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206892","2020-01-09 12:58:19",598,"2","2020-01-09 12:58:19","2","2020-01-09 12:58:19","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:58:20","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":["6892","DEPOSIT",null,"PAID","2020-01-09 12:58:19",0,"2","2020-01-09 12:58:19","2","2020-01-09 12:58:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 12:58:20","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":["6892","INVOICE","7242","PAID","2020-01-09 12:58:19",598,"2","2020-01-09 12:58:19","2","2020-01-09 12:58:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 13:07:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 13:16:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 13:22:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 13:31: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":"filter1=2&filter2=1162&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":679,"customer_code":"C180679","identity_type":"BUSINESS","identity_id":"30490025","title":"Ms","lastname":"Chan","firstname":"Doris","companyname":"Hemandas Industrial Ltd.","email":"dorischan@esc.com.hk","tel":"92896007","address":"Unit 2243, 22\/F, Yan's Tower, 25-27 Wong Chuk Hang Rd, Wong Chuk Hang, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2728.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-03","renew_room_key":"055,56887","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 4, 2019. Storage deposit transferred from agreement A18-CT196374 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196607, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"82","order_discount":[],"order_room":[{"room_id":"859","room_code":"T03","retail_price":"2728.0","discounted_price":"2728.00","location_id":"3"}],"roughly_size":"36","total_retail_price":2728,"total_discounted_price":2728,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2728,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-03","rent_from":"2020-01-03","rent_to":"2020-02-02","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 9, 2020. Storage deposit transferred from agreement A18-CT196607 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2728,"final_order_total":2728,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,56887","order_product":[],"pass":true}},"first_order_id":"4697","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> T03 <\/td>\r\n\t\t\t\t\t 6X6X7 <\/td>\r\n\t\t\t\t\t $2728.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":"36","total_discounted_price":"2728.0","deposit":"0","total_retail_price":"2728.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 13:31: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","3",679,"NEW","A18-CT206915",2728,2728,0,0,"1","1",2728,2728,2728,"2020-01-09 13:31:37","0",null,null,null,"2020-01-03","2020-02-02","1 month contract. Storage rental paid by bank transfer on January 9, 2020. Storage deposit transferred from agreement A18-CT196607 to this agreement.\r\n","2020-01-03","36",0,null,0,"0","2","2020-01-09 13:31:37","2","2020-01-09 13:31:37","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,56887","C180679","BUSINESS","Ms","1p0+HSxbHlPSeHnKL1+MnA==","U9yoE9KqV1v8YlRkf7Q2yg==","Hemandas Industrial Ltd.","NNq9wxs1efEwHG+GfiDv3WoHFlyl2ik9vc5ha7eicfoFr48wfjXwEVDp3r5jjcxqeRyrZaz+NALvMBTiKSrb1OMQJpkhkNMPCpwd2zTkR61b7UwwjxTbA4OPPOLfvpDG","gMEFsGZs7+56GFUaxLbplg==","Um3+ktI0eYcw3estHH8TQKxSuSRl+2j3b4bDI46i5yg=",null,"UeK5wwtn5\/PTJNB6lM3obw==",1,"4697"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 13:31: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":["6915","859","2728.0","2728.00","2","2020-01-09 13:31:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 13:31: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-01-03","2020-02-02","859"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-09 13:31: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":["6915",679,"SETTLED","A18-I207243","2020-01-09 13:31:37","2020-01-03","2","2020-01-09 13:31:37","2","2020-01-09 13:31:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 13:31: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":["7243","RENT","\u9810\u7e73\u79df\u91d1",1,2728,"MO","1",2728,"2","2020-01-09 13:31:37","2","2020-01-09 13:31:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 13:31:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2728,0,"7243"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-09 13:31: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":[679,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206893","2020-01-09 13:31:37",2728,"2","2020-01-09 13:31:37","2","2020-01-09 13:31:37","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 13:31: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":["6893","DEPOSIT",null,"PAID","2020-01-09 13:31:37",0,"2","2020-01-09 13:31:37","2","2020-01-09 13:31:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 13:31: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":["6893","INVOICE","7243","PAID","2020-01-09 13:31:37",2728,"2","2020-01-09 13:31:37","2","2020-01-09 13:31:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 13:49:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 14:19:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 15:13:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 15:19:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 15:22:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 15:31:11","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 15:48:31","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 16:00:02","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","langcode":"tc","index_url_parameter":"filter1=1&filter2=709&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":683,"customer_code":"C180683","identity_type":"PERSONAL","identity_id":"C296561(3)","title":"Mr","lastname":"Yu","firstname":"Shek Chi Pack","companyname":"","email":"diefattuen@gmail.com","tel":"96506596","address":"5, 24\/F, On Fai House, Yue Fai Court, Aberdeen","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1764.0","renew_rent_month":"3","renew_warehousing_date":"2020-01-03","renew_room_key":"042, 54145","renew_remark":"3 months contract. Storage rental paid by cash on Oct 4, 2019. Storage deposit transferred from agreement \tA18-CT195371 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196074, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"79","order_discount":[{"master_room_discount_id":"256","master_room_id":"79","discount_type":"%","price":"1857.00","disocunted_price":"1764.20","discount":"5.00","monthly_deduct":92.85,"room_id":"830","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"830","room_code":"R04","retail_price":"1857.0","discounted_price":1764.2,"location_id":"3"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1764,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":5292,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-03","rent_from":"2020-01-03","rent_to":"2020-04-02","delivery_service":"0","remark":"3 months contract. Storage rental paid by cash on Jan 9, 2020. Storage deposit transferred from agreement \tA18-CT196074 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":5292,"final_order_total":5292,"location_id":"3","branch_id":"1","company_id":"1","room_key":"042, 54145","order_product":[],"pass":true}},"first_order_id":"4702","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> R04 <\/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> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1764.0","deposit":"0","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 16:00: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",683,"NEW","A18-CT206916",1857,1764,0,0,"3","3",5292,5292,5292,"2020-01-09 16:00:02","0",null,null,null,"2020-01-03","2020-04-02","3 months contract. Storage rental paid by cash on Jan 9, 2020. Storage deposit transferred from agreement \tA18-CT196074 to this agreement.\r\n","2020-01-03","24",0,null,0,"0","2","2020-01-09 16:00:02","2","2020-01-09 16:00:02","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"042, 54145","C180683","PERSONAL","Mr","xtZSHTD915TFuAy\/s3sBhA==","thtRZ5CDeQ9OOuodTdr1ng==","","C5oTsyuyqTxVHkMPFgHty10nBsHMbbmG4XxsHE5vDrVx+DP1RmCsFA6TKWjB7M9z","g7a+bPKtyWONirfAtn6jNw==","BKZ53JbQrrubaM8RsgM4rxgkTKfjpF9DEAaZUAfU2ws=","nH4tF+iocioYKgKiZm0GXA==",null,1,"4702"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 16:00:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["6916","256","79","830","%","5.00",92.85,"2","2020-01-09 16:00:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 16:00: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":["6916","830","1857.0",1764.2,"2","2020-01-09 16:00:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 16:00: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-01-03","2020-04-02","830"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-09 16:00: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":["6916",683,"SETTLED","A18-I207244","2020-01-09 16:00:02","2020-01-03","2","2020-01-09 16:00:02","2","2020-01-09 16:00:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 16:00: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":["7244","RENT","\u9810\u7e73\u79df\u91d1",1,1764,"MO","1",1764,"2","2020-01-09 16:00:02","2","2020-01-09 16:00:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 16:00: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":["7244","RENT","\u9810\u7e73\u79df\u91d1",2,1764,"MO","1",1764,"2","2020-01-09 16:00:02","2","2020-01-09 16:00:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 16:00: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":["7244","RENT","\u9810\u7e73\u79df\u91d1",3,1764,"MO","1",1764,"2","2020-01-09 16:00:02","2","2020-01-09 16:00:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 16:00:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5292,0,"7244"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-09 16:00: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":[683,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P206894","2020-01-09 16:00:02",5292,"2","2020-01-09 16:00:02","2","2020-01-09 16:00:02","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 16:00: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":["6894","DEPOSIT",null,"PAID","2020-01-09 16:00:02",0,"2","2020-01-09 16:00:02","2","2020-01-09 16:00:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 16:00: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":["6894","INVOICE","7244","PAID","2020-01-09 16:00:02",5292,"2","2020-01-09 16:00:02","2","2020-01-09 16:00:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 16:13:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 17:28:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-09 21:43:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****