Subversion Repositories SmartDukaan

Rev

Rev 37519 | Rev 37586 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 37519 Rev 37533
Line 716... Line 716...
716 
        q.setParameter("refDate", refDate);
 716 
        q.setParameter("refDate", refDate);
717 
        return q.getResultList();
 717 
        return q.getResultList();
718 
    }
 718 
    }
719 
 
 719 
 
720 
    @Override
 720 
    @Override
- 
 
 721 
    public List<com.spice.profitmandi.dao.model.SalesHierarchyBrandSoldModel>
- 
 
 722 
    getSalesBrandsSold(Collection<Integer> authIds, int warehouseId, LocalDate startDate, LocalDate endDate) {
- 
 
 723 
        if (authIds == null || authIds.isEmpty()) return new ArrayList<>();
- 
 
 724 
        Session session = sessionFactory.getCurrentSession();
- 
 
 725 
        TypedQuery<com.spice.profitmandi.dao.model.SalesHierarchyBrandSoldModel> q =
- 
 
 726 
                session.createNamedQuery("RbmDrr.SalesBrandSold",
- 
 
 727 
                        com.spice.profitmandi.dao.model.SalesHierarchyBrandSoldModel.class);
- 
 
 728 
        q.setParameter("authIds", authIds);
- 
 
 729 
        q.setParameter("warehouseId", warehouseId);
- 
 
 730 
        q.setParameter("startDate", startDate);
- 
 
 731 
        q.setParameter("endDate", endDate);
- 
 
 732 
        return q.getResultList();
- 
 
 733 
    }
- 
 
 734 
 
- 
 
 735 
    @Override
- 
 
 736 
    public List<com.spice.profitmandi.dao.model.SalesHierarchyBrandPartnerCountModel>
- 
 
 737 
    getSalesBrandPartnerCount(Collection<Integer> authIds, int warehouseId, LocalDate startDate, LocalDate endDate) {
- 
 
 738 
        if (authIds == null || authIds.isEmpty()) return new ArrayList<>();
- 
 
 739 
        Session session = sessionFactory.getCurrentSession();
- 
 
 740 
        TypedQuery<com.spice.profitmandi.dao.model.SalesHierarchyBrandPartnerCountModel> q =
- 
 
 741 
                session.createNamedQuery("RbmDrr.SalesBrandPartnerCount",
- 
 
 742 
                        com.spice.profitmandi.dao.model.SalesHierarchyBrandPartnerCountModel.class);
- 
 
 743 
        q.setParameter("authIds", authIds);
- 
 
 744 
        q.setParameter("warehouseId", warehouseId);
- 
 
 745 
        q.setParameter("startDate", startDate);
- 
 
 746 
        q.setParameter("endDate", endDate);
- 
 
 747 
        return q.getResultList();
- 
 
 748 
    }
- 
 
 749 
 
- 
 
 750 
    @Override
721 
    public void setSalesAchievements() {
 751 
    public void setSalesAchievements() {
722 
        setSalesAchievementsForDate(LocalDate.now());
 752 
        setSalesAchievementsForDate(LocalDate.now());
723 
    }
 753 
    }
724 
 
 754 
 
725 
    @Override
 755 
    @Override