123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139 |
- <?php
- if (!defined('STATUSNET')) {
- exit(1);
- }
- require_once INSTALLDIR . '/classes/Memcached_DataObject.php';
- class GNUsocialPhoto extends Managed_DataObject
- {
- public $__table = 'GNUsocialPhoto';
- public $id;
- public $notice_id;
- public $album_id;
- public $uri;
- public $thumb_uri;
- public $title;
- public $photo_description;
- public $created;
- public $modified;
- public static function schemaDef()
- {
- return array(
- 'fields' => array(
- 'id' => array('type' => 'serial', 'not null' => true, 'description' => 'Unique ID for Photo'),
- 'notice_id' => array('type' => 'int', 'not null' => true, 'description' => 'Notice ID for the related notice'),
- 'album_id' => array('type' => 'int', 'not null' => true, 'description' => 'The parent album ID'),
- 'uri' => array('type' => 'varchar', 'not null' => true, 'length' => 255, 'description' => 'unique address for this photo'),
- 'thumb_uri' => array('type' => 'varchar', 'not null' => true, 'length' => 255, 'description' => 'unique address for this photo thumbnail'),
- 'title' => array('type' => 'varchar', 'not null' => true, 'length' => 255, 'description' => 'The Photo title'),
- 'photo_description' => array('type' => 'text', 'not null' => true, 'description' => 'A description for this photo'),
- 'created' => array('type' => 'datetime', 'not null' => true, 'description' => 'date this record was created'),
- 'modified' => array('type' => 'timestamp', 'not null' => true, 'description' => 'date this record was modified'),
- ),
- 'primary key' => array('id'),
- 'unique keys' => array(
- 'gnusocialphoto_id_key' => array('notice_id'),
- 'gnusocialphoto_uri_key' => array('uri'),
- ),
- 'foreign keys' => array(
- 'gnusocialphoto_notice_id_fkey' => array('notice', array('notice_id' => 'id')),
- 'gnusocialphoto_album_id_fkey' => array('GNUsocialPhotoAlbum', array('album_id' => 'id')),
- ),
- 'indexes' => array(
- 'gnusocialphoto_title_idx' => array('title'),
- ),
- );
- }
- static function saveNew($profile_id, $album_id, $thumb_uri, $uri, $source, $insert_now, $title = null, $photo_description = null)
- {
- $photo = new GNUsocialPhoto();
- $photo->thumb_uri = $thumb_uri;
- $photo->uri = $uri;
- $photo->album_id = $album_id;
- if(!empty($title)) $photo->title = $title;
- if(!empty($photo_description)) $photo->photo_description = (string)$photo_description;
- if($insert_now) {
- $notice = Notice::saveNew($profile_id, $uri, $source);
- $photo->notice_id = $notice->id;
- $photo_id = $photo->insert();
- if (!$photo_id) {
- common_log_db_error($photo, 'INSERT', __FILE__);
- throw new ServerException(_m('Problem Saving Photo.'));
- }
- } else {
- GNUsocialPhotoTemp::$tmp = $photo;
- Notice::saveNew($profile_id, $uri, $source);
- }
- }
- function getPageLink()
- {
- return '/photo/' . $this->id;
- }
-
- static function getGalleryPage($page_id, $album_id, $gallery_size)
- {
- $page_offset = ($page_id-1) * $gallery_size;
- $sql = 'SELECT * FROM GNUsocialPhoto WHERE album_id = ' . $album_id .
- ' ORDER BY notice_id LIMIT ' . $page_offset . ',' . $gallery_size;
- $photo = new GNUsocialPhoto();
- $photo->query($sql);
- $photos = array();
- while ($photo->fetch()) {
- $photos[] = clone($photo);
- }
- return $photos;
- }
- }
|