public function index() { $news = $this->news->orderBy('position', 'DESC')->orderBy('created_at', 'DESC')->limit(4)->get(); $sliders = Photo::join('photo_album', 'photo_album.id', '=', 'photo.photo_album_id')->where('photo.slider', 1)->orderBy('photo.position', 'DESC')->orderBy('photo.created_at', 'DESC')->select('photo.filename', 'photo.name', 'photo.description', 'photo_album.folderid')->get(); $photoalbums = PhotoAlbum::select(array('photo_album.id', 'photo_album.name', 'photo_album.description', 'photo_album.folderid', DB::raw('(select filename from ' . DB::getTablePrefix() . 'photo WHERE album_cover=TRUE and ' . DB::getTablePrefix() . 'photo.photo_album_id=' . DB::getTablePrefix() . 'photo_album.id) AS album_image'), DB::raw('(select filename from ' . DB::getTablePrefix() . 'photo WHERE ' . DB::getTablePrefix() . 'photo.photo_album_id=' . DB::getTablePrefix() . 'photo_album.id ORDER BY position ASC, id ASC LIMIT 1) AS album_image_first')))->limit(8)->get(); $videoalbums = VideoAlbum::select(array('video_album.id', 'video_album.name', 'video_album.description', 'video_album.folderid', DB::raw('(select youtube from ' . DB::getTablePrefix() . 'video as v WHERE album_cover=TRUE and v.video_album_id=' . DB::getTablePrefix() . 'video_album.id) AS album_image'), DB::raw('(select youtube from ' . DB::getTablePrefix() . 'video WHERE ' . DB::getTablePrefix() . 'video.video_album_id=' . DB::getTablePrefix() . 'video_album.id ORDER BY position ASC, id ASC LIMIT 1) AS album_image_first')))->limit(8)->get(); return view('site.home.index', compact('news', 'sliders', 'videoalbums', 'photoalbums')); }
/** * Store a newly created resource in storage. * * @param Request $request * @return Response */ public function store(Request $request) { try { $post_tag = new Post(); $post_tag->title = $request->input('title'); $post_tag->body = $request->input('body'); $post_tag->save(); return response()->json(array('error' => false, 'message' => 'Post tag added successfully.'), 200); } catch (Exception $e) { throw $e; } }
/** * [list description] * @return [type] [description] */ public function blog() { // $post = \Post::type('post')->status('published'); $posts = \Post::type('post')->published()->get(); // dd($posts); return view('posts.list', compact('posts')); }
/** * Metodo para se recuperar a entidade que tem o $id passado por parametro * OBS: necessita do input hidden tipoEntidade; */ public function getEntidade($id) { $tipoEntidade = Input::get('tipoEntidade', ''); switch ($tipoEntidade) { case 'App\\Perfil': $entidade = Perfil::findOrFail($id); break; case 'App\\Ong': $entidade = Ong::findOrFail($id); break; case 'App\\Empresa': $entidade = Empresa::findOrFail($id); break; case 'App\\Post': $entidade = Post::findOrFail($id); break; default: $entidade = ''; // Se nao encontrar nenhuma entidade, quebrar? // App::abort(500, 'Entidade nao identificada'); break; } return $entidade ? $entidade : false; }
public function delete($id) { Post::destroy($id); return redirect('/post/index'); }
/** * Display a listing of the resource. * * @return Response */ public function index() { $post = Post::all(); return view('post.index', compact('post')); }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { $post = Post::find($id); $post->delete(); return Redirect::to('post'); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { $tag = Post::find($id); if ($tag->delete()) { return response()->json(array('error' => false, 'message' => 'Tag has been deleted.'), 200); } else { return response()->json(array('error' => false, 'message' => 'Tag has not been deleted.'), 200); } }