PluginProbe ʕ •ᴥ•ʔ
Matomo Analytics – Powerful, Privacy-First Insights for WordPress / 5.13.0
Matomo Analytics – Powerful, Privacy-First Insights for WordPress v5.13.0
5.13.0 5.12.1 5.12.0 5.11.1 5.11.0 5.10.2 5.10.1 trunk 1.0.2 1.0.3 1.0.4 1.0.5 1.0.6 1.1.0 1.1.1 1.1.2 1.1.3 1.2.0 1.3.0 1.3.1 1.3.2 4.0.0 4.0.1 4.0.2 4.0.3 4.0.4 4.1.0 4.1.1 4.1.2 4.1.3 4.10.0 4.11.0 4.12.0 4.13.0 4.13.2 4.13.3 4.13.4 4.13.5 4.14.0 4.14.1 4.14.2 4.15.0 4.15.1 4.15.2 4.15.3 4.2.0 4.3.0 4.3.1 4.4.1 4.4.2 4.5.0 4.6.0 5.0.1 5.0.2 5.0.3 5.0.4 5.0.5 5.0.6 5.0.7 5.0.8 5.1.0 5.1.1 5.1.2 5.1.3 5.1.4 5.1.5 5.1.6 5.1.7 5.10.0 5.2.0 5.2.1 5.2.2 5.3.0 5.3.1 5.3.2 5.3.3 5.6.0 5.6.1 5.7.0 5.7.1 5.8.0 5.8.1 5.8.2
matomo / app / core / DataArray.php
matomo / app / core Last commit date
API 4 days ago Access 1 month ago Application 1 month ago Archive 1 month ago ArchiveProcessor 4 days ago Archiver 2 years ago AssetManager 1 month ago Auth 1 month ago Category 1 month ago Changes 3 months ago CliMulti 1 month ago Columns 4 days ago Concurrency 1 month ago Config 1 month ago Container 3 months ago CronArchive 1 month ago DataAccess 4 days ago DataFiles 2 years ago DataTable 1 month ago Db 4 days ago DeviceDetector 1 year ago Email 2 years ago Exception 6 months ago Http 4 days ago Intl 5 months ago Log 2 years ago Mail 1 year ago Measurable 8 months ago Menu 1 month ago Metrics 1 month ago Notification 8 months ago Period 1 month ago Plugin 4 days ago Policy 3 months ago ProfessionalServices 1 year ago Report 1 year ago ReportRenderer 4 days ago Request 1 month ago Scheduler 1 month ago Segment 1 month ago Session 4 days ago Settings 4 days ago Tracker 4 days ago Translation 3 months ago Twig 1 year ago UpdateCheck 5 months ago Updater 1 month ago Updates 2 months ago Validators 1 year ago View 3 months ago ViewDataTable 4 days ago Visualization 4 days ago Widget 1 month ago .htaccess 2 years ago Access.php 1 month ago Archive.php 3 months ago ArchiveProcessor.php 4 days ago AssetManager.php 1 month ago Auth.php 8 months ago AuthResult.php 8 months ago BaseFactory.php 2 years ago Cache.php 1 month ago CacheId.php 6 months ago CliMulti.php 1 month ago Common.php 1 month ago Config.php 1 month ago Console.php 5 months ago Context.php 2 years ago Cookie.php 1 month ago CronArchive.php 1 month ago DI.php 5 months ago DataArray.php 1 month ago DataTable.php 4 days ago Date.php 3 months ago Db.php 3 months ago DbHelper.php 1 month ago Development.php 1 month ago ErrorHandler.php 8 months ago EventDispatcher.php 3 months ago ExceptionHandler.php 6 months ago FileIntegrity.php 1 month ago Filechecks.php 1 year ago Filesystem.php 4 days ago FrontController.php 1 month ago Http.php 4 days ago IP.php 1 year ago Log.php 5 months ago LogDeleter.php 1 month ago Mail.php 1 year ago Metrics.php 3 months ago NoAccessException.php 2 years ago Nonce.php 8 months ago Notification.php 3 months ago NumberFormatter.php 1 month ago Option.php 1 month ago Period.php 1 month ago Piwik.php 1 month ago Plugin.php 3 months ago Process.php 3 months ago Profiler.php 1 month ago ProxyHeaders.php 6 months ago ProxyHttp.php 1 month ago QuickForm2.php 5 months ago RankingQuery.php 3 months ago ReportRenderer.php 4 days ago Request.php 3 months ago Segment.php 4 days ago Sequence.php 1 month ago Session.php 2 months ago SettingsPiwik.php 1 month ago SettingsServer.php 1 month ago Singleton.php 2 years ago Site.php 3 months ago SiteContentDetector.php 4 days ago SupportedBrowser.php 2 years ago TCPDF.php 1 year ago Theme.php 1 month ago Timer.php 1 month ago Tracker.php 1 month ago Twig.php 4 days ago Unzip.php 1 year ago UpdateCheck.php 3 months ago Updater.php 1 month ago UpdaterErrorException.php 2 years ago Updates.php 1 month ago Url.php 1 month ago UrlHelper.php 3 months ago Version.php 4 days ago View.php 1 month ago bootstrap.php 1 year ago dispatch.php 2 years ago testMinimumPhpVersion.php 8 months ago
DataArray.php
332 lines
1 <?php
2
3 /**
4 * Matomo - free/libre analytics platform
5 *
6 * @link https://matomo.org
7 * @license https://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later
8 */
9 namespace Piwik;
10
11 use Exception;
12 use Piwik\DataTable\Filter\EnrichRecordWithGoalMetricSums;
13 use Piwik\Tracker\GoalManager;
14 /**
15 * The DataArray is a data structure used to aggregate datasets,
16 * ie. sum arrays made of rows made of columns,
17 * data from the logs is stored in a DataArray before being converted in a DataTable
18 *
19 */
20 class DataArray
21 {
22 protected $data = array();
23 protected $dataTwoLevels = array();
24 public function __construct($data = array(), $dataArrayByLabel = array())
25 {
26 $this->data = $data;
27 $this->dataTwoLevels = $dataArrayByLabel;
28 }
29 /**
30 * This returns the actual raw data array
31 *
32 * @return array
33 */
34 public function &getDataArray()
35 {
36 return $this->data;
37 }
38 public function getDataArrayWithTwoLevels()
39 {
40 return $this->dataTwoLevels;
41 }
42 public function sumMetricsVisits($label, $row)
43 {
44 if (!isset($this->data[$label])) {
45 $this->data[$label] = static::makeEmptyRow();
46 }
47 $this->doSumVisitsMetrics($row, $this->data[$label]);
48 }
49 /**
50 * Returns an empty row containing default metrics
51 *
52 * @return array
53 */
54 public static function makeEmptyRow()
55 {
56 return array(\Piwik\Metrics::INDEX_NB_UNIQ_VISITORS => 0, \Piwik\Metrics::INDEX_NB_VISITS => 0, \Piwik\Metrics::INDEX_NB_ACTIONS => 0, \Piwik\Metrics::INDEX_NB_USERS => 0, \Piwik\Metrics::INDEX_MAX_ACTIONS => 0, \Piwik\Metrics::INDEX_SUM_VISIT_LENGTH => 0, \Piwik\Metrics::INDEX_BOUNCE_COUNT => 0, \Piwik\Metrics::INDEX_NB_VISITS_CONVERTED => 0);
57 }
58 /**
59 * Adds the given row $newRowToAdd to the existing $oldRowToUpdate passed by reference
60 * The rows are php arrays Name => value
61 *
62 * @param array $newRowToAdd
63 * @param array $oldRowToUpdate
64 *
65 * @return void
66 */
67 protected function doSumVisitsMetrics($newRowToAdd, &$oldRowToUpdate)
68 {
69 // Pre 1.2 format: string indexed rows are returned from the DB
70 // Left here for Backward compatibility with plugins doing custom SQL queries using these metrics as string
71 if (!isset($newRowToAdd[\Piwik\Metrics::INDEX_NB_VISITS])) {
72 $oldRowToUpdate[\Piwik\Metrics::INDEX_NB_VISITS] += $newRowToAdd['nb_visits'];
73 $oldRowToUpdate[\Piwik\Metrics::INDEX_NB_ACTIONS] += $newRowToAdd['nb_actions'];
74 $oldRowToUpdate[\Piwik\Metrics::INDEX_NB_UNIQ_VISITORS] += $newRowToAdd['nb_uniq_visitors'];
75 $oldRowToUpdate[\Piwik\Metrics::INDEX_NB_USERS] += $newRowToAdd['nb_users'];
76 $oldRowToUpdate[\Piwik\Metrics::INDEX_MAX_ACTIONS] = (float) max($newRowToAdd['max_actions'], $oldRowToUpdate[\Piwik\Metrics::INDEX_MAX_ACTIONS]);
77 $oldRowToUpdate[\Piwik\Metrics::INDEX_SUM_VISIT_LENGTH] += $newRowToAdd['sum_visit_length'];
78 $oldRowToUpdate[\Piwik\Metrics::INDEX_BOUNCE_COUNT] += $newRowToAdd['bounce_count'];
79 $oldRowToUpdate[\Piwik\Metrics::INDEX_NB_VISITS_CONVERTED] += $newRowToAdd['nb_visits_converted'];
80 return;
81 }
82 // Edge case fail safe
83 if (!isset($oldRowToUpdate[\Piwik\Metrics::INDEX_NB_VISITS])) {
84 return;
85 }
86 $oldRowToUpdate[\Piwik\Metrics::INDEX_NB_VISITS] += $newRowToAdd[\Piwik\Metrics::INDEX_NB_VISITS];
87 $oldRowToUpdate[\Piwik\Metrics::INDEX_NB_ACTIONS] += $newRowToAdd[\Piwik\Metrics::INDEX_NB_ACTIONS];
88 $oldRowToUpdate[\Piwik\Metrics::INDEX_NB_UNIQ_VISITORS] += $newRowToAdd[\Piwik\Metrics::INDEX_NB_UNIQ_VISITORS];
89 // In case the existing Row had no action metrics (eg. Custom Variable XYZ with "visit" scope)
90 // but the new Row has action metrics (eg. same Custom Variable XYZ this time with a "page" scope)
91 if (!isset($oldRowToUpdate[\Piwik\Metrics::INDEX_MAX_ACTIONS])) {
92 $toZero = array(\Piwik\Metrics::INDEX_NB_USERS, \Piwik\Metrics::INDEX_MAX_ACTIONS, \Piwik\Metrics::INDEX_SUM_VISIT_LENGTH, \Piwik\Metrics::INDEX_BOUNCE_COUNT, \Piwik\Metrics::INDEX_NB_VISITS_CONVERTED);
93 foreach ($toZero as $metric) {
94 $oldRowToUpdate[$metric] = 0;
95 }
96 }
97 $oldRowToUpdate[\Piwik\Metrics::INDEX_NB_USERS] += $newRowToAdd[\Piwik\Metrics::INDEX_NB_USERS];
98 $oldRowToUpdate[\Piwik\Metrics::INDEX_MAX_ACTIONS] = (float) max($newRowToAdd[\Piwik\Metrics::INDEX_MAX_ACTIONS], $oldRowToUpdate[\Piwik\Metrics::INDEX_MAX_ACTIONS]);
99 $oldRowToUpdate[\Piwik\Metrics::INDEX_SUM_VISIT_LENGTH] += $newRowToAdd[\Piwik\Metrics::INDEX_SUM_VISIT_LENGTH];
100 $oldRowToUpdate[\Piwik\Metrics::INDEX_BOUNCE_COUNT] += $newRowToAdd[\Piwik\Metrics::INDEX_BOUNCE_COUNT];
101 $oldRowToUpdate[\Piwik\Metrics::INDEX_NB_VISITS_CONVERTED] += $newRowToAdd[\Piwik\Metrics::INDEX_NB_VISITS_CONVERTED];
102 }
103 /**
104 * Adds the given row $newRowToAdd to the existing $oldRowToUpdate passed by reference
105 * The rows are php arrays Name => value
106 *
107 * @param array $newRowToAdd
108 * @param array $oldRowToUpdate
109 *
110 * @return void
111 */
112 protected function doSumActionsMetrics($newRowToAdd, &$oldRowToUpdate)
113 {
114 // Pre 1.2 format: string indexed rows are returned from the DB
115 // Left here for Backward compatibility with plugins doing custom SQL queries using these metrics as string
116 if (!isset($newRowToAdd[\Piwik\Metrics::INDEX_NB_VISITS])) {
117 $oldRowToUpdate[\Piwik\Metrics::INDEX_NB_VISITS] += $newRowToAdd['nb_visits'];
118 $oldRowToUpdate[\Piwik\Metrics::INDEX_NB_ACTIONS] += $newRowToAdd['nb_actions'];
119 $oldRowToUpdate[\Piwik\Metrics::INDEX_NB_UNIQ_VISITORS] += $newRowToAdd['nb_uniq_visitors'];
120 return;
121 }
122 // Edge case fail safe
123 if (!isset($oldRowToUpdate[\Piwik\Metrics::INDEX_NB_VISITS])) {
124 return;
125 }
126 $oldRowToUpdate[\Piwik\Metrics::INDEX_NB_VISITS] += $newRowToAdd[\Piwik\Metrics::INDEX_NB_VISITS];
127 if (array_key_exists(\Piwik\Metrics::INDEX_NB_ACTIONS, $newRowToAdd)) {
128 $oldRowToUpdate[\Piwik\Metrics::INDEX_NB_ACTIONS] += $newRowToAdd[\Piwik\Metrics::INDEX_NB_ACTIONS];
129 }
130 if (array_key_exists(\Piwik\Metrics::INDEX_PAGE_NB_HITS, $newRowToAdd)) {
131 if (!array_key_exists(\Piwik\Metrics::INDEX_PAGE_NB_HITS, $oldRowToUpdate)) {
132 $oldRowToUpdate[\Piwik\Metrics::INDEX_PAGE_NB_HITS] = 0;
133 }
134 $oldRowToUpdate[\Piwik\Metrics::INDEX_PAGE_NB_HITS] += $newRowToAdd[\Piwik\Metrics::INDEX_PAGE_NB_HITS];
135 }
136 $oldRowToUpdate[\Piwik\Metrics::INDEX_NB_UNIQ_VISITORS] += $newRowToAdd[\Piwik\Metrics::INDEX_NB_UNIQ_VISITORS];
137 }
138 public function sumMetricsGoals($label, $row)
139 {
140 $idGoal = $row['idgoal'];
141 if (!isset($this->data[$label][\Piwik\Metrics::INDEX_GOALS][$idGoal])) {
142 $this->data[$label][\Piwik\Metrics::INDEX_GOALS][$idGoal] = static::makeEmptyGoalRow($idGoal);
143 }
144 $this->doSumGoalsMetrics($row, $this->data[$label][\Piwik\Metrics::INDEX_GOALS][$idGoal]);
145 }
146 /**
147 * @param $idGoal
148 * @return array
149 */
150 protected static function makeEmptyGoalRow($idGoal)
151 {
152 if ($idGoal > GoalManager::IDGOAL_ORDER) {
153 return array(\Piwik\Metrics::INDEX_GOAL_NB_CONVERSIONS => 0, \Piwik\Metrics::INDEX_GOAL_NB_VISITS_CONVERTED => 0, \Piwik\Metrics::INDEX_GOAL_REVENUE => 0);
154 }
155 if ($idGoal == GoalManager::IDGOAL_ORDER) {
156 return array(\Piwik\Metrics::INDEX_GOAL_NB_CONVERSIONS => 0, \Piwik\Metrics::INDEX_GOAL_NB_VISITS_CONVERTED => 0, \Piwik\Metrics::INDEX_GOAL_REVENUE => 0, \Piwik\Metrics::INDEX_GOAL_ECOMMERCE_REVENUE_SUBTOTAL => 0, \Piwik\Metrics::INDEX_GOAL_ECOMMERCE_REVENUE_TAX => 0, \Piwik\Metrics::INDEX_GOAL_ECOMMERCE_REVENUE_SHIPPING => 0, \Piwik\Metrics::INDEX_GOAL_ECOMMERCE_REVENUE_DISCOUNT => 0, \Piwik\Metrics::INDEX_GOAL_ECOMMERCE_ITEMS => 0);
157 }
158 // idGoal == GoalManager::IDGOAL_CART
159 return array(\Piwik\Metrics::INDEX_GOAL_NB_CONVERSIONS => 0, \Piwik\Metrics::INDEX_GOAL_NB_VISITS_CONVERTED => 0, \Piwik\Metrics::INDEX_GOAL_REVENUE => 0, \Piwik\Metrics::INDEX_GOAL_ECOMMERCE_ITEMS => 0);
160 }
161 /**
162 * @param $newRowToAdd
163 * @param $oldRowToUpdate
164 */
165 protected function doSumGoalsMetrics($newRowToAdd, &$oldRowToUpdate)
166 {
167 $oldRowToUpdate[\Piwik\Metrics::INDEX_GOAL_NB_CONVERSIONS] += $newRowToAdd[\Piwik\Metrics::INDEX_GOAL_NB_CONVERSIONS];
168 $oldRowToUpdate[\Piwik\Metrics::INDEX_GOAL_NB_VISITS_CONVERTED] += $newRowToAdd[\Piwik\Metrics::INDEX_GOAL_NB_VISITS_CONVERTED];
169 $oldRowToUpdate[\Piwik\Metrics::INDEX_GOAL_REVENUE] += $newRowToAdd[\Piwik\Metrics::INDEX_GOAL_REVENUE];
170 // Cart & Order
171 if (isset($oldRowToUpdate[\Piwik\Metrics::INDEX_GOAL_ECOMMERCE_ITEMS])) {
172 $oldRowToUpdate[\Piwik\Metrics::INDEX_GOAL_ECOMMERCE_ITEMS] += $newRowToAdd[\Piwik\Metrics::INDEX_GOAL_ECOMMERCE_ITEMS];
173 // Order only
174 if (isset($oldRowToUpdate[\Piwik\Metrics::INDEX_GOAL_ECOMMERCE_REVENUE_SUBTOTAL])) {
175 $oldRowToUpdate[\Piwik\Metrics::INDEX_GOAL_ECOMMERCE_REVENUE_SUBTOTAL] += $newRowToAdd[\Piwik\Metrics::INDEX_GOAL_ECOMMERCE_REVENUE_SUBTOTAL];
176 $oldRowToUpdate[\Piwik\Metrics::INDEX_GOAL_ECOMMERCE_REVENUE_TAX] += $newRowToAdd[\Piwik\Metrics::INDEX_GOAL_ECOMMERCE_REVENUE_TAX];
177 $oldRowToUpdate[\Piwik\Metrics::INDEX_GOAL_ECOMMERCE_REVENUE_SHIPPING] += $newRowToAdd[\Piwik\Metrics::INDEX_GOAL_ECOMMERCE_REVENUE_SHIPPING];
178 $oldRowToUpdate[\Piwik\Metrics::INDEX_GOAL_ECOMMERCE_REVENUE_DISCOUNT] += $newRowToAdd[\Piwik\Metrics::INDEX_GOAL_ECOMMERCE_REVENUE_DISCOUNT];
179 }
180 }
181 }
182 public function sumMetricsActions($label, $row)
183 {
184 if (!isset($this->data[$label])) {
185 $this->data[$label] = static::makeEmptyActionRow();
186 }
187 $this->doSumActionsMetrics($row, $this->data[$label]);
188 }
189 protected static function makeEmptyActionRow()
190 {
191 return array(\Piwik\Metrics::INDEX_NB_UNIQ_VISITORS => 0, \Piwik\Metrics::INDEX_NB_VISITS => 0, \Piwik\Metrics::INDEX_NB_ACTIONS => 0);
192 }
193 public function sumMetricsEvents($label, $row)
194 {
195 if (!isset($this->data[$label])) {
196 $this->data[$label] = static::makeEmptyEventRow();
197 }
198 $this->doSumEventsMetrics($row, $this->data[$label]);
199 }
200 protected static function makeEmptyEventRow()
201 {
202 return array(\Piwik\Metrics::INDEX_NB_UNIQ_VISITORS => 0, \Piwik\Metrics::INDEX_NB_VISITS => 0, \Piwik\Metrics::INDEX_EVENT_NB_HITS => 0, \Piwik\Metrics::INDEX_EVENT_NB_HITS_WITH_VALUE => 0, \Piwik\Metrics::INDEX_EVENT_SUM_EVENT_VALUE => 0, \Piwik\Metrics::INDEX_EVENT_MIN_EVENT_VALUE => \false, \Piwik\Metrics::INDEX_EVENT_MAX_EVENT_VALUE => 0);
203 }
204 public const EVENT_VALUE_PRECISION = 2;
205 /**
206 * @param array $newRowToAdd
207 * @param array $oldRowToUpdate
208 * @return void
209 */
210 protected function doSumEventsMetrics($newRowToAdd, &$oldRowToUpdate)
211 {
212 $oldRowToUpdate[\Piwik\Metrics::INDEX_NB_VISITS] += $newRowToAdd[\Piwik\Metrics::INDEX_NB_VISITS];
213 $oldRowToUpdate[\Piwik\Metrics::INDEX_NB_UNIQ_VISITORS] += $newRowToAdd[\Piwik\Metrics::INDEX_NB_UNIQ_VISITORS];
214 $oldRowToUpdate[\Piwik\Metrics::INDEX_EVENT_NB_HITS] += $newRowToAdd[\Piwik\Metrics::INDEX_EVENT_NB_HITS];
215 $oldRowToUpdate[\Piwik\Metrics::INDEX_EVENT_NB_HITS_WITH_VALUE] += $newRowToAdd[\Piwik\Metrics::INDEX_EVENT_NB_HITS_WITH_VALUE];
216 $newRowToAdd[\Piwik\Metrics::INDEX_EVENT_SUM_EVENT_VALUE] = round($newRowToAdd[\Piwik\Metrics::INDEX_EVENT_SUM_EVENT_VALUE], static::EVENT_VALUE_PRECISION);
217 $oldRowToUpdate[\Piwik\Metrics::INDEX_EVENT_SUM_EVENT_VALUE] += $newRowToAdd[\Piwik\Metrics::INDEX_EVENT_SUM_EVENT_VALUE];
218 $oldRowToUpdate[\Piwik\Metrics::INDEX_EVENT_MAX_EVENT_VALUE] = round(max(0, $newRowToAdd[\Piwik\Metrics::INDEX_EVENT_MAX_EVENT_VALUE], $oldRowToUpdate[\Piwik\Metrics::INDEX_EVENT_MAX_EVENT_VALUE]), static::EVENT_VALUE_PRECISION);
219 // Update minimum only if it is set
220 if ($newRowToAdd[\Piwik\Metrics::INDEX_EVENT_MIN_EVENT_VALUE] !== \false && $newRowToAdd[\Piwik\Metrics::INDEX_EVENT_MIN_EVENT_VALUE] !== null) {
221 if ($oldRowToUpdate[\Piwik\Metrics::INDEX_EVENT_MIN_EVENT_VALUE] === \false) {
222 $oldRowToUpdate[\Piwik\Metrics::INDEX_EVENT_MIN_EVENT_VALUE] = round($newRowToAdd[\Piwik\Metrics::INDEX_EVENT_MIN_EVENT_VALUE], static::EVENT_VALUE_PRECISION);
223 } else {
224 $oldRowToUpdate[\Piwik\Metrics::INDEX_EVENT_MIN_EVENT_VALUE] = round(min($newRowToAdd[\Piwik\Metrics::INDEX_EVENT_MIN_EVENT_VALUE], $oldRowToUpdate[\Piwik\Metrics::INDEX_EVENT_MIN_EVENT_VALUE]), static::EVENT_VALUE_PRECISION);
225 }
226 }
227 }
228 /**
229 * Generic function that will sum all columns of the given row, at the specified label's row.
230 *
231 * @param $label
232 * @param $row
233 * @throws Exception if the data row contains non numeric values
234 */
235 public function sumMetrics($label, $row)
236 {
237 foreach ($row as $columnName => $columnValue) {
238 if (empty($columnValue)) {
239 continue;
240 }
241 if (empty($this->data[$label][$columnName])) {
242 $this->data[$label][$columnName] = 0;
243 }
244 if (!is_numeric($columnValue)) {
245 throw new Exception("DataArray->sumMetricsPivot expects rows of numeric values, non numeric found: " . var_export($columnValue, \true) . " for column {$columnName}");
246 }
247 $this->data[$label][$columnName] += $columnValue;
248 }
249 }
250 public function sumMetricsVisitsPivot($parentLabel, $label, $row)
251 {
252 if (!isset($this->dataTwoLevels[$parentLabel][$label])) {
253 $this->dataTwoLevels[$parentLabel][$label] = static::makeEmptyRow();
254 }
255 $this->doSumVisitsMetrics($row, $this->dataTwoLevels[$parentLabel][$label]);
256 }
257 public function sumMetricsGoalsPivot($parentLabel, $label, $row)
258 {
259 $idGoal = $row['idgoal'];
260 if (!isset($this->dataTwoLevels[$parentLabel][$label][\Piwik\Metrics::INDEX_GOALS][$idGoal])) {
261 $this->dataTwoLevels[$parentLabel][$label][\Piwik\Metrics::INDEX_GOALS][$idGoal] = static::makeEmptyGoalRow($idGoal);
262 }
263 $this->doSumGoalsMetrics($row, $this->dataTwoLevels[$parentLabel][$label][\Piwik\Metrics::INDEX_GOALS][$idGoal]);
264 }
265 public function sumMetricsActionsPivot($parentLabel, $label, $row)
266 {
267 if (!isset($this->dataTwoLevels[$parentLabel][$label])) {
268 $this->dataTwoLevels[$parentLabel][$label] = $this->makeEmptyActionRow();
269 }
270 $this->doSumActionsMetrics($row, $this->dataTwoLevels[$parentLabel][$label]);
271 }
272 public function sumMetricsEventsPivot($parentLabel, $label, $row)
273 {
274 if (!isset($this->dataTwoLevels[$parentLabel][$label])) {
275 $this->dataTwoLevels[$parentLabel][$label] = $this->makeEmptyEventRow();
276 }
277 $this->doSumEventsMetrics($row, $this->dataTwoLevels[$parentLabel][$label]);
278 }
279 public function setRowColumnPivot($parentLabel, $label, $column, $value)
280 {
281 $this->dataTwoLevels[$parentLabel][$label][$column] = $value;
282 }
283 public function enrichMetricsWithConversions()
284 {
285 $this->enrichWithConversions($this->data);
286 foreach ($this->dataTwoLevels as &$metricsBySubLabel) {
287 $this->enrichWithConversions($metricsBySubLabel);
288 }
289 }
290 /**
291 * Given an array of stats, it will process the sum of goal conversions
292 * and sum of revenue and add it in the stats array in two new fields.
293 *
294 * @param array $data Passed by reference, two new columns
295 * will be added: total conversions, and total revenue, for all goals for this label/row
296 */
297 protected function enrichWithConversions(&$data)
298 {
299 foreach ($data as &$values) {
300 EnrichRecordWithGoalMetricSums::enrichWithConversions($values);
301 }
302 }
303 /**
304 * Returns true if the row looks like an Action metrics row
305 *
306 * @param $row
307 * @return bool
308 */
309 public static function isRowActions($row)
310 {
311 return count($row) == count(static::makeEmptyActionRow()) && isset($row[\Piwik\Metrics::INDEX_NB_ACTIONS]);
312 }
313 /**
314 * Converts array to a datatable
315 *
316 * @return \Piwik\DataTable
317 */
318 public function asDataTable()
319 {
320 $dataArray = $this->getDataArray();
321 $dataArrayTwoLevels = $this->getDataArrayWithTwoLevels();
322 $subtableByLabel = null;
323 if (!empty($dataArrayTwoLevels)) {
324 $subtableByLabel = array();
325 foreach ($dataArrayTwoLevels as $label => $subTable) {
326 $subtableByLabel[$label] = \Piwik\DataTable::makeFromIndexedArray($subTable);
327 }
328 }
329 return \Piwik\DataTable::makeFromIndexedArray($dataArray, $subtableByLabel);
330 }
331 }
332