oct_seogeneration.php
8.4 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
<?php
/**
* @copyright OCTemplates
* @support https://octemplates.net/
* @license LICENSE.txt
*/
class ModelOCTemplatesWidgetsOCTSeoGeneration extends Model {
public function seoUrlGenerator($type, $language_id, $store_id, $data, $element_id) {
$oct_seo_url_data = $this->config->get('theme_oct_deals_seo_url_data');
if (!empty($oct_seo_url_data[$type])) {
$oct_urlgen_template = $oct_seo_url_data[$type];
$i = 0;
switch ($type) {
case 'product':
$name = (isset($data['product_description'][$language_id]['name']) && !empty($data['product_description'][$language_id]['name'])) ? strip_tags(html_entity_decode($data['product_description'][$language_id]['name'], ENT_QUOTES, 'UTF-8')) : '';
$model = (isset($data['model']) && !empty($data['model'])) ? strip_tags(html_entity_decode($data['model'], ENT_QUOTES, 'UTF-8')) : '';
$sku = (isset($data['sku']) && !empty($data['sku'])) ? strip_tags(html_entity_decode($data['sku'], ENT_QUOTES, 'UTF-8')) : '';
$brand = (isset($data['manufacturer']) && !empty($data['manufacturer'])) ? strip_tags(html_entity_decode($data['manufacturer'], ENT_QUOTES, 'UTF-8')) : '';
break;
case 'category':
$name = (isset($data['category_description'][$language_id]['name']) && !empty($data['category_description'][$language_id]['name'])) ? strip_tags(html_entity_decode($data['category_description'][$language_id]['name'], ENT_QUOTES, 'UTF-8')) : '';
$model = '';
$sku = '';
$brand = '';
break;
case 'manufacturer':
$name = ($data['name'] && !empty($data['name'])) ? strip_tags(html_entity_decode($this->db->escape($data['name']), ENT_QUOTES, 'UTF-8')) : '';
$model = '';
$sku = '';
$brand = '';
break;
case 'information':
$name = (isset($data['information_description'][$language_id]['title']) && !empty($data['information_description'][$language_id]['title'])) ? strip_tags(html_entity_decode($data['information_description'][$language_id]['title'], ENT_QUOTES, 'UTF-8')) : ''; $model = '';
$sku = '';
$brand = '';
break;
case 'blog_category':
$name = (isset($data['category_description'][$language_id]['name']) && !empty($data['category_description'][$language_id]['name'])) ? strip_tags(html_entity_decode($data['category_description'][$language_id]['name'], ENT_QUOTES, 'UTF-8')) : '';
$model = '';
$sku = '';
$brand = '';
break;
case 'blog_article':
$name = (isset($data['article_description'][$language_id]['name']) && !empty($data['article_description'][$language_id]['name'])) ? strip_tags(html_entity_decode($data['article_description'][$language_id]['name'], ENT_QUOTES, 'UTF-8')) : '';
$model = '';
$sku = '';
$brand = '';
break;
default:
$name = '';
$model = '';
$sku = '';
$brand = '';
break;
}
if (!empty($name)) {
$oct_replace = [
'[name]' => $name,
'[model]' => $model,
'[sku]' => $sku,
'[brand]' => $brand,
'[lang_prefix]' => isset($oct_seo_url_data['lang_prefix'][$language_id]) ? $oct_seo_url_data['lang_prefix'][$language_id] : ''
];
$keyword = str_replace(array_keys($oct_replace), array_values($oct_replace), $oct_urlgen_template);
$oct_keyword_translit = $this->octTranslit($this->db->escape($keyword));
$unic = false;
$t = '';
while ($unic === false) {
if ($i > 0) {
$t = '-'. $i;
}
$sql = $this->db->query("SELECT seo_url_id FROM " . DB_PREFIX . "seo_url WHERE store_id = '" . (int)$store_id . "' AND keyword = '" . $this->db->escape(trim($oct_keyword_translit.$t)) . "'");
if (!$sql->num_rows) {
$unic = true;
} else {
$unic = false;
$i++;
}
}
$this->db->query("INSERT INTO " . DB_PREFIX . "seo_url SET store_id = '" . (int)$store_id . "', language_id = '" . (int)$language_id . "', query = '". str_replace('_', '', $type) ."_id=" . (int)$element_id . "', keyword = '" . $this->db->escape(trim($oct_keyword_translit.$t)) . "'");
}
}
}
public function octTranslit($string) {
$string = (string)$string;
$string = strip_tags($string);
$string = str_replace(array("\n", "\r"), " ", $string);
$string = preg_replace("/\s+/", ' ', $string);
$string = trim($string);
$string = utf8_strtolower($string);
$lang_tr = [
'á' => 'a', 'Á' => 'A', 'à' => 'a', 'À' => 'A',
'ă' => 'a', 'Ă' => 'A', 'â' => 'a', 'Â' => 'A',
'å' => 'a', 'Å' => 'A', 'ã' => 'a', 'Ã' => 'A',
'ą' => 'a', 'Ą' => 'A', 'ā' => 'a', 'Ā' => 'A',
'ä' => 'ae', 'Ä' => 'AE', 'æ' => 'ae', 'Æ' => 'AE',
'ḃ' => 'b', 'Ḃ' => 'B', 'ć' => 'c', 'Ć' => 'C',
'ĉ' => 'c', 'Ĉ' => 'C', 'č' => 'c', 'Č' => 'C',
'ċ' => 'c', 'Ċ' => 'C', 'ç' => 'c', 'Ç' => 'C',
'ď' => 'd', 'Ď' => 'D', 'ḋ' => 'd', 'Ḋ' => 'D',
'đ' => 'd', 'Đ' => 'D', 'ð' => 'dh', 'Ð' => 'Dh',
'é' => 'e', 'É' => 'E', 'è' => 'e', 'È' => 'E',
'ĕ' => 'e', 'Ĕ' => 'E', 'ê' => 'e', 'Ê' => 'E',
'ě' => 'e', 'Ě' => 'E', 'ë' => 'e', 'Ë' => 'E',
'ė' => 'e', 'Ė' => 'E', 'ę' => 'e', 'Ę' => 'E',
'ē' => 'e', 'Ē' => 'E', 'ḟ' => 'f', 'Ḟ' => 'F',
'ƒ' => 'f', 'Ƒ' => 'F', 'ğ' => 'g', 'Ğ' => 'G',
'ĝ' => 'g', 'Ĝ' => 'G', 'ġ' => 'g', 'Ġ' => 'G',
'ģ' => 'g', 'Ģ' => 'G', 'ĥ' => 'h', 'Ĥ' => 'H',
'ħ' => 'h', 'Ħ' => 'H', 'í' => 'i', 'Í' => 'I',
'ì' => 'i', 'Ì' => 'I', 'î' => 'i', 'Î' => 'I',
'ï' => 'i', 'Ï' => 'I', 'ĩ' => 'i', 'Ĩ' => 'I',
'į' => 'i', 'Į' => 'I', 'ī' => 'i', 'Ī' => 'I',
'ĵ' => 'j', 'Ĵ' => 'J', 'ķ' => 'k', 'Ķ' => 'K',
'ĺ' => 'l', 'Ĺ' => 'L', 'ľ' => 'l', 'Ľ' => 'L',
'ļ' => 'l', 'Ļ' => 'L', 'ł' => 'l', 'Ł' => 'L',
'ṁ' => 'm', 'Ṁ' => 'M', 'ń' => 'n', 'Ń' => 'N',
'ň' => 'n', 'Ň' => 'N', 'ñ' => 'n', 'Ñ' => 'N',
'ņ' => 'n', 'Ņ' => 'N', 'ó' => 'o', 'Ó' => 'O',
'ò' => 'o', 'Ò' => 'O', 'ô' => 'o', 'Ô' => 'O',
'ő' => 'o', 'Ő' => 'O', 'õ' => 'o', 'Õ' => 'O',
'ø' => 'oe', 'Ø' => 'OE', 'ō' => 'o', 'Ō' => 'O',
'ơ' => 'o', 'Ơ' => 'O', 'ö' => 'oe', 'Ö' => 'OE',
'ṗ' => 'p', 'Ṗ' => 'P', 'ŕ' => 'r', 'Ŕ' => 'R',
'ř' => 'r', 'Ř' => 'R', 'ŗ' => 'r', 'Ŗ' => 'R',
'ś' => 's', 'Ś' => 'S', 'ŝ' => 's', 'Ŝ' => 'S',
'š' => 's', 'Š' => 'S', 'ṡ' => 's', 'Ṡ' => 'S',
'ş' => 's', 'Ş' => 'S', 'ș' => 's', 'Ș' => 'S',
'ß' => 'SS', 'ť' => 't', 'Ť' => 'T', 'ṫ' => 't',
'Ṫ' => 'T', 'ţ' => 't', 'Ţ' => 'T', 'ț' => 't',
'Ț' => 'T', 'ŧ' => 't', 'Ŧ' => 'T', 'ú' => 'u',
'Ú' => 'U', 'ù' => 'u', 'Ù' => 'U', 'ŭ' => 'u',
'Ŭ' => 'U', 'û' => 'u', 'Û' => 'U', 'ů' => 'u',
'Ů' => 'U', 'ű' => 'u', 'Ű' => 'U', 'ũ' => 'u',
'Ũ' => 'U', 'ų' => 'u', 'Ų' => 'U', 'ū' => 'u',
'Ū' => 'U', 'ư' => 'u', 'Ư' => 'U', 'ü' => 'ue',
'Ü' => 'UE', 'ẃ' => 'w', 'Ẃ' => 'W', 'ẁ' => 'w',
'Ẁ' => 'W', 'ŵ' => 'w', 'Ŵ' => 'W', 'ẅ' => 'w',
'Ẅ' => 'W', 'ý' => 'y', 'Ý' => 'Y', 'ỳ' => 'y',
'Ỳ' => 'Y', 'ŷ' => 'y', 'Ŷ' => 'Y', 'ÿ' => 'y',
'Ÿ' => 'Y', 'ź' => 'z', 'Ź' => 'Z', 'ž' => 'z',
'Ž' => 'Z', 'ż' => 'z', 'Ż' => 'Z', 'þ' => 'th',
'Þ' => 'Th', 'µ' => 'u', 'а' => 'a', 'А' => 'a',
'б' => 'b', 'Б' => 'b', 'в' => 'v', 'В' => 'v',
'г' => 'h', 'Г' => 'h', 'ґ' => 'g', 'Ґ' => 'g',
'д' => 'd', 'Д' => 'd', 'е' => 'e', 'Е' => 'e', 'ё' => 'e', 'Ё' => 'e',
'є' => 'ie', 'Є' => 'ie', 'ж' => 'zh', 'Ж' => 'zh',
'з' => 'z', 'З' => 'z', 'и' => 'y', 'И' => 'y',
'і' => 'i', 'І' => 'i', 'ї' => 'i', 'Ї' => 'i',
'й' => 'i', 'Й' => 'i', 'к' => 'k', 'К' => 'k',
'л' => 'l', 'Л' => 'l', 'м' => 'm', 'М' => 'm',
'н' => 'n', 'Н' => 'n', 'о' => 'o', 'О' => 'o',
'п' => 'p', 'П' => 'p', 'р' => 'r', 'Р' => 'r',
'с' => 's', 'С' => 's', 'т' => 't', 'Т' => 't',
'у' => 'u', 'У' => 'u', 'ф' => 'f', 'Ф' => 'f',
'х' => 'kh', 'Х' => 'kh', 'ц' => 'ts', 'Ц' => 'ts',
'ч' => 'ch', 'Ч' => 'ch', 'ш' => 'sh', 'Ш' => 'sh',
'щ' => 'shch', 'Щ' => 'shch', 'ь' => '', 'Ь' => '', 'ъ' => '', 'Ъ' => '', 'ы' => 'y', 'Ы' => 'y',
'ю' => 'iu', 'Ю' => 'iu', 'я' => 'ia', 'Я' => 'ia'
];
$string = strtr($string, $lang_tr);
$string = preg_replace("/[^0-9a-z-_ ]/i", "", $string);
$string = str_replace(" ", "-", $string);
$string = str_replace("----", "-", $string);
$string = str_replace("---", "-", $string);
$string = str_replace("--", "-", $string);
$string = trim($string);
$string = trim($string, '-');
return $string;
}
}