summaryrefslogtreecommitdiffstats
path: root/application/models/EventMapper.php
diff options
context:
space:
mode:
Diffstat (limited to 'application/models/EventMapper.php')
-rwxr-xr-xapplication/models/EventMapper.php29
1 files changed, 29 insertions, 0 deletions
diff --git a/application/models/EventMapper.php b/application/models/EventMapper.php
index cacff29..71d472d 100755
--- a/application/models/EventMapper.php
+++ b/application/models/EventMapper.php
@@ -183,4 +183,33 @@ class Application_Model_EventMapper
$vv2 = $v2->toArray();
return array_diff($vv1,$vv2);
}
+
+ public function getCategoryCount() {
+
+ $db = Zend_Db_Table::getDefaultAdapter();
+ $select = $this->getDbTable()->select()
+ ->from($this->_dbTable,
+ array('count' => 'COUNT(*)', 'category'))
+ ->group('category');
+ $stmt = $db->query($select);
+ $result = $stmt->fetchAll();
+
+ return array($result);
+ }
+
+ /* Erzeugt diese Anfrage:
+ // SELECT p."product_id", COUNT(*) AS line_items_per_product
+ // FROM "products" AS p JOIN "line_items" AS l
+ // ON p.product_id = l.product_id
+ // GROUP BY p.product_id
+ *
+ *
+ *
+ *
+ * SELECT category, COUNT( * ) AS count
+ * FROM `poolctrl_event`
+ * GROUP BY category
+ * LIMIT 0 , 30
+ */
+
} \ No newline at end of file