Club Drupal

/**

 * @file

 */

/**

 * Relationship handler that allows a groupwise maximum of the linked in table.

 * For a definition, see:

 * http://dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group-row.html

 * In lay terms, instead of joining to get all matching records in the linked

  /**

   * Defines default values for options.

   */

    $options = parent::option_definition();

    $options['subquery_sort'] = array('default' => NULL);

  }

  /**

   */

    parent::options_form($form, $form_state);

    // Get the sorts that apply to our base.

      '#default_value' => !empty($this->options['subquery_sort']) ? $this->options['subquery_sort'] : $this->definition['base'] . '.' . $base_table_data['table']['base']['field'],

      '#options' => $sort_options,

      '#description' => theme('advanced_help_topic', array('module' => 'views', 'topic' => 'relationship-representative')) .

    );

    $form['subquery_order'] = array(

      '#default_value' => $this->options['subquery_namespace'],

    );

    // A list of suitable views to pick one as the subview.

    $views = array('' => '<none>');

    $all_views = views_get_all_views();

      // - base must the base that our relationship joins towards

      // - must have fields.

      if ($view->base_table == $this->definition['base'] && !empty($view->display['default']->display_options['fields'])) {

        // or let users hang themselves at this stage and check later?

        if ($view->type == 'Default') {

          $views[t('Default Views')][$view->name] = $view->name;

   *

   * We use this to obtain our subquery SQL.

   */

    views_include('view');

    $view = new view();

    $view->base_table = $this->definition['base'];

    $view->add_display('default');

    return $view;

  /**

   * When the form is submitted, take sure to clear the subquery string cache.

   */

    $cid = 'views_relationship_groupwise_max:' . $this->view->name . ':' . $this->view->current_display . ':' . $this->options['id'];

    cache_clear_all($cid, 'cache_views_data');

  }

   * generate the subquery when the options are saved, rather than when the view

   * is run. This saves considerable time.

   *

   *    The subquery SQL string, ready for use in the main query.

   */

    // Either load another view, or create one on the fly.

    if ($options['subquery_view']) {

      $temp_view = views_get_view($options['subquery_view']);

      unset($temp_view->display['default']->display_options['fields']);

    }

    else {

      $temp_view = $this->get_temporary_view();

      // Add the sort from the options to the default display.

      $sort_options = array('order' => $options['subquery_order']);

      $temp_view->add_item('default', 'sort', $sort_table, $sort_field, $sort_options);

    }

    // Get the namespace string.

    // The value we add here does nothing, but doing this adds the right tables

    // and puts in a WHERE clause with a placeholder we can grab later.

    $base_field = $views_data['table']['base']['field'];

    $temp_view->add_item('default', 'field', $this->definition['base'], $this->definition['field']);

    $temp_view->add_item(

      'default',

      'argument',

    );

    // Build the view. The creates the query object and produces the query

    // somewhat so we can get the SQL query from it.

    $subquery = $temp_view->build_info['query'];

    // Remove all fields from the SELECT except the base id.

    $fields =& $subquery->getFields();

    foreach (array_keys($fields) as $field_name) {

      }

    }

    $tables =& $subquery->getTables();

    foreach (array_keys($tables) as $table_name) {

      $tables[$table_name]['alias'] .= $this->subquery_namespace;

    $where =& $subquery->conditions();

    $this->alter_subquery_condition($subquery, $where);

    // Not sure why, but our sort order clause doesn't have a table.

    // wrong -- needs attention from someone who understands it.

    $orders =& $subquery->getOrderBy();

    foreach ($orders as $order_key => $order) {

    }

    // The query we get doesn't include the LIMIT, so add it here.

    $subquery->range(0, 1);

    // Extract the SQL the temporary view built.

    $subquery_sql = $subquery->__toString();

    return $subquery_sql;

  }

   *

   * (Though why is the condition we get in a simple query 3 levels deep???)

   */

    foreach ($conditions as $condition_id => &$condition) {

      // Skip the #conjunction element.

      if (is_numeric($condition_id)) {

   *

   * Turns 'foo.bar' into 'foo_NAMESPACE.bar'.

   */

    return str_replace('.', $this->subquery_namespace . '.', $string);

  }

   * This is mostly a copy of our parent's query() except for this bit with

   * the join class.

   */

    // Figure out what base table this relationship brings to the party.

    $table_data = views_fetch_data($this->definition['base']);

    $base_field = empty($this->definition['base field']) ? $table_data['table']['base']['field'] : $this->definition['base field'];

    $join->construct();

    $join->adjusted = TRUE;

    $alias = $def['table'] . '_' . $this->table;

    $this->alias = $this->query->add_relationship($alias, $join, $this->definition['base'], $this->relationship);

  }

}