· 8 years ago · Mar 15, 2018, 03:52 PM
1<modification>
2 <id>manufacturer_description_oc_1.5.1.3</id>
3 <version>1.0</version>
4 <vqmver>1.0.8</vqmver>
5 <author>Разработал - afwollis. Ðдаптировал под VQMOD - stalker780</author>
6
7 <file name="admin/model/catalog/manufacturer.php">
8 <operation>
9 <search position="before"><![CDATA[
10 if (isset($data['manufacturer_store'])) {
11 ]]></search>
12 <add trim="true"><![CDATA[
13 foreach ($data['manufacturer_description'] as $language_id => $value) {
14 $this->db->query("INSERT INTO " . DB_PREFIX . "manufacturer_description SET manufacturer_id = '" . (int)$manufacturer_id . "', language_id = '" . (int)$language_id . "', name = '" . $this->db->escape($value['name']) . "', meta_keyword = '" . $this->db->escape($value['meta_keyword']) . "', meta_description = '" . $this->db->escape($value['meta_description']) . "', description = '" . $this->db->escape($value['description']) . "'");
15 }
16 ]]></add>
17 </operation>
18 <operation>
19 <search position="before"><![CDATA[
20 $this->db->query("DELETE FROM " . DB_PREFIX . "manufacturer_to_store WHERE manufacturer_id = '" . (int)$manufacturer_id . "'");
21 ]]></search>
22 <add trim="true"><![CDATA[
23 $this->db->query("DELETE FROM " . DB_PREFIX . "manufacturer_description WHERE manufacturer_id = '" . (int)$manufacturer_id . "'");
24 foreach ($data['manufacturer_description'] as $language_id => $value) {
25 $this->db->query("INSERT INTO " . DB_PREFIX . "manufacturer_description SET manufacturer_id = '" . (int)$manufacturer_id . "', language_id = '" . (int)$language_id . "', name = '" . $this->db->escape($value['name']) . "', meta_keyword = '" . $this->db->escape($value['meta_keyword']) . "', meta_description = '" . $this->db->escape($value['meta_description']) . "', description = '" . $this->db->escape($value['description']) . "'");
26 }
27 ]]></add>
28 </operation>
29 <operation>
30 <search position="before"><![CDATA[
31 $this->db->query("DELETE FROM " . DB_PREFIX . "manufacturer_to_store WHERE manufacturer_id = '" . (int)$manufacturer_id . "'");
32 ]]></search>
33 <add trim="true"><![CDATA[
34 $this->db->query("DELETE FROM " . DB_PREFIX . "manufacturer_description WHERE manufacturer_id = '" . (int)$manufacturer_id . "'");
35 ]]></add>
36 </operation>
37 <operation>
38 <search position="before"><![CDATA[
39 public function getManufacturerStores($manufacturer_id) {
40 ]]></search>
41 <add trim="true"><![CDATA[
42 public function getManufacturerDescriptions($manufacturer_id) {
43 $manufacturer_description_data = array();
44 $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "manufacturer_description WHERE manufacturer_id = '" . (int)$manufacturer_id . "'");
45 foreach ($query->rows as $result) {
46 $manufacturer_description_data[$result['language_id']] = array(
47 'name' => $result['name'],
48 'meta_keyword' => $result['meta_keyword'],
49 'meta_description' => $result['meta_description'],
50 'description' => $result['description']
51 );
52 }
53 return $manufacturer_description_data;
54 }
55
56 public function w_manufacturerDescriptionInstall() {
57 $sql = "
58 CREATE TABLE IF NOT EXISTS `" . DB_PREFIX . "manufacturer_description` (
59 `manufacturer_id` int(11) NOT NULL,
60 `language_id` int(11) NOT NULL,
61 `name` varchar(255) NOT NULL DEFAULT '',
62 `description` text NOT NULL,
63 `meta_description` varchar(255) NOT NULL,
64 `meta_keyword` varchar(255) NOT NULL,
65 PRIMARY KEY (`manufacturer_id`,`language_id`),
66 KEY `name` (`name`)
67 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
68 INSERT INTO `" . DB_PREFIX . "manufacturer_description` (`manufacturer_id`, `name`, `language_id`, `description`, `meta_description`, `meta_keyword`)
69 SELECT `manufacturer_id`, `name`, 1, '', '', '' FROM `" . DB_PREFIX . "manufacturer`;
70 ";
71 $query = $this->db->query($sql);
72 }
73 ]]></add>
74 </operation>
75 </file>
76
77 <file name="admin/language/english/catalog/manufacturer.php">
78 <operation error="skip">
79 <search position="replace"><![CDATA[
80 $_['entry_name'] = 'KļiÄka:';
81 ]]></search>
82 <add trim="true"><![CDATA[
83 $_['entry_name'] = 'Производитель:';
84 $_['entry_name_old'] = 'Производитель:<br>(Ð¸Ð¼Ñ Ð´Ð»Ñ Ð°Ð´Ð¼Ð¸Ð½ÐºÐ¸)';
85 $_['entry_description'] = 'ОпиÑание:';
86 $_['entry_meta_description'] = 'Мета-тег "ОпиÑание":';
87 $_['entry_meta_keyword'] = 'Мета-тег "Ключевые Ñлова":';
88 ]]></add>
89 </operation>
90 </file>
91
92 <file name="admin/controller/catalog/manufacturer.php">
93 <operation>
94 <search position="replace"><![CDATA[
95 $this->data['entry_name'] = $this->language->get('entry_name');
96 ]]></search>
97 <add trim="true"><![CDATA[
98 $this->data['entry_name'] = $this->language->get('entry_name');
99 $this->data['entry_name_old'] = $this->language->get('entry_name_old');
100 $this->data['entry_description'] = $this->language->get('entry_description');
101 $this->data['entry_meta_description'] = $this->language->get('entry_meta_description');
102 $this->data['entry_meta_keyword'] = $this->language->get('entry_meta_keyword');
103 $this->data['tab_general'] = $this->language->get('tab_general');
104 $this->data['tab_data'] = $this->language->get('tab_data');
105 ]]></add>
106 </operation>
107 <operation>
108 <search position="before"><![CDATA[
109 if (isset($this->request->post['name'])) {
110 ]]></search>
111 <add trim="true"><![CDATA[
112 //$this->model_catalog_manufacturer->w_manufacturerDescriptionInstall(); /* create database table */
113
114 $this->load->model('localisation/language');
115
116 $this->data['languages'] = $this->model_localisation_language->getLanguages();
117
118 if (isset($this->request->post['manufacturer_description'])) {
119 $this->data['manufacturer_description'] = $this->request->post['manufacturer_description'];
120 } elseif (isset($this->request->get['manufacturer_id'])) {
121 $this->data['manufacturer_description'] = $this->model_catalog_manufacturer->getManufacturerDescriptions($this->request->get['manufacturer_id']);
122 } else {
123 $this->data['manufacturer_description'] = array();
124 }
125 ]]></add>
126 </operation>
127 <operation error="skip">
128 <search position="replace"><![CDATA[
129 1$this->error['name'] = $this->language->get('error_name');
130 ]]></search>
131 <add trim="true"><![CDATA[
132 if ((utf8_strlen($value['name']) < 2) || (utf8_strlen($value['name']) > 255)) {
133 $this->error['name'][$language_id] = $this->language->get('error_name');
134 }
135 ]]></add>
136 </operation>
137 </file>
138
139 <file name="admin/view/template/catalog/manufacturer_form.tpl">
140 <operation error="skip">
141 <search position="replace"><![CDATA[
142 <?php echo $entry_name; ?>
143 ]]></search>
144 <add trim="true"><![CDATA[
145 <?php echo $entry_name_old; ?>
146 ]]></add>
147 </operation>
148
149 <operation>
150 <search position="replace"><![CDATA[
151 <div id="tab-general">
152 ]]></search>
153 <add trim="true"><![CDATA[
154 <div id="tab-general">
155 <div id="languages" class="htabs">
156 <?php foreach ($languages as $language) { ?>
157 <a href="#language<?php echo $language['language_id']; ?>"><img src="view/image/flags/<?php echo $language['image']; ?>" title="<?php echo $language['name']; ?>" /> <?php echo $language['name']; ?></a>
158 <?php } ?>
159 </div>
160 <?php foreach ($languages as $language) { ?>
161 <div id="language<?php echo $language['language_id']; ?>">
162 <table class="form">
163 <tr>
164 <td><span class="required">*</span> <?php echo $entry_name; ?></td>
165 <td><input type="text" name="manufacturer_description[<?php echo $language['language_id']; ?>][name]" size="100" value="<?php echo isset($manufacturer_description[$language['language_id']]) ? $manufacturer_description[$language['language_id']]['name'] : ''; ?>" />
166 <?php if (isset($error_name[$language['language_id']])) { ?>
167 <span class="error"><?php echo $error_name[$language['language_id']]; ?></span>
168 <?php } ?></td>
169 </tr>
170 <tr>
171 <td><?php echo $entry_meta_description; ?></td>
172 <td><textarea name="manufacturer_description[<?php echo $language['language_id']; ?>][meta_description]" cols="40" rows="5"><?php echo isset($manufacturer_description[$language['language_id']]) ? $manufacturer_description[$language['language_id']]['meta_description'] : ''; ?></textarea></td>
173 </tr>
174 <tr>
175 <td><?php echo $entry_meta_keyword; ?></td>
176 <td><textarea name="manufacturer_description[<?php echo $language['language_id']; ?>][meta_keyword]" cols="40" rows="5"><?php echo isset($manufacturer_description[$language['language_id']]) ? $manufacturer_description[$language['language_id']]['meta_keyword'] : ''; ?></textarea></td>
177 </tr>
178 <tr>
179 <td><?php echo $entry_description; ?></td>
180 <td><textarea name="manufacturer_description[<?php echo $language['language_id']; ?>][description]" id="description<?php echo $language['language_id']; ?>"><?php echo isset($manufacturer_description[$language['language_id']]) ? $manufacturer_description[$language['language_id']]['description'] : ''; ?></textarea></td>
181 </tr>
182 </table>
183 </div>
184 <?php } ?>
185 ]]></add>
186 </operation>
187 <operation>
188 <search position="replace"><![CDATA[
189 $('#tabs a').tabs();
190 ]]></search>
191 <add trim="true"><![CDATA[
192 $('#tabs a').tabs();
193 $('#languages a').tabs();
194 ]]></add>
195 </operation>
196 <operation>
197 <search position="replace"><![CDATA[
198 <?php echo $footer; ?>
199 ]]></search>
200 <add trim="true"><![CDATA[
201 <script type="text/javascript" src="view/javascript/ckeditor/ckeditor.js"></script>
202 <script type="text/javascript"><!--
203 <?php foreach ($languages as $language) { ?>
204 CKEDITOR.replace('description<?php echo $language['language_id']; ?>', {
205 toolbar : 'Full',
206 filebrowserBrowseUrl: 'index.php?route=common/filemanager&token=<?php echo $token; ?>',
207 filebrowserImageBrowseUrl: 'index.php?route=common/filemanager&token=<?php echo $token; ?>',
208 filebrowserFlashBrowseUrl: 'index.php?route=common/filemanager&token=<?php echo $token; ?>',
209 filebrowserUploadUrl: 'index.php?route=common/filemanager&token=<?php echo $token; ?>',
210 filebrowserImageUploadUrl: 'index.php?route=common/filemanager&token=<?php echo $token; ?>',
211 filebrowserFlashUploadUrl: 'index.php?route=common/filemanager&token=<?php echo $token; ?>'
212 });
213 <?php } ?>
214 //--></script>
215 <?php echo $footer; ?>
216 ]]></add>
217 </operation>
218 </file>
219
220 <file name="catalog/model/catalog/manufacturer.php">
221 <operation>
222 <search position="replace"><![CDATA[
223 "SELECT * FROM " . DB_PREFIX . "manufacturer m LEFT JOIN " . DB_PREFIX . "manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m.manufacturer_id = '" . (int)$manufacturer_id . "' AND m2s.store_id = '" . (int)$this->config->get('config_store_id') . "'"
224 ]]></search>
225 <add trim="true"><![CDATA[
226 "SELECT DISTINCT m.manufacturer_id, m.image, m.sort_order, md.name, md.description, md.meta_description, md.meta_keyword, md.language_id FROM " . DB_PREFIX . "manufacturer m LEFT JOIN " . DB_PREFIX . "manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN " . DB_PREFIX . "manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m.manufacturer_id = '" . (int)$manufacturer_id . "' AND md.language_id = '" . (int)$this->config->get('config_language_id') . "' AND m2s.store_id = '" . (int)$this->config->get('config_store_id') . "'"
227 ]]></add>
228 </operation>
229 <operation>
230 <search position="replace"><![CDATA[
231 "SELECT * FROM " . DB_PREFIX . "manufacturer m LEFT JOIN " . DB_PREFIX . "manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m2s.store_id = '" . (int)$this->config->get('config_store_id') . "'
232 ]]></search>
233 <add trim="true"><![CDATA[
234 "SELECT DISTINCT m.manufacturer_id, m.image, m.sort_order, md.name, md.description, md.meta_description, md.meta_keyword, md.language_id FROM " . DB_PREFIX . "manufacturer m LEFT JOIN " . DB_PREFIX . "manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN " . DB_PREFIX . "manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE md.language_id = '" . (int)$this->config->get('config_language_id') . "' AND m2s.store_id = '" . (int)$this->config->get('config_store_id') . "'
235 ]]></add>
236 </operation>
237 </file>
238
239 <file name="catalog/controller/product/manufacturer.php">
240 <operation>
241 <search position="replace"><![CDATA[
242 $this->data['heading_title'] = $manufacturer_info['name'];
243 ]]></search>
244 <add trim="true"><![CDATA[
245 $this->data['heading_title'] = $manufacturer_info['name'];
246 $this->data['description'] = html_entity_decode($manufacturer_info['description'], ENT_QUOTES, 'UTF-8');
247 $this->document->setTitle($manufacturer_info['name']);
248 $this->document->setDescription($manufacturer_info['meta_description']);
249 $this->document->setKeywords($manufacturer_info['meta_keyword']);
250 ]]></add>
251 </operation>
252 </file>
253
254 <file name="catalog/view/theme/*/template/product/manufacturer_info.tpl">
255 <operation>
256 <search position="replace"><![CDATA[
257 <h1><?php echo $heading_title; ?></h1>
258 ]]></search>
259 <add trim="true"><![CDATA[
260 <h1><?php echo $heading_title; ?></h1>
261 <?php if ($description) { ?>
262 <div class="category-info">
263 <?php if ($description) { ?>
264 <?php echo $description; ?>
265 <?php } ?>
266 </div>
267 <?php } ?>
268 ]]></add>
269 </operation>
270 </file>
271
272</modification>