<%
/*==============================================================================================
* Project Title : GY (계양구청 관리프로그램)
* File Name : bb_Edit_ok.jsp
* Include : /include/in_Top.jsp, /include/in_Bottom.jsp, /include/in_BBSMenu.jsp,
/include/in_Import.jsp, /include/in_Function.jsp
* Used DB Table : gy_bbs
* Used Class :
* Description : 게시판 수정 처리
* Programmer : 김명재
* First Write : 2005.12.20
* Last Update :
==============================================================================================*/
%>
<%@ page contentType="text/html;charset=euc-kr" %>
<%@ include file="/include/in_Import.jsp" %>
<%@ include file="/include/in_Function.jsp" %>
<jsp:useBean id="sutil" class="kr.co.slight.jinhae.util.GYUtil" scope="page" />
<jsp:useBean id="myUpload" class="com.jspsmart.upload.SmartUpload" scope="page" />
<%!
static {
try {
new kr.co.slight.jinhae.pool.JDCConnectionDriver("org.postgresql.Driver","jdbc:postgresql:hanmaum","postgres","");
} catch(Exception e) {
System.out.println("<br><br>JDCConnectionDriver Error : " + e.toString());
}
}
%>
<%
myUpload.initialize(pageContext);
myUpload.upload();
String no = request.getParameter("no");
String companyNm = "";
String companyCd = "";
String userNm = "";
String postNo1 = "";
String postNo2 = "";
String addr = "";
String upte = "";
String jongmok = "";
String deptNm = "";
String charge = "";
String telNo1 = "";
String mbNo1 = "";
String faxNo1 = "";
String email = "";
String curmNm = "";
String strYear = "";
String endYear = "";
String endMonth = "";
String endDay = "";
String chInTime = "";
String chOutTime = "";
String totalCnt = "";
String studentCnt = "";
String otherCnt = "";
String menCnt = "";
String girlCnt = "";
String totalMeal = "";
String mealUserCnt = "";
String totalSpMeal = "";
String atchFile01 = "";
String atchFile02 = "";
String roomCnt01 = "";
String roomCnt02 = "";
String roomCnt03 = "";
String roomCnt04 = "";
String roomCnt05 = "";
String roomCnt06 = "";
String roomCnt07 = "";
String dayCnt01 = "";
String dayCnt02 = "";
String dayCnt03 = "";
String dayCnt04 = "";
String dayCnt05 = "";
String dayCnt06 = "";
String dayCnt07 = "";
String dayCnt08 = "";
String dayCnt09 = "";
String dayCnt10 = "";
String campfire = "";
String seting = "";
String reg_dt = "";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
StringBuffer query = new StringBuffer();
query.append("select * from ");
query.append("application_installation a, application b ");
query.append("where a.no = b.no and a.no = ").append(no);
conn = DriverManager.getConnection("jdbc:jdc:jdcpool");
stmt = conn.createStatement();
rs = stmt.executeQuery(query.toString());
while(rs.next()) {
companyNm = rs.getString("company_name");
companyCd = rs.getString("company_code");
userNm = rs.getString("representative");
postNo1 = rs.getString("post_no");
addr = rs.getString("addr");
upte = rs.getString("conditions");
jongmok = rs.getString("event");
deptNm = rs.getString("dept_name");
charge = rs.getString("charge");
telNo1 = rs.getString("tel_no");
mbNo1 = rs.getString("mb_no");
faxNo1 = rs.getString("fax_no");
email = rs.getString("email");
curmNm = rs.getString("curm_name");
strYear = rs.getString("start_training_date");
endYear = rs.getString("end_training_date");
chInTime = rs.getString("check_in_time");
chOutTime = rs.getString("check_out_time");
totalCnt = rs.getString("user_cnt");
totalMeal = rs.getString("meal_cnt");
totalSpMeal = rs.getString("sp_meal_cnt");
atchFile01 = rs.getString("atch_file_01");
atchFile02 = rs.getString("atch_file_02");
roomCnt01 = rs.getString("hall_150");
roomCnt02 = rs.getString("class_room_80");
roomCnt03 = rs.getString("class_room_40");
roomCnt04 = rs.getString("seminar_room_20");
roomCnt05 = rs.getString("seminar_room_10");
roomCnt06 = rs.getString("stay_5");
roomCnt07 = rs.getString("stay_18");
dayCnt01 = rs.getString("hall_150");
dayCnt02 = rs.getString("class_room_80");
dayCnt03 = rs.getString("class_room_40");
dayCnt04 = rs.getString("seminar_room_20");
dayCnt05 = rs.getString("seminar_room_10");
dayCnt06 = rs.getString("stay_5");
dayCnt07 = rs.getString("stay_18");
dayCnt08 = rs.getString("playground_50");
dayCnt09 = rs.getString("playground_100");
dayCnt10 = rs.getString("playground_200");
campfire = rs.getString("campfire");
seting = rs.getString("seting");
reg_dt = rs.getString("reg_dt");
if("S".equals(seting)) {
seting = "학교식";
} else {
seting = "분임식";
}
}
if(totalSpMeal == null) totalSpMeal = "0,0,0";
if(totalSpMeal.equals(",,")) totalSpMeal = "0,0,0";
String[] startTrainingDate = strYear.split(",");
String[] endTrainingDate = endYear.split(",");
String[] userCnt = totalCnt.split(",");
String[] mealCnt = totalMeal.split(",");
String[] spMealCnt = totalSpMeal.split(",");
String[] postNo = postNo1.split(",");
String[] telNo = telNo1.split(",");
String[] mbNo = mbNo1.split(",");
String[] faxNo = faxNo1.split(",");
String[] array01 = roomCnt01.split(",");
String[] array02 = roomCnt02.split(",");
String[] array03 = roomCnt03.split(",");
String[] array04 = roomCnt04.split(",");
String[] array05 = roomCnt05.split(",");
String[] array06 = roomCnt06.split(",");
String[] array07 = roomCnt07.split(",");
%>
<%@ page contentType="text/html;charset=euc-kr" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="ko" xml:lang="ko">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr" />
<link rel="stylesheet" href="../Common/hstyle.css" type="text/css">
<title>충주 한마음 연수원 이용신청서</title>
<script language="javascript">
<!--
function onViewFile(filePath) {
window.open(filePath,"popup", "width=500px, height=600px");
}
//-->
</script>
</head>
<body>
<form name="form1">
<table width="640" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="right">
<a href="javascript:window.print()"><font color="orange"><strong>[ 인쇄하기 ]</strong></font></a>
</td>
</tr>
</table>
<table width="640" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center">
<strong><font size="+2">충주 한마음 연수원 이용신청서</font></strong>
</td>
</tr>
</table>
<br />
<br />
<table width="640" border="0" cellspacing="1" cellpadding="0" bgcolor="#333333" style="padding:4 10 0 10">
<tr>
<td height="1" colspan="4" bgcolor="#313131"></td>
</tr>
<tr>
<th width="17%" height="24" bgcolor="#f4f4f4">회사명</th>
<td width="34%" bgcolor="#FFFFFF">
<%= companyNm %>
</td>
<th width="17%" bgcolor="#f4f4f4">사업자등록번호</th>
<td width="32%" bgcolor="#FFFFFF" class="no">
<%= companyCd %>
</td>
</tr>
<tr>
<th height="24" bgcolor="#f4f4f4">대표자</th>
<td bgcolor="#FFFFFF"> <%= userNm %></td>
<th bgcolor="#f4f4f4">우편번호</th>
<td bgcolor="#FFFFFF">
<%= !postNo1.equals(",")?postNo[0]:"" %>
- <%= !postNo1.equals(",")?postNo[1]:"" %>
</td>
</tr>
<tr>
<th height="24" bgcolor="#f4f4f4">주소</th>
<td colspan="3" bgcolor="#FFFFFF"> <%= addr %></td>
</tr>
<tr>
<th height="24" bgcolor="#f4f4f4">업태</th>
<td bgcolor="#FFFFFF"> <%= upte %></td>
<th bgcolor="#f4f4f4">종목</th>
<td bgcolor="#FFFFFF"> <%= jongmok %></td>
</tr>
<tr>
<th height="24" bgcolor="#f4f4f4">부서명</th>
<td bgcolor="#FFFFFF"> <%= deptNm %></td>
<th bgcolor="#f4f4f4">담당자</th>
<td bgcolor="#FFFFFF"> <%= charge %></td>
</tr>
<tr>
<th height="24" bgcolor="#f4f4f4">전화번호</th>
<td bgcolor="#FFFFFF">
<%= !telNo1.equals(",,")?telNo[0]:"" %>
- <%= !telNo1.equals(",,")?telNo[1]:"" %>
- <%= !telNo1.equals(",,")?telNo[2]:"" %>
</td>
<th bgcolor="#f4f4f4">휴대폰</th>
<td bgcolor="#FFFFFF">
<%= !mbNo1.equals(",,")?mbNo[0]:"" %>
- <%= !mbNo1.equals(",,")?mbNo[1]:"" %>
- <%= !mbNo1.equals(",,")?mbNo[2]:"" %>
</td>
</tr>
<tr>
<th height="24" bgcolor="#f4f4f4">팩스번호</th>
<td bgcolor="#FFFFFF">
<%= !faxNo1.equals(",,")?faxNo[0]:"" %>
- <%= !faxNo1.equals(",,")?faxNo[1]:"" %>
- <%= !faxNo1.equals(",,")?faxNo[2]:"" %>
</td>
<th bgcolor="#f4f4f4">E-Mail</th>
<td bgcolor="#FFFFFF"> <%= email %></td>
</tr>
<tr>
<th height="24" bgcolor="#f4f4f4">과정명</th>
<td colspan="3" bgcolor="#FFFFFF"> <%= curmNm %></td>
</tr>
<tr>
<th height="24" bgcolor="#f4f4f4">교육기간</th>
<td colspan="3" bgcolor="#FFFFFF">
<%= startTrainingDate[0]!=null?startTrainingDate[0]:"" %> 년
<%= startTrainingDate[1] %> 월
<%= startTrainingDate[2] %> 일
~
<%= endTrainingDate[0]!=null?endTrainingDate[0]:"" %> 년
<%= endTrainingDate[1] %> 월
<%= endTrainingDate[2] %> 일
</td>
</tr>
<tr>
<th height="24" bgcolor="#f4f4f4">입소시간</th>
<td bgcolor="#FFFFFF"> <%= chInTime %></td>
<th bgcolor="#f4f4f4">퇴소시간</th>
<td bgcolor="#FFFFFF"> <%= chOutTime %></td>
</tr>
<tr>
<th height="24" bgcolor="#f4f4f4">인원</th>
<td colspan="3" bgcolor="#FFFFFF">
총 <%= userCnt[0] %> 명 (교육생 : <%= userCnt[1] %>명 , 기타 : <%= userCnt[2] %> 명 ) 남자 : <%= userCnt[3] %>명 , 여자 : <%= userCnt[4] %> 명
</td>
</tr>
<tr>
<th height="24" bgcolor="#f4f4f4">식사</th>
<td colspan="3" bgcolor="#FFFFFF">
총 <%= mealCnt[0] %> 식 ( <%= mealCnt[1] %> 명 x <%= mealCnt[2] %> 식)
</td>
</tr>
<tr>
<th height="24" bgcolor="#f4f4f4">특식</th>
<td colspan="3" bgcolor="#FFFFFF">
총 <%= spMealCnt[0] %> 식 ( <%= spMealCnt[1] %> 명 x <%= spMealCnt[2] %> 식)
</td>
</tr>
</table>
<br />
<table width="640" border="0" cellspacing="1" cellpadding="0" bgcolor="#333333" style="padding:4 10 0 10">
<tr>
<td height="1" colspan="6" bgcolor="#333333"></td>
</tr>
<tr>
<th width="17%" bgcolor="#f4f4f4">시설명</th>
<th width="17%" bgcolor="#f4f4f4">구분</th>
<th width="17%" height="24" bgcolor="#f4f4f4">시설현황</th>
<th width="17%" bgcolor="#f4f4f4">수량</th>
<th width="17%" bgcolor="#f4f4f4">사용일</th>
<th width="15%" bgcolor="#f4f4f4">비고</th>
</tr>
<tr>
<th rowspan="5" bgcolor="#f4f4f4">교육시설</th>
<td align="center" bgcolor="#FFFFFF">강당</td>
<td height="24" align="center" bgcolor="#FFFFFF">150명 (1실)</td>
<td bgcolor="#FFFFFF"> <%= array01.length > 0 ? array01[0]:"" %></td>
<td bgcolor="#FFFFFF"> <%= array01.length > 1 ? array01[1]:"" %></td>
<td bgcolor="#FFFFFF"></td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">중강의실</td>
<td height="24" align="center" bgcolor="#FFFFFF">80명 (1실)</td>
<td bgcolor="#FFFFFF"> <%= array02.length > 0 ? array02[0]:"" %></td>
<td bgcolor="#FFFFFF"> <%= array02.length > 1 ? array02[1]:"" %></td>
<td bgcolor="#FFFFFF"></td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">소강의실</td>
<td height="24" align="center" bgcolor="#FFFFFF">40명 (4실)</td>
<td bgcolor="#FFFFFF"> <%= array03.length > 0 ? array03[0]:"" %></td>
<td bgcolor="#FFFFFF"> <%= array03.length > 1 ? array03[1]:"" %></td>
<td bgcolor="#FFFFFF"></td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">세미나실(중)</td>
<td height="24" align="center" bgcolor="#FFFFFF">20명 (1실)</td>
<td bgcolor="#FFFFFF"> <%= array04.length > 0 ? array04[0]:"" %></td>
<td bgcolor="#FFFFFF"> <%= array04.length > 1 ? array04[1]:"" %></td>
<td bgcolor="#FFFFFF"></td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">세미나실(소)</td>
<td height="24" align="center" bgcolor="#FFFFFF">10명 (4실)</td>
<td bgcolor="#FFFFFF"> <%= array05.length > 0 ? array05[0]:"" %></td>
<td bgcolor="#FFFFFF"> <%= array05.length > 1 ? array05[1]:"" %></td>
<td bgcolor="#FFFFFF"></td>
</tr>
<tr>
<th rowspan="2" bgcolor="#f4f4f4">숙박시설</th>
<td align="center" bgcolor="#FFFFFF">2 • 4 인실</td>
<td height="24" align="center" bgcolor="#FFFFFF">6실</td>
<td bgcolor="#FFFFFF"> <%= array06.length > 0 ? array06[0]:"" %></td>
<td bgcolor="#FFFFFF"> <%= array06.length > 1 ? array06[1]:"" %></td>
<td bgcolor="#FFFFFF"></td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">4 • 6 인실</td>
<td height="24" align="center" bgcolor="#FFFFFF">17실</td>
<td bgcolor="#FFFFFF"> <%= array07.length > 0 ? array07[0]:"" %></td>
<td bgcolor="#FFFFFF"> <%= array07.length > 1 ? array07[1]:"" %></td>
<td bgcolor="#FFFFFF"></td>
</tr>
<tr>
<th rowspan="3" bgcolor="#f4f4f4">부대시설</th>
<td rowspan="3" align="center" bgcolor="#FFFFFF">잔디운동장</td>
<td height="24" align="center" bgcolor="#FFFFFF">50인 이하</td>
<td colspan="2" bgcolor="#FFFFFF"> <%= dayCnt08 %></td>
<td rowspan="3" align="center" bgcolor="#FFFFFF">
단체숙박시<br />
무료이용
</td>
</tr>
<tr>
<td height="24" align="center" bgcolor="#FFFFFF">100인 이하</td>
<td colspan="2" bgcolor="#FFFFFF"> <%= dayCnt09 %></td>
</tr>
<tr>
<td height="24" align="center" bgcolor="#FFFFFF">200인 이하</td>
<td colspan="2" bgcolor="#FFFFFF"> <%= dayCnt10 %></td>
</tr>
<tr>
<th bgcolor="#f4f4f4">강의장세팅</th>
<td height="24" colspan="5" bgcolor="#FFFFFF" style="line-height:160%;"> <%= seting %></td>
</tr>
<tr>
<th bgcolor="#f4f4f4">첨부파일</th>
<td height="40" colspan="5" bgcolor="#FFFFFF" style="line-height:160%;">
<%
String img_name1 = "";
String img_name2 = "";
if (atchFile01 != null && !atchFile01.equals("")) {
try {
img_name1 = "/hanmaum/Accou/atcFile/" + atchFile01;
} catch (Exception e) { }
}
if (atchFile02 != null && !atchFile02.equals("")) {
try {
img_name2 = "/hanmaum/Accou/atcFile/" + atchFile02;
} catch (Exception e) { }
}
%>
<% if(!atchFile01.equals("")) { %>
<a href="javascript:onViewFile('<%=img_name1%>')">
<% } %>
1. 사업자등록중
<% if(!atchFile01.equals("")) { %>
</a> <img src="../Image/04_but20.gif" border="0" align="absmiddle">
<% } else { %>
<img src="../Image/04_but19.gif" border="0" align="absmiddle">
<% } %>
<br />
<% if(!atchFile02.equals("")) { %>
<a href="javascript:onViewFile('<%=img_name2%>')">
<% } %>
2. 교육일정표
<% if(!atchFile02.equals("")) { %>
</a> <img src="../Image/04_but20.gif" border="0" align="absmiddle">
<% } else { %>
<img src="../Image/04_but19.gif" border="0" align="absmiddle">
<% } %>
</td>
</tr>
<tr>
<th bgcolor="#f4f4f4" id="ce">협조사항</th>
<td height="140" colspan="5" bgcolor="#FFFFFF" style="line-height:160%;">
1. 사업자등록증과 교육일정표는 첨부하시거나 팩스로 송부바랍니다.<br />
2. 식사인원 변동시 4일전 통보하여 주시고, 미통보시 예약신청 인원으로 정산됩니다. <br />
(단, 예약인원 초과시 실제인원으로 정산)<br />
3. 본 신청서 접수로 사용계약이 체결됩니다. <br />
(단, 별도 계약이 필요시 연수원으로 연락하 주시기 바랍니다.)<br />
4. 시설물 사용부주의로 인한 고장 수리비는 사용자가 부담합니다.<br />
5. 기타 변동사항이 발생시 교육일 2주전까지 연락바랍니다.<br />
6. 그외 모든 사항은 이용약관을 참조하시기 바랍니다.
</td>
</tr>
</table>
<br />
<br />
<br />
<table width="640" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center">
<strong>
<font size="3pt">
<%= reg_dt.substring(0,4) %> 년 <%= reg_dt.substring(5,7) %> 월 <%= reg_dt.substring(8,10) %> 일
</font>
</strong>
<br />
<br />
<strong><font size="+2">SCG 그룹 충주 한마음 연수원장 귀중 </font></strong>
</td>
</tr>
</table>
</form>
<form method="post" name="popup" target="popup"></form>
</body>
</html>
<%
if ( rs != null ) rs.close();
if ( stmt != null ) stmt.close();
if ( conn != null ) conn.close();
} catch (Exception e) {
if ( rs != null ) rs.close();
if ( stmt != null ) stmt.close();
if ( conn != null ) conn.close();
// 에러페이지로 이동............
out.println("JSP >> Exception : " + e.toString());
}
%>