commerce_reports.blocks.inc in Commerce Reporting 7.4

Provides all statistics and other features that are not powered by Views.

File

commerce_reports.blocks.inc

<?php

/**
 * @file
 * Provides all statistics and other features that are not powered by Views.
 */

/**
 * Implementation of table showing sales overview.
 */
function commerce_reports_sales() {
  $sales = array();
  if ($timestamp = strtotime('first day of this month midnight')) {
    $passed_days = format_date(REQUEST_TIME, 'custom', 'j');
    $month_raw = commerce_reports_sales_data($timestamp, $passed_days);
    $month = commerce_reports_sales_format($month_raw, t('Daily average for @month', array(
      '@month' => format_date($timestamp, 'custom', 'F o'),
    )));
    $sales = array_merge($sales, $month);
    $total_days = format_date($timestamp, 'custom', 't');
    $projected_raw = array();
    foreach ($month_raw as $currency => $row) {
      $projected_raw[$currency] = array(
        'count' => round($row['count'] * $total_days, 2),
        'sum' => round($row['sum'] * $total_days),
      );
    }
    $projected = commerce_reports_sales_format($projected_raw, t('Projected totals for @month', array(
      '@month' => format_date($timestamp, 'custom', 'F o'),
    )));
    $sales = array_merge($sales, $projected);
  }
  return array(
    '#theme' => 'table',
    '#rows' => $sales,
    '#header' => array(
      array(
        'data' => t('Sales Data'),
      ),
      array(
        'data' => t('Number of Orders'),
      ),
      array(
        'data' => t('Revenue'),
      ),
    ),
  );
}

/**
 * Helper function that retrieves sales data from a certain starting point.
 */
function commerce_reports_sales_data($start = 0, $time_periods = 1) {
  $sales = array();
  $result = db_query('SELECT SUM(amount) AS sum, AVG(amount) AS average, COUNT(*) AS count, currency_code
    FROM {commerce_payment_transaction} cpt
    INNER JOIN {commerce_order} co ON cpt.order_id = co.order_id
    WHERE cpt.created >= :start AND cpt.status = :status
    GROUP by cpt.currency_code', array(
    ':status' => 'success',
    ':start' => $start,
  ));
  while ($row = $result
    ->fetchAssoc()) {
    $currency = $row['currency_code'];
    unset($row['currency_code']);
    $sales[$currency] = $row;
    $sales[$currency]['count'] = round($sales[$currency]['count'] / $time_periods, 2);
    $sales[$currency]['sum'] = round($sales[$currency]['sum'] / $time_periods);
  }
  return $sales;
}

/**
 * Helper function that formats the data retrieved from commerce_reports_sales_data() function.
 */
function commerce_reports_sales_format($data, $title) {
  $sales = array();
  foreach ($data as $currency => $row) {
    $sales[] = array(
      $title,
      $row['count'],
      commerce_currency_format($row['sum'], $currency),
    );
  }
  if (empty($sales)) {
    $sales[] = array(
      $title,
      0,
      commerce_currency_format(0, commerce_default_currency()),
    );
  }
  return $sales;
}

Functions

Name	Description
commerce_reports_sales	Implementation of table showing sales overview.
commerce_reports_sales_data	Helper function that retrieves sales data from a certain starting point.
commerce_reports_sales_format	Helper function that formats the data retrieved from commerce_reports_sales_data() function.