HumanResourceAptitude.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.hr.humanres;
 
import java.util.ArrayList;
import java.util.Collection;
import java.util.Date;
import java.util.List;
import javax.persistence.EntityManager;
import javax.persistence.Query;
import org.turro.elephant.db.SQLHelper;
import org.turro.elephant.db.WhereClause;
import org.turro.erp.db.ErpPU;
import org.turro.erp.entity.AptitudeDegree;
import org.turro.erp.entity.HumanResource;
import org.turro.erp.entity.OwnedAptitude;
import org.turro.util.PhraseBuilder;
 
public class HumanResourceAptitude {
  
  private HumanResource humanResource;
  private boolean canChange;
  private AptitudeDegree aptitudeDegree;
 
  public HumanResourceAptitude(HumanResource humanResource, boolean canChange, AptitudeDegree aptitudeDegree) {
    this.humanResource = humanResource;
    this.canChange = canChange;
    this.aptitudeDegree = aptitudeDegree;
  }
 
  public HumanResource getHumanResource() {
    return humanResource;
  }
 
  public AptitudeDegree getAptitudeDegree() {
    return aptitudeDegree;
  }
  
  public String getRealName() {
    PhraseBuilder pb = new PhraseBuilder();
    if(humanResource != null) {
      pb.addWord(humanResource.getName());
    }
    pb.addPendingSeparator(" -");
    if(aptitudeDegree != null) {
      pb.addWord(aptitudeDegree.getFullName());
    }
    return pb.toString();
  }
 
  public String getName() {
    PhraseBuilder pb = new PhraseBuilder();
    if(humanResource != null) {
      if(canChange) {
        pb.addWord("Variable");
      } else {
        pb.addWord(humanResource.getName());
      }
    }
    pb.addPendingSeparator(" -");
    if(aptitudeDegree != null) {
      pb.addWord(aptitudeDegree.getFullName());
    }
    return pb.toString();
  }
 
  @Override
  public String toString() {
    return getName();
  }
  
  public double getCost() {
    return humanResource.getCostHour() + aptitudeDegree.getCost();
  }
  
  public double getPrice() {
    return humanResource.getPriceHour() + aptitudeDegree.getPrice();
  }
  
  public double getMarketPrice() {
    return humanResource.getMarketPrice() + aptitudeDegree.getMarketPrice();
  }
  
  public static Collection<HumanResourceAptitude> load(Date date, String value, Collection<AptitudeDegree> required, boolean onlyActive, int nRows) {
    ArrayList<HumanResourceAptitude> result = new ArrayList<HumanResourceAptitude>();
    EntityManager em = new ErpPU().getEntityManager();
    try {
      WhereClause wc = SQLHelper.getWhereClause(new String[]{
        "res.name"
      }, value);
      Query q = em.createQuery(
              "select res from HumanResource res " +
              "where res.active = :active " +
              wc.getClause() +
              " order by res.name"
              );
      wc.addNamedValue("active", onlyActive);
      q.setMaxResults(nRows);
      wc.setNamedParameters(q);
      List<HumanResource> l = q.getResultList();
      for(HumanResource hr : l) {
        for(OwnedAptitude off : hr.getActiveAptitudes(date)) {
          if(required.isEmpty() || off.getAptitudeDegree().isIn(required)) {
            result.add(new HumanResourceAptitude(hr, false, off.getAptitudeDegree()));
          }
        }
      }
    } finally {
      em.close();
    }
    return result;
  }
  
  public static HumanResourceAptitude get(Date date, String text) {
    String s[] = text.split(" - ");
    if(s.length > 1) {
      String name = s.length == 3 ? s[0] + " - " + s[1] : s[0]; 
      String aptitude = s.length == 3 ? s[2] : s[1];
      EntityManager em = new ErpPU().getEntityManager();
      try {
        Query q = em.createQuery(
                " select res from HumanResource res " +
                " where res.name = :name");
        q.setParameter("name", name);
        q.setMaxResults(1);
        HumanResource hr = (HumanResource) q.getSingleResult();
        for(OwnedAptitude off : hr.getActiveAptitudes(date)) {
          if(off.getAptitudeDegree().getFullName().equals(aptitude)) {
            return new HumanResourceAptitude(hr, false, off.getAptitudeDegree());
          }
        }
      } catch(Exception ex) {
        return null;
      } finally {
        em.close();
      }
    }
    return null;
  }
}