Subversion Repositories SmartDukaan

Rev

Go to most recent revision | Show changed files | Directory listing | RSS feed

Filtering Options

Rev Age Author Path Log message Diff
35538 105 d 2 h amit /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ Add total row to Purchase MileStone table and clean up code formatting  
35537 105 d 2 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 105 d 9 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		  
35535 106 d 7 h amit /trunk/profitmandi-fofo/src/main/webapp/resources/js/ Fix: Use camelCase for jQuery data attribute access (fofoId instead of fofo-id)  
35534 106 d 10 h amit /trunk/profitmandi-fofo/src/main/ Add credit blocked exception button to SD Credit page

- Added 'Add Exception' button in sd-credit-requirement-row.vm
- Added /addCreditBlockedException endpoint in SDCreditController.java
- Added JavaScript handler in sd-credit.js for the new button
- Allows adding CreditBlockedExceptionPartner entry for a partner for the current day		  
35533 106 d 12 h amit /trunk/profitmandi-fofo/src/main/ Fixed AppConfig  
35532 106 d 15 h amit /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/ Added migration for 2 parties for gold  
35531 106 d 16 h amit /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ Add manual partner type upgrade detection in rolloutMarginForStoreOnMonth

- Check if there's a MANUAL partner type change on day 1 of the month
- If manual upgrade detected, proceed with margin rollout for all orders in that month
- Existing calculated upgrade logic remains unchanged		  
35530 106 d 16 h amit /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ Added migration for 2 parties for gold  
35529 107 d 7 h ranu /trunk/ lead repo done  
35528 107 d 8 h ranu /trunk/ content pojo chwcking  
35527 107 d 8 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/dtr/ lead repo done  
35526 107 d 8 h ranu /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ lead repo done  
35525 107 d 8 h ranu /trunk/profitmandi-fofo/src/main/ content exception added  
35524 107 d 8 h amit /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/ Added migration for 2 parties for gold  
35523 107 d 8 h ranu /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ lead repo done  
35522 107 d 9 h amit /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ Added migration for 2 parties for gold  
35521 107 d 9 h amit /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/ Added migration for 2 parties for gold  
35520 107 d 9 h amit /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/ Fixed method Number to comma for Cr. Values  
35519 107 d 10 h ranu /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ lead repo done  

←Prev12Next→

Show All