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 = $wpdb->prepare( "SELECT * FROM {$wpdb->prefix}wppm_task WHERE project = %d", $project_id ); } else{ $query = $wpdb->prepare( "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 = %d AND (FIND_IN_SET(%d, Task.users) > 0 OR Task.created_by = %d OR ( proj_users.user_id = %d AND proj_users.role_id = 1 AND FIND_IN_SET(%d, proj.users) > 0 ) OR ( proj_meta.meta_key = 'public_project' AND proj_meta.meta_value = 1 ) OR proj.created_by = %d ) GROUP BY Task.id", $project_id,$cu_id, $cu_id,$cu_id,$cu_id, $cu_id ); } $query = apply_filters('wppm_get_project_tasks_query',$query,$project_id); $tasks = $wpdb->get_results($query); ob_start(); ?>

get_row( $wpdb->prepare( "SELECT * FROM {$wpdb->prefix}wppm_task_statuses WHERE id = %d", (int) $task->status ) ); $users = array(); if($task->users != null){ $users = explode(",",$task->users); } if(!empty($task->priority)){ $priority = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM {$wpdb->prefix}wppm_task_priorities WHERE id = %d", (int) $task->priority)); } if(!empty($task->project)){ $project = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM {$wpdb->prefix}wppm_project WHERE id = %d",(int) $task->project)); } 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); ?>	task_name); ?>	; color: color))? esc_attr($status->color):""; ?>">name))? esc_html($status->name):"" ?>	; color: color))? esc_attr($priority->color):""; ?>">name))? esc_html($priority->name):"" ?>	ID, 25, "mysteryman"))?> 4){ ?> +

$body, 'footer' => $footer ); echo wp_json_encode($response);