phpbbgallery\core\log::build_list()

Complexity

Conditions	35
Paths	> 20000

Size

Total Lines	207
Code Lines	127

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	54
CRAP Score	217.7875

Importance

Changes	6
Bugs	2	Features	0

<?php
	public function build_list($type, $limit = 0, $page = 1, $album = 0, $image = 0, $additional = [])
	{
		if ($limit == 0)
		{
			$limit = $this->gallery_config->get('items_per_page');
			// If its called from ACP album is -1, if from MCP then is not
			if ($album == -1)
			{
				$page = (int) ($page / $limit) + 1;
			}
		}
		$this->language->add_lang(['info_acp_gallery_logs'], 'phpbbgallery/core');

		$this->gallery_auth->load_user_permissions($this->user->data['user_id']);
		$sql_array = array(
			'FROM'	=> array(
				$this->log_table	=> 'l'
			),
			'LEFT_JOIN' => array(
				array(
					'FROM'	=> array($this->images_table => 'i'),
					'ON'	=> 'l.image = i.image_id'
				)
			)
		);
		$sql_where = [];
		if ($type != 'all')
		{
			$sql_where[] = "l.log_type = '" . $this->db->sql_escape($type) . "'";
		}
		// If album is -1 we are calling it from ACP so ... priority!
		// If album is 0 we are calling it from moderator log, so we need album we can access
		$mod_array = $this->gallery_auth->acl_album_ids('m_status');
		// Patch for missing album
		$mod_array[] = 0;
		if ($album === 0)
		{
			// If no albums we can approve - quit building queue
			if (empty($mod_array))
			{
				return;
			}
			$sql_where[] = $this->db->sql_in_set('l.album', $mod_array);
			$sql_where[] = $this->db->sql_in_set('i.image_album_id', $mod_array);
		}
		if ($album > 0)
		{
			if (!$this->gallery_auth->acl_check('i_view', $album))
			{
				return;
			}
			$sql_where[] = 'l.album = ' . (int) $album;
		}
		if ($image > 0)
		{
			$sql_where[] = 'l.image = ' . (int) $image;
			$sql_where[] = $this->db->sql_in_set('i.image_album_id', $mod_array);
		}
		if (isset($additional['sort_days']))
		{
			$sql_where[] = 'l.log_time > ' . (time() - ($additional['sort_days'] * 86400));
		}
		// And additional check for "active" logs (DB admin can review logs in DB)
		$sql_where[] = 'l.deleted = 0';
		$sql_array['WHERE'] = implode(' and ', $sql_where);
		if (isset($additional['sort_key']))
		{
			switch ($additional['sort_key'])
			{
				case 'u':
					$sql_array['ORDER_BY'] = 'l.log_user ' . (isset($additional['sort_dir']) ? 'ASC' : 'DESC');
					$sql_array['GROUP_BY'] = 'l.log_user, l.log_id, i.image_id, i.image_album_id';
				break;
				case 'i':
					$sql_array['ORDER_BY'] = 'l.log_ip ' . (isset($additional['sort_dir']) ? 'ASC' : 'DESC');
					$sql_array['GROUP_BY'] = 'l.log_ip, l.log_id, i.image_id, i.image_album_id';
				break;
				case 'o':
					$sql_array['ORDER_BY'] = 'l.description ' . (isset($additional['sort_dir']) ? 'ASC' : 'DESC');
					$sql_array['GROUP_BY'] = 'l.description, l.log_id, i.image_id, i.image_album_id';
				break;
			}
		}
		else
		{
			$sql_array['ORDER_BY'] = 'l.log_time ' . (isset($additional['sort_dir']) ? 'ASC' : 'DESC');
			$sql_array['GROUP_BY'] = 'l.log_time, l.log_id, i.image_id, i.image_album_id';
		}
		// So we need count - so define SELECT
		$count_sql_array = $sql_array;

		// Remove SELECT for correct count
		$count_sql_array['SELECT'] = 'COUNT(DISTINCT l.log_id) as count';
		unset($count_sql_array['GROUP_BY']);
		unset($count_sql_array['ORDER_BY']);
		$filtering_on_image_album = false;
		foreach ($sql_where as $where_clause)
		{
			if (strpos($where_clause, 'i.image_album_id') !== false)
			{
				$filtering_on_image_album = true;
				break;
			}
		}
		if (!$filtering_on_image_album)
		{
			unset($count_sql_array['LEFT_JOIN']);
		}

		$sql = $this->db->sql_build_query('SELECT', $count_sql_array);
		$result = $this->db->sql_query($sql);
		$row = $this->db->sql_fetchrow($result);
		$this->db->sql_freeresult($result);

		$count = $row ? $row['count'] : 0;

		$sql_array['SELECT'] = '*';
		$sql = $this->db->sql_build_query('SELECT', $sql_array);
		$result = $this->db->sql_query_limit($sql, $limit, ($page - 1) * $limit);

		$logoutput = $users_array = array();
		while ($row = $this->db->sql_fetchrow($result))
		{
			$logoutput[] = array(
				'id'	=> $row['log_id'],
				'type'	=> $row['log_type'],
				'action'	=> $row['log_action'],
				'time'	=> $row['log_time'],
				'user'	=> $row['log_user'],
				'ip'	=> $row['log_ip'],
				'album'	=> $row['album'],
				'image'	=> $row['image'],
				'description'	=> json_decode(stripslashes($row['description']))
			);
			$users_array[$row['log_user']] = array('');
		}
		$this->db->sql_freeresult($result);

		$this->user_loader->load_users(array_keys($users_array));

		// Let's build template vars
		if (!empty($logoutput))
		{
			foreach ($logoutput as $var)
			{
				$this->template->assign_block_vars('log', array(
					'U_LOG_ID'		=> $var['id'],
					'U_LOG_USER'	=> $this->user_loader->get_username($var['user'], 'full'),
					'U_TYPE'		=> $var['type'],
					'U_LOG_IP'		=> $var['ip'],
					'U_ALBUM_LINK'	=> $var['album'] != 0 ? $this->helper->route('phpbbgallery_core_album', array('album_id'	=> $var['album'])) : false,
					'U_IMAGE_LINK'	=> $var['image'] != 0 ? $this->helper->route('phpbbgallery_core_image', array('image_id'	=> $var['image'])) : false,
					'U_LOG_ACTION' => isset($var['description']) && is_array($var['description']) ? $this->language->lang($var['description'][0], $var['description'][1] ?? false, $var['description'][2] ?? false, $var['description'][3] ?? false) : '',
					'U_TIME'		=> $this->user->format_date($var['time']),
				));
			}
		}
		$this->template->assign_vars(array(
			'S_HAS_LOGS' => $count > 0 ? true : false,
			'TOTAL_PAGES'	=> $this->language->lang('PAGE_TITLE_NUMBER', $page),
		));
		// Here we do some routes magic
		if ($album == 0)
		{
			$this->pagination->generate_template_pagination(array(
				'routes' => array(
					'phpbbgallery_core_moderate_action_log',
					'phpbbgallery_core_moderate_action_log_page',
				),
				'params' => array(
				),
			), 'pagination', 'page', $count, $limit, ($page-1) * $limit);
		}
		else if ($album == -1)
		{
			$url_array = array(
				'i' => '-phpbbgallery-core-acp-gallery_logs_module',
				'mode' => 'main',
				'lf' => $type
			);
			if (isset($additional['sort_days']))
			{
				$url_array['st'] = $additional['sort_days'];
			}
			if (isset($additional['sort_key']))
			{
				$url_array['sk'] = $additional['sort_key'];
			}
			if (isset($additional['sort_dir']))
			{
				$url_array['sd'] = $additional['sort_dir'];
			}
			$url = http_build_query($url_array,'','&');

			$this->pagination->generate_template_pagination(append_sid('index.php?' . $url), 'pagination', 'page', $count, $limit, ($page-1) * $limit);

The function append_sid was not found. Maybe you did not declare it correctly or list all dependencies?

		}
		else
		{
			$this->pagination->generate_template_pagination(array(
				'routes' => array(
					'phpbbgallery_core_moderate_action_log_album',
					'phpbbgallery_core_moderate_action_log_album_page',
				),
				'params' => array(
					'album_id'	=> $album,
				),
			), 'pagination', 'page', $count, $limit, ($page-1) * $limit);
		}