/**
Function name: sendNonKarmaNote()
Created by : Evon
Created on : 04/10/2014
*/
public function SendDirectkarmaNote($userType, $Giver)
{
//print_r($userType);
$CurrentUser = $ConnectionDetail = $userDetail = $userDetailArr = '';
$CurrentUser = Auth::User();
$checkMsgLimit = KarmaHelper::CheckUserLinkedMgsLimit();
if ($userType == 'NoKarma') {
$ConnectionDetail = Auth::User()->connections()->where('connections.id', '=', $Giver)->get()->first();
} else {
$userDetail = User::find($Giver);
$userDetailArr = $userDetail->toArray();
}
if ($userType == 'NoKarma') {
$skills = "";
$skills = DB::table('tags')->get();
foreach ($skills as $key => $value) {
$countSkill = DB::table('users_tags')->Where('tag_id', '=', $value->id)->count();
$skills[$key]->UserCount = $countSkill;
}
$skills = array_values(array_sort($skills, function ($value) {
return $value->UserCount;
}));
$skills = array_reverse($skills);
} else {
$skills = $userskills = "";
$userskills = DB::table('tags')->join('users_tags', 'tags.id', '=', 'users_tags.tag_id')->select(array('tags.name', 'tags.id', 'users_tags.user_id'))->where('users_tags.user_id', '=', $userDetail->id)->orderByRaw("RANd()")->take(10)->get();
$skills = $userskills;
if (empty($skills)) {
$skills = DB::table('tags')->get();
foreach ($skills as $key => $value) {
$countSkill = DB::table('users_tags')->Where('tag_id', '=', $value->id)->count();
$skills[$key]->UserCount = $countSkill;
}
$skills = array_values(array_sort($skills, function ($value) {
return $value->UserCount;
}));
$skills = array_reverse($skills);
}
}
//echo "<pre>===========";print_r($skills);echo "</pre>======";
if (!empty($Giver)) {
return View::make('send_nonkarma_note', array('pageTitle' => 'KarmaNotes', 'checkMsgLimit' => $checkMsgLimit, 'CurrentUser' => $CurrentUser, 'ConnectionDetail' => $ConnectionDetail, 'UserDetail' => $userDetailArr, 'Skills' => $skills, 'userType' => $userType));
} else {
return Redirect::to('404');
}
}
public function searchConnectionDataIntroGiver()
{
$user_info = Auth::user();
$user_id = 0;
$location = $search = $totalCount = $searchCat = '';
$searchresult = array();
if (!empty($_REQUEST['searchUsers'])) {
$search = $_REQUEST['searchUsers'];
}
if (!empty($_REQUEST['searchCat'])) {
$searchCat = $_REQUEST['searchCat'];
}
if ($searchCat == 'People') {
if (!empty($user_info)) {
$user_id = $user_info->id;
$location = $user_info->location;
}
$searchquery = DB::select(DB::raw('SELECT * from (SELECT `connections`.`fname`,
`connections`.`lname`, `connections`.`piclink`, `connections`.`networkid`,
`connections`.`linkedinurl`, `connections`.`headline`, `connections`.`location`,
`connections`.`id`,`connections`.`user_id`,`users`.`userstatus` from `connections`
inner join `users_connections` on `connections`.`id` = `users_connections`.`connection_id`
LEFT JOIN `users` on (`users`.`id` = `connections`.`user_id`)
WHERE concat(connections.fname," ",connections.lname) LIKE "%' . $search . '%" and `connections`.`user_id` != "" and `users_connections`.`user_id` = ' . $user_id . '
UNION
SELECT `connections`.`fname`,`connections`.`lname`, `connections`.`piclink`, `connections`.`networkid`,
`connections`.`linkedinurl`, `connections`.`headline`, `connections`.`location`,
`connections`.`id`,`connections`.`user_id`,`users`.`userstatus` from `connections`
inner join `users` on (`connections`.`user_id` = `users`.`id`)
WHERE concat(connections.fname," ",connections.lname) LIKE "%' . $search . '%" and `connections`.`user_id` != ""
and `connections`.`user_id` != ' . $user_id . ' and `users`.`userstatus` = "approved" ) as
result group by result.networkid order by result.user_id desc,result.location = "' . $location . '" desc
'));
foreach ($searchquery as $key => $value) {
$searchresult[$key]['fname'] = $value->fname;
$searchresult[$key]['lname'] = $value->lname;
$searchresult[$key]['linkedinurl'] = $value->linkedinurl;
$searchresult[$key]['headline'] = $value->headline;
$searchresult[$key]['location'] = $value->location;
$searchresult[$key]['linkedinid'] = $value->networkid;
$searchresult[$key]['piclink'] = $value->piclink;
$searchresult[$key]['id'] = $value->user_id;
$searchresult[$key]['connection_id'] = $value->id;
//$searchresult[$key]['userstatus'] = $value->userstatus;
$searchresult[$key]['unique_id'] = $key;
//$checkKarmaUser = KarmaHelper::checkKarmaUser($value->networkid);
if ($value->user_id != '' && ($value->userstatus == 'approved' || $value->userstatus == '')) {
$karmaProfileLink = 'profile/' . strtolower($value->fname . '-' . $value->lname) . '/' . $value->user_id;
} else {
$karmaProfileLink = '';
}
$searchresult[$key]['karmaProfileLink'] = $karmaProfileLink;
}
$totalCount = 0;
if (!empty($searchresult)) {
$totalCount = count($searchresult);
}
//echo "<pre>";print_r($searchresult);echo "</pre>";
//check if user messaging limit is reached for thr day
$checkMsgLimit = KarmaHelper::CheckUserLinkedMgsLimit();
return View::make('ajaxsearch_resultIntroGiver', array('checkMsgLimit' => $checkMsgLimit, 'CurrentUser' => $user_info, 'searchresult' => $searchresult, 'totalResult' => $totalCount, 'searchFor' => $search));
}
}
