function viewAction()
{
$this->view->title = 'Viewer Details';
$album_id = $this->_request->getParam('album_id', 0);
$template_id = $this->_request->getParam('template_id', 0);
if ($album_id > 0 && $template_id > 0) {
$viewers = new Viewers();
$select = $viewers->select()->setIntegrityCheck(false);
$select->from('viewers')->join('templates', 'templates.id = viewers.template_id', 'name AS template_name')->where('viewers.album_id = ?', $album_id)->where('viewers.template_id = ?', $template_id);
$viewer = $viewers->fetchRow($select);
$this->view->viewer = $viewer;
}
}
public function __construct($options = null)
{
parent::__construct($options);
$album_id = new PP_Form_Element_Hidden('album_id');
$template_id = new PP_Form_Element_Select('template_id');
$template_id->setLabel('Template:');
$templates = new Templates();
$templates = $templates->fetchAll();
$viewers = new Viewers();
foreach ($templates as $template) {
$viewer = $viewers->fetchRow($viewers->select()->where('album_id = ? AND template_id = ?', $options['album_id'], $template->id));
$select = $viewers->select()->where('album_id = ?', $options['album_id'])->where('template_id = ?', $template->id);
$viewer = $viewers->fetchRow($select);
// only present the template as an option if it is not yet added
if (!$viewer) {
$template_id->addMultiOption($template->id, $template->name);
}
}
$submit = new PP_Form_Element_Submit('submit');
$submit->setAttrib('id', 'submitbutton');
$this->addElements(array($album_id, $template_id, $submit));
}
function setBuildTime()
{
$viewer_class = new Viewers();
$select = $viewer_class->select();
$select->where('album_id = ' . $this->album_id)->where('template_id = ' . $this->template_id);
$viewer = $viewer_class->fetchRow($select);
$viewer->built_on = date('Y-m-d h:i:s');
$viewer->save();
}
