public function cleanup() { $prefix = config('larablog.table.prefix'); // Clean out any old pivot data. DB::statement("DELETE {$prefix}_post_tag FROM {$prefix}_post_tag LEFT JOIN {$prefix}_posts ON {$prefix}_post_tag.post_id = {$prefix}_posts.id WHERE NOT({$prefix}_post_tag.post_id = {$prefix}_posts.id AND {$prefix}_posts.status = 'active' AND {$prefix}_posts.type='post')"); // TODO: convert to eloquent? DB::table($prefix . '_tags')->update(['posts_count' => DB::Raw("(SELECT COUNT(*) FROM {$prefix}_post_tag WHERE {$prefix}_post_tag.tag_id = {$prefix}_tags.id)")]); Tag::where('posts_count', 0)->delete(); }
public static function tags() { return Tag::orderBy('slug', 'asc')->get(); }