From dc76e8f73c7ff963d7cf47b6f533314a58db36ac Mon Sep 17 00:00:00 2001
From: chen_xi <276999030@qq.com>
Date: Thu, 17 Nov 2022 09:15:23 +0800
Subject: [PATCH] 风场接口
---
screen-api/src/main/java/com/moral/api/mapper/WindModelMapper.java | 22 +++++++
screen-api/src/main/resources/mapper/WindModelMapper.xml | 20 ++++++
screen-api/src/main/java/com/moral/api/entity/WindModel.java | 37 ++++++++++++
screen-api/src/main/java/com/moral/api/service/impl/WindModelServiceImpl.java | 37 ++++++++++++
screen-api/src/main/java/com/moral/api/service/WindModelService.java | 21 +++++++
5 files changed, 137 insertions(+), 0 deletions(-)
diff --git a/screen-api/src/main/java/com/moral/api/entity/WindModel.java b/screen-api/src/main/java/com/moral/api/entity/WindModel.java
new file mode 100644
index 0000000..8aaa11e
--- /dev/null
+++ b/screen-api/src/main/java/com/moral/api/entity/WindModel.java
@@ -0,0 +1,37 @@
+package com.moral.api.entity;
+
+import com.baomidou.mybatisplus.annotation.IdType;
+import com.baomidou.mybatisplus.extension.activerecord.Model;
+import com.baomidou.mybatisplus.annotation.TableId;
+import java.io.Serializable;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+
+/**
+ * <p>
+ *
+ * </p>
+ *
+ * @author moral
+ * @since 2022-08-04
+ */
+@Data
+@EqualsAndHashCode(callSuper = false)
+public class WindModel extends Model<WindModel> {
+
+ private static final long serialVersionUID = 1L;
+
+ @TableId(value = "id", type = IdType.AUTO)
+ private Integer id;
+
+ private String json;
+
+ private String value;
+
+
+ @Override
+ protected Serializable pkVal() {
+ return this.id;
+ }
+
+}
diff --git a/screen-api/src/main/java/com/moral/api/mapper/WindModelMapper.java b/screen-api/src/main/java/com/moral/api/mapper/WindModelMapper.java
new file mode 100644
index 0000000..14ce27a
--- /dev/null
+++ b/screen-api/src/main/java/com/moral/api/mapper/WindModelMapper.java
@@ -0,0 +1,22 @@
+package com.moral.api.mapper;
+
+import com.moral.api.entity.WindModel;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import org.apache.ibatis.annotations.Param;
+
+import java.util.List;
+import java.util.Map;
+
+/**
+ * <p>
+ * Mapper ������
+ * </p>
+ *
+ * @author moral
+ * @since 2022-08-04
+ */
+public interface WindModelMapper extends BaseMapper<WindModel> {
+
+ List<Map<String,Object>> selectWindModel(@Param("map") Map map);
+
+}
diff --git a/screen-api/src/main/java/com/moral/api/service/WindModelService.java b/screen-api/src/main/java/com/moral/api/service/WindModelService.java
new file mode 100644
index 0000000..0988702
--- /dev/null
+++ b/screen-api/src/main/java/com/moral/api/service/WindModelService.java
@@ -0,0 +1,21 @@
+package com.moral.api.service;
+
+import com.moral.api.entity.WindModel;
+import com.baomidou.mybatisplus.extension.service.IService;
+
+import java.util.List;
+import java.util.Map;
+
+/**
+ * <p>
+ * ���������
+ * </p>
+ *
+ * @author moral
+ * @since 2022-08-04
+ */
+public interface WindModelService extends IService<WindModel> {
+
+ List<Map<String,Object>> selectWindModel();
+
+}
diff --git a/screen-api/src/main/java/com/moral/api/service/impl/WindModelServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/WindModelServiceImpl.java
new file mode 100644
index 0000000..1c65563
--- /dev/null
+++ b/screen-api/src/main/java/com/moral/api/service/impl/WindModelServiceImpl.java
@@ -0,0 +1,37 @@
+package com.moral.api.service.impl;
+
+import com.moral.api.entity.WindModel;
+import com.moral.api.mapper.WindModelMapper;
+import com.moral.api.service.WindModelService;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+
+import java.util.HashMap;
+import java.util.List;
+import java.util.Map;
+
+/**
+ * <p>
+ * ���������������
+ * </p>
+ *
+ * @author moral
+ * @since 2022-08-04
+ */
+@Service
+public class WindModelServiceImpl extends ServiceImpl<WindModelMapper, WindModel> implements WindModelService {
+
+ @Autowired
+ private WindModelMapper windModelMapper;
+
+ @Override
+ public List<Map<String, Object>> selectWindModel() {
+ Map<String,Object> map = new HashMap<>();
+ map.put("p5dna7a0390001",146);
+ map.put("p5dna7a0390002",140);
+ List<Map<String, Object>> maps = windModelMapper.selectWindModel(map);
+ System.out.println(maps);
+ return null;
+ }
+}
diff --git a/screen-api/src/main/resources/mapper/WindModelMapper.xml b/screen-api/src/main/resources/mapper/WindModelMapper.xml
new file mode 100644
index 0000000..3e9f9e1
--- /dev/null
+++ b/screen-api/src/main/resources/mapper/WindModelMapper.xml
@@ -0,0 +1,20 @@
+<?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.moral.api.mapper.WindModelMapper">
+
+ <!-- ������������������������ -->
+ <resultMap id="BaseResultMap" type="com.moral.api.entity.WindModel">
+ <id column="id" property="id" />
+ <result column="json" property="json" />
+ <result column="value" property="value" />
+ </resultMap>
+
+ <select id="selectWindModel" resultType="java.util.Map">
+ select * from wind_model
+ <where>
+ <foreach collection="map.entrySet()" item="value" index="key">
+ AND ABS((select JSON_EXTRACT(json, '$.${key}') FROM wind_model)-#{value})<![CDATA[<]]>10
+ </foreach>
+ </where>
+ </select>
+</mapper>
\ No newline at end of file
--
Gitblit v1.8.0