well guys am sorry i bother you all but i still could not solve my problem !!!
down below i will post the whole code i have in that file and used for that part of my programm and hope you could find my mistake .
PS: the datas are added to the database as : yyyy-mm-dd
i also write the entry the same way !! so i guess u should have no problem in adding the datas
here is the code i have ::
from tkinter import*
from second_win import*
from datetime import datetime
def cal():
cal_win = Toplevel()
cal_win.title("Calculations Window")
cal_win.geometry("600x600")
cal_win.configure(background="black")
global d_f_entry
global d_u_entry
def weekly_cal():
connect = sqlite3.connect('working_time_app.db')
cursor = connect.cursor()
cursor.execute("SELECT sum(fnishing - starting) FROM working_time_app_table WHERE date BETWEEN ? and ? ",
(d_u_entry, d_f_entry))
sum_result = cursor.fetchall()
show_weekly_cal_label = Label(cal_win, text=sum_result, font=("mv boli", 12), fg="white", bg="black")
show_weekly_cal_label.grid(column=3, row=15, columnspan=5)
connect.commit()
connect.close()
def day_cal():
h_sum = str( float(until_entry.get()) - float(from_entry.get()) )
date_sum = str(date_entry.get())
day_sum = str(day_entry.get())
label_show_sum = Label(cal_win, text=(" you worked " + " "
+ h_sum + "H" + " \n " + "on" + " " + day_sum + " " + date_sum),
bg="black", fg="white", font=("mv boli", 20))
label_show_sum.grid(column=3, row=4, columnspan=5)
def cal1():
global date_entry
global day_entry
global from_entry
global until_entry
day_label = Label(cal_win, text="Day", font=("mv boli", 20), fg="white", bg="black")
date_label = Label(cal_win, text="Date", font=("mv boli", 20), fg="white", bg="black")
from_label = Label(cal_win, text="From", font=("mv boli", 20), fg="white", bg="black")
until_label = Label(cal_win, text="Until", font=("mv boli", 20), fg="white", bg="black")
daily_cal_button = Button(cal_win, text="Show Daily Sum", fg="black", bg="white",
font=("mv boli", 15), command=day_cal, width=15)
day_entry = Entry(cal_win, width=30)
date_entry = Entry(cal_win, width=30)
from_entry = Entry(cal_win, width=30)
until_entry = Entry(cal_win, width=30)
date_label.grid(column=1, row=2, pady=5)
day_label.grid(column=3, row=2, pady=5)
from_label.grid(column=1, row=3, pady=5)
until_label.grid(column=3, row=3, pady=5)
daily_cal_button.grid(column=1, row=5, pady=5, columnspan=2)
day_entry.grid(column=4, row=2, pady=5)
date_entry.grid(column=2, row=2, pady=5)
from_entry.grid(column=2, row=3, pady=5)
until_entry.grid(column=4, row=3, pady=5)
connect = sqlite3.connect('working_time_app.db')
cursor = connect.cursor()
record_id = id_entry.get()
cursor.execute("SELECT* from working_time_app_table WHERE oid=" + record_id)
records = cursor.fetchall()
connect.commit()
connect.close()
for record in records:
day_entry.insert(0, record[0])
date_entry.insert(0, record[1])
from_entry.insert(0, record[2])
until_entry.insert(0, record[3])
daily_button.destroy()
monthly_sum_button.grid_forget()
weekly_sum_button.grid_forget()
date_from_entry.grid_forget()
date_until_entry.grid_forget()
until_date_label.grid_forget()
from_date_label.grid_forget()
id_label = Label(cal_win, text="ID", font=("mv boli", 15), fg="white", bg="black")
id_entry = Entry(cal_win, width=30)
id_entry.grid(column=3, row=1, pady=5)
id_label.grid(column=2, row=1, pady=5)
daily_button = Button(cal_win, text="Daily Sum", font=("mv boli", 15),
fg="black", bg="white", width=10, command=cal1)
daily_button.grid(column=3, row=2, columnspan=2)
monthly_sum_button = Button(cal_win, text="Monthly Sum", fg="black", bg="white",
font=("mv boli", 15), width=15)
weekly_sum_button = Button(cal_win, text="Weekly Sum",
fg="black", bg="white",
font=("mv boli", 15), width=15, command=weekly_cal)
monthly_sum_button.grid(column=3, row=7, pady=5, columnspan=2)
weekly_sum_button.grid(column=3, row=8, pady=5, columnspan=2)
from_date_label = Label(cal_win, text="From", font=("mv boli", 15), fg="white", bg="black")
from_date_label.grid(column=2, row=5, pady=5)
date_from_entry = Entry(cal_win, width=30)
date_from_entry.grid(column=3, row=5, pady=5)
until_date_label = Label(cal_win, text="Until", font=("mv boli", 15), fg="white", bg="black")
until_date_label.grid(column=4, row=5, pady=5)
date_until_entry = Entry(cal_win, width=30)
date_until_entry.grid(column=5, row=5, pady=5)
d_u_entry = date_until_entry.get()
d_f_entry = date_from_entry.get()
cal_win.mainloop()