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]); }