course_views_handler_relationship_ce_cr.inc in Course 6

File

views/handlers/course_views_handler_relationship_ce_cr.inc

<?php

/**
 * Create a relationship from the course report to course enrolment.
 */
class course_views_handler_relationship_ce_cr extends views_handler_relationship {

  /**
   * Called to implement a relationship in a query.
   */
  function query() {

    // Figure out what base table this relationship brings to the party.
    $join = new views_join_course();
    $join->definition = array(
      'table' => 'course_enrolment',
      'field' => 'uid',
      'left_table' => !empty($this->relationship) ? $this->relationship : 'course_report',
      'left_field' => 'uid',
      'extra' => array(
        array(
          'field' => 'nid',
          'value' => (!empty($this->relationship) ? $this->relationship : 'course_report') . '.nid',
          'numeric' => TRUE,
        ),
      ),
    );
    $join
      ->construct();
    $this
      ->ensure_my_table();
    $alias = $join->definition['table'] . '_' . $join->definition['left_table'];
    $this->alias = $this->query
      ->add_relationship($alias, $join, $this->definition['base'], $this->relationship);
  }

}

Classes

Name	Description
course_views_handler_relationship_ce_cr	Create a relationship from the course report to course enrolment.