DatabaseAttemptsRepository.php

<?php


namespace Source\Gateways\Attempts;

use Carbon\Carbon;
use Source\Entities\Attempt;
use Source\Sanitize\CastsTo;

class DatabaseAttemptsRepository implements AttemptsRepository
{
    use CastsTo;

    /**
     * @param \App\Attempt $attempt
     * @return \Source\Entities\Attempt
     */
    protected static function toAttempt(\App\Attempt $attempt): Attempt
    {
        return new Attempt(
            $attempt->getAttribute('id'),
            $attempt->getAttribute('door_location'),
            $attempt->getAttribute('created_at'),
            $attempt->getAttribute('updated_at')
        );
    }

    /**
     * @inheritDoc
     */
    public function getBetween(?Carbon $begin = null, ?Carbon $end = null, ?string $doorLocation = null): array
    {
        $query = \App\Attempt::query()->orderByDesc('created_at');

        if ($doorLocation) {
            $query->where('door_location', 'ILIKE', "%$doorLocation%");
        }

        if ($begin && $end) {
            $query->whereBetween('created_at', [$begin, $end]);
        } elseif ($begin) {
            $query->where('created_at', '>', $begin);
        } elseif ($end) {
            $query->where('created_at', '<', $end);
        }

        return array_map(static function (\App\Attempt $attempt) {
            return self::toAttempt($attempt);
        }, $query->get()->values()->all());
    }

    /**
     * @inheritDoc
     */
    public function add(Attempt $attempt): ?Attempt
    {
        $a = new \App\Attempt();
        $a->setAttribute('door_location', $attempt->getDoorLocation());

        $a->save();

        return self::toAttempt($a);
    }
}