<%=rs_pre.getString("c_team_name")%> <

<%=c_presentation_name%>

<%if(session.getAttribute("member_type").equals("0") && session.getAttribute("member_team_no").equals(rs_pre.getString("c_team_no"))){%>

EDIT <%}%>

Presentation Link or File

<%if(!rs_pre.getString("c_link").equals("")){%>
Link : " target="_blank"> <%=rs_pre.getString("c_link")%> <%}%> <%if(!rs_pre.getString("c_file").equals("")){%>

File : " target="_blank"> <%=rs_pre.getString("c_file")%> <%}%>

<% int pt_rate = 100 / pt_count; %> <%if(session.getAttribute("member_type").equals("0") || session.getAttribute("member_type").equals("1") || session.getAttribute("member_type").equals("2")|| session.getAttribute("member_type").equals("3") || ( session.getAttribute("member_type").equals("0") && session.getAttribute("member_team_no").equals(rs_pre.getString("c_team_no")) ) ){%> <% String tab_go[] = new String[4]; tab_go[1] = "1"; tab_go[2] = "2"; tab_go[3] = "0"; %> <%if(session.getAttribute("member_type").equals("0") || session.getAttribute("member_type").equals("1") || session.getAttribute("member_type").equals("2")|| session.getAttribute("member_type").equals("3") ){%>

Point History

<% for(int tab_no = 1;tab_no <4;tab_no++){%>

<% String p_name[] = new String[20]; String sql_pre2 = " select a.* "; sql_pre2 = sql_pre2 + ", (select avg(c_point) from tbl_comment where c_type = 2 and c_relation = b.c_no and c_use = 0 and c_member_type = "+ tab_go[tab_no] +" and c_point > 0 ) as m_avg "; sql_pre2 = sql_pre2 + " from tbl_presentation a "; sql_pre2 = sql_pre2 + " inner join tbl_presentation_team b on b.c_presentation_no = a.c_no and b.c_use = 0 and c_team_no = " + rs_pre.getInt("c_team_no"); sql_pre2 = sql_pre2 + " where a.c_use = 0 and a.c_project_no = " + session.getAttribute("member_project_no"); sql_pre2 = sql_pre2 + " order by a.c_no asc"; ResultSet rs_pre2 = stmt2.executeQuery(sql_pre2); int ppl = 0; while(rs_pre2.next()){ ppl = ppl + 1; p_name[ppl] = rs_pre2.getString("c_name"); %> <%} rs_pre2.close(); %>

<%=rs_pre2.getFloat("m_avg")%>

px" bgcolor=<%if(c_presentation_no == rs_pre2.getInt("c_no")){%>#FFF585<%}else{%>#cdcdcd<%}%>>

<% for(int typ = 1; typ < ppl + 1;typ++){%> <%}%>

<%=p_name[typ]%>

<%}%>

Comment & point <%if(session.getAttribute("member_type").equals("1") || session.getAttribute("member_type").equals("3") ){%> <%}%>

class="active"<%}%>>Instructor
class="active"<%}%>>Mentor
class="active"<%}%>>Member in Project

<%// int tab_no = 1; %> <%for(int tab_no = 1; tab_no<4;tab_no++) {%>

in active<%}%>" id="iinfo0<%=tab_no%>">

<%if( session.getAttribute("member_type").equals(tab_go[tab_no] ) ){%> <% String last_sql = " select c_content, c_point, c_no from tbl_comment "; last_sql = last_sql + " where c_point > 0 and c_project_no = " + session.getAttribute("member_project_no") + " "; last_sql = last_sql + " and c_pt_no = " + c_presentation_no + " "; last_sql = last_sql + " and c_team_no = " + rs_pre.getInt("c_team_no") + " "; last_sql = last_sql + " and c_type = 2 "; last_sql = last_sql + " and c_relation = " + c_p_team + " "; last_sql = last_sql + " and c_member_no = " + session.getAttribute("member_no") + " "; last_sql = last_sql + " and c_member_type = " + session.getAttribute("member_type") + " "; last_sql = last_sql + " and c_use=0 "; ResultSet rs_last = stmt.executeQuery(last_sql); if(rs_last.next()){ %>

" type="hidden">

* Point & Comment <% String sql_in = "select c_photo from tbl_member where c_no = " + session.getAttribute("member_no"); ResultSet rs_in = stmt.executeQuery(sql_in); if(rs_in.next()){ %> <% } rs_in.close(); %>

<%if(!rs_in.getString("c_photo").equals("")){%> " width="50" height=50 style="border: 1px solid #ededed;border-radius: 50px; "> <%}%>	<%=rs_last.getString("c_content")%>
	Point : Edit

<% }else{ %>

" type="hidden">

<%if(!rs_in.getString("c_photo").equals("")){%> " width="50" height=50 style="border: 1px solid #ededed;border-radius: 50px; "> <%}%>
	Point : Insert

<%}%> <%}%> <%if(session.getAttribute("member_type").equals("1") || session.getAttribute("member_type").equals("3") ){%>

" type="hidden">

* General Comment <% String sql_in = "select c_photo from tbl_member where c_no = " + session.getAttribute("member_no"); ResultSet rs_in = stmt.executeQuery(sql_in); if(rs_in.next()){ %> <% } rs_in.close(); %>

<%if(!rs_in.getString("c_photo").equals("")){%> " width="50" height=50 style="border: 1px solid #ededed;border-radius: 50px; "> <%}%>
	Insert

<%}%>

<% String sql_comment = " select a.c_content, a.c_date, b.c_photo, b.c_name, a.c_member_type, a.c_point,a.c_member_no from tbl_comment a "; sql_comment = sql_comment + " inner join tbl_member b on b.c_no = a.c_member_no "; sql_comment = sql_comment + " where a.c_type= 2 and a.c_relation = " + c_p_team + " and a.c_member_type= "+ tab_go[tab_no] +" order by a.c_no desc "; ResultSet rs_comment = stmt.executeQuery(sql_comment); while(rs_comment.next()){ %> <% } rs_comment.close(); %>

<%if(!rs_comment.getString("c_photo").equals("")){%> " width="50" height=50 style="border: 1px solid #ededed;border-radius: 50px; "> <%}%>	bgcolor="#FFFBCB"<%}%>> <%=rs_comment.getString("c_name")%>[ <%if(rs_comment.getInt("c_member_type") ==0){%> Team Member <%}%> <%if(rs_comment.getInt("c_member_type") ==1){%> Instructor <%}%> <%if(rs_comment.getInt("c_member_type") ==2){%> Mentor <%}%> ] / <%=rs_comment.getString("c_date")%> <%if(session.getAttribute("member_type").equals("1") \|\| session.getAttribute("member_type").equals("3") ){%> <%if(rs_comment.getInt("c_point") >0){%> / point : 11 <%=rs_comment.getInt("c_point")%> <%}%> <%}%>
	bgcolor="#FFFBCB"<%}%>> <%=rs_comment.getString("c_content").replaceAll("\r\n"," ")%>

<%}%>

Team List