Exemple #1
0
 /**
  * @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);
 }
Exemple #2
0
 public function _change()
 {
     parent::_change();
     $this->getItemsRaw();
     // eagerly refill the cache
 }