From 179c9d6b6a98292e4e2bec9a01c620d38d13c54a Mon Sep 17 00:00:00 2001
From: zss <zss@example.com>
Date: 星期六, 05 七月 2025 16:37:17 +0800
Subject: [PATCH] 质量不合格添加productId字段+删除库存模块代码
---
/dev/null | 67 ---------------------------------
src/main/java/com/ruoyi/quality/pojo/QualityUnqualified.java | 5 ++
2 files changed, 5 insertions(+), 67 deletions(-)
diff --git a/src/main/java/com/ruoyi/inventory/controller/StockInController.java b/src/main/java/com/ruoyi/inventory/controller/StockInController.java
deleted file mode 100644
index 3f01298..0000000
--- a/src/main/java/com/ruoyi/inventory/controller/StockInController.java
+++ /dev/null
@@ -1,64 +0,0 @@
-package com.ruoyi.inventory.controller;
-
-import com.ruoyi.common.utils.poi.ExcelUtil;
-import com.ruoyi.framework.web.controller.BaseController;
-import com.ruoyi.framework.web.domain.AjaxResult;
-import com.ruoyi.inventory.service.StockInService;
-import com.ruoyi.inventory.pojo.StockIn;
-import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.web.bind.annotation.*;
-
-import java.util.List;
-
-@RestController
-@RequestMapping("/stockin")
-public class StockInController extends BaseController {
- @Autowired
- private StockInService stockInService;
-
- @PostMapping("/add")// 鏂板鍏ュ簱璁板綍
- public AjaxResult addStockIn(@RequestBody StockIn stockIn) {
- int i = stockInService.addStockIn(stockIn);
- if(i>0){
- return success();
- }
- return error();
- }
- @GetMapping("/list")// 鍒楀嚭鎵�鏈夊叆搴撹褰�
- public AjaxResult listStockIns() {
- List<StockIn> stockIns = stockInService.listStockIns();
- return success(stockIns);
- }
- @GetMapping("/{id}")// 鏍规嵁ID鑾峰彇鍏ュ簱璁板綍
- public AjaxResult getStockInById(@PathVariable Long id) {
- StockIn stockIn = stockInService.getStockInById(id);
- return success(stockIn);
- }
- @PutMapping("/update")// 鏇存柊鍏ュ簱璁板綍
- public AjaxResult updateStockIn(@RequestBody StockIn stockIn) {
- int i = stockInService.updateStockIn(stockIn);
- if(i>0){
- return success();
- }
- return error();
- }
- @DeleteMapping("/delete/{id}")// 鍒犻櫎鍏ュ簱璁板綍
- public AjaxResult deleteStockIn(@PathVariable Long id) {
- int i = stockInService.deleteStockIn(id);
- if(i>0){
- return success();
- }
- return error();
- }
-// @Log(title = "宀椾綅绠＄悊", businessType = BusinessType.EXPORT)
-// @PreAuthorize("@ss.hasPermi('system:post:export')")
- @GetMapping("/export")// 瀵煎嚭鍏ュ簱鏁版嵁
- public AjaxResult exportStockInData() {
- List<StockIn> stockIns = stockInService.listStockIns();
- ExcelUtil<StockIn> util = new ExcelUtil<StockIn>(StockIn.class);
- util.exportExcel(stockIns, "搴撳瓨鍏ュ簱淇℃伅");
- return success();
- }
-
-
-}
diff --git a/src/main/java/com/ruoyi/inventory/controller/StockManagementController.java b/src/main/java/com/ruoyi/inventory/controller/StockManagementController.java
deleted file mode 100644
index c8084e2..0000000
--- a/src/main/java/com/ruoyi/inventory/controller/StockManagementController.java
+++ /dev/null
@@ -1,54 +0,0 @@
-package com.ruoyi.inventory.controller;
-
-import com.ruoyi.framework.web.domain.AjaxResult;
-import com.ruoyi.inventory.pojo.StockManagement;
-import com.ruoyi.inventory.service.StockManagementService;
-import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.web.bind.annotation.*;
-
-import java.util.List;
-
-import static com.ruoyi.framework.web.domain.AjaxResult.error;
-import static com.ruoyi.framework.web.domain.AjaxResult.success;
-
-@RestController
-@RequestMapping("/stockmanagement")
-public class StockManagementController {
- @Autowired
- private StockManagementService stockManagementService;
- @RequestMapping("/list")// 鍒楀嚭鎵�鏈夊嚭搴撹褰�
- public AjaxResult listStockOuts() {
- List<StockManagement> stockManagements = stockManagementService.getStockManagements();
- return success(stockManagements);
- }
- @GetMapping("/{id}")// 鏍规嵁ID鑾峰彇鍑哄簱璁板綍
- public AjaxResult getStockOutById(@PathVariable Long id) {
- StockManagement stockManagement = stockManagementService.getStockManagementById(id);
- return success(stockManagement);
- }
- @PostMapping("add")// 鏂板鍑哄簱璁板綍
- public AjaxResult addStockOut(@RequestBody StockManagement stockManagement) {
- int i = stockManagementService.addStockManagement(stockManagement);
- if(i>0){
- return success();
- }
- return error();
- }
- @PutMapping("/update")// 鏇存柊鍑哄簱璁板綍
- public AjaxResult updateStockOut(@RequestBody StockManagement stockManagement) {
- int i = stockManagementService.updateStockManagement(stockManagement);
- if(i>0){
- return success();
- }
- return error();
- }
- @DeleteMapping("/delete/{id}")// 鍒犻櫎鍑哄簱璁板綍
- public AjaxResult deleteStockOut(@PathVariable Long id) {
- int i = stockManagementService.deleteStockManagement(id);
- if(i>0){
- return success();
- }
- return error();
- }
-
-}
diff --git a/src/main/java/com/ruoyi/inventory/controller/StockOutController.java b/src/main/java/com/ruoyi/inventory/controller/StockOutController.java
deleted file mode 100644
index d0457fd..0000000
--- a/src/main/java/com/ruoyi/inventory/controller/StockOutController.java
+++ /dev/null
@@ -1,56 +0,0 @@
-package com.ruoyi.inventory.controller;
-
-import com.ruoyi.framework.web.controller.BaseController;
-import com.ruoyi.framework.web.domain.AjaxResult;
-import com.ruoyi.inventory.mapper.StockManagementMapper;
-import com.ruoyi.inventory.pojo.StockOut;
-import com.ruoyi.inventory.service.StockOutService;
-import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.web.bind.annotation.*;
-
-import java.util.List;
-
-
-@RestController
-@RequestMapping("/stockout")
-public class StockOutController extends BaseController {
- @Autowired
- private StockOutService stockOutService;
- @Autowired
- private StockManagementMapper stockManagementMapper;
-
- @RequestMapping("/add")
- public AjaxResult addStockOut(StockOut stockOut) {
- int i = stockOutService.addStockOut(stockOut);
- if(i>0){
- return success();
- }
- return error();
- }
- @RequestMapping("/list")
- public AjaxResult listStockOuts() {
- List<StockOut> stockOuts = stockOutService.getStockOuts();
- return success(stockOuts);
- }
- @RequestMapping("/{id}")
- public AjaxResult getStockOutById(@PathVariable Long id) {
- StockOut stockOut = stockOutService.getStockOutById(id);
- return success(stockOut);
- }
- @RequestMapping("/update")
- public AjaxResult updateStockOut(@RequestBody StockOut stockOut) {
- int i = stockOutService.updateStockOut(stockOut);
- if(i>0){
- return success();
- }
- return error();
- }
- @RequestMapping("/delete/{id}")
- public AjaxResult deleteStockOut(Long id) {
- int i = stockOutService.deleteStockOut(id);
- if(i>0){
- return success();
- }
- return error();
- }
-}
diff --git a/src/main/java/com/ruoyi/inventory/mapper/StockInMapper.java b/src/main/java/com/ruoyi/inventory/mapper/StockInMapper.java
deleted file mode 100644
index 0412c6e..0000000
--- a/src/main/java/com/ruoyi/inventory/mapper/StockInMapper.java
+++ /dev/null
@@ -1,25 +0,0 @@
-package com.ruoyi.inventory.mapper;
-
-import com.ruoyi.inventory.pojo.StockIn;
-
-import java.util.List;
-
-/**
-* @author 86151
-* @description 閽堝琛ㄣ�恠tock_in銆戠殑鏁版嵁搴撴搷浣淢apper
-* @createDate 2025-06-23 18:11:59
-* @Entity inventory.domain.StockIn
-*/
-public interface StockInMapper {
-
- int deleteByPrimaryKey(Long id);
-
- int insertSelective(StockIn record);
-
- StockIn selectByPrimaryKey(Long id);
-
- int updateByPrimaryKeySelective(StockIn record);
-
- List<StockIn> selectList();
-
-}
diff --git a/src/main/java/com/ruoyi/inventory/mapper/StockManagementMapper.java b/src/main/java/com/ruoyi/inventory/mapper/StockManagementMapper.java
deleted file mode 100644
index 0d55981..0000000
--- a/src/main/java/com/ruoyi/inventory/mapper/StockManagementMapper.java
+++ /dev/null
@@ -1,25 +0,0 @@
-package com.ruoyi.inventory.mapper;
-
-
-import com.ruoyi.inventory.pojo.StockManagement;
-
-import java.util.List;
-
-/**
-* @author 86151
-* @description 閽堝琛ㄣ�恠tock_management銆戠殑鏁版嵁搴撴搷浣淢apper
-* @createDate 2025-06-23 18:11:59
-* @Entity inventory.domain.StockManagement
-*/
-public interface StockManagementMapper {
- List<StockManagement> selectAll();
- int deleteByPrimaryKey(Long id);
-
- int insertSelective(StockManagement record);
-
- StockManagement selectByPrimaryKey(Long id);
-
- int updateByPrimaryKeySelective(StockManagement record);
-
-
-}
diff --git a/src/main/java/com/ruoyi/inventory/mapper/StockOutMapper.java b/src/main/java/com/ruoyi/inventory/mapper/StockOutMapper.java
deleted file mode 100644
index 91449de..0000000
--- a/src/main/java/com/ruoyi/inventory/mapper/StockOutMapper.java
+++ /dev/null
@@ -1,26 +0,0 @@
-package com.ruoyi.inventory.mapper;
-
-
-import com.ruoyi.inventory.pojo.StockOut;
-
-import java.util.List;
-
-/**
-* @author 86151
-* @description 閽堝琛ㄣ�恠tock_out銆戠殑鏁版嵁搴撴搷浣淢apper
-* @createDate 2025-06-23 18:11:59
-* @Entity inventory.domain.StockOut
-*/
-public interface StockOutMapper {
-
- int deleteByPrimaryKey(Long id);
-
- List<StockOut> selectAll();
- int insertSelective(StockOut record);
-
- StockOut selectByPrimaryKey(Long id);
-
- int updateByPrimaryKeySelective(StockOut record);
-
-
-}
diff --git a/src/main/java/com/ruoyi/inventory/mapper/StockProductMapper.java b/src/main/java/com/ruoyi/inventory/mapper/StockProductMapper.java
deleted file mode 100644
index 357d413..0000000
--- a/src/main/java/com/ruoyi/inventory/mapper/StockProductMapper.java
+++ /dev/null
@@ -1,26 +0,0 @@
-package com.ruoyi.inventory.mapper;
-
-
-
-import com.ruoyi.inventory.pojo.StockProduct;
-
-import java.util.List;
-
-/**
-* @author 86151
-* @description 閽堝琛ㄣ�恠tock_product銆戠殑鏁版嵁搴撴搷浣淢apper
-* @createDate 2025-06-23 18:11:59
-* @Entity inventory.domain.StockProduct
-*/
-public interface StockProductMapper {
- List<StockProduct> selectList();
- int deleteByPrimaryKey(Long id);
-
- int insertSelective(StockProduct record);
-
- StockProduct selectByPrimaryKey(Long id);
-
- int updateByPrimaryKeySelective(StockProduct record);
-
-
-}
diff --git a/src/main/java/com/ruoyi/inventory/pojo/StockIn.java b/src/main/java/com/ruoyi/inventory/pojo/StockIn.java
deleted file mode 100644
index d28cd2e..0000000
--- a/src/main/java/com/ruoyi/inventory/pojo/StockIn.java
+++ /dev/null
@@ -1,73 +0,0 @@
-package com.ruoyi.inventory.pojo;
-
-import java.io.Serializable;
-import java.math.BigDecimal;
-import java.util.Date;
-import java.util.List;
-
-import lombok.Data;
-
-/**
- *
- * @TableName stock_in
- */
-@Data
-public class StockIn implements Serializable {
- /**
- * 鍏ュ簱璁板綍ID
- */
- private Integer id;
-
- /**
- * 浜у搧id
- */
- private Integer productId;
-
- /**
- * 鍏ュ簱鏃堕棿
- */
- private Date inboundTime;
-
- /**
- * 鍏ュ簱鎵规锛堝鈥滅涓夋壒娆♀�濓級
- */
- private String inboundBatch;
-
- /**
- * 渚涘簲鍟嗗悕绉�
- */
- private String supplierName;
-
- /**
- * 鍏ュ簱鏁伴噺
- */
- private Integer inboundQuantity;
-
- /**
- * 鍚◣鍗曚环
- */
- private BigDecimal taxInclusivePrice;
-
- /**
- * 鍚◣鎬讳环
- */
- private BigDecimal taxInclusiveTotal;
-
- /**
- * 绋庣巼
- */
- private BigDecimal taxRate;
-
- /**
- * 涓嶅惈绋庢�讳环
- */
- private BigDecimal taxExclusiveTotal;
-
- /**
- * 鍏ュ簱浜�
- */
- private String inboundPerson;
-
- private static final long serialVersionUID = 1L;
- private List<StockProduct> stockProducts;
-}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/inventory/pojo/StockManagement.java b/src/main/java/com/ruoyi/inventory/pojo/StockManagement.java
deleted file mode 100644
index 640fe57..0000000
--- a/src/main/java/com/ruoyi/inventory/pojo/StockManagement.java
+++ /dev/null
@@ -1,54 +0,0 @@
-package com.ruoyi.inventory.pojo;
-
-import java.io.Serializable;
-import java.math.BigDecimal;
-import lombok.Data;
-
-/**
- *
- * @TableName stock_management
- */
-@Data
-public class StockManagement implements Serializable {
- /**
- * 搴撳瓨璁板綍ID
- */
- private Integer id;
-
- /**
- * 浜у搧id
- */
- private Integer productId;
-
- /**
- * 褰撳墠搴撳瓨閲�
- */
- private Integer stockQuantity;
-
- /**
- * 鍚◣鍗曚环
- */
- private BigDecimal taxInclusivePrice;
-
- /**
- * 鍚◣鎬讳环
- */
- private BigDecimal taxInclusiveTotal;
-
- /**
- * 绋庣巼
- */
- private BigDecimal taxRate;
-
- /**
- * 涓嶅惈绋庢�讳环
- */
- private BigDecimal taxExclusiveTotal;
-
- /**
- * 鍏ュ簱浜�
- */
- private String inboundPerson;
-
- private static final long serialVersionUID = 1L;
-}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/inventory/pojo/StockOut.java b/src/main/java/com/ruoyi/inventory/pojo/StockOut.java
deleted file mode 100644
index acb735b..0000000
--- a/src/main/java/com/ruoyi/inventory/pojo/StockOut.java
+++ /dev/null
@@ -1,70 +0,0 @@
-package com.ruoyi.inventory.pojo;
-
-import java.io.Serializable;
-import java.math.BigDecimal;
-import java.util.Date;
-import lombok.Data;
-
-/**
- *
- * @TableName stock_out
- */
-@Data
-public class StockOut implements Serializable {
- /**
- * 鍑哄簱璁板綍ID
- */
- private Integer id;
-
- /**
- * 浜у搧id
- */
- private Integer productId;
-
- /**
- * 鍑哄簱鏃堕棿
- */
- private Date inboundTime;
-
- /**
- * 鍑哄簱鎵规锛堝鈥滅涓夋壒娆♀�濓級
- */
- private String inboundBatch;
-
- /**
- * 渚涘簲鍟嗗悕绉�
- */
- private String supplierName;
-
- /**
- * 鍏ュ簱鏁伴噺
- */
- private Integer inboundQuantity;
-
- /**
- * 鍚◣鍗曚环
- */
- private BigDecimal taxInclusivePrice;
-
- /**
- * 鍚◣鎬讳环
- */
- private BigDecimal taxInclusiveTotal;
-
- /**
- * 绋庣巼
- */
- private BigDecimal taxRate;
-
- /**
- * 涓嶅惈绋庢�讳环
- */
- private BigDecimal taxExclusiveTotal;
-
- /**
- * 鍑哄簱浜�
- */
- private String inboundPerson;
-
- private static final long serialVersionUID = 1L;
-}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/inventory/pojo/StockProduct.java b/src/main/java/com/ruoyi/inventory/pojo/StockProduct.java
deleted file mode 100644
index f897913..0000000
--- a/src/main/java/com/ruoyi/inventory/pojo/StockProduct.java
+++ /dev/null
@@ -1,33 +0,0 @@
-package com.ruoyi.inventory.pojo;
-
-import java.io.Serializable;
-import lombok.Data;
-
-/**
- *
- * @TableName stock_product
- */
-@Data
-public class StockProduct implements Serializable {
- /**
- * 浜у搧ID
- */
- private Integer id;
-
- /**
- * 浜у搧澶х被锛堝鈥滀骇鍝�1鈥濓級
- */
- private String productCategory;
-
- /**
- * 瑙勬牸鍨嬪彿
- */
- private String specModel;
-
- /**
- * 鍗曚綅锛堝鈥滃惃鈥濓級
- */
- private String unit;
-
- private static final long serialVersionUID = 1L;
-}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/inventory/service/StockInService.java b/src/main/java/com/ruoyi/inventory/service/StockInService.java
deleted file mode 100644
index 7b7f7a9..0000000
--- a/src/main/java/com/ruoyi/inventory/service/StockInService.java
+++ /dev/null
@@ -1,21 +0,0 @@
-package com.ruoyi.inventory.service;
-
-import com.ruoyi.inventory.pojo.StockIn;
-
-
-import java.util.List;
-
-
-public interface StockInService {
- int addStockIn(StockIn stockIn);
-
- List<StockIn> listStockIns();
-
- StockIn getStockInById(Long id);
-
- int updateStockIn(StockIn stockIn);
-
- int deleteStockIn(Long id);
-
-
-}
diff --git a/src/main/java/com/ruoyi/inventory/service/StockManagementService.java b/src/main/java/com/ruoyi/inventory/service/StockManagementService.java
deleted file mode 100644
index 6f8fe06..0000000
--- a/src/main/java/com/ruoyi/inventory/service/StockManagementService.java
+++ /dev/null
@@ -1,14 +0,0 @@
-package com.ruoyi.inventory.service;
-
-import com.ruoyi.inventory.pojo.StockManagement;
-
-import java.util.List;
-
-
-public interface StockManagementService {
- List<StockManagement> getStockManagements();
- StockManagement getStockManagementById(Long id);
- int addStockManagement(StockManagement stockManagement);
- int updateStockManagement(StockManagement stockManagement);
- int deleteStockManagement(Long id);
-}
diff --git a/src/main/java/com/ruoyi/inventory/service/StockOutService.java b/src/main/java/com/ruoyi/inventory/service/StockOutService.java
deleted file mode 100644
index 9be4b97..0000000
--- a/src/main/java/com/ruoyi/inventory/service/StockOutService.java
+++ /dev/null
@@ -1,13 +0,0 @@
-package com.ruoyi.inventory.service;
-
-import com.ruoyi.inventory.pojo.StockOut;
-
-import java.util.List;
-
-public interface StockOutService {
- List<StockOut> getStockOuts();
- StockOut getStockOutById(Long id);
- int addStockOut(StockOut stockOut);
- int updateStockOut(StockOut stockOut);
- int deleteStockOut(Long id);
-}
diff --git a/src/main/java/com/ruoyi/inventory/service/impl/StockInServiceImpl.java b/src/main/java/com/ruoyi/inventory/service/impl/StockInServiceImpl.java
deleted file mode 100644
index c215d2a..0000000
--- a/src/main/java/com/ruoyi/inventory/service/impl/StockInServiceImpl.java
+++ /dev/null
@@ -1,45 +0,0 @@
-package com.ruoyi.inventory.service.impl;
-
-import com.ruoyi.inventory.pojo.StockIn;
-import com.ruoyi.inventory.mapper.StockInMapper;
-import com.ruoyi.inventory.service.StockInService;
-import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.stereotype.Service;
-
-import java.util.List;
-@Service
-public class StockInServiceImpl implements StockInService {
- @Autowired
- private StockInMapper stockInMapper;
-
- @Override//娣诲姞搴撳瓨鍏ュ簱淇℃伅
- public int addStockIn(StockIn stockIn) {
- int i = stockInMapper.insertSelective(stockIn);
- return i;
- }
-
- @Override//鍒楀嚭鎵�鏈夊簱瀛樺叆搴撲俊鎭�
- public List<StockIn> listStockIns() {
- List<StockIn> stockIns = stockInMapper.selectList();
- return stockIns;
- }
-
- @Override//鏍规嵁id鑾峰彇搴撳瓨鍏ュ簱淇℃伅
- public StockIn getStockInById(Long id) {
- StockIn stockIn = stockInMapper.selectByPrimaryKey(id);
- return stockIn;
- }
-
- @Override//鏇存柊搴撳瓨鍏ュ簱淇℃伅
- public int updateStockIn(StockIn stockIn) {
- int i = stockInMapper.updateByPrimaryKeySelective(stockIn);
- return i;
- }
-
- @Override//鍒犻櫎搴撳瓨鍏ュ簱淇℃伅
- public int deleteStockIn(Long id) {
- int i = stockInMapper.deleteByPrimaryKey(id);
- return i;
- }
-
-}
diff --git a/src/main/java/com/ruoyi/inventory/service/impl/StockManagementServiceImpl.java b/src/main/java/com/ruoyi/inventory/service/impl/StockManagementServiceImpl.java
deleted file mode 100644
index 1c5d1e2..0000000
--- a/src/main/java/com/ruoyi/inventory/service/impl/StockManagementServiceImpl.java
+++ /dev/null
@@ -1,45 +0,0 @@
-package com.ruoyi.inventory.service.impl;
-
-import com.ruoyi.inventory.mapper.StockManagementMapper;
-import com.ruoyi.inventory.pojo.StockManagement;
-import com.ruoyi.inventory.service.StockManagementService;
-import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.stereotype.Service;
-
-import java.util.List;
-
-@Service
-public class StockManagementServiceImpl implements StockManagementService {
- @Autowired
- private StockManagementMapper stockManagementMapper;
-
- @Override
- public List<StockManagement> getStockManagements() {
- List<StockManagement> stockManagements = stockManagementMapper.selectAll();
- return stockManagements;
- }
-
- @Override
- public StockManagement getStockManagementById(Long id) {
- StockManagement stockManagement = stockManagementMapper.selectByPrimaryKey(id);
- return stockManagement;
- }
-
- @Override
- public int addStockManagement(StockManagement stockManagement) {
- int i = stockManagementMapper.insertSelective(stockManagement);
- return i;
- }
-
- @Override
- public int updateStockManagement(StockManagement stockManagement) {
- int i = stockManagementMapper.updateByPrimaryKeySelective(stockManagement);
- return i;
- }
-
- @Override
- public int deleteStockManagement(Long id) {
- int i = stockManagementMapper.deleteByPrimaryKey(id);
- return i;
- }
-}
diff --git a/src/main/java/com/ruoyi/inventory/service/impl/StockOutServiceImpl.java b/src/main/java/com/ruoyi/inventory/service/impl/StockOutServiceImpl.java
deleted file mode 100644
index ff084b9..0000000
--- a/src/main/java/com/ruoyi/inventory/service/impl/StockOutServiceImpl.java
+++ /dev/null
@@ -1,46 +0,0 @@
-package com.ruoyi.inventory.service.impl;
-
-import com.ruoyi.inventory.mapper.StockOutMapper;
-import com.ruoyi.inventory.pojo.StockOut;
-import com.ruoyi.inventory.service.StockOutService;
-
-import lombok.AllArgsConstructor;
-import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.stereotype.Service;
-
-import java.util.List;
-
-@Service
-public class StockOutServiceImpl implements StockOutService {
- @Autowired
- private StockOutMapper stockOutMapper;
- @Override
- public List<StockOut> getStockOuts() {
- List<StockOut> stockOuts = stockOutMapper.selectAll();
- return stockOuts;
- }
-
- @Override
- public StockOut getStockOutById(Long id) {
- StockOut stockOut = stockOutMapper.selectByPrimaryKey(id);
- return stockOut;
- }
-
- @Override
- public int addStockOut(StockOut stockOut) {
- int i = stockOutMapper.insertSelective(stockOut);
- return i;
- }
-
- @Override
- public int updateStockOut(StockOut stockOut) {
- int i = stockOutMapper.updateByPrimaryKeySelective(stockOut);
- return i;
- }
-
- @Override
- public int deleteStockOut(Long id) {
- int i = stockOutMapper.deleteByPrimaryKey(id);
- return i;
- }
-}
diff --git a/src/main/java/com/ruoyi/quality/pojo/QualityUnqualified.java b/src/main/java/com/ruoyi/quality/pojo/QualityUnqualified.java
index e26d014..2479add 100644
--- a/src/main/java/com/ruoyi/quality/pojo/QualityUnqualified.java
+++ b/src/main/java/com/ruoyi/quality/pojo/QualityUnqualified.java
@@ -57,6 +57,11 @@
private String checkName;
/**
+ * 鍏宠仈浜у搧id
+ */
+ private Long productId;
+
+ /**
* 浜у搧鍚嶇О
*/
@Excel(name = "浜у搧鍚嶇О")
diff --git a/src/main/resources/mapper/inventory/StockInMapper.xml b/src/main/resources/mapper/inventory/StockInMapper.xml
deleted file mode 100644
index 223d083..0000000
--- a/src/main/resources/mapper/inventory/StockInMapper.xml
+++ /dev/null
@@ -1,122 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<!DOCTYPE mapper
- PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
- "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
-<mapper namespace="com.ruoyi.inventory.mapper.StockInMapper">
-
- <resultMap id="BaseResultMap" type="com.ruoyi.inventory.pojo.StockIn">
- <id property="id" column="id" jdbcType="INTEGER"/>
- <result property="productId" column="product_id" jdbcType="INTEGER"/>
- <result property="inboundTime" column="inbound_time" jdbcType="TIMESTAMP"/>
- <result property="inboundBatch" column="inbound_batch" jdbcType="VARCHAR"/>
- <result property="supplierName" column="supplier_name" jdbcType="VARCHAR"/>
- <result property="inboundQuantity" column="inbound_quantity" jdbcType="INTEGER"/>
- <result property="taxInclusivePrice" column="tax_inclusive_price" jdbcType="DECIMAL"/>
- <result property="taxInclusiveTotal" column="tax_inclusive_total" jdbcType="DECIMAL"/>
- <result property="taxRate" column="tax_rate" jdbcType="DECIMAL"/>
- <result property="taxExclusiveTotal" column="tax_exclusive_total" jdbcType="DECIMAL"/>
- <result property="inboundPerson" column="inbound_person" jdbcType="VARCHAR"/>
- <collection property="stockProducts" ofType="com.ruoyi.inventory.pojo.StockProduct"
- select="com.ruoyi.inventory.mapper.StockProductMapper.selectByPrimaryKey" column="productId">
- <id property="id" column="productId" jdbcType="INTEGER"/>
- </collection>
- </resultMap>
-
- <sql id="Base_Column_List">
- id,product_id,inbound_time,
- inbound_batch,supplier_name,inbound_quantity,
- tax_inclusive_price,tax_inclusive_total,tax_rate,
- tax_exclusive_total,inbound_person
- </sql>
-
- <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap">
- select
- <include refid="Base_Column_List" />
- from stock_in
- where id = #{id,jdbcType=INTEGER}
- </select>
- <select id="selectList" resultType="com.ruoyi.inventory.pojo.StockIn">
- select
- <include refid="Base_Column_List" />
- from stock_in
- </select>
- <select id="selectListByPage" resultType="com.ruoyi.inventory.pojo.StockIn">
- select
- <include refid="Base_Column_List" />
- from stock_in
- limit #{pageNum},#{pageSize}
- </select>
-
- <delete id="deleteByPrimaryKey" parameterType="java.lang.Long">
- delete from stock_in
- where id = #{id,jdbcType=INTEGER}
- </delete>
-
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.ruoyi.inventory.pojo.StockIn" useGeneratedKeys="true">
- insert into stock_in
- <trim prefix="(" suffix=")" suffixOverrides=",">
- <if test="id != null">id,</if>
- <if test="productId != null">product_id,</if>
- <if test="inboundTime != null">inbound_time,</if>
- <if test="inboundBatch != null">inbound_batch,</if>
- <if test="supplierName != null">supplier_name,</if>
- <if test="inboundQuantity != null">inbound_quantity,</if>
- <if test="taxInclusivePrice != null">tax_inclusive_price,</if>
- <if test="taxInclusiveTotal != null">tax_inclusive_total,</if>
- <if test="taxRate != null">tax_rate,</if>
- <if test="taxExclusiveTotal != null">tax_exclusive_total,</if>
- <if test="inboundPerson != null">inbound_person,</if>
- </trim>
- <trim prefix="values (" suffix=")" suffixOverrides=",">
- <if test="id != null">#{id,jdbcType=INTEGER},</if>
- <if test="productId != null">#{productId,jdbcType=INTEGER},</if>
- <if test="inboundTime != null">#{inboundTime,jdbcType=TIMESTAMP},</if>
- <if test="inboundBatch != null">#{inboundBatch,jdbcType=VARCHAR},</if>
- <if test="supplierName != null">#{supplierName,jdbcType=VARCHAR},</if>
- <if test="inboundQuantity != null">#{inboundQuantity,jdbcType=INTEGER},</if>
- <if test="taxInclusivePrice != null">#{taxInclusivePrice,jdbcType=DECIMAL},</if>
- <if test="taxInclusiveTotal != null">#{taxInclusiveTotal,jdbcType=DECIMAL},</if>
- <if test="taxRate != null">#{taxRate,jdbcType=DECIMAL},</if>
- <if test="taxExclusiveTotal != null">#{taxExclusiveTotal,jdbcType=DECIMAL},</if>
- <if test="inboundPerson != null">#{inboundPerson,jdbcType=VARCHAR},</if>
- </trim>
- </insert>
-
- <update id="updateByPrimaryKeySelective" parameterType="com.ruoyi.inventory.pojo.StockIn">
- update stock_in
- <set>
- <if test="productId != null">
- product_id = #{productId,jdbcType=INTEGER},
- </if>
- <if test="inboundTime != null">
- inbound_time = #{inboundTime,jdbcType=TIMESTAMP},
- </if>
- <if test="inboundBatch != null">
- inbound_batch = #{inboundBatch,jdbcType=VARCHAR},
- </if>
- <if test="supplierName != null">
- supplier_name = #{supplierName,jdbcType=VARCHAR},
- </if>
- <if test="inboundQuantity != null">
- inbound_quantity = #{inboundQuantity,jdbcType=INTEGER},
- </if>
- <if test="taxInclusivePrice != null">
- tax_inclusive_price = #{taxInclusivePrice,jdbcType=DECIMAL},
- </if>
- <if test="taxInclusiveTotal != null">
- tax_inclusive_total = #{taxInclusiveTotal,jdbcType=DECIMAL},
- </if>
- <if test="taxRate != null">
- tax_rate = #{taxRate,jdbcType=DECIMAL},
- </if>
- <if test="taxExclusiveTotal != null">
- tax_exclusive_total = #{taxExclusiveTotal,jdbcType=DECIMAL},
- </if>
- <if test="inboundPerson != null">
- inbound_person = #{inboundPerson,jdbcType=VARCHAR},
- </if>
- </set>
- where id = #{id,jdbcType=INTEGER}
- </update>
-
-</mapper>
diff --git a/src/main/resources/mapper/inventory/StockManagementMapper.xml b/src/main/resources/mapper/inventory/StockManagementMapper.xml
deleted file mode 100644
index f46d1e2..0000000
--- a/src/main/resources/mapper/inventory/StockManagementMapper.xml
+++ /dev/null
@@ -1,92 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<!DOCTYPE mapper
- PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
- "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
-<mapper namespace="com.ruoyi.inventory.mapper.StockManagementMapper">
-
- <resultMap id="BaseResultMap" type="com.ruoyi.inventory.pojo.StockManagement">
- <id property="id" column="id" jdbcType="INTEGER"/>
- <result property="productId" column="product_id" jdbcType="INTEGER"/>
- <result property="stockQuantity" column="stock_quantity" jdbcType="INTEGER"/>
- <result property="taxInclusivePrice" column="tax_inclusive_price" jdbcType="DECIMAL"/>
- <result property="taxInclusiveTotal" column="tax_inclusive_total" jdbcType="DECIMAL"/>
- <result property="taxRate" column="tax_rate" jdbcType="DECIMAL"/>
- <result property="taxExclusiveTotal" column="tax_exclusive_total" jdbcType="DECIMAL"/>
- <result property="inboundPerson" column="inbound_person" jdbcType="VARCHAR"/>
- </resultMap>
-
- <sql id="Base_Column_List">
- id,product_id,stock_quantity,
- tax_inclusive_price,tax_inclusive_total,tax_rate,
- tax_exclusive_total,inbound_person
- </sql>
-
- <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap">
- select
- <include refid="Base_Column_List" />
- from stock_management
- where id = #{id,jdbcType=INTEGER}
- </select>
- <select id="selectAll" resultType="com.ruoyi.inventory.pojo.StockManagement">
- select
- <include refid="Base_Column_List" />
- from stock_management
- </select>
-
- <delete id="deleteByPrimaryKey" parameterType="java.lang.Long">
- delete from stock_management
- where id = #{id,jdbcType=INTEGER}
- </delete>
-
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.ruoyi.inventory.pojo.StockManagement" useGeneratedKeys="true">
- insert into stock_management
- <trim prefix="(" suffix=")" suffixOverrides=",">
- <if test="id != null">id,</if>
- <if test="productId != null">product_id,</if>
- <if test="stockQuantity != null">stock_quantity,</if>
- <if test="taxInclusivePrice != null">tax_inclusive_price,</if>
- <if test="taxInclusiveTotal != null">tax_inclusive_total,</if>
- <if test="taxRate != null">tax_rate,</if>
- <if test="taxExclusiveTotal != null">tax_exclusive_total,</if>
- <if test="inboundPerson != null">inbound_person,</if>
- </trim>
- <trim prefix="values (" suffix=")" suffixOverrides=",">
- <if test="id != null">#{id,jdbcType=INTEGER},</if>
- <if test="productId != null">#{productId,jdbcType=INTEGER},</if>
- <if test="stockQuantity != null">#{stockQuantity,jdbcType=INTEGER},</if>
- <if test="taxInclusivePrice != null">#{taxInclusivePrice,jdbcType=DECIMAL},</if>
- <if test="taxInclusiveTotal != null">#{taxInclusiveTotal,jdbcType=DECIMAL},</if>
- <if test="taxRate != null">#{taxRate,jdbcType=DECIMAL},</if>
- <if test="taxExclusiveTotal != null">#{taxExclusiveTotal,jdbcType=DECIMAL},</if>
- <if test="inboundPerson != null">#{inboundPerson,jdbcType=VARCHAR},</if>
- </trim>
- </insert>
- <update id="updateByPrimaryKeySelective" parameterType="com.ruoyi.inventory.pojo.StockManagement">
- update stock_management
- <set>
- <if test="productId != null">
- product_id = #{productId,jdbcType=INTEGER},
- </if>
- <if test="stockQuantity != null">
- stock_quantity = #{stockQuantity,jdbcType=INTEGER},
- </if>
- <if test="taxInclusivePrice != null">
- tax_inclusive_price = #{taxInclusivePrice,jdbcType=DECIMAL},
- </if>
- <if test="taxInclusiveTotal != null">
- tax_inclusive_total = #{taxInclusiveTotal,jdbcType=DECIMAL},
- </if>
- <if test="taxRate != null">
- tax_rate = #{taxRate,jdbcType=DECIMAL},
- </if>
- <if test="taxExclusiveTotal != null">
- tax_exclusive_total = #{taxExclusiveTotal,jdbcType=DECIMAL},
- </if>
- <if test="inboundPerson != null">
- inbound_person = #{inboundPerson,jdbcType=VARCHAR},
- </if>
- </set>
- where id = #{id,jdbcType=INTEGER}
- </update>
-
-</mapper>
diff --git a/src/main/resources/mapper/inventory/StockOutMapper.xml b/src/main/resources/mapper/inventory/StockOutMapper.xml
deleted file mode 100644
index 5569d99..0000000
--- a/src/main/resources/mapper/inventory/StockOutMapper.xml
+++ /dev/null
@@ -1,111 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<!DOCTYPE mapper
- PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
- "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
-<mapper namespace="com.ruoyi.inventory.mapper.StockOutMapper">
-
- <resultMap id="BaseResultMap" type="com.ruoyi.inventory.pojo.StockOut">
- <id property="id" column="id" jdbcType="INTEGER"/>
- <result property="productId" column="product_id" jdbcType="INTEGER"/>
- <result property="inboundTime" column="inbound_time" jdbcType="TIMESTAMP"/>
- <result property="inboundBatch" column="inbound_batch" jdbcType="VARCHAR"/>
- <result property="supplierName" column="supplier_name" jdbcType="VARCHAR"/>
- <result property="inboundQuantity" column="inbound_quantity" jdbcType="INTEGER"/>
- <result property="taxInclusivePrice" column="tax_inclusive_price" jdbcType="DECIMAL"/>
- <result property="taxInclusiveTotal" column="tax_inclusive_total" jdbcType="DECIMAL"/>
- <result property="taxRate" column="tax_rate" jdbcType="DECIMAL"/>
- <result property="taxExclusiveTotal" column="tax_exclusive_total" jdbcType="DECIMAL"/>
- <result property="inboundPerson" column="inbound_person" jdbcType="VARCHAR"/>
- </resultMap>
-
- <sql id="Base_Column_List">
- id,product_id,inbound_time,
- inbound_batch,supplier_name,inbound_quantity,
- tax_inclusive_price,tax_inclusive_total,tax_rate,
- tax_exclusive_total,inbound_person
- </sql>
-
- <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap">
- select
- <include refid="Base_Column_List" />
- from stock_out
- where id = #{id,jdbcType=INTEGER}
- </select>
- <select id="selectAll" resultType="com.ruoyi.inventory.pojo.StockOut">
- select
- <include refid="Base_Column_List" />
- from stock_out
- </select>
-
- <delete id="deleteByPrimaryKey" parameterType="java.lang.Long">
- delete from stock_out
- where id = #{id,jdbcType=INTEGER}
- </delete>
-
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.ruoyi.inventory.pojo.StockOut" useGeneratedKeys="true">
- insert into stock_out
- <trim prefix="(" suffix=")" suffixOverrides=",">
- <if test="id != null">id,</if>
- <if test="productId != null">product_id,</if>
- <if test="inboundTime != null">inbound_time,</if>
- <if test="inboundBatch != null">inbound_batch,</if>
- <if test="supplierName != null">supplier_name,</if>
- <if test="inboundQuantity != null">inbound_quantity,</if>
- <if test="taxInclusivePrice != null">tax_inclusive_price,</if>
- <if test="taxInclusiveTotal != null">tax_inclusive_total,</if>
- <if test="taxRate != null">tax_rate,</if>
- <if test="taxExclusiveTotal != null">tax_exclusive_total,</if>
- <if test="inboundPerson != null">inbound_person,</if>
- </trim>
- <trim prefix="values (" suffix=")" suffixOverrides=",">
- <if test="id != null">#{id,jdbcType=INTEGER},</if>
- <if test="productId != null">#{productId,jdbcType=INTEGER},</if>
- <if test="inboundTime != null">#{inboundTime,jdbcType=TIMESTAMP},</if>
- <if test="inboundBatch != null">#{inboundBatch,jdbcType=VARCHAR},</if>
- <if test="supplierName != null">#{supplierName,jdbcType=VARCHAR},</if>
- <if test="inboundQuantity != null">#{inboundQuantity,jdbcType=INTEGER},</if>
- <if test="taxInclusivePrice != null">#{taxInclusivePrice,jdbcType=DECIMAL},</if>
- <if test="taxInclusiveTotal != null">#{taxInclusiveTotal,jdbcType=DECIMAL},</if>
- <if test="taxRate != null">#{taxRate,jdbcType=DECIMAL},</if>
- <if test="taxExclusiveTotal != null">#{taxExclusiveTotal,jdbcType=DECIMAL},</if>
- <if test="inboundPerson != null">#{inboundPerson,jdbcType=VARCHAR},</if>
- </trim>
- </insert>
- <update id="updateByPrimaryKeySelective" parameterType="com.ruoyi.inventory.pojo.StockOut">
- update stock_out
- <set>
- <if test="productId != null">
- product_id = #{productId,jdbcType=INTEGER},
- </if>
- <if test="inboundTime != null">
- inbound_time = #{inboundTime,jdbcType=TIMESTAMP},
- </if>
- <if test="inboundBatch != null">
- inbound_batch = #{inboundBatch,jdbcType=VARCHAR},
- </if>
- <if test="supplierName != null">
- supplier_name = #{supplierName,jdbcType=VARCHAR},
- </if>
- <if test="inboundQuantity != null">
- inbound_quantity = #{inboundQuantity,jdbcType=INTEGER},
- </if>
- <if test="taxInclusivePrice != null">
- tax_inclusive_price = #{taxInclusivePrice,jdbcType=DECIMAL},
- </if>
- <if test="taxInclusiveTotal != null">
- tax_inclusive_total = #{taxInclusiveTotal,jdbcType=DECIMAL},
- </if>
- <if test="taxRate != null">
- tax_rate = #{taxRate,jdbcType=DECIMAL},
- </if>
- <if test="taxExclusiveTotal != null">
- tax_exclusive_total = #{taxExclusiveTotal,jdbcType=DECIMAL},
- </if>
- <if test="inboundPerson != null">
- inbound_person = #{inboundPerson,jdbcType=VARCHAR},
- </if>
- </set>
- where id = #{id,jdbcType=INTEGER}
- </update>
-
-</mapper>
diff --git a/src/main/resources/mapper/inventory/StockProductMapper.xml b/src/main/resources/mapper/inventory/StockProductMapper.xml
deleted file mode 100644
index baf75a8..0000000
--- a/src/main/resources/mapper/inventory/StockProductMapper.xml
+++ /dev/null
@@ -1,67 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<!DOCTYPE mapper
- PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
- "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
-<mapper namespace="com.ruoyi.inventory.mapper.StockProductMapper">
-
- <resultMap id="BaseResultMap" type="com.ruoyi.inventory.pojo.StockProduct">
- <id property="id" column="id" jdbcType="INTEGER"/>
- <result property="productCategory" column="product_category" jdbcType="VARCHAR"/>
- <result property="specModel" column="spec_model" jdbcType="VARCHAR"/>
- <result property="unit" column="unit" jdbcType="VARCHAR"/>
- </resultMap>
-
- <sql id="Base_Column_List">
- id,product_category,spec_model,
- unit
- </sql>
-
- <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap">
- select
- <include refid="Base_Column_List" />
- from stock_product
- where id = #{id,jdbcType=INTEGER}
- </select>
- <select id="selectList" resultType="com.ruoyi.inventory.pojo.StockProduct">
- select
- <include refid="Base_Column_List" />
- from stock_product
- </select>
-
- <delete id="deleteByPrimaryKey" parameterType="java.lang.Long">
- delete from stock_product
- where id = #{id,jdbcType=INTEGER}
- </delete>
-
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.ruoyi.inventory.pojo.StockProduct" useGeneratedKeys="true">
- insert into stock_product
- <trim prefix="(" suffix=")" suffixOverrides=",">
- <if test="id != null">id,</if>
- <if test="productCategory != null">product_category,</if>
- <if test="specModel != null">spec_model,</if>
- <if test="unit != null">unit,</if>
- </trim>
- <trim prefix="values (" suffix=")" suffixOverrides=",">
- <if test="id != null">#{id,jdbcType=INTEGER},</if>
- <if test="productCategory != null">#{productCategory,jdbcType=VARCHAR},</if>
- <if test="specModel != null">#{specModel,jdbcType=VARCHAR},</if>
- <if test="unit != null">#{unit,jdbcType=VARCHAR},</if>
- </trim>
- </insert>
- <update id="updateByPrimaryKeySelective" parameterType="com.ruoyi.inventory.pojo.StockProduct">
- update stock_product
- <set>
- <if test="productCategory != null">
- product_category = #{productCategory,jdbcType=VARCHAR},
- </if>
- <if test="specModel != null">
- spec_model = #{specModel,jdbcType=VARCHAR},
- </if>
- <if test="unit != null">
- unit = #{unit,jdbcType=VARCHAR},
- </if>
- </set>
- where id = #{id,jdbcType=INTEGER}
- </update>
-
-</mapper>
--
Gitblit v1.9.3