PHP-Code:
<?php if (!defined('TL_ROOT')) die('You can not access this file directly!');
/**
* TYPOlight webCMS
*
* The TYPOlight webCMS is an accessible web content management system that
* specializes in accessibility and generates W3C-compliant HTML code. It
* provides a wide range of functionality to develop professional websites
* including a built-in search engine, form generator, file and user manager,
* CSS engine, multi-language support and many more. For more information and
* additional TYPOlight applications like the TYPOlight MVC Framework please
* visit the project website https://contao.org.
*
* The Catalog extension allows the creation of multiple catalogs of custom items,
* each with its own unique set of selectable field types, with field extendability.
* The Front-End modules allow you to build powerful listing and filtering of the
* data in each catalog.
*
* PHP version 5
* @copyright Martin Komara, Thyon Design, CyberSpectrum 2007-2009
* @author Martin Komara,
* John Brand <john.brand@thyon.com>,
* Christian Schiffler <c.schiffler@cyberspectrum.de>
* @package Catalog
* @license LGPL
* @filesource
*/
/**
* Class ModuleCatalog
*
* @copyright Martin Komara, Thyon Design, CyberSpectrum 2007-2009
* @author Martin Komara,
* John Brand <john.brand@thyon.com>,
* Christian Schiffler <c.schiffler@cyberspectrum.de>
* @package Controller
*
*/
abstract class ModuleCatalog extends Module
{
/**
* Tablename String
* @var string
*/
protected $strTable;
/**
* Name of the alias field
* @var string
*/
protected $strAliasField;
/**
* Search String
* @var string
*/
protected $strSearch = 'search';
/**
* Sort String
* @var string
*/
protected $strSort = 'sort';
/**
* OrderBy String
* @var string
*/
protected $strOrderBy = 'orderby';
protected $systemColumns = array('id', 'pid', 'sorting', 'tstamp');
protected $arrTree;
protected $cacheJumpTo;
public function generate()
{
if (!strlen($this->catalog))
{
return '';
}
// get DCA
$objCatalog = $this->Database->prepare('SELECT * FROM tl_catalog_types WHERE id=?')
->limit(1)
->execute($this->catalog);
if ($objCatalog->numRows > 0 && $objCatalog->tableName)
{
$this->strTable = $objCatalog->tableName;
$this->strAliasField=$objCatalog->aliasField;
$this->publishField=$objCatalog->publishField;
// dynamically load dca for catalog operations
$this->Import('Catalog');
if(!$GLOBALS['TL_DCA'][$objCatalog->tableName]['Cataloggenerated'])
{
// load language files and DC.
$this->loadLanguageFile($objCatalog->tableName);
$this->loadDataContainer($objCatalog->tableName);
// load default language
$GLOBALS['TL_LANG'][$objType->tableName] = is_array($GLOBALS['TL_LANG'][$objType->tableName])
? Catalog::array_replace_recursive($GLOBALS['TL_LANG']['tl_catalog_items'], $GLOBALS['TL_LANG'][$objType->tableName])
: $GLOBALS['TL_LANG']['tl_catalog_items'];
// load dca
$GLOBALS['TL_DCA'][$objCatalog->tableName] =
is_array($GLOBALS['TL_DCA'][$objCatalog->tableName])
? Catalog::array_replace_recursive($this->Catalog->getCatalogDca($this->catalog), $GLOBALS['TL_DCA'][$objCatalog->tableName])
: $this->Catalog->getCatalogDca($this->catalog);
$GLOBALS['TL_DCA'][$objCatalog->tableName]['Cataloggenerated'] = true;
}
}
// Send file to the browser
$blnDownload = ($this instanceof ModuleCatalogList || $this instanceof ModuleCatalogFeatured || $this instanceof ModuleCatalogRelated || $this instanceof ModuleCatalogReference || $this instanceof ModuleCatalogReader);
if ($blnDownload && strlen($this->Input->get('file')) && $this->catalog_visible)
{
foreach ($this->catalog_visible as $k)
{
$fieldConf = &$GLOBALS['TL_DCA'][$this->strTable]['fields'][$k];
if ($fieldConf['eval']['catalog']['type'] == 'file' && !$fieldConf['eval']['catalog']['showImage'])
{
// check file in Catalog
$objDownload = $this->Database->prepare('SELECT id FROM '.$this->strTable.' WHERE '.(!BE_USER_LOGGED_IN && $this->publishField ? $this->publishField.'=1 AND ' : '').'(LOCATE(?,'.$k.')>0 OR LOCATE(?,'.$k.')>0)')
->limit(1)
->execute($this->Input->get('file'), dirname($this->Input->get('file')));
if ($objDownload->numRows)
{
$this->sendFileToBrowser($this->Input->get('file'));
}
}
}
}
return parent::generate();
}
protected function getModulesForThisPage()
{
if($this->cachePageModules)
return $this->cachePageModules;
global $objPage;
if($objPage->layout)
$objLayout = $this->Database->prepare('SELECT id,modules FROM tl_layout WHERE id=?')
->limit(1)
->execute($objPage->layout);
// Fallback layout
if (!$objPage->layout || $objLayout->numRows == 0)
{
$objLayout = $this->Database->prepare('SELECT id, modules FROM tl_layout WHERE fallback=?')
->limit(1)
->execute(1);
}
// check if there is a layout and fetch modules if so.
if ($objLayout->numRows)
{
$arrModules = deserialize($objLayout->modules);
} else {
$arrModules = array();
}
// fetch all content element modules from this page.
$objContent = $this->Database->prepare('SELECT module FROM tl_content WHERE pid IN (SELECT id FROM tl_article WHERE pid=?) AND type="module"')
->execute($objPage->id);
while($objContent->next())
{
$arrModules[] = array('mod' => $objContent->module);
}
$ids=array();
foreach ($arrModules as $arrModule)
{
$ids[] = $arrModule['mod'];
}
$this->cachePageModules=$ids;
return $this->cachePageModules;
}
protected function getCatalogFields($arrTypes=false)
{
if(!$arrTypes)
$arrTypes=$GLOBALS['BE_MOD']['content']['catalog']['typesCatalogFields'];
$fields = array();
$objFields = $this->Database->prepare("SELECT * FROM tl_catalog_fields WHERE pid=? ORDER BY sorting")
->execute($this->catalog);
while ($objFields->next())
{
if(!in_array($objFields->type, $arrTypes))
continue;
$fields[$objFields->colName] = array
(
'label' => $objFields->name,
'type' => $objFields->type,
);
}
return $fields;
}
protected function getTree()
{
if ($this->type != 'catalogfilter' || !$this->catalog_filter_enable)
{
return array();
}
$tree = array();
if($this->catalog_filters) {
$arrFilters = deserialize($this->catalog_filters, true);
foreach ($arrFilters as $key=>$fieldconfig)
{
list($field, $config) = each($fieldconfig);
if ($config['checkbox'] == 'tree')
{
$tree[] = $field;
}
}
}
return $tree;
}
protected function parseFilterUrl($searchFields=NULL)
{
$arrTree = $this->getTree();
$blnTree = (count($arrTree)>0);
$current = $this->convertAliasInput();
$searchFields = deserialize($searchFields);
// Setup Fields
$fields = $this->getCatalogFields();
if (!strlen($this->catalog_tags_mode))
{
$this->catalog_tags_mode = 'AND';
}
// Process POST redirect() settings
$doPost = false;
if ($this->Input->post('FORM_SUBMIT') == $this->strTable)
{
// search string POST
if (array_key_exists($this->strSearch, $_POST))
{
$doPost = true;
if ($this->Input->post($this->strSearch))
{
$current[$this->strSearch] = $this->Input->post($this->strSearch);
}
else
{
unset($current[$this->strSearch]);
}
}
// filters POST
foreach ($fields as $field=>$data)
{
// check if this is a filter
if (array_key_exists($field, $_POST))
{
$doPost = true;
$fieldConf = &$GLOBALS['TL_DCA'][$this->strTable]['fields'][$field];
// check if array posted (range and dates)
if (is_array($this->Input->post($field)))
{
$range = $this->Input->post($field);
$min = strlen($fieldConf['eval']['catalog']['minValue']) ?
max(min($range), $fieldConf['eval']['catalog']['minValue']) : min($range);
$max = strlen($fieldConf['eval']['catalog']['maxValue']) ?
min(max($range), $fieldConf['eval']['catalog']['maxValue']) : max($range);
if (strlen($max) && strlen($min))
{
$current[$field] = $min.'__'.$max;
}
if (in_array($fieldConf['eval']['catalog']['type'],array('number', 'decimal', 'date')))
{
$min='';
$max='';
if($fieldConf['eval']['catalog']['type'] == 'date')
{
if($range[0] && !is_numeric($range[0]))
$range[0] = strtotime($range[0]);
if($range[1] && !is_numeric($range[1]))
$range[1] = strtotime($range[1]);
}
if (strlen($range[0]))
$min=$range[0];
if (strlen($range[1]))
$max=$range[1];
if (strlen($max) || strlen($min))
{
$current[$field] = $min.'__'.$max;
}
}
}
// regular filter value
else
{
// use TL safe function
$v = $this->Input->post($field);
$fieldConf = &$GLOBALS['TL_DCA'][$this->strTable]['fields'][$field];
if (strlen($v) && $this->getAliasFieldConf($fieldConf) != 'id')
{
$arrAlias = array_flip($this->getAliasOptionList($fieldConf));
switch ($fieldConf['eval']['catalog']['type'])
{
case 'tags':
$tags = explode(',', $v);
$newtags = array();
foreach($tags as $tag)
{
$newtags[] = $arrAlias[$tag];
}
$v = implode(',', $newtags);
break;
case 'select':
$v = $arrAlias[$v];
break;
default:;
}
}
$current[$field] = $v;
}
}
}
// Redirect POST variables to GET, for [search] and [ranges]
if ($doPost)
{
$this->redirect($this->generateFilterUrl($current, false, false));
}
}
// return if no filter parameters in URL
if (!is_array($current) && !count($current))
{
return array();
}
// Setup Variables
$baseurl = $this->generateFilterUrl();
$procedure = array();
$values = array();
$procedure['search'] = null;
$values['search'] = null;
foreach ($fields as $field=>$data)
{
$fieldConf = &$GLOBALS['TL_DCA'][$this->strTable]['fields'][$field];
// GET search value
if ($this->Input->get($this->strSearch) && strlen($fieldConf['eval']['catalog']['type']))
{
if (is_array($searchFields) && !in_array($field, $searchFields))
{
continue;
}
switch ($fieldConf['eval']['catalog']['type'])
{
case 'text':
case 'longtext':
// explode the search by spaces and add the result to the query.
// this allows us to search for multiple words which do not have to be in the same order as searched by.
// Drawback is, we now can not search for exact phrases anymore (which is less required than searching for
// multiple words IMO).
// TODO: make this configable so users can decide which search algorithm to use.
$words=explode(' ', $this->Input->get($this->strSearch));
$proc=array();
$vals=array();
if(count($words))
{
$values['search'][$field]=array();
foreach($words as $word)
{
$proc[] = '('.$field.' LIKE ?)';
$values['search'][$field][] = '%'.$word.'%';
}
$procedure['search'][$field] = '('.implode(' AND ', $proc).')';
}
break;
case 'number':
case 'decimal':
$procedure['search'][$field] = '('.$field.' LIKE ?)';
$values['search'][$field] = '%'.$this->Input->get($this->strSearch).'%';
break;
case 'file':
case 'url':
$procedure['search'][$field] = '('.$field.' LIKE ?)';
// $values['search'][$field] = '%'.urldecode($this->Input->get($this->strSearch)).'%';
$values['search'][$field] = '%'.($this->Input->get($this->strSearch)).'%';
break;
case 'date':
// add month only search
if (!is_numeric($this->Input->get($this->strSearch)))
{
$procedure['search'][$field] = "CAST(MONTHNAME(FROM_UNIXTIME(".$field.")) AS CHAR) LIKE ?";
$values['search'][$field] = '%'.$this->Input->get($this->strSearch).'%';
}
// add numeric day, month, year search
else
{
foreach (array('YEAR','MONTH','DAY') as $function)
{
$tmpDate[] = "CAST(".$function."(FROM_UNIXTIME(".$field.")) AS CHAR) LIKE ?";
$values['search'][$field][] = '%'.$this->Input->get($this->strSearch).'%';
}
$procedure['search'][$field] = '('.implode(' OR ',$tmpDate).')';
}
break;
case 'checkbox' :
// search only if true
if (substr_count(strtolower($fieldConf['label']['0']),strtolower($this->Input->get($this->strSearch))))
{
$procedure['search'][$field] = '('.$field.'=?)';
$values['search'][$field] = '1';
}
break;
case 'select' :
list($itemTable, $valueCol) = explode('.', $fieldConf['eval']['catalog']['foreignKey']);
$procedure['search'][$field] = '('.$field.' IN (SELECT id FROM '.$itemTable.' WHERE '.$valueCol.' LIKE ?'.($fieldConf['options']? ' AND id IN ('.implode(',',array_keys($fieldConf['options'])).')':'').'))';
$values['search'][$field] = '%'.$this->Input->get($this->strSearch).'%';
break;
case 'tags' :
list($itemTable, $valueCol) = explode('.', $fieldConf['eval']['catalog']['foreignKey']);
// perform search by using a subselect over the tables.
$tagQuery = $this->Database->prepare(sprintf('SELECT DISTINCT(itemid) as id FROM tl_catalog_tag_rel WHERE fieldid=%s AND valueid IN (SELECT id FROM %s WHERE %s LIKE ? %s)',
$fieldConf['eval']['catalog']['fieldId'],
$itemTable,
$valueCol,
($fieldConf['options']? ' AND id IN ('.implode(',',array_keys($fieldConf['options'])).')':'')
))
->execute('%'.$this->Input->get($this->strSearch).'%');
if ($tagQuery->numRows)
{
$procedure['search'][$field] = 'id IN('.implode(',', $tagQuery->fetchEach('id')).')';
}
break;
default:;
// HOOK: Might be a custom field type, check if that one has registered a hook.
$fieldType=$GLOBALS['BE_MOD']['content']['catalog']['fieldTypes'][$fieldConf['eval']['catalog']['type']];
if(array_key_exists('generateFilter', $fieldType) && is_array($fieldType['generateFilter']))
{
foreach ($fieldType['generateFilter'] as $callback)
{
$this->import($callback[0]);
$tmp=$this->$callback[0]->$callback[1]($field, $fieldConf, $this->Input->get($this->strSearch));
$procedure['search'][$field] = $tmp['procedure'];
if(is_array($tmp['search']))
{
if(isset($values['search'][$field]))
$values['search'][$field]=array_merge($values['search'][$field], $tmp['search']);
else
$values['search'][$field]=$tmp['search'];
}
else
$values['search'][$field]=$tmp['search'];
}
}
}
} // of search
// GET range values
if (substr_count($this->Input->get($field),'__'))
{
$rangeValues = trimsplit('__', $this->Input->get($field), 2);
$rangeOptions[$field]['label'] = $fieldConf['label'][0];
$rangeOptions[$field]['min'] = $rangeValues[0];
$rangeOptions[$field]['max'] = $rangeValues[1];
$minValue = $rangeValues[0];
$maxValue = $rangeValues[1];
//$procedure['where'][] = '('.$field.' BETWEEN ? AND ?)';
$strSqlWhereClause = '('.$field.' BETWEEN ? AND ?)';
switch ($fieldConf['eval']['catalog']['type'])
{
case 'number':
$rangeValues[0] = intval($rangeValues[0]);
$rangeValues[1] = intval($rangeValues[1]);
break;
case 'decimal':
$rangeValues[0] = floatval($rangeValues[0]);
$rangeValues[1] = floatval($rangeValues[1]);
break;
case 'date':
$rangeValues[0] = strtotime($rangeValues[0]);
$rangeValues[1] = strtotime($rangeValues[1]);
break;
default:
}
if ($minValue!='')
$values['where'][] = $rangeValues[0];
else
$strSqlWhereClause = '('.$field.' < ?)';
if ($maxValue!='')
$values['where'][] = $rangeValues[1];
else
$strSqlWhereClause = '('.$field.' > ?)';
$procedure['where'][] = $strSqlWhereClause;
$current[$field] = $this->Input->get($field);
}
//GET filter values
elseif (strlen($this->Input->get($field)))
{
switch ($fieldConf['eval']['catalog']['type'])
{
case 'tags':
list($itemTable, $valueCol) = explode('.', $fieldConf['eval']['catalog']['foreignKey']);
// TODO: add support for string values here and get rid of the convertAliasInput call on the beginning.
foreach(explode(',', $current[$field]) as $tag)
$tags[] = (int)$tag;
if($this->catalog_tags_mode == 'AND')
{
$sql = sprintf('SELECT itemid FROM tl_catalog_tag_rel WHERE fieldid=%s AND valueid=%s',
$fieldConf['eval']['catalog']['fieldId'],
$tag);
foreach($tags as $tag)
$sql = sprintf('SELECT itemid FROM tl_catalog_tag_rel WHERE fieldid=%s AND valueid=%s AND itemid IN(%s)',
$fieldConf['eval']['catalog']['fieldId'],
$tag,
$sql);
$sql = sprintf('id IN (SELECT DISTINCT(itemid) FROM tl_catalog_tag_rel WHERE fieldid=%s AND itemid IN (%s) AND valueid IN (%s))',
$fieldConf['eval']['catalog']['fieldId'],
$sql,
implode(',', array_intersect($tags, ($fieldConf['options']?array_keys($fieldConf['options']):array())))
);
$tagQuery = $sql;
} else {
// perform search by using a subselect over the tables.
$tagQuery = 'id IN(SELECT DISTINCT(itemid) as id FROM tl_catalog_tag_rel WHERE fieldid='.$fieldConf['eval']['catalog']['fieldId'].' AND valueid IN ('.implode(',', array_intersect($tags, ($fieldConf['options']?array_keys($fieldConf['options']):array()))).'))';
}
$procedure['tags'][] = $tagQuery;
if ($blnTree && in_array($field, $arrTree))
{
$procedure['tree'][] = $tagQuery;
}
break;
case 'checkbox':
$procedure['where'][] = $field."=?";
$values['where'][] = ($this->Input->get($field) == 'true' ? 1 : 0);
//$current[$field] = $this->Input->get($field);
if ($blnTree && in_array($field, $arrTree))
{
$procedure['tree'][$field] = $field."=?";
$values['tree'][$field] = ($this->Input->get($field) == 'true' ? 1 : 0);
}
break;
case 'text':
case 'longtext':
case 'number':
case 'decimal':
case 'select':
$value = $current[$field];
if($value!==NULL)
{
$procedure['where'][] = $field."=?";
$values['where'][] = $value;
if ($blnTree && in_array($field, $arrTree))
{
$procedure['tree'][$field] = $field."=?";
$values['tree'][$field] = $value;
}
}
break;
case 'date':
$procedure['where'][] = $field."=?";
$values['where'][] = strtotime($this->Input->get($field));
//$current[$field] = $this->Input->get($field);
if ($blnTree && in_array($field, $arrTree))
{
$procedure['tree'][$field] = $field."=?";
$values['tree'][$field] = strtotime($this->Input->get($field));
}
break;
case 'file':
case 'url':
$procedure['where'][] = $field."=?";
$values['where'][] = urldecode($this->Input->get($field));
$current[$field] = $this->Input->get($field);
if ($blnTree && in_array($field, $arrTree))
{
$procedure['tree'][$field] = $field."=?";
$values['tree'][$field] = urldecode($this->Input->get($field));
}
break;
}
} // filter
// GET sort values
if ($this->Input->get($this->strOrderBy) == $field && in_array($this->Input->get($this->strSort), array('asc','desc')))
{
switch ($fieldConf['eval']['catalog']['type'])
{
case 'select':
list($itemTable, $valueCol) = explode('.', $fieldConf['eval']['catalog']['foreignKey']);
$procedure['orderby'] = '(SELECT '.$valueCol.' from '.$itemTable.' WHERE id='.$field.') '.$this->Input->get($this->strSort);
break;
default:
$procedure['orderby'] = $field.' '.$this->Input->get($this->strSort);
}
$current[$this->strOrderBy] = $this->Input->get($this->strOrderBy);
$current[$this->strSort] = $this->Input->get($this->strSort);
} //sort
} // foreach $filter
$settings = array
(
'current' => $current,
'procedure' => $procedure,
'values' => $values,
);
// HOOK: allow other extensions to manipulate the filter settings before passing it to the template
if(is_array($GLOBALS['TL_HOOKS']['filterCatalog']))
{
foreach ($GLOBALS['TL_HOOKS']['filterCatalog'] as $callback)
{
$this->import($callback[0]);
$settings = $this->$callback[0]->$callback[1]($settings);
}
}
return $settings;
}
/**
* Retrieve Alias field from table, checks if catalog
* @param string
* @return string
*/
public function getAliasField($sourceTable)
{
// check alias field
$objAlias = $this->Database->prepare("SELECT aliasField FROM tl_catalog_types WHERE tableName=?")
->execute($sourceTable);
$aliasField = ($objAlias->numRows && strlen($objAlias->aliasField)) ? $objAlias->aliasField : 'alias';
return ($this->Database->fieldExists($aliasField, $sourceTable) && !$GLOBALS['TL_CONFIG']['disableAlias']) ? $aliasField : 'id';
}
/**
* Retrieve alias field for current catalog field configuration
* @param array
* @return string
*/
private function getAliasFieldConf($fieldConf)
{
if (!$fieldConf['eval']['catalog']['foreignKey'])
{
return 'id';
}
// get alias column
list($itemTable, $valueCol) = explode('.', $fieldConf['eval']['catalog']['foreignKey']);
return $this->getAliasField($itemTable);
}
/**
* Retrieve alias values with id as index
* @param array
* @return array
*/
private function getAliasOptionList(&$fieldConf)
{
if($fieldConf['optionslist'])
return $fieldConf['optionslist'];
// get alias column
list($itemTable, $valueCol) = explode('.', $fieldConf['eval']['catalog']['foreignKey']);
$aliasField = $this->getAliasField($itemTable);
// determine item sorting.
$strSorting=($fieldConf['eval']['catalog']['sortCol']
?' ORDER BY '.$fieldConf['eval']['catalog']['sortCol']
:($this->Database->fieldExists('sorting', $itemTable)?' ORDER BY sorting':''));
// get existing alias values of options in DB
$objList = $this->Database->prepare('SELECT id,'.$aliasField.' FROM '.$itemTable .
($fieldConf['options'] ? ' WHERE id IN ('.implode(',',array_keys($fieldConf['options'])).')':'') . $strSorting)
->execute();
$return = array();
while ($objList->next())
{
// check if this is still ok to use id if alias is empty
$return[$objList->id] = strlen($objList->$aliasField) ? $objList->$aliasField : $objList->id;
}
$fieldConf['optionslist'] = $return;
return $return;
}
/**
* Detect input $_GET variables and convert alias values to id's, if table supports it
* @return array
*/
protected function convertAliasInput()
{
$return = array();
// convert $_GET filter parameters in Url
foreach ($_GET as $k=>$v)
{
// exclude page parameter
if (!in_array($k, array('page')))
{
$_GET[$k] = str_replace($GLOBALS['TL_CONFIG']['catalog']['safeReplace'], $GLOBALS['TL_CONFIG']['catalog']['safeCheck'], $v);
// use TL safe function
$v = $this->Input->get($k);
$fieldConf = &$GLOBALS['TL_DCA'][$this->strTable]['fields'][$k];
if (strlen($v) && $this->getAliasFieldConf($fieldConf) != 'id')
{
$arrAlias = array_flip($this->getAliasOptionList($fieldConf));
switch ($fieldConf['eval']['catalog']['type'])
{
case 'tags':
$tags = explode(',', $v);
$newtags = array();
foreach($tags as $tag)
{
$newtags[] = $arrAlias[$tag];
}
$v = implode(',', $newtags);
break;
case 'select':
$v = $arrAlias[$v];
break;
default:;
}
}
$return[$k] = $v;
}
}
return $return;
}
protected function lastInTree($field, $current, $tree)
{
return (!count($tree) || in_array($field, $tree) && array_search($field, $tree)==(count($tree)-1));
}
protected function hideTree($field, $current, $tree)
{
if ($this->catalog_filter_hide && in_array($field, $tree))
{
$pos = array_search($field, $tree);
for ($i=0,$total=0;$i<=$pos;$i++)
{
$total += array_key_exists($tree[$i], $current);
}
return ($total<$pos);
}
return false;
}
protected function buildTreeQuery($field, $filterurl, $tree)
{
if (count($tree) && is_array($filterurl['procedure']['tree']))
{
$pos = array_search($field, $tree);
for ($i=0;$i<$pos;$i++)
{
if (strlen($filterurl['procedure']['tree'][$tree[$i]]))
$query[] = $filterurl['procedure']['tree'][$tree[$i]];
if (strlen($filterurl['values']['tree'][$tree[$i]]))
$params[] = $filterurl['values']['tree'][$tree[$i]];
}
}
return array (
'query' => (is_array($query) ? implode(' AND ', $query) : ''),
'params' => (is_array($params) ? $params : array()),
);
}
protected function clearTree($field, &$newcurrent, $tree)
{
if (in_array($field, $tree))
{
$pos = (array_search($field, $tree)+1);
for ($i=$pos;$i<=count($tree);$i++)
{
unset($newcurrent[$tree[$i]]);
}
}
}
protected function makeAllLabel($input, $label, $multi=false)
{
if ($input=='select' && !$multi)
{
return sprintf($GLOBALS['TL_LANG']['MSC']['selectNone'], $label);
}
return sprintf($GLOBALS['TL_LANG']['MSC']['clearAll'], $label);
}
protected function generateFilter()
{
$filterurl = $this->parseFilterUrl();
$current = $filterurl['current'];
$arrFilters = deserialize($this->catalog_filters, true);
if ($this->catalog_filter_enable && count($arrFilters))
{
// Get Tree View
$tree = $this->getTree();
// Setup filters and option values
$filterOptions = array();
foreach ($arrFilters as $fieldconfig)
{
list($field, $config) = each($fieldconfig);
$input = $config['radio'];
$blnTree = ($config['checkbox'] == 'tree');
if ($input == 'none' || $this->hideTree($field, $current, $tree))
{
continue;
}
$blnLast = $this->lastInTree($field, $current, $tree);
$query = $this->buildTreeQuery($field, $filterurl, $tree);
if(!BE_USER_LOGGED_IN && $this->publishField)
{
if(strlen($query['query']))
{
$query['query'].=' AND '.$this->publishField.'=1 ';
} else {
$query['query']=$this->publishField.'=1 ';
}
}
$fieldConf = &$GLOBALS['TL_DCA'][$this->strTable]['fields'][$field];
$fieldType = $fieldConf['eval']['catalog']['type'];
// HOOK: let custom fields mimic another fieldtype to generate a filter
if(array_key_exists($fieldType, $GLOBALS['BE_MOD']['content']['catalog']['fieldTypes']))
{
$fieldTypeArr=$GLOBALS['BE_MOD']['content']['catalog']['fieldTypes'][$fieldType];
if(array_key_exists('generateFilterWidget', $fieldTypeArr) && is_array($fieldTypeArr['generateFilterWidget']))
{
foreach ($fieldTypeArr['generateFilterWidget'] as $callback)
{
$this->import($callback[0]);
$tmp=$this->$callback[0]->$callback[1]($fieldType, $field, $config, $fieldConf, $filterurl, $query, $tree);
if($tmp)
{
$fieldType = $tmp;
}
}
}
}
$options = array();
switch ($fieldType)
{
case 'checkbox':
// Build Widget Options
$labels = array
(
'none' => $this->makeAllLabel($input, $fieldConf['label'][0]),
'true' => $GLOBALS['TL_LANG']['MSC']['true'],
'false' => $GLOBALS['TL_LANG']['MSC']['false'],
);
foreach ($labels as $key=>$label)
{
$newcurrent = $current;
$newcurrent[$field] = ($key == 'none' ? '' : $key);
$selected = $current[$field] == $newcurrent[$field];
$this->clearTree($field, $newcurrent, $tree);
$url = $this->generateFilterUrl($newcurrent, true, $blnLast);
$addOption = array();
$addOption['value'] = $url;
$addOption['label'] = $label;
$addOption['id'] = ($key == 'none' ? '' : $key);
if ($selected)
{
$addOption['selected'] = true;
}
array_push($options, $addOption);
}
$widget = array
(
'name' => $field,
'id' => 'filter_field_'.$field,
'label' => $fieldConf['label'][0],
'options' => serialize($options),
'value' => htmlentities($this->generateFilterUrl($current, true, $blnLast)),
'tableless' => true,
'inputType' => $input,
);
// parse Widget
$settings['filter'][] = $this->parseWidget($widget, false);
$widgets['filter'][] = $widget;
break;
case 'select':
if(($this instanceof ModuleCatalogFilter) && $this->catalog_filter_cond_from_lister)
{
$ids=$this->getModulesForThisPage();
$objModules = $this->Database->prepare('SELECT * FROM tl_module WHERE id IN (' . implode(', ', $ids) . ') AND deny_catalog_filter_cond_from_lister=0 AND type=\'cataloglist\' AND catalog='.$this->catalog)
->execute();
while($objModules->next())
{
$objModules->catalog_search=deserialize($objModules->catalog_search);
$moduleFilterUrl = $this->parseFilterUrl($objModules->catalog_search);
if (is_array($objModules->catalog_search) && strlen($objModules->catalog_search[0]) && is_array($moduleFilterUrl['procedure']['search']))
{
// reset arrays
$searchProcedure = array();
$searchValues = array();
foreach($objModules->catalog_search as $searchfield)
{
if (($searchfield != $field)
&& array_key_exists($searchfield, $moduleFilterUrl['current'])
&& array_key_exists($searchfield, $moduleFilterUrl['procedure']['search']))
{
$searchProcedure[] = $moduleFilterUrl['procedure']['search'][$searchfield];
if (is_array($moduleFilterUrl['values']['search'][$searchfield]))
{
foreach($moduleFilterUrl['values']['search'][$searchfield] as $item)
{
$searchValues[] = $item;
}
}
else
{
$searchValues[] = $moduleFilterUrl['values']['search'][$searchfield];
}
}
}
if(count($searchProcedure))
{
$moduleFilterUrl['procedure']['where'][] = ' ('.implode(' OR ', $searchProcedure).')';
$moduleFilterUrl['values']['where'] = is_array($moduleFilterUrl['values']['where']) ? (array_merge($moduleFilterUrl['values']['where'],$searchValues)) : $searchValues;
}
}
if(is_array($moduleFilterUrl['procedure']['where']))
{
foreach($moduleFilterUrl['procedure']['where'] as $key=>$value)
{
if(strpos($value, $field) !== false)
{
unset($moduleFilterUrl['procedure']['where'][$key]);
unset($moduleFilterUrl['values']['where'][$key]);
}
}
}
if(is_array($moduleFilterUrl['procedure']['tags']))
{
foreach($moduleFilterUrl['procedure']['tags'] as $key=>$value)
{
if(strpos($value, $field) !== false)
{
unset($moduleFilterUrl['procedure']['tags'][$key]);
unset($moduleFilterUrl['values']['tags'][$key]);
}
}
}
if (is_array($moduleFilterUrl['values']['where'])) {
$query['params'] = array_merge($query['params'], $moduleFilterUrl['values']['where']);
}
if (is_array($moduleFilterUrl['values']['tags'])) {
$query['params'] = array_merge($query['params'], $moduleFilterUrl['values']['tags']);
}
if($objModules->catalog_where)
{
$strCondition = $this->replaceInsertTags($objModules->catalog_where);
if(strlen($strCondition))
$query['query'] .= (strlen($query['query'])?' AND ':'').$strCondition;
}
if(count($moduleFilterUrl['procedure']['where']))
$query['query'] .=(strlen($query['query'])?' AND ':'').implode(' '.$objModules->catalog_query_mode.' ', $moduleFilterUrl['procedure']['where']);
if(count($moduleFilterUrl['procedure']['tags']))
$query['query'] .=(strlen($query['query'])?' AND ':'').implode(' '.$objModules->catalog_tags_mode.' ', $moduleFilterUrl['procedure']['tags']);
}
}
// get existing options in DB
$objFilter = $this->Database->prepare('SELECT DISTINCT('.$field.') FROM '.$this->strTable . ($query['query'] ? ' WHERE '.$query['query'] : '') )
->execute($query['params']);
if ($objFilter->numRows)
{
$selected = !strlen($current[$field]);
$newcurrent = $current;
unset($newcurrent[$field]);
$this->clearTree($field, $newcurrent, $tree);
$url = $this->generateFilterUrl($newcurrent, true, $blnLast);
$addOption = array();
$addOption['value'] = $url;
$addOption['label'] = $this->makeAllLabel($input, $fieldConf['label'][0]);
$addOption['id'] = '';
if ($selected)
{
$addOption['selected'] = true;
}
array_push($options, $addOption);
// get all rows
$rows = $objFilter->fetchEach($field);
if($fieldConf['options'])
{
$tmpTags = array();
foreach ($fieldConf['options'] as $id=>$option)
{
$tmpTags[] = 'SUM(FIND_IN_SET('.$id.','.$field.')) AS '.$field.$id;
}
$objResultCount = $this->Database->prepare('SELECT '.implode(', ',$tmpTags).' FROM '.$this->strTable. ($query['query'] ? ' WHERE '. $query['query'] : ''))
->execute($query['params']);
$arrResultCount = $objResultCount->row();
foreach ($fieldConf['options'] as $id=>$option)
{
if (in_array($id, $rows))
{
$selected = ($current[$field] == $id);
$newcurrent = $current;
$newcurrent[$field] = $id;
$this->clearTree($field, $newcurrent, $tree);
$url = $this->generateFilterUrl($newcurrent, true, $blnLast);
$addOption = array();
$addOption['value'] = $url;
$addOption['label'] = $option;
$addOption['id'] = $id;
$addOption['alias'] = $id;
$addOption['resultcount'] = $arrResultCount[$field.$id];
if ($selected)
{
$addOption['selected'] = true;
}
array_push($options, $addOption);
}
}
}
$widget = array
(
'name' => $field,
'id' => 'filter_field_'.$field,
'label' => $fieldConf['label'][0],
'value' => $this->generateFilterUrl($current, true, $blnLast),
'options' => serialize($options),
'tableless' => true,
'inputType' => $input,
);
// parse Widget
$settings['filter'][] = $this->parseWidget($widget, false);
$widgets['filter'][] = $widget;
}
break;
case 'tags' :
$query['query'] = '';
$query['params'] = is_array($filterurl['values']['where'])? $filterurl['values']['where'] : array();
if (is_array($filterurl['values']['tags']))
$query['params'] = array_merge($query['params'], $filterurl['values']['tags']);
if(count($filterurl['procedure']['where']))
$query['query'] .=(strlen($query['query'])?' AND ':'').implode(' AND ', $filterurl['procedure']['where']);
// TODO: we have a problem here if more than one tag field exists - we simply ignore the other one in here.
// if(count($filterurl['procedure']['tags']))
// $query['query'] .=(strlen($query['query'])?' AND ':'').implode(' AND ', $filterurl['procedure']['tags']);
// clear option
$selected = !strlen($current[$field]);
$newcurrent = $current;
unset($newcurrent[$field]);
$this->clearTree($field, $newcurrent, $tree);
$url = $this->generateFilterUrl($newcurrent, true, $blnLast);
$addOption = array();
$addOption['value'] = $url;
$addOption['label'] = $this->makeAllLabel($input, $fieldConf['label'][0], $this->catalog_tags_multi);
$addOption['id'] = $id;
if ($selected)
{
$addOption['selected'] = true;
}
array_push($options, $addOption);
$tmpTags = array();
// get ids of matches according to all other filters.
if($query['query'])
{
$objFilter = $this->Database->prepare('SELECT id FROM '.$this->strTable.' WHERE '.$query['query'])
->execute($query['params']);
$itemIds = implode(',',$objFilter->fetchEach('id'));
}
foreach ($fieldConf['options'] as $id=>$option)
{
$tmpTags[] = '(SELECT COUNT(itemid) FROM tl_catalog_tag_rel WHERE valueid='.$id.' AND fieldid='.$fieldConf['eval']['catalog']['fieldId'].($query['query'] && $itemIds?' AND itemid IN('.$itemIds.')':'').') AS '.$field.$id;
}
if(count($tmpTags)==0)
$tmpTags = array($field);
$objFilter = $this->Database->prepare('SELECT '.implode(', ',$tmpTags))
->execute($query['params']);
if ($objFilter->numRows)
{
$row = $objFilter->row();
foreach ($fieldConf['options'] as $id=>$option)
{
if ($row[$field.$id])
{
$selected = in_array($id, explode(',',$current[$field]));
$newcurrent = $current;
$newids = strlen($current[$field]) ? explode(',', $current[$field]) : array();
$newids = array_unique(!$selected ? array_merge($newids, array($id)) : array_diff($newids, array($id)));
$newcurrent[$field] = ($this->catalog_tags_multi ? implode(',',$newids) : $id);
$this->clearTree($field, $newcurrent, $tree);
$url = $this->generateFilterUrl($newcurrent, true, $blnLast);
$blnList = ($selected && $input=='list');
$addOption = array();
$addOption['value'] = $url;
$addOption['label'] = $blnList ? sprintf($GLOBALS['TL_LANG']['MSC']['optionselected'], $option) : $option;
$addOption['id'] = $id;
$addOption['resultcount'] = $row[$field.$id];
$addOption['selected'] = $selected;
array_push($options, $addOption);
}
}
}
$widget = array
(
'name' => $field,
'id' => 'filter_field_'.$field,
'label' => $fieldConf['label'][0],
'value' => $this->generateFilterUrl($current, true, $blnLast),
'options' => serialize($options),
'tableless' => true,
'inputType' => ($this->catalog_tags_multi && $input=='radio' ? 'checkbox' : $input),
);
if ($this->catalog_tags_multi && $input=='select')
{
$widget = array_merge($widget, array('multiple'=>true));
}
$settings['filter'][] = $this->parseWidget($widget, false);
$widgets['filter'][] = $widget;
break;
case 'text':
case 'file':
case 'url':
case 'number':
case 'decimal':
case 'date':
$query['query'] = '';
// TODO: this is an evil hack - we DEFINATELY have to rewrite this lookup mechanism.
if(count($filterurl['procedure']['where']))
foreach($filterurl['procedure']['where'] as $k=>$v)
{
if(strpos($v, $field) !== false)
{
unset($filterurl['procedure']['where'][$k]);
unset($filterurl['values']['where'][$k]);
}
}
$query['params'] = is_array($filterurl['values']['where'])? $filterurl['values']['where'] : array();
if (is_array($filterurl['values']['tags']))
$query['params'] = array_merge($query['params'], $filterurl['values']['tags']);
if(count($filterurl['procedure']['where']))
$query['query'] .=(strlen($query['query'])?' AND ':'').implode(' AND ', $filterurl['procedure']['where']);
if(count($filterurl['procedure']['tags']))
$query['query'] .=(strlen($query['query'])?' AND ':'').implode(' AND ', $filterurl['procedure']['tags']);
// get existing options in DB
$options = array();
$objFilter = $this->Database->prepare("SELECT DISTINCT ".$field." FROM ".$this->strTable . ($query['query'] ? " WHERE ".$query['query'] : '') . " ORDER BY ".$field)
->execute($query['params']);
if ($objFilter->numRows)
{
// setup ALL option
$selected = !strlen($current[$field]);
$newcurrent = $current;
unset($newcurrent[$field]);
$this->clearTree($field, $newcurrent, $tree);
$url = $this->generateFilterUrl($newcurrent, true, $blnLast);
$addOption = array();
$addOption['value'] = $url;
$addOption['label'] = $this->makeAllLabel($input, $fieldConf['label'][0]);
$addOption['id'] = '';
if ($selected)
{
$addOption['selected'] = true;
}
array_push($options, $addOption);
while ($objFilter->next())
{
$row = $objFilter->row();
if (!strlen(trim($row[$field])))
{
continue;
}
$label = $this->formatValue(0, $field, $row[$field], false);
switch ($fieldConf['eval']['catalog']['type'])
{
case 'url':
$label = $row[$field];
$row[$field] = urlencode(urlencode($row[$field]));
break;
case 'file':
$label = implode(',',deserialize($row[$field],true));
$row[$field] = urlencode(urlencode($row[$field]));
break;
case 'date':
$row[$field] = $label;
break;
default:;
}
$newcurrent = $current;
$newcurrent[$field] = htmlspecialchars($row[$field]);
$selected = $current[$field] == $newcurrent[$field];
$this->clearTree($field, $newcurrent, $tree);
$url = $this->generateFilterUrl($newcurrent, true, $blnLast);
$addOption = array();
$addOption['value'] = $url;
$addOption['label'] = $label;
$addOption['id'] = $row[$field];
if ($selected)
{
$addOption['selected'] = true;
}
array_push($options, $addOption);
}
$widget = array
(
'name' => $field,
'id' => 'filter_field_'.$field,
'label' => $fieldConf['label'][0],
'options' => serialize($options),
'value' => htmlentities($this->generateFilterUrl($current, true, $blnLast)),
'tableless' => true,
'inputType' => $input,
);
// parse Widget
$settings['filter'][] = $this->parseWidget($widget, false);
$widgets['filter'][] = $widget;
}
break;
case 'longtext':
$options[] = array
(
'label' => &$GLOBALS['TL_LANG']['MSC']['invalidFilter'],
'value' => '',
);
$widget = array
(
'name' => $field,
'id' => 'filter_field_'.$field,
'label' => $fieldConf['label'][0],
'options' => serialize($options),
'value' => '',
'tableless' => true,
'inputType' => 'list',
);
// parse Widget
$settings['filter'][] = $this->parseWidget($widget, true);
$widgets['filter'][] = $widget;
break;
default:
// HOOK: let custom fields generate a filter widget
if($fieldType && array_key_exists($fieldType, $GLOBALS['BE_MOD']['content']['catalog']['fieldTypes']))
{
$fieldType=$GLOBALS['BE_MOD']['content']['catalog']['fieldTypes'][$fieldType];
if(array_key_exists('generateFilterForField', $fieldType) && is_array($fieldType['generateFilterForField']))
{
$callback = $fieldType['generateFilterForField'];
$tmp=$this->$callback[0]->$callback[1]($fieldType, $field, $config, $fieldConf, $filterurl, $query, $tree);
if($tmp)
{
$settings['filter'][] = $tmp['settings'];
$widgets['filter'][] = $tmp['widget'];
}
}
}
}
}
}
$arrRange = deserialize($this->catalog_range,true);
if ($this->catalog_range_enable && count($arrRange) && strlen($arrRange[0]))
{
// GET range values
$rangeOptions = array();
foreach ($arrRange as $field)
{
$fieldConf = &$GLOBALS['TL_DCA'][$this->strTable]['fields'][$field];
switch ($fieldConf['eval']['catalog']['type'])
{
case 'text':
case 'longtext':
case 'number':
case 'decimal':
case 'date':
$rangeValues = substr_count($this->Input->get($field),'__') ? trimsplit('__', $this->Input->get($field)) : array('','');
$current[$field] = $this->Input->get($field);
$widget = array
(
'name' => $field,
'id' => 'filter_range_'.$field,
'label' => ($i==0 ? $fieldConf['label'][0]:''),
'inputType' => 'range',
'value' => serialize($rangeValues),
'multiple' => true,
'size' => 2,
'tableless' => true,
'addSubmit' => true,
'slabel' => $GLOBALS['TL_LANG']['MSC']['catalogSearch'],
);
if ($fieldConf['eval']['catalog']['type'] == 'date')
{
$date = array
(
'maxlength' => 10,
'rgxp' => 'date'
);
// date picker was changed in 2.10
if (version_compare(VERSION, '2.10', '>='))
$date['datepicker'] = true;
else
$date['datepicker'] = $this->getDatePickerString();
$widget = array_merge($widget, $date);
}
$settings['range'][] = $this->parseWidget($widget, true);
$widgets['range'][] = $widget;
break;
default :;
}
}
}
// Setup date values
$arrDates = deserialize($this->catalog_dates,true);
$arrRanges = deserialize($this->catalog_date_ranges,true);
if ($this->catalog_date_enable && count($arrDates))
{
foreach ($arrDates as $fieldconfig)
{
list($field, $config) = each($fieldconfig);
$input = $config['radio'];
$fieldConf = &$GLOBALS['TL_DCA'][$this->strTable]['fields'][$field];
$options = array();
$selected = !strlen($current[$field]);
$newcurrent = $current;
unset($newcurrent[$field]);
$url = $this->generateFilterUrl($newcurrent, true);
$addOption = array();
$addOption['value'] = $url;
$addOption['label'] = $this->makeAllLabel($input, $fieldConf['label'][0]);
$addOption['id'] = '';
if ($selected)
{
$addOption['selected'] = true;
}
array_push($options, $addOption);
foreach ($arrRanges as $id=>$range)
{
$now = new Date();
$strToday = '';
$strYesterday = date($now->format, (strtotime('-1 days', $now->dayBegin) + 1));
$strTomorrow = date($now->format, (strtotime('+1 days', $now->dayBegin) + 1));
$strPast = '';
$strFuture = '';
switch ($range)
{
case 'd':
//$strPast = date($now->format, $now->dayEnd);
$strPast = date($now->format, (strtotime('-1 days', $now->dayBegin) + 1));
break;
case 'w':
$strPast = date($now->format, (strtotime('-7 days', $now->dayBegin) + 1));
break;
case 'm':
$strPast = date($now->format, (strtotime('-1 month', $now->dayBegin) + 1));
break;
case 'h':
$strPast = date($now->format, (strtotime('-6 month', $now->dayBegin) + 1));
break;
case 'y':
$strPast = date($now->format, (strtotime('-1 year', $now->dayBegin) + 1));
break;
case 't':
$strToday = date($now->format, $now->dayBegin);
break;
case 'df':
$strFuture = date($now->format, (strtotime('+1 days', $now->dayBegin) + 1));
break;
case 'wf':
$strFuture = date($now->format, (strtotime('+7 days', $now->dayBegin) + 1));
break;
case 'mf':
$strFuture = date($now->format, (strtotime('+1 month', $now->dayBegin) + 1));
break;
case 'hf':
$strFuture = date($now->format, (strtotime('+6 month', $now->dayBegin) + 1));
break;
case 'yf':
$strFuture = date($now->format, (strtotime('+1 year', $now->dayBegin) + 1));
break;
}
$newcurrent = $current;
$newcurrent[$field] = ($strPast ? $strPast . '__' .$strYesterday : '') . $strToday . ($strFuture ? $strTomorrow . '__' . $strFuture : '');
$selected = ($current[$field] == $newcurrent[$field]);
$url = $this->generateFilterUrl($newcurrent, true);
$addOption = array();
$addOption['value'] = $url;
$addOption['label'] = &$GLOBALS['TL_LANG']['MSC']['daterange'][$range];
$addOption['id'] = $range;
if ($selected)
{
$addOption['selected'] = true;
}
array_push($options, $addOption);
}
$widget = array
(
'name' => $field,
'id' => 'filter_date_'.$field,
'label' => $fieldConf['label'][0],
'value' => $this->generateFilterUrl($current, true),
'tableless' => true,
'options' => serialize($options),
'inputType' => $input,
);
$settings['date'][] = $this->parseWidget($widget, false);
$widgets['date'][] = $widget;
}
}
$arrSort = deserialize($this->catalog_sort,true);
if ($this->catalog_sort_enable && count($arrSort))
{
// Setup sort values
$options = array();
if (count($arrSort) && $this->catalog_sort_type!='list')
{
$selected = !strlen($current[$field]);
$newcurrent = $current;
unset($newcurrent[$this->strOrderBy]);
unset($newcurrent[$this->strSort]);
$url = $this->generateFilterUrl($newcurrent, true);
$addOption = array();
$addOption['value'] = $url;
$addOption['label'] = $GLOBALS['TL_LANG']['MSC']['unsorted'];
$addOption['id'] = '';
if ($selected)
{
$addOption['selected'] = true;
}
array_push($options, $addOption);
}
foreach ($arrSort as $id=>$field)
{
$fieldConf = &$GLOBALS['TL_DCA'][$this->strTable]['fields'][$field];
$newcurrent = $current;
$newcurrent[$this->strOrderBy] = $field;
foreach (array('asc','desc') as $order)
{
$newcurrent[$this->strSort] = $order;
$selected = ($current[$this->strSort] == $newcurrent[$this->strSort] && $current[$this->strOrderBy] == $newcurrent[$this->strOrderBy]);
$url = $this->generateFilterUrl($newcurrent, true);
$addOption = array();
$addOption['value'] = $url;
$addOption['label'] = $fieldConf['label'][0] . ' ' . $this->selectSortLabel($fieldConf['eval']['catalog']['type'], ($order=='asc'));
$addOption['id'] = $field.'__'.$order;
if ($selected)
{
$addOption['selected'] = true;
}
array_push($options, $addOption);
}
}
$widget = array
(
'name' => $this->strSort,
'id' => 'filter_'.$this->strSort,
'value' => $this->generateFilterUrl($current, true),
'tableless' => true,
'options' => serialize($options),
'inputType' => $this->catalog_sort_type,
);
$settings['sort'] = $this->parseWidget($widget, false);
$widgets['sort'] = $widget;
}
if ($this->catalog_search_enable)
{
$widget = array
(
'name' => $this->strSearch,
'id' => 'filter_'.$this->strSearch,
'inputType' => 'text',
'value' => $this->Input->get($this->strSearch),
'tableless' => true,
'addSubmit' => true,
'slabel' => $GLOBALS['TL_LANG']['MSC']['catalogSearch'],
);
$settings['search'] = $this->parseWidget($widget);
$widgets['search'] = $widget;
}
$settings['url'] = $this->generateFilterUrl();
$settings['action'] = $this->generateFilterUrl($current);
$settings['widgets'] = $widgets;
if(is_array($GLOBALS['TL_HOOKS']['generateFilterCatalog']))
{
foreach ($GLOBALS['TL_HOOKS']['generateFilterCatalog'] as $callback)
{
$this->import($callback[0]);
$settings = $this->$callback[0]->$callback[1]($this,$settings);
}
}
return $settings;
}
public function parseWidget(&$widget)
{
$this->addWidgetAttributes($widget);
$class = $widget['inputType'];
$options = deserialize($widget['options']);
$return = '';
$label = $widget['label'] ? sprintf(
'<h3><label for="%s">%s</label></h3>
',
'ctrl_'.$widget['id'],
$widget['label'])
: '';
switch ($widget['inputType'])
{
case 'list':
$return = sprintf(
'%s<div id="%s" class="list_container">
<ul class="list%s">',
$label,
'ctrl_'.$widget['id'],
(strlen($widget['class']) ? ' ' . $widget['class'] : '')
);
foreach ($options as $id=>$option)
{
$class = standardize($option['id']);
$class = ($class == '' ? 'none' : $class);
$selected = $option['selected'];
$return .= sprintf('
<li class="option%s%s"><a href="%s" title="%s">%s</a></li>',
' list_'.$class,
($selected ? ' active' : ''),
$option['value'],
$option['label'],
$option['label']
);
}
$return .= '
</ul></div>';
break;
case 'range':
$widget['value'] = deserialize($widget['value'], true);
$arrFields = array();
for ($i=0; $i<2; $i++)
{
$datepicker = ($widget['datepicker'] ? '
<script type="text/javascript"><!--//--><![CDATA[//><!--
window.addEvent(\'domready\', function() { ' . sprintf($widget['datepicker'], 'ctrl_' . $widget['id'] .'_'.$i) . ' });
//--><!]]></script>'
: '');
// adding a <label for=""> to the inputs
$strLabel = ($i == 0) ? $GLOBALS['TL_LANG']['MSC']['rangeFrom'] : $GLOBALS['TL_LANG']['MSC']['rangeTo'];
$arrFields[] = sprintf('%s<input type="text" name="%s[]" id="ctrl_%s" class="text%s" value="%s"%s />',
(strlen($strLabel)) ? '<label for="ctrl_' . $widget['id'].'_'.$i . '">' . $strLabel . '</label>' : '',
$widget['name'],
$widget['id'].'_'.$i,
(strlen($widget['class']) ? ' ' . $widget['class'] : ''),
specialchars($widget['value'][$i]),
$widget['attributes'])
. $datepicker . ($i==1 ? $this->addSubmit($widget) : '');
}
$return = sprintf('%s<div id="ctrl_%s"%s>%s</div>',
$label,
$widget['id'],
(strlen($widget['class']) ? ' class="' . $widget['class'] . '"' : ''),
implode(($widget['separator'] ? $widget['separator'] : ' '), $arrFields));
break;
case 'text':
$return = sprintf('<input type="text" name="%s" id="ctrl_%s" class="text%s" value="%s"%s />',
$widget['name'],
$widget['id'],
(strlen($widget['class']) ? ' ' . $widget['class'] : ''),
specialchars($widget['value']),
$widget['attributes'])
. $this->addSubmit($widget);
break;
case 'radio':
$arrOptions = array();
foreach ($options as $i=>$option)
{
$arrOptions[] = sprintf('<input type="radio" name="%s" id="opt_%s" class="radio%s" value="%s"%s%s /> <label for="opt_%s">%s</label>',
$widget['name'],
$widget['id'].'_'.$option['id'],
(strlen($widget['class']) ? ' ' . $widget['class'] : ''),
specialchars($option['value']),
($option['selected'] ? ' checked="checked"' : ''),
$widget['attributes'],
// $widget['id'].'_'.$i,
$widget['id'].'_'.$option['id'], // we have to use the proper ID otherwise the label won't be attached to the input.
$option['label']);
}
// Add a "no entries found" message if there are no options
if (!count($options))
{
$arrOptions[]= '<p class="tl_noopt">'.$GLOBALS['TL_LANG']['MSC']['noResult'].'</p>';
}
$return = sprintf('%s<div id="ctrl_%s" class="radio_container%s">%s</div>',
$label,
$widget['id'],
(strlen($widget['class']) ? ' ' . $widget['class'] : ''),
implode(($widget['separator'] ? $widget['separator'] : '<br />'), $arrOptions));
break;
case 'checkbox':
$arrOptions = array();
foreach ($options as $i=>$option)
{
$arrOptions[] = sprintf('<span><input type="checkbox" name="%s" id="opt_%s" class="checkbox%s" value="%s"%s%s /> <label for="opt_%s">%s</label></span>',
$widget['name'] . ($widget['multiple'] ? '[]' : ''), // name
$widget['id'].'_'.$option['id'], // id
(strlen($widget['class']) ? ' ' . $widget['class'] : ''), // class
($widget['multiple'] ? specialchars($option['value']) : 1), // value
($option['selected'] ? ' checked="checked"' : ''), // state
$widget['attributes'], // more attributes
// $widget['id'].'_'.$i, // the id again
$widget['id'].'_'.$option['id'], // the id again
$option['label']); // and the label
}
// Add a "no entries found" message if there are no options
if (!count($options))
{
$arrOptions[]= '<p class="noopt">'.$GLOBALS['TL_LANG']['MSC']['noResult'].'</p>';
}
$return = sprintf('%s<div id="ctrl_%s" class="%s%s">%s</div>',
$label,
$widget['id'],
($widget['multiple'] ? 'checkbox_container' : 'checkbox_single_container'),
(strlen($widget['class']) ? ' ' . $widget['class'] : ''),
// implode(($widget['separator'] ? $widget['separator'] : '<br />'), $arrOptions));
// c.schiffler - removed the separator as if none specified, we do not want one. <br /> is evil IMO.
implode(($widget['separator'] ? $widget['separator'] : ''), $arrOptions));
break;
case 'select':
// Add empty option (XHTML) if there are none
if (!count($options))
{
$options = array(array('value'=>'', 'label'=>'-'));
}
foreach ($options as $option)
{
$strOptions .= sprintf('<option value="%s"%s>%s</option>',
$option['value'],
($option['selected'] ? ' selected="selected"' : ''),
$option['label']);
}
$return = sprintf('%s<select name="%s" id="ctrl_%s" class="%s%s"%s%s>%s</select>',
$label,
$widget['name'] . ($widget['multiple'] ? '[]' : ''),
$widget['id'],
($widget['multiple'] ? 'multi'.$class : $class),
(strlen($widget['class']) ? ' ' . $widget['class'] : ''),
($widget['multiple'] ? ' multiple="multiple"' : ''),
$widget['attributes'],
$strOptions);
break;
default:;
}
return '<div class="widget'.(strlen($widget['id']) ? ' ' . $widget['id'] : '').'">
'.$return.'
</div>
';
}
protected function addSubmit($widget)
{
return (strlen($widget['slabel']) ? sprintf(' <input type="submit" id="ctrl_%s_submit" class="submit" value="%s" />',
$widget['id'],
specialchars($widget['slabel']))
: '');
}
private function addWidgetAttributes(&$widget)
{
switch ($widget['inputType'])
{
case 'radio':
$types = array
(
'attributes' => ' onclick="window.location=this.value"',
);
break;
case 'checkbox':
$types = array
(
'multiple' => true,
'attributes' => ' onclick="window.location=this.value"',
);
break;
case 'select':
$types = array
(
'attributes' => $widget['multiple']
? ' onclick="window.location=this.options[this.selectedIndex].value"'
: ' onchange="window.location=this.options[this.selectedIndex].value"',
);
break;
default:;
}
if (is_array($types))
{
$widget = array_merge($widget, $types);
}
}
private function checkArray($arrInput)
{
return is_array($arrInput) ? $arrInput : array();
}
protected function selectSortLabel($inputType, $blnAsc=true)
{
$labelSuffix = '';
switch ($inputType)
{
case 'text':
case 'longtext':
case 'select':
case 'tags':
case 'url':
case 'file':
$labelSuffix = $blnAsc ? $GLOBALS['TL_LANG']['MSC']['AtoZ']: $GLOBALS['TL_LANG']['MSC']['ZtoA'];
break;
case 'number':
case 'decimal':
$labelSuffix = $blnAsc ? $GLOBALS['TL_LANG']['MSC']['lowhigh']: $GLOBALS['TL_LANG']['MSC']['highlow'];
break;
case 'checkbox':
$labelSuffix = $blnAsc ? $GLOBALS['TL_LANG']['MSC']['falsetrue']: $GLOBALS['TL_LANG']['MSC']['truefalse'];
break;
case 'date':
$labelSuffix = $blnAsc ? $GLOBALS['TL_LANG']['MSC']['dateasc']: $GLOBALS['TL_LANG']['MSC']['datedesc'];
break;
default:
if($blnAsc)
{
if($GLOBALS['TL_LANG']['MSC'][$inputType.'asc'])
$labelSuffix=$GLOBALS['TL_LANG']['MSC'][$inputType.'asc'];
} else {
if($GLOBALS['TL_LANG']['MSC'][$inputType.'desc'])
$labelSuffix=$GLOBALS['TL_LANG']['MSC'][$inputType.'desc'];
}
}
return $labelSuffix;
}
private function getJumpTo($catalogJump, $blnJumpTo=true)
{
global $objPage;
if(!$blnJumpTo)
return $objPage->row();
if ($this->cacheJumpTo[$catalogJump])
{
return $this->cacheJumpTo[$catalogJump];
}
else
{
if ($catalogJump && $blnJumpTo)
{
// Get current "jumpTo" page
$objJump = $this->Database->prepare("SELECT * FROM tl_page WHERE id=?")
->execute($catalogJump);
if ($objJump->numRows)
{
$pageRow = $objJump->row();
}
}
else
{
$pageRow = $objPage->row();
}
// cacheJumpTo
$this->cacheJumpTo[$pageRow['id']] = $pageRow;
return $pageRow;
}
}
public function generateFilterUrl($arrGet = array(), $blnRoot=false, $blnJumpTo=true)
{
$arrPage=$this->getJumpTo($this->catalog_jumpTo, $blnJumpTo);
$strParams = '';
if (is_array($arrGet) && ($arrGet))
{
foreach ($arrGet as $k=>$v)
{
if (strlen($v))
{
$fieldConf = &$GLOBALS['TL_DCA'][$this->strTable]['fields'][$k];
if (in_array($fieldConf['eval']['catalog']['type'], array('select', 'tags'))
&& $this->getAliasFieldConf($fieldConf) != 'id')
{
$arrAlias = $this->getAliasOptionList($fieldConf);
if ($fieldConf['eval']['catalog']['type'] == 'tags')
{
$tags = explode(',', $v);
$newtags = array();
foreach($tags as $tag)
{
$newtags[] = $arrAlias[$tag];
}
$v = implode(',', $newtags);
}
else
{
$v = $arrAlias[$v];
}
}
$v = str_replace($GLOBALS['TL_CONFIG']['catalog']['safeCheck'], $GLOBALS['TL_CONFIG']['catalog']['safeReplace'], $v);
$strParams .= $GLOBALS['TL_CONFIG']['disableAlias'] ? '&' . $k . '=' . $v : '/' . $k . '/' . $v;
}
}
}
return ($blnRoot ? $this->Environment->base : '') . $this->generateFrontEndUrl($arrPage, $strParams);
}
/**
* Translate SQL if needed (needed for calculated fields)
* @param array
* @return array
*/
protected function processFieldSQL($arrVisible)
{
$arrConverted = array();
// iterate all catalog fields
$objFields = $this->Database->prepare("SELECT * FROM tl_catalog_fields f WHERE f.pid=(SELECT c.id FROM tl_catalog_types c WHERE c.tableName=?)")
->execute($this->strTable);
$arrFields = array();
if ($objFields->numRows)
{
while ($objFields->next())
{
$row = $objFields->row();
$arrFields[$row['colName']] = $row;
}
foreach ($arrVisible as $id=>$field)
{
if (array_key_exists($field, $arrFields))
{
switch ($arrFields[$field]['type'])
{
case 'calc':
// set query value to forumla
$value = '('.$arrFields[$field]['calcValue'].') AS '.$field; //.'_calc';
$arrConverted[$id] = $value;
break;
default:
$arrConverted[$id] = $field;
}
}
// HOOK: allow third party extension developers to prepare the SQL data
if(is_array($GLOBALS['TL_HOOKS']['processFieldSQL']) && count($GLOBALS['TL_HOOKS']['processFieldSQL']))
{
foreach($GLOBALS['TL_HOOKS']['processFieldSQL'] as $callback)
{
$this->import($callback[0]);
$this->$callback[0]->$callback[1]($this->catalog, $id, $field, $arrFields, $arrConverted, $this->strTable);
}
}
}
}
return $arrConverted;
}
/**
* Generate one or more items and return them as array
* @param object
* @param boolean
* @return array
*/
protected function generateCatalog(Database_Result $objCatalog, $blnLink=true, $visible=null, $blnImageLink=false)
{
$i=0;
$arrCatalog = array();
$objCatalog->reset();
while ($objCatalog->next())
{
$arrCatalog[$i]['id'] = $objCatalog->id;
$arrCatalog[$i]['catalog_name'] = $objCatalog->catalog_name;
$arrCatalog[$i]['parentJumpTo'] = $objCatalog->parentJumpTo;
$arrCatalog[$i]['tablename'] = $this->strTable;
$arrCatalog[$i]['showLink'] = (!$this->catalog_link_override);
// get alias field WARNING -- check if blnLink is needed for edit mode where alias is also used
if ($i==0 && $blnLink)
{
$objArchive = $this->Database->prepare("SELECT aliasField FROM tl_catalog_types where id=?")
->limit(1)
->execute($objCatalog->pid);
$aliasField = $objArchive->numRows ? $objArchive->aliasField : 'alias';
}
$class = (($i == 0) ? ' first' : '') . ((($i + 1) == $objCatalog->numRows) ? ' last' : '') . ((($i % 2) == 0) ? ' even' : ' odd');
$arrCatalog[$i]['class'] = $class;
if ($blnLink)
{
$arrCatalog[$i]['link'] = $this->generateLink($objCatalog, $aliasField, $this->strTable, $this->catalog_link_window);
$arrCatalog[$i]['url'] = $this->generateCatalogUrl($objCatalog, $aliasField, $this->strTable);
}
$arrData = $objCatalog->row();
// check if editing of this record is disabled for frontend.
$editingallowedByFields=true;
foreach ($GLOBALS['TL_DCA'][$this->strTable]['fields'] as $fieldname=>$field)
{
if(is_array($visible) && !in_array($fieldname, $visible))
continue;
// HOOK: additional permission checks if this field allows editing of this record (for the current user).
$fieldType = $GLOBALS['BE_MOD']['content']['catalog']['fieldTypes'][$field['eval']['catalog']['type']];
if(is_array($fieldType) && array_key_exists('checkPermissionFERecordEdit', $fieldType) && is_array($fieldType['checkPermissionFERecordEdit']))
{
foreach ($fieldType['checkPermissionFERecordEdit'] as $callback)
{
$this->import($callback[0]);
// TODO: Do we need more parameters here?
if(!($this->$callback[0]->$callback[1]($this->strTable, $fieldname, $arrData)))
{
$editingallowedByFields=false;
break;
}
}
}
}
if ($this->catalog_edit_enable && $editingallowedByFields)
{
$arrCatalog[$i]['linkEdit'] = $this->generateLink($objCatalog, $aliasField, $this->strTable, $this->catalog_link_window, true);
$arrCatalog[$i]['urlEdit'] = $this->generateCatalogEditUrl($objCatalog, $aliasField, $this->strTable);
}
if (is_array($visible))
{
foreach($visible as $field)
{
$tmpData[$field] = $arrData[$field];
}
$arrData = $tmpData;
}
foreach ($arrData as $k=>$v)
{
$fieldConf = &$GLOBALS['TL_DCA'][$this->strTable]['fields'][$k];
$blnParentCheckbox = $fieldConf['eval']['catalog']['parentCheckbox'] && !$arrData[$fieldConf['eval']['catalog']['parentCheckbox']];
if (in_array($k, array('id','pid','sorting','tstamp')) || $fieldConf['inputType'] == 'password' || $blnParentCheckbox)
continue;
$strLabel = strlen($label = $fieldConf['label'][0]) ? $label : $k;
$strType = $fieldConf['eval']['catalog']['type'];
$arrValues = $this->parseValue($this->type.$i, $k, $v, $blnImageLink, $objCatalog);
$linked = deserialize($this->catalog_islink, true);
if ($this->catalog_link_override && is_array($linked) && in_array($k, $linked))
{
$arrValues['html'] = $this->generateLink($objCatalog, $aliasField, $this->strTable, $this->catalog_link_window, false, $arrValues['html']);
}
$arrCatalog[$i]['data'][$k] = array
(
'label' => $strLabel,
'type' => $strType,
'raw' => $v,
'value' => ($arrValues['html'] ? $arrValues['html'] : '')
);
switch ($strType)
{
case 'select':
case 'tags':
list($refTable, $valueCol) = explode('.', $fieldConf['eval']['catalog']['foreignKey']);
if (strlen(trim($v)))
{
// set sort order
$sortCol = $fieldConf['eval']['catalog']['sortCol'];
if (!strlen($sortCol))
{
$sortCol = 'sorting';
}
$sortOrder = $this->Database->fieldExists($sortCol, $refTable) ? $sortCol : $refCol;
// Get referenced fields
$objRef = $this->Database->prepare('SELECT * FROM '.$refTable.' WHERE id IN ('.trim($v).')'.(strlen($sortOrder)?' ORDER BY '.$sortOrder:''))
->execute();
if ($objRef->numRows)
{
// Get Ref Catalog JumpTo
$objJump = $this->Database->prepare("SELECT tableName, aliasField, jumpTo FROM tl_catalog_types WHERE tableName=?")
->limit(1)
->execute($refTable);
// Add Ref Catalog Links
if ($objJump->numRows)
{
while ($objRef->next())
{
$objRef->parentJumpTo = $objJump->jumpTo;
$objRef->parentLink = $this->generateLink($objRef, $objJump->aliasField, $objJump->tableName, $this->catalog_link_window);
$objRef->parentUrl = $this->generateCatalogUrl($objRef, $objJump->aliasField, $objJump->tableName);
}
}
// add to reference array
$arrCatalog[$i]['data'][$k]['ref'] = $objRef->fetchAllAssoc();
}
}
break;
case 'file':
case 'image':
// add file and image information
$arrCatalog[$i]['data'][$k]['files'] = $arrValues['items'];
$arrCatalog[$i]['data'][$k]['meta'] = $arrValues['values'];
break;
default:
// per default we deliver all other keys aswell to allow custom field types to transport custom data.
foreach($arrValues as $kk => $vv)
{
if($kk != 'html')
$arrCatalog[$i]['data'][$k][$kk] = $vv;
}
}
}
// HOOK: allow other extensions to manipulate the item before returning them in the array
if(is_array($GLOBALS['TL_HOOKS']['generateCatalogItem']))
{
foreach ($GLOBALS['TL_HOOKS']['generateCatalogItem'] as $callback)
{
$this->import($callback[0]);
$arrCatalog[$i] = $this->$callback[0]->$callback[1]($arrCatalog[$i], $arrData, $this);
}
}
$i++;
}
return $arrCatalog;
}
/**
* Parse one or more items and pipe them through the given template
* @param object
* @param boolean
* @return array
*/
protected function parseCatalog(Database_Result $objCatalog, $blnLink=true, $template='catalog_full', $visible=null, $blnImageLink=false)
{
$objTemplate = new FrontendTemplate($template);
$arrCatalog = $this->generateCatalog($objCatalog, $blnLink, $visible, $blnImageLink);
// HOOK: allow other extensions to manipulate the items before passing it to the template
if(is_array($GLOBALS['TL_HOOKS']['parseCatalog']))
{
foreach ($GLOBALS['TL_HOOKS']['parseCatalog'] as $callback)
{
$this->import($callback[0]);
$arrCatalog = $this->$callback[0]->$callback[1]($arrCatalog, $objTemplate, $this);
}
}
$objTemplate->entries = $arrCatalog;
$objTemplate->moduleTemplate = $this->Template;
$objTemplate->noItemsMsg = $GLOBALS['TL_LANG']['MSC']['noItemsMsg'];
return $objTemplate->parse();
}
protected function generateCatalogUrl(Database_Result $objCatalog, $aliasField='alias', $strTable, $strPrependParams='')
{
if (!strlen($aliasField))
{
$aliasField = 'alias';
}
$useJump = ($this instanceof ModuleCatalogList || $this instanceof ModuleCatalogFeatured || $this instanceof ModuleCatalogRelated || $this instanceof ModuleCatalogReference || $this instanceof ModuleCatalogNavigation);
$jumpTo = ($useJump && $this->jumpTo) ? $this->jumpTo : $objCatalog->parentJumpTo;
$arrPage=$this->getJumpTo($jumpTo, true);
return ampersand($this->generateFrontendUrl($arrPage, $strPrependParams . '/items/' . (($this->Database->fieldExists($aliasField, $strTable) && strlen($objCatalog->$aliasField) && !$GLOBALS['TL_CONFIG']['disableAlias']) ? $objCatalog->$aliasField : $objCatalog->id)));
}
private function generateCatalogEditUrl(Database_Result $objCatalog, $aliasField='alias', $strTable)
{
if (!strlen($aliasField))
{
$aliasField = 'alias';
}
$arrPage=$this->getJumpTo($this->catalog_editJumpTo, true);
// Link to catalog edit
return ampersand($this->generateFrontendUrl($arrPage, '/items/' . (($this->Database->fieldExists($aliasField, $strTable) && strlen($objCatalog->$aliasField) && !$GLOBALS['TL_CONFIG']['disableAlias']) ? $objCatalog->$aliasField : $objCatalog->id)));
}
/**
* Generate a link and return it as string
* @param string
* @param object
* @param boolean
* @return string
*/
protected function generateLink(Database_Result $objCatalog, $aliasField, $strTable, $blnWindow, $blnEdit=false, $strLink='')
{
$linkUrl = (!$blnEdit ? $this->generateCatalogUrl($objCatalog, $aliasField, $strTable) : $this->generateCatalogEditUrl($objCatalog, $aliasField, $strTable));
$strLink = strlen($strLink) ? $strLink : (!$blnEdit ? $GLOBALS['TL_LANG']['MSC']['viewCatalog'] : $GLOBALS['TL_LANG']['MSC']['editCatalog']);
$strTitle = (!$blnEdit ? $GLOBALS['TL_LANG']['MSC']['viewCatalog'] : $GLOBALS['TL_LANG']['MSC']['editCatalog']);
return sprintf('<a href="%s" title="%s"%s>%s</a>',
$linkUrl,
$strTitle,
$blnWindow ? ' onclick="this.blur(); window.open(this.href); return false;"' : '',
$strLink
);
}
/**
* Format the catalog value according to its settings and return it as HTML string
* @param integer
* @param string
* @param variable
* @param boolean
* @return string
*/
protected function formatValue($id, $k, $value, $blnImageLink=true, $objCatalog=array())
{
$arrFormat = $this->parseValue($id, $k, $value, $blnImageLink, $objCatalog);
return $arrFormat['html'];
}
/**
* parse the catalog values and return information as an array
* @param integer
* @param string
* @param variable
* @param boolean
* @return array
*/
protected function parseValue($id, $k, $value, $blnImageLink=true, $objCatalog=array())
{
$raw = $value;
$arrItems = deserialize($value, true);
$arrValues = deserialize($value, true);
$strHtml = $value;
$fieldConf = &$GLOBALS['TL_DCA'][$this->strTable]['fields'][$k];
if((version_compare(VERSION, '2.10', '>=')) && $fieldConf['eval']['rte'] && $GLOBALS['TL_CONFIG']['useRTE'])
{
global $objPage;
$this->import('String');
// reformat the RTE output to the proper format
if($objPage->outputFormat == 'xhtml')
{
$strHtml = $this->String->toXhtml($strHtml);
}
if($objPage->outputFormat == 'html5')
{
$strHtml = $this->String->toHtml5($strHtml);
}
}
switch ($fieldConf['eval']['catalog']['type'])
{
case 'select':
case 'tags':
if ($fieldConf['options'])
{
$arrItems = trimsplit(',',$raw);
$selectedValues = array_intersect_key($fieldConf['options'], array_flip($arrItems));
$arrValues = $selectedValues;
$strHtml = implode(', ', $arrValues);
}
break;
case 'file':
$files = $this->parseFiles($id, $k, $raw);
$arrItems = $files['files'];
$arrValues = $files['src'];
$strHtml = implode('', $files['html']);
break;
case 'url':
if (strlen($raw))
{
// E-mail addresses
if (preg_match_all('/^(mailto:)?(\w+([_\.-]*\w+)*@\w+([_\.-]*\w+)*\.[a-z]{2,6})$/i', $value, $matches))
{
$this->import('String');
$emailencode = $this->String->encodeEmail($matches[2][0]);
$arrValues[0] = $emailencode;
$strHtml = '<a href="mailto:' . $emailencode . '">' . $emailencode . '</a>';
}
elseif (preg_match_all('@^(https?://|ftp://)(\w+([_\.-]*\w+)*\.[a-z]{2,6})(/?)@i', $value, $matches))
{
$arrValues[0] = $raw;
$website = $matches[2][0];
$strHtml = '<a href="'.ampersand($raw).'"'.(preg_match('@^(https?://|ftp://)@i', $value) ? ' onclick="window.open(this.href); return false;"' : '').'>'.$website.'</a>';
}
}
break;
// allow custom fields.
default:
if(array_key_exists($fieldConf['eval']['catalog']['type'], $GLOBALS['BE_MOD']['content']['catalog']['fieldTypes']))
{
// HOOK: try to format the fieldtype as it is a custom added one.
$fieldType=$GLOBALS['BE_MOD']['content']['catalog']['fieldTypes'][$fieldConf['eval']['catalog']['type']];
if(array_key_exists('parseValue', $fieldType) && is_array($fieldType['parseValue']))
{
foreach ($fieldType['parseValue'] as $callback)
{
$this->import($callback[0]);
$ret=$this->$callback[0]->$callback[1]($id, $k, $value, $blnImageLink, $objCatalog, $this, $fieldConf);
$arrItems = $ret['items'];
$arrValues = $ret['values'];
$strHtml = $ret['html'];
}
}
}
}
// special formatting
$formatStr = $fieldConf['eval']['catalog']['formatStr'];
if (strlen($formatStr))
{
//$formatStr = htmlspecialchars_decode($fieldConf['eval']['catalog']['formatStr']);
$value = $arrValues[0];
switch ($fieldConf['eval']['catalog']['formatFunction'])
{
case 'string':
$value = sprintf($formatStr, $value);
break;
case 'number':
$decimalPlaces = is_numeric($formatStr) ? intval($formatStr) : 0;
$value = number_format($value, $decimalPlaces,
$GLOBALS['TL_LANG']['MSC']['decimalSeparator'],
$GLOBALS['TL_LANG']['MSC']['thousandsSeparator']);
break;
case 'date':
if (strlen($raw) && $raw !== 0)
{
$date = new Date($raw);
$value = $this->parseDate((strlen($formatStr) ? $formatStr : $GLOBALS['TL_CONFIG']['dateFormat']), $date->tstamp);
}
else
{
$value = '';
}
break;
default:;
}
$arrValues[0] = $value;
$strHtml = $value;
}
// add prefix and suffix format strings
if (is_array($fieldConf['eval']['catalog']['formatPrePost']) && count($fieldConf['eval']['catalog']['formatPrePost'])>0)
{
$strHtml = $fieldConf['eval']['catalog']['formatPrePost'][0].$strHtml.$fieldConf['eval']['catalog']['formatPrePost'][1];
// no $this->restoreBasicEntities() as this is done in the OutputTemplate
}
$return['items'] = $arrItems;
$return['values'] = $arrValues;
$return['html'] = $strHtml;
return $return;
}
/**
* parse files into HTML and other information and return as an array
* @param integer
* @param string
* @param variable
* @return array
*/
public function parseFiles($id, $k, $files)
{
$fieldConf = &$GLOBALS['TL_DCA'][$this->strTable]['fields'][$k];
$blnThumnailOverride = $this->catalog_thumbnails_override && ($this instanceof ModuleCatalogList || $this instanceof ModuleCatalogFeatured || $this instanceof ModuleCatalogRelated || $this instanceof ModuleCatalogReference);
// setup standard linking
$showLink = $fieldConf['eval']['catalog']['showLink'];
// image override
if ($blnThumnailOverride)
{
$showLink = $this->catalog_imagemain_field == $k ? $this->catalog_imagemain_fullsize :
($this->catalog_imagegallery_field == $k ? $this->catalog_imagegallery_fullsize : ''); // override default
}
$sortBy = $blnThumnailOverride ? $this->sortBy : $fieldConf['eval']['catalog']['sortBy'];
$files = deserialize($files,true);
$countFiles = count($files);
if (!is_array($files) || $countFiles < 1)
{
return array('files'=>array(),'src'=>array(),'html'=>array());
}
// required for parseMetaFile function (in FrontEnd)
$this->multiSRC = $files;
$this->arrAux = array();
// TODO: we also have to clean the array of already processed files here as otherwise $arrAux will not get populated again.
// We might find some better approach to this in the future rather than cleaning the cache arrays.
$this->arrProcessed=array();
$arrFiles = array();
$arrSource = array();
$arrValues = array();
$auxDate = array();
$counter = 0;
$allowedDownload = trimsplit(',', strtolower($GLOBALS['TL_CONFIG']['allowedDownload']));
if (strlen($fieldConf['eval']['extensions']))
{
$extensions = trimsplit(',', strtolower($fieldConf['eval']['extensions']));
$allowedDownload = array_intersect($allowedDownload, $extensions);
}
foreach ($files as $file)
{
if (!file_exists(TL_ROOT . '/' . $file))
{
continue;
}
if (is_file(TL_ROOT . '/' . $file))
{
$objFile = new File($file);
$showImage = $objFile->isGdImage && $fieldConf['eval']['catalog']['showImage'];
if (!$showImage && in_array($objFile->extension, $allowedDownload) || $showImage)
{
$class = (($counter == 0) ? ' first' : '') . (($counter == ($countFiles -1 )) ? ' last' : '') . ((($counter % 2) == 0) ? ' even' : ' odd');
$this->parseMetaFile(dirname($file), true);
$strBasename = strlen($this->arrMeta[$objFile->basename][0]) ? $this->arrMeta[$objFile->basename][0] : specialchars($objFile->basename);
$alt = (strlen($this->arrMeta[$objFile->basename][0]) ? $this->arrMeta[$objFile->basename][0] : ucfirst(str_replace('_', ' ', preg_replace('/^[0-9]+_/', '', $objFile->filename))));
$auxDate[] = $objFile->mtime;
// images
if ($showImage)
{
$w = $fieldConf['eval']['catalog']['imageSize'][0] ? $fieldConf['eval']['catalog']['imageSize'][0] : '';
$h = $fieldConf['eval']['catalog']['imageSize'][1] ? $fieldConf['eval']['catalog']['imageSize'][1] : '';
if ($blnThumnailOverride)
{
$newsize = deserialize($this->catalog_imagemain_field == $k ? $this->catalog_imagemain_size
: ($this->catalog_imagegallery_field == $k ? $this->catalog_imagegallery_size : array()) );
$w = ($newsize[0] ? $newsize[0] : '');
$h = ($newsize[1] ? $newsize[1] : '');
}
$src = $this->getImage($this->urlEncode($file), $w, $h, $fieldConf['eval']['catalog']['imageSize'][2]);
$size = getimagesize(TL_ROOT . '/' . $src);
$arrSource[$file] = array
(
'src' => $src,
'alt' => $alt,
'lb' => 'lb'.$id,
'w' => $size[0],
'h' => $size[1],
'wh' => $size[3],
'caption' => (strlen($this->arrMeta[$objFile->basename][2]) ? $this->arrMeta[$objFile->basename][2] : ''),
'metafile' => $this->arrMeta[$objFile->basename],
);
$tmpFile = '<img src="'.$src.'" alt="'.$alt.'" '.$size[3].' />';
if ($showLink)
{
// $tmpFile = '<a rel="lightbox[lb'.$id.']" href="'.$file.'" title="'.$alt.'">'.$tmpFile.'</a>';
// we have to supply the catalog id here as we might have more than one catalog with a field with the same name
// which will cause the lightbox to display the images for items with the same id in both.
$tmpFile = '<a data-lightbox="'. $this->strTable . $id . '" title="'.$alt.'" href="'.$file . '/' . $subfile.'">'.$tmpFile.'</a>';
}
}
// files
elseif ($showLink)
{
$text = $strBasename;
$url = $this->Environment->request . (($GLOBALS['TL_CONFIG']['disableAlias'] || strpos($this->Environment->request, '?') !== false) ? '&' : '?') . 'file=' . $this->urlEncode($file);
$icon = 'system/themes/' . $this->getTheme() . '/images/' . $objFile->icon;
$sizetext = '('.$this->getReadableSize($objFile->filesize, 1).')';
$arrSource[$file] = array
(
'title' => $strBasename,
'url' => $url,
'alt' => $alt,
'caption' => (strlen($this->arrMeta[$objFile->basename][2]) ? $this->arrMeta[$objFile->basename][2] : ''),
'size' => $objFile->filesize,
'sizetext' => $sizetext,
'icon' => $icon,
'metafile' => $this->arrMeta[$objFile->basename],
);
$iconfile = '<img src="'.$icon.'" alt="'.$alt.'" />';
$tmpFile = $iconfile.' <a href="'.$url.'" title="'.$alt.'">'.$text.' '.$sizetext.'</a>';
}
$arrFiles[$file] = $file;
$arrValues[$file] = '<span class="'.($showImage ? 'image' : 'file').$class.'">'.$tmpFile.'</span>';
$counter ++;
}
continue;
}
else if (is_dir(TL_ROOT . '/' . $file))
{
// Folders
$subfiles = scan(TL_ROOT . '/' . $file);
$this->parseMetaFile($file);
foreach ($subfiles as $subfile)
{
if (is_file(TL_ROOT . '/' . $file . '/' . $subfile))
{
$objFile = new File($file . '/' . $subfile);
$showImage = $objFile->isGdImage && $fieldConf['eval']['catalog']['showImage'];
if (!$showImage && in_array($objFile->extension, $allowedDownload) || $showImage)
{
$class = (($counter == 0) ? ' first' : '') . ((($counter % 2) == 0) ? ' even' : ' odd');
$strBasename = strlen($this->arrMeta[$objFile->basename][0]) ? $this->arrMeta[$objFile->basename][0] : specialchars($objFile->basename);
$alt = (strlen($this->arrMeta[$objFile->basename][0]) ? $this->arrMeta[$objFile->basename][0] : ucfirst(str_replace('_', ' ', preg_replace('/^[0-9]+_/', '', $objFile->filename))));
$auxDate[] = $objFile->mtime;
if ($showImage)
{
$w = $fieldConf['eval']['catalog']['imageSize'][0] ? $fieldConf['eval']['catalog']['imageSize'][0] : '';
$h = $fieldConf['eval']['catalog']['imageSize'][1] ? $fieldConf['eval']['catalog']['imageSize'][1] : '';
if ($blnThumnailOverride)
{
$newsize = deserialize($this->catalog_imagemain_field == $k ? $this->catalog_imagemain_size
: ($this->catalog_imagegallery_field == $k ? $this->catalog_imagegallery_size : array()) );
$w = ($newsize[0] ? $newsize[0] : '');
$h = ($newsize[1] ? $newsize[1] : '');
}
$src = $this->getImage($this->urlEncode($file . '/' . $subfile), $w, $h, $fieldConf['eval']['catalog']['imageSize'][2]);
$size = getimagesize(TL_ROOT . '/' . $src);
$arrSource[$file . '/' . $subfile] = array
(
'src' => $src,
'alt' => $alt,
'lb' => 'lb'.$id,
'w' => $size[0],
'h' => $size[1],
'wh' => $size[3],
'caption' => (strlen($this->arrMeta[$objFile->basename][2]) ? $this->arrMeta[$objFile->basename][2] : ''),
'metafile' => $this->arrMeta[$objFile->basename],
);
$tmpFile = '<img src="'.$src.'" alt="'.$alt.'" '.$size[3].' />';
if ($showLink)
{
// $tmpFile = '<a rel="lightbox[lb'.$id.']" title="'.$alt.'" href="'.$file . '/' . $subfile.'">'.$tmpFile.'</a>';
// we have to supply the catalog id here as we might have more than one catalog with a field with the same name here.
$tmpFile = '<a data-lightbox="'. $this->strTable . $id . '" title="'.$alt.'" href="'.$file . '/' . $subfile.'">'.$tmpFile.'</a>';
}
}
// files
elseif ($showLink)
{
$text = $strBasename;
$url = $this->Environment->request . (($GLOBALS['TL_CONFIG']['disableAlias'] || !$GLOBALS['TL_CONFIG']['rewriteURL']
&& count($_GET) || strlen($_GET['page'])) ? '&' : '?'). 'file=' . $this->urlEncode($file . '/' . $subfile);
$icon = 'system/themes/' . $this->getTheme() . '/images/' . $objFile->icon;
$sizetext = '('.number_format(($objFile->filesize/1024), 1, $GLOBALS['TL_LANG']['MSC']['decimalSeparator'], $GLOBALS['TL_LANG']['MSC']['thousandsSeparator']).' kB)';
$arrSource[$file . '/' . $subfile] = array
(
'title' => $strBasename,
'url' => $url,
'alt' => $alt,
'caption' => (strlen($this->arrMeta[$objFile->basename][2]) ? $this->arrMeta[$objFile->basename][2] : ''),
'size' => $objFile->filesize,
'sizetext' => $sizetext,
'icon' => $icon,
'metafile' => $this->arrMeta[$objFile->basename],
);
$iconfile = '<img src="'.$icon.'" alt="'.$alt.'" />';
$tmpFile = $iconfile.' <a href="'.$url.'" title="'.$alt.'">'.$text.' '.$sizetext.'</a>';
}
$arrFiles[$file . '/' . $subfile] = $file . '/' . $subfile;
$arrValues[$file . '/' . $subfile] = '<span class="'.($showImage ? 'image' : 'file').$class.'">'.$tmpFile.'</span>';
$counter ++;
}
}
}
}
}
// Sort array
$files = array();
$source = array();
$values = array();
switch ($sortBy)
{
default:
case 'name_asc':
uksort($arrFiles, 'basename_natcasecmp');
break;
case 'name_desc':
uksort($arrFiles, 'basename_natcasercmp');
break;
case 'date_asc':
array_multisort($arrFiles, SORT_NUMERIC, $auxDate, SORT_ASC);
break;
case 'date_desc':
array_multisort($arrFiles, SORT_NUMERIC, $auxDate, SORT_DESC);
break;
case 'meta':
foreach ($this->arrAux as $aux)
{
$k = array_search($aux, $arrFiles);
if ($k !== false)
{
$files[] = $arrFiles[$k];
$source[] = $arrSource[$k];
$values[] = $arrValues[$k];
}
}
break;
case 'random':
$keys = array_keys($arrFiles);
shuffle($keys);
foreach($keys as $key)
{
$files[$key] = $arrFiles[$key];
}
$arrFiles = $files;
break;
}
if ($sortBy != 'meta')
{
// re-sort the values
foreach($arrFiles as $k=>$v)
{
$files[] = $arrFiles[$k];
$source[] = $arrSource[$k];
$values[] = $arrValues[$k];
}
}
$return['files'] = $files;
$return['src'] = $source;
$return['html'] = $values;
return $return;
}
/**
* Replace Catalog InsertTags including TL InsertTags
* @param string
* @param array
* @return string
*/
protected function replaceCatalogTags($strValue, $arrCatalog)
{
$strValue = trim($strValue);
// search for catalog tags
$tags = array();
preg_match_all('/{{[^}]+}}/i', $strValue, $tags);
// Replace tags of type {{catalog::fieldname}}
foreach ($tags[0] as $tag)
{
$elements = explode('::', trim(str_replace(array('{{', '}}'), array('', ''), $tag)));
// {{catalog::fieldname}}
if (strtolower($elements[0]) == 'catalog')
{
$key = $elements[1];
if (array_key_exists($key, $arrCatalog))
{
$strValue = str_replace($tag, str_replace("\n", "<br>", $arrCatalog[$key]), $strValue);
}
}
}
// Replace standard insert tags
if (strlen($strValue))
{
$strValue = $this->replaceInsertTags($strValue);
}
return $strValue;
}
/**
* Generate Front-end Url with only catalog ID as parameter
* @param integer
* @param integer
* @return string
*/
public function generateCatalogNavigationUrl($field=false, $value=false)
{
$jumpTo= $this->catalog_jumpTo?$this->catalog_jumpTo:$this->jumpTo;
$pageRow=$this->getJumpTo($jumpTo, true);
if (!$pageRow)
{
return ampersand($this->Environment->request, ENCODE_AMPERSANDS);
}
if($field)
{
$strParams = $GLOBALS['TL_CONFIG']['disableAlias'] ? '&' . $field . '=' . $value : '/' . $field . '/' . $value;
} else {
$strParams = '';
}
// Return link to catalog reader page with item alias
return ampersand($this->generateFrontendUrl($pageRow, $strParams));
}
protected function renderCatalogNavigationItems($id, $level=1, $blnTags=false, $value='')
{
$aliasField = $this->getAliasField($this->strTable);
$strWhere = $blnTags ? $this->strTable.'.id=tl_catalog_tag_rel.itemid AND fieldid='.$GLOBALS['TL_DCA'][$this->strTable]['fields'][$this->catalog_navigation]['eval']['catalog']['fieldId'].' AND valueid='.$id.'' : $this->catalog_navigation."=?";
// TODO: add the parsed filter URL here.
if(!BE_USER_LOGGED_IN && $this->publishField)
{
$strWhere .=' AND '.$this->publishField.'=1';
}
// query database
$objNodes = $this->Database->prepare('SELECT DISTINCT '.$this->strTable.'.*, tl_catalog_types.jumpTo AS parentJumpTo FROM '.$this->strTable.($blnTags?', tl_catalog_tag_rel':'').', tl_catalog_types WHERE tl_catalog_types.id='.$this->strTable.'.pid AND '.$strWhere)
->execute($id);
if ($objNodes->numRows < 1)
{
return '';
}
$items = array();
// Determine the layout template
if (!strlen($this->navigationTpl))
{
$this->navigationTpl = 'nav_default';
}
// Overwrite template
$objTemplate = new FrontendTemplate($this->navigationTpl);
$objTemplate->type = get_class($this);
$objTemplate->level = 'level_' . $level++;
// Get page object
global $objPage;
$showField = $this->catalog_show_field;
// Browse items
while($objNodes->next())
{
$href = $this->generateCatalogUrl($objNodes, $aliasField, $this->strTable, sprintf('/%s/%s', $this->catalog_navigation, $value?$value:$id));
// Active field
if ($this->Input->get('items') == $objNodes->id || $this->Input->get('items') == $objNodes->$aliasField)
{
$strClass = trim('item' . (strlen($objJump->cssClass) ? ' ' . $objJump->cssClass : ''));
$items[] = array
(
'isActive' => true,
'subitems' => $subitems,
'class' => (strlen($strClass) ? $strClass : ''),
// 'pageTitle' => specialchars($objJump->pageTitle),
'title' => specialchars($objNodes->$showField),
'link' => $objNodes->$showField,
'href' => $href,
// 'alias' => $objJump->alias,
// 'target' => (($objJump->type == 'redirect' && $objJump->target) ? ' window.open(this.href); return false;' : ''),
// 'description' => str_replace(array("\n", "\r"), array(' ' , ''), $objJump->description),
// 'accesskey' => $objJump->accesskey,
// 'tabindex' => $objJump->tabindex
);
continue;
}
$strClass = trim('item' . (strlen($objJump->cssClass) ? ' ' . $objJump->cssClass : ''));
$items[] = array
(
'isActive' => false,
'subitems' => $subitems,
'class' => (strlen($strClass) ? $strClass : ''),
// 'pageTitle' => specialchars($objJump->pageTitle),
'title' => specialchars($objNodes->$showField),
'link' => $objNodes->$showField,
'href' => $href,
// 'alias' => $objJump->alias,
// 'target' => (($objJump->type == 'redirect' && $objJump->target) ? ' window.open(this.href); return false;' : ''),
// 'description' => str_replace(array("\n", "\r"), array(' ' , ''), $objJump->description),
// 'accesskey' => $objJump->accesskey,
// 'tabindex' => $objJump->tabindex
);
}
// Add classes first and last
if (count($items))
{
$last = count($items) - 1;
$items[0]['class'] = trim($items[0]['class'] . ' first');
$items[$last]['class'] = trim($items[$last]['class'] . ' last');
}
$objTemplate->items = $items;
return count($items) ? $objTemplate->parse() : '';
}
protected $arrTrail=array();
protected $objNavField=NULL;
/**
* Recursively compile the catalog navigation menu and return it as HTML string
* @param integer
* @param integer
* @return string
*/
protected function internalRenderCatalogNavigation($pid, $level, $strActive=NULL)
{
// Get internal page (from parent catalog)
$arrJump = $this->getJumpTo($this->jumpTo, false);
$ids = ($pid == 0) ? ($this->objNavField->limitItems && $this->objNavField->items ? $this->objNavField->items : array(0)) : array($pid);
$strRoot = ((!$this->objNavField->blnChildren && $level == 1) ? 'id' : 'pid');
if ($this->objNavField->treeView)
{
if($this->objNavField->type == 'tags')
{
$strItemCount = '(SELECT COUNT(t.id) AS count FROM tl_catalog_tag_rel AS t RIGHT JOIN ' . $this->strTable . ' AS c ON (t.itemid=c.id) WHERE t.valueid=o.id AND t.fieldid=' . $this->objNavField->id . (!BE_USER_LOGGED_IN && $this->publishField ? ' AND c.' . $this->publishField.'=1' : '') . ') AS itemCount';
} else {
$strItemCount = '(SELECT COUNT(t.id) AS count FROM ' . $this->strTable . ' AS t WHERE ' .
(!BE_USER_LOGGED_IN && $this->publishField ? 't.'.$this->publishField.'=1 AND ' : '') .
$this->catalog_navigation . ' IN (SELECT id FROM ' . $this->objNavField->sourceTable . ' AS t WHERE pid=o.id) OR '.$this->catalog_navigation.'=o.id) AS itemCount';
}
$objNodes = $this->Database->execute('SELECT '.$strRoot.', id, ' . $this->objNavField->valueField .
', (SELECT COUNT(*) FROM '. $this->objNavField->sourceTable .' i WHERE i.pid=o.id) AS childCount, ' .
$this->objNavField->sourceColumn . ' AS name, ' .
$strItemCount .
' FROM '. $this->objNavField->sourceTable. ' o WHERE '.$strRoot.' IN ('.implode(',',$ids).') ORDER BY '. $this->objNavField->sort);
}
if (!$this->objNavField->treeView || ($objNodes->numRows == 0 && $level == 1))
{
$objNodes = $this->Database->execute('SELECT id, '.$this->objNavField->valueField.', 0 AS childCount, '. $this->objNavField->sourceColumn .' AS name, 0 AS itemCount FROM '. $this->objNavField->sourceTable .' ORDER BY '.$this->objNavField->sort);
}
// no entries for the given pid
if (!$objNodes->numRows)
return '';
$valueField=$this->objNavField->valueField;
$items = array();
// Overwrite template
$objTemplate = new FrontendTemplate($this->navigationTpl);
$objTemplate->type = get_class($this);
$objTemplate->level = 'level_' . $level++;
// Browse field nodes
while($objNodes->next())
{
$subitems = '';
$strClass = '';
// setup field and value
$field = $this->catalog_navigation;
$value = $objNodes->$valueField;
$isTrail = in_array($objNodes->id, $this->arrTrail);
$href = $this->generateCatalogNavigationUrl($field, $value, sprintf('/%s/%s', $field, $value));
if (!$this->showLevel || $this->showLevel >= $level || (!$this->hardLimit && $isTrail))
{
// if current field value is selected, display children
if ($this->catalog_show_items && $strActive == $objNodes->$valueField)
{
$subitems .= $this->renderCatalogNavigationItems($objNodes->id, $level, ($this->objNavField->type == 'tags'), $value);
}
if (count($objNodes->childCount) && $this->objNavField->blnChildren)
{
$subitems .= $this->internalRenderCatalogNavigation($objNodes->id, $level, $strActive);
}
}
$strClass .= trim((strlen($subitems) ? 'submenu' : '')
. (strlen($arrJump['cssClass']) ? ' ' . $arrJump['cssClass'] : '')
. ($isTrail ? ' trail' : '')
. ' ' . (count($items)%2 ? 'odd' : 'even')
);
// Active field
if ($strActive == $value)
{
$items[] = array
(
'isActive' => !strlen($this->Input->get('items')),
'subitems' => $subitems,
'subitemcount' => $objNodes->itemCount,
'class' => (strlen($strClass) ? $strClass : ''),
'pageTitle' => specialchars($arrJump['pageTitle']),
'title' => specialchars($objNodes->name),
'link' => $objNodes->name,
'href' => $href,
'alias' => $arrJump['alias'],
'target' => (($arrJump['type'] == 'redirect' && $arrJump['target']) ? ' window.open(this.href); return false;' : ''),
'description' => str_replace(array("\n", "\r"), array(' ' , ''), $arrJump['description']),
'accesskey' => $arrJump['accesskey'],
'tabindex' => $arrJump['tabindex'],
'itemAlias' => $value
);
// move on to next childnode
continue;
}
if(!$this->objNavField->treeView || ($objNodes->itemCount || $objNodes->childCount))
{
$items[] = array
(
'isActive' => false,
'subitems' => $isTrail?$subitems:'',
'subitemcount' => $objNodes->itemCount,
'class' => (strlen($strClass) ? $strClass : ''),
'pageTitle' => specialchars($arrJump['pageTitle']),
'title' => specialchars($objNodes->name),
'link' => specialchars($objNodes->name),
'href' => $href,
'alias' => $arrJump['alias'],
'target' => (($arrJump['type'] == 'redirect' && $arrJump['target']) ? ' window.open(this.href); return false;' : ''),
'description' => str_replace(array("\n", "\r"), array(' ' , ''), $arrJump['description']),
'accesskey' => $arrJump['accesskey'],
'tabindex' => $arrJump['tabindex'],
'itemAlias' => $value
);
}
}
// Add classes first and last
if (count($items))
{
$last = count($items) - 1;
$items[0]['class'] = trim($items[0]['class'] . ' first');
$items[$last]['class'] = trim($items[$last]['class'] . ' last');
}
$objTemplate->items = $items;
return count($items) ? $objTemplate->parse() : '';
}
protected function determineNavRootFromReferer($strNavField, $skipRawReferer=false)
{
$HTTPReferer = (!$skipRawReferer) ? $this->Environment->httpReferer : $this->getReferer();
// We check the real HTTP referer first, as we might have multiple tabs open in
// this environment and therefore want to use the "real" referer.
if((!$skipRawReferer) && preg_match('#[\/?&]'.$strNavField.'#', $HTTPReferer))
{
$strRequest = str_replace($this->Environment->base, '', $HTTPReferer);
if(!$GLOBALS['TL_CONFIG']['disableAlias'])
{
$strRequest = preg_replace('/\?.*$/i', '', $strRequest);
$strRequest = preg_replace('/' . preg_quote($GLOBALS['TL_CONFIG']['urlSuffix'], '/') . '$/i', '', $strRequest);
$arrFragments = explode('/', $strRequest);
// Skip index.php
if (strtolower($arrFragments[0]) == 'index.php')
{
array_shift($arrFragments);
}
} else {
// TODO: handle disabled aliases here.
$arrFragments = array();
}
// skip page and search for our param.
for($i=1;$i<count($arrFragments);$i+=2)
{
if($arrFragments[$i]==$strNavField)
{
return $arrFragments[$i+1];
}
}
}
if(!$skipRawReferer)
{
return $this->determineNavRootFromReferer($strNavField, true);
}
}
/**
* Look up all needed stuff and then call the recursive function internalRenderCatalogNavigation
* @param integer
* @return string
*/
protected function renderCatalogNavigation($pid)
{
$this->arrTrail=array();
// get reference table and column
$objFields = $this->Database->prepare('SELECT * FROM tl_catalog_fields WHERE pid=? AND colName=?')
->limit(1)
->execute($this->catalog, $this->catalog_navigation);
if (!$objFields->numRows)
return '';
$this->objNavField = new stdClass();
$this->objNavField->id = $objFields->id;
$this->objNavField->sourceTable = $objFields->itemTable;
$this->objNavField->sourceColumn = $objFields->itemTableValueCol;
$this->objNavField->blnChildren = $objFields->childrenSelMode;
$this->objNavField->limitItems = $objFields->limitItems;
$this->objNavField->items = deserialize($objFields->items);
$this->objNavField->valueField = $this->getAliasField($this->objNavField->sourceTable);
$this->objNavField->type = $objFields->type;
// check if this tree has a pid or a flat table
$this->objNavField->treeView = $this->Database->fieldExists('pid', $this->objNavField->sourceTable);
$this->objNavField->sort = $this->Database->fieldExists('sorting', $this->objNavField->sourceTable) ? 'sorting' : $this->objNavField->sourceColumn;
// Determine the layout template
if (!strlen($this->navigationTpl))
{
$this->navigationTpl = 'nav_default';
}
// root is given via URL
if($this->Input->get($this->catalog_navigation))
{
$root=$this->Input->get($this->catalog_navigation);
}
// root not given via URL but we have an select field and an item is being requested.
else if($this->Input->get('items') && ($this->objNavField->type == 'select'))
{
// SELECT fields
$value=$this->Input->get('items');
$strAlias = $this->strAliasField ? $this->strAliasField : (is_numeric($value) ? 'id' : '');
if(strlen($strAlias))
{
$objItem = $this->Database->prepare('SELECT '.$this->objNavField->valueField.' AS alias FROM '. $this->objNavField->sourceTable. ' WHERE id=(SELECT '.$this->catalog_navigation.' FROM '.$this->strTable.' WHERE '.(!BE_USER_LOGGED_IN && $this->publishField ? $this->publishField.'=1 AND ' : ''). $strAlias . '=?)')
->limit(1)
->execute($value);
if ($objItem->numRows)
{
$root=$objItem->alias;
}
}
}
// no root via URL but an item requested, let's try to get the root from the referer.
else if($this->Input->get('items') && !$this->Input->get($this->catalog_navigation))
{
// check if in referer is something mentioned.
if(preg_match('#[\/?&]'.$this->catalog_navigation.'#', $this->Environment->httpReferer))
{
$root = $this->determineNavRootFromReferer($this->catalog_navigation);
}
}
if ($this->objNavField->treeView && $root)
{
// determine all parents
$objRoot = $this->Database->prepare('SELECT id,pid FROM '. $this->objNavField->sourceTable. ' WHERE '.$this->objNavField->valueField.'=?')
->limit(1)
->execute($root);
$parents=array($objRoot->id);
// root found, we can now find the parents.
while($objRoot->numRows && $objRoot->pid)
{
$parents[]=$objRoot->pid;
$objRoot = $this->Database->prepare('SELECT pid FROM '. $this->objNavField->sourceTable. ' WHERE id='.$objRoot->pid)
->limit(1)
->execute();
}
foreach(array_reverse($parents) as $k=>$v)
$this->arrTrail[$k+1]=$v;
}
if($this->levelOffset)
{
// start level specified but not in trail -> do not output
if(!$this->arrTrail[$this->levelOffset])
return '';
$pid = $this->arrTrail[$this->levelOffset];
}
return $this->internalRenderCatalogNavigation($pid, 1, $root);
}
/**
* List and generate comment form
* @param object
*/
public function processComments(Database_Result $objCatalog)
{
// Comments
$objArchive = $this->Database->prepare('SELECT * FROM tl_catalog_types WHERE id=?')
->limit(1)
->execute($objCatalog->pid);
if ($objArchive->numRows < 1 || !$objArchive->allowComments || !in_array('comments', $this->Config->getActiveModules()))
{
$this->Template->allowComments = false;
return;
}
$this->Template->allowComments = true;
$this->import('Comments');
$objConfig = new stdClass();
$objConfig->perPage = $objArchive->perPage;
$objConfig->order = $objArchive->sortOrder;
$objConfig->template = $objArchive->template;
$objConfig->requireLogin = $objArchive->requireLogin;
$objConfig->disableCaptcha = $objArchive->disableCaptcha;
$objConfig->bbcode = $objArchive->bbcode;
$objConfig->moderate = $objArchive->moderate;
// TODO: add notifies here.
$arrNotifies=array($GLOBALS['TL_ADMIN_EMAIL']);
// issue #1690 hide member details not working anymore.
if($objArchive->hideMember && ($this->Input->post('FORM_SUBMIT')=='com_'. $this->strTable .'_'. $objCatalog->id))
{
// we have to trick the comments module into beliving that the user inserted his name and email as those are hardcoded mandatory.
$this->import('FrontendUser', 'Member');
$this->Input->setPost('name', trim($this->Member->firstname . ' ' . $this->Member->lastname));
$this->Input->setPost('email', trim($this->Member->email));
}
$this->Comments->addCommentsToTemplate($this->Template, $objConfig, $this->strTable, $objCatalog->id, $arrNotifies);
if($objArchive->hideMember)
{
$fields = $this->Template->fields;
unset($fields['name']);
unset($fields['email']);
$this->Template->fields=$fields;
}
if($objArchive->disableWebsite)
{
$fields = $this->Template->fields;
unset($fields['website']);
$this->Template->fields=$fields;
}
}
}
?>
Noch ein Hinweis, wenn in den Ordnernamen wo die Bilder liegen Leerzeichen sind, verträgt es sich auch nicht mit dem Catalog.
lightbox mit catalog geht nicht mehr
Zitat von valentin
Lesezeichen