<?= $viewing_ticket ? 'Ticket Details' : 'Ticket System' ?>

when i click the "Ticket" menu, it return blank page setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { die("Database connection failed: " . $e->getMessage()); } // Custom security check if (empty($_SESSION['user_id'])) { header("Location: http://localhost/helpdesk/?page_id=50"); exit; } // Get current user data $stmt = $pdo->prepare("SELECT * FROM users WHERE id = ?"); $stmt->execute([$_SESSION['user_id']]); $current_user = $stmt->fetch(PDO::FETCH_ASSOC); if (!$current_user) { session_destroy(); header("Location: http://localhost/helpdesk/?page_id=50"); exit; } // Base URL for ticket system $base_url = 'http://localhost/helpdesk/?page_id=70'; // Check if viewing/editing ticket $viewing_ticket = isset($_GET['ticket_id']); $editing_ticket = $viewing_ticket && isset($_GET['action']) && $_GET['action'] === 'edit'; $ticket_id = $viewing_ticket ? (int)$_GET['ticket_id'] : 0; if ($viewing_ticket) { // Get ticket details $stmt = $pdo->prepare(" SELECT t.*, d.name as department_name, CONCAT(u.first_name, ' ', u.last_name) as creator_name, CONCAT(a.first_name, ' ', a.last_name) as assigned_name FROM tickets t LEFT JOIN departments d ON t.department_id = d.id LEFT JOIN users u ON t.created_by = u.id LEFT JOIN users a ON t.assigned_to = a.id WHERE t.id = ? "); $stmt->execute([$ticket_id]); $ticket = $stmt->fetch(PDO::FETCH_ASSOC); // Check if ticket exists and user has permission if (!$ticket) { die("Ticket not found"); } if ($current_user['role'] === 'user' && $ticket['created_by'] != $current_user['id']) { die("You don't have permission to view this ticket"); } // Get ticket messages $stmt = $pdo->prepare(" SELECT m.*, CONCAT(u.first_name, ' ', u.last_name) as user_name, u.role as user_role FROM ticket_messages m JOIN users u ON m.user_id = u.id WHERE m.ticket_id = ? ORDER BY m.created_at ASC "); $stmt->execute([$ticket_id]); $messages = $stmt->fetchAll(PDO::FETCH_ASSOC); } // Handle form submissions $message = ''; $message_type = ''; if ($_SERVER['REQUEST_METHOD'] === 'POST') { if (isset($_POST['create_ticket'])) { $subject = htmlspecialchars($_POST['subject']); $description = htmlspecialchars($_POST['description']); $priority = htmlspecialchars($_POST['priority']); $department_id = (int)$_POST['department_id']; try { $ticket_number = 'TKT-' . date('Ymd-His'); $stmt = $pdo->prepare("INSERT INTO tickets (ticket_number, subject, description, priority, department_id, created_by, status, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, 'open', NOW(), NOW())"); $stmt->execute([ $ticket_number, $subject, $description, $priority, $department_id, $current_user['id'] ]); $ticket_id = $pdo->lastInsertId(); // Add initial message $stmt = $pdo->prepare("INSERT INTO ticket_messages (ticket_id, user_id, message, created_at) VALUES (?, ?, ?, NOW())"); $stmt->execute([ $ticket_id, $current_user['id'], $description ]); $message = 'Ticket created successfully!'; $message_type = 'success'; } catch (PDOException $e) { $message = 'Error creating ticket: ' . $e->getMessage(); $message_type = 'error'; } } elseif (isset($_POST['update_status'])) { $ticket_id = (int)$_POST['ticket_id']; $status = htmlspecialchars($_POST['status']); try { $stmt = $pdo->prepare("UPDATE tickets SET status = ?, updated_at = NOW() WHERE id = ?"); $stmt->execute([$status, $ticket_id]); // Add status change message $stmt = $pdo->prepare("INSERT INTO ticket_messages (ticket_id, user_id, message, created_at) VALUES (?, ?, ?, NOW())"); $stmt->execute([ $ticket_id, $current_user['id'], "Status changed to: " . ucfirst($status) ]); $message = 'Ticket status updated!'; $message_type = 'success'; } catch (PDOException $e) { $message = 'Error updating ticket status: ' . $e->getMessage(); $message_type = 'error'; } } elseif (isset($_POST['assign_ticket'])) { $ticket_id = (int)$_POST['ticket_id']; $assign_to = (int)$_POST['assign_to']; try { $stmt = $pdo->prepare("UPDATE tickets SET assigned_to = ?, status = 'assigned', updated_at = NOW() WHERE id = ?"); $stmt->execute([$assign_to, $ticket_id]); // Add assignment message $stmt = $pdo->prepare("INSERT INTO ticket_messages (ticket_id, user_id, message, created_at) VALUES (?, ?, ?, NOW())"); $stmt->execute([ $ticket_id, $current_user['id'], "Ticket assigned to staff ID: " . $assign_to ]); $message = 'Ticket assigned successfully!'; $message_type = 'success'; } catch (PDO::FETCH_ASSOC) { $message = 'Error assigning ticket: ' . $e->getMessage(); $message_type = 'error'; } } elseif (isset($_POST['add_message'])) { $ticket_id = (int)$_POST['ticket_id']; $message_text = htmlspecialchars($_POST['message']); try { $stmt = $pdo->prepare("INSERT INTO ticket_messages (ticket_id, user_id, message, created_at) VALUES (?, ?, ?, NOW())"); $stmt->execute([ $ticket_id, $current_user['id'], $message_text ]); // Update ticket's updated_at $stmt = $pdo->prepare("UPDATE tickets SET updated_at = NOW() WHERE id = ?"); $stmt->execute([$ticket_id]); $message = 'Message added successfully!'; $message_type = 'success'; // Refresh messages $stmt = $pdo->prepare(" SELECT m.*, CONCAT(u.first_name, ' ', u.last_name) as user_name, u.role as user_role FROM ticket_messages m JOIN users u ON m.user_id = u.id WHERE m.ticket_id = ? ORDER BY m.created_at ASC "); $stmt->execute([$ticket_id]); $messages = $stmt->fetchAll(PDO::FETCH_ASSOC); } catch (PDOException $e) { $message = 'Error adding message: ' . $e->getMessage(); $message_type = 'error'; } } elseif (isset($_POST['update_ticket'])) { $ticket_id = (int)$_POST['ticket_id']; $subject = htmlspecialchars($_POST['subject']); $description = htmlspecialchars($_POST['description']); $priority = htmlspecialchars($_POST['priority']); try { $stmt = $pdo->prepare("UPDATE tickets SET subject = ?, description = ?, priority = ?, updated_at = NOW() WHERE id = ?"); $stmt->execute([$subject, $description, $priority, $ticket_id]); // Add update message $stmt = $pdo->prepare("INSERT INTO ticket_messages (ticket_id, user_id, message, created_at) VALUES (?, ?, ?, NOW())"); $stmt->execute([ $ticket_id, $current_user['id'], "Ticket details updated" ]); $message = 'Ticket updated successfully!'; $message_type = 'success'; // Refresh ticket data $stmt = $pdo->prepare("SELECT * FROM tickets WHERE id = ?"); $stmt->execute([$ticket_id]); $ticket = $stmt->fetch(PDO::FETCH_ASSOC); } catch (PDOException $e) { $message = 'Error updating ticket: ' . $e->getMessage(); $message_type = 'error'; } } } // Get all necessary data for ticket list if (!$viewing_ticket) { try { // Get tickets based on role if ($current_user['role'] === 'admin' || $current_user['role'] === 'staff') { $tickets = $pdo->query(" SELECT t.*, d.name as department_name, CONCAT(u.first_name, ' ', u.last_name) as creator_name, CONCAT(a.first_name, ' ', a.last_name) as assigned_name FROM tickets t LEFT JOIN departments d ON t.department_id = d.id LEFT JOIN users u ON t.created_by = u.id LEFT JOIN users a ON t.assigned_to = a.id ORDER BY t.created_at DESC ")->fetchAll(PDO::FETCH_ASSOC); } else { $stmt = $pode->prepare(" SELECT t.*, d.name as department_name, CONCAT(a.first_name, ' ', a.last_name) as assigned_name FROM tickets t LEFT JOIN departments d ON t.department_id = d.id LEFT JOIN users a ON t.assigned_to = a.id WHERE t.created_by = ? ORDER BY t.created_at DESC "); $stmt->execute([$current_user['id']]); $tickets = $stmt->fetchAll(PDO::FETCH_ASSOC); } // Get departments for dropdown $departments = $pdo->query("SELECT * FROM departments")->fetchAll(PDO::FETCH_ASSOC); // Get staff for assignment dropdown $staff_members = $pdo->query(" SELECT id, CONCAT(first_name, ' ', last_name) as name FROM users WHERE role IN ('staff', 'admin') ")->fetchAll(PDO::FETCH_ASSOC); } catch (PDOException $e) { die("Error fetching data: " . $e->getMessage()); } } ?> <?= $viewing_ticket ? 'Ticket Details' : 'Ticket System' ?>

Edit Ticket #

priority

Description

Created By:

Department:

Assigned To:

Created At:

Last Updated:

Conversation

No messages yet.

Add Message

Create New Ticket

Subject

Description

Priority

Department

No tickets found.

Ticket #	Created By	Subject	Status	Priority	Department	Assigned To	Created At	Actions
								View Edit

I check the consoloe forr error it show this: Uncaught TypeError: Cannot set properties of null (setting 'onclick') at scroll-to-top.js:12:56