IrrecoverableService.java

/**
 * Axelor Business Solutions
 *
 * Copyright (C) 2016 Axelor (<http://axelor.com>).
 *
 * This program is free software: you can redistribute it and/or  modify
 * it under the terms of the GNU Affero General Public License, version 3,
 * as published by the Free Software Foundation.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */
package com.axelor.apps.account.service;

import java.math.BigDecimal;
import java.math.RoundingMode;
import java.util.ArrayList;
import java.util.HashSet;
import java.util.List;
import java.util.Set;

import javax.persistence.EntityTransaction;

import org.joda.time.LocalDate;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import com.axelor.apps.account.db.Account;
import com.axelor.apps.account.db.AccountConfig;
import com.axelor.apps.account.db.Invoice;
import com.axelor.apps.account.db.InvoiceLine;
import com.axelor.apps.account.db.InvoiceLineTax;
import com.axelor.apps.account.db.Irrecoverable;
import com.axelor.apps.account.db.IrrecoverableCustomerLine;
import com.axelor.apps.account.db.IrrecoverableInvoiceLine;
import com.axelor.apps.account.db.IrrecoverablePaymentScheduleLineLine;
import com.axelor.apps.account.db.IrrecoverableReportLine;
import com.axelor.apps.account.db.ManagementObject;
import com.axelor.apps.account.db.Move;
import com.axelor.apps.account.db.MoveLine;
import com.axelor.apps.account.db.PaymentSchedule;
import com.axelor.apps.account.db.PaymentScheduleLine;
import com.axelor.apps.account.db.Reconcile;
import com.axelor.apps.account.db.Tax;
import com.axelor.apps.account.db.repo.InvoiceRepository;
import com.axelor.apps.account.db.repo.IrrecoverableCustomerLineRepository;
import com.axelor.apps.account.db.repo.IrrecoverableRepository;
import com.axelor.apps.account.db.repo.ManagementObjectRepository;
import com.axelor.apps.account.db.repo.MoveLineRepository;
import com.axelor.apps.account.db.repo.PaymentScheduleLineRepository;
import com.axelor.apps.account.db.repo.PaymentScheduleRepository;
import com.axelor.apps.account.exception.IExceptionMessage;
import com.axelor.apps.account.service.config.AccountConfigService;
import com.axelor.apps.account.service.move.MoveLineService;
import com.axelor.apps.account.service.move.MoveService;
import com.axelor.apps.base.db.Company;
import com.axelor.apps.base.db.IAdministration;
import com.axelor.apps.base.db.Partner;
import com.axelor.apps.base.service.administration.GeneralService;
import com.axelor.apps.base.service.administration.GeneralServiceImpl;
import com.axelor.apps.base.service.administration.SequenceService;
import com.axelor.apps.base.service.tax.TaxService;
import com.axelor.db.JPA;
import com.axelor.exception.AxelorException;
import com.axelor.exception.db.IException;
import com.axelor.exception.service.TraceBackService;
import com.axelor.i18n.I18n;
import com.google.inject.Inject;
import com.google.inject.persist.Transactional;

public class IrrecoverableService{

	private final Logger log = LoggerFactory.getLogger( getClass() );

	protected SequenceService sequenceService;
	protected MoveService moveService;
	protected MoveLineService moveLineService;
	protected MoveLineRepository moveLineRepo;
	protected ReconcileService reconcileService;
	protected TaxService taxService;
	protected TaxAccountService taxAccountService;
	protected PaymentScheduleService paymentScheduleService;
	protected PaymentScheduleRepository paymentScheduleRepo;
	protected PaymentScheduleLineRepository paymentScheduleLineRepo;
	protected AccountConfigService accountConfigService;
	protected IrrecoverableCustomerLineRepository irrecoverableCustomerLineRepo;
	protected InvoiceRepository invoiceRepo;
	protected ManagementObjectRepository managementObjectRepo;
	protected IrrecoverableRepository irrecoverableRepo;

	protected LocalDate date;

	@Inject
	public IrrecoverableService(GeneralService generalService, SequenceService sequenceService, MoveService moveService, MoveLineService moveLineService, MoveLineRepository moveLineRepo,
			ReconcileService reconcileService, TaxService taxService, TaxAccountService taxAccountService, PaymentScheduleService paymentScheduleService, PaymentScheduleRepository paymentScheduleRepo,
			PaymentScheduleLineRepository paymentScheduleLineRepo, AccountConfigService accountConfigService, IrrecoverableCustomerLineRepository irrecoverableCustomerLineRepo,
			InvoiceRepository invoiceRepo, ManagementObjectRepository managementObjectRepo, IrrecoverableRepository irrecoverableRepo) {

		this.sequenceService = sequenceService;
		this.moveService = moveService;
		this.moveLineService = moveLineService;
		this.moveLineRepo = moveLineRepo;
		this.reconcileService = reconcileService;
		this.taxService = taxService;
		this.taxAccountService = taxAccountService;
		this.paymentScheduleService = paymentScheduleService;
		this.paymentScheduleRepo = paymentScheduleRepo;
		this.paymentScheduleLineRepo = paymentScheduleLineRepo;
		this.accountConfigService = accountConfigService;
		this.irrecoverableCustomerLineRepo = irrecoverableCustomerLineRepo;
		this.invoiceRepo = invoiceRepo;
		this.managementObjectRepo = managementObjectRepo;
		this.irrecoverableRepo = irrecoverableRepo;
		
		this.date = generalService.getTodayDate();

	}

	/**
	 * Procédure permettant de remplir la liste des factures et échéances rejetées à passer en irrécouvrable d'une société,
	 * ansi que de remplir le champ nom de l'objet irrécouvrable
	 * @param irrecoverable
	 * 			Un objet Irrécouvrable
	 * @throws AxelorException
	 */
	@Transactional(rollbackOn = {AxelorException.class, Exception.class})
	public void getIrrecoverable(Irrecoverable irrecoverable) throws AxelorException  {

		Company company = irrecoverable.getCompany();

		this.testCompanyField(company);

		if(irrecoverable.getName() == null)  {
			irrecoverable.setName(this.getSequence(company));
		}

		irrecoverable.setInvoiceSet(new HashSet<Invoice>());
		irrecoverable.getInvoiceSet().addAll(this.getInvoiceList(company));
		irrecoverable.getInvoiceSet().addAll(this.getRejectInvoiceList(company));

		irrecoverable.setPaymentScheduleLineSet(new HashSet<PaymentScheduleLine>());
		irrecoverable.getPaymentScheduleLineSet().addAll(this.getPaymentScheduleLineList(company));

		irrecoverableRepo.save(irrecoverable);
	}


	/**
	 * Fonction permettant de récupérer la liste des tiers payeur associés à une liste de factures
	 * @param invoiceList
	 * 			Une liste de factures
	 * @return
	 */
	public List<Partner> getPayerPartnerList(Set<Invoice> invoiceList)  {
		List<Partner> partnerList = new ArrayList<Partner>();

		for(Invoice invoice : invoiceList)  {
			if(!partnerList.contains(invoice.getPartner()))  {
				partnerList.add(invoice.getPartner());
			}
		}
		return partnerList;
	}


	/**
	 * Fonction permettant de récupérer la liste des factures à passer en irrécouvrable d'une société
	 * @param company
	 * 			Une société
	 * @return
	 */
	public List<Invoice> getInvoiceList(Company company)   {
		return invoiceRepo.all().filter("self.irrecoverableStateSelect = ?1 AND self.company = ?2 AND self.statusSelect = ?3 " +
				"AND self.companyInTaxTotalRemaining > 0 AND self.rejectMoveLine IS NULL ORDER BY self.dueDate ASC",
				InvoiceRepository.IRRECOVERABLE_STATUS_TO_PASS_IN_IRRECOUVRABLE, company, InvoiceRepository.STATUS_VENTILATED).fetch();
	}

	/**
	 * Fonction permettant de récupérer la liste des factures rejetées à passer en irrécouvrable d'une société
	 * @param company
	 * 			Une société
	 * @return
	 */
	public List<Invoice> getRejectInvoiceList(Company company)   {
		return invoiceRepo.all().filter("self.irrecoverableStateSelect = ?1 AND self.company = ?2 AND self.statusSelect = ?3 " +
				"AND self.companyInTaxTotalRemaining = 0 AND self.rejectMoveLine IS NOT NULL ORDER BY self.dueDate ASC",
				InvoiceRepository.IRRECOVERABLE_STATUS_TO_PASS_IN_IRRECOUVRABLE, company, InvoiceRepository.STATUS_VENTILATED).fetch();
	}


	/**
	 * Fonction permettant de récupérer la liste des échéances rejetées à passer une irrécouvrable d'une société
	 * @param company
	 * 			Une société
	 * @return
	 */
	public List<PaymentScheduleLine> getPaymentScheduleLineList(Company company)   {
		return paymentScheduleLineRepo.all()
				.filter("self.paymentSchedule.irrecoverableStateSelect = ?1 AND self.paymentSchedule.company = ?2 " +
						"AND self.paymentSchedule.stateSelect = ?3 AND self.rejectMoveLine.amountRemaining > 0 ORDER BY self.scheduleDate ASC",
						PaymentScheduleRepository.IRRECOVERABLE_STATUS_TO_PASS_IN_IRRECOUVRABLE, company, PaymentScheduleRepository.STATUS_CONFIRMED).fetch();
	}


	/**
	 * Fonction permettant de récupérer les factures à passer en irrécouvrable d'un tiers
	 * @param company
	 * 			Une société
	 * @param payerPartner
	 * 			Un tiers payeur
	 * @param allInvoiceList
	 * 			La liste des factures à passer en irrécouvrable de la société
	 * @return
	 */
	public List<Invoice> getInvoiceList(Partner partner,Set<Invoice> allInvoiceList)  {
		List<Invoice> invoiceList = new ArrayList<Invoice>();

		for(Invoice invoice : allInvoiceList)  {
			if(invoice.getPartner().equals(partner))  {
				invoiceList.add(invoice);
			}
		}

		log.debug("Nombre de facture à passer en irrécouvrable pour le tiers : {}", invoiceList.size());

		return invoiceList;
	}


	/**
	 * Fonction permettant de récupérer les échéances rejetées à passer en irrécouvrable d'un tiers
	 * @param company
	 * 			Une société
	 * @param payerPartner
	 * 			Un tiers payeur
	 * @param allPaymentScheduleLineList
	 * 			La liste des échéances rejetées à passer en irrécouvrable de la société
	 * @return
	 */
	public List<PaymentScheduleLine> getPaymentScheduleLineList(Partner payerPartner, Set<PaymentScheduleLine> allPaymentScheduleLineList)   {
		List<PaymentScheduleLine> paymentScheduleLineList = new ArrayList<PaymentScheduleLine>();

		for(PaymentScheduleLine paymentScheduleLine : allPaymentScheduleLineList)  {
			if(paymentScheduleLine.getPaymentSchedule().getPartner().equals(payerPartner))  {
				paymentScheduleLineList.add(paymentScheduleLine);
			}
		}

		log.debug("Nombre d'échéances à passer en irrécouvrable pour le tiers : {}", paymentScheduleLineList.size());

		return paymentScheduleLineList;
	}


	/**
	 * Procédure permettant de passer en irrécouvrables les factures et échéances rejetées récupéré sur l'objet Irrécouvrable
	 * @param irrecoverable
	 * 			Un objet Irrécouvrable
	 */
	@Transactional
	public void createIrrecoverableReport(Irrecoverable irrecoverable)  {

		Set<Invoice> invoiceSet = irrecoverable.getInvoiceSet();
		Set<PaymentScheduleLine> paymentScheduleLineSet = irrecoverable.getPaymentScheduleLineSet();

		irrecoverable.setMoveSet(new HashSet<Move>());

		List<Partner> payerPartnerList = this.getPayerPartnerList(invoiceSet);

		EntityTransaction transaction = JPA.em().getTransaction();

		int i = 0;
		if(payerPartnerList != null && payerPartnerList.size() != 0)  {
			for(Partner payerPartner : payerPartnerList)  {

			    if (!transaction.isActive())  {
			    	transaction.begin();
			    }

				i++;
				try {
					log.debug("Tiers : {}", payerPartner.getName());
					this.createIrrecoverableCustomerLine(
							irrecoverable,
							payerPartner,
							this.getInvoiceList(payerPartner, invoiceSet),
							this.getPaymentScheduleLineList(payerPartner, paymentScheduleLineSet));
					irrecoverableRepo.save(irrecoverable);
					transaction.commit();

					if (i % 50 == 0)  {
						JPA.flush();
						JPA.clear();
					}

				} catch (Exception e) {
					TraceBackService.trace(e);
					log.error("Bug(Anomalie) généré(e) pour le tiers : {}", payerPartner.getName());

				} finally {
					if (!transaction.isActive())  {
						transaction.begin();
					}
				}
			}
		}
	}


	/**
	 * Fonction permettant de créer une ligne Client
	 * @param irrecoverable
	 * 				Un objet Irrécouvrable
	 * @param payerPartner
	 * 				Un tiers payeur
	 * @param invoiceList
	 * 				Une liste de facture du tiers payeur
	 * @param paymentScheduleLineSet
	 * 				Une liste d'échéancier du tiers payeur
	 * @return
	 * @throws AxelorException
	 */
	@Transactional(rollbackOn = {AxelorException.class, Exception.class})
	public IrrecoverableCustomerLine createIrrecoverableCustomerLine(Irrecoverable irrecoverable, Partner payerPartner, List<Invoice> invoiceList, List<PaymentScheduleLine> paymentScheduleLineList) throws AxelorException  {
		IrrecoverableCustomerLine icl = new IrrecoverableCustomerLine();
		icl.setIrrecoverable(irrecoverable);
		irrecoverableCustomerLineRepo.save(icl);
		irrecoverable.getIrrecoverableCustomerLineList().add(icl);
		icl.setPartner(payerPartner);
		icl.setIrrecoverablePaymentScheduleLineLineList(this.createIrrecoverablePaymentScheduleLineLineList(icl, paymentScheduleLineList));
		icl.setIrrecoverableInvoiceLineList(this.createIrrecoverableInvoiceLineList(icl, invoiceList));

		log.debug("Ligne client : {}", icl);

		return icl;
	}



	/**
	 * Procédure permettant de
	 * @param irrecoverable
	 * @throws AxelorException
	 */
	public int passInIrrecoverable(Irrecoverable irrecoverable) throws AxelorException  {

		irrecoverable.setMoveSet(new HashSet<Move>());

		EntityTransaction transaction = JPA.em().getTransaction();

		int anomaly = 0;

		this.testCompanyField(irrecoverable.getCompany());

		int i = 0;
		if(irrecoverable.getInvoiceSet() != null && irrecoverable.getInvoiceSet().size() != 0)  {
			for(Invoice invoice : irrecoverable.getInvoiceSet())  {
				i++;

				if (!transaction.isActive())  {
					transaction.begin();
				}

				try {
					log.debug("Facture : {}", invoice.getInvoiceId());

					this.createIrrecoverableInvoiceLineMove(irrecoverable, invoice);

					irrecoverableRepo.save(irrecoverable);

					if (i % 50 == 0)  {
						JPA.flush();
						JPA.clear();
					}

				} catch (AxelorException e) {
					anomaly++;
					TraceBackService.trace(new AxelorException(String.format(I18n.get("Invoice")+" %s", invoice.getInvoiceId()), e, e.getcategory()), IException.IRRECOVERABLE, irrecoverable.getId());
					log.error("Bug(Anomalie) généré(e) pour la facture : {}", invoice.getInvoiceId());

				} catch (Exception e) {
					anomaly++;
					TraceBackService.trace(new Exception(String.format(I18n.get("Invoice")+" %s", invoice.getInvoiceId()), e), IException.IRRECOVERABLE, irrecoverable.getId());
					log.error("Bug(Anomalie) généré(e) pour la facture : {}", invoice.getInvoiceId());

				} finally {
					if (!transaction.isActive())  {
						transaction.begin();
					}
				}
			}
		}
		if(irrecoverable.getPaymentScheduleLineSet() != null && irrecoverable.getPaymentScheduleLineSet().size() != 0)  {
			for(PaymentScheduleLine paymentScheduleLine : irrecoverable.getPaymentScheduleLineSet())  {
				i++;

				if (!transaction.isActive())  {
					transaction.begin();
				}

				try {
					log.debug("Ligne d'échéancier : {}", paymentScheduleLine.getName());

					this.createMoveForPaymentScheduleLineReject(irrecoverable, paymentScheduleLine);

					irrecoverableRepo.save(irrecoverable);

					if (i % 50 == 0)  {
						JPA.flush();
						JPA.clear();
					}

				} catch (AxelorException e) {
					anomaly++;
					TraceBackService.trace(new AxelorException(String.format(I18n.get(IExceptionMessage.IRRECOVERABLE_1), paymentScheduleLine.getName()), e, e.getcategory()), IException.IRRECOVERABLE, irrecoverable.getId());
					log.error("Bug(Anomalie) généré(e) pour la ligne d'échéancier : {}", paymentScheduleLine.getName());

				} catch (Exception e) {
					anomaly++;
					TraceBackService.trace(new Exception(String.format(I18n.get(IExceptionMessage.IRRECOVERABLE_1), paymentScheduleLine.getName()), e), IException.IRRECOVERABLE, irrecoverable.getId());
					log.error("Bug(Anomalie) généré(e) pour la ligne d'échéancier : {}", paymentScheduleLine.getName());

				} finally {
					if (!transaction.isActive())  {
						transaction.begin();
					}
				}
			}
		}
		if (!transaction.isActive())  {
			transaction.begin();
		}
		irrecoverable.setStatusSelect(IrrecoverableRepository.STATUS_VALIDATED);
		irrecoverableRepo.save(irrecoverable);
		transaction.commit();

		return anomaly;
	}


	@Transactional(rollbackOn = {AxelorException.class, Exception.class})
	public void createMoveForPaymentScheduleLineReject(Irrecoverable irrecoverable, PaymentScheduleLine paymentScheduleLine) throws AxelorException  {

		Move move = this.createIrrecoverableMove(paymentScheduleLine.getRejectMoveLine());
		if(move == null)  {
			throw new AxelorException(String.format(I18n.get(IExceptionMessage.IRRECOVERABLE_2),
					GeneralServiceImpl.EXCEPTION), IException.INCONSISTENCY);
		}
		moveService.getMoveValidateService().validateMove(move);
		irrecoverable.getMoveSet().add(move);

	}



	@Transactional(rollbackOn = {AxelorException.class, Exception.class})
	public void createIrrecoverableInvoiceLineMove(Irrecoverable irrecoverable, Invoice invoice) throws AxelorException  {

		BigDecimal prorataRate = this.getProrataRate(invoice, invoice.getRejectMoveLine() != null);

		// Ajout de l'écriture générée
		Move move = this.createIrrecoverableMove(invoice, prorataRate, invoice.getRejectMoveLine() != null);
		if(move == null)  {
			throw new AxelorException(String.format(I18n.get(IExceptionMessage.IRRECOVERABLE_2),
					GeneralServiceImpl.EXCEPTION), IException.INCONSISTENCY);
		}
		moveService.getMoveValidateService().validateMove(move);
		irrecoverable.getMoveSet().add(move);

		invoice.setIrrecoverableStatusSelect(InvoiceRepository.IRRECOVERABLE_STATUS_PASSED_IN_IRRECOUVRABLE);

		if(invoice.getCanceledPaymentSchedule() != null && this.isAllInvoicePassedInIrrecoverable(invoice.getCanceledPaymentSchedule()))  {
			invoice.getCanceledPaymentSchedule().setIrrecoverableStatusSelect(PaymentScheduleRepository.IRRECOVERABLE_STATUS_PASSED_IN_IRRECOUVRABLE);
		}

	}


	/**
	 * Fonction permettant de créer une liste de ligne Facture
	 * @param icl
	 * 			Une ligne Client
	 * @param invoiceList
	 * 			Une liste de factures du tiers payeur
	 * @return
	 * @throws AxelorException
	 */
	public List<IrrecoverableInvoiceLine> createIrrecoverableInvoiceLineList(IrrecoverableCustomerLine icl, List<Invoice> invoiceList) throws AxelorException  {
		int seq = 1;
		List<IrrecoverableInvoiceLine> iilList = new ArrayList<IrrecoverableInvoiceLine>();
		for(Invoice invoice : invoiceList)  {
			iilList.add(this.createIrrecoverableInvoiceLine(icl, invoice, seq));
			seq++;
		}
		return iilList;
	}



	/**
	 * Fonction permettant de créer une liste de ligne d'échéance rejetée
	 * @param icl
	 * 			Une ligne Client
	 * @param invoiceList
	 * 			Une liste de d'échéance rejetée du tiers payeur
	 * @return
	 * @throws AxelorException
	 */
	public List<IrrecoverablePaymentScheduleLineLine> createIrrecoverablePaymentScheduleLineLineList(IrrecoverableCustomerLine icl, List<PaymentScheduleLine> paymentScheduleLineList) throws AxelorException  {
		int seq = 1;
		List<IrrecoverablePaymentScheduleLineLine> ipsllList = new ArrayList<IrrecoverablePaymentScheduleLineLine>();
		for(PaymentScheduleLine paymentScheduleLine : paymentScheduleLineList)  {
			ipsllList.add(this.createIrrecoverablePaymentScheduleLineLine(icl, paymentScheduleLine, seq));
			seq++;
		}
		return ipsllList;
	}



	/**
	 * Fonction permettant de créer une ligne Facture
	 * @param icl
	 * 			Une ligne Client
	 * @param invoice
	 * 			Une facture
	 * @param seq
	 * 			Un numéro de séquence
	 * @return
	 * @throws AxelorException
	 */
	public IrrecoverableInvoiceLine createIrrecoverableInvoiceLine(IrrecoverableCustomerLine icl, Invoice invoice, int seq) throws AxelorException  {
		IrrecoverableInvoiceLine iil = new IrrecoverableInvoiceLine();
		iil.setInvoice(invoice);
		iil.setInvoiceLineSeq(seq);
		iil.setIrrecoverableCustomerLine(icl);

		BigDecimal prorataRate = this.getProrataRate(invoice, invoice.getRejectMoveLine() != null);

		iil.setIrrecoverableReportLineList(this.createIrrecoverableReportLineList(iil, invoice, prorataRate));

		log.debug("Ligne facture : {}", iil);

		return iil;
	}


	/**
	 * Fonction permettant de créer une ligne Echéance rejetée
	 * @param icl
	 * 			Une ligne Client
	 * @param invoice
	 * 			Une échéance rejetée
	 * @param seq
	 * 			Un numéro de séquence
	 * @return
	 * @throws AxelorException
	 */
	public IrrecoverablePaymentScheduleLineLine createIrrecoverablePaymentScheduleLineLine(IrrecoverableCustomerLine icl, PaymentScheduleLine paymentScheduleLine, int seq) throws AxelorException  {
		IrrecoverablePaymentScheduleLineLine ipsll = new IrrecoverablePaymentScheduleLineLine();
		ipsll.setPaymentScheduleLine(paymentScheduleLine);
		ipsll.setIrrecoverableCustomerLine(icl);

		Company company = paymentScheduleLine.getPaymentSchedule().getCompany();

		Tax tax = accountConfigService.getIrrecoverableStandardRateTax(accountConfigService.getAccountConfig(company));

		ipsll.setIrrecoverableReportLineList(this.createIrrecoverableReportLineList(ipsll, paymentScheduleLine, tax));

		log.debug("Ligne échéance rejetée : {}", ipsll);

		return ipsll;
	}






	/**
	 * Fonction permettant de savoir si toutes les factures à passer en irrécouvrable d'un échéancier à passer en irrécouvrable,
	 * ont été passées en irrécouvrable
	 * @param paymentSchedule
	 * 			Un échéancier
	 * @return
	 */
	public boolean isAllInvoicePassedInIrrecoverable (PaymentSchedule paymentSchedule)  {
		for(Invoice invoiceScheduled : paymentSchedule.getInvoiceSet())  {
			if(invoiceScheduled.getIrrecoverableStatusSelect().equals(InvoiceRepository.IRRECOVERABLE_STATUS_TO_PASS_IN_IRRECOUVRABLE))  {
				return false;
			}
		}
		return true;
	}


	/**
	 * Fonction permettant de créer une liste de ligne de reporting pour une ligne Facture
	 * @param iil
	 * 			Une ligne Facture
	 * @param invoice
	 * 			Une facture
	 * @param prorataRate
	 * 			Un taux de restant à payer d'une facture
	 * @return
	 */
	public List<IrrecoverableReportLine> createIrrecoverableReportLineList(IrrecoverableInvoiceLine iil, Invoice invoice, BigDecimal prorataRate)  {
		int seq = 1;
		List<IrrecoverableReportLine> irlList = new ArrayList<IrrecoverableReportLine>();

		for(InvoiceLine invoiceLine : invoice.getInvoiceLineList())  {

			irlList.add(this.createIrrecoverableReportLine(iil, invoiceLine.getName(), invoiceLine.getExTaxTotal().multiply(prorataRate).setScale(IAdministration.DEFAULT_NB_DECIMAL_DIGITS, RoundingMode.HALF_EVEN), seq));
			seq++;
		}
		for(InvoiceLineTax invoiceLineTax : invoice.getInvoiceLineTaxList())  {
			irlList.add(this.createIrrecoverableReportLine(iil, invoiceLineTax.getTaxLine().getTax().getName(), invoiceLineTax.getTaxTotal().multiply(prorataRate).setScale(IAdministration.DEFAULT_NB_DECIMAL_DIGITS, RoundingMode.HALF_EVEN), seq));
			seq++;
		}
		// Afin de ne pas modifier les valeurs des lignes de factures, on les recharges depuis la base
		invoiceRepo.refresh(invoice);
		return irlList;
	}


	/**
	 * Fonction permettant de créer une liste de ligne de reporting pour une ligne Echéance rejetée
	 * @param iil
	 * 			Une ligne Echéance rejetée
	 * @param invoice
	 * 			Une échéance rejetée
	 * @param prorataRate
	 * 			Un taux de restant à payer d'une échéance rejetée
	 * @return
	 * @throws AxelorException
	 */
	public List<IrrecoverableReportLine> createIrrecoverableReportLineList(IrrecoverablePaymentScheduleLineLine ipsll, PaymentScheduleLine paymentScheduleLine, Tax tax) throws AxelorException  {
		List<IrrecoverableReportLine> irlList = new ArrayList<IrrecoverableReportLine>();

		BigDecimal taxRate = taxService.getTaxRate(tax, date);

		BigDecimal amount = paymentScheduleLine.getInTaxAmount();

		BigDecimal divid = taxRate.add(BigDecimal.ONE);

		// Montant hors-Taxe
		BigDecimal irrecoverableAmount = amount.divide(divid, 6, RoundingMode.HALF_EVEN).setScale(IAdministration.DEFAULT_NB_DECIMAL_DIGITS, RoundingMode.HALF_EVEN);

		// Montant Tax
		BigDecimal taxAmount = amount.subtract(irrecoverableAmount);

		irlList.add(this.createIrrecoverableReportLine(ipsll, "HT", irrecoverableAmount, 1));

		irlList.add(this.createIrrecoverableReportLine(ipsll, tax.getName(), taxAmount, 2));

		return irlList;
	}


	/**
	 * Fonction permettant de créer une ligne Reporting
	 * @param iil
	 * 			Une ligne Facture
	 * @param label
	 * 			Un libellé
	 * @param value
	 * 			Une valeur
	 * @param seq
	 * 			Un numéro de séquence
	 * @return
	 */
	public IrrecoverableReportLine createIrrecoverableReportLine(IrrecoverableInvoiceLine iil, String label, BigDecimal value, int seq)  {
		IrrecoverableReportLine irl = new IrrecoverableReportLine();
		irl.setReportLineSeq(seq);
		irl.setLabel(label);
		irl.setValue(value);
		irl.setIrrecoverableInvoiceLine(iil);

		log.debug("Ligne reporting : {}", irl);

		return irl;
	}


	/**
	 * Fonction permettant de créer une ligne Reporting
	 * @param iil
	 * 			Une ligne Echéance rejetée
	 * @param label
	 * 			Un libellé
	 * @param value
	 * 			Une valeur
	 * @param seq
	 * 			Un numéro de séquence
	 * @return
	 */
	public IrrecoverableReportLine createIrrecoverableReportLine(IrrecoverablePaymentScheduleLineLine ipsll, String label, BigDecimal value, int seq)  {
		IrrecoverableReportLine irl = new IrrecoverableReportLine();
		irl.setReportLineSeq(seq);
		irl.setLabel(label);
		irl.setValue(value);
		irl.setIrrecoverablePaymentScheduleLineLine(ipsll);

		log.debug("Ligne reporting : {}", irl);

		return irl;
	}


	/**
	 * Fonction permettant de calculer le taux de restant à payer d'une facture
	 * @param invoice
	 * 			Une facture
	 * @param isInvoiceReject
	 * 			La facture est-elle rejetée?
	 * @return
	 */
	public BigDecimal getProrataRate(Invoice invoice, boolean isInvoiceReject)  {
		BigDecimal prorataRate = null;
		if(isInvoiceReject)  {
			prorataRate = (invoice.getRejectMoveLine().getAmountRemaining()).divide(invoice.getInTaxTotal(), 6, RoundingMode.HALF_EVEN);
		}
		else  {
			prorataRate = invoice.getCompanyInTaxTotalRemaining().divide(invoice.getInTaxTotal(), 6, RoundingMode.HALF_EVEN);
		}

		log.debug("Taux d'impayé pour la facture {} : {}", invoice.getInvoiceId(), prorataRate);

		return prorataRate;
	}


	/**
	 * Fonction permettant de créer l'écriture de passage en irrécouvrable d'une facture
	 * @param invoice
	 * 			Une facture
	 * @param prorataRate
	 * 			Le taux de restant à payer sur la facture
	 * @param isInvoiceReject
	 * 			La facture est-elle rejetée?
	 * @return
	 * @throws AxelorException
	 */
	public Move createIrrecoverableMove(Invoice invoice, BigDecimal prorataRate, boolean isInvoiceReject) throws AxelorException  {
		Company company = invoice.getCompany();
		Partner payerPartner = invoice.getPartner();

		AccountConfig accountConfig = company.getAccountConfig();

		// Move
		Move move = moveService.getMoveCreateService().createMove(accountConfig.getIrrecoverableJournal(), company, null, payerPartner, null);

		int seq = 1;

		BigDecimal amount = BigDecimal.ZERO;
		MoveLine debitMoveLine = null;
		BigDecimal creditAmount = null;
		BigDecimal debitAmount = null;
		if(isInvoiceReject)  {
			creditAmount = invoice.getRejectMoveLine().getAmountRemaining();
			debitAmount = creditAmount;
		}
		else  {
			creditAmount = invoice.getCompanyInTaxTotalRemaining();
			debitAmount = creditAmount;
		}

		// Debits MoveLines Tva
		for(InvoiceLineTax invoiceLineTax : invoice.getInvoiceLineTaxList())  {
			amount = (invoiceLineTax.getTaxTotal().multiply(prorataRate)).setScale(2, RoundingMode.HALF_EVEN);
			debitMoveLine = moveLineService.createMoveLine(
					move, payerPartner, taxAccountService.getAccount(invoiceLineTax.getTaxLine().getTax(), company), amount, true, date, seq, null);
			move.getMoveLineList().add(debitMoveLine);
			seq++;
			debitAmount = debitAmount.subtract(amount);
		}

		// Debit MoveLine 654 (irrecoverable account)
		debitMoveLine = moveLineService.createMoveLine(move, payerPartner, accountConfig.getIrrecoverableAccount(), debitAmount, true, date, seq, null);
		move.getMoveLineList().add(debitMoveLine);

		seq++;

		// Getting customer MoveLine from Facture
		MoveLine customerMoveLine = moveService.getMoveToolService().getCustomerMoveLineByQuery(invoice);
		if(customerMoveLine == null)  {
			throw new AxelorException(String.format(I18n.get(IExceptionMessage.IRRECOVERABLE_3),
					GeneralServiceImpl.EXCEPTION, invoice.getInvoiceId()), IException.INCONSISTENCY);
		}
		customerMoveLine.setIrrecoverableStatusSelect(MoveLineRepository.IRRECOVERABLE_STATUS_PASSED_IN_IRRECOUVRABLE);

		// Credit MoveLine Customer account (411, 416, ...)
		MoveLine creditMoveLine = moveLineService.createMoveLine(move, payerPartner, customerMoveLine.getAccount(), creditAmount, false, date, seq, null);
		move.getMoveLineList().add(creditMoveLine);

		Reconcile reconcile = reconcileService.createReconcile(customerMoveLine, creditMoveLine, creditAmount, false);
		reconcileService.confirmReconcile(reconcile);

		return move;
	}


	/**
	 * Fonction permettant de créer l'écriture de passage en irrécouvrable d'une échéance
	 * @param moveLine
	 * 			Une écriture d'échéance
	 * @return
	 * @throws AxelorException
	 */
	public Move createIrrecoverableMove(MoveLine moveLine) throws AxelorException  {

		Company company = moveLine.getMove().getCompany();
		Partner payerPartner = moveLine.getPartner();
		BigDecimal amount = moveLine.getAmountRemaining();

		AccountConfig accountConfig = company.getAccountConfig();

		// Move
		Move move = moveService.getMoveCreateService().createMove(accountConfig.getIrrecoverableJournal(), company, null, payerPartner, null);

		int seq = 1;

		// Credit MoveLine Customer account (411, 416, ...)
		MoveLine creditMoveLine = moveLineService.createMoveLine(move, payerPartner, moveLine.getAccount(), amount, false, date, seq, null);
		move.getMoveLineList().add(creditMoveLine);

		Reconcile reconcile = reconcileService.createReconcile(moveLine, creditMoveLine, amount, false);
		reconcileService.confirmReconcile(reconcile);

		Tax tax = accountConfig.getIrrecoverableStandardRateTax();

		BigDecimal taxRate = taxService.getTaxRate(tax, date);

		// Debit MoveLine 654. (irrecoverable account)
		BigDecimal divid = taxRate.add(BigDecimal.ONE);
		BigDecimal irrecoverableAmount = amount.divide(divid, 6, RoundingMode.HALF_EVEN).setScale(IAdministration.DEFAULT_NB_DECIMAL_DIGITS, RoundingMode.HALF_EVEN);
		MoveLine creditMoveLine1 = moveLineService.createMoveLine(move, payerPartner, accountConfig.getIrrecoverableAccount(), irrecoverableAmount, true, date, 2, null);
		move.getMoveLineList().add(creditMoveLine1);

		// Debit MoveLine 445 (Tax account)
		Account taxAccount = taxAccountService.getAccount(tax, company);
		BigDecimal taxAmount = amount.subtract(irrecoverableAmount);
		MoveLine creditMoveLine2 = moveLineService.createMoveLine(move, payerPartner, taxAccount, taxAmount, true, date, 3, null);
		move.getMoveLineList().add(creditMoveLine2);

		return move;
	}


	/**
	 * Fonction permettant de créer un objet de gestion
	 * @param code
	 * @param message
	 * @return
	 */
	public ManagementObject createManagementObject(String code, String message)  {
		ManagementObject managementObject = managementObjectRepo.all().filter("self.code = ?1 AND self.name = ?2", code, message).fetchOne();
		if(managementObject != null)  { return managementObject;  }

		managementObject = new ManagementObject();
		managementObject.setCode(code);
		managementObject.setName(message);
		return managementObject;
	}


	/**
	 * Procédure permettant de vérifier les champs d'une société
	 * @param company
	 * 			Une société
	 * @throws AxelorException
	 */
	public void testCompanyField(Company company) throws AxelorException  {

		AccountConfig accountConfig = accountConfigService.getAccountConfig(company);
		accountConfigService.getIrrecoverableAccount(accountConfig);
		accountConfigService.getIrrecoverableJournal(accountConfig);
		accountConfigService.getIrrecoverableStandardRateTax(accountConfig);

	}


	public String getSequence(Company company) throws AxelorException  {

		String seq = sequenceService.getSequenceNumber(IAdministration.IRRECOVERABLE, company);
		if(seq == null) {
			throw new AxelorException(String.format(I18n.get(IExceptionMessage.IRRECOVERABLE_4),
					GeneralServiceImpl.EXCEPTION,company.getName()), IException.CONFIGURATION_ERROR);
		}

		return seq;

	}


	/**
	 * Procédure permettant de passer une facture en irrécouvrable
	 * @param invoice
	 * 			Une facture
	 * @param generateEvent
	 * 			Un évènement à t'il déjà été créé par un autre objet ?
	 * @throws AxelorException
	 */
	@Transactional(rollbackOn = {AxelorException.class, Exception.class})
	public void passInIrrecoverable(Invoice invoice, boolean generateEvent) throws AxelorException  {
		invoice.setIrrecoverableStatusSelect(InvoiceRepository.IRRECOVERABLE_STATUS_TO_PASS_IN_IRRECOUVRABLE);

		if(generateEvent)  {
			Company company = invoice.getCompany();

			ManagementObject managementObject = this.createManagementObject("IRR", accountConfigService.getIrrecoverableReasonPassage(accountConfigService.getAccountConfig(company)));
			invoice.setManagementObject(managementObject);

			MoveLine moveLine = moveService.getMoveToolService().getCustomerMoveLineByQuery(invoice);

			if(moveLine == null)  {
				throw new AxelorException(String.format(I18n.get(IExceptionMessage.IRRECOVERABLE_3),
						GeneralServiceImpl.EXCEPTION,invoice.getInvoiceId()), IException.INCONSISTENCY);
			}

			this.passInIrrecoverable(moveLine, managementObject, false);

		}

		invoiceRepo.save(invoice);
	}


	/**
	 * Procédure permettant de passer une facture en irrécouvrable
	 * @param invoice
	 * 			Une facture
	 * @param managementObject
	 * 			Un objet de gestion (utilisé si procédure appelée depuis un autre objet)
	 * @throws AxelorException
	 */
	public void passInIrrecoverable(Invoice invoice, ManagementObject managementObject) throws AxelorException  {
		this.passInIrrecoverable(invoice, false);
		invoice.setManagementObject(managementObject);
		MoveLine moveLine = moveService.getMoveToolService().getCustomerMoveLineByQuery(invoice);

		if(moveLine == null)  {
			throw new AxelorException(String.format(I18n.get(IExceptionMessage.IRRECOVERABLE_3),
					GeneralServiceImpl.EXCEPTION,invoice.getInvoiceId()), IException.INCONSISTENCY);
		}

		this.passInIrrecoverable(moveLine, managementObject, false);

		invoiceRepo.save(invoice);
	}


	/**
	 * Procédure permettant d'annuler le passage en irrécouvrable d'une facture
	 * @param invoice
	 * 			Une facture
	 * @throws AxelorException
	 */
	@Transactional(rollbackOn = {AxelorException.class, Exception.class})
	public void notPassInIrrecoverable(Invoice invoice) throws AxelorException  {
		invoice.setIrrecoverableStatusSelect(InvoiceRepository.IRRECOVERABLE_STATUS_NOT_IRRECOUVRABLE);

		MoveLine moveLine = moveService.getMoveToolService().getCustomerMoveLineByQuery(invoice);

		if(moveLine != null)  {
			this.notPassInIrrecoverable(moveLine, false);
		}

		invoiceRepo.save(invoice);
	}


	/**
	 * Procédure permettant de passer en irrécouvrable une ligne d'écriture
	 * @param moveLine
	 * 			Une ligne d'écriture
	 * @param generateEvent
	 * 			Un évènement à t'il déjà été créé par un autre objet ?
	 * @param passInvoice
	 * 			La procédure doit-elle passer aussi en irrécouvrable la facture ?
	 *
	 * @throws AxelorException
	 */
	@Transactional(rollbackOn = {AxelorException.class, Exception.class})
	public void passInIrrecoverable(MoveLine moveLine, boolean generateEvent, boolean passInvoice) throws AxelorException  {
		moveLine.setIrrecoverableStatusSelect(MoveLineRepository.IRRECOVERABLE_STATUS_TO_PASS_IN_IRRECOUVRABLE);
		ManagementObject managementObject = null;
		if(generateEvent)  {
			Company company = moveLine.getMove().getCompany();

			managementObject = this.createManagementObject("IRR", accountConfigService.getIrrecoverableReasonPassage(accountConfigService.getAccountConfig(company)));
			moveLine.setManagementObject(managementObject);

		}

		if(moveLine.getMove().getInvoice() != null && passInvoice)  {
			this.passInIrrecoverable(moveLine.getMove().getInvoice(), managementObject);
		}

		moveLineRepo.save(moveLine);
	}


	/**
	 * Procédure permettant d'annuler le passage en irrrécouvrable d'une ligne d'écriture
	 * @param moveLine
	 * 			Une ligne d'écriture
	 * @param managementObject
	 * 			Un objet de gestion (utilisé si procédure appelée depuis un autre objet)
	 * @param passInvoice
	 * 			La procédure doit-elle passer aussi en irrécouvrable la facture ?
	 *
	 * @throws AxelorException
	 */
	public void passInIrrecoverable(MoveLine moveLine, ManagementObject managementObject, boolean passInvoice) throws AxelorException  {
		this.passInIrrecoverable(moveLine, false, passInvoice);

		moveLine.setManagementObject(managementObject);

		moveLineRepo.save(moveLine);
	}


	/**
	 * Procédure permettant d'annuler le passage en irrrécouvrable d'une ligne d'écriture
	 * @param moveLine
	 * 			Une ligne d'écriture
	 * @param passInvoice
	 * 			La procédure doit-elle passer aussi en irrécouvrable la facture ?
	 * @throws AxelorException
	 */
	@Transactional(rollbackOn = {AxelorException.class, Exception.class})
	public void notPassInIrrecoverable(MoveLine moveLine, boolean passInvoice) throws AxelorException  {
		moveLine.setIrrecoverableStatusSelect(MoveLineRepository.IRRECOVERABLE_STATUS_NOT_IRRECOUVRABLE);

		if(moveLine.getMove().getInvoice() != null && passInvoice)  {
			this.notPassInIrrecoverable(moveLine.getMove().getInvoice());
		}

		moveLineRepo.save(moveLine);
	}


	/**
	 * Procédure permettant de passer un échéancier de lissage de paiement en irrécouvrable
	 * La procédure passera aussi les lignes d'écriture de rejet d'échéance en irrécouvrable,
	 * ainsi que les factures pas complètement payée selectionnées sur l'échéancier
	 *
	 * @param paymentSchedule
	 * 				Un échéancier de paiement
	 * @throws AxelorException
	 */
	@Transactional(rollbackOn = {AxelorException.class, Exception.class})
	public void passInIrrecoverable(PaymentSchedule paymentSchedule) throws AxelorException  {
		Company company = paymentSchedule.getCompany();

		paymentSchedule.setIrrecoverableStatusSelect(PaymentScheduleRepository.IRRECOVERABLE_STATUS_TO_PASS_IN_IRRECOUVRABLE);

		ManagementObject managementObject = this.createManagementObject("IRR", accountConfigService.getIrrecoverableReasonPassage(accountConfigService.getAccountConfig(company)));
		paymentSchedule.setManagementObject(managementObject);

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

		for(PaymentScheduleLine paymentScheduleLine : paymentSchedule.getPaymentScheduleLineList())  {
			if(paymentScheduleLine.getRejectMoveLine() != null && paymentScheduleLine.getRejectMoveLine().getAmountRemaining().compareTo(BigDecimal.ZERO) > 0)  {
				paymentScheduleLineRejectMoveLineList.add(paymentScheduleLine.getRejectMoveLine());
			}
		}

		for(MoveLine moveLine : paymentScheduleLineRejectMoveLineList)  {
			this.passInIrrecoverable(moveLine, managementObject, true);
		}

		for(Invoice invoice : paymentSchedule.getInvoiceSet())  {
			if(invoice.getCompanyInTaxTotalRemaining().compareTo(BigDecimal.ZERO) > 0)  {
				this.passInIrrecoverable(invoice, managementObject);
			}
		}

		paymentScheduleService.cancelPaymentSchedule(paymentSchedule);

		paymentScheduleRepo.save(paymentSchedule);
	}


	/**
	 * Procédure permettant d'annuler le passage en irrécouvrable d'une échéancier de lissage de paiement
	 * La procédure annulera aussi le passage en irrécouvrable des lignes d'écriture de rejet d'échéance en irrécouvrable,
	 * ainsi que des factures pas complètement payée selectionnées sur l'échéancier
	 * @param paymentSchedule
	 * 			Un échéancier de paiement
	 * @throws AxelorException
	 */
	@Transactional(rollbackOn = {AxelorException.class, Exception.class})
	public void notPassInIrrecoverable(PaymentSchedule paymentSchedule) throws AxelorException  {
		paymentSchedule.setIrrecoverableStatusSelect(PaymentScheduleRepository.IRRECOVERABLE_STATUS_NOT_IRRECOUVRABLE);

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

		for(PaymentScheduleLine paymentScheduleLine : paymentSchedule.getPaymentScheduleLineList())  {
			if(paymentScheduleLine.getRejectMoveLine() != null && paymentScheduleLine.getRejectMoveLine().getAmountRemaining().compareTo(BigDecimal.ZERO) > 0)  {
				paymentScheduleLineRejectMoveLineList.add(paymentScheduleLine.getRejectMoveLine());
			}
		}

		for(MoveLine moveLine : paymentScheduleLineRejectMoveLineList)  {
			this.notPassInIrrecoverable(moveLine, false);
		}

		for(Invoice invoice : paymentSchedule.getInvoiceSet())  {
			this.notPassInIrrecoverable(invoice);
		}
		paymentScheduleRepo.save(paymentSchedule);
	}
}