CustomerCombobox.java

Go to the documentation of this file.

package org.turro.crm.zul.customer;
 
import java.util.LinkedList;
import java.util.List;
import org.turro.crm.db.CrmPU;
import org.turro.crm.entity.Customer;
import org.turro.elephant.db.WhereClause;
import org.turro.jpa.Dao;
import org.turro.zkoss.input.GenericCombobox;
 
public class CustomerCombobox extends GenericCombobox<Customer> {
 
  @Override
  public void populateList(String value, LinkedList list, int nRows) {
    Dao dao = new CrmPU();
    WhereClause wc = new WhereClause();
    wc.addClause("select customer from Customer as customer");
    wc.addClause("where 1=1");
    wc.addLikeFields(new String[] {"customer.name"}, value);
    wc.addClause("order by customer.name");
    List<Customer> l = dao.getResultList(wc, nRows);
    for(Object o : l) {
      list.add((Customer) o);
    }
  }
 
  @Override
  public String getTextFromObject(Customer value) {
    return value.getName();
  }
 
}