| Rev |
Age |
Author |
Path |
Log message |
Diff |
| 37943 |
3 d 20 h |
amit |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ |
Store status: readers use store_status instead of the active / closed columns
- HQL named queries and repository lookups: active = ACTIVE + PAUSED, inactive = SUSPENDED + CLOSED,
not closed = store_status <> CLOSED
- Native SQL report / snapshot / ageing / delist queries moved to fofo_store.store_status
- PAUSED stores now count as active everywhere (incl. the internal stores whose active column is still 0) |
|
| 37319 |
73 d 13 h |
amit |
/trunk/ |
Fix partner-performance tertiary: aggregate order items (qty*mop), not the POS-typed order header
The tertiary panel summed fofo_order.total_amount - a price typed at the partner POS
and never validated against the catalogue - and attributed each whole order to its
first line item's brand via .get(0). One mistyped digit inflated reported sell-out
10x, and mixed-brand orders booked 100% to the first brand, leaving the rest at zero.
Defect dates from r32000/r32034 (May 2023); the panel was the only tertiary consumer
diverging from the qty*mop basis.
- New FofoOrder.selectMonthlyBrandTertiary: sum(quantity*mop) grouped by
(year*100+month) and item brand - the same basis selectPartnerTertiarySales
already uses for the DSR and the partner tier calculation
- PerformanceController: replaces two entity-loading queries (every FofoOrder and
FofoOrderItem for 6 months) with one aggregate; all items now count, each under
its own brand
- Month labels unchanged - toMonthLabel rebuilds the MMM''uu key, template untouched
- Remove V2FofoPerformanceController, the /v2/fofo JSON copy carrying the same defect
Verified against dev DB for fofo_id 175139501: Jul 2026 now 16,94,939 (panel
previously showed 50,92,440); all six months match the qty*mop basis. |
|
| 36586 |
161 d 20 h |
aman |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ |
Fix:Restructure mail send |
|
| 36571 |
163 d 17 h |
amit |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/ |
fix: add transient orderItems list field to FofoOrder for order creation response |
|
| 36513 |
169 d 14 h |
amit |
/trunk/ |
Add running_balance to userwallethistory: persist wallet balance after each transaction for instant ledger display. Populate at all write paths (WalletService, adjustTransaction). Read directly in wallet statement template and CSV download. Includes backfill migration SQL. Renamed walletSummart to walletSummary. |
|
| 35537 |
291 d 8 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) |
|
| 35184 |
378 d 14 h |
vikas |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/ |
Oppo Activation Number On Graph |
|
| 34490 |
546 d 12 h |
ranu |
/trunk/ |
get code for dashboard |
|
| 34412 |
563 d 12 h |
ranu |
/trunk/ |
sales and stock and summry updated |
|
| 34390 |
566 d 11 h |
tejus.lohani |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/ |
fix |
|
| 34384 |
567 d 15 h |
ranu |
/trunk/ |
additional point in annalysis model |
|
| 34287 |
595 d 13 h |
vikas.jangra |
/trunk/ |
Download Invoice Issue |
|
| 34121 |
654 d 12 h |
ranu |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/ |
foco sales report added customer name |
|
| 34066 |
677 d 12 h |
aman.kumar |
/trunk/ |
Partner Report access to rbm team |
|
| 34011 |
697 d 16 h |
tejus.lohani |
/trunk/ |
bug fix in wallet statement report |
|
| 33873 |
741 d 7 h |
ranu |
/trunk/ |
smart cart first phase updated |
|
| 33177 |
936 d 13 h |
tejus.lohani |
/trunk/ |
Fix quantity and serial number related issue in salas report |
|
| 32907 |
997 d 23 h |
amit.gupta |
/trunk/ |
Added PO Autocolose in scheduler |
|
| 32906 |
998 d 12 h |
amit.gupta |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/ |
Fixed changes added new fields |
|
| 32044 |
1252 d 20 h |
tejbeer |
/trunk/ |
change |
|