{"created_at":"2020-04-07 10:08:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:34:42","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"type=INVOICE&filter1=0&filter2=982&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":263,"customer_code":"C170263","identity_type":"PERSONAL","identity_id":"D704585(A)","title":"Mr","lastname":"Leung","firstname":"Man Kai","companyname":"","email":"hellomkhk@yahoo.com.hk","tel":"97352237","address":"Flat 5, 27\/F, BLK A, Yue Fai Court","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2318.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-06","renew_room_key":"054,00997","renew_remark":"1 month contract. Storage rental paid by bank transfer on March 11, 2020. Storage deposit transferred from agreement A12-CT207111 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207373, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"32","room_code":"A32","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"},{"room_id":"31","room_code":"A31","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":2318,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":4636,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-06","rent_from":"2020-03-06","rent_to":"2020-05-05","delivery_service":"0","remark":"2 months contract. Storage rental paid by bank transfer on April 6, 2020. Storage deposit transferred from agreement A12-CT207373 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4636,"final_order_total":4636,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,00997","order_product":[],"pass":true}},"first_order_id":"4781","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>
A32 <\/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>
A31 <\/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":"32","total_discounted_price":"2318.00","deposit":"0.00","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:34:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",263,"NEW","A12-CT207574",2196,2318,0,0,"2","2",4636,4636,4636,"2020-04-07 10:34:42","0",null,null,null,"2020-03-06","2020-05-05","2 months contract. Storage rental paid by bank transfer on April 6, 2020. Storage deposit transferred from agreement A12-CT207373 to this agreement.\r\n","2020-03-06","32",0,null,0,"0","2","2020-04-07 10:34:42","2","2020-04-07 10:34:42","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,00997","C170263","PERSONAL","Mr","nRvnQbLeZEN7gUr1x\/8GHQ==","xEf2h2aoyRQ71ZVgBH+9WQ==","","aQak8hG9FmECD+\/o3qbqPw48j8cKpXf13a9FHWLZJj3a8gSxqyhYsUtF0aVccmhO","k9yvnbmpfXW5Z3ZwhLsQZQ==","p65IBdT2ZCL5fh+ct7VZ+jkIQMQs\/mV6AeDzTTgXcsg=","2lzZZ98xqcDCMYSbgaPj3g==",null,1,"4781"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:34:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7574","32","1098.0","1098.00","2","2020-04-07 10:34:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:34:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-06","2020-05-05","32"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-07 10:34:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7574","31","1098.0","1098.00","2","2020-04-07 10:34:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:34:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-06","2020-05-05","31"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-07 10:34:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7574",263,"SETTLED","A12-I207902","2020-04-07 10:34:42","2020-03-06","2","2020-04-07 10:34:42","2","2020-04-07 10:34:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:34:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7902","RENT","\u9810\u7e73\u79df\u91d1",1,2318,"MO","1",2318,"2","2020-04-07 10:34:42","2","2020-04-07 10:34:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:34:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7902","RENT","\u9810\u7e73\u79df\u91d1",2,2318,"MO","1",2318,"2","2020-04-07 10:34:42","2","2020-04-07 10:34:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:34:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4636,0,"7902"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-07 10:34:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[263,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207549","2020-04-07 10:34:42",4636,"2","2020-04-07 10:34:42","2","2020-04-07 10:34:42","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:34:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7549","DEPOSIT",null,"PAID","2020-04-07 10:34:42",0,"2","2020-04-07 10:34:42","2","2020-04-07 10:34:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:34:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7549","INVOICE","7902","PAID","2020-04-07 10:34:42",4636,"2","2020-04-07 10:34:42","2","2020-04-07 10:34:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:36:15","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"type=INVOICE&filter1=0&filter2=982&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1220,"customer_code":"C191220","identity_type":"PERSONAL","identity_id":"R119900(4)","title":"Mr","lastname":"LEUNG","firstname":"Wai Hung","companyname":"","email":null,"tel":"59386116","address":"\u65b0\u754c\u5c6f\u9580\u5927\u8208\u82b1\u57121\u671f2\u5ea79\u6a13G\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1228.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-06","renew_room_key":"054,00997","renew_remark":"1 month contract. Storage rental paid by bank transfer on March 11, 2020. Storage deposit transferred from agreement A12-CT207112 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207374, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"149","room_code":"C25","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1228,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":2456,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-06","rent_from":"2020-03-06","rent_to":"2020-05-05","delivery_service":"0","remark":"2 months contract. Storage rental paid by bank transfer on April 6, 2020. Storage deposit transferred from agreement A12-CT207374 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2456,"final_order_total":2456,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,00997","order_product":[],"pass":true}},"first_order_id":"4572","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> C25 <\/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":"1228.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:36:15","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",1220,"NEW","A12-CT207575",1098,1228,0,0,"2","2",2456,2456,2456,"2020-04-07 10:36:15","0",null,null,null,"2020-03-06","2020-05-05","2 months contract. Storage rental paid by bank transfer on April 6, 2020. Storage deposit transferred from agreement A12-CT207374 to this agreement.","2020-03-06","16",0,null,0,"0","2","2020-04-07 10:36:15","2","2020-04-07 10:36:15","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,00997","C191220","PERSONAL","Mr","Vy30hO8KRRcWAyFHMj+GkQ==","yXKc2lCF323ApRADrjNaSg==","","kB3ZkLOEsqrfGlmYGehYoS1RHUa4+htDrEhnq1OyQOZf8ydcmD1ve7Z29T4bDE82","UuUIwTJb9gH2x8g8+PEtTA==",null,"dhuboonMisA+jeGDyP70SA==",null,1,"4572"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:36:15","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":["7575","149","1098.0","1098.00","2","2020-04-07 10:36:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:36:15","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-06","2020-05-05","149"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-07 10:36:15","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":["7575",1220,"SETTLED","A12-I207903","2020-04-07 10:36:15","2020-03-06","2","2020-04-07 10:36:15","2","2020-04-07 10:36:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:36:15","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":["7903","RENT","\u9810\u7e73\u79df\u91d1",1,1228,"MO","1",1228,"2","2020-04-07 10:36:15","2","2020-04-07 10:36:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:36:15","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":["7903","RENT","\u9810\u7e73\u79df\u91d1",2,1228,"MO","1",1228,"2","2020-04-07 10:36:15","2","2020-04-07 10:36:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:36:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2456,0,"7903"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-07 10:36:15","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":[1220,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207550","2020-04-07 10:36:15",2456,"2","2020-04-07 10:36:15","2","2020-04-07 10:36:15","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:36:15","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":["7550","DEPOSIT",null,"PAID","2020-04-07 10:36:15",0,"2","2020-04-07 10:36:15","2","2020-04-07 10:36:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:36:15","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":["7550","INVOICE","7903","PAID","2020-04-07 10:36:15",2456,"2","2020-04-07 10:36:15","2","2020-04-07 10:36:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:37: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":"type=INVOICE&filter1=0&filter2=982&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":263,"customer_code":"C170263","identity_type":"PERSONAL","identity_id":"D704585(A)","title":"Mr","lastname":"Leung","firstname":"Man Kai","companyname":"","email":"hellomkhk@yahoo.com.hk","tel":"97352237","address":"Flat 5, 27\/F, BLK A, Yue Fai Court","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-03-04","renew_room_key":"054,00997","renew_remark":"1 month contract. Storage rental paid by bank transfer on March 11, 2020. Storage deposit transferred from agreement A14-CT207113 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207375, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"688","room_code":"N05","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":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":1196,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-04","rent_from":"2020-03-04","rent_to":"2020-05-03","delivery_service":"0","remark":"2 months contract. Storage rental paid by bank transfer on April 6, 2020. Storage deposit transferred from agreement A14-CT207375 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1196,"final_order_total":1196,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,00997","order_product":[],"pass":true}},"first_order_id":"4783","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> N05 <\/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-04-07 10:38:00","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",263,"NEW","A14-CT207576",598,598,0,0,"2","2",1196,1196,1196,"2020-04-07 10:38:00","0",null,null,null,"2020-03-04","2020-05-03","2 months contract. Storage rental paid by bank transfer on April 6, 2020. Storage deposit transferred from agreement A14-CT207375 to this agreement.\r\n","2020-03-04","12",0,null,0,"0","2","2020-04-07 10:37:59","2","2020-04-07 10:37:59","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,00997","C170263","PERSONAL","Mr","nRvnQbLeZEN7gUr1x\/8GHQ==","xEf2h2aoyRQ71ZVgBH+9WQ==","","aQak8hG9FmECD+\/o3qbqPw48j8cKpXf13a9FHWLZJj3a8gSxqyhYsUtF0aVccmhO","k9yvnbmpfXW5Z3ZwhLsQZQ==","p65IBdT2ZCL5fh+ct7VZ+jkIQMQs\/mV6AeDzTTgXcsg=","2lzZZ98xqcDCMYSbgaPj3g==",null,1,"4783"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:38:00","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":["7576","688","598.0","598.00","2","2020-04-07 10:37:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:38:00","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-04","2020-05-03","688"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-07 10:38:00","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":["7576",263,"SETTLED","A14-I207904","2020-04-07 10:37:59","2020-03-04","2","2020-04-07 10:37:59","2","2020-04-07 10:37:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:38:00","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":["7904","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-04-07 10:37:59","2","2020-04-07 10:37:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:38:00","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":["7904","RENT","\u9810\u7e73\u79df\u91d1",2,598,"MO","1",598,"2","2020-04-07 10:37:59","2","2020-04-07 10:37:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:38:00","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1196,0,"7904"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-07 10:38:00","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":[263,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207551","2020-04-07 10:37:59",1196,"2","2020-04-07 10:37:59","2","2020-04-07 10:37:59","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:38:00","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":["7551","DEPOSIT",null,"PAID","2020-04-07 10:37:59",0,"2","2020-04-07 10:37:59","2","2020-04-07 10:37:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:38:00","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":["7551","INVOICE","7904","PAID","2020-04-07 10:37:59",1196,"2","2020-04-07 10:37:59","2","2020-04-07 10:37:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:41:53","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"type=INVOICE&filter1=0&filter2=982&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","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":263,"customer_code":"C170263","identity_type":"PERSONAL","identity_id":"D704585(A)","title":"Mr","lastname":"Leung","firstname":"Man Kai","companyname":"","email":"hellomkhk@yahoo.com.hk","tel":"97352237","address":"Flat 5, 27\/F, BLK A, Yue Fai Court","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"998.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-08","renew_room_key":"054,00997","renew_remark":"1 month contract. Storage rental paid by bank transfer on March 11, 2020. Storage deposit transferred from agreement A14-CT207114 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207376, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"736","room_code":"O12","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":1996,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-08","rent_from":"2020-03-08","rent_to":"2020-05-07","delivery_service":"0","remark":"2 months contract. Storage rental paid by bank transfer on April 6, 2020. Storage deposit transferred from agreement A14-CT207376 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1996,"final_order_total":1996,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,00997","order_product":[],"pass":true}},"first_order_id":"4784","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> O12 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"998.00","deposit":"0.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:41:54","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",263,"NEW","A14-CT207577",998,998,0,0,"2","2",1996,1996,1996,"2020-04-07 10:41:54","0",null,null,null,"2020-03-08","2020-05-07","2 months contract. Storage rental paid by bank transfer on April 6, 2020. Storage deposit transferred from agreement A14-CT207376 to this agreement.\r\n","2020-03-08","12",0,null,0,"0","2","2020-04-07 10:41:53","2","2020-04-07 10:41:53","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,00997","C170263","PERSONAL","Mr","nRvnQbLeZEN7gUr1x\/8GHQ==","xEf2h2aoyRQ71ZVgBH+9WQ==","","aQak8hG9FmECD+\/o3qbqPw48j8cKpXf13a9FHWLZJj3a8gSxqyhYsUtF0aVccmhO","k9yvnbmpfXW5Z3ZwhLsQZQ==","p65IBdT2ZCL5fh+ct7VZ+jkIQMQs\/mV6AeDzTTgXcsg=","2lzZZ98xqcDCMYSbgaPj3g==",null,1,"4784"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:41:54","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":["7577","736","998.0","998.00","2","2020-04-07 10:41:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:41:54","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-08","2020-05-07","736"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-07 10:41:54","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":["7577",263,"SETTLED","A14-I207905","2020-04-07 10:41:53","2020-03-08","2","2020-04-07 10:41:53","2","2020-04-07 10:41:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:41:54","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":["7905","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-04-07 10:41:53","2","2020-04-07 10:41:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:41:54","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":["7905","RENT","\u9810\u7e73\u79df\u91d1",2,998,"MO","1",998,"2","2020-04-07 10:41:53","2","2020-04-07 10:41:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:41:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1996,0,"7905"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-07 10:41:54","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":[263,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207552","2020-04-07 10:41:53",1996,"2","2020-04-07 10:41:53","2","2020-04-07 10:41:53","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:41:54","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":["7552","DEPOSIT",null,"PAID","2020-04-07 10:41:53",0,"2","2020-04-07 10:41:53","2","2020-04-07 10:41:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:41:54","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":["7552","INVOICE","7905","PAID","2020-04-07 10:41:53",1996,"2","2020-04-07 10:41:53","2","2020-04-07 10:41:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:44:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:51: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=145&filter3=undefined&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1120,"customer_code":"C181120","identity_type":"PERSONAL","identity_id":"K990796(3)","title":"Ms","lastname":"Lim","firstname":"Ngai Ying","companyname":"","email":"tclimny@yahoo.com.hk","tel":"98653330","address":"20A, Block A, Monticello, 48 Kennedy Road, Wanchai, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1226.0","renew_rent_month":"3","renew_warehousing_date":"2020-02-29","renew_room_key":"0012401482","renew_remark":"3 months contract. Storage rental paid bank transfer on February 1, 2020. Storage deposit $2580 transferred from agreement A05-CT183734 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT207107, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"114","order_discount":[{"master_room_discount_id":"249","master_room_id":"114","discount_type":"%","price":"1290.00","disocunted_price":"1225.90","discount":"4.97","monthly_deduct":64.113,"room_id":"1019","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1019","room_code":"A05-017","retail_price":"1290.0","discounted_price":1225.9,"location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1226,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3678,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-29","rent_from":"2020-02-29","rent_to":"2020-05-28","delivery_service":"0","remark":"3 months contract. Storage rental paid bank transfer on April 1, 2020. Storage deposit $2580 transferred from agreement A05-CT207107 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3678,"final_order_total":3678,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012401482","order_product":[],"pass":true}},"first_order_id":"3734","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-017 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1226.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:51:48","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",1120,"NEW","A05-CT207578",1290,1226,0,0,"3","3",3678,3678,3678,"2020-04-07 10:51:48","0",null,null,null,"2020-02-29","2020-05-28","3 months contract. Storage rental paid bank transfer on April 1, 2020. Storage deposit $2580 transferred from agreement A05-CT207107 to this agreement. \r\n","2020-02-29","16",0,null,0,"0","2","2020-04-07 10:51:48","2","2020-04-07 10:51:48","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012401482","C181120","PERSONAL","Ms","nJGhBNHWOLtL64ual1FhFA==","WCEL8nEjkO0P1E7kTUoqkQ==","","Qr1SRqR2X49jk0j2hOhWiFEhOjiP14+1A6nt0Q0YK90cJMi6SRuNinj4hXfIri5qKfbQkbzl6w8BEFYfdt7b2g==","EgxkBPCBSIsAmJIjePUbYw==","Q7UrH7ZgViNFwAsZWBfCI\/D5dHSSButouyQRgnceP3w=","8JmQh3i8+8LWkp6AFiAV7A==",null,1,"3734"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:51:48","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":["7578","249","114","1019","%","4.97",64.113,"2","2020-04-07 10:51:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:51:48","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":["7578","1019","1290.0",1225.9,"2","2020-04-07 10:51:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:51:48","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-29","2020-05-28","1019"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-07 10:51:48","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":["7578",1120,"SETTLED","A05-I207906","2020-04-07 10:51:48","2020-02-29","2","2020-04-07 10:51:48","2","2020-04-07 10:51:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:51:48","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":["7906","RENT","\u9810\u7e73\u79df\u91d1",1,1226,"MO","1",1226,"2","2020-04-07 10:51:48","2","2020-04-07 10:51:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:51:48","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":["7906","RENT","\u9810\u7e73\u79df\u91d1",2,1226,"MO","1",1226,"2","2020-04-07 10:51:48","2","2020-04-07 10:51:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:51:48","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":["7906","RENT","\u9810\u7e73\u79df\u91d1",3,1226,"MO","1",1226,"2","2020-04-07 10:51:48","2","2020-04-07 10:51:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:51:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3678,0,"7906"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-07 10:51:48","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":[1120,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207553","2020-04-07 10:51:48",3678,"2","2020-04-07 10:51:48","2","2020-04-07 10:51:48","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:51:48","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":["7553","DEPOSIT",null,"PAID","2020-04-07 10:51:48",0,"2","2020-04-07 10:51:48","2","2020-04-07 10:51:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 10:51:48","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":["7553","INVOICE","7906","PAID","2020-04-07 10:51:48",3678,"2","2020-04-07 10:51:48","2","2020-04-07 10:51:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 11:53:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 11:53:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 14:51: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=2&filter2=145&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":561,"customer_code":"C170561","identity_type":"PERSONAL","identity_id":"E820695(7)","title":"Ms","lastname":"Wong","firstname":"Siu Ling Marina","companyname":"","email":"marinachow123@gmail.com","tel":"91869062","address":"\u9d28\u8137\u6d32\u6d77\u6021\u534a\u5cf610\u5ea720\u6a13F\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","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-06","renew_room_key":"054,50812","renew_remark":"6 months contract. Storage rental paid by bank transfer on October 15, 2019. Storage deposit transferred from agreement A12-CT194710 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196240, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.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":"245","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"245","room_code":"D49","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-06","rent_from":"2020-04-06","rent_to":"2020-10-05","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on April 7, 2020. Storage deposit transferred from agreement A12-CT196240 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5394,"final_order_total":5394,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,50812","order_product":[],"pass":true}},"first_order_id":"4710","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> D49 <\/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-04-07 14:51:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",561,"NEW","A12-CT207579",998,899,0,0,"6","6",5394,5394,5394,"2020-04-07 14:51:18","0",null,null,null,"2020-04-06","2020-10-05","6 months contract. Storage rental paid by bank transfer on April 7, 2020. Storage deposit transferred from agreement A12-CT196240 to this agreement.\r\n","2020-04-06","12",0,null,0,"0","2","2020-04-07 14:51:17","2","2020-04-07 14:51:17","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,50812","C170561","PERSONAL","Ms","UmJh9AbJdy6zsynnx+CySA==","hULSwM2MvFtpeV9\/z+er8Q==","","xztHH5TbzA5tZa+5WtBZHaU1ciLyBiPUHPTI6hQdhtIIMxvu7IadU8BdO21mGFoT","XlvQEE\/W+vFQiTpby05Izw==","pm7CkDvOkUxqOHAHnFRi50XYRG8jwXaBb4OEvcB0zik=","YLwHD+2Fd0GTY4YWTvIC3Q==",null,1,"4710"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 14:51:18","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":["7579","70","6","245","%","9.96",99.4008,"2","2020-04-07 14:51:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 14:51:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7579","245","998.0",898.6,"2","2020-04-07 14:51:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 14:51:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-06","2020-10-05","245"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-07 14:51:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7579",561,"SETTLED","A12-I207907","2020-04-07 14:51:17","2020-04-06","2","2020-04-07 14:51:17","2","2020-04-07 14:51:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 14:51:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7907","RENT","\u9810\u7e73\u79df\u91d1",1,899,"MO","1",899,"2","2020-04-07 14:51:17","2","2020-04-07 14:51:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 14:51:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7907","RENT","\u9810\u7e73\u79df\u91d1",2,899,"MO","1",899,"2","2020-04-07 14:51:17","2","2020-04-07 14:51:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 14:51:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7907","RENT","\u9810\u7e73\u79df\u91d1",3,899,"MO","1",899,"2","2020-04-07 14:51:17","2","2020-04-07 14:51:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 14:51:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7907","RENT","\u9810\u7e73\u79df\u91d1",4,899,"MO","1",899,"2","2020-04-07 14:51:17","2","2020-04-07 14:51:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 14:51:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7907","RENT","\u9810\u7e73\u79df\u91d1",5,899,"MO","1",899,"2","2020-04-07 14:51:17","2","2020-04-07 14:51:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 14:51:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7907","RENT","\u9810\u7e73\u79df\u91d1",6,899,"MO","1",899,"2","2020-04-07 14:51:17","2","2020-04-07 14:51:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 14:51:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5394,0,"7907"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-07 14:51:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[561,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207554","2020-04-07 14:51:17",5394,"2","2020-04-07 14:51:17","2","2020-04-07 14:51:17","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 14:51:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7554","DEPOSIT",null,"PAID","2020-04-07 14:51:17",0,"2","2020-04-07 14:51:17","2","2020-04-07 14:51:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 14:51:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7554","INVOICE","7907","PAID","2020-04-07 14:51:17",5394,"2","2020-04-07 14:51:17","2","2020-04-07 14:51:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 15:27:48","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 16:57:31","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"type=INVOICE&filter1=0&filter2=982&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":445,"customer_code":"C170445","identity_type":"PERSONAL","identity_id":"K738319(3)","title":"Mr","lastname":"Sin","firstname":"Dai Chuen Sunny","companyname":"","email":"sindaichuen@netvigator.com","tel":"93632429","address":"\u9999\u6e2f\u4ed4\u4e2d\u5fc3K\u5ea7\u6d77\u6676\u95a313\u6a134\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1198.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-10","renew_room_key":"054,60440","renew_remark":"1 month contract. Storage rental paid by bank transfer on March 7,2020. Storage deposit transferred from agreement A14-CT207145 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207347, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"70","order_discount":[],"order_room":[{"room_id":"722","room_code":"N39","retail_price":"1318.0","discounted_price":"1318.00","location_id":"2"}],"roughly_size":"18","total_retail_price":1318,"total_discounted_price":1198,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1198,"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 bank transfer on April 7,2020. Storage deposit transferred from agreement A14-CT207347 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1198,"final_order_total":1198,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,60440","order_product":[],"pass":true}},"first_order_id":"4712","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> N39 <\/td>\r\n\t\t\t\t\t 3X6X8 <\/td>\r\n\t\t\t\t\t $1318.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":"18","total_discounted_price":"1198.0","deposit":"0","total_retail_price":"1318.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 16:57:31","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",445,"NEW","A14-CT207580",1318,1198,0,0,"1","1",1198,1198,1198,"2020-04-07 16:57:31","0",null,null,null,"2020-04-10","2020-05-09","1 month contract. Storage rental paid by bank transfer on April 7,2020. Storage deposit transferred from agreement A14-CT207347 to this agreement.","2020-04-10","18",0,null,0,"0","2","2020-04-07 16:57:31","2","2020-04-07 16:57:31","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,60440","C170445","PERSONAL","Mr","9L2K7wn1Opvr3WQ4vJABDA==","995YTEe316mZ2NiY\/8o00g==","","mvDoTgHRyEEzx3aiSCEV4DxQZHD5YYGgvyNzPm1QCr\/nAPIFPb3QfWTpiQPnxKX2","QrHnF9IXwKZ9qN6l8eYD5g==","A+zYSJpoRkceQYWowNFQUv3ec39gnccN6z82YnuKfNw=","d5o++GGoW7Lf\/yZcJ7PGQw==",null,1,"4712"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 16:57:31","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":["7580","722","1318.0","1318.00","2","2020-04-07 16:57:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 16:57:31","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","722"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-07 16:57:31","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":["7580",445,"SETTLED","A14-I207908","2020-04-07 16:57:31","2020-04-10","2","2020-04-07 16:57:31","2","2020-04-07 16:57:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 16:57:31","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":["7908","RENT","\u9810\u7e73\u79df\u91d1",1,1198,"MO","1",1198,"2","2020-04-07 16:57:31","2","2020-04-07 16:57:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 16:57:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1198,0,"7908"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-07 16:57:31","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":[445,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207555","2020-04-07 16:57:31",1198,"2","2020-04-07 16:57:31","2","2020-04-07 16:57:31","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 16:57:31","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":["7555","DEPOSIT",null,"PAID","2020-04-07 16:57:31",0,"2","2020-04-07 16:57:31","2","2020-04-07 16:57:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 16:57:31","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":["7555","INVOICE","7908","PAID","2020-04-07 16:57:31",1198,"2","2020-04-07 16:57:31","2","2020-04-07 16:57:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 17:42:12","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":990,"customer_code":"C180990","identity_type":"PERSONAL","identity_id":"D383352(7)","title":"Mr","lastname":"Wong","firstname":"Wah Chak William","companyname":"","email":"wahchakwong@yahoo.com.hk","tel":"97826638","address":"Flt 30, 7\/F Chun Tak Hse, Lung Tak Court, 52 Cape Road, Stanley. HK","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1511.0","renew_rent_month":"12","renew_warehousing_date":"2020-04-15","renew_room_key":"0012491589","renew_remark":"12 month contract. Special renewal offer 1 month free. Storage rental paid by Cheque on April 12, 2019. Storage deposit transferred from agreement C15-CT183277 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT194741, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"174","order_discount":[],"order_room":[{"room_id":"1479","room_code":"C15-173","retail_price":"1678.0","discounted_price":"1678.00","location_id":"6"}],"roughly_size":"28","total_retail_price":1678,"total_discounted_price":1511,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":18132,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-15","rent_from":"2020-04-15","rent_to":"2021-04-14","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on Apr 07,2020. Storage deposit transferred from agreement C15-CT194741 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":18132,"final_order_total":18132,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012491589","order_product":[],"pass":true}},"first_order_id":4741,"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-173 <\/td>\r\n\t\t\t\t\t 4X7X6.5 <\/td>\r\n\t\t\t\t\t $1678.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":"28","total_discounted_price":"1511.0","deposit":"0","total_retail_price":"1678.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 17:42:12","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",990,"NEW","C15-CT207581",1678,1511,0,0,"12","12",18132,18132,18132,"2020-04-07 17:42:12","0",null,null,null,"2020-04-15","2021-04-14","12 months contract. Storage rental paid by bank transfer on Apr 07,2020. Storage deposit transferred from agreement C15-CT194741 to this agreement.","2020-04-15","28",0,null,0,"0","2","2020-04-07 17:42:12","2","2020-04-07 17:42:12","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012491589","C180990","PERSONAL","Mr","Lg4gDisiPu9XB4rIWAv2SO2CKFF6eFodTC9epVx8zAY=","hULSwM2MvFtpeV9\/z+er8Q==","","M7FmrjLZsKvgYn1vBCFSaRZ3CHXacdCHhz\/Xosd6K4WhgkP\/RJP98zy+KVfJGltT5A2iNjMja1nY8tKa660YltdaLMYdrS398HzFPzHP9KA=","jllZh8GcNSpS5sq8a16+lQ==","OErNiC+zqMy663Zzw89ivWNjHBphEr\/OhUy68\/WgC7o=","VIdCq9pvJl3JtXLm8AlfvQ==",null,1,4741]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 17:42:12","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":["7581","1479","1678.0","1678.00","2","2020-04-07 17:42:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 17:42:12","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-15","2021-04-14","1479"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-07 17:42:12","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":["7581",990,"SETTLED","C15-I207909","2020-04-07 17:42:12","2020-04-15","2","2020-04-07 17:42:12","2","2020-04-07 17:42:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 17:42:12","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":["7909","RENT","\u9810\u7e73\u79df\u91d1",1,1511,"MO","1",1511,"2","2020-04-07 17:42:12","2","2020-04-07 17:42:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 17:42:12","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":["7909","RENT","\u9810\u7e73\u79df\u91d1",2,1511,"MO","1",1511,"2","2020-04-07 17:42:12","2","2020-04-07 17:42:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 17:42:12","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":["7909","RENT","\u9810\u7e73\u79df\u91d1",3,1511,"MO","1",1511,"2","2020-04-07 17:42:12","2","2020-04-07 17:42:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 17:42:12","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":["7909","RENT","\u9810\u7e73\u79df\u91d1",4,1511,"MO","1",1511,"2","2020-04-07 17:42:12","2","2020-04-07 17:42:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 17:42:12","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":["7909","RENT","\u9810\u7e73\u79df\u91d1",5,1511,"MO","1",1511,"2","2020-04-07 17:42:12","2","2020-04-07 17:42:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 17:42:12","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":["7909","RENT","\u9810\u7e73\u79df\u91d1",6,1511,"MO","1",1511,"2","2020-04-07 17:42:12","2","2020-04-07 17:42:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 17:42:12","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":["7909","RENT","\u9810\u7e73\u79df\u91d1",7,1511,"MO","1",1511,"2","2020-04-07 17:42:12","2","2020-04-07 17:42:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 17:42:12","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":["7909","RENT","\u9810\u7e73\u79df\u91d1",8,1511,"MO","1",1511,"2","2020-04-07 17:42:12","2","2020-04-07 17:42:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 17:42:12","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":["7909","RENT","\u9810\u7e73\u79df\u91d1",9,1511,"MO","1",1511,"2","2020-04-07 17:42:12","2","2020-04-07 17:42:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 17:42:12","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":["7909","RENT","\u9810\u7e73\u79df\u91d1",10,1511,"MO","1",1511,"2","2020-04-07 17:42:12","2","2020-04-07 17:42:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 17:42:12","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":["7909","RENT","\u9810\u7e73\u79df\u91d1",11,1511,"MO","1",1511,"2","2020-04-07 17:42:12","2","2020-04-07 17:42:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 17:42:12","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":["7909","RENT","\u9810\u7e73\u79df\u91d1",12,1511,"MO","1",1511,"2","2020-04-07 17:42:12","2","2020-04-07 17:42:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 17:42:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[18132,0,"7909"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-07 17:42:12","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":[990,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207556","2020-04-07 17:42:12",18132,"2","2020-04-07 17:42:12","2","2020-04-07 17:42:12","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 17:42:12","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":["7556","DEPOSIT",null,"PAID","2020-04-07 17:42:12",0,"2","2020-04-07 17:42:12","2","2020-04-07 17:42:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 17:42:12","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":["7556","INVOICE","7909","PAID","2020-04-07 17:42:12",18132,"2","2020-04-07 17:42:12","2","2020-04-07 17:42:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-07 19:08:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****