275 lines
14 KiB
Plaintext
275 lines
14 KiB
Plaintext
<%@ page contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
|
|
<%
|
|
if(home_fact == 1){
|
|
menu1_title = "Membership";
|
|
String sql_fact = "select c_name from tbl_menu where c_no = " + show_no;
|
|
ResultSet rs_fact = stmt.executeQuery(sql_fact);
|
|
if(rs_fact.next()){
|
|
page_title = rs_fact.getString("c_name");
|
|
//navi_text = navi_text + " Membership > " + rs_fact.getString("c_name");
|
|
}
|
|
rs_fact.close();
|
|
}
|
|
%>
|
|
<div class="container" style="background:#ffffff;padding-top:30px;padding-bottom:30px;>
|
|
<div class="row">
|
|
<div class="col-lg-3 col-md-3">
|
|
<div class="sidebar-widget hidden-xs">
|
|
<div class="col-lg-12 col-md-12" style="height:56px;padding-bottom:15px">
|
|
<table width="100%" height="100%" cellpadding=0 cellspacing=0>
|
|
<tr><td align=right bgcolor="#FA6F0D" style="text-align:top;padding-top:10px;padding-right:20px">
|
|
<h4><font color=white><%=menu1_title%></font></h4>
|
|
</td></tr></table>
|
|
</div>
|
|
<div class="col-lg-12 col-md-12">
|
|
<div class="tab tab-border">
|
|
<div class="tab-content white-bg" style="padding:10px">
|
|
|
|
<ul class="nav nav-pills nav-stacked sideMenu" >
|
|
<%if(home_fact == 1){
|
|
|
|
String sql_menu_fact= "select * from tbl_menu where c_use = 0 and c_view = 0 and c_up_no = "+ check_no +" order by c_order asc";
|
|
ResultSet rs_menu_fact=stmt.executeQuery(sql_menu_fact);
|
|
while(rs_menu_fact.next()){
|
|
String link_t = "";
|
|
String target_t = "_self";
|
|
if(rs_menu_fact.getInt("c_type") == 1){
|
|
link_t = "/cms_for_bcb/show.jsp?show_no=" + rs_menu_fact.getInt("c_no");
|
|
link_t = link_t + "&check_no=" + rs_menu_fact.getInt("c_up_no");
|
|
link_t = link_t + "&c_relation=" + rs_menu_fact.getInt("c_relation");
|
|
link_t = link_t + "&c_relation2=" + rs_menu_fact.getInt("c_relation2");
|
|
}
|
|
if(rs_menu_fact.getInt("c_type") == 2){
|
|
link_t = "/cms_for_bcb/process/"+ rs_menu_fact.getString("c_content") +"/list.jsp?show_no=" + rs_menu_fact.getInt("c_no");
|
|
link_t = link_t + "&check_no=" + rs_menu_fact.getInt("c_up_no");
|
|
link_t = link_t + "&c_relation=" + rs_menu_fact.getInt("c_relation");
|
|
link_t = link_t + "&c_relation2=" + rs_menu_fact.getInt("c_relation2");
|
|
}
|
|
if(rs_menu_fact.getInt("c_type") == 3){
|
|
link_t = rs_menu_fact.getString("c_content");
|
|
}
|
|
if(rs_menu_fact.getInt("c_type") == 4){
|
|
link_t = rs_menu_fact.getString("c_content");
|
|
target_t = "_blank";
|
|
}
|
|
%>
|
|
<li>
|
|
<a href="<%=link_t%>" target="<%=target_t%>" <%if(Integer.parseInt(show_no) ==rs_menu_fact.getInt("c_no")){%>style="color:#F5A623;"<%}%>><%=rs_menu_fact.getString("c_name")%></a>
|
|
</li>
|
|
<%
|
|
}
|
|
rs_menu_fact.close();
|
|
|
|
}else{
|
|
String sub_m_link = "/";
|
|
String sub_m_targrt = "_self";
|
|
String sub_menu_sql2 = "select a.* ";
|
|
sub_menu_sql2 = sub_menu_sql2 + " from tbl_menu a where a.c_home = " + c_home + " and a.c_use = 0 and a.c_up_no = "+ menu1 +" order by a.c_order asc";
|
|
ResultSet sub_rs_menu2 = stmt.executeQuery(sub_menu_sql2);
|
|
while(sub_rs_menu2.next()){
|
|
|
|
if(sub_rs_menu2.getInt("c_type") == 1 || sub_rs_menu2.getInt("c_type") == 5){
|
|
sub_m_link = "/cms_for_bcb/show.jsp?show_no=" + sub_rs_menu2.getInt("c_no") + "&check_no=" + sub_rs_menu2.getInt("c_up_no") + "&c_relation=" + sub_rs_menu2.getInt("c_relation") + "&c_relation2=" + sub_rs_menu2.getInt("c_relation2");
|
|
}
|
|
if(sub_rs_menu2.getInt("c_type") == 2){
|
|
sub_m_link = "/cms_for_bcb/process/"+ sub_rs_menu2.getString("c_content") +"/list.jsp?show_no="+ sub_rs_menu2.getInt("c_no") +"&check_no="+ sub_rs_menu2.getInt("c_up_no") +"&c_relation="+ sub_rs_menu2.getInt("c_relation") +"&c_relation2="+ sub_rs_menu2.getInt("c_relation2");
|
|
}
|
|
if(sub_rs_menu2.getInt("c_type") == 3 || sub_rs_menu2.getInt("c_type") == 4){
|
|
sub_m_link = sub_rs_menu2.getString("c_content");
|
|
}
|
|
if(sub_rs_menu2.getInt("c_type") == 4){
|
|
sub_m_targrt = "_blank";
|
|
}
|
|
if(sub_rs_menu2.getInt("c_type") == 0){
|
|
String menu_sql3 = "select a.* ";
|
|
menu_sql3 = menu_sql3 + " from tbl_menu a where a.c_home = " + c_home + " and a.c_use = 0 and a.c_up_no = "+ sub_rs_menu2.getInt("c_no") +" order by a.c_order asc";
|
|
ResultSet rs_menu3 = stmt.executeQuery(menu_sql3);
|
|
if(rs_menu3.next()){
|
|
if(rs_menu3.getInt("c_type") == 1 || rs_menu3.getInt("c_type") == 5){
|
|
sub_m_link = "/cms_for_bcb/show.jsp?show_no=" + rs_menu3.getInt("c_no") + "&check_no=" + rs_menu3.getInt("c_up_no") + "&c_relation=" + rs_menu3.getInt("c_relation") + "&c_relation2=" + rs_menu3.getInt("c_relation2");
|
|
}
|
|
if(rs_menu3.getInt("c_type") == 2){
|
|
sub_m_link = "/cms_for_bcb/process/"+ rs_menu3.getString("c_content") +"/list.jsp?show_no="+ rs_menu3.getInt("c_no") +"&check_no="+ rs_menu3.getInt("c_up_no") +"&c_relation="+ rs_menu3.getInt("c_relation") +"&c_relation2="+ rs_menu3.getInt("c_relation2");
|
|
}
|
|
if(rs_menu3.getInt("c_type") == 3 || rs_menu3.getInt("c_type") == 4){
|
|
sub_m_link = rs_menu3.getString("c_content");
|
|
}
|
|
if(rs_menu3.getInt("c_type") == 4){
|
|
sub_m_targrt = "_blank";
|
|
}
|
|
}
|
|
rs_menu3.close();
|
|
}
|
|
|
|
%>
|
|
|
|
<li >
|
|
<a href="<%=sub_m_link%>" target="<%=sub_m_targrt%>" <%if(sub_rs_menu2.getInt("c_no") == menu2){%>style="color:#F5A623;"<%}%>><%=sub_rs_menu2.getString("c_name")%></a>
|
|
<%
|
|
if(sub_rs_menu2.getInt("c_type") == 0){
|
|
%>
|
|
<ul class="sub-menu nav nav-pills nav-stacked">
|
|
<%
|
|
String sub_menu_sql3 = "select a.* ";
|
|
sub_menu_sql3 = sub_menu_sql3 + " from tbl_menu a where a.c_home = " + c_home + " and a.c_use = 0 and a.c_up_no = "+ sub_rs_menu2.getInt("c_no") +" order by a.c_order asc";
|
|
ResultSet sub_rs_menu3 = stmt.executeQuery(sub_menu_sql3);
|
|
while(sub_rs_menu3.next()){
|
|
|
|
if(sub_rs_menu3.getInt("c_type") == 1 || sub_rs_menu3.getInt("c_type") == 5){
|
|
sub_m_link = "/cms_for_bcb/show.jsp?show_no=" + sub_rs_menu3.getInt("c_no") + "&check_no=" + sub_rs_menu3.getInt("c_up_no") + "&c_relation=" + sub_rs_menu3.getInt("c_relation") + "&c_relation2=" + sub_rs_menu3.getInt("c_relation2");
|
|
}
|
|
if(sub_rs_menu3.getInt("c_type") == 2){
|
|
sub_m_link = "/cms_for_bcb/process/"+ sub_rs_menu3.getString("c_content") +"/list.jsp?show_no="+ sub_rs_menu3.getInt("c_no") +"&check_no="+ sub_rs_menu3.getInt("c_up_no") +"&c_relation="+ sub_rs_menu3.getInt("c_relation") +"&c_relation2="+ sub_rs_menu3.getInt("c_relation2");
|
|
}
|
|
if(sub_rs_menu3.getInt("c_type") == 3 || sub_rs_menu3.getInt("c_type") == 4){
|
|
sub_m_link = sub_rs_menu3.getString("c_content");
|
|
}
|
|
if(sub_rs_menu3.getInt("c_type") == 4){
|
|
sub_m_targrt = "_blank";
|
|
}
|
|
|
|
%>
|
|
<li >
|
|
<a href="<%=sub_m_link%>" target="<%=sub_m_targrt%>" <%if(sub_rs_menu3.getInt("c_no") == menu3){%>style="color:#F5A623;"<%}%>><%=sub_rs_menu3.getString("c_name")%></a>
|
|
</li>
|
|
|
|
<%
|
|
}
|
|
sub_rs_menu3.close();
|
|
%>
|
|
</ul>
|
|
<%}%>
|
|
|
|
</li>
|
|
<%
|
|
if(sub_rs_menu2.getInt("c_no") == menu2 && ( sub_rs_menu2.getString("c_name").equals("Comunidad") || sub_rs_menu2.getString("c_name").equals("Community") )){
|
|
if(session.getAttribute("member_no") == null || session.getAttribute("member_no").equals("")){
|
|
%>
|
|
<div style="padding-left:15px;padding-bottom:10px" >
|
|
<a href="/cms_for_bcb/process/community/list.jsp?show_no=<%=sub_rs_menu2.getInt("c_no")%>&check_no=<%=sub_rs_menu2.getInt("c_up_no")%>&c_relation=<%=sub_rs_menu2.getInt("c_relation")%>&c_relation2=<%=sub_rs_menu2.getInt("c_relation2")%>" >My Community</a>
|
|
</div>
|
|
<%
|
|
}else{
|
|
String sql_ss = "select t.* from ( ";
|
|
sql_ss = sql_ss + " select a.*, b.c_name as m_name ";
|
|
sql_ss = sql_ss + " ,(select c_now from tbl_community_member where c_community_no = a.c_no and c_member_no = "+ session.getAttribute("member_no") +" and c_use = 0 ) as my_no ";
|
|
sql_ss = sql_ss + " from tbl_community a ";
|
|
sql_ss = sql_ss + " inner join tbl_member b on b.c_no = a.c_member_no ";
|
|
sql_ss = sql_ss + " where a.c_use = 0 and a.c_home = "+ c_home +" ";
|
|
sql_ss = sql_ss + " ) t where t.c_member_no = "+ session.getAttribute("member_no") +" or (t.my_no is not null and t.my_no in (0,1)) order by t.c_no desc ";
|
|
|
|
int c_counts = 0;
|
|
ResultSet rs_ss = stmt.executeQuery(sql_ss);
|
|
while (rs_ss.next()) {
|
|
c_counts = c_counts + 1;
|
|
%>
|
|
<%if(c_counts == 1){%>
|
|
|
|
<div style="padding-left:25px;padding-bottom:10px;" >
|
|
<a <%if(now_community > 0){%>style="color:#F5A623;"<%}%> href="/cms_for_bcb/process/community/community/list.jsp?show_no=<%=sub_rs_menu2.getInt("c_no")%>&check_no=<%=sub_rs_menu2.getInt("c_up_no")%>&c_relation=<%=sub_rs_menu2.getInt("c_relation")%>&c_relation2=<%=sub_rs_menu2.getInt("c_relation2")%>&c_no=<%=rs_ss.getInt("c_no")%>" >My Community</a>
|
|
</div>
|
|
|
|
<%}%>
|
|
<div style="padding-left:35px;line-height:100%;padding-bottom:5px;padding-top:5px;background:#efefef">
|
|
<a <%if(now_community == rs_ss.getInt("c_no")){%>style="color:#F5A623;"<%}%> href="/cms_for_bcb/process/community/community/list.jsp?show_no=<%=sub_rs_menu2.getInt("c_no")%>&check_no=<%=sub_rs_menu2.getInt("c_up_no")%>&c_relation=<%=sub_rs_menu2.getInt("c_relation")%>&c_relation2=<%=sub_rs_menu2.getInt("c_relation2")%>&c_no=<%=rs_ss.getInt("c_no")%>" ><%=rs_ss.getString("c_name")%></a>
|
|
</div>
|
|
<%if(now_community == rs_ss.getInt("c_no")){%>
|
|
<div style="padding-left:45px;line-height:100%;padding-bottom:5px;padding-top:5px;background:#efefef">
|
|
<a <%if(now_community_board == 0){%>style="color:#F5A623;"<%}%> href="/cms_for_bcb/process/community/community/list.jsp?show_no=<%=sub_rs_menu2.getInt("c_no")%>&check_no=<%=sub_rs_menu2.getInt("c_up_no")%>&c_relation=<%=sub_rs_menu2.getInt("c_relation")%>&c_relation2=<%=sub_rs_menu2.getInt("c_relation2")%>&c_no=<%=rs_ss.getInt("c_no")%>" >┗ Introduction</a>
|
|
</div>
|
|
<%
|
|
String sql_bb = "select * from tbl_community_board where c_community_no = "+ rs_ss.getInt("c_no") +" and c_use = 0 and c_view = 0 order by c_order asc ";
|
|
ResultSet rs_bb = stmt.executeQuery(sql_bb);
|
|
|
|
while (rs_bb.next()) {
|
|
|
|
%>
|
|
<div style="padding-left:45px;line-height:100%;padding-bottom:5px;padding-top:5px;background:#efefef">
|
|
<a <%if(now_community_board == rs_bb.getInt("c_no")){%>style="color:#F5A623;"<%}%> href="/cms_for_bcb/process/community/community/board/list.jsp?show_no=<%=sub_rs_menu2.getInt("c_no")%>&check_no=<%=sub_rs_menu2.getInt("c_up_no")%>&c_relation=<%=sub_rs_menu2.getInt("c_relation")%>&c_relation2=<%=sub_rs_menu2.getInt("c_relation2")%>&c_no=<%=rs_ss.getInt("c_no")%>&c_board_no=<%=rs_bb.getInt("c_no")%>" > ┗ <%=rs_bb.getString("c_name")%></a>
|
|
</div>
|
|
<%}
|
|
rs_bb.close();
|
|
%>
|
|
<%}%>
|
|
<div style="height:3px">
|
|
</div>
|
|
<%
|
|
}
|
|
rs_ss.close();
|
|
}
|
|
}
|
|
%>
|
|
|
|
<%
|
|
if(sub_rs_menu2.getInt("c_no") == menu2 && sub_rs_menu2.getString("c_name").equals("Mentoring") && c_home == 33 ){
|
|
if(session.getAttribute("member_no") == null || session.getAttribute("member_no").equals("")){
|
|
|
|
}else{
|
|
|
|
%>
|
|
|
|
|
|
|
|
<div style="padding-left:35px;line-height:100%;padding-bottom:5px;padding-top:5px;background:#efefef">
|
|
<a <%if(!r_call(request.getParameter("c_no")).equals("") && r_call(request.getParameter("c_board_no")).equals("")){%>style="color:#F5A623;"<%}%> href="/cms_for_bcb/process/community/mentoring/community/list.jsp?show_no=444&check_no=316&c_relation=2056&c_relation2=1112&c_no=12" >┗ Introduction</a>
|
|
</div>
|
|
<%
|
|
String sql_bb = "select * from tbl_community_board where c_community_no = 12 and c_use = 0 and c_view = 0 order by c_order asc ";
|
|
ResultSet rs_bb = stmt.executeQuery(sql_bb);
|
|
|
|
while (rs_bb.next()) {
|
|
|
|
%>
|
|
<div style="padding-left:35px;line-height:100%;padding-bottom:5px;padding-top:5px;background:#efefef">
|
|
<a <%if(!r_call(request.getParameter("c_no")).equals("") && !r_call(request.getParameter("c_board_no")).equals("")){%>style="color:#F5A623;"<%}%> href="/cms_for_bcb/process/community/mentoring/community/board/list.jsp?show_no=444&check_no=316&c_relation=2056&c_relation2=1112&c_no=12&c_board_no=<%=rs_bb.getInt("c_no")%>" > ┗ <%=rs_bb.getString("c_name")%></a>
|
|
</div>
|
|
<%}
|
|
rs_bb.close();
|
|
%>
|
|
|
|
|
|
<%
|
|
|
|
}
|
|
}
|
|
%>
|
|
<%
|
|
|
|
}
|
|
sub_rs_menu2.close();
|
|
%>
|
|
<%}%>
|
|
</ul>
|
|
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<style type="text/css">
|
|
<!--
|
|
@media (max-width: 800px) {
|
|
.navi_text { display: none; }
|
|
}
|
|
//-->
|
|
</style>
|
|
<div class="col-lg-9 col-md-9 page-content" style="padding-top:10px">
|
|
<div class="row">
|
|
<div class="col-lg-12 col-md-12" style="padding-bottom:10px">
|
|
<div class="col-lg-6 col-md-6">
|
|
<div class="text-left" >
|
|
<h4 class="theme-color" >· <%=page_title%></h4>
|
|
</div>
|
|
|
|
</div>
|
|
<div class="navi_text col-lg-6 col-md-6">
|
|
<div class="text-right" >
|
|
<div class=" mb-20"><%=navi_text%></div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="col-lg-12 col-md-12">
|
|
<div class="tab tab-border">
|
|
<div class="tab-content white-bg" style="padding:30px">
|
|
|