ruoyi-auth/src/main/java/com/ruoyi/auth/service/SysLoginService.java
@@ -106,6 +106,9 @@ recordLogService.recordLogininfor(username, Constants.LOGIN_FAIL, "用户已停用,请联系管理员"); throw new ServiceException("对不起,您的账号:" + username + " 已停用"); } if (user.getUserType().equals("02")){ throw new ServiceException("登录失败,登录账号权限不足"); } if (user.getUserType().equals("03")){ SeBei se=new SeBei(); se.setUserId(user.getUserId()); ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlRegionController.java
@@ -9,6 +9,7 @@ import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; @@ -46,13 +47,13 @@ @PostMapping("/getcountyRegione") @ApiOperation(value = "获取县") public R<List<SlRegion>> getcountyRegione(RegionQuery regionQuery) { public R<List<SlRegion>> getcountyRegione(@RequestBody RegionQuery regionQuery) { return R.ok(regionService.getcountyRegione(regionQuery)); } @PostMapping("/gettownRegione") @ApiOperation(value = "获取乡") public R<List<SlRegion>> gettownRegione(RegionQuery regionQuery) { public R<List<SlRegion>> gettownRegione(@RequestBody RegionQuery regionQuery) { return R.ok(regionService.gettownRegione(regionQuery)); } ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlVolumeProductionCkController.java
@@ -5,6 +5,7 @@ import com.ruoyi.common.core.utils.page.PageDTO; import com.ruoyi.management.domain.SlVolumeProductionCk; import com.ruoyi.management.domain.dto.*; import com.ruoyi.management.domain.vo.InventoriesSuppliesInfoVO; import com.ruoyi.management.domain.vo.ManagementimgSlVolumeProductionCkVO; import com.ruoyi.management.domain.vo.ManagementimgVolumeProductionCkVO; import com.ruoyi.management.domain.vo.ManagementimgVolumeProductionRkVO; @@ -33,7 +34,11 @@ @Resource private SlVolumeProductionCkService slVolumeProductionCkService; @PostMapping("/getMaterialByManagementIdList") @ApiOperation(value = "发起出库 根据仓库Id 选择物资") public R<PageDTO<InventoriesSuppliesInfoVO>> getMaterialByManagementIdList(@RequestBody GetMaterialsByManagementIdQuery query) { return R.ok(slVolumeProductionCkService.getMaterialByManagementIdList(query)); } @PostMapping("/getManagementimgSlVolumeProductionCkList") @ApiOperation(value = "分页获取通过物资来获取当前批次出库的物资") public R<PageDTO<ManagementimgSlVolumeProductionCkVO>> getManagementimgSlVolumeProductionCkList(@RequestBody SlGoodsMaterialsSlVolumeProductionRkQuery slGoodsMaterialsSlVolumeProductionRkQuery) { ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlVolumeProductionRkController.java
@@ -5,10 +5,7 @@ import com.ruoyi.common.core.utils.page.PageDTO; import com.ruoyi.management.domain.SlVolumeProductionRk; import com.ruoyi.management.domain.dto.*; import com.ruoyi.management.domain.vo.ManagementimgVolumeProductionRkVO; import com.ruoyi.management.domain.vo.VolumeProductionRkgInventoryVO; import com.ruoyi.management.domain.vo.getVolumeProductionRkgCodeVO; import com.ruoyi.management.domain.vo.gethuojRkVO; import com.ruoyi.management.domain.vo.*; import com.ruoyi.management.service.SlVolumeProductionRkService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; @@ -83,8 +80,9 @@ @PostMapping("/codeInfo/{id}") @ApiOperation(value = "获取二维码样式") public R<ManagementimgVolumeProductionRkVO> codeInfo( @ApiParam(name = "id", value = "入库批次id", required = true) @PathVariable("id") Long id){ return R.ok(slVolumeProductionRkService.codeInfo(id)); public R<List<QRCodeVO>> codeInfo(@ApiParam(name = "id", value = "入库管理id", required = true) @PathVariable("id") Long id){ slVolumeProductionRkService.codeInfo(id); return R.ok(); } @PostMapping("/getSlvolumeVolumeProductionRkList") ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/controller/SlVolumeProductionZyController.java
@@ -5,10 +5,8 @@ import com.ruoyi.common.core.utils.page.PageDTO; import com.ruoyi.management.domain.SlVolumeProductionZy; import com.ruoyi.management.domain.dto.*; import com.ruoyi.management.domain.vo.ManagementimgSlVolumeProductionCkVO; import com.ruoyi.management.domain.vo.ManagementimgVolumeProductionCkVO; import com.ruoyi.management.domain.vo.getVolumeProductionRkgCodeVO; import com.ruoyi.management.domain.vo.getVolumeProductionzyCodeVO; import com.ruoyi.management.domain.dto.ManagementimgVolumeProductionZyVO; import com.ruoyi.management.domain.vo.*; import com.ruoyi.management.service.SlVolumeProductionZyService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; @@ -34,6 +32,11 @@ @Resource private SlVolumeProductionZyService slVolumeProductionZyService; @PostMapping("/getNumberAndShelfByManagementId") @ApiOperation(value = "根据仓库id 查询楼层和货架") public R<NumberAndShelfVO> getNumberAndShelfByManagementId(@RequestBody QueryDTO dto) { return R.ok(slVolumeProductionZyService.getNumberAndShelfByManagementId(dto)); } @PostMapping("/getVolumeProductionzyCode") @ApiOperation(value = "获取转移管理二维码") public R<PageDTO<getVolumeProductionzyCodeVO>> getVolumeProductionzyCode(VolumeProductionZygCodeQuery volumeProductionZygCodeQuery) { ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/SlAuditRecord.java
@@ -5,6 +5,8 @@ import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import java.util.Date; import com.fasterxml.jackson.annotation.JsonFormat; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Getter; ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/dto/GetMaterialsByManagementIdQuery.java
New file @@ -0,0 +1,17 @@ package com.ruoyi.management.domain.dto; import com.ruoyi.common.core.web.page.BasePage; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; @Data @ApiModel("出库-通过仓库Id查询对应物资") public class GetMaterialsByManagementIdQuery extends BasePage { @ApiModelProperty("仓库id") private Long managementId; @ApiModelProperty("物资名称") private String materialsName; @ApiModelProperty("物资类型 1消耗 2非消耗") private Integer isConsume; } ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/dto/QueryDTO.java
New file @@ -0,0 +1,18 @@ package com.ruoyi.management.domain.dto; import com.ruoyi.management.domain.SlGoodsShelf; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import java.util.List; @Data @ApiModel("查询仓库楼层数量和货架数量") public class QueryDTO { @ApiModelProperty("所在楼层") private Integer managementNumber; @ApiModelProperty("仓库id") private Long managementId; } ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/vo/ManagementimgVolumeProductionRkVO.java
@@ -60,6 +60,10 @@ @ApiModelProperty("判断是不是新增的数据") private String newAddTime; @ApiModelProperty("二维码数量") private String erwmNum; @ApiModelProperty("已扫描二维码数量") private String smerwmNum; ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/vo/NumberAndShelfVO.java
New file @@ -0,0 +1,17 @@ package com.ruoyi.management.domain.vo; import com.ruoyi.management.domain.SlGoodsShelf; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import java.util.List; @Data @ApiModel(value = "根据仓库id 获取对应货架和楼层VO", description = "根据仓库id 获取对应货架和楼层VO") public class NumberAndShelfVO { @ApiModelProperty("楼层 1=一层 2=二层。。。") private List<String> number; @ApiModelProperty("货架列表") private List<SlGoodsShelf> goodsShelfList; } ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/vo/QRCodeVO.java
New file @@ -0,0 +1,39 @@ package com.ruoyi.management.domain.vo; import com.ruoyi.management.domain.SlGoodsShelf; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import java.math.BigDecimal; import java.util.List; @Data @ApiModel(value = "生成二维码VO", description = "生成二维码VO") public class QRCodeVO { private Long id; @ApiModelProperty("二维码") private String qrCode; @ApiModelProperty("物资名称") private String goodsMaterialsName; @ApiModelProperty("供应商名称") private String supplierName; @ApiModelProperty("物资批次(物资缩写+时间202401010000)") private String materials; @ApiModelProperty("物资数量") private Long materialsNum; @ApiModelProperty("仓库名称") private String storeManagementName; @ApiModelProperty("入管理主表id") private Long VolumeProductionRkglId; @ApiModelProperty("物资id") private Long materialsId; @ApiModelProperty("货架id") private Long shelfId; @ApiModelProperty("仓库id") private Long storeManagementId; @ApiModelProperty("分类") private String category; } ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/vo/SlAuditVO.java
@@ -2,9 +2,12 @@ import cn.hutool.core.date.DateTime; import com.baomidou.mybatisplus.annotation.TableField; import com.fasterxml.jackson.annotation.JsonFormat; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import java.util.Date; @Data @ApiModel(value = "审核管理视图对象", description = "审核管理视图对象") @@ -18,7 +21,8 @@ private String sysPhone; @ApiModelProperty("发起时间") private DateTime createTime; @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") private Date createTime; @ApiModelProperty("入库管理id") private Long rkId; ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/domain/vo/VolumeProductionZyglInfoVO.java
@@ -1,6 +1,7 @@ package com.ruoyi.management.domain.vo; import com.baomidou.mybatisplus.annotation.TableField; import com.fasterxml.jackson.annotation.JsonFormat; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; @@ -30,6 +31,7 @@ private String BstoreManagementName; @ApiModelProperty("发起时间") @JsonFormat(pattern = "yyyy-MM-dd HH:mm") private Date startiTime; @ApiModelProperty("结束时间") ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/SlVolumeProductionCkService.java
@@ -3,10 +3,8 @@ import com.ruoyi.common.core.utils.page.PageDTO; import com.ruoyi.management.domain.SlVolumeProductionCk; import com.baomidou.mybatisplus.extension.service.IService; import com.ruoyi.management.domain.dto.AddSlVolumeProductionCkDTO; import com.ruoyi.management.domain.dto.ManagementimgVolumeProductionCkQuery; import com.ruoyi.management.domain.dto.SlGoodsMaterialsSlVolumeProductionRkQuery; import com.ruoyi.management.domain.dto.SlVolumeProductionCkDTO; import com.ruoyi.management.domain.dto.*; import com.ruoyi.management.domain.vo.InventoriesSuppliesInfoVO; import com.ruoyi.management.domain.vo.ManagementimgSlVolumeProductionCkVO; import com.ruoyi.management.domain.vo.ManagementimgVolumeProductionCkVO; import org.springframework.web.bind.annotation.RequestBody; @@ -32,4 +30,7 @@ PageDTO<ManagementimgVolumeProductionCkVO> getSlVolumeProductionCkList(ManagementimgVolumeProductionCkQuery managementimgVolumeProductionCkQuery); List<ManagementimgVolumeProductionCkVO> SlVolumeProductionCkList( ManagementimgVolumeProductionCkQuery managementimgVolumeProductionCkQuery); PageDTO<InventoriesSuppliesInfoVO> getMaterialByManagementIdList(GetMaterialsByManagementIdQuery query); } ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/SlVolumeProductionRkService.java
@@ -5,6 +5,7 @@ import com.baomidou.mybatisplus.extension.service.IService; import com.ruoyi.management.domain.dto.*; import com.ruoyi.management.domain.vo.ManagementimgVolumeProductionRkVO; import com.ruoyi.management.domain.vo.QRCodeVO; import com.ruoyi.management.domain.vo.getVolumeProductionRkgCodeVO; import com.ruoyi.management.domain.vo.gethuojRkVO; import io.swagger.annotations.ApiParam; @@ -32,7 +33,7 @@ void uplSlVolumeProductionRk(@RequestBody List<SlVolumeProductionRkDTO> SlVolumeProductionRkDTO); PageDTO<getVolumeProductionRkgCodeVO> getVolumeProductionRkgCode(VolumeProductionRkgCodeQuery volumeProductionRkgCodeQuery); ManagementimgVolumeProductionRkVO codeInfo(Long id); List<QRCodeVO> codeInfo(Long id); PageDTO<ManagementimgVolumeProductionRkVO> getroductionRkList(umeProductionRkQuery meProductionRkQuery); ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/SlVolumeProductionZyService.java
@@ -4,6 +4,7 @@ import com.ruoyi.management.domain.SlVolumeProductionZy; import com.baomidou.mybatisplus.extension.service.IService; import com.ruoyi.management.domain.dto.*; import com.ruoyi.management.domain.vo.NumberAndShelfVO; import com.ruoyi.management.domain.vo.getVolumeProductionzyCodeVO; import org.springframework.web.bind.annotation.RequestBody; @@ -25,4 +26,6 @@ void updSlVolumeProductionZy(List<UpdaddSlVolumeProductionZyDTO> updaddSlVolumeProductionZyDTO); PageDTO<ManagementimgVolumeProductionZyVO> getSlVolumeProductionZyList( ManagementimgVolumeProductionZyQuery managementimgVolumeProductionZyQuery); NumberAndShelfVO getNumberAndShelfByManagementId(QueryDTO dto); } ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/InventoriesSuppliesInfoServiceImpl.java
@@ -14,10 +14,7 @@ import org.springframework.stereotype.Service; import javax.annotation.Resource; import java.util.HashSet; import java.util.List; import java.util.ListResourceBundle; import java.util.Set; import java.util.*; /** * <p> @@ -77,6 +74,7 @@ InventoriesSuppliesInfo inventoriesSuppliesInf=new InventoriesSuppliesInfo(); inventoriesSuppliesInf.setSuppliesId(m.getSuppliesId()); inventoriesSuppliesInf.setRkId(m.getRkId()); inventoriesSuppliesInf.setCreateTime(new Date()); SlVolumeProductionRk slVolumeProductionRk = slVolumeProductionRkMapper.selectById(m.getRkId()); inventoriesSuppliesInf.setZkNum(slVolumeProductionRk.getRepertoryZhai()); inventoriesSuppliesInf.setSuppliesNum(m.getSuppliesNum()); ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/InventoriesSuppliesServiceImpl.java
@@ -114,6 +114,7 @@ InventoriesSupplies inventoriesSupplies=new InventoriesSupplies(); inventoriesSupplies.setMaterialsId(inventoriesSuppDTO.getMaterialsId()); inventoriesSupplies.setPdTime(new Date()); inventoriesSupplies.setCreateTime(new Date()); inventoriesSupplies.setPdrId(inventoriesSuppDTO.getPdrId()); R<SysUser> sysUser = sysUserClient.getSysUser(inventoriesSuppDTO.getPdrId()); inventoriesSupplies.setPdrName(sysUser.getData().getNickName()); ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlAuditRecordServiceImpl.java
@@ -1,6 +1,7 @@ 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.ruoyi.common.security.utils.SecurityUtils; import com.ruoyi.management.domain.*; @@ -57,12 +58,15 @@ @Override public void updSlAuditRecord(AuditRecordDTO auditRecordDTO) { SlAudit slAudit = slAuditMapper.selectById(auditRecordDTO.getAuditId()); SlAuditRecord byId = this.getById(auditRecordDTO.getId()); SlAuditRecord byId = this.getOne(new QueryWrapper<SlAuditRecord>() .eq("type", auditRecordDTO.getType()) .eq("audit_id", auditRecordDTO.getAuditId())); Long userid = SecurityUtils.getUserId(); SysUser data = sysUserClient.getSysUser(userid).getData(); if (auditRecordDTO.getState()==2){ Long userid = SecurityUtils.getUserId(); SysUser data = sysUserClient.getSysUser(userid).getData(); byId.setShenhName(data.getNickName()); byId.setShenhTime(new Date()); byId.setState(auditRecordDTO.getState()); this.updateById(byId); if (slAudit.getState()==1){ slAudit.setState(2); @@ -92,12 +96,12 @@ slVolumeProductionZyglMapper.updateById(slVolumeProductionZygl); } } if (slAudit.getState()==2){ } else if (slAudit.getState()==2){ slAudit.setState(3); LambdaQueryWrapper<SlAuditRecord> wrapper= Wrappers.lambdaQuery(); wrapper.eq(SlAuditRecord::getAuditId,auditRecordDTO.getAuditId()); wrapper.eq(SlAuditRecord::getType,3); wrapper.eq( SlAuditRecord::getDelFlag,0); wrapper.eq(SlAuditRecord::getDelFlag,0); SlAuditRecord one = this.getOne(wrapper); slAudit.setShenhId(one.getShenhId()); slAuditMapper.updateById(slAudit); @@ -120,7 +124,7 @@ slVolumeProductionZyglMapper.updateById(slVolumeProductionZygl); } }if (slAudit.getState()==3){ }else if (slAudit.getState()==3){ slAudit.setState(4); slAuditMapper.updateById(slAudit); if (slAudit.getType()==1){ @@ -147,12 +151,20 @@ } } if (auditRecordDTO.getState()==3){ }else if (auditRecordDTO.getState()==3){ byId.setShenhName(data.getNickName()); byId.setShenhTime(new Date()); byId.setState(auditRecordDTO.getState()); this.updateById(byId); LambdaQueryWrapper<SlAuditRecord> wrapper= Wrappers.lambdaQuery(); wrapper.eq(SlAuditRecord::getAuditId,auditRecordDTO.getAuditId()); wrapper.eq(SlAuditRecord::getType,3); wrapper.eq(SlAuditRecord::getDelFlag,0); SlAuditRecord one = this.getOne(wrapper); slAudit.setShenhId(one.getShenhId()); slAudit.setCause(auditRecordDTO.getCause()); slAudit.setState(5); slAuditMapper.updateById(slAudit); if (slAudit.getType()==1){ SlVolumeProductionRkgl slVolumeProductionRkgl = slVolumeProductionRkglMapper.selectById(slAudit.getRkId()); slVolumeProductionRkgl.setAuditStatus(5); ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlAuditServiceImpl.java
@@ -133,6 +133,7 @@ slAuditRecord.setShenhId(byId.getAdministratorId()); slAuditRecord.setType(1); slAuditRecord.setState(1); slAuditRecord.setCreateTime(new Date()); slAuditRecordMapper.insert(slAuditRecord); SlAuditRecord slAuditRecord1=new SlAuditRecord(); @@ -140,6 +141,7 @@ slAuditRecord1.setShenhId(byId.getCompetentId()); slAuditRecord1.setType(2); slAuditRecord1.setState(1); slAuditRecord1.setCreateTime(new Date()); slAuditRecordMapper.insert(slAuditRecord1); SlAuditRecord slAuditRecord2=new SlAuditRecord(); @@ -147,6 +149,7 @@ slAuditRecord2.setShenhId(byId.getDirectorId()); slAuditRecord2.setType(3); slAuditRecord2.setState(1); slAuditRecord2.setCreateTime(new Date()); slAuditRecordMapper.insert(slAuditRecord2); } if (slAudit.getType()==2){ @@ -162,6 +165,7 @@ slAuditRecord.setShenhId(byId.getAdministratorId()); slAuditRecord.setType(1); slAuditRecord.setState(1); slAuditRecord.setCreateTime(new Date()); slAuditRecordMapper.insert(slAuditRecord); SlAuditRecord slAuditRecord1=new SlAuditRecord(); @@ -169,6 +173,7 @@ slAuditRecord1.setShenhId(byId.getCompetentId()); slAuditRecord1.setType(2); slAuditRecord1.setState(1); slAuditRecord1.setCreateTime(new Date()); slAuditRecordMapper.insert(slAuditRecord1); SlAuditRecord slAuditRecord2=new SlAuditRecord(); @@ -176,6 +181,7 @@ slAuditRecord2.setShenhId(byId.getDirectorId()); slAuditRecord2.setType(3); slAuditRecord2.setState(1); slAuditRecord2.setCreateTime(new Date()); slAuditRecordMapper.insert(slAuditRecord2); } if (slAudit.getType()==3){ @@ -191,6 +197,7 @@ slAuditRecord.setShenhId(byId.getAdministratorId()); slAuditRecord.setType(1); slAuditRecord.setState(1); slAuditRecord.setCreateTime(new Date()); slAuditRecordMapper.insert(slAuditRecord); SlAuditRecord slAuditRecord1=new SlAuditRecord(); @@ -198,6 +205,7 @@ slAuditRecord1.setShenhId(byId.getCompetentId()); slAuditRecord1.setType(2); slAuditRecord1.setState(1); slAuditRecord1.setCreateTime(new Date()); slAuditRecordMapper.insert(slAuditRecord1); SlAuditRecord slAuditRecord2=new SlAuditRecord(); @@ -205,6 +213,7 @@ slAuditRecord2.setShenhId(byId.getDirectorId()); slAuditRecord2.setType(3); slAuditRecord2.setState(1); slAuditRecord2.setCreateTime(new Date()); slAuditRecordMapper.insert(slAuditRecord2); } ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlEquipmentServiceImpl.java
@@ -124,24 +124,21 @@ List<Long> arr=new ArrayList<>(); wrapper.eq(SlStoreManagement::getDelFlag,0); wrapper.like(SlStoreManagement::getAdministratorId,seBei.getUserId()); wrapper.eq(SlStoreManagement::getAdministratorId,seBei.getUserId()); List<SlStoreManagement> page = slStoreManagementMapper.selectList(wrapper); for (SlStoreManagement a:page){ arr.add(a.getId()); } LambdaQueryWrapper< SlStoreManagement> wrapper1= Wrappers.lambdaQuery(); wrapper1.eq(SlStoreManagement::getDelFlag,0); wrapper1.like(SlStoreManagement::getCompetentId,seBei.getUserId()); wrapper1.eq(SlStoreManagement::getCompetentId,seBei.getUserId()); List<SlStoreManagement> page1 = slStoreManagementMapper.selectList(wrapper1); for (SlStoreManagement a1:page1){ arr.add(a1.getId()); } LambdaQueryWrapper< SlStoreManagement> wrapper2= Wrappers.lambdaQuery(); wrapper2.eq(SlStoreManagement::getDelFlag,0); wrapper2.like(SlStoreManagement::getDirectorId,seBei.getUserId()); wrapper2.eq(SlStoreManagement::getDirectorId,seBei.getUserId()); List<SlStoreManagement> page2 = slStoreManagementMapper.selectList(wrapper2); for (SlStoreManagement a2:page2){ arr.add(a2.getId()); ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlGoodsMaterialsServiceImpl.java
@@ -121,17 +121,18 @@ SlGoodsMaterialsList = list1.stream().map(SlGoodsMaterials::getId) .collect(Collectors.toSet()); Page<ManagementGoodsMaterials> page = new Page<>(storeManagementGoodSmaterialsQuery.getPageCurr(), storeManagementGoodSmaterialsQuery.getPageSize()); LambdaQueryWrapper< ManagementGoodsMaterials> wrapper= Wrappers.lambdaQuery(); if (!slVolumeProductionIdList.isEmpty()){ wrapper.in(ManagementGoodsMaterials::getManagementId,slVolumeProductionIdList); } // if (!slVolumeProductionIdList.isEmpty()){ // wrapper.in(ManagementGoodsMaterials::getId,slVolumeProductionIdList); // } if (!SlGoodsMaterialsList.isEmpty()){ wrapper.in(ManagementGoodsMaterials::getGoodsMaterialsId,SlGoodsMaterialsList); } wrapper.eq( ManagementGoodsMaterials::getDelFlag,0); wrapper.eq(ManagementGoodsMaterials::getManagementId,storeManagementGoodSmaterialsQuery.getStoreManagementId()); wrapper.orderByDesc(ManagementGoodsMaterials::getCreateTime); Page<ManagementGoodsMaterials> page1 = managementGoodsMaterialsService.page(page, wrapper); PageDTO<StoreManagementGoodSmaterialsVO> storeManagementGoodSmaterialsVOPageDTO = PageDTO.of(page1, StoreManagementGoodSmaterialsVO.class); @@ -143,24 +144,19 @@ li.setIsConsume(byId.getIsConsume()); li.setAveragePrice(storeManagementGoodSmaterialsOne); } return storeManagementGoodSmaterialsVOPageDTO; } @Override public StoreManagementGoodSmaterialsVO getSmaterialsOne(StoreManagementGoodSmaterialsQuery storeManagementGoodSmaterialsQuery) { LambdaQueryWrapper< ManagementGoodsMaterials> wrapper= Wrappers.lambdaQuery(); wrapper.eq(ManagementGoodsMaterials::getGoodsMaterialsId,storeManagementGoodSmaterialsQuery.getGoodsMaterialsId()); wrapper.eq( ManagementGoodsMaterials::getDelFlag,0); wrapper.orderByDesc(ManagementGoodsMaterials::getCreateTime); ManagementGoodsMaterials page1 = managementGoodsMaterialsService.getOne(wrapper); StoreManagementGoodSmaterialsVO storeManagementGoodSmaterialsVO = BeanUtils.copyBean(page1, StoreManagementGoodSmaterialsVO.class); Double storeManagementGoodSmaterialsOne = slVolumeProductionRkMapper.getStoreManagementGoodSmaterialsOne(storeManagementGoodSmaterialsVO.getGoodsMaterialsId()); SlGoodsMaterials byId = this.getById(storeManagementGoodSmaterialsVO.getGoodsMaterialsId()); Double storeManagementGoodSmaterialsOne = slVolumeProductionRkMapper.getStoreManagementGoodSmaterialsOne(storeManagementGoodSmaterialsVO.getGoodsMaterialsId()); SlGoodsMaterials byId = this.getById(storeManagementGoodSmaterialsVO.getGoodsMaterialsId()); storeManagementGoodSmaterialsVO.setGoodsMaterialsName(byId.getGoodsMaterialsName()); storeManagementGoodSmaterialsVO.setIsConsume(byId.getIsConsume()); storeManagementGoodSmaterialsVO.setAveragePrice(storeManagementGoodSmaterialsOne); ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlGoodsShelfServiceImpl.java
@@ -70,7 +70,7 @@ if (StringUtils.hasLength(slGoodsShelfQuery.getGoodsShelfName())){ wrapper1.like(SlGoodsShelf::getGoodsShelfName,slGoodsShelfQuery.getGoodsShelfName()); } if (slGoodsShelfQuery.getStoreManagementNumber()!=null){ if (slGoodsShelfQuery.getStoreManagementNumber()!=null && slGoodsShelfQuery.getStoreManagementNumber()!=0){ wrapper1.eq(SlGoodsShelf::getStoreManagementNumber,slGoodsShelfQuery.getStoreManagementNumber()); } if(slGoodsShelfQuery.getStoreManagementName()!=null&&slGoodsShelfQuery.getStoreManagementName()!="") { ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionCkServiceImpl.java
@@ -1,14 +1,13 @@ 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.PageDTO; import com.ruoyi.management.domain.*; import com.ruoyi.management.domain.dto.AddSlVolumeProductionCkDTO; import com.ruoyi.management.domain.dto.ManagementimgVolumeProductionCkQuery; import com.ruoyi.management.domain.dto.SlGoodsMaterialsSlVolumeProductionRkQuery; import com.ruoyi.management.domain.dto.SlVolumeProductionCkDTO; import com.ruoyi.management.domain.dto.*; import com.ruoyi.management.domain.vo.InventoriesSuppliesInfoVO; import com.ruoyi.management.domain.vo.ManagementimgSlVolumeProductionCkVO; import com.ruoyi.management.domain.vo.ManagementimgVolumeProductionCkVO; import com.ruoyi.management.domain.vo.ManagementimgVolumeProductionRkVO; @@ -16,15 +15,20 @@ import com.ruoyi.management.mapper.SlGoodsShelfMapper; import com.ruoyi.management.mapper.SlVolumeProductionCkMapper; import com.ruoyi.management.mapper.SlVolumeProductionRkMapper; import com.ruoyi.management.service.ManagementGoodsMaterialsService; import com.ruoyi.management.service.SlVolumeProductionCkService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.ruoyi.management.service.SlVolumeProductionRkService; import com.ruoyi.system.api.domain.SysUser; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.util.StringUtils; import javax.annotation.Resource; import java.util.ArrayList; import java.util.Date; import java.util.List; import java.util.stream.Collectors; /** * <p> @@ -45,6 +49,8 @@ @Resource private SlGoodsShelfMapper slGoodsShelfMapper; @Autowired private ManagementGoodsMaterialsService managementGoodsMaterialsService; @Override public PageDTO<ManagementimgSlVolumeProductionCkVO> getManagementimgSlVolumeProductionCkList(SlGoodsMaterialsSlVolumeProductionRkQuery slGoodsMaterialsSlVolumeProductionRkQuery) { @@ -146,4 +152,56 @@ } return SlGoodsShelfDTO; } @Autowired private SlVolumeProductionRkService slVolumeProductionRkService; @Override public PageDTO<InventoriesSuppliesInfoVO> getMaterialByManagementIdList(GetMaterialsByManagementIdQuery query) { List<InventoriesSuppliesInfoVO> res = new ArrayList<>(); Page<SlVolumeProductionRk> page = new Page<>(query.getPageCurr(), query.getPageSize()); QueryWrapper<ManagementGoodsMaterials> wrapper1 = new QueryWrapper<>(); wrapper1.eq("del_flag","0"); wrapper1.eq("management_id",query.getManagementId()); // 获取对应仓库下所有入库的物资ids List<Long> collect = managementGoodsMaterialsService.list(wrapper1).stream().map(ManagementGoodsMaterials::getGoodsMaterialsId).collect(Collectors.toList()); QueryWrapper<SlGoodsMaterials> wrapper2 = new QueryWrapper<>(); if (StringUtils.hasLength(query.getMaterialsName())){ wrapper2.like("goods_materials_name",query.getMaterialsName()); } if (query.getIsConsume()!=null){ wrapper2.eq("is_consume",query.getIsConsume()); } wrapper2.eq("del_flag","0"); wrapper2.in("id",collect); List<Long> collect1 = slGoodsMaterialsMapper.selectList(wrapper2).stream().map(SlGoodsMaterials::getId).collect(Collectors.toList()); QueryWrapper<SlVolumeProductionRk> wrapper = new QueryWrapper<>(); wrapper.in("materials_id",collect1); wrapper.eq("del_flag","0"); Page<SlVolumeProductionRk> page2 = slVolumeProductionRkService.page(page, wrapper); List<SlVolumeProductionRk> list = page2.getRecords(); PageDTO<InventoriesSuppliesInfoVO> slGoodsMaterialsVO = PageDTO.of(page2, InventoriesSuppliesInfoVO.class); for (SlVolumeProductionRk slVolumeProductionRk : list) { SlGoodsMaterials slGoodsMaterials = slGoodsMaterialsMapper.selectById(slVolumeProductionRk.getMaterialsId()); SlGoodsShelf slGoodsShelf = slGoodsShelfMapper.selectById(slVolumeProductionRk.getShelfId()); if (slGoodsMaterials == null || slGoodsShelf == null){ continue; } InventoriesSuppliesInfoVO inventoriesSuppliesInfoVO = new InventoriesSuppliesInfoVO(); inventoriesSuppliesInfoVO.setId(slVolumeProductionRk.getId()); inventoriesSuppliesInfoVO.setGoodsMaterialsName(slGoodsMaterials.getGoodsMaterialsName()); inventoriesSuppliesInfoVO.setIsConsume(slGoodsMaterials.getIsConsume()); inventoriesSuppliesInfoVO.setRkNumber(slVolumeProductionRk.getRkNumber()); inventoriesSuppliesInfoVO.setRkModel(slVolumeProductionRk.getRkModel()); inventoriesSuppliesInfoVO.setRkId(slVolumeProductionRk.getId()); inventoriesSuppliesInfoVO.setZkNum(slVolumeProductionRk.getRepertoryZhai()); inventoriesSuppliesInfoVO.setGoodsShelfName(slGoodsShelf.getGoodsShelfName()); inventoriesSuppliesInfoVO.setStoreManagementNumber(slVolumeProductionRk.getStoreManagementNumber()); res.add(inventoriesSuppliesInfoVO); } slGoodsMaterialsVO.setList(res); return slGoodsMaterialsVO; } } ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionRkServiceImpl.java
@@ -6,10 +6,7 @@ import com.ruoyi.common.core.utils.page.PageDTO; import com.ruoyi.management.domain.*; import com.ruoyi.management.domain.dto.*; import com.ruoyi.management.domain.vo.ManagementimgVolumeProductionRkVO; import com.ruoyi.management.domain.vo.SlGoodsShelfVO; import com.ruoyi.management.domain.vo.getVolumeProductionRkgCodeVO; import com.ruoyi.management.domain.vo.gethuojRkVO; import com.ruoyi.management.domain.vo.*; import com.ruoyi.management.mapper.*; import com.ruoyi.management.service.SlStoreManagementService; import com.ruoyi.management.service.SlVolumeProductionRkService; @@ -21,10 +18,9 @@ import javax.annotation.Resource; import java.math.BigDecimal; import java.util.Date; import java.util.HashSet; import java.util.List; import java.util.Set; import java.sql.Array; import java.text.SimpleDateFormat; import java.util.*; import java.util.stream.Collectors; /** @@ -41,6 +37,8 @@ private SlGoodsMaterialsMapper slGoodsMaterialsMapper; @Resource private SlVolumeProductionRkglMapper slVolumeProductionRkglMapper; @Resource private SlVolumeProductionRkMapper slVolumeProductionRkMapper; @Resource private SlGoodsShelfMapper slGoodsShelfMapper; @@ -105,14 +103,22 @@ for(ManagementimgVolumeProductionRkVO list:list2) {{ SlGoodsMaterials slGoodsMaterials = slGoodsMaterialsMapper.selectById(list.getMaterialsId()); if (slGoodsMaterials!=null){ list.setGoodsMaterialsName(slGoodsMaterials.getGoodsMaterialsName()); list.setIsConsume(slGoodsMaterials.getIsConsume()); } SlVolumeProductionRkgl byId = slVolumeProductionRkglMapper.selectById(list.getVolumeProductionRkglId()); SysUser data = sysUserClient.getSysUser(byId.getSupplierId()).getData(); if (byId!=null){ SysUser data = sysUserClient.getSysUser(byId.getSupplierId()).getData(); list.setSupplierName(data.getNickName()); } list.setGoodsMaterialsName(slGoodsMaterials.getGoodsMaterialsName()); list.setIsConsume(slGoodsMaterials.getIsConsume()); list.setSupplierName(data.getNickName()); SlGoodsShelf slGoodsShelf = slGoodsShelfMapper.selectById(list.getShelfId()); list.setGoodsShelfName(slGoodsShelf.getGoodsShelfName()); if (slGoodsShelf!=null){ list.setGoodsShelfName(slGoodsShelf.getGoodsShelfName()); } } } return SlGoodsShelfDTO; @@ -120,13 +126,13 @@ @Override public void addVolumeProductionRkgl(List<SlVolumeProductionRkListDTO> slVolumeProductionRkListDTO) { SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyyMMddHHmmss"); for (SlVolumeProductionRkListDTO m:slVolumeProductionRkListDTO){ SlVolumeProductionRk slVolumeProductionRk=new SlVolumeProductionRk(); slVolumeProductionRk.setVolumeProductionRkglId(m.getVolumeProductionRkglId()); slVolumeProductionRk.setMaterialsId(m.getMaterialsId()); slVolumeProductionRk.setManagementId(m.getManagementId()); slVolumeProductionRk.setRkNumber("CD-"+new Date().getTime()); slVolumeProductionRk.setRkNumber("CD-"+simpleDateFormat.format(new Date())); slVolumeProductionRk.setNewAddTime(m.getNewAddTime()); if ( m.getErwmNum()!=null){ slVolumeProductionRk.setErwmNum( m.getErwmNum()); @@ -143,7 +149,8 @@ }if ( m.getRkNumber()!=null){ slVolumeProductionRk.setRkNumber( m.getRkNumber()); } slVolumeProductionRk.setCreateTime(new Date()); slVolumeProductionRk.setRepertoryZhai(m.getRkNum()); this.save(slVolumeProductionRk); } @@ -193,22 +200,55 @@ } @Override public ManagementimgVolumeProductionRkVO codeInfo(Long id) { SlVolumeProductionRk byId = this.getById(id); ManagementimgVolumeProductionRkVO vo=new ManagementimgVolumeProductionRkVO(); SlGoodsMaterials slGoodsMaterials = slGoodsMaterialsMapper.selectById(byId.getMaterialsId()); vo.setGoodsMaterialsName(slGoodsMaterials.getGoodsMaterialsName()); vo.setIsConsume(slGoodsMaterials.getIsConsume()); SlVolumeProductionRkgl byId1 = slVolumeProductionRkglMapper.selectById(byId.getVolumeProductionRkglId()); SysUser data = sysUserClient.getSysUser(byId1.getSupplierId()).getData(); vo.setSupplierName(data.getNickName()); SlStoreManagement slStoreManagement = slStoreManagementMapper.selectById(byId.getManagementId()); vo.setStoreManagementName(slStoreManagement.getStoreManagementName()); vo.setRkNum(byId.getRkNum()); vo.setRkNumber(byId.getRkNumber()); return vo; public List<QRCodeVO> codeInfo(Long id) { SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyyMMddHHmmss"); List<QRCodeVO> res = new ArrayList<>(); LambdaQueryWrapper< SlVolumeProductionRk> wrapper1= Wrappers.lambdaQuery(); wrapper1.like(SlVolumeProductionRk::getVolumeProductionRkglId,id); wrapper1.eq( SlVolumeProductionRk::getDelFlag,0); wrapper1.orderByDesc(SlVolumeProductionRk::getCreateTime); List<SlVolumeProductionRk> list = this.list(wrapper1); for (SlVolumeProductionRk byId : list) { // 根据生成二维码数量 复制 for (int i = 0; i < byId.getErwmNum(); i++) { QRCodeVO vo=new QRCodeVO(); String letter = getLetter(i); vo.setCategory(letter); SlGoodsMaterials slGoodsMaterials = slGoodsMaterialsMapper.selectById(byId.getMaterialsId()); vo.setGoodsMaterialsName(slGoodsMaterials.getGoodsMaterialsName()); SlVolumeProductionRkgl byId1 = slVolumeProductionRkglMapper.selectById(byId.getVolumeProductionRkglId()); SysUser data = sysUserClient.getSysUser(byId1.getSupplierId()).getData(); vo.setSupplierName(data.getNickName()); vo.setMaterialsNum(byId.getRkNum()); Long materialsId = byId.getMaterialsId(); // 查询物资缩写 vo.setMaterials(byId.getRkNumber()); SlStoreManagement slStoreManagement = slStoreManagementMapper.selectById(byId.getManagementId()); vo.setStoreManagementName(slStoreManagement.getStoreManagementName()); res.add(vo); } } return res; } // 根据传入数字是几 返回对应的字母 public static String getLetter(int num) { String[] str = {"A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z"}; // 如果num大于26 那么往后叠加对应的字母 if (num > 26) { int a = num / 26; int b = num % 26; if (b == 0) { a = a - 1; b = 26; } return getLetter(a) + getLetter(b); } return str[num - 1]; } @Override public PageDTO<ManagementimgVolumeProductionRkVO> getroductionRkList(umeProductionRkQuery meProductionRkQuery) { @@ -292,7 +332,6 @@ List<gethuojRkVO> list2 = SlGoodsShelfDTO.getList(); for(gethuojRkVO list:list2) { LambdaQueryWrapper<ManagementGoodsMaterials> wrapper2 = Wrappers.lambdaQuery(); wrapper2.eq(ManagementGoodsMaterials::getGoodsMaterialsId,list.getMaterialsId()); wrapper2.eq(ManagementGoodsMaterials::getManagementId,list.getManagementId()); @@ -300,19 +339,29 @@ ManagementGoodsMaterials managementGoodsMaterials = managementGoodsMaterialsMapper.selectOne(wrapper2); if (managementGoodsMaterials != null){ list.setRkPiceSum(list.getRkPice().multiply(new BigDecimal(managementGoodsMaterials.getRepertorySum()))); list.setRepertorySum(managementGoodsMaterials.getRepertorySum()); }else{ list.setRkPiceSum(list.getRkPice().multiply(new BigDecimal(1))); list.setRepertorySum(0L); } list.setRepertorySum(managementGoodsMaterials.getRepertorySum()); SlGoodsMaterials slGoodsMaterials = slGoodsMaterialsMapper.selectById(list.getMaterialsId()); SlVolumeProductionRkgl byId = slVolumeProductionRkglMapper.selectById(list.getVolumeProductionRkglId()); SysUser data = sysUserClient.getSysUser(byId.getSupplierId()).getData(); if (byId!=null){ SysUser data = sysUserClient.getSysUser(byId.getSupplierId()).getData(); list.setSupplierName(data.getNickName()); } list.setGoodsMaterialsName(slGoodsMaterials.getGoodsMaterialsName()); list.setIsConsume(slGoodsMaterials.getIsConsume()); list.setSupplierName(data.getNickName()); if (slGoodsMaterials!=null){ list.setGoodsMaterialsName(slGoodsMaterials.getGoodsMaterialsName()); list.setIsConsume(slGoodsMaterials.getIsConsume()); } SlGoodsShelf slGoodsShelf = slGoodsShelfMapper.selectById(list.getShelfId()); list.setGoodsShelfName(slGoodsShelf.getGoodsShelfName()); if (slGoodsShelf!=null){ list.setGoodsShelfName(slGoodsShelf.getGoodsShelfName()); } } return SlGoodsShelfDTO; } ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionRkglServiceImpl.java
@@ -95,6 +95,7 @@ SysUser data1 = sysUserClient.getSysUser(Long.valueOf(byId.getSysId())).getData(); v.setSysName(data1.getNickName()); v.setSysPhone(data1.getPhonenumber()); v.setAuthorization(byId.getAuthorizationUrl()); return v; } @@ -282,7 +283,8 @@ managementGoodsMaterials1.setGoodsMaterialsId(list.getMaterialsId()); managementGoodsMaterials1.setRepertoryZhai(list.getRkNum()); managementGoodsMaterials1.setRepertorySum(list.getRkNum()); managementGoodsMaterials.setRepertory(slGoodsMaterials.getRepertory()); managementGoodsMaterials1.setCreateTime(new Date()); managementGoodsMaterials1.setRepertory(slGoodsMaterials.getRepertory()); managementGoodsMaterialsMapper.insert(managementGoodsMaterials1); } } ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionZyServiceImpl.java
@@ -1,6 +1,7 @@ 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.PageDTO; @@ -9,14 +10,17 @@ import com.ruoyi.management.domain.dto.ManagementimgVolumeProductionZyVO; import com.ruoyi.management.domain.vo.*; import com.ruoyi.management.mapper.*; import com.ruoyi.management.service.SlStoreManagementService; import com.ruoyi.management.service.SlVolumeProductionZyService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.ruoyi.system.api.domain.SysUser; import com.ruoyi.system.api.domain.getVolumeProductionRkQuery; import com.ruoyi.system.api.feignClient.SysUserClient; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import javax.annotation.Resource; import java.util.ArrayList; import java.util.List; import java.util.Set; import java.util.stream.Collectors; @@ -41,6 +45,8 @@ private SlVolumeProductionZyglMapper slVolumeProductionZyglMapper; @Resource private SlGoodsShelfMapper slGoodsShelfMapper; @Autowired private SlStoreManagementService service; @Override public PageDTO<getVolumeProductionzyCodeVO> getVolumeProductionzyCode(VolumeProductionZygCodeQuery volumeProductionZygCodeQuery) { @@ -107,9 +113,7 @@ @Override public PageDTO<ManagementimgVolumeProductionZyVO> getSlVolumeProductionZyList(ManagementimgVolumeProductionZyQuery managementimgVolumeProductionZyQuery) { SlVolumeProductionZygl slVolumeProductionZygl = slVolumeProductionZyglMapper.selectById(managementimgVolumeProductionZyQuery.getVolumeProductionzyglId()); LambdaQueryWrapper<SlVolumeProductionRk> wrapper2= Wrappers.lambdaQuery(); wrapper2.eq(SlVolumeProductionRk::getManagementId,slVolumeProductionZygl.getBmanagementId()); wrapper2.eq(SlVolumeProductionRk::getStoreManagementNumber,managementimgVolumeProductionZyQuery.getStoreManagementNumber()); @@ -152,4 +156,32 @@ } return SlGoodsShelfDTO; } @Override public NumberAndShelfVO getNumberAndShelfByManagementId(QueryDTO dto) { NumberAndShelfVO numberAndShelfVO = new NumberAndShelfVO(); SlStoreManagement byId = service.getById(dto.getManagementId()); List<String> number = new ArrayList<>(); for (Integer i = 1; i <= byId.getStoreManagementNumber(); i++) { switch (i){ case 1: number.add("一层"); break; case 2: number.add("二层"); break; case 3: number.add("三层"); break; } } numberAndShelfVO.setNumber(number); QueryWrapper<SlGoodsShelf> eq = new QueryWrapper<SlGoodsShelf>() .eq("del_flag", "0") .eq("store_management_id", dto.getManagementId()) .eq("store_management_number",dto.getManagementNumber()); List<SlGoodsShelf> slGoodsShelves = slGoodsShelfMapper.selectList(eq); numberAndShelfVO.setGoodsShelfList(slGoodsShelves); return numberAndShelfVO; } } ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlVolumeProductionZyglServiceImpl.java
@@ -226,6 +226,7 @@ slVolumeProductionRk.setRkNum(Long.valueOf(zy.getZyNum())); slVolumeProductionRk.setShelfId(slVolumeProductionRk1.getShelfId()); slVolumeProductionRk.setRepertoryZhai(Long.valueOf(zy.getZyNum())); slVolumeProductionRk.setCreateTime(new Date()); slVolumeProductionRkMapper.insert(slVolumeProductionRk); zy.setScrkId(slVolumeProductionRk.getId()); @@ -248,6 +249,7 @@ managementGoodsMaterials1.setGoodsMaterialsId(slVolumeProductionRk1.getMaterialsId()); managementGoodsMaterials1.setRepertoryZhai(Long.valueOf(zy.getZyNum())); managementGoodsMaterials1.setRepertorySum(Long.valueOf(zy.getZyNum())); managementGoodsMaterials1.setCreateTime(new Date()); managementGoodsMaterialsMapper.insert(managementGoodsMaterials1); } ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/controller/SysUserController.java
@@ -160,7 +160,7 @@ ajax.put("roleId", sysUser.getRoleId()); ajax.put("roleName", sysUser.getRoleName()); } return AjaxResult.success(ajax); return ajax; } ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/mapper/SysUserMapper.java
@@ -137,4 +137,6 @@ List<Long> getSysUserFromPhone(@Param("phoneNumber") String phoneNumber); void deleteSysUser(@Param("userIds") ArrayList<Integer> userIds); void updateHandle(@Param("req") SysUser user); } ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysUserServiceImpl.java
@@ -1,6 +1,7 @@ package com.ruoyi.system.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.baomidou.mybatisplus.extension.service.impl.ServiceImpl; @@ -682,7 +683,10 @@ @Override public List<SysUser> getConservatorPage1() { List<SysUser> page1 = this.list(); QueryWrapper<SysUser> sysUserQueryWrapper = new QueryWrapper<>(); sysUserQueryWrapper.eq("del_flag",0); sysUserQueryWrapper.eq("user_type","03"); List<SysUser> page1 = this.list(sysUserQueryWrapper); return page1; } @@ -693,12 +697,10 @@ // 添加 if (StringUtils.isNull(dto.getUserId())) { boolean b = checkPhoneUnique(user); if (!b) { throw new ServiceException("该手机号已存在"); } user.setNickName(dto.getNickName()); user.setUserName(dto.getPhonenumber()); user.setUserType("03"); @@ -727,10 +729,20 @@ user.setUpdateTime(new Date()); user.setUpdateBy(SecurityUtils.getUsername()); user.setRoleType(dto.getRoleType()); this.updateById(user); user.setProvinceCode(dto.getProvinceCode()); user.setCityCode(dto.getCityCode()); user.setCountyCode(dto.getCountyCode()); user.setTownCode(dto.getTownCode()); user.setProvinceName(dto.getProvinceName()); user.setCityName(dto.getCityName()); user.setCountyName(dto.getCountyName()); user.setTownName(dto.getTownName()); userMapper.updateHandle(user); } } @Override public void deleteConservator(Long id) { this.lambdaUpdate().set(SysUser::getDelFlag, "2").eq(SysUser::getUserId, id).update(); ruoyi-modules/ruoyi-system/src/main/resources/mapper/system/SysUserMapper.xml
@@ -272,8 +272,28 @@ <update id="resetUserPwd" parameterType="com.ruoyi.system.api.domain.SysUser"> update sys_user set password = #{password} where user_name = #{userName} </update> <delete id="deleteUserById" parameterType="Long"> <update id="updateHandle"> update sys_user <set> dept_id = #{req.deptId}, user_name = #{req.userName}, nick_name = #{req.nickName}, phonenumber = #{req.phonenumber}, roleType = #{req.roleType}, province_name = #{req.provinceName}, province_code = #{req.provinceCode}, city_name = #{req.cityName}, city_code = #{req.cityCode}, county_name = #{req.countyName}, county_code = #{req.countyCode}, town_name = #{req.townName}, town_code = #{req.townCode}, </set> where user_id = #{req.userId} </update> <delete id="deleteUserById" parameterType="Long"> update sys_user set del_flag = '2' where user_id = #{userId} </delete>