public function members($id) { $selected_users = DB::select("select * from users join user_has_designation on users.id = user_has_designation.users_id where user_has_designation.designation_id = {$id}"); $notselected_users = DB::select("select * from users where id not in ( select users_id from user_has_designation where designation_id = {$id}) and confirmed = 1"); //Block URL access for non existing designation $existence = Designation::where('id', $id)->get(); $exist = 0; foreach ($existence as $designate) { $exist = $exist + 1; } if ($exist == 0) { return Redirect::to('/designation'); } else { return View::make('designation_members')->with('designation_id', $id)->with('notselected_users', $notselected_users)->with('selected_users', $selected_users); } }
/** * Show the form for creating a new resource. * * @return Response */ public function create() { if (!Auth::guest()) { $user = User::where('priviledge', '!=', 'superuser')->get(); $user_designation = Designation::where('id', '=', Auth::user()->id)->pluck('designation'); $user_votes = Vote::where('user_id', '=', Auth::user()->id)->get(); $count = count($user_votes); $i = 0; foreach ($user_votes as $user_vote) { $user_name[$i] = user::where('id', '=', $user_vote->login_id)->pluck('user_name'); $i++; } //var_dump($user_name);die; $weights = Vote::where('user_id', '=', Auth::id())->sum('performance'); $sum = $weights; $name = priviledge::where('user_id', '=', Auth::user()->id)->pluck('name_show'); $path = file::where('user_id', '=', Auth::user()->id)->pluck('path'); $authority = Priviledge::all(); return View::make('votes.profile', compact('authority', 'path', 'user_designation', 'user_votes', 'sum', 'user', 'name', 'user_name')); } else { return Redirect::intended('login'); } }
public function ajax_designation() { if (Request::ajax()) { $input = Input::get('deptID'); $designation = Designation::where('deptID', '=', $input)->get(); return Response::json($designation, 200); } }