In this project, I have designed an application using Pyqt5 and SQLite to manage all employees of a hypothetical company. Each employee has an Employee Id (which acts as Primary Key for our table), Name, Lastname, Age, Position, and Email address. This Company will hire people who are older than 18 and younger than 70 years old. I have defined a function to generate 40 employees with fake information.
python mainGUI.py
+ User and password is admin
- SQLite
- Plotly
- Pyqt5
- Mailjet_rest
check the requirments.txt
- Login page
- Display table
- Search function
- Update data (double click or right click on each cell )
- Delete data
- different themes and fonts
- Interesting data (such as number of employees, salary per position, average salary per position)
- Interactive plots
- sending email to specific employee ( update use_jet_mail.py file with your jetmail api and email )