function commerce_reports_sales_data in Commerce Reporting 7.4

Same name and namespace in other branches

1. 7.3 commerce_reports.blocks.inc \commerce_reports_sales_data()

Helper function that retrieves sales data from a certain starting point.

1 call to commerce_reports_sales_data()

commerce_reports_sales in ./commerce_reports.blocks.inc

Implementation of table showing sales overview.

File

./commerce_reports.blocks.inc, line 43

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

Code

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;
}