From 568a2c2fdfbc79645b310b9288f313d0bbb730ab Mon Sep 17 00:00:00 2001
From: phpcjl <phpcjl@gmail.com>
Date: 星期五, 06 十二月 2024 18:31:18 +0800
Subject: [PATCH] 1.
---
ruoyi-service/ruoyi-other/src/main/resources/mapper/other/TechnicianMapper.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/ruoyi-service/ruoyi-other/src/main/resources/mapper/other/TechnicianMapper.xml b/ruoyi-service/ruoyi-other/src/main/resources/mapper/other/TechnicianMapper.xml
index af52346..c20eb67 100644
--- a/ruoyi-service/ruoyi-other/src/main/resources/mapper/other/TechnicianMapper.xml
+++ b/ruoyi-service/ruoyi-other/src/main/resources/mapper/other/TechnicianMapper.xml
@@ -8,7 +8,7 @@
tt.introduction,
tt.home_picture,
COUNT(tts.id) AS serviceCount,
- AVG(ttsc.score) AS score
+ AVG( IFNULL(ttsc.score,0) ) AS score
FROM
t_technician tt
LEFT JOIN t_technician_subscribe tts ON tt.id = tts.technician_id and tts.`status` != 0
--
Gitblit v1.7.1