/** * @param Player $player * * @return PointLog[] */ public function getForPlayer(Player $player) { $sql = "\n SELECT\n *\n FROM\n pointlog pl\n LEFT JOIN\n match m ON m.id = pl.match_id\n WHERE\n m.player1_id = :id\n OR\n m.player2_id = :id\n OR\n m.team1attack = :id\n OR\n m.team1defence = :id\n OR\n m.team2attack = :id\n OR\n m.team2defence = :id\n ORDER BY\n m.date DESC"; $rsm = new ResultSetMappingBuilder($this->_em); $rsm->addRootEntityFromClassMetadata('Application\\Model\\Entity\\PointLog', 'pl'); $query = $this->_em->createNativeQuery($sql, $rsm); $query->setParameter('id', $player->getId()); $logs = $query->getResult(); return $logs; }
public function testIdProperty() { $this->player->setId(1); $this->assertEquals(1, $this->player->getId()); }