*/ use HasFactory, SoftDeletes; /** * The table associated with the model. */ protected $table = 'topic_tags'; /** * The attributes that are mass assignable. * * @var list */ protected $fillable = [ 'name', 'slug', 'description', 'color', 'usage_count', ]; /** * The attributes that should be cast. * * @return array */ protected function casts(): array { return [ 'usage_count' => 'integer', ]; } /** * Get the topics associated with this tag through pivot table. */ public function topics(): BelongsToMany { return $this->belongsToMany(Topic::class, 'topic_tag_details', 'topic_tag_id', 'topic_id') ->withTimestamps(); } /** * Get popular tags ordered by usage count. */ public function scopePopular($query) { return $query->orderBy('usage_count', 'desc'); } /** * Increment usage count when tag is used. */ public function incrementUsage(): void { $this->increment('usage_count'); } /** * Decrement usage count when tag is removed. */ public function decrementUsage(): void { if ($this->usage_count > 0) { $this->decrement('usage_count'); } } }