From 8816a5ef1bd1226969b15302fcb01a163f26348b Mon Sep 17 00:00:00 2001 From: gaoaoy <1042166043@qq.com> Date: 星期四, 07 三月 2024 17:12:19 +0800 Subject: [PATCH] 6 设备工具明细 功能调整 --- user-server/src/main/java/com/yuanchu/mom/controller/UserController.java | 16 +++---- cnas-server/src/main/resources/mapper/LaboratoryMapper.xml | 4 +- user-server/src/main/java/com/yuanchu/mom/service/CustomService.java | 5 -- inspect-server/src/main/resources/mapper/InsOrderMapper.xml | 46 +++++++++++++++++++++++ user-server/src/main/java/com/yuanchu/mom/mapper/UserMapper.java | 3 + user-server/src/main/java/com/yuanchu/mom/service/UserService.java | 3 + user-server/src/main/java/com/yuanchu/mom/service/impl/UserServiceImp.java | 13 ++---- user-server/src/main/resources/mapper/UserMapper.xml | 3 + 8 files changed, 68 insertions(+), 25 deletions(-) diff --git a/cnas-server/src/main/resources/mapper/LaboratoryMapper.xml b/cnas-server/src/main/resources/mapper/LaboratoryMapper.xml index a39d2cc..e750909 100644 --- a/cnas-server/src/main/resources/mapper/LaboratoryMapper.xml +++ b/cnas-server/src/main/resources/mapper/LaboratoryMapper.xml @@ -13,7 +13,7 @@ laboratory_number, phone_number, head, - address, + l.address, u1.name create_user_name, l.create_time from laboratory l @@ -32,7 +32,7 @@ laboratory_number, phone_number, head, - address, + l.address, u1.name create_user_name, l.create_time from laboratory l diff --git a/inspect-server/src/main/resources/mapper/InsOrderMapper.xml b/inspect-server/src/main/resources/mapper/InsOrderMapper.xml new file mode 100644 index 0000000..6162cca --- /dev/null +++ b/inspect-server/src/main/resources/mapper/InsOrderMapper.xml @@ -0,0 +1,46 @@ +<?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.yuanchu.mom.mapper.InsOrderMapper"> + + <resultMap id="BaseResultMap" type="com.yuanchu.mom.pojo.InsOrder"> + <id property="id" column="id" jdbcType="INTEGER"/> + <result property="entrustCode" column="entrust_code" jdbcType="VARCHAR"/> + <result property="sampleCode" column="sample_code" jdbcType="VARCHAR"/> + <result property="orderingCustomers" column="ordering_customers" jdbcType="VARCHAR"/> + <result property="orderingUnit" column="ordering_unit" jdbcType="VARCHAR"/> + <result property="urgency" column="urgency" jdbcType="VARCHAR"/> + <result property="appointedTime" column="appointed_time" jdbcType="TIMESTAMP"/> + <result property="laboratoryName" column="laboratory_name" jdbcType="VARCHAR"/> + <result property="sampleClassification" column="sample_classification" jdbcType="VARCHAR"/> + <result property="model" column="model" jdbcType="VARCHAR"/> + <result property="sample" column="sample" jdbcType="VARCHAR"/> + <result property="numberSamples" column="number_samples" jdbcType="INTEGER"/> + <result property="leaveSample" column="leave_sample" jdbcType="VARCHAR"/> + <result property="retainedSamples" column="retained_samples" jdbcType="INTEGER"/> + <result property="smapleType" column="smaple_type" jdbcType="VARCHAR"/> + <result property="entrustCompany" column="entrust_company" jdbcType="VARCHAR"/> + <result property="entrustName" column="entrust_name" jdbcType="VARCHAR"/> + <result property="documentTime" column="document_time" jdbcType="TIMESTAMP"/> + <result property="entrustmentTime" column="entrustment_time" jdbcType="TIMESTAMP"/> + <result property="inspectionProgress" column="inspection_progress" jdbcType="VARCHAR"/> + <result property="inspectionResult" column="inspection_result" jdbcType="VARCHAR"/> + <result property="createUser" column="create_user" jdbcType="INTEGER"/> + <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/> + <result property="updateUser" column="update_user" jdbcType="INTEGER"/> + <result property="updateTime" column="update_time" jdbcType="TIMESTAMP"/> + </resultMap> + + <sql id="Base_Column_List"> + id,entrust_code,sample_code, + ordering_customers,ordering_unit,urgency, + appointed_time,laboratory_name,sample_classification, + model,sample,number_samples, + leave_sample,retained_samples,smaple_type, + entrust_company,entrust_name,document_time, + entrustment_time,inspection_progress,inspection_result, + create_user,create_time,update_user, + update_time + </sql> +</mapper> diff --git a/user-server/src/main/java/com/yuanchu/mom/controller/UserController.java b/user-server/src/main/java/com/yuanchu/mom/controller/UserController.java index 78811e3..5e3ecf2 100644 --- a/user-server/src/main/java/com/yuanchu/mom/controller/UserController.java +++ b/user-server/src/main/java/com/yuanchu/mom/controller/UserController.java @@ -1,12 +1,7 @@ package com.yuanchu.mom.controller; -import cn.hutool.http.HttpUtil; -import cn.hutool.json.JSONObject; -import cn.hutool.json.JSONUtil; -import com.alibaba.fastjson.JSON; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.yuanchu.mom.annotation.ValueAuth; -import com.yuanchu.mom.common.PrintChina; import com.yuanchu.mom.dto.Custom; import com.yuanchu.mom.dto.UserPageDto; import com.yuanchu.mom.pojo.User; @@ -16,15 +11,11 @@ import com.yuanchu.mom.utils.JackSonUtil; import com.yuanchu.mom.utils.Jwt; import com.yuanchu.mom.utils.RedisUtil; -import com.yuanchu.mom.utils.ServletUtils; import com.yuanchu.mom.vo.Result; import io.swagger.annotations.Api; -import io.swagger.annotations.ApiModelProperty; import io.swagger.annotations.ApiOperation; import lombok.AllArgsConstructor; -import org.springframework.beans.factory.annotation.Autowired; import org.springframework.util.DigestUtils; -import org.springframework.validation.annotation.Validated; import org.springframework.web.bind.annotation.*; import java.util.HashMap; @@ -149,4 +140,11 @@ return Result.success(customService.addCustom(custom)); } + //鑾峰彇璁惧璐熻矗浜� + @ApiOperation(value = "鑾峰彇璁惧璐熻矗浜�") + @GetMapping("/getDeviceManager") + public Result<?> getDeviceManager() { + return Result.success(userService.getDeviceManager()); + } + } diff --git a/user-server/src/main/java/com/yuanchu/mom/mapper/UserMapper.java b/user-server/src/main/java/com/yuanchu/mom/mapper/UserMapper.java index f1d519e..e0ec91b 100644 --- a/user-server/src/main/java/com/yuanchu/mom/mapper/UserMapper.java +++ b/user-server/src/main/java/com/yuanchu/mom/mapper/UserMapper.java @@ -16,4 +16,7 @@ IPage<User> selectUserDtoPageList(IPage<UserPageDto> page, QueryWrapper<UserPageDto> ew); + //鑾峰彇璁惧璐熻矗浜� + List<User> getDeviceManager(); + } diff --git a/user-server/src/main/java/com/yuanchu/mom/service/CustomService.java b/user-server/src/main/java/com/yuanchu/mom/service/CustomService.java index 44ddeb5..a2a710c 100644 --- a/user-server/src/main/java/com/yuanchu/mom/service/CustomService.java +++ b/user-server/src/main/java/com/yuanchu/mom/service/CustomService.java @@ -1,13 +1,9 @@ package com.yuanchu.mom.service; -import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.service.IService; import com.yuanchu.mom.dto.Custom; -import com.yuanchu.mom.dto.UserPageDto; -import com.yuanchu.mom.pojo.Power; -import java.util.List; import java.util.Map; /** @@ -22,5 +18,4 @@ int delCustomById(Integer id); int addCustom(Custom custom); - } diff --git a/user-server/src/main/java/com/yuanchu/mom/service/UserService.java b/user-server/src/main/java/com/yuanchu/mom/service/UserService.java index 3b8fc96..4481cb5 100644 --- a/user-server/src/main/java/com/yuanchu/mom/service/UserService.java +++ b/user-server/src/main/java/com/yuanchu/mom/service/UserService.java @@ -1,7 +1,6 @@ package com.yuanchu.mom.service; import com.baomidou.mybatisplus.core.metadata.IPage; -import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.yuanchu.mom.dto.UserPageDto; import com.yuanchu.mom.pojo.User; @@ -24,4 +23,6 @@ List<User> getUserMenu(); + List<User> getDeviceManager(); + } diff --git a/user-server/src/main/java/com/yuanchu/mom/service/impl/UserServiceImp.java b/user-server/src/main/java/com/yuanchu/mom/service/impl/UserServiceImp.java index 4796942..3af627b 100644 --- a/user-server/src/main/java/com/yuanchu/mom/service/impl/UserServiceImp.java +++ b/user-server/src/main/java/com/yuanchu/mom/service/impl/UserServiceImp.java @@ -1,28 +1,20 @@ package com.yuanchu.mom.service.impl; -import cn.hutool.json.JSONUtil; -import com.baomidou.mybatisplus.core.conditions.Wrapper; -import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; -import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.core.toolkit.Wrappers; -import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.yuanchu.mom.common.GetLook; import com.yuanchu.mom.common.PrintChina; import com.yuanchu.mom.dto.UserPageDto; import com.yuanchu.mom.mapper.UserMapper; import com.yuanchu.mom.pojo.User; import com.yuanchu.mom.service.UserService; -import com.yuanchu.mom.utils.JackSonUtil; import com.yuanchu.mom.utils.Jwt; import com.yuanchu.mom.utils.QueryWrappers; -import com.yuanchu.mom.utils.ServletUtils; import lombok.AllArgsConstructor; import org.springframework.stereotype.Service; import org.springframework.util.DigestUtils; -import javax.annotation.Resource; import java.util.HashMap; import java.util.List; import java.util.Map; @@ -76,4 +68,9 @@ public List<User> getUserMenu() { return userMapper.selectList(Wrappers.<User>lambdaQuery().eq(User::getState, 1).select(User::getName, User::getId)); } + + @Override + public List<User> getDeviceManager() { + return userMapper.getDeviceManager(); + } } diff --git a/user-server/src/main/resources/mapper/UserMapper.xml b/user-server/src/main/resources/mapper/UserMapper.xml index 229b3c4..5c58eb1 100644 --- a/user-server/src/main/resources/mapper/UserMapper.xml +++ b/user-server/src/main/resources/mapper/UserMapper.xml @@ -13,4 +13,7 @@ ${ew.customSqlSegment} </if> </select> + <select id="getDeviceManager" resultType="com.yuanchu.mom.dto.UserPageDto"> + select id,name from user where state=1 + </select> </mapper> \ No newline at end of file -- Gitblit v1.9.3