Presentations
<%if(session.getAttribute("member_type").equals("1") || session.getAttribute("member_type").equals("2")){%>
+
<%}%>
<%
String s_p_team = r_call(request.getParameter("c_p_team"));
String c_presentation_name = "";
int c_p_team = 0;
if(!s_p_team.equals("")){
c_p_team = Integer.parseInt(s_p_team);
}
String s_presentation_no = r_call(request.getParameter("c_presentation_no"));
int c_presentation_no = 0;
if(!s_presentation_no.equals("")){
c_presentation_no = Integer.parseInt(s_presentation_no);
}
String check_project = "";
String sql_p = "select * from tbl_presentation where c_project_no = " + session.getAttribute("member_project_no") + " and c_use = 0 order by c_no desc ";
ResultSet rs_p = stmt2.executeQuery(sql_p);
int pt_count = 0;
while(rs_p.next()){
pt_count = pt_count + 1;
if(pt_count == 1 && c_presentation_no == 0){
c_presentation_no = rs_p.getInt("c_no");
}
if(c_presentation_no == rs_p.getInt("c_no")){
check_project = rs_p.getString("c_project_no");
c_presentation_name = rs_p.getString("c_name") + " / " + rs_p.getString("c_presentation_date");
}
%>
<% if(check_project.equals("")){%>
<%}else{%>
<%if(!check_project.equals(session.getAttribute("member_project_no"))){%>
<%}%>
<%}%>
| " title="Presentation 이동"> <%=rs_p.getString("c_name")%> / <%=rs_p.getString("c_presentation_date")%> |
<%if(session.getAttribute("member_type").equals("1") || session.getAttribute("member_type").equals("2")){%>
" title="Presentation Edit">
<%}%>
)">
▼
|
| " style="display:<%if(c_presentation_no == rs_p.getInt("c_no")){%><%}else{%>none<%}%>;padding-bottom:10px;padding-left:10px;padding-top:5px;line-height:200%">
<%
String sql_p_t = "select a.c_no, b.c_team_name,a.c_team_no from tbl_presentation_team a ";
sql_p_t = sql_p_t + " inner join tbl_team b on b.c_no = a.c_team_no ";
sql_p_t = sql_p_t + " where a.c_presentation_no = " + rs_p.getInt("c_no") + " and a.c_use = 0 order by b.c_team_name asc, a.c_no desc ";
ResultSet rs_p_t = stmt2.executeQuery(sql_p_t);
while(rs_p_t.next()){
%>
&c_presentation_no=<%=rs_p.getInt("c_no")%>">
<%if(c_p_team == rs_p_t.getInt("c_no")){%>
<%=rs_p_t.getString("c_team_name")%>
<%}else{%>
<%=rs_p_t.getString("c_team_name")%>
<%}%>
<%if(session.getAttribute("member_type").equals("0") && session.getAttribute("member_team_no").equals(rs_p_t.getString("c_team_no"))){%>
&c_presentation_no=<%=rs_p.getInt("c_no")%>" title="Team Presentation Edit">
<%}%>
<% } rs_p_t.close(); %> |
|