'cleverness_todo_list', 'description' => __('Lists To-Do Items', 'cleverness-to-do-list') );
$control_ops = array( 'width' => 300, 'height' => 350, 'id_base' => 'cleverness-to-do-widget' );
$this->WP_Widget( 'cleverness-to-do-widget', __('To-Do List Widget', 'cleverness-to-do-list'), $widget_ops, $control_ops );
}
function widget( $args, $instance ) {
global $wpdb, $cleverness_todo_option, $userdata;
get_currentuserinfo();
extract( $args );
$title = apply_filters('widget_title', $instance['title'] );
$number = $instance['number'];
$assignedto = $instance['assigned_to'];
$deadline = $instance['deadline'];
$progress = $instance['progress'];
$category = $instance['category'];
if ( $cleverness_todo_option['list_view'] == '0' && $userdata->ID != NULL ) {
if ( $cleverness_todo_option['assign'] == '0' )
$author = "AND ( author = $userdata->ID || assign = $userdata->ID )";
else
$author = " AND author = $userdata->ID ";
}
echo $before_widget;
if ( $title )
echo $before_title . $title . $after_title;
echo '';
$table_name = $wpdb->prefix . 'todolist';
$cat_table_name = $wpdb->prefix . 'todolist_cats';
$sort = $cleverness_todo_option['sort_order'];
if ( $cleverness_todo_option['categories'] == '0' ) {
$sql = "SELECT * FROM $table_name WHERE status = 0 $author ORDER BY priority, $sort LIMIT $number";
} else {
if ( $category != 'All' )
$sql = "SELECT * FROM $table_name WHERE status = 0 $author AND cat_id = $category ORDER BY priority, $sort LIMIT $number";
else
$sql = "SELECT * FROM $table_name LEFT JOIN $cat_table_name ON $table_name.cat_id = $cat_table_name.id WHERE status = 0 $author AND $cat_table_name.visibility = 0 ORDER BY cat_id, priority, $table_name.$sort LIMIT $number";
}
$results = $wpdb->get_results($sql);
if ($results) {
foreach ($results as $result) {
if ( $cleverness_todo_option['categories'] == '1' && $category == 'All' ) {
$cat = cleverness_todo_get_cat_name($result->cat_id);
if ( $catid != $result->cat_id && $cat->name != '' ) echo '
'.$cat->name.'
';
$catid = $result->cat_id;
}
echo '- '.stripslashes($result->todotext);
if ( $result->progress != '' && $progress == true )
echo ' - '.$result->progress.'%';
if ( $deadline == true && $result->deadline != '' )
echo '
'.__('Deadline: ', 'cleverness-to-do-list').$result->deadline.'';
if ( $assignedto == true && $result->assign != '') {
$assign_user = '';
if ( $result->assign != '-1' )
$assign_user = get_userdata($result->assign);
echo '
'.__('Assigned to ', 'cleverness-to-do-list').$assign_user->display_name.'';
}
echo ' ';
}
} else {
echo '- '.__('No items to do.', 'cleverness-to-do-list').'
';
}
echo '
';
echo $after_widget;
}
function update( $new_instance, $old_instance ) {
$instance = $old_instance;
$instance['title'] = strip_tags( $new_instance['title'] );
$instance['number'] = $new_instance['number'];
$instance['assigned_to'] = $new_instance['assigned_to'];
$instance['deadline'] = $new_instance['deadline'];
$instance['progress'] = $new_instance['progress'];
$instance['category'] = $new_instance['category'];
return $instance;
}
function form( $instance ) {
global $wpdb, $cleverness_todo_option;
$defaults = array( 'title' => __('To-Do List', 'cleverness-to-do-list'), 'number' => '5', 'assigned_to' => false, 'deadline' => false, 'progress' => false, 'category' => 'All');
$instance = wp_parse_args( (array) $instance, $defaults ); ?>
id="get_field_id( 'assigned_to' ); ?>" name="get_field_name( 'assigned_to' ); ?>" />
id="get_field_id( 'deadline' ); ?>" name="get_field_name( 'deadline' ); ?>" />
id="get_field_id( 'progress' ); ?>" name="get_field_name( 'progress' ); ?>" />