<?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	= "GF6200"
	title	= "レポート出力(Excel)"
	date	= "2008/10/27"
	author	= "Hiroki.Nakamura"
	text	= ""
	version	= "001"
/>

<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}">
		select * from GF41
	<og:where>
		<og:and value = "SYSTEM_ID  = '{@SYSTEM_ID}'" />
		<og:and value = "FGJ        = '1'"            />
	</og:where>
		order by SYSTEM_ID,CLM,KBSAKU,LANG
</og:query>

<og:report  debug="{@debug}" 
	headerKeys     = "HKEY1,HKEY2,HKEY3,HKEY4,HKEY5"
	headerVals     = "{@HKEY1},{@HKEY2},{@HKEY3},{@HKEY4},{@HKEY5}"
	footerKeys     = "FKEY1,FKEY2,FKEY3,FKEY4,FKEY5"
	footerVals     = "{@FKEY1},{@FKEY2},{@FKEY3},{@FKEY4},{@FKEY5}"
	fileURL        = "{@MODELDIR}"
	listId         = "{@LISTID}"
	outFileURL     = "{@OUTDIR}"
	outFilename    = "{@OUTFILE}"
	programFile    = "{@SYS.REAL_PATH}def/Script/runExcelPrint.bat"
	pageEndCut     = "{@pageEndCut}"
	reportClass    = "{@reportClass}" />

<og:forward page="{@SYS.JSP}/fileDownload" keys="file" vals="{@OUTDIR}/{@OUTFILE}" useRedirect="true" />

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