{"created_at":"2020-06-17 09:59:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 10:02:11","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 10:02:28","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 10:02:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 10:03:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 11:59:06","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 13:32:14","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=98&filter3=undefined&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":"888","master_room_id":"85","room_code":"Y17"},{"room_id":"889","master_room_id":"85","room_code":"Y18"}],"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\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>
Y17 <\/td>\r\n\t\t\t\t\t	8X4X7 <\/td>\r\n\t\t\t\t\t	$2434.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>
Y18 <\/td>\r\n\t\t\t\t\t	8X4X7 <\/td>\r\n\t\t\t\t\t	$2434.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":"0","identity_type":"PERSONAL","identity_id":"G435908(8)","title":"Mr","lastname":"Ng","firstname":"Kim Hung","companyname":"","email":"ngkh.hk@gmail.com","tel":"94359909","address":"Flat H, 3\/F, Tower 21, South Horizons, Ap Lei Chau","pass":true,"customer_id":"612","customer_code":"C170612","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"302","master_room_id":"85","discount_type":"%","price":"2434.00","disocunted_price":"2190.60","discount":"10.00","monthly_deduct":243.4,"room_id":"889","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"302","master_room_id":"85","discount_type":"%","price":"2434.00","disocunted_price":"2190.60","discount":"10.00","monthly_deduct":243.4,"room_id":"888","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"888","room_code":"Y17","retail_price":"2434.0","discounted_price":2190.6,"location_id":"3"},{"room_id":"889","room_code":"Y18","retail_price":"2434.0","discounted_price":2190.6,"location_id":"3"}],"roughly_size":"64","total_retail_price":4868,"total_discounted_price":5434,"deposit":10076,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":23680,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"19000","warehousing_date":"2020-06-24","rent_from":"2020-06-24","rent_to":"2020-12-23","delivery_service":"0","remark":"6 months contract. Change unit R14 to Y17 Y18. Storage deposit $13600 transferred from agreement A18-CT196775 to this agreement. Remaining rental $23680 paid by bank transfer on JUNE 17,2020. ","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":19000,"order_total":42680,"final_order_total":23680,"location_id":"3","branch_id":"1","company_id":"1","room_key":"137,19344,054,60061","order_product":[],"pass":true}},"roughly_size":"64","total_discounted_price":"5434","deposit":"10076","total_retail_price":"4868.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 13:32:15","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","3","612","NEW","A18-CT208156",4868,5434,10076,0,"6","6",23680,42680,23680,"2020-06-17 13:32:15","0",null,null,null,"2020-06-24","2020-12-23","6 months contract. Change unit R14 to Y17 Y18. Storage deposit $13600 transferred from agreement A18-CT196775 to this agreement. Remaining rental $23680 paid by bank transfer on JUNE 17,2020. ","2020-06-24","64",0,null,19000,"19000","2","2020-06-17 13:32:14","2","2020-06-17 13:32:14","BANKIN","","","","BANKIN","","","",null,0,"137,19344,054,60061","C170612","PERSONAL","Mr","GqH+t4D4XqDN5Gx3zJwoLQ==","cxr02xsD1tXvJ4ihJHZKWw==","","mYqAlf88L9yyTacZnpfY7e\/4uuwbqY9auGxQuzyoqqy46PWBqEdlBQQPUkTwwZjfqKTmfksd0v+O0Mz7+m\/UFQ==","LBmTeybjrFtX2f0XTesnWA==","FlAt\/Y53v6RuyOc9dqySFGM0RHWoorKMp72nHaXlJMo=","RkobS6ean7ZpvALtp80HDA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 13:32:15","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":["8156","302","85","889","%","10.00",243.4,"2","2020-06-17 13:32:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 13:32:15","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":["8156","302","85","888","%","10.00",243.4,"2","2020-06-17 13:32:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 13:32:15","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":["8156","888","2434.0",2190.6,"2","2020-06-17 13:32:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 13:32:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-24","2020-12-23","888"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-17 13:32:15","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":["8156","889","2434.0",2190.6,"2","2020-06-17 13:32:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 13:32:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-24","2020-12-23","889"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-17 13:32:15","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":["8156","A18-D205478","PAID",10076,0,"2020-12-23","2020-06-17 13:32:14","2020-06-17 13:32:14","2","2020-06-17 13:32:14","2","2020-06-17 13:32:14","612"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 13:32:15","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":["8156","612","SETTLED","A18-I208485","2020-06-17 13:32:14","2020-06-24","2","2020-06-17 13:32:14","2","2020-06-17 13:32:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 13:32:15","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":["8485","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-17 13:32:14","2","2020-06-17 13:32:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 13:32:15","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":["8485","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-06-17 13:32:14","2","2020-06-17 13:32:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 13:32:15","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":["8485","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,0,"MO","1",0,"2","2020-06-17 13:32:14","2","2020-06-17 13:32:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 13:32:15","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":["8485","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",4,2736,"MO","1",2736,"2","2020-06-17 13:32:14","2","2020-06-17 13:32:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 13:32:15","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":["8485","RENT","\u9810\u7e73\u79df\u91d1",5,5434,"MO","1",5434,"2","2020-06-17 13:32:14","2","2020-06-17 13:32:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 13:32:15","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":["8485","RENT","\u9810\u7e73\u79df\u91d1",6,5434,"MO","1",5434,"2","2020-06-17 13:32:14","2","2020-06-17 13:32:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 13:32:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13604,0,"8485"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-17 13:32:15","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":["612","BANKIN","","","","BANKIN","","","","PAID","P208128","2020-06-17 13:32:14",23680,"2","2020-06-17 13:32:14","2","2020-06-17 13:32:14","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 13:32:15","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":["8128","DEPOSIT","5478","PAID","2020-06-17 13:32:14",10076,"2","2020-06-17 13:32:14","2","2020-06-17 13:32:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 13:32:15","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":["8128","INVOICE","8485","PAID","2020-06-17 13:32:14",13604,"2","2020-06-17 13:32:14","2","2020-06-17 13:32:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 14:30:31","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:03:41","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=786&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1763","master_room_id":"232","room_code":"WC-06"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":823,"customer_code":"C180823","identity_type":"BUSINESS","identity_id":"39661261","title":"Mr","lastname":"Milan Martinez","firstname":"Alejandro","companyname":"La Nao Group Limited","email":"a.milan@la-nao.com","tel":"90212010","address":"13A, Trust Tower, 68 Johnston Road, Wanchai, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2318.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-13","renew_room_key":"055,09251","renew_remark":"1 month contract. Storage rental paid by bank transfer on May 13, 2020. Storage deposit transferred from agreement A14-CT207650 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207853, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"794","room_code":"K60","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"515","room_code":"K52","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":2318,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2318,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-13","rent_from":"2020-05-13","rent_to":"2020-06-12","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on June 16, 2020. Storage deposit transferred from agreement A14-CT207853 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2318,"final_order_total":2318,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,09251","order_product":[],"pass":true}},"first_order_id":"4785","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> K60 <\/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\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> K52 <\/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\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":"32","total_discounted_price":"2318.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:03:41","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",823,"NEW","A14-CT208157",2196,2318,0,0,"1","1",2318,2318,2318,"2020-06-17 15:03:41","0",null,null,null,"2020-05-13","2020-06-12","1 month contract. Storage rental paid by bank transfer on June 16, 2020. Storage deposit transferred from agreement A14-CT207853 to this agreement.\r\n","2020-05-13","32",0,null,0,"0","2","2020-06-17 15:03:41","2","2020-06-17 15:03:41","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,09251","C180823","BUSINESS","Mr","Ltuw0GNYtUHvg5xq\/qUHZw==","B0t4iVfZVAQdLpfngFJQ9g==","La Nao Group Limited","ogXiJSz6bxnQX1arPQzS4HtoujvXU7DtPI6iXMqgmibwYxgUDD+7IDSdp7zHKT1WsucqNnxkVRDDkoVXniYCDA==","oMTdQIHVXIpTgMmFZOwTlA==","toRvij1IyfmFV4d7mZnp4cg+UZM6Nv9c2C6kHmvTa8c=",null,"mWmgEjucdLaH5rglf7tExg==",1,"4785"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:03:41","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":["8157","794","1098.0","1098.00","2","2020-06-17 15:03:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:03:41","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-05-13","2020-06-12","794"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-17 15:03:41","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":["8157","515","1098.0","1098.00","2","2020-06-17 15:03:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:03:41","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-05-13","2020-06-12","515"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-17 15:03:41","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":["8157",823,"SETTLED","A14-I208486","2020-06-17 15:03:41","2020-05-13","2","2020-06-17 15:03:41","2","2020-06-17 15:03:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:03:41","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":["8486","RENT","\u9810\u7e73\u79df\u91d1",1,2318,"MO","1",2318,"2","2020-06-17 15:03:41","2","2020-06-17 15:03:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:03:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2318,0,"8486"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-17 15:03:41","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":[823,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208129","2020-06-17 15:03:41",2318,"2","2020-06-17 15:03:41","2","2020-06-17 15:03:41","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:03:41","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":["8129","DEPOSIT",null,"PAID","2020-06-17 15:03:41",0,"2","2020-06-17 15:03:41","2","2020-06-17 15:03:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:03:41","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":["8129","INVOICE","8486","PAID","2020-06-17 15:03:41",2318,"2","2020-06-17 15:03:41","2","2020-06-17 15:03:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:38:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:57:25","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1558&filter3=undefined","floor_plan_rent_room":[{"room_id":"1763","master_room_id":"232","room_code":"WC-06"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":89,"customer_code":"C160089","identity_type":"PERSONAL","identity_id":"K919836(9)","title":"Mr","lastname":"Wong","firstname":"Chi Ming","companyname":"","email":"alvinwong127@gmail.com","tel":"92593593","address":"17G Shan Kwong Towers , 24 Shan Kwong Rd , H.K.","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1139.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-25","renew_room_key":"054,42791","renew_remark":"6 months contract. Storage rental paid by PPS on December 27, 2019. Storage deposit transferred from agreement A12-CT195118 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196792, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[{"master_room_discount_id":"77","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1271.00","discount":"16.82","monthly_deduct":257.0096,"room_id":"62","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"62","room_code":"B10","retail_price":"1528.0","discounted_price":1271,"location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1139,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":13668,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-25","rent_from":"2020-05-25","rent_to":"2021-05-24","delivery_service":"0","remark":"6 months contract. Storage rental paid by PPS on June 16, 2020. Storage deposit transferred from agreement A12-CT196792 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":13668,"final_order_total":13668,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,42791","order_product":[],"pass":true}},"first_order_id":"3792","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> B10 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.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":"20","total_discounted_price":"1139.00","deposit":"0.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:57:25","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",89,"NEW","A12-CT208158",1528,1139,0,0,"12","12",13668,13668,13668,"2020-06-17 15:57:25","0",null,null,null,"2020-05-25","2021-05-24","6 months contract. Storage rental paid by PPS on June 16, 2020. Storage deposit transferred from agreement A12-CT196792 to this agreement.\r\n","2020-05-25","20",0,null,0,"0","2","2020-06-17 15:57:25","2","2020-06-17 15:57:25","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,42791","C160089","PERSONAL","Mr","85IYGmU7T42vA2xjCNQ\/9g==","hULSwM2MvFtpeV9\/z+er8Q==","","725qawD2XAxh8vD93buM7Bt+e9NAt1JD5Nppaw4U5uhL75KQJp\/38MQoJdSum4Oo","ahXo4Cp1sXnSvV+RC3GlfQ==","F0shMEmecqy9M6LGjx0wm2ms0HI38uJ35E4kCfxGVjc=","pCxdr33L8qcs0omSSHxHkQ==",null,1,"3792"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:57:25","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":["8158","77","10","62","%","16.82",257.0096,"2","2020-06-17 15:57:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:57:25","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":["8158","62","1528.0",1271,"2","2020-06-17 15:57:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:57:25","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-05-25","2021-05-24","62"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-17 15:57:25","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":["8158",89,"SETTLED","A12-I208487","2020-06-17 15:57:25","2020-05-25","2","2020-06-17 15:57:25","2","2020-06-17 15:57:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:57:25","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":["8487","RENT","\u9810\u7e73\u79df\u91d1",1,1139,"MO","1",1139,"2","2020-06-17 15:57:25","2","2020-06-17 15:57:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:57:25","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":["8487","RENT","\u9810\u7e73\u79df\u91d1",2,1139,"MO","1",1139,"2","2020-06-17 15:57:25","2","2020-06-17 15:57:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:57:25","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":["8487","RENT","\u9810\u7e73\u79df\u91d1",3,1139,"MO","1",1139,"2","2020-06-17 15:57:25","2","2020-06-17 15:57:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:57:25","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":["8487","RENT","\u9810\u7e73\u79df\u91d1",4,1139,"MO","1",1139,"2","2020-06-17 15:57:25","2","2020-06-17 15:57:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:57:25","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":["8487","RENT","\u9810\u7e73\u79df\u91d1",5,1139,"MO","1",1139,"2","2020-06-17 15:57:25","2","2020-06-17 15:57:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:57:25","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":["8487","RENT","\u9810\u7e73\u79df\u91d1",6,1139,"MO","1",1139,"2","2020-06-17 15:57:25","2","2020-06-17 15:57:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:57:25","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":["8487","RENT","\u9810\u7e73\u79df\u91d1",7,1139,"MO","1",1139,"2","2020-06-17 15:57:25","2","2020-06-17 15:57:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:57:25","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":["8487","RENT","\u9810\u7e73\u79df\u91d1",8,1139,"MO","1",1139,"2","2020-06-17 15:57:25","2","2020-06-17 15:57:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:57:25","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":["8487","RENT","\u9810\u7e73\u79df\u91d1",9,1139,"MO","1",1139,"2","2020-06-17 15:57:25","2","2020-06-17 15:57:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:57:25","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":["8487","RENT","\u9810\u7e73\u79df\u91d1",10,1139,"MO","1",1139,"2","2020-06-17 15:57:25","2","2020-06-17 15:57:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:57:25","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":["8487","RENT","\u9810\u7e73\u79df\u91d1",11,1139,"MO","1",1139,"2","2020-06-17 15:57:25","2","2020-06-17 15:57:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:57:25","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":["8487","RENT","\u9810\u7e73\u79df\u91d1",12,1139,"MO","1",1139,"2","2020-06-17 15:57:25","2","2020-06-17 15:57:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:57:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13668,0,"8487"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-17 15:57:25","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":[89,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208130","2020-06-17 15:57:25",13668,"2","2020-06-17 15:57:25","2","2020-06-17 15:57:25","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:57:25","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":["8130","DEPOSIT",null,"PAID","2020-06-17 15:57:25",0,"2","2020-06-17 15:57:25","2","2020-06-17 15:57:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 15:57:25","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":["8130","INVOICE","8487","PAID","2020-06-17 15:57:25",13668,"2","2020-06-17 15:57:25","2","2020-06-17 15:57:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:00:19","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1558&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1763","master_room_id":"232","room_code":"WC-06"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1271,"customer_code":"C191271","identity_type":"PERSONAL","identity_id":"K712755(3)","title":"Mr","lastname":"LAM","firstname":"Chi Wai","companyname":"","email":null,"tel":"92164311","address":"Room 2101, Ching Fai House, Tsz Ching Estate, Tsz Wan Shan, Kowloon ","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1798.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-17","renew_room_key":"'0012449154","renew_remark":"1 month contract. Storage rental paid by PPS on May 18, 2020. Storage deposit $1798 transferred from agreement C15-CT194999 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT207895, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"175","order_discount":[],"order_room":[{"room_id":"1352","room_code":"C15-046","retail_price":"1798.0","discounted_price":"1798.00","location_id":"6"}],"roughly_size":"32","total_retail_price":1798,"total_discounted_price":1798,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1798,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-17","rent_from":"2020-06-17","rent_to":"2020-07-16","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on June 16, 2020. Storage deposit $1798 transferred from agreement C15-CT207895 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1798,"final_order_total":1798,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012449154","order_product":[],"pass":true}},"first_order_id":"4999","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-046 <\/td>\r\n\t\t\t\t\t 4X8X6.5 <\/td>\r\n\t\t\t\t\t $1798.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"1798.0","deposit":"0","total_retail_price":"1798.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:00:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1271,"NEW","C15-CT208159",1798,1798,0,0,"1","1",1798,1798,1798,"2020-06-17 16:00:19","0",null,null,null,"2020-06-17","2020-07-16","1 month contract. Storage rental paid by PPS on June 16, 2020. Storage deposit $1798 transferred from agreement C15-CT207895 to this agreement. \r\n","2020-06-17","32",0,null,0,"0","2","2020-06-17 16:00:19","2","2020-06-17 16:00:19","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"'0012449154","C191271","PERSONAL","Mr","gRYbQt3pC62mUupe40WPwQ==","BLxWt7e4owYJMFkn6\/eeMQ==","","TRjEyvIacLdlB3\/BTvMBQ8s+Hedp2neB9QwS8\/VtPvYoFFhsPhCivmgyYY0I0p4pmtPDggtb2uBFb9BrJYjHC86L6DWB3nraLGtOU\/Zg+IA=","+Lhrg0tS4jJm1n1j9ILS9A==",null,"EqHubtgeNEG24y4Oi2L10g==",null,1,"4999"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:00:19","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":["8159","1352","1798.0","1798.00","2","2020-06-17 16:00:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:00:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-17","2020-07-16","1352"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-17 16:00:19","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":["8159",1271,"SETTLED","C15-I208488","2020-06-17 16:00:19","2020-06-17","2","2020-06-17 16:00:19","2","2020-06-17 16:00:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:00:19","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":["8488","RENT","\u9810\u7e73\u79df\u91d1",1,1798,"MO","1",1798,"2","2020-06-17 16:00:19","2","2020-06-17 16:00:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:00:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1798,0,"8488"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-17 16:00:19","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":[1271,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208131","2020-06-17 16:00:19",1798,"2","2020-06-17 16:00:19","2","2020-06-17 16:00:19","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:00:19","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":["8131","DEPOSIT",null,"PAID","2020-06-17 16:00:19",0,"2","2020-06-17 16:00:19","2","2020-06-17 16:00:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:00:19","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":["8131","INVOICE","8488","PAID","2020-06-17 16:00:19",1798,"2","2020-06-17 16:00:19","2","2020-06-17 16:00:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:02:23","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1558&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1763","master_room_id":"232","room_code":"WC-06"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1425,"customer_code":"C191425","identity_type":"BUSINESS","identity_id":"2519978","title":"Mr","lastname":"Wong ","firstname":"Man Cheung","companyname":"Serene Capital Limited","email":"philipwong@certproperty.co.uk","tel":"90941892","address":"16A, 16\/F Chung Hing Commercial Building, 62 Connaught Road Central, Central, H.K.","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-17","renew_room_key":"0012450069","renew_remark":"1 month contract. Storage rental paid by PPS on May 19, 2020. Storage deposit $1196 transferred from agreement A12-CT207720 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207917, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"1","order_discount":[],"order_room":[{"room_id":"213","room_code":"D17","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-17","rent_from":"2020-06-17","rent_to":"2020-07-16","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on June 16, 2020. Storage deposit $1196 transferred from agreement A12-CT207917 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"1","branch_id":"1","company_id":"1","room_key":"0012450069","order_product":[],"pass":true}},"first_order_id":"3347","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> D17 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:02:24","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",1425,"NEW","A12-CT208160",598,598,0,0,"1","1",598,598,598,"2020-06-17 16:02:24","0",null,null,null,"2020-06-17","2020-07-16","1 month contract. Storage rental paid by PPS on June 16, 2020. Storage deposit $1196 transferred from agreement A12-CT207917 to this agreement. \r\n","2020-06-17","12",0,null,0,"0","2","2020-06-17 16:02:23","2","2020-06-17 16:02:23","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0012450069","C191425","BUSINESS","Mr","G+w65JkR7AS+JT7hCDD+yg==","DgLsCGM4faTvgwjKBW9M0A==","Serene Capital Limited","S4o9AXA7eRky9fl+GI6ii2+TMoCmBDuByzpKzUF7jpxGD0QmypETmhNR0PVTCj612a7mYANU+Sc3i0encOiszMwjCriyODNCJhdNRzJhCfKfqggF6Ry9Getc\/0LKYKRN","CL6e4EkMiRzRr0Rve85mrw==","eLkWayCc4RkCZg6CrTQmBSr+4xmx9fTzOhnQ35wQOzA=",null,"JdjeYwtWISTCzDjjVIKzVw==",1,"3347"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:02:24","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":["8160","213","598.0","598.00","2","2020-06-17 16:02:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:02:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-17","2020-07-16","213"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-17 16:02:24","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":["8160",1425,"SETTLED","A12-I208489","2020-06-17 16:02:23","2020-06-17","2","2020-06-17 16:02:23","2","2020-06-17 16:02:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:02:24","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":["8489","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-06-17 16:02:23","2","2020-06-17 16:02:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:02:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8489"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-17 16:02:24","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":[1425,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208132","2020-06-17 16:02:23",598,"2","2020-06-17 16:02:23","2","2020-06-17 16:02:23","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:02:24","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":["8132","DEPOSIT",null,"PAID","2020-06-17 16:02:23",0,"2","2020-06-17 16:02:23","2","2020-06-17 16:02:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:02:24","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":["8132","INVOICE","8489","PAID","2020-06-17 16:02:23",598,"2","2020-06-17 16:02:23","2","2020-06-17 16:02:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:04:36","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1558&filter3=undefined&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":"1763","master_room_id":"232","room_code":"WC-06"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1369,"customer_code":"C191369","identity_type":"PERSONAL","identity_id":"K168595(3)","title":"Ms","lastname":"Lam","firstname":"Chak Yan Jessie Teresa","companyname":"","email":"jessielam98@yahoo.com","tel":"90249982","address":"Flat G, 39\/F, Block 10, Park Central, 9 Tong Tak St, Tseung Kwan O, New Territories","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1722.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-17","renew_room_key":"0012400828","renew_remark":"1 month contract. Storage rental paid by PPS on May 14, 2020. Storage deposit $3444 transferred from agreement B01-CT207655 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT207857, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"144","order_discount":[],"order_room":[{"room_id":"1245","room_code":"B01-055","retail_price":"1722.0","discounted_price":"1722.00","location_id":"5"}],"roughly_size":"28","total_retail_price":1722,"total_discounted_price":1722,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1722,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-17","rent_from":"2020-06-17","rent_to":"2020-07-16","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on June 16, 2020. Storage deposit $3444 transferred from agreement B01-CT207857 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1722,"final_order_total":1722,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0012400828","order_product":[],"pass":true}},"first_order_id":"5735","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> B01-055 <\/td>\r\n\t\t\t\t\t 4X7X7 <\/td>\r\n\t\t\t\t\t $1722.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\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":"28","total_discounted_price":"1722.0","deposit":"0","total_retail_price":"1722.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:04:36","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","2","5",1369,"NEW","B01-CT208161",1722,1722,0,0,"1","1",1722,1722,1722,"2020-06-17 16:04:36","0",null,null,null,"2020-06-17","2020-07-16","1 month contract. Storage rental paid by PPS on June 16, 2020. Storage deposit $3444 transferred from agreement B01-CT207857 to this agreement. \r\n","2020-06-17","28",0,null,0,"0","2","2020-06-17 16:04:36","2","2020-06-17 16:04:36","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0012400828","C191369","PERSONAL","Ms","jK0sLQIokMTYV3ZXRP7RRXDjgJo6nAphSESGZHss\/8U=","0JxYUqbNPOvgfMwVa0l0NA==","","pTmVYn+9+08jSfjkrAQ930uwUJzZ7GoK3+66lfew+t\/0fxR9nqTrYogXakd2cb9Sk2zdmyu\/qWeMNreBPl1p7XP\/HNblMsLwTfHvYfY+z2iPqem7sllCAATFp9Gnw3Iz","oV5+sNO0lE615GWj8tpo0Q==","kejhjXk8xC0HdcA9K5VT+zQSSUKUT3H1mkDxQhBuRjw=","VerPwfNhcgk\/G01dKO+a8A==",null,1,"5735"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:04:36","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":["8161","1245","1722.0","1722.00","2","2020-06-17 16:04:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:04:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-17","2020-07-16","1245"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-17 16:04:36","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":["8161",1369,"SETTLED","B01-I208490","2020-06-17 16:04:36","2020-06-17","2","2020-06-17 16:04:36","2","2020-06-17 16:04:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:04:36","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":["8490","RENT","\u9810\u7e73\u79df\u91d1",1,1722,"MO","1",1722,"2","2020-06-17 16:04:36","2","2020-06-17 16:04:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:04:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1722,0,"8490"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-17 16:04:36","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":[1369,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208133","2020-06-17 16:04:36",1722,"2","2020-06-17 16:04:36","2","2020-06-17 16:04:36","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:04:36","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":["8133","DEPOSIT",null,"PAID","2020-06-17 16:04:36",0,"2","2020-06-17 16:04:36","2","2020-06-17 16:04:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:04:36","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":["8133","INVOICE","8490","PAID","2020-06-17 16:04:36",1722,"2","2020-06-17 16:04:36","2","2020-06-17 16:04:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:57:02","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1558&filter3=undefined","floor_plan_rent_room":[{"room_id":"1763","master_room_id":"232","room_code":"WC-06"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1276,"customer_code":"C191276","identity_type":"BUSINESS","identity_id":"67226140-002-02-19-5","title":"Ms","lastname":"Kwok","firstname":"Wancie","companyname":"Happy Concepts Asia Limited","email":"wancie@happy-concepts.com","tel":"92420692","address":"Room 2107, 21\/F, Fullagar Ind Building, 234 Aberdeen Main Road, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2161.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-27","renew_room_key":"076,47844","renew_remark":"1 month contract. Storage rental paid by bank transfer on May 16, 2020. Storage deposit $4322 transferred form agreement A16-CT207612 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT207889, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"206","order_discount":[],"order_room":[{"room_id":"1645","room_code":"A16-154","retail_price":"2161.0","discounted_price":"2161.00","location_id":"7"}],"roughly_size":"28","total_retail_price":2161,"total_discounted_price":2161,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2161,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-27","rent_from":"2020-05-27","rent_to":"2020-06-26","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on June 16, 2020. Storage deposit $4322 transferred form agreement A16-CT207889 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2161,"final_order_total":2161,"location_id":"7","branch_id":"1","company_id":"1","room_key":"076,47844","order_product":[],"pass":true}},"first_order_id":"5067","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> A16-154 <\/td>\r\n\t\t\t\t\t 4X7X7 <\/td>\r\n\t\t\t\t\t $2161.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":"28","total_discounted_price":"2161.0","deposit":"0","total_retail_price":"2161.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:57:03","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","7",1276,"NEW","A16-CT208162",2161,2161,0,0,"1","1",2161,2161,2161,"2020-06-17 16:57:03","0",null,null,null,"2020-05-27","2020-06-26","1 month contract. Storage rental paid by bank transfer on June 16, 2020. Storage deposit $4322 transferred form agreement A16-CT207889 to this agreement. \r\n","2020-05-27","28",0,null,0,"0","2","2020-06-17 16:57:02","2","2020-06-17 16:57:02","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,47844","C191276","BUSINESS","Ms","UnAuVv7vF8jhvFzl3xSCmg==","+pNULpsInm3siHASV0hIrg==","Happy Concepts Asia Limited","Vz2ejyARH5zcH5e4QlFSq51bZp23xF3kJ5RJpCNl57lAk8+AWULPwqnFcIQcG5ZBdUxERR9syaCIcEtZgd+HqAaztaF6lZ3cM+VjkllU2B0=","Gfho0rh19G9JYZxq3cLhUw==","YWYp2e5RTnHURnlliiVCoZfRQjqOlQ4Jschx6rAjv1w=",null,"emH+RX7ttsZFOmRnXIxwP9GHFJD2VTz2ibaI3AjX2ZU=",1,"5067"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:57:03","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":["8162","1645","2161.0","2161.00","2","2020-06-17 16:57:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:57:03","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-05-27","2020-06-26","1645"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-17 16:57:03","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":["8162",1276,"SETTLED","A16-I208491","2020-06-17 16:57:02","2020-05-27","2","2020-06-17 16:57:02","2","2020-06-17 16:57:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:57:03","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":["8491","RENT","\u9810\u7e73\u79df\u91d1",1,2161,"MO","1",2161,"2","2020-06-17 16:57:02","2","2020-06-17 16:57:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:57:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2161,0,"8491"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-17 16:57:03","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":[1276,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208134","2020-06-17 16:57:02",2161,"2","2020-06-17 16:57:02","2","2020-06-17 16:57:02","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:57:03","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":["8134","DEPOSIT",null,"PAID","2020-06-17 16:57:02",0,"2","2020-06-17 16:57:02","2","2020-06-17 16:57:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 16:57:03","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":["8134","INVOICE","8491","PAID","2020-06-17 16:57:02",2161,"2","2020-06-17 16:57:02","2","2020-06-17 16:57:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 17:35:29","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1558&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1763","master_room_id":"232","room_code":"WC-06"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":476,"customer_code":"C170476","identity_type":"PERSONAL","identity_id":"Z261609(3)","title":"Ms","lastname":"Nagrani","firstname":"Dyana Chirag","companyname":"","email":"dyananagrani@gmail.com","tel":"97530656","address":"15D,Block 23,Upper Baguio Villa,555 Victoria Road","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2079.0","renew_rent_month":"3","renew_warehousing_date":"2020-05-12","renew_room_key":"","renew_remark":"3 months contract. Storage rental and deposit paid by bank transfer on March. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207355, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $4376.0","renew_master_room_id":"23","order_discount":[{"master_room_discount_id":"462","master_room_id":"23","discount_type":"%","price":"2188.00","disocunted_price":"2078.60","discount":"5.00","monthly_deduct":109.4,"room_id":"111","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"111","room_code":"B59","retail_price":"2188.0","discounted_price":2078.6,"location_id":"1"}],"roughly_size":"30","total_retail_price":2188,"total_discounted_price":2079,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":6237,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-12","rent_from":"2020-05-12","rent_to":"2020-08-11","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on June 17, 2020. Storage deposit $4376 transferred from agreement A12-CT207355 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6237,"final_order_total":6237,"location_id":"1","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"first_order_id":7355,"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> B59 <\/td>\r\n\t\t\t\t\t 5X6X8 <\/td>\r\n\t\t\t\t\t $2188.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":"30","total_discounted_price":"2079.0","deposit":"0","total_retail_price":"2188.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 17:35:30","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",476,"NEW","A12-CT208163",2188,2079,0,0,"3","3",6237,6237,6237,"2020-06-17 17:35:30","0",null,null,null,"2020-05-12","2020-08-11","3 months contract. Storage rental paid by bank transfer on June 17, 2020. Storage deposit $4376 transferred from agreement A12-CT207355 to this agreement. ","2020-05-12","30",0,null,0,"0","2","2020-06-17 17:35:29","2","2020-06-17 17:35:29","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"","C170476","PERSONAL","Ms","uY1GOIr7ltXY31G7hQ1Lpw==","aJKgnyAdJr97nz4jfpV3sQ==","","1lJ4K+syeOSy\/iMz0AD2J1xPDznD6Og9NKPh1dqZhBdfuPpjXKo+Pfxml\/5AOdOZg\/o5qCMIqoVmECFdvjh4OQ==","yOfdSxJ\/ZUSdf+Zln3yzeQ==","nGVYsbC3icJGemDDP2LYnBkL+VDYEjjfs2MMvYaW\/PE=","ByPC9gVlx28UHvivmbpe3Q==",null,1,7355]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 17:35:30","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":["8163","462","23","111","%","5.00",109.4,"2","2020-06-17 17:35:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 17:35:30","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":["8163","111","2188.0",2078.6,"2","2020-06-17 17:35:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 17:35:30","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-05-12","2020-08-11","111"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-17 17:35:30","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":["8163",476,"SETTLED","A12-I208492","2020-06-17 17:35:29","2020-05-12","2","2020-06-17 17:35:29","2","2020-06-17 17:35:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 17:35:30","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":["8492","RENT","\u9810\u7e73\u79df\u91d1",1,2079,"MO","1",2079,"2","2020-06-17 17:35:29","2","2020-06-17 17:35:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 17:35:30","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":["8492","RENT","\u9810\u7e73\u79df\u91d1",2,2079,"MO","1",2079,"2","2020-06-17 17:35:29","2","2020-06-17 17:35:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 17:35:30","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":["8492","RENT","\u9810\u7e73\u79df\u91d1",3,2079,"MO","1",2079,"2","2020-06-17 17:35:29","2","2020-06-17 17:35:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 17:35:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6237,0,"8492"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-17 17:35:30","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":[476,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208135","2020-06-17 17:35:29",6237,"2","2020-06-17 17:35:29","2","2020-06-17 17:35:29","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 17:35:30","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":["8135","DEPOSIT",null,"PAID","2020-06-17 17:35:29",0,"2","2020-06-17 17:35:29","2","2020-06-17 17:35:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 17:35:30","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":["8135","INVOICE","8492","PAID","2020-06-17 17:35:29",6237,"2","2020-06-17 17:35:29","2","2020-06-17 17:35:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 19:12:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-17 22:06:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****