449 lines
20 KiB
Plaintext
449 lines
20 KiB
Plaintext
<%@ page contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
|
|
|
|
|
|
<%
|
|
if(login_tag == 1 && (session.getAttribute("member_no") == null || session.getAttribute("member_no").equals(""))){
|
|
%>
|
|
<script>
|
|
alert("Login Please.")
|
|
location.href="/cms_for_bcb/process/login/list.jsp?c_relation=23&c_relation2=32&show_no=2&check_no=1"
|
|
</script>
|
|
<%}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;
|
|
%>
|
|
<!DOCTYPE html>
|
|
<html lang="ko">
|
|
<head>
|
|
<meta charset="utf-8">
|
|
<meta http-equiv="X-UA-Compatible" content="IE=edge">
|
|
<meta name="keywords" content="" />
|
|
<meta name="description" content="" />
|
|
<meta name="author" content="" />
|
|
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1" />
|
|
<title>C-Innovacion BMC System</title>
|
|
<link rel="shortcut icon" href="" />
|
|
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Montserrat:300,300i,400,500,500i,600,700,800,900|Poppins:200,300,300i,400,400i,500,500i,600,600i,700,700i,800,800i,900">
|
|
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Dosis:300,400,500,600,700,800">
|
|
<link rel="stylesheet" href="http://fonts.googleapis.com/earlyaccess/nanumgothic.css">
|
|
<link href="https://fonts.googleapis.com/css?family=Noto+Sans" rel="stylesheet">
|
|
<link rel="stylesheet" type="text/css" href="/css/plugins-css.css" />
|
|
<link rel="stylesheet" type="text/css" href="/revolution/css/settings.css" media="screen" />
|
|
<link rel="stylesheet" type="text/css" href="/css/typography.css" />
|
|
<link rel="stylesheet" type="text/css" href="/css/shortcodes/shortcodes.css" />
|
|
<link rel="stylesheet" type="text/css" href="/css/style.css" />
|
|
<link rel="stylesheet" type="text/css" href="/css/custom.css" />
|
|
<link rel="stylesheet" type="text/css" href="/css/responsive.css" />
|
|
<link href="/js/cal_style.css" rel="stylesheet" type="text/css">
|
|
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
|
|
<script type="text/javascript" src="/js/calendar.js"></script>
|
|
<script type="text/javascript" src="/js/html2canvas.min.js"></script>
|
|
<script>
|
|
function my_reload(){
|
|
window.location.reload()
|
|
}
|
|
</script>
|
|
</head>
|
|
<body>
|
|
|
|
<div class="wrapper" >
|
|
|
|
<!--=================================
|
|
header -->
|
|
<script>
|
|
function photo_go(flag,flag2) {
|
|
//특정부분 스크린샷
|
|
html2canvas(document.getElementById(flag))
|
|
//id container 부분만 스크린샷
|
|
.then(function (canvas) {
|
|
//jpg 결과값
|
|
drawImg(canvas.toDataURL('image/jpeg'));
|
|
//이미지 저장
|
|
saveAs(canvas.toDataURL(), flag2);
|
|
}).catch(function (err) {
|
|
console.log(err);
|
|
});
|
|
}
|
|
|
|
function drawImg(imgData) {
|
|
console.log(imgData);
|
|
//imgData의 결과값을 console 로그롤 보실 수 있습니다.
|
|
return new Promise(function reslove() {
|
|
//내가 결과 값을 그릴 canvas 부분 설정
|
|
var canvas = document.getElementById('canvas');
|
|
var ctx = canvas.getContext('2d');
|
|
//canvas의 뿌려진 부분 초기화
|
|
ctx.clearRect(0, 0, canvas.width, canvas.height);
|
|
|
|
var imageObj = new Image();
|
|
imageObj.onload = function () {
|
|
ctx.drawImage(imageObj, 10, 10);
|
|
//canvas img를 그리겠다.
|
|
};
|
|
imageObj.src = imgData;
|
|
//그릴 image데이터를 넣어준다.
|
|
|
|
}, function reject() { });
|
|
|
|
}
|
|
function saveAs(uri, filename) {
|
|
var link = document.createElement('a');
|
|
if (typeof link.download === 'string') {
|
|
link.href = uri;
|
|
link.download = filename;
|
|
document.body.appendChild(link);
|
|
link.click();
|
|
document.body.removeChild(link);
|
|
} else {
|
|
window.open(uri);
|
|
}
|
|
}
|
|
function fnExcelReport(id,flag2) {
|
|
var data_type = 'data:application/vnd.ms-excel;charset=utf-8';
|
|
var table_html = encodeURIComponent(document.getElementById(id).outerHTML);
|
|
var a = document.createElement('a');
|
|
a.href = data_type + ',%EF%BB%BF' + table_html;
|
|
a.download = flag2+'.xls';
|
|
a.click();
|
|
}
|
|
</script>
|
|
|
|
<header class="header light">
|
|
<div class="topbar">
|
|
<div class="container" style='width:100%;background-image: linear-gradient(45deg, #9dc66b 5%, #4fa49a 30%, #4361c2);'>
|
|
<div class="row">
|
|
<div class="col-lg-6 col-md-6 col-sm-6">
|
|
<div class="topbar-left text-left">
|
|
<%if(session.getAttribute("member_no") == null || session.getAttribute("member_no").equals("")){%>
|
|
<p class="mt-10" style="color:#ffffff">
|
|
Use after login
|
|
</p>
|
|
<%}else{%>
|
|
<p class="mt-10" style="color:#ffffff">
|
|
<%
|
|
int s_count = 0;
|
|
String sql_ac = " select a.*,b.c_name as a3, c.c_name as a2,d.c_name as a1 ";
|
|
sql_ac = sql_ac + ",(select c_team_name from tbl_team where c_no = a.c_team_no and c_use = 0) as team_name ";
|
|
sql_ac = sql_ac + ",(select count(c_no) from tbl_pnm_for_bcb where c_member_no = " + session.getAttribute("member_no") + " and c_use = 0) as s_count ";
|
|
sql_ac = sql_ac + " from tbl_pnm_for_bcb a ";
|
|
sql_ac = sql_ac + " inner join tbl_project b on b.c_no = a.c_project_no and b.c_use = 0 ";
|
|
sql_ac = sql_ac + " inner join tbl_project c on c.c_no = b.c_up_no and c.c_use = 0 ";
|
|
sql_ac = sql_ac + " inner join tbl_field d on d.c_no = c.c_field and d.c_use = 0 ";
|
|
sql_ac = sql_ac + " where a.c_use = 0 and a.c_member_no = " + session.getAttribute("member_no") + " and a.c_no = " + session.getAttribute("member_pnm_no");
|
|
sql_ac = sql_ac + " ";
|
|
ResultSet rs_ac = stmt.executeQuery(sql_ac);
|
|
if(rs_ac.next()){
|
|
s_count = rs_ac.getInt("s_count");
|
|
%>
|
|
<%=rs_ac.getString("a1")%> > <%=rs_ac.getString("a2")%> > <%=rs_ac.getString("a3")%>
|
|
<%if(rs_ac.getString("team_name") != null && !rs_ac.getString("team_name").equals("")){%>
|
|
> <%=rs_ac.getString("team_name")%>
|
|
<%}%>
|
|
[
|
|
<%if(rs_ac.getInt("c_type") == 0){%>
|
|
<font color=yellow>Member</font>
|
|
<%}%>
|
|
<%if(rs_ac.getInt("c_type") == 1){%>
|
|
<font color=yellow>Instructor</font>
|
|
<%}%>
|
|
<%if(rs_ac.getInt("c_type") == 2){%>
|
|
<font color=yellow>Mentor</font>
|
|
<%}%>
|
|
<%if(rs_ac.getInt("c_type") == 3){%>
|
|
<font color=yellow>Observer</font>
|
|
<%}%>
|
|
]
|
|
<%
|
|
}
|
|
rs_ac.close();
|
|
%>
|
|
<a href="#none" style="color:yellow;font-size:10px" title="Change Account" onclick="document.getElementById('c_a').style.display = 'block';document.getElementById('c_pnm_no').focus(); " >▼</a>
|
|
</p>
|
|
<div id="c_a" style="z-index:9999;position: absolute; background:#ffffff;display:none">
|
|
<script>
|
|
function go_ac(flag){
|
|
if(confirm("Do you Change the Account?")){
|
|
location.href="/go_ac.jsp?c_pnm_no=" + flag;
|
|
}
|
|
}
|
|
</script>
|
|
<table cellpadding=0 cellspacing=0>
|
|
<tr><td>
|
|
<select name="c_pnm_no" id="c_pnm_no" size="<%=s_count%>" onchange="go_ac(this.value)">
|
|
<%
|
|
sql_ac = " select a.*,b.c_name as a3, c.c_name as a2,d.c_name as a1,(select c_team_name from tbl_team where c_no = a.c_team_no and c_use = 0) as team_name from tbl_pnm_for_bcb a ";
|
|
sql_ac = sql_ac + " inner join tbl_project b on b.c_no = a.c_project_no and b.c_use = 0 ";
|
|
sql_ac = sql_ac + " inner join tbl_project c on c.c_no = b.c_up_no and c.c_use = 0 ";
|
|
sql_ac = sql_ac + " inner join tbl_field d on d.c_no = c.c_field and d.c_use = 0 ";
|
|
sql_ac = sql_ac + " where a.c_use = 0 and a.c_member_no = " + session.getAttribute("member_no") + " ";
|
|
sql_ac = sql_ac + " order by d.c_no desc, c.c_no desc, b.c_no desc, a.c_type asc, a.c_no desc ";
|
|
rs_ac = stmt2.executeQuery(sql_ac);
|
|
while(rs_ac.next()){
|
|
%>
|
|
<option value="<%=rs_ac.getInt("c_no")%>">
|
|
<%=rs_ac.getString("a1")%> > <%=rs_ac.getString("a2")%> > <b><%=rs_ac.getString("a3")%></b>
|
|
<%if(rs_ac.getString("team_name") != null && !rs_ac.getString("team_name").equals("")){%>
|
|
> <%=rs_ac.getString("team_name")%>
|
|
<%}%>
|
|
[
|
|
<%if(rs_ac.getInt("c_type") == 0){%>
|
|
Member
|
|
<%}%>
|
|
<%if(rs_ac.getInt("c_type") == 1){%>
|
|
Instructor
|
|
<%}%>
|
|
<%if(rs_ac.getInt("c_type") == 2){%>
|
|
Mentor
|
|
<%}%>
|
|
<%if(rs_ac.getInt("c_type") == 3){%>
|
|
Observer
|
|
<%}%>
|
|
]
|
|
</option>
|
|
<%
|
|
}
|
|
rs_ac.close();
|
|
%>
|
|
</select>
|
|
</td><td valign=top>
|
|
|
|
<a href="#none" style="font-size:10px" title="Change Account" onclick="document.getElementById('c_a').style.display = 'none'" ><b>X</b></a>
|
|
</td></tr></table>
|
|
</div>
|
|
<%}%>
|
|
</div>
|
|
</div>
|
|
<div class="col-lg-6 col-md-6 col-sm-6">
|
|
<div class="topbar-right text-right">
|
|
<ul id="topbar-nav">
|
|
<!-- <li class="nav-item"><a href="/">Home</a></li>-->
|
|
<%
|
|
if(session.getAttribute("member_no") == null || session.getAttribute("member_no").equals("")){
|
|
|
|
%>
|
|
<li class="nav-item"><a href="/cms_for_bcb/process/login/list.jsp?show_no=2&check_no=1&c_relation=23&c_relation2=32" style="color:#ffffff">Login</a></li>
|
|
<%}else{%>
|
|
<li class="nav-item"><a href="/cms_for_bcb/process/member/list.jsp?show_no=3&check_no=1&c_relation=45&c_relation2=23" style="color:#ffffff"><%=session.getAttribute("member_name")%></a></li>
|
|
<li class="nav-item"><a href="/cms_for_bcb/process/login/logout_ok.jsp" style="color:#ffffff">Logout</a></li>
|
|
<%}%>
|
|
<li class="nav-item"><a href="/cms_for_bcb/process/member/list.jsp?show_no=3&check_no=1&c_relation=45&c_relation2=23" style="color:#ffffff">Membership</a></li>
|
|
</ul>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<!--=================================
|
|
mega menu -->
|
|
|
|
<div class="menu" style="height:50px; ">
|
|
<!-- menu start -->
|
|
<nav id="menu" class="mega-menu">
|
|
<!-- menu list items container -->
|
|
<section class="menu-list-items">
|
|
<div class="container" style="width:100%">
|
|
<div class="row">
|
|
<div class="col-lg-12 col-md-12" >
|
|
<!-- menu logo -->
|
|
<ul class="menu-logo">
|
|
<li >
|
|
<a href="/default.jsp" style="font-size:18px;color:#343434"> C-innovacion BMC System</a>
|
|
</li>
|
|
</ul>
|
|
<!-- menu links -->
|
|
<div class="menu-bar" >
|
|
<ul class="menu-links" >
|
|
<li <%if(r_call(request.getParameter("show_no")).equals("6")){%>class="active"<%}%>><a href="/cms_for_bcb/process/leaderboard/list.jsp?show_no=6&check_no=0&c_relation=120&c_relation2=312">Leaderboard<i class="fa fa-indicator"></i></a>
|
|
|
|
</li>
|
|
<% if(session.getAttribute("member_type") != null && session.getAttribute("member_type").equals("0")){%>
|
|
<li <%if(r_call(request.getParameter("show_no")).equals("7")){%>class="active"<%}%> ><a href="/cms_for_bcb/process/bcb/list.jsp?show_no=7&check_no=0&c_relation=528&c_relation2=304&c_team=<%=session.getAttribute("member_team_no")%>">BMC<i class="fa fa-indicator"></i></a>
|
|
<ul class="drop-down-multilevel">
|
|
<li <%if(c_team.equals(session.getAttribute("member_team_no"))){%>class="active"<%}%> style="border-bottom: 1px solid #ccc;">
|
|
<a href="/cms_for_bcb/process/bcb/list.jsp?show_no=7&check_no=0&c_relation=528&c_relation2=304&c_team=<%=session.getAttribute("member_team_no")%>">My Team</a>
|
|
</li>
|
|
<%
|
|
if(session.getAttribute("member_project_no") != null && !session.getAttribute("member_project_no").equals("")){
|
|
String sql_team = " select c_no, c_team_name from tbl_team where c_use = 0 and c_project_no = "+ session.getAttribute("member_project_no") + " and c_no <> "+ session.getAttribute("member_team_no") +" order by c_team_name asc ";
|
|
ResultSet rs_team = stmt2.executeQuery(sql_team);
|
|
while(rs_team.next()){
|
|
%>
|
|
<li <%if(c_team.equals(rs_team.getString("c_no"))){%>class="active"<%}%>>
|
|
<a href="/cms_for_bcb/process/order_bcb/list.jsp?show_no=7&check_no=0&c_relation=528&c_relation2=304&c_team=<%=rs_team.getInt("c_no")%>"><%=rs_team.getString("c_team_name")%></a>
|
|
</li>
|
|
<%
|
|
}
|
|
rs_team.close();
|
|
}
|
|
%>
|
|
</ul>
|
|
</li>
|
|
<%}else{%>
|
|
<li <%if(r_call(request.getParameter("show_no")).equals("7")){%>class="active"<%}%> ><a href="#none">Teams<i class="fa fa-indicator"></i></a>
|
|
<!-- drop down multilevel -->
|
|
<%
|
|
int t_count = 0;
|
|
int go_count = 0;
|
|
String sql_pop = "select count(c_no) as t_count from tbl_team where c_use = 0 and c_project_no = "+ session.getAttribute("member_project_no") + " ";
|
|
ResultSet rs_pop = stmt2.executeQuery(sql_pop);
|
|
if(rs_pop.next()){
|
|
t_count = rs_pop.getInt("t_count");
|
|
}
|
|
rs_pop.close();
|
|
go_count = t_count / 10 + 1;
|
|
%>
|
|
<ul class="drop-down-multilevel" style="background:#efefef" >
|
|
<table style="background:#efefef;">
|
|
<%
|
|
if(session.getAttribute("member_project_no") != null && !session.getAttribute("member_project_no").equals("")){
|
|
String sql_team = " select c_no, c_team_name from tbl_team where c_use = 0 and c_project_no = "+ session.getAttribute("member_project_no") + " order by c_team_name asc ";
|
|
ResultSet rs_team = stmt2.executeQuery(sql_team);
|
|
int rtp = 0;
|
|
while(rs_team.next()){
|
|
rtp = rtp + 1;
|
|
%>
|
|
<%if(rtp == 1){%>
|
|
<tr>
|
|
<%}%>
|
|
<td style="vertical-align:top;">
|
|
<li <%if(c_team.equals(rs_team.getString("c_no"))){%>class="active"<%}%> style="padding:0px; ">
|
|
<a href="/cms_for_bcb/process/bcb/list.jsp?show_no=7&check_no=0&c_relation=528&c_relation2=304&c_team=<%=rs_team.getInt("c_no")%>"><%=rs_team.getString("C_team_name")%></a>
|
|
</li>
|
|
</td>
|
|
<%if(rtp == go_count){
|
|
rtp = 0;
|
|
%>
|
|
</tr>
|
|
<%}%>
|
|
<%
|
|
}
|
|
rs_team.close();
|
|
}
|
|
%>
|
|
</table>
|
|
</ul>
|
|
</li>
|
|
<%}%>
|
|
<li <%if(r_call(request.getParameter("show_no")).equals("8")){%>class="active"<%}%>><a href="/cms_for_bcb/process/presentation/list.jsp?show_no=8&check_no=0&c_relation=821&c_relation2=239">Presentation<i class="fa fa-indicator"></i></a>
|
|
|
|
</li>
|
|
<li <%if(r_call(request.getParameter("show_no")).equals("9")){%>class="active"<%}%>><a href="/cms_for_bcb/process/board/list.jsp?show_no=9&check_no=0&c_relation=394&c_relation2=239">BMC Notice<i class="fa fa-indicator"></i></a>
|
|
|
|
</li>
|
|
<li <%if(r_call(request.getParameter("show_no")).equals("10")){%>class="active"<%}%>><a href="/cms_for_bcb/process/notice/list.jsp?show_no=10&check_no=0&c_relation=2019&c_relation2=1074">Board<i class="fa fa-indicator"></i></a>
|
|
<ul class="drop-down-multilevel">
|
|
<li <%if(r_call(request.getParameter("c_relation2")).equals("1074")){%>class="active"<%}%>>
|
|
<a href="/cms_for_bcb/process/notice/list.jsp?show_no=10&check_no=0&c_relation=2019&c_relation2=1074">Data</a>
|
|
</li>
|
|
<!--
|
|
<li <%if(r_call(request.getParameter("c_relation2")).equals("1075")){%>class="active"<%}%>>
|
|
<a href="/cms_for_bcb/process/movie/list.jsp?show_no=11&check_no=0&c_relation=2019&c_relation2=1075">Education Clips</a>
|
|
</li>
|
|
-->
|
|
<li <%if(r_call(request.getParameter("c_relation2")).equals("1073")){%>class="active"<%}%>>
|
|
<a href="/cms_for_bcb/process/notice/list.jsp?show_no=12&check_no=0&c_relation=2019&c_relation2=1073">General Notice</a>
|
|
</li>
|
|
|
|
</ul>
|
|
</li>
|
|
<!--
|
|
<li <%if(r_call(request.getParameter("show_no")).equals("102")){%>class="active"<%}%>><a href="/cms_for_bcb/process/apply/list.jsp?show_no=102&check_no=0&c_relation=329&c_relation2=232">Apply Site<i class="fa fa-indicator"></i></a>
|
|
|
|
</li>
|
|
-->
|
|
|
|
|
|
|
|
</ul>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</section>
|
|
</nav>
|
|
<!-- menu end -->
|
|
</div>
|
|
</header>
|