/**
* Display a listing of news
*
* @param Request $request
*
* @return \Illuminate\View\View
*/
public function index(Request $request)
{
$news = News::site_access()->with('category')->leftJoin('sitelanguages', 'sitelanguages.id', '=', 'news.sitelanguages_id')->join('sites', 'sites.id', '=', 'sitelanguages.sites_id')->join('languages', 'languages.id', '=', 'sitelanguages.languages_id')->select('news.*', \DB::raw(' CONCAT(sites.title, \'-\',languages.code) as site_language'))->get();
return view('admin.news.index', compact('news'));
}
