Login

#!/bin/bash # Define the base directory where the system will be set up BASE_DIR="/public_html/tasks" # Step 1: Create the required directories mkdir -p $BASE_DIR/{auth,tasks,admin,user,config} # Step 2: Create the database setup script cat < $BASE_DIR/config/db_setup.sql -- Create the necessary tables for the task management system CREATE TABLE IF NOT EXISTS users ( user_id INT AUTO_INCREMENT PRIMARY KEY, username VARCHAR(255) NOT NULL, password_hash VARCHAR(255) NOT NULL, email VARCHAR(255), role ENUM('User', 'Admin') DEFAULT 'User' ); CREATE TABLE IF NOT EXISTS tasks ( task_id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(255) NOT NULL, description TEXT, status ENUM('Assigned', 'In Progress', 'Completed', 'Failed') DEFAULT 'Assigned', due_date DATE, assigned_user_id INT, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); CREATE TABLE IF NOT EXISTS employee_involvement ( task_id INT, user_id INT, involvement_type ENUM('Creator', 'Executor') DEFAULT 'Executor', PRIMARY KEY (task_id, user_id), FOREIGN KEY (task_id) REFERENCES tasks(task_id), FOREIGN KEY (user_id) REFERENCES users(user_id) ); -- Insert a test admin user INSERT INTO users (username, password_hash, role) VALUES ('admin', PASSWORD('AdminPass'), 'Admin'); EOL # Step 3: Create PHP configuration file for database connection cat < $BASE_DIR/config/db_connect.php setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException \$e) { echo "Connection failed: " . \$e->getMessage(); } ?> EOL # Step 4: Create authentication-related files # login.php cat < $BASE_DIR/auth/login.php prepare("SELECT * FROM users WHERE username = :username"); \$stmt->execute(['username' => \$username]); \$user = \$stmt->fetch(PDO::FETCH_ASSOC); if (\$user && password_verify(\$password, \$user['password_hash'])) { \$_SESSION['user_id'] = \$user['user_id']; header('Location: ../tasks/dashboard.php'); exit(); } else { \$error = 'Invalid username or password!'; } } ?> Login

Login

EOL # logout.php cat < $BASE_DIR/auth/logout.php EOL # Step 5: Create task-related files # dashboard.php cat < $BASE_DIR/tasks/dashboard.php Dashboard EOL # Step 6: Create additional PHP files for tasks (create_task.php, edit_task.php, etc.) # Add each file similarly to the examples above # Step 7: Set appropriate permissions chown -R www-data:www-data $BASE_DIR chmod -R 755 $BASE_DIR echo "Task Management System setup complete!"