• 홈
• Piwik
• DataAccess
• LogAggregator

PHP 클래스 Piwik\DataAccess\LogAggregator

You can use the methods in this class within {@link Piwik\Plugin\Archiver Archiver} descendants to aggregate log data without having to write SQL queries. ### Aggregation Dimension All aggregation methods accept a **dimension** parameter. These parameters are important as they control how rows in a table are aggregated together. A **_dimension_** is just a table column. Rows that have the same values for these columns are aggregated together. The result of these aggregations is a set of metrics for every recorded value of a **dimension**. _Note: A dimension is essentially the same as a **GROUP BY** field._ ### Examples **Aggregating visit data** $archiveProcessor = // ... $logAggregator = $archiveProcessor->getLogAggregator(); get metrics for every used browser language of all visits by returning visitors $query = $logAggregator->queryVisitsByDimension( $dimensions = array('log_visit.location_browser_lang'), $where = 'log_visit.visitor_returning = 1', also count visits for each browser language that are not located in the US $additionalSelects = array('sum(case when log_visit.location_country <> 'us' then 1 else 0 end) as nonus'), we're only interested in visits, unique visitors & actions, so don't waste time calculating anything else $metrics = array(Metrics::INDEX_NB_UNIQ_VISITORS, Metrics::INDEX_NB_VISITS, Metrics::INDEX_NB_ACTIONS), ); if ($query === false) { return; } while ($row = $query->fetch()) { $uniqueVisitors = $row[Metrics::INDEX_NB_UNIQ_VISITORS]; $visits = $row[Metrics::INDEX_NB_VISITS]; $actions = $row[Metrics::INDEX_NB_ACTIONS]; ... do something w/ calculated metrics ... } **Aggregating conversion data** $archiveProcessor = // ... $logAggregator = $archiveProcessor->getLogAggregator(); get metrics for ecommerce conversions for each country $query = $logAggregator->queryConversionsByDimension( $dimensions = array('log_conversion.location_country'), $where = 'log_conversion.idgoal = 0', // 0 is the special ecommerceOrder idGoal value in the table also calculate average tax and max shipping per country $additionalSelects = array( 'AVG(log_conversion.revenue_tax) as avg_tax', 'MAX(log_conversion.revenue_shipping) as max_shipping' ) ); if ($query === false) { return; } while ($row = $query->fetch()) { $country = $row['location_country']; $numEcommerceSales = $row[Metrics::INDEX_GOAL_NB_CONVERSIONS]; $numVisitsWithEcommerceSales = $row[Metrics::INDEX_GOAL_NB_VISITS_CONVERTED]; $avgTaxForCountry = $row['avg_tax']; $maxShippingForCountry = $row['max_shipping']; ... do something with aggregated data ... } 파일 보기 프로젝트 열기: piwik/piwik 1 사용 예제들

보호된 프로퍼티들

프로퍼티	타입	설명
$dateEnd	Piwik\Date
$dateStart	Piwik\Date
$segment	Piwik\Segment
$sites	int[]

공개 메소드들

메소드	설명
__construct ( Piwik\ArchiveProcessor\Parameters $params )	Constructor.
generateQuery ( $select, $from, $where, $groupBy, $orderBy, $limit, $offset )
getConversionsMetricFields ( )
getDb ( )
getMetricsFromVisitByDimension ( string $dimension ) : Piwik\DataArray	Helper function that returns an array with common metrics for a given log_visit field distinct values.
getSelectsFromRangedColumn ( string $column, array $ranges, string $table, string $selectColumnPrefix, boolean $restrictToReturningVisitors = false ) : array	Creates and returns an array of SQL SELECT expressions that will each count how many rows have a column whose value is within a certain range.
getSqlRevenue ( $field )
makeArrayOneColumn ( $row, $columnName, boolean $lookForThisPrefix = false ) : array	Clean up the row data and return values.
queryActionsByDimension ( array | string $dimensions, boolean | string $where = '', array $additionalSelects = [], boolean | array $metrics = false, boolean | Piwik\RankingQuery $rankingQuery = null, boolean | string $joinLogActionOnColumn = false ) : mixed	Executes and returns a query aggregating action data (everything in the log_action table) and returns a DB statement that can be used to iterate over the result
queryConversionsByDimension ( array | string $dimensions = [], boolean | string $where = false, array $additionalSelects = [] ) : Zend_Db_Statement	Executes a query aggregating conversion data (everything in the **log_conversion** table) and returns a DB statement that can be used to iterate over the result.
queryEcommerceItems ( string $dimension ) : Zend_Db_Statement	Executes and returns a query aggregating ecommerce item data (everything stored in the **log\_conversion\_item** table) and returns a DB statement that can be used to iterate over the result
queryVisitsByDimension ( array $dimensions = [], boolean | string $where = false, array $additionalSelects = [], boolean | array $metrics = false, boolean | Piwik\RankingQuery $rankingQuery = false ) : mixed	Executes and returns a query aggregating visit logs, optionally grouping by some dimension. Returns a DB statement that can be used to iterate over the result
setQueryOriginHint ( $nameOfOrigiin )

보호된 메소드들

메소드	설명
getActionsMetricFields ( )
getDimensionsToSelect ( $dimensions, array $additionalSelects ) : array	Will return the subset of $dimensions that are not found in $additionalSelects
getGeneralQueryBindParams ( ) : array	Returns general bind parameters for all log aggregation queries. This includes the datetime start of entities, datetime end of entities and IDs of all sites.
getGroupByStatement ( $dimensions, $tableName )
getSelectAliasAs ( $metricId )
getSelectDimensions ( $dimensions, $tableName, boolean $appendSelectAs = true ) : mixed	Returns the dimensions array, where (1) the table name is prepended to the field (2) the "AS label " is appended to the field
getSelectStatement ( $dimensions, $tableName, $additionalSelects, array $availableMetrics, $requestedMetrics = false )
getSelectsMetrics ( $metricsAvailable, $metricsRequested = false )
getVisitsMetricFields ( )
getWhereStatement ( $tableName, $datetimeField, $extraWhere = false )
isFieldFunctionOrComplexExpression ( $field )
isMetricRequested ( $metricId, $metricsRequested )

비공개 메소드들

메소드	설명
getSqlConversionRevenueSum ( $field )
prefixColumn ( string $column, string $tableName ) : string	Prefixes a column name with a table name if not already done.

메소드 상세

프로퍼티 상세