示例#1
0
 public function listOpenQMatchesByTournament($tournamentid)
 {
     $qb = $this->em->createQuery("select m.id as mid,m.matchno,m.date,m.time," . "p.id as pid," . "g.id as gid," . "q.id as rid,q.awayteam,q.rank,gq.id as rgrp " . "from " . $this->entity->getRepositoryPath('QMatchRelation') . " q, " . $this->entity->getRepositoryPath('MatchRelation') . " r, " . $this->entity->getRepositoryPath('Match') . " m, " . $this->entity->getRepositoryPath('Group') . " g, " . $this->entity->getRepositoryPath('Category') . " cat, " . $this->entity->getRepositoryPath('Playground') . " p, " . $this->entity->getRepositoryPath('Group') . " gq " . "where cat.tournament=:tournament and " . "g.category=cat.id and " . "m.group=g.id and " . "p.id=m.playground and " . "q.match=m.id and " . "q.group=gq.id and " . "(select count(r.match) from matchrelations r where r.match=m.id) = 0 " . "order by m.id");
     $qb->setParameter('tournament', $tournamentid);
     // Collect match relations as matches
     $matchList = array();
     foreach ($qb->getResult() as $qmatch) {
         $matchList[$qmatch['matchno']][$qmatch['awayteam'] == 'Y' ? 'A' : 'H'] = $qmatch;
     }
     // Prepare match list for output
     $matches = array();
     foreach ($matchList as $matchRelList) {
         // There must be two relations for each match - otherwise ignore the match
         if (count($matchRelList) == 2) {
             $match = new QMatch();
             $match->setId($matchRelList['H']['mid']);
             $match->setMatchno($matchRelList['H']['matchno']);
             $match->setPid($matchRelList['H']['gid']);
             $match->setPlayground($matchRelList['H']['pid']);
             $match->setDate($matchRelList['H']['date']);
             $match->setTime($matchRelList['H']['time']);
             $match->setGroupA($matchRelList['H']['rgrp']);
             $match->setGroupB($matchRelList['A']['rgrp']);
             $match->setRankA($matchRelList['H']['rank']);
             $match->setRankB($matchRelList['A']['rank']);
             $matches[] = $match;
         }
     }
     // Sort the matches based on schedule
     usort($matches, function (QMatch $match1, QMatch $match2) {
         $p1 = $match2->getPid() - $match1->getPid();
         $p2 = $match2->getDate() - $match1->getDate();
         $p3 = $match2->getPlayground() - $match1->getPlayground();
         $p4 = $match2->getTime() - $match1->getTime();
         if ($p1 == 0 && $p2 == 0 && $p3 == 0 && $p4 == 0) {
             return 0;
         } elseif ($p1 < 0 || $p1 == 0 && $p2 < 0 || $p1 == 0 && $p2 == 0 && $p3 < 0 || $p1 == 0 && $p2 == 0 && $p3 == 0 && $p4 < 0) {
             return 1;
         } else {
             return -1;
         }
     });
     return $matches;
 }
 private function copyMatchForm(Match $match)
 {
     $matchForm = new MatchForm();
     $matchForm->setId($match->getId());
     $matchForm->setPid($match->getGroup()->getId());
     $matchForm->setMatchno($match->getMatchno());
     $matchdate = Date::getDateTime($match->getDate(), $match->getTime());
     $dateformat = $this->get('translator')->trans('FORMAT.DATE');
     $matchForm->setDate(date_format($matchdate, $dateformat));
     $timeformat = $this->get('translator')->trans('FORMAT.TIME');
     $matchForm->setTime(date_format($matchdate, $timeformat));
     $matchForm->setPlayground($match->getPlayground());
     /* @var $homeRel QMatchRelation */
     $homeRel = $this->get('match')->getQMatchRelationByMatch($match->getId(), false);
     if ($homeRel != null) {
         $matchForm->setGroupA($homeRel->getGroup()->getId());
         $matchForm->setRankA($homeRel->getRank());
     }
     /* @var $awayRel QMatchRelation */
     $awayRel = $this->get('match')->getQMatchRelationByMatch($match->getId(), true);
     if ($awayRel != null) {
         $matchForm->setGroupB($awayRel->getGroup()->getId());
         $matchForm->setRankB($awayRel->getRank());
     }
     return $matchForm;
 }