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);
}
}
}
