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