File CoreServices/Order/Repositories/Writer/OrderItemAttributeRepositoryWriter.inc.php

  1 <?php
  2 
  3 /* --------------------------------------------------------------
  4    OrderItemAttributeRepositoryWriter.inc.php 2015-11-11
  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 MainFactory::load_class('OrderItemAttributeRepositoryWriterInterface');
 14 
 15 /**
 16  * Class OrderItemAttributeRepositoryWriter
 17  *
 18  * @category   System
 19  * @package    Order
 20  * @subpackage Repositories
 21  */
 22 class OrderItemAttributeRepositoryWriter implements OrderItemAttributeRepositoryWriterInterface
 23 {
 24     /**
 25      * Query builder.
 26      * @var CI_DB_query_builder
 27      */
 28     protected $db;
 29 
 30     /**
 31      * Table.
 32      * @var string
 33      */
 34     protected $table = 'orders_products_attributes';
 35 
 36 
 37     /**
 38      * OrderItemAttributeRepositoryWriter constructor.
 39      *
 40      * @param CI_DB_query_builder $dbQueryBuilder Query builder.
 41      */
 42     public function __construct(CI_DB_query_builder $dbQueryBuilder)
 43     {
 44         $this->db = $dbQueryBuilder;
 45     }
 46 
 47 
 48     /**
 49      * Adds a new attribute to the order item.
 50      *
 51      * @param IdType             $orderItemId        ID of the order item.
 52      * @param OrderItemAttribute $orderItemAttribute Attribute to add.
 53      *
 54      * @return int ID of stored order item attribute.
 55      */
 56     public function insertIntoOrderItem(IdType $orderItemId, OrderItemAttribute $orderItemAttribute)
 57     {
 58         $orderItemIdValue = $orderItemId->asInt();
 59         $result           = $this->db->get_where('orders_products', array('orders_products_id' => $orderItemIdValue))
 60                                      ->row_array();
 61 
 62         $columnValueArray = array(
 63             'orders_products_id'      => $orderItemIdValue,
 64             'orders_id'               => $result['orders_id'],
 65             'products_options'        => $orderItemAttribute->getName(),
 66             'products_options_values' => $orderItemAttribute->getValue(),
 67             'options_values_price'    => $orderItemAttribute->getPrice(),
 68             'price_prefix'            => $orderItemAttribute->getPriceType(),
 69             'options_id'              => $orderItemAttribute->getOptionId(),
 70             'options_values_id'       => $orderItemAttribute->getOptionValueId(),
 71         );
 72 
 73         $this->db->insert($this->table, $columnValueArray);
 74 
 75         return $this->db->insert_id();
 76     }
 77 
 78 
 79     /**
 80      * Updates the stored order item attribute.
 81      *
 82      * @param StoredOrderItemAttribute $orderItemAttribute Order item attribute.
 83      *
 84      * @return OrderItemAttributeRepositoryWriter Same instance for method chaining.
 85      */
 86     public function update(StoredOrderItemAttribute $orderItemAttribute)
 87     {
 88         $columnValueArray = array(
 89             'products_options'        => $orderItemAttribute->getName(),
 90             'products_options_values' => $orderItemAttribute->getValue(),
 91             'options_values_price'    => $orderItemAttribute->getPrice(),
 92             'price_prefix'            => $orderItemAttribute->getPriceType(),
 93             'options_id'              => $orderItemAttribute->getOptionId(),
 94             'options_values_id'       => $orderItemAttribute->getOptionValueId(),
 95         );
 96 
 97         $this->db->update($this->table, $columnValueArray,
 98                           array('orders_products_attributes_id' => $orderItemAttribute->getOrderItemAttributeId()));
 99 
100         return $this;
101     }
102 }
Packages

Classes

Interfaces

Exceptions
