Rename selectOne to selectFirst

[friendica.git] / src / Model / Photo.php

diff --git a/src/Model/Photo.php b/src/Model/Photo.php
index 229f22107717c268a9a60328c1748a92d2a081e2..a91636b6726e6c0556432e433acc628d0cdd3b25 100644 (file)
--- a/src/Model/Photo.php
+++ b/src/Model/Photo.php
@@ -1,24 +1,27 @@
 <?php
-
 /**
  * @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\PConfig;
 use Friendica\Core\System;
 use Friendica\Database\DBM;
 use Friendica\Object\Image;
 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,14 +38,14 @@ 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));
+               $r = dba::selectFirst('photo', ['guid'], ["`resource-id` = ? AND `guid` != ?", $rid, '']);
                if (DBM::is_result($r)) {
                        $guid = $r['guid'];
                } else {
                        $guid = get_guid();
                }
 
-               $x = dba::select('photo', array('id'), array('resource-id' => $rid, 'uid' => $uid, 'contact-id' => $cid, 'scale' => $scale), array('limit' => 1));
+               $x = dba::selectFirst('photo', ['id'], ['resource-id' => $rid, 'uid' => $uid, 'contact-id' => $cid, 'scale' => $scale]);
 
                $fields = array(
                        'uid' => $uid,
@@ -85,8 +88,8 @@ class Photo
         */
        public static function importProfilePhoto($photo, $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)
+               $r = dba::selectFirst(
+                       'photo', ['resource-id'], ['uid' => $uid, 'contact-id' => $cid, 'scale' => 4, 'album' => 'Contact Photos']
                );
 
                if (DBM::is_result($r) && strlen($r['resource-id'])) {
@@ -171,4 +174,92 @@ class Photo
 
                return array($photo, $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(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(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);
+       }
 }