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))) { ?>