<?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	= "GANTT06B"
	title	= "ガントチャート(時間)"
	date	= "2008/10/27"
	author	= "Hiroki.Nakamura"
	text	= ""
	version	= "001"
/>
<og:value command="SQL">
	<jsp:text>
		select (CASE WHEN '{@VIEW_DATE2}' IS NULL THEN VIEW_DATE ELSE '{@VIEW_DATE2}' END) AS VIEW_DATE2,
			 VIEW_ZOOM AS VIEW_ZOOM2
		from GF62 where PRJCODE = '{@PRJCODE}'
	</jsp:text>
</og:value>

<form method="GET" action="forward.jsp" target="RESULT" onClick="timeSet();">

<!-- 変更はここから -->
<table summary="layout" >
<tr>
	<!-- {@USER.XXXX} で、UserInfo 情報や、独自設定の値が取得できます。-->
	<og:select name="PRJCODE" onChange="renew('query.jsp','QUERY'); " colspan="3" >
		<og:option value="" lbl="" />
		<og:queryOption>
			<jsp:text>
				select PRJCODE,NAME_JA from GF62
				where fgj in ('0','1')
				order by PRJCODE
			</jsp:text>
		</og:queryOption>
	</og:select>
	<og:column name="VIEW_DATE" value="{@VIEW_DATE2}" must="true" />
	<og:column name="VIEW_ZOOM" value="{@VIEW_ZOOM2}" addNoValue="false"  />
</tr>
<tr>
	<og:column name="TASK_LEVEL" />
	<og:select name="WARN">
		<og:option value=""   lbl=""         />
		<og:option value="1"  lbl="WARN"     />
	</og:select>
	<og:select name="COMPLETE">
		<og:option value=""       lbl=""         />
		<og:option value="= 100"  lbl="100%"     />
		<og:option value="!= 100" lbl="&lt;100%" />
	</og:select>
	<og:column name="CDKT"      value="{@CDKT}"  must="true"    />
</tr>
	<og:column name="TEST_BREAK_TIMES" lbl="BreakTimes" maxlength="25" colspan="3" value="1200-1245,1630-1645,200508290700-1000,200508300000-200509010000" />
	<og:column name="TEST_DAYSPAN"     lbl="daySpan" value="0700-2000" size="10" />
	<og:select name="ORDER_BY" lbl="ORDER_BY">
		<og:option value="PRJCODE,SEQ"      lbls="PRJCODE,SEQ"   selected="selected" />
		<og:option value="DYSTART"          lbls="DYSTART"          />
	</og:select>
<tr>
</tr>
</table>
<og:queryButton />
</form>

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