diff options
| author | Thomas Steur <tsteur@users.noreply.github.com> | 2020-10-01 09:34:26 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-10-01 09:34:26 +0300 |
| commit | a35192e5e1ba4d1a01a38f991363dab7989c7d19 (patch) | |
| tree | 3d38a2d425add0defd0f3e4a542d987b8223f7bc /plugins/Actions | |
| parent | fd14a155269038f6fe12ce31db20f8ebffaf00c5 (diff) | |
Add page performance query only if page performance plugin is activated (#16500)
Diffstat (limited to 'plugins/Actions')
| -rw-r--r-- | plugins/Actions/VisitorDetails.php | 18 |
1 files changed, 12 insertions, 6 deletions
diff --git a/plugins/Actions/VisitorDetails.php b/plugins/Actions/VisitorDetails.php index 623c8a55f4..4aed002314 100644 --- a/plugins/Actions/VisitorDetails.php +++ b/plugins/Actions/VisitorDetails.php @@ -14,6 +14,7 @@ use Piwik\Date; use Piwik\Db; use Piwik\Metrics\Formatter; use Piwik\Piwik; +use Piwik\Plugin; use Piwik\Plugins\Live\VisitorDetailsAbstract; use Piwik\Site; use Piwik\Tracker\Action; @@ -269,6 +270,16 @@ class VisitorDetails extends VisitorDetailsAbstract // The second join is a LEFT join to allow returning records that don't have a matching page title // eg. Downloads, Outlinks. For these, idaction_name is set to 0 + $pagePerformanceSelect = ''; + if (Plugin\Manager::getInstance()->isPluginActivated('PagePerformance')) { + $pagePerformanceSelect = '( log_link_visit_action.time_network + + log_link_visit_action.time_server + + log_link_visit_action.time_transfer + + log_link_visit_action.time_dom_completion + + log_link_visit_action.time_dom_processing + + log_link_visit_action.time_on_load ) AS pageLoadTime,'; + } + $sql = " SELECT log_link_visit_action.idvisit, @@ -283,12 +294,7 @@ class VisitorDetails extends VisitorDetailsAbstract log_link_visit_action.time_spent_ref_action as timeSpentRef, log_link_visit_action.idlink_va AS pageId, log_link_visit_action.custom_float, - ( log_link_visit_action.time_network + - log_link_visit_action.time_server + - log_link_visit_action.time_transfer + - log_link_visit_action.time_dom_completion + - log_link_visit_action.time_dom_processing + - log_link_visit_action.time_on_load ) AS pageLoadTime, + $pagePerformanceSelect log_link_visit_action.pageview_position, log_link_visit_action.search_cat, log_link_visit_action.search_count |