def __init__(self, win) :

''' It is a reserved function in Python class which makes all the function initialize the attributes inside
the class. It is also called as a constructor is object oriented terminology. '''

[Link] = win
[Link]("800x500+300+150")
[Link]("Salary Manager")
# [Link](bg = "#15350204f")

st = StringVar()
[Link] = IntVar()

def main_table() :

''' The function main_table() is used for creating the table and the database in MySql. Here I have
use
Exceptional Handling for checking that the database is already created or not. Using different
exceptions, I have created a database named salarymanagement and table name main in MySql
server. Using
the module [Link], I have inserted columns in the table. '''

[Link]("create table main"

"("
"Name varchar(25), "
"Age mediumint, "
"Gender char(7), "
"Password varchar(100) NOT NULL, "
"Job char(5), "
"Job_Interval char(5), "
"Salary int, "
"Extra_Income "
"mediumint, "
"House_Rent mediumint, "
"Electric_Bill mediumint, "
"Food mediumint, "
"Cooking mediumint, "
"Health mediumint, "
"Education mediumint, "
"Water_Supply mediumint, "
"Shopping mediumint, "
"Travelling mediumint, "
"Internet mediumint,"
"Savings mediumint, "
"Loan mediumint, "
"Extra mediumint, "
 "Donations mediumint"
")"
"")

[Link] = [Link](host = "localhost", user = "root", passwd = "18180612")

[Link] = [Link]()

try :

[Link]("create database salarymanagement")

[Link] = [Link](host = "localhost", user = "root", passwd = "18180612", database =
"salarymanagement")
[Link] = [Link]()

except [Link] :

[Link] = [Link](host = "localhost", user = "root", passwd = "18180612", database =

"salarymanagement")
[Link] = [Link]()

try :

main_table()

except [Link] :
pass

finally :

try :

main_table()

except [Link] :

pass

self.home_frame = Frame(win, width = 800, height = 500, bg = "#17616E")

self.home_frame.place(x = 0, y = 0)

self.lab1 = Label(self.home_frame, text = "Name :", bg = "#17616E", fg = "white", font = "agencyfb")

self.lab2 = Label(self.home_frame, text = "Age :", bg = "#17616E", fg = "white", font = "agencyfb")
[Link] = Label(self.home_frame, text = "Password :", bg = "#17616E")
[Link](fg = "white", font = "agencyfb")
[Link] = Label(self.home_frame, text = "Please Login / Sign Up to continue :")
[Link](bg = "#17616E", fg = "#A09995", font = "agencyfb")

[Link](x = 300, y = 175)

 [Link](x = 300, y = 200)
[Link](x = 300, y = 225)
[Link](x = 294, y = 140)

def coountdown(time, fab) :

''' This function coountdown() is used for time interval. I have used this function several time for
vanishing different frames. '''

if time == -1 :
[Link]()
else :
[Link](500, coountdown, time-1, fab)

fab = Frame([Link], bg = "white", width = 800, height = 500)

[Link](x = 0, y = 0)
coountdown(2, fab)

basewidth = 300
img = [Link]('[Link]')
# wpercent = (basewidth/float([Link][0]))
# hsize = int((float([Link][1])*float(wpercent)))
im = [Link]((90,90), [Link])
imgii = [Link](im)
imi = [Link]((150, 130), [Link])
imgia = [Link](imi)

panel = Label(fab, image = imgii)

[Link] = imgii
[Link](x = 355, y = 205)

varm = IntVar()
st = StringVar()
st1 = StringVar()
[Link] = IntVar()

def mark() :

''' The function mark() is used for hiding password in the first frame or login page. This function is
embedded inside the Checkbutton widget so that if the button is checked then the password will
bo shown
or for any other case it will be replaced by a star(*). '''

if [Link]() == 1 :

[Link](show = "")
[Link](text = "Hide")
 elif [Link]() == 0 :

[Link](show = "*")
[Link](text = "Show")

[Link] = Entry(self.home_frame, textvariable = st, font = "Arial", bg = "#FDFEFE", width = 16,

fg = "#F02D94", bd = 0, selectbackground = "#B9AA8F")
[Link] = Entry(self.home_frame, textvariable = [Link], font = "Arial", bg = "#FDFEFE", width = 16,
fg = "#F02D94", bd = 0, selectbackground = "#B9AA8F")
[Link] = Entry(self.home_frame,textvariable = st1, show = "*", font = "Arial", bg =
"#FDFEFE",
width = 16, fg = "#FDFEFE", bd = 0, selectbackground = "#FDFEFE")
check = Checkbutton(self.home_frame, text = "Show", command = mark, font = "Arial", bd = 0)
[Link](onvalue = 1, offvalue = 0, variable = varm, bg = "#17616E", fg = "white",
activebackground = "#2A7888")

[Link](x = 385, y = 175)

[Link](x = 385, y = 200)
[Link](x = 385, y = 225)
[Link](x = 534, y = 225)

[Link] = "Subham Das\n"

def like(event) :

''' The function like() is used to display the image in the login frame and it also display the about
section of application by double clicking on the image. I have also packed a button named Out to
exiting
about frame displayed on the main frame. '''

creator_info = Frame(self.home_frame, width = 600, height = 380)

creator_info.place(x = 100, y = 60)

messg_widget = Message(creator_info, text = [Link], bg = "pink", fg = "black")

messg_widget.place(x = 100, y = 100)

def destrot() :

''' This small function destrot() is packed inside the Button named out for destroying the about
frame or to clear the about section. '''

creator_info.destroy()

quite = Button(creator_info,text = "Out", command = destrot, bd = 0, fg = "red")

[Link](x = 570, y = 0)

top = Button(self.home_frame, image = imgia, bd = 0)

[Link]('<Double-Button>', like)
 [Link] = imgia
[Link](x = 25, y = 25)

# [Link] = ""
# [Link] = ""
[Link] = False

#[Link]('management_ico.ico')

def options() :

''' The function options() is used for displaying the different genders in the login page. I have used
the OptionMenu widget for making the Option Button. This options are specified with the four
different
strings. '''

self.lab3 = Label(self.home_frame, text = "Gender :", bg = "#17616E", fg = "white", font =

"agencyfb")
[Link](x = 300, y = 250)

options = [
" None ",
" Male ",
" Female ",
" Others "
]

st = StringVar()
[Link](options[0])
[Link] = OptionMenu(self.home_frame, st, options[0], options[1], options[2], options[3])
[Link](bd = 0, height = 1, width = 12, font = "Arial", bg = "#FDFEFE", fg =
"#F02D94",
activebackground = "#B6C1C3")
[Link](x = 385, y = 250)
self.optnbtn1 = "gg"

options()

def service() :

''' This function service() is designed to store the Earnings of a person in a regular basis in the
service sector. I have specified different entry box using the Entry widget to store the data of their
expenses in our MySql server. '''

self.service_frame = Frame([Link], width = 800, height = 500, bg = "dimgrey")

self.service_frame.place(x = 0, y = 0)

self.var5 = IntVar()
 self.var6 = IntVar()

[Link](0)
[Link](0)

[Link] = "servi"

# self.day_1.place_forget()
# self.week_1.place_forget()
# self.month_1.place_forget()

self.lab5 = Label(self.service_frame, text = "EARNINGS")

self.lab6 = Label(self.service_frame, text = "SALARY :")
self.lab7 = Label(self.service_frame, text = "EXTRA INCOME :")

[Link](bd = 0, bg = "dimgrey", fg = "white", font = "arialroundedmtbold")

[Link](bd = 0, bg = "dimgrey", fg = "white", font = "arialroundedmtbold")
[Link](bd = 0, bg = "dimgrey", fg = "white", font = "arialroundedmtbold")

[Link](x = 375, y = 155)

[Link](x = 250, y = 250)
[Link](x = 250, y = 325)

self.salary_1 = Entry(self.service_frame, textvariable = self.var5)

self.extra_1 = Entry(self.service_frame, textvariable = self.var6)
self.salary_1.place(x = 390, y = 250)
self.extra_1.place(x = 390, y = 325)

''' Here I have just extract the username and password from MySql server to check weather this
account is
already registered or not. If registered, then it will extract the values of Earnings and Extra from
MySql
server and placed it in the entry field as it was saved earlier by the owner of that account. It
means
it will be recovered every time when it is logged in. '''

user = str([Link]())
passwd = b64encode(bytes([Link](), "utf-16")).decode()

[Link]("select * from main where Name = '%s' and Password = '%s'" % (str(user),
str(passwd)))
rud = [Link]()

if rud :

[Link]("select Salary, Extra_Income from main where Name = '%s'and Job = 'servi'" %
(user))
 nod = [Link]()

if nod :

rd = [Link](nod)

[Link](rd[0])
[Link](rd[1])

self.salary_1.configure(textvariable = self.var5)
self.extra_1.configure(textvariable = self.var6)

submit = Button(self.service_frame, text = "SUBMIT", command = expenses)

[Link](bd = 0, bg = "grey", fg = "red", font = "agencyfb", width = 10)
[Link](x = 390, y = 375)

[Link] = Button([Link], text = "12", command = account, bd = 0)

[Link](x = 0, y = 240)

def business() :

''' This function business() is designed to store the Earnings of a person in a regular basis in the
business sector. I have specified different entry box using the Entry widget to store the data of
their
income in our MySql server. '''

self.business_frame = Frame([Link], width = 800, height = 500, bg = "dimgrey")

self.business_frame.place(x = 0, y = 0)

self.var5 = IntVar()
self.var6 = IntVar()

[Link](0)
[Link](0)

[Link] = "busin"

# self.day_2.place_forget()
# self.week_2.place_forget()
# self.month_2.place_forget()

self.lab8 = Label(self.business_frame, text = "EARNINGS")

self.lab9 = Label(self.business_frame, text = "SALARY :")
self.lab10 = Label(self.business_frame, text = "EXTRA INCOME :")

[Link](bd = 0, bg = "dimgrey", fg = "white", font = "arialroundedmtbold")

[Link](bd = 0, bg = "dimgrey", fg = "white", font = "arialroundedmtbold")
[Link](bd = 0, bg = "dimgrey", fg = "white", font = "arialroundedmtbold")
 [Link](x = 375, y = 155)
[Link](x = 250, y = 250)
[Link](x = 250, y = 325)

self.salary_1 = Entry(self.business_frame, textvariable = self.var5)

self.extra_1 = Entry(self.business_frame, textvariable = self.var6)
self.salary_1.place(x = 390, y = 250)
self.extra_1.place(x = 390, y = 325)

''' Here I have just extract the username and password from MySql server to check weather this
account is
already registered or not. If registered, then it will extract the values of Earnings and Extra from
MySql
server and placed it in the entry field as it was saved earlier by the owner of that account. It
means
it will be recovered every time when it is logged in. '''

user = str([Link]())
passwd = b64encode(bytes([Link](), "utf-16")).decode()

[Link]("select * from main where Name = '%s' and Password = '%s'" % (str(user),
str(passwd)))
rud = [Link]()

if rud:

[Link]("select Salary, Extra_Income from main where Name = '%s'and Job = 'busin'" %
(user))
nod = [Link]()

if nod :

rd = [Link](nod)

[Link](rd[0])
[Link](rd[1])

self.salary_1.configure(textvariable = self.var5)
self.extra_1.configure(textvariable = self.var6)

submit = Button(self.business_frame, text = "SUBMIT", command = expenses)

[Link](bd = 0, bg = "grey", fg = "red", font = "agencyfb", width = 10)
[Link](x = 390, y = 375)

[Link] = Button([Link], text = "12", command = account, bd = 0)

[Link](x = 0, y = 240)
 def expenses() :

''' This function expenses() creates a frame that consists of different expenses of life. Here are
different entry box with different labels for users convenient. I have specified different entry box
using
the Entry widget to store the data of their expenses in our MySql server. '''

if self.salary_1.get() != "" or self.extra_1.get() != "" :

self.frame2 = Frame([Link], bg = "blue", width = 800, height = 500)

[Link](x = 0, y = 0)

[Link] = Button([Link], text = "12", command = account, bd = 0)

[Link](x = 0, y = 240)

self.lab14 = Label(self.frame2, text = "EXPENSES", bd = 0)

[Link](fg = "yellow", bg = "blue", font = "agencyfb")
[Link](x = 375, y = 50)

self.var7 = IntVar()
self.var8 = IntVar()
self.var9 = IntVar()
self.var10 = IntVar()
self.var11 = IntVar()
self.var12 = IntVar()
self.var13 = IntVar()
self.var14 = IntVar()
self.var15 = IntVar()
self.var16 = IntVar()
self.var17 = IntVar()
self.var18 = IntVar()
self.var19 = IntVar()
self.var20 = IntVar()

[Link](0)
[Link](0)
[Link](0)
[Link](0)
[Link](0)
[Link](0)
[Link](0)
[Link](0)
[Link](0)
[Link](0)
[Link](0)
[Link](0)
[Link](0)
[Link](0)
lab15 = Label(self.frame2, text = "HOUSE RENT", bd = 0)
lab16 = Label(self.frame2, text = "ELECTRIC BILLS", bd = 0)
lab17 = Label(self.frame2, text = "FOOD", bd = 0)
lab18 = Label(self.frame2, text = "COOKING EMENITIES", bd = 0)
lab19 = Label(self.frame2, text = "HEALTH", bd = 0)
lab20 = Label(self.frame2, text = "EDUCATION", bd = 0)
lab21 = Label(self.frame2, text = "WATER SUPPLY", bd = 0)
lab22 = Label(self.frame2, text = "SHOPPING", bd = 0)
lab23 = Label(self.frame2, text = "TRAVELLING", bd = 0)
lab24 = Label(self.frame2, text = "INTERNET &", bd = 0)
lab24_a = Label(self.frame2, text = "COMMUNICATION BILLS", bd = 0)
lab25 = Label(self.frame2, text = "SAVINGS", bd = 0)
lab26 = Label(self.frame2, text = "LOAN REPAYMENT", bd = 0)
lab27 = Label(self.frame2, text = "EXTRA", bd = 0)
lab28 = Label(self.frame2, text = "DONATIONS", bd = 0)

[Link](fg = "#AC6D0F", bg = "blue", font = "Arial")

[Link](fg = "#AC6D0F", bg = "blue", font = "Arial")
[Link](fg = "#AC6D0F", bg = "blue", font = "Arial")
[Link](fg = "#AC6D0F", bg = "blue", font = "Arial")
[Link](fg = "#AC6D0F", bg = "blue", font = "Arial")
[Link](fg = "#AC6D0F", bg = "blue", font = "Arial")
[Link](fg = "#AC6D0F", bg = "blue", font = "Arial")
[Link](fg = "#AC6D0F", bg = "blue", font = "Arial")
[Link](fg = "#AC6D0F", bg = "blue", font = "Arial")
[Link](fg = "#AC6D0F", bg = "blue", font = "Arial")
lab24_a.configure(fg = "#AC6D0F", bg = "blue", font = "Arial")
[Link](fg = "#AC6D0F", bg = "blue", font = "Arial")
[Link](fg = "#AC6D0F", bg = "blue", font = "Arial")
[Link](fg = "#AC6D0F", bg = "blue", font = "Arial")
[Link](fg = "#AC6D0F", bg = "blue", font = "Arial")

#intt = IntVar()
[Link] .set(0)

self.entry15 = Entry(self.frame2, textvariable = self.var7, bd = 0)

self.entry16 = Entry(self.frame2, textvariable = self.var8, bd = 0)
self.entry17 = Entry(self.frame2, textvariable = self.var9, bd = 0)
self.entry18 = Entry(self.frame2, textvariable = self.var10, bd = 0)
self.entry19 = Entry(self.frame2, textvariable = self.var11, bd = 0)
self.entry20 = Entry(self.frame2, textvariable = self.var12, bd = 0)
self.entry21 = Entry(self.frame2, textvariable = self.var13, bd = 0)
self.entry22 = Entry(self.frame2, textvariable = self.var14, bd = 0)
self.entry23 = Entry(self.frame2, textvariable = self.var15, bd = 0)
self.entry24 = Entry(self.frame2, textvariable = self.var16, bd = 0)
self.entry25 = Entry(self.frame2, textvariable = self.var17, bd = 0)
self.entry26 = Entry(self.frame2, textvariable = self.var18, bd = 0)
 self.entry27 = Entry(self.frame2, textvariable = self.var19, bd = 0)
self.entry28 = Entry(self.frame2, textvariable = self.var20, bd = 0)

self.total_print = Label(self.frame2, text = 0, bd = 0)

[Link] = Label(self.frame2, text = "TOTAL EXPENSES", bd = 0)

''' Here again I have checked for account verification so that the data can be replaced with the
existing data stored in the MySql database for any similar username and password. So that it
will be
easy for user to update their existing data in the frame. '''

[Link] = [Link](host = "localhost", user = "root", passwd = "18180612",

database = "salarymanagement")
[Link] = [Link]()

user = [Link]()
passwd = b64encode(bytes([Link](), "utf-16")).decode()

[Link]("select * from main where Name = '%s' and Password = '%s'" % (str(user),
str(passwd)))
rud = [Link]()

if rud :

def if_login() :

''' In this function if_login() we have extracted all the values of daily expenses
from database as stored by the user. I have also used a if structure before calling of this
function, that will help if the given username and password matched with the data stored
earlier in the database, otherwise it will create a new row for the new user. '''

rd = [Link](rud)

self.var1 = StringVar()
self.var2 = IntVar()
# self.var3 = StringVar()
self.var4 = StringVar()
self.var5 = IntVar()
self.var6 = IntVar()
self.var7 = IntVar()
self.var8 = IntVar()
self.var9 = IntVar()
self.var10 = IntVar()
self.var11 = IntVar()
self.var12 = IntVar()
self.var13 = IntVar()
self.var14 = IntVar()
self.var15 = IntVar()
self.var16 = IntVar()
self.var17 = IntVar()
self.var18 = IntVar()
self.var19 = IntVar()
self.var20 = IntVar()

[Link](rd[0][0])
[Link](rd[0][1])
# [Link](rd[0][2])
[Link](rd[0][3])
[Link](rd[0][6])
[Link](rd[0][7])
[Link](rd[0][8])
[Link](rd[0][9])
[Link](rd[0][10])
[Link](rd[0][11])
[Link](rd[0][12])
[Link](rd[0][13])
[Link](rd[0][14])
[Link](rd[0][15])
[Link](rd[0][16])
[Link](rd[0][17])
[Link](rd[0][18])
[Link](rd[0][19])
[Link](rd[0][20])
[Link](rd[0][21])

[Link](textvariable = self.var1)
[Link](textvariable = self.var2)
# [Link](textvariable = self.var3)
[Link](textvariable = self.var4)
self.salary_1.configure(textvariable = self.var5)
self.extra_1.configure(textvariable = self.var6)
[Link](textvariable = self.var7)
[Link](textvariable = self.var8)
[Link](textvariable = self.var9)
[Link](textvariable = self.var10)
[Link](textvariable = self.var11)
[Link](textvariable = self.var12)
[Link](textvariable = self.var13)
[Link](textvariable = self.var14)
[Link](textvariable = self.var15)
[Link](textvariable = self.var16)
[Link](textvariable = self.var17)
[Link](textvariable = self.var18)
[Link](textvariable = self.var19)
[Link](textvariable = self.var20)
 if_login()
[Link]()

def click() :

''' This function click() mainly used for collecting all the data from the entry boxes of
expenses an to check weather the total expenses is less that the total income including extra
income. If it is more that the income then it will show a error message, so that user can
understand the problem so that it can be changed into correct form. '''

self.lst_total = [
int([Link]()),
int([Link]()),
int([Link]()),
int([Link]()),
int([Link]()),
int([Link]()),
int([Link]()),
int([Link]()),
int([Link]()),
int([Link]()),
int([Link]()),
int([Link]()),
int([Link]()),
int([Link]())
]

[Link] = 0
for i in range(0, len(self.lst_total)):
[Link] = [Link] + self.lst_total[i]

inc_1 = int(self.salary_1.get()) + int(self.extra_1.get())

if [Link] > inc_1 :

error = Frame(self.frame2, bd = 0, bg = "red", width = 800, height = 100)

[Link](x = 250, y = 245)
error_lab = Label(error, text = "YOUR INCOME IS LESS TO FULFILL YOUR EXPENSE")
error_lab.configure(bd = 0, fg = "black", bg = "red")
error_lab.pack()
self.total_print.configure(text = [Link])

coountdown(6, error)

def error_ok() :

''' The function error_ok() is used delete a error frame created due to a debug in the
program to make this simple and understandable. '''
 error.place_forget()
#sleep(5)

error_btn = Button(error, text = "Ok", command = error_ok, bd = 0)

error_btn.pack()

else :

database()
self.total_print.configure(text = [Link])

stat()

click_btn = Button(self.frame2, text = "Enter", command = click, bd = 0)

click_btn.configure()

[Link](x = 50, y = 100)

[Link](x = 50, y = 150)
[Link](x = 50, y = 200)
[Link](x = 50, y = 250)
[Link](x = 50, y = 300)
[Link](x = 50, y = 350)
[Link](x = 50, y = 400)
[Link](x = 450, y = 100)
[Link](x = 450, y = 150)
[Link](x = 450, y = 200)
lab24_a.place(x = 450, y = 220)
[Link](x = 450, y = 250)
[Link](x = 450, y = 300)
[Link](x = 450, y = 350)
[Link](x = 450, y = 400)
[Link](x = 280, y = 445)
self.total_print.place(x = 480, y = 440)
click_btn.place(x = 380, y = 475)

[Link](x = 200, y = 100)

[Link](x = 200, y = 150)
[Link](x = 200, y = 200)
[Link](x = 200, y = 250)
[Link](x = 200, y = 300)
[Link](x = 200, y = 350)
[Link](x = 200, y = 400)
[Link](x = 600, y = 100)
[Link](x = 600, y = 150)
[Link](x = 600, y = 200)
[Link](x = 600, y = 250)
[Link](x = 600, y = 300)
 [Link](x = 600, y = 350)
[Link](x = 600, y = 400)

else :

fabu = Label([Link], text = "Please enter your Name and Password")

[Link](bg = "#15350204f", fg = "black")
[Link](x = 300, y = 345)
coountdown(5, fabu)

def stat() :

''' This function stat() will create a frame with three buttons for three types of graph. This was
made
so that user can get graphical or tabular view of his/her daily expenses. '''

self.frame2.place_forget()
[Link] = Frame([Link], bg = "pink", width = 800, height = 500)
[Link] (x = 0, y = 0)

ab = Label([Link], text = "STATISTICAL INTERPETATION")

[Link](x = 340, y = 35)

self.line_graph = Button([Link], text = "LINE GRAPH", command = line_graphical)

self.bar_graph = Button([Link], text = "BAR GRAPH", command = bar_graphical)
self.pie_graph = Button([Link], text = "PIE CHART", command = pie_graphical)

self.line_graph.configure(bd = 0, width = 15, height = 6, bg = "dark green", activebackground =

"#15350204f", font = "arialroundedmtbold", relief = SUNKEN)
self.bar_graph.configure(bd = 0, width = 15, height = 6, bg = "dark green", activebackground =
"#15350204f", font = "arialroundedmtbold", relief = SUNKEN)
self.pie_graph.configure(bd = 0, width = 15, height = 6, bg = "dark green", activebackground =
"#15350204f", font = "arialroundedmtbold", relief = SUNKEN)

self.line_graph.place(x = 166, y = 160)

self.bar_graph.place(x = 482, y = 160)
self.pie_graph.place(x = 320, y = 330)

[Link] = Button([Link], text = "12", command = account, bd = 0)

[Link](x = 0, y = 240)

def line_graphical() :

''' The function line_graphical() is directed from the statt frame. Here using matplotlib and pyplot,
I have plotted the data in format of line graph. For this I have used canvas and figure function
from
tkinter and matplotlib respectively. At first I have created a figure and then the data was plotted
 inside the line graph. After that the image was placed inside the canvas and then on main frame
of the
window. '''

[Link].place_forget()

self.graph_frame = Frame([Link], bg = "green", width = 800, height = 500)

self.graph_frame.place(x = 0, y = 0)

fig = Figure(figsize = (8, 5), dpi = 100)

[Link]("Money Spent")

b = []
a=[
"HOUSE RENT",
"ELECTRIC BILLS",
"FOOD",
"COOKING EMENITIES",
"HEALTH",
"EDUCATION",
"WATER SUPPLY",
"SHOPPING",
"TRAVELLING",
"INTERNET & COMMUNICATION",
"SAVINGS",
"LOAN REPAYMENT",
"EXTRA",
"DONATIONS"
]

for i in self.lst_total :
[Link](i)

graph = fig.add_subplot(122)
[Link](b, a, marker = "o")
[Link]()

canv = FigureCanvasTkAgg(fig, master = self.graph_frame)

[Link]()

get_widz = canv.get_tk_widget()
get_widz.pack()

[Link] = Button(self.graph_frame, text = "BACK", command = stat)

[Link](bd = 0, bg = "black", fg = "white", activebackground = "#15350204f",
font = "arialroundedmtbold", relief = SUNKEN)
[Link](x = 0, y = 0)
 def bar_graphical() :

''' The function bar_graphical() is directed from the statt frame. Here using matplotlib and pyplot,
I have plotted the data in format of bar graph. For this I have used canvas and figure function
from
tkinter and matplotlib respectively. At first I have created a figure and then the data was plotted
inside the line graph. After that the image was placed inside the canvas and then on main frame
of the
window. In the same way like the line graph. '''

[Link].place_forget()

self.br_grph = Frame([Link], bg = "green", width = 800, height = 500)

self.br_grph.place(x = 0, y = 0)

fig = Figure(figsize = (8, 5), dpi = 100)

[Link]("Money Spent")

b = []
a=[
"HOUSE RENT",
"ELECTRIC BILLS",
"FOOD",
"COOKING EMENITIES",
"HEALTH",
"EDUCATION",
"WATER SUPPLY",
"SHOPPING",
"TRAVELLING",
"INTERNET & COMMUNICATION",
"SAVINGS",
"LOAN REPAYMENT",
"EXTRA",
"DONATIONS"
]

for i in self.lst_total:
[Link](i)

graph = fig.add_subplot(122)
[Link](a, b)
[Link]()

canv = FigureCanvasTkAgg(fig, master = self.br_grph)

[Link]()

get_widz = canv.get_tk_widget()
get_widz.pack()
 [Link] = Button(self.br_grph, text = "BACK", command = stat)
[Link](bd = 0, bg = "black", fg = "white", activebackground = "#15350204f",
font = "arialroundedmtbold", relief = SUNKEN)
[Link](x = 0, y = 0)

def pie_graphical() :

''' The function pie_graphical() is directed from the statt frame. Here using matplotlib and pyplot,
I have plotted the data in format of pie graph. For this I have used canvas and figure function from
tkinter and matplotlib respectively. At first I have created a figure and then the data was plotted
inside the line graph. After that the image was placed inside the canvas and then on main frame
of the
window. In the same way like the line graph & and bar graph. '''

[Link].place_forget()

self.pie_grph = Frame([Link], bg = "green", width = 800, height = 500)

self.pie_grph.place(x = 0, y = 0)

fig = Figure(figsize = (8, 5), dpi = 100)

[Link]("Money Spent")

b = []
a=[
"HOUSE RENT",
"ELECTRIC BILLS",
"FOOD",
"COOKING EMENITIES",
"HEALTH",
"EDUCATION",
"WATER SUPPLY",
"SHOPPING",
"TRAVELLING",
"INTERNET & COMMUNICATION",
"SAVINGS",
"LOAN REPAYMENT",
"EXTRA",
"DONATIONS"
]

for i in self.lst_total :
[Link](i)

graph = fig.add_subplot(111)
[Link](b, labels = a)

canv = FigureCanvasTkAgg(fig, master = self.pie_grph)

 [Link]()

get_widz = canv.get_tk_widget()
get_widz.pack()

[Link] = Button(self.pie_grph, text = "BACK", command = stat)

[Link](bd = 0, bg = "black", fg = "white", activebackground = "#15350204f",
font = "arialroundedmtbold", relief = SUNKEN)
[Link](x = 0, y = 0)

def database() :

''' This function database() once again checks for account verification so that the expenses can be
stored in the MySql database. If the condition satisfied the it will restore the old data of thar user
otherwise it will insert the new data of that new user. This thing will make the whole program
more
user-friendly, so there will be no need to remember the old data by user. '''

user = [Link]()
passwd = b64encode(bytes([Link](), "utf-16")).decode()

[Link]("select * from main where Name = '%s' and Password = '%s'" % (str(user),
str(passwd)))
rud = [Link]()

def inserting() :

''' The function inserting() is fully based on the module [Link], because this function
working on the department of inserting all the data of user starting from Name or username to
daily
expenses and total amount that have spent by user. Here I have extracted the all the data from
the
entry boxes using the syntax <entry>.get() function and put it into different columns of the
table
main main in MySql database. '''

[Link] = [Link]()
[Link]("insert into main values"
"("
"'{}', {}, '{}', '{}', '{}', '{}', {}, {}, {}, {}, {},"
" {}, {}, {}, {}, {}, {}, {},{}, {}, {}, {})"
.format
(
str([Link]()),
[Link](),
str(self.optnbtn1),
b64encode(bytes([Link](), "utf-16")).decode(),
str([Link]),
 str([Link]),
int(self.salary_1.get()),
int(self.extra_1.get()),
[Link](),
[Link](),
[Link](),
[Link](),
[Link](),
[Link](),
[Link](),
[Link](),
[Link](),
[Link](),
[Link](),
[Link](),
[Link](),
[Link]()
))

if rud :

print("Welcome")
inserting()
[Link]()

else :

inserting()
[Link]()
print("Account Created")

[Link]()
[Link]()

def add_income_again() :

''' The function add_income_again() is called inside the settings tab Add Income. The function will
redirect the user the service or business income page. Whenever user will press that button,
the frame will be replaced by that frame. '''

[Link] = [Link](host = "localhost", user = "root", passwd = "18180612", database =

"salarymanagement")
[Link] = [Link]()

user = [Link]()
passwd = b64encode(bytes([Link](), "utf-16")).decode()
 [Link]("select Job from main where Name = '%s' and Password = '%s'" % (str(user),
str(passwd)))
rud = [Link]()

try :

if rud[-1][0] == "servi" :

service()

elif rud[-1][0] == "busin" :

business()

except IndexError :

if [Link] == "servi" :

service()

elif [Link] == "busin" :

business()

def account_setting() :

''' This function account_setting() is a part of settings where user can change their name as well
their
age too. Here one frame will be slided from left side of the window for settings options. The
frame was
a rectangle of dimension 250 x 500. '''

[Link].pack_forget()

# intt = IntVar()
varm = IntVar()
st = StringVar()
st1 = StringVar()
[Link]([Link]())
[Link]([Link]())
[Link]([Link]())
[Link] = True

self.frame1 = Frame([Link], bg = "lightpink", width = 250, height = 500)

[Link](x = 0, y = 0)

name_entry = Entry(self.frame1, textvariable = st)

age_entry = Entry(self.frame1, textvariable = [Link])
 password_entry = Entry(self.frame1, textvariable = st1, show = "*")
name_entry.configure(bd = 1, width = 17)
age_entry.configure(bd = 1, width = 17)

def mark_2() :

''' The function mark_2() is same as the mark() at top level, used for hiding password in the first
frame or login page. This function is embedded inside the Checkbutton widget so that if the
button is
checked then the password will bo shown or for any other case it will be replaced by a star(*).
'''

if [Link]() == 1 :

password_entry.configure(show = "")
[Link](text = "Hide")

elif [Link]() == 0 :

password_entry.configure(show = "*")
[Link](text = "Show")

def update_account() :

''' The function update_account() will change their name to the new name given by that user.
Here I
am just shifting the values name & age that we are getting from login page to the new name
and age
in the settings section. '''

[Link] = name_entry
[Link] = age_entry
[Link] = password_entry

btn_name = Button(self.frame1, text = "Change Name", command = update_account)

btn_age = Button(self.frame1, text = "Change Age", command = update_account)
btn_password = Button(self.frame1, text = "Change Password", command = update_account)

check = Checkbutton(self.frame1, text = "Show", command = mark_2, font = "Arial", bd = 0)

[Link](onvalue = 1, offvalue = 0, variable = varm, bg = "lightpink", fg = "white",
activebackground = "pink")

name_entry.place(x = 10, y = 150)

age_entry.place(x = 10, y = 230)
password_entry.place(x = 10, y = 310)

btn_name.place(x = 140, y = 150)

btn_age.place(x = 140, y = 230)
 btn_password.place(x = 140, y = 310)
[Link](x = 10, y = 350)

def account() :

''' The function account() is used to create a frame with several options like about, updating
name & age, quit etc. for users benefits. This will also show your name at the top of the frame.
The
main work of this function is for account settings. '''

# [Link].place_forget()
[Link](text = "21", command = account_update)
[Link].place_configure(x = 250, y = 240)
# [Link] = Button([Link], text = "21", command = account_update)
# [Link](x = 250, y = 240)
[Link] = Frame([Link], bg = "red", width = 250, height = 500)
[Link](side = LEFT)

lab11 = Label([Link], text = "Hello", font = "agencyfb", bd = 0)

[Link](bg = "red", fg = "white")
lab12 = Label([Link], text = [Link](), font = "agencyfb", bd = 0)
lab13 = Label([Link], text = "-"*50, bd = 0)
[Link](font = "agencyfb", bg = "red", fg = "white")
[Link](bg = "red", fg = "blue")

[Link](x = 100, y = 40)

[Link](x = 75, y = 65)
[Link](x = 0, y = 90)

def like() :

''' The function like() is used for showing the about section of the program. The work of the
function is to place the about frame. '''

creator_info = Frame([Link], width = 600, height = 380)

creator_info.place(x = 100, y = 60)

messg_widget = Message(creator_info, text = [Link], bg = "pink", fg = "black")

messg_widget.place(x = 100, y = 100)

def destrot() :

''' The function destrot() was used to destroy the about frame. Simply it is used as a cross
button which exit a window. '''

creator_info.destroy()

quite = Button(creator_info, text = "Out", command = destrot, bd = 0, fg = "red")

 [Link](x = 570, y = 0)

accsettings = Button([Link], text = "Account Settings", command = account_setting, font =

"agencyfb")
addincome = Button([Link], text = "Add Income", font = "agencyfb", command =
add_income_again)
about = Button([Link], text = "ABOUT", font = "agencyfb", command = like)
quit = Button([Link], text = "Quit",font = "agencyfb", command = [Link])
[Link](bg = "red", fg = "white", bd = 0)
[Link](bg = "red", fg = "white", bd = 0)
[Link](bd = 0, bg = "red", fg = "white")
[Link](bg = "red", fg = "white", bd = 0)

[Link](x = 70, y = 160)

[Link](x = 70, y = 245)
[Link](x = 70, y = 330)
[Link](x = 70, y = 415)

def account_update() :

''' The function account_update() was just used for the sliding part of the account setting frame.
This
was responsible for the placing and vanishing part of the frame '''

[Link].pack_forget()

if [Link] == True :

self.frame1.place_forget()
[Link](text = "12", command = account)
[Link].place_configure(x = 0, y = 240)
# [Link].pack_forget()

# [Link].place_forget()
# [Link].place_forget()
[Link](text = "12", command = account)
[Link].place_configure(x = 0, y = 240)

''' Here all the function day1(), week1() etc. is responsible for storing the date of the period of
interval
choose by the user. For different conditions it will store different strings in the MySql database. '''

def day1() :

[Link] = "Day"
service()

def week1() :
 [Link] = "Week"
service()

def month1() :

[Link] = "Month"
service()

def day2():

[Link] = "Day"
business()

def week2() :

[Link] = "Week"
business()

def month2() :

[Link] = "Month"
business()

def interval_service() :

''' This function interval_service() will create a frame with time of intervals for service sections.
Every buttons will redirect you to different function specified for this. This is build so that user
can store their income as per their options. '''

self.lab4.place_forget()
[Link].place_forget()
[Link].place_forget()

self.day_1 = Button([Link], text = "per Day", command = day1)

self.week_1 = Button([Link], text = "per Week", command = week1)
self.month_1 = Button([Link], text = "per Month", command = month1)

self.day_1.configure(bg = "lightpink", bd = 0, width = 15, height = 6)

self.week_1.configure(bg = "lightpink", bd = 0, width = 15, height = 6)
self.month_1.configure(bg = "lightpink", bd = 0, width = 15, height = 6)

self.day_1.place(x = 350, y = 80)

self.week_1.place(x = 350, y = 220)
self.month_1.place(x = 350, y = 360)

[Link] = Button([Link], text = "12", command = account, bd = 0)

[Link](x = 0, y = 240)
 def interval_business() :

''' This function interval_business() will create a frame with time of intervals for business sections.
Every buttons will redirect you to different function specified for this. This is build so that user
can store their income as per their options. '''

self.lab4.place_forget()
[Link].place_forget()
[Link].place_forget()

self.day_2 = Button([Link], text = "per Day", command = day2)

self.week_2 = Button([Link], text = "per Week", command = week2)
self.month_2 = Button([Link], text = "per Year", command = month2)

self.day_2.configure(bg = "lightpink", bd = 0, width = 15, height = 6)

self.week_2.configure(bg = "lightpink", bd = 0, width = 15, height = 6)
self.month_2.configure(bg = "lightpink", bd = 0, width = 15, height = 6)

self.day_2.place(x = 350, y = 80)

self.week_2.place(x = 350, y = 220)
self.month_2.place(x = 350, y =360)

[Link] = Button([Link], text = "12", command = account, bd = 0)

[Link](x = 0, y = 240)

def afterenter() :

''' The function afterenter() is called after the enter button clicked in login page. This function will
redirect you from login page to the job frame which will allow to select your job type. I have also
specified a condition that if the entry box of name or username and password is blank then it will
stop
you from entering the job frame.'''

if [Link]() != "" and [Link]() != "" :

self.home_frame.place_forget()
[Link](bg = "dimgrey")

self.lab4 = Label([Link], text = "/", fg = "red", bg ="dimgrey")

[Link](x = 400, y = 210)

[Link] = Button([Link], text = "SERVICE", command = interval_service, bd = 0)

[Link] = Button([Link], text = "BUSINESS", command = interval_business, bd = 0)

[Link](fg = "black", bg = "red", height = 3, width =13)

[Link](activebackground = "blue", activeforeground = "white")
[Link](fg = "black", bg = "red", height = 3, width =13)
 [Link](activebackground = "blue", activeforeground = "white")

[Link](x = 290, y =200)

[Link](x = 430, y = 200)

else :

fabu = Label([Link], text = "Please enter your Name or Password")

[Link](bg = "#17616E", fg = "#A09995")
[Link](x = 300, y = 360)
coountdown(4, fabu)

enter = Button(self.home_frame, text = "Enter", command = afterenter, bg = "#9DC3CA")

[Link](fg = "white", bd = 0, height = 2, activebackground = "#2A7888", width = 15, relief =
SUNKEN)
[Link](activeforeground = "black", highlightcolor = "pink", font = "arialroundedmtbold")
[Link](x = 340, y = 310)

if __name__ == "__main__" :

''' This thing is just checking that we are outside the class or function, if yes then it will call the
respected class startpage() with the parameter window as tkinter window as scripted below. '''

window = Tk()
startpage(window)

[Link]()

@@@@@@@@@@@@