Only return fields that are enabled based on another field

@zefex I'm using this package myself and I'm storing the full array in a single json field in my model's table.

In your case, I would store additional enabled value for each day and filter out disabled days before creating an instance of OpeningHours.

[
    'monday' => [
        '09:00-11:00',
        '13:00-19:00',
        'data' => [
            'enabled' => true
        ],
    ],
    'tuesday' => [
        '09:00-11:00',
        '13:00-19:00',
        'data' => [
            'enabled' => false
        ],
    ],
]

Creating OpeningHours instance:

OpeningHours::create(collect($openingHours)->filter(function ($day) {
    return $day['data']['enabled'];
})->all());

@sti3bas I thought about in the model Schedule I could like create a field called enabled so I can retrieve only the enabled ones, this would get rid of the extra data field on the json, what you think?

I have 2 questions:

1. How do you retrieve the data from the database and put back on the OpeningHours?
2. How did you structured your frontend (form) to accept the user input and handled on the controller to save on the database?

@zefex will you ever need to query opening hours in the database? If no, storing everything in a single json column seems a lot easier to me.

1: I have a method in my model class, so I can call it like $model->openingHours()->isOpenAt(new DateTime('2016-12-25')); :

public function openingHours()
{
    return OpeningHours::create($this->opening_hours ?: []);
}

2: I'm using Vue components. I have a component for a day which consists of dynamic number (user can click a button to add new one) of interval components. Then I emit events to the parent OpeningHours component where I store all the details in the array (same format as used in the package). Then after user clicks save button I'm sending a patch request with axios. In the controller I'm validating (I have few custom validation rules) the array and then updating my model:

$model->update([
   'opening_hours' => $request->validated()['opening_hours'] ?: null,
]);

@sti3bas Is it possible for you to share your Vue component and how you validated it? Thank you

@zefex the validation is quite simple, but Vue components are ~600 lines of code, because it handles some additional functionality, so it would be hard to extract the code only for the basic functionality, sorry.

Validation rules:

'opening_hours' => [
    'bail',
    'array',
    new WeekdayNames(),
],
'opening_hours.*' => [
    'bail',
    'array',
    'max:2', // only 2 intervals per day - business rule
],
'opening_hours.*.*' => [
    'bail',
    'array',
    'max:2', // ['hours', 'data']
],
'opening_hours.*.*.hours' => [
    'bail',
    new TimeRange(),
],
// other rules for validating data

WeekdayNames validation rule:

public function passes($attribute, $value)
{
    foreach ($value as $weekday => $i) {
        if (! \Spatie\OpeningHours\Day::isValid($weekday)) {
            return false;
        }
    }

    return true;
}

TimeRange validation rule:

public function passes($attribute, $value)
{
    try {
        \Spatie\OpeningHours\TimeRange::fromString($value);

        return true;
    } catch (\Exception $e) {
        return false;
    }
}

Thank you @sti3bas, I will be trying that out