Пример #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 checkForm($form, MatchForm $matchForm)
 {
     if (!$form->isValid()) {
         return false;
     }
     if ($matchForm->getGroupA() == null) {
         $form->addError(new FormError($this->get('translator')->trans('FORM.MATCH.NOHOMEGROUP', array(), 'admin')));
     }
     if ($matchForm->getGroupB() == null) {
         $form->addError(new FormError($this->get('translator')->trans('FORM.MATCH.NOAWAYGROUP', array(), 'admin')));
     }
     if ($matchForm->getRankA() == null || trim($matchForm->getRankA()) == '') {
         $form->addError(new FormError($this->get('translator')->trans('FORM.MATCH.NOHOMERANK', array(), 'admin')));
     }
     if ($matchForm->getRankB() == null || trim($matchForm->getRankB()) == '') {
         $form->addError(new FormError($this->get('translator')->trans('FORM.MATCH.NOAWAYRANK', array(), 'admin')));
     } elseif ($matchForm->getGroupA() == $matchForm->getGroupB() && $matchForm->getRankA() == $matchForm->getRankB()) {
         $form->addError(new FormError($this->get('translator')->trans('FORM.MATCH.SAMEQ', array(), 'admin')));
     }
     return $form->isValid();
 }