1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
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;
}
}
|
