SaleProspectResults.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.crm.entity.SaleProspect;
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 SaleProspectResults {
 
  private Application app = Application.getApplication();
 
  private boolean ckOthers;
  private String saleProspectValue = "*";
  private IContact byParticipant;
 
  public SaleProspectResults() {
  }
 
  public java.util.List<SaleProspect> getSaleProspectList() {
    Dao dao = new CrmPU();
    return dao.getResultList(createCriteria());
  }
 
  public WhereClause createCriteria() {
    WhereClause wc = new WhereClause();
 
    wc.addClause("select distinct saleProspect from SaleProspect as saleProspect");
    wc.addClause("where 1=1");
    
    if(Strings.isEmpty(saleProspectValue) || (ckOthers && !app.isInRole("sale-prospect:all"))) {
      wc.addClause("order by saleProspect.prospectDate");
      return wc;
    }
 
    if(byParticipant == null) {
      byParticipant = Authentication.getIContact();
    }
 
    wc = SQLHelper.getWhereClause(wc, new String[] {
              "saleProspect.description"
              }, (saleProspectValue == null ? "" : saleProspectValue.replaceAll("\\*", "%")));
 
    if(!(ckOthers && app.isInRole("sale-prospect:all"))) {
      wc.addClause("and ( exists (");
 
      wc.addClause(
              "select co from CustomerOwner as co where co.vendor.idContact = :idOwner " +
              "and co.customer = saleProspect.customer"
              );
      wc.addNamedValue("idOwner", byParticipant.getId());
 
      wc.addClause(") or exists (");
 
      wc.addClause(
              "select vp from VendorProspect as vp where vp.vendor.idContact = :idVendor " +
              "and vp.saleProspect = saleProspect"
              );
      wc.addNamedValue("idVendor", byParticipant.getId());
 
      wc.addClause("))");
    }
 
    wc.addClause("order by saleProspect.prospectDate");
    
    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 getSaleProspectValue() {
    return saleProspectValue;
  }
 
  public void setSaleProspectValue(String saleProspectValue) {
    this.saleProspectValue = saleProspectValue;
  }
 
}