配置大屏新增文件

fengxiang

2018-06-25 071adf2ca6063884b095544eff17f976a258cb4d

配置大屏新增文件

 src/main/java/com/moral/entity/OrganizationLayout.java

New file
@@ -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;
    }

}

 src/main/java/com/moral/entity/OrganizationSensorUnit.java

New file
@@ -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;
}

 src/main/java/com/moral/mapper/OrganizationLayoutMapper.java

New file
@@ -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> {
}

 src/main/java/com/moral/mapper/OrganizationSensorUnitMapper.java

New file
@@ -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);
}

 src/main/resources/mapper/OrganizationLayoutMapper.xml

New file
@@ -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>

 src/main/resources/mapper/OrganizationSensorUnitMapper.xml

New file
@@ -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>

 src/main/resources/mapper/SensorUnitMapper.xml

New file
@@ -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>