Esempio n. 1
0
    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()
Esempio n. 3
0
    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!")
Esempio n. 4
0
 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()
Esempio n. 5
0
    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!")
Esempio n. 6
0
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)