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