WebSVN RSS feed – SmartDukaanWed, 13 May 2026 23:54:35 +0530WebSVN 2.8.6-DEVenhttps://svn.smartdukaan.com/log.php?repname=SmartDukaan&path=%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fjava%2Fcom%2Fspice%2Fprofitmandi%2Fdao%2Fmodel%2FPartnerTertiarySalesModel.java&max=40& Thu, 08 Jan 2026 23:58:50 +0530amit<div><strong>amit – 6 file(s) modified</strong><br/>Optimize getAllPartnerStats: combine 5 tertiary queries into 1 using CASE WHEN pattern<br /> <br /> - Added PartnerTertiarySalesModel to hold combined tertiary data<br /> - Added FofoOrder.selectPartnerTertiarySales named query using CASE WHEN<br /> - Added selectPartnerTertiarySales() batch method in FofoOrderItemRepository<br /> - Updated PartnerStatsServiceImpl to use single combined query<br /> - Reduces 5 DB queries to 1 for tertiary sales data (lmtd, mtd, lms, today, last3days)</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/PartnerTertiarySalesModel.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/FofoOrderItemRepository.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/FofoOrderItemRepositoryImpl.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/PartnerStatsService.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/PartnerStatsServiceImpl.java<br />https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fjava%2Fcom%2Fspice%2Fprofitmandi%2Fdao%2Fmodel%2FPartnerTertiarySalesModel.java&rev=35537https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fjava%2Fcom%2Fspice%2Fprofitmandi%2Fdao%2Fmodel%2FPartnerTertiarySalesModel.java&rev=35537