@SelectProvider(type = ResourceCompareMapperSlave.Provider.class, method = "selectHistoryList")
    List<ResourceCompareRecord> selectHistoryList(@Param("account") String account,@Param("compareParams") ResourceCompareParams compareParams);


    class Provider {

        public String selectHistoryList(@Param("account") String account,@Param("compareParams") ResourceCompareParams compareParams) {
            StringBuilder sql = new StringBuilder();
            sql.append("SELECT * FROM tb_***_record where creator = ").append("#{account}").append(" and delete_flag = 0 ");
            if (!StringUtil.isEmpty(compareParams.getStartTime())) {
                sql.append(" and modify_time >= ").append("#{compareParams.startTime}");
            }
            if(!StringUtil.isEmpty(compareParams.getEndTime())){
                sql.append(" and modify_time < ").append("#{compareParams.endTime}");
            }
            if(!StringUtil.isEmpty(compareParams.getFileName())){
                sql.append(" and file_name like CONCAT('%', #{compareParams.fileName}, '%')");
            }
            sql.append(" ORDER BY modify_time DESC limit ").append("#{compareParams.pageNum}").append(",").append("#{compareParams.pageSize}");
            return sql.toString();
        }
}