| | |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.zhitan.dataitem.mapper.DataItemMapper"> |
| | | <resultMap type="StagseDataEntry" id="stagseDataEntryResult"> |
| | | <resultMap type="com.zhitan.dataitem.domain.StagseDataEntry" id="stagseDataEntryResult"> |
| | | <result property="code" column="code"/> |
| | | <result property="name" column="name"/> |
| | | <result property="indexId" column="index_id"/> |
| | |
| | | <result property="dataTime" column="data_time"/> |
| | | </resultMap> |
| | | |
| | | <select id="getSettingIndex" parameterType="StagseDataEntry" resultMap="stagseDataEntryResult"> |
| | | <select id="getSettingIndex" parameterType="com.zhitan.dataitem.domain.StagseDataEntry" resultMap="stagseDataEntryResult"> |
| | | |
| | | SELECT |
| | | ei.index_id, |
| | |
| | | and si.time_type = #{timeType} |
| | | AND si.calc_type = #{calcType} |
| | | </select> |
| | | <select id="getSettingEdit" parameterType="StagseDataEntry" resultMap="stagseDataEntryResult"> |
| | | <select id="getSettingEdit" parameterType="com.zhitan.dataitem.domain.StagseDataEntry" resultMap="stagseDataEntryResult"> |
| | | SELECT |
| | | ei.index_id, |
| | | code, |
| | |
| | | AND data_time >= #{beginTime} |
| | | AND data_time <= #{endTime} |
| | | </select> |
| | | <select id="stagseDataByCode" parameterType="StagseDataEntry" resultMap="stagseDataEntryResult"> |
| | | <select id="stagseDataByCode" parameterType="com.zhitan.dataitem.domain.StagseDataEntry" resultMap="stagseDataEntryResult"> |
| | | SELECT |
| | | ei.index_id, |
| | | code, |