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

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

\u5009\u5eab\u7de8\u865f<\/td>\n	\u5c3a\u5bf8<\/td>\n	\u539f\u50f9(\u6708)<\/td>\n	\u512a\u60e0\u50f9(\u6708)<\/td>\n	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n	\u50f9\u683c<\/td>\n	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n	<\/td>\n <\/tr>
C15-132 <\/td>\n\t\t\t\t\t	4X3X3 <\/td>\n\t\t\t\t\t	$566.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"12","total_discounted_price":"510.00","deposit":"566.00","total_retail_price":"566.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:04:04","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":["C201614","PERSONAL","Ms","92ETzwHeYMOYZxdoGpxA8A==","8hiEOuVVoOMleTEBdtujcw==","","9sofJafwsOc8ORRHzYxoyg==","mLHNlZEJPqaLW0N8jymQ9x9H1MQreaOPGHejT3AVPuU=","vRN6lpHDSuEVlyxP+fRoihgnSgbN0QkGVokzqhyWnY0=","ga9ZL6WgWPRhGBEwvtJF+w==",null,"mLHNlZEJPqaLW0N8jymQ9x9H1MQreaOPGHejT3AVPuU=","jNuF9z6kUq0ByFa0n5AX1g==","2","2020-06-09 16:04:03","2","2020-06-09 16:04:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:04:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","3","6",1614,"NEW","C15-CT208082",566,510,566,0,"12","12",5666,6746,5726,"2020-06-09 16:04:05","0",null,null,null,"2020-06-01","2021-05-31","12 months contract. Special offer the 11th and 12th months free for the first contract. Storage rental and deposit, Smart card paid by bank transfer on June 01 and 09,2020. Smart card will provided by mail.","2020-06-01","12",0,null,1020,"1020.00","2","2020-06-09 16:04:03","2","2020-06-09 16:04:03","BANKIN","","","","BANKIN","","","",null,0,"\u20180012398473","C201614","PERSONAL","Ms","92ETzwHeYMOYZxdoGpxA8A==","8hiEOuVVoOMleTEBdtujcw==","","vRN6lpHDSuEVlyxP+fRoihgnSgbN0QkGVokzqhyWnY0=","9sofJafwsOc8ORRHzYxoyg==","mLHNlZEJPqaLW0N8jymQ9x9H1MQreaOPGHejT3AVPuU=","ga9ZL6WgWPRhGBEwvtJF+w==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:04:05","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":["8082",1614,"11","1","60.0",60,"2","2020-06-09 16:04:03","2","2020-06-09 16:04:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:04:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"8082"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-06-09 16:04:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8082","1438","566.0","566.00","2","2020-06-09 16:04:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:04:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2021-05-31","1438"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-09 16:04:05","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":["8082","C15-D205459","PAID",566,0,"2021-05-31","2020-06-09 16:04:03","2020-06-09 16:04:03","2","2020-06-09 16:04:03","2","2020-06-09 16:04:03",1614]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:04:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8082",1614,"SETTLED","C15-I208411","2020-06-09 16:04:03","2020-06-01","2","2020-06-09 16:04:03","2","2020-06-09 16:04:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:04:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8411","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-09 16:04:03","2","2020-06-09 16:04:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:04:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8411","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,510,"MO","1",510,"2","2020-06-09 16:04:03","2","2020-06-09 16:04:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:04:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8411","RENT","\u9810\u7e73\u79df\u91d1",4,510,"MO","1",510,"2","2020-06-09 16:04:03","2","2020-06-09 16:04:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:04:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8411","RENT","\u9810\u7e73\u79df\u91d1",5,510,"MO","1",510,"2","2020-06-09 16:04:03","2","2020-06-09 16:04:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:04:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8411","RENT","\u9810\u7e73\u79df\u91d1",6,510,"MO","1",510,"2","2020-06-09 16:04:03","2","2020-06-09 16:04:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:04:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8411","RENT","\u9810\u7e73\u79df\u91d1",7,510,"MO","1",510,"2","2020-06-09 16:04:03","2","2020-06-09 16:04:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:04:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8411","RENT","\u9810\u7e73\u79df\u91d1",8,510,"MO","1",510,"2","2020-06-09 16:04:03","2","2020-06-09 16:04:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:04:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8411","RENT","\u9810\u7e73\u79df\u91d1",9,510,"MO","1",510,"2","2020-06-09 16:04:03","2","2020-06-09 16:04:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:04:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8411","RENT","\u9810\u7e73\u79df\u91d1",10,510,"MO","1",510,"2","2020-06-09 16:04:03","2","2020-06-09 16:04:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:04:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8411","RENT","\u9810\u7e73\u79df\u91d1",11,510,"MO","1",510,"2","2020-06-09 16:04:03","2","2020-06-09 16:04:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:04:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8411","RENT","\u9810\u7e73\u79df\u91d1",12,510,"MO","1",510,"2","2020-06-09 16:04:03","2","2020-06-09 16:04:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:04:05","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":["8411","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-06-09 16:04:03","2","2020-06-09 16:04:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:04:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5160,0,"8411"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-09 16:04:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1614,"BANKIN","","","","BANKIN","","","","PAID","P208054","2020-06-09 16:04:03",5726,"2","2020-06-09 16:04:03","2","2020-06-09 16:04:03","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:04:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8054","DEPOSIT","5459","PAID","2020-06-09 16:04:03",566,"2","2020-06-09 16:04:03","2","2020-06-09 16:04:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:04:05","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8054","INVOICE","8411","PAID","2020-06-09 16:04:03",5160,"2","2020-06-09 16:04:03","2","2020-06-09 16:04:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:12:02","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":"type=INVOICE&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":62,"customer_code":"C160062","identity_type":"PERSONAL","identity_id":"K228082(5)","title":"Mr","lastname":"Yuen","firstname":"Kwok On, Mark","companyname":"","email":"ym6128@yahoo.com.hk","tel":"61287967","address":"Flat 7,20\/F ,Blk E, Yue Fai Court,Aberdeen","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-06-14","renew_room_key":"254,19454","renew_remark":"1 month contract. Storage rental paid by cash deposit on May 8, 2020. Storage deposit transferred from agreement A12-CT207553 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207802, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"1","order_discount":[],"order_room":[{"room_id":"214","room_code":"D18","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":"2020-06-14","rent_from":"2020-06-14","rent_to":"2020-07-13","delivery_service":"0","remark":"1 month contract. Storage rental $600 paid by cash deposit on June 09, 2020. Storage deposit transferred from agreement A12-CT207802 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":"254,19454","order_product":[],"pass":true}},"first_order_id":"4763","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> D18 <\/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-06-09 16:12:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",62,"NEW","A12-CT208083",598,598,0,0,"1","1",598,598,598,"2020-06-09 16:12:02","0",null,null,null,"2020-06-14","2020-07-13","1 month contract. Storage rental $600 paid by cash deposit on June 09, 2020. Storage deposit transferred from agreement A12-CT207802 to this agreement.","2020-06-14","12",0,null,0,"0","2","2020-06-09 16:12:02","2","2020-06-09 16:12:02","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"254,19454","C160062","PERSONAL","Mr","Tq2aGqdc3HaJ2Dhv1kivng==","DtbrOSvE4C7BOu5x4dBFtg==","","2dywE7m0E1QsxnoSSYjXYNGzam8BrQqJlW4yfvPMcgEUuu+U\/Cd9GXzTFUxRV\/Gk","ALSdg5RJw2nKsrdRoyKl+w==","IHWbmboe0mGIN08sR8rCSx94uDCuEAuXNvmkUE\/zPAQ=","CPbHg76fKF8UJ5bblGTxzg==",null,1,"4763"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:12:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8083","214","598.0","598.00","2","2020-06-09 16:12:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:12:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-14","2020-07-13","214"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-09 16:12:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8083",62,"SETTLED","A12-I208412","2020-06-09 16:12:02","2020-06-14","2","2020-06-09 16:12:02","2","2020-06-09 16:12:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:12:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8412","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-06-09 16:12:02","2","2020-06-09 16:12:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:12:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8412"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-09 16:12:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[62,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208055","2020-06-09 16:12:02",598,"2","2020-06-09 16:12:02","2","2020-06-09 16:12:02","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:12:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8055","DEPOSIT",null,"PAID","2020-06-09 16:12:02",0,"2","2020-06-09 16:12:02","2","2020-06-09 16:12:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:12:02","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8055","INVOICE","8412","PAID","2020-06-09 16:12:02",598,"2","2020-06-09 16:12:02","2","2020-06-09 16:12:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:14:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:41:11","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:47:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 16:48:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 18:19:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 19:38:28","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":"type=INVOICE&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1222,"customer_code":"C191222","identity_type":"PERSONAL","identity_id":"A810522(A)","title":"Mr","lastname":"PENG","firstname":"Ho Joong","companyname":"","email":"fredhjp01@gmail.com","tel":"61708188","address":"8\/F, Flat C, Block A, 4 Braemar Hill Rd., Tempo Court, North Point, H.K.","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"729.0","renew_rent_month":"12","renew_warehousing_date":"2020-07-02","renew_room_key":"0012403776","renew_remark":"'12 month contract. special offer " free 2 month". storage rental and deposit paid by cheque on 13 June, 2019. smartcard provided on 13 June, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT195211, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $810.0","renew_master_room_id":"167","order_discount":[{"master_room_discount_id":"408","master_room_id":"167","discount_type":"%","price":"810.00","disocunted_price":"770.00","discount":"4.94","monthly_deduct":40.014,"room_id":"1362","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1362","room_code":"C15-056","retail_price":"810.0","discounted_price":770,"location_id":"6"}],"roughly_size":"12","total_retail_price":810,"total_discounted_price":770,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2310,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-02","rent_from":"2020-07-02","rent_to":"2020-10-01","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on June 09, 2020. Deposit $810 transferred from agreement C15-CT195211 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2310,"final_order_total":2310,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012403776","order_product":[],"pass":true}},"first_order_id":5211,"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> C15-056 <\/td>\r\n\t\t\t\t\t 4X3X6.5 <\/td>\r\n\t\t\t\t\t $810.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"770.00","deposit":"0.00","total_retail_price":"810.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 19:38:29","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","3","6",1222,"NEW","C15-CT208084",810,770,0,0,"3","3",2310,2310,2310,"2020-06-09 19:38:29","0",null,null,null,"2020-07-02","2020-10-01","3 months contract. Storage rental paid by bank transfer on June 09, 2020. Deposit $810 transferred from agreement C15-CT195211 to this agreement.","2020-07-02","12",0,null,0,"0","2","2020-06-09 19:38:28","2","2020-06-09 19:38:28","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012403776","C191222","PERSONAL","Mr","YWZImkC2t5z2Ges+rSGvIg==","kkRnMtk38aHWXhpdNaJ24Q==","","npyWlO9u2L70jC8puXBKvTUPt5uZoDXViYlrdzxUcqBm00b73JL5Mx5eN0fL2amIYAtm42kocZWF993f90qdl8AQ2Z843ESbn\/jo0clS72U=","29P8K9aW7j0pkpjdJEH96Q==","ndnjSQ1Nvz+AfUIdJhPxKYnsK73OI0+3b1bq9nECeOA=","N116H2Ft\/oV\/+anZvbjifg==",null,1,5211]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 19:38:29","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":["8084","408","167","1362","%","4.94",40.014,"2","2020-06-09 19:38:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 19:38:29","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":["8084","1362","810.0",770,"2","2020-06-09 19:38:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 19:38:29","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-07-02","2020-10-01","1362"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-09 19:38:29","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":["8084",1222,"SETTLED","C15-I208413","2020-06-09 19:38:28","2020-07-02","2","2020-06-09 19:38:28","2","2020-06-09 19:38:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 19:38:29","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":["8413","RENT","\u9810\u7e73\u79df\u91d1",1,770,"MO","1",770,"2","2020-06-09 19:38:28","2","2020-06-09 19:38:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 19:38:29","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":["8413","RENT","\u9810\u7e73\u79df\u91d1",2,770,"MO","1",770,"2","2020-06-09 19:38:28","2","2020-06-09 19:38:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 19:38:29","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":["8413","RENT","\u9810\u7e73\u79df\u91d1",3,770,"MO","1",770,"2","2020-06-09 19:38:28","2","2020-06-09 19:38:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 19:38:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2310,0,"8413"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-09 19:38:29","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":[1222,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208056","2020-06-09 19:38:28",2310,"2","2020-06-09 19:38:28","2","2020-06-09 19:38:28","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 19:38:29","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":["8056","DEPOSIT",null,"PAID","2020-06-09 19:38:28",0,"2","2020-06-09 19:38:28","2","2020-06-09 19:38:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 19:38:29","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":["8056","INVOICE","8413","PAID","2020-06-09 19:38:28",2310,"2","2020-06-09 19:38:28","2","2020-06-09 19:38:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 19:41:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 22:31:31","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-09 22:41:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****