Version 1

[yaffs-website] / web / core / modules / comment / src / Plugin / views / sort / StatisticsLastUpdated.php

diff --git a/web/core/modules/comment/src/Plugin/views/sort/StatisticsLastUpdated.php b/web/core/modules/comment/src/Plugin/views/sort/StatisticsLastUpdated.php
new file mode 100644 (file)
index 0000000..0f9c055
--- /dev/null
+++ b/web/core/modules/comment/src/Plugin/views/sort/StatisticsLastUpdated.php
@@ -0,0 +1,22 @@
+<?php
+
+namespace Drupal\comment\Plugin\views\sort;
+
+use Drupal\views\Plugin\views\sort\Date;
+
+/**
+ * Sort handler for the newer of last comment / entity updated.
+ *
+ * @ingroup views_sort_handlers
+ *
+ * @ViewsSort("comment_ces_last_updated")
+ */
+class StatisticsLastUpdated extends Date {
+
+  public function query() {
+    $this->ensureMyTable();
+    $this->node_table = $this->query->ensureTable('node', $this->relationship);
+    $this->field_alias = $this->query->addOrderBy(NULL, "GREATEST(" . $this->node_table . ".changed, " . $this->tableAlias . ".last_comment_timestamp)", $this->options['order'], $this->tableAlias . '_' . $this->field);
+  }
+
+}