public function setSelectList()
{
$sportId = $this->getSportId();
$eventTypesModel = new Model_EventTypesModel();
$eventTypesModel->addQuery('select', array('table' => $eventTypesModel->getTableName()));
if (is_numeric($sportId)) {
$eventTypesModel->addQuery('where', array('where_condition' => 'sports_id_FK=' . $sportId));
}
$eventTypesCollection = new Core_Model_Adapter_ModelCollection();
$eventTypesCollection->getModelCollection($eventTypesModel);
$this->selectList = $eventTypesCollection->toArray();
}
public function setSelectElement()
{
$sportId = $this->getSportId();
$groupsModel = new Model_EventTypesModel();
$groupsModel->addQuery('select', array('table' => $groupsModel->getTableName()));
if (is_numeric($sportId)) {
$groupsModel->addQuery('where', array('where_condition' => 'sports_id_FK=' . $sportId));
}
$groupsCollection = new Core_Model_Adapter_ModelCollection();
$groupsCollectionData = $groupsCollection->getModelCollection($groupsModel);
$select = new Extension_View_Html_Form_Elements_Select();
$select->setModel($groupsCollection->toArray());
$select->setAttribute('name', 'event_types_id');
$select->setAttribute('id', $select->getId());
$select->setOptionLabelKey('event_types_name');
$select->setOptionValueKey('event_types_id');
$this->select = $select;
}
private function setEventTypesTablePanel()
{
$table = $this->eventTypesTableWithPanel->getTable();
$model = new Model_EventTypesModel();
$model->addQuery('select', array('table' => $model->getTableName()));
$model->addQuery('order', array('order' => implode($model->getPrimaryKeys(), ",") . ' DESC'));
$model->addQuery('limit', array('limit' => 20));
$this->eventTypesTableWithPanel->setModel($model);
$table->addColumn(array('key' => 'event_types_id', 'label' => 'ID'));
$table->addColumn(array('key' => 'event_types_name', 'label' => 'Name'));
$table->addColumn('{key:"event_types_id",label:"Event Types Values",allowHTML:true,formatter:' . $table->getFormatter("inputFieldCell", array('attributes' => array('type' => 'button', 'class' => 'event_type_values', 'value' => 'Edit values'))) . '}', false, 'active');
$sportsModel = new Model_SportsModel();
$sportsModel->addQuery('select', array('table' => $sportsModel->getTableName()));
$sportsCollection = new Core_Model_Adapter_ModelCollection();
$sportsCollectionData = $sportsCollection->getModelCollection($sportsModel);
$table->addColumn('{key:"sports_id_FK",label:"Sport",allowHTML:true,formatter:' . $table->getFormatter("selectFromModel", array('values' => $sportsCollectionData, 'value' => 'sports_id', 'label' => 'name_of_sport', 'attributes' => array('name' => 'model[' . $this->eventTypesTableWithPanel->getModelName() . '][sports_id_FK]'))) . '}', false, 'sports');
$select = new Extension_View_Html_Form_Elements_Select();
$select->setModel($sportsCollection->toArray());
$select->setAttribute('name', 'sports_id_FK');
$select->setOptionLabelKey('name_of_sport');
$select->setOptionValueKey('sports_id');
$this->eventTypesTableWithPanel->addFilter($select);
}
