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 

<?php

/* --------------------------------------------------------------
   StaticSeoUrlContentRepositoryWriter.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]
   --------------------------------------------------------------
*/

MainFactory::load_class('StaticSeoUrlContentRepositoryWriterInterface');

/**
 * Class StaticSeoUrlContentRepositoryWriter
 *
 * @category   System
 * @package    StaticSeoUrl
 * @subpackage Repositories
 */
class StaticSeoUrlContentRepositoryWriter implements StaticSeoUrlContentRepositoryWriterInterface
{
    /**
     * Table name
     *
     * @var string
     */
    protected $table = 'static_seo_url_contents';
    
    /**
     * Query builder.
     *
     * @var CI_DB_query_builder
     */
    protected $db;
    
    
    /**
     * StaticSeoUrlContentRepositoryWriter constructor.
     *
     * @param CI_DB_query_builder $db Query builder.
     */
    public function __construct(CI_DB_query_builder $db)
    {
        $this->db = $db;
    }
    
    
    /**
     * Inserts a staticSeoUrlContent to the database.
     *
     * @param IdType                       $staticSeoUrlId
     * @param StaticSeoUrlContentInterface $staticSeoUrlContent
     *
     * @return int ID of inserted staticSeoUrlContent or the given staticSeoUrlContent ID if the staticSeoUrlContent
     *             had an ID already.
     */
    public function store(IdType $staticSeoUrlId, StaticSeoUrlContentInterface $staticSeoUrlContent)
    {
        $sqlData = [
            'static_seo_url_id' => $staticSeoUrlId->asInt(),
            'language_id'       => $staticSeoUrlContent->getLanguageId(),
            'title'             => $staticSeoUrlContent->getTitle(),
            'description'       => $staticSeoUrlContent->getDescription(),
            'keywords'          => $staticSeoUrlContent->getKeywords()
        ];
        
        $staticSeoUrlContentId = $staticSeoUrlContent->getId();
        if($staticSeoUrlContentId !== 0)
        {
            $this->db->update($this->table, $sqlData, ['static_seo_url_content_id' => $staticSeoUrlContentId]);
        }
        else
        {
            $this->db->insert($this->table, $sqlData);
            $staticSeoUrlContentId = $this->db->insert_id();
        }
        
        return $staticSeoUrlContentId;
    }
}