VendorCombobox.java

Go to the documentation of this file.

package org.turro.crm.zul.vendor;
 
import java.util.LinkedList;
import org.turro.auth.Authentication;
import org.turro.crm.db.CrmPU;
import org.turro.crm.entity.Vendor;
import org.turro.elephant.db.WhereClause;
import org.turro.jpa.Dao;
import org.turro.zkoss.input.GenericCombobox;
 
public class VendorCombobox extends GenericCombobox<Vendor> {
 
  public void setSelectSelf(boolean selectSelf) {
    if(selectSelf) {
      Dao dao = new CrmPU();
      WhereClause wc = new WhereClause();
      wc.addClause("select vendor from Vendor as vendor");
      wc.addClause("where vendor.idContact = :id");
      wc.addNamedValue("id", Authentication.getIContact().getId());
      setObjectValue((Vendor) dao.getSingleResultOrNull(wc));
    }
  }
  
  @Override
  public void populateList(String value, LinkedList list, int nRows) {
    Dao dao = new CrmPU();
    WhereClause wc = new WhereClause();
    wc.addClause("select vendor from Vendor as vendor");
    wc.addClause("where 1=1");
    wc.addLikeFields(new String[] {"vendor.name"}, value);
    wc.addClause("order by vendor.name");
    list.addAll(dao.getResultList(wc, nRows));
  }
 
  @Override
  public String getTextFromObject(Vendor value) {
    return value.getName();
  }
 
}