| | |
|---|
| | | |
|---|
| | | Page<LocItem> page = new Page<>(params.getCurrent(), params.getPageSize()); |
|---|
| | | QueryWrapper<LocItem> wrapper = new QueryWrapper<>(); |
|---|
| | | wrapper.select("id, matnr_id, maktx, matnr_code, anfme, work_qty, qty, batch, unit, fields_index, model, spec, loc_id ") |
|---|
| | | wrapper.select("id, matnr_id, maktx, matnr_code, SUM(anfme) anfme, SUM(work_qty) work_qty, SUM(qty) qty, batch, unit, fields_index, model, spec, loc_id ") |
|---|
| | | .lambda() |
|---|
| | | .eq(StringUtils.isNotBlank(params.getMatnrCode()), LocItem::getMatnrCode, params.getMatnrCode()) |
|---|
| | | .like(StringUtils.isNotBlank(params.getMaktx()), LocItem::getMaktx, params.getMaktx()); |
|---|
