{"created_at":"2020-02-26 10:18:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 10:34:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 14:07:09","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 14:50:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 14:51:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 14:58:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 16:08:45","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 16:32:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 16:34:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:01:47","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:05:34","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=239&filter3=undefined&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1646","master_room_id":"206","room_code":"A16-155"}],"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":"2020-02-10","renew_room_key":"054,46461","renew_remark":"2 months contract. Storage rental paid by cheque on January 13, 2020. Storage deposit transferred from agreement A12-CT196763 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT206951, \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":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":3792,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-10","rent_from":"2020-02-10","rent_to":"2020-03-09","delivery_service":"0","remark":"1 month contract. Storage rental paid by cheque on February 26, 2020. Storage deposit transferred from agreement A12-CT206951 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":3792,"final_order_total":3792,"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.00","deposit":"0.00","total_retail_price":"4392.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:05: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","1",485,"NEW","A12-CT207263",4392,3792,0,0,"1","1",3792,3792,3792,"2020-02-26 19:05:34","0",null,null,null,"2020-02-10","2020-03-09","1 month contract. Storage rental paid by cheque on February 26, 2020. Storage deposit transferred from agreement A12-CT206951 to this agreement.\r\n","2020-02-10","64",0,null,0,"0","2","2020-02-26 19:05:34","2","2020-02-26 19:05:34","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-02-26 19:05: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":["7263","194","1098.0","1098.00","2","2020-02-26 19:05:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:05: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-02-10","2020-03-09","194"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-26 19:05: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":["7263","193","1098.0","1098.00","2","2020-02-26 19:05:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:05: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-02-10","2020-03-09","193"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-26 19:05: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":["7263","183","1098.0","1098.00","2","2020-02-26 19:05:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:05: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-02-10","2020-03-09","183"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-26 19:05: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":["7263","182","1098.0","1098.00","2","2020-02-26 19:05:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:05: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-02-10","2020-03-09","182"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-26 19:05: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":["7263",485,"SETTLED","A12-I207591","2020-02-26 19:05:34","2020-02-10","2","2020-02-26 19:05:34","2","2020-02-26 19:05:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:05: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":["7591","RENT","\u9810\u7e73\u79df\u91d1",1,3792,"MO","1",3792,"2","2020-02-26 19:05:34","2","2020-02-26 19:05:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:05:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3792,0,"7591"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-26 19:05:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[485,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207239","2020-02-26 19:05:34",3792,"2","2020-02-26 19:05:34","2","2020-02-26 19:05:34","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:05:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7239","DEPOSIT",null,"PAID","2020-02-26 19:05:34",0,"2","2020-02-26 19:05:34","2","2020-02-26 19:05:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:05:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7239","INVOICE","7591","PAID","2020-02-26 19:05:34",3792,"2","2020-02-26 19:05:34","2","2020-02-26 19:05:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:05: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","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":874,"customer_code":"C180874","identity_type":"PERSONAL","identity_id":"K451268(5)","title":"Mr","lastname":"Lui","firstname":"Chun Hung","companyname":"","email":"patpat9413888@yahoo.com.hk","tel":"90301273","address":"Room 403, Low Block, Lei Fook House, Apleichau Estate, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-22","renew_room_key":"076,32357","renew_remark":"1 month contract. Storage rental paid by PPS on January 24, 2020. Storage deposit transferred from agreement A12-CT196791 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207060, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"241","room_code":"D45","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-22","rent_from":"2020-02-22","rent_to":"2020-03-21","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on Feb 26, 2020. Storage deposit transferred from agreement A12-CT207060 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"076,32357","order_product":[],"pass":true}},"first_order_id":"4854","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> D45 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:05: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",874,"NEW","A12-CT207264",998,1038,0,0,"1","1",1038,1038,1038,"2020-02-26 19:05:35","0",null,null,null,"2020-02-22","2020-03-21","1 month contract. Storage rental paid by PPS on Feb 26, 2020. Storage deposit transferred from agreement A12-CT207060 to this agreement.","2020-02-22","12",0,null,0,"0","2","2020-02-26 19:05:35","2","2020-02-26 19:05:35","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"076,32357","C180874","PERSONAL","Mr","8E6nLeLaS+nuXxUNvooxGQ==","vyCKi4IYWx3VnCZylJM1yA==","","t2fcXTNQ5zXw41HK7XLxjgpqs4CAbleDk0AZC75MEKtw5ZsokMMh80cI\/IUaR9tYbJXdnEldy\/dOlMJjVNoCJBK+BLg2Hq37YGStg4SRRpc=","v99UbwvGk\/IX8Amdc7pe+Q==","93qNDvLNra1NfZlAUamtzf14nbvapEp9X2o2aos8F7w=","fzIJnHKlsYW3ETkg3nSzoQ==",null,1,"4854"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:05: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":["7264","241","998.0","998.00","2","2020-02-26 19:05:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:05: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-02-22","2020-03-21","241"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-26 19:05: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":["7264",874,"SETTLED","A12-I207592","2020-02-26 19:05:35","2020-02-22","2","2020-02-26 19:05:35","2","2020-02-26 19:05:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:05: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":["7592","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-02-26 19:05:35","2","2020-02-26 19:05:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:05:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"7592"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-26 19:05: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":[874,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207240","2020-02-26 19:05:35",1038,"2","2020-02-26 19:05:35","2","2020-02-26 19:05:35","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:05: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":["7240","DEPOSIT",null,"PAID","2020-02-26 19:05:35",0,"2","2020-02-26 19:05:35","2","2020-02-26 19:05:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:05: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":["7240","INVOICE","7592","PAID","2020-02-26 19:05:35",1038,"2","2020-02-26 19:05:35","2","2020-02-26 19:05:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:07:23","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"type=INVOICE&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":21,"customer_code":"C150021","identity_type":"PERSONAL","identity_id":"K072676(1)","title":"Mr","lastname":"Cheng","firstname":"Wai Kin","companyname":"","email":"cwkroy@yahoo.com.hk","tel":"93033492","address":"Flat 2B, Block 14, Chi Fu Fa Yuen, H.K.","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"568.0","renew_rent_month":"3","renew_warehousing_date":"2020-01-22","renew_room_key":"054,59552","renew_remark":"3 months contract. Storage rental paid by PPS on January 2, 2020. Storage deposit transferred from agreement A12-CT196416 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT206855, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"1","order_discount":[],"order_room":[{"room_id":"211","room_code":"D15","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":568,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":1704,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-22","rent_from":"2020-01-22","rent_to":"2020-04-21","delivery_service":"0","remark":"3 months contract. Storage rental paid by PPS on Feb 26, 2020. Storage deposit transferred from agreement A12-CT206855 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1704,"final_order_total":1704,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,59552","order_product":[],"pass":true}},"first_order_id":"5130","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> D15 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"568.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:07:23","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",21,"NEW","A12-CT207265",598,568,0,0,"3","3",1704,1704,1704,"2020-02-26 19:07:23","0",null,null,null,"2020-01-22","2020-04-21","3 months contract. Storage rental paid by PPS on Feb 26, 2020. Storage deposit transferred from agreement A12-CT206855 to this agreement.","2020-01-22","12",0,null,0,"0","2","2020-02-26 19:07:23","2","2020-02-26 19:07:23","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,59552","C150021","PERSONAL","Mr","MLCe5vmZDmd8r2fUbVc13A==","UCPBCXrBLI9U7KKsPqgmNA==","","6e\/BP2gUBkTAY5yPTvoK7RwdSoD67HISilZb2LuPrHeikacP8o2utC4vDnnnhvni","YemE6fp9WuJaRz9GK0KgKA==","EGeNYE9J78gEvzgbENBQeL\/9UQajTXO7AoyiNhVjolY=","6OwZ\/TwaT9UKVnq5GjUg9w==",null,1,"5130"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:07:23","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":["7265","211","598.0","598.00","2","2020-02-26 19:07:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:07:23","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-04-21","211"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-26 19:07:23","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":["7265",21,"SETTLED","A12-I207593","2020-02-26 19:07:23","2020-01-22","2","2020-02-26 19:07:23","2","2020-02-26 19:07:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:07:23","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":["7593","RENT","\u9810\u7e73\u79df\u91d1",1,568,"MO","1",568,"2","2020-02-26 19:07:23","2","2020-02-26 19:07:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:07:23","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":["7593","RENT","\u9810\u7e73\u79df\u91d1",2,568,"MO","1",568,"2","2020-02-26 19:07:23","2","2020-02-26 19:07:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:07:23","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":["7593","RENT","\u9810\u7e73\u79df\u91d1",3,568,"MO","1",568,"2","2020-02-26 19:07:23","2","2020-02-26 19:07:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:07:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1704,0,"7593"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-26 19:07:23","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":[21,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207241","2020-02-26 19:07:23",1704,"2","2020-02-26 19:07:23","2","2020-02-26 19:07:23","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:07:23","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":["7241","DEPOSIT",null,"PAID","2020-02-26 19:07:23",0,"2","2020-02-26 19:07:23","2","2020-02-26 19:07:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-26 19:07:23","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":["7241","INVOICE","7593","PAID","2020-02-26 19:07:23",1704,"2","2020-02-26 19:07:23","2","2020-02-26 19:07:23"]},"data_before":[],"data_after":[],"step":1} *****