<%for(int i = 1; i<10 ; i++){%> <%if(i==1 || i==6 || i==8){%> <%}%> <%if(i==5 || i==7 || i==9){%> <%}%> <%}%> width="20%"<%}%> <%if(i==8 || i==9){%> width="50%" colspan=3<%}%> <%if(i==1 || i==3 || i==5){%>rowspan=2<%}%> <%if(i==3){%>colspan=2<%}%>> <%=hy_title[c_channel]%>Period Detail

<%for (int i = 1; i < c_p_p + 1; i++){%> <%}%>

<%if( i == today_period ){%> <%}%> <%if( i > today_period ){%> <%}%> <%=i%> Period <%if( i <= today_period ){%> <% String sql_hypo = " select a.*, b.c_name as writer_name "; sql_hypo = sql_hypo + ", (select count(c.c_no) as 2count from tbl_interview_point c inner join tbl_interview d on d.c_no = c.c_interview_no and d.c_use = 0 where c.c_hypo_no = a.c_no and c_point= 2 and d.c_date <= '"+ a_w_e[i] + " 23:59:59" +"') as 2count"; sql_hypo = sql_hypo + ", (select count(c.c_no) as 1count from tbl_interview_point c inner join tbl_interview d on d.c_no = c.c_interview_no and d.c_use = 0 where c.c_hypo_no = a.c_no and c_point= 1 and d.c_date <= '"+ a_w_e[i] + " 23:59:59" +"') as 1count"; sql_hypo = sql_hypo + ", (select count(c.c_no) as 0count from tbl_interview_point c inner join tbl_interview d on d.c_no = c.c_interview_no and d.c_use = 0 where c.c_hypo_no = a.c_no and c_point= 0 and d.c_date <= '"+ a_w_e[i] + " 23:59:59" +"') as 0count"; sql_hypo = sql_hypo + ", (select max(e.c_no) from tbl_hypo_history e where e.c_hypo_no = a.c_no and e.c_date <= '"+ a_w_e[i] + " 23:59:59" +"' ) as c_last_now "; sql_hypo = sql_hypo + " from tbl_hypo a "; sql_hypo = sql_hypo + " inner join tbl_member b on b.c_no = a.c_member_no "; sql_hypo = sql_hypo + " where (a.c_use = 0 or ( a.c_use = 1 and a.c_use_date > '"+ a_w_e[i] + " 23:59:59" +"' ) ) and a.c_team_no = "+ c_team +" and a.c_channel = "+ c_channel +" and a.c_date <= '"+ a_w_e[i] + " 23:59:59" +"' "; sql_hypo = sql_hypo + " order by a.c_no desc"; ResultSet rs_hypo = stmt2.executeQuery(sql_hypo); while(rs_hypo.next()){ %> <% int now_call = 0; String sql_hypo_history = " select c_now from tbl_hypo_history where c_no = " + rs_hypo.getInt("c_last_now") + " "; ResultSet rs_hypo_history = stmt.executeQuery(sql_hypo_history); if(rs_hypo_history.next()){ now_call = rs_hypo_history.getInt("c_now"); } rs_hypo_history.close(); %> _<%=i%>').style.display='block'" onmouseout="document.getElementById('hypo_<%=rs_hypo.getString("c_no")%>_<%=i%>').style.display='none'"> _<%=i%>" style="display:none;"> <%if(now_call == 2){%> &c_channel=<%=i%>"><%=rs_hypo.getString("c_title")%> <%}else{%> &c_channel=<%=i%>"><%=rs_hypo.getString("c_title")%> <%}%> <%if(now_call == 0){%> <%}%> <%if(now_call == 1){%> <%}%> <%if(now_call == 2){%> <%}%> <%=rs_hypo.getString("c_date").substring(0,10)%> / <%=rs_hypo.getString("writer_name")%> <%=rs_hypo.getInt("2count")%>    <%=rs_hypo.getInt("1count")%>    <%=rs_hypo.getInt("0count")%> <% if(c_channel==5){ %> ">■ <% }else{%> <% String sql_hypo_cs = " select c_cs_color from tbl_hypo_cs where c_hypo_no = " + rs_hypo.getInt("c_no") + " order by c_no desc"; ResultSet rs_hypo_cs = stmt.executeQuery(sql_hypo_cs); while(rs_hypo_cs.next()){ %> ">■ <%} rs_hypo_cs.close(); %> <%}%> <% } rs_hypo.close(); %> <%}%>

• Hypothesis
• Interview
• Comment

<% String sql_hypo = " select a.*, b.c_name as writer_name "; sql_hypo = sql_hypo + ", (select count(c.c_no) as 2count from tbl_interview_point c inner join tbl_interview d on d.c_no = c.c_interview_no and d.c_use = 0 where c.c_hypo_no = a.c_no and c_point= 2 and d.c_date <= '"+ call_date + " 23:59:59" +"') as 2count"; sql_hypo = sql_hypo + ", (select count(c.c_no) as 1count from tbl_interview_point c inner join tbl_interview d on d.c_no = c.c_interview_no and d.c_use = 0 where c.c_hypo_no = a.c_no and c_point= 1 and d.c_date <= '"+ call_date + " 23:59:59" +"') as 1count"; sql_hypo = sql_hypo + ", (select count(c.c_no) as 0count from tbl_interview_point c inner join tbl_interview d on d.c_no = c.c_interview_no and d.c_use = 0 where c.c_hypo_no = a.c_no and c_point= 0 and d.c_date <= '"+ call_date + " 23:59:59" +"') as 0count"; sql_hypo = sql_hypo + ", (select max(e.c_no) from tbl_hypo_history e where e.c_hypo_no = a.c_no and e.c_date <= '"+ call_date + " 23:59:59" +"' ) as c_last_now "; sql_hypo = sql_hypo + " from tbl_hypo a "; sql_hypo = sql_hypo + " inner join tbl_member b on b.c_no = a.c_member_no "; sql_hypo = sql_hypo + " where a.c_channel = "+ c_channel +" and (a.c_use = 0 or ( a.c_use = 1 and a.c_use_date > '"+ call_date + " 23:59:59" +"' ) ) and a.c_team_no = "+ c_team +" and a.c_date <= '"+ call_date + " 23:59:59" +"' "; sql_hypo = sql_hypo + " order by a.c_no desc"; ResultSet rs_hypo = stmt2.executeQuery(sql_hypo); while(rs_hypo.next()){ %> <% int now_call = 0; String sql_hypo_history = " select c_now from tbl_hypo_history where c_no = " + rs_hypo.getInt("c_last_now") + " "; ResultSet rs_hypo_history = stmt.executeQuery(sql_hypo_history); if(rs_hypo_history.next()){ now_call = rs_hypo_history.getInt("c_now"); } rs_hypo_history.close(); %> <%} rs_hypo.close(); %>

Title	Channel	Validation	Customer Segment	Insert Date	Period
"><%=rs_hypo.getString("c_title")%>	<% int c_chan_no = rs_hypo.getInt("c_channel"); %> <%=hy_title[c_chan_no]%>	<%if(now_call == 0){%> Ing.. <%}%> <%if(now_call == 1){%> Validated <%}%> <%if(now_call == 2){%> Invalidated <%}%>	<% if(rs_hypo.getInt("c_channel") == 5 ){ %> ">■ <% }else{%> <% String sql_hypo_cs = " select c_cs_color from tbl_hypo_cs where c_hypo_no = " + rs_hypo.getInt("c_no") + " order by c_no desc"; ResultSet rs_hypo_cs = stmt.executeQuery(sql_hypo_cs); while(rs_hypo_cs.next()){ %> ">■ <%} rs_hypo_cs.close(); %> <%}%>	<%=rs_hypo.getString("c_date").substring(0,10)%>	<%for (int i = 1; i < c_p_p + 1; i++){%> <%if(Integer.parseInt(a_w_s[i].replaceAll("-","")) <= Integer.parseInt(rs_hypo.getString("c_date").substring(0,10).replaceAll("-","")) && Integer.parseInt(a_w_e[i].replaceAll("-","")) >= Integer.parseInt(rs_hypo.getString("c_date").substring(0,10).replaceAll("-","")) ){ %> <%if(today_period == i){%> <%}%> <%=i%>P <% }%> <%}%>

<% sql_hypo = " select a.* , c.c_title as hypo_title, c.c_no as hypo_no "; sql_hypo = sql_hypo + " from tbl_interview a "; sql_hypo = sql_hypo + " inner join tbl_interview_point b on b.c_interview_no = a.c_no "; sql_hypo = sql_hypo + " inner join tbl_hypo c on c.c_no = b.c_hypo_no and c.c_channel = " + c_channel + " "; sql_hypo = sql_hypo + " where a.c_use = 0 and a.c_team_no = "+ c_team +" and a.c_date <= '"+ call_date + " 23:59:59" +"' "; sql_hypo = sql_hypo + " order by a.c_no desc"; rs_hypo = stmt2.executeQuery(sql_hypo); while(rs_hypo.next()){ %> <%} rs_hypo.close(); %>

Whom	Type	Interview Date	Hypothesiis	Period
" title="View Interview Information"> <% String sql_hypo_history = " select * from tbl_interview_target where c_interview_no = " + rs_hypo.getInt("c_no") + " "; ResultSet rs_hypo_history = stmt.executeQuery(sql_hypo_history); int top = 0; while(rs_hypo_history.next()){ top = top + 1; %> <%if(top > 1){%>  /  <%}%> <%=rs_hypo_history.getString("c_company")%>, <%=rs_hypo_history.getString("c_position")%>, <%=rs_hypo_history.getString("c_name")%> <% } rs_hypo_history.close(); %>	<%if(rs_hypo.getInt("c_type") == 0){%> In Person <%}%> <%if(rs_hypo.getInt("c_type") == 1){%> Phone <%}%> <%if(rs_hypo.getInt("c_type") == 2){%> Email <%}%> <%if(rs_hypo.getInt("c_type") == 3){%> Video Chat <%}%>	<%=rs_hypo.getString("c_interview_date").substring(0,10)%>	" title="Hypothesis View information"> <%=rs_hypo.getString("hypo_title")%>	<%for (int i = 1; i < c_p_p + 1; i++){%> <%if(Integer.parseInt(a_w_s[i].replaceAll("-","")) <= Integer.parseInt(rs_hypo.getString("c_date").substring(0,10).replaceAll("-","")) && Integer.parseInt(a_w_e[i].replaceAll("-","")) >= Integer.parseInt(rs_hypo.getString("c_date").substring(0,10).replaceAll("-","")) ){ %> <%if(today_period == i){%> <%}%> <%=i%>P <% }%> <%}%>

<% sql_hypo = " select a.* "; sql_hypo = sql_hypo + " from tbl_comment a "; sql_hypo = sql_hypo + " inner join tbl_hypo b on b.c_no = a.c_relation and b.c_channel = "+ c_channel +" "; sql_hypo = sql_hypo + " where a.c_type = 0 and a.c_use = 0 and a.c_team_no = "+ c_team +" and a.c_date <= '"+ call_date + " 23:59:59" +"' "; sql_hypo = sql_hypo + " order by a.c_no desc"; rs_hypo = stmt2.executeQuery(sql_hypo); while(rs_hypo.next()){ %> <%} rs_hypo.close(); %>

Content	Target Type	Writer Type	Insert Date	Period
<%if(rs_hypo.getInt("c_type") == 0){%> " title="Go to related hypothesis"> <%}%> <%if(rs_hypo.getInt("c_type") == 1){%> " title="Go to related interview"> <%}%> <%=rs_hypo.getString("c_content")%>	<%if(rs_hypo.getInt("c_type") == 0){%> Hypothesis <%}%> <%if(rs_hypo.getInt("c_type") == 1){%> Interview <%}%>	<%if(rs_hypo.getInt("c_member_type") == 0){%> Member <%}%> <%if(rs_hypo.getInt("c_member_type") == 1){%> Instructor <%}%> <%if(rs_hypo.getInt("c_member_type") == 2){%> Mentor <%}%>	<%=rs_hypo.getString("c_date").substring(0,10)%>	<%for (int i = 1; i < c_p_p + 1; i++){%> <%if(Integer.parseInt(a_w_s[i].replaceAll("-","")) <= Integer.parseInt(rs_hypo.getString("c_date").substring(0,10).replaceAll("-","")) && Integer.parseInt(a_w_e[i].replaceAll("-","")) >= Integer.parseInt(rs_hypo.getString("c_date").substring(0,10).replaceAll("-","")) ){ %> <%if(today_period == i){%> <%}%> <%=i%>P <% }%> <%}%>