AppDeviceRepository.java 667 B

12345678910111213141516171819
  1. package cn.fastfun.service.repository;
  2. import cn.fastfun.controller.dto.DeviceBathNumDTO;
  3. import cn.fastfun.service.entity.AppDevice;
  4. import org.springframework.data.jpa.repository.JpaRepository;
  5. import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
  6. import org.springframework.data.jpa.repository.Query;
  7. /**
  8. * Created by Eye
  9. *
  10. * @Author Bridge
  11. */
  12. public interface AppDeviceRepository extends JpaRepository<AppDevice, String>, JpaSpecificationExecutor<AppDevice> {
  13. @Query(value = "select t.batch_num,t.sn,t.deliver_time,count(0) from pdms_oss.app_device t group by t.batch_num", nativeQuery = true)
  14. DeviceBathNumDTO selectCount();
  15. }