1 <?php
  2 /* --------------------------------------------------------------
  3    OrderRepositoryReader.inc.php 2016-02-16
  4    Gambio GmbH
  5    http://www.gambio.de
  6    Copyright (c) 2016 Gambio GmbH
  7    Released under the GNU General Public License (Version 2)
  8    [http://www.gnu.org/licenses/gpl-2.0.html]
  9    --------------------------------------------------------------
 10 */
 11 
 12 MainFactory::load_class('OrderRepositoryReaderInterface');
 13 
 14 /**
 15  * Class OrderRepositoryReader
 16  *
 17  * @category   System
 18  * @package    Order
 19  * @subpackage Repositories
 20  */
 21 class OrderRepositoryReader implements OrderRepositoryReaderInterface
 22 {
 23     /**
 24      * Query builder.
 25      * @var CI_DB_query_builder
 26      */
 27     protected $db;
 28     
 29     /**
 30      * Order factory.
 31      * @var OrderFactory
 32      */
 33     protected $orderFactory;
 34     
 35     /**
 36      * Country service.
 37      * @var CountryServiceInterface
 38      */
 39     protected $countryService;
 40     
 41     
 42     /**
 43      * OrderRepositoryReader constructor.
 44      *
 45      * @param CI_DB_query_builder     $db             Query builder.
 46      * @param OrderFactoryInterface   $orderFactory   Order factory.
 47      * @param CountryServiceInterface $countryService Country service.
 48      */
 49     public function __construct(CI_DB_query_builder $db,
 50                                 OrderFactoryInterface $orderFactory,
 51                                 CountryServiceInterface $countryService)
 52     {
 53         $this->db             = $db;
 54         $this->orderFactory   = $orderFactory;
 55         $this->countryService = $countryService;
 56     }
 57     
 58     
 59     /**
 60      * Fetches an new order object from the orders table by the given ID.
 61      *
 62      * @param IdType $orderId ID of the expected order.
 63      *
 64      * @return GXEngineOrder Fetched order.
 65      * @throws UnexpectedValueException If no entry has been found.
 66      */
 67     public function getById(IdType $orderId)
 68     {
 69         $this->db->select('orders.*, languages.code AS language_code')
 70                  ->from('orders')
 71                  ->join('languages', 'languages.directory = orders.language', 'inner')
 72                  ->where('orders_id', $orderId->asInt());
 73         
 74         $data = $this->db->get()->row_array();
 75         
 76         if($data === null)
 77         {
 78             throw new UnexpectedValueException('The requested Order was not found in database (ID:' . $orderId->asInt()
 79                                                . ')');
 80         }
 81         
 82         $order = $this->_createOrderByArray($data);
 83         
 84         return $order;
 85     }
 86     
 87     
 88     /**
 89      * Creates an order instance.
 90      *
 91      * @param array $data Order data.
 92      *
 93      * @return GXEngineOrder Created order object.
 94      */
 95     protected function _createOrderByArray(array $data)
 96     {
 97         $order = $this->orderFactory->createOrder();
 98         
 99         // Set IDs
100         $order->setOrderId(new IdType($data['orders_id']));
101         $order->setCustomerId(new IdType($data['customers_id']));
102         $order->setStatusId(new IdType($data['orders_status']));
103         
104         // Customer Status Information
105         $isGuest                   = ((int)$data['account_type'] === 1 || (int)$data['customers_status'] === 1);
106         $customerStatusInformation = MainFactory::create('CustomerStatusInformation',
107                                                          new IdType((int)$data['customers_status']),
108                                                          new StringType((string)$data['customers_status_name']),
109                                                          new StringType((string)$data['customers_status_image']),
110                                                          new DecimalType((double)$data['customers_status_discount']),
111                                                          new BoolType($isGuest));
112         $order->setCustomerStatusInformation($customerStatusInformation);
113         
114         // Address Information
115         $customerAddress = $this->_getOrderAddressBlock($data, new StringType('customers'));
116         $order->setCustomerAddress($customerAddress);
117         $billingAddress = $this->_getOrderAddressBlock($data, new StringType('billing'));
118         $order->setBillingAddress($billingAddress);
119         $deliveryAddress = $this->_getOrderAddressBlock($data, new StringType('delivery'));
120         $order->setDeliveryAddress($deliveryAddress);
121         $paymentType = MainFactory::create('OrderPaymentType', new StringType($data['payment_method']),
122                                            new StringType($data['payment_class']));
123         
124         // Payment & Shipping Type
125         $order->setPaymentType($paymentType);
126         $shippingType = MainFactory::create('OrderShippingType', new StringType($data['shipping_method']),
127                                             new StringType($data['shipping_class']));
128         $order->setShippingType($shippingType);
129         
130         // Miscellaneous Values
131         $order->setCustomerNumber(new StringType((string)$data['customers_cid']));
132         $order->setCustomerEmail(new EmailStringType($data['customers_email_address']));
133         $order->setCustomerTelephone(new StringType($data['customers_telephone']));
134         $order->setVatIdNumber(new StringType((string)$data['customers_vat_id']));
135         
136         $order->setCurrencyCode(MainFactory::create('CurrencyCode', new NonEmptyStringType((string)$data['currency']),
137                                                     new DecimalType((double)$data['currency_value'])));
138         $order->setLanguageCode(new LanguageCode(new NonEmptyStringType($data['language_code'])));
139         $order->setPurchaseDateTime(new DateTime((string)$data['date_purchased']));
140         $order->setLastModifiedDateTime(new DateTime((string)$data['last_modified']));
141         $order->setComment(new StringType((string)$data['comments']));
142         $order->setOrderHash(new StringType($data['orders_hash']));
143         
144         return $order;
145     }
146     
147     
148     /**
149      * Returns order address block instance for the customer, billing and delivery address.
150      *
151      * @param array      $data   Contains the order data that came directly from the database.
152      * @param StringType $prefix Must be one of "customers", "billing" and "delivery" (look at the "orders" db table).
153      *
154      * @return AddressBlock Instance of an address block that contains the address values.
155      */
156     protected function _getOrderAddressBlock(array $data, StringType $prefix)
157     {
158         $addressPrefix = $prefix->asString() . '_';
159         
160         $country = $this->countryService->getCountryByName($data[$addressPrefix . 'country']);
161         $zone    = $this->countryService->getUnknownCountryZoneByName((string)$data[$addressPrefix . 'state']);
162         
163         return MainFactory::create('AddressBlock', new CustomerGender($data[$addressPrefix . 'gender']),
164                                    new CustomerFirstname($data[$addressPrefix . 'firstname']),
165                                    new CustomerLastname($data[$addressPrefix . 'lastname']),
166                                    new CustomerCompany((string)$data[$addressPrefix . 'company']),
167                                    new CustomerB2BStatus(false),
168                                    new CustomerStreet($data[$addressPrefix . 'street_address']),
169                                    new CustomerSuburb((string)$data[$addressPrefix . 'suburb']),
170                                    new CustomerPostcode($data[$addressPrefix . 'postcode']),
171                                    new CustomerCity($data[$addressPrefix . 'city']), $country, $zone);
172     }
173 }

API documentation generated by ApiGen