function opigno_statistics_app_query_course_avg_score in Opigno Statistics App 7

Retrieve course AVG score (cached for 1 day)

Parameters

int $course_nid:

Return value

float

File

includes/opigno_statistics_app.queries.inc, line 10

Code

function opigno_statistics_app_query_course_avg_score($course_nid) {
  $cache_key = __FUNCTION__ . ':' . $course_nid;
  $cached_object = cache_get($cache_key);
  if ($cached_object) {
    $avg_score = $cached_object->data;
  }
  else {
    $avg_score = db_query('SELECT AVG(score) FROM {opigno_statistics_user_course} WHERE course_nid = :course_nid', array(
      ':course_nid' => $course_nid,
    ))
      ->fetchField();
    cache_set($cache_key, $avg_score, 'cache', time() + 7200);

    // 7200s = 2h cache
  }
  return $avg_score;
}