花城E+防疫修改

101captain

2022-05-07 bb78e31de2f3b9a97fb8f50beb861cbde9cf6da0

花城E+防疫修改

 springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/resources/mapper/UserDao.xml

@@ -140,7 +140,7 @@
        AND last_login_time > DATE_FORMAT( date_sub( SYSDATE(), INTERVAL 0 DAY ), '%Y-%m-%d 00:00:00')) as dayNum
        FROM
        com_act a
        LEFT JOIN sys_user u ON a.community_id = u.community_id and u.type=1 where a.area_code = #{areaCode}
        LEFT JOIN sys_user u ON a.community_id = u.community_id and u.type=1 and a.state=0 where a.area_code = #{areaCode}
        GROUP BY a.community_id)t ORDER BY t.num desc
    </select>