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);
}
