public function getLatestFileVersion(Campaign $campaign, File $originalName)
{
$fileRepository = $this->getEntityManager();
$versionQuery = $fileRepository->createQuery('SELECT f
FROM FileBundle:File f
WHERE f.campaign = :campaign
AND f.originalName = :originalName
AND f.task = :task
AND f.fileType = :fileType
AND f.contentType = :contentType
AND f.version IS NOT NULL
AND f.notVisible != TRUE
ORDER BY f.version DESC')->setMaxResults(1)->setParameter('campaign', $campaign)->setParameter('originalName', $originalName->getOriginalName())->setParameter('task', $originalName->getTask())->setParameter('fileType', $originalName->getFileType())->setParameter('contentType', $originalName->getContentType());
$latestVersion = $versionQuery->getOneOrNullResult();
return $latestVersion;
}
