function opigno_statistics_app_query_user_course_update_score in Opigno Statistics App 7

Update user course status All latest required quizzes must passed to pass the course

Parameters

int $user_course_id:

Return value

int (id of new record)

2 calls to opigno_statistics_app_query_user_course_update_score()

opigno_statistics_app_handle_new_quiz_score in ./opigno_statistics_app.module

Handle new quiz score coming from quiz hooks

opigno_statistics_app_migrate_data in ./opigno_statistics_app.install

Migrate opigno data to opigno statistics

File

includes/opigno_statistics_app.queries.inc, line 36

Code

function opigno_statistics_app_query_user_course_update_score($user_course_id) {
  $avg_score = db_query('SELECT AVG(score) FROM {opigno_statistics_user_course_details} WHERE opigno_statistics_user_course_fk = :opigno_statistics_user_course_fk', array(
    ':opigno_statistics_user_course_fk' => $user_course_id,
  ))
    ->fetchField();
  if (!$avg_score) {
    $avg_score = 0;
  }

  //No course details
  return db_update('opigno_statistics_user_course')
    ->fields(array(
    'score' => $avg_score,
    'timestamp' => time(),
  ))
    ->condition('opigno_statistics_user_course_pk', $user_course_id)
    ->execute();
}