StudentDao.java 5.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128
  1. package cn.com.qmth.scancentral.dao;
  2. import java.util.List;
  3. import org.apache.ibatis.annotations.Param;
  4. import com.baomidou.mybatisplus.core.mapper.BaseMapper;
  5. import com.baomidou.mybatisplus.core.metadata.IPage;
  6. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  7. import cn.com.qmth.scancentral.bean.AbsentQueryDomain;
  8. import cn.com.qmth.scancentral.bean.AnswerQueryDomain;
  9. import cn.com.qmth.scancentral.bean.AssignedQueryDomain;
  10. import cn.com.qmth.scancentral.entity.StudentEntity;
  11. import cn.com.qmth.scancentral.vo.AbsentInfoVo;
  12. import cn.com.qmth.scancentral.vo.AbsentQueryVo;
  13. import cn.com.qmth.scancentral.vo.AnswerExportVo;
  14. import cn.com.qmth.scancentral.vo.CampusVo;
  15. import cn.com.qmth.scancentral.vo.ExamSiteVo;
  16. import cn.com.qmth.scancentral.vo.ExportCetMarkingQueryVo;
  17. import cn.com.qmth.scancentral.vo.ExportCetVo;
  18. import cn.com.qmth.scancentral.vo.ImportStudentQueryVo;
  19. import cn.com.qmth.scancentral.vo.ImportStudentVo;
  20. import cn.com.qmth.scancentral.vo.ScanAnswerInfoVo;
  21. import cn.com.qmth.scancentral.vo.StudentUploadVo;
  22. import cn.com.qmth.scancentral.vo.answerquery.AnswerQueryParam;
  23. import cn.com.qmth.scancentral.vo.answerquery.AnswerQueryVo;
  24. import cn.com.qmth.scancentral.vo.assginedcheck.AssignedCheckExamRoomExport;
  25. import cn.com.qmth.scancentral.vo.assginedcheck.AssignedCheckExport;
  26. import cn.com.qmth.scancentral.vo.examroom.ExamRoomScannedQuery;
  27. import cn.com.qmth.scancentral.vo.examroom.ExamRoomScannedVo;
  28. import cn.com.qmth.scancentral.vo.imagecheck.ImageCheckDetailVo;
  29. import cn.com.qmth.scancentral.vo.imagecheck.ImageCheckQuery;
  30. import cn.com.qmth.scancentral.vo.imagecheck.ImageCheckVo;
  31. import cn.com.qmth.scancentral.vo.student.StudentAnswerVo;
  32. import cn.com.qmth.scancentral.vo.student.StudentExamRoomVo;
  33. import cn.com.qmth.scancentral.vo.student.StudentPageQuery;
  34. import cn.com.qmth.scancentral.vo.student.StudentPageVo;
  35. import cn.com.qmth.scancentral.vo.student.StudentVo;
  36. import cn.com.qmth.scancentral.vo.studentimport.StudentCountVo;
  37. import cn.com.qmth.scancentral.vo.subject.SubjectScanProgressVo;
  38. public interface StudentDao extends BaseMapper<StudentEntity> {
  39. List<CampusVo> listCampusByExamId(@Param("examId") Long examId);
  40. List<ExamSiteVo> listSiteByExamId(@Param("examId") Long examId);
  41. AbsentInfoVo absentInfo(@Param("examId") Long examId, @Param("groupType") String groupType,
  42. @Param("groupName") String groupName);
  43. List<String> absentQuerySummary(@Param("groupNameCol") String groupNameCol,
  44. @Param("query") AbsentQueryDomain query);
  45. IPage<AbsentQueryVo> absentQueryPage(Page<AbsentQueryVo> page, @Param("groupNameCol") String groupNameCol,
  46. @Param("query") AbsentQueryDomain query);
  47. List<AbsentQueryVo> absentExportList(Page<AbsentQueryVo> page, @Param("groupNameCol") String groupNameCol,
  48. @Param("query") AbsentQueryDomain query);
  49. IPage<AnswerQueryVo> queryPage(Page<AnswerQueryVo> page, @Param("query") AnswerQueryParam query);
  50. List<String> querySummary(@Param("query") AnswerQueryDomain query);
  51. List<AnswerExportVo> exportList(Page<AnswerQueryVo> page, @Param("query") AnswerQueryDomain query);
  52. List<StudentUploadVo> findToUpload(@Param("pageSize") Integer pageSize);
  53. List<StudentUploadVo> findUploadError(@Param("pageSize") Integer pageSize);
  54. int getPackageCountByExam(@Param("examId") Long examId);
  55. int countByQuery(@Param("query") ImportStudentQueryVo query);
  56. List<StudentCountVo> countStudent(@Param("examId") Long examId);
  57. IPage<ImportStudentVo> listPageQuery(Page<ImportStudentVo> page, @Param("query") ImportStudentQueryVo query);
  58. List<StudentUploadVo> findToPictureCopy(@Param("pageSize") Integer pageSize);
  59. int getUploadedCount(@Param("examId") Long examId);
  60. int getNeedUploadCount(@Param("examId") Long examId);
  61. int countCetMarking(@Param("query") ExportCetMarkingQueryVo query);
  62. IPage<ExportCetVo> listCetMarkingPage(Page<ExportCetVo> page, @Param("query") ExportCetMarkingQueryVo query);
  63. ScanAnswerInfoVo getInfoCountByExam(@Param("examId") Long examId);
  64. List<AssignedCheckExport> exportAssignedCheckPage(Page<AssignedCheckExport> page,
  65. @Param("query") AssignedQueryDomain query);
  66. IPage<AnswerQueryVo> queryAssignedCheckPage(Page<AnswerQueryVo> page, @Param("query") AssignedQueryDomain query);
  67. List<AnswerQueryVo> findUnCheck(@Param("examId") Long examId, @Param("pageNumber") int pageNumber,
  68. @Param("pageSize") int pageSize, @Param("checkCount") int checkCount);
  69. List<AnswerQueryVo> getAssignedCheckTaskHistory(@Param("id") Long id, @Param("pageSize") Long pageSize,
  70. @Param("userId") Long userId, @Param("examId") Long examId);
  71. void updateAssignedCheckCount(@Param("id") Long id);
  72. List<SubjectScanProgressVo> scanProgress(@Param("examId") Long examId, @Param("subjectCode") String subjectCode);
  73. IPage<ExamRoomScannedVo> examRoomScannedPage(Page<ExamRoomScannedVo> page,
  74. @Param("req") ExamRoomScannedQuery query);
  75. IPage<StudentPageVo> studentPage(Page<StudentPageVo> page, @Param("req") StudentPageQuery query);
  76. IPage<StudentVo> studentExport(Page<StudentVo> page, @Param("query") AnswerQueryDomain query);
  77. IPage<StudentExamRoomVo> studentExamRoomExport(Page<StudentExamRoomVo> page,
  78. @Param("query") AnswerQueryDomain query);
  79. List<Long> queryImageCheckWaitingList(@Param("examId") Long examId, @Param("startId") Long startId,
  80. @Param("batchSize") Integer batchSize);
  81. List<ImageCheckVo> countImageCheck(@Param("examId") Long examId);
  82. IPage<ImageCheckDetailVo> queryImageCheckDetail(Page<ImageCheckDetailVo> page,
  83. @Param("query") ImageCheckQuery query);
  84. List<AssignedCheckExamRoomExport> exportAssignedCheck(@Param("examId") Long examId,
  85. @Param("subjectCode") String subjectCode);
  86. StudentAnswerVo getStudentVo(@Param("studentId") Long studentId);
  87. }