summaryrefslogtreecommitdiffstats
path: root/application/models
diff options
context:
space:
mode:
authorSebastian Wagner2011-10-02 17:13:17 +0200
committerSebastian Wagner2011-10-02 17:13:17 +0200
commite504912258dc813a621fec6a8b3f6e8778221d88 (patch)
tree509f9283b1a73e32af683a337051469b0d9250ad /application/models
parentsome changes (diff)
downloadpoolctrl-e504912258dc813a621fec6a8b3f6e8778221d88.tar.gz
poolctrl-e504912258dc813a621fec6a8b3f6e8778221d88.tar.xz
poolctrl-e504912258dc813a621fec6a8b3f6e8778221d88.zip
some changes
Diffstat (limited to 'application/models')
-rwxr-xr-xapplication/models/EventMapper.php29
-rwxr-xr-xapplication/models/EventcategoryMapper.php31
2 files changed, 29 insertions, 31 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
diff --git a/application/models/EventcategoryMapper.php b/application/models/EventcategoryMapper.php
index 1ba0369..b70a116 100755
--- a/application/models/EventcategoryMapper.php
+++ b/application/models/EventcategoryMapper.php
@@ -82,37 +82,6 @@ class Application_Model_EventcategoryMapper
return $this->_dbTable;
}
-
- /*public function getCategoryCount() {
-
-
- $select = $db->select()
- ->from(array('p' => 'products'),
- array('product_id'))
- ->join(array('l' => 'line_items'),
- 'p.product_id = l.product_id',
- array('line_items_per_product' => 'COUNT(*)'))
- ->group('p.product_id');
-
-
-// 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
-
-
- }*/
-
-
public function save(Application_Model_Eventcategory $eventcategory)
{