How sharma2206/mis-report works
This Laravel application accepts branch- and date-specific CSV uploads, imports bill, cashier-collection, and (for Chromepet) package-consumption data, then generates a management information system (MIS) report for JSON display or Excel export. The principal flow is routed through the MIS API controller, which coordinates CSV processing and report generation. Report calculations query the imported records and apply branch-specific adjustments. The source excerpts show the controller, processing, and report layers; several import, validation, and export relationships are supported by the source index rather than full excerpts.
Main entry points: CsvProcessingService.php CSV processing · MISController.php MIS controller · MISService.php MIS calculations · BillItem.php Bill records
Components 16
API entry
- API routes
routes/api.php - MIS controller
app/Http/Controllers/Api/MISController.php - Upload validation
app/Http/Requests/MISUploadRequest.php - Report validation
app/Http/Requests/MISRequest.php - Branch rules
app/Enums/Branch.php
CSV ingestion
- CSV processing
app/Services/CsvProcessingService.php - Bill import
app/Imports/BillItemImport.php - Cashier import
app/Imports/CashierCollectionImport.php - Package import
app/Imports/PackageConsumptionImport.php
MIS reporting
- MIS calculations
app/Services/MISService.php - Excel export
app/Exports/MISExport.php
Report records
- Bill records
app/Models/BillItem.php - Cashier records
app/Models/CashierCollection.php - Package records
app/Models/PackageConsumption.php
Other components
- MIS user
- Application database
Connections 24
- MIS user → API routes: calls API
- API routes → MIS controller: routes to
routes/api.php - MIS controller → Upload validation: validates upload
app/Http/Controllers/Api/MISController.php - MIS controller → Report validation: validates report
app/Http/Controllers/Api/MISController.php - Upload validation → Branch rules: uses branch
app/Http/Requests/MISUploadRequest.php - Report validation → Branch rules: uses branch
app/Http/Requests/MISRequest.php - MIS controller → CSV processing: processes files
app/Http/Controllers/Api/MISController.php - MIS controller → MIS calculations: generates report
app/Http/Controllers/Api/MISController.php - MIS controller → Excel export: exports report
app/Http/Controllers/Api/MISController.php - CSV processing → Bill import: imports bills
app/Services/CsvProcessingService.php - CSV processing → Cashier import: imports collections
app/Services/CsvProcessingService.php - CSV processing → Package import: imports packages
app/Services/CsvProcessingService.php - Bill import → Bill records: creates records
app/Imports/BillItemImport.php - Cashier import → Cashier records: creates records
app/Imports/CashierCollectionImport.php - Package import → Package records: creates records
app/Imports/PackageConsumptionImport.php - MIS calculations → Bill records: queries records
app/Services/MISService.php - MIS calculations → Cashier records: queries records
app/Services/MISService.php - MIS calculations → Package records: queries records
app/Services/MISService.php - CSV processing → Bill records: deletes prior data
app/Services/CsvProcessingService.php - CSV processing → Cashier records: deletes prior data
app/Services/CsvProcessingService.php - CSV processing → Package records: deletes prior data
app/Services/CsvProcessingService.php - Bill records → Application database: persists records
- Cashier records → Application database: persists records
- Package records → Application database: persists records