需求:根据模板列表勾选的字段查询列表数据
FreeMarker代码:
/**
* 分页列表查询
*
* @param ${entityName?uncap_first}
* @param pageNo
* @param pageSize
* @param req
* @return
*/
//@AutoLog(value = "${tableVo.ftlDescription}-分页列表查询")
@ApiOperation(value="${tableVo.ftlDescription}-分页列表查询", notes="${tableVo.ftlDescription}-分页列表查询")
@GetMapping(value = "/list")
public Result<IPage<${entityName}>> queryPageList(${entityName} ${entityName?uncap_first},
@RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
@RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
HttpServletRequest req) {
QueryWrapper<${entityName}> queryWrapper = QueryGenerator.initQueryWrapper(${entityName?uncap_first}, req.getParameterMap());
queryWrapper.select(
<#list columns as po>
<#if po?is_last>
"${po.fieldName}"
<#else>
"${po.fieldName}",
</#if>
</#list>
);
Page<${entityName}> page = new Page<${entityName}>(pageNo, pageSize);
IPage<${entityName}> pageList = ${entityName?uncap_first}Service.page(page, queryWrapper);
return Result.OK(pageList);
}
生成效果:
/**
* 分页列表查询
*
* @param crmCcRedlist
* @param pageNo
* @param pageSize
* @param req
* @return
*/
//@AutoLog(value = "crm_cc_redlist-分页列表查询")
@ApiOperation(value="crm_cc_redlist-分页列表查询", notes="crm_cc_redlist-分页列表查询")
@GetMapping(value = "/list")
public Result<IPage<CrmCcRedlist>> queryPageList(CrmCcRedlist crmCcRedlist,
@RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
@RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
HttpServletRequest req) {
QueryWrapper<CrmCcRedlist> queryWrapper = QueryGenerator.initQueryWrapper(crmCcRedlist, req.getParameterMap());
queryWrapper.select(
"name",
"number",
"priority",
"remarks",
"lastDate",
"isAlways",
"createBy",
"createTime",
"updateBy",
"updateTime"
);
Page<CrmCcRedlist> page = new Page<CrmCcRedlist>(pageNo, pageSize);
IPage<CrmCcRedlist> pageList = crmCcRedlistService.page(page, queryWrapper);
return Result.OK(pageList);
}