public function editAction()
{
$this->view->title = "Edit review";
$this->view->headTitle($this->view->title, 'PREPEND');
$form = new Form_Review();
$form->submit->setLabel('Save');
$this->view->form = $form;
if ($this->getRequest()->isPost()) {
$formData = $this->getRequest()->getPost();
if ($form->isValid($formData)) {
$id = (int) $form->getValue('id');
$userID = (int) $form->getValue('user_id');
$dishID = (int) $form->getValue('dish_id');
$rating = $form->getValue('rating');
$comments = $form->getValue('comments');
$reviews = new Model_DbTable_Reviews();
$reviews->updateReview($id, $userID, $dishID, $rating, $comments);
$this->_redirect('/review');
} else {
$form->populate($formData);
}
} else {
$id = $this->_getParam('id', 0);
if ($id > 0) {
$reviews = new Model_DbTable_Reviews();
$form->populate($reviews->getReview($id));
$thisReview = $reviews->getReview($id);
$ratVal = $thisReview['rating'];
$rating = 0;
if ($ratVal == 1 ? $rating = 'pos' : ($rating = 'neg')) {
}
$form->getElement('rating')->setValue($rating);
}
}
}
public function addreviewAction()
{
global $mySession;
$db = new Db();
$myform = new Form_Review();
if ($this->getRequest()->isPost()) {
$request = $this->getRequest();
if ($myform->isValid($request->getPost())) {
$dataForm = $myform->getValues();
$myObj = new Review();
$Result = $myObj->saveReview($dataForm);
if ($Result > 0) {
$mySession->sucessMsg = "Review Added Sucessfully";
} else {
$mySession->errorMsg = "Enter proper Property Code";
}
} else {
$mySession->errorMsg = "Enter proper details first";
}
}
$this->view->myform = $myform;
}
public function updatereviewAction()
{
global $mySession;
$db = new Db();
$reviewId = $this->getRequest()->getParam('reviewId');
$this->view->reviewId = $reviewId;
$this->view->pageHeading = "Edit Review";
if ($this->getRequest()->isPost()) {
$request = $this->getRequest();
$myform = new Form_Review($reviewId);
if ($myform->isValid($request->getPost())) {
$dataForm = $myform->getValues();
$myObj = new Review();
$Result = $myObj->savereview($dataForm, $reviewId);
if ($Result == 1) {
$mySession->sucessMsg = "Review updated successfully.";
$this->_redirect('property/reviews');
} else {
$mySession->errorMsg = "This Review you entered is already exists.";
$this->view->myform = $myform;
$this->render('editreview');
}
} else {
$this->view->myform = $myform;
$this->render('editreview');
}
} else {
$this->_redirect('property/editreview/reviewId/' . $reviewId);
}
}
public function addreviewAction()
{
global $mySession;
$db = new Db();
$myform = new Form_Review();
// $user_id = $mySession->LoggedUserId;
// $propert_codes_arr = "SELECT * FROM " . BOOKING . " as b
// LEFT JOIN `review` as r
// ON b.property_id = r.property_id
// WHERE b.user_id = $user_id AND r.review_id IS NULL";
// $this->view->propertyCodesArr = $propert_codes_arr;
$this->view->myform = $myform;
if ($this->getRequest()->isPost()) {
$request = $this->getRequest();
if ($myform->isValid($request->getPost())) {
$dataForm = $myform->getValues();
$myObj = new Review();
$Result = $myObj->saveReview($dataForm);
if ($Result > 0) {
$mySession->sucessMsg = "Review Added Sucessfully";
} else {
$mySession->errorMsg = "Enter proper Property Code";
}
} else {
$mySession->errorMsg = "Enter proper details first";
}
}
}
