- Verbesserung der Suchfunktionen

10 files changed, 283 insertions, 16 deletions

diff --git a/protected/models/Standort.php b/protected/models/Standort.php
index f64ea51..d62a594 100644
--- a/protected/models/Standort.php
+++ b/protected/models/Standort.php
@@ -73,7 +73,7 @@ class Standort extends CActiveRecord
 	{
 		return array(
 			'id' => 'ID',
-			'type' => 'Type',
+			'type' => 'Typ',
 			'name' => 'Name',
 			'pos_lat' => 'Pos Lat',
 			'pos_long' => 'Pos Long',
diff --git a/protected/runtime/application.log b/protected/runtime/application.log
index 21df9c0..7187392 100644
--- a/protected/runtime/application.log
+++ b/protected/runtime/application.log
@@ -4906,3 +4906,263 @@ Stack trace:
 REQUEST_URI=/admin.astaf.de/index.php?r=veranstaltung/update&id=2
 HTTP_REFERER=http://dev.astaf.de:90/admin.astaf.de/index.php?r=veranstaltung/update&id=2
 ---
+2012/04/28 17:07:31 [error] [exception.CException] exception 'CException' with message 'Eigenschaft "Standort.typ ist nicht definiert.' in D:\Projects\Astaf\workspace\yii\framework\base\CComponent.php:131
+Stack trace:
+#0 D:\Projects\Astaf\workspace\yii\framework\db\ar\CActiveRecord.php(144): CComponent->__get('typ')
+#1 D:\Projects\Astaf\workspace\yii\framework\web\helpers\CHtml.php(2044): CActiveRecord->__get('typ')
+#2 D:\Projects\Astaf\workspace\yii\framework\web\helpers\CHtml.php(1774): CHtml::resolveValue(Object(Standort), 'typ')
+#3 D:\Projects\Astaf\workspace\yii\framework\web\helpers\CHtml.php(1205): CHtml::activeInputField('text', Object(Standort), 'typ', Array)
+#4 D:\Projects\Astaf\workspace\yii\framework\zii\widgets\grid\CDataColumn.php(105): CHtml::activeTextField(Object(Standort), 'typ', Array)
+#5 D:\Projects\Astaf\workspace\yii\framework\zii\widgets\grid\CGridColumn.php(106): CDataColumn->renderFilterCellContent()
+#6 D:\Projects\Astaf\workspace\yii\framework\zii\widgets\grid\CGridView.php(450): CGridColumn->renderFilterCell()
+#7 D:\Projects\Astaf\workspace\yii\framework\zii\widgets\grid\CGridView.php(428): CGridView->renderFilter()
+#8 D:\Projects\Astaf\workspace\yii\framework\zii\widgets\grid\CGridView.php(398): CGridView->renderTableHeader()
+#9 D:\Projects\Astaf\workspace\yii\framework\zii\widgets\CBaseListView.php(158): CGridView->renderItems()
+#10 [internal function]: CBaseListView->renderSection(Array)
+#11 D:\Projects\Astaf\workspace\yii\framework\zii\widgets\CBaseListView.php(141): preg_replace_callback('/{(\w+)}/', Array, '{summary}?{item...')
+#12 D:\Projects\Astaf\workspace\yii\framework\zii\widgets\CBaseListView.php(126): CBaseListView->renderContent()
+#13 D:\Projects\Astaf\workspace\yii\framework\web\CBaseController.php(174): CBaseListView->run()
+#14 D:\Projects\Astaf\workspace\admin.astaf.de\protected\views\standort\index.php(75): CBaseController->widget('zii.widgets.gri...', Array)
+#15 D:\Projects\Astaf\workspace\yii\framework\web\CBaseController.php(127): require('D:\Projects\Ast...')
+#16 D:\Projects\Astaf\workspace\yii\framework\web\CBaseController.php(96): CBaseController->renderInternal('D:\Projects\Ast...', Array, true)
+#17 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(870): CBaseController->renderFile('D:\Projects\Ast...', Array, true)
+#18 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(783): CController->renderPartial('index', Array, true)
+#19 D:\Projects\Astaf\workspace\admin.astaf.de\protected\controllers\StandortController.php(162): CController->render('index', Array)
+#20 D:\Projects\Astaf\workspace\yii\framework\web\actions\CInlineAction.php(50): StandortController->actionIndex()
+#21 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(309): CInlineAction->runWithParams(Array)
+#22 D:\Projects\Astaf\workspace\yii\framework\web\filters\CFilterChain.php(134): CController->runAction(Object(CInlineAction))
+#23 D:\Projects\Astaf\workspace\yii\framework\web\filters\CFilter.php(41): CFilterChain->run()
+#24 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(1146): CFilter->filter(Object(CFilterChain))
+#25 D:\Projects\Astaf\workspace\yii\framework\web\filters\CInlineFilter.php(59): CController->filterAccessControl(Object(CFilterChain))
+#26 D:\Projects\Astaf\workspace\yii\framework\web\filters\CFilterChain.php(131): CInlineFilter->filter(Object(CFilterChain))
+#27 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(292): CFilterChain->run()
+#28 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(266): CController->runActionWithFilters(Object(CInlineAction), Array)
+#29 D:\Projects\Astaf\workspace\yii\framework\web\CWebApplication.php(276): CController->run('index')
+#30 D:\Projects\Astaf\workspace\yii\framework\web\CWebApplication.php(135): CWebApplication->runController('standort/index')
+#31 D:\Projects\Astaf\workspace\yii\framework\base\CApplication.php(162): CWebApplication->processRequest()
+#32 D:\Projects\Astaf\workspace\admin.astaf.de\index.php(13): CApplication->run()
+#33 {main}
+REQUEST_URI=/admin.astaf.de/index.php?r=standort/index
+HTTP_REFERER=http://dev.astaf.de:90/admin.astaf.de/index.php?r=speisTrank/index
+---
+2012/04/28 17:17:23 [error] [php] Object of class Angebot could not be converted to string (D:\Projects\Astaf\workspace\yii\framework\web\helpers\CHtml.php:1712)
+Stack trace:
+#0 D:\Projects\Astaf\workspace\yii\framework\web\helpers\CHtml.php(727): inputField()
+#1 D:\Projects\Astaf\workspace\admin.astaf.de\protected\views\speisTrank\index.php(31): checkBox()
+#2 D:\Projects\Astaf\workspace\yii\framework\web\CBaseController.php(127): require()
+#3 D:\Projects\Astaf\workspace\yii\framework\web\CBaseController.php(96): SpeisTrankController->renderInternal()
+#4 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(870): SpeisTrankController->renderFile()
+#5 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(783): SpeisTrankController->renderPartial()
+#6 D:\Projects\Astaf\workspace\admin.astaf.de\protected\controllers\SpeisTrankController.php(135): SpeisTrankController->render()
+#7 D:\Projects\Astaf\workspace\yii\framework\web\actions\CInlineAction.php(50): SpeisTrankController->actionIndex()
+#8 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(309): CInlineAction->runWithParams()
+#9 D:\Projects\Astaf\workspace\yii\framework\web\filters\CFilterChain.php(134): SpeisTrankController->runAction()
+#10 D:\Projects\Astaf\workspace\yii\framework\web\filters\CFilter.php(41): CFilterChain->run()
+#11 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(1146): CAccessControlFilter->filter()
+#12 D:\Projects\Astaf\workspace\yii\framework\web\filters\CInlineFilter.php(59): SpeisTrankController->filterAccessControl()
+#13 D:\Projects\Astaf\workspace\yii\framework\web\filters\CFilterChain.php(131): CInlineFilter->filter()
+#14 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(292): CFilterChain->run()
+#15 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(266): SpeisTrankController->runActionWithFilters()
+#16 D:\Projects\Astaf\workspace\yii\framework\web\CWebApplication.php(276): SpeisTrankController->run()
+#17 D:\Projects\Astaf\workspace\yii\framework\web\CWebApplication.php(135): CWebApplication->runController()
+#18 D:\Projects\Astaf\workspace\yii\framework\base\CApplication.php(162): CWebApplication->processRequest()
+#19 D:\Projects\Astaf\workspace\admin.astaf.de\index.php(13): CWebApplication->run()
+REQUEST_URI=/admin.astaf.de/index.php?r=speisTrank/index
+in D:\Projects\Astaf\workspace\admin.astaf.de\protected\views\speisTrank\index.php (31)
+in D:\Projects\Astaf\workspace\admin.astaf.de\protected\controllers\SpeisTrankController.php (135)
+in D:\Projects\Astaf\workspace\admin.astaf.de\index.php (13)
+2012/04/28 17:17:54 [error] [php] Object of class Angebot could not be converted to string (D:\Projects\Astaf\workspace\yii\framework\web\helpers\CHtml.php:1712)
+Stack trace:
+#0 D:\Projects\Astaf\workspace\yii\framework\web\CBaseController.php(127): require()
+#1 D:\Projects\Astaf\workspace\yii\framework\web\CBaseController.php(96): SpeisTrankController->renderInternal()
+#2 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(870): SpeisTrankController->renderFile()
+#3 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(783): SpeisTrankController->renderPartial()
+#4 D:\Projects\Astaf\workspace\admin.astaf.de\protected\controllers\SpeisTrankController.php(135): SpeisTrankController->render()
+#5 D:\Projects\Astaf\workspace\yii\framework\web\actions\CInlineAction.php(50): SpeisTrankController->actionIndex()
+#6 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(309): CInlineAction->runWithParams()
+#7 D:\Projects\Astaf\workspace\yii\framework\web\filters\CFilterChain.php(134): SpeisTrankController->runAction()
+#8 D:\Projects\Astaf\workspace\yii\framework\web\filters\CFilter.php(41): CFilterChain->run()
+#9 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(1146): CAccessControlFilter->filter()
+#10 D:\Projects\Astaf\workspace\yii\framework\web\filters\CInlineFilter.php(59): SpeisTrankController->filterAccessControl()
+#11 D:\Projects\Astaf\workspace\yii\framework\web\filters\CFilterChain.php(131): CInlineFilter->filter()
+#12 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(292): CFilterChain->run()
+#13 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(266): SpeisTrankController->runActionWithFilters()
+#14 D:\Projects\Astaf\workspace\yii\framework\web\CWebApplication.php(276): SpeisTrankController->run()
+#15 D:\Projects\Astaf\workspace\yii\framework\web\CWebApplication.php(135): CWebApplication->runController()
+#16 D:\Projects\Astaf\workspace\yii\framework\base\CApplication.php(162): CWebApplication->processRequest()
+#17 D:\Projects\Astaf\workspace\admin.astaf.de\index.php(13): CWebApplication->run()
+REQUEST_URI=/admin.astaf.de/index.php?r=speisTrank/index
+in D:\Projects\Astaf\workspace\admin.astaf.de\protected\views\speisTrank\index.php (31)
+in D:\Projects\Astaf\workspace\admin.astaf.de\protected\controllers\SpeisTrankController.php (135)
+in D:\Projects\Astaf\workspace\admin.astaf.de\index.php (13)
+2012/04/28 17:20:40 [error] [php] Missing argument 1 for CHtml::checkBox(), called in D:\Projects\Astaf\workspace\admin.astaf.de\protected\views\speisTrank\index.php on line 31 and defined (D:\Projects\Astaf\workspace\yii\framework\web\helpers\CHtml.php:697)
+Stack trace:
+#0 D:\Projects\Astaf\workspace\yii\framework\web\CBaseController.php(96): SpeisTrankController->renderInternal()
+#1 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(870): SpeisTrankController->renderFile()
+#2 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(783): SpeisTrankController->renderPartial()
+#3 D:\Projects\Astaf\workspace\admin.astaf.de\protected\controllers\SpeisTrankController.php(135): SpeisTrankController->render()
+#4 D:\Projects\Astaf\workspace\yii\framework\web\actions\CInlineAction.php(50): SpeisTrankController->actionIndex()
+#5 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(309): CInlineAction->runWithParams()
+#6 D:\Projects\Astaf\workspace\yii\framework\web\filters\CFilterChain.php(134): SpeisTrankController->runAction()
+#7 D:\Projects\Astaf\workspace\yii\framework\web\filters\CFilter.php(41): CFilterChain->run()
+#8 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(1146): CAccessControlFilter->filter()
+#9 D:\Projects\Astaf\workspace\yii\framework\web\filters\CInlineFilter.php(59): SpeisTrankController->filterAccessControl()
+#10 D:\Projects\Astaf\workspace\yii\framework\web\filters\CFilterChain.php(131): CInlineFilter->filter()
+#11 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(292): CFilterChain->run()
+#12 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(266): SpeisTrankController->runActionWithFilters()
+#13 D:\Projects\Astaf\workspace\yii\framework\web\CWebApplication.php(276): SpeisTrankController->run()
+#14 D:\Projects\Astaf\workspace\yii\framework\web\CWebApplication.php(135): CWebApplication->runController()
+#15 D:\Projects\Astaf\workspace\yii\framework\base\CApplication.php(162): CWebApplication->processRequest()
+#16 D:\Projects\Astaf\workspace\admin.astaf.de\index.php(13): CWebApplication->run()
+REQUEST_URI=/admin.astaf.de/index.php?r=speisTrank/index
+in D:\Projects\Astaf\workspace\admin.astaf.de\protected\views\speisTrank\index.php (31)
+in D:\Projects\Astaf\workspace\admin.astaf.de\protected\controllers\SpeisTrankController.php (135)
+in D:\Projects\Astaf\workspace\admin.astaf.de\index.php (13)
+2012/04/28 17:25:06 [error] [php] Missing argument 3 for CActiveForm::dropDownList(), called in D:\Projects\Astaf\workspace\admin.astaf.de\protected\views\speisTrank\_search.php on line 15 and defined (D:\Projects\Astaf\workspace\yii\framework\web\widgets\CActiveForm.php:679)
+Stack trace:
+#0 D:\Projects\Astaf\workspace\yii\framework\web\CBaseController.php(96): SpeisTrankController->renderInternal()
+#1 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(870): SpeisTrankController->renderFile()
+#2 D:\Projects\Astaf\workspace\admin.astaf.de\protected\views\common\_advanced_search.php(19): SpeisTrankController->renderPartial()
+#3 D:\Projects\Astaf\workspace\yii\framework\web\CBaseController.php(127): require()
+#4 D:\Projects\Astaf\workspace\yii\framework\web\CBaseController.php(96): SpeisTrankController->renderInternal()
+#5 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(870): SpeisTrankController->renderFile()
+#6 D:\Projects\Astaf\workspace\admin.astaf.de\protected\views\speisTrank\index.php(16): SpeisTrankController->renderPartial()
+#7 D:\Projects\Astaf\workspace\yii\framework\web\CBaseController.php(127): require()
+#8 D:\Projects\Astaf\workspace\yii\framework\web\CBaseController.php(96): SpeisTrankController->renderInternal()
+#9 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(870): SpeisTrankController->renderFile()
+#10 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(783): SpeisTrankController->renderPartial()
+#11 D:\Projects\Astaf\workspace\admin.astaf.de\protected\controllers\SpeisTrankController.php(135): SpeisTrankController->render()
+#12 D:\Projects\Astaf\workspace\yii\framework\web\actions\CInlineAction.php(50): SpeisTrankController->actionIndex()
+#13 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(309): CInlineAction->runWithParams()
+#14 D:\Projects\Astaf\workspace\yii\framework\web\filters\CFilterChain.php(134): SpeisTrankController->runAction()
+#15 D:\Projects\Astaf\workspace\yii\framework\web\filters\CFilter.php(41): CFilterChain->run()
+#16 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(1146): CAccessControlFilter->filter()
+#17 D:\Projects\Astaf\workspace\yii\framework\web\filters\CInlineFilter.php(59): SpeisTrankController->filterAccessControl()
+#18 D:\Projects\Astaf\workspace\yii\framework\web\filters\CFilterChain.php(131): CInlineFilter->filter()
+#19 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(292): CFilterChain->run()
+#20 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(266): SpeisTrankController->runActionWithFilters()
+#21 D:\Projects\Astaf\workspace\yii\framework\web\CWebApplication.php(276): SpeisTrankController->run()
+#22 D:\Projects\Astaf\workspace\yii\framework\web\CWebApplication.php(135): CWebApplication->runController()
+#23 D:\Projects\Astaf\workspace\yii\framework\base\CApplication.php(162): CWebApplication->processRequest()
+#24 D:\Projects\Astaf\workspace\admin.astaf.de\index.php(13): CWebApplication->run()
+REQUEST_URI=/admin.astaf.de/index.php?r=speisTrank/index
+in D:\Projects\Astaf\workspace\admin.astaf.de\protected\views\speisTrank\_search.php (15)
+in D:\Projects\Astaf\workspace\admin.astaf.de\protected\views\common\_advanced_search.php (19)
+in D:\Projects\Astaf\workspace\admin.astaf.de\protected\views\speisTrank\index.php (16)
+2012/04/28 17:29:49 [error] [exception.CException] exception 'CException' with message 'Für CDataColumn muss entweder "name" oder "value" angegeben werden.' in D:\Projects\Astaf\workspace\yii\framework\zii\widgets\grid\CDataColumn.php:86
+Stack trace:
+#0 D:\Projects\Astaf\workspace\yii\framework\zii\widgets\grid\CGridView.php(326): CDataColumn->init()
+#1 D:\Projects\Astaf\workspace\yii\framework\zii\widgets\grid\CGridView.php(284): CGridView->initColumns()
+#2 D:\Projects\Astaf\workspace\yii\framework\web\CBaseController.php(148): CGridView->init()
+#3 D:\Projects\Astaf\workspace\yii\framework\web\CBaseController.php(173): CBaseController->createWidget('zii.widgets.gri...', Array)
+#4 D:\Projects\Astaf\workspace\admin.astaf.de\protected\views\veranstaltung\index.php(35): CBaseController->widget('zii.widgets.gri...', Array)
+#5 D:\Projects\Astaf\workspace\yii\framework\web\CBaseController.php(127): require('D:\Projects\Ast...')
+#6 D:\Projects\Astaf\workspace\yii\framework\web\CBaseController.php(96): CBaseController->renderInternal('D:\Projects\Ast...', Array, true)
+#7 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(870): CBaseController->renderFile('D:\Projects\Ast...', Array, true)
+#8 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(783): CController->renderPartial('index', Array, true)
+#9 D:\Projects\Astaf\workspace\admin.astaf.de\protected\controllers\VeranstaltungController.php(141): CController->render('index', Array)
+#10 D:\Projects\Astaf\workspace\yii\framework\web\actions\CInlineAction.php(50): VeranstaltungController->actionIndex()
+#11 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(309): CInlineAction->runWithParams(Array)
+#12 D:\Projects\Astaf\workspace\yii\framework\web\filters\CFilterChain.php(134): CController->runAction(Object(CInlineAction))
+#13 D:\Projects\Astaf\workspace\yii\framework\web\filters\CFilter.php(41): CFilterChain->run()
+#14 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(1146): CFilter->filter(Object(CFilterChain))
+#15 D:\Projects\Astaf\workspace\yii\framework\web\filters\CInlineFilter.php(59): CController->filterAccessControl(Object(CFilterChain))
+#16 D:\Projects\Astaf\workspace\yii\framework\web\filters\CFilterChain.php(131): CInlineFilter->filter(Object(CFilterChain))
+#17 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(292): CFilterChain->run()
+#18 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(266): CController->runActionWithFilters(Object(CInlineAction), Array)
+#19 D:\Projects\Astaf\workspace\yii\framework\web\CWebApplication.php(276): CController->run('index')
+#20 D:\Projects\Astaf\workspace\yii\framework\web\CWebApplication.php(135): CWebApplication->runController('veranstaltung/i...')
+#21 D:\Projects\Astaf\workspace\yii\framework\base\CApplication.php(162): CWebApplication->processRequest()
+#22 D:\Projects\Astaf\workspace\admin.astaf.de\index.php(13): CApplication->run()
+#23 {main}
+REQUEST_URI=/admin.astaf.de/index.php?r=veranstaltung/index
+HTTP_REFERER=http://dev.astaf.de:90/admin.astaf.de/index.php?r=verein/index
+---
+2012/04/28 17:33:25 [error] [exception.CException] exception 'CException' with message 'Eigenschaft "CDbCriteria.type ist nicht definiert.' in D:\Projects\Astaf\workspace\yii\framework\base\CComponent.php:174
+Stack trace:
+#0 D:\Projects\Astaf\workspace\yii\framework\db\schema\CDbCriteria.php(153): CComponent->__set('type', 'B??hne')
+#1 D:\Projects\Astaf\workspace\yii\framework\db\schema\CDbCommandBuilder.php(462): CDbCriteria->__construct(Array)
+#2 D:\Projects\Astaf\workspace\yii\framework\db\ar\CActiveRecord.php(1405): CDbCommandBuilder->createCriteria(Array, Array)
+#3 D:\Projects\Astaf\workspace\admin.astaf.de\protected\views\veranstaltung\index.php(32): CActiveRecord->findAll(Array)
+#4 D:\Projects\Astaf\workspace\yii\framework\web\CBaseController.php(127): require('D:\Projects\Ast...')
+#5 D:\Projects\Astaf\workspace\yii\framework\web\CBaseController.php(96): CBaseController->renderInternal('D:\Projects\Ast...', Array, true)
+#6 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(870): CBaseController->renderFile('D:\Projects\Ast...', Array, true)
+#7 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(783): CController->renderPartial('index', Array, true)
+#8 D:\Projects\Astaf\workspace\admin.astaf.de\protected\controllers\VeranstaltungController.php(141): CController->render('index', Array)
+#9 D:\Projects\Astaf\workspace\yii\framework\web\actions\CInlineAction.php(50): VeranstaltungController->actionIndex()
+#10 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(309): CInlineAction->runWithParams(Array)
+#11 D:\Projects\Astaf\workspace\yii\framework\web\filters\CFilterChain.php(134): CController->runAction(Object(CInlineAction))
+#12 D:\Projects\Astaf\workspace\yii\framework\web\filters\CFilter.php(41): CFilterChain->run()
+#13 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(1146): CFilter->filter(Object(CFilterChain))
+#14 D:\Projects\Astaf\workspace\yii\framework\web\filters\CInlineFilter.php(59): CController->filterAccessControl(Object(CFilterChain))
+#15 D:\Projects\Astaf\workspace\yii\framework\web\filters\CFilterChain.php(131): CInlineFilter->filter(Object(CFilterChain))
+#16 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(292): CFilterChain->run()
+#17 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(266): CController->runActionWithFilters(Object(CInlineAction), Array)
+#18 D:\Projects\Astaf\workspace\yii\framework\web\CWebApplication.php(276): CController->run('index')
+#19 D:\Projects\Astaf\workspace\yii\framework\web\CWebApplication.php(135): CWebApplication->runController('veranstaltung/i...')
+#20 D:\Projects\Astaf\workspace\yii\framework\base\CApplication.php(162): CWebApplication->processRequest()
+#21 D:\Projects\Astaf\workspace\admin.astaf.de\index.php(13): CApplication->run()
+#22 {main}
+REQUEST_URI=/admin.astaf.de/index.php?r=veranstaltung/index
+HTTP_REFERER=http://dev.astaf.de:90/admin.astaf.de/index.php?r=verein/index
+---
+2012/04/28 17:33:42 [error] [exception.CException] exception 'CException' with message 'Eigenschaft "CDbCriteria.criteria ist nicht definiert.' in D:\Projects\Astaf\workspace\yii\framework\base\CComponent.php:174
+Stack trace:
+#0 D:\Projects\Astaf\workspace\yii\framework\db\schema\CDbCriteria.php(153): CComponent->__set('criteria', 'type=B??hne')
+#1 D:\Projects\Astaf\workspace\yii\framework\db\schema\CDbCommandBuilder.php(462): CDbCriteria->__construct(Array)
+#2 D:\Projects\Astaf\workspace\yii\framework\db\ar\CActiveRecord.php(1405): CDbCommandBuilder->createCriteria(Array, Array)
+#3 D:\Projects\Astaf\workspace\admin.astaf.de\protected\views\veranstaltung\index.php(32): CActiveRecord->findAll(Array)
+#4 D:\Projects\Astaf\workspace\yii\framework\web\CBaseController.php(127): require('D:\Projects\Ast...')
+#5 D:\Projects\Astaf\workspace\yii\framework\web\CBaseController.php(96): CBaseController->renderInternal('D:\Projects\Ast...', Array, true)
+#6 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(870): CBaseController->renderFile('D:\Projects\Ast...', Array, true)
+#7 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(783): CController->renderPartial('index', Array, true)
+#8 D:\Projects\Astaf\workspace\admin.astaf.de\protected\controllers\VeranstaltungController.php(141): CController->render('index', Array)
+#9 D:\Projects\Astaf\workspace\yii\framework\web\actions\CInlineAction.php(50): VeranstaltungController->actionIndex()
+#10 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(309): CInlineAction->runWithParams(Array)
+#11 D:\Projects\Astaf\workspace\yii\framework\web\filters\CFilterChain.php(134): CController->runAction(Object(CInlineAction))
+#12 D:\Projects\Astaf\workspace\yii\framework\web\filters\CFilter.php(41): CFilterChain->run()
+#13 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(1146): CFilter->filter(Object(CFilterChain))
+#14 D:\Projects\Astaf\workspace\yii\framework\web\filters\CInlineFilter.php(59): CController->filterAccessControl(Object(CFilterChain))
+#15 D:\Projects\Astaf\workspace\yii\framework\web\filters\CFilterChain.php(131): CInlineFilter->filter(Object(CFilterChain))
+#16 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(292): CFilterChain->run()
+#17 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(266): CController->runActionWithFilters(Object(CInlineAction), Array)
+#18 D:\Projects\Astaf\workspace\yii\framework\web\CWebApplication.php(276): CController->run('index')
+#19 D:\Projects\Astaf\workspace\yii\framework\web\CWebApplication.php(135): CWebApplication->runController('veranstaltung/i...')
+#20 D:\Projects\Astaf\workspace\yii\framework\base\CApplication.php(162): CWebApplication->processRequest()
+#21 D:\Projects\Astaf\workspace\admin.astaf.de\index.php(13): CApplication->run()
+#22 {main}
+REQUEST_URI=/admin.astaf.de/index.php?r=veranstaltung/index
+HTTP_REFERER=http://dev.astaf.de:90/admin.astaf.de/index.php?r=verein/index
+---
+2012/04/28 17:33:59 [error] [system.db.CDbCommand] CDbCommand::fetchAll fehlgeschlagen: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Bühne' in 'where clause'. Der SQL-Ausdruck war: SELECT * FROM `standorte` `t` WHERE type=Bühne.
+in D:\Projects\Astaf\workspace\admin.astaf.de\protected\views\veranstaltung\index.php (32)
+in D:\Projects\Astaf\workspace\admin.astaf.de\protected\controllers\VeranstaltungController.php (141)
+in D:\Projects\Astaf\workspace\admin.astaf.de\index.php (13)
+2012/04/28 17:33:59 [error] [exception.CDbException] exception 'CDbException' with message 'CDbCommand konnte das SQL-Statement nicht ausführen: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Bühne' in 'where clause'. The SQL statement executed was: SELECT * FROM `standorte` `t` WHERE type=Bühne' in D:\Projects\Astaf\workspace\yii\framework\db\CDbCommand.php:528
+Stack trace:
+#0 D:\Projects\Astaf\workspace\yii\framework\db\CDbCommand.php(390): CDbCommand->queryInternal('fetchAll', Array, Array)
+#1 D:\Projects\Astaf\workspace\yii\framework\db\ar\CActiveRecord.php(1287): CDbCommand->queryAll()
+#2 D:\Projects\Astaf\workspace\yii\framework\db\ar\CActiveRecord.php(1406): CActiveRecord->query(Object(CDbCriteria), true)
+#3 D:\Projects\Astaf\workspace\admin.astaf.de\protected\views\veranstaltung\index.php(32): CActiveRecord->findAll(Array)
+#4 D:\Projects\Astaf\workspace\yii\framework\web\CBaseController.php(127): require('D:\Projects\Ast...')
+#5 D:\Projects\Astaf\workspace\yii\framework\web\CBaseController.php(96): CBaseController->renderInternal('D:\Projects\Ast...', Array, true)
+#6 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(870): CBaseController->renderFile('D:\Projects\Ast...', Array, true)
+#7 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(783): CController->renderPartial('index', Array, true)
+#8 D:\Projects\Astaf\workspace\admin.astaf.de\protected\controllers\VeranstaltungController.php(141): CController->render('index', Array)
+#9 D:\Projects\Astaf\workspace\yii\framework\web\actions\CInlineAction.php(50): VeranstaltungController->actionIndex()
+#10 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(309): CInlineAction->runWithParams(Array)
+#11 D:\Projects\Astaf\workspace\yii\framework\web\filters\CFilterChain.php(134): CController->runAction(Object(CInlineAction))
+#12 D:\Projects\Astaf\workspace\yii\framework\web\filters\CFilter.php(41): CFilterChain->run()
+#13 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(1146): CFilter->filter(Object(CFilterChain))
+#14 D:\Projects\Astaf\workspace\yii\framework\web\filters\CInlineFilter.php(59): CController->filterAccessControl(Object(CFilterChain))
+#15 D:\Projects\Astaf\workspace\yii\framework\web\filters\CFilterChain.php(131): CInlineFilter->filter(Object(CFilterChain))
+#16 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(292): CFilterChain->run()
+#17 D:\Projects\Astaf\workspace\yii\framework\web\CController.php(266): CController->runActionWithFilters(Object(CInlineAction), Array)
+#18 D:\Projects\Astaf\workspace\yii\framework\web\CWebApplication.php(276): CController->run('index')
+#19 D:\Projects\Astaf\workspace\yii\framework\web\CWebApplication.php(135): CWebApplication->runController('veranstaltung/i...')
+#20 D:\Projects\Astaf\workspace\yii\framework\base\CApplication.php(162): CWebApplication->processRequest()
+#21 D:\Projects\Astaf\workspace\admin.astaf.de\index.php(13): CApplication->run()
+#22 {main}
+REQUEST_URI=/admin.astaf.de/index.php?r=veranstaltung/index
+HTTP_REFERER=http://dev.astaf.de:90/admin.astaf.de/index.php?r=verein/index
+---
diff --git a/protected/views/kategorie/_search.php b/protected/views/kategorie/_search.php
index 8322f02..7352abd 100644
--- a/protected/views/kategorie/_search.php
+++ b/protected/views/kategorie/_search.php
@@ -32,7 +32,7 @@
 
 	<div class="row">
 		<?php echo $form->label($model,'published'); ?>
-		<?php echo $form->textField($model,'published'); ?>
+		<?php echo $form->checkbox($model,'published'); ?>
 	</div>
 
 	<div class="row buttons">
diff --git a/protected/views/kategorie/index.php b/protected/views/kategorie/index.php
index 2afd66f..705ca3d 100644
--- a/protected/views/kategorie/index.php
+++ b/protected/views/kategorie/index.php
@@ -21,7 +21,6 @@ $this->menu=array(
 	'dataProvider'=>$model->search(),
 	'filter'=>$model,
 	'columns'=>array(
-		'id',
 		'name',
 		'einheiten',
 		'default_menge:number',
diff --git a/protected/views/speisTrank/_search.php b/protected/views/speisTrank/_search.php
index 4300232..a88293a 100644
--- a/protected/views/speisTrank/_search.php
+++ b/protected/views/speisTrank/_search.php
@@ -12,7 +12,7 @@
 
 	<div class="row">
 		<?php echo $form->label($model,'kategorie_id'); ?>
-		<?php echo $form->textField($model,'kategorie_id'); ?>
+		<?php echo $form->dropDownList($model, 'kategorie_id', CHtml::listData(Kategorie::model()->findAll(), 'id', 'name'), array("empty"=>"")); ?>
 	</div>
 
 	<div class="row">
@@ -27,7 +27,7 @@
 
 	<div class="row">
 		<?php echo $form->label($model,'published'); ?>
-		<?php echo $form->textField($model,'published'); ?>
+		<?php echo $form->checkbox($model,'published'); ?>
 	</div>
 
 	<div class="row buttons">
diff --git a/protected/views/speisTrank/index.php b/protected/views/speisTrank/index.php
index 48015fc..1f416cc 100644
--- a/protected/views/speisTrank/index.php
+++ b/protected/views/speisTrank/index.php
@@ -20,7 +20,10 @@ $this->menu=array(
 	'dataProvider'=>$model->search(),
 	'filter'=>$model,
 	'columns'=>array(
-		array('header'=>'Kategorie', 'value'=>'($data->kategorie) ? $data->kategorie->name : "-"'),
+		array('header'=>'Kategorie',
+				'name'=>'kategorie_id',
+				'filter'=>CHtml::listData(Kategorie::model()->findAll(), 'id', 'name'),
+				'value'=>'($data->kategorie) ? $data->kategorie->name : "-"'),
 		'name',
 		'beschreibung:html',
 		array('header'=>'Öffentlich',
diff --git a/protected/views/standort/_search.php b/protected/views/standort/_search.php
index 4f39bd5..eeab539 100644
--- a/protected/views/standort/_search.php
+++ b/protected/views/standort/_search.php
@@ -27,7 +27,7 @@
 
 	<div class="row">
 		<?php echo $form->label($model,'published'); ?>
-		<?php echo $form->textField($model,'published'); ?>
+		<?php echo $form->checkbox($model,'published'); ?>
 	</div>
 
 	<div class="row buttons">
diff --git a/protected/views/standort/index.php b/protected/views/standort/index.php
index 5449010..9a88a74 100644
--- a/protected/views/standort/index.php
+++ b/protected/views/standort/index.php
@@ -61,7 +61,7 @@ $map->render();
 	'dataProvider'=>$model->search(),
 	'filter'=>$model,
 	'columns'=>array(
-		'id',
+		'type',
 		'name',
 		'pos_lat',
 		'pos_long',
diff --git a/protected/views/veranstaltung/_search.php b/protected/views/veranstaltung/_search.php
index b4ec2ed..099603c 100644
--- a/protected/views/veranstaltung/_search.php
+++ b/protected/views/veranstaltung/_search.php
@@ -12,7 +12,7 @@
 
 	<div class="row">
 		<?php echo $form->label($model,'verein_id'); ?>
-		<?php echo $form->textField($model,'verein_id'); ?>
+		<?php echo $form->dropDownList($model, 'verein_id', CHtml::listData(Verein::model()->findAll(), 'id', 'name'), array("empty"=>"")); ?>
 	</div>
 
 	<div class="row">
@@ -37,12 +37,12 @@
 
 	<div class="row">
 		<?php echo $form->label($model,'standort_id'); ?>
-		<?php echo $form->textField($model,'standort_id'); ?>
+		<?php echo $form->dropDownList($model, 'standort_id', CHtml::listData(Standort::model()->findAll(array('condition'=>'type="Bühne"')), 'id', 'name'), array("empty"=>"")); ?>
 	</div>
 
 	<div class="row">
 		<?php echo $form->label($model,'published'); ?>
-		<?php echo $form->textField($model,'published'); ?>
+		<?php echo $form->checkbox($model,'published'); ?>
 	</div>
 
 	<div class="row buttons">
diff --git a/protected/views/veranstaltung/index.php b/protected/views/veranstaltung/index.php
index 42d1d62..35f2ec7 100644
--- a/protected/views/veranstaltung/index.php
+++ b/protected/views/veranstaltung/index.php
@@ -20,12 +20,17 @@ $this->menu=array(
 	'dataProvider'=>$model->search(),
 	'filter'=>$model,
 	'columns'=>array(
-		'id',
-		array('header'=>'Verein', 'value'=>'$data->verein->name'),
+		array('header'=>'Verein', 
+				'name'=>'verein_id',
+				'filter'=>CHtml::listData(Verein::model()->findAll(), 'id', 'name'),
+				'value'=>'$data->verein->name'),
 		'titel',
-		array('header'=>'Startzeit', 'value'=>Format::displayDateTime($model->startzeit)),
-		array('header'=>'Endzeit', 'value'=>Format::displayDateTime($model->endzeit)),
-		array('header'=>'Standort', 'value'=>'($data->standort) ? $data->standort->name : "Kein Standort"'),
+		array('header'=>'Startzeit', 'value'=>'Format::displayDateTime($data->startzeit)'),
+		array('header'=>'Endzeit', 'value'=>'Format::displayDateTime($data->endzeit)'),
+		array('header'=>'Standort',
+				'name'=>'standort_id',
+				'filter'=>CHtml::listData(Standort::model()->findAll(array('condition'=>'type="Bühne"')), 'id', 'name'),
+				'value'=>'($data->standort) ? $data->standort->name : "Kein Standort"'),
 		array('header'=>'Öffentlich',
 				'value'=>'CHtml::image($data->published ? "images/ok.png" : "images/nok.png", $data->published ? "ok.png" : "nok.png")', 'type'=>'raw'),
 		array(