FormulaResults.java

Go to the documentation of this file.

package org.turro.crm.search;
 
import org.turro.crm.db.CrmPU;
import org.turro.crm.entity.Formula;
import org.turro.crm.entity.FormulaType;
import org.turro.elephant.db.WhereClause;
import org.turro.jpa.Dao;
 
public class FormulaResults {
 
  private FormulaType type;
 
  public FormulaResults() {
    this(null);
  }
 
  public FormulaResults(FormulaType type) {
    this.type = type;
  }
 
  public java.util.List<Formula> getFormulaList() {
    Dao dao = new CrmPU();
    return dao.getResultList(createCriteria());
  }
 
  public WhereClause createCriteria() {
    WhereClause wc = new WhereClause();
 
    wc.addClause("select distinct formula from Formula as formula");
    wc.addClause("where 1=1");
    
    if(type != null) {
      wc.addClause("and formula.type = :type");
      wc.addNamedValue("type", type);
    }
    
    wc.addClause("order by formula.name");
 
    return wc;
  }
 
}