优化

liuhaonan

2022-07-27 e9e2230b41133c2e1821fa096fb1acf30c4d5698

优化

 dao/src/main/java/com/sandu/ximon/dao/mapper/LightReportErrorMapper.java

@@ -20,6 +20,8 @@
     * @return 故障码列表
     */
    List<LightReportErrorBo> listReportError(String keyword, Integer error_code, Long userid);

    List<LightReportErrorBo> listError(Long userid);
}



 dao/src/main/resources/mapper/LightReportErrorMapper.xml

@@ -42,4 +42,19 @@
        </where>
        ORDER BY t1.light_report_error_id DESC
    </select>
    <select id="listError" resultType="com.sandu.ximon.dao.bo.LightReportErrorBo"
            parameterType="java.lang.Long">
        SELECT
            t1.*
        FROM
            light_report_error t1
                LEFT JOIN pole t3 ON t1.device_code = t3.device_code
        WHERE
            <if test="userid != null">
                t3.client_id = #{userId} OR t3.user_id = #{userId}
                </if>
            t1.light_report_error_id IN ( SELECT t.max_id FROM ( SELECT Max( light_report_error.light_report_error_id ) AS max_id FROM light_report_error GROUP BY light_report_error.device_code ) AS t )
        ORDER BY
            t1.create_time DESC
    </select>
</mapper>