Springboot+Mybatisplus+VUE前后端代码:

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()
      },

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值