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