{"created_at":"2020-03-31 10:05:26","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=882&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1165","master_room_id":"123","room_code":"A05-163"}],"_payment_type":"INVOICE","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-04-17","renew_room_key":"053,48941","renew_remark":"1 month contract. Storage rental paid by bank transfer on March 2, 2020. Storage deposit transferred from agreement A12-CT196815 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207288, \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-04-17","rent_from":"2020-04-17","rent_to":"2020-05-16","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on March 31, 2020. Storage deposit transferred from agreement A12-CT207288 to this agreement.\r\n","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-03-31 10:05:26","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-CT207529",1528,1286,0,0,"1","1",1286,1286,1286,"2020-03-31 10:05:26","0",null,null,null,"2020-04-17","2020-05-16","1 month contract. Storage rental paid by bank transfer on March 31, 2020. Storage deposit transferred from agreement A12-CT207288 to this agreement.\r\n","2020-04-17","20",0,null,0,"0","2","2020-03-31 10:05:26","2","2020-03-31 10:05:26","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-03-31 10:05:26","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":["7529","101","1528.0","1528.00","2","2020-03-31 10:05:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 10:05:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-17","2020-05-16","101"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-31 10:05:26","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":["7529",441,"SETTLED","A12-I207857","2020-03-31 10:05:26","2020-04-17","2","2020-03-31 10:05:26","2","2020-03-31 10:05:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 10:05:26","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":["7857","RENT","\u9810\u7e73\u79df\u91d1",1,1286,"MO","1",1286,"2","2020-03-31 10:05:26","2","2020-03-31 10:05:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 10:05:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1286,0,"7857"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-31 10:05:26","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","P207504","2020-03-31 10:05:26",1286,"2","2020-03-31 10:05:26","2","2020-03-31 10:05:26","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 10:05:26","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":["7504","DEPOSIT",null,"PAID","2020-03-31 10:05:26",0,"2","2020-03-31 10:05:26","2","2020-03-31 10:05:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 10:05:26","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":["7504","INVOICE","7857","PAID","2020-03-31 10:05:26",1286,"2","2020-03-31 10:05:26","2","2020-03-31 10:05:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 10:09:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:09:10","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=395&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1165","master_room_id":"123","room_code":"A05-163"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":681,"customer_code":"C180681","identity_type":"PERSONAL","identity_id":"K087413(2)","title":"Mr","lastname":"Chung","firstname":"Ka Po","companyname":"","email":"patrickbobofamily@gmail.com","tel":"63336887","address":"3\/F, Siu Fung Hong Building, 239-241 Wing Lok Street, Sheung Wan, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"965.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-02","renew_room_key":"056,05555","renew_remark":"1 month contract. Storage rental paid by PPS on March 1, 2020. Storage deposit transferred from agreement A18-CT207085 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207285, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"103","order_discount":[],"order_room":[{"room_id":"906","room_code":"U07","retail_price":"965.0","discounted_price":"965.00","location_id":"3"}],"roughly_size":"8","total_retail_price":965,"total_discounted_price":965,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":965,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-02","rent_from":"2020-04-02","rent_to":"2020-05-01","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on March 30, 2020. Storage deposit transferred from agreement A18-CT207285 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":965,"final_order_total":965,"location_id":"3","branch_id":"1","company_id":"1","room_key":"056,05555","order_product":[],"pass":true}},"first_order_id":"4704","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> U07 <\/td>\r\n\t\t\t\t\t 2X4X7 <\/td>\r\n\t\t\t\t\t $965.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","total_discounted_price":"965.0","deposit":"0","total_retail_price":"965.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:09:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",681,"NEW","A18-CT207530",965,965,0,0,"1","1",965,965,965,"2020-03-31 12:09:10","0",null,null,null,"2020-04-02","2020-05-01","1 month contract. Storage rental paid by PPS on March 30, 2020. Storage deposit transferred from agreement A18-CT207285 to this agreement.\r\n","2020-04-02","8",0,null,0,"0","2","2020-03-31 12:09:10","2","2020-03-31 12:09:10","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"056,05555","C180681","PERSONAL","Mr","WpXUsGIV5ZMagl9ab+XsmA==","ThKwrAIcvgN3JqAg+7\/isg==","","MfbxfJxu6rnCI3QT7TKkp941rf6ZLqXK4FI5VbVzAJiJni8uQnXc2gGJQSsyflI200jM1kVIWfocMiR8ixEVuOtN59H0aUN3N6cpSW\/Zb8g=","uk+aBM1pdnZq7uENadbWLg==","AlXt3dY1\/1B81wXwqLajny8WQO2W1oXWizWY\/cvTtlY=","ikLrZy69X3qkMVAoKWXxnQ==",null,1,"4704"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:09:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7530","906","965.0","965.00","2","2020-03-31 12:09:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:09:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-02","2020-05-01","906"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-31 12:09:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7530",681,"SETTLED","A18-I207858","2020-03-31 12:09:10","2020-04-02","2","2020-03-31 12:09:10","2","2020-03-31 12:09:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:09:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7858","RENT","\u9810\u7e73\u79df\u91d1",1,965,"MO","1",965,"2","2020-03-31 12:09:10","2","2020-03-31 12:09:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:09:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[965,0,"7858"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-31 12:09:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[681,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207505","2020-03-31 12:09:10",965,"2","2020-03-31 12:09:10","2","2020-03-31 12:09:10","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:09:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7505","DEPOSIT",null,"PAID","2020-03-31 12:09:10",0,"2","2020-03-31 12:09:10","2","2020-03-31 12:09:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:09:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7505","INVOICE","7858","PAID","2020-03-31 12:09:10",965,"2","2020-03-31 12:09:10","2","2020-03-31 12:09:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:11:48","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=395&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1165","master_room_id":"123","room_code":"A05-163"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":999,"customer_code":"C180999","identity_type":"PERSONAL","identity_id":"K209079(1)","title":"Mr","lastname":"Ho","firstname":"Ka Man","companyname":"","email":"hokaman1973@gmail.com","tel":"93080512","address":"Rm517, Chak Tsui Hse, Wan Tsui Estate, Chai Wan","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1678.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-28","renew_room_key":"0005821195","renew_remark":"1 month contract. Storage rental paid by PPS on February 28, 2020. Storage deposit $1678 transferred from agreement C15-CT207059 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT207306, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"161","order_discount":[],"order_room":[{"room_id":"1472","room_code":"C15-166","retail_price":"1678.0","discounted_price":"1678.00","location_id":"6"}],"roughly_size":"28","total_retail_price":1678,"total_discounted_price":1678,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1678,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-28","rent_from":"2020-03-28","rent_to":"2020-04-27","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on March 30, 2020. Storage deposit $1678 transferred from agreement C15-CT207306 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1678,"final_order_total":1678,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0005821195","order_product":[],"pass":true}},"first_order_id":"5351","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-166 <\/td>\r\n\t\t\t\t\t 3.5X8X6.5 <\/td>\r\n\t\t\t\t\t $1678.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"28","total_discounted_price":"1678.0","deposit":"0","total_retail_price":"1678.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:11:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",999,"NEW","C15-CT207531",1678,1678,0,0,"1","1",1678,1678,1678,"2020-03-31 12:11:49","0",null,null,null,"2020-03-28","2020-04-27","1 month contract. Storage rental paid by PPS on March 30, 2020. Storage deposit $1678 transferred from agreement C15-CT207306 to this agreement. \r\n","2020-03-28","28",0,null,0,"0","2","2020-03-31 12:11:48","2","2020-03-31 12:11:48","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0005821195","C180999","PERSONAL","Mr","mpGDaYSZYMm5Nv4dlC\/AXA==","D\/skxQ5s\/L5yyRWaDK\/iSg==","","s+jJD+PTKIcV6TFUbKAjZeaR7whyPq\/zYSwZaQ3P71eVxgGVseccbnTawUyuMcS0","6hDDMUpiAw3i7Vyi+5LUuw==","O5CaJhqkZvhJIkWAmdNjem53qQvwEVnuhSQx55cm2I4=","lBWb6eJ9jDFkCCTNwsJ4wA==",null,1,"5351"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:11:49","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":["7531","1472","1678.0","1678.00","2","2020-03-31 12:11:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:11:49","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-28","2020-04-27","1472"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-31 12:11:49","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":["7531",999,"SETTLED","C15-I207859","2020-03-31 12:11:48","2020-03-28","2","2020-03-31 12:11:48","2","2020-03-31 12:11:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:11:49","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":["7859","RENT","\u9810\u7e73\u79df\u91d1",1,1678,"MO","1",1678,"2","2020-03-31 12:11:48","2","2020-03-31 12:11:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:11:49","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1678,0,"7859"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-31 12:11:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[999,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207506","2020-03-31 12:11:48",1678,"2","2020-03-31 12:11:48","2","2020-03-31 12:11:48","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:11:49","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":["7506","DEPOSIT",null,"PAID","2020-03-31 12:11:48",0,"2","2020-03-31 12:11:48","2","2020-03-31 12:11:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:11:49","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":["7506","INVOICE","7859","PAID","2020-03-31 12:11:48",1678,"2","2020-03-31 12:11:48","2","2020-03-31 12:11:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:14: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":"filter1=1&filter2=1008&filter3=undefined","floor_plan_rent_room":[{"room_id":"1165","master_room_id":"123","room_code":"A05-163"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1008,"customer_code":"C181008","identity_type":"PERSONAL","identity_id":"K700926(7)","title":"Ms","lastname":"Cheng","firstname":"King","companyname":"","email":"dumpling_jing@hotmail.com","tel":"90989956","address":"FT F 60\/F Tower 2 , 38 Tai Hong Street, Grand Promenade , Sai Wan Ho, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1115.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-10","renew_room_key":"0005796877","renew_remark":"1 month contract. Storage rental paid by PPS on March 2, 2020. Storage deposit $2230 transferred from agreement C15-CT207067 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT207313, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"172","order_discount":[],"order_room":[{"room_id":"1408","room_code":"C15-102","retail_price":"1115.0","discounted_price":"1115.00","location_id":"6"}],"roughly_size":"20","total_retail_price":1115,"total_discounted_price":1115,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1115,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-10","rent_from":"2020-04-10","rent_to":"2020-05-09","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on March 30, 2020. Storage deposit $2230 transferred from agreement C15-CT207313 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1115,"final_order_total":1115,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0005796877","order_product":[],"pass":true}},"first_order_id":"3501","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-102 <\/td>\r\n\t\t\t\t\t 4X5X6.5 <\/td>\r\n\t\t\t\t\t $1115.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":"20","total_discounted_price":"1115.0","deposit":"0","total_retail_price":"1115.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:14:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1008,"NEW","C15-CT207532",1115,1115,0,0,"1","1",1115,1115,1115,"2020-03-31 12:14:41","0",null,null,null,"2020-04-10","2020-05-09","1 month contract. Storage rental paid by PPS on March 30, 2020. Storage deposit $2230 transferred from agreement C15-CT207313 to this agreement. \r\n","2020-04-10","20",0,null,0,"0","2","2020-03-31 12:14:41","2","2020-03-31 12:14:41","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0005796877","C181008","PERSONAL","Ms","pyScVxHN1bAPGGa\/Bucd1Q==","UCPBCXrBLI9U7KKsPqgmNA==","","LoTfAY\/7hsJ5LMg1lxRl5U61+y\/bHOn3mXXs4ZtLiTsKgr3U0XtRwxPFeprq+NiHAM+QrB+m5+WZ7R14dzMxe+z0ciqodfk7L3bAksKmsSI=","ODUJ\/sh5I9t4EANm7+m4qQ==","IK6uRSfHgYDvM30SfvOBrVdAXD9E++uXhp1WOnqnMIk=","0n\/HYQ\/ulfaXU7JBtiiVDg==",null,1,"3501"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:14:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7532","1408","1115.0","1115.00","2","2020-03-31 12:14:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:14:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-10","2020-05-09","1408"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-31 12:14:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7532",1008,"SETTLED","C15-I207860","2020-03-31 12:14:41","2020-04-10","2","2020-03-31 12:14:41","2","2020-03-31 12:14:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:14:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7860","RENT","\u9810\u7e73\u79df\u91d1",1,1115,"MO","1",1115,"2","2020-03-31 12:14:41","2","2020-03-31 12:14:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:14:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1115,0,"7860"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-31 12:14:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1008,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207507","2020-03-31 12:14:41",1115,"2","2020-03-31 12:14:41","2","2020-03-31 12:14:41","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:14:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7507","DEPOSIT",null,"PAID","2020-03-31 12:14:41",0,"2","2020-03-31 12:14:41","2","2020-03-31 12:14:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:14:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7507","INVOICE","7860","PAID","2020-03-31 12:14:41",1115,"2","2020-03-31 12:14:41","2","2020-03-31 12:14:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:18:36","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1008&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1165","master_room_id":"123","room_code":"A05-163"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":807,"customer_code":"C180807","identity_type":"PERSONAL","identity_id":"K546620(2)","title":"Mr","lastname":"Choy","firstname":"Chung Kit","companyname":"","email":"chung.greatoo@gmail.com","tel":"65722444","address":"Flat F, 17\/F, Pokfulam Gardens, Pok Fu Lam, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1342.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-26","renew_room_key":"072,57038","renew_remark":"1 month contract. Storage rental paid by bank transfer on March 1, 2020. Storage deposit transferred from agreement A14-CT207080 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207281, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"68","order_discount":[],"order_room":[{"room_id":"526","room_code":"L04(\u670d\u88dd\u5009)","retail_price":"1342.0","discounted_price":"1342.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1342,"total_discounted_price":1342,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1342,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-26","rent_from":"2020-03-26","rent_to":"2020-04-25","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on March 30, 2020. Storage deposit transferred from agreement A14-CT207281 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1342,"final_order_total":1342,"location_id":"2","branch_id":"1","company_id":"1","room_key":"072,57038","order_product":[],"pass":true}},"first_order_id":"4859","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> L04(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1342.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1342.0","deposit":"0","total_retail_price":"1342.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:18:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",807,"NEW","A14-CT207533",1342,1342,0,0,"1","1",1342,1342,1342,"2020-03-31 12:18:36","0",null,null,null,"2020-03-26","2020-04-25","1 month contract. Storage rental paid by bank transfer on March 30, 2020. Storage deposit transferred from agreement A14-CT207281 to this agreement.\r\n","2020-03-26","16",0,null,0,"0","2","2020-03-31 12:18:36","2","2020-03-31 12:18:36","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"072,57038","C180807","PERSONAL","Mr","UrB+L8vaPiEMZevupuoWEA==","UrsMAvfb5x9QBcnJ8435JA==","","ME0hoxN9uZ9kGpx7EDhDMplFp1dDf6LAd2zTCgZuVMA07NK1aBM+okfJHxxQhQeMEGMyIA8TbBMZxd3bYkNlpA==","yzkFlVLEWHluqrSaK6I+5w==","D5Tn0rsTf6KebW06OoCf5+7qkW80yY20kTJlXh0yutU=","SXzqecVFjMModfNH2tMtyQ==",null,1,"4859"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:18:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7533","526","1342.0","1342.00","2","2020-03-31 12:18:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:18:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-26","2020-04-25","526"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-31 12:18:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7533",807,"SETTLED","A14-I207861","2020-03-31 12:18:36","2020-03-26","2","2020-03-31 12:18:36","2","2020-03-31 12:18:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:18:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7861","RENT","\u9810\u7e73\u79df\u91d1",1,1342,"MO","1",1342,"2","2020-03-31 12:18:36","2","2020-03-31 12:18:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:18:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1342,0,"7861"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-31 12:18:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[807,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207508","2020-03-31 12:18:36",1342,"2","2020-03-31 12:18:36","2","2020-03-31 12:18:36","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:18:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7508","DEPOSIT",null,"PAID","2020-03-31 12:18:36",0,"2","2020-03-31 12:18:36","2","2020-03-31 12:18:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:18:36","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7508","INVOICE","7861","PAID","2020-03-31 12:18:36",1342,"2","2020-03-31 12:18:36","2","2020-03-31 12:18:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:20:40","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1008&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1165","master_room_id":"123","room_code":"A05-163"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":874,"customer_code":"C180874","identity_type":"PERSONAL","identity_id":"K451268(5)","title":"Mr","lastname":"Lui","firstname":"Chun Hung","companyname":"","email":"patpat9413888@yahoo.com.hk","tel":"90301273","address":"Room 403, Low Block, Lei Fook House, Apleichau Estate, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-22","renew_room_key":"076,32357","renew_remark":"1 month contract. Storage rental paid by PPS on Feb 26, 2020. Storage deposit transferred from agreement A12-CT207060 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207264, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"241","room_code":"D45","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-22","rent_from":"2020-03-22","rent_to":"2020-04-21","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on March 30, 2020. Storage deposit transferred from agreement A12-CT207264 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"076,32357","order_product":[],"pass":true}},"first_order_id":"4854","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> D45 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:20:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",874,"NEW","A12-CT207534",998,1038,0,0,"1","1",1038,1038,1038,"2020-03-31 12:20:41","0",null,null,null,"2020-03-22","2020-04-21","1 month contract. Storage rental paid by PPS on March 30, 2020. Storage deposit transferred from agreement A12-CT207264 to this agreement.","2020-03-22","12",0,null,0,"0","2","2020-03-31 12:20:40","2","2020-03-31 12:20:40","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"076,32357","C180874","PERSONAL","Mr","8E6nLeLaS+nuXxUNvooxGQ==","vyCKi4IYWx3VnCZylJM1yA==","","t2fcXTNQ5zXw41HK7XLxjgpqs4CAbleDk0AZC75MEKtw5ZsokMMh80cI\/IUaR9tYbJXdnEldy\/dOlMJjVNoCJBK+BLg2Hq37YGStg4SRRpc=","v99UbwvGk\/IX8Amdc7pe+Q==","93qNDvLNra1NfZlAUamtzf14nbvapEp9X2o2aos8F7w=","fzIJnHKlsYW3ETkg3nSzoQ==",null,1,"4854"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:20:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7534","241","998.0","998.00","2","2020-03-31 12:20:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:20:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-22","2020-04-21","241"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-31 12:20:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7534",874,"SETTLED","A12-I207862","2020-03-31 12:20:40","2020-03-22","2","2020-03-31 12:20:40","2","2020-03-31 12:20:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:20:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7862","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-03-31 12:20:40","2","2020-03-31 12:20:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:20:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"7862"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-31 12:20:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[874,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207509","2020-03-31 12:20:40",1038,"2","2020-03-31 12:20:40","2","2020-03-31 12:20:40","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:20:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7509","DEPOSIT",null,"PAID","2020-03-31 12:20:40",0,"2","2020-03-31 12:20:40","2","2020-03-31 12:20:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:20:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7509","INVOICE","7862","PAID","2020-03-31 12:20:40",1038,"2","2020-03-31 12:20:40","2","2020-03-31 12:20:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 12:50:31","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 14:30:17","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1008&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1165","master_room_id":"123","room_code":"A05-163"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":904,"customer_code":"C180904","identity_type":"PERSONAL","identity_id":"D513677(7)","title":"Mr","lastname":"Lee","firstname":"Kim Hung","companyname":"","email":"luplus@hgcbroadband.com","tel":"98657033","address":"Flat C, 8\/F, Block 29, Fung King Court, South Horizon, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1167.0","renew_rent_month":"3","renew_warehousing_date":"2020-02-28","renew_room_key":"190,40459,190,26677","renew_remark":"3 months contract. Storage rental paid by bank transfer on Dec 03, 2019. Outstanding $366 will be deducted in next agreement. Deposit $2456 transferred from agreement A14-CT196428 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196817, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[{"master_room_discount_id":"434","master_room_id":"35","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"501","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"501","room_code":"K38","retail_price":"1098.0","discounted_price":1043.4,"location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1167,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3135,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"366.00","warehousing_date":"2020-02-28","rent_from":"2020-02-28","rent_to":"2020-05-27","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on Dec 03, 2019. Rental $366 and deposit $2456 transferred from agreement A14-CT196817 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":366,"order_total":3501,"final_order_total":3135,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190,40459,190,26677","order_product":[],"pass":true}},"first_order_id":"4261","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> K38 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1167.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 14:30:17","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",904,"NEW","A14-CT207535",1098,1167,0,0,"3","3",3135,3501,3135,"2020-03-31 14:30:17","0",null,null,null,"2020-02-28","2020-05-27","3 months contract. Storage rental paid by bank transfer on Dec 03, 2019. Rental $366 and deposit $2456 transferred from agreement A14-CT196817 to this agreement.\r\n","2020-02-28","16",0,null,366,"366.00","2","2020-03-31 14:30:17","2","2020-03-31 14:30:17","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190,40459,190,26677","C180904","PERSONAL","Mr","GqH+t4D4XqDN5Gx3zJwoLQ==","kiriEIqhcx866RNZiMXdKQ==","","iHpVrORte32amFa0iA2m3loee1+zslqIL\/7FP2fxc0DcV2T8K6RpbNnKzf8+y3YX\/HSrJ9HIQxVivWaX+vYSfPnGcbPVUj+QrNNyAeaF4No=","xblDSif\/OxScVYnZ8ntRGw==","j4azBMg4uFIF0TmQ06Wk1A\/5a8goLVmCGncsLq4iJqM=","n1gCvw4+mkHcKV9r39Ub7A==",null,1,"4261"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 14:30:17","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":["7535","434","35","501","%","4.97",54.5706,"2","2020-03-31 14:30:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 14:30:17","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":["7535","501","1098.0",1043.4,"2","2020-03-31 14:30:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 14:30:17","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-28","2020-05-27","501"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-31 14:30:17","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":["7535",904,"SETTLED","A14-I207863","2020-03-31 14:30:17","2020-02-28","2","2020-03-31 14:30:17","2","2020-03-31 14:30:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 14:30:17","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":["7863","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,801,"MO","1",801,"2","2020-03-31 14:30:17","2","2020-03-31 14:30:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 14:30:17","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":["7863","RENT","\u9810\u7e73\u79df\u91d1",2,1167,"MO","1",1167,"2","2020-03-31 14:30:17","2","2020-03-31 14:30:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 14:30:17","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":["7863","RENT","\u9810\u7e73\u79df\u91d1",3,1167,"MO","1",1167,"2","2020-03-31 14:30:17","2","2020-03-31 14:30:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 14:30:17","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3135,0,"7863"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-31 14:30:17","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":[904,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207510","2020-03-31 14:30:17",3135,"2","2020-03-31 14:30:17","2","2020-03-31 14:30:17","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 14:30:17","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":["7510","DEPOSIT",null,"PAID","2020-03-31 14:30:17",0,"2","2020-03-31 14:30:17","2","2020-03-31 14:30:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 14:30:17","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":["7510","INVOICE","7863","PAID","2020-03-31 14:30:17",3135,"2","2020-03-31 14:30:17","2","2020-03-31 14:30:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 14:52:51","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1008&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1165","master_room_id":"123","room_code":"A05-163"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":904,"customer_code":"C180904","identity_type":"PERSONAL","identity_id":"D513677(7)","title":"Mr","lastname":"Lee","firstname":"Kim Hung","companyname":"","email":"luplus@hgcbroadband.com","tel":"98657033","address":"Flat C, 8\/F, Block 29, Fung King Court, South Horizon, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1167.0","renew_rent_month":"3","renew_warehousing_date":"2020-03-01","renew_room_key":"076,28245","renew_remark":"3 months contract. Storage rental paid by bank transfer on Dec 31, 2019. Deposit $2456 transferred from agreement A14-CT196429 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196818, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[{"master_room_discount_id":"434","master_room_id":"35","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"505","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"505","room_code":"K42","retail_price":"1098.0","discounted_price":1043.4,"location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1167,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3501,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-01","rent_from":"2020-03-01","rent_to":"2020-05-31","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on March 30, 2020. Deposit $2456 transferred from agreement A14-CT196818 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3501,"final_order_total":3501,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,28245","order_product":[],"pass":true}},"first_order_id":"4262","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> K42 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1167.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 14:52:52","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",904,"NEW","A14-CT207536",1098,1167,0,0,"3","3",3501,3501,3501,"2020-03-31 14:52:52","0",null,null,null,"2020-03-01","2020-05-31","3 months contract. Storage rental paid by bank transfer on March 30, 2020. Deposit $2456 transferred from agreement A14-CT196818 to this agreement.\r\n","2020-03-01","16",0,null,0,"0","2","2020-03-31 14:52:51","2","2020-03-31 14:52:51","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,28245","C180904","PERSONAL","Mr","GqH+t4D4XqDN5Gx3zJwoLQ==","kiriEIqhcx866RNZiMXdKQ==","","iHpVrORte32amFa0iA2m3loee1+zslqIL\/7FP2fxc0DcV2T8K6RpbNnKzf8+y3YX\/HSrJ9HIQxVivWaX+vYSfPnGcbPVUj+QrNNyAeaF4No=","xblDSif\/OxScVYnZ8ntRGw==","j4azBMg4uFIF0TmQ06Wk1A\/5a8goLVmCGncsLq4iJqM=","n1gCvw4+mkHcKV9r39Ub7A==",null,1,"4262"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 14:52:52","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":["7536","434","35","505","%","4.97",54.5706,"2","2020-03-31 14:52:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 14:52:52","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":["7536","505","1098.0",1043.4,"2","2020-03-31 14:52:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 14:52:52","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-01","2020-05-31","505"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-31 14:52:52","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":["7536",904,"SETTLED","A14-I207864","2020-03-31 14:52:51","2020-03-01","2","2020-03-31 14:52:51","2","2020-03-31 14:52:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 14:52:52","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":["7864","RENT","\u9810\u7e73\u79df\u91d1",1,1167,"MO","1",1167,"2","2020-03-31 14:52:51","2","2020-03-31 14:52:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 14:52:52","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":["7864","RENT","\u9810\u7e73\u79df\u91d1",2,1167,"MO","1",1167,"2","2020-03-31 14:52:51","2","2020-03-31 14:52:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 14:52:52","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":["7864","RENT","\u9810\u7e73\u79df\u91d1",3,1167,"MO","1",1167,"2","2020-03-31 14:52:51","2","2020-03-31 14:52:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 14:52:52","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3501,0,"7864"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-31 14:52:52","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":[904,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207511","2020-03-31 14:52:51",3501,"2","2020-03-31 14:52:51","2","2020-03-31 14:52:51","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 14:52:52","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":["7511","DEPOSIT",null,"PAID","2020-03-31 14:52:51",0,"2","2020-03-31 14:52:51","2","2020-03-31 14:52:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 14:52:52","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":["7511","INVOICE","7864","PAID","2020-03-31 14:52:51",3501,"2","2020-03-31 14:52:51","2","2020-03-31 14:52:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 15:10:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 15:17:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:04:29","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1008&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1165","master_room_id":"123","room_code":"A05-163"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1410,"customer_code":"C191410","identity_type":"PERSONAL","identity_id":"K225482(4)","title":"Ms","lastname":"LAI","firstname":"Si Ting Cecilia","companyname":"","email":null,"tel":"60950188","address":"Rm 1, 20\/F, Kong Wing Court, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"899.0","renew_rent_month":"6","renew_warehousing_date":"2020-04-04","renew_room_key":"189,633727","renew_remark":"6 months contract. Special 5% "rent now" offer and $500 coupon. Storage rental and deposit paid by cash on October 4, 2019. Smardcard provided on October 4, 2019. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196075, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1996.0","renew_master_room_id":"6","order_discount":[{"master_room_discount_id":"70","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"898.60","discount":"9.96","monthly_deduct":99.4008,"room_id":"230","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"230","room_code":"D34","retail_price":"998.0","discounted_price":898.6,"location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":899,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5394,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-04","rent_from":"2020-04-04","rent_to":"2020-10-03","delivery_service":"0","remark":"6 months contract. Storage rental paid by cash on March 31, 2020. Storage deposit $1996 transferred from agreement A12-CT196075 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":5394,"final_order_total":5394,"location_id":"1","branch_id":"1","company_id":"1","room_key":"189,633727","order_product":[],"pass":true}},"first_order_id":6075,"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> D34 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"899.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:04:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",1410,"NEW","A12-CT207537",998,899,0,0,"6","6",5394,5394,5394,"2020-03-31 17:04:30","0",null,null,null,"2020-04-04","2020-10-03","6 months contract. Storage rental paid by cash on March 31, 2020. Storage deposit $1996 transferred from agreement A12-CT196075 to this agreement. \r\n","2020-04-04","12",0,null,0,"0","2","2020-03-31 17:04:29","2","2020-03-31 17:04:29","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"189,633727","C191410","PERSONAL","Ms","PnCsqWRVQnRzsgNaswotGQ==","8hiEOuVVoOMleTEBdtujcw==","","Q\/03oEurE3NYNWcT76yxRGIa5V29+nJZPk8h4LEdweySTYn7kdzSeQ3no3OkjNgS","POOD3Culec8g9Y5CeGNvXg==",null,"TbUnqi+LijsatFpotSK04g==",null,1,6075]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:04:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["7537","70","6","230","%","9.96",99.4008,"2","2020-03-31 17:04:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:04: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":["7537","230","998.0",898.6,"2","2020-03-31 17:04:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:04: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-04-04","2020-10-03","230"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-31 17:04: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":["7537",1410,"SETTLED","A12-I207865","2020-03-31 17:04:29","2020-04-04","2","2020-03-31 17:04:29","2","2020-03-31 17:04:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:04: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":["7865","RENT","\u9810\u7e73\u79df\u91d1",1,899,"MO","1",899,"2","2020-03-31 17:04:29","2","2020-03-31 17:04:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:04: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":["7865","RENT","\u9810\u7e73\u79df\u91d1",2,899,"MO","1",899,"2","2020-03-31 17:04:29","2","2020-03-31 17:04:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:04: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":["7865","RENT","\u9810\u7e73\u79df\u91d1",3,899,"MO","1",899,"2","2020-03-31 17:04:29","2","2020-03-31 17:04:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:04: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":["7865","RENT","\u9810\u7e73\u79df\u91d1",4,899,"MO","1",899,"2","2020-03-31 17:04:29","2","2020-03-31 17:04:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:04: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":["7865","RENT","\u9810\u7e73\u79df\u91d1",5,899,"MO","1",899,"2","2020-03-31 17:04:29","2","2020-03-31 17:04:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:04: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":["7865","RENT","\u9810\u7e73\u79df\u91d1",6,899,"MO","1",899,"2","2020-03-31 17:04:29","2","2020-03-31 17:04:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:04:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5394,0,"7865"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-31 17:04: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":[1410,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P207512","2020-03-31 17:04:29",5394,"2","2020-03-31 17:04:29","2","2020-03-31 17:04:29","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:04: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":["7512","DEPOSIT",null,"PAID","2020-03-31 17:04:29",0,"2","2020-03-31 17:04:29","2","2020-03-31 17:04:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:04: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":["7512","INVOICE","7865","PAID","2020-03-31 17:04:29",5394,"2","2020-03-31 17:04:29","2","2020-03-31 17:04:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:13:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:17:40","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1008&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1165","master_room_id":"123","room_code":"A05-163"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":47,"customer_code":"C150047","identity_type":"PERSONAL","identity_id":"Z146174(6)","title":"Mr","lastname":"Chow","firstname":"Wing Sun","companyname":"","email":"codychow@hotmail.com","tel":"93287726","address":"Room 2601, Kong Thai Crt, Nam Ning Street, Aberdeen, H.K.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"698.0","renew_rent_month":"12","renew_warehousing_date":"2020-03-01","renew_room_key":"054,18907","renew_remark":"12 months contract. Storage rental paid by bank transfer on March 29, 2019. Storage deposit transferred from agreement A12-CT183027 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT194679, \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":"281","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"281","room_code":"E08","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-03-01","rent_from":"2020-03-01","rent_to":"2021-02-28","delivery_service":"0","remark":"12 months contract. Special offer $300 Maxim's voucher. Storage rental paid by bank transfer on March 31, 2020. Storage deposit transferred from agreement A12-CT194679 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":8376,"final_order_total":8376,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,18907","order_product":[],"pass":true}},"first_order_id":4679,"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> E08 <\/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-03-31 17:17:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",47,"NEW","A12-CT207538",814,698,0,0,"12","12",8376,8376,8376,"2020-03-31 17:17:41","0",null,null,null,"2020-03-01","2021-02-28","12 months contract. Special offer $300 Maxim's voucher. Storage rental paid by bank transfer on March 31, 2020. Storage deposit transferred from agreement A12-CT194679 to this agreement.\r\n","2020-03-01","9",0,null,0,"0","2","2020-03-31 17:17:40","2","2020-03-31 17:17:40","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,18907","C150047","PERSONAL","Mr","EjsWd\/EiwjEkCIXHJjBD5Q==","anq5M29vFb7FteUGD1jgrQ==","","KQGfA9PtizrlU511hYWa5tVxb5KIyryzRcIWVYVmz85Bh15aRqB5rSTozrkRwkj3FFPPqdYkTUXJF2r9PuRkqQ==","90IgJAEz62et4txP2GWWSg==","LZ3xPEeBNT15x2IubO3FRYu\/3Em9YreCNyi4obkiJG4=","r8+WVQqsBYbKKMh3blG6lw==",null,1,4679]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:17:41","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":["7538","61","2","281","%","8.00",65.12,"2","2020-03-31 17:17:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:17:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7538","281","814.0",748.9,"2","2020-03-31 17:17:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:17:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-01","2021-02-28","281"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-31 17:17:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7538",47,"SETTLED","A12-I207866","2020-03-31 17:17:40","2020-03-01","2","2020-03-31 17:17:40","2","2020-03-31 17:17:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:17:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7866","RENT","\u9810\u7e73\u79df\u91d1",1,698,"MO","1",698,"2","2020-03-31 17:17:40","2","2020-03-31 17:17:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:17:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7866","RENT","\u9810\u7e73\u79df\u91d1",2,698,"MO","1",698,"2","2020-03-31 17:17:40","2","2020-03-31 17:17:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:17:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7866","RENT","\u9810\u7e73\u79df\u91d1",3,698,"MO","1",698,"2","2020-03-31 17:17:40","2","2020-03-31 17:17:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:17:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7866","RENT","\u9810\u7e73\u79df\u91d1",4,698,"MO","1",698,"2","2020-03-31 17:17:40","2","2020-03-31 17:17:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:17:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7866","RENT","\u9810\u7e73\u79df\u91d1",5,698,"MO","1",698,"2","2020-03-31 17:17:40","2","2020-03-31 17:17:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:17:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7866","RENT","\u9810\u7e73\u79df\u91d1",6,698,"MO","1",698,"2","2020-03-31 17:17:40","2","2020-03-31 17:17:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:17:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7866","RENT","\u9810\u7e73\u79df\u91d1",7,698,"MO","1",698,"2","2020-03-31 17:17:40","2","2020-03-31 17:17:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:17:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7866","RENT","\u9810\u7e73\u79df\u91d1",8,698,"MO","1",698,"2","2020-03-31 17:17:40","2","2020-03-31 17:17:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:17:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7866","RENT","\u9810\u7e73\u79df\u91d1",9,698,"MO","1",698,"2","2020-03-31 17:17:40","2","2020-03-31 17:17:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:17:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7866","RENT","\u9810\u7e73\u79df\u91d1",10,698,"MO","1",698,"2","2020-03-31 17:17:40","2","2020-03-31 17:17:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:17:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7866","RENT","\u9810\u7e73\u79df\u91d1",11,698,"MO","1",698,"2","2020-03-31 17:17:40","2","2020-03-31 17:17:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:17:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7866","RENT","\u9810\u7e73\u79df\u91d1",12,698,"MO","1",698,"2","2020-03-31 17:17:40","2","2020-03-31 17:17:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:17:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8376,0,"7866"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-31 17:17:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[47,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207513","2020-03-31 17:17:40",8376,"2","2020-03-31 17:17:40","2","2020-03-31 17:17:40","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:17:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7513","DEPOSIT",null,"PAID","2020-03-31 17:17:40",0,"2","2020-03-31 17:17:40","2","2020-03-31 17:17:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-31 17:17:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7513","INVOICE","7866","PAID","2020-03-31 17:17:40",8376,"2","2020-03-31 17:17:40","2","2020-03-31 17:17:40"]},"data_before":[],"data_after":[],"step":1} *****