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

Free Space:

10.25 TB

🔧 Quick Actions

✏️ Editing: meetings.php

<?php
session_start(); // ✅ Must be the first thing in the script
 include '../db.php';

// Safely get session value
$user_id = $_SESSION['user_id'] ?? null;

if (!$user_id) {
    // Optional: redirect unauthorized access
    header("Location: /ems/index.php");
    exit();
}?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <title>CRM | Decconz 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/dec.jpeg">

<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 'super-sidebar.php'; ?>
        <?php include 'super-nav.php'; ?>

<div class="content-page">
            <div class="content container-fluid">

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h4 class="header-title">Meeting Schedule</h4>

<form method="POST" action="" class="row g-3 mb-4">
                                    <div class="col-md-4">
                                        <label for="title" class="form-label">Meeting Title</label>
                                        <input type="text" name="title" class="form-control" required>
                                    </div>
                                    <div class="col-md-4">
                                        <label for="date" class="form-label">Date</label>
                                        <input type="date" name="date" class="form-control" required>
                                    </div>
                                    <div class="col-md-4">
                                        <label for="time" class="form-label">Time</label>
                                        <input type="time" name="time" class="form-control" required>
                                    </div>
                                    <div class="col-12">
                                        <label for="agenda" class="form-label">Agenda</label>
                                        <textarea name="agenda" rows="3" class="form-control" required></textarea>
                                    </div>
                                    <div class="col-12 text-end">
                                        <button type="submit" name="schedule" class="btn btn-success">Schedule Meeting</button>
                                    </div>
                                </form>

<?php
                                // Enable error reporting (for development only)
                                error_reporting(E_ALL);
                                ini_set('display_errors', 1);

if (!$conn) {
                                    die("<div class='alert alert-danger'>Database connection failed: " . mysqli_connect_error() . "</div>");
                                }

if (isset($_POST['schedule'])) {
                                    $title = mysqli_real_escape_string($conn, $_POST['title']);
                                    $meeting_date = mysqli_real_escape_string($conn, $_POST['date']);
                                    $start_time = mysqli_real_escape_string($conn, $_POST['time']);
                                    $notes = mysqli_real_escape_string($conn, $_POST['agenda']);
                                    $end_time = NULL;

// Generate meeting link using OpenRouter API
                                    $api_key = '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';
                                    $ch = curl_init();
                                    curl_setopt($ch, CURLOPT_URL, "https://openrouter.ai/api/v1/chat/completions");
                                    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
                                    curl_setopt($ch, CURLOPT_POST, 1);
                                    curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode([
                                        'model' => 'openai/gpt-3.5-turbo',
                                        'messages' => [['role' => 'user', 'content' => "Generate a unique Google Meet link for $title on $meeting_date at $start_time that opens in the Google Meet app"]]
                                    ]));
                                    curl_setopt($ch, CURLOPT_HTTPHEADER, [
                                        'Content-Type: application/json',
                                        "Authorization: Bearer $api_key"
                                    ]);

$response = curl_exec($ch);
                                    curl_close($ch);

if ($response === false) {
                                        $meet_link = "https://meet.google.com/new?hs=198"; // Fallback link
                                    } else {
                                        $data = json_decode($response, true);
                                        $meet_link = isset($data['choices'][0]['message']['content']) ? trim($data['choices'][0]['message']['content']) : "https://meet.google.com/new?hs=198";
                                    }

// Insert into database
                                    $query = "INSERT INTO meetings (title, meeting_date, start_time, end_time, notes, link) VALUES ('$title', '$meeting_date', '$start_time', NULL, '$notes', '$meet_link')";
                                        if (mysqli_query($conn, $query)) {
                                        echo "<div class='alert alert-success'>Meeting Scheduled with link: <a href='$meet_link' target='_blank'>$meet_link</a></div>";
                                    } else {
                                        echo "<div class='alert alert-danger'>Query Error: " . mysqli_error($conn) . "</div>";
                                    }
                                }
                                ?>

<div class="table-responsive">
                                    <table class="table table-striped table-bordered" id="meetingTable">
                                        <thead>
                                            <tr>
                                                <th>Title</th>
                                                <th>Date</th>
                                                <th>Start Time</th>
                                                <th>End Time</th>
                                                <th>Notes</th>
                                                <th>Link</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            $result = mysqli_query($conn, "SELECT * FROM meetings ORDER BY meeting_date DESC, start_time DESC");
                                            if (!$result) {
                                                echo "<tr><td colspan='6' class='alert alert-danger'>Error fetching data: " . mysqli_error($conn) . "</td></tr>";
                                            } else {
                                                while ($row = mysqli_fetch_assoc($result)) {
                                                    echo "<tr>
                                                            <td>{$row['title']}</td>
                                                            <td>{$row['meeting_date']}</td>
                                                            <td>{$row['start_time']}</td>
                                                            <td>" . ($row['end_time'] ?? 'N/A') . "</td>
                                                            <td>{$row['notes']}</td>
                                                            <td><a href='{$row['link']}' target='_blank'>Join Meeting</a></td>
                                                          </tr>";
                                                }
                                            }
                                            ?>
                                        </tbody>
                                    </table>
                                </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: meetings.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation