Code Coverage |
||||||||||
Lines |
Functions and Methods |
Classes and Traits |
||||||||
| Total | |
94.87% |
37 / 39 |
|
66.67% |
2 / 3 |
CRAP | |
0.00% |
0 / 1 |
| Base | |
94.87% |
37 / 39 |
|
66.67% |
2 / 3 |
14.03 | |
0.00% |
0 / 1 |
| writeInfoHeader | |
92.31% |
24 / 26 |
|
0.00% |
0 / 1 |
10.05 | |||
| setDateTime | |
100.00% |
4 / 4 |
|
100.00% |
1 / 1 |
3 | |||
| getFormatedDates | |
100.00% |
9 / 9 |
|
100.00% |
1 / 1 |
1 | |||
| 1 | <?php |
| 2 | |
| 3 | /** |
| 4 | * @package zmsstatistic |
| 5 | * @copyright BerlinOnline Stadtportal GmbH & Co. KG |
| 6 | **/ |
| 7 | |
| 8 | namespace BO\Zmsstatistic\Download; |
| 9 | |
| 10 | use Exception; |
| 11 | use PhpOffice\PhpSpreadsheet\Spreadsheet; |
| 12 | |
| 13 | class Base extends \BO\Zmsstatistic\BaseController |
| 14 | { |
| 15 | public static $ignoreColumns = [ |
| 16 | 'subjectid', |
| 17 | 'scopeids', |
| 18 | 'max', |
| 19 | 'sum' |
| 20 | ]; |
| 21 | public static $subjectTranslations = [ |
| 22 | 'waitingscope' => 'Wartesituation', |
| 23 | 'waitingdepartment' => 'Wartesituation', |
| 24 | 'waitingorganisation' => 'Wartesituation', |
| 25 | 'notificationscope' => 'SMS Auswertung', |
| 26 | 'notificationdepartment' => 'SMS Auswertung', |
| 27 | 'notificationorganisation' => 'SMS Auswertung', |
| 28 | 'clientscope' => 'Kundenstatistik', |
| 29 | 'clientdepartment' => 'Kundenstatistik', |
| 30 | 'clientorganisation' => 'Kundenstatistik', |
| 31 | 'requestscope' => 'Dienstleistungsstatistik', |
| 32 | 'requestdepartment' => 'Dienstleistungsstatistik', |
| 33 | 'requestorganisation' => 'Dienstleistungsstatistik', |
| 34 | 'raw-waitingscope' => 'Rohdaten Wartesituation', |
| 35 | 'raw-waitingdepartment' => 'Rohdaten Wartesituation', |
| 36 | 'raw-waitingorganisation' => 'Rohdaten Wartesituation', |
| 37 | 'raw-clientscope' => 'Rohdaten Wartende', |
| 38 | 'raw-clientdepartment' => 'Rohdaten Wartende', |
| 39 | 'raw-clientorganisation' => 'Rohdaten Wartende', |
| 40 | 'raw-notificationscope' => 'Rohdaten SMS', |
| 41 | 'raw-notificationdepartment' => 'Rohdaten SMS', |
| 42 | 'raw-notificationorganisation' => 'Rohdaten SMS', |
| 43 | 'raw-requestscope' => 'Rohdaten Dienstleistungsstatistik', |
| 44 | 'raw-requestdepartment' => 'Rohdaten Dienstleistungsstatistik', |
| 45 | 'raw-requestorganisation' => 'Rohdaten Dienstleistungsstatistik' |
| 46 | ]; |
| 47 | |
| 48 | public static $headlines = [ |
| 49 | 'subjectid' => 'ID', |
| 50 | 'scopeids' => 'Standort IDs', |
| 51 | 'date' => 'Datum', |
| 52 | 'notificationscount' => 'SMS*', |
| 53 | 'notificationscost' => 'SMS-Kosten**', |
| 54 | 'clientscount' => 'Kunden Erschienen', |
| 55 | 'missed' => 'Kunden Nicht Erschienen', |
| 56 | 'withappointment' => 'davon Terminkunden Erschienen', |
| 57 | 'missedwithappointment' => 'davon Terminkunden Nicht Erschienen', |
| 58 | 'noappointment' => 'davon Spontankunden Erschienen', |
| 59 | 'missednoappointment' => 'davon Spontankunden Nicht Erschienen', |
| 60 | 'requestscount' => 'Dienstleistungen', |
| 61 | 'organisationname' => 'Organisation', |
| 62 | 'departmentname' => 'Behörde', |
| 63 | 'scopename' => 'Standort' |
| 64 | ]; |
| 65 | |
| 66 | protected function writeInfoHeader(array $args, Spreadsheet $spreadsheet) |
| 67 | { |
| 68 | $sheet = $spreadsheet->getActiveSheet(); |
| 69 | $infoData[] = static::$subjectTranslations[$args['category']]; |
| 70 | if (isset($args['selectedScopes'])) { |
| 71 | try { |
| 72 | $scopesResult = \App::$http->readGetResult('/scope/')->getData(); |
| 73 | $scopeMap = []; |
| 74 | foreach ($scopesResult as $scope) { |
| 75 | $scopeMap[$scope->id] = $scope; |
| 76 | } |
| 77 | foreach ($args['selectedScopes'] as $scopeId) { |
| 78 | if (isset($scopeMap[$scopeId])) { |
| 79 | $infoData[] = $scopeMap[$scopeId]->provider->name . " " . $scopeMap[$scopeId]->shortName; |
| 80 | } |
| 81 | } |
| 82 | } catch (Exception $exception) { |
| 83 | return null; |
| 84 | } |
| 85 | } else { |
| 86 | if (isset($args['organisation'])) { |
| 87 | $infoData[] = $args['organisation']['name'] ; |
| 88 | } |
| 89 | if (isset($args['department'])) { |
| 90 | $infoData[] = $args['department']['name']; |
| 91 | } |
| 92 | if (isset($args['scope'])) { |
| 93 | $infoData[] = $args['scope']['contact']['name'] . ' ' . $args['scope']['shortName']; |
| 94 | } |
| 95 | } |
| 96 | |
| 97 | $infoData = array_chunk($infoData, 1); |
| 98 | $sheet->fromArray($infoData, null, 'A' . $sheet->getHighestRow()); |
| 99 | |
| 100 | if (isset($args['reports'][0]->firstDay)) { |
| 101 | $firstDay = $args['reports'][0]->firstDay->toDateTime()->format('d.m.Y'); |
| 102 | $lastDay = $args['reports'][0]->lastDay->toDateTime()->format('d.m.Y'); |
| 103 | $range = array('Zeitraum:', $firstDay, 'bis', $lastDay); |
| 104 | $sheet->fromArray($range, null, 'A' . ($sheet->getHighestRow() + 1)); |
| 105 | } |
| 106 | |
| 107 | return $spreadsheet; |
| 108 | } |
| 109 | |
| 110 | protected function setDateTime($dateString) |
| 111 | { |
| 112 | $dateArr = explode('-', $dateString); |
| 113 | if (2 == count($dateArr)) { |
| 114 | $dateString = $dateString . '-01'; |
| 115 | } |
| 116 | /* ignore because not in use now */ |
| 117 | //@codeCoverageIgnoreStart |
| 118 | if (1 == count($dateArr)) { |
| 119 | $dateString = $dateString . '-01-01'; |
| 120 | } |
| 121 | //@codeCoverageIgnoreEnd |
| 122 | return new \DateTime($dateString); |
| 123 | } |
| 124 | |
| 125 | protected function getFormatedDates($date, $pattern = 'MMMM') |
| 126 | { |
| 127 | $dateFormatter = new \IntlDateFormatter( |
| 128 | 'de-DE', |
| 129 | \IntlDateFormatter::MEDIUM, |
| 130 | \IntlDateFormatter::MEDIUM, |
| 131 | \App::TIMEZONE, |
| 132 | \IntlDateFormatter::GREGORIAN, |
| 133 | $pattern |
| 134 | ); |
| 135 | |
| 136 | return $dateFormatter->format($date->getTimestamp()); |
| 137 | } |
| 138 | } |