From 5b2eb84c4eb4ba5016b782b7b083585d0ee7d2d9 Mon Sep 17 00:00:00 2001 From: xuhy <3313886187@qq.com> Date: 星期三, 15 一月 2025 19:58:17 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- 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 f74199c..a59d351 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 @@ -11,7 +11,7 @@ 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 + LEFT JOIN t_technician_subscribe tts ON tt.id = tts.technician_id LEFT JOIN t_technician_score ttsc ON ttsc.technician_id = tt.id WHERE tt.`status` = 2 -- Gitblit v1.7.1