Language prefix in OpenCart 2.3
We have a bilingual site on OpenCart 2.3 (NOT ocstore). Ukrainian is set as the second language. There was a bit of nakolhozheniya with seo_pro and the language prefix was added "manually", because of which some pages did not understand this prefix and in the Ukrainian version they were redirected to the Russian-language main page.
First of all, we will "clear" the seo-pro file before the drain. In the catalog / controller / startup / seo_pro.php file, change the content to the following
<?php
class ControllerStartupSeoPro extends Controller {
private $cache_data = null;
public function __construct($registry) {
parent::__construct($registry);
$this->cache_data = $this->cache->get('seo_pro');
if (!$this->cache_data) {
$query = $this->db->query("SELECT LOWER(`keyword`) as 'keyword', `query` FROM " . DB_PREFIX . "url_alias ORDER BY url_alias_id");
$this->cache_data = array();
foreach ($query->rows as $row) {
if (isset($this->cache_data['keywords'][$row['keyword']])){
$this->cache_data['keywords'][$row['query']] = $this->cache_data['keywords'][$row['keyword']];
continue;
}
$this->cache_data['keywords'][$row['keyword']] = $row['query'];
$this->cache_data['queries'][$row['query']] = $row['keyword'];
}
$this->cache->set('seo_pro', $this->cache_data);
}
}
public function index() {
// Add rewrite to url class
if ($this->config->get('config_seo_url')) {
$this->url->addRewrite($this);
} else {
return;
}
// Decode URL
if (!isset($this->request->get['_route_'])) {
$this->validate();
} else {
$route_ = $route = $this->request->get['_route_'];
unset($this->request->get['_route_']);
$parts = explode('/', trim(utf8_strtolower($route), '/'));
list($last_part) = explode('.', array_pop($parts));
array_push($parts, $last_part);
$rows = array();
foreach ($parts as $keyword) {
if (isset($this->cache_data['keywords'][$keyword])) {
$rows[] = array('keyword' => $keyword, 'query' => $this->cache_data['keywords'][$keyword]);
}
}
if (isset($this->cache_data['keywords'][$route])){
$keyword = $route;
$parts = array($keyword);
$rows = array(array('keyword' => $keyword, 'query' => $this->cache_data['keywords'][$keyword]));
}
if (count($rows) == sizeof($parts)) {
$queries = array();
foreach ($rows as $row) {
$queries[utf8_strtolower($row['keyword'])] = $row['query'];
}
reset($parts);
foreach ($parts as $part) {
if(!isset($queries[$part])) return false;
$url = explode('=', $queries[$part], 2);
if ($url[0] == 'category_id') {
if (!isset($this->request->get['path'])) {
$this->request->get['path'] = $url[1];
} else {
$this->request->get['path'] .= '_' . $url[1];
}
} elseif (count($url) > 1) {
$this->request->get[$url[0]] = $url[1];
}
}
} else {
$this->request->get['route'] = 'error/not_found';
}
if (isset($this->request->get['product_id'])) {
$this->request->get['route'] = 'product/product';
if (!isset($this->request->get['path'])) {
$path = $this->getPathByProduct($this->request->get['product_id']);
if ($path) $this->request->get['path'] = $path;
}
} elseif (isset($this->request->get['path'])) {
$this->request->get['route'] = 'product/category';
} elseif (isset($this->request->get['manufacturer_id'])) {
$this->request->get['route'] = 'product/manufacturer/info';
} elseif (isset($this->request->get['information_id'])) {
$this->request->get['route'] = 'information/information';
} elseif(isset($this->cache_data['queries'][$route_])) {
header($this->request->server['SERVER_PROTOCOL'] . ' 301 Moved Permanently');
$this->response->redirect($this->cache_data['queries'][$route_]);
} else {
if (isset($queries[$parts[0]])) {
$this->request->get['route'] = $queries[$parts[0]];
}
}
$this->validate();
if (isset($this->request->get['route'])) {
return new Action($this->request->get['route']);
}
}
}
public function rewrite($link) {
if (!$this->config->get('config_seo_url')) return $link;
$seo_url = '';
$component = parse_url(str_replace('&', '&', $link));
$data = array();
parse_str($component['query'], $data);
$route = $data['route'];
unset($data['route']);
switch ($route) {
case 'product/product':
if (isset($data['product_id'])) {
$tmp = $data;
$data = array();
if ($this->config->get('config_seo_url_include_path')) {
$data['path'] = $this->getPathByProduct($tmp['product_id']);
if (!$data['path']) return $link;
}
$data['product_id'] = $tmp['product_id'];
if (isset($tmp['tracking'])) {
$data['tracking'] = $tmp['tracking'];
}
}
break;
case 'product/category':
if (isset($data['path'])) {
$category = explode('_', $data['path']);
$category = end($category);
$data['path'] = $this->getPathByCategory($category);
if (!$data['path']) return $link;
}
break;
case 'product/product/review':
case 'information/information/info':
return $link;
break;
default:
break;
}
if ($component['scheme'] == 'https') {
$link = $this->config->get('config_ssl');
} else {
$link = $this->config->get('config_url');
}
$link .= 'index.php?route=' . $route;
if (count($data)) {
$link .= '&' . urldecode(http_build_query($data, '', '&'));
}
$queries = array();
if(!in_array($route, array('product/search'))) {
foreach($data as $key => $value) {
switch($key) {
case 'product_id':
case 'manufacturer_id':
case 'category_id':
case 'information_id':
case 'order_id':
$queries[] = $key . '=' . $value;
unset($data[$key]);
$postfix = 1;
break;
case 'path':
$categories = explode('_', $value);
foreach($categories as $category) {
$queries[] = 'category_id=' . $category;
}
unset($data[$key]);
break;
default:
break;
}
}
}
if(empty($queries)) {
$queries[] = $route;
}
$rows = array();
foreach($queries as $query) {
if(isset($this->cache_data['queries'][$query])) {
$rows[] = array('query' => $query, 'keyword' => $this->cache_data['queries'][$query]);
}
}
if(count($rows) == count($queries)) {
$aliases = array();
foreach($rows as $row) {
$aliases[$row['query']] = $row['keyword'];
}
foreach($queries as $query) {
$seo_url .= '/' . rawurlencode($aliases[$query]);
}
}
if ($seo_url == '') return $link;
$seo_url = trim($seo_url, '/');
if ($component['scheme'] == 'https') {
$seo_url = $this->config->get('config_ssl') . $seo_url;
} else {
$seo_url = $this->config->get('config_url') . $seo_url;
}
if (isset($postfix)) {
$seo_url .= trim($this->config->get('config_seo_url_postfix'));
} else {
$seo_url .= '/';
}
if(substr($seo_url, -2) == '//') {
$seo_url = substr($seo_url, 0, -1);
}
if (count($data)) {
$seo_url .= '?' . urldecode(http_build_query($data, '', '&'));
}
return $seo_url;
}
private function getPathByProduct($product_id) {
$product_id = (int)$product_id;
if ($product_id < 1) return false;
static $path = null;
if (!isset($path)) {
$path = $this->cache->get('product.seopath');
if (!isset($path)) $path = array();
}
if (!isset($path[$product_id])) {
$query = $this->db->query("SELECT category_id FROM " . DB_PREFIX . "product_to_category WHERE product_id = '" . $product_id . "' ORDER BY main_category DESC LIMIT 1");
$path[$product_id] = $this->getPathByCategory($query->num_rows ? (int)$query->row['category_id'] : 0);
$this->cache->set('product.seopath', $path);
}
return $path[$product_id];
}
private function getPathByCategory($category_id) {
$category_id = (int)$category_id;
if ($category_id < 1) return false;
static $path = null;
if (!isset($path)) {
$path = $this->cache->get('category.seopath');
if (!isset($path)) $path = array();
}
if (!isset($path[$category_id])) {
$max_level = 10;
$sql = "SELECT CONCAT_WS('_'";
for ($i = $max_level-1; $i >= 0; --$i) {
$sql .= ",t$i.category_id";
}
$sql .= ") AS path FROM " . DB_PREFIX . "category t0";
for ($i = 1; $i < $max_level; ++$i) {
$sql .= " LEFT JOIN " . DB_PREFIX . "category t$i ON (t$i.category_id = t" . ($i-1) . ".parent_id)";
}
$sql .= " WHERE t0.category_id = '" . $category_id . "'";
$query = $this->db->query($sql);
$path[$category_id] = $query->num_rows ? $query->row['path'] : false;
$this->cache->set('category.seopath', $path);
}
return $path[$category_id];
}
private function validate() {
if (isset($this->request->get['route']) && $this->request->get['route'] == 'error/not_found') {
return;
}
if (ltrim($this->request->server['REQUEST_URI'], '/') =='sitemap.xml') {
$this->request->get['route'] = 'feed/google_sitemap';
return;
}
if(empty($this->request->get['route'])) {
$this->request->get['route'] = 'common/home';
}
if (isset($this->request->server['HTTP_X_REQUESTED_WITH']) && strtolower($this->request->server['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') {
return;
}
if (isset($this->request->server['HTTPS']) && (($this->request->server['HTTPS'] == 'on') || ($this->request->server['HTTPS'] == '1'))) {
$config_ssl = substr($this->config->get('config_ssl'), 0, $this->strpos_offset('/', $this->config->get('config_ssl'), 3) + 1);
$url = str_replace('&', '&', $config_ssl . ltrim($this->request->server['REQUEST_URI'], '/'));
$seo = str_replace('&', '&', $this->url->link($this->request->get['route'], $this->getQueryString(array('route')), true));
} else {
$config_url = substr($this->config->get('config_url'), 0, $this->strpos_offset('/', $this->config->get('config_url'), 3) + 1);
$url = str_replace('&', '&', $config_url . ltrim($this->request->server['REQUEST_URI'], '/'));
$seo = str_replace('&', '&', $this->url->link($this->request->get['route'], $this->getQueryString(array('route')), false));
}
if (rawurldecode($url) != rawurldecode($seo)) {
header($this->request->server['SERVER_PROTOCOL'] . ' 301 Moved Permanently');
$this->response->redirect($seo);
}
}
private function strpos_offset($needle, $haystack, $occurrence) {
// explode the haystack
$arr = explode($needle, $haystack);
// check the needle is not out of bounds
switch($occurrence) {
case $occurrence == 0:
return false;
case $occurrence > max(array_keys($arr)):
return false;
default:
return strlen(implode($needle, array_slice($arr, 0, $occurrence)));
}
}
private function getQueryString($exclude = array()) {
if (!is_array($exclude)) {
$exclude = array();
}
return urldecode(http_build_query(array_diff_key($this->request->get, array_flip($exclude))));
}
}
?>
We clear the modifier cache. Thus, we will bring the seo-pro into stock form. Now let's add some code to the same file.
In front of approximately 32 line
// Decode URLadd the code
if(isset($this->request->get['_route_'])){
$urllanguage = explode('/', trim(utf8_strtolower($this->request->get['_route_']), '/'));
$this->load->model('localisation/language');
$languages = $this->model_localisation_language->getLanguages();
$lang = array();
foreach($languages as $language){
$lang[] = $language['code'];
}
if(isset($urllanguage[0]) && in_array($urllanguage[0], $lang)){
if(count($urllanguage) > 1){
$replace_lang = $urllanguage[0]."/";
}else{
$replace_lang = $urllanguage[0];
}
$this->request->get['_route_'] = str_replace($replace_lang, '', $this->request->get['_route_']);
if($this->request->get['_route_'] == '' || $this->request->get['_route_'] == '/'){
unset($this->request->get['_route_']);
}
}
}And approximaðÊÉíU ðÊÉíU ЛÉÉíU ™ÉÉíU XÊÉíU ÊÉíU @ ÊÉíU >
add the following code
$this->load->model('setting/setting');
$store_settings_config = $this->model_setting_setting->getSetting("config", $this->config->get('config_store_id'));
if(isset($this->session->data['language']) && $this->session->data['language'] != $store_settings_config['config_language']){
$seo_url = $this->session->data['language']."/".$seo_url;
}We clear the cache of modifiers and now, when changing the language, the language code will be added to our CNC. By default for the Ukrainian version it will be uk-ua.
If this view suits you, you can stop there, all pages should be adequately processed and opened in Ukrainian translation with a language prefix.
However, if you want to get a more beautiful view of the link and shorten the prefix to ua, you need to make a copy of the folder with the Ukrainian translation and rename the folders and files a little. Go to catalog / language. Here we will see a folder with our Ukrainian translation, which, if you have the prefix uk-ua now, will have the name uk-ua. I immediately make a copy of this folder and rename it to ua. We go into it and rename the uk-ua.php file to ua.php.
We go to the site admin panel and go to the settings of our second language, and we should see the ua we need in the code of our language, which will be added as a prefix in the url.
Thus, for the Ukrainian version, we will have links with the ua prefix, instead of uk-ua.
It should be noted that this option worked on OpenCart and not on ocStore. Also, the very first thought - to manually change the language code in the database, turned out to be wrong. The language table simply stores the already selected language in the admin panel. Those. if you do not rename the translation folders, but only change the value of the code in the database, it will not give any sense.