c-innovacion2/resoft/cms_for_bcb/process/board/view.jsp

162 lines
6.0 KiB
Plaintext

<%@ page contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@include file="/include/include.jsp"%>
<%@include file="/include/head.jsp"%>
<%@include file="/cms_for_bcb/show_top.jsp"%>
<select id="language_select" onchange="setLanguage(this.value)">
<option value="en" <%= (request.getLocale().toString().equals("en") ? "selected" : "") %>>English</option>
<option value="es_PE" <%= (request.getLocale().toString().equals("es_PE") ? "selected" : "") %>>Spanish (Peru)</option>
</select>
</p>
<%
String nowPage = r_call(request.getParameter("nowPage"));
String c_no = r_call(request.getParameter("c_no"));
if(c_no.equals("")){
}else{
String sql_ok = "update tbl_board set c_click = c_click + 1 where c_no = " + c_no;
stmt2.execute(sql_ok);
String sql1 = " select * from tbl_board where c_no = " + c_no;
ResultSet rst = stmt.executeQuery(sql1);
if (rst.next()) {
%>
<div class="row">
<div class="col-lg-12 col-md-12" style=" padding:0px 15px;">
<div class="col-lg-12 col-md-12" style="border-bottom: 1px solid #ccc; padding:10px ">
<span id="a1">Title.</span> <%=rst.getString("c_title")%></b>
</div>
<div class="col-lg-12 col-md-12" style="border-bottom: 1px solid #ccc; padding:10px ">
<div class="col-lg-4 col-md-4" >
<span id="a2">Name.</span> <%=rst.getString("c_name")%></b>
</div>
<div class="col-lg-4 col-md-4" style="text-align:center">
<span id="a3">Clicks</span> <%=rst.getString("c_click")%></b>
</div>
<div class="col-lg-4 col-md-4" style="text-align:right">
<span id="a4"> date</span> <%=rst.getString("c_date").substring(0,10)%></b>
</div>
</div>
<div class="col-lg-12 col-md-12" style="border-bottom: 1px solid #ccc; padding:10px ">
<span id="a5"> To.</span>
<%
String sql12 = " select a.*,(select c_team_name from tbl_team where c_no = a.c_group_no) as team_name from tbl_board_to a where a.c_board_no = " + c_no;
ResultSet rst2 = stmt.executeQuery(sql12);
int ty = 0;
while (rst2.next()) {
ty = ty + 1;
%>
<%if(rst2.getInt("c_group_type") == 0){%>
<%if(rst2.getInt("c_group_no") == 0){%>
<nobr><%if(ty>1){%>/ <%}%><span id="a8">All Members</span> &nbsp;&nbsp;</nobr>
<%}%>
<%if(rst2.getInt("c_group_no") == 1){%>
<nobr><%if(ty>1){%>/ <%}%><span id="a9">All Instructors</span> &nbsp;</nobr>
<%}%>
<%if(rst2.getInt("c_group_no") == 2){%>
<nobr><%if(ty>1){%>/ <%}%><span id="a10">All Mentors</span> &nbsp;&nbsp;</nobr>
<%}%>
<%if(rst2.getInt("c_group_no") == 3){%>
<nobr><%if(ty>1){%>/ <%}%><span id="a11">All Observers </span>&nbsp;&nbsp;</nobr>
<%}%>
<%}else{%>
<nobr><%if(ty>1){%>/ <%}%><span id="a12">Members of team</span>[<%=rst2.getString("team_name") %>] &nbsp;&nbsp;</nobr>
<%}%>
<%
}
rst2.close();
%>
</div>
<div class="col-lg-12 col-md-12" style="min-height:100px;border-bottom: 1px solid #ccc; padding:10px ">
<%=rst.getString("c_content").replaceAll("\n\r","<br />")%></b>
</div>
<div class="col-lg-12 col-md-12" style="border-bottom: 1px solid #ccc; padding:10px ">
<span id="a6"> File.</span> <a href="/upload/board/<%=rst.getString("c_file")%>"><%=rst.getString("c_file")%></a></b>
</div>
</div>
</div>
<div class="col-lg-12 col-md-12" style="text-align:right;padding-top:20px">
<%if(rst.getString("c_member_no").equals(session.getAttribute("member_no") ) && !session.getAttribute("member_type").equals("0")){%>
<a href="edit.jsp?<%=para_t%>&c_no=<%=c_no%>" style="width: 80px; line-height: 26px; text-align: center;display: inline-block; background: #5e7cc4; border: 1px solid #555; border-radius: 5px; color: #ffffff;"><span id="a13">Edit</span></a>
<a href="#none" onclick="if(confirm('Delete?')){location.href='delete_ok.jsp?<%=para_t%>&c_no=<%=c_no%>'}" style="width: 80px; line-height: 26px; text-align: center;display: inline-block; background: red; border: 1px solid #555; border-radius: 5px; color: #ffffff;"><span id="a14">Delete</span></a>
<%}%>
<a href="list.jsp?<%=para_t%>&nowPage=<%=nowPage%>" style="width: 80px; line-height: 26px; text-align: center;display: inline-block; background: #989898; border: 1px solid #555; border-radius: 5px; color: #ffffff;"><span id="a7">List</span></a>
</div>
<%
}
rst.close();
}
%>
<script>
// 다국어 처리를 위한 i18n 객체
var i18n = {
en: {
a1: "Title.",
a2: "Name.",
a3: "Clicks",
a4: "date",
a5: "To.",
a6: "File.",
a7: "List",
a8: "All Members",
a9: "All Instructors",
a10: "All Mentors",
a11: "All Observers",
a12: "Members of team",
a13: "Edit",
a14: "Delete"
},
es_PE: {
a1: "Título.",
a2: "Nombre.",
a3: "Clics",
a4: "fecha",
a5: "A.",
a6: "Archivo.",
a7: "Lista",
a8: "Todos los miembros",
a9: "Todos los instructores",
a10: "Todos los mentores",
a11: "Todos los observadores",
a12: "Miembros del equipo",
a13: "Editar",
a14: "Borrar"
}
};
// 선택된 언어에 따라 다국어 텍스트 설정
function setLanguage(lang) {
var langData = i18n[lang];
document.getElementById("a1").innerText = langData.a1;
document.getElementById("a2").innerText = langData.a2;
document.getElementById("a3").innerText = langData.a3;
document.getElementById("a4").innerText = langData.a4;
document.getElementById("a5").innerText = langData.a5;
document.getElementById("a6").innerText = langData.a6;
document.getElementById("a7").innerText = langData.a7;
document.getElementById("a8").innerText = langData.a8;
document.getElementById("a9").innerText = langData.a9;
document.getElementById("a10").innerText = langData.a10;
document.getElementById("a11").innerText = langData.a11;
document.getElementById("a12").innerText = langData.a12;
document.getElementById("a13").innerText = langData.a13;
document.getElementById("a14").innerText = langData.a14;
}
</script>
<script>
setLanguage('<%= request.getLocale().toString() %>');
</script>
<%@include file="/cms_for_bcb/show_bottom.jsp"%>
<%@include file="/include/bottom.jsp"%>
<%@include file="/include/include_b.jsp"%>