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 

<?php

/* --------------------------------------------------------------
   VersionInfoDatabaseReader.inc.php 2017-07-04
   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 VersionInfoDatabaseReader
 *
 * @category    System
 * @package     VersionInfo
 * @subpackage  Reader
 */
class VersionInfoDatabaseReader extends AbstractVersionInfoReader
{
    /**
     * @var CI_DB_query_builder
     */
    protected $db;
    
    /**
     * @var VersionInfoItemFactory
     */
    protected $versionInfoItemFactory;
    
    
    /**
     * VersionInfoDatabaseReader constructor.
     *
     * @param CI_DB_query_builder    $db
     * @param VersionInfoItemFactory $versionInfoItemFactory
     */
    public function __construct(CI_DB_query_builder $db, VersionInfoItemFactory $versionInfoItemFactory)
    {
        $this->db                     = $db;
        $this->versionInfoItemFactory = $versionInfoItemFactory;
    }
    
    
    /**
     * Returns all VersionInfoDatabaseItems from database.
     *
     * @return VersionInfoDatabaseItem []
     */
    public function getAllVersionInfoItems()
    {
        $versionInfoArray = [];
        
        $resultArray = $this->db->order_by('installation_date', 'ASC')->get('version_history')->result_array();
        
        foreach($resultArray as $versionInfoData)
        {
            $versionInfoArray[] = $this->_createVersionInfoObject($versionInfoData);
        }
        
        return $versionInfoArray;
    }
    
    
    /**
     * @param array $versionInfoData
     *
     * @return VersionInfoDatabaseItem
     */
    protected function _createVersionInfoObject(array $versionInfoData)
    {
        $name                = new NonEmptyStringType($this->_determineName(new NonEmptyStringType($versionInfoData['name'])));
        $version             = new NonEmptyStringType(strtolower($versionInfoData['version']));
        $vendor              = new NonEmptyStringType('Gambio');
        $changelogVersionURL = new NonEmptyStringType($this->_determineChangelogURL($version, $vendor, $name));
        $installationDate    = new DateTime($versionInfoData['installation_date']);
        $installedStatus     = new BoolType($versionInfoData['installed']);
        
        return $this->versionInfoItemFactory->createVersionInfoDatabaseItem($name, $version, $vendor,
                                                                            $changelogVersionURL, $installationDate,
                                                                            $installedStatus);
    }
}