<!-- include ファイルは、jsp:text が使用できません。  -->
<og:message lbl="GFM0001" val0="{@YYYY}" comment=" 年 地区別 売上比率 グラフ" />

<og:query command="NEW" >
		select BLOCK,SUM(SALES) AS SALES
		from GF43
		where YYYY = '{@YYYY}'
		group by BLOCK
		order by SALES DESC
</og:query>

<table><tr>
<td>
<og:chartCreate
	imageMapUrl = "index.jsp?YYYY={@YYYY}&amp;FLAG={@FLAG}&amp;command=NEW,BLOCK"
	imageMapTarget = "CONTENTS"
	width		= "400"
	height		= "200"
>
	<og:chartDataset
		chartType	 = "Pie"
		useTableData = "true"
	/>
</og:chartCreate>
</td>
<td>
<og:equals val1="{@FLAG}" val2="true">
	<og:view command="NEW" />
</og:equals>
</td>
</tr></table>

<hr />
<og:message lbl="GFM0002" val0="{@YYYY}" comment=" 年 営業所別 売上順グラフ" />

<og:query command="NEW" >
		select BRANCH,SUM(SALES) AS SALES, SUM(AMOUNT) AS AMOUNT, 
				SUM(SALES-AMOUNT) AS PROFIT
		from GF43
		where YYYY = '{@YYYY}'
		group by BRANCH
		order by SALES DESC
</og:query>

<table>
<tr><td>
<og:chartCreate
	imageMapUrl = "index.jsp?YYYY={@YYYY}&amp;FLAG={@FLAG}&amp;command=NEW,BRANCH"
	imageMapTarget = "CONTENTS"
	width		= "800"
	height		= "400"
>
	<og:chartDataset
		chartType	 = "Bar"
		useTableData = "true"
	/>
</og:chartCreate>
</td></tr>
<tr><td>
<og:equals val1="{@FLAG}" val2="true">
	<og:view command="NEW" useScrollBar="false" viewFormType="HTMLRotationTable" />
</og:equals>
</td></tr>
</table>

<hr />
<og:message lbl="GFM0003" val0="{@YYYY}" comment=" 年 月別 売上・経費・利益推移グラフ" />

<og:query command="NEW" >
		select MM,SUM(SALES) AS SALES, SUM(AMOUNT) AS AMOUNT, 
				SUM(SALES-AMOUNT) AS PROFIT
		from GF43
		where YYYY = '{@YYYY}'
		group by MM
		order by MM
</og:query>

<table><tr>
<td>
<og:chartCreate
	imageMapUrl = "index.jsp?YYYY={@YYYY}&amp;FLAG={@FLAG}&amp;command=NEW,MM"
	imageMapTarget = "CONTENTS"
	width		= "600"
	height		= "400"
>
	<og:chartDataset
		chartType	 = "LineAndShape"
		useTableData = "true"
	/>
</og:chartCreate>
</td>
<td>
<og:equals val1="{@FLAG}" val2="true">
	<og:view command="NEW" useScrollBar="false" />
</og:equals>
</td>
</tr></table>
