/**
* Show the form for editing the specified news.
*
* @param int $id
* @return \Illuminate\View\View
*/
public function edit($id)
{
$news = News::find($id);
$sitelanguages = Sitelanguages::site_access()->join('sites', function ($join) {
$join->on('sites.id', '=', 'sitelanguages.sites_id');
})->join('languages', 'languages.id', '=', 'sitelanguages.languages_id')->select('sitelanguages.id', \DB::raw(' CONCAT(sites.title, \'-\',languages.code) as site_language'))->get()->lists('site_language', 'id')->prepend('Please select', '');
$category = Category::site_access()->join('sitelanguages', 'sitelanguages.id', '=', 'category.sitelanguages_id')->join('languages', 'languages.id', '=', 'sitelanguages.languages_id')->join('sites', 'sites.id', '=', 'sitelanguages.sites_id')->select('category.id', 'category.title')->get()->lists('title', 'id')->prepend('Please select', '');
return view('admin.news.edit', compact('news', "sitelanguages", "category"));
}
/**
* Display a listing of category
*
* @param Request $request
*
* @return \Illuminate\View\View
*/
public function index(Request $request)
{
$category = Category::site_access()->leftJoin('sitelanguages', 'sitelanguages.id', '=', 'category.sitelanguages_id')->join('sites', 'sites.id', '=', 'sitelanguages.sites_id')->join('languages', 'languages.id', '=', 'sitelanguages.languages_id')->select('category.*', \DB::raw('CONCAT(sites.title, \'-\',languages.code) as site_language'))->get();
return view('admin.category.index', compact('category'));
}
