parking_manage_system/app/Models/ParkingPatternSpace.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

class ParkingPatternSpace extends Model
{
    use HasFactory, SoftDeletes;

    protected $table = 'parking_pattern_space';

    protected $fillable
        = [
            'pattern_id',
            'space_id',
            'space_type_id',
            'space_attr_id',
            'auxiliary_space_type'
        ];

    protected $hidden
        = [
            'created_at',
            'updated_at',
            'deleted_at'
        ];


    public static function getCount($pattern_id)
    {
        return self::query()->where('pattern_id', $pattern_id)->count();
    }

    public static function getData($pattern_id)
    {
        return self::query()->where('pattern_id', $pattern_id)->select()->get()->toArray();
    }

    public static function getParkingSpaceIds($pattern_id)
    {
        return self::query()->where('pattern_id', $pattern_id)->pluck('space_id');
    }

    public static function getParkingSpaceTypeIds($pattern_id)
    {
        return self::query()->where('pattern_id', $pattern_id)->pluck('space_type_id');
    }
}