Subversion Repositories SmartDukaan

Rev

Hide changed files | Directory listing | RSS feed

Filtering Options

Rev Age Author Path Log message Diff Changes
35547 2 h 37 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
 
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/SolrRetryJob.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/config/AsyncConfig.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/solr
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/solr/SolrUpdateFailure.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/event
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/event/SolrStartupSync.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/event/TagListingChangeListener.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/event/TagListingChangedEvent.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/event/TagListingEventPublisher.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/solr
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/solr/SolrUpdateFailureRepository.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/solr/SolrUpdateFailureRepositoryImpl.java
/trunk/profitmandi-dao/src/main/resources/sql
/trunk/profitmandi-dao/src/main/resources/sql/solr_update_failures.sql
/trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/admin
/trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/admin/SolrFailureController.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/catalog/TagListing.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/TagListingRepository.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/TagListingRepositoryImpl.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/service/solr/FofoSolr.java
/trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/IndentController.java
/trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/PriceDropController.java
/trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/TagListingController.java
35546 1 d 23 h aman /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ Fix:Update contact list  
/trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/contact-us.vm
35545 1 d 23 h ranu /trunk/profitmandi-common/src/main/java/com/spice/profitmandi/common/model/ motorola in brand  
/trunk/profitmandi-common/src/main/java/com/spice/profitmandi/common/model/ProfitMandiConstants.java
35544 4 d 1 h amit /trunk/profitmandi-fofo/src/main/webapp/resources/js/ Handle scientific notation (e.g., 1.37E7) in numberToComma() function  
/trunk/profitmandi-fofo/src/main/webapp/resources/js/common.js
35543 5 d 3 h amit /trunk/profitmandi-fofo/src/main/ Use doPostAjaxRequestWithJsonHandler for getMonthWisePurchase and change to @RequestBody  
/trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/DashboardController.java
/trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/purchase-milestone.vm
35542 5 d 3 h amit /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ Fix POST ajax call to use $.ajax with data parameter for proper form encoding  
/trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/purchase-milestone.vm
35541 5 d 3 h amit /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ Change getMonthWisePurchase endpoint to POST method  
/trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/DashboardController.java
35540 5 d 3 h amit /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ Change getPartnersPurchaseDetail to use POST request  
/trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/purchase-milestone.vm
35539 5 d 3 h amit /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ Add click handlers to total row in Purchase MileStone table  
/trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/purchase-milestone.vm
35538 5 d 18 h amit /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ Add total row to Purchase MileStone table and clean up code formatting  
/trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/purchase-milestone.vm
35537 5 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)
 
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/PartnerTertiarySalesModel.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/FofoOrder.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/FofoOrderItemRepository.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/FofoOrderItemRepositoryImpl.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/PartnerStatsService.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/PartnerStatsServiceImpl.java
35536 6 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
 
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/ActivatedImei.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/ActivatedImeiRepository.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/ActivatedImeiRepositoryImpl.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/PartnerInvestmentService.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/PartnerInvestmentServiceImpl.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/PartnerStatsServiceImpl.java
35535 7 d 0 h amit /trunk/profitmandi-fofo/src/main/webapp/resources/js/ Fix: Use camelCase for jQuery data attribute access (fofoId instead of fofo-id)  
/trunk/profitmandi-fofo/src/main/webapp/resources/js/sd-credit.js
35534 7 d 3 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
 
/trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/SDCreditController.java
/trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/sd-credit-requirement-row.vm
/trunk/profitmandi-fofo/src/main/webapp/resources/js/sd-credit.js
35533 7 d 5 h amit /trunk/profitmandi-fofo/src/main/ Fixed AppConfig  
/trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/config/AppConfig.java
/trunk/profitmandi-fofo/src/main/webapp/resources/js/common.js
35532 7 d 8 h amit /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/ Added migration for 2 parties for gold  
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/Application.java
35531 7 d 8 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
 
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java
35530 7 d 8 h amit /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ Added migration for 2 parties for gold  
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java
35529 7 d 23 h ranu /trunk/ lead repo done  
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/ContentPojo.java
/trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ContentController.java
35528 8 d 0 h ranu /trunk/ content pojo chwcking  
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/ContentPojo.java
/trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ContentController.java

Show All