<?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="query" />
<jsp:directive.include file="/jsp/custom/query_info.jsp" />
<og:comment
	system	= "GF:エンジンサンプル"
	pgid	= "GF6240"
	title	= "IOr連携"
	date	= "2021/11/30"
	author	= "LEE.M"
	text	= ""
	version	= "001"
/>

<!-- POSTの評価をしたいので、result.jsp を直接呼び出します。 -->
<form method="POST" action="result.jsp" target="RESULT" onSubmit="timeSet();">
	<table>
		<tr>
			<og:column name="authURL"	must="true" colspan="3" size="50" />
			<og:column name="userId"	must="true" />
			<og:column name="password"	must="true" />
		</tr>
		<tr>
			<og:column name="report_name" lbl="アプリ名" must="true" />
			<og:column name="method" lbl="メソッド" must="true" />
			<og:column name="proxyHost" defaultVal="{@SYS.HTTP_PROXY_HOST}" />
			<og:column name="proxyPort" defaultVal="{@SYS.HTTP_PROXY_PORT}" />
		</tr>
		<tr>
			<og:select name="process" >
				<og:option value="select"	lbl="IOr検索"	/>
				<og:option value="update"	lbl="IOr登録"	/>
				<og:option value="sql"		lbl="JSON取得"	/>
			</og:select>
			<og:column name="ior_url" lbl="url" must="true" colspan="6" size="60" >(登録、検索兼用)</og:column>
		</tr>

	</table>
	<table>
		<tr>
			<td>
			<og:fieldset lbl="検索ﾊﾟﾗﾒｰﾀ用:" defaultNone="false" >
				<table>
					<tr>
						<td>select句</td>
						<og:column name="SEL" lbl="検索項目" size="50" colspan="6" />
					</tr>
					<tr>
						<td>where句</td>
						<og:column name="TANTO" lbl="担当者" aimai="V*" size="5" />
						<og:column name="TANI" lbl="単位" aimai="V*" size="5" />
						<og:column name="DYNK_F" lbl="入出庫日" size="5" >
							<og:message lbl="KARA" comment="～" />
							<og:column name="DYNK_T" td="false" size="5" />
						</og:column>
					</tr>
					<tr>
						<td>group句</td>
						<og:column name="GRP" lbl="集計キー" size="50" colspan="6" />
					</tr>
					<tr>
						<td>order句</td>
						<og:column name="ORD" lbl="表示順" size="50" colspan="6" />
					</tr>
				</table>
			</og:fieldset>
			</td>
		</tr>
		<tr>
			<td>
			<og:fieldset lbl="ﾃﾞﾊﾞｯｸ用:" >
				<table>
					<tr>
						<og:column name="SAVE_FILE" lbl="OUT_FILE" />
						<og:column name="LOAD_FILE" lbl="FILE_IN" editor="TEXT" />
					</tr>
					<tr>
						<td colspan="4"><textarea name="JSON" rows="10" cols="60">
{
  "report_name": "EMP",
  "select_cols": "JOB,sum(SAL) AS AAA,max(COMM),COUNT(*) as cnt,MGR as TANIIII",
  "where_lk": "{'JOB ':'%N%'}",
  "where_gt": "{'SAL':1000,'EMPNO':'7300'}",
  "where_lt": "{'DEPTNO':50}",
  "group_by":"JOB,MGR",
  "order_by":"TANIIII"
}
						</textarea></td>
					</tr>
				</table>
			</og:fieldset>
			</td>
		</tr>
	</table>

	<og:queryButton useRowCount="false" />
</form>

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