public function getStartUnits(Scenario $scenario) { return $this->getEntityManager()->createQuery('SELECT ued FROM WotRBundle:UnitEntryDetails ued ' . 'WHERE :id MEMBER OF ued.scenario')->setParameter('id', $scenario->getId())->getResult(); }
public function getStartCards(Scenario $scenario) { return $this->getEntityManager()->createQuery('SELECT ced, cd FROM WotRBundle:CardEntryDetails ced ' . 'JOIN ced.cardDetails cd ' . 'WHERE ced.scenario = :id ' . 'AND ced.turn = 1')->setParameter('id', $scenario->getId())->getResult(); }
public function getStartCharacters(Scenario $scenario) { return $this->getEntityManager()->createQuery('SELECT cd FROM WotRBundle:CharacterDetails cd ' . 'WHERE :id MEMBER OF cd.scenario')->setParameter('id', $scenario->getId())->getResult(); }