public function executeExternalTvStatsTeams(sfWebRequest $request)
 {
     $this->setLayout("layout_external");
     $this->forward404Unless($request->getParameter("ids"));
     $this->forward404Unless($request->getParameter("team1"));
     $this->forward404Unless($request->getParameter("team2"));
     $this->matchs = MatchsTable::getInstance()->createQuery()->where("id IN ?", array(explode(",", $request->getParameter("ids"))))->execute();
     $this->team1 = TeamsTable::getInstance()->find($request->getParameter("team1"));
     $this->team2 = TeamsTable::getInstance()->find($request->getParameter("team2"));
 }
Exemple #2
0
 public function executeTeamsInSeasons(sfWebRequest $request)
 {
     if ($request->getMethod() == sfWebRequest::POST) {
         if ($request->getPostParameter("season_id")) {
             $season_id = $request->getPostParameter("season_id");
             $getTeams = TeamsInSeasonsTable::getInstance()->createQuery('s')->select('s.team_id')->where('s.season_id = ?', $season_id)->fetchArray();
             $teams = array();
             for ($i = 0; $i < count($getTeams); $i++) {
                 $teams['id'][] = $getTeams[$i]['team_id'];
                 $name = TeamsTable::getInstance()->createQuery('t')->select('t.name, t.flag')->where('t.id = ?', $getTeams[$i]['team_id'])->fetchArray();
                 $teams['name'][] = $name[0]['name'];
                 $teams['flag'][] = $name[0]['flag'];
             }
             echo json_encode($teams);
         }
     }
     return sfView::NONE;
 }