framework/pom.xml
@@ -27,34 +27,16 @@ <artifactId>mysql-connector-java</artifactId> </dependency> <!--Swagger3--> <dependency> <groupId>io.springfox</groupId> <artifactId>springfox-boot-starter</artifactId> </dependency> <!--Swagger3-Uiç¾å--> <dependency> <groupId>com.github.xiaoymin</groupId> <artifactId>knife4j-spring-ui</artifactId> </dependency> <!--mybatis-plus--> <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-boot-starter</artifactId> </dependency> <!--redis jarå --> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-redis</artifactId> </dependency> <!-- JWT --> <dependency> <groupId>com.auth0</groupId> <artifactId>java-jwt</artifactId> </dependency> </dependencies> framework/src/main/java/com/yuanchu/limslaboratory/config/MyBatisPlusConfig.java
@@ -4,11 +4,9 @@ import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor; import com.baomidou.mybatisplus.extension.plugins.OptimisticLockerInterceptor; import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor; import org.mybatis.spring.annotation.MapperScan; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; @MapperScan("com.yuanchu.limslaboratory.mapper") // æ«æMybatisä¸çmapperå @Configuration public class MyBatisPlusConfig { framework/src/main/java/com/yuanchu/limslaboratory/config/WebMvcConfig.java
@@ -1,21 +1,15 @@ package com.yuanchu.limslaboratory.config; import com.fasterxml.jackson.annotation.JsonAutoDetect; import com.fasterxml.jackson.annotation.PropertyAccessor; import com.fasterxml.jackson.databind.ObjectMapper; import com.fasterxml.jackson.databind.SerializationFeature; import com.fasterxml.jackson.datatype.jsr310.JavaTimeModule; import org.springframework.beans.factory.annotation.Value; import org.springframework.context.annotation.Configuration; import org.springframework.http.converter.HttpMessageConverter; import org.springframework.http.converter.json.MappingJackson2HttpMessageConverter; import org.springframework.web.servlet.config.annotation.ResourceHandlerRegistry; import org.springframework.web.servlet.config.annotation.WebMvcConfigurationSupport; import java.io.File; import java.util.List; @Configuration public class WebMvcConfig extends WebMvcConfigurationSupport { @Value("${file.path}") private String filePath; @Override protected void addResourceHandlers(ResourceHandlerRegistry registry) { @@ -25,6 +19,7 @@ registry.addResourceHandler("/webjars/**").addResourceLocations("classpath:/META-INF/resources/webjars/"); //设置æä»¶èæè·¯å¾æ å° registry.addResourceHandler("/img/**").addResourceLocations("file:E:\\webapp\\images\\"); registry.addResourceHandler("/img/**").addResourceLocations("file:"+filePath+"/") .addResourceLocations("file:"+filePath+"/"); } } inspection-server/pom.xml
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,21 @@ <?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <parent> <artifactId>lims-laboratory</artifactId> <groupId>com.yuanchu</groupId> <version>0.0.1-SNAPSHOT</version> </parent> <groupId>com.yunchu.limslaboratory</groupId> <artifactId>inspection-server</artifactId> <version>0.0.1-SNAPSHOT</version> <name>inspection-server</name> <description>inspection-server</description> <packaging>jar</packaging> <dependencies> </dependencies> </project> inspection-server/src/main/java/com/yuanchu/limslaboratory/controller/InspectionController.java
ÎļþÃû´Ó user-server/src/main/java/com/yuanchu/limslaboratory/controller/EnterpriseUserListController.java ÐÞ¸Ä @@ -11,10 +11,10 @@ * </p> * * @author æ±èéµ·éç½ç»ç§ææéå ¬å¸ * @since 2023-07-07 * @since 2023-07-17 */ @RestController @RequestMapping("/enterprise-user-list") public class EnterpriseUserListController { @RequestMapping("/inspection") public class InspectionController { } inspection-server/src/main/java/com/yuanchu/limslaboratory/controller/InspectionProductListController.javacopy from user-server/src/main/java/com/yuanchu/limslaboratory/controller/EnterpriseUserListController.java copy to inspection-server/src/main/java/com/yuanchu/limslaboratory/controller/InspectionProductListController.java
Îļþ´Ó user-server/src/main/java/com/yuanchu/limslaboratory/controller/EnterpriseUserListController.java ¸´ÖÆ @@ -11,10 +11,10 @@ * </p> * * @author æ±èéµ·éç½ç»ç§ææéå ¬å¸ * @since 2023-07-07 * @since 2023-07-17 */ @RestController @RequestMapping("/enterprise-user-list") public class EnterpriseUserListController { @RequestMapping("/inspection-product-list") public class InspectionProductListController { } inspection-server/src/main/java/com/yuanchu/limslaboratory/controller/PlanController.javacopy from user-server/src/main/java/com/yuanchu/limslaboratory/controller/EnterpriseUserListController.java copy to inspection-server/src/main/java/com/yuanchu/limslaboratory/controller/PlanController.java
Îļþ´Ó user-server/src/main/java/com/yuanchu/limslaboratory/controller/EnterpriseUserListController.java ¸´ÖÆ @@ -11,10 +11,10 @@ * </p> * * @author æ±èéµ·éç½ç»ç§ææéå ¬å¸ * @since 2023-07-07 * @since 2023-07-17 */ @RestController @RequestMapping("/enterprise-user-list") public class EnterpriseUserListController { @RequestMapping("/plan") public class PlanController { } inspection-server/src/main/java/com/yuanchu/limslaboratory/mapper/InspectionMapper.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,16 @@ package com.yuanchu.limslaboratory.mapper; import com.yuanchu.limslaboratory.pojo.Inspection; import com.baomidou.mybatisplus.core.mapper.BaseMapper; /** * <p> * Mapper æ¥å£ * </p> * * @author æ±èéµ·éç½ç»ç§ææéå ¬å¸ * @since 2023-07-17 */ public interface InspectionMapper extends BaseMapper<Inspection> { } inspection-server/src/main/java/com/yuanchu/limslaboratory/mapper/InspectionProductListMapper.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,16 @@ package com.yuanchu.limslaboratory.mapper; import com.yuanchu.limslaboratory.pojo.InspectionProductList; import com.baomidou.mybatisplus.core.mapper.BaseMapper; /** * <p> * Mapper æ¥å£ * </p> * * @author æ±èéµ·éç½ç»ç§ææéå ¬å¸ * @since 2023-07-17 */ public interface InspectionProductListMapper extends BaseMapper<InspectionProductList> { } inspection-server/src/main/java/com/yuanchu/limslaboratory/mapper/PlanMapper.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,16 @@ package com.yuanchu.limslaboratory.mapper; import com.yuanchu.limslaboratory.pojo.Plan; import com.baomidou.mybatisplus.core.mapper.BaseMapper; /** * <p> * Mapper æ¥å£ * </p> * * @author æ±èéµ·éç½ç»ç§ææéå ¬å¸ * @since 2023-07-17 */ public interface PlanMapper extends BaseMapper<Plan> { } inspection-server/src/main/java/com/yuanchu/limslaboratory/pojo/Inspection.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,90 @@ package com.yuanchu.limslaboratory.pojo; import java.time.LocalDateTime; import java.io.Serializable; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import lombok.EqualsAndHashCode; /** * <p> * * </p> * * @author æ±èéµ·éç½ç»ç§ææéå ¬å¸ * @since 2023-07-17 */ @Data @EqualsAndHashCode(callSuper = false) @ApiModel(value="Inspection对象", description="") public class Inspection implements Serializable { private static final long serialVersionUID = 1L; @ApiModelProperty(value = "æ¥æ£ç¼å·") private String id; @ApiModelProperty(value = "æ¥æ£ç¶æ 1ï¼å·²æ£éªï¼0æªæ£éª") private Integer inspectionStatus; @ApiModelProperty(value = "æ¯å¦åæ ¼ 1ï¼æ¯ï¼0å¦") private Integer qualifiedState; @ApiModelProperty(value = "1ï¼å¾ æäº¤ï¼2ï¼å·²æäº¤ï¼0ï¼å·²ä½åº") private Integer state; @ApiModelProperty(value = "æ¥æ£æ¶é´") private LocalDateTime createTime; private LocalDateTime updateTime; private Integer version; @ApiModelProperty(value = "æ¥æ£äºº") private String userName; @ApiModelProperty(value = "å ³è æ£éªäººï¼ç¨æ·idï¼") private Integer inspectUserId; @ApiModelProperty(value = "æ£éªå¼å§æ¥æ") private LocalDateTime inspectStartTime; @ApiModelProperty(value = "æ£éªç»ææ¥æ") private LocalDateTime inspectEndTime; @ApiModelProperty(value = "æ¥æ£æ°é-ç©ææ°é") private Integer materialNum; @ApiModelProperty(value = "ä¾åºå") private String materialSupplier; @ApiModelProperty(value = "ç©æåç§°") private String materialName; @ApiModelProperty(value = "ç©æåæ¾å°") private String materialLocation; @ApiModelProperty(value = "ç©ææ¹æ¬¡") private String materialBatch; @ApiModelProperty(value = "ç©æçå·") private String materialReelNumber; @ApiModelProperty(value = "è§æ ¼åç§°/åå·åç§°") private String specificationsSerialNumber; @ApiModelProperty(value = "çµåç级") private String specificationsVoltageLevel; @ApiModelProperty(value = "ä¸»çº¿å¿æªé¢") private String specificationsCrossSection; @ApiModelProperty(value = "主线è¯è¯æ°") private String specificationsNumberOfCores; @ApiModelProperty(value = "ç产æä»¤å·") private String specificationsInstruct; } inspection-server/src/main/java/com/yuanchu/limslaboratory/pojo/InspectionProductList.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,70 @@ package com.yuanchu.limslaboratory.pojo; import com.baomidou.mybatisplus.annotation.IdType; import com.baomidou.mybatisplus.annotation.TableId; import java.time.LocalDateTime; import java.io.Serializable; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import lombok.EqualsAndHashCode; /** * <p> * * </p> * * @author æ±èéµ·éç½ç»ç§ææéå ¬å¸ * @since 2023-07-17 */ @Data @EqualsAndHashCode(callSuper = false) @ApiModel(value="InspectionProductList对象", description="") public class InspectionProductList implements Serializable { private static final long serialVersionUID = 1L; @ApiModelProperty(value = "项ç®id") @TableId(value = "id", type = IdType.AUTO) private Integer id; @ApiModelProperty(value = "项ç®åç§°") private String name; @ApiModelProperty(value = "è¯éªæ¹æ³") private String method; @ApiModelProperty(value = "è¯éªè¦æ±") private String ask; @ApiModelProperty(value = "åä½") private String unit; @ApiModelProperty(value = "ææ äººè¦æ±å¼") private String required; @ApiModelProperty(value = "å æ§å¼") private String internal; @ApiModelProperty(value = "å¼å§æ¥æ") private LocalDateTime startTime; @ApiModelProperty(value = "ç»ææ¥æ") private LocalDateTime endTime; private Integer state; private LocalDateTime createTime; private LocalDateTime updateTime; private Integer version; @ApiModelProperty(value = "å ³è æ¥æ£id") private String inspectionId; @ApiModelProperty(value = "å ³è ç¨æ·id è¯éªå") private Integer userId; } inspection-server/src/main/java/com/yuanchu/limslaboratory/pojo/Plan.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,51 @@ package com.yuanchu.limslaboratory.pojo; import java.time.LocalDateTime; import java.io.Serializable; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import lombok.EqualsAndHashCode; /** * <p> * * </p> * * @author æ±èéµ·éç½ç»ç§ææéå ¬å¸ * @since 2023-07-17 */ @Data @EqualsAndHashCode(callSuper = false) @ApiModel(value="Plan对象", description="") public class Plan implements Serializable { private static final long serialVersionUID = 1L; @ApiModelProperty(value = "计åç¼å·") private Integer id; @ApiModelProperty(value = "æ£éªç»æ") private String results; @ApiModelProperty(value = "è¯éªè¯´æ") private String thing; @ApiModelProperty(value = "1ï¼å¾ 认é¢ï¼2ï¼å¾ åé ï¼3ï¼å·²åé ï¼4ï¼è¶ æå¾ åé ï¼5ï¼å·²å®æï¼0ï¼å·²ä½åº") private Integer state; @ApiModelProperty(value = "ä»»å¡ç»è®°æ¶é´") private LocalDateTime createTime; private LocalDateTime updateTime; private Integer version; @ApiModelProperty(value = "å ³è æ¥æ£id(ç³è¯·åç¼å·)") private String inspectionId; @ApiModelProperty(value = "å ³è ç¨æ·id(è´è´£äººid)") private Integer userId; } inspection-server/src/main/java/com/yuanchu/limslaboratory/service/InspectionProductListService.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,16 @@ package com.yuanchu.limslaboratory.service; import com.yuanchu.limslaboratory.pojo.InspectionProductList; import com.baomidou.mybatisplus.extension.service.IService; /** * <p> * æå¡ç±» * </p> * * @author æ±èéµ·éç½ç»ç§ææéå ¬å¸ * @since 2023-07-17 */ public interface InspectionProductListService extends IService<InspectionProductList> { } inspection-server/src/main/java/com/yuanchu/limslaboratory/service/InspectionService.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,16 @@ package com.yuanchu.limslaboratory.service; import com.yuanchu.limslaboratory.pojo.Inspection; import com.baomidou.mybatisplus.extension.service.IService; /** * <p> * æå¡ç±» * </p> * * @author æ±èéµ·éç½ç»ç§ææéå ¬å¸ * @since 2023-07-17 */ public interface InspectionService extends IService<Inspection> { } inspection-server/src/main/java/com/yuanchu/limslaboratory/service/PlanService.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,16 @@ package com.yuanchu.limslaboratory.service; import com.yuanchu.limslaboratory.pojo.Plan; import com.baomidou.mybatisplus.extension.service.IService; /** * <p> * æå¡ç±» * </p> * * @author æ±èéµ·éç½ç»ç§ææéå ¬å¸ * @since 2023-07-17 */ public interface PlanService extends IService<Plan> { } inspection-server/src/main/java/com/yuanchu/limslaboratory/service/impl/InspectionProductListServiceImpl.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,20 @@ package com.yuanchu.limslaboratory.service.impl; import com.yuanchu.limslaboratory.pojo.InspectionProductList; import com.yuanchu.limslaboratory.mapper.InspectionProductListMapper; import com.yuanchu.limslaboratory.service.InspectionProductListService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import org.springframework.stereotype.Service; /** * <p> * æå¡å®ç°ç±» * </p> * * @author æ±èéµ·éç½ç»ç§ææéå ¬å¸ * @since 2023-07-17 */ @Service public class InspectionProductListServiceImpl extends ServiceImpl<InspectionProductListMapper, InspectionProductList> implements InspectionProductListService { } inspection-server/src/main/java/com/yuanchu/limslaboratory/service/impl/InspectionServiceImpl.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,20 @@ package com.yuanchu.limslaboratory.service.impl; import com.yuanchu.limslaboratory.pojo.Inspection; import com.yuanchu.limslaboratory.mapper.InspectionMapper; import com.yuanchu.limslaboratory.service.InspectionService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import org.springframework.stereotype.Service; /** * <p> * æå¡å®ç°ç±» * </p> * * @author æ±èéµ·éç½ç»ç§ææéå ¬å¸ * @since 2023-07-17 */ @Service public class InspectionServiceImpl extends ServiceImpl<InspectionMapper, Inspection> implements InspectionService { } inspection-server/src/main/java/com/yuanchu/limslaboratory/service/impl/PlanServiceImpl.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,20 @@ package com.yuanchu.limslaboratory.service.impl; import com.yuanchu.limslaboratory.pojo.Plan; import com.yuanchu.limslaboratory.mapper.PlanMapper; import com.yuanchu.limslaboratory.service.PlanService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import org.springframework.stereotype.Service; /** * <p> * æå¡å®ç°ç±» * </p> * * @author æ±èéµ·éç½ç»ç§ææéå ¬å¸ * @since 2023-07-17 */ @Service public class PlanServiceImpl extends ServiceImpl<PlanMapper, Plan> implements PlanService { } inspection-server/src/main/resources/mapper/InspectionMapper.xmlcopy from user-server/src/main/resources/mapper/EnterpriseUserListMapper.xml copy to inspection-server/src/main/resources/mapper/InspectionMapper.xml
Îļþ´Ó user-server/src/main/resources/mapper/EnterpriseUserListMapper.xml ¸´ÖÆ @@ -1,5 +1,5 @@ <?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.limslaboratory.mapper.EnterpriseUserListMapper"> <mapper namespace="com.yuanchu.limslaboratory.mapper.InspectionMapper"> </mapper> inspection-server/src/main/resources/mapper/InspectionProductListMapper.xmlcopy from user-server/src/main/resources/mapper/EnterpriseUserListMapper.xml copy to inspection-server/src/main/resources/mapper/InspectionProductListMapper.xml
Îļþ´Ó user-server/src/main/resources/mapper/EnterpriseUserListMapper.xml ¸´ÖÆ @@ -1,5 +1,5 @@ <?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.limslaboratory.mapper.EnterpriseUserListMapper"> <mapper namespace="com.yuanchu.limslaboratory.mapper.InspectionProductListMapper"> </mapper> inspection-server/src/main/resources/mapper/PlanMapper.xmlcopy from user-server/src/main/resources/mapper/EnterpriseUserListMapper.xml copy to inspection-server/src/main/resources/mapper/PlanMapper.xml
Îļþ´Ó user-server/src/main/resources/mapper/EnterpriseUserListMapper.xml ¸´ÖÆ @@ -1,5 +1,5 @@ <?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.limslaboratory.mapper.EnterpriseUserListMapper"> <mapper namespace="com.yuanchu.limslaboratory.mapper.PlanMapper"> </mapper> pom.xml
@@ -19,7 +19,8 @@ <module>user-server</module> <module>sys</module> <module>framework</module> <module>standard-library</module> <module>standard-server</module> <module>inspection-server</module> </modules> <properties> @@ -34,6 +35,9 @@ <openfeign.version>3.1.3</openfeign.version> <feign-okhttp.version>11.0</feign-okhttp.version> <shiro.version>1.5.3</shiro.version> <!-- æå å导åºçè·¯å¾ --> <package.path>${project.build.directory}/LIMS</package.path> </properties> <dependencies> @@ -41,10 +45,12 @@ <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> </dependency> <!--çé¨ç½²a--> <dependency> <groupId>org.springframework.boot</groupId> @@ -52,10 +58,25 @@ <scope>runtime</scope> <optional>true</optional> </dependency> <!--lombok--> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> </dependency> <!--Swagger3--> <dependency> <groupId>io.springfox</groupId> <artifactId>springfox-boot-starter</artifactId> <version>${swagger.version}</version> </dependency> <!--mybatis-plus--> <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-boot-starter</artifactId> <version>${mybatis-plus.version}</version> </dependency> </dependencies> <dependencyManagement> @@ -81,32 +102,11 @@ <version>${druid.version}</version> </dependency> <!--jwt--> <dependency> <groupId>com.auth0</groupId> <artifactId>java-jwt</artifactId> <version>${jwt.version}</version> </dependency> <!--Swagger3--> <dependency> <groupId>io.springfox</groupId> <artifactId>springfox-boot-starter</artifactId> <version>${swagger.version}</version> </dependency> <!--Swagger3-Uiç¾å--> <dependency> <groupId>com.github.xiaoymin</groupId> <artifactId>knife4j-spring-ui</artifactId> <version>${knife4j-spring-ui.version}</version> </dependency> <!--mybatis-plus--> <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-boot-starter</artifactId> <version>${mybatis-plus.version}</version> </dependency> <!--mybatis-plus代ç çæå¨--> @@ -136,29 +136,89 @@ <artifactId>shiro-spring-boot-starter</artifactId> <version>${shiro.version}</version> </dependency> <!--jwt--> <dependency> <groupId>com.auth0</groupId> <artifactId>java-jwt</artifactId> <version>${jwt.version}</version> </dependency> </dependencies> </dependencyManagement> <build> <plugins> <!-- ä¸çº¿é¨ç½² JARå¯å¨å离ä¾èµlibåé ç½® --> <!-- æå jar --> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-jar-plugin</artifactId> <configuration> <!-- 䏿å èµæºæä»¶ --> <excludes> <exclude> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> </exclude> <exclude>*.**</exclude> </excludes> <mainClass> com.yuanchu.limslaboratory.SysApplication </mainClass> <!--<fork>false</fork> <includeSystemScope>true</includeSystemScope> <skip>true</skip>--> <archive> <manifest> <addClasspath>true</addClasspath> <!-- MANIFEST.MF ä¸ Class-Path å å ¥åç¼ --> <classpathPrefix>lib/</classpathPrefix> <!-- jarå ä¸å å«å¯ä¸çæ¬æ è¯ --> <useUniqueVersions>false</useUniqueVersions> <!-- æå®å ¥å£ç±» --> <mainClass>com.yuanchu.limslaboratory.SysApplication</mainClass> </manifest> <!-- æå®é ç½®æä»¶ç®å½ï¼è¿æ ·jarè¿è¡æ¶ä¼å»æ¾å°åç®å½ä¸çconfæä»¶å¤¹ä¸æ¥æ¾ --> <manifestEntries> <Class-Path>conf/</Class-Path> </manifestEntries> </archive> <outputDirectory>${package.path}</outputDirectory> </configuration> </plugin> <!-- æ·è´ä¾èµ copy-dependencies --> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-dependency-plugin</artifactId> <executions> <execution> <id>copy-dependencies</id> <phase>package</phase> <goals> <goal>copy-dependencies</goal> </goals> <configuration> <outputDirectory>${package.path}/lib/ </outputDirectory> </configuration> </execution> </executions> </plugin> <!-- æ·è´èµæºæä»¶ copy-resources --> <plugin> <artifactId>maven-resources-plugin</artifactId> <executions> <execution> <id>copy-resources</id> <phase>package</phase> <goals> <goal>copy-resources</goal> </goals> <configuration> <resources> <resource> <directory>src/main/resources</directory> <!-- æå®åä¸æå»ºçresource --> <includes> <include>*.**</include> <!--æé¤application-dev.ymlæä»¶--> </includes> </resource> </resources> <outputDirectory>${package.path}/conf</outputDirectory> </configuration> </execution> </executions> </plugin> </plugins> </build> standard-server/pom.xml
ÎļþÃû´Ó standard-library/pom.xml ÐÞ¸Ä @@ -8,7 +8,7 @@ <version>0.0.1-SNAPSHOT</version> </parent> <groupId>com.yunchu.limslaboratory</groupId> <artifactId>standard-library</artifactId> <artifactId>standard-server</artifactId> <version>0.0.1-SNAPSHOT</version> <name>standard-library</name> <description>standard-library</description> @@ -26,12 +26,6 @@ <groupId>com.yunchu.limslaboratory</groupId> <artifactId>user-server</artifactId> <version>${project.parent.version}</version> </dependency> <!--mybatis-plus--> <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-boot-starter</artifactId> </dependency> </dependencies> standard-server/src/main/java/com/yuanchu/limslaboratory/controller/MaterialController.javacopy from user-server/src/main/java/com/yuanchu/limslaboratory/controller/EnterpriseUserListController.java copy to standard-server/src/main/java/com/yuanchu/limslaboratory/controller/MaterialController.java
Îļþ´Ó user-server/src/main/java/com/yuanchu/limslaboratory/controller/EnterpriseUserListController.java ¸´ÖÆ @@ -11,10 +11,10 @@ * </p> * * @author æ±èéµ·éç½ç»ç§ææéå ¬å¸ * @since 2023-07-07 * @since 2023-07-17 */ @RestController @RequestMapping("/enterprise-user-list") public class EnterpriseUserListController { @RequestMapping("/material") public class MaterialController { } standard-server/src/main/java/com/yuanchu/limslaboratory/controller/ProductController.javacopy from user-server/src/main/java/com/yuanchu/limslaboratory/controller/EnterpriseUserListController.java copy to standard-server/src/main/java/com/yuanchu/limslaboratory/controller/ProductController.java
Îļþ´Ó user-server/src/main/java/com/yuanchu/limslaboratory/controller/EnterpriseUserListController.java ¸´ÖÆ @@ -11,10 +11,10 @@ * </p> * * @author æ±èéµ·éç½ç»ç§ææéå ¬å¸ * @since 2023-07-07 * @since 2023-07-17 */ @RestController @RequestMapping("/enterprise-user-list") public class EnterpriseUserListController { @RequestMapping("/product") public class ProductController { } standard-server/src/main/java/com/yuanchu/limslaboratory/controller/SerialNumberController.java
standard-server/src/main/java/com/yuanchu/limslaboratory/controller/SpecificationsController.java
ÎļþÃû´Ó standard-library/src/main/java/com/yuanchu/limslaboratory/controller/SpecificationsController.java ÐÞ¸Ä @@ -7,6 +7,7 @@ import com.yuanchu.limslaboratory.pojo.Standards; import com.yuanchu.limslaboratory.service.SpecificationsService; import com.yuanchu.limslaboratory.utils.JackSonUtil; import com.yuanchu.limslaboratory.utils.MyUtil; import com.yuanchu.limslaboratory.utils.RedisUtil; import com.yuanchu.limslaboratory.vo.ListSpecificationsInformation; import com.yuanchu.limslaboratory.vo.Result; @@ -55,7 +56,7 @@ @ApiImplicitParams(value = { @ApiImplicitParam(name = "pageNo", value = "èµ·å§é¡µ", dataTypeClass = Integer.class, required = true), @ApiImplicitParam(name = "pageSize", value = "æ¯ä¸é¡µæ°é", dataTypeClass = Integer.class, required = true), @ApiImplicitParam(name = "specificationsName", value = "åå·åç§°", dataTypeClass = String.class), @ApiImplicitParam(name = "specificationsName", value = "è§æ ¼åç§°", dataTypeClass = String.class), @ApiImplicitParam(name = "serialNumberId", value = "åå·ID", dataTypeClass = String.class), }) @GetMapping("/list") standard-server/src/main/java/com/yuanchu/limslaboratory/controller/StandardsController.java
standard-server/src/main/java/com/yuanchu/limslaboratory/mapper/MaterialMapper.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,16 @@ package com.yuanchu.limslaboratory.mapper; import com.yuanchu.limslaboratory.pojo.Material; import com.baomidou.mybatisplus.core.mapper.BaseMapper; /** * <p> * Mapper æ¥å£ * </p> * * @author æ±èéµ·éç½ç»ç§ææéå ¬å¸ * @since 2023-07-17 */ public interface MaterialMapper extends BaseMapper<Material> { } standard-server/src/main/java/com/yuanchu/limslaboratory/mapper/ProductMapper.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,16 @@ package com.yuanchu.limslaboratory.mapper; import com.yuanchu.limslaboratory.pojo.Product; import com.baomidou.mybatisplus.core.mapper.BaseMapper; /** * <p> * Mapper æ¥å£ * </p> * * @author æ±èéµ·éç½ç»ç§ææéå ¬å¸ * @since 2023-07-17 */ public interface ProductMapper extends BaseMapper<Product> { } standard-server/src/main/java/com/yuanchu/limslaboratory/mapper/SerialNumberMapper.java
standard-server/src/main/java/com/yuanchu/limslaboratory/mapper/SpecificationsMapper.java
standard-server/src/main/java/com/yuanchu/limslaboratory/mapper/StandardsMapper.java
standard-server/src/main/java/com/yuanchu/limslaboratory/pojo/Material.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,58 @@ package com.yuanchu.limslaboratory.pojo; import java.time.LocalDateTime; import java.io.Serializable; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import lombok.EqualsAndHashCode; /** * <p> * * </p> * * @author æ±èéµ·éç½ç»ç§ææéå ¬å¸ * @since 2023-07-17 */ @Data @EqualsAndHashCode(callSuper = false) @ApiModel(value="Material对象", description="") public class Material implements Serializable { private static final long serialVersionUID = 1L; @ApiModelProperty(value = "ç©æid") private String id; @ApiModelProperty(value = "ç©æåç§°") private String name; @ApiModelProperty(value = "ä¾åºå") private String supplier; @ApiModelProperty(value = "ç©æåæ¾å°") private String location; @ApiModelProperty(value = "ç©ææ°é") private Integer num; @ApiModelProperty(value = "æ¹æ¬¡") private String batch; @ApiModelProperty(value = "çå·") private String reelNumber; private Integer state; private LocalDateTime createTime; private LocalDateTime updateTime; private Integer version; @ApiModelProperty(value = "å ³è è§æ ¼id") private Integer specificationsId; } standard-server/src/main/java/com/yuanchu/limslaboratory/pojo/Product.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,64 @@ package com.yuanchu.limslaboratory.pojo; import com.baomidou.mybatisplus.annotation.IdType; import com.baomidou.mybatisplus.annotation.TableId; import java.time.LocalDateTime; import java.io.Serializable; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import lombok.EqualsAndHashCode; /** * <p> * * </p> * * @author æ±èéµ·éç½ç»ç§ææéå ¬å¸ * @since 2023-07-17 */ @Data @EqualsAndHashCode(callSuper = false) @ApiModel(value="Product对象", description="") public class Product implements Serializable { private static final long serialVersionUID = 1L; @ApiModelProperty(value = "项ç®id") @TableId(value = "id", type = IdType.AUTO) private Integer id; @ApiModelProperty(value = "项ç®åç§°") private String name; @ApiModelProperty(value = "è¯éªæ¹æ³") private String method; @ApiModelProperty(value = "项ç®ç¶ç±»") private String father; @ApiModelProperty(value = "åä½") private String unit; @ApiModelProperty(value = "ææ äººè¦æ±å¼") private String required; @ApiModelProperty(value = "å æ§å¼") private String internal; private Integer state; private LocalDateTime createTime; private LocalDateTime updateTime; private Integer version; @ApiModelProperty(value = "å ³è ç¨æ·id") private Integer userId; @ApiModelProperty(value = "å ³è ç©æid") private String materialId; } standard-server/src/main/java/com/yuanchu/limslaboratory/pojo/SerialNumber.java
standard-server/src/main/java/com/yuanchu/limslaboratory/pojo/Specifications.java
standard-server/src/main/java/com/yuanchu/limslaboratory/pojo/Standards.java
standard-server/src/main/java/com/yuanchu/limslaboratory/service/MaterialService.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,16 @@ package com.yuanchu.limslaboratory.service; import com.yuanchu.limslaboratory.pojo.Material; import com.baomidou.mybatisplus.extension.service.IService; /** * <p> * æå¡ç±» * </p> * * @author æ±èéµ·éç½ç»ç§ææéå ¬å¸ * @since 2023-07-17 */ public interface MaterialService extends IService<Material> { } standard-server/src/main/java/com/yuanchu/limslaboratory/service/ProductService.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,16 @@ package com.yuanchu.limslaboratory.service; import com.yuanchu.limslaboratory.pojo.Product; import com.baomidou.mybatisplus.extension.service.IService; /** * <p> * æå¡ç±» * </p> * * @author æ±èéµ·éç½ç»ç§ææéå ¬å¸ * @since 2023-07-17 */ public interface ProductService extends IService<Product> { } standard-server/src/main/java/com/yuanchu/limslaboratory/service/SerialNumberService.java
standard-server/src/main/java/com/yuanchu/limslaboratory/service/SpecificationsService.java
standard-server/src/main/java/com/yuanchu/limslaboratory/service/StandardsService.java
standard-server/src/main/java/com/yuanchu/limslaboratory/service/impl/MaterialServiceImpl.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,20 @@ package com.yuanchu.limslaboratory.service.impl; import com.yuanchu.limslaboratory.pojo.Material; import com.yuanchu.limslaboratory.mapper.MaterialMapper; import com.yuanchu.limslaboratory.service.MaterialService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import org.springframework.stereotype.Service; /** * <p> * æå¡å®ç°ç±» * </p> * * @author æ±èéµ·éç½ç»ç§ææéå ¬å¸ * @since 2023-07-17 */ @Service public class MaterialServiceImpl extends ServiceImpl<MaterialMapper, Material> implements MaterialService { } standard-server/src/main/java/com/yuanchu/limslaboratory/service/impl/ProductServiceImpl.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,20 @@ package com.yuanchu.limslaboratory.service.impl; import com.yuanchu.limslaboratory.pojo.Product; import com.yuanchu.limslaboratory.mapper.ProductMapper; import com.yuanchu.limslaboratory.service.ProductService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import org.springframework.stereotype.Service; /** * <p> * æå¡å®ç°ç±» * </p> * * @author æ±èéµ·éç½ç»ç§ææéå ¬å¸ * @since 2023-07-17 */ @Service public class ProductServiceImpl extends ServiceImpl<ProductMapper, Product> implements ProductService { } standard-server/src/main/java/com/yuanchu/limslaboratory/service/impl/SerialNumberServiceImpl.java
ÎļþÃû´Ó standard-library/src/main/java/com/yuanchu/limslaboratory/service/impl/SerialNumberServiceImpl.java ÐÞ¸Ä @@ -3,13 +3,10 @@ import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.yuanchu.limslaboratory.pojo.SerialNumber; import com.yuanchu.limslaboratory.mapper.SerialNumberMapper; import com.yuanchu.limslaboratory.pojo.Standards; import com.yuanchu.limslaboratory.pojo.User; import com.yuanchu.limslaboratory.service.SerialNumberService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.yuanchu.limslaboratory.service.StandardsService; import com.yuanchu.limslaboratory.service.UserService; import com.yuanchu.limslaboratory.utils.MyUtil; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.util.ObjectUtils; standard-server/src/main/java/com/yuanchu/limslaboratory/service/impl/SpecificationsServiceImpl.java
standard-server/src/main/java/com/yuanchu/limslaboratory/service/impl/StandardsServiceImpl.java
standard-server/src/main/java/com/yuanchu/limslaboratory/vo/ListSpecificationsInformation.java
standard-server/src/main/resources/mapper/MaterialMapper.xml
ÎļþÃû´Ó user-server/src/main/resources/mapper/EnterpriseUserListMapper.xml ÐÞ¸Ä @@ -1,5 +1,5 @@ <?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.limslaboratory.mapper.EnterpriseUserListMapper"> <mapper namespace="com.yuanchu.limslaboratory.mapper.MaterialMapper"> </mapper> standard-server/src/main/resources/mapper/ProductMapper.xmlcopy from user-server/src/main/resources/mapper/EnterpriseUserListMapper.xml copy to standard-server/src/main/resources/mapper/ProductMapper.xml
Îļþ´Ó user-server/src/main/resources/mapper/EnterpriseUserListMapper.xml ¸´ÖÆ @@ -1,5 +1,5 @@ <?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.limslaboratory.mapper.EnterpriseUserListMapper"> <mapper namespace="com.yuanchu.limslaboratory.mapper.ProductMapper"> </mapper> standard-server/src/main/resources/mapper/SerialNumberMapper.xml
standard-server/src/main/resources/mapper/SpecificationsMapper.xml
ÎļþÃû´Ó standard-library/src/main/resources/mapper/SpecificationsMapper.xml ÐÞ¸Ä @@ -15,7 +15,7 @@ SELECT s.`id`,s.`name`,s.`update_time`,u.`name` username,s.`vel`,s.`spe_state` FROM specifications s,`user` u WHERE s.`user_id` = u.`id` AND s.`serial_id` = #{serialNumberId} AND s.`number` = #{serialNumberId} <if test="specificationsName != null"> AND s.`name` = #{specificationsName} </if> standard-server/src/main/resources/mapper/StandardsMapper.xml
sys/pom.xml
@@ -26,7 +26,14 @@ <!--æ ååºæ¨¡å--> <dependency> <groupId>com.yunchu.limslaboratory</groupId> <artifactId>standard-library</artifactId> <artifactId>standard-server</artifactId> <version>${project.parent.version}</version> </dependency> <!--æ£éªæ¨¡å--> <dependency> <groupId>com.yunchu.limslaboratory</groupId> <artifactId>inspection-server</artifactId> <version>${project.parent.version}</version> </dependency> @@ -41,12 +48,6 @@ <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> </dependency> <!--mybatis-plus--> <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-boot-starter</artifactId> </dependency> <!--mybatis-plus代ç çæå¨--> sys/src/main/java/com/yuanchu/limslaboratory/SysApplication.java
@@ -1,9 +1,13 @@ package com.yuanchu.limslaboratory; import org.mybatis.spring.annotation.MapperScan; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; import org.springframework.cloud.openfeign.EnableFeignClients; @SpringBootApplication @MapperScan("com.yuanchu.limslaboratory.mapper")// æ«æMybatisä¸çmapperå @EnableFeignClients("com.yuanchu.limslaboratory.clients") // æ«æfeignæ¥å£æå¨å éè¦ public class SysApplication { public static void main(String[] args) { sys/src/main/java/com/yuanchu/limslaboratory/backup/MysqlDataBackup.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,190 @@ package com.yuanchu.limslaboratory.backup; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Value; import org.springframework.scheduling.annotation.EnableScheduling; import org.springframework.scheduling.annotation.Scheduled; import org.springframework.stereotype.Component; import java.io.*; import java.text.SimpleDateFormat; import java.util.Date; @Component @EnableScheduling @Slf4j public class MysqlDataBackup { /** * æ°æ®åºçæ¬æ¯å¦ä¸º 8.0 + ï¼false=å¦ true=æ¯ï¼ï¼ mysql8+ éè¦åæ° --column-statistics=0 ï¼ mysql8- ä¸éè¦ */ Boolean isDbVersion8 = false; /** * å¤ä»½å½ä»¤ * USERNAME è´¦å· * PASSWORD å¯ç * SERVERPATH æå¡å¨IP/åå * DBNAME æ°æ®åºåç§° * FILEPATH å¤ä»½æä»¶åæ¾å°å+åç§° * 说æ * cmdCompression ï¼ éå缩 ï¼æ¬å°ææå¡å¨éå®è£ mysqldump å½ä»¤(å®è£ mysqlèªå¸¦æ£ç¬ç«å®è£ ) + gzip å½ä»¤(ç¬ç«å®è£ )ï¼ * cmd ï¼ ä¸å缩 (æ¬å°ææå¡å¨éå®è£ mysqldump å½ä»¤(å®è£ mysqlèªå¸¦æ£ç¬ç«å®è£ ) * --column-statistics=0 mysql8 æ·»å è¯¥åæ°, émysql8 䏿·»å , å¦åå°åºé */ String cmdMysql8 = "mysqldump --column-statistics=0 -u{USERNAME} -p{PASSWORD} -h{SERVERPATH} -P3306 --databases {DBNAME}"; // > {FILEPATH}.sql String cmd = "mysqldump -u{USERNAME} -p{PASSWORD} -h{SERVERPATH} -P3306 --databases {DBNAME}"; // > {FILEPATH}.sql /** * å¤ä»½ sql åæ¾ç®å½(ç¸å¯¹è·¯å¾, 注æå¯è½éè¦å¨ MvcConfig é ç½®è®¿é®æé) */ @Value("${backup.path}") private String filePath; @Value("${spring.datasource.url}") private String dbUrl; @Value("${spring.datasource.username}") private String dbUserName; @Value("${spring.datasource.password}") private String dbPassWord; @Value("${backup.destiny}") private Integer destiny; @Value("${backup.mysqldump}") private String mysqldump; /** * æ¯å¤©æä¸23ç¹05ç§æ§è¡ ã 0 0 4 1/1 * ? ã * æµè¯ 20 ç§ä¸æ¬¡ã 0/20 * * * * ? ã@Scheduled(cron = "5 * 23 * * ?") */ @Scheduled(cron = "5 0 23 * * ?") private void configureTasks() { log.info("ãå¤ä»½æ°æ®åºã--START"); String dbUrl2 = dbUrl.replace("jdbc:mysql://", ""); // è·åæ°æ®åºåç§° String dbName = dbUrl2.substring(dbUrl2.lastIndexOf("/") + 1, dbUrl2.indexOf("?")); // è·åæ°æ®åºå°å String serverPath = dbUrl2.substring(0, dbUrl2.lastIndexOf(":")); // æ°æ®åºè´¦å· String username = dbUserName; // æ°æ®åºå¯ç String password = dbPassWord; // å¤ä»½æä»¶ç®å½+åç§° å¤ä»½æä»¶åæ¾ç®å½+åç§°(åç§° = æ°æ®åºå+æ¶é´å符串.sql) SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm"); String format = simpleDateFormat.format(new Date()); String timeStr = format .replaceAll("-", "_") .replaceAll(" ", "_") .replaceAll(":", ""); timeStr = timeStr.substring(0, 15); String pathFileName = filePath + "/" + dbName + "_" + timeStr + ".sql"; String newCmd = ""; if (isDbVersion8) { newCmd = cmdMysql8; } else { newCmd = cmd; } // æ§è¡å½ä»¤ newCmd = newCmd.replace("{USERNAME}", username) .replace("{PASSWORD}", password) .replace("{SERVERPATH}", serverPath) .replace("{DBNAME}", dbName) .replace("{FILEPATH}", pathFileName); PrintWriter printWriter = null; BufferedReader bufferedReader = null; try { // åå»ºåæ¾sqlçæä»¶ existsFile(new File(pathFileName)); printWriter = new PrintWriter(new OutputStreamWriter(new FileOutputStream(pathFileName), "utf8")); Process process = null; String property = System.getProperty("os.name"); System.out.println(property); if (property.indexOf("Linux") != -1) { // linux process = Runtime.getRuntime().exec(new String[]{"bash", "-c", newCmd}); } else { // æ¬å°win String mysqldumpPath = "cmd /c " + mysqldump + "/" + newCmd; System.out.println(mysqldumpPath); process = Runtime.getRuntime().exec(mysqldumpPath); } InputStreamReader inputStreamReader = new InputStreamReader(process.getInputStream(), "utf8"); bufferedReader = new BufferedReader(inputStreamReader); String line; while ((line = bufferedReader.readLine()) != null) { printWriter.println(line); } // æ¤æ¬¡ä¼æ§è¡è¿é¿æ¶é´,ç´å°å¤ä»½å®æ printWriter.flush(); printWriter.close(); //0 è¡¨ç¤ºçº¿ç¨æ£å¸¸ç»æ¢ã if (process.waitFor() == 0) { // çº¿ç¨æ£å¸¸æ§è¡ log.info("ãå¤ä»½æ°æ®åºãSUCCESSï¼SQLæä»¶ï¼{}", pathFileName); } } catch (Exception e) { e.printStackTrace(); log.info("ãå¤ä»½æ°æ®åºãFAILURE"); } finally { try { if (bufferedReader != null) { bufferedReader.close(); } if (printWriter != null) { printWriter.close(); } } catch (IOException e) { e.printStackTrace(); } } log.info("ãå¤ä»½æ°æ®åºã--END"); } /** * æ¯å¤©æä¸23ç¹0å10ç§æ§è¡ ã 0 0 4 1/1 * ? ã * æµè¯ 20 ç§ä¸æ¬¡ã 0/20 * * * * ? ã */ @Scheduled(cron = "6 0 23 * * ?") private void TimerDeleteFile(){ Date date = new Date(); SimpleDateFormat sdf = new SimpleDateFormat("d"); Integer currentDay = Integer.valueOf(sdf.format(date)); File file = new File(filePath); File[] files = file.listFiles(); if (files != null) { for(File f : files){ if(f.isFile()){//è¥æ¯æä»¶ï¼ç´æ¥æå° String[] splitFile = f.getName().split("_"); Integer fileDay = Integer.valueOf(splitFile[splitFile.length - 2]); Integer i = currentDay - fileDay; if (i.equals(destiny)){ f.delete(); log.info("å¤ä»½sqlæä»¶è¿å¤è¿è¡å é¤ï¼"); } } } } } /** * 夿æä»¶æ¯å¦åå¨ï¼ä¸åå¨å建 */ private static void existsFile(File file) { // 夿æä»¶è·¯å¾æ¯å¦åå¨,ä¸å卿°å»º if (!file.getParentFile().exists()) { file.getParentFile().mkdirs(); } if (!file.exists()) { try { file.createNewFile(); } catch (IOException e) { e.printStackTrace(); } } } } sys/src/main/resources/application-dev.yml
@@ -1,12 +1,37 @@ swagger: enabled: true # æ¥å¿é ç½® logging: config: classpath:logback-spring.xml # æ¥å¿åå¨è·¯å¾+++++++++++++++++++++++++++è¿ç»´éè¦é ç½®+++++++++++++++++++++++++++ file-location: log # æ°æ®åºå¤ä»½è·¯å¾ backup: # æ°æ®åºå¤ä»½è·¯å¾+++++++++++++++++++++++++++è¿ç»´éè¦é ç½®+++++++++++++++++++++++++++ path: E:/webapp/backup # æ°æ®åºå¤ä»½å¤©æ° destiny: 7 # æ°æ®åºå¤ä»½å·¥å ·è·¯å¾+++++++++++++++++++++++++++è¿ç»´éè¦é ç½®+++++++++++++++++++++++++++ mysqldump: E:\JavaCode\WMS\WMS_Admin\src\main\resources # ç §çåå¨è·¯å¾+++++++++++++++++++++++++++è¿ç»´éè¦é ç½®+++++++++++++++++++++++++++ file: path: E:/webapp/images # éµ·é管çç³»ç»å¯é¥ login: userID: c8b1aaacec366c24e5d18c7eea9e551b secret: 701C85FCE0F7CFD714C2052D77098DC7f407b0ee79210bcef51787a0eb8ec7a5 # éµ·éç½ç»IPæè åå customer: url: http://127.0.0.1:6789 mybatis-plus: configuration: log-impl: org.apache.ibatis.logging.stdout.StdOutImpl # å¼å¯mybatis-plusæ¥å¿ logging: config: classpath:logback-spring.xml # æ°æ®æºé ç½® spring: sys/src/main/resources/application-prod.yml
@@ -1,13 +1,36 @@ swagger: enabled: false # æ¥å¿é ç½® logging: config: classpath:logback-spring.xml # æ¥å¿åå¨è·¯å¾+++++++++++++++++++++++++++è¿ç»´éè¦é ç½®+++++++++++++++++++++++++++ file-location: /javaWork/LIMS/log # æ°æ®åºå¤ä»½è·¯å¾ backup: # æ°æ®åºå¤ä»½è·¯å¾+++++++++++++++++++++++++++è¿ç»´éè¦é ç½®+++++++++++++++++++++++++++ path: /javaWork/LIMS/backup # æ°æ®åºå¤ä»½å¤©æ°+++++++++++++++++++++++++++è¿ç»´éè¦é ç½®+++++++++++++++++++++++++++ destiny: 7 # æ°æ®åºå¤ä»½å·¥å ·è·¯å¾+++++++++++++++++++++++++++è¿ç»´éè¦é ç½®+++++++++++++++++++++++++++ mysqldump: /javaWork/LIMS/conf # ç §çè·¯å¾+++++++++++++++++++++++++++è¿ç»´éè¦é ç½®+++++++++++++++++++++++++++ file: path: /javaWork/LIMS/images # éµ·éç½ç»IPæè åå+++++++++++++++++++++++++++è¿ç»´éè¦é ç½®+++++++++++++++++++++++++++ customer: url: http://114.132.189.42:8011 login: userID: c8b1aaacec366c24e5d18c7eea9e551b secret: 701C85FCE0F7CFD714C2052D77098DC7f407b0ee79210bcef51787a0eb8ec7a5 mybatis-plus: configuration: log-impl: org.apache.ibatis.logging.nologging.NoLoggingImpl # å ³émybatis-plusæ¥å¿ logging: config: classpath:logback-spring.xml file-location: /usr/local/webapp/log # æ°æ®æºé ç½® spring: sys/src/main/resources/application.yml
@@ -4,10 +4,6 @@ profiles: active: dev login: userID: c8b1aaacec366c24e5d18c7eea9e551b secret: 701C85FCE0F7CFD714C2052D77098DC7f407b0ee79210bcef51787a0eb8ec7a5 mybatis-plus: type-aliases-package: com.yuanchu.limslaboratory.pojo mapper-locations: classpath*:/mapper/*.xml sys/src/main/resources/logback-spring.xml
@@ -8,7 +8,7 @@ <!-- nameç弿¯åéçåç§°ï¼valueç弿¶åéå®ä¹çå¼ãéè¿å®ä¹çå¼ä¼è¢«æå ¥å°loggerä¸ä¸æä¸ãå®ä¹åï¼å¯ä»¥ä½¿â${}âæ¥ä½¿ç¨åéã --> <springProperty scope="context" name="logs" source="logging.file-location" default="/var/log/myapp"/> <property name="log.path" value="${myLogLocation}"/> <property name="log.path" value="${logs}"/> <!--0. æ¥å¿æ ¼å¼åé¢è²æ¸²æ --> <!-- å½©è²æ¥å¿ä¾èµç渲æç±» --> @@ -196,29 +196,29 @@ <!-- 4 æç»ççç¥ï¼ åºæ¬çç¥(root级) + æ ¹æ®profileå¨å¯å¨æ¶, loggeræ ç¾ä¸å®å¶åpackageæ¥å¿çº§å«(ä¼å 级é«äºä¸é¢çroot级)--> <springProfile name="dev"> <root level="info"> <appender-ref ref="CONSOLE" /> <appender-ref ref="DEBUG_FILE" /> <appender-ref ref="INFO_FILE" /> <appender-ref ref="WARN_FILE" /> <appender-ref ref="ERROR_FILE" /> <appender-ref ref="ALL_FILE" /> </root> <logger name="com.network_manage.SystemSysApplication" level="debug"/> <!-- å¼åç¯å¢, æå®æå æ¥å¿ä¸ºdebug级 --> </springProfile> <!--<springProfile name="dev">--> <!-- <root level="info">--> <!-- <appender-ref ref="CONSOLE" />--> <!-- <appender-ref ref="DEBUG_FILE" />--> <!-- <appender-ref ref="INFO_FILE" />--> <!-- <appender-ref ref="WARN_FILE" />--> <!-- <appender-ref ref="ERROR_FILE" />--> <!-- <appender-ref ref="ALL_FILE" />--> <!-- </root>--> <!-- <logger name="com.yuanchu.limslaboratory.SysApplication" level="debug"/> <!– å¼åç¯å¢, æå®æå æ¥å¿ä¸ºdebug级 –>--> <!--</springProfile>--> <springProfile name="test"> <root level="info"> <appender-ref ref="CONSOLE" /> <appender-ref ref="DEBUG_FILE" /> <appender-ref ref="INFO_FILE" /> <appender-ref ref="WARN_FILE" /> <appender-ref ref="ERROR_FILE" /> <appender-ref ref="ALL_FILE" /> </root> <logger name="com.network_manage.SystemSysApplication" level="info"/> <!-- æµè¯ç¯å¢, æå®æå æ¥å¿ä¸ºinfo级 --> </springProfile> <!--<springProfile name="test">--> <!-- <root level="info">--> <!-- <appender-ref ref="CONSOLE" />--> <!-- <appender-ref ref="DEBUG_FILE" />--> <!-- <appender-ref ref="INFO_FILE" />--> <!-- <appender-ref ref="WARN_FILE" />--> <!-- <appender-ref ref="ERROR_FILE" />--> <!-- <appender-ref ref="ALL_FILE" />--> <!-- </root>--> <!-- <logger name="com.yuanchu.limslaboratory.SysApplication" level="info"/> <!– æµè¯ç¯å¢, æå®æå æ¥å¿ä¸ºinfo级 –>--> <!--</springProfile>--> <springProfile name="prod"> <root level="info"> @@ -229,8 +229,8 @@ <appender-ref ref="ERROR_FILE" /> <appender-ref ref="ALL_FILE" /> </root> <logger name="com.network_manage" level="warn"/> <!-- ç产ç¯å¢, æå®æå æ¥å¿ä¸ºwarn级 --> <logger name="com.network_manage.SystemSysApplication" level="info"/> <!-- ç¹å®æä¸ªç±»æå°infoæ¥å¿, æ¯å¦applicationå¯å¨æååçæç¤ºè¯ --> <logger name="com.yuanchu.limslaboratory" level="warn"/> <!-- ç产ç¯å¢, æå®æå æ¥å¿ä¸ºwarn级 --> <logger name="com.yuanchu.limslaboratory.SysApplication" level="info"/> <!-- ç¹å®æä¸ªç±»æå°infoæ¥å¿, æ¯å¦applicationå¯å¨æååçæç¤ºè¯ --> </springProfile> </configuration> sys/src/main/resources/mysqldump.exeBinary files differ
sys/src/test/java/com/yuanchu/limslaboratory/CodeGenerator.java
@@ -22,7 +22,7 @@ public static String database_username = "root"; public static String database_password= "123456"; public static String author = "æ±èéµ·éç½ç»ç§ææéå ¬å¸"; public static String model_name = "/standard-library"; // å¦æä¸ºåå¸å¼å¡«å模ååç§°ï¼å¦æä¸æ¯åå¸å¼ä¸ºç©ºå³å¯ public static String model_name = "/inspection-server"; // å¦æä¸ºåå¸å¼å¡«å模ååç§°ï¼å¦æä¸æ¯åå¸å¼ä¸ºç©ºå³å¯ public static String setParent = "com.yuanchu.limslaboratory"; // å è·¯å¾ public static Boolean Override = false; // æ¯å¦è¦ç忥çæä»¶ï¼ user-server/pom.xml
@@ -21,12 +21,6 @@ <version>${project.parent.version}</version> </dependency> <!--mybatis-plus--> <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-boot-starter</artifactId> </dependency> <!--feign--> <dependency> <groupId>org.springframework.cloud</groupId> @@ -44,6 +38,12 @@ <groupId>org.apache.shiro</groupId> <artifactId>shiro-spring-boot-starter</artifactId> </dependency> <!--jwt--> <dependency> <groupId>com.auth0</groupId> <artifactId>java-jwt</artifactId> </dependency> </dependencies> </project> user-server/src/main/java/com/yuanchu/limslaboratory/clients/UserLoginUtils.java
@@ -39,6 +39,7 @@ mapRedis.put("id", user.getId()); mapRedis.put("account", user.getAccount()); mapRedis.put("name", user.getName()); mapRedis.put("enterpriseId", user.getEnterpriseId()); mapRedis.put("data", data); //åå ¥redis,äºä¸ªå°æ¶åå é¤ RedisUtil.set(token, mapRedis, 120); user-server/src/main/java/com/yuanchu/limslaboratory/config/FeignConfig.java
@@ -14,7 +14,6 @@ import java.util.concurrent.TimeUnit; @EnableFeignClients("com.yuanchu.limslaboratory.clients") // æ«æfeignæ¥å£æå¨å éè¦ @Configuration @ConditionalOnClass(Feign.class) @AutoConfigureBefore(FeignAutoConfiguration.class) user-server/src/main/java/com/yuanchu/limslaboratory/controller/UserController.java
@@ -8,6 +8,9 @@ import com.yuanchu.limslaboratory.pojo.User; import com.yuanchu.limslaboratory.service.UserService; import com.yuanchu.limslaboratory.shiro.realm.ShiroRealm; import com.yuanchu.limslaboratory.utils.JackSonUtil; import com.yuanchu.limslaboratory.utils.MyUtil; import com.yuanchu.limslaboratory.utils.RedisUtil; import com.yuanchu.limslaboratory.utils.SpringUtil; import com.yuanchu.limslaboratory.vo.NewPersonnelVo; import com.yuanchu.limslaboratory.vo.PagePersonnelVo; @@ -20,6 +23,7 @@ import org.apache.shiro.authc.UsernamePasswordToken; import org.apache.shiro.subject.Subject; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.util.ObjectUtils; import org.springframework.web.bind.annotation.*; import java.util.HashMap; @@ -87,28 +91,30 @@ @PostMapping("/getUserById") @ApiOperation("è·åæå®ç¨æ·idçç¨æ·ä¿¡æ¯åä¼ä¸ä¿¡æ¯") @ApiImplicitParams(value = { @ApiImplicitParam(value = "ç¨æ·id", name = "userId", dataTypeClass = Integer.class, required = true) }) public Result<?> getUserById(int userId) { try { Map<String, String> map = userService.selectUserByUserId(userId); User user = new User(map.get("account"),map.get("uname"),map.get("phone"),map.get("email"),map.get("info")); Enterprise enterprise = new Enterprise(map.get("name"),map.get("byname"),map.get("link_name"),map.get("link_phone")); Map map1 = new HashMap<>(); map1.put("enterprise", enterprise); map1.put("user", user); return Result.success(map1); } catch (Exception e) { return Result.fail("ç¨æ·id为空!"); public Result<?> getUserById(@RequestHeader("X-Token") String token) throws Exception { Object o = RedisUtil.get(token); Map<String, Object> unmarshal = null; if (!ObjectUtils.isEmpty(o)){ unmarshal = JackSonUtil.unmarshal(JackSonUtil.marshal(o), Map.class); Map<String, String> map = userService.selectUserByUserId((Integer) unmarshal.get("id")); MyUtil.PrintLog(map.toString()); return Result.success(map); } return Result.fail("Tokené误ï¼"); } @PostMapping("/add_new_personnel") @ApiOperation("å®éªå®¤ç®¡ç-->人å管ç-->æ°å¢äººå") public Result<?> addNewPersonnel(@RequestBody NewPersonnelVo newPersonnelVo) { public Result<?> addNewPersonnel(@RequestHeader("X-Token") String token, @RequestBody NewPersonnelVo newPersonnelVo) throws Exception { Object redisUserMessage = RedisUtil.get(token); Map<String, Object> user = null; Integer isAddSuccess = 0; if (!ObjectUtils.isEmpty(redisUserMessage)) { user = JackSonUtil.unmarshal(JackSonUtil.marshal(redisUserMessage), Map.class); newPersonnelVo.setPassword("123456"); Integer isAddSuccess = userService.addNewPersonnel(newPersonnelVo); isAddSuccess = userService.addNewPersonnel(newPersonnelVo, user.get("enterpriseId").toString()); } if (isAddSuccess == 1){ return Result.success("æ·»å ã" + newPersonnelVo.getName() + "ãæåï¼é»è®¤å¯ç 为ï¼" + newPersonnelVo.getPassword()); } user-server/src/main/java/com/yuanchu/limslaboratory/mapper/EnterpriseUserListMapper.java
ÎļþÒÑɾ³ý user-server/src/main/java/com/yuanchu/limslaboratory/mapper/UserMapper.java
@@ -5,8 +5,10 @@ import com.yuanchu.limslaboratory.pojo.User; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.yuanchu.limslaboratory.vo.PagePersonnelVo; import org.apache.ibatis.annotations.Mapper; import org.springframework.stereotype.Repository; import javax.annotation.Resource; import java.util.Map; import java.util.Objects; user-server/src/main/java/com/yuanchu/limslaboratory/pojo/Enterprise.java
@@ -39,12 +39,6 @@ @ApiModelProperty(value = "ä¼ä¸ç®ç§°") private String byname; @ApiModelProperty(value = "è系人账å·") private String linkAccount; @ApiModelProperty(value = "è系人å¯ç ") private String linkPassword; @ApiModelProperty(value = "è系人åå") private String linkName; user-server/src/main/java/com/yuanchu/limslaboratory/pojo/EnterpriseUserList.java
ÎļþÒÑɾ³ý user-server/src/main/java/com/yuanchu/limslaboratory/pojo/User.java
@@ -76,6 +76,9 @@ @ApiModelProperty(value = "å ³è è§è²id") private Integer roleId; @ApiModelProperty(value = "å ³è ä¼ä¸id") private Integer enterpriseId; public User(String account, String name, String phone, String email, String info) { this.account = account; this.name = name; user-server/src/main/java/com/yuanchu/limslaboratory/service/EnterpriseUserListService.java
ÎļþÒÑɾ³ý user-server/src/main/java/com/yuanchu/limslaboratory/service/UserService.java
@@ -7,6 +7,7 @@ import com.yuanchu.limslaboratory.vo.NewPersonnelVo; import com.yuanchu.limslaboratory.vo.PagePersonnelVo; import com.yuanchu.limslaboratory.vo.UpdatePersonnelVo; import org.springframework.transaction.annotation.Transactional; import java.io.Serializable; @@ -27,7 +28,7 @@ User AccordingUsernameSelectAll(String account); Integer addNewPersonnel(NewPersonnelVo newPersonnelVo); Integer addNewPersonnel(NewPersonnelVo newPersonnelVo, String enterpriseId); Integer updateNewPersonnel(UpdatePersonnelVo updatePersonnelVo); user-server/src/main/java/com/yuanchu/limslaboratory/service/impl/EnterpriseUserListServiceImpl.java
ÎļþÒÑɾ³ý user-server/src/main/java/com/yuanchu/limslaboratory/service/impl/UserServiceImpl.java
@@ -3,7 +3,6 @@ import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.conditions.update.LambdaUpdateChainWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.yuanchu.limslaboratory.pojo.User; import com.yuanchu.limslaboratory.mapper.UserMapper; @@ -13,13 +12,13 @@ import com.yuanchu.limslaboratory.vo.NewPersonnelVo; import com.yuanchu.limslaboratory.vo.PagePersonnelVo; import com.yuanchu.limslaboratory.vo.UpdatePersonnelVo; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.util.ObjectUtils; import javax.annotation.Resource; import java.util.HashMap; import java.util.Map; import java.util.Objects; /** * <p> @@ -74,12 +73,12 @@ public User AccordingUsernameSelectAll(String account) { LambdaQueryWrapper<User> wrapper = new LambdaQueryWrapper<>(); wrapper.eq(User::getAccount, account); wrapper.select(User::getPassword, User::getId, User::getName, User::getAccount); wrapper.select(User::getPassword, User::getId, User::getName, User::getAccount, User::getEnterpriseId); return userMapper.selectOne(wrapper); } @Override public Integer addNewPersonnel(NewPersonnelVo newPersonnelVo) { public Integer addNewPersonnel(NewPersonnelVo newPersonnelVo, String enterpriseId) { User user = new User() .setName(newPersonnelVo.getName()) .setAccount(newPersonnelVo.getAccount()) @@ -87,7 +86,8 @@ .setPhone(newPersonnelVo.getPhone()) .setEmail(newPersonnelVo.getEmail()) .setRoleId(newPersonnelVo.getRole_id()) .setPassword(newPersonnelVo.getPassword()); .setPassword(newPersonnelVo.getPassword()) .setEnterpriseId(Integer.valueOf(enterpriseId)); return userMapper.insert(user); } user-server/src/main/java/com/yuanchu/limslaboratory/vo/NewPersonnelVo.java
@@ -1,5 +1,6 @@ package com.yuanchu.limslaboratory.vo; import com.baomidou.mybatisplus.annotation.TableField; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; user-server/src/main/resources/mapper/UserMapper.xml
@@ -3,11 +3,10 @@ <mapper namespace="com.yuanchu.limslaboratory.mapper.UserMapper"> <select id="selectUserByUserId" parameterType="int" resultType="Map"> select u.account account,u.name uname,u.phone,u.email,u.info,e.byname,e.`name`,e.link_name,e.link_phone from enterprise_user_list el,enterprise e,`user` u where e.id = el.enterprise_id and el.user_id = u.id and u.id = #{userId} SELECT u.account account,u.name uname,u.phone,u.email,u.info,e.byname e_byname,e.`name` e_name,e.link_name e_link_name,e.link_phone e_phone FROM enterprise e,`user` u WHERE e.`id` = u.`enterprise_id` AND u.id = #{userId} </select> <resultMap id="PagePersonnelVoMap" type="com.yuanchu.limslaboratory.vo.PagePersonnelVo">