package com.boying.dao;

import com.boying.common.BaseDao;
import com.boying.entity.WhiteList;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

@Repository("whiteListDao")
public interface WhiteListDao extends BaseDao<WhiteList, Long>{

    @Query(value = "select new com.boying.entity.WhiteList(a,b.name) from WhiteList a left join Park b on a.parkId=b.id where :carNo is null or a.carNo like %:carNo%")
    Page<WhiteList> findPage2(Pageable pageable,String carNo);
}