dark1\usernotificationcontrol\controller\acp_prune

Complexity

Total Complexity

8

Size/Duplication

Total Lines	131
Duplicated Lines	0 %

Importance

Changes	4
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	11	1
A	handle()	0	45	3
A	disp_stats_tbl()	0	16	4

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

namespace dark1\usernotificationcontrol\controller;

/**
 * @ignore
 */
use phpbb\language\language;
use phpbb\log\log;
use phpbb\request\request;
use phpbb\template\template;
use phpbb\user;
use phpbb\config\config;
use phpbb\cron\manager as cron_manager;
use phpbb\db\driver\driver_interface as db_driver;

/**
 * User Notification Control [UNC] ACP controller Prune.
 */
class acp_prune extends acp_base
{
	/** @var language */
	protected $language;

	/** @var config */
	protected $config;

	/** @var cron_manager */
	protected $cron_manager;

	/** @var db_driver */
	protected $db;

	/** @var string phpBB root path */
	protected $phpbb_root_path;

	/** @var string phpBB adm relative path */
	protected $phpbb_adm_relative_path;

	/** @var string phpBB php ext */
	protected $php_ext;

	/** Time Format */
	const TIME_FORMAT	= 'Y-m-d h:i:s A P';

	/**
	 * Constructor.
	 *
	 * @param language			$language					Language object
	 * @param log				$log						Log object
	 * @param request			$request					Request object
	 * @param template			$template					Template object
	 * @param user				$user						User object
	 * @param config			$config						Config object
	 * @param cron_manager		$cron_manager				Cron manager
	 * @param db_driver			$db							Database object
	 * @param string			$phpbb_root_path			phpBB root path
	 * @param string			$phpbb_adm_relative_path	phpBB adm relative path
	 * @param string			$php_ext					phpBB php ext
	 */
	public function __construct(language $language, log $log, request $request, template $template, user $user, config $config, cron_manager $cron_manager, db_driver $db, $phpbb_root_path, $phpbb_adm_relative_path, $php_ext)
	{
		parent::__construct($language, $log, $request, $template, $user);

		$this->language					= $language;
		$this->config					= $config;
		$this->cron_manager				= $cron_manager;
		$this->db						= $db;
		$this->phpbb_root_path			= $phpbb_root_path;
		$this->phpbb_adm_relative_path	= $phpbb_adm_relative_path;
		$this->php_ext					= $php_ext;
	}

	/**
	 * Display the options a user can configure for Cron Mode.
	 *
	 * @return void
	 * @access public
	 */
	public function handle()
	{
		// Is the form being submitted to us?
		if ($this->request->is_set_post('submit'))
		{
			$this->check_form_on_submit();

			// Set the options the user configured
			$this->config->set('dark1_unc_all_notify_expire_days', $this->request->variable('dark1_unc_all_notify_expire_days', 0));
			$this->config->set('dark1_unc_auto_prune_notify_enable', $this->request->variable('dark1_unc_auto_prune_notify_enable', 0));
			$this->config->set('dark1_unc_auto_prune_notify_gc', ($this->request->variable('dark1_unc_auto_prune_notify_gc', 0)) * 86400);

			$this->success_form_on_submit();
		}

		// Run Cron Task
		if ($this->request->is_set_post('runcrontask'))
		{
			$this->check_form_on_submit();

			$cron_task = $this->cron_manager->find_task('dark1.usernotificationcontrol.cron.auto_prune_notify');
			$cron_task->run();

			$this->success_form_on_submit();
		}

		$this->language->add_lang('acp/board');
		$main_adm_path = $this->phpbb_root_path . $this->phpbb_adm_relative_path . 'index.' . $this->php_ext;
		$read_expire_link = append_sid($main_adm_path, 'i=acp_board&amp;mode=load').'#read_notification_expire_days';

		$curr_time = time();
		$days = $this->config['read_notification_expire_days'] + $this->config['dark1_unc_all_notify_expire_days'];
		$this->disp_stats_tbl($curr_time - ($days * 86400));

		// Set output variables for display in the template
		$this->template->assign_vars([
			'UNC_READ_EXPIRE'		=> $this->config['read_notification_expire_days'],
			'UNC_READ_EXPIRE_LINK'	=> $read_expire_link,
			'UNC_ALL_EXPIRE'		=> $this->config['dark1_unc_all_notify_expire_days'],
			'UNC_TOTAL_EXPIRE'		=> $days,
			'UNC_CURRENT_TIME'		=> $this->user->format_date($curr_time, self::TIME_FORMAT, true),
			'UNC_ENABLE_CRON'		=> $this->config['dark1_unc_auto_prune_notify_enable'],
			'UNC_CRON_INTERVAL'		=> ($this->config['dark1_unc_auto_prune_notify_gc'] / 86400),
			'UNC_CRON_LAST_RUN'		=> $this->user->format_date($this->config['dark1_unc_auto_prune_notify_last_gc'], self::TIME_FORMAT, true),
			'UNC_CRON_NEXT_RUN'		=> $this->user->format_date($this->config['dark1_unc_auto_prune_notify_last_gc'] + $this->config['dark1_unc_auto_prune_notify_gc'], self::TIME_FORMAT, true),
		]);
	}

	/**
	 * Display the Stats Table.
	 *
	 * @param int	$timestamp	Timestamp
	 * @return void
	 * @access private
	 */
	private function disp_stats_tbl($timestamp)
	{
		foreach (['all' => '> 0', 'exp' => '< '.$timestamp, 'rem' => '>= '.$timestamp] as $key => $value)
		{
			$sql = 'SELECT notification_read, COUNT(*) AS count' .
					' FROM ' . NOTIFICATIONS_TABLE .
					' WHERE notification_time ' . (string) $value .
					' GROUP BY notification_read';
			$result = $this->db->sql_query($sql);
			$rows = array_column($this->db->sql_fetchrowset($result), 'count', 'notification_read');
			$this->db->sql_freeresult($result);

			$this->template->assign_block_vars('stats', [
				'TYPE'		=> $this->language->lang('ACP_UNC_STAT_' . strtoupper($key)),
				'UNREAD'	=> (int) (isset($rows[0]) ? $rows[0] : 0),
				'READ'		=> (int) (isset($rows[1]) ? $rows[1] : 0),
			]);
		}
	}
}