contract/ProductGrid.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.contract;
 
import java.util.logging.Level;
import java.util.logging.Logger;
import org.amic.util.db.Converter;
import org.turro.string.Strings;
import org.turro.elephant.context.ElephantContext;
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.financials.product.ProductCombobox;
import org.turro.i18n.I_;
import org.turro.zkoss.grid.CollectionGrid;
import org.turro.zkoss.grid.EditableCell;
import org.zkoss.zk.ui.HtmlBasedComponent;
import org.zkoss.zk.ui.ext.AfterCompose;
import org.zkoss.zul.Row;
 
public class ProductGrid extends CollectionGrid<ProductByContractor> implements AfterCompose {
 
  private Contract contract;
 
  public ProductGrid() {
    super();
    addColumns();
  }
 
  public Contract getContract() {
    return contract;
  }
 
  public void setContract(Contract contract) {
    this.contract = contract;
    setCollection(new FinancialsPU().getResultList(
            "select pbc from ProductByContractor pbc " +
            "where pbc.contract = ?",
            new Object[] { contract }
            ));
  }
  
  @Override
  protected void initiateRow(Row row, ProductByContractor value) {
    if(value == null) {
      value = new ProductByContractor();
      value.setContract(contract);
    }
    row.setValue(value);
  }
 
  @Override
  protected boolean deleteRow(Row row) {
    Object count = new FinancialsPU().getSingleResultOrNull(
            "select count(dl) from DocumentLine dl " +
            "where dl.productByContractor = ?",
            new Object[] { row.getValue() }
            );
    return new Converter(count).getLong() > 0 ? false : true;
  }
 
  @Override
  protected boolean isValid(ProductByContractor v) {
    return v.getProduct() != null && ! Strings.isBlank(v.getContractorCode());
  }
 
  @Override
  protected HtmlBasedComponent createEditor(EditableCell editableCell) {
    if(editableCell.getCellIndex() == 0) {
      Object value = getCellValue(editableCell);
      ProductCombobox cdc = new ProductCombobox();
      if(value != null) cdc.setObjectValue((Product) value);
      return cdc;
    }
    return super.createEditor(editableCell);
  }
 
  @Override
  protected String formatCell(EditableCell editableCell, Object value) {
    if(editableCell.getCellIndex() == 0) {
      Product prod = ((Product) value);
      if(prod != null) {
        return prod.getProductString();
      }
      return "";
    }
    return super.formatCell(editableCell, value);
  }
 
  private void addColumns() {
    try {
      addColumn(I_.get("Product"), Product.class,
              "product", null, 0, false, false).setWidth("40%");
      addColumn(I_.get("Identifier"), String.class,
              "contractorCode", null, 0, false, false).setWidth("20%");
      addColumn(I_.get("Tax"), "double",
              "tax", null, 0, false, false).setWidth("20%");
      addColumn(I_.get("Price"), "double",
              "price", null, 0, false, false).setWidth("20%");
    } catch (ClassNotFoundException ex) {
      Logger.getLogger(ProductGrid.class.getName()).log(Level.SEVERE, ElephantContext.logMsg(null), ex);
    }
  }
 
}