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
/* --------------------------------------------------------------
OrderTotalRepositoryReader.inc.php 2015-11-16
Gambio GmbH
http://www.gambio.de
Copyright (c) 2015 Gambio GmbH
Released under the GNU General Public License (Version 2)
[http://www.gnu.org/licenses/gpl-2.0.html]
--------------------------------------------------------------
*/
MainFactory::load_class('OrderTotalRepositoryReaderInterface');
/**
* Class OrderTotalRepositoryReader
*
* @category System
* @package Order
* @subpackage Repositories
*/
class OrderTotalRepositoryReader implements OrderTotalRepositoryReaderInterface
{
/**
* Order total factory.
* @var OrderTotalFactory
*/
protected $orderTotalFactory;
/**
* Query builder.
* @var CI_DB_query_builder
*/
protected $db;
/**
* Table.
* @var string
*/
protected $table = 'orders_total';
/**
* ID column.
* @var string
*/
protected $key = 'orders_total_id';
/**
* OrderTotalRepositoryReader constructor.
*
* @param CI_DB_query_builder $db Query builder.
* @param OrderTotalFactoryInterface $orderTotalFactory Order total factory.
*/
public function __construct(CI_DB_query_builder $db, OrderTotalFactoryInterface $orderTotalFactory)
{
$this->db = $db;
$this->orderTotalFactory = $orderTotalFactory;
}
/**
* Returns an StoredOrderTotal object by the given ID.
*
* @param IdType $orderTotalId ID of order total item.
*
* @throws UnexpectedValueException If record does not exist.
* @return StoredOrderTotal Fetched order total.
*/
public function getTotalById(IdType $orderTotalId)
{
$data = $this->db->where($this->key, $orderTotalId->asInt())->get($this->table)->row_array();
if(empty($data))
{
throw new UnexpectedValueException('No order total record matches the provided $orderTotalId: '
. $orderTotalId->asInt());
}
return $this->_createStoredOrderTotalItem($data);
}
/**
* Returns a StoredOrderTotalCollection of StoredOrderTotal objects by the given order ID.
*
* @param IdType $orderOrderId ID of order item.
*
* @return StoredOrderTotalCollection Fetched order total collection.
*/
public function getTotalsByOrderId(IdType $orderOrderId)
{
$storedOrderTotalItems = array();
$results = $this->db->where('orders_id', $orderOrderId->asInt())
->order_by('sort_order ASC')
->order_by('orders_total_id ASC')
->get($this->table);
foreach($results->result_array() as $result)
{
$storedOrderTotalItems[] = $this->_createStoredOrderTotalItem($result);
}
$storedOrderTotalCollection = MainFactory::create('StoredOrderTotalCollection', $storedOrderTotalItems);
return $storedOrderTotalCollection;
}
/**
* Creates a StoredOrderTotal instance based on the given result set array.
*
* @param array $storedOrderTotalData Result set from database.
*
* @return StoredOrderTotal Created order total.
*/
protected function _createStoredOrderTotalItem(array $storedOrderTotalData)
{
$storedOrderTotal = $this->orderTotalFactory->createStoredOrderTotal(new IdType($storedOrderTotalData[$this->key]));
$storedOrderTotal->setTitle(new StringType($storedOrderTotalData['title']));
$storedOrderTotal->setValueText(new StringType($storedOrderTotalData['text']));
$storedOrderTotal->setValue(new DecimalType($storedOrderTotalData['value']));
$storedOrderTotal->setClass(new StringType($storedOrderTotalData['class']));
$storedOrderTotal->setSortOrder(new IntType($storedOrderTotalData['sort_order']));
return $storedOrderTotal;
}
}