From 22594e714c57c9e243fe9973515ea9467d71c2db Mon Sep 17 00:00:00 2001
From: Fixiaobai <fixiaobai@163.com>
Date: 星期二, 07 十一月 2023 18:35:11 +0800
Subject: [PATCH] Changes11
---
mes-basic/src/main/java/com/chinaztt/mes/basic/controller/PostController.java | 31 +++++++++++++++++++++++++++++++
1 files changed, 31 insertions(+), 0 deletions(-)
diff --git a/mes-basic/src/main/java/com/chinaztt/mes/basic/controller/PostController.java b/mes-basic/src/main/java/com/chinaztt/mes/basic/controller/PostController.java
index f48baa4..71a9057 100644
--- a/mes-basic/src/main/java/com/chinaztt/mes/basic/controller/PostController.java
+++ b/mes-basic/src/main/java/com/chinaztt/mes/basic/controller/PostController.java
@@ -1,7 +1,13 @@
package com.chinaztt.mes.basic.controller;
+import com.alibaba.excel.EasyExcel;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.chinaztt.mes.basic.entity.Post;
+import com.chinaztt.mes.basic.excel.PostData;
+import com.chinaztt.mes.basic.excel.PostUploadListener;
+import com.chinaztt.mes.basic.excel.StaffData;
+import com.chinaztt.mes.basic.excel.StaffUploadListener;
import com.chinaztt.mes.basic.service.PostService;
import com.chinaztt.mes.common.wrapper.QueryWrapperUtil;
import com.chinaztt.ztt.common.core.util.R;
@@ -11,6 +17,9 @@
import lombok.AllArgsConstructor;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.web.bind.annotation.*;
+import org.springframework.web.multipart.MultipartFile;
+
+import java.io.IOException;
/**
@@ -109,4 +118,26 @@
return R.ok(postService.removeById(id));
}
+ @GetMapping("/getObjById")
+ public R getObjById(Long id ,Long factoryId ,Long divisionId){
+ QueryWrapper<Post>queryWrapper=new QueryWrapper<>();
+ queryWrapper.lambda().eq(Post::getCompanyId,id).eq(Post::getFactoryId,factoryId).eq(Post::getDivisionId,divisionId);
+ return R.ok(postService.list(queryWrapper));
+ }
+
+ /**
+ * excel涓婁紶
+ *
+ * @return
+ */
+ @PostMapping("/upload")
+ public R upload(@RequestParam("file") MultipartFile file) {
+ try {
+ EasyExcel.read(file.getInputStream(), PostData.class, new PostUploadListener(postService)).sheet().doRead();
+ } catch (IOException e) {
+ e.printStackTrace();
+ }
+ return R.ok();
+ }
+
}
--
Gitblit v1.9.3