Пример #1
0
  /** 根据条件查询 */
  public List<ContactDriver> findByScreen(Map<String, String> screenMap) {
    String sql = "from ContactDriver where 1=1 ";
    String cdname = screenMap.get("cdname");
    if (cdname != null && !cdname.equals("")) {
      sql += "and cdName like '%" + CmsUtils.SqlReplace(cdname) + "%'";
    }

    if (!CmsUtils.isEmpty(screenMap.get("startTime"))
        && !CmsUtils.isEmpty(screenMap.get("endTime"))) {
      sql +=
          " and cdAddtime >= to_date('"
              + screenMap.get("startTime")
              + "','yyyy-mm-dd') "
              + "and cdAddtime <= to_date('"
              + screenMap.get("endTime")
              + "','yyyy-mm-dd')+1 ";
    }
    sql += " order by cdAddtime desc ";
    return find(sql);
  }
Пример #2
0
  /** 更新信息 */
  public String update() {
    ServletActionContext.getResponse().setCharacterEncoding("UTF-8");
    CmsUser cmsuserForSession = getCmsUser();
    String user = cmsuserForSession.getCmuName();
    // 写日志
    CmsLog log = UtilTools.buildLog("会员管理", CmsLog.MODIFY, "修改用户的状态", user);
    serviceDispatcher.getCmsLogService().add(log);

    net.sf.json.JSONObject js = net.sf.json.JSONObject.fromObject(rows);
    Long userid = js.getLong("userid");
    String status = js.getString("availabilityflag");
    TbRegUser tbRegUser = audiServiceDispatcher.getRegUserService().getUserById(userid);
    if (!CmsUtils.isEmpty(status)) {
      tbRegUser.setAvailabilityflag(status);
    } else {
      tbRegUser.setAvailabilityflag("1");
    }
    boolean isSuc = audiServiceDispatcher.getRegUserService().modify(tbRegUser);
    this.renderJson("{success:true,msg:'修改成功!',error:" + isSuc + "}");
    return null;
  }
Пример #3
0
 /** 获取信息 */
 public String query() {
   ServletActionContext.getResponse().setCharacterEncoding("UTF-8");
   page = page == 0 ? 0 : page;
   limit = limit == 0 ? 50 : limit;
   Map<String, String> screenMap = new HashMap<String, String>();
   if (rows != null) { // 如果由检索条件
     net.sf.json.JSONObject js = net.sf.json.JSONObject.fromObject(rows);
     String email = js.getString("email");
     screenMap.put("email", CmsUtils.isEmpty(email) ? "" : email);
     screenMap.put("username", js.getString("username"));
     screenMap.put("status", js.getString("availabilityflag"));
     screenMap.put("startTime", js.getString("startTime"));
     screenMap.put("endTime", js.getString("endTime"));
   }
   pt = audiServiceDispatcher.getRegUserService().findByHql(page, limit, screenMap);
   Map map = new HashMap();
   map.put("ROOT", pt.getList());
   map.put("totalCount", pt.getTotalCount());
   String jsonString = UtilTools.getJsonForObject(map);
   this.renderJson(jsonString);
   return null;
 }
Пример #4
0
  /** 生成excel */
  public String export() {
    Map map = new HashMap();
    Map<String, String> screenMap = new HashMap<String, String>();
    // 判断查询条件
    if (rows != null) {
      net.sf.json.JSONObject js = net.sf.json.JSONObject.fromObject(rows);
      String email = js.getString("email");
      screenMap.put("email", CmsUtils.isEmpty(email) ? "" : email);
      screenMap.put("username", js.getString("username"));
      screenMap.put("status", js.getString("availabilityflag"));
      screenMap.put("startTime", js.getString("startTime"));
      screenMap.put("endTime", js.getString("endTime"));
    }
    // 导出的list
    List list = audiServiceDispatcher.getRegUserService().findByScreen(screenMap);
    // 第一步,创建一个workbook,对应一个Excel文件
    HSSFWorkbook wb = new HSSFWorkbook();
    // 第二步,在workbook中添加一个sheet,对应Excel文件中的sheet
    HSSFSheet sheet = wb.createSheet("用户列表");
    // 第三步,在sheet中添加表头第0行,注意老版本poi对Excel的行数列数有限制short
    HSSFRow row = sheet.createRow((int) 0);
    // 第四步,创建单元格,并设置值表头 设置表头居中
    HSSFCellStyle style = wb.createCellStyle();
    style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 创建一个居中格式
    HSSFCell cell = row.createCell((short) 0);
    cell.setCellValue("姓名");
    cell.setCellStyle(style);
    cell = row.createCell((short) 1);
    cell.setCellValue("性别");
    cell.setCellStyle(style);
    cell = row.createCell((short) 2);
    cell.setCellValue("邮箱");
    cell.setCellStyle(style);
    cell = row.createCell((short) 3);
    cell.setCellValue("手机");
    cell.setCellStyle(style);
    cell = row.createCell((short) 4);
    cell.setCellValue("所在省");
    cell.setCellStyle(style);
    cell = row.createCell((short) 5);
    cell.setCellValue("所在市");
    cell.setCellStyle(style);
    cell = row.createCell((short) 6);
    cell.setCellValue("地址");
    cell.setCellStyle(style);
    cell = row.createCell((short) 7);
    cell.setCellValue("邮编");
    cell.setCellStyle(style);

    cell = row.createCell((short) 8);
    cell.setCellValue("出生日期");
    cell.setCellStyle(style);

    cell = row.createCell((short) 9);
    cell.setCellValue("电话");
    cell.setCellStyle(style);

    cell = row.createCell((short) 10);
    cell.setCellValue("注册时间");
    cell.setCellStyle(style);

    cell = row.createCell((short) 11);
    cell.setCellValue("是否有车");
    cell.setCellStyle(style);
    cell = row.createCell((short) 12);
    cell.setCellValue("是否有效");
    cell.setCellStyle(style);
    cell = row.createCell((short) 13);
    cell.setCellValue("是否车主");
    cell.setCellStyle(style);
    String fileName = "";
    try {
      // 省市
      Map<Long, String> cacheMap = audiServiceDispatcher.getUtilDao().getCacheDictionaryMap();
      for (int i = 0; i < list.size(); i++) {
        row = sheet.createRow((int) i + 1);
        TbRegUser bean = (TbRegUser) list.get(i);
        if (bean != null) {
          row.createCell((short) 0)
              .setCellValue(CommonUtil.getCellString(bean.getUsername())); // 姓名
          row.createCell((short) 1).setCellValue(CommonUtil.getGender(bean.getGender())); // 性别
          row.createCell((short) 2).setCellValue(CommonUtil.getCellString(bean.getEmail())); // 邮箱
          row.createCell((short) 3).setCellValue(CommonUtil.getCellString(bean.getMobile())); // 手机
          String province = "";
          if (!CmsUtils.isEmpty(bean.getProvince())) {
            province = cacheMap.get(bean.getProvince());
          }
          row.createCell((short) 4).setCellValue(province); // 所在省
          String city = "";
          if (!CmsUtils.isEmpty(bean.getCity())) {
            city = cacheMap.get(bean.getCity());
          }
          row.createCell((short) 5).setCellValue(city); // 所在市
          row.createCell((short) 6).setCellValue(CommonUtil.getCellString(bean.getAddress())); // 地址
          row.createCell((short) 7)
              .setCellValue(CommonUtil.getCellString(bean.getPostcode())); // 邮编
          String birth = "";
          if (!CmsUtils.isEmpty(bean.getBirthdayy())) {
            birth += CommonUtil.getCellString(bean.getBirthdayy());
          }
          if (!CmsUtils.isEmpty(bean.getBirthdaym())) {
            if (birth != "") {
              birth += "-";
            }
            birth += CommonUtil.getCellString(bean.getBirthdaym());
          }
          if (!CmsUtils.isEmpty(bean.getBirthdayd())) {
            if (birth != "") {
              birth += "-";
            }
            birth += CommonUtil.getCellString(bean.getBirthdayd());
          }

          row.createCell((short) 8).setCellValue(birth); // 出生日期
          String tell = "";
          if (!CmsUtils.isEmpty(bean.getAreanum())) {
            tell += CommonUtil.getCellString(bean.getAreanum());
          }
          if (!CmsUtils.isEmpty(bean.getPhone())) {
            if (tell != "") {
              tell += "-";
            }
            tell += CommonUtil.getCellString(bean.getPhone());
          }
          if (!CmsUtils.isEmpty(bean.getExt())) {
            if (tell != "") {
              tell += "-";
            }
            tell += CommonUtil.getCellString(bean.getExt());
          }
          row.createCell((short) 9).setCellValue(tell); // 电话
          row.createCell((short) 10)
              .setCellValue(CommonUtil.getCellString(bean.getRegtime())); // 注册时间
          row.createCell((short) 11).setCellValue(CommonUtil.yesOrNo(bean.getIscar())); // 是否有车
          row.createCell((short) 12)
              .setCellValue(CommonUtil.yesOrNo(bean.getAvailabilityflag())); // 是否有效
          row.createCell((short) 12)
              .setCellValue(CommonUtil.yesOrNo(bean.getAuditingcar())); // 是否车主
        }
      }
      File filepath =
          new File(ServletActionContext.getServletContext().getRealPath(CommonUtil.SAVEURL));
      if (!filepath.exists() && !filepath.isDirectory()) {
        filepath.mkdirs();
      }
      fileName = "member" + DateUtil.getNowDate("yyyy-MM-dd") + ".xls";
      File file =
          new File(
              ServletActionContext.getServletContext().getRealPath(CommonUtil.SAVEURL)
                  + "/"
                  + fileName);
      if (file.isFile()) {
        file.delete();
      }
      FileOutputStream fout = new FileOutputStream(file);
      wb.write(fout);
      fout.close();
    } catch (Exception e) {
      e.printStackTrace();
    }
    map.put("success", "true");
    map.put("fileName", fileName);
    String text = UtilTools.encodeObject2Json(map);
    renderText(text);
    return null;
  }