public function usersearch($data = Null) { $inputs = Input::get(); $groupmemberid = groupmemberModel::where('group_id', $data)->get()->lists('user_id'); $groupmemberuserid = ProfileModel::whereNotIn('user.ID', $groupmemberid)->lists('ID'); $searcheduser = Input::get('usersearch'); $groupmemberuseridlist = ProfileModel::select('profilepicture', 'firstname', 'lastname', 'username', 'ID')->where('username', 'like', '%' . $searcheduser . '%')->whereIn('user.ID', $groupmemberuserid)->Orwhere('firstname', 'like', '%' . $searcheduser . '%')->whereIn('user.ID', $groupmemberuserid)->where('user.status', 1)->get(); return View::make('user/view/registermember')->with('group_id', $data)->with('searcheduser', $searcheduser)->with('savegroupmembers', $groupmemberuseridlist); }
public function searchmember() { $searcheduser = Input::get('searchkey'); $data = Input::get('group_id'); //$userdetails = ProfileModel::where('')->get(); $groupmemberid = groupmemberModel::where('group_id', $data)->get()->lists('user_id'); $groupmemberuserid = ProfileModel::whereNotIn('user.ID', $groupmemberid)->lists('ID'); $userdetails = ProfileModel::select('profilepicture', 'firstname', 'lastname', 'username', 'ID')->where('username', 'like', '%' . $searcheduser . '%')->where('status', 1)->whereIn('user.ID', $groupmemberuserid)->Orwhere('firstname', 'like', '%' . $searcheduser . '%')->whereIn('user.ID', $groupmemberuserid)->get(); //$userdetails=ProfileModel::select('profilepicture','firstname','lastname','username','ID')->where('username','like','%'.$searchkey.'%')->where('status',1)->Orwhere('firstname','like','%'.$searchkey.'%')->get(); for ($i = 0; $i < count($userdetails); $i++) { if ($userdetails[$i]['profilepicture'] != '') { $userdetails[$i]['profilepicture'] = url() . '/public/assets/upload/profile/' . $userdetails[$i]['profilepicture']; } if ($userdetails[$i]['firstname'] != '') { $userdetails[$i]['name'] = $userdetails[$i]['firstname'] . ' ' . $userdetails[$i]['lastname']; } else { $userdetails[$i]['name'] = $userdetails[$i]['username']; } } if (count($userdetails) > 0) { $Response = array('success' => '1', 'message' => 'User details fetched successfully', 'msgcode' => "c188"); $final = array("response" => $Response, "userdetails" => $userdetails); return json_encode($final); } else { $Response = array('success' => '0', 'message' => 'No data avialable', 'msgcode' => "c181"); $final = array("response" => $Response, "userdetails" => $userdetails); return json_encode($final); } }