Examples with ReportingPeriod org.activityinfo.server.database.hibernate.entity.ReportingPeriod used on opensource projects

Example 1 with ReportingPeriod

use of org.activityinfo.server.database.hibernate.entity.ReportingPeriod in project activityinfo by bedatadriven.

the class GetMonthlyReportsHandler method execute.

@Override
public CommandResult execute(GetMonthlyReports cmd, User user) throws CommandException {
    List<ReportingPeriod> periods = em.createQuery("select p from ReportingPeriod p where p.site.id = ?1").setParameter(1, cmd.getSiteId()).getResultList();
    List<Indicator> indicators = em.createQuery("select i from Indicator i where i.activity.id =" + "(select s.activity.id from Site s where s.id = ?1)").setParameter(1, cmd.getSiteId()).getResultList();
    List<IndicatorRowDTO> list = new ArrayList<IndicatorRowDTO>();
    for (Indicator indicator : indicators) {
        IndicatorRowDTO dto = new IndicatorRowDTO();
        dto.setIndicatorId(indicator.getId());
        dto.setSiteId(cmd.getSiteId());
        dto.setIndicatorName(indicator.getName());
        for (ReportingPeriod period : periods) {
            Month month = HandlerUtil.monthFromRange(period.getDate1(), period.getDate2());
            if (month != null && month.compareTo(cmd.getStartMonth()) >= 0 && month.compareTo(cmd.getEndMonth()) <= 0) {
                for (IndicatorValue value : period.getIndicatorValues()) {
                    if (value.getIndicator().getId() == indicator.getId()) {
                        dto.setValue(month, value.getValue());
                    }
                }
            }
        }
        list.add(dto);
    }
    return new MonthlyReportResult(list);
}

Example 2 with ReportingPeriod

use of org.activityinfo.server.database.hibernate.entity.ReportingPeriod in project activityinfo by bedatadriven.

the class UpdateMonthlyReportsHandler method execute.

@Override
public CommandResult execute(UpdateMonthlyReports cmd, User user) throws CommandException {
    Site site = em.find(Site.class, cmd.getSiteId());
    if (site == null) {
        throw new CommandException(cmd, "site " + cmd.getSiteId() + " not found for user " + user.getEmail());
    }
    Map<Month, ReportingPeriod> periods = Maps.newHashMap();
    Map<String, Object> siteHistoryChangeMap = createChangeMap();
    for (ReportingPeriod period : site.getReportingPeriods()) {
        periods.put(HandlerUtil.monthFromRange(period.getDate1(), period.getDate2()), period);
    }
    for (UpdateMonthlyReports.Change change : cmd.getChanges()) {
        ReportingPeriod period = periods.get(change.getMonth());
        if (period == null) {
            period = new ReportingPeriod(site);
            period.setId(keyGenerator.generateInt());
            Calendar calendar = Calendar.getInstance();
            calendar.set(Calendar.YEAR, change.getMonth().getYear());
            calendar.set(Calendar.MONTH, change.getMonth().getMonth() - 1);
            calendar.set(Calendar.DATE, 1);
            period.setDate1(calendar.getTime());
            calendar.set(Calendar.DATE, calendar.getActualMaximum(Calendar.DATE));
            period.setDate2(calendar.getTime());
            em.persist(period);
            periods.put(change.getMonth(), period);
        }
        updateIndicatorValue(em, period, change.getIndicatorId(), change.getValue(), false);
        siteHistoryChangeMap.put(IndicatorDTO.getPropertyName(change.getIndicatorId(), change.getMonth()), change.getValue());
    }
    siteHistoryProcessor.persistHistory(site, user, ChangeType.UPDATE, siteHistoryChangeMap);
    return new VoidResult();
}