public function getLastIssueByJournal(Journal $journal)
{
$query = $this->createQueryBuilder("i")->andWhere('i.journal = :journal')->andWhere('i.published = :published')->andWhere('i.year IS NOT NULL')->orderBy('i.year', 'DESC')->orderBy('i.datePublished', 'DESC')->setParameter('journal', $journal)->setParameter('published', true)->setMaxResults(1)->getQuery();
$issues = $query->getResult();
if (count($issues) == 0) {
return null;
}
if (count($issues) == 1) {
return $issues[0];
}
return null;
}