serviceImpl.vm 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421
  1. package ${basePackage}.module.${table.moduleName}.service.${table.businessName};
  2. import cn.hutool.core.collection.CollUtil;
  3. import org.springframework.stereotype.Service;
  4. import ${jakartaPackage}.annotation.Resource;
  5. import org.springframework.validation.annotation.Validated;
  6. import org.springframework.transaction.annotation.Transactional;
  7. import java.util.*;
  8. import ${basePackage}.module.${table.moduleName}.controller.${sceneEnum.basePackage}.${table.businessName}.vo.*;
  9. import ${basePackage}.module.${table.moduleName}.dal.dataobject.${table.businessName}.${table.className}DO;
  10. ## 特殊:主子表专属逻辑
  11. #foreach ($subTable in $subTables)
  12. import ${basePackage}.module.${subTable.moduleName}.dal.dataobject.${subTable.businessName}.${subTable.className}DO;
  13. #end
  14. import ${PageResultClassName};
  15. import ${PageParamClassName};
  16. import ${BeanUtils};
  17. import ${basePackage}.module.${table.moduleName}.dal.mysql.${table.businessName}.${table.className}Mapper;
  18. ## 特殊:主子表专属逻辑
  19. #foreach ($subTable in $subTables)
  20. #set ($index = $foreach.count - 1)
  21. import ${basePackage}.module.${subTable.moduleName}.dal.mysql.${subTable.businessName}.${subTable.className}Mapper;
  22. #end
  23. import static ${ServiceExceptionUtilClassName}.exception;
  24. import static ${CollectionUtilsClassName}.convertList;
  25. import static ${CollectionUtilsClassName}.diffList;
  26. import static ${basePackage}.module.${table.moduleName}.enums.ErrorCodeConstants.*;
  27. /**
  28. * ${table.classComment} Service 实现类
  29. *
  30. * @author ${table.author}
  31. */
  32. @Service
  33. @Validated
  34. public class ${table.className}ServiceImpl implements ${table.className}Service {
  35. @Resource
  36. private ${table.className}Mapper ${classNameVar}Mapper;
  37. ## 特殊:主子表专属逻辑
  38. #foreach ($subTable in $subTables)
  39. #set ($index = $foreach.count - 1)
  40. @Resource
  41. private ${subTable.className}Mapper ${subClassNameVars.get($index)}Mapper;
  42. #end
  43. @Override
  44. ## 特殊:主子表专属逻辑(非 ERP 模式)
  45. #if ( $subTables && $subTables.size() > 0 && $table.templateType != 11 )
  46. @Transactional(rollbackFor = Exception.class)
  47. #end
  48. public ${primaryColumn.javaType} create${simpleClassName}(${saveReqVOClass} ${saveReqVOVar}) {
  49. ## 特殊:树表专属逻辑
  50. #if ( $table.templateType == 2 )
  51. #set ($TreeParentJavaField = $treeParentColumn.javaField.substring(0,1).toUpperCase() + ${treeParentColumn.javaField.substring(1)})##首字母大写
  52. #set ($TreeNameJavaField = $treeNameColumn.javaField.substring(0,1).toUpperCase() + ${treeNameColumn.javaField.substring(1)})##首字母大写
  53. // 校验${treeParentColumn.columnComment}的有效性
  54. validateParent${simpleClassName}(null, ${saveReqVOVar}.get${TreeParentJavaField}());
  55. // 校验${treeNameColumn.columnComment}的唯一性
  56. validate${simpleClassName}${TreeNameJavaField}Unique(null, ${saveReqVOVar}.get${TreeParentJavaField}(), ${saveReqVOVar}.get${TreeNameJavaField}());
  57. #end
  58. // 插入
  59. #if ($voType == 10)
  60. ${table.className}DO ${classNameVar} = BeanUtils.toBean(createReqVO, ${table.className}DO.class);
  61. #end
  62. ${classNameVar}Mapper.insert(${classNameVar});
  63. ## 特殊:主子表专属逻辑(非 ERP 模式)
  64. #if ( $subTables && $subTables.size() > 0 && $table.templateType != 11 )
  65. // 插入子表
  66. #foreach ($subTable in $subTables)
  67. #set ($index = $foreach.count - 1)
  68. #set ($subSimpleClassName = $subSimpleClassNames.get($index))
  69. #set ($subJoinColumn = $subJoinColumns.get($index))##当前 join 字段
  70. #set ($SubJoinColumnName = $subJoinColumn.javaField.substring(0,1).toUpperCase() + ${subJoinColumn.javaField.substring(1)})##首字母大写
  71. #if ( $subTable.subJoinMany)
  72. create${subSimpleClassName}List(${classNameVar}.getId(), ${saveReqVOVar}.get${subSimpleClassNames.get($index)}s());
  73. #else
  74. create${subSimpleClassName}(${classNameVar}.getId(), ${saveReqVOVar}.get${subSimpleClassNames.get($index)}());
  75. #end
  76. #end
  77. #end
  78. // 返回
  79. return ${classNameVar}.getId();
  80. }
  81. @Override
  82. ## 特殊:主子表专属逻辑(非 ERP 模式)
  83. #if ( $subTables && $subTables.size() > 0 && $table.templateType != 11 )
  84. @Transactional(rollbackFor = Exception.class)
  85. #end
  86. public void update${simpleClassName}(${updateReqVOClass} ${updateReqVOVar}) {
  87. // 校验存在
  88. validate${simpleClassName}Exists(${updateReqVOVar}.getId());
  89. ## 特殊:树表专属逻辑
  90. #if ( $table.templateType == 2 )
  91. #set ($TreeParentJavaField = $treeParentColumn.javaField.substring(0,1).toUpperCase() + ${treeParentColumn.javaField.substring(1)})##首字母大写
  92. #set ($TreeNameJavaField = $treeNameColumn.javaField.substring(0,1).toUpperCase() + ${treeNameColumn.javaField.substring(1)})##首字母大写
  93. // 校验${treeParentColumn.columnComment}的有效性
  94. validateParent${simpleClassName}(${updateReqVOVar}.getId(), ${updateReqVOVar}.get${TreeParentJavaField}());
  95. // 校验${treeNameColumn.columnComment}的唯一性
  96. validate${simpleClassName}${TreeNameJavaField}Unique(${updateReqVOVar}.getId(), ${updateReqVOVar}.get${TreeParentJavaField}(), ${updateReqVOVar}.get${TreeNameJavaField}());
  97. #end
  98. // 更新
  99. #if ($voType == 10)
  100. ${table.className}DO updateObj = BeanUtils.toBean(updateReqVO, ${table.className}DO.class);
  101. ${classNameVar}Mapper.updateById(updateObj);
  102. #else
  103. ${classNameVar}Mapper.updateById(${updateReqVOVar});
  104. #end
  105. ## 特殊:主子表专属逻辑(非 ERP 模式)
  106. #if ( $subTables && $subTables.size() > 0 && $table.templateType != 11)
  107. // 更新子表
  108. #foreach ($subTable in $subTables)
  109. #set ($index = $foreach.count - 1)
  110. #set ($subSimpleClassName = $subSimpleClassNames.get($index))
  111. #set ($subJoinColumn = $subJoinColumns.get($index))##当前 join 字段
  112. #set ($SubJoinColumnName = $subJoinColumn.javaField.substring(0,1).toUpperCase() + ${subJoinColumn.javaField.substring(1)})##首字母大写
  113. #if ( $subTable.subJoinMany)
  114. update${subSimpleClassName}List(${updateReqVOVar}.getId(), ${updateReqVOVar}.get${subSimpleClassNames.get($index)}s());
  115. #else
  116. update${subSimpleClassName}(${updateReqVOVar}.getId(), ${updateReqVOVar}.get${subSimpleClassNames.get($index)}());
  117. #end
  118. #end
  119. #end
  120. }
  121. @Override
  122. ## 特殊:主子表专属逻辑
  123. #if ( $subTables && $subTables.size() > 0)
  124. @Transactional(rollbackFor = Exception.class)
  125. #end
  126. public void delete${simpleClassName}(${primaryColumn.javaType} id) {
  127. // 校验存在
  128. validate${simpleClassName}Exists(id);
  129. ## 特殊:树表专属逻辑
  130. #if ( $table.templateType == 2 )
  131. #set ($ParentJavaField = $treeParentColumn.javaField.substring(0,1).toUpperCase() + ${treeParentColumn.javaField.substring(1)})##首字母大写
  132. // 校验是否有子${table.classComment}
  133. if (${classNameVar}Mapper.selectCountBy${ParentJavaField}(id) > 0) {
  134. throw exception(${simpleClassName_underlineCase.toUpperCase()}_EXITS_CHILDREN);
  135. }
  136. #end
  137. // 删除
  138. ${classNameVar}Mapper.deleteById(id);
  139. ## 特殊:主子表专属逻辑
  140. #if ( $subTables && $subTables.size() > 0)
  141. // 删除子表
  142. #foreach ($subTable in $subTables)
  143. #set ($index = $foreach.count - 1)
  144. #set ($subSimpleClassName = $subSimpleClassNames.get($index))
  145. #set ($subJoinColumn = $subJoinColumns.get($index))##当前 join 字段
  146. #set ($SubJoinColumnName = $subJoinColumn.javaField.substring(0,1).toUpperCase() + ${subJoinColumn.javaField.substring(1)})##首字母大写
  147. delete${subSimpleClassName}By${SubJoinColumnName}(id);
  148. #end
  149. #end
  150. }
  151. #if ( $table.templateType != 2 && $deleteBatchEnable)
  152. @Override
  153. ## 特殊:主子表专属逻辑
  154. #if ( $subTables && $subTables.size() > 0)
  155. @Transactional(rollbackFor = Exception.class)
  156. #end
  157. public void delete${simpleClassName}ListByIds(List<${primaryColumn.javaType}> ids) {
  158. // 校验存在
  159. validate${simpleClassName}Exists(ids);
  160. // 删除
  161. ${classNameVar}Mapper.deleteByIds(ids);
  162. ## 特殊:主子表专属逻辑
  163. #if ( $subTables && $subTables.size() > 0)
  164. // 删除子表
  165. #foreach ($subTable in $subTables)
  166. #set ($index = $foreach.count - 1)
  167. #set ($subSimpleClassName = $subSimpleClassNames.get($index))
  168. #set ($subJoinColumn = $subJoinColumns.get($index))##当前 join 字段
  169. #set ($SubJoinColumnName = $subJoinColumn.javaField.substring(0,1).toUpperCase() + ${subJoinColumn.javaField.substring(1)})##首字母大写
  170. delete${subSimpleClassName}By${SubJoinColumnName}s(ids);
  171. #end
  172. #end
  173. }
  174. private void validate${simpleClassName}Exists(List<${primaryColumn.javaType}> ids) {
  175. List<${table.className}DO> list = ${classNameVar}Mapper.selectByIds(ids);
  176. if (CollUtil.isEmpty(list) || list.size() != ids.size()) {
  177. throw exception(${simpleClassName_underlineCase.toUpperCase()}_NOT_EXISTS);
  178. }
  179. }
  180. #end
  181. private void validate${simpleClassName}Exists(${primaryColumn.javaType} id) {
  182. if (${classNameVar}Mapper.selectById(id) == null) {
  183. throw exception(${simpleClassName_underlineCase.toUpperCase()}_NOT_EXISTS);
  184. }
  185. }
  186. ## 特殊:树表专属逻辑
  187. #if ( $table.templateType == 2 )
  188. #set ($TreeParentJavaField = $treeParentColumn.javaField.substring(0,1).toUpperCase() + ${treeParentColumn.javaField.substring(1)})##首字母大写
  189. #set ($TreeNameJavaField = $treeNameColumn.javaField.substring(0,1).toUpperCase() + ${treeNameColumn.javaField.substring(1)})##首字母大写
  190. private void validateParent${simpleClassName}(Long id, Long ${treeParentColumn.javaField}) {
  191. if (${treeParentColumn.javaField} == null || ${simpleClassName}DO.${treeParentColumn_javaField_underlineCase.toUpperCase()}_ROOT.equals(${treeParentColumn.javaField})) {
  192. return;
  193. }
  194. // 1. 不能设置自己为父${table.classComment}
  195. if (Objects.equals(id, ${treeParentColumn.javaField})) {
  196. throw exception(${simpleClassName_underlineCase.toUpperCase()}_PARENT_ERROR);
  197. }
  198. // 2. 父${table.classComment}不存在
  199. ${simpleClassName}DO parent${simpleClassName} = ${classNameVar}Mapper.selectById(${treeParentColumn.javaField});
  200. if (parent${simpleClassName} == null) {
  201. throw exception(${simpleClassName_underlineCase.toUpperCase()}_PARENT_NOT_EXITS);
  202. }
  203. // 3. 递归校验父${table.classComment},如果父${table.classComment}是自己的子${table.classComment},则报错,避免形成环路
  204. if (id == null) { // id 为空,说明新增,不需要考虑环路
  205. return;
  206. }
  207. for (int i = 0; i < Short.MAX_VALUE; i++) {
  208. // 3.1 校验环路
  209. ${treeParentColumn.javaField} = parent${simpleClassName}.get${TreeParentJavaField}();
  210. if (Objects.equals(id, ${treeParentColumn.javaField})) {
  211. throw exception(${simpleClassName_underlineCase.toUpperCase()}_PARENT_IS_CHILD);
  212. }
  213. // 3.2 继续递归下一级父${table.classComment}
  214. if (${treeParentColumn.javaField} == null || ${simpleClassName}DO.${treeParentColumn_javaField_underlineCase.toUpperCase()}_ROOT.equals(${treeParentColumn.javaField})) {
  215. break;
  216. }
  217. parent${simpleClassName} = ${classNameVar}Mapper.selectById(${treeParentColumn.javaField});
  218. if (parent${simpleClassName} == null) {
  219. break;
  220. }
  221. }
  222. }
  223. private void validate${simpleClassName}${TreeNameJavaField}Unique(Long id, Long ${treeParentColumn.javaField}, String ${treeNameColumn.javaField}) {
  224. ${simpleClassName}DO ${classNameVar} = ${classNameVar}Mapper.selectBy${TreeParentJavaField}And${TreeNameJavaField}(${treeParentColumn.javaField}, ${treeNameColumn.javaField});
  225. if (${classNameVar} == null) {
  226. return;
  227. }
  228. // 如果 id 为空,说明不用比较是否为相同 id 的${table.classComment}
  229. if (id == null) {
  230. throw exception(${simpleClassName_underlineCase.toUpperCase()}_${treeNameColumn_javaField_underlineCase.toUpperCase()}_DUPLICATE);
  231. }
  232. if (!Objects.equals(${classNameVar}.getId(), id)) {
  233. throw exception(${simpleClassName_underlineCase.toUpperCase()}_${treeNameColumn_javaField_underlineCase.toUpperCase()}_DUPLICATE);
  234. }
  235. }
  236. #end
  237. @Override
  238. public ${table.className}DO get${simpleClassName}(${primaryColumn.javaType} id) {
  239. return ${classNameVar}Mapper.selectById(id);
  240. }
  241. ## 特殊:树表专属逻辑(树不需要分页接口)
  242. #if ( $table.templateType != 2 )
  243. @Override
  244. public PageResult<${table.className}DO> get${simpleClassName}Page(${sceneEnum.prefixClass}${table.className}PageReqVO pageReqVO) {
  245. return ${classNameVar}Mapper.selectPage(pageReqVO);
  246. }
  247. #else
  248. @Override
  249. public List<${table.className}DO> get${simpleClassName}List(${sceneEnum.prefixClass}${table.className}ListReqVO listReqVO) {
  250. return ${classNameVar}Mapper.selectList(listReqVO);
  251. }
  252. #end
  253. ## 特殊:主子表专属逻辑
  254. #foreach ($subTable in $subTables)
  255. #set ($index = $foreach.count - 1)
  256. #set ($subSimpleClassName = $subSimpleClassNames.get($index))
  257. #set ($simpleClassNameUnderlineCase = $simpleClassNameUnderlineCases.get($index))
  258. #set ($subPrimaryColumn = $subPrimaryColumns.get($index))##当前 primary 字段
  259. #set ($subJoinColumn = $subJoinColumns.get($index))##当前 join 字段
  260. #set ($SubJoinColumnName = $subJoinColumn.javaField.substring(0,1).toUpperCase() + ${subJoinColumn.javaField.substring(1)})##首字母大写
  261. #set ($subClassNameVar = $subClassNameVars.get($index))
  262. // ==================== 子表($subTable.classComment) ====================
  263. ## 情况一:MASTER_ERP 时,需要分查询页子表
  264. #if ( $table.templateType == 11 )
  265. @Override
  266. public PageResult<${subTable.className}DO> get${subSimpleClassName}Page(PageParam pageReqVO, ${subJoinColumn.javaType} ${subJoinColumn.javaField}) {
  267. return ${subClassNameVars.get($index)}Mapper.selectPage(pageReqVO, ${subJoinColumn.javaField});
  268. }
  269. ## 情况二:非 MASTER_ERP 时,需要列表查询子表
  270. #else
  271. #if ( $subTable.subJoinMany )
  272. @Override
  273. public List<${subTable.className}DO> get${subSimpleClassName}ListBy${SubJoinColumnName}(${subJoinColumn.javaType} ${subJoinColumn.javaField}) {
  274. return ${subClassNameVars.get($index)}Mapper.selectListBy${SubJoinColumnName}(${subJoinColumn.javaField});
  275. }
  276. #else
  277. @Override
  278. public ${subTable.className}DO get${subSimpleClassName}By${SubJoinColumnName}(${subJoinColumn.javaType} ${subJoinColumn.javaField}) {
  279. return ${subClassNameVars.get($index)}Mapper.selectBy${SubJoinColumnName}(${subJoinColumn.javaField});
  280. }
  281. #end
  282. #end
  283. ## 情况一:MASTER_ERP 时,支持单个的新增、修改、删除操作
  284. #if ( $table.templateType == 11 )
  285. @Override
  286. public ${subPrimaryColumn.javaType} create${subSimpleClassName}(${subTable.className}DO ${subClassNameVar}) {
  287. ## 特殊:一对一时,需要保证只有一条,不能重复插入
  288. #if ( !$subTable.subJoinMany)
  289. // 校验是否已经存在
  290. if (${subClassNameVars.get($index)}Mapper.selectBy${SubJoinColumnName}(${subClassNameVar}.get${SubJoinColumnName}()) != null) {
  291. throw exception(${simpleClassNameUnderlineCase.toUpperCase()}_EXISTS);
  292. }
  293. // 插入
  294. #end
  295. ${subClassNameVars.get($index)}Mapper.insert(${subClassNameVar});
  296. return ${subClassNameVar}.getId();
  297. }
  298. @Override
  299. public void update${subSimpleClassName}(${subTable.className}DO ${subClassNameVar}) {
  300. // 校验存在
  301. validate${subSimpleClassName}Exists(${subClassNameVar}.getId());
  302. // 更新
  303. ${subClassNameVar}.clean(); // 解决更新情况下:updateTime 不更新
  304. ${subClassNameVars.get($index)}Mapper.updateById(${subClassNameVar});
  305. }
  306. @Override
  307. public void delete${subSimpleClassName}(${subPrimaryColumn.javaType} id) {
  308. // 删除
  309. ${subClassNameVars.get($index)}Mapper.deleteById(id);
  310. }
  311. #if ($deleteBatchEnable)
  312. @Override
  313. public void delete${subSimpleClassName}ListByIds(List<${subPrimaryColumn.javaType}> ids) {
  314. // 删除
  315. ${subClassNameVars.get($index)}Mapper.deleteByIds(ids);
  316. }
  317. #end
  318. @Override
  319. public ${subTable.className}DO get${subSimpleClassName}(${subPrimaryColumn.javaType} id) {
  320. return ${subClassNameVars.get($index)}Mapper.selectById(id);
  321. }
  322. private void validate${subSimpleClassName}Exists(${subPrimaryColumn.javaType} id) {
  323. if (${subClassNameVar}Mapper.selectById(id) == null) {
  324. throw exception(${simpleClassNameUnderlineCase.toUpperCase()}_NOT_EXISTS);
  325. }
  326. }
  327. ## 情况二:非 MASTER_ERP 时,支持批量的新增、修改操作
  328. #else
  329. #if ( $subTable.subJoinMany)
  330. private void create${subSimpleClassName}List(${primaryColumn.javaType} ${subJoinColumn.javaField}, List<${subTable.className}DO> list) {
  331. list.forEach(o -> o.set${SubJoinColumnName}(${subJoinColumn.javaField}).clean());
  332. ${subClassNameVars.get($index)}Mapper.insertBatch(list);
  333. }
  334. private void update${subSimpleClassName}List(${primaryColumn.javaType} ${subJoinColumn.javaField}, List<${subTable.className}DO> list) {
  335. list.forEach(o -> o.set${SubJoinColumnName}(${subJoinColumn.javaField}).clean());
  336. List<${subTable.className}DO> oldList = ${subClassNameVar}Mapper.selectListBy${SubJoinColumnName}(${subJoinColumn.javaField});
  337. List<List<${subTable.className}DO>> diffList = diffList(oldList, list, (oldVal, newVal) -> {
  338. boolean same = ObjectUtil.equal(oldVal.getId(), newVal.getId());
  339. if (same) {
  340. newVal.setId(oldVal.getId()).clean(); // 解决更新情况下:updateTime 不更新
  341. }
  342. return same;
  343. });
  344. // 第二步,批量添加、修改、删除
  345. if (CollUtil.isNotEmpty(diffList.get(0))) {
  346. ${subClassNameVar}Mapper.insertBatch(diffList.get(0));
  347. }
  348. if (CollUtil.isNotEmpty(diffList.get(1))) {
  349. ${subClassNameVar}Mapper.updateBatch(diffList.get(1));
  350. }
  351. if (CollUtil.isNotEmpty(diffList.get(2))) {
  352. ${subClassNameVar}Mapper.deleteByIds(convertList(diffList.get(2), ${subTable.className}DO::getId));
  353. }
  354. }
  355. #else
  356. private void create${subSimpleClassName}(${primaryColumn.javaType} ${subJoinColumn.javaField}, ${subTable.className}DO ${subClassNameVar}) {
  357. if (${subClassNameVar} == null) {
  358. return;
  359. }
  360. ${subClassNameVar}.set$SubJoinColumnName(${subJoinColumn.javaField});
  361. ${subClassNameVars.get($index)}Mapper.insert(${subClassNameVar});
  362. }
  363. private void update${subSimpleClassName}(${primaryColumn.javaType} ${subJoinColumn.javaField}, ${subTable.className}DO ${subClassNameVar}) {
  364. if (${subClassNameVar} == null) {
  365. return;
  366. }
  367. ${subClassNameVar}.set$SubJoinColumnName(${subJoinColumn.javaField}).clean();// 解决更新情况下:updateTime 不更新
  368. ${subClassNameVars.get($index)}Mapper.insertOrUpdate(${subClassNameVar});
  369. }
  370. #end
  371. #end
  372. private void delete${subSimpleClassName}By${SubJoinColumnName}(${primaryColumn.javaType} ${subJoinColumn.javaField}) {
  373. ${subClassNameVars.get($index)}Mapper.deleteBy${SubJoinColumnName}(${subJoinColumn.javaField});
  374. }
  375. #if ( $table.templateType != 2 && $deleteBatchEnable)
  376. private void delete${subSimpleClassName}By${SubJoinColumnName}s(List<${primaryColumn.javaType}> ${subJoinColumn.javaField}s) {
  377. ${subClassNameVars.get($index)}Mapper.deleteBy${SubJoinColumnName}s(${subJoinColumn.javaField}s);
  378. }
  379. #end
  380. #end
  381. }