<?php
/***************************************************************************
- * Copyright (C) 2003-2008 Polytechnique.org *
+ * Copyright (C) 2003-2010 Polytechnique.org *
* http://opensource.polytechnique.org/ *
* *
* This program is free software; you can redistribute it and/or modify *
* 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *
***************************************************************************/
+
/** UserSet is a light-weight Model/View tool for displaying a set of items
*/
-class PlSet
+abstract class PlSet
{
- private $from = null;
- private $groupby = null;
- private $joins = null;
- private $where = null;
+ const DEFAULT_MAX_RES = 20;
+
+ protected $conds = null;
+ protected $orders = array();
+ protected $limit = null;
- private $count = null;
+ protected $count = null;
+ // A list of available views
private $mods = array();
+ // An array of $view_name => array($parameters)
private $modParams = array();
+ // The current view name
private $mod = null;
+ // The default view name
private $default = null;
- public function __construct($from, $joins = '', $where = '', $groupby = '')
+ public function __construct(PlFilterCondition &$cond, $orders = null)
{
- $this->from = $from;
- $this->joins = $joins;
- $this->where = $where;
- $this->groupby = $groupby;
+ if ($cond instanceof PFC_And) {
+ $this->conds = $cond;
+ } else {
+ $this->conds = new PFC_And($cond);
+ }
+
+ if (!is_null($orders) && $orders instanceof PlFilterOrder) {
+ $this->addSort($orders);
+ } else if (is_array($orders)){
+ foreach ($orders as $order) {
+ $this->addSort($order);
+ }
+ }
}
+ /** Adds a new view (minifiche, trombi, map)
+ * @param $name The name of the view (cf buildView)
+ * @param $description A user-friendly name for the view
+ * @param $default Whether this is the default view
+ * @param $params Parameters used to tune the view (display promo, order by
+ * score...)
+ */
public function addMod($name, $description, $default = false, array $params = array())
{
$name = strtolower($name);
unset($this->mods[$name]);
}
- private function &query($fields, $from, $joins, $where, $groupby, $order, $limit)
+ /** Adds a new sort (on the PlFilter)
+ */
+ public function addSort(PlFilterOrder &$order)
{
- if (trim($order)) {
- $order = "ORDER BY $order";
- }
- if (trim($where)) {
- $where = "WHERE $where";
+ $this->orders[] = $order;
+ }
+
+ /** Adds a new condition to the PlFilter
+ */
+ public function addCond(PlFilterCondition &$cond)
+ {
+ $this->conds->addChild($cond);
+ }
+
+ /** This function builds the right kind of PlFilter from given data
+ * @param $cond The PlFilterCondition for the filter
+ * @param $orders An array of PlFilterOrder for the filter
+ */
+ abstract protected function buildFilter(PlFilterCondition &$cond, $orders);
+
+ /** This function returns the results of the given filter
+ * wihtin $limit; can be use to replace the default $pf->get call.
+ * @param &$pf The filter
+ * @param $limit The PlLimit
+ * @return The results of the filter
+ */
+ protected function &getFilterResults(PlFilter &$pf, PlLimit $limit)
+ {
+ $res = $pf->get($limit);
+ return $res;
+ }
+
+ /** This function returns the values of the set, and sets $count with the
+ * total number of results.
+ * @param $limit A PlLimit for selecting users
+ * @param $orders An optional array of PFO to use before the "default" ones
+ * @return The result of $pf->get();
+ */
+ public function &get(PlLimit $limit = null, $orders = array())
+ {
+ if (!is_array($orders)) {
+ $orders = array($orders);
}
- if (trim($groupby)) {
- $groupby = "GROUP BY $groupby";
+
+ $orders = array_merge($orders, $this->orders);
+
+ $pf = $this->buildFilter($this->conds, $orders);
+
+ if (is_null($limit)) {
+ $limit = new PlLimit(self::DEFAULT_MAX_RES, 0);
}
- $query = "SELECT SQL_CALC_FOUND_ROWS
- $fields
- FROM $from
- $joins
- $where
- $groupby
- $order
- $limit";
-// echo $query;
-// print_r($this);
- $it = XDB::iterator($query);
- $count = XDB::query('SELECT FOUND_ROWS()');
- $this->count = intval($count->fetchOneCell());
+ $it = $this->getFilterResults($pf, $limit);
+ $this->count = $pf->getTotalCount();
return $it;
}
+ /** Return an array containing all pertinent parameters for this page
+ * Generated from $_GET, after some cleanup (remove 'n' (plat/al field
+ * for the handler path)
+ */
public function args()
{
$get = $_GET;
return $get;
}
+ /** Convert an array into an URL query (?foo=bar)
+ * @param $args An associative array to convert to a query string
+ * @param $encode Whether to url-encode the string
+ */
protected function encodeArgs(array $args, $encode = false)
{
$qs = '?';
return $encode ? urlencode($qs) : $qs;
}
- public function &get($fields, $joins, $where, $groupby, $order, $limitcount = null, $limitfrom = null)
- {
- if (!is_null($limitcount)) {
- if (!is_null($limitfrom)) {
- $limitcount = "$limitfrom,$limitcount";
- }
- $limitcount = "LIMIT $limitcount";
- }
- $joins = $this->joins . ' ' . $joins;
- if (trim($this->where)) {
- if (trim($where)) {
- $where .= ' AND ';
- }
- $where .= $this->where;
- }
- if (!$groupby) {
- $groupby = $this->groupby;
- }
- return $this->query($fields, $this->from, $joins, $where, $groupby, $order, $limitcount);
- }
-
public function count()
{
return $this->count;
}
- private function &buildView($view, $data)
+ /** Builds the view class from the given parameters
+ * @param $view A string ('profile' for 'ProfileView'); if null,
+ * the default view is used.
+ * @return A new PlView instance.
+ */
+ private function &buildView($view)
{
$view = strtolower($view);
if (!$view || !class_exists($view . 'View') || !isset($this->mods[$view])) {
if (!class_exists($class)) {
$view = null;
} else {
- $view = new $class($this, $data, $this->modParams[$this->mod]);
+ $view = new $class($this, $this->modParams[$this->mod]);
if (!$view instanceof PlView) {
$view = null;
}
return $view;
}
- public function apply($baseurl, PlatalPage &$page, $view = null, $data = null)
+ /** Creates the view: sets the page template, assigns Smarty vars.
+ * @param $baseurl The base URL for this (for instance, "search/")
+ * @param $page The page in which the view should be loaded
+ * @param $view The name of the view; if null, the default one will be used.
+ */
+ public function apply($baseurl, PlPage &$page, $view = null)
{
- $view =& $this->buildView($view, $data);
+ $view =& $this->buildView($view);
if (is_null($view)) {
return false;
}
$args = $view->args();
- if (!isset($args['rechercher'])) {
- $args['rechercher'] = 'Chercher';
- }
- $page->changeTpl('core/plset.tpl');
+ $page->coreTpl('plset.tpl');
$page->assign('plset_base', $baseurl);
$page->assign('plset_mods', $this->mods);
$page->assign('plset_mod', $this->mod);
- $page->assign('plset_search', $this->encodeArgs($args));
- $page->assign('plset_search_enc', $this->encodeArgs($args, true));
+ $page->assign('plset_args', $this->encodeArgs($args));
+ $page->assign('plset_args_enc', $this->encodeArgs($args, true));
foreach ($this->modParams[$this->mod] as $param=>$value) {
$page->assign($this->mod . '_' . $param, $value);
}
interface PlView
{
- public function __construct(PlSet &$set, $data, array $params);
- public function apply(PlatalPage &$page);
+ /** Constructs a new PlView
+ * @param $set The set
+ * @param $params Parameters to tune the view (sort by score, include promo...)
+ */
+ public function __construct(PlSet &$set, array $params);
+
+ /** Applies the view to a page
+ * The content of the set is fetched here.
+ * @param $page Page to which the view will be applied
+ * @return The name of the global view template (for displaying the view,
+ * not the items of the set)
+ */
+ public function apply(PlPage &$page);
+
+ /** As PlSet->args(), returns the ?foo=bar part of the URL for generating
+ * this PlSet, after adding the necessary components and removing useless ones.
+ */
public function args();
}
+/** This class describes an Order as used in a PlView :
+ * - It is based on a PlFilterOrder
+ * - It has a short identifier
+ * - It has a full name, to display on the page
+ */
+class PlViewOrder
+{
+ public $pfos = null;
+ public $name = null;
+ public $displaytext = null;
+
+ /** Build a PlViewOrder
+ * @param $name Name of the order (key)
+ * @param $displaytext Text to display
+ * @param $pfos Array of PlFilterOrder for the order
+ */
+ public function __construct($name, $pfos, $displaytext = null)
+ {
+ $this->name = $name;
+ if (is_null($displaytext)) {
+ $this->displaytext = ucfirst($name);
+ } else {
+ $this->displaytext = $displaytext;
+ }
+ $this->pfos = $pfos;
+ }
+}
+
abstract class MultipageView implements PlView
{
protected $set;
protected $sortkeys = array();
protected $defaultkey = null;
- public function __construct(PlSet &$set, $data, array $params)
+ protected $bound_field = null;
+
+ /** Builds a MultipageView
+ * @param $set The associated PlSet
+ * @param $params Parameters of the view
+ */
+ public function __construct(PlSet &$set, array $params)
{
$this->set =& $set;
$this->page = Env::i('page', 1);
$this->params = $params;
}
- public function joins()
- {
- return null;
- }
-
- public function where()
- {
- return null;
- }
-
- public function groupBy()
- {
- return null;
- }
-
- protected function addSortKey($name, array $keys, $desc, $default = false)
+ /** Add an order to the view
+ */
+ protected function addSort(PlViewOrder &$pvo, $default = false)
{
- $this->sortkeys[$name] = array('keys' => $keys, 'desc' => $desc);
+ $this->sortkeys[$pvo->name] = $pvo;
if (!$this->defaultkey || $default) {
- $this->defaultkey = $name;
+ $this->defaultkey = $pvo->name;
}
}
+ /** Returns a list of PFO objects in accordance with the user's choice
+ */
public function order()
{
$order = Env::v('order', $this->defaultkey);
if ($invert) {
$order = substr($order, 1);
}
- $list = array();
- foreach ($this->sortkeys[$order]['keys'] as $item) {
- $desc = ($item{0} == '-');
- if ($desc) {
- $item = substr($item, 1);
- }
- if ($desc xor $invert) {
- $item .= ' DESC';
+
+ $ordering = $this->sortkeys[$order];
+ if ($invert) {
+ foreach ($ordering->pfos as $pfo) {
+ $pfo->toggleDesc();
}
- $list[] = $item;
}
- return implode(', ', $list);
+ return $ordering->pfos;
+ }
+
+ /** Returns information on the order of bounds
+ * @return * 1 if normal bounds
+ * * -1 if inversed bounds
+ * * 0 if bounds shouldn't be displayed
+ */
+ public function bounds()
+ {
+ return null;
+ }
+
+ public function limit()
+ {
+ return new PlLimit($this->entriesPerPage, $this->offset);
}
+ /** Name of the template to use for displaying items of the view
+ * e.g plview.minifiche.tpl, plview.trombi.pl, ...
+ */
abstract public function templateName();
- public function apply(PlatalPage &$page)
+ /** Returns the value of a boundary of the current view (in order
+ * to show "from C to F")
+ * @param $obj The boundary result whose value must be shown to the user
+ * (e.g a Profile, ...)
+ * @return The bound
+ */
+ abstract protected function getBoundValue($obj);
+
+ public function apply(PlPage &$page)
{
+ foreach ($this->order() as $order) {
+ if (!is_null($order)) {
+ $this->set->addSort($order);
+ }
+ }
+ $res = $this->set->get($this->limit());
+
+ $show_bounds = $this->bounds();
+ if ($show_bounds) {
+ $start = current($res);
+ $end = end($res);
+ if ($show_bounds == 1) {
+ $first = $this->getBoundValue($start);
+ $last = $this->getBoundValue($end);
+ } elseif ($show_bounds == -1) {
+ $first = $this->getBoundValue($end);
+ $last = $this->getBoundValue($start);
+ }
+ $page->assign('first', $first);
+ $page->assign('last', $last);
+ }
+
+ $page->assign('show_bounds', $show_bounds);
$page->assign('order', Env::v('order', $this->defaultkey));
$page->assign('orders', $this->sortkeys);
$page->assign_by_ref('plview', $this);
- $page->assign_by_ref('set',
- $this->set->get($this->fields(),
- $this->joins(),
- $this->where(),
- $this->groupBy(),
- $this->order(),
- $this->entriesPerPage,
- $this->offset));
+ if (is_array($res)) {
+ $page->assign('set_keys', array_keys($res));
+ }
+ $page->assign_by_ref('set', $res);
$count = $this->set->count();
$this->pages = intval(ceil($count / $this->entriesPerPage));
- return 'include/plview.multipage.tpl';
+ return PlPage::getCoreTpl('plview.multipage.tpl');
}
+ /** Arguments are those needed by the set, minus 'page' and 'order' which
+ * will be set to new values in the html links.
+ */
public function args()
{
$list = $this->set->args();