Exemplos de Zelenin\yii\modules\I18n\models Message::find em PHP

Exemplo n.º 1

Arquivo: SourceMessageQuery.php Projeto: notgosu/yii2-i18n-module

 public function translated()
 {
     $messageTableName = Message::tableName();
     $query = Message::find()->select($messageTableName . '.id');
     $i = 0;
     foreach (Yii::$app->getI18n()->languages as $language) {
         if ($i === 0) {
             $query->andWhere($messageTableName . '.language = :language and ' . $messageTableName . '.translation is not null and ' . $messageTableName . '.translation <> ""', [':language' => $language]);
         } else {
             $query->innerJoin($messageTableName . ' t' . $i, 't' . $i . '.id = ' . $messageTableName . '.id and t' . $i . '.language = :language and t' . $i . '.translation is not null', [':language' => $language]);
         }
         $i++;
     }
     $ids = $query->indexBy('id')->all();
     $this->andWhere(['in', $messageTableName . '.id', array_keys($ids)]);
     return $this;
 }

Exemplo n.º 2

Arquivo: SourceMessageQuery.php Projeto: uran1980/yii2-translate-panel

 /**
  * @return \uran1980\yii\modules\i18n\models\query\SourceMessageQuery
  */
 public function translated()
 {
     $table = Message::tableName();
     $query = Message::find()->select("{$table}.id");
     $i = 0;
     foreach (Yii::$app->getI18n()->languages as $language) {
         if ($i === 0) {
             $query->andWhere("{$table}.language = :language and {$table}.translation is not null", [':language' => $language]);
         } else {
             $query->innerJoin("{$table} t{$i}", "t{$i}.id = {$table}.id and t{$i}.language = :language and t{$i}.translation is not null", [':language' => $language]);
         }
         $i++;
     }
     $ids = $query->indexBy('id')->all();
     $this->andWhere(['in', "{$table}.id", array_keys($ids)])->andWhere(['not like', 'message', '@@']);
     return $this;
 }