\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>
A05-060 <\/td>\n\t\t\t\t\t	3X3X7 <\/td>\n\t\t\t\t\t	$1006.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":"9","total_discounted_price":"1006.00","deposit":"2012.00","total_retail_price":"1006.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:04:34","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":["C201515","PERSONAL","Ms","wV5bdf6KNCfFQo0K0PxMJg==","8BEgNhGpCR8jGkzUtrIcXg==","","l0xvmNRy7oDOtbMzTuwmkw==",null,"82fWqZhZcRDMEYj0HQR5iEb06S\/\/TG8eHXYDL4jWW3vqKytT0jpE5B6KFcg2mZwDLm1\/eNuPtBuIH+6h0j\/paw==","sMVNjMRfAvmuXJRN+E7Haw==",null,null,"rjj5UwIevroaFLdMZUO4Ig==","2","2020-02-19 17:04:33","2","2020-02-19 17:04:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:04:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","4",1515,"NEW","A05-CT207232",1006,1006,2012,0,"3","3",3446,5030,3446,"2020-02-19 17:04:34","0",null,null,null,"2020-03-01","2020-05-31","3 months contract. Special offer 50% off for the first 3 months. and 5% \"Rent Now\" discount. Storage rental and deposit paid by cash on February 19, 2020. Smartcard provided on February 19, 2020.","2020-03-01","9",0,null,1584,"1584.00","2","2020-02-19 17:04:33","2","2020-02-19 17:04:33","CASH","","","","CASH","","","",null,0,"'0012438277","C201515","PERSONAL","Ms","wV5bdf6KNCfFQo0K0PxMJg==","8BEgNhGpCR8jGkzUtrIcXg==","","82fWqZhZcRDMEYj0HQR5iEb06S\/\/TG8eHXYDL4jWW3vqKytT0jpE5B6KFcg2mZwDLm1\/eNuPtBuIH+6h0j\/paw==","l0xvmNRy7oDOtbMzTuwmkw==",null,"sMVNjMRfAvmuXJRN+E7Haw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:04:34","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":["7232","230 available_room_list_input","108","1062","%","5.00",50.3,"2","2020-02-19 17:04:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:04:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7232","1062","1006.0",955.7,"2","2020-02-19 17:04:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:04:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-01","2020-05-31","1062"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-19 17:04:34","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":["7232","A05-D205293","PAID",2012,0,"2020-05-31","2020-02-19 17:04:33","2020-02-19 17:04:33","2","2020-02-19 17:04:33","2","2020-02-19 17:04:33",1515]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:04:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7232",1515,"SETTLED","A05-I207560","2020-02-19 17:04:33","2020-03-01","2","2020-02-19 17:04:33","2","2020-02-19 17:04:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:04:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7560","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-02-19 17:04:33","2","2020-02-19 17:04:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:04:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7560","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,428,"MO","1",428,"2","2020-02-19 17:04:33","2","2020-02-19 17:04:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:04:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7560","RENT","\u9810\u7e73\u79df\u91d1",3,1006,"MO","1",1006,"2","2020-02-19 17:04:33","2","2020-02-19 17:04:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:04:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1434,0,"7560"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-19 17:04:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1515,"CASH","","","","CASH","","","","PAID","P207208","2020-02-19 17:04:33",3446,"2","2020-02-19 17:04:33","2","2020-02-19 17:04:33","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:04:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7208","DEPOSIT","5293","PAID","2020-02-19 17:04:33",2012,"2","2020-02-19 17:04:33","2","2020-02-19 17:04:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:04:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7208","INVOICE","7560","PAID","2020-02-19 17:04:33",1434,"2","2020-02-19 17:04:33","2","2020-02-19 17:04:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:47:10","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1354&filter3=undefined&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":134,"customer_code":"C160134","identity_type":"PERSONAL","identity_id":"D005655(4)","title":"Mr","lastname":"Wong ","firstname":"Kam Sum","companyname":"","email":null,"tel":"91401401","address":"Flat D, 8\/F, Block 13, Fu Sing Yuen, Chi Fu Fa Yuen","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":"12","renew_warehousing_date":"2020-01-21","renew_room_key":"032,25724","renew_remark":"12 months contract. Storage rental paid by EPS on January 14, 2019. Storage deposit $1856 transferred from agreement A12-CT182646 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT194158, \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":"20","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"20","room_code":"A20","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-21","rent_from":"2020-01-21","rent_to":"2020-07-20","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on January 13, 2019. Storage deposit $1856 transferred from agreement A12-CT194158 to this agreement.\r\n","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":"032,25724","order_product":[],"pass":true}},"first_order_id":4158,"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> A20 <\/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.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:47:10","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",134,"NEW","A12-CT207233",1098,935,0,0,"6","6",5610,5610,5610,"2020-02-19 17:47:10","0",null,null,null,"2020-01-21","2020-07-20","6 months contract. Storage rental paid by bank transfer on January 13, 2019. Storage deposit $1856 transferred from agreement A12-CT194158 to this agreement.\r\n","2020-01-21","16",0,null,0,"0","2","2020-02-19 17:47:10","2","2020-02-19 17:47:10","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"032,25724","C160134","PERSONAL","Mr","aeGPRhIEz9Q9mUB5bKVQLw==","DgLsCGM4faTvgwjKBW9M0A==","","y87W+Je\/7Xy7HtoJBBGIc+FLiJwqu6rid4JSQDiW0H5g4LSOg2lqZK\/Pa32DKOrAGCLN6BO6jr0h0fdtC3htyA==","vMbqI8hQDW3P3YwJBH4X0A==",null,"dmPQovU\/4QHoIQmGg20+dQ==",null,1,4158]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:47:10","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":["7233","72","8","20","%","9.93",109.0314,"2","2020-02-19 17:47:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:47:10","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":["7233","20","1098.0",989,"2","2020-02-19 17:47:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:47:10","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-21","2020-07-20","20"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-19 17:47:10","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":["7233",134,"SETTLED","A12-I207561","2020-02-19 17:47:10","2020-01-21","2","2020-02-19 17:47:10","2","2020-02-19 17:47:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:47:10","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":["7561","RENT","\u9810\u7e73\u79df\u91d1",1,935,"MO","1",935,"2","2020-02-19 17:47:10","2","2020-02-19 17:47:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:47:10","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":["7561","RENT","\u9810\u7e73\u79df\u91d1",2,935,"MO","1",935,"2","2020-02-19 17:47:10","2","2020-02-19 17:47:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:47:10","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":["7561","RENT","\u9810\u7e73\u79df\u91d1",3,935,"MO","1",935,"2","2020-02-19 17:47:10","2","2020-02-19 17:47:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:47:10","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":["7561","RENT","\u9810\u7e73\u79df\u91d1",4,935,"MO","1",935,"2","2020-02-19 17:47:10","2","2020-02-19 17:47:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:47:10","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":["7561","RENT","\u9810\u7e73\u79df\u91d1",5,935,"MO","1",935,"2","2020-02-19 17:47:10","2","2020-02-19 17:47:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:47:10","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":["7561","RENT","\u9810\u7e73\u79df\u91d1",6,935,"MO","1",935,"2","2020-02-19 17:47:10","2","2020-02-19 17:47:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:47:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5610,0,"7561"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-19 17:47:10","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":[134,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207209","2020-02-19 17:47:10",5610,"2","2020-02-19 17:47:10","2","2020-02-19 17:47:10","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:47:10","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":["7209","DEPOSIT",null,"PAID","2020-02-19 17:47:10",0,"2","2020-02-19 17:47:10","2","2020-02-19 17:47:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:47:10","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":["7209","INVOICE","7561","PAID","2020-02-19 17:47:10",5610,"2","2020-02-19 17:47:10","2","2020-02-19 17:47:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:57:26","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=1354&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":798,"customer_code":"C180798","identity_type":"PERSONAL","identity_id":"Z916749(9)","title":"Mr","lastname":"Lo","firstname":"Ka Chun","companyname":"","email":"loka0039@gmai.com","tel":"96670730","address":"Flat 3107, 31\/F, Tin Chak House, Tin Wan Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-21","renew_room_key":"055,32980","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 22, 2019. Storage deposit transferred from agreement A12-CT196457 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196765, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"279","room_code":"E06","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-21","rent_from":"2020-01-21","rent_to":"2020-02-20","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 24, 2020. Storage deposit transferred from agreement A12-CT196765 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,32980","order_product":[],"pass":true}},"first_order_id":"4789","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> E06 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:57: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","1",798,"NEW","A12-CT207234",998,1038,0,0,"1","1",1038,1038,1038,"2020-02-19 17:57:26","0",null,null,null,"2020-01-21","2020-02-20","1 month contract. Storage rental paid by bank transfer on January 24, 2020. Storage deposit transferred from agreement A12-CT196765 to this agreement.","2020-01-21","12",0,null,0,"0","2","2020-02-19 17:57:26","2","2020-02-19 17:57:26","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,32980","C180798","PERSONAL","Mr","51MA8AWBJt370WUqsUeCnw==","4w4biS+jM\/Q3DAzxHdf3pA==","","mMzQ1c7IXnG31el3pMn+cAlVmwOEO8RAHQZJFRSLNV\/SmYFvT5hQ\/KG4Is71QjPxXCoAkN9ubgFw5NXyRPui2oMB3Uo2T5sIHAA\/TnArqac=","iu3rJGYyixnPHEo1U9vPkA==","vSxCV4H9VfvlX9eKdpf+03ZOzigLaCc\/nH8UtdLNTfM=","L8wtX\/W+agotXtDfSAWTVA==",null,1,"4789"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:57: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":["7234","279","998.0","998.00","2","2020-02-19 17:57:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:57: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-21","2020-02-20","279"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-19 17:57: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":["7234",798,"SETTLED","A12-I207562","2020-02-19 17:57:26","2020-01-21","2","2020-02-19 17:57:26","2","2020-02-19 17:57:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:57: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":["7562","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-02-19 17:57:26","2","2020-02-19 17:57:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:57:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"7562"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-19 17:57: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":[798,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207210","2020-02-19 17:57:26",1038,"2","2020-02-19 17:57:26","2","2020-02-19 17:57:26","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:57: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":["7210","DEPOSIT",null,"PAID","2020-02-19 17:57:26",0,"2","2020-02-19 17:57:26","2","2020-02-19 17:57:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:57: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":["7210","INVOICE","7562","PAID","2020-02-19 17:57:26",1038,"2","2020-02-19 17:57:26","2","2020-02-19 17:57:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 17:59:06","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-19 18:41:31","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****