public function loadMedia($id = null, $identifier = null) { try { $stmt = Zend_Registry::get('dbh')->proc('get_media'); $stmt->bindParam(':id', $id, PDO::PARAM_INT); $stmt->bindParam(':identifier', $identifier, PDO::PARAM_STR); $stmt->execute(); $media = $stmt->fetch(PDO::FETCH_OBJ); $stmt->closeCursor(); } catch (Zend_Db_Statement_Exception $e) { die(__LINE__ . ':' . __FILE__ . ':' . $e->getMessage()); } $category = Zend_Controller_Action_HelperBroker::getStaticHelper('Category'); $status = Zend_Controller_Action_HelperBroker::getStaticHelper('Status'); $media->category = $category->getCategory($media->id); $media->status = $status->getStatus($media->status); $media = Showcase_Media::factory($media); //print_r($media); die; return $media; }
public function loadDocuments() { $id = $this->_id; if (!$id) { return false; } try { $stmt = Zend_Registry::get('dbh')->proc('load_media_documents'); $stmt->bindParam(':id', $id, PDO::PARAM_INT); $stmt->execute(); $results = $stmt->fetchAll(PDO::FETCH_OBJ); $stmt->closeCursor(); } catch (Zend_Db_Statement_Exception $e) { die(__LINE__ . ':' . __FILE__ . ':' . $e->getMessage()); } if ($results) { if (!is_array($this->_documents)) { $this->_documents = array(); } foreach ($results as $result) { $doc = array(strtoupper($result->filetype_name) => Showcase_Media::factory($result)); $this->_documents = array_merge($this->_documents, $doc); unset($doc); } } }