bsfinancials-core/src/main/java/org/turro/financials/model/product/ProductWrapper.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.product;
 
import java.util.List;
import org.turro.financials.db.FinancialsPU;
import org.turro.financials.entity.Contract;
import org.turro.financials.entity.Product;
import org.turro.financials.entity.ProductByContractor;
import org.turro.jpa.Dao;
import org.turro.jpa.entity.DaoEntity;
 
public class ProductWrapper extends DaoEntity<Product, Long> {
 
  public ProductWrapper(Product entity) {
    super(entity);
  }
 
  @Override
  protected Dao createDao() {
    return new FinancialsPU();
  }
 
  @Override
  public boolean canDelete() {
    if(!super.canDelete()) return false;
    Long count = (Long) getDao().getSingleResult(
            "select count(*) from DocumentLine " +
            "where product = ?",
            new Object[] { entity });
    if(count == 0) {
      count = (Long) getDao().getSingleResult(
              "select count(*) from DocumentLine " +
              "where productByContractor.product = ?",
              new Object[] { entity });
    }
    return count == 0;
  }
 
  @Override
  protected boolean shouldLog() {
    return true;
  }
  
  public Product save(List<ProductByContractor> pbc) {
    if(pbc != null) {
      entity.getProductByContractors().clear();
      entity.getProductByContractors().addAll(pbc);
    }
    return save();
  }
 
  @Override
  public boolean canSave() {
    Long count = entity.getId() > 0 ? 0 : (Long) getDao().getSingleResult(
            "select count(*) from Product " +
            "where productCode = ?",
            new Object[] { entity.getProductCode() });
    return count == 0;
  }
  
  public static boolean hasAvailableContractorProducts(Contract contract) {
    Dao dao = new FinancialsPU();
    Long result = (Long) dao.getSingleResult(
              "select count(pbp) from ProductByContractor as pbp " +
              "where pbp.contract = ?",
              new Object[] {
                contract
              }
            );
    if(result == null || result == 0) {
      return false;
    }
    return true;
  }
 
  public static boolean hasAvailableProducts() {
    Dao dao = new FinancialsPU();
    Long result = (Long) dao.getSingleResult(
              "select count(p) from Product as p"
            );
    if(result == null || result == 0) {
      return false;
    }
    return true;
  }
 
}