package com.pollex.pam.repository;

import java.util.List;
import java.util.Optional;

import com.pollex.pam.enums.SatisfactionStatusEnum;
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 com.pollex.pam.domain.Satisfaction;

@Repository
public interface SatisfactionRepository extends JpaRepository<Satisfaction, Long>{

	List<Satisfaction> findByAgentNo(String agentNo);

	List<Satisfaction> findByCustomerId(Long customerId);

	Optional<Satisfaction> findOneByAppointmentId(Long appointmentId);

    List<Satisfaction> findAllByStatus(SatisfactionStatusEnum status);

	@Query(value = "SELECT avg(score) FROM satisfaction where agent_no=:agent_no"
			+ " and score is not null"
			, nativeQuery = true)
	Float getAgentScoreAvg(@Param("agent_no") String agentNo);
}