prefix.'todolist';
$status_table_name = $wpdb->prefix.'todolist_status';
$number = $cleverness_todo_option['dashboard_number'];
$cat_id = $cleverness_todo_option['dashboard_cat'];
// individual view
if ( $cleverness_todo_option['list_view'] == '0' ) {
if ( $cleverness_todo_option['assign'] == '0' )
$sql = "SELECT * FROM $table_name WHERE status = 0 AND ( author = $userdata->ID || assign = $userdata->ID )";
else
$sql = "SELECT * FROM $table_name WHERE status = 0 AND author = $userdata->ID";
}
// group view - show only assigned - show all assigned
elseif ( $cleverness_todo_option['list_view'] == '1' && $cleverness_todo_option['show_only_assigned'] == '0' && (current_user_can($cleverness_todo_option['view_all_assigned_capability'])) )
$sql = "SELECT * FROM $table_name WHERE status = 0";
// group view - show only assigned
elseif ( $cleverness_todo_option['list_view'] == '1' && $cleverness_todo_option['show_only_assigned'] == '0' )
$sql = "SELECT * FROM $table_name WHERE status = 0 AND assign = $userdata->ID";
// group view - show all
elseif ( $cleverness_todo_option['list_view'] == '1' )
$sql = "SELECT * FROM $table_name WHERE status = 0";
// master view with edit capablities
elseif ( $cleverness_todo_option['list_view'] == '2' && current_user_can($cleverness_todo_option['edit_capability']) )
$sql = "SELECT * FROM $table_name WHERE status = 0";
// master view
elseif ( $cleverness_todo_option['list_view'] == '2' ) {
$user = $current_user->ID;
$sql = "SELECT * FROM $table_name WHERE ( id = ANY ( SELECT id FROM $status_table_name WHERE user = $user AND status = 0 ) OR id NOT IN( SELECT id FROM $status_table_name WHERE user = $user AND status = 1 ) ) AND status = 0";
}
// show only one category
if ( $cleverness_todo_option['categories'] == '1' ) {
if ( $cat_id != 'All' )
$sql .= " AND cat_id = $cat_id ";
}
// order by sort order - no categories
if ( $cleverness_todo_option['categories'] == '0' )
$sql .= ' ORDER BY priority, '.$cleverness_todo_option['sort_order'].' LIMIT '.$number;
// order by categories then sort order
else
$sql .= ' ORDER BY cat_id, priority, '.$cleverness_todo_option['sort_order'].' LIMIT '.$number;
$results = $wpdb->get_results($sql);
if ($results) {
foreach ($results as $result) {
$user_info = get_userdata($result->author);
$priority_class = '';
if ($result->priority == '0') $priority_class = ' class="todo-important"';
if ($result->priority == '2') $priority_class = ' class="todo-low"';
if ( $cleverness_todo_option['categories'] == '1' ) {
$cat = cleverness_todo_get_cat_name($result->cat_id);
if ( $catid != $result->cat_id && $cat->name != '' ) echo '