From 0b193b98347b5563e59492d8f57eba8f67af6d23 Mon Sep 17 00:00:00 2001
From: liusheng <337615773@qq.com>
Date: 星期二, 27 六月 2023 11:35:54 +0800
Subject: [PATCH] 新增题目
---
smartor/src/main/java/com/smartor/service/impl/SvyLibTopicServiceImpl.java | 209 ---------------------------------------------------
1 files changed, 2 insertions(+), 207 deletions(-)
diff --git a/smartor/src/main/java/com/smartor/service/impl/SvyLibTopicServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/SvyLibTopicServiceImpl.java
index f0e7adc..655070d 100644
--- a/smartor/src/main/java/com/smartor/service/impl/SvyLibTopicServiceImpl.java
+++ b/smartor/src/main/java/com/smartor/service/impl/SvyLibTopicServiceImpl.java
@@ -34,8 +34,8 @@
@Autowired
private SvyLibTopicMapper svyLibTopicMapper;
- @Autowired
- private SvyLibTopicoptionMapper svyLibTopicoptionMapper;
+// @Autowired
+// private SvyLibTopicoptionMapper svyLibTopicoptionMapper;
/**
* 鏌ヨ闂嵎棰樼洰
@@ -103,211 +103,6 @@
@Override
public int deleteSvyLibTopicByTopicid(Long topicid) {
return svyLibTopicMapper.deleteSvyLibTopicByTopicid(topicid);
- }
-
- /**
- * 鎵归噺瀵煎叆闂棶棰樼洰
- *
- * @param multipartFile
- * @return
- */
- @Override
- @Transactional
- public List<SvyLibTopicRes> importLitTopic(SysUser user, MultipartFile multipartFile) {
- List<SvyLibTopicRes> svyLibTopicErrors = new ArrayList<>();
-
- try {
- Workbook workbook = new XSSFWorkbook(multipartFile.getInputStream());
- Sheet sheet = workbook.getSheetAt(0);
-
- //闂嵎棰樼洰瀵硅薄
- SvyLibTopic svyLibTopic = new SvyLibTopic();
-
-
- for (int i = sheet.getFirstRowNum() + 1; i < sheet.getLastRowNum(); i++) {
- SvyLibTopicRes svyLibTopicRes = new SvyLibTopicRes();
-
- Row row = sheet.getRow(i);
- //濡傛灉琛屼负绌猴紝杩涜涓嬩竴娆″惊鐜�
- if (ObjectUtils.isEmpty(row.getCell(0)) && ObjectUtils.isEmpty(row.getCell(1)) && ObjectUtils.isEmpty(row.getCell(2))) {
- continue;
- }
- //鍒ゆ柇鏁版嵁鏄惁鏈夐棶棰�
- svyLibTopicRes.setTopic(row.getCell(0).toString());
- if (ObjectUtils.isEmpty(row.getCell(0)) || StringUtils.isEmpty(row.getCell(0).toString())) {
- svyLibTopicRes.setRemark("棰樼洰涓虹┖,");
- } else {
- //鍒ゆ柇涓�涓嬭棰樻槸鍚﹀凡缁忓湪琛ㄩ噷鍑虹幇
- SvyLibTopic svyLibTopic1 = new SvyLibTopic();
- svyLibTopic1.setTopic(row.getCell(0).toString());
- List<SvyLibTopic> svyLibTopics = svyLibTopicMapper.selectSvyLibTopicList(svyLibTopic1);
- if (svyLibTopics.size() > 0) {
- //宸茬粡瀛樺湪浜嗭紝灏变笉瀛樹簡
- continue;
- }
- }
- svyLibTopicRes.setTag(row.getCell(1).toString());
- if (ObjectUtils.isEmpty(row.getCell(1)) || StringUtils.isEmpty(row.getCell(1).toString())) {
- svyLibTopicRes.setRemark(StringUtils.isNotEmpty(svyLibTopicRes.getRemark()) ? svyLibTopicRes.getRemark() : "" + "绫诲埆涓虹┖,");
- }
- svyLibTopicRes.setTopictype(row.getCell(2).toString());
- if (ObjectUtils.isEmpty(row.getCell(2)) || StringUtils.isEmpty(row.getCell(2).toString())) {
- svyLibTopicRes.setRemark(StringUtils.isNotEmpty(svyLibTopicRes.getRemark()) ? svyLibTopicRes.getRemark() : "" + "棰樼洰绫诲瀷涓虹┖,");
- }
- if (ObjectUtils.isNotEmpty(row.getCell(3))) {
- svyLibTopicRes.setAnswer(row.getCell(3).toString());
- }
- if (ObjectUtils.isNotEmpty(row.getCell(4))) {
- svyLibTopicRes.setOptionA(row.getCell(4).toString());
- }
- if (ObjectUtils.isNotEmpty(row.getCell(5))) {
- svyLibTopicRes.setOptionB(row.getCell(5).toString());
- }
- if (ObjectUtils.isNotEmpty(row.getCell(6))) {
- svyLibTopicRes.setOptionC(row.getCell(6).toString());
- }
- if (ObjectUtils.isNotEmpty(row.getCell(7))) {
- svyLibTopicRes.setOptionD(row.getCell(7).toString());
- }
- if (ObjectUtils.isNotEmpty(row.getCell(8))) {
- svyLibTopicRes.setScore(row.getCell(8).toString());
- }
- if (ObjectUtils.isNotEmpty(row.getCell(9))) {
- svyLibTopicRes.setScore(row.getCell(9).toString());
- }
- if (ObjectUtils.isNotEmpty(row.getCell(10))) {
- svyLibTopicRes.setScore(row.getCell(10).toString());
- }
- if (ObjectUtils.isNotEmpty(row.getCell(11))) {
- svyLibTopicRes.setScore(row.getCell(11).toString());
- }
- if (ObjectUtils.isNotEmpty(row.getCell(12))) {
- svyLibTopicRes.setScore(row.getCell(12).toString());
- }
- if (StringUtils.isNotEmpty(svyLibTopicRes.getRemark())) {
- //璇存槑璇ヨ鏁版嵁鏈夐棶棰�
- svyLibTopicErrors.add(svyLibTopicRes);
- continue;
- }
-
- //鏁版嵁娌℃湁闂锛屽紑濮嬫彃琛�
- svyLibTopic.setTopic(row.getCell(0).toString());
- if (row.getCell(2).toString().equals("鍗曢��")) {
- svyLibTopic.setTopictype(1L);
- } else if (row.getCell(2).toString().equals("澶氶��")) {
- svyLibTopic.setTopictype(2L);
- } else {
- svyLibTopic.setTopictype(3L);
- }
- svyLibTopic.setTopiccode(UUID.randomUUID().toString().replace("-", ""));
- //棰樼洰绫诲埆
- svyLibTopic.setTag(row.getCell(1).toString());
- svyLibTopic.setCreateBy(user.getUserName());
- svyLibTopic.setOrgid(user.getDeptId().toString());
- svyLibTopic.setUpdateBy(user.getUserName());
- svyLibTopic.setUpdateTime(new Date());
- svyLibTopic.setCreateTime(new Date());
- svyLibTopic.setDelFlag("0");
- //鏂板棰樼洰琛�
- svyLibTopicMapper.insertSvyLibTopic(svyLibTopic);
-
- //鏂板棰樼洰閫夐」琛�
- SvyLibTopicoption svyLibTopicoption = new SvyLibTopicoption();
- svyLibTopicoption.setTopicid(svyLibTopic.getTopicid());
- svyLibTopicoption.setTopictype(svyLibTopic.getTopictype());
- svyLibTopicoption.setOptioncode(UUID.randomUUID().toString().replace("-", ""));
- svyLibTopicoption.setCreateBy(user.getUserName());
- svyLibTopicoption.setCreateTime(new Date());
- svyLibTopicoption.setUpdateBy(user.getUserName());
- svyLibTopicoption.setUpdateTime(new Date());
- svyLibTopicoption.setDelFlag("0");
- if (svyLibTopicoption.getTopictype() == 3) {
- //瑙ｇ瓟棰橈紝涓嶉渶瑕佸啀璁剧疆閫夐」
- svyLibTopicoptionMapper.insertSvyLibTopicoption(svyLibTopicoption);
- } else {
- if (ObjectUtils.isNotEmpty(row.getCell(4))) {
- if (StringUtils.isNotEmpty(row.getCell(4).toString())) {
- svyLibTopicoption.setOptioncode("A");
- svyLibTopicoption.setOptioncontent(row.getCell(4).toString());
- svyLibTopicoption.setOptionid(null);
- svyLibTopicoptionMapper.insertSvyLibTopicoption(svyLibTopicoption);
- }
- }
- if (ObjectUtils.isNotEmpty(row.getCell(5))) {
- if (StringUtils.isNotEmpty(row.getCell(5).toString())) {
- svyLibTopicoption.setOptioncode("B");
- svyLibTopicoption.setOptioncontent(row.getCell(5).toString());
- svyLibTopicoption.setOptionid(null);
- svyLibTopicoptionMapper.insertSvyLibTopicoption(svyLibTopicoption);
- }
- }
- if (ObjectUtils.isNotEmpty(row.getCell(6))) {
- if (StringUtils.isNotEmpty(row.getCell(6).toString())) {
- svyLibTopicoption.setOptioncode("C");
- svyLibTopicoption.setOptioncontent(row.getCell(6).toString());
- svyLibTopicoption.setOptionid(null);
- svyLibTopicoptionMapper.insertSvyLibTopicoption(svyLibTopicoption);
- }
- }
- if (ObjectUtils.isNotEmpty(row.getCell(7))) {
- if (StringUtils.isNotEmpty(row.getCell(7).toString())) {
- svyLibTopicoption.setOptioncode("D");
- svyLibTopicoption.setOptioncontent(row.getCell(7).toString());
- svyLibTopicoption.setOptionid(null);
- svyLibTopicoptionMapper.insertSvyLibTopicoption(svyLibTopicoption);
- }
- }
- if (ObjectUtils.isNotEmpty(row.getCell(8))) {
- if (StringUtils.isNotEmpty(row.getCell(8).toString())) {
- svyLibTopicoption.setOptioncode("E");
- svyLibTopicoption.setOptioncontent(row.getCell(8).toString());
- svyLibTopicoption.setOptionid(null);
- svyLibTopicoptionMapper.insertSvyLibTopicoption(svyLibTopicoption);
- }
- }
- if (ObjectUtils.isNotEmpty(row.getCell(9))) {
- if (StringUtils.isNotEmpty(row.getCell(9).toString())) {
- svyLibTopicoption.setOptioncode("F");
- svyLibTopicoption.setOptioncontent(row.getCell(9).toString());
- svyLibTopicoption.setOptionid(null);
- svyLibTopicoptionMapper.insertSvyLibTopicoption(svyLibTopicoption);
- }
- }
- if (ObjectUtils.isNotEmpty(row.getCell(10))) {
- if (StringUtils.isNotEmpty(row.getCell(10).toString())) {
- svyLibTopicoption.setOptioncode("G");
- svyLibTopicoption.setOptioncontent(row.getCell(10).toString());
- svyLibTopicoption.setOptionid(null);
- svyLibTopicoptionMapper.insertSvyLibTopicoption(svyLibTopicoption);
- }
- }
- if (ObjectUtils.isNotEmpty(row.getCell(11))) {
- if (StringUtils.isNotEmpty(row.getCell(11).toString())) {
- svyLibTopicoption.setOptioncode("H");
- svyLibTopicoption.setOptioncontent(row.getCell(11).toString());
- svyLibTopicoption.setOptionid(null);
- svyLibTopicoptionMapper.insertSvyLibTopicoption(svyLibTopicoption);
- }
- }
- }
- }
- if (CollectionUtils.isNotEmpty(svyLibTopicErrors)) {
- return svyLibTopicErrors;
- }
-
- } catch (Exception e) {
- e.printStackTrace();
- }
-
- return null;
- }
-
- @Override
- public SvyLibTopicRes showTopic(SvyTopicReq svyTopicReq) {
- List<SvyLibTopicAndOptionRes> svyLibTopicAndOptionRes = svyLibTopicMapper.showTopic(svyTopicReq);
- Map<Long, List<SvyLibTopicAndOptionRes>> groupByAge = svyLibTopicAndOptionRes.stream().collect(Collectors.groupingBy(SvyLibTopicAndOptionRes::getTopicid));
-
- return null;
}
--
Gitblit v1.9.3