function course_webform_webform_results_download_submission_information_data in Course 7.2

Same name and namespace in other branches

1. 8.3 modules/course_webform/course_webform.module \course_webform_webform_results_download_submission_information_data()
2. 8.2 modules/course_webform/course_webform.module \course_webform_webform_results_download_submission_information_data()
3. 7 modules/course_webform/course_webform.module \course_webform_webform_results_download_submission_information_data()
4. 3.x modules/course_webform/course_webform.module \course_webform_webform_results_download_submission_information_data()

Implements hook_webform_results_download_submission_information().

Add the course to webform submission data.

File

modules/course_webform/course_webform.module, line 73

Code

function course_webform_webform_results_download_submission_information_data($token, $submission, array $options, $serial_start, $row_count) {
  if (in_array($token, array(
    'course_id',
    'course_title',
  ))) {
    $query = db_select('course_outline_fulfillment', 'cof')
      ->fields('n', array(
      'nid',
      'title',
    ))
      ->condition('cof.instance', strval($submission->sid))
      ->condition('co.object_type', 'webform');
    $query
      ->join('course_outline', 'co', 'co.coid = cof.coid');
    $query
      ->join('node', 'n', 'co.nid = n.nid');
    if ($row = $query
      ->execute()
      ->fetch()) {
      if ($token == 'course_id') {
        return $row->nid;
      }
      if ($token == 'course_title') {
        return $row->title;
      }
    }
  }
}