Nombre del proyecto		<%=rs_p.getString("p_name")%>
Nombre de la evaluación		<%=rs_p.getString("c_name")%>

<%if(c_part_name != null){%> <%}%> <%if(c_part_name != null){%> <%}%>

Selección de equipo	Jefe de equipo	<%=c_part_name%>	Información	Estado de evaluación
<% 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"); } %> " <%if(rs_pt.getString("c_team_no").equals(c_team_no)){%>selected<%}%>><%=rs_pt.getString("c_team_name")%> <%} rs_pt.close(); %>	<%=jang_name%>	<%=part_part%>	[Ver información]	<%if(c_ok ==0){%> Proceder <%}else{%> completo <%}%>

<% 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; %> <% 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){%> <%}%> <% o_no2 = rst2.getInt("c_no"); o_order2 = rst2.getInt("c_order"); } rst2.close(); %> <% } if(i_no == 0){ %> <% } rst.close(); %>

Artículo		Nota	puntos
" bgcolor="efefef"> <%=rst.getString("c_title")%>
<%=rst2.getString("c_title")%>	<%=rst2.getString("c_exp").replaceAll("\r"," ").replaceAll("\n\r"," ")%>	<%for(int pp=0;pp < rst2.getInt("c_point") + 1;pp++){%> selected<%}%>><%=pp%> <%}%>
Puntaje total			<%=get_point%> puntos
Opinión
<%=c_content%>

<%if(c_ok == 0){%> almacenamiento temporal Guardado final <%}%> lista