CustomerResults.java

Go to the documentation of this file.

package org.turro.crm.search;
 
import org.turro.auth.Authentication;
import org.turro.crm.db.CrmPU;
import org.turro.elephant.context.Application;
import org.turro.elephant.db.SQLHelper;
import org.turro.elephant.db.WhereClause;
import org.turro.jpa.Dao;
import org.turro.plugin.contacts.IContact;
import org.zkoss.lang.Strings;
 
public class CustomerResults {
 
  private Application app = Application.getApplication();
 
  private boolean ckOthers;
  private String customerValue = "*";
  private IContact byParticipant;
 
  public CustomerResults() {
  }
 
  public java.util.List getCustomerList() {
    Dao dao = new CrmPU();
    return dao.getResultList(createCriteria());
  }
 
  public WhereClause createCriteria() {
    WhereClause wc = new WhereClause();
 
    wc.addClause("select distinct customer");
    wc.addClause("from Customer as customer");
    wc.addClause("left outer join customer.ownedBy ownedBy");
    wc.addClause("where 1=1");
    
    if(Strings.isEmpty(customerValue) || (ckOthers && !app.isInRole("customer:all"))) {
      wc.addClause("order by customer.name");
      return wc;
    }
 
    if(byParticipant == null) {
      byParticipant = Authentication.getIContact();
    }
 
    wc = SQLHelper.getWhereClause(wc, new String[] {
              "customer.name"
              }, (customerValue == null ? "" : customerValue.replaceAll("\\*", "%")));
 
    if(!(ckOthers && app.isInRole("customer:all"))) {
      wc.addClause("and (");
 
      wc.addClause("ownedBy.vendor.idContact = :idOwner");
      wc.addNamedValue("idOwner", byParticipant.getId());
 
      wc.addClause("or exists (");
 
      wc.addClause(
              "select vp from VendorProspect as vp where vendor.idContact = :idVendor " +
              "and vp.saleProspect.customer = customer"
              );
      wc.addNamedValue("idVendor", byParticipant.getId());
 
      wc.addClause("))");
    }
 
    wc.addClause("order by customer.name");
    
    return wc;
  }
 
  public IContact getByParticipant() {
    return byParticipant;
  }
 
  public void setByParticipant(IContact byParticipant) {
    this.byParticipant = byParticipant;
  }
 
  public boolean isCkOthers() {
    return ckOthers;
  }
 
  public void setCkOthers(boolean ckOthers) {
    this.ckOthers = ckOthers;
  }
 
  public String getCustomerValue() {
    return customerValue;
  }
 
  public void setCustomerValue(String customerValue) {
    this.customerValue = customerValue;
  }
 
}