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

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

\u5009\u5eab\u7de8\u865f<\/td>\n	\u5c3a\u5bf8<\/td>\n	\u539f\u50f9(\u6708)<\/td>\n	\u512a\u60e0\u50f9(\u6708)<\/td>\n	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n	\u50f9\u683c<\/td>\n	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n	<\/td>\n <\/tr>
B01-105 <\/td>\n\t\t\t\t\t	4X2X7 <\/td>\n\t\t\t\t\t	$768.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"8","total_discounted_price":"600.00","deposit":"1536.00","total_retail_price":"768.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 16:49:11","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":["C191466","BUSINESS","Ms","sapX1yGvj5KBKw0uUp+FgA==","22KPgW1C3CU66tb5kESLdQ==","Spark Loft Limited","JBAbE9BrBxLxWXyMQet9eg==","tAcsrIzR\/8Q8B+qvpJF46H7QPGXGN2BHc8lL\/QNwbVA=","3WoWUhTbxZ7prA2weXS7mjW6dbC0I7Ta39aaFNy1vA8\/J6vbe6PPxuDE7KZP9w8Gad74D93\/xmyjAMTq4dJvXbMYNbAQPWS9TbX6dwmuIHxUrJxRPVm94hzixtlFHxO+",null,"0kx1FK2k3IBpYe+nh9bM7g==","tAcsrIzR\/8Q8B+qvpJF46H7QPGXGN2BHc8lL\/QNwbVA=","sujXsXSmgh8UxuVH0IgvEA==","2","2019-12-10 16:49:10","2","2019-12-10 16:49:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 16:49:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","2","5",1466,"NEW","B01-CT196663",768,600,1536,0,"12","12",7236,8796,7296,"2019-12-10 16:49:11","0",null,null,null,"2019-12-15","2020-12-14","12 months contract. Special offer 2 months free and 5% 'Rent Now' discount. Storage deposit $500 paid by cash on December 3, 2019. Remaining rental and deposit $6796 will be paid by December 13, 2019. Smartcard paid by December 3, 2019.","2019-12-15","8",0,null,1500,"1500.00","2","2019-12-10 16:49:10","2","2019-12-10 16:49:10","BANKIN","","","","BANKIN","","","",null,0,"'0012472843","C191466","BUSINESS","Ms","sapX1yGvj5KBKw0uUp+FgA==","22KPgW1C3CU66tb5kESLdQ==","Spark Loft Limited","3WoWUhTbxZ7prA2weXS7mjW6dbC0I7Ta39aaFNy1vA8\/J6vbe6PPxuDE7KZP9w8Gad74D93\/xmyjAMTq4dJvXbMYNbAQPWS9TbX6dwmuIHxUrJxRPVm94hzixtlFHxO+","JBAbE9BrBxLxWXyMQet9eg==","tAcsrIzR\/8Q8B+qvpJF46H7QPGXGN2BHc8lL\/QNwbVA=",null,"0kx1FK2k3IBpYe+nh9bM7g=="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 16:49:11","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":["6663","338 available_room_list_input","137","1295","%","34.90",268.032,"2","2019-12-10 16:49:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 16:49:11","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":["6663",1466,"11","1","60.0",60,"2","2019-12-10 16:49:10","2","2019-12-10 16:49:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 16:49:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"6663"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2019-12-10 16:49:11","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":["6663","1295","768.0",500,"2","2019-12-10 16:49:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 16:49:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-15","2020-12-14","1295"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-10 16:49:11","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":["6663","B01-D195210","PAID",1536,0,"2020-12-14","2019-12-10 16:49:10","2019-12-10 16:49:10","2","2019-12-10 16:49:10","2","2019-12-10 16:49:10",1466]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 16:49:11","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":["6663",1466,"SETTLED","B01-I196991","2019-12-10 16:49:10","2019-12-15","2","2019-12-10 16:49:10","2","2019-12-10 16:49:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 16:49:11","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":["6991","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2019-12-10 16:49:10","2","2019-12-10 16:49:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 16:49:11","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":["6991","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2019-12-10 16:49:10","2","2019-12-10 16:49:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 16:49:11","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":["6991","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,300,"MO","1",300,"2","2019-12-10 16:49:10","2","2019-12-10 16:49:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 16:49:11","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":["6991","RENT","\u9810\u7e73\u79df\u91d1",4,600,"MO","1",600,"2","2019-12-10 16:49:10","2","2019-12-10 16:49:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 16:49:11","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":["6991","RENT","\u9810\u7e73\u79df\u91d1",5,600,"MO","1",600,"2","2019-12-10 16:49:10","2","2019-12-10 16:49:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 16:49:11","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":["6991","RENT","\u9810\u7e73\u79df\u91d1",6,600,"MO","1",600,"2","2019-12-10 16:49:10","2","2019-12-10 16:49:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 16:49:11","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":["6991","RENT","\u9810\u7e73\u79df\u91d1",7,600,"MO","1",600,"2","2019-12-10 16:49:10","2","2019-12-10 16:49:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 16:49:11","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":["6991","RENT","\u9810\u7e73\u79df\u91d1",8,600,"MO","1",600,"2","2019-12-10 16:49:10","2","2019-12-10 16:49:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 16:49:11","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":["6991","RENT","\u9810\u7e73\u79df\u91d1",9,600,"MO","1",600,"2","2019-12-10 16:49:10","2","2019-12-10 16:49:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 16:49:11","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":["6991","RENT","\u9810\u7e73\u79df\u91d1",10,600,"MO","1",600,"2","2019-12-10 16:49:10","2","2019-12-10 16:49:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 16:49:11","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":["6991","RENT","\u9810\u7e73\u79df\u91d1",11,600,"MO","1",600,"2","2019-12-10 16:49:10","2","2019-12-10 16:49:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 16:49:11","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":["6991","RENT","\u9810\u7e73\u79df\u91d1",12,600,"MO","1",600,"2","2019-12-10 16:49:10","2","2019-12-10 16:49:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 16:49:11","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":["6991","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2019-12-10 16:49:10","2","2019-12-10 16:49:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 16:49:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5760,0,"6991"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-10 16:49:11","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":[1466,"BANKIN","","","","BANKIN","","","","PAID","P196641","2019-12-10 16:49:10",7296,"2","2019-12-10 16:49:10","2","2019-12-10 16:49:10","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 16:49:11","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":["6641","DEPOSIT","5210","PAID","2019-12-10 16:49:10",1536,"2","2019-12-10 16:49:10","2","2019-12-10 16:49:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 16:49:11","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":["6641","INVOICE","6991","PAID","2019-12-10 16:49:10",5760,"2","2019-12-10 16:49:10","2","2019-12-10 16:49:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:02:11","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:11:09","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:14:17","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1121&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":660,"customer_code":"C170660","identity_type":"PERSONAL","identity_id":"D354297(2)","title":"Mr","lastname":"Low","firstname":"Hon Keet Stephen","companyname":"","email":"aequinox@ymail.com","tel":"64638416","address":"GPO Box 1688, Hong Kong","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2334.0","renew_rent_month":"3","renew_warehousing_date":"2020-12-29","renew_room_key":"055,15470","renew_remark":"3 months contract. Storage rental paid by cash on September 16, 2019. Storage deposit transferred from agreement A18-CT195252 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195959, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[{"master_room_discount_id":"248","master_room_id":"91","discount_type":"%","price":"1290.00","disocunted_price":"1225.90","discount":"4.97","monthly_deduct":64.113,"room_id":"987","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"248","master_room_id":"91","discount_type":"%","price":"1290.00","disocunted_price":"1225.90","discount":"4.97","monthly_deduct":64.113,"room_id":"986","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"987","room_code":"X12","retail_price":"1290.0","discounted_price":1225.9,"location_id":"3"},{"room_id":"986","room_code":"X11","retail_price":"1290.0","discounted_price":1225.9,"location_id":"3"}],"roughly_size":"32","total_retail_price":2580,"total_discounted_price":2334,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":7002,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-12-29","rent_from":"2020-12-29","rent_to":"2021-03-28","delivery_service":"0","remark":"3 months contract. Storage rental paid by cash on Dec 12, 2019. Storage deposit transferred from agreement A18-CT195959 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":7002,"final_order_total":7002,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,15470","order_product":[],"pass":true}},"first_order_id":"4650","selected_room_tr":"	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \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> X12 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> X11 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"2334.0","deposit":"0","total_retail_price":"2580.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:14:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",660,"NEW","A18-CT196664",2580,2334,0,0,"3","3",7002,7002,7002,"2019-12-10 17:14:17","0",null,null,null,"2020-12-29","2021-03-28","3 months contract. Storage rental paid by cash on Dec 12, 2019. Storage deposit transferred from agreement A18-CT195959 to this agreement.","2020-12-29","32",0,null,0,"0","2","2019-12-10 17:14:17","2","2019-12-10 17:14:17","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"055,15470","C170660","PERSONAL","Mr","8WARjcd6zFu40\/HzPdJPfN1ULF7Z3rO82+vQIx5x\/SM=","hXEebd6SlV7J+4vJgo12Ig==","","VBq6cRnFyG95IonRizJi+lwCL6Oe\/bdLOb6ELHGGPWo=","EMRlE0\/B9grUj7uTzS0zfA==","GKb98Vl5nys8iXuEjTSvUjIQSI4LYfAqndGeMATNE\/I=","e9TAobvjjMmIxa53EKWduA==",null,1,"4650"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:14:17","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":["6664","248","91","987","%","4.97",64.113,"2","2019-12-10 17:14:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:14:17","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":["6664","248","91","986","%","4.97",64.113,"2","2019-12-10 17:14:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:14:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6664","987","1290.0",1225.9,"2","2019-12-10 17:14:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:14:17","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-12-29","2021-03-28","987"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-10 17:14:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6664","986","1290.0",1225.9,"2","2019-12-10 17:14:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:14:17","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-12-29","2021-03-28","986"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-10 17:14:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6664",660,"SETTLED","A18-I196992","2019-12-10 17:14:17","2020-12-29","2","2019-12-10 17:14:17","2","2019-12-10 17:14:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:14:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6992","RENT","\u9810\u7e73\u79df\u91d1",1,2334,"MO","1",2334,"2","2019-12-10 17:14:17","2","2019-12-10 17:14:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:14:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6992","RENT","\u9810\u7e73\u79df\u91d1",2,2334,"MO","1",2334,"2","2019-12-10 17:14:17","2","2019-12-10 17:14:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:14:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6992","RENT","\u9810\u7e73\u79df\u91d1",3,2334,"MO","1",2334,"2","2019-12-10 17:14:17","2","2019-12-10 17:14:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:14:17","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7002,0,"6992"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-10 17:14:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[660,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P196642","2019-12-10 17:14:17",7002,"2","2019-12-10 17:14:17","2","2019-12-10 17:14:17","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:14:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6642","DEPOSIT",null,"PAID","2019-12-10 17:14:17",0,"2","2019-12-10 17:14:17","2","2019-12-10 17:14:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:14:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6642","INVOICE","6992","PAID","2019-12-10 17:14:17",7002,"2","2019-12-10 17:14:17","2","2019-12-10 17:14:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:22:57","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&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"656","master_room_id":"30","room_code":"M67"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> M67 <\/td>\r\n\t\t\t\t\t 3X3X8 <\/td>\r\n\t\t\t\t\t $775.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"K494506(9)","title":"Mr","lastname":"YUE","firstname":"Kin Hang","companyname":"","email":"yokenkoyo@gmail.com","tel":"57918881","address":"Flat H, 8\/F, Block 5, New Jade Garden, Chai Wan","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"656","room_code":"M67","retail_price":"775.0","discounted_price":"775.00","location_id":"2"}],"roughly_size":"9","total_retail_price":775,"total_discounted_price":698,"deposit":1550,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5534,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"204.00","warehousing_date":"2019-12-14","rent_from":"2019-12-14","rent_to":"2020-06-13","delivery_service":"0","remark":"6 months contract. Special offer 5% \"rent Now\" discount. Storage rental and deposit paid by EPS on December 10, 2019. Smartcard provided on December 10, 2019.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":204,"order_total":5738,"final_order_total":5534,"location_id":"2","branch_id":"1","company_id":"1","room_key":"191, 05288","order_product":[],"pass":true}},"roughly_size":"9","total_discounted_price":"698.00","deposit":"1550.00","total_retail_price":"775.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:22:58","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":["C191467","PERSONAL","Mr","kTcsgy8ZGSq2a5ruB8dG1w==","4yTQcEBZNABiF4rq79LzLQ==","","BDiTf1k0\/ZAxx7WVrZVfJA==","R8WSiTRtDcI\/5Niu7P+lqDccQvRz8PEyhUvX7\/m8s0Y=","PWSpKG6nNFJWN2zJkttNpSqXtrxtCm+j+Su3dt35U+qhoernM4mXmP9AgxefSEm0","Bq1rNXbKgBuNwBVb0TwBNQ==",null,"R8WSiTRtDcI\/5Niu7P+lqDccQvRz8PEyhUvX7\/m8s0Y=","ra1qMKcgS9bAJwMreD9N8Q==","2","2019-12-10 17:22:57","2","2019-12-10 17:22:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:22:58","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",1467,"NEW","A14-CT196665",775,698,1550,0,"6","6",5534,5738,5534,"2019-12-10 17:22:58","0",null,null,null,"2019-12-14","2020-06-13","6 months contract. Special offer 5% \"rent Now\" discount. Storage rental and deposit paid by EPS on December 10, 2019. Smartcard provided on December 10, 2019.","2019-12-14","9",0,null,204,"204.00","2","2019-12-10 17:22:57","2","2019-12-10 17:22:57","EPS","","","","EPS","","","",null,0,"191, 05288","C191467","PERSONAL","Mr","kTcsgy8ZGSq2a5ruB8dG1w==","4yTQcEBZNABiF4rq79LzLQ==","","PWSpKG6nNFJWN2zJkttNpSqXtrxtCm+j+Su3dt35U+qhoernM4mXmP9AgxefSEm0","BDiTf1k0\/ZAxx7WVrZVfJA==","R8WSiTRtDcI\/5Niu7P+lqDccQvRz8PEyhUvX7\/m8s0Y=","Bq1rNXbKgBuNwBVb0TwBNQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:22:58","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":["6665","656","775.0","775.00","2","2019-12-10 17:22:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:22:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-14","2020-06-13","656"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-10 17:22:58","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":["6665","A14-D195211","PAID",1550,0,"2020-06-13","2019-12-10 17:22:57","2019-12-10 17:22:57","2","2019-12-10 17:22:57","2","2019-12-10 17:22:57",1467]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:22:58","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":["6665",1467,"SETTLED","A14-I196993","2019-12-10 17:22:57","2019-12-14","2","2019-12-10 17:22:57","2","2019-12-10 17:22:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:22:58","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":["6993","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,494,"MO","1",494,"2","2019-12-10 17:22:57","2","2019-12-10 17:22:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:22:58","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":["6993","RENT","\u9810\u7e73\u79df\u91d1",2,698,"MO","1",698,"2","2019-12-10 17:22:57","2","2019-12-10 17:22:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:22:58","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":["6993","RENT","\u9810\u7e73\u79df\u91d1",3,698,"MO","1",698,"2","2019-12-10 17:22:57","2","2019-12-10 17:22:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:22:58","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":["6993","RENT","\u9810\u7e73\u79df\u91d1",4,698,"MO","1",698,"2","2019-12-10 17:22:57","2","2019-12-10 17:22:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:22:58","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":["6993","RENT","\u9810\u7e73\u79df\u91d1",5,698,"MO","1",698,"2","2019-12-10 17:22:57","2","2019-12-10 17:22:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:22:58","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":["6993","RENT","\u9810\u7e73\u79df\u91d1",6,698,"MO","1",698,"2","2019-12-10 17:22:57","2","2019-12-10 17:22:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:22:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3984,0,"6993"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-10 17:22:58","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":[1467,"EPS","","","","EPS","","","","PAID","P196643","2019-12-10 17:22:57",5534,"2","2019-12-10 17:22:57","2","2019-12-10 17:22:57","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:22:58","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":["6643","DEPOSIT","5211","PAID","2019-12-10 17:22:57",1550,"2","2019-12-10 17:22:57","2","2019-12-10 17:22:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:22:58","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":["6643","INVOICE","6993","PAID","2019-12-10 17:22:57",3984,"2","2019-12-10 17:22:57","2","2019-12-10 17:22:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:23:13","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=1&filter2=1121&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":1076,"customer_code":"C181076","identity_type":"PERSONAL","identity_id":"D367728(2)","title":"Mr","lastname":"Tsui ","firstname":"Lai Yin, Ricky","companyname":"","email":"rickylytsui@yahoo.com.hk","tel":"56111196","address":"35H, Pokfulam Village, Hong Kong","pass":true},"2":{"renew_paymethod2":"CREDIT_CARD","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1162.0","renew_rent_month":"12","renew_warehousing_date":"2019-12-01","renew_room_key":"0012415211","renew_remark":"12 months contract. 1 month free. Storage rental and deposit paid by credit card on November 13, 2018. Additional 3% credit card service charge included in the total fee of HK$15,823. Smartcard provided on November 13, 2018. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT183575, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2580.0","renew_master_room_id":"114","order_discount":[{"master_room_discount_id":"251","master_room_id":"114","discount_type":"%","price":"1290.00","disocunted_price":"1161.00","discount":"10.00","monthly_deduct":129,"room_id":"1136","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1136","room_code":"A05-134","retail_price":"1290.0","discounted_price":1161,"location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6972,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-01","rent_from":"2019-12-01","rent_to":"2020-05-31","delivery_service":"0","remark":"6 months contract. Storage rental paid by EPS on Dec 10,2019. Deposit $2580 transferred from agreement A05-CT183575 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":6972,"final_order_total":6972,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012415211","order_product":[],"pass":true}},"first_order_id":3575,"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-134 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1162.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:23:14","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",1076,"NEW","A05-CT196666",1290,1162,0,0,"6","6",6972,6972,6972,"2019-12-10 17:23:14","0",null,null,null,"2019-12-01","2020-05-31","6 months contract. Storage rental paid by EPS on Dec 10,2019. Deposit $2580 transferred from agreement A05-CT183575 to this agreement.","2019-12-01","16",0,null,0,"0","2","2019-12-10 17:23:13","2","2019-12-10 17:23:13","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"0012415211","C181076","PERSONAL","Mr","8D1uLEOXtfHEgH0L7b+I6A==","JYuKNGzB9R7B9ggiMi1thg==","","KZL+9+tGA9K99yCUyPH6xehY269kOG0KsUODz8mEjNfg0VAbTVV1OJrUMhPfvuOM","I5Y7CXsRiY4dHshwP3wjFQ==","XFYTvA5+2boJNHqO313hBCouzb2kChGH21YnZdVIbNw=","sI8qxLSGP\/CHYru0QEJ1vA==",null,1,3575]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:23:14","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":["6666","251","114","1136","%","10.00",129,"2","2019-12-10 17:23:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:23:14","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":["6666","1136","1290.0",1161,"2","2019-12-10 17:23:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:23:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-01","2020-05-31","1136"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-10 17:23:14","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":["6666",1076,"SETTLED","A05-I196994","2019-12-10 17:23:13","2019-12-01","2","2019-12-10 17:23:13","2","2019-12-10 17:23:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:23:14","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":["6994","RENT","\u9810\u7e73\u79df\u91d1",1,1162,"MO","1",1162,"2","2019-12-10 17:23:13","2","2019-12-10 17:23:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:23:14","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":["6994","RENT","\u9810\u7e73\u79df\u91d1",2,1162,"MO","1",1162,"2","2019-12-10 17:23:13","2","2019-12-10 17:23:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:23:14","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":["6994","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2019-12-10 17:23:13","2","2019-12-10 17:23:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:23:14","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":["6994","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2019-12-10 17:23:13","2","2019-12-10 17:23:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:23:14","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":["6994","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2019-12-10 17:23:13","2","2019-12-10 17:23:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:23:14","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":["6994","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2019-12-10 17:23:13","2","2019-12-10 17:23:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:23:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6972,0,"6994"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-10 17:23:14","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":[1076,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P196644","2019-12-10 17:23:13",6972,"2","2019-12-10 17:23:13","2","2019-12-10 17:23:13","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:23:14","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":["6644","DEPOSIT",null,"PAID","2019-12-10 17:23:13",0,"2","2019-12-10 17:23:13","2","2019-12-10 17:23:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-10 17:23:14","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":["6644","INVOICE","6994","PAID","2019-12-10 17:23:13",6972,"2","2019-12-10 17:23:13","2","2019-12-10 17:23:13"]},"data_before":[],"data_after":[],"step":1} *****