File CoreServices/ProductModule/Repositories/Writer/ProductAttributeRepositoryWriter.inc.php

  1 <?php
  2 
  3 /* --------------------------------------------------------------
  4    ProductAttributeRepositoryWriter.inc.php 2016-01-08
  5    Gambio GmbH
  6    http://www.gambio.de
  7    Copyright (c) 2015 Gambio GmbH
  8    Released under the GNU General Public License (Version 2)
  9    [http://www.gnu.org/licenses/gpl-2.0.html]
 10    --------------------------------------------------------------
 11 */
 12 
 13 /**
 14  * Class ProductAttributeRepositoryWriter
 15  *
 16  * @category   System
 17  * @package    ProductModule
 18  * @subpackage Writer
 19  */
 20 class ProductAttributeRepositoryWriter implements ProductAttributeRepositoryWriterInterface
 21 {
 22     /**
 23      * @var CI_DB_query_builder
 24      */
 25     protected $db;
 26 
 27     /**
 28      * @var string
 29      */
 30     protected $tableName = 'products_attributes';
 31 
 32 
 33     /**
 34      * Initialize the product attribute repository writer.
 35      *
 36      * @param CI_DB_query_builder $db
 37      */
 38     public function __construct(CI_DB_query_builder $db)
 39     {
 40         $this->db = $db;
 41     }
 42 
 43 
 44     /**
 45      * Adds a product attribute entity to a product by the given product id.
 46      *
 47      * @param IdType                    $productId         Id of product entity which should belongs to the added
 48      *                                                     attributes.
 49      * @param ProductAttributeInterface $productAttribute  Product attribute entity to add to the product.
 50      *
 51      * @return int Id of the stored product attribute.
 52      */
 53     public function insertIntoProduct(IdType $productId, ProductAttributeInterface $productAttribute)
 54     {
 55         $dataArray = array(
 56             'products_id'           => $productId->asInt(),
 57             'options_id'            => $productAttribute->getOptionId(),
 58             'options_values_id'     => $productAttribute->getOptionValueId(),
 59             'options_values_price'  => $productAttribute->getPrice(),
 60             'price_prefix'          => $productAttribute->getPriceType(),
 61             'attributes_model'      => $productAttribute->getAttributeModel(),
 62             'attributes_stock'      => $productAttribute->getStock(),
 63             'options_values_weight' => $productAttribute->getWeight(),
 64             'weight_prefix'         => $productAttribute->getWeightType(),
 65             'sortorder'             => $productAttribute->getSortOrder(),
 66             'products_vpe_id'       => $productAttribute->getVpeId(),
 67             'gm_vpe_value'          => $productAttribute->getVpeValue(),
 68             'gm_ean'                => $productAttribute->getAttributeEan(),
 69         );
 70 
 71         $this->db->insert($this->tableName, $dataArray);
 72 
 73         return $this->db->insert_id();
 74     }
 75 
 76 
 77     /**
 78      * Updates a product attribute entity.
 79      *
 80      * @param StoredProductAttributeInterface $productAttribute Product attribute entity to update.
 81      *
 82      * @return ProductAttributeRepositoryWriter|$this Same instance for chained method calls.
 83      */
 84     public function update(StoredProductAttributeInterface $productAttribute)
 85     {
 86         $dataArray = array(
 87             'options_id'            => $productAttribute->getOptionId(),
 88             'options_values_id'     => $productAttribute->getOptionValueId(),
 89             'options_values_price'  => $productAttribute->getPrice(),
 90             'price_prefix'          => $productAttribute->getPriceType(),
 91             'attributes_model'      => $productAttribute->getAttributeModel(),
 92             'attributes_stock'      => $productAttribute->getStock(),
 93             'options_values_weight' => $productAttribute->getWeight(),
 94             'weight_prefix'         => $productAttribute->getWeightType(),
 95             'sortorder'             => $productAttribute->getSortOrder(),
 96             'products_vpe_id'       => $productAttribute->getVpeId(),
 97             'gm_vpe_value'          => $productAttribute->getVpeValue(),
 98             'gm_ean'                => $productAttribute->getAttributeEan(),
 99         );
100 
101         $this->db->update($this->tableName, $dataArray,
102                           array('products_attributes_id' => $productAttribute->getAttributeId()));
103 
104         return $this;
105     }
106 }
Packages

Classes

Interfaces

Exceptions
