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


	<!-- ﾁｬｰﾄ情報の取得 -->
	<og:query tableId="tbl1">
		SELECT (to_date('20180921','YYYYMMDD') - to_date('1970010109','YYYYMMDDHH')) * 24 * 60 * 60 * 1000 CDATE, 100 NUM, 200 NUM2 FROM DUAL
		UNION ALL
		SELECT (to_date('20180922','YYYYMMDD') - to_date('1970010109','YYYYMMDDHH')) * 24 * 60 * 60 * 1000 CDATE, 200 NUM, 100 NUM2 FROM DUAL
		UNION ALL
		SELECT (to_date('20180925','YYYYMMDD') - to_date('1970010109','YYYYMMDDHH')) * 24 * 60 * 60 * 1000 CDATE, 200 NUM, 100 NUM2 FROM DUAL
	</og:query>

	<og:query tableId="tbl2">
		SELECT '2017年01月01日' CDATE ,100 NUM ,200 NUM2	FROM DUAL
		UNION ALL SELECT '2017年01月02日' ,200 ,400	FROM DUAL
		UNION ALL SELECT '2017年01月03日' ,300 ,600	FROM DUAL
		UNION ALL SELECT '2017年03月01日' ,-50 ,-100	FROM DUAL
		UNION ALL SELECT '2017年04月01日' ,124 ,248	FROM DUAL
		order by 1
	</og:query>

横軸が文字列で、日付として、扱う場合。<br />
xscaleTypeに未設定、またはstringを設定<br />
timeSetFormatに「YYYYMMDD」を設定して下さい<br />
	<og:jsChart
		tableId				= "tbl2"
		chartType			= "{@chartType}"
		height				= "{@height}"
		width				= "{@width}"
		max					= "{@max}"
		min					= "{@min}"
		stepSize			= "{@stepSize}"
		barWidthPer			= "{@barWidthPer}"
		timeUnit			= "{@timeUnit}"
		timeUnitStepSize	= "{@timeUnitStepSize}"
		timeSetFormat		= "{@timeSetFormat}"
		timeLblFormat		= "{@timeLblFormat}"
		timeMax				= "{@timeMax}"
		timeMin				= "{@timeMin}"
		labelColumn			= "CDATE"
		title				= "{@title}"
		titlePosition		= "{@titlePosition}"
		ylabel				= "{@ylabel}"
		xlabel				= "{@xlabel}"
		legendDisplay		= "{@legendDisplay}"
		legendPosition		= "{@legendPosition}"
		xscaleType			= "{@xscaleType}"
		xscaleTimeType		= ""
		yscaleType			= "{@yscaleType}"
		ycategoryList		= "{@ycategoryList}"
		optionAttributes	= ""
		debug				= "{@debug}"
	>
	<og:jsChartData
			chartColumn			= "NUM"
			label				= "値１"
			fill				= "{@fill}"
			tension				= "{@tension}"
			borderColor			= "{@borderColor}"
			borderWidth			= "{@borderWidth}"
			backgroundColor		= "{@backgroundColor}"
			optionAttributes	= ""
			 />
	<og:jsChartData
				chartColumn			= "NUM2"
				label				= "値２"
				fill				= "{@fill}"
				tension				= "{@tension}"
				borderColor			= "blue"
				borderWidth			= "{@borderWidth}"
				backgroundColor		= "orange"
				optionAttributes	= ""
				 />
	</og:jsChart>

横軸にUNIX時間を渡す場合<br />
xscaleDataType="int"
	<og:jsChart
		tableId				= "tbl1"
		chartType			= "{@chartType}"
		height				= "{@height}"
		width				= "{@width}"
		max					= "{@max}"
		min					= "{@min}"
		stepSize			= "{@stepSize}"
		barWidthPer			= "{@barWidthPer}"
		timeUnit			= "{@timeUnit}"
		timeUnitStepSize	= "{@timeUnitStepSize}"
		timeSetFormat		= "{@timeSetFormat}"
		timeLblFormat		= "{@timeLblFormat}"
		timeMax				= "{@timeMax}"
		timeMin				= "{@timeMin}"
		labelColumn			= "CDATE"
		title				= "{@title}"
		titlePosition		= "{@titlePosition}"
		ylabel				= "{@ylabel}"
		xlabel				= "{@xlabel}"
		legendDisplay		= "{@legendDisplay}"
		legendPosition		= "{@legendPosition}"
		xscaleType			= "{@xscaleType}"
		xscaleTimeType		= "int"
		yscaleType			= "{@yscaleType}"
		ycategoryList		= "{@ycategoryList}"
		optionAttributes	= ""
		debug				= "{@debug}"
	>
	<og:jsChartData
			chartColumn			= "NUM"
			label				= "値１"
			fill				= "{@fill}"
			tension				= "{@tension}"
			borderColor			= "{@borderColor}"
			borderWidth			= "{@borderWidth}"
			backgroundColor		= "{@backgroundColor}"
			optionAttributes	= ""
			 />
	<og:jsChartData
				chartColumn			= "NUM2"
				label				= "値２"
				fill				= "{@fill}"
				tension				= "{@tension}"
				borderColor			= "blue"
				borderWidth			= "{@borderWidth}"
				backgroundColor		= "orange"
				optionAttributes	= ""
				 />
	</og:jsChart>
</jsp:root>