public function search_businessAction()
{
if ($this->request->isPost()) {
$businessName = $this->request->getPost('name');
$businessAddress = $this->request->getPost('address');
$country = Countries::findFirst(array('columns' => '*', 'conditions' => 'country LIKE :country:', 'bind' => array('country' => $businessAddress)));
$countryId = '';
if ($country) {
$countryId = $country->id;
}
if (!empty($businessName) && !empty($businessAddress) && !empty($countryId)) {
$business = Business::find(array('columns' => '*', 'conditions' => 'name LIKE :name: OR street LIKE :street: OR city LIKE :city: OR country_id = :country_id:', 'bind' => array('name' => '%' . $businessName . '%', 'street' => '%' . $businessAddress . '%', 'city' => '%' . $businessAddress . '%', 'country_id' => $countryId)));
}
if (!empty($businessName) && empty($businessAddress)) {
$business = Business::find(array('columns' => '*', 'conditions' => 'name LIKE :name: OR street LIKE :street: OR city LIKE :city:', 'bind' => array('name' => '%' . $businessName . '%', 'street' => '%' . $businessName . '%', 'city' => '%' . $businessName . '%')));
}
if (empty($businessName) && !empty($businessAddress) && !empty($countryId)) {
$business = Business::find(array('columns' => '*', 'conditions' => 'name LIKE :name: OR street LIKE :street: OR city LIKE :city: OR country_id = :country_id:', 'bind' => array('name' => '%' . $businessAddress . '%', 'street' => '%' . $businessAddress . '%', 'city' => '%' . $businessAddress . '%', 'country_id' => $countryId)));
}
if (empty($businessName) && !empty($businessAddress) && empty($countryId)) {
$business = Business::find(array('columns' => '*', 'conditions' => 'name LIKE :name: OR street LIKE :street: OR city LIKE :city:', 'bind' => array('name' => '%' . $businessAddress . '%', 'street' => '%' . $businessAddress . '%', 'city' => '%' . $businessAddress . '%')));
}
$this->view->setVar('business', $business);
} else {
$business = Business::find();
}
$this->view->setVar('business', $business);
}
public function getBusiness($id)
{
$business = Business::find($id);
if ($business == null) {
return Error::make("No Business Found");
} else {
return Error::success("Business found", $business->toArray());
}
}
public function indexAction()
{
$searchWords = '';
$business = array();
if (isset($_GET["page"])) {
$currentPage = (int) $_GET["page"];
} else {
$currentPage = 1;
}
if ($this->request->isPost()) {
$businessName = $this->request->getPost('name');
$businessAddress = $this->request->getPost('address');
$businessCategoryId = $this->request->getPost('business_category_id');
$businessCategory = BusinessCategories::findFirst($businessCategoryId);
$country = Countries::findFirst(array('columns' => '*', 'conditions' => 'country LIKE :country:', 'bind' => array('country' => $businessAddress)));
$countryId = '';
if ($country) {
$countryId = $country->id;
}
$conditions = '';
$bind = array();
if (!empty($businessName)) {
$conditions .= ' OR name LIKE :name:';
$bind['name'] = '%' . $businessName . '%';
$searchWords .= ', ' . $businessName;
}
if (!empty($businessAddress)) {
$conditions .= ' OR street LIKE :street:';
$bind['street'] = '%' . $businessAddress . '%';
$conditions .= ' OR city LIKE :city:';
$bind['city'] = '%' . $businessAddress . '%';
$searchWords .= ', ' . $businessAddress;
}
if (!empty($countryId)) {
$conditions .= ' OR country_id LIKE :country_id:';
$bind['country_id'] = $countryId;
$searchWords .= ', ' . $country->country;
}
if (!empty($businessCategoryId)) {
$conditions .= ' OR business_category_id = :business_category_id:';
$bind['business_category_id'] = $businessCategoryId;
$searchWords .= ', ' . $businessCategory->name;
}
$business = Business::find(array('columns' => '*', 'conditions' => substr($conditions, 3), 'bind' => $bind));
} else {
$realties = Realties::find();
}
// Create a Model paginator, show 10 rows by page starting from $currentPage
$paginator = new \Phalcon\Paginator\Adapter\Model(array("data" => $realties, "limit" => 10, "page" => $currentPage));
$page = $paginator->getPaginate();
$this->view->setVar('searchWords', $searchWords);
$this->view->setVar('realties', $page);
$realtyCategories = RealtyCategories::find();
$this->view->setVar('realtyCategories', $realtyCategories);
}
public function business_searchAction()
{
$searchWords = '';
$business = array();
if (isset($_GET["page"])) {
$currentPage = (int) $_GET["page"];
} else {
$currentPage = 1;
}
if ($this->request->isPost()) {
$businessName = $this->request->getPost('name');
$businessAddress = $this->request->getPost('address');
$businessCategoryId = $this->request->getPost('business_category_id');
$country = Countries::findFirst(array('columns' => '*', 'conditions' => 'country LIKE :country:', 'bind' => array('country' => $businessAddress)));
$countryId = '';
if ($country) {
$countryId = $country->id;
}
$businessCategoryLists = BusinessCategoryLists::find(array('columns' => '*', 'conditions' => 'business_category_id = :business_category_id:', 'bind' => array('business_category_id' => $businessCategoryId)));
$conditions = '';
if (!empty($businessCategoryLists)) {
foreach ($businessCategoryLists as $key => $businessCategoryList) {
$conditions .= ' OR id = :' . $key . ':';
$bind[$key] = $businessCategoryList->business_id;
}
//$searchWords .= ', '.$businessName;
}
if (!empty($businessName)) {
$conditions .= ' OR name LIKE :name:';
$bind['name'] = '%' . $businessName . '%';
$searchWords .= ', ' . $businessName;
}
if (!empty($businessAddress)) {
$conditions .= ' OR street LIKE :street: OR city LIKE :city:';
$bind['street'] = '%' . $businessAddress . '%';
$bind['city'] = '%' . $businessAddress . '%';
$searchWords .= ', ' . $businessAddress;
}
if (!empty($countryId)) {
$conditions .= ' OR country_id = :country_id:';
$bind['country_id'] = $countryId;
$searchWords .= ', ' . $country->country;
}
$searchWords = substr($searchWords, 2);
$business = Business::find(array('columns' => '*', 'conditions' => substr($conditions, 3), 'bind' => $bind));
$this->view->setVar('business', $business);
} else {
$business = Business::find(array('order' => 'id DESC'));
}
$paginator = new \Phalcon\Paginator\Adapter\Model(array("data" => $business, "limit" => 12, "page" => $currentPage));
$page = $paginator->getPaginate();
$this->view->setVar('business', $page);
//$this->view->setVar('business', $business);
$businessCategories = BusinessCategories::find();
$this->view->setVar('businessCategories', $businessCategories);
}
public function admin_pendingAction()
{
$this->view->setTemplateAfter('admin_default');
$business = Business::find('status="Pending"');
$this->view->setVar('business', $business);
}
public function postEditBusiness()
{
$business_data = Input::all();
if (Helper::isBusinessOwner($business_data['business_id'], Helper::userId())) {
// PAG added permission checking
$business = Business::find($business_data['business_id']);
if ($this->validateBusinessNameBusinessAddress($business, $business_data)) {
$business->name = $business_data['business_name'];
$business->local_address = $business_data['business_address'];
$business->industry = $business_data['industry'];
$business->fb_url = $business_data['facebook_url'];
$business->timezone = $business_data['timezone'];
//ARA Added timezone property
$time_open_arr = Helper::parseTime($business_data['time_open']);
$business->open_hour = $time_open_arr['hour'];
$business->open_minute = $time_open_arr['min'];
$business->open_ampm = $time_open_arr['ampm'];
$time_close_arr = Helper::parseTime($business_data['time_close']);
$business->close_hour = $time_close_arr['hour'];
$business->close_minute = $time_close_arr['min'];
$business->close_ampm = $time_close_arr['ampm'];
$business->queue_limit = $business_data['queue_limit'];
/* RDH Added queue_limit to Edit Business Page */
$business->save();
//ARA For queue settings terminal-specific numbers
$queue_settings = new QueueSettingsController();
$queue_settings->getUpdate($business['business_id'], 'number_limit', $business_data['queue_limit']);
$queue_settings->getUpdate($business['business_id'], 'terminal_specific_issue', $business_data['terminal_specific_issue']);
$queue_settings->getUpdate($business['business_id'], 'sms_current_number', $business_data['sms_current_number']);
$queue_settings->getUpdate($business['business_id'], 'sms_1_ahead', $business_data['sms_1_ahead']);
$queue_settings->getUpdate($business['business_id'], 'sms_5_ahead', $business_data['sms_5_ahead']);
$queue_settings->getUpdate($business['business_id'], 'sms_10_ahead', $business_data['sms_10_ahead']);
$queue_settings->getUpdate($business['business_id'], 'sms_blank_ahead', $business_data['sms_blank_ahead']);
$queue_settings->getUpdate($business['business_id'], 'input_sms_field', $business_data['input_sms_field']);
$queue_settings->getUpdate($business['business_id'], 'allow_remote', $business_data['allow_remote']);
$queue_settings->getUpdate($business['business_id'], 'remote_limit', $business_data['remote_limit']);
//sms settings
$sms_api_data = [];
$sms_gateway_api = NULL;
if ($business_data['sms_gateway'] == 'frontline_sms') {
$sms_api_data = ['frontline_sms_url' => $business_data['frontline_sms_url'], 'frontline_sms_api_key' => $business_data['frontline_sms_api_key']];
$sms_gateway_api = serialize($sms_api_data);
} elseif ($business_data['sms_gateway'] == 'twilio') {
if ($business_data['twilio_account_sid'] == TWILIO_ACCOUNT_SID && $business_data['twilio_auth_token'] == TWILIO_AUTH_TOKEN && $business_data['twilio_phone_number'] == TWILIO_PHONE_NUMBER) {
$business_data['sms_gateway'] = NULL;
$sms_gateway_api = NULL;
} else {
$sms_api_data = ['twilio_account_sid' => $business_data['twilio_account_sid'], 'twilio_auth_token' => $business_data['twilio_auth_token'], 'twilio_phone_number' => $business_data['twilio_phone_number']];
$sms_gateway_api = serialize($sms_api_data);
}
}
$queue_settings->getUpdate($business['business_id'], 'sms_gateway', $business_data['sms_gateway']);
$queue_settings->getUpdate($business['business_id'], 'sms_gateway_api', $sms_gateway_api);
$business = Business::getBusinessDetails($business->business_id);
return json_encode(['success' => 1, 'business' => $business]);
} else {
return json_encode(['success' => 0, 'error' => 'Business name already exists with the same business address.']);
}
} else {
return json_encode(['success' => 0, 'error' => 'You are not allowed to access this function.']);
}
}
public function admin_indexAction()
{
$this->view->setTemplateAfter('admin_default');
$business = Business::find();
$this->view->setVar('business', $business);
}
</a>
</li>
@if(Auth::check())
<?php
$data = array("first_name" => "User");
$id = Auth::user()->id;
switch (Auth::user()->type) {
case 'driver':
$data = Driver::find($id)->toArray();
break;
case 'customer':
$data = Customer::find($id)->toArray();
break;
case 'business':
$data = Business::find($id)->toArray();
break;
}
?>
<li><!-- HOME -->
<a href="{{URL::Route('edit')}}">
Edit
</a>
</li>
<li class="dropdown">
<a class="dropdown-toggle" href="#">
Hi! {{$data["first_name"]}}
</a>
<ul class="dropdown-menu">
<li><a href="{{URL::Route('logout')}}">Logout</a></li>
//add a new business to businesses from business home
$app->post("/businesshome", function () use($app) {
$business_name = $_POST['business_name'];
$business_phone = $_POST['business_phone'];
$business_contact = $_POST['business_contact'];
$business_website = $_POST['business_website'];
$business_address = $_POST['business_address'];
$business_contact_email = $_POST['business_contact_email'];
$business = new Business($business_name, $business_phone, $business_contact, $business_website, $business_address, $business_contact_email, $id = null);
$business->save();
return $app['twig']->render('businesshome.html.twig', array('businesses' => Business::getAll()));
});
//specific business viewing page to be viewed by the user.
//(NEED TO FINALIZE ARRAY!!!)
$app->get("/business/{id}", function ($id) use($app) {
$business = Business::find($id);
return $app['twig']->render('business.html.twig', array('business' => $business, 'all_activities' => Activity::getAll()));
});
//Path to update business info --- NOT FINISHED AND NEEDS PROPER THINGS!
$app->get("/updatebusiness/{id}", function () use($app) {
return $app['twig']->render('updatebusiness.html.twig', array('business' => $business));
});
//path to userhome for viewing current users and adding new
$app->get("/userhome", function () use($app) {
return $app['twig']->render('userhome.html.twig', array('users' => User::getAll()));
});
//path to specific users account info and activity info
$app->get("/updateuser/{id}", function () use($app) {
return $app['twig']->render('updateuser.html.twig', array('user' => $user));
});
//Update user info
function testFind()
{
//Arrange
$business_name = "IBM";
$business_phone = "5033133131";
$business_contact = "john";
$business_website = "walkins.com";
$business_address = "123 fake st";
$business_contact_email = "*****@*****.**";
$id = 1;
$test_business = new Business($business_name, $business_phone, $business_contact, $business_website, $business_address, $business_contact_email, $id);
$test_business->save();
$business_name2 = "Smoke Signals";
$business_phone2 = "5033139999";
$business_contact2 = "Theo";
$business_website2 = "Signal.com";
$business_address2 = "123 getreal st";
$business_contact_email2 = "*****@*****.**";
$id2 = 2;
$test_business2 = new Business($business_name2, $business_phone2, $business_contact2, $business_website2, $business_address2, $business_contact_email2, $id2);
$test_business2->save();
//Act
$result = Business::find($test_business->getId());
//Assert
$this->assertEquals($test_business, $result);
}
public function searchAction()
{
$keyword = $this->request->get("find");
$location = $this->request->get("near");
$searchWords = '';
$this->view->setVar('find', $keyword);
$this->view->setVar('near', $near);
$country = Countries::findFirst(array('columns' => '*', 'conditions' => 'country LIKE :country:', 'bind' => array('country' => $location)));
$countryId = '';
if ($country) {
$countryId = $country->id;
}
$conditions = '';
if (!empty($keyword)) {
$conditions .= ' OR name LIKE :name:';
$bind['name'] = '%' . $keyword . '%';
$searchWords .= ', ' . $keyword;
}
if (!empty($location)) {
$conditions .= ' OR street LIKE :street: OR city LIKE :city:';
$bind['street'] = '%' . $location . '%';
$bind['city'] = '%' . $location . '%';
$searchWords .= ', ' . $location;
}
if (!empty($countryId)) {
$conditions .= ' OR country_id = :country_id:';
$bind['country_id'] = $countryId;
$searchWords .= ', ' . $country->country;
}
$searchWords = substr($searchWords, 2);
$business = Business::find(array('columns' => '*', 'conditions' => substr($conditions, 3), 'bind' => $bind));
$this->view->setVar('business', $business);
//CARS and TRUCKS
$conditions = '';
$bind = array();
if (!empty($keyword)) {
$conditions = ' OR name LIKE :name:';
$bind['name'] = '%' . $keyword . '%';
}
if (!empty($keyword)) {
$conditions .= ' OR brand LIKE :brand:';
$bind['brand'] = '%' . $keyword . '%';
}
if (!empty($keyword)) {
$conditions .= ' OR model LIKE :model:';
$bind['model'] = '%' . $keyword . '%';
}
if (!empty($location)) {
$conditions .= ' OR location LIKE :location:';
$bind['location'] = $location;
}
$autos = Automotives::find(['columns' => '*', 'conditions' => substr($conditions, 3), 'bind' => $bind]);
$this->view->setVar('autos', $autos);
$conditions = '';
$bind = array();
if (!empty($keyword)) {
$conditions = 'name LIKE :name:';
$bind['name'] = '%' . $keyword . '%';
}
$things = Things::find(['columns' => '*', 'conditions' => $conditions, 'bind' => $bind]);
$this->view->setVar('things', $things);
//JOBS
$conditions = '';
$bind = array();
if (!empty($keyword)) {
$conditions .= ' OR position LIKE :position:';
$bind['position'] = '%' . $keyword . '%';
$searchWords .= ', ' . $keyword;
}
if (!empty($keyword)) {
$conditions .= ' OR company LIKE :company:';
$bind['company'] = '%' . $keyword . '%';
$searchWords .= ', ' . $keyword;
}
if (!empty($location)) {
$conditions .= ' OR street LIKE :street:';
$bind['street'] = '%' . $location . '%';
$conditions .= ' OR city LIKE :city:';
$bind['city'] = '%' . $location . '%';
$searchWords .= ', ' . $location;
}
if (!empty($countryId)) {
$conditions .= ' OR country_id LIKE :country_id:';
$bind['country_id'] = $countryId;
$searchWords .= ', ' . $country->country;
}
$jobs = Jobs::find(array('columns' => '*', 'conditions' => substr($conditions, 3), 'bind' => $bind));
$this->view->setVar('jobs', $jobs);
}
/**
* Display the specified product.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$business = Business::find($id);
return Response::json($business);
}
/**
* @author Ruffy
* @param $id BusinessI ID of the selected business
* @return JSON object generated through businessId according to the database
*/
public function getBusinessDetail($id)
{
$search = Business::find($id);
return Response::json($search, 200, array(), JSON_PRETTY_PRINT);
}
public function api_edit($id)
{
$user = User::find($id);
if (is_null($user)) {
return Error::make("Invalid User");
}
$this->edit_help($user);
$data = array();
switch (Input::get('type')) {
case 'driver':
$data = Driver::find($id)->toArray();
break;
case 'customer':
$data = Customer::find($id)->toArray();
break;
case 'business':
$data = Business::find($id)->toArray();
break;
}
return Error::success("User Data", $data);
}
