dark1\usernotificationcontrol\core\unc_table

Complexity

Total Complexity

16

Size/Duplication

Total Lines	160
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	5	1
A	get_notify_method_type_value()	0	6	2
A	update_user_notifications_table()	0	28	6
A	set_notify_method_type_matrix()	0	29	4
A	get_notify_method_type_matrix()	0	20	3

<?php
/**
 *
 * User Notification Control [UNC]. An extension for the phpBB Forum Software package.
 *
 * @copyright (c) 2020, Dark❶, https://dark1.tech
 * @license GNU General Public License, version 2 (GPL-2.0)
 *
 */

namespace dark1\usernotificationcontrol\core;

/**
 * @ignore
 */
use phpbb\db\driver\driver_interface as db_driver;
use phpbb\cache\driver\driver_interface as cache_driver;

/**
 * User Notification Control Core Table Class.
 */
class unc_table
{
	/** @var string Table Name */
	const TABLE_NAME = 'dark1_unc';

	/** @var string Cache Key */
	const CACHE_KEY = '_dark1_unc_notify_matrix';

	/** @var \phpbb\db\driver\driver_interface */
	protected $db;

	/** @var \phpbb\cache\driver\driver_interface */
	protected $cache;

	/** @var string */
	protected $table_prefix;

	/**
	 * Constructor for User Notification Control Core Table Class.
	 *
	 * @param \phpbb\db\driver\driver_interface		$db				Database object
	 * @param \phpbb\cache\driver\driver_interface	$cache			Cache object
	 * @param string								$table_prefix
	 */
	public function __construct(db_driver $db, cache_driver $cache, $table_prefix)
	{
		$this->db				= $db;
		$this->cache			= $cache;
		$this->table_prefix		= $table_prefix;
	}



	/**
	 * Get Notification Method & Type is Enabled {true} OR Disabled {false}.
	 *
	 * @param string $notification_method
	 * @param string $notification_type
	 *
	 * @return bool|null Enabled {true} OR Disabled {false}
	 * @access public
	 */
	public function get_notify_method_type_value($notification_method, $notification_type)
	{
		// Get notify matrix
		$notify_matrix = $this->get_notify_method_type_matrix();

		return isset($notify_matrix[$notification_method][$notification_type]) ? $notify_matrix[$notification_method][$notification_type] : null;
	}



	/**
	 * Get Notification Methods & Types is Enabled {true} OR Disabled {false} in Matrix.
	 *
	 * @return array in form notify_matrix['notification_method']['notification_type'] = Enabled {true} OR Disabled {false}
	 * @access public
	 */
	public function get_notify_method_type_matrix()
	{
		// Get notify matrix data from the cache
		$notify_matrix = $this->cache->get(self::CACHE_KEY);

		if ($notify_matrix === false)
		{
			$sql = 'SELECT * FROM ' . $this->table_prefix . self::TABLE_NAME;
			$result = $this->db->sql_query($sql);
			while ($row = $this->db->sql_fetchrow($result))
			{
				$notify_matrix[$row['notification_method']][$row['notification_type']] = $row['notification_value'];
			}
			$this->db->sql_freeresult($result);

			// Cache notify matrix data
			$this->cache->put(self::CACHE_KEY, $notify_matrix);
		}

		return $notify_matrix;
	}



	/**
	 * Set Notification Methods & Types is Disabled {true}in Matrix.
	 *
	 * @param array $notify_matrix in form notify_matrix['notification_method']['notification_type'] = Enabled {true} OR Disabled {false}
	 *
	 * @return void
	 * @access public
	 */
	public function set_notify_method_type_matrix($notify_matrix)
	{
		// Truncate the Table
		$sql = 'DELETE FROM ' . $this->table_prefix . self::TABLE_NAME;
		$this->db->sql_query($sql);

		// Multi-Insert the
		$sr = 0;
		$sql_ary = [];
		foreach ($notify_matrix as $notification_method => $ary_type)
		{
			foreach ($ary_type as $notification_type => $notification_value)
			{
				if (isset($notification_value))
				{
					$sql_ary[] = [
						'notification_sr_no' 	=> $sr,
						'notification_method' 	=> $notification_method,
						'notification_type' 	=> $notification_type,
						'notification_value' 	=> $notification_value,
					];
					$sr++;
				}
			}
		}
		$this->db->sql_multi_insert($this->table_prefix . self::TABLE_NAME, $sql_ary);

		// Cache notify matrix data
		$this->cache->put(self::CACHE_KEY, $notify_matrix);
	}



	/**
	 * Update User Notification Table using No Notify Matrix.
	 *
	 * @param array $notify_matrix in form notify_matrix['notification_method']['notification_type'] = Enabled {true} OR Disabled {false}
	 * @param bool $update to Update or not
	 *
	 * @return void
	 * @access public
	 */
	public function update_user_notifications_table($notify_matrix, $update)
	{
		if ($update)
		{
			foreach ($notify_matrix as $notification_method => $ary_type)
			{
				$sql_ary = [
					0 => '',
					1 => ''
				];
				$flag_1st = [
					0 => true,
					1 => true
				];

				foreach ($ary_type as $notification_type => $value)
				{
					$sql_ary[$value] .= (($flag_1st[$value]) ? '' : 'OR ' ) . 'item_type = "' . $this->db->sql_escape($notification_type) . '"' . PHP_EOL;
					$flag_1st[$value] = false;
				}

				foreach ($sql_ary as $key => $value)
				{
					$sql = 'UPDATE ' . USER_NOTIFICATIONS_TABLE .
							' SET notify = ' . (int) $key .
							' WHERE method = "' . $this->db->sql_escape($notification_method) . '"' .
							' AND (' . PHP_EOL . (string) $value . ')';
					$this->db->sql_query($sql);
				}
			}
		}
	}

}