Lines: 51.85%
| Line | Hits | Source |
|---|---|---|
| 1 | <?php | |
| 2 | ||
| 3 | declare(strict_types=1); | |
| 4 | ||
| 5 | namespace Drupal\visitors\Plugin\views\field; | |
| 6 | ||
| 7 | use Drupal\views\Attribute\ViewsField; | |
| 8 | use Drupal\views\Plugin\views\field\FieldPluginBase; | |
| 9 | ||
| 10 | /** | |
| 11 | * Formats the summed seconds a media item was playing. | |
| 12 | */ | |
| 13 | #[ViewsField("visitors_media_spent_time")] | |
| 14 | class MediaSpentTime extends FieldPluginBase { | |
| 15 | ||
| 16 | /** | |
| 17 | * {@inheritdoc} | |
| 18 | */ | |
| 19 | public function query() { | |
| 20 | 2 | $this->ensureMyTable(); |
| 21 | 2 | $alias = $this->tableAlias . '__spent_time'; |
| 22 | 2 | foreach ($this->query->fields as $field_info) { |
| 23 | 2 | if (!empty($field_info['alias']) && $field_info['alias'] === $alias) { |
| 24 | 0 | $this->field_alias = $alias; |
| 25 | 0 | return; |
| 26 | } | |
| 27 | } | |
| 28 | 2 | $this->field_alias = $this->query->addField($this->tableAlias, 'spent_time', $alias, [ |
| 29 | 2 | 'function' => 'sum', |
| 30 | 2 | 'aggregate' => TRUE, |
| 31 | 2 | ]); |
| 32 | } | |
| 33 | ||
| 34 | /** | |
| 35 | * {@inheritdoc} | |
| 36 | */ | |
| 37 | public function render($values) { | |
| 38 | 1 | $value = $this->getValue($values); |
| 39 | 1 | if ($value === NULL || $value === '') { |
| 40 | 0 | return ''; |
| 41 | } | |
| 42 | 1 | return $this->formatSeconds((int) $value); |
| 43 | } | |
| 44 | ||
| 45 | /** | |
| 46 | * {@inheritdoc} | |
| 47 | */ | |
| 48 | public function usesGroupBy() { | |
| 49 | 0 | return FALSE; |
| 50 | } | |
| 51 | ||
| 52 | /** | |
| 53 | * Formats a duration. | |
| 54 | * | |
| 55 | * @param int $seconds | |
| 56 | * The duration in seconds. | |
| 57 | * | |
| 58 | * @return string | |
| 59 | * A short duration, such as 45s or 1m 3s. | |
| 60 | */ | |
| 61 | protected function formatSeconds(int $seconds): string { | |
| 62 | 1 | $seconds = max(0, $seconds); |
| 63 | 1 | if ($seconds < 60) { |
| 64 | 1 | return $seconds . 's'; |
| 65 | } | |
| 66 | 0 | $minutes = intdiv($seconds, 60); |
| 67 | 0 | $remain = $seconds % 60; |
| 68 | 0 | if ($minutes < 60) { |
| 69 | 0 | return $remain === 0 ? $minutes . 'm' : $minutes . 'm ' . $remain . 's'; |
| 70 | } | |
| 71 | 0 | $hours = intdiv($minutes, 60); |
| 72 | 0 | $minutes %= 60; |
| 73 | 0 | if ($minutes === 0) { |
| 74 | 0 | return $hours . 'h'; |
| 75 | } | |
| 76 | 0 | return $hours . 'h ' . $minutes . 'm'; |
| 77 | } | |
| 78 | ||
| 79 | } |