Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/rutzotech.com/public_html/ems/employee/sales

Free Space:

10.18 TB

🔧 Quick Actions

✏️ Editing: manager_approval.php

<?php
session_start();
include('db.php'); // Ensure this file contains your database connection

// Check if user is logged in and is a manager
if (!isset($_SESSION['user_id']) || $_SESSION['role'] !== 'manager') {
    header('Location: login.php');
    exit();
}

$user_id = $_SESSION['user_id'];

// Fetch pending project approvals for this manager
$query = "SELECT pa.id, pa.project_name, pa.budget, pa.description, pa.created_at, u.name as client_name, u.email as client_email, u.phone as client_phone
          FROM project_approvals pa
          JOIN users u ON pa.client_id = u.id
          WHERE pa.manager_id = '$user_id' AND pa.status = 'pending'";
$result = mysqli_query($conn, $query);
$approvals = mysqli_fetch_all($result, MYSQLI_ASSOC);

// Handle approval/rejection
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $approval_id = mysqli_real_escape_string($conn, $_POST['approval_id']);
    $action = $_POST['action'];
    $project_name = mysqli_real_escape_string($conn, $_POST['project_name']);
    $client_id = mysqli_real_escape_string($conn, $_POST['client_id']);
    $budget = mysqli_real_escape_string($conn, $_POST['budget']);
    $description = mysqli_real_escape_string($conn, $_POST['description']);
    $start_date = date('Y-m-d');

if ($action === 'approve') {
        // Insert into projects table
        $project_query = "INSERT INTO projects (name, client_id, manager_id, start_date, status, budget, description, created_at, updated_at)
                          VALUES ('$project_name', '$client_id', '$user_id', '$start_date', 'active', '$budget', '$description', NOW(), NOW())";
        if (mysqli_query($conn, $project_query)) {
            // Update approval status
            $update_query = "UPDATE project_approvals SET status = 'approved', updated_at = NOW() WHERE id = '$approval_id'";
            mysqli_query($conn, $update_query);
            $success_message = "Project approved and created successfully!";
        } else {
            $error = "Failed to create project: " . mysqli_error($conn);
        }
    } elseif ($action === 'reject') {
        // Update approval status
        $update_query = "UPDATE project_approvals SET status = 'rejected', updated_at = NOW() WHERE id = '$approval_id'";
        mysqli_query($conn, $update_query);
        $success_message = "Project request rejected.";
    }
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <title>Manager Approvals | Decconz Manager Dashboard</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta content="Manager dashboard for approving project requests" name="description">
    <meta content="Coderthemes" name="author">

<link rel="shortcut icon" href="images/favicon.ico">

<script src="js/hyper-config.js"></script>

<link href="css/vendor.min.css" rel="stylesheet" type="text/css">

<link href="css/app.min.css" rel="stylesheet" type="text/css" id="app-style">

<link href="css/unicons.css" rel="stylesheet" type="text/css">
    <link href="css/remixicon.css" rel="stylesheet" type="text/css">
    <link href="css/materialdesignicons.min.css" rel="stylesheet" type="text/css">
</head>
<body>
    
    <div class="wrapper">
        
        <?php include('includes/nav.php') ?>

<?php include('includes/sidebar.php') ?>

<div class="content-page">
            <div class="content">
                
                <div class="container-fluid">
                    <div class="row">
                        <div class="col-12">
                            <div class="page-title-box">
                                <div class="page-title-right">
                                    <ol class="breadcrumb m-0">
                                        <li class="breadcrumb-item"><a href="javascript: void(0);">Decconz</a></li>
                                        <li class="breadcrumb-item active">Project Approvals</li>
                                    </ol>
                                </div>
                                <h4 class="page-title">Project Approvals</h4>
                            </div>
                        </div>
                    </div>

<?php if (isset($success_message)) { ?>
                        <div class="alert alert-success" role="alert">
                            <?php echo $success_message; ?>
                        </div>
                    <?php } ?>
                    <?php if (isset($error)) { ?>
                        <div class="alert alert-danger" role="alert">
                            <?php echo $error; ?>
                        </div>
                    <?php } ?>

<div class="row">
                        <div class="col-12">
                            <div class="card">
                                <div class="card-body">
                                    <h4 class="header-title">Pending Project Approvals</h4>
                                    <p class="text-muted font-14 mb-4">
                                        Below are the project requests pending your approval. Approve or reject each request.
                                    </p>
                                    <div class="table-responsive">
                                        <table class="table table-centered table-nowrap mb-0">
                                            <thead class="table-light">
                                                <tr>
                                                    <th>Project Name</th>
                                                    <th>Client Name</th>
                                                    <th>Email</th>
                                                    <th>Phone</th>
                                                    <th>Budget</th>
                                                    <th>Client Requirements</th>
                                                    <th>Submitted At</th>
                                                    <th>Action</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php if (empty($approvals)) { ?>
                                                    <tr>
                                                        <td colspan="8" class="text-center">No pending approvals found.</td>
                                                    </tr>
                                                <?php } else { ?>
                                                    <?php foreach ($approvals as $approval) { ?>
                                                        <tr>
                                                            <form method="POST" action="">
                                                                <input type="hidden" name="approval_id" value="<?php echo $approval['id']; ?>">
                                                                <input type="hidden" name="project_name" value="<?php echo htmlspecialchars($approval['project_name']); ?>">
                                                                <input type="hidden" name="client_id" value="<?php echo $approval['client_id']; ?>">
                                                                <input type="hidden" name="budget" value="<?php echo $approval['budget']; ?>">
                                                                <input type="hidden" name="description" value="<?php echo htmlspecialchars($approval['description']); ?>">
                                                                <td><?php echo htmlspecialchars($approval['project_name']); ?></td>
                                                                <td><?php echo htmlspecialchars($approval['client_name']); ?></td>
                                                                <td><?php echo htmlspecialchars($approval['client_email']); ?></td>
                                                                <td><?php echo htmlspecialchars($approval['client_phone'] ?? ''); ?></td>
                                                                <td><?php echo number_format($approval['budget'], 2); ?></td>
                                                                <td><?php echo htmlspecialchars($approval['description']); ?></td>
                                                                <td><?php echo $approval['created_at']; ?></td>
                                                                <td>
                                                                    <button type="submit" name="action" value="approve" class="btn btn-success btn-sm">
                                                                        <i class="mdi mdi-check"></i> Approve
                                                                    </button>
                                                                    <button type="submit" name="action" value="reject" class="btn btn-danger btn-sm">
                                                                        <i class="mdi mdi-close"></i> Reject
                                                                    </button>
                                                                </td>
                                                            </form>
                                                        </tr>
                                                    <?php } ?>
                                                <?php } ?>
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

<?php include('includes/footer.php') ?>
            
        </div>
        
        
        
    </div>

<?php include('includes/theme.php') ?>

<script src="js/vendor.min.js"></script>

<script src="js/app.js"></script>

<script src="js/apexcharts.min.js"></script>

<script src="js/component.todo.js"></script>

<script src="js/demo.crm-dashboard.js"></script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manager_approval.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation