ID && $current_user->has_cap('manage_options')) || $wppmfunction->has_permission('change_task_details',$task_id))) {exit;} $task_data = $wppmfunction->get_task($task_id); $settings = get_option("wppm-ap-modal"); $orderby_proj_sql = esc_sql(sanitize_sql_orderby( "project_name" )); $project_data = $wppmfunction->get_project(intval(sanitize_text_field($task_data['project']))); if($current_user->has_cap('manage_options')){ $projects = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}wppm_project ORDER BY $orderby_proj_sql" ); }else{ $query = ("SELECT Proj.* FROM {$wpdb->prefix}wppm_project AS Proj Left join {$wpdb->prefix}wppm_project_meta proj_meta ON Proj.id = proj_meta.project_id where (FIND_IN_SET($current_user->ID,Proj.users)) OR (Proj.id = proj_meta.project_id AND proj_meta.meta_key='public_project' AND proj_meta.meta_value=1) Group by Proj.id ORDER BY $orderby_proj_sql"); $projects = $wpdb->get_results($query); } $priority_id = sanitize_text_field($task_data['priority']); $project_id = sanitize_text_field($task_data['project']); $priorities = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}wppm_task_priorities"); ob_start(); ?>
$body, 'footer' => $footer ); echo json_encode($output); ?>