function viewAction()
{
$tblPolling = new App_Model_Db_Table_Poll();
$tblOption = new App_Model_Db_Table_PollOption();
$time = time();
$date = date("Y-m-d H:i:s", $time);
$rowPoll = $tblPolling->fetchRow("checkedTime < '{$date}'", "checkedTime DESC");
$this->view->rowPoll = $rowPoll;
$rowOpt = $tblOption->fetchAll("pollGuid='{$rowPoll->guid}'", "text ASC");
$this->view->rowOpt = $rowOpt;
}
public function editAction()
{
$this->_helper->layout->setLayout('layout-newpolling');
$this->preProcessSession();
$request = $this->getRequest();
$questionId = $request->getParam('pollid');
$pollingDb = new App_Model_Db_Table_Poll();
$pollingOptionDb = new App_Model_Db_Table_PollOption();
$question = $pollingDb->find($questionId)->current();
$answers = $pollingOptionDb->fetchAll("pollGuid='{$questionId}'");
$this->view->assign('question', $question);
$this->view->assign('answers', $answers);
if ($request->isPost()) {
$title = $request->getPost('title');
$answers = $request->getPost('answers');
$purifier = new HTMLPurifier();
$question->title = $purifier->purify($title);
$question->save();
if ($answers != null && $questionId != null) {
$pollingOptionDb->delete(['pollGuid=?' => $questionId]);
for ($i = 0; $i < count($answers); $i++) {
if (empty($answers[$i])) {
continue;
}
$dataNewRow = $pollingOptionDb->fetchNew();
$dataNewRow->pollGuid = $questionId;
$dataNewRow->text = $purifier->purify($answers[$i]);
$dataNewRow->hits = 0;
$dataNewRow->save();
}
}
$this->_helper->getHelper('FlashMessenger')->addMessage('The poll has been updated successfully.');
$this->_redirect($this->view->serverUrl() . '/' . $this->view->getLanguage() . '/polling/manager/list');
}
}
