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 

<?php

/* --------------------------------------------------------------
   StaticSeoUrlRepositoryWriter.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('StaticSeoUrlRepositoryWriterInterface');

/**
 * Class StaticSeoUrlRepositoryWriter
 *
 * @category   System
 * @package    StaticSeoUrl
 * @subpackage Repositories
 */
class StaticSeoUrlRepositoryWriter implements StaticSeoUrlRepositoryWriterInterface
{
    /**
     * Table name
     *
     * @var string
     */
    protected $table = 'static_seo_urls';
    
    /**
     * Query builder.
     *
     * @var CI_DB_query_builder
     */
    protected $db;
    
    
    /**
     * StaticSeoUrlRepositoryWriter constructor.
     *
     * @param CI_DB_query_builder $db Query builder.
     */
    public function __construct(CI_DB_query_builder $db)
    {
        $this->db = $db;
    }
    
    
    /**
     * Inserts a staticSeoUrl to the database.
     *
     * @param StaticSeoUrlInterface $staticSeoUrl
     *
     * @return int ID of inserted staticSeoUrl or the given staticSeoUrl ID if the staticSeoUrl had an ID already.
     */
    public function store(StaticSeoUrlInterface $staticSeoUrl)
    {
        $sqlData = [
            'name'                  => $staticSeoUrl->getName(),
            'sitemap_entry'         => (int)$staticSeoUrl->isInSitemapEntry(),
            'changefreq'            => $staticSeoUrl->getChangeFrequency(),
            'priority'              => $staticSeoUrl->getPriority(),
            'robots_disallow_entry' => (int)$staticSeoUrl->isInRobotsFile(),
        ];
        
        $staticSeoUrlId = $staticSeoUrl->getId();
        if($staticSeoUrlId !== 0)
        {
            $this->db->update($this->table, $sqlData, ['static_seo_url_id' => $staticSeoUrlId]);
        }
        else
        {
            $this->db->insert($this->table, $sqlData);
            $staticSeoUrlId = $this->db->insert_id();
        }
        
        return $staticSeoUrlId;
    }
}