Posted By

ReeceMarsland on 12/21/09

Tagged

php
drupal

Versions (?)

Last Edited at 12/21/09 06:13am

Statistics

Viewed 916 times

Favorited by 0 user(s)

Related snippets

Alphabet Pagination

/ Published in: PHP

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

function sitehelper_get_membernav(){
 
  //get current url to build relative links  
  $base = trim($_GET['q']);
 
  //url matching to prevent multiple arguments for first letter e.g "membership-list/key/a/b"
  if(strstr($base, 'membership-list/key')){
  	$base = 'membership-list/key';
  }elseif (strstr($base, 'membership-list/sponsor')){
  	$base = 'membership-list/sponsor';
  }elseif (strstr($base, 'membership-list/regular')){
  	$base = 'membership-list/regular';
  }else {
  	$base = 'membership-list/all';
  }
 
 
  $terms = '';
  $where = '';
  //join terms table if url has a taxonomy argument
  if($base != 'membership-list/all'){
	  $terms = "LEFT JOIN {term_node} term_node ON node.vid = term_node.vid".
	 						" INNER JOIN {term_data} term_data ON term_node.tid = term_data.tid";
	 	$term = substr($base, 16);
	 	print $term;
	  $where = "AND term_data.name = '".$term."'";
 	}					
  //Select distinct first letters of current nodes
  $result = db_query("SELECT DISTINCT substring( node.title, 1, 1 ) AS letter 
						FROM {node} node 
						LEFT JOIN {content_type_member} content_type_member ON content_type_member.nid = node.nid 
						".$terms."
						WHERE node.type = 'member'
						AND node.status = '1'
						AND content_type_member.nid = node.nid
						".$where."
						ORDER BY node.title ASC");
 
	//array to hold our first letters				
	$items = array();
	while ($row = db_fetch_array($result)) {
 		$items[$row['letter']] = 1;
	}
 
  //Build output for A-Z matching all first letters from $items when possible
	$output = '<a href="/'.$base.'/all">All</a>';
	foreach(range('A','Z') as $i) {
		if($items[$i] == 1) {
	 		$output .= ' | <a href="/'.$base.'/'.strtolower($i).'">'.strtoupper($i).'</a>';
	  } else {
	  	$output .= ' | <span>'.strtoupper($i).'</span>';
	  }
	} 
 
	return $output;
}