Yii2-advanced：Redisのソースで国際化を行う

  return [ 'color' => null, 'interactive' => true, 'help' => null, 'sourcePath' => __DIR__. '..' . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR, 'languages' => ['ru-RU','uk-UA','en-US'],//    'translator' => 'Yii::t', 'sort' => false, 'overwrite' => true, 'removeUnused' => false, 'markUnused' => true, 'except' => [ '.svn', '.git', '.gitignore', '.gitkeep', '.hgignore', '.hgkeep', '/messages', '/BaseYii.php', ], 'only' => [ '*.php', ], 'format' => 'db', 'db' => 'db', //'messageTable' => '{{%message}}', //       gr_dictionary 'sourceMessageTable' => '{{%gr_dictionary}}',//   'ignoreCategories' => ['yii'], ];
      
      

        
        
        
      

    
        
        
        
      
      

        
        
        
      

    
     

 CREATE TABLE IF NOT EXISTS `gr_language` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY, `code_lang` varchar(255) NOT NULL, `local` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `status` tinyint(4) NOT NULL DEFAULT '1', UNIQUE KEY `code_lang` (`code_lang`), UNIQUE KEY `local` (`local`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO `gr_language` (`id`, `code_lang`, `local`, `name`, `status`) VALUES (1, 'en', 'en-US', 'English', 1), (2, 'ru', 'ru-RU', '', 1), (3, 'uk', 'uk-UA', 'ї', 1);
      
      

        
        
        
      

    
        
        
        
      
      

        
        
        
      

    
     

  --    CREATE TABLE IF NOT EXISTS `gr_dictionary_keys` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY, `key` varchar(250) NOT NULL, UNIQUE KEY `id` (`id`), KEY `key` (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
      
      

        
        
        
      

    
        
        
        
      
      

        
        
        
      

    
     

 --    CREATE TABLE IF NOT EXISTS `gr_dictionary` ( `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, `language_id` smallint(5) unsigned NOT NULL, `key` int(10) unsigned NOT NULL, `value` varchar(255) NOT NULL COMMENT '', `translator` text NOT NULL COMMENT '', `type` set('w','m') DEFAULT NULL COMMENT 'w/m /', `status` tinyint(4) NOT NULL DEFAULT '1', CONSTRAINT `gr_dictionary_ibfk_1` FOREIGN KEY (`language_id`) REFERENCES `gr_language` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `gr_dictionary_ibfk_2` FOREIGN KEY (`key`) REFERENCES `gr_dictionary_keys` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, UNIQUE KEY `language_id` (`language_id`,`key`,`type`), KEY `code_lang` (`language_id`), KEY `type` (`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
      
      

        
        
        
      

    
        
        
        
      
      

        
        
        
      

    
     

 namespace console\controllers; use Yii; use yii\console\Exception; class Message2Controller extends \yii\console\controllers\MessageController { /** * Saves messages to database * * @param array $messages     [[]=>[[],[...]] ,... ] * @param \yii\db\Connection $db * @param string $sourceMessageTable     * @param string $messageTable   * @param boolean $removeUnused * @param array $languages    languages  i18n.php ['ru-RU',...] * @param boolean $markUnused */ protected function saveMessagesToDb($messages, $db, $sourceMessageTable, $messageTable, $removeUnused, $languages, $markUnused) { try{ $pr_iskey=Yii::$app->db->createCommand("SELECT `id` FROM `gr_dictionary_keys` WHERE `key`=:key"); $pr_inskey=Yii::$app->db->createCommand("INSERT INTO `gr_dictionary_keys`( `key`) VALUES (:key)"); $pr_delkey=Yii::$app->db->createCommand("DELETE FROM `gr_dictionary_keys` WHERE `id`=:id"); $id_lang=[]; $pr_l=Yii::$app->db->createCommand("SELECT SQL_NO_CACHE id FROM gr_language WHERE local=:local LIMIT 1"); foreach ($languages as $language) { if(!isset($id_lang[$language])){ $id_language=(int)$pr_l->bindValue(":local", $language,2)->queryScalar(); if(empty($id_language)){ continue; // throw new Exception("Unknow lang type $language"); } $id_lang[$language]=(int)$id_language; } } if(empty($id_lang))throw new Exception("empty lang"); //ALTER TABLE `yii2advanced`.`gr_dictionary` ADD UNIQUE (`language_id`, `key`, `type`); $pr_d=Yii::$app->db->createCommand("INSERT IGNORE INTO `gr_dictionary`( `language_id`, `key`, `value`, `type`) VALUES (:language_id,:key,:value,:type)"); foreach ($messages as $category => $msgs){ list($type,$key)=explode(":", $category); if(empty($id=$pr_iskey->bindValue(":key", $key,2)->queryScalar())){ $pr_inskey->bindValue(":key", $key,2)->execute(); $id=Yii::$app->db->lastInsertID; } foreach ($id_lang as $id_language) { $pr_d->bindValue(":language_id", $id_language,1) ->bindValue(":key", $id,1) ->bindValue(":value", $msgs[0],2) ->bindValue(":type", $type,2) ->execute(); } } //     status=1 (   ) $query=Yii::$app->db->createCommand("SELECT SQL_NO_CACHE dk.`id`,CONCAT(d.`type`,':',dk.`key`) as 'key_' FROM `gr_dictionary` d,gr_dictionary_keys dk WHERE d.`key`=dk.id AND status=1")->query(); //$pr_del=Yii::$app->db->createCommand("DELETE FROM `gr_dictionary` WHERE `key`=:key"); while(($data=$query->read())!=false){ if(array_key_exists($data['key_'], $messages)===false){ //$pr_del->bindValue(":key", $data['id'],1)->execute(); $pr_delkey->bindValue(":id", $data['id'],1)->execute(); } } Yii::$app->db->createCommand("ALTER TABLE gr_dictionary AUTO_INCREMENT = 1;")->execute(); }catch (\Exception $e){ //   } } }
      
      

        
        
        
      

    
        
        
        
      
      

        
        
        
      

    
     

  ... 'language'=> 'ru-RU', 'sourceLanguage' => 'en-US', 'components' => [ 'i18n' => [ 'translations' => [ '*' => [ 'class' => 'common\models\AltDbMessageSource', //   yii\i18n\DbMessageSource ], ], ], 'lng' => [ 'class' => '\common\components\LanguageExtension', ], ...
      
      

        
        
        
      

    
        
        
        
      
      

        
        
        
      

    
     

 namespace common\models; use Yii; class AltDbMessageSource extends \yii\i18n\MessageSource { public $sourceLanguage; public function init() { parent::init(); if ($this->sourceLanguage === null) { $this->sourceLanguage = Yii::$app->sourceLanguage; } } protected function translateMessage($category, $message, $language) { /*    (w:key)         lng    w  m    ,          . */ list($type,) = explode(":",$category); return Yii::$app->lng->$type($category); } public function translate($category, $message, $language) { if ( $language !== $this->sourceLanguage ) { return $this->translateMessage($category, $message, $language); } else { return false; } } }
      
      

        
        
        
      

    
        
        
        
      
      

        
        
        
      

    
     

 namespace common\components\extensions; use Yii; use common\components\exceptions\LanguageException; use yii\db\Exception; use PDO; /** * Class LanguageExtension * @package common\components\extensions * : *   *   redis */ class LanguageExtension extends \yii\base\Object { private $language; //   -   ru private $w = []; //   private $m = []; //   private $storageConnection; //     private $storageStatus; //     private $numbDb; //  redis private $default_key; //    private $expire; public function __construct() { try{ $this->expire = Yii::$app->params['secretKeyExpire']??(60 * 60 * 60); $this->language = \Yii::$app->language; $language=LanguageExtension::currentLang(); if(!empty($language)){ if($this->idKeyLang($language)) { $this->language= $language; } } $this->numbDb=Yii::$app->params['redisLangDB']??11; $this->storageStatus = false; $this->default_key= $this->language.":index"; $this->storageConnection = new \yii\redis\Connection([ 'hostname' => Yii::$app->params['redisHost'], // 'password' => '', 'port' => 6379, 'database' => $this->numbDb, ]); if(empty($this->language)) throw new LanguageException("not default language",0); $this->init(); }catch ( LanguageException $event){ // echo $event->getMessage(); }catch ( \yii\db\Exception $event){ $this->init(); }catch (\Exception $event){ // echo $event->getMessage(); } } public function __destruct() { try{ if($this->storageConnection->isActive) $this->storageConnection->close(); }catch (\Exception $event){ } } /** *  . *  .      . *     . */ public function init(){ try{ $this->storageConnection->open(); //     redis if(!$this->isFullData()){ //   mysql    redis $this->loadRedis(); } $this->storageStatus = true; } catch ( \yii\db\Exception $event) { $this->storageStatus = false; //  . //     $w  $m     . $this->loadVariable(); } } public static function currentLang(){ try{ $language = isset($_COOKIE['userLang']) ? $_COOKIE['userLang'] : null; if(!$language && Yii::$app->session->has('userLang')) { $language = Yii::$app->session('userLang'); } if(empty($language))$language=\Yii::$app->language; return $language; } catch (\Exception $e){ print_r($e->getMessage());exit; } } private function idKeyLang(string $key){ if(!empty($key)){ return Yii::$app->db->createCommand("SELECT `id` FROM `gr_language` WHERE local=:local") ->bindValue(":local", $key,PDO::PARAM_STR) ->queryScalar(); } return false; } /** * @param string $type * @param string $key * @return string *   */ private function getKeyMD5(string $type,string $key):string { return $this->language.":".$type.":".md5($key); } /** * @return bool *     */ private function loadVariable():bool{ try{ //  . //     $w  $m     . $language_id=$this->idKeyLang($this->language); $res=\Yii::$app->db->createCommand("SELECT d.`type`,d.`value`,d.`translator`, dk.`key` FROM `gr_dictionary` d,gr_dictionary_keys dk WHERE d.`key`=dk.id AND d.language_id=:language_id") ->bindValue(":language_id", $language_id,PDO::PARAM_INT)->query(); $this->w=$this->m=[]; while(($data=$res->read())!=false){ if(method_exists($this, $data['type'])){ $this->{$data['type']}[$this->getKeyMD5($data['type'],$data['key'])]=$data['translator']; } } return true; }catch (\Exception $event){ echo $event->getLine()."|".$event->getMessage();exit; return false; } } /** * @return bool *    redis  mysql ( ) */ private function loadRedis():bool{ try{ $language_id=$this->idKeyLang($this->language); $res=\Yii::$app->db->createCommand("SELECT d.`type`,dk.`key`, d.`value`,d.`translator` FROM `gr_dictionary` d,gr_dictionary_keys dk WHERE d.`key`=dk.id AND d.language_id=:language_id") ->bindValue(":language_id", $language_id,PDO::PARAM_INT)->query(); $this->storageConnection->executeCommand('SETEX', [ "KEY" => $this->default_key,"SECONDS"=>$this->expire,"VALUE"=> "1"]); while(($data=$res->read())!=false){ $this->storageConnection->executeCommand('SETEX', ["KEY" => $this->getKeyMD5($data['type'],$data['key']),"SECONDS"=>$this->expire,"VALUE"=> $data['translator']]); } if(empty($this->storageConnection->executeCommand('LASTSAVE', [] ))) $this->storageConnection->executeCommand('BGSAVE', [] ); return true; }catch (\Exception $event){ echo $event->getMessage();exit; } } /** *  Redis */ public function flushdb(){ try{ if($this->storageConnection->isActive) $this->storageConnection->executeCommand('FLUSHDB'); else { $this->w=[]; $this->m=[]; } }catch (\Exception $event){ } } /** * @return bool *    redis         */ private function isFullData():bool { try{ $res= $this->storageConnection->executeCommand('INFO', [ ] ); preg_match("/.*db$this->numbDb:keys=([\d])*.*?/uis",$res,$arr); if(isset($arr[1]) && $arr[1]>1){ return $this->exists($this->default_key); } return false; }catch (\Exception $event){ echo $event->getMessage(); return false; } } /** * @param string $key * @return string *         */ public function w(string $key) : string { return $this->getKeyValue($key, 'w'); } /** * @param string $key * @return string *         */ public function m(string $key) : string { return $this->getKeyValue($key, 'm'); } /** * @param string $key * @param string $type * @return string *    *  .      -. */ private function getKeyValue ( string &$key, string $type ) : string { try{ if(!$key=trim($key)) throw new LanguageException("Error dictionary ".addslashes($key).". The ".addslashes($key)." can not be empty or contain only whitespace.", 777001); if($this->storageStatus) $value = $this->storageConnection->executeCommand("GET",["KEY" =>$this->getKeyMD5($type,$key)]); else{ $value = @$this->$type[$this->getKeyMD5($type,$key)]; } /*   if(!$value){ if ($this->hasEventHandlers(\yii\i18n\MessageSource::EVENT_MISSING_TRANSLATION)) { $event = new \yii\i18n\MissingTranslationEvent([ 'category' => $key, 'message' => $key, 'language' => $this->language, ]); $this->trigger(\yii\i18n\MessageSource::EVENT_MISSING_TRANSLATION, $event); } }*/ return $value ? $value : $key; }catch (\Exception $event){ return $key; } } /** * @param $key * @return bool *   */ public function del($key):bool{ try{ if($this->storageConnection->isActive){ return $this->storageConnection->executeCommand("DEL",["KEY" =>$key]);// keys test:1:v }else{ list($lang_key,$type,$key_)= explode(":", $key); if(method_exists($this, $type) && isset($this->$type[$key_])){ unset($this->$type[$key_]); return true; } return false; } }catch (\Exception $event){ return false; } } /** * @param string $lang_key * @param null $type * @return bool *         */ public function delAll(string $lang_key,$type=null){ try{ if($this->storageConnection->isActive){ $keys= $this->keys($lang_key,$type); if(!empty($keys)){ foreach ($keys as $key){ $this->del($key); } if($type==null) $this->del($lang_key.":index"); } }else{ $this->w=$this->m=[]; return true; } }catch (\Exception $event){ return false; } } /** * @param $type * @param $key * @return array *     */ public function keys(string $lang_key,$type=null):array{ try{ if($this->storageConnection->isActive){ if($type!=null) return $this->storageConnection->executeCommand("KEYS",["KEY" => $lang_key.":".$type.":*"]); else return $this->storageConnection->executeCommand("KEYS",["KEY" => $lang_key.":*"]); }else{ if($type!=null){ return $this->w+$this->m; }else{ if(method_exists($this, $type))return $this->$type; } return []; } }catch (\Exception $event){ return []; } } /** * @param $type * @param $key * @return bool *    */ public function exists($key):bool{ try{ if($this->storageConnection->isActive){ return $this->storageConnection->executeCommand("EXISTS",["KEY" =>$key]); }else{ // return (method_exists($this, $type) && isset($this->$type[$key])); list($lang_key,$type,$key_)= explode(":", $key); if(method_exists($this, $type))return isset($this->$type[$key_]); return false; } return false; }catch (\Exception $event){ return false; } } }
      
      

        
        
        
      

    
        
        
        
      
      

        
        
        
      

    
     

 namespace frontend\widgets\WLang; use frontend\models\Lang; use Yii; use PDO; class WLang extends \yii\bootstrap\Widget { public function init(){} public function run() { return $this->render('index', [ 'current' => \common\components\LanguageExtension::currentLang(), 'default' => \Yii::$app->db->createCommand("SELECT `id`, `code_lang`, `local`, `name`, `default_lang`, `status` FROM `gr_language` WHERE local=:local LIMIT 1")->bindValue(":local",\common\components\LanguageExtension::currentLang(),PDO::PARAM_STR)->queryOne(PDO::FETCH_OBJ), 'langs' =>\Yii::$app->db->createCommand("SELECT `id`, `code_lang`, `local`, `name`, `status` FROM `gr_language` WHERE 1")->queryAll(PDO::FETCH_OBJ), ]); } } <div> <?php use yii\helpers\Html; ?> <script> function click_(el) { var lang = $(el).attr('data-lang'); var date = new Date; date.setDate(date.getDate() + 1); document.cookie = "userLang=" + lang + "; path=/; expires=" + date.toUTCString() + ";"; location.reload(); } </script> <div id="lang"> <span id="current-lang"> <span class="show-more-lang" >  <?= $current;?></span> </span> <ul id="langs"> <?php foreach ($langs as $lang):?> <li class="item-lang"><a href="#" onclick="click_(this)" data-lang="<?=$lang->local?>"><?=$lang->code_lang?></a></li> <?php endforeach;?> </ul> </div> </div>