{"created_at":"2020-02-05 10:03:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:06: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":"&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":733,"customer_code":"C180733","identity_type":"PERSONAL","identity_id":"G011129(4)","title":"Ms","lastname":"Kan","firstname":"Yim Ngan","companyname":"","email":"nellykan1128@yahoo.com.hk","tel":"94324063","address":"Rm 1613, Pik Long House, Shek Pai Wan Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1058.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-20","renew_room_key":"054,42661","renew_remark":"1 months contract. Storage rental $1058 paid by bank transfer on Jan 02,2020. Outstanding $2 for agreement A18-CT196424. Storage deposit $2096 transferred from agreement A18-CT196678 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT206827, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"101","order_discount":[],"order_room":[{"room_id":"935","room_code":"V09(\u670d\u88dd\u5009)","retail_price":"1058.0","discounted_price":"1058.00","location_id":"3"}],"roughly_size":"9.6","total_retail_price":1058,"total_discounted_price":1058,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1058,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-20","rent_from":"2019-12-20","rent_to":"2020-01-19","delivery_service":"0","remark":"1 months contract. Storage rental $1058 paid by bank transfer on February 4,2020. Storage deposit $2096 transferred from agreement A18-CT206827 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1058,"final_order_total":1058,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,42661","order_product":[],"pass":true}},"first_order_id":"4514","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>
V09(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t	4X2.4X7 <\/td>\r\n\t\t\t\t\t	$1058.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.6","total_discounted_price":"1058.0","deposit":"0","total_retail_price":"1058.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:06: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","3",733,"NEW","A18-CT207110",1058,1058,0,0,"1","1",1058,1058,1058,"2020-02-05 10:06:13","0",null,null,null,"2019-12-20","2020-01-19","1 months contract. Storage rental $1058 paid by bank transfer on February 4,2020. Storage deposit $2096 transferred from agreement A18-CT206827 to this agreement.","2019-12-20","9.6",0,null,0,"0","2","2020-02-05 10:06:13","2","2020-02-05 10:06:13","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,42661","C180733","PERSONAL","Ms","LuCmhx4vLIS+I2VRpkOJLw==","Oy7M11y4AYbqdsYthumGaw==","","pRevwfLH+V5p27KCzHhjJiFoLF+7KutuihUJaWarNVLL+Cfse1AKI58Qyx0LsGyvf51+AcKXq58wG9PBXHPRg8q+MOpswflvPznmtJYPHOM=","j+g19UGqLxVDE6Ev1Ki78g==","0QRC7C\/A8YfDBYxJnv35JgsmKRHtg1WHgToRbTKF+0Q=","\/4aTFzkJ3TQsDPebIexQkQ==",null,1,"4514"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:06: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":["7110","935","1058.0","1058.00","2","2020-02-05 10:06:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:06: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":["2019-12-20","2020-01-19","935"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-05 10:06: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":["7110",733,"SETTLED","A18-I207438","2020-02-05 10:06:13","2019-12-20","2","2020-02-05 10:06:13","2","2020-02-05 10:06:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:06: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":["7438","RENT","\u9810\u7e73\u79df\u91d1",1,1058,"MO","1",1058,"2","2020-02-05 10:06:13","2","2020-02-05 10:06:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:06:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1058,0,"7438"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-05 10:06: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":[733,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207086","2020-02-05 10:06:13",1058,"2","2020-02-05 10:06:13","2","2020-02-05 10:06:13","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:06: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":["7086","DEPOSIT",null,"PAID","2020-02-05 10:06:13",0,"2","2020-02-05 10:06:13","2","2020-02-05 10:06:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:06: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":["7086","INVOICE","7438","PAID","2020-02-05 10:06:13",1058,"2","2020-02-05 10:06:13","2","2020-02-05 10:06:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:09:03","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"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-01-06","renew_room_key":"054,00997","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 17, 2019. Storage deposit transferred from agreement A12-CT196406 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196715, \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":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2318,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-06","rent_from":"2020-01-06","rent_to":"2020-02-05","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on February 4, 2020. Storage deposit transferred from agreement A12-CT196715 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2318,"final_order_total":2318,"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.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:09:04","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-CT207111",2196,2318,0,0,"1","1",2318,2318,2318,"2020-02-05 10:09:04","0",null,null,null,"2020-01-06","2020-02-05","1 month contract. Storage rental paid by bank transfer on February 4, 2020. Storage deposit transferred from agreement A12-CT196715 to this agreement.","2020-01-06","32",0,null,0,"0","2","2020-02-05 10:09:03","2","2020-02-05 10:09:03","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-02-05 10:09:04","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":["7111","32","1098.0","1098.00","2","2020-02-05 10:09:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:09:04","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-06","2020-02-05","32"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-05 10:09:04","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":["7111","31","1098.0","1098.00","2","2020-02-05 10:09:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:09:04","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-06","2020-02-05","31"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-05 10:09:04","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":["7111",263,"SETTLED","A12-I207439","2020-02-05 10:09:03","2020-01-06","2","2020-02-05 10:09:03","2","2020-02-05 10:09:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:09:04","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":["7439","RENT","\u9810\u7e73\u79df\u91d1",1,2318,"MO","1",2318,"2","2020-02-05 10:09:03","2","2020-02-05 10:09:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:09:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2318,0,"7439"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-05 10:09:04","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","P207087","2020-02-05 10:09:03",2318,"2","2020-02-05 10:09:03","2","2020-02-05 10:09:03","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:09:04","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":["7087","DEPOSIT",null,"PAID","2020-02-05 10:09:03",0,"2","2020-02-05 10:09:03","2","2020-02-05 10:09:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:09:04","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":["7087","INVOICE","7439","PAID","2020-02-05 10:09:03",2318,"2","2020-02-05 10:09:03","2","2020-02-05 10:09:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:10:29","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1220,"customer_code":"C191220","identity_type":"PERSONAL","identity_id":"Z024485(7)","title":"Mr","lastname":"TSANG","firstname":"Wai Hang","companyname":"","email":null,"tel":"63937108","address":"Room K, 1\/F, Blk 2, Harmony 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":"1228.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-06","renew_room_key":"054,00997","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 17, 2019. Storage deposit transferred from agreement A12-CT196407 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196716, \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":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-06","rent_from":"2020-01-06","rent_to":"2020-02-05","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on February 4, 2020. Storage deposit transferred from agreement A12-CT196716 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1228,"final_order_total":1228,"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.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:10:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",1220,"NEW","A12-CT207112",1098,1228,0,0,"1","1",1228,1228,1228,"2020-02-05 10:10:29","0",null,null,null,"2020-01-06","2020-02-05","1 month contract. Storage rental paid by bank transfer on February 4, 2020. Storage deposit transferred from agreement A12-CT196716 to this agreement.","2020-01-06","16",0,null,0,"0","2","2020-02-05 10:10:29","2","2020-02-05 10:10:29","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,00997","C191220","PERSONAL","Mr","ovFd6oXHMscYazWfsL42IQ==","CQSkiYI47zpAX0jM\/inYfQ==","","tNsYAtswVgIwRrnefohYHwqW0\/qT7EFi\/n034QAND88omd7DZqoDYRrjLqyU8SiOBPBLrQHBbi3iORo8Yd6vjw==","oAlpDeafBj+l77mjY6qR2A==",null,"Z\/Uc2OSsjoza5npRKlVrJw==",null,1,"4572"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:10:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7112","149","1098.0","1098.00","2","2020-02-05 10:10:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:10:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-06","2020-02-05","149"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-05 10:10:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7112",1220,"SETTLED","A12-I207440","2020-02-05 10:10:29","2020-01-06","2","2020-02-05 10:10:29","2","2020-02-05 10:10:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:10:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7440","RENT","\u9810\u7e73\u79df\u91d1",1,1228,"MO","1",1228,"2","2020-02-05 10:10:29","2","2020-02-05 10:10:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:10:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1228,0,"7440"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-05 10:10:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1220,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207088","2020-02-05 10:10:29",1228,"2","2020-02-05 10:10:29","2","2020-02-05 10:10:29","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:10:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7088","DEPOSIT",null,"PAID","2020-02-05 10:10:29",0,"2","2020-02-05 10:10:29","2","2020-02-05 10:10:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:10:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7088","INVOICE","7440","PAID","2020-02-05 10:10:29",1228,"2","2020-02-05 10:10:29","2","2020-02-05 10:10:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:12:02","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"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-01-04","renew_room_key":"054,00997","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 17, 2019. Storage deposit transferred from agreement A14-CT196408 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196717, \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":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-04","rent_from":"2020-01-04","rent_to":"2020-02-03","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on February 4, 2020. Storage deposit transferred from agreement A14-CT196717 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"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.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:12:02","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-CT207113",598,598,0,0,"1","1",598,598,598,"2020-02-05 10:12:02","0",null,null,null,"2020-01-04","2020-02-03","1 month contract. Storage rental paid by bank transfer on February 4, 2020. Storage deposit transferred from agreement A14-CT196717 to this agreement.","2020-01-04","12",0,null,0,"0","2","2020-02-05 10:12:01","2","2020-02-05 10:12:01","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-02-05 10:12:02","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":["7113","688","598.0","598.00","2","2020-02-05 10:12:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:12:02","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-04","2020-02-03","688"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-05 10:12:02","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":["7113",263,"SETTLED","A14-I207441","2020-02-05 10:12:01","2020-01-04","2","2020-02-05 10:12:01","2","2020-02-05 10:12:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:12:02","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":["7441","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-02-05 10:12:01","2","2020-02-05 10:12:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:12:02","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7441"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-05 10:12:02","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","P207089","2020-02-05 10:12:01",598,"2","2020-02-05 10:12:01","2","2020-02-05 10:12:01","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:12:02","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":["7089","DEPOSIT",null,"PAID","2020-02-05 10:12:01",0,"2","2020-02-05 10:12:01","2","2020-02-05 10:12:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:12:02","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":["7089","INVOICE","7441","PAID","2020-02-05 10:12:01",598,"2","2020-02-05 10:12:01","2","2020-02-05 10:12:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:14:20","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"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-01-08","renew_room_key":"054,00997","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 17, 2019. Storage deposit transferred from agreement A14-CT196409 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196718, \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":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":998,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-08","rent_from":"2020-01-08","rent_to":"2020-02-07","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on February 4, 2020. Storage deposit transferred from agreement A14-CT196718 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":998,"final_order_total":998,"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.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:14:21","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-CT207114",998,998,0,0,"1","1",998,998,998,"2020-02-05 10:14:21","0",null,null,null,"2020-01-08","2020-02-07","1 month contract. Storage rental paid by bank transfer on February 4, 2020. Storage deposit transferred from agreement A14-CT196718 to this agreement.","2020-01-08","12",0,null,0,"0","2","2020-02-05 10:14:20","2","2020-02-05 10:14:20","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-02-05 10:14:21","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":["7114","736","998.0","998.00","2","2020-02-05 10:14:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:14:21","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-08","2020-02-07","736"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-05 10:14:21","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":["7114",263,"SETTLED","A14-I207442","2020-02-05 10:14:20","2020-01-08","2","2020-02-05 10:14:20","2","2020-02-05 10:14:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:14:21","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":["7442","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-02-05 10:14:20","2","2020-02-05 10:14:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:14:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"7442"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-05 10:14:21","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","P207090","2020-02-05 10:14:20",998,"2","2020-02-05 10:14:20","2","2020-02-05 10:14:20","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:14:21","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":["7090","DEPOSIT",null,"PAID","2020-02-05 10:14:20",0,"2","2020-02-05 10:14:20","2","2020-02-05 10:14:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 10:14:21","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":["7090","INVOICE","7442","PAID","2020-02-05 10:14:20",998,"2","2020-02-05 10:14:20","2","2020-02-05 10:14:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 12:54: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":"filter1=1&filter2=1180&filter3=undefined","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1178,"customer_code":"C191178","identity_type":"PERSONAL","identity_id":"D387772(9)","title":"Ms","lastname":"LAI","firstname":"YUK LING","companyname":"","email":null,"tel":"90782828","address":"\u67f4\u6e7e\u8208\u83ef\u90a8\u7f8e\u83ef\u697c3414\u5ba4","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"729.0","renew_rent_month":"12","renew_warehousing_date":"2020-01-28","renew_room_key":"0012385392","renew_remark":"12 months contract. Storage rental and deposit paid by Cash on 15 JAN 2019. Smart card provided on 15 JAN 2019.Free of Smart Card.Fee of 2 months\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT194160, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $810.0","renew_master_room_id":"167","order_discount":[],"order_room":[{"room_id":"1358","room_code":"C15-052","retail_price":"810.0","discounted_price":"810.00","location_id":"6"}],"roughly_size":"12","total_retail_price":810,"total_discounted_price":729,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":8748,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-28","rent_from":"2020-01-28","rent_to":"2021-01-27","delivery_service":"0","remark":"12 months contract. Storage rental paid by cheque on February 5, 2020. Storage deposit $810 transferred from agreement C15-CT194160 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":8748,"final_order_total":8748,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012385392","order_product":[],"pass":true}},"first_order_id":4160,"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-052 <\/td>\r\n\t\t\t\t\t 4X3X6.5 <\/td>\r\n\t\t\t\t\t $810.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\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":"729.0","deposit":"0","total_retail_price":"810.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 12:54: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","3","6",1178,"NEW","C15-CT207115",810,729,0,0,"12","12",8748,8748,8748,"2020-02-05 12:54:42","0",null,null,null,"2020-01-28","2021-01-27","12 months contract. Storage rental paid by cheque on February 5, 2020. Storage deposit $810 transferred from agreement C15-CT194160 to this agreement. \r\n","2020-01-28","12",0,null,0,"0","2","2020-02-05 12:54:42","2","2020-02-05 12:54:42","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"0012385392","C191178","PERSONAL","Ms","6cgjK\/1tyud8mot3yxuaCg==","8hiEOuVVoOMleTEBdtujcw==","","acsvCdWTVHYZjdqeJVE2mquLBy5qwf9hpUR2HRMPzz4=","o2hkneVnlzmtfmS6vE+7Gw==",null,"GUEa\/CRCHSWbafLQKW0kRw==",null,1,4160]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 12:54: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":["7115","1358","810.0","810.00","2","2020-02-05 12:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 12:54: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-01-28","2021-01-27","1358"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-05 12:54: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":["7115",1178,"SETTLED","C15-I207443","2020-02-05 12:54:42","2020-01-28","2","2020-02-05 12:54:42","2","2020-02-05 12:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 12:54: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":["7443","RENT","\u9810\u7e73\u79df\u91d1",1,729,"MO","1",729,"2","2020-02-05 12:54:42","2","2020-02-05 12:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 12:54: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":["7443","RENT","\u9810\u7e73\u79df\u91d1",2,729,"MO","1",729,"2","2020-02-05 12:54:42","2","2020-02-05 12:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 12:54: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":["7443","RENT","\u9810\u7e73\u79df\u91d1",3,729,"MO","1",729,"2","2020-02-05 12:54:42","2","2020-02-05 12:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 12:54: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":["7443","RENT","\u9810\u7e73\u79df\u91d1",4,729,"MO","1",729,"2","2020-02-05 12:54:42","2","2020-02-05 12:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 12:54: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":["7443","RENT","\u9810\u7e73\u79df\u91d1",5,729,"MO","1",729,"2","2020-02-05 12:54:42","2","2020-02-05 12:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 12:54: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":["7443","RENT","\u9810\u7e73\u79df\u91d1",6,729,"MO","1",729,"2","2020-02-05 12:54:42","2","2020-02-05 12:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 12:54: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":["7443","RENT","\u9810\u7e73\u79df\u91d1",7,729,"MO","1",729,"2","2020-02-05 12:54:42","2","2020-02-05 12:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 12:54: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":["7443","RENT","\u9810\u7e73\u79df\u91d1",8,729,"MO","1",729,"2","2020-02-05 12:54:42","2","2020-02-05 12:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 12:54: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":["7443","RENT","\u9810\u7e73\u79df\u91d1",9,729,"MO","1",729,"2","2020-02-05 12:54:42","2","2020-02-05 12:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 12:54: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":["7443","RENT","\u9810\u7e73\u79df\u91d1",10,729,"MO","1",729,"2","2020-02-05 12:54:42","2","2020-02-05 12:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 12:54: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":["7443","RENT","\u9810\u7e73\u79df\u91d1",11,729,"MO","1",729,"2","2020-02-05 12:54:42","2","2020-02-05 12:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 12:54: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":["7443","RENT","\u9810\u7e73\u79df\u91d1",12,729,"MO","1",729,"2","2020-02-05 12:54:42","2","2020-02-05 12:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 12:54:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8748,0,"7443"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-05 12:54: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":[1178,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207091","2020-02-05 12:54:42",8748,"2","2020-02-05 12:54:42","2","2020-02-05 12:54:42","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 12:54: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":["7091","DEPOSIT",null,"PAID","2020-02-05 12:54:42",0,"2","2020-02-05 12:54:42","2","2020-02-05 12:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 12:54: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":["7091","INVOICE","7443","PAID","2020-02-05 12:54:42",8748,"2","2020-02-05 12:54:42","2","2020-02-05 12:54:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 13:20:13","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1180&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1180,"customer_code":"C191180","identity_type":"BUSINESS","identity_id":"33720463-000-06-18-2","title":"Mr","lastname":"MR. MAK","firstname":" ","companyname":"EAST METALS H.K. LIMITED","email":null,"tel":"94323836","address":"East Metals (H.K.) Limited 1805, Block B, Villa Lotto, 18 Broadwood Road, Happy Valley, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1161.0","renew_rent_month":"12","renew_warehousing_date":"2020-02-01","renew_room_key":"0012522842","renew_remark":"12 months contract. Special promotion offered, 2 months free of charge. Storage rental and deposit paid by Cheque on 18 JAN 2019. Smartcard provided on 18 JAN 2019. \u514d\u667a\u80fd\u9580\u5361\u548c\u5009\u9396\u5319\\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT194198, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2976.0","renew_master_room_id":"143","order_discount":[{"master_room_discount_id":"344","master_room_id":"143","discount_type":"%","price":"1488.00","disocunted_price":"967.90","discount":"34.95","monthly_deduct":520.056,"room_id":"1215","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1215","room_code":"B01-025","retail_price":"1488.0","discounted_price":967.9,"location_id":"5"}],"roughly_size":"24","total_retail_price":1488,"total_discounted_price":1161,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":12771,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1161.00","warehousing_date":"2020-02-01","rent_from":"2020-02-01","rent_to":"2021-01-31","delivery_service":"0","remark":"12 months contract. Special promotion offered, 1 month free. Storage rental paid by Cheque on February 5, 2020. Storage deposit $2976 transferred from agreement B01-CT194198 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":1161,"order_total":13932,"final_order_total":12771,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0012522842","order_product":[],"pass":true}},"first_order_id":4198,"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-025 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1488.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":"24","total_discounted_price":"1161.0","deposit":"0","total_retail_price":"1488.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 13:20: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","2","5",1180,"NEW","B01-CT207116",1488,1161,0,0,"12","12",12771,13932,12771,"2020-02-05 13:20:13","0",null,null,null,"2020-02-01","2021-01-31","12 months contract. Special promotion offered, 1 month free. Storage rental paid by Cheque on February 5, 2020. Storage deposit $2976 transferred from agreement B01-CT194198 to this agreement. \r\n","2020-02-01","24",0,null,1161,"1161.00","2","2020-02-05 13:20:13","2","2020-02-05 13:20:13","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"0012522842","C191180","BUSINESS","Mr","CoUYtq1h8\/G9hWhlx0TFKA==","+OMw4na84noO2Yxlmuy2lA==","EAST METALS H.K. LIMITED","USpHHXGlS2J\/LZVBAz1s86eFQLcse6x4tnjah35SssQRcfJkeXeqCx4DXjZpItPM8MVA4adQh7Tp4simTQOC4s2dM2yU35sRrOdkmUPQwuktNDFmOlkc9\/8mNmRXcawdBq5nIRVL7QviJf9K2RhlVQ==","jb9ffJd82Zr8xLw5JHXmyQ==",null,null,"qi1hSnDOXBTNgLTsNJVBdF70m9YFMsm5B5A\/dxqvsgs=",1,4198]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 13:20:13","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":["7116","344","143","1215","%","34.95",520.056,"2","2020-02-05 13:20:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 13:20: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":["7116","1215","1488.0",967.9,"2","2020-02-05 13:20:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 13:20:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-01","2021-01-31","1215"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-05 13:20: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":["7116",1180,"SETTLED","B01-I207444","2020-02-05 13:20:13","2020-02-01","2","2020-02-05 13:20:13","2","2020-02-05 13:20:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 13:20: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":["7444","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1161,"MO","1",1161,"2","2020-02-05 13:20:13","2","2020-02-05 13:20:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 13:20: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":["7444","RENT","\u9810\u7e73\u79df\u91d1",3,1161,"MO","1",1161,"2","2020-02-05 13:20:13","2","2020-02-05 13:20:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 13:20: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":["7444","RENT","\u9810\u7e73\u79df\u91d1",4,1161,"MO","1",1161,"2","2020-02-05 13:20:13","2","2020-02-05 13:20:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 13:20: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":["7444","RENT","\u9810\u7e73\u79df\u91d1",5,1161,"MO","1",1161,"2","2020-02-05 13:20:13","2","2020-02-05 13:20:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 13:20: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":["7444","RENT","\u9810\u7e73\u79df\u91d1",6,1161,"MO","1",1161,"2","2020-02-05 13:20:13","2","2020-02-05 13:20:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 13:20: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":["7444","RENT","\u9810\u7e73\u79df\u91d1",7,1161,"MO","1",1161,"2","2020-02-05 13:20:13","2","2020-02-05 13:20:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 13:20: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":["7444","RENT","\u9810\u7e73\u79df\u91d1",8,1161,"MO","1",1161,"2","2020-02-05 13:20:13","2","2020-02-05 13:20:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 13:20: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":["7444","RENT","\u9810\u7e73\u79df\u91d1",9,1161,"MO","1",1161,"2","2020-02-05 13:20:13","2","2020-02-05 13:20:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 13:20: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":["7444","RENT","\u9810\u7e73\u79df\u91d1",10,1161,"MO","1",1161,"2","2020-02-05 13:20:13","2","2020-02-05 13:20:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 13:20: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":["7444","RENT","\u9810\u7e73\u79df\u91d1",11,1161,"MO","1",1161,"2","2020-02-05 13:20:13","2","2020-02-05 13:20:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 13:20: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":["7444","RENT","\u9810\u7e73\u79df\u91d1",12,1161,"MO","1",1161,"2","2020-02-05 13:20:13","2","2020-02-05 13:20:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 13:20:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[12771,0,"7444"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-05 13:20: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":[1180,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207092","2020-02-05 13:20:13",12771,"2","2020-02-05 13:20:13","2","2020-02-05 13:20:13","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 13:20: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":["7092","DEPOSIT",null,"PAID","2020-02-05 13:20:13",0,"2","2020-02-05 13:20:13","2","2020-02-05 13:20:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 13:20: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":["7092","INVOICE","7444","PAID","2020-02-05 13:20:13",12771,"2","2020-02-05 13:20:13","2","2020-02-05 13:20:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 13:52:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 15:47:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 16:34:50","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=790&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":144,"customer_code":"C160144","identity_type":"PERSONAL","identity_id":"K507522(A)","title":"Ms","lastname":"Li","firstname":"Sui Fun","companyname":"","email":"fun1822@yahoo.com.hk","tel":"98439626","address":"\u9999\u6e2f\u9d28\u8137\u6d32\u5927\u885725\u81f331\u865f21\u6a13C\u5ba4","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"568.0","renew_rent_month":"3","renew_warehousing_date":"2020-02-05","renew_room_key":"190.62095","renew_remark":"3 months contract. Special price $568\/mth and special offer $500 coupon. Storage rental and deposit paid by EPS on Oct 19,2019. Smartcard and padlock provided on Oct 19,2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT196186, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1336.0","renew_master_room_id":"200","order_discount":[],"order_room":[{"room_id":"1616","room_code":"A16-125","retail_price":"668.0","discounted_price":"668.00","location_id":"7"}],"roughly_size":"12","total_retail_price":668,"total_discounted_price":568,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":1704,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-05","rent_from":"2020-02-05","rent_to":"2020-05-04","delivery_service":"0","remark":"3 months contract. Special price $568\/mth. Storage rental paid by bank transfer on February 5, 2020. Storage deposit $1336 transferred from agreement A16-CT196186 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1704,"final_order_total":1704,"location_id":"7","branch_id":"1","company_id":"1","room_key":"190.62095","order_product":[],"pass":true}},"first_order_id":6186,"selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A16-125 <\/td>\r\n\t\t\t\t\t 4X3X3.5 <\/td>\r\n\t\t\t\t\t $668.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"568.0","deposit":"0","total_retail_price":"668.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 16:34:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","7",144,"NEW","A16-CT207117",668,568,0,0,"3","3",1704,1704,1704,"2020-02-05 16:34:51","0",null,null,null,"2020-02-05","2020-05-04","3 months contract. Special price $568\/mth. Storage rental paid by bank transfer on February 5, 2020. Storage deposit $1336 transferred from agreement A16-CT196186 to this agreement. \r\n","2020-02-05","12",0,null,0,"0","2","2020-02-05 16:34:50","2","2020-02-05 16:34:50","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190.62095","C160144","PERSONAL","Ms","NxYEwDa2SVUNtmZ7dPBuRA==","7KCehmxbvwRMb+U8lHGoVA==","","9sE7+exGq8Ow29Gw2EAuRJA4mmc+1uezYkiuIO440EH06wvaiykS7J1smlLN9c3H","J9KL\/+eXCgUVH2qD0NEeSA==","8MTxTI3MVhNHjLnNzEu6J1lo006wo9tWXdlnFhOAJs8=","egTZsJjvVbZENoVq8znvxg==",null,1,6186]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 16:34:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7117","1616","668.0","668.00","2","2020-02-05 16:34:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 16:34:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-05","2020-05-04","1616"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-05 16:34:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7117",144,"SETTLED","A16-I207445","2020-02-05 16:34:50","2020-02-05","2","2020-02-05 16:34:50","2","2020-02-05 16:34:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 16:34:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7445","RENT","\u9810\u7e73\u79df\u91d1",1,568,"MO","1",568,"2","2020-02-05 16:34:50","2","2020-02-05 16:34:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 16:34:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7445","RENT","\u9810\u7e73\u79df\u91d1",2,568,"MO","1",568,"2","2020-02-05 16:34:50","2","2020-02-05 16:34:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 16:34:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7445","RENT","\u9810\u7e73\u79df\u91d1",3,568,"MO","1",568,"2","2020-02-05 16:34:50","2","2020-02-05 16:34:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 16:34:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1704,0,"7445"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-05 16:34:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[144,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207093","2020-02-05 16:34:50",1704,"2","2020-02-05 16:34:50","2","2020-02-05 16:34:50","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 16:34:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7093","DEPOSIT",null,"PAID","2020-02-05 16:34:50",0,"2","2020-02-05 16:34:50","2","2020-02-05 16:34:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 16:34:51","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7093","INVOICE","7445","PAID","2020-02-05 16:34:50",1704,"2","2020-02-05 16:34:50","2","2020-02-05 16:34:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 17:21:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 17:26:40","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=790&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":888,"customer_code":"C180888","identity_type":"PERSONAL","identity_id":"K099955(5)","title":"Ms","lastname":"Ho","firstname":"Man Yee Cherie","companyname":"","email":"cheriehmy@gmail.com","tel":"90575456","address":"Flat A, 1\/F, Block 9, Fullview Garden, 18 Siu Sai Wan Road, Siu Sai Wan, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1488.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-06","renew_room_key":"0005763937","renew_remark":"1 month contract. Storage rental paid by PPS on January 6, 2020. Storage deposit $2976 transferred from agreement B01-CT196633 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT206903, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"143","order_discount":[],"order_room":[{"room_id":"1274","room_code":"B01-084","retail_price":"1488.0","discounted_price":"1488.00","location_id":"5"}],"roughly_size":"24","total_retail_price":1488,"total_discounted_price":1488,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1488,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-06","rent_from":"2020-02-06","rent_to":"2020-03-05","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on February 4, 2020. Storage deposit $2976 transferred from agreement B01-CT206903 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1488,"final_order_total":1488,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0005763937","order_product":[],"pass":true}},"first_order_id":"4797","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-084 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1488.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":"24","total_discounted_price":"1488.0","deposit":"0","total_retail_price":"1488.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 17:26:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","2","5",888,"NEW","B01-CT207118",1488,1488,0,0,"1","1",1488,1488,1488,"2020-02-05 17:26:41","0",null,null,null,"2020-02-06","2020-03-05","1 month contract. Storage rental paid by PPS on February 4, 2020. Storage deposit $2976 transferred from agreement B01-CT206903 to this agreement.\r\n","2020-02-06","24",0,null,0,"0","2","2020-02-05 17:26:40","2","2020-02-05 17:26:40","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0005763937","C180888","PERSONAL","Ms","B6XcmzmDA9cWki+qLStEaA==","D\/skxQ5s\/L5yyRWaDK\/iSg==","","zb+wEJU2BcjiqagYCnyRNQzS3jTcz1KQCkGgLWtY\/y+C8KU+srfsdCNTrRUrjSHTpRbkV0JFumXQh3K4klaHUNKIaPzoQH6Ro1qQAUtDwWHyil1VPuPOWLDOdLKNt30K","Mv9sZMBZUVgbHGVZIxyZfQ==","d8Ms1Ternr8fasYV7yyV8x0bubUdhthIhbdOyphH3tQ=","b0wVwk81Vh1dF13X\/TkOaw==",null,1,"4797"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 17:26:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7118","1274","1488.0","1488.00","2","2020-02-05 17:26:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 17:26:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-06","2020-03-05","1274"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-05 17:26:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7118",888,"SETTLED","B01-I207446","2020-02-05 17:26:40","2020-02-06","2","2020-02-05 17:26:40","2","2020-02-05 17:26:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 17:26:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7446","RENT","\u9810\u7e73\u79df\u91d1",1,1488,"MO","1",1488,"2","2020-02-05 17:26:40","2","2020-02-05 17:26:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 17:26:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1488,0,"7446"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-05 17:26:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[888,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207094","2020-02-05 17:26:40",1488,"2","2020-02-05 17:26:40","2","2020-02-05 17:26:40","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 17:26:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7094","DEPOSIT",null,"PAID","2020-02-05 17:26:40",0,"2","2020-02-05 17:26:40","2","2020-02-05 17:26:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 17:26:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7094","INVOICE","7446","PAID","2020-02-05 17:26:40",1488,"2","2020-02-05 17:26:40","2","2020-02-05 17:26:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 17:31:28","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=790&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1168,"customer_code":"C191168","identity_type":"PERSONAL","identity_id":"D531931(6)","title":"Ms","lastname":"Tam","firstname":"Siu Ngun","companyname":"","email":"doristam3@gmail.com","tel":"94757199","address":"22E, Block 11, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1247.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-05","renew_room_key":"0012490559,0012490690","renew_remark":"6 months contract. Storage rental paid by bank transfer on August 3, 2019. Storage deposit $2768 transferred from agreement A05-CT194097 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT195634, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"125","order_discount":[{"master_room_discount_id":"283","master_room_id":"125","discount_type":"%","price":"1384.00","disocunted_price":"1245.60","discount":"10.00","monthly_deduct":138.4,"room_id":"1043","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1043","room_code":"A05-041","retail_price":"1384.0","discounted_price":1245.6,"location_id":"4"}],"roughly_size":"18","total_retail_price":1384,"total_discounted_price":1247,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":7482,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-05","rent_from":"2020-01-05","rent_to":"2020-07-04","delivery_service":"0","remark":"6 months contract. Storage rental paid by PPS on February 4, 2020. Storage deposit $2768 transferred from agreement A05-CT195634 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":7482,"final_order_total":7482,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012490559,0012490690","order_product":[],"pass":true}},"first_order_id":"4097","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-041 <\/td>\r\n\t\t\t\t\t 6X3X7 <\/td>\r\n\t\t\t\t\t $1384.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":"18","total_discounted_price":"1247.0","deposit":"0","total_retail_price":"1384.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 17:31: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","1","4",1168,"NEW","A05-CT207119",1384,1247,0,0,"6","6",7482,7482,7482,"2020-02-05 17:31:28","0",null,null,null,"2020-01-05","2020-07-04","6 months contract. Storage rental paid by PPS on February 4, 2020. Storage deposit $2768 transferred from agreement A05-CT195634 to this agreement.","2020-01-05","18",0,null,0,"0","2","2020-02-05 17:31:28","2","2020-02-05 17:31:28","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0012490559,0012490690","C191168","PERSONAL","Ms","80gnAMOvXv15zv\/CZ0Eqhw==","RAqogkelEKt1q5b\/6Neu\/g==","","Ut6wsoIDAljQJ6kQfCQSwE1wSnsPD\/fsEXrkRDwQG3A6U3eu5pWNV02cKJQSxPwWYYATzlFQ2\/TR66ZFjxzxyA==","J0s5BNrvxP8Nsmss73R5Xg==","ALwu41SaKL6NQKUA4wKaTDEEKRUmzMmPVvr4yQ1ufN4=","R28gHn90bFttZIUfQCAybA==",null,1,"4097"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 17:31: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":["7119","283","125","1043","%","10.00",138.4,"2","2020-02-05 17:31:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 17:31: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":["7119","1043","1384.0",1245.6,"2","2020-02-05 17:31:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 17:31: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-01-05","2020-07-04","1043"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-05 17:31: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":["7119",1168,"SETTLED","A05-I207447","2020-02-05 17:31:28","2020-01-05","2","2020-02-05 17:31:28","2","2020-02-05 17:31:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 17:31: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":["7447","RENT","\u9810\u7e73\u79df\u91d1",1,1247,"MO","1",1247,"2","2020-02-05 17:31:28","2","2020-02-05 17:31:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 17:31: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":["7447","RENT","\u9810\u7e73\u79df\u91d1",2,1247,"MO","1",1247,"2","2020-02-05 17:31:28","2","2020-02-05 17:31:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 17:31: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":["7447","RENT","\u9810\u7e73\u79df\u91d1",3,1247,"MO","1",1247,"2","2020-02-05 17:31:28","2","2020-02-05 17:31:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 17:31: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":["7447","RENT","\u9810\u7e73\u79df\u91d1",4,1247,"MO","1",1247,"2","2020-02-05 17:31:28","2","2020-02-05 17:31:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 17:31: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":["7447","RENT","\u9810\u7e73\u79df\u91d1",5,1247,"MO","1",1247,"2","2020-02-05 17:31:28","2","2020-02-05 17:31:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 17:31: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":["7447","RENT","\u9810\u7e73\u79df\u91d1",6,1247,"MO","1",1247,"2","2020-02-05 17:31:28","2","2020-02-05 17:31:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 17:31:28","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7482,0,"7447"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-05 17:31: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":[1168,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207095","2020-02-05 17:31:28",7482,"2","2020-02-05 17:31:28","2","2020-02-05 17:31:28","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 17:31: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":["7095","DEPOSIT",null,"PAID","2020-02-05 17:31:28",0,"2","2020-02-05 17:31:28","2","2020-02-05 17:31:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 17:31: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":["7095","INVOICE","7447","PAID","2020-02-05 17:31:28",7482,"2","2020-02-05 17:31:28","2","2020-02-05 17:31:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 18:02:09","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=950&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"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-01-03","renew_room_key":"076,29154","renew_remark":"1 month contract. Storage rental paid by bank transfer on November 27, 2019. Storage deposit transferred from agreement A14-CT196549 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT206829, \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-01-03","rent_from":"2020-01-03","rent_to":"2020-02-02","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on December 12, 2019. Storage deposit transferred from agreement A14-CT206829 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-05 18:02:09","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-CT207120",3986,4116,0,0,"1","1",4116,4116,4116,"2020-02-05 18:02:09","0",null,null,null,"2020-01-03","2020-02-02","1 month contract. Storage rental paid by bank transfer on December 12, 2019. Storage deposit transferred from agreement A14-CT206829 to this agreement.\r\n","2020-01-03","56",0,null,0,"0","2","2020-02-05 18:02:09","2","2020-02-05 18:02:09","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-05 18:02:09","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":["7120","417","1098.0","1098.00","2","2020-02-05 18:02:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 18:02:09","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-03","2020-02-02","417"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-05 18:02:09","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":["7120","424","2888.0","2888.00","2","2020-02-05 18:02:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 18:02:09","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-03","2020-02-02","424"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-05 18:02:09","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":["7120",950,"SETTLED","A14-I207448","2020-02-05 18:02:09","2020-01-03","2","2020-02-05 18:02:09","2","2020-02-05 18:02:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 18:02:09","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":["7448","RENT","\u9810\u7e73\u79df\u91d1",1,4116,"MO","1",4116,"2","2020-02-05 18:02:09","2","2020-02-05 18:02:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 18:02:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4116,0,"7448"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-05 18:02:09","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","P207096","2020-02-05 18:02:09",4116,"2","2020-02-05 18:02:09","2","2020-02-05 18:02:09","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 18:02:09","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":["7096","DEPOSIT",null,"PAID","2020-02-05 18:02:09",0,"2","2020-02-05 18:02:09","2","2020-02-05 18:02:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 18:02:09","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":["7096","INVOICE","7448","PAID","2020-02-05 18:02:09",4116,"2","2020-02-05 18:02:09","2","2020-02-05 18:02:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 18: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","index_url_parameter":"filter1=1&filter2=950&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":570,"customer_code":"C170570","identity_type":"PERSONAL","identity_id":"K817823(2)","title":"Ms","lastname":"Yuen","firstname":"Sze Wan Cewan","companyname":"","email":"cewanyuen@yahoo.com.hk","tel":"93190159","address":"Flat E, 8\/F, Blk 8, Chi Fu Fa Yuen, 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":"998.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-30","renew_room_key":"137,17359","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 30, 2020. Storage deposit transferred from agreement A12-CT206820 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207086, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"235","room_code":"D39","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":998,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-30","rent_from":"2020-01-30","rent_to":"2020-02-29","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on November 29, 2019. Storage deposit transferred from agreement A12-CT207086 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":998,"final_order_total":998,"location_id":"1","branch_id":"1","company_id":"1","room_key":"137,17359","order_product":[],"pass":true}},"first_order_id":"3800","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> D39 <\/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":"998.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 18:03: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","1",570,"NEW","A12-CT207121",998,998,0,0,"1","1",998,998,998,"2020-02-05 18:03:27","0",null,null,null,"2020-01-30","2020-02-29","1 month contract. Storage rental paid by bank transfer on November 29, 2019. Storage deposit transferred from agreement A12-CT207086 to this agreement.\r\n","2020-01-30","12",0,null,0,"0","2","2020-02-05 18:03:27","2","2020-02-05 18:03:27","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"137,17359","C170570","PERSONAL","Ms","cOVHZvoCSVf6Uh6Fd\/Oh2w==","DtbrOSvE4C7BOu5x4dBFtg==","","Av+ADiyvjVRBgUo03h3p6hpp6mcXgDaDJDvSxXwfQQosUJ1or1G3FIymGt9ddzamhEKDZyddjvFbjz9Eecftvg==","1l5cJvjJNKc2QtotYjeiiQ==","Lg+q8UB1y8C7eQ5vqzRcDiz\/WuEjcTUgxi3gM++AjHw=","CDRdPp1CIDhlh0eK\/Rafuw==",null,1,"3800"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 18:03: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":["7121","235","998.0","998.00","2","2020-02-05 18:03:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 18:03: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-30","2020-02-29","235"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-05 18:03: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":["7121",570,"SETTLED","A12-I207449","2020-02-05 18:03:27","2020-01-30","2","2020-02-05 18:03:27","2","2020-02-05 18:03:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 18:03: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":["7449","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-02-05 18:03:27","2","2020-02-05 18:03:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 18:03:27","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"7449"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-05 18:03: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":[570,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207097","2020-02-05 18:03:27",998,"2","2020-02-05 18:03:27","2","2020-02-05 18:03:27","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 18:03: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":["7097","DEPOSIT",null,"PAID","2020-02-05 18:03:27",0,"2","2020-02-05 18:03:27","2","2020-02-05 18:03:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 18:03: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":["7097","INVOICE","7449","PAID","2020-02-05 18:03:27",998,"2","2020-02-05 18:03:27","2","2020-02-05 18:03:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 19:30:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-05 19:30:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****