package com.estate.expert.admin.domain.report;

import com.estate.expert.admin.domain.common.EntityBaseRepository;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

public interface ReportTemplateRepository extends EntityBaseRepository<ReportTemplate> {

    @Query("select t from ReportTemplate t where ( :keyword is null or :keyword = '' " +
            "or t.name like %:keyword% " +
            "or t.number like %:keyword% " +
//            "or t.subNumber like %:keyword% " +
            "or t.remark like %:keyword%) " +
            "and t.deleted = false " +
            "order by t.updateTime desc")
    Page<ReportTemplate> list(@Param("keyword") String keyword,
                              Pageable page);

}