1 <?php
  2 
  3 /* --------------------------------------------------------------
  4    ProductAttributeRepositoryReader.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 ProductAttributeRepositoryReader
 15  *
 16  * @category   System
 17  * @package    ProductModule
 18  * @subpackage Reader
 19  */
 20 class ProductAttributeRepositoryReader implements ProductAttributeRepositoryReaderInterface
 21 {
 22     /**
 23      * @var CI_DB_query_builder
 24      */
 25     private $db;
 26 
 27     /**
 28      * @var ProductAttributeFactoryInterface
 29      */
 30     private $factory;
 31 
 32 
 33     /**
 34      * Initialize the product attribute repository reader.
 35      *
 36      * @param CI_DB_query_builder              $db
 37      * @param ProductAttributeFactoryInterface $factory
 38      */
 39     public function __construct(CI_DB_query_builder $db, ProductAttributeFactoryInterface $factory)
 40     {
 41         $this->db      = $db;
 42         $this->factory = $factory;
 43     }
 44 
 45 
 46     /**
 47      * Returns a product attribute entity by the given product attribute id.
 48      *
 49      * @param IdType $productAttributeId Id of expected product attribute entity.
 50      *
 51      * @throws UnexpectedValueException If the requested product attribute was not found.
 52      * @throws InvalidArgumentException If the provided attribute ID is not valid.
 53      *
 54      * @return StoredProductAttributeInterface Expected product attribute entity.
 55      */
 56     public function getAttributeById(IdType $productAttributeId)
 57     {
 58         $dataArray = $this->db->get_where('products_attributes',
 59                                           array('products_attributes_id' => $productAttributeId->asInt()))->row_array();
 60 
 61         if(null === $dataArray)
 62         {
 63             throw new UnexpectedValueException('The requested product attribute was not found in database (ID:'
 64                                                . $productAttributeId->asInt()
 65                                                . ')');
 66         }
 67 
 68         $storedProductAttribute = $this->factory->createStoredProductAttribute($productAttributeId);
 69         $this->_callStoredProductAttributeSetter($storedProductAttribute, $dataArray);
 70 
 71         return $storedProductAttribute;
 72     }
 73 
 74 
 75     /**
 76      * Returns a collection with all product attribute entities which belongs to the product entity by the given
 77      * product id.
 78      *
 79      * @param IdType $productId Id of product entity which belongs to the expected product attribute entities.
 80      *
 81      * @throws UnexpectedValueException If the requested attributes were not found.
 82      * @throws InvalidArgumentException If the provided product ID ist not valid.
 83      *
 84      * @return StoredProductAttributeCollection Collection which contains all expected product attribute entities.
 85      */
 86     public function getAttributesByProductId(IdType $productId)
 87     {
 88         $dataArray =
 89             $this->db->get_where('products_attributes', array('products_id' => $productId->asInt()))->result_array();
 90 
 91         if(count($dataArray) === 0)
 92         {
 93             throw new UnexpectedValueException('The requested product attribute was not found in database (ID:'
 94                                                . $productId->asInt()
 95                                                . ')');
 96         }
 97 
 98         $storedProductAttributesArray = array();
 99 
100         foreach($dataArray as $data)
101         {
102             $storedProductAttribute = $this->factory->createStoredProductAttribute(new IdType($data['products_id']));
103             $this->_callStoredProductAttributeSetter($storedProductAttribute, $data);
104 
105             $storedProductAttributesArray[] = $storedProductAttribute;
106         }
107 
108         return MainFactory::create('StoredProductAttributeCollection', $storedProductAttributesArray);
109     }
110 
111 
112     /**
113      * Call the setter of the stored product attribute entity.
114      *
115      * @param StoredProductAttributeInterface $storedProductAttribute
116      * @param array                            $data
117      *
118      * @throws InvalidArgumentException IF the provided product attribute is not valid.
119      *
120      * @return ProductAttributeRepositoryReader|$this Same instance for chained method calls.
121      */
122     protected function _callStoredProductAttributeSetter(StoredProductAttributeInterface $storedProductAttribute, $data)
123     {
124         $storedProductAttribute->setOptionId(new IdType($data['options_id']));
125         $storedProductAttribute->setOptionValueId(new IdType($data['options_values_id']));
126         $storedProductAttribute->setPrice(new DecimalType($data['options_values_price']));
127         $storedProductAttribute->setPriceType(new StringType((string)$data['price_prefix']));
128         $storedProductAttribute->setAttributeModel(new StringType((string)$data['attributes_model']));
129         $storedProductAttribute->setStock(new DecimalType((float)$data['attributes_stock']));
130         $storedProductAttribute->setWeight(new DecimalType($data['options_values_weight']));
131         $storedProductAttribute->setWeightType(new StringType((string)$data['weight_prefix']));
132         $storedProductAttribute->setSortOrder(new IntType((int)$data['sortorder']));
133         $storedProductAttribute->setVpeId(new IdType($data['products_vpe_id']));
134         $storedProductAttribute->setVpeValue(new DecimalType($data['gm_vpe_value']));
135         $storedProductAttribute->setAttributeEan(new StringType((string)$data['gm_ean']));
136 
137         return $this;
138     }
139 }

API documentation generated by ApiGen