#!/usr/bin/env python3
import sys, json, os, zipfile, io
import docx
from docx.shared import Pt
import barcode
from barcode.writer import ImageWriter
import qrcode
from PIL import Image

def generate_docx_receipt(data):
    template_path = "/var/www/html/dashboard/banking/new/doc-template.docx"
    if not os.path.exists(template_path):
        sys.stderr.write("Template file not found: " + template_path + os.linesep)
        sys.exit(1)

    trn = str(data.get("TRN", ""))
    trn_202 = str(data.get("TRN_202", trn))
    uetr = str(data.get("UETR", ""))
    date_x = str(data.get("dateX", ""))
    time_x = str(data.get("timeX", ""))
    s_bank_name = str(data.get("s_BankName", ""))
    s_bank_address = str(data.get("s_BankAddress", ""))
    s_swift_code = str(data.get("s_swiftCode", ""))
    s_account_name = str(data.get("s_AccountName", ""))
    s_account = str(data.get("s_Account", ""))
    r_bank_name = str(data.get("r_BankName", ""))
    r_bank_address = str(data.get("r_BankAddress", ""))
    r_swift_code = str(data.get("r_swiftCode", ""))
    r_account_name = str(data.get("r_AccountName", ""))
    r_account = str(data.get("r_Account", ""))
    amount = str(data.get("amount", ""))
    currency = str(data.get("currency", "EUR"))
    remittance = str(data.get("remittance", ""))
    charges = str(data.get("charges", "BEN"))
    mir = str(data.get("MIR", ""))
    mor = str(data.get("MOR", ""))
    chk = str(data.get("CHK", ""))

    # 1. Generate Barcode bytes (Code 128 for TRN)
    bc_io = io.BytesIO()
    code128 = barcode.get("code128", trn, writer=ImageWriter())
    code128.write(bc_io)
    bc_bytes = bc_io.getvalue()

    # 2. Generate QR Code bytes (JPEG format for TRN and UETR)
    qr = qrcode.QRCode(version=1, box_size=8, border=2)
    qr_text = trn + os.linesep + uetr if uetr else trn
    qr.add_data(qr_text)
    qr.make(fit=True)
    qr_img = qr.make_image(fill_color="black", back_color="white").convert("RGB")
    qr_io = io.BytesIO()
    qr_img.save(qr_io, format="JPEG")
    qr_bytes = qr_io.getvalue()

    # 3. Load Document with python-docx for text & font manipulation
    doc = docx.Document(template_path)

    # Set default style font
    normal_style = doc.styles["Normal"]
    normal_style.font.name = "Courier New"
    normal_style.font.size = Pt(7.4)

    f72_text = (
        "/// WE, " + s_bank_name + ", " + s_bank_address + ", AT REQUEST OF OUR CLIENT, "
        "HEREBY RECONFIRM WITH FULL BANK RESPONSIBILITY AND LIABILITY ON BEHALF OF OUR CLIENT " + s_account_name + ", "
        "THAT WE HAVE TRANSFERRED VIA MT103 SINGLE CUSTOMER CASH TRANSFER REFERENCE NUMBER: " + trn + " ON " + date_x + " "
        "FAVOURING " + r_account_name + " WITH ACCOUNT NUMBER " + r_account + ", IN AMOUNT OF " + amount + " " + currency + " "
        "AND WE FURTHER CONFIRM THE ABOVE SAID FUND TRANSFER BACKED WITH CASH. THIS FUNDS ARE CLEAN CLEAR, AND FREE FROM ANY LIENS. "
        "THIS FUNDS ARE OBTAINED FROM LEGAL SOURCES OF NON-CRIMINAL ORIGIN. THIS IRREVOCABLE, UNCONDITIONAL, CALLABLE, DIVISIBLE, ASSIGNABLE SWIFT CAN BE RELIED UPON FOR FULL CASH."
    )

    rep = [
        ("DEUT992541320116", trn),
        ("DEUTDEDBFRA", s_swift_code),
        ("DEUTSCHE BANK AG", s_bank_name),
        ("TAUNUSANLAGE 12, FRANKFURT AM MAIN, GERMANY", s_bank_address),
        ("ERA FINANCES REAL ESTATE INVESTMENTS GMBH", s_account_name),
        ("DE64500700240663502300", s_account),
        ("UNCRITMMXXX", r_swift_code),
        ("UNICREDIT SPA", r_bank_name),
        ("PIAZZA EDISON, 1-20123-MILANO-ITALY", r_bank_address),
        ("GUZMANIA MANAGEMENT & CONSULTING SRL", r_account_name),
        ("IT72I0200801600000106435539", r_account),
        ("100,000,000.00", amount),
        ("24/04/2024", date_x),
        ("15:25:10", time_x),
        ("AT1047856952", mir),
        ("AT3562147758", mor),
        ("DEUTDEFFXXX997142599", chk),
        ("FOR INVESTMENT", remittance),
        ("BEN", charges)
    ]

    for p in doc.paragraphs:
        if "/// WE, DEUTSCHE BANK AG" in p.text or "RECONFIRM WITH FULL BANK RESPONSIBILITY" in p.text:
            p.text = f72_text
        else:
            for old_v, new_v in rep:
                if old_v in p.text:
                    p.text = p.text.replace(old_v, new_v)

        if "**20TRANSACTION REFERENCE CODE:" in p.text and "UETR CODE:" not in p.text and uetr:
            p.text = p.text + os.linesep + "**UETR CODE: " + uetr

        p.style = doc.styles["Normal"]
        for r in p.runs:
            r.font.name = "Courier New"
            r.font.size = Pt(7.4)

    for table in doc.tables:
        for row in table.rows:
            for cell in row.cells:
                for p in cell.paragraphs:
                    for r in p.runs:
                        r.font.name = "Courier New"
                        r.font.size = Pt(7.4)

    # Save intermediate text/font updated docx to memory
    mem_io = io.BytesIO()
    doc.save(mem_io)
    mem_io.seek(0)

    # 4. Perform zip media replacement for Barcode (image2.png) and QR Code (image1.jpeg)
    output_dir = "/var/www/html/dashboard/dimension/log"
    os.makedirs(output_dir, exist_ok=True)
    output_path = os.path.join(output_dir, trn + ".docx")

    with zipfile.ZipFile(mem_io, "r") as zin, zipfile.ZipFile(output_path, "w") as zout:
        for item in zin.infolist():
            buffer = zin.read(item.filename)
            if item.filename == "word/media/image2.png":
                buffer = bc_bytes
            elif item.filename == "word/media/image1.jpeg":
                buffer = qr_bytes
            zout.writestr(item, buffer)

    print("DOCX_GENERATED_SUCCESS:" + output_path)

if __name__ == "__main__":
    if len(sys.argv) > 1:
        arg = sys.argv[1]
        if os.path.exists(arg):
            with open(arg, "r") as f:
                data = json.load(f)
        else:
            data = json.loads(arg)
    else:
        data = json.load(sys.stdin)
    generate_docx_receipt(data)