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
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
<?php
/**
* Copyright © Magento, Inc. All rights reserved.
* See COPYING.txt for license details.
*/
namespace Magento\Analytics\ReportXml\DB\Assembler;
use Magento\Analytics\ReportXml\DB\NameResolver;
use Magento\Analytics\ReportXml\DB\SelectBuilder;
use Magento\Analytics\ReportXml\DB\ConditionResolver;
use Magento\Analytics\ReportXml\DB\ColumnsResolver;
use Magento\Framework\App\ResourceConnection;
/**
* Assembles JOIN conditions
*/
class JoinAssembler implements AssemblerInterface
{
/**
* @var ConditionResolver
*/
private $conditionResolver;
/**
* @var NameResolver
*/
private $nameResolver;
/**
* @var ColumnsResolver
*/
private $columnsResolver;
/**
* @var ResourceConnection
*/
private $resourceConnection;
/**
* @param ConditionResolver $conditionResolver
* @param ColumnsResolver $columnsResolver
* @param NameResolver $nameResolver
* @param ResourceConnection $resourceConnection
*/
public function __construct(
ConditionResolver $conditionResolver,
ColumnsResolver $columnsResolver,
NameResolver $nameResolver,
ResourceConnection $resourceConnection
) {
$this->conditionResolver = $conditionResolver;
$this->nameResolver = $nameResolver;
$this->columnsResolver = $columnsResolver;
$this->resourceConnection = $resourceConnection;
}
/**
* Assembles JOIN conditions
*
* @param SelectBuilder $selectBuilder
* @param array $queryConfig
* @return SelectBuilder
*/
public function assemble(SelectBuilder $selectBuilder, $queryConfig)
{
if (!isset($queryConfig['source']['link-source'])) {
return $selectBuilder;
}
$joins = [];
$filters = $selectBuilder->getFilters();
$sourceAlias = $this->nameResolver->getAlias($queryConfig['source']);
foreach ($queryConfig['source']['link-source'] as $join) {
$joinAlias = $this->nameResolver->getAlias($join);
$joins[$joinAlias] = [
'link-type' => isset($join['link-type']) ? $join['link-type'] : 'left',
'table' => [
$joinAlias => $this->resourceConnection
->getTableName($this->nameResolver->getName($join)),
],
'condition' => $this->conditionResolver->getFilter(
$selectBuilder,
$join['using'],
$joinAlias,
$sourceAlias
)
];
if (isset($join['filter'])) {
$filters = array_merge(
$filters,
[
$this->conditionResolver->getFilter(
$selectBuilder,
$join['filter'],
$joinAlias,
$sourceAlias
)
]
);
}
$columns = $this->columnsResolver->getColumns($selectBuilder, isset($join['attribute']) ? $join : []);
$selectBuilder->setColumns(array_merge($selectBuilder->getColumns(), $columns));
}
$selectBuilder->setFilters($filters);
$selectBuilder->setJoins(array_merge($selectBuilder->getJoins(), $joins));
return $selectBuilder;
}
}