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 

<?php

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

MainFactory::load_class('SlideRepositoryWriterInterface');

/**
 * Class SlideRepositoryWriter
 *
 * @category   System
 * @package    Slider
 * @subpackage Repositories
 */
class SlideRepositoryWriter implements SlideRepositoryWriterInterface
{
    /**
     * Table name
     *
     * @var string
     */
    protected $table = 'slides';
    
    /**
     * Query builder.
     *
     * @var CI_DB_query_builder
     */
    protected $db;
    
    
    /**
     * SlideRepositoryWriter constructor.
     *
     * @param CI_DB_query_builder $db Query builder.
     */
    public function __construct(CI_DB_query_builder $db)
    {
        $this->db = $db;
    }
    
    
    /**
     * Inserts a slide to the database.
     *
     * @param IdType         $sliderId
     * @param SlideInterface $slide
     *
     * @return int ID of inserted slide or the given slide ID if the slide had an ID already.
     */
    public function store(IdType $sliderId, SlideInterface $slide)
    {
        $dataArray = [];
        
        $slideId = $slide->getId();
        if($slideId !== 0)
        {
            $dataArray['slide_id'] = $slideId;
        }
        
        $dataArray['slider_id']   = $sliderId->asInt();
        $dataArray['language_id'] = $slide->getLanguageId();
        $dataArray['thumbnail']   = $slide->getThumbnail();
        $dataArray['title']       = $slide->getTitle();
        $dataArray['alt_text']    = $slide->getAltText();
        $dataArray['url']         = $slide->getUrl();
        $dataArray['url_target']  = $slide->getUrlTarget();
        $dataArray['sort_order']  = $slide->getSortOrder();
        
        $this->db->insert($this->table, $dataArray);
        
        if($slideId === 0)
        {
            return $this->db->insert_id();
        }
        else
        {
            return $slideId;
        }
    }
    
    
    /**
     * Unset the thumbnail filename references in other slide thumbnail entry by the given filename.
     *
     * @param FilenameStringType $filename Slide image filename.
     *
     * @return SlideRepositoryWriterInterface Same instance for method chaining.
     */
    public function unsetSlideThumbnailReference(FilenameStringType $filename)
    {
        $this->db->update($this->table, ['thumbnail' => ''], ['thumbnail' => $filename->asString()]);
        
        return $this;
    }
}