From 36cff30b1967bf7b6c6f17ae7379c4a6197933b3 Mon Sep 17 00:00:00 2001
From: cuilei <ray_tsu1@163.com>
Date: 星期三, 21 五月 2025 14:38:24 +0800
Subject: [PATCH] 工具管理-工具出库申请
---
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/OutboundOrder.java | 121 +++++
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/OutboundDetailMapper.java | 41 +
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/enums/OutBillStatus.java | 76 +++
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/OutboundDetailServiceImpl.java | 44 ++
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IOutboundDetailService.java | 29 +
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/OutboundOrderServiceImpl.java | 136 ++++++
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/OutboundOrderMapper.xml | 25 +
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/OutboundOrderMapper.java | 21 +
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/OutboundOrderController.java | 338 ++++++++++++++++
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IOutboundOrderService.java | 43 ++
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/OutboundDetailVo.java | 96 ++++
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/OutboundDetail.java | 93 ++++
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/OutboundDetailMapper.xml | 101 ++++
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolLedgerDetailServiceImpl.java | 7
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/dto/OutboundOrderAndDetailDto.java | 77 +++
15 files changed, 1,246 insertions(+), 2 deletions(-)
diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/OutboundOrderController.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/OutboundOrderController.java
new file mode 100644
index 0000000..a23ff9c
--- /dev/null
+++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/controller/OutboundOrderController.java
@@ -0,0 +1,338 @@
+package org.jeecg.modules.tms.controller;
+
+import org.jeecg.common.system.query.QueryGenerator;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import lombok.extern.slf4j.Slf4j;
+import org.jeecg.common.system.base.controller.JeecgController;
+import org.jeecg.common.api.vo.Result;
+import org.jeecg.modules.tms.entity.dto.OutboundOrderAndDetailDto;
+import org.jeecg.modules.tms.entity.vo.OutboundDetailVo;
+import org.jeecg.modules.tms.enums.OutBillStatus;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.web.bind.annotation.*;
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
+import org.springframework.web.servlet.ModelAndView;
+import java.util.Arrays;
+import org.jeecg.common.util.oConvertUtils;
+import org.jeecg.modules.tms.entity.OutboundDetail;
+import org.jeecg.modules.tms.entity.OutboundOrder;
+import org.jeecg.modules.tms.service.IOutboundOrderService;
+import org.jeecg.modules.tms.service.IOutboundDetailService;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import org.jeecg.common.aspect.annotation.AutoLog;
+import org.apache.shiro.SecurityUtils;
+import org.jeecg.common.system.vo.LoginUser;
+import org.jeecgframework.poi.excel.ExcelImportUtil;
+import org.jeecgframework.poi.excel.def.NormalExcelConstants;
+import org.jeecgframework.poi.excel.entity.ExportParams;
+import org.jeecgframework.poi.excel.entity.ImportParams;
+import org.jeecgframework.poi.excel.view.JeecgEntityExcelView;
+import org.springframework.web.multipart.MultipartFile;
+import org.springframework.web.multipart.MultipartHttpServletRequest;
+import java.io.IOException;
+import java.util.List;
+import java.util.Map;
+import java.util.stream.Collectors;
+
+ /**
+ * @Description: tms_outbound_order
+ * @Author: jeecg-boot
+ * @Date: 2025-05-16
+ * @Version: V1.0
+ */
+@Api(tags="tms_outbound_order")
+@RestController
+@RequestMapping("/tms/outboundOrder")
+@Slf4j
+public class OutboundOrderController extends JeecgController<OutboundOrder, IOutboundOrderService> {
+
+ @Autowired
+ private IOutboundOrderService outboundOrderService;
+
+ @Autowired
+ private IOutboundDetailService outboundDetailService;
+
+
+ /*---------------------------------涓昏〃澶勭悊-begin-------------------------------------*/
+
+ /**
+ * 鍒嗛〉鍒楄〃鏌ヨ
+ * @param outboundOrder
+ * @param pageNo
+ * @param pageSize
+ * @param req
+ * @return
+ */
+ //@AutoLog(value = "tms_outbound_order-鍒嗛〉鍒楄〃鏌ヨ")
+ @ApiOperation(value="tms_outbound_order-鍒嗛〉鍒楄〃鏌ヨ", notes="tms_outbound_order-鍒嗛〉鍒楄〃鏌ヨ")
+ @GetMapping(value = "/list")
+ public Result<IPage<OutboundOrder>> queryPageList(OutboundOrder outboundOrder,
+ @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
+ @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
+ HttpServletRequest req) {
+ Map<String, String[]> parameterMap = req.getParameterMap();
+ QueryWrapper<OutboundOrder> queryWrapper = QueryGenerator.initQueryWrapper(outboundOrder, parameterMap);
+ Page<OutboundOrder> page = new Page<OutboundOrder>(pageNo, pageSize);
+ IPage<OutboundOrder> pageList = outboundOrderService.queryPageList(page, parameterMap);
+ return Result.OK(pageList);
+ }
+
+ /**
+ * 娣诲姞
+ * @param outboundOrder
+ * @return
+ */
+ @AutoLog(value = "tms_outbound_order-娣诲姞")
+ @ApiOperation(value="tms_outbound_order-娣诲姞", notes="tms_outbound_order-娣诲姞")
+ //@RequiresPermissions("org.jeecg.modules:tms_outbound_order:add")
+ @PostMapping(value = "/add")
+ public Result<String> add(@RequestBody OutboundOrder outboundOrder) {
+ outboundOrderService.save(outboundOrder);
+ return Result.OK("娣诲姞鎴愬姛锛�");
+ }
+
+ @AutoLog(value = "tms_outbound_order-娣诲姞鍑哄簱鐢宠鍗曚富琛ㄥ強鏄庣粏淇℃伅")
+ @ApiOperation(value="tms_outbound_order-娣诲姞鍑哄簱鐢宠鍗曚富琛ㄥ強鏄庣粏淇℃伅", notes="tms_outbound_order-娣诲姞鍑哄簱鐢宠鍗曚富琛ㄥ強鏄庣粏淇℃伅")
+ @PostMapping(value = "/addTotal")
+ public Result<String> addTotal(@RequestBody OutboundOrderAndDetailDto outboundOrder) {
+ outboundOrderService.addTotal(outboundOrder);
+ return Result.OK("娣诲姞鎴愬姛锛�");
+ }
+
+ @AutoLog(value = "tms_outbound_order-缂栬緫鍑哄簱鐢宠鍗曚富琛ㄥ強鏄庣粏淇℃伅")
+ @ApiOperation(value="tms_outbound_order-缂栬緫鍑哄簱鐢宠鍗曚富琛ㄥ強鏄庣粏淇℃伅", notes="tms_outbound_order-缂栬緫鍑哄簱鐢宠鍗曚富琛ㄥ強鏄庣粏淇℃伅")
+ //@RequiresPermissions("org.jeecg.modules:tms_outbound_order:edit")
+ @RequestMapping(value = "/editTotal", method = {RequestMethod.PUT,RequestMethod.POST})
+ public Result<String> editTotal(@RequestBody OutboundOrderAndDetailDto outboundOrder) {
+ outboundOrderService.editTotal(outboundOrder);
+ return Result.OK("缂栬緫鎴愬姛锛�");
+ }
+
+ /**
+ * 缂栬緫
+ * @param outboundOrder
+ * @return
+ */
+ @AutoLog(value = "tms_outbound_order-缂栬緫")
+ @ApiOperation(value="tms_outbound_order-缂栬緫", notes="tms_outbound_order-缂栬緫")
+ //@RequiresPermissions("org.jeecg.modules:tms_outbound_order:edit")
+ @RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST})
+ public Result<String> edit(@RequestBody OutboundOrder outboundOrder) {
+ outboundOrderService.updateById(outboundOrder);
+ return Result.OK("缂栬緫鎴愬姛!");
+ }
+
+ @AutoLog(value = "tms_outbound_order-鎻愪氦鍑哄簱鐢宠鍗�")
+ @ApiOperation(value="tms_outbound_order-鎻愪氦鍑哄簱鐢宠鍗�", notes="tms_outbound_order-鎻愪氦鍑哄簱鐢宠鍗�")
+ @GetMapping(value = "/submit")
+ public Result<String> submit(@RequestParam(name="id") String id) {
+ OutboundOrder order = new OutboundOrder();
+ order.setId(id);
+ order.setOrderStatus(OutBillStatus.SUBMITTED.getValue());
+ outboundOrderService.updateById(order);
+ //寮�鍚祦绋�
+ return Result.OK("鎻愪氦鎴愬姛!");
+ }
+
+ /**
+ * 閫氳繃id鍒犻櫎
+ * @param id
+ * @return
+ */
+ @AutoLog(value = "tms_outbound_order-閫氳繃id鍒犻櫎")
+ @ApiOperation(value="tms_outbound_order-閫氳繃id鍒犻櫎", notes="tms_outbound_order-閫氳繃id鍒犻櫎")
+ //@RequiresPermissions("org.jeecg.modules:tms_outbound_order:delete")
+ @DeleteMapping(value = "/delete")
+ public Result<String> delete(@RequestParam(name="id",required=true) String id) {
+ outboundOrderService.delMain(id);
+ return Result.OK("鍒犻櫎鎴愬姛!");
+ }
+
+ /**
+ * 鎵归噺鍒犻櫎
+ * @param ids
+ * @return
+ */
+ @AutoLog(value = "tms_outbound_order-鎵归噺鍒犻櫎")
+ @ApiOperation(value="tms_outbound_order-鎵归噺鍒犻櫎", notes="tms_outbound_order-鎵归噺鍒犻櫎")
+ //@RequiresPermissions("org.jeecg.modules:tms_outbound_order:deleteBatch")
+ @DeleteMapping(value = "/deleteBatch")
+ public Result<String> deleteBatch(@RequestParam(name="ids",required=true) String ids) {
+ this.outboundOrderService.delBatchMain(Arrays.asList(ids.split(",")));
+ return Result.OK("鎵归噺鍒犻櫎鎴愬姛!");
+ }
+
+ /**
+ * 瀵煎嚭
+ * @return
+ */
+ //@RequiresPermissions("org.jeecg.modules:tms_outbound_order:exportXls")
+ @RequestMapping(value = "/exportXls")
+ public ModelAndView exportXls(HttpServletRequest request, OutboundOrder outboundOrder) {
+ return super.exportXls(request, outboundOrder, OutboundOrder.class, "tms_outbound_order");
+ }
+
+ /**
+ * 瀵煎叆
+ * @return
+ */
+ //@RequiresPermissions("org.jeecg.modules:tms_outbound_order:importExcel")
+ @RequestMapping(value = "/importExcel", method = RequestMethod.POST)
+ public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) {
+ return super.importExcel(request, response, OutboundOrder.class);
+ }
+ /*---------------------------------涓昏〃澶勭悊-end-------------------------------------*/
+
+
+ /*--------------------------------瀛愯〃澶勭悊-鍑哄簱鐢宠鍗曟槑缁�-begin----------------------------------------------*/
+ /**
+ * 閫氳繃涓昏〃ID鏌ヨ
+ * @return
+ */
+ //@AutoLog(value = "鍑哄簱鐢宠鍗曟槑缁�-閫氳繃涓昏〃ID鏌ヨ")
+ @ApiOperation(value="鍑哄簱鐢宠鍗曟槑缁�-閫氳繃涓昏〃ID鏌ヨ", notes="鍑哄簱鐢宠鍗曟槑缁�-閫氳繃涓昏〃ID鏌ヨ")
+ @GetMapping(value = "/listOutboundDetailByMainId")
+ public Result<IPage<OutboundDetailVo>> listOutboundDetailByMainId(OutboundDetail outboundDetail,
+ @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo,
+ @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize,
+ HttpServletRequest req) {
+ Map<String, String[]> parameterMap = req.getParameterMap();
+ QueryWrapper<OutboundDetail> queryWrapper = QueryGenerator.initQueryWrapper(outboundDetail, parameterMap);
+ Page<OutboundDetail> page = new Page<OutboundDetail>(pageNo, pageSize);
+ IPage<OutboundDetailVo> pageList = outboundDetailService.queryPageList(page, parameterMap);
+ return Result.OK(pageList);
+ }
+
+ /**
+ * 娣诲姞
+ * @param outboundDetail
+ * @return
+ */
+ @AutoLog(value = "鍑哄簱鐢宠鍗曟槑缁�-娣诲姞")
+ @ApiOperation(value="鍑哄簱鐢宠鍗曟槑缁�-娣诲姞", notes="鍑哄簱鐢宠鍗曟槑缁�-娣诲姞")
+ @PostMapping(value = "/addOutboundDetail")
+ public Result<String> addOutboundDetail(@RequestBody OutboundDetail outboundDetail) {
+ outboundDetailService.save(outboundDetail);
+ return Result.OK("娣诲姞鎴愬姛锛�");
+ }
+
+ /**
+ * 缂栬緫
+ * @param outboundDetail
+ * @return
+ */
+ @AutoLog(value = "鍑哄簱鐢宠鍗曟槑缁�-缂栬緫")
+ @ApiOperation(value="鍑哄簱鐢宠鍗曟槑缁�-缂栬緫", notes="鍑哄簱鐢宠鍗曟槑缁�-缂栬緫")
+ @RequestMapping(value = "/editOutboundDetail", method = {RequestMethod.PUT,RequestMethod.POST})
+ public Result<String> editOutboundDetail(@RequestBody OutboundDetail outboundDetail) {
+ outboundDetailService.updateById(outboundDetail);
+ return Result.OK("缂栬緫鎴愬姛!");
+ }
+
+ /**
+ * 閫氳繃id鍒犻櫎
+ * @param id
+ * @return
+ */
+ @AutoLog(value = "鍑哄簱鐢宠鍗曟槑缁�-閫氳繃id鍒犻櫎")
+ @ApiOperation(value="鍑哄簱鐢宠鍗曟槑缁�-閫氳繃id鍒犻櫎", notes="鍑哄簱鐢宠鍗曟槑缁�-閫氳繃id鍒犻櫎")
+ @DeleteMapping(value = "/deleteOutboundDetail")
+ public Result<String> deleteOutboundDetail(@RequestParam(name="id",required=true) String id) {
+ outboundDetailService.removeById(id);
+ return Result.OK("鍒犻櫎鎴愬姛!");
+ }
+
+ /**
+ * 鎵归噺鍒犻櫎
+ * @param ids
+ * @return
+ */
+ @AutoLog(value = "鍑哄簱鐢宠鍗曟槑缁�-鎵归噺鍒犻櫎")
+ @ApiOperation(value="鍑哄簱鐢宠鍗曟槑缁�-鎵归噺鍒犻櫎", notes="鍑哄簱鐢宠鍗曟槑缁�-鎵归噺鍒犻櫎")
+ @DeleteMapping(value = "/deleteBatchOutboundDetail")
+ public Result<String> deleteBatchOutboundDetail(@RequestParam(name="ids",required=true) String ids) {
+ this.outboundDetailService.removeByIds(Arrays.asList(ids.split(",")));
+ return Result.OK("鎵归噺鍒犻櫎鎴愬姛!");
+ }
+
+ /**
+ * 瀵煎嚭
+ * @return
+ */
+ @RequestMapping(value = "/exportOutboundDetail")
+ public ModelAndView exportOutboundDetail(HttpServletRequest request, OutboundDetail outboundDetail) {
+ // Step.1 缁勮鏌ヨ鏉′欢
+ QueryWrapper<OutboundDetail> queryWrapper = QueryGenerator.initQueryWrapper(outboundDetail, request.getParameterMap());
+ LoginUser sysUser = (LoginUser) SecurityUtils.getSubject().getPrincipal();
+
+ // Step.2 鑾峰彇瀵煎嚭鏁版嵁
+ List<OutboundDetail> pageList = outboundDetailService.list(queryWrapper);
+ List<OutboundDetail> exportList = null;
+
+ // 杩囨护閫変腑鏁版嵁
+ String selections = request.getParameter("selections");
+ if (oConvertUtils.isNotEmpty(selections)) {
+ List<String> selectionList = Arrays.asList(selections.split(","));
+ exportList = pageList.stream().filter(item -> selectionList.contains(item.getId())).collect(Collectors.toList());
+ } else {
+ exportList = pageList;
+ }
+
+ // Step.3 AutoPoi 瀵煎嚭Excel
+ ModelAndView mv = new ModelAndView(new JeecgEntityExcelView());
+ //姝ゅ璁剧疆鐨刦ilename鏃犳晥,鍓嶇浼氶噸鏇存柊璁剧疆涓�涓�
+ mv.addObject(NormalExcelConstants.FILE_NAME, "鍑哄簱鐢宠鍗曟槑缁�");
+ mv.addObject(NormalExcelConstants.CLASS, OutboundDetail.class);
+ mv.addObject(NormalExcelConstants.PARAMS, new ExportParams("鍑哄簱鐢宠鍗曟槑缁嗘姤琛�", "瀵煎嚭浜�:" + sysUser.getRealname(), "鍑哄簱鐢宠鍗曟槑缁�"));
+ mv.addObject(NormalExcelConstants.DATA_LIST, exportList);
+ return mv;
+ }
+
+ /**
+ * 瀵煎叆
+ * @return
+ */
+ @RequestMapping(value = "/importOutboundDetail/{mainId}")
+ public Result<?> importOutboundDetail(HttpServletRequest request, HttpServletResponse response, @PathVariable("mainId") String mainId) {
+ MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
+ Map<String, MultipartFile> fileMap = multipartRequest.getFileMap();
+ for (Map.Entry<String, MultipartFile> entity : fileMap.entrySet()) {
+ // 鑾峰彇涓婁紶鏂囦欢瀵硅薄
+ MultipartFile file = entity.getValue();
+ ImportParams params = new ImportParams();
+ params.setTitleRows(2);
+ params.setHeadRows(1);
+ params.setNeedSave(true);
+ try {
+ List<OutboundDetail> list = ExcelImportUtil.importExcel(file.getInputStream(), OutboundDetail.class, params);
+ for (OutboundDetail temp : list) {
+ temp.setOutStorehouseId(mainId);
+ }
+ long start = System.currentTimeMillis();
+ outboundDetailService.saveBatch(list);
+ log.info("娑堣�楁椂闂�" + (System.currentTimeMillis() - start) + "姣");
+ return Result.OK("鏂囦欢瀵煎叆鎴愬姛锛佹暟鎹鏁帮細" + list.size());
+ } catch (Exception e) {
+ log.error(e.getMessage(), e);
+ return Result.error("鏂囦欢瀵煎叆澶辫触:" + e.getMessage());
+ } finally {
+ try {
+ file.getInputStream().close();
+ } catch (IOException e) {
+ e.printStackTrace();
+ }
+ }
+ }
+ return Result.error("鏂囦欢瀵煎叆澶辫触锛�");
+ }
+
+ /*--------------------------------瀛愯〃澶勭悊-鍑哄簱鐢宠鍗曟槑缁�-end----------------------------------------------*/
+
+
+
+
+}
diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/OutboundDetail.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/OutboundDetail.java
new file mode 100644
index 0000000..21ca411
--- /dev/null
+++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/OutboundDetail.java
@@ -0,0 +1,93 @@
+package org.jeecg.modules.tms.entity;
+
+import java.io.Serializable;
+import com.baomidou.mybatisplus.annotation.IdType;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.baomidou.mybatisplus.annotation.TableLogic;
+import org.jeecg.common.aspect.annotation.Dict;
+import lombok.Data;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import org.springframework.format.annotation.DateTimeFormat;
+import org.jeecgframework.poi.excel.annotation.Excel;
+import java.util.Date;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import java.io.UnsupportedEncodingException;
+
+/**
+ * @Description: 鍑哄簱鐢宠鍗曟槑缁�
+ * @Author: jeecg-boot
+ * @Date: 2025-05-16
+ * @Version: V1.0
+ */
+@Data
+@TableName("tms_outbound_detail")
+@ApiModel(value="tms_outbound_detail瀵硅薄", description="鍑哄簱鐢宠鍗曟槑缁�")
+public class OutboundDetail implements Serializable {
+ private static final long serialVersionUID = 1L;
+
+ /**涓婚敭*/
+ @TableId(type = IdType.ASSIGN_ID)
+ @ApiModelProperty(value = "涓婚敭")
+ private String id;
+ /**鍑哄簱鍗曞彿*/
+ @ApiModelProperty(value = "鍑哄簱鍗曞彿")
+ private String outStorehouseId;
+ /**鍒�鍏风紪鐮�*/
+ @Excel(name = "鍒�鍏风紪鐮�", width = 15)
+ @ApiModelProperty(value = "鍒�鍏风紪鐮�")
+ private String toolCode;
+ /**鍒�鍏风紪鍙�*/
+ @Excel(name = "鍒�鍏风紪鍙�", width = 15)
+ @ApiModelProperty(value = "鍒�鍏风紪鍙�")
+ private String toolId;
+ /**鐢宠鍑哄簱鏁伴噺*/
+ @Excel(name = "鐢宠鍑哄簱鏁伴噺", width = 15)
+ @ApiModelProperty(value = "鐢宠鍑哄簱鏁伴噺")
+ private java.math.BigDecimal outboundQuantity;
+ /**瀹為檯鍑哄簱鏁伴噺*/
+ @Excel(name = "瀹為檯鍑哄簱鏁伴噺", width = 15)
+ @ApiModelProperty(value = "瀹為檯鍑哄簱鏁伴噺")
+ private java.math.BigDecimal outActualCount;
+ /**鍑哄簱鏃堕棿*/
+ @Excel(name = "鍑哄簱鏃堕棿", width = 15, format = "yyyy-MM-dd HH:mm")
+ @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm")
+ @DateTimeFormat(pattern="yyyy-MM-dd HH:mm")
+ @ApiModelProperty(value = "鍑哄簱鏃堕棿")
+ private Date outboundTime;
+ /**浠撳簱*/
+ @Excel(name = "浠撳簱", width = 15)
+ @ApiModelProperty(value = "浠撳簱")
+ @Dict(dictTable = "tms_warehouse", dicCode = "id", dicText = "warehouse_name")
+ private String storageLocation;
+ /**鍑哄簱搴撲綅*/
+ @Excel(name = "鍑哄簱搴撲綅", width = 15)
+ @ApiModelProperty(value = "鍑哄簱搴撲綅")
+ private String outboundLocation;
+ /**鍑哄簱鐘舵��;1.鏈嚭搴擄紱2.閮ㄥ垎鍑哄簱锛�3.鍑哄簱瀹屾垚*/
+ @Excel(name = "鍑哄簱鐘舵��;1.鏈嚭搴擄紱2.閮ㄥ垎鍑哄簱锛�3.鍑哄簱瀹屾垚", width = 15)
+ @ApiModelProperty(value = "鍑哄簱鐘舵��;1.鏈嚭搴擄紱2.閮ㄥ垎鍑哄簱锛�3.鍑哄簱瀹屾垚")
+ @Dict(dicCode = "out_storehouse_status")
+ private Integer status;
+ /**绉熸埛鍙�*/
+ @Excel(name = "绉熸埛鍙�", width = 15)
+ @ApiModelProperty(value = "绉熸埛鍙�")
+ private String tenantId;
+ /**鎿嶄綔鍛�*/
+ @ApiModelProperty(value = "鎿嶄綔鍛�")
+ private String createBy;
+ /**鍒涘缓鏃堕棿*/
+ @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm")
+ @DateTimeFormat(pattern="yyyy-MM-dd HH:mm")
+ @ApiModelProperty(value = "鍒涘缓鏃堕棿")
+ private Date createTime;
+ /**鏇存柊浜�*/
+ @ApiModelProperty(value = "鏇存柊浜�")
+ private String updateBy;
+ /**鏇存柊鏃堕棿*/
+ @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm")
+ @DateTimeFormat(pattern="yyyy-MM-dd HH:mm")
+ @ApiModelProperty(value = "鏇存柊鏃堕棿")
+ private Date updateTime;
+}
diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/OutboundOrder.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/OutboundOrder.java
new file mode 100644
index 0000000..4520bf9
--- /dev/null
+++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/OutboundOrder.java
@@ -0,0 +1,121 @@
+package org.jeecg.modules.tms.entity;
+
+import java.io.Serializable;
+import java.io.UnsupportedEncodingException;
+import java.util.Date;
+
+import com.baomidou.mybatisplus.annotation.*;
+import org.jeecgframework.poi.excel.annotation.Excel;
+import lombok.Data;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import org.springframework.format.annotation.DateTimeFormat;
+import org.jeecg.common.aspect.annotation.Dict;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+
+/**
+ * @Description: tms_outbound_order
+ * @Author: jeecg-boot
+ * @Date: 2025-05-16
+ * @Version: V1.0
+ */
+@Data
+@TableName("tms_outbound_order")
+@ApiModel(value="tms_outbound_order瀵硅薄", description="tms_outbound_order")
+public class OutboundOrder implements Serializable {
+ private static final long serialVersionUID = 1L;
+
+ /**涓婚敭id*/
+ @TableId(type = IdType.ASSIGN_ID)
+ @ApiModelProperty(value = "涓婚敭id")
+ private String id;
+ /**鍑哄簱鍗曠紪鍙�*/
+ @Excel(name = "鍑哄簱鍗曠紪鍙�", width = 15)
+ @ApiModelProperty(value = "鍑哄簱鍗曠紪鍙�")
+ private String outNum;
+ /**鍑哄簱绫诲瀷*/
+ @Excel(name = "鍑哄簱绫诲瀷", width = 15, dicCode = "out_storehouse_type")
+ @Dict(dicCode = "out_storehouse_type")
+ @ApiModelProperty(value = "鍑哄簱绫诲瀷")
+ private String outStorehouseType;
+ /**鏄惁褰掕繕;1鏈綊杩橈紙榛樿锛夛紱2.宸插綊杩�*/
+ @Excel(name = "鏄惁褰掕繕;1鏈綊杩橈紙榛樿锛夛紱2.宸插綊杩�", width = 15)
+ @ApiModelProperty(value = "鏄惁褰掕繕;1鏈綊杩橈紙榛樿锛夛紱2.宸插綊杩�")
+ private Integer isReturn;
+ /**缁忔墜浜�*/
+ @Excel(name = "缁忔墜浜�", width = 15, dictTable = "sys_user", dicText = "realname", dicCode = "id")
+ @Dict(dictTable = "sys_user", dicText = "realname", dicCode = "id")
+ @ApiModelProperty(value = "缁忔墜浜�")
+ private String handler;
+ /**瀹℃牳浜�*/
+ @Excel(name = "瀹℃牳浜�", width = 15, dictTable = "sys_user", dicText = "realname", dicCode = "id")
+ @Dict(dictTable = "sys_user", dicText = "realname", dicCode = "id")
+ @ApiModelProperty(value = "瀹℃牳浜�")
+ private String reviewer;
+ /**鍗曞瓙鐘舵��*/
+ @Excel(name = "鍗曞瓙鐘舵��", width = 15)
+ @ApiModelProperty(value = "鍗曞瓙鐘舵��")
+ @Dict(dicCode = "out_bill_status")
+ private String orderStatus;
+ /**鍑哄簱鐘舵��*/
+ @Excel(name = "鍑哄簱鐘舵��", width = 15)
+ @ApiModelProperty(value = "鍑哄簱鐘舵��")
+ @Dict(dicCode = "out_storehouse_status")
+ private String outStatus;
+ /**瀹℃牳鏃堕棿*/
+ @Excel(name = "瀹℃牳鏃堕棿", width = 15, format = "yyyy-MM-dd HH:mm")
+ @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm")
+ @DateTimeFormat(pattern="yyyy-MM-dd HH:mm")
+ @ApiModelProperty(value = "瀹℃牳鏃堕棿")
+ private Date auditDate;
+ /**寮�濮嬫椂闂�*/
+ @TableField(exist = false)
+ @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm")
+ @DateTimeFormat(pattern="yyyy-MM-dd HH:mm")
+ @ApiModelProperty(value = "寮�濮嬫椂闂�")
+ private Date startTime;
+ /**缁撴潫鏃堕棿*/
+ @TableField(exist = false)
+ @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm")
+ @DateTimeFormat(pattern="yyyy-MM-dd HH:mm")
+ @ApiModelProperty(value = "缁撴潫鏃堕棿")
+ private Date endTime;
+ /**瀹℃牳鎰忚*/
+ @Excel(name = "瀹℃牳鎰忚", width = 15)
+ @ApiModelProperty(value = "瀹℃牳鎰忚")
+ private String approvalOpinion;
+ /**棰嗙敤浜嬬敱*/
+ @Excel(name = "棰嗙敤浜嬬敱", width = 15)
+ @ApiModelProperty(value = "棰嗙敤浜嬬敱")
+ private String subjectMatter;
+ /**鍑哄簱鏃堕棿*/
+ @Excel(name = "鍑哄簱鏃堕棿", width = 15, format = "yyyy-MM-dd HH:mm")
+ @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm")
+ @DateTimeFormat(pattern="yyyy-MM-dd HH:mm")
+ @ApiModelProperty(value = "鍑哄簱鏃堕棿")
+ private Date outboundTime;
+ /**澶囨敞*/
+ @Excel(name = "澶囨敞", width = 15)
+ @ApiModelProperty(value = "澶囨敞")
+ private String remark;
+ /**绉熸埛鍙�*/
+ @Excel(name = "绉熸埛鍙�", width = 15)
+ @ApiModelProperty(value = "绉熸埛鍙�")
+ private String tenantId;
+ /**鎿嶄綔鍛�*/
+ @ApiModelProperty(value = "鎿嶄綔鍛�")
+ private String createBy;
+ /**鍒涘缓鏃堕棿*/
+ @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm")
+ @DateTimeFormat(pattern="yyyy-MM-dd HH:mm")
+ @ApiModelProperty(value = "鍒涘缓鏃堕棿")
+ private Date createTime;
+ /**鏇存柊浜�*/
+ @ApiModelProperty(value = "鏇存柊浜�")
+ private String updateBy;
+ /**鏇存柊鏃堕棿*/
+ @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm")
+ @DateTimeFormat(pattern="yyyy-MM-dd HH:mm")
+ @ApiModelProperty(value = "鏇存柊鏃堕棿")
+ private Date updateTime;
+}
diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/dto/OutboundOrderAndDetailDto.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/dto/OutboundOrderAndDetailDto.java
new file mode 100644
index 0000000..9f53930
--- /dev/null
+++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/dto/OutboundOrderAndDetailDto.java
@@ -0,0 +1,77 @@
+package org.jeecg.modules.tms.entity.dto;
+
+import com.baomidou.mybatisplus.annotation.IdType;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import lombok.experimental.Accessors;
+import org.jeecg.common.aspect.annotation.Dict;
+import org.jeecg.modules.tms.entity.OutboundDetail;
+import org.jeecgframework.poi.excel.annotation.Excel;
+import org.springframework.format.annotation.DateTimeFormat;
+
+import java.io.Serializable;
+import java.util.Date;
+import java.util.List;
+
+/**
+ * @Description: tms_outbound_order
+ * @Author: jeecg-boot
+ * @Date: 2025-05-16
+ * @Version: V1.0
+ */
+@Data
+@Accessors(chain = true)
+@ApiModel(value="tms_outbound_order瀵硅薄", description="tms_outbound_order")
+public class OutboundOrderAndDetailDto implements Serializable {
+ private static final long serialVersionUID = 1L;
+
+ /**涓婚敭id*/
+ @ApiModelProperty(value = "涓婚敭id")
+ private String id;
+ /**鍑哄簱鍗曠紪鍙�*/
+ @ApiModelProperty(value = "鍑哄簱鍗曠紪鍙�")
+ private String outNum;
+ /**鍑哄簱绫诲瀷*/
+ @Dict(dicCode = "out_storehouse_type")
+ @ApiModelProperty(value = "鍑哄簱绫诲瀷")
+ private String outStorehouseType;
+ /**鏄惁褰掕繕;1鏈綊杩橈紙榛樿锛夛紱2.宸插綊杩�*/
+ @ApiModelProperty(value = "鏄惁褰掕繕;1鏈綊杩橈紙榛樿锛夛紱2.宸插綊杩�")
+ private Integer isReturn;
+ /**缁忔墜浜�*/
+ @ApiModelProperty(value = "缁忔墜浜�")
+ private String handler;
+ /**瀹℃牳浜�*/
+ @Dict(dictTable = "sys_user", dicText = "realname", dicCode = "username")
+ @ApiModelProperty(value = "瀹℃牳浜�")
+ private String reviewer;
+ /**鍗曞瓙鐘舵��*/
+ @ApiModelProperty(value = "鍗曞瓙鐘舵��")
+ private String orderStatus;
+ /**瀹℃牳鏃堕棿*/
+ @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd")
+ @DateTimeFormat(pattern="yyyy-MM-dd")
+ @ApiModelProperty(value = "瀹℃牳鏃堕棿")
+ private Date auditDate;
+ /**瀹℃牳鎰忚*/
+ @ApiModelProperty(value = "瀹℃牳鎰忚")
+ private String approvalOpinion;
+ /**棰嗙敤浜嬬敱*/
+ @ApiModelProperty(value = "棰嗙敤浜嬬敱")
+ private String subjectMatter;
+ /**鍑哄簱鏃堕棿*/
+ @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm")
+ @DateTimeFormat(pattern="yyyy-MM-dd HH:mm")
+ @ApiModelProperty(value = "鍑哄簱鏃堕棿")
+ private Date outboundTime;
+ /**澶囨敞*/
+ @ApiModelProperty(value = "澶囨敞")
+ private String remark;
+ /**鍑哄簱鐢宠鍗曟槑缁�*/
+ @ApiModelProperty(value = "鍑哄簱鐢宠鍗曟槑缁�")
+ private List<OutboundDetail> outboundDetailList;
+}
diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/OutboundDetailVo.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/OutboundDetailVo.java
new file mode 100644
index 0000000..0d17e6a
--- /dev/null
+++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/entity/vo/OutboundDetailVo.java
@@ -0,0 +1,96 @@
+package org.jeecg.modules.tms.entity.vo;
+
+import com.fasterxml.jackson.annotation.JsonFormat;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import org.jeecg.common.aspect.annotation.Dict;
+import org.springframework.format.annotation.DateTimeFormat;
+import java.io.Serializable;
+import java.util.Date;
+
+/**
+ * @Description: 鍑哄簱鐢宠鍗曟槑缁�
+ * @Author: jeecg-boot
+ * @Date: 2025-05-16
+ * @Version: V1.0
+ */
+@Data
+@ApiModel(value="鍑哄簱鐢宠鍗曟槑缁嗛〉闈㈠睍绀哄璞″皝瑁�", description="鍑哄簱鐢宠鍗曟槑缁嗛〉闈㈠睍绀哄璞″皝瑁�")
+public class OutboundDetailVo implements Serializable {
+ private static final long serialVersionUID = 1L;
+
+ /**涓婚敭*/
+ @ApiModelProperty(value = "涓婚敭")
+ private String id;
+ /**鍑哄簱鍗曞彿*/
+ @ApiModelProperty(value = "鍑哄簱鍗曞彿")
+ private String outStorehouseId;
+ /**鍒�鍏风紪鐮�*/
+ @ApiModelProperty(value = "鍒�鍏风紪鐮�(tms_base_tool琛ㄤ富閿甶d)")
+ private String toolCode;
+ /**鍒�鍏风紪鍙�*/
+ @ApiModelProperty(value = "鍒�鍏风紪鍙�")
+ private String toolId;
+ /**鍒�鍏风紪鐮�*/
+ @ApiModelProperty(value = "鍒�鍏风紪鐮�(tms_base_tool琛╰ool_code瀛楁)")
+ private String toolNum;
+ /**鐢宠鍑哄簱鏁伴噺*/
+ @ApiModelProperty(value = "鐢宠鍑哄簱鏁伴噺")
+ private java.math.BigDecimal outboundQuantity;
+ /**瀹為檯鍑哄簱鏁伴噺*/
+ @ApiModelProperty(value = "瀹為檯鍑哄簱鏁伴噺")
+ private java.math.BigDecimal outActualCount;
+ /**鍑哄簱鏃堕棿*/
+ @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm")
+ @DateTimeFormat(pattern="yyyy-MM-dd HH:mm")
+ @ApiModelProperty(value = "鍑哄簱鏃堕棿")
+ private Date outboundTime;
+ /**浠撳簱*/
+ @ApiModelProperty(value = "浠撳簱")
+ @Dict(dictTable = "tms_warehouse", dicCode = "id", dicText = "warehouse_name")
+ private String storageLocation;
+ /**鍑哄簱搴撲綅*/
+ @ApiModelProperty(value = "鍑哄簱搴撲綅")
+ private String outboundLocation;
+ /**鍑哄簱鐘舵��;1.鏈嚭搴擄紱2.閮ㄥ垎鍑哄簱锛�3.鍑哄簱瀹屾垚*/
+ @ApiModelProperty(value = "鍑哄簱鐘舵��;1.鏈嚭搴擄紱2.閮ㄥ垎鍑哄簱锛�3.鍑哄簱瀹屾垚")
+ @Dict(dicCode = "out_storehouse_status")
+ private Integer status;
+ /**鎿嶄綔鍛�*/
+ @ApiModelProperty(value = "鎿嶄綔鍛�")
+ private String createBy;
+ /**鍒涘缓鏃堕棿*/
+ @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm")
+ @DateTimeFormat(pattern="yyyy-MM-dd HH:mm")
+ @ApiModelProperty(value = "鍒涘缓鏃堕棿")
+ private Date createTime;
+ /**宸ュ叿绫诲瀷*/
+ @Dict(dicCode = "application_type")
+ @ApiModelProperty(value = "宸ュ叿绫诲瀷")
+ private String applicationType;
+ /**涓枃鍚嶇О*/
+ @ApiModelProperty(value = "涓枃鍚嶇О")
+ private String chineseName;
+ /**鍨嬪彿/鍥惧彿*/
+ @ApiModelProperty(value = "鍨嬪彿/鍥惧彿")
+ private String toolModel;
+ /**鍒�鍏锋潗鏂�*/
+ @ApiModelProperty(value = "鍒�鍏锋潗鏂�")
+ private String toolMaterial;
+ /**闆朵欢鏉愭枡*/
+ @ApiModelProperty(value = "闆朵欢鏉愭枡")
+ private String partMaterial;
+ /**鍘傚*/
+ @ApiModelProperty(value = "鍘傚")
+ private String supplierId;
+ /**鍙敤搴撳瓨鏁伴噺*/
+ @ApiModelProperty(value = "鍙敤搴撳瓨鏁伴噺")
+ private java.math.BigDecimal quantity;
+ /**浠撳簱鍚嶇О*/
+ @ApiModelProperty(value = "浠撳簱鍚嶇О")
+ private String warehouseName;
+ /**鍙拌处鏄庣粏琛ㄤ富閿甶d*/
+ @ApiModelProperty(value = "鍙拌处鏄庣粏琛ㄤ富閿甶d,宸ュ叿閫夋嫨鏃跺幓閲嶇敤")
+ private String toolLedgerDetailId;
+}
diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/enums/OutBillStatus.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/enums/OutBillStatus.java
new file mode 100644
index 0000000..7ead9ae
--- /dev/null
+++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/enums/OutBillStatus.java
@@ -0,0 +1,76 @@
+package org.jeecg.modules.tms.enums;
+
+
+import java.util.Objects;
+
+/**
+ * 鍑哄簱鍗曠姸鎬佹灇涓剧被
+ */
+public enum OutBillStatus {
+ /**
+ * 鑽夌鐘舵�侊紝鍊间负1
+ */
+ DRAFT("1", "鑽夌"),
+
+ /**
+ * 宸叉彁浜ょ姸鎬侊紝鍊间负2
+ */
+ SUBMITTED("2", "宸叉彁浜�"),
+
+ /**
+ * 瀹℃壒閫氳繃鐘舵�侊紝鍊间负3
+ */
+ APPROVED("3", "瀹℃壒閫氳繃"),
+
+ /**
+ * 瀹℃壒椹冲洖鐘舵�侊紝鍊间负4
+ */
+ REJECTED("4", "瀹℃壒椹冲洖");
+
+ private final String value;
+ private final String description;
+
+ /**
+ * 鏋勯�犳柟娉�
+ *
+ * @param value 鐘舵�佸��
+ * @param description 鐘舵�佹弿杩�
+ */
+ OutBillStatus(String value, String description) {
+ this.value = value;
+ this.description = description;
+ }
+
+ /**
+ * 鑾峰彇鐘舵�佸��
+ *
+ * @return 鐘舵�佸��
+ */
+ public String getValue() {
+ return value;
+ }
+
+ /**
+ * 鑾峰彇鐘舵�佹弿杩�
+ *
+ * @return 鐘舵�佹弿杩�
+ */
+ public String getDescription() {
+ return description;
+ }
+
+ /**
+ * 鏍规嵁鐘舵�佸�艰幏鍙栧搴旂殑鏋氫妇瀹炰緥
+ *
+ * @param value 鐘舵�佸��
+ * @return 瀵瑰簲鐨勬灇涓惧疄渚嬶紝濡傛灉鎵句笉鍒板尮閰嶇殑鍊煎垯杩斿洖null
+ */
+ public static OutBillStatus fromValue(String value) {
+ for (OutBillStatus status : values()) {
+ if (Objects.equals(status.getValue(), value)) {
+ return status;
+ }
+ }
+ return null;
+ }
+}
diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/OutboundDetailMapper.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/OutboundDetailMapper.java
new file mode 100644
index 0000000..ae286fc
--- /dev/null
+++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/OutboundDetailMapper.java
@@ -0,0 +1,41 @@
+package org.jeecg.modules.tms.mapper;
+
+import java.util.List;
+
+import com.baomidou.mybatisplus.core.conditions.Wrapper;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.core.toolkit.Constants;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import org.jeecg.modules.tms.entity.OutboundDetail;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import org.apache.ibatis.annotations.Param;
+import org.jeecg.modules.tms.entity.vo.OutboundDetailVo;
+
+/**
+ * @Description: 鍑哄簱鐢宠鍗曟槑缁�
+ * @Author: jeecg-boot
+ * @Date: 2025-05-16
+ * @Version: V1.0
+ */
+public interface OutboundDetailMapper extends BaseMapper<OutboundDetail> {
+
+ /**
+ * 閫氳繃涓昏〃id鍒犻櫎瀛愯〃鏁版嵁
+ *
+ * @param mainId 涓昏〃id
+ * @return boolean
+ */
+ public boolean deleteByMainId(@Param("mainId") String mainId);
+
+ /**
+ * 閫氳繃涓昏〃id鏌ヨ瀛愯〃鏁版嵁
+ *
+ * @param mainId 涓昏〃id
+ * @return List<OutboundDetail>
+ */
+ public List<OutboundDetail> selectByMainId(@Param("mainId") String mainId);
+
+ IPage<OutboundDetailVo> queryPageList(Page<OutboundDetail> page,
+ @Param(Constants.WRAPPER) Wrapper<OutboundDetail> queryWrapper);
+}
diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/OutboundOrderMapper.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/OutboundOrderMapper.java
new file mode 100644
index 0000000..caa1fd5
--- /dev/null
+++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/OutboundOrderMapper.java
@@ -0,0 +1,21 @@
+package org.jeecg.modules.tms.mapper;
+
+import com.baomidou.mybatisplus.core.conditions.Wrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.core.toolkit.Constants;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import org.apache.ibatis.annotations.Param;
+import org.jeecg.modules.tms.entity.OutboundOrder;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+
+/**
+ * @Description: tms_outbound_order
+ * @Author: jeecg-boot
+ * @Date: 2025-05-16
+ * @Version: V1.0
+ */
+public interface OutboundOrderMapper extends BaseMapper<OutboundOrder> {
+
+ IPage<OutboundOrder> queryPageList(Page<OutboundOrder> page,
+ @Param(Constants.WRAPPER) Wrapper<OutboundOrder> queryWrapper);
+}
diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/OutboundDetailMapper.xml b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/OutboundDetailMapper.xml
new file mode 100644
index 0000000..3f57e85
--- /dev/null
+++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/OutboundDetailMapper.xml
@@ -0,0 +1,101 @@
+<?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="org.jeecg.modules.tms.mapper.OutboundDetailMapper">
+
+ <delete id="deleteByMainId" parameterType="java.lang.String">
+ DELETE
+ FROM tms_outbound_detail
+ WHERE
+ out_storehouse_id = #{mainId}
+ </delete>
+
+ <select id="selectByMainId" parameterType="java.lang.String" resultType="org.jeecg.modules.tms.entity.OutboundDetail">
+ SELECT *
+ FROM tms_outbound_detail
+ WHERE
+ out_storehouse_id = #{mainId}
+ </select>
+ <select id="queryPageList" resultType="org.jeecg.modules.tms.entity.vo.OutboundDetailVo">
+ SELECT
+ t1.id,
+ t1.out_storehouse_id outStorehouseId,
+ t1.tool_code toolCode,
+ t1.tool_id toolId,
+ t2.tool_code toolNum,
+ t1.outbound_quantity outboundQuantity,
+ t1.out_actual_count outActualCount,
+ t1.outbound_time outboundTime,
+ t1.storage_location storageLocation,
+ t1.outbound_location outboundLocation,
+ t1.status,
+ t1.create_by createBy,
+ t1.create_time createTime,
+ t2.chinese_name chineseName,
+ t2.tool_model toolModel,
+ t2.parama_table_name paramaTableName,
+ t3.application_type applicationType,
+ t3.supplier_id supplierId,
+ t11.id toolLedgerDetailId,
+ t11.quantity,
+ ISNULL(t12.warehouse_id, '') + '/' + ISNULL(t12.warehouse_name, '') warehouseName,
+ <choose>
+ <when test="ew.paramNameValuePairs.paramaTableName == '1'">
+ t4.tool_material toolMaterial,
+ t4.part_material partMaterial
+ </when>
+ <when test="ew.paramNameValuePairs.paramaTableName == '2'">
+ t5.tool_material toolMaterial,
+ t5.part_material partMaterial
+ </when>
+ <when test="ew.paramNameValuePairs.paramaTableName == '3'">
+ t6.tool_material toolMaterial,
+ t6.part_material partMaterial
+ </when>
+ <when test="ew.paramNameValuePairs.paramaTableName == '4'">
+ t7.tool_material toolMaterial,
+ t7.part_material partMaterial
+ </when>
+ <when test="ew.paramNameValuePairs.paramaTableName == '5'">
+ t8.tool_material toolMaterial,
+ t8.part_material partMaterial
+ </when>
+ <when test="ew.paramNameValuePairs.paramaTableName == '6'">
+ t9.tool_material toolMaterial,
+ t9.part_material partMaterial
+ </when>
+ <otherwise>
+ t10.tool_material toolMaterial,
+ t10.part_material partMaterial
+ </otherwise>
+ </choose>
+ FROM tms_outbound_detail t1
+ LEFT JOIN tms_base_tools t2 on t1.tool_code = t2.id
+ LEFT JOIN tms_tools_config_property t3 on t3.tool_code = t2.id
+ LEFT JOIN tms_tool_ledger_detail t11 on t1.tool_code = t11.tool_code and t1.tool_id = t11.tool_id
+ LEFT JOIN tms_warehouse t12 on t1.storage_location = t12.id
+ <choose>
+ <when test="ew.paramNameValuePairs.paramaTableName == '1'">
+ LEFT JOIN tms_para_common_tool t4 on t4.tool_code = t2.id
+ </when>
+ <when test="ew.paramNameValuePairs.paramaTableName == '2'">
+ LEFT JOIN tms_para_hole_tools t5 on t5.tool_code = t2.id
+ </when>
+ <when test="ew.paramNameValuePairs.paramaTableName == '3'">
+ LEFT JOIN tms_para_threading_tool t6 on t6.tool_code = t2.id
+ </when>
+ <when test="ew.paramNameValuePairs.paramaTableName == '4'">
+ LEFT JOIN tms_para_mill_tool t7 on t7.tool_code = t2.id
+ </when>
+ <when test="ew.paramNameValuePairs.paramaTableName == '5'">
+ LEFT JOIN tms_para_turning_tools t8 on t8.tool_code = t2.id
+ </when>
+ <when test="ew.paramNameValuePairs.paramaTableName == '6'">
+ LEFT JOIN tms_para_blade t9 on t9.tool_code = t2.id
+ </when>
+ <otherwise>
+ LEFT JOIN tms_para_common_tool t10 on t10.tool_code = t2.id
+ </otherwise>
+ </choose>
+ ${ew.customSqlSegment}
+ </select>
+</mapper>
diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/OutboundOrderMapper.xml b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/OutboundOrderMapper.xml
new file mode 100644
index 0000000..b0ce510
--- /dev/null
+++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/mapper/xml/OutboundOrderMapper.xml
@@ -0,0 +1,25 @@
+<?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="org.jeecg.modules.tms.mapper.OutboundOrderMapper">
+
+ <select id="queryPageList" resultType="org.jeecg.modules.tms.entity.OutboundOrder">
+ SELECT
+ t.id,
+ t.out_num outNum,
+ t.out_storehouse_type outStorehouseType,
+ t.is_return isReturn,
+ t.handler,
+ t.reviewer,
+ t.order_status orderStatus,
+ t.out_status outStatus,
+ t.audit_date auditDate,
+ t.approval_opinion approvalOpinion,
+ t.subject_matter subjectMatter,
+ t.outbound_time outboundTime,
+ t.remark,
+ t.create_by createBy,
+ t.create_time createTime
+ FROM tms_outbound_order t
+ ${ew.customSqlSegment}
+ </select>
+</mapper>
\ No newline at end of file
diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IOutboundDetailService.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IOutboundDetailService.java
new file mode 100644
index 0000000..bd76e67
--- /dev/null
+++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IOutboundDetailService.java
@@ -0,0 +1,29 @@
+package org.jeecg.modules.tms.service;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import org.jeecg.modules.tms.entity.OutboundDetail;
+import com.baomidou.mybatisplus.extension.service.IService;
+import org.jeecg.modules.tms.entity.vo.OutboundDetailVo;
+
+import java.util.List;
+import java.util.Map;
+
+/**
+ * @Description: 鍑哄簱鐢宠鍗曟槑缁�
+ * @Author: jeecg-boot
+ * @Date: 2025-05-16
+ * @Version: V1.0
+ */
+public interface IOutboundDetailService extends IService<OutboundDetail> {
+
+ /**
+ * 閫氳繃涓昏〃id鏌ヨ瀛愯〃鏁版嵁
+ *
+ * @param mainId
+ * @return List<OutboundDetail>
+ */
+ public List<OutboundDetail> selectByMainId(String mainId);
+
+ IPage<OutboundDetailVo> queryPageList(Page<OutboundDetail> page, Map<String, String[]> parameterMap);
+}
diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IOutboundOrderService.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IOutboundOrderService.java
new file mode 100644
index 0000000..08f5698
--- /dev/null
+++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/IOutboundOrderService.java
@@ -0,0 +1,43 @@
+package org.jeecg.modules.tms.service;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import org.jeecg.modules.tms.entity.OutboundDetail;
+import org.jeecg.modules.tms.entity.OutboundOrder;
+import com.baomidou.mybatisplus.extension.service.IService;
+import org.jeecg.modules.tms.entity.dto.OutboundOrderAndDetailDto;
+import org.springframework.beans.factory.annotation.Autowired;
+import java.io.Serializable;
+import java.util.Collection;
+import java.util.List;
+import java.util.Map;
+
+/**
+ * @Description: tms_outbound_order
+ * @Author: jeecg-boot
+ * @Date: 2025-05-16
+ * @Version: V1.0
+ */
+public interface IOutboundOrderService extends IService<OutboundOrder> {
+
+ /**
+ * 鍒犻櫎涓�瀵瑰
+ *
+ * @param id
+ */
+ public void delMain (String id);
+
+ /**
+ * 鎵归噺鍒犻櫎涓�瀵瑰
+ *
+ * @param idList
+ */
+ public void delBatchMain (Collection<? extends Serializable> idList);
+
+
+ void addTotal(OutboundOrderAndDetailDto outboundOrder);
+
+ IPage<OutboundOrder> queryPageList(Page<OutboundOrder> page, Map<String, String[]> parameterMap);
+
+ void editTotal(OutboundOrderAndDetailDto outboundOrder);
+}
diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/OutboundDetailServiceImpl.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/OutboundDetailServiceImpl.java
new file mode 100644
index 0000000..18abddc
--- /dev/null
+++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/OutboundDetailServiceImpl.java
@@ -0,0 +1,44 @@
+package org.jeecg.modules.tms.service.impl;
+
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import org.jeecg.modules.tms.entity.OutboundDetail;
+import org.jeecg.modules.tms.entity.vo.OutboundDetailVo;
+import org.jeecg.modules.tms.mapper.OutboundDetailMapper;
+import org.jeecg.modules.tms.service.IOutboundDetailService;
+import org.springframework.stereotype.Service;
+import java.util.List;
+import java.util.Map;
+
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import org.springframework.beans.factory.annotation.Autowired;
+
+/**
+ * @Description: 鍑哄簱鐢宠鍗曟槑缁�
+ * @Author: jeecg-boot
+ * @Date: 2025-05-16
+ * @Version: V1.0
+ */
+@Service
+public class OutboundDetailServiceImpl extends ServiceImpl<OutboundDetailMapper, OutboundDetail> implements IOutboundDetailService {
+
+ @Autowired
+ private OutboundDetailMapper outboundDetailMapper;
+
+ @Override
+ public List<OutboundDetail> selectByMainId(String mainId) {
+ return outboundDetailMapper.selectByMainId(mainId);
+ }
+
+ @Override
+ public IPage<OutboundDetailVo> queryPageList(Page<OutboundDetail> page, Map<String, String[]> parameterMap) {
+ QueryWrapper<OutboundDetail> queryWrapper = Wrappers.query();
+ String[] outStorehouseIds = parameterMap.get("outStorehouseId");
+ if (outStorehouseIds != null && outStorehouseIds.length > 0) {
+ queryWrapper.eq("t1.out_storehouse_id", outStorehouseIds[0]);
+ }
+ return this.baseMapper.queryPageList(page, queryWrapper);
+ }
+}
diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/OutboundOrderServiceImpl.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/OutboundOrderServiceImpl.java
new file mode 100644
index 0000000..70bb424
--- /dev/null
+++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/OutboundOrderServiceImpl.java
@@ -0,0 +1,136 @@
+package org.jeecg.modules.tms.service.impl;
+
+import cn.hutool.core.bean.BeanUtil;
+import cn.hutool.core.collection.CollectionUtil;
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import org.apache.shiro.SecurityUtils;
+import org.apache.shiro.subject.Subject;
+import org.jeecg.common.system.vo.LoginUser;
+import org.jeecg.modules.system.service.ISysBusinessCodeRuleService;
+import org.jeecg.modules.tms.entity.OutboundOrder;
+import org.jeecg.modules.tms.entity.OutboundDetail;
+import org.jeecg.modules.tms.entity.dto.OutboundOrderAndDetailDto;
+import org.jeecg.modules.tms.enums.OutBillStatus;
+import org.jeecg.modules.tms.mapper.OutboundDetailMapper;
+import org.jeecg.modules.tms.mapper.OutboundOrderMapper;
+import org.jeecg.modules.tms.service.IOutboundDetailService;
+import org.jeecg.modules.tms.service.IOutboundOrderService;
+import org.springframework.stereotype.Service;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.transaction.annotation.Transactional;
+import java.io.Serializable;
+import java.util.List;
+import java.util.Collection;
+import java.util.Map;
+import java.util.Objects;
+
+/**
+ * @Description: tms_outbound_order
+ * @Author: jeecg-boot
+ * @Date: 2025-05-16
+ * @Version: V1.0
+ */
+@Service
+public class OutboundOrderServiceImpl extends ServiceImpl<OutboundOrderMapper, OutboundOrder> implements IOutboundOrderService {
+
+ @Autowired
+ private IOutboundDetailService outboundDetailService;
+ @Autowired
+ private ISysBusinessCodeRuleService businessCodeRuleService;
+ @Autowired
+ private OutboundOrderMapper outboundOrderMapper;
+ @Autowired
+ private OutboundDetailMapper outboundDetailMapper;
+
+ @Override
+ @Transactional(rollbackFor = Exception.class)
+ public void delMain(String id) {
+ outboundDetailMapper.deleteByMainId(id);
+ outboundOrderMapper.deleteById(id);
+ }
+
+ @Override
+ @Transactional(rollbackFor = Exception.class)
+ public void delBatchMain(Collection<? extends Serializable> idList) {
+ for(Serializable id:idList) {
+ outboundDetailMapper.deleteByMainId(id.toString());
+ outboundOrderMapper.deleteById(id);
+ }
+ }
+
+ @Override
+ @Transactional(rollbackFor = Exception.class)
+ public void addTotal(OutboundOrderAndDetailDto outboundOrder) {
+ OutboundOrder order = BeanUtil.copyProperties(outboundOrder, OutboundOrder.class);
+ order.setHandler(Objects.requireNonNull(getCurrentUser()).getId());
+ order.setOutNum(businessCodeRuleService.generateBusinessCodeSeq("outBoundOrder"));
+ order.setOrderStatus(OutBillStatus.DRAFT.getValue());
+ save(order);
+ List<OutboundDetail> detailList = CollectionUtil.newArrayList();
+ outboundOrder.getOutboundDetailList().forEach(item->{
+ item.setOutStorehouseId(order.getId());
+ detailList.add(item);
+ });
+ outboundDetailService.saveBatch(detailList);
+ }
+
+ @Override
+ public IPage<OutboundOrder> queryPageList(Page<OutboundOrder> page, Map<String, String[]> parameterMap) {
+ QueryWrapper<OutboundOrder> queryWrapper = Wrappers.query();
+ String[] outNums = parameterMap.get("outNum");
+ if (outNums != null && outNums.length > 0) {
+ queryWrapper.like("t.out_num", outNums[0]);
+ }
+ String[] outStorehouseTypes = parameterMap.get("outStorehouseType");
+ if (outStorehouseTypes != null && outStorehouseTypes.length > 0) {
+ queryWrapper.eq("t.out_storehouse_type", outStorehouseTypes[0]);
+ }
+ String[] statuses = parameterMap.get("orderStatus");
+ if (statuses != null && statuses.length > 0) {
+ queryWrapper.eq("t.order_status", statuses[0]);
+ }
+ String[] startTimes = parameterMap.get("startTime");
+ if (startTimes != null && startTimes.length > 0) {
+ queryWrapper.ge("t.create_time", startTimes[0]);
+ }
+ String[] endTimes = parameterMap.get("endTime");
+ if (endTimes != null && endTimes.length > 0) {
+ queryWrapper.le("t.create_time", endTimes[0]);
+ }
+ queryWrapper.orderByDesc("t.create_time");
+ return this.baseMapper.queryPageList(page, queryWrapper);
+ }
+
+ @Override
+ @Transactional(rollbackFor = Exception.class)
+ public void editTotal(OutboundOrderAndDetailDto outboundOrder) {
+ //鍒犻櫎鎵�鏈夋槑缁�
+ outboundDetailService.remove(new LambdaQueryWrapper<OutboundDetail>()
+ .eq(OutboundDetail::getOutStorehouseId, outboundOrder.getId()));
+ OutboundOrder outboundOrderUpdate = BeanUtil.copyProperties(outboundOrder, OutboundOrder.class);
+ outboundOrderMapper.updateById(outboundOrderUpdate);
+ List<OutboundDetail> detailList = CollectionUtil.newArrayList();
+ outboundOrder.getOutboundDetailList().forEach(item->{
+ item.setOutStorehouseId(outboundOrderUpdate.getId());
+ detailList.add(item);
+ });
+ outboundDetailService.saveBatch(detailList);
+ }
+
+ private LoginUser getCurrentUser() {
+ // 鑾峰彇褰撳墠璁よ瘉鐨勭櫥褰曠敤鎴蜂俊鎭�
+ Subject currentUser = SecurityUtils.getSubject();
+ if (currentUser != null && currentUser.isAuthenticated()) {
+ Object principal = currentUser.getPrincipal();
+ if (principal instanceof LoginUser) {
+ return (LoginUser) principal;
+ }
+ }
+ return null;
+ }
+}
diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolLedgerDetailServiceImpl.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolLedgerDetailServiceImpl.java
index 47d6b53..284b226 100644
--- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolLedgerDetailServiceImpl.java
+++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/ToolLedgerDetailServiceImpl.java
@@ -8,9 +8,7 @@
import org.jeecg.modules.tms.mapper.ToolLedgerDetailMapper;
import org.jeecg.modules.tms.service.IToolLedgerDetailService;
import org.springframework.stereotype.Service;
-
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
-
import java.util.Map;
/**
@@ -33,6 +31,11 @@
if (statuses != null && statuses.length > 0) {
queryWrapper.eq("t.status", statuses[0]);
}
+ String[] excludeIds = parameterMap.get("excludeIds");
+ if (excludeIds != null && excludeIds.length > 0) {
+ String[] idArray = excludeIds[0].split(",");
+ queryWrapper.notIn("t.id", idArray);
+ }
return this.baseMapper.queryPageList(page, queryWrapper);
}
}
--
Gitblit v1.9.3