整体流程:仓库自己创建,然后采购需求自己创建,然后合并采购需求为采购单,采购单可以分配人员,人员可以领取采购单,然后完成采购单,采购单完成之后更新采购需求和采购单的状态,购买成功的则增加库存,这样就完成了整个流程
微服务: service-ware
数据库:gulimall_wms
(1)获取仓库列表(仓库维护)
条件分页查询,有可能输入检索条件,所以需要封装条件
后端接收:
/**
* 列表 http://localhost:88/api/gulimallware/wareinfo/list?t=1637291746711&page=1&limit=10&key=1
*/
@RequestMapping("/list")
public R list(@RequestParam Map<String, Object> params){
PageUtils page = wareInfoService.queryPage(params);
return R.ok().put("page", page);
}
queryPage方法:
@Override
public PageUtils queryPage(Map<String, Object> params) {
// 定义仓库信息条件,封装条件
QueryWrapper<WareInfoEntity> wareInfoEntityQueryWrapper = new QueryWrapper<>();
//可能会传过来key 所以要判断key
String key = (String) params.get("key");
//key不为空
if(!StringUtils.isEmpty(key)){
//如果key是id 需要相等,如果是仓库名字,地址,区域编码 则模糊查询
wareInfoEntityQueryWrapper.eq("id",key).or()
.like("name",key)
.or().like("address",key)
.or().like("areacode",key);
}
//定义Ipage对象 page方法返回Ipage对象 传入Ipage和条件对象
IPage<WareInfoEntity> page = this.page(
//传入的Ipage通过自定义类Query的getPage方法
new Query<WareInfoEntity>().getPage(params),
wareInfoEntityQueryWrapper
);
//返回Page工具类,进行分页显示 传入Ipage
return new PageUtils(page);
}
(2)获取库存列表
http://localhost:88/api/gulimallware/wareinfo/list?t=1637377157949&page=1&limit=500
http://localhost:88/api/gulimallware/waresku/list?t=1637377157949&page=1&limit=10&skuId=&wareId=
读取wareinfo waresku 两张表
都要传入条件,需要进行判断。
(3)合并采购需求
要先获取未被领取的采购单,因为已领取的就要去采购了,不能再新增需求了
方法:
查询未被领取的采购单
@Override
public PageUtils queryPageUnreceivePurchase(Map<String, Object> params) {
IPage<PurchaseEntity> page = this.page(
new Query<PurchaseEntity>().getPage(params),
new QueryWrapper<PurchaseEntity>().eq("status",0).or().eq("status",1)
);
return new PageUtils(page);
}
然后进行合并
后端接收:
@PostMapping("/merge")
public R merge(@RequestBody MergeVo mergeVo){
purchaseService.mergePurchase(mergeVo);
return R.ok();
}
@Override
public void mergePurchase(MergeVo mergeVo) {
//获取采购单id
Long purchaseId = mergeVo.getPurchaseId();
//如果采购单id为空(没选采购单的话,需要新建一个)
if(purchaseId == null){
//1、新建一个
PurchaseEntity purchaseEntity = new PurchaseEntity();
//采购单状态为新建
purchaseEntity.setStatus(WareConstant.PurchaseStatusEnum.CREATED.getCode());
purchaseEntity.setCreateTime(new Date());
purchaseEntity.setUpdateTime(new Date());
this.save(purchaseEntity);
//获取到新建的采购单id
purchaseId = purchaseEntity.getId();
}
//TODO 确认采购单状态是0,1才可以合并
// mergeVo中有要合并的采购需求id数组 和采购单id
List<Long> items = mergeVo.getItems();
Long finalPurchaseId = purchaseId;
//遍历采购需求id数组
List<PurchaseDetailEntity> collect = items.stream().map(i -> {
//采购需求实体类
PurchaseDetailEntity detailEntity = new PurchaseDetailEntity();
//设置采购需求id
detailEntity.setId(i);
//设置采购单id
detailEntity.setPurchaseId(finalPurchaseId);
//设置采购需求状态为已分配
detailEntity.setStatus(WareConstant.PurchaseDetailStatusEnum.ASSIGNED.getCode());
return detailEntity;
}).collect(Collectors.toList());
//更新采购需求表
purchaseDetailService.updateBatchById(collect);
//更新采购表
PurchaseEntity purchaseEntity = new PurchaseEntity();
purchaseEntity.setId(purchaseId);
purchaseEntity.setUpdateTime(new Date());
this.updateById(purchaseEntity);
}
(4)领取采购单
后端接收:
/**
* 领取采购单
* @return
*/
@PostMapping("/received")
public R received(@RequestBody List<Long> ids){
purchaseService.received(ids);
return R.ok();
}
//采购单id 一个人可以领取多个采购单
@Override
public void received(List<Long> ids) {
//1、确认当前采购单是新建或者已分配状态
List<PurchaseEntity> collect = ids.stream().map(id -> {
PurchaseEntity byId = this.getById(id);
return byId;
}).filter(item -> {
if (item.getStatus() == WareConstant.PurchaseStatusEnum.CREATED.getCode() ||
item.getStatus() == WareConstant.PurchaseStatusEnum.ASSIGNED.getCode()) {
return true;
}
return false;
}).map(item->{
item.setStatus(WareConstant.PurchaseStatusEnum.RECEIVE.getCode());
item.setUpdateTime(new Date());
return item;
}).collect(Collectors.toList());
//2、改变采购单的状态
this.updateBatchById(collect);
//3、改变采购需求的状态
collect.forEach((item)->{
List<PurchaseDetailEntity> entities = purchaseDetailService.listDetailByPurchaseId(item.getId());
List<PurchaseDetailEntity> detailEntities = entities.stream().map(entity -> {
PurchaseDetailEntity entity1 = new PurchaseDetailEntity();
entity1.setId(entity.getId());
entity1.setStatus(WareConstant.PurchaseDetailStatusEnum.BUYING.getCode());
return entity1;
}).collect(Collectors.toList());
purchaseDetailService.updateBatchById(detailEntities);
});
}
(5)完成采购
后端接收
///gulimallware/purchase/done
@PostMapping("/done")
public R finish(@RequestBody PurchaseDoneVo doneVo){
purchaseService.done(doneVo);
return R.ok();
}
@Transactional
@Override
public void done(PurchaseDoneVo doneVo) {
//1.改变采购单的状态 根据采购项也就是采购需求去判断
Long id = doneVo.getId();
//2、改变采购项的状态
Boolean flag = true;
//donevo中存有采购单id 和采购项的信息集合 包括采购项id 结果 原因
List<PurchaseItemDoneVo> items = doneVo.getItems();
//定义采购需求集合
List<PurchaseDetailEntity> updates = new ArrayList<>();
//遍历采购项的信息集合
for (PurchaseItemDoneVo item : items) {
//创建采购项
PurchaseDetailEntity detailEntity = new PurchaseDetailEntity();
//如果有一项采购项没完成,状态就为失败
if(item.getStatus() == WareConstant.PurchaseDetailStatusEnum.HASERROR.getCode()){
flag = false;
detailEntity.setStatus(item.getStatus());
}else{
//否则成功
detailEntity.setStatus(item.getStatus());
3、将成功采购的进行入库
PurchaseDetailEntity entity = purchaseDetailService.getById(item.getItemId());
wareSkuService.addStock(entity.getSkuId(),entity.getWareId(),entity.getSkuNum());
}
detailEntity.setId(item.getItemId());
updates.add(detailEntity);
}
//更新采购需求表
purchaseDetailService.updateBatchById(updates);
//1、改变采购单状态
PurchaseEntity purchaseEntity = new PurchaseEntity();
purchaseEntity.setId(id);
purchaseEntity.setStatus(flag?WareConstant.PurchaseStatusEnum.FINISH.getCode():WareConstant.PurchaseStatusEnum.HASERROR.getCode());
purchaseEntity.setUpdateTime(new Date());
//更新采购单表
this.updateById(purchaseEntity);
}