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