@@ 34-57 (lines=24) @@ | ||
31 | * @throws InvalidDayName |
|
32 | * @throws InvalidTimeString |
|
33 | */ |
|
34 | public function scopeOpen(Builder $query, $time = null, string $day = null) |
|
35 | { |
|
36 | $now = Carbon::now(); |
|
37 | if ($time == null) { |
|
38 | $time = Time::fromDateTime($now); |
|
39 | } else if (is_string($time)) { |
|
40 | $time = Time::fromString($time); |
|
41 | } |
|
42 | ||
43 | if ($day == null) { |
|
44 | $day = Day::onDateTime($now); |
|
45 | } else { |
|
46 | if (! Day::isValid($day)) { |
|
47 | throw new InvalidDayName(); |
|
48 | } |
|
49 | } |
|
50 | ||
51 | return $query->whereHas($this->openingHoursRelationName, function(Builder $subquery) use ($day, $time) { |
|
52 | $subquery |
|
53 | ->where('day', $day) |
|
54 | ->where('start', '<=', $time) |
|
55 | ->where('end', '>=', $time); |
|
56 | }); |
|
57 | } |
|
58 | ||
59 | /** |
|
60 | * Get only closed models. |
|
@@ 71-94 (lines=24) @@ | ||
68 | * @throws InvalidDayName |
|
69 | * @throws InvalidTimeString |
|
70 | */ |
|
71 | public function scopeClosed(Builder $query, $time = null, string $day = null) |
|
72 | { |
|
73 | $now = Carbon::now(); |
|
74 | if ($time == null) { |
|
75 | $time = Time::fromDateTime($now); |
|
76 | } else if (is_string($time)) { |
|
77 | $time = Time::fromString($time); |
|
78 | } |
|
79 | ||
80 | if ($day == null) { |
|
81 | $day = Day::onDateTime($now); |
|
82 | } else { |
|
83 | if (! Day::isValid($day)) { |
|
84 | throw new InvalidDayName(); |
|
85 | } |
|
86 | } |
|
87 | ||
88 | return $query->whereDoesntHave($this->openingHoursRelationName, function(Builder $subquery) use ($day, $time) { |
|
89 | $subquery |
|
90 | ->where('day', $day) |
|
91 | ->where('start', '<=', $time) |
|
92 | ->where('end', '>=', $time); |
|
93 | }); |
|
94 | } |
|
95 | ||
96 | /** |
|
97 | * Get all models open at the specified day at random time |