Skip to main content

报表开发

架构图

SQL查询

-- 1. 销售汇总数据集
SELECT
DATE_FORMAT(order_date, '%Y-%m') as order_month,
product_category,
sales_region,
SUM(sales_amount) as total_sales,
COUNT(DISTINCT customer_id) as customer_count,
SUM(sales_amount)/COUNT(DISTINCT order_id) as avg_order_amount
FROM sales_orders
WHERE order_date BETWEEN '${startDate}' AND '${endDate}'
GROUP BY
DATE_FORMAT(order_date, '%Y-%m'),
product_category,
sales_region;

-- 2. 趋势分析数据集
SELECT
DATE_FORMAT(order_date, '%Y-%m-%d') as date,
SUM(sales_amount) as daily_sales,
COUNT(DISTINCT order_id) as order_count,
SUM(sales_amount)/COUNT(DISTINCT order_id) as avg_amount
FROM sales_orders
GROUP BY DATE_FORMAT(order_date, '%Y-%m-%d')
ORDER BY date;

设计交互层