1 files changed, 61 insertions, 0 deletions
diff --git a/www/crm/wp-content/plugins/civicrm/civicrm/ext/api4/Civi/Api4/Service/Schema/Joinable/OptionValueJoinable.php b/www/crm/wp-content/plugins/civicrm/civicrm/ext/api4/Civi/Api4/Service/Schema/Joinable/OptionValueJoinable.php
new file mode 100644
index 00000000..96f65488
--- /dev/null
+++ b/www/crm/wp-content/plugins/civicrm/civicrm/ext/api4/Civi/Api4/Service/Schema/Joinable/OptionValueJoinable.php
@@ -0,0 +1,61 @@
+<?php
+
+namespace Civi\Api4\Service\Schema\Joinable;
+
+class OptionValueJoinable extends Joinable {
+  /**
+   * @var string
+   */
+  protected $optionGroupName;
+
+  /**
+   * @param string $optionGroup
+   *   Can be either the option group name or ID
+   * @param string|null $alias
+   *   The join alias
+   * @param string $keyColumn
+   *   Which column to use to join, defaults to "value"
+   */
+  public function __construct($optionGroup, $alias = NULL, $keyColumn = 'value') {
+    $this->optionGroupName = $optionGroup;
+    $optionValueTable = 'civicrm_option_value';
+
+    // default join alias to option group name, e.g. activity_type
+    if (!$alias && !is_numeric($optionGroup)) {
+      $alias = $optionGroup;
+    }
+
+    parent::__construct($optionValueTable, $keyColumn, $alias);
+
+    if (!is_numeric($optionGroup)) {
+      $subSelect = 'SELECT id FROM civicrm_option_group WHERE name = "%s"';
+      $subQuery = sprintf($subSelect, $optionGroup);
+      $condition = sprintf('%s.option_group_id = (%s)', $alias, $subQuery);
+    }
+    else {
+      $condition = sprintf('%s.option_group_id = %d', $alias, $optionGroup);
+    }
+
+    $this->addCondition($condition);
+  }
+
+  /**
+   * The existing condition must also be re-aliased
+   *
+   * @param string $alias
+   *
+   * @return $this
+   */
+  public function setAlias($alias) {
+    foreach ($this->conditions as $index => $condition) {
+      $search = $this->alias . '.';
+      $replace = $alias . '.';
+      $this->conditions[$index] = str_replace($search, $replace, $condition);
+    }
+
+    parent::setAlias($alias);
+
+    return $this;
+  }
+
+}