Bug #2792
Develop Station Cost Summary Report with Classification Breakdown and Advanced Filters
Description
Description
Description:
Create a new Station Cost Summary Report that provides the total cost incurred for a station within a selected date range. The report should display the overall cost along with a detailed breakdown by each expense classification/category, enabling users to analyze station-wise operational costs.
Requirements:
Report Details
Display the Total Station Cost for the selected criteria.
Show a separate total for each Expense Classification (e.g., Food, Fuel, Travel, Accommodation, Toll, Miscellaneous, etc.).
Display the grand total as well as classification-wise totals.
Support grouping by Station if multiple stations are selected.
Filters
Provide the following filters:
Date Range (From Date – To Date)
Station
Tech Visit
Technician
Expense Classification
Expense Status (Pending, Approved, Rejected, On Hold)
Vendor (if applicable)
Month / Year (optional quick filter)
Output
Grand Total Cost
Classification-wise Cost Breakdown
Number of Expense Records
Number of Tech Visits
Average Cost per Visit (optional)
Export to Excel and PDF
API
Create a new API to fetch the report data.
Support pagination (if detailed records are included).
Support sorting by total cost and date.
Acceptance Criteria
Users can filter the report using Date Range, Station, Tech Visit, and other supported filters.
The report correctly calculates the total station cost.
Costs are displayed separately for each expense classification.
Grand Total equals the sum of all classification totals.
Report supports Excel and PDF export.
API returns accurate aggregated data with applied filters.
Performance remains acceptable for large datasets.
Priority: High
Updated by Yashaditya Singh 9 days ago
I worked on the Station Cost Report module by refining the UI to match the application's branding and design standards. I updated the filter section layout, aligned the Apply and Reset buttons with the filters, standardized the date picker styling, applied consistent branded typography across the page, set the default station selection and one-week date range on page load, and improved the summary cards and expense classification table styling to ensure a consistent look and feel with other report pages. I also fixed layout and font inconsistencies in the ledger details section and completed overall UI validation and polishing.
Updated by Yashaditya Singh 9 days ago
I worked on the Station Cost Report module by refining the UI to match the application's branding and design standards. I updated the filter section layout, aligned the Apply and Reset buttons with the filters, standardized the date picker styling, applied consistent branded typography across the page, set the default station selection and one-week date range on page load, and improved the summary cards and expense classification table styling to ensure a consistent look and feel with other report pages. I also fixed layout and font inconsistencies in the ledger details section and completed overall UI validation and polishing.
Updated by Yashaditya Singh 8 days ago
I worked on enhancing the Station Cost Report UI by redesigning the summary cards to match the application's design style, updating the icons and typography, replacing the dollar icon with the rupee symbol, refining the expense classification section, and improving the expandable table layout. I also aligned the table styling with the reference design by updating the header, text colors, spacing, and overall formatting, along with making minor UI refinements for chips, expand/collapse arrows, and section alignment to ensure a more consistent user experience.