{"created_at":"2020-02-03 11:44:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:46:11","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":28,"customer_code":"C150028","identity_type":"PERSONAL","identity_id":"Y095353(7)","title":"Mr","lastname":"To ","firstname":"Wai Lun","companyname":"","email":"cola73177@gmail.com","tel":"68288688","address":"Flat 1 5\/F Block B,138 Lee Chi 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":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-06","renew_room_key":"055,09203","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 16, 2020. Storage deposit transferred from agreement A12-CT196654 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT206975, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"28","room_code":"A28","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-06","rent_from":"2020-02-06","rent_to":"2020-03-05","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on February 3, 2020. Storage deposit transferred from agreement A12-CT206975 to this agreement.\r\n\r\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT206975, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","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,09203","order_product":[],"pass":true}},"first_order_id":"4760","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>
A28 <\/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-02-03 11:46:11","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",28,"NEW","A12-CT207088",1098,1038,0,0,"1","1",1038,1038,1038,"2020-02-03 11:46:11","0",null,null,null,"2020-02-06","2020-03-05","1 month contract. Storage rental paid by bank transfer on February 3, 2020. Storage deposit transferred from agreement A12-CT206975 to this agreement.\r\n\r\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT206975, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","2020-02-06","16",0,null,0,"0","2","2020-02-03 11:46:11","2","2020-02-03 11:46:11","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,09203","C150028","PERSONAL","Mr","AAE9jdBh7PgsPRXGZOiUIg==","tAIAlFp2vgOGNFu\/xZc8JQ==","","13wMvUOHAYIQOl9QhDAfTbyaRJriUovwBZqC8mfSvX+GXQQxT+ZW3C\/kwUoFMflqDYYBAaV1Xkxn8PK38jLKDQ==","W9K8+8Yyeyys53D1i65fQg==","ewBy12ViY22Kmqy99fNazffSQtOA35qmZqobYk5kHUg=","o3fK6M6cHbhLBnqA0xTjOQ==",null,1,"4760"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:46:11","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":["7088","28","1098.0","1098.00","2","2020-02-03 11:46:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:46:11","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-06","2020-03-05","28"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-03 11:46:11","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":["7088",28,"SETTLED","A12-I207416","2020-02-03 11:46:11","2020-02-06","2","2020-02-03 11:46:11","2","2020-02-03 11:46:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:46:11","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":["7416","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-02-03 11:46:11","2","2020-02-03 11:46:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:46:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"7416"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-03 11:46:11","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":[28,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207064","2020-02-03 11:46:11",1038,"2","2020-02-03 11:46:11","2","2020-02-03 11:46:11","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:46:11","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":["7064","DEPOSIT",null,"PAID","2020-02-03 11:46:11",0,"2","2020-02-03 11:46:11","2","2020-02-03 11:46:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:46:11","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":["7064","INVOICE","7416","PAID","2020-02-03 11:46:11",1038,"2","2020-02-03 11:46:11","2","2020-02-03 11:46:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:47:56","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":441,"customer_code":"C170441","identity_type":"PERSONAL","identity_id":"K187210(9)","title":"Mr","lastname":"Leung","firstname":"Kwong Chi","companyname":"","email":"kckelvin@gmail.com","tel":"94625268","address":"Flat 3113,Pik Yuet House,Shek Pai Wan Estate","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1286.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-17","renew_room_key":"053,48941","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 31, 2019. Storage deposit transferred from agreement A12-CT196656 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196815, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"101","room_code":"B49","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1286,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1286,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-17","rent_from":"2020-02-17","rent_to":"2020-03-16","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on February 3, 2020. Storage deposit transferred from agreement A12-CT196815 to this agreement.\r\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196815, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1286,"final_order_total":1286,"location_id":"1","branch_id":"1","company_id":"1","room_key":"053,48941","order_product":[],"pass":true}},"first_order_id":"4848","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> B49 <\/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":"1286.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:47:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",441,"NEW","A12-CT207089",1528,1286,0,0,"1","1",1286,1286,1286,"2020-02-03 11:47:56","0",null,null,null,"2020-02-17","2020-03-16","1 month contract. Storage rental paid by bank transfer on February 3, 2020. Storage deposit transferred from agreement A12-CT196815 to this agreement.\r\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196815, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","2020-02-17","20",0,null,0,"0","2","2020-02-03 11:47:56","2","2020-02-03 11:47:56","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"053,48941","C170441","PERSONAL","Mr","+dEjQsGfUIM77pS0ke1UNg==","xEf2h2aoyRQ71ZVgBH+9WQ==","","WXAxv4MtPIFgHWZXkMsPE5BEGcBZNXBFpYp6GbukVe41gB3Im3As7f4Wn1yvLqKB","3XEnDPIYj\/Bc8Nw\/mL4YlA==","HqPua0wMa9D6F9q3F52tnLhm3HWWBu1s1N0CWtgara4=","n8KZV65hrsIsZlgzHveC2A==",null,1,"4848"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:47:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7089","101","1528.0","1528.00","2","2020-02-03 11:47:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:47:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-17","2020-03-16","101"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-03 11:47:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7089",441,"SETTLED","A12-I207417","2020-02-03 11:47:56","2020-02-17","2","2020-02-03 11:47:56","2","2020-02-03 11:47:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:47:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7417","RENT","\u9810\u7e73\u79df\u91d1",1,1286,"MO","1",1286,"2","2020-02-03 11:47:56","2","2020-02-03 11:47:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:47:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1286,0,"7417"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-03 11:47:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[441,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207065","2020-02-03 11:47:56",1286,"2","2020-02-03 11:47:56","2","2020-02-03 11:47:56","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:47:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7065","DEPOSIT",null,"PAID","2020-02-03 11:47:56",0,"2","2020-02-03 11:47:56","2","2020-02-03 11:47:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:47:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7065","INVOICE","7417","PAID","2020-02-03 11:47:56",1286,"2","2020-02-03 11:47:56","2","2020-02-03 11:47:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:49:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:49:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:52:45","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1320,"customer_code":"C191320","identity_type":"PERSONAL","identity_id":"Z071705(4)","title":"Ms","lastname":"Tsui","firstname":"Wai Ting","companyname":"","email":"lilian_tsui2003@hotmail.com","tel":"96651398","address":"Flat 1, 20\/F, Block B, Yue Fai Court, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-04","renew_room_key":"076,47738","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 2, 2020. Storage deposit $1196 transferred from agreement A14-CT196580 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT206835, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"629","room_code":"M40","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-04","rent_from":"2020-02-04","rent_to":"2020-03-03","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on February 3, 2020. Storage deposit transferred from agreement A14-CT206835 to this agreement.\r\n\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,47738","order_product":[],"pass":true}},"first_order_id":"5394","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> M40 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:52:45","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",1320,"NEW","A14-CT207090",598,598,0,0,"1","1",598,598,598,"2020-02-03 11:52:45","0",null,null,null,"2020-02-04","2020-03-03","1 month contract. Storage rental paid by bank transfer on February 3, 2020. Storage deposit transferred from agreement A14-CT206835 to this agreement.\r\n\r\n","2020-02-04","12",0,null,0,"0","2","2020-02-03 11:52:45","2","2020-02-03 11:52:45","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,47738","C191320","PERSONAL","Ms","JgAavgpIkIT+QrZDjc3BRA==","iFBOFA5ozF+SaoxW1fJyqg==","","nS2AiTTeQuxhPG679Pwsq8kB6U8sV32RDbPuHYq7+uZFSa7VZrGSkrkHoVfookObAopb4zx1arlGt2IOtgLjog==","zL50AC1II2U4KbzngrxU9w==","LPBlaIsAU5KUY5TZ0ddhbjaTC47xq2aEL17KEpHG6hM=","EknxojvrXMxgxEofwXXtVQ==",null,1,"5394"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:52:45","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":["7090","629","598.0","598.00","2","2020-02-03 11:52:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:52:45","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-04","2020-03-03","629"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-03 11:52:45","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":["7090",1320,"SETTLED","A14-I207418","2020-02-03 11:52:45","2020-02-04","2","2020-02-03 11:52:45","2","2020-02-03 11:52:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:52:45","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":["7418","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-02-03 11:52:45","2","2020-02-03 11:52:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:52:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7418"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-03 11:52:45","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":[1320,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207066","2020-02-03 11:52:45",598,"2","2020-02-03 11:52:45","2","2020-02-03 11:52:45","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:52:45","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":["7066","DEPOSIT",null,"PAID","2020-02-03 11:52:45",0,"2","2020-02-03 11:52:45","2","2020-02-03 11:52:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:52:45","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":["7066","INVOICE","7418","PAID","2020-02-03 11:52:45",598,"2","2020-02-03 11:52:45","2","2020-02-03 11:52:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:56:41","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":758,"customer_code":"C180758","identity_type":"PERSONAL","identity_id":"E846315(1)","title":"Ms","lastname":"Chan","firstname":"Chui Yi Eunice","companyname":"","email":"cyechan192@gmail.com","tel":"91242807","address":"3G, 20 Chi Fu Road, Pok Fu Lam, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1162.0","renew_rent_month":"12","renew_warehousing_date":"2020-02-11","renew_room_key":"190,37032","renew_remark":"12 months contract. Storage rental paid by cheque deposit on January 30, 2019. Storage deposit transferred from agreement A18-CT182784 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT194306, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"991","room_code":"X16","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":13944,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1162.00","warehousing_date":"2020-02-11","rent_from":"2020-02-11","rent_to":"2021-03-10","delivery_service":"0","remark":"13 months contract. 1 month free. Storage rental paid by bank transfer on February 3, 2020. Storage deposit transferred from agreement A18-CT194306 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":1162,"order_total":15106,"final_order_total":13944,"location_id":"3","branch_id":"1","company_id":"1","room_key":"190,37032","order_product":[],"pass":true}},"first_order_id":4306,"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> X16 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1162.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:56:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",758,"NEW","A18-CT207091",1290,1162,0,0,"13","13",13944,15106,13944,"2020-02-03 11:56:42","0",null,null,null,"2020-02-11","2021-03-10","13 months contract. 1 month free. Storage rental paid by bank transfer on February 3, 2020. Storage deposit transferred from agreement A18-CT194306 to this agreement.\r\n","2020-02-11","16",0,null,1162,"1162.00","2","2020-02-03 11:56:41","2","2020-02-03 11:56:41","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190,37032","C180758","PERSONAL","Ms","rH7Gqg9DysMEIpskwAs4Lg==","U9yoE9KqV1v8YlRkf7Q2yg==","","jKFkxL2YIZhrZ2aBwIj2qeujjEDGGtnHn9u1KUSDD1K5tqZSbv5qH3HYnkJNk6Ka","LJn7ksxp3BpBQ9Rhe4f5\/A==","GMZM1IRXu9tWtDA9EgqfMhDCVNzYTAcFQYfs1NHhvv8=","dI0JuwWtctWR9xd7LOjcGw==",null,1,4306]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:56:42","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":["7091","991","1290.0","1290.00","2","2020-02-03 11:56:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:56:42","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-11","2021-03-10","991"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-03 11:56:42","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":["7091",758,"SETTLED","A18-I207419","2020-02-03 11:56:41","2020-02-11","2","2020-02-03 11:56:41","2","2020-02-03 11:56:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:56:42","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":["7419","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1162,"MO","1",1162,"2","2020-02-03 11:56:41","2","2020-02-03 11:56:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:56:42","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":["7419","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-02-03 11:56:41","2","2020-02-03 11:56:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:56:42","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":["7419","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-02-03 11:56:41","2","2020-02-03 11:56:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:56:42","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":["7419","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-02-03 11:56:41","2","2020-02-03 11:56:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:56:42","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":["7419","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-02-03 11:56:41","2","2020-02-03 11:56:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:56:42","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":["7419","RENT","\u9810\u7e73\u79df\u91d1",7,1162,"MO","1",1162,"2","2020-02-03 11:56:41","2","2020-02-03 11:56:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:56:42","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":["7419","RENT","\u9810\u7e73\u79df\u91d1",8,1162,"MO","1",1162,"2","2020-02-03 11:56:41","2","2020-02-03 11:56:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:56:42","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":["7419","RENT","\u9810\u7e73\u79df\u91d1",9,1162,"MO","1",1162,"2","2020-02-03 11:56:41","2","2020-02-03 11:56:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:56:42","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":["7419","RENT","\u9810\u7e73\u79df\u91d1",10,1162,"MO","1",1162,"2","2020-02-03 11:56:41","2","2020-02-03 11:56:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:56:42","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":["7419","RENT","\u9810\u7e73\u79df\u91d1",11,1162,"MO","1",1162,"2","2020-02-03 11:56:41","2","2020-02-03 11:56:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:56:42","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":["7419","RENT","\u9810\u7e73\u79df\u91d1",12,1162,"MO","1",1162,"2","2020-02-03 11:56:41","2","2020-02-03 11:56:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:56:42","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":["7419","RENT","\u9810\u7e73\u79df\u91d1",13,1162,"MO","1",1162,"2","2020-02-03 11:56:41","2","2020-02-03 11:56:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:56:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13944,0,"7419"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-03 11:56:42","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":[758,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207067","2020-02-03 11:56:41",13944,"2","2020-02-03 11:56:41","2","2020-02-03 11:56:41","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:56:42","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":["7067","DEPOSIT",null,"PAID","2020-02-03 11:56:41",0,"2","2020-02-03 11:56:41","2","2020-02-03 11:56:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:56:42","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":["7067","INVOICE","7419","PAID","2020-02-03 11:56:41",13944,"2","2020-02-03 11:56:41","2","2020-02-03 11:56:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:58:53","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":724,"customer_code":"C180724","identity_type":"PERSONAL","identity_id":"D488390(0)","title":"Mr","lastname":"Chan","firstname":"Kai Ming Johnny","companyname":"","email":"ckmjohnny@gmail.com","tel":"92855920","address":"Room 922, Wah Cheong House, Wah Fu Estate, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2058.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-05","renew_room_key":"054,32853","renew_remark":"1 month contract. Storage rental paid by PPS on January 3. Storage deposit transferred from agreement A12-CT196635 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT206862, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"321","room_code":"F06","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"332","room_code":"F17","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"28","total_retail_price":2096,"total_discounted_price":2058,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2058,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-05","rent_from":"2020-02-05","rent_to":"2020-03-04","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on February 3, 2020. Storage deposit transferred from agreement A12-CT206862 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":2058,"final_order_total":2058,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,32853","order_product":[],"pass":true}},"first_order_id":"4888","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> F06 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> F17 <\/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":"28","total_discounted_price":"2058.0","deposit":"0","total_retail_price":"2096.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:58:53","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",724,"NEW","A12-CT207092",2096,2058,0,0,"1","1",2058,2058,2058,"2020-02-03 11:58:53","0",null,null,null,"2020-02-05","2020-03-04","1 month contract. Storage rental paid by PPS on February 3, 2020. Storage deposit transferred from agreement A12-CT206862 to this agreement.\r\n","2020-02-05","28",0,null,0,"0","2","2020-02-03 11:58:53","2","2020-02-03 11:58:53","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,32853","C180724","PERSONAL","Mr","S2Y\/+hrua6snugCiRVXC+g==","U9yoE9KqV1v8YlRkf7Q2yg==","","k+e0QYxm9l5HuoQuXakgBNnw8UW4n+ZLcCG9eEWYCG3GGUVs8OcyHqJxZXBRIAQ7e4G25Jwv46TjFMKIeqmD6Q==","uIJTfVK37Ukw\/PebwnT1DA==","HVGIbYlde5F3OKyLRPpR9QsuoR+xNkr5wlpbBQugV6E=","tHG2eMtIkTmRjccZ2JJ3PQ==",null,1,"4888"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:58:53","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":["7092","321","998.0","998.00","2","2020-02-03 11:58:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:58:53","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-05","2020-03-04","321"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-03 11:58:53","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":["7092","332","1098.0","1098.00","2","2020-02-03 11:58:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:58:53","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-05","2020-03-04","332"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-03 11:58:53","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":["7092",724,"SETTLED","A12-I207420","2020-02-03 11:58:53","2020-02-05","2","2020-02-03 11:58:53","2","2020-02-03 11:58:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:58:53","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":["7420","RENT","\u9810\u7e73\u79df\u91d1",1,2058,"MO","1",2058,"2","2020-02-03 11:58:53","2","2020-02-03 11:58:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:58:53","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2058,0,"7420"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-03 11:58:53","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":[724,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207068","2020-02-03 11:58:53",2058,"2","2020-02-03 11:58:53","2","2020-02-03 11:58:53","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:58:53","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":["7068","DEPOSIT",null,"PAID","2020-02-03 11:58:53",0,"2","2020-02-03 11:58:53","2","2020-02-03 11:58:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 11:58:53","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":["7068","INVOICE","7420","PAID","2020-02-03 11:58:53",2058,"2","2020-02-03 11:58:53","2","2020-02-03 11:58:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 12:00: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":"&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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":373,"customer_code":"C170373","identity_type":"PERSONAL","identity_id":"A810524(6)","title":"Ms","lastname":"Tang","firstname":"Wai Fong","companyname":"","email":"tang222888@hotmail.com","tel":"92668877","address":"Flat A,13\/F,Kaning Mansion,Aberdeen,Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3784.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-20","renew_room_key":"055,46666","renew_remark":"1 month contract. Storage rental paid by PPS on January 13, 2020. Storage deposit transferred from agreement A12-CT196536 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT206961, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"409","room_code":"H19","retail_price":"1938.0","discounted_price":"1938.00","location_id":"1"},{"room_id":"86","room_code":"B34","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"62.5","total_retail_price":3466,"total_discounted_price":3784,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":3784,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-20","rent_from":"2020-01-20","rent_to":"2020-02-19","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on February 3, 2020. Storage deposit transferred from agreement A12-CT206961 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":3784,"final_order_total":3784,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,46666","order_product":[],"pass":true}},"first_order_id":"4881","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> H19 <\/td>\r\n\t\t\t\t\t 5X8.5X8 <\/td>\r\n\t\t\t\t\t $1938.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> B34 <\/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":"62.5","total_discounted_price":"3784.0","deposit":"0","total_retail_price":"3466.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 12:00: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","1",373,"NEW","A12-CT207093",3466,3784,0,0,"1","1",3784,3784,3784,"2020-02-03 12:00:55","0",null,null,null,"2020-01-20","2020-02-19","1 month contract. Storage rental paid by PPS on February 3, 2020. Storage deposit transferred from agreement A12-CT206961 to this agreement.\r\n","2020-01-20","62.5",0,null,0,"0","2","2020-02-03 12:00:54","2","2020-02-03 12:00:54","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,46666","C170373","PERSONAL","Ms","nTGfHLdEIudAzJAvttiE\/g==","M7CfcmE2OSMlZOkNgaoDmQ==","","BXgfEt9fXMpUNvxC+2X229VwwYS6rNmHtxMS+n23vDnbhk3n3xs6q6u0V\/EvTko5","HCKjEGhRJ8yb3ZyyPfmQag==","jQ4ob3N7+u9PyWPiMEH+PWHdZ55bC9BctdRu99koSsw=","QQr8JjuTNOLQNSu7eSLB1g==",null,1,"4881"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 12:00: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":["7093","409","1938.0","1938.00","2","2020-02-03 12:00:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 12:00: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-01-20","2020-02-19","409"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-03 12:00: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":["7093","86","1528.0","1528.00","2","2020-02-03 12:00:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 12:00: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-01-20","2020-02-19","86"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-03 12:00: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":["7093",373,"SETTLED","A12-I207421","2020-02-03 12:00:54","2020-01-20","2","2020-02-03 12:00:54","2","2020-02-03 12:00:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 12:00: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":["7421","RENT","\u9810\u7e73\u79df\u91d1",1,3784,"MO","1",3784,"2","2020-02-03 12:00:54","2","2020-02-03 12:00:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 12:00:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3784,0,"7421"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-03 12:00: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":[373,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207069","2020-02-03 12:00:54",3784,"2","2020-02-03 12:00:54","2","2020-02-03 12:00:54","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 12:00: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":["7069","DEPOSIT",null,"PAID","2020-02-03 12:00:54",0,"2","2020-02-03 12:00:54","2","2020-02-03 12:00:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 12:00: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":["7069","INVOICE","7421","PAID","2020-02-03 12:00:54",3784,"2","2020-02-03 12:00:54","2","2020-02-03 12:00:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 12:02:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 12:45:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 14:22:30","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"type=INVOICE&filter1=0&filter2=924&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1223,"customer_code":"C191223","identity_type":"BUSINESS","identity_id":"K911888(8)","title":"Mr","lastname":"CHAN","firstname":"Fai Ming","companyname":"Imperial Solutions HK Limited","email":null,"tel":"61319870","address":"Rm 1406, 14\/F The Broadway, 54-62 Lockhart Road, Wanchai Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"459.0","renew_rent_month":"12","renew_warehousing_date":"2020-03-14","renew_room_key":"'0005832681","renew_remark":"12 months contact. Special offer 2 months off. Storage rental and deposit paid by EPS on March 14, 2019. Smartcard provided on March 14, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT194582, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $510.0","renew_master_room_id":"158","order_discount":[],"order_room":[{"room_id":"1447","room_code":"C15-141","retail_price":"510.0","discounted_price":"510.00","location_id":"6"}],"roughly_size":"8.1","total_retail_price":510,"total_discounted_price":459,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":5508,"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":"2021-03-13","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on Feb 03,2020. Deposit $510 transferred from agreement C15-CT194582 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5508,"final_order_total":5508,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0005832681","order_product":[],"pass":true}},"first_order_id":4582,"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-141 <\/td>\r\n\t\t\t\t\t 3X2.7X3 <\/td>\r\n\t\t\t\t\t $510.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":"8.1","total_discounted_price":"459.0","deposit":"0","total_retail_price":"510.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 14:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1223,"NEW","C15-CT207094",510,459,0,0,"12","12",5508,5508,5508,"2020-02-03 14:22:30","0",null,null,null,"2020-03-14","2021-03-13","12 months contract. Storage rental paid by bank transfer on Feb 03,2020. Deposit $510 transferred from agreement C15-CT194582 to this agreement.","2020-03-14","8.1",0,null,0,"0","2","2020-02-03 14:22:30","2","2020-02-03 14:22:30","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0005832681","C191223","BUSINESS","Mr","AlAZHEQsmCj2hZWfWjcQQQ==","8BEgNhGpCR8jGkzUtrIcXg==","Imperial Solutions HK Limited","5Rq2oY9hFDcYUnvrwrUQd8UKFo2jOGJq\/z3RwC8cyxC402nq3mK0nlyHD1yxVFX8pQEKWfmM3+SV+PLx1qFTCSbN6qSL69Hs12FbHkYzAuE=","EPc8yj7rkdKIDpWIPFBOQg==",null,null,"5HHm6pnRmRvjiEbHOEBSUw==",1,4582]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 14:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7094","1447","510.0","510.00","2","2020-02-03 14:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 14:22:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-14","2021-03-13","1447"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-03 14:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7094",1223,"SETTLED","C15-I207422","2020-02-03 14:22:30","2020-03-14","2","2020-02-03 14:22:30","2","2020-02-03 14:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 14:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7422","RENT","\u9810\u7e73\u79df\u91d1",1,459,"MO","1",459,"2","2020-02-03 14:22:30","2","2020-02-03 14:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 14:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7422","RENT","\u9810\u7e73\u79df\u91d1",2,459,"MO","1",459,"2","2020-02-03 14:22:30","2","2020-02-03 14:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 14:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7422","RENT","\u9810\u7e73\u79df\u91d1",3,459,"MO","1",459,"2","2020-02-03 14:22:30","2","2020-02-03 14:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 14:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7422","RENT","\u9810\u7e73\u79df\u91d1",4,459,"MO","1",459,"2","2020-02-03 14:22:30","2","2020-02-03 14:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 14:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7422","RENT","\u9810\u7e73\u79df\u91d1",5,459,"MO","1",459,"2","2020-02-03 14:22:30","2","2020-02-03 14:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 14:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7422","RENT","\u9810\u7e73\u79df\u91d1",6,459,"MO","1",459,"2","2020-02-03 14:22:30","2","2020-02-03 14:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 14:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7422","RENT","\u9810\u7e73\u79df\u91d1",7,459,"MO","1",459,"2","2020-02-03 14:22:30","2","2020-02-03 14:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 14:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7422","RENT","\u9810\u7e73\u79df\u91d1",8,459,"MO","1",459,"2","2020-02-03 14:22:30","2","2020-02-03 14:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 14:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7422","RENT","\u9810\u7e73\u79df\u91d1",9,459,"MO","1",459,"2","2020-02-03 14:22:30","2","2020-02-03 14:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 14:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7422","RENT","\u9810\u7e73\u79df\u91d1",10,459,"MO","1",459,"2","2020-02-03 14:22:30","2","2020-02-03 14:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 14:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7422","RENT","\u9810\u7e73\u79df\u91d1",11,459,"MO","1",459,"2","2020-02-03 14:22:30","2","2020-02-03 14:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 14:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7422","RENT","\u9810\u7e73\u79df\u91d1",12,459,"MO","1",459,"2","2020-02-03 14:22:30","2","2020-02-03 14:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 14:22:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5508,0,"7422"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-03 14:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1223,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207070","2020-02-03 14:22:30",5508,"2","2020-02-03 14:22:30","2","2020-02-03 14:22:30","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 14:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7070","DEPOSIT",null,"PAID","2020-02-03 14:22:30",0,"2","2020-02-03 14:22:30","2","2020-02-03 14:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 14:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7070","INVOICE","7422","PAID","2020-02-03 14:22:30",5508,"2","2020-02-03 14:22:30","2","2020-02-03 14:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 15:07:14","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"type=INVOICE&filter1=0&filter2=924&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1358,"customer_code":"C191358","identity_type":"PERSONAL","identity_id":"D545463(9)","title":"Mr","lastname":"FUNG","firstname":"San Wa","companyname":"","email":null,"tel":"67688797","address":"Room D, 39\/F, Block 4, Boardview Court, 11 Sham Wan Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"773.0","renew_rent_month":"2","renew_warehousing_date":"2020-02-02","renew_room_key":"0012491558","renew_remark":"2 months contract. Change unit from C15-137 to C15-008. Deposit $530 transferred from agreement C15-CT196515 to this agreement. Remaining storage rental and deposit paid by bank transfer on Jan 02,2020. Smartcard provided on Jan 02,2020.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT206831, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $773.0","renew_master_room_id":"164","order_discount":[],"order_room":[{"room_id":"1314","room_code":"C15-008","retail_price":"773.0","discounted_price":"773.00","location_id":"6"}],"roughly_size":"10","total_retail_price":773,"total_discounted_price":773,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":773,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-02","rent_from":"2020-02-02","rent_to":"2020-03-01","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Feb 03,2020. Deposit $773 transferred from agreement C15-CT206831 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":773,"final_order_total":773,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012491558","order_product":[],"pass":true}},"first_order_id":6831,"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-008 <\/td>\r\n\t\t\t\t\t 4X2.5X6.5 <\/td>\r\n\t\t\t\t\t $773.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":"10","total_discounted_price":"773.00","deposit":"0.00","total_retail_price":"773.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 15:07:14","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",1358,"NEW","C15-CT207095",773,773,0,0,"1","1",773,773,773,"2020-02-03 15:07:14","0",null,null,null,"2020-02-02","2020-03-01","1 month contract. Storage rental paid by bank transfer on Feb 03,2020. Deposit $773 transferred from agreement C15-CT206831 to this agreement.","2020-02-02","10",0,null,0,"0","2","2020-02-03 15:07:14","2","2020-02-03 15:07:14","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012491558","C191358","PERSONAL","Mr","WlalgTrrPcjA8Gp112S\/Kg==","cyZbjLKMtXmsqxQPpU0UpA==","","fe9iCk1tQ1lAm3PjbJ6V+OcyRyIUyWQKGswsQvEp2AW4XMR2lHSRsQlP8RHp1WU2o5SV8smkoy3jxlR42qpFlCAZwCkDgtdv0NJkZDJeMD0=","Fu4byQTCTJLHh9jc8AHLPw==",null,"CX+Y57S\/WdhXAqCDsjxY3Q==",null,1,6831]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 15:07:14","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":["7095","1314","773.0","773.00","2","2020-02-03 15:07:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 15:07:14","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-02","2020-03-01","1314"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-03 15:07:14","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":["7095",1358,"SETTLED","C15-I207423","2020-02-03 15:07:14","2020-02-02","2","2020-02-03 15:07:14","2","2020-02-03 15:07:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 15:07:14","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":["7423","RENT","\u9810\u7e73\u79df\u91d1",1,773,"MO","1",773,"2","2020-02-03 15:07:14","2","2020-02-03 15:07:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 15:07:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[773,0,"7423"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-03 15:07:14","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":[1358,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207071","2020-02-03 15:07:14",773,"2","2020-02-03 15:07:14","2","2020-02-03 15:07:14","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 15:07:14","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":["7071","DEPOSIT",null,"PAID","2020-02-03 15:07:14",0,"2","2020-02-03 15:07:14","2","2020-02-03 15:07:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 15:07:14","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":["7071","INVOICE","7423","PAID","2020-02-03 15:07:14",773,"2","2020-02-03 15:07:14","2","2020-02-03 15:07:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 15:09:18","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"type=INVOICE&filter1=0&filter2=924&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1185,"customer_code":"C191185","identity_type":"PERSONAL","identity_id":"D522909(0)","title":"Mr","lastname":"Lui","firstname":"Cheuk Ho","companyname":"","email":null,"tel":"60381903","address":"Flat\/Rm B, Mei Lun House, 2~4 Mei Lun Street, Central, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1322.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-01","renew_room_key":"0012516868","renew_remark":"1 month contract. Storage rental paid by bank transfer on Jan 06,2020. Storage deposit $1322 transferred from agreement C15-CT196614 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT206883, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"173","order_discount":[],"order_room":[{"room_id":"1421","room_code":"C15-115","retail_price":"1322.0","discounted_price":"1322.00","location_id":"6"}],"roughly_size":"24","total_retail_price":1322,"total_discounted_price":1322,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1322,"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. Storage rental paid by bank transfer on Feb 01,2020. Storage deposit $1322 transferred from agreement C15-CT206883 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1322,"final_order_total":1322,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012516868","order_product":[],"pass":true}},"first_order_id":"4243","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-115 <\/td>\r\n\t\t\t\t\t 4X6X6.5 <\/td>\r\n\t\t\t\t\t $1322.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":"24","total_discounted_price":"1322.0","deposit":"0","total_retail_price":"1322.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 15:09:18","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",1185,"NEW","C15-CT207096",1322,1322,0,0,"1","1",1322,1322,1322,"2020-02-03 15:09:18","0",null,null,null,"2020-02-01","2020-02-29","1 month contract. Storage rental paid by bank transfer on Feb 01,2020. Storage deposit $1322 transferred from agreement C15-CT206883 to this agreement.","2020-02-01","24",0,null,0,"0","2","2020-02-03 15:09:18","2","2020-02-03 15:09:18","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012516868","C191185","PERSONAL","Mr","\/JQwF1+M6FL7Yun0+bBCFg==","vyCKi4IYWx3VnCZylJM1yA==","","M40cxW4GMmuJRXhcXM+Wt7bO\/WDVLnPGUxgCIY4qYL\/XYrR2lvobKWJ1rPDsF3EoUQ75QxAufkpF6LMIzO2Rkg==","KUOWIMoqsVaNtCRfR6snnQ==",null,"QAJCjnmgSugLsyxdh+ZSuA==",null,1,"4243"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 15:09:18","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":["7096","1421","1322.0","1322.00","2","2020-02-03 15:09:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 15:09:18","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","1421"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-03 15:09:18","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":["7096",1185,"SETTLED","C15-I207424","2020-02-03 15:09:18","2020-02-01","2","2020-02-03 15:09:18","2","2020-02-03 15:09:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 15:09:18","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":["7424","RENT","\u9810\u7e73\u79df\u91d1",1,1322,"MO","1",1322,"2","2020-02-03 15:09:18","2","2020-02-03 15:09:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 15:09:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1322,0,"7424"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-03 15:09:18","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":[1185,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207072","2020-02-03 15:09:18",1322,"2","2020-02-03 15:09:18","2","2020-02-03 15:09:18","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 15:09:18","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":["7072","DEPOSIT",null,"PAID","2020-02-03 15:09:18",0,"2","2020-02-03 15:09:18","2","2020-02-03 15:09:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 15:09:18","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":["7072","INVOICE","7424","PAID","2020-02-03 15:09:18",1322,"2","2020-02-03 15:09:18","2","2020-02-03 15:09:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 15:18:23","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&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","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","floor_plan_rent_room":[{"room_id":"1755","master_room_id":"232","room_code":"WC-14"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1217,"customer_code":"C191217","identity_type":"PERSONAL","identity_id":"D447759(7)","title":"Ms","lastname":"HUI","firstname":"Mei Ying","companyname":"","email":"florahui23@gmail.com","tel":"91760388","address":"21B, Kam Fat Bldg, 145 Lee Chi Rd, Apleichau, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-14","renew_room_key":"'0006047753","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 4\uff0c 2020. Storage deposit $2580 transferred from agreement A05-CT196623 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT206858, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"114","order_discount":[],"order_room":[{"room_id":"1010","room_code":"A05-008","retail_price":"1290.0","discounted_price":"1290.00","location_id":"4"}],"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-02-14","rent_from":"2020-02-14","rent_to":"2020-03-13","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on February 3, 2020. Storage deposit $2580 transferred from agreement A05-CT206858 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0006047753","order_product":[],"pass":true}},"first_order_id":"4509","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-008 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1290.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 15:18: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","4",1217,"NEW","A05-CT207097",1290,1290,0,0,"1","1",1290,1290,1290,"2020-02-03 15:18:23","0",null,null,null,"2020-02-14","2020-03-13","1 month contract. Storage rental paid by bank transfer on February 3, 2020. Storage deposit $2580 transferred from agreement A05-CT206858 to this agreement.","2020-02-14","16",0,null,0,"0","2","2020-02-03 15:18:23","2","2020-02-03 15:18:23","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0006047753","C191217","PERSONAL","Ms","itB3q7EVO34a2hxkwiPhKw==","SLPJ+c2smshjwdK17xoj0w==","","ueCxoUZm7SuNCZWvZfej2KDREwW7lwoKDTTNZzTAoaO5sqnLfLBRCkfNGM8f7yinGogt7bT6sVG5LxuicUK9\/w==","6zI+PZPtByw9BmzFx6tCzA==","YTLujwAtYb1\/RI+1mL1DaVX7TvWW5ErARjMcxpk9WYA=","vm7DP84yeg7qminXe9MP\/Q==",null,1,"4509"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 15:18: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":["7097","1010","1290.0","1290.00","2","2020-02-03 15:18:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 15:18: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-14","2020-03-13","1010"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-03 15:18: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":["7097",1217,"SETTLED","A05-I207425","2020-02-03 15:18:23","2020-02-14","2","2020-02-03 15:18:23","2","2020-02-03 15:18:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 15:18: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":["7425","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-02-03 15:18:23","2","2020-02-03 15:18:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 15:18:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"7425"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-03 15:18:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1217,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207073","2020-02-03 15:18:23",1290,"2","2020-02-03 15:18:23","2","2020-02-03 15:18:23","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 15:18:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7073","DEPOSIT",null,"PAID","2020-02-03 15:18:23",0,"2","2020-02-03 15:18:23","2","2020-02-03 15:18:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 15:18:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7073","INVOICE","7425","PAID","2020-02-03 15:18:23",1290,"2","2020-02-03 15:18:23","2","2020-02-03 15:18:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 17:46:53","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&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","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","floor_plan_rent_room":[{"room_id":"1755","master_room_id":"232","room_code":"WC-14"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":685,"customer_code":"C180685","identity_type":"PERSONAL","identity_id":"Z136565(8)","title":"Mr","lastname":"Tam","firstname":"Wai Hung","companyname":"","email":null,"tel":"61102922","address":"Room 210, Wah Lai House, Wah Kwai Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2298.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-01","renew_room_key":"053,56239","renew_remark":"1 month contract. Storage rental $2300 paid by bank transfer on Jan 02,2020. Storage deposit transferred from agreement A18-CT196579 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT206828, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"81","order_discount":[],"order_room":[{"room_id":"857","room_code":"T01","retail_price":"2298.0","discounted_price":"2298.00","location_id":"3"}],"roughly_size":"30","total_retail_price":2298,"total_discounted_price":2298,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2298,"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. Storage rental $2298 paid by bank transfer on February 3, 2020. Storage deposit transferred from agreement A18-CT206828 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2298,"final_order_total":2298,"location_id":"3","branch_id":"1","company_id":"1","room_key":"053,56239","order_product":[],"pass":true}},"first_order_id":"4879","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> T01 <\/td>\r\n\t\t\t\t\t 5X6X7 <\/td>\r\n\t\t\t\t\t $2298.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":"30","total_discounted_price":"2298.0","deposit":"0","total_retail_price":"2298.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 17:46:53","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",685,"NEW","A18-CT207098",2298,2298,0,0,"1","1",2298,2298,2298,"2020-02-03 17:46:53","0",null,null,null,"2020-02-01","2020-02-29","1 month contract. Storage rental $2298 paid by bank transfer on February 3, 2020. Storage deposit transferred from agreement A18-CT206828 to this agreement.\r\n","2020-02-01","30",0,null,0,"0","2","2020-02-03 17:46:53","2","2020-02-03 17:46:53","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"053,56239","C180685","PERSONAL","Mr","Vy30hO8KRRcWAyFHMj+GkQ==","RAqogkelEKt1q5b\/6Neu\/g==","","T1rrupXx2a84nbfDVVe7dRZNixC4wynq7dBDu6A1cSJX7dG0wQgUJ6ZUu1fBgxwDKFNAcVyti6Of6RFkiuBYCg==","\/abipioEOeirm5gkDUnYEA==",null,"HSRQWr1h55jzD6yUUsYl4g==",null,1,"4879"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 17:46:53","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":["7098","857","2298.0","2298.00","2","2020-02-03 17:46:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 17:46:53","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","857"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-03 17:46:53","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":["7098",685,"SETTLED","A18-I207426","2020-02-03 17:46:53","2020-02-01","2","2020-02-03 17:46:53","2","2020-02-03 17:46:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 17:46:53","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":["7426","RENT","\u9810\u7e73\u79df\u91d1",1,2298,"MO","1",2298,"2","2020-02-03 17:46:53","2","2020-02-03 17:46:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 17:46:53","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2298,0,"7426"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-03 17:46:53","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":[685,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207074","2020-02-03 17:46:53",2298,"2","2020-02-03 17:46:53","2","2020-02-03 17:46:53","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 17:46:53","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":["7074","DEPOSIT",null,"PAID","2020-02-03 17:46:53",0,"2","2020-02-03 17:46:53","2","2020-02-03 17:46:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 17:46:53","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":["7074","INVOICE","7426","PAID","2020-02-03 17:46:53",2298,"2","2020-02-03 17:46:53","2","2020-02-03 17:46:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 18:07:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 18:30:22","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","floor_plan_rent_room":[{"room_id":"1755","master_room_id":"232","room_code":"WC-14"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":29,"customer_code":"C150029","identity_type":"PERSONAL","identity_id":"D521817(A)","title":"Ms","lastname":"Chan","firstname":"Wing See , Janet","companyname":"","email":null,"tel":"97459744","address":"\u9999\u6e2f\u5947\u529b\u7063\u5609\u9686\u82d1\u5609\u6607\u95a3801\u5ba4","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"698.0","renew_rent_month":"12","renew_warehousing_date":"2020-02-05","renew_room_key":"055,34754","renew_remark":"12 months contract. Storage rental paid by EPS on Jan 26, 2019. Storage deposit transferred from agreement \t\tA12-CT182791 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT194245, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"2","order_discount":[{"master_room_discount_id":"61","master_room_id":"2","discount_type":"%","price":"814.00","disocunted_price":"748.90","discount":"8.00","monthly_deduct":65.12,"room_id":"309","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"309","room_code":"E36","retail_price":"814.0","discounted_price":748.9,"location_id":"1"}],"roughly_size":"9","total_retail_price":814,"total_discounted_price":698,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":8376,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-05","rent_from":"2020-02-05","rent_to":"2021-02-04","delivery_service":"0","remark":"12 months contract. Special offer $300 Maxim's voucher. Storage rental paid by PPS on February 3, 2020. Storage deposit transferred from agreement A12-CT194245 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":8376,"final_order_total":8376,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,34754","order_product":[],"pass":true}},"first_order_id":4245,"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> E36 <\/td>\r\n\t\t\t\t\t 3X3X8 <\/td>\r\n\t\t\t\t\t $814.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":"9","total_discounted_price":"698.0","deposit":"0","total_retail_price":"814.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 18:30: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",29,"NEW","A12-CT207099",814,698,0,0,"12","12",8376,8376,8376,"2020-02-03 18:30:23","0",null,null,null,"2020-02-05","2021-02-04","12 months contract. Special offer $300 Maxim's voucher. Storage rental paid by PPS on February 3, 2020. Storage deposit transferred from agreement A12-CT194245 to this agreement.","2020-02-05","9",0,null,0,"0","2","2020-02-03 18:30:22","2","2020-02-03 18:30:22","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,34754","C150029","PERSONAL","Ms","D2mRtddw78l9HrOAdSkifW7GvgysdtPw3UxhnrSBwFo=","U9yoE9KqV1v8YlRkf7Q2yg==","","5ugb5EmZVvyYaI52TEecXXbNu5VtkR9Wkr2y61Ri2KB9om0Jv\/CYAAIqHgXICDZe","QeTd2xN4rPBV7+OzcpSK1Q==",null,"gnwOU9SMiz3M32BpPTwcBA==",null,1,4245]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 18:30:23","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":["7099","61","2","309","%","8.00",65.12,"2","2020-02-03 18:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 18:30: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":["7099","309","814.0",748.9,"2","2020-02-03 18:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 18:30: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-05","2021-02-04","309"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-03 18:30: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":["7099",29,"SETTLED","A12-I207427","2020-02-03 18:30:22","2020-02-05","2","2020-02-03 18:30:22","2","2020-02-03 18:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 18:30: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":["7427","RENT","\u9810\u7e73\u79df\u91d1",1,698,"MO","1",698,"2","2020-02-03 18:30:22","2","2020-02-03 18:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 18:30: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":["7427","RENT","\u9810\u7e73\u79df\u91d1",2,698,"MO","1",698,"2","2020-02-03 18:30:22","2","2020-02-03 18:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 18:30: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":["7427","RENT","\u9810\u7e73\u79df\u91d1",3,698,"MO","1",698,"2","2020-02-03 18:30:22","2","2020-02-03 18:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 18:30: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":["7427","RENT","\u9810\u7e73\u79df\u91d1",4,698,"MO","1",698,"2","2020-02-03 18:30:22","2","2020-02-03 18:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 18:30: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":["7427","RENT","\u9810\u7e73\u79df\u91d1",5,698,"MO","1",698,"2","2020-02-03 18:30:22","2","2020-02-03 18:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 18:30: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":["7427","RENT","\u9810\u7e73\u79df\u91d1",6,698,"MO","1",698,"2","2020-02-03 18:30:22","2","2020-02-03 18:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 18:30: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":["7427","RENT","\u9810\u7e73\u79df\u91d1",7,698,"MO","1",698,"2","2020-02-03 18:30:22","2","2020-02-03 18:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 18:30: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":["7427","RENT","\u9810\u7e73\u79df\u91d1",8,698,"MO","1",698,"2","2020-02-03 18:30:22","2","2020-02-03 18:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 18:30: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":["7427","RENT","\u9810\u7e73\u79df\u91d1",9,698,"MO","1",698,"2","2020-02-03 18:30:22","2","2020-02-03 18:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 18:30: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":["7427","RENT","\u9810\u7e73\u79df\u91d1",10,698,"MO","1",698,"2","2020-02-03 18:30:22","2","2020-02-03 18:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 18:30: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":["7427","RENT","\u9810\u7e73\u79df\u91d1",11,698,"MO","1",698,"2","2020-02-03 18:30:22","2","2020-02-03 18:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 18:30: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":["7427","RENT","\u9810\u7e73\u79df\u91d1",12,698,"MO","1",698,"2","2020-02-03 18:30:22","2","2020-02-03 18:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 18:30:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8376,0,"7427"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-03 18:30: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":[29,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207075","2020-02-03 18:30:22",8376,"2","2020-02-03 18:30:22","2","2020-02-03 18:30:22","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 18:30: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":["7075","DEPOSIT",null,"PAID","2020-02-03 18:30:22",0,"2","2020-02-03 18:30:22","2","2020-02-03 18:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 18:30: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":["7075","INVOICE","7427","PAID","2020-02-03 18:30:22",8376,"2","2020-02-03 18:30:22","2","2020-02-03 18:30:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 18:43:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-03 18:47:48","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****