/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index($slug) { $article = \App\Articles::where('slug', '=', $slug)->first(); $articles = \App\Articles::whereNotIn('slug', array($slug))->take(3)->get(); $data = array('article' => $article, 'articles' => $articles); return view('pages.article', $data); }
/** * Display the specified resource. * * @param $y * @param $m * @param $d * @param $alias */ public function show($y, $m, $d, $alias) { $article = Articles::where('alias', $alias)->first(); if (!$article) { return redirect('/'); } $pageTitle = $article->title; $pageDescription = $article->short_description; $pageInfo = 'Posted by ' . $article->user->username . ' on ' . $article->created_at->format('F j, Y'); return view('articles.show', compact('article', 'pageTitle', 'pageDescription', 'pageInfo')); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(Request $request) { $data = array(); $search = $request->input('search'); $schools = Schools::where('nama_sekolah', 'like', '%' . $search . '%')->get(); $articles = Articles::where('title', 'like', '%' . $search . '%')->where('category', 'news')->get(); $activities = Articles::where('title', 'like', '%' . $search . '%')->where('category', 'activity')->get(); $events = Events::where('title', 'like', '%' . $search . '%')->get(); $total = $schools->count() + $articles->count() + $activities->count() + $events->count(); $data = array('schools' => $schools, 'articles' => $articles, 'activities' => $activities, 'events' => $events, 'search' => $search, 'total' => $total); return view('pages.pencarian', $data); }
public function delete($tipe, $id) { if ($tipe == 'event') { Events::where('id', $id)->delete(); return redirect('dashboard/admin/events'); } elseif ($tipe == 'article') { Articles::where('id', $id)->delete(); $upload_folder = '/img/article/'; unlink(public_path() . $upload_folder . $id . '.jpg'); return redirect('dashboard/admin/articles'); } elseif ($tipe == 'user') { $role = Users::where('id', $id); Users::where('id', $id)->delete(); if ($role - role == 'sekolah') { Schools::where('user_id', $role->id)->delete(); } return redirect('dashboard/admin/users'); } elseif ($tipe == 'activity') { Articles::where('id', $id)->delete(); return redirect('dashboard/admin/activities'); } }
/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($slug) { $articles = Articles::where('slug', $slug)->get(); return view('backend.detail', ['articles' => $articles]); }
public function simpanpost($request) { $user = Auth::user()->id; $judul = $request->input('judul'); $isi = $request->input('isi'); $gambar = $request->file('gambar'); Articles::insert(['created_at' => date('Y-m-d h:i:sa'), 'updated_at' => date('Y-m-d h:i:sa'), 'user_id' => $user, 'title' => $judul, 'category' => 'activity', 'slug' => str_replace(' ', '-', $judul), 'intro' => substr($isi, 0, 300), 'content' => $isi]); $filename = Articles::where('slug', str_replace(' ', '-', $judul))->first()->id; $upload_folder = '/img/article/'; $gambar->move(public_path() . $upload_folder, $filename . '.jpg'); return redirect('dashboard/sekolah'); }
public function index() { $articles = Articles::where('active', 1)->orderBy('id', 'desc')->get(); return view('index', ['articles' => $articles]); }