<jsp:directive.page pageEncoding="UTF-8" />
<table>
<!-- UserResource 作成 -->
<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>

<!-- 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>
