@@ -6,50 +6,50 @@ discard block |
||
| 6 | 6 | $id = $_GET['id']; |
| 7 | 7 | $ticket = $tickets->ticket_data($id); |
| 8 | 8 | if ($ticket['ticketstatus'] == 'Closed') {
|
| 9 | - header("Location: ticketread.php?id=$id");
|
|
| 10 | - exit(); |
|
| 9 | + header("Location: ticketread.php?id=$id");
|
|
| 10 | + exit(); |
|
| 11 | 11 | } |
| 12 | 12 | if (isset($_POST['submit'])) {
|
| 13 | - $sla = $_POST['sla']; |
|
| 14 | - $reporteddate = strtotime($_POST['reporteddate']); |
|
| 15 | - $reportedby = $_POST['reportedby']; |
|
| 16 | - $telp = $_POST['telp']; |
|
| 17 | - $email = $_POST['email']; |
|
| 18 | - $problemsummary = $_POST['problemsummary']; |
|
| 19 | - $problemdetail = $_POST['problemdetail']; |
|
| 20 | - $assignee = $_POST['idassignee']; |
|
| 21 | - $type = $_POST['pro']; |
|
| 22 | - $ticketstatus = $_POST['ticketstatus']; |
|
| 23 | - $resolution = $_POST['resolution']; |
|
| 24 | - $pendingby = $_POST['pendingby']; |
|
| 25 | - $pendingdate = $_POST['pendingdate']; |
|
| 26 | - $resolvedby = $_POST['resolvedby']; |
|
| 27 | - $resolveddate = $_POST['resolveddate']; |
|
| 28 | - $closedby = $_POST['closedby']; |
|
| 29 | - $closeddate = $_POST['closeddate']; |
|
| 30 | - $changes = 'Re-assigned the ticket.'; |
|
| 31 | - if ($ticketstatus == 'Pending') {
|
|
| 32 | - $pendingby = $user['username']; |
|
| 33 | - $pendingdate = strtotime(now); |
|
| 34 | - $changes = 'Change Status to Pending.'; |
|
| 35 | - } |
|
| 36 | - if ($ticketstatus == 'Resolved') {
|
|
| 37 | - $resolvedby = $user['username']; |
|
| 38 | - $resolveddate = strtotime(now); |
|
| 39 | - $changes = 'Change Status to Resolved.'; |
|
| 40 | - } |
|
| 41 | - if ($ticketstatus == 'Closed') {
|
|
| 42 | - $closedby = $user['username']; |
|
| 43 | - $closeddate = strtotime(now); |
|
| 44 | - $changes = 'Change Status to Closed.'; |
|
| 45 | - } |
|
| 46 | - $tickets->update_ticket($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate); |
|
| 47 | - $tickets->log_tickets($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate, $changes, $changeby); |
|
| 48 | - if ($user['level'] == 'Admin') {
|
|
| 49 | - header('Location: ticketlist.php');
|
|
| 50 | - } else {
|
|
| 51 | - header('Location: myticketbyassignee.php');
|
|
| 52 | - } |
|
| 13 | + $sla = $_POST['sla']; |
|
| 14 | + $reporteddate = strtotime($_POST['reporteddate']); |
|
| 15 | + $reportedby = $_POST['reportedby']; |
|
| 16 | + $telp = $_POST['telp']; |
|
| 17 | + $email = $_POST['email']; |
|
| 18 | + $problemsummary = $_POST['problemsummary']; |
|
| 19 | + $problemdetail = $_POST['problemdetail']; |
|
| 20 | + $assignee = $_POST['idassignee']; |
|
| 21 | + $type = $_POST['pro']; |
|
| 22 | + $ticketstatus = $_POST['ticketstatus']; |
|
| 23 | + $resolution = $_POST['resolution']; |
|
| 24 | + $pendingby = $_POST['pendingby']; |
|
| 25 | + $pendingdate = $_POST['pendingdate']; |
|
| 26 | + $resolvedby = $_POST['resolvedby']; |
|
| 27 | + $resolveddate = $_POST['resolveddate']; |
|
| 28 | + $closedby = $_POST['closedby']; |
|
| 29 | + $closeddate = $_POST['closeddate']; |
|
| 30 | + $changes = 'Re-assigned the ticket.'; |
|
| 31 | + if ($ticketstatus == 'Pending') {
|
|
| 32 | + $pendingby = $user['username']; |
|
| 33 | + $pendingdate = strtotime(now); |
|
| 34 | + $changes = 'Change Status to Pending.'; |
|
| 35 | + } |
|
| 36 | + if ($ticketstatus == 'Resolved') {
|
|
| 37 | + $resolvedby = $user['username']; |
|
| 38 | + $resolveddate = strtotime(now); |
|
| 39 | + $changes = 'Change Status to Resolved.'; |
|
| 40 | + } |
|
| 41 | + if ($ticketstatus == 'Closed') {
|
|
| 42 | + $closedby = $user['username']; |
|
| 43 | + $closeddate = strtotime(now); |
|
| 44 | + $changes = 'Change Status to Closed.'; |
|
| 45 | + } |
|
| 46 | + $tickets->update_ticket($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate); |
|
| 47 | + $tickets->log_tickets($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate, $changes, $changeby); |
|
| 48 | + if ($user['level'] == 'Admin') {
|
|
| 49 | + header('Location: ticketlist.php');
|
|
| 50 | + } else {
|
|
| 51 | + header('Location: myticketbyassignee.php');
|
|
| 52 | + } |
|
| 53 | 53 | } |
| 54 | 54 | ?> |
| 55 | 55 | <!DOCTYPE HTML> |
@@ -141,13 +141,13 @@ discard block |
||
| 141 | 141 | <td> Urgency (SLA)*</td><td> : </td> |
| 142 | 142 | <td><select name="sla"> |
| 143 | 143 | <?php |
| 144 | - $sladata = $slas->sla_data($ticket['sla']); |
|
| 145 | - echo '<option value="'.$ticket['sla'].'" selected="selected">'.$sladata['namasla'].'</option>'; |
|
| 146 | - $sla = $slas->get_sla(); |
|
| 147 | - foreach ($sla as $slaval) {
|
|
| 148 | - echo '<option value="'.$slaval['slaid'].'">'.$slaval['namasla'].'</option>'; |
|
| 149 | - } |
|
| 150 | - ?> |
|
| 144 | + $sladata = $slas->sla_data($ticket['sla']); |
|
| 145 | + echo '<option value="'.$ticket['sla'].'" selected="selected">'.$sladata['namasla'].'</option>'; |
|
| 146 | + $sla = $slas->get_sla(); |
|
| 147 | + foreach ($sla as $slaval) {
|
|
| 148 | + echo '<option value="'.$slaval['slaid'].'">'.$slaval['namasla'].'</option>'; |
|
| 149 | + } |
|
| 150 | + ?> |
|
| 151 | 151 | </select> |
| 152 | 152 | </td> |
| 153 | 153 | </tr> |
@@ -155,10 +155,10 @@ discard block |
||
| 155 | 155 | <td> Type</td><td> : </td> |
| 156 | 156 | <td> |
| 157 | 157 | <?php |
| 158 | - //$pro = $slas->get_sla(); |
|
| 159 | - echo $ticket['pro']; |
|
| 158 | + //$pro = $slas->get_sla(); |
|
| 159 | + echo $ticket['pro']; |
|
| 160 | 160 | |
| 161 | - ?> |
|
| 161 | + ?> |
|
| 162 | 162 | |
| 163 | 163 | </td> |
| 164 | 164 | </tr> |
@@ -178,13 +178,13 @@ discard block |
||
| 178 | 178 | <td width="120"> Assign to* </td><td> : </td> |
| 179 | 179 | <td> <select name="idassignee"> |
| 180 | 180 | <?php |
| 181 | - $userassignee = $users->userdata($ticket['assignee']); |
|
| 182 | - echo '<option value='.$ticket['assignee'].' selected="selected">'.$userassignee['fullname'].'</option>'; |
|
| 183 | - $listusers = $users->get_users(); |
|
| 184 | - foreach ($listusers as $user) {
|
|
| 185 | - echo '<option value='.$user['id'].'>'.$user['fullname'].'</option>'; |
|
| 186 | - } |
|
| 187 | - ?> |
|
| 181 | + $userassignee = $users->userdata($ticket['assignee']); |
|
| 182 | + echo '<option value='.$ticket['assignee'].' selected="selected">'.$userassignee['fullname'].'</option>'; |
|
| 183 | + $listusers = $users->get_users(); |
|
| 184 | + foreach ($listusers as $user) {
|
|
| 185 | + echo '<option value='.$user['id'].'>'.$user['fullname'].'</option>'; |
|
| 186 | + } |
|
| 187 | + ?> |
|
| 188 | 188 | </select> </td> |
| 189 | 189 | </tr> |
| 190 | 190 | <tr> |
@@ -229,14 +229,14 @@ discard block |
||
| 229 | 229 | <table class="formtable"> |
| 230 | 230 | <tr bgcolor="#e0e0e0" ><td width="150">Updated On</td><td width="150">Updated By</td><td>Description</td></tr> |
| 231 | 231 | <?php |
| 232 | - $list_log_tickets = $tickets->get_audit_trail($id); |
|
| 233 | - foreach ($list_log_tickets as $log_ticket) {
|
|
| 234 | - $changed_by = $users->userdata($log_ticket['changeby']); |
|
| 235 | - echo '<tr><td>'.date('d-M-Y H:i:s', $log_ticket['changedate']).'</td>'.
|
|
| 236 | - '<td>'.$changed_by['fullname'].'</td>'. |
|
| 237 | - '<td>'.$log_ticket['changes'].'</td></tr>'; |
|
| 238 | - } |
|
| 239 | - ?> |
|
| 232 | + $list_log_tickets = $tickets->get_audit_trail($id); |
|
| 233 | + foreach ($list_log_tickets as $log_ticket) {
|
|
| 234 | + $changed_by = $users->userdata($log_ticket['changeby']); |
|
| 235 | + echo '<tr><td>'.date('d-M-Y H:i:s', $log_ticket['changedate']).'</td>'.
|
|
| 236 | + '<td>'.$changed_by['fullname'].'</td>'. |
|
| 237 | + '<td>'.$log_ticket['changes'].'</td></tr>'; |
|
| 238 | + } |
|
| 239 | + ?> |
|
| 240 | 240 | </table> |
| 241 | 241 | </fieldset> |
| 242 | 242 | <br/><br/> |
@@ -47,7 +47,7 @@ discard block |
||
| 47 | 47 | $tickets->log_tickets($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate, $changes, $changeby); |
| 48 | 48 | if ($user['level'] == 'Admin') {
|
| 49 | 49 | header('Location: ticketlist.php');
|
| 50 | - } else {
|
|
| 50 | + }else {
|
|
| 51 | 51 | header('Location: myticketbyassignee.php');
|
| 52 | 52 | } |
| 53 | 53 | } |
@@ -191,11 +191,11 @@ discard block |
||
| 191 | 191 | <td> Status* </td><td> : </td> |
| 192 | 192 | <td> <input type="hidden" name="oldticketstatus" value="<?php echo $ticket['ticketstatus']; ?>"> |
| 193 | 193 | <select name="ticketstatus"> |
| 194 | - <option value="Assigned" <?php echo ($ticket['ticketstatus'] == 'Assigned') ? 'selected="selected"' : '';?>>Assigned</option> |
|
| 195 | - <option value="Process" <?php echo ($ticket['ticketstatus'] == 'Process') ? 'selected="selected"' : '';?>>Process</option> |
|
| 196 | - <option value="Resolved" <?php echo ($ticket['ticketstatus'] == 'Resolved') ? 'selected="selected"' : '';?>>Resolved</option> |
|
| 197 | - <option value="Pending" <?php echo ($ticket['ticketstatus'] == 'Pending') ? 'selected="selected"' : '';?>>Pending</option> |
|
| 198 | - <option value="Closed" <?php echo ($ticket['ticketstatus'] == 'Closed') ? 'selected="selected"' : '';?>>Closed</option> |
|
| 194 | + <option value="Assigned" <?php echo ($ticket['ticketstatus'] == 'Assigned') ? 'selected="selected"' : ''; ?>>Assigned</option> |
|
| 195 | + <option value="Process" <?php echo ($ticket['ticketstatus'] == 'Process') ? 'selected="selected"' : ''; ?>>Process</option> |
|
| 196 | + <option value="Resolved" <?php echo ($ticket['ticketstatus'] == 'Resolved') ? 'selected="selected"' : ''; ?>>Resolved</option> |
|
| 197 | + <option value="Pending" <?php echo ($ticket['ticketstatus'] == 'Pending') ? 'selected="selected"' : ''; ?>>Pending</option> |
|
| 198 | + <option value="Closed" <?php echo ($ticket['ticketstatus'] == 'Closed') ? 'selected="selected"' : ''; ?>>Closed</option> |
|
| 199 | 199 | </select> |
| 200 | 200 | </td> |
| 201 | 201 | </tr> |