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 

<?php
/* --------------------------------------------------------------
   PackingSlipReader.inc.php 2018-05-09
   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 PackingSlipReader
 */
class PackingSlipReader implements PackingSlipReaderInterface
{
    /**
     * @var CI_DB_query_builder
     */
    protected $queryBuilder;
    
    /**
     * @var PackingSlipFactory
     */
    protected $factory;
    
    
    /**
     * PackingSlipReader constructor.
     *
     * @param \CI_DB_query_builder $queryBuilder
     * @param \PackingSlipFactory  $factory
     */
    public function __construct(CI_DB_query_builder $queryBuilder, PackingSlipFactory $factory)
    {
        $this->queryBuilder = $queryBuilder;
        $this->factory      = $factory;
    }
    
    
    /**
     * Gets all packing slips for a given order ID.
     *
     * @param \IdType $orderId
     *
     * @return \PackingSlipCollection
     *
     * @throws \InvalidArgumentException
     */
    public function getPackingSlipsByOrderId(IdType $orderId)
    {
        $packingSlips = [];
        
        $result = $this->queryBuilder->select()
                                     ->from('packing_slips')
                                     ->where(['order_id' => $orderId->asInt()])
                                     ->get()
                                     ->result_array();
        foreach($result as $row)
        {
            $packingSlips[] = $this->factory->createPackingSlip(new IdType($row['packing_slip_id']),
                                                                new StringType($row['number']),
                                                                new DateTime($row['date']),
                                                                new FilenameStringType($row['filename']),
                                                                new IdType($row['order_id']));
        }
        
        return MainFactory::create('PackingSlipCollection', $packingSlips);
    }
    
    
    /**
     * Gets all file names of packing slips for a given order ID.
     *
     * @param \IdType $orderId
     *
     * @return \StringCollection
     *
     * @throws \InvalidArgumentException
     */
    public function getPackingSlipFileNameCollectionByOrderId(IdType $orderId)
    {
        $fileNameArray = [];
        
        $result = $this->queryBuilder->select('filename')
                                     ->from('packing_slips')
                                     ->where(['order_id' => $orderId->asInt()])
                                     ->get()
                                     ->result_array();
        foreach($result as $row)
        {
            $fileNameArray[] = new FilenameStringType($row['filename']);
        }
        
        return MainFactory::create('StringCollection', $fileNameArray);
    }
}