{"statusCode":1,"message":"success","status":"success","result":1,"data":{"sourceId":null,"recordsTotal":3,"recordsFiltered":3,"gridKey":"view_period_fee_water_page","gridType":0,"totalAmount":464530,"gridflexs":[{"columnField":"ownerName","columnCaption":"Chủ hộ","columnCaptionE":"Owner","data_type":"nvarchar","columnWidth":150,"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":"meterCode","columnCaption":"Mã công tơ","columnCaptionE":"Meter Code","data_type":"nvarchar","columnWidth":130,"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":"contractNo","columnCaption":"Số hợp đồng","columnCaptionE":"Contract No","data_type":"nvarchar","columnWidth":130,"widthMode":"auto","fieldType":"text","columnClass":"","cellClass":["border-right","d-flex","align-items-center"],"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":"serviceType","columnCaption":"Loại giá DV","columnCaptionE":"Service Type","data_type":"nvarchar","columnWidth":140,"widthMode":"auto","fieldType":"text","columnClass":"","cellClass":["border-right","d-flex","align-items-center"],"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":"monthYear","columnCaption":"Tháng/Năm","columnCaptionE":"Month/Year","data_type":"nvarchar","columnWidth":100,"widthMode":"auto","fieldType":"text","columnClass":"","cellClass":["border-right","d-flex","align-items-center"],"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":"fromDate","columnCaption":"Từ ngày","columnCaptionE":"From Date","data_type":"nvarchar","columnWidth":110,"widthMode":"auto","fieldType":"text","columnClass":"","cellClass":["border-right","d-flex","align-items-center"],"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":"toDate","columnCaption":"Đến ngày","columnCaptionE":"To Date","data_type":"nvarchar","columnWidth":110,"widthMode":"auto","fieldType":"text","columnClass":"","cellClass":["border-right","d-flex","align-items-center"],"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":"fromIndex","columnCaption":"Từ số","columnCaptionE":"From Index","data_type":"numeric","columnWidth":90,"widthMode":"auto","fieldType":"number","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":"toIndex","columnCaption":"Đến số","columnCaptionE":"To Index","data_type":"numeric","columnWidth":90,"widthMode":"auto","fieldType":"number","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":"totalM3","columnCaption":"Tổng số m3","columnCaptionE":"Total M3","data_type":"numeric","columnWidth":100,"widthMode":"auto","fieldType":"number","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":"preTaxAmount","columnCaption":"Tiền trước thuế","columnCaptionE":"Pre-tax Amount","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":11,"isUsed":1,"isHide":false,"isMasterDetail":false,"isStatusLable":false,"isFilter":false,"columnObject":null,"group_cd":null,"group_name":null,"children":null},{"columnField":"vat","columnCaption":"VAT","columnCaptionE":"VAT","data_type":"numeric","columnWidth":100,"widthMode":"auto","fieldType":"money","columnClass":"","cellClass":["border-right","d-flex","align-items-center","justify-content-end"],"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":"envFee","columnCaption":"Phí Môi trường","columnCaptionE":"Environment Fee","data_type":"numeric","columnWidth":120,"widthMode":"auto","fieldType":"money","columnClass":"","cellClass":["border-right","d-flex","align-items-center","justify-content-end"],"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":"envTax","columnCaption":"Thuế Môi trường","columnCaptionE":"Environment Tax","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":14,"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 tiền","columnCaptionE":"Total Amount","data_type":"numeric","columnWidth":120,"widthMode":"auto","fieldType":"money","columnClass":"","cellClass":["border-right","d-flex","align-items-center","justify-content-end","fw-bold"],"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":"hasEstimate","columnCaption":"Dự thu","columnCaptionE":"Has Estimate","data_type":"nvarchar","columnWidth":90,"widthMode":"auto","fieldType":"check","columnClass":"","cellClass":["border-right","d-flex","align-items-center","justify-content-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":"hasInvoice","columnCaption":"Hoá đơn","columnCaptionE":"Has Invoice","data_type":"nvarchar","columnWidth":90,"widthMode":"auto","fieldType":"check","columnClass":"","cellClass":["border-right","d-flex","align-items-center","justify-content-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},{"columnField":"createdBy","columnCaption":"Người tạo","columnCaptionE":"Created By","data_type":"nvarchar","columnWidth":140,"widthMode":"auto","fieldType":"text","columnClass":"","cellClass":["border-right","d-flex","align-items-center"],"conditionClass":"","pinned":null,"ordinal":18,"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":"nvarchar","columnWidth":165,"widthMode":"auto","fieldType":"text","columnClass":"","cellClass":["border-right","d-flex","align-items-center"],"conditionClass":"","pinned":null,"ordinal":19,"isUsed":1,"isHide":false,"isMasterDetail":false,"isStatusLable":false,"isFilter":false,"columnObject":null,"group_cd":null,"group_name":null,"children":null},{"columnField":"updatedBy","columnCaption":"Người cập nhật","columnCaptionE":"Updated By","data_type":"nvarchar","columnWidth":140,"widthMode":"auto","fieldType":"text","columnClass":"","cellClass":["border-right","d-flex","align-items-center"],"conditionClass":"","pinned":null,"ordinal":20,"isUsed":1,"isHide":false,"isMasterDetail":false,"isStatusLable":false,"isFilter":false,"columnObject":null,"group_cd":null,"group_name":null,"children":null},{"columnField":"updatedDate","columnCaption":"Ngày cập nhật","columnCaptionE":"Updated Date","data_type":"nvarchar","columnWidth":165,"widthMode":"auto","fieldType":"text","columnClass":"","cellClass":["border-right","d-flex","align-items-center"],"conditionClass":"","pinned":null,"ordinal":21,"isUsed":1,"isHide":false,"isMasterDetail":false,"isStatusLable":false,"isFilter":false,"columnObject":null,"group_cd":null,"group_name":null,"children":null},{"columnField":"statusName","columnCaption":"Trạng thái","columnCaptionE":"Status","data_type":"nvarchar","columnWidth":130,"widthMode":"auto","fieldType":"text","columnClass":"","cellClass":["border-right","d-flex","align-items-center"],"conditionClass":"","pinned":"right","ordinal":22,"isUsed":1,"isHide":false,"isMasterDetail":false,"isStatusLable":true,"isFilter":false,"columnObject":null,"group_cd":null,"group_name":null,"children":null}],"dataList":[{"Oid":"fee-water-a101-0001","RoomCode":"A-01-01","FullName":"Nguyễn Văn An","periodMonthYearLabel":"Tháng 04/2026","apartmentCode":"A101","ownerName":"Nguyễn Văn An","meterCode":"CM-W-001","contractNo":"WTR-001","serviceType":"Nước sinh hoạt","monthYear":"04/2026","fromDate":"01/04/2026","toDate":"30/04/2026","fromIndex":35,"toIndex":48,"totalM3":13,"preTaxAmount":130000,"vat":13000,"envFee":3900,"envTax":390,"totalAmount":147290,"hasEstimate":true,"hasInvoice":false,"createdBy":"Nhân viên A","statusName":"<span class=\"inline-flex items-center gap-1 text-xs font-medium px-2 py-1 rounded-full bg-gray-500/10 text-gray-700\"><div class=\"w-1.5 h-1.5 rounded-full bg-gray-500\"></div>Khởi tạo</span>","createdDate":"2026-07-24 10:00:00","updatedBy":"Nhân viên A","updatedDate":"2026-07-24 10:00:00"},{"Oid":"fee-water-a102-0001","RoomCode":"A-01-02","FullName":"Trần Thị Bình","periodMonthYearLabel":"Tháng 04/2026","isClosed":true,"apartmentCode":"A102","ownerName":"Trần Thị Bình","meterCode":"CM-W-002","contractNo":"WTR-002","serviceType":"Nước sinh hoạt","monthYear":"04/2026","fromDate":"01/04/2026","toDate":"30/04/2026","fromIndex":20,"toIndex":30,"totalM3":10,"preTaxAmount":100000,"vat":10000,"envFee":3000,"envTax":300,"totalAmount":113300,"hasEstimate":true,"hasInvoice":true,"createdBy":"Nhân viên A","statusName":"<span class=\"inline-flex items-center gap-1 text-xs font-medium px-2 py-1 rounded-full bg-green-500/10 text-green-700\"><div class=\"w-1.5 h-1.5 rounded-full bg-green-600\"></div>Đã chốt</span>","createdDate":"2026-07-24 10:00:00","updatedBy":"Nhân viên A","updatedDate":"2026-07-24 10:00:00"},{"Oid":"fee-water-b101-0001","RoomCode":"B-01-01","FullName":"Phạm Thị Dung","periodMonthYearLabel":"Tháng 04/2026","apartmentCode":"B101","ownerName":"Phạm Thị Dung","meterCode":"CM-W-003","contractNo":"WTR-003","serviceType":"Nước sinh hoạt","monthYear":"04/2026","fromDate":"01/04/2026","toDate":"30/04/2026","fromIndex":55,"toIndex":73,"totalM3":18,"preTaxAmount":180000,"vat":18000,"envFee":5400,"envTax":540,"totalAmount":203940,"hasEstimate":false,"hasInvoice":false,"createdBy":"Nhân viên B","statusName":"<span class=\"inline-flex items-center gap-1 text-xs font-medium px-2 py-1 rounded-full bg-gray-500/10 text-gray-700\"><div class=\"w-1.5 h-1.5 rounded-full bg-gray-500\"></div>Khởi tạo</span>","createdDate":"2026-07-24 10:00:00","updatedBy":"Nhân viên B","updatedDate":"2026-07-24 10:00:00"}]}}