From 1c4311135628b53daa336821ff452292a9d063e9 Mon Sep 17 00:00:00 2001 From: 无关风月 <443237572@qq.com> Date: 星期三, 28 八月 2024 09:14:10 +0800 Subject: [PATCH] 代码提交 bug解决 --- ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlVolumeProductionZyglController.java | 12 ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/controller/SysOperlogController.java | 4 ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlGoodsShelfController.java | 20 + ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionCkServiceImpl.java | 20 + ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlEquipmentController.java | 1 ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionZyServiceImpl.java | 14 ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionRkServiceImpl.java | 6 ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlAuditServiceImpl.java | 487 +++++++++++++++++++++++++++++++----- ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionCkglServiceImpl.java | 3 ruoyi-modules/ruoyi-management/src/main/resources/mapper/management/SlGoodsMaterialsMapper.xml | 2 ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/SlGoodsShelfService.java | 3 ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlStoreManagementServiceImpl.java | 89 +++++- ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionZyglServiceImpl.java | 4 ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/ManagementGoodsMaterialsServiceImpl.java | 6 ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlGoodsShelfServiceImpl.java | 22 + ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionRkglServiceImpl.java | 49 +++ ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlEquipmentServiceImpl.java | 3 ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/dto/SlGoodsMaterialsSlVolumeProductionRkQuery.java | 2 18 files changed, 621 insertions(+), 126 deletions(-) diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlEquipmentController.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlEquipmentController.java index 5e9fc94..c3d4656 100644 --- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlEquipmentController.java +++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlEquipmentController.java @@ -45,7 +45,6 @@ @PostMapping("/addSlEquipment") @ApiOperation(value = "添加设备管理") public AjaxResult addSlEquipment(@RequestBody SlEquipmentDTO slEquipmentDTO) { - slEquipmentService.addSlEquipment(slEquipmentDTO); return slEquipmentService.addSlEquipment(slEquipmentDTO); } diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlGoodsShelfController.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlGoodsShelfController.java index 855e735..fded7cb 100644 --- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlGoodsShelfController.java +++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlGoodsShelfController.java @@ -1,14 +1,13 @@ package com.ruoyi.management.controller; +import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.ruoyi.common.core.domain.R; import com.ruoyi.common.core.utils.page.PageDTO; -import com.ruoyi.management.domain.SlGoodsMaterials; -import com.ruoyi.management.domain.SlGoodsShelf; -import com.ruoyi.management.domain.SlStoreManagement; -import com.ruoyi.management.domain.SlStoreManagementImg; +import com.ruoyi.management.domain.*; import com.ruoyi.management.domain.dto.*; import com.ruoyi.management.domain.vo.SlGoodsShelfVO; +import com.ruoyi.management.mapper.SlVolumeProductionRkMapper; import com.ruoyi.management.service.SlGoodsShelfService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; @@ -33,6 +32,8 @@ @Resource private SlGoodsShelfService slGoodsShelfService; + @Resource + private SlVolumeProductionRkMapper slVolumeProductionRkMapper; @PostMapping("/getGoodsShelfList") @ApiOperation(value = "分页获货架表管理") @@ -43,8 +44,7 @@ @PostMapping("/addSlGoodsShelf") @ApiOperation(value = "添加/修改货架管理") public R addSlGoodsShelf(@RequestBody SlGoodsShelfDTO slGoodsShelfDTO) { - slGoodsShelfService.addSlGoodsShelf(slGoodsShelfDTO); - return R.ok(); + return slGoodsShelfService.addSlGoodsShelf(slGoodsShelfDTO); } @GetMapping("/SlGoodsShelf/{id}") @@ -57,6 +57,14 @@ @DeleteMapping("/{id}") public R<?> delStoreManagement( @ApiParam(name = "id", value = "货架管理id", required = true) @PathVariable("id") Long id) { + List<SlVolumeProductionRk> slVolumeProductionRks = slVolumeProductionRkMapper.selectList(new QueryWrapper<SlVolumeProductionRk>() + .eq("shelf_id", id) + .ge("repertory_zhai",0) + .isNotNull("new_add_time") + .eq("del_flag", "0")); + if (slVolumeProductionRks.size() > 0) { + return R.fail("删除失败,当前货架存有物资"); + } SlGoodsShelf byId = slGoodsShelfService.getById(id); byId.setDelFlag("1"); slGoodsShelfService.updateById(byId); diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlVolumeProductionZyglController.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlVolumeProductionZyglController.java index 509dfb2..cce75fb 100644 --- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlVolumeProductionZyglController.java +++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlVolumeProductionZyglController.java @@ -75,7 +75,13 @@ SlGoodsMaterials slGoodsMaterials = slGoodsMaterialsService.getById(list.getMaterialsId()); list.setGoodsMaterialsName(slGoodsMaterials.getGoodsMaterialsName()); list.setIsConsume(slGoodsMaterials.getIsConsume()); - list.setErwmNum(slVolumeProductionRkService.getById(list.getScrkId()).getErwmNum()); + if (list.getScrkId() != null){ + SlVolumeProductionRk byId = slVolumeProductionRkService.getById(list.getScrkId()); + if (byId!=null){ + Integer erwmNum = byId.getErwmNum(); + list.setErwmNum(erwmNum); + } + } } // 将list2中的数据 如果字段erwmNum为空 优先展示在前面 list2.sort((o1, o2) -> { @@ -103,7 +109,9 @@ continue; } byId1.setErwmNum(updateQrCodeNumDTO.getErwmNum()); - byId1.setRkModel(getLetter(updateQrCodeNumDTO.getErwmNum())); + if (byId1.getErwmNum()>0){ + byId1.setRkModel(getLetter(updateQrCodeNumDTO.getErwmNum())); + } slVolumeProductionRkService.updateById(byId1); } diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/dto/SlGoodsMaterialsSlVolumeProductionRkQuery.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/dto/SlGoodsMaterialsSlVolumeProductionRkQuery.java index 2da2b79..111a0a4 100644 --- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/dto/SlGoodsMaterialsSlVolumeProductionRkQuery.java +++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/dto/SlGoodsMaterialsSlVolumeProductionRkQuery.java @@ -10,4 +10,6 @@ public class SlGoodsMaterialsSlVolumeProductionRkQuery extends BasePage { @ApiModelProperty("物资id") private Long slGoodsMaterialsid; + @ApiModelProperty("仓库id") + private Long id; } diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/SlGoodsShelfService.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/SlGoodsShelfService.java index ad87ae9..5cad4a1 100644 --- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/SlGoodsShelfService.java +++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/SlGoodsShelfService.java @@ -1,5 +1,6 @@ package com.ruoyi.management.service; +import com.ruoyi.common.core.domain.R; import com.ruoyi.common.core.utils.page.PageDTO; import com.ruoyi.management.domain.SlGoodsShelf; import com.baomidou.mybatisplus.extension.service.IService; @@ -25,7 +26,7 @@ public interface SlGoodsShelfService extends IService<SlGoodsShelf> { PageDTO<SlGoodsShelfVO> getGoodsShelfList(@RequestBody SlGoodsShelfQuery slGoodsShelfQuery); - void addSlGoodsShelf(@RequestBody SlGoodsShelfDTO slGoodsShelfDTO); + R addSlGoodsShelf(@RequestBody SlGoodsShelfDTO slGoodsShelfDTO); SlGoodsShelfVO getSlGoodsShelfOne( Long id); diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/ManagementGoodsMaterialsServiceImpl.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/ManagementGoodsMaterialsServiceImpl.java index aa61c7d..a734fee 100644 --- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/ManagementGoodsMaterialsServiceImpl.java +++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/ManagementGoodsMaterialsServiceImpl.java @@ -46,6 +46,9 @@ @Override public PageDTO<ManagementGoodsMaterialsVO> getManagementGoodsMaterialsList(ManagementGoodsMaterialsQuery managementGoodsMaterialsQuery) { + if (managementGoodsMaterialsQuery.getStoreManagementGrade() == 0){ + managementGoodsMaterialsQuery.setStoreManagementGrade(null); + } LambdaQueryWrapper<SlStoreManagement> wrapper= Wrappers.lambdaQuery(); if (managementGoodsMaterialsQuery.getStoreManagementName()!=null&&managementGoodsMaterialsQuery.getStoreManagementName()!=""){ wrapper.like(SlStoreManagement::getStoreManagementName,managementGoodsMaterialsQuery.getStoreManagementName()); @@ -98,7 +101,8 @@ SlGoodsMaterialsList.add(0L); wrapper3.in(ManagementGoodsMaterials::getGoodsMaterialsId,SlGoodsMaterialsList); } - wrapper3.apply("repertory_zhai <repertory"); + wrapper3.apply("repertory_zhai < repertory"); + wrapper3.ne(ManagementGoodsMaterials::getRepertory,0); wrapper3.eq(ManagementGoodsMaterials::getDelFlag,0); wrapper3.orderByDesc(ManagementGoodsMaterials::getCreateTime); Page<ManagementGoodsMaterials> page1 = this.page(page, wrapper3); diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlAuditServiceImpl.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlAuditServiceImpl.java index ca23b4d..01be406 100644 --- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlAuditServiceImpl.java +++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlAuditServiceImpl.java @@ -42,6 +42,8 @@ @Resource private SlVolumeProductionRkglMapper slVolumeProductionRkglMapper; + @Resource + private SlVolumeProductionRkMapper slVolumeProductionRkMapper; @Resource private SlVolumeProductionCkglMapper slVolumeProductionCKglMapper; @@ -71,6 +73,12 @@ Page<SlAudit> page = new Page<>(auditRecordListQuery.getPageCurr(), auditRecordListQuery.getPageSize()); LambdaQueryWrapper< SlAudit> wrapper= Wrappers.lambdaQuery(); + wrapper.eq(SlAudit::getDelFlag,0); + if (auditRecordListQuery.getState()!=null){ + wrapper.eq(SlAudit::getState,auditRecordListQuery.getState()); + + } + if (goodsSkuIdList.size()>0){ wrapper.in(SlAudit::getSysId,goodsSkuIdList); }else{ @@ -114,7 +122,6 @@ .like("shenh_id", data.getUserId())).stream().map(SlAuditRecord::getAuditId).collect(Collectors.toList()); wrapper.in(SlAudit::getId,auditIds); } - break; } wrapper.eq(SlAudit::getType,auditRecordListQuery.getType()); @@ -139,10 +146,10 @@ } return slEquipmentVOPageDTO; } - + @Resource + private SlStoreManagementMapper slStoreManagementMapper; @Override public void addslAudit(SlAuditDTO slAuditDTO) { - LambdaQueryWrapper< SlAudit> wrapper= Wrappers.lambdaQuery(); wrapper.eq(SlAudit::getRkId,slAuditDTO.getRkId()); wrapper.eq(SlAudit::getType,slAuditDTO.getType()); @@ -163,101 +170,437 @@ slAudit.setState(1); slAudit.setCreateTime(new Date()); slAudit.setRkId(slAuditDTO.getRkId()); + // 根据发起人 if (slAudit.getType()==1){ SlVolumeProductionRkgl slVolumeProductionRkgl = slVolumeProductionRkglMapper.selectById(slAuditDTO.getRkId()); + SlStoreManagement slStoreManagement = slStoreManagementMapper.selectById(slVolumeProductionRkgl.getManagementId()); + String directorId = slStoreManagement.getDirectorId(); + String competentId = slStoreManagement.getCompetentId(); + String administratorId = slStoreManagement.getAdministratorId(); + Long userid = SecurityUtils.getUserId(); + List<String> list1 = Arrays.asList(administratorId.split(",")); + List<String> list2 = Arrays.asList(competentId.split(",")); + List<String> list3 = Arrays.asList(directorId.split(",")); + slAudit.setSysId(slVolumeProductionRkgl.getSysId()); slAudit.setManagementId(slVolumeProductionRkgl.getManagementId()); SlStoreManagement byId = slStoreManagementService.getById(slVolumeProductionRkgl.getManagementId()); slAudit.setShenhId(byId.getAdministratorId()); - this.save(slAudit); - SlAuditRecord slAuditRecord=new SlAuditRecord(); - slAuditRecord.setAuditId(slAudit.getId()); - slAuditRecord.setShenhId(byId.getAdministratorId()); - slAuditRecord.setType(1); - slAuditRecord.setState(1); - slAuditRecord.setCreateTime(new Date()); - slAuditRecordMapper.insert(slAuditRecord); + if (list3.contains(userid.toString())){ + slVolumeProductionRkgl.setAuditStatus(4); + slVolumeProductionRkgl.setPresentState(3); + slVolumeProductionRkglMapper.updateById(slVolumeProductionRkgl); + slAudit.setState(4); + this.save(slAudit); + // 主任发起 主管和管理员默认审核通过 + SlAuditRecord slAuditRecord4=new SlAuditRecord(); + slAuditRecord4.setAuditId(slAudit.getId()); + slAuditRecord4.setShenhId(byId.getDirectorId()); + slAuditRecord4.setType(3); + slAuditRecord4.setState(2); + slAuditRecord4.setShenhTime(new Date()); + slAuditRecord4.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord4); - SlAuditRecord slAuditRecord1=new SlAuditRecord(); - slAuditRecord1.setAuditId(slAudit.getId()); - slAuditRecord1.setShenhId(byId.getCompetentId()); - slAuditRecord1.setType(2); - slAuditRecord1.setState(1); - slAuditRecord1.setCreateTime(new Date()); - slAuditRecordMapper.insert(slAuditRecord1); + SlAuditRecord slAuditRecord3=new SlAuditRecord(); + slAuditRecord3.setAuditId(slAudit.getId()); + slAuditRecord3.setShenhId(byId.getCompetentId()); + slAuditRecord3.setType(2); + slAuditRecord3.setState(2); + slAuditRecord3.setShenhTime(new Date()); + slAuditRecord3.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord3); - SlAuditRecord slAuditRecord2=new SlAuditRecord(); - slAuditRecord2.setAuditId(slAudit.getId()); - slAuditRecord2.setShenhId(byId.getDirectorId()); - slAuditRecord2.setType(3); - slAuditRecord2.setState(1); - slAuditRecord2.setCreateTime(new Date()); - slAuditRecordMapper.insert(slAuditRecord2); + SlAuditRecord slAuditRecord2=new SlAuditRecord(); + slAuditRecord2.setAuditId(slAudit.getId()); + slAuditRecord2.setShenhId(byId.getAdministratorId()); + slAuditRecord2.setType(1); + slAuditRecord2.setState(2); + slAuditRecord2.setShenhTime(new Date()); + slAuditRecord2.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord2); + }else if (list2.contains(userid.toString())){ + slAudit.setState(3); + this.save(slAudit); + slVolumeProductionRkgl.setAuditStatus(3); + slVolumeProductionRkgl.setPresentState(1); + slVolumeProductionRkglMapper.updateById(slVolumeProductionRkgl); + // 如果是主管 + SlAuditRecord slAuditRecord3=new SlAuditRecord(); + slAuditRecord3.setAuditId(slAudit.getId()); + slAuditRecord3.setShenhId(byId.getCompetentId()); + slAuditRecord3.setType(2); + slAuditRecord3.setState(2); + slAuditRecord3.setShenhTime(new Date()); + slAuditRecord3.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord3); + + SlAuditRecord slAuditRecord2=new SlAuditRecord(); + slAuditRecord2.setAuditId(slAudit.getId()); + slAuditRecord2.setShenhId(byId.getAdministratorId()); + slAuditRecord2.setType(1); + slAuditRecord2.setState(2); + slAuditRecord2.setShenhTime(new Date()); + slAuditRecord2.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord2); + + SlAuditRecord slAuditRecord4=new SlAuditRecord(); + slAuditRecord4.setAuditId(slAudit.getId()); + slAuditRecord4.setShenhId(byId.getDirectorId()); + slAuditRecord4.setType(3); + slAuditRecord4.setState(1); + slAuditRecord4.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord4); + + }else if (list1.contains(userid.toString())){ + // 如果是管理员 + slAudit.setState(2); + this.save(slAudit); + slVolumeProductionRkgl.setAuditStatus(2); + slVolumeProductionRkgl.setPresentState(1); + slVolumeProductionRkglMapper.updateById(slVolumeProductionRkgl); + // 如果是主管 + SlAuditRecord slAuditRecord3=new SlAuditRecord(); + slAuditRecord3.setAuditId(slAudit.getId()); + slAuditRecord3.setShenhId(byId.getCompetentId()); + slAuditRecord3.setType(2); + slAuditRecord3.setState(1); + slAuditRecord3.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord3); + + SlAuditRecord slAuditRecord2=new SlAuditRecord(); + slAuditRecord2.setAuditId(slAudit.getId()); + slAuditRecord2.setShenhId(byId.getAdministratorId()); + slAuditRecord2.setType(1); + slAuditRecord2.setState(2); + slAuditRecord2.setShenhTime(new Date()); + slAuditRecord2.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord2); + + SlAuditRecord slAuditRecord4=new SlAuditRecord(); + slAuditRecord4.setAuditId(slAudit.getId()); + slAuditRecord4.setShenhId(byId.getDirectorId()); + slAuditRecord4.setType(3); + slAuditRecord4.setState(1); + slAuditRecord4.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord4); + } + if (!list3.contains(userid.toString()) && !list2.contains(userid.toString()) && !list1.contains(userid.toString())){ + this.save(slAudit); + + SlAuditRecord slAuditRecord=new SlAuditRecord(); + slAuditRecord.setAuditId(slAudit.getId()); + slAuditRecord.setShenhId(byId.getAdministratorId()); + slAuditRecord.setType(1); + slAuditRecord.setState(1); + slAuditRecord.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord); + + SlAuditRecord slAuditRecord3=new SlAuditRecord(); + slAuditRecord3.setAuditId(slAudit.getId()); + slAuditRecord3.setShenhId(byId.getCompetentId()); + slAuditRecord3.setType(2); + slAuditRecord3.setState(1); + slAuditRecord3.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord3); + + SlAuditRecord slAuditRecord4=new SlAuditRecord(); + slAuditRecord4.setAuditId(slAudit.getId()); + slAuditRecord4.setShenhId(byId.getDirectorId()); + slAuditRecord4.setType(3); + slAuditRecord4.setState(1); + slAuditRecord4.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord4); + } } - if (slAudit.getType()==2){ + if (slAudit.getType()==2) { SlVolumeProductionCkgl slVolumeProductionCkgl = slVolumeProductionCKglMapper.selectById(slAuditDTO.getRkId()); + SlStoreManagement slStoreManagement = slStoreManagementMapper.selectById(slVolumeProductionCkgl.getManagementId()); + String directorId = slStoreManagement.getDirectorId(); + String competentId = slStoreManagement.getCompetentId(); + String administratorId = slStoreManagement.getAdministratorId(); + Long userid = SecurityUtils.getUserId(); + List<String> list1 = Arrays.asList(administratorId.split(",")); + List<String> list2 = Arrays.asList(competentId.split(",")); + List<String> list3 = Arrays.asList(directorId.split(",")); + slAudit.setSysId(slVolumeProductionCkgl.getSysId()); slAudit.setManagementId(slVolumeProductionCkgl.getManagementId()); SlStoreManagement byId = slStoreManagementService.getById(slVolumeProductionCkgl.getManagementId()); slAudit.setShenhId(byId.getAdministratorId()); - this.save(slAudit); - SlAuditRecord slAuditRecord=new SlAuditRecord(); - slAuditRecord.setAuditId(slAudit.getId()); - slAuditRecord.setShenhId(byId.getAdministratorId()); - slAuditRecord.setType(1); - slAuditRecord.setState(1); - slAuditRecord.setCreateTime(new Date()); - slAuditRecordMapper.insert(slAuditRecord); + if (list3.contains(userid.toString())){ + slAudit.setState(4); + this.save(slAudit); + slVolumeProductionCkgl.setAuditStatus(4); + slVolumeProductionCkgl.setPresentState(3); + slVolumeProductionCKglMapper.updateById(slVolumeProductionCkgl); + // 主任发起 主管和管理员默认审核通过 + SlAuditRecord slAuditRecord4=new SlAuditRecord(); + slAuditRecord4.setAuditId(slAudit.getId()); + slAuditRecord4.setShenhId(byId.getDirectorId()); + slAuditRecord4.setType(3); + slAuditRecord4.setState(2); + slAuditRecord4.setShenhTime(new Date()); + slAuditRecord4.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord4); - SlAuditRecord slAuditRecord1=new SlAuditRecord(); - slAuditRecord1.setAuditId(slAudit.getId()); - slAuditRecord1.setShenhId(byId.getCompetentId()); - slAuditRecord1.setType(2); - slAuditRecord1.setState(1); - slAuditRecord1.setCreateTime(new Date()); - slAuditRecordMapper.insert(slAuditRecord1); + SlAuditRecord slAuditRecord3=new SlAuditRecord(); + slAuditRecord3.setAuditId(slAudit.getId()); + slAuditRecord3.setShenhId(byId.getCompetentId()); + slAuditRecord3.setType(2); + slAuditRecord3.setState(2); + slAuditRecord3.setShenhTime(new Date()); + slAuditRecord3.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord3); - SlAuditRecord slAuditRecord2=new SlAuditRecord(); - slAuditRecord2.setAuditId(slAudit.getId()); - slAuditRecord2.setShenhId(byId.getDirectorId()); - slAuditRecord2.setType(3); - slAuditRecord2.setState(1); - slAuditRecord2.setCreateTime(new Date()); - slAuditRecordMapper.insert(slAuditRecord2); + SlAuditRecord slAuditRecord2=new SlAuditRecord(); + slAuditRecord2.setAuditId(slAudit.getId()); + slAuditRecord2.setShenhId(byId.getAdministratorId()); + slAuditRecord2.setType(1); + slAuditRecord2.setState(2); + slAuditRecord2.setShenhTime(new Date()); + slAuditRecord2.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord2); + }else if (list2.contains(userid.toString())){ + slAudit.setState(3); + this.save(slAudit); + slVolumeProductionCkgl.setAuditStatus(3); + slVolumeProductionCkgl.setPresentState(1); + slVolumeProductionCKglMapper.updateById(slVolumeProductionCkgl); + // 如果是主管 + SlAuditRecord slAuditRecord3=new SlAuditRecord(); + slAuditRecord3.setAuditId(slAudit.getId()); + slAuditRecord3.setShenhId(byId.getCompetentId()); + slAuditRecord3.setType(2); + slAuditRecord3.setState(2); + slAuditRecord3.setShenhTime(new Date()); + slAuditRecord3.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord3); + + SlAuditRecord slAuditRecord2=new SlAuditRecord(); + slAuditRecord2.setAuditId(slAudit.getId()); + slAuditRecord2.setShenhId(byId.getAdministratorId()); + slAuditRecord2.setType(1); + slAuditRecord2.setState(2); + slAuditRecord2.setShenhTime(new Date()); + slAuditRecord2.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord2); + + SlAuditRecord slAuditRecord4=new SlAuditRecord(); + slAuditRecord4.setAuditId(slAudit.getId()); + slAuditRecord4.setShenhId(byId.getDirectorId()); + slAuditRecord4.setType(3); + slAuditRecord4.setState(1); + slAuditRecord4.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord4); + + }else if (list1.contains(userid.toString())){ + // 如果是管理员 + slAudit.setState(2); + this.save(slAudit); + slVolumeProductionCkgl.setAuditStatus(2); + slVolumeProductionCkgl.setPresentState(1); + slVolumeProductionCKglMapper.updateById(slVolumeProductionCkgl); + // 如果是主管 + SlAuditRecord slAuditRecord3=new SlAuditRecord(); + slAuditRecord3.setAuditId(slAudit.getId()); + slAuditRecord3.setShenhId(byId.getCompetentId()); + slAuditRecord3.setType(2); + slAuditRecord3.setState(1); + slAuditRecord3.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord3); + + SlAuditRecord slAuditRecord2=new SlAuditRecord(); + slAuditRecord2.setAuditId(slAudit.getId()); + slAuditRecord2.setShenhId(byId.getAdministratorId()); + slAuditRecord2.setType(1); + slAuditRecord2.setState(2); + slAuditRecord2.setShenhTime(new Date()); + slAuditRecord2.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord2); + + SlAuditRecord slAuditRecord4=new SlAuditRecord(); + slAuditRecord4.setAuditId(slAudit.getId()); + slAuditRecord4.setShenhId(byId.getDirectorId()); + slAuditRecord4.setType(3); + slAuditRecord4.setState(1); + slAuditRecord4.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord4); + } + if (!list3.contains(userid.toString()) && !list2.contains(userid.toString()) && !list1.contains(userid.toString())){ + this.save(slAudit); + + SlAuditRecord slAuditRecord=new SlAuditRecord(); + slAuditRecord.setAuditId(slAudit.getId()); + slAuditRecord.setShenhId(byId.getAdministratorId()); + slAuditRecord.setType(1); + slAuditRecord.setState(1); + slAuditRecord.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord); + + SlAuditRecord slAuditRecord3=new SlAuditRecord(); + slAuditRecord3.setAuditId(slAudit.getId()); + slAuditRecord3.setShenhId(byId.getCompetentId()); + slAuditRecord3.setType(2); + slAuditRecord3.setState(1); + slAuditRecord3.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord3); + + SlAuditRecord slAuditRecord4=new SlAuditRecord(); + slAuditRecord4.setAuditId(slAudit.getId()); + slAuditRecord4.setShenhId(byId.getDirectorId()); + slAuditRecord4.setType(3); + slAuditRecord4.setState(1); + slAuditRecord4.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord4); + } } - if (slAudit.getType()==3){ + if(slAuditDTO.getType() == 3){ SlVolumeProductionZygl slVolumeProductionZygl = slVolumeProductionZyglMapper.selectById(slAuditDTO.getRkId()); + slAudit.setSysId(slVolumeProductionZygl.getSysId()); + slAudit.setManagementId(slVolumeProductionZygl.getManagementId()); + slAudit.setZymanagementId(slVolumeProductionZygl.getBmanagementId()); + SlStoreManagement slStoreManagement = slStoreManagementMapper.selectById(slVolumeProductionZygl.getManagementId()); + String directorId = slStoreManagement.getDirectorId(); + String competentId = slStoreManagement.getCompetentId(); + String administratorId = slStoreManagement.getAdministratorId(); + Long userid = SecurityUtils.getUserId(); + List<String> list1 = Arrays.asList(administratorId.split(",")); + List<String> list2 = Arrays.asList(competentId.split(",")); + List<String> list3 = Arrays.asList(directorId.split(",")); + slAudit.setSysId(slVolumeProductionZygl.getSysId()); slAudit.setManagementId(slVolumeProductionZygl.getManagementId()); slAudit.setZymanagementId(slVolumeProductionZygl.getBmanagementId()); SlStoreManagement byId = slStoreManagementService.getById(slVolumeProductionZygl.getManagementId()); slAudit.setShenhId(byId.getAdministratorId()); - this.save(slAudit); - SlAuditRecord slAuditRecord=new SlAuditRecord(); - slAuditRecord.setAuditId(slAudit.getId()); - slAuditRecord.setShenhId(byId.getAdministratorId()); - slAuditRecord.setType(1); - slAuditRecord.setState(1); - slAuditRecord.setCreateTime(new Date()); - slAuditRecordMapper.insert(slAuditRecord); + if (list3.contains(userid.toString())){ + slAudit.setState(4); + this.save(slAudit); + slVolumeProductionZygl.setAuditStatus(4); + slVolumeProductionZygl.setPresentState(3); + slVolumeProductionZyglMapper.updateById(slVolumeProductionZygl); + // 主任发起 主管和管理员默认审核通过 + SlAuditRecord slAuditRecord4=new SlAuditRecord(); + slAuditRecord4.setAuditId(slAudit.getId()); + slAuditRecord4.setShenhId(byId.getDirectorId()); + slAuditRecord4.setType(3); + slAuditRecord4.setState(2); + slAuditRecord4.setShenhTime(new Date()); + slAuditRecord4.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord4); - SlAuditRecord slAuditRecord1=new SlAuditRecord(); - slAuditRecord1.setAuditId(slAudit.getId()); - slAuditRecord1.setShenhId(byId.getCompetentId()); - slAuditRecord1.setType(2); - slAuditRecord1.setState(1); - slAuditRecord1.setCreateTime(new Date()); - slAuditRecordMapper.insert(slAuditRecord1); + SlAuditRecord slAuditRecord3=new SlAuditRecord(); + slAuditRecord3.setAuditId(slAudit.getId()); + slAuditRecord3.setShenhId(byId.getCompetentId()); + slAuditRecord3.setType(2); + slAuditRecord3.setState(2); + slAuditRecord3.setShenhTime(new Date()); + slAuditRecord3.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord3); - SlAuditRecord slAuditRecord2=new SlAuditRecord(); - slAuditRecord2.setAuditId(slAudit.getId()); - slAuditRecord2.setShenhId(byId.getDirectorId()); - slAuditRecord2.setType(3); - slAuditRecord2.setState(1); - slAuditRecord2.setCreateTime(new Date()); - slAuditRecordMapper.insert(slAuditRecord2); + SlAuditRecord slAuditRecord2=new SlAuditRecord(); + slAuditRecord2.setAuditId(slAudit.getId()); + slAuditRecord2.setShenhId(byId.getAdministratorId()); + slAuditRecord2.setType(1); + slAuditRecord2.setState(2); + slAuditRecord2.setShenhTime(new Date()); + slAuditRecord2.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord2); + }else if (list2.contains(userid.toString())){ + slAudit.setState(3); + this.save(slAudit); + slVolumeProductionZygl.setAuditStatus(3); + slVolumeProductionZygl.setPresentState(1); + slVolumeProductionZyglMapper.updateById(slVolumeProductionZygl); + // 如果是主管 + SlAuditRecord slAuditRecord3=new SlAuditRecord(); + slAuditRecord3.setAuditId(slAudit.getId()); + slAuditRecord3.setShenhId(byId.getCompetentId()); + slAuditRecord3.setType(2); + slAuditRecord3.setState(2); + slAuditRecord3.setShenhTime(new Date()); + slAuditRecord3.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord3); + + SlAuditRecord slAuditRecord2=new SlAuditRecord(); + slAuditRecord2.setAuditId(slAudit.getId()); + slAuditRecord2.setShenhId(byId.getAdministratorId()); + slAuditRecord2.setType(1); + slAuditRecord2.setState(2); + slAuditRecord2.setShenhTime(new Date()); + slAuditRecord2.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord2); + + SlAuditRecord slAuditRecord4=new SlAuditRecord(); + slAuditRecord4.setAuditId(slAudit.getId()); + slAuditRecord4.setShenhId(byId.getDirectorId()); + slAuditRecord4.setType(3); + slAuditRecord4.setState(1); + slAuditRecord4.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord4); + + }else if (list1.contains(userid.toString())){ + // 如果是管理员 + slAudit.setState(2); + this.save(slAudit); + slVolumeProductionZygl.setAuditStatus(2); + slVolumeProductionZygl.setPresentState(1); + slVolumeProductionZyglMapper.updateById(slVolumeProductionZygl); + // 如果是主管 + SlAuditRecord slAuditRecord3=new SlAuditRecord(); + slAuditRecord3.setAuditId(slAudit.getId()); + slAuditRecord3.setShenhId(byId.getCompetentId()); + slAuditRecord3.setType(2); + slAuditRecord3.setState(1); + slAuditRecord3.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord3); + + SlAuditRecord slAuditRecord2=new SlAuditRecord(); + slAuditRecord2.setAuditId(slAudit.getId()); + slAuditRecord2.setShenhId(byId.getAdministratorId()); + slAuditRecord2.setType(1); + slAuditRecord2.setState(2); + slAuditRecord2.setShenhTime(new Date()); + slAuditRecord2.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord2); + + SlAuditRecord slAuditRecord4=new SlAuditRecord(); + slAuditRecord4.setAuditId(slAudit.getId()); + slAuditRecord4.setShenhId(byId.getDirectorId()); + slAuditRecord4.setType(3); + slAuditRecord4.setState(1); + slAuditRecord4.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord4); + } + if (!list3.contains(userid.toString()) && !list2.contains(userid.toString()) && !list1.contains(userid.toString())){ + this.save(slAudit); + + SlAuditRecord slAuditRecord=new SlAuditRecord(); + slAuditRecord.setAuditId(slAudit.getId()); + slAuditRecord.setShenhId(byId.getAdministratorId()); + slAuditRecord.setType(1); + slAuditRecord.setState(1); + slAuditRecord.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord); + + SlAuditRecord slAuditRecord3=new SlAuditRecord(); + slAuditRecord3.setAuditId(slAudit.getId()); + slAuditRecord3.setShenhId(byId.getCompetentId()); + slAuditRecord3.setType(2); + slAuditRecord3.setState(1); + slAuditRecord3.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord3); + + SlAuditRecord slAuditRecord4=new SlAuditRecord(); + slAuditRecord4.setAuditId(slAudit.getId()); + slAuditRecord4.setShenhId(byId.getDirectorId()); + slAuditRecord4.setType(3); + slAuditRecord4.setState(1); + slAuditRecord4.setCreateTime(new Date()); + slAuditRecordMapper.insert(slAuditRecord4); + } } - } } diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlEquipmentServiceImpl.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlEquipmentServiceImpl.java index b55157a..582e7e6 100644 --- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlEquipmentServiceImpl.java +++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlEquipmentServiceImpl.java @@ -73,6 +73,7 @@ if (slEquipmentDTO.getId()==null){ List<SlEquipment> list = this.list(new QueryWrapper<SlEquipment>() .eq("type", slEquipmentDTO.getType()) + .eq("del_flag","0") .eq("equipment_num", slEquipmentDTO.getEquipmentNum())); if (!list.isEmpty()){ return AjaxResult.error("当前设备已存在相同设备编号"); @@ -82,12 +83,14 @@ slEquipment.setEquipmentNum(slEquipmentDTO.getEquipmentNum()); slEquipment.setType(slEquipmentDTO.getType()); slEquipment.setManagementId(slEquipmentDTO.getManagementId()); + slEquipment.setCreateTime(new Date()); this.save(slEquipment); }else{ SlEquipment byId = this.getById(slEquipmentDTO.getId()); List<SlEquipment> list = this.list(new QueryWrapper<SlEquipment>() .eq("type", slEquipmentDTO.getType()) .ne("id",slEquipmentDTO.getId()) + .eq("del_flag","0") .eq("equipment_num", slEquipmentDTO.getEquipmentNum())); if (!list.isEmpty()){ return AjaxResult.error("当前设备已存在相同设备编号"); diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlGoodsShelfServiceImpl.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlGoodsShelfServiceImpl.java index aad0664..64db86e 100644 --- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlGoodsShelfServiceImpl.java +++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlGoodsShelfServiceImpl.java @@ -1,8 +1,10 @@ package com.ruoyi.management.service.impl; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.ruoyi.common.core.domain.R; import com.ruoyi.common.core.utils.page.BeanUtils; import com.ruoyi.common.core.utils.page.PageDTO; import com.ruoyi.common.security.utils.SecurityUtils; @@ -111,8 +113,15 @@ } @Override - public void addSlGoodsShelf(SlGoodsShelfDTO slGoodsShelfDTO) { + public R addSlGoodsShelf(SlGoodsShelfDTO slGoodsShelfDTO) { if (slGoodsShelfDTO.getId()==null){ + List<SlGoodsShelf> list = this.list(new QueryWrapper<SlGoodsShelf>() + .eq("del_flag","0") + .eq("store_management_id", slGoodsShelfDTO.getStoreManagementId()) + .eq("goods_shelf_name", slGoodsShelfDTO.getGoodsShelfName())); + if (list.size()>0){ + return R.fail("添加失败,当前仓库已有相同名称货架"); + } SlGoodsShelf slGoodsShelf=new SlGoodsShelf(); slGoodsShelf.setGoodsShelfName(slGoodsShelfDTO.getGoodsShelfName()); slGoodsShelf.setStoreManagementId(slGoodsShelfDTO.getStoreManagementId()); @@ -120,6 +129,14 @@ this.save(slGoodsShelf); }else{ SlGoodsShelf slGoodsShelf = this.getById(slGoodsShelfDTO.getId()); + List<SlGoodsShelf> list = this.list(new QueryWrapper<SlGoodsShelf>() + .ne("id", slGoodsShelfDTO.getId()) + .eq("del_flag","0") + .eq("store_management_id", slGoodsShelfDTO.getStoreManagementId()) + .eq("goods_shelf_name", slGoodsShelfDTO.getGoodsShelfName())); + if (list.size()>0){ + return R.fail("添加失败,当前仓库已有相同名称货架"); + } if (slGoodsShelfDTO.getGoodsShelfName()!=null){ slGoodsShelf.setGoodsShelfName(slGoodsShelfDTO.getGoodsShelfName()); } @@ -131,6 +148,7 @@ } this.updateById(slGoodsShelf); } + return R.ok(); } @Override @@ -142,7 +160,7 @@ SlStoreManagement byId = SlStoreManagementService.getById(byId1.getStoreManagementId()); slGoodsShelfVO.setStoreManagementId(byId1.getStoreManagementId()); slGoodsShelfVO.setStoreManagementName(byId.getStoreManagementName()); - slGoodsShelfVO.setStoreManagementNumber(byId.getStoreManagementNumber()); + slGoodsShelfVO.setStoreManagementNumber(byId1.getStoreManagementNumber()); slGoodsShelfVO.setProvinceName(byId.getProvinceName()); slGoodsShelfVO.setProvinceCode(byId.getProvinceCode()); slGoodsShelfVO.setCityName(byId.getCityName()); diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlStoreManagementServiceImpl.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlStoreManagementServiceImpl.java index 88eb02f..33761db 100644 --- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlStoreManagementServiceImpl.java +++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlStoreManagementServiceImpl.java @@ -53,13 +53,13 @@ Page<SlStoreManagement> page = new Page<>(storeManagementQuery.getPageCurr(), storeManagementQuery.getPageSize()); LambdaQueryWrapper< SlStoreManagement> wrapper= Wrappers.lambdaQuery(); if (storeManagementQuery.getStoreManagementName()!=null&&storeManagementQuery.getStoreManagementName()!=""){ - wrapper.eq(SlStoreManagement::getStoreManagementName,storeManagementQuery.getStoreManagementName()); + wrapper.like(SlStoreManagement::getStoreManagementName,storeManagementQuery.getStoreManagementName()); } - if(storeManagementQuery.getStoreManagementNo()!=null&&storeManagementQuery.getStoreManagementNo()!=""){ - wrapper.eq(SlStoreManagement::getStoreManagementNo,storeManagementQuery.getStoreManagementNo()); + if(storeManagementQuery.getStoreManagementNo()!=null&&storeManagementQuery.getStoreManagementNo()!="" ){ + wrapper.like(SlStoreManagement::getStoreManagementNo,storeManagementQuery.getStoreManagementNo()); } - if ( storeManagementQuery.getStoreManagementGrade()!=null &&!storeManagementQuery.getStoreManagementGrade().equals("0") ){ + if ( storeManagementQuery.getStoreManagementGrade()!=null &&!storeManagementQuery.getStoreManagementGrade().equals("0") ){ String[] split = storeManagementQuery.getStoreManagementGrade().split(","); List<Integer> arr=new ArrayList<>(); for(int i=0;i<split.length;i++){ @@ -176,18 +176,6 @@ @Override public List<SlStoreManagement> QueryStoreManagementList(QStoreManagementQuery StoreManagementQuery) { LambdaQueryWrapper< SlStoreManagement> wrapper= Wrappers.lambdaQuery(); - if (StoreManagementQuery.getCityCode()!=null && StoreManagementQuery.getCityCode()!=""){ - wrapper.eq(SlStoreManagement::getCityCode,StoreManagementQuery.getCityCode()); - } - if (StoreManagementQuery.getCountyCode()!=null && StoreManagementQuery.getCountyCode()!=""){ - wrapper.eq(SlStoreManagement::getCountyCode,StoreManagementQuery.getCountyCode()); - } - if (StoreManagementQuery.getTownCode()!=null && StoreManagementQuery.getTownCode()!=""){ - wrapper.eq(SlStoreManagement::getTownCode,StoreManagementQuery.getTownCode()); - } - if (StoreManagementQuery.getStoreManagementGrade()!=null&&StoreManagementQuery.getStoreManagementGrade()!=0){ - wrapper.eq(SlStoreManagement::getStoreManagementGrade,StoreManagementQuery.getStoreManagementGrade()); - } wrapper.eq(SlStoreManagement::getDelFlag,0); wrapper.orderByDesc(SlStoreManagement::getCreateTime); Long userid = tokenService.getLoginUser().getUserid(); @@ -197,19 +185,72 @@ // 仓库管理员 根据仓库管理员的等级查询对应的仓库 switch (data.getRoleType()){ case 3: - wrapper.ge(SlStoreManagement::getStoreManagementGrade,3); + if (StoreManagementQuery.getStoreManagementGrade()!=null&&StoreManagementQuery.getStoreManagementGrade()!=0){ + wrapper.ge(SlStoreManagement::getStoreManagementGrade,StoreManagementQuery.getStoreManagementGrade()); + }else{ + wrapper.eq(SlStoreManagement::getStoreManagementGrade,3); + + } + if (StoreManagementQuery.getCityCode()!=null && StoreManagementQuery.getCityCode()!=""){ + wrapper.eq(SlStoreManagement::getCityCode,StoreManagementQuery.getCityCode()); + }else if (StoreManagementQuery.getCountyCode()!=null){ + wrapper.eq(SlStoreManagement::getCountyCode,StoreManagementQuery.getCountyCode()); + wrapper.isNull(SlStoreManagement::getTownCode); + }else if (StoreManagementQuery.getTownCode()!=null){ + wrapper.eq(SlStoreManagement::getTownCode,StoreManagementQuery.getTownCode()); + }else{ + wrapper.eq(SlStoreManagement::getCityCode,data.getCityCode()); + wrapper.isNull(SlStoreManagement::getCountyCode); + } break; case 4: - wrapper.ge(SlStoreManagement::getStoreManagementGrade,4); + if (StoreManagementQuery.getStoreManagementGrade()!=null&&StoreManagementQuery.getStoreManagementGrade()!=0){ + wrapper.ge(SlStoreManagement::getStoreManagementGrade,StoreManagementQuery.getStoreManagementGrade()); + }else{ + wrapper.eq(SlStoreManagement::getStoreManagementGrade,4); + } + if (StoreManagementQuery.getCountyCode()!=null && StoreManagementQuery.getCountyCode()!=""){ + wrapper.eq(SlStoreManagement::getCountyCode,StoreManagementQuery.getCountyCode()); + }else{ + wrapper.eq(SlStoreManagement::getCountyCode,data.getCountyCode()); + wrapper.isNull(SlStoreManagement::getTownCode); + } break; case 5: - wrapper.ge(SlStoreManagement::getStoreManagementGrade,5); + if (StoreManagementQuery.getStoreManagementGrade()!=null&&StoreManagementQuery.getStoreManagementGrade()!=0){ + wrapper.ge(SlStoreManagement::getStoreManagementGrade,StoreManagementQuery.getStoreManagementGrade()); + }else{ + wrapper.eq(SlStoreManagement::getStoreManagementGrade,5); + } + if (StoreManagementQuery.getTownCode()!=null && StoreManagementQuery.getTownCode()!=""){ + wrapper.eq(SlStoreManagement::getTownCode,StoreManagementQuery.getTownCode()); + }else{ + wrapper.eq(SlStoreManagement::getTownCode,data.getTownCode()); + + } break; case 6: - wrapper.eq(SlStoreManagement::getStoreManagementGrade,6); + if (StoreManagementQuery.getStoreManagementGrade()!=null&&StoreManagementQuery.getStoreManagementGrade()!=0){ + wrapper.ge(SlStoreManagement::getStoreManagementGrade,StoreManagementQuery.getStoreManagementGrade()); + }else{ + wrapper.eq(SlStoreManagement::getStoreManagementGrade,6); + } break; } + }else { + if (StoreManagementQuery.getStoreManagementGrade()!=null&&StoreManagementQuery.getStoreManagementGrade()!=0){ + wrapper.eq(SlStoreManagement::getStoreManagementGrade,StoreManagementQuery.getStoreManagementGrade()); + } + if (StoreManagementQuery.getCityCode()!=null && StoreManagementQuery.getCityCode()!=""){ + wrapper.eq(SlStoreManagement::getCityCode,StoreManagementQuery.getCityCode()); + } + if (StoreManagementQuery.getCountyCode()!=null && StoreManagementQuery.getCountyCode()!=""){ + wrapper.eq(SlStoreManagement::getCountyCode,StoreManagementQuery.getCountyCode()); + } + if (StoreManagementQuery.getTownCode()!=null && StoreManagementQuery.getTownCode()!=""){ + wrapper.eq(SlStoreManagement::getTownCode,StoreManagementQuery.getTownCode()); + } } } @@ -232,15 +273,23 @@ switch (data.getRoleType()){ case 3: wrapper.ge(SlStoreManagement::getStoreManagementGrade,3); + wrapper.eq(SlStoreManagement::getCityCode,data.getCityCode()); + + break; case 4: + wrapper.eq(SlStoreManagement::getCountyCode,data.getCountyCode()); + wrapper.ge(SlStoreManagement::getStoreManagementGrade,4); break; case 5: + wrapper.eq(SlStoreManagement::getTownCode,data.getTownCode()); + wrapper.ge(SlStoreManagement::getStoreManagementGrade,5); break; case 6: wrapper.eq(SlStoreManagement::getStoreManagementGrade,6); + wrapper.eq(SlStoreManagement::getTownCode,data.getTownCode()); break; } } diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionCkServiceImpl.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionCkServiceImpl.java index 0e04574..d8864dd 100644 --- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionCkServiceImpl.java +++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionCkServiceImpl.java @@ -57,11 +57,26 @@ @Override public PageDTO<ManagementimgSlVolumeProductionCkVO> getManagementimgSlVolumeProductionCkList(SlGoodsMaterialsSlVolumeProductionRkQuery slGoodsMaterialsSlVolumeProductionRkQuery) { + QueryWrapper<SlVolumeProductionRk> notNull = new QueryWrapper<SlVolumeProductionRk>() + + .eq("del_flag", "0") + .isNotNull("new_add_time"); + if (slGoodsMaterialsSlVolumeProductionRkQuery.getId()!=null){ + notNull.eq("management_id", slGoodsMaterialsSlVolumeProductionRkQuery.getId()); + } + + // 查询该仓库的入库记录 + List<Long> collect = slVolumeProductionRkMapper.selectList(notNull + ).stream().map(SlVolumeProductionRk::getId).collect(Collectors.toList()); Page<SlVolumeProductionCk> page = new Page<>(slGoodsMaterialsSlVolumeProductionRkQuery.getPageCurr(), slGoodsMaterialsSlVolumeProductionRkQuery.getPageSize()); LambdaQueryWrapper< SlVolumeProductionCk> wrapper1= Wrappers.lambdaQuery(); - wrapper1.like(SlVolumeProductionCk::getMaterialsId,slGoodsMaterialsSlVolumeProductionRkQuery.getSlGoodsMaterialsid()); - wrapper1.eq( SlVolumeProductionCk::getDelFlag,0); + + wrapper1.eq(SlVolumeProductionCk::getMaterialsId,slGoodsMaterialsSlVolumeProductionRkQuery.getSlGoodsMaterialsid()); + wrapper1.eq(SlVolumeProductionCk::getDelFlag,0); wrapper1.orderByDesc(SlVolumeProductionCk::getCreateTime); + if (!collect.isEmpty()){ + wrapper1.in(SlVolumeProductionCk::getRkId,collect); + } Page<SlVolumeProductionCk> page2 = this.page(page, wrapper1); PageDTO<ManagementimgSlVolumeProductionCkVO> SlGoodsShelfDTO = PageDTO.of(page2, ManagementimgSlVolumeProductionCkVO.class); List<ManagementimgSlVolumeProductionCkVO> list2 = SlGoodsShelfDTO.getList(); @@ -199,6 +214,7 @@ wrapper.in("materials_id",collect1); wrapper.eq("management_id",query.getManagementId()); wrapper.eq("del_flag","0"); + wrapper.isNotNull("new_add_time"); Page<SlVolumeProductionRk> page2 = slVolumeProductionRkService.page(page, wrapper); List<SlVolumeProductionRk> list = page2.getRecords(); diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionCkglServiceImpl.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionCkglServiceImpl.java index 8a664ee..33b0631 100644 --- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionCkglServiceImpl.java +++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionCkglServiceImpl.java @@ -232,6 +232,7 @@ SlVolumeProductionRk slVolumeProductionRk = slVolumeProductionRkMapper.selectById(list.getRkId()); Long num =slVolumeProductionRk.getRepertoryZhai()-Long.valueOf(list.getCkNum()); slVolumeProductionRk.setRepertoryZhai(num); + slVolumeProductionRk.setNewAddTime("1"); slVolumeProductionRkMapper.updateById(slVolumeProductionRk); LambdaQueryWrapper<ManagementGoodsMaterials> wrapper2 = Wrappers.lambdaQuery(); wrapper2.eq(ManagementGoodsMaterials::getGoodsMaterialsId,list.getMaterialsId()); @@ -243,7 +244,7 @@ Long re1=repertoryZhai-Long.valueOf(list.getCkNum()); Integer num1= managementGoodsMaterials.getRepertoryChu()+list.getCkNum(); managementGoodsMaterials.setRepertoryZhai(re1); - managementGoodsMaterials.setCheckNum(num1); + managementGoodsMaterials.setRepertoryChu(num1); managementGoodsMaterialsMapper.updateById(managementGoodsMaterials); } } diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionRkServiceImpl.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionRkServiceImpl.java index a6c2f62..67a1a6c 100644 --- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionRkServiceImpl.java +++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionRkServiceImpl.java @@ -118,13 +118,14 @@ LambdaQueryWrapper< SlVolumeProductionRk> wrapper1= Wrappers.lambdaQuery(); wrapper1.eq(SlVolumeProductionRk::getMaterialsId,SlGoodsMaterialsSlVolumeProductionRkDTO.getSlGoodsMaterialsid()); wrapper1.eq( SlVolumeProductionRk::getDelFlag,0); + wrapper1.eq(SlVolumeProductionRk::getManagementId,SlGoodsMaterialsSlVolumeProductionRkDTO.getId()); + wrapper1.isNotNull(SlVolumeProductionRk::getNewAddTime); wrapper1.orderByDesc(SlVolumeProductionRk::getCreateTime); Page<SlVolumeProductionRk> page2 = this.page(page, wrapper1); PageDTO<ManagementimgVolumeProductionRkVO> SlGoodsShelfDTO = PageDTO.of(page2, ManagementimgVolumeProductionRkVO.class); List<ManagementimgVolumeProductionRkVO> list2 = SlGoodsShelfDTO.getList(); for(ManagementimgVolumeProductionRkVO list:list2) {{ SlGoodsMaterials slGoodsMaterials = slGoodsMaterialsMapper.selectById(list.getMaterialsId()); - if (slGoodsMaterials!=null){ list.setGoodsMaterialsName(slGoodsMaterials.getGoodsMaterialsName()); list.setIsConsume(slGoodsMaterials.getIsConsume()); @@ -136,8 +137,6 @@ list.setSupplierName(data.getNickName()); } } - - SlGoodsShelf slGoodsShelf = slGoodsShelfMapper.selectById(list.getShelfId()); if (slGoodsShelf!=null){ list.setGoodsShelfName(slGoodsShelf.getGoodsShelfName()); @@ -200,7 +199,6 @@ }if (a.getRkNumber()!=null){ byId.setRkNumber(a.getRkNumber()); } - byId.setNewAddTime(a.getNewAddTime()); this.updateById(byId); } diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionRkglServiceImpl.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionRkglServiceImpl.java index 4b51b73..2bf2154 100644 --- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionRkglServiceImpl.java +++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionRkglServiceImpl.java @@ -1,10 +1,12 @@ package com.ruoyi.management.service.impl; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.ruoyi.common.core.utils.page.BeanUtils; import com.ruoyi.common.core.utils.page.PageDTO; +import com.ruoyi.common.security.service.TokenService; import com.ruoyi.common.security.utils.SecurityUtils; import com.ruoyi.management.domain.*; import com.ruoyi.management.domain.dto.SupplierVolumeProductionRkglQuery; @@ -20,6 +22,7 @@ import com.ruoyi.system.api.domain.getVolumeProductionRkQuery; import com.ruoyi.system.api.feignClient.LogClient; import com.ruoyi.system.api.feignClient.SysUserClient; +import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import javax.annotation.Resource; @@ -111,17 +114,54 @@ v.setReason(byId.getReasonsRefusal()); return v; } - + @Autowired + private TokenService tokenService; @Override public PageDTO<SupplierVolumeProductionRkglVO> getslVolumeProductionRkglList(getVolumeProductionRkQuery getVolumeProductionRkQuery) { Page<SlVolumeProductionRkgl> page = new Page<>(getVolumeProductionRkQuery.getPageCurr(), getVolumeProductionRkQuery.getPageSize()); List<SysUser> data1 = sysUserClient.getUserSupplierList(getVolumeProductionRkQuery).getData(); Set<Long> goodsSkuIdList = null; + List<Long> managementIds = new ArrayList<>(); goodsSkuIdList = data1.stream().map(SysUser::getUserId) .collect(Collectors.toSet()); - + Long userid = tokenService.getLoginUser().getUserid(); + SysUser data2 = sysUserClient.getSysUser(userid).getData(); LambdaQueryWrapper< SlVolumeProductionRkgl> wrapper1= Wrappers.lambdaQuery(); + QueryWrapper<SlStoreManagement> storeManagementGrade = new QueryWrapper<SlStoreManagement>() + .eq("del_flag", "0"); + if (data2!=null){ + if (!data2.getUserType().equals("00")){ + // 仓库管理员 根据仓库管理员的等级查询对应的仓库 + switch (data2.getRoleType()){ + case 3: + storeManagementGrade.ge("store_management_grade",3); + managementIds = slStoreManagementMapper.selectList(storeManagementGrade).stream() + .map(SlStoreManagement::getId).collect(Collectors.toList()); + break; + case 4: + storeManagementGrade.ge("store_management_grade",4); + managementIds = slStoreManagementMapper.selectList(storeManagementGrade).stream() + .map(SlStoreManagement::getId).collect(Collectors.toList()); + break; + case 5: + storeManagementGrade.ge("store_management_grade",5); + managementIds = slStoreManagementMapper.selectList(storeManagementGrade).stream() + .map(SlStoreManagement::getId).collect(Collectors.toList()); + break; + case 6: + storeManagementGrade.eq("store_management_grade",6); + managementIds = slStoreManagementMapper.selectList(storeManagementGrade).stream() + .map(SlStoreManagement::getId).collect(Collectors.toList()); + break; + } + + } + + } + if (!managementIds.isEmpty()){ + wrapper1.in(SlVolumeProductionRkgl::getManagementId,managementIds); + } if (getVolumeProductionRkQuery.getPresentState()!=null && getVolumeProductionRkQuery.getPresentState()!=0){ wrapper1.eq(SlVolumeProductionRkgl::getPresentState,getVolumeProductionRkQuery.getPresentState()); } @@ -185,10 +225,9 @@ slVolumeProductionRkgl.setPresentState(3); } if (list3.contains(userid.toString())){ - slVolumeProductionRkgl.setAuditStatus(1); + slVolumeProductionRkgl.setAuditStatus(3); slVolumeProductionRkgl.setPresentState(4); } - this.save(slVolumeProductionRkgl); }else{ slVolumeProductionRkgl = this.getById(volumeProductionRkglDTO.getId()); @@ -219,7 +258,7 @@ slVolumeProductionRkgl.setPresentState(3); } if (list3.contains(userid.toString())){ - slVolumeProductionRkgl.setAuditStatus(1); + slVolumeProductionRkgl.setAuditStatus(3); slVolumeProductionRkgl.setPresentState(4); } this.updateById(slVolumeProductionRkgl); diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionZyServiceImpl.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionZyServiceImpl.java index c7977d7..94462c6 100644 --- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionZyServiceImpl.java +++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionZyServiceImpl.java @@ -122,7 +122,6 @@ slVolumeProductionZygl.setPresentState(1); slVolumeProductionZyglMapper.insert(slVolumeProductionZygl); addaddSlVolumeProductionZyDTO.setId(slVolumeProductionZygl.getId()); - // 新增 List<AddZYIdsDTO> rkId = addaddSlVolumeProductionZyDTO.getAddZYIdsDTOS(); for (AddZYIdsDTO m:rkId){ @@ -139,7 +138,6 @@ slVolumeProductionZy.setStoreManagementNumber(m.getStoreManagementNumber()); slVolumeProductionZy.setShelfId(m.getShelfId()); slVolumeProductionZy.setSysId(userid); - slVolumeProductionZy.setRkId(m.getRkId()); if (slVolumeProductionRkgl!=null){ if (slVolumeProductionRkgl.getSupplierId()!=null){ slVolumeProductionZy.setSupplierId(Integer.valueOf(slVolumeProductionRkgl.getSupplierId().toString())); @@ -162,8 +160,10 @@ slVolumeProductionRk.setRkNumber("CD-"+simpleDateFormat.format(new Date())+ UUIDUtil.getNumberRandom(2)); slVolumeProductionRk.setRkNum(Long.valueOf(zy.getZyNum())); SlVolumeProductionRk slVolumeProductionRk2 = slVolumeProductionRkMapper.selectById(zy.getRkId()); - slVolumeProductionRk.setRkPice(slVolumeProductionRk2.getRkPice()); - if (slVolumeProductionRk2!=null)slVolumeProductionRk.setRkModel(slVolumeProductionRk2.getRkModel()); + if (slVolumeProductionRk2!=null){ + slVolumeProductionRk.setRkModel(slVolumeProductionRk2.getRkModel()); + slVolumeProductionRk.setRkPice(slVolumeProductionRk2.getRkPice()); + } slVolumeProductionRk.setShelfId(zy.getShelfId()); slVolumeProductionRk.setRepertoryZhai(Long.valueOf(zy.getZyNum())); slVolumeProductionRk.setCreateTime(new Date()); @@ -204,7 +204,11 @@ slVolumeProductionZy.setShelfId(m.getShelfId()); slVolumeProductionZy.setSysId(userid); slVolumeProductionZy.setRkId(m.getRkId()); - slVolumeProductionZy.setSupplierId(Integer.parseInt(slVolumeProductionRkgl.getSupplierId().toString())); + if (slVolumeProductionRkgl!=null){ + if (slVolumeProductionRkgl.getSupplierId()!=null){ + slVolumeProductionZy.setSupplierId(Integer.valueOf(slVolumeProductionRkgl.getSupplierId().toString())); + } + } this.save(slVolumeProductionZy); // slVolumeProductionZyQueryWrapper.eq("rk_id",z.getRkId()); // slVolumeProductionZyQueryWrapper.eq("del_flag","0"); diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionZyglServiceImpl.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionZyglServiceImpl.java index 9da41b0..af504ac 100644 --- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionZyglServiceImpl.java +++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionZyglServiceImpl.java @@ -364,6 +364,10 @@ // 新入库ids List<Long> collect = page2.stream().map(SlVolumeProductionZy::getScrkId).collect(Collectors.toList()); for (SlVolumeProductionZy zy : page2) { + // 将入库记录确认 + SlVolumeProductionRk slVolumeProductionRk = slVolumeProductionRkMapper.selectById(zy.getScrkId()); + slVolumeProductionRk.setNewAddTime("1"); + slVolumeProductionRkMapper.updateById(slVolumeProductionRk); // 确认转移之后扣库存 SlVolumeProductionRk slVolumeProductionRk1 = slVolumeProductionRkMapper.selectById(zy.getRkId()); slVolumeProductionRk1.setRepertoryZhai(slVolumeProductionRk1.getRepertoryZhai()-Long.valueOf(zy.getZyNum())); diff --git a/ruoyi-modules/ruoyi-management/src/main/resources/mapper/management/SlGoodsMaterialsMapper.xml b/ruoyi-modules/ruoyi-management/src/main/resources/mapper/management/SlGoodsMaterialsMapper.xml index 3ac5b55..a9459e9 100644 --- a/ruoyi-modules/ruoyi-management/src/main/resources/mapper/management/SlGoodsMaterialsMapper.xml +++ b/ruoyi-modules/ruoyi-management/src/main/resources/mapper/management/SlGoodsMaterialsMapper.xml @@ -15,9 +15,7 @@ <if test="req.isConsume != null and req.isConsume != ''"> is_consume = #{req.isConsume}, </if> - <if test="req.repertory != null and req.repertory != ''"> repertory = #{req.repertory}, - </if> </set> WHERE id = #{req.id} </update> diff --git a/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/controller/SysOperlogController.java b/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/controller/SysOperlogController.java index b2f021a..d31fa29 100644 --- a/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/controller/SysOperlogController.java +++ b/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/controller/SysOperlogController.java @@ -86,11 +86,11 @@ } if(gy.getBeginTime()!=null){ - wrapper.le(SysOperLog::getOperTime, gy.getBeginTime()); + wrapper.gt(SysOperLog::getOperTime, gy.getBeginTime()); } if(gy.getEndTime()!=null){ - wrapper.gt(SysOperLog::getOperTime, gy.getEndTime()); + wrapper.lt(SysOperLog::getOperTime, gy.getEndTime()); } wrapper.orderByDesc(SysOperLog::getOperTime); Page<SysOperLog> sysOperLogPage = operLogService.selectPage(page, wrapper); -- Gitblit v1.7.1