X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=src%2FModel%2FPhoto.php;h=b08c6f0459b8654fe0fdfa220255e24107674376;hb=d993c8584c4c2b6023606e727ea3e0db6a6bde51;hp=229f22107717c268a9a60328c1748a92d2a081e2;hpb=3fc3e67b706cf79e661b3a19def622faca1e5756;p=friendica.git

diff --git a/src/Model/Photo.php b/src/Model/Photo.php
index 229f221077..b08c6f0459 100644
--- a/src/Model/Photo.php
+++ b/src/Model/Photo.php
@@ -4,21 +4,27 @@
  * @file src/Model/Photo.php
  * @brief This file contains the Photo class for database interface
  */
-
 namespace Friendica\Model;
 
+use Friendica\Core\Cache;
+use Friendica\Core\Config;
+use Friendica\Core\L10n;
 use Friendica\Core\System;
 use Friendica\Database\DBM;
 use Friendica\Object\Image;
+use Friendica\Util\DateTimeFormat;
+use Friendica\Util\Network;
 use dba;
 
-require_once "include/photos.php";
+require_once 'include/dba.php';
+
 /**
  * Class to handle photo dabatase table
  */
 class Photo
 {
 	/**
+	 * @param Image   $Image     image
 	 * @param integer $uid       uid
 	 * @param integer $cid       cid
 	 * @param integer $rid       rid
@@ -35,22 +41,22 @@ class Photo
 	 */
 	public static function store(Image $Image, $uid, $cid, $rid, $filename, $album, $scale, $profile = 0, $allow_cid = '', $allow_gid = '', $deny_cid = '', $deny_gid = '', $desc = '')
 	{
-		$r = dba::select('photo', array('guid'), array("`resource-id` = ? AND `guid` != ?", $rid, ''), array('limit' => 1));
-		if (DBM::is_result($r)) {
-			$guid = $r['guid'];
+		$photo = dba::selectFirst('photo', ['guid'], ["`resource-id` = ? AND `guid` != ?", $rid, '']);
+		if (DBM::is_result($photo)) {
+			$guid = $photo['guid'];
 		} else {
-			$guid = get_guid();
+			$guid = System::createGUID();
 		}
 
-		$x = dba::select('photo', array('id'), array('resource-id' => $rid, 'uid' => $uid, 'contact-id' => $cid, 'scale' => $scale), array('limit' => 1));
+		$existing_photo = dba::selectFirst('photo', ['id'], ['resource-id' => $rid, 'uid' => $uid, 'contact-id' => $cid, 'scale' => $scale]);
 
-		$fields = array(
+		$fields = [
 			'uid' => $uid,
 			'contact-id' => $cid,
 			'guid' => $guid,
 			'resource-id' => $rid,
-			'created' => datetime_convert(),
-			'edited' => datetime_convert(),
+			'created' => DateTimeFormat::utcNow(),
+			'edited' => DateTimeFormat::utcNow(),
 			'filename' => basename($filename),
 			'type' => $Image->getType(),
 			'album' => $album,
@@ -65,10 +71,10 @@ class Photo
 			'deny_cid' => $deny_cid,
 			'deny_gid' => $deny_gid,
 			'desc' => $desc
-		);
+		];
 
-		if (DBM::is_result($x)) {
-			$r = dba::update('photo', $fields, array('id' => $x['id']));
+		if (DBM::is_result($existing_photo)) {
+			$r = dba::update('photo', $fields, ['id' => $existing_photo['id']]);
 		} else {
 			$r = dba::insert('photo', $fields);
 		}
@@ -77,34 +83,36 @@ class Photo
 	}
 
 	/**
-	 * @param string  $photo         photo
+	 * @param string  $image_url     Remote URL
 	 * @param integer $uid           user id
 	 * @param integer $cid           contact id
 	 * @param boolean $quit_on_error optional, default false
 	 * @return array
 	 */
-	public static function importProfilePhoto($photo, $uid, $cid, $quit_on_error = false)
+	public static function importProfilePhoto($image_url, $uid, $cid, $quit_on_error = false)
 	{
-		$r = dba::select(
-			'photo', array('resource-id'), array('uid' => $uid, 'contact-id' => $cid, 'scale' => 4, 'album' => 'Contact Photos'), array('limit' => 1)
-		);
+		$thumb = '';
+		$micro = '';
 
-		if (DBM::is_result($r) && strlen($r['resource-id'])) {
-			$hash = $r['resource-id'];
+		$photo = dba::selectFirst(
+			'photo', ['resource-id'], ['uid' => $uid, 'contact-id' => $cid, 'scale' => 4, 'album' => 'Contact Photos']
+		);
+		if (x($photo['resource-id'])) {
+			$hash = $photo['resource-id'];
 		} else {
-			$hash = photo_new_resource();
+			$hash = self::newResource();
 		}
 
 		$photo_failure = false;
 
-		$filename = basename($photo);
-		$img_str = fetch_url($photo, true);
+		$filename = basename($image_url);
+		$img_str = Network::fetchUrl($image_url, true);
 
 		if ($quit_on_error && ($img_str == "")) {
 			return false;
 		}
 
-		$type = Image::guessType($photo, true);
+		$type = Image::guessType($image_url, true);
 		$Image = new Image($img_str, $type);
 		if ($Image->isValid()) {
 			$Image->scaleToSquare(175);
@@ -133,7 +141,7 @@ class Photo
 
 			$suffix = '?ts=' . time();
 
-			$photo = System::baseUrl() . '/photo/' . $hash . '-4.' . $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;
 
@@ -164,11 +172,109 @@ class Photo
 		}
 
 		if ($photo_failure) {
-			$photo = System::baseUrl() . '/images/person-175.jpg';
+			$image_url = System::baseUrl() . '/images/person-175.jpg';
 			$thumb = System::baseUrl() . '/images/person-80.jpg';
 			$micro = System::baseUrl() . '/images/person-48.jpg';
 		}
 
-		return array($photo, $thumb, $micro);
+		return [$image_url, $thumb, $micro];
+	}
+
+	/**
+	 * @param string $exifCoord coordinate
+	 * @param string $hemi      hemi
+	 * @return float
+	 */
+	public static function getGps($exifCoord, $hemi)
+	{
+		$degrees = count($exifCoord) > 0 ? self::gps2Num($exifCoord[0]) : 0;
+		$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;
+
+		return floatval($flip * ($degrees + ($minutes / 60) + ($seconds / 3600)));
+	}
+
+	/**
+	 * @param string $coordPart coordPart
+	 * @return float
+	 */
+	private static function gps2Num($coordPart)
+	{
+		$parts = explode('/', $coordPart);
+
+		if (count($parts) <= 0) {
+			return 0;
+		}
+
+		if (count($parts) == 1) {
+			return $parts[0];
+		}
+
+		return floatval($parts[0]) / floatval($parts[1]);
+	}
+
+	/**
+	 * @brief Fetch the photo albums that are available for a viewer
+	 *
+	 * The query in this function is cost intensive, so it is cached.
+	 *
+	 * @param int  $uid    User id of the photos
+	 * @param bool $update Update the cache
+	 *
+	 * @return array Returns array of the photo albums
+	 */
+	public static function getAlbums($uid, $update = false)
+	{
+		$sql_extra = permissions_sql($uid);
+
+		$key = "photo_albums:".$uid.":".local_user().":".remote_user();
+		$albums = Cache::get($key);
+		if (is_null($albums) || $update) {
+			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`
+					FROM `photo`
+					WHERE `uid` = %d  AND `album` != '%s' AND `album` != '%s' $sql_extra
+					GROUP BY `album` ORDER BY `created` DESC",
+					intval($uid),
+					dbesc('Contact Photos'),
+					dbesc(L10n::t('Contact Photos'))
+				);
+			} else {
+				// This query doesn't do the count and is much faster
+				$albums = q("SELECT DISTINCT(`album`), '' AS `total`
+					FROM `photo` USE INDEX (`uid_album_scale_created`)
+					WHERE `uid` = %d  AND `album` != '%s' AND `album` != '%s' $sql_extra",
+					intval($uid),
+					dbesc('Contact Photos'),
+					dbesc(L10n::t('Contact Photos'))
+				);
+			}
+			Cache::set($key, $albums, CACHE_DAY);
+		}
+		return $albums;
+	}
+
+	/**
+	 * @param int $uid User id of the photos
+	 * @return void
+	 */
+	public static function clearAlbumCache($uid)
+	{
+		$key = "photo_albums:".$uid.":".local_user().":".remote_user();
+		Cache::set($key, null, CACHE_DAY);
+	}
+
+	/**
+	 * Generate a unique photo ID.
+	 *
+	 * @return string
+	 */
+	public static function newResource()
+	{
+		return system::createGUID(32, false);
 	}
 }