summaryrefslogtreecommitdiffstats
path: root/application/models/EventMapper.php
diff options
context:
space:
mode:
Diffstat (limited to 'application/models/EventMapper.php')
-rwxr-xr-xapplication/models/EventMapper.php24
1 files changed, 24 insertions, 0 deletions
diff --git a/application/models/EventMapper.php b/application/models/EventMapper.php
index 91fdc4a..092ab63 100755
--- a/application/models/EventMapper.php
+++ b/application/models/EventMapper.php
@@ -412,4 +412,28 @@ class Application_Model_EventMapper
return $return;
}
+ public function getDraggingEvents($eventID) {
+
+ $db = Zend_Db_Table::getDefaultAdapter();
+ $select = 'SELECT * FROM poolctrl_event WHERE title = (SELECT title FROM poolctrl_event WHERE eventID = ?)';
+ $stmt = $db->query($select, array(''.$eventID));
+ $return = $stmt->fetchAll();
+
+ return $return;
+
+ }
+
+ public function getNotDraggingEvents($eventID) {
+
+ $db = Zend_Db_Table::getDefaultAdapter();
+ $select = 'SELECT * FROM poolctrl_event WHERE title <> (SELECT title FROM poolctrl_event WHERE eventID = ?)';
+ $stmt = $db->query($select, array(''.$eventID));
+ $return = $stmt->fetchAll();
+
+ return $return;
+
+ }
+
+ //$others[] = SELECT * FROM events WHERE id NOT IN (implode(',', $events_ids))
+
} \ No newline at end of file