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);
 }
Beispiel #4
0
 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>
Beispiel #9
0
//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);
 }