org.turro.crm.search.SaleActionResults Class Reference

Public Member Functions
	SaleActionResults ()
java.util.List	getSaleActionList ()
WhereClause	createCriteria ()
IContact	getByParticipant ()
void	setByParticipant (IContact byParticipant)
boolean	isCkDone ()
void	setCkDone (boolean ckDone)
boolean	isCkOthers ()
void	setCkOthers (boolean ckOthers)
String	getSaleActionValue ()
void	setSaleActionValue (String saleActionValue)
SaleProspect	getSaleProspect ()
void	setSaleProspect (SaleProspect saleProspect)

Detailed Description

Author

llturro

Definition at line 17 of file SaleActionResults.java.

Constructor & Destructor Documentation

SaleActionResults()

org.turro.crm.search.SaleActionResults.SaleActionResults

(

)

Definition at line 26 of file SaleActionResults.java.

                             {
  }

Member Function Documentation

createCriteria()

WhereClause org.turro.crm.search.SaleActionResults.createCriteria

(

)

Definition at line 34 of file SaleActionResults.java.

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

Here is the call graph for this function:

Here is the caller graph for this function:

getByParticipant()

IContact org.turro.crm.search.SaleActionResults.getByParticipant

(

)

Definition at line 89 of file SaleActionResults.java.

                                     {
    return byParticipant;
  }

getSaleActionList()

java.util.List org.turro.crm.search.SaleActionResults.getSaleActionList

(

)

Definition at line 29 of file SaleActionResults.java.

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

Here is the call graph for this function:

getSaleActionValue()

String org.turro.crm.search.SaleActionResults.getSaleActionValue

(

)

Definition at line 113 of file SaleActionResults.java.

                                     {
    return saleActionValue;
  }

getSaleProspect()

SaleProspect org.turro.crm.search.SaleActionResults.getSaleProspect

(

)

Definition at line 121 of file SaleActionResults.java.

                                        {
    return saleProspect;
  }

isCkDone()

boolean org.turro.crm.search.SaleActionResults.isCkDone

(

)

Definition at line 97 of file SaleActionResults.java.

                            {
    return ckDone;
  }

isCkOthers()

boolean org.turro.crm.search.SaleActionResults.isCkOthers

(

)

Definition at line 105 of file SaleActionResults.java.

                              {
    return ckOthers;
  }

setByParticipant()

void org.turro.crm.search.SaleActionResults.setByParticipant

(

IContact

byParticipant

)

Definition at line 93 of file SaleActionResults.java.

                                                       {
    this.byParticipant = byParticipant;
  }

setCkDone()

void org.turro.crm.search.SaleActionResults.setCkDone

(

boolean

ckDone

)

Definition at line 101 of file SaleActionResults.java.

                                        {
    this.ckDone = ckDone;
  }

setCkOthers()

void org.turro.crm.search.SaleActionResults.setCkOthers

(

boolean

ckOthers

)

Definition at line 109 of file SaleActionResults.java.

                                            {
    this.ckOthers = ckOthers;
  }

setSaleActionValue()

void org.turro.crm.search.SaleActionResults.setSaleActionValue

(

String

saleActionValue

)

Definition at line 117 of file SaleActionResults.java.

                                                         {
    this.saleActionValue = saleActionValue;
  }

setSaleProspect()

void org.turro.crm.search.SaleActionResults.setSaleProspect

(

SaleProspect

saleProspect

)

Definition at line 125 of file SaleActionResults.java.

                                                         {
    this.saleProspect = saleProspect;
  }

---

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

• SaleActionResults.java