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 

<?php
/* --------------------------------------------------------------
 GXParcelTrackingCodeWriter.php 2018-01-11
 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 GXParcelTrackingCodeWriter
 */
class GXParcelTrackingCodeWriter
{
    /**
     * @var \CI_DB_query_builder
     */
    protected $db;
    
    /**
     * @var string
     */
    protected $table = 'orders_parcel_tracking_codes';
    
    
    /**
     * TrackingCodesWriter constructor.
     *
     * @param \CI_DB_query_builder $db
     */
    public function __construct(CI_DB_query_builder $db)
    {
        $this->db = $db;
    }
    
    
    /**
     * Saves the given order tracking code information in the order parcel tracking codes table.
     * Data for parcel service name, url and comment is fetched from related tables.
     *
     * @param \ParcelTrackingCodeServiceId  $parcelServiceId Id of parcel service.
     * @param \ParcelTrackingCodeOrderId    $orderId         Id of order.
     * @param \OrderParcelTrackingCode      $trackingCode    Tracking code for order.
     * @param \ParcelTrackingCodeLanguageId $languageId      Id of selected language.
     *
     * @return \ParcelTrackingCodeId Id of new order parcel tracking code.
     */
    public function save(ParcelTrackingCodeServiceId $parcelServiceId,
                         ParcelTrackingCodeOrderId $orderId,
                         OrderParcelTrackingCode $trackingCode,
                         ParcelTrackingCodeLanguageId $languageId)
    {
        
        $parcelServiceDescription = $this->db->select('ps.name, psd.url, psd.comment')
                                             ->from('parcel_services as ps')
                                             ->join('parcel_services_description as psd',
                                                    'ps.parcel_service_id = psd.parcel_service_id')
                                             ->where('ps.parcel_service_id', $parcelServiceId->is())
                                             ->where('psd.language_id', $languageId->is())
                                             ->get()
                                             ->row_array();
        
        if(!$parcelServiceDescription)
        {
            throw new InvalidArgumentException('Can not find related parcel service description for given parcel service id "'
                                               . $parcelServiceId->is() . '" and language id "' . $languageId->is()
                                               . '".');
        }
        
        $this->db->insert($this->table, [
            'order_id'            => $orderId->is(),
            'tracking_code'       => $trackingCode->is(),
            'parcel_service_id'   => $parcelServiceId->is(),
            'language_id'         => $languageId->is(),
            'parcel_service_name' => $parcelServiceDescription['name'],
            'url'                 => str_replace('{TRACKING_NUMBER}', $trackingCode->is(),
                                                 $parcelServiceDescription['url']),
            'comment'             => $parcelServiceDescription['comment']
        ]);
        
        return ParcelTrackingCodeId::create($this->db->insert_id());
    }
    
    
    /**
     * Saves the given order tracking code information in the order parcel tracking codes table.
     * Only the provided data is stored in the database.
     *
     * @param \ParcelTrackingCodeOrderId      $orderId Id of order.
     * @param \ParcelTrackingCodeServiceName  $name    Name of parcel service.
     * @param \ParcelTrackingCodeUrl          $url     Tracking code url for order.
     * @param \ParcelTrackingCodeComment|null $comment Comment about tracking code.
     *
     * @return \ParcelTrackingCodeId Id of new order parcel tracking code.
     */
    public function saveLightweight(ParcelTrackingCodeOrderId $orderId,
                                    ParcelTrackingCodeServiceName $name,
                                    ParcelTrackingCodeUrl $url,
                                    ParcelTrackingCodeComment $comment = null)
    {
        $this->db->insert($this->table, [
            'order_id'            => $orderId->is(),
            'parcel_service_name' => $name->is(),
            'url'                 => $url->is(),
            'comment'             => $comment ? $comment->is() : ''
        ]);
        
        return ParcelTrackingCodeId::create($this->db->insert_id());
    }
}