\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>
N10 <\/td>\n\t\t\t\t\t	4X3X4 <\/td>\n\t\t\t\t\t	$598.00 <\/td>\n\t\t\t\t	- <\/td>	<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"12","total_discounted_price":"568.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 14:50:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2","791","NEW","A14-CT207296",598,568,0,0,"3","3",1704,1704,1704,"2020-03-02 14:50:21","0",null,null,null,"2020-03-16","2020-06-15","3 months contract. Storage rental paid by cash on Mar 02,2020. Storage deposit transferred from agreement A14-CT196657 to this agreement.","2020-03-16","12",0,null,0,"0","2","2020-03-02 14:50:21","2","2020-03-02 14:50:21","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"054,58848","C180791","PERSONAL","Mr","P+qxskvHUH4OJZ9H+Ork5g==","7KCehmxbvwRMb+U8lHGoVA==","","ma1BnXBxZAlZQ9n1jQ9gebwnAjgMDmdVLZtKi7a5mNC+mVcA3v9KGitvyZNrikYWIXcX6RVj3AwrtSLhFBSFHojwYg1dHJfhMm7Y8JuSohQ=","T7\/3p2HqBeXmQgImq4qEyA==",null,"adoNyfYYHqGuBZUsS3PDOQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 14:50:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7296","693","598.0","598.00","2","2020-03-02 14:50:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 14:50:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-16","2020-06-15","693"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-02 14:50:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7296","791","SETTLED","A14-I207624","2020-03-02 14:50:21","2020-03-16","2","2020-03-02 14:50:21","2","2020-03-02 14:50:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 14:50:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7624","RENT","\u9810\u7e73\u79df\u91d1",1,568,"MO","1",568,"2","2020-03-02 14:50:21","2","2020-03-02 14:50:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 14:50:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7624","RENT","\u9810\u7e73\u79df\u91d1",2,568,"MO","1",568,"2","2020-03-02 14:50:21","2","2020-03-02 14:50:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 14:50:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7624","RENT","\u9810\u7e73\u79df\u91d1",3,568,"MO","1",568,"2","2020-03-02 14:50:21","2","2020-03-02 14:50:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 14:50:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1704,0,"7624"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-02 14:50:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["791","NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207272","2020-03-02 14:50:21",1704,"2","2020-03-02 14:50:21","2","2020-03-02 14:50:21","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 14:50:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7272","DEPOSIT",null,"PAID","2020-03-02 14:50:21",0,"2","2020-03-02 14:50:21","2","2020-03-02 14:50:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 14:50:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7272","INVOICE","7624","PAID","2020-03-02 14:50:21",1704,"2","2020-03-02 14:50:21","2","2020-03-02 14:50:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 15:00:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 15:14:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 15:56:23","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","floor_plan_rent_room":[],"index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","warehousing":{"1":{"new_customer":"1","identity_type":"BUSINESS","identity_id":"33028823","title":"Ms","lastname":"Abby","firstname":"LAW","companyname":"C.H.T Management Company","email":"","tel":"53968179","address":"Flat 8, Amtel Building, 144-148 Des Voeux Road, Central, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"470 available_room_list_input","master_room_id":"34","discount_type":"%","price":"998.00","disocunted_price":"949.00","discount":"4.91","monthly_deduct":49.0018,"room_id":"730","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"730","room_code":"O06","retail_price":"998.0","discounted_price":949,"location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":949,"deposit":1996,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":4343,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"500.00","warehousing_date":"2020-03-03","rent_from":"2020-03-03","rent_to":"2020-06-02","delivery_service":"0","remark":"3 months contract. Special offer $500 coupon. Storage renal and deposit paid by EPS on Mar 02,2020. Smartcard provided.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":500,"order_total":4843,"final_order_total":4343,"location_id":"2","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"selected_room_tr":"\n	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n	\n \n\n \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> O06 <\/td>\n\t\t\t\t\t 4X3X8 <\/td>\n\t\t\t\t\t $998.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed83\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":"12","total_discounted_price":"949.00","deposit":"1996.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 15:56:24","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":["C201528","BUSINESS","Ms","enGRI1kYXjmIiGhoi15EYA==","I9rJvJnbeL\/1+Tk\/WxcrnA==","C.H.T Management Company","YvmocSfkNkGJRm\/m6Wew0w==",null,"nbJqJcwDJqlQ461OyaN08jZidjA+vVWpHgngNLdPWpS3eq4G1ZMdV\/ke\/SdGfr6BsXSKnYUq4bDthdF\/B65Eug==",null,"Y1VYctiB5heTr7RUjnWj8w==",null,"i4W9g\/lxePxyA\/ntcNo4Xw==","2","2020-03-02 15:56:23","2","2020-03-02 15:56:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 15:56:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2",1528,"NEW","A14-CT207297",998,949,1996,0,"3","3",4343,4843,4343,"2020-03-02 15:56:25","0",null,null,null,"2020-03-03","2020-06-02","3 months contract. Special offer $500 coupon. Storage renal and deposit paid by EPS on Mar 02,2020. Smartcard provided.","2020-03-03","12",0,null,500,"500.00","2","2020-03-02 15:56:23","2","2020-03-02 15:56:23","EPS","","","","EPS","","","",null,0,"","C201528","BUSINESS","Ms","enGRI1kYXjmIiGhoi15EYA==","I9rJvJnbeL\/1+Tk\/WxcrnA==","C.H.T Management Company","nbJqJcwDJqlQ461OyaN08jZidjA+vVWpHgngNLdPWpS3eq4G1ZMdV\/ke\/SdGfr6BsXSKnYUq4bDthdF\/B65Eug==","YvmocSfkNkGJRm\/m6Wew0w==",null,null,"Y1VYctiB5heTr7RUjnWj8w=="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 15:56:25","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":["7297","470 available_room_list_input","34","730","%","4.91",49.0018,"2","2020-03-02 15:56:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 15:56:25","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":["7297","730","998.0",949,"2","2020-03-02 15:56:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 15:56:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-03","2020-06-02","730"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-02 15:56:25","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":["7297","A14-D205310","PAID",1996,0,"2020-06-02","2020-03-02 15:56:23","2020-03-02 15:56:23","2","2020-03-02 15:56:23","2","2020-03-02 15:56:23",1528]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 15:56:25","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":["7297",1528,"SETTLED","A14-I207625","2020-03-02 15:56:23","2020-03-03","2","2020-03-02 15:56:23","2","2020-03-02 15:56:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 15:56:25","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":["7625","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,449,"MO","1",449,"2","2020-03-02 15:56:23","2","2020-03-02 15:56:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 15:56:25","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":["7625","RENT","\u9810\u7e73\u79df\u91d1",2,949,"MO","1",949,"2","2020-03-02 15:56:23","2","2020-03-02 15:56:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 15:56:25","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":["7625","RENT","\u9810\u7e73\u79df\u91d1",3,949,"MO","1",949,"2","2020-03-02 15:56:23","2","2020-03-02 15:56:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 15:56:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2347,0,"7625"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-02 15:56:25","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":[1528,"EPS","","","","EPS","","","","PAID","P207273","2020-03-02 15:56:23",4343,"2","2020-03-02 15:56:23","2","2020-03-02 15:56:23","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 15:56:25","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":["7273","DEPOSIT","5310","PAID","2020-03-02 15:56:23",1996,"2","2020-03-02 15:56:23","2","2020-03-02 15:56:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 15:56:25","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":["7273","INVOICE","7625","PAID","2020-03-02 15:56:23",2347,"2","2020-03-02 15:56:23","2","2020-03-02 15:56:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 16:17:04","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=1485&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1503,"customer_code":"C201503","identity_type":"PERSONAL","identity_id":"M427706(1)","title":"Mr","lastname":"CHESTER","firstname":"Andrew","companyname":"","email":"pesterchestor@hotmail.com","tel":"90942135","address":"BishopLei International, 4 Robinson Road, Mid-Level, Hong Kong","pass":true},"2":{"renew_paymethod2":"CREDIT_CARD","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-04","renew_room_key":"0012462724","renew_remark":"1 month contract. Storage rental and deposit paid by Visa on February 4, 2020. Smartcard and padlock provided on February 4, 2020. $54 Visa additional fee.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT207109, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1196.0","renew_master_room_id":"110","order_discount":[],"order_room":[{"room_id":"1088","room_code":"A05-086","retail_price":"598.0","discounted_price":"598.00","location_id":"4"}],"roughly_size":"8","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-04","rent_from":"2020-03-04","rent_to":"2020-04-03","delivery_service":"0","remark":"1 month contract. Storage rental paid by cash on Match 2, 2020. Storage deposit $1196 transferred from agreement A05-CT207109 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012462724","order_product":[],"pass":true}},"first_order_id":7109,"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-086 <\/td>\r\n\t\t\t\t\t 4X2X3.5 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"8","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 16:17:04","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",1503,"NEW","A05-CT207298",598,598,0,0,"1","1",598,598,598,"2020-03-02 16:17:04","0",null,null,null,"2020-03-04","2020-04-03","1 month contract. Storage rental paid by cash on Match 2, 2020. Storage deposit $1196 transferred from agreement A05-CT207109 to this agreement.\r\n","2020-03-04","8",0,null,0,"0","2","2020-03-02 16:17:04","2","2020-03-02 16:17:04","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012462724","C201503","PERSONAL","Mr","2FxALZl389hi2eIQ+u33ig==","BT4zDXNaxIuFMxsBZh9eFw==","","o3omKroPlI3S4mwPuKGWRtI1LxiSqi7Bj6U1bq5vV4gng3SWdbWBN8eTOBvMCnT+VIr46pMlTrVRWylgO3130Q==","0WZ1OLwKgm6LsW4Cii\/cPg==","VF5nqgbgWsnjRzNN8wKg+LC3+J1g64a3n+\/rh0Eu+Kk=","iHLkhzrqTwdz65g+nqADVg==",null,1,7109]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 16:17:04","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":["7298","1088","598.0","598.00","2","2020-03-02 16:17:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 16:17:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-04","2020-04-03","1088"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-02 16:17:04","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":["7298",1503,"SETTLED","A05-I207626","2020-03-02 16:17:04","2020-03-04","2","2020-03-02 16:17:04","2","2020-03-02 16:17:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 16:17:04","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":["7626","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-03-02 16:17:04","2","2020-03-02 16:17:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 16:17:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7626"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-02 16:17:04","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":[1503,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207274","2020-03-02 16:17:04",598,"2","2020-03-02 16:17:04","2","2020-03-02 16:17:04","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 16:17:04","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":["7274","DEPOSIT",null,"PAID","2020-03-02 16:17:04",0,"2","2020-03-02 16:17:04","2","2020-03-02 16:17:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 16:17:04","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":["7274","INVOICE","7626","PAID","2020-03-02 16:17:04",598,"2","2020-03-02 16:17:04","2","2020-03-02 16:17:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 16:21:41","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1503&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1503,"customer_code":"C201503","identity_type":"PERSONAL","identity_id":"M427706(1)","title":"Mr","lastname":"CHESTER","firstname":"Andrew","companyname":"","email":"pesterchestor@hotmail.com","tel":"90942135","address":"BishopLei International, 4 Robinson Road, Mid-Level, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-04","renew_room_key":"0012462724","renew_remark":"1 month contract. Storage rental paid by cash on Match 2, 2020. Storage deposit $1196 transferred from agreement A05-CT207109 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT207298, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"110","order_discount":[],"order_room":[{"room_id":"1088","room_code":"A05-086","retail_price":"598.0","discounted_price":"598.00","location_id":"4"}],"roughly_size":"8","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-04","rent_from":"2020-04-04","rent_to":"2020-05-03","delivery_service":"0","remark":"1 month contract. Storage rental paid by visa on Match 2, 2020. Storage deposit $1196 transferred from agreement A05-CT207298 to this agreement. \r\n$36 additional charge.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CREDIT_CARD","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012462724","order_product":[],"pass":true}},"first_order_id":"7109","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-086 <\/td>\r\n\t\t\t\t\t 4X2X3.5 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"8","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 16:21:42","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",1503,"NEW","A05-CT207299",598,598,0,0,"1","1",598,598,598,"2020-03-02 16:21:42","0",null,null,null,"2020-04-04","2020-05-03","1 month contract. Storage rental paid by visa on Match 2, 2020. Storage deposit $1196 transferred from agreement A05-CT207298 to this agreement. \r\n$36 additional charge.\r\n","2020-04-04","8",0,null,0,"0","2","2020-03-02 16:21:41","2","2020-03-02 16:21:41","NO_NEED_PAID_RENEW","","","","CREDIT_CARD","","","",null,0,"0012462724","C201503","PERSONAL","Mr","2FxALZl389hi2eIQ+u33ig==","BT4zDXNaxIuFMxsBZh9eFw==","","o3omKroPlI3S4mwPuKGWRtI1LxiSqi7Bj6U1bq5vV4gng3SWdbWBN8eTOBvMCnT+VIr46pMlTrVRWylgO3130Q==","0WZ1OLwKgm6LsW4Cii\/cPg==","VF5nqgbgWsnjRzNN8wKg+LC3+J1g64a3n+\/rh0Eu+Kk=","iHLkhzrqTwdz65g+nqADVg==",null,1,"7109"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 16:21:42","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":["7299","1088","598.0","598.00","2","2020-03-02 16:21:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 16:21:42","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-04-04","2020-05-03","1088"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-02 16:21:42","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":["7299",1503,"SETTLED","A05-I207627","2020-03-02 16:21:41","2020-04-04","2","2020-03-02 16:21:41","2","2020-03-02 16:21:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 16:21:42","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":["7627","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-03-02 16:21:41","2","2020-03-02 16:21:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 16:21:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7627"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-02 16:21:42","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":[1503,"NO_NEED_PAID_RENEW","","","","CREDIT_CARD","","","","PAID","P207275","2020-03-02 16:21:41",598,"2","2020-03-02 16:21:41","2","2020-03-02 16:21:41","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 16:21:42","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":["7275","DEPOSIT",null,"PAID","2020-03-02 16:21:41",0,"2","2020-03-02 16:21:41","2","2020-03-02 16:21:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 16:21:42","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":["7275","INVOICE","7627","PAID","2020-03-02 16:21:41",598,"2","2020-03-02 16:21:41","2","2020-03-02 16:21:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 17:26:30","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=1485&filter3=undefined&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":508,"customer_code":"C170508","identity_type":"BUSINESS","identity_id":"Z099488(0)","title":"Ms","lastname":"Wong","firstname":"Mei Yuk ","companyname":"\u6d77\u73cd\u6d77\u9bae\u6709\u9650\u516c\u53f8","email":"yakyuk662003@yahoo.com.hk","tel":"62512313","address":"\u9999\u6e2f\u4ed4\u77f3\u6392\u7063\u9053102\u865f\u6d3b\u9053\u6279\u767c\u5e02\u5834B1\u865f\u92ea","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"935.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-13","renew_room_key":"055,16294","renew_remark":"6 months contract. storage rental paid by EPS on July 13, 2019. Storage deposit transferred from agreement A12-CT194109 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195465, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"130","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"130","room_code":"C06","retail_price":"1098.0","discounted_price":989,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":935,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5610,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-13","rent_from":"2020-01-13","rent_to":"2020-07-12","delivery_service":"0","remark":"6 months contract. storage rental paid by bank transfer on February 27, 2020. Storage deposit transferred from agreement A12-CT195465 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5610,"final_order_total":5610,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,16294","order_product":[],"pass":true}},"first_order_id":"4109","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> C06 <\/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\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"935.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 17:26:30","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",508,"NEW","A12-CT207300",1098,935,0,0,"6","6",5610,5610,5610,"2020-03-02 17:26:30","0",null,null,null,"2020-01-13","2020-07-12","6 months contract. storage rental paid by bank transfer on February 27, 2020. Storage deposit transferred from agreement A12-CT195465 to this agreement.","2020-01-13","16",0,null,0,"0","2","2020-03-02 17:26:30","2","2020-03-02 17:26:30","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,16294","C170508","BUSINESS","Ms","oprQp5GqNXkl6wi8ck36nA==","hULSwM2MvFtpeV9\/z+er8Q==","\u6d77\u73cd\u6d77\u9bae\u6709\u9650\u516c\u53f8","HjzS06sq40u00Mll+UK8ZH8+YyddAvuw9OT5pX3L6\/djlGuhqocfWGLXoJs7OEVtCUdwWdc+dJxB0oBzs01shA==","lpgXTgwlktvWBcAAPNZXWA==","GMwdleJ9MeIEwH7DDM0FwMwmlEqiiq03jR\/oMlSOEOs=",null,"\/I1TU\/oumx32q\/1esoGNhw==",1,"4109"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 17:26:30","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":["7300","72","8","130","%","9.93",109.0314,"2","2020-03-02 17:26:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 17:26:30","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":["7300","130","1098.0",989,"2","2020-03-02 17:26:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 17:26:30","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-13","2020-07-12","130"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-02 17:26:30","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":["7300",508,"SETTLED","A12-I207628","2020-03-02 17:26:30","2020-01-13","2","2020-03-02 17:26:30","2","2020-03-02 17:26:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 17:26:30","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":["7628","RENT","\u9810\u7e73\u79df\u91d1",1,935,"MO","1",935,"2","2020-03-02 17:26:30","2","2020-03-02 17:26:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 17:26:30","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":["7628","RENT","\u9810\u7e73\u79df\u91d1",2,935,"MO","1",935,"2","2020-03-02 17:26:30","2","2020-03-02 17:26:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 17:26:30","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":["7628","RENT","\u9810\u7e73\u79df\u91d1",3,935,"MO","1",935,"2","2020-03-02 17:26:30","2","2020-03-02 17:26:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 17:26:30","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":["7628","RENT","\u9810\u7e73\u79df\u91d1",4,935,"MO","1",935,"2","2020-03-02 17:26:30","2","2020-03-02 17:26:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 17:26:30","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":["7628","RENT","\u9810\u7e73\u79df\u91d1",5,935,"MO","1",935,"2","2020-03-02 17:26:30","2","2020-03-02 17:26:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 17:26:30","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":["7628","RENT","\u9810\u7e73\u79df\u91d1",6,935,"MO","1",935,"2","2020-03-02 17:26:30","2","2020-03-02 17:26:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 17:26:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5610,0,"7628"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-02 17:26:30","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":[508,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207276","2020-03-02 17:26:30",5610,"2","2020-03-02 17:26:30","2","2020-03-02 17:26:30","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 17:26:30","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":["7276","DEPOSIT",null,"PAID","2020-03-02 17:26:30",0,"2","2020-03-02 17:26:30","2","2020-03-02 17:26:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 17:26:30","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":["7276","INVOICE","7628","PAID","2020-03-02 17:26:30",5610,"2","2020-03-02 17:26:30","2","2020-03-02 17:26:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 18:24:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 18:27:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-02 19:08:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****