修改小程序三说会堂专家列表报错

lidongdong

2023-07-18 b313c1c78e65726f59072b7a94a8f27e4c96b06d

修改小程序三说会堂专家列表报错

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/ComSanShuoExpertApi.java

@@ -146,7 +146,8 @@
    @GetMapping("/expertShowList")
    public R expertShowList(@RequestParam(value = "level",required = false)Integer level,
                            @RequestParam(value = "id",required = false)Long id){
        return comSanShuoExpertService.expertShowList(level,id,userService.detailUser(this.getUserId()).getData().getAppId());
//        return comSanShuoExpertService.expertShowList(level,id,userService.detailUser(this.getUserId()).getData().getAppId());
        return comSanShuoExpertService.expertShowList(level,id,getAppId());
    }

    /**

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

@@ -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) {
            //获取成功率