fix(mapper): 更新 HappyActivityOptionMapper 映射逻辑

Administrator

5 days ago 5b61384b8db46b9412425cb10f1247ddfc3da706

fix(mapper): 更新 HappyActivityOptionMapper 映射逻辑

-将 join_cnt 字段的查询方式改为子查询，以获取准确的参与人数
- 优化了 SQL 查询性能和准确性

 src/main/resources/mapper/modules/HappyActivityOptionMapper.xml

@@ -11,7 +11,7 @@
            a.type,
            a.name,
            a.state,
            a.join_cnt,
            (select count(id) from happy_follow where source_id = a.id) as join_cnt,
            a.start_time,
            a.end_time
        from happy_activity a