Subversion Repositories SmartDukaan

Rev

Show changed files | Directory listing | RSS feed

Filtering Options

Rev Age Author Path Log message Diff
35563 58 m ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/ tickets updated  
35562 59 m ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/ tickets updated  
35559 2 h 19 m amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/scheme/ Fixed SchemeService  
35551 5 h 17 m ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/offers/ bulletin updated on dashboard and give access category department  
35549 5 h 48 m ranu /trunk/ bulletin updated on dashboard and give access category department  
35548 23 h 31 m aman /trunk/ Feat : Bulk uploader for lead reassign and update state and city for leads  
35547 1 d 2 h amit /trunk/ Real-time Solr updates for TagListing changes

- Add Spring ApplicationEvent for TagListing changes (price, status, create, delete)
- Add async listener for incremental Solr updates (updateSingleCatalog)
- Add failure tracking with solr_update_failures table for visibility
- Add admin dashboard API for tech team to retry failed updates
- Add auto-retry job every 5 minutes (max 3 retries)
- Add startup sync for consistency after restart
- Add isProd check to skip Solr updates in local/dev environment
- Inject event publisher in TagListing, PriceDrop, Indent controllers
 
35537 6 d 18 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Optimize getAllPartnerStats: combine 5 tertiary queries into 1 using CASE WHEN pattern

- Added PartnerTertiarySalesModel to hold combined tertiary data
- Added FofoOrder.selectPartnerTertiarySales named query using CASE WHEN
- Added selectPartnerTertiarySales() batch method in FofoOrderItemRepository
- Updated PartnerStatsServiceImpl to use single combined query
- Reduces 5 DB queries to 1 for tertiary sales data (lmtd, mtd, lms, today, last3days)
 
35536 7 d 1 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ Optimize fetchParnterStats() - fix N+1 query issues

Performance improvements:
- Use batch method getAuthUserAndEsclationByPartnerIds() instead of N+1 loop
- Add new batch method getInvestmentsForFofoStores() to replace N+1 getInvestment() calls
- Add batch query selectActivatedGrnPendingAmountByFofoIds in ActivatedImeiRepository

Before: ~900 queries for 100 stores
After: ~7 queries for 100 stores
 
35529 8 d 23 h ranu /trunk/ lead repo done  
35528 9 d 0 h ranu /trunk/ content pojo chwcking  
35527 9 d 0 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/dtr/ lead repo done  
35513 14 d 20 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/ Fixed method Number to comma for Cr. Values  
35512 15 d 0 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/ Fix NonUniqueResultException in selectPartnerType - handle multiple records (CALCULATED + MANUAL) for same date by ordering by id DESC  
35509 15 d 2 h amit /trunk/ Add manual partner type upgrade support with source tracking

- Add PartnerTypeSource enum (CALCULATED, MANUAL)
- Add source and upgradedBy fields to PartnerTypeChange entity
- Manual upgrades now backdated to 1st of month for full month effect
- Fix repository queries to use id DESC as tie-breaker (MySQL 5.7 compatible)
- Track who performed manual upgrade via upgradedBy field
 
35508 15 d 3 h ranu /trunk/ lead repo done  
35507 15 d 3 h ranu /trunk/ lead repo done  
35504 16 d 5 h vikas /trunk/ Shopify Apis: Sync Products and Orders  
35503 16 d 5 h vikas /trunk/ Shopify : Orders  
35501 16 d 5 h ranu /trunk/ today offer modal done  

Show All