<?xml version="1.0" encoding="UTF-8" ?>
<jsp:directive.page pageEncoding="UTF-8" />

<style type="text/css">
	table.wd100 td { width: 100px;}
</style>

<table class="wd100">
	<!-- ｶﾗﾑ GEA03 GE0003 -->
	<tr>
		<td>
			<og:link gamenId="GE0003" href="index.jsp" target="CONTENTS"
				keys="command,SYSTEM_ID,RDC_CODE,RELEASE_NOTES,USRUPD,DYUPDFROM,DYUPDTO,CDKH,LANG,FGJ"
				vals="NEW,{@SYSTEM_ID},{@RDC_CODE},{@RELEASE_NOTES},{@USRUPD},{@DYUPDFROM},{@DYUPDTO},{@CDKH},ja,{@FGJ}" >{@LBL.GE0003}
			</og:link>
		</td>
		<td>GEA03.xml</td><td id="GEA03"></td>
	</tr>

	<!-- ｺｰﾄﾞ GEA04 GE0004 -->
	<tr>
		<td>
			<og:link gamenId="GE0004" href="index.jsp" target="CONTENTS"
				keys="command,SYSTEM_ID,RDC_CODE,RELEASE_NOTES,USRUPD,DYUPDFROM,DYUPDTO,CDKH,LANG,FGJ"
				vals="NEW,{@SYSTEM_ID},{@RDC_CODE},{@RELEASE_NOTES},{@USRUPD},{@DYUPDFROM},{@DYUPDTO},{@CDKH},ja,{@FGJ}" >{@LBL.GE0004}
			</og:link>
		</td>
		<td>GEA04.xml</td><td id="GEA04"></td>
	</tr>

	<!-- ﾗﾍﾞﾙ GEA08 GE0005 -->
	<tr>
		<td>
			<og:link gamenId="GE0005" href="index.jsp" target="CONTENTS"
				keys="command,SYSTEM_ID,RDC_CODE,RELEASE_NOTES,USRUPD,DYUPDFROM,DYUPDTO,CDKH,FGJ"
				vals="NEW,{@SYSTEM_ID},{@RDC_CODE},{@RELEASE_NOTES},{@USRUPD},{@DYUPDFROM},{@DYUPDTO},{@CDKH},{@FGJ}" >{@LBL.GE0005}
			</og:link>
		</td>
		<td>GEA08.xml</td><td id="GEA08"></td>
	</tr>

	<!-- 画面 GEA11 GE0002 -->
	<tr>
		<td>
			<og:link gamenId="GE0002" href="index.jsp" target="CONTENTS"
				keys="command,SYSTEM_ID,RDC_CODE,RELEASE_NOTES,USRUPD,DYUPDFROM,DYUPDTO,CDKH,LANG,FGJ"
				vals="NEW,{@SYSTEM_ID},{@RDC_CODE},{@RELEASE_NOTES},{@USRUPD},{@DYUPDFROM},{@DYUPDTO},{@CDKH},ja,{@FGJ}" >{@LBL.GE0002}
			</og:link>
		</td>
		<td>GEA11.xml</td><td id="GEA11"></td>
	</tr>
</table>
=============================================================================<br />

<!-- ｶﾗﾑ GEA03 GE0003 -->
<og:text caseNN="{@VIEW}">******************** GEA03 {@LBL.GEA03} ********************</og:text>
	<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}" dbid="{@DBID}" notfoundMsg="">
		select SYSTEM_ID,CLM,NAME_JA,CLS_NAME,USE_LENGTH,VIEW_LENGTH,RENDERER,EDITOR,DBTYPE,
		DATA_DEFAULT,LABEL_CLM,CODE_CLM,RENDERER_PARAM,EDITOR_PARAM,TYPE_PARAM,
		COMMENTS,FGLOAD,KBSAKU,ROLES,CLM_PARAM,RDC_CODE,RELEASE_NOTES,FGJ,
		DYSET,DYUPD,USRSET,USRUPD,PGSET,PGUPD
		from GEA03
		where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		<og:where startKey="and">
			<og:and value = "CDKH {@CDKH}"  />
			<og:and value = "KBSAKU = '{@KBSAKU}'" />
			<jsp:directive.include file="/jsp/custom/releaseNotesWhere.jsp" />
		</og:where>
		order by CLM
	</og:query>

	<og:value action="ADD" key="DBCNT" value="{@DBCNT}" defaultVal="{@DB.COUNT}" />

	<script type="text/javascript">
		gea03 = document.getElementById("GEA03");
		gea03.textContent = "<og:text>{@DB.COUNT}</og:text>";
	</script>

	<og:view command="{@command}" selectedType="none" useScrollBar="false" pageSize="{@pageSize}" caseNN="{@VIEW}" />

	<og:writeTable
		fileURL		= "{@DIR}"
		filename	= "GEA03_{@KBSAKU}.xml"
		writerClass	= "XML"
		encode		= "UTF-8" >
		<og:writeTableParam key="TableName" value="GEA03" />
		<og:equals val1="{@EXT_SQL}" val2="DELETE" >
			<og:writeTableParam key="First" >
				delete from GEA03 where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
				<og:where startKey="and">
				<og:and value = "KBSAKU = '{@KBSAKU}'" />
				</og:where>
			</og:writeTableParam>
		</og:equals>
		<og:equals val1="{@EXT_SQL}" val2="MERGE" >
			<og:writeTableParam key="MergeSql" >
				update GEA03
				set
					NAME_JA			= [NAME_JA]
				,	CLS_NAME		= [CLS_NAME]
				,	USE_LENGTH		= [USE_LENGTH]
				,	VIEW_LENGTH		= [VIEW_LENGTH]
				,	RENDERER		= [RENDERER]
				,	EDITOR			= [EDITOR]
				,	DBTYPE			= [DBTYPE]
				,	DATA_DEFAULT	= [DATA_DEFAULT]
				,	LABEL_CLM		= [LABEL_CLM]
				,	CODE_CLM		= [CODE_CLM]
				,	RENDERER_PARAM	= [RENDERER_PARAM]
				,	EDITOR_PARAM	= [EDITOR_PARAM]
				,	TYPE_PARAM		= [TYPE_PARAM]
				,	COMMENTS		= [COMMENTS]
				,	CDKH			= [CDKH]
				,	FGLOAD			= [FGLOAD]
				,	ROLES			= [ROLES]
				,	CLM_PARAM		= [CLM_PARAM]
				,	RDC_CODE		= [RDC_CODE]
				,	RELEASE_NOTES	= [RELEASE_NOTES]
				,	FGJ				= [FGJ]
				,	DYSET			= [DYSET]
				,	DYUPD			= [DYUPD]
				,	USRSET			= [USRSET]
				,	USRUPD			= [USRUPD]
				,	PGSET			= [PGSET]
				,	PGUPD			= [PGUPD]
				where	SYSTEM_ID	= [SYSTEM_ID]
				and		CLM			= [CLM]
				and		KBSAKU		= [KBSAKU]
			</og:writeTableParam>
		</og:equals>
	</og:writeTable>

<!-- ｺｰﾄﾞ GEA04 GE0004 -->
<og:text caseNN="{@VIEW}">******************** GEA04 {@LBL.GEA04} ********************</og:text>
	<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}" dbid="{@DBID}" notfoundMsg="">
		select SYSTEM_ID,CLM,CODE,SEQNO,KBSAKU,RDC_CODE,RELEASE_NOTES,
				CODEGRP,CODELVL,CODE_PARAM,ROLES,COMMENTS,FGJ,
			DYSET,DYUPD,USRSET,USRUPD,PGSET,PGUPD
		from GEA04
		where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		<og:where startKey="and">
			<og:and value = "CDKH {@CDKH}"  />
			<og:and value = "KBSAKU = '{@KBSAKU}'" />
			<jsp:directive.include file="/jsp/custom/releaseNotesWhere.jsp" />
		</og:where>
		order by CLM,SEQNO
	</og:query>

	<og:value action="ADD" key="DBCNT" value="{@DBCNT}" defaultVal="{@DB.COUNT}" />

	<script type="text/javascript">
		gea04 = document.getElementById("GEA04");
		gea04.textContent = "<og:text>{@DB.COUNT}</og:text>";
	</script>

	<og:view command="{@command}" selectedType="none" useScrollBar="false" pageSize="{@pageSize}" caseNN="{@VIEW}" />

	<og:writeTable
		fileURL		= "{@DIR}"
		filename	= "GEA04_{@KBSAKU}.xml"
		writerClass	= "XML"
		encode		= "UTF-8" >
		<og:writeTableParam key="TableName" value="GEA04" />
		<og:equals val1="{@EXT_SQL}" val2="DELETE" >
			<og:writeTableParam key="First" >
				delete from GEA04 where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
				<og:where startKey="and">
					<og:and value = "CDKH {@CDKH}"  />
					<og:and value = "KBSAKU = '{@KBSAKU}'" />
				</og:where>
			</og:writeTableParam>
		</og:equals>
		<og:equals val1="{@EXT_SQL}" val2="MERGE" >
			<og:writeTableParam key="MergeSql" >
				update GEA04
				set
					SEQNO			= [SEQNO]
				,	CODEGRP			= [CODEGRP]
				,	CODELVL			= [CODELVL]
				,	CODE_PARAM		= [CODE_PARAM]
				,	ROLES			= [ROLES]
				,	COMMENTS		= [COMMENTS]
				,	CDKH			= [CDKH]
				,	RDC_CODE		= [RDC_CODE]
				,	RELEASE_NOTES	= [RELEASE_NOTES]
				,	FGJ				= [FGJ]
				,	DYSET			= [DYSET]
				,	DYUPD			= [DYUPD]
				,	USRSET			= [USRSET]
				,	USRUPD			= [USRUPD]
				,	PGSET			= [PGSET]
				,	PGUPD			= [PGUPD]
				where	SYSTEM_ID	= [SYSTEM_ID]
				and		CLM			= [CLM]
				and		CODE		= [CODE]
				and		KBSAKU		= [KBSAKU]
			</og:writeTableParam>
		</og:equals>
	</og:writeTable>

<!-- ﾗﾍﾞﾙ GEA08 GE0005 -->
<og:text caseNN="{@VIEW}">******************** GEA08 {@LBL.GEA08} ********************</og:text>
	<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}" dbid="{@DBID}" notfoundMsg="">
		select SYSTEM_ID,LANG,CLM,NAME_JA,SNAME,LNAME,COMMENTS,FGLOAD,KBSAKU,
				DESCRIPTION,KBLBL,RDC_CODE,RELEASE_NOTES,FGJ,
				DYSET,DYUPD,USRSET,USRUPD,PGSET,PGUPD
		from GEA08
		where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		<og:where startKey="and">
			<og:and value = "CDKH {@CDKH}"  />
			<og:and value = "KBSAKU = '{@KBSAKU}'" />
			<jsp:directive.include file="/jsp/custom/releaseNotesWhere.jsp" />
		</og:where>
		order by LANG,CLM
	</og:query>

	<og:value action="ADD" key="DBCNT" value="{@DBCNT}" defaultVal="{@DB.COUNT}" />

	<script type="text/javascript">
		gea08 = document.getElementById("GEA08");
		gea08.textContent = "<og:text>{@DB.COUNT}</og:text>";
	</script>

	<og:view command="{@command}" selectedType="none" useScrollBar="false" pageSize="{@pageSize}" caseNN="{@VIEW}" />

	<og:writeTable
		fileURL		= "{@DIR}"
		filename	= "GEA08_{@KBSAKU}.xml"
		writerClass	= "XML"
		encode		= "UTF-8" >
		<og:writeTableParam key="TableName" value="GEA08" />
		<og:equals val1="{@EXT_SQL}" val2="DELETE" >
			<og:writeTableParam key="First" >
				delete from GEA08 where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
				<og:where startKey="and">
					<og:and value = "CDKH {@CDKH}"  />
					<og:and value = "KBSAKU = '{@KBSAKU}'" />
				</og:where>
			</og:writeTableParam>
		</og:equals>
		<og:equals val1="{@EXT_SQL}" val2="MERGE" >
			<og:writeTableParam key="MergeSql" >
				update GEA08
				set
					NAME_JA			= [NAME_JA]
				,	SNAME			= [SNAME]
				,	LNAME			= [LNAME]
				,	COMMENTS		= [COMMENTS]
				,	CDKH			= [CDKH]
				,	FGLOAD			= [FGLOAD]
				,	DESCRIPTION		= [DESCRIPTION]
				,	KBLBL			= [KBLBL]
				,	RDC_CODE		= [RDC_CODE]
				,	RELEASE_NOTES	= [RELEASE_NOTES]
				,	FGJ				= [FGJ]
				,	DYSET			= [DYSET]
				,	DYUPD			= [DYUPD]
				,	USRSET			= [USRSET]
				,	USRUPD			= [USRUPD]
				,	PGSET			= [PGSET]
				,	PGUPD			= [PGUPD]
				where	SYSTEM_ID	= [SYSTEM_ID]
				and		LANG		= [LANG]
				and		CLM			= [CLM]
				and		KBSAKU		= [KBSAKU]
			</og:writeTableParam>
		</og:equals>
	</og:writeTable>

<!-- 画面 GEA11 GE0002 -->
<og:text caseNN="{@VIEW}">******************** GEA11 {@LBL.GEA11} ********************</og:text>
	<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}" dbid="{@DBID}" notfoundMsg="">
		select SYSTEM_ID,SEQNO,GUIKEY,GUILVL,NAME_JA,ADDRESS,GROUPS,LABEL_CLM,KBLINK,
				ROLES,RWMODE,TARGET,PARAM,KBSAKU,COMMENTS,RDC_CODE,RELEASE_NOTES,FGJ,
				DYSET,DYUPD,USRSET,USRUPD,PGSET,PGUPD
		from GEA11
		where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
	<og:where startKey="and">
		<og:and value = "CDKH {@CDKH}"  />
		<og:and value = "KBSAKU = '{@KBSAKU}'" />
		<jsp:directive.include file="/jsp/custom/releaseNotesWhere.jsp" />
	</og:where>
		order by SEQNO
	</og:query>

	<og:value action="ADD" key="DBCNT" value="{@DBCNT}" defaultVal="{@DB.COUNT}" />

	<script type="text/javascript">
		gea11 = document.getElementById("GEA11");
		gea11.textContent = "<og:text>{@DB.COUNT}</og:text>";
	</script>

	<og:view command="{@command}" selectedType="none" useScrollBar="false" pageSize="{@pageSize}" caseNN="{@VIEW}" />

	<og:writeTable
		fileURL		= "{@DIR}"
		filename	= "GEA11_{@KBSAKU}.xml"
		writerClass	= "XML"
		encode		= "UTF-8" >
		<og:writeTableParam key="TableName" value="GEA11" />
		<og:equals val1="{@EXT_SQL}" val2="DELETE" >
			<og:writeTableParam key="First" >
				delete from GEA11 where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
				<og:where startKey="and">
				<og:and value = "KBSAKU = '{@KBSAKU}'" />
					</og:where>
			</og:writeTableParam>
		</og:equals>
		<og:equals val1="{@EXT_SQL}" val2="MERGE" >
			<og:writeTableParam key="MergeSql" >
				update GEA11
				set
					SEQNO			= [SEQNO]
				,	GUILVL			= [GUILVL]
				,	NAME_JA			= [NAME_JA]
				,	GROUPS			= [GROUPS]
				,	LABEL_CLM		= [LABEL_CLM]
				,	KBLINK			= [KBLINK]
				,	RWMODE			= [RWMODE]
				,	TARGET			= [TARGET]
				,	PARAM			= [PARAM]
				,	COMMENTS		= [COMMENTS]
				,	CDKH			= [CDKH]
				,	RDC_CODE		= [RDC_CODE]
				,	RELEASE_NOTES	= [RELEASE_NOTES]
				,	FGJ				= [FGJ]
				,	DYSET			= [DYSET]
				,	DYUPD			= [DYUPD]
				,	USRSET			= [USRSET]
				,	USRUPD			= [USRUPD]
				,	PGSET			= [PGSET]
				,	PGUPD			= [PGUPD]
				where	SYSTEM_ID	= [SYSTEM_ID]
				and		GUIKEY		= [GUIKEY]
				and		CONCAT(ADDRESS,'x')=CONCAT([ADDRESS],'x')
				and		KBSAKU		= [KBSAKU]
			</og:writeTableParam>
		</og:equals>
	</og:writeTable>
