alex or mr vibe certificate course completion date

please ask help from #alex in this. i dont think you can help in this. the issue is with course completion date code. it's my code to sync the generated certificate code with the "document manager plugin". in this video you can understand what am i doing: http://somup.com/crQ3FPrdbP when pdf certificate is generated in the media folder. i sync the same certificate with "document manager plugin". then user can download it. what is the issue?? the course completion date is showing weired. sometimes it shows fine like in video "22 september 2021" but when same course is completed 2 times. then it should show the latest course completion date. but sometimes it shows the older date means the first time when you completed the course. i think i am missing something in this code with date thing.

add_shortcode('certificate_link',function( $atts,$content = null ){
	$a = shortcode_atts( array( 'user_id' => ' ', 'course_id' => ' ' ), $atts );
	
	global $wpdb;
	$suffix = $filesize = '';
	
	if( !empty($a['course_id']) && !empty($a['user_id']) ){
		
		$course_id = esc_attr($a['course_id']);
		$course_id = (int)$course_id;
		
		$user_id = esc_attr($a['user_id']);
		$user_id = (int)$user_id;

		$user_info = get_userdata($user_id);
		$userlogin = $user_info->user_login;
		
		$admin_user_id = 1; //as users folder is in id 1
		
		//get users folder ID
		$query = "SELECT *  FROM " . $wpdb->prefix . "sp_cu_project  where name = 'Users' ";
  		$result = $wpdb->get_results($query, ARRAY_A);
		if(count($result)>0){
			$user_pid = $result[0]['id'];
		}
		if( !empty($user_pid) ){
			//check if user's folder is created in Users' folder
			$query = "SELECT *  FROM " . $wpdb->prefix . "sp_cu_project  where name = '".$userlogin."'";
			$res = $wpdb->get_results($query, ARRAY_A);
			if(count($res)>0){
				$pid = $res[0]['id'];
			}else{
				$wm_insert = array();
				$wm_insert['name'] = $userlogin;
				$wm_insert['uid'] = $admin_user_id;
				$wm_insert['parent'] = $user_pid; //Users Folder

				foreach($wm_insert as $key=>$value){
					if(is_null($value)){ unset($insert[$key]); }
				}
				$wpdb->insert("" . $wpdb->prefix . "sp_cu_project", $wm_insert);
				do_action('sp_cdm/save_folder', $wpdb->insert_id,$wm_insert);
				$pid = $wpdb->insert_id;

				cdm_delete_cache();
			}
			if( !empty($pid) ){
				//check user certificate folder
				$query1 = "SELECT *  FROM " . $wpdb->prefix . "sp_cu_project  where name = 'Certificates' AND parent = $pid ";
				$res1 = $wpdb->get_results($query1, ARRAY_A);
				if(count($res1)>0){
					$c_folderid = $res1[0]['id']; 
				}else{
					$wm_insert = array();
					$wm_insert['name'] = 'Certificates';
					$wm_insert['uid'] = $admin_user_id;
					$wm_insert['parent'] = $pid;

					foreach($wm_insert as $key=>$value){
						if(is_null($value)){ unset($insert[$key]); }
					}
					$wpdb->insert("" . $wpdb->prefix . "sp_cu_project", $wm_insert);
					do_action('sp_cdm/save_folder', $wpdb->insert_id,$wm_insert);
					$c_folderid = $wpdb->insert_id;

					cdm_delete_cache();
				}
			}
		}
		
		$filepath = bp_get_course_certificate('user_id=' . $user_id . '&course_id=' . $course_id);
		$filepath_certi = strstr($filepath, '?', true);
		
		$filename = urldecode( basename( str_replace( array( '%2F', '%5C' ), '/', urlencode( $filepath ) ), $suffix ) );
		$filename = strstr($filename, '?', true);
		$filename = apply_filters('sp_cdm/premium/upload/file_name', $filename, $user_id);
		$filename = strtolower($filename);
    	$filename = sanitize_file_name($filename);
    	$filename = remove_accents($filename);
    	$filename = apply_filters('sp_cdm/premium/upload/file_rename', $filename, $user_id);
		
		$headers = get_headers($filepath, true);
		$filesize = $headers['Content-Length'];
	
		$dir = '' . SP_CDM_UPLOADS_DIR . '' . $admin_user_id . '/';
		$target_path = $dir . $filename;
		
		if(is_file($filepath_certi)){
			echo 'yes<br/>';
		}else{
			echo 'no<br/>';
		}
		if(file_exists($filepath_certi)){
			echo 'yes file<br/>';
		}else{
			echo 'no file<br/>';
		}
		
		/*if ( copy($filepath_certi, $target_path) ) {
			echo "Uploaded<br/>";
			$a = array();
			$a['name'] = $filename;
			$a['file'] = $filename;
			$a['pid'] = $c_folderid;
			$a['cid'] = 0;
			$a['notes'] = '';
			$a['parent'] = 0;
			$a['uid'] = $admin_user_id; //same as target dir userid
			$a['file_size'] = $filesize;
			foreach($a as $key=>$value){ if(is_null($value)){ unset($a[$key]); } }
			$wpdb->insert(  "".$wpdb->prefix."sp_cu", $a );
			$insert_id = $wpdb->insert_id;
		}else {
		  	echo "File was not uploaded<br/>";
		}*/
		if(!@copy("'$filepath_certi'","'$target_path'"))
		{
			$errors= error_get_last();
			echo "COPY ERROR: ".$errors['type'];
			echo "<br />\n".$errors['message'];
		} else {
			echo "File copied from remote!";
		}
	}
	return $user_id.' '.$course_id.' '.$user_pid.' '.$pid.' '.$c_folderid.' '.$filepath_certi.' '.$target_path.' '.$insert_id;
});
add_shortcode('delete_certificate',function( $atts,$content = null ){
	$a = shortcode_atts( array( 'user_id' => ' ', 'course_id' => ' ' ), $atts );
	
	global $wpdb;
	$suffix = $filesize = '';
	
	if( !empty($a['course_id']) && !empty($a['user_id']) ){
		
		$course_id = esc_attr($a['course_id']);
		$course_id = (int)$course_id;
		
		$user_id = esc_attr($a['user_id']);
		$user_id = (int)$user_id;
		
		$user_info = get_userdata($user_id);
		$userlogin = $user_info->user_login;
		
		$filepath = bp_get_course_certificate('user_id=' . $user_id . '&course_id=' . $course_id);
		
		$filename = urldecode( basename( str_replace( array( '%2F', '%5C' ), '/', urlencode( $filepath ) ), $suffix ) );
		$filename = strstr($filename, '?', true);
		$filename = apply_filters('sp_cdm/premium/upload/file_name', $filename, $user_id);
		$filename = strtolower($filename);
    	$filename = sanitize_file_name($filename);
    	$filename = remove_accents($filename);
    	$filename = apply_filters('sp_cdm/premium/upload/file_rename', $filename, $user_id);
		
		$query = "SELECT *  FROM " . $wpdb->prefix . "sp_cu_project  where name = '".$userlogin."'";
		$res = $wpdb->get_results($query, ARRAY_A);
		if(count($res)>0){
			$pid = $res[0]['id'];
		}
		if(!empty($pid)){
			$query1 = "SELECT *  FROM " . $wpdb->prefix . "sp_cu_project  where name = 'Certificates' AND parent = $pid ";
			$res1 = $wpdb->get_results($query1, ARRAY_A);
			if(count($res1)>0){
				$c_folderid = $res1[0]['id']; 
			}
		}
		if(!empty($c_folderid))
		//get file ID
		$query = "SELECT *  FROM " . $wpdb->prefix . "sp_cu  where name = '".$filename."' AND pid = $c_folderid AND recycle = 0";
  		$result = $wpdb->get_results($query, ARRAY_A);
		if(count($result)>0){
			$file_id = $result[0]['id'];
			cdm_delete_file($file_id);
		}
		
		return $user_id.' '.$course_id.' '.$file_id;
	}
});