473 lines
17 KiB
Plaintext
473 lines
17 KiB
Plaintext
<%@ page contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
|
|
<%@include file="/include/include.jsp"%>
|
|
<%
|
|
login_tag = 1;
|
|
%>
|
|
<%@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 c_project_no = r_call(request.getParameter("c_project_no"));
|
|
int c_now_propose = 0;
|
|
if(c_project_no.equals("")){
|
|
%>
|
|
<script>
|
|
alert("Wrong Connection")
|
|
location.href="/"
|
|
</script>
|
|
<%
|
|
}else{
|
|
String slq_chekc = "select * from tbl_apply_team where c_project_no = "+ c_project_no + " and c_member_no = " + session.getAttribute("member_no") + " and c_use = 0 ";
|
|
ResultSet rs_check = stmt.executeQuery(slq_chekc);
|
|
if (rs_check.next()) {
|
|
|
|
|
|
String sql_up = " SELECT c.*, a.c_name as u_name, b.c_name as f_name ";
|
|
sql_up = sql_up + " , (select c_now_propose from tbl_project_plan where c_relation = 0 and c_project_no = c.c_no) as c_now_propose " ;
|
|
sql_up = sql_up + " from tbl_project c ";
|
|
sql_up = sql_up + " inner join tbl_project a on a.c_no = c.c_up_no ";
|
|
sql_up = sql_up + " inner join tbl_field b on b.c_no = a.c_field ";
|
|
sql_up = sql_up + " where c.c_no = " + c_project_no;
|
|
ResultSet rs_up = stmt.executeQuery(sql_up);
|
|
if (rs_up.next()) {
|
|
c_now_propose = rs_up.getInt("c_now_propose");
|
|
%>
|
|
<script>
|
|
function go(){
|
|
<%if(c_now_propose == 1){%>
|
|
if(document.bcb.c_team_name.value == ""){
|
|
alert("Insert Team Name")
|
|
document.bcb.c_team_name.focus();
|
|
}else{
|
|
document.bcb.method = "post"
|
|
document.bcb.target = "exec"
|
|
document.bcb.action = "insert_ok.jsp?show_no=<%=show_no%>&check_no=<%=check_no%>&c_relation=<%=c_relation%>&c_relation2=<%=c_relation2%>"
|
|
document.bcb.submit()
|
|
}
|
|
<%}else{%>
|
|
alert("This is not the application period.")
|
|
<%}%>
|
|
}
|
|
</script>
|
|
<form name="bcb" encType="multipart/form-data">
|
|
<input name="c_home" value="<%=c_home%>" type="hidden">
|
|
<input name="c_maker" value="0" type="hidden">
|
|
<input name="c_project_no" value="<%=c_project_no%>" type="hidden">
|
|
|
|
|
|
<table width="100%" border="0" cellspacing="1" cellpadding="0" bgcolor=dddddd >
|
|
<tr " bgcolor=ffffff>
|
|
<td colspan=2 align=center style="font-weight:bold;width:15%;min-width:50px"><span id="a1"> System</span></td>
|
|
<td width="85%" style="padding:5px">
|
|
<b><%=rs_up.getString("f_name")%>
|
|
</td>
|
|
</tr>
|
|
<tr bgcolor=ffffff>
|
|
<td colspan=2 align=center style="font-weight:bold;"><span id="a2">Category</span></td>
|
|
<td style="padding:5px">
|
|
<b><%=rs_up.getString("u_name")%>
|
|
</td>
|
|
</tr>
|
|
<tr height=30 bgcolor=ffffff>
|
|
<td colspan=2 align=center style="font-weight:bold;"><span id="a3"> Program </span></td>
|
|
<td style="padding:5px">
|
|
<font color=red><b><%=rs_up.getString("c_name")%></b></font>
|
|
</tr>
|
|
|
|
</table>
|
|
<%
|
|
|
|
}
|
|
rs_up.close();
|
|
|
|
%>
|
|
|
|
<table width="100%" border="0" cellspacing="1" cellpadding="0" bgcolor=dddddd >
|
|
<tr height="30" bgcolor=efefef>
|
|
<td align=center style="width:15%;min-width:50px" ><span id="a4"> Article</span></td>
|
|
<td align=center style="width:85%" ><span id="a5"> Contents</span></td>
|
|
|
|
</tr>
|
|
<%
|
|
int i = 0;
|
|
int stu_check = 1;
|
|
String sql_field = " SELECT * from tbl_apply_field where c_project_no = " + c_project_no +" order by c_order asc ";
|
|
ResultSet rs_field = stmt.executeQuery(sql_field);
|
|
while (rs_field.next()) {
|
|
if(rs_field.getString("c_use_field").equals("c_grade")){
|
|
stu_check = 0;
|
|
}
|
|
i = i + 1;
|
|
%>
|
|
|
|
<tr bgcolor=ffffff>
|
|
|
|
<td height="40" align=center >
|
|
<%=rs_field.getString("c_name")%>
|
|
</td>
|
|
<td align=left style="padding:5px">
|
|
<%if(rs_field.getInt("c_type") == 1){%>
|
|
<input name="<%=rs_field.getString("c_use_field")%>" value="<%=rs_check.getString(rs_field.getString("c_use_field"))%>" style="width:100%">
|
|
<%}%>
|
|
<%if(rs_field.getInt("c_type") == 2){
|
|
%>
|
|
<select name="<%=rs_field.getString("c_use_field")%>" >
|
|
<%if(rs_field.getString("c_content") != null && !rs_field.getString("c_content").equals("")){
|
|
String[] sArray1 = rs_field.getString("c_content").split("[|]");
|
|
for( int ii = 0; ii < sArray1.length; ii++ ){
|
|
%>
|
|
<option <%if(rs_check.getString(rs_field.getString("c_use_field")).equals(sArray1[ii])){%>selected<%}%>><%=sArray1[ii]%></option>
|
|
<%
|
|
}
|
|
%>
|
|
|
|
<%}%>
|
|
</select>
|
|
<%}%>
|
|
<%if(rs_field.getInt("c_type") == 3){%>
|
|
<textarea name="<%=rs_field.getString("c_use_field")%>" style="width:100%;height:100px"><%=rs_check.getString(rs_field.getString("c_use_field"))%></textarea>
|
|
<%}%>
|
|
<%if(rs_field.getInt("c_type") == 4){%>
|
|
Attach : <%=rs_check.getString(rs_field.getString("c_use_field"))%>
|
|
<input name="o_<%=rs_field.getString("c_use_field")%>" value="<%=rs_check.getString(rs_field.getString("c_use_field"))%>" type="hidden">
|
|
<table><tr><td>Change : </td>
|
|
<td>
|
|
<input name="<%=rs_field.getString("c_use_field")%>" type="file">
|
|
</td></tr></table>
|
|
form : <a href="/upload/yangsik/<%=rs_field.getString("c_content")%>"><%=rs_field.getString("c_content")%></a>
|
|
<%}%>
|
|
</td>
|
|
|
|
|
|
</tr>
|
|
<tr><td height=1 bgcolor=cdcdcd colspan=2></td></tr>
|
|
<%
|
|
|
|
}
|
|
rs_field.close();
|
|
%>
|
|
</table>
|
|
<%
|
|
String major_t = "Department";
|
|
String grade_t = "Grade";
|
|
if( stu_check == 1){
|
|
major_t = "Department";
|
|
grade_t = "Rank";
|
|
}
|
|
%>
|
|
<br>
|
|
<h7><b id="a6">Team Leader Information</b></h7>
|
|
<%
|
|
String slq_t = "select * from tbl_apply_team_member where c_project_no = "+ c_project_no + " and c_team_no = " + rs_check.getInt("c_no") + " and c_use = 0 and c_type= 1 ";
|
|
ResultSet rs_t = stmt2.executeQuery(slq_t);
|
|
if (rs_t.next()) {
|
|
%>
|
|
|
|
<table width="100%" border="0" cellspacing="1" cellpadding="0" bgcolor=dddddd >
|
|
<tr height="24" bgcolor=efefef>
|
|
<td align=center style="width:15%;min-width:50px" >
|
|
<span id="a7">Email(ID)</span>
|
|
</td>
|
|
<td bgcolor=ffffff style="padding-left:5px">
|
|
<input name="m_email" style="width:80%" value="<%=rs_t.getString("c_email")%>" readonly>
|
|
</td>
|
|
</tr>
|
|
<tr height="24" bgcolor=efefef>
|
|
<td align=center style="width:15%;min-width:50px" >
|
|
<span id="a8">Name</span>
|
|
</td>
|
|
<td bgcolor=ffffff style="padding-left:5px">
|
|
<input name="m_name" style="width:50%" value="<%=rs_t.getString("c_name")%>" readonly>
|
|
</td>
|
|
</tr>
|
|
<tr height="24" bgcolor=efefef>
|
|
<td align=center style="width:15%;min-width:50px" >
|
|
<span id="a9">Mobile </span>
|
|
</td>
|
|
<td bgcolor=ffffff style="padding-left:5px">
|
|
<input name="m_phone" style="width:50%" value="<%=rs_t.getString("c_phone")%>" >
|
|
</td>
|
|
</tr>
|
|
<tr height="24" bgcolor=efefef>
|
|
<td align=center style="width:15%;min-width:50px" >
|
|
<%=major_t%>
|
|
</td>
|
|
<td bgcolor=ffffff style="padding-left:5px">
|
|
<input name="m_major" style="width:70%" value="<%=rs_t.getString("c_major")%>" >
|
|
</td>
|
|
</tr>
|
|
<tr height="24" bgcolor=efefef>
|
|
<td align=center style="width:15%;min-width:50px" >
|
|
<%=grade_t%>
|
|
</td>
|
|
<td bgcolor=ffffff style="padding-left:5px">
|
|
<%if( stu_check == 0){%>
|
|
<select name="m_grade">
|
|
<option value="1 Grade" <%if(rs_t.getString("c_grade").equals("1 Grade")){%>selected<%}%>>1 Grade</option>
|
|
<option value="2 Grade" <%if(rs_t.getString("c_grade").equals("2 Grade")){%>selected<%}%>>2 Grade</option>
|
|
<option value="3 Grade" <%if(rs_t.getString("c_grade").equals("3 Grade")){%>selected<%}%>>3 Grade</option>
|
|
<option value="4 Grade" <%if(rs_t.getString("c_grade").equals("4 Grade")){%>selected<%}%>>4 Grade</option>
|
|
<option value="Graduate school" <%if(rs_t.getString("c_grade").equals("Graduate school")){%>selected<%}%>>Graduate school</option>
|
|
</select>
|
|
<%}else{%>
|
|
<input name="m_grade" style="width:50%" value="<%=rs_t.getString("c_grade")%>" >
|
|
<%}%>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<%}
|
|
rs_t.close();
|
|
%>
|
|
<br>
|
|
<script>
|
|
var tm_no = 1;
|
|
function p_tm(flag){
|
|
if(tm_no + flag < 1){
|
|
alert("At least one team member must be registered.")
|
|
}else if(tm_no + flag > 10){
|
|
alert("Up to 10 team members can be registered.")
|
|
}else{
|
|
if(flag == 1){
|
|
tm_no = tm_no + 1
|
|
document.getElementById("tm_"+tm_no).style.display = "block"
|
|
}else{
|
|
document.getElementById("tm_"+tm_no).style.display = "none"
|
|
tm_no = tm_no - 1
|
|
}
|
|
}
|
|
}
|
|
</script>
|
|
<h7><b id="a10">Team member information </b> <a href="#none" onclick="p_tm(1)">+</a> <a href="#none" onclick="p_tm(-1)">-</a></h7>
|
|
<%
|
|
slq_t = "select * from tbl_apply_team_member where c_project_no = "+ c_project_no + " and c_team_no = " + rs_check.getInt("c_no") + " and c_use = 0 and c_type= 0 ";
|
|
rs_t = stmt2.executeQuery(slq_t);
|
|
int trr = 0;
|
|
while(rs_t.next()) {
|
|
trr = trr + 1;
|
|
%>
|
|
<table id="tm_<%=trr%>" border="0" cellspacing="1" cellpadding="0" bgcolor=dddddd style="width:100%;" >
|
|
<tr height="24" bgcolor=efefef>
|
|
<td bgcolor=cdcdcd align=center style="width:5%;min-width:50px" rowspan=5 >
|
|
<span id="a11">Team Members</span><%=trr%>.
|
|
</td><td align=center style="width:15%;min-width:50px" >
|
|
<span id="a12">Email(ID)</span>
|
|
</td>
|
|
<td bgcolor=ffffff style="padding-left:5px">
|
|
<input name="m_email" style="width:80%" value="<%=rs_t.getString("c_email")%>" >
|
|
</td>
|
|
</tr>
|
|
<tr height="24" bgcolor=efefef>
|
|
<td align=center style="width:15%;min-width:50px" >
|
|
<span id="a13">Name</span>
|
|
</td>
|
|
<td bgcolor=ffffff style="padding-left:5px">
|
|
<input name="m_name" style="width:50%" value="<%=rs_t.getString("c_name")%>" >
|
|
</td>
|
|
</tr>
|
|
<tr height="24" bgcolor=efefef>
|
|
<td align=center style="width:15%;min-width:50px" >
|
|
<span id="a14">Mobile</span>
|
|
</td>
|
|
<td bgcolor=ffffff style="padding-left:5px">
|
|
<input name="m_phone" style="width:50%" value="<%=rs_t.getString("c_phone")%>" >
|
|
</td>
|
|
</tr>
|
|
<tr height="24" bgcolor=efefef>
|
|
<td align=center style="width:15%;min-width:50px" >
|
|
<%=major_t%>
|
|
</td>
|
|
<td bgcolor=ffffff style="padding-left:5px">
|
|
<input name="m_major" style="width:70%" value="<%=rs_t.getString("c_major")%>" >
|
|
</td>
|
|
</tr>
|
|
<tr height="24" bgcolor=efefef>
|
|
<td align=center style="width:15%;min-width:50px" >
|
|
<%=grade_t%>
|
|
</td>
|
|
<td bgcolor=ffffff style="padding-left:5px">
|
|
<%if( stu_check == 0){%>
|
|
<select name="m_grade">
|
|
<option value="1 Grade" <%if(rs_t.getString("c_grade").equals("1 Grade")){%>selected<%}%>>1 Grade</option>
|
|
<option value="2 Grade" <%if(rs_t.getString("c_grade").equals("2 Grade")){%>selected<%}%>>2 Grade</option>
|
|
<option value="3 Grade" <%if(rs_t.getString("c_grade").equals("3 Grade")){%>selected<%}%>>3 Grade</option>
|
|
<option value="4 Grade" <%if(rs_t.getString("c_grade").equals("4 Grade")){%>selected<%}%>>4 Grade</option>
|
|
<option value="Graduate school" <%if(rs_t.getString("c_grade").equals("Graduate school")){%>selected<%}%>>Graduate school</option>
|
|
</select>
|
|
<%}else{%>
|
|
<input name="m_grade" style="width:50%" value="<%=rs_t.getString("c_grade")%>" >
|
|
<%}%>
|
|
</td>
|
|
</tr>
|
|
<tr><td height=20 bgcolor=ffffff colspan=3></td></tr>
|
|
</table>
|
|
<%}
|
|
rs_t.close();
|
|
%>
|
|
<script>
|
|
tm_no = <%=trr%>;
|
|
</script>
|
|
<%for(int ir = trr+ 1; ir<11; ir++){%>
|
|
<table id="tm_<%=ir%>" border="0" cellspacing="1" cellpadding="0" bgcolor=dddddd style="width:100%;<%if(ir>1){%>display:none<%}%> " >
|
|
<tr height="24" bgcolor=efefef>
|
|
<td bgcolor=cdcdcd align=center style="width:5%;min-width:50px" rowspan=5 >
|
|
Team Members<%=ir%>.
|
|
</td><td align=center style="width:15%;min-width:50px" >
|
|
Email(ID)
|
|
</td>
|
|
<td bgcolor=ffffff style="padding-left:5px">
|
|
<input name="m_email" style="width:80%" value="" >
|
|
</td>
|
|
</tr>
|
|
<tr height="24" bgcolor=efefef>
|
|
<td align=center style="width:15%;min-width:50px" >
|
|
Name
|
|
</td>
|
|
<td bgcolor=ffffff style="padding-left:5px">
|
|
<input name="m_name" style="width:50%" value="" >
|
|
</td>
|
|
</tr>
|
|
<tr height="24" bgcolor=efefef>
|
|
<td align=center style="width:15%;min-width:50px" >
|
|
Mobile
|
|
</td>
|
|
<td bgcolor=ffffff style="padding-left:5px">
|
|
<input name="m_phone" style="width:50%" value="" >
|
|
</td>
|
|
</tr>
|
|
<tr height="24" bgcolor=efefef>
|
|
<td align=center style="width:15%;min-width:50px" >
|
|
<%=major_t%>
|
|
</td>
|
|
<td bgcolor=ffffff style="padding-left:5px">
|
|
<input name="m_major" style="width:70%" value="" >
|
|
</td>
|
|
</tr>
|
|
<tr height="24" bgcolor=efefef>
|
|
<td align=center style="width:15%;min-width:50px" >
|
|
<%=grade_t%>
|
|
</td>
|
|
<td bgcolor=ffffff style="padding-left:5px">
|
|
<%if( stu_check == 0){%>
|
|
<select name="m_grade">
|
|
<option value="1 Grade">1 Grade</option>
|
|
<option value="2 Grade">2 Grade</option>
|
|
<option value="3 Grade">3 Grade</option>
|
|
<option value="4 Grade">4 Grade</option>
|
|
<option value="Graduate school">Graduate school</option>
|
|
</select>
|
|
<%}else{%>
|
|
<input name="m_grade" style="width:50%" value="" >
|
|
<%}%>
|
|
</td>
|
|
</tr>
|
|
<tr><td height=20 bgcolor=ffffff colspan=3></td></tr>
|
|
</table>
|
|
<%}%>
|
|
|
|
<table width="100%">
|
|
<tr>
|
|
<td height="45" align="center" colspan="5" style="padding-bottom:10px;padding-top:10px;font-weight:bold;">
|
|
<a href="#none" onclick="go()" style="width: 160px; line-height: 26px; text-align: center;display: inline-block; background: #5e7cc4; border: 1px solid #555; border-radius: 5px; color: #ffffff;"><span id="a15">Change content</span></a>
|
|
<a href="#none" onclick="if(confirm('If it is canceled, all the information entered will be deleted. \nAre you sure you want to cancel?')){location.href='delete_ok.jsp?c_no=<%=rs_check.getInt("c_no")%>&show_no=<%=show_no%>&check_no=<%=check_no%>&c_relation=<%=c_relation%>&c_relation2=<%=c_relation2%>'}" style="width: 160px; line-height: 26px; text-align: center;display: inline-block; background: red; border: 1px solid #555; border-radius: 5px; color: #ffffff;"><span id="a16">Cancel an app</span></a>
|
|
<a href="list.jsp?show_no=<%=show_no%>&check_no=<%=check_no%>&c_relation=<%=c_relation%>&c_relation2=<%=c_relation2%>" style="width: 100px; line-height: 26px; text-align: center;display: inline-block; background: #ededed; border: 1px solid #555; border-radius: 5px; color: #000000;"><span id="a17">List</span></a>
|
|
</td>
|
|
|
|
</tr>
|
|
</table>
|
|
</form>
|
|
<iframe name="exec" id="exec" src="" width=0 height=0></iframe>
|
|
<%}else{%>
|
|
<script>
|
|
alert("There is no application for the selected program");
|
|
location.href="list.jsp?show_no=<%=show_no%>&check_no=<%=check_no%>&c_relation=<%=c_relation%>&c_relation2=<%=c_relation2%>"
|
|
</script>
|
|
<%}
|
|
rs_check.close();
|
|
%>
|
|
<%}%>
|
|
|
|
|
|
<script>
|
|
// 다국어 처리를 위한 i18n 객체
|
|
var i18n = {
|
|
en: {
|
|
a1: "System",
|
|
a2: "Category",
|
|
a3: "Program",
|
|
a4: "Article",
|
|
a5: "Contents",
|
|
a6: "Team Leader Information",
|
|
a7: "Email(ID)",
|
|
a8: "Name",
|
|
a9: "Mobile",
|
|
a10: "Team member information",
|
|
a11: "Team members",
|
|
a12: "Email(ID)",
|
|
a13: "Name",
|
|
a14: "Mobile",
|
|
a15: "Change content",
|
|
a16: "Cancel an app",
|
|
a17: "List"
|
|
},
|
|
es_PE: {
|
|
a1: "Sistema",
|
|
a2: "Categoría",
|
|
a3: "Programa",
|
|
a4: "Artículo",
|
|
a5: "Contenido",
|
|
a6: "Información del líder del equipo",
|
|
a7: "Correo electrónico (ID)",
|
|
a8: "Nombre",
|
|
a9: "Móvil",
|
|
a10: "Información del miembro del equipo",
|
|
a11: "Miembros del equipo",
|
|
a12: "Correo electrónico (ID)",
|
|
a13: "Nombre",
|
|
a14: "Móvil",
|
|
a15: "Cambiar contenido",
|
|
a16: "Cancelar una aplicación",
|
|
a17: "Lista"
|
|
|
|
}
|
|
};
|
|
|
|
// 선택된 언어에 따라 다국어 텍스트 설정
|
|
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;
|
|
document.getElementById("a15").innerText = langData.a15;
|
|
|
|
document.getElementById("a16").innerText = langData.a16;
|
|
document.getElementById("a17").innerText = langData.a17;
|
|
|
|
|
|
|
|
}
|
|
</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"%>
|