WebSVN RSS feed – SmartDukaanTue, 06 Oct 2026 19:09:05 +0530WebSVN 2.8.6-DEVenhttps://svn.smartdukaan.com/log.php?repname=SmartDukaan&path=%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fjava%2Fcom%2Fspice%2Fprofitmandi%2Fdao%2Fmodel%2FMonthlyBrandTertiaryModel.java&max=40& Fri, 14 Aug 2026 18:17:18 +0530amit<div><strong>amit – 6 file(s) modified</strong><br/>Fix partner-performance tertiary: aggregate order items (qty*mop), not the POS-typed order header<br /> <br /> The tertiary panel summed fofo_order.total_amount - a price typed at the partner POS<br /> and never validated against the catalogue - and attributed each whole order to its<br /> first line item's brand via .get(0). One mistyped digit inflated reported sell-out<br /> 10x, and mixed-brand orders booked 100% to the first brand, leaving the rest at zero.<br /> Defect dates from r32000/r32034 (May 2023); the panel was the only tertiary consumer<br /> diverging from the qty*mop basis.<br /> <br /> - New FofoOrder.selectMonthlyBrandTertiary: sum(quantity*mop) grouped by<br /> (year*100+month) and item brand - the same basis selectPartnerTertiarySales<br /> already uses for the DSR and the partner tier calculation<br /> - PerformanceController: replaces two entity-loading queries (every FofoOrder and<br /> FofoOrderItem for 6 months) with one aggregate; all items now count, each under<br /> its own brand<br /> - Month labels unchanged - toMonthLabel rebuilds the MMM''uu key, template untouched<br /> - Remove V2FofoPerformanceController, the /v2/fofo JSON copy carrying the same defect<br /> <br /> Verified against dev DB for fofo_id 175139501: Jul 2026 now 16,94,939 (panel<br /> previously showed 50,92,440); all six months match the qty*mop basis.</div>~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/FofoOrder.java<br />+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/MonthlyBrandTertiaryModel.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/FofoOrderRepository.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/FofoOrderRepositoryImpl.java<br />~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/PerformanceController.java<br />x /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/v2/controller/fofo/V2FofoPerformanceController.java<br />https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fjava%2Fcom%2Fspice%2Fprofitmandi%2Fdao%2Fmodel%2FMonthlyBrandTertiaryModel.java&rev=37319https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fjava%2Fcom%2Fspice%2Fprofitmandi%2Fdao%2Fmodel%2FMonthlyBrandTertiaryModel.java&rev=37319