Пример #1
0
  /** 批量删除 */
  @RequestMapping(value = "/deleteAllU")
  @ResponseBody
  public Object deleteAllU() {
    PageData pd = new PageData();
    Map<String, Object> map = new HashMap<String, Object>();
    try {
      pd = this.getPageData();
      List<PageData> pdList = new ArrayList<PageData>();
      String USER_IDS = pd.getString("USER_IDS");

      if (null != USER_IDS && !"".equals(USER_IDS)) {
        String ArrayUSER_IDS[] = USER_IDS.split(",");
        if (Jurisdiction.buttonJurisdiction(menuUrl, "del")) {
          userService.deleteAllU(ArrayUSER_IDS);
        }
        pd.put("msg", "ok");
      } else {
        pd.put("msg", "no");
      }

      pdList.add(pd);
      map.put("list", pdList);
    } catch (Exception e) {
      logger.error(e.toString(), e);
    } finally {
      logAfter(logger);
    }
    return AppUtil.returnObject(pd, map);
  }
Пример #2
0
  /** 保存用户 */
  @RequestMapping(value = "/saveU")
  public ModelAndView saveU(PrintWriter out) throws Exception {
    ModelAndView mv = this.getModelAndView();
    PageData pd = new PageData();
    pd = this.getPageData();

    pd.put("USER_ID", this.get32UUID()); // ID
    pd.put("RIGHTS", ""); // 权限
    pd.put("LAST_LOGIN", ""); // 最后登录时间
    pd.put("IP", ""); // IP
    pd.put("STATUS", "0"); // 状态
    pd.put("SKIN", "default"); // 默认皮肤

    pd.put(
        "PASSWORD",
        new SimpleHash("SHA-1", pd.getString("USERNAME"), pd.getString("PASSWORD")).toString());

    if (null == userService.findByUId(pd)) {
      if (Jurisdiction.buttonJurisdiction(menuUrl, "add")) {
        userService.saveU(pd);
      } // 判断新增权限
      mv.addObject("msg", "success");
    } else {
      mv.addObject("msg", "failed");
    }
    mv.setViewName("save_result");
    return mv;
  }
Пример #3
0
 /** 删除用户 */
 @RequestMapping(value = "/deleteU")
 public void deleteU(PrintWriter out) {
   PageData pd = new PageData();
   try {
     pd = this.getPageData();
     if (Jurisdiction.buttonJurisdiction(menuUrl, "del")) {
       userService.deleteU(pd);
     }
     out.write("success");
     out.close();
   } catch (Exception e) {
     logger.error(e.toString(), e);
   }
 }
Пример #4
0
 /** 修改用户 */
 @RequestMapping(value = "/editU")
 public ModelAndView editU(PrintWriter out) throws Exception {
   ModelAndView mv = this.getModelAndView();
   PageData pd = new PageData();
   pd = this.getPageData();
   if (pd.getString("PASSWORD") != null && !"".equals(pd.getString("PASSWORD"))) {
     pd.put("PASSWORD", MD5.md5(pd.getString("PASSWORD")));
   }
   if (Jurisdiction.buttonJurisdiction(menuUrl, "edit")) {
     appuserService.editU(pd);
   }
   mv.addObject("msg", "success");
   mv.setViewName("save_result");
   return mv;
 }
Пример #5
0
 /** 修改用户 */
 @RequestMapping(value = "/editU")
 public ModelAndView editU() throws Exception {
   ModelAndView mv = this.getModelAndView();
   PageData pd = new PageData();
   pd = this.getPageData();
   if (pd.getString("PASSWORD") != null && !"".equals(pd.getString("PASSWORD"))) {
     pd.put(
         "PASSWORD",
         new SimpleHash("SHA-1", pd.getString("USERNAME"), pd.getString("PASSWORD")).toString());
   }
   if (Jurisdiction.buttonJurisdiction(menuUrl, "edit")) {
     userService.editU(pd);
   }
   mv.addObject("msg", "success");
   mv.setViewName("save_result");
   return mv;
 }
Пример #6
0
  /** 从EXCEL导入到数据库 */
  @RequestMapping(value = "/readExcel")
  public ModelAndView readExcel(@RequestParam(value = "excel", required = false) MultipartFile file)
      throws Exception {
    ModelAndView mv = this.getModelAndView();
    PageData pd = new PageData();
    if (!Jurisdiction.buttonJurisdiction(menuUrl, "add")) {
      return null;
    }
    if (null != file && !file.isEmpty()) {
      String filePath = PathUtil.getClasspath() + Const.FILEPATHFILE; // 文件上传路径
      String fileName = FileUpload.fileUp(file, filePath, "userexcel"); // 执行上传

      List<PageData> listPd =
          (List)
              ObjectExcelRead.readExcel(
                  filePath, fileName, 2, 0,
                  0); // 执行读EXCEL操作,读出的数据导入List 2:从第3行开始;0:从第A列开始;0:第0个sheet

      /*存入数据库操作======================================*/
      pd.put("RIGHTS", ""); // 权限
      pd.put("LAST_LOGIN", ""); // 最后登录时间
      pd.put("IP", ""); // IP
      pd.put("STATUS", "0"); // 状态
      pd.put("SKIN", "default"); // 默认皮肤

      List<Role> roleList = roleService.listAllERRoles(); // 列出所有二级角色

      pd.put("ROLE_ID", roleList.get(0).getROLE_ID()); // 设置角色ID为随便第一个
      /** var0 :编号 var1 :姓名 var2 :手机 var3 :邮箱 var4 :备注 */
      for (int i = 0; i < listPd.size(); i++) {
        pd.put("USER_ID", this.get32UUID()); // ID
        pd.put("NAME", listPd.get(i).getString("var1")); // 姓名

        String USERNAME = GetPinyin.getPingYin(listPd.get(i).getString("var1")); // 根据姓名汉字生成全拼
        pd.put("USERNAME", USERNAME);
        if (userService.findByUId(pd) != null) { // 判断用户名是否重复
          USERNAME = GetPinyin.getPingYin(listPd.get(i).getString("var1")) + Tools.getRandomNum();
          pd.put("USERNAME", USERNAME);
        }
        pd.put("BZ", listPd.get(i).getString("var4")); // 备注
        if (Tools.checkEmail(listPd.get(i).getString("var3"))) { // 邮箱格式不对就跳过
          pd.put("EMAIL", listPd.get(i).getString("var3"));
          if (userService.findByUE(pd) != null) { // 邮箱已存在就跳过
            continue;
          }
        } else {
          continue;
        }

        pd.put("NUMBER", listPd.get(i).getString("var0")); // 编号已存在就跳过
        pd.put("PHONE", listPd.get(i).getString("var2")); // 手机号

        pd.put("PASSWORD", new SimpleHash("SHA-1", USERNAME, "123").toString()); // 默认密码123
        if (userService.findByUN(pd) != null) {
          continue;
        }
        userService.saveU(pd);
      }
      /*存入数据库操作======================================*/

      mv.addObject("msg", "success");
    }

    mv.setViewName("save_result");
    return mv;
  }
Пример #7
0
  /*
   * 导出用户信息到EXCEL
   * @return
   */
  @RequestMapping(value = "/excel")
  public ModelAndView exportExcel() {
    ModelAndView mv = this.getModelAndView();
    PageData pd = new PageData();
    pd = this.getPageData();
    try {
      if (Jurisdiction.buttonJurisdiction(menuUrl, "cha")) {
        // 检索条件===
        String USERNAME = pd.getString("USERNAME");
        if (null != USERNAME && !"".equals(USERNAME)) {
          USERNAME = USERNAME.trim();
          pd.put("USERNAME", USERNAME);
        }
        String lastLoginStart = pd.getString("lastLoginStart");
        String lastLoginEnd = pd.getString("lastLoginEnd");
        if (lastLoginStart != null && !"".equals(lastLoginStart)) {
          lastLoginStart = lastLoginStart + " 00:00:00";
          pd.put("lastLoginStart", lastLoginStart);
        }
        if (lastLoginEnd != null && !"".equals(lastLoginEnd)) {
          lastLoginEnd = lastLoginEnd + " 00:00:00";
          pd.put("lastLoginEnd", lastLoginEnd);
        }
        // 检索条件===

        Map<String, Object> dataMap = new HashMap<String, Object>();
        List<String> titles = new ArrayList<String>();

        titles.add("用户名"); // 1
        titles.add("编号"); // 2
        titles.add("姓名"); // 3
        titles.add("职位"); // 4
        titles.add("手机"); // 5
        titles.add("邮箱"); // 6
        titles.add("最近登录"); // 7
        titles.add("上次登录IP"); // 8

        dataMap.put("titles", titles);

        List<PageData> userList = userService.listAllUser(pd);
        List<PageData> varList = new ArrayList<PageData>();
        for (int i = 0; i < userList.size(); i++) {
          PageData vpd = new PageData();
          vpd.put("var1", userList.get(i).getString("USERNAME")); // 1
          vpd.put("var2", userList.get(i).getString("NUMBER")); // 2
          vpd.put("var3", userList.get(i).getString("NAME")); // 3
          vpd.put("var4", userList.get(i).getString("ROLE_NAME")); // 4
          vpd.put("var5", userList.get(i).getString("PHONE")); // 5
          vpd.put("var6", userList.get(i).getString("EMAIL")); // 6
          vpd.put("var7", userList.get(i).getString("LAST_LOGIN")); // 7
          vpd.put("var8", userList.get(i).getString("IP")); // 8
          varList.add(vpd);
        }
        dataMap.put("varList", varList);
        ObjectExcelView erv = new ObjectExcelView(); // 执行excel操作
        mv = new ModelAndView(erv, dataMap);
      }
    } catch (Exception e) {
      logger.error(e.toString(), e);
    }
    return mv;
  }