public static function getStatus2($id)
{
$langs = Yii::$app->components['i18n']['languages'];
$langlist = implode("','", $langs);
$langLen = sizeof($langs);
$messageTableName = Message::tableName();
$query = Message::findBySql("SELECT * FROM yii2_message WHERE language IN ('{$langlist}') AND id={$id} AND (TRIM(translation)<>'' AND translation IS NOT NULL)")->count('*');
return $query . "/" . $langLen;
}
public function translated()
{
$langs = Yii::$app->components['i18n']['languages'];
$langlist = implode("','", $langs);
$langLen = sizeof($langs);
$messageTableName = Message::tableName();
$query = Message::findBySql("\n SELECT yii2_source_message.*\n FROM yii2_source_message, yii2_message\n WHERE yii2_message.language IN ('{$langlist}') AND (TRIM(yii2_message.translation)='' OR yii2_message.translation IS NULL) AND yii2_source_message.id=yii2_message.id")->all();
$ids = [];
foreach ($query as $row) {
$ids[] = $row->id;
}
$this->andWhere("id NOT IN ('" . implode("','", $ids) . "')");
return $this;
}
/**
* @param array|null $params
* @return ActiveDataProvider
*/
public function search($params)
{
$query = SourceMessage::find()->joinWith('message');
$dataProvider = new ActiveDataProvider(['query' => $query]);
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
if ($this->status == static::STATUS_TRANSLATED) {
$query->translated();
}
if ($this->status == static::STATUS_NOT_TRANSLATED) {
$query->notTranslated();
}
$query->andFilterWhere(['like', 'category', $this->category])->andFilterWhere(['like', 'message', $this->message])->andFilterWhere(['like', Message::tableName() . '.translation', $this->translation]);
return $dataProvider;
}
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;
}
/**
* @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;
}
public function getMessage()
{
$firstLang = Yii::$app->getI18n()->languages[0];
return $this->hasOne(Message::className(), ['id' => 'id'])->where(['language' => $firstLang])->indexBy('language');
}
public function getMessages()
{
return $this->hasMany(Message::className(), ['id' => 'id'])->indexBy('language');
}
use Zelenin\yii\modules\I18n\Module;
$this->title = 'Переводы';
echo Breadcrumbs::widget(['links' => [$this->title]]);
?>
<div class="panel panel-default">
<div class="panel-heading">
<h3 class="panel-title"><?php
echo Html::encode($this->title);
?>
</h3>
</div>
<div class="panel-body">
<?php
Pjax::begin();
echo GridView::widget(['filterModel' => $searchModel, 'dataProvider' => $dataProvider, 'columns' => [['attribute' => 'id', 'value' => function ($model, $index, $dataColumn) {
return $model->id;
}, 'filter' => false], ['attribute' => 'message', 'format' => 'raw', 'value' => function ($model, $index, $widget) {
return Html::a($model->message, ['update', 'id' => $model->id], ['data' => ['pjax' => 0]]);
}], ['attribute' => 'translation', 'format' => 'raw', 'value' => function ($model, $index, $widget) {
return $model->getDefaultLangTranslation();
}], ['attribute' => 'category', 'value' => function ($model, $index, $dataColumn) {
return $model->category;
}, 'filter' => ArrayHelper::map($searchModel::getCategories(), 'category', 'category')], ['attribute' => 'status', 'value' => function ($model, $index, $widget) {
return \Zelenin\yii\modules\I18n\models\Message::isModelFullyTranslated($model->id) ? 'Переведено' : 'Не переведено';
}, 'filter' => Html::dropDownList($searchModel->formName() . '[status]', $searchModel->status, $searchModel->getStatus(), ['class' => 'form-control', 'prompt' => ''])]]]);
Pjax::end();
?>
</div>
</div>
public function actionFlush()
{
$tableNames = [Message::tableName(), SourceMessage::tableName()];
$db = Yii::$app->getDb();
foreach ($tableNames as $tableName) {
$db->createCommand()->delete($tableName)->execute();
}
echo PHP_EOL . 'Done.' . PHP_EOL;
}
/**
* @param array|null $params
* @return ActiveDataProvider
*/
public function search($params)
{
$query = SourceMessage::find();
$dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['id' => SORT_DESC]]]);
// check and populate params
if (!($this->load($params) && $this->validate())) {
$query->joinWith(['messages']);
return $dataProvider;
}
if ($this->status == static::STATUS_TRANSLATED) {
$query->joinWith(['messages']);
$query->translated();
}
if ($this->status == static::STATUS_NOT_TRANSLATED) {
$query->joinWith(['messages']);
$query->notTranslated();
}
if ($this->status == static::STATUS_DELETED) {
$query->joinWith(['messages']);
$query->deleted();
}
// search with related table
// @see http://www.yiiframework.com/wiki/621/filter-sort-by-calculated-related-fields-in-gridview-yii-2-0/
if (!empty($this->translation)) {
$query->joinWith(['messages' => function ($q) {
$q->where(['like', Message::tableName() . '.translation', $this->translation]);
}]);
}
$query->andFilterWhere(['like', 'category', $this->category])->andFilterWhere(['like', 'message', $this->message]);
return $dataProvider;
}
