generate.py

from PIL import Image,ImageDraw,ImageFont
import matplotlib.pyplot as plt
import  pandas as pd
from termcolor import colored
from tqdm import tqdm_gui
import os 
from datetime import datetime
import shutil


# Usually a .csv file but here i've used .xlsx file
# Make sure to have 'Name' column in it
file = pd.read_excel('event.csv')

# Uni name is hard coded for CUI only, you can uncomment below option for making it generic
# uniName = input("Enter University Name: ")
uniName = "COMSATS University, Islamabad"

# uniAcronym = input("Enter University Acronym: ")
uniAcronym = "CUI"


eventName = input("Enter Event Name: ")
# leadName = input("Lead Name: ")
leadName = "Muhammad Hamza"

currentDate = datetime.date(datetime.now())

# where certificates will be generated
fname = 'certificates/'
if os.path.exists(fname):
    shutil.rmtree(fname)
os.mkdir(fname)

# Getting 'Name' columns from 'file'
for names in tqdm_gui(file['Name']):
    image = Image.new('RGB',(1920,1080),(255,255,255))

    draw = ImageDraw.Draw(image)
    font_path = './Almondita.ttf'

    # font of DSC
    fontdev = ImageFont.truetype('arial.ttf', size=35)
    # font of Certificate
    fontcert = ImageFont.truetype('arialbd.ttf', size=55)
    # font of participant name
    fontname = ImageFont.truetype('arial.ttf', size=35)
    # font of signature
    signature = ImageFont.truetype(font_path, 150)

    # colors for various writings
    colordev = 'rgb(128, 128, 128)'
    colorcert = 'rgb(89, 89, 89)'
    colorname = 'rgb(77, 148, 255)'
    colorNameDSCLead = 'rgb(229, 57, 53)'


    # DSC logo
    dsc_logo = Image.open('logo.jpg')
    # Resizing the DSC Logo
    dsc_logo = dsc_logo.resize((75,75))

    # Left Side style Image
    side_style = Image.open('leftSide.png')

    # Putting Logo & Left style Image
    image.paste(dsc_logo, (950,125))
    image.paste(side_style, (0,0))


    participation_message = f"is hereby awarded this Certificate of Participation on successfully attending \n{eventName} at {uniName} organized by\nDSC {uniAcronym}."

    draw.text((1040,143),'Developer Student Clubs',font=fontdev,fill=colordev)
    draw.text((950,200),'Certificate of Participation',font=fontcert,fill=colorcert)
    draw.text((950,300), eventName + ' Participant',font=ImageFont.truetype('arial.ttf', size=32), fill=colordev)
    draw.text((950,400),names,font=fontcert,fill=colorname)
    draw.text((950,500),participation_message,font=ImageFont.truetype('arial.ttf', size=25),fill='rgb(102, 102, 102)')
    draw.text((960,650),leadName,font=signature,fill=colorNameDSCLead)
    draw.line((950,800, 1520,800), fill='rgb(128, 128, 128)', width=3)

    draw.text((950,820),f'Developer Student Clubs, {uniAcronym} Lead',font=ImageFont.truetype('./arialbd.ttf', size=22),fill=colorcert)
    draw.text((950,920), 'Signing Authority', font=ImageFont.truetype('arial.ttf', size=22), fill='rgb(128,128,128)')
    draw.text((950,960), 'DSC ' + uniAcronym + ' Lead', font=ImageFont.truetype('./arialbd.ttf', size=25), fill='rgb(128,128,128)')
    draw.text((1640,1020),'#DeveloperStudentClubs',font=ImageFont.truetype('arial_italic.ttf', size=18),fill='rgb(211, 47, 47)')
    draw.text((1640,950),'Certificate ID:',font=ImageFont.truetype('arial.ttf', size=20),fill=colorcert)
    draw.text((1640,980),f'Issue Date: {currentDate}',font=ImageFont.truetype('arial.ttf', size=20),fill=colorcert)
    image.save('certificates/'+names+'.png')