{"created_at":"2020-05-29 10:30:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 10:38:37","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1522,"customer_code":"C201522","identity_type":"BUSINESS","identity_id":"36881187","title":"Ms","lastname":"LEUNG","firstname":"Shirley","companyname":"Maxwell International Holdings Limited","email":"info@maxwelldancing.com","tel":"93880422","address":"Rm 4206, 1 Harbor Road, Wan Chai","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4120.0","renew_rent_month":"3","renew_warehousing_date":"2020-05-26","renew_room_key":"0012415181","renew_remark":"3 months contract. Storage rental and deposit paid by bank transfer on Feb 25,2020. Smart card provided and mailed out on the same day.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT207262, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $4336.0","renew_master_room_id":"184","order_discount":[{"master_room_discount_id":"429","master_room_id":"184","discount_type":"%","price":"2168.00","disocunted_price":"2059.80","discount":"4.99","monthly_deduct":108.1832,"room_id":"1456","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1456","room_code":"C15-150","retail_price":"2168.0","discounted_price":2059.8,"location_id":"6"}],"roughly_size":"40","total_retail_price":2168,"total_discounted_price":2060,"deposit":4336,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":6180,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"4336.00","warehousing_date":"2020-05-26","rent_from":"2020-05-26","rent_to":"2020-08-25","delivery_service":"0","remark":"3 months contract. Change unit from C15-150,151 to C15-150. Storage deposit $4336 transferred from agreement C15-CT207262 to this agreement. Storage rental paid by bank transfer on May 28,2020.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":4336,"order_total":10516,"final_order_total":6180,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012415181","order_product":[],"pass":true}},"first_order_id":7262,"selected_room_tr":"\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t

---

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

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

\u5009\u5eab\u7de8\u865f<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u5c3a\u5bf8<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u539f\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u512a\u60e0\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>
C15-150 <\/td>\n\t\t\t\t\t	5X8X6.5 <\/td>\n\t\t\t\t\t	$2168.00 <\/td>\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\u522a\u9664<\/button>\n\t\t\t\t\t<\/td><\/tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\n\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"40","total_discounted_price":"2060.00","deposit":"4336.00","total_retail_price":"2168.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 10:38:38","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",1522,"NEW","C15-CT207985",2168,2060,4336,0,"3","3",6180,10516,6180,"2020-05-29 10:38:38","0",null,null,null,"2020-05-26","2020-08-25","3 months contract. Change unit from C15-150,151 to C15-150. Storage deposit $4336 transferred from agreement C15-CT207262 to this agreement. Storage rental paid by bank transfer on May 28,2020.","2020-05-26","40",0,null,4336,"4336.00","2","2020-05-29 10:38:37","2","2020-05-29 10:38:37","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012415181","C201522","BUSINESS","Ms","maGPoIyyOq0FH19ab1I12w==","yXKc2lCF323ApRADrjNaSg==","Maxwell International Holdings Limited","0sSvFlk0xEmkGkl6qzSoDP3TyPbPIvv2qR5QQuKdIPxEKEnWGgNWV6qnxj9vP3sQ","EGeyc0EeOLCcsqDPfA6YiQ==","4dnH0rljgTSIK1rTsoMWiSCW7EQLum6YOPZNSkfE778=",null,"nSr3gGP7oX\/irLGjgfYIKQ==",1,7262]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 10:38:38","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":["7985","429","184","1456","%","4.99",108.1832,"2","2020-05-29 10:38:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 10:38:38","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":["7985","1456","2168.0",2059.8,"2","2020-05-29 10:38:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 10:38:38","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-26","2020-08-25","1456"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-29 10:38:38","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":["7985","C15-D205435","PAID",4336,0,"2020-08-25","2020-05-29 10:38:37","2020-05-29 10:38:37","2","2020-05-29 10:38:37","2","2020-05-29 10:38:37",1522]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 10:38:38","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":["7985",1522,"SETTLED","C15-I208314","2020-05-29 10:38:37","2020-05-26","2","2020-05-29 10:38:37","2","2020-05-29 10:38:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 10:38:38","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":["8314","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-29 10:38:37","2","2020-05-29 10:38:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 10:38:38","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":["8314","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-05-29 10:38:37","2","2020-05-29 10:38:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 10:38:38","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":["8314","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,1844,"MO","1",1844,"2","2020-05-29 10:38:37","2","2020-05-29 10:38:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 10:38:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1844,0,"8314"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-29 10:38:38","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":[1522,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207958","2020-05-29 10:38:37",6180,"2","2020-05-29 10:38:37","2","2020-05-29 10:38:37","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 10:38:38","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":["7958","DEPOSIT","5435","PAID","2020-05-29 10:38:37",4336,"2","2020-05-29 10:38:37","2","2020-05-29 10:38:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 10:38:38","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":["7958","INVOICE","8314","PAID","2020-05-29 10:38:37",1844,"2","2020-05-29 10:38:37","2","2020-05-29 10:38:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 13:46: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":"","floor_plan_rent_room":[{"room_id":"1545","master_room_id":"201","room_code":"A16-054"}],"_payment_type":"INVOICE","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> L40 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1435,"customer_code":"C191435","identity_type":"PERSONAL","identity_id":"Z600823(3)","title":"Ms","lastname":"SO","firstname":"Ching Man","companyname":"","email":"manman_615@gmail.com","tel":"66857798","address":"\u9d28\u8137\u6d32\u5229\u6771\u90a8\u6771\u5e73\u6a133209\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"998.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-05","renew_room_key":"190,25713","renew_remark":"1 month contract. Storage rental paid by bank transfer on April 11, 2020. Storage deposit $1996 transferred from agreement A14-CT207411 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207616, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"562","room_code":"L40","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":998,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-05","rent_from":"2020-05-05","rent_to":"2020-06-04","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on May 24, 2020. Storage deposit $1996 transferred from agreement A14-CT207616 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":998,"final_order_total":998,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190,25713","order_product":[],"pass":true}},"first_order_id":"6294","roughly_size":"12","total_discounted_price":"998.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 13:46: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","2",1435,"NEW","A14-CT207986",998,998,0,0,"1","1",998,998,998,"2020-05-29 13:46:34","0",null,null,null,"2020-05-05","2020-06-04","1 month contract. Storage rental paid by bank transfer on May 24, 2020. Storage deposit $1996 transferred from agreement A14-CT207616 to this agreement.\r\n","2020-05-05","12",0,null,0,"0","2","2020-05-29 13:46:34","2","2020-05-29 13:46:34","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190,25713","C191435","PERSONAL","Ms","knZMm9GAZID7Lv+9MLc5ZA==","mOWsGT2TzOPDdjq14yV0zw==","","JP4Rs\/ygk7B5+4qY1O\/77mUgOqLhOV7RAed2ioH8C+7gkcorV\/Bk82G90L53vhh8","95CDSt30lRyCZEH4n270nw==","bE\/Jfb0PyFebKTBoaLQMLuSWgoH2ygJQ\/KlmIxPGGno=","v8f4b0Nv2Vl1ElMKQ09dDQ==",null,1,"6294"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 13:46: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":["7986","562","998.0","998.00","2","2020-05-29 13:46:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 13:46: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-05-05","2020-06-04","562"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-29 13:46: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":["7986",1435,"SETTLED","A14-I208315","2020-05-29 13:46:34","2020-05-05","2","2020-05-29 13:46:34","2","2020-05-29 13:46:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 13:46: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":["8315","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-05-29 13:46:34","2","2020-05-29 13:46:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 13:46:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"8315"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-29 13:46: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":[1435,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207959","2020-05-29 13:46:34",998,"2","2020-05-29 13:46:34","2","2020-05-29 13:46:34","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 13:46: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":["7959","DEPOSIT",null,"PAID","2020-05-29 13:46:34",0,"2","2020-05-29 13:46:34","2","2020-05-29 13:46:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 13:46: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":["7959","INVOICE","8315","PAID","2020-05-29 13:46:34",998,"2","2020-05-29 13:46:34","2","2020-05-29 13:46:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:14:28","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1707","master_room_id":"205","room_code":"A16-216"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A16-216 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1857.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"M739936(2)","title":"Ms","lastname":"REYES","firstname":"Portia Mamaclay","companyname":"","email":"portiareyes@gmail.com","tel":"96604983","address":"Unit 2514, Block Q, 6-8 Hong On Street, Kornhill, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1707","room_code":"A16-216","retail_price":"1857.0","discounted_price":"1857.00","location_id":"7"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":998,"deposit":1996,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3493,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1497.00","warehousing_date":"2020-05-30","rent_from":"2020-05-30","rent_to":"2020-08-29","delivery_service":"0","remark":"3 months contract. Special offer first 3 months 50% off, $499\/month. Storage rental and deposit paid by bank transfer on May 29, 2020. ","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":1497,"order_total":4990,"final_order_total":3493,"location_id":"7","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"roughly_size":"24","total_discounted_price":"998.00","deposit":"1996.00","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:14:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201596","PERSONAL","Ms","xDfBqogpSByT7nV1vfxHkw==","5KAEbrC6P7Bq5UKMFNrGaw==","","XIsQQ9eemnizowWhl59pmw==","TRiL9OJqWeWyYbUz7ofJgZ6\/9dmgj72k1XEXwW78bnE=","ogRDbRCz4BRte1vRXHDVO5yR\/beQ8PlfIqvt2hS+Gek2RUML98qfHWJFx7tijQFZ1dF3tJNfJiFXLRzHP\/4F9g==","I0seUC9TM+sl4q\/I24HPZA==",null,"TRiL9OJqWeWyYbUz7ofJgZ6\/9dmgj72k1XEXwW78bnE=","Zv3QfS6GH0YwLHOm+6EacQ==","2","2020-05-29 14:14:28","2","2020-05-29 14:14:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:14: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` = ?","parameters":["1","1","7",1596,"NEW","A16-CT207987",1857,998,1996,0,"3","3",3493,4990,3493,"2020-05-29 14:14:30","0",null,null,null,"2020-05-30","2020-08-29","3 months contract. Special offer first 3 months 50% off, $499\/month. Storage rental and deposit paid by bank transfer on May 29, 2020. ","2020-05-30","24",0,null,1497,"1497.00","2","2020-05-29 14:14:28","2","2020-05-29 14:14:28","BANKIN","","","","BANKIN","","","",null,0,"","C201596","PERSONAL","Ms","xDfBqogpSByT7nV1vfxHkw==","5KAEbrC6P7Bq5UKMFNrGaw==","","ogRDbRCz4BRte1vRXHDVO5yR\/beQ8PlfIqvt2hS+Gek2RUML98qfHWJFx7tijQFZ1dF3tJNfJiFXLRzHP\/4F9g==","XIsQQ9eemnizowWhl59pmw==","TRiL9OJqWeWyYbUz7ofJgZ6\/9dmgj72k1XEXwW78bnE=","I0seUC9TM+sl4q\/I24HPZA==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:14: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":["7987","1707","1857.0","1857.00","2","2020-05-29 14:14:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:14: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-30","2020-08-29","1707"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-29 14:14:30","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":["7987","A16-D205436","PAID",1996,0,"2020-08-29","2020-05-29 14:14:28","2020-05-29 14:14:28","2","2020-05-29 14:14:28","2","2020-05-29 14:14:28",1596]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:14: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":["7987",1596,"SETTLED","A16-I208316","2020-05-29 14:14:28","2020-05-30","2","2020-05-29 14:14:28","2","2020-05-29 14:14:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:14: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":["8316","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-29 14:14:28","2","2020-05-29 14:14:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:14: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":["8316","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,499,"MO","1",499,"2","2020-05-29 14:14:28","2","2020-05-29 14:14:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:14: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":["8316","RENT","\u9810\u7e73\u79df\u91d1",3,998,"MO","1",998,"2","2020-05-29 14:14:28","2","2020-05-29 14:14:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:14:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1497,0,"8316"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-29 14:14: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":[1596,"BANKIN","","","","BANKIN","","","","PAID","P207960","2020-05-29 14:14:28",3493,"2","2020-05-29 14:14:28","2","2020-05-29 14:14:28","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:14: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":["7960","DEPOSIT","5436","PAID","2020-05-29 14:14:28",1996,"2","2020-05-29 14:14:28","2","2020-05-29 14:14:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:14: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":["7960","INVOICE","8316","PAID","2020-05-29 14:14:28",1497,"2","2020-05-29 14:14:28","2","2020-05-29 14:14:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:44:32","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1401","master_room_id":"159","room_code":"C15-095"}],"selected_room_tr":"\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n\t\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\t\t\t\t \n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-096 <\/td>\n\t\t\t\t\t 3X3X6.5 <\/td>\n\t\t\t\t\t $720.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr> C15-095 <\/td>\n\t\t\t\t\t 3X3X6.5 <\/td>\n\t\t\t\t\t $720.00 <\/td>\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\n\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"D247838(3)","title":"Ms","lastname":"YU","firstname":"MAY WAH FANNY","companyname":"","email":"","tel":"91011012","address":"Flat 24B, Block 8, Wah Fung Sun Chuen, Quarry Bay ","pass":true,"customer_id":"1302","customer_code":"C191302","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1402","room_code":"C15-096","retail_price":"720.0","discounted_price":"720.00","location_id":"6"},{"room_id":"1401","room_code":"C15-095","retail_price":"720.0","discounted_price":"720.00","location_id":"6"}],"roughly_size":"18","total_retail_price":1440,"total_discounted_price":998,"deposit":1108,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":9756,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3328.00","warehousing_date":"2020-06-30","rent_from":"2020-06-30","rent_to":"2021-06-29","delivery_service":"0","remark":"12 months contract. Special offer the 11th &12th months free and 50% off for the first 3 months. Storage rental and deposit paid by bank transfer on May 29,2020. Smart card provided on 15 June,2019.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":3328,"order_total":13084,"final_order_total":9756,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0005832360","order_product":[],"pass":true}},"roughly_size":"18","total_discounted_price":"998.00","deposit":"1108.00","total_retail_price":"1440.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:44:32","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","3","6","1302","NEW","C15-CT207988",1440,998,1108,0,"12","12",9756,13084,9756,"2020-05-29 14:44:32","0",null,null,null,"2020-06-30","2021-06-29","12 months contract. Special offer the 11th &12th months free and 50% off for the first 3 months. Storage rental and deposit paid by bank transfer on May 29,2020. Smart card provided on 15 June,2019.","2020-06-30","18",0,null,3328,"3328.00","2","2020-05-29 14:44:32","2","2020-05-29 14:44:32","BANKIN","","","","BANKIN","","","",null,0,"0005832360","C191302","PERSONAL","Ms","SJl5mtclMxxls4thCtM4Yg==","4sZhlLfrmxrYN8eefiQ6Rg==","","1ThvMnPoNi5ho4y+yIjO8fTjvFE4ebS\/1J691E19ZNV9v2CEzPkoFqLA1M\/0R3W9slC+32AQywY8yqrIqz3Hug==","1N2L0Z0YyzH04BeLEfQvKQ==",null,"DYAJUdww6UI5QcPFZeevPg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:44:32","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":["7988","1402","720.0","720.00","2","2020-05-29 14:44:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:44:32","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-30","2021-06-29","1402"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-29 14:44:32","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":["7988","1401","720.0","720.00","2","2020-05-29 14:44:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:44:32","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-30","2021-06-29","1401"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-29 14:44:32","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":["7988","C15-D205437","PAID",1108,0,"2021-06-29","2020-05-29 14:44:32","2020-05-29 14:44:32","2","2020-05-29 14:44:32","2","2020-05-29 14:44:32","1302"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:44:32","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":["7988","1302","SETTLED","C15-I208317","2020-05-29 14:44:32","2020-06-30","2","2020-05-29 14:44:32","2","2020-05-29 14:44:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:44:32","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":["8317","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-29 14:44:32","2","2020-05-29 14:44:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:44:32","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":["8317","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-05-29 14:44:32","2","2020-05-29 14:44:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:44:32","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":["8317","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,0,"MO","1",0,"2","2020-05-29 14:44:32","2","2020-05-29 14:44:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:44:32","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":["8317","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",4,664,"MO","1",664,"2","2020-05-29 14:44:32","2","2020-05-29 14:44:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:44:32","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":["8317","RENT","\u9810\u7e73\u79df\u91d1",5,998,"MO","1",998,"2","2020-05-29 14:44:32","2","2020-05-29 14:44:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:44:32","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":["8317","RENT","\u9810\u7e73\u79df\u91d1",6,998,"MO","1",998,"2","2020-05-29 14:44:32","2","2020-05-29 14:44:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:44:32","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":["8317","RENT","\u9810\u7e73\u79df\u91d1",7,998,"MO","1",998,"2","2020-05-29 14:44:32","2","2020-05-29 14:44:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:44:32","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":["8317","RENT","\u9810\u7e73\u79df\u91d1",8,998,"MO","1",998,"2","2020-05-29 14:44:32","2","2020-05-29 14:44:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:44:32","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":["8317","RENT","\u9810\u7e73\u79df\u91d1",9,998,"MO","1",998,"2","2020-05-29 14:44:32","2","2020-05-29 14:44:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:44:32","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":["8317","RENT","\u9810\u7e73\u79df\u91d1",10,998,"MO","1",998,"2","2020-05-29 14:44:32","2","2020-05-29 14:44:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:44:32","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":["8317","RENT","\u9810\u7e73\u79df\u91d1",11,998,"MO","1",998,"2","2020-05-29 14:44:32","2","2020-05-29 14:44:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:44:32","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":["8317","RENT","\u9810\u7e73\u79df\u91d1",12,998,"MO","1",998,"2","2020-05-29 14:44:32","2","2020-05-29 14:44:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:44:32","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8648,0,"8317"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-29 14:44:32","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":["1302","BANKIN","","","","BANKIN","","","","PAID","P207961","2020-05-29 14:44:32",9756,"2","2020-05-29 14:44:32","2","2020-05-29 14:44:32","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:44:32","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":["7961","DEPOSIT","5437","PAID","2020-05-29 14:44:32",1108,"2","2020-05-29 14:44:32","2","2020-05-29 14:44:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 14:44:32","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":["7961","INVOICE","8317","PAID","2020-05-29 14:44:32",8648,"2","2020-05-29 14:44:32","2","2020-05-29 14:44:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 15:03:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:04:09","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:17:56","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1094&filter3=undefined","floor_plan_rent_room":[{"room_id":"1206","master_room_id":"140","room_code":"B01-016"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> B01-016 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1112.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","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"K048423(7)","title":"Mr","lastname":"TSE","firstname":"Benjamin","companyname":"","email":"hotbentse@hotmail.com","tel":"94640792","address":"Flat E, 8\/F, Rower 5, Island Resort, 28 Siu Sai Wan Rd, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"314","master_room_id":"140","discount_type":"%","price":"1112.00","disocunted_price":"1112.00","discount":"4.95","monthly_deduct":55.044,"room_id":"1206","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1206","room_code":"B01-016","retail_price":"1112.0","discounted_price":1057,"location_id":"5"}],"roughly_size":"16","total_retail_price":1112,"total_discounted_price":1112,"deposit":2224,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3892,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1668.00","warehousing_date":"2020-05-01","rent_from":"2020-05-01","rent_to":"2020-07-31","delivery_service":"0","remark":"3 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit $3892 paid by bank transfer on Apr 30,2020.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":1668,"order_total":5560,"final_order_total":3892,"location_id":"5","branch_id":"2","company_id":"1","room_key":"191,03186","order_product":[],"pass":true}},"roughly_size":"16","total_discounted_price":"1112.00","deposit":"2224.00","total_retail_price":"1112.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:17:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201597","PERSONAL","Mr","bwb96wH4qFOsW\/IXnLAdNw==","F7Lf58cOVR\/XRWFhxHffpg==","","F08yREgjUF9JrZg+uHTxcg==","Nh6WnR4XtVE8MZNLtmQczVeYSP9XgIZhSB7Ru\/RHVE0=","yfMFGUEmxy\/WdrA9UE4vAdxBg2y4BfG26VDW\/48ZPedX47V7uQ\/hgont16fmKegBvaa+8vlU0DBJTTRkLwHXHQ==","8qzp7YV3qjKpayyE2tSQHw==",null,"Nh6WnR4XtVE8MZNLtmQczVeYSP9XgIZhSB7Ru\/RHVE0=","oRhtWEuPjeBDk3orv5LU9w==","2","2020-05-29 16:17:56","2","2020-05-29 16:17:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:17:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","2","5",1597,"NEW","B01-CT207989",1112,1112,2224,0,"3","3",3892,5560,3892,"2020-05-29 16:17:58","0",null,null,null,"2020-05-01","2020-07-31","3 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit $3892 paid by bank transfer on Apr 30,2020.","2020-05-01","16",0,null,1668,"1668.00","2","2020-05-29 16:17:56","2","2020-05-29 16:17:56","BANKIN","","","","BANKIN","","","",null,0,"191,03186","C201597","PERSONAL","Mr","bwb96wH4qFOsW\/IXnLAdNw==","F7Lf58cOVR\/XRWFhxHffpg==","","yfMFGUEmxy\/WdrA9UE4vAdxBg2y4BfG26VDW\/48ZPedX47V7uQ\/hgont16fmKegBvaa+8vlU0DBJTTRkLwHXHQ==","F08yREgjUF9JrZg+uHTxcg==","Nh6WnR4XtVE8MZNLtmQczVeYSP9XgIZhSB7Ru\/RHVE0=","8qzp7YV3qjKpayyE2tSQHw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:17:58","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":["7989","314","140","1206","%","4.95",55.044,"2","2020-05-29 16:17:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:17:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7989","1206","1112.0",1057,"2","2020-05-29 16:17:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:17:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-01","2020-07-31","1206"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-29 16:17:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["7989","B01-D205438","PAID",2224,0,"2020-07-31","2020-05-29 16:17:56","2020-05-29 16:17:56","2","2020-05-29 16:17:56","2","2020-05-29 16:17:56",1597]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:17:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7989",1597,"SETTLED","B01-I208318","2020-05-29 16:17:56","2020-05-01","2","2020-05-29 16:17:56","2","2020-05-29 16:17:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:17:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8318","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-29 16:17:56","2","2020-05-29 16:17:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:17:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8318","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,556,"MO","1",556,"2","2020-05-29 16:17:56","2","2020-05-29 16:17:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:17:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8318","RENT","\u9810\u7e73\u79df\u91d1",3,1112,"MO","1",1112,"2","2020-05-29 16:17:56","2","2020-05-29 16:17:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:17:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1668,0,"8318"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-29 16:17:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1597,"BANKIN","","","","BANKIN","","","","PAID","P207962","2020-05-29 16:17:56",3892,"2","2020-05-29 16:17:56","2","2020-05-29 16:17:56","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:17:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7962","DEPOSIT","5438","PAID","2020-05-29 16:17:56",2224,"2","2020-05-29 16:17:56","2","2020-05-29 16:17:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:17:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7962","INVOICE","8318","PAID","2020-05-29 16:17:56",1668,"2","2020-05-29 16:17:56","2","2020-05-29 16:17:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:31:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:32:39","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1280,"customer_code":"C191280","identity_type":"PERSONAL","identity_id":"D459133(0)","title":"Mr","lastname":"LAM","firstname":"Shek Bo","companyname":"","email":null,"tel":"94289049","address":"Rm 8, 25\/F, Block B, ABBA House, 227 Aberdeen Main Road, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"698.0","renew_rent_month":"12","renew_warehousing_date":"2020-06-01","renew_room_key":"076,32594, 189,51782","renew_remark":"12 months contract. Special "Rent Now" offer 5% off. Storage rental and deposit paid by cash on May 30, 2019. 2 Smartcards provided on May 30, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195109, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1550.0","renew_master_room_id":"30","order_discount":[],"order_room":[{"room_id":"657","room_code":"M68","retail_price":"775.0","discounted_price":"775.00","location_id":"2"}],"roughly_size":"9","total_retail_price":775,"total_discounted_price":698,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":8376,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"698.00","warehousing_date":"2020-06-01","rent_from":"2020-06-01","rent_to":"2021-06-30","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by cash on May 29, 2020. Storage deposit $1550 transferred from agreement A14-CT195109 to this agreement. \r\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195109, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1550.0","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":698,"order_total":9074,"final_order_total":8376,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,32594, 189,51782","order_product":[],"pass":true}},"first_order_id":5109,"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> M68 <\/td>\r\n\t\t\t\t\t 3X3X8 <\/td>\r\n\t\t\t\t\t $775.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"9","total_discounted_price":"698.00","deposit":"0.00","total_retail_price":"775.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:32:39","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",1280,"NEW","A14-CT207990",775,698,0,0,"13","13",8376,9074,8376,"2020-05-29 16:32:39","0",null,null,null,"2020-06-01","2021-06-30","13 months contract. Special offer the 13th month free. Storage rental paid by cash on May 29, 2020. Storage deposit $1550 transferred from agreement A14-CT195109 to this agreement. \r\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195109, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1550.0","2020-06-01","9",0,null,698,"698.00","2","2020-05-29 16:32:39","2","2020-05-29 16:32:39","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"076,32594, 189,51782","C191280","PERSONAL","Mr","peShyZcVkQeK8dhtimZXDA==","BLxWt7e4owYJMFkn6\/eeMQ==","","nz4L0q7sLR\/3iWbPiVQkgJ9ebaviztv4aSXZyzFP+tppeWjO56tt2h+qua9zjAB3Kxwb8dnlIXfynXyrO\/RDNJ+534dIteRiF\/zCW8dGpv0=","7\/JJUHro8W2RSjQ7jMWpiw==",null,"QE+kKFqJOMjIit7vZVl9rg==",null,1,5109]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:32:39","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":["7990","657","775.0","775.00","2","2020-05-29 16:32:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:32:39","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-01","2021-06-30","657"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-29 16:32:39","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":["7990",1280,"SETTLED","A14-I208319","2020-05-29 16:32:39","2020-06-01","2","2020-05-29 16:32:39","2","2020-05-29 16:32:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:32:39","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":["8319","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,698,"MO","1",698,"2","2020-05-29 16:32:39","2","2020-05-29 16:32:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:32:39","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":["8319","RENT","\u9810\u7e73\u79df\u91d1",3,698,"MO","1",698,"2","2020-05-29 16:32:39","2","2020-05-29 16:32:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:32:39","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":["8319","RENT","\u9810\u7e73\u79df\u91d1",4,698,"MO","1",698,"2","2020-05-29 16:32:39","2","2020-05-29 16:32:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:32:39","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":["8319","RENT","\u9810\u7e73\u79df\u91d1",5,698,"MO","1",698,"2","2020-05-29 16:32:39","2","2020-05-29 16:32:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:32:39","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":["8319","RENT","\u9810\u7e73\u79df\u91d1",6,698,"MO","1",698,"2","2020-05-29 16:32:39","2","2020-05-29 16:32:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:32:39","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":["8319","RENT","\u9810\u7e73\u79df\u91d1",7,698,"MO","1",698,"2","2020-05-29 16:32:39","2","2020-05-29 16:32:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:32:39","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":["8319","RENT","\u9810\u7e73\u79df\u91d1",8,698,"MO","1",698,"2","2020-05-29 16:32:39","2","2020-05-29 16:32:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:32:39","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":["8319","RENT","\u9810\u7e73\u79df\u91d1",9,698,"MO","1",698,"2","2020-05-29 16:32:39","2","2020-05-29 16:32:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:32:39","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":["8319","RENT","\u9810\u7e73\u79df\u91d1",10,698,"MO","1",698,"2","2020-05-29 16:32:39","2","2020-05-29 16:32:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:32:39","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":["8319","RENT","\u9810\u7e73\u79df\u91d1",11,698,"MO","1",698,"2","2020-05-29 16:32:39","2","2020-05-29 16:32:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:32:39","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":["8319","RENT","\u9810\u7e73\u79df\u91d1",12,698,"MO","1",698,"2","2020-05-29 16:32:39","2","2020-05-29 16:32:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:32:39","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":["8319","RENT","\u9810\u7e73\u79df\u91d1",13,698,"MO","1",698,"2","2020-05-29 16:32:39","2","2020-05-29 16:32:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:32:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8376,0,"8319"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-29 16:32:39","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":[1280,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207963","2020-05-29 16:32:39",8376,"2","2020-05-29 16:32:39","2","2020-05-29 16:32:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:32:39","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":["7963","DEPOSIT",null,"PAID","2020-05-29 16:32:39",0,"2","2020-05-29 16:32:39","2","2020-05-29 16:32:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 16:32:39","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":["7963","INVOICE","8319","PAID","2020-05-29 16:32:39",8376,"2","2020-05-29 16:32:39","2","2020-05-29 16:32:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 17:12:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 17:12:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 17:16:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 17:23:01","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 17:40:09","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=1511&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":637,"customer_code":"C170637","identity_type":"PERSONAL","identity_id":"D706815(9)","title":"Mr","lastname":"Choy","firstname":"Yuk Ling Francis","companyname":"","email":"garyc2hk@yahoo.com.hk","tel":"94332403","address":"6E, 6\/F, Jing Hui Garden, 8 Aberdeen Main Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1228.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-01","renew_room_key":"055,14113","renew_remark":"1 month contract. Storage rental paid by PPS on April 28, 2020. Storage deposit $2456 transferred from agreement A18-CT207545 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207748, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"981","room_code":"X06","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1228,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-01","rent_from":"2020-06-01","rent_to":"2020-06-30","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on May 28, 2020. Storage deposit $2456 transferred from agreement A18-CT207748 to this agreement. \r\n\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1228,"final_order_total":1228,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,14113","order_product":[],"pass":true}},"first_order_id":"4858","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> X06 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1228.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 17:40:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",637,"NEW","A18-CT207991",1290,1228,0,0,"1","1",1228,1228,1228,"2020-05-29 17:40:10","0",null,null,null,"2020-06-01","2020-06-30","1 month contract. Storage rental paid by PPS on May 28, 2020. Storage deposit $2456 transferred from agreement A18-CT207748 to this agreement. \r\n\r\n","2020-06-01","16",0,null,0,"0","2","2020-05-29 17:40:09","2","2020-05-29 17:40:09","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,14113","C170637","PERSONAL","Mr","J+g+TeRBIdzsY6tyXdUL4DZdTF+kJBMmq07PxUuV2rQ=","UrsMAvfb5x9QBcnJ8435JA==","","IqhgG3xSMZDgzwxkBvRbXd3aZXF9S\/xKJDNT6bRp\/CaVT0KgEUyW3DMnqWGhAmYTEqUAiJDuiC0jx5487vY8cg==","46NXlqFaJugFX+V9A1awbQ==","j6foxYTVlm9b0h+GRpM4lraceSoVkydGqoE3S05vxDI=","zgahvSRYS8hsN+dhdAMC4A==",null,1,"4858"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 17:40:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7991","981","1290.0","1290.00","2","2020-05-29 17:40:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 17:40:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-06-30","981"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-29 17:40:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7991",637,"SETTLED","A18-I208320","2020-05-29 17:40:09","2020-06-01","2","2020-05-29 17:40:09","2","2020-05-29 17:40:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 17:40:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8320","RENT","\u9810\u7e73\u79df\u91d1",1,1228,"MO","1",1228,"2","2020-05-29 17:40:09","2","2020-05-29 17:40:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 17:40:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1228,0,"8320"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-29 17:40:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[637,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207964","2020-05-29 17:40:09",1228,"2","2020-05-29 17:40:09","2","2020-05-29 17:40:09","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 17:40:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7964","DEPOSIT",null,"PAID","2020-05-29 17:40:09",0,"2","2020-05-29 17:40:09","2","2020-05-29 17:40:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 17:40:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7964","INVOICE","8320","PAID","2020-05-29 17:40:09",1228,"2","2020-05-29 17:40:09","2","2020-05-29 17:40:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 17:43:05","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=1511&filter3=undefined&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":999,"customer_code":"C180999","identity_type":"PERSONAL","identity_id":"K209079(1)","title":"Mr","lastname":"Ho","firstname":"Ka Man","companyname":"","email":"hokaman1973@gmail.com","tel":"93080512","address":"Rm517, Chak Tsui Hse, Wan Tsui Estate, Chai Wan","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1678.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-28","renew_room_key":"0005821195","renew_remark":"1 month contract. Storage rental paid by PPS on April 27, 2020. Storage deposit $1678 transferred from agreement C15-CT207531 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT207736, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"161","order_discount":[],"order_room":[{"room_id":"1472","room_code":"C15-166","retail_price":"1678.0","discounted_price":"1678.00","location_id":"6"}],"roughly_size":"28","total_retail_price":1678,"total_discounted_price":1678,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1678,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-28","rent_from":"2020-05-28","rent_to":"2020-06-27","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on May 28, 2020. Storage deposit $1678 transferred from agreement C15-CT207736 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1678,"final_order_total":1678,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0005821195","order_product":[],"pass":true}},"first_order_id":"5351","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-166 <\/td>\r\n\t\t\t\t\t 3.5X8X6.5 <\/td>\r\n\t\t\t\t\t $1678.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":"1678.0","deposit":"0","total_retail_price":"1678.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 17:43:05","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",999,"NEW","C15-CT207992",1678,1678,0,0,"1","1",1678,1678,1678,"2020-05-29 17:43:05","0",null,null,null,"2020-05-28","2020-06-27","1 month contract. Storage rental paid by PPS on May 28, 2020. Storage deposit $1678 transferred from agreement C15-CT207736 to this agreement. \r\n","2020-05-28","28",0,null,0,"0","2","2020-05-29 17:43:05","2","2020-05-29 17:43:05","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0005821195","C180999","PERSONAL","Mr","mpGDaYSZYMm5Nv4dlC\/AXA==","D\/skxQ5s\/L5yyRWaDK\/iSg==","","s+jJD+PTKIcV6TFUbKAjZeaR7whyPq\/zYSwZaQ3P71eVxgGVseccbnTawUyuMcS0","6hDDMUpiAw3i7Vyi+5LUuw==","O5CaJhqkZvhJIkWAmdNjem53qQvwEVnuhSQx55cm2I4=","lBWb6eJ9jDFkCCTNwsJ4wA==",null,1,"5351"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 17:43:05","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":["7992","1472","1678.0","1678.00","2","2020-05-29 17:43:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 17:43:05","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-28","2020-06-27","1472"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-29 17:43:05","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":["7992",999,"SETTLED","C15-I208321","2020-05-29 17:43:05","2020-05-28","2","2020-05-29 17:43:05","2","2020-05-29 17:43:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 17:43:05","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":["8321","RENT","\u9810\u7e73\u79df\u91d1",1,1678,"MO","1",1678,"2","2020-05-29 17:43:05","2","2020-05-29 17:43:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 17:43:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1678,0,"8321"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-29 17:43:05","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":[999,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207965","2020-05-29 17:43:05",1678,"2","2020-05-29 17:43:05","2","2020-05-29 17:43:05","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 17:43:05","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":["7965","DEPOSIT",null,"PAID","2020-05-29 17:43:05",0,"2","2020-05-29 17:43:05","2","2020-05-29 17:43:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 17:43:05","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":["7965","INVOICE","8321","PAID","2020-05-29 17:43:05",1678,"2","2020-05-29 17:43:05","2","2020-05-29 17:43:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 17:44:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 17:44:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 17:58:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 18:27:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 18:52:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 19:08:22","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=1511&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1269","master_room_id":"142","room_code":"B01-079"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> B01-079 <\/td>\r\n\t\t\t\t\t 4X5.5X7 <\/td>\r\n\t\t\t\t\t $1398.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","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"D557515(0)","title":"Ms","lastname":"CHAN","firstname":"Tsui Ping","companyname":"","email":"","tel":"93059121","address":"Flat E, 21\/F, Block 2, Cheerful Garden, Siu Sai Wan, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"318","master_room_id":"142","discount_type":"%","price":"1398.00","disocunted_price":"1328.80","discount":"4.95","monthly_deduct":69.201,"room_id":"1269","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1269","room_code":"B01-079","retail_price":"1398.0","discounted_price":1328.8,"location_id":"5"}],"roughly_size":"22","total_retail_price":1398,"total_discounted_price":1398,"deposit":2796,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":4893,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2097.00","warehousing_date":"2020-06-06","rent_from":"2020-06-06","rent_to":"2020-09-05","delivery_service":"0","remark":"3 months contract. Special offer first 3 months 50% off. Storage rental and deposit paid by bank transfer on May 29, 2020. Smartcard mails on May 29, 2020. ","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":2097,"order_total":6990,"final_order_total":4893,"location_id":"5","branch_id":"2","company_id":"1","room_key":"'0012415117","order_product":[],"pass":true}},"roughly_size":"22","total_discounted_price":"1398.00","deposit":"2796.00","total_retail_price":"1398.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 19:08:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201598","PERSONAL","Ms","vXGdTNy9LvwX04wnIqWpkA==","8BEgNhGpCR8jGkzUtrIcXg==","","PZmnfiJYWeWxoAH0DzfB+g==",null,"raL9mQIdPGGwWsIuGBAHNmPBT8S4upMWPFVQNnXp0GCnN1LtR+CcK0yT2TbpMBlszikNQTVbrVF\/Fs5dqIAKNQ==","L3GdH0wCX1Q8+8ucB43nlw==",null,null,"B4cRdGOOZRMdPq2DpQPeXQ==","2","2020-05-29 19:08:22","2","2020-05-29 19:08:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 19:08: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` = ?","parameters":["1","2","5",1598,"NEW","B01-CT207993",1398,1398,2796,0,"3","3",4893,6990,4893,"2020-05-29 19:08:24","0",null,null,null,"2020-06-06","2020-09-05","3 months contract. Special offer first 3 months 50% off. Storage rental and deposit paid by bank transfer on May 29, 2020. Smartcard mails on May 29, 2020. ","2020-06-06","22",0,null,2097,"2097.00","2","2020-05-29 19:08:22","2","2020-05-29 19:08:22","BANKIN","","","","BANKIN","","","",null,0,"'0012415117","C201598","PERSONAL","Ms","vXGdTNy9LvwX04wnIqWpkA==","8BEgNhGpCR8jGkzUtrIcXg==","","raL9mQIdPGGwWsIuGBAHNmPBT8S4upMWPFVQNnXp0GCnN1LtR+CcK0yT2TbpMBlszikNQTVbrVF\/Fs5dqIAKNQ==","PZmnfiJYWeWxoAH0DzfB+g==",null,"L3GdH0wCX1Q8+8ucB43nlw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 19:08:24","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":["7993","318","142","1269","%","4.95",69.201,"2","2020-05-29 19:08:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 19:08: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":["7993","1269","1398.0",1328.8,"2","2020-05-29 19:08:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 19:08: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-06","2020-09-05","1269"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-29 19:08:24","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":["7993","B01-D205439","PAID",2796,0,"2020-09-05","2020-05-29 19:08:22","2020-05-29 19:08:22","2","2020-05-29 19:08:22","2","2020-05-29 19:08:22",1598]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 19:08: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":["7993",1598,"SETTLED","B01-I208322","2020-05-29 19:08:22","2020-06-06","2","2020-05-29 19:08:22","2","2020-05-29 19:08:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 19:08: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":["8322","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-29 19:08:22","2","2020-05-29 19:08:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 19:08: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":["8322","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,699,"MO","1",699,"2","2020-05-29 19:08:22","2","2020-05-29 19:08:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 19:08: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":["8322","RENT","\u9810\u7e73\u79df\u91d1",3,1398,"MO","1",1398,"2","2020-05-29 19:08:22","2","2020-05-29 19:08:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 19:08:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2097,0,"8322"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-29 19:08: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":[1598,"BANKIN","","","","BANKIN","","","","PAID","P207966","2020-05-29 19:08:22",4893,"2","2020-05-29 19:08:22","2","2020-05-29 19:08:22","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 19:08: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":["7966","DEPOSIT","5439","PAID","2020-05-29 19:08:22",2796,"2","2020-05-29 19:08:22","2","2020-05-29 19:08:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-29 19:08: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":["7966","INVOICE","8322","PAID","2020-05-29 19:08:22",2097,"2","2020-05-29 19:08:22","2","2020-05-29 19:08:22"]},"data_before":[],"data_after":[],"step":1} *****