/** * Конструктор. * @param type $tableName - название таблицы локализатора. * @param type $langColumn - название столбца хранящего информацию о языке. * @param type $selectionColumn - название столбца по которому производится отбор данных. * @param type $selectionValue - значение столбца по которому производится отбор данных. * @param type $lang - язык. */ public function __construct($tableName, $langColumn, $selectionColumn, $selectionValue, $lang) { $query_ok = "select * from `Lang` as T1 left join `{$tableName}` as T2\n on T1.`lang` = T2.`{$langColumn}`\n where T1.`lang` = '{$lang}' and T2.`{$selectionColumn}` = '{$selectionValue}'\n limit 0, 1;"; $query_default = "select * from `Lang` as T1 left join `{$tableName}` as T2\n on T1.`lang` = T2.`{$langColumn}`\n where T1.`default` = '1' and T2.`{$selectionColumn}` = '{$selectionValue}' \n limit 0, 1;"; $query_else = "select * from `Lang` as T1 left join `{$tableName}` as T2\n on T1.`lang` = T2.`{$langColumn}`\n where T2.`{$selectionColumn}` = '{$selectionValue}'\n limit 0, 1;"; $this->data = null; $this->keys = null; $mySqlHelper1 = new MySqlHelper($query_ok); $this->data = $mySqlHelper1->getDataRow(0); $this->keys = $mySqlHelper1->getDataKeys(); if ($this->data != null && count($this->data) > 0) { $this->langType = 1; } else { $this->data = null; $this->keys = null; $mySqlHelper2 = new MySqlHelper($query_default); $this->data = $mySqlHelper2->getDataRow(0); $this->keys = $mySqlHelper2->getDataKeys(); if ($this->data != null && count($this->data) > 0) { $this->langType = 0; } else { $this->data = null; $this->keys = null; $mySqlHelper3 = new MySqlHelper($query_else); $this->data = $mySqlHelper3->getDataRow(0); $this->keys = $mySqlHelper3->getDataKeys(); if ($this->data != null && count($this->data) > 0) { $this->langType = 0; } else { $this->langType = -1; } } } }