1:后端代码:
(1):controller
@RequestMapping("/list")
@ResponseBody
public BootTablePagEntity list(@RequestParam Map<String,Object> params) {
String currentPage = String.valueOf(params.get("page"));
String pageSize = String.valueOf(params.get("limit"));
IPage<CostAuxiliarySavingEntity> costMaterialDailyEntityIPage =
costAuxiliarySavingService.listAuxiliary(params, Integer.parseInt(currentPage),
Integer.parseInt(pageSize));
BootTablePagEntity table = new BootTablePagEntity(costMaterialDailyEntityIPage);
return table;
}
(2):service
IPage<CostAuxiliarySavingEntity> listAuxiliary(Map<String, Object> paramMap, int currentPage, int pageSize);
(3):serviceImpl
@Override
public IPage<CostAuxiliarySavingEntity> listAuxiliary(Map<String, Object> paramMap, int currentPage, int pageSize) {
QueryWrapper queryWrapper = getQueryWrapper(paramMap);
IPage<CostAuxiliarySavingEntity> resultPage = null;
try {
resultPage = page(new Page(currentPage, pageSize), queryWrapper);
} catch (Exception e) {
e.printStackTrace();
}
return resultPage;
}
private QueryWrapper getQueryWrapper(Map<String, Object> paramMap) {
QueryWrapper<CostAuxiliarySavingEntity> queryWrapper = new QueryWrapper<>();
if (paramMap != null && !paramMap.isEmpty()) {
queryWrapper.select();
Map<String, String> map = mdmWorkShiftService.beforeDayShift();
if (paramMap.get("startTime") == "" && paramMap.get("endTime") == "" && paramMap.get("groupCode") == "" && paramMap.get("shiftCode") == "") {
String shiftDate = map.get("shiftDate");
String groupCode = map.get("shiftCode");
String shiftCode = map.get("teamCode");
String productCode = map.get("productCode");
paramMap.put("startTime", shiftDate);
paramMap.put("endTime", shiftDate);
paramMap.put("groupCode", groupCode);
paramMap.put("productCode", productCode);
queryWrapper.ge(!StrUtil.isEmpty(String.valueOf(paramMap.getOrDefault("startTime", ""))), CostAuxiliarySavingEntity.COL_SHIFT_DATE, paramMap.get("startTime"));
queryWrapper.le(!StrUtil.isEmpty(String.valueOf(paramMap.getOrDefault("endTime", ""))), CostAuxiliarySavingEntity.COL_SHIFT_DATE, paramMap.get("endTime"));
queryWrapper.eq(!StrUtil.isEmpty(String.valueOf(paramMap.getOrDefault("groupCode", ""))), CostAuxiliarySavingEntity.COL_GROUP_CODE, paramMap.get("groupCode"));//甲乙丙班组
queryWrapper.eq(!StrUtil.isEmpty(String.valueOf(paramMap.getOrDefault("shiftCode", ""))), CostAuxiliarySavingEntity.COL_SHIFT_CODE, paramMap.get("shiftCode"));//白夜
queryWrapper.eq(!StrUtil.isEmpty(String.valueOf(paramMap.getOrDefault("productCode", ""))), CostAuxiliarySavingEntity.COL_PRODUCT_CODE, paramMap.get("productCode"));//code
} else {
queryWrapper.ge(!StrUtil.isEmpty(String.valueOf(paramMap.getOrDefault("startTime", ""))), CostAuxiliarySavingEntity.COL_SHIFT_DATE, paramMap.get("startTime"));
queryWrapper.le(!StrUtil.isEmpty(String.valueOf(paramMap.getOrDefault("endTime", ""))), CostAuxiliarySavingEntity.COL_SHIFT_DATE, paramMap.get("endTime"));
queryWrapper.eq(!StrUtil.isEmpty(String.valueOf(paramMap.getOrDefault("groupCode", ""))), CostAuxiliarySavingEntity.COL_GROUP_CODE, paramMap.get("groupCode"));//甲乙丙班组
queryWrapper.eq(!StrUtil.isEmpty(String.valueOf(paramMap.getOrDefault("shiftCode", ""))), CostAuxiliarySavingEntity.COL_SHIFT_CODE, paramMap.get("shiftCode"));//白夜
queryWrapper.eq(!StrUtil.isEmpty(String.valueOf(paramMap.getOrDefault("productCode", ""))), CostAuxiliarySavingEntity.COL_PRODUCT_CODE, paramMap.get("productCode"));//code
}
}
queryWrapper.orderByDesc(CostAuxiliarySavingEntity.COL_SHIFT_DATE);
queryWrapper.orderByAsc(CostAuxiliarySavingEntity.COL_LINE);
return queryWrapper;
}
2:前端代码:
<el-pagination
@size-change="sizeChangeHandle"
@current-change="currentChangeHandle"
:current-page="pageIndex"
:page-sizes="[10, 20, 50, 100]"
:page-size="pageSize"
:total="totalPage"
layout="total, sizes, prev, pager, next, jumper">
</el-pagination>
// 每页数
sizeChangeHandle(val) {
this.pageSize = val
this.pageIndex = 1
this.getDataList()
},
// 当前页
currentChangeHandle(val) {
this.pageIndex = val
this.getDataList()
},
queryHandle() {
this.pageIndex = 1
this.getDataList()
},