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

<!-- すべてのグラフに値ﾗﾍﾞﾙを表示する場合は、register を使います。
	<script type="text/javascript">
		Chart.plugins.register( chartLabelPlugin );
	</script>
-->
	<og:jsChart
		chartType		= "{@chartType}"
		labelColumn		= "LABELS"
		optOptions		= "animation:false"
		debug			= "{@debug}"
		plugins			= "chartLabelPlugin"
	>
		<og:jsChartData
			chartColumn		= "VAL1"
			label			= "{@LBL.SAL}"
			borderColor		= "VIVID"
		/>
		<og:jsChartData
			chartColumn		= "VAL2"
			label			= "{@LBL.COMM}"
			borderColor		= "PASTEL"
		/>
	</og:jsChart>
<jsp:directive.include file="/jsp/common/htmlend.jsp" />
</jsp:root>
