org.turro.crm.search.CustomerResults Class Reference

Public Member Functions
	CustomerResults ()
java.util.List	getCustomerList ()
WhereClause	createCriteria ()
IContact	getByParticipant ()
void	setByParticipant (IContact byParticipant)
boolean	isCkOthers ()
void	setCkOthers (boolean ckOthers)
String	getCustomerValue ()
void	setCustomerValue (String customerValue)

Detailed Description

Author

llturro

Definition at line 16 of file CustomerResults.java.

Constructor & Destructor Documentation

CustomerResults()

org.turro.crm.search.CustomerResults.CustomerResults

(

)

Definition at line 24 of file CustomerResults.java.

                           {
  }

Member Function Documentation

createCriteria()

WhereClause org.turro.crm.search.CustomerResults.createCriteria

(

)

Definition at line 32 of file CustomerResults.java.

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

Here is the call graph for this function:

Here is the caller graph for this function:

getByParticipant()

IContact org.turro.crm.search.CustomerResults.getByParticipant

(

)

Definition at line 75 of file CustomerResults.java.

                                     {
    return byParticipant;
  }

getCustomerList()

java.util.List org.turro.crm.search.CustomerResults.getCustomerList

(

)

Definition at line 27 of file CustomerResults.java.

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

Here is the call graph for this function:

getCustomerValue()

String org.turro.crm.search.CustomerResults.getCustomerValue

(

)

Definition at line 91 of file CustomerResults.java.

                                   {
    return customerValue;
  }

isCkOthers()

boolean org.turro.crm.search.CustomerResults.isCkOthers

(

)

Definition at line 83 of file CustomerResults.java.

                              {
    return ckOthers;
  }

setByParticipant()

void org.turro.crm.search.CustomerResults.setByParticipant

(

IContact

byParticipant

)

Definition at line 79 of file CustomerResults.java.

                                                       {
    this.byParticipant = byParticipant;
  }

setCkOthers()

void org.turro.crm.search.CustomerResults.setCkOthers

(

boolean

ckOthers

)

Definition at line 87 of file CustomerResults.java.

                                            {
    this.ckOthers = ckOthers;
  }

setCustomerValue()

void org.turro.crm.search.CustomerResults.setCustomerValue

(

String

customerValue

)

Definition at line 95 of file CustomerResults.java.

                                                     {
    this.customerValue = customerValue;
  }

---

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

• CustomerResults.java