/** * Display a listing of the resource. * * @return Response */ public function index(ApiRepository $apirepo) { $popularCandidate = \App\LikeCandidate::select('*', \DB::raw('count(candidate_id) as count'))->groupBy('candidate_id')->orderBy('count', 'desc')->take(4)->get(); $data; foreach ($popularCandidate as $key => $value) { $candidate = $apirepo->getCandidateById($value->candidate_id); $candidate->data->likeCount = $value->count; $data[] = $candidate; } return view('main.home', compact('data')); }
protected function getLikeCountForCandidate($candidateId) { return \App\LikeCandidate::where('candidate_id', $candidateId)->count(); }
protected function checkLikeExist($candidateId) { $result = \App\LikeCandidate::where('user_id', auth()->user()->id)->where('candidate_id', $candidateId)->count(); return $result; }
public function checkLikeCandidate($candidateId) { return \App\LikeCandidate::where('candidate_id', $candidateId)->where('user_id', auth()->user()->id)->count(); }
public function show(ApiRepository $apirepo, $id) { $candidate = $apirepo->getCandidateById($id); $likes = \App\LikeCandidate::where('candidate_id', $id)->count(); return view('candidate.show', compact('candidate', 'likes')); }