From 4f3a98f19143865cdc1de4791e8a95d96bd40c65 Mon Sep 17 00:00:00 2001
From: maven <2163098428@qq.com>
Date: 星期五, 01 八月 2025 13:27:59 +0800
Subject: [PATCH] yys 密码已重置

---
 cnas-require/src/main/java/com/ruoyi/require/controller/FeCalibrationScheduleController.java |   97 ++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 97 insertions(+), 0 deletions(-)

diff --git a/cnas-require/src/main/java/com/ruoyi/require/controller/FeCalibrationScheduleController.java b/cnas-require/src/main/java/com/ruoyi/require/controller/FeCalibrationScheduleController.java
new file mode 100644
index 0000000..722cceb
--- /dev/null
+++ b/cnas-require/src/main/java/com/ruoyi/require/controller/FeCalibrationScheduleController.java
@@ -0,0 +1,97 @@
+package com.ruoyi.require.controller;
+
+import com.alibaba.excel.EasyExcel;
+import com.alibaba.excel.read.listener.PageReadListener;
+import com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy;
+import com.alibaba.fastjson.JSONObject;
+import com.alibaba.fastjson2.JSON;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ruoyi.common.core.domain.Result;
+import com.ruoyi.require.excel.FeCalibrationScheduleExport;
+import com.ruoyi.require.pojo.FeCalibrationSchedule;
+import com.ruoyi.require.service.FeCalibrationScheduleService;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import org.springframework.web.bind.annotation.*;
+import org.springframework.web.multipart.MultipartFile;
+
+import javax.annotation.Resource;
+import javax.servlet.http.HttpServletResponse;
+import java.io.IOException;
+import java.util.List;
+
+/**
+ * <p>
+ *
+ * </p>
+ *
+ * @author 
+ * @since 2024-11-13 02:53:05
+ */
+@Api(tags = "閲忓�兼函婧愯鍒�")
+@RestController
+@RequestMapping("/feCalibrationSchedule")
+public class FeCalibrationScheduleController {
+
+    @Resource
+    private FeCalibrationScheduleService feCalibrationScheduleService;
+
+    @ApiOperation(value = "閲忓�兼函婧愯鍒掓煡璇�")
+    @GetMapping("/getPageCalibrationSchedule")
+    public Result<IPage<FeCalibrationSchedule>> getPageCalibrationSchedule(Page page, String instrumentName, String managementNumber) {
+        IPage<FeCalibrationSchedule> ipage = feCalibrationScheduleService.page(page,instrumentName, managementNumber);
+        return Result.success(ipage);
+    }
+
+    @ApiOperation(value = "閲忓�兼函婧愯鍒掓柊澧炵紪杈�")
+    @PostMapping("/addCalibrationSchedule")
+    public Result addCalibrationSchedule(@RequestBody FeCalibrationSchedule feCalibrationSchedule) {
+        return Result.success(feCalibrationScheduleService.saveOrUpdate(feCalibrationSchedule));
+    }
+
+    @ApiOperation(value = "閲忓�兼函婧愯鍒掑垹闄�")
+    @GetMapping("/removeCalibrationSchedule")
+    public Result removeCalibrationSchedule(Integer id) {
+        return Result.success(feCalibrationScheduleService.removeById(id));
+    }
+
+
+    @ApiOperation(value = "閲忓�兼函婧愯鍒掑鍑�")
+    @PostMapping("exportOfValueTraceabilityPlan")
+    public void exportOfValueTraceabilityPlan(String instrumentName, String managementNumber,
+                                       HttpServletResponse response) throws Exception {
+        IPage<FeCalibrationSchedule> data = feCalibrationScheduleService.page(new Page<>(1, -1),instrumentName, managementNumber);
+        List<FeCalibrationScheduleExport> studentList  = JSONObject.parseArray(JSON.toJSONString(data.getRecords()), FeCalibrationScheduleExport.class);
+        response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
+        response.setHeader("requestType", "excel");
+        response.setHeader("Access-Control-Expose-Headers", "requestType");
+        // 璁剧疆鍗曞厓鏍兼牱寮�
+        // 淇濆瓨鍒扮涓�涓猻heet涓�
+        EasyExcel.write(response.getOutputStream())
+                .head(FeCalibrationScheduleExport.class)
+                .registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()) // 鑷�傚簲鍒楀
+                .sheet("sheet")
+                .doWrite(studentList);
+    }
+
+    @ApiOperation(value = "importOfValueTraceabilityPlan")
+    @PostMapping("/importOfValueTraceabilityPlan")
+    public void importOfValueTraceabilityPlan(MultipartFile file) throws IOException {
+        if (file.isEmpty()) {
+            return;
+        }
+        EasyExcel.read(file.getInputStream(), FeCalibrationScheduleExport.class, new PageReadListener<FeCalibrationScheduleExport>(dataList -> {
+            List<FeCalibrationSchedule> studentList  = JSONObject.parseArray(JSON.toJSONString(dataList), FeCalibrationSchedule.class);
+            feCalibrationScheduleService.saveOrUpdateBatch(studentList);
+        })).sheet().doRead();
+    }
+
+
+//    Equipment quantity traceability management
+    @ApiOperation(value = "閲忓�兼函婧愯鍒掑鍑簑ord")
+    @GetMapping("/exportWordOfValueTraceabilityPlan")
+    public void exportWordOfValueTraceabilityPlan(HttpServletResponse response) throws IOException {
+        feCalibrationScheduleService.exportWordOfValueTraceabilityPlan(response);
+    }
+}

--
Gitblit v1.9.3