81 lines
2.8 KiB
Plaintext
81 lines
2.8 KiB
Plaintext
<%@ page contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
|
|
<%@include file="/include/include.jsp"%>
|
|
|
|
<%
|
|
String call_home = r_call(request.getParameter("c_home"));
|
|
String call_maker = r_call(request.getParameter("c_maker"));
|
|
|
|
int sub_show_no = 0;
|
|
int sub_check_no = 0;
|
|
int sub_c_relation = 0;
|
|
int sub_c_relation2 = 0;
|
|
int sub_c_use = 0;
|
|
|
|
|
|
String sql_sub_t = "select * from tbl_menu where c_home = " + call_home + " and c_maker = " + call_maker + " and c_name = 'Notice' and c_fix = 1";
|
|
ResultSet rs_sub_t = stmt.executeQuery(sql_sub_t);
|
|
if(rs_sub_t.next()){
|
|
sub_show_no = rs_sub_t.getInt("c_no");
|
|
sub_check_no = rs_sub_t.getInt("c_up_no");
|
|
sub_c_relation = rs_sub_t.getInt("c_relation");
|
|
sub_c_relation2 = rs_sub_t.getInt("c_relation2");
|
|
sub_c_use = rs_sub_t.getInt("c_use");
|
|
}else{
|
|
}
|
|
rs_sub_t.close();
|
|
%>
|
|
<div class="col-lg-12 col-md-12 col-sm-12" >
|
|
<div class="col-lg-8 col-md-8 " style="text-align:left">
|
|
<h5 class="theme-color">
|
|
<a href="/cms_for_bcb/process/notice/list.jsp?show_no=<%=sub_show_no%>&check_no=<%=sub_check_no%>&c_relation=<%=sub_c_relation%>&c_relation2=<%=sub_c_relation2%>">
|
|
Notice
|
|
</a>
|
|
</h5>
|
|
</div>
|
|
<div class="col-lg-4 col-md-4 " style="text-align:right">
|
|
<a href="/cms_for_bcb/process/notice/list.jsp?show_no=<%=sub_show_no%>&check_no=<%=sub_check_no%>&c_relation=<%=sub_c_relation%>&c_relation2=<%=sub_c_relation2%>"><font color=red><b>+</b></font></a>
|
|
</div>
|
|
</div>
|
|
<div class="col-lg-12 col-md-12 col-sm-12" >
|
|
<table width="100%" cellSpacing="0" cellPadding="0" border="0" bgcolor=ffffff >
|
|
<tr>
|
|
<td height="1px" colspan=2 bgcolor="cdcdcd">
|
|
</td>
|
|
</tr>
|
|
<%
|
|
String sql1 = " select t.* from ( select a.* ";
|
|
sql1 = sql1 + " from tbl_board a ";
|
|
sql1 = sql1 + " where a.c_use= 0 and a.c_relation = "+ sub_c_relation +" and a.c_relation2 = "+ sub_c_relation2 +" and a.c_home = "+ call_home +" and a.c_maker = "+ call_maker +" and a.c_board_no = "+ sub_show_no +") t ";
|
|
sql1 = sql1 + " order by t.c_no desc ";
|
|
sql1 = sql1 + " limit 0 , 10 ";
|
|
ResultSet rst = stmt.executeQuery(sql1);
|
|
while(rst.next()){
|
|
%>
|
|
<tr>
|
|
<td height="26" align=left style="padding-left:5px;" >
|
|
<a href="/cms_for_bcb/process/notice/view.jsp?show_no=<%=sub_show_no%>&check_no=<%=sub_check_no%>&c_relation=<%=sub_c_relation%>&c_relation2=<%=sub_c_relation2%>&c_no=<%=rst.getInt("c_no")%>">
|
|
<%if(rst.getString("c_title").length() > 20){%>
|
|
<%=rst.getString("c_title").substring(0,20)%>..
|
|
<%}else{%>
|
|
<%=rst.getString("c_title")%>
|
|
<%}%>
|
|
</a>
|
|
</td>
|
|
<td align=right style="padding-right:5px;width:80px">
|
|
<%=rst.getString("c_date").substring(0,10)%>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td height="1px" colspan=2 bgcolor="cdcdcd">
|
|
</td>
|
|
</tr>
|
|
<%
|
|
}
|
|
rst.close();
|
|
|
|
%>
|
|
</table>
|
|
</div>
|
|
|
|
<%@include file="/include/include_b.jsp"%>
|