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 

<?php

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

/**
 * Class ReviewWriter
 *
 * @category   System
 * @package    Review
 * @subpackage Repositories
 */
class ReviewWriter implements ReviewWriterInterface
{
    /**
     * @var \CI_DB_query_builder
     */
    protected $queryBuilder;
    
    
    /**
     * ReviewWriter constructor.
     *
     * @param \CI_DB_query_builder $queryBuilder
     */
    public function __construct(CI_DB_query_builder $queryBuilder)
    {
        $this->queryBuilder = $queryBuilder;
    }
    
    
    /**
     * Saves review entity data in database.
     *
     * @param \ReviewInterface $review Review entity to be saved.
     *
     * @return $this|\ReviewWriterInterface Same instance for chained method calls.
     */
    public function store(ReviewInterface $review)
    {
        $reviewDataArray = [
            'products_id'    => $review->getProductId(),
            'customers_id'   => $review->getCustomer()->getCustomerId(),
            'customers_name' => $review->getCustomer()->getCustomerName(),
            'reviews_rating' => $review->getRating(),
            'reviews_read'   => $review->getRead(),
            'date_added'     => $review->getDateAdded()->format('Y-m-d H:i:s'),
            'last_modified'  => $review->getLastModifiedDate()->format('Y-m-d H:i:s')
        ];
        
        $this->queryBuilder->insert('reviews', $reviewDataArray);
        
        $reviewId = $this->queryBuilder->insert_id();
        
        $review->setId(new IdType($reviewId));
        
        $reviewDescriptionDataArray = [
            'reviews_id'   => $review->getId(),
            'languages_id' => $review->getLanguageId(),
            'reviews_text' => $review->getText()
        ];
        
        $this->queryBuilder->insert('reviews_description', $reviewDescriptionDataArray);
        
        return $this;
    }
    
    
    /**
     * Updates review entity data in database.
     *
     * @param \ReviewInterface $review Review to be updated.
     *
     * @return $this|\ReviewWriterInterface Same instance for chained method calls.
     */
    public function update(ReviewInterface $review)
    {
        $this->queryBuilder->update('reviews', [
            'products_id'    => $review->getProductId(),
            'customers_id'   => $review->getCustomer()->getCustomerId(),
            'customers_name' => $review->getCustomer()->getCustomerName(),
            'reviews_rating' => $review->getRating(),
            'reviews_read'   => $review->getRead()
        ], ['reviews_id' => $review->getId()]);
        
        $this->queryBuilder->update('reviews_description', [
            'languages_id' => $review->getLanguageId(),
            'reviews_text' => $review->getText()
        ], ['reviews_id' => $review->getId()]);
        
        return $this;
    }
}