HoursGrid.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.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;
import org.amic.util.date.CheckDate;
import org.turro.elephant.context.Application;
import org.turro.elephant.util.DateFormats;
import org.turro.elephant.util.DecimalFormats;
import org.turro.erp.db.ErpPU;
import org.turro.erp.entity.HumanResource;
import org.turro.erp.entity.Task;
import org.turro.erp.entity.WorkOrder;
import org.turro.erp.reference.OrderReferenceGrid;
import org.turro.erp.reference.OrderReferencePositionListbox;
import org.turro.erp.resource.ResourceAptitude;
import org.turro.erp.resource.ResourceAptitudeCombobox;
import org.turro.erp.task.TaskListbox;
import org.turro.jpa.Dao;
import org.turro.zkoss.grid.CollectionGrid;
import org.turro.zkoss.grid.EditableCell;
import org.turro.zkoss.grid.EditableColumn;
import org.turro.zkoss.input.Percentbox;
import org.zkoss.zk.ui.HtmlBasedComponent;
import org.zkoss.zk.ui.event.Event;
import org.zkoss.zk.ui.event.EventListener;
import org.zkoss.zk.ui.event.Events;
import org.zkoss.zk.ui.ext.AfterCompose;
import org.zkoss.zul.Row;
 
public class HoursGrid extends CollectionGrid<HoursItem> implements AfterCompose {
 
  private long lastWorkOrderId;
  private int lastOrderRef;
  private Date lastDate;
  private Task lastTask;
  private ResourceAptitude lastResource;
  private String lastConcept;
  private boolean receipt;
 
  public HoursGrid() {
    addColumns();
  }
 
  public boolean isReceipt() {
    return receipt;
  }
 
  public void setReceipt(boolean receipt) {
    this.receipt = receipt;
  }
 
  public void setDocumentDate(Date documentDate) {
    if(lastDate == null) {
      lastDate = new CheckDate(documentDate).setHour(8).setMinute(0).setSecond(0).getDate();
    }
  }
 
  @Override
  protected void initiateRow(Row row, HoursItem value) {
    if(value == null) {
      value = new HoursItem();
      value.setDedication(1.0);
      value.setWorkOrderId(lastWorkOrderId);
      value.setOrderRef(lastOrderRef);
      value.setStartWorking(lastDate);
      value.setTask(lastTask);
      value.setConcept(lastConcept);
      value.setResourceAptitude(lastResource);
    }
    row.setValue(value);
  }
 
  @Override
  protected boolean deleteRow(Row row) {
    return true;
  }
 
  @Override
  protected boolean isValid(HoursItem v) {
    return v.isValid();
  }
 
  @Override
  protected HtmlBasedComponent createEditor(final EditableCell editableCell) {
    if(editableCell.getColumn() instanceof EditableColumn) {
      final HoursItem hoursItem = (HoursItem) editableCell.getRow().getValue();
      if(hoursItem.getStartWorking() == null) {
        hoursItem.setStartWorking(lastDate);
      }
      EditableColumn ec = (EditableColumn) editableCell.getColumn();
      if(ec.getLabel().equals(Application.getString("lReference"))) {
        Object value = getCellValue(editableCell);
        final OrderReferencePositionListbox orplb = new OrderReferencePositionListbox();
        orplb.setMold("select");
        orplb.setAllowNull(true);
        orplb.setNullAtBottom(true);
        orplb.setNullLabel("lNewReference");
        orplb.setWorkOrder(hoursItem.getWorkOrder());
        // line value must update with new selection
        orplb.addEventListener(Events.ON_SELECT, new EventListener() {
          @Override
          public void onEvent(Event event) throws Exception {
            Integer oref = orplb.getObjectValue();
            if(oref != null) {
              hoursItem.setOrderRef(oref);
              Events.postEvent(new Event(Events.ON_CHANGING, HoursGrid.this, editableCell));
            }
          }
        });
        if(value != null) orplb.setObjectValue((Integer) value);
        return orplb;
      } else if(ec.getJavaClass().equals(Task.class)) {
        Object value = getCellValue(editableCell);
        TaskListbox tlb = new TaskListbox();
        tlb.setMold("select");
        tlb.setAllowNull(true);
        tlb.setNullAtBottom(true);
        tlb.setNullLabel("lNewTask");
        tlb.setOrderReference(hoursItem.getOrderReference());
        if(value != null) tlb.setObjectValue((Task) value);
        return tlb;
      } else if(ec.getJavaClass().equals(ResourceAptitude.class)) {
        Object value = getCellValue(editableCell);
        ResourceAptitudeCombobox racb = new ResourceAptitudeCombobox();
        if(value != null) racb.setObjectValue((ResourceAptitude) value);
        return racb;
      } else if(ec.getLabel().equals(Application.getString("lDedication"))) {
        Object value = getCellValue(editableCell);
        Percentbox pc = new Percentbox();
        if(value != null) pc.setValue((Double) value);
        return pc;
      }
    }
    return super.createEditor(editableCell);
  }
 
  @Override
  protected String formatCell(EditableCell editableCell, Object value) {
    HoursItem hoursItem = (HoursItem) editableCell.getRow().getValue();
    lastWorkOrderId = hoursItem.getWorkOrderId();
    lastOrderRef = hoursItem.getOrderRef();
    lastDate = hoursItem.getStartWorking();
    lastTask = hoursItem.getTask();
    lastResource = hoursItem.getResourceAptitude();
    lastConcept = hoursItem.getConcept();
    if(value instanceof Task) {
      Task t = ((Task) value);
      return t.getName();
    } else if(value instanceof ResourceAptitude) {
      ResourceAptitude r = ((ResourceAptitude) value);
      return r.getName();
    } else if(editableCell.getColumn().getLabel().equals(Application.getString("lDedication"))) {
      return DecimalFormats.format(((Double) value) * 100.0) + "%";
    }
    return super.formatCell(editableCell, value);
  }
 
  @Override
  protected void cellChanged(EditableCell editableCell, Object value) {
    if(editableCell.getColumn() instanceof EditableColumn) {
      EditableColumn ec = (EditableColumn) editableCell.getColumn();
      if(ec.getLabel().equals(Application.getString("lAutomatic"))) {
        updateRow(editableCell.getRow());
      }
    }
    super.cellChanged(editableCell, value);
  }
 
  @Override
  protected boolean isCellValid(EditableCell editableCell, Object value) {
    if(editableCell.getColumn() instanceof EditableColumn) {
      EditableColumn ec = (EditableColumn) editableCell.getColumn();
      if(ec.getLabel().equals(Application.getString("lWorkOrder"))) {
        return WorkOrder.getByWorkOrderId((Long) value) != null;
      }
    }
    return super.isCellValid(editableCell, value);
  }
 
  private void addColumns() {
    try {
      addColumn(Application.getString("lWorkOrder"), "long", "workOrderId", null, 0, false, false).setWidth("100px");
      addColumn(Application.getString("lReference"), "int", "orderRef", null, 0, false, false).setWidth("100px");
      addColumn(Application.getString("lTask"), Task.class, "task", null, 3, false, false).setHflex("1");
      addColumn(Application.getString("lDate"), Date.class, "startWorking", DateFormats.getDefaultDateTimeFormat(), 0, false, false).setWidth("150px");
      addColumn(Application.getString("lHours"), "double", "units", null, 2, false, false).setWidth("60px");
      addColumn(Application.getString("lCostHour"), "double", "costHour", null, 2, false, false).setWidth("60px");
      addColumn(Application.getString("lDedication"), "double", "dedication", null, 2, false, false).setWidth("80px");
      addColumn(Application.getString("lConcept"), String.class, "concept", null, 0, false, false).setHflex("1");
      addColumn(Application.getString("lResource"), ResourceAptitude.class, "resourceAptitude", null, 0, false, false).setHflex("1");
      addColumn(Application.getString("lAutomatic"), "boolean", "automatic", null, 0, false, false).setWidth("90px");
    } catch (ClassNotFoundException ex) {
      Logger.getLogger(OrderReferenceGrid.class.getName()).log(Level.SEVERE, null, ex);
    }
  }
 
  public void refreshUsing(HumanResource humanResource, String documentNumber, Date documentDate) {
    Dao dao = new ErpPU();
    List<HoursItem> l = new ArrayList<HoursItem>();
//    for(HoursReceipt hr : (List<HoursReceipt>) dao.getResultList(
//            "select hr from HoursReceipt as hr where humanReceipt.draftOrder.humanResourceUsage.humanResource = ? and documentNumber = ? and documentDate = ?",
//            new Object[] { humanResource, documentNumber, documentDate })) {
//      l.add(new HoursItem(hr));
//    }
//    for(HoursReceipt hr : (List<HoursReceipt>) dao.getResultList(
//            "select hr from HoursReceipt as hr where resourceReceipt.draftOrder.resourceUsage.support = ? and documentNumber = ? and documentDate = ?",
//            new Object[] { humanResource, documentNumber, documentDate })) {
//      l.add(new HoursItem(hr));
//    }
    updateCollection(l);
  }
  
}