ResourceAptitude.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.resource;
 
import java.util.ArrayList;
import java.util.Collection;
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.Resource;
import org.turro.util.PhraseBuilder;
 
public class ResourceAptitude  {
  
  private Resource resource;
  private AptitudeDegree aptitudeDegree;
 
  public ResourceAptitude(Resource resource, AptitudeDegree aptitudeDegree) {
    this.resource = resource;
    this.aptitudeDegree = aptitudeDegree;
  }
 
  public Resource getResource() {
    return resource;
  }
 
  public AptitudeDegree getAptitudeDegree() {
    return aptitudeDegree;
  }
  
  public String getName() {
    PhraseBuilder pb = new PhraseBuilder();
    if(resource != null) {
      pb.addWord(resource.getName());
    }
    pb.addPendingSeparator(" -");
    if(aptitudeDegree != null) {
      pb.addWord(aptitudeDegree.getFullName());
    }
    return pb.toString();
  }
 
  @Override
  public String toString() {
    return getName();
  }
  
  public double getCost() {
    return resource.getCostHour() + aptitudeDegree.getCost();
  }
  
  public double getPrice() {
    return resource.getPriceHour() + aptitudeDegree.getPrice();
  }
  
  public double getMarketPrice() {
    return resource.getMarketPrice() + aptitudeDegree.getMarketPrice();
  }
  
  public static Collection<ResourceAptitude> load(String value, boolean onlyActive, int nRows) {
    ArrayList<ResourceAptitude> result = new ArrayList<ResourceAptitude>();
    EntityManager em = new ErpPU().getEntityManager();
    try {
      WhereClause wc = SQLHelper.getWhereClause(new String[]{
        "res.name"
      }, value);
      Query q = em.createQuery(
              "select res from Resource res " +
              "where res.active = :active " +
              wc.getClause() +
              " order by res.name"
              );
      wc.addNamedValue("active", onlyActive);
      q.setMaxResults(nRows);
      wc.setNamedParameters(q);
      List<Resource> l = q.getResultList();
      for(Resource hr : l) {
        for(AptitudeDegree ad : hr.getAptitudeDegrees()) {
          result.add(new ResourceAptitude(hr, ad));
        }
      }
    } finally {
      em.close();
    }
    return result;
  }
  
  public static ResourceAptitude get(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 Resource res " +
                " where res.name = :name");
        q.setParameter("name", name);
        q.setMaxResults(1);
        Resource hr = (Resource) q.getSingleResult();
        for(AptitudeDegree ad : hr.getAptitudeDegrees()) {
          if(ad.getFullName().equals(aptitude)) {
            return new ResourceAptitude(hr, ad);
          }
        }
      } catch(Exception ex) {
        return null;
      } finally {
        em.close();
      }
    }
    return null;
  }
 
}