{"created_at":"2020-03-17 10:03:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 10:27:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 10:39:54","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=1146&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"732","master_room_id":"34","room_code":"O08"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":533,"customer_code":"C170533","identity_type":"PERSONAL","identity_id":"D702226(2)","title":"Mr","lastname":"Leung","firstname":"Ming Fai","companyname":"","email":"leungmingfai@hotmail.com","tel":"62805618","address":"Flat G,9\/F, Kam Fung Mansion, 171 Aberdeen Main Rd, Aberdeen ","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-18","renew_room_key":"136,58083","renew_remark":"1 month contract. Storage rental paid by bank transfer on February 17, 2020. Storage deposit transferred from agreement A14-CT206995 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207211, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"754","room_code":"O30","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-18","rent_from":"2020-02-18","rent_to":"2020-03-17","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on March 16, 2020. Storage deposit transferred from agreement A14-CT207211 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"2","branch_id":"1","company_id":"1","room_key":"136,58083","order_product":[],"pass":true}},"first_order_id":"4566","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>
O30 <\/td>\r\n\t\t\t\t\t	4X3X8 <\/td>\r\n\t\t\t\t\t	$998.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 10:39:55","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",533,"NEW","A14-CT207415",998,1038,0,0,"1","1",1038,1038,1038,"2020-03-17 10:39:55","0",null,null,null,"2020-02-18","2020-03-17","1 month contract. Storage rental paid by bank transfer on March 16, 2020. Storage deposit transferred from agreement A14-CT207211 to this agreement.\r\n","2020-02-18","12",0,null,0,"0","2","2020-03-17 10:39:54","2","2020-03-17 10:39:54","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"136,58083","C170533","PERSONAL","Mr","ltCiTyDjJ0Gdz4KiVHpL3w==","xEf2h2aoyRQ71ZVgBH+9WQ==","","oxxB92pGHSI9I6dk86NeV50fIKbJm7OHBHlNQ0XlFwdi0YrCU3uueNLGwLXtYZ27jc2ffcQTK04oDV5uyRKmsw==","65I9HJH8Lb0dMm8MBuRKKw==","UoHdQ18xnvupRvjCY9wtS6MZZ24DKjVuPgYYyCDQhRU=","IiBGQKIxd9Yo4PXXqWkRIg==",null,1,"4566"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 10:39:55","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":["7415","754","998.0","998.00","2","2020-03-17 10:39:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 10:39:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-18","2020-03-17","754"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-17 10:39:55","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":["7415",533,"SETTLED","A14-I207743","2020-03-17 10:39:54","2020-02-18","2","2020-03-17 10:39:54","2","2020-03-17 10:39:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 10:39:55","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":["7743","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-03-17 10:39:54","2","2020-03-17 10:39:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 10:39:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"7743"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-17 10:39:55","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":[533,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207391","2020-03-17 10:39:54",1038,"2","2020-03-17 10:39:54","2","2020-03-17 10:39:54","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 10:39:55","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":["7391","DEPOSIT",null,"PAID","2020-03-17 10:39:54",0,"2","2020-03-17 10:39:54","2","2020-03-17 10:39:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 10:39:55","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":["7391","INVOICE","7743","PAID","2020-03-17 10:39:54",1038,"2","2020-03-17 10:39:54","2","2020-03-17 10:39:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:27:42","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"1337","master_room_id":"188","room_code":"C15-031"}],"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> C15-031 <\/td>\r\n\t\t\t\t\t 7X5X6.5 <\/td>\r\n\t\t\t\t\t $1938.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"K436363(9)","title":"Ms","lastname":"WONG","firstname":"Ngar Yan","companyname":"","email":"genevewong811@gmail.com","tel":"90420124","address":"Rm 560, Tai On Building, 57-87 Shau Kei Wan Rd, Hong Kong","pass":true,"customer_id":"1536","customer_code":"C201536","customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1337","room_code":"C15-031","retail_price":"1938.0","discounted_price":"1938.00","location_id":"6"}],"roughly_size":"35","total_retail_price":1938,"total_discounted_price":1745,"deposit":1938,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":18518,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"4360.00","warehousing_date":"2020-03-15","rent_from":"2020-03-15","rent_to":"2021-03-14","delivery_service":"0","remark":"12 months contract. Special offer 5% 'rent now' discount. $500 deposit paid by EPS on Mar 11,2020. The balance of storage rental and deposit paid by bank transfer on Mar 14,2020.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":4360,"order_total":22938,"final_order_total":18578,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012490550","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"pass":true}},"roughly_size":"35","total_discounted_price":"1745.00","deposit":"1938.00","total_retail_price":"1938.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:27:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","3","6","1536","NEW","C15-CT207416",1938,1745,1938,0,"12","12",18518,22938,18578,"2020-03-17 11:27:43","0",null,null,null,"2020-03-15","2021-03-14","12 months contract. Special offer 5% 'rent now' discount. $500 deposit paid by EPS on Mar 11,2020. The balance of storage rental and deposit paid by bank transfer on Mar 14,2020.","2020-03-15","35",0,null,4360,"4360.00","2","2020-03-17 11:27:42","2","2020-03-17 11:27:42","BANKIN","","","","BANKIN","","","",null,0,"0012490550","C201536","PERSONAL","Ms","sv4DsLdaxX9bS2j3xQT\/yw==","ddrfzAYTmkL\/QNu3psjONQ==","","HpCrqNFXBJyq9gpogE3bXYS+BpPvESXfyrrZEfGs4SUontlGRrTAwTUmJJG2CgyBX5m4qL+wGeC34840BCls3g==","TcJDX\/VCGluFTysFoL0VXQ==","4BEzPqYdgneltd8BsHrbT4wOAl6NJpQTeYhDaKdWGPg=","0Hm+MxqwbgMBj1EKcaCjkg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:27:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7416","1536","11","1","60.0",60,"2","2020-03-17 11:27:42","2","2020-03-17 11:27:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:27:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"7416"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-03-17 11:27:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7416","1337","1938.0","1938.00","2","2020-03-17 11:27:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:27:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-15","2021-03-14","1337"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-17 11:27:43","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":["7416","C15-D205321","PAID",1938,0,"2021-03-14","2020-03-17 11:27:42","2020-03-17 11:27:42","2","2020-03-17 11:27:42","2","2020-03-17 11:27:42","1536"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:27:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7416","1536","SETTLED","C15-I207744","2020-03-17 11:27:42","2020-03-15","2","2020-03-17 11:27:42","2","2020-03-17 11:27:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:27:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7744","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-03-17 11:27:42","2","2020-03-17 11:27:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:27:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7744","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-03-17 11:27:42","2","2020-03-17 11:27:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:27:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7744","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,875,"MO","1",875,"2","2020-03-17 11:27:42","2","2020-03-17 11:27:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:27:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7744","RENT","\u9810\u7e73\u79df\u91d1",4,1745,"MO","1",1745,"2","2020-03-17 11:27:42","2","2020-03-17 11:27:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:27:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7744","RENT","\u9810\u7e73\u79df\u91d1",5,1745,"MO","1",1745,"2","2020-03-17 11:27:42","2","2020-03-17 11:27:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:27:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7744","RENT","\u9810\u7e73\u79df\u91d1",6,1745,"MO","1",1745,"2","2020-03-17 11:27:42","2","2020-03-17 11:27:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:27:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7744","RENT","\u9810\u7e73\u79df\u91d1",7,1745,"MO","1",1745,"2","2020-03-17 11:27:42","2","2020-03-17 11:27:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:27:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7744","RENT","\u9810\u7e73\u79df\u91d1",8,1745,"MO","1",1745,"2","2020-03-17 11:27:42","2","2020-03-17 11:27:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:27:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7744","RENT","\u9810\u7e73\u79df\u91d1",9,1745,"MO","1",1745,"2","2020-03-17 11:27:42","2","2020-03-17 11:27:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:27:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7744","RENT","\u9810\u7e73\u79df\u91d1",10,1745,"MO","1",1745,"2","2020-03-17 11:27:42","2","2020-03-17 11:27:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:27:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7744","RENT","\u9810\u7e73\u79df\u91d1",11,1745,"MO","1",1745,"2","2020-03-17 11:27:42","2","2020-03-17 11:27:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:27:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7744","RENT","\u9810\u7e73\u79df\u91d1",12,1745,"MO","1",1745,"2","2020-03-17 11:27:42","2","2020-03-17 11:27:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:27:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7744","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-03-17 11:27:42","2","2020-03-17 11:27:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:27:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[16640,0,"7744"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-17 11:27:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["1536","BANKIN","","","","BANKIN","","","","PAID","P207392","2020-03-17 11:27:42",18578,"2","2020-03-17 11:27:42","2","2020-03-17 11:27:42","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:27:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7392","DEPOSIT","5321","PAID","2020-03-17 11:27:42",1938,"2","2020-03-17 11:27:42","2","2020-03-17 11:27:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:27:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7392","INVOICE","7744","PAID","2020-03-17 11:27:42",16640,"2","2020-03-17 11:27:42","2","2020-03-17 11:27:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:28: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=1146&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"732","master_room_id":"34","room_code":"O08"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":952,"customer_code":"C180952","identity_type":"PERSONAL","identity_id":"K172832(0)","title":"Ms","lastname":"Ling","firstname":"Kam Yin Aydy","companyname":"","email":null,"tel":"91008222","address":"Flat 32, 13\/F, 32 Whitty Street, Shek Tong Tsui, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1817.0","renew_rent_month":"6","renew_warehousing_date":"2020-03-22","renew_room_key":"0012518441","renew_remark":"6 months contract. Storage rental and deposit paid by bank transfer on Nov 09,2019. Deposit $4176 transferred from agreement C15-CT83063 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT196339, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"179","order_discount":[],"order_room":[{"room_id":"1471","room_code":"C15-165","retail_price":"2018.0","discounted_price":"2018.00","location_id":"6"}],"roughly_size":"36","total_retail_price":2018,"total_discounted_price":1817,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":10902,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-22","rent_from":"2020-03-22","rent_to":"2020-09-21","delivery_service":"0","remark":"6 months contract. Storage rental and deposit paid by PPS on March 17, 2020. Deposit $4176 transferred from agreement C15-CT196339 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":10902,"final_order_total":10902,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012518441","order_product":[],"pass":true}},"first_order_id":"3063","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-165 <\/td>\r\n\t\t\t\t\t 4.5X8X6.5 <\/td>\r\n\t\t\t\t\t $2018.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":"36","total_discounted_price":"1817.0","deposit":"0","total_retail_price":"2018.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:28:22","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",952,"NEW","C15-CT207417",2018,1817,0,0,"6","6",10902,10902,10902,"2020-03-17 11:28:22","0",null,null,null,"2020-03-22","2020-09-21","6 months contract. Storage rental and deposit paid by PPS on March 17, 2020. Deposit $4176 transferred from agreement C15-CT196339 to this agreement.","2020-03-22","36",0,null,0,"0","2","2020-03-17 11:28:22","2","2020-03-17 11:28:22","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012518441","C180952","PERSONAL","Ms","OET5XHG7Txi\/BcmbsU09\/g==","HO5WkyMicWQD3rOIs347gA==","","qnqTzqltx8BzR5PTx7UT2WHIKx91uYBrMJXe9QX\/ssYGWoi\/vdJEtArFBhYweMo70rnj+q0cDKmWXJOV+vTIeQ==","45N21T\/9v8giv1S2LSyUsw==",null,"us5XTaD2oGfABGf08X58YA==",null,1,"3063"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:28:22","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":["7417","1471","2018.0","2018.00","2","2020-03-17 11:28:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:28:22","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-03-22","2020-09-21","1471"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-17 11:28:22","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":["7417",952,"SETTLED","C15-I207745","2020-03-17 11:28:22","2020-03-22","2","2020-03-17 11:28:22","2","2020-03-17 11:28:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:28:22","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":["7745","RENT","\u9810\u7e73\u79df\u91d1",1,1817,"MO","1",1817,"2","2020-03-17 11:28:22","2","2020-03-17 11:28:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:28:22","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":["7745","RENT","\u9810\u7e73\u79df\u91d1",2,1817,"MO","1",1817,"2","2020-03-17 11:28:22","2","2020-03-17 11:28:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:28:22","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":["7745","RENT","\u9810\u7e73\u79df\u91d1",3,1817,"MO","1",1817,"2","2020-03-17 11:28:22","2","2020-03-17 11:28:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:28:22","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":["7745","RENT","\u9810\u7e73\u79df\u91d1",4,1817,"MO","1",1817,"2","2020-03-17 11:28:22","2","2020-03-17 11:28:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:28:22","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":["7745","RENT","\u9810\u7e73\u79df\u91d1",5,1817,"MO","1",1817,"2","2020-03-17 11:28:22","2","2020-03-17 11:28:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:28:22","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":["7745","RENT","\u9810\u7e73\u79df\u91d1",6,1817,"MO","1",1817,"2","2020-03-17 11:28:22","2","2020-03-17 11:28:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:28:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10902,0,"7745"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-17 11:28:22","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":[952,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207393","2020-03-17 11:28:22",10902,"2","2020-03-17 11:28:22","2","2020-03-17 11:28:22","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:28:22","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":["7393","DEPOSIT",null,"PAID","2020-03-17 11:28:22",0,"2","2020-03-17 11:28:22","2","2020-03-17 11:28:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:28:22","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":["7393","INVOICE","7745","PAID","2020-03-17 11:28:22",10902,"2","2020-03-17 11:28:22","2","2020-03-17 11:28:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:31:24","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=1146&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"732","master_room_id":"34","room_code":"O08"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1301,"customer_code":"C191301","identity_type":"PERSONAL","identity_id":"K08388(5)","title":"Ms","lastname":"Kwan","firstname":"Yuen Yee Amy","companyname":"","email":"akyyhk@yahoo.com","tel":"92750360","address":"Flat L, 9\/F, Blk 5, Hong Sing Garden, Tseung Kwan O, N.T.","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-16","renew_room_key":"111,40893","renew_remark":"1 month contract. Storage rental paid by PPS on February 7, 2020. Storage deposit transferred from agreement A16-CT206971 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT207146, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"202","order_discount":[],"order_room":[{"room_id":"1519","room_code":"A16-028","retail_price":"1290.0","discounted_price":"1290.00","location_id":"7"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1290,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-16","rent_from":"2020-03-16","rent_to":"2020-04-15","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on March 16, 2020. Storage deposit transferred from agreement A16-CT207146 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"7","branch_id":"1","company_id":"1","room_key":"111,40893","order_product":[],"pass":true}},"first_order_id":"5235","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A16-028 <\/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> <\/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":"1290.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:31:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","7",1301,"NEW","A16-CT207418",1290,1290,0,0,"1","1",1290,1290,1290,"2020-03-17 11:31:25","0",null,null,null,"2020-03-16","2020-04-15","1 month contract. Storage rental paid by PPS on March 16, 2020. Storage deposit transferred from agreement A16-CT207146 to this agreement.\r\n","2020-03-16","16",0,null,0,"0","2","2020-03-17 11:31:24","2","2020-03-17 11:31:24","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"111,40893","C191301","PERSONAL","Ms","5wigC8kzb56lGRRSAEYGsw==","iNwdG3Dj3OBaAQ6MRfBM1w==","","\/Ewh1holgp6WSTJa\/JHYhYvoqKRvnYtpL3yQk4vYZf\/xWDWin6QHzWL6hMnAUJ4T8XbSzfh5jMoFXOktD1XRYw==","YESwwapoFqF3cRsBQ+uG6A==","G8w9ZbnhyRcx0XoYCRwUCjIw8+4PSVsFNffrrS+i8x4=","kt7RlFLP4CUDPa9sfSXSrg==",null,1,"5235"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:31:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7418","1519","1290.0","1290.00","2","2020-03-17 11:31:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:31:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-16","2020-04-15","1519"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-17 11:31:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7418",1301,"SETTLED","A16-I207746","2020-03-17 11:31:24","2020-03-16","2","2020-03-17 11:31:24","2","2020-03-17 11:31:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:31:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7746","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-03-17 11:31:24","2","2020-03-17 11:31:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:31:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"7746"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-17 11:31:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1301,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207394","2020-03-17 11:31:24",1290,"2","2020-03-17 11:31:24","2","2020-03-17 11:31:24","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:31:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7394","DEPOSIT",null,"PAID","2020-03-17 11:31:24",0,"2","2020-03-17 11:31:24","2","2020-03-17 11:31:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:31:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7394","INVOICE","7746","PAID","2020-03-17 11:31:24",1290,"2","2020-03-17 11:31:24","2","2020-03-17 11:31:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:33:12","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1146&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"732","master_room_id":"34","room_code":"O08"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":312,"customer_code":"C170312","identity_type":"PERSONAL","identity_id":"Z087903(8)","title":"Ms","lastname":"Chong","firstname":"King Chi Vicki","companyname":"","email":null,"tel":"90521886","address":"\u9999\u6e2f\u4ed4\u4e2d\u5fc3\u5de5I\u5ea71601","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1358.0","renew_rent_month":"6","renew_warehousing_date":"2020-03-21","renew_room_key":"055,14467","renew_remark":"6 months contract. Storage rental paid by bank transfer on Sep 9, 2019. Storage deposit transferred from agreement A14-CT194570 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195910, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"44","order_discount":[],"order_room":[{"room_id":"774","room_code":"P08","retail_price":"1768.0","discounted_price":"1768.00","location_id":"2"}],"roughly_size":"24","total_retail_price":1768,"total_discounted_price":1358,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":8148,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-21","rent_from":"2020-03-21","rent_to":"2020-09-20","delivery_service":"0","remark":"6 months contract. Storage rental paid by PPS on March 16, 2020. Storage deposit transferred from agreement A14-CT195910 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":8148,"final_order_total":8148,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,14467","order_product":[],"pass":true}},"first_order_id":"4570","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> P08 <\/td>\r\n\t\t\t\t\t 4X6X8 <\/td>\r\n\t\t\t\t\t $1768.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1358.0","deposit":"0","total_retail_price":"1768.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:33:13","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",312,"NEW","A14-CT207419",1768,1358,0,0,"6","6",8148,8148,8148,"2020-03-17 11:33:13","0",null,null,null,"2020-03-21","2020-09-20","6 months contract. Storage rental paid by PPS on March 16, 2020. Storage deposit transferred from agreement A14-CT195910 to this agreement.\r\n","2020-03-21","24",0,null,0,"0","2","2020-03-17 11:33:12","2","2020-03-17 11:33:12","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,14467","C170312","PERSONAL","Ms","Y7CsY4XQJMJT7jKPSB9HvQ==","xoslI7xaq8EyGcHiI7WJHQ==","","qZRT3NfbiP3Uu42B6TvANV\/XutkU4a0YhlwK1hCirGQ=","8dR8AfYtaUEztbarN40S4A==",null,"mP+5eOkNwbLcDHm9OqXQ3w==",null,1,"4570"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:33:13","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":["7419","774","1768.0","1768.00","2","2020-03-17 11:33:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:33:13","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-03-21","2020-09-20","774"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-17 11:33:13","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":["7419",312,"SETTLED","A14-I207747","2020-03-17 11:33:12","2020-03-21","2","2020-03-17 11:33:12","2","2020-03-17 11:33:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:33:13","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":["7747","RENT","\u9810\u7e73\u79df\u91d1",1,1358,"MO","1",1358,"2","2020-03-17 11:33:12","2","2020-03-17 11:33:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:33:13","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":["7747","RENT","\u9810\u7e73\u79df\u91d1",2,1358,"MO","1",1358,"2","2020-03-17 11:33:12","2","2020-03-17 11:33:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:33:13","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":["7747","RENT","\u9810\u7e73\u79df\u91d1",3,1358,"MO","1",1358,"2","2020-03-17 11:33:12","2","2020-03-17 11:33:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:33:13","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":["7747","RENT","\u9810\u7e73\u79df\u91d1",4,1358,"MO","1",1358,"2","2020-03-17 11:33:12","2","2020-03-17 11:33:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:33:13","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":["7747","RENT","\u9810\u7e73\u79df\u91d1",5,1358,"MO","1",1358,"2","2020-03-17 11:33:12","2","2020-03-17 11:33:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:33:13","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":["7747","RENT","\u9810\u7e73\u79df\u91d1",6,1358,"MO","1",1358,"2","2020-03-17 11:33:12","2","2020-03-17 11:33:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:33:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8148,0,"7747"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-17 11:33:13","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":[312,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207395","2020-03-17 11:33:12",8148,"2","2020-03-17 11:33:12","2","2020-03-17 11:33:12","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:33:13","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":["7395","DEPOSIT",null,"PAID","2020-03-17 11:33:12",0,"2","2020-03-17 11:33:12","2","2020-03-17 11:33:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:33:13","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":["7395","INVOICE","7747","PAID","2020-03-17 11:33:12",8148,"2","2020-03-17 11:33:12","2","2020-03-17 11:33:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:37:40","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=1146&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"732","master_room_id":"34","room_code":"O08"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1228,"customer_code":"C191228","identity_type":"BUSINESS","identity_id":"C.I. No. 7527","title":"Ms","lastname":"Chu","firstname":"Shuk Fung","companyname":"The Hong Kong Vajrayana Esoteric Society Limited","email":"infovajrayanahk@gmail.com","tel":"94170260","address":"Room A, 1\/F, Chin Hung Building, 5 Heard Street, Wan Chai, Hong Kong ","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1952.0","renew_rent_month":"12","renew_warehousing_date":"2020-04-01","renew_room_key":"'0012449278, 0012467711","renew_remark":"12 months contract. Special offer 2 months free. Storage rental and deposit paid by EPS on March 21, 2019. Smartcard provided on March 21, 2019. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT194627, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2168.0","renew_master_room_id":"160","order_discount":[],"order_room":[{"room_id":"1485","room_code":"C15-179","retail_price":"1518.0","discounted_price":"1518.00","location_id":"6"},{"room_id":"1487","room_code":"C15-181","retail_price":"968.0","discounted_price":"968.00","location_id":"6"}],"roughly_size":"40","total_retail_price":2486,"total_discounted_price":1952,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":23424,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1952.00","warehousing_date":"2020-04-01","rent_from":"2020-04-01","rent_to":"2021-04-30","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by PPS on March 16, 2020. Storage deposit $2168 transferred from agreement C15-CT194627 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":1952,"order_total":25376,"final_order_total":23424,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012449278, 0012467711","order_product":[],"pass":true}},"first_order_id":4627,"selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-179 <\/td>\r\n\t\t\t\t\t 5X5X6.5 <\/td>\r\n\t\t\t\t\t $1518.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> C15-181 <\/td>\r\n\t\t\t\t\t 3X5X6.5 <\/td>\r\n\t\t\t\t\t $968.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":"40","total_discounted_price":"1952.00","deposit":"0.00","total_retail_price":"2486.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:37:40","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",1228,"NEW","C15-CT207420",2486,1952,0,0,"13","13",23424,25376,23424,"2020-03-17 11:37:40","0",null,null,null,"2020-04-01","2021-04-30","13 months contract. Special offer the 13th month free. Storage rental paid by PPS on March 16, 2020. Storage deposit $2168 transferred from agreement C15-CT194627 to this agreement. \r\n","2020-04-01","40",0,null,1952,"1952.00","2","2020-03-17 11:37:40","2","2020-03-17 11:37:40","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"'0012449278, 0012467711","C191228","BUSINESS","Ms","EwhbAVtcr\/+4QEjoBKrBHg==","uwdKi3S38jh5+tBibXKG4A==","The Hong Kong Vajrayana Esoteric Society Limited","UYw3DJGFeZVAHJ\/FvS994gMCf3spOswmcd84Vxq7EnaDsg4KudW4lWTLye9\/NQGrSc6Yde1Cx+FXhoXQWazAUCB7lx3wj7kuH52MQ2J7Nsc=","4q12l5YV14WOSi1RLvADaw==","0t0E2xPU2iRSawAtTE0uA0+H9hpffA7lgKjdAlY\/O9Y=",null,"72AaWNKBBHvQxIuBu5u0mg==",1,4627]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:37:40","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":["7420","1485","1518.0","1518.00","2","2020-03-17 11:37:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:37:40","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-04-01","2021-04-30","1485"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-17 11:37:40","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":["7420","1487","968.0","968.00","2","2020-03-17 11:37:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:37:40","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-04-01","2021-04-30","1487"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-17 11:37:40","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":["7420",1228,"SETTLED","C15-I207748","2020-03-17 11:37:40","2020-04-01","2","2020-03-17 11:37:40","2","2020-03-17 11:37:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:37:40","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":["7748","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1952,"MO","1",1952,"2","2020-03-17 11:37:40","2","2020-03-17 11:37:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:37:40","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":["7748","RENT","\u9810\u7e73\u79df\u91d1",3,1952,"MO","1",1952,"2","2020-03-17 11:37:40","2","2020-03-17 11:37:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:37:40","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":["7748","RENT","\u9810\u7e73\u79df\u91d1",4,1952,"MO","1",1952,"2","2020-03-17 11:37:40","2","2020-03-17 11:37:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:37:40","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":["7748","RENT","\u9810\u7e73\u79df\u91d1",5,1952,"MO","1",1952,"2","2020-03-17 11:37:40","2","2020-03-17 11:37:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:37:40","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":["7748","RENT","\u9810\u7e73\u79df\u91d1",6,1952,"MO","1",1952,"2","2020-03-17 11:37:40","2","2020-03-17 11:37:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:37:40","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":["7748","RENT","\u9810\u7e73\u79df\u91d1",7,1952,"MO","1",1952,"2","2020-03-17 11:37:40","2","2020-03-17 11:37:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:37:40","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":["7748","RENT","\u9810\u7e73\u79df\u91d1",8,1952,"MO","1",1952,"2","2020-03-17 11:37:40","2","2020-03-17 11:37:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:37:40","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":["7748","RENT","\u9810\u7e73\u79df\u91d1",9,1952,"MO","1",1952,"2","2020-03-17 11:37:40","2","2020-03-17 11:37:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:37:40","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":["7748","RENT","\u9810\u7e73\u79df\u91d1",10,1952,"MO","1",1952,"2","2020-03-17 11:37:40","2","2020-03-17 11:37:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:37:40","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":["7748","RENT","\u9810\u7e73\u79df\u91d1",11,1952,"MO","1",1952,"2","2020-03-17 11:37:40","2","2020-03-17 11:37:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:37:40","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":["7748","RENT","\u9810\u7e73\u79df\u91d1",12,1952,"MO","1",1952,"2","2020-03-17 11:37:40","2","2020-03-17 11:37:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:37:40","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":["7748","RENT","\u9810\u7e73\u79df\u91d1",13,1952,"MO","1",1952,"2","2020-03-17 11:37:40","2","2020-03-17 11:37:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:37:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[23424,0,"7748"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-17 11:37:40","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":[1228,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207396","2020-03-17 11:37:40",23424,"2","2020-03-17 11:37:40","2","2020-03-17 11:37:40","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:37:40","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":["7396","DEPOSIT",null,"PAID","2020-03-17 11:37:40",0,"2","2020-03-17 11:37:40","2","2020-03-17 11:37:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:37:40","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":["7396","INVOICE","7748","PAID","2020-03-17 11:37:40",23424,"2","2020-03-17 11:37:40","2","2020-03-17 11:37:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:41:51","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=1146&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"732","master_room_id":"34","room_code":"O08"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":151,"customer_code":"C160151","identity_type":"PERSONAL","identity_id":"E673693(2)","title":"Ms","lastname":"Cheung","firstname":"Kei Lai","companyname":"","email":"anitaroma@gmail.com","tel":"90781361","address":"Flat 22A, Tower 16, Yee Tsui Court, South Horizons, Ap Lei Chau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1139.0","renew_rent_month":"6","renew_warehousing_date":"2020-02-18","renew_room_key":"055,33823","renew_remark":"6 months contract. Storage rental paid by bank transfer on September 7, 2019. Storage deposit transferred from agreement A12-CT194462 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195924, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[{"master_room_discount_id":"76","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1376.00","discount":"9.95","monthly_deduct":152.036,"room_id":"59","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"59","room_code":"B07","retail_price":"1528.0","discounted_price":1376,"location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1139,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6834,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-18","rent_from":"2020-02-18","rent_to":"2020-08-17","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on March 17, 2020. Storage deposit transferred from agreement A12-CT195924 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6834,"final_order_total":6834,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,33823","order_product":[],"pass":true}},"first_order_id":"4462","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> B07 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1139.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:41:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",151,"NEW","A12-CT207421",1528,1139,0,0,"6","6",6834,6834,6834,"2020-03-17 11:41:51","0",null,null,null,"2020-02-18","2020-08-17","6 months contract. Storage rental paid by bank transfer on March 17, 2020. Storage deposit transferred from agreement A12-CT195924 to this agreement.","2020-02-18","20",0,null,0,"0","2","2020-03-17 11:41:51","2","2020-03-17 11:41:51","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,33823","C160151","PERSONAL","Ms","qXqS8Q0aA91eIhCC1pmoNg==","vCxOlXQuvOQaoL822H2o\/Q==","","2hGyZ837IHRKHVwxQvhrtfVb5B55xRWceRFIcsRXcOVowBmmx8UoGYo9x+o7mTxTP5Ht1dWhmQahmnZ620+G3lnyizF2lKRDsTcQ9QMjyrA=","xygD0FfWL\/r5HJLQiS649Q==","hD32tMWVV61\/LbKkV3lyC5HhT71Ym0\/EerX73EtuJxI=","5VZhoOve+ehAyqoE\/dzeJg==",null,1,"4462"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:41:51","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":["7421","76","10","59","%","9.95",152.036,"2","2020-03-17 11:41:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:41:51","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":["7421","59","1528.0",1376,"2","2020-03-17 11:41:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:41:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-18","2020-08-17","59"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-17 11:41:51","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":["7421",151,"SETTLED","A12-I207749","2020-03-17 11:41:51","2020-02-18","2","2020-03-17 11:41:51","2","2020-03-17 11:41:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:41:51","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":["7749","RENT","\u9810\u7e73\u79df\u91d1",1,1139,"MO","1",1139,"2","2020-03-17 11:41:51","2","2020-03-17 11:41:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:41:51","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":["7749","RENT","\u9810\u7e73\u79df\u91d1",2,1139,"MO","1",1139,"2","2020-03-17 11:41:51","2","2020-03-17 11:41:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:41:51","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":["7749","RENT","\u9810\u7e73\u79df\u91d1",3,1139,"MO","1",1139,"2","2020-03-17 11:41:51","2","2020-03-17 11:41:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:41:51","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":["7749","RENT","\u9810\u7e73\u79df\u91d1",4,1139,"MO","1",1139,"2","2020-03-17 11:41:51","2","2020-03-17 11:41:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:41:51","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":["7749","RENT","\u9810\u7e73\u79df\u91d1",5,1139,"MO","1",1139,"2","2020-03-17 11:41:51","2","2020-03-17 11:41:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:41:51","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":["7749","RENT","\u9810\u7e73\u79df\u91d1",6,1139,"MO","1",1139,"2","2020-03-17 11:41:51","2","2020-03-17 11:41:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:41:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6834,0,"7749"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-17 11:41:51","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":[151,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207397","2020-03-17 11:41:51",6834,"2","2020-03-17 11:41:51","2","2020-03-17 11:41:51","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:41:51","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":["7397","DEPOSIT",null,"PAID","2020-03-17 11:41:51",0,"2","2020-03-17 11:41:51","2","2020-03-17 11:41:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:41:51","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":["7397","INVOICE","7749","PAID","2020-03-17 11:41:51",6834,"2","2020-03-17 11:41:51","2","2020-03-17 11:41:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:59:57","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"1337","master_room_id":"188","room_code":"C15-031"}],"index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1488,"customer_code":"C201488","identity_type":"PERSONAL","identity_id":"Z088839(8)","title":"Mr","lastname":"HO","firstname":"Ka Yu","companyname":"","email":"ofayyeung@gmail.com","tel":"66922831","address":"Flat %, 3\/F, Kong Fu Court, Aberdeen Centre, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"775.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-14","renew_room_key":"'0012415172","renew_remark":"1 month contract. Storage rental paid by EPS on February 12, 2020. Storage deposit $1550 transferred from agreement A05-CT206953 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT207167, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"108","order_discount":[{"master_room_discount_id":"230","master_room_id":"108","discount_type":"%","price":"1006.00","disocunted_price":"955.70","discount":"5.00","monthly_deduct":50.3,"room_id":"1063","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1063","room_code":"A05-061","retail_price":"1006.0","discounted_price":955.7,"location_id":"4"}],"roughly_size":"9","total_retail_price":1006,"total_discounted_price":737,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2211,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-14","rent_from":"2020-03-14","rent_to":"2020-06-13","delivery_service":"0","remark":"3 months contract. Storage rental paid by EPS on Mar 17,2020. Storage deposit $1550 transferred from agreement A05-CT207167 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":2211,"final_order_total":2211,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0012415172","order_product":[],"pass":true}},"first_order_id":"6953","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-061 <\/td>\r\n\t\t\t\t\t 3X3X7 <\/td>\r\n\t\t\t\t\t $1006.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"9","total_discounted_price":"737.00","deposit":"0.00","total_retail_price":"1006.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:59:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1488,"NEW","A05-CT207422",1006,737,0,0,"3","3",2211,2211,2211,"2020-03-17 11:59:57","0",null,null,null,"2020-03-14","2020-06-13","3 months contract. Storage rental paid by EPS on Mar 17,2020. Storage deposit $1550 transferred from agreement A05-CT207167 to this agreement. ","2020-03-14","9",0,null,0,"0","2","2020-03-17 11:59:57","2","2020-03-17 11:59:57","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"'0012415172","C201488","PERSONAL","Mr","f8XYjME4S7bFUqbGMta6lQ==","Zzv1eRCimQisUlUlw\/fpjg==","","G0DqRe7qjhKPGx\/xBTTOfkZj9PK2cXtWpGQaKEp9drmf1mJDIa4T67yQK6PXaGroPKe1kXil+G7i0kRQHfNH8Q==","JtEwh55Nke4GFrfYfJpr1Q==","AZDu+wknFwhYjI7GQSWpRWhCL1yTRGiLRIyDoNojrDM=","7QBn2SNCjVe7w65Aiokifg==",null,1,"6953"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:59:57","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":["7422","230","108","1063","%","5.00",50.3,"2","2020-03-17 11:59:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:59:57","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":["7422","1063","1006.0",955.7,"2","2020-03-17 11:59:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:59:57","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-03-14","2020-06-13","1063"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-17 11:59:57","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":["7422",1488,"SETTLED","A05-I207750","2020-03-17 11:59:57","2020-03-14","2","2020-03-17 11:59:57","2","2020-03-17 11:59:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:59:57","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":["7750","RENT","\u9810\u7e73\u79df\u91d1",1,737,"MO","1",737,"2","2020-03-17 11:59:57","2","2020-03-17 11:59:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:59:57","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":["7750","RENT","\u9810\u7e73\u79df\u91d1",2,737,"MO","1",737,"2","2020-03-17 11:59:57","2","2020-03-17 11:59:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:59:57","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":["7750","RENT","\u9810\u7e73\u79df\u91d1",3,737,"MO","1",737,"2","2020-03-17 11:59:57","2","2020-03-17 11:59:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:59:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2211,0,"7750"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-17 11:59:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1488,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P207398","2020-03-17 11:59:57",2211,"2","2020-03-17 11:59:57","2","2020-03-17 11:59:57","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:59:57","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":["7398","DEPOSIT",null,"PAID","2020-03-17 11:59:57",0,"2","2020-03-17 11:59:57","2","2020-03-17 11:59:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 11:59:57","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":["7398","INVOICE","7750","PAID","2020-03-17 11:59:57",2211,"2","2020-03-17 11:59:57","2","2020-03-17 11:59:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 13:55:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 14:17:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 14:48:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 14:49:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 15:19:23","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=571&filter3=undefined","floor_plan_rent_room":[{"room_id":"732","master_room_id":"34","room_code":"O08"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":574,"customer_code":"C170574","identity_type":"BUSINESS","identity_id":"67544417-000","title":"Ms","lastname":"Kwok","firstname":"Yuet Wah Albertina","companyname":"Boba Cafe 128","email":"tinaywk33@hotmail.com","tel":"66871716","address":"G\/F, Shop 1, 128 Ap Lei Chau Main Road, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-03","renew_room_key":"055,07586","renew_remark":"1 month contract. Storage rental paid by bank transfer on February 4, 2020. Storage deposit transferred from agreement A12-CT196691 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207122, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"144","room_code":"C20","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-03","rent_from":"2020-02-03","rent_to":"2020-03-02","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on March 17, 2020. Storage deposit transferred from agreement A12-CT207122 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,07586","order_product":[],"pass":true}},"first_order_id":"4722","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> C20 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 15:19:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",574,"NEW","A12-CT207423",1098,1038,0,0,"1","1",1038,1038,1038,"2020-03-17 15:19:23","0",null,null,null,"2020-02-03","2020-03-02","1 month contract. Storage rental paid by bank transfer on March 17, 2020. Storage deposit transferred from agreement A12-CT207122 to this agreement.\r\n","2020-02-03","16",0,null,0,"0","2","2020-03-17 15:19:23","2","2020-03-17 15:19:23","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,07586","C170574","BUSINESS","Ms","A+uRj8p7tDqEbQijhd95GjDFnFB7Op1AqPZ9q\/ChjGU=","+pNULpsInm3siHASV0hIrg==","Boba Cafe 128","Isk4kzOjkF6xeDXceSf25KVcGBgp\/FxQCSbLWl0WDEisZ9I5jVSpGA0hu4eHP+cqW9lXYIwIK1KYgWa8VI8QkA==","cqSYrPZcLGU6olheKS6TwQ==","HyiE2BUsNgIyg65jh\/6C9e6snrjutNDWNVbS\/MDm\/20=",null,"O33I8t0JzOwsECFDTsBzRw==",1,"4722"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 15:19:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7423","144","1098.0","1098.00","2","2020-03-17 15:19:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 15:19:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-03","2020-03-02","144"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-17 15:19:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7423",574,"SETTLED","A12-I207751","2020-03-17 15:19:23","2020-02-03","2","2020-03-17 15:19:23","2","2020-03-17 15:19:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 15:19:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7751","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-03-17 15:19:23","2","2020-03-17 15:19:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 15:19:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"7751"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-17 15:19:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[574,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207399","2020-03-17 15:19:23",1038,"2","2020-03-17 15:19:23","2","2020-03-17 15:19:23","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 15:19:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7399","DEPOSIT",null,"PAID","2020-03-17 15:19:23",0,"2","2020-03-17 15:19:23","2","2020-03-17 15:19:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 15:19:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7399","INVOICE","7751","PAID","2020-03-17 15:19:23",1038,"2","2020-03-17 15:19:23","2","2020-03-17 15:19:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 16:09:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 16:24:13","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=571&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"732","master_room_id":"34","room_code":"O08"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1433,"customer_code":"C191433","identity_type":"PERSONAL","identity_id":"K186942(6)","title":"Ms","lastname":"CHONG","firstname":"Hiu Sai Stephanie","companyname":"","email":"kaczorowski@netvigator.com","tel":"96159015","address":"Flat B, 18\/F, TWR 10, Larvotto, 8 Ap Lei Chau Praya Rd, Ap Lei Chau, HK.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4400.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-01","renew_room_key":"191,03185","renew_remark":"1 month contract. Special offer $4400\/mth. Storage rental paid by bank transfer on Feb 12,2020. Deposit $4400 transferred from A14-CT207027 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207168, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"579","room_code":"L57","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"578","room_code":"L56","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"577","room_code":"L55","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"589","room_code":"L67","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"588","room_code":"L66","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"587","room_code":"L65","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"96","total_retail_price":6588,"total_discounted_price":4400,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":4400,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-01","rent_from":"2020-02-01","rent_to":"2020-02-29","delivery_service":"0","remark":"1 month contract. Special offer $4400\/mth. Storage rental paid by bank transfer on March 17, 2020. Deposit $4400 transferred from A14-CT207168 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4400,"final_order_total":4400,"location_id":"2","branch_id":"1","company_id":"1","room_key":"191,03185","order_product":[],"pass":true}},"first_order_id":"6263","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \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> L57 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> L56 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> L55 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> L67 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> L66 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> L65 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"96","total_discounted_price":"4400.0","deposit":"0","total_retail_price":"6588.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 16:24:13","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",1433,"NEW","A14-CT207424",6588,4400,0,0,"1","1",4400,4400,4400,"2020-03-17 16:24:13","0",null,null,null,"2020-02-01","2020-02-29","1 month contract. Special offer $4400\/mth. Storage rental paid by bank transfer on March 17, 2020. Deposit $4400 transferred from A14-CT207168 to this agreement.","2020-02-01","96",0,null,0,"0","2","2020-03-17 16:24:12","2","2020-03-17 16:24:12","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"191,03185","C191433","PERSONAL","Ms","jvk7zrBnQZbXfX1dgEQlHe0RI1vs\/c8ofCzDIiHPduw=","sFvIMVuF8ZsYisXFtwlNOg==","","voDtSK9PGGTovDOARqXC4\/CqVs\/FW\/EFt+7Y8XgoNXnKX\/oYLjrZhZIszuJBDn5WLlxnxR+ombwIyw2An8MxBSJza\/jcybdtGn9ZStmQV6U=","WkO2u9lqQEjRnfUKLBy+6Q==","WfnjLYwTfgHTPaehcdhvGWTDmhNfxmwxxekvQ0TBxrg=","F4vjEMLSruInVObtV1LPJw==",null,1,"6263"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 16:24:13","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":["7424","579","1098.0","1098.00","2","2020-03-17 16:24:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 16:24:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2020-02-29","579"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-17 16:24:13","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":["7424","578","1098.0","1098.00","2","2020-03-17 16:24:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 16:24:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2020-02-29","578"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-17 16:24:13","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":["7424","577","1098.0","1098.00","2","2020-03-17 16:24:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 16:24:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2020-02-29","577"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-17 16:24:13","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":["7424","589","1098.0","1098.00","2","2020-03-17 16:24:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 16:24:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2020-02-29","589"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-17 16:24:13","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":["7424","588","1098.0","1098.00","2","2020-03-17 16:24:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 16:24:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2020-02-29","588"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-17 16:24:13","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":["7424","587","1098.0","1098.00","2","2020-03-17 16:24:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 16:24:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2020-02-29","587"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-17 16:24:13","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":["7424",1433,"SETTLED","A14-I207752","2020-03-17 16:24:12","2020-02-01","2","2020-03-17 16:24:12","2","2020-03-17 16:24:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 16:24:13","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":["7752","RENT","\u9810\u7e73\u79df\u91d1",1,4400,"MO","1",4400,"2","2020-03-17 16:24:12","2","2020-03-17 16:24:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 16:24:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4400,0,"7752"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-17 16:24:13","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":[1433,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207400","2020-03-17 16:24:12",4400,"2","2020-03-17 16:24:12","2","2020-03-17 16:24:12","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 16:24:13","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":["7400","DEPOSIT",null,"PAID","2020-03-17 16:24:12",0,"2","2020-03-17 16:24:12","2","2020-03-17 16:24:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 16:24:13","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":["7400","INVOICE","7752","PAID","2020-03-17 16:24:12",4400,"2","2020-03-17 16:24:12","2","2020-03-17 16:24:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 16:26:29","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=571&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"732","master_room_id":"34","room_code":"O08"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1433,"customer_code":"C191433","identity_type":"PERSONAL","identity_id":"K186942(6)","title":"Ms","lastname":"CHONG","firstname":"Hiu Sai Stephanie","companyname":"","email":"kaczorowski@netvigator.com","tel":"96159015","address":"Flat B, 18\/F, TWR 10, Larvotto, 8 Ap Lei Chau Praya Rd, Ap Lei Chau, HK.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3920.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-01","renew_room_key":"191,03185","renew_remark":"1 month contract. Special price $3920\/mth. Storage rental paid by bank transfer on Feb 12,2020. Deposit $3920 transferred from agreement A14-CT207028 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207169, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"683","room_code":"M94","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"682","room_code":"M93","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"681","room_code":"M92","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"672","room_code":"M83","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"671","room_code":"M82","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"670","room_code":"M81","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"72","total_retail_price":5988,"total_discounted_price":3920,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":3920,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-01","rent_from":"2020-02-01","rent_to":"2020-02-29","delivery_service":"0","remark":"1 month contract. Special price $3920\/mth. Storage rental paid by bank transfer on March 17, 2020. Deposit $3920 transferred from agreement A14-CT207169 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3920,"final_order_total":3920,"location_id":"2","branch_id":"1","company_id":"1","room_key":"191,03185","order_product":[],"pass":true}},"first_order_id":"6272","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \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> M94 <\/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> M93 <\/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> M92 <\/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> M83 <\/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> M82 <\/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> M81 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"72","total_discounted_price":"3920.0","deposit":"0","total_retail_price":"5988.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 16:26:29","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",1433,"NEW","A14-CT207425",5988,3920,0,0,"1","1",3920,3920,3920,"2020-03-17 16:26:29","0",null,null,null,"2020-02-01","2020-02-29","1 month contract. Special price $3920\/mth. Storage rental paid by bank transfer on March 17, 2020. Deposit $3920 transferred from agreement A14-CT207169 to this agreement.","2020-02-01","72",0,null,0,"0","2","2020-03-17 16:26:29","2","2020-03-17 16:26:29","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"191,03185","C191433","PERSONAL","Ms","jvk7zrBnQZbXfX1dgEQlHe0RI1vs\/c8ofCzDIiHPduw=","sFvIMVuF8ZsYisXFtwlNOg==","","voDtSK9PGGTovDOARqXC4\/CqVs\/FW\/EFt+7Y8XgoNXnKX\/oYLjrZhZIszuJBDn5WLlxnxR+ombwIyw2An8MxBSJza\/jcybdtGn9ZStmQV6U=","WkO2u9lqQEjRnfUKLBy+6Q==","WfnjLYwTfgHTPaehcdhvGWTDmhNfxmwxxekvQ0TBxrg=","F4vjEMLSruInVObtV1LPJw==",null,1,"6272"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 16:26:29","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":["7425","683","998.0","998.00","2","2020-03-17 16:26:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 16:26:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2020-02-29","683"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-17 16:26:29","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":["7425","682","998.0","998.00","2","2020-03-17 16:26:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 16:26:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2020-02-29","682"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-17 16:26:29","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":["7425","681","998.0","998.00","2","2020-03-17 16:26:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 16:26:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2020-02-29","681"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-17 16:26:29","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":["7425","672","998.0","998.00","2","2020-03-17 16:26:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 16:26:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2020-02-29","672"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-17 16:26:29","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":["7425","671","998.0","998.00","2","2020-03-17 16:26:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 16:26:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2020-02-29","671"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-17 16:26:29","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":["7425","670","998.0","998.00","2","2020-03-17 16:26:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 16:26:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2020-02-29","670"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-17 16:26:29","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":["7425",1433,"SETTLED","A14-I207753","2020-03-17 16:26:29","2020-02-01","2","2020-03-17 16:26:29","2","2020-03-17 16:26:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 16:26:29","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":["7753","RENT","\u9810\u7e73\u79df\u91d1",1,3920,"MO","1",3920,"2","2020-03-17 16:26:29","2","2020-03-17 16:26:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 16:26:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3920,0,"7753"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-17 16:26:29","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":[1433,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207401","2020-03-17 16:26:29",3920,"2","2020-03-17 16:26:29","2","2020-03-17 16:26:29","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 16:26:29","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":["7401","DEPOSIT",null,"PAID","2020-03-17 16:26:29",0,"2","2020-03-17 16:26:29","2","2020-03-17 16:26:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 16:26:29","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":["7401","INVOICE","7753","PAID","2020-03-17 16:26:29",3920,"2","2020-03-17 16:26:29","2","2020-03-17 16:26:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 17:31:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 17:31:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 17:56:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 18:23:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 18:24: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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1146,"customer_code":"C181146","identity_type":"PERSONAL","identity_id":"D103036(2)","title":"Ms","lastname":"Leung ","firstname":"Lai Yee","companyname":"","email":null,"tel":"93069953","address":"28\/C , Block 10 , Nam Fung Sun Cheun, Quarry Bay","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1798.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-11","renew_room_key":"0012403799","renew_remark":"1 month contract. Storage rental paid by cheque on Feb 27,2020. Deposit transferred from agreement C15-CT194293 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT207271, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"170","order_discount":[],"order_room":[{"room_id":"1354","room_code":"C15-048","retail_price":"1108.0","discounted_price":"1108.00","location_id":"6"},{"room_id":"1353","room_code":"C15-047","retail_price":"1108.0","discounted_price":"1108.00","location_id":"6"}],"roughly_size":"32","total_retail_price":2216,"total_discounted_price":1798,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1798,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-11","rent_from":"2020-03-11","rent_to":"2020-04-10","delivery_service":"0","remark":"1 month contract. Storage rental paid by cheque on Mar 17,2020. Deposit transferred from agreement C15-CT207271 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":1798,"final_order_total":1798,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012403799","order_product":[],"pass":true}},"first_order_id":"4293","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-048 <\/td>\r\n\t\t\t\t\t 4X4X6.5 <\/td>\r\n\t\t\t\t\t $1108.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> C15-047 <\/td>\r\n\t\t\t\t\t 4X4X6.5 <\/td>\r\n\t\t\t\t\t $1108.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"1798.0","deposit":"0","total_retail_price":"2216.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 18:24:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1146,"NEW","C15-CT207426",2216,1798,0,0,"1","1",1798,1798,1798,"2020-03-17 18:24:23","0",null,null,null,"2020-03-11","2020-04-10","1 month contract. Storage rental paid by cheque on Mar 17,2020. Deposit transferred from agreement C15-CT207271 to this agreement.","2020-03-11","32",0,null,0,"0","2","2020-03-17 18:24:22","2","2020-03-17 18:24:22","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"0012403799","C181146","PERSONAL","Ms","gjSpyhqyAa7WiwccZ+QVeQ==","EU9enA5\/vY58OMUDrd7sSw==","","dX+zJ458tDKiugVFVeBzNhNApFHtw42VR0\/lPFKhmiYTCTEHyOZIjDuovvRjZrW6gZiRuj2LsbRWS9nBvW\/ZuQ==","iaEkitfo+RiWiRQ1VJ1bPg==",null,"S1RRDrlG6v7bZDT0Ztugpw==",null,1,"4293"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 18:24:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7426","1354","1108.0","1108.00","2","2020-03-17 18:24:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 18:24:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-11","2020-04-10","1354"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-17 18:24:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7426","1353","1108.0","1108.00","2","2020-03-17 18:24:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 18:24:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-11","2020-04-10","1353"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-17 18:24:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7426",1146,"SETTLED","C15-I207754","2020-03-17 18:24:22","2020-03-11","2","2020-03-17 18:24:22","2","2020-03-17 18:24:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 18:24:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7754","RENT","\u9810\u7e73\u79df\u91d1",1,1798,"MO","1",1798,"2","2020-03-17 18:24:22","2","2020-03-17 18:24:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 18:24:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1798,0,"7754"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-17 18:24:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1146,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207402","2020-03-17 18:24:22",1798,"2","2020-03-17 18:24:22","2","2020-03-17 18:24:22","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 18:24:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7402","DEPOSIT",null,"PAID","2020-03-17 18:24:22",0,"2","2020-03-17 18:24:22","2","2020-03-17 18:24:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-17 18:24:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7402","INVOICE","7754","PAID","2020-03-17 18:24:22",1798,"2","2020-03-17 18:24:22","2","2020-03-17 18:24:22"]},"data_before":[],"data_after":[],"step":1} *****