<selectid="getDataByMetricIdsAndTimeList"resultMap="MetricDataMap"resultType="map">
SELECT
DATE_FORMAT(mdt.measure_time,'%Y-%m-%d %H:%i:%s') measure_time
, mdt.metric_code,mdt.`value`,mdt.producer_code,mdt.device_sn,
mdt.channel,mdt.metric_id
FROM
metric_data_t mdt
<where><iftest="startTime != null"><![CDATA[AND mdt.measure_time >= #{startTime,jdbcType=VARCHAR}]]></if><iftest="endTime != null"><![CDATA[AND mdt.measure_time <= #{endTime,jdbcType=VARCHAR}]]></if><iftest="metricIds != null">
AND mdt.metric_id in (
<foreachcollection="metricIds"item="metricId"index="index"separator=",">
#{metricId,jdbcType=BIGINT}
</foreach>
)
</if></where>
ORDER BY mdt.measure_time
</select>
<selectid="getRoadStakeListByRoadIds"resultMap="RoadStakeMap"parameterType="map">
SELECT
<includerefid="RoadInfo_Stake"/>
FROM bs_road_stake_info_t AS RoadStake
<where><iftest="roadIds != null and roadIds.size() > 0">
RoadStake.road_id IN
<foreachitem="item"index="index"collection="roadIds"open="("separator=","close=")">
${item}
</foreach></if></where></select>