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