115 lines
4.1 KiB
Plaintext
115 lines
4.1 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"%>
|
|
|
|
<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" >· Consulte la lista de objetivos para la 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")%> / <%=session.getAttribute("pointer_part")%>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<br>
|
|
<table width="100%" cellSpacing="1" cellPadding="0" border="0" bgcolor=cdcdcd>
|
|
<tr bgcolor=ededed style="font-weight:bold;">
|
|
<td height=30 width="40" align=center>No</td>
|
|
<td align=center>Nombre del equipo</td>
|
|
<%if(c_part_name != null){%>
|
|
<td width="150" align=center><%=c_part_name%></td>
|
|
<%}%>
|
|
<td width="100" align=center>Jefe de equipo</td>
|
|
<td width="120" align=center>Ver información</td>
|
|
<td width="80" align=center>evaluación</td>
|
|
</tr>
|
|
<%
|
|
|
|
|
|
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);
|
|
int i_no = 0;
|
|
while (rs_pt.next()) {
|
|
i_no = i_no + 1;
|
|
%>
|
|
<tr bgcolor=ffffff onMouseover="this.bgColor='#FFF669'" onMouseout="this.bgColor='#FFFFFF'">
|
|
<td height="30px" align=center bgcolor=ffffff>
|
|
<%=i_no%>
|
|
</td>
|
|
<td align=center bgcolor=ffffff>
|
|
<a href="view_team.jsp?c_team_no=<%=rs_pt.getString("c_team_no")%>&c_project_no=<%=c_project_no%>" target="_blank"><%=rs_pt.getString("c_team_name")%></a>
|
|
</td>
|
|
<%if(c_part_name != null){%>
|
|
<td align=center bgcolor=ffffff>
|
|
<%=rs_pt.getString("part_part")%>
|
|
</td>
|
|
<%}%>
|
|
<td align=center bgcolor=ffffff>
|
|
<%=rs_pt.getString("jang_name")%>
|
|
</td>
|
|
<td align=center bgcolor=ffffff>
|
|
<a href="view_team.jsp?c_team_no=<%=rs_pt.getString("c_team_no")%>&c_project_no=<%=c_project_no%>" target="_blank">[Ver información]</a>
|
|
</td>
|
|
<td align=center bgcolor=ffffff>
|
|
<a href="insert_go.jsp?c_team_no=<%=rs_pt.getString("c_team_no")%>" >[Evaluar]</a>
|
|
</td>
|
|
</tr>
|
|
<tr height=1><td colspan=12 bgcolor=cdcdcd></td></tr>
|
|
<!------------------project----------------------------------->
|
|
|
|
<%
|
|
}
|
|
if(i_no == 0){
|
|
%>
|
|
|
|
<% }
|
|
rs_pt.close();
|
|
%>
|
|
</table>
|
|
<br>
|
|
<br>
|
|
<br>
|
|
</div>
|
|
<div class="col-lg-1 col-md-1" >
|
|
</div>
|
|
</div>
|
|
|
|
<%@include file="/point/log_bottom.jsp"%>
|
|
<%@include file="/point/point_bottom.jsp"%>
|
|
<%@include file="/include/bottom.jsp"%>
|
|
<%@include file="/include/include_b.jsp"%>
|