Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/matomo-org/matomo.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authormattab <matthieu.aubry@gmail.com>2013-07-20 11:09:46 +0400
committermattab <matthieu.aubry@gmail.com>2013-07-20 11:09:46 +0400
commit0a63210e3eae7562af1a3dbee340eb1ee140db3d (patch)
treec9f7c3a36a4b344b25c12aa04fed0733efb3bfa0 /plugins/Actions
parent7ca35544d15cdb41b17283e693c8a14777c923ad (diff)
Converting to namespace: Period*, Metrics, Segment, SegmentExpression, PluginsManager
Diffstat (limited to 'plugins/Actions')
-rw-r--r--plugins/Actions/API.php17
-rw-r--r--plugins/Actions/Actions.php7
-rw-r--r--plugins/Actions/Archiver.php129
-rw-r--r--plugins/Actions/ArchivingHelper.php49
-rw-r--r--plugins/Actions/Controller.php2
5 files changed, 104 insertions, 100 deletions
diff --git a/plugins/Actions/API.php b/plugins/Actions/API.php
index 3c824c574f..0262f807e0 100644
--- a/plugins/Actions/API.php
+++ b/plugins/Actions/API.php
@@ -9,6 +9,7 @@
* @package Piwik_Actions
*/
use Piwik\Archive;
+use Piwik\Metrics;
use Piwik\Piwik;
use Piwik\Common;
@@ -277,7 +278,7 @@ class Piwik_Actions_API
public function getSiteSearchKeywords($idSite, $period, $date, $segment = false)
{
$dataTable = $this->getSiteSearchKeywordsRaw($idSite, $period, $date, $segment);
- $dataTable->deleteColumn(Piwik_Metrics::INDEX_SITE_SEARCH_HAS_NO_RESULT);
+ $dataTable->deleteColumn(Metrics::INDEX_SITE_SEARCH_HAS_NO_RESULT);
$this->filterPageDatatable($dataTable);
$this->filterActionsDataTable($dataTable);
$this->addPagesPerSearchColumn($dataTable);
@@ -302,11 +303,11 @@ class Piwik_Actions_API
// Delete all rows that have some results
$dataTable->filter('ColumnCallbackDeleteRow',
array(
- Piwik_Metrics::INDEX_SITE_SEARCH_HAS_NO_RESULT,
+ Metrics::INDEX_SITE_SEARCH_HAS_NO_RESULT,
create_function('$value', 'return $value >= 1;')
));
$dataTable->deleteRow(Piwik_DataTable::ID_SUMMARY_ROW);
- $dataTable->deleteColumn(Piwik_Metrics::INDEX_SITE_SEARCH_HAS_NO_RESULT);
+ $dataTable->deleteColumn(Metrics::INDEX_SITE_SEARCH_HAS_NO_RESULT);
$this->filterPageDatatable($dataTable);
$this->filterActionsDataTable($dataTable);
$this->addPagesPerSearchColumn($dataTable);
@@ -472,7 +473,7 @@ class Piwik_Actions_API
$dataTable->queueFilter('ColumnCallbackAddColumnPercentage', array('exit_rate', 'exit_nb_visits', 'nb_visits', 0));
// Handle performance analytics
- $hasTimeGeneration = (array_sum($dataTable->getColumn(Piwik_Metrics::INDEX_PAGE_SUM_TIME_GENERATION)) > 0);
+ $hasTimeGeneration = (array_sum($dataTable->getColumn(Metrics::INDEX_PAGE_SUM_TIME_GENERATION)) > 0);
if ($hasTimeGeneration) {
// Average generation time = total generation time / number of pageviews
$precisionAvgTimeGeneration = 3;
@@ -482,10 +483,10 @@ class Piwik_Actions_API
// No generation time: remove it from the API output and add it to empty_columns metadata, so that
// the columns can also be removed from the view
$dataTable->filter('ColumnDelete', array(array(
- Piwik_Metrics::INDEX_PAGE_SUM_TIME_GENERATION,
- Piwik_Metrics::INDEX_PAGE_NB_HITS_WITH_TIME_GENERATION,
- Piwik_Metrics::INDEX_PAGE_MIN_TIME_GENERATION,
- Piwik_Metrics::INDEX_PAGE_MAX_TIME_GENERATION
+ Metrics::INDEX_PAGE_SUM_TIME_GENERATION,
+ Metrics::INDEX_PAGE_NB_HITS_WITH_TIME_GENERATION,
+ Metrics::INDEX_PAGE_MIN_TIME_GENERATION,
+ Metrics::INDEX_PAGE_MAX_TIME_GENERATION
)));
if ($dataTable instanceof Piwik_DataTable) {
diff --git a/plugins/Actions/Actions.php b/plugins/Actions/Actions.php
index cb8716aba0..03109bfdb9 100644
--- a/plugins/Actions/Actions.php
+++ b/plugins/Actions/Actions.php
@@ -10,6 +10,7 @@
*/
use Piwik\Piwik;
use Piwik\Common;
+use Piwik\SegmentExpression;
use Piwik\Site;
/**
@@ -148,8 +149,8 @@ class Piwik_Actions extends Piwik_Plugin
$valueToMatch = Common::sanitizeInputValue(Common::unsanitizeInputValue($valueToMatch));
// exact matches work by returning the id directly
- if ($matchType == Piwik_SegmentExpression::MATCH_EQUAL
- || $matchType == Piwik_SegmentExpression::MATCH_NOT_EQUAL
+ if ($matchType == SegmentExpression::MATCH_EQUAL
+ || $matchType == SegmentExpression::MATCH_NOT_EQUAL
) {
$sql = Piwik_Tracker_Action::getSqlSelectActionId();
$bind = array($valueToMatch, $valueToMatch, $actionType);
@@ -596,7 +597,7 @@ class Piwik_Actions extends Piwik_Plugin
static protected function isCustomVariablesPluginsEnabled()
{
- return Piwik_PluginsManager::getInstance()->isPluginActivated('CustomVariables');
+ return PluginsManager::getInstance()->isPluginActivated('CustomVariables');
}
/**
diff --git a/plugins/Actions/Archiver.php b/plugins/Actions/Archiver.php
index c4a2bf24af..f512bd36ea 100644
--- a/plugins/Actions/Archiver.php
+++ b/plugins/Actions/Archiver.php
@@ -9,6 +9,7 @@
* @package Piwik_Actions
*/
use Piwik\Config;
+use Piwik\Metrics;
/**
* Class encapsulating logic to process Day/Period Archiving for the Actions reports
@@ -54,18 +55,18 @@ class Piwik_Actions_Archiver extends Piwik_PluginsArchiver
Piwik_Tracker_Action::TYPE_SITE_SEARCH,
);
static protected $invalidSummedColumnNameToRenamedNameFromPeriodArchive = array(
- Piwik_Metrics::INDEX_NB_UNIQ_VISITORS => Piwik_Metrics::INDEX_SUM_DAILY_NB_UNIQ_VISITORS,
- Piwik_Metrics::INDEX_PAGE_ENTRY_NB_UNIQ_VISITORS => Piwik_Metrics::INDEX_PAGE_ENTRY_SUM_DAILY_NB_UNIQ_VISITORS,
- Piwik_Metrics::INDEX_PAGE_EXIT_NB_UNIQ_VISITORS => Piwik_Metrics::INDEX_PAGE_EXIT_SUM_DAILY_NB_UNIQ_VISITORS,
+ Metrics::INDEX_NB_UNIQ_VISITORS => Metrics::INDEX_SUM_DAILY_NB_UNIQ_VISITORS,
+ Metrics::INDEX_PAGE_ENTRY_NB_UNIQ_VISITORS => Metrics::INDEX_PAGE_ENTRY_SUM_DAILY_NB_UNIQ_VISITORS,
+ Metrics::INDEX_PAGE_EXIT_NB_UNIQ_VISITORS => Metrics::INDEX_PAGE_EXIT_SUM_DAILY_NB_UNIQ_VISITORS,
);
static protected $invalidSummedColumnNameToDeleteFromDayArchive = array(
- Piwik_Metrics::INDEX_NB_UNIQ_VISITORS,
- Piwik_Metrics::INDEX_PAGE_ENTRY_NB_UNIQ_VISITORS,
- Piwik_Metrics::INDEX_PAGE_EXIT_NB_UNIQ_VISITORS,
+ Metrics::INDEX_NB_UNIQ_VISITORS,
+ Metrics::INDEX_PAGE_ENTRY_NB_UNIQ_VISITORS,
+ Metrics::INDEX_PAGE_EXIT_NB_UNIQ_VISITORS,
);
private static $actionColumnAggregationOperations = array(
- Piwik_Metrics::INDEX_PAGE_MAX_TIME_GENERATION => 'max',
- Piwik_Metrics::INDEX_PAGE_MIN_TIME_GENERATION => 'min'
+ Metrics::INDEX_PAGE_MAX_TIME_GENERATION => 'max',
+ Metrics::INDEX_PAGE_MIN_TIME_GENERATION => 'min'
);
protected $actionsTablesByType = null;
protected $isSiteSearchEnabled = false;
@@ -171,25 +172,25 @@ class Piwik_Actions_Archiver extends Piwik_PluginsArchiver
log_action.type,
log_action.idaction,
log_action.url_prefix,
- count(distinct log_link_visit_action.idvisit) as `" . Piwik_Metrics::INDEX_NB_VISITS . "`,
- count(distinct log_link_visit_action.idvisitor) as `" . Piwik_Metrics::INDEX_NB_UNIQ_VISITORS . "`,
- count(*) as `" . Piwik_Metrics::INDEX_PAGE_NB_HITS . "`,
+ count(distinct log_link_visit_action.idvisit) as `" . Metrics::INDEX_NB_VISITS . "`,
+ count(distinct log_link_visit_action.idvisitor) as `" . Metrics::INDEX_NB_UNIQ_VISITORS . "`,
+ count(*) as `" . Metrics::INDEX_PAGE_NB_HITS . "`,
sum(
case when " . Piwik_Tracker_Action::DB_COLUMN_TIME_GENERATION . " is null
then 0
else " . Piwik_Tracker_Action::DB_COLUMN_TIME_GENERATION . "
end
- ) / 1000 as `" . Piwik_Metrics::INDEX_PAGE_SUM_TIME_GENERATION . "`,
+ ) / 1000 as `" . Metrics::INDEX_PAGE_SUM_TIME_GENERATION . "`,
sum(
case when " . Piwik_Tracker_Action::DB_COLUMN_TIME_GENERATION . " is null
then 0
else 1
end
- ) as `" . Piwik_Metrics::INDEX_PAGE_NB_HITS_WITH_TIME_GENERATION . "`,
+ ) as `" . Metrics::INDEX_PAGE_NB_HITS_WITH_TIME_GENERATION . "`,
min(" . Piwik_Tracker_Action::DB_COLUMN_TIME_GENERATION . ") / 1000
- as `" . Piwik_Metrics::INDEX_PAGE_MIN_TIME_GENERATION . "`,
+ as `" . Metrics::INDEX_PAGE_MIN_TIME_GENERATION . "`,
max(" . Piwik_Tracker_Action::DB_COLUMN_TIME_GENERATION . ") / 1000
- as `" . Piwik_Metrics::INDEX_PAGE_MAX_TIME_GENERATION . "`
+ as `" . Metrics::INDEX_PAGE_MAX_TIME_GENERATION . "`
";
$from = array(
@@ -206,23 +207,23 @@ class Piwik_Actions_Archiver extends Piwik_PluginsArchiver
AND log_link_visit_action.%s IS NOT NULL";
$groupBy = "log_action.idaction";
- $orderBy = "`" . Piwik_Metrics::INDEX_PAGE_NB_HITS . "` DESC, name ASC";
+ $orderBy = "`" . Metrics::INDEX_PAGE_NB_HITS . "` DESC, name ASC";
$rankingQuery = false;
if ($rankingQueryLimit > 0) {
$rankingQuery = new Piwik_RankingQuery($rankingQueryLimit);
$rankingQuery->setOthersLabel(Piwik_DataTable::LABEL_SUMMARY_ROW);
$rankingQuery->addLabelColumn(array('idaction', 'name'));
- $rankingQuery->addColumn(array('url_prefix', Piwik_Metrics::INDEX_NB_UNIQ_VISITORS));
- $rankingQuery->addColumn(array(Piwik_Metrics::INDEX_PAGE_NB_HITS, Piwik_Metrics::INDEX_NB_VISITS), 'sum');
+ $rankingQuery->addColumn(array('url_prefix', Metrics::INDEX_NB_UNIQ_VISITORS));
+ $rankingQuery->addColumn(array(Metrics::INDEX_PAGE_NB_HITS, Metrics::INDEX_NB_VISITS), 'sum');
if ($this->isSiteSearchEnabled()) {
- $rankingQuery->addColumn(Piwik_Metrics::INDEX_SITE_SEARCH_HAS_NO_RESULT, 'min');
- $rankingQuery->addColumn(Piwik_Metrics::INDEX_PAGE_IS_FOLLOWING_SITE_SEARCH_NB_HITS, 'sum');
+ $rankingQuery->addColumn(Metrics::INDEX_SITE_SEARCH_HAS_NO_RESULT, 'min');
+ $rankingQuery->addColumn(Metrics::INDEX_PAGE_IS_FOLLOWING_SITE_SEARCH_NB_HITS, 'sum');
}
- $rankingQuery->addColumn(Piwik_Metrics::INDEX_PAGE_SUM_TIME_GENERATION, 'sum');
- $rankingQuery->addColumn(Piwik_Metrics::INDEX_PAGE_NB_HITS_WITH_TIME_GENERATION, 'sum');
- $rankingQuery->addColumn(Piwik_Metrics::INDEX_PAGE_MIN_TIME_GENERATION, 'min');
- $rankingQuery->addColumn(Piwik_Metrics::INDEX_PAGE_MAX_TIME_GENERATION, 'max');
+ $rankingQuery->addColumn(Metrics::INDEX_PAGE_SUM_TIME_GENERATION, 'sum');
+ $rankingQuery->addColumn(Metrics::INDEX_PAGE_NB_HITS_WITH_TIME_GENERATION, 'sum');
+ $rankingQuery->addColumn(Metrics::INDEX_PAGE_MIN_TIME_GENERATION, 'min');
+ $rankingQuery->addColumn(Metrics::INDEX_PAGE_MAX_TIME_GENERATION, 'max');
$rankingQuery->partitionResultIntoMultipleGroups('type', array_keys($this->actionsTablesByType));
}
@@ -231,7 +232,7 @@ class Piwik_Actions_Archiver extends Piwik_PluginsArchiver
// 2) For each page view, count number of times the referrer page was a Site Search
if ($this->isSiteSearchEnabled()) {
$selectFlagNoResultKeywords = ",
- CASE WHEN (MAX(log_link_visit_action.custom_var_v" . Piwik_Tracker_Action::CVAR_INDEX_SEARCH_COUNT . ") = 0 AND log_link_visit_action.custom_var_k" . Piwik_Tracker_Action::CVAR_INDEX_SEARCH_COUNT . " = '" . Piwik_Tracker_Action::CVAR_KEY_SEARCH_COUNT . "') THEN 1 ELSE 0 END AS `" . Piwik_Metrics::INDEX_SITE_SEARCH_HAS_NO_RESULT . "`";
+ CASE WHEN (MAX(log_link_visit_action.custom_var_v" . Piwik_Tracker_Action::CVAR_INDEX_SEARCH_COUNT . ") = 0 AND log_link_visit_action.custom_var_k" . Piwik_Tracker_Action::CVAR_INDEX_SEARCH_COUNT . " = '" . Piwik_Tracker_Action::CVAR_KEY_SEARCH_COUNT . "') THEN 1 ELSE 0 END AS `" . Metrics::INDEX_SITE_SEARCH_HAS_NO_RESULT . "`";
//we need an extra JOIN to know whether the referrer "idaction_name_ref" was a Site Search request
$from[] = array(
@@ -241,7 +242,7 @@ class Piwik_Actions_Archiver extends Piwik_PluginsArchiver
);
$selectSiteSearchFollowingPages = ",
- SUM(CASE WHEN log_action_name_ref.type = " . Piwik_Tracker_Action::TYPE_SITE_SEARCH . " THEN 1 ELSE 0 END) AS `" . Piwik_Metrics::INDEX_PAGE_IS_FOLLOWING_SITE_SEARCH_NB_HITS . "`";
+ SUM(CASE WHEN log_action_name_ref.type = " . Piwik_Tracker_Action::TYPE_SITE_SEARCH . " THEN 1 ELSE 0 END) AS `" . Metrics::INDEX_PAGE_IS_FOLLOWING_SITE_SEARCH_NB_HITS . "`";
$select .= $selectFlagNoResultKeywords
. $selectSiteSearchFollowingPages;
@@ -292,11 +293,11 @@ class Piwik_Actions_Archiver extends Piwik_PluginsArchiver
$rankingQuery = new Piwik_RankingQuery($rankingQueryLimit);
$rankingQuery->setOthersLabel(Piwik_DataTable::LABEL_SUMMARY_ROW);
$rankingQuery->addLabelColumn('idaction');
- $rankingQuery->addColumn(Piwik_Metrics::INDEX_PAGE_ENTRY_NB_UNIQ_VISITORS);
- $rankingQuery->addColumn(array(Piwik_Metrics::INDEX_PAGE_ENTRY_NB_VISITS,
- Piwik_Metrics::INDEX_PAGE_ENTRY_NB_ACTIONS,
- Piwik_Metrics::INDEX_PAGE_ENTRY_SUM_VISIT_LENGTH,
- Piwik_Metrics::INDEX_PAGE_ENTRY_BOUNCE_COUNT), 'sum');
+ $rankingQuery->addColumn(Metrics::INDEX_PAGE_ENTRY_NB_UNIQ_VISITORS);
+ $rankingQuery->addColumn(array(Metrics::INDEX_PAGE_ENTRY_NB_VISITS,
+ Metrics::INDEX_PAGE_ENTRY_NB_ACTIONS,
+ Metrics::INDEX_PAGE_ENTRY_SUM_VISIT_LENGTH,
+ Metrics::INDEX_PAGE_ENTRY_BOUNCE_COUNT), 'sum');
$rankingQuery->partitionResultIntoMultipleGroups('type', array_keys($this->actionsTablesByType));
$extraSelects = 'log_action.type, log_action.name,';
@@ -307,7 +308,7 @@ class Piwik_Actions_Archiver extends Piwik_PluginsArchiver
"joinOn" => "log_visit.%s = log_action.idaction"
)
);
- $orderBy = "`" . Piwik_Metrics::INDEX_PAGE_ENTRY_NB_ACTIONS . "` DESC, log_action.name ASC";
+ $orderBy = "`" . Metrics::INDEX_PAGE_ENTRY_NB_ACTIONS . "` DESC, log_action.name ASC";
} else {
$extraSelects = false;
$from = "log_visit";
@@ -315,11 +316,11 @@ class Piwik_Actions_Archiver extends Piwik_PluginsArchiver
}
$select = "log_visit.%s as idaction, $extraSelects
- count(distinct log_visit.idvisitor) as `" . Piwik_Metrics::INDEX_PAGE_ENTRY_NB_UNIQ_VISITORS . "`,
- count(*) as `" . Piwik_Metrics::INDEX_PAGE_ENTRY_NB_VISITS . "`,
- sum(log_visit.visit_total_actions) as `" . Piwik_Metrics::INDEX_PAGE_ENTRY_NB_ACTIONS . "`,
- sum(log_visit.visit_total_time) as `" . Piwik_Metrics::INDEX_PAGE_ENTRY_SUM_VISIT_LENGTH . "`,
- sum(case log_visit.visit_total_actions when 1 then 1 when 0 then 1 else 0 end) as `" . Piwik_Metrics::INDEX_PAGE_ENTRY_BOUNCE_COUNT . "`";
+ count(distinct log_visit.idvisitor) as `" . Metrics::INDEX_PAGE_ENTRY_NB_UNIQ_VISITORS . "`,
+ count(*) as `" . Metrics::INDEX_PAGE_ENTRY_NB_VISITS . "`,
+ sum(log_visit.visit_total_actions) as `" . Metrics::INDEX_PAGE_ENTRY_NB_ACTIONS . "`,
+ sum(log_visit.visit_total_time) as `" . Metrics::INDEX_PAGE_ENTRY_SUM_VISIT_LENGTH . "`,
+ sum(case log_visit.visit_total_actions when 1 then 1 when 0 then 1 else 0 end) as `" . Metrics::INDEX_PAGE_ENTRY_BOUNCE_COUNT . "`";
$where = "log_visit.visit_last_action_time >= ?
AND log_visit.visit_last_action_time <= ?
@@ -343,8 +344,8 @@ class Piwik_Actions_Archiver extends Piwik_PluginsArchiver
$rankingQuery = new Piwik_RankingQuery($rankingQueryLimit);
$rankingQuery->setOthersLabel(Piwik_DataTable::LABEL_SUMMARY_ROW);
$rankingQuery->addLabelColumn('idaction');
- $rankingQuery->addColumn(Piwik_Metrics::INDEX_PAGE_EXIT_NB_UNIQ_VISITORS);
- $rankingQuery->addColumn(Piwik_Metrics::INDEX_PAGE_EXIT_NB_VISITS, 'sum');
+ $rankingQuery->addColumn(Metrics::INDEX_PAGE_EXIT_NB_UNIQ_VISITORS);
+ $rankingQuery->addColumn(Metrics::INDEX_PAGE_EXIT_NB_VISITS, 'sum');
$rankingQuery->partitionResultIntoMultipleGroups('type', array_keys($this->actionsTablesByType));
$extraSelects = 'log_action.type, log_action.name,';
@@ -355,7 +356,7 @@ class Piwik_Actions_Archiver extends Piwik_PluginsArchiver
"joinOn" => "log_visit.%s = log_action.idaction"
)
);
- $orderBy = "`" . Piwik_Metrics::INDEX_PAGE_EXIT_NB_VISITS . "` DESC, log_action.name ASC";
+ $orderBy = "`" . Metrics::INDEX_PAGE_EXIT_NB_VISITS . "` DESC, log_action.name ASC";
} else {
$extraSelects = false;
$from = "log_visit";
@@ -363,8 +364,8 @@ class Piwik_Actions_Archiver extends Piwik_PluginsArchiver
}
$select = "log_visit.%s as idaction, $extraSelects
- count(distinct log_visit.idvisitor) as `" . Piwik_Metrics::INDEX_PAGE_EXIT_NB_UNIQ_VISITORS . "`,
- count(*) as `" . Piwik_Metrics::INDEX_PAGE_EXIT_NB_VISITS . "`";
+ count(distinct log_visit.idvisitor) as `" . Metrics::INDEX_PAGE_EXIT_NB_UNIQ_VISITORS . "`,
+ count(*) as `" . Metrics::INDEX_PAGE_EXIT_NB_VISITS . "`";
$where = "log_visit.visit_last_action_time >= ?
AND log_visit.visit_last_action_time <= ?
@@ -389,10 +390,10 @@ class Piwik_Actions_Archiver extends Piwik_PluginsArchiver
$rankingQuery = new Piwik_RankingQuery($rankingQueryLimit);
$rankingQuery->setOthersLabel(Piwik_DataTable::LABEL_SUMMARY_ROW);
$rankingQuery->addLabelColumn('idaction');
- $rankingQuery->addColumn(Piwik_Metrics::INDEX_PAGE_SUM_TIME_SPENT, 'sum');
+ $rankingQuery->addColumn(Metrics::INDEX_PAGE_SUM_TIME_SPENT, 'sum');
$rankingQuery->partitionResultIntoMultipleGroups('type', array_keys($this->actionsTablesByType));
- $extraSelects = "log_action.type, log_action.name, count(*) as `" . Piwik_Metrics::INDEX_PAGE_NB_HITS . "`,";
+ $extraSelects = "log_action.type, log_action.name, count(*) as `" . Metrics::INDEX_PAGE_NB_HITS . "`,";
$from = array(
"log_link_visit_action",
array(
@@ -400,7 +401,7 @@ class Piwik_Actions_Archiver extends Piwik_PluginsArchiver
"joinOn" => "log_link_visit_action.%s = log_action.idaction"
)
);
- $orderBy = "`" . Piwik_Metrics::INDEX_PAGE_NB_HITS . "` DESC, log_action.name ASC";
+ $orderBy = "`" . Metrics::INDEX_PAGE_NB_HITS . "` DESC, log_action.name ASC";
} else {
$extraSelects = false;
$from = "log_link_visit_action";
@@ -408,7 +409,7 @@ class Piwik_Actions_Archiver extends Piwik_PluginsArchiver
}
$select = "log_link_visit_action.%s as idaction, $extraSelects
- sum(log_link_visit_action.time_spent_ref_action) as `" . Piwik_Metrics::INDEX_PAGE_SUM_TIME_SPENT . "`";
+ sum(log_link_visit_action.time_spent_ref_action) as `" . Metrics::INDEX_PAGE_SUM_TIME_SPENT . "`";
$where = "log_link_visit_action.server_time >= ?
AND log_link_visit_action.server_time <= ?
@@ -443,10 +444,10 @@ class Piwik_Actions_Archiver extends Piwik_PluginsArchiver
$this->recordDataTable($dataTable, self::PAGE_URLS_RECORD_NAME);
$records = array(
- self::METRIC_PAGEVIEWS_RECORD_NAME => array_sum($dataTable->getColumn(Piwik_Metrics::INDEX_PAGE_NB_HITS)),
- self::METRIC_UNIQ_PAGEVIEWS_RECORD_NAME => array_sum($dataTable->getColumn(Piwik_Metrics::INDEX_NB_VISITS)),
- self::METRIC_SUM_TIME_RECORD_NAME => array_sum($dataTable->getColumn(Piwik_Metrics::INDEX_PAGE_SUM_TIME_GENERATION)),
- self::METRIC_HITS_TIMED_RECORD_NAME => array_sum($dataTable->getColumn(Piwik_Metrics::INDEX_PAGE_NB_HITS_WITH_TIME_GENERATION))
+ self::METRIC_PAGEVIEWS_RECORD_NAME => array_sum($dataTable->getColumn(Metrics::INDEX_PAGE_NB_HITS)),
+ self::METRIC_UNIQ_PAGEVIEWS_RECORD_NAME => array_sum($dataTable->getColumn(Metrics::INDEX_NB_VISITS)),
+ self::METRIC_SUM_TIME_RECORD_NAME => array_sum($dataTable->getColumn(Metrics::INDEX_PAGE_SUM_TIME_GENERATION)),
+ self::METRIC_HITS_TIMED_RECORD_NAME => array_sum($dataTable->getColumn(Metrics::INDEX_PAGE_NB_HITS_WITH_TIME_GENERATION))
);
$this->getProcessor()->insertNumericRecords( $records );
}
@@ -502,7 +503,7 @@ class Piwik_Actions_Archiver extends Piwik_PluginsArchiver
{
// Delete all columns that have a value of zero
$dataTable->filter('ColumnDelete', array(
- $columnsToRemove = array(Piwik_Metrics::INDEX_PAGE_IS_FOLLOWING_SITE_SEARCH_NB_HITS),
+ $columnsToRemove = array(Metrics::INDEX_PAGE_IS_FOLLOWING_SITE_SEARCH_NB_HITS),
$columnsToKeep = array(),
$deleteIfZeroOnly = true
));
@@ -513,8 +514,8 @@ class Piwik_Actions_Archiver extends Piwik_PluginsArchiver
$dataTable = $this->getDataTable(Piwik_Tracker_Action::TYPE_DOWNLOAD);
$this->recordDataTable($dataTable, self::DOWNLOADS_RECORD_NAME);
- $this->getProcessor()->insertNumericRecord(self::METRIC_DOWNLOADS_RECORD_NAME, array_sum($dataTable->getColumn(Piwik_Metrics::INDEX_PAGE_NB_HITS)));
- $this->getProcessor()->insertNumericRecord(self::METRIC_UNIQ_DOWNLOADS_RECORD_NAME, array_sum($dataTable->getColumn(Piwik_Metrics::INDEX_NB_VISITS)));
+ $this->getProcessor()->insertNumericRecord(self::METRIC_DOWNLOADS_RECORD_NAME, array_sum($dataTable->getColumn(Metrics::INDEX_PAGE_NB_HITS)));
+ $this->getProcessor()->insertNumericRecord(self::METRIC_UNIQ_DOWNLOADS_RECORD_NAME, array_sum($dataTable->getColumn(Metrics::INDEX_NB_VISITS)));
}
protected function recordOutlinksReports()
@@ -522,8 +523,8 @@ class Piwik_Actions_Archiver extends Piwik_PluginsArchiver
$dataTable = $this->getDataTable(Piwik_Tracker_Action::TYPE_OUTLINK);
$this->recordDataTable($dataTable, self::OUTLINKS_RECORD_NAME);
- $this->getProcessor()->insertNumericRecord(self::METRIC_OUTLINKS_RECORD_NAME, array_sum($dataTable->getColumn(Piwik_Metrics::INDEX_PAGE_NB_HITS)));
- $this->getProcessor()->insertNumericRecord(self::METRIC_UNIQ_OUTLINKS_RECORD_NAME, array_sum($dataTable->getColumn(Piwik_Metrics::INDEX_NB_VISITS)));
+ $this->getProcessor()->insertNumericRecord(self::METRIC_OUTLINKS_RECORD_NAME, array_sum($dataTable->getColumn(Metrics::INDEX_PAGE_NB_HITS)));
+ $this->getProcessor()->insertNumericRecord(self::METRIC_UNIQ_OUTLINKS_RECORD_NAME, array_sum($dataTable->getColumn(Metrics::INDEX_NB_VISITS)));
}
protected function recordPageTitlesReports()
@@ -538,21 +539,21 @@ class Piwik_Actions_Archiver extends Piwik_PluginsArchiver
$this->deleteUnusedColumnsFromKeywordsDataTable($dataTable);
$this->recordDataTable($dataTable, self::SITE_SEARCH_RECORD_NAME);
- $this->getProcessor()->insertNumericRecord(self::METRIC_SEARCHES_RECORD_NAME, array_sum($dataTable->getColumn(Piwik_Metrics::INDEX_NB_VISITS)));
+ $this->getProcessor()->insertNumericRecord(self::METRIC_SEARCHES_RECORD_NAME, array_sum($dataTable->getColumn(Metrics::INDEX_NB_VISITS)));
$this->getProcessor()->insertNumericRecord(self::METRIC_KEYWORDS_RECORD_NAME, $dataTable->getRowsCount());
}
protected function deleteUnusedColumnsFromKeywordsDataTable($dataTable)
{
$columnsToDelete = array(
- Piwik_Metrics::INDEX_NB_UNIQ_VISITORS,
- Piwik_Metrics::INDEX_PAGE_IS_FOLLOWING_SITE_SEARCH_NB_HITS,
- Piwik_Metrics::INDEX_PAGE_ENTRY_NB_UNIQ_VISITORS,
- Piwik_Metrics::INDEX_PAGE_ENTRY_NB_ACTIONS,
- Piwik_Metrics::INDEX_PAGE_ENTRY_SUM_VISIT_LENGTH,
- Piwik_Metrics::INDEX_PAGE_ENTRY_NB_VISITS,
- Piwik_Metrics::INDEX_PAGE_ENTRY_BOUNCE_COUNT,
- Piwik_Metrics::INDEX_PAGE_EXIT_NB_UNIQ_VISITORS,
+ Metrics::INDEX_NB_UNIQ_VISITORS,
+ Metrics::INDEX_PAGE_IS_FOLLOWING_SITE_SEARCH_NB_HITS,
+ Metrics::INDEX_PAGE_ENTRY_NB_UNIQ_VISITORS,
+ Metrics::INDEX_PAGE_ENTRY_NB_ACTIONS,
+ Metrics::INDEX_PAGE_ENTRY_SUM_VISIT_LENGTH,
+ Metrics::INDEX_PAGE_ENTRY_NB_VISITS,
+ Metrics::INDEX_PAGE_ENTRY_BOUNCE_COUNT,
+ Metrics::INDEX_PAGE_EXIT_NB_UNIQ_VISITORS,
);
$dataTable->deleteColumns($columnsToDelete);
}
diff --git a/plugins/Actions/ArchivingHelper.php b/plugins/Actions/ArchivingHelper.php
index 72342adff7..514b75116b 100644
--- a/plugins/Actions/ArchivingHelper.php
+++ b/plugins/Actions/ArchivingHelper.php
@@ -9,6 +9,7 @@
* @package Piwik_Actions
*/
use Piwik\Config;
+use Piwik\Metrics;
/**
* This static class provides:
@@ -43,7 +44,7 @@ class Piwik_Actions_ArchivingHelper
}
if ($row['type'] != Piwik_Tracker_Action::TYPE_SITE_SEARCH) {
- unset($row[Piwik_Metrics::INDEX_SITE_SEARCH_HAS_NO_RESULT]);
+ unset($row[Metrics::INDEX_SITE_SEARCH_HAS_NO_RESULT]);
}
// This will appear as <url /> in the API, which is actually very important to keep
@@ -101,15 +102,15 @@ class Piwik_Actions_ArchivingHelper
&& !$actionRow->isSummaryRow()
) {
if (($existingUrl = $actionRow->getMetadata('url')) !== false) {
- if (!empty($row[Piwik_Metrics::INDEX_PAGE_NB_HITS])
- && $row[Piwik_Metrics::INDEX_PAGE_NB_HITS] > $actionRow->maxVisitsSummed
+ if (!empty($row[Metrics::INDEX_PAGE_NB_HITS])
+ && $row[Metrics::INDEX_PAGE_NB_HITS] > $actionRow->maxVisitsSummed
) {
$actionRow->setMetadata('url', $url);
- $actionRow->maxVisitsSummed = $row[Piwik_Metrics::INDEX_PAGE_NB_HITS];
+ $actionRow->maxVisitsSummed = $row[Metrics::INDEX_PAGE_NB_HITS];
}
} else {
$actionRow->setMetadata('url', $url);
- $actionRow->maxVisitsSummed = !empty($row[Piwik_Metrics::INDEX_PAGE_NB_HITS]) ? $row[Piwik_Metrics::INDEX_PAGE_NB_HITS] : 0;
+ $actionRow->maxVisitsSummed = !empty($row[Metrics::INDEX_PAGE_NB_HITS]) ? $row[Metrics::INDEX_PAGE_NB_HITS] : 0;
}
}
@@ -117,17 +118,17 @@ class Piwik_Actions_ArchivingHelper
&& $row['type'] != Piwik_Tracker_Action::TYPE_ACTION_NAME
) {
// only keep performance metrics when they're used (i.e. for URLs and page titles)
- if (array_key_exists(Piwik_Metrics::INDEX_PAGE_SUM_TIME_GENERATION, $row)) {
- unset($row[Piwik_Metrics::INDEX_PAGE_SUM_TIME_GENERATION]);
+ if (array_key_exists(Metrics::INDEX_PAGE_SUM_TIME_GENERATION, $row)) {
+ unset($row[Metrics::INDEX_PAGE_SUM_TIME_GENERATION]);
}
- if (array_key_exists(Piwik_Metrics::INDEX_PAGE_NB_HITS_WITH_TIME_GENERATION, $row)) {
- unset($row[Piwik_Metrics::INDEX_PAGE_NB_HITS_WITH_TIME_GENERATION]);
+ if (array_key_exists(Metrics::INDEX_PAGE_NB_HITS_WITH_TIME_GENERATION, $row)) {
+ unset($row[Metrics::INDEX_PAGE_NB_HITS_WITH_TIME_GENERATION]);
}
- if (array_key_exists(Piwik_Metrics::INDEX_PAGE_MIN_TIME_GENERATION, $row)) {
- unset($row[Piwik_Metrics::INDEX_PAGE_MIN_TIME_GENERATION]);
+ if (array_key_exists(Metrics::INDEX_PAGE_MIN_TIME_GENERATION, $row)) {
+ unset($row[Metrics::INDEX_PAGE_MIN_TIME_GENERATION]);
}
- if (array_key_exists(Piwik_Metrics::INDEX_PAGE_MAX_TIME_GENERATION, $row)) {
- unset($row[Piwik_Metrics::INDEX_PAGE_MAX_TIME_GENERATION]);
+ if (array_key_exists(Metrics::INDEX_PAGE_MAX_TIME_GENERATION, $row)) {
+ unset($row[Metrics::INDEX_PAGE_MAX_TIME_GENERATION]);
}
}
@@ -151,7 +152,7 @@ class Piwik_Actions_ArchivingHelper
// if the exit_action was not recorded properly in the log_link_visit_action
// there would be an error message when getting the nb_hits column
// we must fake the record and add the columns
- if ($actionRow->getColumn(Piwik_Metrics::INDEX_PAGE_NB_HITS) === false) {
+ if ($actionRow->getColumn(Metrics::INDEX_PAGE_NB_HITS) === false) {
// to test this code: delete the entries in log_link_action_visit for
// a given exit_idaction_url
foreach (self::getDefaultRow()->getColumns() as $name => $value) {
@@ -174,7 +175,7 @@ class Piwik_Actions_ArchivingHelper
*/
private static function getColumnValuesMerged($columnName, $alreadyValue, $value)
{
- if ($columnName == Piwik_Metrics::INDEX_PAGE_MIN_TIME_GENERATION) {
+ if ($columnName == Metrics::INDEX_PAGE_MIN_TIME_GENERATION) {
if (empty($alreadyValue)) {
$newValue = $value;
} else if (empty($value)) {
@@ -184,7 +185,7 @@ class Piwik_Actions_ArchivingHelper
}
return $newValue;
}
- if ($columnName == Piwik_Metrics::INDEX_PAGE_MAX_TIME_GENERATION) {
+ if ($columnName == Metrics::INDEX_PAGE_MAX_TIME_GENERATION) {
$newValue = max($alreadyValue, $value);
return $newValue;
}
@@ -215,7 +216,7 @@ class Piwik_Actions_ArchivingHelper
}
self::$defaultActionName = Config::getInstance()->General['action_default_name'];
- self::$columnToSortByBeforeTruncation = Piwik_Metrics::INDEX_NB_VISITS;
+ self::$columnToSortByBeforeTruncation = Metrics::INDEX_NB_VISITS;
self::$maximumRowsInDataTableLevelZero = Config::getInstance()->General['datatable_archiving_maximum_rows_actions'];
self::$maximumRowsInSubDataTable = Config::getInstance()->General['datatable_archiving_maximum_rows_subtable_actions'];
@@ -239,9 +240,9 @@ class Piwik_Actions_ArchivingHelper
// so we add this fake row information to make sure there is a nb_hits, etc. column for every action
$row = new Piwik_DataTable_Row(array(
Piwik_DataTable_Row::COLUMNS => array(
- Piwik_Metrics::INDEX_NB_VISITS => 1,
- Piwik_Metrics::INDEX_NB_UNIQ_VISITORS => 1,
- Piwik_Metrics::INDEX_PAGE_NB_HITS => 1,
+ Metrics::INDEX_NB_VISITS => 1,
+ Metrics::INDEX_NB_UNIQ_VISITORS => 1,
+ Metrics::INDEX_PAGE_NB_HITS => 1,
)));
}
return $row;
@@ -486,10 +487,10 @@ class Piwik_Actions_ArchivingHelper
*/
private static function getDefaultRowColumns()
{
- return array(Piwik_Metrics::INDEX_NB_VISITS => 0,
- Piwik_Metrics::INDEX_NB_UNIQ_VISITORS => 0,
- Piwik_Metrics::INDEX_PAGE_NB_HITS => 0,
- Piwik_Metrics::INDEX_PAGE_SUM_TIME_SPENT => 0);
+ return array(Metrics::INDEX_NB_VISITS => 0,
+ Metrics::INDEX_NB_UNIQ_VISITORS => 0,
+ Metrics::INDEX_PAGE_NB_HITS => 0,
+ Metrics::INDEX_PAGE_SUM_TIME_SPENT => 0);
}
/**
diff --git a/plugins/Actions/Controller.php b/plugins/Actions/Controller.php
index f7597825e5..6044c225d8 100644
--- a/plugins/Actions/Controller.php
+++ b/plugins/Actions/Controller.php
@@ -49,7 +49,7 @@ class Piwik_Actions_Controller extends Piwik_Controller
$view->noResultKeywords = $this->getSiteSearchNoResultKeywords(true);
$view->pagesUrlsFollowingSiteSearch = $this->getPageUrlsFollowingSiteSearch(true);
- $categoryTrackingEnabled = Piwik_PluginsManager::getInstance()->isPluginActivated('CustomVariables');
+ $categoryTrackingEnabled = PluginsManager::getInstance()->isPluginActivated('CustomVariables');
if ($categoryTrackingEnabled) {
$view->categories = $this->getSiteSearchCategories(true);
}