public function fetchItemReview($itemid) { try { $db = $this->getDbTable(); $select = $db->select()->where('iritemid_fk_miid =?', $itemid)->order('ircreateddateandtime DESC'); $itemreviewdata = $select->query()->fetchAll(); $reviewdata = array(); $cusmapper = new User_Model_CustomerMapper(); foreach ($itemreviewdata as $record) { $cusdata = $cusmapper->getcusdata($record['iruserid_fk_userid']); $customer_name = ""; if (is_array($cusdata)) { if (array_key_exists(0, $cusdata)) { $customer_name = $cusdata[0]['cusfirst_name']; } else { $customer_name = "User"; } } else { $customer_name = "User"; } $reviewdata[] = array("irid" => $record['irid'], "ir_reviewdate" => $record['ircreateddate'], "userid" => $record['iruserid_fk_userid'], "review" => $record['ir_review_text'], "rating" => $record['ir_review_rating'], "cusname" => $customer_name); } return $reviewdata; } catch (Exception $e) { throw new Exception($e->getMessage()); } }
public function dashboardAction() { try { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $_resservice = new Application_Service_Restaurant(); $storage = new Zend_Auth_Storage_Session(); $userArr = $storage->read(); $userid = $userArr['User_Id']; $cusmapper = new User_Model_CustomerMapper($userid); $cusname = $cusmapper->getcusdata($userid); $this->view->cusname = $cusname; $this->view->userid = $userid; $this->view->isLoggedin = true; $shortlisted = $_resservice->showshortlist($userid, $this->view->baseUrl()); $this->view->shortlist = $shortlisted; $likedres = $_resservice->showlikedreslist($userid, $this->view->baseUrl()); $this->view->likedreslist = $likedres; $resreviews = array(); $resreviews = $_resservice->resReviewsByUserid($userid, $this->view->baseUrl()); $this->view->resreviews = $resreviews; $itemreviews = $_resservice->itemReviewsByUserid($userid, $this->view->baseUrl()); //print_r($itemreviews);die(); $this->view->itemreviews = $itemreviews; $cusname = $_resservice->usernameByUserid($userid); $this->view->cusname = $cusname; } else { } } catch (Exception $e) { throw new Exception($e->getMessage()); } }
public function itemreviewfetch($request) { try { $itemid = $request->getPost('itemid'); $resid = $request->getPost('resid'); $itemReviewMapper = new Restaurant_Model_ItemReviewMapper(); $itemreviewdata = $itemReviewMapper->fetchItemReview($itemid, $resid); $cusmapper = new User_Model_CustomerMapper(); foreach ($itemreviewdata as $itemdata) { $itemreviewdata[0]['cusname'] = $cusmapper->getcusdata($itemdata['userid']); } return $itemreviewdata; } catch (Exception $ex) { Rdine_Logger_FileLogger::info($ex->getMessage()); throw new Exception($ex->getMessage()); } }