studentResults/resultUploadStatusForInstitute

Created by: Radheshhathwar

attendance/getByExamCycle

src/main/java/com/tarento/upsmf/examsAndAdmissions/repository/AttendanceRepository.java

@@ -11,4 +11,6 @@ public interface AttendanceRepository extends JpaRepository<AttendanceRecord, Lo
     boolean existsByStudentEnrollmentNumber(String studentEnrollmentNumber);
     AttendanceRecord findByStudentEnrollmentNumber(String studentEnrollmentNumber);
     List<AttendanceRecord> findByExamCycleId(Long examCycleId);
+
+    List<AttendanceRecord> findByExamCycleData(String examCycleName);
 }
\ No newline at end of file

src/main/java/com/tarento/upsmf/examsAndAdmissions/repository/ExamCycleRepository.java

@@ -15,6 +15,9 @@ public interface ExamCycleRepository extends JpaRepository<ExamCycle, Long> {
     // Fetch all non-obsolete records
     List<ExamCycle> findByObsolete(Integer value);
 
+    @Query("SELECT ec.examCycleName FROM ExamCycle ec WHERE ec.id = :examCycleId")
+    String getExamCycleNameById(@Param("examCycleId") Long examCycleId);
+
     // Fetch a non-obsolete record by ID
     Optional<ExamCycle> findByIdAndObsolete(Long id, Integer value);
     ExamCycle findByExamCycleName(String name);

src/main/java/com/tarento/upsmf/examsAndAdmissions/repository/ExamRepository.java

@@ -26,4 +26,5 @@ public interface ExamRepository extends JpaRepository<Exam, Long> {
 
     @Query("SELECT e FROM Exam e JOIN StudentExamRegistration ser ON e.id = ser.exam.id WHERE ser.student.id = :studentId AND e.examCycleId = :examCycleId")
     List<Exam> findRegisteredExamsForStudentInCycle(Long studentId, Long examCycleId);
+    String getExamNameById(Long exam);
 }

src/main/java/com/tarento/upsmf/examsAndAdmissions/repository/StudentResultRepository.java

@@ -2,6 +2,7 @@ package com.tarento.upsmf.examsAndAdmissions.repository;
 
 import com.tarento.upsmf.examsAndAdmissions.model.Exam;
 import com.tarento.upsmf.examsAndAdmissions.model.ExamCycle;
+import com.tarento.upsmf.examsAndAdmissions.model.StudentExamRegistration;
 import com.tarento.upsmf.examsAndAdmissions.model.StudentResult;
 import org.springframework.data.jpa.repository.JpaRepository;
 import org.springframework.data.jpa.repository.Modifying;
@@ -56,5 +57,11 @@ public interface StudentResultRepository extends JpaRepository<StudentResult, Lo
     List<StudentResult> findByExamExamNameAndInstituteId(String examName, Long instituteId);
 
     List<StudentResult> findByStudent_EnrollmentNumberAndExamCycle_IdAndPublished(String enrollmentNumber, Long examCycleId, boolean b);
+
+    @Query("SELECT sr FROM StudentResult sr WHERE sr.examCycle_name = :examCycleName AND sr.exam_name = :examName AND sr.student.institute.id = :institute")
+    List<StudentResult> findByExamCycleNameAndExamNameAndInstitute(String examCycleName, String examName, Long institute);
+
+    @Query("SELECT sr FROM StudentResult sr WHERE sr.examCycle_name = :examCycleName")
+    List<StudentResult> findByExamCycleName(String examCycleName);
 }
 

src/main/java/com/tarento/upsmf/examsAndAdmissions/service/AttendanceService.java

@@ -270,8 +270,8 @@ public class AttendanceService {
     }
     public ResponseDto getByExamCycleId(Long ExamCycleId) {
         ResponseDto response = new ResponseDto(Constants.API_ATTENDANCE_BY_EXAM_CYCLE_ID);
-        List<AttendanceRecord> records = attendanceRepository.findByExamCycleId(ExamCycleId);
-
+        String examCycleName = examCycleRepository.getExamCycleNameById(ExamCycleId);
+        List<AttendanceRecord> records = attendanceRepository.findByExamCycleData(examCycleName);
         if (records.isEmpty()) {
             ResponseDto.setErrorResponse(response, "NO_RECORDS_FOUND", "No attendance records found", HttpStatus.NOT_FOUND);
         } else {