import pandas as pd
import pdfkit
from datetime import datetime, timedelta
import code128
import random#generate costum html file using the arguments
def HTMLgen(code,first_name,last_name,function,date_of_birth,picture,expiration_date):
html= r"""<!doctype html><meta charset="utf-8"><link rel="stylesheet" href="../RES/card.css"><body><div class="face face-front" ><img src="../RES/front.png"></div><div id="infoi"><img src="@picture" height="89.5" width="83" />
<div style="margin-left: 1.3cm;margin-top: -0.6cm;">
<br>
<div style="font-size: 0.7em;margin-top: 5%;font-family: sans-serif;color: aliceblue;text-transform: uppercase;"><b>@fname</b> @lname</div><br>
<div style="font-size: 0.7em;margin-top: -0.4cm;font-family: sans-serif;color: aliceblue;text-t ransform: capitalize;">@function</div>
</div>
</div>
<div id="info">
<br><div style="font-size: 0.7em;margin-top: 0.6%;font-family: sans-serif;text-transform: uppercase;">@code</div>
<br><div style="font-size: 0.7em;margin-top: -0.6%;font-family: sans-serif;text-transform: capitalize;">@date_of_birth</div>
<br><div style="font-size: 0.7em;margin-top: -0.6%;font-family: sans-serif;text-transform: capitalize;">@expiration_date</div>
</div>
<div id="BARCODE"><img src="../RES/bar.PNG" height="20" width="120"/></div>
</body>"""
html = html.replace("@picture",picture)
html = html.replace("@code",str(code))
html = html.replace("@fname",first_name)
html = html.replace("@lname",last_name)
html = html.replace("@function",function)
html = html.replace("@date_of_birth",date_of_birth)
html = html.replace("@expiration_date",expiration_date)
f= open("index.html","w")
f.write(html)
f.close()
return
#generate a file bar.png contains barcode of the 10 digits code
def BARgen(code):
code128.image(code).save("../RES/bar.png")
return
#generate costum pdf file using the existing html file // code argument is only to name the file generated
def PDFgen(code):
config = pdfkit.configuration(wkhtmltopdf='C:\\Program Files\\wkhtmltopdf\\bin\\wkhtmltopdf.exe')
options = {'dpi': 365,'margin-top': '0in','margin-bottom': '0in','margin-right': '0in','margin-left': '0in','page-size': 'A8',"orientation": "Landscape",'disable-smart-shrinking': ''}
pdfkit.from_file('index.html', str(code)+".pdf",configuration=config , options = options)
return
#complete with random digits an integer x until it contains 10 digits
def complete(x):
x=str(x)
while len(x)<10:
x+=str(random.randint(0,9))
return int(x)data=pd.read_excel("../RES/exo_dataset_P001.xlsx")data.head(5)| code | first_name | last_name | function | date_of_birth | submission_date | picture | |
|---|---|---|---|---|---|---|---|
| 0 | 5591927432 | Prent | Hickenbottom | Senior Editor | 4/3/1993 | 22/1/2019 | https://robohash.org/quidemsaepequi.png?size=3... |
| 1 | 5071682362 | Jard | Stein | Geological Engineer | 15/7/1992 | 10/4/2019 | https://robohash.org/teneturautsunt.png?size=3... |
| 2 | 6295398980 | Levon | Noen | Research Assistant IV | 12/10/1999 | 27/3/2019 | https://robohash.org/quaeetsed.png?size=300x30... |
| 3 | 3718164078 | Nonah | Scoggin | Junior Executive | 9/7/2000 | 21/1/2019 | https://robohash.org/debitisinciduntdolore.png... |
| 4 | 2261412840 | Jameson | Hugueville | Teacher | 5/12/1991 | 1/2/2019 | https://robohash.org/facilisrerumad.png?size=3... |
some of the code column entries are only 9 digits or less, so we will add some random degits to them.
data['code'] = data['code'].apply(lambda x: complete(x))data.dtypescode int64
first_name object
last_name object
function object
date_of_birth object
submission_date object
picture object
dtype: object
data['submission_date']=pd.to_datetime(data['submission_date'])
data['date_of_birth'] = pd.to_datetime(data['date_of_birth'])data.dtypescode int64
first_name object
last_name object
function object
date_of_birth datetime64[ns]
submission_date datetime64[ns]
picture object
dtype: object
data.head(5)| code | first_name | last_name | function | date_of_birth | submission_date | picture | |
|---|---|---|---|---|---|---|---|
| 0 | 5591927432 | Prent | Hickenbottom | Senior Editor | 1993-04-03 | 2019-01-22 | https://robohash.org/quidemsaepequi.png?size=3... |
| 1 | 5071682362 | Jard | Stein | Geological Engineer | 1992-07-15 | 2019-10-04 | https://robohash.org/teneturautsunt.png?size=3... |
| 2 | 6295398980 | Levon | Noen | Research Assistant IV | 1999-12-10 | 2019-03-27 | https://robohash.org/quaeetsed.png?size=300x30... |
| 3 | 3718164078 | Nonah | Scoggin | Junior Executive | 2000-09-07 | 2019-01-21 | https://robohash.org/debitisinciduntdolore.png... |
| 4 | 2261412840 | Jameson | Hugueville | Teacher | 1991-05-12 | 2019-01-02 | https://robohash.org/facilisrerumad.png?size=3... |
data["expiration_date"] = data["submission_date"] + timedelta(days=15)data['date_of_birth']=data['date_of_birth'].dt.strftime('%d-%m-%Y')
data['submission_date']=data['submission_date'].dt.strftime('%d-%m-%Y')
data['expiration_date']=data['expiration_date'].dt.strftime('%d-%m-%Y')data.head(5)| code | first_name | last_name | function | date_of_birth | submission_date | picture | expiration_date | |
|---|---|---|---|---|---|---|---|---|
| 0 | 5591927432 | Prent | Hickenbottom | Senior Editor | 03-04-1993 | 22-01-2019 | https://robohash.org/quidemsaepequi.png?size=3... | 06-02-2019 |
| 1 | 5071682362 | Jard | Stein | Geological Engineer | 15-07-1992 | 04-10-2019 | https://robohash.org/teneturautsunt.png?size=3... | 19-10-2019 |
| 2 | 6295398980 | Levon | Noen | Research Assistant IV | 10-12-1999 | 27-03-2019 | https://robohash.org/quaeetsed.png?size=300x30... | 11-04-2019 |
| 3 | 3718164078 | Nonah | Scoggin | Junior Executive | 07-09-2000 | 21-01-2019 | https://robohash.org/debitisinciduntdolore.png... | 05-02-2019 |
| 4 | 2261412840 | Jameson | Hugueville | Teacher | 12-05-1991 | 02-01-2019 | https://robohash.org/facilisrerumad.png?size=3... | 17-01-2019 |
for index, row in data.head(n=5).iterrows() :
code=row[0]
fname = row[1]
lname = row[2]
func = row[3]
dob = row[4]
ed = row[5]
pic = row[6]
BARgen(code)
HTMLgen(code,fname,lname,func,dob,pic,ed)
PDFgen(code)
Loading pages (1/6)
Counting pages (2/6)
Resolving links (4/6)
Loading headers and footers (5/6)
Printing pages (6/6)
Done
