public function indexAction() { $this->view->book = $subject = Engine_Api::_()->core()->getSubject(); $this->view->viewer = $viewer = Engine_Api::_()->user()->getViewer(); if ($viewer->isAdmin() || $subject->isBookAuthor($viewer) || $subject->user_id == $viewer->getIdentity()) { $photoTbl = new Book_Model_DbTable_Photos(); $select = $photoTbl->select()->where('parent_object_type = ?', $subject->getType())->where('parent_object_id = ?', $subject->getIdentity()); $this->view->photos = $photos = $photoTbl->fetchAll($select); return; } return $this->setNoRender(); }
public function getAllApprovedPhotos() { $photoTbl = new Book_Model_DbTable_Photos(); $select = $photoTbl->select(); $select->where("parent_object_type = ?", $this->getType())->where("parent_object_id = ?", $this->getIdentity())->where("approved = ?", 1); $select->order('default DESC'); $photos = array(); $storageApi = Engine_Api::_()->storage(); foreach ($photoTbl->fetchAll($select) as $photo) { $file = $storageApi->get($photo->file_id); if (!empty($file)) { array_push($photos, $file->storage_path); } } return $photos; }