Mapper.java.vm

package ${basePackage}.module.${table.moduleName}.mapper;

import java.util.List;
import java.util.Map;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Select;
import ${basePackage}.module.${table.moduleName}.entities.${table.className};
import cn.iocoder.yudao.framework.common.base.BaseMapper;

/**
 * ${table.classComment} Mapper
 * @author ${table.author}
 * @date ${datetime}
 * Copyright (c) 2017
 */
public interface ${table.className}Mapper extends BaseMapper<${table.className}> {
	/**
     * 分页查询
     * @param entity
     * @return
     */
	@Select({
		"<script>",
		    "SELECT",
#foreach ($column in $columns)
					"${column.columnName}#if($velocityCount != $columns.size()), #end",
#end
		    "FROM ${table.tableName} ",
		    "WHERE 1 = 1 ",
#foreach ($column in $columns)
	#if (!${baseDOFields.contains(${column.javaField})} && !${column.primaryKey})
			"<when test = '$column.javaField != null'>",
				"AND `$column.columnName` = #{$column.javaField}",
			"</when>",
	#end
#end
		    "<when test = 'sts != null and !sts.isEmpty()'>",
		    	"AND created_at &gt;= #{sts}",
		    "</when>",
		    "<when test = 'ets != null and !ets.isEmpty()'>",
				"AND created_at &lt;= #{ets}",
			"</when>",
    	"</script>"
	})
	@Override
	List<${table.className}> queryPage(final Map<String, Object> entity);

	/**
	 * 批量更新
	 * @param entities
	 * @return
	 */
	@Override
	int batch(final List<${table.className}> entities);

	/**
	 * 删除历史数据
	 * @param month
	 * @return
	 */
	@Override
	@Delete("delete from ${table.tableName} where created_at < DATE_SUB(NOW(),INTERVAL #{month} MONTH)")
	Long clean(final int month);

	/**
	 * 清空
	 * @return
	 */
	@Override
	@Delete("truncate table ${table.tableName}")
	void truncate();
}