{"created_at":"2020-02-10 09:58:33","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":"all=1&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1191,"customer_code":"C191191","identity_type":"PERSONAL","identity_id":"M738692(9)","title":"Mr","lastname":"MAI","firstname":"Bosco Khoi","companyname":"","email":"bosco.mai@gmail.com","tel":"67614440","address":"Block A, Flat 15, Wah Lee Building, Tsung Man St. Aberdeen","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1098.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-01","renew_room_key":"089,00345","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 24, 2019. Storage deposit transferred from agreement A12-CT196615 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196777, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"5","room_code":"A05","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1098,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1098,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-01","rent_from":"2020-02-01","rent_to":"2020-02-29","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on February 8, 2020. Storage deposit transferred from agreement A12-CT196777 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1098,"final_order_total":1098,"location_id":"1","branch_id":"1","company_id":"1","room_key":"089,00345","order_product":[],"pass":true}},"first_order_id":"4686","selected_room_tr":"\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t

---

\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t

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

\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>
A05 <\/td>\r\n\t\t\t\t\t	4X4X8 <\/td>\r\n\t\t\t\t\t	$1098.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1098.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 09:58:33","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",1191,"NEW","A12-CT207148",1098,1098,0,0,"1","1",1098,1098,1098,"2020-02-10 09:58:33","0",null,null,null,"2020-02-01","2020-02-29","1 month contract. Storage rental paid by bank transfer on February 8, 2020. Storage deposit transferred from agreement A12-CT196777 to this agreement.","2020-02-01","16",0,null,0,"0","2","2020-02-10 09:58:33","2","2020-02-10 09:58:33","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"089,00345","C191191","PERSONAL","Mr","0soiKCD7NjJcZw48G3GvfA==","MvdRz7N0iNyy9YO2DdpHMA==","","NcpK5OrfF8\/ElyhXm5yH2xQ9zY+h9560LUlyXGmaKZfQ1gIMmhqC+OiOd\/MDfL7LWoyplf\/sWugxqiR3ggITpg==","1y6MGBuYIscSst\/RcREtDQ==","xaZ\/yoblidF8zejY4KpifA94CHlEn27CqR\/97lOoGjk=","wcyFUD6Pm8bwB7ut4Ratqg==",null,1,"4686"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 09:58:33","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":["7148","5","1098.0","1098.00","2","2020-02-10 09:58:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 09:58:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2020-02-29","5"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-10 09:58:33","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":["7148",1191,"SETTLED","A12-I207476","2020-02-10 09:58:33","2020-02-01","2","2020-02-10 09:58:33","2","2020-02-10 09:58:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 09:58:33","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":["7476","RENT","\u9810\u7e73\u79df\u91d1",1,1098,"MO","1",1098,"2","2020-02-10 09:58:33","2","2020-02-10 09:58:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 09:58:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1098,0,"7476"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-10 09:58:33","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":[1191,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207124","2020-02-10 09:58:33",1098,"2","2020-02-10 09:58:33","2","2020-02-10 09:58:33","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 09:58:33","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":["7124","DEPOSIT",null,"PAID","2020-02-10 09:58:33",0,"2","2020-02-10 09:58:33","2","2020-02-10 09:58:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 09:58:33","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":["7124","INVOICE","7476","PAID","2020-02-10 09:58:33",1098,"2","2020-02-10 09:58:33","2","2020-02-10 09:58:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 10:31:39","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":774,"customer_code":"C180774","identity_type":"PERSONAL","identity_id":"D426114(4)","title":"Ms","lastname":"Chan","firstname":"Yee Man Elaine","companyname":"","email":"elainechloe@hotmail.com","tel":"54080892","address":"Room 5, 10\/F, Block A, Yue Fai Court, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1106.0","renew_rent_month":"6","renew_warehousing_date":"2020-02-20","renew_room_key":"136,62628","renew_remark":"6 months contract. Storage rental paid by bank transfer on August 19, 2019. Storage deposit transferred from agreement A12-CT194418 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195766, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"359","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"359","room_code":"F44","retail_price":"1098.0","discounted_price":989,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1106,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6636,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-20","rent_from":"2020-02-20","rent_to":"2020-08-19","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on February 9, 2020. Storage deposit transferred from agreement A12-CT195766 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6636,"final_order_total":6636,"location_id":"1","branch_id":"1","company_id":"1","room_key":"136,62628","order_product":[],"pass":true}},"first_order_id":"4418","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> F44 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1106.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 10:31:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",774,"NEW","A12-CT207149",1098,1106,0,0,"6","6",6636,6636,6636,"2020-02-10 10:31:40","0",null,null,null,"2020-02-20","2020-08-19","6 months contract. Storage rental paid by bank transfer on February 9, 2020. Storage deposit transferred from agreement A12-CT195766 to this agreement.","2020-02-20","16",0,null,0,"0","2","2020-02-10 10:31:39","2","2020-02-10 10:31:39","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"136,62628","C180774","PERSONAL","Ms","E7qK9LvX0DaqVTJFwujStQ==","U9yoE9KqV1v8YlRkf7Q2yg==","","UFO75ZblfzMCVIMJVs2YkR62I+IgIjDBT6axQSGt0Y1Pw+zdx7PIvH3T2MmwzXMl1GcfnwzJooqB3JuInT5iRg==","LW2mX1ic1Uqb66UeyyY3Wg==","at5wZWO2rHOhq8ntT+F8r7vd+v6sSVh4KF3JZ3NBAEo=","I0l5p\/XVm4Exa3mM6SYXCA==",null,1,"4418"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 10:31:40","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":["7149","72","8","359","%","9.93",109.0314,"2","2020-02-10 10:31:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 10:31:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7149","359","1098.0",989,"2","2020-02-10 10:31:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 10:31:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-20","2020-08-19","359"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-10 10:31:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7149",774,"SETTLED","A12-I207477","2020-02-10 10:31:39","2020-02-20","2","2020-02-10 10:31:39","2","2020-02-10 10:31:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 10:31:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7477","RENT","\u9810\u7e73\u79df\u91d1",1,1106,"MO","1",1106,"2","2020-02-10 10:31:39","2","2020-02-10 10:31:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 10:31:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7477","RENT","\u9810\u7e73\u79df\u91d1",2,1106,"MO","1",1106,"2","2020-02-10 10:31:39","2","2020-02-10 10:31:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 10:31:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7477","RENT","\u9810\u7e73\u79df\u91d1",3,1106,"MO","1",1106,"2","2020-02-10 10:31:39","2","2020-02-10 10:31:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 10:31:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7477","RENT","\u9810\u7e73\u79df\u91d1",4,1106,"MO","1",1106,"2","2020-02-10 10:31:39","2","2020-02-10 10:31:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 10:31:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7477","RENT","\u9810\u7e73\u79df\u91d1",5,1106,"MO","1",1106,"2","2020-02-10 10:31:39","2","2020-02-10 10:31:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 10:31:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7477","RENT","\u9810\u7e73\u79df\u91d1",6,1106,"MO","1",1106,"2","2020-02-10 10:31:39","2","2020-02-10 10:31:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 10:31:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6636,0,"7477"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-10 10:31:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[774,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207125","2020-02-10 10:31:39",6636,"2","2020-02-10 10:31:39","2","2020-02-10 10:31:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 10:31:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7125","DEPOSIT",null,"PAID","2020-02-10 10:31:39",0,"2","2020-02-10 10:31:39","2","2020-02-10 10:31:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 10:31:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7125","INVOICE","7477","PAID","2020-02-10 10:31:39",6636,"2","2020-02-10 10:31:39","2","2020-02-10 10:31:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 10:46: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":"&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":881,"customer_code":"C180881","identity_type":"PERSONAL","identity_id":"K531352(A)","title":"Ms","lastname":"CHOY","firstname":"EUPHEMIA","companyname":"","email":"euphem@yahoo.com","tel":"92022175","address":"27\/F, Flat D, Block 16, South Horizons, Ap Lei Chau","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"814.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-27","renew_room_key":"0005921000","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 14, 2020. Storage deposit transferred from agreement A05-CT196755 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT206954, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"108","order_discount":[],"order_room":[{"room_id":"1034","room_code":"A05-032","retail_price":"1006.0","discounted_price":"1006.00","location_id":"4"}],"roughly_size":"9","total_retail_price":1006,"total_discounted_price":814,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":814,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-27","rent_from":"2020-01-27","rent_to":"2020-02-26","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on February 9, 2020. Storage deposit transferred from agreement A05-CT206954 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":814,"final_order_total":814,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0005921000","order_product":[],"pass":true}},"first_order_id":"4882","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-032 <\/td>\r\n\t\t\t\t\t 3X3X7 <\/td>\r\n\t\t\t\t\t $1006.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"9","total_discounted_price":"814.0","deposit":"0","total_retail_price":"1006.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 10:46:27","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",881,"NEW","A05-CT207150",1006,814,0,0,"1","1",814,814,814,"2020-02-10 10:46:27","0",null,null,null,"2020-01-27","2020-02-26","1 month contract. Storage rental paid by bank transfer on February 9, 2020. Storage deposit transferred from agreement A05-CT206954 to this agreement.\r\n","2020-01-27","9",0,null,0,"0","2","2020-02-10 10:46:26","2","2020-02-10 10:46:26","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005921000","C180881","PERSONAL","Ms","cgxXGJI\/ZTnh+WLA7hfGwg==","KHX1V\/o61A5lYN2Th2Ak\/Q==","","U8wra+WSnJl5LR7S5iiWZnnh338ln2lsz3xMjaQzmzZP4BCRoLcPkHMf26rmrqVZKqHoyISkO4JAVUv4wniBZg==","JgGxc0OPptFMBUC8eZGB8A==","cCZv0x8iMqg8yBlgEfmg12iFWmQM8Gc1m7ERyq86bXs=","uZ7Ygw5sLpeeqN2M2YKoJA==",null,1,"4882"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 10:46:27","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":["7150","1034","1006.0","1006.00","2","2020-02-10 10:46:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 10:46:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-27","2020-02-26","1034"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-10 10:46:27","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":["7150",881,"SETTLED","A05-I207478","2020-02-10 10:46:26","2020-01-27","2","2020-02-10 10:46:26","2","2020-02-10 10:46:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 10:46:27","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":["7478","RENT","\u9810\u7e73\u79df\u91d1",1,814,"MO","1",814,"2","2020-02-10 10:46:26","2","2020-02-10 10:46:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 10:46:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[814,0,"7478"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-10 10:46:27","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":[881,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207126","2020-02-10 10:46:26",814,"2","2020-02-10 10:46:26","2","2020-02-10 10:46:26","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 10:46:27","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":["7126","DEPOSIT",null,"PAID","2020-02-10 10:46:26",0,"2","2020-02-10 10:46:26","2","2020-02-10 10:46:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 10:46:27","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":["7126","INVOICE","7478","PAID","2020-02-10 10:46:26",814,"2","2020-02-10 10:46:26","2","2020-02-10 10:46:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 11:02:01","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 11:03:27","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":892,"customer_code":"C180892","identity_type":"PERSONAL","identity_id":"E849835(4)","title":"Ms","lastname":"Leung","firstname":"Lai Fan Celia","companyname":"","email":"cl89723@yahoo.com.hk","tel":"98301204","address":"Flat 23C, Block 7, Fullview Garden, Siu Sai Wan, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2170.0","renew_rent_month":"12","renew_warehousing_date":"2020-02-13","renew_room_key":"0005011944","renew_remark":" 12 months contract. Storage rental paid by Bank Transfer on 1 FEB 2019. Storage deposit $5,106 transferred from agreement B01-CT182652 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT194283, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"155","order_discount":[{"master_room_discount_id":"351","master_room_id":"155","discount_type":"%","price":"3058.00","disocunted_price":"1988.90","discount":"34.96","monthly_deduct":1069.0768,"room_id":"1264","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1264","room_code":"B01-074","retail_price":"3058.0","discounted_price":1988.9,"location_id":"5"}],"roughly_size":"54","total_retail_price":3058,"total_discounted_price":2170,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":26040,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-13","rent_from":"2020-02-13","rent_to":"2021-02-12","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on Feb 10,2020. Storage deposit $5,106 transferred from agreement B01-CT194283 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":26040,"final_order_total":26040,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0005011944","order_product":[],"pass":true}},"first_order_id":4283,"selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> B01-074 <\/td>\r\n\t\t\t\t\t 6X9X7 <\/td>\r\n\t\t\t\t\t $3058.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"54","total_discounted_price":"2170.0","deposit":"0","total_retail_price":"3058.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 11:03:28","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","2","5",892,"NEW","B01-CT207151",3058,2170,0,0,"12","12",26040,26040,26040,"2020-02-10 11:03:28","0",null,null,null,"2020-02-13","2021-02-12","12 months contract. Storage rental paid by bank transfer on Feb 10,2020. Storage deposit $5,106 transferred from agreement B01-CT194283 to this agreement.","2020-02-13","54",0,null,0,"0","2","2020-02-10 11:03:27","2","2020-02-10 11:03:27","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005011944","C180892","PERSONAL","Ms","gFD\/46B0Wdt4bcucJusUMA==","xEf2h2aoyRQ71ZVgBH+9WQ==","","Rg9YVaKRXLWPM7xyVsg9HKryIWwOJa9Jndo+w6fvpRZ5Wgkyd+kN5Uf0E33AZ8TN7JOW81gOaTcHqQxJjsXnsA==","hPBZFgd4MGbuZJeSrzcMqA==","PZrig2I\/0ldTQV4Mk\/RUr6PH1XYO9KPOND3J4jehWrw=","bfyzJGXX3jp9lsfoC7uv7Q==",null,1,4283]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 11:03:28","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":["7151","351","155","1264","%","34.96",1069.0768,"2","2020-02-10 11:03:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 11:03:28","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":["7151","1264","3058.0",1988.9,"2","2020-02-10 11:03:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 11:03:28","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-13","2021-02-12","1264"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-10 11:03:28","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":["7151",892,"SETTLED","B01-I207479","2020-02-10 11:03:27","2020-02-13","2","2020-02-10 11:03:27","2","2020-02-10 11:03:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 11:03:28","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":["7479","RENT","\u9810\u7e73\u79df\u91d1",1,2170,"MO","1",2170,"2","2020-02-10 11:03:27","2","2020-02-10 11:03:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 11:03:28","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":["7479","RENT","\u9810\u7e73\u79df\u91d1",2,2170,"MO","1",2170,"2","2020-02-10 11:03:27","2","2020-02-10 11:03:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 11:03:28","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":["7479","RENT","\u9810\u7e73\u79df\u91d1",3,2170,"MO","1",2170,"2","2020-02-10 11:03:27","2","2020-02-10 11:03:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 11:03:28","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":["7479","RENT","\u9810\u7e73\u79df\u91d1",4,2170,"MO","1",2170,"2","2020-02-10 11:03:27","2","2020-02-10 11:03:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 11:03:28","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":["7479","RENT","\u9810\u7e73\u79df\u91d1",5,2170,"MO","1",2170,"2","2020-02-10 11:03:27","2","2020-02-10 11:03:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 11:03:28","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":["7479","RENT","\u9810\u7e73\u79df\u91d1",6,2170,"MO","1",2170,"2","2020-02-10 11:03:27","2","2020-02-10 11:03:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 11:03:28","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":["7479","RENT","\u9810\u7e73\u79df\u91d1",7,2170,"MO","1",2170,"2","2020-02-10 11:03:27","2","2020-02-10 11:03:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 11:03:28","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":["7479","RENT","\u9810\u7e73\u79df\u91d1",8,2170,"MO","1",2170,"2","2020-02-10 11:03:27","2","2020-02-10 11:03:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 11:03:28","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":["7479","RENT","\u9810\u7e73\u79df\u91d1",9,2170,"MO","1",2170,"2","2020-02-10 11:03:27","2","2020-02-10 11:03:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 11:03:28","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":["7479","RENT","\u9810\u7e73\u79df\u91d1",10,2170,"MO","1",2170,"2","2020-02-10 11:03:27","2","2020-02-10 11:03:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 11:03:28","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":["7479","RENT","\u9810\u7e73\u79df\u91d1",11,2170,"MO","1",2170,"2","2020-02-10 11:03:27","2","2020-02-10 11:03:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 11:03:28","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":["7479","RENT","\u9810\u7e73\u79df\u91d1",12,2170,"MO","1",2170,"2","2020-02-10 11:03:27","2","2020-02-10 11:03:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 11:03:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[26040,0,"7479"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-10 11:03:28","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":[892,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207127","2020-02-10 11:03:27",26040,"2","2020-02-10 11:03:27","2","2020-02-10 11:03:27","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 11:03:28","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":["7127","DEPOSIT",null,"PAID","2020-02-10 11:03:27",0,"2","2020-02-10 11:03:27","2","2020-02-10 11:03:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 11:03:28","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":["7127","INVOICE","7479","PAID","2020-02-10 11:03:27",26040,"2","2020-02-10 11:03:27","2","2020-02-10 11:03:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 11:27:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 11:46:45","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 12:20:08","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","076, 32297","6 months contract. Special referral bonus $250. Referred by O01 Mr Leung Yue Chau. Storage rental and deposit paid by cheque on January 11, 2020. Smartcard and padlock provided on January 11, 2020.","2020-02-10 12:20:08","2","yXKc2lCF323ApRADrjNaSg==","MnXcL0b4p+eE4SuxYrBPGQ==","\/Iz+moYOjhs1xBpKff8ytQ==","5kixRt4Sm\/Mxyj3L\/f2YCOizAxjWbhd\/\/KvLYmyXAgU\/bclTaWWKXvZg4m4tmiuvpCz9DHywpa9N8HkS3+dPkw==",6929]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 12:20:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 14:41:33","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=822&filter3=undefined","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":707,"customer_code":"C180707","identity_type":"PERSONAL","identity_id":"XD664200(A)","title":"Mr","lastname":"Figueiras","firstname":"Julio Alberto","companyname":"","email":"scaljf@yahoo.com","tel":"90490864","address":"24B, Block 25, Baguio Villa, 555 Victoria Road, Pok Fu Lam, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2161.0","renew_rent_month":"1","renew_warehousing_date":"2019-11-08","renew_room_key":"055,02407","renew_remark":"1 month contract. Storage rental paid by bank transfer on Oct 14, 2019. Storage deposit transferred from agreement A18-CT195863 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196144, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"83","order_discount":[],"order_room":[{"room_id":"897","room_code":"Y26","retail_price":"2161.0","discounted_price":"2161.00","location_id":"3"}],"roughly_size":"28","total_retail_price":2161,"total_discounted_price":2161,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":6375,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"108.00","warehousing_date":"2019-11-08","rent_from":"2019-11-08","rent_to":"2020-02-07","delivery_service":"0","remark":"3 month contract. Storage rental paid by bank transfer on January 27, 2020. Storage deposit transferred from agreement A18-CT196144 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":108,"order_total":6483,"final_order_total":6375,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,02407","order_product":[],"pass":true}},"first_order_id":"4758","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> Y26 <\/td>\r\n\t\t\t\t\t 7X4X7 <\/td>\r\n\t\t\t\t\t $2161.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"28","total_discounted_price":"2161.00","deposit":"0.00","total_retail_price":"2161.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 14:41:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",707,"NEW","A18-CT207152",2161,2161,0,0,"3","3",6375,6483,6375,"2020-02-10 14:41:34","0",null,null,null,"2019-11-08","2020-02-07","3 month contract. Storage rental paid by bank transfer on January 27, 2020. Storage deposit transferred from agreement A18-CT196144 to this agreement.","2019-11-08","28",0,null,108,"108.00","2","2020-02-10 14:41:33","2","2020-02-10 14:41:33","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,02407","C180707","PERSONAL","Mr","SR2Z5I9sPVu5xacQHgTyIg==","9DTHDCdI0o\/83sM4ct1LPg==","","K5\/5N+Bn0vBxmk8zM4MdOaD5g\/ggASRq4gDh8rMA\/2x+pfaHe8CKVVwOGqDLCKD7DoW+N1f1zYdDvubF4CXfuQ6ylZO+RwDnmiiRHP0oIxI=","WRDWXos0JwYitaPzwd6RNg==","FyADBuQi8RzCieNDaLsYH5ya+4WM9cySJMcy8\/2CqiE=","WhxmmwJ+NlhISvFFctqMCA==",null,1,"4758"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 14:41:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7152","897","2161.0","2161.00","2","2020-02-10 14:41:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 14:41:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-11-08","2020-02-07","897"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-10 14:41:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7152",707,"SETTLED","A18-I207480","2020-02-10 14:41:33","2019-11-08","2","2020-02-10 14:41:33","2","2020-02-10 14:41:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 14:41:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7480","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,2053,"MO","1",2053,"2","2020-02-10 14:41:33","2","2020-02-10 14:41:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 14:41:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7480","RENT","\u9810\u7e73\u79df\u91d1",2,2161,"MO","1",2161,"2","2020-02-10 14:41:33","2","2020-02-10 14:41:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 14:41:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7480","RENT","\u9810\u7e73\u79df\u91d1",3,2161,"MO","1",2161,"2","2020-02-10 14:41:33","2","2020-02-10 14:41:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 14:41:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6375,0,"7480"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-10 14:41:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[707,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207128","2020-02-10 14:41:33",6375,"2","2020-02-10 14:41:33","2","2020-02-10 14:41:33","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 14:41:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7128","DEPOSIT",null,"PAID","2020-02-10 14:41:33",0,"2","2020-02-10 14:41:33","2","2020-02-10 14:41:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 14:41:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7128","INVOICE","7480","PAID","2020-02-10 14:41:33",6375,"2","2020-02-10 14:41:33","2","2020-02-10 14:41:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 16:42:34","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1386&filter3=undefined","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":950,"customer_code":"C180950","identity_type":"PERSONAL","identity_id":"M096081(6)","title":"Mr","lastname":"Vincelli","firstname":"Stefano","companyname":"","email":"sabiobra@hotmail.com","tel":"95652114","address":"35 Happy View Terrace, Happy Valley, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4116.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-03","renew_room_key":"076,29154","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 12, 2019. Storage deposit transferred from agreement A14-CT206829 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207120, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"58","order_discount":[],"order_room":[{"room_id":"417","room_code":"I08","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"424","room_code":"J06","retail_price":"2888.0","discounted_price":"2888.00","location_id":"2"}],"roughly_size":"56","total_retail_price":3986,"total_discounted_price":4116,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":4116,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-03","rent_from":"2020-02-03","rent_to":"2020-03-02","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on December 12, 2019. Storage deposit transferred from agreement A14-CT207120 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4116,"final_order_total":4116,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,29154","order_product":[],"pass":true}},"first_order_id":"4680","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> I08 <\/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> J06 <\/td>\r\n\t\t\t\t\t 5X8X8 <\/td>\r\n\t\t\t\t\t $2888.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \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":"56","total_discounted_price":"4116.0","deposit":"0","total_retail_price":"3986.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 16:42:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",950,"NEW","A14-CT207153",3986,4116,0,0,"1","1",4116,4116,4116,"2020-02-10 16:42:34","0",null,null,null,"2020-02-03","2020-03-02","1 month contract. Storage rental paid by bank transfer on December 12, 2019. Storage deposit transferred from agreement A14-CT207120 to this agreement.\r\n","2020-02-03","56",0,null,0,"0","2","2020-02-10 16:42:34","2","2020-02-10 16:42:34","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,29154","C180950","PERSONAL","Mr","kBtwICYFFgkwWiGlHlA7Vg==","J9AQQ+eusxRuMi9Uwswx2w==","","xpCmz6ayhnKM9CeubIeX46ST4OH8jL8leoh\/7rF5LKq0NI4lQzsUw3z+sKEaA2Q2","HMxniP6OLhRLykg\/y72g1w==","G2oqjsMfynuJ5hF7HR+cYPuapiwUrw6QQkLUvHZtFiE=","LjEwev8Vn2pWAe0zRvbXAw==",null,1,"4680"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 16:42:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7153","417","1098.0","1098.00","2","2020-02-10 16:42:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 16:42:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-03","2020-03-02","417"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-10 16:42:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7153","424","2888.0","2888.00","2","2020-02-10 16:42:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 16:42:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-03","2020-03-02","424"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-10 16:42:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7153",950,"SETTLED","A14-I207481","2020-02-10 16:42:34","2020-02-03","2","2020-02-10 16:42:34","2","2020-02-10 16:42:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 16:42:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7481","RENT","\u9810\u7e73\u79df\u91d1",1,4116,"MO","1",4116,"2","2020-02-10 16:42:34","2","2020-02-10 16:42:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 16:42:34","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4116,0,"7481"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-10 16:42:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[950,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207129","2020-02-10 16:42:34",4116,"2","2020-02-10 16:42:34","2","2020-02-10 16:42:34","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 16:42:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7129","DEPOSIT",null,"PAID","2020-02-10 16:42:34",0,"2","2020-02-10 16:42:34","2","2020-02-10 16:42:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 16:42:34","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7129","INVOICE","7481","PAID","2020-02-10 16:42:34",4116,"2","2020-02-10 16:42:34","2","2020-02-10 16:42:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 17:04:59","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=1386&filter3=undefined&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":679,"customer_code":"C180679","identity_type":"BUSINESS","identity_id":"30490025","title":"Ms","lastname":"Chan","firstname":"Doris","companyname":"Hemandas Industrial Ltd.","email":"dorischan@esc.com.hk","tel":"92896007","address":"Unit 2243, 22\/F, Yan's Tower, 25-27 Wong Chuk Hang Rd, Wong Chuk Hang, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2728.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-03","renew_room_key":"055,56887","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 9, 2020. Storage deposit transferred from agreement A18-CT196607 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT206915, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"82","order_discount":[],"order_room":[{"room_id":"859","room_code":"T03","retail_price":"2728.0","discounted_price":"2728.00","location_id":"3"}],"roughly_size":"36","total_retail_price":2728,"total_discounted_price":2728,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2728,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-03","rent_from":"2020-02-03","rent_to":"2020-03-02","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on February 10, 2020. Storage deposit transferred from agreement A18-CT206915 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2728,"final_order_total":2728,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,56887","order_product":[],"pass":true}},"first_order_id":"4697","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> T03 <\/td>\r\n\t\t\t\t\t 6X6X7 <\/td>\r\n\t\t\t\t\t $2728.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":"36","total_discounted_price":"2728.0","deposit":"0","total_retail_price":"2728.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 17:04:59","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",679,"NEW","A18-CT207154",2728,2728,0,0,"1","1",2728,2728,2728,"2020-02-10 17:04:59","0",null,null,null,"2020-02-03","2020-03-02","1 month contract. Storage rental paid by bank transfer on February 10, 2020. Storage deposit transferred from agreement A18-CT206915 to this agreement.\r\n","2020-02-03","36",0,null,0,"0","2","2020-02-10 17:04:59","2","2020-02-10 17:04:59","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,56887","C180679","BUSINESS","Ms","1p0+HSxbHlPSeHnKL1+MnA==","U9yoE9KqV1v8YlRkf7Q2yg==","Hemandas Industrial Ltd.","NNq9wxs1efEwHG+GfiDv3WoHFlyl2ik9vc5ha7eicfoFr48wfjXwEVDp3r5jjcxqeRyrZaz+NALvMBTiKSrb1OMQJpkhkNMPCpwd2zTkR61b7UwwjxTbA4OPPOLfvpDG","gMEFsGZs7+56GFUaxLbplg==","Um3+ktI0eYcw3estHH8TQKxSuSRl+2j3b4bDI46i5yg=",null,"UeK5wwtn5\/PTJNB6lM3obw==",1,"4697"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 17:04:59","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":["7154","859","2728.0","2728.00","2","2020-02-10 17:04:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 17:04:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-03","2020-03-02","859"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-10 17:04:59","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":["7154",679,"SETTLED","A18-I207482","2020-02-10 17:04:59","2020-02-03","2","2020-02-10 17:04:59","2","2020-02-10 17:04:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 17:04:59","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":["7482","RENT","\u9810\u7e73\u79df\u91d1",1,2728,"MO","1",2728,"2","2020-02-10 17:04:59","2","2020-02-10 17:04:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 17:04:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2728,0,"7482"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-10 17:04:59","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":[679,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207130","2020-02-10 17:04:59",2728,"2","2020-02-10 17:04:59","2","2020-02-10 17:04:59","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 17:04:59","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":["7130","DEPOSIT",null,"PAID","2020-02-10 17:04:59",0,"2","2020-02-10 17:04:59","2","2020-02-10 17:04:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 17:04:59","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":["7130","INVOICE","7482","PAID","2020-02-10 17:04:59",2728,"2","2020-02-10 17:04:59","2","2020-02-10 17:04:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 18:21:13","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"all=1","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":673,"customer_code":"C170673","identity_type":"PERSONAL","identity_id":"Y085423(7)","title":"Mr","lastname":"Li","firstname":"Pui Wing","companyname":"","email":"wing022090@hotmail.com","tel":"65002249","address":"Flat A, 6\/F. Albert House, 26 Cheng Tu Rd, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-01","renew_room_key":"054,58226,076,35816","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 10, 2019. Storage deposit transferred from agreement A14-CT196103 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196669, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"620","room_code":"M31","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":1794,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-01","rent_from":"2020-01-01","rent_to":"2020-03-31","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on February 10, 2020. Storage deposit transferred from agreement A14-CT196669 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1794,"final_order_total":1794,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,58226,076,35816","order_product":[],"pass":true}},"first_order_id":"4685","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> M31 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 18:21:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",673,"NEW","A14-CT207155",598,598,0,0,"3","3",1794,1794,1794,"2020-02-10 18:21:13","0",null,null,null,"2020-01-01","2020-03-31","3 months contract. Storage rental paid by bank transfer on February 10, 2020. Storage deposit transferred from agreement A14-CT196669 to this agreement.\r\n","2020-01-01","12",0,null,0,"0","2","2020-02-10 18:21:13","2","2020-02-10 18:21:13","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,58226,076,35816","C170673","PERSONAL","Mr","ITD2Z30msP76kNRsYAQJdA==","7KCehmxbvwRMb+U8lHGoVA==","","HdXbjSMvv+ZR14503QlGfIIJx53YwiSYo18C3zg2iAsoCVGYQ5WI8DdHfRG1zNaPWkGvmtKZhfECBhHRiUVkSg==","7i41GG+VMMQ0anZ5o5qU1A==","CYmwmTN8U9iiSrWcIU95bF9znWI7Bh\/wdBd3p1sJ\/Ew=","V8J6VCsbvmxznZr8ycizJA==",null,1,"4685"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 18:21:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7155","620","598.0","598.00","2","2020-02-10 18:21:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 18:21:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-01","2020-03-31","620"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-10 18:21:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7155",673,"SETTLED","A14-I207483","2020-02-10 18:21:13","2020-01-01","2","2020-02-10 18:21:13","2","2020-02-10 18:21:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 18:21:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7483","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-02-10 18:21:13","2","2020-02-10 18:21:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 18:21:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7483","RENT","\u9810\u7e73\u79df\u91d1",2,598,"MO","1",598,"2","2020-02-10 18:21:13","2","2020-02-10 18:21:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 18:21:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7483","RENT","\u9810\u7e73\u79df\u91d1",3,598,"MO","1",598,"2","2020-02-10 18:21:13","2","2020-02-10 18:21:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 18:21:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1794,0,"7483"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-10 18:21:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[673,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207131","2020-02-10 18:21:13",1794,"2","2020-02-10 18:21:13","2","2020-02-10 18:21:13","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 18:21:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7131","DEPOSIT",null,"PAID","2020-02-10 18:21:13",0,"2","2020-02-10 18:21:13","2","2020-02-10 18:21:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-10 18:21:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7131","INVOICE","7483","PAID","2020-02-10 18:21:13",1794,"2","2020-02-10 18:21:13","2","2020-02-10 18:21:13"]},"data_before":[],"data_after":[],"step":1} *****