From e509fc24d904831759071134361bef1503d4ff87 Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
Date: Tue, 15 Mar 2016 23:59:33 +0100
Subject:  * facade for event list fetch

---
 app/php/sqlmap/config.xml |  1 +
 app/php/sqlmap/events.xml | 11 +++++++++++
 2 files changed, 12 insertions(+)
 create mode 100644 app/php/sqlmap/events.xml

(limited to 'app/php/sqlmap')

diff --git a/app/php/sqlmap/config.xml b/app/php/sqlmap/config.xml
index 7c213a3..101e1b7 100644
--- a/app/php/sqlmap/config.xml
+++ b/app/php/sqlmap/config.xml
@@ -4,5 +4,6 @@
     <datasource ConnectionID="db" />
   </provider>
   <sqlMaps>
+    <sqlMap name="events" resource="events.xml" />
   </sqlMaps>
 </sqlMapConfig>
diff --git a/app/php/sqlmap/events.xml b/app/php/sqlmap/events.xml
new file mode 100644
index 0000000..5980b27
--- /dev/null
+++ b/app/php/sqlmap/events.xml
@@ -0,0 +1,11 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<sqlMapConfig>
+  <select id="getEvents" resultClass="Entry">
+    <![CDATA[
+             SELECT * FROM entries
+             WHERE end_date >= #date_from# AND begin_date <= #date_to#
+               AND $calendar_clause$
+             ORDER BY begin_date ASC;
+    ]]>
+  </select>
+</sqlMapConfig>
-- 
cgit v1.2.3