\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>
B01-010 <\/td>\n\t\t\t\t\t	4X5X7 <\/td>\n\t\t\t\t\t	$1308.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"20","total_discounted_price":"1021.00","deposit":"2616.00","total_retail_price":"1308.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:29:19","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":["C201497","PERSONAL","Ms","pW1hjJszcyhXwFGSMcbhPw==","brgGVGuPrfoSjI4k+kLGow==","","6SNoo46vGLWnY2cAZBwsdA==","2bwdtz\/a13qlc\/UyOuJpU9wh+k2Xlm\/KM0PC2SINxD8=","q3BokFfJHxzrZXBvvX\/6Xg9dpn\/r8HrsWzTuOIZY2A8SKypigLij\/zsluPplSu3cpP96WoB3Wjkq1aeMyrRVWw==","dMHqDtmbbUUUFmVvyG8YZw==",null,"2bwdtz\/a13qlc\/UyOuJpU9wh+k2Xlm\/KM0PC2SINxD8=","XSoEYb5nNeyAfjeQPe3igQ==","2","2020-01-24 11:29:17","2","2020-01-24 11:29:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:29:19","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","2","5",1497,"NEW","B01-CT207040",1308,1021,2616,0,"12","12",12316,14928,12376,"2020-01-24 11:29:19","0",null,null,null,"2020-02-01","2021-01-31","12 months contract. Special offer two months free and 5% 'rent now' discount. Storage rental and deposit paid by bank transfer on Jan 24,2020. Smart card paid and mail out on Jan 24,2020.","2020-02-01","20",0,null,2552,"2552.00","2","2020-01-24 11:29:17","2","2020-01-24 11:29:17","BANKIN","","","","BANKIN","","","",null,0,"0012438125","C201497","PERSONAL","Ms","pW1hjJszcyhXwFGSMcbhPw==","brgGVGuPrfoSjI4k+kLGow==","","q3BokFfJHxzrZXBvvX\/6Xg9dpn\/r8HrsWzTuOIZY2A8SKypigLij\/zsluPplSu3cpP96WoB3Wjkq1aeMyrRVWw==","6SNoo46vGLWnY2cAZBwsdA==","2bwdtz\/a13qlc\/UyOuJpU9wh+k2Xlm\/KM0PC2SINxD8=","dMHqDtmbbUUUFmVvyG8YZw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:29:19","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":["7040","342 available_room_list_input","141","1200","%","34.94",457.0152,"2","2020-01-24 11:29:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:29:19","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":["7040",1497,"11","1","60.0",60,"2","2020-01-24 11:29:17","2","2020-01-24 11:29:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:29:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"7040"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-01-24 11:29:19","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":["7040","1200","1308.0",851,"2","2020-01-24 11:29:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:29:19","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-01","2021-01-31","1200"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-24 11:29:19","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":["7040","B01-D205268","PAID",2616,0,"2021-01-31","2020-01-24 11:29:17","2020-01-24 11:29:17","2","2020-01-24 11:29:17","2","2020-01-24 11:29:17",1497]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:29:19","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":["7040",1497,"SETTLED","B01-I207368","2020-01-24 11:29:17","2020-02-01","2","2020-01-24 11:29:17","2","2020-01-24 11:29:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:29:19","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":["7368","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-01-24 11:29:17","2","2020-01-24 11:29:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:29:19","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":["7368","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-01-24 11:29:17","2","2020-01-24 11:29:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:29:19","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":["7368","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,511,"MO","1",511,"2","2020-01-24 11:29:17","2","2020-01-24 11:29:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:29:19","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":["7368","RENT","\u9810\u7e73\u79df\u91d1",4,1021,"MO","1",1021,"2","2020-01-24 11:29:17","2","2020-01-24 11:29:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:29:19","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":["7368","RENT","\u9810\u7e73\u79df\u91d1",5,1021,"MO","1",1021,"2","2020-01-24 11:29:17","2","2020-01-24 11:29:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:29:19","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":["7368","RENT","\u9810\u7e73\u79df\u91d1",6,1021,"MO","1",1021,"2","2020-01-24 11:29:17","2","2020-01-24 11:29:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:29:19","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":["7368","RENT","\u9810\u7e73\u79df\u91d1",7,1021,"MO","1",1021,"2","2020-01-24 11:29:17","2","2020-01-24 11:29:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:29:19","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":["7368","RENT","\u9810\u7e73\u79df\u91d1",8,1021,"MO","1",1021,"2","2020-01-24 11:29:17","2","2020-01-24 11:29:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:29:19","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":["7368","RENT","\u9810\u7e73\u79df\u91d1",9,1021,"MO","1",1021,"2","2020-01-24 11:29:17","2","2020-01-24 11:29:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:29:19","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":["7368","RENT","\u9810\u7e73\u79df\u91d1",10,1021,"MO","1",1021,"2","2020-01-24 11:29:17","2","2020-01-24 11:29:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:29:19","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":["7368","RENT","\u9810\u7e73\u79df\u91d1",11,1021,"MO","1",1021,"2","2020-01-24 11:29:17","2","2020-01-24 11:29:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:29:19","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":["7368","RENT","\u9810\u7e73\u79df\u91d1",12,1021,"MO","1",1021,"2","2020-01-24 11:29:17","2","2020-01-24 11:29:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:29:19","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":["7368","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-01-24 11:29:17","2","2020-01-24 11:29:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:29:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[9760,0,"7368"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-24 11:29:19","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":[1497,"BANKIN","","","","BANKIN","","","","PAID","P207017","2020-01-24 11:29:17",12376,"2","2020-01-24 11:29:17","2","2020-01-24 11:29:17","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:29:19","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":["7017","DEPOSIT","5268","PAID","2020-01-24 11:29:17",2616,"2","2020-01-24 11:29:17","2","2020-01-24 11:29:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:29:19","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":["7017","INVOICE","7368","PAID","2020-01-24 11:29:17",9760,"2","2020-01-24 11:29:17","2","2020-01-24 11:29:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:31: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=144&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1508","master_room_id":"196","room_code":"A16-017"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":916,"customer_code":"C180916","identity_type":"PERSONAL","identity_id":"K589047(0)","title":"Ms","lastname":"Ku","firstname":"Yuk Ling","companyname":"","email":"ximiaku@gmail.com","tel":"95518824","address":"Flat A, 1\/F, Block 31, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2068.0","renew_rent_month":"12","renew_warehousing_date":"2020-02-03","renew_room_key":"0012449959","renew_remark":"6 months contract. Storage rental paid by EPS on January 29, 2019. Storage deposit $4,596 transferred from agreement A05-CT182806 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT194265, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"127","order_discount":[],"order_room":[{"room_id":"1055","room_code":"A05-053","retail_price":"2298.0","discounted_price":"2298.00","location_id":"4"}],"roughly_size":"30","total_retail_price":2298,"total_discounted_price":2068,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":24816,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2068.00","warehousing_date":"2020-02-03","rent_from":"2020-02-03","rent_to":"2021-03-02","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by PPS on January 22, 2020. Storage deposit $4,596 transferred from agreement A05-CT194265 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":2068,"order_total":26884,"final_order_total":24816,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012449959","order_product":[],"pass":true}},"first_order_id":4265,"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-053 <\/td>\r\n\t\t\t\t\t 6X5X7 <\/td>\r\n\t\t\t\t\t $2298.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":"30","total_discounted_price":"2068.00","deposit":"0.00","total_retail_price":"2298.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:31:50","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",916,"NEW","A05-CT207041",2298,2068,0,0,"13","13",24816,26884,24816,"2020-01-24 11:31:50","0",null,null,null,"2020-02-03","2021-03-02","13 months contract. Special offer the 13th month free. Storage rental paid by PPS on January 22, 2020. Storage deposit $4,596 transferred from agreement A05-CT194265 to this agreement.","2020-02-03","30",0,null,2068,"2068.00","2","2020-01-24 11:31:50","2","2020-01-24 11:31:50","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0012449959","C180916","PERSONAL","Ms","ZzRtsket6p7WIKEqrfiAQw==","dd8q3vwj4lgFhMoP+laJmA==","","zb+wEJU2BcjiqagYCnyRNcOv7\/plGg9i221q+x0OgI+6BWsQDSkzYT6Qjc72DuS2RjVntxXbtkOL31ZofM5U9Q==","qAZxmIOM3IgX2IKvuKjfuQ==","zJWr\/wk+FoRyb087SXnbf75z\/Zdgkc\/KDVF4FR6zu2s=","x2iFrDSU+rhfMqNf4OYNAQ==",null,1,4265]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:31:50","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":["7041","1055","2298.0","2298.00","2","2020-01-24 11:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:31:50","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","2021-03-02","1055"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-24 11:31:50","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":["7041",916,"SETTLED","A05-I207369","2020-01-24 11:31:50","2020-02-03","2","2020-01-24 11:31:50","2","2020-01-24 11:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:31:50","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":["7369","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,2068,"MO","1",2068,"2","2020-01-24 11:31:50","2","2020-01-24 11:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:31:50","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":["7369","RENT","\u9810\u7e73\u79df\u91d1",3,2068,"MO","1",2068,"2","2020-01-24 11:31:50","2","2020-01-24 11:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:31:50","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":["7369","RENT","\u9810\u7e73\u79df\u91d1",4,2068,"MO","1",2068,"2","2020-01-24 11:31:50","2","2020-01-24 11:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:31:50","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":["7369","RENT","\u9810\u7e73\u79df\u91d1",5,2068,"MO","1",2068,"2","2020-01-24 11:31:50","2","2020-01-24 11:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:31:50","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":["7369","RENT","\u9810\u7e73\u79df\u91d1",6,2068,"MO","1",2068,"2","2020-01-24 11:31:50","2","2020-01-24 11:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:31:50","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":["7369","RENT","\u9810\u7e73\u79df\u91d1",7,2068,"MO","1",2068,"2","2020-01-24 11:31:50","2","2020-01-24 11:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:31:50","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":["7369","RENT","\u9810\u7e73\u79df\u91d1",8,2068,"MO","1",2068,"2","2020-01-24 11:31:50","2","2020-01-24 11:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:31:50","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":["7369","RENT","\u9810\u7e73\u79df\u91d1",9,2068,"MO","1",2068,"2","2020-01-24 11:31:50","2","2020-01-24 11:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:31:50","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":["7369","RENT","\u9810\u7e73\u79df\u91d1",10,2068,"MO","1",2068,"2","2020-01-24 11:31:50","2","2020-01-24 11:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:31:50","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":["7369","RENT","\u9810\u7e73\u79df\u91d1",11,2068,"MO","1",2068,"2","2020-01-24 11:31:50","2","2020-01-24 11:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:31:50","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":["7369","RENT","\u9810\u7e73\u79df\u91d1",12,2068,"MO","1",2068,"2","2020-01-24 11:31:50","2","2020-01-24 11:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:31:50","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":["7369","RENT","\u9810\u7e73\u79df\u91d1",13,2068,"MO","1",2068,"2","2020-01-24 11:31:50","2","2020-01-24 11:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:31:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[24816,0,"7369"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-24 11:31:50","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":[916,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207018","2020-01-24 11:31:50",24816,"2","2020-01-24 11:31:50","2","2020-01-24 11:31:50","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:31:50","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":["7018","DEPOSIT",null,"PAID","2020-01-24 11:31:50",0,"2","2020-01-24 11:31:50","2","2020-01-24 11:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:31:50","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":["7018","INVOICE","7369","PAID","2020-01-24 11:31:50",24816,"2","2020-01-24 11:31:50","2","2020-01-24 11:31:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:43:00","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=144&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","floor_plan_rent_room":[{"room_id":"1508","master_room_id":"196","room_code":"A16-017"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":462,"customer_code":"C170462","identity_type":"PERSONAL","identity_id":"K360799(2)","title":"Mr","lastname":"Yu","firstname":"Wing Ho Peter","companyname":"","email":"vr2xbl@gmail.com","tel":"92533969","address":"FLT F, 19\/F ,BLK 1, 18 Tsui Wan Street","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1047.0","renew_rent_month":"3","renew_warehousing_date":"2020-01-22","renew_room_key":"053,37485, 191, 05433","renew_remark":"3 months contract. Storage rental paid by PPS on November 25, 2019. Storage deposit transferred from agreement A14-CT195674 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196539, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"67","order_discount":[],"order_room":[{"room_id":"423","room_code":"J05(\u670d\u88dd\u5009)","retail_price":"1118.0","discounted_price":"1118.00","location_id":"2"}],"roughly_size":"12","total_retail_price":1118,"total_discounted_price":1047,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3141,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-22","rent_from":"2020-01-22","rent_to":"2020-04-21","delivery_service":"0","remark":"3 months contract. Storage rental paid by PPS on January 23, 2020. Storage deposit transferred from agreement A14-CT196539 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":3141,"final_order_total":3141,"location_id":"2","branch_id":"1","company_id":"1","room_key":"053,37485, 191, 05433","order_product":[],"pass":true}},"first_order_id":"4340","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> J05(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $1118.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"1047.0","deposit":"0","total_retail_price":"1118.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:43:01","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",462,"NEW","A14-CT207042",1118,1047,0,0,"3","3",3141,3141,3141,"2020-01-24 11:43:01","0",null,null,null,"2020-01-22","2020-04-21","3 months contract. Storage rental paid by PPS on January 23, 2020. Storage deposit transferred from agreement A14-CT196539 to this agreement.","2020-01-22","12",0,null,0,"0","2","2020-01-24 11:43:00","2","2020-01-24 11:43:00","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"053,37485, 191, 05433","C170462","PERSONAL","Mr","BYjifWmIFNENpUI6KijenQ==","thtRZ5CDeQ9OOuodTdr1ng==","","qFxWg6ty8YLT5usnC5rQpcVGyK8fcSAy3kOPLYCQSTBkdbKDaAwWSCGhAyWML\/ob","wNgcXUnmZ0eJG8XwVZF25A==","Fj34QP5je0a2jhCIbIxvfq1qLloGSLgQk4pOCLZMes0=","NSx+wI1\/3ifu25UJRr13xg==",null,1,"4340"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:43:01","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":["7042","423","1118.0","1118.00","2","2020-01-24 11:43:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:43:01","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-22","2020-04-21","423"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-24 11:43:01","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":["7042",462,"SETTLED","A14-I207370","2020-01-24 11:43:00","2020-01-22","2","2020-01-24 11:43:00","2","2020-01-24 11:43:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:43:01","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":["7370","RENT","\u9810\u7e73\u79df\u91d1",1,1047,"MO","1",1047,"2","2020-01-24 11:43:00","2","2020-01-24 11:43:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:43:01","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":["7370","RENT","\u9810\u7e73\u79df\u91d1",2,1047,"MO","1",1047,"2","2020-01-24 11:43:00","2","2020-01-24 11:43:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:43:01","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":["7370","RENT","\u9810\u7e73\u79df\u91d1",3,1047,"MO","1",1047,"2","2020-01-24 11:43:00","2","2020-01-24 11:43:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:43:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3141,0,"7370"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-24 11:43:01","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":[462,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207019","2020-01-24 11:43:00",3141,"2","2020-01-24 11:43:00","2","2020-01-24 11:43:00","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:43:01","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":["7019","DEPOSIT",null,"PAID","2020-01-24 11:43:00",0,"2","2020-01-24 11:43:00","2","2020-01-24 11:43:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 11:43:01","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":["7019","INVOICE","7370","PAID","2020-01-24 11:43:00",3141,"2","2020-01-24 11:43:00","2","2020-01-24 11:43:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 12:06:14","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=144&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1508","master_room_id":"196","room_code":"A16-017"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":731,"customer_code":"C180731","identity_type":"PERSONAL","identity_id":"D253697(9)","title":"Mr","lastname":"Kwan","firstname":"Kwai Foon Anthony","companyname":"","email":null,"tel":"92195717","address":"Flat 1D, Tower 21, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"953.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-19","renew_room_key":"055,15172","renew_remark":"6 months contract. Storage rental paid by bank transfer on July 22, 2019. Storage deposit transferred from agreement A18-CT194214 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195527, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"101","order_discount":[{"master_room_discount_id":"242","master_room_id":"101","discount_type":"%","price":"1058.00","disocunted_price":"952.20","discount":"10.00","monthly_deduct":105.8,"room_id":"931","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"931","room_code":"V05(\u670d\u88dd\u5009)","retail_price":"1058.0","discounted_price":952.2,"location_id":"3"}],"roughly_size":"10","total_retail_price":1058,"total_discounted_price":953,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5718,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-19","rent_from":"2020-01-19","rent_to":"2020-07-18","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on January 24, 2020. Storage deposit transferred from agreement A18-CT195527 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5718,"final_order_total":5718,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,15172","order_product":[],"pass":true}},"first_order_id":"4214","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> V05(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X2.4X7 <\/td>\r\n\t\t\t\t\t $1058.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":"10","total_discounted_price":"953.0","deposit":"0","total_retail_price":"1058.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 12:06: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",731,"NEW","A18-CT207043",1058,953,0,0,"6","6",5718,5718,5718,"2020-01-24 12:06:15","0",null,null,null,"2020-01-19","2020-07-18","6 months contract. Storage rental paid by bank transfer on January 24, 2020. Storage deposit transferred from agreement A18-CT195527 to this agreement.","2020-01-19","10",0,null,0,"0","2","2020-01-24 12:06:14","2","2020-01-24 12:06:14","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,15172","C180731","PERSONAL","Mr","XEKuncTNLnWIEObxvB17UqG5cAGiVkSpLi71ikzyiJ4=","iNwdG3Dj3OBaAQ6MRfBM1w==","","ntXytXK6\/T+L0FeDbW8qSWUcYsJNyd4aTkp1LmCXPyCht1bCagmRSaAL+JAi9p0OyUeHSfdNwJN0yH4GE2jEBA==","cqfkLklaoLunE5diE3rkHQ==",null,"ovOFCa+w4n1tIBcVIj9JoA==",null,1,"4214"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 12:06:15","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":["7043","242","101","931","%","10.00",105.8,"2","2020-01-24 12:06:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 12:06: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":["7043","931","1058.0",952.2,"2","2020-01-24 12:06:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 12:06: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-01-19","2020-07-18","931"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-24 12:06: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":["7043",731,"SETTLED","A18-I207371","2020-01-24 12:06:14","2020-01-19","2","2020-01-24 12:06:14","2","2020-01-24 12:06:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 12:06: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":["7371","RENT","\u9810\u7e73\u79df\u91d1",1,953,"MO","1",953,"2","2020-01-24 12:06:14","2","2020-01-24 12:06:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 12:06: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":["7371","RENT","\u9810\u7e73\u79df\u91d1",2,953,"MO","1",953,"2","2020-01-24 12:06:14","2","2020-01-24 12:06:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 12:06: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":["7371","RENT","\u9810\u7e73\u79df\u91d1",3,953,"MO","1",953,"2","2020-01-24 12:06:14","2","2020-01-24 12:06:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 12:06: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":["7371","RENT","\u9810\u7e73\u79df\u91d1",4,953,"MO","1",953,"2","2020-01-24 12:06:14","2","2020-01-24 12:06:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 12:06: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":["7371","RENT","\u9810\u7e73\u79df\u91d1",5,953,"MO","1",953,"2","2020-01-24 12:06:14","2","2020-01-24 12:06:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 12:06: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":["7371","RENT","\u9810\u7e73\u79df\u91d1",6,953,"MO","1",953,"2","2020-01-24 12:06:14","2","2020-01-24 12:06:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 12:06:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5718,0,"7371"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-24 12:06: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":[731,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207020","2020-01-24 12:06:14",5718,"2","2020-01-24 12:06:14","2","2020-01-24 12:06:14","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 12:06: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":["7020","DEPOSIT",null,"PAID","2020-01-24 12:06:14",0,"2","2020-01-24 12:06:14","2","2020-01-24 12:06:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 12:06: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":["7020","INVOICE","7371","PAID","2020-01-24 12:06:14",5718,"2","2020-01-24 12:06:14","2","2020-01-24 12:06:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 13:57:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:14:25","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=423&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":423,"customer_code":"C170423","identity_type":"PERSONAL","identity_id":"E417712(A)","title":"Mrs","lastname":"Kwok Shiu","firstname":"Siu Lay Shirley","companyname":"","email":"se-kwok@hotmail.com","tel":"91904490","address":"18B, 52 Mount Davis Rd ,Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4499.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-10","renew_room_key":"055,32590","renew_remark":"1 month contract. Storage rental paid by bank transfer on November 10, 2019. Storage deposit transferred from agreement A14-CT196749 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT206833, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"44","order_discount":[],"order_room":[{"room_id":"522","room_code":"K59","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"521","room_code":"K58","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"520","room_code":"K57","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"519","room_code":"K56","retail_price":"1768.0","discounted_price":"1768.00","location_id":"2"}],"roughly_size":"72","total_retail_price":5062,"total_discounted_price":4499,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":4499,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-10","rent_from":"2020-01-10","rent_to":"2020-02-09","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 9, 2020. Storage deposit transferred from agreement A14-CT206833 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4499,"final_order_total":4499,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,32590","order_product":[],"pass":true}},"first_order_id":"4832","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> K59 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> K58 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> K57 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> K56 <\/td>\r\n\t\t\t\t\t 4X6X8 <\/td>\r\n\t\t\t\t\t $1768.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":"72","total_discounted_price":"4499.0","deposit":"0","total_retail_price":"5062.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:14:26","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",423,"NEW","A14-CT207044",5062,4499,0,0,"1","1",4499,4499,4499,"2020-01-24 15:14:26","0",null,null,null,"2020-01-10","2020-02-09","1 month contract. Storage rental paid by bank transfer on January 9, 2020. Storage deposit transferred from agreement A14-CT206833 to this agreement.","2020-01-10","72",0,null,0,"0","2","2020-01-24 15:14:25","2","2020-01-24 15:14:25","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,32590","C170423","PERSONAL","Mrs","+cSauOfzf4UKH6i9E\/o3Ow==","9BE1lGM5+6cl7FB3cBYT\/Q==","","QuHHgcx1ghORfe6aPTL+cwHs9gJpW87+Y84Si6oTDbtaPpyzLd7Q86Xo4RoVzL1i","uWe4YUxvL5KuigFTIBklFw==","CBE2gpTh\/+LjBRyyCUBxTx7oEtKfkCZ0NTTPgR4mc0Q=","I\/c6FTBu+Cf57wsquAGAzA==",null,1,"4832"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:14:26","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":["7044","522","1098.0","1098.00","2","2020-01-24 15:14:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:14:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-10","2020-02-09","522"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-24 15:14:26","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":["7044","521","1098.0","1098.00","2","2020-01-24 15:14:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:14:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-10","2020-02-09","521"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-24 15:14:26","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":["7044","520","1098.0","1098.00","2","2020-01-24 15:14:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:14:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-10","2020-02-09","520"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-24 15:14:26","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":["7044","519","1768.0","1768.00","2","2020-01-24 15:14:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:14:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-10","2020-02-09","519"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-24 15:14:26","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":["7044",423,"SETTLED","A14-I207372","2020-01-24 15:14:25","2020-01-10","2","2020-01-24 15:14:25","2","2020-01-24 15:14:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:14:26","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":["7372","RENT","\u9810\u7e73\u79df\u91d1",1,4499,"MO","1",4499,"2","2020-01-24 15:14:25","2","2020-01-24 15:14:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:14:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4499,0,"7372"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-24 15:14:26","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":[423,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207021","2020-01-24 15:14:25",4499,"2","2020-01-24 15:14:25","2","2020-01-24 15:14:25","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:14:26","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":["7021","DEPOSIT",null,"PAID","2020-01-24 15:14:25",0,"2","2020-01-24 15:14:25","2","2020-01-24 15:14:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:14:26","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":["7021","INVOICE","7372","PAID","2020-01-24 15:14:25",4499,"2","2020-01-24 15:14:25","2","2020-01-24 15:14:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:22:25","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":"all=1","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":469,"customer_code":"C170469","identity_type":"PERSONAL","identity_id":"E562535(5)","title":"Mr","lastname":"Poon ","firstname":"Yin Ming","companyname":"","email":null,"tel":"67039272","address":"Rm1403,14\/F,Ming Cheun House,Shui Chuen O Estate,Sha Tin","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":"2019-12-24","renew_room_key":"133,33462","renew_remark":"1 month contract. Storage rental paid by bank transfer on Dec 06, 2019. Storage deposit transferred from agreement A14-CT196337 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196624, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"625","room_code":"M36","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":"2019-12-24","rent_from":"2019-12-24","rent_to":"2020-01-23","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 7, 2020. Storage deposit transferred from agreement A14-CT196624 to this agreement.","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":"133,33462","order_product":[],"pass":true}},"first_order_id":"4725","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> M36 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:22:26","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",469,"NEW","A14-CT207045",598,598,0,0,"1","1",598,598,598,"2020-01-24 15:22:26","0",null,null,null,"2019-12-24","2020-01-23","1 month contract. Storage rental paid by bank transfer on January 7, 2020. Storage deposit transferred from agreement A14-CT196624 to this agreement.","2019-12-24","12",0,null,0,"0","2","2020-01-24 15:22:25","2","2020-01-24 15:22:25","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"133,33462","C170469","PERSONAL","Mr","7zuhiU2fzaatGP2D2mnAJA==","c9CkZ4cZzKCidNu3YYjrkw==","","QJ5AY46e6jExLz0oVTYEajr8ICB272rxLBtUMHgM2LeYYJatyO4QCPJb6GJOXbbZ2qJarCJxAoCZti1Uif3gKw==","2+3VDW\/cQQxeWAv\/Fi3w0Q==",null,"So0zSsBwxE4\/4T3R4c76WA==",null,1,"4725"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:22:26","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":["7045","625","598.0","598.00","2","2020-01-24 15:22:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:22:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-24","2020-01-23","625"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-24 15:22:26","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":["7045",469,"SETTLED","A14-I207373","2020-01-24 15:22:25","2019-12-24","2","2020-01-24 15:22:25","2","2020-01-24 15:22:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:22:26","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":["7373","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-01-24 15:22:25","2","2020-01-24 15:22:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:22:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7373"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-24 15:22:26","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":[469,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207022","2020-01-24 15:22:25",598,"2","2020-01-24 15:22:25","2","2020-01-24 15:22:25","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:22:26","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":["7022","DEPOSIT",null,"PAID","2020-01-24 15:22:25",0,"2","2020-01-24 15:22:25","2","2020-01-24 15:22:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:22:26","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":["7022","INVOICE","7373","PAID","2020-01-24 15:22:25",598,"2","2020-01-24 15:22:25","2","2020-01-24 15:22:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:37:17","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":"all=1&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":826,"customer_code":"C180826","identity_type":"PERSONAL","identity_id":"V120085(2)","title":"Ms","lastname":"Wong","firstname":"Lai Wing","companyname":"","email":"aslinnlaiwing@gmail.com","tel":"60823501","address":"Flat B, 23\/F, Yee Wan Court, South Horizons, 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":"2019-12-21","renew_room_key":"052,37309","renew_remark":"1 month contract. Storage rental paid by bank transfer on November 25, 2019. Storage deposit transferred from agreement A12-CT196221 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196507, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"1","order_discount":[],"order_room":[{"room_id":"207","room_code":"D11","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"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":"2019-12-21","rent_from":"2019-12-21","rent_to":"2020-01-20","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on December 23, 2019. Storage deposit transferred from agreement A12-CT196507 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"1","branch_id":"1","company_id":"1","room_key":"052,37309","order_product":[],"pass":true}},"first_order_id":"4840","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> D11 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:37:17","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",826,"NEW","A12-CT207046",598,598,0,0,"1","1",598,598,598,"2020-01-24 15:37:17","0",null,null,null,"2019-12-21","2020-01-20","1 month contract. Storage rental paid by bank transfer on December 23, 2019. Storage deposit transferred from agreement A12-CT196507 to this agreement.","2019-12-21","12",0,null,0,"0","2","2020-01-24 15:37:17","2","2020-01-24 15:37:17","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,37309","C180826","PERSONAL","Ms","AVQEhVbkdf0QwgZhPqTuvQ==","hULSwM2MvFtpeV9\/z+er8Q==","","VYTecHlXsAq2HU\/SK2vg0HE0ESjbB0AIG1TtdkNrHvzSOFADaqlQfFPEOwNTSSdXg5YSZtYVVGLVGFZuRQfF9AxsFxu92jPjM0q+fUqGSyI=","M\/mMkpABptC23N0qOMtMOA==","I+DcTUTCSlvqwNtqcfOhWkdyXo7XLnfkUFX2VHxYh3c=","d\/8HRqfi7sBcCF03ucfekg==",null,1,"4840"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:37:17","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":["7046","207","598.0","598.00","2","2020-01-24 15:37:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:37:17","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-21","2020-01-20","207"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-24 15:37:17","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":["7046",826,"SETTLED","A12-I207374","2020-01-24 15:37:17","2019-12-21","2","2020-01-24 15:37:17","2","2020-01-24 15:37:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:37:17","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":["7374","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-01-24 15:37:17","2","2020-01-24 15:37:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:37:17","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7374"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-24 15:37:17","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":[826,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207023","2020-01-24 15:37:17",598,"2","2020-01-24 15:37:17","2","2020-01-24 15:37:17","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:37:17","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":["7023","DEPOSIT",null,"PAID","2020-01-24 15:37:17",0,"2","2020-01-24 15:37:17","2","2020-01-24 15:37:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:37:17","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":["7023","INVOICE","7374","PAID","2020-01-24 15:37:17",598,"2","2020-01-24 15:37:17","2","2020-01-24 15:37:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:53:47","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":"all=1&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1427","master_room_id":"173","room_code":"C15-121"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-121 <\/td>\r\n\t\t\t\t\t 4X6X6.5 <\/td>\r\n\t\t\t\t\t $1322.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"BUSINESS","identity_id":"63953971-000-10-17-6","title":"Ms","lastname":"Yau ","firstname":"Yuk Yan","companyname":"Alive Yoga Alliance Ltd","email":"amyyoga@ymail.com","tel":"92530001","address":"Flat C & D, 1\/F Fook Ying Building, 379-381 King\u2019s Rd, North Point, H.K","pass":true,"customer_id":"1101","customer_code":"C181101","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"419","master_room_id":"173","discount_type":"%","price":"1322.00","disocunted_price":"1255.90","discount":"5.00","monthly_deduct":66.1,"room_id":"1427","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1427","room_code":"C15-121","retail_price":"1322.0","discounted_price":1255.9,"location_id":"6"}],"roughly_size":"24","total_retail_price":1322,"total_discounted_price":1256,"deposit":1322,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":5090,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-24","rent_from":"2020-01-24","rent_to":"2020-04-23","delivery_service":"0","remark":"3 months contract. Storage rental and deposit $5090 paid by bank transfer on January 24, 2020. Transportation fee $1400 paid by January 24, 2020. ","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5090,"final_order_total":5090,"location_id":"6","branch_id":"3","company_id":"1","room_key":"\u20180012415083","order_product":[],"pass":true}},"roughly_size":"24","total_discounted_price":"1256.00","deposit":"1322.00","total_retail_price":"1322.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:53:48","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","1101","NEW","C15-CT207047",1322,1256,1322,0,"3","3",5090,5090,5090,"2020-01-24 15:53:48","0",null,null,null,"2020-01-24","2020-04-23","3 months contract. Storage rental and deposit $5090 paid by bank transfer on January 24, 2020. Transportation fee $1400 paid by January 24, 2020. ","2020-01-24","24",0,null,0,"0","2","2020-01-24 15:53:47","2","2020-01-24 15:53:47","BANKIN","","","","BANKIN","","","",null,0,"\u20180012415083","C181101","BUSINESS","Ms","RlKt34vcZvRZ1B47nY\/fgQ==","eg6mnYsOn64SOpH7hwzmzw==","Alive Yoga Alliance Ltd","J4gN8qCnHYBqifDoM\/w3B4pMnK9R3SOmOekdx0aWx8wFimkFSq\/ovz+SLDRz0JHP0zuDSTMzbkaxg9fQx26Whny0nYhF6eJVpEH5UtgLSVs=","tjARpijmRPN33ts7XMesgw==","26iudEKydkbSBd6ePqD2yTnY4IH4Yvw\/VHV7dVhQ8Rw=",null,"4sVsRnjmji+akrTf224OtJHLnqERjelObNdOANDjidM="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:53:48","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":["7047","419","173","1427","%","5.00",66.1,"2","2020-01-24 15:53:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:53:48","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":["7047","1427","1322.0",1255.9,"2","2020-01-24 15:53:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:53:48","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-24","2020-04-23","1427"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-24 15:53:48","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":["7047","C15-D205269","PAID",1322,0,"2020-04-23","2020-01-24 15:53:47","2020-01-24 15:53:47","2","2020-01-24 15:53:47","2","2020-01-24 15:53:47","1101"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:53:48","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":["7047","1101","SETTLED","C15-I207375","2020-01-24 15:53:47","2020-01-24","2","2020-01-24 15:53:47","2","2020-01-24 15:53:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:53:48","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":["7375","RENT","\u9810\u7e73\u79df\u91d1",1,1256,"MO","1",1256,"2","2020-01-24 15:53:47","2","2020-01-24 15:53:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:53:48","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":["7375","RENT","\u9810\u7e73\u79df\u91d1",2,1256,"MO","1",1256,"2","2020-01-24 15:53:47","2","2020-01-24 15:53:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:53:48","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":["7375","RENT","\u9810\u7e73\u79df\u91d1",3,1256,"MO","1",1256,"2","2020-01-24 15:53:47","2","2020-01-24 15:53:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:53:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3768,0,"7375"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-24 15:53:48","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":["1101","BANKIN","","","","BANKIN","","","","PAID","P207024","2020-01-24 15:53:47",5090,"2","2020-01-24 15:53:47","2","2020-01-24 15:53:47","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:53:48","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":["7024","DEPOSIT","5269","PAID","2020-01-24 15:53:47",1322,"2","2020-01-24 15:53:47","2","2020-01-24 15:53:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 15:53:48","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":["7024","INVOICE","7375","PAID","2020-01-24 15:53:47",3768,"2","2020-01-24 15:53:47","2","2020-01-24 15:53:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 16:33:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 16:34:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 16:57:11","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 16:59:06","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","floor_plan_rent_room":[{"room_id":"198","master_room_id":"1","room_code":"D02"}],"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> D02 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"Z813062(1)","title":"Ms","lastname":"TSUI","firstname":"Wai Ting","companyname":"","email":"leila.tsui@yahoo.com.hk","tel":"92829889","address":"RM 103 Pick Shan House,Shek Pai Wan Estate H.K.","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"198","room_code":"D02","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":1196,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1794,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-15","rent_from":"2020-01-15","rent_to":"2020-02-14","delivery_service":"0","remark":"1 month contract. Storage rental and deposit paid by bank transfer on January 15,2020. ","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1794,"final_order_total":1794,"location_id":"1","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"598.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 16:59:07","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":["C201498","PERSONAL","Ms","JgAavgpIkIT+QrZDjc3BRA==","4zek2V6v+muRHEsNI7xEHw==","","kQeKRVYsl351hB8tSJajyg==","qkxnp5SHRu4Kc3Kv53ZfIb6\/ziTIdZr0R53qKZFrHLM=","PMn1p0oadyJx29V1OPiOSN\/BYn2sl3wPiJ9DdvSe3jCo8xHWlf6yiVjMvn60tn+k","JwsF7JQXZLJyMrrbcjBmIQ==",null,"qkxnp5SHRu4Kc3Kv53ZfIb6\/ziTIdZr0R53qKZFrHLM=","6OaIUBzxwDANj12G4OoMhw==","2","2020-01-24 16:59:06","2","2020-01-24 16:59:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 16:59: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` = ?","parameters":["1","1","1",1498,"NEW","A12-CT207048",598,598,1196,0,"1","1",1794,1794,1794,"2020-01-24 16:59:08","0",null,null,null,"2020-01-15","2020-02-14","1 month contract. Storage rental and deposit paid by bank transfer on January 15,2020. ","2020-01-15","12",0,null,0,"0","2","2020-01-24 16:59:06","2","2020-01-24 16:59:06","BANKIN","","","","BANKIN","","","",null,0,"","C201498","PERSONAL","Ms","JgAavgpIkIT+QrZDjc3BRA==","4zek2V6v+muRHEsNI7xEHw==","","PMn1p0oadyJx29V1OPiOSN\/BYn2sl3wPiJ9DdvSe3jCo8xHWlf6yiVjMvn60tn+k","kQeKRVYsl351hB8tSJajyg==","qkxnp5SHRu4Kc3Kv53ZfIb6\/ziTIdZr0R53qKZFrHLM=","JwsF7JQXZLJyMrrbcjBmIQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 16:59: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":["7048","198","598.0","598.00","2","2020-01-24 16:59:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 16:59: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-01-15","2020-02-14","198"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-24 16:59:08","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":["7048","A12-D205270","PAID",1196,0,"2020-02-14","2020-01-24 16:59:06","2020-01-24 16:59:06","2","2020-01-24 16:59:06","2","2020-01-24 16:59:06",1498]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 16:59: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":["7048",1498,"SETTLED","A12-I207376","2020-01-24 16:59:06","2020-01-15","2","2020-01-24 16:59:06","2","2020-01-24 16:59:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 16:59: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":["7376","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-01-24 16:59:06","2","2020-01-24 16:59:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 16:59:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7376"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-24 16:59: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":[1498,"BANKIN","","","","BANKIN","","","","PAID","P207025","2020-01-24 16:59:06",1794,"2","2020-01-24 16:59:06","2","2020-01-24 16:59:06","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 16:59: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":["7025","DEPOSIT","5270","PAID","2020-01-24 16:59:06",1196,"2","2020-01-24 16:59:06","2","2020-01-24 16:59:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 16:59: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":["7025","INVOICE","7376","PAID","2020-01-24 16:59:06",598,"2","2020-01-24 16:59:06","2","2020-01-24 16:59:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-24 16:59:30","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","","1 month contract. Storage rental and deposit paid by bank transfer on January 15,2020. ","2020-01-24 16:59:30","2","4zek2V6v+muRHEsNI7xEHw==","JgAavgpIkIT+QrZDjc3BRA==","qkxnp5SHRu4Kc3Kv53ZfIb6\/ziTIdZr0R53qKZFrHLM=","kQeKRVYsl351hB8tSJajyg==","tYmwtE+9cBTFsiyOy7glylbs2PO\/ZJ0mF0kQwzOpXUIeOXoxcGpojpNxlmnZ8QLULsVT9UTHR\/4I1gE4Y+0Hkg==",7048]},"data_before":[],"data_after":[],"step":1} *****