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