From bf765893039bc7968b8160a70bda778526dca98c Mon Sep 17 00:00:00 2001 From: 无关风月 <443237572@qq.com> Date: 星期二, 31 十二月 2024 15:28:19 +0800 Subject: [PATCH] 定时任务 --- manage/src/main/java/com/jilongda/manage/controller/TWarehousingController.java | 100 ++++++++++++++++++++++++++++++++++++++++++-------- 1 files changed, 84 insertions(+), 16 deletions(-) diff --git a/manage/src/main/java/com/jilongda/manage/controller/TWarehousingController.java b/manage/src/main/java/com/jilongda/manage/controller/TWarehousingController.java index b983a81..c1e09dc 100644 --- a/manage/src/main/java/com/jilongda/manage/controller/TWarehousingController.java +++ b/manage/src/main/java/com/jilongda/manage/controller/TWarehousingController.java @@ -8,6 +8,7 @@ import com.jilongda.common.enums.WarehousingTypeEnum; import com.jilongda.common.security.JwtTokenUtils; import com.jilongda.common.utils.CodeGenerateUtils; +import com.jilongda.common.utils.UUIDUtil; import com.jilongda.manage.dto.GetCurrentByParam; import com.jilongda.manage.dto.GetCurrentByParamLens; import com.jilongda.manage.dto.TWarehousingDTO; @@ -23,12 +24,16 @@ import io.swagger.annotations.ApiOperation; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.util.StringUtils; import org.springframework.validation.annotation.Validated; import org.springframework.web.bind.annotation.*; +import java.text.SimpleDateFormat; import java.time.LocalDateTime; import java.util.ArrayList; +import java.util.Date; import java.util.List; +import java.util.Objects; import java.util.stream.Collectors; /** @@ -58,33 +63,40 @@ private TModelService modelService; @Autowired private TLensSeriesService lensSeriesService; + @Autowired + private TStoreService storeService; + @Autowired + private TBrandService brandService; /** * 通过型号查询色号列表 */ - @ApiOperation(value = "镜架-根据品牌id、型号名称、色号名称查询当前库存") + @ApiOperation(value = "镜架-根据品牌id、型号名称、色号名称、材质id查询当前库存") @PostMapping(value = "/getCurrentByParamFrame") public ApiResult<Integer> getCurrentByParamFrame(@RequestBody GetCurrentByParam getCurrentByParam) { // 根据型号名称 查询型号列表ids - List<Integer> collect = modelService.lambdaQuery().eq(TModel::getName, getCurrentByParam.getModel()) - .eq(TModel::getColor,getCurrentByParam.getColor()) - .eq(TModel::getBrandId,getCurrentByParam.getBrandId()) + List<Integer> collect = modelService.lambdaQuery() + .eq(StringUtils.hasLength(getCurrentByParam.getModel()),TModel::getName, getCurrentByParam.getModel()) + .eq(Objects.nonNull(getCurrentByParam.getMaterialId()),TModel::getMaterialId,getCurrentByParam.getMaterialId()) + .eq(StringUtils.hasLength(getCurrentByParam.getColor()),TModel::getColor,getCurrentByParam.getColor()) + .eq(Objects.nonNull(getCurrentByParam.getBrandId()),TModel::getBrandId,getCurrentByParam.getBrandId()) .list().stream().map(TModel::getId).collect(Collectors.toList()); TFrameGoods one = frameGoodsService.lambdaQuery().in(TFrameGoods::getModelId, collect) - .eq(TFrameGoods::getColor, getCurrentByParam).one(); + .eq(TFrameGoods::getColor, getCurrentByParam.getColor()) + .eq(TFrameGoods::getStoreId, getCurrentByParam.getStoreId()).one(); if (one!=null){ return ApiResult.success(one.getTotal()); - } return ApiResult.success(0); } - @ApiOperation(value = "镜片-根据品牌id、系列id、球/非球、折射率、球镜、柱镜查询当前库存") + @ApiOperation(value = "镜片-根据系列id、球/非球、品牌id、折射率、ballMirror、columnMirror查询当前库存") @PostMapping(value = "/getCurrentByParamLens") public ApiResult<Integer> getCurrentByParamLens(@RequestBody GetCurrentByParamLens dto) { TLensGoods one = lensGoodsService.lambdaQuery().in(TLensGoods::getSeriesId, dto.getSeriesId()) - .eq(TLensGoods::getLensType, dto.getLensType()) - .eq(TLensGoods::getRefractiveIndex, dto.getRefractiveIndex()) - .eq(TLensGoods::getBallMirror, dto.getBallMirror()) - .eq(TLensGoods::getColumnMirror, dto.getColumnMirror()) + .eq(dto.getLensType()!=null,TLensGoods::getLensType, dto.getLensType()) + .eq(dto.getRefractiveIndex()!=null,TLensGoods::getRefractiveIndex, dto.getRefractiveIndex()) + .eq(dto.getBallMirror()!=null,TLensGoods::getBallMirror, dto.getBallMirror()) + .eq(dto.getColumnMirror()!=null,TLensGoods::getColumnMirror, dto.getColumnMirror()) + .eq(dto.getStoreId()!=null,TLensGoods::getStoreId, dto.getStoreId()) .one(); if (one!=null){ return ApiResult.success(one.getTotal()); @@ -100,6 +112,30 @@ @PostMapping(value = "/lensReceiptList") public ApiResult<PageInfo<TLensGoodsVO>> lensReceiptList(@RequestBody TLensGoodsQuery query) { return ApiResult.success(lensGoodsService.lensReceiptList(query)); + } + @ApiOperation(value = "镜片库存分页列表-启用禁用") + @PostMapping(value = "/updateStateLens") + public ApiResult updateStateLens(Integer id) { + TLensGoods byId = lensGoodsService.getById(id); + if (byId.getStatus()==1){ + byId.setStatus(2); + }else { + byId.setStatus(1); + } + lensGoodsService.updateById(byId); + return ApiResult.success(); + } + @ApiOperation(value = "镜架库存分页列表-启用禁用") + @PostMapping(value = "/updateStateFrame") + public ApiResult updateStateFrame(Integer id) { + TFrameGoods byId = frameGoodsService.getById(id); + if (byId.getStatus()==1){ + byId.setStatus(2); + }else { + byId.setStatus(1); + } + frameGoodsService.updateById(byId); + return ApiResult.success(); } /** * 出入库单列表 @@ -124,14 +160,46 @@ PageInfo<TFrameWarehousingDetailVO> frameWarehousingDetailVOPageInfo = warehousingService.detailList(query); return ApiResult.success(frameWarehousingDetailVOPageInfo); } + @ApiOperation(value = "镜片出入库记录列表") + @PostMapping(value = "/detailLensList") + public ApiResult<PageInfo<TLensWarehousingDetailVO>> detailLensList(@RequestBody TWarehousingDetailLensQuery query) { + return ApiResult.success(warehousingService.detailListLens(query)); + } /** * 库存明细记录列表 */ - @ApiOperation(value = "镜片库存明细记录列表") - @PostMapping(value = "/detailLensList") - public ApiResult<PageInfo<TLensWarehousingDetailVO>> detailLensList(@RequestBody TWarehousingDetailLensQuery query) { - PageInfo<TLensWarehousingDetailVO> frameWarehousingDetailVOPageInfo = warehousingService.detailListLens(query); - return ApiResult.success(frameWarehousingDetailVOPageInfo); + @ApiOperation(value = "镜片库存明细记录列表--库存详情") + @PostMapping(value = "/detailLensListDetail") + public ApiResult<TLensGoodsDetailVO> detailLensListDetail(Integer id) { + TLensGoodsDetailVO tLensGoodsDetailVO = new TLensGoodsDetailVO(); + TLensGoods byId = lensGoodsService.getById(id); + TStore byId1 = storeService.getById(byId.getStoreId()); + if (byId1!=null){ + tLensGoodsDetailVO.setStoreName(byId1.getName()); + } + TLensSeries byId2 = lensSeriesService.getById(byId.getSeriesId()); + if (byId2!=null){ + Integer brandId = byId2.getBrandId(); + TBrand byId3 = brandService.getById(brandId); + String t1 = ""; + switch (byId.getLensType()){ + case 1: + t1="球面"; + break; + case 2: + t1="非球面"; + break; + case 3: + t1="双非"; + break; + } + 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(); + tLensGoodsDetailVO.setList(list); + return ApiResult.success(tLensGoodsDetailVO); } /** -- Gitblit v1.7.1