source: src/main/java/com/example/medweb/repository/TerminRepository.java

package com.example.medweb.repository;

import com.example.medweb.model.Termin;
import com.example.medweb.model.TerminId;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Component;
import org.springframework.stereotype.Repository;

import java.time.ZonedDateTime;
import java.util.List;
import java.util.Optional;


@Repository
@Component("main")
public interface TerminRepository extends JpaRepository<Termin, TerminId>, TerminRepositoryCustom {

    @Query("select t from Termin t left join Rezervacija r on t.termin_id = r.termin.termin_id where t.vreme > :now and r.termin is null")
    List<Termin> findFutureAndFree (ZonedDateTime now);

    @Query("select t from Termin t left join Rezervacija r on t.termin_id = r.termin.termin_id where t.vreme > :now and t.doktor_id = :doktor_id and r.termin is null")
    List<Termin> findFutureAndFreeAndByDoktor (ZonedDateTime now, Integer doktor_id);

}