<?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"
/>

<form method="GET" action="forward.jsp" target="RESULT" onSubmit="timeSet();">
	<table>
		<tr>
			<og:column name="authURL" must="true" colspan="3" size="55" />
			<og:column name="userId" must="true" />
			<og:column name="password" must="true" />
		</tr>
		<tr>
			<og:column name="report_name" lbl="ｱﾌﾟﾘ名" must="true" colspan="3" />
			<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="selupd"	lbl="IOr検索／登録"	/>
				<og:option value="update"	lbl="IOr登録"	/>
				<og:option value="sql"		lbl="JSON取得"	/>
			</og:select>
			<og:select name="sqlType" >
				<og:option value="INSERT"	lbl="追加"	/>
				<og:option value="UPDATE"	lbl="変更"	/>
				<og:option value="DELETE"	lbl="削除"	/>
			</og:select>
		</tr>
	</table>
	<table>
		<tr>
			<td>
			<og:fieldset lbl="検索用" defaultNone="false" >
				<table>
					<tr>
						<og:column name="urlSel" lbl="url" maxlength="100" size="70" colspan="3" />
					</tr>
				</table>
				<table>
					<tr>
						<td>select句</td>
						<og:column name="SEL" lbl="検索項目" maxlength="200" size="100" colspan="5" />
					</tr>
					<tr>
						<td>where句</td>
						<!-- 担当者 -->
						<og:column name="TANTO1" lbl="担当者" aimai="V*" ></og:column>
						<!-- 入出庫日(≧) -->
						<og:column name="DYNYSY1" lbl="入出庫日" size="5" >(≧)</og:column>
						<!-- 単位 -->
						<og:column name="TANI" lbl="単位" aimai="V*" size="5" />
					</tr>
					<tr>
						<td colspan="2"/>
						<!-- 担当者(NOT) -->
						<td><og:column name="TANTO2" aimai="V*" td="false" >(NOT)</og:column></td>
						<td/>
						<!-- 入出庫日(≦) -->
						<td><og:column name="DYNYSY2" size="5" td="false" >(≦)</og:column></td>
						<!-- 社名(IS NULL) -->
						<td class="label">社名:</td>
						<td><input type="radio" name="NMSYA" value="IS NULL" />IS NULL</td>
					</tr>
					<tr>
						<td colspan="2"/>
						<!-- 担当者(IN) -->
						<td><og:column name="TANTO3" td="false" >(IN)</og:column></td><td>※ｶﾝﾏ区切りで指定</td>
						<!-- 入出庫日(＞) -->
						<td><og:column name="DYNYSY3" size="5" td="false" >(＞)</og:column></td>
						<td/>
						<!-- 社名(IS NOT NULL) -->
						<td><input type="radio" name="NMSYA" value="IS NOT NULL" />NOT NULL</td>
					</tr>
					<tr>
						<td colspan="2"/>
						<!-- 担当者(NOT IN) -->
						<td><og:column name="TANTO4" td="false" >(NOT IN)</og:column></td><td>※ｶﾝﾏ区切りで指定</td>
						<!-- 担当者(＜) -->
						<td><og:column name="DYNYSY4" size="5" td="false" >(＜)</og:column></td>
					</tr>
					<tr>
						<td>group句</td>
						<og:column name="GRP" lbl="集計キー" size="50" colspan="5" />
					</tr>
					<tr>
						<td>order句</td>
						<og:column name="ORD" lbl="表示順" size="50" colspan="5" />
					</tr>
				</table>
			</og:fieldset>
			</td>
		</tr>
		<tr>
			<td>
			<og:fieldset lbl="登録用" >
				<table>
					<tr>
						<og:column name="urlUpd" lbl="url" maxlength="100" size="70" colspan="3" />
					</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>
