serviceImpl.vm 19 KB

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