Coverage index

src/Plugin/views/field/MediaSpentTime.php

Lines: 51.85%

LineHitsSource
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() {
202
    $this->ensureMyTable();
212
    $alias = $this->tableAlias . '__spent_time';
222
    foreach ($this->query->fields as $field_info) {
232
      if (!empty($field_info['alias']) && $field_info['alias'] === $alias) {
240
        $this->field_alias = $alias;
250
        return;
26
      }
27
    }
282
    $this->field_alias = $this->query->addField($this->tableAlias, 'spent_time', $alias, [
292
      'function' => 'sum',
302
      'aggregate' => TRUE,
312
    ]);
32
  }
33
34
  /**
35
   * {@inheritdoc}
36
   */
37
  public function render($values) {
381
    $value = $this->getValue($values);
391
    if ($value === NULL || $value === '') {
400
      return '';
41
    }
421
    return $this->formatSeconds((int) $value);
43
  }
44
45
  /**
46
   * {@inheritdoc}
47
   */
48
  public function usesGroupBy() {
490
    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 {
621
    $seconds = max(0, $seconds);
631
    if ($seconds < 60) {
641
      return $seconds . 's';
65
    }
660
    $minutes = intdiv($seconds, 60);
670
    $remain = $seconds % 60;
680
    if ($minutes < 60) {
690
      return $remain === 0 ? $minutes . 'm' : $minutes . 'm ' . $remain . 's';
70
    }
710
    $hours = intdiv($minutes, 60);
720
    $minutes %= 60;
730
    if ($minutes === 0) {
740
      return $hours . 'h';
75
    }
760
    return $hours . 'h ' . $minutes . 'm';
77
  }
78
79
}