| 35567 |
116 d 20 h |
amit |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ |
Ticket system improvements: working days service and batch queries
- Add WorkingDaysService for centralized working days calculation
- Excludes Sundays and public holidays from database
- Saturdays are counted as working days
- Methods: isWorkingDay, countWorkingDays, addWorkingDays, isDeadlineExceeded
- Add new escalation constants in Ticket.java (L2=3, L3=3, Final=2 working days)
- Add selectByIds batch query to TicketAssignedRepository to eliminate N+1 queries
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com> |
|
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/WorkingDaysService.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/cs/Ticket.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/TicketAssignedRepository.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/TicketAssignedRepositoryImpl.java
|