{"created_at":"2020-01-13 10:07:01","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:17:35","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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":133,"customer_code":"C160133","identity_type":"PERSONAL","identity_id":"R071611(0)","title":"Ms","lastname":"Huang","firstname":"Yi Ting","companyname":"","email":"yiting50@yahoo.com.hk","tel":"98336964","address":"\u5357\u5be7\u88579\u865f\u9999\u6e2f\u4ed4\u4e2d\u5fc3\u7f8e\u8f1d\u95a319\u5b57\u6a133\u5ba4","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1358.0","renew_rent_month":"12","renew_warehousing_date":"2020-01-23","renew_room_key":"034,21196","renew_remark":"12 months contract. Storage rental paid by cash on January 15, 2019. Storage deposit $2516 transferred from agreement A12-CT182622 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT194161, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"11","order_discount":[{"master_room_discount_id":"81","master_room_id":"11","discount_type":"%","price":"1768.00","disocunted_price":"1469.90","discount":"16.86","monthly_deduct":298.0848,"room_id":"374","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"374","room_code":"G15","retail_price":"1768.0","discounted_price":1469.9,"location_id":"1"}],"roughly_size":"24","total_retail_price":1768,"total_discounted_price":1358,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":16296,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-23","rent_from":"2020-01-23","rent_to":"2021-01-22","delivery_service":"0","remark":"12 months contract. Storage rental paid by cheque on January 13, 2019. Storage deposit $2516 transferred from agreement A12-CT194161 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":16296,"final_order_total":16296,"location_id":"1","branch_id":"1","company_id":"1","room_key":"034,21196","order_product":[],"pass":true}},"first_order_id":4161,"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>
G15 <\/td>\r\n\t\t\t\t\t	4X6X8 <\/td>\r\n\t\t\t\t\t	$1768.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\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":"24","total_discounted_price":"1358.0","deposit":"0","total_retail_price":"1768.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:17:35","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",133,"NEW","A12-CT206939",1768,1358,0,0,"12","12",16296,16296,16296,"2020-01-13 10:17:35","0",null,null,null,"2020-01-23","2021-01-22","12 months contract. Storage rental paid by cheque on January 13, 2019. Storage deposit $2516 transferred from agreement A12-CT194161 to this agreement.\r\n","2020-01-23","24",0,null,0,"0","2","2020-01-13 10:17:35","2","2020-01-13 10:17:35","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"034,21196","C160133","PERSONAL","Ms","KpitwOwVW68V469iqvW3iA==","olN5\/Q5aAg1whjEZQduEyg==","","zFHL+ig9Jbiebk+N6IFuVtm5hy7pW7XXI8Eq1pPRW+ln0\/Nz9j58WznSykiy1t2mju5lA19r\/EATTPtUFxSqKQ==","hIA\/S1HVdk0gSUIbjxwUBg==","jHedBImZnO+sfVxwoGezu5J597BpDILJkGcHzMHMwZk=","DD0fx5\/rNY6AEq+xgh7QZA==",null,1,4161]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:17:35","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":["6939","81","11","374","%","16.86",298.0848,"2","2020-01-13 10:17:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:17:35","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":["6939","374","1768.0",1469.9,"2","2020-01-13 10:17:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:17:35","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-23","2021-01-22","374"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 10:17:35","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":["6939",133,"SETTLED","A12-I207267","2020-01-13 10:17:35","2020-01-23","2","2020-01-13 10:17:35","2","2020-01-13 10:17:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:17:35","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":["7267","RENT","\u9810\u7e73\u79df\u91d1",1,1358,"MO","1",1358,"2","2020-01-13 10:17:35","2","2020-01-13 10:17:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:17:35","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":["7267","RENT","\u9810\u7e73\u79df\u91d1",2,1358,"MO","1",1358,"2","2020-01-13 10:17:35","2","2020-01-13 10:17:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:17:35","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":["7267","RENT","\u9810\u7e73\u79df\u91d1",3,1358,"MO","1",1358,"2","2020-01-13 10:17:35","2","2020-01-13 10:17:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:17:35","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":["7267","RENT","\u9810\u7e73\u79df\u91d1",4,1358,"MO","1",1358,"2","2020-01-13 10:17:35","2","2020-01-13 10:17:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:17:35","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":["7267","RENT","\u9810\u7e73\u79df\u91d1",5,1358,"MO","1",1358,"2","2020-01-13 10:17:35","2","2020-01-13 10:17:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:17:35","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":["7267","RENT","\u9810\u7e73\u79df\u91d1",6,1358,"MO","1",1358,"2","2020-01-13 10:17:35","2","2020-01-13 10:17:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:17:35","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":["7267","RENT","\u9810\u7e73\u79df\u91d1",7,1358,"MO","1",1358,"2","2020-01-13 10:17:35","2","2020-01-13 10:17:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:17:35","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":["7267","RENT","\u9810\u7e73\u79df\u91d1",8,1358,"MO","1",1358,"2","2020-01-13 10:17:35","2","2020-01-13 10:17:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:17:35","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":["7267","RENT","\u9810\u7e73\u79df\u91d1",9,1358,"MO","1",1358,"2","2020-01-13 10:17:35","2","2020-01-13 10:17:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:17:35","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":["7267","RENT","\u9810\u7e73\u79df\u91d1",10,1358,"MO","1",1358,"2","2020-01-13 10:17:35","2","2020-01-13 10:17:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:17:35","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":["7267","RENT","\u9810\u7e73\u79df\u91d1",11,1358,"MO","1",1358,"2","2020-01-13 10:17:35","2","2020-01-13 10:17:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:17:35","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":["7267","RENT","\u9810\u7e73\u79df\u91d1",12,1358,"MO","1",1358,"2","2020-01-13 10:17:35","2","2020-01-13 10:17:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:17:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[16296,0,"7267"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-13 10:17:35","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":[133,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P206917","2020-01-13 10:17:35",16296,"2","2020-01-13 10:17:35","2","2020-01-13 10:17:35","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:17:35","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":["6917","DEPOSIT",null,"PAID","2020-01-13 10:17:35",0,"2","2020-01-13 10:17:35","2","2020-01-13 10:17:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:17:35","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":["6917","INVOICE","7267","PAID","2020-01-13 10:17:35",16296,"2","2020-01-13 10:17:35","2","2020-01-13 10:17:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:23:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:29:00","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":273,"customer_code":"C170273","identity_type":"PERSONAL","identity_id":"M432924(A)","title":"Mr","lastname":"Ye","firstname":"Xiaodong","companyname":"","email":null,"tel":"64330476","address":"\u6df1\u5733\u5e02\u7f85\u6e56\u7f85\u82b3\u6751641\u865f","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"935.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-17","renew_room_key":"133,50419,076,34754","renew_remark":"6 months contract. Storage rental paid by cash on July 16, 2019. Storage deposit transferred from agreement A12-CT194175 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195482, \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":"38","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"38","room_code":"A38","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-17","rent_from":"2020-01-17","rent_to":"2020-07-16","delivery_service":"0","remark":"6 months contract. Storage rental paid by cash on Jan 13, 2020. Storage deposit transferred from agreement A12-CT195482 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":5610,"final_order_total":5610,"location_id":"1","branch_id":"1","company_id":"1","room_key":"133,50419,076,34754","order_product":[],"pass":true}},"first_order_id":"4175","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> A38 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"935.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:29:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",273,"NEW","A12-CT206940",1098,935,0,0,"6","6",5610,5610,5610,"2020-01-13 10:29:01","0",null,null,null,"2020-01-17","2020-07-16","6 months contract. Storage rental paid by cash on Jan 13, 2020. Storage deposit transferred from agreement A12-CT195482 to this agreement.\r\n","2020-01-17","16",0,null,0,"0","2","2020-01-13 10:29:00","2","2020-01-13 10:29:00","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"133,50419,076,34754","C170273","PERSONAL","Mr","\/r+nw+Hrwr71g2M2LIxhog==","j4rd614DPInD4J8v51pwNQ==","","7vj0H72vjkFMWgxfv67tgrC\/+xkA9o1PyCaKRXLdncQ=","7Zmx0g\/HDuZGW5h5ebP8gQ==",null,"vNoJv2kv\/w7WxmBjh1Rztg==",null,1,"4175"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:29:01","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":["6940","72","8","38","%","9.93",109.0314,"2","2020-01-13 10:29:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:29:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6940","38","1098.0",989,"2","2020-01-13 10:29:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:29:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-17","2020-07-16","38"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 10:29:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6940",273,"SETTLED","A12-I207268","2020-01-13 10:29:00","2020-01-17","2","2020-01-13 10:29:00","2","2020-01-13 10:29:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:29:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7268","RENT","\u9810\u7e73\u79df\u91d1",1,935,"MO","1",935,"2","2020-01-13 10:29:00","2","2020-01-13 10:29:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:29:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7268","RENT","\u9810\u7e73\u79df\u91d1",2,935,"MO","1",935,"2","2020-01-13 10:29:00","2","2020-01-13 10:29:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:29:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7268","RENT","\u9810\u7e73\u79df\u91d1",3,935,"MO","1",935,"2","2020-01-13 10:29:00","2","2020-01-13 10:29:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:29:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7268","RENT","\u9810\u7e73\u79df\u91d1",4,935,"MO","1",935,"2","2020-01-13 10:29:00","2","2020-01-13 10:29:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:29:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7268","RENT","\u9810\u7e73\u79df\u91d1",5,935,"MO","1",935,"2","2020-01-13 10:29:00","2","2020-01-13 10:29:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:29:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7268","RENT","\u9810\u7e73\u79df\u91d1",6,935,"MO","1",935,"2","2020-01-13 10:29:00","2","2020-01-13 10:29:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:29:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5610,0,"7268"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-13 10:29:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[273,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P206918","2020-01-13 10:29:00",5610,"2","2020-01-13 10:29:00","2","2020-01-13 10:29:00","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:29:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6918","DEPOSIT",null,"PAID","2020-01-13 10:29:00",0,"2","2020-01-13 10:29:00","2","2020-01-13 10:29:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:29:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6918","INVOICE","7268","PAID","2020-01-13 10:29:00",5610,"2","2020-01-13 10:29:00","2","2020-01-13 10:29:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 10:54:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 11:42:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 11:49:33","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":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":616,"customer_code":"C170616","identity_type":"PERSONAL","identity_id":"Z103280(2)","title":"Ms","lastname":"Yiu","firstname":"Kit Ling","companyname":"","email":"jessieyiu@hotmail.com","tel":"96981481","address":"Room 3611, Tung On House, Lei Tung Estate, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-18","renew_room_key":"054,29997","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 26, 2019. Storage deposit transferred from agreement A14-CT196602 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196782, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"686","room_code":"N03","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-18","rent_from":"2020-01-18","rent_to":"2020-02-17","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 12, 2020. Storage deposit transferred from agreement A14-CT196782 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,29997","order_product":[],"pass":true}},"first_order_id":"4846","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> N03 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 11:49:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",616,"NEW","A14-CT206941",598,598,0,0,"1","1",598,598,598,"2020-01-13 11:49:33","0",null,null,null,"2020-01-18","2020-02-17","1 month contract. Storage rental paid by bank transfer on January 12, 2020. Storage deposit transferred from agreement A14-CT196782 to this agreement.","2020-01-18","12",0,null,0,"0","2","2020-01-13 11:49:33","2","2020-01-13 11:49:33","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,29997","C170616","PERSONAL","Ms","p8\/VerPta7kqG1jT7vONTw==","izJVo3RcQVJ02PBMypGKnQ==","","ENXImS4KdDZt3vDBAvbUseTFoyYV41Dwmv5vVbvIdZhZx8O1O37lzRS04mcx6FS\/yI73wDF8ltcsMz9AVNZttg==","a4NDOVya9cf76uWohlEcuA==","6FqTwPEFt8u2TYXg83c9argn0qm0Ubm3\/Tw0rg\/hkrw=","9XfgXEI68THR3GL9uXD8Pg==",null,1,"4846"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 11:49:33","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":["6941","686","598.0","598.00","2","2020-01-13 11:49:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 11:49:33","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-18","2020-02-17","686"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 11:49:33","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":["6941",616,"SETTLED","A14-I207269","2020-01-13 11:49:33","2020-01-18","2","2020-01-13 11:49:33","2","2020-01-13 11:49:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 11:49:33","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":["7269","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-01-13 11:49:33","2","2020-01-13 11:49:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 11:49:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7269"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-13 11:49:33","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":[616,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206919","2020-01-13 11:49:33",598,"2","2020-01-13 11:49:33","2","2020-01-13 11:49:33","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 11:49:33","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":["6919","DEPOSIT",null,"PAID","2020-01-13 11:49:33",0,"2","2020-01-13 11:49:33","2","2020-01-13 11:49:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 11:49:33","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":["6919","INVOICE","7269","PAID","2020-01-13 11:49:33",598,"2","2020-01-13 11:49:33","2","2020-01-13 11:49:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 12:54:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 13:19:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 13:19:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 13:34: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":"filter1=2&filter2=1000&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1032","master_room_id":"117","room_code":"A05-030"}],"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> A05-030 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1857.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":"0","identity_type":"BUSINESS","identity_id":"69808784","title":"Mr","lastname":"Halliday","firstname":"David Jeffrey","companyname":"Lancashire Decorating Limited","email":"hallid@hotmail.com","tel":"63247121","address":"Unit 305-7, 3\/F, Laford Centre, 838 Lai Chi Kok Road, Cheung Sha Wan, Kowloon","pass":true,"customer_id":"1000","customer_code":"C181000","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1032","room_code":"A05-030","retail_price":"1857.0","discounted_price":"1857.00","location_id":"4"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1857,"deposit":3714,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2500,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3071.00","warehousing_date":"2020-01-14","rent_from":"2020-01-14","rent_to":"2020-02-13","delivery_service":"0","remark":"1 month contract. Change unit A05-040 to 05-030. Storage rental and deposit $3071 transferred from agreement A05-CT196797. Remaining balance $2500 paid by cash on January 13.","paymethod":"CASH","paymethod2":"CASH","discount_deduct":3071,"order_total":5571,"final_order_total":2500,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012385366","order_product":[],"pass":true}},"roughly_size":"24","total_discounted_price":"1857.00","deposit":"3714.00","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 13:34: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","4","1000","NEW","A05-CT206942",1857,1857,3714,0,"1","1",2500,5571,2500,"2020-01-13 13:34:58","0",null,null,null,"2020-01-14","2020-02-13","1 month contract. Change unit A05-040 to 05-030. Storage rental and deposit $3071 transferred from agreement A05-CT196797. Remaining balance $2500 paid by cash on January 13.","2020-01-14","24",0,null,3071,"3071.00","2","2020-01-13 13:34:57","2","2020-01-13 13:34:57","CASH","","","","CASH","","","",null,0,"0012385366","C181000","BUSINESS","Mr","uH6SR3Usr5pjl15fgk2xBQ==","3hC5jWxTyseC0UGI0aOkAg==","Lancashire Decorating Limited","2Z3GrSs8TtWmHfqJQHcTHSj5PkrfAJG3icQpP+dHb4pR6r6gZDlFua9f0SQRB4T7nesXzD6ZQbIz9hPFFQWgZxCafnJaWissyZGlcu8xHaw=","6vfNYC\/zokp3t8YiOOVHSg==","hDQSd3rKdaAlD3TTnjhsvRH6brF\/H73VmPFKao018qs=",null,"c4A7Vexe0m66GXy70hIIWA=="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 13:34: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":["6942","1032","1857.0","1857.00","2","2020-01-13 13:34:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 13:34: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":["2020-01-14","2020-02-13","1032"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 13:34: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":["6942","A05-D205250","PAID",3714,0,"2020-02-13","2020-01-13 13:34:57","2020-01-13 13:34:57","2","2020-01-13 13:34:57","2","2020-01-13 13:34:57","1000"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 13:34: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":["6942","1000","SETTLED","A05-I207270","2020-01-13 13:34:57","2020-01-14","2","2020-01-13 13:34:57","2","2020-01-13 13:34:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 13:34: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":["7270","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-01-13 13:34:57","2","2020-01-13 13:34:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 13:34:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[0,0,"7270"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-13 13:34: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":["1000","CASH","","","","CASH","","","","PAID","P206920","2020-01-13 13:34:57",3714,"2","2020-01-13 13:34:57","2","2020-01-13 13:34:57","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 13:34: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":["6920","DEPOSIT","5250","PAID","2020-01-13 13:34:57",3714,"2","2020-01-13 13:34:57","2","2020-01-13 13:34:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 13:34: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":["6920","INVOICE","7270","PAID","2020-01-13 13:34:57",0,"2","2020-01-13 13:34:57","2","2020-01-13 13:34:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 13:42:26","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ?, `customer_companyname` = ? where id = ?","parameters":["VOID","0012385366","1 month contract. Change unit A05-040 to 05-030. Storage rental and deposit $3071 transferred from agreement A05-CT196797. Remaining balance $2500 paid by cash on January 13.","2020-01-13 13:42:26","2","3hC5jWxTyseC0UGI0aOkAg==","uH6SR3Usr5pjl15fgk2xBQ==","hDQSd3rKdaAlD3TTnjhsvRH6brF\/H73VmPFKao018qs=","6vfNYC\/zokp3t8YiOOVHSg==","2Z3GrSs8TtWmHfqJQHcTHSj5PkrfAJG3icQpP+dHb4pR6r6gZDlFua9f0SQRB4T7nesXzD6ZQbIz9hPFFQWgZxCafnJaWissyZGlcu8xHaw=","Lancashire Decorating Limited",6942]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 13:46:12","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=319&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1032","master_room_id":"117","room_code":"A05-030"}],"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> A05-030 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1857.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":"0","identity_type":"BUSINESS","identity_id":"69808784","title":"Mr","lastname":"Halliday","firstname":"David Jeffrey","companyname":"Lancashire Decorating Limited","email":"hallid@hotmail.com","tel":"63247121","address":"Unit 305-7, 3\/F, Laford Centre, 838 Lai Chi Kok Road, Cheung Sha Wan, Kowloon","pass":true,"customer_id":"1000","customer_code":"C181000","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1032","room_code":"A05-030","retail_price":"1857.0","discounted_price":"1857.00","location_id":"4"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1857,"deposit":3714,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2934,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2637.00","warehousing_date":"2020-01-22","rent_from":"2020-01-22","rent_to":"2020-02-21","delivery_service":"0","remark":"1 month contract. Change unit A05-040 to 05-030. Storage rental and deposit $2637 transferred from agreement A05-CT196797. Remaining balance $2934 paid by cash on January 13.","paymethod":"CASH","paymethod2":"CASH","discount_deduct":2637,"order_total":5571,"final_order_total":2934,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012385366","order_product":[],"pass":true}},"roughly_size":"24","total_discounted_price":"1857.00","deposit":"3714.00","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 13:46:12","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","1000","NEW","A05-CT206943",1857,1857,3714,0,"1","1",2934,5571,2934,"2020-01-13 13:46:12","0",null,null,null,"2020-01-22","2020-02-21","1 month contract. Change unit A05-040 to 05-030. Storage rental and deposit $2637 transferred from agreement A05-CT196797. Remaining balance $2934 paid by cash on January 13.","2020-01-22","24",0,null,2637,"2637.00","2","2020-01-13 13:46:12","2","2020-01-13 13:46:12","CASH","","","","CASH","","","",null,0,"0012385366","C181000","BUSINESS","Mr","uH6SR3Usr5pjl15fgk2xBQ==","3hC5jWxTyseC0UGI0aOkAg==","Lancashire Decorating Limited","2Z3GrSs8TtWmHfqJQHcTHSj5PkrfAJG3icQpP+dHb4pR6r6gZDlFua9f0SQRB4T7nesXzD6ZQbIz9hPFFQWgZxCafnJaWissyZGlcu8xHaw=","6vfNYC\/zokp3t8YiOOVHSg==","hDQSd3rKdaAlD3TTnjhsvRH6brF\/H73VmPFKao018qs=",null,"c4A7Vexe0m66GXy70hIIWA=="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 13:46:12","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":["6943","1032","1857.0","1857.00","2","2020-01-13 13:46:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 13:46:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-22","2020-02-21","1032"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 13:46:12","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":["6943","A05-D205251","PAID",3714,0,"2020-02-21","2020-01-13 13:46:12","2020-01-13 13:46:12","2","2020-01-13 13:46:12","2","2020-01-13 13:46:12","1000"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 13:46:12","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":["6943","1000","SETTLED","A05-I207271","2020-01-13 13:46:12","2020-01-22","2","2020-01-13 13:46:12","2","2020-01-13 13:46:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 13:46:12","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":["7271","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-01-13 13:46:12","2","2020-01-13 13:46:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 13:46:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[0,0,"7271"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-13 13:46:12","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":["1000","CASH","","","","CASH","","","","PAID","P206921","2020-01-13 13:46:12",3714,"2","2020-01-13 13:46:12","2","2020-01-13 13:46:12","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 13:46:12","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":["6921","DEPOSIT","5251","PAID","2020-01-13 13:46:12",3714,"2","2020-01-13 13:46:12","2","2020-01-13 13:46:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 13:46:12","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":["6921","INVOICE","7271","PAID","2020-01-13 13:46:12",0,"2","2020-01-13 13:46:12","2","2020-01-13 13:46:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 14:01:45","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 14:03:28","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 14:27:57","login_id":"1","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 14:47:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:19:07","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":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1032","master_room_id":"117","room_code":"A05-030"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":468,"customer_code":"C170468","identity_type":"PERSONAL","identity_id":"P638183(2)","title":"Ms","lastname":"Mowbray-d'Arbela","firstname":"Melissa P.","companyname":"","email":"maven@netvigator.com","tel":"93054259","address":"27 Tung Tau Wan Rd., Stanley, HK","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"12498.0","renew_rent_month":"12","renew_warehousing_date":"2020-01-05","renew_room_key":"0005796905,088,29737","renew_remark":"12 months contract. Storage rental will be paid by cheque. Storage deposit transferred from agreement A05-CT182615 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT194338, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"122","order_discount":[],"order_room":[{"room_id":"1024","room_code":"A05-022","retail_price":"6162.0","discounted_price":"6162.00","location_id":"4"},{"room_id":"1023","room_code":"A05-021","retail_price":"1.0","discounted_price":"1.00","location_id":"4"},{"room_id":"1098","room_code":"A05-096","retail_price":"2188.0","discounted_price":"2188.00","location_id":"4"},{"room_id":"1097","room_code":"A05-095","retail_price":"2188.0","discounted_price":"2188.00","location_id":"4"}],"roughly_size":"200","total_retail_price":10539,"total_discounted_price":12498,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":149976,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-05","rent_from":"2020-01-05","rent_to":"2021-01-04","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on January 10, 2020. Storage deposit transferred from agreement A05-CT194338 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":149976,"final_order_total":149976,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0005796905,088,29737","order_product":[],"pass":true}},"first_order_id":4338,"selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-022 <\/td>\r\n\t\t\t\t\t 8X10X7 <\/td>\r\n\t\t\t\t\t $6162.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> A05-021 <\/td>\r\n\t\t\t\t\t 6X10X7 <\/td>\r\n\t\t\t\t\t $1.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> A05-096 <\/td>\r\n\t\t\t\t\t 5X6X7 <\/td>\r\n\t\t\t\t\t $2188.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> A05-095 <\/td>\r\n\t\t\t\t\t 5X6X7 <\/td>\r\n\t\t\t\t\t $2188.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":"200","total_discounted_price":"12498.00","deposit":"0.00","total_retail_price":"10539.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",468,"NEW","A05-CT206944",10539,12498,0,0,"12","12",149976,149976,149976,"2020-01-13 15:19:08","0",null,null,null,"2020-01-05","2021-01-04","12 months contract. Storage rental paid by bank transfer on January 10, 2020. Storage deposit transferred from agreement A05-CT194338 to this agreement. ","2020-01-05","200",0,null,0,"0","2","2020-01-13 15:19:07","2","2020-01-13 15:19:07","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005796905,088,29737","C170468","PERSONAL","Ms","XTcxR8TUP2CPuGRWybxfwg==","jOCK56zq8bvX55lGpqjRUPVZfEyHf7r5bJPDGCJl4Bc=","","iPtMK771tBxHdGaOqJG\/JmpMSfceZbq29xtlC7QGkSH+xDXmgmNi5Lw3R\/BGkAP4","R90UJtXDfxrcO4efMGqh8A==","dsZe70nz\/aQUyCyfMEk+4ThA3ree89BTRpYCVsmtIaY=","prCdGtnhFWAEzKSD9b+zcg==",null,1,4338]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6944","1024","6162.0","6162.00","2","2020-01-13 15:19:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:19:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-05","2021-01-04","1024"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 15:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6944","1023","1.0","1.00","2","2020-01-13 15:19:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:19:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-05","2021-01-04","1023"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 15:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6944","1098","2188.0","2188.00","2","2020-01-13 15:19:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:19:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-05","2021-01-04","1098"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 15:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6944","1097","2188.0","2188.00","2","2020-01-13 15:19:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:19:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-05","2021-01-04","1097"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 15:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6944",468,"SETTLED","A05-I207272","2020-01-13 15:19:07","2020-01-05","2","2020-01-13 15:19:07","2","2020-01-13 15:19:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7272","RENT","\u9810\u7e73\u79df\u91d1",1,12498,"MO","1",12498,"2","2020-01-13 15:19:07","2","2020-01-13 15:19:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7272","RENT","\u9810\u7e73\u79df\u91d1",2,12498,"MO","1",12498,"2","2020-01-13 15:19:07","2","2020-01-13 15:19:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7272","RENT","\u9810\u7e73\u79df\u91d1",3,12498,"MO","1",12498,"2","2020-01-13 15:19:07","2","2020-01-13 15:19:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7272","RENT","\u9810\u7e73\u79df\u91d1",4,12498,"MO","1",12498,"2","2020-01-13 15:19:07","2","2020-01-13 15:19:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7272","RENT","\u9810\u7e73\u79df\u91d1",5,12498,"MO","1",12498,"2","2020-01-13 15:19:07","2","2020-01-13 15:19:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7272","RENT","\u9810\u7e73\u79df\u91d1",6,12498,"MO","1",12498,"2","2020-01-13 15:19:07","2","2020-01-13 15:19:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7272","RENT","\u9810\u7e73\u79df\u91d1",7,12498,"MO","1",12498,"2","2020-01-13 15:19:07","2","2020-01-13 15:19:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7272","RENT","\u9810\u7e73\u79df\u91d1",8,12498,"MO","1",12498,"2","2020-01-13 15:19:07","2","2020-01-13 15:19:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7272","RENT","\u9810\u7e73\u79df\u91d1",9,12498,"MO","1",12498,"2","2020-01-13 15:19:07","2","2020-01-13 15:19:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7272","RENT","\u9810\u7e73\u79df\u91d1",10,12498,"MO","1",12498,"2","2020-01-13 15:19:07","2","2020-01-13 15:19:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7272","RENT","\u9810\u7e73\u79df\u91d1",11,12498,"MO","1",12498,"2","2020-01-13 15:19:07","2","2020-01-13 15:19:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7272","RENT","\u9810\u7e73\u79df\u91d1",12,12498,"MO","1",12498,"2","2020-01-13 15:19:07","2","2020-01-13 15:19:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:19:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[149976,0,"7272"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-13 15:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[468,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206922","2020-01-13 15:19:07",149976,"2","2020-01-13 15:19:07","2","2020-01-13 15:19:07","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6922","DEPOSIT",null,"PAID","2020-01-13 15:19:07",0,"2","2020-01-13 15:19:07","2","2020-01-13 15:19:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:19:08","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6922","INVOICE","7272","PAID","2020-01-13 15:19:07",149976,"2","2020-01-13 15:19:07","2","2020-01-13 15:19:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:21:07","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":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1032","master_room_id":"117","room_code":"A05-030"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":468,"customer_code":"C170468","identity_type":"PERSONAL","identity_id":"P638183(2)","title":"Ms","lastname":"Mowbray-d'Arbela","firstname":"Melissa P.","companyname":"","email":"maven@netvigator.com","tel":"93054259","address":"27 Tung Tau Wan Rd., Stanley, HK","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4127.0","renew_rent_month":"12","renew_warehousing_date":"2020-01-20","renew_room_key":"0005796905,088,29737","renew_remark":"12 months contract. Storage rental will be paid by cheque. Storage deposit transferred from agreement A05-CT182730 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT194339, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"117","order_discount":[],"order_room":[{"room_id":"1099","room_code":"A05-097","retail_price":"2728.0","discounted_price":"2728.00","location_id":"4"},{"room_id":"1096","room_code":"A05-094","retail_price":"1857.0","discounted_price":"1857.00","location_id":"4"}],"roughly_size":"60","total_retail_price":4585,"total_discounted_price":4127,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":49524,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-20","rent_from":"2020-01-20","rent_to":"2021-01-19","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on January 11, 2020. Storage deposit transferred from agreement A05-CT194339 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":49524,"final_order_total":49524,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0005796905,088,29737","order_product":[],"pass":true}},"first_order_id":4339,"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> A05-097 <\/td>\r\n\t\t\t\t\t 6X6X7 <\/td>\r\n\t\t\t\t\t $2728.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> A05-094 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1857.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","roughly_size":"60","total_discounted_price":"4127.0","deposit":"0","total_retail_price":"4585.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:21:07","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",468,"NEW","A05-CT206945",4585,4127,0,0,"12","12",49524,49524,49524,"2020-01-13 15:21:07","0",null,null,null,"2020-01-20","2021-01-19","12 months contract. Storage rental paid by bank transfer on January 11, 2020. Storage deposit transferred from agreement A05-CT194339 to this agreement.","2020-01-20","60",0,null,0,"0","2","2020-01-13 15:21:07","2","2020-01-13 15:21:07","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"0005796905,088,29737","C170468","PERSONAL","Ms","XTcxR8TUP2CPuGRWybxfwg==","jOCK56zq8bvX55lGpqjRUPVZfEyHf7r5bJPDGCJl4Bc=","","iPtMK771tBxHdGaOqJG\/JmpMSfceZbq29xtlC7QGkSH+xDXmgmNi5Lw3R\/BGkAP4","R90UJtXDfxrcO4efMGqh8A==","dsZe70nz\/aQUyCyfMEk+4ThA3ree89BTRpYCVsmtIaY=","prCdGtnhFWAEzKSD9b+zcg==",null,1,4339]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:21:07","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":["6945","1099","2728.0","2728.00","2","2020-01-13 15:21:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:21:07","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-20","2021-01-19","1099"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 15:21:07","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":["6945","1096","1857.0","1857.00","2","2020-01-13 15:21:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:21:07","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-20","2021-01-19","1096"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 15:21:07","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":["6945",468,"SETTLED","A05-I207273","2020-01-13 15:21:07","2020-01-20","2","2020-01-13 15:21:07","2","2020-01-13 15:21:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:21:07","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":["7273","RENT","\u9810\u7e73\u79df\u91d1",1,4127,"MO","1",4127,"2","2020-01-13 15:21:07","2","2020-01-13 15:21:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:21:07","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":["7273","RENT","\u9810\u7e73\u79df\u91d1",2,4127,"MO","1",4127,"2","2020-01-13 15:21:07","2","2020-01-13 15:21:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:21:07","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":["7273","RENT","\u9810\u7e73\u79df\u91d1",3,4127,"MO","1",4127,"2","2020-01-13 15:21:07","2","2020-01-13 15:21:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:21:07","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":["7273","RENT","\u9810\u7e73\u79df\u91d1",4,4127,"MO","1",4127,"2","2020-01-13 15:21:07","2","2020-01-13 15:21:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:21:07","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":["7273","RENT","\u9810\u7e73\u79df\u91d1",5,4127,"MO","1",4127,"2","2020-01-13 15:21:07","2","2020-01-13 15:21:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:21:07","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":["7273","RENT","\u9810\u7e73\u79df\u91d1",6,4127,"MO","1",4127,"2","2020-01-13 15:21:07","2","2020-01-13 15:21:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:21:07","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":["7273","RENT","\u9810\u7e73\u79df\u91d1",7,4127,"MO","1",4127,"2","2020-01-13 15:21:07","2","2020-01-13 15:21:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:21:07","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":["7273","RENT","\u9810\u7e73\u79df\u91d1",8,4127,"MO","1",4127,"2","2020-01-13 15:21:07","2","2020-01-13 15:21:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:21:07","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":["7273","RENT","\u9810\u7e73\u79df\u91d1",9,4127,"MO","1",4127,"2","2020-01-13 15:21:07","2","2020-01-13 15:21:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:21:07","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":["7273","RENT","\u9810\u7e73\u79df\u91d1",10,4127,"MO","1",4127,"2","2020-01-13 15:21:07","2","2020-01-13 15:21:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:21:07","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":["7273","RENT","\u9810\u7e73\u79df\u91d1",11,4127,"MO","1",4127,"2","2020-01-13 15:21:07","2","2020-01-13 15:21:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:21:07","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":["7273","RENT","\u9810\u7e73\u79df\u91d1",12,4127,"MO","1",4127,"2","2020-01-13 15:21:07","2","2020-01-13 15:21:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:21:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[49524,0,"7273"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-13 15:21:07","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":[468,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P206923","2020-01-13 15:21:07",49524,"2","2020-01-13 15:21:07","2","2020-01-13 15:21:07","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:21:07","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":["6923","DEPOSIT",null,"PAID","2020-01-13 15:21:07",0,"2","2020-01-13 15:21:07","2","2020-01-13 15:21:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:21:07","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":["6923","INVOICE","7273","PAID","2020-01-13 15:21:07",49524,"2","2020-01-13 15:21:07","2","2020-01-13 15:21:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:49","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":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&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":"1032","master_room_id":"117","room_code":"A05-030"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":468,"customer_code":"C170468","identity_type":"PERSONAL","identity_id":"P638183(2)","title":"Ms","lastname":"Mowbray-d'Arbela","firstname":"Melissa P.","companyname":"","email":"maven@netvigator.com","tel":"93054259","address":"27 Tung Tau Wan Rd., Stanley, HK","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"6618.0","renew_rent_month":"12","renew_warehousing_date":"2020-01-25","renew_room_key":"134,53533","renew_remark":"12 months contract. Storage rental will be paid by cheque. Storage deposit transferred from agreement A14-CT183181 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT194337, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"800","room_code":"N44","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"799","room_code":"N43","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"798","room_code":"N42","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"724","room_code":"N41","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"723","room_code":"N40","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"719","room_code":"N36","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"718","room_code":"N35","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"717","room_code":"N34","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"716","room_code":"N33","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"715","room_code":"N32","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"120","total_retail_price":9980,"total_discounted_price":6618,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":79416,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-25","rent_from":"2020-01-25","rent_to":"2021-01-24","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on January 11, 2020. Storage deposit transferred from agreement A14-CT194337 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":79416,"final_order_total":79416,"location_id":"2","branch_id":"1","company_id":"1","room_key":"134,53533","order_product":[],"pass":true}},"first_order_id":4337,"selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\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> N44 <\/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\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> N43 <\/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\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> N42 <\/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\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> N41 <\/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\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> N40 <\/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\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> N36 <\/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\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> N35 <\/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\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> N34 <\/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\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> N33 <\/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\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> N32 <\/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\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":"120","total_discounted_price":"6618.0","deposit":"0","total_retail_price":"9980.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",468,"NEW","A14-CT206946",9980,6618,0,0,"12","12",79416,79416,79416,"2020-01-13 15:23:50","0",null,null,null,"2020-01-25","2021-01-24","12 months contract. Storage rental paid by bank transfer on January 11, 2020. Storage deposit transferred from agreement A14-CT194337 to this agreement.","2020-01-25","120",0,null,0,"0","2","2020-01-13 15:23:49","2","2020-01-13 15:23:49","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"134,53533","C170468","PERSONAL","Ms","XTcxR8TUP2CPuGRWybxfwg==","jOCK56zq8bvX55lGpqjRUPVZfEyHf7r5bJPDGCJl4Bc=","","iPtMK771tBxHdGaOqJG\/JmpMSfceZbq29xtlC7QGkSH+xDXmgmNi5Lw3R\/BGkAP4","R90UJtXDfxrcO4efMGqh8A==","dsZe70nz\/aQUyCyfMEk+4ThA3ree89BTRpYCVsmtIaY=","prCdGtnhFWAEzKSD9b+zcg==",null,1,4337]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6946","800","998.0","998.00","2","2020-01-13 15:23:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-25","2021-01-24","800"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6946","799","998.0","998.00","2","2020-01-13 15:23:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-25","2021-01-24","799"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6946","798","998.0","998.00","2","2020-01-13 15:23:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-25","2021-01-24","798"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6946","724","998.0","998.00","2","2020-01-13 15:23:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-25","2021-01-24","724"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6946","723","998.0","998.00","2","2020-01-13 15:23:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-25","2021-01-24","723"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6946","719","998.0","998.00","2","2020-01-13 15:23:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-25","2021-01-24","719"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6946","718","998.0","998.00","2","2020-01-13 15:23:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-25","2021-01-24","718"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6946","717","998.0","998.00","2","2020-01-13 15:23:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-25","2021-01-24","717"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6946","716","998.0","998.00","2","2020-01-13 15:23:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-25","2021-01-24","716"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6946","715","998.0","998.00","2","2020-01-13 15:23:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-25","2021-01-24","715"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6946",468,"SETTLED","A14-I207274","2020-01-13 15:23:49","2020-01-25","2","2020-01-13 15:23:49","2","2020-01-13 15:23:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7274","RENT","\u9810\u7e73\u79df\u91d1",1,6618,"MO","1",6618,"2","2020-01-13 15:23:49","2","2020-01-13 15:23:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7274","RENT","\u9810\u7e73\u79df\u91d1",2,6618,"MO","1",6618,"2","2020-01-13 15:23:49","2","2020-01-13 15:23:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7274","RENT","\u9810\u7e73\u79df\u91d1",3,6618,"MO","1",6618,"2","2020-01-13 15:23:49","2","2020-01-13 15:23:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7274","RENT","\u9810\u7e73\u79df\u91d1",4,6618,"MO","1",6618,"2","2020-01-13 15:23:49","2","2020-01-13 15:23:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7274","RENT","\u9810\u7e73\u79df\u91d1",5,6618,"MO","1",6618,"2","2020-01-13 15:23:49","2","2020-01-13 15:23:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7274","RENT","\u9810\u7e73\u79df\u91d1",6,6618,"MO","1",6618,"2","2020-01-13 15:23:49","2","2020-01-13 15:23:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7274","RENT","\u9810\u7e73\u79df\u91d1",7,6618,"MO","1",6618,"2","2020-01-13 15:23:49","2","2020-01-13 15:23:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7274","RENT","\u9810\u7e73\u79df\u91d1",8,6618,"MO","1",6618,"2","2020-01-13 15:23:49","2","2020-01-13 15:23:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7274","RENT","\u9810\u7e73\u79df\u91d1",9,6618,"MO","1",6618,"2","2020-01-13 15:23:49","2","2020-01-13 15:23:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7274","RENT","\u9810\u7e73\u79df\u91d1",10,6618,"MO","1",6618,"2","2020-01-13 15:23:49","2","2020-01-13 15:23:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7274","RENT","\u9810\u7e73\u79df\u91d1",11,6618,"MO","1",6618,"2","2020-01-13 15:23:49","2","2020-01-13 15:23:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7274","RENT","\u9810\u7e73\u79df\u91d1",12,6618,"MO","1",6618,"2","2020-01-13 15:23:49","2","2020-01-13 15:23:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[79416,0,"7274"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[468,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206924","2020-01-13 15:23:49",79416,"2","2020-01-13 15:23:49","2","2020-01-13 15:23:49","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6924","DEPOSIT",null,"PAID","2020-01-13 15:23:49",0,"2","2020-01-13 15:23:49","2","2020-01-13 15:23:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:23:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6924","INVOICE","7274","PAID","2020-01-13 15:23:49",79416,"2","2020-01-13 15:23:49","2","2020-01-13 15:23:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:28:16","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":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&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":"1032","master_room_id":"117","room_code":"A05-030"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":268,"customer_code":"C170268","identity_type":"PERSONAL","identity_id":"D421709(9)","title":"Ms","lastname":"To","firstname":"Lai Na Linna","companyname":"","email":null,"tel":"67601866","address":"\u9999\u6e2f\u9285\u947c\u7063\u6d77\u90fd\u5927\u5ec81\/F,G Room","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"568.0","renew_rent_month":"3","renew_warehousing_date":"2019-12-01","renew_room_key":"135,20949","renew_remark":"3 months contract. change from unit M73 to N16. Storage deposit ($1396 - 22\/7-21\/8 $998 - 22\/8-30\/8 $306 = $92) transferred from agreement A14-CT195244 to this agreement. Remaining storage rental and deposit (ttl: $2808) paid by cash on August 31, 2019. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195841, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1196.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"699","room_code":"N16","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":1196,"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-01-31","delivery_service":"0","remark":"2 months contract. Storage rental paid by bank transfer on January 11, 2020. Storage deposit $1196 transferred from agreement A14-CT195841 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1196,"final_order_total":1196,"location_id":"2","branch_id":"1","company_id":"1","room_key":"135,20949","order_product":[],"pass":true}},"first_order_id":5841,"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> N16 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:28:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",268,"NEW","A14-CT206947",598,598,0,0,"2","2",1196,1196,1196,"2020-01-13 15:28:16","0",null,null,null,"2019-12-01","2020-01-31","2 months contract. Storage rental paid by bank transfer on January 11, 2020. Storage deposit $1196 transferred from agreement A14-CT195841 to this agreement. ","2019-12-01","12",0,null,0,"0","2","2020-01-13 15:28:16","2","2020-01-13 15:28:16","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"135,20949","C170268","PERSONAL","Ms","tBQgDidK\/yVQr0lAqq5LPA==","ME1HgmDJnR5612zeAsjIHA==","","qpPAjyxsJ0n\/Kv7FGiRhvC+xFVuWjCcB9CtF7z1+Ool5R5f5x36ghU9yZVbmUHmP","G\/s3K1J7FjoHpr9g4onXlQ==",null,"AeHqveSHk3PK4RctlagJHg==",null,1,5841]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:28:16","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":["6947","699","598.0","598.00","2","2020-01-13 15:28:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:28:16","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-01-31","699"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 15:28:16","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":["6947",268,"SETTLED","A14-I207275","2020-01-13 15:28:16","2019-12-01","2","2020-01-13 15:28:16","2","2020-01-13 15:28:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:28:16","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":["7275","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-01-13 15:28:16","2","2020-01-13 15:28:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:28:16","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":["7275","RENT","\u9810\u7e73\u79df\u91d1",2,598,"MO","1",598,"2","2020-01-13 15:28:16","2","2020-01-13 15:28:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:28:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1196,0,"7275"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-13 15:28:16","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":[268,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206925","2020-01-13 15:28:16",1196,"2","2020-01-13 15:28:16","2","2020-01-13 15:28:16","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:28:16","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":["6925","DEPOSIT",null,"PAID","2020-01-13 15:28:16",0,"2","2020-01-13 15:28:16","2","2020-01-13 15:28:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:28:16","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":["6925","INVOICE","7275","PAID","2020-01-13 15:28:16",1196,"2","2020-01-13 15:28:16","2","2020-01-13 15:28:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:47:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:47:18","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:47:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:51:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:51:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 15:51:47","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:03:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:08:55","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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":718,"customer_code":"C180718","identity_type":"PERSONAL","identity_id":"D563964(7)","title":"Mr","lastname":"Yuen","firstname":"Hong Wa","companyname":"","email":"wienyuen@netvigator.com","tel":"96337798","address":"Flat F, 12\/F, Block 32, Albany Court, Oasis, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1076.0","renew_rent_month":"12","renew_warehousing_date":"2020-01-13","renew_room_key":"055,32268","renew_remark":"12 months contract. Storage rental paid by bank transfer on December 31, 2018. Storage deposit transferred from agreement A18-CT182657 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT194057, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"88","order_discount":[],"order_room":[{"room_id":"909","room_code":"U10","retail_price":"1195.0","discounted_price":"1195.00","location_id":"3"}],"roughly_size":"15","total_retail_price":1195,"total_discounted_price":1076,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":12912,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-13","rent_from":"2020-01-13","rent_to":"2021-01-12","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by bank transfer on January 12, 2020. Storage deposit transferred from agreement A18-CT194057 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":12912,"final_order_total":12912,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,32268","order_product":[],"pass":true}},"first_order_id":4057,"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> U10 <\/td>\r\n\t\t\t\t\t 5X3X7 <\/td>\r\n\t\t\t\t\t $1195.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"15","total_discounted_price":"1076.0","deposit":"0.00","total_retail_price":"1195.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:08:56","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",718,"NEW","A18-CT206948",1195,1076,0,0,"12","12",12912,12912,12912,"2020-01-13 16:08:56","0",null,null,null,"2020-01-13","2021-01-12","13 months contract. Special offer the 13th month free. Storage rental paid by bank transfer on January 12, 2020. Storage deposit transferred from agreement A18-CT194057 to this agreement.\r\n","2020-01-13","15",0,null,0,"0","2","2020-01-13 16:08:55","2","2020-01-13 16:08:55","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,32268","C180718","PERSONAL","Mr","qnBzJlmjrsjg97AJJjAOEA==","DtbrOSvE4C7BOu5x4dBFtg==","","TiohxuohjFYIQsAE0UvE7wuDW2WvrA\/BP5XKySsE3p04\/0BizflCB\/AhxrhZrzIS3Tg17T6Xbjr14VZ3kVTp1UEsWv0Psn3Z7MqlG48viV0=","yJHEC57tV3i7U5JBDSvC9g==","Z0C9yWmml+rwnLuED+YDPAdApSqHvkj7tCVqFDHi6TA=","snwth8nllOZXxT6Rwhf38g==",null,1,4057]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:08:56","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":["6948","909","1195.0","1195.00","2","2020-01-13 16:08:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:08:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-13","2021-01-12","909"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 16:08:56","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":["6948",718,"SETTLED","A18-I207276","2020-01-13 16:08:55","2020-01-13","2","2020-01-13 16:08:55","2","2020-01-13 16:08:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:08:56","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":["7276","RENT","\u9810\u7e73\u79df\u91d1",1,1076,"MO","1",1076,"2","2020-01-13 16:08:55","2","2020-01-13 16:08:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:08:56","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":["7276","RENT","\u9810\u7e73\u79df\u91d1",2,1076,"MO","1",1076,"2","2020-01-13 16:08:55","2","2020-01-13 16:08:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:08:56","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":["7276","RENT","\u9810\u7e73\u79df\u91d1",3,1076,"MO","1",1076,"2","2020-01-13 16:08:55","2","2020-01-13 16:08:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:08:56","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":["7276","RENT","\u9810\u7e73\u79df\u91d1",4,1076,"MO","1",1076,"2","2020-01-13 16:08:55","2","2020-01-13 16:08:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:08:56","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":["7276","RENT","\u9810\u7e73\u79df\u91d1",5,1076,"MO","1",1076,"2","2020-01-13 16:08:55","2","2020-01-13 16:08:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:08:56","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":["7276","RENT","\u9810\u7e73\u79df\u91d1",6,1076,"MO","1",1076,"2","2020-01-13 16:08:55","2","2020-01-13 16:08:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:08:56","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":["7276","RENT","\u9810\u7e73\u79df\u91d1",7,1076,"MO","1",1076,"2","2020-01-13 16:08:55","2","2020-01-13 16:08:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:08:56","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":["7276","RENT","\u9810\u7e73\u79df\u91d1",8,1076,"MO","1",1076,"2","2020-01-13 16:08:55","2","2020-01-13 16:08:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:08:56","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":["7276","RENT","\u9810\u7e73\u79df\u91d1",9,1076,"MO","1",1076,"2","2020-01-13 16:08:55","2","2020-01-13 16:08:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:08:56","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":["7276","RENT","\u9810\u7e73\u79df\u91d1",10,1076,"MO","1",1076,"2","2020-01-13 16:08:55","2","2020-01-13 16:08:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:08:56","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":["7276","RENT","\u9810\u7e73\u79df\u91d1",11,1076,"MO","1",1076,"2","2020-01-13 16:08:55","2","2020-01-13 16:08:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:08:56","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":["7276","RENT","\u9810\u7e73\u79df\u91d1",12,1076,"MO","1",1076,"2","2020-01-13 16:08:55","2","2020-01-13 16:08:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:08:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[12912,0,"7276"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-13 16:08:56","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":[718,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206926","2020-01-13 16:08:55",12912,"2","2020-01-13 16:08:55","2","2020-01-13 16:08:55","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:08:56","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":["6926","DEPOSIT",null,"PAID","2020-01-13 16:08:55",0,"2","2020-01-13 16:08:55","2","2020-01-13 16:08:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:08:56","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":["6926","INVOICE","7276","PAID","2020-01-13 16:08:55",12912,"2","2020-01-13 16:08:55","2","2020-01-13 16:08:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:10:42","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","floor_plan_rent_room":[{"room_id":"1032","master_room_id":"117","room_code":"A05-030"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":572,"customer_code":"C170572","identity_type":"BUSINESS","identity_id":"66658554-001-09-17-5","title":"Ms","lastname":"Cheng","firstname":"Cherry","companyname":"Mykita Asia Pacific Limited","email":"a.lo@mykita.com","tel":"39901702","address":"Unit 1603, 16\/F, 8 Observatory Road, Tsim Sha Tsui, Kowloon, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"5268.0","renew_rent_month":"12","renew_warehousing_date":"2019-11-04","renew_room_key":"55, 55576","renew_remark":"12 months contract. Storage rental paid by bank transfer on January 7, 2019. Storage deposit $10656 transferred from agreement SD18-CT171269 to this agreement. **Deduct $3000 in total amount as customer had paid $3000 deposit on October 30, 2017 but not yet deduct.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT194103, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"96","order_discount":[],"order_room":[{"room_id":"869","room_code":"T13","retail_price":"5592.0","discounted_price":"5592.00","location_id":"3"}],"roughly_size":"90","total_retail_price":5592,"total_discounted_price":5268,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":63216,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"5268.00","warehousing_date":"2019-11-04","rent_from":"2019-11-04","rent_to":"2020-12-03","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on January 7, 2019. Storage deposit $10656 transferred from agreement SD18-CT171269 to this agreement. **Deduct $3000 in total amount as customer had paid $3000 deposit on October 30, 2017 but not yet deduct.\r\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT194103, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":5268,"order_total":68484,"final_order_total":63216,"location_id":"3","branch_id":"1","company_id":"1","room_key":"55, 55576","order_product":[],"pass":true}},"first_order_id":4103,"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> T13 <\/td>\r\n\t\t\t\t\t 11.25X8X7 <\/td>\r\n\t\t\t\t\t $5592.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"90","total_discounted_price":"5268.00","deposit":"0.00","total_retail_price":"5592.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:10:43","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",572,"NEW","A18-CT206949",5592,5268,0,0,"13","13",63216,68484,63216,"2020-01-13 16:10:43","0",null,null,null,"2019-11-04","2020-12-03","12 months contract. Storage rental paid by bank transfer on January 7, 2019. Storage deposit $10656 transferred from agreement SD18-CT171269 to this agreement. **Deduct $3000 in total amount as customer had paid $3000 deposit on October 30, 2017 but not yet deduct.\r\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT194103, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","2019-11-04","90",0,null,5268,"5268.00","2","2020-01-13 16:10:42","2","2020-01-13 16:10:42","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"55, 55576","C170572","BUSINESS","Ms","HG6oaZvTPLQje6sdauxpZA==","UCPBCXrBLI9U7KKsPqgmNA==","Mykita Asia Pacific Limited","\/L4duQe11XVGKkSrvJdtf\/H5Fv1rMsJBEXmGQKedJElR+5NV\/GV47t8x9CpJSepM+lEy5Cfnb8gyWaA7aqUMsA==","JeHMD0E\/EYKZ4QCEsOOQsg==","E1G8YIpR4Ph67eGU9W2+DA==",null,"RDDf9+EYNmhODYsNsvmNfJjekNzzJMgZte7sUXTfhIg=",1,4103]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:10:43","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":["6949","869","5592.0","5592.00","2","2020-01-13 16:10:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:10:43","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-11-04","2020-12-03","869"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 16:10:43","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":["6949",572,"SETTLED","A18-I207277","2020-01-13 16:10:42","2019-11-04","2","2020-01-13 16:10:42","2","2020-01-13 16:10:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:10:43","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":["7277","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,5268,"MO","1",5268,"2","2020-01-13 16:10:42","2","2020-01-13 16:10:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:10:43","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":["7277","RENT","\u9810\u7e73\u79df\u91d1",3,5268,"MO","1",5268,"2","2020-01-13 16:10:42","2","2020-01-13 16:10:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:10:43","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":["7277","RENT","\u9810\u7e73\u79df\u91d1",4,5268,"MO","1",5268,"2","2020-01-13 16:10:42","2","2020-01-13 16:10:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:10:43","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":["7277","RENT","\u9810\u7e73\u79df\u91d1",5,5268,"MO","1",5268,"2","2020-01-13 16:10:42","2","2020-01-13 16:10:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:10:43","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":["7277","RENT","\u9810\u7e73\u79df\u91d1",6,5268,"MO","1",5268,"2","2020-01-13 16:10:42","2","2020-01-13 16:10:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:10:43","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":["7277","RENT","\u9810\u7e73\u79df\u91d1",7,5268,"MO","1",5268,"2","2020-01-13 16:10:42","2","2020-01-13 16:10:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:10:43","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":["7277","RENT","\u9810\u7e73\u79df\u91d1",8,5268,"MO","1",5268,"2","2020-01-13 16:10:42","2","2020-01-13 16:10:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:10:43","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":["7277","RENT","\u9810\u7e73\u79df\u91d1",9,5268,"MO","1",5268,"2","2020-01-13 16:10:42","2","2020-01-13 16:10:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:10:43","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":["7277","RENT","\u9810\u7e73\u79df\u91d1",10,5268,"MO","1",5268,"2","2020-01-13 16:10:42","2","2020-01-13 16:10:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:10:43","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":["7277","RENT","\u9810\u7e73\u79df\u91d1",11,5268,"MO","1",5268,"2","2020-01-13 16:10:42","2","2020-01-13 16:10:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:10:43","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":["7277","RENT","\u9810\u7e73\u79df\u91d1",12,5268,"MO","1",5268,"2","2020-01-13 16:10:42","2","2020-01-13 16:10:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:10:43","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":["7277","RENT","\u9810\u7e73\u79df\u91d1",13,5268,"MO","1",5268,"2","2020-01-13 16:10:42","2","2020-01-13 16:10:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:10:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[63216,0,"7277"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-13 16:10:43","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":[572,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206927","2020-01-13 16:10:42",63216,"2","2020-01-13 16:10:42","2","2020-01-13 16:10:42","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:10:43","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":["6927","DEPOSIT",null,"PAID","2020-01-13 16:10:42",0,"2","2020-01-13 16:10:42","2","2020-01-13 16:10:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:10:43","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":["6927","INVOICE","7277","PAID","2020-01-13 16:10:42",63216,"2","2020-01-13 16:10:42","2","2020-01-13 16:10:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:23:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:26:30","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","055,32268","13 months contract. Special offer the 13th month free. Storage rental paid by bank transfer on January 12, 2020. Storage deposit transferred from agreement A18-CT194057 to this agreement.\r\n","2020-01-13 16:26:30","2","DtbrOSvE4C7BOu5x4dBFtg==","qnBzJlmjrsjg97AJJjAOEA==","Z0C9yWmml+rwnLuED+YDPAdApSqHvkj7tCVqFDHi6TA=","yJHEC57tV3i7U5JBDSvC9g==","TiohxuohjFYIQsAE0UvE7wuDW2WvrA\/BP5XKySsE3p04\/0BizflCB\/AhxrhZrzIS3Tg17T6Xbjr14VZ3kVTp1UEsWv0Psn3Z7MqlG48viV0=",6948]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:36:33","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","renew":1,"warehousing":{"1":{"new_customer":"0","customer_id":"718","customer_code":"C180718","identity_type":"PERSONAL","identity_id":"D563964(7)","title":"Mr","lastname":"Yuen","firstname":"Hong Wa","companyname":"","email":"wienyuen@netvigator.com","tel":"96337798","address":"Flat F, 12\/F, Block 32, Albany Court, Oasis, Apleichau, Hong Kong","pass":true,"customer_first_order":false},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1076.0","renew_rent_month":"12","renew_warehousing_date":"2021-01-13","renew_room_key":"055,32268","renew_remark":"13 months contract. Special offer the 13th month free. Storage rental paid by bank transfer on January 12, 2020. Storage deposit transferred from agreement A18-CT194057 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT206948, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"88","order_discount":[],"order_room":[{"room_id":"909","room_code":"U10","retail_price":"1195.0","discounted_price":"1195.00","location_id":"3"}],"roughly_size":"15","total_retail_price":1195,"total_discounted_price":1076,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":12912,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1076","warehousing_date":"2020-01-13","rent_from":"2020-01-13","rent_to":"2021-02-12","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by bank transfer on January 12, 2020. Storage deposit transferred from agreement A18-CT194057 to this agreement.","paymethod":"UNPAID","paymethod2":"UNPAID","discount_deduct":1076,"order_total":13988,"final_order_total":12912,"location_id":"3","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"first_order_id":"4057","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> U10 <\/td>\r\n\t\t\t\t\t 5X3X7 <\/td>\r\n\t\t\t\t\t $1195.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","floor_plan_rent_room":[{"room_id":"909","master_room_id":"88","room_code":"U10"}],"roughly_size":"15","total_discounted_price":"1076","deposit":"0.00","total_retail_price":"1195.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:36: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3","718","NEW","A18-CT206950",1195,1076,0,0,"13","13",12912,13988,12912,"2020-01-13 16:36:34","0",null,null,null,"2020-01-13","2021-02-12","13 months contract. Special offer the 13th month free. Storage rental paid by bank transfer on January 12, 2020. Storage deposit transferred from agreement A18-CT194057 to this agreement.","2020-01-13","15",0,null,1076,"1076","2","2020-01-13 16:36:33","2","2020-01-13 16:36:33","UNPAID","","","","UNPAID","","","",null,0,"","C180718","PERSONAL","Mr","qnBzJlmjrsjg97AJJjAOEA==","DtbrOSvE4C7BOu5x4dBFtg==","","TiohxuohjFYIQsAE0UvE7wuDW2WvrA\/BP5XKySsE3p04\/0BizflCB\/AhxrhZrzIS3Tg17T6Xbjr14VZ3kVTp1UEsWv0Psn3Z7MqlG48viV0=","yJHEC57tV3i7U5JBDSvC9g==","Z0C9yWmml+rwnLuED+YDPAdApSqHvkj7tCVqFDHi6TA=","snwth8nllOZXxT6Rwhf38g==",null,1,"4057"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:36: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":["6950","909","1195.0","1195.00","2","2020-01-13 16:36:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:36: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-01-13","2021-02-12","909"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 16:36: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":["6950","718","NEW","A18-I207278","2020-01-13 16:36:33","2020-01-13","2","2020-01-13 16:36:33","2","2020-01-13 16:36:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:36: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":["7278","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1076,"MO","1",1076,"2","2020-01-13 16:36:33","2","2020-01-13 16:36:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:36: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":["7278","RENT","\u9810\u7e73\u79df\u91d1",3,1076,"MO","1",1076,"2","2020-01-13 16:36:33","2","2020-01-13 16:36:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:36: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":["7278","RENT","\u9810\u7e73\u79df\u91d1",4,1076,"MO","1",1076,"2","2020-01-13 16:36:33","2","2020-01-13 16:36:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:36: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":["7278","RENT","\u9810\u7e73\u79df\u91d1",5,1076,"MO","1",1076,"2","2020-01-13 16:36:33","2","2020-01-13 16:36:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:36: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":["7278","RENT","\u9810\u7e73\u79df\u91d1",6,1076,"MO","1",1076,"2","2020-01-13 16:36:33","2","2020-01-13 16:36:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:36: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":["7278","RENT","\u9810\u7e73\u79df\u91d1",7,1076,"MO","1",1076,"2","2020-01-13 16:36:33","2","2020-01-13 16:36:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:36: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":["7278","RENT","\u9810\u7e73\u79df\u91d1",8,1076,"MO","1",1076,"2","2020-01-13 16:36:33","2","2020-01-13 16:36:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:36: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":["7278","RENT","\u9810\u7e73\u79df\u91d1",9,1076,"MO","1",1076,"2","2020-01-13 16:36:33","2","2020-01-13 16:36:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:36: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":["7278","RENT","\u9810\u7e73\u79df\u91d1",10,1076,"MO","1",1076,"2","2020-01-13 16:36:33","2","2020-01-13 16:36:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:36: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":["7278","RENT","\u9810\u7e73\u79df\u91d1",11,1076,"MO","1",1076,"2","2020-01-13 16:36:33","2","2020-01-13 16:36:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:36: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":["7278","RENT","\u9810\u7e73\u79df\u91d1",12,1076,"MO","1",1076,"2","2020-01-13 16:36:33","2","2020-01-13 16:36:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:36: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":["7278","RENT","\u9810\u7e73\u79df\u91d1",13,1076,"MO","1",1076,"2","2020-01-13 16:36:33","2","2020-01-13 16:36:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:36:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[12912,11836,"7278"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-13 16:37:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:46:49","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","floor_plan_rent_room":[{"room_id":"1032","master_room_id":"117","room_code":"A05-030"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":485,"customer_code":"C170485","identity_type":"BUSINESS","identity_id":"05770131","title":"Mr","lastname":"Cheung","firstname":"Tsun Hin Nicholas","companyname":"Hong Kong Ten Pin Bowling Congress Ltd","email":"hktbc@netvigator.com","tel":"28919786","address":"Rm 2004,Olympic House,1 Stadium Path,So Kon Po,Causeway Bay","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3792.0","renew_rent_month":"2","renew_warehousing_date":"2019-12-10","renew_room_key":"054,46461","renew_remark":"2 months contract. Storage rental paid by cheque on December 23, 2019. Storage deposit transferred from agreement A12-CT195993 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196763, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"194","room_code":"C70","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"},{"room_id":"193","room_code":"C69","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"},{"room_id":"183","room_code":"C59","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"},{"room_id":"182","room_code":"C58","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"64","total_retail_price":4392,"total_discounted_price":3792,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":7584,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-10","rent_from":"2019-12-10","rent_to":"2020-02-09","delivery_service":"0","remark":"2 months contract. Storage rental paid by cheque on January 13, 2020. Storage deposit transferred from agreement A12-CT196763 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":7584,"final_order_total":7584,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,46461","order_product":[],"pass":true}},"first_order_id":"4867","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C70 <\/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> C69 <\/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> C59 <\/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> C58 <\/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":"64","total_discounted_price":"3792.0","deposit":"0","total_retail_price":"4392.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:46:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",485,"NEW","A12-CT206951",4392,3792,0,0,"2","2",7584,7584,7584,"2020-01-13 16:46:50","0",null,null,null,"2019-12-10","2020-02-09","2 months contract. Storage rental paid by cheque on January 13, 2020. Storage deposit transferred from agreement A12-CT196763 to this agreement.\r\n","2019-12-10","64",0,null,0,"0","2","2020-01-13 16:46:49","2","2020-01-13 16:46:49","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"054,46461","C170485","BUSINESS","Mr","qVM+uTcKf4Y9E8s+eih0BbUwgmcs8Dolhv8i5LsTMY4=","vCxOlXQuvOQaoL822H2o\/Q==","Hong Kong Ten Pin Bowling Congress Ltd","R44stv6Dyr9kiU5+jHXzVDEMmdwWNMFGMGD1lN3Z8BcE3\/gfhLYqETOPf5gC7n6eD58k\/jkIWG2yqeoObII72Q==","bk3wscMyfpIXu3yUbW0Avw==","BnxhYhAuTFtuOn0lnUjJwAs5l\/FZMq2vjXv1muEvLVM=",null,"Sd\/ri5Dfmc9LZnNS5Qw5OQ==",1,"4867"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:46:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6951","194","1098.0","1098.00","2","2020-01-13 16:46:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:46:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-10","2020-02-09","194"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 16:46:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6951","193","1098.0","1098.00","2","2020-01-13 16:46:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:46:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-10","2020-02-09","193"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 16:46:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6951","183","1098.0","1098.00","2","2020-01-13 16:46:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:46:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-10","2020-02-09","183"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 16:46:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6951","182","1098.0","1098.00","2","2020-01-13 16:46:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:46:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-10","2020-02-09","182"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 16:46:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6951",485,"SETTLED","A12-I207279","2020-01-13 16:46:49","2019-12-10","2","2020-01-13 16:46:49","2","2020-01-13 16:46:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:46:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7279","RENT","\u9810\u7e73\u79df\u91d1",1,3792,"MO","1",3792,"2","2020-01-13 16:46:49","2","2020-01-13 16:46:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:46:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7279","RENT","\u9810\u7e73\u79df\u91d1",2,3792,"MO","1",3792,"2","2020-01-13 16:46:49","2","2020-01-13 16:46:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:46:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7584,0,"7279"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-13 16:46:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[485,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P206928","2020-01-13 16:46:49",7584,"2","2020-01-13 16:46:49","2","2020-01-13 16:46:49","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:46:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6928","DEPOSIT",null,"PAID","2020-01-13 16:46:49",0,"2","2020-01-13 16:46:49","2","2020-01-13 16:46:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 16:46:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6928","INVOICE","7279","PAID","2020-01-13 16:46:49",7584,"2","2020-01-13 16:46:49","2","2020-01-13 16:46:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 17:34:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 17:37:56","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","floor_plan_rent_room":[{"room_id":"1032","master_room_id":"117","room_code":"A05-030"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":115,"customer_code":"C160115","identity_type":"PERSONAL","identity_id":"D536483(4)","title":"Mr","lastname":"Hui","firstname":"Man Wo","companyname":"","email":"cwn648@yahoo.com.hk","tel":"90130443","address":"Room 711, Tat Yau House, Po Tat Estate, Sau Mou Ping, Kowloon, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1358.0","renew_rent_month":"12","renew_warehousing_date":"2020-01-03","renew_room_key":"055,06565","renew_remark":"12 months contract. Storage rental paid by cheque deposit on January 7, 2019. Storage deposit transferred from agreement A12-CT182605 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT194104, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"11","order_discount":[{"master_room_discount_id":"81","master_room_id":"11","discount_type":"%","price":"1768.00","disocunted_price":"1469.90","discount":"16.86","monthly_deduct":298.0848,"room_id":"366","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"366","room_code":"G07","retail_price":"1768.0","discounted_price":1469.9,"location_id":"1"}],"roughly_size":"24","total_retail_price":1768,"total_discounted_price":1358,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":16296,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-03","rent_from":"2020-01-03","rent_to":"2021-01-02","delivery_service":"0","remark":"12 months contract. Special offer $300 Maxim's voucher. Storage rental paid by cheque deposit on January 13, 2020. Storage deposit transferred from agreement A12-CT194104 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":16296,"final_order_total":16296,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,06565","order_product":[],"pass":true}},"first_order_id":4104,"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> G07 <\/td>\r\n\t\t\t\t\t 4X6X8 <\/td>\r\n\t\t\t\t\t $1768.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \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":"24","total_discounted_price":"1358.0","deposit":"0","total_retail_price":"1768.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 17:37:56","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",115,"NEW","A12-CT206952",1768,1358,0,0,"12","12",16296,16296,16296,"2020-01-13 17:37:56","0",null,null,null,"2020-01-03","2021-01-02","12 months contract. Special offer $300 Maxim's voucher. Storage rental paid by cheque deposit on January 13, 2020. Storage deposit transferred from agreement A12-CT194104 to this agreement.","2020-01-03","24",0,null,0,"0","2","2020-01-13 17:37:56","2","2020-01-13 17:37:56","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,06565","C160115","PERSONAL","Mr","YjJnShHdHHBMxD2y4OQO3g==","Uu\/X0ZeZROrQW5FJIWd7Ww==","","7wZ73jducYWTmjhvgHX9qWXB7q8FoSKQEQm1RCMZ6LQR\/4a995tsTZ04zISrWnlUOujZnzraV0lh\/4JUOKcsuD8KP\/E\/7XGJUWyFxt9Xzoo=","w41C7swGSuMRQZh4tg42xQ==","dirz9LP+Zk7+GSTQYJUv4XJ\/Un4XpZtUmtospQpSrWg=","rL4BgA8Ofk77b8P6yVsA6Q==",null,1,4104]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 17:37:56","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":["6952","81","11","366","%","16.86",298.0848,"2","2020-01-13 17:37:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 17:37:56","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":["6952","366","1768.0",1469.9,"2","2020-01-13 17:37:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 17:37:56","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-03","2021-01-02","366"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 17:37:56","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":["6952",115,"SETTLED","A12-I207280","2020-01-13 17:37:56","2020-01-03","2","2020-01-13 17:37:56","2","2020-01-13 17:37:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 17:37:56","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":["7280","RENT","\u9810\u7e73\u79df\u91d1",1,1358,"MO","1",1358,"2","2020-01-13 17:37:56","2","2020-01-13 17:37:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 17:37:56","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":["7280","RENT","\u9810\u7e73\u79df\u91d1",2,1358,"MO","1",1358,"2","2020-01-13 17:37:56","2","2020-01-13 17:37:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 17:37:56","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":["7280","RENT","\u9810\u7e73\u79df\u91d1",3,1358,"MO","1",1358,"2","2020-01-13 17:37:56","2","2020-01-13 17:37:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 17:37:56","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":["7280","RENT","\u9810\u7e73\u79df\u91d1",4,1358,"MO","1",1358,"2","2020-01-13 17:37:56","2","2020-01-13 17:37:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 17:37:56","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":["7280","RENT","\u9810\u7e73\u79df\u91d1",5,1358,"MO","1",1358,"2","2020-01-13 17:37:56","2","2020-01-13 17:37:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 17:37:56","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":["7280","RENT","\u9810\u7e73\u79df\u91d1",6,1358,"MO","1",1358,"2","2020-01-13 17:37:56","2","2020-01-13 17:37:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 17:37:56","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":["7280","RENT","\u9810\u7e73\u79df\u91d1",7,1358,"MO","1",1358,"2","2020-01-13 17:37:56","2","2020-01-13 17:37:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 17:37:56","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":["7280","RENT","\u9810\u7e73\u79df\u91d1",8,1358,"MO","1",1358,"2","2020-01-13 17:37:56","2","2020-01-13 17:37:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 17:37:56","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":["7280","RENT","\u9810\u7e73\u79df\u91d1",9,1358,"MO","1",1358,"2","2020-01-13 17:37:56","2","2020-01-13 17:37:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 17:37:56","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":["7280","RENT","\u9810\u7e73\u79df\u91d1",10,1358,"MO","1",1358,"2","2020-01-13 17:37:56","2","2020-01-13 17:37:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 17:37:56","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":["7280","RENT","\u9810\u7e73\u79df\u91d1",11,1358,"MO","1",1358,"2","2020-01-13 17:37:56","2","2020-01-13 17:37:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 17:37:56","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":["7280","RENT","\u9810\u7e73\u79df\u91d1",12,1358,"MO","1",1358,"2","2020-01-13 17:37:56","2","2020-01-13 17:37:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 17:37:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[16296,0,"7280"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-13 17:37:56","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":[115,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206929","2020-01-13 17:37:56",16296,"2","2020-01-13 17:37:56","2","2020-01-13 17:37:56","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 17:37:56","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":["6929","DEPOSIT",null,"PAID","2020-01-13 17:37:56",0,"2","2020-01-13 17:37:56","2","2020-01-13 17:37:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 17:37:56","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":["6929","INVOICE","7280","PAID","2020-01-13 17:37:56",16296,"2","2020-01-13 17:37:56","2","2020-01-13 17:37:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 17:44:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 17:52:28","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 18:20:28","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 18:32:35","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","floor_plan_rent_room":[{"room_id":"1063","master_room_id":"108","room_code":"A05-061"}],"_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> A05-061 <\/td>\r\n\t\t\t\t\t 3X3X7 <\/td>\r\n\t\t\t\t\t $1006.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","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"Z088839(8)","title":"Mr","lastname":"HO","firstname":"Ka Yu","companyname":"","email":"ofayyeung@gmail.com","tel":"66922831","address":"Flat %, 3\/F, Kong Fu Court, Aberdeen Centre, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1063","room_code":"A05-061","retail_price":"1006.0","discounted_price":"1006.00","location_id":"4"}],"roughly_size":"9","total_retail_price":1006,"total_discounted_price":775,"deposit":1550,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2287,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"38.00","warehousing_date":"2020-01-14","rent_from":"2020-01-14","rent_to":"2020-02-13","delivery_service":"0","remark":"1 month contract. Special offer 5% \"Rent Now\" discount.Storage rental and deposit paid by EPS on January 13, 2020. Smartcard and padlock provided on January 13, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":38,"order_total":2325,"final_order_total":2287,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0012415172","order_product":[],"pass":true}},"roughly_size":"9","total_discounted_price":"775.00","deposit":"1550.00","total_retail_price":"1006.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 18:32:37","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":["C201488","PERSONAL","Mr","f8XYjME4S7bFUqbGMta6lQ==","Zzv1eRCimQisUlUlw\/fpjg==","","JtEwh55Nke4GFrfYfJpr1Q==","AZDu+wknFwhYjI7GQSWpRWhCL1yTRGiLRIyDoNojrDM=","G0DqRe7qjhKPGx\/xBTTOfkZj9PK2cXtWpGQaKEp9drmf1mJDIa4T67yQK6PXaGroPKe1kXil+G7i0kRQHfNH8Q==","7QBn2SNCjVe7w65Aiokifg==",null,"AZDu+wknFwhYjI7GQSWpRWhCL1yTRGiLRIyDoNojrDM=","zmhUjeol3TxPbbC+IoOiVw==","2","2020-01-13 18:32:35","2","2020-01-13 18:32:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 18:32:37","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",1488,"NEW","A05-CT206953",1006,775,1550,0,"1","1",2287,2325,2287,"2020-01-13 18:32:37","0",null,null,null,"2020-01-14","2020-02-13","1 month contract. Special offer 5% \"Rent Now\" discount.Storage rental and deposit paid by EPS on January 13, 2020. Smartcard and padlock provided on January 13, 2020. ","2020-01-14","9",0,null,38,"38.00","2","2020-01-13 18:32:35","2","2020-01-13 18:32:35","EPS","","","","EPS","","","",null,0,"'0012415172","C201488","PERSONAL","Mr","f8XYjME4S7bFUqbGMta6lQ==","Zzv1eRCimQisUlUlw\/fpjg==","","G0DqRe7qjhKPGx\/xBTTOfkZj9PK2cXtWpGQaKEp9drmf1mJDIa4T67yQK6PXaGroPKe1kXil+G7i0kRQHfNH8Q==","JtEwh55Nke4GFrfYfJpr1Q==","AZDu+wknFwhYjI7GQSWpRWhCL1yTRGiLRIyDoNojrDM=","7QBn2SNCjVe7w65Aiokifg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 18:32:37","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":["6953","1063","1006.0","1006.00","2","2020-01-13 18:32:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 18:32:37","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-14","2020-02-13","1063"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-13 18:32:37","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":["6953","A05-D205252","PAID",1550,0,"2020-02-13","2020-01-13 18:32:35","2020-01-13 18:32:35","2","2020-01-13 18:32:35","2","2020-01-13 18:32:35",1488]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 18:32:37","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":["6953",1488,"SETTLED","A05-I207281","2020-01-13 18:32:35","2020-01-14","2","2020-01-13 18:32:35","2","2020-01-13 18:32:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 18:32:37","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":["7281","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,737,"MO","1",737,"2","2020-01-13 18:32:35","2","2020-01-13 18:32:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 18:32:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[737,0,"7281"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-13 18:32:37","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":[1488,"EPS","","","","EPS","","","","PAID","P206930","2020-01-13 18:32:35",2287,"2","2020-01-13 18:32:35","2","2020-01-13 18:32:35","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 18:32:37","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":["6930","DEPOSIT","5252","PAID","2020-01-13 18:32:35",1550,"2","2020-01-13 18:32:35","2","2020-01-13 18:32:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 18:32:37","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":["6930","INVOICE","7281","PAID","2020-01-13 18:32:35",737,"2","2020-01-13 18:32:35","2","2020-01-13 18:32:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 19:31:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 20:41:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-13 20:41:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****