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
<?php
/* --------------------------------------------------------------
ProductPermissionSetter.inc.php 2016-01-29
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]
--------------------------------------------------------------
*/
/**
* Class ProductPermissionSetter
*
* @category System
* @package Product
* @subpackage Repositories
*/
class ProductPermissionSetter implements ProductPermissionSetterInterface
{
/**
* @var CI_DB_query_builder
*/
protected $db;
/**
* ProductPermissionSetter constructor.
*
* @param CI_DB_query_builder $db
*/
public function __construct(CI_DB_query_builder $db)
{
$this->db = $db;
}
/**
* Sets the Customer Status Permissions for all products which are linked with the provided category ID.
*
* @param IdType $categoryId
* @param IdType $customerStatusId
* @param BoolType $permitted
*
* @return ProductPermissionSetterInterface Same instance for chained method calls.
*/
public function setProductsPermissionByCategoryId(IdType $categoryId,
IdType $customerStatusId,
BoolType $permitted)
{
$column = 'group_permission_' . $customerStatusId->asInt();
// Sub Query
$this->db->select('products_id')->from('products_to_categories')->where('categories_id', $categoryId->asInt());
$subQuery = $this->db->get_compiled_select();
// Main Query
$this->db->set($column, (int)$permitted->asBool())
->where("products_id IN ($subQuery)", null, false)
->update('products');
return $this;
}
}