WfTextbookSubscriptionServiceImpl.java 24 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467
  1. package com.xjrsoft.module.textbook.service.impl;
  2. import cn.dev33.satoken.stp.StpUtil;
  3. import cn.hutool.core.bean.BeanUtil;
  4. import com.alibaba.excel.EasyExcel;
  5. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
  6. import com.baomidou.mybatisplus.core.toolkit.Wrappers;
  7. import com.github.yulichang.base.MPJBaseServiceImpl;
  8. import com.github.yulichang.wrapper.MPJLambdaWrapper;
  9. import com.xjrsoft.common.enums.DeleteMark;
  10. import com.xjrsoft.common.utils.VoToColumnUtil;
  11. import com.xjrsoft.module.base.entity.BaseClass;
  12. import com.xjrsoft.module.base.entity.BaseCourseSubject;
  13. import com.xjrsoft.module.base.mapper.BaseClassMapper;
  14. import com.xjrsoft.module.system.entity.DictionaryDetail;
  15. import com.xjrsoft.module.textbook.dto.AddTextbookWarehouseRecordDto;
  16. import com.xjrsoft.module.textbook.dto.TextbookInstockroomDto;
  17. import com.xjrsoft.module.textbook.dto.TextbookInstockroomImportDto;
  18. import com.xjrsoft.module.textbook.dto.TextbookInstockroomListDto;
  19. import com.xjrsoft.module.textbook.dto.TextbookSubscriptionExportQueryListDto;
  20. import com.xjrsoft.module.textbook.dto.UpdateWfTextbookSubscriptionDto;
  21. import com.xjrsoft.module.textbook.dto.UpdateWfTextbookSubscriptionItemDto;
  22. import com.xjrsoft.module.textbook.dto.WfTextbookSubscriptionDto;
  23. import com.xjrsoft.module.textbook.entity.*;
  24. import com.xjrsoft.module.textbook.mapper.*;
  25. import com.xjrsoft.module.textbook.service.ITextbookService;
  26. import com.xjrsoft.module.textbook.service.IWfTextbookSubscriptionService;
  27. import com.xjrsoft.module.textbook.vo.TextbookInstockroomListVo;
  28. import com.xjrsoft.module.textbook.vo.TextbookSubscriptionExportQueryListVo;
  29. import com.xjrsoft.module.textbook.vo.WfTextbookSubscriptionItemVo;
  30. import com.xjrsoft.module.textbook.vo.WfTextbookSubscriptionVo;
  31. import lombok.AllArgsConstructor;
  32. import org.apache.commons.lang3.ObjectUtils;
  33. import org.springframework.beans.BeanUtils;
  34. import org.springframework.stereotype.Service;
  35. import org.springframework.transaction.annotation.Transactional;
  36. import java.io.InputStream;
  37. import java.util.ArrayList;
  38. import java.util.Arrays;
  39. import java.util.Date;
  40. import java.util.HashMap;
  41. import java.util.List;
  42. import java.util.Map;
  43. import java.util.Objects;
  44. import java.util.concurrent.atomic.AtomicReference;
  45. import java.util.regex.Matcher;
  46. import java.util.regex.Pattern;
  47. import java.util.stream.Collectors;
  48. /**
  49. * @title: 教材教辅征订
  50. * @Author szs
  51. * @Date: 2024-06-04
  52. * @Version 1.0
  53. */
  54. @Service
  55. @AllArgsConstructor
  56. public class WfTextbookSubscriptionServiceImpl extends MPJBaseServiceImpl<WfTextbookSubscriptionMapper, WfTextbookSubscription> implements IWfTextbookSubscriptionService {
  57. private final WfTextbookSubscriptionMapper wfTextbookSubscriptionWfTextbookSubscriptionMapper;
  58. private final WfTextbookSubscriptionItemMapper wfTextbookSubscriptionWfTextbookSubscriptionItemMapper;
  59. private final WfTextbookSubscriptionItemHistoryMapper wfTextbookSubscriptionItemHistoryMapper;
  60. private final TextbookSubscriptionMapper textbookSubscriptionMapper;
  61. private final TextbookSubscriptionItemMapper textbookSubscriptionItemMapper;
  62. private final TextbookSubscriptionClassMapper textbookSubscriptionClassMapper;
  63. private final ITextbookService textbookService;
  64. private final BaseClassMapper baseClassMapper;
  65. @Override
  66. @Transactional(rollbackFor = Exception.class)
  67. public Boolean add(TextbookSubscription textbookSubscription) {
  68. // 处理征订表
  69. int sum = 0;
  70. for (TextbookSubscriptionItem textbookSubscriptionItem : textbookSubscription.getTextbookSubscriptionItemList()) {
  71. sum += (ObjectUtils.isNotEmpty(textbookSubscriptionItem.getStudentNum()) ? textbookSubscriptionItem.getStudentNum() : 0)
  72. + (ObjectUtils.isNotEmpty(textbookSubscriptionItem.getTeacherNum()) ? textbookSubscriptionItem.getTeacherNum() : 0)
  73. ;
  74. }
  75. textbookSubscriptionMapper.insert(textbookSubscription);
  76. // 处理征订和班级关联表
  77. if(ObjectUtils.isNotEmpty(textbookSubscription.getSubscriptionMethod())
  78. && textbookSubscription.getSubscriptionMethod() == 1
  79. ){
  80. TextbookSubscriptionClass textbookSubscriptionClass = new TextbookSubscriptionClass();
  81. textbookSubscriptionClass.setTextbookSubscriptionId(textbookSubscription.getId());
  82. textbookSubscriptionClassMapper.insert(textbookSubscriptionClass);
  83. }
  84. // 处理征订表子表
  85. for (TextbookSubscriptionItem textbookSubscriptionItem : textbookSubscription.getTextbookSubscriptionItemList()) {
  86. textbookSubscriptionItem.setTextbookSubscriptionId(textbookSubscription.getId());
  87. textbookSubscriptionItemMapper.insert(textbookSubscriptionItem);
  88. }
  89. return true;
  90. }
  91. @Override
  92. @Transactional(rollbackFor = Exception.class)
  93. public Boolean update(WfTextbookSubscription wfTextbookSubscription) {
  94. wfTextbookSubscriptionWfTextbookSubscriptionMapper.updateById(wfTextbookSubscription);
  95. //********************************* WfTextbookSubscriptionItem 增删改 开始 *******************************************/
  96. {
  97. // 查出所有子级的id
  98. List<WfTextbookSubscriptionItem> wfTextbookSubscriptionItemList = wfTextbookSubscriptionWfTextbookSubscriptionItemMapper.selectList(Wrappers.lambdaQuery(WfTextbookSubscriptionItem.class).eq(WfTextbookSubscriptionItem::getWfTextbookSubscriptionId, wfTextbookSubscription.getId()).select(WfTextbookSubscriptionItem::getId));
  99. List<Long> wfTextbookSubscriptionItemIds = wfTextbookSubscriptionItemList.stream().map(WfTextbookSubscriptionItem::getId).collect(Collectors.toList());
  100. //原有子表单 没有被删除的主键
  101. List<Long> wfTextbookSubscriptionItemOldIds = wfTextbookSubscription.getWfTextbookSubscriptionItemList().stream().map(WfTextbookSubscriptionItem::getId).filter(Objects::nonNull).collect(Collectors.toList());
  102. //找到需要删除的id
  103. List<Long> wfTextbookSubscriptionItemRemoveIds = wfTextbookSubscriptionItemIds.stream().filter(item -> !wfTextbookSubscriptionItemOldIds.contains(item)).collect(Collectors.toList());
  104. for (WfTextbookSubscriptionItem wfTextbookSubscriptionItem : wfTextbookSubscription.getWfTextbookSubscriptionItemList()) {
  105. //如果不等于空则修改
  106. if (wfTextbookSubscriptionItem.getId() != null) {
  107. wfTextbookSubscriptionWfTextbookSubscriptionItemMapper.updateById(wfTextbookSubscriptionItem);
  108. }
  109. //如果等于空 则新增
  110. else {
  111. //已经不存在的id 删除
  112. wfTextbookSubscriptionItem.setWfTextbookSubscriptionId(wfTextbookSubscription.getId());
  113. wfTextbookSubscriptionWfTextbookSubscriptionItemMapper.insert(wfTextbookSubscriptionItem);
  114. }
  115. }
  116. //已经不存在的id 删除
  117. if (wfTextbookSubscriptionItemRemoveIds.size() > 0) {
  118. wfTextbookSubscriptionWfTextbookSubscriptionItemMapper.deleteBatchIds(wfTextbookSubscriptionItemRemoveIds);
  119. }
  120. }
  121. //********************************* WfTextbookSubscriptionItem 增删改 结束 *******************************************/
  122. return true;
  123. }
  124. @Override
  125. @Transactional(rollbackFor = Exception.class)
  126. public Boolean alteration(UpdateWfTextbookSubscriptionItemDto dto) {
  127. WfTextbookSubscriptionItem old = wfTextbookSubscriptionWfTextbookSubscriptionItemMapper.selectById(dto.getId());
  128. if(old == null){
  129. return false;
  130. }
  131. //将历史记录保存到历史变更记录表
  132. LambdaQueryWrapper<WfTextbookSubscriptionItemHistory> wfTextbookSubscriptionItemHistoryLambdaQueryWrapper = new LambdaQueryWrapper<>();
  133. wfTextbookSubscriptionItemHistoryLambdaQueryWrapper
  134. .eq(WfTextbookSubscriptionItemHistory::getWfTextbookSubscriptionItemId, old.getId())
  135. .orderByDesc(WfTextbookSubscriptionItemHistory::getHistoryVersion)
  136. .last("limit 1")
  137. ;
  138. WfTextbookSubscriptionItemHistory lastOne = wfTextbookSubscriptionItemHistoryMapper.selectOne(wfTextbookSubscriptionItemHistoryLambdaQueryWrapper);
  139. WfTextbookSubscriptionItemHistory wfTextbookSubscriptionItemHistory = new WfTextbookSubscriptionItemHistory();
  140. BeanUtils.copyProperties(old, wfTextbookSubscriptionItemHistory);
  141. wfTextbookSubscriptionItemHistory.setId(null);
  142. wfTextbookSubscriptionItemHistory.setWfTextbookSubscriptionItemId(old.getId());
  143. wfTextbookSubscriptionItemHistory.setCreateDate(new Date());
  144. wfTextbookSubscriptionItemHistory.setCreateUserId(StpUtil.getLoginIdAsLong());
  145. if(lastOne != null){
  146. wfTextbookSubscriptionItemHistory.setHistoryVersion(lastOne.getHistoryVersion() + 1);
  147. } else {
  148. wfTextbookSubscriptionItemHistory.setHistoryVersion(1);
  149. }
  150. wfTextbookSubscriptionItemHistoryMapper.insert(wfTextbookSubscriptionItemHistory);
  151. //变更当前记录
  152. WfTextbookSubscriptionItem updateItem = new WfTextbookSubscriptionItem();
  153. BeanUtils.copyProperties(dto, updateItem);
  154. wfTextbookSubscriptionWfTextbookSubscriptionItemMapper.updateById(updateItem);
  155. return true;
  156. }
  157. @Override
  158. @Transactional(rollbackFor = Exception.class)
  159. public Boolean delete(List<Long> ids) {
  160. wfTextbookSubscriptionWfTextbookSubscriptionMapper.deleteBatchIds(ids);
  161. wfTextbookSubscriptionWfTextbookSubscriptionItemMapper.delete(Wrappers.lambdaQuery(WfTextbookSubscriptionItem.class).in(WfTextbookSubscriptionItem::getWfTextbookSubscriptionId, ids));
  162. return true;
  163. }
  164. @Override
  165. @Transactional(rollbackFor = Exception.class)
  166. public Boolean changeStatus(UpdateWfTextbookSubscriptionDto dto) {
  167. TextbookSubscription textbookSubscription = textbookSubscriptionMapper.selectById(dto.getId());
  168. if (textbookSubscription == null) {
  169. return false;
  170. }
  171. WfTextbookSubscription newW = new WfTextbookSubscription();
  172. newW.setId(textbookSubscription.getId());
  173. newW.setStatus(dto.getStatus());
  174. return this.updateById(newW);
  175. }
  176. @Override
  177. public WfTextbookSubscriptionVo getInfo(WfTextbookSubscriptionDto dto) {
  178. WfTextbookSubscription wfTextbookSubscription = this.getById(dto.getId());
  179. if (wfTextbookSubscription == null) {
  180. return null;
  181. }
  182. WfTextbookSubscriptionVo wfTextbookSubscriptionVo = BeanUtil.toBean(wfTextbookSubscription, WfTextbookSubscriptionVo.class);
  183. MPJLambdaWrapper<WfTextbookSubscriptionItem> mpjLambdaWrapper = new MPJLambdaWrapper<>();
  184. mpjLambdaWrapper
  185. .select(WfTextbookSubscriptionItem::getId)
  186. .selectAs(BaseCourseSubject::getName, WfTextbookSubscriptionItemVo::getCourseSubjectIdCn)
  187. .select(Textbook.class, x -> VoToColumnUtil.fieldsToColumns(WfTextbookSubscriptionItemVo.class).contains(x.getProperty()))
  188. .select(WfTextbookSubscriptionItem.class, x -> VoToColumnUtil.fieldsToColumns(WfTextbookSubscriptionItemVo.class).contains(x.getProperty()))
  189. .leftJoin(Textbook.class, Textbook::getId, WfTextbookSubscriptionItem::getTextbookId)
  190. .leftJoin(DictionaryDetail.class, DictionaryDetail::getCode, Textbook::getTextbookType,
  191. ext -> ext.selectAs(DictionaryDetail::getName, WfTextbookSubscriptionItemVo::getTextbookTypeCn))
  192. .leftJoin(BaseCourseSubject.class, BaseCourseSubject::getId, Textbook::getCourseSubjectId)
  193. .eq(WfTextbookSubscriptionItem::getWfTextbookSubscriptionId, wfTextbookSubscription.getId())
  194. .eq(dto.getWfTextbookSubscriptionItemId() != null && dto.getWfTextbookSubscriptionItemId() > 0, WfTextbookSubscriptionItem::getId, dto.getWfTextbookSubscriptionItemId())
  195. .eq(dto.getTextbookType() != null && !dto.getTextbookType().isEmpty(), Textbook::getTextbookType, dto.getTextbookType())
  196. .like(dto.getBookName() != null && !dto.getBookName().isEmpty(), Textbook::getBookName, dto.getBookName())
  197. .like(dto.getCourseSubjectIdCn() != null && !dto.getCourseSubjectIdCn().isEmpty(), BaseCourseSubject::getName, dto.getCourseSubjectIdCn())
  198. ;
  199. List<WfTextbookSubscriptionItemVo> itemList = wfTextbookSubscriptionWfTextbookSubscriptionItemMapper.selectJoinList(WfTextbookSubscriptionItemVo.class, mpjLambdaWrapper);
  200. //处理班级
  201. String classIds = "";
  202. List<String> classIdList = new ArrayList<>();
  203. StringBuilder sb = new StringBuilder();
  204. if (!itemList.isEmpty() && itemList.get(0).getClassIds() != null && !itemList.get(0).getClassIds().equals("")) {
  205. classIds = itemList.get(0).getClassIds();
  206. String[] classIdArr = classIds.split(",");
  207. classIdList = Arrays.asList(classIdArr);
  208. if (!classIdList.isEmpty()) {
  209. List<BaseClass> baseClassList = baseClassMapper.selectList(Wrappers.<BaseClass>query().lambda().in(BaseClass::getId, classIdList));
  210. Map<Long, BaseClass> baseClassMap = baseClassList.stream()
  211. .collect(Collectors.toMap(BaseClass::getId, baseClass -> baseClass));
  212. for (String classId : classIdList) {
  213. BaseClass baseClass = baseClassMap.get(Long.parseLong(classId));
  214. if (baseClass != null) {
  215. sb.append(baseClass.getName());
  216. sb.append(",");
  217. }
  218. }
  219. sb.deleteCharAt(sb.length() - 1);
  220. }
  221. }
  222. //遍历处理所有项
  223. int stuSum = 0;
  224. int teaSum = 0;
  225. for (WfTextbookSubscriptionItemVo w : itemList) {
  226. int sum = 0;
  227. if (!classIdList.isEmpty()) {
  228. w.setClassNum(classIdList.size());
  229. }
  230. if (w.getStudentSubscriptionNumber() != null) {
  231. stuSum += w.getStudentSubscriptionNumber();
  232. sum += w.getStudentSubscriptionNumber();
  233. }
  234. if (w.getTeacherSubscriptionNumber() != null) {
  235. teaSum += w.getTeacherSubscriptionNumber();
  236. sum += w.getTeacherSubscriptionNumber();
  237. }
  238. w.setSumNumber(sum);
  239. }
  240. wfTextbookSubscriptionVo.setClassIdsCn(sb.toString());
  241. wfTextbookSubscriptionVo.setClassIds(classIds);
  242. wfTextbookSubscriptionVo.setStudentSubscriptionNumberSum(stuSum);
  243. wfTextbookSubscriptionVo.setTeacherSubscriptionNumberSum(teaSum);
  244. wfTextbookSubscriptionVo.setSum(stuSum + teaSum);
  245. wfTextbookSubscriptionVo.setWfTextbookSubscriptionItemList(itemList);
  246. return wfTextbookSubscriptionVo;
  247. }
  248. @Override
  249. public List<TextbookSubscriptionExportQueryListVo> textbookSubscriptionExportQuery(TextbookSubscriptionExportQueryListDto dto) {
  250. WfTextbookSubscription wfTextbookSubscription = this.getById(dto.getTextbookSubscriptionId());
  251. if (wfTextbookSubscription == null) {
  252. return null;
  253. }
  254. MPJLambdaWrapper<WfTextbookSubscriptionItem> mpjLambdaWrapper = new MPJLambdaWrapper<>();
  255. mpjLambdaWrapper
  256. .selectAs(BaseCourseSubject::getName, TextbookSubscriptionExportQueryListVo::getCourseName)
  257. .select(WfTextbookSubscriptionItem.class, x -> VoToColumnUtil.fieldsToColumns(TextbookSubscriptionExportQueryListVo.class).contains(x.getProperty()))
  258. .select(Textbook.class, x -> VoToColumnUtil.fieldsToColumns(TextbookSubscriptionExportQueryListVo.class).contains(x.getProperty()))
  259. .leftJoin(Textbook.class, Textbook::getId, WfTextbookSubscriptionItem::getTextbookId)
  260. .leftJoin(DictionaryDetail.class, DictionaryDetail::getCode, Textbook::getTextbookType,
  261. ext -> ext.selectAs(DictionaryDetail::getName, TextbookSubscriptionExportQueryListVo::getTextbookTypeCn))
  262. .leftJoin(BaseCourseSubject.class, BaseCourseSubject::getId, Textbook::getCourseSubjectId)
  263. .eq(WfTextbookSubscriptionItem::getWfTextbookSubscriptionId, wfTextbookSubscription.getId())
  264. ;
  265. List<TextbookSubscriptionExportQueryListVo> itemList = wfTextbookSubscriptionWfTextbookSubscriptionItemMapper.selectJoinList(TextbookSubscriptionExportQueryListVo.class, mpjLambdaWrapper);
  266. //处理班级
  267. String classIds = "";
  268. List<String> classIdList = new ArrayList<>();
  269. StringBuilder sb = new StringBuilder();
  270. if (!itemList.isEmpty() && itemList.get(0).getClassIds() != null && !itemList.get(0).getClassIds().equals("")) {
  271. classIds = itemList.get(0).getClassIds();
  272. String[] classIdArr = classIds.split(",");
  273. classIdList = Arrays.asList(classIdArr);
  274. /*if(!classIdList.isEmpty()){
  275. List<BaseClass> baseClassList = baseClassMapper.selectList(Wrappers.<BaseClass>query().lambda().in(BaseClass::getId, classIdList));
  276. Map<Long, BaseClass> baseClassMap = baseClassList.stream()
  277. .collect(Collectors.toMap(BaseClass::getId, baseClass -> baseClass));
  278. for (String classId : classIdList){
  279. BaseClass baseClass = baseClassMap.get(Long.parseLong(classId));
  280. if(baseClass != null){
  281. sb.append(baseClass.getName());
  282. sb.append(",");
  283. }
  284. }
  285. sb.deleteCharAt(sb.length() - 1);
  286. }*/
  287. }
  288. for (TextbookSubscriptionExportQueryListVo w : itemList) {
  289. w.setClassNum(classIdList.size());
  290. }
  291. return itemList;
  292. }
  293. @Override
  294. public List<TextbookInstockroomListVo> instockroomList(TextbookInstockroomListDto dto) {
  295. MPJLambdaWrapper<WfTextbookSubscriptionItem> queryWrapper = new MPJLambdaWrapper<>();
  296. queryWrapper
  297. .select(WfTextbookSubscriptionItem::getId)
  298. .selectAs(BaseCourseSubject::getName, TextbookInstockroomListVo::getCourseName)
  299. .selectAs(DictionaryDetail::getName, TextbookInstockroomListVo::getTextbookTypeCn)
  300. .select("(t.student_subscription_number + t.teacher_subscription_number) as subscriptionNumber")
  301. .select(Textbook.class, x -> VoToColumnUtil.fieldsToColumns(TextbookInstockroomListVo.class).contains(x.getProperty()))
  302. .select(WfTextbookSubscriptionItem.class, x -> VoToColumnUtil.fieldsToColumns(TextbookInstockroomListVo.class).contains(x.getProperty()))
  303. .leftJoin(Textbook.class, Textbook::getId, WfTextbookSubscriptionItem::getTextbookId)
  304. .leftJoin(BaseCourseSubject.class, BaseCourseSubject::getId, Textbook::getCourseSubjectId)
  305. .leftJoin(DictionaryDetail.class, DictionaryDetail::getCode, Textbook::getTextbookType)
  306. .eq(WfTextbookSubscriptionItem::getWfTextbookSubscriptionId, dto.getTextbookSubscriptionId())
  307. .orderByAsc(WfTextbookSubscriptionItem::getInStockroomNum)
  308. ;
  309. return wfTextbookSubscriptionWfTextbookSubscriptionItemMapper.selectJoinList(TextbookInstockroomListVo.class, queryWrapper);
  310. }
  311. @Override
  312. @Transactional(rollbackFor = Exception.class)
  313. public Boolean instockroom(List<TextbookInstockroomDto> dtos) {
  314. if (dtos.isEmpty()) {
  315. return false;
  316. }
  317. Map<String, Object> result = saveData(dtos);
  318. return result != null && (int) result.get("successNum") > 0;
  319. }
  320. @Override
  321. public String excelImport(InputStream inputStream, Long wfTextbookSubscriptionId) {
  322. AtomicReference<Map<String, Object>> atomicMap = new AtomicReference<>(new HashMap<>());
  323. List<Map<Integer, Object>> excalDataList = EasyExcel.read(inputStream).sheet().headRowNumber(1).doReadSync();
  324. String regex = "\\d+";
  325. Pattern pattern = Pattern.compile(regex);
  326. List<TextbookInstockroomImportDto> dataList = new ArrayList<>();
  327. for (Map<Integer, Object> integerObjectMap : excalDataList) {
  328. Matcher matcher = pattern.matcher(integerObjectMap.get(11).toString());
  329. int inNum = 0;
  330. if(matcher.find()){
  331. inNum = Integer.parseInt(integerObjectMap.get(11).toString());
  332. }
  333. TextbookInstockroomImportDto importDto = new TextbookInstockroomImportDto();
  334. importDto.setInNum(inNum);
  335. importDto.setIssn(integerObjectMap.get(2).toString());
  336. dataList.add(importDto);
  337. }
  338. List<TextbookInstockroomDto> textbookInstockroomDtoList = new ArrayList<>();
  339. for (TextbookInstockroomImportDto item : dataList){
  340. textbookInstockroomDtoList.add(new TextbookInstockroomDto(){{
  341. setTextbookSubscriptionId(wfTextbookSubscriptionId);
  342. // setIssn(item.getIssn());
  343. setInNum(item.getInNum());
  344. }});
  345. }
  346. atomicMap.set(saveData(textbookInstockroomDtoList));
  347. if(atomicMap.get() != null){
  348. return "计划入库教材" + atomicMap.get().get("allNum") + "样,成功入库" + atomicMap.get().get("successNum") + "样,成功入库" + atomicMap.get().get("instockroomNum") + "本";
  349. }
  350. return "计划入库教材0样,成功入库0样,成功入库0本";
  351. }
  352. private Map<String, Object> saveData(List<TextbookInstockroomDto> dtos) {
  353. Map<String, Object> result = new HashMap<>();
  354. int successNum = 0;
  355. int instockroomNum = 0;
  356. //获取需要修改的list
  357. MPJLambdaWrapper<WfTextbookSubscriptionItem> queryWrapper = new MPJLambdaWrapper<>();
  358. queryWrapper
  359. .select(WfTextbookSubscriptionItem::getId)
  360. .selectAs(Textbook::getIssn, WfTextbookSubscriptionItem::getIssn)
  361. .select(WfTextbookSubscriptionItem.class, x -> VoToColumnUtil.fieldsToColumns(WfTextbookSubscriptionItem.class).contains(x.getProperty()))
  362. .leftJoin(Textbook.class, Textbook::getId, WfTextbookSubscriptionItem::getTextbookId)
  363. .eq(WfTextbookSubscriptionItem::getWfTextbookSubscriptionId, dtos.get(0).getTextbookSubscriptionId())
  364. .eq(WfTextbookSubscriptionItem::getDeleteMark, DeleteMark.NODELETE.getCode())
  365. ;
  366. List<WfTextbookSubscriptionItem> wfTextbookSubscriptionItemList = wfTextbookSubscriptionWfTextbookSubscriptionItemMapper.selectList(queryWrapper);
  367. if (wfTextbookSubscriptionItemList.isEmpty()) {
  368. return null;
  369. }
  370. Map<Long, WfTextbookSubscriptionItem> itemByIdMap = new HashMap<>();
  371. for (WfTextbookSubscriptionItem el : wfTextbookSubscriptionItemList) {
  372. itemByIdMap.put(el.getId(), el);
  373. }
  374. Map<String, WfTextbookSubscriptionItem> itemByIssnMap = new HashMap<>();
  375. for (WfTextbookSubscriptionItem el : wfTextbookSubscriptionItemList) {
  376. itemByIssnMap.put(el.getIssn(), el);
  377. }
  378. Date now = new Date();
  379. Long loginId = StpUtil.getLoginIdAsLong();
  380. // for (TextbookInstockroomDto dto : dtos) {
  381. // WfTextbookSubscriptionItem old;
  382. // if(dto.getTextbookSubscriptionItemId() != null && dto.getTextbookSubscriptionItemId() > 0){
  383. // old = itemByIdMap.get(dto.getTextbookSubscriptionItemId());
  384. // } else {
  385. // old = itemByIssnMap.get(dto.getIssn());
  386. // }
  387. //
  388. // if(old == null){
  389. // continue;
  390. // }
  391. //
  392. // WfTextbookSubscriptionItem updateItem = new WfTextbookSubscriptionItem();
  393. // updateItem.setId(old.getId());
  394. // updateItem.setInStockroomNum(old.getInStockroomNum() + dto.getInNum());
  395. // updateItem.setModifyDate(now);
  396. // updateItem.setModifyUserId(loginId);
  397. // wfTextbookSubscriptionWfTextbookSubscriptionItemMapper.updateById(updateItem);
  398. //
  399. // //新增入库记录
  400. //// textbookService.deliverWarehouse(new AddTextbookWarehouseRecordDto() {{
  401. //// setTextbookId(old.getTextbookId());
  402. //// setWarehouseNumber(dto.getInNum());
  403. //// setSource("wm_manual");
  404. //// }});
  405. //// successNum++;
  406. // instockroomNum += dto.getInNum();
  407. // }
  408. result.put("allNum", dtos.size());
  409. result.put("successNum", successNum);
  410. result.put("instockroomNum", instockroomNum);
  411. return result;
  412. }
  413. }