Subversion Repositories SmartDukaan

Rev

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

Rev 33985 Rev 33991
Line 71... Line 71...
71 
 
 71 
 
72 
        return typedQuerySimilar.getResultList();
 72 
        return typedQuerySimilar.getResultList();
73 
 
 73 
 
74 
    }
 74 
    }
75 
 
 75 
 
- 
 
 76 
    @Override
- 
 
 77 
    public List<SoldCatalogsReportModel> getCatalogSoldReport(LocalDate startDate, LocalDate endDate) {
- 
 
 78 
        Session session = sessionFactory.getCurrentSession();
- 
 
 79 
        final TypedQuery<SoldCatalogsReportModel> typedQuerySimilar = session.createNamedQuery("CatalogsReport.SoldCatalogsReport", SoldCatalogsReportModel.class);
- 
 
 80 
        typedQuerySimilar.setParameter("startDate", startDate);
- 
 
 81 
        typedQuerySimilar.setParameter("endDate", endDate);
- 
 
 82 
        return typedQuerySimilar.getResultList();
- 
 
 83 
 
- 
 
 84 
    }
- 
 
 85 
 
76 
 
 86 
 
77 
    public int getWorkingDaysCount(LocalDate startDate) {
 87 
    public int getWorkingDaysCount(LocalDate startDate) {
78 
        Session session = sessionFactory.getCurrentSession();
 88 
        Session session = sessionFactory.getCurrentSession();
79 
 
 89 
 
80 
        // Convert the LocalDate to a format MySQL can interpret
 90 
        // Convert the LocalDate to a format MySQL can interpret