cs\Permission\Any

Complexity

Total Complexity

23

Size/Duplication

Total Lines	142
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	2

Test Coverage

Coverage

91.3%

Importance

Changes	1
Bugs	1	Features	1

3 Methods

Rating	Name	Duplication	Size	Complexity
C	set_any_permissions()	0	59	12
B	del_any_permissions_all()	0	25	5
B	get_any_permissions()	0	37	6

<?php
/**
 * @package   CleverStyle Framework
 * @author    Nazar Mokrynskyi <nazar@mokrynskyi.com>
 * @copyright Copyright (c) 2013-2016, Nazar Mokrynskyi
 * @license   MIT License, see license.txt
 */
namespace cs\Permission;
use
	cs\Cache;

/**
 * Class Any with common methods for User and Group classes
 *
 * @property Cache $cache
 *
 * @method \cs\DB\_Abstract db()
 * @method \cs\DB\_Abstract db_prime()
 */
trait Any {
	/**
	 * @param int    $id
	 * @param string $type
	 *
	 * @return int[]|false
	 */
	protected function get_any_permissions ($id, $type) {
		$id = (int)$id;
		if (!$id) {
			return false;
		}
		switch ($type) {
			case 'user':
				$table = '[prefix]users_permissions';
				break;
			case 'group':
				$table = '[prefix]groups_permissions';
				break;
			default:
				return false;
		}
		return $this->cache->get(
			"permissions/$id",
			function () use ($id, $table) {
				$permissions       = false;
				$permissions_array = $this->db()->qfa(
					"SELECT
						`permission`,
						`value`
					FROM `$table`
					WHERE `id` = '$id'
					ORDER BY `permission` ASC"
				);
				if (is_array($permissions_array)) {
					$permissions = [];
					foreach ($permissions_array as $permission) {
						$permissions[$permission['permission']] = (int)(bool)$permission['value'];
					}
				}
				return $permissions;
			}
		);
	}
	/**
	 * @param array  $data
	 * @param int    $id
	 * @param string $type
	 *
	 * @return bool
	 */
	protected function set_any_permissions ($data, $id, $type) {
		$id = (int)$id;
		if (!is_array($data) || empty($data) || !$id) {
			return false;
		}
		switch ($type) {
			case 'user':
				$table = '[prefix]users_permissions';
				break;
			case 'group':
				$table = '[prefix]groups_permissions';
				break;
			default:
				return false;
		}
		$insert_update = [];
		$delete        = [];
		foreach ($data as $permission => $value) {
			if ($value == -1) {
				$delete[] = (int)$permission;
			} else {
				$insert_update[] = [$permission, (int)(bool)$value];
			}
		}
		unset($permission, $value);
		$return = true;
		if ($delete) {
			$delete = implode(', ', $delete);
			$return = (bool)$this->db_prime()->q(
				"DELETE FROM `$table`
				WHERE
					`id`			= '$id' AND
					`permission`	IN ($delete)"
			);
		}
		unset($delete);
		if ($insert_update) {
			$return =
				$return &&
				$this->db_prime()->insert(
					"REPLACE INTO `$table`
						(
							`id`,
							`permission`,
							`value`
						) VALUES (
							'$id',
							'%d',
							'%d'
						)",
					$insert_update
				);
		}
		$this->cache->del("permissions/$id");
		if ($type == 'group') {
			Cache::instance()->del('users/permissions');
		}
		return (bool)$return;
	}
	/**
	 * @param int    $id
	 * @param string $type
	 *
	 * @return bool
	 */
	protected function del_any_permissions_all ($id, $type) {
		$id = (int)$id;
		if (!$id) {
			return false;
		}
		switch ($type) {
			case 'user':
				$table = '[prefix]users_permissions';
				break;
			case 'group':
				$table = '[prefix]groups_permissions';
				break;
			default:
				return false;
		}
		$return = $this->db_prime()->q(
			"DELETE FROM `$table`
			WHERE `id` = '$id'"
		);
		$this->cache->del("permissions/$id");
		if ($type == 'group') {
			Cache::instance()->del('users/permissions');
		}
		return (bool)$return;
	}
}