<!-- include ファイルは、jsp:text が使用できません。  -->
<og:message lbl="GFM0001" val0="{@YEAR}" comment=" 年 地区別 売上比率 グラフ" />
<og:query command = "{@command}" debug="false" displayMsg="" >
		select BLOCK,SUM(SALES) AS SALES
		from GF43
		where YEAR = '{@YEAR}'
		group by BLOCK
		order by SALES DESC
</og:query>

<og:viewLink command="{@command}">
	<og:link column="BLOCK" href="index.jsp" target="CONTENTS"
		keys="YEAR,BLOCK,FLAG,command" vals="{@YEAR},[BLOCK],{@FLAG},NEW" >[BLOCK]
	</og:link>
</og:viewLink>

<og:view command="{@command}" useScrollBar="false" />

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

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

<og:columnEditor column="BRANCH" className="row_h" />
<og:view useScrollBar="false" viewFormType="HTMLRotationTable" />

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

<og:query command = "{@command}" debug="false" displayMsg="" >
		select MONTH,SUM(SALES) AS SALES, SUM(AMOUNT) AS AMOUNT, 
				SUM(SALES-AMOUNT) AS PROFIT
		from GF43
		where YEAR = '{@YEAR}'
		group by MONTH
		order by MONTH
</og:query>

<og:view useScrollBar="false" />
