本周，本日统计

baizonghao

2023-04-03 55f7863d800839c868589b63986f6c61ef8e9815

本周，本日统计

 ycl-platform/src/main/resources/mapper/caseHandler/BaseCaseMapper.xml

@@ -312,8 +312,8 @@
        FROM
            ums_base_case
        WHERE
                YEARWEEK(
                        date_format( create_time, '%Y-%m-%d' )) = date_format( now(), '%Y-%m-%d' );
            create_time BETWEEN CONCAT( CURDATE(), ' 00:00:00' )
                AND CONCAT( CURDATE(), ' 23:59:59' );
    </select>
    <select id="weekCount" resultType="java.lang.Integer">
        SELECT
@@ -322,8 +322,8 @@
            ums_base_case
        WHERE
                YEARWEEK(
                        date_format( create_time, '%Y-%m-%d' )) = YEARWEEK(
                        now());
                        date_format( create_time, '%Y-%m-%d' ), 1) = YEARWEEK(
                        now(), 1);
    </select>
    <select id="dispatchCount" resultType="java.lang.Integer">
        select count(1)