PntComparator

PntSqlCombiFilter

PntSqlFilter

PntSqlJoinFilter

PntSqlMultiOrFilter

PntSqlSort

PntSqlSpec

__clone

addParamsTo

andWhere

appliesTo

assocSelectFrom

by

canBeSortSpec

compare

evaluate

evaluateValue

generateSql

getColumnName

getDescription

getExtraSelectExpressions

getFieldMapPrefixed

getGroupByField

getGroupBySql

getId

getInstance

getInstanceForNav

getItemTableName

getItemType

getLast

getNavigation

getPath

getPersistArray

getPropLabel

getSql

getSqlForGroupBy

getSqlTemplate

getSql_WhereToLimit

getTableAlias

getValueProp

getValueType

ignoreGlobalFilter

initConverter

initFromPersistArray

initPropertyDescriptors

instanceFromPersistArray

orWhere

selectFrom

setComparatorId

setValue1

setValue2

sortBy

<?php
/* Copyright (c) MetaClass, 2003-2017

Distributed and licensed under under the terms of the GNU Affero General Public License
version 3, or (at your option) any later version.

This program is distributed WITHOUT ANY WARRANTY; without even the implied warranty 
of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
	
See the License, http://www.gnu.org/licenses/agpl.txt */

Gen::includeClass('PntDbObject', 'pnt/db');
Gen::includeClass('PntSqlSpec', 'pnt/db/query');
Gen::includeClass('Comparator');
 
/** * PntSqlFilters specify (and produce) what comes after
* the WHERE clause to retrieve some objects
*
* Used by FilterFormPart in the advanced search.
* part for navigational query specification, part of PntSqlFilter
* @see http://www.phppeanuts.org/site/index_php/Pagina/170
* for navigation instances of a subclass also produce JOIN clauses to access related tables.
* Objects of this class produce an empty JOIN clause.
* Also used by other types of SqlFilter to produce
* more complicated WHERE expressions, JOIN and ORDER BY clauses
*
* Current version is MySQL specific. In future, all SQL generating methods should
* delegate to PntQueryHandler to support other databases
* @package pnt/db/query
*/
class PntSqlFilter extends PntSqlSpec {

	public $comparatorId = 0;
	public $valueType;
	public $tableAlias;
	public $itemTableName;
	public $key;
	public $value1; 
	public $value2;
	public $columnName;
	public $sqlTemplate;
	public $navigation;
	public $visible = true;