Subversion Repositories SmartDukaan

Last modification

• Rev 35454 2025-12-20 15:37:17
• Author: amit

• Log message:

  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