Ubuntu

getMetadata('Actions', 'action'); // update performance metrics only for non pageview requests if ($action && $action instanceof ActionPageview) { return; } $pageViewId = $request->getParam('pv_id'); $idVisit = $visitProperties->getProperty('idvisit'); // ignore requests that can't be associated with an existing page view of a visitor if (empty($pageViewId) || empty($idVisit)) { return; } /** @var ActionDimension[] $performanceDimensions */ $performanceDimensions = [ new TimeNetwork(), new TimeServer(), new TimeTransfer(), new TimeDomProcessing(), new TimeDomCompletion(), new TimeOnLoad() ]; $valuesToUpdate = []; foreach ($performanceDimensions as $performanceDimension) { $paramValue = $request->getParam($performanceDimension->getRequestParam()); if ($paramValue > -1) { $valuesToUpdate[$performanceDimension->getColumnName()] = $paramValue; } } if (empty($valuesToUpdate)) { return; // no values to update given with the request } $idLinkVa = $this->getPageViewId($idVisit, $pageViewId); // ignore requests if (empty($idLinkVa)) { return; } Log::info('Updating page performance metrics of page view with id ' . $pageViewId); $model = new Model(); $model->updateAction($idLinkVa, $valuesToUpdate); } protected function getPageViewId($idVisit, $pageViewId) { $query = sprintf( 'SELECT idlink_va FROM %1$s LEFT JOIN %2$s ON idaction_url = idaction WHERE idvisit = ? AND idpageview = ? AND %2$s.type = ?', Common::prefixTable('log_link_visit_action'), Common::prefixTable('log_action') ); $idLinkVa = Tracker::getDatabase()->fetchOne($query, [$idVisit, $pageViewId, Action::TYPE_PAGE_URL]); if (!empty($idLinkVa)) { return $idLinkVa; } $query = sprintf( 'SELECT idlink_va FROM %1$s LEFT JOIN %2$s ON idaction_name = idaction WHERE idvisit = ? AND idpageview = ? AND %2$s.type = ?', Common::prefixTable('log_link_visit_action'), Common::prefixTable('log_action') ); return Tracker::getDatabase()->fetchOne($query, [$idVisit, $pageViewId, Action::TYPE_PAGE_TITLE]); } }