phpPeanuts  2.2.0
phpPeanuts framework
 All Data Structures Namespaces Files Functions Variables
Public Member Functions | Data Fields
PntSqlCombiFilter Class Reference

Inherits PntSqlFilter.

Inherited by PntSqlMultiOrFilter.

Public Member Functions

 __construct ()
 
 initPropertyDescriptors ()
 
 addPart ($value)
 
 __clone ()
 
 copy ()
 
 getItemType ()
 
 getParts ()
 
 appliesTo ($type, $persistent=false)
 
 setItemType ($value)
 
 setTableAlias ($value)
 
 setComparatorId ($value)
 
 setValue1 ($value)
 
 setValue2 ($value)
 
 andWhere ($path, $comparatorId=null, $value1=null, $value2=null)
 
 orWhere ($path, $comparatorId=null, $value1=null, $value2=null)
 
 combi ($path, $comparatorId=null, $value1=null, $value2=null)
 
 getSql ()
 
 addParamsTo ($qh)
 
 generateSql (&$aliasCount, &$paramCount, $backTrack=array())
 
 generateSqlForJoins (&$aliasCount, &$paramCount, $backTrack=array())
 
 getDescription ($conv)
 
 canBeSortSpec ()
 
 evaluate ($item)
 
 combine ($bool1, $bool2)
 
- Public Member Functions inherited from PntSqlFilter
 initPropertyDescriptors ()
 
 getId ()
 
 getPath ()
 
 getItemType ()
 
 getPropLabel ()
 
 appliesTo ($type, $persistent=false)
 
 getTableAlias ()
 
 getItemTableName ()
 
 getValueProp ()
 
 getValueType ()
 
 setComparatorId ($value)
 
 setValue1 ($value)
 
 setValue2 ($value)
 
 by ($comparatorId, $value1=null, $value2=null)
 
 andWhere ($path, $comparatorId=null, $value1=null, $value2=null)
 
 orWhere ($path, $comparatorId=null, $value1=null, $value2=null)
 
 sortBy ($path, $direction='ASC')
 
 getFieldMapPrefixed ()
 
 getSqlTemplate ()
 
 addParamsTo ($qh)
 
 getColumnName ()
 
 generateSql (&$aliasCount, &$paramCount, $backTrack=array())
 
 getSql ()
 
 getSqlForGroupBy ()
 
 getGroupBySql ()
 
 getGroupByField ()
 
 getSql_WhereToLimit ($groupBy=true)
 
 getExtraSelectExpressions ()
 
 getDescription ($conv)
 
 initConverter ($conv)
 
 getPersistArray ()
 
 initFromPersistArray ($array)
 
 getNavigation ()
 
 getLast ()
 
 canBeSortSpec ()
 
 ignoreGlobalFilter ($wheater)
 
 evaluate ($item)
 
 evaluateValue ($value)
 
 assocSelectFrom (&$array)
 
 selectFrom (&$array)
 
 compare ($a, $b)
 
 __clone ()
 
- Public Member Functions inherited from PntSqlSpec
 __construct ($id=null)
 
 getId ()
 
 getLabel ()
 
 getQueryHandler ()
 
 getDescription ($conv)
 
 setDescription ($value)
 
 getSqlForJoin ()
 
 generateSqlForJoins (&$aliasCount, &$paramCount, $backTrack=array())
 
 isJoinFilter ()
 
 where ($path, $comparatorId=null, $value1=null, $value2=null)
 
 sortBy ($path, $direction='ASC')
 
 retrieve ()
 
 retrieveFirst ()
 
 retrieveOne ()
 
- Public Member Functions inherited from PntObject
 __construct ()
 
 copy ()
 
 getClass ()
 
 getClassDescriptor ()
 
 initPropertyDescriptors ()
 
 getOid ()
 
 addFieldProp ($name, $type, $readOnly=false, $minValue=null, $maxValue=null, $minLength=0, $maxLength=null, $classDir=null, $persistent=true)
 
 addDerivedProp ($name, $type, $readOnly=true, $minValue=null, $maxValue=null, $minLength=0, $maxLength=null, $classDir=null)
 
 addMultiValueProp ($name, $type, $readOnly=true, $minValue=null, $maxValue=null, $minLength=0, $maxLength=null, $classDir=null)
 
 getPropertyDescriptor ($propertyName)
 
 get ($propertyName, $filter=true)
 
 set ($propertyName, $value)
 
 getOptions ($name, $filter=true)
 
 getValueValidator ($prop)
 
 validateGetErrorString ($prop, $value, $validateReadOnly=true)
 
 basicGetLabel ()
 
 getLabel ()
 
 __toString ()
 
 release ()
 
 getEditInfo ()
 
 toString ()
 
 _getValueValidator ($prop)
 

Data Fields

 $parts
 
 $combinator = 'AND'
 
- Data Fields inherited from PntSqlFilter
 $comparatorId = 0
 
 $valueType
 
 $tableAlias
 
 $itemTableName
 
 $key
 
 $value1
 
 $value2
 
 $columnName
 
 $sqlTemplate
 
 $navigation
 
 $visible = true
 
- Data Fields inherited from PntSqlSpec
 $label
 
 $propLabel
 
 $itemType
 

Additional Inherited Members

- Static Public Member Functions inherited from PntSqlFilter
static getInstance ($itemType, $path, $comparatorId=null, $value1=null, $value2=null)
 
static getInstanceForNav ($nav)
 
static instanceFromPersistArray ($array)
 

Constructor & Destructor Documentation

__construct ( )

Member Function Documentation

__clone ( )
addParamsTo (   $qh)

Add the parameter values from this to $qh

Parameters
PntDao$qh
addPart (   $value)
andWhere (   $path,
  $comparatorId = null,
  $value1 = null,
  $value2 = null 
)

(Navigational query DSL)

Returns
PntSqlCombiFilter for AND this with the specified
Parameters
string$paththe path to filter by
string$comparatorIdone id from PntComparator::getInstances
mixed$value1dynamically typed by >>valueType
mixed$value2dynamically typed by >>valueType
Exceptions
PntReflectionError
appliesTo (   $type,
  $persistent = false 
)

All parts must apply

Returns
boolean wheather the filter applies to the itemType
Parameters
string$typetype name
booleanwheather using ::getSql
canBeSortSpec ( )
combi (   $path,
  $comparatorId = null,
  $value1 = null,
  $value2 = null 
)

(Navigational query DSL)

Returns
PntSqlCombiFilter for extending this with the specified
Parameters
string$paththe path to filter by
string$comparatorIdone id from PntComparator::getInstances
mixed$value1dynamically typed by >>valueType
mixed$value2dynamically typed by >>valueType
Exceptions
PntReflectionError
combine (   $bool1,
  $bool2 
)
copy ( )

. Returns a recursive copy of $this

evaluate (   $item)
generateSql ( $aliasCount,
$paramCount,
  $backTrack = array() 
)
generateSqlForJoins ( $aliasCount,
$paramCount,
  $backTrack = array() 
)
getDescription (   $conv)
getItemType ( )

If $this->itemType not set, look for itemType on parts

getParts ( )
getSql ( )
initPropertyDescriptors ( )
Returns
String the name of the database table the instances are stored in - override for each subclass
orWhere (   $path,
  $comparatorId = null,
  $value1 = null,
  $value2 = null 
)

(Navigational query DSL)

Returns
PntSqlCombiFilter for OR this with the specified
Parameters
string$paththe path to filter by
string$comparatorIdone id from PntComparator::getInstances
mixed$value1dynamically typed by >>valueType
mixed$value2dynamically typed by >>valueType
Exceptions
PntReflectionError
setComparatorId (   $value)
setItemType (   $value)
setTableAlias (   $value)
setValue1 (   $value)
setValue2 (   $value)

Field Documentation

$combinator = 'AND'
$parts

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