<?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:columnCheck
	command   = "{@command}"
/>

<og:equals val1="{@VERSION}" nullCheck="true">
	<og:value command="SQL">
		SELECT VERSION FROM GF21 GROUP BY VERSION ORDER BY 1 DESC
	</og:value>
</og:equals>

<table>

<!-- GF21 作成 -->
<tr><td>Table Space</td><td>(GF21 XML File)</td><td width="10px"></td><td class="S9">
<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}">
	<jsp:text>
		select	VERSION,PREFIX,TAGNAME,SEQ,TAGCLASS,TEICLASS,BODYCONTENT,FGJ
		from	GF21
		where	VERSION = '{@VERSION}'
		and		FGJ = '1'
		order by PREFIX, TAGNAME
	</jsp:text>
</og:query>

<og:writeTable
	fileURL        = "{@USER.ID}"
	filename       = "GF21.xml"
	writerClass    = "XML"
	encode         = "UTF-8" >
	<og:writeTableParam key="TableName" value="GF21" />
	<og:writeTableParam key="First" >
		<jsp:text>delete from GF21 where VERSION = '{@VERSION}'</jsp:text>
	</og:writeTableParam>
</og:writeTable>

</td></tr>

<!-- GF22 作成 -->
<tr><td>Table Space</td><td>(GF22 XML File)</td><td width="10px"></td><td class="S9">
<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}">
	<jsp:text>
		select	VERSION,PREFIX,TAGNAME,VALUENAME,SEQ,TAGCLASS,REQUIRED,RTEXPRVALUE,TYPE,FGJ
		from	GF22
		where	VERSION = '{@VERSION}'
		and		FGJ = '1'
		order by PREFIX, TAGNAME, VALUENAME
	</jsp:text>
</og:query>

<og:writeTable
	fileURL        = "{@USER.ID}"
	filename       = "GF22.xml"
	writerClass    = "XML"
	encode         = "UTF-8" >
	<og:writeTableParam key="TableName" value="GF22" />
	<og:writeTableParam key="First" >
		<jsp:text>delete from GF22 where VERSION = '{@VERSION}'</jsp:text>
	</og:writeTableParam>
</og:writeTable>

</td></tr>

<!-- GF23 作成 -->
<tr><td>Table Space</td><td>(GF23 XML File)</td><td width="10px"></td><td class="S9">
<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}">
	<jsp:text>
		select	VERSION,TAGCLASS,HTMLEXT,DESCRIPTION,CONTENTS,FORM_SAMPLE,FGJ
		from	GF23
		where	VERSION = '{@VERSION}'
		and		FGJ = '1'
		order by TAGCLASS
	</jsp:text>
</og:query>

<og:writeTable
	fileURL        = "{@USER.ID}"
	filename       = "GF23.xml"
	writerClass    = "XML"
	encode         = "UTF-8" >
	<og:writeTableParam key="TableName" value="GF23" />
	<og:writeTableParam key="First" >
		<jsp:text>delete from GF23 where VERSION = '{@VERSION}'</jsp:text>
	</og:writeTableParam>
</og:writeTable>

</td></tr>

<!-- GF24 作成 -->
<tr><td>Table Space</td><td>(GF24 XML File)</td><td width="10px"></td><td class="S9">
<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}">
	<jsp:text>
		select	VERSION,TAGCLASS,VALUENAME,HTMLEXT,DESCRIPTION,CONTENTS,FGJ
		from	GF24
		where	VERSION = '{@VERSION}'
		and		FGJ = '1'
		order by TAGCLASS,VALUENAME
	</jsp:text>
</og:query>

<og:writeTable
	fileURL        = "{@USER.ID}"
	filename       = "GF24.xml"
	writerClass    = "XML"
	encode         = "UTF-8" >
	<og:writeTableParam key="TableName" value="GF24" />
	<og:writeTableParam key="First" >
		<jsp:text>delete from GF24 where VERSION = '{@VERSION}'</jsp:text>
	</og:writeTableParam>
</og:writeTable>

</td></tr>

<!-- GF25 作成 -->
<tr><td>Table Space</td><td>(GF25 XML File)</td><td width="10px"></td><td class="S9">
<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}">
	<jsp:text>
		select	VERSION,ATTCLASS,SEQ,ATTKEY,VALUENAME,DESCRIPTION,CONTENTS,FORM_SAMPLE,FGJ
		from	GF25
		where	VERSION = '{@VERSION}'
		and		FGJ = '1'
		order by ATTCLASS,ATTKEY
	</jsp:text>
</og:query>

<og:writeTable
	fileURL        = "{@USER.ID}"
	filename       = "GF25.xml"
	writerClass    = "XML"
	encode         = "UTF-8" >
	<og:writeTableParam key="TableName" value="GF25" />
	<og:writeTableParam key="First" >
		<jsp:text>delete from GF25 where VERSION = '{@VERSION}'</jsp:text>
	</og:writeTableParam>
</og:writeTable>

</td></tr>

</table>

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