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()));
}
}