EGA System Tool: A graphical information system for working with the database of a consulting company
The repository contains a graphical user interface (GUI) information system designed specifically for efficient database management in a consulting company. The system provides parsing, data generation functions and provides a GUI for easy interaction with the database.
EGA System Tool is a graphical application (GUI) designed for use in a consulting agency. Access to the main database window requires authentication with a user login and password.
The main functionality of the interface allows you to create SQL scripts for database queries and provides a convenient table form for viewing query results. It is also possible to export these results in .csv format.
A schema displayed in the interface is provided for easy navigation of the database. In addition, the user can download a scan of the contract by specifying its number.
The window interface is divided into blocks using separators, allowing the user to resize or close them at will.
The parsing folder contains files responsible for parsing information about people's first and last names. This parsed data is used in the data generation process.
The generator folder contains the gen_funcs2.py file that generates information about companies, clients, service types, agency services, managers, contracts, etc. It also contains functions for creating contract scans and creating a working SQL database.
The GUI_app folder contains scripts for creating a GUI application and the specifications needed to implement it.
The dist/ega_system directory contains a sample working application packaged for distribution.
This project is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
For questions and discussions, please contact author via the contacts listed in his profile.