Fix for Argument handler for terms restricted to vocabulary

This fix will not be saved to the database until you submit.

Summary:

Tags:

Any tags you'd like to associate with your code, delimitered by commas (example: Views, CCK, Module, etc).

Source code: *

function vocab_id_from_typename($typename)
{
  return end(explode('_', $typename));
}

function views_handler_tc_taxinvoc($op, &$query, $argtype, $arg = '') {
 static $field = NULL;
/* drupal_set_message($op);
 echo "\n op \n";
 echo "$op \n";
 echo "query \n";
 print_r($query);
 echo "argtype \n";
 print_r($argtype);
 echo "arg \n";
 print_r($arg);
 echo " vocab id would be: ";
 echo vocab_id_from_typename($argtype);*/
 echo " \n";
 echo $op;
 echo " \n";
 switch($op) {
 case 'summary':
 //$argtype has typename
 //summary for the second one won't work
 $tnum = $query->add_table('term_data', true);
 $tablename = $query->get_table_name('term_data', $tnum);
 $len = intval($arg);
 $field = $fieldinfo['field'] = ($len <= 0 ? "$tablename.name" : "LEFT($tablename.name, $len)");

$fieldinfo['fieldname'] = 'letter';
      $query->add_field('tid', $tablename);
      $query->add_where('%s.name IS NOT NULL', $tablename);
      $vid = vocab_id_from_typename($argtype);
      $query->add_where('%s.vid = %d', $tablename, $vid);
      return $fieldinfo;
      break;
    case 'sort':
      //no typename
      //this looks ok, sorts summary by name.
      $query->add_orderby('', $field, $argtype, 'letter');
      break;
    case 'filter':
      //$argtype['type'] has typename
      $len = intval($argtype['options']);
      
      $tnum = $query->add_table('term_node');
      $tablename = $query->get_table_name('term_node', $tnum);

$tnum = $query->add_table('term_data', true, 1, array('left' => array('table' => $tablename, 'field' => 'tid'), 'right' => array('field' => 'tid')));
 $tablename = $query->get_table_name('term_data', $tnum);
 $vid = vocab_id_from_typename($argtype['type']);
 $query->add_where($tablename . '.vid = %d', $vid);
 
 if ($len <= 0) {
 $query->add_where("%s.name = '%s'", $tablename, $arg);
 } else {
 $query->add_where("LEFT(%s.name, $len) = '%s'", $tablename, $arg);
 }
 break;
 case 'link':
 //$argtype has typename
 //this is fine
 return l($query->letter, "$arg/$query->letter");
 case 'title':
 //$argtype has typename
 //I guess this is fine too, for now.
 return check_plain($query);
 }
}

Syntax highlighting mode:

Select the syntax highlighting mode to use.

DrupalBin

Recent Posts

Tags

User login

Fix for Argument handler for terms restricted to vocabulary