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 update_businessAction($businessId = null) { $business = Business::findFirst($businessId); if (!$business) { return $this->response->redirect('biz/business_search'); } if ($this->request->isPost()) { $countryId = $this->request->getPost('country_id'); $country = Countries::findFirst(array('columns' => '*', 'conditions' => 'id LIKE :id:', 'bind' => array('id' => $countryId))); $countryName = ''; if ($country) { $countryName = $country->country; } $address = str_replace(' ', '+', $this->request->getPost('street') . '+' . $this->request->getPost('city') . '+' . $countryName); $userSession = $this->session->get("userSession"); $content = file_get_contents('https://maps.googleapis.com/maps/api/geocode/json?address=' . $address . '&key=AIzaSyAbpLPfBH8sNdVSzMULD_BZN9qrAqbL3V8'); $json = json_decode($content, true); $lat = $json['results'][0]['geometry']['location']['lat']; $lng = $json['results'][0]['geometry']['location']['lng']; $business->modified = date('Y-m-d H:i:s'); $business->member_id = $userSession['id']; $business->name = $this->request->getPost('name'); $business->website = $this->request->getPost('website'); $business->telephone = $this->request->getPost('telephone'); $business->street = $this->request->getPost('street'); $business->city = $this->request->getPost('city'); $business->country_id = $this->request->getPost('country_id'); $business->lat = $lat; $business->lng = $lng; $opened = ''; if (!empty($this->request->getPost('opened'))) { $opened = 'Opened'; } if (empty($this->request->getPost('opened'))) { $opened = 'Opening Soon'; } $business->opened = $opened; if ($business->update()) { if (!empty($this->request->getPost('business_category_ids'))) { $bCtegories = $this->request->getPost('business_category_ids'); $bCtegoryIds = explode(',', $bCtegories); BusinessCategoryLists::find('business_id="' . $businessId . '"')->delete(); foreach ($bCtegoryIds as $key => $bCtegoryId) { $businessCategoryLists = new BusinessCategoryLists(); $businessCategoryLists->created = date('Y-m-d H:i:s'); $businessCategoryLists->business_id = $businessId; $businessCategoryLists->business_category_id = $bCtegoryId; $businessCategoryLists->create(); } } $this->flash->success('<button type="button" class="close" data-dismiss="alert">×</button>Business has been updated'); return $this->response->redirect('business/view/' . $businessId); } } $this->view->setVar('business', $business); $countries = Countries::find(); $this->view->setVar('countries', $countries); $businessCategoryLists = BusinessCategoryLists::find('business_id="' . $businessId . '"'); $this->view->setVar('businessCategoryLists', $businessCategoryLists); }
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); }