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