Category Model

app/Models/Category.php

protected $fillable = [
    'provider_id',
    'name',
    'in_vod',
    'in_series',
    'is_system',
];

protected function casts(): array
{
    return [
        'in_vod' => 'boolean',
        'in_series' => 'boolean',
        'is_system' => 'boolean',
    ];
}

Category::UNCATEGORIZED_VOD_PROVIDER_ID = '__uncategorized_vod__'

Category::UNCATEGORIZED_SERIES_PROVIDER_ID = '__uncategorized_series__'

use App\Models\Category;

// Get all VOD categories
$vodCategories = Category::where('in_vod', true)->get();

// Get non-system VOD categories
$userCategories = Category::where('in_vod', true)
    ->where('is_system', false)
    ->get();

// Get all series categories
$seriesCategories = Category::where('in_series', true)->get();

// Find category by provider ID
$category = Category::where('provider_id', 'action-123')->first();

// Get uncategorized VOD category
$uncategorizedVod = Category::where(
    'provider_id',
    Category::UNCATEGORIZED_VOD_PROVIDER_ID
)->first();

// Check if category is system-managed
if ($category->is_system) {
    // Cannot delete system categories
}

use App\Actions\SyncCategories;

// Trigger category sync
$result = app(SyncCategories::class)->handle();