public function updateAction()
{
try {
//Get the comment first...
$_comment = $this->_commentsTable->findById($this->_getParam("commentId"));
if ($_comment === null) {
throw new Exception("No comment is found");
}
//Update the status of the comment...
$_do = $this->getRequest()->getParam("do");
switch ($_do) {
case "approve":
$_comment->approved_at = date("d.m.Y H:i:s");
break;
case "reject":
$_comment->approved_at = null;
break;
case "delete":
$_comment->deleted_at = date("d.m.Y H:i:s");
break;
case "restore":
$_comment->deleted_at = null;
break;
default:
throw new Exception("Invalid Action");
}
$_affectedRows = $_comment->save();
if ($_affectedRows < 1) {
throw new Exception("Failed to save the comment");
}
} catch (Exception $_e) {
$this->view->error = $_e->getMessage();
}
}
