File_thumbnail.php 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302
  1. <?php
  2. /*
  3. * StatusNet - the distributed open-source microblogging tool
  4. * Copyright (C) 2008, 2009, StatusNet, Inc.
  5. *
  6. * This program is free software: you can redistribute it and/or modify
  7. * it under the terms of the GNU Affero General Public License as published by
  8. * the Free Software Foundation, either version 3 of the License, or
  9. * (at your option) any later version.
  10. *
  11. * This program is distributed in the hope that it will be useful,
  12. * but WITHOUT ANY WARRANTY; without even the implied warranty of
  13. * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  14. * GNU Affero General Public License for more details.
  15. *
  16. * You should have received a copy of the GNU Affero General Public License
  17. * along with this program. If not, see <http://www.gnu.org/licenses/>.
  18. */
  19. if (!defined('GNUSOCIAL')) { exit(1); }
  20. /**
  21. * Table Definition for file_thumbnail
  22. */
  23. class File_thumbnail extends Managed_DataObject
  24. {
  25. public $__table = 'file_thumbnail'; // table name
  26. public $file_id; // int(4) primary_key not_null
  27. public $urlhash; // varchar(64) indexed
  28. public $url; // text
  29. public $filename; // text
  30. public $width; // int(4) primary_key
  31. public $height; // int(4) primary_key
  32. public $modified; // timestamp() not_null default_CURRENT_TIMESTAMP
  33. const URLHASH_ALG = 'sha256';
  34. public static function schemaDef()
  35. {
  36. return array(
  37. 'fields' => array(
  38. 'file_id' => array('type' => 'int', 'not null' => true, 'description' => 'thumbnail for what URL/file'),
  39. 'urlhash' => array('type' => 'varchar', 'length' => 64, 'description' => 'sha256 of url field if non-empty'),
  40. 'url' => array('type' => 'text', 'description' => 'URL of thumbnail'),
  41. 'filename' => array('type' => 'text', 'description' => 'if stored locally, filename is put here'),
  42. 'width' => array('type' => 'int', 'description' => 'width of thumbnail'),
  43. 'height' => array('type' => 'int', 'description' => 'height of thumbnail'),
  44. 'modified' => array('type' => 'timestamp', 'not null' => true, 'description' => 'date this record was modified'),
  45. ),
  46. 'primary key' => array('file_id', 'width', 'height'),
  47. 'indexes' => array(
  48. 'file_thumbnail_file_id_idx' => array('file_id'),
  49. 'file_thumbnail_urlhash_idx' => array('urlhash'),
  50. ),
  51. 'foreign keys' => array(
  52. 'file_thumbnail_file_id_fkey' => array('file', array('file_id' => 'id')),
  53. )
  54. );
  55. }
  56. /**
  57. * Save oEmbed-provided thumbnail data
  58. *
  59. * @param object $data
  60. * @param int $file_id
  61. */
  62. public static function saveNew($data, $file_id) {
  63. if (!empty($data->thumbnail_url)) {
  64. // Non-photo types such as video will usually
  65. // show us a thumbnail, though it's not required.
  66. self::saveThumbnail($file_id,
  67. $data->thumbnail_url,
  68. $data->thumbnail_width,
  69. $data->thumbnail_height);
  70. } else if ($data->type == 'photo') {
  71. // The inline photo URL given should also fit within
  72. // our requested thumbnail size, per oEmbed spec.
  73. self::saveThumbnail($file_id,
  74. $data->url,
  75. $data->width,
  76. $data->height);
  77. }
  78. }
  79. /**
  80. * Fetch an entry by using a File's id
  81. *
  82. * @param File $file The File object we're getting a thumbnail for.
  83. * @param boolean $notNullUrl Originally remote thumbnails have a URL stored, we use this to find the "original"
  84. *
  85. * @return File_thumbnail
  86. * @throws NoResultException if no File_thumbnail matched the criteria
  87. */
  88. static function byFile(File $file, $notNullUrl=true) {
  89. $thumb = new File_thumbnail();
  90. $thumb->file_id = $file->getID();
  91. if ($notNullUrl) {
  92. $thumb->whereAdd('url IS NOT NULL');
  93. }
  94. $thumb->limit(1);
  95. if (!$thumb->find(true)) {
  96. throw new NoResultException($thumb);
  97. }
  98. return $thumb;
  99. }
  100. /**
  101. * Save a thumbnail record for the referenced file record.
  102. *
  103. * FIXME: Add error handling
  104. *
  105. * @param int $file_id
  106. * @param string $url
  107. * @param int $width
  108. * @param int $height
  109. */
  110. static function saveThumbnail($file_id, $url, $width, $height, $filename=null)
  111. {
  112. $tn = new File_thumbnail;
  113. $tn->file_id = $file_id;
  114. $tn->url = $url;
  115. $tn->filename = $filename;
  116. $tn->width = intval($width);
  117. $tn->height = intval($height);
  118. $tn->insert();
  119. return $tn;
  120. }
  121. static function path($filename)
  122. {
  123. File::tryFilename($filename);
  124. // NOTE: If this is left empty in default config, it will be set to File::path('thumb')
  125. $dir = common_config('thumbnail', 'dir');
  126. if (!in_array($dir[mb_strlen($dir)-1], ['/', '\\'])) {
  127. $dir .= DIRECTORY_SEPARATOR;
  128. }
  129. return $dir . $filename;
  130. }
  131. static function url($filename)
  132. {
  133. File::tryFilename($filename);
  134. // FIXME: private site thumbnails?
  135. $path = common_config('thumbnail', 'path');
  136. if (empty($path)) {
  137. return File::url('thumb')."/{$filename}";
  138. }
  139. $protocol = (GNUsocial::useHTTPS() ? 'https' : 'http');
  140. $server = common_config('thumbnail', 'server') ?: common_config('site', 'server');
  141. if ($path[mb_strlen($path)-1] != '/') {
  142. $path .= '/';
  143. }
  144. if ($path[0] != '/') {
  145. $path = '/'.$path;
  146. }
  147. return $protocol.'://'.$server.$path.$filename;
  148. }
  149. public function getFilename()
  150. {
  151. return File::tryFilename($this->filename);
  152. }
  153. /**
  154. *
  155. * @return string full filesystem path to the locally stored thumbnail file
  156. * @throws
  157. */
  158. public function getPath()
  159. {
  160. $oldpath = File::path($this->getFilename());
  161. $thumbpath = self::path($this->getFilename());
  162. // If we have a file in our old thumbnail storage path, move (or copy) it to the new one
  163. // (if the if/elseif don't match, we have a $thumbpath just as we should and can return it)
  164. if (file_exists($oldpath) && !file_exists($thumbpath)) {
  165. try {
  166. // let's get the filename of the File, to check below if it happens to be identical
  167. $file_filename = $this->getFile()->getFilename();
  168. } catch (NoResultException $e) {
  169. // reasonably the function calling us will handle the following as "File_thumbnail entry should be deleted"
  170. throw new FileNotFoundException($thumbpath);
  171. } catch (InvalidFilenameException $e) {
  172. // invalid filename in getFile()->getFilename(), just
  173. // means the File object isn't stored locally and that
  174. // means it's safe to move it below.
  175. $file_filename = null;
  176. }
  177. if ($this->getFilename() === $file_filename) {
  178. // special case where thumbnail file exactly matches stored File filename
  179. common_debug('File filename and File_thumbnail filename match on '.$this->file_id.', copying instead');
  180. copy($oldpath, $thumbpath);
  181. } elseif (!rename($oldpath, $thumbpath)) {
  182. common_log(LOG_ERR, 'Could not move thumbnail from '._ve($oldpath).' to '._ve($thumbpath));
  183. throw new ServerException('Could not move thumbnail from old path to new path.');
  184. } else {
  185. common_log(LOG_DEBUG, 'Moved thumbnail '.$this->file_id.' from '._ve($oldpath).' to '._ve($thumbpath));
  186. }
  187. } elseif (!file_exists($thumbpath)) {
  188. throw new FileNotFoundException($thumbpath);
  189. }
  190. return $thumbpath;
  191. }
  192. public function getUrl()
  193. {
  194. if (!empty($this->filename) || $this->getFile()->isLocal()) {
  195. // A locally stored File, so we can dynamically generate a URL.
  196. $url = common_local_url('attachment_thumbnail', array('attachment'=>$this->file_id));
  197. if (strpos($url, '?') === false) {
  198. $url .= '?';
  199. }
  200. return $url . http_build_query(array('w'=>$this->width, 'h'=>$this->height));
  201. }
  202. // No local filename available, return the remote URL we have stored
  203. return $this->url;
  204. }
  205. public function getHeight()
  206. {
  207. return $this->height;
  208. }
  209. public function getWidth()
  210. {
  211. return $this->width;
  212. }
  213. /**
  214. * @throws UseFileAsThumbnailException from File_thumbnail->getUrl() for stuff like animated GIFs
  215. */
  216. public function getHtmlAttrs(array $orig=array(), $overwrite=true)
  217. {
  218. $attrs = [
  219. 'height' => $this->getHeight(),
  220. 'width' => $this->getWidth(),
  221. 'src' => $this->getUrl(),
  222. ];
  223. return $overwrite ? array_merge($orig, $attrs) : array_merge($attrs, $orig);
  224. }
  225. public function delete($useWhere=false)
  226. {
  227. try {
  228. $thumbpath = self::path($this->getFilename());
  229. // if file does not exist, try to delete it
  230. $deleted = !file_exists($thumbpath) || @unlink($thumbpath);
  231. if (!$deleted) {
  232. common_log(LOG_ERR, 'Could not unlink existing thumbnail file: '._ve($thumbpath));
  233. }
  234. } catch (InvalidFilenameException $e) {
  235. common_log(LOG_ERR, 'Deleting object but not attempting deleting file: '._ve($e->getMessage()));
  236. }
  237. return parent::delete($useWhere);
  238. }
  239. public function getFile()
  240. {
  241. return File::getByID($this->file_id);
  242. }
  243. static public function hashurl($url)
  244. {
  245. if (!mb_strlen($url)) {
  246. throw new Exception('No URL provided to hash algorithm.');
  247. }
  248. return hash(self::URLHASH_ALG, $url);
  249. }
  250. public function onInsert()
  251. {
  252. $this->setUrlhash();
  253. }
  254. public function onUpdate($dataObject=false)
  255. {
  256. // if we have nothing to compare with OR it has changed from previous entry
  257. if (!$dataObject instanceof Managed_DataObject || $this->url !== $dataObject->url) {
  258. $this->setUrlhash();
  259. }
  260. }
  261. public function setUrlhash()
  262. {
  263. $this->urlhash = mb_strlen($this->url)>0 ? self::hashurl($this->url) : null;
  264. }
  265. }