| | |
| | | .eq(Objects.nonNull(getCurrentByParam.getBrandId()),TModel::getBrandId,getCurrentByParam.getBrandId()) |
| | | .list().stream().map(TModel::getId).collect(Collectors.toList()); |
| | | if (collect.isEmpty())collect.add(-1); |
| | | TFrameGoods one = frameGoodsService.lambdaQuery().in(TFrameGoods::getModelId, collect) |
| | | List<TFrameGoods> one = frameGoodsService.lambdaQuery().in(TFrameGoods::getModelId, collect) |
| | | .eq(TFrameGoods::getColor, getCurrentByParam.getColor()) |
| | | .eq(TFrameGoods::getStoreId, getCurrentByParam.getStoreId()).one(); |
| | | if (one!=null){ |
| | | return ApiResult.success(one.getTotal()); |
| | | } |
| | | return ApiResult.success(0); |
| | | .eq(TFrameGoods::getStoreId, getCurrentByParam.getStoreId()).list(); |
| | | if (one.isEmpty())return ApiResult.success(0); |
| | | Integer temp = one.stream() |
| | | .mapToInt(TFrameGoods::getTotal) |
| | | .sum(); |
| | | return ApiResult.success(temp); |
| | | } |
| | | @ApiOperation(value = "镜片-根据系列id、球/非球、品牌id、折射率、ballMirror、columnMirror查询当前库存") |
| | | @PostMapping(value = "/getCurrentByParamLens") |
| | | public ApiResult<Integer> getCurrentByParamLens(@RequestBody GetCurrentByParamLens dto) { |
| | | TLensGoods one = lensGoodsService.lambdaQuery().eq(TLensGoods::getSeriesId, dto.getSeriesId()) |
| | | List<TLensGoods> one = lensGoodsService.lambdaQuery().eq(TLensGoods::getSeriesId, dto.getSeriesId()) |
| | | .eq(dto.getLensType()!=null,TLensGoods::getLensType, dto.getLensType()) |
| | | .eq(StringUtils.hasLength(dto.getRefractiveIndex()),TLensGoods::getRefractiveIndex, dto.getRefractiveIndex()) |
| | | .eq(StringUtils.hasLength(dto.getBallMirror()),TLensGoods::getBallMirror, dto.getBallMirror()) |
| | | .eq(StringUtils.hasLength(dto.getColumnMirror()),TLensGoods::getColumnMirror, dto.getColumnMirror()) |
| | | .eq(dto.getStoreId()!=null,TLensGoods::getStoreId, dto.getStoreId()) |
| | | .one(); |
| | | if (one!=null){ |
| | | return ApiResult.success(one.getTotal()); |
| | | } |
| | | return ApiResult.success(0); |
| | | .list(); |
| | | if (one.isEmpty())return ApiResult.success(0); |
| | | Integer temp = one.stream() |
| | | .mapToInt(TLensGoods::getTotal) |
| | | .sum(); |
| | | return ApiResult.success(temp); |
| | | } |
| | | @ApiOperation(value = "镜架库存分页列表") |
| | | @PostMapping(value = "/frameReceiptList") |
| | |
| | | @ApiOperation(value = "镜片出入库记录列表") |
| | | @PostMapping(value = "/detailLensList") |
| | | public ApiResult<PageInfo<TLensWarehousingDetailVO>> detailLensList(@RequestBody TWarehousingDetailLensQuery query) { |
| | | if (query.getSeriesId()!=null){ |
| | | TLensSeries series = lensSeriesService.getById(query.getSeriesId()); |
| | | if (series!=null){ |
| | | query.setSeries(series.getName()); |
| | | } |
| | | } |
| | | if (query.getBrandId()!=null){ |
| | | TBrand brand = brandService.getById(query.getBrandId()); |
| | | if (brand!=null){ |
| | | query.setBrand(brand.getName()); |
| | | } |
| | | } |
| | | return ApiResult.success(warehousingService.detailListLens(query)); |
| | | } |
| | | /** |
| | |
| | | tLensGoodsDetailVO.setTitle(byId3.getName()+byId2.getName()+t1+" "+byId.getRefractiveIndex()); |
| | | } |
| | | // 查询这个商品的库存明细 |
| | | List<TLensWarehousingDetail> list = lensWarehousingDetailService.lambdaQuery().eq(TLensWarehousingDetail::getSeriesId, byId.getSeriesId()) |
| | | .eq(TLensWarehousingDetail::getRefractiveIndex, byId.getRefractiveIndex()).list(); |
| | | List<TLensGoods> list = lensGoodsService.lambdaQuery().eq(TLensGoods::getSeriesId, byId.getSeriesId()) |
| | | .eq(TLensGoods::getRefractiveIndex, byId.getRefractiveIndex()).list(); |
| | | tLensGoodsDetailVO.setList(list); |
| | | return ApiResult.success(tLensGoodsDetailVO); |
| | | } |
| | |
| | | one.setTotal(one.getTotal()-frameWarehousingDetail.getTotal()); |
| | | list1.add(one); |
| | | }else { |
| | | return ApiResult.failed("商品不存在"); |
| | | return ApiResult.failed("库存不足"); |
| | | |
| | | } |
| | | } |
| | |
| | | one.setTotal(one.getTotal()-frameWarehousingDetail.getTotal()); |
| | | list1.add(one); |
| | | }else { |
| | | return ApiResult.failed("商品不存在"); |
| | | return ApiResult.failed("库存不足"); |
| | | |
| | | } |
| | | } |
| | |
| | | List<TFrameWarehousingDetail> list = frameWarehousingDetailService.list(Wrappers.lambdaQuery(TFrameWarehousingDetail.class) |
| | | .eq(TFrameWarehousingDetail::getWarehousingId, id)); |
| | | vo.setFrameWarehousingDetails(list); |
| | | TStore store = storeService.getById(warehousing.getStoreId()); |
| | | if (store!=null){ |
| | | vo.setStoreName(store.getName()); |
| | | } |
| | | // 统计数量 |
| | | vo.setTotalNum(list.stream().mapToInt(TFrameWarehousingDetail::getTotal).sum()); |
| | | return ApiResult.success(vo); |
| | |
| | | BeanUtils.copyProperties(warehousing, vo); |
| | | List<TLensWarehousingDetail> list = lensWarehousingDetailService.list(Wrappers.lambdaQuery(TLensWarehousingDetail.class) |
| | | .eq(TLensWarehousingDetail::getWarehousingId, id)); |
| | | TStore store = storeService.getById(warehousing.getStoreId()); |
| | | if (store!=null){ |
| | | vo.setStoreName(store.getName()); |
| | | } |
| | | vo.setLensWarehousingDetails(list); |
| | | // 统计数量 |
| | | vo.setTotalNum(list.stream().mapToInt(TLensWarehousingDetail::getTotal).sum()); |