From 823d71ced9b4947b1a5a5ade7245d521ed490061 Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
Date: Tue, 7 Jun 2016 15:17:49 +0200
Subject:  * renaming php directory

---
 app/frontend/sqlmap/config.xml |  9 +++++++++
 app/frontend/sqlmap/events.xml | 11 +++++++++++
 2 files changed, 20 insertions(+)
 create mode 100644 app/frontend/sqlmap/config.xml
 create mode 100644 app/frontend/sqlmap/events.xml

(limited to 'app/frontend/sqlmap')

diff --git a/app/frontend/sqlmap/config.xml b/app/frontend/sqlmap/config.xml
new file mode 100644
index 0000000..101e1b7
--- /dev/null
+++ b/app/frontend/sqlmap/config.xml
@@ -0,0 +1,9 @@
+<?xml version="1.0" encoding="utf-8"?>
+<sqlMapConfig>
+  <provider class="TAdodbProvider">
+    <datasource ConnectionID="db" />
+  </provider>
+  <sqlMaps>
+    <sqlMap name="events" resource="events.xml" />
+  </sqlMaps>
+</sqlMapConfig>
diff --git a/app/frontend/sqlmap/events.xml b/app/frontend/sqlmap/events.xml
new file mode 100644
index 0000000..030a773
--- /dev/null
+++ b/app/frontend/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 $order_clause$;
+    ]]>
+  </select>
+</sqlMapConfig>
-- 
cgit v1.2.3