279 lines
9.0 KiB
Plaintext
279 lines
9.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="/point/point_head.jsp"%>
|
|
<%@include file="/point/log_head.jsp"%>
|
|
<%
|
|
String c_team_no = r_call(request.getParameter("c_team_no"));
|
|
int c_ok = 0;
|
|
String c_value = "0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0";
|
|
int c_point = 0;
|
|
String c_content = "";
|
|
String sql_re = "select * from tbl_point_result where c_point_project_no = "+ c_point_project_no +" and c_team_no = "+ c_team_no +" and c_pointer_no = "+ session.getAttribute("pointer_no") +" ";
|
|
ResultSet rs_re = stmt.executeQuery(sql_re);
|
|
if (rs_re.next()) {
|
|
c_ok = rs_re.getInt("c_ok");
|
|
c_value = rs_re.getString("c_value");
|
|
c_point = rs_re.getInt("c_point");
|
|
c_content = rs_re.getString("c_content");
|
|
}
|
|
rs_re.close();
|
|
String[] a_value = c_value.split("[|]");
|
|
%>
|
|
<script>
|
|
function go_focus(flag){
|
|
if(flag == "c_id"){
|
|
document.kdb.c_id.focus()
|
|
}
|
|
}
|
|
function team_go(){
|
|
|
|
document.kdb.method = "get"
|
|
document.kdb.target = "_self"
|
|
document.kdb.action = "insert_go.jsp"
|
|
document.kdb.submit()
|
|
|
|
}
|
|
function go(){
|
|
|
|
document.kdb.method = "post"
|
|
document.kdb.target = "exec"
|
|
document.kdb.action = "insert_ok.jsp"
|
|
document.kdb.submit()
|
|
|
|
}
|
|
function go2(){
|
|
if(confirm("Es imposible editar una vez que se ha guardado por última vez. \n¿Desea guardar la última vez?")){
|
|
document.kdb.c_ok.value=1
|
|
document.kdb.method = "post"
|
|
document.kdb.target = "exec"
|
|
document.kdb.action = "insert_ok.jsp"
|
|
document.kdb.submit()
|
|
}
|
|
|
|
}
|
|
</script>
|
|
<form name="kdb">
|
|
<input name="c_ok" type="hidden" value="<%=c_ok%>">
|
|
<input name="c_point_project_no" type="hidden" value="<%=c_point_project_no%>">
|
|
|
|
<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" >· Procesamiento de evaluación</h4>
|
|
</div>
|
|
|
|
</div>
|
|
<div class="navi_text col-lg-6 col-md-6">
|
|
<div class="text-right" >
|
|
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<div class="col-lg-12 col-md-12" style="padding-bottom:10px">
|
|
<div class="col-lg-1 col-md-1" >
|
|
</div>
|
|
<div class="col-lg-10 col-md-10" >
|
|
<table width="50%" border="0" cellspacing="1" cellpadding="0" bgcolor=dddddd >
|
|
<tr height="20" bgcolor=ffffff>
|
|
<td colspan=2 width="25%" align=center style="font-weight:bold;" bgcolor=ededed> Nombre del proyecto</td>
|
|
<td width="75%" style="padding:5px">
|
|
<b> <%=rs_p.getString("p_name")%>
|
|
</td>
|
|
</tr>
|
|
<tr height="20" bgcolor=ffffff>
|
|
<td colspan=2 align=center style="font-weight:bold;" bgcolor=ededed> Nombre de la evaluación</td>
|
|
<td style="padding:5px">
|
|
<b><%=rs_p.getString("c_name")%>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<br>
|
|
<table width="100%" border="0" cellspacing="1" cellpadding="0" >
|
|
<tr bgcolor="efefef">
|
|
<td height=30 align=center>
|
|
Selección de equipo
|
|
</td>
|
|
<td align=center>
|
|
Jefe de equipo
|
|
</td>
|
|
<%if(c_part_name != null){%>
|
|
<td align=center><%=c_part_name%></td>
|
|
<%}%>
|
|
<td align=center>
|
|
Información
|
|
</td>
|
|
<td align=center>
|
|
Estado de evaluación
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td height=30 align=center>
|
|
<select name="c_team_no" style="height:24px" onchange="team_go()">
|
|
<%
|
|
String jang_name="";
|
|
String part_part="";
|
|
|
|
String sql_pt="select t.* from ( select a.*,b.c_team_name,c.c_name as jang_name ";
|
|
sql_pt = sql_pt +" ,( select "+ c_part_field +" from tbl_apply_team where c_no = b.c_no ) as part_part ";
|
|
sql_pt = sql_pt +" from tbl_point_target a ";
|
|
sql_pt = sql_pt +" inner join tbl_apply_team b on a.c_team_no = b.c_no ";
|
|
sql_pt = sql_pt +" inner join tbl_apply_team_member c on c.c_team_no = b.c_no and c.c_type = 1 ";
|
|
sql_pt = sql_pt +" where a.c_point_project_no = " + c_point_project_no + " and a.c_use = 0 ) t ";
|
|
if(c_part_name != null){
|
|
sql_pt = sql_pt +" where t.part_part = '"+ session.getAttribute("pointer_part") +"' ";
|
|
}
|
|
sql_pt = sql_pt +" order by t.part_part asc, t.c_team_name asc ";
|
|
ResultSet rs_pt = stmt.executeQuery(sql_pt);
|
|
while (rs_pt.next()) {
|
|
if(rs_pt.getString("c_team_no").equals(c_team_no)){
|
|
jang_name = rs_pt.getString("jang_name");
|
|
part_part = rs_pt.getString("part_part");
|
|
}
|
|
%>
|
|
<option value="<%=rs_pt.getInt("c_team_no")%>" <%if(rs_pt.getString("c_team_no").equals(c_team_no)){%>selected<%}%>><%=rs_pt.getString("c_team_name")%></option>
|
|
<%}
|
|
rs_pt.close();
|
|
%>
|
|
</select>
|
|
</td>
|
|
<td align=center>
|
|
<%=jang_name%>
|
|
</td>
|
|
<%if(c_part_name != null){%>
|
|
<td align=center >
|
|
<%=part_part%>
|
|
</td>
|
|
<%}%>
|
|
<td align=center>
|
|
<a href="view_team.jsp?c_team_no=<%=c_team_no%>&c_project_no=<%=c_project_no%>" target="_blank">[Ver información]</a>
|
|
</td>
|
|
<td align=center>
|
|
<%if(c_ok ==0){%>
|
|
Proceder
|
|
<%}else{%>
|
|
completo
|
|
<%}%>
|
|
</td>
|
|
</tr>
|
|
<tr><td colspan=8 height=1 bgcolor=cdcdcd></td></tr>
|
|
</table>
|
|
|
|
<br>
|
|
<table width="100%" border="0" cellspacing="1" cellpadding="0" >
|
|
<tr bgcolor=ededed style="font-weight:bold;">
|
|
<td height=30 align=center colspan=2>Artículo</td>
|
|
<td align=center>Nota</td>
|
|
<td width="80" align=center>puntos</td>
|
|
</tr>
|
|
<tr><td colspan=8 height=1 bgcolor=cdcdcd></td></tr>
|
|
<%
|
|
int total_point = 0;
|
|
int o_no = 0;
|
|
int o_order = 0;
|
|
int o_no2 = 0;
|
|
int o_order2 = 0;
|
|
int get_point = 0;
|
|
String sql1=" SELECT a.*,(select count(c_no) from tbl_point_ji_detail where c_up_no = a.c_no and c_use=0 ) as down_no from tbl_point_ji_detail a where a.c_ji_no = " + rs_p.getInt("c_ji_no") + " and a.c_up_no = 0 and a.c_use=0 order by a.c_order asc";
|
|
ResultSet rst = stmt.executeQuery(sql1);
|
|
int i_no = 0;
|
|
int i_no3 = -1;
|
|
|
|
while (rst.next()) {
|
|
i_no = i_no + 1;
|
|
%>
|
|
<tr bgcolor=ffffff height=30>
|
|
<td width=150 align=center rowspan="<%=rst.getInt("down_no") * 2 - 1%>" bgcolor="efefef">
|
|
<b><%=rst.getString("c_title")%>
|
|
</td>
|
|
<%
|
|
|
|
o_no2 = 0;
|
|
o_order2 = 0;
|
|
|
|
String sql12=" SELECT * from tbl_point_ji_detail where c_ji_no = " + rs_p.getInt("c_ji_no") + " and c_up_no = "+ rst.getInt("c_no") +" and c_use=0 order by c_order asc";
|
|
ResultSet rst2 = stmt.executeQuery(sql12);
|
|
int i_no2 = 0;
|
|
|
|
while (rst2.next()) {
|
|
total_point = total_point + rst2.getInt("c_point");
|
|
i_no2 = i_no2 + 1;
|
|
i_no3 = i_no3 + 1;
|
|
get_point = get_point + Integer.parseInt(a_value[i_no3]);
|
|
%>
|
|
<%if(i_no2 > 1){%>
|
|
<tr bgcolor=ffffff height=30 >
|
|
<%}%>
|
|
|
|
<td height="30px" width=150 align=center style="font-weight:bold;padding-left:10px">
|
|
<%=rst2.getString("c_title")%>
|
|
</td>
|
|
<td align=left style="padding:5px;line-height:130%">
|
|
<%=rst2.getString("c_exp").replaceAll("\r","<br />").replaceAll("\n\r","<br />")%>
|
|
</td>
|
|
<td align=center style=" padding:10px">
|
|
<select style="height:22px" name="p1">
|
|
<%for(int pp=0;pp < rst2.getInt("c_point") + 1;pp++){%>
|
|
<option <%if(Integer.parseInt(a_value[i_no3]) == pp){%>selected<%}%>><%=pp%></option>
|
|
<%}%>
|
|
</select>
|
|
</td>
|
|
|
|
</tr>
|
|
<tr><td colspan=8 height=1 bgcolor=cdcdcd></td></tr>
|
|
|
|
|
|
<% o_no2 = rst2.getInt("c_no");
|
|
o_order2 = rst2.getInt("c_order");
|
|
}
|
|
rst2.close();
|
|
%>
|
|
|
|
<%
|
|
}
|
|
if(i_no == 0){
|
|
%>
|
|
|
|
<% }
|
|
rst.close();
|
|
%>
|
|
<tr><td colspan=8 height=1 bgcolor=cdcdcd></td></tr>
|
|
<tr bgcolor=ffffff><td height=30 colspan=3 align=center style="padding-right:10px">
|
|
<b>Puntaje total
|
|
</td>
|
|
<td align=center bgcolor="efefef">
|
|
<b><%=get_point%> puntos
|
|
</td>
|
|
<tr><td colspan=8 height=1 bgcolor=cdcdcd></td></tr>
|
|
<tr><td colspan=8 height=30 >
|
|
<b>Opinión
|
|
</td></tr>
|
|
<tr><td colspan=8 >
|
|
<textarea name="c_content" style="width:100%;height:200px"><%=c_content%></textarea>
|
|
</td></tr>
|
|
|
|
</table>
|
|
<br>
|
|
<table width="100%" cellSpacing="1" cellPadding="0" border="0" bgcolor=ffffff>
|
|
<tr bgcolor=ffffff><td height="40" align=center style="padding:5px">
|
|
<%if(c_ok == 0){%>
|
|
<a href="#none" onclick="go()" style="width: 160px; line-height: 26px; text-align: center;display: inline-block; background: blue; border: 1px solid #555; border-radius: 5px; color: #ffffff;">almacenamiento temporal</a>
|
|
<a href="#none" onclick="go2()" style="width: 120px; line-height: 26px; text-align: center;display: inline-block; background: red; border: 1px solid #555; border-radius: 5px; color: #ffffff;">Guardado final</a>
|
|
<%}%>
|
|
<a href="insert.jsp" style="width: 80px; line-height: 26px; text-align: center;display: inline-block; background:#989898; border: 1px solid #555; border-radius: 5px; color: #ffffff;">lista</a>
|
|
|
|
</td></tr>
|
|
</table>
|
|
<br>
|
|
</div>
|
|
<div class="col-lg-1 col-md-1" >
|
|
</div>
|
|
</div>
|
|
</form>
|
|
<iframe name="exec" src="" width=0 height=0></iframe>
|
|
<%@include file="/point/log_bottom.jsp"%>
|
|
<%@include file="/point/point_bottom.jsp"%>
|
|
<%@include file="/include/bottom.jsp"%>
|
|
<%@include file="/include/include_b.jsp"%>
|