1.

phpcjl

2024-12-06 568a2c2fdfbc79645b310b9288f313d0bbb730ab

1.

 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