def focus(win: Window) -> None: win.Finalize() win.TKroot.attributes(r"-topmost", True) win.bring_to_front() win.TKroot.focus_set() win.TKroot.focus_force() win.disable_debugger() win.grab_any_where_on() win.force_focus() win.refresh()
def update_bar_message(message: str, counter: int, window: sg.Window): """ Updates progress bar and output message, returns counter +1 """ msg = window["-MESSAGE-"] bar = window["-BAR-"] counter += 1 bar.update_bar(counter) msg.update(message) window.refresh() return counter
class Xpnsit: def __init__(self): self.app_state: bool = True # <------------------- Misc. Functions (Layouts and Updaters and stuff) --------------------> # def Add_Trans(self, particulars: str, _type: str, amount: float, date: str): cursor = conn.cursor() try: cursor.execute(f""" INSERT INTO transactions ( user_id, username, particulars, exp_type, amount, exp_date ) VALUES ( {self.user.user_id}, '{self.user.uname}', '{particulars}', '{_type}', {amount}, "{date}" ); """) conn.commit() Popup("Transaction successfully added.") self.win.Refresh() except SQLErrors.ProgrammingError: PopupError("ERROR: Invalid details.\nRectify and try again.") cursor.close() def Create_Add_Trans_Layout(self): layout = [ [T("New Transaction", font=("Helvetica", 18))], [T("NOTE:", font=("Helvetica", 20)), T( "All fields are required to be filled.")], [T("Particulars:"), Multiline("Enter details of transaction", autoscroll=True, key="Particulars")], [T("Transaction type:"), Combo(["Select", "Credit", "Debit"], "Select", readonly=True, key="new_type")], [T("Amount:"), Input(enable_events=True, key="amount")], [T("Date Of Transaction:"), Input("YYYY-MM-DD or use the button on the right", key="date"), CalendarButton("Select Date", target="date", format="%Y-%m-%d")], [Submit()] ] return layout def History(self): history_values, table, no_of_records = get_transactions( self.user.uname) self.slider = sg.Slider( range=(0, no_of_records), default_value=no_of_records, orientation='h', enable_events=True, key='slider' ) layout = [ [T("Transaction History", font=("Helvetica", 18))], [T("All your transactions, in one place. Right click any one to delete or edit it.")], [T('Number of records to be shown:'), self.slider], [T("Show records from "), Input(f"{year}-{month}-1", key="start_date", size=(10, 1)), CalendarButton("Start date", target="start_date", default_date_m_d_y=( month, 1, year), button_color=("white", "green"), format="%Y-%m-%d"), T("to"), Input(f"{year}-{month}-{day}", key="end_date", size=(10, 1)), CalendarButton("End date", target="end_date", default_date_m_d_y=( month, day, year), button_color=("white", "red"), format="%Y-%m-%d") ], [T("Type:"), Combo(["All", "Credit", "Debit"], default_value="All", key="used_type", readonly=True)], [T("Sort by:"), Combo(["Name", "Amount", "Date of Transaction"], default_value="Name", key="sort_by", readonly=True), Combo(["Ascending", "Descending"], default_value="Ascending", key="asc_or_desc", readonly=True)], [table, Button("Refresh", button_color=( "white", "orange"), bind_return_key=True, key="refresh")], ] self.history_active = True return layout def update_table(self): start, end = self.values['start_date'], self.values["end_date"] aod = 'ASC' if self.values["asc_or_desc"] == "Ascending" else "DESC" sort = "particulars" if self.values["sort_by"] == "Name" else "amount" if self.values["sort_by"] == "Amount" else "exp_date" n = self.values["slider"] if self.event == 'slider' else 10000 new_trans, new_table, new_number_of_trans = get_transactions( self.user.user_id, int(n), start, end, aod, # a(scending)o(r)d(escending) sort ) print(new_trans, new_table, new_number_of_trans) self.win["table"].Update(new_trans) # Updates table # Updates max number of records to be possibly displayed self.win["slider"].Update(range=(0, new_number_of_trans+1)) # Updates the default value of the slider to be the max self.slider.Update(value=new_number_of_trans) self.win.Refresh() def create_graph(self): fig, w, h = get_graph_values( self.values['a_start_date'], self.values['a_end_date'], self.values["a_type"], ) self.figure_agg = draw_figure( self.win['canvas'].TKCanvas, fig) # <------------------ Main Screens --------------------> # def Login(self): login_active = True layout = [ [T("Xpnsit", **heading_format)], [T("Username:"******"user")], [T("Password:"******"pass", password_char='*')], [Button("Login", bind_return_key=True), Button("Signup")] ] win = Window("Xpnsit", layout=layout) while login_active: # <------------ Event Loop -----------------> # event, values = win.Read() if event is None: print("Exiting event loop") login_active = False self.app_state = False win.close() del win break if event == "Login": success = check_login_info(values["user"], values["pass"]) if success == True: print("Login Successful.") self.user_details = get_user_details(values["user"]) self.user = NewUser(*self.user_details) win.close() self.Interface() login_active = False else: PopupError( "ERROR: Username or password incorrect.\nPlease try again.") if event == "Signup": self.Signup() def Signup(self): signup_active = True layout = [ [T("Signup for Xpnsit", **heading_format), ], [T("First Name:"), Input(size=(15, 1), key="f_name"), T( " "), T("Last Name:"), Input(size=(15, 1), key="l_name")], [T("Username:"******"user")], [T("Password:"******"pass", password_char="*")], [], [T(' '*40), Submit()] ] signup_win = Window("Xpnsit - Signup", layout=layout) while signup_active: # <------------ Event Loop -----------------> # event, values = signup_win.Read() if event in (None, 'Exit'): signup_active = False login_active = True if event == 'Submit': self.vals = [values["user"], values["pass"], values["mail"], values["f_name"], values["l_name"]] if not username_used(self.vals[0]): create_account(*self.vals) # <------------------- Confirmation of Insertion ------------------> # success = check_login_info(values["user"], values["pass"]) if success == True: print("Signup Successful.") Popup( "Signup Successful!", "Exit this popup to return to the login page" ) signup_win.close() signup_active = False login_active = True else: PopupError("ERROR: Username already in usage", title="Username already taken") def Dashboard(self): income, expenses = get_income_and_expense(self.user.uname) if (income, expenses) == (None, None): dash_layout = [ [T(f"Welcome {self.user.first_name}")], [T("Looks like you have no transactions!\nGo add one in the Transactions tab.", justification="center")], [T("-"*60, text_color="gray")], ] else: dash_layout = [ [T(f"Welcome {self.user.first_name}")], [T(f"Your expenses for {month_name}-{year} are:"), T(str(expenses), font=("Arial", 20))], [T(f"Your income for {month_name}-{year} is:"), T(str(income), font=("Arial", 20))], [T("-"*80, text_color="gray")], [T("Net Profit/Loss:", font=("Segoe", 18)), T(str(income-expenses), font=("Arial", 24))] ] dash_active = True return dash_layout def Transactions(self): transaction_layout = [ [T("Transactions", font=("Helvetica", 18))], [TabGroup( [ [Tab("New Transaction", self.Create_Add_Trans_Layout())], [Tab("History", self.History())] ] )] ] return transaction_layout def Analytics(self): fig, w, h = get_graph_values() analysis_layout = [ [T("Analytics", font=("Helvetica", 18))], [T("Here you can find and generate graphs for your desired timeframe\nand observe trends in your balance.")], [T("Generate for records from "), Input(f"{year}-{month}-1", key="a_start_date", size=(10, 1)), CalendarButton("Start date", target="a_start_date", default_date_m_d_y=( month, 1, year), button_color=("white", "green"), format="%Y-%m-%d"), T("to"), Input(f"{year}-{month}-{day}", key="a_end_date", size=(10, 1)), CalendarButton("End date", target="a_end_date", default_date_m_d_y=( month, day, year), button_color=("white", "red"), format="%Y-%m-%d") ], [T("Type:"), Combo(["All", "Credit", "Debit"], default_value="All", key="a_type", readonly=True)], [Button("Generate", button_color=("white", "orange"))], [Canvas(size=(w, h), key="canvas")] ] return analysis_layout def Interface(self): global graph_active layout = [ [T("Xpnsit", **heading_format), T(" "*50), Button("Settings"), Button("Log Out", button_color=("black", "yellow"))], [TabGroup([ [ Tab("Dashboard", self.Dashboard( ), tooltip="See an overview of your account", font=("Arial", 12)), Tab("Transactions", self.Transactions( ), tooltip="View,add and delete transactions", font=("Arial", 12), key="transactions"), Tab("Analytics", self.Analytics( ), tooltip="Get a graphical insight to your spendings.", font=("Arial", 12)) ] ],)] ] self.win = Window("Xpnsit v1.0", layout=layout, size = (590,640),resizable=True) while True: self.event, self.values = self.win.Read() self.figure_agg = self.create_graph() if self.event == "Log Out": logout = PopupYesNo("Are you sure you want to log out?") if logout == 'Yes': sg.popup_quick_message( "Okay, closing. Bye", auto_close_duration=10) self.win.close() # self.app_state = False del self.win break elif self.event is None: self.win.close() self.app_state = False del self.win break if self.event != sg.TIMEOUT_KEY: print(f"Event = {self.event}\nValues = {self.values}\n") if self.event == "Submit": _type = "CR" if self.values["new_type"] in ( "Credit", "Select") else "DR" self.Add_Trans( self.values["Particulars"], _type, self.values["amount"], self.values["date"]) if self.event in ("slider", "refresh"): self.update_table() self.win.refresh() if self.event == "Generate": # self.create_graph() delete_figure_agg(self.figure_agg) self.create_graph() self.win.read() self.win.refresh()