public function menuList(Request $request)
{
// $classes = Video::distinct()->groupBy('class')->get();
// //$topicsList = Video::distinct()->groupBy('topic')->get();
// //$topicsList = Topic::distinct()->groupBy('course')->orderBy('priority','ASC')->get();
// $topicsList = Video::join('topics',function($join){
// $join->on('videos.topic','=','topics.topic')->On('videos.class','=','topics.course');
// })->groupBy('topics.topic')->orderBy('priority', 'ASC')->get();
// $menuList = Video::get();
// $videos = Video::where('instructor','like', $squery)->orWhere('title', 'like', $squery)->orWhere('class', 'like', $squery)->orderBy('id', 'DESC')->paginate(15);
// $data = Video::join('topics',function($join){
// $join->on('videos.class','=','topics.course') ->on('videos.unit','=','topics.unit');
// })->groupBy('topics.course')->orderBy('priority', 'ASC')->get();
$data = Video::orderBy('order', 'ASC')->get();
$classes = Video::distinct()->groupBy('class')->get();
$menuList = Topic::orderBy('priority', 'ASC')->get();
return view('videos.menu', compact('menuList', 'classes', 'data'));
//return view('videos.menu', compact('videos'))->with('search', $search);
//return view('videos.menu');
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($video)
{
$units = Topic::orderBy('priority', 'ASC')->get();
$topics = Video::distinct()->select(['class', 'topic'])->orderBy('class', 'ASC')->get();
return view('videos.edit', compact('video', 'units', 'topics'));
}
