function commerce_reports_geckoboard_order_processing_rag in Commerce Reporting 7.3

Same name and namespace in other branches

1. 7.4 modules/geckoboard/commerce_reports_geckoboard.module \commerce_reports_geckoboard_order_processing_rag()

Processing order breakdown

1 string reference to 'commerce_reports_geckoboard_order_processing_rag'

commerce_reports_geckoboard_geckoboardapi in modules/geckoboard/commerce_reports_geckoboard.module

Implements hook_geckoboard().

File

modules/geckoboard/commerce_reports_geckoboard.module, line 278

Code

function commerce_reports_geckoboard_order_processing_rag() {
  $periods = array(
    REQUEST_TIME - 86400 => REQUEST_TIME,
    REQUEST_TIME - 86400 * 2 => REQUEST_TIME - 86400,
    0 => REQUEST_TIME - 86400 * 2,
  );
  $stats = array();
  foreach ($periods as $start => $end) {
    $result = db_select('commerce_order', 'o')
      ->condition('o.status', 'processing')
      ->condition('o.created', $start, '>')
      ->condition('o.created', $end, '<=')
      ->countQuery()
      ->execute()
      ->fetchField();
    $stats[] = (int) $result;
  }
  return array(
    'item' => array(
      array(
        'value' => $stats[2],
        'text' => t('processing orders older than 48h'),
      ),
      array(
        'value' => $stats[1],
        'text' => t('processing orders older than 24h'),
      ),
      array(
        'value' => $stats[0],
        'text' => t('processing orders within the last 24h'),
      ),
    ),
  );
}