From 5208d39b2adecd65a56a7d55b8cfd7ef076eb9dc Mon Sep 17 00:00:00 2001
From: xiangpei <xiangpei@timesnew.cn>
Date: 星期五, 12 七月 2024 13:39:49 +0800
Subject: [PATCH] 获取会议学员接口
---
src/main/java/com/ycl/jxkg/mapper/ClassesMapper.java | 3 +
src/main/java/com/ycl/jxkg/service/ClassesService.java | 1
src/main/java/com/ycl/jxkg/mapper/MeetMapper.java | 11 +++++
src/main/java/com/ycl/jxkg/service/MeetService.java | 9 ++++
src/main/java/com/ycl/jxkg/controller/admin/ClassesController.java | 1
src/main/java/com/ycl/jxkg/domain/vo/StudentSimpleVO.java | 24 ++++++++++++
src/main/java/com/ycl/jxkg/service/impl/ClassesServiceImpl.java | 2 +
src/main/resources/mapper/MeetMapper.xml | 11 +++++
src/main/java/com/ycl/jxkg/controller/admin/MeetController.java | 7 +++
src/main/java/com/ycl/jxkg/service/impl/MeetServiceImpl.java | 7 +++
10 files changed, 76 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/ycl/jxkg/controller/admin/ClassesController.java b/src/main/java/com/ycl/jxkg/controller/admin/ClassesController.java
index 90336bf..436c59a 100644
--- a/src/main/java/com/ycl/jxkg/controller/admin/ClassesController.java
+++ b/src/main/java/com/ycl/jxkg/controller/admin/ClassesController.java
@@ -99,4 +99,5 @@
public Result myClassList() {
return classesService.myClassList();
}
+
}
diff --git a/src/main/java/com/ycl/jxkg/controller/admin/MeetController.java b/src/main/java/com/ycl/jxkg/controller/admin/MeetController.java
index 2882416..5ba1a30 100644
--- a/src/main/java/com/ycl/jxkg/controller/admin/MeetController.java
+++ b/src/main/java/com/ycl/jxkg/controller/admin/MeetController.java
@@ -77,4 +77,11 @@
return meetService.all();
}
+ @GetMapping("/students/{meetId}")
+ @PreAuthorize("hasAuthority('classes:students')")
+ @ApiOperation(value = "鏌ユ壘鐝骇瀛︾敓", notes = "鏌ユ壘鐝骇瀛︾敓")
+ public Result getStudentList(@PathVariable("meetId") Integer meetId, String keyword) {
+ return meetService.getStudentList(meetId, keyword);
+ }
+
}
diff --git a/src/main/java/com/ycl/jxkg/domain/vo/StudentSimpleVO.java b/src/main/java/com/ycl/jxkg/domain/vo/StudentSimpleVO.java
new file mode 100644
index 0000000..193d499
--- /dev/null
+++ b/src/main/java/com/ycl/jxkg/domain/vo/StudentSimpleVO.java
@@ -0,0 +1,24 @@
+package com.ycl.jxkg.domain.vo;
+
+import lombok.Data;
+
+/**
+ * 浼氳瀛︾敓鏁版嵁
+ *
+ * @author锛歺p
+ * @date锛�2024/7/11 14:58
+ */
+@Data
+public class StudentSimpleVO {
+
+ private Integer id;
+
+ private String realName;
+
+ /**
+ * 浼氳鍦ㄧ嚎鐘舵�侊細0绂荤嚎 1鍦ㄧ嚎 杩斿洖鏁版嵁閮芥槸绂荤嚎锛屽墠绔垽鏂湪绾�
+ *
+ */
+ private Integer onlineStatus = 0;
+
+}
diff --git a/src/main/java/com/ycl/jxkg/mapper/ClassesMapper.java b/src/main/java/com/ycl/jxkg/mapper/ClassesMapper.java
index 7b5f3f9..b34fdf0 100644
--- a/src/main/java/com/ycl/jxkg/mapper/ClassesMapper.java
+++ b/src/main/java/com/ycl/jxkg/mapper/ClassesMapper.java
@@ -6,6 +6,9 @@
import com.ycl.jxkg.domain.query.ClassesQuery;
import com.ycl.jxkg.domain.vo.ClassesVO;
import java.util.List;
+
+import com.ycl.jxkg.domain.vo.StudentSimpleVO;
+import com.ycl.jxkg.domain.vo.StudentVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
diff --git a/src/main/java/com/ycl/jxkg/mapper/MeetMapper.java b/src/main/java/com/ycl/jxkg/mapper/MeetMapper.java
index d074aa8..8f1e15c 100644
--- a/src/main/java/com/ycl/jxkg/mapper/MeetMapper.java
+++ b/src/main/java/com/ycl/jxkg/mapper/MeetMapper.java
@@ -5,8 +5,11 @@
import com.ycl.jxkg.domain.entity.Meet;
import com.ycl.jxkg.domain.query.MeetQuery;
import com.ycl.jxkg.domain.vo.MeetVO;
+import com.ycl.jxkg.domain.vo.StudentSimpleVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
+
+import java.util.List;
/**
* 浼氳琛� Mapper 鎺ュ彛
@@ -29,4 +32,12 @@
*/
IPage getPage(IPage page, @Param("query") MeetQuery query);
+ /**
+ * 鑾峰彇浼氳瀵瑰簲鐝骇鐨勫鐢熷垪琛�
+ *
+ * @param meetId 浼氳ID
+ * @param keyword 鎼滅储
+ * @return
+ */
+ List<StudentSimpleVO> getStudentList(@Param("meetId") Integer meetId, @Param("keyword") String keyword);
}
diff --git a/src/main/java/com/ycl/jxkg/service/ClassesService.java b/src/main/java/com/ycl/jxkg/service/ClassesService.java
index fb42511..3468cf5 100644
--- a/src/main/java/com/ycl/jxkg/service/ClassesService.java
+++ b/src/main/java/com/ycl/jxkg/service/ClassesService.java
@@ -93,4 +93,5 @@
* @return
*/
Result recover(Integer id);
+
}
diff --git a/src/main/java/com/ycl/jxkg/service/MeetService.java b/src/main/java/com/ycl/jxkg/service/MeetService.java
index 1087fe7..4feef5c 100644
--- a/src/main/java/com/ycl/jxkg/service/MeetService.java
+++ b/src/main/java/com/ycl/jxkg/service/MeetService.java
@@ -66,4 +66,13 @@
Result studentPage(MeetQuery query);
Result start(MeetForm form);
+
+ /**
+ * 鑾峰彇瀛︾敓鍒楄〃
+ *
+ * @param meetId 浼氳ID
+ * @param keyword 鎼滅储
+ * @return
+ */
+ Result getStudentList(Integer meetId, String keyword);
}
diff --git a/src/main/java/com/ycl/jxkg/service/impl/ClassesServiceImpl.java b/src/main/java/com/ycl/jxkg/service/impl/ClassesServiceImpl.java
index 2f06ffd..94a5c85 100644
--- a/src/main/java/com/ycl/jxkg/service/impl/ClassesServiceImpl.java
+++ b/src/main/java/com/ycl/jxkg/service/impl/ClassesServiceImpl.java
@@ -5,6 +5,8 @@
import com.baomidou.mybatisplus.extension.conditions.update.LambdaUpdateChainWrapper;
import com.ycl.jxkg.context.WebContext;
import com.ycl.jxkg.domain.entity.Classes;
+import com.ycl.jxkg.domain.vo.StudentSimpleVO;
+import com.ycl.jxkg.domain.vo.StudentVO;
import com.ycl.jxkg.enums.general.ClassesStatusEnum;
import com.ycl.jxkg.mapper.ClassesMapper;
import com.ycl.jxkg.service.ClassesService;
diff --git a/src/main/java/com/ycl/jxkg/service/impl/MeetServiceImpl.java b/src/main/java/com/ycl/jxkg/service/impl/MeetServiceImpl.java
index 91d30cb..548338d 100644
--- a/src/main/java/com/ycl/jxkg/service/impl/MeetServiceImpl.java
+++ b/src/main/java/com/ycl/jxkg/service/impl/MeetServiceImpl.java
@@ -14,6 +14,7 @@
import com.ycl.jxkg.domain.form.MeetForm;
import com.ycl.jxkg.domain.query.MeetQuery;
import com.ycl.jxkg.domain.vo.MeetVO;
+import com.ycl.jxkg.domain.vo.StudentSimpleVO;
import com.ycl.jxkg.enums.MeetStatusEnum;
import com.ycl.jxkg.mapper.ClassesUserMapper;
import com.ycl.jxkg.mapper.MeetMapper;
@@ -222,6 +223,12 @@
return Result.ok().data(vos);
}
+ @Override
+ public Result getStudentList(Integer meetId, String keyword) {
+ List<StudentSimpleVO> studentList = baseMapper.getStudentList(meetId, keyword);
+ return Result.ok().data(studentList);
+ }
+
/**
* 鍙戦�乵q娑堟伅
*
diff --git a/src/main/resources/mapper/MeetMapper.xml b/src/main/resources/mapper/MeetMapper.xml
index 44fbee2..6cd5068 100644
--- a/src/main/resources/mapper/MeetMapper.xml
+++ b/src/main/resources/mapper/MeetMapper.xml
@@ -64,4 +64,15 @@
</where>
</select>
+ <select id="getStudentList" resultType="com.ycl.jxkg.domain.vo.StudentSimpleVO">
+ SELECT
+ s.real_name, s.id
+ FROM
+ t_meet m
+ INNER JOIN t_classes c ON m.classes_id = c.id AND m.id = #{meetId} AND c.deleted = 0 AND m.deleted = 0
+ INNER JOIN t_classes_user cu ON cu.classes_id = c.id AND cu.deleted = 0
+ INNER JOIN t_user s ON s.id = cu.user_id AND s.deleted = 0
+ <if test="keyword != null and keyword != ''">AND s.real_name like concat('%', #{keyword}, '%')</if>
+ </select>
+
</mapper>
--
Gitblit v1.8.0