<?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.xintong.visualinspection.visuallnspection_qzd.dao.CarStatisticsDao">
    <select id="getTaskList" parameterType="com.xintong.visualinspection.bean.CarStatistics" resultType="com.xintong.visualinspection.bean.CarStatistics">
            SELECT
                i.*,
                 min( t.start_mileage ) AS start_mileage,
                max( t.end_mileage ) as end_mileage
            FROM
                `car_info` i
                LEFT JOIN car_task t ON i.id = t.car_id
            WHERE
                t.is_vaild = 0
            and i.is_vaild = 0
        <if test="start_time != null and end_time != null">and t.start_time between #{start_time} and #{end_time}</if>
            GROUP BY
                i.id
    </select>

    <select id="getMaintenanceList" parameterType="com.xintong.visualinspection.bean.CarStatistics" resultType="com.xintong.visualinspection.bean.CarStatistics">
        select
          *
        from
        car_info
        where
         id = #{id}
    </select>
</mapper>