Lines
90.66%
408 / 450
Functions and Methods
42.85%
9 / 21
Classes and Traits
0.00%
0 / 1
| Name | Lines | Functions and Methods | CRAP | Classes and Traits | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| CalendarAvailability | 90.66% | 408 / 450 | 42.85% | 9 / 21 | 113.96 | 0.00% | 0 / 1 | |||
| readFromQuery | 81.08% | 30 / 37 | 0.00% | 0 / 1 | 7.33 | |||||
| readAvailability | 100.00% | 118 / 118 | 100.00% | 1 / 1 | 7 | |||||
| withoutUnrelatedScopes | 66.66% | 4 / 6 | 0.00% | 0 / 1 | 4.59 | |||||
| resolveSlotsDateRange | 69.56% | 16 / 23 | 0.00% | 0 / 1 | 11.28 | |||||
| resolveResponseDaysRange | 76.92% | 10 / 13 | 0.00% | 0 / 1 | 4.20 | |||||
| filterDaysInDateRange | 100.00% | 6 / 6 | 100.00% | 1 / 1 | 4 | |||||
| narrowSlotsWindowToFirstBookableDay | 100.00% | 12 / 12 | 100.00% | 1 / 1 | 5 | |||||
| readBookableDaysForRange | 100.00% | 21 / 21 | 100.00% | 1 / 1 | 4 | |||||
| findAdjacentBookableDatesByScan | 100.00% | 20 / 20 | 100.00% | 1 / 1 | 1 | |||||
| findFirstBookableDateAfter | 93.33% | 28 / 30 | 0.00% | 0 / 1 | 10.03 | |||||
| findFirstBookableDateBefore | 76.66% | 23 / 30 | 0.00% | 0 / 1 | 11.27 | |||||
| formatDayIso | 100.00% | 7 / 7 | 100.00% | 1 / 1 | 1 | |||||
| buildCalendarFromQuery | 100.00% | 6 / 6 | 100.00% | 1 / 1 | 1 | |||||
| addProvidersFromQuery | 78.57% | 11 / 14 | 0.00% | 0 / 1 | 5.25 | |||||
| addRequestsFromQuery | 86.95% | 20 / 23 | 0.00% | 0 / 1 | 8.14 | |||||
| parseCsv | 66.66% | 2 / 3 | 0.00% | 0 / 1 | 2.15 | |||||
| datePartsFromIso | 100.00% | 6 / 6 | 100.00% | 1 / 1 | 1 | |||||
| buildResult | 91.66% | 44 / 48 | 0.00% | 0 / 1 | 12.08 | |||||
| groupAppointmentsByDateAndOffice | 88.88% | 16 / 18 | 0.00% | 0 / 1 | 7.07 | |||||
| dayToArray | 66.66% | 2 / 3 | 0.00% | 0 / 1 | 2.15 | |||||
| formatCalendarDate | 100.00% | 6 / 6 | 100.00% | 1 / 1 | 1 | |||||
| 1 | <?php | |
| 2 | ||
| 3 | namespace BO\Zmsbackend\Calendar\Service; | |
| 4 | ||
| 5 | use BO\Zmsentities\Calendar as Entity; | |
| 6 | use BO\Zmsentities\Collection\DayList; | |
| 7 | ||
| 8 | /** | |
| 9 | * Combined calendar days + free appointment slots in a single optimised DB pass. | |
| 10 | * | |
| 11 | * @SuppressWarnings(Coupling) | |
| 12 | */ | |
| 13 | class CalendarAvailability extends \BO\Zmsbackend\Base | |
| 14 | { | |
| 15 | public function readFromQuery( | |
| 16 | \DateTimeInterface $now, | |
| 17 | string $slotType, | |
| 18 | int $slotsRequired, | |
| 19 | ?string $startDate, | |
| 20 | ?string $endDate, | |
| 21 | ?string $officeIds, | |
| 22 | ?string $serviceIds, | |
| 23 | ?string $serviceCounts = '', | |
| 24 | ?string $providerSource = null, | |
| 25 | ?string $requestSource = null, | |
| 26 | ?string $slotsStartDate = null, | |
| 27 | ?string $slotsEndDate = null | |
| 28 | ): array { | |
| 29 | if (!$startDate || !$endDate || !$officeIds || !$serviceIds) { | |
| 30 | throw new \BO\Zmsbackend\Slot\Exception\Calendar\InvalidAvailabilityInput( | |
| 31 | 'startDate, endDate, officeIds and serviceIds are required' | |
| 32 | ); | |
| 33 | } | |
| 34 | ||
| 35 | try { | |
| 36 | $startDate = (new \DateTimeImmutable($startDate))->format('Y-m-d'); | |
| 37 | $endDate = (new \DateTimeImmutable($endDate))->format('Y-m-d'); | |
| 38 | } catch (\Exception $exception) { | |
| 39 | throw new \BO\Zmsbackend\Slot\Exception\Calendar\InvalidAvailabilityInput( | |
| 40 | 'startDate and endDate must be valid dates (YYYY-MM-DD)' | |
| 41 | ); | |
| 42 | } | |
| 43 | ||
| 44 | if ($startDate > $endDate) { | |
| 45 | throw new \BO\Zmsbackend\Slot\Exception\Calendar\InvalidAvailabilityInput( | |
| 46 | 'startDate must not be after endDate' | |
| 47 | ); | |
| 48 | } | |
| 49 | ||
| 50 | [$slotsStartDate, $slotsEndDate] = $this->resolveSlotsDateRange( | |
| 51 | $startDate, | |
| 52 | $endDate, | |
| 53 | $slotsStartDate, | |
| 54 | $slotsEndDate | |
| 55 | ); | |
| 56 | ||
| 57 | $calendar = $this->buildCalendarFromQuery( | |
| 58 | $startDate, | |
| 59 | $endDate, | |
| 60 | $officeIds, | |
| 61 | $serviceIds, | |
| 62 | $serviceCounts ?? '', | |
| 63 | $providerSource, | |
| 64 | $requestSource | |
| 65 | ); | |
| 66 | ||
| 67 | return $this->readAvailability( | |
| 68 | $calendar, | |
| 69 | $now, | |
| 70 | $slotType, | |
| 71 | $slotsRequired, | |
| 72 | $slotsStartDate, | |
| 73 | $slotsEndDate | |
| 74 | ); | |
| 75 | } | |
| 76 | ||
| 77 | public function readAvailability( | |
| 78 | Entity $calendar, | |
| 79 | \DateTimeInterface $now, | |
| 80 | string $slotType = 'public', | |
| 81 | int $slotsRequired = 0, | |
| 82 | ?string $slotsStartDate = null, | |
| 83 | ?string $slotsEndDate = null | |
| 84 | ): array { | |
| 85 | $dayRangeStart = $this->formatCalendarDate($calendar->firstDay); | |
| 86 | $dayRangeEnd = $this->formatCalendarDate($calendar->lastDay); | |
| 87 | [$slotsStartDate, $slotsEndDate] = $this->resolveSlotsDateRange( | |
| 88 | $dayRangeStart, | |
| 89 | $dayRangeEnd, | |
| 90 | $slotsStartDate, | |
| 91 | $slotsEndDate | |
| 92 | ); | |
| 93 | ||
| 94 | // Free-slot SQL only for slotsStart/End (may be a single day). | |
| 95 | // Bookable-day SQL only for the painted month of that window (not the full horizon). | |
| 96 | [$responseStartDate, $responseEndDate] = $this->resolveResponseDaysRange( | |
| 97 | $slotsStartDate, | |
| 98 | $slotsEndDate, | |
| 99 | $dayRangeStart, | |
| 100 | $dayRangeEnd | |
| 101 | ); | |
| 102 | ||
| 103 | $calendar = (new Calendar())->readResolvedEntity( | |
| 104 | $calendar, | |
| 105 | $now, | |
| 106 | true, | |
| 107 | $slotType, | |
| 108 | $slotsRequired, | |
| 109 | false | |
| 110 | ); | |
| 111 | // Citizen-only: do not invent bookable scopes when slotsRequired would fall back to 1. | |
| 112 | $calendar = $this->withoutUnrelatedScopes($calendar, $slotsRequired); | |
| 113 | ||
| 114 | $dayQuery = new \BO\Zmsbackend\Day\Service\Day(); | |
| 115 | $bookableDays = $this->readBookableDaysForRange( | |
| 116 | $calendar, | |
| 117 | $dayQuery, | |
| 118 | $slotsRequired, | |
| 119 | $slotType, | |
| 120 | $now, | |
| 121 | $responseStartDate, | |
| 122 | $responseEndDate, | |
| 123 | false | |
| 124 | ); | |
| 125 | ||
| 126 | $slotDays = $this->filterDaysInDateRange($bookableDays, $slotsStartDate, $slotsEndDate); | |
| 127 | $responseDays = $this->filterDaysInDateRange($bookableDays, $responseStartDate, $responseEndDate); | |
| 128 | ||
| 129 | // Free-slot SQL: one day only — either the first bookable day in a multi-day | |
| 130 | // window, or (for a single-day miss) the first bookable day in the painted month. | |
| 131 | if ($slotsStartDate !== $slotsEndDate) { | |
| 132 | [$slotsStartDate, $slotsEndDate, $slotDays] = $this->narrowSlotsWindowToFirstBookableDay( | |
| 133 | $slotDays, | |
| 134 | $slotsStartDate, | |
| 135 | $slotsEndDate | |
| 136 | ); | |
| 137 | } elseif (count($slotDays) === 0 && count($responseDays) > 0) { | |
| 138 | [$slotsStartDate, $slotsEndDate, $slotDays] = $this->narrowSlotsWindowToFirstBookableDay( | |
| 139 | $responseDays, | |
| 140 | $responseStartDate, | |
| 141 | $responseEndDate | |
| 142 | ); | |
| 143 | } | |
| 144 | ||
| 145 | // Vorlauf / lead time: citizen starts with slotsStartDate=today, but bookable | |
| 146 | // days may begin later. Snap free-slot + painted month to the first bookable | |
| 147 | // day in the horizon instead of returning an empty calendar. | |
| 148 | if (count($responseDays) === 0) { | |
| 149 | $firstBookableDate = $this->findFirstBookableDateAfter( | |
| 150 | $calendar, | |
| 151 | $dayQuery, | |
| 152 | $slotsRequired, | |
| 153 | $slotType, | |
| 154 | $now, | |
| 155 | (new \DateTimeImmutable($responseStartDate))->modify('-1 day')->format('Y-m-d'), | |
| 156 | $dayRangeEnd | |
| 157 | ); | |
| 158 | if ($firstBookableDate !== null) { | |
| 159 | $slotsStartDate = $firstBookableDate; | |
| 160 | $slotsEndDate = $firstBookableDate; | |
| 161 | [$responseStartDate, $responseEndDate] = $this->resolveResponseDaysRange( | |
| 162 | $slotsStartDate, | |
| 163 | $slotsEndDate, | |
| 164 | $dayRangeStart, | |
| 165 | $dayRangeEnd | |
| 166 | ); | |
| 167 | $bookableDays = $this->readBookableDaysForRange( | |
| 168 | $calendar, | |
| 169 | $dayQuery, | |
| 170 | $slotsRequired, | |
| 171 | $slotType, | |
| 172 | $now, | |
| 173 | $responseStartDate, | |
| 174 | $responseEndDate, | |
| 175 | true | |
| 176 | ); | |
| 177 | $responseDays = $this->filterDaysInDateRange( | |
| 178 | $bookableDays, | |
| 179 | $responseStartDate, | |
| 180 | $responseEndDate | |
| 181 | ); | |
| 182 | $slotDays = $this->filterDaysInDateRange( | |
| 183 | $bookableDays, | |
| 184 | $slotsStartDate, | |
| 185 | $slotsEndDate | |
| 186 | ); | |
| 187 | } | |
| 188 | } | |
| 189 | ||
| 190 | $calendar->days = $slotDays; | |
| 191 | ||
| 192 | $processList = []; | |
| 193 | if (count($slotDays) > 0) { | |
| 194 | $processList = (new \BO\Zmsbackend\Process\Service\ProcessStatusFree()) | |
| 195 | ->readMinimalFreeProcessesFromCalendar( | |
| 196 | $calendar, | |
| 197 | $slotType, | |
| 198 | $slotsRequired, | |
| 199 | false | |
| 200 | ); | |
| 201 | } | |
| 202 | ||
| 203 | [$prevBookableDate, $nextBookableDate] = $this->findAdjacentBookableDatesByScan( | |
| 204 | $calendar, | |
| 205 | $dayQuery, | |
| 206 | $slotsRequired, | |
| 207 | $slotType, | |
| 208 | $now, | |
| 209 | $responseStartDate, | |
| 210 | $responseEndDate, | |
| 211 | $dayRangeStart, | |
| 212 | $dayRangeEnd | |
| 213 | ); | |
| 214 | ||
| 215 | $calendar->days = $responseDays; | |
| 216 | return $this->buildResult( | |
| 217 | $calendar, | |
| 218 | $processList, | |
| 219 | $slotsStartDate, | |
| 220 | $slotsEndDate, | |
| 221 | $prevBookableDate, | |
| 222 | $nextBookableDate, | |
| 223 | $now | |
| 224 | ); | |
| 225 | } | |
| 226 | ||
| 227 | /** | |
| 228 | * Drop scopes with no request-relation slot requirement when slots are not forced. | |
| 229 | * Shared Day::writeTemporaryScopeList still defaults those to 1 for zmsadmin; | |
| 230 | * citizen availability must not invent bookable offices that way. | |
| 231 | */ | |
| 232 | private function withoutUnrelatedScopes(Entity $calendar, int $slotsRequiredForce): Entity | |
| 233 | { | |
| 234 | if ($slotsRequiredForce) { | |
| 235 | return $calendar; | |
| 236 | } | |
| 237 | ||
| 238 | // Keep the same ScopeList instance so slotsByID from resolve stays intact. | |
| 239 | foreach ($calendar->scopes as $key => $scope) { | |
| 240 | if ($calendar->scopes->getRequiredSlotsByScope($scope) < 1) { | |
| 241 | unset($calendar->scopes[$key]); | |
| 242 | } | |
| 243 | } | |
| 244 | ||
| 245 | return $calendar; | |
| 246 | } | |
| 247 | ||
| 248 | /** | |
| 249 | * Defaults slots window to the day range. When one side is missing, use the day range bound. | |
| 250 | * Clamps the slots window to the day range intersection. No overlap snaps to the nearest bound. | |
| 251 | */ | |
| 252 | private function resolveSlotsDateRange( | |
| 253 | string $startDate, | |
| 254 | string $endDate, | |
| 255 | ?string $slotsStartDate, | |
| 256 | ?string $slotsEndDate | |
| 257 | ): array { | |
| 258 | $slotsStart = $slotsStartDate ?: $startDate; | |
| 259 | $slotsEnd = $slotsEndDate ?: $endDate; | |
| 260 | ||
| 261 | try { | |
| 262 | $slotsStart = (new \DateTimeImmutable($slotsStart))->format('Y-m-d'); | |
| 263 | $slotsEnd = (new \DateTimeImmutable($slotsEnd))->format('Y-m-d'); | |
| 264 | } catch (\Exception $exception) { | |
| 265 | throw new \BO\Zmsbackend\Slot\Exception\Calendar\InvalidAvailabilityInput( | |
| 266 | 'slotsStartDate and slotsEndDate must be valid dates (YYYY-MM-DD)' | |
| 267 | ); | |
| 268 | } | |
| 269 | ||
| 270 | if ($slotsStart > $slotsEnd) { | |
| 271 | throw new \BO\Zmsbackend\Slot\Exception\Calendar\InvalidAvailabilityInput( | |
| 272 | 'slotsStartDate must not be after slotsEndDate' | |
| 273 | ); | |
| 274 | } | |
| 275 | ||
| 276 | // Clamp to day-status range so slot SQL never exceeds the resolved calendar. | |
| 277 | if ($slotsStart < $startDate) { | |
| 278 | $slotsStart = $startDate; | |
| 279 | } | |
| 280 | if ($slotsEnd > $endDate) { | |
| 281 | $slotsEnd = $endDate; | |
| 282 | } | |
| 283 | if ($slotsStart > $slotsEnd) { | |
| 284 | // No overlap: snap to the nearest day in the horizon instead of failing. | |
| 285 | if ($slotsEnd < $startDate) { | |
| 286 | $slotsStart = $startDate; | |
| 287 | $slotsEnd = $startDate; | |
| 288 | } else { | |
| 289 | $slotsStart = $endDate; | |
| 290 | $slotsEnd = $endDate; | |
| 291 | } | |
| 292 | } | |
| 293 | ||
| 294 | return [$slotsStart, $slotsEnd]; | |
| 295 | } | |
| 296 | ||
| 297 | /** | |
| 298 | * Bookable days returned to the client cover full calendar month(s) of the free-slots window | |
| 299 | * (clamped to the overall day-status range), so a single-day slot query still paints the month. | |
| 300 | */ | |
| 301 | private function resolveResponseDaysRange( | |
| 302 | string $slotsStartDate, | |
| 303 | string $slotsEndDate, | |
| 304 | string $dayRangeStart, | |
| 305 | string $dayRangeEnd | |
| 306 | ): array { | |
| 307 | $monthStart = (new \DateTimeImmutable($slotsStartDate)) | |
| 308 | ->modify('first day of this month') | |
| 309 | ->format('Y-m-d'); | |
| 310 | $monthEnd = (new \DateTimeImmutable($slotsEndDate)) | |
| 311 | ->modify('last day of this month') | |
| 312 | ->format('Y-m-d'); | |
| 313 | ||
| 314 | if ($monthStart < $dayRangeStart) { | |
| 315 | $monthStart = $dayRangeStart; | |
| 316 | } | |
| 317 | if ($monthEnd > $dayRangeEnd) { | |
| 318 | $monthEnd = $dayRangeEnd; | |
| 319 | } | |
| 320 | if ($monthStart > $monthEnd) { | |
| 321 | return [$slotsStartDate, $slotsEndDate]; | |
| 322 | } | |
| 323 | ||
| 324 | return [$monthStart, $monthEnd]; | |
| 325 | } | |
| 326 | ||
| 327 | private function filterDaysInDateRange(DayList $days, string $startDate, string $endDate): DayList | |
| 328 | { | |
| 329 | $filtered = new DayList(); | |
| 330 | foreach ($days as $day) { | |
| 331 | $date = $this->formatDayIso($day); | |
| 332 | if ($date >= $startDate && $date <= $endDate) { | |
| 333 | $filtered->addEntity($day); | |
| 334 | } | |
| 335 | } | |
| 336 | ||
| 337 | return $filtered; | |
| 338 | } | |
| 339 | ||
| 340 | /** | |
| 341 | * When the client asks for free slots over a range, only query the earliest bookable day. | |
| 342 | */ | |
| 343 | private function narrowSlotsWindowToFirstBookableDay( | |
| 344 | DayList $slotDays, | |
| 345 | string $slotsStartDate, | |
| 346 | string $slotsEndDate | |
| 347 | ): array { | |
| 348 | $firstBookableDate = null; | |
| 349 | foreach ($slotDays as $day) { | |
| 350 | $date = $this->formatDayIso($day); | |
| 351 | if ($firstBookableDate === null || $date < $firstBookableDate) { | |
| 352 | $firstBookableDate = $date; | |
| 353 | } | |
| 354 | } | |
| 355 | ||
| 356 | if ($firstBookableDate === null) { | |
| 357 | return [$slotsStartDate, $slotsEndDate, new DayList()]; | |
| 358 | } | |
| 359 | ||
| 360 | return [ | |
| 361 | $firstBookableDate, | |
| 362 | $firstBookableDate, | |
| 363 | $this->filterDaysInDateRange($slotDays, $firstBookableDate, $firstBookableDate), | |
| 364 | ]; | |
| 365 | } | |
| 366 | ||
| 367 | /** | |
| 368 | * Run daylist for a date range only (calendarscope months derived from firstDay/lastDay). | |
| 369 | * Restores the calendar horizon afterwards so response startDate/endDate stay full-range. | |
| 370 | * When $rewrite is false, create the temp table (first paint); when true, drop+rebuild. | |
| 371 | */ | |
| 372 | private function readBookableDaysForRange( | |
| 373 | Entity $calendar, | |
| 374 | \BO\Zmsbackend\Day\Service\Day $dayQuery, | |
| 375 | int $slotsRequired, | |
| 376 | string $slotType, | |
| 377 | \DateTimeInterface $now, | |
| 378 | string $rangeStartDate, | |
| 379 | string $rangeEndDate, | |
| 380 | bool $rewrite | |
| 381 | ): DayList { | |
| 382 | $savedFirst = $calendar->firstDay; | |
| 383 | $savedLast = $calendar->lastDay; | |
| 384 | $calendar->firstDay = $this->datePartsFromIso($rangeStartDate); | |
| 385 | $calendar->lastDay = $this->datePartsFromIso($rangeEndDate); | |
| 386 | ||
| 387 | try { | |
| 388 | if ($rewrite) { | |
| 389 | $dayQuery->rewriteTemporaryScopeList($calendar, $slotsRequired); | |
| 390 | } else { | |
| 391 | $dayQuery->writeTemporaryScopeList($calendar, $slotsRequired); | |
| 392 | } | |
| 393 | $dayList = $dayQuery->readListFromPreparedTemporaryScopeList( | |
| 394 | $slotsRequired, | |
| 395 | \BO\Zmsbackend\Day\Repository\Day::QUERY_DAYLIST_JOIN_AVAILABILITY | |
| 396 | ) | |
| 397 | ->setStatusByType($slotType, $now) | |
| 398 | ->withDaysInDateRange($calendar->getFirstDay(), $calendar->getLastDay()); | |
| 399 | } finally { | |
| 400 | $calendar->firstDay = $savedFirst; | |
| 401 | $calendar->lastDay = $savedLast; | |
| 402 | } | |
| 403 | ||
| 404 | $bookableDays = new DayList(); | |
| 405 | foreach ($dayList as $day) { | |
| 406 | $status = $day['status'] ?? null; | |
| 407 | if ($status === 'bookable') { | |
| 408 | $bookableDays->addEntity($day); | |
| 409 | } | |
| 410 | } | |
| 411 | ||
| 412 | return $bookableDays; | |
| 413 | } | |
| 414 | ||
| 415 | /** | |
| 416 | * Walk neighbor months until the first bookable date outside the painted window is found. | |
| 417 | */ | |
| 418 | private function findAdjacentBookableDatesByScan( | |
| 419 | Entity $calendar, | |
| 420 | \BO\Zmsbackend\Day\Service\Day $dayQuery, | |
| 421 | int $slotsRequired, | |
| 422 | string $slotType, | |
| 423 | \DateTimeInterface $now, | |
| 424 | string $responseStartDate, | |
| 425 | string $responseEndDate, | |
| 426 | string $dayRangeStart, | |
| 427 | string $dayRangeEnd | |
| 428 | ): array { | |
| 429 | return [ | |
| 430 | $this->findFirstBookableDateBefore( | |
| 431 | $calendar, | |
| 432 | $dayQuery, | |
| 433 | $slotsRequired, | |
| 434 | $slotType, | |
| 435 | $now, | |
| 436 | $responseStartDate, | |
| 437 | $dayRangeStart | |
| 438 | ), | |
| 439 | $this->findFirstBookableDateAfter( | |
| 440 | $calendar, | |
| 441 | $dayQuery, | |
| 442 | $slotsRequired, | |
| 443 | $slotType, | |
| 444 | $now, | |
| 445 | $responseEndDate, | |
| 446 | $dayRangeEnd | |
| 447 | ), | |
| 448 | ]; | |
| 449 | } | |
| 450 | ||
| 451 | private function findFirstBookableDateAfter( | |
| 452 | Entity $calendar, | |
| 453 | \BO\Zmsbackend\Day\Service\Day $dayQuery, | |
| 454 | int $slotsRequired, | |
| 455 | string $slotType, | |
| 456 | \DateTimeInterface $now, | |
| 457 | string $afterDate, | |
| 458 | string $horizonEnd | |
| 459 | ): ?string { | |
| 460 | $cursor = (new \DateTimeImmutable($afterDate))->modify('+1 day'); | |
| 461 | $horizonEndDate = new \DateTimeImmutable($horizonEnd); | |
| 462 | if ($cursor > $horizonEndDate) { | |
| 463 | return null; | |
| 464 | } | |
| 465 | ||
| 466 | while ($cursor <= $horizonEndDate) { | |
| 467 | $monthFirst = $cursor->modify('first day of this month'); | |
| 468 | $monthLast = $cursor->modify('last day of this month'); | |
| 469 | if ($monthLast > $horizonEndDate) { | |
| 470 | $monthLast = $horizonEndDate; | |
| 471 | } | |
| 472 | ||
| 473 | $bookableDays = $this->readBookableDaysForRange( | |
| 474 | $calendar, | |
| 475 | $dayQuery, | |
| 476 | $slotsRequired, | |
| 477 | $slotType, | |
| 478 | $now, | |
| 479 | $monthFirst->format('Y-m-d'), | |
| 480 | $monthLast->format('Y-m-d'), | |
| 481 | true | |
| 482 | ); | |
| 483 | ||
| 484 | $firstInMonth = null; | |
| 485 | foreach ($bookableDays as $day) { | |
| 486 | $date = $this->formatDayIso($day); | |
| 487 | if ($date <= $afterDate || $date > $horizonEnd) { | |
| 488 | continue; | |
| 489 | } | |
| 490 | if ($firstInMonth === null || $date < $firstInMonth) { | |
| 491 | $firstInMonth = $date; | |
| 492 | } | |
| 493 | } | |
| 494 | if ($firstInMonth !== null) { | |
| 495 | return $firstInMonth; | |
| 496 | } | |
| 497 | ||
| 498 | $cursor = $monthFirst->modify('first day of next month'); | |
| 499 | } | |
| 500 | ||
| 501 | return null; | |
| 502 | } | |
| 503 | ||
| 504 | private function findFirstBookableDateBefore( | |
| 505 | Entity $calendar, | |
| 506 | \BO\Zmsbackend\Day\Service\Day $dayQuery, | |
| 507 | int $slotsRequired, | |
| 508 | string $slotType, | |
| 509 | \DateTimeInterface $now, | |
| 510 | string $beforeDate, | |
| 511 | string $horizonStart | |
| 512 | ): ?string { | |
| 513 | $cursor = (new \DateTimeImmutable($beforeDate))->modify('-1 day'); | |
| 514 | $horizonStartDate = new \DateTimeImmutable($horizonStart); | |
| 515 | if ($cursor < $horizonStartDate) { | |
| 516 | return null; | |
| 517 | } | |
| 518 | ||
| 519 | while ($cursor >= $horizonStartDate) { | |
| 520 | $monthFirst = $cursor->modify('first day of this month'); | |
| 521 | $monthLast = $cursor->modify('last day of this month'); | |
| 522 | if ($monthFirst < $horizonStartDate) { | |
| 523 | $monthFirst = $horizonStartDate; | |
| 524 | } | |
| 525 | ||
| 526 | $bookableDays = $this->readBookableDaysForRange( | |
| 527 | $calendar, | |
| 528 | $dayQuery, | |
| 529 | $slotsRequired, | |
| 530 | $slotType, | |
| 531 | $now, | |
| 532 | $monthFirst->format('Y-m-d'), | |
| 533 | $monthLast->format('Y-m-d'), | |
| 534 | true | |
| 535 | ); | |
| 536 | ||
| 537 | $lastInMonth = null; | |
| 538 | foreach ($bookableDays as $day) { | |
| 539 | $date = $this->formatDayIso($day); | |
| 540 | if ($date >= $beforeDate || $date < $horizonStart) { | |
| 541 | continue; | |
| 542 | } | |
| 543 | if ($lastInMonth === null || $date > $lastInMonth) { | |
| 544 | $lastInMonth = $date; | |
| 545 | } | |
| 546 | } | |
| 547 | if ($lastInMonth !== null) { | |
| 548 | return $lastInMonth; | |
| 549 | } | |
| 550 | ||
| 551 | $cursor = $monthFirst->modify('last day of previous month'); | |
| 552 | } | |
| 553 | ||
| 554 | return null; | |
| 555 | } | |
| 556 | ||
| 557 | private function formatDayIso(\BO\Zmsentities\Day $day): string | |
| 558 | { | |
| 559 | $dayData = $this->dayToArray($day); | |
| 560 | ||
| 561 | return sprintf( | |
| 562 | '%04d-%02d-%02d', | |
| 563 | (int) ($dayData['year'] ?? 0), | |
| 564 | (int) ($dayData['month'] ?? 0), | |
| 565 | (int) ($dayData['day'] ?? 0) | |
| 566 | ); | |
| 567 | } | |
| 568 | ||
| 569 | private function buildCalendarFromQuery( | |
| 570 | string $startDate, | |
| 571 | string $endDate, | |
| 572 | string $officeIds, | |
| 573 | string $serviceIds, | |
| 574 | string $serviceCounts, | |
| 575 | ?string $providerSource, | |
| 576 | ?string $requestSource | |
| 577 | ): Entity { | |
| 578 | $calendar = new Entity(); | |
| 579 | $calendar->firstDay = $this->datePartsFromIso($startDate); | |
| 580 | $calendar->lastDay = $this->datePartsFromIso($endDate); | |
| 581 | $this->addProvidersFromQuery($calendar, $officeIds, $providerSource); | |
| 582 | $this->addRequestsFromQuery($calendar, $serviceIds, $serviceCounts, $requestSource); | |
| 583 | ||
| 584 | return $calendar; | |
| 585 | } | |
| 586 | ||
| 587 | private function addProvidersFromQuery( | |
| 588 | Entity $calendar, | |
| 589 | string $officeIds, | |
| 590 | ?string $providerSource | |
| 591 | ): void { | |
| 592 | $officeIdList = $this->parseCsv($officeIds); | |
| 593 | $providerSources = $providerSource | |
| 594 | ? [] | |
| 595 | : (new \BO\Zmsbackend\Provider\Service\Provider())->readSourceMapByIds($officeIdList); | |
| 596 | ||
| 597 | foreach ($officeIdList as $officeId) { | |
| 598 | $source = $providerSource ?: ($providerSources[$officeId] ?? null); | |
| 599 | if (!$source) { | |
| 600 | throw new \BO\Zmsbackend\Slot\Exception\Calendar\InvalidAvailabilityInput( | |
| 601 | 'Unknown officeId: ' . $officeId | |
| 602 | ); | |
| 603 | } | |
| 604 | ||
| 605 | $calendar->providers[] = [ | |
| 606 | 'id' => (int) $officeId, | |
| 607 | 'source' => $source, | |
| 608 | ]; | |
| 609 | } | |
| 610 | } | |
| 611 | ||
| 612 | private function addRequestsFromQuery( | |
| 613 | Entity $calendar, | |
| 614 | string $serviceIds, | |
| 615 | string $serviceCounts, | |
| 616 | ?string $requestSource | |
| 617 | ): void { | |
| 618 | $serviceIdList = $this->parseCsv($serviceIds); | |
| 619 | $countList = $serviceCounts === '' ? [] : array_map('trim', explode(',', $serviceCounts)); | |
| 620 | $requestSources = $requestSource | |
| 621 | ? [] | |
| 622 | : (new \BO\Zmsbackend\Request\Service\Request())->readSourceMapByIds( | |
| 623 | array_values(array_filter(array_map('strval', $serviceIdList))) | |
| 624 | ); | |
| 625 | ||
| 626 | foreach ($serviceIdList as $index => $serviceId) { | |
| 627 | $source = $requestSource ?: ($requestSources[$serviceId] ?? null); | |
| 628 | if (!$source) { | |
| 629 | throw new \BO\Zmsbackend\Slot\Exception\Calendar\InvalidAvailabilityInput( | |
| 630 | 'Unknown serviceId: ' . $serviceId | |
| 631 | ); | |
| 632 | } | |
| 633 | ||
| 634 | $count = max(1, (int) ($countList[$index] ?? 1)); | |
| 635 | if ($count > \BO\Zmsbackend\Slot\Service\Slot::MAX_SLOTS) { | |
| 636 | throw new \BO\Zmsbackend\Slot\Exception\Calendar\InvalidAvailabilityInput( | |
| 637 | 'serviceCount exceeds maximum of ' . \BO\Zmsbackend\Slot\Service\Slot::MAX_SLOTS | |
| 638 | ); | |
| 639 | } | |
| 640 | for ($slot = 0; $slot < $count; $slot++) { | |
| 641 | $calendar->requests[] = [ | |
| 642 | 'id' => $serviceId, | |
| 643 | 'source' => $source, | |
| 644 | ]; | |
| 645 | } | |
| 646 | } | |
| 647 | } | |
| 648 | ||
| 649 | /** | |
| 650 | * @return array<int, string> | |
| 651 | */ | |
| 652 | private function parseCsv(string $value): array | |
| 653 | { | |
| 654 | if ($value === '') { | |
| 655 | return []; | |
| 656 | } | |
| 657 | ||
| 658 | return array_values(array_filter(array_map('trim', explode(',', $value)), static fn (string $item): bool => $item !== '')); | |
| 659 | } | |
| 660 | ||
| 661 | /** | |
| 662 | * @return array{year: int, month: int, day: int} | |
| 663 | */ | |
| 664 | private function datePartsFromIso(string $isoDate): array | |
| 665 | { | |
| 666 | $date = new \DateTimeImmutable($isoDate); | |
| 667 | ||
| 668 | return [ | |
| 669 | 'year' => (int) $date->format('Y'), | |
| 670 | 'month' => (int) $date->format('n'), | |
| 671 | 'day' => (int) $date->format('j'), | |
| 672 | ]; | |
| 673 | } | |
| 674 | ||
| 675 | /** | |
| 676 | * @param array<int, array<string, mixed>> $processList | |
| 677 | * | |
| 678 | * @return array<string, mixed> | |
| 679 | */ | |
| 680 | private function buildResult( | |
| 681 | Entity $calendar, | |
| 682 | array $processList, | |
| 683 | string $slotsStartDate, | |
| 684 | string $slotsEndDate, | |
| 685 | ?string $prevBookableDate, | |
| 686 | ?string $nextBookableDate, | |
| 687 | \DateTimeInterface $now | |
| 688 | ): array { | |
| 689 | $scopeToProvider = []; | |
| 690 | foreach ($calendar->scopes as $scope) { | |
| 691 | $scopeToProvider[(string) $scope['id']] = (string) $scope['provider']['id']; | |
| 692 | } | |
| 693 | ||
| 694 | $appointmentsByDateAndOffice = $this->groupAppointmentsByDateAndOffice($processList, $now); | |
| 695 | $days = []; | |
| 696 | ||
| 697 | foreach ($calendar->days as $day) { | |
| 698 | $dayData = $this->dayToArray($day); | |
| 699 | if (($dayData['status'] ?? null) !== 'bookable') { | |
| 700 | continue; | |
| 701 | } | |
| 702 | ||
| 703 | $date = sprintf( | |
| 704 | '%04d-%02d-%02d', | |
| 705 | (int) $dayData['year'], | |
| 706 | (int) $dayData['month'], | |
| 707 | (int) $dayData['day'] | |
| 708 | ); | |
| 709 | ||
| 710 | $inSlotsWindow = $date >= $slotsStartDate && $date <= $slotsEndDate; | |
| 711 | $dayAppointments = $appointmentsByDateAndOffice[$date] ?? []; | |
| 712 | ||
| 713 | if ($inSlotsWindow) { | |
| 714 | // Free-slot verified: only providers that actually have appointments. | |
| 715 | $providerIds = array_map('strval', array_keys($dayAppointments)); | |
| 716 | sort($providerIds, SORT_STRING); | |
| 717 | if ($providerIds === []) { | |
| 718 | continue; | |
| 719 | } | |
| 720 | } else { | |
| 721 | // Daylist paints the rest of the month without free-slot payloads. | |
| 722 | // Do not intersect with the slots-window providers: an office can be | |
| 723 | // closed on the free-slot day and still bookable later in the month. | |
| 724 | $scopeIdList = isset($dayData['scopeIDs']) && $dayData['scopeIDs'] !== '' | |
| 725 | ? array_filter(explode(',', (string) $dayData['scopeIDs'])) | |
| 726 | : []; | |
| 727 | $providerIds = []; | |
| 728 | foreach ($scopeIdList as $scopeId) { | |
| 729 | if (isset($scopeToProvider[$scopeId])) { | |
| 730 | $providerIds[] = $scopeToProvider[$scopeId]; | |
| 731 | } | |
| 732 | } | |
| 733 | $providerIds = array_values(array_unique($providerIds)); | |
| 734 | sort($providerIds, SORT_STRING); | |
| 735 | if ($providerIds === []) { | |
| 736 | continue; | |
| 737 | } | |
| 738 | $dayAppointments = []; | |
| 739 | } | |
| 740 | ||
| 741 | $days[] = [ | |
| 742 | 'date' => $date, | |
| 743 | 'providerIDs' => implode(',', $providerIds), | |
| 744 | 'appointments' => $dayAppointments, | |
| 745 | ]; | |
| 746 | } | |
| 747 | ||
| 748 | return [ | |
| 749 | 'startDate' => $this->formatCalendarDate($calendar->firstDay), | |
| 750 | 'endDate' => $this->formatCalendarDate($calendar->lastDay), | |
| 751 | 'slotsStartDate' => $slotsStartDate, | |
| 752 | 'slotsEndDate' => $slotsEndDate, | |
| 753 | 'prevBookableDate' => $prevBookableDate, | |
| 754 | 'nextBookableDate' => $nextBookableDate, | |
| 755 | 'days' => $days, | |
| 756 | ]; | |
| 757 | } | |
| 758 | ||
| 759 | /** | |
| 760 | * @param array<int, array<string, mixed>> $processList | |
| 761 | * | |
| 762 | * @return array<string, array<string, array<int, int>>> | |
| 763 | */ | |
| 764 | private function groupAppointmentsByDateAndOffice(array $processList, \DateTimeInterface $now): array | |
| 765 | { | |
| 766 | $grouped = []; | |
| 767 | $nowTimestamp = $now->getTimestamp(); | |
| 768 | ||
| 769 | foreach ($processList as $process) { | |
| 770 | $officeId = (string) ($process['scope']['provider']['id'] ?? ''); | |
| 771 | if ($officeId === '') { | |
| 772 | continue; | |
| 773 | } | |
| 774 | ||
| 775 | foreach ($process['appointments'] ?? [] as $appointment) { | |
| 776 | $timestamp = (int) ($appointment['date'] ?? 0); | |
| 777 | if ($timestamp <= $nowTimestamp) { | |
| 778 | continue; | |
| 779 | } | |
| 780 | ||
| 781 | $date = date('Y-m-d', $timestamp); | |
| 782 | $grouped[$date][$officeId][] = $timestamp; | |
| 783 | } | |
| 784 | } | |
| 785 | ||
| 786 | foreach ($grouped as &$byOffice) { | |
| 787 | foreach ($byOffice as &$timestamps) { | |
| 788 | sort($timestamps); | |
| 789 | $timestamps = array_values(array_unique($timestamps)); | |
| 790 | } | |
| 791 | } | |
| 792 | unset($byOffice, $timestamps); | |
| 793 | ||
| 794 | return $grouped; | |
| 795 | } | |
| 796 | ||
| 797 | /** | |
| 798 | * @return array<string, mixed> | |
| 799 | */ | |
| 800 | private function dayToArray(mixed $day): array | |
| 801 | { | |
| 802 | if ($day instanceof \BO\Zmsentities\Day) { | |
| 803 | return $day->getArrayCopy(); | |
| 804 | } | |
| 805 | ||
| 806 | return (array) $day; | |
| 807 | } | |
| 808 | ||
| 809 | /** | |
| 810 | * @param array<string, int|string>|null $date | |
| 811 | */ | |
| 812 | private function formatCalendarDate(?array $date): string | |
| 813 | { | |
| 814 | return sprintf( | |
| 815 | '%04d-%02d-%02d', | |
| 816 | (int) ($date['year'] ?? 0), | |
| 817 | (int) ($date['month'] ?? 0), | |
| 818 | (int) ($date['day'] ?? 0) | |
| 819 | ); | |
| 820 | } | |
| 821 | } |