Return to Snippet

Revision: 38599
at January 5, 2011 20:06 by thefrosty


Updated Code
/**
 * Lets manage the new column
 *
 * @ref http://wordpress.org/support/topic/custom-post-type-admin-ui-with-custom-taxonomies
 * @ref http://wordpress.org/support/topic/add-id-column-to-custom-taxonomy-admin-display-1
 * @help http://snipplr.com/view/46538/manage-custom-taxonomy-column-meta/ (??)
 * @since 0.1.0
 */
function manage_venues_column( $tag, $column_name ) {
	global $wpdb, $taxonomy, $post, $post_type;
	
	/* get_metadata( $meta_type, $object_id, $meta_key = '', $single = false ) */
	
	$address 	= get_metadata( 'venues', get_venues_id_by_key( 'address' ), 'address', true );
    $city 		= get_metadata( 'venues', get_venues_id_by_key( 'city' ), 'city', true );
    $state 		= get_metadata( 'venues', get_venues_id_by_key( 'state' ), 'state', true );
    $zip 		= get_metadata( 'venues', get_venues_id_by_key( 'zip' ), 'zip', true );
	
	$gmaps = 'http://maps.google.com/maps?q=';
		if ( !empty( $address ) )
			$gmaps .= urlencode( $address );
		if ( !empty( $city ) )
			$gmaps .= '+' . urlencode( $city );
		if ( !empty( $state ) )
			$gmaps .= ',+' . urlencode( $state );
		if ( !empty( $zip ) )
			$gmaps .= '+' . urlencode( $zip );
		
	$map_script = "<script type='text/javascript'>jQuery(document).ready( function() {
			jQuery('th#maps.manage-column.column-maps').css({ textAlign: 'center', width: '10%' });
			jQuery('td.maps.column-maps').css({ textAlign: 'center', width: '10%' });
		});</script>";
	
	$edit_link = get_edit_term_link( $tag->term_id, $taxonomy, $post_type ); //Not correct, need old query_var_something....
		
	switch( $column_name ) {
	case 'maps' :		
		if ( !empty( $address ) ) {
			echo $map_script . '<a href="'.$gmaps.'" target="_blank" style="color:green"><strong>&radic;</strong></a>';
		} else {
			echo $map_script . '<a class="nomap" href="' . $edit_link . '" style="color:red"><strong>&chi;</strong></a>' . var_dump( get_venues_id_by_key( 'address' ) );
		}
		break;
	}
 
}

/**
 * Try to get the ID by way of $wpdb
 *
 * @ref http://wpseek.com/blog/2010/how-to-get-the-meta-id-by-meta-key/80/
 * @since 0.1.0
 */
function get_venues_id_by_key( $meta_key ) {
	global $wpdb;
	
	$venue = $wpdb->get_var( $wpdb->prepare( "SELECT venues_id FROM $wpdb->venuesmeta WHERE meta_key = %s", $meta_key ) );
	
	if ( $venue != '' )
		return (int)$venue;
	
	return false;
}

Revision: 38598
at January 5, 2011 17:35 by thefrosty


Updated Code
function manage_venues_column( $tag, $column_name ) {
	global $wpdb, $taxonomy;
	$wpdb->venuesmeta = $wpdb->prefix . 'venuesmeta';

if ( empty( $tag ) )
			$tag = 'venues';
	
	/* get_metadata( $meta_type, $object_id, $meta_key = '', $single = false ) */
	
	$address 	= get_metadata( $tag->taxonomy, $tag->term_id, 'address', true );
    $city 		= get_metadata( $tag->taxonomy, $tag->term_id, 'city', true );
    $state 		= get_metadata( $tag->taxonomy, $tag->term_id, 'state', true );
    $zip 		= get_metadata( $tag->taxonomy, $tag->term_id, 'zip', true );
	
	$gmaps = 'http://maps.google.com/maps?q=';
		if ( !empty( $address ) )
			$gmaps .= urlencode( $address );
		if ( !empty( $city ) )
			$gmaps .= '+' . urlencode( $city );
		if ( !empty( $state ) )
			$gmaps .= ',+' . urlencode( $state );
		if ( !empty( $zip ) )
			$gmaps .= '+' . urlencode( $zip );
		
	$map_script = "<script type='text/javascript'>jQuery(document).ready( function() {
			jQuery('th#maps.manage-column.column-maps').css({ textAlign: 'center', width: '10%' });
			jQuery('td.maps.column-maps').css({ textAlign: 'center', width: '10%' });
		});</script>";
		
	switch( $column_name ) {
	case 'maps' :		
		if ( !empty( $address ) ) {
			echo $map_script . '<a href="'.$gmaps.'" target="_blank" style="color:green"><strong>&radic;</strong></a>';
		} else {
			echo $map_script . '<a class="nomap" href="" style="color:red"><strong>&chi;</strong></a>';
		}
		break;
	}
 
}

Revision: 38597
at January 5, 2011 17:23 by thefrosty


Initial Code
function manage_venues_column( $tag, $column_name ) {
	global $wpdb, $taxonomy;
	$wpdb->venuesmeta = $wpdb->prefix . 'venuesmeta';
	
	/* get_metadata( $meta_type, $object_id, $meta_key = '', $single = false ) */
	
	$address 	= get_metadata( $tag->taxonomy, $tag->term_id, 'address', true );
    $city 		= get_metadata( $tag->taxonomy, $tag->term_id, 'city', true );
    $state 		= get_metadata( $tag->taxonomy, $tag->term_id, 'state', true );
    $zip 		= get_metadata( $tag->taxonomy, $tag->term_id, 'zip', true );
	
	$gmaps = 'http://maps.google.com/maps?q=';
		if ( !empty( $address ) )
			$gmaps .= urlencode( $address );
		if ( !empty( $city ) )
			$gmaps .= '+' . urlencode( $city );
		if ( !empty( $state ) )
			$gmaps .= ',+' . urlencode( $state );
		if ( !empty( $zip ) )
			$gmaps .= '+' . urlencode( $zip );
		
	$map_script = "<script type='text/javascript'>jQuery(document).ready( function() {
			jQuery('th#maps.manage-column.column-maps').css({ textAlign: 'center', width: '10%' });
			jQuery('td.maps.column-maps').css({ textAlign: 'center', width: '10%' });
		});</script>";
		
	switch( $column_name ) {
	case 'maps' :		
		if ( !empty( $address ) ) {
			echo $map_script . '<a href="'.$gmaps.'" target="_blank" style="color:green"><strong>&radic;</strong></a>';
		} else {
			echo $map_script . '<a class="nomap" href="" style="color:red"><strong>&chi;</strong></a>';
		}
		break;
	}
 
}

Initial URL


Initial Description
It's working now. Just having issue with it applying to all columns. Need to keep checking. (IE. have to tax's for testing, only one has the additional meta info attached, but they are both showing in the column as having the address as "active" (using same addy for both) will play more ).

Initial Title
Manage Custom $taxonomy column meta

Initial Tags
wordpress

Initial Language
PHP