ABN Job Portal

ABN Job Portal is a Job Portal Web Application for fulfillment of requirements in subjects 'Web Development' and 'Database Administration'

Project Details

Authors and Designers:

• Buenaventura, Vanessah (Web Designer, Research)
• Honorio, Lance (Research)
• Robillos, Elric (Logo Designer, Research)
• Torres, Jetsun Prince (Developer, Project Leader)

BSIT 3-1, PUPQC

Date Started: October 31, 2020

Dependencies

• bootstrap v4.5.3
• jQuery v3.5.1
• jQuery-parallax.js v1.5.0
• bootstrap-select v1.13.18
• croppie v2.6.5

Web Framework

• Codeigniter 3

Requirements

Please install the following to get started

• NodeJS
• Microsoft SQL Server Management Studio 18 (SSMS 18)
• XAMPP
• PHP Driver for SQL Server

To guide you in installing PHP Driver, you may watch this video on YouTube by clicking this link.

How to run?

1. Download the zip file of this code or click here.

2. Extract the file to C:/xampp/htdocs/ and make sure that the folder name would be renamed as ABN-Job-Portal.

3. Open a terminal and enter the following:

   1. cd C:/xampp/htdocs/ABN-Job-Portal
   2. npm install

   Make sure you have NodeJS installed on your computer before to do this. This project is dependent to some node packages. To check, enter to the terminal node -v or node --version. If node version is not display, then you need to install NodeJS.

   Old version of npm is used here. So you can run npm audit fix to fix some high severity vulnerabilities

4. Open the Microsoft SQL Server Management Studio and copy the server name

5. Open any editor you want. Locate this file in extracted folder

   ABN-Job-Portal/application/config/database.php

6. In database.php, locate the $db['default'] array and edit the 'dsn' value to this format:

   'dsn' => 'sqlsrv:Server=[YOUR SERVER NAME];Database=ABN_Job_Portal;'

7. In your Microsoft SQL Server Management Studio, open the file in ABN-Job-Portal/queries/ABN_Job-Portal - Schema.sql and execute.

   Optional: Execute also the file in ABN-Job-Portal/queries/ABN_Job-Portal - Sample Data.sql so database have sample data. You can log in as Jobseeker or Employer by logging in this accounts:

   For Jobseeker	For Employer
   [email protected] [email protected]	[email protected] [email protected] [email protected] [email protected]

   All accounts have P@ssw0rd password

8. Open your XAMPP and start the Apache

9. Open any browser and type localhost/ABN-Job-Portal and you are now ready to use it.

Screenshots

Note: Some images are not owned by us.

Home Page - Hero	Home Page - Create Account
Home Page - Create Account	Home Page - Recent Available Jobs
Home Page - Hero and Footer	Login Page
Register Page - Job Seeker (With Form Validation)	Register Page - Employer
Jobseeker Page - Profile (including dropdown options)	Jobseeker Page - Edit Profile Picture
Jobseeker Page - Applications	Jobseeker Page - Bookmarks
Jobseeker Page - Notifications	Job Details
Job Application	Search Page
Company Page - Details	Employer Page - Profile
Employer Page - Post New Job	Employer Page - Job Post
Employer Page - Applicants	Employer Page - Edit Information