Lines 81.08% 180 / 222
Methods 57.14% 16 / 28
Classes 0.00% 0 / 1
Name Lines Methods CRAP
 readResponse 88.88% 8 / 9 0.00% 0 / 1 4.02
 writeReport 100.00% 5 / 5 100.00% 1 / 1 1
 writeReportHeader 100.00% 16 / 16 100.00% 1 / 1 7
 writeTotalsRow 94.44% 17 / 18 0.00% 0 / 1 6.01
 writeReportData 100.00% 18 / 18 100.00% 1 / 1 6
 calculateNoAppointment 66.66% 2 / 3 0.00% 0 / 1 3.33
 calculateMissedNoAppointment 66.66% 2 / 3 0.00% 0 / 1 3.33
 calculateNoAppointmentForRow 66.66% 2 / 3 0.00% 0 / 1 3.33
 calculateMissedNoAppointmentForRow 66.66% 2 / 3 0.00% 0 / 1 3.33
 [BO\Zmsstatistic\Download\Base] sanitizeDownloadFilenamePart 100.00% 1 / 1 100.00% 1 / 1 1
 [BO\Zmsstatistic\Download\Base] resolveDictionaryHeader 33.33% 2 / 6 0.00% 0 / 1 5.67
 [BO\Zmsstatistic\Download\Base] writeRawReport 100.00% 9 / 9 100.00% 1 / 1 5
 [BO\Zmsstatistic\Download\Base] writeFilteredExchangeReport 93.75% 15 / 16 0.00% 0 / 1 6.01
 [BO\Zmsstatistic\Download\Base] writeInfoHeader 92.59% 25 / 27 0.00% 0 / 1 10.04
 [BO\Zmsstatistic\Download\Base] setDateTime 75.00% 3 / 4 0.00% 0 / 1 3.14
 [BO\Zmsstatistic\Download\Base] getFormatedDates 100.00% 9 / 9 100.00% 1 / 1 1
 [BO\Zmsstatistic\BaseController] __invoke 100.00% 5 / 5 100.00% 1 / 1 2
 [BO\Zmsstatistic\Helper\Access] initAccessRights 100.00% 6 / 6 100.00% 1 / 1 4
 [BO\Zmsstatistic\Helper\Access] readWorkstation 100.00% 2 / 2 100.00% 1 / 1 1
 [BO\Zmsstatistic\Helper\Access] readDepartment 100.00% 5 / 5 100.00% 1 / 1 2
 [BO\Zmsstatistic\Helper\Access] readOrganisation 100.00% 5 / 5 100.00% 1 / 1 2
 [BO\Zmsstatistic\Helper\Access] readOwner 100.00% 5 / 5 100.00% 1 / 1 2
 [BO\Zmsstatistic\Helper\Access] validateAccessRights 100.00% 3 / 3 100.00% 1 / 1 1
 [BO\Zmsstatistic\Helper\Access] validateAccess 100.00% 4 / 4 100.00% 1 / 1 7
 [BO\Zmsstatistic\Helper\Access] validateScope 66.66% 2 / 3 0.00% 0 / 1 4.59
 [BO\Zmsstatistic\Helper\Access] isPathWithoutScope 100.00% 5 / 5 100.00% 1 / 1 4
 [BO\Zmsstatistic\Helper\Access] testLogin 0.00% 0 / 27 0.00% 0 / 1 42
 [BO\Zmsstatistic\Helper\Access] exceptionTemplateExists 100.00% 2 / 2 100.00% 1 / 1 1
16class ClientReport extends Base
17{
18    /**
19     * @SuppressWarnings(Param)
20     * @return ResponseInterface
21     */
22    #[\Override]
23    public function readResponse(
24        RequestInterface $request,
25        ResponseInterface $response,
26        array $args
27    ): mixed {
28        $title = 'clientstatistic_' . $args['period'];
29        $download = (new Download($request))->setSpreadSheet($title);
30
31        $this->writeInfoHeader($args, $download->getSpreadSheet());
32        if ($args['reports']) {
33            foreach ($args['reports'] as $report) {
34                if ('month' == $report->period) {
35                    $this->writeReport($report, $download->getSpreadSheet(), 'yyyy', 'MMMM', 'yyyy');
36                } else {
37                    $this->writeReport($report, $download->getSpreadSheet());
38                }
39            }
40        }
41
42        return $download->writeDownload($response);
43    }
44
45    public function writeReport(
46        ReportEntity $report,
47        Spreadsheet $spreadsheet,
48        string $datePatternTotals = 'MMMM',
49        string $datePatternCol1 = 'ccc',
50        string $datePatternCol2 = 'dd.MM.yy'
51    ): Spreadsheet {
52        $sheet = $spreadsheet->getActiveSheet();
53        $this->writeReportHeader($report, $sheet);
54        $this->writeTotalsRow($report, $sheet, $datePatternTotals);
55        $this->writeReportData($report, $sheet, $datePatternCol1, $datePatternCol2);
56
57        return $spreadsheet;
58    }
59
60    public function writeReportHeader(ReportEntity $report, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $sheet): void
61    {
62        $reportHeader = [];
63        if ('totals' == end($report->data)['date'] || 'month' == $report->period) {
64            $reportHeader[] = null;
65        }
66
67        $row = $report->data[0];
68        if (is_array($row)) {
69            foreach (array_keys($row) as $headline) {
70                if (!in_array($headline, static::$ignoreColumns)) {
71                    if (isset(static::$headlines[$headline])) {
72                        $reportHeader[] = static::$headlines[$headline];
73                    }
74                }
75            }
76        }
77
78        // Placeholders for the new columns
79        $end = array_splice($reportHeader, -1);  // get the last element
80        $reportHeader[] = static::$headlines['noappointment'];
81        $reportHeader[] = static::$headlines['missednoappointment'];
82        $reportHeader[] = static::$headlines['ticketprinter'];
83        $reportHeader[] = static::$headlines['ticketprintermissed'];
84
85        $reportHeader = array_merge($reportHeader, $end);  // append them back after adding new headers
86
87
88        $sheet->fromArray($reportHeader, null, 'A' . ($sheet->getHighestRow() + 2));
89    }
90
91    public function writeTotalsRow(
92        ReportEntity $report,
93        \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $sheet,
94        string $datePatternTotals
95    ): void {
96        if ('totals' == end($report->data)['date']) {
97            $totals = array_pop($report->data);
98            $dateString = $report->firstDay->year . '-' . $report->firstDay->month . '-' . $report->firstDay->day;
99            $dateCol1 = ('MMMM' == $datePatternTotals) ?
100                $this->getFormatedDates($this->setDateTime($dateString), $datePatternTotals) :
101                null;
102            $dateCol2 = $this->setDateTime($dateString)->format('Y');
103            $reportTotal = [$dateCol1, $dateCol2];
104
105            foreach ($totals as $key => $item) {
106                if (! in_array($key, static::$ignoreColumns) && 'date' != $key) {
107                    $reportTotal[] = (string)($item);
108                }
109            }
110
111            // Calculations for the new columns
112            $end = array_splice($reportTotal, -1);
113
114            $reportTotal[] = $this->calculateNoAppointment($totals);
115            $reportTotal[] = $this->calculateMissedNoAppointment($totals);
116            $reportTotal[] = (string)($totals['ticketprinter'] ?? 0);
117            $reportTotal[] = (string)($totals['ticketprintermissed'] ?? 0);
118
119            $reportTotal = array_merge($reportTotal, $end);
120
121            $sheet->fromArray($reportTotal, null, 'A' . ($sheet->getHighestRow() + 1));
122        }
123    }
124
125    public function writeReportData(
126        ReportEntity $report,
127        \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $sheet,
128        string $datePatternCol1,
129        string $datePatternCol2
130    ): void {
131        $reportData = [];
132
133        foreach ($report->data as $row => $entry) {
134            $processedRow = [];
135
136            foreach ($entry as $key => $item) {
137                if (!in_array($key, static::$ignoreColumns)) {
138                    if ('date' == $key) {
139                        $dateCol1 = $this->getFormatedDates($this->setDateTime($item), $datePatternCol1);
140                        $item = $this->getFormatedDates($this->setDateTime($item), $datePatternCol2);
141                        $processedRow[] = $dateCol1;
142                    }
143                    $processedRow[] = (is_numeric($item)) ? (string)($item) : $item;
144                }
145            }
146
147            // Calculations for the new columns
148            $end = array_splice($processedRow, -1);
149
150            $processedRow[] = $this->calculateNoAppointmentForRow($entry);
151            $processedRow[] = $this->calculateMissedNoAppointmentForRow($entry);
152            $processedRow[] = (string)($entry['ticketprinter'] ?? 0);
153            $processedRow[] = (string)($entry['ticketprintermissed'] ?? 0);
154
155            $processedRow = array_merge($processedRow, $end);
156
157            $reportData[$row] = $processedRow;
158        }
159
160        $sheet->fromArray($reportData, null, 'A' . ($sheet->getHighestRow() + 1));
161    }
162
163    private function calculateNoAppointment(array $totals): string
164    {
165        if (isset($totals['clientscount']) && isset($totals['withappointment'])) {
166            return (string) ($totals['clientscount'] - $totals['withappointment']);
167        }
168        return 'N/A';
169    }
170
171    private function calculateMissedNoAppointment(array $totals): string
172    {
173        if (isset($totals['missed']) && isset($totals['missedwithappointment'])) {
174            return (string) ($totals['missed'] - $totals['missedwithappointment']);
175        }
176        return 'N/A';
177    }
178
179    private function calculateNoAppointmentForRow(array $entry): string
180    {
181        if (isset($entry['clientscount']) && isset($entry['withappointment'])) {
182            return (string) ($entry['clientscount'] - $entry['withappointment']);
183        }
184        return 'N/A';
185    }
186
187    private function calculateMissedNoAppointmentForRow(array $entry): string
188    {
189        if (isset($entry['missed']) && isset($entry['missedwithappointment'])) {
190            return (string) ($entry['missed'] - $entry['missedwithappointment']);
191        }
192        return 'N/A';
193    }
194}

Inherited from BO\Zmsstatistic\Download\Base

70    protected function sanitizeDownloadFilenamePart(string $part): string
71    {
72        return str_replace(',', '_', $part);
73    }
75    protected function resolveDictionaryHeader(array $item): string
76    {
77        if (!empty($item['description'])) {
78            return (string) $item['description'];
79        }
80
81        $variable = $item['variable'] ?? '';
82        if (isset(static::$headlines[$variable])) {
83            return static::$headlines[$variable];
84        }
85
86        return (string) $variable;
87    }
89    protected function writeRawReport(Exchange $report, Spreadsheet $spreadsheet): Spreadsheet
90    {
91        $sheet = $spreadsheet->getActiveSheet();
92        $reportData = [];
93        foreach ($report->dictionary as $item) {
94            $reportData['header'][] = $this->resolveDictionaryHeader($item);
95        }
96        foreach ($report->data as $row => $entry) {
97            foreach ($entry as $item) {
98                $reportData[$row][] = is_numeric($item) ? (string) $item : $item;
99            }
100        }
101        $sheet->fromArray($reportData, null, 'A' . ($sheet->getHighestRow()));
102
103        return $spreadsheet;
104    }
106    protected function writeFilteredExchangeReport(
107        Exchange $report,
108        Spreadsheet $spreadsheet,
109        array $skipVariables = [],
110        int $rowGap = 0
111    ): Spreadsheet {
112        $sheet = $spreadsheet->getActiveSheet();
113        $columnIndexes = [];
114        $reportData = [];
115
116        foreach ($report->dictionary as $index => $item) {
117            $variable = $item['variable'] ?? '';
118            if (in_array($variable, $skipVariables, true)) {
119                continue;
120            }
121            $columnIndexes[] = $index;
122            $reportData['header'][] = $this->resolveDictionaryHeader($item);
123        }
124
125        foreach ($report->data as $row => $entry) {
126            foreach ($columnIndexes as $index) {
127                $value = $entry[$index] ?? '';
128                $reportData[$row][] = is_numeric($value) ? (string) $value : $value;
129            }
130        }
131
132        $startRow = $sheet->getHighestRow() + $rowGap;
133        $sheet->fromArray($reportData, null, 'A' . $startRow);
134
135        return $spreadsheet;
136    }
138    protected function writeInfoHeader(array $args, Spreadsheet $spreadsheet): Spreadsheet|null
139    {
140        $sheet = $spreadsheet->getActiveSheet();
141        $infoData = [];
142        $infoData[] = static::$subjectTranslations[$args['category']];
143        if (isset($args['selectedScopes'])) {
144            try {
145                $scopesResult = \App::http()->readGetResult('/scope/')->getData();
146                $scopeMap = [];
147                foreach ($scopesResult ?? [] as $scope) {
148                    $scopeMap[$scope->id] = $scope;
149                }
150                foreach ($args['selectedScopes'] as $scopeId) {
151                    if (isset($scopeMap[$scopeId])) {
152                        $infoData[] = $scopeMap[$scopeId]->provider->name . " " . $scopeMap[$scopeId]->shortName;
153                    }
154                }
155            } catch (Exception $exception) {
156                return null;
157            }
158        } else {
159            if (isset($args['organisation'])) {
160                $infoData[] = $args['organisation']['name'] ;
161            }
162            if (isset($args['department'])) {
163                $infoData[] = $args['department']['name'];
164            }
165            if (isset($args['scope'])) {
166                $infoData[] = $args['scope']['contact']['name'] . ' ' . $args['scope']['shortName'];
167            }
168        }
169
170        $infoData = array_chunk($infoData, 1);
171        $sheet->fromArray($infoData, null, 'A' . $sheet->getHighestRow());
172
173        if (isset($args['reports'][0]->firstDay)) {
174            $firstDay = $args['reports'][0]->firstDay->toDateTime()->format('d.m.Y');
175            $lastDay = $args['reports'][0]->lastDay->toDateTime()->format('d.m.Y');
176            $range = array('Zeitraum:', $firstDay, 'bis', $lastDay);
177            $sheet->fromArray($range, null, 'A' . ($sheet->getHighestRow() + 1));
178        }
179
180        return $spreadsheet;
181    }
184    protected function setDateTime(string $dateString): \DateTime
185    {
186        $dateArr = explode('-', $dateString);
187        if (2 == count($dateArr)) {
188            $dateString = $dateString . '-01';
189        }
190        /* ignore because not in use now */
191        //@codeCoverageIgnoreStart
192        if (1 == count($dateArr)) {
193            $dateString = $dateString . '-01-01';
194        }
195        //@codeCoverageIgnoreEnd
196        return new \DateTime($dateString);
197    }
203    protected function getFormatedDates(\DateTimeInterface $date, string $pattern = 'MMMM'): string|false
204    {
205        $dateFormatter = new \IntlDateFormatter(
206            'de-DE',
207            \IntlDateFormatter::MEDIUM,
208            \IntlDateFormatter::MEDIUM,
209            \App::TIMEZONE,
210            \IntlDateFormatter::GREGORIAN,
211            $pattern
212        );
213
214        return $dateFormatter->format($date->getTimestamp());
215    }

Inherited from BO\Zmsstatistic\BaseController

20    public function __invoke(RequestInterface $request, ResponseInterface $response, array $args)
21    {
22        $request = $this->initRequest($request);
23        if ($this->withAccess) {
24            $this->initAccessRights($request);
25        }
26        $noCacheResponse = \BO\Slim\Render::withLastModified($response, time(), '0');
27        return $this->readResponse($request, $noCacheResponse, $args);
28    }

Inherited from BO\Zmsstatistic\Helper\Access

33    protected function initAccessRights(RequestInterface $request): void
34    {
35        $this->workstation = $this->readWorkstation();
36        if ($this->workstation && isset($this->workstation->scope['id']) && $this->workstation->scope['id'] > 0) {
37            $this->department = $this->readDepartment();
38            $this->organisation = $this->readOrganisation();
39            $this->owner = $this->readOwner();
40        }
41        $this->validateAccessRights($request);
42    }
44    protected function readWorkstation(): mixed
45    {
46        $workstation = \App::http()->readGetResult('/workstation/', ['resolveReferences' => $this->resolveLevel]);
47        return $workstation->getEntity();
48    }
50    protected function readDepartment(): mixed
51    {
52        if ($this->workstation->getUseraccount()->hasPermissions(['statistic'])) {
53            return \App::http()
54                ->readGetResult('/scope/' . $this->workstation->scope['id'] . '/department/')
55                ->getEntity();
56        }
57        return null;
58    }
60    protected function readOrganisation(): mixed
61    {
62        if ($this->workstation->getUseraccount()->isSuperUser()) {
63            return \App::http()
64                ->readGetResult('/department/' . $this->department->getId() . '/organisation/')
65                ->getEntity();
66        }
67        return null;
68    }
70    protected function readOwner(): mixed
71    {
72        if ($this->workstation->getUseraccount()->isSuperUser()) {
73            return \App::http()
74                ->readGetResult('/organisation/' . $this->organisation->getId() . '/owner/')
75                ->getEntity();
76        }
77        return null;
78    }
80    protected function validateAccessRights(RequestInterface $request): void
81    {
82        $path = $request->getUri()->getPath();
83        $this->validateAccess($path);
84        $this->validateScope($path);
85    }
87    protected function validateAccess(string $path): void
88    {
89        if (
90            (false !== strpos($path, 'owner') && ! $this->owner) ||
91            (false !== strpos($path, 'organisation') && ! $this->organisation) ||
92            (false !== strpos($path, 'department') && ! $this->department)
93        ) {
94            throw new UserAccountAccessRightsFailed();
95        }
96    }
98    protected function validateScope(string $path): void
99    {
100        if (
101            $this->isPathWithoutScope($path)
102            && (! isset($this->workstation['scope']) || ! isset($this->workstation['scope']['id']))
103        ) {
104            throw new WorkstationMissingScope();
105        }
106    }
108    protected function isPathWithoutScope(string $path): bool
109    {
110        // TODO: refactor to integrate these access rules in the controller to make them visible
111        return (false === strpos($path, 'select')
112            && false === strpos($path, 'warehouse')
113            && false === strpos($path, 'logout')
114            && false === strpos($path, 'report')
115        );
116    }
121    protected function testLogin(mixed $input): mixed
122    {
123        $userAccount = new Useraccount(array(
124            'id' => $input['loginName'],
125            'password' => $input['password'],
126            'departments' => array('id' => 0) // required in schema validation
127        ));
128        try {
129            /** @var Workstation $workstation */
130            $workstation = \App::http()->readPostResult('/workstation/login/', $userAccount)->getEntity();
131            return $workstation;
132        } catch (\BO\Zmsclient\Exception $exception) {
133            $template = TwigExceptionHandler::getExceptionTemplate($exception);
134            if ('BO\Zmsentities\Exception\SchemaValidation' == $exception->template) {
135                $exceptionData = [
136                  'template' => 'exception/bo/zmsbackend/useraccount/exception/invalidcredentials.twig'
137                ];
138                $exceptionData['data']['password']['messages'] = [
139                    'Der Nutzername oder das Passwort wurden falsch eingegeben'
140                ];
141            } elseif ('BO\Zmsbackend\Useraccount\Exception\UserAlreadyLoggedIn' == $exception->template) {
142                Auth::setKey($exception->data['authkey'], time() + \App::SESSION_DURATION);
143                throw $exception;
144            } elseif (
145                '' != $exception->template
146                && $this->exceptionTemplateExists($template)
147            ) {
148                $exceptionData = [
149                  'template' => $template,
150                  'data' => $exception->data
151                ];
152            } else {
153                throw $exception;
154            }
155        }
156        return $exceptionData;
157    }
159    protected function exceptionTemplateExists(string $template): bool
160    {
161        /** @var mixed $container */
162        $container = \App::$slim->getContainer();
163        return $container->get('view')->getLoader()->exists($template);
164    }