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 

<?php

/* --------------------------------------------------------------
   StaticSeoUrlContentRepositoryReader.inc.php 2017-05-24
   Gambio GmbH
   http://www.gambio.de
   Copyright (c) 2017 Gambio GmbH
   Released under the GNU General Public License (Version 2)
   [http://www.gnu.org/licenses/gpl-2.0.html]
   --------------------------------------------------------------
*/

/**
 * Class StaticSeoUrlContentRepositoryReader
 *
 * @category   System
 * @package    StaticSeoUrl
 * @subpackage Repositories
 */
class StaticSeoUrlContentRepositoryReader implements StaticSeoUrlContentRepositoryReaderInterface
{
    /**
     * Table name
     *
     * @var string
     */
    protected $table = 'static_seo_url_contents';
    
    /**
     * Query builder.
     *
     * @var CI_DB_query_builder
     */
    protected $db;
    
    
    /**
     * StaticSeoUrlContentRepositoryReader constructor.
     *
     * @param CI_DB_query_builder $db
     */
    public function __construct(CI_DB_query_builder $db)
    {
        $this->db = $db;
    }
    
    
    /**
     * Returns a StaticSeoUrlContentCollection for the given StaticSeoUrl ID.
     *
     * @param IdType $staticSeoUrlId
     *
     * @throws UnexpectedValueException
     * @throws InvalidArgumentException
     *
     * @return StaticSeoUrlContentCollection All staticSeoUrlContents found by the staticSeoUrlId ID as a
     *                                       StaticSeoUrlContentCollection.
     */
    public function getByStaticSeoUrlId(IdType $staticSeoUrlId)
    {
        $staticSeoUrlContentArray = [];
        
        $result = $this->db->from($this->table)->where(['static_seo_url_id' => $staticSeoUrlId->asInt()])->get();
        
        foreach($result->result_array() as $row)
        {
            $staticSeoUrlContent = MainFactory::create('StaticSeoUrlContent');
            $this->_setDbValues($staticSeoUrlContent, $row);
            
            $staticSeoUrlContentArray[] = $staticSeoUrlContent;
        }
        
        return MainFactory::create('StaticSeoUrlContentCollection', $staticSeoUrlContentArray);
    }
    
    
    /**
     * Returns a StaticSeoUrlContent instance by the given staticSeoUrlContent ID.
     *
     * @param IdType $staticSeoUrlContentId
     *
     * @throws UnexpectedValueException
     * @throws InvalidArgumentException
     *
     * @return StaticSeoUrlContentInterface
     */
    public function getById(IdType $staticSeoUrlContentId)
    {
        $staticSeoUrlContentData = $this->db->get_where($this->table,
                                                        ['static_seo_url_content_id' => $staticSeoUrlContentId->asInt()])
                                            ->row_array();
        
        if($staticSeoUrlContentData === null)
        {
            throw new UnexpectedValueException('The requested staticSeoUrlContent was not found in the database (ID:'
                                               . $staticSeoUrlContentId->asInt() . ')');
        }
        
        $staticSeoUrlContent = MainFactory::create('StaticSeoUrlContent');
        $this->_setDbValues($staticSeoUrlContent, $staticSeoUrlContentData);
        
        return $staticSeoUrlContent;
    }
    
    
    /**
     * Assign the staticSeoUrlContent values via the setters.
     *
     * @param StaticSeoUrlContent $staticSeoUrlContent StaticSeoUrlContent object.
     * @param array               $row                 Fetched DB row.
     *
     * @throws InvalidArgumentException If $row contains invalid values.
     */
    protected function _setDbValues(StaticSeoUrlContent $staticSeoUrlContent, array $row)
    {
        $staticSeoUrlContent->setId(new IdType($row['static_seo_url_content_id']))
                            ->setLanguageId(new IdType($row['language_id']))
                            ->setTitle(new StringType((string)$row['title']))
                            ->setDescription(new StringType((string)$row['description']))
                            ->setKeywords(new StringType((string)$row['keywords']));
    }
}