aepnat /
simhelpdesk
@@ -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> |
@@ -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> |
@@ -186,13 +186,13 @@ discard block |
||
| 186 | 186 | <td width="120"> Assign to* </td><td> : </td> |
| 187 | 187 | <td> <select name="idassignee"> |
| 188 | 188 | <?php |
| 189 | - $userassignee = $users->userdata($ticket['assignee']); |
|
| 190 | - echo '<option value='.$ticket['assignee'].' selected="selected">'.$userassignee['fullname'].'</option>'; |
|
| 191 | - $listusers = $users->get_users(); |
|
| 192 | - foreach ($listusers as $user) {
|
|
| 193 | - echo '<option value='.$user['id'].'>'.$user['fullname'].'</option>'; |
|
| 194 | - } |
|
| 195 | - ?> |
|
| 189 | + $userassignee = $users->userdata($ticket['assignee']); |
|
| 190 | + echo '<option value='.$ticket['assignee'].' selected="selected">'.$userassignee['fullname'].'</option>'; |
|
| 191 | + $listusers = $users->get_users(); |
|
| 192 | + foreach ($listusers as $user) {
|
|
| 193 | + echo '<option value='.$user['id'].'>'.$user['fullname'].'</option>'; |
|
| 194 | + } |
|
| 195 | + ?> |
|
| 196 | 196 | </select> </td> |
| 197 | 197 | </tr> |
| 198 | 198 | <tr> |
@@ -200,8 +200,8 @@ discard block |
||
| 200 | 200 | <td> <input type="hidden" name="oldticketstatus" value="<?php echo $ticket['ticketstatus']; ?>"> |
| 201 | 201 | <select name="ticketstatus"> |
| 202 | 202 | <?php |
| 203 | - echo '<option value='.$ticket['ticketstatus'].' selected="selected">'.$ticket['ticketstatus'].'</option>'; |
|
| 204 | - ?> |
|
| 203 | + echo '<option value='.$ticket['ticketstatus'].' selected="selected">'.$ticket['ticketstatus'].'</option>'; |
|
| 204 | + ?> |
|
| 205 | 205 | <option value="Assigned"> Assigned </option> |
| 206 | 206 | <option value="Resolved"> Resolved </option> |
| 207 | 207 | <option value="Pending"> Pending </option> |
@@ -239,14 +239,14 @@ discard block |
||
| 239 | 239 | <table class="formtable"> |
| 240 | 240 | <tr bgcolor="#e0e0e0" ><td width="150">Updated On</td><td width="150">Updated By</td><td>Description</td></tr> |
| 241 | 241 | <?php |
| 242 | - $list_log_tickets = $tickets->get_audit_trail($id); |
|
| 243 | - foreach ($list_log_tickets as $log_ticket) {
|
|
| 244 | - $changed_by = $users->userdata($log_ticket['changeby']); |
|
| 245 | - echo '<tr><td>'.date('d-M-Y H:i:s', $log_ticket['changedate']).'</td>'.
|
|
| 246 | - '<td>'.$changed_by['fullname'].'</td>'. |
|
| 247 | - '<td>'.$log_ticket['changes'].'</td></tr>'; |
|
| 248 | - } |
|
| 249 | - ?> |
|
| 242 | + $list_log_tickets = $tickets->get_audit_trail($id); |
|
| 243 | + foreach ($list_log_tickets as $log_ticket) {
|
|
| 244 | + $changed_by = $users->userdata($log_ticket['changeby']); |
|
| 245 | + echo '<tr><td>'.date('d-M-Y H:i:s', $log_ticket['changedate']).'</td>'.
|
|
| 246 | + '<td>'.$changed_by['fullname'].'</td>'. |
|
| 247 | + '<td>'.$log_ticket['changes'].'</td></tr>'; |
|
| 248 | + } |
|
| 249 | + ?> |
|
| 250 | 250 | </table> |
| 251 | 251 | </fieldset> |
| 252 | 252 | <br/><br/> |
@@ -47,7 +47,7 @@ |
||
| 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 | } |
@@ -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> |
