<?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">
	<!-- 帳票ﾚｲｱｳﾄﾃｰﾌﾞﾙ GE52 REP03 -->
	<tr>
		<td>
			<og:link gamenId="REP03" href="index.jsp" target="CONTENTS"
				keys="command,SYSTEM_ID,RDC_CODE,RELEASE_NOTES,USRUPD,DYUPDFROM,DYUPDTO,FGJ"
				vals="NEW,{@SYSTEM_ID},{@RDC_CODE},{@RELEASE_NOTES},{@USRUPD},{@DYUPDFROM},{@DYUPDTO},{@FGJ}" >{@LBL.REP03}
			</og:link>
		</td>
		<td>GE52.xml</td><td id="GE52"></td>
	</tr>

	<!-- 振分条件ﾏｽﾀ GE53 REP04 -->
	<tr>
		<td>
			<og:link gamenId="REP04" href="index.jsp" target="CONTENTS"
				keys="command,SYSTEM_ID,RDC_CODE,RELEASE_NOTES,USRUPD,DYUPDFROM,DYUPDTO,FGJ"
				vals="NEW,{@SYSTEM_ID},{@RDC_CODE},{@RELEASE_NOTES},{@USRUPD},{@DYUPDFROM},{@DYUPDTO},{@FGJ}" >{@LBL.REP04}
			</og:link>
		</td>
		<td>GE53.xml</td><td id="GE53"></td>
	</tr>

	<!-- 帳票定義ﾏｽﾀ GE54 REP05 -->
	<tr>
		<td>
			<og:link gamenId="REP05" href="index.jsp" target="CONTENTS"
				keys="command,SYSTEM_ID,RDC_CODE,RELEASE_NOTES,USRUPD,DYUPDFROM,DYUPDTO,FGJ"
				vals="NEW,{@SYSTEM_ID},{@RDC_CODE},{@RELEASE_NOTES},{@USRUPD},{@DYUPDFROM},{@DYUPDTO},{@FGJ}" >{@LBL.REP05}
			</og:link>
		</td>
		<td>GE54.xml</td><td id="GE54"></td>
	</tr>

	<!-- 出力先ﾏｽﾀ GE55 REP06 -->
	<tr>
		<td>
			<og:link gamenId="REP06" href="index.jsp" target="CONTENTS"
				keys="command,SYSTEM_ID,RDC_CODE,RELEASE_NOTES,USRUPD,DYUPDFROM,DYUPDTO,FGJ"
				vals="NEW,{@SYSTEM_ID},{@RDC_CODE},{@RELEASE_NOTES},{@USRUPD},{@DYUPDFROM},{@DYUPDTO},{@FGJ}" >{@LBL.REP06}
			</og:link>
		</td>
		<td>GE55.xml</td><td id="GE55"></td>
	</tr>

	<!-- 雛形明細定義ﾃｰﾌﾞﾙ GE57 REP11 -->
	<tr>
		<td>
			<og:link gamenId="REP11" href="index.jsp" target="CONTENTS"
				keys="command,SYSTEM_ID,RDC_CODE,RELEASE_NOTES,USRUPD,DYUPDFROM,DYUPDTO,FGJ"
				vals="NEW,{@SYSTEM_ID},{@RDC_CODE},{@RELEASE_NOTES},{@USRUPD},{@DYUPDFROM},{@DYUPDTO},{@FGJ}" >{@LBL.REP11}
			</og:link>
		</td>
		<td>GE57.xml</td><td id="GE57"></td>
	</tr>
</table>
=============================================================================<br />

<!-- 帳票ﾚｲｱｳﾄﾃｰﾌﾞﾙ GE52 REP03 -->
<og:text caseNN="{@VIEW}">******************** GE52 {@LBL.GE52} ********************</og:text>
	<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}" dbid="{@DBID}" notfoundMsg="">
		select LISTID,KBTEXT,CLM,SEQ,START_POS,USE_LENGTH,FGUSE,RDC_CODE,RELEASE_NOTES,SYSTEM_ID,
			FGJ,DYSET,DYUPD,USRSET,USRUPD,PGSET,PGUPD
		from GE52
		where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		<og:where startKey="and">
			<jsp:directive.include file="/jsp/custom/releaseNotesWhere.jsp" />
		</og:where>
		order by SYSTEM_ID,LISTID,KBTEXT,SEQ
	</og:query>

	<script type="text/javascript">
		ge52 = document.getElementById("GE52");
		ge52.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       = "GE52.xml"
		writerClass    = "XML"
		encode         = "UTF-8" >
		<og:writeTableParam key="TableName" value="GE52" />
		<og:equals val1="{@EXT_SQL}" val2="DELETE" >
			<og:writeTableParam key="First" >
				delete from GE52 where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
				<og:where startKey="and"><og:and value = "RDC_CODE='{@RDC_CODE}'" /></og:where>
			</og:writeTableParam>
		</og:equals>
		<og:equals val1="{@EXT_SQL}" val2="MERGE" >
		  <og:writeTableParam key="MergeSql" >
			update GE52
			set
				SEQ				= [SEQ]
			,	START_POS		= [START_POS]
			,	USE_LENGTH		= [USE_LENGTH]
			,	FGUSE			= [FGUSE]
			,	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		LISTID		= [LISTID]
			and		KBTEXT		= [KBTEXT]
			and		CLM			= [CLM]
		  </og:writeTableParam>
		</og:equals>
	</og:writeTable>

<!-- 振分条件ﾏｽﾀ GE53 REP04 -->
<og:text caseNN="{@VIEW}">******************** GE53 {@LBL.GE53} ********************</og:text>
	<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}" dbid="{@DBID}" notfoundMsg="">
		select JOKEN,PRTID,FGRUN,DMN_GRP,PRGDIR,PRGFILE,COMMENTS,SYSTEM_ID,LANG,DMN_TIME,RDC_CODE,RELEASE_NOTES,
			FGJ,DYSET,DYUPD,USRSET,USRUPD,PGSET,PGUPD
		from GE53
		where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		<og:where startKey="and">
			<jsp:directive.include file="/jsp/custom/releaseNotesWhere.jsp" />
		</og:where>
		order by SYSTEM_ID,JOKEN
	</og:query>

	<script type="text/javascript">
		ge53 = document.getElementById("GE53");
		ge53.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       = "GE53.xml"
		writerClass    = "XML"
		encode         = "UTF-8" >
		<og:writeTableParam key="TableName" value="GE53" />
		<og:equals val1="{@EXT_SQL}" val2="DELETE" >
			<og:writeTableParam key="First" >
				delete from GE53 where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
				<og:where startKey="and"><og:and value = "RDC_CODE='{@RDC_CODE}'" /></og:where>
			</og:writeTableParam>
		</og:equals>
		<og:equals val1="{@EXT_SQL}" val2="MERGE" >
		  <og:writeTableParam key="MergeSql" >
			update GE53
			set
				PRTID			= [PRTID]
			,	FGRUN			= [FGRUN]
			,	DMN_GRP 		= [DMN_GRP]
			,	PRGDIR			= [PRGDIR]
			,	PRGFILE 		= [PRGFILE]
			,	COMMENTS		= [COMMENTS]
			,	LANG			= [LANG]
			,	DMN_TIME		= [DMN_TIME]
			,	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		JOKEN		= [JOKEN]
		  </og:writeTableParam>
		</og:equals>
	</og:writeTable>

<!-- 帳票定義ﾏｽﾀ GE54 REP05 -->
<og:text caseNN="{@VIEW}">******************** GE54 {@LBL.GE54} ********************</og:text>
	<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}" dbid="{@DBID}" notfoundMsg="">
		select LISTID,LISTNAME,MODELDIR,MODELFILE,FGCUT,HSQL,FSQL,BSQL,COMMENTS,FGLOCAL,OPTIONS,RDC_CODE,RELEASE_NOTES,SYSTEM_ID,
				FGJ,DYSET,DYUPD,USRSET,USRUPD,PGSET,PGUPD
		from GE54
		where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		<og:where startKey="and">
			<jsp:directive.include file="/jsp/custom/releaseNotesWhere.jsp" />
		</og:where>
		order by SYSTEM_ID,LISTID
	</og:query>

	<script type="text/javascript">
		ge54 = document.getElementById("GE54");
		ge54.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       = "GE54.xml"
		writerClass    = "XML"
		encode         = "UTF-8" >
		<og:writeTableParam key="TableName" value="GE54" />
		<og:equals val1="{@EXT_SQL}" val2="DELETE" >
			<og:writeTableParam key="First" >
				delete from GE54 where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
				<og:where startKey="and"><og:and value = "RDC_CODE='{@RDC_CODE}'" /></og:where>
			</og:writeTableParam>
		</og:equals>
		<og:equals val1="{@EXT_SQL}" val2="MERGE" >
		  <og:writeTableParam key="MergeSql" >
			update GE54
			set
				LISTNAME		= [LISTNAME]
			,	MODELDIR		= [MODELDIR]
			,	MODELFILE		= [MODELFILE]
			,	FGCUT			= [FGCUT]
			,	HSQL			= [HSQL]
			,	FSQL			= [FSQL]
			,	BSQL			= [BSQL]
			,	COMMENTS		= [COMMENTS]
			,	FGLOCAL 		= [FGLOCAL]
			,	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		LISTID		= [LISTID]
		  </og:writeTableParam>
		</og:equals>
	</og:writeTable>

<!-- 出力先ﾏｽﾀ GE55 REP06 -->
<og:text caseNN="{@VIEW}">******************** GE55 {@LBL.GE55} ********************</og:text>
	<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}" dbid="{@DBID}" notfoundMsg="">
		select PRTID,PRTNM,PORTNM,COMMENTS,SYSTEM_ID,RDC_CODE,RELEASE_NOTES,
			FGJ,DYSET,DYUPD,USRSET,USRUPD,PGSET,PGUPD
		from GE55
		where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		<og:where startKey="and">
			<jsp:directive.include file="/jsp/custom/releaseNotesWhere.jsp" />
		</og:where>
		order by SYSTEM_ID,PRTID
	</og:query>

	<script type="text/javascript">
		ge55 = document.getElementById("GE55");
		ge55.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       = "GE55.xml"
		writerClass    = "XML"
		encode         = "UTF-8" >
		<og:writeTableParam key="TableName" value="GE55" />
		<og:equals val1="{@EXT_SQL}" val2="DELETE" >
			<og:writeTableParam key="First" >
				delete from GE55 where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
				<og:where startKey="and"><og:and value = "RDC_CODE='{@RDC_CODE}'" /></og:where>
			</og:writeTableParam>
		</og:equals>
		<og:equals val1="{@EXT_SQL}" val2="MERGE" >
		  <og:writeTableParam key="MergeSql" >
			update GE55
			set
				PRTNM			= [PRTNM]
			,	PORTNM			= [PORTNM]
			,	COMMENTS		= [COMMENTS]
			,	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		PRTID		= [PRTID]
		  </og:writeTableParam>
		</og:equals>
	</og:writeTable>

<!-- 雛形明細定義ﾃｰﾌﾞﾙ GE57 REP11 -->
<og:text caseNN="{@VIEW}">******************** GE57 {@LBL.GE57} ********************</og:text>
	<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}" dbid="{@DBID}" notfoundMsg="">
		select LISTID,SHEETNO,SHEETREF,HEADDBID,BODYDBID,LOOPCLM,SYSTEM_ID,RDC_CODE,RELEASE_NOTES,
				FGJ,DYSET,DYUPD,USRSET,USRUPD,PGSET,PGUPD
		from GE57
		where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		<og:where startKey="and">
			<jsp:directive.include file="/jsp/custom/releaseNotesWhere.jsp" />
		</og:where>
		order by SYSTEM_ID,LISTID,SHEETNO
	</og:query>

	<script type="text/javascript">
		ge57 = document.getElementById("GE57");
		ge57.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       = "GE57.xml"
		writerClass    = "XML"
		encode         = "UTF-8" >
		<og:writeTableParam key="TableName" value="GE57" />
		<og:equals val1="{@EXT_SQL}" val2="DELETE" >
			<og:writeTableParam key="First" >
				delete from GE57 where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
				<og:where startKey="and"><og:and value = "RDC_CODE='{@RDC_CODE}'" /></og:where>
			</og:writeTableParam>
		</og:equals>
		<og:equals val1="{@EXT_SQL}" val2="MERGE" >
		  <og:writeTableParam key="MergeSql" >
			update GE57
			set
				SHEETREF		= [SHEETREF]
			,	HEADDBID		= [HEADDBID]
			,	BODYDBID		= [BODYDBID]
			,	LOOPCLM 		= [LOOPCLM]
			,	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		LISTID		= [LISTID]
			and		SHEETNO		= [SHEETNO]
		  </og:writeTableParam>
		</og:equals>
	</og:writeTable>
