public function manageUsers() { $adminId = Session::get('admin_id'); if (!isset($adminId)) { return Redirect::to('/'); } $institutes = Institute::where('status', 'active')->orderBy('name')->get(); if (isset($institutes) && count($institutes) > 0) { return View::make('admin.users')->with('institutesFound', true)->with('institutes', $institutes); } else { return View::make('admin.users')->with('institutesFound', false); } }
public function listInstitutes($status, $page) { $adminId = Session::get('admin_id'); if (!isset($adminId)) { return json_encode(array('message' => 'not logged')); } if (isset($status)) { $institutes = Institute::where('status', '=', $status)->with('location')->get(); if (isset($institutes) && count($institutes) > 0) { return json_encode(array('message' => 'found', 'institutes' => $institutes->toArray())); } else { return json_encode(array('message' => 'empty')); } } else { return json_encode(array('message' => 'invalid')); } }
public function getConnections($status = 'active', $page = 1) { $adminId = Session::get('admin_id'); if (!isset($adminId)) { return json_encode(array('message' => 'not logged')); } $connections = InstituteConnection::where('status', $status)->get(); if (isset($connections) && count($connections) > 0) { $connectionArray = array(); foreach ($connections as $connection) { $connectionFrom = Institute::where('id', $connection->connection_id)->first(); $connectionTo = Institute::where('id', $connection->institute_id)->first(); if (isset($connectionFrom) && isset($connectionTo)) { $connectionArray[] = array('id' => $connection->id, 'connection_from' => $connectionFrom->name, 'connection_from_location' => $connectionFrom->city . ', ' . $connectionFrom->country, 'connection_to' => $connectionTo->name, 'connection_to_location' => $connectionTo->city . ', ' . $connectionTo->country); } } return json_encode(array('message' => 'found', 'connections' => $connectionArray)); } else { return json_encode(array('message' => 'empty')); } }
public function institutes() { $key = Input::get('keyword'); $city = Input::get('city'); $cityId = Input::get('c'); // city id if (isset($key)) { if (isset($cityId) && strlen($cityId) > 0) { $institutes = Institute::where('name', 'like', '%' . $key . '%')->where('location_id', '=', $cityId)->with('location')->get(); } else { $institutes = Institute::where('name', 'like', '%' . $key . '%')->with('location')->get(); } $city = str_replace("-", " / ", $city); if (isset($institutes) && count($institutes) > 0) { return View::make('institute.institutes')->with('institutes', $institutes)->with('city', $city)->with('status', 'search'); } else { return View::make('institute.institutes')->with('city', $city)->with('status', 'search'); } } else { return View::make('institute.institutes')->with('city', '')->with('status', 'direct'); } }
public function searchByKeyword($key, $cityId = null) { if (isset($key)) { if (isset($cityId)) { $experts = Expert::where('first_name', 'like', '%' . $key . '%')->Orwhere('last_name', 'like', '%' . $key . '%')->where('status', '=', 'active')->get(); $institutes = Institute::where('name', 'like', '%' . $key . '%')->where('status', '=', 'active')->get(); } else { $experts = Expert::where('first_name', 'like', '%' . $key . '%')->Orwhere('last_name', 'like', '%' . $key . '%')->where('status', '=', 'active')->get(); $institutes = Institute::where('name', 'like', '%' . $key . '%')->where('status', '=', 'active')->get(); } $data = array(); if (isset($experts) && count($experts) > 0) { foreach ($experts as $expert) { $data[] = array('id' => $expert->id, 'name' => $expert->first_name . ' ' . $expert->last_name, 'group' => 'Experts'); } } if (isset($institutes) && count($institutes) > 0) { foreach ($institutes as $institute) { $data[] = array('id' => $institute->id, 'name' => $institute->name, 'group' => 'Institutes'); } } if (isset($data) && count($data) > 0) { return json_encode(array('message' => 'found', 'data' => $data)); } else { return json_encode(array('message' => 'empty')); } } else { return json_encode(array('message' => 'invalid')); } }