sale_flow_product_chart.jsp

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

<%@	include file="tags.jsp"%>
<sql:query var="charts"
 sql="select tp.id as product_code,
 tp.name as product_name,
 tsale.sales as sales
  from t_dic_product tp left join
   (select product_code, count(product_code) as sales from t_data_sale_flow group by product_code) tsale
 on tp.id = tsale.product_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 }" productCode="${fn:fillZero(r.product_code,4) }" productName="${r.product_name }" />
	</c:forEach>
</root>