/**
* Get the stored path for a file
* @param int $file_id
* @param int $version_id
* @param int $storage_location_id
* @param string $thumbnail_handle
* @return null|string
*/
protected function getStoredPath($file_id, $version_id, $storage_location_id, $thumbnail_handle)
{
$builder = $this->connection->createQueryBuilder();
$query = $builder->select('path')->from('FileImageThumbnailPaths', 'p')->where('p.fileID = :file')->andWhere('p.fileVersionID = :version')->andWhere('p.storageLocationID = :storage')->andWhere('p.thumbnailTypeHandle = :thumbnail')->setParameters(array('file' => $file_id, 'version' => $version_id, 'storage' => $storage_location_id, 'thumbnail' => $thumbnail_handle))->execute();
if ($query->rowCount()) {
return $query->fetchColumn();
}
}
