target/classes/mybatis/system/CarReportMapper.xml

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?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.ruoyi.project.system.report.mapper.CarReportMapper">

    <select id="selecCarReportByByMonth" parameterType="com.ruoyi.project.system.report.domain.CarReport"
            resultType="com.ruoyi.project.system.report.domain.CarReport">


        <choose>
            <when test="params.showType  ==1">
                SELECT carNumber,count(carNumber) as num
                FROM oa_sysordertable
                WHERE (YEAR(operationTime) = YEAR(CURDATE()) AND MONTH(operationTime) = MONTH(CURDATE()))
                and oa_sysordertable.orderStatus!=0

                GROUP BY carNumber
                ORDER BY num desc

            </when>
            <when test="params.showType ==2">

                SELECT
                carNumber,
                SUM(
                CASE
                WHEN DATEDIFF(endTime, starTime) >= 0 THEN
                DATEDIFF(endTime, starTime)
                ELSE
                0
                END
                ) AS num

                FROM
                oa_sysordertable
                WHERE

                operationTime BETWEEN DATE_FORMAT(CURDATE(), '%Y-%m-01') AND CURDATE()
                and oa_sysordertable.orderStatus!=0

                GROUP BY carNumber
                ORDER BY num desc
            </when>

        </choose>


    </select>
    <select id="selecCarReportByHalfYear"  parameterType="com.ruoyi.project.system.report.domain.CarReport" resultType="com.ruoyi.project.system.report.domain.CarReport">
        <choose>
            <when test="params.showType  ==1">
                SELECT carNumber,count(carNumber) as num
                FROM oa_sysordertable
                where operationTime between DATE_SUB(CURDATE(), INTERVAL 6 MONTH) and now()
                and oa_sysordertable.orderStatus!=0
                GROUP BY carNumber
                ORDER BY num desc;

            </when>