✏️ Editing: SystemParameter.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\HasMany;

class SystemParameter extends Model
{
    use HasFactory;

protected $fillable = [
        'table',
        'name',
        'value',
        'amount',
        'qty',
        'priority',
        'icon',
        'color',
        'items',
        'status',
    ];

protected function casts(): array
    {
        return [
            'amount' => 'decimal:2',
            'qty' => 'integer',
            'priority' => 'integer',
            'items' => 'array',
            'status' => 'boolean',
        ];
    }

public function users(): HasMany
    {
        return $this->hasMany(User::class, 'user_type');
    }

/**
     * Get SystemParameter by table, name and value
     */
    public static function getByValue(?string $table = null, ?string $name = null, ?string $value = null): ?self
    {
        $query = static::query();

if ($table !== null) {
            $query->where('table', $table);
        }

if ($name !== null) {
            $query->where('name', $name);
        }

if ($value !== null) {
            $query->where('value', $value);
        }

return $query->first();
    }

/**
     * Get Client type ID
     */
    public static function getClientTypeId(): ?int
    {
        return static::getByValue('roles', 'cliente')?->id;
    }

/**
     * Get Admin type ID
     */
    public static function getAdminTypeId(): ?int
    {
        return static::getByValue('roles', 'admin')?->id;
    }

/**
     * Get Comercio type ID
     */
    public static function getComercioTypeId(): ?int
    {
        return static::getByValue('roles', 'comercio')?->id;
    }

/**
     * Get Agente type ID
     */
    public static function getAgenteTypeId(): ?int
    {
        return static::getByValue('roles', 'agente')?->id;
    }
}

Ubuntu

Sid Gifari From Gifari Industries - BD Cyber Security Team



Ubuntu

Sid Gifari From Gifari Industries - BD Cyber Security Team