public function show($slug) { $serie = Serie::where('slug', $slug)->first(); if (!$serie) { return self::notfound(); } return view('larablog::themes.master', ['view' => lb_view('serie.show'), 'serie' => $serie, 'posts' => Larablog::publishedWhereSeries($serie), 'series' => Larablog::series(), 'top' => Larablog::top()]); }
public function cleanup() { $prefix = config('larablog.table.prefix'); DB::table($prefix . '_series')->update(['posts_count' => DB::Raw("(SELECT COUNT(*) FROM {$prefix}_posts WHERE {$prefix}_posts.serie_id = {$prefix}_series.id)")]); Serie::where('posts_count', 0)->delete(); }
public static function series() { return Serie::orderBy('slug', 'asc')->with('posts')->get(); }