From 79882e3330a0f083686199c486f3d241387084c2 Mon Sep 17 00:00:00 2001
From: lidongdong <1459917685@qq.com>
Date: 星期二, 18 七月 2023 11:27:54 +0800
Subject: [PATCH] 修改小程序三说会堂专家列表报错
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComSanShuoExpertServiceImpl.java | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComSanShuoExpertServiceImpl.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComSanShuoExpertServiceImpl.java
index 40f83a7..0e7f446 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComSanShuoExpertServiceImpl.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComSanShuoExpertServiceImpl.java
@@ -365,8 +365,8 @@
}
// 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 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 )");
List<ComSanshuoExpert> comSanshuoExperts = comSanshuoExpertDao.selectList(wrapper);
for (ComSanshuoExpert comSanshuoExpert : comSanshuoExperts) {
//获取成功率
--
Gitblit v1.7.1