public function pageAction($id = null) { $member = Members::findFirstById($id); $this->view->setVar('member', $member); $reviews = Reviews::find(array('member_id = "' . $id . '"', 'order' => 'id DESC')); $this->view->setVar('reviews', $reviews); }
public function biz_pageAction() { $member = Members::findFirstById($id); $this->view->setVar('member', $member); $reviews = Reviews::find(array('member_id = "' . $id . '"', 'order' => 'id DESC')); $this->view->setVar('reviews', $reviews); $claimRequests = ClaimRequests::find(array('member_id = "' . $id . '"', 'order' => 'id DESC')); }
public function pageAction($id = null) { $userSession = $this->session->get('userSession'); $member = Members::findFirstById($id); $this->view->setVar('member', $member); $reviews = Reviews::find(array('member_id = "' . $id . '"', 'order' => 'id DESC')); $this->view->setVar('reviews', $reviews); $claimRequests = ClaimRequests::find(array('member_id = "' . $id . '"', 'order' => 'id DESC')); $this->view->setVar('claimrequest', $claimRequests); }
public function viewAction($id = null) { $business = Business::findFirst($id); if (!$business) { return $this->response->redirect('review/search_business'); } $averageRate = $business->average_rate; $businessCategoryLists = BusinessCategoryLists::find('business_id = "' . $id . '"'); $businessUpdates = BusinessUpdates::findFirst(array('business_id="' . $id . '"', "order" => "id DESC")); if ($businessUpdates) { $business = $businessUpdates; //$businessCategoryLists = BusinessCategoryListUpdates::find('business_update_id = "'.$businessUpdates->id.'"'); $business->id = $id; $business->average_rate = $averageRate; } $this->view->setVar('business', $business); $this->view->setVar('businessCategoryLists', $businessCategoryLists); $query = $this->modelsManager->createQuery("SELECT * from BusinessImages where business_id={$id} and primary_pic='yes'"); //$businessLastImg = $query->execute(); $businessLastImg = BusinessImages::findFirst(array('business_id="' . $id . '" and primary_pic="Yes"')); $businessImgCover = BusinessBackgroundCovers::findFirst(array('business_id="' . $id . '" and primary_pic="Yes"')); //$businessLastImg = BusinessImages::findFirst(array('business_id = "'.$id.'"', "order" => "id DESC")); $this->view->setVar('businessLastImg', $businessLastImg); $businessImages = BusinessImages::find(array('business_id = "' . $id . '"', "order" => "id DESC", "limit" => 7)); $this->view->setVar('businessImages', $businessImages); $reviews = Reviews::find(array('business_id = "' . $id . '"', "order" => "id DESC")); $this->view->setVar('reviews', $reviews); $this->view->setVar('businessImgCover', $businessImgCover); //error_log("WWWWWW ".print_r($businessCategoryLists)); // $this->view->setVar('businessCategoryLists', $businessCategoryLists); // $reviews = Reviews::find('business_id = "'.$id.'"'); // $this->view->setVar('reviews', $reviews); }
public function viewAction($id = null) { $business = Business::findFirst($id); if (!$business) { return $this->response->redirect('review/search_business'); } $averageRate = $business->average_rate; $businessCategoryLists = BusinessCategoryLists::find('business_id = "' . $id . '"'); $businessUpdates = BusinessUpdates::findFirst(array('business_id="' . $id . '"', "order" => "id DESC")); if ($businessUpdates) { $business = $businessUpdates; //$businessCategoryLists = BusinessCategoryListUpdates::find('business_update_id = "'.$businessUpdates->id.'"'); $business->id = $id; $business->average_rate = $averageRate; } $this->view->setVar('business', $business); $this->view->setVar('businessCategoryLists', $businessCategoryLists); $businessLastImg = BusinessImages::findFirst(array('business_id = "' . $id . '"', "order" => "id DESC")); $this->view->setVar('businessLastImg', $businessLastImg); $businessImages = BusinessImages::find(array('business_id = "' . $id . '"', "order" => "id DESC", "limit" => 7)); $this->view->setVar('businessImages', $businessImages); $reviews = Reviews::find(array('business_id = "' . $id . '"', "order" => "id DESC")); $this->view->setVar('reviews', $reviews); //error_log("WWWWWW ".print_r($businessCategoryLists)); // $this->view->setVar('businessCategoryLists', $businessCategoryLists); // $reviews = Reviews::find('business_id = "'.$id.'"'); // $this->view->setVar('reviews', $reviews); }