From 23258c585a626b15d770459870a8b24763cf540c Mon Sep 17 00:00:00 2001 From: AdaKing88 <369509171> Date: 星期一, 21 八月 2023 09:08:27 +0800 Subject: [PATCH] 初版 --- src/main/java/com/tairui/app/cim/mapper/xml/BusProductionDeviceMapper.xml | 50 + src/main/java/com/tairui/app/cim/mapper/BusProductionDeviceMapper.java | 29 src/test/java/com/tairui/app/DemoApplicationTests.java | 13 src/main/java/com/tairui/app/cim/mapper/PersonnelPointMapper.java | 27 src/main/java/com/tairui/app/cim/mapper/MajorHazardsPointMapper.java | 23 src/main/java/com/http/Swagger3Config.java | 39 src/main/java/com/tairui/app/cim/util/MyGeometryHandler.java | 48 src/main/java/com/tairui/app/cim/mapper/FireEquipmentPointMapper.java | 23 src/main/java/com/tairui/app/cim/service/IBusProductionDeviceService.java | 16 src/main/java/com/tairui/app/cim/util/CodeGenerator.java | 139 ++ src/main/java/com/tairui/app/cim/util/MyBatisPage.java | 18 src/main/java/com/tairui/app/cim/dao/model/CameraPoint.java | 25 src/main/java/com/tairui/app/cim/dao/model/Elevation.java | 41 src/main/java/com/tairui/app/cim/mapper/xml/BusDeviceMainMapper.xml | 38 src/main/resources/com/tairui/app/cim/test/mapper/EntranceGuardPointMapper.xml | 28 src/main/java/com/tairui/app/DemoApplication.java | 16 src/main/java/com/tairui/app/cim/mapper/ElevationMapper.java | 57 + src/main/java/com/tairui/app/cim/mapper/EntranceGuardPointMapper.java | 23 src/main/java/com/tairui/app/cim/mapper/ProductionAreaMapper.java | 29 src/main/java/com/tairui/app/cim/controller/BusProductionDeviceController.java | 95 + src/main/java/com/tairui/app/cim/mapper/OperationAreaMapper.java | 27 src/main/java/com/tairui/app/cim/config/MyBatisPlusConfig.java | 16 src/main/java/com/tairui/app/cim/dao/model/AlarmPoint.java | 25 src/main/java/com/http/HttpResult.java | 69 + .mvn/wrapper/maven-wrapper.properties | 2 src/main/java/com/tairui/app/cim/dao/model/EmergencySuppliesPoint.java | 62 + src/main/java/com/tairui/app/cim/dao/model/Inspection.java | 25 src/main/java/com/tairui/app/cim/controller/BusDeviceMainController.java | 106 ++ src/main/java/com/tairui/app/cim/mapper/AlarmPointMapper.java | 29 .mvn/wrapper/MavenWrapperDownloader.java | 118 ++ src/main/java/com/tairui/app/cim/mapper/CameraMapper.java | 27 src/main/java/com/tairui/app/cim/dao/model/BusDeviceMain.java | 115 ++ src/main/java/com/tairui/app/cim/mapper/ToxicGasPointMapper.java | 25 src/main/java/com/tairui/app/cim/mapper/EmergencySuppliesPointMapper.java | 23 src/main/java/com/tairui/app/cim/mapper/InspectionMapper.java | 27 src/main/java/com/tairui/app/cim/service/impl/ProductionAreaServiceImpl.java | 20 .mvn/wrapper/maven-wrapper.jar | 0 src/main/java/com/tairui/app/cim/dao/model/FireEquipmentPoint.java | 62 + src/main/java/com/tairui/app/cim/controller/ProductionAreaController.java | 82 + src/main/resources/com/tairui/app/cim/test/mapper/MajorHazardsPointMapper.xml | 27 src/main/java/com/tairui/app/cim/dao/model/BusProductionDevice.java | 154 +++ src/main/java/com/tairui/app/cim/mapper/EvacuationPointMapper.java | 23 src/main/java/com/tairui/app/cim/mapper/BusDeviceMainMapper.java | 26 src/main/java/com/tairui/app/cim/service/impl/BusProductionDeviceServiceImpl.java | 20 src/main/java/com/tairui/app/cim/service/impl/BusDeviceMainServiceImpl.java | 20 src/main/java/com/tairui/app/cim/dao/model/ProductionArea.java | 28 src/main/java/com/tairui/app/cim/dao/model/EvacuationPoint.java | 64 + src/main/java/com/tairui/app/cim/dao/model/ToxicGasPoint.java | 64 + src/main/java/com/tairui/app/cim/mapper/ProductionUnitAreaMapper.java | 26 src/main/resources/com/tairui/app/cim/test/mapper/FireEquipmentPointMapper.xml | 27 src/main/java/com/tairui/app/cim/util/GeoJsonUtil.java | 95 + src/main/java/com/tairui/app/cim/dao/model/OperationArea.java | 28 src/main/resources/com/tairui/app/cim/test/mapper/EmergencySuppliesPointMapper.xml | 27 src/main/resources/com/tairui/app/cim/test/mapper/ToxicGasPointMapper.xml | 28 src/main/java/com/tairui/app/cim/service/IProductionAreaService.java | 16 src/main/java/com/tairui/app/cim/controller/GeomController.java | 206 ++++ src/main/java/com/tairui/app/cim/dao/model/ProductionUnitArea.java | 28 src/main/java/com/tairui/app/cim/service/IBusDeviceMainService.java | 16 src/main/java/com/http/HttpStatus.java | 149 ++ src/main/java/com/tairui/app/cim/dao/model/PersonnelPoint.java | 25 src/main/resources/com/tairui/app/cim/test/mapper/EvacuationPointMapper.xml | 28 src/main/resources/application.yml | 88 + src/main/java/com/tairui/app/cim/dao/model/EntranceGuardPoint.java | 64 + src/main/java/com/tairui/app/cim/dao/model/MajorHazardsPoint.java | 63 + 64 files changed, 2,977 insertions(+), 0 deletions(-) diff --git a/.mvn/wrapper/MavenWrapperDownloader.java b/.mvn/wrapper/MavenWrapperDownloader.java new file mode 100644 index 0000000..a45eb6b --- /dev/null +++ b/.mvn/wrapper/MavenWrapperDownloader.java @@ -0,0 +1,118 @@ +/* + * Copyright 2007-present the original author or authors. + * + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * https://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ + +import java.net.*; +import java.io.*; +import java.nio.channels.*; +import java.util.Properties; + +public class MavenWrapperDownloader { + + private static final String WRAPPER_VERSION = "0.5.6"; + /** + * Default URL to download the maven-wrapper.jar from, if no 'downloadUrl' is provided. + */ + private static final String DEFAULT_DOWNLOAD_URL = "https://repo.maven.apache.org/maven2/io/takari/maven-wrapper/" + + WRAPPER_VERSION + "/maven-wrapper-" + WRAPPER_VERSION + ".jar"; + + /** + * Path to the maven-wrapper.properties file, which might contain a downloadUrl property to + * use instead of the default one. + */ + private static final String MAVEN_WRAPPER_PROPERTIES_PATH = + ".mvn/wrapper/maven-wrapper.properties"; + + /** + * Path where the maven-wrapper.jar will be saved to. + */ + private static final String MAVEN_WRAPPER_JAR_PATH = + ".mvn/wrapper/maven-wrapper.jar"; + + /** + * Name of the property which should be used to override the default download url for the wrapper. + */ + private static final String PROPERTY_NAME_WRAPPER_URL = "wrapperUrl"; + + public static void main(String args[]) { + System.out.println("- Downloader started"); + File baseDirectory = new File(args[0]); + System.out.println("- Using base directory: " + baseDirectory.getAbsolutePath()); + + // If the maven-wrapper.properties exists, read it and check if it contains a custom + // wrapperUrl parameter. + File mavenWrapperPropertyFile = new File(baseDirectory, MAVEN_WRAPPER_PROPERTIES_PATH); + String url = DEFAULT_DOWNLOAD_URL; + if (mavenWrapperPropertyFile.exists()) { + FileInputStream mavenWrapperPropertyFileInputStream = null; + try { + mavenWrapperPropertyFileInputStream = new FileInputStream(mavenWrapperPropertyFile); + Properties mavenWrapperProperties = new Properties(); + mavenWrapperProperties.load(mavenWrapperPropertyFileInputStream); + url = mavenWrapperProperties.getProperty(PROPERTY_NAME_WRAPPER_URL, url); + } catch (IOException e) { + System.out.println("- ERROR loading '" + MAVEN_WRAPPER_PROPERTIES_PATH + "'"); + } finally { + try { + if (mavenWrapperPropertyFileInputStream != null) { + mavenWrapperPropertyFileInputStream.close(); + } + } catch (IOException e) { + // Ignore ... + } + } + } + System.out.println("- Downloading from: " + url); + + File outputFile = new File(baseDirectory.getAbsolutePath(), MAVEN_WRAPPER_JAR_PATH); + if (!outputFile.getParentFile().exists()) { + if (!outputFile.getParentFile().mkdirs()) { + System.out.println( + "- ERROR creating output directory '" + outputFile.getParentFile().getAbsolutePath() + "'"); + } + } + System.out.println("- Downloading to: " + outputFile.getAbsolutePath()); + try { + downloadFileFromURL(url, outputFile); + System.out.println("Done"); + System.exit(0); + } catch (Throwable e) { + System.out.println("- Error downloading"); + e.printStackTrace(); + System.exit(1); + } + } + + private static void downloadFileFromURL(String urlString, File destination) throws Exception { + if (System.getenv("MVNW_USERNAME") != null && System.getenv("MVNW_PASSWORD") != null) { + String username = System.getenv("MVNW_USERNAME"); + char[] password = System.getenv("MVNW_PASSWORD").toCharArray(); + Authenticator.setDefault(new Authenticator() { + @Override + protected PasswordAuthentication getPasswordAuthentication() { + return new PasswordAuthentication(username, password); + } + }); + } + URL website = new URL(urlString); + ReadableByteChannel rbc; + rbc = Channels.newChannel(website.openStream()); + FileOutputStream fos = new FileOutputStream(destination); + fos.getChannel().transferFrom(rbc, 0, Long.MAX_VALUE); + fos.close(); + rbc.close(); + } + +} diff --git a/.mvn/wrapper/maven-wrapper.jar b/.mvn/wrapper/maven-wrapper.jar new file mode 100644 index 0000000..2cc7d4a --- /dev/null +++ b/.mvn/wrapper/maven-wrapper.jar Binary files differ diff --git a/.mvn/wrapper/maven-wrapper.properties b/.mvn/wrapper/maven-wrapper.properties new file mode 100644 index 0000000..642d572 --- /dev/null +++ b/.mvn/wrapper/maven-wrapper.properties @@ -0,0 +1,2 @@ +distributionUrl=https://repo.maven.apache.org/maven2/org/apache/maven/apache-maven/3.6.3/apache-maven-3.6.3-bin.zip +wrapperUrl=https://repo.maven.apache.org/maven2/io/takari/maven-wrapper/0.5.6/maven-wrapper-0.5.6.jar diff --git a/src/main/java/com/http/HttpResult.java b/src/main/java/com/http/HttpResult.java new file mode 100644 index 0000000..5186a9f --- /dev/null +++ b/src/main/java/com/http/HttpResult.java @@ -0,0 +1,69 @@ +package com.http; + +/** + * HTTP缁撴灉灏佽 + * @author Louis + * @date Oct 29, 2018 + */ +public class HttpResult { + + private int code = 200; + private String msg; + private Object data; + + public static HttpResult error() { + return error(HttpStatus.SC_INTERNAL_SERVER_ERROR, "鏈煡寮傚父锛岃鑱旂郴绠$悊鍛�"); + } + + public static HttpResult error(String msg) { + return error(HttpStatus.SC_INTERNAL_SERVER_ERROR, msg); + } + + public static HttpResult error(int code, String msg) { + HttpResult r = new HttpResult(); + r.setCode(code); + r.setMsg(msg); + return r; + } + + public static HttpResult ok(String msg) { + HttpResult r = new HttpResult(); + r.setMsg(msg); + return r; + } + + public static HttpResult ok(Object data) { + HttpResult r = new HttpResult(); + r.setData(data); + return r; + } + + public static HttpResult ok() { + return new HttpResult(); + } + + public int getCode() { + return code; + } + + public void setCode(int code) { + this.code = code; + } + + public String getMsg() { + return msg; + } + + public void setMsg(String msg) { + this.msg = msg; + } + + public Object getData() { + return data; + } + + public void setData(Object data) { + this.data = data; + } + +} diff --git a/src/main/java/com/http/HttpStatus.java b/src/main/java/com/http/HttpStatus.java new file mode 100644 index 0000000..a4a9637 --- /dev/null +++ b/src/main/java/com/http/HttpStatus.java @@ -0,0 +1,149 @@ +package com.http; + +/** + * Constants enumerating the HTTP status codes. + * All status codes defined in RFC1945 (HTTP/1.0), RFC2616 (HTTP/1.1), and + * RFC2518 (WebDAV) are listed. + * + * @see StatusLine + * + * @since 4.0 + */ +public interface HttpStatus { + + // --- 1xx Informational --- + + /** {@code 100 Continue} (HTTP/1.1 - RFC 2616) */ + public static final int SC_CONTINUE = 100; + /** {@code 101 Switching Protocols} (HTTP/1.1 - RFC 2616)*/ + public static final int SC_SWITCHING_PROTOCOLS = 101; + /** {@code 102 Processing} (WebDAV - RFC 2518) */ + public static final int SC_PROCESSING = 102; + + // --- 2xx Success --- + + /** {@code 200 OK} (HTTP/1.0 - RFC 1945) */ + public static final int SC_OK = 200; + /** {@code 201 Created} (HTTP/1.0 - RFC 1945) */ + public static final int SC_CREATED = 201; + /** {@code 202 Accepted} (HTTP/1.0 - RFC 1945) */ + public static final int SC_ACCEPTED = 202; + /** {@code 203 Non Authoritative Information} (HTTP/1.1 - RFC 2616) */ + public static final int SC_NON_AUTHORITATIVE_INFORMATION = 203; + /** {@code 204 No Content} (HTTP/1.0 - RFC 1945) */ + public static final int SC_NO_CONTENT = 204; + /** {@code 205 Reset Content} (HTTP/1.1 - RFC 2616) */ + public static final int SC_RESET_CONTENT = 205; + /** {@code 206 Partial Content} (HTTP/1.1 - RFC 2616) */ + public static final int SC_PARTIAL_CONTENT = 206; + /** + * {@code 207 Multi-Status} (WebDAV - RFC 2518) + * or + * {@code 207 Partial Update OK} (HTTP/1.1 - draft-ietf-http-v11-spec-rev-01?) + */ + public static final int SC_MULTI_STATUS = 207; + + // --- 3xx Redirection --- + + /** {@code 300 Mutliple Choices} (HTTP/1.1 - RFC 2616) */ + public static final int SC_MULTIPLE_CHOICES = 300; + /** {@code 301 Moved Permanently} (HTTP/1.0 - RFC 1945) */ + public static final int SC_MOVED_PERMANENTLY = 301; + /** {@code 302 Moved Temporarily} (Sometimes {@code Found}) (HTTP/1.0 - RFC 1945) */ + public static final int SC_MOVED_TEMPORARILY = 302; + /** {@code 303 See Other} (HTTP/1.1 - RFC 2616) */ + public static final int SC_SEE_OTHER = 303; + /** {@code 304 Not Modified} (HTTP/1.0 - RFC 1945) */ + public static final int SC_NOT_MODIFIED = 304; + /** {@code 305 Use Proxy} (HTTP/1.1 - RFC 2616) */ + public static final int SC_USE_PROXY = 305; + /** {@code 307 Temporary Redirect} (HTTP/1.1 - RFC 2616) */ + public static final int SC_TEMPORARY_REDIRECT = 307; + + // --- 4xx Client Error --- + + /** {@code 400 Bad Request} (HTTP/1.1 - RFC 2616) */ + public static final int SC_BAD_REQUEST = 400; + /** {@code 401 Unauthorized} (HTTP/1.0 - RFC 1945) */ + public static final int SC_UNAUTHORIZED = 401; + /** {@code 402 Payment Required} (HTTP/1.1 - RFC 2616) */ + public static final int SC_PAYMENT_REQUIRED = 402; + /** {@code 403 Forbidden} (HTTP/1.0 - RFC 1945) */ + public static final int SC_FORBIDDEN = 403; + /** {@code 404 Not Found} (HTTP/1.0 - RFC 1945) */ + public static final int SC_NOT_FOUND = 404; + /** {@code 405 Method Not Allowed} (HTTP/1.1 - RFC 2616) */ + public static final int SC_METHOD_NOT_ALLOWED = 405; + /** {@code 406 Not Acceptable} (HTTP/1.1 - RFC 2616) */ + public static final int SC_NOT_ACCEPTABLE = 406; + /** {@code 407 Proxy Authentication Required} (HTTP/1.1 - RFC 2616)*/ + public static final int SC_PROXY_AUTHENTICATION_REQUIRED = 407; + /** {@code 408 Request Timeout} (HTTP/1.1 - RFC 2616) */ + public static final int SC_REQUEST_TIMEOUT = 408; + /** {@code 409 Conflict} (HTTP/1.1 - RFC 2616) */ + public static final int SC_CONFLICT = 409; + /** {@code 410 Gone} (HTTP/1.1 - RFC 2616) */ + public static final int SC_GONE = 410; + /** {@code 411 Length Required} (HTTP/1.1 - RFC 2616) */ + public static final int SC_LENGTH_REQUIRED = 411; + /** {@code 412 Precondition Failed} (HTTP/1.1 - RFC 2616) */ + public static final int SC_PRECONDITION_FAILED = 412; + /** {@code 413 Request Entity Too Large} (HTTP/1.1 - RFC 2616) */ + public static final int SC_REQUEST_TOO_LONG = 413; + /** {@code 414 Request-URI Too Long} (HTTP/1.1 - RFC 2616) */ + public static final int SC_REQUEST_URI_TOO_LONG = 414; + /** {@code 415 Unsupported Media Type} (HTTP/1.1 - RFC 2616) */ + public static final int SC_UNSUPPORTED_MEDIA_TYPE = 415; + /** {@code 416 Requested Range Not Satisfiable} (HTTP/1.1 - RFC 2616) */ + public static final int SC_REQUESTED_RANGE_NOT_SATISFIABLE = 416; + /** {@code 417 Expectation Failed} (HTTP/1.1 - RFC 2616) */ + public static final int SC_EXPECTATION_FAILED = 417; + + /** + * Static constant for a 418 error. + * {@code 418 Unprocessable Entity} (WebDAV drafts?) + * or {@code 418 Reauthentication Required} (HTTP/1.1 drafts?) + */ + // not used + // public static final int SC_UNPROCESSABLE_ENTITY = 418; + + /** + * Static constant for a 419 error. + * {@code 419 Insufficient Space on Resource} + * (WebDAV - draft-ietf-webdav-protocol-05?) + * or {@code 419 Proxy Reauthentication Required} + * (HTTP/1.1 drafts?) + */ + public static final int SC_INSUFFICIENT_SPACE_ON_RESOURCE = 419; + /** + * Static constant for a 420 error. + * {@code 420 Method Failure} + * (WebDAV - draft-ietf-webdav-protocol-05?) + */ + public static final int SC_METHOD_FAILURE = 420; + /** {@code 422 Unprocessable Entity} (WebDAV - RFC 2518) */ + public static final int SC_UNPROCESSABLE_ENTITY = 422; + /** {@code 423 Locked} (WebDAV - RFC 2518) */ + public static final int SC_LOCKED = 423; + /** {@code 424 Failed Dependency} (WebDAV - RFC 2518) */ + public static final int SC_FAILED_DEPENDENCY = 424; + + // --- 5xx Server Error --- + + /** {@code 500 Server Error} (HTTP/1.0 - RFC 1945) */ + public static final int SC_INTERNAL_SERVER_ERROR = 500; + /** {@code 501 Not Implemented} (HTTP/1.0 - RFC 1945) */ + public static final int SC_NOT_IMPLEMENTED = 501; + /** {@code 502 Bad Gateway} (HTTP/1.0 - RFC 1945) */ + public static final int SC_BAD_GATEWAY = 502; + /** {@code 503 Service Unavailable} (HTTP/1.0 - RFC 1945) */ + public static final int SC_SERVICE_UNAVAILABLE = 503; + /** {@code 504 Gateway Timeout} (HTTP/1.1 - RFC 2616) */ + public static final int SC_GATEWAY_TIMEOUT = 504; + /** {@code 505 HTTP Version Not Supported} (HTTP/1.1 - RFC 2616) */ + public static final int SC_HTTP_VERSION_NOT_SUPPORTED = 505; + + /** {@code 507 Insufficient Storage} (WebDAV - RFC 2518) */ + public static final int SC_INSUFFICIENT_STORAGE = 507; + +} diff --git a/src/main/java/com/http/Swagger3Config.java b/src/main/java/com/http/Swagger3Config.java new file mode 100644 index 0000000..f41ee21 --- /dev/null +++ b/src/main/java/com/http/Swagger3Config.java @@ -0,0 +1,39 @@ +package com.http; + +import org.springframework.context.annotation.Bean; +import org.springframework.context.annotation.Configuration; +import springfox.documentation.builders.ApiInfoBuilder; +import springfox.documentation.builders.PathSelectors; +import springfox.documentation.builders.RequestHandlerSelectors; +import springfox.documentation.service.ApiInfo; + +import springfox.documentation.spi.DocumentationType; +import springfox.documentation.spring.web.plugins.Docket; +import springfox.documentation.swagger2.annotations.EnableSwagger2; + +@Configuration + +public class Swagger3Config { + + @Bean + public Docket buildDocket() { + return new Docket(DocumentationType.SWAGGER_2) + .apiInfo(apiInfo())//璋冪敤涓嬮潰apiInfo()鏂规硶 + .select() + //Controller鎵�鍦ㄨ矾寰� + .apis(RequestHandlerSelectors.basePackage("com.cim.controller")) + .paths(PathSelectors.any()) + .build(); + + } + + public ApiInfo apiInfo() { + return new ApiInfoBuilder() + .title("springboot缁撳悎swagger2鏋勫缓Restful API") + .description("杩欐槸涓�涓猻wagger2灏忓瀷demo") + .termsOfServiceUrl("www.baidu.com") + .version("0.0.1") + .build(); + + } +} diff --git a/src/main/java/com/tairui/app/DemoApplication.java b/src/main/java/com/tairui/app/DemoApplication.java new file mode 100644 index 0000000..11102f3 --- /dev/null +++ b/src/main/java/com/tairui/app/DemoApplication.java @@ -0,0 +1,16 @@ +package com.tairui.app; + +import org.springframework.boot.SpringApplication; +import org.springframework.boot.autoconfigure.SpringBootApplication; +import springfox.documentation.swagger2.annotations.EnableSwagger2; + + +@SpringBootApplication +@EnableSwagger2 +public class DemoApplication { + + public static void main(String[] args) { + SpringApplication.run(DemoApplication.class, args); + } + +} diff --git a/src/main/java/com/tairui/app/cim/config/MyBatisPlusConfig.java b/src/main/java/com/tairui/app/cim/config/MyBatisPlusConfig.java new file mode 100644 index 0000000..8f0f729 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/config/MyBatisPlusConfig.java @@ -0,0 +1,16 @@ +package com.tairui.app.cim.config; + +import com.github.pagehelper.PageHelper; +import org.springframework.context.annotation.Bean; +import org.springframework.context.annotation.Configuration; + +@Configuration +public class MyBatisPlusConfig { + + @Bean + public PageHelper pageHelper() { + PageHelper pageHelper = new PageHelper(); + + return pageHelper; + } +} diff --git a/src/main/java/com/tairui/app/cim/controller/BusDeviceMainController.java b/src/main/java/com/tairui/app/cim/controller/BusDeviceMainController.java new file mode 100644 index 0000000..3148010 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/controller/BusDeviceMainController.java @@ -0,0 +1,106 @@ +package com.tairui.app.cim.controller; + + +import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; +import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.tairui.app.cim.dao.model.BusDeviceMain; +import com.tairui.app.cim.mapper.BusDeviceMainMapper; +import com.tairui.app.cim.service.IBusDeviceMainService; +import com.github.pagehelper.PageHelper; +import com.github.pagehelper.PageInfo; +import com.http.HttpResult; +import io.swagger.annotations.ApiOperation; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.web.bind.annotation.*; + +import java.util.List; + + +/** + * <p> + * 鍓嶇鎺у埗鍣� + * </p> + * + * @author yw + * @since 2022-05-21 + */ + + +@RestController +@RequestMapping("/cim/busDeviceMain") +public class BusDeviceMainController { + + @Autowired + private BusDeviceMainMapper busDeviceMainMapper; + +@Autowired +IBusDeviceMainService iBusDeviceMainService ; + + + + @GetMapping("/queryByID") + public HttpResult queryByID(long id ){ + + return HttpResult.ok(busDeviceMainMapper.selectById(id)); + } + + @GetMapping("/queryByModelID") + public HttpResult queryByModelID(String model_id ){ + QueryWrapper queryWrapper = new QueryWrapper(); + queryWrapper.eq("model_id",model_id); + return HttpResult.ok(iBusDeviceMainService.list(queryWrapper)); + } + + @GetMapping("/list") + @ApiOperation(value = "鍒楄〃",notes = "鍒嗛〉鍒楀嚭鎵�鏈�") + public HttpResult list(@RequestParam(name="pageNo", defaultValue="1") Integer pageNo, + @RequestParam(name="pageSize", defaultValue="10") Integer pageSize){ + + PageHelper.startPage(pageNo,pageSize); + List<BusDeviceMain> list = busDeviceMainMapper.listPage(); + PageInfo<BusDeviceMain> page = new PageInfo<>(list); + + + return HttpResult.ok(page); + } + + @GetMapping("/listPage") + public HttpResult listPage(String status,String name, @RequestParam(name="pageNo", defaultValue="1") Integer pageNo, + @RequestParam(name="pageSize", defaultValue="10") Integer pageSize){ + + LambdaQueryWrapper<BusDeviceMain> query = new LambdaQueryWrapper<>(); + + //澧炲姞kind鏉′欢鏌ヨ + if( status != null ){ + if( !status.equals("2")) + query.eq(BusDeviceMain::getStatus,Integer.parseInt(status)); + } + //else 鏌ヨ鍏ㄩ儴 + if( name != null && name.length() > 0) + query.like(BusDeviceMain::getUnitArea,name); + + + Page<BusDeviceMain> page = new Page<BusDeviceMain>(pageNo, pageSize); + IPage<BusDeviceMain> p = busDeviceMainMapper.selectPage(page, query); + + return HttpResult.ok(p); + } + + @PostMapping("/add") + public HttpResult add(@RequestBody BusDeviceMain busDeviceMain){ + return HttpResult.ok(busDeviceMainMapper.insert(busDeviceMain)); + } + + @PostMapping("/update") + public HttpResult update(@RequestBody BusDeviceMain busDeviceMain){ + return HttpResult.ok(busDeviceMainMapper.updateById(busDeviceMain)); + } + + @GetMapping("/delete") + public HttpResult delet(@RequestBody BusDeviceMain busDeviceMain){ + + return HttpResult.ok(busDeviceMainMapper.deleteById(busDeviceMain.getBdmId())); + } +} diff --git a/src/main/java/com/tairui/app/cim/controller/BusProductionDeviceController.java b/src/main/java/com/tairui/app/cim/controller/BusProductionDeviceController.java new file mode 100644 index 0000000..c85bb2a --- /dev/null +++ b/src/main/java/com/tairui/app/cim/controller/BusProductionDeviceController.java @@ -0,0 +1,95 @@ +package com.tairui.app.cim.controller; + + +import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; +import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.tairui.app.cim.dao.model.BusProductionDevice; +import com.tairui.app.cim.mapper.BusProductionDeviceMapper; +import com.github.pagehelper.PageHelper; +import com.github.pagehelper.PageInfo; +import com.http.HttpResult; +import com.tairui.app.cim.service.IBusDeviceMainService; +import com.tairui.app.cim.service.IBusProductionDeviceService; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.web.bind.annotation.*; + +import java.util.List; + + +/** + * <p> + * 鍓嶇鎺у埗鍣� + * </p> + * + * @author yw + * @since 2022-05-21 + */ +@RestController +@RequestMapping("/cim/busProductionDevice") + +public class BusProductionDeviceController { + @Autowired + private BusProductionDeviceMapper busProductionDeviceMapper; + +@Autowired +private IBusProductionDeviceService iBusProductionDeviceService; + @GetMapping("/queryByID") + public HttpResult queryByID(long id ){ + + return HttpResult.ok(busProductionDeviceMapper.selectById(id)); + } + + @GetMapping("/queryByModelID") + public HttpResult queryByModelID(String model_id ){ + QueryWrapper queryWrapper = new QueryWrapper(); + queryWrapper.eq("model_id",model_id); + return HttpResult.ok(iBusProductionDeviceService.list(queryWrapper)); + } + @GetMapping("/list") + public HttpResult list(@RequestParam(name="pageNo", defaultValue="1") Integer pageNo, + @RequestParam(name="pageSize", defaultValue="10") Integer pageSize){ + PageHelper.startPage(pageNo,pageSize); + List<BusProductionDevice> list = busProductionDeviceMapper.listPage(); + PageInfo<BusProductionDevice> page = new PageInfo<>(list); + + + return HttpResult.ok(page); + } + + @GetMapping("/listPage") + public HttpResult listPage(String status, @RequestParam(name="pageNo", defaultValue="1") Integer pageNo, + @RequestParam(name="pageSize", defaultValue="10") Integer pageSize){ + + LambdaQueryWrapper<BusProductionDevice> query = new LambdaQueryWrapper<>(); + + //澧炲姞kind鏉′欢鏌ヨ + if( status != null ){ + if( !status.equals("2")) + query.eq(BusProductionDevice::getStatus,Integer.parseInt(status)); + } + + Page<BusProductionDevice> page = new Page<BusProductionDevice>(pageNo, pageSize); + IPage<BusProductionDevice> p = busProductionDeviceMapper.selectPage(page, query); + + return HttpResult.ok(p); + } + + @PostMapping("/add") + public HttpResult add(@RequestBody BusProductionDevice busDeviceMain){ + return HttpResult.ok(busProductionDeviceMapper.insert(busDeviceMain)); + } + + @PostMapping("/update") + public HttpResult update(@RequestBody BusProductionDevice busDeviceMain){ + + return HttpResult.ok(busProductionDeviceMapper.updateById(busDeviceMain)); + } + + @GetMapping("/delete") + public HttpResult delet(@RequestBody BusProductionDevice busDeviceMain){ + + return HttpResult.ok(busProductionDeviceMapper.deleteById(busDeviceMain.getId())); + } +} diff --git a/src/main/java/com/tairui/app/cim/controller/GeomController.java b/src/main/java/com/tairui/app/cim/controller/GeomController.java new file mode 100644 index 0000000..c33fec7 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/controller/GeomController.java @@ -0,0 +1,206 @@ +package com.tairui.app.cim.controller; + +import com.tairui.app.cim.dao.model.*; +import com.tairui.app.cim.mapper.*; +import com.http.HttpResult; +import com.vividsolutions.jts.geom.Coordinate; +import com.vividsolutions.jts.geom.Geometry; +import com.vividsolutions.jts.geom.GeometryFactory; +import com.vividsolutions.jts.geom.Point; +import io.swagger.annotations.ApiOperation; +import org.apache.ibatis.annotations.Param; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.web.bind.annotation.GetMapping; +import org.springframework.web.bind.annotation.RequestMapping; +import org.springframework.web.bind.annotation.RestController; + +import java.util.ArrayList; +import java.util.List; +import java.util.stream.Collectors; + +@RestController +@RequestMapping("/cim/geom") +public class GeomController { + + @Autowired + AlarmPointMapper alarmPointMapper ; + @Autowired + CameraMapper cameraMapper ; + @Autowired + PersonnelPointMapper personnelPointMapper ; + @Autowired + ProductionAreaMapper productionAreaMapper ; + @Autowired + ProductionUnitAreaMapper productionUnitAreaMapper ; + @Autowired + OperationAreaMapper operationAreaMapper ; + @Autowired + InspectionMapper inspectionMapper ; + + @Autowired + ElevationMapper elevationMapper ; + + + @Autowired + EmergencySuppliesPointMapper emergencySuppliesPointMapper; + @Autowired + EntranceGuardPointMapper entranceGuardPointMapper; + @Autowired + EvacuationPointMapper evacuationPointMapper ; + @Autowired + MajorHazardsPointMapper majorHazardsPointMapper ; + @Autowired + ToxicGasPointMapper toxicGasPointMapper; + @Autowired + FireEquipmentPointMapper fireEquipmentPointMapper; + @GetMapping("/queryByID") + @ApiOperation("table_name:alarm,camera,inspection,production,production_unit,operation," + + "toxic_gas_point,emergency_supplies_point,major_hazards_point,entrance_guard_point," + + "evacuation_point,fire_equipment_point") + public HttpResult queryByID(int gid ,String table_name ){ + + if( table_name.toLowerCase().equals("alarm")) return HttpResult.ok(alarmPointMapper.query(gid)); + if( table_name.toLowerCase().equals("camera")) return HttpResult.ok(cameraMapper.query(gid)); + if( table_name.toLowerCase().equals("personnel")) return HttpResult.ok(personnelPointMapper.query(gid)); + if( table_name.toLowerCase().equals("inspection")) return HttpResult.ok(inspectionMapper.query(gid)); + + if( table_name.toLowerCase().equals("production")) return HttpResult.ok(productionAreaMapper.query(gid)); + if( table_name.toLowerCase().equals("production_unit"))return HttpResult.ok(productionUnitAreaMapper.query(gid)); + if( table_name.toLowerCase().equals("operation")) return HttpResult.ok(operationAreaMapper.query(gid)); + + if( table_name.toLowerCase().equals("toxic_gas_point")) return HttpResult.ok(toxicGasPointMapper.query(gid)); + if( table_name.toLowerCase().equals("emergency_supplies_point")) return HttpResult.ok(emergencySuppliesPointMapper.query(gid)); + + if( table_name.toLowerCase().equals("major_hazards_point")) return HttpResult.ok(majorHazardsPointMapper.query(gid)); + if( table_name.toLowerCase().equals("entrance_guard_point"))return HttpResult.ok(entranceGuardPointMapper.query(gid)); + if( table_name.toLowerCase().equals("evacuation_point")) return HttpResult.ok(evacuationPointMapper.query(gid)); + if( table_name.toLowerCase().equals("fire_equipment_point")) return HttpResult.ok(fireEquipmentPointMapper.query(gid)); + + return HttpResult.error("鍙傛暟閿欒"); + } + + @GetMapping("/update") + public HttpResult update(int gid , String geom,String table_name){ + if( table_name.toLowerCase().equals("alarm")) { + AlarmPoint alarmPoint = alarmPointMapper.selectById(gid) ; + if( alarmPoint == null ) return HttpResult.error("璁板綍涓嶅瓨鍦紒"); + alarmPoint.setGeom(geom); + int ret = alarmPointMapper.updateById(alarmPoint); + return HttpResult.ok(ret); + } + if( table_name.toLowerCase().equals("camera")) { + CameraPoint alarmPoint = cameraMapper.selectById(gid) ; + if( alarmPoint == null ) return HttpResult.error("璁板綍涓嶅瓨鍦紒"); + alarmPoint.setGeom(geom); + int ret = cameraMapper.updateById(alarmPoint); + return HttpResult.ok(ret); + } + if( table_name.toLowerCase().equals("inspection")) { + Inspection alarmPoint =inspectionMapper .selectById(gid) ; + if( alarmPoint == null ) return HttpResult.error("璁板綍涓嶅瓨鍦紒"); + alarmPoint.setGeom(geom); + int ret = inspectionMapper.updateById(alarmPoint); + return HttpResult.ok(ret); + } + if( table_name.toLowerCase().equals("production")) { + ProductionArea alarmPoint =productionAreaMapper .selectById(gid) ; + if( alarmPoint == null ) return HttpResult.error("璁板綍涓嶅瓨鍦紒"); + alarmPoint.setGeom(geom); + int ret = productionAreaMapper.updateById(alarmPoint); + return HttpResult.ok(ret); + } + if( table_name.toLowerCase().equals("production_unit")){ + ProductionUnitArea alarmPoint =productionUnitAreaMapper .selectById(gid) ; + if( alarmPoint == null ) return HttpResult.error("璁板綍涓嶅瓨鍦紒"); + alarmPoint.setGeom(geom); + int ret = productionUnitAreaMapper.updateById(alarmPoint); + return HttpResult.ok(ret); + } + if( table_name.toLowerCase().equals("operation")) { + OperationArea alarmPoint =operationAreaMapper .selectById(gid) ; + if( alarmPoint == null ) return HttpResult.error("璁板綍涓嶅瓨鍦紒"); + alarmPoint.setGeom(geom); + int ret = operationAreaMapper.updateById(alarmPoint); + return HttpResult.ok(ret); + } + + + + if( table_name.toLowerCase().equals("toxic_gas_point")){ + ToxicGasPoint alarmPoint =toxicGasPointMapper.selectById(gid) ; + if( alarmPoint == null ) return HttpResult.error("璁板綍涓嶅瓨鍦紒"); + alarmPoint.setGeom(geom); + int ret = toxicGasPointMapper.updateById(alarmPoint); + return HttpResult.ok(ret); + } + if( table_name.toLowerCase().equals("emergency_supplies_point")) { + EmergencySuppliesPoint alarmPoint =emergencySuppliesPointMapper .selectById(gid) ; + if( alarmPoint == null ) return HttpResult.error("璁板綍涓嶅瓨鍦紒"); + alarmPoint.setGeom(geom); + int ret = emergencySuppliesPointMapper.updateById(alarmPoint); + return HttpResult.ok(ret); + } + if( table_name.toLowerCase().equals("major_hazards_point")){ + MajorHazardsPoint alarmPoint =majorHazardsPointMapper .selectById(gid) ; + if( alarmPoint == null ) return HttpResult.error("璁板綍涓嶅瓨鍦紒"); + alarmPoint.setGeom(geom); + int ret = majorHazardsPointMapper.updateById(alarmPoint); + return HttpResult.ok(ret); + } + if( table_name.toLowerCase().equals("entrance_guard_point")) { + EntranceGuardPoint alarmPoint =entranceGuardPointMapper .selectById(gid) ; + if( alarmPoint == null ) return HttpResult.error("璁板綍涓嶅瓨鍦紒"); + alarmPoint.setGeom(geom); + int ret = entranceGuardPointMapper.updateById(alarmPoint); + return HttpResult.ok(ret); + } + if( table_name.toLowerCase().equals("evacuation_point")){ + EvacuationPoint alarmPoint =evacuationPointMapper .selectById(gid) ; + if( alarmPoint == null ) return HttpResult.error("璁板綍涓嶅瓨鍦紒"); + alarmPoint.setGeom(geom); + int ret = evacuationPointMapper.updateById(alarmPoint); + return HttpResult.ok(ret); + } + if( table_name.toLowerCase().equals("fire_equipment_point")){ + FireEquipmentPoint alarmPoint =fireEquipmentPointMapper .selectById(gid) ; + if( alarmPoint == null ) return HttpResult.error("璁板綍涓嶅瓨鍦紒"); + alarmPoint.setGeom(geom); + int ret = fireEquipmentPointMapper.updateById(alarmPoint); + return HttpResult.ok(ret); + } + + return HttpResult.error("鍙傛暟閿欒"); + } + + /** + * 澶勭悊杩囩▼锛屾牴鎹ゼ灞傚緱鍒伴潰鏁版嵁锛屽垽鏂偣鏄惁鍦ㄩ潰涓婏紝濡傛灉鍦紝杩斿洖 x,y 锛宑oor_z + * 濡傛灉涓嶅湪闈笂锛岃幏寰楁渶杩戠殑闈紝杩斿洖 cen_x cen_y coor_z + * @param x + * @param y + * @param + * @return + */ + @GetMapping("/queryElevation") + public HttpResult queryElevation(String floor_num,double x , double y){ + List<Elevation> list = new ArrayList<>(); + //涓�灞備笉鏌ヨ + if( floor_num.equals("1")){ + Elevation e = new Elevation(); + e.setCenx(x); + e.setCeny(y); + e.setHigh("0"); + list.add(e); + return HttpResult.ok(list ); + + } + list = elevationMapper.queryFloor(x,y,floor_num) ; + if( list == null || list.size() == 0 ){ + list = elevationMapper.queryMinDistance(x,y,floor_num); + return (HttpResult.ok(list));//.stream().filter(p->{System.out.println(p.getCentX());p.setCen_x(p.getCenx());p.setCen_y(p.getCeny());return true;}).collect(Collectors.toList()))); + }else{ + return HttpResult.ok( list.stream().filter(p->{p.setCenx(x);p.setCeny(y);return true;}).collect(Collectors.toList())); + } + + + } +} diff --git a/src/main/java/com/tairui/app/cim/controller/ProductionAreaController.java b/src/main/java/com/tairui/app/cim/controller/ProductionAreaController.java new file mode 100644 index 0000000..ae9810d --- /dev/null +++ b/src/main/java/com/tairui/app/cim/controller/ProductionAreaController.java @@ -0,0 +1,82 @@ +package com.tairui.app.cim.controller; + +import com.alibaba.fastjson.JSON; +import com.alibaba.fastjson.JSONArray; +import com.alibaba.fastjson.JSONObject; +import com.tairui.app.cim.dao.model.ProductionArea; +import com.tairui.app.cim.mapper.ProductionAreaMapper; +import com.tairui.app.cim.service.IProductionAreaService; +import com.tairui.app.cim.util.GeoJsonUtil; +import com.github.pagehelper.PageHelper; +import com.github.pagehelper.PageInfo; +import com.http.HttpResult; +import com.vividsolutions.jts.geom.Geometry; +import com.vividsolutions.jts.geom.GeometryFactory; +import com.vividsolutions.jts.io.ParseException; +import com.vividsolutions.jts.io.WKTReader; +import io.swagger.annotations.ApiOperation; +import org.geotools.geometry.jts.JTSFactoryFinder; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.web.bind.annotation.*; + +import java.util.List; + +@RestController +@RequestMapping("/cim/productionArea") +public class ProductionAreaController { + + @Autowired + IProductionAreaService iProductionAreaService; + @Autowired + ProductionAreaMapper productionAreaMapper; + + private GeometryFactory geometryFactory = JTSFactoryFinder.getGeometryFactory( null ); + private WKTReader reader = new WKTReader( geometryFactory ); + @GetMapping("/list") + @ApiOperation(value = "鍒楄〃",notes = "鍒嗛〉鍒楀嚭鎵�鏈�") + public HttpResult list(@RequestParam(name="pageNo", defaultValue="1") Integer pageNo, + @RequestParam(name="pageSize", defaultValue="10") Integer pageSize){ + + PageHelper.startPage(pageNo,pageSize); + List<ProductionArea> list = productionAreaMapper.listPage(); + PageInfo<ProductionArea> page = new PageInfo<>(list); + + + return HttpResult.ok(page); + } + + @GetMapping("/listArea") + @ApiOperation(value = "鍒楄〃鍖哄垝鍚嶇О",notes = "鍒嗛〉鍒楀嚭鎵�鏈�") + public HttpResult listArea(@RequestParam(name="pageNo", defaultValue="1") Integer pageNo, + @RequestParam(name="pageSize", defaultValue="10") Integer pageSize){ + + PageHelper.startPage(pageNo,pageSize); + List<String> list = productionAreaMapper.listAreaName(); + PageInfo<String> page = new PageInfo<>(list); + + + return HttpResult.ok(page); + } + @PostMapping("/add") + @ApiOperation(value = "鍒楄〃",notes = "鍒嗛〉鍒楀嚭鎵�鏈�") + public HttpResult add(@RequestBody String json) throws ParseException { + + JSONArray jsonArray = JSON.parseArray(json); + + for(Object obj:jsonArray){ + JSON jsonObject = (JSON)obj; + + String geom =((JSONObject)obj).getString("geometry"); + Geometry geometry = GeoJsonUtil.getGeometryFromGeoJSON(geom); + JSONObject jsonObject1 = JSON.parseObject(((JSONObject)obj).getString("properties")); + + ProductionArea productionArea = JSON.parseObject(jsonObject.toString(),ProductionArea.class); + productionArea.setGeom(geometry.toText()); + + productionAreaMapper.insert(productionArea); + } + + + return HttpResult.ok(); + } +} diff --git a/src/main/java/com/tairui/app/cim/dao/model/AlarmPoint.java b/src/main/java/com/tairui/app/cim/dao/model/AlarmPoint.java new file mode 100644 index 0000000..fb99d8f --- /dev/null +++ b/src/main/java/com/tairui/app/cim/dao/model/AlarmPoint.java @@ -0,0 +1,25 @@ +package com.tairui.app.cim.dao.model; + +import com.baomidou.mybatisplus.annotation.TableField; +import com.baomidou.mybatisplus.annotation.TableId; +import com.baomidou.mybatisplus.annotation.TableName; +import com.tairui.app.cim.util.MyGeometryHandler; +import lombok.Data; +import lombok.EqualsAndHashCode; +import lombok.experimental.Accessors; + +@Data +@EqualsAndHashCode(callSuper = false) +@Accessors(chain = true) +@TableName("alarm_point") +public class AlarmPoint { + @TableField("gid") + @TableId + private long gid; + + @TableField(typeHandler = MyGeometryHandler.class) + private String geom; + + @TableField(exist=false) + private String gwkt; +} diff --git a/src/main/java/com/tairui/app/cim/dao/model/BusDeviceMain.java b/src/main/java/com/tairui/app/cim/dao/model/BusDeviceMain.java new file mode 100644 index 0000000..befadc9 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/dao/model/BusDeviceMain.java @@ -0,0 +1,115 @@ +package com.tairui.app.cim.dao.model; + +import java.time.LocalDateTime; +import com.baomidou.mybatisplus.annotation.TableField; +import java.io.Serializable; + +import com.baomidou.mybatisplus.annotation.TableId; +import lombok.Data; +import lombok.EqualsAndHashCode; +import lombok.experimental.Accessors; + +/** + * <p> + * + * </p> + * + * @author yw + * @since 2022-05-21 + */ +@Data +@EqualsAndHashCode(callSuper = false) +@Accessors(chain = true) +public class BusDeviceMain implements Serializable { + + private static final long serialVersionUID = 1L; + @TableId + @TableField("bdm_id") + private Long bdmId; + + @TableField("device_no") + private String deviceNo; + + @TableField("device_name") + private String bdmDeviceName; + + @TableField("bdm_type_first") + private Integer bdmTypeFirst; + + @TableField("bdm_type_second") + private Integer bdmTypeSecond; + + @TableField("bdm_type_third") + private Integer bdmTypeThird; + + @TableField("bdm_area") + private Long bdmArea; + + @TableField("unit_area") + private String unitArea; + + @TableField("bdm_location") + private String bdmLocation; + + @TableField("bdm_department") + private String bdmDepartment; + + @TableField("bdm_purpose") + private String bdmPurpose; + + @TableField("bdm_specification") + private String bdmSpecification; + + @TableField("bdm_manufacturer") + private String bdmManufacturer; + + @TableField("bdm_production_date") + private String bdmProductionDate; + + @TableField("bdm_first_use_date") + private String bdmFirstUseDate; + + @TableField("bdm_newest_use_date") + private String bdmNewestUseDate; + + @TableField("bdm_newest_valid_date") + private String bdmNewestValidDate; + + @TableField("bdm_use_state") + private String bdmUseState; + + @TableField("bdm_device_state") + private String bdmDeviceState; + + @TableField("bdm_remark") + private String bdmRemark; + + @TableField("bdm_map_point_flag") + private Integer bdmMapPointFlag; + + @TableField("bdm_deleted_flag") + private Integer bdmDeletedFlag; + + @TableField("create_time") + private LocalDateTime createTime; + + @TableField("create_user") + private String createUser; + + @TableField("update_time") + private LocalDateTime updateTime; + + @TableField("update_user") + private String updateUser; + + @TableField("bdm_type") + private String bdmType; + + @TableField("model_id") + private String modelId; + + @TableField("status") + private Integer status; + + +} diff --git a/src/main/java/com/tairui/app/cim/dao/model/BusProductionDevice.java b/src/main/java/com/tairui/app/cim/dao/model/BusProductionDevice.java new file mode 100644 index 0000000..071a598 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/dao/model/BusProductionDevice.java @@ -0,0 +1,154 @@ +package com.tairui.app.cim.dao.model; + +import java.time.LocalDateTime; +import com.baomidou.mybatisplus.annotation.TableField; +import java.io.Serializable; + +import com.baomidou.mybatisplus.annotation.TableId; +import com.fasterxml.jackson.databind.annotation.JsonSerialize; +import com.fasterxml.jackson.databind.ser.std.ToStringSerializer; +import lombok.Data; +import lombok.EqualsAndHashCode; +import lombok.experimental.Accessors; + +/** + * <p> + * + * </p> + * + * @author yw + * @since 2022-05-21 + */ +@Data +@EqualsAndHashCode(callSuper = false) +@Accessors(chain = true) +public class BusProductionDevice implements Serializable { + + private static final long serialVersionUID = 1L; + + @TableId() + @JsonSerialize(using = ToStringSerializer.class) + private long id; + + @TableField("device_no") + private String deviceNo; + + @TableField("device_name") + private String deviceName; + + @TableField("dept_id") + private long deptId; + + @TableField("deivce_type") + private int deivceType; + + @TableField("sub_device_type") + private long subDeviceType; + + @TableField("device_trand") + private int deviceTrand; + + @TableField("region_id") + private long regionId; + + @TableField("tag_number") + private String tagNumber; + + @TableField("state") + private int state; + + @TableField("factory_no") + private String factoryNo; + + @TableField("special") + private int special; + + @TableField("equipment") + private Long equipment; + + @TableField("responsibility_by") + private long responsibilityBy; + + @TableField("model_id") + private String modelId; + + @TableField("video_coding") + private int videoCoding; + + @TableField("device_channel") + private String deviceChannel; + + @TableField("bitstream_type") + private int bitstreamType; + + @TableField("monitor_type") + private int monitorType; + + @TableField("videotape_type") + private int videotapeType; + + @TableField("in_out_type") + private int inOutType; + + @TableField("device_model") + private String deviceModel; + + @TableField("location") + private String location; + + @TableField("purpose") + private String purpose; + + @TableField("device_account") + private String deviceAccount; + + @TableField("device_password") + private String devicePassword; + + @TableField("ip") + private String ip; + + @TableField("prot") + private int prot; + + @TableField("del_flag") + private int delFlag; + + @TableField("create_time") + private LocalDateTime createTime; + + @TableField("update_time") + private LocalDateTime updateTime; + + @TableField("bind_location") + private String bindLocation; + + @TableField("bind_state") + private int bindState; + + @TableField("channel_state") + private int channelState; + + @TableField("video_address") + private String videoAddress; + + @TableField("unit") + private String unit; + + @TableField("infra_red_channel") + private String infraRedChannel; + + @TableField("status") + private int status; + + @TableField("unit_area") + private String unitArea; + + @TableField("create_user") + private String createUser; + + @TableField("update_user") + private String updateUser; + + +} diff --git a/src/main/java/com/tairui/app/cim/dao/model/CameraPoint.java b/src/main/java/com/tairui/app/cim/dao/model/CameraPoint.java new file mode 100644 index 0000000..abd8ac1 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/dao/model/CameraPoint.java @@ -0,0 +1,25 @@ +package com.tairui.app.cim.dao.model; + +import com.baomidou.mybatisplus.annotation.TableField; +import com.baomidou.mybatisplus.annotation.TableId; +import com.baomidou.mybatisplus.annotation.TableName; +import com.tairui.app.cim.util.MyGeometryHandler; +import lombok.Data; +import lombok.EqualsAndHashCode; +import lombok.experimental.Accessors; + +@Data +@EqualsAndHashCode(callSuper = false) +@Accessors(chain = true) +@TableName("camera_point") +public class CameraPoint { + @TableField("gid") + @TableId + private long gid; + + @TableField(typeHandler = MyGeometryHandler.class) + private String geom; + + @TableField(exist=false) + private String gwkt; +} diff --git a/src/main/java/com/tairui/app/cim/dao/model/Elevation.java b/src/main/java/com/tairui/app/cim/dao/model/Elevation.java new file mode 100644 index 0000000..8eff59e --- /dev/null +++ b/src/main/java/com/tairui/app/cim/dao/model/Elevation.java @@ -0,0 +1,41 @@ +package com.tairui.app.cim.dao.model; + + +import com.baomidou.mybatisplus.annotation.TableField; +import com.baomidou.mybatisplus.annotation.TableId; +import com.baomidou.mybatisplus.annotation.TableName; +import com.tairui.app.cim.util.MyGeometryHandler; +import com.vividsolutions.jts.geom.Geometry; +import lombok.Data; +import lombok.EqualsAndHashCode; +import lombok.experimental.Accessors; + + +@Data +@EqualsAndHashCode(callSuper = false) +@Accessors(chain = true) +@TableName("elevation_correction") +public class Elevation { + @TableField("gid") + @TableId + private long gid; + + @TableField(typeHandler = MyGeometryHandler.class) + private String geom; + + @TableField(exist=false) + private String gwkt; + //涓嶅湪闈㈠唴鐐瑰鐞� + @TableField(exist=false) + private double cenx ; + @TableField(exist=false) + private double ceny ; + private String coor_z ; + private String name ; + private String floor_num ; + @TableField(exist=false) + private String high; + + + +} diff --git a/src/main/java/com/tairui/app/cim/dao/model/EmergencySuppliesPoint.java b/src/main/java/com/tairui/app/cim/dao/model/EmergencySuppliesPoint.java new file mode 100644 index 0000000..ca785ff --- /dev/null +++ b/src/main/java/com/tairui/app/cim/dao/model/EmergencySuppliesPoint.java @@ -0,0 +1,62 @@ +package com.tairui.app.cim.dao.model; + +import com.baomidou.mybatisplus.annotation.IdType; +import com.baomidou.mybatisplus.annotation.TableField; +import com.baomidou.mybatisplus.annotation.TableId; +import com.tairui.app.cim.util.MyGeometryHandler; +import io.swagger.annotations.ApiModel; +import lombok.Data; +import lombok.EqualsAndHashCode; + +import java.io.Serializable; +import java.math.BigDecimal; +import java.util.Date; + +/** + * <p> + * + * </p> + * + * @author hyy + * @since 2022-08-22 + */ +@Data +@EqualsAndHashCode(callSuper = false) +@ApiModel(value="EmergencySuppliesPoint瀵硅薄", description="") +public class EmergencySuppliesPoint implements Serializable { + + private static final long serialVersionUID=1L; + + @TableId(value = "gid", type = IdType.ASSIGN_ID) + private Integer gid; + + private String pointId; + + private String pointType; + + private String orgCode; + + private String pointName; + + private String createuser; + + private Date createtime; + + private String updateuser; + + private Date updatetime; + + private BigDecimal coorZ; + + private Integer status; + + private String remarks; + + @TableField(typeHandler = MyGeometryHandler.class) + private String geom; + + @TableField(exist=false) + private String gwkt; + + +} diff --git a/src/main/java/com/tairui/app/cim/dao/model/EntranceGuardPoint.java b/src/main/java/com/tairui/app/cim/dao/model/EntranceGuardPoint.java new file mode 100644 index 0000000..2a7dab4 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/dao/model/EntranceGuardPoint.java @@ -0,0 +1,64 @@ +package com.tairui.app.cim.dao.model; + +import com.baomidou.mybatisplus.annotation.IdType; +import com.baomidou.mybatisplus.annotation.TableField; +import com.baomidou.mybatisplus.annotation.TableId; +import com.tairui.app.cim.util.MyGeometryHandler; +import io.swagger.annotations.ApiModel; +import lombok.Data; +import lombok.EqualsAndHashCode; + +import java.io.Serializable; +import java.math.BigDecimal; +import java.util.Date; + +/** + * <p> + * + * </p> + * + * @author hyy + * @since 2022-08-22 + */ +@Data +@EqualsAndHashCode(callSuper = false) +@ApiModel(value="EntranceGuardPoint瀵硅薄", description="") +public class EntranceGuardPoint implements Serializable { + + private static final long serialVersionUID=1L; + + @TableId(value = "gid", type = IdType.ASSIGN_ID) + private Integer gid; + + private String pointId; + + private String pointType; + + private String orgCode; + + private String pointName; + + private String createuser; + + private Date createtime; + + private String updateuser; + + private Date updatetime; + + private BigDecimal coorZ; + + private BigDecimal status; + + private String remarks; + + private String bindKey; + + @TableField(typeHandler = MyGeometryHandler.class) + private String geom; + + @TableField(exist=false) + private String gwkt; + + +} diff --git a/src/main/java/com/tairui/app/cim/dao/model/EvacuationPoint.java b/src/main/java/com/tairui/app/cim/dao/model/EvacuationPoint.java new file mode 100644 index 0000000..fe6fb31 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/dao/model/EvacuationPoint.java @@ -0,0 +1,64 @@ +package com.tairui.app.cim.dao.model; + +import com.baomidou.mybatisplus.annotation.IdType; +import com.baomidou.mybatisplus.annotation.TableField; +import com.baomidou.mybatisplus.annotation.TableId; +import com.tairui.app.cim.util.MyGeometryHandler; +import io.swagger.annotations.ApiModel; +import lombok.Data; +import lombok.EqualsAndHashCode; + +import java.io.Serializable; +import java.math.BigDecimal; +import java.util.Date; + +/** + * <p> + * + * </p> + * + * @author hyy + * @since 2022-08-22 + */ +@Data +@EqualsAndHashCode(callSuper = false) +@ApiModel(value="EvacuationPoint瀵硅薄", description="") +public class EvacuationPoint implements Serializable { + + private static final long serialVersionUID=1L; + + @TableId(value = "gid", type = IdType.ASSIGN_ID) + private Integer gid; + + private String pointId; + + private String pointType; + + private String orgCode; + + private String pointName; + + private String createuser; + + private Date createtime; + + private String updateuser; + + private Date updatetime; + + private BigDecimal coorZ; + + private BigDecimal status; + + private String remarks; + + private String bindKey; + + @TableField(typeHandler = MyGeometryHandler.class) + private String geom; + + @TableField(exist=false) + private String gwkt; + + +} diff --git a/src/main/java/com/tairui/app/cim/dao/model/FireEquipmentPoint.java b/src/main/java/com/tairui/app/cim/dao/model/FireEquipmentPoint.java new file mode 100644 index 0000000..29cb91a --- /dev/null +++ b/src/main/java/com/tairui/app/cim/dao/model/FireEquipmentPoint.java @@ -0,0 +1,62 @@ +package com.tairui.app.cim.dao.model; + +import com.baomidou.mybatisplus.annotation.IdType; +import com.baomidou.mybatisplus.annotation.TableField; +import com.baomidou.mybatisplus.annotation.TableId; +import com.tairui.app.cim.util.MyGeometryHandler; +import io.swagger.annotations.ApiModel; +import lombok.Data; +import lombok.EqualsAndHashCode; + +import java.io.Serializable; +import java.math.BigDecimal; +import java.util.Date; + +/** + * <p> + * + * </p> + * + * @author hyy + * @since 2022-08-23 + */ +@Data +@EqualsAndHashCode(callSuper = false) +@ApiModel(value="FireEquipmentPoint瀵硅薄", description="") +public class FireEquipmentPoint implements Serializable { + + private static final long serialVersionUID=1L; + + @TableId(value = "gid", type = IdType.ASSIGN_ID) + private Integer gid; + + private String pointId; + + private String pointType; + + private String orgCode; + + private String pointName; + + private String createuser; + + private Date createtime; + + private String updateuser; + + private Date updatetime; + + private BigDecimal coorZ; + + private Integer status; + + private String remarks; + + @TableField(typeHandler = MyGeometryHandler.class) + private String geom; + + @TableField(exist=false) + private String gwkt; + + +} diff --git a/src/main/java/com/tairui/app/cim/dao/model/Inspection.java b/src/main/java/com/tairui/app/cim/dao/model/Inspection.java new file mode 100644 index 0000000..87a5924 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/dao/model/Inspection.java @@ -0,0 +1,25 @@ +package com.tairui.app.cim.dao.model; + +import com.baomidou.mybatisplus.annotation.TableField; +import com.baomidou.mybatisplus.annotation.TableId; +import com.baomidou.mybatisplus.annotation.TableName; +import com.tairui.app.cim.util.MyGeometryHandler; +import lombok.Data; +import lombok.EqualsAndHashCode; +import lombok.experimental.Accessors; + +@Data +@EqualsAndHashCode(callSuper = false) +@Accessors(chain = true) +@TableName("onsite_inspection_point") +public class Inspection { + @TableField("gid") + @TableId + private long gid; + + @TableField(typeHandler = MyGeometryHandler.class) + private String geom; + + @TableField(exist=false) + private String gwkt; +} \ No newline at end of file diff --git a/src/main/java/com/tairui/app/cim/dao/model/MajorHazardsPoint.java b/src/main/java/com/tairui/app/cim/dao/model/MajorHazardsPoint.java new file mode 100644 index 0000000..ac874d5 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/dao/model/MajorHazardsPoint.java @@ -0,0 +1,63 @@ +package com.tairui.app.cim.dao.model; + +import com.baomidou.mybatisplus.annotation.IdType; +import com.baomidou.mybatisplus.annotation.TableField; +import com.baomidou.mybatisplus.annotation.TableId; +import com.tairui.app.cim.util.MyGeometryHandler; +import io.swagger.annotations.ApiModel; +import lombok.Data; +import lombok.EqualsAndHashCode; + +import java.io.Serializable; +import java.math.BigDecimal; +import java.util.Date; + +/** + * <p> + * + * </p> + * + * @author hyy + * @since 2022-08-22 + */ +@Data +@EqualsAndHashCode(callSuper = false) +@ApiModel(value="MajorHazardsPoint瀵硅薄", description="") +public class MajorHazardsPoint implements Serializable { + + private static final long serialVersionUID=1L; + + @TableId(value = "gid", type = IdType.ASSIGN_ID) + private Integer gid; + + private String pointId; + + private String pointType; + + private String orgCode; + + private String pointName; + + private String createuser; + + private Date createtime; + + private String updateuser; + + private Date updatetime; + + private BigDecimal coorZ; + + private Integer status; + + private String remarks; + + + @TableField(typeHandler = MyGeometryHandler.class) + private String geom; + + @TableField(exist=false) + private String gwkt; + + +} diff --git a/src/main/java/com/tairui/app/cim/dao/model/OperationArea.java b/src/main/java/com/tairui/app/cim/dao/model/OperationArea.java new file mode 100644 index 0000000..38276f3 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/dao/model/OperationArea.java @@ -0,0 +1,28 @@ +package com.tairui.app.cim.dao.model; + +import com.baomidou.mybatisplus.annotation.TableField; +import com.baomidou.mybatisplus.annotation.TableId; +import com.baomidou.mybatisplus.annotation.TableName; +import com.tairui.app.cim.util.MyGeometryHandler; +import lombok.Data; +import lombok.EqualsAndHashCode; +import lombok.experimental.Accessors; + +import java.io.Serializable; + +@Data +@EqualsAndHashCode(callSuper = false) +@Accessors(chain = true) +@TableName("operation_area") +public class OperationArea implements Serializable { + + @TableField("gid") + @TableId + private long gid; + + @TableField(typeHandler = MyGeometryHandler.class) + private String geom; + + @TableField(exist=false) + private String gwkt; +} diff --git a/src/main/java/com/tairui/app/cim/dao/model/PersonnelPoint.java b/src/main/java/com/tairui/app/cim/dao/model/PersonnelPoint.java new file mode 100644 index 0000000..8e49211 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/dao/model/PersonnelPoint.java @@ -0,0 +1,25 @@ +package com.tairui.app.cim.dao.model; + +import com.baomidou.mybatisplus.annotation.TableField; +import com.baomidou.mybatisplus.annotation.TableId; +import com.baomidou.mybatisplus.annotation.TableName; +import com.tairui.app.cim.util.MyGeometryHandler; +import lombok.Data; +import lombok.EqualsAndHashCode; +import lombok.experimental.Accessors; + +@Data +@EqualsAndHashCode(callSuper = false) +@Accessors(chain = true) +@TableName("personnel_point") +public class PersonnelPoint { + @TableField("gid") + @TableId + private long gid; + + @TableField(typeHandler = MyGeometryHandler.class) + private String geom; + + @TableField(exist=false) + private String gwkt; +} diff --git a/src/main/java/com/tairui/app/cim/dao/model/ProductionArea.java b/src/main/java/com/tairui/app/cim/dao/model/ProductionArea.java new file mode 100644 index 0000000..cd2aa1b --- /dev/null +++ b/src/main/java/com/tairui/app/cim/dao/model/ProductionArea.java @@ -0,0 +1,28 @@ +package com.tairui.app.cim.dao.model; + +import com.baomidou.mybatisplus.annotation.TableField; +import com.baomidou.mybatisplus.annotation.TableId; +import com.baomidou.mybatisplus.annotation.TableName; +import com.tairui.app.cim.util.MyGeometryHandler; +import lombok.Data; +import lombok.EqualsAndHashCode; +import lombok.experimental.Accessors; + +import java.io.Serializable; + +@Data +@EqualsAndHashCode(callSuper = false) +@Accessors(chain = true) +@TableName("production_area") +public class ProductionArea implements Serializable { + + @TableField("gid") + @TableId + private long gid; + + @TableField(typeHandler = MyGeometryHandler.class) + private String geom; + + @TableField(exist=false) + private String gwkt; +} diff --git a/src/main/java/com/tairui/app/cim/dao/model/ProductionUnitArea.java b/src/main/java/com/tairui/app/cim/dao/model/ProductionUnitArea.java new file mode 100644 index 0000000..8dd7f0f --- /dev/null +++ b/src/main/java/com/tairui/app/cim/dao/model/ProductionUnitArea.java @@ -0,0 +1,28 @@ +package com.tairui.app.cim.dao.model; + +import com.baomidou.mybatisplus.annotation.TableField; +import com.baomidou.mybatisplus.annotation.TableId; +import com.baomidou.mybatisplus.annotation.TableName; +import com.tairui.app.cim.util.MyGeometryHandler; +import lombok.Data; +import lombok.EqualsAndHashCode; +import lombok.experimental.Accessors; + +import java.io.Serializable; + +@Data +@EqualsAndHashCode(callSuper = false) +@Accessors(chain = true) +@TableName("production_unit_area") +public class ProductionUnitArea implements Serializable { + + @TableField("gid") + @TableId + private long gid; + + @TableField(typeHandler = MyGeometryHandler.class) + private String geom; + + @TableField(exist=false) + private String gwkt; +} diff --git a/src/main/java/com/tairui/app/cim/dao/model/ToxicGasPoint.java b/src/main/java/com/tairui/app/cim/dao/model/ToxicGasPoint.java new file mode 100644 index 0000000..de53a55 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/dao/model/ToxicGasPoint.java @@ -0,0 +1,64 @@ +package com.tairui.app.cim.dao.model; + +import com.baomidou.mybatisplus.annotation.IdType; +import com.baomidou.mybatisplus.annotation.TableField; +import com.baomidou.mybatisplus.annotation.TableId; +import com.tairui.app.cim.util.MyGeometryHandler; +import io.swagger.annotations.ApiModel; +import lombok.Data; +import lombok.EqualsAndHashCode; + +import java.io.Serializable; +import java.math.BigDecimal; + +/** + * <p> + * + * </p> + * + * @author hyy + * @since 2022-08-22 + */ +@Data +@EqualsAndHashCode(callSuper = false) +@ApiModel(value="ToxicGasPoint瀵硅薄", description="") +public class ToxicGasPoint implements Serializable { + + private static final long serialVersionUID=1L; + + @TableId(value = "gid", type = IdType.ASSIGN_ID) + private Integer gid; + + private String pointId; + + private String pointType; + + private String orgCode; + + private String pointName; + + private String createuser; + + private String createtime; + + private String updateuser; + + private String updatetime; + + private BigDecimal coorZ; + + private BigDecimal status; + + private String remarks; + + private String bindKey; + + + + @TableField(typeHandler = MyGeometryHandler.class) + private String geom; + + @TableField(exist=false) + private String gwkt; + +} diff --git a/src/main/java/com/tairui/app/cim/mapper/AlarmPointMapper.java b/src/main/java/com/tairui/app/cim/mapper/AlarmPointMapper.java new file mode 100644 index 0000000..6a559f0 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/mapper/AlarmPointMapper.java @@ -0,0 +1,29 @@ +package com.tairui.app.cim.mapper; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.tairui.app.cim.dao.model.AlarmPoint; +import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Select; +import org.springframework.stereotype.Repository; + +import java.util.List; + +/** + * <p> + * Mapper 鎺ュ彛 + * </p> + * + * @author yw + * @since 2022-05-21 + */ +@Mapper +@Repository +public interface AlarmPointMapper extends BaseMapper<AlarmPoint> { + + @Select("select gid,geom ,ST_AsText(geom) as gwkt from alarm_point ") + public List<AlarmPoint> listPage(); + + @Select("select gid,geom ,ST_AsText(geom) as gwkt from alarm_point where gid=#{gid} ") + public List<AlarmPoint> query(int gid); + + } diff --git a/src/main/java/com/tairui/app/cim/mapper/BusDeviceMainMapper.java b/src/main/java/com/tairui/app/cim/mapper/BusDeviceMainMapper.java new file mode 100644 index 0000000..51daebe --- /dev/null +++ b/src/main/java/com/tairui/app/cim/mapper/BusDeviceMainMapper.java @@ -0,0 +1,26 @@ +package com.tairui.app.cim.mapper; + +import com.tairui.app.cim.dao.model.BusDeviceMain; +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Select; +import org.springframework.stereotype.Repository; + +import java.util.List; + +/** + * <p> + * Mapper 鎺ュ彛 + * </p> + * + * @author yw + * @since 2022-05-21 + */ +@Mapper +@Repository +public interface BusDeviceMainMapper extends BaseMapper<BusDeviceMain> { + + @Select("select * from bus_device_main ") + public List<BusDeviceMain> listPage(); + +} diff --git a/src/main/java/com/tairui/app/cim/mapper/BusProductionDeviceMapper.java b/src/main/java/com/tairui/app/cim/mapper/BusProductionDeviceMapper.java new file mode 100644 index 0000000..853a3a8 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/mapper/BusProductionDeviceMapper.java @@ -0,0 +1,29 @@ +package com.tairui.app.cim.mapper; + +import com.tairui.app.cim.dao.model.BusProductionDevice; +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Select; +import org.apache.ibatis.annotations.Update; +import org.springframework.stereotype.Repository; + +import java.util.List; + +/** + * <p> + * Mapper 鎺ュ彛 + * </p> + * + * @author yw + * @since 2022-05-21 + */ +@Mapper +@Repository +public interface BusProductionDeviceMapper extends BaseMapper<BusProductionDevice> { + @Select("select * from bus_production_device ") + public List<BusProductionDevice> listPage(); + + @Update("update bus_production_device set status=#{status} where id= #{id}") + public int updateStatus(int status,long id); + + } diff --git a/src/main/java/com/tairui/app/cim/mapper/CameraMapper.java b/src/main/java/com/tairui/app/cim/mapper/CameraMapper.java new file mode 100644 index 0000000..a2c578b --- /dev/null +++ b/src/main/java/com/tairui/app/cim/mapper/CameraMapper.java @@ -0,0 +1,27 @@ +package com.tairui.app.cim.mapper; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.tairui.app.cim.dao.model.CameraPoint; +import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Select; +import org.springframework.stereotype.Repository; + +import java.util.List; + +/** + * <p> + * Mapper 鎺ュ彛 + * </p> + * + * @author yw + * @since 2022-05-21 + */ +@Mapper +@Repository +public interface CameraMapper extends BaseMapper<CameraPoint> { + + @Select("select gid,geom ,ST_AsText(geom) as gwkt from camera_point ") + public List<CameraPoint> listPage(); + @Select("select gid,geom ,ST_AsText(geom) as gwkt from camera_point where gid=#{gid} ") + public List<CameraPoint> query(int gid); + } diff --git a/src/main/java/com/tairui/app/cim/mapper/ElevationMapper.java b/src/main/java/com/tairui/app/cim/mapper/ElevationMapper.java new file mode 100644 index 0000000..30e1681 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/mapper/ElevationMapper.java @@ -0,0 +1,57 @@ +package com.tairui.app.cim.mapper; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.tairui.app.cim.dao.model.AlarmPoint; +import com.tairui.app.cim.dao.model.Elevation; +import com.vividsolutions.jts.geom.Point; +import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Param; +import org.apache.ibatis.annotations.Select; +import org.springframework.stereotype.Repository; + +import java.util.List; + +/** + * <p> + * Mapper 鎺ュ彛 + * </p> + * + * @author yw + * @since 2022-05-21 + */ +@Mapper +@Repository +public interface ElevationMapper extends BaseMapper<Elevation> { + + /** + * 鍖呭惈闈� + * select * from (select gid,geom,coor_z,cen_x,cen_y,name from elevation_correction where floor_num='Floor5') + * as xx where ST_Within(st_geomfromtext('Point(124.041948 41.840189)',4326),xx.geom) + * + * @param x + * @param y + * @param floor + * @return + */ + @Select("select gid,to_char(coor_z,'999.999') as high ,name from elevation_correction " + + "where floor_num='${floor_num}' and ST_Within(st_geomfromtext('Point(${x} ${y})',4326),geom) ") + public List<Elevation> queryFloor(@Param("x") double x, @Param("y") double y, @Param("floor_num") String floor_num); + + + /** + * 鏌ヨ鏈�杩戠殑闈� + * select * from (select gid,geom,coor_z,cen_x,cen_y,name from elevation_correction + * where floor_num='Floor3') as xx order by (st_geomfromtext('Point(124.04 41.840)',4326)<->xx.geom) asc limit 1 + * + * @param x + * @param y + * @param floor + * @return + */ + + @Select("select gid,to_char(coor_z,'999.999') as high ,ST_X(ST_AsText(ST_PointOnSurface(geom::geometry))) as cen_x," + + "ST_Y(ST_AsText(ST_PointOnSurface(geom::geometry))) as cen_y,name from elevation_correction " + + "where floor_num='${floor_num}' order by (st_geomfromtext('Point(${x} ${y})',4326)<->geom) asc limit 1") + public List<Elevation> queryMinDistance(@Param("x") double x, @Param("y") double y, @Param("floor_num") String floor_num); +} + diff --git a/src/main/java/com/tairui/app/cim/mapper/EmergencySuppliesPointMapper.java b/src/main/java/com/tairui/app/cim/mapper/EmergencySuppliesPointMapper.java new file mode 100644 index 0000000..1645eb0 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/mapper/EmergencySuppliesPointMapper.java @@ -0,0 +1,23 @@ +package com.tairui.app.cim.mapper; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.tairui.app.cim.dao.model.EmergencySuppliesPoint; +import com.tairui.app.cim.dao.model.Inspection; +import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Select; + +import java.util.List; + +/** + * <p> + * Mapper 鎺ュ彛 + * </p> + * + * @author hyy + * @since 2022-08-22 + */ +@Mapper +public interface EmergencySuppliesPointMapper extends BaseMapper<EmergencySuppliesPoint> { + @Select("select gid,geom ,ST_AsText(geom) as gwkt from emergency_supplies_point where gid=#{gid} ") + public List<EmergencySuppliesPoint> query(int gid); +} diff --git a/src/main/java/com/tairui/app/cim/mapper/EntranceGuardPointMapper.java b/src/main/java/com/tairui/app/cim/mapper/EntranceGuardPointMapper.java new file mode 100644 index 0000000..45dbd98 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/mapper/EntranceGuardPointMapper.java @@ -0,0 +1,23 @@ +package com.tairui.app.cim.mapper; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.tairui.app.cim.dao.model.EntranceGuardPoint; +import com.tairui.app.cim.dao.model.Inspection; +import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Select; + +import java.util.List; + +/** + * <p> + * Mapper 鎺ュ彛 + * </p> + * + * @author hyy + * @since 2022-08-22 + */ +@Mapper +public interface EntranceGuardPointMapper extends BaseMapper<EntranceGuardPoint> { + @Select("select gid,geom ,ST_AsText(geom) as gwkt from entrance_guard_point where gid=#{gid} ") + public List<EntranceGuardPoint> query(int gid); +} diff --git a/src/main/java/com/tairui/app/cim/mapper/EvacuationPointMapper.java b/src/main/java/com/tairui/app/cim/mapper/EvacuationPointMapper.java new file mode 100644 index 0000000..67e13dc --- /dev/null +++ b/src/main/java/com/tairui/app/cim/mapper/EvacuationPointMapper.java @@ -0,0 +1,23 @@ +package com.tairui.app.cim.mapper; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.tairui.app.cim.dao.model.EntranceGuardPoint; +import com.tairui.app.cim.dao.model.EvacuationPoint; +import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Select; + +import java.util.List; + +/** + * <p> + * Mapper 鎺ュ彛 + * </p> + * + * @author hyy + * @since 2022-08-22 + */ +@Mapper +public interface EvacuationPointMapper extends BaseMapper<EvacuationPoint> { + @Select("select gid,geom ,ST_AsText(geom) as gwkt from evacuation_point where gid=#{gid} ") + public List<EvacuationPoint> query(int gid); +} diff --git a/src/main/java/com/tairui/app/cim/mapper/FireEquipmentPointMapper.java b/src/main/java/com/tairui/app/cim/mapper/FireEquipmentPointMapper.java new file mode 100644 index 0000000..eee7313 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/mapper/FireEquipmentPointMapper.java @@ -0,0 +1,23 @@ +package com.tairui.app.cim.mapper; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.tairui.app.cim.dao.model.EvacuationPoint; +import com.tairui.app.cim.dao.model.FireEquipmentPoint; +import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Select; + +import java.util.List; + +/** + * <p> + * Mapper 鎺ュ彛 + * </p> + * + * @author hyy + * @since 2022-08-23 + */ +@Mapper +public interface FireEquipmentPointMapper extends BaseMapper<FireEquipmentPoint> { + @Select("select gid,geom ,ST_AsText(geom) as gwkt from fire_equipment_point where gid=#{gid} ") + public List<FireEquipmentPoint> query(int gid); +} diff --git a/src/main/java/com/tairui/app/cim/mapper/InspectionMapper.java b/src/main/java/com/tairui/app/cim/mapper/InspectionMapper.java new file mode 100644 index 0000000..82717e6 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/mapper/InspectionMapper.java @@ -0,0 +1,27 @@ +package com.tairui.app.cim.mapper; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.tairui.app.cim.dao.model.Inspection; +import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Select; +import org.springframework.stereotype.Repository; + +import java.util.List; + +/** + * <p> + * Mapper 鎺ュ彛 + * </p> + * + * @author yw + * @since 2022-05-21 + */ +@Mapper +@Repository +public interface InspectionMapper extends BaseMapper<Inspection> { + + @Select("select gid,geom ,ST_AsText(geom) as gwkt from onsite_inspection_point ") + public List<Inspection> listPage(); + @Select("select gid,geom ,ST_AsText(geom) as gwkt from onsite_inspection_point where gid=#{gid} ") + public List<Inspection> query(int gid); + } diff --git a/src/main/java/com/tairui/app/cim/mapper/MajorHazardsPointMapper.java b/src/main/java/com/tairui/app/cim/mapper/MajorHazardsPointMapper.java new file mode 100644 index 0000000..b271a73 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/mapper/MajorHazardsPointMapper.java @@ -0,0 +1,23 @@ +package com.tairui.app.cim.mapper; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.tairui.app.cim.dao.model.EvacuationPoint; +import com.tairui.app.cim.dao.model.MajorHazardsPoint; +import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Select; + +import java.util.List; + +/** + * <p> + * Mapper 鎺ュ彛 + * </p> + * + * @author hyy + * @since 2022-08-22 + */ +@Mapper +public interface MajorHazardsPointMapper extends BaseMapper<MajorHazardsPoint> { + @Select("select gid,geom ,ST_AsText(geom) as gwkt from major_hazards_point where gid=#{gid} ") + public List<MajorHazardsPoint> query(int gid); +} diff --git a/src/main/java/com/tairui/app/cim/mapper/OperationAreaMapper.java b/src/main/java/com/tairui/app/cim/mapper/OperationAreaMapper.java new file mode 100644 index 0000000..fab1dfd --- /dev/null +++ b/src/main/java/com/tairui/app/cim/mapper/OperationAreaMapper.java @@ -0,0 +1,27 @@ +package com.tairui.app.cim.mapper; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.tairui.app.cim.dao.model.OperationArea; +import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Select; +import org.springframework.stereotype.Repository; + +import java.util.List; + +/** + * <p> + * Mapper 鎺ュ彛 + * </p> + * + * @author yw + * @since 2022-05-21 + */ +@Mapper +@Repository +public interface OperationAreaMapper extends BaseMapper<OperationArea> { + + @Select("select gid,geom ,ST_AsText(geom) as gwkt from operation_area ") + public List<OperationArea> listPage(); + @Select("select gid,geom ,ST_AsText(geom) as gwkt from operation_area where gid=#{gid} ") + public List<OperationArea> query(int gid); + } diff --git a/src/main/java/com/tairui/app/cim/mapper/PersonnelPointMapper.java b/src/main/java/com/tairui/app/cim/mapper/PersonnelPointMapper.java new file mode 100644 index 0000000..74087f2 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/mapper/PersonnelPointMapper.java @@ -0,0 +1,27 @@ +package com.tairui.app.cim.mapper; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.tairui.app.cim.dao.model.PersonnelPoint; +import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Select; +import org.springframework.stereotype.Repository; + +import java.util.List; + +/** + * <p> + * Mapper 鎺ュ彛 + * </p> + * + * @author yw + * @since 2022-05-21 + */ +@Mapper +@Repository +public interface PersonnelPointMapper extends BaseMapper<PersonnelPoint> { + + @Select("select gid,geom ,ST_AsText(geom) as gwkt from personnel_point ") + public List<PersonnelPoint> listPage(); + @Select("select gid,geom ,ST_AsText(geom) as gwkt from personnel_point where gid=#{gid} ") + public List<PersonnelPoint> query(int gid); + } diff --git a/src/main/java/com/tairui/app/cim/mapper/ProductionAreaMapper.java b/src/main/java/com/tairui/app/cim/mapper/ProductionAreaMapper.java new file mode 100644 index 0000000..ddc5872 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/mapper/ProductionAreaMapper.java @@ -0,0 +1,29 @@ +package com.tairui.app.cim.mapper; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.tairui.app.cim.dao.model.ProductionArea; +import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Select; +import org.springframework.stereotype.Repository; + +import java.util.List; + +/** + * <p> + * Mapper 鎺ュ彛 + * </p> + * + * @author yw + * @since 2022-05-21 + */ +@Mapper +@Repository +public interface ProductionAreaMapper extends BaseMapper<ProductionArea> { + + @Select("select * from production_area ") + public List<ProductionArea> listPage(); + @Select("select name from production_area ") + public List<String> listAreaName(); + @Select("select gid,geom ,ST_AsText(geom) as gwkt from production_area where gid=#{gid} ") + public List<ProductionArea> query(int gid); +} diff --git a/src/main/java/com/tairui/app/cim/mapper/ProductionUnitAreaMapper.java b/src/main/java/com/tairui/app/cim/mapper/ProductionUnitAreaMapper.java new file mode 100644 index 0000000..2fde412 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/mapper/ProductionUnitAreaMapper.java @@ -0,0 +1,26 @@ +package com.tairui.app.cim.mapper; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.tairui.app.cim.dao.model.ProductionUnitArea; +import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Select; +import org.springframework.stereotype.Repository; + +import java.util.List; + +/** + * <p> + * Mapper 鎺ュ彛 + * </p> + * + * @author yw + * @since 2022-05-21 + */ +@Mapper +@Repository +public interface ProductionUnitAreaMapper extends BaseMapper<ProductionUnitArea> { + + @Select("select gid,geom ,ST_AsText(geom) as gwkt from production_unit_area where gid=#{gid} ") + public List<ProductionUnitArea> query(int gid); + +} diff --git a/src/main/java/com/tairui/app/cim/mapper/ToxicGasPointMapper.java b/src/main/java/com/tairui/app/cim/mapper/ToxicGasPointMapper.java new file mode 100644 index 0000000..45143f3 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/mapper/ToxicGasPointMapper.java @@ -0,0 +1,25 @@ +package com.tairui.app.cim.mapper; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.tairui.app.cim.dao.model.Inspection; +import com.tairui.app.cim.dao.model.ToxicGasPoint; +import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Select; +import org.springframework.stereotype.Repository; + +import java.util.List; + +/** + * <p> + * Mapper 鎺ュ彛 + * </p> + * + * @author hyy + * @since 2022-08-22 + */ +@Mapper +@Repository +public interface ToxicGasPointMapper extends BaseMapper<ToxicGasPoint> { + @Select("select gid,geom ,ST_AsText(geom) as gwkt from toxic_gas_point where gid=#{gid} ") + public List<ToxicGasPoint> query(int gid); +} diff --git a/src/main/java/com/tairui/app/cim/mapper/xml/BusDeviceMainMapper.xml b/src/main/java/com/tairui/app/cim/mapper/xml/BusDeviceMainMapper.xml new file mode 100644 index 0000000..2617745 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/mapper/xml/BusDeviceMainMapper.xml @@ -0,0 +1,38 @@ +<?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.tairui.app.cim.mapper.BusDeviceMainMapper"> + + <!-- 閫氱敤鏌ヨ鏄犲皠缁撴灉 --> + <resultMap id="BaseResultMap" type="com.tairui.app.cim.dao.model.BusDeviceMain"> + <result column="bdm_id" property="bdmId" /> + <result column="device_no" property="deviceNo" /> + <result column="bdm_device_name" property="bdmDeviceName" /> + <result column="bdm_type_first" property="bdmTypeFirst" /> + <result column="bdm_type_second" property="bdmTypeSecond" /> + <result column="bdm_type_third" property="bdmTypeThird" /> + <result column="bdm_area" property="bdmArea" /> + <result column="unit_area" property="unitArea" /> + <result column="bdm_location" property="bdmLocation" /> + <result column="bdm_department" property="bdmDepartment" /> + <result column="bdm_purpose" property="bdmPurpose" /> + <result column="bdm_specification" property="bdmSpecification" /> + <result column="bdm_manufacturer" property="bdmManufacturer" /> + <result column="bdm_production_date" property="bdmProductionDate" /> + <result column="bdm_first_use_date" property="bdmFirstUseDate" /> + <result column="bdm_newest_use_date" property="bdmNewestUseDate" /> + <result column="bdm_newest_valid_date" property="bdmNewestValidDate" /> + <result column="bdm_use_state" property="bdmUseState" /> + <result column="bdm_device_state" property="bdmDeviceState" /> + <result column="bdm_remark" property="bdmRemark" /> + <result column="bdm_map_point_flag" property="bdmMapPointFlag" /> + <result column="bdm_deleted_flag" property="bdmDeletedFlag" /> + <result column="create_time" property="createTime" /> + <result column="create_user" property="createUser" /> + <result column="update_time" property="updateTime" /> + <result column="update_user" property="updateUser" /> + <result column="bdm_type" property="bdmType" /> + <result column="model_id" property="modelId" /> + <result column="status" property="status" /> + </resultMap> + +</mapper> diff --git a/src/main/java/com/tairui/app/cim/mapper/xml/BusProductionDeviceMapper.xml b/src/main/java/com/tairui/app/cim/mapper/xml/BusProductionDeviceMapper.xml new file mode 100644 index 0000000..347715a --- /dev/null +++ b/src/main/java/com/tairui/app/cim/mapper/xml/BusProductionDeviceMapper.xml @@ -0,0 +1,50 @@ +<?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.tairui.app.cim.mapper.BusProductionDeviceMapper"> + + <!-- 閫氱敤鏌ヨ鏄犲皠缁撴灉 --> + <resultMap id="BaseResultMap" type="com.tairui.app.cim.dao.model.BusProductionDevice"> + <result column="id" property="id" /> + <result column="device_no" property="deviceNo" /> + <result column="device_name" property="deviceName" /> + <result column="dept_id" property="deptId" /> + <result column="deivce_type" property="deivceType" /> + <result column="sub_device_type" property="subDeviceType" /> + <result column="device_trand" property="deviceTrand" /> + <result column="region_id" property="regionId" /> + <result column="tag_number" property="tagNumber" /> + <result column="state" property="state" /> + <result column="factory_no" property="factoryNo" /> + <result column="special" property="special" /> + <result column="equipment" property="equipment" /> + <result column="responsibility_by" property="responsibilityBy" /> + <result column="model_id" property="modelId" /> + <result column="video_coding" property="videoCoding" /> + <result column="device_channel" property="deviceChannel" /> + <result column="bitstream_type" property="bitstreamType" /> + <result column="monitor_type" property="monitorType" /> + <result column="videotape_type" property="videotapeType" /> + <result column="in_out_type" property="inOutType" /> + <result column="device_model" property="deviceModel" /> + <result column="location" property="location" /> + <result column="purpose" property="purpose" /> + <result column="device_account" property="deviceAccount" /> + <result column="device_password" property="devicePassword" /> + <result column="ip" property="ip" /> + <result column="prot" property="prot" /> + <result column="del_flag" property="delFlag" /> + <result column="create_time" property="createTime" /> + <result column="update_time" property="updateTime" /> + <result column="bind_location" property="bindLocation" /> + <result column="bind_state" property="bindState" /> + <result column="channel_state" property="channelState" /> + <result column="video_address" property="videoAddress" /> + <result column="unit" property="unit" /> + <result column="infra_red_channel" property="infraRedChannel" /> + <result column="status" property="status" /> + <result column="unit_area" property="unitArea" /> + <result column="create_user" property="createUser" /> + <result column="update_user" property="updateUser" /> + </resultMap> + +</mapper> diff --git a/src/main/java/com/tairui/app/cim/service/IBusDeviceMainService.java b/src/main/java/com/tairui/app/cim/service/IBusDeviceMainService.java new file mode 100644 index 0000000..63fb495 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/service/IBusDeviceMainService.java @@ -0,0 +1,16 @@ +package com.tairui.app.cim.service; + +import com.tairui.app.cim.dao.model.BusDeviceMain; +import com.baomidou.mybatisplus.extension.service.IService; + +/** + * <p> + * 鏈嶅姟绫� + * </p> + * + * @author yw + * @since 2022-05-21 + */ +public interface IBusDeviceMainService extends IService<BusDeviceMain> { + +} diff --git a/src/main/java/com/tairui/app/cim/service/IBusProductionDeviceService.java b/src/main/java/com/tairui/app/cim/service/IBusProductionDeviceService.java new file mode 100644 index 0000000..d683df2 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/service/IBusProductionDeviceService.java @@ -0,0 +1,16 @@ +package com.tairui.app.cim.service; + +import com.tairui.app.cim.dao.model.BusProductionDevice; +import com.baomidou.mybatisplus.extension.service.IService; + +/** + * <p> + * 鏈嶅姟绫� + * </p> + * + * @author yw + * @since 2022-05-21 + */ +public interface IBusProductionDeviceService extends IService<BusProductionDevice> { + +} diff --git a/src/main/java/com/tairui/app/cim/service/IProductionAreaService.java b/src/main/java/com/tairui/app/cim/service/IProductionAreaService.java new file mode 100644 index 0000000..72093c7 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/service/IProductionAreaService.java @@ -0,0 +1,16 @@ +package com.tairui.app.cim.service; + +import com.baomidou.mybatisplus.extension.service.IService; +import com.tairui.app.cim.dao.model.ProductionArea; + +/** + * <p> + * 鏈嶅姟绫� + * </p> + * + * @author yw + * @since 2022-05-21 + */ +public interface IProductionAreaService extends IService<ProductionArea> { + +} diff --git a/src/main/java/com/tairui/app/cim/service/impl/BusDeviceMainServiceImpl.java b/src/main/java/com/tairui/app/cim/service/impl/BusDeviceMainServiceImpl.java new file mode 100644 index 0000000..b90bf72 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/service/impl/BusDeviceMainServiceImpl.java @@ -0,0 +1,20 @@ +package com.tairui.app.cim.service.impl; + +import com.tairui.app.cim.dao.model.BusDeviceMain; +import com.tairui.app.cim.mapper.BusDeviceMainMapper; +import com.tairui.app.cim.service.IBusDeviceMainService; +import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import org.springframework.stereotype.Service; + +/** + * <p> + * 鏈嶅姟瀹炵幇绫� + * </p> + * + * @author yw + * @since 2022-05-21 + */ +@Service +public class BusDeviceMainServiceImpl extends ServiceImpl<BusDeviceMainMapper, BusDeviceMain> implements IBusDeviceMainService { + +} diff --git a/src/main/java/com/tairui/app/cim/service/impl/BusProductionDeviceServiceImpl.java b/src/main/java/com/tairui/app/cim/service/impl/BusProductionDeviceServiceImpl.java new file mode 100644 index 0000000..bf8a99f --- /dev/null +++ b/src/main/java/com/tairui/app/cim/service/impl/BusProductionDeviceServiceImpl.java @@ -0,0 +1,20 @@ +package com.tairui.app.cim.service.impl; + +import com.tairui.app.cim.dao.model.BusProductionDevice; +import com.tairui.app.cim.mapper.BusProductionDeviceMapper; +import com.tairui.app.cim.service.IBusProductionDeviceService; +import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import org.springframework.stereotype.Service; + +/** + * <p> + * 鏈嶅姟瀹炵幇绫� + * </p> + * + * @author yw + * @since 2022-05-21 + */ +@Service +public class BusProductionDeviceServiceImpl extends ServiceImpl<BusProductionDeviceMapper, BusProductionDevice> implements IBusProductionDeviceService { + +} diff --git a/src/main/java/com/tairui/app/cim/service/impl/ProductionAreaServiceImpl.java b/src/main/java/com/tairui/app/cim/service/impl/ProductionAreaServiceImpl.java new file mode 100644 index 0000000..7589f5f --- /dev/null +++ b/src/main/java/com/tairui/app/cim/service/impl/ProductionAreaServiceImpl.java @@ -0,0 +1,20 @@ +package com.tairui.app.cim.service.impl; + +import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import com.tairui.app.cim.dao.model.ProductionArea; +import com.tairui.app.cim.mapper.ProductionAreaMapper; +import com.tairui.app.cim.service.IProductionAreaService; +import org.springframework.stereotype.Service; + +/** + * <p> + * 鏈嶅姟瀹炵幇绫� + * </p> + * + * @author yw + * @since 2022-05-21 + */ +@Service +public class ProductionAreaServiceImpl extends ServiceImpl<ProductionAreaMapper, ProductionArea> implements IProductionAreaService { + +} diff --git a/src/main/java/com/tairui/app/cim/util/CodeGenerator.java b/src/main/java/com/tairui/app/cim/util/CodeGenerator.java new file mode 100644 index 0000000..c6d8825 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/util/CodeGenerator.java @@ -0,0 +1,139 @@ +package com.tairui.app.cim.util; + +import com.baomidou.mybatisplus.annotation.IdType; +import com.baomidou.mybatisplus.core.exceptions.MybatisPlusException; +import com.baomidou.mybatisplus.core.toolkit.StringPool; +import com.baomidou.mybatisplus.core.toolkit.StringUtils; +import com.baomidou.mybatisplus.generator.AutoGenerator; +import com.baomidou.mybatisplus.generator.InjectionConfig; +import com.baomidou.mybatisplus.generator.config.*; +import com.baomidou.mybatisplus.generator.config.po.TableInfo; +import com.baomidou.mybatisplus.generator.config.rules.DateType; +import com.baomidou.mybatisplus.generator.config.rules.NamingStrategy; + + +import java.util.ArrayList; +import java.util.List; +import java.util.Scanner; + +/** + * @program: spring-boot-parent + * @description: 浠g爜鐢熸垚宸ュ叿绫� + * @author: + * @create: 2020-12-14 19:23 + */ +public class CodeGenerator { + + /** + * <p> + * 璇诲彇鎺у埗鍙板唴瀹� + * </p> + */ + public static String scanner(String tip) { + Scanner scanner = new Scanner(System.in); + StringBuilder help = new StringBuilder(); + help.append("璇疯緭鍏�" + tip + "锛�"); + System.out.println(help.toString()); + if (scanner.hasNext()) { + String ipt = scanner.next(); + if (StringUtils.isNotBlank(ipt)) { + return ipt; + } + } + throw new MybatisPlusException("璇疯緭鍏ユ纭殑" + tip + "锛�"); + } + + + public static void main(String[] args) { + // 浠g爜鐢熸垚鍣� + AutoGenerator mpg = new AutoGenerator(); + + // 鍏ㄥ眬閰嶇疆 + GlobalConfig gc = new GlobalConfig(); + String projectPath = System.getProperty("user.dir"); + gc.setOutputDir(projectPath + "/src/main/java"); + gc.setAuthor("hyy");//璁剧疆浣滆�� + gc.setOpen(false); + gc.setFileOverride(false); + gc.setIdType(IdType.ASSIGN_ID); + gc.setDateType(DateType.ONLY_DATE); + gc.setSwagger2(true); //瀹炰綋灞炴�� Swagger2 娉ㄨВ + gc.setServiceName("%sService"); //鍘绘帀Service鎺ュ彛鐨勯瀛楁瘝I + gc.setBaseResultMap(true); + gc.setBaseColumnList(true); + mpg.setGlobalConfig(gc); + + TemplateConfig templateConfig = new TemplateConfig() + .setController(ConstVal.TEMPLATE_CONTROLLER).setXml(null) + .setServiceImpl(ConstVal.TEMPLATE_SERVICE_IMPL).setXml(null) + .setMapper(ConstVal.TEMPLATE_MAPPER).setXml(null) + .setService(ConstVal.TEMPLATE_SERVICE).setXml(null); + + mpg.setTemplate(templateConfig); + // 鏁版嵁婧愰厤缃� + DataSourceConfig dsc = new DataSourceConfig(); + dsc.setUrl("jdbc:postgresql://192.168.22.198:5432/fssh?characterEncoding=utf8&ssl=false"); + // dsc.setSchemaName("public"); + dsc.setDriverName("org.postgresql.Driver"); + dsc.setUsername("postgres"); + dsc.setPassword("postgres"); +// dsc.setUrl("jdbc:mysql://localhost:3306/cyioc?charset=utf8mb4&useSSL=false&characterEncoding=utf-8&serverTimezone=Asia/Shanghai"); +// // dsc.setSchemaName("public"); +// dsc.setDriverName("com.mysql.cj.jdbc.Driver"); +// dsc.setUsername("root"); +// dsc.setPassword("123456"); +// dsc.setDbType(DbType.MYSQL); + mpg.setDataSource(dsc); + + + // 鍖呴厤缃� + PackageConfig pc = new PackageConfig(); + pc.setParent("com.tairui.app.cim"); + pc.setModuleName(scanner("妯″潡鍚�")); + pc.setEntity("domain"); + pc.setMapper("mapper"); + pc.setService("service"); + pc.setController("controller"); + mpg.setPackageInfo(pc); + + + // 濡傛灉妯℃澘寮曟搸鏄� velocity + // String templatePath = "/templates/mapper.xml.vm"; + + + // 绛栫暐閰嶇疆 + StrategyConfig strategy = new StrategyConfig(); + strategy.setNaming(NamingStrategy.underline_to_camel); + strategy.setColumnNaming(NamingStrategy.underline_to_camel); + strategy.setEntityLombokModel(true); + strategy.setRestControllerStyle(true); + //鍏叡鐖剁被 + //strategy.setSuperControllerClass("BaseEntity"); +// strategy.setSuperEntityClass(BaseEntity.class); + // 鍐欎簬鐖剁被涓殑鍏叡瀛楁 +// strategy.setSuperEntityColumns("id", "create_time", "update_time"); + strategy.setInclude(scanner("琛ㄥ悕锛屽涓嫳鏂囬�楀彿鍒嗗壊").split(",")); + strategy.setControllerMappingHyphenStyle(true); + strategy.setTablePrefix(pc.getModuleName() + "_"); + strategy.setVersionFieldName("version"); + + + InjectionConfig cfg = new InjectionConfig() { + @Override + public void initMap() { + } + }; + List<FileOutConfig> configList = new ArrayList<>(); + configList.add(new FileOutConfig(ConstVal.TEMPLATE_XML+ ".vm") { + @Override + public String outputFile(TableInfo tableInfo) { + return projectPath+"/src/main/resources/"+pc.getParent().replace(".","/") + +"/mapper/"+tableInfo.getXmlName()+ StringPool.DOT_XML; + } + }); + cfg.setFileOutConfigList(configList); + mpg.setCfg(cfg); + mpg.setStrategy(strategy); + mpg.execute(); + } +} diff --git a/src/main/java/com/tairui/app/cim/util/GeoJsonUtil.java b/src/main/java/com/tairui/app/cim/util/GeoJsonUtil.java new file mode 100644 index 0000000..26bc132 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/util/GeoJsonUtil.java @@ -0,0 +1,95 @@ +package com.tairui.app.cim.util; + + +import com.vividsolutions.jts.geom.Geometry; +import com.vividsolutions.jts.geom.GeometryFactory; +import com.vividsolutions.jts.geom.Point; +import com.vividsolutions.jts.io.WKBReader; +import com.vividsolutions.jts.io.WKTReader; +import org.geotools.geojson.geom.GeometryJSON; +import org.springframework.util.StringUtils; + +import java.io.IOException; +import java.io.StringWriter; + +public class GeoJsonUtil { + + + public static String getGeoJSON(Point geometry){ + + if(geometry==null){ + return null; + } + StringWriter writer = new StringWriter(); + GeometryJSON g = new GeometryJSON(); + try { + g.write(geometry, writer); + } catch (IOException e) { + e.printStackTrace(); + } + + String json = writer.toString(); + if("null".equals(json)){ + json = null; + } + return json; + } + + public static Geometry getGeometryFromGeometryBinargy(String hexString){ + GeometryFactory geometryFactory = new GeometryFactory(); + WKBReader wktReader = new WKBReader(); + Geometry geometry = null ; + try { + geometry = wktReader.read(WKBReader.hexToBytes(hexString)); + } catch (Exception e) { + e.printStackTrace(); + } + return geometry ; + } + + //geoJSON鏍煎紡瀛楃涓茶浆Point绫诲瀷 + public static Geometry getGeometryFromGeoJSON(String geoJSON){ + + if(StringUtils.isEmpty(geoJSON)){ + return null; + } + + GeometryJSON g = new GeometryJSON(); + + Geometry geometry =null ; + + try { + + geometry=(Geometry)g.read(geoJSON); + } catch (IOException e) { + // TODO Auto-generated catch block + e.printStackTrace(); + } + + + return geometry; + } + + //鏁版嵁搴揂sText鏌ヨ鍑烘潵鐨剋kt鏍煎紡鐨勫瓧绗︿覆杞负geoJSON杩斿洖鍒板墠绔� + public static String getGeoJSONFromWKT(String geoWkt){ + + if(StringUtils.isEmpty(geoWkt)){ + return null; + } + WKTReader reader = new WKTReader(); + + String ret = null; + try { + Geometry geometry = reader.read(geoWkt); + StringWriter writer = new StringWriter(); + GeometryJSON g = new GeometryJSON(); + g.write(geometry, writer); + ret = writer.toString(); + } catch (Exception e) { + e.printStackTrace(); + } + return ret; + + } + +} diff --git a/src/main/java/com/tairui/app/cim/util/MyBatisPage.java b/src/main/java/com/tairui/app/cim/util/MyBatisPage.java new file mode 100644 index 0000000..e5567c9 --- /dev/null +++ b/src/main/java/com/tairui/app/cim/util/MyBatisPage.java @@ -0,0 +1,18 @@ +package com.tairui.app.cim.util; + +import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor; +import org.springframework.context.annotation.Bean; +import org.springframework.context.annotation.Configuration; + +@Configuration +public class MyBatisPage { + + /** + * 閰嶇疆PaginationInterceptor,浣垮叾鍒嗛〉鎻掍欢鏈夋晥 + * @return + */ + @Bean + public PaginationInterceptor paginationInterceptor() { + return new PaginationInterceptor(); + } +} \ No newline at end of file diff --git a/src/main/java/com/tairui/app/cim/util/MyGeometryHandler.java b/src/main/java/com/tairui/app/cim/util/MyGeometryHandler.java new file mode 100644 index 0000000..a3d841d --- /dev/null +++ b/src/main/java/com/tairui/app/cim/util/MyGeometryHandler.java @@ -0,0 +1,48 @@ +package com.tairui.app.cim.util; + +import org.apache.ibatis.type.BaseTypeHandler; +import org.apache.ibatis.type.JdbcType; +import org.apache.ibatis.type.MappedTypes; +import org.postgis.PGgeometry; + +import java.sql.CallableStatement; +import java.sql.PreparedStatement; +import java.sql.ResultSet; +import java.sql.SQLException; + +@MappedTypes({String.class}) +public class MyGeometryHandler extends BaseTypeHandler<String> { + @Override + public void setNonNullParameter(PreparedStatement ps, int i, String parameter, JdbcType jdbcType) throws SQLException { + PGgeometry pGgeometry = new PGgeometry(parameter); + ps.setObject(i, pGgeometry); + } + + @Override + public String getNullableResult(ResultSet rs, String columnName) throws SQLException { + PGgeometry pGgeometry = new PGgeometry(rs.getString(columnName)); + if (pGgeometry == null) { + return null; + } + return pGgeometry.toString(); + } + + @Override + public String getNullableResult(ResultSet rs, int columnIndex) throws SQLException { + PGgeometry pGgeometry = new PGgeometry(rs.getString(columnIndex)); + if (pGgeometry == null) { + return null; + } + return pGgeometry.toString(); + } + + @Override + public String getNullableResult(CallableStatement cs, int columnIndex) throws SQLException { + + PGgeometry pGgeometry = new PGgeometry(cs.getString(columnIndex)); + if (pGgeometry == null) { + return null; + } + return pGgeometry.toString(); + } +} \ No newline at end of file diff --git a/src/main/resources/application.yml b/src/main/resources/application.yml new file mode 100644 index 0000000..36ffae6 --- /dev/null +++ b/src/main/resources/application.yml @@ -0,0 +1,88 @@ +server: + port: 8543 + servlet: + context-path: /fssh +# 鏁版嵁婧愰厤缃� +spring: + datasource: + type: com.alibaba.druid.pool.DruidDataSource + driverClassName: org.postgresql.Driver + url: jdbc:postgresql://192.168.22.198:5432/fssh?characterEncoding=utf8&ssl=false + username: postgres + # 1.閰嶇疆鐢熸垚鐨刾assword + password: postgres + # Druid鏁版嵁婧愰厤缃� + # 鍒濆杩炴帴鏁� + initialSize: 5 + # 鏈�灏忚繛鎺ユ睜鏁伴噺 + minIdle: 10 + # 鏈�澶ц繛鎺ユ睜鏁伴噺 + maxActive: 20 + # 閰嶇疆鑾峰彇杩炴帴绛夊緟瓒呮椂鐨勬椂闂� + maxWait: 60000 + # 閰嶇疆闂撮殧澶氫箙鎵嶈繘琛屼竴娆℃娴嬶紝妫�娴嬮渶瑕佸叧闂殑绌洪棽杩炴帴锛屽崟浣嶆槸姣 + timeBetweenEvictionRunsMillis: 60000 + # 閰嶇疆涓�涓繛鎺ュ湪姹犱腑鏈�灏忕敓瀛樼殑鏃堕棿锛屽崟浣嶆槸姣 + minEvictableIdleTimeMillis: 300000 + # 閰嶇疆涓�涓繛鎺ュ湪姹犱腑鏈�澶х敓瀛樼殑鏃堕棿锛屽崟浣嶆槸姣 + maxEvictableIdleTimeMillis: 900000 + # 閰嶇疆妫�娴嬭繛鎺ユ槸鍚︽湁鏁� + validationQuery: SELECT 1 FROM DUAL + #鐢宠杩炴帴鐨勬椂鍊欐娴嬶紝濡傛灉绌洪棽鏃堕棿澶т簬timeBetweenEvictionRunsMillis锛屾墽琛寁alidationQuery妫�娴嬭繛鎺ユ槸鍚︽湁鏁堛�� + testWhileIdle: true + #閰嶇疆浠庤繛鎺ユ睜鑾峰彇杩炴帴鏃讹紝鏄惁妫�鏌ヨ繛鎺ユ湁鏁堟�э紝true姣忔閮芥鏌ワ紱false涓嶆鏌ャ�傚仛浜嗚繖涓厤缃細闄嶄綆鎬ц兘銆� + testOnBorrow: false + #閰嶇疆鍚戣繛鎺ユ睜褰掕繕杩炴帴鏃讹紝鏄惁妫�鏌ヨ繛鎺ユ湁鏁堟�э紝true姣忔閮芥鏌ワ紱false涓嶆鏌ャ�傚仛浜嗚繖涓厤缃細闄嶄綆鎬ц兘銆� + testOnReturn: false + #鎵撳紑PsCache锛屽苟涓旀寚瀹氭瘡涓繛鎺ヤ笂PSCache鐨勫ぇ灏� + poolPreparedStatements: true + maxPoolPreparedStatementPerConnectionSize: 20 + # 閰嶇疆鐩戞帶缁熻鎷︽埅鐨刦ilters锛屽幓鎺夊悗鐩戞帶鐣岄潰sql鏃犳硶缁熻锛�'wall'鐢ㄤ簬闃茬伀澧� + filters: stat,wall,log4j + #鍚堝苟澶氫釜DruidDatasource鐨勭洃鎺ф暟鎹� + useGlobalDataSourceStat: true + #閫氳繃connectProperties灞炴�ф潵鎵撳紑mergesql鍔熻兘缃楁參sQL璁板綍 + connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500; + +#spring: +# +# datasource: +# driver-class-name: org.postgresql.Driver +# url: jdbc:postgresql://192.168.22.198:5432/fssh?characterEncoding=utf8&ssl=false +## username: postgres +# # Tam@root +# # terra@123 +## url: jdbc:postgresql://127.0.0.1:5432/fssh?characterEncoding=utf8&ssl=false +# username: postgres +# password: postgres +# # 杩欓噷鏁村浘鏁版嵁鐨勯摼鎺ャ�傜敤浜庡瓨鏀炬嫇鎵戜俊鎭互鍙婂垎鏋愪娇鐢� + + jackson: + date-format: yyyy-MM-dd HH:mm:ss + time-zone: GMT+8 + serialization: + write-dates-as-timestamps: false + # redis 閰嶇疆 + + sql: + init: + platform: postgres + +logging: + level: + com.example.demo.cim.mapper: debug +mybatis-plus: + mapper-locations: classpath*:org/jeecg/modules/**/xml/*Mapper.xml + global-config: + # 鍏抽棴MP3.0鑷甫鐨刡anner + banner: false + db-config: + #涓婚敭绫诲瀷 + id-type: ASSIGN_ID + # 榛樿鏁版嵁搴撹〃涓嬪垝绾垮懡鍚� + table-underline: true + configuration: + # 杩欎釜閰嶇疆浼氬皢鎵ц鐨剆ql鎵撳嵃鍑烘潵锛屽湪寮�鍙戞垨娴嬭瘯鐨勬椂鍊欏彲浠ョ敤 + log-impl: org.apache.ibatis.logging.stdout.StdOutImpl + # 杩斿洖绫诲瀷涓篗ap,鏄剧ずnull瀵瑰簲鐨勫瓧娈� + call-setters-on-nulls: true \ No newline at end of file diff --git a/src/main/resources/com/tairui/app/cim/test/mapper/EmergencySuppliesPointMapper.xml b/src/main/resources/com/tairui/app/cim/test/mapper/EmergencySuppliesPointMapper.xml new file mode 100644 index 0000000..1e43c73 --- /dev/null +++ b/src/main/resources/com/tairui/app/cim/test/mapper/EmergencySuppliesPointMapper.xml @@ -0,0 +1,27 @@ +<?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.tairui.app.cim.test.mapper.EmergencySuppliesPointMapper"> + + <!-- 閫氱敤鏌ヨ鏄犲皠缁撴灉 --> + <resultMap id="BaseResultMap" type="com.tairui.app.cim.test.domain.EmergencySuppliesPoint"> + <id column="gid" property="gid" /> + <result column="point_id" property="pointId" /> + <result column="point_type" property="pointType" /> + <result column="org_code" property="orgCode" /> + <result column="point_name" property="pointName" /> + <result column="createuser" property="createuser" /> + <result column="createtime" property="createtime" /> + <result column="updateuser" property="updateuser" /> + <result column="updatetime" property="updatetime" /> + <result column="coor_z" property="coorZ" /> + <result column="status" property="status" /> + <result column="remarks" property="remarks" /> + <result column="geom" property="geom" /> + </resultMap> + + <!-- 閫氱敤鏌ヨ缁撴灉鍒� --> + <sql id="Base_Column_List"> + gid, point_id, point_type, org_code, point_name, createuser, createtime, updateuser, updatetime, coor_z, status, remarks, geom + </sql> + +</mapper> diff --git a/src/main/resources/com/tairui/app/cim/test/mapper/EntranceGuardPointMapper.xml b/src/main/resources/com/tairui/app/cim/test/mapper/EntranceGuardPointMapper.xml new file mode 100644 index 0000000..71d7a1a --- /dev/null +++ b/src/main/resources/com/tairui/app/cim/test/mapper/EntranceGuardPointMapper.xml @@ -0,0 +1,28 @@ +<?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.tairui.app.cim.test.mapper.EntranceGuardPointMapper"> + + <!-- 閫氱敤鏌ヨ鏄犲皠缁撴灉 --> + <resultMap id="BaseResultMap" type="com.tairui.app.cim.test.domain.EntranceGuardPoint"> + <id column="gid" property="gid" /> + <result column="point_id" property="pointId" /> + <result column="point_type" property="pointType" /> + <result column="org_code" property="orgCode" /> + <result column="point_name" property="pointName" /> + <result column="createuser" property="createuser" /> + <result column="createtime" property="createtime" /> + <result column="updateuser" property="updateuser" /> + <result column="updatetime" property="updatetime" /> + <result column="coor_z" property="coorZ" /> + <result column="status" property="status" /> + <result column="remarks" property="remarks" /> + <result column="bind_key" property="bindKey" /> + <result column="geom" property="geom" /> + </resultMap> + + <!-- 閫氱敤鏌ヨ缁撴灉鍒� --> + <sql id="Base_Column_List"> + gid, point_id, point_type, org_code, point_name, createuser, createtime, updateuser, updatetime, coor_z, status, remarks, bind_key, geom + </sql> + +</mapper> diff --git a/src/main/resources/com/tairui/app/cim/test/mapper/EvacuationPointMapper.xml b/src/main/resources/com/tairui/app/cim/test/mapper/EvacuationPointMapper.xml new file mode 100644 index 0000000..a246395 --- /dev/null +++ b/src/main/resources/com/tairui/app/cim/test/mapper/EvacuationPointMapper.xml @@ -0,0 +1,28 @@ +<?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.tairui.app.cim.test.mapper.EvacuationPointMapper"> + + <!-- 閫氱敤鏌ヨ鏄犲皠缁撴灉 --> + <resultMap id="BaseResultMap" type="com.tairui.app.cim.test.domain.EvacuationPoint"> + <id column="gid" property="gid" /> + <result column="point_id" property="pointId" /> + <result column="point_type" property="pointType" /> + <result column="org_code" property="orgCode" /> + <result column="point_name" property="pointName" /> + <result column="createuser" property="createuser" /> + <result column="createtime" property="createtime" /> + <result column="updateuser" property="updateuser" /> + <result column="updatetime" property="updatetime" /> + <result column="coor_z" property="coorZ" /> + <result column="status" property="status" /> + <result column="remarks" property="remarks" /> + <result column="bind_key" property="bindKey" /> + <result column="geom" property="geom" /> + </resultMap> + + <!-- 閫氱敤鏌ヨ缁撴灉鍒� --> + <sql id="Base_Column_List"> + gid, point_id, point_type, org_code, point_name, createuser, createtime, updateuser, updatetime, coor_z, status, remarks, bind_key, geom + </sql> + +</mapper> diff --git a/src/main/resources/com/tairui/app/cim/test/mapper/FireEquipmentPointMapper.xml b/src/main/resources/com/tairui/app/cim/test/mapper/FireEquipmentPointMapper.xml new file mode 100644 index 0000000..616110e --- /dev/null +++ b/src/main/resources/com/tairui/app/cim/test/mapper/FireEquipmentPointMapper.xml @@ -0,0 +1,27 @@ +<?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.tairui.app.cim.test.mapper.FireEquipmentPointMapper"> + + <!-- 閫氱敤鏌ヨ鏄犲皠缁撴灉 --> + <resultMap id="BaseResultMap" type="com.tairui.app.cim.test.domain.FireEquipmentPoint"> + <id column="gid" property="gid" /> + <result column="point_id" property="pointId" /> + <result column="point_type" property="pointType" /> + <result column="org_code" property="orgCode" /> + <result column="point_name" property="pointName" /> + <result column="createuser" property="createuser" /> + <result column="createtime" property="createtime" /> + <result column="updateuser" property="updateuser" /> + <result column="updatetime" property="updatetime" /> + <result column="coor_z" property="coorZ" /> + <result column="status" property="status" /> + <result column="remarks" property="remarks" /> + <result column="geom" property="geom" /> + </resultMap> + + <!-- 閫氱敤鏌ヨ缁撴灉鍒� --> + <sql id="Base_Column_List"> + gid, point_id, point_type, org_code, point_name, createuser, createtime, updateuser, updatetime, coor_z, status, remarks, geom + </sql> + +</mapper> diff --git a/src/main/resources/com/tairui/app/cim/test/mapper/MajorHazardsPointMapper.xml b/src/main/resources/com/tairui/app/cim/test/mapper/MajorHazardsPointMapper.xml new file mode 100644 index 0000000..cf69fec --- /dev/null +++ b/src/main/resources/com/tairui/app/cim/test/mapper/MajorHazardsPointMapper.xml @@ -0,0 +1,27 @@ +<?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.tairui.app.cim.test.mapper.MajorHazardsPointMapper"> + + <!-- 閫氱敤鏌ヨ鏄犲皠缁撴灉 --> + <resultMap id="BaseResultMap" type="com.tairui.app.cim.test.domain.MajorHazardsPoint"> + <id column="gid" property="gid" /> + <result column="point_id" property="pointId" /> + <result column="point_type" property="pointType" /> + <result column="org_code" property="orgCode" /> + <result column="point_name" property="pointName" /> + <result column="createuser" property="createuser" /> + <result column="createtime" property="createtime" /> + <result column="updateuser" property="updateuser" /> + <result column="updatetime" property="updatetime" /> + <result column="coor_z" property="coorZ" /> + <result column="status" property="status" /> + <result column="remarks" property="remarks" /> + <result column="geom" property="geom" /> + </resultMap> + + <!-- 閫氱敤鏌ヨ缁撴灉鍒� --> + <sql id="Base_Column_List"> + gid, point_id, point_type, org_code, point_name, createuser, createtime, updateuser, updatetime, coor_z, status, remarks, geom + </sql> + +</mapper> diff --git a/src/main/resources/com/tairui/app/cim/test/mapper/ToxicGasPointMapper.xml b/src/main/resources/com/tairui/app/cim/test/mapper/ToxicGasPointMapper.xml new file mode 100644 index 0000000..bed490f --- /dev/null +++ b/src/main/resources/com/tairui/app/cim/test/mapper/ToxicGasPointMapper.xml @@ -0,0 +1,28 @@ +<?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.tairui.app.cim.test.mapper.ToxicGasPointMapper"> + + <!-- 閫氱敤鏌ヨ鏄犲皠缁撴灉 --> + <resultMap id="BaseResultMap" type="com.tairui.app.cim.test.domain.ToxicGasPoint"> + <id column="gid" property="gid" /> + <result column="point_id" property="pointId" /> + <result column="point_type" property="pointType" /> + <result column="org_code" property="orgCode" /> + <result column="point_name" property="pointName" /> + <result column="createuser" property="createuser" /> + <result column="createtime" property="createtime" /> + <result column="updateuser" property="updateuser" /> + <result column="updatetime" property="updatetime" /> + <result column="coor_z" property="coorZ" /> + <result column="status" property="status" /> + <result column="remarks" property="remarks" /> + <result column="bind_key" property="bindKey" /> + <result column="geom" property="geom" /> + </resultMap> + + <!-- 閫氱敤鏌ヨ缁撴灉鍒� --> + <sql id="Base_Column_List"> + gid, point_id, point_type, org_code, point_name, createuser, createtime, updateuser, updatetime, coor_z, status, remarks, bind_key, geom + </sql> + +</mapper> diff --git a/src/test/java/com/tairui/app/DemoApplicationTests.java b/src/test/java/com/tairui/app/DemoApplicationTests.java new file mode 100644 index 0000000..1048789 --- /dev/null +++ b/src/test/java/com/tairui/app/DemoApplicationTests.java @@ -0,0 +1,13 @@ +package com.tairui.app; + +import org.junit.jupiter.api.Test; +import org.springframework.boot.test.context.SpringBootTest; + +@SpringBootTest +class DemoApplicationTests { + + @Test + void contextLoads() { + } + +} -- Gitblit v1.9.3