306 lines
13 KiB
Plaintext
306 lines
13 KiB
Plaintext
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
|
|
<%@ include file="/field_manager/include/manager_head.jsp"%>
|
|
|
|
<%
|
|
String c_home = r_call(request.getParameter("c_home"));
|
|
String c_maker = r_call(request.getParameter("c_maker"));
|
|
|
|
if(c_home.equals("") || c_maker.equals("")){
|
|
%>
|
|
<script>
|
|
alert("잘못 된 접속입니다.")
|
|
location.href="/"
|
|
</script>
|
|
<%
|
|
}else{
|
|
|
|
Statement stmt3=conn.createStatement();
|
|
int old_order2 = 0;
|
|
int old_order3 = 0;
|
|
int order2 = 0;
|
|
int order3 = 0;
|
|
%>
|
|
<center>
|
|
<table width="1024" cellSpacing="0" cellPadding="0" border="0" bgcolor=ffffff>
|
|
<tr style="font-size:14px;">
|
|
<td height="60">
|
|
<%
|
|
String sql_ok2 = "select c_name, c_eng_name from tbl_field where c_no = " + c_home ;
|
|
ResultSet rss = stmt.executeQuery(sql_ok2);
|
|
if(rss.next()){
|
|
%>
|
|
<b><%=rss.getString("c_name")%> / <%=rss.getString("c_eng_name")%> 메뉴 관리</b>
|
|
<%
|
|
}
|
|
rss.close();
|
|
%>
|
|
</td>
|
|
</tr></table>
|
|
<table width="1024" cellSpacing="0" cellPadding="0" border="0" bgcolor=ffffff>
|
|
<tr style="font-size:14px;">
|
|
<td height="30" width="250" style="text-align:center; border-top:2px solid #9BBB67; border-bottom:1px solid #9BBB67">메뉴명</td>
|
|
<td height="30" width="100" style="text-align:center; border-top:2px solid #9BBB67; border-bottom:1px solid #9BBB67">Type</td>
|
|
<td height="30" width="100" style="text-align:center; border-top:2px solid #9BBB67; border-bottom:1px solid #9BBB67">Using Content</td>
|
|
<!--<td height="" scope="col" style="text-align:center; border-top:2px solid #9BBB67; border-bottom:1px solid #9BBB67">설명</td>-->
|
|
<td height="30" width="100" style="text-align:center; border-top:2px solid #9BBB67; border-bottom:1px solid #9BBB67">사용/미사용</td>
|
|
<td height="30" width="120" style="text-align:center; border-top:2px solid #9BBB67; border-bottom:1px solid #9BBB67">하위등록</td>
|
|
<td height="30" width="80" style="text-align:center; border-top:2px solid #9BBB67; border-bottom:1px solid #9BBB67">수정</td>
|
|
<td height="30" width="80" style="text-align:center; border-top:2px solid #9BBB67; border-bottom:1px solid #9BBB67">삭제</td>
|
|
<td height="30" width="70" style="text-align:center; border-top:2px solid #9BBB67; border-bottom:1px solid #9BBB67">순서</td>
|
|
</tr>
|
|
|
|
<%
|
|
int order1 = 0;
|
|
int old_order1 = 0;
|
|
String sql1=" SELECT * from tbl_menu where c_up_no = 0 and c_home="+ c_home +" and c_maker = "+ c_maker +" order by c_order asc";
|
|
ResultSet rst = stmt.executeQuery(sql1);
|
|
while (rst.next()) {
|
|
order1 = order1 + 1 ;
|
|
%>
|
|
<tr bgcolor="cdcdcd">
|
|
<td style="text-align:left; padding:5px;padding-left:20px"><b><%=rst.getString("c_name")%></td>
|
|
<td style="text-align:center; padding:5px;padding-left:20px">
|
|
</td>
|
|
<td style="text-align:center; padding:5px;padding-left:20px">
|
|
</td>
|
|
<!--<td style="text-align:center; padding:5px;padding-left:20px">
|
|
</td>-->
|
|
<td style="text-align:center; padding:5px;padding-left:20px">
|
|
<%//if(rst.getInt("c_fix") == 1){%>
|
|
|
|
<%//}else{%>
|
|
<%if(rst.getInt("c_use") == 0){%>
|
|
<a href="#none" onclick="if(confirm('정말 변경하시겠습니까?')){location.href='change.jsp?name=c_use&value=1&c_no=<%=rst.getInt("c_no")%>&c_home=<%=c_home%>&c_maker=<%=c_maker%>'}">사용</a>
|
|
<%}else{%>
|
|
<a href="#none" onclick="if(confirm('정말 변경하시겠습니까?')){location.href='change.jsp?name=c_use&value=0&c_no=<%=rst.getInt("c_no")%>&c_home=<%=c_home%>&c_maker=<%=c_maker%>'}">미사용</a>
|
|
<%}%>
|
|
<%//}%>
|
|
</td>
|
|
<td style="text-align:center; padding:5px;padding-left:20px">
|
|
<a href="insert.jsp?c_up_no=<%=rst.getInt("c_no")%>&c_level=2&c_home=<%=c_home%>&c_maker=<%=c_maker%>">[하위등록]</a>
|
|
</td>
|
|
<td style="text-align:center; padding:5px;padding-left:20px">
|
|
<%if(rst.getInt("c_fix") == 1){%>
|
|
|
|
<%}else{%>
|
|
<a href="edit.jsp?c_up_no=0&c_no=<%=rst.getInt("c_no")%>&c_home=<%=c_home%>&c_maker=<%=c_maker%>">[수정]</a>
|
|
<%}%>
|
|
</td>
|
|
<td style="text-align:center; padding:5px;padding-left:20px">
|
|
<%if(rst.getInt("c_fix") == 1){%>
|
|
|
|
<%}else{%>
|
|
|
|
<a href="#none" onclick="if(confirm('정말 삭제하시겠습니까?\n삭제하게 되면 하위의 모든 메뉴도 같이 삭제 됩니다.')){location.href='delete.jsp?c_no=<%=rst.getInt("c_no")%>&c_home=<%=c_home%>&c_maker=<%=c_maker%>'}">[삭제]</a>
|
|
|
|
<%}%>
|
|
</td>
|
|
<td style="text-align:center; padding:5px;padding-left:20px">
|
|
<%if(order1 > 1){%>
|
|
<a href="change_order.jsp?<%if(order1 == 2){%>c_no=<%if(rst.getInt("c_type") == 0){%><%=rst.getString("c_content")%><%}else{%><%=rst.getInt("c_no")%><%}%>&<%}%>c_up_no=<%=rst.getInt("c_up_no")%>&now_order=<%=rst.getInt("c_order")%>&change_order=<%=old_order1%>&c_home=<%=c_home%>&c_maker=<%=c_maker%>">▲</a>
|
|
<%}%>
|
|
</td>
|
|
</tr>
|
|
<%
|
|
old_order1 = rst.getInt("c_order");
|
|
%>
|
|
<tr>
|
|
<td colspan="9" height="1" bgcolor="e5e5e6"></td>
|
|
</tr>
|
|
<%
|
|
order2 = 0;
|
|
old_order2 = 0;
|
|
String sql12=" SELECT * from tbl_menu where c_up_no = "+ rst.getInt("c_no") +" order by c_order asc";
|
|
ResultSet rst2 = stmt2.executeQuery(sql12);
|
|
while (rst2.next()) {
|
|
order2 = order2 + 1 ;
|
|
%>
|
|
<tr bgcolor="ededed">
|
|
<td style="text-align:left; padding:5px;padding-left:60px"><b><%=rst2.getString("c_name")%></td>
|
|
<td style="text-align:center; padding:5px;padding-left:20px">
|
|
<%if(rst2.getInt("c_type") == 0){%>
|
|
Up Menu
|
|
<%}%>
|
|
<%if(rst2.getInt("c_type") == 1){%>
|
|
Contents
|
|
<%}%>
|
|
<%if(rst2.getInt("c_type") == 2){%>
|
|
Process
|
|
<%}%>
|
|
<%if(rst2.getInt("c_type") == 3){%>
|
|
Int. Link
|
|
<%}%>
|
|
<%if(rst2.getInt("c_type") == 4){%>
|
|
Ext. Link
|
|
<%}%>
|
|
<%if(rst2.getInt("c_type") == 5){%>
|
|
Direct Contents
|
|
<%}%>
|
|
</td>
|
|
<td style="text-align:center; padding:5px;padding-left:20px">
|
|
<%if(rst2.getInt("c_type") > 0){%>
|
|
<%if(rst2.getInt("c_type") == 5){%>
|
|
수정에서 확인
|
|
<%}else{%>
|
|
|
|
<%if(rst2.getString("c_content").length() > 20){%>
|
|
<%=rst2.getString("c_content").substring(0,20)%>..
|
|
<%}else{%>
|
|
<%=rst2.getString("c_content")%>
|
|
<%}%>
|
|
<%}%>
|
|
<%}%>
|
|
</td>
|
|
|
|
<td style="text-align:center; padding:5px;padding-left:20px">
|
|
<%if(rst2.getInt("c_use") == 0){%>
|
|
<%if(order2 > 1){%>
|
|
<a href="#none" onclick="if(confirm('정말 변경하시겠습니까?')){location.href='change.jsp?name=c_use&value=1&c_no=<%=rst2.getInt("c_no")%>&c_home=<%=c_home%>&c_maker=<%=c_maker%>'}">사용</a>
|
|
<%}else{%>
|
|
<a href="#none" onclick="alert('메뉴 그룹중 첫번째 메뉴는 미사용 전환이 불가능합니다.\n하위로 이동 후 변경해 주세요.')">사용</a>
|
|
<%}%>
|
|
<%}else{%>
|
|
<a href="#none" onclick="if(confirm('정말 변경하시겠습니까?')){location.href='change.jsp?name=c_use&value=0&c_no=<%=rst2.getInt("c_no")%>&c_home=<%=c_home%>&c_maker=<%=c_maker%>'}">미사용</a>
|
|
<%}%>
|
|
</td>
|
|
<td style="text-align:center; padding:5px;padding-left:20px">
|
|
<%if(rst2.getInt("c_type") == 0){%>
|
|
<a href="insert.jsp?c_up_no=<%=rst2.getInt("c_no")%>&c_level=3&c_home=<%=c_home%>&c_maker=<%=c_maker%>">[하위등록]</a>
|
|
<%}%>
|
|
</td>
|
|
<td style="text-align:center; padding:5px;padding-left:20px">
|
|
<%if(rst2.getInt("c_fix") == 1){%>
|
|
|
|
<%}else{%>
|
|
<a href="edit.jsp?c_up_no=<%=rst2.getInt("c_up_no")%>&c_no=<%=rst2.getInt("c_no")%>&c_home=<%=c_home%>&c_maker=<%=c_maker%>">[수정]</a>
|
|
<%}%>
|
|
</td>
|
|
<td style="text-align:center; padding:5px;padding-left:20px">
|
|
<%if(rst2.getInt("c_fix") == 1){%>
|
|
|
|
<%}else{%>
|
|
<%if(order2 > 1){%>
|
|
<a href="#none" onclick="if(confirm('정말 삭제하시겠습니까?\n삭제하게 되면 하위의 모든 메뉴도 같이 삭제 됩니다.')){location.href='delete.jsp?c_no=<%=rst2.getInt("c_no")%>&c_home=<%=c_home%>&c_maker=<%=c_maker%>'}">[삭제]</a>
|
|
<%}else{%>
|
|
<a href="#none" onclick="alert('메뉴 그룹중 첫번째 메뉴는 삭제가 불가능합니다.\n하위로 이동 후 삭제해 주세요.')">[삭제]</a>
|
|
<%}%>
|
|
<%}%>
|
|
</td>
|
|
<td style="text-align:center; padding:5px;padding-left:20px">
|
|
<%if(order2 > 1){%>
|
|
<a href="change_order.jsp?<%if(order2 == 2){%>c_no=<%if(rst2.getInt("c_type") == 0){%><%=rst2.getString("c_content")%><%}else{%><%=rst2.getInt("c_no")%><%}%>&<%}%>c_up_no=<%=rst2.getInt("c_up_no")%>&now_order=<%=rst2.getInt("c_order")%>&change_order=<%=old_order2%>&c_home=<%=c_home%>&c_maker=<%=c_maker%>">▲</a>
|
|
<%}%>
|
|
</td>
|
|
<%
|
|
old_order2 = rst2.getInt("c_order");
|
|
%>
|
|
</tr>
|
|
<tr>
|
|
<td colspan="9" height="1" bgcolor="e5e5e6"></td>
|
|
</tr>
|
|
<%
|
|
order3 = 0;
|
|
old_order3 = 0;
|
|
String sql13=" SELECT * from tbl_menu where c_up_no = "+ rst2.getInt("c_no") +" order by c_order asc";
|
|
ResultSet rst3 = stmt3.executeQuery(sql13);
|
|
while (rst3.next()) {
|
|
order3 = order3 + 1 ;
|
|
%>
|
|
<tr bgcolor="ffffff">
|
|
<td style="text-align:left; padding:5px;padding-left:120px"><b><%=rst3.getString("c_name")%></td>
|
|
<td style="text-align:center; padding:5px;padding-left:20px">
|
|
<%if(rst3.getInt("c_type") == 0){%>
|
|
Up Menu
|
|
<%}%>
|
|
<%if(rst3.getInt("c_type") == 1){%>
|
|
Contents
|
|
<%}%>
|
|
<%if(rst3.getInt("c_type") == 2){%>
|
|
Process
|
|
<%}%>
|
|
<%if(rst3.getInt("c_type") == 3){%>
|
|
Int. Link
|
|
<%}%>
|
|
<%if(rst3.getInt("c_type") == 4){%>
|
|
Ext. Link
|
|
<%}%>
|
|
<%if(rst3.getInt("c_type") == 5){%>
|
|
Direct Contents
|
|
<%}%>
|
|
</td>
|
|
<td style="text-align:center; padding:5px;padding-left:20px">
|
|
|
|
<%if(rst3.getInt("c_type") > 0){%>
|
|
<%if(rst3.getInt("c_type") == 5){%>
|
|
수정에서 확인
|
|
<%}else{%>
|
|
<%if(rst3.getString("c_content").length() > 20){%>
|
|
<%=rst3.getString("c_content").substring(0,20)%>..
|
|
<%}else{%>
|
|
<%=rst3.getString("c_content")%>
|
|
<%}%>
|
|
<%}%>
|
|
<%}%>
|
|
</td>
|
|
|
|
<td style="text-align:center; padding:5px;padding-left:20px">
|
|
<%if(rst3.getInt("c_use") == 0){%>
|
|
<%if(order3 > 1){%>
|
|
<a href="#none" onclick="if(confirm('정말 변경하시겠습니까?')){location.href='change.jsp?name=c_use&value=1&c_no=<%=rst3.getInt("c_no")%>&c_home=<%=c_home%>&c_maker=<%=c_maker%>'}">사용</a>
|
|
<%}else{%>
|
|
<a href="#none" onclick="alert('메뉴 그룹중 첫번째 메뉴는 미사용 전환이 불가능합니다.\n하위로 이동 후 변경해 주세요.')">사용</a>
|
|
<%}%>
|
|
<%}else{%>
|
|
<a href="#none" onclick="if(confirm('정말 변경하시겠습니까?')){location.href='change.jsp?name=c_use&value=0&c_no=<%=rst3.getInt("c_no")%>&c_home=<%=c_home%>&c_maker=<%=c_maker%>'}">미사용</a>
|
|
<%}%>
|
|
</td>
|
|
<td style="text-align:center; padding:5px;padding-left:20px">
|
|
|
|
</td>
|
|
<td style="text-align:center; padding:5px;padding-left:20px">
|
|
<a href="edit.jsp?c_up_no=<%=rst3.getInt("c_up_no")%>&c_no=<%=rst3.getInt("c_no")%>&c_home=<%=c_home%>&c_maker=<%=c_maker%>">[수정]</a>
|
|
</td>
|
|
<td style="text-align:center; padding:5px;padding-left:20px">
|
|
|
|
<%if(order3 > 1){%>
|
|
<a href="#none" onclick="if(confirm('정말 삭제하시겠습니까?\n삭제하게 되면 하위의 모든 메뉴도 같이 삭제 됩니다.')){location.href='delete.jsp?c_no=<%=rst3.getInt("c_no")%>&c_home=<%=c_home%>&c_maker=<%=c_maker%>'}">[삭제]</a>
|
|
<%}else{%>
|
|
<a href="#none" onclick="alert('메뉴 그룹중 첫번째 메뉴는 삭제가 불가능합니다.\n하위로 이동 후 삭제해 주세요.')">[삭제]</a>
|
|
<%}%>
|
|
</td>
|
|
<td style="text-align:center; padding:5px;padding-left:20px">
|
|
<%if(order3 > 1){%>
|
|
<a href="change_order.jsp?<%if(order3 == 2){%><%if(order2 == 1){%>y=1&<%}%>c_no=<%=rst3.getInt("c_no")%>&<%}%>c_up_no=<%=rst3.getInt("c_up_no")%>&now_order=<%=rst3.getInt("c_order")%>&change_order=<%=old_order3%>&c_home=<%=c_home%>&c_maker=<%=c_maker%>">▲</a>
|
|
<%}%>
|
|
</td>
|
|
<%
|
|
old_order3 = rst3.getInt("c_order");
|
|
%>
|
|
|
|
</tr>
|
|
<tr>
|
|
<td colspan="9" height="1" bgcolor="e5e5e6"></td>
|
|
</tr>
|
|
<%
|
|
}
|
|
rst3.close();
|
|
%>
|
|
<%
|
|
}
|
|
rst2.close();
|
|
%>
|
|
<%
|
|
}
|
|
rst.close();
|
|
%>
|
|
<tr><td align=right height=40 colspan=8>
|
|
<a href="insert.jsp?c_up_no=0&c_level=1&c_home=<%=c_home%>&c_maker=<%=c_maker%>">[최상위 등록]</a>
|
|
</td></tr>
|
|
</table>
|
|
<%
|
|
stmt3.close();
|
|
%>
|
|
|
|
<% }%>
|
|
<%@ include file="/field_manager/include/manager_bottom.jsp"%>
|