File Manager

Editing File: /home/markqprx/iniasli.pro/Database/Seeds/SettingsTableSeeder.php

<?php namespace Common\Database\Seeds;

use Carbon\Carbon;
use Common\Settings\Setting;
use Illuminate\Database\Seeder;
use Illuminate\Support\Arr;
use Illuminate\Support\Str;

class SettingsTableSeeder extends Seeder
{
    public function __construct(protected Setting $setting)
    {
    }

public function run()
    {
        $defaultSettings = config('common.default-settings');

$names = [];

$defaultSettings = array_map(function ($setting) use (&$names) {
            $names[] = $setting['name'];

$setting['created_at'] = Carbon::now();
            $setting['updated_at'] = Carbon::now();

//make sure all settings have "private" field to
            //avoid db errors due to different column count
            if (!array_key_exists('private', $setting)) {
                $setting['private'] = 0;
            }

// cast booleans to string as "insert"
            // method will not use Setting model setters
            if ($setting['value'] === true) {
                $setting['value'] = 'true';
            } elseif ($setting['value'] === false) {
                $setting['value'] = 'false';
            }
            $setting['value'] = (string) $setting['value'];

// add ids to menus and menu items, if don't have one already
            if ($setting['name'] === 'menus') {
                $value = json_decode($setting['value'], true);
                foreach ($value as &$menu) {
                    if (!isset($menu['id'])) {
                        $menu['id'] = Str::random(6);
                    }
                    foreach ($menu['items'] as &$item) {
                        if (!isset($item['id'])) {
                            $item['id'] = Str::random(6);
                        }
                    }
                }
                $setting['value'] = json_encode($value);
            }

return $setting;
        }, $defaultSettings);

$existing = $this->setting->whereIn('name', $names)->pluck('name');

//only insert settings that don't already exist in database
        $new = array_filter($defaultSettings, function ($setting) use (
            $existing,
        ) {
            return !$existing->contains($setting['name']);
        });

$this->setting->insert($new);

$this->mergeMenusSetting($defaultSettings);
    }

/**
     * Merge existing menus setting json with new one.
     */
    private function mergeMenusSetting(array $defaultSettings): void
    {
        $existing =
            $this->setting->where('name', 'menus')->first()->value ?? [];
        $new = json_decode(
            Arr::first(
                $defaultSettings,
                fn($value) => $value['name'] === 'menus',
            )['value'],
            true,
        );

foreach ($new as $newMenu) {
            $alreadyHas = Arr::first(
                $existing,
                fn($value) => $value['name'] === $newMenu['name'],
            );

foreach ($newMenu['items'] as $index => $item) {
                $newMenu['items'][$index]['order'] = $index;
            }

if (!$alreadyHas) {
                $existing[] = $newMenu;
            }
        }

$this->setting
            ->where('name', 'menus')
            ->update(['value' => json_encode($existing)]);
    }
}

Back to Directory File Manager