ProductFactory.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.List;
import org.turro.string.Strings;
import org.turro.elephant.db.WhereClause;
import org.turro.financials.db.FinancialsPU;
import org.turro.financials.entity.DocumentLine;
import org.turro.financials.entity.LineType;
import org.turro.financials.entity.Product;
import org.turro.financials.entity.ProductByContractor;
import org.turro.util.Chars;
 
public class ProductFactory {
  
  public static IProduct getProduct(long id) {
    if(id < 1) return null;
    return new FinancialsPU().find(Product.class, (Long) id);
  }
  
  public static IProduct getProduct(String id) {
    if(Strings.isBlank(id)) return null;
    return (IProduct) new FinancialsPU().getSingleResultOrNull(
            "select prod from Product prod " +
            "where prod.productCode = ?",
            new Object[] { id }
            );
  }
  
  public static IProduct getProduct(long contractorId, String contractorCode) {
    IProduct product = null;
    ProductByContractor pbc = getContractorProduct(contractorId, contractorCode);
    if(pbc != null) {
      product = pbc.getProduct();
      product.setProductByContractor(pbc);
    }
    return product;
  }
  
  public static IProduct getProduct(IProductKey productKey) {
    return getProduct(productKey.getProductId(), productKey.getProviderId(),
            productKey.getProviderProductId(), productKey.getProductDescription());
  }
  
  public static IProduct getProduct(long productId, long providerId, long providerProductId, String description) {
    if(providerProductId > 0) {
      ProductByContractor pbc = new FinancialsPU().find(ProductByContractor.class, providerProductId);
      if(pbc != null) {
        return pbc.getProduct();
      }
    }
    if(productId > 0) {
      return getProduct(productId);
    }
    if(!Strings.isBlank(description)) {
      return getProductFromText(providerId, description);
    }
    return null;
  }
  
  public static ProductByContractor getContractorProduct(long contractorId, String contractorCode) {
    if(contractorId < 1 || Strings.isBlank(contractorCode)) return null;
    WhereClause wc = new WhereClause();
    wc.addClause("select pbc from ProductByContractor pbc");
    wc.addClause("where pbc.contract.id = :id");
    wc.addNamedValue("id", contractorId);
    wc.addClause("and pbc.contractorCode = :code");
    wc.addNamedValue("code", contractorCode);
    List l = new FinancialsPU().getResultList(wc, 1);
    if(l != null && !l.isEmpty()) {
      return (ProductByContractor) l.get(0);
    }
    return null;
  }
  
  public static void setContractorProduct(IProduct product, long contractorId) {
    if(contractorId < 1 || product == null) return;
    WhereClause wc = new WhereClause();
    wc.addClause("select pbc from ProductByContractor pbc");
    wc.addClause("where pbc.contract.id = :id");
    wc.addNamedValue("id", contractorId);
    wc.addClause("and pbc.product.productCode = :code");
    wc.addNamedValue("code", product.getProductCodeStr());
    List l = new FinancialsPU().getResultList(wc, 1);
    if(l != null && !l.isEmpty()) {
      product.setProductByContractor((ProductByContractor) l.get(0));
    }
  }
  
  public static List<IProduct> getProducts(long contractorId, String input) {
    List<IProduct> list = new ArrayList<>();
    IProduct product;
    // Contractor coded
    if(input.matches("\\##.*")) {
      product = getProduct(contractorId, input.substring(2));
      if(product != null) list.add(product);
    // Coded
    } else if(input.matches("\\#.*")) {
      product = getProduct(input.substring(1));
      if(product != null) list.add(product);
    // Coded or Contractor coded
    } else {
      product = getProduct(input);
      setContractorProduct(product, contractorId);
      if(product != null) list.add(product);
      product = getProduct(contractorId, input);
      if(product != null) list.add(product);
    }
    // Product description
    if(list.isEmpty()) {
      list.addAll(Product.getProducts(input, true));
    }
    // Concept description
    if(list.isEmpty()) {
      list.addAll(ProductUncoded.getProducts(input, true));
    }
    // Product similarities
    if(list.size() < 10) {
      list.addAll(Product.getProducts(input, false));
    }
    // Concept similarities
    if(list.size() < 10) {
      list.addAll(ProductUncoded.getProducts(input, false));
    }
    return list;
  }
 
  public static IProduct getProductFromText(long contractorId, String text) {
    String parts[] = text.split(Chars.forward().regexp().spaced().toString());
    if(parts.length == 2) { // program generated
      if(parts[0].startsWith("##")) {
        return getProduct(contractorId, parts[0].substring(2));
      } else if(parts[0].startsWith("#")) {
        IProduct prod = getProduct(parts[0].substring(1));
        setContractorProduct(prod, contractorId);
        return prod;
      }
    } else if(!Strings.isBlank(text)) { // manual input
      IProduct prod;
      // Contractor coded
      if(text.matches("\\##.*")) {
        prod = getProduct(contractorId, text.substring(2));
      // Coded
      } else if(text.matches("\\#.*")) {
        prod = getProduct(text.substring(1));
        setContractorProduct(prod, contractorId);
      // Coded or Contractor coded
      } else {
        prod = getProduct(text);
        setContractorProduct(prod, contractorId);
        if(prod == null) {
          prod = getProduct(contractorId, text);
        }
      }
      if(prod != null) {
        return prod;
      }
      return new ProductUncoded(text);
    }
    return null;
  }
 
  public static void setPriceTax(DocumentLine dl, IProduct prod) {
    if(dl.getPrice() == 0.0 && dl.getTax() == 0.0) {
      LineType lt = dl.getLineType();
      if(lt != null) {
        if(lt.getStockCoefficient() == -1) {
          dl.setPrice(prod.getProductPrice());
          dl.setTax(prod.getProductPriceTax());
        } else if(lt.getStockCoefficient() == 1) {
          dl.setPrice(prod.getProductCost());
          dl.setTax(prod.getProductCostTax());
        }
      }
    }
  }
 
  private ProductFactory() {
  }
 
}