ID, 'wppm_capability', true ); $wppm_deafault_time_duration_project = get_option('wppm_display_time_duration_project'); $current_date = wp_date('Y-m-d'); $id = isset($_POST) && isset($_POST['id']) ? absint(sanitize_text_field(wp_unslash($_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($wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_project where id = %d",$id)); $orderby_sql = (sanitize_sql_orderby("create_time DESC")); // url authentication. $auth_code = isset( $_POST['auth-code'] ) ? sanitize_text_field( $_POST['auth-code'] ) : ''; // phpcs:ignore if ( ! $auth_code ) { $auth_code = isset( $_POST['auth_code'] ) ? sanitize_text_field( $_POST['auth_code'] ) : ''; // phpcs:ignore } if ( $auth_code && $auth_id == $auth_code ) { $url_auth = true; } $project_comment = $wpdb->get_results($wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_project_comment where proj_id = %d ORDER BY $orderby_sql",$id)); if(isset($project->users)){ $users = explode(",",$project->users); }else{ $users = ""; } $wppm_users_role = get_option('wppm_user_role'); if(isset($project->status)){ $projstatus = absint($project->status); $project_status = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_project_statuses where id = %d",$projstatus)); } if(isset($project->cat_id)){ $projcat = absint($project->cat_id); $project_category = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_project_categories where id = %d",$projcat)); } if(!empty($project->description)){ $project_description = ! empty( $project->description ) ? $project->description : ''; } if($wppm_project_time == 1){ $psDate = new DateTime($project->start_date); $peDate = new DateTime($project->end_date); if($project->start_date=='0000-00-00 00:00:00'){ if($wppm_date_setting=='Y-m-d H:i:s'){ $proj_start_date = '0000-00-00 00:00:00'; }elseif($wppm_date_setting=='d-m-Y H:i:s'){ $proj_start_date = '00-00-0000 00:00:00'; }elseif($wppm_date_setting=='m-d-Y H:i:s'){ $proj_start_date = '00-00-0000 00:00:00'; }else{ $proj_start_date = '0000-00-00 00:00:00'; } }if($project->end_date=='0000-00-00 00:00:00'){ if($wppm_date_setting=='Y-m-d H:i:s'){ $proj_end_date = '0000-00-00 00:00:00'; }elseif($wppm_date_setting=='d-m-Y H:i:s'){ $proj_end_date = '00-00-0000 00:00:00'; }elseif($wppm_date_setting=='m-d-Y H:i:s'){ $proj_end_date = '00-00-0000 00:00:00'; }else{ $proj_end_date = '0000-00-00 00:00:00'; } }if($project->start_date!='0000-00-00 00:00:00'){ if(!empty($wppm_date_setting)){ $proj_start_date = $psDate->format($wppm_date_setting); }else{ $proj_start_date = isset($project->start_date)? $project->start_date:""; } } if($project->end_date!='0000-00-00 00:00:00'){ if(!empty($wppm_date_setting)){ $proj_end_date = $peDate->format($wppm_date_setting); }else{ $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'):""; if($project->start_date=='0000-00-00 00:00:00'){ if($wppm_date_setting=='Y-m-d H:i:s'){ $proj_start_date = '0000-00-00'; }elseif($wppm_date_setting=='d-m-Y H:i:s'){ $proj_start_date = '00-00-0000'; }elseif($wppm_date_setting=='m-d-Y H:i:s'){ $proj_start_date = '00-00-0000'; }else{ $proj_start_date = '0000-00-00'; } } if($project->end_date=='0000-00-00 00:00:00'){ if($wppm_date_setting=='Y-m-d H:i:s'){ $proj_end_date = '0000-00-00'; }elseif($wppm_date_setting=='d-m-Y H:i:s'){ $proj_end_date = '00-00-0000'; }elseif($wppm_date_setting=='m-d-Y H:i:s'){ $proj_end_date = '00-00-0000'; }else{ $proj_end_date = '0000-00-00'; } }else{ if($wppm_date_setting=='Y-m-d H:i:s'){ $proj_start_date = $psDate->format('Y-m-d'); $proj_end_date = $peDate->format('Y-m-d'); }elseif($wppm_date_setting=='d-m-Y H:i:s'){ $proj_start_date = $psDate->format('d-m-Y'); $proj_end_date = $peDate->format('d-m-Y'); }elseif($wppm_date_setting=='m-d-Y H:i:s'){ $proj_start_date = $psDate->format('m-d-Y'); $proj_end_date = $peDate->format('m-d-Y'); }else{ $proj_start_date = !empty($psDate) ? $psDate->format( 'Y-m-d'):""; $proj_end_date = !empty($peDate) ? $peDate->format( 'Y-m-d'):""; } } } $project_data = $wppmfunction->get_project($id); $project_users = explode(",",$project_data['users']); if (!(($current_user->ID && $current_user->has_cap('manage_options')) || in_array($current_user->ID,$project_users) || ($project_data['created_by']==$current_user->ID && $wppm_current_user_capability == 'wppm_manager') || ($current_user->ID && $current_user->has_cap('wppm_admin')) || ((!empty($auth_code)) && $url_auth==true))) { ?>
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) ? new DateTime($project->date_created): ""; if($wppm_project_time !=0){ if($wppm_date_setting=='Y-m-d H:i:s'){ $proj_create_date = !empty($pcDate) ? $pcDate->format('Y-m-d H:i:s'):""; } elseif($wppm_date_setting=='d-m-Y H:i:s'){ $proj_create_date = !empty($pcDate) ? $pcDate->format('d-m-Y H:i:s'):""; } elseif($wppm_date_setting=='m-d-Y H:i:s'){ $proj_create_date = !empty($pcDate) ? $pcDate->format('m-d-Y H:i:s'):""; } else { $proj_create_date = !empty($pcDate) ? $pcDate->format('Y-m-d H:i:s'):""; } } elseif($wppm_project_time == 0){ if($wppm_date_setting=='Y-m-d H:i:s'){ $proj_create_date = !empty($pcDate) ? $pcDate->format('Y-m-d'):""; } elseif($wppm_date_setting=='d-m-Y H:i:s'){ $proj_create_date = !empty($pcDate) ? $pcDate->format('d-m-Y'):""; } elseif($wppm_date_setting=='m-d-Y H:i:s'){ $proj_create_date = !empty($pcDate) ? $pcDate->format('m-d-Y'):""; } else { $proj_create_date = !empty($pcDate) ? $pcDate->format('Y-m-d'):""; } } ?>
status) ? $project->status :""; $style = (!empty($proj_end_date) && $pstatus!=4 && $proj_end_date < $current_date && ($proj_end_date != '0000-00-00 00:00:00' && $proj_end_date != '00-00-0000 00:00:00' && $proj_end_date != '00-00-0000' && $proj_end_date != '0000-00-00')) ? "color:#FF0000":"color:#2C3E50"; ?>
wppm_get_duration($project->start_date,$project->end_date); $pstatus = isset($project->status) ? $project->status :""; $style = (!empty($proj_end_date) && $pstatus!=4 && $proj_end_date < $current_date && ($proj_end_date != '0000-00-00 00:00:00' && $proj_end_date != '00-00-0000 00:00:00' && $proj_end_date != '00-00-0000' && $proj_end_date != '0000-00-00')) ? "color:#FF0000":"color:#2C3E50"; ?>
name))? esc_html($project_category->name):"" ?>
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 = !empty($comment->body) ? wp_kses_post(wpautop($comment->body)) : ''; $date = wp_date("Y-m-d H:i:s" ,strtotime($comment->create_time)); $thread_date = wp_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 = absint($prev_status); $project_prev_status = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_project_statuses where id = %d",$prev_status)); } if(isset($new_status)){ $new_status = absint($new_status); $project_new_status = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_project_statuses where id= %d",$new_status)); } echo esc_html( sprintf(__( 'Changed status from %1$s to %2$s', 'taskbuilder' ),$project_prev_status->name,$project_new_status->name)); } 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); echo sprintf( esc_html__( 'Changed creator from %1$s to %2$s', 'taskbuilder' ), esc_html( $prev_user_data->display_name ), esc_html( $new_user_data->display_name )); } 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 = absint($prev_cat); $project_prev_cat = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_project_categories where id= %d",$prev_cat)); } if(!empty($new_cat)){ $new_cat = absint($new_cat); $project_new_cat = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_project_categories where id=%d",$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"; echo sprintf( esc_html__( 'Changed category from %1$s to %2$s', 'taskbuilder' ), esc_html( $proj_prev_cat_name ), esc_html( $proj_new_cat_name )); } ?>
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( $wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_attachments where id=%d",$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) : "";?>

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($wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_project_users WHERE proj_id = %d AND user_id = %d",$id,$user)); ?>
display_name); ?> $role){ if(!empty($role)){ foreach($role as $k=>$val){ if( !empty($project_user) && $key == $project_user->role_id){ ?> ()
id);?>