ID); $appearance_settings = get_option("wppm-ap-task-list"); $wppm_task_time = get_option('wppm_task_time'); $wppm_current_user_capability = get_user_meta( $current_user->ID, 'wppm_capability', true ); if($current_user->has_cap('manage_options') || $wppm_current_user_capability=='wppm_admin'){ $query = ( "SELECT * FROM {$wpdb->prefix}wppm_task where project='$project_id'"); } else{ $query = ( "SELECT Task.* FROM {$wpdb->prefix}wppm_task AS Task Left join {$wpdb->prefix}wppm_project proj ON Task.project = proj.id Left join {$wpdb->prefix}wppm_project_users proj_users ON Task.project = proj_users.proj_id Left join {$wpdb->prefix}wppm_project_meta proj_meta ON Task.project = proj_meta.project_id where Task.project = '$project_id' AND ((FIND_IN_SET('$cu_id',Task.users)>0) OR (Task.created_by= '$cu_id') OR (proj_users.user_id = '$cu_id' AND proj_users.role_id = 1 AND (FIND_IN_SET('$cu_id',proj.users)>0)) OR (Task.project = proj_meta.project_id AND proj_meta.meta_key='public_project' AND proj_meta.meta_value=1) OR (Task.project = proj.id AND proj.created_by='$cu_id')) Group by Task.id"); } $query = apply_filters('wppm_get_project_tasks_query',$query,$project_id); $tasks = $wpdb->get_results($query); ob_start(); ?>
status); $status = $wpdb->get_row( "SELECT * FROM {$wpdb->prefix}wppm_task_statuses where id = '$tstatus'" ); $users = array(); if($task->users != null){ $users = explode(",",$task->users); } if(!empty($task->priority)){ $tpriority = esc_sql($task->priority); $priority = $wpdb->get_row( "SELECT * FROM {$wpdb->prefix}wppm_task_priorities where id = '$tpriority'" ); } if(!empty($task->project)){ $tproject = esc_sql($task->project); $project = $wpdb->get_row( "SELECT * FROM {$wpdb->prefix}wppm_project where id = '$tproject'" ); } if($wppm_task_time == 1){ $task_start_date = $task->start_date; $task_end_date = $task->end_date; } elseif($wppm_task_time == 0){ $tsDate = new DateTime($task->start_date); $teDate = new DateTime($task->end_date); $task_start_date = $tsDate->format('Y-m-d'); $task_end_date = $teDate->format('Y-m-d'); } ?>
>
id,'taskbuilder') ?> task_name,'taskbuilder') ?> ; color: color))? esc_attr($status->color):""; ?>">name))? esc_html_e($status->name,'taskbuilder'):"" ?> ; color: color))? esc_attr($priority->color):""; ?>">name))? esc_html_e($priority->name,'taskbuilder'):"" ?> ID, 25, "mysteryman"))?> 4){ ?> +
$body, 'footer' => $footer ); echo json_encode($response);