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<String,Object> getUserList(
|
@RequestParam(value="pageNumber",defaultValue="0",required=false)int pageNumber,
|
@RequestParam("pageSize")int pageSize){
|
try {
|
Map<String,Object>map=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<String,Object> validUserAccount(
|
@RequestParam("account")String account,
|
@RequestParam(value="uid",defaultValue="0",required=false)int uid){
|
Map<String,Object> map=new HashMap<String, Object>();
|
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<String,Object> queryUserById(@RequestParam("uid")int id){
|
Map<String,Object>map=new HashMap<String, Object>();
|
try {
|
List<DeptBean>dlist=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<String,Object> getRole(@RequestParam("uid")int uid){
|
Map<String,Object> map=new HashMap<String, Object>();
|
try {
|
// List<RoleBean>rlist=roleService.getRoleList();
|
List<Integer> 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<String,Object> getRoleList(){
|
Map<String,Object> map=new HashMap<String, Object>();
|
try {
|
List<RoleBean>rlist=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<String,Object> importExcel(@RequestParam("files")MultipartFile file,
|
HttpServletRequest request){
|
Map<String,Object> map = new HashMap<String, Object>();
|
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<String,Object> 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<String,Object> getHightsInfo(){
|
try {
|
return userService.getHightsInfo();
|
}catch (Exception e) {
|
System.out.println(e.getMessage());
|
return null;
|
}
|
}
|
}
|