phpbbgallery\core\moderate::album_overview()

Complexity

Conditions	15
Paths	322

Size

Total Lines	133
Code Lines	95

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	240

Importance

Changes

0

<?php
	public function album_overview($album_id, $page = 1, $per_page = 0)
	{
		// So if we are not forcing par page get it from config
		if ($per_page == 0)
		{
			$per_page = $this->gallery_config->get('items_per_page');
		}
		// Let's get albums that user can moderate
		$this->gallery_auth->load_user_permissions($this->user->data['user_id']);

		// we have security in the controller, so no need to be paranoid ...
		// and we will build queue with only items user can review
		if (!isset($album_id))
		{
			return;
		}
		// Let's see what the user can do?
		$status[] = 1;

$status was never initialized. Although not strictly required by PHP, it is generally a good practice to add $status = array(); before regardless.

		$actions = array();
		$this->gallery_auth->load_user_permissions($this->user->data['user_id']);
		$album = $this->album->get_info($album_id);
		if ($this->gallery_auth->acl_check('m_status', $album['album_id'], $album['album_user_id']))
		{
			$status[] = 0;
			$status[] = 2;
			$actions['approve'] = 'QUEUES_A_APPROVE';
			$actions['unapprove'] = 'QUEUES_A_UNAPPROVE';
			$actions['lock'] = 'QUEUES_A_LOCK';
		}
		if ($this->gallery_auth->acl_check('m_delete', $album['album_id'], $album['album_user_id']))
		{
			$actions['delete'] = 'QUEUES_A_DELETE';
		}
		if ($this->gallery_auth->acl_check('m_move', $album['album_id'], $album['album_user_id']))
		{
			$actions['move'] = 'QUEUES_A_MOVE';
		}
		if ($this->gallery_auth->acl_check('m_report', $album['album_id'], $album['album_user_id']))
		{
			$actions['report'] = 'REPORT_A_CLOSE';
		}
		$sql = 'SELECT COUNT(DISTINCT image_id) AS count FROM ' . $this->images_table . ' WHERE ' . $this->db->sql_in_set('image_status', $status) . ' AND image_album_id = ' . (int) $album_id;
		$result = $this->db->sql_query($sql);
		$row = $this->db->sql_fetchrow($result);
		$this->db->sql_freeresult($result);
		$count = $row['count'];
		$sql = 'SELECT * FROM ' . $this->images_table . ' WHERE ' . $this->db->sql_in_set('image_status', $status) . ' AND image_album_id = ' . (int) $album_id . ' ORDER BY image_id DESC';

		$result = $this->db->sql_query_limit($sql, $per_page, ($page - 1) * $per_page);
		$users_array = array();
		$images = array();
		while ($row = $this->db->sql_fetchrow($result))
		{
			$images[] = array(
				'image_id'             => $row['image_id'],
				'image_filename'       => $row['image_filename'],
				'image_name'           => $row['image_name'],
				'image_name_clean'     => $row['image_name_clean'],
				'image_desc'           => $row['image_desc'],
				'image_desc_uid'       => $row['image_desc_uid'],
				'image_desc_bitfield'  => $row['image_desc_bitfield'],
				'image_user_id'        => $row['image_user_id'],
				'image_username'       => $row['image_username'],
				'image_username_clean' => $row['image_username_clean'],
				'image_user_colour'    => $row['image_user_colour'],
				'image_user_ip'        => $row['image_user_ip'],
				'image_time'           => $row['image_time'],
				'image_album_id'       => $row['image_album_id'],
				'image_view_count'     => $row['image_view_count'],
				'image_status'         => $row['image_status'],
				'image_filemissing'    => $row['image_filemissing'],
				'image_rates'          => $row['image_rates'],
				'image_rate_points'    => $row['image_rate_points'],
				'image_rate_avg'       => $row['image_rate_avg'],
				'image_comments'       => $row['image_comments'],
				'image_last_comment'   => $row['image_last_comment'],
				'image_allow_comments' => $row['image_allow_comments'],
				'image_favorited'      => $row['image_favorited'],
				'image_reported'       => $row['image_reported'],
				'filesize_upload'      => $row['filesize_upload'],
				'filesize_medium'      => $row['filesize_medium'],
				'filesize_cache'       => $row['filesize_cache'],
			);
			$users_array[$row['image_user_id']] = array('');
		}
		$this->db->sql_freeresult($result);

		if (empty($users_array))
		{
			return;
		}

		// Load users
		$this->user_loader->load_users(array_keys($users_array));
		foreach ($images as $var)
		{
			$this->template->assign_block_vars('overview', array(
				'U_IMAGE_ID'           => $var['image_id'],
				'U_IMAGE'              => $this->helper->route('phpbbgallery_core_image_file_mini', array('image_id' => $var['image_id'])),
				'U_IMAGE_URL'          => $this->helper->route('phpbbgallery_core_image', array('image_id' => $var['image_id'])),
				'U_IMAGE_MODERATE_URL' => $this->helper->route('phpbbgallery_core_moderate_image', array('image_id' => $var['image_id'])),
				'U_IMAGE_NAME'         => $var['image_name'],
				'IMAGE_AUTHOR'         => $this->user_loader->get_username($var['image_user_id'], 'full'),
				'IMAGE_TIME'           => $this->user->format_date($var['image_time']),
				'IMAGE_ALBUM'          => $album['album_name'],
				'IMAGE_ALBUM_URL'      => $this->helper->route('phpbbgallery_core_album', array('album_id' => $var['image_album_id'])),
				'IMAGE_ALBUM_ID'       => $var['image_album_id'],
				'U_IS_REPORTED'        => $this->gallery_auth->acl_check('m_report', $album['album_id'], $album['album_user_id']) && $var['image_reported'] > 0 ? true : false,
				'U_IS_UNAPPROVED'      => $var['image_status'] == 0 ? true : false,
				'U_IS_LOCKED'          => $var['image_status'] == 2 ? true : false,
			));
		}

		$this->pagination->generate_template_pagination(array(
			'routes' => array(
				'phpbbgallery_core_moderate_view',
				'phpbbgallery_core_moderate_view_page',
			),
			'params' => array(
				'album_id' => $album_id,
			),
		), 'pagination', 'page', $count, $per_page, ($page - 1) * $per_page);

		$select = '<select name="select_action">';
		foreach ($actions as $id => $var)
		{
			$select .= '<option value="' . $id . '">' . $this->lang->lang($var) . '</option>';
		}
		$select .= '</select>';
		$this->template->assign_vars(array(
			'TOTAL_PAGES'                        => $this->lang->lang('PAGE_TITLE_NUMBER', $page),
			'S_GALLERY_MODERATE_OVERVIEW_ACTION' => $this->helper->route('phpbbgallery_core_moderate_view', array('album_id' => $album_id)),
			'U_ACTION_SELECT'                    => $select,
		));