private function setEventTypesValuesTablePanel() { $model = new Model_EventTypesValueModel(); $table = $this->eventTypesValuesTableWithPanel->getTable(); $this->eventTypesValuesTableWithPanel->setModel($model); $this->eventTypesValuesTableWithPanel->setUpdateRule('event_types_id_FK', 'hidden'); $this->eventTypesValuesTableWithPanel->isFilterButtonEnabled(false); $table->addColumn(array('key' => 'event_types_value_id', 'label' => 'ID')); $table->addColumn(array('key' => 'event_value_name', 'label' => 'Name')); $table->addColumn(array('key' => 'event_types_id_FK', 'label' => 'Event Type ID')); $select = new Extension_View_Html_Form_Elements_Input(); $select->setAttribute('name', 'event_types_id_FK'); $select->setAttribute('type', 'hidden'); $this->eventTypesValuesTableWithPanel->addFilter($select); }
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; }
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; }
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); }