feat(appointment): 添加访客预约系统敏感词库功能

longz

2026-06-02 937f99a139bedbacdf15e25cfd55aa592f56082c

 backend/src/main/java/com/sinata/appointment/service/DashboardApplicationService.java

@@ -55,8 +55,8 @@
        vo.setDailyDate(format(dailyDate));
        vo.setDailyAppointmentCount(countAppointments(dailyDate, dailyDate, null));
        vo.setTotalAppointmentCount(countAppointments(range.startDate(), range.endDate(), null));
        vo.setRegisteredUserCount(countRegisteredUsers());
        vo.setEmployeeCount(countEmployees());
        vo.setRegisteredUserCount(countRegisteredUsers(range.startDate(), range.endDate()));
        vo.setEmployeeCount(countEmployees(range.startDate(), range.endDate()));
        return vo;
    }

@@ -203,15 +203,22 @@
        return result;
    }

    private long countRegisteredUsers() {
        return mpUserMapper.selectCount(new LambdaQueryWrapper<MpUser>().eq(MpUser::getDelFlag, 0));
    }

    private long countEmployees() {
    private long countRegisteredUsers(LocalDate startDate, LocalDate endDate) {
        return mpUserMapper.selectCount(
                new LambdaQueryWrapper<MpUser>()
                        .eq(MpUser::getDelFlag, 0)
                        .eq(MpUser::getUserType, MiniUserType.EMPLOYEE));
                        .eq(MpUser::getUserType, MiniUserType.VISITOR)
                        .ge(MpUser::getCreateTime, atStartOfDay(startDate))
                        .lt(MpUser::getCreateTime, atStartOfNextDay(endDate)));
    }

    private long countEmployees(LocalDate startDate, LocalDate endDate) {
        return mpUserMapper.selectCount(
                new LambdaQueryWrapper<MpUser>()
                        .eq(MpUser::getDelFlag, 0)
                        .eq(MpUser::getUserType, MiniUserType.EMPLOYEE)
                        .ge(MpUser::getCreateTime, atStartOfDay(startDate))
                        .lt(MpUser::getCreateTime, atStartOfNextDay(endDate)));
    }

    private DateRange resolveRange(LocalDate startDate, LocalDate endDate) {