Lines 100.00% 80 / 80
Functions and Methods 100.00% 3 / 3
Classes and Traits 100.00% 1 / 1
Name Lines Functions and Methods CRAP Classes and Traits
ExchangeWaitingowner 100.00% 80 / 80 100.00% 3 / 3 10 100.00% 1 / 1
 readEntity 100.00% 47 / 47 100.00% 1 / 1 4
 readSubjectList 100.00% 11 / 11 100.00% 1 / 1 2
 readPeriodList 100.00% 22 / 22 100.00% 1 / 1 4
1<?php
2
3namespace BO\Zmsbackend\Exchange\Service;
4
5use BO\Zmsentities\Exchange;
6
7class ExchangeWaitingowner extends \BO\Zmsbackend\Base implements \BO\Zmsbackend\Interfaces\ExchangeSubject
8{
9    /**
10     * @return Exchange
11     */
12    #[\Override]
13    public function readEntity(
14        string|int $subjectid,
15        \DateTimeInterface $datestart,
16        \DateTimeInterface $dateend,
17        string $period = 'day'
18    ) {
19        $owner = (new \BO\Zmsbackend\Owner\Service\Owner())->readEntity($subjectid);
20        $entity = new Exchange();
21        $entity['title'] = "Wartestatistik $owner->name";
22        $entity->setPeriod($datestart, $dateend, $period);
23        $entity->addDictionaryEntry('subjectid', 'string', 'ID of an owner', 'owner.id');
24        $entity->addDictionaryEntry('date', 'string', 'date of report entry');
25        $entity->addDictionaryEntry('hour', 'string', 'hour of report entry');
26        $entity->addDictionaryEntry('waitingcount', 'number', 'amount of waiting spontaneous clients');
27        $entity->addDictionaryEntry('waitingtime', 'number', 'real waitingtime for spontaneous clients');
28        $entity->addDictionaryEntry('waytime', 'number', 'real waytime for spontaneous clients');
29        $entity->addDictionaryEntry('waitingcalculated', 'number', 'calculated waitingtime for spontaneous clients');
30        $entity->addDictionaryEntry('waitingcount_termin', 'number', 'amount of waiting clients with termin');
31        $entity->addDictionaryEntry('waitingtime_termin', 'number', 'real waitingtime with termin');
32        $entity->addDictionaryEntry('waytime_termin', 'number', 'real waytime with appointment');
33        $entity->addDictionaryEntry('waitingcalculated_termin', 'number', 'calculated waitingtime with termin');
34        $entity->addDictionaryEntry('waycount_termin', 'number', 'clients included in appointment way time');
35        $subjectIdList = explode(',', $subjectid);
36
37        foreach ($subjectIdList as $subjectid) {
38            $raw = $this
39                ->getReader()
40                ->fetchAll(
41                    constant("\BO\Zmsbackend\Exchange\Repository\ExchangeWaitingowner::QUERY_READ_" . strtoupper($period)),
42                    [
43                        'ownerid' => $subjectid,
44                        'datestart' => $datestart->format('Y-m-d'),
45                        'dateend' => $dateend->format('Y-m-d'),
46                    ]
47                );
48
49            $entry = array_shift($raw);
50            while ($entry) {
51                foreach (range(0, 23) as $hour) {
52                    $entity->addDataSet([
53                        $subjectid,
54                        $entry['datum'],
55                        $hour,
56                        $entry[sprintf('hour_%02d_waiting_count_spontaneous', $hour)],
57                        $entry[sprintf('hour_%02d_waiting_time_spontaneous', $hour)],
58                        $entry[sprintf('hour_%02d_way_time_spontaneous', $hour)],
59                        $entry[sprintf('hour_%02d_estimated_waiting_time_spontaneous', $hour)],
60                        $entry[sprintf('hour_%02d_waiting_count_appointment', $hour)],
61                        $entry[sprintf('hour_%02d_waiting_time_appointment', $hour)],
62                        $entry[sprintf('hour_%02d_way_time_appointment', $hour)],
63                        $entry[sprintf('hour_%02d_estimated_waiting_time_appointment', $hour)],
64                        $entry[sprintf('hour_%02d_way_count_appointment', $hour)],
65                    ]);
66                }
67                $entry = array_shift($raw);
68            }
69        }
70        return $entity;
71    }
72
73    /**
74     * @return Exchange
75     */
76    #[\Override]
77    public function readSubjectList()
78    {
79        $raw = $this->getReader()->fetchAll(\BO\Zmsbackend\Exchange\Repository\ExchangeWaitingowner::QUERY_SUBJECTS, []);
80        $entity = new Exchange();
81        $entity['title'] = "Wartestatistik";
82        $entity->setPeriod(new \DateTimeImmutable(), new \DateTimeImmutable());
83        $entity->addDictionaryEntry('subject', 'string', 'Owner ID', 'owner.id');
84        $entity->addDictionaryEntry('periodstart', 'string', 'Datum von');
85        $entity->addDictionaryEntry('periodend', 'string', 'Datum bis');
86        $entity->addDictionaryEntry('description', 'string', 'Name des Inhabers');
87
88        foreach ($raw as $entry) {
89            $entity->addDataSet(array_values($entry));
90        }
91        return $entity;
92    }
93
94    /**
95     * @return Exchange
96     */
97    #[\Override]
98    public function readPeriodList(string|int $subjectid, string $period = 'day')
99    {
100        $owner = (new \BO\Zmsbackend\Owner\Service\Owner())->readEntity($subjectid);
101        $entity = new Exchange();
102        $entity['title'] = "Wartestatistik $owner->name";
103        $entity->setPeriod(new \DateTimeImmutable(), new \DateTimeImmutable(), $period);
104        $entity->addDictionaryEntry('period');
105
106        $monthsList = $this->getReader()->fetchAll(
107            constant("\BO\Zmsbackend\Exchange\Repository\ExchangeWaitingowner::QUERY_PERIODLIST_MONTH"),
108            [
109                'ownerid' => $subjectid,
110            ]
111        );
112        $raw = [];
113        foreach ($monthsList as $month) {
114            $date = new \DateTimeImmutable($month['date']);
115            $raw[$date->format('Y')][] = $month['date'];
116            rsort($raw[$date->format('Y')]);
117        }
118        krsort($raw);
119
120        foreach ($raw as $year => $months) {
121            $entity->addDataSet([$year]);
122            foreach ($months as $month) {
123                $entity->addDataSet([$month]);
124            }
125        }
126        return $entity;
127    }
128}