function commerce_reports_geckoboard_order_status_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_status_rag()

Order status breakdown

1 string reference to 'commerce_reports_geckoboard_order_status_rag'

commerce_reports_geckoboard_geckoboardapi in modules/geckoboard/commerce_reports_geckoboard.module

Implements hook_geckoboard().

File

modules/geckoboard/commerce_reports_geckoboard.module, line 316

Code

function commerce_reports_geckoboard_order_status_rag() {
  $statuses = array(
    'review',
    'pending',
    'processing',
  );
  $stats = array();
  foreach ($statuses as $status) {
    $result = db_select('commerce_order', 'o')
      ->condition('o.status', $status)
      ->countQuery()
      ->execute()
      ->fetchField();
    $stats[$status] = (int) $result;
  }
  return array(
    'item' => array(
      array(
        'value' => $stats['review'],
        'text' => t('orders requiring review'),
      ),
      array(
        'value' => $stats['pending'],
        'text' => t('pending orders'),
      ),
      array(
        'value' => $stats['processing'],
        'text' => t('processing orders'),
      ),
    ),
  );
}