DataDictionaryController.java 9.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277
  1. package com.jpsoft.smart.modules.sys.controller;
  2. import com.github.pagehelper.Page;
  3. import com.jpsoft.smart.modules.common.dto.MessageResult;
  4. import com.jpsoft.smart.modules.common.dto.Sort;
  5. import com.jpsoft.smart.modules.common.utils.PojoUtils;
  6. import com.jpsoft.smart.modules.sys.entity.DataDictionary;
  7. import com.jpsoft.smart.modules.sys.service.DataDictionaryService;
  8. import io.swagger.annotations.ApiOperation;
  9. import org.apache.commons.lang3.StringUtils;
  10. import org.slf4j.Logger;
  11. import org.slf4j.LoggerFactory;
  12. import org.springframework.beans.factory.annotation.Autowired;
  13. import org.springframework.web.bind.annotation.*;
  14. import java.util.*;
  15. @RestController
  16. @RequestMapping("/sys/dataDictionary")
  17. public class DataDictionaryController {
  18. private Logger logger = LoggerFactory.getLogger(getClass());
  19. @Autowired
  20. private DataDictionaryService dataDictionaryService;
  21. @ApiOperation(value="创建空记录")
  22. @GetMapping("create")
  23. public MessageResult<DataDictionary> create(){
  24. MessageResult<DataDictionary> msgResult = new MessageResult<>();
  25. DataDictionary dataDictionary = new DataDictionary();
  26. msgResult.setData(dataDictionary);
  27. msgResult.setResult(true);
  28. return msgResult;
  29. }
  30. @ApiOperation(value="添加信息")
  31. @PostMapping("add")
  32. public MessageResult<DataDictionary> add(@RequestBody DataDictionary dataDictionary,@RequestAttribute String subject){
  33. MessageResult<DataDictionary> msgResult = new MessageResult<>();
  34. try {
  35. dataDictionary.setId(UUID.randomUUID().toString());
  36. dataDictionary.setDelFlag(false);
  37. dataDictionary.setCreateBy(subject);
  38. dataDictionary.setCreateDate(new Date());
  39. int affectCount = dataDictionaryService.insert(dataDictionary);
  40. if (affectCount > 0) {
  41. msgResult.setResult(true);
  42. msgResult.setData(dataDictionary);
  43. } else {
  44. msgResult.setResult(false);
  45. msgResult.setMessage("添加失败");
  46. }
  47. }
  48. catch(Exception ex){
  49. logger.error(ex.getMessage(),ex);
  50. msgResult.setResult(false);
  51. msgResult.setMessage("添加失败");
  52. }
  53. return msgResult;
  54. }
  55. @ApiOperation(value="获取信息")
  56. @GetMapping("edit/{id}")
  57. public MessageResult<DataDictionary> edit(@PathVariable("id") String id){
  58. MessageResult<DataDictionary> msgResult = new MessageResult<>();
  59. try {
  60. DataDictionary dataDictionary = dataDictionaryService.get(id);
  61. if (dataDictionary != null) {
  62. msgResult.setResult(true);
  63. msgResult.setData(dataDictionary);
  64. } else {
  65. msgResult.setResult(false);
  66. msgResult.setMessage("不存在该记录!");
  67. }
  68. }
  69. catch(Exception ex){
  70. logger.error(ex.getMessage(),ex);
  71. msgResult.setResult(false);
  72. msgResult.setMessage(ex.getMessage());
  73. }
  74. return msgResult;
  75. }
  76. @ApiOperation(value="更新用户")
  77. @PostMapping("update")
  78. public MessageResult<DataDictionary> update(@RequestBody DataDictionary dataDictionary,@RequestAttribute String subject){
  79. MessageResult<DataDictionary> msgResult = new MessageResult<>();
  80. try {
  81. dataDictionary.setUpdateBy(subject);
  82. dataDictionary.setUpdateDate(new Date());
  83. int affectCount = dataDictionaryService.update(dataDictionary);
  84. if (affectCount > 0) {
  85. msgResult.setResult(true);
  86. msgResult.setData(dataDictionary);
  87. } else {
  88. msgResult.setResult(false);
  89. msgResult.setMessage("更新失败");
  90. }
  91. }
  92. catch(Exception ex){
  93. logger.error(ex.getMessage(),ex);
  94. msgResult.setResult(false);
  95. msgResult.setMessage("更新失败");
  96. }
  97. return msgResult;
  98. }
  99. @ApiOperation(value="删除")
  100. @PostMapping("delete/{id}")
  101. public MessageResult<Integer> delete(@PathVariable("id") String id,@RequestAttribute String subject){
  102. MessageResult<Integer> msgResult = new MessageResult<>();
  103. try {
  104. DataDictionary dataDictionary = dataDictionaryService.get(id);
  105. dataDictionary.setDelFlag(true);
  106. dataDictionary.setUpdateBy(subject);
  107. dataDictionary.setUpdateDate(new Date());
  108. int affectCount = dataDictionaryService.update(dataDictionary);
  109. if (affectCount > 0) {
  110. msgResult.setResult(true);
  111. msgResult.setData(affectCount);
  112. } else {
  113. msgResult.setResult(false);
  114. msgResult.setMessage("删除失败");
  115. }
  116. }
  117. catch(Exception ex){
  118. logger.error(ex.getMessage(),ex);
  119. msgResult.setResult(false);
  120. msgResult.setMessage(ex.getMessage());
  121. }
  122. return msgResult;
  123. }
  124. @ApiOperation(value="批量删除")
  125. @PostMapping("batchDelete")
  126. public MessageResult<Integer> batchDelete(@RequestBody List<String> idList,@RequestAttribute String subject){
  127. MessageResult<Integer> msgResult = new MessageResult<>();
  128. try {
  129. int affectCount = 0;
  130. for (String id : idList) {
  131. DataDictionary dataDictionary = dataDictionaryService.get(id);
  132. //dataDictionary.setDelFlag(true);
  133. dataDictionary.setUpdateBy(subject);
  134. dataDictionary.setUpdateDate(new Date());
  135. affectCount += dataDictionaryService.update(dataDictionary);
  136. }
  137. if (affectCount > 0) {
  138. msgResult.setResult(true);
  139. msgResult.setData(affectCount);
  140. } else {
  141. msgResult.setResult(false);
  142. msgResult.setMessage("删除失败");
  143. }
  144. }
  145. catch(Exception ex){
  146. logger.error(ex.getMessage(),ex);
  147. msgResult.setResult(false);
  148. msgResult.setMessage(ex.getMessage());
  149. }
  150. return msgResult;
  151. }
  152. @ApiOperation(value="列表")
  153. @RequestMapping(value = "pageList",method = RequestMethod.POST)
  154. public MessageResult<Map> pageList(
  155. String id,
  156. String name,
  157. @RequestParam(name="pageIndex",defaultValue = "1") int pageIndex,
  158. @RequestParam(name="pageSize",defaultValue = "10") int pageSize,
  159. @RequestAttribute String subject){
  160. //当前用户ID
  161. System.out.println(subject);
  162. MessageResult<Map> msgResult = new MessageResult<>();
  163. Map<String,Object> searchParams = new HashMap<>();
  164. List<Sort> sortList = new ArrayList<>();
  165. sortList.add(new Sort("sort_no","asc"));
  166. if (StringUtils.isNotEmpty(id)) {
  167. searchParams.put("id",id);
  168. }
  169. if (StringUtils.isNotEmpty(name)) {
  170. searchParams.put("name","%" + name + "%");
  171. }
  172. Page<DataDictionary> page = dataDictionaryService.pageSearch(searchParams,pageIndex, pageSize,sortList);
  173. msgResult.setResult(true);
  174. msgResult.setData(PojoUtils.pageWrapper(page));
  175. return msgResult;
  176. }
  177. @ApiOperation(value = "查询")
  178. @RequestMapping(value = "query", method = RequestMethod.POST)
  179. public MessageResult<List> query(
  180. String keywords,
  181. String excludeId,
  182. @RequestParam(value = "dataType", defaultValue = "null") String dataType,
  183. @RequestParam(value = "length", defaultValue = "20") int limit,
  184. @RequestAttribute String subject) {
  185. MessageResult<List> msgResult = new MessageResult<>();
  186. Map<String, Object> searchParams = new HashMap<>();
  187. List<Sort> sortList = new ArrayList<>();
  188. sortList.add(new Sort("a.sort_no", "asc"));
  189. if (StringUtils.isNotEmpty(keywords)) {
  190. searchParams.put("name", "%" + keywords + "%");
  191. }
  192. if (StringUtils.isNotEmpty(excludeId)) {
  193. searchParams.put("excludeId", excludeId);
  194. }
  195. if (StringUtils.isNotEmpty(dataType)) {
  196. //1查目录-2查值
  197. searchParams.put("dataType", dataType);
  198. }
  199. Page<DataDictionary> page = dataDictionaryService.pageSearch(searchParams,0, limit,sortList);
  200. List<DataDictionary> dataDictionaryList = page.getResult();
  201. msgResult.setResult(true);
  202. msgResult.setData(dataDictionaryList);
  203. return msgResult;
  204. }
  205. @ApiOperation(value = "查询字典")
  206. @RequestMapping(value = "queryChildren", method = RequestMethod.POST)
  207. public MessageResult<List> queryChildren(
  208. @RequestParam(value = "parentId", defaultValue = "") String parentId,
  209. @RequestAttribute String subject) {
  210. MessageResult<List> msgResult = new MessageResult<>();
  211. List<Map<String, Object>> dataDictionaryList = dataDictionaryService.queryChildren(parentId);
  212. msgResult.setResult(true);
  213. msgResult.setData(dataDictionaryList);
  214. return msgResult;
  215. }
  216. }