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'> |