#!/usr/bin/env python3 """Счёт из JSON с расчётом итога и CSV-реестром.""" from __future__ import annotations import argparse import csv import html import json from datetime import date from decimal import Decimal, InvalidOperation, ROUND_HALF_UP from pathlib import Path SAMPLE = { "number": "2026-001", "date": "2026-11-09", "due": "2026-11-23", "currency": "USD", "tax_rate": 0, "from": {"name": "Demo Studio", "address": "1 Example Street, Demo"}, "to": {"name": "Example Client", "address": "2 Example Avenue, Demo"}, "items": [ {"description": "Консультация", "quantity": 2, "price": 100}, {"description": "Подготовка документа", "quantity": 1, "price": 250}, ], } def money(value: Decimal) -> str: return f"{value.quantize(Decimal('0.01'), rounding=ROUND_HALF_UP):,.2f}" def to_decimal(value, label: str) -> Decimal: try: number = Decimal(str(value)) except (InvalidOperation, ValueError): raise SystemExit(f"Не число в поле {label}: {value}") if number < 0: raise SystemExit(f"Отрицательное значение в поле {label}") return number def load_invoice(path: Path) -> dict: try: data = json.loads(path.read_text(encoding="utf-8")) except json.JSONDecodeError as error: raise SystemExit(f"Ошибка JSON: {error}") if not isinstance(data, dict): raise SystemExit("Корень JSON должен быть объектом") for field in ("number", "date", "to", "items"): if field not in data: raise SystemExit(f"В JSON нет поля {field}") if not isinstance(data["items"], list) or not data["items"]: raise SystemExit("Поле items должно быть непустым списком") return data def calculate(data: dict) -> tuple[list[dict], Decimal, Decimal, Decimal]: rows = [] subtotal = Decimal("0") for index, item in enumerate(data["items"], start=1): if not isinstance(item, dict) or not item.get("description"): raise SystemExit(f"Позиция {index} без description") quantity = to_decimal(item.get("quantity", 1), f"items[{index}].quantity") price = to_decimal(item.get("price", 0), f"items[{index}].price") amount = quantity * price subtotal += amount rows.append({"description": str(item["description"]), "quantity": quantity, "price": price, "amount": amount}) tax_rate = to_decimal(data.get("tax_rate", 0), "tax_rate") tax = subtotal * tax_rate / Decimal("100") total = subtotal + tax return rows, subtotal, tax, total def render_html(data: dict, rows: list[dict], subtotal: Decimal, tax: Decimal, total: Decimal) -> str: esc = html.escape client = data.get("to", {}) seller = data.get("from", {}) currency = esc(str(data.get("currency", ""))) body = [] for row in rows: body.append( "" f"{esc(row['description'])}" f"{row['quantity']}" f"{money(row['price'])}" f"{money(row['amount'])}" "" ) tax_row = "" if tax > 0: tax_row = f"Налог {esc(str(data.get('tax_rate', 0)))}%{money(tax)}" due_text = f" · Оплатить до: {esc(str(data['due']))}" if data.get("due") else "" return f""" Счёт {esc(str(data['number']))}

Счёт {esc(str(data['number']))}

Дата: {esc(str(data['date']))}{due_text}
Исполнитель
{esc(str(seller.get("name", "")))}
{esc(str(seller.get("address", "")))}
Заказчик
{esc(str(client.get("name", "")))}
{esc(str(client.get("address", "")))}
{''.join(body)} {tax_row}
ОписаниеКол-воЦенаСумма
Подытог{money(subtotal)} {currency}
Итого{money(total)} {currency}
""" def render_markdown(data: dict, rows: list[dict], subtotal: Decimal, tax: Decimal, total: Decimal) -> str: currency = str(data.get("currency", "")) lines = [ f"# Счёт {data['number']}", "", f"Дата: {data['date']}", ] if data.get("due"): lines.append(f"Оплатить до: {data['due']}") lines.extend([ "", f"Исполнитель: {data.get('from', {}).get('name', '')}", f"Заказчик: {data.get('to', {}).get('name', '')}", "", "| Описание | Кол-во | Цена | Сумма |", "|---|---:|---:|---:|", ]) for row in rows: description = str(row["description"]).replace("|", "\\|") lines.append( f"| {description} | {row['quantity']} | {money(row['price'])} | {money(row['amount'])} |" ) lines.extend([ "", f"Подытог: {money(subtotal)} {currency}", ]) if tax > 0: lines.append(f"Налог {data.get('tax_rate', 0)}%: {money(tax)} {currency}") lines.append(f"**Итого: {money(total)} {currency}**") return "\n".join(lines) + "\n" def append_register(path: Path, data: dict, total: Decimal) -> None: path.parent.mkdir(parents=True, exist_ok=True) is_new = not path.exists() with path.open("a", encoding="utf-8", newline="") as handle: writer = csv.writer(handle) if is_new: writer.writerow(["number", "date", "due", "client", "total", "currency"]) writer.writerow([ data.get("number", ""), data.get("date", ""), data.get("due", ""), data.get("to", {}).get("name", ""), money(total), data.get("currency", ""), ]) print(f"Реестр обновлён: {path}") def main() -> int: parser = argparse.ArgumentParser(description="Счёт из JSON") parser.add_argument("--data", type=Path) parser.add_argument("--output", type=Path, default=Path("invoice.html")) parser.add_argument("--register", type=Path) parser.add_argument("--init", action="store_true") parser.add_argument("--force", action="store_true") args = parser.parse_args() if args.init: if not args.output: parser.error("Для --init укажите --output") output = args.output.expanduser() if output.exists() and not args.force: parser.error(f"Файл уже существует: {output}") output.parent.mkdir(parents=True, exist_ok=True) output.write_text(json.dumps(SAMPLE, ensure_ascii=False, indent=2) + "\n", encoding="utf-8") print(f"Пример счёта сохранён: {output}") return 0 if not args.data: parser.error("Укажите --data или --init") data_path = args.data.expanduser() if not data_path.is_file(): parser.error(f"Файл не найден: {data_path}") data = load_invoice(data_path) for field in ("date", "due"): if data.get(field): try: date.fromisoformat(str(data[field])) except ValueError: parser.error(f"Поле {field} должно быть в формате YYYY-MM-DD") output = args.output.expanduser() suffix = output.suffix.lower() if suffix not in {".html", ".md"}: parser.error("Поддерживаются расширения .html и .md") if output.exists() and not args.force: parser.error(f"Файл уже существует: {output}. Добавьте --force.") rows, subtotal, tax, total = calculate(data) text = render_html(data, rows, subtotal, tax, total) if suffix == ".html" else render_markdown(data, rows, subtotal, tax, total) output.parent.mkdir(parents=True, exist_ok=True) output.write_text(text, encoding="utf-8") print(f"Счёт сохранён: {output}") if args.register: append_register(args.register.expanduser(), data, total) return 0 if __name__ == "__main__": raise SystemExit(main())