<?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="result" />
<jsp:directive.include file="/jsp/custom/result_info.jsp" />
<og:comment
	system	= "GF:エンジンサンプル"
	pgid	= "GF6430"
	title	= "EXCEL変換"
	date	= "2015/06/15"
	author	= "K.Hasegawa"
	text	= ""
	version	= "001"
/>

<og:upload
	fileURL		= "{@USER.ID}"
	maxPostSize = "0"
/>

<og:file fileURL="{@USER.ID}" file1="{@file1}" action="existsLength" >
	<og:message lbl="MSG0064" comment="ファイルが存在していません。" />
	<og:text>fileURL="{@USER.ID}" file1="{@file1}"</og:text>
</og:file>

<!-- この検索結果は、KEYとVALUEの MAPオブジェクトに設定される。 -->
<!-- convMap に渡すMapオブジェクトを作成します。 -->
<og:value command="SQL" action="ALL_MAPOBJ" key="{@convMap}" caseKey="{@useConverter}" caseVal="true" >
	select GENBUN,YAKU
	from  GF28
	where SYSTEM_ID = '{@SYSTEM_ID}'
	and   KEYWORD   = '{@NVL.KEYWORD @file1}'
	and   LANG_YAKU = '{@LANG_YAKU}'
	and   KBYAKU    = '4'
	and   KBHORYU   = '1'
	and   FGJ       = '1'
</og:value>

<og:excelFile
	fileURL				= "{@USER.ID}"
	file1				= "{@file1}"
	file2				= "{@file2}"
	sheetName			= "{@sheetName}"
	sheetNos			= "{@sheetNos}"
	sheetConstKeys		= "{@sheetConstKeys}"
	sheetConstAdrs		= "{@sheetConstAdrs}"
	useActiveWorkbook	= "{@useActiveWorkbook}"
	addTitleSheet		= "{@addTitleSheet}"
	addImageFile		= "{@addImageFile}"
	valueType			= "{@valueType}"
	readText			= "{@readText}"
	readSheet			= "{@readSheet}"
	readName			= "{@readName}"
	readStyle			= "{@readStyle}"
	useConverter		= "{@useConverter}"
	convFile			= "{@convFile}"
	convMap				= "{@convMap}"
	saveAs				= "{@saveAs}"
	toPrint				= "{@toPrint}"
	scope				= "{@scope}"
/>

<pre><og:value command="GET"  key="{@readText}" caseNN="{@readText}"  /></pre>

<table>
	<th><td>Key			</td><td>Param							</td><td>Value																</td></th>
	<tr><td>readSheet	</td><td><og:text>{@readSheet}</og:text></td><td><og:value command="GET" key="{@readSheet}"	caseNN="{@readSheet}" /></td></tr>
	<tr><td>readName	</td><td><og:text>{@readName}</og:text>	</td><td><og:value command="GET" key="{@readName}"	caseNN="{@readName}"  /></td></tr>
	<tr><td>readStyle	</td><td><og:text>{@readStyle}</og:text></td><td><og:value command="GET" key="{@readStyle}"	caseNN="{@readStyle}" /></td></tr>
</table>

<og:link href="{@SYS.CONTEXT_URL}{@SYS.FILE_URL}{@USER.ID}/{@NVL.saveAs @file2 @file1}" target="_blank" useGamenId="false" >
	<img src="{@SYS.JSP}/image/floppy.gif" alt="Excel Open" />
	{@NVL.saveAs @file2 @file1}　　<og:message lbl="MSG0056" />
</og:link>

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