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/manager

Free Space:

10.18 TB

🔧 Quick Actions

✏️ Editing: projects_accept.php

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <title>CRM | rutzo Admin Dashboard</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta content="A fully featured admin theme which can be used to build CRM, CMS, etc." 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>

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

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

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h4 class="header-title mb-3">Notifications</h4>
                                <table class="table table-bordered dt-responsive nowrap" style="border-collapse: collapse; border-spacing: 0; width: 100%;">
                                    <thead>
                                        <tr>
                                            <th>ID</th>
                                            <th>Sender ID</th>
                                            <th>Receiver ID</th>
                                            <th>Project Name</th>
                                            <th>Client Name</th>
                                            <th>Email</th>
                                            <th>Phone</th>
                                            <th>Budget</th>
                                            <th>Requirements</th>
                                            <th>Status</th>
                                            <th>Created At</th>
                                            <th>Action</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php
                                        include('db.php');
                                        $sql = "SELECT * FROM notifications";
                                        $result = $conn->query($sql);
                                        if ($result->num_rows > 0) {
                                            while($row = $result->fetch_assoc()) {
                                                echo "<tr>";
                                                echo "<td>" . $row['id'] . "</td>";
                                                echo "<td>" . $row['sender_id'] . "</td>";
                                                echo "<td>" . $row['receiver_id'] . "</td>";
                                                echo "<td>" . $row['project_name'] . "</td>";
                                                echo "<td>" . $row['client_name'] . "</td>";
                                                echo "<td>" . $row['email'] . "</td>";
                                                echo "<td>" . $row['phone'] . "</td>";
                                                echo "<td>" . $row['budget'] . "</td>";
                                                echo "<td>" . $row['requirements'] . "</td>";
                                                echo "<td>" . $row['status'] . "</td>";
                                                echo "<td>" . $row['created_at'] . "</td>";
                                                echo "<td><button class='btn btn-success approve-btn' data-id='" . $row['id'] . "'>Approve</button></td>";
                                                echo "</tr>";
                                            }
                                        } else {
                                            echo "<tr><td colspan='12'>No notifications found</td></tr>";
                                        }
                                        $conn->close();
                                        ?>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>

<?php
                if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['approve_id'])) {
                    $approve_id = $_POST['approve_id'];
                    include('db.php');
                    $sql = "SELECT * FROM notifications WHERE id = ?";
                    $stmt = $conn->prepare($sql);
                    $stmt->bind_param("i", $approve_id);
                    $stmt->execute();
                    $result = $stmt->get_result();
                    if ($result->num_rows > 0) {
                        $notification = $result->fetch_assoc();
                        $insert_sql = "INSERT INTO projects (client_id, manager_id, start_date, end_date, status, budget, description, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)";
                        $stmt_insert = $conn->prepare($insert_sql);
                        $client_id = $notification['receiver_id'];
                        $manager_id = 1; // Default or dynamic value as needed
                        $start_date = date('Y-m-d');
                        $end_date = date('Y-m-d', strtotime('+30 days')); // Default end date, adjust as needed
                        $status = 'approved';
                        $budget = $notification['budget'];
                        $description = $notification['requirements'];
                        $created_at = date('Y-m-d H:i:s');
                        $updated_at = date('Y-m-d H:i:s');
                        $stmt_insert->bind_param("iisssdsss", $client_id, $manager_id, $start_date, $end_date, $status, $budget, $description, $created_at, $updated_at);
                        $stmt_insert->execute();
                        $stmt_insert->close();
                        $delete_sql = "DELETE FROM notifications WHERE id = ?";
                        $stmt_delete = $conn->prepare($delete_sql);
                        $stmt_delete->bind_param("i", $approve_id);
                        $stmt_delete->execute();
                        $stmt_delete->close();
                    }
                    $stmt->close();
                    $conn->close();
                }
                ?>

</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: projects_accept.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation