Index: base3.10/src/main/java/egovframework/com/uss/umt/service/UserDefaultVO.java =================================================================== --- base3.10/src/main/java/egovframework/com/uss/umt/service/UserDefaultVO.java (revision 86) +++ base3.10/src/main/java/egovframework/com/uss/umt/service/UserDefaultVO.java (revision 87) @@ -27,6 +27,15 @@ /** 검색조건-회원상태 (0, A, D, P)*/ private String sbscrbSttus = "0"; + /** + * 권한코드 + */ + private String authorCode; + /** + * 권한코드이름 + */ + private String authorCdnm; + /** 검색조건 */ // private String searchCondition = ""; @@ -70,4 +79,20 @@ this.sbscrbSttus = sbscrbSttus; } + public String getAuthorCode() { + return authorCode; + } + + public void setAuthorCode(String authorCode) { + this.authorCode = authorCode; + } + + public String getAuthorCdnm() { + return authorCdnm; + } + + public void setAuthorCdnm(String authorCdnm) { + this.authorCdnm = authorCdnm; + } + } Index: base3.10/src/main/resources/egovframework/mapper/com/uss/umt/EgovUserManage_SQL_postgres.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/uss/umt/EgovUserManage_SQL_postgres.xml (revision 86) +++ base3.10/src/main/resources/egovframework/mapper/com/uss/umt/EgovUserManage_SQL_postgres.xml (revision 87) @@ -3,38 +3,41 @@ "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="userManageDAO"> - <select id="selectUserList_S" resultType="egovMap"> - SELECT - ESNTL_ID "uniqId", - 'USR03' "userTy", - EMPLYR_ID "userId", - USER_NM "userNm", - EMAIL_ADRES "emailAdres", - AREA_NO "areaNo", - HOUSE_MIDDLE_TELNO "middleTelno", - HOUSE_END_TELNO "endTelno", - MBTLNUM "moblphonNo", - GROUP_ID "groupId", - EMPLYR_STTUS_CODE "sttus", - SBSCRB_DE "sbscrbDe" - FROM COMTNEMPLYRINFO - WHERE 1=1 - <if test='sbscrbSttus != null and sbscrbSttus neq "0" and sbscrbSttus neq ""'> - AND EMPLYR_STTUS_CODE LIKE #{sbscrbSttus} - </if> - <if test="@egovframework.com.cmm.util.EgovMybaitsUtil@isNotEmpty(searchKeyword)"> - <if test="searchCondition == 0">AND - EMPLYR_ID LIKE '%' || #{searchKeyword} || '%' - </if> - <if test="searchCondition == 1">AND - USER_NM LIKE '%' || #{searchKeyword} || '%' - </if> - </if> - - ORDER BY SBSCRB_DE DESC - LIMIT #{recordCountPerPage} OFFSET #{firstIndex} - </select> - + <select id="selectUserList_S" resultType="egovMap"> + SELECT + ESNTL_ID "uniqId", + 'USR03' "userTy", + EMPLYR_ID "userId", + USER_NM "userNm", + EMAIL_ADRES "emailAdres", + AREA_NO "areaNo", + HOUSE_MIDDLE_TELNO "middleTelno", + HOUSE_END_TELNO "endTelno", + MBTLNUM "moblphonNo", + GROUP_ID "groupId", + EMPLYR_STTUS_CODE "sttus", + SBSCRB_DE "sbscrbDe", + b.author_code, + fncauthorcodenm(b.author_code) as author_cdnm + FROM COMTNEMPLYRINFO a + LEFT OUTER JOIN COMTNEMPLYRSCRTYESTBS b + ON a.ESNTL_ID = b.scrty_dtrmn_trget_id + WHERE 1=1 + <if test='sbscrbSttus != null and sbscrbSttus neq "0" and sbscrbSttus neq ""'> + AND EMPLYR_STTUS_CODE LIKE #{sbscrbSttus} + </if> + <if test="@egovframework.com.cmm.util.EgovMybaitsUtil@isNotEmpty(searchKeyword)"> + <if test="searchCondition == 0"> + AND EMPLYR_ID LIKE '%' || #{searchKeyword} || '%' + </if> + <if test="searchCondition == 1"> + AND USER_NM LIKE '%' || #{searchKeyword} || '%' + </if> + </if> + ORDER BY SBSCRB_DE DESC + LIMIT #{recordCountPerPage} OFFSET #{firstIndex} + </select> + <select id="selectUserListTotCnt_S" resultType="int"> SELECT COUNT(1) totcnt FROM( Index: base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/uss/umt/EgovUserManage.jsp =================================================================== --- base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/uss/umt/EgovUserManage.jsp (revision 86) +++ base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/uss/umt/EgovUserManage.jsp (revision 87) @@ -152,10 +152,11 @@ <table class="table_list"> <caption>${pageTitle} <spring:message code="title.list" /></caption> <colgroup> - <col class="width100"> + <col class="width50"> <col class="width50"> <col class="width150"> <col class="width150"> + <col class="width150"> <col class="width100"> <col class="width200"> <col class="width100"> @@ -167,6 +168,7 @@ <th><input type="checkbox" name="checkAll" class="check2" onclick="javascript:fncCheckAll()" title="<spring:message code="input.selectAll.title" />"></th><!-- 전체선택 --> <th class="board_th_link"><spring:message code="comUssUmt.userManageList.id" /></th><!--아이디 --> <th><spring:message code="comUssUmt.userManageList.name" /></th><!-- 사용자이름 --> + <th>권한</th><!-- 권한 --> <th><spring:message code="comUssUmt.userManageList.email" /></th><!-- 사용자이메일 --> <th><spring:message code="comUssUmt.userManageList.phone" /></th><!-- 전화번호 --> <th><spring:message code="table.regdate" /></th><!-- 등록일 --> @@ -177,7 +179,7 @@ <tbody> <c:if test="${fn:length(resultList) == 0}"> <tr> - <td colspan="8"><spring:message code="common.nodata.msg" /></td> + <td colspan="7"><spring:message code="common.nodata.msg" /></td> </tr> </c:if> <c:forEach var="result" items="${resultList}" varStatus="status"> @@ -189,6 +191,7 @@ </td> <td><a href="<c:url value='/uss/umt/EgovMberSelectUpdtView.do'/>?selectedId=<c:out value="${result.uniqId}"/>" onclick="javascript:fnSelectUser('<c:out value="${result.userTy}"/>:<c:out value="${result.uniqId}"/>'); return false;"><c:out value="${result.userId}"/></a></td> <td><c:out value="${result.userNm}"/></td> + <td><c:out value="${result.authorCdnm}"/></td> <td><c:out value="${result.emailAdres}"/></td> <td><c:out value="${result.areaNo}"/>)<c:out value="${result.middleTelno}"/>-<c:out value="${result.endTelno}"/></td> <td><c:out value="${fn:substring(result.sbscrbDe,0,10)}"/></td>