package com.kmall.admin.controller; import com.kmall.admin.entity.UserEntity; import com.kmall.admin.service.UserService; import com.kmall.common.utils.PageUtils; import com.kmall.common.utils.Query; import com.kmall.common.utils.R; import com.kmall.common.utils.excel.ExcelExport; import org.apache.shiro.authz.annotation.RequiresPermissions; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import javax.servlet.http.HttpServletResponse; import java.util.ArrayList; import java.util.LinkedHashMap; import java.util.List; import java.util.Map; /** * Controller * * @author Scott * @email * @date 2017-08-16 15:02:28 */ @RestController @RequestMapping("user") public class UserController { @Autowired private UserService userService; /** * 查看列表 */ @RequestMapping("/list") @RequiresPermissions("user:list") public R list(@RequestParam Map params) { //查询列表数据 Query query = new Query(params); List userList = userService.queryList(query); int total = userService.queryTotal(query); PageUtils pageUtil = new PageUtils(userList, total, query.getLimit(), query.getPage()); return R.ok().put("page", pageUtil); } /** * 查看信息 */ @RequestMapping("/info/{id}") @RequiresPermissions("user:info") public R info(@PathVariable("id") Integer id) { UserEntity user = userService.queryObject(id); return R.ok().put("user", user); } /** * 保存 */ @RequestMapping("/save") @RequiresPermissions("user:save") public R save(@RequestBody UserEntity user) { userService.save(user); return R.ok(); } /** * 修改 */ @RequestMapping("/update") @RequiresPermissions("user:update") public R update(@RequestBody UserEntity user) { userService.update(user); return R.ok(); } /** * 删除 */ @RequestMapping("/delete") @RequiresPermissions("user:delete") public R delete(@RequestBody Integer[] ids) { userService.deleteBatch(ids); return R.ok(); } /** * 查看所有列表 */ @RequestMapping("/queryAll") public R queryAll(@RequestParam Map params) { List userList = userService.queryList(params); return R.ok().put("list", userList); } /** * 总计 */ @RequestMapping("/queryTotal") public R queryTotal(@RequestParam Map params) { int sum = userService.queryTotal(params); return R.ok().put("userSum", sum); } /** * 导出会员 */ @RequestMapping("/export") @RequiresPermissions("user:export") public R export(@RequestParam Map params, HttpServletResponse response) { List userList = userService.queryList(params); ExcelExport ee = new ExcelExport("会员列表"); String[] header = new String[]{"会员微信名称", "会员名称", "性别", "会员级别", "手机号码", "身份证"}; List> list = new ArrayList<>(); if (userList != null && userList.size() != 0) { for (UserEntity userEntity : userList) { LinkedHashMap map = new LinkedHashMap<>(); map.put("NICKNAME", userEntity.getNickname()); map.put("USERNAME", userEntity.getUsername()); map.put("GENDER", userEntity.getGender() == 1 ? "男" : (userEntity.getGender() == 2 ? "女" : "未知")); map.put("LEVEL_NAME", userEntity.getLevelName()); map.put("MOBILE", userEntity.getMobile()); map.put("IDNO", userEntity.getIdNo()); list.add(map); } } ee.addSheetByMap("会员", list, header); ee.export(response); return R.ok(); } }