blob: ea5a6a559d64401634e5ad1e4a897383d45519de (
plain)
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
|
<?php
/**
* Matomo - free/libre analytics platform
*
* @link https://matomo.org
* @license http://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later
*
*/
namespace Piwik\Plugins\Ecommerce;
use Piwik\Columns\ComputedMetricFactory;
use Piwik\Columns\MetricsList;
use Piwik\Common;
use Piwik\Plugin\ArchivedMetric;
use Piwik\Plugin\ComputedMetric;
use Piwik\Plugins\Ecommerce\Columns\ProductCategory;
/**
*
*/
class Ecommerce extends \Piwik\Plugin
{
/**
* @see \Piwik\Plugin::registerEvents
*/
public function registerEvents()
{
return [
'Metric.addComputedMetrics' => 'addComputedMetrics',
'Actions.getCustomActionDimensionFieldsAndJoins' => 'provideActionDimensionFields'
];
}
public function provideActionDimensionFields(&$fields, &$joins)
{
$fields[] = 'log_link_visit_action.product_price as productViewPrice';
$fields[] = 'log_action_productview_name.name as productViewName';
$fields[] = 'log_action_productview_sku.name as productViewSku';
$joins[] = 'LEFT JOIN ' . Common::prefixTable('log_action') . ' AS log_action_productview_name
ON log_link_visit_action.idaction_product_name = log_action_productview_name.idaction';
$joins[] = 'LEFT JOIN ' . Common::prefixTable('log_action') . ' AS log_action_productview_sku
ON log_link_visit_action.idaction_product_sku = log_action_productview_sku.idaction';
for($i = 1; $i <= ProductCategory::PRODUCT_CATEGORY_COUNT; $i++) {
$suffix = $i > 1 ? $i : '';
$fields[] = "log_action_productview_category$i.name as productViewCategory$i";
$joins[] = "LEFT JOIN " . Common::prefixTable('log_action') . " AS log_action_productview_category$i
ON log_link_visit_action.idaction_product_cat$suffix = log_action_productview_category$i.idaction";
}
}
public function addComputedMetrics(MetricsList $list, ComputedMetricFactory $computedMetricFactory)
{
$category = 'Goals_Ecommerce';
$metrics = $list->getMetrics();
foreach ($metrics as $metric) {
if ($metric instanceof ArchivedMetric && $metric->getDimension()) {
$metricName = $metric->getName();
if ($metric->getDbTableName() === 'log_conversion'
&& $metricName !== 'nb_uniq_orders'
&& strpos($metricName, ArchivedMetric::AGGREGATION_SUM_PREFIX) === 0
&& $metric->getCategoryId() === $category) {
$metric = $computedMetricFactory->createComputedMetric($metric->getName(), 'nb_uniq_orders', ComputedMetric::AGGREGATION_AVG);
$list->addMetric($metric);
}
}
}
}
}
|
