产品销售数据备份#

food_sales_sync
├─ main.py
└─ 产品销售
   ├─ 待同步
   │  └─ 202505.csv
   └─ 已同步
      ├─ 202501.csv
      ├─ 202502.csv
      ├─ 202503.csv
      ├─ 202504.csv
      ├─ 202505.csv
      ├─ 202506.csv
      ├─ 202507.csv
      ├─ 202508.csv
      ├─ 202509.csv
      ├─ 202510.csv
      ├─ 202511.csv
      ├─ 202512.csv
      ├─ 202601.csv
      ├─ 202602.csv
      ├─ 202603.csv
      └─ 202604.csv

SELECT 
	business_date AS 日期,
    stat_shop_id AS 门店编号,
    channel_name AS 渠道,
    item_name AS 产品名称,
    SUM(dp_total_amount) AS 流水,
    SUM(dp_pay_amount) AS 实收,
    SUM(dp_item_count) AS 销量
FROM ads_dbs_trade_food_di
WHERE business_date BETWEEN '20260101' AND '20260401'
GROUP BY business_date,stat_shop_id, channel_name, item_name;

SELECT 
    SUBSTR(日期, 1, 6) AS 月份,
    SUM(流水) AS 流水
FROM 日表
WHERE 日期 >= '20250101'
GROUP BY SUBSTR(日期, 1, 6) 
ORDER BY 月份;

SELECT 
    SUBSTR(business_date, 1, 6) AS 月份,
    SUM(dp_total_amount) AS 流水
FROM ads_dbs_trade_food_di
WHERE business_date >= '20250101'
GROUP BY SUBSTR(business_date, 1, 6) 
ORDER BY 月份;