public function denyAction($id = null)
 {
     $businessUpdates = BusinessUpdates::findFirst($id);
     if (!$businessUpdates) {
         return $this->response->redirect('admin/business');
     }
     $this->view->setVar('businessUpdates', $businessUpdates);
 }
 public function admin_viewAction($id = null)
 {
     $this->view->setTemplateAfter('admin_default');
     $business = Business::findFirst($id);
     if (!$business) {
         return $this->response->redirect('admin/business');
     }
     $this->view->setVar('business', $business);
     $businessUpdates = BusinessUpdates::find(array('business_id="' . $id . '"', "order" => "id DESC"));
     //$businessCategoryLists = BusinessCategoryListUpdates::find('business_update_id = "'.$businessUpdates->id.'"');
     $this->view->setVar('businessUpdates', $businessUpdates);
     //$this->view->setVar('businessCategoryLists', $businessCategoryLists);
 }
 public function update_businessAction($businessId = null)
 {
     $business = Business::findFirst($businessId);
     if (!$business) {
         return $this->response->redirect('review/search_business');
     }
     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'];
         $businessUpdate = new BusinessUpdates();
         $businessUpdate->created = date('Y-m-d H:i:s');
         $businessUpdate->modified = date('Y-m-d H:i:s');
         $businessUpdate->member_id = $userSession['id'];
         $businessUpdate->business_id = $businessId;
         $businessUpdate->name = $this->request->getPost('name');
         $businessUpdate->website = $this->request->getPost('website');
         $businessUpdate->telephone = $this->request->getPost('telephone');
         $businessUpdate->street = $this->request->getPost('street');
         $businessUpdate->city = $this->request->getPost('city');
         $businessUpdate->country_id = $this->request->getPost('country_id');
         $businessUpdate->lat = $lat;
         $businessUpdate->lng = $lng;
         $businessUpdate->status = 'Pending';
         if (!empty($this->request->getPost('review'))) {
             $businessUpdate->total_review = 1;
         }
         $opened = '';
         if (!empty($this->request->getPost('opened'))) {
             $opened = 'Opened';
         }
         if (empty($this->request->getPost('opened'))) {
             $opened = 'Opening Soon';
         }
         $businessUpdate->opened = $opened;
         if ($businessUpdate->create()) {
             $id = $businessUpdate->id;
             if (!empty($this->request->getPost('business_category_ids'))) {
                 $bCtegories = $this->request->getPost('business_category_ids');
                 $bCtegoryIds = explode(',', $bCtegories);
                 foreach ($bCtegoryIds as $key => $bCtegoryId) {
                     $businessCategoryLists = new BusinessCategoryListUpdates();
                     $businessCategoryLists->created = date('Y-m-d H:i:s');
                     $businessCategoryLists->business_update_id = $id;
                     $businessCategoryLists->business_category_id = $bCtegoryId;
                     $businessCategoryLists->create();
                 }
             }
             $this->flash->success('<button type="button" class="close" data-dismiss="alert">×</button>Business upates has been submitted');
             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);
 }