custom post type

Taxonomy in custom post column

Posted on August 1st, 2011 by

<?php

/* Add Columns */
function wco_add_columns($defaults){
if($_GET['post_type'] != 'wco_vendor') return $defaults;
$defaults['wco_region'] = __('Region');
return $defaults;
}

/* Get Column Data */
function wco_get_column_data($column,$id){
switch($column){
case 'wco_region':
wco_term_links($id,'wco_region');
break;
}
}

/* Term Links */
function wco_term_links($id,$taxonomy){
$terms = wp_get_object_terms($id,$taxonomy);
$count = count($terms);
$i = 1;
if($count > 0){
foreach($terms as $term){?>
<a href="/wp-admin/edit-tags.php?action=edit&taxonomy=<?php echo $taxonomy . '&tag_ID=' . $term->term_id ?>&post_type=wco_vendor"><?php echo $term->name ?></a><?php if($i < $count) echo ','; $i++ ?>
<?php
}
}
}

add_filter('manage_wco_vendor_posts_columns','wco_add_columns');
add_action('manage_wco_vendor_posts_custom_column','wco_get_column_data',10,2);
?>

Count posts in taxonomy

Posted on April 16th, 2011 by

<?php

global $wpdb;
$query = "
SELECT COUNT( DISTINCT cat_posts.ID ) AS post_count
FROM wp_term_taxonomy AS cat_term_taxonomy INNER JOIN wp_terms AS cat_terms ON
cat_term_taxonomy.term_id = cat_terms.term_id
INNER JOIN wp_term_relationships AS cat_term_relationships
ON cat_term_taxonomy.term_taxonomy_id = cat_term_relationships.term_taxonomy_id
INNER JOIN wp_posts AS cat_posts
ON cat_term_relationships.object_id = cat_posts.ID
WHERE cat_posts.post_status = 'publish'
AND cat_posts.post_type = 'post'
AND cat_term_taxonomy.taxonomy = 'my_taxonomy'
AND cat_terms.slug IN ('term_slug','term-slug2')
";
return $wpdb->get_var($query);
?>