<?xml version="1.0" encoding="UTF-8" ?>
<jsp:root
	xmlns:jsp="http://java.sun.com/JSP/Page"
	xmlns:og="hybs-taglib.tld" 
	version="2.0">
<jsp:directive.page language="java" contentType="text/html; charset=UTF-8" />

<og:head headType="query" />
<jsp:directive.include file="/jsp/custom/query_info.jsp" />
<og:comment
	system   = "GE:エンジンサンプル"
	pgid     = "REP13"
	title    = "取込EXCEL登録"
	date     = "2007/12/12"
	author   = "K.HASEGAWA"
	text     = "ZZZZ"
	version  = "001"
/>

<form method="GET" action="forward.jsp" target="RESULT" onClick="timeSet();">
<table summary="layout" >
<tr>
	<!-- SYSTEM_IDを検索するメニュー onChangeイベントで再呼び出し -->
	<og:select name="SYSTEM_ID" onChange="renew('query.jsp','QUERY'); " must="true">
		<og:option value="" lbl="" />
		<og:queryOption>
			<jsp:text>
				select SYSTEM_ID from GE54 where FGJ = '1'
				group by SYSTEM_ID order by SYSTEM_ID
			</jsp:text>
		</og:queryOption>
	</og:select>

	<!-- <og:column name="LISTID"    /> -->
	<og:select name="LISTID" onChange="renew('query.jsp','QUERY'); " must="true">
		<og:option lbl="" value="" />
		<og:queryOption defaultVal="{@LISTID}">
			<jsp:text>
				select LISTID,LISTID,LISTNAME
				from GE54
				where SYSTEM_ID = '{@SYSTEM_ID}'
				and   exists ( select * from GE57 where SYSTEM_ID = '{@SYSTEM_ID}' and LISTID = GE54.LISTID )
				and   FGJ = '1'
				order by 1
			</jsp:text>
		</og:queryOption>
	</og:select>

	<!-- -->
	<og:select name="JOKEN" onChange="renew('query.jsp','QUERY'); " must="true">
		<og:option lbl="" value="" />
		<og:queryOption defaultVal="{@JOKEN}">
			<jsp:text>
				select JOKEN,JOKEN,FGRUN,COMMENTS
				from GE53
				where SYSTEM_ID = '{@SYSTEM_ID}'
				and   PRTID     = 'EXCELIN'
				and   FGJ = '1'
				order by 1
			</jsp:text>
		</og:queryOption>
	</og:select>
</tr>
</table>
</form>

<!-- ファイルアップロードなので、enctype="multipart/form-data" で飛ばします。 -->
<form method="POST" action="result.jsp" enctype="multipart/form-data" target="RESULT">
<table>
<tr>
	<og:input type="file" name="file1" size="30" lbl="MSG0015" />
	<og:value key="V_SYSTEM_ID" value="{@SYSTEM_ID}" scope="session" />
	<og:value key="V_LISTID"    value="{@LISTID}"    scope="session" />
	<og:value key="V_JOKEN"     value="{@JOKEN}"     scope="session" />
</tr>
</table>
<og:queryButton type="ENTRY" />
</form>

<jsp:directive.include file="/jsp/common/htmlend.jsp" />
</jsp:root>
