SaleActionResults.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 SaleActionResults {
 
  private Application app = Application.getApplication();
 
  private boolean ckOthers, ckDone;
  private String saleActionValue = "*";
  private IContact byParticipant;
  private SaleProspect saleProspect;
 
  public SaleActionResults() {
  }
 
  public java.util.List getSaleActionList() {
    Dao dao = new CrmPU();
    return dao.getResultList(createCriteria());
  }
 
  public WhereClause createCriteria() {
    WhereClause wc = new WhereClause();
 
    wc.addClause("select distinct saleAction");
    wc.addClause("from SaleAction as saleAction");
    wc.addClause("where 1=1");
    
    if(Strings.isEmpty(saleActionValue) || (ckOthers && !app.isInRole("sale-prospect:all"))) {
      //TODO: check if necessary wc.addClause("and 0=1");
      wc.addClause("order by saleAction.actionDate");
      return wc;
    }
 
    if(byParticipant == null) {
      byParticipant = Authentication.getIContact();
    }
 
    wc = SQLHelper.getWhereClause(wc, new String[] {
              "saleAction.comment"
              }, (saleActionValue == null ? "" : saleActionValue.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 = saleAction.vendorProspect.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 = saleAction.vendorProspect.saleProspect"
              );
      wc.addNamedValue("idVendor", byParticipant.getId());
 
      wc.addClause("))");
    }
 
    if(!ckDone) {
      wc.addClause("and saleAction.done = FALSE");
    }
 
    if(saleProspect != null) {
      wc.addClause("and saleAction.vendorProspect.saleProspect = :saleProspect");
      wc.addNamedValue("saleProspect", saleProspect);
    }
    
    wc.addClause("order by saleAction.actionDate");
 
    return wc;
  }
 
  public IContact getByParticipant() {
    return byParticipant;
  }
 
  public void setByParticipant(IContact byParticipant) {
    this.byParticipant = byParticipant;
  }
 
  public boolean isCkDone() {
    return ckDone;
  }
 
  public void setCkDone(boolean ckDone) {
    this.ckDone = ckDone;
  }
 
  public boolean isCkOthers() {
    return ckOthers;
  }
 
  public void setCkOthers(boolean ckOthers) {
    this.ckOthers = ckOthers;
  }
 
  public String getSaleActionValue() {
    return saleActionValue;
  }
 
  public void setSaleActionValue(String saleActionValue) {
    this.saleActionValue = saleActionValue;
  }
 
  public SaleProspect getSaleProspect() {
    return saleProspect;
  }
 
  public void setSaleProspect(SaleProspect saleProspect) {
    this.saleProspect = saleProspect;
  }
 
}