File: /home/retile.ru/public_html/storage/modification/catalog/controller/startup/seo_url.php
<?php // ========================================== seo_url.php v.140618 opencart-russia.ru ===============================
class ControllerStartupSeoUrl extends Controller {
public function index() {
// Add rewrite to url class
//d_seo_module
$route_status = isset($this->request->get['route']);
$this->load->controller('extension/module/d_seo_module/seo_url');
///d_seo_module
if ($this->config->get('config_seo_url')) {
$this->url->addRewrite($this);
}
// Decode URL
//d_seo_module
if (!$route_status && isset($this->request->get['route'])) {
if (VERSION >= '2.3.0.0') {
return true;
} else {
return new Action($this->request->get['route']);
}
}
///d_seo_module
if (isset($this->request->get['_route_'])) {
$parts = explode('/', $this->request->get['_route_']);
// SEO URL Generator . Begin
$parts = array_filter($parts);
$last_part = end($parts);
// SEO URL Generator . End
// remove any empty arrays from trailing
if (utf8_strlen(end($parts)) == 0) {
array_pop($parts);
}
foreach ($parts as $part) {
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "seo_url WHERE keyword = '" . $this->db->escape($part) . "' AND store_id = '" . (int)$this->config->get('config_store_id') . "'");
if ($query->num_rows) {
$url = explode('=', $query->row['query']);
if ($url[0] == 'product_id') {
$this->request->get['product_id'] = $url[1];
}
if ($url[0] == 'category_id') {
if (!isset($this->request->get['path'])) {
$this->request->get['path'] = $url[1];
} else {
$this->request->get['path'] .= '_' . $url[1];
}
}
if ($url[0] == 'manufacturer_id') {
$this->request->get['manufacturer_id'] = $url[1];
}
if ($url[0] == 'news_id') {
$this->request->get['news_id'] = $url[1];
}
if ($url[0] == 'news_category_id') {
if (!isset($this->request->get['news_path'])) {
$this->request->get['news_path'] = $url[1];
} else {
$this->request->get['news_path'] .= '_' . $url[1];
}
}
if ($url[0] == 'gallery_id') {
$this->request->get['gallery_id'] = $url[1];
}
if ($url[0] == 'information_id') {
$this->request->get['information_id'] = $url[1];
}
if ($query->row['query'] && $url[0] != 'information_id' && $url[0] != 'news_id' && $url[0] != 'news_category_id' && $url[0] != 'gallery_id' && $url[0] != 'manufacturer_id' && $url[0] != 'category_id' && $url[0] != 'product_id') {
$this->request->get['route'] = $query->row['query'];
}
} else {
// SEO URL Generator . Begin
$new_url = false;
// Attention!
// Sometimes users fill SEO URL with postfix ".html" instead of to turn on it in the SeoPro settings
// For those cases $last_part not contain ".html" so it is impossible to find anything in redirects
// That's why we need to check SEO URL if they contain postfix ".html"
$parts2 = explode('/', trim(utf8_strtolower($this->request->get['_route_']), '/'));
$last_part2 = str_replace('.html', '', end($parts2));
$a_parts = $parts;
if ($last_part != $last_part2) {
array_push($a_parts, $last_part2);
}
// Проверяем все части УРЛа, а не только крайнюю справа!
$in = '';
$i = 0;
foreach ($a_parts as $item) {
$in .= ($i) ? ', ' : '';
$in .= '\'' . $this->db->escape($item) . '\'';
$i++;
}
$sql = "SELECT * FROM " . DB_PREFIX . "seo_url_generator_redirects WHERE seo_url_old IN ($in) AND store_id = '" . (int)$this->config->get('config_store_id') . "' AND language_id = '" . (int)$this->config->get('config_language_id') . "' ORDER BY seo_url_id DESC";
$query = $this->db->query($sql);
$keys_with_redirects = array();
$essence_to_keys = array();
$res = array();
if ($query->rows) {
foreach ($query->rows as $item) {
$keys_with_redirects[] = mb_strtolower($item['seo_url_old']); // strtolower for SeoPro
$essence_to_keys[mb_strtolower($item['seo_url_old'])] = $item['query']; // strtolower for SeoPro
}
}
if ($last_part != $last_part2) {
$last_part = $last_part2;
}
// strtolower for SeoPro
if (in_array(mb_strtolower($last_part), $keys_with_redirects)) {
// Последний алиас есть в базе редиректов
$res = explode('=', $essence_to_keys[$last_part]);
} else {
// There isn't $last_part in redirects, but there is parent essence
// So we need to find out what type of essence is it
$sql = "SELECT query, keyword FROM " . DB_PREFIX . "seo_url WHERE keyword = '" . $this->db->escape($last_part) . "' AND store_id = '" . (int)$this->config->get('config_store_id') . "' AND language_id = '" . (int)$this->config->get('config_language_id') . "' ORDER BY seo_url_id DESC LIMIT 1";
$query = $this->db->query($sql);
if ($query->row) {
$res = explode('=', $query->row['query']);
}
}
// Определяем сущность текущей страницы
if ($res) {
if ('product_id' == $res[0]) {
$new_url = $this->url->link('product/product', 'product_id=' . $res[1]);
}
if ('category_id' == $res[0]) {
$new_url = $this->url->link('product/category', 'path=' . $res[1]);
}
if ('manufacturer_id' == $res[0]) {
$new_url = $this->url->link('product/manufacturer/info', 'manufacturer_id=' . $res[1]);
}
if ('information_id' == $res[0]) {
$new_url = $this->url->link('information/information', 'information_id=' . $res[1]);
}
}
if ($new_url) {
$this->response->redirect($new_url, 301);
exit;
}
// SEO URL Generator . End
$this->request->get['route'] = 'error/not_found';
break;
}
}
if (!isset($this->request->get['route'])) {
if (isset($this->request->get['product_id'])) {
$this->request->get['route'] = 'product/product';
} 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['news_id'])) {
$this->request->get['route'] = 'information/uni_news_story';
} elseif (isset($this->request->get['news_path'])) {
$this->request->get['route'] = 'information/uni_news';
} elseif (isset($this->request->get['gallery_id'])) {
$this->request->get['route'] = 'information/uni_gallery';
} elseif (isset($this->request->get['information_id'])) {
$this->request->get['route'] = 'information/information';
}
}
// Redirect 301
} elseif (isset($this->request->get['route']) && empty($this->request->post) && !isset($this->request->get['token']) && $this->config->get('config_seo_url')) {
$arg = '';
$cat_path = false;
$route = $this->request->get['route'];
if ($this->request->get['route'] == 'product/product' && isset($this->request->get['product_id'])) {
$route = 'product_id=' . (int)$this->request->get['product_id'];
} elseif ($this->request->get['route'] == 'product/category' && isset($this->request->get['path'])) {
$categorys_id = explode('_', $this->request->get['path']);
$cat_path = '';
foreach ($categorys_id as $category_id) {
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "seo_url WHERE query = 'category_id=" . (int)$category_id . "' AND store_id = '" . (int)$this->config->get('config_store_id') . "' AND language_id = '" . (int)$this->config->get('config_language_id') . "'");
if ($query->num_rows && $query->row['keyword']) {
$cat_path .= '/' . $query->row['keyword'];
} else {
$cat_path = false;
break;
}
}
$arg = trim($cat_path, '/');
if (isset($this->request->get['page'])) $arg = $arg . '?page=' . (int)$this->request->get['page'];
} elseif ($this->request->get['route'] == 'product/manufacturer/info' && isset($this->request->get['manufacturer_id'])) {
$route = 'manufacturer_id=' . (int)$this->request->get['manufacturer_id'];
if (isset($this->request->get['page'])) $arg = $arg . '?page=' . (int)$this->request->get['page'];
} elseif ($this->request->get['route'] == 'information/information' && isset($this->request->get['information_id'])) {
$route = 'information_id=' . (int)$this->request->get['information_id'];
} elseif (sizeof($this->request->get) > 1) {
$args = '?' . str_replace("route=" . $this->request->get['route'] . '&', "", $this->request->server['QUERY_STRING']);
$arg = str_replace('&', '&', $args);
}
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "seo_url WHERE query = '" . $this->db->escape($route) . "' AND store_id = '" . (int)$this->config->get('config_store_id') . "' AND language_id = '" . (int)$this->config->get('config_language_id') . "'");
if (!empty($query->num_rows) && !empty($query->row['keyword']) && $route) {
$this->response->redirect($query->row['keyword'] . $arg, 301);
} elseif ($cat_path) {
$this->response->redirect($arg, 301);
} elseif ($this->request->get['route'] == 'common/home') {
$this->response->redirect(HTTP_SERVER . $arg, 301);
}
}
}
public function rewrite($link) {
$url_info = parse_url(str_replace('&', '&', $link));
$url = '';
$data = array();
//d_seo_module
if (isset($url_info['query'])) parse_str($url_info['query'], $data);
///d_seo_module
foreach ($data as $key => $value) {
if (isset($data['route'])) {
if (($data['route'] == 'product/product' && $key == 'product_id') || (($data['route'] == 'product/manufacturer/info' || $data['route'] == 'product/product') && $key == 'manufacturer_id') || ($data['route'] == 'information/information' && $key == 'information_id') || ($data['route'] == 'information/uni_news_story' && $key == 'news_id') || ($data['route'] == 'information/uni_gallery' && $key == 'gallery_id')) {
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "seo_url WHERE `query` = '" . $this->db->escape($key . '=' . (int)$value) . "' AND store_id = '" . (int)$this->config->get('config_store_id') . "' AND language_id = '" . (int)$this->config->get('config_language_id') . "'");
if ($query->num_rows && $query->row['keyword']) {
$url .= '/' . $query->row['keyword'];
unset($data[$key]);
}
} elseif ($key == 'news_path') {
$categories = explode('_', $value);
foreach ($categories as $category) {
$query = $this->db->query("SELECT * FROM `".DB_PREFIX."seo_url` WHERE `query` = 'news_category_id=".(int)$category."' AND store_id = '".(int)$this->config->get('config_store_id')."' AND language_id = '".(int)$this->config->get('config_language_id')."'");
if ($query->num_rows && $query->row['keyword']) {
$url .= '/' . $query->row['keyword'];
} else {
$url = '';
break;
}
}
unset($data[$key]);
} elseif ($key == 'path') {
$categories = explode('_', $value);
foreach ($categories as $category) {
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "seo_url WHERE `query` = 'category_id=" . (int)$category . "' AND store_id = '" . (int)$this->config->get('config_store_id') . "' AND language_id = '" . (int)$this->config->get('config_language_id') . "'");
if ($query->num_rows && $query->row['keyword']) {
$url .= '/' . $query->row['keyword'];
} else {
$url = '';
break;
}
}
unset($data[$key]);
} elseif ($key == 'route') {
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "seo_url WHERE `query` = '" . $this->db->escape($data['route']) . "' AND store_id = '" . (int)$this->config->get('config_store_id') . "' AND language_id = '" . (int)$this->config->get('config_language_id') . "'");
if ($query->num_rows) /**/ {
$url .= '/' . $query->row['keyword'];
}
}
}
}
if ($url) {
unset($data['route']);
$query = '';
if ($data) {
foreach ($data as $key => $value) {
$query .= '&' . rawurlencode((string)$key) . '=' . rawurlencode((is_array($value) ? http_build_query($value) : (string)$value));
}
if ($query) {
$query = '?' . str_replace('&', '&', trim($query, '&'));
}
}
// Проверка на существование ключа 'path' в массиве $url_info
$path = isset($url_info['path']) ? str_replace('/index.php', '', $url_info['path']) : '';
return $url_info['scheme'] . '://' . $url_info['host'] . (isset($url_info['port']) ? ':' . $url_info['port'] : '') . $path . $url . $query;
} else {
return $link;
}
}
}