ID && $current_user->has_cap('manage_options')) || ($wppmfunction->has_permission('view_task',$id)))) {exit;} $proj_id = isset($_POST) && isset($_POST['proj_id']) ? intval(sanitize_text_field($_POST['proj_id'])) : 0; $auth_id = $wppmfunction->wppm_get_auth_code($id); $auth_id = sanitize_text_field($auth_id); $current_date = date('Y-m-d'); $wppm_current_user_capability = get_user_meta( $current_user->ID, 'wppm_capability', true ); $cu_id = $current_user->ID; if(!empty($id)){ $task = $wpdb->get_row( "SELECT * FROM {$wpdb->prefix}wppm_task where id='".esc_sql($id)."'"); $project_data = $wppmfunction->get_project($task->project); $task_comment = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}wppm_task_comment where task_id='".esc_sql($id)."' ORDER BY create_time DESC"); $orderby_proj_sql = esc_sql(sanitize_sql_orderby( "create_time DESC" )); $task_comment = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}wppm_task_comment where task_id='".esc_sql($id)."' ORDER BY ". $orderby_proj_sql); $task_proj = isset($task->project) ? esc_sql($task->project) :""; $task_id = isset($task->id) ? esc_sql($task->id):""; } $user_role = $wpdb->get_var( "SELECT role_id FROM {$wpdb->prefix}wppm_project_users where proj_id = '$task_proj' AND user_id = '$cu_id'"); if(!empty($task_proj)){ $project_name = $wpdb->get_var( "SELECT project_name FROM {$wpdb->prefix}wppm_project where id= '$task_proj'"); } $wppm_checklist=$wpdb->get_results( "SELECT * FROM {$wpdb->prefix}wppm_checklist where task_id='$task_id'" ); if(!empty($task->status)){ $task_status_var = esc_sql($task->status); $task_status = $wpdb->get_row( "SELECT * FROM {$wpdb->prefix}wppm_task_statuses where id='$task_status_var'"); } if(!empty($task->priority)){ $task_priority_var = esc_sql($task->priority); $task_priority = $wpdb->get_row( "SELECT * FROM {$wpdb->prefix}wppm_task_priorities where id='$task_priority_var'"); } if(!empty($task->users)){ $users = explode(",",$task->users); } if(!empty($task->description)){ $task_description = stripslashes((htmlspecialchars_decode($task->description, ENT_QUOTES))); } 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'); } $flag = false; $wppm_task_fillter = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}wppm_task"); if(!empty($wppm_task_fillter)){ foreach($wppm_task_fillter as $key_filter=>$val_filter){ $val_array = (array) $val_filter; $tusers = $val_array['users']; $tusers_arr = explode(',',$tusers); $tproject_id = $val_array['project']; $tproject_id = esc_sql($tproject_id); if(!empty($tusers) && in_array($current_user->ID,$tusers_arr)){ $project_user_role = $wpdb->get_var("SELECT role_id FROM {$wpdb->prefix}wppm_project_users WHERE proj_id = '$tproject_id' AND user_id = '$cu_id'"); $project_users = $wpdb->get_var("SELECT users FROM {$wpdb->prefix}wppm_project WHERE id = '$tproject_id'"); $project_users_arr = explode(',',(string)$project_users); if((!empty($project_user_role)) && ($project_user_role == 1) && in_array($current_user->ID,$project_users_arr)){ $flag= true; break; } } } } $project_creator = $wpdb->get_var("SELECT created_by FROM {$wpdb->prefix}wppm_project WHERE created_by = '$cu_id'"); ?>
has_cap('manage_options') || $wppmfunction->has_permission('add_new_task',$task_id) || ($flag==true) || $project_creator!=""){ $style = "display:inline;"; }else{ $style = "display:none;"; } $style = apply_filters('wppm_add_new_task_btn_style_open_task_form',$style); if($proj_id==0) { ?> add add list list ID && $current_user->has_cap('manage_options')) || ($wppmfunction->has_permission('delete_task',$id)) || $wppm_current_user_capability == 'wppm_admin'|| $project_data['created_by']==$current_user->ID )? "display:inline":"display:none"; ?> ID && $current_user->has_cap('manage_options') || $wppm_current_user_capability == 'wppm_admin') || ($wppmfunction->has_permission('clone_task',$id)) || $project_data['created_by']==$current_user->ID )? "display:inline":"display:none"; ?> delete
clone
task_name,'taskbuilder'); if ($wppmfunction->has_permission('change_task_details',$id) || $current_user->has_cap('manage_options') || $wppm_current_user_capability == 'wppm_admin') { ?> edit
date_created))? esc_html($task->date_created):"" ?>
status!=4 && $task->end_date < $current_date) ? "color:#FF0000":"color:#2C3E50"; ?>
;color:color))? esc_html($task_priority->color):""?>;">name)) ? esc_html_e($task_priority->name,'taskbuilder'):"" ?>
id, $task->project);?>
$list){ ?>
checklistchecklist_name,'taskbuilder');?>
created_by == $current_user->ID || $current_user->has_cap('manage_options') || $user_role == 1 || $wppmfunction->has_permission('edit_checklist',$task->id)))? "display:inline":"display:none"; ?> created_by == $current_user->ID || $current_user->has_cap('manage_options') || $user_role == 1 || $wppmfunction->has_permission('delete_checklist',$task->id)|| ($wppmfunction->has_permission('add_checklist',0))))? "":"disabled"; ?> has_permission('add_checklist',$task->id) || $current_user->has_cap('manage_options')){ ?>
0%
id); $wppm_checklist_items = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}wppm_checklist_items where checklist_id='$list_id'"); ?> $val){ $checked = $val->checked == 1 ? 'checked="checked"' : ''; ?>
value="id) ?>" style="margin:5px;">
created_by == $current_user->ID || $current_user->has_cap('manage_options') || $user_role == 1 || $wppmfunction->has_permission('delete_checklist',$task->id)) { ?>
has_permission('add_checklist',$task->id) || $current_user->has_cap('manage_options')){ ?>
has_permission('add_checklist',$task->id) || $current_user->has_cap('manage_options')){ ?>

has_permission('add_checklist',$task->id) || $current_user->has_cap('manage_options')){ ?>


get_row( "SELECT * FROM {$wpdb->prefix}wppm_task_comment_meta where task_id='".esc_sql($id)."' AND comment_id='".esc_sql($comment->id)."'"); $user = get_userdata( $comment->created_by ); $comment_body = stripslashes((htmlspecialchars_decode($comment->body, ENT_QUOTES))); $comment_body = preg_replace('#(.*?)#is', '', $comment_body); $date = date("Y-m-d H:i:s" ,strtotime($comment->create_time)); $thread_date = date("d F Y, h:i:s A" ,strtotime($date)); $attachment_ids = isset($comment->attachment_ids)? $comment->attachment_ids : ''; if($attachment_ids!=""){ $attachments = explode(",",$attachment_ids); } else { $attachments = array(); } ?>
created_by, 40));?>
display_name) ?> body) && (isset($task_comment_meta->comment_type) && $task_comment_meta->comment_type=='change_task_status')){ $comment_log_body = unserialize($comment->body); $prev_status = $comment_log_body['prev_status']; $new_status = $comment_log_body['new_status']; if(isset($prev_status)){ $prev_status = esc_sql($prev_status); $task_prev_status = $wpdb->get_row("SELECT * FROM {$wpdb->prefix}wppm_task_statuses where id='$prev_status'"); } if(isset($new_status)){ $new_status = esc_sql($new_status); $task_new_status = $wpdb->get_row("SELECT * FROM {$wpdb->prefix}wppm_task_statuses where id='$new_status'"); } esc_html_e("changed status from $task_prev_status->name to $task_new_status->name","taskbuilder"); } if(!empty($comment->body) && (isset($task_comment_meta->comment_type) && $task_comment_meta->comment_type=='change_task_creator')){ $comment_log_body = unserialize($comment->body); $prev_user = $comment_log_body['prev_user']; $new_user = $comment_log_body['new_user']; $prev_user_data = get_userdata($prev_user); $new_user_data = get_userdata($new_user); esc_html_e("changed creator from $prev_user_data->display_name to $new_user_data->display_name","taskbuilder"); } if( !empty($comment->body) && (isset($task_comment_meta->comment_type) && $task_comment_meta->comment_type=='change_assign_user')){ esc_html_e("changed the Assignee","taskbuilder"); } if(!empty($comment->body) && (isset($task_comment_meta->comment_type) && $task_comment_meta->comment_type=='change_task_priority')){ $comment_log_body = unserialize($comment->body); $prev_prio = $comment_log_body['prev_prio']; $new_prio = $comment_log_body['new_prio']; if(isset($prev_prio)){ $prev_prio = esc_sql($prev_prio); $task_prev_prio = $wpdb->get_row("SELECT * FROM {$wpdb->prefix}wppm_task_priorities where id= '$prev_prio'"); } if(isset($new_prio)){ $new_prio = esc_sql($new_prio); $task_new_prio = $wpdb->get_row("SELECT * FROM {$wpdb->prefix}wppm_task_priorities where id= '$new_prio'"); } $task_prev_prio_name = !empty($task_prev_prio) ? $task_prev_prio->name: "None"; $task_new_prio_name = !empty($task_new_prio) ? $task_new_prio->name: "None"; esc_html_e("changed priority from $task_prev_prio_name to $task_new_prio_name","taskbuilder"); } ?>
has_cap('manage_options')) || ($wppmfunction->has_comment_permission('edit_task_comment',$id,$comment->id))) && ((empty($task_comment_meta->comment_type)) || (isset($task_comment_meta->comment_type) && $task_comment_meta->comment_type=='comment')))){ ?> edit delete
array(), 'abbr' => array('title' => array(),), 'p' => array(), 'strong' => array(), 'a' => array('href' => array(), 'title' => array(), 'target'=> array(), 'rel'=>array()),'em' =>array(),'span' =>array(), 'blockquote'=>array('cite' => array(),),'div' => array('class' => array(),'title' => array(),'style' => array(),),'ul'=>array(),'li'=>array(),'ol'=>array(),'img' => array( 'alt'=> array(),'class' => array(),'height' => array(),'src'=> array(),'width'=> array(),)); if(!empty($comment_body) && ((empty($task_comment_meta->comment_type)) || (isset($task_comment_meta->comment_type) && $task_comment_meta->comment_type=='comment') || (isset($task_comment_meta->comment_type) && $task_comment_meta->comment_type=='delete_task_comment'))){ echo wp_kses(wpautop($comment_body),$allowedtags) ; } elseif(!empty($comment->body) && (isset($task_comment_meta->comment_type) && $task_comment_meta->comment_type=='change_task_status')){ ?> ;color:color) ? esc_attr($task_prev_status->color): "" ?>;">name) ? esc_attr($task_prev_status->name) : "" ?> arrow_right ;color:color) ? esc_attr($task_new_status->color): "" ?>;">name) ? esc_attr($task_new_status->name) : "" ?>body) && (isset($task_comment_meta->comment_type) && $task_comment_meta->comment_type=='change_task_creator')){ ?> display_name) ? esc_attr($prev_user_data->display_name) : "" ?> arrow_right display_name) ? esc_attr($new_user_data->display_name) : "" ?>body) && (isset($task_comment_meta->comment_type) && $task_comment_meta->comment_type=='change_assign_user')) { $comment_log_body = unserialize($comment->body); $prev_assign_user = $comment_log_body['prev_assign_user']; $new_assign_user = $comment_log_body['new_assign_user']; $prev_assign_user_array = array(); $new_assign_user_array = array(); if(!empty($prev_assign_user)){ $prev_assign_user_array = explode(",",$prev_assign_user); } if(!empty($new_assign_user)){ $new_assign_user_array = explode(",",$new_assign_user); } $assign_user_name = array(); $assign_user_name_str = ""; if(!empty($prev_assign_user_array)){ foreach($prev_assign_user_array as $val){ $assign_user = get_userdata($val); $assign_user_name[] = $assign_user->display_name; } $assign_user_name_str = implode(",",$assign_user_name); } $new_assign_user_name = array(); $new_assign_user_name_str = ""; if(!empty($new_assign_user_array)){ foreach($new_assign_user_array as $val){ $new_assign_user = get_userdata($val); $new_assign_user_name[] = $new_assign_user->display_name; } $new_assign_user_name_str = implode(",",$new_assign_user_name); } ?> arrow_right body) && (isset($task_comment_meta->comment_type) && $task_comment_meta->comment_type=='change_task_priority')){ ?> ;color:color) ? esc_attr($task_prev_prio->color): "" ?>;">name) ? esc_attr($task_prev_prio->name) : "None" ?> arrow_right ;color:color) ? esc_attr($task_new_prio->color): "" ?>;">name) ? esc_attr($task_new_prio->name) : "None" ?>
comment_type) && !($task_comment_meta->comment_type=='delete_task_comment'))):?>
:
id.'"&tac='.$auth_id; $attachment = esc_sql($attachment); $attach = $wpdb->get_row( "SELECT * FROM {$wpdb->prefix}wppm_attachments where id='$attachment'"); $findStr = ".txt"; if(!empty( $attach)){ $attachment_name = preg_replace('/' . $findStr . '/', "", $attach->name, 1); $attachment_name = sanitize_file_name($attachment_name); } if((!empty($attachment_name))){ ?>
file_name) ? esc_html($attach->file_name):"";?> created_by == $current_user->ID) || ($current_user->has_cap('manage_options')) || ($wppmfunction->has_comment_permission('edit_task_comment',$id,$comment->id)))){ ?> cancel
id);?>

has_cap('manage_options') || $wppm_current_user_capability == ('wppm_admin') || ($flag==true) || ($wppmfunction->has_permission('change_task_status',$id))!=""){ ?> edit

: ;color:color))? esc_attr($task_status->color):""?>;">name))? esc_attr($task_status->name):"" ?>

has_permission('change_raised_by',$id ) || $current_user->has_cap('manage_options')) { ?> edit

created_by)){ $user_info = get_userdata($task->created_by); }else{ $user_info =""; } ?>
created_by, 25, "mysteryman")); ?> display_name)?esc_html($user_info->display_name):""; ?>

has_permission('assign_task_users',$id ) || $current_user->has_cap('manage_options')) { ?> edit

display_name) :"") ?>