CustomerFeedbackRepository.java

package com.eksad.masterdata.repository;

import com.eksad.ddms.common.util.status.DataStatus;
import com.eksad.masterdata.domain.CustomerFeedback;
import jakarta.transaction.Transactional;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
@Transactional
public interface CustomerFeedbackRepository extends GenericRepository<CustomerFeedback> {
    List<CustomerFeedback> findAllByAhassIDOrderByIdAsc(String ahassID);

    Page<CustomerFeedback> findAllByCustFeedbackStatus(DataStatus custFeedbackStatus, Pageable pageable);

    Page<CustomerFeedback> findAllByAhassID(String ahassID, Pageable pageable);

    CustomerFeedback findOneByNoPolisi(String noPolisi);

    CustomerFeedback findOneByNoPolisiAndCustFeedbackStatus(String noPolisi, DataStatus custFeedbackStatus);

    List<CustomerFeedback> findAllByNoPolisiAndCustFeedbackStatusOrderByIdDesc(String noPolisi, DataStatus custFeedbackStatus);

    List<CustomerFeedback> findAllByNoPolisiOrderByIdDesc(String noPolisi);

    //    @Query("SELECT cf FROM CustomerFeedback cf WHERE cf.noPolisi LIKE ('%:noPolisi%:') AND cf.custFeedStatus = 0")
//    Page<CustomerFeedback> findAllByNoPolisiAndCustFeedbackStatus (@Param("noPolisi") String noPolisi,
//                                                                   @Param ("custFeedback") DataStatus custFeedbackStatus, Pageable pageable);
    Page<CustomerFeedback> findAllByNoPolisiContainingIgnoreCaseAndAhassID(String noPolisi, String ahassID, Pageable pageable);

    CustomerFeedback findOneByCustFeedbackID(String custFeedbackID);

    CustomerFeedback findOneByWoID(String woID);

    CustomerFeedback findOneByCustFeedbackIDAndCustFeedbackStatus(String custFeedbackID, DataStatus custFeedbackStatus);
}