Created
April 7, 2011 01:21
-
-
Save scribu/906872 to your computer and use it in GitHub Desktop.
'price' sortable column example
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
// Register the column | |
function price_column_register( $columns ) { | |
$columns['price'] = __( 'Price', 'my-plugin' ); | |
return $columns; | |
} | |
add_filter( 'manage_edit-post_columns', 'price_column_register' ); | |
// Display the column content | |
function price_column_display( $column_name, $post_id ) { | |
if ( 'price' != $column_name ) | |
return; | |
$price = get_post_meta($post_id, 'price', true); | |
if ( !$price ) | |
$price = '<em>' . __( 'undefined', 'my-plugin' ) . '</em>'; | |
echo $price; | |
} | |
add_action( 'manage_posts_custom_column', 'price_column_display', 10, 2 ); | |
// Register the column as sortable | |
function price_column_register_sortable( $columns ) { | |
$columns['price'] = 'price'; | |
return $columns; | |
} | |
add_filter( 'manage_edit-post_sortable_columns', 'price_column_register_sortable' ); | |
function price_column_orderby( $vars ) { | |
if ( isset( $vars['orderby'] ) && 'price' == $vars['orderby'] ) { | |
$vars = array_merge( $vars, array( | |
'meta_key' => 'price', | |
'orderby' => 'meta_value_num' | |
) ); | |
} | |
return $vars; | |
} | |
add_filter( 'request', 'price_column_orderby' ); |
Works here even without the _price_column_orderby_ function?
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
@Rarst: Thank you so much for sharing that tweak.
The request filter is applied globally so its a good practice to apply it where required:-
global $pagenow, $post_type;
if (is_admin() && $pagenow == 'edit.php' && $post_type == 'product' && isset($_GET['orderby']) && $_GET['orderby'] == 'sponsor')
{
$Request = array_merge($Request, array(
'meta_key' => 'fh_sponsor_level',
'orderby' => 'meta_value_num'
));
}