package com.project.whatsappchatbot.repository;

import com.project.whatsappchatbot.model.PaymentLink;
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.List;
import java.util.Optional;

@Repository
public interface PaymentLinkRepository extends JpaRepository<PaymentLink, Long> {


    Optional<PaymentLink> findByPaymentLink(String paymentLink);

    Optional<PaymentLink> findByContactNumber(String contactNumber);

    @Query("SELECT p FROM PaymentLink p WHERE LOWER(p.description) = LOWER(:description)")
    Optional<PaymentLink> findByDescriptionIgnoreCase(@Param("description") String description);


    @Query("SELECT p FROM PaymentLink p WHERE p.paymentStatus = 'unpaid'")
    List<PaymentLink> findUnpaidPaymentLinks();
}