public function keywords()
{
$userName = Auth::user()->name;
$keywords = Keyword::all();
$results = [];
foreach ($keywords as $keyword) {
$id = $keyword->id;
$lists = DB::table('links')->where('keyword_id', '=', $id)->get();
$listCount = count($lists);
$results[] = ["keyword" => $keyword->text, "count" => $listCount];
}
usort($results, function ($a, $b) {
return $b['count'] - $a['count'];
});
return view('report.keywords', ['userName' => $userName, 'results' => $results]);
}
/**
*
* @return type
*/
public function index()
{
$keywords = Keyword::all();
return view('keyword-urls', ['keywords' => $keywords]);
}
