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 

<?php
/* --------------------------------------------------------------
   OrderItemRepositoryDeleter.inc.php 2016-06-23
   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('OrderItemRepositoryDeleterInterface');

/**
 * Class OrderItemRepositoryDeleter
 *
 * @category   System
 * @package    Order
 * @subpackage Repositories
 */
class OrderItemRepositoryDeleter implements OrderItemRepositoryDeleterInterface
{
    /**
     * Query builder.
     * @var CI_DB_query_builder
     */
    protected $db;
    
    
    /**
     * OrderItemRepositoryDeleter constructor.
     *
     * @param CI_DB_query_builder $db Query builder.
     */
    public function __construct(CI_DB_query_builder $db)
    {
        $this->db = $db;
    }
    
    
    /**
     * Removes an item from the order by the given order item ID.
     *
     * @param IdType $orderItemId ID of the order item.
     *
     * @return OrderItemRepositoryDeleter Same instance for method chaining.
     */
    public function deleteItemById(IdType $orderItemId)
    {
        $this->db->delete(array('orders_products', 'orders_products_download', 'orders_products_quantity_units'),
                          array('orders_products_id' => $orderItemId->asInt()));
    }
    
    
    /**
     * Removes multiple order items by the given order ID.
     *
     * @param IdType $orderId ID of the order.
     *
     * @return OrderItemRepositoryDeleter Same instance for method chaining.
     */
    public function deleteItemsByOrderId(IdType $orderId)
    {
        $query = $this->db->select('orders_products_id')
                          ->from('orders_products')
                          ->where('orders_id', $orderId->asInt());
        
        foreach($query->get()->result_array() as $row)
        {
            $this->db->delete(array('orders_products_quantity_units'),
                              array('orders_products_id' => $row['orders_products_id']));
        }
        
        $this->db->delete(array('orders_products', 'orders_products_download'),
                          array('orders_id' => $orderId->asInt()));
    }
}