/**
* @param CM_Model_Language $language
* @param string|null $searchPhrase
* @param string|null $section
* @param bool|null $translated
*/
public function __construct(CM_Model_Language $language, $searchPhrase = null, $section = null, $translated = null)
{
$this->_language = $language;
$where = array();
$parameters = array();
if ($searchPhrase) {
$where[] = '(k.name LIKE ? OR v.value LIKE ?)';
$parameters[] = '%' . $searchPhrase . '%';
$parameters[] = '%' . $searchPhrase . '%';
}
if ($section) {
$where[] = 'k.name LIKE ?';
$parameters[] = $section . '%';
}
if ($translated === true) {
$where[] = 'v.value IS NOT NULL';
}
if ($translated === false) {
$where[] = 'v.value IS NULL';
}
$orderBy = 'k.name ASC';
$join = 'LEFT JOIN `cm_languageValue` AS v ON k.id = v.languageKeyId AND v.languageId = ' . $this->_language->getId() . ' ';
$groupBy = 'BINARY k.name';
$source = new CM_PagingSource_Sql_Deferred('k.name AS `key`, v.value, k.variables', 'cm_model_languagekey` as `k', implode(' AND ', $where), $orderBy, $join, $groupBy, $parameters);
parent::__construct($source);
}
public function _change()
{
parent::_change();
$this->getItemsRaw();
// eagerly refill the cache
}