<?xml version="1.0" encoding="UTF-8" ?>
<jsp:root
	xmlns:jsp="http://java.sun.com/JSP/Page"
	xmlns:c="http://java.sun.com/jsp/jstl/core"
	xmlns:og="hybs-taglib.tld"
	version="2.0">
<jsp:directive.page language="java" contentType="text/html; charset=UTF-8" />

<og:value command="SQL">
		SELECT 	 DECODE('{@plotOrientation}' ,'VERTICAL' ,500 ,count(*)*100 ) GRAPH_HEIGHT
				,DECODE('{@plotOrientation}' ,'VERTICAL' ,count(*)*100 ,500 ) GRAPH_WIDTH
		FROM EMP
		<og:where>
			<og:and value=" DEPTNO = {@SOOUID}" />
		</og:where>
</og:value>
<!--  -->
<og:chartCreate
	title		= "{@chartType}"
	width		= "{@GRAPH_WIDTH}"
	height		= "{@GRAPH_HEIGHT}"
	plotOrientation	 = "{@plotOrientation}"
	rotationLabel = "0"
	useCache	= "{@useCache}"
	cacheTime	= "{@cacheTime}"
	cacheScope	= "{@cacheScope}"
	masterKey	= "{@chartType}_{@plotOrientation}_{@SOOUID}"
	useToolTip	= "true"
	imageMapUrl = "../GF7202/index.jsp?SOOUID={@SOOUID}&amp;command=NEW,ENAME"
	imageMapTarget = "CONTENTS"
>
	<!-- ラベルの改行は、'\n' 文字列か、chr(10) で行う -->
	<og:chartDataset
		chartType	= "{@chartType}"
		itemLabelVisible="true"
		markOverColors ="BLUE,RED"
		markValues="4000"
		markColors="BLACK"
	>
			SELECT 	 ENAME || '\n' || EMPNO || '\n' || JOB	<!-- 営業担当者 -->
					,SAL									<!-- 売上( 1月) -->
					,SAL * 2 * DBMS_RANDOM.VALUE as RAND1	<!-- 乱数倍 -->
					,SAL * 2 * DBMS_RANDOM.VALUE as RAND2	<!-- 乱数倍 -->
			FROM EMP
			<og:where>
				<og:and value=" DEPTNO = {@SOOUID}" />
			</og:where>
	</og:chartDataset>
</og:chartCreate>

</jsp:root>
