get_var($wpdb->prepare("SELECT count FROM $wpdb->term_taxonomy
WHERE taxonomy = '%s' AND term_id = %d",
$assignment_desk->custom_taxonomies->assignment_status_label,
$status->term_id));
$count = $count ? $count : 0;
return $count;
}
function count_user_posts_by_assignment_status($status){
global $current_user, $wpdb, $assignment_desk;
get_currentuserinfo();
$counts = array();
if ( ! $assignment_desk->coauthors_plus_exists() ){
return $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->posts
LEFT JOIN $wpdb->term_relationships ON($wpdb->posts.ID = $wpdb->term_relationships.object_id)
LEFT JOIN $wpdb->term_taxonomy ON($wpdb->term_taxonomy.term_taxonomy_id = $wpdb->term_relationships.term_taxonomy_id)
WHERE $wpdb->posts.post_author = '$current_user->ID'
AND $wpdb->posts.post_status != 'publish'
AND $wpdb->posts.post_status != 'inherit'
AND $wpdb->posts.post_status != 'trash'
AND $wpdb->posts.post_status != 'auto-draft'
AND $wpdb->term_taxonomy.taxonomy = 'assignment_status'
AND $wpdb->term_taxonomy.term_id = $status->term_id ");
}
else {
return 0;
}
}
function widget() {
global $assignment_desk, $current_user, $wpdb;
get_currentuserinfo();
$assignment_statuses = $assignment_desk->custom_taxonomies->get_assignment_statuses();
if($_REQUEST['ad-dashboard-editor-messages']){
foreach($_REQUEST['ad-dashboard-assignment-messages'] as $messages){
echo "$message
";
}
}
?>
By assignment status
define_editor_permissions) ) {
foreach ( $assignment_statuses as $assignment_status ) {
$count = $this->count_posts_by_assignment_status($assignment_status);
if ( $count ) {
$url = admin_url() . "/edit.php?ad-assignment-status=$assignment_status->term_id";
echo "| " . $count . " | ";
echo "$assignment_status->name |
";
}
}
$this_month_url = admin_url() . '/edit.php?post_status=publish&monthnum=' . date('M');
$q = new WP_Query( array('post_status' => 'publish', 'monthnum' => date('M')));
echo "| $q->found_posts | ";
echo "" . _('Published this month', 'assignment-desk') . " |
";
}
else {
foreach ( $assignment_statuses as $assignment_status ) {
$count = $this->count_user_posts_by_assignment_status($assignment_status);
if ( $count ) {
$url = admin_url() . "/edit.php?ad-assignment-status=$assignment_status->term_id";
echo "| " . $count . " | ";
echo "$assignment_status->name |
";
}
}
}
?>
get_results("SELECT post_id FROM $wpdb->postmeta
WHERE meta_key = '_ad_participant_{$current_user->ID}'
ORDER BY post_id");
if ( ! $participant_posts ){
$participant_posts = array();
}
$roles = $assignment_desk->custom_taxonomies->get_user_roles();
$max_pending = 5;
foreach($participant_posts as $post ){
foreach($roles as $user_role){
// Get all of the roles this user has for this post
$participant_record = get_post_meta($post->post_id, "_ad_participant_role_$user_role->term_id", true);
if($participant_record) {
foreach ($participant_record as $user_id => $status ){
if( $user_id == $current_user->ID && $status == 'pending' ){
$pending_posts[] = array($post->post_id, $user_role);
$max_pending--;
}
}
}
}
if(!$max_pending){
break;
}
}
$count_pending = count($pending_posts);
if ( $count_pending ) {
echo "$count_pending pending assignment";
echo ($count_pending != 1)? 's': '';
echo "
";
echo "";
foreach($pending_posts as $pending) {
$post = get_post($pending[0]);
echo "";
echo "| {$post->post_title} | {$pending[1]->name} | ";
echo "Accept ";
echo "Decline | ";
echo "
";
}
echo "