X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=classes%2Fplfilter.php;h=af8141d4e939f96857a1f32f0eb26b74955af1bb;hb=4d1c62e006bc896e9ddb59d15dc7a7e30f9eb48e;hp=6cdeb7014e3da8155a948ae4d87cc9960f9451b8;hpb=285fb262c9740106026de6d456d85c7b652046ec;p=platal.git diff --git a/classes/plfilter.php b/classes/plfilter.php index 6cdeb70..af8141d 100644 --- a/classes/plfilter.php +++ b/classes/plfilter.php @@ -19,83 +19,333 @@ * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA * ***************************************************************************/ -class PlSqlJoin +__autoload('xdb'); + +// {{{ class PlLimit +class PlLimit { - private $mode; - private $table; - private $condition; + private $count = null; + private $from = null; - const MODE_LEFT = 'LEFT'; - const MODE_RIGHT = 'RIGHT'; - const MODE_INNER = 'INNER'; + public function __construct($count = null, $from = null) + { + $this->count = $count; + $this->from = $from; + } - public function __construct($mode, $table, $condition) + public function getSql() { - if ($mode != self::MODE_LEFT && $mode != self::MODE_RIGHT && $mode != self::MODE_INNER) { - Platal::page()->kill("Join mode error : unknown mode $mode"); - return; + if (!is_null($this->count) && $this->count != 0) { + if (!is_null($this->from) && $this->from != 0) { + return XDB::format('LIMIT {?}, {?}', (int)$this->from, (int)$this->count); + } else { + return XDB::format('LIMIT {?}', (int)$this->count); + } } - $this->mode = $mode; - $this->table = $table; - $this->condition = $condition; + return ''; + } +} +// }}} + +// {{{ class PlFilterOrder +/** Base class for ordering results of a query. + * Parameters for the ordering must be given to the constructor ($desc for a + * descending order). + * The getSortTokens function is used to get actual ordering part of the query. + */ +abstract class PlFilterOrder +{ + protected $desc = false; + public function __construct($desc = false) + { + $this->desc = $desc; + $this->_tokens = null; + } + + public function toggleDesc() + { + $this->desc = !$this->desc; } - public function mode() + public function setDescending($desc = true) { - return $this->mode; + $this->desc = $desc; } - public function table() + public function buildSort(PlFilter &$pf) { - return $this->table; + $sel = $this->getSortTokens($pf); + $this->_tokens = $sel; + if (!is_array($sel)) { + $sel = array($sel); + } + if ($this->desc) { + foreach ($sel as $k => $s) { + $sel[$k] = $s . ' DESC'; + } + } + return $sel; } - public function condiftion() + /** This function must return the tokens to use for ordering + * @param &$pf The PlFilter whose results must be ordered + * @return The name of the field to use for ordering results + */ + abstract protected function getSortTokens(PlFilter &$pf); +} +// }}} + +// {{{ class PlFilterGroupableOrder +/** Extension of a PlFilterOrder, for orders where the value on which ordering + * is done could be used for grouping results (promo, country, ...) + */ +abstract class PlFilterGroupableOrder extends PlFilterOrder +{ + /** This function will be called when trying to retrieve groups; + * the returned token will be used to group the values. + * It will always be called AFTER getSortTokens(). + */ + public function getGroupToken(PlFilter &$pf) { - return $this->condition; + return $this->_tokens; } } +// }}} -abstract class PlFilter +// {{{ class PFO_Random +class PFO_Random extends PlFilterOrder { - public abstract function filter(array $objects, $count = null, $offset = null); + private $seed = null; - public abstract function setCondition(PlFilterCondition &$cond); + public function __construct($seed = null, $desc = false) + { + parent::__construct($desc); + $this->seed = $seed; + } - public abstract function addSort(PlFilterOrder &$sort); + protected function getSortTokens(PlFilter &$pf) + { + if ($this->seed == null) { + return 'RAND()'; + } else { + return XDB::format('RAND({?})', $this->seed); + } + } +} +// }}} + +// {{{ interface PlFilterCondition +interface PlFilterCondition +{ + const COND_TRUE = 'TRUE'; + const COND_FALSE = 'FALSE'; + + public function buildCondition(PlFilter &$pf); +} +// }}} + +// {{{ class PFC_OneChild +abstract class PFC_OneChild implements PlFilterCondition +{ + protected $child; + + public function __construct(&$child = null) + { + if (!is_null($child) && ($child instanceof PlFilterCondition)) { + $this->setChild($child); + } + } + + public function setChild(PlFilterCondition &$cond) + { + $this->child =& $cond; + } +} +// }}} + +// {{{ class PFC_NChildren +abstract class PFC_NChildren implements PlFilterCondition +{ + protected $children = array(); + + public function __construct() + { + $this->addChildren(pl_flatten(func_get_args())); + } + + public function addChildren(array $conds) + { + foreach ($conds as &$cond) { + if (!is_null($cond) && ($cond instanceof PlFilterCondition)) { + $this->addChild($cond); + } + } + } + + public function addChild(PlFilterCondition &$cond) + { + $this->children[] =& $cond; + } + + protected function catConds(array $cond, $op, $fallback) + { + if (count($cond) == 0) { + return $fallback; + } else if (count($cond) == 1) { + return $cond[0]; + } else { + return '(' . implode(') ' . $op . ' (', $cond) . ')'; + } + } +} +// }}} - private function replaceJoinMetas($cond, $key) +// {{{ class PFC_True +class PFC_True implements PlFilterCondition +{ + public function buildCondition(PlFilter &$uf) + { + return self::COND_TRUE; + } +} +// }}} + +// {{{ class PFC_False +class PFC_False implements PlFilterCondition +{ + public function buildCondition(PlFilter &$uf) { - return str_replace(array('$ME'), array($key), $cond); + return self::COND_FALSE; } +} +// }}} - private function formatJoin(array $joins) +// {{{ class PFC_Not +class PFC_Not extends PFC_OneChild +{ + public function buildCondition(PlFilter &$uf) { - $str = ''; - foreach ($joins as $key => $join) { - if (! $join instanceof PlSqlJoin) { - Platal::page()->kill("Error : not a join : $join"); + $val = $this->child->buildCondition($uf); + if ($val == self::COND_TRUE) { + return self::COND_FALSE; + } else if ($val == self::COND_FALSE) { + return self::COND_TRUE; + } else { + return 'NOT (' . $val . ')'; + } + } +} +// }}} + +// {{{ class PFC_And +class PFC_And extends PFC_NChildren +{ + public function buildCondition(PlFilter &$uf) + { + if (empty($this->children)) { + return self::COND_FALSE; + } else { + $true = self::COND_FALSE; + $conds = array(); + foreach ($this->children as &$child) { + $val = $child->buildCondition($uf); + if ($val == self::COND_TRUE) { + $true = self::COND_TRUE; + } else if ($val == self::COND_FALSE) { + return self::COND_FALSE; + } else { + $conds[] = $val; + } } - $mode = $join->mode(); - $table = $join->table(); - $str .= ' ' . $mode . ' JOIN ' . $table . ' AS ' . $key; - if ($join->condition() != null) { - $str .= ' ON (' . $this->replaceJoinMetas($join->condition(), $key) . ')'; + return $this->catConds($conds, 'AND', $true); + } + } +} +// }}} + +// {{{ class PFC_Or +class PFC_Or extends PFC_NChildren +{ + public function buildCondition(PlFilter &$uf) + { + if (empty($this->children)) { + return self::COND_TRUE; + } else { + $true = self::COND_TRUE; + $conds = array(); + foreach ($this->children as &$child) { + $val = $child->buildCondition($uf); + if ($val == self::COND_TRUE) { + return self::COND_TRUE; + } else if ($val == self::COND_FALSE) { + $true = self::COND_FALSE; + } else { + $conds[] = $val; + } } - $str .= "\n"; + return $this->catConds($conds, 'OR', $true); } - return $str; } +} +// }}} + +// {{{ class PlFilter +abstract class PlFilter +{ + /** Filters objects matching the PlFilter + * @param $objects The objects to filter + * @param $limit The portion of the matching objects to show + */ + public abstract function filter(array $objects, $limit = null); + + public abstract function setCondition(PlFilterCondition &$cond); + + public abstract function addSort(PlFilterOrder &$sort); + + public abstract function getTotalCount(); + + /** Whether this PlFilter can return grouped results through + * $this->getGroups(); + */ + public abstract function hasGroups(); + + /** Used to retrieve value/amount resulting from grouping by the first + * given order. + */ + public abstract function getGroups(); + + /** Get objects, selecting only those within a limit + * @param $limit The portion of the matching objects to select + */ + public abstract function get($limit = null); + + /** PRIVATE FUNCTIONS + */ + + /** List of metas to replace in joins: + * '$COIN' => 'pan.x' means 'replace $COIN with pan.x in the condition of the joins' + * + * "$ME" => "joined table alias" is always added to these. + */ + protected $joinMetas = array(); + + protected $joinMethods = array(); - private function buildJoins() + /** Build the 'join' part of the query + * This function will call all methods declared in self::$joinMethods + * to get an array of PlSqlJoin objects to merge + */ + protected function buildJoins() { $joins = array(); - foreach (self::$joinMethods as $method) { + foreach ($this->joinMethods as $method) { $joins = array_merge($joins, $this->$method()); } - return $this->formatJoin($joins); + return PlSqlJoin::formatJoins($joins, $this->joinMetas); } } +// }}} +// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: ?>