protected function buildCondition(&$conditions, &$values, $criteria_type, $field, $param, $join_id = null, $i18n = false, $extra = null)
{
$params_list = c2cTools::getCriteriaRequestParameters();
Document::buildConditionItem($conditions, $values, $criteria_type, $field, $param, $join_id, $i18n, $params_list, $extra);
}
/**
* Executes list action.
* Overrides documentsActions::executeList()
*/
public function executeList()
{
// params in order to add images of linked summits, parkings, etc...
$request_array = array();
if ($this->hasRequestParameter('rsummits') && ($summit_ids = $this->getRequestParameter('rsummits'))) {
if (!in_array($summit_ids, array('-', ' '))) {
$request_array = array(explode('-', $summit_ids), 'sr', 'ri', 'si');
}
} elseif ($this->hasRequestParameter('rparkings') && ($parking_ids = $this->getRequestParameter('rparkings'))) {
if (!in_array($parking_ids, array('-', ' '))) {
$request_array = array(explode('-', $parking_ids), 'pr', 'ri', 'pi');
}
} elseif ($this->hasRequestParameter('rhuts') && ($hut_ids = $this->getRequestParameter('rhuts'))) {
if (!in_array($hut_ids, array('-', ' '))) {
$request_array = array(explode('-', $hut_ids), 'hr', 'ri', 'hi');
}
} elseif ($this->hasRequestParameter('oroutes') && ($route_ids = $this->getRequestParameter('oroutes'))) {
if (!in_array($route_ids, array('-', ' '))) {
$request_array = array(explode('-', $route_ids), 'ro', 'oi', 'ri');
}
} elseif ($this->hasRequestParameter('osites') && ($site_ids = $this->getRequestParameter('osites'))) {
if (!in_array($site_ids, array('-', ' '))) {
$request_array = array(explode('-', $site_ids), 'to', 'oi', 'ti');
}
}
if (!empty($request_array)) {
$ids = array_shift($request_array);
$pager = new c2cDoctrinePager('Image', c2cTools::mobileVersion() ? sfConfig::get('app_list_mobile_maxline_number') : sfConfig::get('app_list_maxline_number'));
$this->pager = $pager;
$q = $pager->getQuery();
$q->select('DISTINCT i.id, i.image_type, i.geom_wkt, i.filename, ii.name, ii.culture, ii.search_name')->from('Image i')->leftJoin('i.associations a ON i.id = a.linked_id')->leftJoin('i.ImageI18n ii')->where('(a.main_id IN (SELECT a2.linked_id FROM Association a2 WHERE a2.main_id IN (' . implode(',', $ids) . ') AND a2.type = ?) AND a.type = ?)' . ' OR (a.main_id IN (' . implode(',', $ids) . ') AND a.type = ?)', $request_array);
$pager->setPage($this->getRequestParameter('page', 1));
$pager->init();
$nb_results = $pager->getNbResults();
$this->nb_results = $nb_results;
// deal with format
if (isset($this->format)) {
$format = $this->format;
} else {
$format = $this->getRequestParameter('format', 'list');
$format = explode('-', $format);
$this->format = $format;
}
if ($nb_results == 0 && !in_array('json', $format)) {
$params_list = array_keys(c2cTools::getCriteriaRequestParameters());
if (count($params_list) == 1) {
$param = reset($params_list);
if (strpos($param, 'nam') !== false) {
$this->query_string = $this->getRequestParameter($param);
$this->setTemplate('../../documents/templates/simplenoresult');
}
}
} else {
$this->items = $pager->getResults('array');
}
$this->setPageTitle($this->__($this->getModuleName() . ' list'));
$this->setTemplate('list');
} else {
parent::executeList();
$nb_results = $this->nb_results;
if ($nb_results == 0) {
return;
}
$items = $this->query->execute(array(), Doctrine::FETCH_ARRAY);
$this->items = Language::parseListItems($items, 'Image');
$this->setTemplate('list');
}
if (in_array('json', $this->format)) {
$this->setJsonResponse();
$this->setTemplate('../../documents/templates/jsonlist');
}
}
function region_header_list_tag($label = null, $default_order = '', $simple = false)
{
$params_list = array_keys(c2cTools::getCriteriaRequestParameters());
$is_default_list = empty($params_list);
$orderby = sfContext::getInstance()->getRequest()->getParameter('orderby');
if (in_array($orderby, array('range', 'admin', 'country', 'valley'))) {
$orderby_area = $orderby;
} else {
$orderby_area = 'range';
}
return header_list_tag($orderby_area, $label, $default_order, $is_default_list || $simple);
}
<?php
use_helper('Field', 'Pagination');
$params_list = array_keys(c2cTools::getCriteriaRequestParameters());
$is_default_list = empty($params_list);
$request = sfContext::getInstance()->getRequest();
$orderby = $request->getParameter('orderby');
$add_rating_link = !empty($orderby) && in_array($orderby, sfConfig::get('mod_outings_sort_route_criteria'));
if (!$add_rating_link and !empty($activities)) {
$orderby = Route::getDefaultRatingOrderby($activities);
$add_rating_link = !empty($orderby);
}
echo select_all_header_list_tag();
echo header_list_tag('onam', 'name', '', $is_default_list);
echo header_list_tag('date', 'date short', 'desc');
echo header_list_tag('act', 'activities short', '', $is_default_list);
echo header_list_tag('alt', 'elevation short');
echo header_list_tag('hdif', 'height_diff_up short');
echo header_list_tag($orderby, 'ratings', '', !$add_rating_link);
echo header_list_tag('cond', 'cond short');
echo header_list_tag('freq', 'frequentation short');
echo region_header_list_tag('region_name');
echo images_header_list_tag();
echo comments_header_list_tag();
echo simple_header_list_tag('author short');