@@ -3,12 +3,12 @@ discard block |
||
| 3 | 3 | $general->logged_out_protect(); |
| 4 | 4 | $user = $users->userdata($_SESSION['loginid']); |
| 5 | 5 | if ($user['level'] == 'Admin' || $user['level'] == 'Manager') {
|
| 6 | - $akses = true; |
|
| 6 | + $akses = true; |
|
| 7 | 7 | } else {
|
| 8 | - $akses = false; |
|
| 8 | + $akses = false; |
|
| 9 | 9 | } |
| 10 | 10 | if ($akses = false) {
|
| 11 | - exit("You don't have permission to access this page!");
|
|
| 11 | + exit("You don't have permission to access this page!");
|
|
| 12 | 12 | } |
| 13 | 13 | $ticket_list = $tickets->get_tickets(); |
| 14 | 14 | $tickets_count = count($ticket_list); |
@@ -70,35 +70,35 @@ discard block |
||
| 70 | 70 | </thead> |
| 71 | 71 | <tbody> |
| 72 | 72 | <?php |
| 73 | - foreach ($ticket_list as $ticket) {
|
|
| 74 | - $sla = $slas->sla_data($ticket['sla']); |
|
| 75 | - $documenteddate = $ticket['documenteddate']; |
|
| 76 | - $resolutiontime = $sla['resolutiontime']; |
|
| 77 | - $slawarning = $sla['slawarning']; |
|
| 78 | - $slagoaltime = strtotime("+$resolutiontime hours", $documenteddate);
|
|
| 79 | - $slawarningtime = strtotime("+$slawarning hours", $documenteddate);
|
|
| 80 | - if ($currenttime > $slagoaltime) {
|
|
| 81 | - $slabgcolor = '#FF0000'; |
|
| 82 | - $slatxtcolor = '#ffffff'; |
|
| 83 | - } elseif ($currenttime >= $slawarningtime) {
|
|
| 84 | - $slabgcolor = '#FFFF00'; |
|
| 85 | - $slatxtcolor = '#000000'; |
|
| 86 | - } else {
|
|
| 87 | - $slabgcolor = '#00FF00'; |
|
| 88 | - $slatxtcolor = '#000000'; |
|
| 89 | - } |
|
| 90 | - $user = $users->userdata($ticket['assignee']); |
|
| 91 | - echo '<tr><td><a href=ticketedit.php?id='.$ticket['id'].'>'.$ticket['ticketnumber'].'</a></td>'. |
|
| 92 | - '<td style="background-color:'.$slabgcolor.';color:'.$slatxtcolor.';">'.$sla['namasla'].'</td>'. |
|
| 93 | - '<td>'.date('d-M-Y H:i:s', $slagoaltime).'</td>'.
|
|
| 94 | - '<td>'.date('d-M-Y H:i:s', $ticket['reporteddate']).'</td>'.
|
|
| 95 | - '<td>'.date('d-M-Y H:i:s', $ticket['documenteddate']).'</td>'.
|
|
| 96 | - '<td>'.$ticket['problemsummary'].'</td>'. |
|
| 97 | - '<td>'.$ticket['ticketstatus'].'</td>'. |
|
| 98 | - '<td>'.$user['fullname'].'</td>'. |
|
| 99 | - '<td><a href=ticketdel.php?id='.$ticket['id'].' onclick="return delete_confirm();">del</a></td></tr>'; |
|
| 100 | - } |
|
| 101 | - ?> |
|
| 73 | + foreach ($ticket_list as $ticket) {
|
|
| 74 | + $sla = $slas->sla_data($ticket['sla']); |
|
| 75 | + $documenteddate = $ticket['documenteddate']; |
|
| 76 | + $resolutiontime = $sla['resolutiontime']; |
|
| 77 | + $slawarning = $sla['slawarning']; |
|
| 78 | + $slagoaltime = strtotime("+$resolutiontime hours", $documenteddate);
|
|
| 79 | + $slawarningtime = strtotime("+$slawarning hours", $documenteddate);
|
|
| 80 | + if ($currenttime > $slagoaltime) {
|
|
| 81 | + $slabgcolor = '#FF0000'; |
|
| 82 | + $slatxtcolor = '#ffffff'; |
|
| 83 | + } elseif ($currenttime >= $slawarningtime) {
|
|
| 84 | + $slabgcolor = '#FFFF00'; |
|
| 85 | + $slatxtcolor = '#000000'; |
|
| 86 | + } else {
|
|
| 87 | + $slabgcolor = '#00FF00'; |
|
| 88 | + $slatxtcolor = '#000000'; |
|
| 89 | + } |
|
| 90 | + $user = $users->userdata($ticket['assignee']); |
|
| 91 | + echo '<tr><td><a href=ticketedit.php?id='.$ticket['id'].'>'.$ticket['ticketnumber'].'</a></td>'. |
|
| 92 | + '<td style="background-color:'.$slabgcolor.';color:'.$slatxtcolor.';">'.$sla['namasla'].'</td>'. |
|
| 93 | + '<td>'.date('d-M-Y H:i:s', $slagoaltime).'</td>'.
|
|
| 94 | + '<td>'.date('d-M-Y H:i:s', $ticket['reporteddate']).'</td>'.
|
|
| 95 | + '<td>'.date('d-M-Y H:i:s', $ticket['documenteddate']).'</td>'.
|
|
| 96 | + '<td>'.$ticket['problemsummary'].'</td>'. |
|
| 97 | + '<td>'.$ticket['ticketstatus'].'</td>'. |
|
| 98 | + '<td>'.$user['fullname'].'</td>'. |
|
| 99 | + '<td><a href=ticketdel.php?id='.$ticket['id'].' onclick="return delete_confirm();">del</a></td></tr>'; |
|
| 100 | + } |
|
| 101 | + ?> |
|
| 102 | 102 | </tbody> |
| 103 | 103 | </table> |
| 104 | 104 | <p> </p> |
@@ -5,16 +5,16 @@ |
||
| 5 | 5 | require_once 'connect/database.php'; |
| 6 | 6 | function my_autoload($class) |
| 7 | 7 | { |
| 8 | - $filename = 'classes/'.$class.'.php'; |
|
| 9 | - include_once $filename; |
|
| 8 | + $filename = 'classes/'.$class.'.php'; |
|
| 9 | + include_once $filename; |
|
| 10 | 10 | } |
| 11 | 11 | spl_autoload_register('my_autoload'); |
| 12 | 12 | |
| 13 | 13 | try { |
| 14 | - $general = new General(); |
|
| 15 | - $users = new Users($db); |
|
| 16 | - $tickets = new Tickets($db); |
|
| 17 | - $slas = new SLA($db); |
|
| 14 | + $general = new General(); |
|
| 15 | + $users = new Users($db); |
|
| 16 | + $tickets = new Tickets($db); |
|
| 17 | + $slas = new SLA($db); |
|
| 18 | 18 | } catch (Exception $e) { |
| 19 | - echo 'Caught exception: ', $e->getMessage(), "\n"; |
|
| 19 | + echo 'Caught exception: ', $e->getMessage(), "\n"; |
|
| 20 | 20 | } |
@@ -7,20 +7,20 @@ discard block |
||
| 7 | 7 | $ticket_list = array(); |
| 8 | 8 | $i = 0; $color[0] = 'FF0000'; $color[1] = '00FF00'; $color[2] = 'FFFF00'; $color[3] = '0000FF'; $color[4] = 'FF00FF'; |
| 9 | 9 | foreach ($ticket_list as $ticket) {
|
| 10 | - @$value .= $ticket['total'].'#'; |
|
| 11 | - @$name .= '#'; |
|
| 12 | - //echo $value[i].'<br>'.$name[i].'<br>'; |
|
| 13 | - //$color[$i++]; |
|
| 10 | + @$value .= $ticket['total'].'#'; |
|
| 11 | + @$name .= '#'; |
|
| 12 | + //echo $value[i].'<br>'.$name[i].'<br>'; |
|
| 13 | + //$color[$i++]; |
|
| 14 | 14 | } |
| 15 | 15 | $arr_value = explode('#', $value);
|
| 16 | 16 | $arr_name = explode('#', $name);
|
| 17 | 17 | //echo $arr_name[0].$arr_name[1].$arr_name[2].$arr_name[3].$arr_name[4]; |
| 18 | 18 | $ticket_list2 = $tickets->count_tickets_by_status(); |
| 19 | 19 | foreach ($ticket_list2 as $ticket2) {
|
| 20 | - @$value2 .= $ticket2['total'].'#'; |
|
| 21 | - @$name2 .= $ticket2['ticketstatus'].'#'; |
|
| 22 | - //echo $value[i].'<br>'.$name[i].'<br>'; |
|
| 23 | - //$color[$i++]; |
|
| 20 | + @$value2 .= $ticket2['total'].'#'; |
|
| 21 | + @$name2 .= $ticket2['ticketstatus'].'#'; |
|
| 22 | + //echo $value[i].'<br>'.$name[i].'<br>'; |
|
| 23 | + //$color[$i++]; |
|
| 24 | 24 | } |
| 25 | 25 | $arr_value2 = explode('#', $value2);
|
| 26 | 26 | $arr_name2 = explode('#', $name2);
|
@@ -28,12 +28,12 @@ discard block |
||
| 28 | 28 | $ResolvedBulan = [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]; |
| 29 | 29 | $ticket_list3 = $tickets->count_resolved_tickets_by_month(); |
| 30 | 30 | foreach ($ticket_list3 as $ticket3) {
|
| 31 | - @$ResolvedBulan[$ticket3['Bulan']] = $ticket3['Total']; |
|
| 31 | + @$ResolvedBulan[$ticket3['Bulan']] = $ticket3['Total']; |
|
| 32 | 32 | } |
| 33 | 33 | $InProgressBulan = [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]; |
| 34 | 34 | $ticket_list4 = $tickets->count_inprogress_tickets_by_month(); |
| 35 | 35 | foreach ($ticket_list4 as $ticket4) {
|
| 36 | - @$InProgressBulan[$ticket4['Bulan']] = $ticket4['Total']; |
|
| 36 | + @$InProgressBulan[$ticket4['Bulan']] = $ticket4['Total']; |
|
| 37 | 37 | } |
| 38 | 38 | ?> |
| 39 | 39 | <!DOCTYPE html> |
@@ -34,7 +34,7 @@ |
||
| 34 | 34 | echo "<li><p>Jumlah tiket yang ditugaskan untuk Anda: $tickets_assigned tickets.</p></li> "; |
| 35 | 35 | echo "<li><p>Anda telah menyelesaikan $tickets_resolved tickets.</p></li>"; |
| 36 | 36 | } |
| 37 | - ?> |
|
| 37 | + ?> |
|
| 38 | 38 | </ol><br/> |
| 39 | 39 | </td> |
| 40 | 40 | </tr> |
@@ -50,18 +50,18 @@ |
||
| 50 | 50 | </thead> |
| 51 | 51 | <tbody> |
| 52 | 52 | <?php |
| 53 | - foreach ($tickets as $ticket) {
|
|
| 54 | - $sla = $slas->sla_data($ticket['sla']); |
|
| 55 | - $user = $users->userdata($ticket['assignee']); |
|
| 56 | - echo '<tr><td><a href=ticketedit.php?id='.$ticket['id'].'>'.$ticket['ticketnumber'].'</a></td>'. |
|
| 57 | - '<td>'.$sla['namasla'].'</td>'. |
|
| 58 | - '<td>'.date('d-M-Y', $ticket['reporteddate']).'</td>'.
|
|
| 59 | - '<td>'.$ticket['reportedby'].'</td>'. |
|
| 60 | - '<td>'.$ticket['problemsummary'].'</td>'. |
|
| 61 | - '<td>'.$ticket['ticketstatus'].'</td>'. |
|
| 62 | - '<td>'.$user['fullname'].'</td></tr>'; |
|
| 63 | - } |
|
| 64 | - ?> |
|
| 53 | + foreach ($tickets as $ticket) {
|
|
| 54 | + $sla = $slas->sla_data($ticket['sla']); |
|
| 55 | + $user = $users->userdata($ticket['assignee']); |
|
| 56 | + echo '<tr><td><a href=ticketedit.php?id='.$ticket['id'].'>'.$ticket['ticketnumber'].'</a></td>'. |
|
| 57 | + '<td>'.$sla['namasla'].'</td>'. |
|
| 58 | + '<td>'.date('d-M-Y', $ticket['reporteddate']).'</td>'.
|
|
| 59 | + '<td>'.$ticket['reportedby'].'</td>'. |
|
| 60 | + '<td>'.$ticket['problemsummary'].'</td>'. |
|
| 61 | + '<td>'.$ticket['ticketstatus'].'</td>'. |
|
| 62 | + '<td>'.$user['fullname'].'</td></tr>'; |
|
| 63 | + } |
|
| 64 | + ?> |
|
| 65 | 65 | </tbody> |
| 66 | 66 | </table> |
| 67 | 67 | <p> </p> |
@@ -3,7 +3,7 @@ |
||
| 3 | 3 | $general->logged_out_protect(); |
| 4 | 4 | $user = $users->userdata($_SESSION['loginid']); |
| 5 | 5 | if ($user['level'] != 'Admin') { |
| 6 | - exit("You don't have permission to access this page!"); |
|
| 6 | + exit("You don't have permission to access this page!"); |
|
| 7 | 7 | } |
| 8 | 8 | $logs = $users->get_users_log(); |
| 9 | 9 | ?> |
@@ -3,12 +3,12 @@ discard block |
||
| 3 | 3 | $general->logged_out_protect(); |
| 4 | 4 | $user = $users->userdata($_SESSION['loginid']); |
| 5 | 5 | if ($user['level'] == 'Admin' || $user['level'] == 'Manager') { |
| 6 | - $akses = true; |
|
| 6 | + $akses = true; |
|
| 7 | 7 | } else { |
| 8 | - $akses = false; |
|
| 8 | + $akses = false; |
|
| 9 | 9 | } |
| 10 | 10 | if ($akses = false) { |
| 11 | - exit("You don't have permission to access this page!"); |
|
| 11 | + exit("You don't have permission to access this page!"); |
|
| 12 | 12 | } |
| 13 | 13 | $ticket_list = $tickets->get_tickets(); |
| 14 | 14 | $tickets_count = count($ticket_list); |
@@ -180,14 +180,14 @@ discard block |
||
| 180 | 180 | </thead> |
| 181 | 181 | <tbody> |
| 182 | 182 | <?php foreach ($ticket_list as $ticket) : |
| 183 | - $sla = $slas->sla_data($ticket['sla']); |
|
| 184 | - $documenteddate = $ticket['documenteddate']; |
|
| 185 | - $resolutiontime = $sla['resolutiontime']; |
|
| 186 | - $slawarning = $sla['slawarning']; |
|
| 187 | - $slagoaltime = strtotime("+$resolutiontime hours", $documenteddate); |
|
| 188 | - $slawarningtime = strtotime("+$slawarning hours", $documenteddate); |
|
| 189 | - $user = $users->userdata($ticket['assignee']); |
|
| 190 | - ?> |
|
| 183 | + $sla = $slas->sla_data($ticket['sla']); |
|
| 184 | + $documenteddate = $ticket['documenteddate']; |
|
| 185 | + $resolutiontime = $sla['resolutiontime']; |
|
| 186 | + $slawarning = $sla['slawarning']; |
|
| 187 | + $slagoaltime = strtotime("+$resolutiontime hours", $documenteddate); |
|
| 188 | + $slawarningtime = strtotime("+$slawarning hours", $documenteddate); |
|
| 189 | + $user = $users->userdata($ticket['assignee']); |
|
| 190 | + ?> |
|
| 191 | 191 | <tr> |
| 192 | 192 | <td> |
| 193 | 193 | <?php echo $ticket['ticketnumber'];?> |
@@ -6,58 +6,58 @@ 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 = $_POST['reporteddate']; |
|
| 15 | - $reportedmonth = $_POST['reportedmonth']; |
|
| 16 | - $reportedyear = $_POST['reportedyear']; |
|
| 17 | - $datetimeStr = $reportedyear.'-'.$reportedmonth.'-'.$reporteddate; |
|
| 18 | - $reporteddate = strtotime($datetimeStr); |
|
| 13 | + $sla = $_POST['sla']; |
|
| 14 | + $reporteddate = $_POST['reporteddate']; |
|
| 15 | + $reportedmonth = $_POST['reportedmonth']; |
|
| 16 | + $reportedyear = $_POST['reportedyear']; |
|
| 17 | + $datetimeStr = $reportedyear.'-'.$reportedmonth.'-'.$reporteddate; |
|
| 18 | + $reporteddate = strtotime($datetimeStr); |
|
| 19 | 19 | |
| 20 | - $reportedby = $_POST['reportedby']; |
|
| 21 | - $telp = $_POST['telp']; |
|
| 22 | - $email = $_POST['email']; |
|
| 23 | - $problemsummary = $_POST['problemsummary']; |
|
| 24 | - $problemdetail = $_POST['problemdetail']; |
|
| 25 | - $assignee = $_POST['idassignee']; |
|
| 26 | - $ticketstatus = $_POST['ticketstatus']; |
|
| 27 | - $resolution = $_POST['resolution']; |
|
| 28 | - $comment = $_POST['comment']; |
|
| 29 | - $processby = $_POST['processby']; |
|
| 30 | - $processdate = $_POST['processdate']; |
|
| 31 | - $pendingby = $_POST['pendingby']; |
|
| 32 | - $pendingdate = $_POST['pendingdate']; |
|
| 33 | - $resolvedby = $_POST['resolvedby']; |
|
| 34 | - $resolveddate = $_POST['resolveddate']; |
|
| 35 | - $closedby = $_POST['closedby']; |
|
| 36 | - $closeddate = $_POST['closeddate']; |
|
| 20 | + $reportedby = $_POST['reportedby']; |
|
| 21 | + $telp = $_POST['telp']; |
|
| 22 | + $email = $_POST['email']; |
|
| 23 | + $problemsummary = $_POST['problemsummary']; |
|
| 24 | + $problemdetail = $_POST['problemdetail']; |
|
| 25 | + $assignee = $_POST['idassignee']; |
|
| 26 | + $ticketstatus = $_POST['ticketstatus']; |
|
| 27 | + $resolution = $_POST['resolution']; |
|
| 28 | + $comment = $_POST['comment']; |
|
| 29 | + $processby = $_POST['processby']; |
|
| 30 | + $processdate = $_POST['processdate']; |
|
| 31 | + $pendingby = $_POST['pendingby']; |
|
| 32 | + $pendingdate = $_POST['pendingdate']; |
|
| 33 | + $resolvedby = $_POST['resolvedby']; |
|
| 34 | + $resolveddate = $_POST['resolveddate']; |
|
| 35 | + $closedby = $_POST['closedby']; |
|
| 36 | + $closeddate = $_POST['closeddate']; |
|
| 37 | 37 | $changes = 'Re-assigned the ticket.'; |
| 38 | 38 | if ($ticketstatus == 'Process') {
|
| 39 | 39 | $processby = $user['username']; |
| 40 | 40 | $processdate = strtotime(now); |
| 41 | 41 | $changes = 'Change Status to Process'; |
| 42 | 42 | } |
| 43 | - if ($ticketstatus == 'Pending') {
|
|
| 44 | - $pendingby = $user['username']; |
|
| 45 | - $pendingdate = strtotime(now); |
|
| 46 | - $changes = 'Change Status to Pending.'; |
|
| 47 | - } |
|
| 48 | - if ($ticketstatus == 'Resolved') {
|
|
| 49 | - $resolvedby = $user['username']; |
|
| 50 | - $resolveddate = strtotime(now); |
|
| 51 | - $changes = 'Change Status to Resolved.'; |
|
| 52 | - } |
|
| 53 | - if ($ticketstatus == 'Closed') {
|
|
| 54 | - $closedby = $user['username']; |
|
| 55 | - $closeddate = strtotime(now); |
|
| 56 | - $changes = 'Change Status to Closed.'; |
|
| 57 | - } |
|
| 58 | - $tickets->update_ticket($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate, $processby, $processdate, $comment); |
|
| 59 | - $tickets->log_tickets($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate, $changes, $changeby, $processby, $processdate, $comment); |
|
| 60 | - header('Location: ticketlistuser.php');
|
|
| 43 | + if ($ticketstatus == 'Pending') {
|
|
| 44 | + $pendingby = $user['username']; |
|
| 45 | + $pendingdate = strtotime(now); |
|
| 46 | + $changes = 'Change Status to Pending.'; |
|
| 47 | + } |
|
| 48 | + if ($ticketstatus == 'Resolved') {
|
|
| 49 | + $resolvedby = $user['username']; |
|
| 50 | + $resolveddate = strtotime(now); |
|
| 51 | + $changes = 'Change Status to Resolved.'; |
|
| 52 | + } |
|
| 53 | + if ($ticketstatus == 'Closed') {
|
|
| 54 | + $closedby = $user['username']; |
|
| 55 | + $closeddate = strtotime(now); |
|
| 56 | + $changes = 'Change Status to Closed.'; |
|
| 57 | + } |
|
| 58 | + $tickets->update_ticket($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate, $processby, $processdate, $comment); |
|
| 59 | + $tickets->log_tickets($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate, $changes, $changeby, $processby, $processdate, $comment); |
|
| 60 | + header('Location: ticketlistuser.php');
|
|
| 61 | 61 | } |
| 62 | 62 | ?> |
| 63 | 63 | <!DOCTYPE HTML> |
@@ -146,8 +146,8 @@ discard block |
||
| 146 | 146 | <td> <input type="hidden" name="oldticketstatus" value="<?php echo $ticket['ticketstatus']; ?>"> |
| 147 | 147 | <select name="ticketstatus"> |
| 148 | 148 | <?php |
| 149 | - echo '<option value='.$ticket['ticketstatus'].' selected="selected">'.$ticket['ticketstatus'].'</option>'; |
|
| 150 | - ?> |
|
| 149 | + echo '<option value='.$ticket['ticketstatus'].' selected="selected">'.$ticket['ticketstatus'].'</option>'; |
|
| 150 | + ?> |
|
| 151 | 151 | <option value="Assigned"> Assigned </option> |
| 152 | 152 | <option value="Resolved"> Resolved </option> |
| 153 | 153 | <option value="Pending"> Pending </option> |
@@ -189,14 +189,14 @@ discard block |
||
| 189 | 189 | <table class="formtable"> |
| 190 | 190 | <tr bgcolor="#e0e0e0" ><td width="150">Updated On</td><td width="150">Updated By</td><td>Description</td></tr> |
| 191 | 191 | <?php |
| 192 | - $list_log_tickets = $tickets->get_audit_trail($id); |
|
| 193 | - foreach ($list_log_tickets as $log_ticket) {
|
|
| 194 | - $changed_by = $users->userdata($log_ticket['changeby']); |
|
| 195 | - echo '<tr><td>'.date('d-M-Y H:i:s', $log_ticket['changedate']).'</td>'.
|
|
| 196 | - '<td>'.$changed_by['fullname'].'</td>'. |
|
| 197 | - '<td>'.$log_ticket['changes'].'</td></tr>'; |
|
| 198 | - } |
|
| 199 | - ?> |
|
| 192 | + $list_log_tickets = $tickets->get_audit_trail($id); |
|
| 193 | + foreach ($list_log_tickets as $log_ticket) {
|
|
| 194 | + $changed_by = $users->userdata($log_ticket['changeby']); |
|
| 195 | + echo '<tr><td>'.date('d-M-Y H:i:s', $log_ticket['changedate']).'</td>'.
|
|
| 196 | + '<td>'.$changed_by['fullname'].'</td>'. |
|
| 197 | + '<td>'.$log_ticket['changes'].'</td></tr>'; |
|
| 198 | + } |
|
| 199 | + ?> |
|
| 200 | 200 | </table> |
| 201 | 201 | </fieldset> |
| 202 | 202 | <br/><br/> |
@@ -6,58 +6,58 @@ 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 | - $comment = $_POST['comment']; |
|
| 25 | - $processby = $_POST['processby']; |
|
| 26 | - $processdate = $_POST['processdate']; |
|
| 27 | - $pendingby = $_POST['pendingby']; |
|
| 28 | - $pendingdate = $_POST['pendingdate']; |
|
| 29 | - $resolvedby = $_POST['resolvedby']; |
|
| 30 | - $resolveddate = $_POST['resolveddate']; |
|
| 31 | - $closedby = $_POST['closedby']; |
|
| 32 | - $closeddate = $_POST['closeddate']; |
|
| 33 | - $changes = 'Re-assigned the ticket.'; |
|
| 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 | + $comment = $_POST['comment']; |
|
| 25 | + $processby = $_POST['processby']; |
|
| 26 | + $processdate = $_POST['processdate']; |
|
| 27 | + $pendingby = $_POST['pendingby']; |
|
| 28 | + $pendingdate = $_POST['pendingdate']; |
|
| 29 | + $resolvedby = $_POST['resolvedby']; |
|
| 30 | + $resolveddate = $_POST['resolveddate']; |
|
| 31 | + $closedby = $_POST['closedby']; |
|
| 32 | + $closeddate = $_POST['closeddate']; |
|
| 33 | + $changes = 'Re-assigned the ticket.'; |
|
| 34 | 34 | if ($ticketstatus == 'Process') {
|
| 35 | 35 | $processby = $user['username']; |
| 36 | 36 | $processdate = strtotime(now); |
| 37 | 37 | $changes = 'Change Status to Process'; |
| 38 | 38 | } |
| 39 | 39 | if ($ticketstatus == 'Pending') {
|
| 40 | - $pendingby = $user['username']; |
|
| 41 | - $pendingdate = strtotime(now); |
|
| 42 | - $changes = 'Change Status to Pending.'; |
|
| 43 | - } |
|
| 44 | - if ($ticketstatus == 'Resolved') {
|
|
| 45 | - $resolvedby = $user['username']; |
|
| 46 | - $resolveddate = strtotime(now); |
|
| 47 | - $changes = 'Change Status to Resolved.'; |
|
| 48 | - } |
|
| 49 | - if ($ticketstatus == 'Closed') {
|
|
| 50 | - $closedby = $user['username']; |
|
| 51 | - $closeddate = strtotime(now); |
|
| 52 | - $changes = 'Change Status to Closed.'; |
|
| 53 | - } |
|
| 54 | - $tickets->update_ticket($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate, $processby, $processdate, $comment); |
|
| 55 | - $tickets->log_tickets($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate, $changes, $changeby, $processby, $processdate, $comment); |
|
| 56 | - if ($user['level'] == 'Admin') {
|
|
| 57 | - header('Location: ticketlist.php');
|
|
| 58 | - } else {
|
|
| 59 | - header('Location: myticketbyassignee.php');
|
|
| 60 | - } |
|
| 40 | + $pendingby = $user['username']; |
|
| 41 | + $pendingdate = strtotime(now); |
|
| 42 | + $changes = 'Change Status to Pending.'; |
|
| 43 | + } |
|
| 44 | + if ($ticketstatus == 'Resolved') {
|
|
| 45 | + $resolvedby = $user['username']; |
|
| 46 | + $resolveddate = strtotime(now); |
|
| 47 | + $changes = 'Change Status to Resolved.'; |
|
| 48 | + } |
|
| 49 | + if ($ticketstatus == 'Closed') {
|
|
| 50 | + $closedby = $user['username']; |
|
| 51 | + $closeddate = strtotime(now); |
|
| 52 | + $changes = 'Change Status to Closed.'; |
|
| 53 | + } |
|
| 54 | + $tickets->update_ticket($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate, $processby, $processdate, $comment); |
|
| 55 | + $tickets->log_tickets($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate, $changes, $changeby, $processby, $processdate, $comment); |
|
| 56 | + if ($user['level'] == 'Admin') {
|
|
| 57 | + header('Location: ticketlist.php');
|
|
| 58 | + } else {
|
|
| 59 | + header('Location: myticketbyassignee.php');
|
|
| 60 | + } |
|
| 61 | 61 | } |
| 62 | 62 | ?> |
| 63 | 63 | <!DOCTYPE HTML> |
@@ -142,13 +142,13 @@ discard block |
||
| 142 | 142 | <td> Urgency (SLA)*</td><td> : </td> |
| 143 | 143 | <td><select name="sla"> |
| 144 | 144 | <?php |
| 145 | - $sladata = $slas->sla_data($ticket['sla']); |
|
| 146 | - echo '<option value="'.$ticket['sla'].'" selected="selected">'.$sladata['namasla'].'</option>'; |
|
| 147 | - $sla = $slas->get_sla(); |
|
| 148 | - foreach ($sla as $slaval) {
|
|
| 149 | - echo '<option value="'.$slaval['slaid'].'">'.$slaval['namasla'].'</option>'; |
|
| 150 | - } |
|
| 151 | - ?> |
|
| 145 | + $sladata = $slas->sla_data($ticket['sla']); |
|
| 146 | + echo '<option value="'.$ticket['sla'].'" selected="selected">'.$sladata['namasla'].'</option>'; |
|
| 147 | + $sla = $slas->get_sla(); |
|
| 148 | + foreach ($sla as $slaval) {
|
|
| 149 | + echo '<option value="'.$slaval['slaid'].'">'.$slaval['namasla'].'</option>'; |
|
| 150 | + } |
|
| 151 | + ?> |
|
| 152 | 152 | </select> |
| 153 | 153 | </td> |
| 154 | 154 | </tr> |
@@ -156,10 +156,10 @@ discard block |
||
| 156 | 156 | <td> Type</td><td> : </td> |
| 157 | 157 | <td> |
| 158 | 158 | <?php |
| 159 | - //$pro = $slas->get_sla(); |
|
| 160 | - echo $ticket['pro']; |
|
| 159 | + //$pro = $slas->get_sla(); |
|
| 160 | + echo $ticket['pro']; |
|
| 161 | 161 | |
| 162 | - ?> |
|
| 162 | + ?> |
|
| 163 | 163 | |
| 164 | 164 | </td> |
| 165 | 165 | </tr> |
@@ -179,13 +179,13 @@ discard block |
||
| 179 | 179 | <td width="120"> Assign to* </td><td> : </td> |
| 180 | 180 | <td> <select name="idassignee"> |
| 181 | 181 | <?php |
| 182 | - $userassignee = $users->userdata($ticket['assignee']); |
|
| 183 | - echo '<option value='.$ticket['assignee'].' selected="selected">'.$userassignee['fullname'].'</option>'; |
|
| 184 | - $listusers = $users->get_users(); |
|
| 185 | - foreach ($listusers as $user) {
|
|
| 186 | - echo '<option value='.$user['id'].'>'.$user['fullname'].'</option>'; |
|
| 187 | - } |
|
| 188 | - ?> |
|
| 182 | + $userassignee = $users->userdata($ticket['assignee']); |
|
| 183 | + echo '<option value='.$ticket['assignee'].' selected="selected">'.$userassignee['fullname'].'</option>'; |
|
| 184 | + $listusers = $users->get_users(); |
|
| 185 | + foreach ($listusers as $user) {
|
|
| 186 | + echo '<option value='.$user['id'].'>'.$user['fullname'].'</option>'; |
|
| 187 | + } |
|
| 188 | + ?> |
|
| 189 | 189 | </select> </td> |
| 190 | 190 | </tr> |
| 191 | 191 | <tr> |
@@ -234,14 +234,14 @@ discard block |
||
| 234 | 234 | <table class="formtable"> |
| 235 | 235 | <tr bgcolor="#e0e0e0" ><td width="150">Updated On</td><td width="150">Updated By</td><td>Description</td></tr> |
| 236 | 236 | <?php |
| 237 | - $list_log_tickets = $tickets->get_audit_trail($id); |
|
| 238 | - foreach ($list_log_tickets as $log_ticket) {
|
|
| 239 | - $changed_by = $users->userdata($log_ticket['changeby']); |
|
| 240 | - echo '<tr><td>'.date('d-M-Y H:i:s', $log_ticket['changedate']).'</td>'.
|
|
| 241 | - '<td>'.$changed_by['fullname'].'</td>'. |
|
| 242 | - '<td>'.$log_ticket['changes'].'</td></tr>'; |
|
| 243 | - } |
|
| 244 | - ?> |
|
| 237 | + $list_log_tickets = $tickets->get_audit_trail($id); |
|
| 238 | + foreach ($list_log_tickets as $log_ticket) {
|
|
| 239 | + $changed_by = $users->userdata($log_ticket['changeby']); |
|
| 240 | + echo '<tr><td>'.date('d-M-Y H:i:s', $log_ticket['changedate']).'</td>'.
|
|
| 241 | + '<td>'.$changed_by['fullname'].'</td>'. |
|
| 242 | + '<td>'.$log_ticket['changes'].'</td></tr>'; |
|
| 243 | + } |
|
| 244 | + ?> |
|
| 245 | 245 | </table> |
| 246 | 246 | </fieldset> |
| 247 | 247 | <br/><br/> |