/**
   * Procédure permettant de récupérer l'objet de gestion déjà créé lors du prélèvement d'une autre
   * facture
   *
   * @param mlList La liste des lignes d'écriture de facture à prélever
   * @param ml Une ligne d'écriture de facture ) prélever
   * @return L'objet de gestion trouvé
   */
  public DirectDebitManagement getDirectDebitManagement(
      List<MoveLine> moveLineList, MoveLine ml, long directDebitManagementMaxId) {

    Partner partner = ml.getPartner();

    log.debug("Récupération de l'objet de prélèvement du tiers {}", partner.getFullName());

    List<MoveLine> moveLineListResult =
        moveLineRepo
            .all()
            .filter("self IN (?1) and self.partner = ?2", moveLineList, partner)
            .fetch();

    for (MoveLine moveLine : moveLineListResult) {
      Invoice invoice = cfonbExportService.getInvoice(moveLine);

      DirectDebitManagement directDebitManagement = invoice.getDirectDebitManagement();
      if (directDebitManagement != null
          && directDebitManagement.getId() > directDebitManagementMaxId) {

        log.debug("Objet de prélèvement trouvé : {} pour le tiers {}", partner.getFullName());
        return invoice.getDirectDebitManagement();
      }
    }

    log.debug("Aucun objet de prélèvement trouvé pour le tiers {}", partner.getFullName());

    return null;
  }
コード例 #2
0
  @Override
  protected void process() {

    for (Invoice invoice : invoices(batch.getInvoiceBatch(), true)) {

      try {

        invoiceService.validate(invoiceRepo.find(invoice.getId()));
        updateInvoice(invoiceRepo.find(invoice.getId()));

      } catch (AxelorException e) {

        TraceBackService.trace(
            new AxelorException(
                String.format(I18n.get("Facture") + " %s", invoice.getInvoiceId()),
                e,
                e.getcategory()),
            IException.INVOICE_ORIGIN,
            batch.getId());
        incrementAnomaly();

      } catch (Exception e) {

        TraceBackService.trace(
            new Exception(String.format(I18n.get("Facture") + " %s", invoice.getInvoiceId()), e),
            IException.INVOICE_ORIGIN,
            batch.getId());
        incrementAnomaly();

      } finally {

        JPA.clear();
      }
    }
  }
  public void testBankDetails(Invoice invoice) throws AxelorException {
    BankDetails bankDetails = partnerService.getDefaultBankDetails(invoice.getPartner());

    if (bankDetails == null) {
      throw new AxelorException(
          String.format(
              I18n.get(IExceptionMessage.PAYMENT_SCHEDULE_2),
              GeneralServiceImpl.EXCEPTION,
              invoice.getPartner().getName()),
          IException.CONFIGURATION_ERROR);
    } else {
      cfonbExportService.testBankDetailsField(bankDetails);
    }
  }
  /**
   * Methode permettant de mettre à jour les informations de la facture
   *
   * @param moveLine
   * @param paymentMove
   * @param pse
   * @param mlList
   * @return
   * @throws AxelorException
   */
  public Invoice updateInvoice(
      MoveLine moveLine,
      Move paymentMove,
      List<MoveLine> mlList,
      BigDecimal amountExported,
      long directDebitManagementMaxId)
      throws AxelorException {

    Invoice invoice = cfonbExportService.getInvoice(moveLine);

    this.testBankDetails(invoice);

    Company company = invoice.getCompany();

    // Mise à jour du champ 'Ecriture de paiement' sur la facture
    log.debug(
        "generateAllExportInvoice - Mise à jour du champ 'Ecriture de paiement' sur la facture");
    invoice.setPaymentMove(paymentMove);

    // Mise à jour du montant prélever
    invoice.setDirectDebitAmount(amountExported);

    // Mise à jour du Numéro de prélèvement sur la facture
    log.debug("Mise à jour du Numéro de prélèvement sur la facture");

    if (this.hasOtherInvoice(mlList, moveLine)) {
      DirectDebitManagement directDebitManagement =
          this.getDirectDebitManagement(mlList, moveLine, directDebitManagementMaxId);
      if (directDebitManagement == null) {
        directDebitManagement =
            this.createDirectDebitManagement(this.getDirectDebitSequence(company), company);
      }
      invoice.setDirectDebitManagement(directDebitManagement);
      invoice.setDebitNumber(null);
      directDebitManagement.getInvoiceSet().add(invoice);
      directDebitManagementRepo.save(directDebitManagement);
    } else {
      invoice.setDebitNumber(this.getDirectDebitSequence(company));
      invoice.setDirectDebitManagement(null);
    }
    return invoice;
  }
  public List<MoveLine> getInvoiceToExport(
      Company company, LocalDate scheduleDate, Currency currency) {

    List<MoveLine> moveLineInvoiceList = new ArrayList<MoveLine>();

    PaymentMode paymentMode = company.getAccountConfig().getDirectDebitPaymentMode();

    /**
     * Selection des lignes d'écritures dont : - l'état est validé - la société est celle
     * selectionnée sur l'objet export - le compte est lettrable - le montant restant à payer est
     * supérieur à 0 et débit supérieur à 0 (équivaut à une facture et non un avoir) - le mode de
     * règlement de la facture est en prélèvement - la date d'échéance est passée - la facture est
     * remplie sur l'écriture - la facture n'est pas selectionnée sur un échéancier
     */
    List<MoveLine> moveLineList =
        moveLineRepo
            .all()
            .filter(
                "self.move.statusSelect = ?1 AND self.exportedDirectDebitOk = 'false' "
                    + "AND self.move.company = ?2 "
                    + "AND self.account.reconcileOk = ?3 AND self.amountRemaining > 0 "
                    + "AND self.debit > 0 "
                    + "AND self.dueDate <= ?5 AND self.move.invoice IS NOT NULL "
                    + "AND self.move.invoice.paymentMode = ?4 "
                    + "AND self.move.invoice.schedulePaymentOk = 'false' "
                    + "AND self.move.invoice.currency = ?5",
                MoveRepository.STATUS_VALIDATED,
                company,
                true,
                paymentMode,
                currency)
            .fetch();

    // Ajout des factures
    for (MoveLine moveLine : moveLineList) {
      if (!this.isDebitBlocking(moveLine.getMove().getInvoice())) {
        moveLineInvoiceList.add(moveLine);
      }
    }

    // Récupération des factures rejetées
    List<Invoice> invoiceRejectList =
        invoiceRepo
            .all()
            .filter(
                "self.rejectMoveLine IS NOT NULL AND self.rejectMoveLine.amountRemaining > 0 AND self.rejectMoveLine.debit > 0"
                    + " AND self.paymentMode = ?1 AND self.company = ?2 AND self.rejectMoveLine.exportedDirectDebitOk = 'false' AND self.move.statusSelect = ?3"
                    + " AND self.rejectMoveLine.account.reconcileOk = 'true' "
                    + " AND self.rejectMoveLine.invoiceReject IS NOT NULL"
                    + " AND self.currency = ?4",
                paymentMode,
                company,
                MoveRepository.STATUS_VALIDATED,
                currency)
            .fetch();

    // Ajout des factures rejetées
    for (Invoice invoice : invoiceRejectList) {

      if (!this.isDebitBlocking(invoice)) {
        moveLineInvoiceList.add(invoice.getRejectMoveLine());
      }
    }

    return moveLineInvoiceList;
  }
  public boolean isDebitBlocking(Invoice invoice) {

    return blockingService.isDebitBlockingBlocking(invoice.getPartner(), invoice.getCompany());
  }