X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=src%2FModel%2FPhoto.php;h=3c22c52bc1d06ee9a25a32a5db38bcad2477f2f6;hb=234c110d38f50dfcf181797cf02bd721847eb486;hp=a9b4c0fb736fd139957518921de46f03cac308d5;hpb=9c9ebfc7c97016881d9ad2bb3c3b54a5640d2f08;p=friendica.git diff --git a/src/Model/Photo.php b/src/Model/Photo.php index a9b4c0fb73..3c22c52bc1 100644 --- a/src/Model/Photo.php +++ b/src/Model/Photo.php @@ -6,24 +6,179 @@ */ namespace Friendica\Model; +use Friendica\BaseObject; use Friendica\Core\Cache; use Friendica\Core\Config; use Friendica\Core\L10n; use Friendica\Core\System; use Friendica\Database\DBA; +use Friendica\Database\DBStructure; use Friendica\Object\Image; use Friendica\Util\DateTimeFormat; use Friendica\Util\Network; use Friendica\Util\Security; -require_once 'include/dba.php'; +require_once "include/dba.php"; /** * Class to handle photo dabatase table */ -class Photo +class Photo extends BaseObject { /** + * @brief Select rows from the photo table + * + * @param array $fields Array of selected fields, empty for all + * @param array $conditions Array of fields for conditions + * @param array $params Array of several parameters + * + * @return boolean|array + * + * @see \Friendica\Database\DBA::select + */ + public static function select(array $fields = [], array $conditions = [], array $params = []) + { + if (empty($fields)) { + $selected = self::getFields(); + } + + $r = DBA::select("photo", $fields, $conditions, $params); + return DBA::toArray($r); + } + + /** + * @brief Retrieve a single record from the photo table + * + * @param array $fields Array of selected fields, empty for all + * @param array $conditions Array of fields for conditions + * @param array $params Array of several parameters + * + * @return bool|array + * + * @see \Friendica\Database\DBA::select + */ + public static function selectFirst(array $fields = [], array $conditions = [], array $params = []) + { + if (empty($fields)) { + $fields = self::getFields(); + } + + return DBA::selectFirst("photo", $fields, $conditions, $params); + } + + /** + * @brief Get a single photo given resource id and scale + * + * This method checks for permissions. Returns associative array + * on success, "no sign" image info, if user has no permission, + * false if photo does not exists + * + * @param string $resourceid Rescource ID for the photo + * @param integer $scale Scale of the photo. Defaults to 0 + * + * @return boolean|array + */ + public static function getPhoto($resourceid, $scale = 0) + { + $r = self::selectFirst(["uid"], ["resource-id" => $resourceid]); + if ($r === false) { + return false; + } + + $sql_acl = Security::getPermissionsSQLByUserId($r["uid"]); + + $conditions = [ + "`resource-id` = ? AND `scale` <= ? " . $sql_acl, + $resourceid, $scale + ]; + + $params = ["order" => ["scale" => true]]; + + $photo = self::selectFirst([], $conditions, $params); + if ($photo === false) { + return self::createPhotoForSystemResource("images/nosign.jpg"); + } + return $photo; + } + + /** + * @brief Check if photo with given resource id exists + * + * @param string $resourceid Resource ID of the photo + * + * @return boolean + */ + public static function exists($resourceid) + { + return DBA::count("photo", ["resource-id" => $resourceid]) > 0; + } + + /** + * @brief Get Image object for given row id. null if row id does not exist + * + * @param integer $id Row id + * + * @return \Friendica\Object\Image + */ + public static function getImageForPhoto($photo) + { + $data = ""; + if ($photo["backend-class"] == "") { + // legacy data storage in "data" column + $i = self::selectFirst(["data"], ["id"=>$photo["id"]]); + if ($i === false) { + return null; + } + $data = $i["data"]; + } else { + $backendClass = $photo["backend-class"]; + $backendRef = $photo["backend-ref"]; + $data = $backendClass::get($backendRef); + } + + if ($data === "") { + return null; + } + return new Image($data, $photo["type"]); + } + + /** + * @brief Return a list of fields that are associated with the photo table + * + * @return array field list + */ + private static function getFields() + { + $allfields = DBStructure::definition(false); + $fields = array_keys($allfields["photo"]["fields"]); + array_splice($fields, array_search("data", $fields), 1); + return $fields; + } + + /** + * @brief Construct a photo array for a system resource image + * + * @param string $filename Image file name relative to code root + * @param string $mimetype Image mime type. Defaults to "image/jpeg" + * + * @return array + */ + public static function createPhotoForSystemResource($filename, $mimetype = "image/jpeg") + { + $fields = self::getFields(); + $values = array_fill(0, count($fields), ""); + $photo = array_combine($fields, $values); + $photo["backend-class"] = "\Friendica\Model\Storage\SystemResource"; + $photo["backend-ref"] = $filename; + $photo["type"] = $mimetype; + $photo["cacheable"] = false; + return $photo; + } + + + /** + * @brief store photo metadata in db and binary in default backend + * * @param Image $Image image * @param integer $uid uid * @param integer $cid cid @@ -32,56 +187,94 @@ class Photo * @param string $album album name * @param integer $scale scale * @param integer $profile optional, default = 0 - * @param string $allow_cid optional, default = '' - * @param string $allow_gid optional, default = '' - * @param string $deny_cid optional, default = '' - * @param string $deny_gid optional, default = '' - * @param string $desc optional, default = '' - * @return object + * @param string $allow_cid optional, default = "" + * @param string $allow_gid optional, default = "" + * @param string $deny_cid optional, default = "" + * @param string $deny_gid optional, default = "" + * @param string $desc optional, default = "" + * + * @return boolean True on success */ - public static function store(Image $Image, $uid, $cid, $rid, $filename, $album, $scale, $profile = 0, $allow_cid = '', $allow_gid = '', $deny_cid = '', $deny_gid = '', $desc = '') + public static function store(Image $Image, $uid, $cid, $rid, $filename, $album, $scale, $profile = 0, $allow_cid = "", $allow_gid = "", $deny_cid = "", $deny_gid = "", $desc = "") { - $photo = DBA::selectFirst('photo', ['guid'], ["`resource-id` = ? AND `guid` != ?", $rid, '']); + $photo = self::selectFirst(["guid"], ["`resource-id` = ? AND `guid` != ?", $rid, ""]); if (DBA::isResult($photo)) { - $guid = $photo['guid']; + $guid = $photo["guid"]; } else { $guid = System::createGUID(); } - $existing_photo = DBA::selectFirst('photo', ['id'], ['resource-id' => $rid, 'uid' => $uid, 'contact-id' => $cid, 'scale' => $scale]); + $existing_photo = self::selectFirst(["id", "backend-class", "backend-ref"], ["resource-id" => $rid, "uid" => $uid, "contact-id" => $cid, "scale" => $scale]); + + // Get defined storage backend. + // if no storage backend, we use old "data" column in photo table. + // if is an existing photo, reuse same backend + $data = ""; + $backend_ref = ""; + $backend_class = ""; + + if (DBA::isResult($existing_photo)) { + $backend_ref = (string)$existing_photo["backend-ref"]; + $backend_class = (string)$existing_photo["backend-class"]; + } else { + $backend_class = Config::get("storage", "class", ""); + } + if ($backend_class === "") { + $data = $Image->asString(); + } else { + $backend_ref = $backend_class::put($Image->asString(), $backend_ref); + } + $fields = [ - 'uid' => $uid, - 'contact-id' => $cid, - 'guid' => $guid, - 'resource-id' => $rid, - 'created' => DateTimeFormat::utcNow(), - 'edited' => DateTimeFormat::utcNow(), - 'filename' => basename($filename), - 'type' => $Image->getType(), - 'album' => $album, - 'height' => $Image->getHeight(), - 'width' => $Image->getWidth(), - 'datasize' => strlen($Image->asString()), - 'data' => $Image->asString(), - 'scale' => $scale, - 'profile' => $profile, - 'allow_cid' => $allow_cid, - 'allow_gid' => $allow_gid, - 'deny_cid' => $deny_cid, - 'deny_gid' => $deny_gid, - 'desc' => $desc + "uid" => $uid, + "contact-id" => $cid, + "guid" => $guid, + "resource-id" => $rid, + "created" => DateTimeFormat::utcNow(), + "edited" => DateTimeFormat::utcNow(), + "filename" => basename($filename), + "type" => $Image->getType(), + "album" => $album, + "height" => $Image->getHeight(), + "width" => $Image->getWidth(), + "datasize" => strlen($Image->asString()), + "data" => $data, + "scale" => $scale, + "profile" => $profile, + "allow_cid" => $allow_cid, + "allow_gid" => $allow_gid, + "deny_cid" => $deny_cid, + "deny_gid" => $deny_gid, + "desc" => $desc, + "backend-class" => $backend_class, + "backend-ref" => $backend_ref ]; if (DBA::isResult($existing_photo)) { - $r = DBA::update('photo', $fields, ['id' => $existing_photo['id']]); + $r = DBA::update("photo", $fields, ["id" => $existing_photo["id"]]); } else { - $r = DBA::insert('photo', $fields); + $r = DBA::insert("photo", $fields); } return $r; } + public static function delete(array $conditions, $options = []) + { + // get photo to delete data info + $photos = self::select(["backend-class","backend-ref"], $conditions); + + foreach($photos as $photo) { + $backend_class = (string)$photo["backend-class"]; + if ($backend_class !== "") { + $backend_class::delete($photo["backend-ref"]); + } + } + + return DBA::delete("photo", $conditions, $options); + } + /** * @param string $image_url Remote URL * @param integer $uid user id @@ -91,14 +284,14 @@ class Photo */ public static function importProfilePhoto($image_url, $uid, $cid, $quit_on_error = false) { - $thumb = ''; - $micro = ''; + $thumb = ""; + $micro = ""; $photo = DBA::selectFirst( - 'photo', ['resource-id'], ['uid' => $uid, 'contact-id' => $cid, 'scale' => 4, 'album' => 'Contact Photos'] + "photo", ["resource-id"], ["uid" => $uid, "contact-id" => $cid, "scale" => 4, "album" => "Contact Photos"] ); - if (x($photo['resource-id'])) { - $hash = $photo['resource-id']; + if (!empty($photo['resource-id'])) { + $hash = $photo["resource-id"]; } else { $hash = self::newResource(); } @@ -117,7 +310,7 @@ class Photo if ($Image->isValid()) { $Image->scaleToSquare(300); - $r = self::store($Image, $uid, $cid, $hash, $filename, 'Contact Photos', 4); + $r = self::store($Image, $uid, $cid, $hash, $filename, "Contact Photos", 4); if ($r === false) { $photo_failure = true; @@ -125,7 +318,7 @@ class Photo $Image->scaleDown(80); - $r = self::store($Image, $uid, $cid, $hash, $filename, 'Contact Photos', 5); + $r = self::store($Image, $uid, $cid, $hash, $filename, "Contact Photos", 5); if ($r === false) { $photo_failure = true; @@ -133,32 +326,32 @@ class Photo $Image->scaleDown(48); - $r = self::store($Image, $uid, $cid, $hash, $filename, 'Contact Photos', 6); + $r = self::store($Image, $uid, $cid, $hash, $filename, "Contact Photos", 6); if ($r === false) { $photo_failure = true; } - $suffix = '?ts=' . time(); + $suffix = "?ts=" . time(); - $image_url = System::baseUrl() . '/photo/' . $hash . '-4.' . $Image->getExt() . $suffix; - $thumb = System::baseUrl() . '/photo/' . $hash . '-5.' . $Image->getExt() . $suffix; - $micro = System::baseUrl() . '/photo/' . $hash . '-6.' . $Image->getExt() . $suffix; + $image_url = System::baseUrl() . "/photo/" . $hash . "-4." . $Image->getExt() . $suffix; + $thumb = System::baseUrl() . "/photo/" . $hash . "-5." . $Image->getExt() . $suffix; + $micro = System::baseUrl() . "/photo/" . $hash . "-6." . $Image->getExt() . $suffix; // Remove the cached photo - $a = get_app(); + $a = \get_app(); $basepath = $a->getBasePath(); if (is_dir($basepath . "/photo")) { - $filename = $basepath . '/photo/' . $hash . '-4.' . $Image->getExt(); + $filename = $basepath . "/photo/" . $hash . "-4." . $Image->getExt(); if (file_exists($filename)) { unlink($filename); } - $filename = $basepath . '/photo/' . $hash . '-5.' . $Image->getExt(); + $filename = $basepath . "/photo/" . $hash . "-5." . $Image->getExt(); if (file_exists($filename)) { unlink($filename); } - $filename = $basepath . '/photo/' . $hash . '-6.' . $Image->getExt(); + $filename = $basepath . "/photo/" . $hash . "-6." . $Image->getExt(); if (file_exists($filename)) { unlink($filename); } @@ -172,9 +365,9 @@ class Photo } if ($photo_failure) { - $image_url = System::baseUrl() . '/images/person-300.jpg'; - $thumb = System::baseUrl() . '/images/person-80.jpg'; - $micro = System::baseUrl() . '/images/person-48.jpg'; + $image_url = System::baseUrl() . "/images/person-300.jpg"; + $thumb = System::baseUrl() . "/images/person-80.jpg"; + $micro = System::baseUrl() . "/images/person-48.jpg"; } return [$image_url, $thumb, $micro]; @@ -191,7 +384,7 @@ class Photo $minutes = count($exifCoord) > 1 ? self::gps2Num($exifCoord[1]) : 0; $seconds = count($exifCoord) > 2 ? self::gps2Num($exifCoord[2]) : 0; - $flip = ($hemi == 'W' || $hemi == 'S') ? -1 : 1; + $flip = ($hemi == "W" || $hemi == "S") ? -1 : 1; return floatval($flip * ($degrees + ($minutes / 60) + ($seconds / 3600))); } @@ -202,7 +395,7 @@ class Photo */ private static function gps2Num($coordPart) { - $parts = explode('/', $coordPart); + $parts = explode("/", $coordPart); if (count($parts) <= 0) { return 0; @@ -232,7 +425,7 @@ class Photo $key = "photo_albums:".$uid.":".local_user().":".remote_user(); $albums = Cache::get($key); if (is_null($albums) || $update) { - if (!Config::get('system', 'no_count', false)) { + if (!Config::get("system", "no_count", false)) { /// @todo This query needs to be renewed. It is really slow // At this time we just store the data in the cache $albums = q("SELECT COUNT(DISTINCT `resource-id`) AS `total`, `album`, ANY_VALUE(`created`) AS `created` @@ -240,8 +433,8 @@ class Photo WHERE `uid` = %d AND `album` != '%s' AND `album` != '%s' $sql_extra GROUP BY `album` ORDER BY `created` DESC", intval($uid), - DBA::escape('Contact Photos'), - DBA::escape(L10n::t('Contact Photos')) + DBA::escape("Contact Photos"), + DBA::escape(L10n::t("Contact Photos")) ); } else { // This query doesn't do the count and is much faster @@ -249,8 +442,8 @@ class Photo FROM `photo` USE INDEX (`uid_album_scale_created`) WHERE `uid` = %d AND `album` != '%s' AND `album` != '%s' $sql_extra", intval($uid), - DBA::escape('Contact Photos'), - DBA::escape(L10n::t('Contact Photos')) + DBA::escape("Contact Photos"), + DBA::escape(L10n::t("Contact Photos")) ); } Cache::set($key, $albums, Cache::DAY);