<?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="result" useChartJS="true" />
<jsp:directive.include file="/jsp/custom/result_info.jsp" />

<!-- ﾁｬｰﾄ情報の取得 -->
<og:query command="NEW">
	SELECT	 A.ENAME as LABELS
			,A.SAL   as VAL1
			,A.COMM  as VAL2
--			,A.JOB
--			,B.EMPNO
--			,B.MGR
--			,B.HIREDATE
--			,B.SAL
--			,B.COMM
--			,B.DEPTNO
--			,C.DNAME
--			,C.LOC
	FROM BONUS A left outer join EMP B
		on A.ENAME = B.ENAME
		left outer join DEPT C
			on B.DEPTNO = C.DEPTNO
	order by B.EMPNO
</og:query>

<script>
	Chart.defaults.plugins.title.color='black';				// タイトルの文字色(グローバルなので個別設定の方が強い)
	Chart.defaults.plugins.title.font.size=20;				//
	Chart.defaults.plugins.legend.labels.color='black';		// 凡例の文字色
</script>

<!--
	X軸の文字色		jsChart の optTicks = "color:'black'"
	Y軸の文字色		jsChartData の fontColor= "black"
-->

<og:jsChart
	chartType	= "{@chartType}"
	labelColumn	= "LABELS"
	title		= "{@chartTitle}"
	indexAxis	= "{@indexAxis}"
	optOptions	= "animation:false"
	optTicks	= "color:'black'"
	debug		= "{@debug}"
	plugins		= "chartLabelPlugin"
	optLegend	= "onClick:function(event, legendItem, legend){return;}"
>
	<og:jsChartData
		chartColumn	= "VAL1"
		label		= "{@LBL.SAL}"
		borderColor	= "VIVID"
		fontColor	= "black"
		grace		= "{@grace}"
		spanGaps	= "true"
	/>
	<og:jsChartData
		chartColumn	= "VAL2"
		label		= "{@LBL.COMM}"
		borderColor	= "PASTEL"
		spanGaps	= "true"
	/>
</og:jsChart>

<og:view useScrollBar="false" />

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