Create Mark sheet pdf file by using data from SQLite / MySQL database table in Python ReportLab

PDF Invoice generation in Python using Reportlab by using sales and product data using template

Keep the water mark at the starting so all other lines and text will appear over this.
To draw a vertical line we have to keep the x1 and x2 value same
To draw a horizontal line we have to keep the y1 and y2 value same
We can also use default font styles and a list is available by using getAvailableFonts() method
While using currency it is better to right align the string by using drawRightString()
Date is taken as today’s date by using date library.

There are three files used and the library ReportLab is used to write the PDF file.

the invoice_data.py file can be used to get data from different database and other data sources to generate the Invoice. Here some sample data is stored inside the file.

invoice_data.py

This file stores sample data for product and sales inside two dictionary and variables like tax rate discount rate are set here.

my_prod is a dictionary having product_id as key and product name , price as value list.

my_prod={1:['Hard Disk',80],2:['RAM',90],3:['Monitor',75],
         4:['CPU',55],5:['Keyboard',20],6:['Mouse',10],
         7:['Mother board',50],8:['Power Sypply',20],
         9:['Speaker',50],10:['Microphone',45]}

my_sale is a dictionary having product_id as key and quantity sold as value.

my_sale={1:2,3:2,7:1,4:3,6:5,5:3,2:1,9:1,10:3}

We have discount and tax rate as variables inside this file.

discount_rate=10 # 10% discount 
tax_rate=12 # tax rate  in percentage

temp_invoice.py

This is the template file where the blank design of the invoice is available inside the function my_temp(). This function is called inside the main file to show the blank invoice.

This file draws all lines , add text and place the top logo on the canvas. Font family is changed to available default fonts.

invoice.py

This is the main file and by using the template ( temp_invoice.py ) and the data ( invoice_data.py ) it creates the pdf document.

from temp_invoice import my_temp # import the template
from invoice_data import *  # get all data required for invoice

By using for loop all sales data are displayed with quanity and price. Here for price and total drawRightString() is used.

for items in my_sale:
    c.drawString(0.1*inch,line_y*inch,str(my_prod[items][0])) # p Name
    c.drawRightString(4.5*inch,line_y*inch,str(my_prod[items][1])) # p Price
    c.drawRightString(5.5*inch,line_y*inch,str(my_sale[items])) # p Qunt 
    sub_total=my_prod[items][1]*my_sale[items]
    c.drawRightString(7*inch,line_y*inch,str(sub_total)) # Sub Total 
    total=round(total+sub_total,1)
    line_y=line_y-row_gap

invoice_data

temp_invoice.py

from reportlab.lib.units import inch
def my_temp(c):
    c.translate(inch,inch)
# define a large font
    c.setFont("Helvetica", 14)
# choose some colors
    c.setStrokeColorRGB(0.1,0.8,0.1)
    c.setFillColorRGB(0,0,1) # font colour
    c.drawImage('D:\\top2.jpg',-0.8*inch,9.3*inch)
    c.drawString(0, 9*inch, "Shop No : 1234, ABCD Road")
    c.drawString(0, 8.7*inch, "City Name: Mycity, ZIP : 12345")
    c.setFillColorRGB(0,0,0) # font colour
    c.line(0,8.6*inch,6.8*inch,8.6*inch)
    c.drawString(5.6*inch,9.5*inch,'Bill No :# 1234')
    from  datetime import date
    dt = date.today().strftime('%d-%b-%Y')
    c.drawString(5.6*inch,9.3*inch,dt)
    c.setFont("Helvetica", 8)
    c.drawString(3*inch,9.6*inch,'Tax No :# ABC1234')
    c.setFillColorRGB(1,0,0) # font colour
    c.setFont("Times-Bold", 40)
    c.drawString(4.3*inch,8.7*inch,'INVOICE')
    c.rotate(45) # rotate by 45 degree 
    c.setFillColorCMYK(0,0,0,0.08) # font colour CYAN, MAGENTA, YELLOW and BLACK
    c.setFont("Helvetica", 140) # font style and size
    c.drawString(2*inch, 1*inch, "SAMPLE") # String written 
    c.rotate(-45) # restore the rotation 
    c.setFillColorRGB(0,0,0) # font colour
    c.setFont("Times-Roman", 22)
    c.drawString(0.5*inch,8.3*inch,'Products')
    c.drawString(4*inch,8.3*inch,'Price')
    c.drawString(5*inch,8.3*inch,'Quantity')
    c.drawString(6.1*inch,8.3*inch,'Total')
    c.setStrokeColorCMYK(0,0,0,1) # vertical line colour 
    c.line(3.9*inch,8.3*inch,3.9*inch,2.7*inch)# first vertical line
    c.line(4.9*inch,8.3*inch,4.9*inch,2.7*inch)# second vertical line
    c.line(6.1*inch,8.3*inch,6.1*inch,2.7*inch)# third vertical line
    c.line(0.01*inch,2.5*inch,7*inch,2.5*inch)# horizontal line total

c.drawString(1*inch,1.8*inch,'Discount')
    c.drawString(1*inch,1.2*inch,'Tax')
    c.setFont("Times-Bold", 22)
    c.drawString(2*inch,0.8*inch,'Total')
    c.setFont("Times-Roman", 22)
    c.drawString(5.6*inch,-0.1*inch,'Signature')
    c.setStrokeColorRGB(0.1,0.8,0.1) # Bottom Line colour 
    c.line(0,-0.7*inch,6.8*inch,-0.7*inch)
    c.setFont("Helvetica", 8) # font size
    c.setFillColorRGB(1,0,0) # font colour
    c.drawString(0, -0.9*inch, u"\u00A9"+" plus2net.com")
    
    return c

invoice.py

from reportlab.pdfgen import canvas
my_path='G:\\My drive\\testing\\pypdf2\\my_pdf.pdf' 
from reportlab.lib.units import inch
from reportlab.lib.pagesizes import letter, A4
from temp_invoice import my_temp # import the template
from invoice_data import *  # get all data required for invoice

#my_prod={1:['Hard Disk',80,1],2:['RAM',90,2],3:['Monitor',75,2]}
c = canvas.Canvas(my_path,pagesize=letter)
c=my_temp(c) # run the template

c.setFillColorRGB(0,0,1) # font colour
c.setFont("Helvetica", 20)
row_gap=0.6 # gap between each row
line_y=7.9 # location of fist Y position 
total=0
for items in my_sale:
    c.drawString(0.1*inch,line_y*inch,str(my_prod[items][0])) # p Name
    c.drawRightString(4.5*inch,line_y*inch,str(my_prod[items][1])) # p Price
    c.drawRightString(5.5*inch,line_y*inch,str(my_sale[items])) # p Qunt 
    sub_total=my_prod[items][1]*my_sale[items]
    c.drawRightString(7*inch,line_y*inch,str(sub_total)) # Sub Total 
    total=round(total+sub_total,1)
    line_y=line_y-row_gap
c.drawRightString(7*inch,2.1*inch,str(float(total))) # Total 
discount=round((discount_rate/100) * total,1)
c.drawRightString(4*inch,1.8*inch,str(discount_rate)+'%') # discount
c.drawRightString(7*inch,1.8*inch,'-'+str(discount)) # discount
tax=round((tax_rate/100) * (total-discount),1)
c.drawRightString(4*inch,1.2*inch,str(tax_rate)+'%') # tax 
c.drawRightString(7*inch,1.2*inch,str(tax)) # tax 
total_final=total-discount+tax
c.setFont("Times-Bold", 22)
c.setFillColorRGB(1,0,0) # font colour
c.drawRightString(7*inch,0.8*inch,str(total_final)) # tax 
c.showPage()
c.save()

Python PDF PDF Mark sheet by using data from SQLite database Table from different data sources to PDF file Table from Pandas DataFrame to PDF file

Subscribe to our YouTube Channel here

Mark sheet in PDF using data from database

invoice_data.py

temp_invoice.py

invoice.py

Subscribe