From 1ebe2726a5f8fe55f01481b37d1ac1f75a088520 Mon Sep 17 00:00:00 2001
From: Crunchy <3114200645@qq.com>
Date: 星期四, 25 四月 2024 16:34:23 +0800
Subject: [PATCH] 2024-4-25 资源要求-设备管理后端调整
---
cnas-server/src/main/java/com/yuanchu/mom/mapper/DeviceMapper.java | 7
cnas-server/src/main/java/com/yuanchu/mom/service/impl/LaboratoryServiceImpl.java | 2
cnas-server/src/main/resources/mapper/DeviceMapper.xml | 53 ++------
cnas-server/src/main/java/com/yuanchu/mom/dto/DeviceDto.java | 26 ++++
framework/src/main/java/com/yuanchu/mom/controller/InformationNotificationController.java | 12 +-
cnas-server/src/main/java/com/yuanchu/mom/controller/DepartmentController.java | 8
cnas-server/src/main/java/com/yuanchu/mom/mapper/DepartmentMapper.java | 2
cnas-server/src/main/java/com/yuanchu/mom/service/impl/DeviceServiceImpl.java | 9 +
cnas-server/src/main/java/com/yuanchu/mom/controller/CertificationController.java | 6
cnas-server/src/main/java/com/yuanchu/mom/controller/DeviceController.java | 3
cnas-server/src/main/java/com/yuanchu/mom/service/DeviceService.java | 3
cnas-server/src/main/java/com/yuanchu/mom/controller/CapacityScopeController.java | 20 +-
cnas-server/src/main/java/com/yuanchu/mom/pojo/Device.java | 152 +++++++++---------------
13 files changed, 137 insertions(+), 166 deletions(-)
diff --git a/cnas-server/src/main/java/com/yuanchu/mom/controller/CapacityScopeController.java b/cnas-server/src/main/java/com/yuanchu/mom/controller/CapacityScopeController.java
index 9b01b9d..1baa094 100644
--- a/cnas-server/src/main/java/com/yuanchu/mom/controller/CapacityScopeController.java
+++ b/cnas-server/src/main/java/com/yuanchu/mom/controller/CapacityScopeController.java
@@ -29,7 +29,7 @@
private CapacityScopeService capacityScopeService;
- @ApiOperation(value = "鑾峰彇椤圭洰妫�楠屽弬鏁板垪琛�")
+ @ApiOperation(value = "鑳藉姏鑼冨洿-鑾峰彇椤圭洰妫�楠屽弬鏁板垪琛�")
@PostMapping("/selectItemParameterList")
public Result selectItemParameterList(@RequestBody Map<String, Object> data) throws Exception {
Page page = JackSonUtil.unmarshal(JackSonUtil.marshal(data.get("page")), Page.class);
@@ -37,25 +37,25 @@
return Result.success(capacityScopeService.selectItemParameterList(page, itemParameter));
}
- @ApiOperation(value = "娣诲姞椤圭洰妫�楠屽弬鏁�")
+ @ApiOperation(value = "鑳藉姏鑼冨洿-娣诲姞椤圭洰妫�楠屽弬鏁�")
@PostMapping("/addItemParameter")
public Result addItemParameter(@RequestBody StructureItemParameter itemParameter) {
return Result.success(capacityScopeService.addItemParameter(itemParameter));
}
- @ApiOperation(value = "鍒犻櫎椤圭洰妫�楠屽弬鏁�")
+ @ApiOperation(value = "鑳藉姏鑼冨洿-鍒犻櫎椤圭洰妫�楠屽弬鏁�")
@PostMapping("/delItemParameter")
public Result<?> delItemParameter(Integer id) {
return Result.success(capacityScopeService.delItemParameter(id));
}
- @ApiOperation(value = "淇敼椤圭洰妫�楠屽弬鏁�")
+ @ApiOperation(value = "鑳藉姏鑼冨洿-淇敼椤圭洰妫�楠屽弬鏁�")
@PostMapping("/upItemParameter")
public Result<?> upItemParameter(@RequestBody StructureItemParameter itemParameter) {
return Result.success(capacityScopeService.upItemParameter(itemParameter));
}
- @ApiOperation(value = "鑾峰彇妫�楠屽璞�")
+ @ApiOperation(value = "鑳藉姏鑼冨洿-鑾峰彇妫�楠屽璞�")
@PostMapping("/selectTestObjectList")
public Result selectTestObjectList(@RequestBody Map<String, Object> data) throws Exception {
Page page = JackSonUtil.unmarshal(JackSonUtil.marshal(data.get("page")), Page.class);
@@ -63,32 +63,32 @@
return Result.success(capacityScopeService.selectTestObjectList(page, pageTestObjectDto));
}
- @ApiOperation(value = "娣诲姞妫�楠屽璞�")
+ @ApiOperation(value = "鑳藉姏鑼冨洿-娣诲姞妫�楠屽璞�")
@PostMapping("/addTestObject")
public Result addTestObject(@RequestBody StructureTestObject testObject) {
return Result.success(capacityScopeService.addTestObject(testObject));
}
- @ApiOperation(value = "鍒犻櫎妫�楠屽璞�")
+ @ApiOperation(value = "鑳藉姏鑼冨洿-鍒犻櫎妫�楠屽璞�")
@PostMapping("/delTestObject")
public Result<?> delTestObject(Integer id) {
return Result.success(capacityScopeService.delTestObject(id));
}
- @ApiOperation(value = "淇敼妫�楠屽璞�")
+ @ApiOperation(value = "鑳藉姏鑼冨洿-淇敼妫�楠屽璞�")
@PostMapping("/upTestObject")
public Result upTestObject(@RequestBody StructureTestObject testObject) {
return Result.success(capacityScopeService.upTestObject(testObject));
}
- @ApiOperation(value = "鑾峰彇妫�楠屽璞℃灇涓�")
+ @ApiOperation(value = "鑳藉姏鑼冨洿-鑾峰彇妫�楠屽璞℃灇涓�")
@GetMapping("/selectTestObjectByName")
@ValueAuth
public Result selectTestObjectByName() {
return Result.success(capacityScopeService.selectTestObjectByName());
}
- @ApiOperation(value = "璁惧閲岄潰閫夋嫨妫�楠岄」鐩�(鏍戝舰缁撴瀯)")
+ @ApiOperation(value = "鑳藉姏鑼冨洿-璁惧閲岄潰閫夋嫨妫�楠岄」鐩�(鏍戝舰缁撴瀯)")
@PostMapping("/getInsProduction")
public Result getInsProduction(){
return Result.success(capacityScopeService.getInsProduction());
diff --git a/cnas-server/src/main/java/com/yuanchu/mom/controller/CertificationController.java b/cnas-server/src/main/java/com/yuanchu/mom/controller/CertificationController.java
index b9ebb9c..7468a13 100644
--- a/cnas-server/src/main/java/com/yuanchu/mom/controller/CertificationController.java
+++ b/cnas-server/src/main/java/com/yuanchu/mom/controller/CertificationController.java
@@ -26,7 +26,7 @@
private CertificationService certificationService;
- @ApiOperation(value = "鏌ヨ璧勮川鏄庣粏鍒楄〃")
+ @ApiOperation(value = "璧勮川璇存槑-鏌ヨ璧勮川鏄庣粏鍒楄〃")
@PostMapping("/getCertificationDetail")
@ValueAuth
public Result getCertificationDetail(@RequestBody Map<String, Object> data) throws Exception {
@@ -35,13 +35,13 @@
return Result.success(certificationService.getCertificationDetail(page, certification));
}
- @ApiOperation(value = "娣诲姞璧勮川鏄庣粏鍒楄〃")
+ @ApiOperation(value = "璧勮川璇存槑-娣诲姞璧勮川鏄庣粏鍒楄〃")
@PostMapping("/addCertificationDetail")
public Result addCertificationDetail(@RequestBody Certification certification) {
return Result.success(certificationService.addCertificationDetail(certification));
}
- @ApiOperation(value = "鍒犻櫎璧勮川鏄庣粏鍒楄〃")
+ @ApiOperation(value = "璧勮川璇存槑-鍒犻櫎璧勮川鏄庣粏鍒楄〃")
@PostMapping("/delCertificationDetail")
public Result<?> delCertificationDetail( String ids) {
return Result.success(certificationService.delCertificationDetail(ids));
diff --git a/cnas-server/src/main/java/com/yuanchu/mom/controller/DepartmentController.java b/cnas-server/src/main/java/com/yuanchu/mom/controller/DepartmentController.java
index f02883a..444c062 100644
--- a/cnas-server/src/main/java/com/yuanchu/mom/controller/DepartmentController.java
+++ b/cnas-server/src/main/java/com/yuanchu/mom/controller/DepartmentController.java
@@ -32,25 +32,25 @@
DepartmentService departmentService;
- @ApiOperation(value = "娣诲姞閮ㄩ棬")
+ @ApiOperation(value = "浜哄憳鏄庣粏-娣诲姞閮ㄩ棬")
@PostMapping("/addDepartment")
public Result addDepartment(@RequestBody Department department) {
return Result.success(departmentService.addDepartment(department));
}
- @ApiOperation(value = "鑾峰彇閮ㄩ棬鏍�")
+ @ApiOperation(value = "浜哄憳鏄庣粏-鑾峰彇閮ㄩ棬鏍�")
@GetMapping("/selectDepartment")
public Result selectDepartment() {
return Result.success(departmentService.selectDepartment());
}
- @ApiOperation(value = "鍒犻櫎閮ㄩ棬")
+ @ApiOperation(value = "浜哄憳鏄庣粏-鍒犻櫎閮ㄩ棬")
@PostMapping("/delDepartment")
public Result delDepartment(Integer id) {
return Result.success(departmentService.delDepartment(id));
}
- @ApiOperation(value = "鏍规嵁閫夋嫨鐨勬爲灞曠ず鐩稿叧鐨勪汉鍛�")
+ @ApiOperation(value = "浜哄憳鏄庣粏-鏍规嵁閫夋嫨鐨勬爲灞曠ず鐩稿叧鐨勪汉鍛�")
@PostMapping("/showUserById")
public Result showUserById(@RequestBody Map<String, Object> data) throws Exception {
Page page = JackSonUtil.unmarshal(JackSonUtil.marshal(data.get("page")), Page.class);
diff --git a/cnas-server/src/main/java/com/yuanchu/mom/controller/DeviceController.java b/cnas-server/src/main/java/com/yuanchu/mom/controller/DeviceController.java
index d4ca573..6715974 100644
--- a/cnas-server/src/main/java/com/yuanchu/mom/controller/DeviceController.java
+++ b/cnas-server/src/main/java/com/yuanchu/mom/controller/DeviceController.java
@@ -4,6 +4,7 @@
import cn.hutool.core.lang.UUID;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.yuanchu.mom.annotation.ValueAuth;
+import com.yuanchu.mom.dto.DeviceDto;
import com.yuanchu.mom.pojo.Device;
import com.yuanchu.mom.service.DeviceService;
import com.yuanchu.mom.utils.JackSonUtil;
@@ -40,7 +41,7 @@
@PostMapping("/selectDeviceParameter")
public Result selectDeviceParameter(@RequestBody Map<String, Object> data) throws Exception {
Page page = JackSonUtil.unmarshal(JackSonUtil.marshal(data.get("page")), Page.class);
- Device itemParameter = JackSonUtil.unmarshal(JackSonUtil.marshal(data.get("entity")), Device.class);
+ DeviceDto itemParameter = JackSonUtil.unmarshal(JackSonUtil.marshal(data.get("entity")), DeviceDto.class);
return Result.success(deviceService.selectDeviceParameter(page, itemParameter));
}
diff --git a/cnas-server/src/main/java/com/yuanchu/mom/dto/DeviceDto.java b/cnas-server/src/main/java/com/yuanchu/mom/dto/DeviceDto.java
new file mode 100644
index 0000000..8bd8ce8
--- /dev/null
+++ b/cnas-server/src/main/java/com/yuanchu/mom/dto/DeviceDto.java
@@ -0,0 +1,26 @@
+package com.yuanchu.mom.dto;
+
+import com.yuanchu.mom.annotation.ValueTableShow;
+import com.yuanchu.mom.pojo.Device;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.AllArgsConstructor;
+import lombok.Data;
+import lombok.NoArgsConstructor;
+
+@Data
+@AllArgsConstructor
+@NoArgsConstructor
+public class DeviceDto extends Device {
+
+ @ValueTableShow(10)
+ @ApiModelProperty(value = "绠＄悊浜�")
+ private String equipmentManagerUser;
+
+ @ValueTableShow(value = 12, name = "鎵�灞為儴闂�")
+ @ApiModelProperty(value = "鎵�灞為儴闂�")
+ private String laboratoryName;
+
+ @ValueTableShow(13)
+ @ApiModelProperty(value = "妫�楠岄」鐩�")
+ private Integer insProductItem;
+}
diff --git a/cnas-server/src/main/java/com/yuanchu/mom/mapper/DepartmentMapper.java b/cnas-server/src/main/java/com/yuanchu/mom/mapper/DepartmentMapper.java
index f998d90..f38205a 100644
--- a/cnas-server/src/main/java/com/yuanchu/mom/mapper/DepartmentMapper.java
+++ b/cnas-server/src/main/java/com/yuanchu/mom/mapper/DepartmentMapper.java
@@ -2,12 +2,10 @@
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
-import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.yuanchu.mom.dto.DepartmentDto;
import com.yuanchu.mom.dto.UserDto;
import com.yuanchu.mom.pojo.Department;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
-import com.yuanchu.mom.pojo.User;
import org.apache.ibatis.annotations.Param;
import java.util.List;
diff --git a/cnas-server/src/main/java/com/yuanchu/mom/mapper/DeviceMapper.java b/cnas-server/src/main/java/com/yuanchu/mom/mapper/DeviceMapper.java
index a07992d..b84efc7 100644
--- a/cnas-server/src/main/java/com/yuanchu/mom/mapper/DeviceMapper.java
+++ b/cnas-server/src/main/java/com/yuanchu/mom/mapper/DeviceMapper.java
@@ -4,8 +4,9 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.yuanchu.mom.dto.DeviceDto;
import com.yuanchu.mom.pojo.Device;
-import org.springframework.data.repository.query.Param;
+import org.apache.ibatis.annotations.Param;
import java.util.List;
@@ -16,9 +17,6 @@
IPage<Device> selectDeviceParameter(Page page, QueryWrapper<Device> ew);
List<Device> selectEquipmentOverview(Page page, QueryWrapper<Device> ew);
-
- //鏇存柊
- int upDeviceParameter(Device itemParameter);
//鑾峰彇琚巿鏉冧汉
List<Device> authorizedPerson();
@@ -33,5 +31,6 @@
//鏌ヨ璁惧璐熻矗浜�
List<Device> selectDevicePrincipal();
+ IPage<DeviceDto> selectDeviceParameterPage(Page page, @Param("ew") QueryWrapper<DeviceDto> queryWrappers);
}
diff --git a/cnas-server/src/main/java/com/yuanchu/mom/pojo/Device.java b/cnas-server/src/main/java/com/yuanchu/mom/pojo/Device.java
index b67eb1b..03d5367 100644
--- a/cnas-server/src/main/java/com/yuanchu/mom/pojo/Device.java
+++ b/cnas-server/src/main/java/com/yuanchu/mom/pojo/Device.java
@@ -8,6 +8,7 @@
import lombok.Data;
import java.io.Serializable;
+import java.math.BigDecimal;
import java.time.LocalDate;
import java.time.LocalDateTime;
@@ -21,113 +22,83 @@
@TableId(type = IdType.AUTO)
private Integer id;
- //@ValueTableShow(2)
- @ApiModelProperty(value = "澶х被")
- private String largeCategory;
-
- @ValueTableShow(13)
- @ApiModelProperty(value = "鍑哄巶鏃ユ湡")
- @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
- private String dateProduction;
-
- @ValueTableShow(4)
- @ApiModelProperty(value = "璁惧璐熻矗浜�")
- private Integer equipmentManager;
-
- @ValueTableShow(5)
- @ApiModelProperty(value = "琚巿鏉冧汉")
- private String authorizedPerson;
-
@ValueTableShow(1)
@ApiModelProperty(value = "璁惧鍚嶇О")
private String deviceName;
- @ValueTableShow(7)
- @ApiModelProperty(value = "鍐呴儴缂栫爜")
- private String internalCode;
+ @ValueTableShow(value = 2, name = "en璁惧鍚嶇О")
+ @ApiModelProperty(value = "en璁惧鍚嶇О")
+ private String enDeviceName;
- @ValueTableShow(8)
- @ApiModelProperty(value = "璧勪骇缂栫爜")
- private String assetCode;
+ @ValueTableShow(3)
+ @ApiModelProperty(value = "瑙勬牸鍨嬪彿")
+ private String specificationModel;
- @ValueTableShow(9)
- @ApiModelProperty(value = "鏍″噯鏃ユ湡锛堟湀锛�")
- private String calibrationDate;
+ @ValueTableShow(4)
+ @ApiModelProperty(value = "鐢熶骇鍘傚")
+ private String manufacturer;
- @ValueTableShow(10)
- @ApiModelProperty(value = "鎶ュ簾鏃ユ湡")
- @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
- private LocalDateTime scrapTime;
-
- @ValueTableShow(11)
- @ApiModelProperty(value = "楠屾敹璁板綍")
- private String acceptanceRecords;
-
- @ValueTableShow(12)
- @ApiModelProperty(value = "缁嗙被")
- private String subclass;
-
- @ValueTableShow(13)
- @ApiModelProperty(value = "璁惧缂栫爜")
+ @ValueTableShow(5)
+ @ApiModelProperty(value = "鍑哄巶缂栧彿")
private String factoryNo;
- @ValueTableShow(14)
+ @ValueTableShow(value = 6, name = "绠＄悊缂栧彿")
+ @ApiModelProperty(value = "绠＄悊缂栧彿")
+ private String managementNumber;
+
+ @ValueTableShow(value = 7, name = "鎶�鏈寚鏍�")
+ @ApiModelProperty(value = "鎶�鏈寚鏍�")
+ private String technicalIndicators;
+
+ @ValueTableShow(8)
@ApiModelProperty(value = "璐疆鏃ユ湡")
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
private String acquisitionDate;
- @ValueTableShow(15)
- @ApiModelProperty(value = "鍑嗙‘搴﹂噺鍊�")
- private String accurateMeasurement;
+ @ValueTableShow(value = 9, name = "鍚敤鏃ユ湡")
+ @ApiModelProperty(value = "鍚敤鏃ユ湡")
+ private LocalDateTime activationDate;
- @ValueTableShow(16)
- @ApiModelProperty(value = "澶囨敞")
- private String notes;
+ @ApiModelProperty(value = "绠＄悊浜篒d")
+ private Integer equipmentManager;
- @ValueTableShow(17)
- @ApiModelProperty(value = "瑙勬牸鍨嬪彿")
- private String specificationModel;
-
- @ValueTableShow(6)
- @ApiModelProperty(value = "璁惧鐘舵��")
- private Integer deviceStatus;
-
- @ValueTableShow(19)
+ @ValueTableShow(11)
@ApiModelProperty(value = "瀛樻斁鐐�")
private String storagePoint;
+ @ApiModelProperty(value = "鎵�灞為儴闂↖d")
+ private Integer subordinateDepartmentsId;
+
+ @ApiModelProperty(value = "妫�楠岄」鐩甀d")
+ private String insProductIds;
+
+ @ValueTableShow(value = 14, name = "鏍″噯鏈嶅姟鏈烘瀯")
+ @ApiModelProperty(value = "鏍″噯鏈嶅姟鏈烘瀯")
+ private String calibrationServices;
+
+ @ValueTableShow(value = 15, name = "鏈�杩戞牎鍑嗘棩鏈�")
+ @ApiModelProperty(value = "鏈�杩戞牎鍑嗘棩鏈�")
+ private LocalDateTime lastCalibrationDate;
+
+ @ValueTableShow(value = 16, name = "涓嬫鏍″噯鏃ユ湡")
+ @ApiModelProperty(value = "涓嬫鏍″噯鏃ユ湡")
+ private LocalDateTime nextCalibrationDate;
+
+ @ValueTableShow(value = 17, name = "璁惧鍒嗙被")
+ @ApiModelProperty(value = "璁惧绫诲瀷")
+ private String largeCategory;
+
+ @ValueTableShow(value = 18, name = "鍗曚环")
+ @ApiModelProperty(value = "鍗曚环")
+ private BigDecimal unitPrice;
+
+ @ValueTableShow(19)
+ @ApiModelProperty(value = "璁惧鐘舵��")
+ private Integer deviceStatus;
+
@ValueTableShow(20)
- @ApiModelProperty(value = "鏈�杩戣拷婧棩鏈�")
- @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
- private LocalDateTime latestTraceability;
-
- @ValueTableShow(21)
- @ApiModelProperty(value = "鍋滅敤鏃堕棿")
- @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
- private LocalDateTime downTime;
-
- @ValueTableShow(22)
- @ApiModelProperty(value = "缁翠慨璁板綍")
- private String maintenanceRecords;
-
- @ValueTableShow(23)
- @ApiModelProperty(value = "鐢熶骇鍘傚")
- private String manufacturer;
-
- @ValueTableShow(24)
- @ApiModelProperty(value = "妫�娴嬬被鍨�")
- private String detectionType;
-
- @ValueTableShow(25)
- @ApiModelProperty(value = "閲囪喘璐圭敤")
- private String procurementCosts;
-
- @ValueTableShow(26)
- @ApiModelProperty(value = "鏍″噯璇佷功")
- private String calibrationCerticate;
-
- @ApiModelProperty(value = "鐘舵��")
- private Integer status;
+ @ApiModelProperty(value = "鏍″噯鍛ㄦ湡锛堟湀锛�")
+ private String calibrationDate;
@ApiModelProperty(value = "鍥剧墖涓婁紶")
private String imageUpload;
@@ -148,9 +119,4 @@
@TableField(fill = FieldFill.INSERT)
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
private LocalDateTime createTime;
-
- @ValueTableShow(12)
- @ApiModelProperty(value = "妫�楠岄」鐩�")
- private String insProductIds;
-
}
diff --git a/cnas-server/src/main/java/com/yuanchu/mom/service/DeviceService.java b/cnas-server/src/main/java/com/yuanchu/mom/service/DeviceService.java
index 7ade738..0c90826 100644
--- a/cnas-server/src/main/java/com/yuanchu/mom/service/DeviceService.java
+++ b/cnas-server/src/main/java/com/yuanchu/mom/service/DeviceService.java
@@ -2,6 +2,7 @@
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.IService;
+import com.yuanchu.mom.dto.DeviceDto;
import com.yuanchu.mom.pojo.Device;
import java.util.List;
@@ -12,7 +13,7 @@
*/
public interface DeviceService extends IService<Device> {
- Map<String, Object> selectDeviceParameter(Page page, Device itemParameter);
+ Map<String, Object> selectDeviceParameter(Page page, DeviceDto itemParameter);
int addDeviceParameter(Device itemParameter);
diff --git a/cnas-server/src/main/java/com/yuanchu/mom/service/impl/DeviceServiceImpl.java b/cnas-server/src/main/java/com/yuanchu/mom/service/impl/DeviceServiceImpl.java
index c833734..9b7ce3c 100644
--- a/cnas-server/src/main/java/com/yuanchu/mom/service/impl/DeviceServiceImpl.java
+++ b/cnas-server/src/main/java/com/yuanchu/mom/service/impl/DeviceServiceImpl.java
@@ -1,10 +1,12 @@
package com.yuanchu.mom.service.impl;
+import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.yuanchu.mom.common.GetLook;
import com.yuanchu.mom.common.PrintChina;
+import com.yuanchu.mom.dto.DeviceDto;
import com.yuanchu.mom.mapper.DeviceMapper;
import com.yuanchu.mom.pojo.Device;
import com.yuanchu.mom.service.DeviceService;
@@ -28,12 +30,13 @@
private DeviceMapper deviceMapper;
@Override
- public Map<String, Object> selectDeviceParameter(Page page, Device itemParameter) {
+ public Map<String, Object> selectDeviceParameter(Page page, DeviceDto itemParameter) {
Map<String, Object> map = new HashMap<>();
- map.put("head", PrintChina.printChina(Device.class));
+ map.put("head", PrintChina.printChina(DeviceDto.class));
Map<String, Integer> map1 = getLook.selectPowerByMethodAndUserId("selectDeviceParameter");
if (map1.get("look") == 1) itemParameter.setCreateUser(map1.get("userId"));
- map.put("body", deviceMapper.selectPage(page, QueryWrappers.queryWrappers(itemParameter)));
+ IPage<DeviceDto> iPage = deviceMapper.selectDeviceParameterPage(page, QueryWrappers.queryWrappers(itemParameter));
+ map.put("body", iPage);
return map;
}
diff --git a/cnas-server/src/main/java/com/yuanchu/mom/service/impl/LaboratoryServiceImpl.java b/cnas-server/src/main/java/com/yuanchu/mom/service/impl/LaboratoryServiceImpl.java
index 621fe7c..c048f49 100644
--- a/cnas-server/src/main/java/com/yuanchu/mom/service/impl/LaboratoryServiceImpl.java
+++ b/cnas-server/src/main/java/com/yuanchu/mom/service/impl/LaboratoryServiceImpl.java
@@ -54,7 +54,7 @@
@Override
public List<Laboratory> obtainItemParameterList() {
- return laboratoryMapper.selectList(Wrappers.<Laboratory>lambdaQuery().select(Laboratory::getLaboratoryName));
+ return laboratoryMapper.selectList(Wrappers.<Laboratory>lambdaQuery().select(Laboratory::getLaboratoryName, Laboratory::getId));
}
diff --git a/cnas-server/src/main/resources/mapper/DeviceMapper.xml b/cnas-server/src/main/resources/mapper/DeviceMapper.xml
index f24ba1a..721840b 100644
--- a/cnas-server/src/main/resources/mapper/DeviceMapper.xml
+++ b/cnas-server/src/main/resources/mapper/DeviceMapper.xml
@@ -79,44 +79,6 @@
</where>
</select>
- <update id="upDeviceParameter" parameterType="com.yuanchu.mom.pojo.Device">
- UPDATE device
- <set>
- <if test="largeCategory!=null and largeCategory!='' ">large_category=#{largeCategory},</if>
- <if test="dateProduction!=null ">date_production=#{dateProduction},</if>
- <if test="equipmentManager!=null ">equipment_manager=#{equipmentManager},</if>
- <if test="authorizedPerson!=null ">authorized_person=#{authorizedPerson}</if>
- <if test="deviceName!=null ">device_name=#{deviceName}</if>
- <if test="internalCode!=null ">internal_code=#{internalCode}</if>
- <if test="assetCode!=null ">asset_code=#{assetCode}</if>
- <if test="calibrationDate!=null ">calibration_date=#{calibrationDate}</if>
- <if test="scrapTime!=null ">scrap_time=#{scrapTime}</if>
- <if test="acceptanceRecords!=null ">acceptance_records=#{acceptanceRecords}</if>
- <if test="subclass!=null ">subclass=#{subclass}</if>
- <if test="factoryNo!=null ">factory_no=#{factoryNo}</if>
- <if test="acquisitionDate!=null ">create_time=#{acquisition_date}</if>
- <if test="factoryNo!=null ">create_time=#{factory_no}</if>
- <if test="acquisitionDate!=null ">acquisition_date=#{acquisitionDate}</if>
- <if test="accurateMeasurement!=null ">accurate_measurement=#{accurateMeasurement}</if>
- <if test="notes!=null ">notes=#{notes}</if>
- <if test="specificationModel!=null ">specification_model=#{specificationModel}</if>
- <if test="deviceStatus!=null ">device_status=#{deviceStatus}</if>
- <if test="storagePoint!=null ">storage_point=#{storagePoint}</if>
- <if test="latestTraceability!=null ">latest_traceability=#{latestTraceability}</if>
- <if test="downTime!=null ">down_time=#{downTime}</if>
- <if test="maintenanceRecords!=null ">maintenance_records=#{maintenanceRecords}</if>
- <if test="manufacturer!=null ">manufacturer=#{manufacturer}</if>
- <if test="detectionType!=null ">detection_type=#{detectionType}</if>
- <if test="procurementCosts!=null ">procurement_costs=#{procurementCosts}</if>
- <if test="calibrationCerticate!=null ">calibration_certicate=#{calibrationCerticate}</if>
- <if test="status!=null ">status=#{status}</if>
- <if test="imageUpload!=null ">image_upload=#{imageUpload}</if>
- <if test="imageName!=null ">image_name=#{imageName}</if>
- </set>
- <where>
- id=#{id}
- </where>
- </update>
<select id="selectDeviceImage" resultType="com.yuanchu.mom.pojo.Device">
select (image_upload, create_user, create_time) values (#{image_upload}
, #{createUser}
@@ -127,4 +89,19 @@
equipment_manager
from device
</select>
+
+ <select id="selectDeviceParameterPage" resultType="com.yuanchu.mom.dto.DeviceDto">
+ select * from(
+ SELECT
+ d.*, u.name equipmentManagerUser, l.laboratory_name laboratoryName, i.inspection_item insProductItem
+ FROM
+ device d
+ left join `user` u on u.id = d.equipment_manager
+ left join laboratory l on l.id = d.subordinate_departments_id
+ left join ins_product i on i.id = d.ins_product_ids
+ ) a
+ <if test="ew.customSqlSegment != null and ew.customSqlSegment != ''">
+ ${ew.customSqlSegment}
+ </if>
+ </select>
</mapper>
diff --git a/framework/src/main/java/com/yuanchu/mom/controller/InformationNotificationController.java b/framework/src/main/java/com/yuanchu/mom/controller/InformationNotificationController.java
index 013fda6..972ba26 100644
--- a/framework/src/main/java/com/yuanchu/mom/controller/InformationNotificationController.java
+++ b/framework/src/main/java/com/yuanchu/mom/controller/InformationNotificationController.java
@@ -31,40 +31,40 @@
@Autowired
private InformationNotificationService informationNotificationService;
- @ApiOperation(value = "婊氬姩鍒嗛〉鏌ヨ")
+ @ApiOperation(value = "娑堟伅閫氱煡-婊氬姩鍒嗛〉鏌ヨ")
@GetMapping("page")
public Result<?> getPage(Long size, Long current, String messageType) {
return Result.success(informationNotificationService.getPage(new Page<>(current, size), messageType));
}
- @ApiOperation(value = "鏇存柊娑堟伅鐘舵�侊紙鎷掔粷銆佹帴鏀讹級")
+ @ApiOperation(value = "娑堟伅閫氱煡-鏇存柊娑堟伅鐘舵�侊紙鎷掔粷銆佹帴鏀讹級")
@PutMapping("updateMessageStatus")
public Result<?> updateMessageStatus(@RequestBody InformationNotification informationNotification) {
informationNotificationService.updateById(informationNotification);
return Result.success();
}
- @ApiOperation(value = "鏍囪鎵�鏈変俊鎭负宸茶/鍒犻櫎鎵�鏈夊凡璇绘秷鎭�")
+ @ApiOperation(value = "娑堟伅閫氱煡-鏍囪鎵�鏈変俊鎭负宸茶/鍒犻櫎鎵�鏈夊凡璇绘秷鎭�")
@PutMapping("informationReadOrDelete/{isMarkAllInformationRead}")
public Result<?> markAllInformationReadOrDeleteAllReadMessages(@PathVariable("isMarkAllInformationRead") Boolean isMarkAllInformationRead) {
informationNotificationService.markAllInformationReadOrDeleteAllReadMessages(isMarkAllInformationRead);
return Result.success();
}
- @ApiOperation(value = "鏍规嵁Id鍒犻櫎鏁版嵁")
+ @ApiOperation(value = "娑堟伅閫氱煡-鍒犻櫎鏁版嵁")
@DeleteMapping("deleteDataBasedOnId")
public Result<?> deleteDataBasedOnId(Integer id) {
informationNotificationService.removeById(id);
return Result.success();
}
- @ApiOperation(value = "鏌ヨ鏄惁瀛樺湪鏈鏁版嵁")
+ @ApiOperation(value = "娑堟伅閫氱煡-鏌ヨ鏄惁瀛樺湪鏈鏁版嵁")
@GetMapping("checkForUnreadData")
public Result<?> checkForUnreadData() {
return Result.success(informationNotificationService.checkForUnreadData());
}
- @ApiOperation(value = "鐐瑰嚮璇︽儏瑙﹀彂淇敼鐘舵�佷负宸茶")
+ @ApiOperation(value = "娑堟伅閫氱煡-鐐瑰嚮璇︽儏瑙﹀彂淇敼鐘舵�佷负宸茶")
@PutMapping("triggerModificationStatusToRead/{id}")
public Result<?> triggerModificationStatusToRead(@PathVariable("id") Integer id) {
informationNotificationService.triggerModificationStatusToRead(id);
--
Gitblit v1.9.3