WebSVN RSS feed – SmartDukaanThu, 14 May 2026 14:09:17 +0530WebSVN 2.8.6-DEVenhttps://svn.smartdukaan.com/log.php?repname=SmartDukaan&path=%2F%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fjava%2Fcom%2Fspice%2Fprofitmandi%2Fservice%2FPartnerStatsService.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=%2F%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fjava%2Fcom%2Fspice%2Fprofitmandi%2Fservice%2FPartnerStatsService.java&rev=35537https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2F%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fjava%2Fcom%2Fspice%2Fprofitmandi%2Fservice%2FPartnerStatsService.java&rev=35537 Wed, 18 Mar 2020 17:04:14 +0530amit.gupta<div><strong>amit.gupta – 3 file(s) modified</strong><br/>Fixed partner detail stats cache</div>~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/PartnerInvestmentServiceImpl.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=%2F%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fjava%2Fcom%2Fspice%2Fprofitmandi%2Fservice%2FPartnerStatsService.java&rev=26461https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2F%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fjava%2Fcom%2Fspice%2Fprofitmandi%2Fservice%2FPartnerStatsService.java&rev=26461 Wed, 18 Mar 2020 16:48:55 +0530amit.gupta<div><strong>amit.gupta – 10 file(s) modified</strong><br/></div>~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/PartnerDetailModel.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/CsService.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/CsServiceImpl.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/TicketRepository.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/TicketRepositoryImpl.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 />~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/DashboardController.java<br />~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ReportsController.java<br />~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/admin.vm<br />https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2F%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fjava%2Fcom%2Fspice%2Fprofitmandi%2Fservice%2FPartnerStatsService.java&rev=26460https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2F%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fjava%2Fcom%2Fspice%2Fprofitmandi%2Fservice%2FPartnerStatsService.java&rev=26460