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 104 105 106 107 108 109 110 111 112 113 114 115 116 117 

<?php
/* --------------------------------------------------------------
   WithdrawalWriter.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 WithdrawalWriter
 *
 * @category   System
 * @package    Withdrawal
 * @subpackage Repositories
 */
class WithdrawalWriter implements WithdrawalWriterInterface
{
    /**
     * @var \CI_DB_query_builder
     */
    protected $queryBuilder;
    
    
    /**
     * WithdrawalWriter constructor.
     *
     * @param \CI_DB_query_builder $queryBuilder
     */
    public function __construct(CI_DB_query_builder $queryBuilder)
    {
        $this->queryBuilder = $queryBuilder;
    }
    
    
    /**
     * Saves withdrawal entity data in database.
     *
     * @param \WithdrawalInterface $withdrawal Withdrawal to be saved.
     *
     * @return $this|\WithdrawalWriterInterface Same instance for chained method calls.
     */
    public function store(WithdrawalInterface $withdrawal)
    {
        $this->queryBuilder->set([
                                     'order_id'                => $withdrawal->getWithdrawalOrder()->getOrderId(),
                                     'customer_id'             => $withdrawal->getWithdrawalOrder()->getCustomerId(),
                                     'customer_gender'         => $withdrawal->getWithdrawalOrder()
                                                                             ->getCustomerGender(),
                                     'customer_firstname'      => $withdrawal->getWithdrawalOrder()
                                                                             ->getCustomerFirstName(),
                                     'customer_lastname'       => $withdrawal->getWithdrawalOrder()
                                                                             ->getCustomerLastName(),
                                     'customer_street_address' => $withdrawal->getWithdrawalOrder()
                                                                             ->getCustomerStreetAddress(),
                                     'customer_postcode'       => $withdrawal->getWithdrawalOrder()
                                                                             ->getCustomerPostCode(),
                                     'customer_city'           => $withdrawal->getWithdrawalOrder()->getCustomerCity(),
                                     'customer_country'        => $withdrawal->getWithdrawalOrder()
                                                                             ->getCustomerCountry(),
                                     'customer_email'          => $withdrawal->getWithdrawalOrder()->getCustomerEmail(),
                                     'order_date'              => $withdrawal->getWithdrawalOrder()
                                                                             ->getOrderDate()
                                                                             ->format('Y-m-d H:i:s'),
                                     'delivery_date'           => $withdrawal->getWithdrawalOrder()
                                                                             ->getDeliveryDate()
                                                                             ->format('Y-m-d H:i:s'),
                                     'withdrawal_date'         => $withdrawal->getWithdrawalDate()
                                                                             ->format('Y-m-d H:i:s'),
                                     'withdrawal_content'      => $withdrawal->getWithdrawalContent(),
                                     'created_by_admin'        => $withdrawal->getCreatedByAdmin(),
                                     'date_created'            => $withdrawal->getDateCreated()->format('Y-m-d H:i:s')
                                 ]);
        
        $this->queryBuilder->insert('withdrawals');
        
        $withdrawalId = $this->queryBuilder->insert_id();
        
        $withdrawal->setWithdrawalId(new IdType($withdrawalId));
        
        return $this;
    }
    
    
    /**
     * Updates withdrawal entity data in database.
     *
     * @param \WithdrawalInterface $withdrawal Withdrawal to be updated.
     *
     * @return $this|\WithdrawalWriterInterface Same instance for chained method calls.
     */
    public function update(WithdrawalInterface $withdrawal)
    {
        $this->queryBuilder->update('withdrawals', [
            
            'order_id'                => $withdrawal->getWithdrawalOrder()->getOrderId(),
            'customer_id'             => $withdrawal->getWithdrawalOrder()->getCustomerId(),
            'customer_gender'         => $withdrawal->getWithdrawalOrder()->getCustomerGender(),
            'customer_firstname'      => $withdrawal->getWithdrawalOrder()->getCustomerFirstName(),
            'customer_lastname'       => $withdrawal->getWithdrawalOrder()->getCustomerLastName(),
            'customer_street_address' => $withdrawal->getWithdrawalOrder()->getCustomerStreetAddress(),
            'customer_postcode'       => $withdrawal->getWithdrawalOrder()->getCustomerPostCode(),
            'customer_city'           => $withdrawal->getWithdrawalOrder()->getCustomerCity(),
            'customer_country'        => $withdrawal->getWithdrawalOrder()->getCustomerCountry(),
            'customer_email'          => $withdrawal->getWithdrawalOrder()->getCustomerEmail(),
            'order_date'              => $withdrawal->getWithdrawalOrder()->getOrderDate()->format('Y-m-d H:i:s'),
            'delivery_date'           => $withdrawal->getWithdrawalOrder()->getDeliveryDate()->format('Y-m-d H:i:s'),
            'withdrawal_date'         => $withdrawal->getWithdrawalDate()->format('Y-m-d H:i:s'),
            'withdrawal_content'      => $withdrawal->getWithdrawalContent(),
            'created_by_admin'        => $withdrawal->getCreatedByAdmin()
        ], ['withdrawal_id' => $withdrawal->getWithdrawalId()]);
        
        return $this;
    }
}