session->userdata('USER_ID'); $role = $this->session->userdata('USER_ROLE'); ?>

Tickets

Create New Ticket
View Assigned Tickets
Create / Edit Tickets Use the below form to edit tickets.
Ticket No Assigned to Contact No Created Date Modified Date Turn arround time Modified User Status Actions
db->query("SELECT * FROM users WHERE (role = '3' OR role = '6' OR role = '7') AND user_id = $technician")->result_array(); foreach ($users as $user) { echo $user['user_name']; // Output user name } } ?> db->query("SELECT * FROM users WHERE role = '3' AND user_id = $technician")->result_array(); foreach ($users as $user) { echo $user['user_name']; // Output user name } } ?> db->query("SELECT * FROM users WHERE (role = '6' OR role = '7') AND user_id = $technician")->result_array(); foreach ($users as $user) { echo $user['user_name']; // Output user name } } ?> diff($endDate); $totalDays = $dateInterval->days; $totalSeconds = $dateInterval->s + ($dateInterval->i * 60) + ($dateInterval->h * 3600) + ($dateInterval->days * 86400); // Calculate total hours, minutes, and seconds $totalHours = floor($totalSeconds / 3600); $totalMinutes = floor(($totalSeconds % 3600) / 60); $totalSeconds = $totalSeconds % 60; echo $totalDays ."days -". $totalHours .":". $totalMinutes .":". $totalSeconds; // echo "Total Time: " . $totalHours . " hours, " . $totalMinutes . " minutes, " . $totalSeconds . " seconds\n"; ?> Acknowledged Return with query Mark Resolved Return cancel ' title="view completed ticket"> ' title="edit"> ' class="view_ticket_details btn btn-sm btn-outline grey-salsa delete_button" title="delete" id='delete_button'>