serviceImpl.vm 16 KB

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