{"statusCode":1,"message":"success","status":"success","result":1,"data":{"sourceId":null,"recordsTotal":10,"recordsFiltered":10,"gridKey":"view_service_fee_test_page","gridType":0,"totalAmount":0,"gridflexs":[{"columnField":"apartmentCode","columnCaption":"Mã căn hộ","columnCaptionE":"Apartment Code","data_type":"nvarchar","columnWidth":120,"widthMode":"auto","fieldType":"text","columnClass":"","cellClass":["border-right","d-flex","align-items-center"],"conditionClass":"","pinned":null,"ordinal":1,"isUsed":1,"isHide":false,"isMasterDetail":false,"isStatusLable":false,"isFilter":false,"columnObject":null,"group_cd":null,"group_name":null,"children":null},{"columnField":"ownerName","columnCaption":"Chủ hộ","columnCaptionE":"Owner","data_type":"nvarchar","columnWidth":120,"widthMode":"auto","fieldType":"text","columnClass":"","cellClass":["border-right","d-flex","align-items-center"],"conditionClass":"","pinned":null,"ordinal":2,"isUsed":1,"isHide":false,"isMasterDetail":false,"isStatusLable":false,"isFilter":false,"columnObject":null,"group_cd":null,"group_name":null,"children":null},{"columnField":"month","columnCaption":"Tháng","columnCaptionE":"Month","data_type":"numeric","columnWidth":120,"widthMode":"auto","fieldType":"number","columnClass":"","cellClass":["border-right","d-flex","align-items-center","justify-content-end"],"conditionClass":"","pinned":null,"ordinal":3,"isUsed":1,"isHide":false,"isMasterDetail":false,"isStatusLable":false,"isFilter":false,"columnObject":null,"group_cd":null,"group_name":null,"children":null},{"columnField":"year","columnCaption":"Năm","columnCaptionE":"Year","data_type":"numeric","columnWidth":120,"widthMode":"auto","fieldType":"number","columnClass":"","cellClass":["border-right","d-flex","align-items-center","justify-content-end"],"conditionClass":"","pinned":null,"ordinal":4,"isUsed":1,"isHide":false,"isMasterDetail":false,"isStatusLable":false,"isFilter":false,"columnObject":null,"group_cd":null,"group_name":null,"children":null},{"columnField":"area","columnCaption":"Diện tích (m²)","columnCaptionE":"Area","data_type":"numeric","columnWidth":120,"widthMode":"auto","fieldType":"number","columnClass":"","cellClass":["border-right","d-flex","align-items-center","justify-content-end"],"conditionClass":"","pinned":null,"ordinal":5,"isUsed":1,"isHide":false,"isMasterDetail":false,"isStatusLable":false,"isFilter":false,"columnObject":null,"group_cd":null,"group_name":null,"children":null},{"columnField":"serviceFee","columnCaption":"Phí dịch vụ","columnCaptionE":"Service Fee","data_type":"numeric","columnWidth":130,"widthMode":"auto","fieldType":"money","columnClass":"","cellClass":["border-right","d-flex","align-items-center","justify-content-end"],"conditionClass":"","pinned":null,"ordinal":6,"isUsed":1,"isHide":false,"isMasterDetail":false,"isStatusLable":false,"isFilter":false,"columnObject":null,"group_cd":null,"group_name":null,"children":null},{"columnField":"managementFee","columnCaption":"Phí quản lý","columnCaptionE":"Management Fee","data_type":"numeric","columnWidth":130,"widthMode":"auto","fieldType":"money","columnClass":"","cellClass":["border-right","d-flex","align-items-center","justify-content-end"],"conditionClass":"","pinned":null,"ordinal":7,"isUsed":1,"isHide":false,"isMasterDetail":false,"isStatusLable":false,"isFilter":false,"columnObject":null,"group_cd":null,"group_name":null,"children":null},{"columnField":"parkingFee","columnCaption":"Phí gửi xe","columnCaptionE":"Parking Fee","data_type":"numeric","columnWidth":130,"widthMode":"auto","fieldType":"money","columnClass":"","cellClass":["border-right","d-flex","align-items-center","justify-content-end"],"conditionClass":"","pinned":null,"ordinal":8,"isUsed":1,"isHide":false,"isMasterDetail":false,"isStatusLable":false,"isFilter":false,"columnObject":null,"group_cd":null,"group_name":null,"children":null},{"columnField":"cleaningFee","columnCaption":"Phí vệ sinh","columnCaptionE":"Cleaning Fee","data_type":"numeric","columnWidth":130,"widthMode":"auto","fieldType":"money","columnClass":"","cellClass":["border-right","d-flex","align-items-center","justify-content-end"],"conditionClass":"","pinned":null,"ordinal":9,"isUsed":1,"isHide":false,"isMasterDetail":false,"isStatusLable":false,"isFilter":false,"columnObject":null,"group_cd":null,"group_name":null,"children":null},{"columnField":"securityFee","columnCaption":"Phí an ninh","columnCaptionE":"Security Fee","data_type":"numeric","columnWidth":130,"widthMode":"auto","fieldType":"money","columnClass":"","cellClass":["border-right","d-flex","align-items-center","justify-content-end"],"conditionClass":"","pinned":null,"ordinal":10,"isUsed":1,"isHide":false,"isMasterDetail":false,"isStatusLable":false,"isFilter":false,"columnObject":null,"group_cd":null,"group_name":null,"children":null},{"columnField":"totalAmount","columnCaption":"Tổng phải thu","columnCaptionE":"Total","data_type":"numeric","columnWidth":130,"widthMode":"auto","fieldType":"money-primary","columnClass":"","cellClass":["border-right","d-flex","align-items-center","justify-content-end"],"conditionClass":"","pinned":null,"ordinal":11,"isUsed":1,"isHide":false,"isMasterDetail":false,"isStatusLable":false,"isFilter":false,"columnObject":null,"group_cd":null,"group_name":null,"children":null},{"columnField":"isPaid","columnCaption":"Đã thu","columnCaptionE":"Paid","data_type":"bit","columnWidth":90,"widthMode":"auto","fieldType":"checkbox","columnClass":"","cellClass":["border-right","d-flex","align-items-center","justify-content-center"],"conditionClass":"","pinned":null,"ordinal":12,"isUsed":1,"isHide":false,"isMasterDetail":false,"isStatusLable":false,"isFilter":false,"columnObject":null,"group_cd":null,"group_name":null,"children":null},{"columnField":"hasInvoice","columnCaption":"Có hóa đơn","columnCaptionE":"Has Invoice","data_type":"bit","columnWidth":90,"widthMode":"auto","fieldType":"checkbox","columnClass":"","cellClass":["border-right","d-flex","align-items-center","justify-content-center"],"conditionClass":"","pinned":null,"ordinal":13,"isUsed":1,"isHide":false,"isMasterDetail":false,"isStatusLable":false,"isFilter":false,"columnObject":null,"group_cd":null,"group_name":null,"children":null},{"columnField":"isLocked","columnCaption":"Đã chốt","columnCaptionE":"Locked","data_type":"bit","columnWidth":90,"widthMode":"auto","fieldType":"checkbox","columnClass":"","cellClass":["border-right","d-flex","align-items-center","justify-content-center"],"conditionClass":"","pinned":null,"ordinal":14,"isUsed":1,"isHide":false,"isMasterDetail":false,"isStatusLable":false,"isFilter":false,"columnObject":null,"group_cd":null,"group_name":null,"children":null},{"columnField":"createdBy","columnCaption":"Người tạo","columnCaptionE":"Created By","data_type":"nvarchar","columnWidth":120,"widthMode":"auto","fieldType":"text","columnClass":"","cellClass":["border-right","d-flex","align-items-center"],"conditionClass":"","pinned":null,"ordinal":15,"isUsed":1,"isHide":false,"isMasterDetail":false,"isStatusLable":false,"isFilter":false,"columnObject":null,"group_cd":null,"group_name":null,"children":null},{"columnField":"createdDate","columnCaption":"Ngày tạo","columnCaptionE":"Created Date","data_type":"date","columnWidth":110,"widthMode":"auto","fieldType":"date","columnClass":"","cellClass":["border-right","d-flex","align-items-center"],"conditionClass":"","pinned":null,"ordinal":16,"isUsed":1,"isHide":false,"isMasterDetail":false,"isStatusLable":false,"isFilter":false,"columnObject":null,"group_cd":null,"group_name":null,"children":null},{"columnField":"note","columnCaption":"Ghi chú","columnCaptionE":"Note","data_type":"nvarchar","columnWidth":120,"widthMode":"auto","fieldType":"text","columnClass":"","cellClass":["border-right","d-flex","align-items-center"],"conditionClass":"","pinned":null,"ordinal":17,"isUsed":1,"isHide":false,"isMasterDetail":false,"isStatusLable":false,"isFilter":false,"columnObject":null,"group_cd":null,"group_name":null,"children":null}],"dataList":[{"id":"1","apartmentCode":"A01-1001","ownerName":"Nguyễn Văn A","month":"01","year":"2024","area":85.5,"serviceFee":2565000,"managementFee":1710000,"parkingFee":500000,"cleaningFee":200000,"securityFee":155000,"totalAmount":5130000,"isPaid":true,"hasInvoice":true,"isLocked":false,"createdBy":"Admin Hệ thống","createdDate":"2024-01-15 09:00:00","note":"Đã thanh toán đầy đủ","Oid":"00000000-0000-0000-0000-000000000001"},{"id":"2","apartmentCode":"A01-1002","ownerName":"Trần Thị B","month":"01","year":"2024","area":72,"serviceFee":2160000,"managementFee":1440000,"parkingFee":500000,"cleaningFee":200000,"securityFee":120000,"totalAmount":4420000,"isPaid":false,"hasInvoice":true,"isLocked":false,"createdBy":"Nguyễn Văn C","createdDate":"2024-01-15 09:00:00","note":"","Oid":"00000000-0000-0000-0000-000000000002"},{"id":"3","apartmentCode":"A01-1003","ownerName":"Lê Minh C","month":"01","year":"2024","area":95,"serviceFee":2850000,"managementFee":1900000,"parkingFee":1000000,"cleaningFee":200000,"securityFee":190000,"totalAmount":6140000,"isPaid":true,"hasInvoice":true,"isLocked":true,"createdBy":"Admin Hệ thống","createdDate":"2024-01-15 09:00:00","note":"Có 2 chỗ đậu xe","Oid":"00000000-0000-0000-0000-000000000003"},{"id":"4","apartmentCode":"A02-2001","ownerName":"Phạm Thị D","month":"01","year":"2024","area":68,"serviceFee":2040000,"managementFee":1360000,"parkingFee":500000,"cleaningFee":200000,"securityFee":100000,"totalAmount":4200000,"isPaid":false,"hasInvoice":false,"isLocked":false,"createdBy":"Nguyễn Văn C","createdDate":"2024-01-15 09:00:00","note":"","Oid":"00000000-0000-0000-0000-000000000004"},{"id":"5","apartmentCode":"A02-2002","ownerName":"Hoàng Văn E","month":"01","year":"2024","area":110,"serviceFee":3300000,"managementFee":2200000,"parkingFee":1000000,"cleaningFee":200000,"securityFee":220000,"totalAmount":6920000,"isPaid":true,"hasInvoice":true,"isLocked":false,"createdBy":"Admin Hệ thống","createdDate":"2024-01-15 09:00:00","note":"Căn hộ lớn","Oid":"00000000-0000-0000-0000-000000000005"},{"id":"6","apartmentCode":"B01-1001","ownerName":"Đặng Thị F","month":"01","year":"2024","area":78,"serviceFee":2340000,"managementFee":1560000,"parkingFee":500000,"cleaningFee":200000,"securityFee":140000,"totalAmount":4740000,"isPaid":false,"hasInvoice":true,"isLocked":false,"createdBy":"Nguyễn Văn C","createdDate":"2024-01-15 09:00:00","note":"","Oid":"00000000-0000-0000-0000-000000000006"},{"id":"7","apartmentCode":"B01-1002","ownerName":"Vũ Minh G","month":"01","year":"2024","area":88,"serviceFee":2640000,"managementFee":1760000,"parkingFee":500000,"cleaningFee":200000,"securityFee":160000,"totalAmount":5260000,"isPaid":true,"hasInvoice":true,"isLocked":false,"createdBy":"Admin Hệ thống","createdDate":"2024-01-15 09:00:00","note":"","Oid":"00000000-0000-0000-0000-000000000007"},{"id":"8","apartmentCode":"B02-2001","ownerName":"Bùi Thị H","month":"01","year":"2024","area":92,"serviceFee":2760000,"managementFee":1840000,"parkingFee":1000000,"cleaningFee":200000,"securityFee":180000,"totalAmount":5980000,"isPaid":false,"hasInvoice":true,"isLocked":false,"createdBy":"Nguyễn Văn C","createdDate":"2024-01-15 09:00:00","note":"","Oid":"00000000-0000-0000-0000-000000000008"},{"id":"9","apartmentCode":"C01-1001","ownerName":"Ngô Văn I","month":"01","year":"2024","area":105,"serviceFee":3150000,"managementFee":2100000,"parkingFee":1000000,"cleaningFee":200000,"securityFee":210000,"totalAmount":6660000,"isPaid":true,"hasInvoice":true,"isLocked":true,"createdBy":"Admin Hệ thống","createdDate":"2024-01-15 09:00:00","note":"Đã khóa bản ghi","Oid":"00000000-0000-0000-0000-000000000009"},{"id":"10","apartmentCode":"C01-1002","ownerName":"Đinh Thị K","month":"01","year":"2024","area":70,"serviceFee":2100000,"managementFee":1400000,"parkingFee":500000,"cleaningFee":200000,"securityFee":110000,"totalAmount":4310000,"isPaid":false,"hasInvoice":false,"isLocked":false,"createdBy":"Nguyễn Văn C","createdDate":"2024-01-15 09:00:00","note":"Chưa có hóa đơn","Oid":"00000000-0000-0000-0000-00000000000a"}],"view_type":0,"valid":true},"error":null}