def __init__(self, user_log_in, user_id, hire_date, is_employer, root): super().__init__() self.root: Tk = root self.var = IntVar() self.__default_time: str = "Odchozeno hodin: " self.__default_wage: str = "Celková hrubá mzda: " self.__default_days: str = "Počet dnů: " self.__cb_year = Combobox(self, state="readonly") self.__lb_data = Listbox(self, font=('Courier New', 12)) self.__output = LabelFrame(self, text="Výpis") self.__lb_time = Label(self.__output, text=self.__default_time + "0:0") self.__lb_wage = Label(self.__output, text=self.__default_wage + "0,00 Kč") self.__lb_days = Label(self.__output, text=self.__default_days + "0") self.__conn = db.create_connection() self.user_id = user_id self.isEmployer = is_employer self.hire_date: str = hire_date self.user_log_in: str = user_log_in self.__init_ui() self.__btn_update_event()
def __init__(self, root): super().__init__() self.root = root root.title("Hire") root.geometry("450x270+450+170") root.minsize(450, 270) root.maxsize(450, 270) self.var = BooleanVar() self.conn = db.create_connection() self.__init_ui()
def login_user(self): """Login user """ name = self.username_box.get() password = self.password_box.get() # login_completed = self.login_completed.get() # AUTO DATA PRO TESTOVÁNÍ # name = "dom53" # password = "******" conn = db.create_connection() # us = db.select_user_by_id(conn, 1) # row = db.select_user_by_id(conn, 1)[0] # row = db.select_user_by_credentials(conn, name, password)[0] row: tuple try: row = db.select_user_by_credentials2(conn, name)[0] print("row") print(type(row)) except IndexError: messagebox.showwarning("Login Failed - Access Denied", "Username or Password incorrect!") raise ValueError("Wrong credentials! - Access denied") # print("name: " + name) # print("password: "******"row[1]: " + row[1]) # print("row[2]: " + row[2]) # global qq # global userId # global hire # global isEmployer self.user = row[3] + " " + row[4] self.user_id = row[0] self.hire = row[5] self.isEmployer = row[7] # print("tady typy") # print(type(self.user)) # print(type(self.user_id)) # print(type(self.hire)) # print(type(self.isEmployer)) # print("isEmployer") # print(self.isEmployer) # print(password) # print(row[2]) if name == row[1] and helper.Validation.verify_password( row[2], password): messagebox.showinfo("Login page", "Login successful!") self.__login.destroy() # Removes the toplevel window else: messagebox.showwarning("Login Failed - Access Denied", "Username or Password incorrect!")
def __init__(self, root, user_id): super().__init__() self.root = root root.title("Hire") root.geometry("350x200+250+170") root.minsize(350, 200) root.maxsize(350, 200) self.user_id = user_id self.var = BooleanVar() self.conn = db.create_connection() print("toto -> " + str(self.user_id)) self.__init_ui()
def login_user(self): name = self.username_box.get() password = self.password_box.get() login_completed = self.login_completed.get() # AUTO DATA PRO TESTOVÁNÍ name = "dom53" password = "******" conn = db.create_connection() # us = db.select_user_by_id(conn, 1) # row = db.select_user_by_id(conn, 1)[0] row = db.select_user_by_credentials(conn, name, password)[0] print("name: " + name) print("password: "******"row[1]: " + row[1]) print("row[2]: " + row[2]) global qq global userId global hire global isEmployer qq = row[3] + " " + row[4] userId = row[0] hire = row[5] isEmployer = row[7] print("isEmployer") print(isEmployer) # Potom zapnout if name == row[1] and password == row[2]: #Main_Win.setUzv(uu) # Potom zapnout # messagebox.showinfo("Login page", "Login successful!") self.login.destroy() # Removes the toplevel window # self.main_win.deiconify() #Unhides the root window self.login_completed == 1 # Potom zapnout else: messagebox.showwarning("Login Failed - Acess Denied", "Username or Password incorrect!")
def main(): print(__presence_json_file) conn = db.create_connection() __insert_presence(conn, __read_json(__presence_json_file)) db.get_presence_group_by_year_by_id(conn, 1)