Статьи:

Новости:

Разработка сайта для нотариусов Мы подготовили новое пакетное предложение по разработке сайтов для нотариусов. Если Вы - частный нотариус, то создание сайта у нас позволит вам:

Главная

Статьи

Программирование

Данная статья создана для внутреннего пользования
Она может содержать ошибки и неточности, мы не гарантируем корректность информации
Вся информация в статье относится к версии 1.4.х и могла устареть на данный момент времени
МЫ НЕ КОНСУЛЬТИРУЕМ ПО ДОРАБОТКЕ ОПЕНКАРТА И ИНФОМАЦИИ В СТАТЬЕ

Доработка Opencart. Как добавить описание к производителю.

Иногда крайне необходимо иметь текстовое описание к каждому производителю товаров. Стандартная поставка Opencart 1.4.8 не позволяет этого сделать, поэтому делаем своими руками.

Доработка Opencart

Наша компания занимается созданием, доработкой и сопровождением магазинов на Opencart. Подробнее

Это текст написан по горячим следам, в первую очередь для себя. Он будет полезен в первую очередь программистам Opencart, которым надо только показать что и где надо менять. Не имее навыков по работе с PHP и SQL будет сложно пользоваться данной информацией для доработки вашего интернет-магазина.

1. Правим базу, добавляя еще одну таблицу

CREATE TABLE <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+bWFudWZhY3R1cmVyX2Rlc2NyaXB0aW9uPC9jb2RlPg=="></span> (
  <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+bWFudWZhY3R1cmVyX2lkPC9jb2RlPg=="></span> int(11) NOT NULL,
  <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+bGFuZ3VhZ2VfaWQ8L2NvZGU+"></span> int(11) NOT NULL,
  <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+bWV0YV9kZXNjcmlwdGlvbjwvY29kZT4="></span> varchar(66) collate utf8_unicode_ci NOT NULL,
  <span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+ZGVzY3JpcHRpb248L2NvZGU+"></span> text collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+bWFudWZhY3R1cmVyX2lkPC9jb2RlPg=="></span>,<span class="base64" title="PGNvZGUgY2xhc3M9J3NwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lJyBkaXI9J2x0cic+bGFuZ3VhZ2VfaWQ8L2NvZGU+"></span>)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

2. В /catalog/controller/product/manufacturer.php примерно в 34 строке

$this->document->title = $manufacturer_info['name'];
/*После этой строки идет наша вставка*/
$this->data['description'] = html_entity_decode($manufacturer_info['description']);

3. В /catalog/model/catalog/manufacturer.php меняем запрос к базе в функции getManufacturer

$query = $this->db->query("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') . "' ORDER BY sort_order, LCASE(m.name) ASC");

4) В /catalog/view/theme/template/product/manufacturer.tpl добавляем вывод описания

<?php if ($description) { ?>
  <div style="margin-bottom: 15px;"><?php echo $description; ?></div>
  <?php } ?>

Меняем админку

5)В admin/language/catalog/manufacturer.php

$_['entry_meta_description'] = 'Мета Таг:';
$_['entry_description']      = 'Описание:';
$_['error_meta_description'] = 'Ошибка мета-описания:';
$_['error_description']      = 'Ошибка описания:';

6) Вносим правки в controller/catalog/manufacturer.php в функцию getForm():

/*Строка 278*/
$this->data['entry_meta_description'] = $this->language->get('entry_meta_description');
$this->data['entry_description'] = $this->language->get('entry_description');
/*Строка 346*/
if (isset($this->request->post['manufacturer_description'])) {
	$this->data['manufacturer_description'] = $this->request->post['manufacturer_description'];
} elseif (isset($manufacturer_info)) {
	$this->data['manufacturer_description'] = $this->model_catalog_manufacturer->getManufacturerDescriptions($this->request->get['manufacturer_id']);
} else {
	$this->data['manufacturer_description'] = array();
}

/*Строка 401*/
$this->load->model('localisation/language');
$this->data['languages'] = $this->model_localisation_language->getLanguages();

Я сознательно не стал возиться с обработчиком ошибок.

7. /model/catalog/manufacturer.php после всех правок выглядит так

<?php
class ModelCatalogManufacturer extends Model {
	public function addManufacturer($data) {
      	$this->db->query("INSERT INTO " . DB_PREFIX . "manufacturer SET name = '" . $this->db->escape($data['name']) . "', sort_order = '" . (int)$data['sort_order'] . "'");
		$manufacturer_id = $this->db->getLastId();
		if (isset($data['image'])) {
			$this->db->query("UPDATE " . DB_PREFIX . "manufacturer SET image = '" . $this->db->escape($data['image']) . "' WHERE manufacturer_id = '" . (int)$manufacturer_id . "'");
		}
foreach ($data['manufacturer_description'] as $language_id => $value) {
	$this->db->query("INSERT INTO " . DB_PREFIX . "manufacturer_description SET manufacturer_id = '" . (int)$manufacturer_id . "', language_id = '" . (int)$language_id . "', meta_description = '" . $this->db->escape(@$value['meta_description']) . "', description = '" . $this->db->escape(@$value['description']) . "'");
}
		if (isset($data['manufacturer_store'])) {
			foreach ($data['manufacturer_store'] as $store_id) {
				$this->db->query("INSERT INTO " . DB_PREFIX . "manufacturer_to_store SET manufacturer_id = '" . (int)$manufacturer_id . "', store_id = '" . (int)$store_id . "'");
			}
		}
		$this->cache->delete('manufacturer');
	}
	public function editManufacturer($manufacturer_id, $data) {
      	$this->db->query("UPDATE " . DB_PREFIX . "manufacturer SET name = '" . $this->db->escape($data['name']) . "', sort_order = '" . (int)$data['sort_order'] . "' WHERE manufacturer_id = '" . (int)$manufacturer_id . "'");
		if (isset($data['image'])) {
			$this->db->query("UPDATE " . DB_PREFIX . "manufacturer SET image = '" . $this->db->escape($data['image']) . "' WHERE manufacturer_id = '" . (int)$manufacturer_id . "'");
		}
		$this->db->query("DELETE FROM " . DB_PREFIX . "manufacturer_to_store WHERE manufacturer_id = '" . (int)$manufacturer_id . "'");
		if (isset($data['manufacturer_store'])) {
			foreach ($data['manufacturer_store'] as $store_id) {
				$this->db->query("INSERT INTO " . DB_PREFIX . "manufacturer_to_store SET manufacturer_id = '" . (int)$manufacturer_id . "', store_id = '" . (int)$store_id . "'");
			}
		}
$this->db->query("DELETE FROM " . DB_PREFIX . "manufacturer_description WHERE manufacturer_id = '" . (int)$manufacturer_id . "'");
foreach ($data['manufacturer_description'] as $language_id => $value) {
	//echo "INSERT INTO " . DB_PREFIX . "manufacturer_description SET manufacturer_id = '" . (int)$manufacturer_id . "', language_id = '" . (int)$language_id . "', meta_description = '" . $this->db->escape(@$value['meta_description']) . "', description = '" . $this->db->escape(@$value['description']) . "'";
	$this->db->query("INSERT INTO " . DB_PREFIX . "manufacturer_description SET manufacturer_id = '" . (int)$manufacturer_id . "', language_id = '" . (int)$language_id . "', meta_description = '" . $this->db->escape(@$value['meta_description']) . "', description = '" . $this->db->escape(@$value['description']) . "'");
}
		$this->db->query("DELETE FROM " . DB_PREFIX . "url_alias WHERE query = 'manufacturer_id=" . (int)$manufacturer_id. "'");
		if ($data['keyword']) {
			$this->db->query("INSERT INTO " . DB_PREFIX . "url_alias SET query = 'manufacturer_id=" . (int)$manufacturer_id . "', keyword = '" . $this->db->escape($data['keyword']) . "'");
		}
		$this->cache->delete('manufacturer');
	}
	public function deleteManufacturer($manufacturer_id) {
		$this->db->query("DELETE FROM " . DB_PREFIX . "manufacturer WHERE manufacturer_id = '" . (int)$manufacturer_id . "'");
		$this->db->query("DELETE FROM " . DB_PREFIX . "manufacturer_to_store WHERE manufacturer_id = '" . (int)$manufacturer_id . "'");
		$this->db->query("DELETE FROM " . DB_PREFIX . "manufacturer_description WHERE manufacturer_id = '" . (int)$manufacturer_id . "'");
		$this->db->query("DELETE FROM " . DB_PREFIX . "url_alias WHERE query = 'manufacturer_id=" . (int)$manufacturer_id . "'");
		$this->cache->delete('manufacturer');
	}
	public function getManufacturer($manufacturer_id) {
		//$query = $this->db->query("SELECT DISTINCT *, (SELECT keyword FROM " . DB_PREFIX . "url_alias WHERE query = 'manufacturer_id=" . (int)$manufacturer_id . "') AS keyword FROM " . DB_PREFIX . "manufacturer WHERE manufacturer_id = '" . (int)$manufacturer_id . "'");
$query = $this->db->query("SELECT DISTINCT *, (SELECT keyword FROM " . DB_PREFIX . "url_alias WHERE query = 'manufacturer_id=" . (int)$manufacturer_id . "') AS keyword FROM " . DB_PREFIX . "manufacturer WHERE manufacturer_id = '" . (int)$manufacturer_id . "'");
		return $query->row;
	}
   public function getManufacturerDescriptions($manufacturer_id) {
         $category_description_data = array();
         $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "manufacturer_description WHERE manufacturer_id = '" . (int)$manufacturer_id . "'");
         foreach ($query->rows as $result) {
            $manufacturer_description_data[$result['language_id']] = array(
               'meta_description' => $result['meta_description'],
               'description'      => $result['description']
            );
         }
         return $manufacturer_description_data;
      }
	public function getManufacturers($data = array()) {
		if ($data) {
			$sql = "SELECT * FROM " . DB_PREFIX . "manufacturer";
			$sort_data = array(
				'name',
				'sort_order'
			);
			if (isset($data['sort']) && in_array($data['sort'], $sort_data)) {
				$sql .= " ORDER BY " . $data['sort'];
			} else {
				$sql .= " ORDER BY name";
			}
			if (isset($data['order']) && ($data['order'] == 'DESC')) {
				$sql .= " DESC";
			} else {
				$sql .= " ASC";
			}
			if (isset($data['start']) || isset($data['limit'])) {
				if ($data['start'] < 0) {
					$data['start'] = 0;
				}
				if ($data['limit'] < 1) {
					$data['limit'] = 20;
				}
				$sql .= " LIMIT " . (int)$data['start'] . "," . (int)$data['limit'];
			}
			$query = $this->db->query($sql);
			return $query->rows;
		} else {
			$manufacturer_data = $this->cache->get('manufacturer');
			if (!$manufacturer_data) {
				$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "manufacturer ORDER BY name");
				$manufacturer_data = $query->rows;
				$this->cache->set('manufacturer', $manufacturer_data);
			}
			return $manufacturer_data;
		}
	}
	public function getManufacturerStores($manufacturer_id) {
		$manufacturer_store_data = array();
		$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "manufacturer_to_store WHERE manufacturer_id = '" . (int)$manufacturer_id . "'");
		foreach ($query->rows as $result) {
			$manufacturer_store_data[] = $result['store_id'];
		}
		return $manufacturer_store_data;
	}
	public function getTotalManufacturersByImageId($image_id) {
      	$query = $this->db->query("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "manufacturer WHERE image_id = '" . (int)$image_id . "'");
		return $query->row['total'];
	}
	public function getTotalManufacturers() {
      	$query = $this->db->query("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "manufacturer");
		return $query->row['total'];
	}
}
?>

8. view/template/catalog/manufacturer_form.php вставляем этот код там где должен быть редактор.

<?php foreach ($languages as $language) { ?>
      <tr>
        <td width="25%"><?php echo $entry_meta_description; ?></td>
        <td><textarea name="manufacturer_description[<?php echo $language['language_id']; ?>][meta_description]" cols="40" rows="5"><?php echo @$manufacturer_description[$language['language_id']]['meta_description']; ?></textarea>
          <img src="view/image/flags/<?php echo $language['image']; ?>" title="<?php echo $language['name']; ?>" style="vertical-align: top;" /><br />
          <?php if (@$error_meta_description[$language['language_id']]) { ?>
          <span class="error"><?php echo $error_meta_description[$language['language_id']]; ?></span>
          <?php } ?></td>
      </tr>
      <tr>
        <td><?php echo $entry_description; ?></td>
        <td><textarea  name="manufacturer_description[<?php echo $language['language_id']; ?>][description]" id="description<?php echo $language['language_id']; ?>"><?php echo @$manufacturer_description[$language['language_id']]['description']; ?></textarea>
          <img src="view/image/flags/<?php echo $language['image']; ?>" title="<?php echo $language['name']; ?>" style="vertical-align: top;" />
          <?php if (@$error_description[$language['language_id']]) { ?>
          <span class="error"><?php echo $error_description[$language['language_id']]; ?></span>
          <?php } ?></td>
      </tr>
      <?php } ?>

И добавляем в самый низ , перед <?php $footer; ?> следующий код.

<script type="text/javascript" src="view/javascript/ckeditor/ckeditor.js"></script>
<script type="text/javascript"><!--
<?php foreach ($languages as $language) { ?>
CKEDITOR.replace('description<?php echo $language['language_id']; ?>', {
	filebrowserBrowseUrl: 'index.php?route=common/filemanager&token=<?php echo $token; ?>',
	filebrowserImageBrowseUrl: 'index.php?route=common/filemanager&token=<?php echo $token; ?>',
	filebrowserFlashBrowseUrl: 'index.php?route=common/filemanager&token=<?php echo $token; ?>',
	filebrowserUploadUrl: 'index.php?route=common/filemanager&token=<?php echo $token; ?>',
	filebrowserImageUploadUrl: 'index.php?route=common/filemanager&token=<?php echo $token; ?>',
	filebrowserFlashUploadUrl: 'index.php?route=common/filemanager&token=<?php echo $token; ?>'
});
<?php } ?>
//--></script>

Вроде и все.

Сергей Маркитаненко

Opencart. Выносим фрагмент шаблона в отдельный файл.

Opencart. Описание файлов в шаблоне

Доработка Opencart. Упрощаем регистрацию в Opencart.

Доработка Opencart. Создаем свое расширение