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();
}
