{"created_at":"2020-02-25 10:20:13","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=1481&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1455,"customer_code":"C191455","identity_type":"PERSONAL","identity_id":"D218085(6)","title":"Mr","lastname":"SHEK","firstname":"Chi Sum","companyname":"","email":null,"tel":"90321620","address":"Flat C, 14\/F, Siu Kwan Mansion, 118A-120 Aberdeen Old Main Road, Aberdeen, H.K.","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"635.0","renew_rent_month":"3","renew_warehousing_date":"2020-02-27","renew_room_key":"189,12077","renew_remark":"3 months contract. $500 discount from leaflet. Storage rental and deposit paid by EPS on November 25, 2019. Smartcard and padlock provided on November 25, 2019. \\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT196496, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1336.0","renew_master_room_id":"200","order_discount":[],"order_room":[{"room_id":"1611","room_code":"A16-120","retail_price":"668.0","discounted_price":"668.00","location_id":"7"}],"roughly_size":"12","total_retail_price":668,"total_discounted_price":635,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":1905,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-27","rent_from":"2020-02-27","rent_to":"2020-05-26","delivery_service":"0","remark":"3 months contract. Storage rental paid by EPS on February 25, 2020. Storage deposit $1336 transferred form agreement A16-CT196496 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":1905,"final_order_total":1905,"location_id":"7","branch_id":"1","company_id":"1","room_key":"189,12077","order_product":[],"pass":true}},"first_order_id":6496,"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>
A16-120 <\/td>\r\n\t\t\t\t\t	4X3X3.5 <\/td>\r\n\t\t\t\t\t	$668.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"635.0","deposit":"0","total_retail_price":"668.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 10:20:14","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","7",1455,"NEW","A16-CT207254",668,635,0,0,"3","3",1905,1905,1905,"2020-02-25 10:20:14","0",null,null,null,"2020-02-27","2020-05-26","3 months contract. Storage rental paid by EPS on February 25, 2020. Storage deposit $1336 transferred form agreement A16-CT196496 to this agreement. ","2020-02-27","12",0,null,0,"0","2","2020-02-25 10:20:13","2","2020-02-25 10:20:13","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"189,12077","C191455","PERSONAL","Mr","TcsrHZ1EUxrfhlQ8bqXAmA==","wSY\/nxPlGfFNjZmR6Rg1Rw==","","JeQdGMpjDMvci\/vZr8\/8BlwdLXKeehoEFLm5K7ht5GvklBl0wk1ASzI5eq9x4ljZ\/dFzwL1kalndqCiHG1nbQ1AggV\/lyNX4DyOwzsyN4L0=","ZialXAyfIpNzCpZ2hbMosA==",null,"q8qG7bSllGVjpT0PF8a2Zg==",null,1,6496]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 10:20:14","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":["7254","1611","668.0","668.00","2","2020-02-25 10:20:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 10:20:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-27","2020-05-26","1611"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-25 10:20:14","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":["7254",1455,"SETTLED","A16-I207582","2020-02-25 10:20:13","2020-02-27","2","2020-02-25 10:20:13","2","2020-02-25 10:20:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 10:20:14","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":["7582","RENT","\u9810\u7e73\u79df\u91d1",1,635,"MO","1",635,"2","2020-02-25 10:20:13","2","2020-02-25 10:20:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 10:20:14","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":["7582","RENT","\u9810\u7e73\u79df\u91d1",2,635,"MO","1",635,"2","2020-02-25 10:20:13","2","2020-02-25 10:20:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 10:20:14","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":["7582","RENT","\u9810\u7e73\u79df\u91d1",3,635,"MO","1",635,"2","2020-02-25 10:20:13","2","2020-02-25 10:20:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 10:20:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1905,0,"7582"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-25 10:20:14","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":[1455,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207230","2020-02-25 10:20:13",1905,"2","2020-02-25 10:20:13","2","2020-02-25 10:20:13","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 10:20:14","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":["7230","DEPOSIT",null,"PAID","2020-02-25 10:20:13",0,"2","2020-02-25 10:20:13","2","2020-02-25 10:20:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 10:20:14","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":["7230","INVOICE","7582","PAID","2020-02-25 10:20:13",1905,"2","2020-02-25 10:20:13","2","2020-02-25 10:20:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 10:20:35","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 10:22:12","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=1481&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1455,"customer_code":"C191455","identity_type":"PERSONAL","identity_id":"D218085(6)","title":"Mr","lastname":"SHEK","firstname":"Chi Sum","companyname":"","email":null,"tel":"90321620","address":"Flat C, 14\/F, Siu Kwan Mansion, 118A-120 Aberdeen Old Main Road, Aberdeen, H.K.","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"635.0","renew_rent_month":"3","renew_warehousing_date":"2020-03-02","renew_room_key":"189,12077","renew_remark":"3 months contract. Storage rental and deposit paid by EPS on Dec 02,2019. Padlock provided on Dec 02,2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT196569, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1336.0","renew_master_room_id":"200","order_discount":[],"order_room":[{"room_id":"1612","room_code":"A16-121","retail_price":"668.0","discounted_price":"668.00","location_id":"7"}],"roughly_size":"12","total_retail_price":668,"total_discounted_price":635,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":1905,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-02","rent_from":"2020-03-02","rent_to":"2020-06-01","delivery_service":"0","remark":"3 months contract. Storage rental paid by EPS on February 25, 2020. Storage deposit $1336 transferred from agreement A16-CT196569 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":1905,"final_order_total":1905,"location_id":"7","branch_id":"1","company_id":"1","room_key":"189,12077","order_product":[],"pass":true}},"first_order_id":6569,"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> A16-121 <\/td>\r\n\t\t\t\t\t 4X3X3.5 <\/td>\r\n\t\t\t\t\t $668.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"635.0","deposit":"0","total_retail_price":"668.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 10:22:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","7",1455,"NEW","A16-CT207255",668,635,0,0,"3","3",1905,1905,1905,"2020-02-25 10:22:12","0",null,null,null,"2020-03-02","2020-06-01","3 months contract. Storage rental paid by EPS on February 25, 2020. Storage deposit $1336 transferred from agreement A16-CT196569 to this agreement. ","2020-03-02","12",0,null,0,"0","2","2020-02-25 10:22:12","2","2020-02-25 10:22:12","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"189,12077","C191455","PERSONAL","Mr","TcsrHZ1EUxrfhlQ8bqXAmA==","wSY\/nxPlGfFNjZmR6Rg1Rw==","","JeQdGMpjDMvci\/vZr8\/8BlwdLXKeehoEFLm5K7ht5GvklBl0wk1ASzI5eq9x4ljZ\/dFzwL1kalndqCiHG1nbQ1AggV\/lyNX4DyOwzsyN4L0=","ZialXAyfIpNzCpZ2hbMosA==",null,"q8qG7bSllGVjpT0PF8a2Zg==",null,1,6569]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 10:22:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7255","1612","668.0","668.00","2","2020-02-25 10:22:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 10:22:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-02","2020-06-01","1612"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-25 10:22:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7255",1455,"SETTLED","A16-I207583","2020-02-25 10:22:12","2020-03-02","2","2020-02-25 10:22:12","2","2020-02-25 10:22:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 10:22:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7583","RENT","\u9810\u7e73\u79df\u91d1",1,635,"MO","1",635,"2","2020-02-25 10:22:12","2","2020-02-25 10:22:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 10:22:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7583","RENT","\u9810\u7e73\u79df\u91d1",2,635,"MO","1",635,"2","2020-02-25 10:22:12","2","2020-02-25 10:22:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 10:22:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7583","RENT","\u9810\u7e73\u79df\u91d1",3,635,"MO","1",635,"2","2020-02-25 10:22:12","2","2020-02-25 10:22:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 10:22:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1905,0,"7583"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-25 10:22:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1455,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207231","2020-02-25 10:22:12",1905,"2","2020-02-25 10:22:12","2","2020-02-25 10:22:12","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 10:22:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7231","DEPOSIT",null,"PAID","2020-02-25 10:22:12",0,"2","2020-02-25 10:22:12","2","2020-02-25 10:22:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 10:22:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7231","INVOICE","7583","PAID","2020-02-25 10:22:12",1905,"2","2020-02-25 10:22:12","2","2020-02-25 10:22:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 10:28:25","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","189,12077 \/ 092, 17416","3 months contract. Storage rental paid by EPS on February 25, 2020. Storage deposit $1336 transferred form agreement A16-CT196496 to this agreement. ","2020-02-25 10:28:25","2","wSY\/nxPlGfFNjZmR6Rg1Rw==","TcsrHZ1EUxrfhlQ8bqXAmA==","ZialXAyfIpNzCpZ2hbMosA==","JeQdGMpjDMvci\/vZr8\/8BlwdLXKeehoEFLm5K7ht5GvklBl0wk1ASzI5eq9x4ljZ\/dFzwL1kalndqCiHG1nbQ1AggV\/lyNX4DyOwzsyN4L0=",7254]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 10:28:52","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","189,12077 \/ 092, 17416","3 months contract. Storage rental paid by EPS on February 25, 2020. Storage deposit $1336 transferred from agreement A16-CT196569 to this agreement. ","2020-02-25 10:28:52","2","wSY\/nxPlGfFNjZmR6Rg1Rw==","TcsrHZ1EUxrfhlQ8bqXAmA==","ZialXAyfIpNzCpZ2hbMosA==","JeQdGMpjDMvci\/vZr8\/8BlwdLXKeehoEFLm5K7ht5GvklBl0wk1ASzI5eq9x4ljZ\/dFzwL1kalndqCiHG1nbQ1AggV\/lyNX4DyOwzsyN4L0=",7255]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 10:42:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 10:57:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 11:43:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 11:58:33","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=512&filter3=undefined","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1067,"customer_code":"C181067","identity_type":"PERSONAL","identity_id":"Z805762(2)","title":"Mr","lastname":"Yip","firstname":"Lai Yin","companyname":"","email":"gu01380413@hotmail.com","tel":"60396126","address":"Room 214, Pik Long House, Shek Pai Wan Estate, Hong Kong ","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1605.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-12","renew_room_key":"0012436759","renew_remark":"1 month contract. Storage rental $1605 paid by bank transfer on January 18, 2020. Outstanding $95 will transfer to next contract. Storage deposit $3210 transferred from agreement A05-CT196659 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT207001, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"116","order_discount":[],"order_room":[{"room_id":"1111","room_code":"A05-109","retail_price":"1605.0","discounted_price":"1605.00","location_id":"4"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1605,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1605,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-12","rent_from":"2020-02-12","rent_to":"2020-03-11","delivery_service":"0","remark":"1 month contract. $95 transferred from contract A05-CT207001 to this contract. Storage rental $1600 paid by bank transfer on February 25, 2020. Extra $9 will transfer to next contract. Storage deposit $3210 transferred from agreement A05-CT207001 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1605,"final_order_total":1605,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012436759","order_product":[],"pass":true}},"first_order_id":"3564","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-109 <\/td>\r\n\t\t\t\t\t 4X5X7 <\/td>\r\n\t\t\t\t\t $1605.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":"20","total_discounted_price":"1605.0","deposit":"0","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 11:58:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1067,"NEW","A05-CT207256",1605,1605,0,0,"1","1",1605,1605,1605,"2020-02-25 11:58:33","0",null,null,null,"2020-02-12","2020-03-11","1 month contract. $95 transferred from contract A05-CT207001 to this contract. Storage rental $1600 paid by bank transfer on February 25, 2020. Extra $9 will transfer to next contract. Storage deposit $3210 transferred from agreement A05-CT207001 to this agreement. \r\n","2020-02-12","20",0,null,0,"0","2","2020-02-25 11:58:33","2","2020-02-25 11:58:33","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012436759","C181067","PERSONAL","Mr","DslEpAGTlvzwRhXWzd3GTQ==","H9gmHz05\/Te4s1\/V+q8XVg==","","m4rpeseyC+3XbEZyki2sZe8nBXUNRhxQsygvVPRrHuh9JuMqbXLWzl\/BfY8qGZS6DRiHyjvCbg\/6kE8K2OncZQ==","fywBBIIwzINfMGd5TWlOxw==","WwudnjXvrdBb2Ykc6EFFLev8id0sdCyvkKSmhESkEzs=","e7I4cjG99z4ybwV1aES9ng==",null,1,"3564"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 11:58:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7256","1111","1605.0","1605.00","2","2020-02-25 11:58:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 11:58:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-12","2020-03-11","1111"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-25 11:58:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7256",1067,"SETTLED","A05-I207584","2020-02-25 11:58:33","2020-02-12","2","2020-02-25 11:58:33","2","2020-02-25 11:58:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 11:58:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7584","RENT","\u9810\u7e73\u79df\u91d1",1,1605,"MO","1",1605,"2","2020-02-25 11:58:33","2","2020-02-25 11:58:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 11:58:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1605,0,"7584"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-25 11:58:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1067,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207232","2020-02-25 11:58:33",1605,"2","2020-02-25 11:58:33","2","2020-02-25 11:58:33","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 11:58:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7232","DEPOSIT",null,"PAID","2020-02-25 11:58:33",0,"2","2020-02-25 11:58:33","2","2020-02-25 11:58:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 11:58:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7232","INVOICE","7584","PAID","2020-02-25 11:58:33",1605,"2","2020-02-25 11:58:33","2","2020-02-25 11:58:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:00:50","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=512&filter3=undefined&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":616,"customer_code":"C170616","identity_type":"PERSONAL","identity_id":"Z103280(2)","title":"Ms","lastname":"Yiu","firstname":"Kit Ling","companyname":"","email":"jessieyiu@hotmail.com","tel":"96981481","address":"Room 3611, Tung On House, Lei Tung Estate, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-18","renew_room_key":"054,29997","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 12, 2020. Storage deposit transferred from agreement A14-CT196782 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT206941, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"686","room_code":"N03","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-02-18","rent_from":"2020-02-18","rent_to":"2020-03-17","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on February 24, 2020. Storage deposit transferred from agreement A14-CT206941 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":"054,29997","order_product":[],"pass":true}},"first_order_id":"4846","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> N03 <\/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-02-25 12:00:51","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",616,"NEW","A14-CT207257",598,598,0,0,"1","1",598,598,598,"2020-02-25 12:00:51","0",null,null,null,"2020-02-18","2020-03-17","1 month contract. Storage rental paid by bank transfer on February 24, 2020. Storage deposit transferred from agreement A14-CT206941 to this agreement.\r\n","2020-02-18","12",0,null,0,"0","2","2020-02-25 12:00:50","2","2020-02-25 12:00:50","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,29997","C170616","PERSONAL","Ms","p8\/VerPta7kqG1jT7vONTw==","izJVo3RcQVJ02PBMypGKnQ==","","ENXImS4KdDZt3vDBAvbUseTFoyYV41Dwmv5vVbvIdZhZx8O1O37lzRS04mcx6FS\/yI73wDF8ltcsMz9AVNZttg==","a4NDOVya9cf76uWohlEcuA==","6FqTwPEFt8u2TYXg83c9argn0qm0Ubm3\/Tw0rg\/hkrw=","9XfgXEI68THR3GL9uXD8Pg==",null,1,"4846"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:00:51","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":["7257","686","598.0","598.00","2","2020-02-25 12:00:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:00:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-18","2020-03-17","686"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-25 12:00:51","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":["7257",616,"SETTLED","A14-I207585","2020-02-25 12:00:50","2020-02-18","2","2020-02-25 12:00:50","2","2020-02-25 12:00:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:00:51","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":["7585","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-02-25 12:00:50","2","2020-02-25 12:00:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:00:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7585"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-25 12:00:51","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":[616,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207233","2020-02-25 12:00:50",598,"2","2020-02-25 12:00:50","2","2020-02-25 12:00:50","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:00:51","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":["7233","DEPOSIT",null,"PAID","2020-02-25 12:00:50",0,"2","2020-02-25 12:00:50","2","2020-02-25 12:00:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:00:51","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":["7233","INVOICE","7585","PAID","2020-02-25 12:00:50",598,"2","2020-02-25 12:00:50","2","2020-02-25 12:00:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:15:41","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=512&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":506,"customer_code":"C170506","identity_type":"PERSONAL","identity_id":"D435016(3)","title":"Mr","lastname":"Kwok","firstname":"Chi Kong","companyname":"","email":"kwokchikong@gmail.com","tel":"91520880","address":"\u9d28\u8137\u6d32\u5229\u679d\u9053145\u865f\u91d1\u767c\u5927\u5ec85\u6a13F\u5ba4","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1286.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-17","renew_room_key":"054,46844","renew_remark":"1 month contract. Storage rental paid by PPS on January 15, 2020. Storage deposit transferred from agreement A12-CT195485 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT206979, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"113","room_code":"B61","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1286,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1286,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-17","rent_from":"2020-02-17","rent_to":"2020-03-16","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on February 24, 2020. Storage deposit transferred from agreement A12-CT206979 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1286,"final_order_total":1286,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,46844","order_product":[],"pass":true}},"first_order_id":"4179","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> B61 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \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":"20","total_discounted_price":"1286.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:15:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",506,"NEW","A12-CT207258",1528,1286,0,0,"1","1",1286,1286,1286,"2020-02-25 12:15:41","0",null,null,null,"2020-02-17","2020-03-16","1 month contract. Storage rental paid by PPS on February 24, 2020. Storage deposit transferred from agreement A12-CT206979 to this agreement.\r\n","2020-02-17","20",0,null,0,"0","2","2020-02-25 12:15:41","2","2020-02-25 12:15:41","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,46844","C170506","PERSONAL","Mr","m+azv2CUGWm2lPm4xNx9sA==","+pNULpsInm3siHASV0hIrg==","","LwVAteVJ0ZkV+zmR7qIDhOZ88Sc7Q+u3tsoHaiRzz2YCnm7wtowmDZcdUdskzm9A","22F8u0roh3XfvK0e6+ag3g==","WR6bE6RUwKqp5feySv5edgfk8AMEkZpUrE0\/8O+jORg=","Rmwt5dKGhWq\/pC\/sJ3hH+A==",null,1,"4179"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:15:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7258","113","1528.0","1528.00","2","2020-02-25 12:15:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:15:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-17","2020-03-16","113"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-25 12:15:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7258",506,"SETTLED","A12-I207586","2020-02-25 12:15:41","2020-02-17","2","2020-02-25 12:15:41","2","2020-02-25 12:15:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:15:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7586","RENT","\u9810\u7e73\u79df\u91d1",1,1286,"MO","1",1286,"2","2020-02-25 12:15:41","2","2020-02-25 12:15:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:15:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1286,0,"7586"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-25 12:15:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[506,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207234","2020-02-25 12:15:41",1286,"2","2020-02-25 12:15:41","2","2020-02-25 12:15:41","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:15:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7234","DEPOSIT",null,"PAID","2020-02-25 12:15:41",0,"2","2020-02-25 12:15:41","2","2020-02-25 12:15:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:15:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7234","INVOICE","7586","PAID","2020-02-25 12:15:41",1286,"2","2020-02-25 12:15:41","2","2020-02-25 12:15:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:25:10","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=512&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":506,"customer_code":"C170506","identity_type":"PERSONAL","identity_id":"D435016(3)","title":"Mr","lastname":"Kwok","firstname":"Chi Kong","companyname":"","email":"kwokchikong@gmail.com","tel":"91520880","address":"\u9d28\u8137\u6d32\u5229\u679d\u9053145\u865f\u91d1\u767c\u5927\u5ec85\u6a13F\u5ba4","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"998.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-15","renew_room_key":"054,46844","renew_remark":"1 month contract. Storage rental paid by PPS on January 15, 2020. Storage deposit transferred from agreement A12-CT196744 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT206980, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"243","room_code":"D47","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":998,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-15","rent_from":"2020-02-15","rent_to":"2020-03-14","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on February 24, 2020. Storage deposit transferred from agreement A12-CT206980 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":998,"final_order_total":998,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,46844","order_product":[],"pass":true}},"first_order_id":"4192","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> D47 <\/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\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"998.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:25:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",506,"NEW","A12-CT207259",998,998,0,0,"1","1",998,998,998,"2020-02-25 12:25:11","0",null,null,null,"2020-02-15","2020-03-14","1 month contract. Storage rental paid by PPS on February 24, 2020. Storage deposit transferred from agreement A12-CT206980 to this agreement.","2020-02-15","12",0,null,0,"0","2","2020-02-25 12:25:10","2","2020-02-25 12:25:10","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,46844","C170506","PERSONAL","Mr","m+azv2CUGWm2lPm4xNx9sA==","+pNULpsInm3siHASV0hIrg==","","LwVAteVJ0ZkV+zmR7qIDhOZ88Sc7Q+u3tsoHaiRzz2YCnm7wtowmDZcdUdskzm9A","22F8u0roh3XfvK0e6+ag3g==","WR6bE6RUwKqp5feySv5edgfk8AMEkZpUrE0\/8O+jORg=","Rmwt5dKGhWq\/pC\/sJ3hH+A==",null,1,"4192"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:25: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":["7259","243","998.0","998.00","2","2020-02-25 12:25:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:25:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-15","2020-03-14","243"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-25 12:25: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":["7259",506,"SETTLED","A12-I207587","2020-02-25 12:25:10","2020-02-15","2","2020-02-25 12:25:10","2","2020-02-25 12:25:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:25: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":["7587","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-02-25 12:25:10","2","2020-02-25 12:25:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:25:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"7587"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-25 12:25: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":[506,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207235","2020-02-25 12:25:10",998,"2","2020-02-25 12:25:10","2","2020-02-25 12:25:10","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:25: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":["7235","DEPOSIT",null,"PAID","2020-02-25 12:25:10",0,"2","2020-02-25 12:25:10","2","2020-02-25 12:25:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:25: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":["7235","INVOICE","7587","PAID","2020-02-25 12:25:10",998,"2","2020-02-25 12:25:10","2","2020-02-25 12:25:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:28:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:32:40","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=1&filter2=934&filter3=undefined","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":934,"customer_code":"C180934","identity_type":"PERSONAL","identity_id":"Z739355(6)","title":"Mr","lastname":"Kam","firstname":"Hang Wai","companyname":"","email":"kam6163@gmail.com","tel":"62380278","address":"G\/F, Blk B, Sunview Industry Building , 3 On Yip Street, Chai Wai, HK","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1516.0","renew_rent_month":"6","renew_warehousing_date":"2020-02-17","renew_room_key":"0012421013","renew_remark":"6 months contract. Storage rental paid by PPS on August 16, 2019. Storage deposit $3444 transferred from agreement B01-CT182936 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT195763, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"144","order_discount":[{"master_room_discount_id":"322","master_room_id":"144","discount_type":"%","price":"1722.00","disocunted_price":"1263.90","discount":"26.60","monthly_deduct":458.052,"room_id":"1247","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1247","room_code":"B01-057","retail_price":"1722.0","discounted_price":1263.9,"location_id":"5"}],"roughly_size":"28","total_retail_price":1722,"total_discounted_price":1516,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":8064,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1032.00","warehousing_date":"2020-02-17","rent_from":"2020-02-17","rent_to":"2020-08-16","delivery_service":"0","remark":"6 months contract. Special offer $1334\/month. Storage rental paid by PPS on February 25, 2020. Storage deposit $3444 transferred from agreement B01-CT195763 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":1032,"order_total":9096,"final_order_total":8064,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0012421013","order_product":[],"pass":true}},"first_order_id":"2936","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> B01-057 <\/td>\r\n\t\t\t\t\t 4X7X7 <\/td>\r\n\t\t\t\t\t $1722.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":"28","total_discounted_price":"1516.0","deposit":"0","total_retail_price":"1722.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:32:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","2","5",934,"NEW","B01-CT207260",1722,1516,0,0,"6","6",8064,9096,8064,"2020-02-25 12:32:41","0",null,null,null,"2020-02-17","2020-08-16","6 months contract. Special offer $1334\/month. Storage rental paid by PPS on February 25, 2020. Storage deposit $3444 transferred from agreement B01-CT195763 to this agreement.\r\n","2020-02-17","28",0,null,1032,"1032.00","2","2020-02-25 12:32:40","2","2020-02-25 12:32:40","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0012421013","C180934","PERSONAL","Mr","StXCAUvh+VKwTp70Ji7HmQ==","23wCRdcybxUEHt5OHLfIwQ==","","P5xcVShMtFk79EaAhZjxItx\/9UhMnrGwdlBxYhhtqUTFgqXpGxaMvMZSCpNbabybEp74gydZltkAT3Orjp9ZoBEiBPtikwfB0jTuPpQkK\/4=","eVGtiJN9n9aEvzx6N4tEbg==","eSBYJRSZcCtrEPof9Ilp84wmJrMVcapIxmc8hJxQDTc=","\/vw5ktFAMPPDB68bxSAVTQ==",null,1,"2936"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:32:41","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":["7260","322","144","1247","%","26.60",458.052,"2","2020-02-25 12:32:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:32:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7260","1247","1722.0",1263.9,"2","2020-02-25 12:32:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:32:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-17","2020-08-16","1247"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-25 12:32:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7260",934,"SETTLED","B01-I207588","2020-02-25 12:32:40","2020-02-17","2","2020-02-25 12:32:40","2","2020-02-25 12:32:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:32:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7588","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,484,"MO","1",484,"2","2020-02-25 12:32:40","2","2020-02-25 12:32:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:32:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7588","RENT","\u9810\u7e73\u79df\u91d1",2,1516,"MO","1",1516,"2","2020-02-25 12:32:40","2","2020-02-25 12:32:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:32:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7588","RENT","\u9810\u7e73\u79df\u91d1",3,1516,"MO","1",1516,"2","2020-02-25 12:32:40","2","2020-02-25 12:32:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:32:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7588","RENT","\u9810\u7e73\u79df\u91d1",4,1516,"MO","1",1516,"2","2020-02-25 12:32:40","2","2020-02-25 12:32:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:32:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7588","RENT","\u9810\u7e73\u79df\u91d1",5,1516,"MO","1",1516,"2","2020-02-25 12:32:40","2","2020-02-25 12:32:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:32:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7588","RENT","\u9810\u7e73\u79df\u91d1",6,1516,"MO","1",1516,"2","2020-02-25 12:32:40","2","2020-02-25 12:32:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:32:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8064,0,"7588"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-25 12:32:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[934,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207236","2020-02-25 12:32:40",8064,"2","2020-02-25 12:32:40","2","2020-02-25 12:32:40","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:32:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7236","DEPOSIT",null,"PAID","2020-02-25 12:32:40",0,"2","2020-02-25 12:32:40","2","2020-02-25 12:32:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 12:32:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7236","INVOICE","7588","PAID","2020-02-25 12:32:40",8064,"2","2020-02-25 12:32:40","2","2020-02-25 12:32:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 13:55:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 14:25:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 14:28:13","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=1&filter2=934&filter3=undefined&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1646","master_room_id":"206","room_code":"A16-155"}],"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-155 <\/td>\r\n\t\t\t\t\t 4X7X7 <\/td>\r\n\t\t\t\t\t $2161.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":"D549938(1)","title":"Mr","lastname":"CHAN","firstname":"Kim Ho Vincent","companyname":"","email":"vincent_khchan@yahoo.com.hk","tel":"53603097","address":"9H, Kam Fung Bldg., 171 Aberdeen Main Road, Aberdeen, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1646","room_code":"A16-155","retail_price":"2161.0","discounted_price":"2161.00","location_id":"7"}],"roughly_size":"28","total_retail_price":2161,"total_discounted_price":1945,"deposit":4322,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":27462,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2145.00","warehousing_date":"2020-03-01","rent_from":"2020-03-01","rent_to":"2021-03-31","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free and $200 \"Come to Us\" discount. Storage rental and deposit paid by EPS on February 25, 2020. Smaetcard and padlock provided on February 25, 2020.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":2145,"order_total":29607,"final_order_total":27462,"location_id":"7","branch_id":"1","company_id":"1","room_key":"092, 17481","order_product":[],"pass":true}},"roughly_size":"28","total_discounted_price":"1945.00","deposit":"4322.00","total_retail_price":"2161.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 14:28:15","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":["C201521","PERSONAL","Mr","z0buXrxMO5RH1gZ07q26qw==","8BEgNhGpCR8jGkzUtrIcXg==","","6NacOxFV9vgKnvOji8MljQ==","DZzH6k8NsdEBor7PSywR1B8JOPqCMyaFt3Sxdb3q8fE=","rFt3VBE7p5\/qxfhPhiA0518YrstiEEnVWUGPUTnj6\/Dj25xZblFwaTCGTg6QMlD5gQa5lkFsWV7Mja1Web104w==","ZcyzzajXdAMYTcmYUVKVGg==",null,"DZzH6k8NsdEBor7PSywR1B8JOPqCMyaFt3Sxdb3q8fE=","24cBeAOCFJ8QHSLb0JAJ3A==","2","2020-02-25 14:28:13","2","2020-02-25 14:28:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 14:28:15","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",1521,"NEW","A16-CT207261",2161,1945,4322,0,"13","13",27462,29607,27462,"2020-02-25 14:28:15","0",null,null,null,"2020-03-01","2021-03-31","13 months contract. Special offer the 13th month free and $200 \"Come to Us\" discount. Storage rental and deposit paid by EPS on February 25, 2020. Smaetcard and padlock provided on February 25, 2020.","2020-03-01","28",0,null,2145,"2145.00","2","2020-02-25 14:28:13","2","2020-02-25 14:28:13","EPS","","","","EPS","","","",null,0,"092, 17481","C201521","PERSONAL","Mr","z0buXrxMO5RH1gZ07q26qw==","8BEgNhGpCR8jGkzUtrIcXg==","","rFt3VBE7p5\/qxfhPhiA0518YrstiEEnVWUGPUTnj6\/Dj25xZblFwaTCGTg6QMlD5gQa5lkFsWV7Mja1Web104w==","6NacOxFV9vgKnvOji8MljQ==","DZzH6k8NsdEBor7PSywR1B8JOPqCMyaFt3Sxdb3q8fE=","ZcyzzajXdAMYTcmYUVKVGg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 14:28:15","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":["7261","1646","2161.0","2161.00","2","2020-02-25 14:28:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 14:28:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-01","2021-03-31","1646"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-25 14:28:15","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":["7261","A16-D205301","PAID",4322,0,"2021-03-31","2020-02-25 14:28:13","2020-02-25 14:28:13","2","2020-02-25 14:28:13","2","2020-02-25 14:28:13",1521]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 14:28:15","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":["7261",1521,"SETTLED","A16-I207589","2020-02-25 14:28:13","2020-03-01","2","2020-02-25 14:28:13","2","2020-02-25 14:28:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 14:28:15","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":["7589","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-02-25 14:28:13","2","2020-02-25 14:28:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 14:28:15","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":["7589","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1745,"MO","1",1745,"2","2020-02-25 14:28:13","2","2020-02-25 14:28:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 14:28:15","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":["7589","RENT","\u9810\u7e73\u79df\u91d1",3,1945,"MO","1",1945,"2","2020-02-25 14:28:13","2","2020-02-25 14:28:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 14:28:15","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":["7589","RENT","\u9810\u7e73\u79df\u91d1",4,1945,"MO","1",1945,"2","2020-02-25 14:28:13","2","2020-02-25 14:28:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 14:28:15","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":["7589","RENT","\u9810\u7e73\u79df\u91d1",5,1945,"MO","1",1945,"2","2020-02-25 14:28:13","2","2020-02-25 14:28:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 14:28:15","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":["7589","RENT","\u9810\u7e73\u79df\u91d1",6,1945,"MO","1",1945,"2","2020-02-25 14:28:13","2","2020-02-25 14:28:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 14:28:15","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":["7589","RENT","\u9810\u7e73\u79df\u91d1",7,1945,"MO","1",1945,"2","2020-02-25 14:28:13","2","2020-02-25 14:28:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 14:28:15","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":["7589","RENT","\u9810\u7e73\u79df\u91d1",8,1945,"MO","1",1945,"2","2020-02-25 14:28:13","2","2020-02-25 14:28:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 14:28:15","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":["7589","RENT","\u9810\u7e73\u79df\u91d1",9,1945,"MO","1",1945,"2","2020-02-25 14:28:13","2","2020-02-25 14:28:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 14:28:15","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":["7589","RENT","\u9810\u7e73\u79df\u91d1",10,1945,"MO","1",1945,"2","2020-02-25 14:28:13","2","2020-02-25 14:28:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 14:28:15","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":["7589","RENT","\u9810\u7e73\u79df\u91d1",11,1945,"MO","1",1945,"2","2020-02-25 14:28:13","2","2020-02-25 14:28:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 14:28:15","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":["7589","RENT","\u9810\u7e73\u79df\u91d1",12,1945,"MO","1",1945,"2","2020-02-25 14:28:13","2","2020-02-25 14:28:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 14:28:15","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":["7589","RENT","\u9810\u7e73\u79df\u91d1",13,1945,"MO","1",1945,"2","2020-02-25 14:28:13","2","2020-02-25 14:28:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 14:28:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[23140,0,"7589"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-25 14:28:15","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":[1521,"EPS","","","","EPS","","","","PAID","P207237","2020-02-25 14:28:13",27462,"2","2020-02-25 14:28:13","2","2020-02-25 14:28:13","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 14:28:15","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":["7237","DEPOSIT","5301","PAID","2020-02-25 14:28:13",4322,"2","2020-02-25 14:28:13","2","2020-02-25 14:28:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 14:28:15","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":["7237","INVOICE","7589","PAID","2020-02-25 14:28:13",23140,"2","2020-02-25 14:28:13","2","2020-02-25 14:28:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 14:42:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 14:42:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 18:51:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 19:15:42","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"selected_room_tr":"\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n\t\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\t\t\t\t \n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-151 <\/td>\n\t\t\t\t\t 5X8X6.5 <\/td>\n\t\t\t\t\t $2168.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr> C15-150 <\/td>\n\t\t\t\t\t 5X8X6.5 <\/td>\n\t\t\t\t\t $2168.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\n\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"BUSINESS","identity_id":"36881187","title":"Ms","lastname":"LEUNG","firstname":"Shirley","companyname":"Maxwell International Holdings Limited","email":"info@maxwelldancing.com","tel":"93880422","address":"1506, 10 Chater Road, Hong Kong","pass":true,"customer_id":"1470","customer_code":"C191470","customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"429 available_room_list_input","master_room_id":"184","discount_type":"%","price":"2168.00","disocunted_price":"2059.80","discount":"4.99","monthly_deduct":108.1832,"room_id":"1457","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"429 available_room_list_input","master_room_id":"184","discount_type":"%","price":"2168.00","disocunted_price":"2059.80","discount":"4.99","monthly_deduct":108.1832,"room_id":"1456","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1457","room_code":"C15-151","retail_price":"2168.0","discounted_price":2059.8,"location_id":"6"},{"room_id":"1456","room_code":"C15-150","retail_price":"2168.0","discounted_price":2059.8,"location_id":"6"}],"roughly_size":"80","total_retail_price":4336,"total_discounted_price":4120,"deposit":4336,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":16696,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-26","rent_from":"2020-02-26","rent_to":"2020-05-25","delivery_service":"0","remark":"3 months contract. Storage rental and deposit paid by bank transfer on Feb 25,2020. Smart card provided and mailed out on the same day.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":16696,"final_order_total":16696,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012415181","order_product":[],"pass":true}},"roughly_size":"80","total_discounted_price":"4120.00","deposit":"4336","total_retail_price":"4336.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 19:15:43","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":["C201522","BUSINESS","Ms","maGPoIyyOq0FH19ab1I12w==","yXKc2lCF323ApRADrjNaSg==","Maxwell International Holdings Limited","EGeyc0EeOLCcsqDPfA6YiQ==","4dnH0rljgTSIK1rTsoMWiSCW7EQLum6YOPZNSkfE778=","jvJ\/OPD9ncA9D81pWlBUtZAKchaFIaMrEyNFB8Tlgsw=",null,"nSr3gGP7oX\/irLGjgfYIKQ==","4dnH0rljgTSIK1rTsoMWiSCW7EQLum6YOPZNSkfE778=","Sf4ni94LQISFqSk2mm4H1g==","2","2020-02-25 19:15:42","2","2020-02-25 19:15:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 19:15:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","3","6",1522,"NEW","C15-CT207262",4336,4120,4336,0,"3","3",16696,16696,16696,"2020-02-25 19:15:44","0",null,null,null,"2020-02-26","2020-05-25","3 months contract. Storage rental and deposit paid by bank transfer on Feb 25,2020. Smart card provided and mailed out on the same day.","2020-02-26","80",0,null,0,"0","2","2020-02-25 19:15:42","2","2020-02-25 19:15:42","BANKIN","","","","BANKIN","","","",null,0,"0012415181","C201522","BUSINESS","Ms","maGPoIyyOq0FH19ab1I12w==","yXKc2lCF323ApRADrjNaSg==","Maxwell International Holdings Limited","jvJ\/OPD9ncA9D81pWlBUtZAKchaFIaMrEyNFB8Tlgsw=","EGeyc0EeOLCcsqDPfA6YiQ==","4dnH0rljgTSIK1rTsoMWiSCW7EQLum6YOPZNSkfE778=",null,"nSr3gGP7oX\/irLGjgfYIKQ=="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 19:15:44","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":["7262","429 available_room_list_input","184","1457","%","4.99",108.1832,"2","2020-02-25 19:15:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 19:15:44","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":["7262","429 available_room_list_input","184","1456","%","4.99",108.1832,"2","2020-02-25 19:15:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 19:15:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7262","1457","2168.0",2059.8,"2","2020-02-25 19:15:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 19:15:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-26","2020-05-25","1457"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-25 19:15:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7262","1456","2168.0",2059.8,"2","2020-02-25 19:15:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 19:15:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-26","2020-05-25","1456"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-25 19:15:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["7262","C15-D205302","PAID",4336,0,"2020-05-25","2020-02-25 19:15:42","2020-02-25 19:15:42","2","2020-02-25 19:15:42","2","2020-02-25 19:15:42",1522]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 19:15:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7262",1522,"SETTLED","C15-I207590","2020-02-25 19:15:42","2020-02-26","2","2020-02-25 19:15:42","2","2020-02-25 19:15:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 19:15:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7590","RENT","\u9810\u7e73\u79df\u91d1",1,4120,"MO","1",4120,"2","2020-02-25 19:15:42","2","2020-02-25 19:15:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 19:15:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7590","RENT","\u9810\u7e73\u79df\u91d1",2,4120,"MO","1",4120,"2","2020-02-25 19:15:42","2","2020-02-25 19:15:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 19:15:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7590","RENT","\u9810\u7e73\u79df\u91d1",3,4120,"MO","1",4120,"2","2020-02-25 19:15:42","2","2020-02-25 19:15:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 19:15:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[12360,0,"7590"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-25 19:15:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1522,"BANKIN","","","","BANKIN","","","","PAID","P207238","2020-02-25 19:15:42",16696,"2","2020-02-25 19:15:42","2","2020-02-25 19:15:42","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 19:15:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7238","DEPOSIT","5302","PAID","2020-02-25 19:15:42",4336,"2","2020-02-25 19:15:42","2","2020-02-25 19:15:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-25 19:15:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7238","INVOICE","7590","PAID","2020-02-25 19:15:42",12360,"2","2020-02-25 19:15:42","2","2020-02-25 19:15:42"]},"data_before":[],"data_after":[],"step":1} *****