ProductsEdit.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2012 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.erp.purchase;
 
import java.util.Date;
import org.turro.string.Strings;
import org.turro.erp.db.ErpPU;
import org.turro.erp.entity.OrderItem;
import org.turro.erp.entity.PurchaseMode;
import org.turro.erp.entity.ReceiptItem;
import org.turro.erp.entity.RequiredUsage;
import org.turro.financials.contract.ProviderCombobox;
import org.turro.financials.entity.Contract;
import org.turro.jpa.Dao;
import org.turro.zkoss.grid.EditableCell;
import org.zkoss.zk.ui.Component;
import org.zkoss.zk.ui.util.GenericForwardComposer;
import org.zkoss.zul.Button;
import org.zkoss.zul.Datebox;
import org.zkoss.zul.Label;
import org.zkoss.zul.Textbox;
 
public class ProductsEdit extends GenericForwardComposer {
 
  private ProductsGrid productsGrid;
  private ProviderCombobox provider;
  private Textbox docnumber;
  private Datebox docdate;
  private Button doccreate;
  private Label lWorkOrder, lOrderReference;
  
  public void onClick$doccreate() {
    for(ProductsItem hi : productsGrid.getValues()) {
      if(hi.isValid()) {
        if(productsGrid.isReceipt()) {
          createReceipt(provider.getObjectValue(), docnumber.getValue(), docdate.getValue(), hi);
        } else {
          createOrder(provider.getObjectValue(), docnumber.getValue(), docdate.getValue(), hi);
        }
      }
    }
    productsGrid.clearValidRows();
  }
  
  public void onChange$docdate() {
    updateButton();
  }
 
  public void onChange$docnumber() {
    updateButton();
  }
 
  public void onChange$provider() {
    updateButton();
  }
 
  public void onChange$productsGrid() {
    updateButton();
  }
 
  public void onChanging$productsGrid() {
    EditableCell ec = productsGrid.getCurrentCell();
    if(ec != null) {
      ProductsItem pi = (ProductsItem) ec.getRow().getValue();
      if(pi != null) {
        lWorkOrder.setValue(pi.getWorkOrder() == null ? null : 
                "#" + pi.getWorkOrder().getWorkOrderId() + "\n" + pi.getWorkOrder().getSomeDescription());
        lOrderReference.setValue(pi.getOrderReference() == null ? null : 
                "#" + pi.getOrderReference().getOrderRef() + "\n" + pi.getOrderReference().getDescription());
      }
    }
  }
 
  private void updateButton() {
    doccreate.setDisabled(
            provider.getObjectValue() == null ||
            Strings.isEmpty(docnumber.getValue()) ||
            docdate.getValue() == null ||
            productsGrid.getValues().isEmpty()
            );
  }
 
  @Override
  public void doAfterCompose(Component comp) throws Exception {
    super.doAfterCompose(comp);
    docdate.setValue(new Date());
    doccreate.setDisabled(true);
  }
 
  private void createOrder(Contract provider, String documentNumber, Date documentDate, ProductsItem pi) {
    Dao dao = new ErpPU();
    // Find Product Usage
    RequiredUsage ru;
    if(pi.getIProduct().isUncoded()) {
      ru = (RequiredUsage) dao.getSingleResultOrNull(
              "select pu from RequiredUsage pu " +
              "where task = ? " +
              "and description = ?",
              new Object[] { pi.getTask(), pi.getIProduct().getProductCodeStr() });
    } else {
      ru = (RequiredUsage) dao.getSingleResultOrNull(
              "select pu from RequiredUsage pu " +
              "where task = ? " +
              "and productId = ?",
              new Object[] { pi.getTask(), pi.getIProduct().getProductId() });
    }
    // Or create it
    if(ru == null) {
      ru = new RequiredUsage();
      ru.setTask(pi.getTask());
      ru.getTask().getRequiredUsages().add(ru);
      ru.setPurchaseMode(PurchaseMode.PURCHASE_IMMEDIATELY);
      ru.setPurchaseLag(0);
      ru.setIProduct(pi.getIProduct());
      ru.setUnits(pi.getUnits());
      ru = dao.saveObject(ru);
    }
    // Or create DraftOrder
    OrderItem dro = ru.startOrder();
    dro.setDocumentDate(documentDate);
    dro.setDocumentNumber("*" + documentNumber);
    dro.setProviderId(provider.getId());
    dao.saveObject(dro);
  }
 
 
  private void createReceipt(Contract provider, String documentNumber, Date documentDate, ProductsItem pi) {
    Dao dao = new ErpPU();
    // Find a DraftOrder
    OrderItem oi;
    if(pi.getIProduct().isUncoded()) {
      oi = (OrderItem) dao.getSingleResultOrNull(
              "select dro from OrderItem dro " +
              "where requiredUsage.task = ? " +
              "and providerId = ? " +
              "and requiredUsage.description = ?",
              new Object[] { pi.getTask(), provider.getId(), pi.getIProduct().getProductCodeStr() });
    } else {
      oi = (OrderItem) dao.getSingleResultOrNull(
              "select dro from OrderItem dro " +
              "where requiredUsage.task = ? " +
              "and providerId = ? " +
              "and requiredUsage.productId = ?",
              new Object[] { pi.getTask(), provider.getId(), pi.getIProduct().getProductId() });
    }
    if(oi == null) {
      // Find Product Usage
      RequiredUsage pu;
      if(pi.getIProduct().isUncoded()) {
        pu = (RequiredUsage) dao.getSingleResultOrNull(
                "select pu from RequiredUsage pu " +
                "where requiredUsage.task = ? " +
                "and description = ?",
                new Object[] { pi.getTask(), pi.getIProduct().getProductCodeStr() });
      } else {
        pu = (RequiredUsage) dao.getSingleResultOrNull(
                "select pu from RequiredUsage pu " +
                "where requiredUsage.task = ? " +
                "and productId = ?",
                new Object[] { pi.getTask(), pi.getIProduct().getProductId() });
      }
      // Or create it
      if(pu == null) {
        pu = new RequiredUsage();
        pu.setTask(pi.getTask());
        pu.getTask().getRequiredUsages().add(pu);
        pu.setPurchaseMode(PurchaseMode.PURCHASE_IMMEDIATELY);
        pu.setPurchaseLag(0);
        pu.setIProduct(pi.getIProduct());
        pu.setUnits(pi.getUnits());
        pu = dao.saveObject(pu);
      }
      // Or create DraftOrder
      oi = pu.startOrder();
      oi.setDocumentDate(documentDate);
      oi.setDocumentNumber("*" + documentNumber);
      oi.setProviderId(provider.getId());
      dao.saveObject(oi);
    }
    // Create DraftReceipt
    ReceiptItem ri = oi.startReceipt(null);
    dao.saveObject(ri);
    if(ri.getOrderItem().getRelated() != null) {
      ri = ri.getOrderItem().getRelated().getReceiptItems().iterator().next();
      dao.saveObject(ri);
    }
  }
 
}