sylver35\smiliescat\controller\main

Complexity

Total Complexity

11

Size/Duplication

Total Lines	230
Duplicated Lines	0 %

Importance

Changes	10
Bugs	0	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	13	1
A	popup_smilies_category()	0	45	2
A	ajax_smilies()	0	41	2
B	ajax_list_cat()	0	74	6

<?php
/**
*
* @package		Breizh Smilies Categories Extension
* @copyright	(c) 2020-2024 Sylver35  https://breizhcode.com
* @license		https://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

namespace sylver35\smiliescat\controller;

use sylver35\smiliescat\core\category;
use sylver35\smiliescat\core\diffusion;
use phpbb\request\request;
use phpbb\config\config;
use phpbb\controller\helper;
use phpbb\db\driver\driver_interface as db;
use phpbb\template\template;
use phpbb\user;
use phpbb\language\language;
use phpbb\pagination;

class main
{
	/* @var \sylver35\smiliescat\core\category */
	protected $category;

	/* @var \sylver35\smiliescat\core\diffusion */
	protected $diffusion;

	/** @var \phpbb\request\request */
	protected $request;

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

	/* @var \phpbb\controller\helper */
	protected $helper;

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

	/** @var \phpbb\template\template */
	protected $template;

	/** @var \phpbb\user */
	protected $user;

	/** @var \phpbb\language\language */
	protected $language;

	/** @var \phpbb\pagination */
	protected $pagination;

	/**
	 * The database tables
	 *
	 * @var string */
	protected $smilies_category_table;

	/**
	 * Constructor
	 */
	public function __construct(category $category, diffusion $diffusion, request $request, config $config, helper $helper, db $db, template $template, user $user, language $language, pagination $pagination, $smilies_category_table)
	{
		$this->category = $category;
		$this->diffusion = $diffusion;
		$this->request = $request;
		$this->config = $config;
		$this->helper = $helper;
		$this->db = $db;
		$this->template = $template;
		$this->user = $user;
		$this->language = $language;
		$this->pagination = $pagination;
		$this->smilies_category_table = $smilies_category_table;
	}

	/**
	 * @return \Symfony\Component\HttpFoundation\Response A Symfony Response object
	 */
	public function popup_smilies_category()
	{
		$start = (int) $this->request->variable('start', 0);
		$pagin = (int) $this->config['smilies_per_page_cat'];
		$first = (int) $this->config['smilies_first_cat'];
		$cat = (int) $this->request->variable('select', $first);
		$count = $this->category->smilies_count($cat);
		$title = $this->diffusion->extract_list_categories($cat);
		$data = $this->category->get_version();

		$sql = $this->db->sql_build_query('SELECT', [
			'SELECT'	=> '*',
			'FROM'		=> [SMILIES_TABLE => ''],
			'WHERE'		=> 'category = ' . $cat,
			'ORDER_BY'	=> 'smiley_order ASC',
		]);
		$result = $this->db->sql_query_limit($sql, $pagin, $start);
		while ($row = $this->db->sql_fetchrow($result))
		{
			$this->template->assign_block_vars('smilies', [
				'SMILEY_CODE'		=> $row['code'],
				'SMILEY_EMOTION'	=> $row['emotion'],
				'SMILEY_WIDTH'		=> $row['smiley_width'],
				'SMILEY_HEIGHT'		=> $row['smiley_height'],
				'SMILEY_SRC'		=> $row['smiley_url'],
			]);
		}
		$this->db->sql_freeresult($result);

		$start = $this->pagination->validate_start($start, $pagin, $count);
		$this->pagination->generate_template_pagination($this->helper->route('sylver35_smiliescat_smilies_pop', ['select' => $cat]), 'pagination', 'start', $count, $pagin, $start);

		$this->template->assign_vars([
			'U_SMILIES_PATH'	=> generate_board_url() . '/' . $this->config['smilies_path'] . '/',
			'POPUP_TITLE'		=> $this->language->lang('SC_CATEGORY_IN', $title),
			'SC_VERSION'		=> $this->language->lang('SC_VERSION_COPY', $data['homepage'], $data['version']),
		]);

		page_header($this->language->lang('SC_CATEGORY_IN', $title));

		$this->template->set_filenames([
			'body' => '@sylver35_smiliescat/smilies_category.html']
		);

		page_footer();
	}

	/**
	 * @return \Symfony\Component\HttpFoundation\Response A Symfony Response object
	 */
	public function ajax_smilies()
	{
		$i = 0;
		$list_smilies = [];
		$start = (int) $this->request->variable('start', 0);
		$pagin = (int) $this->config['smilies_per_page_cat'];
		$first = (int) $this->config['smilies_first_cat'];
		$cat = (int) $this->request->variable('cat', $first);
		$count = $this->category->smilies_count($cat);

		$sql = $this->db->sql_build_query('SELECT', [
			'SELECT'	=> '*',
			'FROM'		=> [SMILIES_TABLE => ''],
			'WHERE'		=> 'category = ' . $cat,
			'ORDER_BY'	=> 'smiley_order ASC',
		]);
		$result = $this->db->sql_query_limit($sql, $pagin, $start);
		while ($row = $this->db->sql_fetchrow($result))
		{
			$list_smilies[$i] = [
				'code'		=> $row['code'],
				'emotion'	=> $row['emotion'],
				'width'		=> $row['smiley_width'],
				'height'	=> $row['smiley_height'],
				'src'		=> $row['smiley_url'],
			];
			$i++;
		}
		$this->db->sql_freeresult($result);

		$categories = $this->diffusion->list_cats($cat);
		$json_response = new \phpbb\json_response;
		$json_response->send([
			'total'			=> $i,
			'title'			=> $this->category->return_name($cat, '', true),
			'nb_cats'		=> $categories['nb_cats'],
			'start'			=> $start,
			'pagination'	=> $count,
			'smilies_path'	=> generate_board_url() . '/' . $this->config['smilies_path'] . '/',
			'list_smilies'	=> $list_smilies,
			'categories'	=> $categories['list_cat'],
		]);
	}

	/**
	 * @return \Symfony\Component\HttpFoundation\Response A Symfony Response object
	 */
	public function ajax_list_cat()
	{
		$i = $j = $cat = 0;
		$lang_cat = $list_cat = [];
		$id = (int) $this->request->variable('id', 0);
		$action = (string) $this->request->variable('action', '');

		$this->category->move_cat($id, $action);
		$max = $this->category->get_max_order();
		$langs = $this->category->get_langs();
		$total = $this->category->category_exist();

		$sql = $this->db->sql_build_query('SELECT', [
			'SELECT'	=> 'l.lang_id, l.lang_iso, l.lang_local_name, c.*',
			'FROM'		=> [LANG_TABLE => 'l'],
			'LEFT_JOIN'	=> [
				[
					'FROM'	=> [$this->smilies_category_table => 'c'],
					'ON'	=> 'c.cat_lang = l.lang_iso',
				],
			],
			'ORDER_BY'	=> 'c.cat_order ASC, c.cat_lang_id ASC',
		]);
		$result = $this->db->sql_query($sql);
		while ($row = $this->db->sql_fetchrow($result))
		{
			$title = '';
			if ((int) $row['cat_id'] !== $cat)
			{
				$return = $this->category->verify_cat_langs($langs, $cat, $i, $lang_cat, true);
				$list_cat[$j] = [
					'error'		=> $return['error'],
					'langEmpty'	=> $return['lang_empty'],
				];
				$j++;
				$title = $this->language->lang('SC_CATEGORY_IN', $this->category->return_name($row['cat_id'], $row['cat_name'], true));
			}
			$lang_cat[$row['cat_id']][$row['lang_id']] = $row['lang_iso'];
			$list_cat[$j] = [
				'titleCat'		=> $title,
				'catLang'		=> $row['lang_local_name'],
				'catIso'		=> $row['lang_iso'],
				'catTranslate'	=> $row['cat_name'],
				'catId'			=> (int) $row['cat_id'],
				'catOrder'		=> (int) $row['cat_order'],
				'catNb'			=> (int) $row['cat_nb'],
				'nbCss'			=> $row['cat_nb'] ? 'green' : 'orange',
				'row'			=> (int) $row['cat_id'] !== $cat,
				'rowMax'		=> (int) $row['cat_order'] === $max,
				'uEdit'			=> '&amp;action=edit&amp;id=' . $row['cat_id'],
				'uDelete'		=> '&amp;action=delete&amp;id=' . $row['cat_id'],
			];
			$i++;
			$j++;
			// Keep this value in memory
			$cat = (int) $row['cat_id'];

			// Do this only for the last category
			if ((int) $row['cat_order'] === $max && ($i === $total))
			{
				$return = $this->category->verify_cat_langs($langs, $cat, $i, $lang_cat, true);
				$list_cat[$j] = [
					'error'		=> $return['error'],
					'langEmpty'	=> $return['lang_empty'],
				];
				$j++;
			}
		}
		$this->db->sql_freeresult($result);

		$json_response = new \phpbb\json_response;
		$json_response->send([
			'total'	=> $j,
			'datas'	=> $list_cat,
		]);
	}
}