#!/bin/bash
# 每日数据处理脚本 — 读取上传文件夹中的最新文件，更新工作台JSON
# 手动运行: bash process_daily.sh
# Cron: 每天 8:00 自动运行

set -e
UPLOAD_DIR="$(cd "$(dirname "$0")" && pwd)"
DATA_DIR="$(dirname "$UPLOAD_DIR")"
WORK_DIR="$HOME/Desktop/Hermes输出-工作类"
LOG="$UPLOAD_DIR/process.log"

echo "=== $(date '+%Y-%m-%d %H:%M:%S') 开始处理 ===" >> "$LOG"

# Find latest CRM file
CRM_FILE=$(ls -t "$UPLOAD_DIR"/活动导出*.xlsx "$UPLOAD_DIR"/CRM活动导出*.xlsx 2>/dev/null | head -1)
if [ -z "$CRM_FILE" ]; then
  CRM_FILE="$HOME/work/secure/CRM及ERP数据/CRM活动导出-销售管理20260328V03.xlsx"
  echo "  使用默认CRM: $CRM_FILE" >> "$LOG"
else
  echo "  使用上传CRM: $CRM_FILE" >> "$LOG"
fi

# Find latest ERP file
ERP_FILE=$(ls -t "$UPLOAD_DIR"/销售订单导出*.xlsx "$UPLOAD_DIR"/ERP销售订单*.xlsx 2>/dev/null | head -1)
if [ -z "$ERP_FILE" ]; then
  ERP_FILE="$HOME/work/secure/CRM及ERP数据/erp销售订单_2026032814241310_102319.xlsx"
  echo "  使用默认ERP: $ERP_FILE" >> "$LOG"
else
  echo "  使用上传ERP: $ERP_FILE" >> "$LOG"
fi

# Run the Python processing script
python3 "$UPLOAD_DIR/regenerate_jsons.py" "$CRM_FILE" "$ERP_FILE" "$DATA_DIR" >> "$LOG" 2>&1

echo "=== $(date '+%Y-%m-%d %H:%M:%S') 完成 ===" >> "$LOG"
echo "" >> "$LOG"