/** * Creating _languageSources array. */ private function _createLanguageSource() { $languageSources = LanguageSource::find()->all(); foreach ($languageSources as $languageSource) { $this->_languageSources[$languageSource->category][$languageSource->message] = $languageSource->id; } }
/** * @param array $params Search conditions. * @return ActiveDataProvider */ public function search($params) { $translateLanguage = Yii::$app->request->get('language_id', Yii::$app->sourceLanguage); $sourceLanguage = $this->_getSourceLanguage(); $query = LanguageSource::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $dataProvider->setSort(['attributes' => ['id', 'category', 'message', 'translation' => ['asc' => ['lt.translation' => SORT_ASC], 'desc' => ['lt.translation' => SORT_DESC], 'label' => Yii::t('language', 'Translation')]]]); if (!($this->load($params) && $this->validate())) { $query->joinWith(['languageTranslate' => function ($query) use($translateLanguage) { $query->from(['lt' => LanguageTranslate::tableName()])->onCondition(['lt.language' => $translateLanguage]); }]); $query->joinWith(['languageTranslateByLanguage' => function ($query) use($sourceLanguage) { $query->from(['ts' => LanguageTranslate::tableName()])->onCondition(['ts.language' => $sourceLanguage]); }]); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'category' => $this->category]); $query->andFilterWhere(['or', $this->createLikeExpression('message', $this->message), $this->createLikeExpression('ts.translation', $this->message)]); $query->joinWith(['languageTranslate' => function ($query) use($translateLanguage) { $query->from(['lt' => LanguageTranslate::tableName()])->onCondition(['lt.language' => $translateLanguage])->andFilterWhere($this->createLikeExpression('lt.translation', $this->translation)); }]); $query->joinWith(['languageTranslateByLanguage' => function ($query) use($sourceLanguage) { $query->from(['ts' => LanguageTranslate::tableName()])->onCondition(['ts.language' => $sourceLanguage]); }]); return $dataProvider; }
/** * @return Array[] Generate a two dimensional array of the translation data for the exportLanguages: * * ~~~ * [ * 'languages' => [], * 'languageSources' => [], * 'languageTranslations' => [], * ] * ~~~ * */ public function getExportData() { $languages = Language::findAll($this->exportLanguages); $languageSources = LanguageSource::find()->all(); $languageTranslations = LanguageTranslate::findAll(['language' => $this->exportLanguages]); $data = ['languages' => $languages, 'languageSources' => $languageSources, 'languageTranslations' => $languageTranslations]; return $data; }
/** * Scanning project for text not stored in database. * @return integer The number of new language elements. */ public function scanning() { $this->_scanningProject(); $languageSources = LanguageSource::find()->all(); foreach ($languageSources as $languageSource) { if (isset($this->_languageItems[$languageSource->category][$languageSource->message])) { unset($this->_languageItems[$languageSource->category][$languageSource->message]); } } $languageSource = new LanguageSource(); return $languageSource->insertLanguageItems($this->_languageItems); }
public function search($params) { $this->_languageId = $params['language_id']; $query = LanguageSource::find()->with(['languageTranslate' => function ($query) { $query->andWhere(['language' => $this->_languageId]); }]); $dataProvider = new ActiveDataProvider(['query' => $query]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['id' => $this->id]); $query->andFilterWhere(['like', 'category', $this->category])->andFilterWhere(['like', 'message', $this->message]); return $dataProvider; }
/** * Returns an ArrayDataProvider consisting of language elements. * @param array $languageSourceIds * @return ArrayDataProvider */ private function _createLanguageSourceDataProvider($languageSourceIds) { $languageSources = LanguageSource::find()->with('languageTranslates')->where(['id' => $languageSourceIds])->all(); $data = []; foreach ($languageSources as $languageSource) { $languages = []; if ($languageSource->languageTranslates) { foreach ($languageSource->languageTranslates as $languageTranslate) { $languages[] = $languageTranslate->language; } } $data[] = ['id' => $languageSource->id, 'category' => $languageSource->category, 'message' => $languageSource->message, 'languages' => implode(', ', $languages)]; } return new ArrayDataProvider(['allModels' => $data, 'pagination' => false]); }
/** * @param array $params Search conditions. * @return ActiveDataProvider */ public function search($params) { Yii::$app->session->setFlash('TM-language__id', $params['language_id']); $query = LanguageSource::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $dataProvider->setSort(['attributes' => ['id', 'category', 'message', 'translation' => ['asc' => ['translation' => SORT_ASC], 'desc' => ['translation' => SORT_DESC], 'label' => Yii::t('language', 'Translation')]]]); if (!($this->load($params) && $this->validate())) { $query->joinWith('languageTranslateByLanguage'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'category' => $this->category]); $query->andFilterWhere(['like', 'lower(message)', mb_strtolower($this->message, 'UTF-8')]); $query->joinWith(['languageTranslateByLanguage' => function ($query) { if ($this->translation) { $searchEmptyCommand = \Yii::$app->controller->module->searchEmptyCommand; if ($searchEmptyCommand && $this->translation == $searchEmptyCommand) { $query->andWhere(['or', ['translation' => null], ['translation' => '']]); } else { $query->andWhere(['like', 'lower(translation)', mb_strtolower($this->translation, 'UTF-8')]); } } }]); return $dataProvider; }
/** * Returns the completness of a given translation (language). * @return integer */ public function getGridStatistic() { static $statistics; if (!$statistics) { $count = LanguageSource::find()->count(); if ($count == 0) { return 0; } $languageTranslates = LanguageTranslate::find()->select(['language', 'COUNT(*) AS cnt'])->where('translation IS NOT NULL AND translation != \'\'')->groupBy(['language'])->all(); foreach ($languageTranslates as $languageTranslate) { $statistics[$languageTranslate->language] = floor($languageTranslate->cnt / $count * 100); } } return isset($statistics[$this->language_id]) ? $statistics[$this->language_id] : 0; }
/** * Import the uploaded file. Existing languages and translations will be updated, new ones will be created. * Source messages won't be updated, only created if they not exist. * @return array * @throws BadRequestHttpException * @throws Exception */ public function import() { $result = ['languages' => ['new' => 0, 'updated' => 0], 'languageSources' => ['new' => 0, 'updated' => 0], 'languageTranslations' => ['new' => 0, 'updated' => 0]]; $data = $this->parseImportFile(); /** @var Language[] $languages */ $languages = Language::find()->indexBy('language_id')->all(); foreach ($data['languages'] as $importedLanguage) { if (isset($languages[$importedLanguage['language_id']])) { $language = $languages[$importedLanguage['language_id']]; } else { $language = new Language(); } //cast integers $importedLanguage['status'] = (int) $importedLanguage['status']; $language->attributes = $importedLanguage; if (count($language->getDirtyAttributes())) { $saveType = $language->isNewRecord ? 'new' : 'updated'; if ($language->save()) { $result['languages'][$saveType]++; } else { $this->throwInvalidModelException($language); } } } /** @var LanguageSource[] $languageSources */ $languageSources = LanguageSource::find()->indexBy('id')->all(); /** @var LanguageTranslate[] $languageTranslations */ $languageTranslations = LanguageTranslate::find()->all(); /* * Create 2 dimensional array for current and imported translation, first index by LanguageSource->id * and than indexed by LanguageTranslate->language. * E.g.: [ * id => [ * language => LanguageTranslate (for $languageTranslations) / Array (for $importedLanguageTranslations) * ... * ] * ... * ] */ $languageTranslations = ArrayHelper::map($languageTranslations, 'language', function ($languageTranslation) { return $languageTranslation; }, 'id'); $importedLanguageTranslations = ArrayHelper::map($data['languageTranslations'], 'language', function ($languageTranslation) { return $languageTranslation; }, 'id'); foreach ($data['languageSources'] as $importedLanguageSource) { $languageSource = null; //check if id exist and if category and messages are matching if (isset($languageSources[$importedLanguageSource['id']]) && $languageSources[$importedLanguageSource['id']]->category == $importedLanguageSource['category'] && $languageSources[$importedLanguageSource['id']]->message == $importedLanguageSource['message']) { $languageSource = $languageSources[$importedLanguageSource['id']]; } if (is_null($languageSource)) { //no match by id, search by message foreach ($languageSources as $languageSourceSearch) { if ($languageSourceSearch->category == $importedLanguageSource['category'] && $languageSourceSearch->message == $importedLanguageSource['message']) { $languageSource = $languageSourceSearch; break; } } } if (is_null($languageSource)) { //still no match, create new $languageSource = new LanguageSource(['category' => $importedLanguageSource['category'], 'message' => $importedLanguageSource['message']]); if ($languageSource->save()) { $result['languageSources']['new']++; } else { $this->throwInvalidModelException($languageSource); } } //do we have translations for the current source? if (isset($importedLanguageTranslations[$importedLanguageSource['id']])) { //loop through the translations for the current source foreach ($importedLanguageTranslations[$importedLanguageSource['id']] as $importedLanguageTranslation) { $languageTranslate = null; //is there already a translation for this souce if (isset($languageTranslations[$languageSource->id]) && isset($languageTranslations[$languageSource->id][$importedLanguageTranslation['language']])) { $languageTranslate = $languageTranslations[$languageSource->id][$importedLanguageTranslation['language']]; } //no translation found, create a new one if (is_null($languageTranslate)) { $languageTranslate = new LanguageTranslate(); } $languageTranslate->attributes = $importedLanguageTranslation; //overwrite the id because the $languageSource->id might be different from the $importedLanguageTranslation['id'] $languageTranslate->id = $languageSource->id; if (count($languageTranslate->getDirtyAttributes())) { $saveType = $languageTranslate->isNewRecord ? 'new' : 'updated'; if ($languageTranslate->save()) { $result['languageTranslations'][$saveType]++; } else { $this->throwInvalidModelException($languageTranslate); } } } } } return $result; }
/** * Returns the category of LanguageSource in an associative array. * @return array */ public static function getCategories() { $languageSources = \lajax\translatemanager\models\LanguageSource::find()->select('category')->distinct()->all(); $categories = []; foreach ($languageSources as $languageSource) { $categories[$languageSource->category] = $languageSource->category; } return $categories; }
/** * Initialising $_languageItems and $_removableLanguageSourceIds arrays. */ private function _initLanguageArrays() { $this->_scanningProject(); $languageSources = LanguageSource::find()->all(); foreach ($languageSources as $languageSource) { if (isset($this->_languageElements[$languageSource->category][$languageSource->message])) { unset($this->_languageElements[$languageSource->category][$languageSource->message]); } else { $this->_removableLanguageSourceIds[$languageSource->id] = $languageSource->id; } } }
/** * Loads language elements in JavaScript category. */ private function _loadLanguageItems() { $this->_languageItems = LanguageSource::find()->joinWith(['languageTranslate' => function ($query) { $query->where(['language' => $this->_languageId]); }])->where(['category' => Scanner::CATEGORY_JAVASCRIPT])->all(); }
/** * Saveing new language element by category. * @param string $message Language element save in database. * @param string $category the message category. */ public static function saveMessage($message, $category = 'database') { $languageSources = \lajax\translatemanager\models\LanguageSource::find()->where(['category' => $category])->all(); $messages = []; foreach ($languageSources as $languageSource) { $messages[$languageSource->message] = $languageSource->id; } if (empty($messages[$message])) { $languageSource = new \lajax\translatemanager\models\LanguageSource(); $languageSource->category = $category; $languageSource->message = $message; $languageSource->save(); } }
/** * Returns the completness of a given translation (language). * @return integer */ public function getGridStatistic() { static $statistics; if (!$statistics) { $count = LanguageSource::find()->count(); if ($count == 0) { return 0; } $languages = Language::find()->select('language_id, COUNT(`lt`.`id`) AS `status`')->leftJoin(LanguageTranslate::tableName() . ' AS `lt`', '`language`.`language_id` = `lt`.`language`')->groupBy('language_id')->all(); foreach ($languages as $language) { $statistics[$language->language_id] = round($language->status / $count, 2) * 100; } } return isset($statistics[$this->language_id]) ? $statistics[$this->language_id] : 0; }
/** * Loads language elements in JavaScript category. */ private function _getLanguageItems() { $this->_languageItems = LanguageSource::find()->joinWith(['languageTranslate' => function ($query) { $query->where('language_translate.language = :language', [':language' => $this->_languageId]); }])->where('`category` = :category', [':category' => 'javascript'])->all(); }