/**
  * Display a listing of the resource.
  *
  * @return Response
  */
 public function index()
 {
     $contents = Content::all();
     return view('post.index', compact('contents'));
 }
 /**
  * Get all contents
  * 
  * @param Content $content
  * @return \Illiminate\Http\JsonResponse
  */
 public function json()
 {
     return response()->json(['data' => Content::all()]);
 }
 public function delete(Request $request)
 {
     /*
      * Find the product and delete it
      */
     $content_to_delete = Content::find($request->id);
     if ($content_to_delete->delete()) {
         return view('cms.content', ['contents' => Content::all()]);
     } else {
         die("There was an error deleting the copy!");
     }
 }
 /**
  * Show the form for creating a new resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function create()
 {
     $contents = Content::all();
     $categories = DB::table('categories')->select('categories.id', 'categories.title', 'categories.level', DB::raw("(CASE categories.level \n                                      WHEN 0 THEN LPAD(categories.ordering,5,0)\n                                      WHEN 1 THEN (SELECT CONCAT(LPAD(m.ordering,5,0), '.' ,LPAD(categories.ordering,5,0)) FROM categories as m WHERE m.id=categories.parent_id)\n                                      WHEN 2 THEN (SELECT CONCAT((SELECT LPAD(super.ordering,5,0) FROM categories AS super WHERE super.id = m.parent_id), '.' , LPAD(m.ordering,5,0), '.' ,LPAD(categories.ordering,5,0)) FROM categories as m WHERE m.id=categories.parent_id)\n                                      END) AS Pos"))->where('status', 1)->orderBy('Pos')->get();
     return View('admin.contents.create_content')->with(['categories' => $categories]);
 }
 /**
  * Display a listing of the resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function index(Request $request)
 {
     $contents = Content::all();
     return view('dashboard', compact('contents'));
 }