diff options
| author | emkael <emkael@tlen.pl> | 2016-06-07 15:17:49 +0200 |
|---|---|---|
| committer | emkael <emkael@tlen.pl> | 2016-06-10 11:46:41 +0200 |
| commit | 823d71ced9b4947b1a5a5ade7245d521ed490061 (patch) | |
| tree | a9a6c7cb0de74ff705e8320c284de423a698f5b5 /app/frontend/sqlmap | |
| parent | df401552aac363655ab8f056a6c910a7611954d6 (diff) | |
* renaming php directory
Diffstat (limited to 'app/frontend/sqlmap')
| -rw-r--r-- | app/frontend/sqlmap/config.xml | 9 | ||||
| -rw-r--r-- | app/frontend/sqlmap/events.xml | 11 |
2 files changed, 20 insertions, 0 deletions
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> |