<?php
 class ent_manufacturer { public $data; public $previous; public function __construct($manufacturer_id='') { if (!empty($manufacturer_id)) { $this->load($manufacturer_id); } else { $this->reset(); } } public function reset() { $this->data = []; $manufacturer_query = database::query( "show fields from ". DB_TABLE_PREFIX ."manufacturers;" ); while ($field = database::fetch($manufacturer_query)) { $this->data[$field['Field']] = database::create_variable($field); } $manufacturer_info_query = database::query( "show fields from ". DB_TABLE_PREFIX ."manufacturers_info;" ); while ($field = database::fetch($manufacturer_info_query)) { if (in_array($field['Field'], ['id', 'manufacturer_id', 'language_code'])) continue; $this->data[$field['Field']] = []; foreach (array_keys(language::$languages) as $language_code) { $this->data[$field['Field']][$language_code] = database::create_variable($field); } } $this->previous = $this->data; } public function load($manufacturer_id) { if (!preg_match('#^[0-9]+$#', $manufacturer_id)) throw new Exception('Invalid manufacturer (ID: '. $manufacturer_id .')'); $this->reset(); $manufacturers_query = database::query( "select * from ". DB_TABLE_PREFIX ."manufacturers
        where id = ". (int)$manufacturer_id ."
        limit 1;" ); if ($manufacturer = database::fetch($manufacturers_query)) { $this->data = array_replace($this->data, array_intersect_key($manufacturer, $this->data)); } else { throw new Exception('Could not find manufacturer (ID: '. (int)$manufacturer_id .') in database.'); } $manufacturers_info_query = database::query( "select * from ". DB_TABLE_PREFIX ."manufacturers_info
        where manufacturer_id = ". (int)$manufacturer_id .";" ); while ($manufacturer_info = database::fetch($manufacturers_info_query)) { foreach ($manufacturer_info as $key => $value) { if (in_array($key, ['id', 'manufacturer_id', 'language_code'])) continue; $this->data[$key][$manufacturer_info['language_code']] = $value; } } $this->previous = $this->data; } public function save() { if (empty($this->data['id'])) { database::query( "insert into ". DB_TABLE_PREFIX ."manufacturers
          (date_created)
          values ('". ($this->data['date_created'] = date('Y-m-d H:i:s')) ."');" ); $this->data['id'] = database::insert_id(); } $this->data['keywords'] = preg_split('#\s*,\s*#', $this->data['keywords'], -1, PREG_SPLIT_NO_EMPTY); $this->data['keywords'] = array_unique($this->data['keywords']); $this->data['keywords'] = implode(',', $this->data['keywords']); database::query( "update ". DB_TABLE_PREFIX ."manufacturers set
        status = ". (int)$this->data['status'] .",
        featured = ". (int)$this->data['featured'] .",
        code = '". database::input($this->data['code']) ."',
        name = '". database::input($this->data['name']) ."',
        image = '". database::input($this->data['image']) ."',
        keywords = '". database::input($this->data['keywords']) ."'
        where id = ". (int)$this->data['id'] ."
        limit 1;" ); foreach (array_keys(language::$languages) as $language_code) { $manufacturers_info_query = database::query( "select * from ". DB_TABLE_PREFIX ."manufacturers_info
          where manufacturer_id = ". (int)$this->data['id'] ."
          and language_code = '". database::input($language_code) ."'
          limit 1;" ); if (!$manufacturer_info = database::fetch($manufacturers_info_query)) { database::query( "insert into ". DB_TABLE_PREFIX ."manufacturers_info
            (manufacturer_id, language_code)
            values (". (int)$this->data['id'] .", '". database::input($language_code) ."');" ); } database::query( "update ". DB_TABLE_PREFIX ."manufacturers_info set
          short_description = '". database::input($this->data['short_description'][$language_code]) ."',
          description = '". database::input($this->data['description'][$language_code], true) ."',
          head_title = '". database::input($this->data['head_title'][$language_code]) ."',
          h1_title = '". database::input($this->data['h1_title'][$language_code]) ."',
          meta_description = '". database::input($this->data['meta_description'][$language_code]) ."',
          link = '". database::input($this->data['link'][$language_code]) ."'
          where manufacturer_id = ". (int)$this->data['id'] ."
          and language_code = '". database::input($language_code) ."'
          limit 1;" ); } $this->previous = $this->data; cache::clear_cache('manufacturers'); } public function save_image($file) { if (empty($file)) return; if (empty($this->data['id'])) { $this->save(); } if (!is_dir(FS_DIR_STORAGE . 'images/manufacturers/')) mkdir(FS_DIR_STORAGE . 'images/manufacturers/', 0777); $image = new ent_image($file); $filename = 'manufacturers/' . $this->data['id'] .'-'. functions::format_path_friendly($this->data['name'], settings::get('store_language_code')) .'.'. $image->type(); if (is_file(FS_DIR_STORAGE . 'images/' . $this->data['image'])) unlink(FS_DIR_STORAGE . 'images/' . $this->data['image']); functions::image_delete_cache(FS_DIR_STORAGE . 'images/' . $filename); if (settings::get('image_downsample_size')) { list($width, $height) = preg_split('#\s*,\s*#', settings::get('image_downsample_size'), -1, PREG_SPLIT_NO_EMPTY); $image->resample($width, $height, 'FIT_ONLY_BIGGER'); } $image->write(FS_DIR_STORAGE . 'images/' . $filename, 90); database::query( "update ". DB_TABLE_PREFIX ."manufacturers
        set image = '". database::input($filename) ."'
        where id = ". (int)$this->data['id'] .";" ); $this->previous['image'] = $this->data['image'] = $filename; } public function delete_image() { if (empty($this->data['id'])) return; if (is_file(FS_DIR_STORAGE . 'images/' . $this->data['image'])) unlink(FS_DIR_STORAGE . 'images/' . $this->data['image']); functions::image_delete_cache(FS_DIR_STORAGE . 'images/' . $this->data['image']); database::query( "update ". DB_TABLE_PREFIX ."manufacturers
        set image = ''
        where id = ". (int)$this->data['id'] .";" ); $this->previous['image'] = $this->data['image'] = ''; } public function delete() { if (empty($this->data['id'])) return; $products_query = database::query( "select id from ". DB_TABLE_PREFIX ."products
        where manufacturer_id = ". (int)$this->data['id'] ."
        limit 1;" ); if (database::num_rows($products_query)) { throw new Exception(language::translate('error_cannot_delete_manfacturer_while_used_by_products', 'The manufacturer could not be deleted because there are products linked to it.')); } if (!empty($this->data['image']) && is_file(FS_DIR_STORAGE . 'images/manufacturers/' . $this->data['image'])) { unlink(FS_DIR_STORAGE . 'images/manufacturers/' . $this->data['image']); } database::query( "delete from ". DB_TABLE_PREFIX ."manufacturers
        where id = ". (int)$this->data['id'] ."
        limit 1;" ); database::query( "delete from ". DB_TABLE_PREFIX ."manufacturers_info
        where manufacturer_id = ". (int)$this->data['id'] .";" ); $this->reset(); cache::clear_cache('manufacturers'); } } 