original_string: protected function archiveDayActionsTime($rankingQueryLimit)
      {
          $rankingQuery = false;
          if ($rankingQueryLimit > 0) {
              $rankingQuery = new RankingQuery($rankingQueryLimit);
              $rankingQuery->setOthersLabel(DataTable::LABEL_SUMMARY_ROW);
              $rankingQuery->addLabelColumn('idaction');
              $rankingQuery->addColumn(PiwikMetrics::INDEX_PAGE_SUM_TIME_SPENT, 'sum');
              $rankingQuery->partitionResultIntoMultipleGroups('type', array_keys($this->actionsTablesByType));
  
              $extraSelects = "log_action.type, log_action.name, count(*) as `" . PiwikMetrics::INDEX_PAGE_NB_HITS . "`,";
              $from = array(
                  "log_link_visit_action",
                  array(
                      "table"  => "log_action",
                      "joinOn" => "log_link_visit_action.%s = log_action.idaction"
                  )
              );
              $orderBy = "`" . PiwikMetrics::INDEX_PAGE_NB_HITS . "` DESC, log_action.name ASC";
          } else {
              $extraSelects = false;
              $from = "log_link_visit_action";
              $orderBy = false;
          }
  
          $select = "log_link_visit_action.%s as idaction, $extraSelects
                  sum(log_link_visit_action.time_spent_ref_action) as `" . PiwikMetrics::INDEX_PAGE_SUM_TIME_SPENT . "`";
  
          $where = $this->getLogAggregator()->getWhereStatement('log_link_visit_action', 'server_time');
          $where .= " AND log_link_visit_action.time_spent_ref_action > 0
                   AND log_link_visit_action.%s > 0"
              . $this->getWhereClauseActionIsNotEvent();
  
          $groupBy = "log_link_visit_action.%s";
  
          $this->archiveDayQueryProcess($select, $from, $where, $groupBy, $orderBy, "idaction_url_ref", $rankingQuery);
  
          $this->archiveDayQueryProcess($select, $from, $where, $groupBy, $orderBy, "idaction_name_ref", $rankingQuery);
      }
code: protected function archiveDayActionsTime($rankingQueryLimit)
      {
          $rankingQuery = false;
          if ($rankingQueryLimit > 0) {
              $rankingQuery = new RankingQuery($rankingQueryLimit);
              $rankingQuery->setOthersLabel(DataTable::LABEL_SUMMARY_ROW);
              $rankingQuery->addLabelColumn('idaction');
              $rankingQuery->addColumn(PiwikMetrics::INDEX_PAGE_SUM_TIME_SPENT, 'sum');
              $rankingQuery->partitionResultIntoMultipleGroups('type', array_keys($this->actionsTablesByType));
  
              $extraSelects = "log_action.type, log_action.name, count(*) as `" . PiwikMetrics::INDEX_PAGE_NB_HITS . "`,";
              $from = array(
                  "log_link_visit_action",
                  array(
                      "table"  => "log_action",
                      "joinOn" => "log_link_visit_action.%s = log_action.idaction"
                  )
              );
              $orderBy = "`" . PiwikMetrics::INDEX_PAGE_NB_HITS . "` DESC, log_action.name ASC";
          } else {
              $extraSelects = false;
              $from = "log_link_visit_action";
              $orderBy = false;
          }
  
          $select = "log_link_visit_action.%s as idaction, $extraSelects
                  sum(log_link_visit_action.time_spent_ref_action) as `" . PiwikMetrics::INDEX_PAGE_SUM_TIME_SPENT . "`";
  
          $where = $this->getLogAggregator()->getWhereStatement('log_link_visit_action', 'server_time');
          $where .= " AND log_link_visit_action.time_spent_ref_action > 0
                   AND log_link_visit_action.%s > 0"
              . $this->getWhereClauseActionIsNotEvent();
  
          $groupBy = "log_link_visit_action.%s";
  
          $this->archiveDayQueryProcess($select, $from, $where, $groupBy, $orderBy, "idaction_url_ref", $rankingQuery);
  
          $this->archiveDayQueryProcess($select, $from, $where, $groupBy, $orderBy, "idaction_name_ref", $rankingQuery);
      }
code_tokens: protected function archiveDayActionsTime ( $ rankingQueryLimit ) { $ rankingQuery = false ; if ( $ rankingQueryLimit > 0 ) { $ rankingQuery = new RankingQuery ( $ rankingQueryLimit ) ; $ rankingQuery -> setOthersLabel ( DataTable :: LABEL_SUMMARY_ROW ) ; $ rankingQuery -> addLabelColumn ( 'idaction' ) ; $ rankingQuery -> addColumn ( PiwikMetrics :: INDEX_PAGE_SUM_TIME_SPENT , 'sum' ) ; $ rankingQuery -> partitionResultIntoMultipleGroups ( 'type' , array_keys ( $ this -> actionsTablesByType ) ) ; $ extraSelects = "log_action.type, log_action.name, count(*) as `" . PiwikMetrics :: INDEX_PAGE_NB_HITS . "`," ; $ from = array ( "log_link_visit_action" , array ( "table" => "log_action" , "joinOn" => "log_link_visit_action.%s = log_action.idaction" ) ) ; $ orderBy = "`" . PiwikMetrics :: INDEX_PAGE_NB_HITS . "` DESC, log_action.name ASC" ; } else { $ extraSelects = false ; $ from = "log_link_visit_action" ; $ orderBy = false ; } $ select = "log_link_visit_action.%s as idaction, $extraSelects
                  sum(log_link_visit_action.time_spent_ref_action) as `" . PiwikMetrics :: INDEX_PAGE_SUM_TIME_SPENT . "`" ; $ where = $ this -> getLogAggregator ( ) -> getWhereStatement ( 'log_link_visit_action' , 'server_time' ) ; $ where .= " AND log_link_visit_action.time_spent_ref_action > 0
                   AND log_link_visit_action.%s > 0" . $ this -> getWhereClauseActionIsNotEvent ( ) ; $ groupBy = "log_link_visit_action.%s" ; $ this -> archiveDayQueryProcess ( $ select , $ from , $ where , $ groupBy , $ orderBy , "idaction_url_ref" , $ rankingQuery ) ; $ this -> archiveDayQueryProcess ( $ select , $ from , $ where , $ groupBy , $ orderBy , "idaction_name_ref" , $ rankingQuery ) ; }
docstring: Time per action
docstring_tokens: Time per action