Untitled

from fpdf import FPDF

# Create a PDF document
pdf = FPDF()
pdf.set_auto_page_break(auto=True, margin=15)
pdf.add_page()

# Set title
pdf.set_font("Arial", style='B', size=14)
pdf.cell(200, 10, "Ma'din LSDC Collection", ln=True, align='C')

# Add table headers
pdf.ln(10)
pdf.set_font("Arial", size=12)
pdf.cell(65, 10, "Denomination", border=1, align='C')
pdf.cell(65, 10, "Number of Notes/Coins", border=1, align='C')
pdf.cell(65, 10, "Total Amount", border=1, align='C')
pdf.ln()

# Table rows
data = [
    ("₹500", 134, "₹67,000"),
    ("₹200", 90, "₹18,000"),
    ("₹100", 470, "₹47,000"),
    ("₹50", 471, "₹23,550"),
    ("₹20", 1055, "₹21,100"),
    ("₹10 (note)", 926, "₹9,260"),
    ("₹5 (coin)", 126, "₹630"),
    ("₹2 (coin)", 55, "₹110"),
    ("₹1 (coin)", 76, "₹76")
]

for row in data:
    pdf.cell(65, 10, row[0], border=1, align='C')
    pdf.cell(65, 10, str(row[1]), border=1, align='C')
    pdf.cell(65, 10, row[2], border=1, align='C')
    pdf.ln()

# Add Grand Total row
pdf.ln(5)
pdf.set_font("Arial", style='B', size=12)
pdf.cell(130, 10, "Grand Total", border=1, align='C')
pdf.cell(65, 10, "₹186,726", border=1, align='C')

# Save the PDF to a file
pdf_output_path = "/mnt/data/Madin_LSDC_Collection.pdf"
pdf.output(pdf_output_path)

pdf_output_path