package com.healthcare.ohctech.repository; import com.healthcare.ohctech.entity.GroupItem; import com.healthcare.ohctech.entity.Procurement; import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.data.jpa.repository.Query; import org.springframework.data.repository.query.Param; import org.springframework.stereotype.Repository; import java.util.Optional; @Repository public interface ProcurementRepo extends JpaRepository { Optional findById(Long id); @Query("SELECT MAX(p.procurementRefno) FROM Procurement p WHERE p.procurementRefno LIKE CONCAT('PMT-%', :year)") String findMaxProcurementRefNoForYear(@Param("year") int year); @Query("SELECT COUNT(p) > 0 FROM Procurement p WHERE p.procurementRefno = :procurementRefno") boolean existsByProcurementRefNo(@Param("procurementRefno") String procurementRefno); }