6.9新增登录失败冻结逻辑

liujie

2025-06-09 70d2a5d0f9c6951b2d4cac954041ed73582ff7eb

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComSanShuoExpertServiceImpl.java

@@ -241,7 +241,7 @@
     * */
    @Override
    public R expertRange(LoginUserInfoVO loginUserInfo) {
        if (nonNull(loginUserInfo)){
//        if (loginUserInfo!=null){
            if (loginUserInfo.getAccount().equals("zhengfawei") || loginUserInfo.getAccount().equals("admin")){
                List<ExpertRangeVO> list=new ArrayList<>();
                for (int i = 1; i < 5; i++) {
@@ -305,8 +305,8 @@
                list.add(vo);
                return R.ok(list);
            }
        }
        return R.fail();
//        }
        return R.ok("测试陈宫:"+loginUserInfo.getUserType());
    }

    /**
@@ -363,10 +363,8 @@
                wrapper.eq("id",id );
            }
        }
//        wrapper.orderByDesc("(select count(*) FROM com_sanshuo_event_info where specialist_id=com_sanshuo_expert.id and event_process_status=6 and event_result=2)/(select count(*) FROM com_sanshuo_event_info where specialist_id=com_sanshuo_expert.id and event_process_status=6 ) ");
//        wrapper.orderByDesc("(select count(*) FROM com_sanshuo_event_info where specialist_id=com_sanshuo_expert.id and event_process_status=6 )");
//        wrapper.orderByDesc("(select count(*) FROM com_sanshuo_event_info LEFT JOIN com_sanshuo_expert on  specialist_id=com_sanshuo_expert.id  where event_process_status=6 and event_result=2)/(select count(*) FROM com_sanshuo_event_info LEFT JOIN com_sanshuo_expert on  specialist_id=com_sanshuo_expert.id  where event_process_status=6 ) ");
//        wrapper.orderByDesc("(select count(*) FROM com_sanshuo_event_info LEFT JOIN com_sanshuo_expert on  specialist_id=com_sanshuo_expert.id where event_process_status=6 )");
        wrapper.orderByDesc("(select count(*) FROM com_sanshuo_event_info where specialist_id=com_sanshuo_expert.id and event_process_status=6 and event_result=2)/(select count(*) FROM com_sanshuo_event_info where specialist_id=com_sanshuo_expert.id and event_process_status=6 ) ");
        wrapper.orderByDesc("(select count(*) FROM com_sanshuo_event_info where specialist_id=com_sanshuo_expert.id and event_process_status=6 )");
        List<ComSanshuoExpert> comSanshuoExperts = comSanshuoExpertDao.selectList(wrapper);
        for (ComSanshuoExpert comSanshuoExpert : comSanshuoExperts) {
            //获取成功率