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', [':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', 'id', array_keys($ids)]);
return $this;
}
/**
* @return \common\widgets\yii2TranslatePanel\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', "id", array_keys($ids)])->andWhere(['not like', 'message', '@@']);
return $this;
}
