Subversion Repositories SmartDukaan

Rev

Go to most recent revision | Show changed files | Details | Compare with Previous | Blame | RSS feed

Filtering Options

Rev Age Author Path Log message Diff
35454 213 d 10 h amit /trunk/ perf: Optimize N+1 queries and reduce stream iterations in today_po and today_po_rbm endpoints

MonitorController.java:
- Consolidate 12 stream ops on rbmArrViewModels into single loop
- Consolidate 6 stream ops on sold15daysOldAgingModels into single loop
- Consolidate 6 stream ops on weeklyBillingData into single loop
- Merge double iteration loops into single pass operations
- Replace containsKey+get patterns with computeIfAbsent/getOrDefault
- Add extractRbmNames() helper to eliminate duplicated stream operations

CsServiceImpl.java:
- Fix N+1 in getAuthUserIdAndAuthUserMap using batch selectByIds
- Fix N+1 in getTicketIdAndAuthUserMapUsingTickets using batch selectByIds
- Fix N+1 in getAuthUserIdAndAuthUserMapUsingPositions using batch selectByIds
- Fix N+1 in getCategoryIdAndCategoryUsingPositions using batch selectAll
- Fix N+1 in getRegionIdAndRegionMap using batch selectAll
- Fix N+1 in getAuthUserByPartnerId using batch selectByIds
- Fix double N+1 in getAuthUserAndEsclationTypeByPartnerId
- Fix N+1 in authUserpartnerIdMap using selectByPositionIds
- Fix N+1 in getAuthUserIdPartnerIdMappingByCatIds
- Fix N+1 in getAuthUserIdPartnerIdMapping

RbmTargetServiceImpl.java:
- Fix O(n*m) stream filter in getRbmTodayArr using pre-built lookup maps
- Fix O(n*m) stream filter in setMovementWiseRbmTargets using pre-built maps

today_po.vm:
- Optimize template lookups with single get instead of containsKey+get		  
35443 214 d 6 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/ Optimize CsService methods - fix N+1 queries with batch fetching

- Add selectByPositionIds() batch method to PartnerPositionRepository
- getPositionCustomRetailerMap(): Batch fetch PartnerPositions and PartnerRegions
- getRegionPartners(): Batch fetch PartnerRegions upfront
- getAuthUserPartnerEmailMapping(): Batch fetch positions and AuthUsers
- getAuthUserPartnerIdMapping(): Batch fetch positions and AuthUsers

🤖 Generated with Claude Code		  
35394 217 d 0 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Improved performance  
35180 281 d 17 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/ Added SD Credit Scheduler  
35058 301 d 12 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/ Fixed issue reported by Shankar ji  
34921 327 d 4 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/ changeList  
34905 329 d 13 h ranu /trunk/ abm adddes in roles  
34903 333 d 6 h ranu /trunk/ bi report chnage  
34380 473 d 13 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/ Fixed  
34276 501 d 10 h ranu /trunk/ code commit for franchisee visit and rbm ratings  
34158 543 d 6 h tejus.lohani /trunk/ bug fix ,
1. Default partner mail saleL1 duplicate issue
2. Search order alert fix , specific field name instead of fix the error when field miss in update details form		  
34084 571 d 9 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/ auth user partner map configuration  
34082 571 d 12 h ranu /trunk/ new auth user partner maping and upsell correction  
34077 574 d 10 h tejus.lohani /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ partner access bug fix , verification reject mail send to all managers of loiForm filler  
33965 607 d 11 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/ ticket category trainning added on partner id map  
33870 645 d 9 h tejus.lohani /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/ add catagory ,in posisation catagory  
33773 676 d 10 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/ set l1,l2,l3,l4 for auth user direct ticket  
33588 734 d 6 h ranu /trunk/ tickect activity recordings some changes updated with kommuno  
33378 796 d 12 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/ adjust party sales header in cs service  
33377 796 d 13 h amit.gupta /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/ Fixed  

←Prev12Next→

Show All