app使用率接口

guoshilong

2023-06-01 035c72ea2515a68643cccb9aee7bd3a1fa0e7988

app使用率接口

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/log/mapper/SmLogManageMapper.xml

@@ -19,10 +19,10 @@
        FROM SK002.SM_LOG_MANAGE
        WHERE IS_DELETED = 0 AND SOURCE = 'APP'
        <if test="vo.startTime !=null and vo.startTime !=''">
            AND DATE_FORMAT(creat_time,'%Y-%m-%d') &gt;= #{vo.startTime}
            AND DATE_FORMAT(create_time,'%Y-%m-%d') &gt;= #{vo.startTime}
        </if>
        <if test="vo.endTime !=null and vo.endTime !=''">
            AND DATE_FORMAT(creat_time,'%Y-%m-%d') &lt;= #{vo.endTime}
            AND DATE_FORMAT(create_time,'%Y-%m-%d') &lt;= #{vo.endTime}
        </if>
        GROUP BY (CREATE_USER,to_char(create_time,'yyyy-mm-dd'),CREATE_USER)
        ) A