sale_flow_store_chart.jsp

来自「实现很多功能 实现很多功能 实现很多功能」· JSP 代码 · 共 19 行

<%@	include file="tags.jsp"%>
<sql:query var="charts"
 sql="select ts.id as store_code,
 ts.name as store_name,
 tsale.sales as sales
  from t_dic_chain_store ts left join
   (select store_code, count(store_code) as sales from t_data_sale_flow group by store_code) tsale
 on ts.id = tsale.store_code
 order by sales desc"/>
 
<root>
	<c:forEach var="r" items="${charts.rows }">
		<c:set var="tmpSales" value="${r.sales }"/>
		<c:if test="${empty tmpSales }">
			<c:set var="tmpSales" value="0"/>
		</c:if>
		<chartcolumn sales="${tmpSales }" storeCode="${fn:fillZero(r.store_code,4) }" storeName="${r.store_name }" />
	</c:forEach>
</root>