3 files changed, 116 insertions, 0 deletions
diff --git a/subsonic-backend/src/main/webapp/WEB-INF/jsp/backend/db.jsp b/subsonic-backend/src/main/webapp/WEB-INF/jsp/backend/db.jsp
new file mode 100644
index 00000000..c3e1eb39
--- /dev/null
+++ b/subsonic-backend/src/main/webapp/WEB-INF/jsp/backend/db.jsp
@@ -0,0 +1,51 @@
+<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="iso-8859-1"%>
+
+<html><head>
+    <%@ include file="../head.jsp" %>
+    <link rel="stylesheet" type="text/css" href="http://yui.yahooapis.com/2.8.0r4/build/reset/reset.css">
+    <link rel="stylesheet" type="text/css" href="http://yui.yahooapis.com/2.8.0r4/build/fonts/fonts.css">
+    <link rel="stylesheet" type="text/css" href="http://yui.yahooapis.com/2.8.0r4/build/grid/grid.css">
+    <link rel="stylesheet" type="text/css" href="http://yui.yahooapis.com/2.8.0r4/build/base/base.css">
+</head><body>
+
+<h1>Database query</h1>
+
+<form method="post" action="db.view">
+    <textarea rows="10" cols="80" name="query" style="margin-top:1em">${model.query}</textarea>
+    <input type="submit" value="OK">
+    <input type="hidden" name="p" value="${model.p}">
+</form>
+
+
+<c:if test="${not empty model.result}">
+    <h1 style="margin-top:2em">Result</h1>
+
+    <table>
+        <c:forEach items="${model.result}" var="row" varStatus="loopStatus">
+
+            <c:if test="${loopStatus.count == 1}">
+                <tr>
+                    <c:forEach items="${row}" var="entry">
+                        <td>${entry.key}</td>
+                    </c:forEach>
+                </tr>
+            </c:if>
+            <tr>
+                <c:forEach items="${row}" var="entry">
+                    <td>${entry.value}</td>
+                </c:forEach>
+            </tr>
+        </c:forEach>
+
+    </table>
+</c:if>
+
+<c:if test="${not empty model.error}">
+    <h1 style="margin-top:2em">Error</h1>
+
+    <p>
+        ${model.error}
+    </p>
+</c:if>
+
+</body></html>
+\ No newline at end of file
diff --git a/subsonic-backend/src/main/webapp/WEB-INF/jsp/backend/payment.jsp b/subsonic-backend/src/main/webapp/WEB-INF/jsp/backend/payment.jsp
new file mode 100644
index 00000000..c72f798d
--- /dev/null
+++ b/subsonic-backend/src/main/webapp/WEB-INF/jsp/backend/payment.jsp
@@ -0,0 +1,23 @@
+<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="iso-8859-1" %>
+
+<html>
+<head>
+    <%@ include file="../head.jsp" %>
+    <link rel="stylesheet" type="text/css" href="http://yui.yahooapis.com/2.8.0r4/build/reset/reset.css">
+    <link rel="stylesheet" type="text/css" href="http://yui.yahooapis.com/2.8.0r4/build/fonts/fonts.css">
+    <link rel="stylesheet" type="text/css" href="http://yui.yahooapis.com/2.8.0r4/build/grid/grid.css">
+    <link rel="stylesheet" type="text/css" href="http://yui.yahooapis.com/2.8.0r4/build/base/base.css">
+    <meta http-equiv="refresh" content="300">
+</head>
+<body>
+
+<div style="margin-left: auto; margin-right: auto;width:10em">
+    <h1 style="text-align: center;">&euro;${model.sumToday}</h1>
+
+    <div style="white-space: nowrap; text-align:center;">
+        <span title="Sum yesterday">Y <b>&euro;${model.sumYesterday}</b></span> &nbsp;&nbsp;
+        <span title="Daily average this month">M <b>&euro;${model.dayAverageThisMonth}</b></span>
+    </div>
+</div>
+</body>
+</html>
+\ No newline at end of file
diff --git a/subsonic-backend/src/main/webapp/WEB-INF/jsp/backend/requestLicense.jsp b/subsonic-backend/src/main/webapp/WEB-INF/jsp/backend/requestLicense.jsp
new file mode 100644
index 00000000..c8654663
--- /dev/null
+++ b/subsonic-backend/src/main/webapp/WEB-INF/jsp/backend/requestLicense.jsp
@@ -0,0 +1,42 @@
+<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="iso-8859-1" %>
+
+<html>
+<head>
+    <%@ include file="../head.jsp" %>
+    <link rel="stylesheet" type="text/css" href="http://yui.yahooapis.com/2.8.0r4/build/reset/reset.css">
+    <link rel="stylesheet" type="text/css" href="http://yui.yahooapis.com/2.8.0r4/build/fonts/fonts.css">
+    <link rel="stylesheet" type="text/css" href="http://yui.yahooapis.com/2.8.0r4/build/grid/grid.css">
+    <link rel="stylesheet" type="text/css" href="http://yui.yahooapis.com/2.8.0r4/build/base/base.css">
+</head>
+<body>
+
+<h1>Resend Subsonic license key</h1>
+
+<c:if test="${empty model.email}">
+    <p>Have you purchased a Subsonic license but lost the license key?</p>
+
+    <p>Enter your email address below to have it resent to you.</p>
+</c:if>
+
+<c:if test="${not empty model.email and not model.valid}">
+    <p>Sorry, no license key is associated to ${model.email}. Did you use a different email address when
+        creating the payment on PayPal?</p>
+</c:if>
+
+<c:choose>
+    <c:when test="${model.valid}">
+        <p>Your license key has been sent to ${model.email}. Didn't get it? Please remember to check your spam
+            folder.</p>
+    </c:when>
+    <c:otherwise>
+        <form method="post" action="requestLicense.view">
+            <label>Email address
+                <input type="text" size="30" name="email">
+            </label>
+            <input type="submit" value="Send license key">
+        </form>
+    </c:otherwise>
+</c:choose>
+
+</body>
+</html>
+\ No newline at end of file