/**
* @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());
}
