SmartDukaan – /

Rev 35549 – bulletin updated on dashboard and give access category department

ranu — Thu, 15 Jan 2026 12:55:23 +0530

ranu – 23 file(s) modified
bulletin updated on dashboard and give access category department

~ /trunk/profitmandi-common/src/main/java/com/spice/profitmandi/common/model/ProfitMandiConstants.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/cs/Bulletin.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/BulletinOfferModal.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/BulletinPostModel.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/PartnerBrief.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/OfferRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/OfferRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/SchemeRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/SchemeRepositoryImpl.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/BulletinRepository.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/BulletinRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/AdminUser.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/offers/TodayOfferService.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/offers/TodayOfferServiceImpl.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ContentController.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/FileUploadController.java
+ /trunk/profitmandi-fofo/src/main/webapp/resources/js/bulletin.js
~ /trunk/profitmandi-fofo/src/main/webapp/resources/js/create-order.js
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/admin.vm
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/include-scripts.vm
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/mobile-brand-wise-report.vm
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/order-index.vm
+ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/post-bulletin.vm

Rev 35548 – Feat : Bulk uploader for lead reassign and update state ...

aman — Wed, 14 Jan 2026 19:12:44 +0530

aman – 4 file(s) modified
Feat : Bulk uploader for lead reassign and update state and city for leads

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/CreateLeacdActivityRequest.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/LeadController.java
~ /trunk/profitmandi-fofo/src/main/webapp/resources/js/lead.js
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/lead.vm

Rev 35547 – Real-time Solr updates for TagListing changes - Add Spring ...

amit — Wed, 14 Jan 2026 16:05:06 +0530

amit – 23 file(s) modified
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/catalog/TagListing.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/TagListingChangedEvent.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/TagListingEventPublisher.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/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/java/com/spice/profitmandi/dao/service/solr/FofoSolr.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-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

Rev 35546 – Fix:Update contact list

aman — Mon, 12 Jan 2026 19:42:26 +0530

aman – 1 file(s) modified
Fix:Update contact list

~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/contact-us.vm

Rev 35545 – motorola in brand

ranu — Mon, 12 Jan 2026 19:27:15 +0530

ranu – 1 file(s) modified
motorola in brand

~ /trunk/profitmandi-common/src/main/java/com/spice/profitmandi/common/model/ProfitMandiConstants.java

Rev 35544 – Handle scientific notation (e.g., 1.37E7) in numberToComma() function

amit — Sat, 10 Jan 2026 17:11:39 +0530

amit – 1 file(s) modified
Handle scientific notation (e.g., 1.37E7) in numberToComma() function

~ /trunk/profitmandi-fofo/src/main/webapp/resources/js/common.js

Rev 35543 – Use doPostAjaxRequestWithJsonHandler for getMonthWisePurchase and change to @RequestBody

amit — Fri, 09 Jan 2026 15:04:48 +0530

amit – 2 file(s) modified
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

Rev 35542 – Fix POST ajax call to use $.ajax with data parameter ...

amit — Fri, 09 Jan 2026 15:00:30 +0530

amit – 1 file(s) modified
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

Rev 35541 – Change getMonthWisePurchase endpoint to POST method

amit — Fri, 09 Jan 2026 14:56:12 +0530

amit – 1 file(s) modified
Change getMonthWisePurchase endpoint to POST method

~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/DashboardController.java

Rev 35540 – Change getPartnersPurchaseDetail to use POST request

amit — Fri, 09 Jan 2026 14:55:19 +0530

amit – 1 file(s) modified
Change getPartnersPurchaseDetail to use POST request

~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/purchase-milestone.vm

Rev 35539 – Add click handlers to total row in Purchase MileStone table

amit — Fri, 09 Jan 2026 14:54:22 +0530

amit – 1 file(s) modified
Add click handlers to total row in Purchase MileStone table

~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/purchase-milestone.vm

Rev 35538 – Add total row to Purchase MileStone table and clean up ...

amit — Fri, 09 Jan 2026 00:07:51 +0530

amit – 1 file(s) modified
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

Rev 35537 – Optimize getAllPartnerStats: combine 5 tertiary queries into 1 using CASE ...

amit — Thu, 08 Jan 2026 23:58:50 +0530

amit – 6 file(s) modified
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/entity/fofo/FofoOrder.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/PartnerTertiarySalesModel.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

Rev 35536 – Optimize fetchParnterStats() - fix N+1 query issues Performance improvements: ...

amit — Thu, 08 Jan 2026 16:53:05 +0530

amit – 6 file(s) modified
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

Rev 35535 – Fix: Use camelCase for jQuery data attribute access (fofoId instead ...

amit — Wed, 07 Jan 2026 18:27:42 +0530

amit – 1 file(s) modified
Fix: Use camelCase for jQuery data attribute access (fofoId instead of fofo-id)

~ /trunk/profitmandi-fofo/src/main/webapp/resources/js/sd-credit.js

Rev 35534 – Add credit blocked exception button to SD Credit page ...

amit — Wed, 07 Jan 2026 15:22:35 +0530

amit – 3 file(s) modified
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/resources/js/sd-credit.js
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/sd-credit-requirement-row.vm

Rev 35533 – Fixed AppConfig

amit — Wed, 07 Jan 2026 13:17:37 +0530

amit – 2 file(s) modified
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

Rev 35532 – Added migration for 2 parties for gold

amit — Wed, 07 Jan 2026 10:26:16 +0530

amit – 1 file(s) modified
Added migration for 2 parties for gold

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/Application.java

Rev 35531 – Add manual partner type upgrade detection in rolloutMarginForStoreOnMonth - ...

amit — Wed, 07 Jan 2026 10:15:29 +0530

amit – 1 file(s) modified
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

Rev 35530 – Added migration for 2 parties for gold

amit — Wed, 07 Jan 2026 09:44:31 +0530

amit – 1 file(s) modified
Added migration for 2 parties for gold

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 35529 – lead repo done

ranu — Tue, 06 Jan 2026 18:59:30 +0530

ranu – 2 file(s) modified
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

Rev 35528 – content pojo chwcking

ranu — Tue, 06 Jan 2026 17:59:41 +0530

ranu – 2 file(s) modified
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

Rev 35527 – lead repo done

ranu — Tue, 06 Jan 2026 17:52:53 +0530

ranu – 1 file(s) modified
lead repo done

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/dtr/Mongo.java

Rev 35526 – lead repo done

ranu — Tue, 06 Jan 2026 17:45:22 +0530

ranu – 1 file(s) modified
lead repo done

~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/content.vm

Rev 35525 – content exception added

ranu — Tue, 06 Jan 2026 17:41:16 +0530

ranu – 2 file(s) modified
content exception added

~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ContentController.java
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/content.vm

Rev 35524 – Added migration for 2 parties for gold

amit — Tue, 06 Jan 2026 17:36:52 +0530

amit – 2 file(s) modified
Added migration for 2 parties for gold

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/Application.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 35523 – lead repo done

ranu — Tue, 06 Jan 2026 17:22:40 +0530

ranu – 1 file(s) modified
lead repo done

~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ContentController.java

Rev 35522 – Added migration for 2 parties for gold

amit — Tue, 06 Jan 2026 16:51:59 +0530

amit – 1 file(s) modified
Added migration for 2 parties for gold

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledSkeleton.java

Rev 35521 – Added migration for 2 parties for gold

amit — Tue, 06 Jan 2026 16:49:46 +0530

amit – 2 file(s) modified
Added migration for 2 parties for gold

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/Application.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 35520 – Fixed method Number to comma for Cr. Values

amit — Tue, 06 Jan 2026 16:36:33 +0530

amit – 1 file(s) modified
Fixed method Number to comma for Cr. Values

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/Application.java

Rev 35519 – lead repo done

ranu — Tue, 06 Jan 2026 16:12:33 +0530

ranu – 1 file(s) modified
lead repo done

~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/content.vm

Rev 35518 – lead repo done

ranu — Tue, 06 Jan 2026 16:11:24 +0530

ranu – 1 file(s) modified
lead repo done

~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/content.vm

Rev 35517 – Fix:Update Brand Market Share and give status wise filter for ...

aman — Mon, 05 Jan 2026 18:38:19 +0530

aman – 4 file(s) modified
Fix:Update Brand Market Share and give status wise filter for trial users

~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/TrialController.java
~ /trunk/profitmandi-fofo/src/main/webapp/resources/js/trial-form.js
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/all-trial-form.vm
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/dashboard-modal.vm

Rev 35516 – Fix:Update Contact list

aman — Mon, 05 Jan 2026 15:50:12 +0530

aman – 1 file(s) modified
Fix:Update Contact list

~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/contact-us.vm

Rev 35515 – Fix:Update Contact list

aman — Mon, 05 Jan 2026 15:41:00 +0530

aman – 1 file(s) modified
Fix:Update Contact list

~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/contact-us.vm

Rev 35514 – Fix getMobileLMPGraph 414 error - convert GET to POST ...

amit — Sun, 04 Jan 2026 21:16:54 +0530

amit – 2 file(s) modified
Fix getMobileLMPGraph 414 error - convert GET to POST

- Changed /getMobileLMPGraph from GET with @RequestParam to POST with @RequestBody
- Updated frontend to use doPostAjaxRequestWithJsonHandler instead of doGetAjaxRequestHandler
- Reuses LMSGraphRequest model for request body (same as getMobileLMSGraph)
- Fixes 414 Request-URI Too Large error when many fofoIds are passed

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>

~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/DashboardController.java
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/chart-filter-lms.vm

Rev 35513 – Fixed method Number to comma for Cr. Values

amit — Wed, 31 Dec 2025 22:23:40 +0530

amit – 1 file(s) modified
Fixed method Number to comma for Cr. Values

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/UserWalletHistoryRepositoryImpl.java

Rev 35512 – Fix NonUniqueResultException in selectPartnerType - handle multiple records (CALCULATED + ...

amit — Wed, 31 Dec 2025 18:01:05 +0530

amit – 1 file(s) modified
Fix NonUniqueResultException in selectPartnerType - handle multiple records (CALCULATED + MANUAL) for same date by ordering by id DESC

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/PartnerTypeChangeRepositoryImpl.java

Rev 35511 – Fixed method Number to comma for Cr. Values

amit — Wed, 31 Dec 2025 16:37:13 +0530

amit – 1 file(s) modified
Fixed method Number to comma for Cr. Values

~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/config/AppConfig.java

Rev 35510 – Fixed method Number to comma for Cr. Values

amit — Wed, 31 Dec 2025 16:36:02 +0530

amit – 1 file(s) modified
Fixed method Number to comma for Cr. Values

~ /trunk/profitmandi-fofo/src/main/webapp/resources/js/common.js