From 071adf2ca6063884b095544eff17f976a258cb4d Mon Sep 17 00:00:00 2001
From: fengxiang <110431245@qq.com>
Date: Mon, 25 Jun 2018 16:49:10 +0800
Subject: [PATCH] 配置大屏新增文件
---
src/main/resources/mapper/OrganizationLayoutMapper.xml | 15 +++++
src/main/resources/mapper/OrganizationSensorUnitMapper.xml | 28 +++++++++
src/main/java/com/moral/entity/OrganizationSensorUnit.java | 24 ++++++++
src/main/java/com/moral/mapper/OrganizationSensorUnitMapper.java | 9 +++
src/main/java/com/moral/entity/OrganizationLayout.java | 23 +++++++
src/main/resources/mapper/SensorUnitMapper.xml | 16 +++++
src/main/java/com/moral/mapper/OrganizationLayoutMapper.java | 7 ++
7 files changed, 122 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/moral/entity/OrganizationLayout.java b/src/main/java/com/moral/entity/OrganizationLayout.java
new file mode 100644
index 0000000..ef94329
--- /dev/null
+++ b/src/main/java/com/moral/entity/OrganizationLayout.java
@@ -0,0 +1,23 @@
+package com.moral.entity;
+
+import lombok.Data;
+
+@Data
+public class OrganizationLayout {
+ private Integer id;
+
+ private Integer organizationId;
+
+ private String pageType;
+
+ private String pagePosition;
+
+ private Integer pagePositionIndex;
+
+ private String pagePositionValue;
+
+ public Integer getId() {
+ return id;
+ }
+
+}
\ No newline at end of file
diff --git a/src/main/java/com/moral/entity/OrganizationSensorUnit.java b/src/main/java/com/moral/entity/OrganizationSensorUnit.java
new file mode 100644
index 0000000..b28044e
--- /dev/null
+++ b/src/main/java/com/moral/entity/OrganizationSensorUnit.java
@@ -0,0 +1,24 @@
+package com.moral.entity;
+
+import lombok.Data;
+
+import javax.persistence.Id;
+import javax.persistence.Transient;
+import java.util.Date;
+
+@Data
+public class OrganizationSensorUnit {
+ @Id
+ private Integer id;
+
+ private Integer organizationId;
+
+ private Integer sensorUnitId;
+
+ private Date createTime;
+
+ @Transient
+ private SensorUnit sensorUnit;
+ @Transient
+ private Sensor sensor;
+}
\ No newline at end of file
diff --git a/src/main/java/com/moral/mapper/OrganizationLayoutMapper.java b/src/main/java/com/moral/mapper/OrganizationLayoutMapper.java
new file mode 100644
index 0000000..5b039ea
--- /dev/null
+++ b/src/main/java/com/moral/mapper/OrganizationLayoutMapper.java
@@ -0,0 +1,7 @@
+package com.moral.mapper;
+
+import com.moral.common.mapper.BaseMapper;
+import com.moral.entity.OrganizationLayout;
+
+public interface OrganizationLayoutMapper extends BaseMapper<OrganizationLayout> {
+}
\ No newline at end of file
diff --git a/src/main/java/com/moral/mapper/OrganizationSensorUnitMapper.java b/src/main/java/com/moral/mapper/OrganizationSensorUnitMapper.java
new file mode 100644
index 0000000..c9e893e
--- /dev/null
+++ b/src/main/java/com/moral/mapper/OrganizationSensorUnitMapper.java
@@ -0,0 +1,9 @@
+package com.moral.mapper;
+
+import com.moral.common.mapper.BaseMapper;
+import com.moral.entity.OrganizationSensorUnit;
+import java.util.List;
+
+public interface OrganizationSensorUnitMapper extends BaseMapper<OrganizationSensorUnit> {
+ public List<OrganizationSensorUnit> selectByOrgId(Integer organizationId);
+}
\ No newline at end of file
diff --git a/src/main/resources/mapper/OrganizationLayoutMapper.xml b/src/main/resources/mapper/OrganizationLayoutMapper.xml
new file mode 100644
index 0000000..b34e2e0
--- /dev/null
+++ b/src/main/resources/mapper/OrganizationLayoutMapper.xml
@@ -0,0 +1,15 @@
+<?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.mapper.OrganizationLayoutMapper" >
+ <resultMap id="BaseResultMap" type="com.moral.entity.OrganizationLayout" >
+ <id column="id" property="id" jdbcType="INTEGER" />
+ <result column="organization_id" property="organizationId" jdbcType="INTEGER" />
+ <result column="page_type" property="pageType" jdbcType="VARCHAR" />
+ <result column="page_position" property="pagePosition" jdbcType="VARCHAR" />
+ <result column="page_position_index" property="pagePositionIndex" jdbcType="INTEGER" />
+ <result column="page_position_value" property="pagePositionValue" jdbcType="VARCHAR" />
+ </resultMap>
+ <sql id="Base_Column_List" >
+ id, organization_id, page_type, page_position, page_position_index, page_position_value
+ </sql>
+</mapper>
\ No newline at end of file
diff --git a/src/main/resources/mapper/OrganizationSensorUnitMapper.xml b/src/main/resources/mapper/OrganizationSensorUnitMapper.xml
new file mode 100644
index 0000000..bb9e030
--- /dev/null
+++ b/src/main/resources/mapper/OrganizationSensorUnitMapper.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.moral.mapper.OrganizationSensorUnitMapper" >
+ <resultMap id="BaseResultMap" type="com.moral.entity.OrganizationSensorUnit" >
+ <id column="id" property="id" jdbcType="INTEGER" />
+ <result column="organization_id" property="organizationId" jdbcType="INTEGER" />
+ <result column="sensor_unit_id" property="sensorUnitId" jdbcType="INTEGER" />
+ <result column="create_time" property="createTime" jdbcType="TIMESTAMP" />
+ <association property="sensorUnit" javaType="com.moral.entity.SensorUnit">
+ <id column="sensor_unit_id" property="id" jdbcType="INTEGER" />
+ <result column="sut_sensor_id" property="sensorId" jdbcType="INTEGER" />
+ <result column="sut_name" property="name" jdbcType="VARCHAR" />
+ <result column="sut_rules" property="rules" jdbcType="VARCHAR" />
+ </association>
+ </resultMap>
+ <sql id="Base_Column_List" >
+ id, organization_id, sensor_unit_id, create_time, update_time
+ </sql>
+ <select id="selectByOrgId" resultMap="BaseResultMap">
+ SELECT osu.*,
+ sut.sensor_id as sut_sensor_id,
+ sut.`name` as sut_name,
+ sut.`rules` as sut_rules
+ from organization_sensor_unit osu
+ left join sensor_unit sut on osu.sensor_unit_id = sut.id
+ where osu.organization_id = #{organizationId,jdbcType=INTEGER}
+ </select>
+</mapper>
\ No newline at end of file
diff --git a/src/main/resources/mapper/SensorUnitMapper.xml b/src/main/resources/mapper/SensorUnitMapper.xml
new file mode 100644
index 0000000..2fc812d
--- /dev/null
+++ b/src/main/resources/mapper/SensorUnitMapper.xml
@@ -0,0 +1,16 @@
+<?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.mapper.SensorUnitMapper" >
+ <resultMap id="BaseResultMap" type="com.moral.entity.SensorUnit" >
+ <id column="id" property="id" jdbcType="INTEGER" />
+ <result column="sensor_id" property="sensorId" jdbcType="INTEGER" />
+ <result column="name" property="name" jdbcType="VARCHAR" />
+ <result column="rules" property="rules" jdbcType="VARCHAR" />
+ <result column="is_delete" property="isDelete" jdbcType="BIT" />
+ <result column="create_time" property="createTime" jdbcType="TIMESTAMP" />
+ <result column="update_time" property="updateTime" jdbcType="TIMESTAMP" />
+ </resultMap>
+ <sql id="Base_Column_List" >
+ id, sensor_id, name, rules, is_delete, create_time, update_time
+ </sql>
+</mapper>
\ No newline at end of file
--
Gitblit v1.8.0