Group Members

• Twumasi Pennoh
• Ricardo Zacarias
• Jeffrey Awuku-Boateng
• Christian Summerlin

Description

• An employee portal was created for the fictional tech company named Artec. The employees that work in this company will have the ability to login, update their timesheets, lookup employee emails, as well as a couple of other simple tasks. The website will also allow an admin to login with other capabilities such as adding/removing employees to the employee database and responding to client requests.

Contribution summary

• Twumasi Pennoh: Twumasi created and set up the database in AWS so that all of the members of the group could access the same data in the database. He also created the Login page, Forgot Password page, and Personal Info page. He connected those pages and the Registration page to the database so that information would be passed between those pages and the database when a user performs an action. Overall, he contributed his part to the project.

• Ricardo Zacarias: Ricardo created the Home Page, Timesheet Page, Pay Info Page, Admin Requests Page, and half of the Employee Requests Page. He also created the layout for the Nav Bar that was used at the top of every page. With all the pages he created, he made sure that they all worked entirely through the use of the database and any necessary javascript to perform the actions needed on the website. Apart from that, he worked on the general styling of all the pages to make sure the CSS properties made them look the same. Overall, he made a fair contribution to the project.

• Jeffrey Awuku-Boateng: Created the admin features which included the add and delete employee pages, registration check page, some parts of the registration page and request page. After creating all these pages, Jeffrey added their respected javascript validations and css design and if anything needed to connect to the database, he made sure that they did and worked properly. He also helped to create the timesheet table. He also checked that all links worked and went to the right pages.

• Christian Summerlin: Created the preliminary registration page and also did JavaScript validation for the registration page. Also made the registration confirmation and connected it to the registration page so that it goes there whenever the user has successfully registered. Christian also created the employee directory page and css for that, making it so that the employee can see all the employees in the company and also can filter by first name, last name, or job title. She contributed her part to the project.

How To Run The Program

• You will need XAMPP to start Apache and MySQL.
• You will need to create a database named “HR_Tables” and use the HR_Tables.sql file provided to fill up the database with the necessary tables and data.
• You will also need to modify the db_connection/database.php file with the host, port, socket, user, password, dbname information so that you can access the database you created.
• Once you have started Apache and MySQL and have placed the web-programming-project folder in the htdocs folder inside of the xampp folder, you will need to use the link below to run it: http://localhost/web-programming-project/pages/welcome_page.html

Resources Used

• https://www.html.am/html-codes/tables/table-border.cfm
• https://www.w3resource.com/javascript/form/password-validation.php
• https://www.w3resource.com/javascript/form/email-validation.php
• String to time: https://www.php.net/manual/en/function.strtotime.php
• https://stackoverflow.com/questions/1361340/how-to-insert-if-not-exists-in-mysql
• Import CSS in php: https://stackoverflow.com/questions/6315772/how-to-import-include-a-css-file-using-php-code-and-not-html-code/6315792#:~:text=To%20use%20%22include%22%20to%20include,php%20(or%20styles
• Number Formatting: https://stackoverflow.com/questions/4483540/show-a-number-to-two-decimal-places#:~:text=Use%20the%20PHP%20number_format()%20function.,-https%3A%2F%2Fstackoverflow&text=%24retailPrice%20%3D%205.989%3B%20echo%20number_format,5.98%20without%20rounding%20the%20number
• PHP split string: https://www.daniweb.com/programming/web-development/threads/174472/split-a-string-into-two-parts
• Passing multiple variables PHP: https://stackoverflow.com/questions/13102489/passing-multiple-variables-to-another-page-in-url
• CSS Exclusion: https://css-tricks.com/almanac/selectors/n/not/