def detail_check_today(parent, self, text_widget, detail_income, detail_expances):
date = self.date_entry_var.get()
retrive = pc_data()
data_list = retrive.retrive(date)
income_and_expances = expances_and_income()
income = income_and_expances.retrive_income_for_text_box(date)
expances = income_and_expances.retrive_expances_for_text_box(date)
c = 1
for x in data_list:
text_widget.insert(INSERT, ' '+'{:<5}'.format(c))
#text_widget.insert(INSERT, '{:>10}'.format(x[1]))
text_widget.insert(INSERT, '{:>10}'.format(x[2]))
text_widget.insert(INSERT, '{:>7}'.format(x[3]))
text_widget.insert(INSERT, '{:>6}'.format(x[4]))
text_widget.insert(INSERT, '{:>5}'.format(x[5]))
text_widget.insert(INSERT, '{:>5}'.format(x[6]))
text_widget.insert(INSERT, '{:>5}'.format(x[7])+'\n\n')
c += 1
for x in income:
detail_income.insert(INSERT, ' '+'{:<20}'.format(x[0])+'{:>5}'.format(x[1])+'\n\n')
for x in expances:
detail_expances.insert(INSERT, ' '+'{:<20}'.format(x[0])+'{:>5}'.format(x[1])+'\n\n')
#text_widget.config(state='disabled')
detail_income.config(state='disabled')
detail_expances.config(state='disabled')
def administrator_from_to_check(parent, self, Total_earned_entry, qty_entry,
total_after_entry, Expances_entry, Other_Income_entry,
difference_entry):
# delete data before insertimg data
Total_earned_entry.delete(0, END)
qty_entry.delete(0, END)
total_after_entry.delete(0, END)
Expances_entry.delete(0, END)
Other_Income_entry.delete(0, END)
difference_entry.delete(0, END)
p = pc_data()
from_to_date = p.retrive_administrator(self.from_date_var.get(),
self.to_date_var.get())
qty = from_to_date['qty']
earned_total = from_to_date['total_rate']
difference_total = from_to_date['total_difference']
i_e_object = expances_and_income()
expance = i_e_object.retrive_administrator_expances(self.from_date_var.get(),
self.to_date_var.get())
income = i_e_object.retrive_administrator_income(self.from_date_var.get(),
self.to_date_var.get())
#income = i_e_object.retrive_income(date)
# Insert data in entries
Total_earned_entry.insert(0,earned_total)
qty_entry.insert(0,qty)
total_after_entry.insert(0, str((int(earned_total)+int(income))-int(expance)))
Expances_entry.insert(0, expance)
Other_Income_entry.insert(0, income)
difference_entry.insert(0, difference_total)
def check_today(parent, self, Total_earned_entry, qty_entry, total_after_entry,
Expances_entry, Other_Income_entry, difference_entry):
# get date from date entry
date = self.date_entry_var.get()
# retrive data from data base based on today date
p = pc_data()
today = p.retrive_today(date)
qty = today['qty']
earned_total = today['total_rate']
difference_total = today['total_difference']
i_e_object = expances_and_income()
expance = i_e_object.retrive_expances(date)
income = i_e_object.retrive_income(date)
# delete data before insertimg data
Total_earned_entry.delete(0, END)
qty_entry.delete(0, END)
total_after_entry.delete(0, END)
Expances_entry.delete(0, END)
Other_Income_entry.delete(0, END)
difference_entry.delete(0, END)
# Insert data in entries
Total_earned_entry.insert(0,earned_total)
qty_entry.insert(0,qty)
total_after_entry.insert(0, str((int(earned_total)+int(income))-int(expance)))
Expances_entry.insert(0, expance)
Other_Income_entry.insert(0, income)
difference_entry.insert(0, difference_total)
def income_done(self, description, amount):
description_get = description.get()
amount_get = amount.get()
if len(description_get) > 0 and len(amount_get) > 0 and amount_get.isdigit():
description.delete(0, END)
amount.delete(0, END)
e_a_i_object = expances_and_income()
e_a_i_object.insert_income(description_get, amount_get)
return None
else:
return None
def admin_detail_check(parent, self, text_widget, detail_income, detail_expances):
retrive = pc_data()
data_list = retrive.admin_detail_pc_data(self.from_date_var.get(), self.to_date_var.get() )
income_and_expances = expances_and_income()
income = income_and_expances.retrive_income_for_text_box_admin(self.from_date_var.get(), self.to_date_var.get() )
expances = income_and_expances.retrive_expances_for_text_box_admin(self.from_date_var.get(), self.to_date_var.get() )
c = 1
for x in data_list:
text_widget.insert(INSERT, ' '+'{:<5}'.format(c))
text_widget.insert(INSERT, '{:>10}'.format(x[1]))
text_widget.insert(INSERT, '{:>10}'.format(x[2]))
text_widget.insert(INSERT, '{:>7}'.format(x[3]))
text_widget.insert(INSERT, '{:>6}'.format(x[4]))
text_widget.insert(INSERT, '{:>5}'.format(x[5]))
text_widget.insert(INSERT, '{:>5}'.format(x[6]))
text_widget.insert(INSERT, '{:>5}'.format(x[7])+'\n\n')
c += 1
for x in income:
detail_income.insert(INSERT, ' '+'{:<10}'.format(x[0])+'{:>10}'.format(x[1])+'{:>12}'.format(x[2])+'{:>5}'.format(x[3])+'\n\n')
for x in expances:
detail_expances.insert(INSERT, ' '+'{:<10}'.format(x[0])+'{:>10}'.format(x[1])+'{:>12}'.format(x[2])+'{:>5}'.format(x[3])+'\n\n')