Server : nginx/1.18.0 System : Linux localhost 6.14.3-x86_64-linode168 #1 SMP PREEMPT_DYNAMIC Mon Apr 21 19:47:55 EDT 2025 x86_64 User : www-data ( 33) PHP Version : 8.0.16 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, Directory :  /var/www/ecommerce/app/Models/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Option extends Model
{
    public $timestamps = false;
    protected $fillable = [
        'group', 'key', 'value'
    ];

    public static function getOptions(string $group): array
    {
        $options = static::query()->where('group', $group)->toBase()->get();
        $array = [];

        foreach ($options as $option) {
            $array[$option->key] = $option->value;
        }

        return $array;
    }

    public static function setOptions(string $group, array $array): bool
    {
        $options = static::getOptions($group);

        $getUpserts = function () use ($group, $array) {
            $insert = [];
            $first = current($array);
            if (is_array($first)) {
                foreach ($array as $block) {
                    if (isset($block['key'], $block['value'])) {
                        $insert[] = ['group' => $group] + $block;
                    } else {
                        foreach ($block as $k => $v) {
                            $insert[] = ['group' => $group] + ['key' => $k, 'value' => $v];
                        }
                        break;
                    }
                }
            } else {
                if (isset($array['key'], $array['value'])) {
                    $insert[] = ['group' => $group] + $array;
                } else {
                    foreach ($array as $k => $v) {
                        $insert[] = ['group' => $group] + ['key' => $k, 'value' => $v];
                    }
                }
            }

            return $insert;
        };

        if (empty($options)) {
            if (empty($array)) {
                return false;
            }

            $insert = $getUpserts();
            return static::query()->insert($insert);
        } else {
            if (empty($array)) {
                return static::query()->where('group', $group)->delete();
            }

            $upsert = $getUpserts();
            foreach ($upsert as $rec) {
                static::query()
                    ->where('group', $rec['group'])
                    ->where('key', $rec['key'])
                    ->update([
                        'value' => $rec['value']
                    ]);
            }

            return true;
        }
    }
}