Nexatech Job Application Portal

Apply with Ease, Manage with Control – Introducing Our Job Application Portal!

Explore the docs »

View Demo . Installation Guide . Report Bug . Request Feature

Table Of Contents

• About the Project
  • Screenshots
  • Built With
• Getting Started
  • Prerequisites
  • Installation
• Usage
• Roadmap
• Contributing
• License
• Authors
• Acknowledgements

About The Project

Nexatech is a cool open source project that features job application form and administration control. The application was created as a project in our Database subject. The goal of this project is to showcase our knowledge in programming (especially in GUI) and database management using MySQL.

(back to top)

Screenshots

Take a look at some screenshots showcasing the intuitive application form and powerful admin control of our Job Application Portal.

Homepage	Personal Information
Desired Employment	Education
Work Experience	Major Skills
Ending Page	Login Page
Dashboard	New Applicant
View Applicants	Update Applicant
About Page	Confirm Logout

(back to top)

Built With

The following tools and techonologies were involved in the making of this project

• Figma
• Python 🐍
• Visual Studio Code
• MySQL Server 🐬
• MySQL Connector Python
• Tkinter Designer

Getting Started

If you're looking to set up a local copy that runs seamlessly, just follow these straightforward example steps.

Prerequisites

• Python
• MySQL Workbench 8.0 CE
• Visual Studio Code

If all the above are satisfied, you may proceed to the next section.

Installation

Follow these instructions to setup your own instance of the app. You can also follow the video tutorial here.

1. Clone the repo

You may follow this instruction: cloning a repository

You may use github desktop for easy cloning.

gh repo clone Rednaxela5/nexatech-job-application-portal

Or if you have git command line installed, clone using this command:

git clone https://github.com/Rednaxela5/nexatech-job-application-portal.git

2. Change the directory

Open terminal/cmd/powershell and change the directory to the cloned folder. You can also open the directory to your preferred IDE.

cd Location\nexatech-job-application-portal

3. Install the necessary dependencies

pip install -r requirements.txt

In the event that pip doesn't work, you can also try the following commands:

pip3 install -r requirements.txt

python -m pip install -r requirements.txt

python3 -m pip install -r requirements.txt

4. Setup the database

Create the database from the MySQL schema:

1. Copy-paste the contents of nexatech.sql directly into the MySQL command line, or simply open and run the MySQL file.
2. Verify the settings of each table in the schema.

5. Modify the config file

You need to modify the codes inside the config.py file before running the app.

1. Open config.py and adjust these lines depending on your setup

USERNAME = "admin"
PASSWORD = "password"

MYSQL_HOST = 'localhost'
MYSQL_USER = 'root'
MYSQL_PASSWORD = 'P@ssw0rd2023!'
MYSQL_DATABASE = 'nexatech'

6. Install the fonts

This application used the "Montserrat" font. Install the fonts inside the font

7. Run the app 🎉

Run the application.bat and you should see the home page window if there are no issues.

(back to top)

Roadmap

• Improve the education page
• Add error handler for each page in application from
• Improve the database
• Redesign the admin control (make it real)
• Add and improve the add new applicant section (Admin Control)
• Add more features in the Admin Control
• Add graph and statistics in the Admin Control using matplotlib

(back to top)

Contribute

Contributions are what make the open source community such an amazing place to be learn, inspire, and create. Any contributions you make are greatly appreciated.

• If you have suggestions for adding or removing projects, feel free to open an issue to discuss it, or directly create a pull request after you edit the README.md file with necessary changes.
• Please make sure you check your spelling and grammar.
• Create individual PR for each suggestion.
• Please also read through the Code Of Conduct before posting your first idea as well.

Creating A Pull Request

1. Fork the Project
2. Create your Feature Branch (git checkout -b feature/AmazingFeature)
3. Clone and checkout that branch locally.
4. Commit your Changes (git commit -m 'Add some AmazingFeature')
5. Push to the Branch (git push origin feature/AmazingFeature)
6. Open a Pull Request

(back to top)

License

Distributed under the MIT License. See LICENSE for more information.

Authors

• Alexander Porlares - @Rednaxela5 - Head/Back End
• Jallane Roncales - Jallane Roncales - Front End
• Jerome Agarin - Jerome Agarin - Front End
• Luen Lozada - @lnlzd - Back End

Acknowledgements

• Parth Jadhav and his contributors for their awesome Tkinter-Designer. This project would look dull if we used the common tkinter. So thank you very much for this helpful project.
• Mohit Yadav for his HotinGo project. Learned a lot from his approach in making README.md as well as the whole project.
• raja2505 for his Name Patcher. Made renaming elements and editing code a lot faster.

(back to top)