package com.dacrt.SBIABackend.security.repository;

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

import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;


import com.dacrt.SBIABackend.security.entity.Audit;
import com.dacrt.SBIABackend.security.entity.Menu;
import com.dacrt.SBIABackend.security.dto.AuditDto;


@Repository
public interface AuditRepository extends JpaRepository<Audit,Integer>{
	
	@Query(value=" SELECT count(1) FROM main.rolesprivileges a WHERE a.rolid = ?1 and a.privilegeid = ?2 ",nativeQuery=true)
	//List<Audit> getAllMovAudit(int orderIn,int asc);
	int getCantbyRolAndPrivi(int rolid,int privilegeid);
	
	
	@Query(value=" SELECT a.name FROM main.users a WHERE a.usr = ?1 ",nativeQuery=true)
	//List<Audit> getAllMovAudit(int orderIn,int asc);
	String getNamebyusr(String nombre);
	
}