package com.dev.dao;

import com.dev.entity.ApiDashboardWidget;


import com.system.role.entity.SysRole;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import java.util.List;

public interface ApiDashboardWidgetDao  extends CrudRepository<ApiDashboardWidget, Long>, JpaSpecificationExecutor<ApiDashboardWidget> {

    public List<ApiDashboardWidget> findAll();

    public ApiDashboardWidget findById(long id);

    @Query(value = "select * from API_LARGE_SCREEN  where bsCode = ?1 ", nativeQuery = true)
    List<ApiDashboardWidget> getDataByBsCode(String bsCode);

}