| | |
|---|
| | | */ |
|---|
| | | @Override |
|---|
| | | public R getDeltByCode(Map<String, Object> params) { |
|---|
| | | String code = params.get("code").toString(); |
|---|
| | | Object code = params.get("code"); |
|---|
| | | Object matnrCode = params.get("matnrCode"); |
|---|
| | | String batch = null; |
|---|
| | | if (!Objects.isNull(params.get("batch"))) { |
|---|
| | | batch = params.get("batch").toString(); |
|---|
| | |
|---|
| | | //TODO 后续需根据策略配置，获取组拖数据。如：混装，按批次混装等 |
|---|
| | | LambdaQueryWrapper<WarehouseAreasItem> queryWrapper = new QueryWrapper<WarehouseAreasItem>() |
|---|
| | | .select("SUM(anfme) as anfme, track_code, asn_code, id, splr_batch, ispt_result, plat_item_id, batch,unit, stock_unit, qty, work_qty, matnr_code, matnr_id, maktx").lambda() |
|---|
| | | .eq(StringUtils.isNotBlank(code), WarehouseAreasItem::getTrackCode, code) |
|---|
| | | .eq(!Objects.isNull(code), WarehouseAreasItem::getTrackCode, code) |
|---|
| | | .eq(StringUtils.isNotBlank(batch), WarehouseAreasItem::getSplrBatch, batch) |
|---|
| | | .eq(!Objects.isNull(matnrCode), WarehouseAreasItem::getMatnrCode, matnrCode) |
|---|
| | | .groupBy(WarehouseAreasItem::getSplrBatch, WarehouseAreasItem::getAsnId, WarehouseAreasItem::getAreaId, WarehouseAreasItem::getMatnrId); |
|---|
| | | return R.ok(warehouseAreasItemService.getOne(queryWrapper, false)); |
|---|
| | | return R.ok(warehouseAreasItemService.list(queryWrapper)); |
|---|
| | | } |
|---|
| | | |
|---|
| | | /** |
|---|
