\n \n \n\t\t\t\t\t

\u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n

\u5009\u5eab\u7de8\u865f<\/td>\n	\u5c3a\u5bf8<\/td>\n	\u539f\u50f9(\u6708)<\/td>\n	\u512a\u60e0\u50f9(\u6708)<\/td>\n	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n	\u50f9\u683c<\/td>\n	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n	<\/td>\n <\/tr>
C15-007 <\/td>\n\t\t\t\t\t	4X2.5X6.5 <\/td>\n\t\t\t\t\t	$773.00 <\/td>\n\t\t\t\t	- <\/td>	<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"10","total_discounted_price":"773.00","deposit":"773.00","total_retail_price":"773.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:07:18","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":["C201505","PERSONAL","Ms","K6CZ9UUjtQcq2bBPDY0Brg==","ddrfzAYTmkL\/QNu3psjONQ==","","Hl69FJ9hMe1tXmUBCwltZA==","El5xh+fj\/Xt6sO4Jp95HQ5IWcSwJ2mwHP8EuPCiRXZ4=","XdnC8GvyDJ4gPKz7oUpjCSQU0ThEUFO\/Tl2+nZEgpoewpioAdxtLxDOHsPtVdOky","3H26cWfXKmAN3CQ33oJxCw==",null,"El5xh+fj\/Xt6sO4Jp95HQ5IWcSwJ2mwHP8EuPCiRXZ4=","n5wVSsRBqcAtEfXmyPNOzQ==","2","2020-02-06 16:07:17","2","2020-02-06 16:07:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:07:18","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",1505,"NEW","C15-CT207130",773,773,773,0,"1","1",1546,1606,1606,"2020-02-06 16:07:18","0",null,null,null,"2020-02-08","2020-03-07","1 month contract. Storage rental and deposit, smartcard paid by bank transfer on Feb 06,2020. ","2020-02-08","10",0,null,0,"0","2","2020-02-06 16:07:17","2","2020-02-06 16:07:17","BANKIN","","","","BANKIN","","","",null,0,"0005013086","C201505","PERSONAL","Ms","K6CZ9UUjtQcq2bBPDY0Brg==","ddrfzAYTmkL\/QNu3psjONQ==","","XdnC8GvyDJ4gPKz7oUpjCSQU0ThEUFO\/Tl2+nZEgpoewpioAdxtLxDOHsPtVdOky","Hl69FJ9hMe1tXmUBCwltZA==","El5xh+fj\/Xt6sO4Jp95HQ5IWcSwJ2mwHP8EuPCiRXZ4=","3H26cWfXKmAN3CQ33oJxCw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:07:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7130",1505,"11","1","60.0",60,"2","2020-02-06 16:07:17","2","2020-02-06 16:07:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:07:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"7130"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-02-06 16:07:18","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":["7130","1313","773.0","773.00","2","2020-02-06 16:07:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:07:18","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-08","2020-03-07","1313"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-06 16:07:18","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":["7130","C15-D205280","PAID",773,0,"2020-03-07","2020-02-06 16:07:17","2020-02-06 16:07:17","2","2020-02-06 16:07:17","2","2020-02-06 16:07:17",1505]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:07:18","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":["7130",1505,"SETTLED","C15-I207458","2020-02-06 16:07:17","2020-02-08","2","2020-02-06 16:07:17","2","2020-02-06 16:07:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:07:18","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":["7458","RENT","\u9810\u7e73\u79df\u91d1",1,773,"MO","1",773,"2","2020-02-06 16:07:17","2","2020-02-06 16:07:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:07:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7458","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-02-06 16:07:17","2","2020-02-06 16:07:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:07:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[833,0,"7458"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-06 16:07:18","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":[1505,"BANKIN","","","","BANKIN","","","","PAID","P207106","2020-02-06 16:07:17",1606,"2","2020-02-06 16:07:17","2","2020-02-06 16:07:17","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:07:18","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":["7106","DEPOSIT","5280","PAID","2020-02-06 16:07:17",773,"2","2020-02-06 16:07:17","2","2020-02-06 16:07:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:07:18","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":["7106","INVOICE","7458","PAID","2020-02-06 16:07:17",833,"2","2020-02-06 16:07:17","2","2020-02-06 16:07:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:13:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:38:19","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":"","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":153,"customer_code":"C160153","identity_type":"PERSONAL","identity_id":"Z614380(7)","title":"Ms","lastname":"Au-Yeung","firstname":"Pik Kwan","companyname":"","email":"carol_85_2000@yahoo.com.hk","tel":"97502271","address":"\u9999\u6e2f\u77f3\u6392\u7063\u6751\u78a7\u8f1d\u6a137\u6a13706\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-01-20","renew_room_key":"053,63642","renew_remark":"1 month contract. Storage rental paid by PPS on January 2, 2020. Storage deposit transferred from agreement A12-CT196562 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT206848, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"227","room_code":"D31","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-01-20","rent_from":"2020-01-20","rent_to":"2020-02-19","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on February 6, 2020. Storage deposit transferred from agreement A12-CT206848 to this agreement.\r\n","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":"053,63642","order_product":[],"pass":true}},"first_order_id":"4883","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> D31 <\/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-06 16:38:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",153,"NEW","A12-CT207131",998,998,0,0,"1","1",998,998,998,"2020-02-06 16:38:19","0",null,null,null,"2020-01-20","2020-02-19","1 month contract. Storage rental paid by PPS on February 6, 2020. Storage deposit transferred from agreement A12-CT206848 to this agreement.\r\n","2020-01-20","12",0,null,0,"0","2","2020-02-06 16:38:19","2","2020-02-06 16:38:19","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"053,63642","C160153","PERSONAL","Ms","KkrSDrQ1H2C7AHMXanK04g==","5c4M0ZQmSIw3LaJy30yaLQ==","","VydP8q4rzuZV5xu3JM4S94+vjANpX0mSGFwOYMOB853mNnGiX4hnOAOtYB32IPMF","G4ql4s\/qkLFXwmJNbU6cdQ==","2yv4BPlbG\/\/YEJETfEEfNB1ddarjnzyQnu7bGnobgMM=","N0BX828OAg4Z6rH9GAZdUA==",null,1,"4883"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:38:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7131","227","998.0","998.00","2","2020-02-06 16:38:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:38:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-20","2020-02-19","227"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-06 16:38:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7131",153,"SETTLED","A12-I207459","2020-02-06 16:38:19","2020-01-20","2","2020-02-06 16:38:19","2","2020-02-06 16:38:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:38:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7459","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-02-06 16:38:19","2","2020-02-06 16:38:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:38:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"7459"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-06 16:38:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[153,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207107","2020-02-06 16:38:19",998,"2","2020-02-06 16:38:19","2","2020-02-06 16:38:19","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:38:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7107","DEPOSIT",null,"PAID","2020-02-06 16:38:19",0,"2","2020-02-06 16:38:19","2","2020-02-06 16:38:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:38:20","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7107","INVOICE","7459","PAID","2020-02-06 16:38:19",998,"2","2020-02-06 16:38:19","2","2020-02-06 16:38:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:43:34","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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1311,"customer_code":"C191311","identity_type":"PERSONAL","identity_id":"K105798(7)","title":"Ms","lastname":"Lo","firstname":"Kuen Fun","companyname":"","email":"lokuenfun@yahoo.com","tel":"96870556","address":"Room 907, Tung Sing House, Lei Tung Estate, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"503.0","renew_rent_month":"6","renew_warehousing_date":"2020-02-19","renew_room_key":"190,01639, 076,32371","renew_remark":"6 months contract. Storage rental and deposit paid by EPS on June 22, 2019. Smartcard provided on June 22, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT195292, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1116.0","renew_master_room_id":"196","order_discount":[],"order_room":[{"room_id":"1509","room_code":"A16-018","retail_price":"598.0","discounted_price":"598.00","location_id":"7"}],"roughly_size":"8","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":6456,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"538.00","warehousing_date":"2020-02-19","rent_from":"2020-02-19","rent_to":"2021-03-18","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by PPS on February 5, 2020. Storage deposit $1116 transferred from agreement A16-CT195292 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":538,"order_total":6994,"final_order_total":6456,"location_id":"7","branch_id":"1","company_id":"1","room_key":"190,01639, 076,32371","order_product":[],"pass":true}},"first_order_id":5292,"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-018 <\/td>\r\n\t\t\t\t\t 4X2X3.5 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"8","total_discounted_price":"538.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:43:34","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",1311,"NEW","A16-CT207132",598,538,0,0,"13","13",6456,6994,6456,"2020-02-06 16:43:34","0",null,null,null,"2020-02-19","2021-03-18","13 months contract. Special offer the 13th month free. Storage rental paid by PPS on February 5, 2020. Storage deposit $1116 transferred from agreement A16-CT195292 to this agreement. ","2020-02-19","8",0,null,538,"538.00","2","2020-02-06 16:43:34","2","2020-02-06 16:43:34","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"190,01639, 076,32371","C191311","PERSONAL","Ms","hBcSRip9t5FSBua3YNArjw==","4w4biS+jM\/Q3DAzxHdf3pA==","","giQ7QHdSdA\/i2o7x1lqj35GYYFUtyDIz5ItvA3MBAT0BGoOa\/4lfBCIEDiengz8B3\/NVkynpDqzItCYhvkOpPUtbP81gAumxucDL8najrvI=","x3aXvSJ4eN+mCSavm\/vhYA==","kpv0qcHJ8imlx1KG25P4d4FoQGjf+3U6yJouoQ4QGAI=","GBmYkmLhftXxsW7pZBRNww==",null,1,5292]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:43:34","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":["7132","1509","598.0","598.00","2","2020-02-06 16:43:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:43:34","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-19","2021-03-18","1509"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-06 16:43:34","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":["7132",1311,"SETTLED","A16-I207460","2020-02-06 16:43:34","2020-02-19","2","2020-02-06 16:43:34","2","2020-02-06 16:43:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:43:34","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":["7460","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,538,"MO","1",538,"2","2020-02-06 16:43:34","2","2020-02-06 16:43:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:43:34","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":["7460","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-02-06 16:43:34","2","2020-02-06 16:43:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:43:34","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":["7460","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-02-06 16:43:34","2","2020-02-06 16:43:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:43:34","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":["7460","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-02-06 16:43:34","2","2020-02-06 16:43:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:43:34","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":["7460","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-02-06 16:43:34","2","2020-02-06 16:43:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:43:34","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":["7460","RENT","\u9810\u7e73\u79df\u91d1",7,538,"MO","1",538,"2","2020-02-06 16:43:34","2","2020-02-06 16:43:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:43:34","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":["7460","RENT","\u9810\u7e73\u79df\u91d1",8,538,"MO","1",538,"2","2020-02-06 16:43:34","2","2020-02-06 16:43:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:43:34","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":["7460","RENT","\u9810\u7e73\u79df\u91d1",9,538,"MO","1",538,"2","2020-02-06 16:43:34","2","2020-02-06 16:43:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:43:34","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":["7460","RENT","\u9810\u7e73\u79df\u91d1",10,538,"MO","1",538,"2","2020-02-06 16:43:34","2","2020-02-06 16:43:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:43:34","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":["7460","RENT","\u9810\u7e73\u79df\u91d1",11,538,"MO","1",538,"2","2020-02-06 16:43:34","2","2020-02-06 16:43:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:43:34","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":["7460","RENT","\u9810\u7e73\u79df\u91d1",12,538,"MO","1",538,"2","2020-02-06 16:43:34","2","2020-02-06 16:43:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:43:34","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":["7460","RENT","\u9810\u7e73\u79df\u91d1",13,538,"MO","1",538,"2","2020-02-06 16:43:34","2","2020-02-06 16:43:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:43:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6456,0,"7460"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-06 16:43:34","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":[1311,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207108","2020-02-06 16:43:34",6456,"2","2020-02-06 16:43:34","2","2020-02-06 16:43:34","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:43:34","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":["7108","DEPOSIT",null,"PAID","2020-02-06 16:43:34",0,"2","2020-02-06 16:43:34","2","2020-02-06 16:43:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:43:34","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":["7108","INVOICE","7460","PAID","2020-02-06 16:43:34",6456,"2","2020-02-06 16:43:34","2","2020-02-06 16:43:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:48:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:58:08","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1131,"customer_code":"C181131","identity_type":"PERSONAL","identity_id":"Z345376(7)","title":"Mr","lastname":"Chan","firstname":"Siu Cheung","companyname":"","email":"siucheung2004@yahoo.com.hk","tel":"98251393","address":"Room 2204, Tung On House, Lei Tung Estate, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","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-03","renew_room_key":"0005012995","renew_remark":"1 month contract. Storage rental paid by PPS on January 3, 2020. Storage deposit transferred from agreement A05-CT196661 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT206866, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"110","order_discount":[],"order_room":[{"room_id":"1077","room_code":"A05-075","retail_price":"598.0","discounted_price":"598.00","location_id":"4"}],"roughly_size":"8","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-03","rent_from":"2020-02-03","rent_to":"2020-03-02","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on February 5, 2020. Storage deposit transferred from agreement A05-CT206866 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0005012995","order_product":[],"pass":true}},"first_order_id":"4845","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-075 <\/td>\r\n\t\t\t\t\t 4X2X3.5 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"8","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:58:08","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",1131,"NEW","A05-CT207133",598,598,0,0,"1","1",598,598,598,"2020-02-06 16:58:08","0",null,null,null,"2020-02-03","2020-03-02","1 month contract. Storage rental paid by PPS on February 5, 2020. Storage deposit transferred from agreement A05-CT206866 to this agreement.\r\n","2020-02-03","8",0,null,0,"0","2","2020-02-06 16:58:08","2","2020-02-06 16:58:08","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0005012995","C181131","PERSONAL","Mr","fGcZizJCatuKFWu4ZRrKSA==","U9yoE9KqV1v8YlRkf7Q2yg==","","CQCYoAe3GOoadJVRzLyv+sNtTDGIle0HVMeR83McsJynyrP8tFX204cW64FCZ5NA5j\/z2cPdugPvlnA2Si9a8Q==","9k5P13X5Z+o0UYFE5+2bdg==","ApBLMJPz\/Z49uwpRoZz00ngQMrV7EI2jJmIQp3ku3DM=","EdsRFjojZ1QPZDY\/kWek4g==",null,1,"4845"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:58:08","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":["7133","1077","598.0","598.00","2","2020-02-06 16:58:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:58:08","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-03","2020-03-02","1077"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-06 16:58:08","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":["7133",1131,"SETTLED","A05-I207461","2020-02-06 16:58:08","2020-02-03","2","2020-02-06 16:58:08","2","2020-02-06 16:58:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:58:08","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":["7461","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-02-06 16:58:08","2","2020-02-06 16:58:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:58:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7461"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-06 16:58:08","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":[1131,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207109","2020-02-06 16:58:08",598,"2","2020-02-06 16:58:08","2","2020-02-06 16:58:08","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:58:08","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":["7109","DEPOSIT",null,"PAID","2020-02-06 16:58:08",0,"2","2020-02-06 16:58:08","2","2020-02-06 16:58:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 16:58:08","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":["7109","INVOICE","7461","PAID","2020-02-06 16:58:08",598,"2","2020-02-06 16:58:08","2","2020-02-06 16:58:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 17:02:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 17:03:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 17:13:28","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 17:50:18","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-06 17:50:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****