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();
}
private function setTeamsTable()
{
$model = new Model_TeamsModel();
$model->addQuery('select', array('table' => $model->getTableName()));
$groupId = $this->getGroupId();
if (is_numeric($groupId)) {
$model->addQuery('where', array('where_condition' => 'groups_id_FK=' . $groupId));
}
$model->addQuery('order', array('order' => implode($model->getPrimaryKeys(), ",") . ' DESC'));
$teamsCollection = new Core_Model_Adapter_ModelCollection();
$teamsCollection->getModelCollection($model);
$this->teamsTable->setData($teamsCollection->toArray());
$this->teamsTable->addColumn(array('key' => 'teams_id', 'label' => 'ID'));
$this->teamsTable->addColumn(array('key' => 'team_name', 'label' => 'Name'));
}
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;
}
private function setBetOddsTable()
{
$model = new Model_EventTypesValueModel();
$model->addQuery('select', array('table' => $model->getTableName()));
$eventTypesId = $this->getEventTypesId();
if (is_numeric($eventTypesId)) {
$model->addQuery('where', array('where_condition' => 'event_types_id_FK=' . $eventTypesId));
}
$model->addQuery('order', array('order' => implode($model->getPrimaryKeys(), ",") . ' DESC'));
$valuesCollection = new Core_Model_Adapter_ModelCollection();
$valuesCollection->getModelCollection($model);
$this->betOddsTable->setData($valuesCollection->toArray());
$this->betOddsTable->addColumn(array('key' => 'event_types_value_id', 'label' => 'ID'));
$this->betOddsTable->addColumn(array('key' => 'event_value_name', 'label' => 'Name'));
$this->betOddsTable->addColumn('{key:"event_types_value_id",label:"Odds",allowHTML:true,formatter:"<input class=\'oddsInput\' valueid=\'{value}\' value=\'1\' type=\'text\' />"}', false, 'active');
}
private function setOfferTable()
{
$this->offerTable = new Extension_View_Yui35_DataTable();
$eventTypesValues = new Model_EventTypesValueModel();
$eventTypesValues->addQuery('select', array('table' => $eventTypesValues->getTableName()));
$eventTypesId = $this->getEventTypesId();
if (is_numeric($eventTypesId)) {
$eventTypesValues->addQuery('where', array('where_condition' => 'event_types_id_FK=' . (int) $eventTypesId));
} else {
return;
}
$eventTypesValues->addQuery('order', array('order' => implode($eventTypesValues->getPrimaryKeys(), ",") . ' DESC'));
$eventTypesValuesCoellction = new Core_Model_Adapter_ModelCollection();
$eventTypesValuesCoellction->getModelCollection($eventTypesValues);
$this->offerTable->addColumn(array('key' => 'event_bets_id', 'label' => 'ID'));
$this->offerTable->addColumn(array('key' => 'event_bets_name', 'label' => 'Name'));
$this->offerTable->addColumn(array('key' => 'end_date', 'label' => 'Ends'));
foreach ($eventTypesValuesCoellction->toArray() as $a) {
$this->offerTable->addColumn(array('key' => $a['event_types_value_id'], 'allowHTML' => true, 'formatter' => '<span class="betOfferElement">{value}</span>', 'label' => $a['event_value_name']));
}
$betsModel = new Model_BetsModel();
$groupsId = $this->getGroupId();
if (!is_numeric($groupsId)) {
return;
}
$eventBetsInTable = $betsModel->completeBetData($groupsId, $eventTypesId)->executeQuery('fetchAssoc');
$data = array();
if (!is_array($eventBetsInTable)) {
return;
}
foreach ($eventBetsInTable as $d) {
$data[$d['event_bets_id']][$d['event_types_value_id_FK']] = $d['odd_value'];
$data[$d['event_bets_id']]['event_bets_name'] = $d['event_bets_name'];
$data[$d['event_bets_id']]['end_date'] = $d['end_date'];
$data[$d['event_bets_id']]['event_bets_id'] = $d['event_bets_id'];
$data[$d['event_bets_id']][$d['event_types_value_id_FK'] . '_odd_value_id'] = $d['odd_value_id'];
$data[$d['event_bets_id']]['bets_id'] = $d['bets_id'];
}
$preperedTableArray = array();
foreach ($data as $value) {
$preperedTableArray[] = $value;
}
$this->offerTable->setData($preperedTableArray);
return $this->offerTable;
}
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');
}
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 setOfferTable()
{
$offerTable = new Extension_View_Yui35_DataTableEdit();
$offerTable->isAddButtonEnabled(false);
$eventTypesValues = new Model_EventTypesValueModel();
$eventTypesValues->addQuery('select', array('table' => $eventTypesValues->getTableName()));
$model = new Model_EventBetsModel();
$offerTable->setModel($model);
$eventTypesId = $this->getEventTypesId();
if (is_numeric($eventTypesId)) {
$eventTypesValues->addQuery('where', array('where_condition' => 'event_types_id_FK=' . (int) $eventTypesId));
} else {
return;
}
$eventTypesValues->addQuery('order', array('order' => implode($eventTypesValues->getPrimaryKeys(), ",") . ' DESC'));
$eventTypesValuesCoellction = new Core_Model_Adapter_ModelCollection();
$eventTypesValuesCoellction->getModelCollection($eventTypesValues);
$offerTable->getTable()->addColumn(array('key' => 'event_bets_id', 'label' => 'ID'));
$offerTable->getTable()->addColumn(array('key' => 'event_bets_name', 'label' => 'Name'));
$offerTable->getTable()->addColumn(array('key' => 'add_date', 'label' => 'Active'));
$offerTable->getTable()->addColumn(array('key' => 'end_date', 'label' => 'Ends'));
$offerTable->getTable()->addColumn(array('key' => 'score', 'label' => 'Score'));
$offerTable->setUpdateRule('exclude', 'end_date');
$offerTable->setUpdateRule('exclude', 'add_date');
$offerTable->getTable()->addColumn('{key:"correct_type",label:"Correct Type",allowHTML:true,formatter:' . $offerTable->getTable()->getFormatter("selectFromModel", array('values' => $eventTypesValuesCoellction, 'value' => 'event_types_value_id', 'label' => 'event_value_name', 'attributes' => array('name' => 'model[' . $model->getModelClassName() . '][correct_type]'))) . '}', false, 'correct_type');
foreach ($eventTypesValuesCoellction->toArray() as $a) {
$offerTable->getTable()->addColumn(array('key' => $a['event_types_value_id'], 'allowHTML' => true, 'formatter' => '<span class="betOfferElement">{value}</span>', 'label' => $a['event_value_name']));
$offerTable->setUpdateRule('exclude', $a['event_types_value_id']);
}
$groupsId = $this->getGroupId();
if (!is_numeric($groupsId)) {
return;
}
$offerTable->setUrl('filter', Application::getRouter()->getFullUrl(array('controller' => 'servicejson', 'action' => 'method', 'params' => 'method=completeEventBetDataArray&groups_id=' . $groupsId . '&event_types_id' . $eventTypesId)));
$preperedTableArray = $model->completeEventBetDataArray($groupsId, $eventTypesId);
$offerTable->getTable()->setData($preperedTableArray);
return $this->offerTable = $offerTable;
}
public function update($forceUpdateFlag = false)
{
$checkIfModelIsUpdatebale = new Model_EventBetsModel();
$checkIfModelIsUpdatebale->load($this->getEventBetsId());
if ($checkIfModelIsUpdatebale->getCorrectType() != null) {
return $this->setValidationError('update', 'Correct Type is set, Event can be updated anymore');
}
parent::update($forceUpdateFlag);
$this->load($this->getEventBetsId());
if ($this->getCorrectType() != null) {
$betTypesModel = new Model_BetsTypeModel();
$betTypesModel->load(array('event_bets_id_FK' => $this->getEventBetsId(), 'event_types_value_id_FK' => $this->getCorrectType()));
$betTypesModel->addQuery('select', array('table' => $betTypesModel->getTableName()));
$betTypesModel->addQuery('where', array('where_condition' => 'event_bets_id_FK=' . $this->getEventBetsId()));
$betTypesModelCollection = new Core_Model_Adapter_ModelCollection();
$betTypesModelCollection->getModelCollection($betTypesModel);
$betTypesKeys = $betTypesModelCollection->getKeysArray('bet_types_id');
$odds = new Model_OddValueModel();
$odds->addQuery('update', array('table' => $odds->getTableName(), 'columns' => 'is_correct=0'));
$odds->addQuery('where', array('where_condition' => 'bet_types_id_FK in (' . implode(',', $betTypesKeys) . ')'));
$odds->executeQuery();
$odds->load(array('bet_types_id_FK' => $betTypesModel->getBetTypesId()));
$odds->setIsCorrect(1);
$odds->update();
$odds->addQuery('select', array('table' => $odds->getTableName()));
$odds->addQuery('where', array('where_condition' => 'bet_types_id_FK in (' . implode(',', $betTypesKeys) . ')'));
$oddsValuesCollection = new Core_Model_Adapter_ModelCollection();
$oddsValuesCollection->getModelCollection($odds);
$oddValuesKeys = $oddsValuesCollection->getKeysArray('odd_value_id');
$betSlip = new Model_BetSlipModel();
$betSlip->addQuery('update', array('table' => $betSlip->getTableName(), 'columns' => 'finished = finished+1'));
$betSlip->addQuery('where', array('where_condition' => 'bet_slip_id in (select bet_slip_id_FK from bet_slip_odds where odd_value_id_FK in (' . implode(',', $oddValuesKeys) . '))'));
$betSlip->executeQuery();
$betSlip->setStatusOne();
$betSlip->proccessBetSlips();
$betSlip->setStatusTwo();
}
}
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 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);
}
public function actionModelcollection()
{
$requestedData = $this->validateModel();
$paramModel = $_REQUEST['model'];
$className = $requestedData['class'];
$method = $requestedData['method'];
$model = new $className();
$where = '';
$divader = '';
if ($method !== null) {
$model->{$method}();
} else {
$model->addQuery('select', array('table' => $model->getTableName()));
}
if (isset($paramModel[$className]['filter'])) {
$where = $this->parseFilter($paramModel[$className]['filter'], $model, $paramModel[$className]['filterGroupOperators']);
}
if ($where != '') {
$model->addQuery('where', array('where_condition' => $where));
}
$sortBy = 'DESC';
if (isset($paramModel[$className]['sortBy'])) {
if ($paramModel[$className]['sortBy'] == 'ASC') {
$sortBy = 'ASC';
}
}
$model->addQuery('order', array('order' => implode($model->getPrimaryKeys(), ",") . ' ' . $sortBy));
if (isset($paramModel[$className]['limitStart'])) {
$start = (int) $paramModel[$className]['limitStart'];
$end = (int) $paramModel[$className]['limitEnd'];
if ($start != 0 || $end != 0) {
$limit = $start;
if ($end != 0) {
$limit = $start . ',' . $end;
}
$model->addQuery('limit', array('limit' => $limit));
}
}
$modelCollection = new Core_Model_Adapter_ModelCollection();
$result = $modelCollection->getModelCollection($model, false);
$countResult = null;
if (isset($paramModel['count'])) {
$countResult = $model->count();
}
if (!$model->isValid()) {
echo json_encode(array('status' => 'error', 'errors' => $modelCollection->modelValidationErrors()));
} else {
$dataForJson = array('status' => 'ok', 'data' => $modelCollection->toServiceArray());
if (isset($countResult)) {
$dataForJson['count'] = $countResult;
}
echo json_encode($dataForJson);
}
}
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 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);
}
public function setModel(Core_Model_Adapter_Object $model, $useModel = true)
{
$this->model = $model;
if ($useModel) {
$modelCollection = new Core_Model_Adapter_ModelCollection();
$modelCollection->getModelCollection($model, false);
if (sizeof($modelCollection->getData()) > 0) {
$this->setTableData($modelCollection->toArray());
}
$this->modelCollection = $modelCollection;
}
}
