mt-wp-plugin.shortcodes.php

<?php
use MT\WP\Plugin\Api\MT_Photo;
use MT\WP\Plugin\Api\MT_News;
use MT\WP\Plugin\Common\MT_QueryBuilder;
use MT\WP\Plugin\Api\MT_Photographer;

add_shortcode('mt_photo', function ($atts) {
	$a = shortcode_atts(array(
		'id' => '',
		'width' => '200'
	), $atts);
	
	$photo = new MT_Photo($a['id']);
	$item = $photo->getOne(array('id', 'path'), 'ARRAY_A');
	return '<img width="'.$a['width'].'" src="bilder/'.$item['path'].'">';
});

add_shortcode('total_number_of_photos', function ($atts) {
	return (new MT_Photo)->getCount();
});

add_shortcode('latest_news_date', function ($atts) {
	$a = shortcode_atts(array(
		'format' => '%e. %B %Y'
	), $atts);
	
	return utf8_encode(strftime($a['format'], (new MT_News())->getLatestNewsTimestamp()));
});

add_shortcode('latest_photo_date', function ($atts) {
	$a = shortcode_atts(array(
		'format' => '%e. %B %Y'
	), $atts);
	
	return utf8_encode(strftime($a['format'], (new MT_Photo())->getLatestPhotoDate()));
});

add_shortcode('mt_statistics', function ($atts) {
	$returnString = '
			<table class="horizontalLeft">
			 <tr>
			  <th>'.__('Galerie', MT_NAME).'</th>
			  <th>'.__('Anzahl der Bilder', MT_NAME).'</th>
			 </tr>	
	';
	$tempCategoryId = 0;
	$tempSubcategoryId = 0;

	$query = (new MT_QueryBuilder())
		->from('photo')
		->select('COUNT(wp_mt_photo.id) as numPhotos')
		->joinInner('gallery', true, array('id AS galleryId', 'name as galleryName'))
		->joinInner('category', 'wp_mt_category.id = wp_mt_gallery.category', array('id AS categoryId', 'name AS categoryName'))
		->joinLeftOuter('subcategory', 'wp_mt_subcategory.id = wp_mt_gallery.subcategory', array('id AS subcategoryId', 'name subcategoryName'))
		->whereEqual('wp_mt_photo.show', 1)
		->groupBy(array('categoryName', 'subcategoryName', 'galleryName'))
		->orderBy(array('categoryName', 'subcategoryName', 'galleryName'));
	foreach ($query->getResult() as $row) {
		// Category
		if ($row->categoryId != $tempCategoryId) {
			$tempCategoryId = $row->categoryId;
			$returnString .= '
			 <tr>
			  <td><u>'.$row->categoryName.'</u></td>
			  <td></td>
			 </tr>';
		}

		// Subcategory
		if ($row->subcategoryId != $tempSubcategoryId) {
			$tempSubcategoryId = $row->subcategoryId;
			$returnString .= '
			 <tr>
			  <td>&nbsp;&nbsp;»&nbsp;&nbsp;'.$row->subcategoryName.'</td>
			  <td></td>
			 </tr>';
		}

		// Gallery
		$returnString .= '
			 <tr>
			  <td>&nbsp;&nbsp;&nbsp;&nbsp;»&nbsp;&nbsp;<a href="'.MT_Photo::GALLERY_PATH_ABS.'/'.$row->galleryId.'">'.$row->galleryName.'</a></td>
			  <td>'.$row->numPhotos.'</td>
			 </tr>';
	}
	$returnString .= '</table>';
	return $returnString;
});

add_shortcode('mt_recent_post', function ($atts) {
	$recent_posts = wp_get_recent_posts();
	$returnString = '';
	foreach ($recent_posts as $recent) {
		$returnString .= '<h3>'.$recent["post_title"].'</h3>'.$recent["post_content"].'<div class="postDate">Verfasst am: '.$recent["post_modified"].'</div>';
	}
	return $returnString;
});

add_shortcode('mt_news', function ($atts) {
	$returnString = '';

	$dateYear_old = '';
	$dateMonth_old = '';
	$dateDay_old = '';

	$newsItems = MT_News::getAll(array('title', 'text', 'gallery', 'date' ), 'date DESC');
	foreach ($newsItems as $item) {
		// News link
		if (empty($item->gallery)) {
			$news_link = '../';
		} else {
			$news_link = MT_Photo::GALLERY_PATH_ABS.'/'.$item->gallery;
		}

		// Year
		$dateYear = utf8_encode(strftime('%Y', $item->date));
		if ($dateYear != $dateYear_old && $dateYear != date('Y', time())) {
			$dateYear_old = $dateYear;
			$returnString .= '
			</table>
			<hr>
			<center><h2>' . $dateYear . '</h2></center>';
		}

		// Month
		$dateMonth = utf8_encode(strftime('%B', $item->date));
		if ($dateMonth != $dateMonth_old) {
			// Beim ersten Monat <table> noch nicht beenden
			if (!empty($dateMonth_old)) {
				$returnString .= '</table>';
			}
			$dateMonth_old = $dateMonth;

			$returnString .= '
			<h3>' . $dateMonth . '</h3>
			<table class="table_quer" cellSpacing="4" cellPadding="1">
				<colgroup>
					<col width="95px">
					<col width="*">
				</colgroup>';
		}

		// Day
		$returnString .= '<tr>';
				
		$dateDay = utf8_encode(strftime('%a, %d.%m.', $item->date));
				
		if ($dateDay != $dateDay_old) {
			$dateDay_old = $dateDay;
			$returnString .= '<th>'. $dateDay . ':</th>';
		} else {
			$returnString .= '<th></th>';
		}
		$returnString .= '<td><a href="' . $news_link . '">' . $item->title . '</a><br>' . $item->text . '</td>
				</tr>';
	}
	$returnString .= '</table>';
	return $returnString;
});

add_shortcode('mt_photographers', function ($atts) {
	$returnString = '<ul>';
	
	$photo = new MT_Photo();
	
	$items = MT_Photographer::getAll(array('id', 'name'), 'name');
	foreach ($items as $item) {
		$returnString .= '<li><a href="'.MT_Photographer::$photographersPath.$item->id.'">'.$item->name.'</a>&nbsp;<span class="style_grew">('.$photo->getNumPhotos($item->id).')</span></li>';
	}
	$returnString .= '</ul>';
	return $returnString;
});