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 

<?php
/* --------------------------------------------------------------
 ParcelTrackingCodeFinder.inc.php 2018-01-15
 Gambio GmbH
 http://www.gambio.de
 Copyright (c) 2018 Gambio GmbH
 Released under the GNU General Public License (Version 2)
 [http://www.gnu.org/licenses/gpl-2.0.html]
 --------------------------------------------------------------
 */

/**
 * Class ParcelTrackingCodeFinder
 */
class ParcelTrackingCodeFinder
{
    /**
     * @var \CI_DB_query_builder
     */
    protected $db;
    
    /**
     * @var string
     */
    protected $table = 'orders_parcel_tracking_codes';
    
    
    /**
     * ParcelTrackingCodeFinder constructor.
     *
     * @param \CI_DB_query_builder $db Database access.
     */
    public function __construct(CI_DB_query_builder $db)
    {
        $this->db = $db;
    }
    
    
    /**
     * Returns parcel tracking code data by the given tracking code id.
     *
     * @param \ParcelTrackingCodeId $id Id of searched parcel tracking code entry.
     *
     * @return array
     */
    public function find(ParcelTrackingCodeId $id)
    {
        return $this->db->where('orders_parcel_tracking_code_id', $id->is())->get($this->table)->row_array() ? : [];
    }
    
    
    /**
     * Returns parcel tracking codes data by the given order id.
     *
     * @param \ParcelTrackingCodeOrderId $orderId Id of order.
     *
     * @return array
     */
    public function findByOrderId(ParcelTrackingCodeOrderId $orderId)
    {
        return $this->db->where('order_id', $orderId->is())->get($this->table)->result_array() ? : [];
    }
    
    
    /**
     * Returns all parcel tracking code data.
     *
     * @return array
     */
    public function getAll()
    {
        return $this->db->get($this->table)->result_array() ? : [];
    }
}