Public Member Functions
	InactiveProspects ()

java.util.List< SaleProspect >	getObjectValues (Vendor vendor)

WhereClause	createCriteria (Vendor vendor)

Detailed Description

Author: Lluis Turró Cutiller lluis.nosp@m.@tur.nosp@m.ro.or.nosp@m.g

Definition at line 33 of file InactiveProspects.java.

Constructor & Destructor Documentation

◆ InactiveProspects()

org.turro.crm.search.InactiveProspects.InactiveProspects ( )

Definition at line 35 of file InactiveProspects.java.

35 {

36 }

Member Function Documentation

◆ createCriteria()

WhereClause org.turro.crm.search.InactiveProspects.createCriteria ( Vendor vendor )

Definition at line 42 of file InactiveProspects.java.

                                                    {
     WhereClause wc = new WhereClause();
     wc.addClause("select distinct salep from SaleProspect as salep");
     if(!Application.getApplication().isInRole("sale-prospect:all")) {
       vendor = vendor == null ? VendorUtil.getCurrent() : vendor;
       if(vendor == null) {
         wc.addClause("where 1=2");
         return wc;
       }
     }
     if(vendor != null) {
       wc.addClause("left join salep.vendorProspects vendorp");
       wc.addClause("left join salep.customer.ownedBy vendoro");
       wc.addClause("where (vendorp.vendor = :vendorlimp");
       wc.addClause("or vendoro.vendor = :vendorlimo)");
       wc.addNamedValue("vendorlimp", vendor);
       wc.addNamedValue("vendorlimo", vendor);
     } else {
       wc.addClause("where 1=1");
     }
     wc.addClause("and salep.stage <> :close_won");
     wc.addNamedValue("close_won", ProspectStage.CLOSED_WON);
     wc.addClause("and salep.stage <> :close_lost");
     wc.addNamedValue("close_lost", ProspectStage.CLOSED_LOST);
     wc.addClause("and not exists (");
     wc.addClause("select sa from SaleAction sa");
     wc.addClause("where sa.vendorProspect.saleProspect = salep");
     wc.addClause("and sa.status = 0");
     wc.addClause(")");
     wc.addClause("order by salep.prospectDate");
     return wc;
   }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getObjectValues()

java.util.List<SaleProspect> org.turro.crm.search.InactiveProspects.getObjectValues ( Vendor vendor )

Definition at line 38 of file InactiveProspects.java.

                                                                      {
     return new CrmPU().getResultList(createCriteria(vendor));
   }