wppm_get_auth_code($id); $auth_id = sanitize_text_field($auth_id); // url authentication. $auth_code = isset( $_POST['auth-code'] ) ? sanitize_text_field( wp_unslash($_POST['auth-code'] ) ) : ''; // phpcs:ignore if ( ! $auth_code ) { $auth_code = isset( $_POST['auth_code'] ) ? sanitize_text_field( wp_unslash($_POST['auth_code'] ) ) : ''; // phpcs:ignore } if ( $auth_code && $auth_id == $auth_code ) { $url_auth = true; } if (!(($current_user->ID && $current_user->has_cap('manage_options')) || ($wppmfunction->has_permission('view_task',$id)) || ($url_auth==true))) { ?>
ID, 'wppm_capability', true ); $cu_id = absint($current_user->ID); if(!empty($id)){ $task = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_task where id=%d",$id)); $project_data = $wppmfunction->get_project($task->project); $task_comment = $wpdb->get_results( $wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_task_comment where task_id=%d ORDER BY create_time DESC",$id)); $orderby_proj_sql = (sanitize_sql_orderby( "create_time DESC" )); $task_comment = $wpdb->get_results( $wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_task_comment where task_id=%d ORDER BY ". $orderby_proj_sql,$id)); $task_proj = isset($task->project) ? absint($task->project) :""; $task_id = isset($task->id) ? absint($task->id):""; } $user_role = $wpdb->get_var( $wpdb->prepare("SELECT role_id FROM {$wpdb->prefix}wppm_project_users where proj_id = %d AND user_id = %d",$task_proj,$cu_id)); if(!empty($task_proj)){ $project_name = $wpdb->get_var( $wpdb->prepare("SELECT project_name FROM {$wpdb->prefix}wppm_project where id= %d",$task_proj)); } $wppm_checklist=$wpdb->get_results( $wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_checklist where task_id=%d",$task_id)); if(!empty($task->status)){ $task_status_var = absint($task->status); $task_status = $wpdb->get_row( $wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_task_statuses where id=%d",$task_status_var)); } if(!empty($task->priority)){ $task_priority_var = absint($task->priority); $task_priority = $wpdb->get_row( $wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_task_priorities where id=%d",$task_priority_var)); } if(!empty($task->users)){ $users = explode(",",$task->users); } if(!empty($task->description)){ $task_description = !empty($task->description) ? wp_kses_post(wpautop($task->description)) : ''; } if($wppm_task_time == 1){ $tsDate = new DateTime($task->start_date); $teDate = new DateTime($task->end_date); if($task->start_date=='0000-00-00 00:00:00'){ if($wppm_date_setting=='Y-m-d H:i:s'){ $task_start_date = '0000-00-00 00:00:00'; }elseif($wppm_date_setting=='d-m-Y H:i:s'){ $task_start_date = '00-00-0000 00:00:00'; }elseif($wppm_date_setting=='m-d-Y H:i:s'){ $task_start_date = '00-00-0000 00:00:00'; }else{ $task_start_date = '0000-00-00 00:00:00'; } }if($task->end_date=='0000-00-00 00:00:00'){ if($wppm_date_setting=='Y-m-d H:i:s'){ $task_end_date = '0000-00-00 00:00:00'; }elseif($wppm_date_setting=='d-m-Y H:i:s'){ $task_end_date = '00-00-0000 00:00:00'; }elseif($wppm_date_setting=='m-d-Y H:i:s'){ $task_end_date = '00-00-0000 00:00:00'; }else{ $task_end_date = '0000-00-00 00:00:00'; } }if($task->start_date!='0000-00-00 00:00:00'){ if(!empty($wppm_date_setting)){ $task_start_date = $tsDate->format($wppm_date_setting); }else{ $task_start_date = isset($task->start_date)? $task->start_date:""; } } if($task->end_date!='0000-00-00 00:00:00'){ if(!empty($wppm_date_setting)){ $task_end_date = $teDate->format($wppm_date_setting); }else{ $task_end_date = isset($task->end_date) ? $task->end_date: "" ; } } } elseif($wppm_task_time == 0){ $tsDate = isset($task->start_date) ? new DateTime($task->start_date): ""; $teDate = isset($task->end_date) ? new DateTime($task->end_date):""; $task_start_date = !empty($tsDate) ? $tsDate->format( $wppm_date_setting):""; $task_end_date = !empty($teDate) ? $teDate->format( $wppm_date_setting):""; if($task->start_date=='0000-00-00 00:00:00'){ if($wppm_date_setting=='Y-m-d H:i:s'){ $task_start_date = '0000-00-00'; }elseif($wppm_date_setting=='d-m-Y H:i:s'){ $task_start_date = '00-00-0000'; }elseif($wppm_date_setting=='m-d-Y H:i:s'){ $task_start_date = '00-00-0000'; }else{ $task_start_date = '0000-00-00'; } } if($task->end_date=='0000-00-00 00:00:00'){ if($wppm_date_setting=='Y-m-d H:i:s'){ $task_end_date = '0000-00-00'; }elseif($wppm_date_setting=='d-m-Y H:i:s'){ $task_end_date = '00-00-0000'; }elseif($wppm_date_setting=='m-d-Y H:i:s'){ $task_end_date = '00-00-0000'; } else{ $task_end_date = '0000-00-00'; } }if($task->start_date!='0000-00-00 00:00:00'){ if($wppm_date_setting=='Y-m-d H:i:s'){ $task_start_date = $tsDate->format('Y-m-d'); }elseif($wppm_date_setting=='d-m-Y H:i:s'){ $task_start_date = $tsDate->format('d-m-Y'); }elseif($wppm_date_setting=='m-d-Y H:i:s'){ $task_start_date = $tsDate->format('m-d-Y'); }else{ $task_start_date = $tsDate->format('Y-m-d'); } }if($task->end_date!='0000-00-00 00:00:00'){ if($wppm_date_setting=='Y-m-d H:i:s'){ $task_end_date = $teDate->format('Y-m-d'); }elseif($wppm_date_setting=='d-m-Y H:i:s'){ $task_end_date = $teDate->format('d-m-Y'); }elseif($wppm_date_setting=='m-d-Y H:i:s'){ $task_end_date = $teDate->format('m-d-Y'); }else{ $task_end_date = $teDate->format('Y-m-d'); } } } $flag = false; $wppm_task_fillter = $wpdb->get_results( $wpdb->prepare("SELECT * FROM {$wpdb->prefix}wppm_task where id=%d",$id)); 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 = absint($tproject_id); if(!empty($tusers) && in_array($current_user->ID,$tusers_arr)){ $project_user_role = $wpdb->get_var( $wpdb->prepare("SELECT role_id FROM {$wpdb->prefix}wppm_project_users WHERE proj_id = %d AND user_id = %d",$tproject_id,$cu_id)); $project_users = $wpdb->get_var( $wpdb->prepare("SELECT users FROM {$wpdb->prefix}wppm_project WHERE id = %d",$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( $wpdb->prepare("SELECT created_by FROM {$wpdb->prefix}wppm_project WHERE created_by = %d",$cu_id)); ?>