summaryrefslogtreecommitdiffstats
path: root/application/models
diff options
context:
space:
mode:
authorSebastian Wagner2011-09-30 17:09:23 +0200
committerSebastian Wagner2011-09-30 17:09:23 +0200
commita19068db1ccc0982fa604edd32a7e5351e2e2388 (patch)
tree6c47536137b9d7104806ac7361310dc7d16e9107 /application/models
parentbugfix (diff)
downloadpoolctrl-a19068db1ccc0982fa604edd32a7e5351e2e2388.tar.gz
poolctrl-a19068db1ccc0982fa604edd32a7e5351e2e2388.tar.xz
poolctrl-a19068db1ccc0982fa604edd32a7e5351e2e2388.zip
some changes
Diffstat (limited to 'application/models')
-rwxr-xr-xapplication/models/EventcategoryMapper.php31
1 files changed, 31 insertions, 0 deletions
diff --git a/application/models/EventcategoryMapper.php b/application/models/EventcategoryMapper.php
index b70a116..1ba0369 100755
--- a/application/models/EventcategoryMapper.php
+++ b/application/models/EventcategoryMapper.php
@@ -82,6 +82,37 @@ 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)
{