prepareAttachsByMsg()

Complexity

Conditions	21
Paths	178

Size

Total Lines	80
Code Lines	42

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
function prepareAttachsByMsg($msgIDs)
{
	global $context, $modSettings, $smcFunc, $sourcedir;

	if (empty($context['loaded_attachments']))
		$context['loaded_attachments'] = array();
	// Remove all $msgIDs that we already processed
	else
		$msgIDs = array_diff($msgIDs, array_keys($context['loaded_attachments']), array(0));

	// Ensure that $msgIDs doesn't contain zero or non-integers.
	$msgIDs = array_filter(array_map('intval', $msgIDs));

	if (!empty($msgIDs) || !empty($_SESSION['attachments_can_preview']))
	{
		// Where clause - there may or may not be msg ids, & may or may not be attachs to preview,
		// depending on post vs edit, inserted or not, preview or not, post error or not, etc.
		// Either way, they may be needed in a display of a list of posts or in the dropzone 'mock' list of thumbnails.
		$msg_or_att = '';
		if (!empty($msgIDs))
			$msg_or_att .= 'a.id_msg IN ({array_int:message_id}) ';
		if (!empty($msgIDs) && !empty($_SESSION['attachments_can_preview']))
			$msg_or_att .= 'OR ';
		if (!empty($_SESSION['attachments_can_preview']))
			$msg_or_att .= 'a.id_attach IN ({array_int:preview_attachments})';

		// This tries to get all attachments for the page being displayed, to build a cache of attach info.
		// This is also being used by POST, so it may need to grab attachs known only in the session.
		$request = $smcFunc['db_query']('', '
			SELECT
				a.id_attach, a.id_folder, a.id_msg, a.filename, a.file_hash, COALESCE(a.size, 0) AS filesize, a.downloads, a.approved, m.id_topic AS topic, m.id_board AS board, m.id_member, a.mime_type,
				a.width, a.height' . (empty($modSettings['attachmentShowImages']) || empty($modSettings['attachmentThumbnails']) ? '' : ',
				COALESCE(thumb.id_attach, 0) AS id_thumb, thumb.width AS thumb_width, thumb.height AS thumb_height') . '
			FROM {db_prefix}attachments AS a' . (empty($modSettings['attachmentShowImages']) || empty($modSettings['attachmentThumbnails']) ? '' : '
				LEFT JOIN {db_prefix}attachments AS thumb ON (thumb.id_attach = a.id_thumb)') . '
				LEFT JOIN {db_prefix}messages AS m ON (m.id_msg = a.id_msg)
			WHERE a.attachment_type = {int:attachment_type}
				AND (' . $msg_or_att . ')',
			array(
				'message_id' => $msgIDs,
				'attachment_type' => 0,
				'preview_attachments' => !empty($_SESSION['attachments_can_preview']) ? array_keys(array_filter($_SESSION['attachments_can_preview'])) : array(0),
			)
		);
		$rows = $smcFunc['db_fetch_all']($request);
		$smcFunc['db_free_result']($request);

		foreach ($rows as $row)
		{
			// SVGs are special.
			if ($row['mime_type'] === 'image/svg+xml')
			{
				if (empty($row['width']) || empty($row['height']))
				{
					require_once($sourcedir . '/Subs-Graphics.php');

					$row = array_merge($row, getSvgSize(getAttachmentFilename($row['filename'], $row['id_attach'], $row['id_folder'])));
				}

				// SVG is its own thumbnail.
				if (isset($row['id_thumb']))
				{
					$row['id_thumb'] = $row['id_attach'];

					// For SVGs, we don't need to calculate thumbnail size precisely.
					$row['thumb_width'] = min($row['width'], !empty($modSettings['attachmentThumbWidth']) ? $modSettings['attachmentThumbWidth'] : 1000);
					$row['thumb_height'] = min($row['height'], !empty($modSettings['attachmentThumbHeight']) ? $modSettings['attachmentThumbHeight'] : 1000);

					// Must set the thumbnail's CSS dimensions manually.
					addInlineCss('img#thumb_' . $row['id_thumb'] . ':not(.original_size) {width: ' . $row['thumb_width'] . 'px; height: ' . $row['thumb_height'] . 'px;}');
				}
			}

			if (empty($context['loaded_attachments'][$row['id_msg']]))
				$context['loaded_attachments'][$row['id_msg']] = array();

			$context['loaded_attachments'][$row['id_msg']][$row['id_attach']] = $row;

			// This is better than sorting it with the query...
			ksort($context['loaded_attachments'][$row['id_msg']]);
		}
?>