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