<%@ 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" /> <%! 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()); } } %> <% String menuId = request.getParameter("menuId"); String agree = request.getParameter("agree"); if(menuId == null || menuId.equals("")) menuId = "35"; %> <% /*++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ SESSION ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/ String todate = ""; Connection conn = null; Statement stmt = null; ResultSet rs = null; try { StringBuffer query = new StringBuffer(); query.append("select now() as sysdate"); conn = DriverManager.getConnection("jdbc:jdc:jdcpool"); stmt = conn.createStatement(); rs = stmt.executeQuery(query.toString()); while ( rs.next() ) { todate = rs.getString("sysdate"); } rs.close(); %> <%@ page contentType="text/html;charset=euc-kr" %> <jsp:include page="/hanmaum/top.jsp" flush="false"/> <!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="/hanmaum/Common/hstyle.css" type="text/css"> <title>무제 문서</title> <script type="text/javascript"> <!-- function onSubmit(str) { var frm = document.all; var frm1 = document.form1; frm.companyCd.value = frm.companyCd1.value + frm.companyCd2.value + frm.companyCd3.value; window.open("accou05_pri.jsp?companyNm="+frm.companyNm.value+"&companyCd="+frm.companyCd.value+"&userNm="+frm.userNm.value+"&postNo1="+frm.postNo1.value+"&postNo2="+frm.postNo2.value+"&addr="+frm.addr.value+"&upte="+frm.upte.value+"&jongmok="+frm.jongmok.value+"&deptNm="+frm.deptNm.value+"&charge="+frm.charge.value+"&telNo1="+frm.telNo1.value+"&telNo2="+frm.telNo2.value+"&telNo3="+frm.telNo3.value+"&mbNo1="+frm.mbNo1.value+"&mbNo2="+frm.mbNo2.value+"&mbNo3="+frm.mbNo3.value+"&faxNo1="+frm.faxNo1.value+"&faxNo2="+frm.faxNo2.value+"&faxNo3="+frm.faxNo3.value+"&email="+frm.email.value+"&curmNm="+frm.curmNm.value+"&strYear="+frm.strYear.value+"&strMonth="+frm.strMonth.value+"&strDay="+frm.strDay.value+"&endYear="+frm.endYear.value+"&endMonth="+frm.endMonth.value+"&endDay="+frm.endDay.value+"&chInTime="+frm.chInTime.value+"&chOutTime="+frm.chOutTime.value+"&totalCnt="+frm.totalCnt.value+"&studentCnt="+frm.studentCnt.value+"&otherCnt="+frm.otherCnt.value+"&menCnt="+frm.menCnt.value+"&girlCnt="+frm.girlCnt.value+"&totalMeal="+frm.totalMeal.value+"&mealUserCnt="+frm.mealUserCnt.value+"&mealCnt="+frm.mealCnt.value+"&roomCnt01="+frm.roomCnt01.value+"&roomCnt02="+frm.roomCnt02.value+"&roomCnt03="+frm.roomCnt03.value+"&roomCnt04="+frm.roomCnt04.value+"&roomCnt05="+frm.roomCnt05.value+"&roomCnt06="+frm.roomCnt06.value+"&roomCnt07="+frm.roomCnt07.value+"&dayCnt01="+frm.dayCnt01.value+"&dayCnt02="+frm.dayCnt02.value+"&dayCnt03="+frm.dayCnt03.value+"&dayCnt04="+frm.dayCnt04.value+"&dayCnt05="+frm.dayCnt05.value+"&dayCnt06="+frm.dayCnt06.value+"&dayCnt07="+frm.dayCnt07.value+"&dayCnt08="+frm.dayCnt08.value+"&dayCnt09="+frm.dayCnt09.value+"&dayCnt10="+frm.dayCnt10.value+"&dayCnt="+frm.dayCnt.value+"&todate="+frm.todate.value+"&sikGubun="+frm.sikGubun.value+"&totaluSpMeal="+frm.totaluSpMeal.value+"&SpmealUserCnt="+frm.SpmealUserCnt.value+"&SpmealCnt="+frm.SpmealCnt.value+"&file_nm_new01="+frm.file_nm_new01.value+"&file_nm_new02="+frm.file_nm_new02.value, "popup", "width=700px, height=2000px, scrollbars=yes"); frm1.target = "_self"; if(str == "Y") { if(onCheck() == false) return; frm1.submit(); } } function onReset() { var frm = document.form1; if(!confirm("취소하시겠습니까?")) return; frm.reset(); } function onAdmin() { location.href = "csnot04.jsp"; } function post() { window.open("../post_search.jsp","popup", "width=500%, height=600"); } function onSetPostNo(postNo, addr) { document.all.postNo1.value = postNo.substr(0,3); document.all.postNo2.value = postNo.substr(3,6); document.all.addr.value = document.all.addr.value + addr; } function onCheck() { var frm = document.all; if(frm.agree.value != "Y") { alert("잘못된 경로로 접근하셨습니다."); return false; } else if(frm.companyNm.value == "") { alert("회사명을 등록해주세요."); return false; } else if(frm.companyCd.value == "") { alert("사업자등록번호를 등록해주세요."); return false; } else if(frm.userNm.value == "") { alert("대표자를 등록해주세요."); return false; } else if(frm.postNo1.value == "") { alert("우편번호를 등록해주세요."); return false; } else if(frm.postNo2.value == "") { alert("우편번호를 등록해주세요."); return false; } else if(frm.addr.value == "") { alert("주소를 등록해주세요."); return false; } else if(frm.upte.value == "") { alert("업태를 등록해주세요."); return false; } else if(frm.jongmok.value == "") { alert("종목을 등록해주세요."); return false; } else if(frm.deptNm.value == "") { alert("부서명을 등록해주세요."); return false; } else if(frm.charge.value == "") { alert("담당자를 등록해주세요."); return false; } else if(frm.telNo1.value == "") { alert("전화번호를 등록해주세요."); return false; } else if(frm.telNo2.value == "") { alert("전화번호를 등록해주세요."); return false; } else if(frm.telNo3.value == "") { alert("전화번호를 등록해주세요."); return false; } else if(frm.mbNo1.value == "") { alert("휴대전화를 등록해주세요."); return false; } else if(frm.mbNo2.value == "") { alert("휴대전화를 등록해주세요."); return false; } else if(frm.mbNo3.value == "") { alert("휴대전화를 등록해주세요."); return false; } else if(frm.faxNo1.value == "") { alert("팩스를 등록해주세요."); return false; } else if(frm.faxNo2.value == "") { alert("팩스를 등록해주세요."); return false; } else if(frm.faxNo3.value == "") { alert("팩스를 등록해주세요."); return false; } else if(frm.email.value == "") { alert("이메일을 등록해주세요."); return false; } else if(frm.curmNm.value == "") { alert("과정명을 등록해주세요."); return false; } else if(frm.strYear.value == "") { alert("교육기간을 등록해주세요."); return false; } else if(frm.strMonth.value == "") { alert("교육기간을 등록해주세요."); return false; } else if(frm.strDay.value == "") { alert("교육기간을 등록해주세요."); return false; } else if(frm.endYear.value == "") { alert("교육기간을 등록해주세요."); return false; } else if(frm.endMonth.value == "") { alert("교육기간을 등록해주세요."); return false; } else if(frm.endDay.value == "") { alert("교육기간을 등록해주세요."); return false; } else if(frm.chInTime.value == "") { alert("입소시간을 등록해주세요."); return false; } else if(frm.chOutTime.value == "") { alert("퇴소시간을 등록해주세요."); return false; } else if(frm.totalCnt.value == "") { alert("인원을 등록해주세요."); return false; } else if(frm.studentCnt.value == "") { alert("인원을 등록해주세요."); return false; } else if(frm.otherCnt.value == "") { alert("인원을 등록해주세요."); return false; } else if(frm.menCnt.value == "") { alert("인원을 등록해주세요."); return false; } else if(frm.girlCnt.value == "") { alert("인원을 등록해주세요."); return false; } else if(frm.totalMeal.value == "") { alert("식사를 등록해주세요."); return false; } else if(frm.mealUserCnt.value == "") { alert("식사를 등록해주세요."); return false; } else if(frm.mealCnt.value == "") { alert("식사를 등록해주세요."); return false; } else if(frm.sikGubun.value == "") { alert("강의장세팅을 선택해주세요."); return false; } else { return true; } } function onNextTab(name) { var frm = document.form1; eval("frm."+name+".focus();"); } function onInwoun() { var frm = document.form1; if(frm.studentCnt.value == "") frm.studentCnt.value = "0"; if(frm.otherCnt.value == "") frm.otherCnt.value = "0"; var studentCnt = frm.studentCnt.value; var otherCnt = frm.otherCnt.value; frm.totalCnt.value = Number(studentCnt) + Number(otherCnt); frm.mealUserCnt.value = frm.totalCnt.value; } function onSiksa() { var frm = document.form1; if(frm.mealUserCnt.value == "") frm.mealUserCnt.value = "0"; if(frm.mealCnt.value == "") frm.mealCnt.value = "0"; var mealUserCnt = frm.mealUserCnt.value; var mealCnt = frm.mealCnt.value; frm.totalMeal.value = Number(mealUserCnt) * Number(mealCnt); } function onTksik() { var frm = document.form1; if(frm.SpmealUserCnt.value == "") frm.SpmealUserCnt.value = "0"; if(frm.SpmealCnt.value == "") frm.SpmealCnt.value = "0"; var SpmealUserCnt = frm.SpmealUserCnt.value; var SpmealCnt = frm.SpmealCnt.value; frm.totaluSpMeal.value = Number(SpmealUserCnt) * Number(SpmealCnt); } //--> </script> </head> <body onload="mouseOnEvent('<%= menuId %>');"> <%@ include file="/hanmaum/Accou/03_subimg.jsp" %> <form name="form1" method="post" action="accou05_ok.jsp" enctype="multipart/form-data"> <input type="hidden" name="todate" value="<%= todate %>" /> <input type="hidden" name="agree" value="<%= agree %>" /> <table width="940" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="239" valign="top" id="left"> <!--좌측메뉴--> <%@ include file="/hanmaum/Accou/left_menu.jsp" %> <!--좌측메뉴끝--> </td> <td width="701" valign="top" id="left"> <!--컨텐츠 시작--> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="25" align="right" valign="bottom" id="ma1"> <img src="/hanmaum/Image/location.gif" width="51" height="13" align="absmiddle"> 홈 > 이용안내 > 신청서작성 </td> </tr> <tr> <td><img src="/hanmaum/Image/03_centop05.gif" alt="" width="701" height="56" /></td> </tr> <tr> <td height="36"> </td> </tr> </table> <table width="680" border="0" cellspacing="0" cellpadding="0"> <tr> <td><img src="/hanmaum/Image/box_01.gif" alt="" width="680" height="7" /></td> </tr> <tr> <td background="/hanmaum/Image/box_03.gif" id="box1"> <img src="/hanmaum/Image/03_cen06.gif" alt="" width="618" height="56" /> <br /> <br /> <img src="../Image/03_cen10.gif" alt="" width="48" height="21" /><br /> <table width="618" border="0" cellspacing="0" cellpadding="0" class="boxtable"> <tr> <td height="3" colspan="4" background="/hanmaum/Image/ha_backc01.gif"></td> </tr> <tr> <th width="17%">회사명</th> <td width="34%"><input type="text" name="companyNm" id="companyNm" /></td> <th width="17%">사업자등록번호</th> <td width="32%" class="no"> <input type="text" name="companyCd1" size="3" maxlength="3" /> - <input type="text" name="companyCd2" size="2" maxlength="2" /> - <input type="text" name="companyCd3" size="5" maxlength="5" /> <input type="hidden" name="companyCd" id="companyCd" /> </td> </tr> <tr> <th>대표자</th> <td><input type="text" name="userNm" id="userNm" /></td> <th>우편번호</th> <td class="no"> <input name="postNo1" type="text" id="postNo1" size="5" /> - <input name="postNo2" type="text" id="postNo2" size="5" /> <a href="javascript:post();"> <img src="/hanmaum/Image/ha_but_s23.gif" alt="" width="88" height="17" align="absmiddle" border="0" /> </a> </td> </tr> <tr> <th>주소</th> <td colspan="3" class="no"><input name="addr" type="text" id="addr" size="60" /></td> </tr> <tr> <th>업태</th> <td><input type="text" name="upte" id="upte" /></td> <th>종목</th> <td class="no"><input type="text" name="jongmok" id="jongmok" /></td> </tr> <tr> <th>부서명</th> <td><input type="text" name="deptNm" id="deptNm" /></td> <th>담당자</th> <td class="no"><input type="text" name="charge" id="charge" /></td> </tr> <tr> <th>전화번호</th> <td> <input name="telNo1" type="text" id="telNo1" size="3" /> - <input name="telNo2" type="text" id="telNo2" size="5" /> - <input name="telNo3" type="text" id="telNo3" size="5" /> </td> <th>이동전화</th> <td class="no"> <input name="mbNo1" type="text" id="mbNo1" size="3" /> - <input name="mbNo2" type="text" id="mbNo2" size="5" /> - <input name="mbNo3" type="text" id="mbNo3" size="5" /> </td> </tr> <tr> <th>팩스번호</th> <td> <input name="faxNo1" type="text" id="faxNo1" size="3" /> - <input name="faxNo2" type="text" id="faxNo2" size="5" /> - <input name="faxNo3" type="text" id="faxNo3" size="5" /> </td> <th>E-Mail</th> <td class="no"> <input type="text" name="email" id="email" /> </td> </tr> <tr> <th>과정명</th> <td colspan="3" class="no"><input type="text" name="curmNm" id="curmNm" /></td> </tr> <tr> <th>교육기간</th> <td colspan="3" class="no"> <input name="strYear" type="text" id="strYear" size="5" /> 년 <input name="strMonth" type="text" id="strMonth" size="4" /> 월 <input name="strDay" type="text" id="strDay" size="4" /> 일 ~ <input name="endYear" type="text" id="endYear" size="5" /> 년 <input name="endMonth" type="text" id="endMonth" size="4" /> 월 <input name="endDay" type="text" id="endDay" size="4" /> 일 </td> </tr> <tr> <th>입소시간</th> <td> <span class="no"> <input type="text" name="chInTime" id="chInTime" /> </span> </td> <th>퇴소시간</th> <td class="no"><input type="text" name="chOutTime" id="chOutTime" /></td> </tr> <tr> <th>인원</th> <td colspan="3" class="no"> 총 <input name="totalCnt" type="text" id="totalCnt" size="5" readonly="readonly" onclick="javascript:onNextTab('studentCnt');" /> 명 (교육생 : <input name="studentCnt" type="text" id="studentCnt" size="3" onkeyup="javascript:onInwoun();" /> 명, 기타 : <input name="otherCnt" type="text" id="otherCnt" size="3" onkeyup="javascript:onInwoun();" /> 명) 남자 : <input name="menCnt" type="text" id="menCnt" size="3" /> 명, 여자 : <input name="girlCnt" type="text" id="girlCnt" size="3" /> 명 </td> </tr> <tr> <th>식사</th> <td colspan="3" class="no"> 총 <input name="totalMeal" type="text" id="totalMeal" size="5" readonly="readonly" onclick="javascript:onNextTab('mealUserCnt');" /> 식 ( <input name="mealUserCnt" type="text" id="mealUserCnt" size="5" onkeyup="javascript:onSiksa();" /> 명 x <input name="mealCnt" type="text" id="mealCnt" size="3" onkeyup="javascript:onSiksa();" /> 식) </td> </tr> <tr> <th>특식</th> <td colspan="3" class="no"> 총 <input name="totaluSpMeal" type="text" id="totaluSpMeal" size="5" readonly="readonly" onclick="javascript:onNextTab('SpmealUserCnt');" /> 식 ( <input name="SpmealUserCnt" type="text" id="SpmealUserCnt" size="5" onkeyup="javascript:onTksik();" /> 명 x <input name="SpmealCnt" type="text" id="SpmealCnt" size="3" onkeyup="javascript:onTksik();" /> 식) </td> </tr> <tr> <td height="2" colspan="4" background="/hanmaum/Image/ha_backc01.gif"></td> </tr> </table> <br /><br /> <img src="../Image/03_cen11.gif" alt="" width="70" height="21" /><br /> <table width="618" border="0" cellspacing="0" cellpadding="0" class="boxtable"> <tr> <td height="3" colspan="6" background="/hanmaum/Image/ha_backc01.gif"></td> </tr> <tr> <th width="17%">시설명</th> <th width="17%">구분</th> <th width="17%">시설현황</th> <th width="17%">수량</th> <th width="17%">사용일</th> <th width="15%" class="no">비고</th> </tr> <tr> <th rowspan="5">교육시설</th> <td id="ce">강당</td> <td id="ce">150명 (1실)</td> <td id="ce"> <input name="roomCnt01" type="text" id="roomCnt01" size="2" /> 실 </td> <td id="ce"> <input name="dayCnt01" type="text" id="dayCnt01" size="3" /> 일 </td> <td class="nor"> </td> </tr> <tr> <td id="ce">중강의실</td> <td id="ce">80명 (1실)</td> <td id="ce"> <input name="roomCnt02" type="text" id="roomCnt02" size="2" /> 실 </td> <td id="ce"> <input name="dayCnt02" type="text" id="dayCnt02" size="3" /> 일 </td> <td class="nor"> </td> </tr> <tr> <td id="ce">소강의실</td> <td id="ce">40명 (4실)</td> <td id="ce"> <input name="roomCnt03" type="text" id="roomCnt03" size="2" /> 실 </td> <td id="ce"> <input name="dayCnt03" type="text" id="dayCnt03" size="3" /> 일 </td> <td class="nor"> </td> </tr> <tr> <td id="ce">세미나실(중)</td> <td id="ce">20명 (1실)</td> <td id="ce"> <input name="roomCnt04" type="text" id="roomCnt04" size="2" /> 실 </td> <td id="ce"> <input name="dayCnt04" type="text" id="dayCnt04" size="3" /> 일 </td> <td class="nor"> </td> </tr> <tr> <td id="ce">세미나실(소)</td> <td id="ce">10명 (4실)</td> <td id="ce"> <input name="roomCnt05" type="text" id="roomCnt05" size="2" /> 실 </td> <td id="ce"> <input name="dayCnt05" type="text" id="dayCnt05" size="3" /> 일 </td> <td class="nor"> </td> </tr> <tr> <th rowspan="2">숙박시설</th> <td id="ce">2 • 4 인실</td> <td id="ce">6실</td> <td id="ce"> <input name="roomCnt06" type="text" id="roomCnt06" size="2" /> 실 </td> <td id="ce"> <input name="dayCnt06" type="text" id="dayCnt06" size="3" /> 일 </td> <td class="nor"> </td> </tr> <tr> <td id="ce">4 • 6 인실</td> <td id="ce">17실</td> <td id="ce"> <input name="roomCnt07" type="text" id="roomCnt07" size="2" /> 실 </td> <td id="ce"> <input name="dayCnt07" type="text" id="dayCnt07" size="3" /> 일 </td> <td class="nor"> </td> </tr> <tr> <th rowspan="4">부대시설</th> <td rowspan="3" id="ce">잔디운동장</td> <td id="ce">50인 이하</td> <td colspan="2" id="ce"> <input name="dayCnt08" type="text" id="dayCnt08" size="3" /> 일 </td> <td rowspan="3" class="noc">단체숙박시<br />무료이용</td> </tr> <tr> <td id="ce">100인 이하</td> <td colspan="2" id="ce"> <input name="dayCnt09" type="text" id="dayCnt09" size="3" /> 일 </td> </tr> <tr> <td id="ce">200인 이하</td> <td colspan="2" id="ce"> <input name="dayCnt10" type="text" id="dayCnt10" size="3" /> 일 </td> </tr> <tr> <td id="ce">캠프파이어</td> <td id="ce"> </td> <td colspan="2" id="ce"><input name="dayCnt" type="text" id="dayCnt" size="3" /> 회</td> <td class="noc">1회 기준</td> </tr> <tr> <th>강의장세팅</th> <td colspan="5" class="no"> <input type="radio" name="sikGubun" id="ch1" value="S" /> 학교식 <input type="radio" name="sikGubun" id="ch1" value="T" /> 분임식 </td> </tr> <tr> <th>첨부파일</th> <td colspan="5" class="no"> 1. 사업자등록증 <input type="file" name="file_nm_new01" size="50"> <br /> 2. 교육일정표 <input type="file" name="file_nm_new02" size="50"> </td> </tr> <tr> <th>협조사항</th> <td colspan="5" class="no"> 1. 사업자등록증과 교육일정표는 첨부하시거나 팩스로 송부바랍니다. <br /> 2. 식사인원 변동시 4일전 통보하여 주시고, 미통보시 예약신청 인원으로 정산됩니다. <br /> (단, 예약인원 초과시 실제인원으로 정산) <br /> 3. 본 신청서 접수로 사용계약이 체결됩니다. <br /> (단, 별도 계약이 필요시 연수원으로 연락하여 주시기 바랍니다.) <br /> 4. 시설물 사용부주의로 인한 고장 수리비는 사용자가 부담합니다. <br /> 5. 기타 변동사항이 발생시 교육일 2주전까지 연락바랍니다. <br /> 6. 그외 모든 사항은 이용약관을 참조하시기 바랍니다. </td> </tr> <tr> <td height="2" colspan="6" background="/hanmaum/Image/ha_backc01.gif"></td> </tr> </table> <br /> <br /> <br /> <table width="618" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="center"> <strong> <font size="3pt"> <%= todate.substring(0,4) %> 년 <%= todate.substring(5,7) %> 월 <%= todate.substring(8,10) %> 일 </font> </strong> <br /> <br /> <strong><font size="+2">SCG 그룹 충주 한마음 연수원장 귀중 </font></strong> </td> </tr> </table> <br /> <br /> <table width="618" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="center"> <a href="javascript:onSubmit('Y');"> <img src="/hanmaum/Image/04_but12.gif" alt="" width="107" height="25" hspace="2" border="0" /> </a> <a href="javascript:onReset();"> <img src="/hanmaum/Image/04_but15.gif" alt="" width="107" height="25" hspace="2" border="0" /> </a> <a href="javascript:onSubmit('N');"> <img src="/hanmaum/Image/04_but18.gif" alt="" width="107" height="25" hspace="2" border="0" /> </a> </td> </tr> </table> </td> </tr> <tr> <td><img src="/hanmaum/Image/box_02.gif" alt="" width="680" height="5" /></td> </tr> </table> <!--컨텐츠 끝--> <br /> <div align="right"> <a href="javascript:onAdmin();"> <img src="/hanmaum/Image/04_but01.gif" border="0"/> </a> </div> </td> </tr> </table> </form> <form method="post" name="popup" target="popup"></form> <%@ include file="/hanmaum/bottom.jsp" %> <% 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 >> Exceptionp : " + e.toString()); } %>