harshraj22 / automated_payroll Goto Github PK

View Code? Open in Web Editor NEW

3.0 2.0 4.0 6.02 MB

This repository contains the Course Project of Software System Lab

License: MIT License

PHP 89.03% CSS 3.13% JavaScript 3.44% HTML 4.40%

php mysql-database javascript html5 bootstrap4 html-api

automated_payroll's People

Contributors

Stargazers

Watchers

Forkers

abhiisshheekk pavanbodas jaraxxxx bughunter18

automated_payroll's Issues

Create employee count

Take employee count idea from our actual website
Add the same to salary calculated.

Make input tags Required

Add required attribute to all the input tagas.

Update filter.php

Make form center align
Add labels to form

Display captured image

Display captured image while logging in/out

Create admin section

Create admin section, where admin has option

to add user
display all user

Add feature of salary calculation at runtime

Add feature to click salary of employee

Add BootStrap

Add bootstrap to fix the look of website.

Add HR part

Add Option For HR to check and calculate salary.
While also add option to create HR. Update auth table.

add nav bar

Add nav bar in createUser.php and createHr.php

Admin can change

Admin can change password of employee .
Add feature in dispalyUserStats.php

HR can not see, please see. 🤣 😆

Add link

Add link to the Home button into nav bar. ⭕

Dependent on homepage

unable to run automate.php

Warning: require_once(../authenticate/login.php): Failed to open stream: No such file or directory in C:\xampp\htdocs\Automated_Payroll\Payroll\automate\automate.php on line 3

Fatal error: Uncaught Error: Failed opening required '../authenticate/login.php' (include_path='C:\xampp\php\PEAR') in C:\xampp\htdocs\Automated_Payroll\Payroll\automate\automate.php:3 Stack trace: #0 {main} thrown in C:\xampp\htdocs\Automated_Payroll\Payroll\automate\automate.php on line 3

Can you please help?

Decorate short lived pages

Beautify short lived pages that redirect withing seconds e.g. logged in/ logged out etc.
Put them in class='container text-center' and do some more decoration

Automate Table Making

Automate Table making for Database.

on displaystats.php page

Change the name of the calc Salary to Calculate Salary

Create Login Front-End

Create a basic Html structure for login page.

unable To Run Automate.php File

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES) in C:\xampp\htdocs\my-site\Automated_Payroll-develop\Payroll\automate\automate.php on line 4
Error while connecting to database.Access denied for user 'root'@'localhost' (using password: YES)

AUTOMATE.PHP

"; } // create the database. $db_create_query = "CREATE DATABASE {$database}"; $db_create_result = mysqli_query($conn, $db_create_query); if(!$db_create_result) die("Error creating database. ".mysqli_error($conn)); else echo "Successfully created Database.
"; mysqli_close($conn); // ------------------------Database Created, Now creating admin table ----------------------------- $conn = mysqli_connect($hostname, $username, $password, $database); if(!$conn) die("Error connecting database.
".mysqli_connect_error()); else echo "Connected to databse, creating tables.
"; // create auth table which stores username and password for each user, along with info it he/she is admin $table_query = "CREATE TABLE auth (username VARCHAR(20) NOT NULL PRIMARY KEY, pass VARCHAR(20) NOT NULL, isAdmin VARCHAR(3) NOT NULL DEFAULT 'No', isHr VARCHAR(3) NOT NULL DEFAULT 'No')"; $table_result = mysqli_query($conn, $table_query); if(!$table_result) die("Error creating authentication table.
".mysqli_error($conn)); else echo "Successfully created auth table.
"; // create an admin auth credentials. $create_admin_query = "INSERT INTO auth VALUES('{$admin_name}', '{$admin_pass}', 'yes', 'No')"; $create_admin_result = mysqli_query($conn, $create_admin_query); if(!$create_admin_result) die("Error creating admin.
".mysqli_error($conn)); else echo "Successfully Created admin.
"; //--------------------------------HR Table Creation---------------------------------------------------- $create_hr_table = "CREATE TABLE hr_table (username VARCHAR(30) NOT NULL PRIMARY KEY, rate INT (3) DEFAULT 10)"; $create_hr_table_result = mysqli_query($conn, $create_hr_table); if(!$create_hr_table_result) die("Error creating hr table.
"); else echo "Successfully Created HR table.
"; function removeDirectory($path) { $files = glob($path . '/*'); foreach ($files as $file) { is_dir($file) ? removeDirectory($file) : unlink($file); } rmdir($path); return; } removeDirectory('../user_images'); mysqli_close($conn); ?>

Display user details of month when page corresponding to him/her is tried to access by the admin/HR.

displayUserStats.php
Add clickable list that opens up in map to show the location (lat-long)

Button to show image of user.

Dependent on homepage

Add Image Capture

Add feature to capture image when user logs in/logs out.
Save the pic in his/her directory.