/catalog/controller/common/seo_pro.php
PHP | 434 lines | 356 code | 76 blank | 2 comment | 103 complexity | bda2ed58828fe0578896eb37b1c9c111 MD5 | raw file
- <?php
- class ControllerCommonSeoPro 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");
- $this->cache_data = array();
- foreach ($query->rows as $row) {
- $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 = $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 (count($rows) == sizeof($parts)) {
- $queries = array();
- foreach ($rows as $row) {
- $queries[utf8_strtolower($row['keyword'])] = $row['query'];
- }
- reset($parts);
- foreach ($parts as $part) {
- $url = explode('=', $queries[$part], 2);
- 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] == 'news_id') {
- $this->request->get['news_id'] = $url[1];
- }
- if ($url[0] == 'news_category_id') {
- if (!isset($this->request->get['ncat'])) {
- $this->request->get['ncat'] = $url[1];
- } else {
- $this->request->get['ncat'] .= '_' . $url[1];
- }
- }
-
- if ($url[0] == 'manufacturer_id') {
- $this->request->get['manufacturer_id'] = $url[1];
- }
-
- if ($url[0] == 'information_id') {
- $this->request->get['information_id'] = $url[1];
- } else{
- $route = $url[0];
- }
- }
- } 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['news_id'])) {
- $this->request->get['route'] = 'news/news';
- if (!isset($this->request->get['ncat'])) {
- $ncat = $this->getNcatByNews($this->request->get['news_id']);
- if ($ncat) $this->request->get['ncat'] = $ncat;
- }
- } elseif (isset($this->request->get['path'])) {
- $this->request->get['route'] = 'product/category';
- } elseif (isset($this->request->get['ncat'])) {
- $this->request->get['route'] = 'news/news_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';
- } else {
- if (isset($queries[$parts[0]])) {
- $this->request->get['route'] = $queries[$parts[0]];
- }
- }
- $this->validate();
- if (isset($this->request->get['route'])) {
- return $this->forward($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 'news/news':
- if (isset($data['news_id'])) {
- $tmp = $data;
- $data = array();
- if ($this->config->get('config_seo_url_include_path')) {
- $data['ncat'] = $this->getNcatByNews($tmp['news_id']);
- if (!$data['ncat']) return $link;
- }
- $data['news_id'] = $tmp['news_id'];
- if (isset($tmp['tracking'])) {
- $data['tracking'] = $tmp['tracking'];
- }
- }
- break;
- case 'news/news_category':
- if (isset($data['ncat'])) {
- $news_category = explode('_', $data['ncat']);
- $news_category = end($news_category);
- $data['ncat'] = $this->getNcatByNcategory($news_category);
- if (!$data['ncat']) return $link;
- }
- break;
- case 'product/product/review':
- case 'information/information/info':
- case 'account/return/insert':
- 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();
- foreach ($data as $key => $value) {
- switch ($key) {
- case 'product_id':
- case 'news_id':
- case 'manufacturer_id':
- case 'category_id':
- case 'news_category_id':
- case 'information_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;
-
- case 'ncat':
- $news_categories = explode('_', $value);
- foreach ($news_categories as $news_category) {
- $queries[] = 'news_category_id=' . $news_category;
- }
- unset($data[$key]);
- break;
- default:
- break;
- }
- }
- if(empty($queries)) {
- $queries[] = $route;
- if ($route != 'common/home') {$postfix = 1;}
- }
- $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 (!is_array($path)) {
- $path = $this->cache->get('product.seopath');
- if (!is_array($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 getNcatByNews($news_id) {
- $news_id = (int)$news_id;
- if ($news_id < 1) return false;
- static $ncat = null;
- if (!is_array($ncat)) {
- $ncat = $this->cache->get('news.seoncat');
- if (!is_array($ncat)) $ncat = array();
- }
- if (!isset($ncat[$news_id])) {
- $query = $this->db->query("SELECT news_category_id FROM " . DB_PREFIX . "news_to_news_category WHERE news_id = '" . $news_id . "' ORDER BY main_category DESC LIMIT 1");
- $ncat[$news_id] = $this->getNcatByNcategory($query->num_rows ? (int)$query->row['news_category_id'] : 0);
- $this->cache->set('news.seoncat', $ncat);
- }
- return $ncat[$news_id];
- }
- private function getPathByCategory($category_id) {
- $category_id = (int)$category_id;
- if ($category_id < 1) return false;
- static $path = null;
- if (!is_array($path)) {
- $path = $this->cache->get('category.seopath');
- if (!is_array($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 getNcatByNcategory($news_category_id) {
- $news_category_id = (int)$news_category_id;
- if ($news_category_id < 1) return false;
- static $ncat = null;
- if (!is_array($ncat)) {
- $ncat = $this->cache->get('news_category.seoncat');
- if (!is_array($ncat)) $ncat = array();
- }
- if (!isset($ncat[$news_category_id])) {
- $max_level = 10;
- $sql = "SELECT CONCAT_WS('_'";
- for ($i = $max_level-1; $i >= 0; --$i) {
- $sql .= ",t$i.news_category_id";
- }
- $sql .= ") AS ncat FROM " . DB_PREFIX . "news_category t0";
- for ($i = 1; $i < $max_level; ++$i) {
- $sql .= " LEFT JOIN " . DB_PREFIX . "news_category t$i ON (t$i.news_category_id = t" . ($i-1) . ".parent_id)";
- }
- $sql .= " WHERE t0.news_category_id = '" . $news_category_id . "'";
- $query = $this->db->query($sql);
- $ncat[$news_category_id] = $query->num_rows ? $query->row['ncat'] : false;
- $this->cache->set('news_category.seoncat', $ncat);
- }
- return $ncat[$news_category_id];
- }
- private function validate() {
- if (empty($this->request->get['route']) || $this->request->get['route'] == 'error/not_found') {
- return;
- }
- 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'))) {
- $url = str_replace('&', '&', $this->config->get('config_ssl') . ltrim($this->request->server['REQUEST_URI'], '/'));
- $seo = str_replace('&', '&', $this->url->link($this->request->get['route'], $this->getQueryString(array('route')), 'SSL'));
- } else {
- $url = str_replace('&', '&', $this->config->get('config_url') . ltrim($this->request->server['REQUEST_URI'], '/'));
- $seo = str_replace('&', '&', $this->url->link($this->request->get['route'], $this->getQueryString(array('route')), 'NONSSL'));
- }
- if (rawurldecode($url) != rawurldecode($seo)) {
- header($this->request->server['SERVER_PROTOCOL'] . ' 301 Moved Permanently');
- $this->response->redirect($seo);
- }
- }
- 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))));
- }
- }
- ?>