Version 1

[yaffs-website] / web / core / modules / node / src / Plugin / views / argument / UidRevision.php

diff --git a/web/core/modules/node/src/Plugin/views/argument/UidRevision.php b/web/core/modules/node/src/Plugin/views/argument/UidRevision.php
new file mode 100644 (file)
index 0000000..0f989a7
--- /dev/null
+++ b/web/core/modules/node/src/Plugin/views/argument/UidRevision.php
@@ -0,0 +1,21 @@
+<?php
+
+namespace Drupal\node\Plugin\views\argument;
+
+use Drupal\user\Plugin\views\argument\Uid;
+
+/**
+ * Filter handler to accept a user id to check for nodes that
+ * user posted or created a revision on.
+ *
+ * @ViewsArgument("node_uid_revision")
+ */
+class UidRevision extends Uid {
+
+  public function query($group_by = FALSE) {
+    $this->ensureMyTable();
+    $placeholder = $this->placeholder();
+    $this->query->addWhereExpression(0, "$this->tableAlias.uid = $placeholder OR ((SELECT COUNT(DISTINCT vid) FROM {node_revision} nr WHERE nr.revision_uid = $placeholder AND nr.nid = $this->tableAlias.nid) > 0)", [$placeholder => $this->argument]);
+  }
+
+}