/** * Retrieves a sfAsset object from a relative URL like * /medias/foo/bar.jpg * i.e. the kind of URL returned by $sf_asset->getUrl() */ public static function retrieveFromUrl($url) { $url = sfAssetFolderPeer::cleanPath($url); list($relPath, $filename) = sfAssetsLibraryTools::splitPath($url); $c = new Criteria(); $c->add(sfAssetPeer::FILENAME, $filename); $c->addJoin(sfAssetPeer::FOLDER_ID, sfAssetFolderPeer::ID); $c->add(sfAssetFolderPeer::RELATIVE_PATH, $relPath ? $relPath : null); return sfAssetPeer::doSelectOne($c); }
/** * Retrieves a sfAsset object from a relative URL like * /medias/foo/bar.jpg * i.e. the kind of URL returned by $sf_asset->getUrl() */ public static function retrieveFromUrl($url) { $url = sfAssetFolderPeer::cleanPath($url); list($relPath, $filename) = sfAssetsLibraryTools::splitPath($url); return Doctrine::getTable('sfAsset a')->createQuery()->leftJoin('sfAssetFolder f')->where('f.relative_path = ? AND a.filename = ', $relPath ? $relPath : null, $filename)->fetchOne(); }