Esempio n. 1
0
 @WebMethod
 public ModelAndView save(User user, Integer groupId, String roleIds) {
   ModelAndView mv = new ModelAndView();
   if (StringUtils.isEmpty(user.account)) {
     throw new GException(PlatformExceptionType.BusinessException, "用户账号不能为空");
   }
   if (StringUtils.isEmpty(user.name)) {
     throw new GException(PlatformExceptionType.BusinessException, "用户姓名不能为空");
   }
   if (StringUtils.isEmpty(user.pwd)) {
     throw new GException(PlatformExceptionType.BusinessException, "请先设置密码");
   }
   user.isSuperAdmin = 0;
   user.addtime = new Date();
   user.pwd = SecurityHelper.Md5(user.pwd);
   // TODO
   dao.saveOrUpdate(user);
   if (groupId != null) {
     UserGroup ug = new UserGroup();
     ug.gid = groupId;
     ug.uid = user.id;
     dao.saveOrUpdate(ug);
   }
   if (roleIds != null && roleIds.length() != 0) {
     String[] Ids = roleIds.split(",");
     for (int i = 0; i < Ids.length; i++) {
       UserRole rg = new UserRole();
       rg.roleId = Integer.valueOf(Ids[i]);
       rg.uid = user.id;
       dao.saveOrUpdate(rg);
     }
   }
   return mv;
 }
Esempio n. 2
0
 private JSONArray getChildrenOfGroup(Integer groupId, String _site) {
   List<Group> groups =
       dao.listByParams(Group.class, "from Group where parentId = ? and _site=?", groupId, _site);
   JSONArray arr = new JSONArray();
   for (Group g : groups) {
     JSONObject jobj = new JSONObject();
     jobj.put("name", g.name);
     jobj.put("id", g.id);
     jobj.put("type", "group");
     jobj.put("key", "group_" + g.id);
     jobj.put("isParent", true);
     JSONArray children = getChildrenOfGroup(g.id, _site);
     if (!children.isEmpty()) {
       jobj.put("children", children);
     }
     arr.add(jobj);
   }
   List<Map> users =
       dao.listAsMap(
           "select u.name as name , u.id as id from User u , UserGroup ug where u.id = ug.uid and ug.gid=? and u._site=?",
           groupId,
           _site);
   for (Map u : users) {
     JSONObject jobj = new JSONObject();
     jobj.put("name", u.get("name"));
     jobj.put("id", u.get("id"));
     jobj.put("key", "user_" + u.get("id"));
     jobj.put("type", "user");
     arr.add(jobj);
   }
   return arr;
 }
Esempio n. 3
0
  // 产品搜索
  @WebMethod
  public ModelAndView searchGoods(Page<Map> page, String name, Integer uid) {
    ModelAndView mv = new ModelAndView();
    StringBuilder sql =
        new StringBuilder(
            "select goods.id as id , goods.title as title , img.path as img , goods.spec as spec , goods.vender as vender , goods.price as price from Goods goods , Image img  where goods.imgId=img.id ");
    List<Object> params = new ArrayList<Object>();
    if (StringUtils.isNotEmpty(name)) {
      System.out.println(name);
      sql.append(" and title like ?");
      params.add("%" + name + "%");
    }
    page.order = "desc";
    page.orderBy = "addtime";
    page.setPageSize(10);
    page = dao.findPage(page, sql.toString(), true, params.toArray());

    if (StringUtils.isNotEmpty(name)) {
      SearchHistory search = new SearchHistory();
      search.uid = uid;
      search.text = name;
      dao.saveOrUpdate(search);
    }

    mv.data.put("page", JSONHelper.toJSON(page));
    mv.data.put(
        "imgUrl", "http://" + ConfigCache.get("image_host", "localhost") + "/article_image_path");
    mv.data.put(
        "goodsDetailUrl",
        "https://" + ConfigCache.get("app_host", "localhost") + "/goods/view.jsp");
    return mv;
  }
Esempio n. 4
0
 @WebMethod
 public ModelAndView update(User user, String roleIds) {
   ModelAndView mv = new ModelAndView();
   if (StringUtils.isEmpty(user.name)) {
     throw new GException(PlatformExceptionType.BusinessException, "用户名不能为空");
   }
   User po = dao.get(User.class, user.id);
   po.account = user.account;
   po.name = user.name;
   //		String pwd = user.pwd.replace("*", "");
   if (StringUtils.isNotEmpty(user.pwd)) {
     po.pwd = SecurityHelper.Md5(user.pwd);
   }
   po.tel = user.tel;
   dao.saveOrUpdate(po);
   ThreadSession.getHttpSession().setAttribute(MakesiteConstant.Session_Attr_User, po);
   if (roleIds != null && roleIds.length() != 0) {
     String[] Ids = roleIds.split(",");
     dao.execute("delete from UserRole where uid=?", user.id);
     for (int i = 0; i < Ids.length; i++) {
       if (StringUtils.isEmpty(Ids[i])) {
         continue;
       }
       UserRole rg = new UserRole();
       rg.roleId = Integer.valueOf(Ids[i]);
       rg.uid = user.id;
       dao.saveOrUpdate(rg);
     }
   } else {
   }
   return mv;
 }
Esempio n. 5
0
 @WebMethod
 public ModelAndView login(User user, String _site) {
   ModelAndView mv = new ModelAndView();
   String pwd = SecurityHelper.Md5(user.pwd);
   User po =
       dao.getUniqueByParams(
           User.class,
           new String[] {"account", "pwd", "_site"},
           new Object[] {user.account, pwd, _site});
   if (po == null) {
     throw new GException(PlatformExceptionType.BusinessException, "用户名或密码不正确。");
   }
   po.lasttime = new Date();
   dao.saveOrUpdate(po);
   ThreadSession.getHttpSession().setAttribute(MakesiteConstant.Session_Attr_User, po);
   List<Map> result =
       dao.listAsMap(
           "select ra.authId as authId from UserRole ur ,RoleAuth ra where ur.roleId=ra.roleId and ur.uid=?",
           po.id);
   StringBuilder authList = new StringBuilder("");
   for (Map map : result) {
     authList.append(map.get("authId").toString());
   }
   ThreadSession.getHttpSession()
       .setAttribute(MakesiteConstant.Session_Auth_List, authList.toString());
   String serverName = DataHelper.getServerName(ThreadSession.HttpServletRequest.get());
   if (!onlineUserCountMap.containsKey(serverName)) {
     onlineUserCountMap.put(serverName, 1);
   } else {
     onlineUserCountMap.put(serverName, onlineUserCountMap.get(serverName) + 1);
   }
   String text;
   try {
     text =
         FileUtils.readFileToString(
             new File(
                 ThreadSession.HttpServletRequest.get().getServletContext().getRealPath("/")
                     + File.separator
                     + "auths.json"),
             "utf8");
     JSONArray jarr = JSONArray.fromObject(text);
     List<String> urlList = new ArrayList<String>();
     for (int i = 0; i < jarr.size(); i++) {
       JSONObject jobj = jarr.getJSONObject(i);
       if (authList.toString().contains(jobj.getString("id"))) {
         continue;
       }
       String urls = jobj.getString("urls");
       for (String url : urls.split(",")) {
         urlList.add(url);
       }
     }
     ThreadSession.getHttpSession().setAttribute(MakesiteConstant.Session_Auth_Urls, urlList);
   } catch (IOException e) {
     e.printStackTrace();
   }
   return mv;
 }
Esempio n. 6
0
 @WebMethod
 public ModelAndView setCommon(int ndbNo) {
   Food food = service.get(Food.class, ndbNo);
   ModelAndView mv = new ModelAndView();
   if (food != null) {
     food.common = true;
     service.saveOrUpdate(food);
   }
   //		mv.redirect="list";
   mv.data.put("msg", "set common successfully");
   return mv;
 }
Esempio n. 7
0
 // 删除扫描记录
 @WebMethod
 public ModelAndView deleteScanRecord(Integer id) {
   ModelAndView mv = new ModelAndView();
   ScanRecord po = dao.get(ScanRecord.class, id);
   if (po != null) {
     dao.delete(po);
   } else {
     throw new GException(PlatformExceptionType.BusinessException, "记录不存在或已经删除");
   }
   mv.data.put("result", "success");
   return mv;
 }
Esempio n. 8
0
  @WebMethod
  public ModelAndView delete(int id) {
    ModelAndView mv = new ModelAndView();
    User po = dao.get(User.class, id);
    if (po != null) {
      dao.delete(po);
      dao.execute("delete from UserGroup where uid=?", id);
      dao.execute("delete from UserRole where uid=?", id);
      mv.data.put("msg", "删除用户成功");
    }

    return mv;
  }
Esempio n. 9
0
 @WebMethod
 public ModelAndView modifyPwd(int uid, String oldPwd, String newPwd) {
   ModelAndView mv = new ModelAndView();
   User po = dao.get(User.class, uid);
   if (po != null) {
     if (!po.pwd.equals(SecurityHelper.Md5(oldPwd))) {
       throw new GException(PlatformExceptionType.BusinessException, "原密码不正确,请重新输入后重试");
     }
     po.pwd = SecurityHelper.Md5(newPwd);
     dao.saveOrUpdate(po);
   }
   return mv;
 }
Esempio n. 10
0
 @WebMethod
 public ModelAndView banUser(int groupId, int uid) {
   ModelAndView mv = new ModelAndView();
   UserGroup po =
       dao.getUniqueByParams(
           UserGroup.class,
           new String[] {"gid", "uid"},
           new Object[] {groupId, Integer.valueOf(uid)});
   if (po != null) {
     dao.delete(po);
   }
   return mv;
 }
Esempio n. 11
0
 @WebMethod
 public ModelAndView add(Food food) {
   ModelAndView mv = null;
   Food po = service.getUnique(Food.class, food);
   if (po != null) {
     mv = list();
     mv.data.put("msg", food.name + "已经存在");
   } else {
     service.saveOrUpdate(food);
     mv = list();
     mv.data.put("msg", "添加成功");
   }
   return mv;
 }
Esempio n. 12
0
 // 生活帮
 @WebMethod
 public ModelAndView tips(Page<Map> page) {
   ModelAndView mv = new ModelAndView();
   page.setPageSize(3);
   page =
       dao.findPage(
           page,
           "select art.id as id, art.title as title , art.isAd as isTop, art.conts as conts, img.path as img from Article art , Image img where img.id=art.imgId"
               + " and art.leibie='tips' and art.publishFlag=1 order by art.setTopTime desc, art.id desc ",
           true,
           new Object[] {});
   // make abstract
   for (Map art : page.getResult()) {
     String conts = art.get("conts").toString();
     conts = HTMLSpirithHelper.delHTMLTag(conts);
     if (conts.length() > 70) {
       conts = conts.substring(0, 70);
     }
     art.put("conts", conts);
   }
   mv.data.put("tips", JSONHelper.toJSONArray(page.getResult()));
   mv.data.put(
       "imgUrl", "http://" + ConfigCache.get("image_host", "localhost") + "/article_image_path");
   mv.data.put(
       "tipsDetailUrl",
       "https://" + ConfigCache.get("app_host", "localhost") + "/article/view.jsp");
   return mv;
 }
Esempio n. 13
0
 // 批量删除扫描记录
 @WebMethod
 public ModelAndView deleteBatchScanRecord(String ids) {
   ModelAndView mv = new ModelAndView();
   if (StringUtils.isEmpty(ids)) {
     throw new GException(PlatformExceptionType.BusinessException, "参数ids不能为空");
   }
   String[] idArr = ids.split(",");
   for (String id : idArr) {
     ScanRecord po = dao.get(ScanRecord.class, Integer.valueOf(id));
     if (po != null) {
       dao.delete(po);
     }
   }
   mv.data.put("result", "success");
   return mv;
 }
Esempio n. 14
0
  /**
   * 扫描历史记录
   *
   * @param page
   * @param uid
   * @param type
   * @param device
   * @return
   */
  @WebMethod
  public ModelAndView listScanRecord(Page<Map> page, Integer uid, Integer type, String device) {
    ModelAndView mv = new ModelAndView();
    StringBuilder hql =
        new StringBuilder(
            "select p.id as id, p.title as title , p.vender as vender , p.spec as spec,record.addtime as addtime , img.path as img,record.id as scanId from Product p ,ScanRecord record , Image img where record.productId=p.id and p.imgId=img.id ");
    List<Object> params = new ArrayList<Object>();

    hql.append(" and record.type=? ");
    params.add(type);

    hql.append(" and (record.device=? ");

    params.add(device);
    if (uid != null) {
      hql.append(" or record.uid=? ");
      params.add(uid);
    }
    hql.append(")");
    LogUtil.info(
        "listScanRecord uid=" + uid + ",device=" + device + ",type=" + type + ",hql=" + hql);
    page = dao.findPage(page, hql.toString(), true, params.toArray());
    mv.data.put("page", JSONHelper.toJSON(page));
    mv.data.put(
        "productDetailUrl",
        "https://" + ConfigCache.get("app_host", "localhost") + "/product/view.jsp");
    mv.data.put(
        "imgUrl", "http://" + ConfigCache.get("image_host", "localhost") + "/article_image_path");
    return mv;
  }
Esempio n. 15
0
 @WebMethod
 public ModelAndView get(int id) {
   ModelAndView mv = new ModelAndView();
   FeedBack po = dao.get(FeedBack.class, id);
   mv.data.put("feedback", JSONHelper.toJSON(po));
   return mv;
 }
Esempio n. 16
0
 @WebMethod
 public ModelAndView listCommon() {
   List<Food> foods = service.listByParams(Food.class, "from Food where common=1", null, null);
   ModelAndView mv = new ModelAndView();
   mv.data.put("foods", foods);
   mv.jsp = "/Food.jsp";
   return mv;
 }
Esempio n. 17
0
  // 首页初始化
  @WebMethod
  public ModelAndView init(String tel) {
    // https://localhost:8181/c/app/init
    ModelAndView mv = new ModelAndView();
    // 新闻
    Page<Map> page = new Page<Map>();
    page.setPageSize(2);
    page =
        dao.findPage(
            page,
            "select art.id as id, art.title as title , art.conts as conts, img.path as img from Article art , Image img where img.id=art.imgId and art.publishFlag=1"
                + " and art.leibie='news' order by art.setTopTime desc, art.id desc ",
            true,
            new Object[] {});
    // make abstract
    for (Map art : page.getResult()) {
      String conts = art.get("conts").toString();
      conts = HTMLSpirithHelper.delHTMLTag(conts);
      if (conts.length() > 70) {
        conts = conts.substring(0, 70);
      }
      art.put("conts", conts);
    }
    mv.data.put("news", JSONHelper.toJSONArray(page.getResult()));

    page =
        dao.findPage(
            page,
            "select product.id as id, product.title as title , img.path as img from Product product , Image img where img.id=product.imgId and product.isAd=1",
            true,
            new Object[] {});
    mv.data.put("products", JSONHelper.toJSONArray(page.getResult()));
    mv.data.put(
        "imgUrl", "http://" + ConfigCache.get("image_host", "localhost") + "/article_image_path");
    mv.data.put(
        "productDetailUrl",
        "https://" + ConfigCache.get("app_host", "localhost") + "/product/view.jsp");
    mv.data.put(
        "goodsDetailUrl",
        "https://" + ConfigCache.get("app_host", "localhost") + "/goods/view.jsp");
    mv.data.put(
        "newsDetailUrl",
        "https://" + ConfigCache.get("app_host", "localhost") + "/article/view.jsp");
    return mv;
  }
Esempio n. 18
0
 @WebMethod
 public ModelAndView add(FeedBack fb) {
   if (fb.conts == null) {
     throw new GException(PlatformExceptionType.BusinessException, "请先填写反馈已经");
   }
   fb.addtime = new Date();
   fb.userId = ThreadSession.getUser().id;
   dao.saveOrUpdate(fb);
   return new ModelAndView();
 }
Esempio n. 19
0
 @WebMethod
 public ModelAndView list(Page<Map> page) {
   ModelAndView mv = new ModelAndView();
   StringBuilder hql =
       new StringBuilder(
           "select fb.id as id, SubString(fb.conts,1,20) as conts ,fb.addtime as addtime , u.uname as uname, d.namea as deptName from FeedBack fb, User u, "
               + "Department d where fb.userId=u.id and u.deptId=d.id");
   List<Object> params = new ArrayList<Object>();
   page = dao.findPage(page, hql.toString(), true, params.toArray());
   mv.data.put("page", JSONHelper.toJSON(page));
   return mv;
 }
Esempio n. 20
0
 @WebMethod
 public ModelAndView addToGroup(int groupId, String ids) {
   ModelAndView mv = new ModelAndView();
   for (String uid : ids.split(",")) {
     if (StringUtils.isEmpty(uid)) {
       continue;
     }
     UserGroup po =
         dao.getUniqueByParams(
             UserGroup.class,
             new String[] {"gid", "uid"},
             new Object[] {groupId, Integer.valueOf(uid)});
     if (po != null) {
       continue;
     }
     UserGroup ug = new UserGroup();
     ug.gid = groupId;
     ug.uid = Integer.valueOf(uid);
     dao.saveOrUpdate(ug);
   }
   return mv;
 }
Esempio n. 21
0
 @WebMethod
 public ModelAndView getUserTree(String _site) {
   ModelAndView mv = new ModelAndView();
   List<Group> groups =
       dao.listByParams(Group.class, "from Group where parentId is null and _site=?", _site);
   JSONArray arr = new JSONArray();
   for (Group g : groups) {
     JSONObject jobj = new JSONObject();
     jobj.put("name", g.name);
     jobj.put("id", g.id);
     jobj.put("key", "group_" + g.id);
     jobj.put("isParent", true);
     jobj.put("type", "group");
     JSONArray children = getChildrenOfGroup(g.id, _site);
     if (!children.isEmpty()) {
       jobj.put("children", children);
     }
     arr.add(jobj);
   }
   mv.returnText = arr.toString();
   return mv;
 }