HoursEdit.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.*;
import org.turro.erp.humanres.HumanResourceCombobox;
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 HoursEdit extends GenericForwardComposer {
 
  private HoursGrid hoursGrid, hoursHistGrid;
  private HumanResourceCombobox humanres;
  private Textbox docnumber;
  private Datebox docdate;
  private Button doccreate;
  private Label lWorkOrder, lOrderReference;
  
  public void onClick$doccreate() {
    for(HoursItem hi : hoursGrid.getValues()) {
      if(hi.isValid()) {
        if(hoursGrid.isReceipt()) {
          createReceipt(humanres.getObjectValue(), docnumber.getValue(), docdate.getValue(), hi);
        } else {
          createOrder(humanres.getObjectValue(), docnumber.getValue(), docdate.getValue(), hi);
        }
      }
    }
    hoursGrid.clearValidRows();
    if(hoursHistGrid != null) {
      hoursHistGrid.refreshUsing(humanres.getObjectValue(), docnumber.getValue(), docdate.getValue());
    }
  }
  
  public void onChange$docdate() {
    hoursGrid.setDocumentDate(docdate.getValue());
    if(hoursHistGrid != null) {
      hoursHistGrid.refreshUsing(humanres.getObjectValue(), docnumber.getValue(), docdate.getValue());
    }
    updateButton();
  }
 
  public void onChange$docnumber() {
    if(hoursHistGrid != null) {
      hoursHistGrid.refreshUsing(humanres.getObjectValue(), docnumber.getValue(), docdate.getValue());
    }
    updateButton();
  }
 
  public void onChange$humanres() {
    if(hoursHistGrid != null) {
      hoursHistGrid.refreshUsing(humanres.getObjectValue(), docnumber.getValue(), docdate.getValue());
    }
    updateButton();
  }
 
  public void onChange$hoursGrid() {
    updateButton();
  }
 
  public void onChanging$hoursGrid() {
    EditableCell ec = hoursGrid.getCurrentCell();
    if(ec != null) {
      HoursItem pi = (HoursItem) 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().getSomeDescription());
      }
    }
  }
 
  public void onChanging$hoursHistGrid() {
    EditableCell ec = hoursGrid.getCurrentCell();
    if(ec != null) {
      HoursItem hi = (HoursItem) ec.getRow().getValue();
      if(hi != null) {
        lWorkOrder.setValue(hi.getWorkOrder() == null ? null : hi.getWorkOrder().getSomeDescription());
        lOrderReference.setValue(hi.getOrderReference() == null ? null : hi.getOrderReference().getSomeDescription());
      }
    }
  }
 
  private void updateButton() {
    doccreate.setDisabled(
            humanres.getObjectValue() == null ||
            Strings.isEmpty(docnumber.getValue()) ||
            docdate.getValue() == null ||
            hoursGrid.getValues().isEmpty()
            );
  }
 
  @Override
  public void doAfterCompose(Component comp) throws Exception {
    super.doAfterCompose(comp);
    docdate.setValue(new Date());
    doccreate.setDisabled(true);
    hoursGrid.setDocumentDate(docdate.getValue());
  }
 
  private void createOrder(HumanResource humanResource, String documentNumber, Date documentDate, HoursItem hi) {
    Dao dao = new ErpPU();
    if(hi.getResourceAptitude() == null) {
      // Find Human Resource RequiredUsage
      RequiredUsage ru = (RequiredUsage) dao.getSingleResultOrNull(
              "select ru from RequiredUsage ru " +
              "where task = ? " +
              "and humanResource = ?",
              new Object[] { hi.getTask(), humanResource });
      // Or create it
      if(ru == null) {
        ru = new RequiredUsage();
        ru.setTask(hi.getTask());
        ru.getTask().getRequiredUsages().add(ru);
        ru.setPurchaseMode(PurchaseMode.PURCHASE_IMMEDIATELY);
        ru.setPurchaseLag(0);
        ru.setHumanResourceAptitude(humanResource.getDefaultHumanResourceAptitude(documentDate));
        ru.setUnits(0);
        ru.setDedication(hi.getDedication());
        ru = dao.saveObject(ru);
      }
      // Create DraftOrder
      OrderItem oi = ru.startOrder();
      oi.setDocumentDate(documentDate);
      oi.setDocumentNumber("*" + documentNumber);
      oi = dao.saveObject(oi);
    } else {
      // Find Resource RequiredUsage
      RequiredUsage ru = (RequiredUsage) dao.getSingleResultOrNull(
              "select ru from RequiredUsage ru " +
              "where task = ? " +
              "and resource = ? " +
              "and humanResource = ? " +
              "and aptitudeDegree = ?",
              new Object[] { hi.getTask(), hi.getResourceAptitude().getResource(), 
                humanResource, hi.getResourceAptitude().getAptitudeDegree() });
      // Or create it
      if(ru == null) {
        ru = new RequiredUsage();
        ru.setTask(hi.getTask());
        ru.getTask().getRequiredUsages().add(ru);
        ru.setPurchaseMode(PurchaseMode.PURCHASE_IMMEDIATELY);
        ru.setPurchaseLag(0);
        ru.setResourceAptitude(hi.getResourceAptitude());
        ru.setHumanResource(humanResource);
        ru.setUnits(hi.getUnits());
        ru.setDedication(hi.getDedication());
        ru = dao.saveObject(ru);
      }
      // Create DraftOrder
      OrderItem oi = ru.startOrder();
      oi.setDocumentDate(documentDate);
      oi.setDocumentNumber("*" + documentNumber);
      oi = dao.saveObject(oi);
    }
  }
 
  private void createReceipt(HumanResource humanResource, String documentNumber, Date documentDate, HoursItem hi) {
    Dao dao = new ErpPU();
    if(hi.getResourceAptitude() == null) {
      // Find Human Resource RequiredUsage
      RequiredUsage ru = (RequiredUsage) dao.getSingleResultOrNull(
              "select hru from HumanResourceUsage hru " +
              "where task = ? " +
              "and humanResource = ?",
              new Object[] { hi.getTask(), humanResource });
      // Or create it
      if(ru == null) {
        ru = new RequiredUsage();
        ru.setTask(hi.getTask());
        ru.getTask().getRequiredUsages().add(ru);
        ru.setPurchaseMode(PurchaseMode.PURCHASE_IMMEDIATELY);
        ru.setPurchaseLag(0);
        ru.setHumanResourceAptitude(humanResource.getDefaultHumanResourceAptitude(documentDate));
        ru.setUnits(0);
        ru.setDedication(hi.getDedication());
        ru = dao.saveObject(ru);
      }
      // Create DraftOrder
      OrderItem oi = ru.startOrder();
      oi.setDocumentDate(documentDate);
      oi.setDocumentNumber("*" + documentNumber);
      oi = dao.saveObject(oi);
      
      ReceiptItem ri = oi.startReceipt(hi.getStartWorking());
      dao.saveObject(ri);
      if(ri.getOrderItem().getRelated() != null) {
        ri = ri.getOrderItem().getRelated().getReceiptItems().iterator().next();
        dao.saveObject(ri);
      }
    } else {
      // Find Resource RequiredUsage
      RequiredUsage ru = (RequiredUsage) dao.getSingleResultOrNull(
              "select hru from HumanResourceUsage hru " +
              "where task = ? " +
              "and resource = ? " +
              "and humanResource = ? " +
              "and aptitudeDegree = ?",
              new Object[] { hi.getTask(), hi.getResourceAptitude().getResource(), 
                humanResource, hi.getResourceAptitude().getAptitudeDegree() });
      // Or create it
      if(ru == null) {
        ru = new RequiredUsage();
        ru.setTask(hi.getTask());
        ru.getTask().getRequiredUsages().add(ru);
        ru.setPurchaseMode(PurchaseMode.PURCHASE_IMMEDIATELY);
        ru.setPurchaseLag(0);
        ru.setResourceAptitude(hi.getResourceAptitude());
        ru.setHumanResource(humanResource);
        ru.setUnits(hi.getUnits());
        ru.setDedication(hi.getDedication());
        ru = dao.saveObject(ru);
      }
      // Create DraftOrder
      OrderItem oi = ru.startOrder();
      oi.setDocumentDate(documentDate);
      oi.setDocumentNumber("*" + documentNumber);
      oi = dao.saveObject(oi);
      
      ReceiptItem ri = oi.startReceipt(hi.getStartWorking());
      dao.saveObject(ri);
      if(ri.getOrderItem().getRelated() != null) {
        ri = ri.getOrderItem().getRelated().getReceiptItems().iterator().next();
        dao.saveObject(ri);
      }
    }
  }
 
}