| Rev |
Age |
Author |
Path |
Log message |
Diff |
| 35547 |
45 m |
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 |
5 d 16 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 |
5 d 23 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 |
7 d 21 h |
ranu |
/trunk/ |
lead repo done |
|
| 35528 |
7 d 22 h |
ranu |
/trunk/ |
content pojo chwcking |
|
| 35527 |
7 d 22 h |
ranu |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/dtr/ |
lead repo done |
|
| 35513 |
13 d 18 h |
amit |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/ |
Fixed method Number to comma for Cr. Values |
|
| 35512 |
13 d 22 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 |
14 d 0 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 |
14 d 1 h |
ranu |
/trunk/ |
lead repo done |
|
| 35507 |
14 d 1 h |
ranu |
/trunk/ |
lead repo done |
|
| 35504 |
15 d 3 h |
vikas |
/trunk/ |
Shopify Apis: Sync Products and Orders |
|
| 35503 |
15 d 3 h |
vikas |
/trunk/ |
Shopify : Orders |
|
| 35501 |
15 d 3 h |
ranu |
/trunk/ |
today offer modal done |
|
| 35499 |
15 d 22 h |
aman |
/trunk/ |
Fix:Trial Activation Mail, All trial user page and gst validation |
|
| 35495 |
20 d 17 h |
amit |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ |
Fresh money allowance feature for B2B orders with overdue loans
- SDCreditServiceImpl: Added validateOverdueLoans() to check if partner can place order
- SDCreditServiceImpl: Added getAvailableFreshMoney() to calculate same-day fresh money
- SDCreditServiceImpl: Partners with overdue loans can now place orders using fresh money added same day
- OrderRepository: Added selectTodayOrdersExcludingRefund() for fresh money calculation
- UserWalletHistoryRepository: Added methods to get today's payments and refunds
Logic: Fresh money = (Today's PAYMENT_GATEWAY + AUTOMATED_ADVANCE deposits) - (Today's orders excluding refunded) + (Today's refunds) |
|
| 35493 |
20 d 17 h |
amit |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ |
N+1 query optimization for B2B order creation flow
- OrderServiceImpl: Batch fetch PendingOrderItems before validation loop (line 402)
- OrderServiceImpl: Batch update opening stock using minusOpeningStockBatch
- OrderServiceImpl: Pre-fetch tagListings and GST rates before createAndGetFofoOrderItem loop
- OrderServiceImpl: Batch fetch PendingOrderItems for status update (line 719)
- CartServiceImpl: Pre-fetch items before getCartValidation loop
- SchemeServiceImpl: Batch fetch SchemeInOut records in processSchemeOut
- SmartCartService: Added minusOpeningStockBatch method for batch updates
- TagListingRepository: Added selectByItemIds batch method
- FofoOpeningStockRepository: Added findByFofoIdAndCatalogIds batch method
- PendingOrderItemRepository: Added selectByIds batch method
Performance improvement: ~70-100 DB queries reduced per order (10 items avg) |
|
| 35490 |
21 d 21 h |
ranu |
/trunk/ |
given brandwise placement acesseries qty instead of value |
|
| 35489 |
21 d 22 h |
aman |
/trunk/ |
Fix:Trial Activation Mail |
|
| 35487 |
22 d 0 h |
ranu |
/trunk/ |
place ment plan page show catalog status wise |
|