package com.slcf.controller; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.ResponseBody; import org.springframework.web.multipart.MultipartFile; import com.slcf.pojo.DeptBean; import com.slcf.pojo.RoleBean; import com.slcf.pojo.SysLogBean; import com.slcf.pojo.UserBean; import com.slcf.service.DeptService; import com.slcf.service.RoleService; import com.slcf.service.SysLogService; import com.slcf.service.UserService; import com.slcf.util.AuthorityCode; import com.slcf.util.DESPlus; @Controller @RequestMapping("/user") public class UserController { @Resource UserService userService; @Autowired DeptService deptService; @Autowired RoleService roleService; @Autowired SysLogService sysLogService; @RequestMapping("/goMenu.action") public String goMenuPage(HttpServletRequest request){ try { String rid = request.getSession().getAttribute("ROLEID").toString(); String authCode = roleService.getAuthListByRoleMenu(Integer.parseInt(rid), AuthorityCode.MenuCode); request.getSession().setAttribute("AUTHCODE",authCode); // 插入日志 UserBean user = (UserBean) request.getSession().getAttribute("USER"); SysLogBean sysLog = new SysLogBean(); sysLog.setLogin_no(user.getUser_account()); sysLog.setMachine_ip(request.getRemoteAddr()); sysLog.setForm_no("goMenu.action"); sysLog.setTts_keyname("访问:菜单管理"); sysLog.setModi_user(user.getUser_account()); sysLogService.insertSysLog(sysLog); }catch (Exception e) { System.out.println(e.getMessage()); } return "menu"; } @RequestMapping("/goRole.action") public String goRolePage(HttpServletRequest request){ try { String rid = request.getSession().getAttribute("ROLEID").toString(); String authCode = roleService.getAuthListByRoleMenu(Integer.parseInt(rid), AuthorityCode.RoleCode); request.getSession().setAttribute("AUTHCODE",authCode); // 插入日志 UserBean user = (UserBean) request.getSession().getAttribute("USER"); SysLogBean sysLog = new SysLogBean(); sysLog.setLogin_no(user.getUser_account()); sysLog.setMachine_ip(request.getRemoteAddr()); sysLog.setForm_no("goRole.action"); sysLog.setTts_keyname("访问:角色管理"); sysLog.setModi_user(user.getUser_account()); sysLogService.insertSysLog(sysLog); }catch (Exception e) { System.out.println(e.getMessage()); } return "role"; } @RequestMapping("/goAuth.action") public String goAuthPage(){ return "auth"; } @RequestMapping("/goUser.action") public String goUserPage(HttpServletRequest request){ try { String rid = request.getSession().getAttribute("ROLEID").toString(); String authCode = roleService.getAuthListByRoleMenu(Integer.parseInt(rid), AuthorityCode.UserCode); request.getSession().setAttribute("AUTHCODE",authCode); // 插入日志 UserBean user = (UserBean) request.getSession().getAttribute("USER"); SysLogBean sysLog = new SysLogBean(); sysLog.setLogin_no(user.getUser_account()); sysLog.setMachine_ip(request.getRemoteAddr()); sysLog.setForm_no("goUser.action"); sysLog.setTts_keyname("访问:用户管理"); sysLog.setModi_user(user.getUser_account()); sysLogService.insertSysLog(sysLog); }catch (Exception e) { System.out.println(e.getMessage()); } return "user"; } @RequestMapping("/goChar.action") public String goHightPage(){ return "hight"; } /** * 分页查询所以user表 * @param pageNumber * @param pageSize * @return */ @ResponseBody @RequestMapping("/userList.action") public Map getUserList( @RequestParam(value="pageNumber",defaultValue="0",required=false)int pageNumber, @RequestParam("pageSize")int pageSize){ try { Mapmap=userService.getUserList(pageNumber, pageSize); return map; }catch (Exception e) { System.out.println(e.getMessage()); return null; } } /** * 修改用户密码 * @param uid * @param pass * @param request * @return */ @ResponseBody @RequestMapping("/upPass.action") public int upPass(@RequestParam("id")int uid,@RequestParam("pass")String pass,HttpServletRequest request){ int i=0; try { //密码DES加密 String user_password = new DESPlus().encrypt(pass); i = userService.upPass(uid, user_password, request); if(i>0) { // 插入日志 UserBean user = (UserBean) request.getSession().getAttribute("USER"); SysLogBean sysLog = new SysLogBean(); sysLog.setLogin_no(user.getUser_account()); sysLog.setMachine_ip(request.getRemoteAddr()); sysLog.setForm_no("upPass.action"); sysLog.setTts_keyname("修改密码:" + user.getUser_name()); sysLog.setModi_user(user.getUser_account()); sysLogService.insertSysLog(sysLog); } }catch (Exception e) { System.out.println(e.getMessage()); } return i; } /** * 验证用户登录账号是否唯一 * @param account * @param uid * @return */ @ResponseBody @RequestMapping("/validAccount.action") public Map validUserAccount( @RequestParam("account")String account, @RequestParam(value="uid",defaultValue="0",required=false)int uid){ Map map=new HashMap(); try { boolean flag = userService.validUserAccount(account, uid); if (flag) { map.put("msg", "此账号可用"); } else { map.put("msg", "此账号不可用"); } }catch (Exception e) { System.out.println(e.getMessage()); } return map; } /** * 添加用户 * @param user * @return */ @ResponseBody @RequestMapping("/saveUser.action") public int saveUser(UserBean user,HttpServletRequest request){ int i=0; try { //密码DES加密 String user_password = new DESPlus().encrypt(user.getUser_password()); user.setUser_password(user_password); i = userService.saveUser(user, request); if(i>0) { // 插入日志 UserBean userBean = (UserBean) request.getSession().getAttribute("USER"); SysLogBean sysLog = new SysLogBean(); sysLog.setLogin_no(userBean.getUser_account()); sysLog.setMachine_ip(request.getRemoteAddr()); sysLog.setForm_no("saveUser.action"); sysLog.setTts_keyname("添加用户:" + user.getUser_account()); sysLog.setModi_user(userBean.getUser_account()); sysLogService.insertSysLog(sysLog); } }catch (Exception e) { System.out.println(e.getMessage()); } return i; } /** * 删除用户 * @param id * @return */ @ResponseBody @RequestMapping("/delUser.action") public int delUser(@RequestParam("uid")int id,HttpServletRequest request){ int i=0; try { i = userService.delUser(id); if(i>0) { // 插入日志 UserBean user = (UserBean) request.getSession().getAttribute("USER"); SysLogBean sysLog = new SysLogBean(); sysLog.setLogin_no(user.getUser_account()); sysLog.setMachine_ip(request.getRemoteAddr()); sysLog.setForm_no("delUser.action"); sysLog.setTts_keyname("删除用户,ID:" + id); sysLog.setModi_user(user.getUser_account()); sysLogService.insertSysLog(sysLog); } }catch (Exception e) { System.out.println(e.getMessage()); } return i; } /** * 批量删除用户 * @param ids * @return */ @ResponseBody @RequestMapping("/delUsers.action") public int delUsers(@RequestParam("ids")int[] ids,HttpServletRequest request){ int i=0; try { i = userService.delUsers(ids); if(i>0) { // 插入日志 UserBean user = (UserBean) request.getSession().getAttribute("USER"); SysLogBean sysLog = new SysLogBean(); sysLog.setLogin_no(user.getUser_account()); sysLog.setMachine_ip(request.getRemoteAddr()); sysLog.setForm_no("delUsers.action"); sysLog.setTts_keyname("批量删除用户,ID:" + ids); sysLog.setModi_user(user.getUser_account()); sysLogService.insertSysLog(sysLog); } }catch (Exception e) { System.out.println(e.getMessage()); } return i; } /** * 根据用户id查询用户信息 * @param id * @return */ @ResponseBody @RequestMapping("/getUserById.action") public Map queryUserById(@RequestParam("uid")int id){ Mapmap=new HashMap(); try { Listdlist=deptService.getDeptList(); UserBean user=userService.queryUserById(id); //密码DES解密 String user_password = new DESPlus().decrypt(user.getUser_password()); user.setUser_password(user_password); map.put("user", user); map.put("dept", dlist); }catch (Exception e) { System.out.println(e.getMessage()); } return map; } /** * 修改用户 * @param user * @param request * @return */ @ResponseBody @RequestMapping("/upUser.action") public int upUser(UserBean user,HttpServletRequest request){ int i=0; try { //密码DES加密 String user_password = new DESPlus().encrypt(user.getUser_password()); user.setUser_password(user_password); i = userService.upUser(user, request); if(i>0) { // 插入日志 UserBean userBean = (UserBean) request.getSession().getAttribute("USER"); SysLogBean sysLog = new SysLogBean(); sysLog.setLogin_no(userBean.getUser_account()); sysLog.setMachine_ip(request.getRemoteAddr()); sysLog.setForm_no("upUser.action"); sysLog.setTts_keyname("修改用户:" + user.getUser_name()); sysLog.setModi_user(userBean.getUser_account()); sysLogService.insertSysLog(sysLog); } }catch (Exception e) { System.out.println(e.getMessage()); } return i; } /** * 查询用户拥有的角色 * @param uid * @return */ @ResponseBody @RequestMapping("/getRole.action") public Map getRole(@RequestParam("uid")int uid){ Map map=new HashMap(); try { // Listrlist=roleService.getRoleList(); List userRoleList=userService.getUserRole(uid); // map.put("role", rlist); map.put("userRole", userRoleList.get(0)); }catch (Exception e) { System.out.println(e.getMessage()); } return map; } /** * 查询用户拥有的角色 * @param uid * @return */ @ResponseBody @RequestMapping("/getRoleList.action") public Map getRoleList(){ Map map=new HashMap(); try { Listrlist=roleService.getRoleList(); map.put("rows", rlist); }catch (Exception e) { System.out.println(e.getMessage()); } return map; } /** * 修改用户角色 * @param uid * @param rid * @return */ @ResponseBody @RequestMapping("/upUserRple.action") public boolean saveUserRole(@RequestParam("uid")int uid,@RequestParam("rid")String ridStr, HttpServletRequest request){ boolean flag=false; try { flag = userService.saveUserRole(uid, ridStr); if(flag) { // 插入日志 UserBean user = (UserBean) request.getSession().getAttribute("USER"); SysLogBean sysLog = new SysLogBean(); sysLog.setLogin_no(user.getUser_account()); sysLog.setMachine_ip(request.getRemoteAddr()); sysLog.setForm_no("upUserRple.action"); sysLog.setTts_keyname("修改用户角色,ID:" + uid); sysLog.setModi_user(user.getUser_account()); sysLogService.insertSysLog(sysLog); } }catch (Exception e) { System.out.println(e.getMessage()); } return flag; } /** * 导出所有 * @param response */ @RequestMapping("/export.action") public void ExportExcel(HttpServletResponse response,HttpServletRequest request){ try { userService.ExportUserList(response); // 插入日志 UserBean user = (UserBean) request.getSession().getAttribute("USER"); SysLogBean sysLog = new SysLogBean(); sysLog.setLogin_no(user.getUser_account()); sysLog.setMachine_ip(request.getRemoteAddr()); sysLog.setForm_no("export.action"); sysLog.setTts_keyname("导出用户EXCEL"); sysLog.setModi_user(user.getUser_account()); sysLogService.insertSysLog(sysLog); }catch (Exception e) { System.out.println(e.getMessage()); } } /** * 导入 * @param file * @return */ @ResponseBody @RequestMapping("/import.action") public Map importExcel(@RequestParam("files")MultipartFile file, HttpServletRequest request){ Map map = new HashMap(); try { map = userService.importExcel(file); // 插入日志 UserBean user = (UserBean) request.getSession().getAttribute("USER"); SysLogBean sysLog = new SysLogBean(); sysLog.setLogin_no(user.getUser_account()); sysLog.setMachine_ip(request.getRemoteAddr()); sysLog.setForm_no("export.action"); sysLog.setTts_keyname("导入用户EXCEL"); sysLog.setModi_user(user.getUser_account()); sysLogService.insertSysLog(sysLog); }catch (Exception e) { System.out.println(e.getMessage()); } return map; } /** * 条件查询 * @return */ @ResponseBody @RequestMapping("/getUserByCon.action") public Map getUseByCon( @RequestParam("pageNumber")Integer pageNumber, @RequestParam("pageSize")Integer pageSize, @RequestParam(value="userId",required=false,defaultValue="0")Integer userId, @RequestParam(value="userName",required=false,defaultValue="")String userName, @RequestParam(value="deptId",required=false,defaultValue="0")Integer deptId){ // return userService.getUserListByCon((pageNumber-1)*pageSize, pageNumber*pageSize, userId, userName, deptId); try { return userService.getUserListByCon(pageNumber, pageSize, userId, userName, deptId); }catch (Exception e) { System.out.println(e.getMessage()); return null; } } /** * 获取报表数据 * @return */ @ResponseBody @RequestMapping("/hightInfo.action") public Map getHightsInfo(){ try { return userService.getHightsInfo(); }catch (Exception e) { System.out.println(e.getMessage()); return null; } } }