Differential D79 Diff 206 core/kernel/db/dblist.php

Changeset View

Standalone View

core/kernel/db/dblist.php

	Show First 20 Lines • Show All 255 Lines • ▼ Show 20 Line(s)
	* @return kDBList			* @return kDBList
	* @access public			* @access public
	*/			*/
	public function __construct()			public function __construct()
	{			{
	parent::__construct();			parent::__construct();
	$this->OrderFields = Array();			$this->OrderFields = Array();

				foreach ( $this->getFilterStructure() as $filter_params ) {
	$filters = $this->getFilterStructure();			$property_name = $filter_params['type'];
				$filter_group =& $this->$property_name;
	foreach ($filters as $filter_params) {
	$filter =& $this->$filter_params['type'];			$filter_group[$filter_params['class']] = $this->Application->makeClass(
	$filter[ $filter_params['class'] ] = $this->Application->makeClass('kMultipleFilter', Array ($filter_params['join_using']));			'kMultipleFilter',
				array($filter_params['join_using'])
				);
	}			}

	$this->PerPage = -1;			$this->PerPage = -1;
	}			}

	function setGridName($grid_name)			function setGridName($grid_name)
	{			{
	$this->gridName = $grid_name;			$this->gridName = $grid_name;
	Show All 34 Lines
	* @param string $name filter name (for internal use)			* @param string $name filter name (for internal use)
	* @param string $clause where/having clause part (no OR/AND allowed)			* @param string $clause where/having clause part (no OR/AND allowed)
	* @param int $filter_type is filter having filter or where filter			* @param int $filter_type is filter having filter or where filter
	* @param int $filter_scope filter subtype: FLT_NORMAL,FLT_SYSTEM,FLT_SEARCH,FLT_VIEW,FLT_CUSTOM			* @param int $filter_scope filter subtype: FLT_NORMAL,FLT_SYSTEM,FLT_SEARCH,FLT_VIEW,FLT_CUSTOM
	* @access public			* @access public
	*/			*/
	public function addFilter($name, $clause, $filter_type = self::WHERE_FILTER, $filter_scope = self::FLT_SYSTEM)			public function addFilter($name, $clause, $filter_type = self::WHERE_FILTER, $filter_scope = self::FLT_SYSTEM)
	{			{
	$filter_source = Array (			$this->getFilterCollection($filter_type, $filter_scope)->addFilter($name, $clause);
	self::WHERE_FILTER => 'WhereFilter',
	self::HAVING_FILTER => 'HavingFilter',
	self::AGGREGATE_FILTER => 'AggregateFilter'
	);

	$filter_name = $filter_source[$filter_type];

	$filter =& $this->$filter_name;
	$filter =& $filter[$filter_scope];
	/* @var $filter kMultipleFilter */

	$filter->addFilter($name, $clause);
	}			}

	/**			/**
	* Reads filter content			* Reads filter content
	*			*
	* @param string $name filter name (for internal use)			* @param string $name filter name (for internal use)
	* @param int $filter_type is filter having filter or where filter			* @param int $filter_type is filter having filter or where filter
	* @param int $filter_scope filter subtype: FLT_NORMAL,FLT_SYSTEM,FLT_SEARCH,FLT_VIEW,FLT_CUSTOM			* @param int $filter_scope filter subtype: FLT_NORMAL,FLT_SYSTEM,FLT_SEARCH,FLT_VIEW,FLT_CUSTOM
	* @return string			* @return string
	* @access public			* @access public
	*/			*/
	public function getFilter($name, $filter_type = self::WHERE_FILTER, $filter_scope = self::FLT_SYSTEM)			public function getFilter($name, $filter_type = self::WHERE_FILTER, $filter_scope = self::FLT_SYSTEM)
	{			{
	$filter_source = Array (			return $this->getFilterCollection($filter_type, $filter_scope)->getFilter($name);
	self::WHERE_FILTER => 'WhereFilter',
	self::HAVING_FILTER => 'HavingFilter',
	self::AGGREGATE_FILTER => 'AggregateFilter'
	);

	$filter_name = $filter_source[$filter_type];

	$filter =& $this->$filter_name;
	$filter =& $filter[$filter_scope];
	/* @var $filter kMultipleFilter */

	return $filter->getFilter($name);
	}			}

	/**			/**
	* Removes specified filter from filters list			* Removes specified filter from filters list
	*			*
	* @param string $name filter name (for internal use)			* @param string $name filter name (for internal use)
	* @param int $filter_type is filter having filter or where filter			* @param int $filter_type is filter having filter or where filter
	* @param int $filter_scope filter subtype: FLT_NORMAL,FLT_SYSTEM,FLT_SEARCH,FLT_VIEW,FLT_CUSTOM			* @param int $filter_scope filter subtype: FLT_NORMAL,FLT_SYSTEM,FLT_SEARCH,FLT_VIEW,FLT_CUSTOM
	* @access public			* @access public
	*/			*/
	public function removeFilter($name, $filter_type = self::WHERE_FILTER, $filter_scope = self::FLT_SYSTEM)			public function removeFilter($name, $filter_type = self::WHERE_FILTER, $filter_scope = self::FLT_SYSTEM)
	{			{
	$filter_source = Array (			$this->getFilterCollection($filter_type, $filter_scope)->removeFilter($name);
				}

				/**
				* Returns filter collection.
				*
				* @param integer $filter_type Is filter having filter or where filter.
				* @param integer $filter_scope Filter subtype: FLT_NORMAL,FLT_SYSTEM,FLT_SEARCH,FLT_VIEW,FLT_CUSTOM.
				*
				* @return kMultipleFilter
				*/
				protected function getFilterCollection($filter_type = self::WHERE_FILTER, $filter_scope = self::FLT_SYSTEM)
				{
				$filter_source = array(
	self::WHERE_FILTER => 'WhereFilter',			self::WHERE_FILTER => 'WhereFilter',
	self::HAVING_FILTER => 'HavingFilter',			self::HAVING_FILTER => 'HavingFilter',
	self::AGGREGATE_FILTER => 'AggregateFilter'			self::AGGREGATE_FILTER => 'AggregateFilter'
	);			);

	$filter_name = $filter_source[$filter_type];			/** @var kMultipleFilter[] $filters */
				$property_name = $filter_source[$filter_type];
	$filter =& $this->$filter_name;			$filters =& $this->$property_name;
	$filter =& $filter[$filter_scope];
	/* @var $filter kMultipleFilter */

	$filter->removeFilter($name);			return $filters[$filter_scope];
	}			}

	/**			/**
	* Clear all filters			* Clear all filters
	*			*
	* @access public			* @access public
	*/			*/
	public function clearFilters()			public function clearFilters()
	{			{
	$filters = $this->getFilterStructure();			foreach ( $this->getFilterStructure() as $filter_params ) {
				$property_name = $filter_params['type'];
				$filter_group =& $this->$property_name;

	foreach ($filters as $filter_params) {			$filter_group[$filter_params['class']]->clearFilters();
	$filter =& $this->$filter_params['type'];
	$filter[ $filter_params['class'] ]->clearFilters();
	}			}
	}			}

	/**			/**
	* Counts the total number of records base on the query resulted from {@link kDBList::GetSelectSQL()}			* Counts the total number of records base on the query resulted from {@link kDBList::GetSelectSQL()}
	*			*
	* The method modifies the query to substitude SELECT part (fields listing) with COUNT(*).			* The method modifies the query to substitude SELECT part (fields listing) with COUNT(*).
	* Special care should be applied when working with lists based on grouped queries, all aggregate function fields			* Special care should be applied when working with lists based on grouped queries, all aggregate function fields
	▲ Show 20 Lines • Show All 1373 Lines • Show Last 20 Lines