public function execute()
{
$query = trim(waRequest::post('q'), ' /');
$hash = '/search/' . $query;
$collection = new photosCollection($hash);
if ($query == 'rate>0') {
$collection->orderBy('p.rate DESC, p.id');
}
$this->template = 'templates/actions/photo/PhotoList.html';
$count = $this->getConfig()->getOption('photos_per_page');
$photos = $collection->getPhotos("*,thumb,thumb_crop,thumb_middle,thumb_big,tags,edit_rights", 0, $count);
$photos = photosCollection::extendPhotos($photos);
$frontend_link = $query == 'rate>0' ? photosCollection::getFrontendLink('favorites', false) : photosCollection::getFrontendLink($hash, false);
/**
* @event search_frontend_link
* @param string $query
* @return array of bool|string if false - default frontend_link isn't overridden, if string - override default frontend link
*/
$res = wa()->event('search_frontend_link', $query);
foreach ($res as $r) {
if (is_string($r)) {
$frontend_link = $r;
break;
}
}
$config = $this->getConfig();
$this->view->assign('sidebar_width', $config->getSidebarWidth());
$this->view->assign('big_size', $config->getSize('big'));
$this->view->assign('frontend_link', $frontend_link);
$this->view->assign('photos', $photos);
$this->view->assign('title', $query == 'rate>0' ? _w('Rated') : $collection->getTitle());
$this->view->assign('total_count', $collection->count());
$this->view->assign('sort_method', $query == 'rate>0' ? 'rate' : 'upload_datetime');
$this->view->assign('hash', $hash);
}
public function execute()
{
$query = trim(waRequest::post('q'), ' /');
$hash = '/search/' . $query;
$collection = new photosCollection($hash);
if ($query == 'rate>0') {
$collection->orderBy('p.rate DESC, p.id');
}
$this->template = 'templates/actions/photo/PhotoList.html';
$photos = $collection->getPhotos("*,thumb,thumb_crop,thumb_middle,thumb_big,tags,edit_rights");
$photos = photosCollection::extendPhotos($photos);
$this->view->assign('big_size', $this->getConfig()->getSize('big'));
$this->view->assign('frontend_link', $query == 'rate>0' ? photosCollection::getFrontendLink('favorites', false) : photosCollection::getFrontendLink($hash, false));
$this->view->assign('photos', $photos);
$this->view->assign('title', $query == 'rate>0' ? _w('Rated') : $collection->getTitle());
$this->view->assign('total_count', $collection->count());
}
<?php
$model = new waModel();
try {
$model->query("SELECT key_photo_id FROM photos_album WHERE 0");
} catch (waException $e) {
$model->exec("ALTER TABLE `photos_album` ADD `key_photo_id` INT(11) NULL DEFAULT NULL");
}
// Set cover photo for all static albums
$sql = "SELECT a.id AS album_id,\n (SELECT ap.photo_id FROM photos_album_photos AS ap WHERE ap.album_id=a.id ORDER BY RAND() LIMIT 1)\n AS photo_id\n FROM photos_album AS a\n WHERE a.type=0\n AND key_photo_id IS NULL";
foreach ($model->query($sql) as $row) {
if ($row['photo_id']) {
$sql = "UPDATE photos_album SET key_photo_id=? WHERE id=?";
$model->query($sql, array($row['photo_id'], $row['album_id']));
}
}
// Set cover photo for the first 50 dynamic albums
$sql = "SELECT id FROM photos_album WHERE type=1 AND key_photo_id IS NULL LIMIT 50";
foreach ($model->query($sql) as $album) {
$collection = new photosCollection('album/' . $album['id']);
$collection->orderBy('RAND(), p.id');
$photos = $collection->getPhotos("id", 0, 1, false);
if ($photos) {
$photo = reset($photos);
$sql = "UPDATE photos_album SET key_photo_id=? WHERE id=?";
$model->query($sql, array($photo['id'], $album['id']));
}
}
public function execute()
{
$id = waRequest::post('id', 0, waRequest::TYPE_INT);
$in_stack = waRequest::post('in_stack', 0, waRequest::TYPE_INT);
$hash = waRequest::post('hash', null, waRequest::TYPE_STRING_TRIM);
$hash = urldecode($hash);
// get photo
$this->photo_model = new photosPhotoModel();
$this->photo = $this->photo_model->getById($id);
if (!$this->photo) {
throw new waException(_w("Photo doesn't exists"), 404);
}
$photo_rights_model = new photosPhotoRightsModel();
if (!$photo_rights_model->checkRights($this->photo)) {
throw new waRightsException(_w("You don't have sufficient access rights"));
}
$this->photo['name_not_escaped'] = $this->photo['name'];
$this->photo = photosPhoto::escapeFields($this->photo);
$this->photo['upload_datetime_formatted'] = waDateTime::format('humandate', $this->photo['upload_datetime']);
$this->photo['upload_timestamp'] = strtotime($this->photo['upload_datetime']);
$this->photo['edit_rights'] = $photo_rights_model->checkRights($this->photo, true);
$this->photo['private_url'] = photosPhotoModel::getPrivateUrl($this->photo);
$this->photo['thumb'] = photosPhoto::getThumbInfo($this->photo, photosPhoto::getThumbPhotoSize());
$this->photo['thumb_big'] = photosPhoto::getThumbInfo($this->photo, photosPhoto::getBigPhotoSize());
$this->photo['thumb_middle'] = photosPhoto::getThumbInfo($this->photo, photosPhoto::getMiddlePhotoSize());
$original_photo_path = photosPhoto::getOriginalPhotoPath($this->photo);
if (wa('photos')->getConfig()->getOption('save_original') && file_exists($original_photo_path)) {
$this->photo['original_exists'] = true;
} else {
$this->photo['original_exists'] = false;
}
$photo_tags_model = new photosPhotoTagsModel();
$tags = $photo_tags_model->getTags($id);
$this->photo['tags'] = $tags;
$this->response['photo'] = $this->photo;
// get stack if it's possible
if (!$in_stack && ($stack = $this->photo_model->getStack($id, array('thumb' => true, 'thumb_crop' => true, 'thumb_big' => true, 'thumb_middle' => true)))) {
$this->response['stack'] = $stack;
}
// get albums
$album_photos_model = new photosAlbumPhotosModel();
$albums = $album_photos_model->getAlbums($id, array('id', 'name'));
$this->response['albums'] = isset($albums[$id]) ? array_values($albums[$id]) : array();
// exif info
$exif_model = new photosPhotoExifModel();
$exif = $exif_model->getByPhoto($this->photo['id']);
if (isset($exif['DateTimeOriginal'])) {
$exif['DateTimeOriginal'] = waDateTime::format('humandatetime', $exif['DateTimeOriginal'], date_default_timezone_get());
}
$this->response['exif'] = $exif;
// get author
$contact = new waContact($this->photo['contact_id']);
$this->response['author'] = array('id' => $contact['id'], 'name' => photosPhoto::escape($contact['name']), 'photo_url' => $contact->getPhoto(photosPhoto::AUTHOR_PHOTO_SIZE), 'backend_url' => $this->getConfig()->getBackendUrl(true) . 'contacts/#/contact/' . $contact['id']);
// for making inline-editable widget
$this->response['frontend_link_template'] = photosFrontendPhoto::getLink(array('url' => '%url%'));
$hooks = array();
$parent_id = $this->photo_model->getStackParentId($this->photo);
$photo_id = $parent_id ? $parent_id : $id;
/**
* Extend photo page
* Add extra widget(s)
* @event backend_photo
* @return array[string][string]string $return[%plugin_id%]['bottom'] In bottom, under photo any widget
*/
$hooks['backend_photo'] = wa()->event('backend_photo', $photo_id);
$this->response['hooks'] = $hooks;
if ($hash !== null) {
$collection = new photosCollection($hash);
if (strstr($hash, 'rate>0') !== false) {
$collection->orderBy('p.rate DESC, p.id');
}
$this->response['photo_stream'] = $this->getPhotoStream($collection);
if ($collection->getAlbum()) {
$this->response['album'] = $collection->getAlbum();
}
}
}
