Bug #2421
Implement Station Setup Tracking System with Step-wise Status and Audit Logs
0%
Description
Currently, managing EV station setup activities lacks structured tracking, leading to delays and poor visibility on progress and bottlenecks.
We need to implement a step-wise station setup tracking system to monitor each stage of station deployment with clear ownership, status, and audit logs.
Objective:
Create a centralized system to track all station setup steps with:
Real-time status visibility
Ownership tracking
Delay identification
Historical audit logs
Scope of Work:
1. Station Setup Steps Tracking
Create a structured workflow to track below steps per station:
Electricity Connection
Civil Work / Foundation
Machine (Charger) Setup
Canopy Setup
Network Setup
Camera Setup
Fire & Safety Setup
Software Configuration
Testing & Commissioning
Final Go-Live
Each step should have:
Status: In Progress / On Hold / Completed
Assigned Owner
Dependency (optional)
Remarks (for delay/issues)
Follow-up Date
2. Database Design
Table: station_setup_steps
id (PK)
station_id (FK)
step_name
status
assigned_to
dependency
remark
follow_up_date
updated_by
updated_date
Table: station_setup_logs (Audit Trail)
id (PK)
station_setup_step_id (FK)
old_status
new_status
remark
assigned_to
updated_by
updated_date
3. Functional Requirements
Ability to update step status
Capture remarks for “On Hold” scenarios
Track ownership per step
Maintain history of all status changes
View all steps for a station in a single dashboard
4. Reporting / Dashboard
Station-wise progress tracking
Identify delayed steps
Highlight blockers (On Hold cases)
Completion percentage per station
Acceptance Criteria:
All station setup steps are configurable and trackable
Status updates reflect in real-time
Audit logs capture every change
Users can identify delays and responsible owners
Dashboard shows clear progress per station
Priority: High
Type: Feature / Enhancement
Business Impact:
Improves visibility on station setup progress
Reduces delays by identifying bottlenecks early
Ensures accountability across teams
Standardizes deployment process
Subtasks
Updated by Shreya Agarwal about 2 months ago
Today I got a new project assignment and I created the required database tables and explored their structure to understand how the system will be implemented and also analyzed the overall project requirements and try to gained clarity on the workflow and next steps.
Updated by Yashaditya Singh about 2 months ago
Designed and implemented the database structure and required tables for step-wise tracking of station setup stages
Defined fields for capturing status updates and remarks at each step
Work is in progress, and further API development and integration will continue.
Updated by Yashaditya Singh about 2 months ago
Today I completed the API development for the Station Setup Tracking System in the EVCSMS project. I created all the required database tables and Api's including station_status_steps,station_setup_logs and station_steps to support step-wise tracking of station setup. On the schema side, I implemented proper table relationships, added necessary foreign keys between station, steps, and status tables, and structured the schema to support dynamic step and status mapping instead of fixed default values.
All the APIs were thoroughly tested and are working as expected.
Updated by Shreya Agarwal about 1 month ago
API development for the Station Setup Tracking System in the EVCSMS project in which working on status master and setup step master in master data service in EVCSMS
Updated by Yashaditya Singh about 1 month ago
I added permission handling to the existing APIs to ensure proper role-based access control. I also developed APIs for the log table to track and manage activity related to the Station Setup Tracking System. Additionally, I debugged the existing functionality to fix issues and ensure smooth operation.
Updated by Yashaditya Singh about 1 month ago
Worked on resolving query issues in the Station Setup Log API, including fixing column mappings and join errors. Improved step and status handling, refined input logic during station creation, and debugged existing functionality to ensure accurate data retrieval.
Updated by Shreya Agarwal about 1 month ago
implementation of the Status Master Repository in master data services in EVCSMS Project with full tenant-aware schema support using Dapper. I created and structured all CRUD operations and also implemented of setup step master and status master API
Updated by Yashaditya Singh about 1 month ago
Completed the backend development for the Station Setup Tracking System, including implementation of audit logs and required API functionalities also performed debugging to improve the existing functionality and ensured smooth integration across the system.
Additionally, created a feature branch (feature/station-setup-enhancement) and successfully committed code to GitHub. I tested all the developed APIs validated their behavior, and confirmed that they are working as expected.
Updated by Shreya Agarwal about 1 month ago
Today, I successfully completed the implementation of the Station Setup Tracking System with setup step Master and Status Master functionality.
Developed and integrated setup step master and status master APIS and tracking for station setup processes.
Implemented comprehensive audit logging to capture all actions and changes.
Ensured proper validation and flow across all setup stages.
Completed testing and verification of the full workflow.
All development tasks are completed and Code has been reviewed and successfully merged into the branch: station setup enhancement.
Analyzed other APIs for integration and for more understanding .
Updated by Shreya Agarwal about 1 month ago
Learned basics of API development from online . Understood how APIs work . Reviewed some existing project APIs for better understanding. Received a new task for Upload Document APIs and started working on it .
Updated by Shreya Agarwal about 1 month ago
Reviewed existing project structure for Upload Document APIs . Understood implementation and flow from other APIs. Worked on developing my own Upload Document API. Completed most of the implementation for document upload. Major work for Upload Document API is complete. But Some Remaining minor changes and final testing are pending.
Updated by Shreya Agarwal about 1 month ago
Today, I worked on completing the document upload functionality for the station setup module. I verified and fixed the AWS S3 configuration for tenant-specific settings, which resolved the upload failure issue. I tested the upload API with different file types such as PDF, images, and DOCX to ensure validation and upload were functioning correctly. I also confirmed that the uploaded file path is being stored properly in the database using the tenant-specific schema. Additionally, I improved error handling and logging for better debugging and reliability. Finally, I performed testing from API to database and ensured the overall upload flow is working as expected and ready for review.