/**
* Действие для отображения списка сезонов
*/
public function action_index()
{
$data['seasons'] = \Model_Season::find('all', array('order_by' => array('id' => 'desc')));
$this->template->page_title = 'Команда :: Календарь матчей';
$this->template->content = \View::forge('calendar/index', $data, FALSE);
}
public function action_get_teams_by_season()
{
$data['teams'] = array();
$data['teams'][] = array('id' => '', 'val' => '');
$season = \Model_Season::find('first', array('related' => 'teams', 'where' => array(array('id', '=', \Input::get('season_id')))));
foreach ($season->teams as $value) {
$data['teams'][] = array('id' => $value->id, 'val' => $value->value);
}
return \View::forge('competitions/seasons/get_teams_by_season', $data);
}
/**
* Действие для отображения бомбардиров
*/
public function action_strikers()
{
// Извлекаем настройки из БД
$data['settings'] = \Model_Striker::find('first');
if ($data['settings']->show == 1) {
// Считаем голы игроков
$data['season'] = \Model_Season::find($data['settings']->season_id);
\Config::load('my_config');
$team_id = \Config::get('main_team_id');
$sql = "SELECT COUNT(`m_e`.`player`) AS `goals`, `m_e`.`player` AS `player`\n FROM `matches_events` AS `m_e` \n LEFT JOIN `matches` AS `m` ON (`m_e`.`match_id` = `m`.`id`) \n WHERE `m_e`.`event_id` = 1 \n AND `m`.`status_id` = 2 \n AND `m_e`.`team_id` = {$team_id}\n AND (`m`.`team_1_id` = {$team_id} OR `m`.`team_2_id` = {$team_id})\n AND `m`.`season_id` = {$data['settings']->season_id} \n GROUP BY `m_e`.`player`\n ORDER BY `goals` DESC\n LIMIT 5";
$data['goals'] = \DB::query($sql)->execute();
}
return \View::forge('widgets/strikers', $data, FALSE)->render();
}
