concrete/src/File/Image/Thumbnail/Path/Resolver.php
protected function getStoredThumbnailPath($file_id, $version_id, $storage_location_id, $thumbnail_handle, $format)
    {
        $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')
            ->andWhere('p.thumbnailFormat = :format')
            ->setParameters(array(
                'file' => $file_id,
                'version' => $version_id,
                'storage' => $storage_location_id,
                'thumbnail' => $thumbnail_handle,
                'format' => $format,
            ))->execute();

        if ($query->rowCount()) {
            return $query->fetchColumn();
        }

        return null;
    }
protected function getStoredThumbnailPath($file_id, $version_id, $storage_location_id, $thumbnail_handle, $format)
    {
        $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')
            ->andWhere('p.thumbnailFormat = :format')
            ->setParameters(array(
                'file' => $file_id,
                'version' => $version_id,
                'storage' => $storage_location_id,
                'thumbnail' => $thumbnail_handle,
                'format' => $format,
            ))->execute();

        if ($query->rowCount()) {
            return $query->fetchColumn();
        }

        return null;
    }
protected function getStoredThumbnailPath ( $ file_id , $ version_id , $ storage_location_id , $ thumbnail_handle , $ format ) { $ 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' ) -> andWhere ( 'p.thumbnailFormat = :format' ) -> setParameters ( array ( 'file' => $ file_id , 'version' => $ version_id , 'storage' => $ storage_location_id , 'thumbnail' => $ thumbnail_handle , 'format' => $ format , ) ) -> execute ( ) ; if ( $ query -> rowCount ( ) ) { return $ query -> fetchColumn ( ) ; } return null ; }
Get the stored path for a file.

@param int $file_id
@param int $version_id
@param int $storage_location_id
@param string $thumbnail_handle
@param string $format

@return null|string
Get the stored path for a file .