function course_views_handler_relationship_ce_cr::query in Course 6

Same name and namespace in other branches

1. 8.3 views/handlers/course_views_handler_relationship_ce_cr.inc \course_views_handler_relationship_ce_cr::query()
2. 8.2 views/handlers/course_views_handler_relationship_ce_cr.inc \course_views_handler_relationship_ce_cr::query()
3. 7.2 views/handlers/course_views_handler_relationship_ce_cr.inc \course_views_handler_relationship_ce_cr::query()
4. 7 views/handlers/course_views_handler_relationship_ce_cr.inc \course_views_handler_relationship_ce_cr::query()

Called to implement a relationship in a query.

File

views/handlers/course_views_handler_relationship_ce_cr.inc, line 11

Class

course_views_handler_relationship_ce_cr

Create a relationship from the course report to course enrolment.

Code

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);
}