Example #1
0
 public function setMinutes()
 {
     $select = new Extension_View_Html_Form_Elements_Select();
     $select->setModel(Extension_Helpers_Models_Elements_Select::minutes());
     $select->setOptionLabelKey('label');
     $select->setOptionValueKey('value');
     $this->minutes = $select;
 }
Example #2
0
 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;
 }
Example #3
0
 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' => '<'));
 }
Example #4
0
 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;
 }
Example #5
0
 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);
 }
Example #6
0
 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);
 }
Example #7
0
 private function setUserBankTable()
 {
     $user = new Core_Auth_User();
     $role = $user->getRole();
     $userId = $this->getUserId();
     if ($role == 'admin' || $role == 'superadmin') {
         $bank = new Extension_View_Yui35_DataTableEdit();
         $bank->isAddButtonEnabled(false);
         $bank->isEditEnabled(false);
     } else {
         $bank = new Extension_View_Yui35_DataTablePF();
         if ($userId === null) {
             return;
         }
     }
     $table = $bank->getTable();
     $model = new Model_TransactionModel();
     $model->setUserId($userId);
     if ($userId == null) {
         $model->addQuery('select', array('table' => $model->getTableName()));
     } else {
         $model->getTransactionsByUser();
     }
     $model->addQuery('order', array('order' => implode($model->getPrimaryKeys(), ",") . ' DESC'));
     $model->addQuery('limit', array('limit' => 20));
     $bank->setModel($model);
     $table->addColumn(array('key' => 'transaction_id', 'label' => 'ID'));
     $table->addColumn(array('key' => 'money', 'label' => 'Money'));
     $table->addColumn(array('key' => 'date_created', 'label' => 'Date'));
     $typeModel = new Model_TransactionTypeModel();
     $typeModel->addQuery('select', array('table' => $typeModel->getTableName()));
     $typeCollection = new Core_Model_Adapter_ModelCollection();
     $typeCollectionData = $typeCollection->getModelCollection($typeModel);
     $table->addColumn('{key:"transaction_type_id_FK",label:"Type Of Transaction",allowHTML:true,formatter:' . $table->getFormatter("labelFromModelCollection", array('values' => $typeCollectionData, 'value' => 'transaction_type_id', 'label' => 'transaction_name', 'attributes' => array('name' => 'model[' . $model->getModelClassName() . '][transaction_type_id_FK]'))) . '}', false, 'transaction_type_id_FK');
     $url = Application::getRouter()->getFullUrl(array('controller' => 'servicehtml', 'action' => 'view'));
     $table->addColumn(array('key' => 'transaction_id', 'label' => 'ID'));
     $table->addColumn(array('key' => 'money', 'label' => 'Money'));
     $table->addColumn(array('key' => 'date_created', 'label' => 'Date'));
     $table->addColumn('{key:"transaction_type_id_FK",label: "Details",allowHTML:true,formatter:function (o){ if(o.value==2||o.value==3){return "<a class=\'systemSubServiceLinkBank\' servicehtml=\'' . $url . '&view=View_Frontend_UserBetSlip&bet_slip_id="+o.data.transaction_type_idendifier+"\' href=\'javascript:void(0)\' >View</a>";}else{return "-"}}}', false, 'bet_slip_id_view');
     $status = new Extension_View_Html_Form_Elements_Select();
     $status->setModel($typeCollection->toArray());
     $status->setOptionLabelKey('transaction_name');
     $status->setOptionValueKey('transaction_type_id');
     $status->setAttributes(array('name' => 'transaction_type_id_FK', 'type' => 'text'));
     $status->setPrependHtml('Status: ');
     $bank->addFilter($status);
     $filterCalendar = new Extension_View_Html_Form_Elements_Calendar();
     $filterCalendar->setPrependHtml('<br />Date from:');
     $filterCalendar->setAttribute('name', 'date_created');
     $bank->addFilter($filterCalendar, array('group' => 'added', 'operator' => 'and', 'comparison' => '>'));
     $filterCalendar = new Extension_View_Html_Form_Elements_Calendar();
     $filterCalendar->setPrependHtml('Date to:');
     $filterCalendar->setAttribute('name', 'date_created');
     $bank->addFilter($filterCalendar, array('group' => 'added', 'operator' => 'and', 'comparison' => '<'));
     $filterMoney = new Extension_View_Html_Form_Elements_Input();
     $filterMoney->setPrependHtml('<br />Money from:');
     $filterMoney->setAttribute('name', 'money');
     $bank->addFilter($filterMoney, array('group' => 'money', 'operator' => 'and', 'comparison' => '>'));
     $filterMoney = new Extension_View_Html_Form_Elements_Input();
     $filterMoney->setPrependHtml('Money to:');
     $filterMoney->setAppendHtml('</br>');
     $filterMoney->setAttribute('name', 'money');
     $bank->addFilter($filterMoney, array('group' => 'money', 'operator' => 'and', 'comparison' => '<'));
     if ($role == 'admin' || $role == 'superadmin') {
         $userIdFiterId = new Extension_View_Html_Form_Elements_Input();
         $userIdFiterId->setAttributes(array('type' => 'hidden', 'name' => 'user_id_FK', 'value' => $userId, 'class' => 'filterInput'));
         $bank->addFilter($userIdFiterId);
     } else {
         $method = new Extension_View_Html_Form_Elements_Input();
         $method->setAttributes(array('type' => 'hidden', 'name' => 'method', 'value' => 'getTransactionsByUser', 'class' => 'filterInput'));
         $bank->addAdditionalFilterElement($method);
     }
     $this->userBankTable = $bank;
 }
Example #8
0
 private function setUserBetsTable()
 {
     $user = new Core_Auth_User();
     $role = $user->getRole();
     $userId = $this->getUserId();
     if ($role == 'admin' || $role == 'superadmin') {
         $bets = new Extension_View_Yui35_DataTableEdit();
         $bets->isAddButtonEnabled(false);
         $bets->isEditEnabled(false);
     } else {
         $bets = new Extension_View_Yui35_DataTablePF();
         if ($userId === null) {
             return;
         }
     }
     $table = $bets->getTable();
     $model = new Model_BetSlipModel();
     $model->getBetSlipsTransaction();
     if ($userId !== null) {
         $model->addQuery('where', array('where_condition' => 'bs.user_id_FK=' . (int) $userId));
     }
     $model->addQuery('order', array('order' => implode($model->getPrimaryKeys(), ",") . ' DESC'));
     $model->addQuery('limit', array('limit' => 20));
     $bets->setModel($model);
     $url = Application::getRouter()->getFullUrl(array('controller' => 'servicehtml', 'action' => 'view'));
     $table->addColumn(array('key' => 'bet_slip_id', 'label' => 'ID'));
     $table->addColumn(array('key' => 'date_created', 'label' => 'Played'));
     $table->addColumn('{key:status,label: "Status",allowHTML:true,formatter:function(o){if(o.data.status==2){return "Finished"} else {return "In Play"}}}', false, 'transaction_type_id_FK');
     $table->addColumn('{key:"bet_slip_id",label: "Details",allowHTML:true,formatter:"<a class=\'systemSubServiceLinkBets\' servicehtml=\'' . $url . '&view=View_Frontend_UserBetSlip&bet_slip_id={value}\' href=\'javascript:void(0)\' >View</a>"}', false, 'bet_slip_id_view');
     $table->addColumn(array('key' => 'money', 'label' => 'Money'));
     $status = new Extension_View_Html_Form_Elements_Select();
     $status->setModel(array(array('label' => 'Finished', 'value' => '2'), array('label' => 'In play', 'value' => '0')));
     $status->setOptionLabelKey('label');
     $status->setOptionValueKey('value');
     $status->setAttributes(array('name' => 'status', 'type' => 'text'));
     $status->setPrependHtml('Status: ');
     $bets->addFilter($status);
     $filterCalendar = new Extension_View_Html_Form_Elements_Calendar();
     $filterCalendar->setPrependHtml('<br />Date from:');
     $filterCalendar->setAttribute('name', 'date_created');
     $bets->addFilter($filterCalendar, array('group' => 'added', 'operator' => 'and', 'comparison' => '>'));
     $filterCalendar = new Extension_View_Html_Form_Elements_Calendar();
     $filterCalendar->setPrependHtml('Date to:');
     $filterCalendar->setAttribute('name', 'date_created');
     $bets->addFilter($filterCalendar, array('group' => 'added', 'operator' => 'and', 'comparison' => '<'));
     $filterMoney = new Extension_View_Html_Form_Elements_Input();
     $filterMoney->setPrependHtml('<br />Money from:');
     $filterMoney->setAttribute('name', 'money');
     $bets->addFilter($filterMoney, array('group' => 'money', 'operator' => 'and', 'comparison' => '>'));
     $filterMoney = new Extension_View_Html_Form_Elements_Input();
     $filterMoney->setPrependHtml('Money to:');
     $filterMoney->setAppendHtml('</br>');
     $filterMoney->setAttribute('name', 'money');
     $bets->addFilter($filterMoney, array('group' => 'money', 'operator' => 'and', 'comparison' => '<'));
     if ($role == 'admin' || $role == 'superadmin') {
         $userIdFiterId = new Extension_View_Html_Form_Elements_Input();
         $userIdFiterId->setAttributes(array('type' => 'hidden', 'name' => 'bs.user_id_FK', 'value' => $userId, 'class' => 'filterInput'));
         $bets->addFilter($userIdFiterId);
         $method = new Extension_View_Html_Form_Elements_Input();
         $method->setAttributes(array('type' => 'hidden', 'name' => 'method', 'value' => 'getBetSlipsTransaction', 'class' => 'filterInput'));
         $bets->addAdditionalFilterElement($method);
     } else {
         $method = new Extension_View_Html_Form_Elements_Input();
         $method->setAttributes(array('type' => 'hidden', 'name' => 'method', 'value' => 'getBetSlipsTransactionByUser', 'class' => 'filterInput'));
         $bets->addAdditionalFilterElement($method);
     }
     $this->userBetsTable = $bets;
 }
Example #9
0
 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);
 }