1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129
<?php
MainFactory::load_class('OrderItemAttributeRepositoryReaderInterface');
class OrderItemAttributeRepositoryReader implements OrderItemAttributeRepositoryReaderInterface
{
protected $orderItemAttributeFactory;
protected $db;
protected $table = 'orders_products_attributes';
protected $key = 'orders_products_attributes_id';
public function __construct(CI_DB_query_builder $db, OrderItemAttributeFactoryInterface $orderItemAttributeFactory)
{
$this->db = $db;
$this->orderItemAttributeFactory = $orderItemAttributeFactory;
}
public function getAttributeById(IdType $orderItemAttributeId)
{
$data = $this->db->where($this->key, $orderItemAttributeId->asInt())->get($this->table)->row_array();
if(empty($data))
{
throw new UnexpectedValueException('No order item attribute record matches the provided $orderItemAttributeId: '
. $orderItemAttributeId->asInt());
}
return $this->_createStoredOrderItemAttribute($data);
}
public function getAttributesByOrderItemId(IdType $orderItemId)
{
$storedOrderItemAttributes = array();
$results = $this->db->where('orders_products_id', $orderItemId->asInt())->get($this->table);
foreach($results->result_array() as $result)
{
$storedOrderItemAttributes[] = $this->_createStoredOrderItemAttribute($result);
}
$storedOrderItemAttributeCollection = MainFactory::create('StoredOrderItemAttributeCollection',
$storedOrderItemAttributes);
return $storedOrderItemAttributeCollection;
}
protected function _createStoredOrderItemAttribute(array $storedOrderItemAttributeData)
{
$orderItemAttributeId = new IdType($storedOrderItemAttributeData[$this->key]);
$storedOrderItemAttribute = $this->orderItemAttributeFactory->createStoredOrderItemAttribute($orderItemAttributeId);
$storedOrderItemAttribute->setName(new StringType($storedOrderItemAttributeData['products_options']));
$storedOrderItemAttribute->setValue(new StringType($storedOrderItemAttributeData['products_options_values']));
$storedOrderItemAttribute->setPrice(new DecimalType($storedOrderItemAttributeData['options_values_price']));
$storedOrderItemAttribute->setPriceType(new StringType($storedOrderItemAttributeData['price_prefix']));
$storedOrderItemAttribute->setOptionId(new IdType($storedOrderItemAttributeData['options_id']));
$storedOrderItemAttribute->setOptionValueId(new IdType($storedOrderItemAttributeData['options_values_id']));
return $storedOrderItemAttribute;
}
}