$ticketTitle"; $time = time(); foreach ($assignedUsers as $user_id) { // 1. Notification Bell $notif_query = "INSERT INTO jeoXillityCrm_notifications (user_id, message, link, is_read, created_at) VALUES ('$user_id', '$message', '$pageLink', 0, '$time')"; runQuery($notif_query); // 2. Email Alert $userInfo = getRow($con, "SELECT email, name FROM jeoXillityCrm_users WHERE name='$user_id'"); // echo $userInfo; die(); if (!empty($userInfo['email'])) { $to = $userInfo['email']; $subject = "New Ticket Assigned: $ticketTitle"; $body = "Hello {$userInfo['name']},

You have been assigned to a new ticket titled $ticketTitle.
Click here to view

Thank you,
Support Team"; $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type:text/html;charset=UTF-8" . "\r\n"; $headers .= "From: noreply@xillity-crm.online\r\n"; if (!mail($to, $subject, $body, $headers)) { error_log("Email to $to failed to send."); } else { error_log("Email to $to sent successfully."); } } } } header("Location: ?m=Data was saved successfully!&type=success"); exit(); } // if (isset($_GET['delete-record'])) { // $id = escape($_GET['delete-record']); // $query = "delete from jeoXillityCrm_tickets where id='$id'"; // runQuery($query); // } if (isset($_GET['delete-record'])) { $id = escape($_GET['delete-record']); // Check if there are tickets associated with the company $chk = "SELECT * FROM jeoXillityCrm_tickets WHERE id='$id' AND is_deleted = 0"; $chk_run = mysqli_query($con, $chk); if (!$chk_run) { die("Database error: " . mysqli_error($con)); } if (mysqli_num_rows($chk_run) > 0) { $moveToTrash = "UPDATE jeoXillityCrm_tickets SET is_deleted = 1 WHERE id='$id'"; mysqli_query($con, $moveToTrash); header("Location: ?m=Tickets moved to trash. You can recover them from Trash.!&type=success"); } } if (isset($_POST['filter'])) { $status = isset($_POST['status']) ? escape($_POST['status']) : ''; $priority = isset($_POST['priority']) ? escape($_POST['priority']) : ''; // Construct the query with filters $query = "SELECT * FROM jeoXillityCrm_tickets WHERE 1=1"; if ($status != '') { $query .= " AND status = '$status'"; } if ($priority != '') { $query .= " AND priority = '$priority'"; } $query .= " AND userId='$session_userId' AND is_deleted=0"; // echo $query;die(); // Execute the query $results = getAll($con, $query); } else { // Default query to display all records $session_userName = $_SESSION['username'] ?? null; $query = "select * from jeoXillityCrm_tickets t where (t.userId='$session_userId' or t.assign like '%$session_userName%') AND t.is_deleted=0 order by t.timeAdded desc"; // echo($query);die(); $results = getAll($con, $query); } if (isset($_POST['site_names'])) { $siteName = $_POST['site_names']; $query = "SELECT * FROM jeoXillityCrm_sites WHERE site_name = '$siteName' and userId='$session_userId'"; // print_r($query);die(); $results = getall($con, $query); $output = ''; foreach ($results as $row) { $output .= ''; } echo $output; } if (isset($_POST['companyId'])) { $companyId = $_POST['companyId']; $sql = "SELECT * FROM jeoXillityCrm_sites WHERE company_id = $companyId"; $stmt = $con->prepare($sql); $stmt->bind_param("i", $companyId); $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows > 0) { echo ''; while ($row = $result->fetch_assoc()) { echo ''; } } else { echo ''; } $stmt->close(); } ?>

Ticket Summary

Trash Bin