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 setSelectElement() { $sportId = $this->getSportId(); $groupsModel = new Model_GroupsModel(); $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', 'groups_id'); $select->setAttribute('id', $select->getId()); $select->setOptionLabelKey('name_of_group'); $select->setOptionValueKey('groups_id'); $this->select = $select; }
public function setBetsTablePanel() { $table = $this->betsTableWithPanel->getTable(); $this->betsTableWithPanel->isAddButtonEnabled(false); $model = new Model_BetsModel(); $model->addQuery('select', array('table' => $model->getTableName())); $model->addQuery('order', array('order' => implode($model->getPrimaryKeys(), ",") . ' DESC')); $model->addQuery('limit', array('limit' => 20)); $this->betsTableWithPanel->setModel($model); $table->addColumn(array('key' => 'bets_id', 'label' => 'ID')); $table->addColumn(array('key' => 'bet_name', 'label' => 'Name')); $groupsModel = new Model_GroupsModel(); $groupsModel->addQuery('select', array('table' => $groupsModel->getTableName())); $groupsCollection = new Core_Model_Adapter_ModelCollection(); $groupsCollectionData = $groupsCollection->getModelCollection($groupsModel); $table->addColumn('{key:"groups_id_FK",label:"Group",allowHTML:true,formatter:' . $table->getFormatter("selectFromModel", array('values' => $groupsCollectionData, 'value' => 'groups_id', 'label' => 'name_of_group', 'attributes' => array('name' => 'model[' . $this->betsTableWithPanel->getModelName() . '][groups_id_FK]'))) . '}', false, 'groups'); $table->addColumn(array('key' => 'bet_active', 'label' => 'Active')); $table->addColumn(array('key' => 'end_date', 'label' => 'Ends')); $select = new Extension_View_Html_Form_Elements_Select(); $select->setModel($groupsCollection->toArray()); $select->setAttribute('name', 'groups_id_FK'); $select->setOptionLabelKey('name_of_group'); $select->setOptionValueKey('groups_id'); $select->setPrependHtml('Group:'); $this->betsTableWithPanel->addFilter($select); $this->betsTableWithPanel->addFilterGroupOperators('active', 'and'); $this->betsTableWithPanel->addFilterGroupOperators('end', 'and'); $filterCalendar = new Extension_View_Html_Form_Elements_Calendar(); $filterCalendar->setPrependHtml('Active from:'); $filterCalendar->setAttribute('name', 'bet_active'); $this->betsTableWithPanel->addFilter($filterCalendar, array('group' => 'active', 'operator' => 'and', 'comparison' => '>')); $filterCalendar = new Extension_View_Html_Form_Elements_Calendar(); $filterCalendar->setPrependHtml('Active to:'); $filterCalendar->setAttribute('name', 'bet_active'); $this->betsTableWithPanel->addFilter($filterCalendar, array('group' => 'active', 'operator' => 'and', 'comparison' => '<')); $filterCalendar = new Extension_View_Html_Form_Elements_Calendar(); $filterCalendar->setPrependHtml('End from:'); $filterCalendar->setAttribute('name', 'end_date'); $this->betsTableWithPanel->addFilter($filterCalendar, array('group' => 'end', 'operator' => 'and', 'comparison' => '>')); $filterCalendar = new Extension_View_Html_Form_Elements_Calendar(); $filterCalendar->setPrependHtml('End to:'); $filterCalendar->setAttribute('name', 'end_date'); $this->betsTableWithPanel->addFilter($filterCalendar, array('group' => 'end', 'operator' => 'and', 'comparison' => '<')); }
private function setTeamsTablePanel() { $table = $this->teamsTableWithPanel->getTable(); $model = new Model_TeamsModel(); $model->addQuery('select', array('table' => $model->getTableName())); $model->addQuery('order', array('order' => implode($model->getPrimaryKeys(), ",") . ' DESC')); $model->addQuery('limit', array('limit' => 20)); $this->teamsTableWithPanel->setModel($model); $table->addColumn(array('key' => 'teams_id', 'label' => 'ID')); $table->addColumn(array('key' => 'team_name', 'label' => 'Name')); $groupsModel = new Model_GroupsModel(); $groupsModel->addQuery('select', array('table' => $groupsModel->getTableName())); $groupsCollection = new Core_Model_Adapter_ModelCollection(); $groupsCollectionData = $groupsCollection->getModelCollection($groupsModel); $table->addColumn('{key:"groups_id_FK",label:"Group",allowHTML:true,formatter:' . $table->getFormatter("selectFromModel", array('values' => $groupsCollectionData, 'value' => 'groups_id', 'label' => 'name_of_group', 'attributes' => array('name' => 'model[' . $this->teamsTableWithPanel->getModelName() . '][groups_id_FK]'))) . '}', false, 'groups'); $select = new Extension_View_Html_Form_Elements_Select(); $select->setModel($groupsCollection->toArray()); $select->setAttribute('name', 'groups_id_FK'); $select->setOptionLabelKey('name_of_group'); $select->setOptionValueKey('groups_id'); $this->teamsTableWithPanel->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 setUsersTablePanel() { $table = $this->usersTableWithPanel->getTable(); $model = new Model_UserModel(); $model->addQuery('select', array('table' => $model->getTableName())); $model->addQuery('order', array('order' => implode($model->getPrimaryKeys(), ",") . ' DESC')); $model->addQuery('limit', array('limit' => 20)); $this->usersTableWithPanel->addRemoveKeyFromData('password'); $this->usersTableWithPanel->addRemoveKeyFromData('salt'); $this->usersTableWithPanel->addRemoveKeyFromData('mail_validation'); $this->usersTableWithPanel->setModel($model); $table->addColumn(array('key' => 'user_id', 'label' => 'ID')); $table->addColumn(array('key' => 'first_name', 'label' => 'First Name')); $table->addColumn(array('key' => 'last_name', 'label' => 'Last Name')); $table->addColumn(array('key' => 'user_name', 'label' => 'User Name')); $table->addColumn(array('key' => 'password_before_salt', 'label' => 'Password')); $table->addColumn(array('key' => 'last_login', 'label' => 'Last login')); $table->addColumn(array('key' => 'email', 'label' => 'Email')); $table->addColumn(array('key' => 'banned', 'label' => 'Banned')); $table->addColumn('{key:"email_validated",label:"E-Validated",allowHTML:true,formatter:' . $table->getFormatter("selectYesNo", array('attributes' => array('name' => 'model[' . $this->usersTableWithPanel->getModelName() . '][email_validated]'))) . '}', false, 'email_validated'); $table->addColumn('{key:"banned",label:"Banned",allowHTML:true,formatter:' . $table->getFormatter("selectYesNo", array('attributes' => array('name' => 'model[' . $this->usersTableWithPanel->getModelName() . '][banned]'))) . '}', false, 'banned'); $edit = Application::getBaseRelativeUrl() . '/images/edit.png'; $this->usersTableWithPanel->addRemoveKeyFromData('password'); $this->usersTableWithPanel->setUpdateRule('exclude', 'last_login'); $this->usersTableWithPanel->setUpdateRule('exclude', 'yui_datatablepanel_bets_bank'); $this->usersTableWithPanel->setInsertRule('exclude', 'yui_datatablepanel_bets_bank'); $userStatusModel = new Model_UserStatusModel(); $userStatusModel->addQuery('select', array('table' => $userStatusModel->getTableName())); $userStatusCollection = new Core_Model_Adapter_ModelCollection(); $userStatusCollectionData = $userStatusCollection->getModelCollection($userStatusModel); $urlServiceBankBetFormatter = Application::getRouter()->getFullUrl(array('controller' => 'servicehtml', 'action' => 'view')) . '&view=View_Admin_UserBankBets&user_id={value}'; $table->addColumn('{key:"user_status_id_FK",label:"Group",allowHTML:true,formatter:' . $table->getFormatter("selectFromModel", array('values' => $userStatusCollectionData, 'value' => 'user_status_id', 'label' => 'status_name', 'attributes' => array('name' => 'model[' . $this->usersTableWithPanel->getModelName() . '][user_status_id_FK]'))) . '}', false, 'user_status'); $table->addColumn('{key:"user_id",label:"Bets/Bank",allowHTML:true,formatter:\'<a class="yui_datatablepanel_bets_bank systemServiceLink" servicehtml="' . $urlServiceBankBetFormatter . '" href="javascript:void(0);" >Bets/Bank</a>\'}', false, 'bets_bank'); $select = new Extension_View_Html_Form_Elements_Select(); $select->setModel($userStatusCollection->toArray()); $select->setAttribute('name', 'user_status_id_FK'); $select->setOptionLabelKey('status_name'); $select->setOptionValueKey('user_status_id'); $select->setPrependHtml('User Status:'); $this->usersTableWithPanel->addFilter($select); $selectBanned = new Extension_View_Html_Form_Elements_Select(); $selectBanned->setModel(Extension_Helpers_Models_Elements_Select::yesNo()); $selectBanned->setAttribute('name', 'banned'); $selectBanned->setOptionLabelKey('label'); $selectBanned->setOptionValueKey('value'); $selectBanned->setPrependHtml('User Banned:'); $this->usersTableWithPanel->addFilter($selectBanned); $selectMailValidation = new Extension_View_Html_Form_Elements_Select(); $selectMailValidation->setModel(Extension_Helpers_Models_Elements_Select::yesNo()); $selectMailValidation->setAttribute('mail_validated', 'banned'); $selectMailValidation->setOptionLabelKey('label'); $selectMailValidation->setOptionValueKey('value'); $selectMailValidation->setPrependHtml('Mail Validated:'); $this->usersTableWithPanel->addFilter($selectMailValidation); $username = new Extension_View_Html_Form_Elements_Input(); $username->setAttributes(array('name' => 'user_name', 'type' => 'text')); $username->setPrependHtml('Username:'******'name' => 'first_name', 'type' => 'text')); $firstname->setPrependHtml('First Name:'); $lastname = new Extension_View_Html_Form_Elements_Input(); $lastname->setAttributes(array('name' => 'last_name', 'type' => 'text')); $lastname->setPrependHtml('Last Name:'); $this->usersTableWithPanel->addFilter($username); $this->usersTableWithPanel->addFilter($firstname); $this->usersTableWithPanel->addFilter($lastname); }