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;
}
public function completeEventBetDataArray($groupsId = null, $eventTypesId = null)
{
if ($groupsId === null) {
if (isset($_GET['groups_id'])) {
$groupsId = (int) $_GET['groups_id'];
}
}
if ($eventTypesId === null) {
if (isset($_GET['event_types_id'])) {
$eventTypesId = (int) $_GET['event_types_id'];
}
}
$betsModel = new Model_BetsModel();
$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'];
$data[$d['event_bets_id']]['score'] = $d['score'];
$data[$d['event_bets_id']]['correct_type'] = $d['correct_type'];
$data[$d['event_bets_id']]['add_date'] = $d['add_date'];
$data[$d['event_bets_id']]['event_bets_id'] = $d['event_bets_id'];
}
$preperedTableArray = array();
foreach ($data as $value) {
$preperedTableArray[] = $value;
}
return $preperedTableArray;
}
