#!/usr/bin/env python3
# -*- coding: utf-8 -*-
import csv
rows = list(csv.DictReader(open("preview_movimientos.csv", encoding="utf-8-sig")))
dups = [r for r in rows if "duplicado" in r["revisar"]]
print(f"== POSIBLES DUPLICADOS ({len(dups)}) ==")
for r in sorted(dups, key=lambda x: (x["fecha"], x["cuenta"], -int(x["monto"]))):
    print(f"  {r['fecha']} {r['cuenta']:<11} ${int(r['monto']):>9,} {r['tipo']:<8} {r['contacto'][:22]:<22} odoo:{r['numero_odoo']}")