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 

<?php
/* --------------------------------------------------------------
   AgreementReader.inc.php 2018-05-16
   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 AgreementReader
 *
 * @category   System
 * @package    Agreement
 * @subpackage Repositories
 */
class AgreementReader implements AgreementReaderInterface
{
    /**
     * @var \CI_DB_query_builder
     */
    protected $queryBuilder;
    
    
    /**
     * AgreementReader constructor.
     *
     * @param \CI_DB_query_builder $queryBuilder
     */
    public function __construct(CI_DB_query_builder $queryBuilder)
    {
        $this->queryBuilder = $queryBuilder;
    }
    
    
    /**
     * Returns all agreement entities as an array.
     *
     * @return array
     */
    public function getAll()
    {
        $agreements = [];
        $rawData    = $this->queryBuilder->select()->from('agreements')->get()->result_array();
        foreach($rawData as $row)
        {
            $agreements[] = $this->_buildAgreementDataArray($row);
        }
        
        return $agreements;
    }
    
    
    /**
     * Returns an agreement entity  by the provided id.
     *
     * @param \IdType $id
     *
     * @throws \EntityNotFoundException
     *
     * @return array
     */
    public function getById(IdType $id)
    {
        $rawData = $this->queryBuilder->select()
                                      ->from('agreements')
                                      ->where('agreements.agreements_id', $id->asInt())
                                      ->get()
                                      ->row_array();
        
        if($rawData === null)
        {
            throw new EntityNotFoundException('Agreement entity was not found with provided id "' . $id->asInt() . '"');
        }
        
        return $this->_buildAgreementDataArray($rawData);
    }
    
    
    /**
     * Returns the agreements by the provided customer email address.
     *
     * @param \StringType $customerEmailAddress
     *
     * @return array
     */
    public function getAgreementsByCustomerEmail(StringType $customerEmailAddress)
    {
        $agreements = [];
        $rawData    = $this->queryBuilder->select()
                                         ->from('agreements')
                                         ->where('customers_email', $customerEmailAddress->asString())
                                         ->get()
                                         ->result_array();
        foreach($rawData as $data)
        {
            $agreements[] = $this->_buildAgreementDataArray($data);
        }
        
        return $agreements;
    }
    
    
    /**
     * @param $rawDataArray
     *
     * @return array
     */
    protected function _buildAgreementDataArray($rawDataArray)
    {
        return [
            'id'               => $rawDataArray['agreements_id'],
            'dateAdded'        => $rawDataArray['date_added'],
            'lastModified'     => $rawDataArray['last_modified'],
            'ipAddress'        => $rawDataArray['ip_address'],
            'text'             => $rawDataArray['text'],
            'legalTextVersion' => $rawDataArray['legal_text_version'],
            'contentGroup'     => $rawDataArray['content_group'],
            'languageId'       => $rawDataArray['language_id'],
            'customer'         => [
                'customerName'  => $rawDataArray['customers_name'],
                'customerEmail' => $rawDataArray['customers_email']
            ]
        ];
    }
}