Examples with Period com.axelor.apps.base.db.Period used on opensource projects

Example 16 with Period

use of com.axelor.apps.base.db.Period in project axelor-open-suite by axelor.

the class YearServiceAccountImpl method closeYearProcess.

/**
 * Procédure permettant de cloturer un exercice comptable
 *
 * @param year Un exercice comptable
 * @throws AxelorException
 */
public void closeYearProcess(Year year) throws AxelorException {
    year = yearRepository.find(year.getId());
    for (Period period : year.getPeriodList()) {
        if (period.getStatusSelect() == PeriodRepository.STATUS_ADJUSTING) {
            adjustHistoryService.setEndDate(period);
        }
        period.setStatusSelect(PeriodRepository.STATUS_CLOSED);
        period.setClosureDateTime(LocalDateTime.now());
    }
    Company company = year.getCompany();
    if (company == null) {
        throw new AxelorException(year, TraceBackRepository.CATEGORY_CONFIGURATION_ERROR, I18n.get(IExceptionMessage.YEAR_1), I18n.get(com.axelor.apps.base.exceptions.IExceptionMessage.EXCEPTION), year.getName());
    }
    Query q;
    if (year.getStatusSelect() == YearRepository.STATUS_ADJUSTING) {
        AdjustHistory adjustHistory = adjustHistoryService.setEndDate(year);
        q = JPA.em().createQuery("select DISTINCT(self.partner) FROM MoveLine as self WHERE self.move.ignoreInAccountingOk = false AND self.move.period.year = ?1 " + "AND self.move.statusSelect = ?2 AND self.move.adjustingMove = true AND self.date >= ?3 AND self.date <= ?4 AND self.move.company = ?5");
        q.setParameter(1, year);
        q.setParameter(2, MoveRepository.STATUS_VALIDATED);
        q.setParameter(3, adjustHistory.getStartDate().toLocalDate());
        q.setParameter(4, adjustHistory.getEndDate().toLocalDate());
    } else {
        q = JPA.em().createQuery("select DISTINCT(self.partner) FROM MoveLine as self WHERE self.move.ignoreInAccountingOk = false AND self.move.period.year = ?1 " + "AND self.move.statusSelect = ?2 AND self.date >= ?3 AND self.date <= ?4 AND self.move.company = ?5");
        q.setParameter(1, year);
        q.setParameter(2, MoveRepository.STATUS_VALIDATED);
        q.setParameter(3, year.getFromDate());
        q.setParameter(4, year.getToDate());
    }
    q.setParameter(5, year.getCompany());
    @SuppressWarnings("unchecked") List<Partner> partnerList = q.getResultList();
    List<? extends Partner> partnerListAll = partnerRepository.all().fetch();
    log.debug("Nombre total de tiers : {}", partnerListAll.size());
    log.debug("Nombre de tiers récupéré : {}", partnerList.size());
    for (Partner partner : partnerList) {
        partner = partnerRepository.find(partner.getId());
        year = yearRepository.find(year.getId());
        log.debug("Tiers en cours de traitement : {}", partner.getName());
        for (AccountingSituation accountingSituation : partner.getAccountingSituationList()) {
            if (accountingSituation.getCompany().equals(year.getCompany())) {
                log.debug("On ajoute une ligne à la Situation comptable trouvée");
                BigDecimal reportedBalanceAmount = this.computeReportedBalance(year.getFromDate(), year.getToDate(), partner, year);
                this.createReportedBalanceLine(accountingSituation, reportedBalanceAmount, year);
                break;
            }
        }
        JPA.clear();
    }
    year = yearRepository.find(year.getId());
    closeYear(year);
}

Example 17 with Period

use of com.axelor.apps.base.db.Period in project axelor-open-suite by axelor.

the class SopServiceImpl method generateSOPLines.

@Override
public void generateSOPLines(Sop sop) throws AxelorException {
    today = appBaseService.getTodayDate(sop.getCompany());
    List<Period> yearPeriods = periodRepo.all().filter("self.year = :year AND self.statusSelect = :status").bind("year", sop.getYear()).bind("status", PeriodRepository.STATUS_OPENED).fetch();
    List<SopLine> sopLineList = new ArrayList<SopLine>();
    for (Period period : yearPeriods) {
        sopLineList.add(this.createSOPLine(sop, period));
    }
    this.linkSOPLines(sop, sopLineList);
    this.updateSOPLines(sop);
}