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;
}
/**
* This method moves a uploaded file into a permanent folder.
*/
public function moveFileAction($campaignId, $tmpData)
{
// Create an instance of the Campaign:
$campaign = $this->getDoctrine()->getRepository('CampaignBundle:Campaign')->findOneById($campaignId);
// Populate the File object with data:
$file = new ProjectFile();
// Set temporary file to be of UploadedFile type:
$temporaryFile = new File(__DIR__ . '/../../../../../web/uploads/tmp/' . 'tmp_' . $tmpData['tmpUuid'] . '.tmp');
$file->setFile($temporaryFile);
$file->setUuid(Uuid::uuid4()->toString());
$file->setOriginalName($tmpData['fileName']);
$file->setContentType($file->getFileExtension($file->getOriginalName()));
$file->setFileLength($tmpData['fileLength']);
$file->setFileName($file->getUuid() . $file->getContentType());
$file->setNotVisible(FALSE);
// Specify User Creator:
$file->setUser($this->getUser());
// Set time for when the file was created:
$creationDate = new \DateTime();
$creationDate->setTimezone(self::timezoneUTC());
$file->setCreatedAt($creationDate);
$file->setUpdatedAt($creationDate);
// Set Matrix file version and uuid:
if ($campaign->getMatrixfileUuid() == null) {
// Matrix file not yet created.
$file->setVersion(1);
$campaign->setMatrixfileUuid($file->getUuid());
$campaign->setMatrixfileVersion($file->getVersion());
} else {
// Increment matrix file version.
// Retrieve latest version number of matrix file for this campaign:
$fileRepository = $this->getDoctrine()->getRepository('FileBundle:File');
$versionQuery = $fileRepository->createQueryBuilder('f')->where('f.campaign = :campaign and f.task IS NULL')->setParameter('campaign', $campaign)->orderBy('f.version', 'DESC')->setMaxResults(1)->getQuery();
$latestMatrixVersion = $versionQuery->getSingleResult()->getVersion();
// Set file version:
$file->setVersion($latestMatrixVersion + 1);
$campaign->setMatrixfileUuid($file->getUuid());
$campaign->setMatrixfileVersion($file->getVersion());
}
// End of version IF.
$file->setCampaign($campaign);
// Get validator service to check for errors:
$validator = $this->get('validator');
$errors = $validator->validate($file);
$response = new Response();
// Create and prepare Response object to be sent back to client.
// Validate the values entered in the File object:
if (count($errors) > 0) {
$ok = false;
// Return $errors in JSON format:
$serializer = $this->get('jms_serializer');
$serializer->serialize($errors, 'json');
return array($errors, $ok);
}
// End of errors IF.
// If no errors were found, handle the File data:
$ok = true;
$em = $this->getDoctrine()->getManager();
$targetDir = 'campaign_files/' . $campaign->getId();
// Specify target directory for file.
$file->upload($targetDir);
// Move matrix file in target directory.
$campaign->setUpdatedAt($creationDate);
$em->persist($file);
$em->flush();
return array($file->getUuid(), $ok);
}