1
0

UserController.java 4.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152
  1. package com.kmall.admin.controller;
  2. import com.kmall.admin.entity.UserEntity;
  3. import com.kmall.admin.service.UserService;
  4. import com.kmall.admin.utils.ParamUtils;
  5. import com.kmall.common.utils.PageUtils;
  6. import com.kmall.common.utils.Query;
  7. import com.kmall.common.utils.R;
  8. import com.kmall.common.utils.excel.ExcelExport;
  9. import org.apache.shiro.authz.annotation.RequiresPermissions;
  10. import org.springframework.beans.factory.annotation.Autowired;
  11. import org.springframework.web.bind.annotation.*;
  12. import javax.servlet.http.HttpServletResponse;
  13. import java.util.ArrayList;
  14. import java.util.LinkedHashMap;
  15. import java.util.List;
  16. import java.util.Map;
  17. /**
  18. * Controller
  19. *
  20. * @author Scott
  21. * @email
  22. * @date 2017-08-16 15:02:28
  23. */
  24. @RestController
  25. @RequestMapping("user")
  26. public class UserController {
  27. @Autowired
  28. private UserService userService;
  29. /**
  30. * 查看列表
  31. */
  32. @RequestMapping("/list")
  33. @RequiresPermissions("user:list")
  34. public R list(@RequestParam Map<String, Object> params) {
  35. ParamUtils.setQueryPowerByRoleType(params, "storeId", "merchSn", "thirdPartyMerchCode");
  36. //查询列表数据
  37. Query query = new Query(params);
  38. List<UserEntity> userList = userService.queryList(query);
  39. int total = userService.queryTotal(query);
  40. PageUtils pageUtil = new PageUtils(userList, total, query.getLimit(), query.getPage());
  41. return R.ok().put("page", pageUtil);
  42. }
  43. /**
  44. * 查看信息
  45. */
  46. @RequestMapping("/info/{id}")
  47. @RequiresPermissions("user:info")
  48. public R info(@PathVariable("id") Integer id) {
  49. UserEntity user = userService.queryObject(id);
  50. return R.ok().put("user", user);
  51. }
  52. /**
  53. * 保存
  54. */
  55. @RequestMapping("/save")
  56. @RequiresPermissions("user:save")
  57. public R save(@RequestBody UserEntity user) {
  58. userService.save(user);
  59. return R.ok();
  60. }
  61. /**
  62. * 修改
  63. */
  64. @RequestMapping("/update")
  65. @RequiresPermissions("user:update")
  66. public R update(@RequestBody UserEntity user) {
  67. userService.update(user);
  68. return R.ok();
  69. }
  70. /**
  71. * 删除
  72. */
  73. @RequestMapping("/delete")
  74. @RequiresPermissions("user:delete")
  75. public R delete(@RequestBody Integer[] ids) {
  76. userService.deleteBatch(ids);
  77. return R.ok();
  78. }
  79. /**
  80. * 查看所有列表
  81. */
  82. @RequestMapping("/queryAll")
  83. public R queryAll(@RequestParam Map<String, Object> params) {
  84. List<UserEntity> userList = userService.queryList(params);
  85. return R.ok().put("list", userList);
  86. }
  87. /**
  88. * 总计
  89. */
  90. @RequestMapping("/queryTotal")
  91. public R queryTotal(@RequestParam Map<String, Object> params) {
  92. ParamUtils.setQueryPowerByRoleType(params, "storeId", "merchSn", "thirdPartyMerchCode");
  93. int sum = userService.queryTotal(params);
  94. return R.ok().put("userSum", sum);
  95. }
  96. /**
  97. * 导出会员
  98. */
  99. @RequestMapping("/export")
  100. @RequiresPermissions("user:export")
  101. public R export(@RequestParam Map<String, Object> params, HttpServletResponse response) {
  102. List<UserEntity> userList = userService.queryList(params);
  103. ExcelExport ee = new ExcelExport("会员列表");
  104. String[] header = new String[]{"会员微信名称", "会员名称", "性别", "会员级别", "手机号码", "身份证"};
  105. List<Map<String, Object>> list = new ArrayList<>();
  106. if (userList != null && userList.size() != 0) {
  107. for (UserEntity userEntity : userList) {
  108. LinkedHashMap<String, Object> map = new LinkedHashMap<>();
  109. map.put("NICKNAME", userEntity.getNickname());
  110. map.put("USERNAME", userEntity.getUsername());
  111. map.put("GENDER", userEntity.getGender() == 1 ? "男" : (userEntity.getGender() == 2 ? "女" : "未知"));
  112. map.put("LEVEL_NAME", userEntity.getLevelName());
  113. map.put("MOBILE", userEntity.getMobile());
  114. map.put("IDNO", userEntity.getIdNo());
  115. list.add(map);
  116. }
  117. }
  118. ee.addSheetByMap("会员", list, header);
  119. ee.export(response);
  120. return R.ok();
  121. }
  122. }