[images] Add very simple image management page

3 files changed, 103 insertions, 0 deletions

diff --git a/modules/images.inc.php b/modules/images.inc.php
new file mode 100644
index 0000000..f962c07
--- /dev/null
+++ b/modules/images.inc.php
@@ -0,0 +1,51 @@
+<?php
+
+class Page_Images extends Page
+{
+
+	protected function doPreprocess()
+	{
+		User::load();
+		if (!User::isShibbolethAuth()) {
+			Message::addError('Not {{0}}', CONFIG_IDM);
+			Util::redirect('?do=Main');
+		}
+		if (!User::isAdmin()) {
+			Message::addError('Not admin!');
+			Util::redirect('?do=Main');
+		}
+		if (Request::post('action') === 'delete') {
+			$image = Request::post('image');
+			$row = Database::queryFirst('SELECT filepath FROM imageversion WHERE imageversionid = :version',
+				['version' => $image]);
+			if ($row === false) {
+				Message::addError('Image {{0}} nicht gefunden', $image);
+			} else {
+				// PHP process doesn't have write permissions to VM store, plus we don't have the absolute path
+				// for now this has to do, until someone comes along and adds an RPC method in the java app.
+				Message::addInfo('Vergessen Sie nicht, {{0}} vom Storage zu löschen', $row['filepath']);
+				Database::exec("DELETE FROM imageversion WHERE imageversionid = :version",
+					['version' => $image]);
+			}
+			Util::redirect('?do=images');
+		}
+	}
+
+	protected function doRender()
+	{
+		$res = Database::simpleQuery('SELECT b.displayname, b.description,
+       		v.imageversionid, v.createtime, v.expiretime, v.filesize, v.filepath
+				FROM imagebase b
+				INNER JOIN imageversion v USING (imagebaseid)
+				ORDER BY b.imagebaseid ASC, v.createtime ASC');
+		$rows = [];
+		while ($row = $res->fetch(PDO::FETCH_ASSOC)) {
+			$row['createtime_s'] = date('d.m.Y', $row['createtime']);
+			$row['expiretime_s'] = date('d.m.Y', $row['expiretime']);
+			$row['filesize_s'] = Util::readableFileSize($row['filesize']);
+			$rows[] = $row;
+		}
+		Render::addTemplate('image-list', ['list' => $rows]);
+	}
+
+}
diff --git a/templates/image-list.html b/templates/image-list.html
new file mode 100644
index 0000000..3c4561e
--- /dev/null
+++ b/templates/image-list.html
@@ -0,0 +1,51 @@
+<h1>Images</h1>
+
+<div class="alert alert-warning">
+	Die Löschfunktion entfernt lediglich den Datenbankeintrag. Bitte <b>löschen Sie die zugehörige Datei</b>
+	aus dem Storage-Verzeichnis (Spalte Pfad)
+</div>
+
+<form method="post" action="?do=images">
+	<input type="hidden" name="token" value="{{token}}">
+	<input type="hidden" name="action" value="delete">
+	<table class="table">
+		<thead>
+		<tr>
+			<th>Name</th>
+			<th>Größe</th>
+			<th>Erstellt</th>
+			<th>Läuft ab</th>
+			<th>Pfad</th>
+			<th></th>
+		</tr>
+		</thead>
+		<tbody>
+		{{#list}}
+		<tr>
+			<td title="{{description}}">
+				{{displayname}}
+				<div class="small">{{imageversionid}}</div>
+			</td>
+			<td class="slx-nowrap">
+				{{filesize_s}}
+			</td>
+			<td class="slx-nowrap">
+				{{createtime_s}}
+			</td>
+			<td class="slx-nowrap">
+				{{expiretime_s}}
+			</td>
+			<td class="small">
+				{{filepath}}
+			</td>
+			<td>
+				<button type="submit" name="image" value="{{imageversionid}}" class="btn btn-xs btn-danger"
+						onclick="return confirm('Wirklich?')">
+					<span class="glyphicon glyphicon-remove"></span>
+				</button>
+			</td>
+		</tr>
+		{{/list}}
+		</tbody>
+	</table>
+</form>
\ No newline at end of file
diff --git a/templates/main-menu.html b/templates/main-menu.html
index e4583cc..ea32b1d 100644
--- a/templates/main-menu.html
+++ b/templates/main-menu.html
@@ -13,6 +13,7 @@
 			<ul class="nav navbar-nav">
 				{{#admin}}
 				<li><a href="?do=AddUser">AddUser</a></li>
+				<li><a href="?do=images">Manage Images</a></li>
 				{{/admin}}
 			</ul>
 			<ul class="nav navbar-nav navbar-right">