<?php

// $Id: content_taxonomy_views.module,v 1.1.4.2 2008-01-29 11:30:39 mh86 Exp $

/**
 * @file
 * Views Support for content_taxonomy
 **/

/**
 * Implementation of hook_help().
 **/
function content_taxonomy_views_help($section) {
  switch ($section) {
    case 'admin/modules#description':
      return t('Views support for content_taxonomy. <em>Note: Requires views.module.</em>');
  }
}

function content_taxonomy_views_views_tables() {
  $tables = array();

  $fields = content_fields();
  $info = _content_type_info();
  
  foreach ($fields as $field) {
    if ($field['type'] == 'content_taxonomy') {
      
      //get out parent for opt groups
      foreach ($info['content types'] as $content_type) {
        foreach ($content_type['fields'] as $field_name => $field_info) {
          if ($field_name == $field['field_name']) {
            if (isset($field_info['widget']['group_tid'])) {
              $group_tid = $field_info['widget']['group_tid'];
            }
          }
        }
      }
      
      if ($field['save'] != 'tag') {
        $db_info = content_database_info($field);
        $tablename = $db_info['table'];
        $fieldname = $field['field_name'] .'_value';
        $table['name'] = $db_info['table'];
    		$table['join'] = array(
    		  'left' => array(
            'table' => 'node',
            'field' => 'vid',
    		  ),
          'right' => array(
            'field' => 'vid',
    		  ),
    	  );
      }
      else {
        $tablename = 'content_taxonomy_'. $field['field_name'];
        $table['name'] = 'term_node';
        $fieldname = "tid";
    		$table['join'] = array(
    		  'left' => array( 
            'table' => 'node', 
            'field' => 'nid', 
          ),
          'right' => array( 
            'field' => 'nid', 
          ),
    	  );
      }
      
      $tables[$tablename] = array();
      $tables[$tablename] = $table;
      
      $tables[$tablename] += array( 
        'provider' => 'internal', 
	      'fields' => array( 
          $fieldname => array(
            'name' => 'Content Taxonomy Field: '. $field['field_name'],
	          'sortable' => TRUE,
            'parent' => $field['tid'],
	          'voc_id' => $field['vid'],
            'content_field' => $field,
            'content_db_info' => $db_info,
          ),
        ),
        'filters' => array(
          $fieldname => array(
            'name' => 'Content Taxonomy Field: '. $field['field_name'],
            'list' => 'views_handler_filter_terms_by_parent',
            'list-type' => isset($field['multiple']) ? 'list' : 'select',
            'value-type' => 'array',
            'option' => 'string',
            'operator' => 'views_handler_operator_andor',
            'parent' => $field['tid'],
            'voc_id' => $field['vid'],
        	  'group' => $group_tid,
          ),
        )
      );
      if ($field['save'] == 'tag') {
        $tables[$tablename]['filters'][$fieldname]['handler'] = "views_handler_filter_tid_custom";
        $tables[$tablename]['fields'][$fieldname]['handler'] = array( 
          'content_taxonomy_views_field_terms_by_parent' => t('Show value'));
        $tables[$tablename]['fields'][$fieldname]['notafield'] = TRUE; 
      }
      else {
        $tables[$tablename]['fields'][$fieldname]['handler'] = array(
          'content_taxonomy_views_field_handler_group' => t('Group multiple values'),
          'content_taxonomy_views_field_handler_ungroup' => t('Do not group multiple values'));
      }
      
    }
  }

      
  return $tables;
}


/**
 * Implementation of hook_views_arguments()
 **/
function content_taxonomy_views_views_arguments() {
  $arguments = array();
  $fields = content_fields();
  
  foreach ($fields as $field) {
    if ($field['type'] == 'content_taxonomy' && $field['save'] != 'tag') {
      $arguments += array(
        'taxid_'. $field['field_name'] => array(
          'name' => 'Content Taxonomy Field: Term ID: '. $field['field_name'],
          'handler' => 'content_taxonomy_views_argument_handler_taxid',
          'option' => 'string',
          'help' => t('The argument will filter by a taxonomy term ID. For this argument, set the option to the depth to search. (Does not support summary, sort and link)'),
        ),
        'taxletter_'. $field['field_name']  => array(
          'name' => 'Content Taxonomy Field: Term Name: '. $field['field_name'],
          'handler' => 'content_taxonomy_views_argument_handler_taxletter',
          'option' => 'string',
          'help' => t('The argument will filter by a taxonomy term name. For this argument, set the option to the depth to search. (Does not support summary, sort and link)'),
        ),
      );
    }
  }
  return $arguments;
}


/**
 * Perform filtering by an argument (as term id) for field data stored via content taxonomy 
 */
function content_taxonomy_views_argument_handler_taxid($op, &$query, $argtype, $arg = '') {
  if ($op == 'filter') {
    $field_name = substr($argtype['type'], 6);
  }
  else {
    $field_name = substr($argtype, 6);
  }

  $field = content_fields($field_name);
  $db_info = content_database_info($field);
  $main_column = reset($db_info['columns']);

  // The table name used here is the Views alias for the table, not the actual
  // table name.
  $table = 'node_data_'. $field['field_name'];

  switch ($op) {
    case 'summary':
      $query->ensure_table($table);
      $query->add_field($main_column['column'], $table);
      return array('field' => $table .'.'. $main_column['column']);
      break;

    case 'sort':
      break;

    case 'filter':
      $query->ensure_table($table);
      $column_placeholder = '%d';
      
      if ($argtype['options'] == '-1') {
        $th_num = $query->add_table('term_hierarchy', false, 1, array('left' => array('table' => $table, 'field' => $main_column['column']), 'right' => array('field' => 'parent')));
        $th_table = $query->get_table_name('term_hierarchy', $th_num);
        
        $query->add_where($th_table .'.tid = %d', $arg);   
      }
      else if ($argtype['options'] == '1') {
        $th_num = $query->add_table('term_hierarchy', false, 1, array('left' => array('table' => $table, 'field' => $main_column['column']), 'right' => array('field' => 'tid')));
        $th_table = $query->get_table_name('term_hierarchy', $th_num);
        
        $query->add_where($th_table .'.parent = %d', $arg);  
      }
      else {
        $query->add_where($table .'.'. $main_column['column'] .' = '. $column_placeholder, $arg);
      }
      break;

    case 'link':
      break;

    case 'title':
      $item = array(key($db_info['columns']) => $query);

      return content_format($field, $item, 'plain');
  }
}

/**
 * Perform filtering by an argument (as term name) for field data stored via content taxonomy 
 */
function content_taxonomy_views_argument_handler_taxletter($op, &$query, $argtype, $arg = '') {
  if ($op == 'filter') {
    $field_name = substr($argtype['type'], 10);
  }
  else {
    $field_name = substr($argtype, 10);
  }
  $field = content_fields($field_name);
  $db_info = content_database_info($field);
  $main_column = reset($db_info['columns']);

  // The table name used here is the Views alias for the table, not the actual
  // table name.
  $table = 'node_data_'. $field['field_name'];

  switch ($op) {
    case 'summary':
      $query->ensure_table($table);
      $query->add_field($main_column['column'], $table);
      return array('field' => $table .'.'. $main_column['column']);
      break;

    case 'sort':
      break;

    case 'filter':
      $query->ensure_table($table);
      
      if ($argtype['options'] == '-1') {
        $th_num = $query->add_table('term_hierarchy', false, 1, array('left' => array('table' => $table, 'field' => $main_column['column']), 'right' => array('field' => 'parent')));
        $th_table = $query->get_table_name('term_hierarchy', $th_num);
        
        $td_num = $query->add_table('term_data', false, 1, array('left' => array('table' => $th_table, 'field' => 'tid'), 'right' => array('field' => 'tid')));
        $td_table = $query->get_table_name('term_data', $td_num);
        
        $query->add_where($td_table .".name = '%s'", $arg);
      }
      else if ($argtype['options'] == '1') {
        $th_num = $query->add_table('term_hierarchy', false, 1, array('left' => array('table' => $table, 'field' => $main_column['column']), 'right' => array('field' => 'tid')));
        $th_table = $query->get_table_name('term_hierarchy', $th_num);
        
        $td_num = $query->add_table('term_data', false, 1, array('left' => array('table' => $th_table, 'field' => 'parent'), 'right' => array('field' => 'tid')));
        $td_table = $query->get_table_name('term_data', $td_num);
        
        $query->add_where($td_table .".name = '%s'", $arg);
      }
      else {
        $td_num = $query->add_table('term_data', false, 1, array('left' => array('table' => $table, 'field' => $main_column['column']), 'right' => array('field' => 'tid')));
        $td_table = $query->get_table_name('term_data', $td_num);
        
        $query->add_where($td_table .".name = '%s'", $arg);
      }
      break;

    case 'link':
      break;
      
    case 'title':
      return check_plain($arg);
  }
}

/**
 * Display all the terms for a given parent term
 */
function content_taxonomy_views_field_terms_by_parent($fieldinfo, $fielddata, $value, $data) {
  $terms = array();
  $names = array();
  
  
  if ($fieldinfo['parent']) {    
    $terms = content_taxonomy_terms_by_field(node_load($data->nid), $fieldinfo['voc_id'], $fieldinfo['parent'], 1);
  }
  if (is_array($terms)) {
	  foreach ($terms as $term) {
	    $names[] = $term->name;
	  }
	  return implode(', ', $names);
  }
}

function content_taxonomy_views_field_handler_group($fieldinfo, $fielddata, $value, $data) {
  if ($fieldinfo['content_field']['multiple']) {
    $fielddata['options'] = 'default';
    $result = content_views_field_handler_group($fieldinfo, $fielddata, $value, $data);
    return $result;
  }
  else {
    return  content_taxonomy_views_field_handler_group($fieldinfo, $fielddata, $value, $data);
  }
}

function content_taxonomy_views_field_handler_ungroup($fieldinfo, $fielddata, $value, $data) {
  $term = taxonomy_get_term($value);
  return $term->name;
}

/**
 * Create a list of terms for a given parent, optional with optgroups
 */
function views_handler_filter_terms_by_parent($op, $filterinfo) {
  $options = array();
  foreach (taxonomy_get_children($filterinfo['parent']) as $term) {
    $options[$term->tid] = $term->name;
  }

  if ($filterinfo['group']) {
    foreach (taxonomy_get_children($filterinfo['group']) as $group) {
      foreach (taxonomy_get_children($group->tid) as $term) {
        $options[$group->name][$term->tid] = $term->name;
        unset($options[$term->tid]);
      }
    }
  }
  return $options;
}


?>