ID, 'wppm_capability', true ); $current_date = date('Y-m-d'); $id = isset($_POST) && isset($_POST['id']) ? intval(sanitize_text_field($_POST['id'])) : 0; if (!isset($id)) {exit;} $auth_id = $wppmfunction->get_project_meta($id,'project_auth_code',true); $auth_id = sanitize_text_field($auth_id); $project = $wpdb->get_row( "SELECT * FROM {$wpdb->prefix}wppm_project where id = '".esc_sql($id)."'" ); $orderby_sql = esc_sql(sanitize_sql_orderby("create_time DESC")); $project_comment = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}wppm_project_comment where proj_id='".esc_sql($id)."' ORDER BY $orderby_sql"); if(isset($project->users)){ $users = explode(",",$project->users); }else{ $users = ""; } $wppm_users_role = get_option('wppm_user_role'); if(isset($project->status)){ $projstatus = esc_sql($project->status); $project_status = $wpdb->get_row("SELECT * FROM {$wpdb->prefix}wppm_project_statuses where id = '$projstatus'"); } if(isset($project->cat_id)){ $projcat = esc_sql($project->cat_id); $project_category = $wpdb->get_row("SELECT * FROM {$wpdb->prefix}wppm_project_categories where id = '$projcat'"); } if(!empty($project->description)){ $project_description = stripslashes((htmlspecialchars_decode($project->description, ENT_QUOTES))); } if($wppm_project_time == 1){ $proj_start_date = isset($project->start_date)? $project->start_date:""; $proj_end_date = isset($project->end_date) ? $project->end_date: "" ; } elseif($wppm_project_time == 0){ $psDate = isset($project->start_date) ? new DateTime($project->start_date): ""; $peDate = isset($project->end_date) ? new DateTime($project->end_date):""; $proj_start_date = !empty($psDate) ? $psDate->format('Y-m-d'):""; $proj_end_date = !empty($peDate) ? $peDate->format('Y-m-d'):""; } ?>
has_cap('manage_options') || $wppm_current_user_capability == 'wppm_manager'|| $wppm_current_user_capability == 'wppm_admin'){ ?> plus_icon list-symbol task_list ID && $current_user->has_cap('manage_options')) || ($wppmfunction->has_project_permission('delete_project',$project->id)) || ($project->created_by==$current_user->ID && $wppm_current_user_capability == 'wppm_manager') || ($current_user->ID && $current_user->has_cap('wppm_admin')))? "display:inline":"display:none"; ?> delete ID && ($current_user->has_cap('manage_options') || $current_user->has_cap('wppm_admin') || ($project->created_by==$current_user->ID && $wppm_current_user_capability == 'wppm_manager'))) && ($wppm_public_projects_permission==1))? "display:inline":"display:none"; ?> project_visibility id);?>
project_name) ? esc_html($project->project_name):""; if (($wppmfunction->has_project_permission('change_project_details',$id)) || ($current_user->has_cap('manage_options') || $current_user->has_cap('wppm_admin') || ($project->created_by==$current_user->ID && $wppm_current_user_capability == 'wppm_manager'))) { ?> edit
date_created) ? esc_html($project->date_created):"" ?>
status) ? $project->status :""; $style = ($pstatus!=4 && $proj_end_date < $current_date) ? "color:#FF0000":"color:#2C3E50"; ?>
name))? esc_html_e($project_category->name,'taskbuilder'):"" ?>
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(),)); ?>

get_row( "SELECT * FROM {$wpdb->prefix}wppm_project_comment_meta where proj_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($proj_comment_meta->comment_type) && $proj_comment_meta->comment_type=='change_proj_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); $project_prev_status = $wpdb->get_row("SELECT * FROM {$wpdb->prefix}wppm_project_statuses where id = '$prev_status'"); } if(isset($new_status)){ $new_status = esc_sql($new_status); $project_new_status = $wpdb->get_row("SELECT * FROM {$wpdb->prefix}wppm_project_statuses where id= '$new_status'"); } esc_html_e("changed status from $project_prev_status->name to $project_new_status->name","taskbuilder"); } if(!empty($comment->body) && (isset($proj_comment_meta->comment_type) && $proj_comment_meta->comment_type=='change_proj_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($proj_comment_meta->comment_type) && $proj_comment_meta->comment_type=='change_assign_user')){ esc_html_e("changed the Assignee","taskbuilder"); }if(!empty($comment->body) && (isset($proj_comment_meta->comment_type) && $proj_comment_meta->comment_type=='change_proj_cat')){ $comment_log_body = unserialize($comment->body); $prev_cat = $comment_log_body['prev_cat']; $new_cat = $comment_log_body['new_cat']; if(!empty($prev_cat)){ $prev_cat = esc_sql($prev_cat); $project_prev_cat = $wpdb->get_row("SELECT * FROM {$wpdb->prefix}wppm_project_categories where id= '$prev_cat'"); } if(!empty($new_cat)){ $new_cat = esc_sql($new_cat); $project_new_cat = $wpdb->get_row("SELECT * FROM {$wpdb->prefix}wppm_project_categories where id='$new_cat'"); } $proj_prev_cat_name = !empty($project_prev_cat) ? $project_prev_cat->name: "None"; $proj_new_cat_name = !empty($project_new_cat) ? $project_new_cat->name: "None"; esc_html_e("changed category from $proj_prev_cat_name to $proj_new_cat_name","taskbuilder"); } ?>
has_cap('manage_options')) || ($wppmfunction->has_proj_comment_permission('edit_proj_comment',$id,$comment->id))) && ((empty($proj_comment_meta->comment_type))|| (isset($proj_comment_meta->comment_type) && $proj_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($proj_comment_meta->comment_type)) || (isset($proj_comment_meta->comment_type) && $proj_comment_meta->comment_type=='comment') || $proj_comment_meta->comment_type=='delete_proj_comment')){ echo wp_kses(wpautop($comment_body),$allowedtags) ; } elseif(!empty($comment_body) && (isset($proj_comment_meta->comment_type) && $proj_comment_meta->comment_type=='change_proj_status')){ ?> ;color:color) ? esc_attr($project_prev_status->color): "" ?>;">name) ? esc_attr($project_prev_status->name) : "" ?> arrow_right ;color:color) ? esc_attr($project_new_status->color): "" ?>;">name) ? esc_attr($project_new_status->name) : "" ?>comment_type) && $proj_comment_meta->comment_type=='change_proj_creator')) { ?> display_name) ? esc_attr($prev_user_data->display_name) : "" ?> arrow_right display_name) ? esc_attr($new_user_data->display_name) : "" ?>comment_type) && $proj_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 comment_type) && $proj_comment_meta->comment_type=='change_proj_cat'){ ?> name) ? esc_attr($project_prev_cat->name) : " None" ?> arrow_right name) ? esc_attr($project_new_cat->name) : "None" ?>
comment_type) && $proj_comment_meta->comment_type=='delete_proj_comment')):?>
:
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_proj_comment_permission('edit_proj_comment',$id,$comment->id)))){ ?> cancel
id);?>

has_project_permission('change_project_status',$id) || $current_user->has_cap('manage_options') || ($project->created_by==$current_user->ID && $wppm_current_user_capability == 'wppm_manager') || $wppm_current_user_capability == 'wppm_admin')? "display:flex":"display:none"; ?> edit

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

has_cap('manage_options') || $wppm_current_user_capability == 'wppm_admin'|| ($project->created_by==$current_user->ID && $wppm_current_user_capability == 'wppm_manager')) { ?> edit

created_by)){ $user_info = get_userdata($project->created_by); }else{ $user_info = ""; } ?>
created_by)? (get_avatar($project->created_by, 25, "mysteryman")):""; ?> display_name,'taskbuilder') : "";?>

has_project_permission('assign_project_users',$id ) || $current_user->has_cap('manage_options') || ($project->created_by==$current_user->ID && $wppm_current_user_capability == 'wppm_manager') || $wppm_current_user_capability == 'wppm_admin') { ?> edit

get_row("SELECT * FROM {$wpdb->prefix}wppm_project_users WHERE proj_id = '".esc_sql($id)."' AND user_id = '$user'"); ?>
display_name,'taskbuilder'); ?> $role){ if(!empty($role)){ foreach($role as $k=>$val){ if( !empty($project_user) && $key == $project_user->role_id){ ?> ()