<jsp:directive.page pageEncoding="UTF-8" />
<table>
<!-- DBColumnResource 作成 -->
<tr><td>
<og:link gamenId="GE0003" href="index.jsp" target="CONTENTS" 
	keys="command,SYSTEM_ID,RDC_CODE,RELEASE_NOTES,DYUPDFROM,DYUPDTO,CDKH" 
	vals="NEW,{@SYSTEM_ID},{@RDC_CODE},{@RELEASE_NOTES},{@DYUPDFROM},{@DYUPDTO},{@CDKH}" >{@LBL.GE0003}
</og:link></td>
<td width="100px">GEA03.xml</td>

<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}" dbid="{@DBID}">
		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
		from GEA03
		where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		and   FGJ       = '1'
	<og:where startKey="and">
		<og:and value = "RDC_CODE   = '{@RDC_CODE}'"  />
		<og:and value = "DYUPD  &gt;= '{@DYUPDFROM}'"  />
		<og:and value = "DYUPD  &lt;= '{@DYUPDTO}99'"  />
		<og:and value = "RELEASE_NOTES like '{@RELEASE_NOTES}%'" xssCheck="false" />
		<og:and value = "USRUPD     =    '{@USRUPD}'"  />
		<og:and value = "CDKH {@CDKH}"  />
		<og:and value = "KBSAKU {@CONDITION} '{@KBSAKU}'" xssCheck="false" />
	</og:where>
		order by CLM
</og:query>

<og:writeTable
	fileURL        = "{@DIR}"
	filename       = "GEA03_{@KBSAKU}.xml"
	writerClass    = "XML"
	encode         = "UTF-8" >
	<og:writeTableParam key="TableName" value="GEA03" />
	<og:equals val1="{@RDC_CODE}{@DYUPDFROM}{@DYUPDTO}{@RELEASE_NOTES}{@USRUPD}{@CDKH}" nullCheck="true" >
	  <og:writeTableParam key="First" >
		delete from GEA03 where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		<og:where startKey="and">
			<og:and value = "KBSAKU {@CONDITION} '{@KBSAKU}'" xssCheck="false" />
		</og:where>
	  </og:writeTableParam>
	</og:equals>
</og:writeTable>
<td width="100px"><og:text>{@DB.COUNT}</og:text></td>
</tr>

<!-- CodeResource 作成 -->
<tr><td>
<og:link gamenId="GE0004" href="index.jsp" target="CONTENTS" 
	keys="command,SYSTEM_ID,RDC_CODE,RELEASE_NOTES,DYUPDFROM,DYUPDTO,CDKH" 
	vals="NEW,{@SYSTEM_ID},{@RDC_CODE},{@RELEASE_NOTES},{@DYUPDFROM},{@DYUPDTO},{@CDKH}" >{@LBL.GE0004}
</og:link></td>
<td width="100px">GEA04.xml</td>

<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}" dbid="{@DBID}">
		select SYSTEM_ID,CLM,CODE,SEQNO,KBSAKU,RDC_CODE,RELEASE_NOTES,
				CODEGRP,CODELVL,CODE_PARAM,ROLES,COMMENTS,FGJ
		from GEA04
		where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		and   FGJ       = '1'
	<og:where startKey="and">
		<og:and value = "RDC_CODE   = '{@RDC_CODE}'"  />
		<og:and value = "DYUPD  &gt;= '{@DYUPDFROM}'"  />
		<og:and value = "DYUPD  &lt;= '{@DYUPDTO}99'"  />
		<og:and value = "RELEASE_NOTES like '{@RELEASE_NOTES}%'" />
		<og:and value = "USRUPD     =    '{@USRUPD}'"  />
		<og:and value = "CDKH {@CDKH}"  />
		<og:and value = "KBSAKU {@CONDITION} '{@KBSAKU}'" xssCheck="false" />
	</og:where>
		order by CLM,SEQNO
</og:query>

<og:writeTable
	fileURL        = "{@DIR}"
	filename       = "GEA04_{@KBSAKU}.xml"
	writerClass    = "XML"
	encode         = "UTF-8" >
	<og:writeTableParam key="TableName" value="GEA04" />
	<og:equals val1="{@RDC_CODE}{@DYUPDFROM}{@DYUPDTO}{@RELEASE_NOTES}{@USRUPD}{@CDKH}" nullCheck="true" >
	  <og:writeTableParam key="First" >
		delete from GEA04 where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		<og:where startKey="and">
			<og:and value = "KBSAKU {@CONDITION} '{@KBSAKU}'" xssCheck="false" />
		</og:where>
	  </og:writeTableParam>
	</og:equals>
</og:writeTable>
<td width="100px"><og:text>{@DB.COUNT}</og:text></td>
</tr>

<!-- LabelResource 作成 -->
<tr><td>
<og:link gamenId="GE0005" href="index.jsp" target="CONTENTS" 
	keys="command,SYSTEM_ID,RDC_CODE,RELEASE_NOTES,DYUPDFROM,DYUPDTO,CDKH" 
	vals="NEW,{@SYSTEM_ID},{@RDC_CODE},{@RELEASE_NOTES},{@DYUPDFROM},{@DYUPDTO},{@CDKH}" >{@LBL.GE0005}
</og:link></td>
<td width="100px">GEA08.xml</td>

<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}" dbid="{@DBID}">
		select SYSTEM_ID,LANG,CLM,NAME_JA,SNAME,LNAME,COMMENTS,FGLOAD,KBSAKU,
				DESCRIPTION,KBLBL,RDC_CODE,RELEASE_NOTES,FGJ
		from GEA08
		where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		and   FGJ       = '1'
	<og:where startKey="and">
		<og:and value = "RDC_CODE   = '{@RDC_CODE}'"  />
		<og:and value = "DYUPD  &gt;= '{@DYUPDFROM}'"  />
		<og:and value = "DYUPD  &lt;= '{@DYUPDTO}99'"  />
		<og:and value = "RELEASE_NOTES like '{@RELEASE_NOTES}%'" />
		<og:and value = "USRUPD     =    '{@USRUPD}'"  />
		<og:and value = "CDKH {@CDKH}"  />
		<og:and value = "KBSAKU {@CONDITION} '{@KBSAKU}'" xssCheck="false" />
	</og:where>
		order by LANG,CLM
</og:query>

<og:writeTable
	fileURL        = "{@DIR}"
	filename       = "GEA08_{@KBSAKU}.xml"
	writerClass    = "XML"
	encode         = "UTF-8" >
	<og:writeTableParam key="TableName" value="GEA08" />
	<og:equals val1="{@RDC_CODE}{@DYUPDFROM}{@DYUPDTO}{@RELEASE_NOTES}{@USRUPD}{@CDKH}" nullCheck="true" >
	  <og:writeTableParam key="First" >
		delete from GEA08 where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		<og:where startKey="and">
			<og:and value = "KBSAKU {@CONDITION} '{@KBSAKU}'" xssCheck="false" />
		</og:where>
	  </og:writeTableParam>
	</og:equals>
</og:writeTable>
<td width="100px"><og:text>{@DB.COUNT}</og:text></td>
</tr>

<!-- UserResource 作成 -->
<og:equals val1="{@KBSAKU}" val2="0" >
	<tr><td>
	<og:link gamenId="GE0001" href="index.jsp" target="CONTENTS" 
		keys="command,SYSTEM_ID,RDC_CODE,RELEASE_NOTES,DYUPDFROM,DYUPDTO" 
		vals="NEW,{@SYSTEM_ID},{@RDC_CODE},{@RELEASE_NOTES},{@DYUPDFROM},{@DYUPDTO}" >{@LBL.GE0001}
	</og:link></td>
	<td width="100px">GEA10.xml</td>

	<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}" dbid="{@DBID}">
			select SYSTEM_ID,USERID,PASSWD,LANG,NAME_JA,ROLES,COMMENTS,DYPASSWD,DYVALID,FGDEFAULT,FGJ
			from GEA10
			where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
			and   FGJ       = '1'
			order by USERID
	  </og:query>

	<og:writeTable
		fileURL        = "{@DIR}"
		filename       = "GEA10_{@KBSAKU}.xml"
		writerClass    = "XML"
		encode         = "UTF-8" >
		<og:writeTableParam key="TableName" value="GEA10" />
		<og:writeTableParam key="First" >
			delete from GEA10 where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		</og:writeTableParam>
	</og:writeTable>
	<td width="100px"><og:text>{@DB.COUNT}</og:text></td>
	</tr>
</og:equals>

<!-- GUIResource 作成 -->
<tr><td width="150px">
<og:link gamenId="GE0002" href="index.jsp" target="CONTENTS" 
	keys="command,SYSTEM_ID,RDC_CODE,RELEASE_NOTES,DYUPDFROM,DYUPDTO,CDKH" 
	vals="NEW,{@SYSTEM_ID},{@RDC_CODE},{@RELEASE_NOTES},{@DYUPDFROM},{@DYUPDTO},{@CDKH}" >{@LBL.GE0002}
</og:link></td>
<td width="100px">GEA11.xml</td>

<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}" dbid="{@DBID}">
		select SYSTEM_ID,SEQNO,GUIKEY,GUILVL,NAME_JA,ADDRESS,GROUPS,LABEL_CLM,KBLINK,
				ROLES,RWMODE,TARGET,PARAM,KBSAKU,COMMENTS,RDC_CODE,RELEASE_NOTES,FGJ
		from GEA11
		where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		and   FGJ       = '1'
	<og:where startKey="and">
		<og:and value = "RDC_CODE   = '{@RDC_CODE}'"  />
		<og:and value = "DYUPD  &gt;= '{@DYUPDFROM}'"  />
		<og:and value = "DYUPD  &lt;= '{@DYUPDTO}99'"  />
		<og:and value = "RELEASE_NOTES like '{@RELEASE_NOTES}%'" />
		<og:and value = "USRUPD     =    '{@USRUPD}'"  />
		<og:and value = "CDKH {@CDKH}"  />
		<og:and value = "KBSAKU {@CONDITION} '{@KBSAKU}'" xssCheck="false" />
	</og:where>
		order by SEQNO
</og:query>

<og:writeTable
	fileURL        = "{@DIR}"
	filename       = "GEA11_{@KBSAKU}.xml"
	writerClass    = "XML"
	encode         = "UTF-8" >
	<og:writeTableParam key="TableName" value="GEA11" />
	<og:equals val1="{@RDC_CODE}{@DYUPDFROM}{@DYUPDTO}{@RELEASE_NOTES}{@USRUPD}{@CDKH}" nullCheck="true" >
	  <og:writeTableParam key="First" >
		delete from GEA11 where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		<og:where startKey="and">
			<og:and value = "KBSAKU {@CONDITION} '{@KBSAKU}'" xssCheck="false" />
			</og:where>
	  </og:writeTableParam>
	</og:equals>
</og:writeTable>
<td width="100px"><og:text>{@DB.COUNT}</og:text></td>
</tr>

<!-- SystemResource 作成 -->
<tr>
	<td width="150px">
	<og:link gamenId="GE0007" href="index.jsp" target="CONTENTS" 
		keys="command,SYSTEM_ID,RDC_CODE,RELEASE_NOTES,DYUPDFROM,DYUPDTO" 
		vals="NEW,{@SYSTEM_ID},{@RDC_CODE},{@RELEASE_NOTES},{@DYUPDFROM},{@DYUPDTO}" >{@LBL.GE0007}
	</og:link></td>
	<td width="100px">GE12.xml</td>

	<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}" dbid="{@DBID}">
			select SYSTEM_ID,PARAM_ID,SEQNO,TITLE,PARAM,CONTENTS,PARAM_LVL,KBSAKU,
					FGCRYPT,CONTXT_PATH,FGREBOOT,FGJ
			from GE12
			where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
			and   FGJ       = '1'
			<og:where startKey="and">
				<og:and value = "KBSAKU {@CONDITION} '{@KBSAKU}'" xssCheck="false" />
			</og:where>
			order by SEQNO
	</og:query>

	<og:writeTable
		fileURL        = "{@DIR}"
		filename       = "GE12_{@KBSAKU}.xml"
		writerClass    = "XML"
		encode         = "UTF-8" >
		<og:writeTableParam key="TableName" value="GE12" />
		<og:writeTableParam key="First" >
			delete from GE12 where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
			<og:where startKey="and">
				<og:and value = "KBSAKU {@CONDITION} '{@KBSAKU}'" xssCheck="false" />
			</og:where>
		</og:writeTableParam>
	</og:writeTable>
	<td width="100px"><og:text>{@DB.COUNT}</og:text></td>
</tr>

</table>
