bsfinancials-www/src/main/java/org/turro/financials/document/logic/BatchOfWrapper.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.document.logic;
 
import java.util.ArrayList;
import java.util.Collection;
import java.util.Date;
import java.util.List;
import org.turro.command.Command;
import org.turro.command.Context;
import org.turro.elephant.db.WhereClause;
import org.turro.elephant.util.Messages;
import org.turro.financials.db.FinancialsPU;
import org.turro.financials.document.DocumentListbox;
import org.turro.financials.entity.*;
import org.turro.financials.model.document.BatchOfType;
import org.turro.financials.portfolio.PortfolioSet;
import org.turro.financials.portfolio.RelationMode;
import org.turro.i18n.I_;
import org.turro.jpa.Dao;
import org.turro.plugin.dossier.IIssue;
import org.turro.plugin.filter.IFilterValue;
import org.turro.zkoss.dialog.SelectionDialog;
import org.turro.zkoss.filter.FilterGrid;
import org.turro.zul.frame.Framework;
 
public class BatchOfWrapper extends org.turro.financials.model.document.BatchOfWrapper {
 
  public Date relationDate = new java.util.Date(new java.util.Date().getTime() - (6L * 30L * 24L * 60L * 60L * 1000L));
  public Date relationToDate = new Date();
 
  public BatchOfWrapper(BatchOf batchOf) {
    super(batchOf);
  }
 
  public Date getRelationDate() {
    return relationDate;
  }
 
  public Date getRelationToDate() {
    return relationToDate;
  }
 
  public String createBatchString() {
    String s = "";
    if(batchOf.getType() != null) {
      s = batchOf.getType().getDocumentDefinition().getName() + ": ";
    }
    return s + I_.get("Create from") + "...";
  }
 
  public String createRelationString() {
    String s = "";
    if(batchOf.getType() != null) {
      s = batchOf.getType().getPortfolioDefinition().getName() + ": ";
    }
    return s + I_.get("Create from") + "...";
  }
 
  public void setContract(Contract contract) {
    batchOf.getBatch().setContract(contract);
    for(Document doc : batchOf.getDocuments()) {
      for(DocumentLine l : doc.getDocumentLines()) {
        l.setStore(contract);
      }
    }
  }
 
  public void setStore(Contract contract) {
    batchOf.setStore(contract);
    for(DocumentLine l : batchOf.getBatch().getDocumentLines()) {
      l.setStore(contract);
    }
  }
 
  public void loadBatch(BatchOfType type, final Command command) {
    final DocumentListbox dl = new DocumentListbox(getPossibleBatch(type));
    dl.setMultiple(false);
    dl.setCheckmark(false);
    dl.setShowContract(true);
 
    SelectionDialog.getComponent(
            Framework.getCurrent().getPage(),
            I_.get("Documents"),
            dl, "80%", "80%", new Command() {
      @Override
      public Object execute(Context context) {
        if(dl != null) {
          batchOf.setBatch(dl.getObjectValue());
          if(batchOf.getBatch() != null) {
            context.put("batch", batchOf.getBatch());
            if(command != null) command.execute(context);
          }
        }
        return null;
      }
    });
  }
 
  public void loadRelation(final BatchOfType type, FilterGrid filterGrid, final Command command) {
    final DocumentListbox dl = new DocumentListbox(getPossibleRelation(type, filterGrid));
    dl.setMultiple(true);
    dl.setCheckmark(true);
    dl.setShowContract(true);
    dl.setShowConcepts(true);
    dl.setSelectFirst(false);
 
    SelectionDialog.getComponent(
            Framework.getCurrent().getPage(),
            I_.get("Documents"),
            dl, "80%", "80%", new Command() {
      @Override
      public Object execute(Context context) {
        if(dl != null) {
          for(Document d : dl.getObjectValues()) {
            if(d.getDocumentDefinition().getId() == type.getPortfolioId()) {
              for(DocumentLine l : d.getDocumentLines()) {
                l.setStore(batchOf.getBatch().getContract());
              }
              batchOf.getDocuments().add(d);
            } else {
              Collection<DocumentWorkflow> wf = d.getWorkflows();
              for(final DocumentWorkflow dw : wf) {
                if(d.getDocumentDefinition().getId() == dw.getAncestor().getId() &&
                        type.getPortfolioId() == dw.getDescendant().getId()) {
                  Document nd = new Document();
                  nd.flowFrom(d, new DocumentWrapper(d).getDocDescription(), dw);
                  if(BatchOfType.BATCH_OF_DISCOUNTING.equals(batchOf.getType())) {
                    nd.setDocumentDate(d.getDocumentDate());
                    nd.setReceiptDate(d.getReceiptDate());
                  } else {
                    nd.setDocumentDate(batchOf.getBatch().getDocumentDate());
                    nd.setReceiptDate(batchOf.getBatch().getReceiptDate());
                  }
                  nd.setDocumentNumber(d.getDocumentNumber() + "/1");
                  for(DocumentLine l : nd.getDocumentLines()) {
                    l.setStore(batchOf.getBatch().getContract());
                  }
                  batchOf.getDocuments().add(nd);
                }
              }
            }
          }
          if(command != null) command.execute(context);
        }
        return null;
      }
    });
  }
 
  public void delete(final boolean close) {
    Messages.confirmDeletion().show(() -> {
      if(BatchOfWrapper.super.delete()) {
        if(close) Framework.getCurrent().closeSelected();
      }
    });
  }
 
  public IIssue getIssue() {
    return new DocumentWrapper(batchOf.getBatch()).getIssue();
  }
 
  @Override
  public boolean save(List<DocumentLine> lines) {
    for(Document doc : batchOf.getDocuments()) {
      for(DocumentLine l : doc.getDocumentLines()) {
        l.setStore(batchOf.getBatch().getContract());
      }
    }
    for(DocumentLine l : batchOf.getBatch().getDocumentLines()) {
      l.setStore(batchOf.getStore());
    }
    return super.save(lines);
  }
 
  private Collection<Document> getPossibleBatch(BatchOfType type) {
    Dao dao = new FinancialsPU();
    return dao.getResultList(
            "select doc from Document as doc " +
            "where doc.documentDefinition.id = ? " +
            "and not exists ("+
            "select batch from BatchOf as batch where batch.batch = doc" +
            ") " +
            "order by doc.documentDate",
            new Object[] { type.getBatchId() });
  }
 
  private Collection<Document> getPossibleRelation(BatchOfType type, FilterGrid filterGrid) {
    Dao dao = new FinancialsPU();
    List<Document> relDocs = new ArrayList<Document>();
    // Already exists the document
    WhereClause wc = createCriteria(type, filterGrid.getValues());
    relDocs.addAll(dao.getResultList(wc));
    // iterate workflows to portfolio
    PortfolioSet ps = new PortfolioSet();
    ps.setDocumentDefinition(type.getPortfolioDefinition());
    ps.load(RelationMode.RELATE_FORWARD, filterGrid.getValues());
    relDocs.addAll(ps.getDocuments());
    return relDocs;
  }
 
  private WhereClause createCriteria(BatchOfType type, List<IFilterValue> values) {
    WhereClause wc = new WhereClause();
    wc.addClause("select doc from Document as doc");
    wc.addClause("where doc.documentDefinition.id = :docDef");
    wc.addNamedValue("docDef", type.getPortfolioId());
    for(IFilterValue v : values) {
      v.addConstraint(wc);
    }
    wc.addClause("and not exists (");
    wc.addClause(" select batch from BatchOf as batch where doc member of batch.documents");
    wc.addClause(") and exists (");
    wc.addClause(" select line from doc.documentLines as line ");
    wc.addClause(" where line.store = :store");
    wc.addNamedValue("store", batchOf.getBatch().getContract());
    wc.addClause(") ");
    wc.addClause("order by doc.documentDate");
    return wc;
  }
 
}