repository/

AdminRepository.java

package com.example.pkscl.repository;

import com.example.pkscl.data.entity.member.Admin;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;

@Repository
public interface AdminRepository extends JpaRepository<Admin, Long> {
    Admin findById(String id);
}

EventRepository.java

package com.example.pkscl.repository;

import java.util.List;

import com.example.pkscl.data.entity.ledger.Event;

import org.springframework.data.jpa.repository.JpaRepository;

public interface EventRepository extends JpaRepository<Event, Long> {
    Event findByEventnumber(int eventnumber);
    void deleteByEventnumber(int eventnumber);
    List<Event> findByQuarteridOrderByEventsequence(int quarterid);
}

MajorRepository.java

package com.example.pkscl.repository;

import java.util.List;

import com.example.pkscl.data.entity.major.Major;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;

@Repository
public interface MajorRepository extends JpaRepository<Major, Long> {
    List<Major> findByMajorstatus(String majorstatus);
    Major findByMajornumber(int majornumber);
}

PresidentCertemailRepository.java

package com.example.pkscl.repository;

import com.example.pkscl.data.entity.temp.PresidentCertemail;

import org.springframework.data.jpa.repository.JpaRepository;


public interface PresidentCertemailRepository extends JpaRepository<PresidentCertemail, Long> {
    PresidentCertemail findByEmail(String email);
}

PresidentRepository.java

package com.example.pkscl.repository;

import com.example.pkscl.data.entity.member.President;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;

@Repository
public interface PresidentRepository extends JpaRepository<President, Long> {
    President findByEmail(String email);
}

QuarterRepository.java

package com.example.pkscl.repository;

import java.util.List;

import com.example.pkscl.data.entity.ledger.Quarter;

import org.springframework.data.jpa.repository.JpaRepository;

public interface QuarterRepository extends JpaRepository<Quarter, Long> {
    List<Quarter> findByMajornumber(int majornumber);
    Quarter findByMajornumberAndQuarternumber(int majornumber, String quarternumber);
    Quarter findByQuarterid(int quarterid);
}

ReceiptdetailRepository.java

package com.example.pkscl.repository;

import java.util.List;

import com.example.pkscl.data.entity.ledger.Receiptdetail;

import org.springframework.data.jpa.repository.JpaRepository;

public interface ReceiptdetailRepository extends JpaRepository<Receiptdetail, Long> {
    List<Receiptdetail> findByReceiptnumber(int receiptnumber);
}

ReceiptRepository.java

package com.example.pkscl.repository;

import java.util.List;

import com.example.pkscl.data.entity.ledger.Receipt;

import org.springframework.data.jpa.repository.JpaRepository;

public interface ReceiptRepository extends JpaRepository<Receipt, Long> {
    List<Receipt> findByEventnumber(int eventnumber);

    Receipt findByReceiptnumber(int receiptnumber);
}

StudentCertemailRepository.java

package com.example.pkscl.repository;

import com.example.pkscl.data.entity.temp.StudentCertemail;

import org.springframework.data.jpa.repository.JpaRepository;


public interface StudentCertemailRepository extends JpaRepository<StudentCertemail, Long> {
    StudentCertemail findByEmail(String email);
}

StudentRepository.java

package com.example.pkscl.repository;

import java.util.List;

import com.example.pkscl.data.entity.member.Student;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;

@Repository
public interface StudentRepository extends JpaRepository<Student, Long> {
    Student findByEmail(String email);
    List<Student> findByMajornumber(int majornumber);
}