/**
   * 메일템플릿보기
   *
   * @param templateID
   * @return
   * @throws DataAccessException
   */
  public MailTemplate viewMailTemplate(int templateID) throws DataAccessException {
    MailTemplate mailTemplate = new MailTemplate();
    Map<String, Object> resultMap = null;
    String sql =
        QueryUtil.getStringQuery(
            "content_sql", "content.mailtemplate.view"); // 쿼리 프로퍼티파일의 키값에 해당되는 sql문을 읽어온다.
    Map<String, Object> param = new HashMap<String, Object>();
    param.put("templateID", new Integer(templateID));

    // SQL문이 실행된다.
    try {
      resultMap = getSimpleJdbcTemplate().queryForMap(sql, param);
    } catch (EmptyResultDataAccessException e1) {
    }

    if (resultMap != null) {
      mailTemplate.setTemplateID(Integer.parseInt(String.valueOf(resultMap.get("templateID"))));
      mailTemplate.setTemplateName((String) resultMap.get("templateName"));
      mailTemplate.setTemplateContent((String) resultMap.get("templateContent"));
      mailTemplate.setShareGroupID((String) resultMap.get("shareGroupID"));
      mailTemplate.setUserID((String) resultMap.get("userID"));
      mailTemplate.setUserName((String) resultMap.get("userName"));
      mailTemplate.setUseYN((String) resultMap.get("useYN"));
      mailTemplate.setGroupName((String) resultMap.get("groupName"));
      mailTemplate.setRegistDate(String.valueOf(resultMap.get("registDate")));
      mailTemplate.setTemplateType((String) resultMap.get("templateType"));
    }

    return mailTemplate;
  }
예제 #2
0
  /**
   * 사용자그룹(tm_usergroup)에서 보여준다
   *
   * @param groupID
   * @return
   * @throws DataAccessException
   */
  public Group viewGroup(String groupID) throws DataAccessException {

    Group group = new Group();
    Map<String, Object> resultMap = null;
    String sql =
        QueryUtil.getStringQuery(
            "admin_sql", "admin.usergroup.viewgroup"); // 쿼리 프로퍼티파일의 키값에 해당되는 sql문을 읽어온다.

    // 넘겨받은 파라미터를 세팅한다.
    Map<String, Object> param = new HashMap<String, Object>();
    param.put("groupID", groupID);

    // SQL문이 실행된다.
    try {
      resultMap = getSimpleJdbcTemplate().queryForMap(sql, param);
    } catch (EmptyResultDataAccessException e1) {
    }
    if (resultMap != null) {
      group.setGroupID((String) (resultMap.get("groupID")));
      group.setGroupName((String) (resultMap.get("groupName")));
      group.setDescription((String) (resultMap.get("description")));

    } else {
      group.setGroupID("0");
    }
    return group;
  }
예제 #3
0
  /**
   * 회원정보UI 기본정보 불러오기
   *
   * @param id
   * @return
   * @throws DataAccessException
   */
  public TargetUIList viewTargetUI(int id) throws DataAccessException {
    TargetUIList targetUIList = new TargetUIList();

    Map<String, Object> resultMap = null;

    String sql = QueryUtil.getStringQuery("targetlist_sql", "target.targetui.view");

    Map<String, Object> param = new HashMap<String, Object>();
    param.put("targetUIManagerID", new Integer(id));

    try {
      resultMap = getSimpleJdbcTemplate().queryForMap(sql, param);
    } catch (EmptyResultDataAccessException e1) {
    }

    if (resultMap != null) {
      targetUIList.setTargetUIManagerID(
          Integer.parseInt(String.valueOf(resultMap.get("targetUIManagerID"))));
      targetUIList.setTargetUIManagerName((String) resultMap.get("targetUIManagerName"));
      targetUIList.setDbID((String) resultMap.get("dbID"));
      targetUIList.setDescription((String) resultMap.get("description"));
      targetUIList.setSelectText((String) resultMap.get("selectText"));
      targetUIList.setFromText((String) resultMap.get("fromText"));
      targetUIList.setWhereText((String) resultMap.get("whereText"));
    }

    return targetUIList;
  }
예제 #4
0
  /**
   * 그룹의 기본 권한을 가져온다
   *
   * @param groupID
   * @return
   * @throws DataAccessException
   */
  public User viewGroupAuth(String groupID) throws DataAccessException {

    User user = new User();
    Map<String, Object> resultMap = null;
    String sql =
        QueryUtil.getStringQuery(
            "admin_sql", "admin.usergroup.groupAuth"); // 쿼리 프로퍼티파일의 키값에 해당되는 sql문을 읽어온다.
    // 넘겨받은 파라미터를 세팅한다.

    Map<String, Object> param = new HashMap<String, Object>();
    param.put("groupID", groupID);

    // SQL문이 실행된다.
    try {
      resultMap = getSimpleJdbcTemplate().queryForMap(sql, param);
    } catch (EmptyResultDataAccessException e1) {
    }

    if (resultMap != null) {

      user.setAuthCSV((String) (resultMap.get("auth_csv")));
      user.setAuthDirect((String) (resultMap.get("auth_direct")));
      user.setAuthRelated((String) (resultMap.get("auth_related")));
      user.setAuthQuery((String) (resultMap.get("auth_query")));
      user.setAuthSendMail((String) (resultMap.get("auth_send_mail")));
      user.setAuthWriteMail((String) (resultMap.get("auth_write_mail")));
      user.setAuthSendSMS((String) (resultMap.get("auth_send_sms")));
      user.setAuthWriteSMS((String) (resultMap.get("auth_write_sms")));
    }
    return user;
  }
예제 #5
0
  public User viewHelper() throws DataAccessException {

    User user = new User();
    Map<String, Object> resultMap = null;
    String sql =
        QueryUtil.getStringQuery(
            "admin_sql", "admin.usergroup.viewhelper"); // 쿼리 프로퍼티파일의 키값에 해당되는 sql문을 읽어온다.

    // 넘겨받은 파라미터를 세팅한다.
    Map<String, Object> param = new HashMap<String, Object>();

    // SQL문이 실행된다.
    try {
      resultMap = getSimpleJdbcTemplate().queryForMap(sql, param);
    } catch (EmptyResultDataAccessException e1) {
    }

    if (resultMap != null) {

      user.setUserID((String) (resultMap.get("userID")));

    } else {
      user.setUserID("");
    }
    return user;
  }
예제 #6
0
  /**
   * 회원정보UI Where절 정보 불러오기
   *
   * @param id
   * @return
   * @throws DataAccessException
   */
  @SuppressWarnings("unchecked")
  public List<TargetUIWhere> getMakeWhere(int id) throws DataAccessException {

    String sql = QueryUtil.getStringQuery("targetlist_sql", "target.targetui.viewmakewhere");

    ParameterizedRowMapper rowMapper =
        new ParameterizedRowMapper() {
          public Object mapRow(ResultSet rs, int rownum) throws SQLException {
            TargetUIWhere targetUIWhere = new TargetUIWhere();
            targetUIWhere.setTargetUIManagerID(rs.getInt("targetUIManagerID"));
            targetUIWhere.setWhereID(rs.getInt("whereID"));
            targetUIWhere.setWhereUIName(rs.getString("whereUIName"));
            targetUIWhere.setWhereFieldName(rs.getString("whereFieldName"));
            targetUIWhere.setWhereType(rs.getInt("whereType"));
            targetUIWhere.setDataType(rs.getString("dataType"));
            targetUIWhere.setExceptYN(rs.getString("exceptYN"));
            targetUIWhere.setCheckName(rs.getString("checkName"));
            targetUIWhere.setCheckValue(rs.getString("checkValue"));
            targetUIWhere.setPeriodStartType(rs.getString("periodStartType"));
            targetUIWhere.setPeriodEndType(rs.getString("periodEndType"));
            targetUIWhere.setDescription(
                (rs.getString("description") == null) ? "" : rs.getString("description"));

            return targetUIWhere;
          }
        };

    Map<String, Object> param = new HashMap<String, Object>();
    param.put("targetUIManagerID", new Integer(id));

    return getSimpleJdbcTemplate().query(sql, rowMapper, param);
  }
예제 #7
0
  /**
   * p>사용자그룹(tm_usergroup)에서 수정한다.
   *
   * @param groupID
   * @return
   * @throws DataAccessException
   */
  public int updateUser(User user) throws DataAccessException {

    String sql =
        QueryUtil.getStringQuery(
            "admin_sql", "admin.usergroup.updateuser"); // 쿼리 프로퍼티파일의 키값에 해당되는 sql문을 읽어온다.
    // 넘겨받은 파라미터를 세팅한다.

    Map<String, Object> param = new HashMap<String, Object>();
    param.put("userPWD", user.getUserPWD());
    param.put("userName", user.getUserName());
    param.put("groupID", user.getGroupID());
    param.put("userLevel", user.getUserLevel());
    param.put("description", user.getDescription());
    param.put("useYN", user.getUseYN());
    param.put("userID", user.getUserID());
    param.put("isHelper", user.getIsHelper());
    param.put("senderName", user.getSenderName());
    param.put("email", user.getEmail());
    param.put("cellPhone", user.getCellPhone());
    param.put("senderEmail", user.getSenderEmail());
    param.put("senderCellPhone", user.getSenderCellPhone());

    // SQL문이 실행된다.
    return getSimpleJdbcTemplate().update(sql, param);
  }
예제 #8
0
  /**
   * tm_target_ui_select 에서 원투원 정보 가져오기
   *
   * @param id
   * @return
   */
  @SuppressWarnings("unchecked")
  public List<TargetUIOneToOne> getSelectOneToOne(int id) throws DataAccessException {

    String sql = QueryUtil.getStringQuery("targetlist_sql", "target.targetui.getSelectOneToOne");

    ParameterizedRowMapper rowMapper =
        new ParameterizedRowMapper() {
          public Object mapRow(ResultSet rs, int rownum) throws SQLException {
            TargetUIOneToOne targetUIOneToOne = new TargetUIOneToOne();
            targetUIOneToOne.setTargetUIManagerID(rs.getInt("targetUIManagerID"));
            targetUIOneToOne.setSelectID(rs.getInt("selectID"));
            targetUIOneToOne.setSelectFieldName(rs.getString("selectFieldName"));
            targetUIOneToOne.setOnetooneID(rs.getInt("onetooneID"));
            targetUIOneToOne.setSelectDescription(rs.getString("selectDescription"));
            targetUIOneToOne.setCsvColumnPos(rs.getInt("csvColumnPos"));

            return targetUIOneToOne;
          }
        };

    Map<String, Object> param = new HashMap<String, Object>();
    param.put("targetUIManagerID", new Integer(id));

    return getSimpleJdbcTemplate().query(sql, rowMapper, param);
  }
예제 #9
0
  /**
   * 트리에 이용할 그룹별 사용자의 데이타를 불러온다
   *
   * @return
   * @throws DataAccessException
   */
  @SuppressWarnings("unchecked")
  public List<User> treeUser(String groupID) {

    String sql = QueryUtil.getStringQuery("admin_sql", "admin.usergroup.selectuser");
    sql += " WHERE u.groupID = '" + groupID + "' AND u.useYN='Y' ORDER BY u.userLevel, u.userName";

    ParameterizedRowMapper rowMapper =
        new ParameterizedRowMapper() {

          public Object mapRow(ResultSet rs, int rownum) throws SQLException {
            User user = new User();
            user.setUserID(rs.getString("userID"));
            user.setUserPWD(rs.getString("userPWD"));
            user.setGroupID(rs.getString("groupID"));
            user.setGroupName(rs.getString("groupName"));
            user.setUserName(rs.getString("userName"));
            user.setUserLevel(rs.getString("userLevel"));
            user.setEmail(rs.getString("email"));
            user.setCellPhone(rs.getString("cellPhone"));
            user.setDescription(rs.getString("description"));
            user.setUseYN(rs.getString("useYN"));
            user.setRegistDate(rs.getString("registDate"));
            user.setIsAdmin(rs.getString("isAdmin"));
            return user;
          }
        };

    return getSimpleJdbcTemplate().query(sql, rowMapper);
  }
예제 #10
0
  /**
   * targetID로 TargetManagerID를 가져온다
   *
   * @return
   * @throws DataAccessException
   */
  public int getTargetManagerID(int targetID) throws DataAccessException {
    String sql = QueryUtil.getStringQuery("targetlist_sql", "target.targetui.gettargetmanagerid");
    Map<String, Object> param = new HashMap<String, Object>();
    param.put("targetID", targetID);

    return getSimpleJdbcTemplate().queryForInt(sql, param);
  }
예제 #11
0
 /**
  * 대상자그룹등록
  *
  * @param targetList
  * @return
  * @throws DataAccessException
  */
 public int insertTargetList(TargetList targetList) throws DataAccessException {
   String sql = QueryUtil.getStringQuery("targetlist_sql", "target.targetui.insert");
   Map<String, Object> param = new HashMap<String, Object>();
   param.put("targetName", targetList.getTargetName());
   param.put("description", targetList.getDescription());
   param.put("userID", targetList.getUserID());
   param.put("bookMark", targetList.getBookMark());
   param.put("shareType", targetList.getShareType());
   param.put("shareID", targetList.getShareID());
   param.put("targetType", targetList.getTargetType());
   param.put("upload_key", targetList.getUploadKey());
   param.put("dbID", targetList.getDbID());
   param.put("queryText", targetList.getQueryText());
   param.put("countQuery", targetList.getCountQuery());
   param.put("targetCount", targetList.getTargetCount());
   param.put("directText", targetList.getDirectText());
   param.put("state", targetList.getState());
   param.put("sendedDate", targetList.getSendedDate());
   param.put("successYN", targetList.getSuccessYN());
   param.put("openYN", targetList.getOpenYN());
   param.put("clickYN", targetList.getClickYN());
   param.put("rejectcallYN", targetList.getRejectcallYN());
   param.put("connectedDbID", targetList.getConnectedDbID());
   param.put("massmailGroupID", targetList.getMassmailGroupID());
   param.put("targetGroupID", targetList.getTargetGroupID());
   param.put("targetUIID", targetList.getTargetUIID());
   return getSimpleJdbcTemplate().update(sql, param);
 }
예제 #12
0
  /**
   * 대상자를 보여준다.
   *
   * @param targetID
   * @return
   * @throws DataAccessException
   */
  public TargetList viewTargetList(int targetID) throws DataAccessException {
    TargetList targetList = new TargetList();
    Map<String, Object> resultMap = null;

    String sql = QueryUtil.getStringQuery("targetlist_sql", "target.targetui.viewtargetinfo");

    Map<String, Object> param = new HashMap<String, Object>();
    param.put("targetID", new Integer(targetID));

    // SQL문이 실행된다.
    try {
      resultMap = getSimpleJdbcTemplate().queryForMap(sql, param);
    } catch (EmptyResultDataAccessException e1) {
    }

    if (resultMap != null) {
      targetList.setTargetID(Integer.parseInt(String.valueOf(resultMap.get("targetID"))));
      targetList.setTargetName((String) resultMap.get("targetName"));
      targetList.setDescription((String) resultMap.get("description"));
      targetList.setUserID((String) resultMap.get("userID"));
      targetList.setGroupID((String) resultMap.get("groupID"));
      targetList.setBookMark((String) resultMap.get("bookMark"));
      targetList.setShareType((String) resultMap.get("shareType"));
      targetList.setShareID((String) resultMap.get("shareID"));
      targetList.setTargetType((String) resultMap.get("targetType"));
      targetList.setTargetGroupID(Integer.parseInt(String.valueOf(resultMap.get("targetGroupID"))));
    }
    return targetList;
  }
예제 #13
0
  /**
   * 계정의 총카운트를 구해온다.
   *
   * @return
   * @throws DataAccessException
   */
  public int getUserTotalCount(
      Map<String, String> searchMap, String groupID, String userLevel, String useYN)
      throws DataAccessException {

    String searchType = searchMap.get("searchType");
    String searchName = searchMap.get("searchName");
    String sql =
        QueryUtil.getStringQuery(
            "admin_sql", "admin.usergroup.totaluser"); // 쿼리 프로퍼티파일의 키값에 해당되는 sql문을 읽어온다.

    String sqlWhere = " WHERE 1=1 ";

    sql += sqlWhere;
    // 검색조건이 있다면
    if (searchName != null && !searchName.equals("")) {
      sql += " AND  " + searchType + " LIKE :searchName ";
    }

    if (groupID != null && !groupID.equals("")) {
      sql += " AND u.groupID = '" + groupID + "'";
    }

    if (userLevel != null && !userLevel.equals("")) {
      sql += " AND u.userLevel = '" + userLevel + "'";
    }

    if (useYN != null && !useYN.equals("")) {
      sql += " AND u.useYN = '" + useYN + "'";
    }

    Map<String, Object> param = new HashMap<String, Object>();
    param.put("searchName", "%" + searchName + "%");

    return getSimpleJdbcTemplate().queryForInt(sql, param);
  }
예제 #14
0
  /**
   * 모든 사용자 IsHelper 값 N으로 변경
   *
   * @return
   * @throws DataAccessException
   */
  public int setIsHelperN() throws DataAccessException {

    String sql =
        QueryUtil.getStringQuery(
            "admin_sql", "admin.usergroup.setishelpern"); // 쿼리 프로퍼티파일의 키값에 해당되는 sql문을 읽어온다.
    // SQL문이 실행된다.
    return getSimpleJdbcTemplate().update(sql);
  }
예제 #15
0
 /**
  * 사용자 ID 사용 제한 해제
  *
  * @param userID
  * @return
  * @throws DataAccessException
  */
 public int updateDerestrict(String userID) throws DataAccessException {
   String sql =
       QueryUtil.getStringQuery(
           "admin_sql", "admin.usergroup.updateDerestrict"); // 쿼리 프로퍼티파일의 키값에 해당되는 sql문을 읽어온다.
   // 넘겨받은 파라미터를 세팅한다.
   Map<String, Object> param = new HashMap<String, Object>();
   param.put("userID", userID);
   return getSimpleJdbcTemplate().update(sql, param);
 }
예제 #16
0
 public int deleteTargetUIGeneralInfo(int targetID, int targetUIManagerID)
     throws DataAccessException {
   String sql =
       QueryUtil.getStringQuery("targetlist_sql", "target.targetui.deletetargetgeneralinfo");
   sql = "delete from tm_target_ui_general_" + targetUIManagerID + " " + sql;
   Map<String, Object> param = new HashMap<String, Object>();
   param.put("targetID", new Integer(targetID));
   return getSimpleJdbcTemplate().update(sql, param);
 }
예제 #17
0
  /**
   * 사용자를 (ez_users)에서 보여준다
   *
   * @param groupID
   * @return
   * @throws DataAccessException
   */
  public User viewUser(String userID) throws DataAccessException {

    User user = new User();
    Map<String, Object> resultMap = null;
    String sql =
        QueryUtil.getStringQuery(
            "admin_sql", "admin.usergroup.viewuser"); // 쿼리 프로퍼티파일의 키값에 해당되는 sql문을 읽어온다.

    // 넘겨받은 파라미터를 세팅한다.
    Map<String, Object> param = new HashMap<String, Object>();
    param.put("userID", userID);

    // SQL문이 실행된다.
    try {
      resultMap = getSimpleJdbcTemplate().queryForMap(sql, param);
    } catch (EmptyResultDataAccessException e1) {
    }

    if (resultMap != null) {

      user.setUserID((String) (resultMap.get("userID")));
      user.setUserPWD((String) (resultMap.get("userPWD")));
      user.setUserName((String) (resultMap.get("userName")));
      user.setGroupID((String) (resultMap.get("groupID")));
      user.setGroupName((String) (resultMap.get("groupName")));
      user.setUserLevel((String) (resultMap.get("userLevel")));
      user.setEmail((String) (resultMap.get("email") == null ? "" : resultMap.get("email")));
      user.setCellPhone(
          (String) (resultMap.get("cellPhone") == null ? "" : resultMap.get("cellPhone")));
      user.setDescription(
          (String) (resultMap.get("description") == null ? "" : resultMap.get("description")));
      user.setUseYN((String) (resultMap.get("useYN")));
      user.setRegistDate(String.valueOf(resultMap.get("registDate")));
      user.setIsAdmin((String) (resultMap.get("isAdmin")));
      user.setAuthCSV((String) (resultMap.get("auth_csv")));
      user.setAuthDirect((String) (resultMap.get("auth_direct")));
      user.setAuthRelated((String) (resultMap.get("auth_related")));
      user.setAuthQuery((String) (resultMap.get("auth_query")));
      user.setAuthSendMail((String) (resultMap.get("auth_send_mail")));
      user.setAuthWriteMail((String) (resultMap.get("auth_write_mail")));
      user.setIsHelper((String) (resultMap.get("isHelper")));
      user.setSenderName(
          (String) (resultMap.get("senderName") == null ? "" : resultMap.get("senderName")));
      user.setSenderEmail(
          (String) (resultMap.get("senderEmail") == null ? "" : resultMap.get("senderEmail")));
      user.setSenderCellPhone(
          (String)
              (resultMap.get("senderCellPhone") == null ? "" : resultMap.get("senderCellPhone")));
      user.setAuthSendSMS((String) (resultMap.get("auth_send_sms")));
      user.setAuthWriteSMS((String) (resultMap.get("auth_write_sms")));
      user.setFailCount(Integer.parseInt(String.valueOf(resultMap.get("failCount"))));
    } else {
      user.setUserID("");
    }
    return user;
  }
예제 #18
0
 /**
  * 사용자의 데이타 권한을 삭제한다
  *
  * @param subMenuIDs
  * @return
  * @throws DataAccessException
  */
 public int deleteUserDataAuth(String userID, String dbID) throws DataAccessException {
   String sql =
       QueryUtil.getStringQuery(
           "admin_sql", "admin.usergroup.deleteDataAuth"); // 쿼리 프로퍼티파일의 키값에 해당되는 sql문을 읽어온다.
   Map<String, Object> param = new HashMap<String, Object>();
   param.put("userID", userID);
   param.put("dbID", dbID);
   // SQL문이 실행된다.
   return getSimpleJdbcTemplate().update(sql, param);
 }
예제 #19
0
  /**
   * p>그룹의 메뉴 권한을 삭제한다
   *
   * @param subMenuIDs
   * @return
   * @throws DataAccessException
   */
  public int deleteGroupAllMenuAuth(String groupID) throws DataAccessException {
    String sql =
        QueryUtil.getStringQuery(
            "admin_sql", "admin.usergroup.deleteAllMenuAuth"); // 쿼리 프로퍼티파일의 키값에 해당되는 sql문을 읽어온다.

    Map<String, Object> param = new HashMap<String, Object>();
    param.put("_group", "_group_" + groupID);

    // SQL문이 실행된다.
    return getSimpleJdbcTemplate().update(sql, param);
  }
예제 #20
0
  /**
   * 대상자에 대한 원투원정보를 인서트한다.
   *
   * @param onetooneTarget
   * @return
   * @throws DataAccessException
   */
  public int insertOnetooneTarget(OnetooneTarget onetooneTarget) throws DataAccessException {
    String sql = QueryUtil.getStringQuery("targetlist_sql", "target.targetui.insertonetoonetarget");
    Map<String, Object> param = new HashMap<String, Object>();
    param.put("targetID", onetooneTarget.getTargetID());
    param.put("fieldName", onetooneTarget.getFieldName());
    param.put("onetooneID", onetooneTarget.getOnetooneID());
    param.put("fieldDesc", onetooneTarget.getFieldDesc());
    param.put("csvColumnPos", onetooneTarget.getCsvColumnPos());

    return getSimpleJdbcTemplate().update(sql, param);
  }
예제 #21
0
  /**
   * 메일템플릿 입력
   *
   * @param mailTemplate
   * @return
   * @throws DataAccessException
   */
  public int insertMailTemplate(MailTemplate mailTemplate) throws DataAccessException {
    String sql = QueryUtil.getStringQuery("content_sql", "content.mailtemplate.insert");
    Map<String, Object> param = new HashMap<String, Object>();
    param.put("templateName", mailTemplate.getTemplateName());
    param.put("templateContent", mailTemplate.getTemplateContent());
    param.put("shareGroupID", mailTemplate.getShareGroupID());
    param.put("userID", mailTemplate.getUserID());
    param.put("useYN", mailTemplate.getUseYN());
    param.put("templateType", mailTemplate.getTemplateType());

    return getSimpleJdbcTemplate().update(sql, param);
  }
예제 #22
0
  /**
   * 사용자ID의 메뉴별권한
   *
   * @param userID
   * @param mainMenuID
   * @param subMenuID
   * @return
   * @throws DataAccessException
   */
  public Map<String, Object> getUserAuth(String userID, String mainMenuID, String subMenuID)
      throws DataAccessException {
    String sql =
        QueryUtil.getStringQuery(
            "admin_sql", "admin.usergroup.getauth"); // 쿼리 프로퍼티파일의 키값에 해당되는 sql문을 읽어온다.

    Map<String, Object> param = new HashMap<String, Object>();
    param.put("userID", userID);
    param.put("mainMenuID", mainMenuID);
    param.put("subMenuID", subMenuID);

    return getSimpleJdbcTemplate().queryForMap(sql, param);
  }
예제 #23
0
  /**
   * 사용자그룹(tm_usergroup) 리스트를 보여준다. //사용안하고 있음. 확실해지면 삭제 예정
   *
   * @return
   * @throws DataAccessException
   */
  @SuppressWarnings("unchecked")
  public List<Group> listGroup(int currentPage, int countPerPage, Map<String, String> searchMap)
      throws DataAccessException {
    int start = (currentPage - 1) * countPerPage;
    String searchType = searchMap.get("searchType");
    String searchName = searchMap.get("searchName");

    String sql = QueryUtil.getStringQuery("admin_sql", "admin.usergroup.selectgroup");

    // 검색조건이 있다면
    if (searchName != null && !searchName.equals("")) {
      sql += " WHERE " + searchType + " LIKE :searchName ";
    }

    String sqlTail = QueryUtil.getStringQuery("admin_sql", "admin.usergroup.grouptail");
    sql += sqlTail;

    ParameterizedRowMapper rowMapper =
        new ParameterizedRowMapper() {

          public Object mapRow(ResultSet rs, int rownum) throws SQLException {
            Group group = new Group();
            group.setGroupID(rs.getString("groupID"));
            group.setGroupName(rs.getString("groupName"));
            group.setDescription(rs.getString("description"));
            group.setUserCount(rs.getInt("userCount"));
            group.setRegistDate(rs.getString("registDate"));
            group.setIsAdmin(rs.getString("isAdmin"));
            return group;
          }
        };

    Map<String, Object> param = new HashMap<String, Object>();
    param.put("start", new Integer(start));
    param.put("countPerPage", new Integer(countPerPage));
    param.put("searchName", "%" + searchName + "%");

    return getSimpleJdbcTemplate().query(sql, rowMapper, param);
  }
예제 #24
0
  /**
   * p>사용자의 데이타 권한을 그룹의 데이타 권한으로 추가한다.
   *
   * @param subMenuIDs
   * @return
   * @throws DataAccessException
   */
  public int insertUserDataDefaultAuth(String userID) throws DataAccessException {

    String sql =
        QueryUtil.getStringQuery(
            "admin_sql",
            "admin.usergroup.insertDataDefaultAuth"); // 쿼리 프로퍼티파일의 키값에 해당되는 sql문을 읽어온다.
    // 넘겨받은 파라미터를 세팅한다.
    Map<String, Object> param = new HashMap<String, Object>();
    param.put("userID", userID);

    // SQL문이 실행된다.
    return getSimpleJdbcTemplate().update(sql, param);
  }
예제 #25
0
  /**
   * tm_usergroup에 그룹을 인서트한다.
   *
   * @param group
   * @return
   * @throws DataAccessException
   */
  public int insertGroup(Group group) throws DataAccessException {

    String sql =
        QueryUtil.getStringQuery(
            "admin_sql", "admin.usergroup.insertgroup"); // 쿼리 프로퍼티파일의 키값에 해당되는 sql문을 읽어온다.
    // 넘겨받은 파라미터를 세팅한다.

    Map<String, Object> param = new HashMap<String, Object>();
    param.put("groupID", group.getGroupID());
    param.put("groupName", group.getGroupName());
    param.put("description", group.getDescription());

    return getSimpleJdbcTemplate().update(sql, param);
  }
예제 #26
0
  /**
   * p>그룹의 메뉴 권한을 수정한다.
   *
   * @param subMenuIDs
   * @return
   * @throws DataAccessException
   */
  public int insertGroupMenuAuth(String groupID, String subMenuID) throws DataAccessException {

    String sql =
        QueryUtil.getStringQuery(
            "admin_sql", "admin.usergroup.insertGroupMenuAuth"); // 쿼리 프로퍼티파일의 키값에 해당되는 sql문을 읽어온다.
    // 넘겨받은 파라미터를 세팅한다.
    Map<String, Object> param = new HashMap<String, Object>();
    param.put("_groupID", "_group_" + groupID);
    param.put("subMenuID", subMenuID);
    param.put("groupID", groupID);

    // SQL문이 실행된다.
    return getSimpleJdbcTemplate().update(sql, param);
  }
예제 #27
0
  /**
   * 메일템플릿 카운트
   *
   * @param currentPage
   * @param countPerPage
   * @param searchMap
   * @return
   * @throws DataAccessException
   */
  public int getCountMailTemplate(
      String userID, String groupID, String userAuth, Map<String, String> searchMap)
      throws DataAccessException {
    String sql = QueryUtil.getStringQuery("content_sql", "content.mailtemplate.selectcount");

    String searchType = searchMap.get("sSearchType");
    String searchText = searchMap.get("sSearchText");
    String useYN = searchMap.get("sUseYN");
    String selectedGroupID = searchMap.get("sSelectedGroupID");

    // 소속관리자라면
    if (userAuth.equals(Constant.USER_LEVEL_MASTER)) {
      sql += QueryUtil.getStringQuery("content_sql", "content.mailtemplate.selectbygroup");
    }
    // 일반사용자라면
    else if (userAuth.equals(Constant.USER_LEVEL_USER)) {
      sql += QueryUtil.getStringQuery("content_sql", "content.mailtemplate.selectbyuser");
    }

    // 검색조건이 있다면
    if (searchText != null && !searchText.equals("")) {
      sql += " AND  " + searchType + " LIKE :searchText ";
    }
    if (useYN != null && !useYN.equals("")) {
      sql += " AND  t.useYN ='" + useYN + "' ";
    }

    if (selectedGroupID != null && !selectedGroupID.equals("")) {
      sql += " AND  shareGroupID ='" + selectedGroupID + "' ";
    }

    Map<String, Object> param = new HashMap<String, Object>();
    param.put("userID", userID);
    param.put("groupID", groupID);
    param.put("searchText", "%" + searchText + "%");
    return getSimpleJdbcTemplate().queryForInt(sql, param);
  }
예제 #28
0
  /**
   * 그룹의 총카운트를 구해온다.
   *
   * @return
   * @throws DataAccessException
   */
  public int getGroupTotalCount(Map<String, String> searchMap) throws DataAccessException {

    String searchType = searchMap.get("searchType");
    String searchName = searchMap.get("searchName");
    String sql =
        QueryUtil.getStringQuery(
            "admin_sql", "admin.usergroup.totalgroup"); // 쿼리 프로퍼티파일의 키값에 해당되는 sql문을 읽어온다.
    if (searchName != null && !searchName.equals("")) {
      sql += " WHERE " + searchType + " LIKE :searchName ";
    }
    Map<String, Object> param = new HashMap<String, Object>();
    param.put("searchName", "%" + searchName + "%");

    return getSimpleJdbcTemplate().queryForInt(sql, param);
  }
예제 #29
0
  /**
   * 회원정보UI 입력값을 저장한다
   *
   * @param targetUIGeneralInfo
   * @return
   * @throws DataAccessException
   */
  public int insertTargetUIGeneralInfo(
      int targetUIManagerID, TargetUIGeneralInfo targetUIGeneralInfo) throws DataAccessException {
    String sql = QueryUtil.getStringQuery("targetlist_sql", "target.targetui.insertgeneralinfo");
    sql = "insert into tm_target_ui_general_" + targetUIManagerID + sql;
    Map<String, Object> param = new HashMap<String, Object>();
    param.put("targetID", targetUIGeneralInfo.getTargetID());
    param.put("whereID", targetUIGeneralInfo.getWhereID());
    param.put("whereType", targetUIGeneralInfo.getWhereType());
    param.put("checkedItems", targetUIGeneralInfo.getCheckedItems());
    param.put("periodStartValue", targetUIGeneralInfo.getPeriodStartValue());
    param.put("periodEndValue", targetUIGeneralInfo.getPeriodEndValue());
    param.put("inputValue", targetUIGeneralInfo.getInputValue());

    return getSimpleJdbcTemplate().update(sql, param);
  }
예제 #30
0
 public int updateTargetList(TargetList targetList) throws DataAccessException {
   String sql = QueryUtil.getStringQuery("targetlist_sql", "target.targetui.update");
   Map<String, Object> param = new HashMap<String, Object>();
   param.put("targetID", targetList.getTargetID());
   param.put("targetName", targetList.getTargetName());
   param.put("description", targetList.getDescription());
   param.put("shareType", targetList.getShareType());
   param.put("shareID", targetList.getShareID());
   param.put("targetType", targetList.getTargetType());
   param.put("dbID", targetList.getDbID());
   param.put("queryText", targetList.getQueryText());
   param.put("countQuery", targetList.getCountQuery());
   param.put("targetCount", targetList.getTargetCount());
   param.put("targetGroupID", targetList.getTargetGroupID());
   return getSimpleJdbcTemplate().update(sql, param);
 }