ProductUncoded.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.product;
 
import java.util.ArrayList;
import java.util.Collection;
import java.util.Date;
import java.util.List;
import org.turro.string.Strings;
import org.turro.elephant.db.WhereClause;
import org.turro.financials.db.FinancialsPU;
import org.turro.financials.entity.Contract;
import org.turro.financials.entity.ProductByContractor;
 
public class ProductUncoded implements IProduct {
 
  private String description = null;
  private Double cost = null, costTax = null, price = null, priceTax = null;
  
  private transient ProductByContractor productByContractor;
 
  public ProductUncoded(String description) {
    this.description = description;
  }
 
  public ProductUncoded(String description, ProductByContractor productByContractor) {
    this.description = description;
    this.productByContractor = productByContractor;
  }
 
  @Override
  public ProductByContractor getProductByContractor() {
    return productByContractor;
  }
 
  @Override
  public void setProductByContractor(ProductByContractor productByContractor) {
    this.productByContractor = productByContractor;
  }
 
  @Override
  public double getProductCost() {
    if(cost == null) {
      loadCostData();
    }
    return cost;
  }
 
  @Override
  public double getProductCostTax() {
    return costTax;
  }
 
  @Override
  public String getProductName() {
    return description;
  }
 
  @Override
  public long getProductId() {
    return -1;
  }
 
  @Override
  public String getProductCodeStr() {
    return description;
  }
 
  @Override
  public double getProductPrice() {
    if(price == null) {
      loadPriceData();
    }
    return price;
  }
 
  @Override
  public double getProductPriceTax() {
    return priceTax;
  }
 
  @Override
  public IProduct load(Object id) {
    this.description = (String) id;
    this.cost = null;
    this.costTax = null;
    this.price = null;
    this.priceTax = null;
    return this;
  }
 
  @Override
  public double getProductStock(Date date, Contract store) {
    WhereClause wc = new WhereClause();
    wc.addClause("select sum(quantity) ");
    wc.addClause("from DocumentLine dl");
    wc.addClause("where dl.document.receiptDate = :date");
    wc.addNamedValue("date", date);
    if(store != null) {
      wc.addClause("and dl.store = :store");
      wc.addNamedValue("store", store);
    }
    wc.addClause("and dl.product is null");
    wc.addClause("and dl.productByContractor is null");
    wc.addClause("and dl.lineType.stockCoefficient <> 0");
    wc.addClause("and dl.quantity <> 0");
    wc.addClause("and dl.concept = :concept");
    wc.addNamedValue("concept", description);
    return (Double) new FinancialsPU().getSingleResultOrNull(wc);
  }
 
  @Override
  public String getProductString() {
    return description;
  }
 
  @Override
  public boolean isUncoded() {
    return true;
  }
  
  @Override
  public Collection<Movement> getMovements() {
    WhereClause wc = new WhereClause();
    wc.addClause("select new org.turro.financials.product.Movement");
    wc.addClause("(dl.document.contract, dl.document.documentDate,");
    wc.addClause("dl.lineType.stockCoefficient,dl.quantity,dl.price,dl.concept)");
    wc.addClause("from DocumentLine dl");
    wc.addClause("where dl.product is null");
    wc.addClause("and dl.productByContractor is null");
    wc.addClause("and dl.concept = :concept");
    wc.addNamedValue("concept", description);
    wc.addClause("and dl.quantity <> 0");
    wc.addClause("order by dl.document.receiptDate desc, dl.lineOrder");
    return new FinancialsPU().getResultList(wc, 100);
  }
  
  @Override
  public Collection<Movement> getMovements(Date from, Date to, Contract store) {
    WhereClause wc = new WhereClause();
    wc.addClause("select new org.turro.financials.product.Movement");
    wc.addClause("('Accumulated',coalesce(sum(dl.quantity*dl.lineType.stockCoefficient),0.0),coalesce(sum(dl.quantity*dl.price*dl.lineType.stockCoefficient),0.0))");
    wc.addClause("from DocumentLine dl");
    wc.addClause("where dl.product is null");
    if(store != null) {
      wc.addClause("and dl.store = :store");
      wc.addNamedValue("store", store);
    }
    wc.addClause("and dl.productByContractor is null");
    wc.addClause("and dl.concept = :concept");
    wc.addNamedValue("concept", description);
    wc.addClause("and dl.quantity <> 0");
    wc.addClause("and dl.document.receiptDate < :from2");
    wc.addNamedValue("from2", from);
    Collection<Movement> movs = new FinancialsPU().getResultList(wc);
    wc = new WhereClause();
    wc.addClause("select new org.turro.financials.product.Movement");
    wc.addClause("(dl.document.contract, dl.document.documentDate,");
    wc.addClause("dl.lineType.stockCoefficient,dl.quantity,dl.price,dl.concept)");
    wc.addClause("from DocumentLine dl");
    wc.addClause("where dl.product is null");
    if(store != null) {
      wc.addClause("and dl.store = :store");
      wc.addNamedValue("store", store);
    }
    wc.addClause("and dl.productByContractor is null");
    wc.addClause("and dl.concept = :concept");
    wc.addNamedValue("concept", description);
    wc.addClause("and dl.quantity <> 0");
    wc.addClause("and dl.document.receiptDate >= :from2");
    wc.addNamedValue("from2", from);
    if(to != null) {
      wc.addClause("and dl.document.receiptDate <= :to2");
      wc.addNamedValue("to2", to);
    }
    wc.addClause("order by dl.document.receiptDate asc, dl.lineOrder");
    movs.addAll(new FinancialsPU().getResultList(wc));
    return movs;
  }
    
  private void loadCostData() {
    Object d[] = loadData(1);
    cost = (Double) d[0];
    costTax = (Double) d[1];
  }
 
  private void loadPriceData() {
    Object d[] = loadData(-1);
    price = (Double) d[0];
    priceTax = (Double) d[1];
  }
 
  private Object[] loadData(double coefficient) {
    WhereClause wc = new WhereClause();
    wc.addClause("select dl.price, dl.tax");
    wc.addClause("from DocumentLine dl");
    wc.addClause("where dl.product is null");
    wc.addClause("and dl.productByContractor is null");
    wc.addClause("and dl.lineType.stockCoefficient = :coef");
    wc.addNamedValue("coef", coefficient);
    wc.addClause("and dl.concept = :concept");
    wc.addNamedValue("concept", description);
    wc.addClause("and dl.quantity <> 0");
    wc.addClause("order by dl.document.receiptDate desc, dl.lineOrder");
    List l = new FinancialsPU().getResultList(wc, 1);
    Object d[];
    if(!l.isEmpty()) {
      d = (Object[]) l.get(0);
    } else {
      d = new Double[] { 0.0, 0.0 };
    }
    return d;
  }
  
  public static List<ProductUncoded> getProducts() {
    return getProducts(null, false);
  }
  
  public static List<ProductUncoded> getProducts(String concept, boolean equality) {
    List<ProductUncoded> l = new ArrayList<ProductUncoded>();
    for(String cp : getConcepts(concept, equality)) {
      l.add(new ProductUncoded(cp));
    }
    return l;
  }
  
  public static List<String> getConcepts(String concept, boolean equality) {
    WhereClause wc = new WhereClause();
    wc.addClause("select distinct dl.concept");
    getConceptsQuery(wc, concept, equality);
    List<String> list = new FinancialsPU().getResultList(wc);
    return list;
  }
  
  private static void getConceptsQuery(WhereClause wc, String concept, boolean equality) {
    wc.addClause("from DocumentLine dl");
    wc.addClause("where dl.product is null");
    wc.addClause("and dl.productByContractor is null");
    wc.addClause("and dl.lineType.stockCoefficient <> 0");
    wc.addClause("and dl.price > 0");
    if(!Strings.isBlank(concept)) {
      if(equality) {
        wc.addClause("and dl.concept = :concept");
        wc.addNamedValue("concept", concept);
      } else {
        wc.addLikeFields(new String[] { "dl.concept" }, concept);
      }
    } else {
      wc.addClause("and dl.concept is not null");
      wc.addClause("and dl.concept <> ''");
    }
    wc.addClause("order by dl.concept");
  }
 
}