if ($ticketLevel == 1 && ($status == 1 || $status == 4) || $ticketLevel == 2 && $status == 2) { changeTicketStatus($ticket_id, 3); } if (isset($_POST['uaction'])) { if ($_POST['uaction'] == "close") { // close ticket closeTicket($ticket_id); } elseif ($_POST['uaction'] == "open") { // open ticket openTicket($ticket_id); } elseif (empty($_POST['user_message'])) { // no message check->error set_page_message(tr('Please type your message!'), 'warning'); } else { $userLevel = getUserLevel($_GET['ticket_id']); updateTicket($ticket_id, $user_id, $_POST['urgency'], $_POST['subject'], $_POST['user_message'], $userLevel, 2); user_goto('ticket_system.php'); } } showTicketContent($tpl, $ticket_id, $user_id, $screenwidth); } else { set_page_message(tr('Ticket not found!'), 'error'); user_goto('ticket_system.php'); } // static page messages gen_logged_from($tpl); $tpl->assign(array('TR_PAGE_TITLE' => tr('EasySCP - Reseller: Support System: View Ticket'), 'TR_VIEW_SUPPORT_TICKET' => tr('View support ticket'), 'TR_TICKET_URGENCY' => tr('Priority'), 'TR_TICKET_SUBJECT' => tr('Subject'), 'TR_TICKET_DATE' => tr('Date'), 'TR_DELETE' => tr('Delete'), 'TR_NEW_TICKET_REPLY' => tr('Send message reply'), 'TR_REPLY' => tr('Send reply'), 'TR_TICKET_FROM' => tr('From'), 'TR_OPEN_TICKETS' => tr('Open tickets'), 'TR_CLOSED_TICKETS' => tr('Closed tickets'))); gen_reseller_mainmenu($tpl, 'reseller/main_menu_ticket_system.tpl'); gen_reseller_menu($tpl, 'reseller/menu_ticket_system.tpl'); gen_page_message($tpl); if ($cfg->DUMP_GUI_DEBUG) {
<?php require_once '/var/www/html/app/model/connect.php'; require_once 'Show_reseve.php'; if (isset($_POST['submit_btn'])) { updateTicket(); //header("Refresh:0"); } ?> <html> <head> <style> td { padding: 10px; } .center_text { text-align: center; } </style> </head> <body> <div style="text-align:center; font-size:50px;">Show List</div> <table border="3px" style="border-collapse: collapse; margin:auto; background-color:rgba(255,255,255,0.1);"> <tr><td>SHOW TICKET ID</td><td>DATE</td><td>SHOW ID</td><td>ZONE ID</td><td>SHOW NAME</td><td>Start Time</td><td>End Time</td><td>Reseve</td></tr> <?php $conn = dbConnect(); if ($conn) { //echo "connection status : ".$conn; //Part one select data from tickettype $sql = "SELECT * FROM EMM_ZOO.SHOW_TICKET WHERE DATES >= CURRENT DATE AND ENDTIME >= CURRENT TIME;"; $stmt = db2_exec($conn, $sql);
$userId = $_SESSION['user_id']; $ticketId = (int) $_GET['ticket_id']; $status = getTicketStatus($ticketId); if ($status == 1 || $status == 4) { if (!changeTicketStatus($ticketId, 3)) { redirectTo('ticket_system.php'); } } if (isset($_POST['uaction'])) { if ($_POST['uaction'] == 'close') { closeTicket($ticketId); } elseif (isset($_POST['user_message'])) { if (empty($_POST['user_message'])) { set_page_message(tr('Please type your message.'), 'error'); } else { updateTicket($ticketId, $userId, $_POST['urgency'], $_POST['subject'], $_POST['user_message'], 2, 3); } } redirectTo('ticket_system.php'); } } else { set_page_message(tr('Ticket not found.'), 'error'); redirectTo('ticket_system.php'); exit; } $tpl = new iMSCP_pTemplate(); $tpl->define_dynamic(array('layout' => 'shared/layouts/ui.tpl', 'page' => 'admin/ticket_view.tpl', 'page_message' => 'layout', 'tickets_list' => 'page', 'tickets_item' => 'tickets_list')); $tpl->assign(array('TR_PAGE_TITLE' => tr('Admin / Support / View Ticket'), 'TR_VIEW_SUPPORT_TICKET' => tr('View Support Ticket'), 'TR_TICKET_INFO' => tr('Ticket Information'), 'TR_TICKET_URGENCY' => tr('Priority'), 'TR_TICKET_SUBJECT' => tr('Subject'), 'TR_TICKET_MESSAGES' => tr('Messages'), 'TR_TICKET_FROM' => tr('From'), 'TR_TICKET_DATE' => tr('Date'), 'TR_TICKET_CONTENT' => tr('Message'), 'TR_REPLY' => tr('Reply'), 'TR_TICKET_NEW_REPLY' => tr('Send new reply'), 'TR_TICKET_REPLY' => tr('Send reply'))); generateNavigation($tpl); showTicketContent($tpl, $ticketId, $userId); generatePageMessage($tpl);
$pre_exist_check = getRequest($json['interaction_id']); // Insert ticket if ($pre_exist_check === null) { $create_ticket = createTicket($json); if ($create_ticket !== null) { header('Content-Type: application/json'); http_response_code(201); echo json_encode($create_ticket); exit; } else { header('Content-Type: application/json'); echo json_encode(['error' => 'Error: Ticket ID already in system!']); exit; } } else { $update_ticket = updateTicket($json); if ($update_ticket !== null) { header('Content-Type: application/json'); http_response_code(201); echo json_encode($update_ticket); exit; } else { header('Content-Type: application/json'); echo json_encode(['error' => 'Error: Unable to update specified ticket!']); exit; } } } } else { if (isset($_GET['gm_id'])) { $gm_id = trim($_GET['gm_id']);
<?php if (isset($_POST['action']) && isset($_GET['update'])) { $ticket = array('ticket_id' => $_GET['update'], 'ticket_notes' => $_POST['ticket_notes'], 'ticket_status' => $_POST['ticket_status']); updateTicket($ticket); } $ticket = null; if (isset($_GET['update'])) { $ticket = mysqli_fetch_object(getTicketByID($_GET['update'])); } ?> <section id="my-account-security-form" class="page container"> <form id="userSecurityForm" class="form-horizontal" action="" method="post"> <div class="container"> <div class="alert alert-block alert-info"> <p> Enter information for your account as desired. Fields marked with an asterisk are required. </p> </div> <div class="row"> <div id="acct-password-row" class="span7"> <fieldset> <legend>Ticket Form</legend><br> <?php if (isset($_POST['action']) && !isset($_GET['update'])) { $ticket = array('ticket_name' => $_POST['ticket_name'], 'ticket_notes' => nl2br($_POST['ticket_notes']), 'ticket_status' => $_POST['ticket_status'], 'case_id' => $_GET['case'], 'created_by' => $_SESSION['user']['employee_id']); $ticket_id = createTicket($ticket); if ($ticket_id > -1) {