<%@ page contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%
if(login_tag == 1 && (session.getAttribute("member_no") == null || session.getAttribute("member_no").equals(""))){
%>
<%}else{
if(login_tag == 0 && (session.getAttribute("member_project_no") == null || session.getAttribute("member_project_no").equals("") )){
session.setAttribute("member_project_no","0");
}
String visit_project_no = "" + session.getAttribute("member_project_no");
String visit_show_no = r_call(request.getParameter("show_no"));
if(visit_show_no.equals("")){
visit_show_no = "0";
}
String visit_c_no = "0";
int vod_no[] = new int[15];
vod_no[1] = 108;
vod_no[2] = 109;
vod_no[3] = 102;
vod_no[4] = 105;
vod_no[5] = 103;
vod_no[6] = 107;
vod_no[7] = 104;
vod_no[8] = 110;
vod_no[9] = 106;
vod_no[11] = 90;
vod_no[12] = 111;
vod_no[13] = 118;
String c_team = r_call(request.getParameter("c_team"));
String para_t = "";
para_t = "show_no="+ r_call(request.getParameter("show_no")) +"&check_no="+ r_call(request.getParameter("check_no")) + "&c_relation=" +r_call(request.getParameter("c_relation")) + "&c_relation2=" +r_call(request.getParameter("c_relation2"));
java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat("yyyy-MM-dd");
String today = formatter.format(new java.util.Date());
String c_p_s_d = today;
String c_p_e_d = today;
int c_p_p = 1;
String sql_period = " select c_bcb_s_date, c_bcb_e_date, c_bcb_period from tbl_project_plan where c_project_no = " + session.getAttribute("member_project_no");
ResultSet rs_period = stmt.executeQuery(sql_period);
if(rs_period.next()){
c_p_s_d = rs_period.getString("c_bcb_s_date").substring(0,10);
c_p_e_d = rs_period.getString("c_bcb_e_date").substring(0,10);
c_p_p = rs_period.getInt("c_bcb_period");
}
rs_period.close();
String a_w_s[] = new String[c_p_p + 1];
String a_w_e[] = new String[c_p_p + 1];
int opl = 0;
//--------------------------------------------------------------------------------
sql_period = " select * from tbl_project_plan_bcb_period where c_project_no = " + session.getAttribute("member_project_no") + " order by c_period_no asc ";
rs_period = stmt.executeQuery(sql_period);
while(rs_period.next()){
a_w_s[rs_period.getInt("c_period_no")] = rs_period.getString("c_s_date");
a_w_e[rs_period.getInt("c_period_no")] = rs_period.getString("c_e_date");
opl = 1;
}
rs_period.close();
//--------------------------------------------------------------------------------
if(opl == 0){
a_w_s[1] = today;
a_w_e[1] = today;
}
String s_call_period = r_call(request.getParameter("call_period"));
int call_period = 0;
int today_period = 1;
for (int i = 1; i < c_p_p + 1; i++){
if( ( Integer.parseInt(today.replaceAll("-","")) > Integer.parseInt(a_w_s[i].replaceAll("-","")) || Integer.parseInt(today.replaceAll("-","")) == Integer.parseInt(a_w_s[i].replaceAll("-","")) ) && ( Integer.parseInt(today.replaceAll("-","")) < Integer.parseInt(a_w_e[i].replaceAll("-","")) || Integer.parseInt(today.replaceAll("-","")) == Integer.parseInt(a_w_e[i].replaceAll("-","")) ) ){
today_period = i;
}
}
if( Integer.parseInt(today.replaceAll("-","")) > Integer.parseInt(a_w_e[c_p_p].replaceAll("-",""))){
today_period = c_p_p;
}
if(s_call_period.equals("")){
call_period = today_period;
}else{
call_period = Integer.parseInt(s_call_period);
}
String call_date = a_w_e[call_period];
int temp_state = 0;
%>
C-Innovacion BMC System