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 <?php
/* --------------------------------------------------------------
CategoryRepositoryDeleter.inc.php 2017-06-15
Gambio GmbH
http://www.gambio.de
Copyright (c) 2015 Gambio GmbH
Released under the GNU General Public License (Version 2)
[http://www.gnu.org/licenses/gpl-2.0.html]
--------------------------------------------------------------
*/
/**
* Class CategoryRepositoryDeleter
*
* This class deletes category records from the database and is used in the category repository among the classes for
* writing and reading category records.
*
* @category System
* @package Category
* @subpackage Repositories
*/
class CategoryRepositoryDeleter implements CategoryRepositoryDeleterInterface
{
/**
* Database connector.
*
* @var CI_DB_query_builder
*/
protected $db;
/**
* @var \ProductRepositoryInterface
*/
protected $productRepository;
/**
* CategoryRepositoryDeleter constructor.
*
* @param CI_DB_query_builder $db Database connector.
* @param ProductRepositoryInterface $productRepository Products repository with functionality to remove products.
*/
public function __construct(CI_DB_query_builder $db, ProductRepositoryInterface $productRepository)
{
$this->db = $db;
$this->productRepository = $productRepository;
}
/**
* Deletes a specific category entity.
*
* @param IdType $categoryId Category ID.
*
* @return CategoryRepositoryDeleter Same instance for chained method calls.
*/
public function deleteById(IdType $categoryId)
{
$this->db->delete(['categories', 'categories_description', 'products_to_categories'],
['categories_id' => $categoryId->asInt()]);
return $this;
}
/**
* Deletes related products of given category.
* All products that are only connected to the given category gets removed.
*
* @param \IdCollection $categoryIds Ids of categories with products to be removed.
*
* @return $this|CategoryRepositoryDeleterInterface Same instance for chained method calls.
*/
public function deleteRelatedProductsOfCategory(IdCollection $categoryIds)
{
$productIdsToRemove = [];
$products = [];
foreach($categoryIds->getArray() as $categoryId)
{
$productsInCategory = $this->db->select('products_id')
->from('products_to_categories')
->where('categories_id', $categoryId->asInt())
->get()
->result_array();
foreach($productsInCategory as $productInCategory)
{
$products[$productInCategory['products_id']]['categories'][] = $categoryId->asInt();
}
}
foreach($products as $productId => $product)
{
$productsTotal = $this->db->select('COUNT(*) as total')
->from('products_to_categories')
->where('products_id', $productId)
->where_not_in('categories_id', $product['categories'])
->get()
->row_array()['total'];
if((int)$productsTotal === 0)
{
$productIdsToRemove[] = $productId;
}
}
foreach($productIdsToRemove as $productId)
{
$this->productRepository->deleteProductById(new IdType($productId));
}
return $this;
}
}