public function setSportSelectHtml()
{
$sportsModel = new Model_SportsModel();
$sportsModel->addQuery('select', array('table' => $sportsModel->getTableName()));
$sportsCollection = new Core_Model_Adapter_ModelCollection();
$sportsCollectionData = $sportsCollection->getModelCollection($sportsModel);
$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');
//bets_id bet_name groups_id_FK add_date end_date bet_active
$select->setAttribute('id', 'sport_select');
return $this->sportSelectHtml = $select;
}
public function setMenu()
{
$url = Application::getRouter()->getFullUrl(array('controller' => 'servicehtml', 'action' => 'view'));
$menu = new Extension_View_Yui35_Menu();
$menu->setDirection('horizontal');
$sportsModel = new Model_SportsModel();
$sportsModel->addQuery('select', array('table' => $sportsModel->getTableName()));
$sportsCollection = new Core_Model_Adapter_ModelCollection();
$sportsCollection->getModelCollection($sportsModel);
foreach ($sportsCollection->toArray() as $s) {
$menu->addLink('sport_' . $s['sports_id'], array('content' => $s['name_of_sport']));
$menu->addChild('menu', 'sport_' . $s['sports_id']);
}
$groupsModel = new Model_GroupsModel();
$groupsModel->addQuery('select', array('table' => $groupsModel->getTableName()));
$groupsCollection = new Core_Model_Adapter_ModelCollection();
$groupsCollection->getModelCollection($groupsModel);
foreach ($groupsCollection->toArray() as $g) {
$menu->addLink('group_' . $g['groups_id'], array('content' => $g['name_of_group'], 'attributes' => array('class' => 'systemServiceLink', 'servicehtml' => $url . '&view=View_Frontend_Offer&groups_id=' . $g['groups_id'])));
$menu->addChild('sport_' . $g['sports_id_FK'], 'group_' . $g['groups_id']);
}
$this->menu = $menu;
}
private function setGroupsTablePanel()
{
$this->groupsTableWithPanel = new Extension_View_Yui35_DataTableEdit();
$groups = $this->groupsTableWithPanel->getTable();
$groupsModel = new Model_GroupsModel();
$groupsModel->addQuery('select', array('table' => $groupsModel->getTableName()));
$groupsModel->addQuery('order', array('order' => implode($groupsModel->getPrimaryKeys(), ",") . ' DESC'));
$groupsModel->addQuery('limit', array('limit' => 20));
$this->groupsTableWithPanel->setModel($groupsModel);
$groups->addColumn(array('key' => 'groups_id', 'label' => 'ID'));
$groups->addColumn(array('key' => 'name_of_group', 'label' => 'Group'));
$sportsModel = new Model_SportsModel();
$sportsModel->addQuery('select', array('table' => $sportsModel->getTableName()));
$sportsCollection = new Core_Model_Adapter_ModelCollection();
$sportsCollectionData = $sportsCollection->getModelCollection($sportsModel);
$groups->addColumn('{key:"sports_id_FK",label:"Sport",allowHTML:true,formatter:' . $groups->getFormatter("selectFromModel", array('values' => $sportsCollectionData, 'value' => 'sports_id', 'label' => 'name_of_sport', 'attributes' => array('name' => 'model[' . $this->groupsTableWithPanel->getModelName() . '][sports_id_FK]'))) . '}', false, 'active');
$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->groupsTableWithPanel->addFilter($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);
}
private function setSportsTablePanel()
{
$this->sportsTableWithPanel = new Extension_View_Yui35_DataTableEdit();
$sports = $this->sportsTableWithPanel->getTable();
$sportsModel = new Model_SportsModel();
$sportsModel->addQuery('select', array('table' => $sportsModel->getTableName()));
$sportsModel->addQuery('order', array('order' => implode($sportsModel->getPrimaryKeys(), ",") . ' DESC'));
$sportsModel->addQuery('limit', array('limit' => 20));
$this->sportsTableWithPanel->setModel($sportsModel);
$this->sportsTableWithPanel->setRowsPerPage(20);
$sports->addColumn(array('key' => 'sports_id', 'label' => 'ID'));
$sports->addColumn(array('key' => 'name_of_sport', 'label' => 'Sport'));
$bookhouseModel = new Model_BookhouseModel();
$bookhouseModel->addQuery('select', array('table' => $bookhouseModel->getTableName()));
$bookhouseCollection = new Core_Model_Adapter_ModelCollection();
$bookhouseCollectionData = $bookhouseCollection->getModelCollection($bookhouseModel);
$sports->addColumn('{key:"bookhouse_id_FK",label:"Bookhouse",allowHTML:true,formatter:' . $sports->getFormatter("selectFromModel", array('values' => $bookhouseCollectionData, 'value' => 'bookhouse_id', 'label' => 'house_name', 'attributes' => array('name' => 'model[' . $this->sportsTableWithPanel->getModelName() . '][bookhouse_id_FK]'))) . '}', false, 'active');
}
