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