public function approveAction($id = null) { $this->view->disable(); $businessUpdates = BusinessUpdates::findFirst($id); if (!$businessUpdates) { return $this->response->redirect('admin/business'); } $businessUpdates->status = 'Approved'; if ($businessUpdates->update()) { $business = Business::findFirst($businessUpdates->business_id); if (!empty($businessUpdates->name)) { $business->name = $businessUpdates->name; } if (!empty($businessUpdates->street)) { $business->street = $businessUpdates->street; } if (!empty($businessUpdates->city)) { $business->city = $businessUpdates->city; } if (!empty($businessUpdates->country_id)) { $business->country_id = $businessUpdates->country_id; } if (!empty($businessUpdates->telephone)) { $business->telephone = $businessUpdates->telephone; } if (!empty($businessUpdates->email)) { $business->email = $businessUpdates->email; } if (count($businessUpdates->BusinessCategoryListUpdates)) { //BusinessCategoryLists::find('business_id="'.$business->id.'"')->delete(); foreach ($businessUpdates->BusinessCategoryListUpdates as $key => $businessCategoryListUpdate) { $businessCategoryList = new BusinessCategoryLists(); $businessCategoryList->created = date('Y-m-d H:i:s'); $businessCategoryList->modified = date('Y-m-d H:i:s'); $businessCategoryList->business_id = $business->id; $businessCategoryList->business_category_id = $businessCategoryListUpdate->business_category_id; $businessCategoryList->create(); } } $business->update(); } return $this->response->redirect('admin/business/view/' . $business->id); }
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 new_businessAction() { 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']; //error_log('LAT : '.$lat.' LONG : '.$lng); $validation = new Phalcon\Validation(); $validation->add('name', new PresenceOf(array('message' => 'name field is required is required'))); $validation->add('street', new PresenceOf(array('message' => 'street field is required'))); $validation->add('city', new PresenceOf(array('message' => 'city field is required'))); $validation->add('country_id', new PresenceOf(array('message' => 'country field is required'))); $validation->add('rate', new PresenceOf(array('message' => 'rate field is required'))); $messages = $validation->validate($_POST); if (count($messages)) { $this->view->disable(); $errorMsg = ''; foreach ($messages as $msg) { $errorMsg .= $msg . "<br>"; } $this->flash->error('<button type="button" class="close" data-dismiss="alert">×</button>' . $errorMsg); return $this->response->redirect('review/new_business/'); } else { $this->view->disable(); echo "validation is either failed or passed"; } $business = new Business(); $business->created = date('Y-m-d H:i:s'); $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; $business->average_rate = $this->request->getPost('rate'); if (!empty($this->request->getPost('review'))) { $business->total_review = 1; } $opened = ''; if (!empty($this->request->getPost('opened'))) { $opened = 'Opened'; } if (empty($this->request->getPost('opened'))) { $opened = 'Opening Soon'; } $business->opened = $opened; //$business->business_category_id = $this->request->getPost('business_category_id'); // $business->business_sub_category_id = $this->request->getPost('business_sub_category_id'); // $business->business_asub_category_id = $this->request->getPost('business_asub_category_id'); if ($business->create()) { $id = $business->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 BusinessCategoryLists(); $businessCategoryLists->created = date('Y-m-d H:i:s'); $businessCategoryLists->business_id = $id; $businessCategoryLists->business_category_id = $bCtegoryId; $businessCategoryLists->create(); } } $this->flash->success('<button type="button" class="close" data-dismiss="alert">×</button>New business has been created'); if (!empty($this->request->getPost('review'))) { $review = new Reviews(); $review->created = date('Y-m-d H:i:s'); $review->modified = date('Y-m-d H:i:s'); $review->member_id = $userSession['id']; $review->business_id = $business->id; $review->content = $this->request->getPost('review'); $review->rate = $this->request->getPost('rate'); if ($review->create()) { $this->flash->success('<button type="button" class="close" data-dismiss="alert">×</button>You\'re review has been submitted.'); } } return $this->response->redirect('business/view/' . $id); } } $countries = Countries::find(); $this->view->setVar('countries', $countries); $businessCategories = BusinessCategories::find(); $this->view->setVar('businessCategories', $businessCategories); }