hs_err_pid13764.log
ÎļþÒÑɾ³ý pom.xml
@@ -9,15 +9,19 @@ <relativePath/> <!-- lookup parent from repository --> </parent> <groupId>com.zmc</groupId> <artifactId>web_01</artifactId> <groupId>com.flightfeather</groupId> <artifactId>monitor</artifactId> <version>0.0.1-SNAPSHOT</version> <name>web_01</name> <name>monitor</name> <packaging>war</packaging> <description>web_01</description> <description>monitor managet</description> <properties> <java.version>1.8</java.version> <kotlin.version>1.8.22</kotlin.version> <!-- tk.mybatis --> <mapper.plugin>tk.mybatis.mapper.generator.MapperPlugin</mapper.plugin> <mapper.Mapper>tk.mybatis.mapper.common.Mapper</mapper.Mapper> </properties> <dependencies> <dependency> @@ -28,14 +32,19 @@ <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>2.3.1</version> </dependency> <dependency> <groupId>org.mybatis.generator</groupId> <artifactId>mybatis-generator-core</artifactId> <version>1.4.2</version> </dependency> <!-- <dependency>--> <!-- <groupId>com.mysql</groupId>--> <!-- <artifactId>mysql-connector-j</artifactId>--> <!-- <scope>runtime</scope>--> <!-- </dependency>--> <!--tk.mybatis--> <dependency> <groupId>tk.mybatis</groupId> <artifactId>mapper-spring-boot-starter</artifactId> <version>4.2.2</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> @@ -57,16 +66,10 @@ <artifactId>pagehelper-spring-boot-starter</artifactId> <version>1.4.6</version> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-configuration-processor</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-aop</artifactId> @@ -92,20 +95,95 @@ <build> <plugins> <!-- <plugin>--> <!-- <groupId>org.springframework.boot</groupId>--> <!-- <artifactId>spring-boot-maven-plugin</artifactId>--> <!-- <version>3.0.5</version>--> <!-- <configuration>--> <!-- <excludes>--> <!-- <exclude>--> <!-- <groupId>org.projectlombok</groupId>--> <!-- <artifactId>lombok</artifactId>--> <!-- </exclude>--> <!-- </excludes>--> <!-- </configuration>--> <!-- </plugin>--> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> </plugin> <plugin> <groupId>org.jetbrains.kotlin</groupId> <artifactId>kotlin-maven-plugin</artifactId> <configuration> <args> <arg>-Xjsr305=strict</arg> </args> <compilerPlugins> <plugin>spring</plugin> </compilerPlugins> </configuration> <dependencies> <dependency> <groupId>org.jetbrains.kotlin</groupId> <artifactId>kotlin-maven-allopen</artifactId> <version>${kotlin.version}</version> </dependency> </dependencies> </plugin> <!-- mybatis generator èªå¨çæä»£ç æä»¶ --> <plugin> <groupId>org.mybatis.generator</groupId> <artifactId>mybatis-generator-maven-plugin</artifactId> <version>1.3.7</version> <configuration> <!-- 设置æä»¶è¿è¡çæä»¶è·¯å¾--> <configurationFile>src/main/resources/generator/generatorConfig4ds1.xml</configurationFile> <overwrite>true</overwrite> <verbose>true</verbose> </configuration> <dependencies> <!-- https://mvnrepository.com/artifact/tk.mybatis/mapper --> <dependency> <groupId>tk.mybatis</groupId> <artifactId>mapper</artifactId> <version>4.1.5</version> </dependency> </dependencies> </plugin> </plugins> </build> <!--ä¾èµä¸è½½å°å--> <repositories> <repository> <id>alimaven</id> <name>aliyun maven</name> <url>https://maven.aliyun.com/repository/public</url> </repository> <repository> <id>spring-snapshots</id> <name>Spring Snapshots</name> <url>https://repo.spring.io/snapshot</url> <snapshots> <enabled>true</enabled> </snapshots> </repository> <repository> <id>spring-milestones</id> <name>Spring Milestones</name> <url>https://repo.spring.io/milestone</url> <snapshots> <enabled>false</enabled> </snapshots> </repository> </repositories> <pluginRepositories> <pluginRepository> <id>spring-snapshots</id> <name>Spring Snapshots</name> <url>https://repo.spring.io/snapshot</url> <snapshots> <enabled>true</enabled> </snapshots> </pluginRepository> <pluginRepository> <id>spring-milestones</id> <name>Spring Milestones</name> <url>https://repo.spring.io/milestone</url> <snapshots> <enabled>false</enabled> </snapshots> </pluginRepository> </pluginRepositories> </project> src/main/java/com/flightfeather/monitor/QianduanApplication.java
ÎļþÃû´Ó src/main/java/com/job/zsc/QianduanApplication.java ÐÞ¸Ä @@ -1,8 +1,7 @@ package com.job.zsc; package com.flightfeather.monitor; import com.job.zsc.scheduledtasks.TaskController; import com.flightfeather.monitor.scheduledtasks.TaskController; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.boot.ApplicationArguments; import org.springframework.boot.ApplicationRunner; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; src/main/java/com/flightfeather/monitor/ServletInitializer.java
ÎļþÃû´Ó src/main/java/com/job/zsc/ServletInitializer.java ÐÞ¸Ä @@ -1,4 +1,4 @@ package com.job.zsc; package com.flightfeather.monitor; import org.springframework.boot.builder.SpringApplicationBuilder; import org.springframework.boot.web.servlet.support.SpringBootServletInitializer; src/main/java/com/flightfeather/monitor/analysis/AnalysisController.kt
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,7 @@ package com.flightfeather.monitor.analysis /** * æ°æ®åææ§å¶å¨ */ class AnalysisController { } src/main/java/com/flightfeather/monitor/analysis/DataAnalysisInterface.kt
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,30 @@ package com.flightfeather.monitor.analysis /** * æ°æ®åææ¥å£ */ abstract class DataAnalysisInterface<T, V>(config: V) { init { initConfig(config) } abstract fun initConfig(config: V) /** * æ¥æ¶ä¸ä¸ä¸ªæ¶é´ç¹çæ°æ® */ abstract fun onNextData(data: T) /** * å°åæç»æå ¥åº */ abstract fun toDb() /** * 夿ç¸é»æ°æ®æ¯å¦è¿ç» */ fun isContinuous(d1:T, d2:T) { } } src/main/java/com/flightfeather/monitor/analysis/dust/ExceptionValueMutation.kt
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,39 @@ package com.flightfeather.monitor.analysis.dust import com.flightfeather.monitor.analysis.DataAnalysisInterface import com.flightfeather.monitor.domain.ds1.entity.DustExceptionSetting import com.flightfeather.monitor.domain.ds1.entity.DustSiteData import java.util.* import kotlin.properties.Delegates /** * é级çªåå¼å¸¸åæ */ class ExceptionValueMutation(config: DustExceptionSetting) : DataAnalysisInterface<DustSiteData, DustExceptionSetting>(config) { private var mutationNum by Delegates.notNull<Int>() private var mutationRate by Delegates.notNull<Double>() private var lastDataTime: Date? = null override fun initConfig(config: DustExceptionSetting) { mutationNum = config.mutationNum mutationRate = config.mutationRate } override fun onNextData(data: DustSiteData) { if (lastDataTime != null) { // ç¸é»æ°æ®æ¶é´å°äºæçäº30åéå为ä¸ç» } lastDataTime = data.lst } override fun toDb() { TODO("Not yet implemented") } } src/main/java/com/flightfeather/monitor/config/DataSourceConfig.kt
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,45 @@ package com.flightfeather.monitor.config import org.springframework.beans.factory.annotation.Qualifier import org.springframework.boot.autoconfigure.jdbc.DataSourceProperties import org.springframework.boot.context.properties.ConfigurationProperties import org.springframework.context.annotation.Bean import org.springframework.context.annotation.Configuration import org.springframework.context.annotation.Primary import javax.sql.DataSource /** * 夿°æ®æºé ç½® */ @Configuration class DataSourceConfig { //ä¸»æ°æ®æºé ç½® ds1æ°æ®æº @Primary @Bean(name = ["ds1DataSourceProperties"]) @ConfigurationProperties(prefix = "spring.datasource.ds1") fun ds1DataSourceProperties(): DataSourceProperties? { return DataSourceProperties() } //ä¸»æ°æ®æº ds1æ°æ®æº @Primary @Bean(name = ["ds1DataSource"]) fun ds1DataSource(@Qualifier("ds1DataSourceProperties") dataSourceProperties: DataSourceProperties): DataSource? { return dataSourceProperties.initializeDataSourceBuilder().build() } //第äºä¸ªds2æ°æ®æºé ç½® // @Bean(name = ["ds2DataSourceProperties"]) // @ConfigurationProperties(prefix = "spring.datasource.ds2") // fun ds2DataSourceProperties(): DataSourceProperties? { // return DataSourceProperties() // } //第äºä¸ªds2æ°æ®æº // @Bean("ds2DataSource") // fun ds2DataSource(@Qualifier("ds2DataSourceProperties") dataSourceProperties: DataSourceProperties): DataSource? { // return dataSourceProperties.initializeDataSourceBuilder().build() // } } src/main/java/com/flightfeather/monitor/config/MybatisConfig4ds1.kt
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,48 @@ package com.flightfeather.monitor.config import org.apache.ibatis.session.SqlSessionFactory import org.mybatis.spring.SqlSessionFactoryBean import org.mybatis.spring.SqlSessionTemplate import org.mybatis.spring.annotation.MapperScan import org.springframework.beans.factory.annotation.Qualifier import org.springframework.context.annotation.Bean import org.springframework.context.annotation.Configuration import org.springframework.context.annotation.Primary import org.springframework.core.io.support.PathMatchingResourcePatternResolver import org.springframework.jdbc.datasource.DataSourceTransactionManager import javax.sql.DataSource /** * Mybatisä¸»æ°æ®æºds1é ç½® * 夿°æ®æºé ç½®ä¾èµæ°æ®æºé ç½® * @see DataSourceConfig */ @Configuration @MapperScan(basePackages = ["com.flightfeather.monitor.domain.ds1.mapper"], sqlSessionTemplateRef = "ds1SqlSessionTemplate") class MybatisConfig4ds1 { //ä¸»æ°æ®æº ds1æ°æ®æº @Primary @Bean("ds1SqlSessionFactory") @Throws(Exception::class) fun ds1SqlSessionFactory(@Qualifier("ds1DataSource") dataSource: DataSource?): SqlSessionFactory? { val sqlSessionFactory = SqlSessionFactoryBean() sqlSessionFactory.setDataSource(dataSource) sqlSessionFactory.setMapperLocations(*PathMatchingResourcePatternResolver().getResources("classpath*:mapper/ds1/*.xml")) return sqlSessionFactory.getObject() } @Primary @Bean(name = ["ds1TransactionManager"]) fun ds1TransactionManager(@Qualifier("ds1DataSource") dataSource: DataSource): DataSourceTransactionManager? { return DataSourceTransactionManager(dataSource) } @Primary @Bean(name = ["ds1SqlSessionTemplate"]) fun ds1SqlSessionTemplate(@Qualifier("ds1SqlSessionFactory") sqlSessionFactory: SqlSessionFactory?): SqlSessionTemplate? { return SqlSessionTemplate(sqlSessionFactory) } } src/main/java/com/flightfeather/monitor/config/TaskPoolConfig.kt
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,30 @@ package com.flightfeather.monitor.config import org.springframework.scheduling.annotation.EnableAsync import org.springframework.aop.interceptor.AsyncExecutionAspectSupport import org.springframework.context.annotation.Bean import org.springframework.context.annotation.Configuration import org.springframework.scheduling.concurrent.ThreadPoolTaskExecutor import java.util.concurrent.Executor import java.util.concurrent.ThreadPoolExecutor @EnableAsync @Configuration class TaskPoolConfig { @Bean(name = [AsyncExecutionAspectSupport.DEFAULT_TASK_EXECUTOR_BEAN_NAME]) fun taskExecutor(): Executor { val executor = ThreadPoolTaskExecutor() //æ ¸å¿çº¿ç¨æ± å¤§å° executor.corePoolSize = 10 //æå¤§çº¿ç¨æ° executor.maxPoolSize = 20 //éå容é executor.queueCapacity = 200 //æ´»è·æ¶é´ executor.keepAliveSeconds = 60 //线ç¨åååç¼ executor.setThreadNamePrefix("taskExecutor-") executor.setRejectedExecutionHandler(ThreadPoolExecutor.CallerRunsPolicy()) return executor } } src/main/java/com/flightfeather/monitor/controller/AnalysisDataController.java
ÎļþÃû´Ó src/main/java/com/job/zsc/controller/AnalysisDataController.java ÐÞ¸Ä @@ -1,8 +1,8 @@ package com.job.zsc.controller; package com.flightfeather.monitor.controller; import com.job.zsc.pojo.AnalysisData; import com.job.zsc.pojo.Result; import com.job.zsc.service.AnalysisDataService; import com.flightfeather.monitor.pojo.AnalysisData; import com.flightfeather.monitor.pojo.Result; import com.flightfeather.monitor.service.AnalysisDataService; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; src/main/java/com/flightfeather/monitor/controller/FugitiveDustController.java
ÎļþÃû´Ó src/main/java/com/job/zsc/controller/FugitiveDustController.java ÐÞ¸Ä @@ -1,8 +1,8 @@ package com.job.zsc.controller; package com.flightfeather.monitor.controller; import com.job.zsc.pojo.*; import com.job.zsc.service.FugitiveDustService; import com.flightfeather.monitor.pojo.*; import com.flightfeather.monitor.service.FugitiveDustService; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; @@ -156,7 +156,7 @@ /*æ ¹æ®å¼å¸¸ç±»ååæ¶æ®µ è¿åç«ç¹åå*/ @GetMapping("/exceptionsSiteName") public Result getSiteNameByTimeAndExceptionType(String [] exceptionType,String beginTime, String endTime){ public Result getSiteNameByTimeAndExceptionType(String [] exceptionType, String beginTime, String endTime){ List<DustExceptionData> list = fugitiveDustService.getSiteNameByTimeAndExceptionType(exceptionType,beginTime,endTime); return Result.success(list); } src/main/java/com/flightfeather/monitor/controller/LoginController.java
ÎļþÃû´Ó src/main/java/com/job/zsc/controller/LoginController.java ÐÞ¸Ä @@ -1,14 +1,11 @@ package com.job.zsc.controller; package com.flightfeather.monitor.controller; import com.job.zsc.pojo.LoginUser; import com.job.zsc.pojo.Result; import com.job.zsc.service.LoginService; import com.flightfeather.monitor.pojo.LoginUser; import com.flightfeather.monitor.pojo.Result; import com.flightfeather.monitor.service.LoginService; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import java.util.HashMap; import java.util.Map; @RequestMapping("/dust") @CrossOrigin src/main/java/com/flightfeather/monitor/controller/SqlController.java
ÎļþÃû´Ó src/main/java/com/job/zsc/controller/SqlController.java ÐÞ¸Ä @@ -1,9 +1,9 @@ package com.job.zsc.controller; package com.flightfeather.monitor.controller; import com.job.zsc.pojo.PageBean; import com.job.zsc.pojo.Result; import com.job.zsc.pojo.OriginalData; import com.job.zsc.service.SqlService; import com.flightfeather.monitor.pojo.PageBean; import com.flightfeather.monitor.pojo.Result; import com.flightfeather.monitor.pojo.OriginalData; import com.flightfeather.monitor.service.SqlService; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.format.annotation.DateTimeFormat; src/main/java/com/flightfeather/monitor/controller/Vue3FumeController.java
ÎļþÃû´Ó src/main/java/com/job/zsc/controller/Vue3FumeController.java ÐÞ¸Ä @@ -1,14 +1,11 @@ package com.job.zsc.controller; package com.flightfeather.monitor.controller; import com.job.zsc.pojo.*; import com.job.zsc.service.Vue3FumeService; import com.flightfeather.monitor.pojo.*; import com.flightfeather.monitor.service.Vue3FumeService; import lombok.extern.slf4j.Slf4j; import org.apache.ibatis.annotations.Param; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.*; import javax.naming.InsufficientResourcesException; import java.util.List; @Slf4j src/main/java/com/flightfeather/monitor/domain/ds1/entity/DustExceptionData.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,141 @@ package com.flightfeather.monitor.domain.ds1.entity; import java.util.Date; import javax.persistence.*; @Table(name = "dust_exception_data") public class DustExceptionData { @Id private Integer id; @Column(name = "mn_code") private String mnCode; private String exception; @Column(name = "exception_type") private Integer exceptionType; private String region; @Column(name = "begin_time") private Date beginTime; @Column(name = "end_time") private Date endTime; @Column(name = "avg_value") private Double avgValue; /** * @return id */ public Integer getId() { return id; } /** * @param id */ public void setId(Integer id) { this.id = id; } /** * @return mn_code */ public String getMnCode() { return mnCode; } /** * @param mnCode */ public void setMnCode(String mnCode) { this.mnCode = mnCode == null ? null : mnCode.trim(); } /** * @return exception */ public String getException() { return exception; } /** * @param exception */ public void setException(String exception) { this.exception = exception == null ? null : exception.trim(); } /** * @return exception_type */ public Integer getExceptionType() { return exceptionType; } /** * @param exceptionType */ public void setExceptionType(Integer exceptionType) { this.exceptionType = exceptionType; } /** * @return region */ public String getRegion() { return region; } /** * @param region */ public void setRegion(String region) { this.region = region == null ? null : region.trim(); } /** * @return begin_time */ public Date getBeginTime() { return beginTime; } /** * @param beginTime */ public void setBeginTime(Date beginTime) { this.beginTime = beginTime; } /** * @return end_time */ public Date getEndTime() { return endTime; } /** * @param endTime */ public void setEndTime(Date endTime) { this.endTime = endTime; } /** * @return avg_value */ public Double getAvgValue() { return avgValue; } /** * @param avgValue */ public void setAvgValue(Double avgValue) { this.avgValue = avgValue; } } src/main/java/com/flightfeather/monitor/domain/ds1/entity/DustExceptionSetting.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,311 @@ package com.flightfeather.monitor.domain.ds1.entity; import java.util.Date; import javax.persistence.*; @Table(name = "dust_exception_setting") public class DustExceptionSetting { @Id private Integer id; private String user; @Column(name = "update_time") private Date updateTime; private String version; @Column(name = "miss_data_minutes") private Integer missDataMinutes; @Column(name = "data_low") private Double dataLow; @Column(name = "long_time_no_change") private Integer longTimeNoChange; @Column(name = "mutation_num") private Integer mutationNum; @Column(name = "mutation_rate") private Double mutationRate; @Column(name = "near_exceed_low_value") private Double nearExceedLowValue; @Column(name = "near_exceed_high_value") private Double nearExceedHighValue; @Column(name = "near_exceed_num") private Integer nearExceedNum; @Column(name = "day_exceed_borderline_low_num") private Integer dayExceedBorderlineLowNum; @Column(name = "day_exceed_borderline_high_num") private Integer dayExceedBorderlineHighNum; @Column(name = "change_trend_group") private Integer changeTrendGroup; @Column(name = "change_trend_interval") private Integer changeTrendInterval; @Column(name = "change_trend_rate") private Double changeTrendRate; @Column(name = "exceeding_standard") private Double exceedingStandard; /** * @return id */ public Integer getId() { return id; } /** * @param id */ public void setId(Integer id) { this.id = id; } /** * @return user */ public String getUser() { return user; } /** * @param user */ public void setUser(String user) { this.user = user == null ? null : user.trim(); } /** * @return update_time */ public Date getUpdateTime() { return updateTime; } /** * @param updateTime */ public void setUpdateTime(Date updateTime) { this.updateTime = updateTime; } /** * @return version */ public String getVersion() { return version; } /** * @param version */ public void setVersion(String version) { this.version = version == null ? null : version.trim(); } /** * @return miss_data_minutes */ public Integer getMissDataMinutes() { return missDataMinutes; } /** * @param missDataMinutes */ public void setMissDataMinutes(Integer missDataMinutes) { this.missDataMinutes = missDataMinutes; } /** * @return data_low */ public Double getDataLow() { return dataLow; } /** * @param dataLow */ public void setDataLow(Double dataLow) { this.dataLow = dataLow; } /** * @return long_time_no_change */ public Integer getLongTimeNoChange() { return longTimeNoChange; } /** * @param longTimeNoChange */ public void setLongTimeNoChange(Integer longTimeNoChange) { this.longTimeNoChange = longTimeNoChange; } /** * @return mutation_num */ public Integer getMutationNum() { return mutationNum; } /** * @param mutationNum */ public void setMutationNum(Integer mutationNum) { this.mutationNum = mutationNum; } /** * @return mutation_rate */ public Double getMutationRate() { return mutationRate; } /** * @param mutationRate */ public void setMutationRate(Double mutationRate) { this.mutationRate = mutationRate; } /** * @return near_exceed_low_value */ public Double getNearExceedLowValue() { return nearExceedLowValue; } /** * @param nearExceedLowValue */ public void setNearExceedLowValue(Double nearExceedLowValue) { this.nearExceedLowValue = nearExceedLowValue; } /** * @return near_exceed_high_value */ public Double getNearExceedHighValue() { return nearExceedHighValue; } /** * @param nearExceedHighValue */ public void setNearExceedHighValue(Double nearExceedHighValue) { this.nearExceedHighValue = nearExceedHighValue; } /** * @return near_exceed_num */ public Integer getNearExceedNum() { return nearExceedNum; } /** * @param nearExceedNum */ public void setNearExceedNum(Integer nearExceedNum) { this.nearExceedNum = nearExceedNum; } /** * @return day_exceed_borderline_low_num */ public Integer getDayExceedBorderlineLowNum() { return dayExceedBorderlineLowNum; } /** * @param dayExceedBorderlineLowNum */ public void setDayExceedBorderlineLowNum(Integer dayExceedBorderlineLowNum) { this.dayExceedBorderlineLowNum = dayExceedBorderlineLowNum; } /** * @return day_exceed_borderline_high_num */ public Integer getDayExceedBorderlineHighNum() { return dayExceedBorderlineHighNum; } /** * @param dayExceedBorderlineHighNum */ public void setDayExceedBorderlineHighNum(Integer dayExceedBorderlineHighNum) { this.dayExceedBorderlineHighNum = dayExceedBorderlineHighNum; } /** * @return change_trend_group */ public Integer getChangeTrendGroup() { return changeTrendGroup; } /** * @param changeTrendGroup */ public void setChangeTrendGroup(Integer changeTrendGroup) { this.changeTrendGroup = changeTrendGroup; } /** * @return change_trend_interval */ public Integer getChangeTrendInterval() { return changeTrendInterval; } /** * @param changeTrendInterval */ public void setChangeTrendInterval(Integer changeTrendInterval) { this.changeTrendInterval = changeTrendInterval; } /** * @return change_trend_rate */ public Double getChangeTrendRate() { return changeTrendRate; } /** * @param changeTrendRate */ public void setChangeTrendRate(Double changeTrendRate) { this.changeTrendRate = changeTrendRate; } /** * @return exceeding_standard */ public Double getExceedingStandard() { return exceedingStandard; } /** * @param exceedingStandard */ public void setExceedingStandard(Double exceedingStandard) { this.exceedingStandard = exceedingStandard; } } src/main/java/com/flightfeather/monitor/domain/ds1/entity/DustGlobalSetting.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,208 @@ package com.flightfeather.monitor.domain.ds1.entity; import java.util.Date; import javax.persistence.*; @Table(name = "dust_global_setting") public class DustGlobalSetting { @Id private Integer id; /** * ç¨æ· */ private String user; /** * å建æ¶é´ */ @Column(name = "create_time") private Date createTime; /** * æ´æ°æ¶é´ */ @Column(name = "update_time") private Date updateTime; /** * ç±»åï¼æ¬å°ï¼æ²¹çï¼ */ private String type; /** * è¶ æ é¢è®¾å¼ */ private Double exceeding; @Column(name = "begin_time") private Date beginTime; @Column(name = "end_time") private Date endTime; private String region; @Column(name = "is_regular_time") private String isRegularTime; /** * @return id */ public Integer getId() { return id; } /** * @param id */ public void setId(Integer id) { this.id = id; } /** * è·åç¨æ· * * @return user - ç¨æ· */ public String getUser() { return user; } /** * è®¾ç½®ç¨æ· * * @param user ç¨æ· */ public void setUser(String user) { this.user = user == null ? null : user.trim(); } /** * è·åå建æ¶é´ * * @return create_time - å建æ¶é´ */ public Date getCreateTime() { return createTime; } /** * 设置å建æ¶é´ * * @param createTime å建æ¶é´ */ public void setCreateTime(Date createTime) { this.createTime = createTime; } /** * è·åæ´æ°æ¶é´ * * @return update_time - æ´æ°æ¶é´ */ public Date getUpdateTime() { return updateTime; } /** * è®¾ç½®æ´æ°æ¶é´ * * @param updateTime æ´æ°æ¶é´ */ public void setUpdateTime(Date updateTime) { this.updateTime = updateTime; } /** * è·åç±»åï¼æ¬å°ï¼æ²¹çï¼ * * @return type - ç±»åï¼æ¬å°ï¼æ²¹çï¼ */ public String getType() { return type; } /** * 设置类åï¼æ¬å°ï¼æ²¹çï¼ * * @param type ç±»åï¼æ¬å°ï¼æ²¹çï¼ */ public void setType(String type) { this.type = type == null ? null : type.trim(); } /** * è·åè¶ æ é¢è®¾å¼ * * @return exceeding - è¶ æ é¢è®¾å¼ */ public Double getExceeding() { return exceeding; } /** * è®¾ç½®è¶ æ é¢è®¾å¼ * * @param exceeding è¶ æ é¢è®¾å¼ */ public void setExceeding(Double exceeding) { this.exceeding = exceeding; } /** * @return begin_time */ public Date getBeginTime() { return beginTime; } /** * @param beginTime */ public void setBeginTime(Date beginTime) { this.beginTime = beginTime; } /** * @return end_time */ public Date getEndTime() { return endTime; } /** * @param endTime */ public void setEndTime(Date endTime) { this.endTime = endTime; } /** * @return region */ public String getRegion() { return region; } /** * @param region */ public void setRegion(String region) { this.region = region == null ? null : region.trim(); } /** * @return is_regular_time */ public String getIsRegularTime() { return isRegularTime; } /** * @param isRegularTime */ public void setIsRegularTime(String isRegularTime) { this.isRegularTime = isRegularTime == null ? null : isRegularTime.trim(); } } src/main/java/com/flightfeather/monitor/domain/ds1/entity/DustSiteData.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,139 @@ package com.flightfeather.monitor.domain.ds1.entity; import java.util.Date; import javax.persistence.*; @Table(name = "ja_t_dust_site_data_info") public class DustSiteData { @Id private Integer id; @Column(name = "mn_code") private String mnCode; @Column(name = "dust_value") private Double dustValue; @Column(name = "noise_value") private Double noiseValue; private Date lst; private String quality; private Integer grade; private String flag; /** * @return id */ public Integer getId() { return id; } /** * @param id */ public void setId(Integer id) { this.id = id; } /** * @return mn_code */ public String getMnCode() { return mnCode; } /** * @param mnCode */ public void setMnCode(String mnCode) { this.mnCode = mnCode == null ? null : mnCode.trim(); } /** * @return dust_value */ public Double getDustValue() { return dustValue; } /** * @param dustValue */ public void setDustValue(Double dustValue) { this.dustValue = dustValue; } /** * @return noise_value */ public Double getNoiseValue() { return noiseValue; } /** * @param noiseValue */ public void setNoiseValue(Double noiseValue) { this.noiseValue = noiseValue; } /** * @return lst */ public Date getLst() { return lst; } /** * @param lst */ public void setLst(Date lst) { this.lst = lst; } /** * @return quality */ public String getQuality() { return quality; } /** * @param quality */ public void setQuality(String quality) { this.quality = quality == null ? null : quality.trim(); } /** * @return grade */ public Integer getGrade() { return grade; } /** * @param grade */ public void setGrade(Integer grade) { this.grade = grade; } /** * @return flag */ public String getFlag() { return flag; } /** * @param flag */ public void setFlag(String flag) { this.flag = flag == null ? null : flag.trim(); } } src/main/java/com/flightfeather/monitor/domain/ds1/entity/DustSiteInfo.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,1100 @@ package com.flightfeather.monitor.domain.ds1.entity; import java.util.Date; import javax.persistence.*; @Table(name = "ja_t_dust_site_info") public class DustSiteInfo { @Id private Integer id; /** * 设å¤ç¼ç */ @Column(name = "mn_code") private String mnCode; /** * å®è£ å°å */ private String address; /** * ç«ç¹åç§° */ private String name; /** * ç«ç¹ç¼ç */ private String code; /** * å¼å·¥æ¶é´ */ @Column(name = "begin_date") private Date beginDate; /** * è¿ç»´å */ @Column(name = "duty_company") private String dutyCompany; /** * è¿ç»´åid */ @Column(name = "duty_company_id") private String dutyCompanyId; /** * ç»ææ¶é´ */ @Column(name = "end_date") private Date endDate; /** * å½åæ½å·¥é¶æ®µ */ @Column(name = "engineering_stage") private String engineeringStage; /** * æå±åºå¿ä»£ç */ @Column(name = "group_id") private String groupId; /** * æå±åºå¿ */ @Column(name = "group_name") private String groupName; /** * æ¯å¦å¨çº¿ */ @Column(name = "is_online") private String isOnline; /** * è®¾å¤æ¯å¦å¼å¸¸ */ @Column(name = "is_trouble") private String isTrouble; /** * æ´æ°æ¶é´ */ @Column(name = "jhpt_update_time") private String jhptUpdateTime; private String kindex; /** * 纬度 */ private String latitude; /** * è系人 */ private String linkman; /** * ç»åº¦ */ private String longitude; /** * è系人çµè¯ */ private String phone; /** * æå±ç份 */ private String province; /** * å ä¸å¤ç¯ç¼ç */ @Column(name = "ring_id") private String ringId; /** * å ä¸å¤ç¯ */ @Column(name = "ring_name") private String ringName; /** * ç±»åç¼ç */ @Column(name = "type_id") private String typeId; /** * ç±»ååç§° */ private String typename; /** * 忢æ¶é´ */ @Column(name = "stop_time") private Date stopTime; private String active; /** * æ 鿬¡æ° */ @Column(name = "trouble_num") private Integer troubleNum; /** * æ°å¢æ¶é´ */ @Column(name = "insert_time") private Date insertTime; /** * é¶æ®µå¼å§æ¥æ */ @Column(name = "stage_begin_date") private Date stageBeginDate; /** * tspæµåº¦ */ private Double tsp; /** * ç»è®¡ç±»åç¼ç */ @Column(name = "union_type_id") private String unionTypeId; /** * å´å¢é«åº¦ */ @Column(name = "wall_height") private String wallHeight; /** * ä¸å¡æ¶é´ */ @Column(name = "ywsj_date") private Date ywsjDate; /** * 建çé¢ç§¯ */ @Column(name = "build_area") private String buildArea; /** * æ½å·¥åä½ */ @Column(name = "construction_unit") private String constructionUnit; /** * ç¹ä½æ§å¶çº§ */ @Column(name = "control_level") private String controlLevel; /** * å¼åå */ private String developers; /** * æ§è¡æ¶é´ */ @Column(name = "do_time") private Date doTime; /** * æ¯å¦æçæµ */ @Column(name = "has_monitor") private String hasMonitor; /** * ééæ¶é´ */ @Column(name = "data_time") private Date dataTime; /** * å½åæ½å·¥é¶æ®µç¼ç */ @Column(name = "engineering_stage_code") private String engineeringStageCode; /** * 设å¤ç¼ç */ @Column(name = "equipment_code") private String equipmentCode; /** * å å°é¢ç§¯ */ @Column(name = "floor_area") private String floorArea; /** * å 餿 å¿ä½ */ @Column(name = "jhpt_delete") private String jhptDelete; /** * åªå£°åè½åº */ @Column(name = "noise_region") private String noiseRegion; /** * è´è´£äºº */ private String responsible; /** * @return id */ public Integer getId() { return id; } /** * @param id */ public void setId(Integer id) { this.id = id; } /** * è·å设å¤ç¼ç * * @return mn_code - 设å¤ç¼ç */ public String getMnCode() { return mnCode; } /** * 设置设å¤ç¼ç * * @param mnCode 设å¤ç¼ç */ public void setMnCode(String mnCode) { this.mnCode = mnCode == null ? null : mnCode.trim(); } /** * è·åå®è£ å°å * * @return address - å®è£ å°å */ public String getAddress() { return address; } /** * 设置å®è£ å°å * * @param address å®è£ å°å */ public void setAddress(String address) { this.address = address == null ? null : address.trim(); } /** * è·åç«ç¹åç§° * * @return name - ç«ç¹åç§° */ public String getName() { return name; } /** * 设置ç«ç¹åç§° * * @param name ç«ç¹åç§° */ public void setName(String name) { this.name = name == null ? null : name.trim(); } /** * è·åç«ç¹ç¼ç * * @return code - ç«ç¹ç¼ç */ public String getCode() { return code; } /** * 设置ç«ç¹ç¼ç * * @param code ç«ç¹ç¼ç */ public void setCode(String code) { this.code = code == null ? null : code.trim(); } /** * è·åå¼å·¥æ¶é´ * * @return begin_date - å¼å·¥æ¶é´ */ public Date getBeginDate() { return beginDate; } /** * 设置å¼å·¥æ¶é´ * * @param beginDate å¼å·¥æ¶é´ */ public void setBeginDate(Date beginDate) { this.beginDate = beginDate; } /** * è·åè¿ç»´å * * @return duty_company - è¿ç»´å */ public String getDutyCompany() { return dutyCompany; } /** * 设置è¿ç»´å * * @param dutyCompany è¿ç»´å */ public void setDutyCompany(String dutyCompany) { this.dutyCompany = dutyCompany == null ? null : dutyCompany.trim(); } /** * è·åè¿ç»´åid * * @return duty_company_id - è¿ç»´åid */ public String getDutyCompanyId() { return dutyCompanyId; } /** * 设置è¿ç»´åid * * @param dutyCompanyId è¿ç»´åid */ public void setDutyCompanyId(String dutyCompanyId) { this.dutyCompanyId = dutyCompanyId == null ? null : dutyCompanyId.trim(); } /** * è·åç»ææ¶é´ * * @return end_date - ç»ææ¶é´ */ public Date getEndDate() { return endDate; } /** * è®¾ç½®ç»ææ¶é´ * * @param endDate ç»ææ¶é´ */ public void setEndDate(Date endDate) { this.endDate = endDate; } /** * è·åå½åæ½å·¥é¶æ®µ * * @return engineering_stage - å½åæ½å·¥é¶æ®µ */ public String getEngineeringStage() { return engineeringStage; } /** * 设置å½åæ½å·¥é¶æ®µ * * @param engineeringStage å½åæ½å·¥é¶æ®µ */ public void setEngineeringStage(String engineeringStage) { this.engineeringStage = engineeringStage == null ? null : engineeringStage.trim(); } /** * è·åæå±åºå¿ä»£ç * * @return group_id - æå±åºå¿ä»£ç */ public String getGroupId() { return groupId; } /** * 设置æå±åºå¿ä»£ç * * @param groupId æå±åºå¿ä»£ç */ public void setGroupId(String groupId) { this.groupId = groupId == null ? null : groupId.trim(); } /** * è·åæå±åºå¿ * * @return group_name - æå±åºå¿ */ public String getGroupName() { return groupName; } /** * 设置æå±åºå¿ * * @param groupName æå±åºå¿ */ public void setGroupName(String groupName) { this.groupName = groupName == null ? null : groupName.trim(); } /** * è·åæ¯å¦å¨çº¿ * * @return is_online - æ¯å¦å¨çº¿ */ public String getIsOnline() { return isOnline; } /** * 设置æ¯å¦å¨çº¿ * * @param isOnline æ¯å¦å¨çº¿ */ public void setIsOnline(String isOnline) { this.isOnline = isOnline == null ? null : isOnline.trim(); } /** * è·åè®¾å¤æ¯å¦å¼å¸¸ * * @return is_trouble - è®¾å¤æ¯å¦å¼å¸¸ */ public String getIsTrouble() { return isTrouble; } /** * è®¾ç½®è®¾å¤æ¯å¦å¼å¸¸ * * @param isTrouble è®¾å¤æ¯å¦å¼å¸¸ */ public void setIsTrouble(String isTrouble) { this.isTrouble = isTrouble == null ? null : isTrouble.trim(); } /** * è·åæ´æ°æ¶é´ * * @return jhpt_update_time - æ´æ°æ¶é´ */ public String getJhptUpdateTime() { return jhptUpdateTime; } /** * è®¾ç½®æ´æ°æ¶é´ * * @param jhptUpdateTime æ´æ°æ¶é´ */ public void setJhptUpdateTime(String jhptUpdateTime) { this.jhptUpdateTime = jhptUpdateTime == null ? null : jhptUpdateTime.trim(); } /** * @return kindex */ public String getKindex() { return kindex; } /** * @param kindex */ public void setKindex(String kindex) { this.kindex = kindex == null ? null : kindex.trim(); } /** * è·å纬度 * * @return latitude - 纬度 */ public String getLatitude() { return latitude; } /** * 设置纬度 * * @param latitude 纬度 */ public void setLatitude(String latitude) { this.latitude = latitude == null ? null : latitude.trim(); } /** * è·åè系人 * * @return linkman - è系人 */ public String getLinkman() { return linkman; } /** * 设置è系人 * * @param linkman è系人 */ public void setLinkman(String linkman) { this.linkman = linkman == null ? null : linkman.trim(); } /** * è·åç»åº¦ * * @return longitude - ç»åº¦ */ public String getLongitude() { return longitude; } /** * 设置ç»åº¦ * * @param longitude ç»åº¦ */ public void setLongitude(String longitude) { this.longitude = longitude == null ? null : longitude.trim(); } /** * è·åè系人çµè¯ * * @return phone - è系人çµè¯ */ public String getPhone() { return phone; } /** * 设置è系人çµè¯ * * @param phone è系人çµè¯ */ public void setPhone(String phone) { this.phone = phone == null ? null : phone.trim(); } /** * è·åæå±ç份 * * @return province - æå±ç份 */ public String getProvince() { return province; } /** * 设置æå±ç份 * * @param province æå±ç份 */ public void setProvince(String province) { this.province = province == null ? null : province.trim(); } /** * è·åå ä¸å¤ç¯ç¼ç * * @return ring_id - å ä¸å¤ç¯ç¼ç */ public String getRingId() { return ringId; } /** * 设置å ä¸å¤ç¯ç¼ç * * @param ringId å ä¸å¤ç¯ç¼ç */ public void setRingId(String ringId) { this.ringId = ringId == null ? null : ringId.trim(); } /** * è·åå ä¸å¤ç¯ * * @return ring_name - å ä¸å¤ç¯ */ public String getRingName() { return ringName; } /** * 设置å ä¸å¤ç¯ * * @param ringName å ä¸å¤ç¯ */ public void setRingName(String ringName) { this.ringName = ringName == null ? null : ringName.trim(); } /** * è·åç±»åç¼ç * * @return type_id - ç±»åç¼ç */ public String getTypeId() { return typeId; } /** * 设置类åç¼ç * * @param typeId ç±»åç¼ç */ public void setTypeId(String typeId) { this.typeId = typeId == null ? null : typeId.trim(); } /** * è·åç±»ååç§° * * @return typename - ç±»ååç§° */ public String getTypename() { return typename; } /** * 设置类ååç§° * * @param typename ç±»ååç§° */ public void setTypename(String typename) { this.typename = typename == null ? null : typename.trim(); } /** * è·å忢æ¶é´ * * @return stop_time - 忢æ¶é´ */ public Date getStopTime() { return stopTime; } /** * è®¾ç½®åæ¢æ¶é´ * * @param stopTime 忢æ¶é´ */ public void setStopTime(Date stopTime) { this.stopTime = stopTime; } /** * @return active */ public String getActive() { return active; } /** * @param active */ public void setActive(String active) { this.active = active == null ? null : active.trim(); } /** * è·åæ 鿬¡æ° * * @return trouble_num - æ 鿬¡æ° */ public Integer getTroubleNum() { return troubleNum; } /** * 设置æ 鿬¡æ° * * @param troubleNum æ 鿬¡æ° */ public void setTroubleNum(Integer troubleNum) { this.troubleNum = troubleNum; } /** * è·åæ°å¢æ¶é´ * * @return insert_time - æ°å¢æ¶é´ */ public Date getInsertTime() { return insertTime; } /** * 设置æ°å¢æ¶é´ * * @param insertTime æ°å¢æ¶é´ */ public void setInsertTime(Date insertTime) { this.insertTime = insertTime; } /** * è·åé¶æ®µå¼å§æ¥æ * * @return stage_begin_date - é¶æ®µå¼å§æ¥æ */ public Date getStageBeginDate() { return stageBeginDate; } /** * è®¾ç½®é¶æ®µå¼å§æ¥æ * * @param stageBeginDate é¶æ®µå¼å§æ¥æ */ public void setStageBeginDate(Date stageBeginDate) { this.stageBeginDate = stageBeginDate; } /** * è·åtspæµåº¦ * * @return tsp - tspæµåº¦ */ public Double getTsp() { return tsp; } /** * 设置tspæµåº¦ * * @param tsp tspæµåº¦ */ public void setTsp(Double tsp) { this.tsp = tsp; } /** * è·åç»è®¡ç±»åç¼ç * * @return union_type_id - ç»è®¡ç±»åç¼ç */ public String getUnionTypeId() { return unionTypeId; } /** * 设置ç»è®¡ç±»åç¼ç * * @param unionTypeId ç»è®¡ç±»åç¼ç */ public void setUnionTypeId(String unionTypeId) { this.unionTypeId = unionTypeId == null ? null : unionTypeId.trim(); } /** * è·åå´å¢é«åº¦ * * @return wall_height - å´å¢é«åº¦ */ public String getWallHeight() { return wallHeight; } /** * 设置å´å¢é«åº¦ * * @param wallHeight å´å¢é«åº¦ */ public void setWallHeight(String wallHeight) { this.wallHeight = wallHeight == null ? null : wallHeight.trim(); } /** * è·åä¸å¡æ¶é´ * * @return ywsj_date - ä¸å¡æ¶é´ */ public Date getYwsjDate() { return ywsjDate; } /** * 设置ä¸å¡æ¶é´ * * @param ywsjDate ä¸å¡æ¶é´ */ public void setYwsjDate(Date ywsjDate) { this.ywsjDate = ywsjDate; } /** * è·å建çé¢ç§¯ * * @return build_area - 建çé¢ç§¯ */ public String getBuildArea() { return buildArea; } /** * 设置建çé¢ç§¯ * * @param buildArea 建çé¢ç§¯ */ public void setBuildArea(String buildArea) { this.buildArea = buildArea == null ? null : buildArea.trim(); } /** * è·åæ½å·¥åä½ * * @return construction_unit - æ½å·¥åä½ */ public String getConstructionUnit() { return constructionUnit; } /** * 设置æ½å·¥åä½ * * @param constructionUnit æ½å·¥åä½ */ public void setConstructionUnit(String constructionUnit) { this.constructionUnit = constructionUnit == null ? null : constructionUnit.trim(); } /** * è·åç¹ä½æ§å¶çº§ * * @return control_level - ç¹ä½æ§å¶çº§ */ public String getControlLevel() { return controlLevel; } /** * 设置ç¹ä½æ§å¶çº§ * * @param controlLevel ç¹ä½æ§å¶çº§ */ public void setControlLevel(String controlLevel) { this.controlLevel = controlLevel == null ? null : controlLevel.trim(); } /** * è·åå¼åå * * @return developers - å¼åå */ public String getDevelopers() { return developers; } /** * 设置å¼åå * * @param developers å¼åå */ public void setDevelopers(String developers) { this.developers = developers == null ? null : developers.trim(); } /** * è·åæ§è¡æ¶é´ * * @return do_time - æ§è¡æ¶é´ */ public Date getDoTime() { return doTime; } /** * 设置æ§è¡æ¶é´ * * @param doTime æ§è¡æ¶é´ */ public void setDoTime(Date doTime) { this.doTime = doTime; } /** * è·åæ¯å¦æçæµ * * @return has_monitor - æ¯å¦æçæµ */ public String getHasMonitor() { return hasMonitor; } /** * 设置æ¯å¦æçæµ * * @param hasMonitor æ¯å¦æçæµ */ public void setHasMonitor(String hasMonitor) { this.hasMonitor = hasMonitor == null ? null : hasMonitor.trim(); } /** * è·åééæ¶é´ * * @return data_time - ééæ¶é´ */ public Date getDataTime() { return dataTime; } /** * 设置ééæ¶é´ * * @param dataTime ééæ¶é´ */ public void setDataTime(Date dataTime) { this.dataTime = dataTime; } /** * è·åå½åæ½å·¥é¶æ®µç¼ç * * @return engineering_stage_code - å½åæ½å·¥é¶æ®µç¼ç */ public String getEngineeringStageCode() { return engineeringStageCode; } /** * 设置å½åæ½å·¥é¶æ®µç¼ç * * @param engineeringStageCode å½åæ½å·¥é¶æ®µç¼ç */ public void setEngineeringStageCode(String engineeringStageCode) { this.engineeringStageCode = engineeringStageCode == null ? null : engineeringStageCode.trim(); } /** * è·å设å¤ç¼ç * * @return equipment_code - 设å¤ç¼ç */ public String getEquipmentCode() { return equipmentCode; } /** * 设置设å¤ç¼ç * * @param equipmentCode 设å¤ç¼ç */ public void setEquipmentCode(String equipmentCode) { this.equipmentCode = equipmentCode == null ? null : equipmentCode.trim(); } /** * è·åå å°é¢ç§¯ * * @return floor_area - å å°é¢ç§¯ */ public String getFloorArea() { return floorArea; } /** * 设置å å°é¢ç§¯ * * @param floorArea å å°é¢ç§¯ */ public void setFloorArea(String floorArea) { this.floorArea = floorArea == null ? null : floorArea.trim(); } /** * è·åå 餿 å¿ä½ * * @return jhpt_delete - å 餿 å¿ä½ */ public String getJhptDelete() { return jhptDelete; } /** * 设置å 餿 å¿ä½ * * @param jhptDelete å 餿 å¿ä½ */ public void setJhptDelete(String jhptDelete) { this.jhptDelete = jhptDelete == null ? null : jhptDelete.trim(); } /** * è·ååªå£°åè½åº * * @return noise_region - åªå£°åè½åº */ public String getNoiseRegion() { return noiseRegion; } /** * 设置åªå£°åè½åº * * @param noiseRegion åªå£°åè½åº */ public void setNoiseRegion(String noiseRegion) { this.noiseRegion = noiseRegion == null ? null : noiseRegion.trim(); } /** * è·åè´è´£äºº * * @return responsible - è´è´£äºº */ public String getResponsible() { return responsible; } /** * 设置è´è´£äºº * * @param responsible è´è´£äºº */ public void setResponsible(String responsible) { this.responsible = responsible == null ? null : responsible.trim(); } } src/main/java/com/flightfeather/monitor/domain/ds1/entity/DustSiteLatestTime.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,59 @@ package com.flightfeather.monitor.domain.ds1.entity; import java.util.Date; import javax.persistence.*; @Table(name = "du_js_t_site_latest_time") public class DustSiteLatestTime { @Id @Column(name = "mn_code") private String mnCode; @Column(name = "latest_time") private Date latestTime; @Column(name = "device_status") private Integer deviceStatus; /** * @return mn_code */ public String getMnCode() { return mnCode; } /** * @param mnCode */ public void setMnCode(String mnCode) { this.mnCode = mnCode == null ? null : mnCode.trim(); } /** * @return latest_time */ public Date getLatestTime() { return latestTime; } /** * @param latestTime */ public void setLatestTime(Date latestTime) { this.latestTime = latestTime; } /** * @return device_status */ public Integer getDeviceStatus() { return deviceStatus; } /** * @param deviceStatus */ public void setDeviceStatus(Integer deviceStatus) { this.deviceStatus = deviceStatus; } } src/main/java/com/flightfeather/monitor/domain/ds1/entity/DustSiteMap.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,144 @@ package com.flightfeather.monitor.domain.ds1.entity; import java.util.Date; import javax.persistence.*; @Table(name = "du_js_t_site_map") public class DustSiteMap { @Id @Column(name = "Id") private Integer id; @Column(name = "TZ_User_Id") private String tzUserId; @Column(name = "TZ_User_Name") private String tzUserName; @Column(name = "JS_Device_Code") private String jsDeviceCode; @Column(name = "JS_Device_Name") private String jsDeviceName; @Column(name = "SV_User_Id") private String svUserId; @Column(name = "SV_User_Name") private String svUserName; @Column(name = "Create_Time") private Date createTime; /** * @return Id */ public Integer getId() { return id; } /** * @param id */ public void setId(Integer id) { this.id = id; } /** * @return TZ_User_Id */ public String getTzUserId() { return tzUserId; } /** * @param tzUserId */ public void setTzUserId(String tzUserId) { this.tzUserId = tzUserId == null ? null : tzUserId.trim(); } /** * @return TZ_User_Name */ public String getTzUserName() { return tzUserName; } /** * @param tzUserName */ public void setTzUserName(String tzUserName) { this.tzUserName = tzUserName == null ? null : tzUserName.trim(); } /** * @return JS_Device_Code */ public String getJsDeviceCode() { return jsDeviceCode; } /** * @param jsDeviceCode */ public void setJsDeviceCode(String jsDeviceCode) { this.jsDeviceCode = jsDeviceCode == null ? null : jsDeviceCode.trim(); } /** * @return JS_Device_Name */ public String getJsDeviceName() { return jsDeviceName; } /** * @param jsDeviceName */ public void setJsDeviceName(String jsDeviceName) { this.jsDeviceName = jsDeviceName == null ? null : jsDeviceName.trim(); } /** * @return SV_User_Id */ public String getSvUserId() { return svUserId; } /** * @param svUserId */ public void setSvUserId(String svUserId) { this.svUserId = svUserId == null ? null : svUserId.trim(); } /** * @return SV_User_Name */ public String getSvUserName() { return svUserName; } /** * @param svUserName */ public void setSvUserName(String svUserName) { this.svUserName = svUserName == null ? null : svUserName.trim(); } /** * @return Create_Time */ public Date getCreateTime() { return createTime; } /** * @param createTime */ public void setCreateTime(Date createTime) { this.createTime = createTime; } } src/main/java/com/flightfeather/monitor/domain/ds1/entity/DustStatisticsValue.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,173 @@ package com.flightfeather.monitor.domain.ds1.entity; import java.util.Date; import javax.persistence.*; @Table(name = "dust_statistics_value") public class DustStatisticsValue { @Id private Integer id; @Column(name = "mn_code") private String mnCode; private Date lst; @Column(name = "day_avg") private String dayAvg; private String min; private String max; @Column(name = "day_online") private String dayOnline; @Column(name = "day_valid") private String dayValid; @Column(name = "day_exceeding") private String dayExceeding; private String type; /** * @return id */ public Integer getId() { return id; } /** * @param id */ public void setId(Integer id) { this.id = id; } /** * @return mn_code */ public String getMnCode() { return mnCode; } /** * @param mnCode */ public void setMnCode(String mnCode) { this.mnCode = mnCode == null ? null : mnCode.trim(); } /** * @return lst */ public Date getLst() { return lst; } /** * @param lst */ public void setLst(Date lst) { this.lst = lst; } /** * @return day_avg */ public String getDayAvg() { return dayAvg; } /** * @param dayAvg */ public void setDayAvg(String dayAvg) { this.dayAvg = dayAvg == null ? null : dayAvg.trim(); } /** * @return min */ public String getMin() { return min; } /** * @param min */ public void setMin(String min) { this.min = min == null ? null : min.trim(); } /** * @return max */ public String getMax() { return max; } /** * @param max */ public void setMax(String max) { this.max = max == null ? null : max.trim(); } /** * @return day_online */ public String getDayOnline() { return dayOnline; } /** * @param dayOnline */ public void setDayOnline(String dayOnline) { this.dayOnline = dayOnline == null ? null : dayOnline.trim(); } /** * @return day_valid */ public String getDayValid() { return dayValid; } /** * @param dayValid */ public void setDayValid(String dayValid) { this.dayValid = dayValid == null ? null : dayValid.trim(); } /** * @return day_exceeding */ public String getDayExceeding() { return dayExceeding; } /** * @param dayExceeding */ public void setDayExceeding(String dayExceeding) { this.dayExceeding = dayExceeding == null ? null : dayExceeding.trim(); } /** * @return type */ public String getType() { return type; } /** * @param type */ public void setType(String type) { this.type = type == null ? null : type.trim(); } } src/main/java/com/flightfeather/monitor/domain/ds1/entity/LoginInfo.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,106 @@ package com.flightfeather.monitor.domain.ds1.entity; import java.util.Date; import javax.persistence.*; @Table(name = "du_js_t_login_info") public class LoginInfo { @Id private Integer id; @Column(name = "user_name") private String userName; private String password; private String cookie; @Column(name = "cookie_timestamp") private Date cookieTimestamp; private String region; /** * @return id */ public Integer getId() { return id; } /** * @param id */ public void setId(Integer id) { this.id = id; } /** * @return user_name */ public String getUserName() { return userName; } /** * @param userName */ public void setUserName(String userName) { this.userName = userName == null ? null : userName.trim(); } /** * @return password */ public String getPassword() { return password; } /** * @param password */ public void setPassword(String password) { this.password = password == null ? null : password.trim(); } /** * @return cookie */ public String getCookie() { return cookie; } /** * @param cookie */ public void setCookie(String cookie) { this.cookie = cookie == null ? null : cookie.trim(); } /** * @return cookie_timestamp */ public Date getCookieTimestamp() { return cookieTimestamp; } /** * @param cookieTimestamp */ public void setCookieTimestamp(Date cookieTimestamp) { this.cookieTimestamp = cookieTimestamp; } /** * @return region */ public String getRegion() { return region; } /** * @param region */ public void setRegion(String region) { this.region = region == null ? null : region.trim(); } } src/main/java/com/flightfeather/monitor/domain/ds1/entity/RequestTaskSetting.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,411 @@ package com.flightfeather.monitor.domain.ds1.entity; import java.util.Date; import javax.persistence.*; @Table(name = "du_js_t_request_task_setting") public class RequestTaskSetting { @Id private Integer id; private String user; @Column(name = "update_time") private Date updateTime; private String region; private String version; /** * æ°æ®ç¬åå¼å§æ¶é´ */ @Column(name = "request_start_time") private Date requestStartTime; /** * æ°æ®ç¬åç»ææ¶é´ */ @Column(name = "request_end_time") private Date requestEndTime; /** * å¨ç¬åä»»å¡å¼å§ç»ææ¶é´å ï¼ç¬åçé¢ç */ @Column(name = "request_interval_seconds") private Integer requestIntervalSeconds; /** * 䏿¬¡æ°æ®ç¬åä»»å¡ä¸ï¼ææ»æ¶é¿å段æ§è¡çæ¯æ®µæ¶é´é¿åº¦ */ @Column(name = "request_range_hour") private Integer requestRangeHour; /** * 䏿¬¡æ°æ®ç¬åä»»å¡ä¸ï¼å段æ§è¡æ¶çæ¯æ®µçé´éæ¶é´ */ @Column(name = "request_range_interval_seconds") private Integer requestRangeIntervalSeconds; /** * ç¬åä»»å¡å¼å¸¸æ¶å次å°è¯é´é */ @Column(name = "request_fail_wait_seconds") private Integer requestFailWaitSeconds; /** * ç¬å失败æ¶å次å°è¯çæ»æ¬¡æ° */ @Column(name = "request_retry_times") private Integer requestRetryTimes; @Column(name = "statics_daily_time") private Date staticsDailyTime; @Column(name = "statics_monthly_time") private Date staticsMonthlyTime; /** * 忬¡ç»éå¤±è´¥éæ°å°è¯çå¾ æ¶é´ */ @Column(name = "login_fail_wait_seconds") private Integer loginFailWaitSeconds; /** * ç»é失败è¿ç»å°è¯æ¬¡æ° */ @Column(name = "login_retry_times") private Integer loginRetryTimes; /** * æ´ä¸ªç¬åä»»å¡éæ°å¼å§å°è¯çå¾ æ¶é´ */ @Column(name = "task_retry_wait_seconds") private Integer taskRetryWaitSeconds; /** * ç¨åºé¦æ¬¡æ§è¡, ç«ç¹æ°æ®ææ°æ¶å»è¡¨ä¸ºç©ºæ¶, æ°æ®è·åå¼å§æ¶é´ç¸å¯¹å½æ¥å¾ååç§»çå¤©æ° */ @Column(name = "first_request_offset_days") private Integer firstRequestOffsetDays; /** * cookieæææ¶é¿ï¼åä½å°æ¶ */ @Column(name = "request_cookie_valid_duration") private Integer requestCookieValidDuration; /** * @return id */ public Integer getId() { return id; } /** * @param id */ public void setId(Integer id) { this.id = id; } /** * @return user */ public String getUser() { return user; } /** * @param user */ public void setUser(String user) { this.user = user == null ? null : user.trim(); } /** * @return update_time */ public Date getUpdateTime() { return updateTime; } /** * @param updateTime */ public void setUpdateTime(Date updateTime) { this.updateTime = updateTime; } /** * @return region */ public String getRegion() { return region; } /** * @param region */ public void setRegion(String region) { this.region = region == null ? null : region.trim(); } /** * @return version */ public String getVersion() { return version; } /** * @param version */ public void setVersion(String version) { this.version = version == null ? null : version.trim(); } /** * è·åæ°æ®ç¬åå¼å§æ¶é´ * * @return request_start_time - æ°æ®ç¬åå¼å§æ¶é´ */ public Date getRequestStartTime() { return requestStartTime; } /** * è®¾ç½®æ°æ®ç¬åå¼å§æ¶é´ * * @param requestStartTime æ°æ®ç¬åå¼å§æ¶é´ */ public void setRequestStartTime(Date requestStartTime) { this.requestStartTime = requestStartTime; } /** * è·åæ°æ®ç¬åç»ææ¶é´ * * @return request_end_time - æ°æ®ç¬åç»ææ¶é´ */ public Date getRequestEndTime() { return requestEndTime; } /** * è®¾ç½®æ°æ®ç¬åç»ææ¶é´ * * @param requestEndTime æ°æ®ç¬åç»ææ¶é´ */ public void setRequestEndTime(Date requestEndTime) { this.requestEndTime = requestEndTime; } /** * è·åå¨ç¬åä»»å¡å¼å§ç»ææ¶é´å ï¼ç¬åçé¢ç * * @return request_interval_seconds - å¨ç¬åä»»å¡å¼å§ç»ææ¶é´å ï¼ç¬åçé¢ç */ public Integer getRequestIntervalSeconds() { return requestIntervalSeconds; } /** * 设置å¨ç¬åä»»å¡å¼å§ç»ææ¶é´å ï¼ç¬åçé¢ç * * @param requestIntervalSeconds å¨ç¬åä»»å¡å¼å§ç»ææ¶é´å ï¼ç¬åçé¢ç */ public void setRequestIntervalSeconds(Integer requestIntervalSeconds) { this.requestIntervalSeconds = requestIntervalSeconds; } /** * è·å䏿¬¡æ°æ®ç¬åä»»å¡ä¸ï¼ææ»æ¶é¿å段æ§è¡çæ¯æ®µæ¶é´é¿åº¦ * * @return request_range_hour - 䏿¬¡æ°æ®ç¬åä»»å¡ä¸ï¼ææ»æ¶é¿å段æ§è¡çæ¯æ®µæ¶é´é¿åº¦ */ public Integer getRequestRangeHour() { return requestRangeHour; } /** * è®¾ç½®ä¸æ¬¡æ°æ®ç¬åä»»å¡ä¸ï¼ææ»æ¶é¿å段æ§è¡çæ¯æ®µæ¶é´é¿åº¦ * * @param requestRangeHour 䏿¬¡æ°æ®ç¬åä»»å¡ä¸ï¼ææ»æ¶é¿å段æ§è¡çæ¯æ®µæ¶é´é¿åº¦ */ public void setRequestRangeHour(Integer requestRangeHour) { this.requestRangeHour = requestRangeHour; } /** * è·å䏿¬¡æ°æ®ç¬åä»»å¡ä¸ï¼å段æ§è¡æ¶çæ¯æ®µçé´éæ¶é´ * * @return request_range_interval_seconds - 䏿¬¡æ°æ®ç¬åä»»å¡ä¸ï¼å段æ§è¡æ¶çæ¯æ®µçé´éæ¶é´ */ public Integer getRequestRangeIntervalSeconds() { return requestRangeIntervalSeconds; } /** * è®¾ç½®ä¸æ¬¡æ°æ®ç¬åä»»å¡ä¸ï¼å段æ§è¡æ¶çæ¯æ®µçé´éæ¶é´ * * @param requestRangeIntervalSeconds 䏿¬¡æ°æ®ç¬åä»»å¡ä¸ï¼å段æ§è¡æ¶çæ¯æ®µçé´éæ¶é´ */ public void setRequestRangeIntervalSeconds(Integer requestRangeIntervalSeconds) { this.requestRangeIntervalSeconds = requestRangeIntervalSeconds; } /** * è·åç¬åä»»å¡å¼å¸¸æ¶å次å°è¯é´é * * @return request_fail_wait_seconds - ç¬åä»»å¡å¼å¸¸æ¶å次å°è¯é´é */ public Integer getRequestFailWaitSeconds() { return requestFailWaitSeconds; } /** * 设置ç¬åä»»å¡å¼å¸¸æ¶å次å°è¯é´é * * @param requestFailWaitSeconds ç¬åä»»å¡å¼å¸¸æ¶å次å°è¯é´é */ public void setRequestFailWaitSeconds(Integer requestFailWaitSeconds) { this.requestFailWaitSeconds = requestFailWaitSeconds; } /** * è·åç¬å失败æ¶å次å°è¯çæ»æ¬¡æ° * * @return request_retry_times - ç¬å失败æ¶å次å°è¯çæ»æ¬¡æ° */ public Integer getRequestRetryTimes() { return requestRetryTimes; } /** * 设置ç¬å失败æ¶å次å°è¯çæ»æ¬¡æ° * * @param requestRetryTimes ç¬å失败æ¶å次å°è¯çæ»æ¬¡æ° */ public void setRequestRetryTimes(Integer requestRetryTimes) { this.requestRetryTimes = requestRetryTimes; } /** * @return statics_daily_time */ public Date getStaticsDailyTime() { return staticsDailyTime; } /** * @param staticsDailyTime */ public void setStaticsDailyTime(Date staticsDailyTime) { this.staticsDailyTime = staticsDailyTime; } /** * @return statics_monthly_time */ public Date getStaticsMonthlyTime() { return staticsMonthlyTime; } /** * @param staticsMonthlyTime */ public void setStaticsMonthlyTime(Date staticsMonthlyTime) { this.staticsMonthlyTime = staticsMonthlyTime; } /** * è·å忬¡ç»éå¤±è´¥éæ°å°è¯çå¾ æ¶é´ * * @return login_fail_wait_seconds - 忬¡ç»éå¤±è´¥éæ°å°è¯çå¾ æ¶é´ */ public Integer getLoginFailWaitSeconds() { return loginFailWaitSeconds; } /** * è®¾ç½®åæ¬¡ç»éå¤±è´¥éæ°å°è¯çå¾ æ¶é´ * * @param loginFailWaitSeconds 忬¡ç»éå¤±è´¥éæ°å°è¯çå¾ æ¶é´ */ public void setLoginFailWaitSeconds(Integer loginFailWaitSeconds) { this.loginFailWaitSeconds = loginFailWaitSeconds; } /** * è·åç»é失败è¿ç»å°è¯æ¬¡æ° * * @return login_retry_times - ç»é失败è¿ç»å°è¯æ¬¡æ° */ public Integer getLoginRetryTimes() { return loginRetryTimes; } /** * 设置ç»é失败è¿ç»å°è¯æ¬¡æ° * * @param loginRetryTimes ç»é失败è¿ç»å°è¯æ¬¡æ° */ public void setLoginRetryTimes(Integer loginRetryTimes) { this.loginRetryTimes = loginRetryTimes; } /** * è·åæ´ä¸ªç¬åä»»å¡éæ°å¼å§å°è¯çå¾ æ¶é´ * * @return task_retry_wait_seconds - æ´ä¸ªç¬åä»»å¡éæ°å¼å§å°è¯çå¾ æ¶é´ */ public Integer getTaskRetryWaitSeconds() { return taskRetryWaitSeconds; } /** * 设置æ´ä¸ªç¬åä»»å¡éæ°å¼å§å°è¯çå¾ æ¶é´ * * @param taskRetryWaitSeconds æ´ä¸ªç¬åä»»å¡éæ°å¼å§å°è¯çå¾ æ¶é´ */ public void setTaskRetryWaitSeconds(Integer taskRetryWaitSeconds) { this.taskRetryWaitSeconds = taskRetryWaitSeconds; } /** * è·åç¨åºé¦æ¬¡æ§è¡, ç«ç¹æ°æ®ææ°æ¶å»è¡¨ä¸ºç©ºæ¶, æ°æ®è·åå¼å§æ¶é´ç¸å¯¹å½æ¥å¾ååç§»çå¤©æ° * * @return first_request_offset_days - ç¨åºé¦æ¬¡æ§è¡, ç«ç¹æ°æ®ææ°æ¶å»è¡¨ä¸ºç©ºæ¶, æ°æ®è·åå¼å§æ¶é´ç¸å¯¹å½æ¥å¾ååç§»çå¤©æ° */ public Integer getFirstRequestOffsetDays() { return firstRequestOffsetDays; } /** * 设置ç¨åºé¦æ¬¡æ§è¡, ç«ç¹æ°æ®ææ°æ¶å»è¡¨ä¸ºç©ºæ¶, æ°æ®è·åå¼å§æ¶é´ç¸å¯¹å½æ¥å¾ååç§»çå¤©æ° * * @param firstRequestOffsetDays ç¨åºé¦æ¬¡æ§è¡, ç«ç¹æ°æ®ææ°æ¶å»è¡¨ä¸ºç©ºæ¶, æ°æ®è·åå¼å§æ¶é´ç¸å¯¹å½æ¥å¾ååç§»çå¤©æ° */ public void setFirstRequestOffsetDays(Integer firstRequestOffsetDays) { this.firstRequestOffsetDays = firstRequestOffsetDays; } /** * è·åcookieæææ¶é¿ï¼åä½å°æ¶ * * @return request_cookie_valid_duration - cookieæææ¶é¿ï¼åä½å°æ¶ */ public Integer getRequestCookieValidDuration() { return requestCookieValidDuration; } /** * 设置cookieæææ¶é¿ï¼åä½å°æ¶ * * @param requestCookieValidDuration cookieæææ¶é¿ï¼åä½å°æ¶ */ public void setRequestCookieValidDuration(Integer requestCookieValidDuration) { this.requestCookieValidDuration = requestCookieValidDuration; } } src/main/java/com/flightfeather/monitor/domain/ds1/mapper/DustExceptionDataMapper.kt
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,8 @@ package com.flightfeather.monitor.domain.ds1.mapper import com.flightfeather.monitor.domain.ds1.entity.DustExceptionData import com.flightfeather.monitor.domain.util.MyMapper import org.apache.ibatis.annotations.Mapper @Mapper interface DustExceptionDataMapper : MyMapper<DustExceptionData?> src/main/java/com/flightfeather/monitor/domain/ds1/mapper/DustExceptionSettingMapper.kt
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,8 @@ package com.flightfeather.monitor.domain.ds1.mapper import com.flightfeather.monitor.domain.ds1.entity.DustExceptionSetting import com.flightfeather.monitor.domain.util.MyMapper import org.apache.ibatis.annotations.Mapper @Mapper interface DustExceptionSettingMapper : MyMapper<DustExceptionSetting?> src/main/java/com/flightfeather/monitor/domain/ds1/mapper/DustGlobalSettingMapper.kt
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,8 @@ package com.flightfeather.monitor.domain.ds1.mapper import com.flightfeather.monitor.domain.ds1.entity.DustGlobalSetting import com.flightfeather.monitor.domain.util.MyMapper import org.apache.ibatis.annotations.Mapper @Mapper interface DustGlobalSettingMapper : MyMapper<DustGlobalSetting?> src/main/java/com/flightfeather/monitor/domain/ds1/mapper/DustSiteDataMapper.kt
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,8 @@ package com.flightfeather.monitor.domain.ds1.mapper import com.flightfeather.monitor.domain.ds1.entity.DustSiteData import com.flightfeather.monitor.domain.util.MyMapper import org.apache.ibatis.annotations.Mapper @Mapper interface DustSiteDataMapper : MyMapper<DustSiteData?> src/main/java/com/flightfeather/monitor/domain/ds1/mapper/DustSiteInfoMapper.kt
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,8 @@ package com.flightfeather.monitor.domain.ds1.mapper import com.flightfeather.monitor.domain.ds1.entity.DustSiteInfo import com.flightfeather.monitor.domain.util.MyMapper import org.apache.ibatis.annotations.Mapper @Mapper interface DustSiteInfoMapper : MyMapper<DustSiteInfo?> src/main/java/com/flightfeather/monitor/domain/ds1/mapper/DustSiteLatestTimeMapper.kt
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,8 @@ package com.flightfeather.monitor.domain.ds1.mapper import com.flightfeather.monitor.domain.ds1.entity.DustSiteLatestTime import com.flightfeather.monitor.domain.util.MyMapper import org.apache.ibatis.annotations.Mapper @Mapper interface DustSiteLatestTimeMapper : MyMapper<DustSiteLatestTime?> src/main/java/com/flightfeather/monitor/domain/ds1/mapper/DustSiteMapMapper.kt
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,8 @@ package com.flightfeather.monitor.domain.ds1.mapper import com.flightfeather.monitor.domain.ds1.entity.DustSiteMap import com.flightfeather.monitor.domain.util.MyMapper import org.apache.ibatis.annotations.Mapper @Mapper interface DustSiteMapMapper : MyMapper<DustSiteMap?> src/main/java/com/flightfeather/monitor/domain/ds1/mapper/DustStatisticsValueMapper.kt
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,8 @@ package com.flightfeather.monitor.domain.ds1.mapper import com.flightfeather.monitor.domain.ds1.entity.DustStatisticsValue import com.flightfeather.monitor.domain.util.MyMapper import org.apache.ibatis.annotations.Mapper @Mapper interface DustStatisticsValueMapper : MyMapper<DustStatisticsValue?> src/main/java/com/flightfeather/monitor/domain/ds1/mapper/LoginInfoMapper.kt
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,8 @@ package com.flightfeather.monitor.domain.ds1.mapper import com.flightfeather.monitor.domain.ds1.entity.LoginInfo import com.flightfeather.monitor.domain.util.MyMapper import org.apache.ibatis.annotations.Mapper @Mapper interface LoginInfoMapper : MyMapper<LoginInfo?> src/main/java/com/flightfeather/monitor/domain/ds1/mapper/RequestTaskSettingMapper.kt
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,8 @@ package com.flightfeather.monitor.domain.ds1.mapper import com.flightfeather.monitor.domain.ds1.entity.RequestTaskSetting import com.flightfeather.monitor.domain.util.MyMapper import org.apache.ibatis.annotations.Mapper @Mapper interface RequestTaskSettingMapper : MyMapper<RequestTaskSetting?> src/main/java/com/flightfeather/monitor/domain/util/MyMapper.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,36 @@ /* * The MIT License (MIT) * * Copyright (c) 2014-2016 abel533@gmail.com * * Permission is hereby granted, free of charge, to any person obtaining a copy * of this software and associated documentation files (the "Software"), to deal * in the Software without restriction, including without limitation the rights * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell * copies of the Software, and to permit persons to whom the Software is * furnished to do so, subject to the following conditions: * * The above copyright notice and this permission notice shall be included in * all copies or substantial portions of the Software. * * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN * THE SOFTWARE. */ package com.flightfeather.monitor.domain.util; import tk.mybatis.mapper.common.Mapper; import tk.mybatis.mapper.common.MySqlMapper; /** * ç»§æ¿èªå·±çMyMapper */ public interface MyMapper<T> extends Mapper<T>, MySqlMapper<T> { //TODO //FIXME ç¹å«æ³¨æï¼è¯¥æ¥å£ä¸è½è¢«æ«æå°ï¼å¦åä¼åºé } src/main/java/com/flightfeather/monitor/mapper/AnalysisDataMapper.java
ÎļþÃû´Ó src/main/java/com/job/zsc/mapper/AnalysisDataMapper.java ÐÞ¸Ä @@ -1,6 +1,6 @@ package com.job.zsc.mapper; package com.flightfeather.monitor.mapper; import com.job.zsc.pojo.AnalysisData; import com.flightfeather.monitor.pojo.AnalysisData; import org.apache.ibatis.annotations.Insert; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Select; src/main/java/com/flightfeather/monitor/mapper/FugitiveDustMapper.java
ÎļþÃû´Ó src/main/java/com/job/zsc/mapper/FugitiveDustMapper.java ÐÞ¸Ä @@ -1,6 +1,6 @@ package com.job.zsc.mapper; package com.flightfeather.monitor.mapper; import com.job.zsc.pojo.*; import com.flightfeather.monitor.pojo.*; import org.apache.ibatis.annotations.Insert; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; @@ -19,7 +19,7 @@ @Select("select DISTINCT name from ja_t_dust_site_info ") List<DustSiteData> allSiteName(); List<AnalysisDustData> analysisdata( String siteName,String beginTime, String endTime); List<AnalysisDustData> analysisdata(String siteName, String beginTime, String endTime); List<AnalysisDustData> analysisByTime(String siteName, String beginTime, String endTime); src/main/java/com/flightfeather/monitor/mapper/LoginMapper.java
ÎļþÃû´Ó src/main/java/com/job/zsc/mapper/LoginMapper.java ÐÞ¸Ä @@ -1,6 +1,6 @@ package com.job.zsc.mapper; package com.flightfeather.monitor.mapper; import com.job.zsc.pojo.LoginUser; import com.flightfeather.monitor.pojo.LoginUser; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Select; src/main/java/com/flightfeather/monitor/mapper/SqlMapper.java
ÎļþÃû´Ó src/main/java/com/job/zsc/mapper/SqlMapper.java ÐÞ¸Ä @@ -1,6 +1,6 @@ package com.job.zsc.mapper; package com.flightfeather.monitor.mapper; import com.job.zsc.pojo.OriginalData; import com.flightfeather.monitor.pojo.OriginalData; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Select; src/main/java/com/flightfeather/monitor/mapper/Vue3FumeMapper.java
ÎļþÃû´Ó src/main/java/com/job/zsc/mapper/Vue3FumeMapper.java ÐÞ¸Ä @@ -1,8 +1,8 @@ package com.job.zsc.mapper; package com.flightfeather.monitor.mapper; import com.job.zsc.pojo.DeviceInfo; import com.job.zsc.pojo.FumeAbnormalData; import com.job.zsc.pojo.FumeHistoryData; import com.flightfeather.monitor.pojo.DeviceInfo; import com.flightfeather.monitor.pojo.FumeAbnormalData; import com.flightfeather.monitor.pojo.FumeHistoryData; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; src/main/java/com/flightfeather/monitor/pojo/AnalysisData.java
ÎļþÃû´Ó src/main/java/com/job/zsc/pojo/AnalysisData.java ÐÞ¸Ä @@ -1,4 +1,4 @@ package com.job.zsc.pojo; package com.flightfeather.monitor.pojo; import com.fasterxml.jackson.annotation.JsonFormat; import lombok.AllArgsConstructor; src/main/java/com/flightfeather/monitor/pojo/AnalysisDustData.java
ÎļþÃû´Ó src/main/java/com/job/zsc/pojo/AnalysisDustData.java ÐÞ¸Ä @@ -1,4 +1,4 @@ package com.job.zsc.pojo; package com.flightfeather.monitor.pojo; import com.fasterxml.jackson.annotation.JsonFormat; import lombok.AllArgsConstructor; src/main/java/com/flightfeather/monitor/pojo/AuditInfo.java
ÎļþÃû´Ó src/main/java/com/job/zsc/pojo/AuditInfo.java ÐÞ¸Ä @@ -1,4 +1,4 @@ package com.job.zsc.pojo; package com.flightfeather.monitor.pojo; import com.fasterxml.jackson.annotation.JsonFormat; import lombok.AllArgsConstructor; src/main/java/com/flightfeather/monitor/pojo/DeviceInfo.java
ÎļþÃû´Ó src/main/java/com/job/zsc/pojo/DeviceInfo.java ÐÞ¸Ä @@ -1,4 +1,4 @@ package com.job.zsc.pojo; package com.flightfeather.monitor.pojo; import lombok.AllArgsConstructor; import lombok.Data; src/main/java/com/flightfeather/monitor/pojo/DustDataAccessSetting.java
ÎļþÃû´Ó src/main/java/com/job/zsc/pojo/DustDataAccessSetting.java ÐÞ¸Ä @@ -1,4 +1,4 @@ package com.job.zsc.pojo; package com.flightfeather.monitor.pojo; import lombok.AllArgsConstructor; import lombok.Data; src/main/java/com/flightfeather/monitor/pojo/DustExceptionData.java
ÎļþÃû´Ó src/main/java/com/job/zsc/pojo/DustExceptionData.java ÐÞ¸Ä @@ -1,4 +1,4 @@ package com.job.zsc.pojo; package com.flightfeather.monitor.pojo; import com.fasterxml.jackson.annotation.JsonFormat; import lombok.AllArgsConstructor; src/main/java/com/flightfeather/monitor/pojo/DustExceptionSetting.java
ÎļþÃû´Ó src/main/java/com/job/zsc/pojo/DustExceptionSetting.java ÐÞ¸Ä @@ -1,9 +1,8 @@ package com.job.zsc.pojo; package com.flightfeather.monitor.pojo; import com.fasterxml.jackson.annotation.JsonFormat; import lombok.AllArgsConstructor; import lombok.Data; import lombok.NoArgsConstructor; import java.time.LocalDateTime; src/main/java/com/flightfeather/monitor/pojo/DustExceptionType.java
ÎļþÃû´Ó src/main/java/com/job/zsc/pojo/DustExceptionType.java ÐÞ¸Ä @@ -1,4 +1,4 @@ package com.job.zsc.pojo; package com.flightfeather.monitor.pojo; import lombok.AllArgsConstructor; import lombok.Data; src/main/java/com/flightfeather/monitor/pojo/DustSiteData.java
ÎļþÃû´Ó src/main/java/com/job/zsc/pojo/DustSiteData.java ÐÞ¸Ä @@ -1,4 +1,4 @@ package com.job.zsc.pojo; package com.flightfeather.monitor.pojo; import com.fasterxml.jackson.annotation.JsonFormat; import lombok.AllArgsConstructor; src/main/java/com/flightfeather/monitor/pojo/FumeAbnormalData.java
ÎļþÃû´Ó src/main/java/com/job/zsc/pojo/FumeAbnormalData.java ÐÞ¸Ä @@ -1,4 +1,4 @@ package com.job.zsc.pojo; package com.flightfeather.monitor.pojo; import com.fasterxml.jackson.annotation.JsonFormat; src/main/java/com/flightfeather/monitor/pojo/FumeHistoryData.java
ÎļþÃû´Ó src/main/java/com/job/zsc/pojo/FumeHistoryData.java ÐÞ¸Ä @@ -1,4 +1,4 @@ package com.job.zsc.pojo; package com.flightfeather.monitor.pojo; import com.fasterxml.jackson.annotation.JsonFormat; import lombok.AllArgsConstructor; src/main/java/com/flightfeather/monitor/pojo/LoginUser.java
ÎļþÃû´Ó src/main/java/com/job/zsc/pojo/LoginUser.java ÐÞ¸Ä @@ -1,4 +1,4 @@ package com.job.zsc.pojo; package com.flightfeather.monitor.pojo; import lombok.AllArgsConstructor; import lombok.Data; src/main/java/com/flightfeather/monitor/pojo/OriginalData.java
ÎļþÃû´Ó src/main/java/com/job/zsc/pojo/OriginalData.java ÐÞ¸Ä @@ -1,4 +1,4 @@ package com.job.zsc.pojo; package com.flightfeather.monitor.pojo; import com.fasterxml.jackson.annotation.JsonFormat; import lombok.AllArgsConstructor; src/main/java/com/flightfeather/monitor/pojo/PageBean.java
ÎļþÃû´Ó src/main/java/com/job/zsc/pojo/PageBean.java ÐÞ¸Ä @@ -1,4 +1,4 @@ package com.job.zsc.pojo; package com.flightfeather.monitor.pojo; import lombok.AllArgsConstructor; import lombok.Data; src/main/java/com/flightfeather/monitor/pojo/Result.java
ÎļþÃû´Ó src/main/java/com/job/zsc/pojo/Result.java ÐÞ¸Ä @@ -1,4 +1,4 @@ package com.job.zsc.pojo; package com.flightfeather.monitor.pojo; import lombok.AllArgsConstructor; src/main/java/com/flightfeather/monitor/scheduledtasks/BaseTimingTask.kt
src/main/java/com/flightfeather/monitor/scheduledtasks/ScheduledTaskController.java
ÎļþÃû´Ó src/main/java/com/job/zsc/scheduledtasks/ScheduledTaskController.java ÐÞ¸Ä @@ -1,4 +1,4 @@ package com.job.zsc.scheduledtasks; package com.flightfeather.monitor.scheduledtasks; import java.util.concurrent.Executors; import java.util.concurrent.ScheduledExecutorService; src/main/java/com/flightfeather/monitor/scheduledtasks/TaskController.kt
ÎļþÃû´Ó src/main/java/com/job/zsc/scheduledtasks/TaskController.kt ÐÞ¸Ä @@ -1,4 +1,4 @@ package com.job.zsc.scheduledtasks package com.flightfeather.monitor.scheduledtasks import cn.flightfeather.supervision.timingtask.BaseTimingTask import org.slf4j.LoggerFactory src/main/java/com/flightfeather/monitor/service/AnalysisDataService.java
ÎļþÃû´Ó src/main/java/com/job/zsc/service/AnalysisDataService.java ÐÞ¸Ä @@ -1,6 +1,6 @@ package com.job.zsc.service; package com.flightfeather.monitor.service; import com.job.zsc.pojo.AnalysisData; import com.flightfeather.monitor.pojo.AnalysisData; import java.util.List; src/main/java/com/flightfeather/monitor/service/FugitiveDustService.java
ÎļþÃû´Ó src/main/java/com/job/zsc/service/FugitiveDustService.java ÐÞ¸Ä @@ -1,6 +1,6 @@ package com.job.zsc.service; package com.flightfeather.monitor.service; import com.job.zsc.pojo.*; import com.flightfeather.monitor.pojo.*; import java.util.List; src/main/java/com/flightfeather/monitor/service/LoginService.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,7 @@ package com.flightfeather.monitor.service; import com.flightfeather.monitor.pojo.LoginUser; public interface LoginService { LoginUser login(LoginUser loginUser); } src/main/java/com/flightfeather/monitor/service/SqlService.java
ÎļþÃû´Ó src/main/java/com/job/zsc/service/SqlService.java ÐÞ¸Ä @@ -1,7 +1,7 @@ package com.job.zsc.service; package com.flightfeather.monitor.service; import com.job.zsc.pojo.PageBean; import com.job.zsc.pojo.OriginalData; import com.flightfeather.monitor.pojo.PageBean; import com.flightfeather.monitor.pojo.OriginalData; import java.time.LocalDate; import java.util.List; src/main/java/com/flightfeather/monitor/service/Vue3FumeService.java
ÎļþÃû´Ó src/main/java/com/job/zsc/service/Vue3FumeService.java ÐÞ¸Ä @@ -1,10 +1,9 @@ package com.job.zsc.service; package com.flightfeather.monitor.service; import com.job.zsc.pojo.DeviceInfo; import com.job.zsc.pojo.FumeAbnormalData; import com.job.zsc.pojo.FumeHistoryData; import com.job.zsc.pojo.PageBean; import org.springframework.stereotype.Service; import com.flightfeather.monitor.pojo.DeviceInfo; import com.flightfeather.monitor.pojo.FumeAbnormalData; import com.flightfeather.monitor.pojo.FumeHistoryData; import com.flightfeather.monitor.pojo.PageBean; import java.util.List; src/main/java/com/flightfeather/monitor/service/impl/AnalysisDataServiceImpl.java
ÎļþÃû´Ó src/main/java/com/job/zsc/service/impl/AnalysisDataServiceImpl.java ÐÞ¸Ä @@ -1,8 +1,8 @@ package com.job.zsc.service.impl; package com.flightfeather.monitor.service.impl; import com.job.zsc.mapper.AnalysisDataMapper; import com.job.zsc.pojo.AnalysisData; import com.job.zsc.service.AnalysisDataService; import com.flightfeather.monitor.mapper.AnalysisDataMapper; import com.flightfeather.monitor.service.AnalysisDataService; import com.flightfeather.monitor.pojo.AnalysisData; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; src/main/java/com/flightfeather/monitor/service/impl/FugitiveDustServiceImpl.java
ÎļþÃû´Ó src/main/java/com/job/zsc/service/impl/FugitiveDustServiceImpl.java ÐÞ¸Ä @@ -1,10 +1,10 @@ package com.job.zsc.service.impl; package com.flightfeather.monitor.service.impl; import com.flightfeather.monitor.mapper.FugitiveDustMapper; import com.flightfeather.monitor.pojo.*; import com.flightfeather.monitor.service.FugitiveDustService; import com.github.pagehelper.Page; import com.github.pagehelper.PageHelper; import com.job.zsc.mapper.FugitiveDustMapper; import com.job.zsc.pojo.*; import com.job.zsc.service.FugitiveDustService; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; @@ -178,7 +178,7 @@ } @Override public List<AnalysisDustData> analysisdataByType(String month,String type) { public List<AnalysisDustData> analysisdataByType(String month, String type) { List<AnalysisDustData> list = fugitiveDustMapper.analysisdataByType(month,type); return list; } src/main/java/com/flightfeather/monitor/service/impl/LoginServiceImpl.java
ÎļþÃû´Ó src/main/java/com/job/zsc/service/impl/LoginServiceImpl.java ÐÞ¸Ä @@ -1,8 +1,8 @@ package com.job.zsc.service.impl; package com.flightfeather.monitor.service.impl; import com.job.zsc.mapper.LoginMapper; import com.job.zsc.pojo.LoginUser; import com.job.zsc.service.LoginService; import com.flightfeather.monitor.mapper.LoginMapper; import com.flightfeather.monitor.pojo.LoginUser; import com.flightfeather.monitor.service.LoginService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; src/main/java/com/flightfeather/monitor/service/impl/SqlServiceImpl.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,66 @@ package com.flightfeather.monitor.service.impl; import com.flightfeather.monitor.mapper.SqlMapper; import com.flightfeather.monitor.pojo.OriginalData; import com.flightfeather.monitor.pojo.PageBean; import com.flightfeather.monitor.service.SqlService; import com.github.pagehelper.Page; import com.github.pagehelper.PageHelper; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.time.LocalDate; import java.util.List; @Service public class SqlServiceImpl implements SqlService { @Autowired private SqlMapper sqlMapper; @Override public PageBean page(Integer page, Integer pageSize, String shopname, LocalDate begin, LocalDate end) { /* //è·åæ»è®°å½æ° Long count=empMapper.count(); //è·åå页æ¥è¯¢ç»æå表 Integer start =(page-1)*pageSize; List<Emp> list=empMapper.list(start,pageSize);*/ //设置å页忰 PageHelper.startPage(page, pageSize); //æ§è¡æ¥è¯¢ List<OriginalData> infoList = sqlMapper.list(shopname, begin, end); //è·åæ¥è¯¢ç»æ Page<OriginalData> p1 = (Page<OriginalData>) infoList; //å°è£ PageBean对象*/ PageBean pageBean = new PageBean(p1.getTotal(), p1.getResult()); return pageBean; } @Override public List<OriginalData> show_all() { List<OriginalData> list_sql = sqlMapper.show_all(); return list_sql; } @Override public List<OriginalData> findShop(String shopname) { List<OriginalData> shops = sqlMapper.findShop(shopname); return shops; } @Override public List<OriginalData> findDate(LocalDate begin, LocalDate end) { List<OriginalData> dates = sqlMapper.findDate(begin, end); return dates; } @Override public List<OriginalData> findByForm(String name, String number, String dname, String begin, String end) { List<OriginalData> form = sqlMapper.findByForm(name, number, dname, begin, end); return form; } } src/main/java/com/flightfeather/monitor/service/impl/Vue3FumeServiceImpl.java
ÎļþÃû´Ó src/main/java/com/job/zsc/service/impl/Vue3FumeServiceImpl.java ÐÞ¸Ä @@ -1,14 +1,17 @@ package com.job.zsc.service.impl; package com.flightfeather.monitor.service.impl; import com.flightfeather.monitor.mapper.Vue3FumeMapper; import com.flightfeather.monitor.pojo.DeviceInfo; import com.flightfeather.monitor.pojo.FumeAbnormalData; import com.flightfeather.monitor.pojo.FumeHistoryData; import com.flightfeather.monitor.pojo.PageBean; import com.flightfeather.monitor.service.Vue3FumeService; import com.github.pagehelper.Page; import com.github.pagehelper.PageHelper; import com.job.zsc.mapper.Vue3FumeMapper; import com.job.zsc.pojo.*; import com.job.zsc.service.Vue3FumeService; import lombok.extern.slf4j.Slf4j; import org.apache.ibatis.annotations.Param; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.List; @Slf4j src/main/java/com/flightfeather/monitor/utils/MD5Util.java
ÎļþÃû´Ó src/main/java/com/job/zsc/utils/MD5Util.java ÐÞ¸Ä @@ -1,4 +1,4 @@ package com.job.zsc.utils; package com.flightfeather.monitor.utils; import java.math.BigInteger; import java.security.MessageDigest; src/main/java/com/flightfeather/monitor/utils/UUIDGenerator.kt
ÎļþÃû´Ó src/main/java/com/job/zsc/utils/UUIDGenerator.kt ÐÞ¸Ä @@ -1,4 +1,4 @@ package com.job.zsc.utils package com.flightfeather.monitor.utils import org.apache.commons.logging.LogFactory import java.net.InetAddress src/main/java/com/job/zsc/controller/dustexception/onlineAnalysisController.java
ÎļþÒÑɾ³ý src/main/java/com/job/zsc/dustexceptionanalysis/ExceptionAnalysis.java
ÎļþÒÑɾ³ý src/main/java/com/job/zsc/dustexceptionanalysis/analysis/Exceeding.java
ÎļþÒÑɾ³ý src/main/java/com/job/zsc/dustexceptionanalysis/database/DustRepository.java
ÎļþÒÑɾ³ý src/main/java/com/job/zsc/dustexceptionanalysis/dataprocess/DataProcess.java
ÎļþÒÑɾ³ý src/main/java/com/job/zsc/mapper/dustexception/OnlineAnalysisMapper.java
ÎļþÒÑɾ³ý src/main/java/com/job/zsc/service/LoginService.java
ÎļþÒÑɾ³ý src/main/java/com/job/zsc/service/dustexception/impl/onlineAnalysisServiceImpl.java
ÎļþÒÑɾ³ý src/main/java/com/job/zsc/service/dustexception/onlineAnalysisService.java
ÎļþÒÑɾ³ý src/main/java/com/job/zsc/service/impl/SqlServiceImpl.java
ÎļþÒÑɾ³ý src/main/java/com/job/zsc/service/impl/dustexception/onlineAnalysisImpl.java
ÎļþÒÑɾ³ý src/main/resources/application.yml
@@ -1,13 +1,18 @@ spring: datasource: driver-class-name: com.mysql.cj.jdbc.Driver # url: jdbc:mysql://localhost:3306/fume # username: fume # password: fume_feiyu2023 ds1: driver-class-name: com.mysql.cj.jdbc.Driver # url: jdbc:mysql://localhost:3306/fume # username: fume # password: fume_feiyu2023 url: jdbc:mysql://localhost:3306/qianduan_sql username: root password: 1234 # url: jdbc:mysql://localhost:3306/qianduan_sql # username: root # password: 1234 url: jdbc:mysql://localhost:3306/fume username: root password: 123456 mybatis: configuration: src/main/resources/generator/generatorConfig4ds1.xml
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,86 @@ <!--<?xml version="1.0" encoding="UTF-8"?>--> <!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd"> <generatorConfiguration> <!-- æ°æ®åºé©±å¨:éæ©ä½ çæ¬å°ç¡¬çä¸é¢çæ°æ®åºé©±å¨å --> <classPathEntry location="C:\Users\feiyu02\.m2\repository\mysql\mysql-connector-java\8.0.21\mysql-connector-java-8.0.21.jar"/> <context id="DB2Tables" targetRuntime="MyBatis3" defaultModelType="flat"> <!-- TKmybatisé ç½® --> <property name="javaFileEncoding" value="UTF-8"/> <property name="beginningDelimiter" value="`"/> <property name="endingDelimiter" value="`"/> <plugin type="${mapper.plugin}"> <property name="mappers" value="${mapper.Mapper}"/> </plugin> <commentGenerator> <property name="suppressDate" value="true"/> <!-- æ¯å¦å»é¤èªå¨çæç注é trueï¼æ¯ ï¼ false:å¦ --> <property name="suppressAllComments" value="true"/> </commentGenerator> <!--æ°æ®åºé¾æ¥URLï¼ç¨æ·åãå¯ç --> <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://114.215.109.124/fume?serverTimezone=Asia/Shanghai" userId="fumeRemote" password="feiyu2023"> </jdbcConnection> <javaTypeResolver> <property name="forceBigDecimals" value="false"/> </javaTypeResolver> <!-- çææ¨¡åçå ååä½ç½®--> <javaModelGenerator targetPackage="com.flightfeather.monitor.domain.ds1.entity" targetProject="src/main/java"> <property name="enableSubPackages" value="true"/> <property name="trimStrings" value="true"/> </javaModelGenerator> <!-- çææ å°æä»¶çå ååä½ç½®--> <sqlMapGenerator targetPackage="ds1" targetProject="src/main/resources/mapper"> <property name="enableSubPackages" value="true"/> </sqlMapGenerator> <!-- çæDAOçå ååä½ç½®--> <javaClientGenerator type="XMLMAPPER" targetPackage="com.flightfeather.monitor.domain.ds1.mapper" targetProject="src/main/java"> <property name="enableSubPackages" value="true"/> </javaClientGenerator> <!-- è¦çæç表 tableNameæ¯æ°æ®åºä¸ç表åæè§å¾å domainObjectNameæ¯å®ä½ç±»å--> <table tableName="du_js_t_login_info" domainObjectName="LoginInfo" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"/> <table tableName="du_js_t_request_task_setting" domainObjectName="RequestTaskSetting" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"/> <table tableName="du_js_t_site_latest_time" domainObjectName="DustSiteLatestTime" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"/> <table tableName="du_js_t_site_map" domainObjectName="DustSiteMap" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"/> <table tableName="dust_exception_data" domainObjectName="DustExceptionData" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"/> <table tableName="dust_exception_setting" domainObjectName="DustExceptionSetting" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"/> <table tableName="dust_global_setting" domainObjectName="DustGlobalSetting" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"/> <table tableName="dust_statistics_value" domainObjectName="DustStatisticsValue" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"/> <table tableName="ja_t_dust_site_data_info" domainObjectName="DustSiteData" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"/> <table tableName="ja_t_dust_site_info" domainObjectName="DustSiteInfo" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"/> </context> </generatorConfiguration> src/main/resources/mapper/AnalysisDataMapper.xml
ÎļþÃû´Ó src/main/resources/com/job/zsc/mapper/AnalysisDataMapper.xml ÐÞ¸Ä @@ -2,10 +2,10 @@ <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "https://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.job.zsc.mapper.AnalysisDataMapper"> <mapper namespace="com.flightfeather.monitor.mapper.AnalysisDataMapper"> <select id="findByDevId" resultType="com.job.zsc.pojo.AnalysisData"> <select id="findByDevId" resultType="com.flightfeather.monitor.pojo.AnalysisData"> select * from fm_web_analysis_data <where> <if test="devId != null and devId != '' "> @@ -19,7 +19,7 @@ </select> <!--ä¿¡æ¯åæ°æ®æªåå¼çæ°æ®è¡¨åæ ed_data--> <!-- <select id="find" resultType="com.job.zsc.pojo.AnalysisData">--> <!-- <select id="find" resultType="AnalysisData">--> <!-- SELECT--> <!-- equipment_number as fume_dev_id,--> <!-- DATE(reporting_time) as fume_date,--> @@ -67,7 +67,7 @@ <!-- limit 0,500--> <!-- </select>--> <!--æ°è¡¨--> <select id="find" resultType="com.job.zsc.pojo.AnalysisData"> <select id="find" resultType="com.flightfeather.monitor.pojo.AnalysisData"> SELECT a.MV_Stat_Code as fume_dev_id, @@ -119,7 +119,7 @@ <!-- å»é--> <select id="search" resultType="com.job.zsc.pojo.AnalysisData"> <select id="search" resultType="com.flightfeather.monitor.pojo.AnalysisData"> select a.*,b.DI_Name,b.DI_Supplier from fm_web_analysis_data as a join ea_t_device_info as b on a.fume_dev_id = b.DI_Code <where> src/main/resources/mapper/FugitiveDustMapper.xml
ÎļþÃû´Ó src/main/resources/com/job/zsc/mapper/FugitiveDustMapper.xml ÐÞ¸Ä @@ -2,7 +2,7 @@ <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "https://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.job.zsc.mapper.FugitiveDustMapper"> <mapper namespace="com.flightfeather.monitor.mapper.FugitiveDustMapper"> <update id="update"> update audit_info <set> @@ -30,7 +30,7 @@ where exception_id = #{exceptionId} </update> <select id="conditonQueryDustHistoryData" resultType="com.job.zsc.pojo.DustSiteData"> <select id="conditonQueryDustHistoryData" resultType="com.flightfeather.monitor.pojo.DustSiteData"> select a.*,b.* from ja_t_dust_site_data_info as a join ja_t_dust_site_info as b on a.mn_code = b.mn_code <where> @@ -55,7 +55,7 @@ </select> <!--åææ°æ®--> <select id="analysisdata" resultType="com.job.zsc.pojo.AnalysisDustData"> <select id="analysisdata" resultType="com.flightfeather.monitor.pojo.AnalysisDustData"> select a.*,b.name,b.duty_company from dust_statistics_value as a join ja_t_dust_site_info as b on a.mn_code = b. mn_code <where> <if test="siteName !=null and siteName != ''"> @@ -70,7 +70,7 @@ <!-- æ ¹æ®ç«ç¹åååæ¶æ®µè¿è¡ç»è®¡åæ--> <select id="analysisByTime" resultType="com.job.zsc.pojo.AnalysisDustData"> <select id="analysisByTime" resultType="com.flightfeather.monitor.pojo.AnalysisDustData"> select c.name,d.* from ja_t_dust_site_info as c join ( @@ -101,7 +101,7 @@ <!--æ¡ä»¶æ¥è¯¢å¼å¸¸æ°æ® å ä¸äºå®¡è®¡ä¿¡æ¯--> <select id="getExceptionData" resultType="com.job.zsc.pojo.DustExceptionData"> <select id="getExceptionData" resultType="com.flightfeather.monitor.pojo.DustExceptionData"> select * from (select a.* ,b.name,b.typename,b.address,b.duty_company from dust_exception_data as a join ja_t_dust_site_info as b on a.mn_code = b.mn_code @@ -129,7 +129,7 @@ <!-- æ ¹æ®ææ®µæ¶é´å æä¸ªå¼å¸¸ç±»åæ¥è¯¢å¯¹åºçåºéºåç§°å设å¤ç¼å·--> <select id="getExceptionSitenameAndCode" resultType="com.job.zsc.pojo.DustExceptionData"> <select id="getExceptionSitenameAndCode" resultType="com.flightfeather.monitor.pojo.DustExceptionData"> select DISTINCT b.name,a.mn_code from dust_exception_data as a join ja_t_dust_site_info as b on a.mn_code = b.mn_code @@ -145,7 +145,7 @@ </select> <!-- æ¡ä»¶æ¥è¯¢å岿°æ®--> <select id="conditonQueryHistoryData" resultType="com.job.zsc.pojo.DustSiteData"> <select id="conditonQueryHistoryData" resultType="com.flightfeather.monitor.pojo.DustSiteData"> select a.*,b.name,b.duty_Company from ja_t_dust_site_data_info as a join ja_t_dust_site_info as b on a.mn_code = b.mn_code <where> @@ -160,7 +160,7 @@ order by a.lst asc </select> <select id="getHasAuditedData" resultType="com.job.zsc.pojo.DustExceptionData"> <select id="getHasAuditedData" resultType="com.flightfeather.monitor.pojo.DustExceptionData"> select * from dust_exception_data as a left join audit_info as b on a.id = b.exception_id <where> @@ -171,7 +171,7 @@ </where> </select> <select id="getSiteNameByTimeAndExceptionType" resultType="com.job.zsc.pojo.DustExceptionData"> <select id="getSiteNameByTimeAndExceptionType" resultType="com.flightfeather.monitor.pojo.DustExceptionData"> select DISTINCT b.name from dust_exception_data as a join ja_t_dust_site_info as b on a.mn_code = b.mn_code <where> @@ -188,7 +188,7 @@ </where> </select> <select id="analysisdataByType" resultType="com.job.zsc.pojo.AnalysisDustData"> <select id="analysisdataByType" resultType="com.flightfeather.monitor.pojo.AnalysisDustData"> select a.*,b.name,b.duty_company from dust_statistics_value as a join ja_t_dust_site_info as b on a.mn_code = b. mn_code <where> <if test="month != null and month != null"> @@ -201,7 +201,7 @@ </where> </select> <select id="analysisdataByTimeAndType" resultType="com.job.zsc.pojo.AnalysisDustData"> <select id="analysisdataByTimeAndType" resultType="com.flightfeather.monitor.pojo.AnalysisDustData"> select a.*,b.name,b.duty_company from dust_statistics_value as a join ja_t_dust_site_info as b on a.mn_code = b. mn_code <where> <if test="beginTime != null and endTime != null"> src/main/resources/mapper/SqlMapper.xml
ÎļþÃû´Ó src/main/resources/com/job/zsc/mapper/SqlMapper.xml ÐÞ¸Ä @@ -2,9 +2,9 @@ <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "https://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.job.zsc.mapper.SqlMapper"> <mapper namespace="com.flightfeather.monitor.mapper.SqlMapper"> <select id="list" resultType="com.job.zsc.pojo.OriginalData"> <select id="list" resultType="com.flightfeather.monitor.pojo.OriginalData"> select * from ed_data <where> <if test="shopname != null and shopname != '' "> @@ -20,7 +20,7 @@ <select id="findByForm" resultType="com.job.zsc.pojo.OriginalData"> <select id="findByForm" resultType="com.flightfeather.monitor.pojo.OriginalData"> select * from ed_data <where> <if test="name != null and name != '' "> src/main/resources/mapper/Vue3FumeMapper.xml
ÎļþÃû´Ó src/main/resources/com/job/zsc/mapper/Vue3FumeMapper.xml ÐÞ¸Ä @@ -2,10 +2,10 @@ <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "https://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.job.zsc.mapper.Vue3FumeMapper"> <mapper namespace="com.flightfeather.monitor.mapper.Vue3FumeMapper"> <!-- è¶ æ æ²¹çæ¥è¯¢--> <select id="conditionQuery" resultType="com.job.zsc.pojo.FumeHistoryData"> <select id="conditionQuery" resultType="com.flightfeather.monitor.pojo.FumeHistoryData"> SELECT a1.MV_ID, a1.MV_Stat_Code, b.DI_Name,b.DI_Supplier, a1.MV_Create_Time, a1.MV_Data_Time, a1.MV_Fume_Concentration2 FROM exceeding_st_data AS a1 INNER JOIN ea_t_device_info AS b ON a1.MV_Stat_Code = b.DI_Code @@ -22,7 +22,7 @@ </select> <!-- å岿²¹çæ¥è¯¢--> <!-- <select id="conditionQueryHistory" resultType="com.job.zsc.pojo.FumeHistoryData">--> <!-- <select id="conditionQueryHistory" resultType="FumeHistoryData">--> <!-- SELECT d.DI_Name, c.*--> <!-- FROM (--> <!-- SELECT a.*--> @@ -42,7 +42,7 @@ <!-- ORDER BY c.MV_Data_Time ASC;--> <!-- </select>--> <!-- å岿²¹çæ¥è¯¢ ä¿®æ¹äºè¯å¥--> <select id="conditionQueryHistory" resultType="com.job.zsc.pojo.FumeHistoryData"> <select id="conditionQueryHistory" resultType="com.flightfeather.monitor.pojo.FumeHistoryData"> SELECT d.DI_Name, c.* FROM ( SELECT a.* @@ -70,7 +70,7 @@ <!-- æ¡ä»¶æ¥è¯¢å¼å¸¸è¡¨--> <select id="conditonQueryAbnormalData" resultType="com.job.zsc.pojo.FumeAbnormalData"> <select id="conditonQueryAbnormalData" resultType="com.flightfeather.monitor.pojo.FumeAbnormalData"> select a1.dev_id,b.DI_Name,a1.exception_type,a1.region,a1.begin_time,a1.end_time from abnormal_data as a1 join ea_t_device_info as b on a1.dev_id = b.DI_Code <where> @@ -88,7 +88,7 @@ </select> <!-- æ¡ä»¶æ¥è¯¢å¼å¸¸è¡¨ å¢å äºå¼å¸¸ç±»åé项--> <select id="conditonQueryAbnormalData1" resultType="com.job.zsc.pojo.FumeAbnormalData"> <select id="conditonQueryAbnormalData1" resultType="com.flightfeather.monitor.pojo.FumeAbnormalData"> select a1.dev_id,b.DI_Name,a1.exception,a1.exception_type,a1.region,a1.begin_time,a1.end_time from abnormal_data as a1 join ea_t_device_info as b on a1.dev_id = b.DI_Code <where> @@ -108,7 +108,7 @@ </select> <!--æ ¹æ®åºéºåéæ©å°å¤ä¸ºExcel --> <select id="exportByShopName" resultType="com.job.zsc.pojo.FumeHistoryData"> <select id="exportByShopName" resultType="com.flightfeather.monitor.pojo.FumeHistoryData"> SELECT a.MV_Stat_Code, b.DI_Name, a.MV_Data_Time, a.MV_Fan_Electricity,a.MV_Purifier_Electricity,a.MV_Fume_Concentration2 FROM fd_t_minutevalue AS a JOIN ea_t_device_info AS b ON a.MV_Stat_Code = b.DI_Code @@ -126,7 +126,7 @@ </select> <!-- å¤éåºéºå è¿åå¤éåºéºææ°ä¸æ¡æ°æ®--> <select id="findLaststById" resultType="com.job.zsc.pojo.FumeHistoryData"> <select id="findLaststById" resultType="com.flightfeather.monitor.pojo.FumeHistoryData"> SELECT a.MV_Stat_Code, b.DI_Name, b.DI_Supplier, a.MV_Data_Time,a.MV_Fan_Electricity,a.MV_Purifier_Electricity,a.MV_Fume_Concentration2 FROM fd_t_minutevalue as a JOIN ea_t_device_info as b ON a.MV_Stat_Code = b.DI_Code @@ -146,7 +146,7 @@ </select> <!-- æ¡ä»¶ç»åæ¥è¯¢å¼å¸¸è¡¨ å¼å¸¸ç±»åé项æ¹ä¸ºå¤é--> <select id="conditonQueryAbnormalData2" resultType="com.job.zsc.pojo.FumeAbnormalData"> <select id="conditonQueryAbnormalData2" resultType="com.flightfeather.monitor.pojo.FumeAbnormalData"> select a1.dev_id,b.DI_Name,b.DI_Supplier,a1.exception,a1.exception_type,a1.region,a1.begin_time,a1.end_time from abnormal_data as a1 join ea_t_device_info as b on a1.dev_id = b.DI_Code <where> @@ -170,7 +170,7 @@ <!-- æ¡ä»¶ç»åæ¥è¯¢å¼å¸¸è¡¨ å¼å¸¸ç±»åé项æ¹ä¸ºå¤é--> <select id="conditonQueryAbnormalData3" resultType="com.job.zsc.pojo.FumeAbnormalData"> <select id="conditonQueryAbnormalData3" resultType="com.flightfeather.monitor.pojo.FumeAbnormalData"> select a1.dev_id,b.DI_Name,a1.exception,a1.exception_type,a1.region,a1.begin_time,a1.end_time from abnormal_data as a1 join ea_t_device_info as b on a1.dev_id = b.DI_Code <where> @@ -191,7 +191,7 @@ </where> </select> <select id="findShopNameBYTime" resultType="com.job.zsc.pojo.FumeAbnormalData"> <select id="findShopNameBYTime" resultType="com.flightfeather.monitor.pojo.FumeAbnormalData"> SELECT DISTINCT b.DI_Name,a.dev_id FROM abnormal_data AS a JOIN ea_t_device_info AS b ON a.dev_id = b.DI_Code src/main/resources/mapper/ds1/DustExceptionDataMapper.xml
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,23 @@ <?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.flightfeather.monitor.domain.ds1.mapper.DustExceptionDataMapper"> <resultMap id="BaseResultMap" type="com.flightfeather.monitor.domain.ds1.entity.DustExceptionData"> <!-- WARNING - @mbg.generated --> <id column="id" jdbcType="INTEGER" property="id" /> <result column="mn_code" jdbcType="VARCHAR" property="mnCode" /> <result column="exception" jdbcType="VARCHAR" property="exception" /> <result column="exception_type" jdbcType="INTEGER" property="exceptionType" /> <result column="region" jdbcType="VARCHAR" property="region" /> <result column="begin_time" jdbcType="TIMESTAMP" property="beginTime" /> <result column="end_time" jdbcType="TIMESTAMP" property="endTime" /> <result column="avg_value" jdbcType="DOUBLE" property="avgValue" /> </resultMap> <sql id="Base_Column_List"> <!-- WARNING - @mbg.generated --> id, mn_code, exception, exception_type, region, begin_time, end_time, avg_value </sql> </mapper> src/main/resources/mapper/ds1/DustExceptionSettingMapper.xml
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,36 @@ <?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.flightfeather.monitor.domain.ds1.mapper.DustExceptionSettingMapper"> <resultMap id="BaseResultMap" type="com.flightfeather.monitor.domain.ds1.entity.DustExceptionSetting"> <!-- WARNING - @mbg.generated --> <id column="id" jdbcType="INTEGER" property="id" /> <result column="user" jdbcType="VARCHAR" property="user" /> <result column="update_time" jdbcType="TIMESTAMP" property="updateTime" /> <result column="version" jdbcType="VARCHAR" property="version" /> <result column="miss_data_minutes" jdbcType="INTEGER" property="missDataMinutes" /> <result column="data_low" jdbcType="DOUBLE" property="dataLow" /> <result column="long_time_no_change" jdbcType="INTEGER" property="longTimeNoChange" /> <result column="mutation_num" jdbcType="INTEGER" property="mutationNum" /> <result column="mutation_rate" jdbcType="DOUBLE" property="mutationRate" /> <result column="near_exceed_low_value" jdbcType="DOUBLE" property="nearExceedLowValue" /> <result column="near_exceed_high_value" jdbcType="DOUBLE" property="nearExceedHighValue" /> <result column="near_exceed_num" jdbcType="INTEGER" property="nearExceedNum" /> <result column="day_exceed_borderline_low_num" jdbcType="INTEGER" property="dayExceedBorderlineLowNum" /> <result column="day_exceed_borderline_high_num" jdbcType="INTEGER" property="dayExceedBorderlineHighNum" /> <result column="change_trend_group" jdbcType="INTEGER" property="changeTrendGroup" /> <result column="change_trend_interval" jdbcType="INTEGER" property="changeTrendInterval" /> <result column="change_trend_rate" jdbcType="DOUBLE" property="changeTrendRate" /> <result column="exceeding_standard" jdbcType="DOUBLE" property="exceedingStandard" /> </resultMap> <sql id="Base_Column_List"> <!-- WARNING - @mbg.generated --> id, user, update_time, version, miss_data_minutes, data_low, long_time_no_change, mutation_num, mutation_rate, near_exceed_low_value, near_exceed_high_value, near_exceed_num, day_exceed_borderline_low_num, day_exceed_borderline_high_num, change_trend_group, change_trend_interval, change_trend_rate, exceeding_standard </sql> </mapper> src/main/resources/mapper/ds1/DustGlobalSettingMapper.xml
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,26 @@ <?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.flightfeather.monitor.domain.ds1.mapper.DustGlobalSettingMapper"> <resultMap id="BaseResultMap" type="com.flightfeather.monitor.domain.ds1.entity.DustGlobalSetting"> <!-- WARNING - @mbg.generated --> <id column="id" jdbcType="INTEGER" property="id" /> <result column="user" jdbcType="VARCHAR" property="user" /> <result column="create_time" jdbcType="TIMESTAMP" property="createTime" /> <result column="update_time" jdbcType="TIMESTAMP" property="updateTime" /> <result column="type" jdbcType="VARCHAR" property="type" /> <result column="exceeding" jdbcType="DOUBLE" property="exceeding" /> <result column="begin_time" jdbcType="TIMESTAMP" property="beginTime" /> <result column="end_time" jdbcType="TIMESTAMP" property="endTime" /> <result column="region" jdbcType="VARCHAR" property="region" /> <result column="is_regular_time" jdbcType="VARCHAR" property="isRegularTime" /> </resultMap> <sql id="Base_Column_List"> <!-- WARNING - @mbg.generated --> id, user, create_time, update_time, type, exceeding, begin_time, end_time, region, is_regular_time </sql> </mapper> src/main/resources/mapper/ds1/DustSiteDataMapper.xml
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,23 @@ <?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.flightfeather.monitor.domain.ds1.mapper.DustSiteDataMapper"> <resultMap id="BaseResultMap" type="com.flightfeather.monitor.domain.ds1.entity.DustSiteData"> <!-- WARNING - @mbg.generated --> <id column="id" jdbcType="INTEGER" property="id" /> <result column="mn_code" jdbcType="VARCHAR" property="mnCode" /> <result column="dust_value" jdbcType="DOUBLE" property="dustValue" /> <result column="noise_value" jdbcType="DOUBLE" property="noiseValue" /> <result column="lst" jdbcType="TIMESTAMP" property="lst" /> <result column="quality" jdbcType="VARCHAR" property="quality" /> <result column="grade" jdbcType="INTEGER" property="grade" /> <result column="flag" jdbcType="VARCHAR" property="flag" /> </resultMap> <sql id="Base_Column_List"> <!-- WARNING - @mbg.generated --> id, mn_code, dust_value, noise_value, lst, quality, grade, flag </sql> </mapper> src/main/resources/mapper/ds1/DustSiteInfoMapper.xml
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,68 @@ <?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.flightfeather.monitor.domain.ds1.mapper.DustSiteInfoMapper"> <resultMap id="BaseResultMap" type="com.flightfeather.monitor.domain.ds1.entity.DustSiteInfo"> <!-- WARNING - @mbg.generated --> <id column="id" jdbcType="INTEGER" property="id" /> <result column="mn_code" jdbcType="VARCHAR" property="mnCode" /> <result column="address" jdbcType="VARCHAR" property="address" /> <result column="name" jdbcType="VARCHAR" property="name" /> <result column="code" jdbcType="VARCHAR" property="code" /> <result column="begin_date" jdbcType="TIMESTAMP" property="beginDate" /> <result column="duty_company" jdbcType="VARCHAR" property="dutyCompany" /> <result column="duty_company_id" jdbcType="VARCHAR" property="dutyCompanyId" /> <result column="end_date" jdbcType="TIMESTAMP" property="endDate" /> <result column="engineering_stage" jdbcType="VARCHAR" property="engineeringStage" /> <result column="group_id" jdbcType="VARCHAR" property="groupId" /> <result column="group_name" jdbcType="VARCHAR" property="groupName" /> <result column="is_online" jdbcType="VARCHAR" property="isOnline" /> <result column="is_trouble" jdbcType="VARCHAR" property="isTrouble" /> <result column="jhpt_update_time" jdbcType="VARCHAR" property="jhptUpdateTime" /> <result column="kindex" jdbcType="VARCHAR" property="kindex" /> <result column="latitude" jdbcType="VARCHAR" property="latitude" /> <result column="linkman" jdbcType="VARCHAR" property="linkman" /> <result column="longitude" jdbcType="VARCHAR" property="longitude" /> <result column="phone" jdbcType="VARCHAR" property="phone" /> <result column="province" jdbcType="VARCHAR" property="province" /> <result column="ring_id" jdbcType="VARCHAR" property="ringId" /> <result column="ring_name" jdbcType="VARCHAR" property="ringName" /> <result column="type_id" jdbcType="VARCHAR" property="typeId" /> <result column="typename" jdbcType="VARCHAR" property="typename" /> <result column="stop_time" jdbcType="TIMESTAMP" property="stopTime" /> <result column="active" jdbcType="VARCHAR" property="active" /> <result column="trouble_num" jdbcType="INTEGER" property="troubleNum" /> <result column="insert_time" jdbcType="TIMESTAMP" property="insertTime" /> <result column="stage_begin_date" jdbcType="TIMESTAMP" property="stageBeginDate" /> <result column="tsp" jdbcType="DOUBLE" property="tsp" /> <result column="union_type_id" jdbcType="VARCHAR" property="unionTypeId" /> <result column="wall_height" jdbcType="VARCHAR" property="wallHeight" /> <result column="ywsj_date" jdbcType="TIMESTAMP" property="ywsjDate" /> <result column="build_area" jdbcType="VARCHAR" property="buildArea" /> <result column="construction_unit" jdbcType="VARCHAR" property="constructionUnit" /> <result column="control_level" jdbcType="VARCHAR" property="controlLevel" /> <result column="developers" jdbcType="VARCHAR" property="developers" /> <result column="do_time" jdbcType="TIMESTAMP" property="doTime" /> <result column="has_monitor" jdbcType="VARCHAR" property="hasMonitor" /> <result column="data_time" jdbcType="TIMESTAMP" property="dataTime" /> <result column="engineering_stage_code" jdbcType="VARCHAR" property="engineeringStageCode" /> <result column="equipment_code" jdbcType="VARCHAR" property="equipmentCode" /> <result column="floor_area" jdbcType="VARCHAR" property="floorArea" /> <result column="jhpt_delete" jdbcType="VARCHAR" property="jhptDelete" /> <result column="noise_region" jdbcType="VARCHAR" property="noiseRegion" /> <result column="responsible" jdbcType="VARCHAR" property="responsible" /> </resultMap> <sql id="Base_Column_List"> <!-- WARNING - @mbg.generated --> id, mn_code, address, name, code, begin_date, duty_company, duty_company_id, end_date, engineering_stage, group_id, group_name, is_online, is_trouble, jhpt_update_time, kindex, latitude, linkman, longitude, phone, province, ring_id, ring_name, type_id, typename, stop_time, active, trouble_num, insert_time, stage_begin_date, tsp, union_type_id, wall_height, ywsj_date, build_area, construction_unit, control_level, developers, do_time, has_monitor, data_time, engineering_stage_code, equipment_code, floor_area, jhpt_delete, noise_region, responsible </sql> </mapper> src/main/resources/mapper/ds1/DustSiteLatestTimeMapper.xml
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,18 @@ <?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.flightfeather.monitor.domain.ds1.mapper.DustSiteLatestTimeMapper"> <resultMap id="BaseResultMap" type="com.flightfeather.monitor.domain.ds1.entity.DustSiteLatestTime"> <!-- WARNING - @mbg.generated --> <id column="mn_code" jdbcType="VARCHAR" property="mnCode" /> <result column="latest_time" jdbcType="TIMESTAMP" property="latestTime" /> <result column="device_status" jdbcType="INTEGER" property="deviceStatus" /> </resultMap> <sql id="Base_Column_List"> <!-- WARNING - @mbg.generated --> mn_code, latest_time, device_status </sql> </mapper> src/main/resources/mapper/ds1/DustSiteMapMapper.xml
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,24 @@ <?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.flightfeather.monitor.domain.ds1.mapper.DustSiteMapMapper"> <resultMap id="BaseResultMap" type="com.flightfeather.monitor.domain.ds1.entity.DustSiteMap"> <!-- WARNING - @mbg.generated --> <id column="Id" jdbcType="INTEGER" property="id" /> <result column="TZ_User_Id" jdbcType="VARCHAR" property="tzUserId" /> <result column="TZ_User_Name" jdbcType="VARCHAR" property="tzUserName" /> <result column="JS_Device_Code" jdbcType="VARCHAR" property="jsDeviceCode" /> <result column="JS_Device_Name" jdbcType="VARCHAR" property="jsDeviceName" /> <result column="SV_User_Id" jdbcType="VARCHAR" property="svUserId" /> <result column="SV_User_Name" jdbcType="VARCHAR" property="svUserName" /> <result column="Create_Time" jdbcType="TIMESTAMP" property="createTime" /> </resultMap> <sql id="Base_Column_List"> <!-- WARNING - @mbg.generated --> Id, TZ_User_Id, TZ_User_Name, JS_Device_Code, JS_Device_Name, SV_User_Id, SV_User_Name, Create_Time </sql> </mapper> src/main/resources/mapper/ds1/DustStatisticsValueMapper.xml
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,25 @@ <?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.flightfeather.monitor.domain.ds1.mapper.DustStatisticsValueMapper"> <resultMap id="BaseResultMap" type="com.flightfeather.monitor.domain.ds1.entity.DustStatisticsValue"> <!-- WARNING - @mbg.generated --> <id column="id" jdbcType="INTEGER" property="id" /> <result column="mn_code" jdbcType="VARCHAR" property="mnCode" /> <result column="lst" jdbcType="DATE" property="lst" /> <result column="day_avg" jdbcType="VARCHAR" property="dayAvg" /> <result column="min" jdbcType="VARCHAR" property="min" /> <result column="max" jdbcType="VARCHAR" property="max" /> <result column="day_online" jdbcType="VARCHAR" property="dayOnline" /> <result column="day_valid" jdbcType="VARCHAR" property="dayValid" /> <result column="day_exceeding" jdbcType="VARCHAR" property="dayExceeding" /> <result column="type" jdbcType="VARCHAR" property="type" /> </resultMap> <sql id="Base_Column_List"> <!-- WARNING - @mbg.generated --> id, mn_code, lst, day_avg, min, max, day_online, day_valid, day_exceeding, type </sql> </mapper> src/main/resources/mapper/ds1/LoginInfoMapper.xml
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,21 @@ <?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.flightfeather.monitor.domain.ds1.mapper.LoginInfoMapper"> <resultMap id="BaseResultMap" type="com.flightfeather.monitor.domain.ds1.entity.LoginInfo"> <!-- WARNING - @mbg.generated --> <id column="id" jdbcType="INTEGER" property="id" /> <result column="user_name" jdbcType="VARCHAR" property="userName" /> <result column="password" jdbcType="VARCHAR" property="password" /> <result column="cookie" jdbcType="VARCHAR" property="cookie" /> <result column="cookie_timestamp" jdbcType="TIMESTAMP" property="cookieTimestamp" /> <result column="region" jdbcType="VARCHAR" property="region" /> </resultMap> <sql id="Base_Column_List"> <!-- WARNING - @mbg.generated --> id, user_name, password, cookie, cookie_timestamp, region </sql> </mapper> src/main/resources/mapper/ds1/RequestTaskSettingMapper.xml
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,37 @@ <?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.flightfeather.monitor.domain.ds1.mapper.RequestTaskSettingMapper"> <resultMap id="BaseResultMap" type="com.flightfeather.monitor.domain.ds1.entity.RequestTaskSetting"> <!-- WARNING - @mbg.generated --> <id column="id" jdbcType="INTEGER" property="id" /> <result column="user" jdbcType="VARCHAR" property="user" /> <result column="update_time" jdbcType="TIMESTAMP" property="updateTime" /> <result column="region" jdbcType="VARCHAR" property="region" /> <result column="version" jdbcType="VARCHAR" property="version" /> <result column="request_start_time" jdbcType="TIMESTAMP" property="requestStartTime" /> <result column="request_end_time" jdbcType="TIMESTAMP" property="requestEndTime" /> <result column="request_interval_seconds" jdbcType="INTEGER" property="requestIntervalSeconds" /> <result column="request_range_hour" jdbcType="INTEGER" property="requestRangeHour" /> <result column="request_range_interval_seconds" jdbcType="INTEGER" property="requestRangeIntervalSeconds" /> <result column="request_fail_wait_seconds" jdbcType="INTEGER" property="requestFailWaitSeconds" /> <result column="request_retry_times" jdbcType="INTEGER" property="requestRetryTimes" /> <result column="statics_daily_time" jdbcType="TIMESTAMP" property="staticsDailyTime" /> <result column="statics_monthly_time" jdbcType="TIMESTAMP" property="staticsMonthlyTime" /> <result column="login_fail_wait_seconds" jdbcType="INTEGER" property="loginFailWaitSeconds" /> <result column="login_retry_times" jdbcType="INTEGER" property="loginRetryTimes" /> <result column="task_retry_wait_seconds" jdbcType="INTEGER" property="taskRetryWaitSeconds" /> <result column="first_request_offset_days" jdbcType="INTEGER" property="firstRequestOffsetDays" /> <result column="request_cookie_valid_duration" jdbcType="INTEGER" property="requestCookieValidDuration" /> </resultMap> <sql id="Base_Column_List"> <!-- WARNING - @mbg.generated --> id, user, update_time, region, version, request_start_time, request_end_time, request_interval_seconds, request_range_hour, request_range_interval_seconds, request_fail_wait_seconds, request_retry_times, statics_daily_time, statics_monthly_time, login_fail_wait_seconds, login_retry_times, task_retry_wait_seconds, first_request_offset_days, request_cookie_valid_duration </sql> </mapper> src/test/java/com/flightfeather/monitor/QianduanApplicationTests.java
ÎļþÃû´Ó src/test/java/com/job/zsc/QianduanApplicationTests.java ÐÞ¸Ä @@ -1,15 +1,11 @@ package com.job.zsc; package com.flightfeather.monitor; import com.job.zsc.dustexceptionanalysis.analysis.Exceeding; import com.job.zsc.dustexceptionanalysis.database.DustRepository; import com.job.zsc.mapper.dustexception.OnlineAnalysisMapper; import com.job.zsc.pojo.DustExceptionSetting; import com.job.zsc.pojo.DustSiteData; import com.flightfeather.monitor.analysis.database.DustRepository; import com.flightfeather.monitor.pojo.DustExceptionSetting; import org.junit.jupiter.api.Test; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.boot.test.context.SpringBootTest; import java.sql.SQLOutput; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.*;