org.turro.crm.search.SaleProspectResults Class Reference

Public Member Functions
	SaleProspectResults ()
java.util.List< SaleProspect >	getSaleProspectList ()
WhereClause	createCriteria ()
IContact	getByParticipant ()
void	setByParticipant (IContact byParticipant)
boolean	isCkOthers ()
void	setCkOthers (boolean ckOthers)
String	getSaleProspectValue ()
void	setSaleProspectValue (String saleProspectValue)

Detailed Description

Author

llturro

Definition at line 17 of file SaleProspectResults.java.

Constructor & Destructor Documentation

SaleProspectResults()

org.turro.crm.search.SaleProspectResults.SaleProspectResults

(

)

Definition at line 25 of file SaleProspectResults.java.

                               {
  }

Member Function Documentation

createCriteria()

WhereClause org.turro.crm.search.SaleProspectResults.createCriteria

(

)

Definition at line 33 of file SaleProspectResults.java.

                                      {
    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;
  }

Here is the call graph for this function:

Here is the caller graph for this function:

getByParticipant()

IContact org.turro.crm.search.SaleProspectResults.getByParticipant

(

)

Definition at line 77 of file SaleProspectResults.java.

                                     {
    return byParticipant;
  }

getSaleProspectList()

java.util.List<SaleProspect> org.turro.crm.search.SaleProspectResults.getSaleProspectList

(

)

Definition at line 28 of file SaleProspectResults.java.

                                                            {
    Dao dao = new CrmPU();
    return dao.getResultList(createCriteria());
  }

Here is the call graph for this function:

getSaleProspectValue()

String org.turro.crm.search.SaleProspectResults.getSaleProspectValue

(

)

Definition at line 93 of file SaleProspectResults.java.

                                       {
    return saleProspectValue;
  }

isCkOthers()

boolean org.turro.crm.search.SaleProspectResults.isCkOthers

(

)

Definition at line 85 of file SaleProspectResults.java.

                              {
    return ckOthers;
  }

setByParticipant()

void org.turro.crm.search.SaleProspectResults.setByParticipant

(

IContact

byParticipant

)

Definition at line 81 of file SaleProspectResults.java.

                                                       {
    this.byParticipant = byParticipant;
  }

setCkOthers()

void org.turro.crm.search.SaleProspectResults.setCkOthers

(

boolean

ckOthers

)

Definition at line 89 of file SaleProspectResults.java.

                                            {
    this.ckOthers = ckOthers;
  }

setSaleProspectValue()

void org.turro.crm.search.SaleProspectResults.setSaleProspectValue

(

String

saleProspectValue

)

Definition at line 97 of file SaleProspectResults.java.

                                                             {
    this.saleProspectValue = saleProspectValue;
  }

---

The documentation for this class was generated from the following file:

• SaleProspectResults.java