bsfinancials-core/src/main/java/org/turro/financials/model/contract/ContractWrapper.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2011 Lluis Turró Cutiller <http://www.turro.org/>
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * 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 org.turro.financials.model.contract;
 
import java.util.*;
import org.turro.string.Strings;
import org.turro.action.Plugins;
import org.turro.elephant.db.WhereClause;
import org.turro.financials.db.FinancialsPU;
import org.turro.financials.entity.*;
import org.turro.financials.model.AccountFormat;
import org.turro.financials.model.document.DocumentWrapper;
import org.turro.financials.model.register.ViewWrapper;
import org.turro.jpa.Dao;
import org.turro.jpa.entity.DaoEntity;
import org.turro.plugin.contacts.IContact;
import org.turro.plugin.dossier.ICategory;
import org.turro.plugin.dossier.IDossier;
 
public class ContractWrapper extends DaoEntity<Contract, Long> {
 
  public ContractWrapper(Contract entity) {
    super(entity);
  }
  
  @Override
  protected Dao createDao() {
    return new FinancialsPU();
  }
 
  public Collection<DocumentDefinition> getExpiryDefinitions(DocumentDefinition source) {
    if(entity == null || source == null) return Collections.EMPTY_LIST;
    ArrayList<DocumentDefinition> list = new ArrayList<>();
    for(DocumentWorkflow dw : entity.getContractDefinition().getDocumentWorkflows()) {
      if(dw.getAncestor().getId() == source.getId() && dw.isAllowNewDescendants()) {
        list.add(dw.getDescendant());
      }
    }
    return list;
  }
  
  @Override
  public boolean canDelete() {
    if(!super.canDelete()) return false;
    Long count = (Long) getDao().getSingleResult(
            "select count(*) from Document " +
            "where contract = ?",
            new Object[] { entity });
    if(count == 0) {
      count = (Long) getDao().getSingleResult(
            "select count(*) from DocumentLine " +
            "where store = ?",
            new Object[] { entity });
    }
    return count == 0;
  }
 
  @Override
  protected boolean shouldLog() {
    return true;
  }
  
  public void generateRegisters(DocumentDefinition docDef, int year) {
    for(Document doc : getDocuments(docDef, year)) {
      new DocumentWrapper(doc).save(null, null);
    }    
  }
 
  public Collection<Document> getDocuments(DocumentDefinition docDef, int year) {
    return getDao().getResultList(
            "select doc from Document as doc " +
            "where doc.contract = ? " +
            "and doc.documentDefinition = ? " +
            "and year(doc.receiptDate) = ? " + 
            "order by doc.documentDate",
            new Object[] { entity, docDef, year });
  }
 
  transient RegisterView lastView;
  transient Double advance;
  
  public double getAdvance(RegisterView view) {
    String acc = entity.getContractDefinition().getAsCash();
    if(!Strings.isBlank(acc) && (acc.startsWith("560") || 
            acc.startsWith("561") || acc.startsWith("565") || acc.startsWith("566"))) {
      WhereClause wc = new WhereClause();
      wc.addClause("select sum(re.debit-re.credit) from RegisterEntry as re");
      wc.addClause("where re.account.id = :idacc");
      wc.addNamedValue("idacc", AccountFormat.expand(acc + "." + entity.getId()));
      wc.addClause("and re.register.view = :view");
      if(view != null) {
        wc.addNamedValue("view", view);
      } else {
        wc.addNamedValue("view", ViewWrapper.getFormalView());
      }
      advance = (Double) getDao().getSingleResultOrNull(wc);
      if("566".equals(entity.getContractDefinition().getAsCash())) {
        advance = advance != null ? -advance : 0.0d;
      } else {
        advance = advance != null ? advance : 0.0d;
      }
      return advance;
    } else {
      return 0.0d;
    }
  }
 
  public void addAdvanceIfNeeded(RegisterView view, Collection<Contract> contracts) {
    if(getAdvance(view) != 0.0d) {
      Iterator<Contract> it = contracts.iterator();
      while(it.hasNext()) {
        Contract ctc = it.next();
        if(ctc.getId() == entity.getId()) {
          return;
        }
      }
      contracts.add(entity);
    }
  }
 
  public static Collection<Contract> getContracts(ContractDefinition contractDefinition) {
    Dao dao = new FinancialsPU();
    return dao.getResultList(
            "select ctc from Contract as ctc " +
            "where ctc.contractDefinition = ? " +
            "and ctc.active = TRUE " +
            "order by ctc.name",
            new Object[] { contractDefinition });
  }
 
  public static Collection<Contract> getContracts(Long contractDefinitionId) {
    Dao dao = new FinancialsPU();
    return dao.getResultList(
            "select ctc from Contract as ctc " +
            "where ctc.contractDefinition.id = ? " +
            "and ctc.active = TRUE " +
            "order by ctc.name",
            new Object[] { contractDefinitionId });
  }
 
  public static void clearActives(Collection<Contract> contracts) {
    Date now = new Date();
    Iterator<Contract> it = contracts.iterator();
    while(it.hasNext()) {
      if(isActive(now, it.next())) {
        it.remove();
      }
    }
  }
 
  public static void clearInactives(Collection<Contract> contracts) {
    Date now = new Date();
    Iterator<Contract> it = contracts.iterator();
    while(it.hasNext()) {
      if(!isActive(now, it.next())) {
        it.remove();
      }
    }
  }
 
  public IDossier getDossier() {
    if(entity.getId() > 0) {
      IDossier dossier = (IDossier) Plugins.loadImplementation(IDossier.class);//PluginChecker.get("dossier");
      ICategory cat = dossier.addCategory();
      cat.setDescription("Financials");
      cat.setId(9000);
      cat = dossier.addCategory();
      cat.setDescription("Contracts");
      cat.setId(9001);
      cat.setParentId(9000);
      cat = dossier.addCategory();
      cat.setDescription(entity.getContractDefinition().getName());
      cat.setId(9500 + entity.getContractDefinition().getId());
      cat.setParentId(9001);
      dossier.setDescription(entity.getFullDescription());
      dossier.setIdCategory(cat.getId());
      dossier.setPath(FinancialsPU.getObjectPath(entity));
      dossier.setSubject(entity.getIContractor());
      return dossier;
    }
    return null;
  }
 
  public static boolean isActive(Date now, Contract contract) {
    return contract.isActive() &&
           (contract.getStartDate() == null || now.after(contract.getStartDate())) &&
           (contract.getEndDate() == null || now.before(contract.getEndDate()));
  }
  
  public static Collection<Contract> getContracts(IContact contact) {
    if(contact == null) return null;
    
    Dao dao = new FinancialsPU();
    return dao.getResultList(
            "select ctc from Contract as ctc " +
            "left outer join ctc.participants participant " +
            "where ctc.contractor = ? or (participant.idContact = ? and participant.interventionType = ?) " +
            "order by ctc.name",
            new Object[] { contact.getId(), contact.getId(), ContractInterventionType.INT_OPERATOR });
  }
 
  public static Collection<DocumentDefinition> getExpiryDefinitions(ContractDefinition contractDefinition, DocumentDefinition documentDefinition) {
    ArrayList<DocumentDefinition> list = new ArrayList<DocumentDefinition>();
    for(DocumentWorkflow dw : contractDefinition.getDocumentWorkflows()) {
      if(dw.getAncestor().getId() == documentDefinition.getId() && dw.isAllowNewDescendants()) {
        list.add(dw.getDescendant());
      }
    }
    return list;
  }
 
}