order_id,customer,amount
1,Ann,1200
2,Bob,850
3,Cat,2400

import csv
import json
from datetime import datetime


def read_orders(file_path):
    orders = []

    with open(file_path, "r", encoding="utf-8") as file:
        reader = csv.DictReader(file)

        for row in reader:
            orders.append({
                "order_id": row["order_id"],
                "customer": row["customer"],
                "amount": float(row["amount"]),
            })

    return orders


def summarize_orders(orders):
    total_amount = 0
    max_order = None

    for order in orders:
        total_amount += order["amount"]

        if max_order is None or order["amount"] > max_order["amount"]:
            max_order = order

    return {
        "order_count": len(orders),
        "total_amount": total_amount,
        "max_order": max_order,
        "generated_at": datetime.now().strftime("%Y-%m-%d %H:%M:%S"),
    }


def write_json(file_path, data):
    with open(file_path, "w", encoding="utf-8") as file:
        json.dump(data, file, ensure_ascii=False, indent=2)


try:
    orders = read_orders("orders.csv")
    summary = summarize_orders(orders)
    write_json("summary.json", summary)
    print("สร้าง summary.json สำเร็จ")
except FileNotFoundError:
    print("ไม่พบไฟล์ orders.csv")
except ValueError:
    print("amount ต้องเป็นตัวเลข")