aepnat /
simhelpdesk
@@ -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> |
@@ -4,12 +4,12 @@ discard block |
||
| 4 | 4 | $general->logged_out_protect(); |
| 5 | 5 | $user = $users->userdata($_SESSION['loginid']); |
| 6 | 6 | if ($user['level'] == 'Admin' || $user['level'] == 'Manager') {
|
| 7 | - $akses = true; |
|
| 7 | + $akses = true; |
|
| 8 | 8 | } else {
|
| 9 | - $akses = false; |
|
| 9 | + $akses = false; |
|
| 10 | 10 | } |
| 11 | 11 | if ($akses = false) {
|
| 12 | - exit("You don't have permission to access this page!");
|
|
| 12 | + exit("You don't have permission to access this page!");
|
|
| 13 | 13 | } |
| 14 | 14 | $tickets = $tickets->get_opened_tickets(); |
| 15 | 15 | $tickets_count = count($tickets); |
@@ -63,34 +63,34 @@ discard block |
||
| 63 | 63 | </thead> |
| 64 | 64 | <tbody> |
| 65 | 65 | <?php |
| 66 | - $currenttime = time(); |
|
| 67 | - foreach ($tickets as $ticket) {
|
|
| 68 | - $sla = $slas->sla_data($ticket['sla']); |
|
| 69 | - $documenteddate = $ticket['documenteddate']; |
|
| 70 | - $resolutiontime = $sla['resolutiontime']; |
|
| 71 | - $slawarning = $sla['slawarning']; |
|
| 72 | - $slagoaltime = strtotime("+$resolutiontime hours", $documenteddate);
|
|
| 73 | - $slawarningtime = strtotime("+$slawarning hours", $documenteddate);
|
|
| 74 | - if ($currenttime > $slagoaltime) {
|
|
| 75 | - $slabgcolor = '#FF0000'; |
|
| 76 | - $slatxtcolor = '#ffffff'; |
|
| 77 | - } elseif ($currenttime >= $slawarningtime) {
|
|
| 78 | - $slabgcolor = '#FFFF00'; |
|
| 79 | - $slatxtcolor = '#000000'; |
|
| 80 | - } else {
|
|
| 81 | - $slabgcolor = '#00FF00'; |
|
| 82 | - $slatxtcolor = '#000000'; |
|
| 83 | - } |
|
| 84 | - $user = $users->userdata($ticket['assignee']); |
|
| 85 | - echo '<tr><td><a href=ticketedituser.php?id='.$ticket['id'].'>'.$ticket['ticketnumber'].'</a></td>'. |
|
| 86 | - '<td style="background-color:'.$slabgcolor.';color:'.$slatxtcolor.';">'.$sla['namasla'].'</td>'. |
|
| 87 | - '<td>'.date('d-M-Y H:i', $ticket['reporteddate']).'</td>'.
|
|
| 88 | - '<td>'.$ticket['reportedby'].'</td>'. |
|
| 89 | - '<td>'.$ticket['problemsummary'].'</td>'. |
|
| 90 | - '<td>'.$ticket['ticketstatus'].'</td>'. |
|
| 91 | - '<td>'.$user['fullname'].'</td></tr>'; |
|
| 92 | - } |
|
| 93 | - ?> |
|
| 66 | + $currenttime = time(); |
|
| 67 | + foreach ($tickets as $ticket) {
|
|
| 68 | + $sla = $slas->sla_data($ticket['sla']); |
|
| 69 | + $documenteddate = $ticket['documenteddate']; |
|
| 70 | + $resolutiontime = $sla['resolutiontime']; |
|
| 71 | + $slawarning = $sla['slawarning']; |
|
| 72 | + $slagoaltime = strtotime("+$resolutiontime hours", $documenteddate);
|
|
| 73 | + $slawarningtime = strtotime("+$slawarning hours", $documenteddate);
|
|
| 74 | + if ($currenttime > $slagoaltime) {
|
|
| 75 | + $slabgcolor = '#FF0000'; |
|
| 76 | + $slatxtcolor = '#ffffff'; |
|
| 77 | + } elseif ($currenttime >= $slawarningtime) {
|
|
| 78 | + $slabgcolor = '#FFFF00'; |
|
| 79 | + $slatxtcolor = '#000000'; |
|
| 80 | + } else {
|
|
| 81 | + $slabgcolor = '#00FF00'; |
|
| 82 | + $slatxtcolor = '#000000'; |
|
| 83 | + } |
|
| 84 | + $user = $users->userdata($ticket['assignee']); |
|
| 85 | + echo '<tr><td><a href=ticketedituser.php?id='.$ticket['id'].'>'.$ticket['ticketnumber'].'</a></td>'. |
|
| 86 | + '<td style="background-color:'.$slabgcolor.';color:'.$slatxtcolor.';">'.$sla['namasla'].'</td>'. |
|
| 87 | + '<td>'.date('d-M-Y H:i', $ticket['reporteddate']).'</td>'.
|
|
| 88 | + '<td>'.$ticket['reportedby'].'</td>'. |
|
| 89 | + '<td>'.$ticket['problemsummary'].'</td>'. |
|
| 90 | + '<td>'.$ticket['ticketstatus'].'</td>'. |
|
| 91 | + '<td>'.$user['fullname'].'</td></tr>'; |
|
| 92 | + } |
|
| 93 | + ?> |
|
| 94 | 94 | </tbody> |
| 95 | 95 | </table> |
| 96 | 96 | </body> |
@@ -5,7 +5,7 @@ discard block |
||
| 5 | 5 | $user = $users->userdata($_SESSION['loginid']); |
| 6 | 6 | if ($user['level'] == 'Admin' || $user['level'] == 'Manager') {
|
| 7 | 7 | $akses = true; |
| 8 | -} else {
|
|
| 8 | +}else {
|
|
| 9 | 9 | $akses = false; |
| 10 | 10 | } |
| 11 | 11 | if ($akses = false) {
|
@@ -77,7 +77,7 @@ discard block |
||
| 77 | 77 | } elseif ($currenttime >= $slawarningtime) {
|
| 78 | 78 | $slabgcolor = '#FFFF00'; |
| 79 | 79 | $slatxtcolor = '#000000'; |
| 80 | - } else {
|
|
| 80 | + }else {
|
|
| 81 | 81 | $slabgcolor = '#00FF00'; |
| 82 | 82 | $slatxtcolor = '#000000'; |
| 83 | 83 | } |
@@ -8,10 +8,10 @@ |
||
| 8 | 8 | $tickets = $tickets->get_tickets(); |
| 9 | 9 | $json = '['; |
| 10 | 10 | foreach ($tickets as $ticket) { |
| 11 | - $userassignee = $users->userdata($ticket['assignee']); |
|
| 12 | - $json .= '{"Product": "",'. |
|
| 13 | - '"Company": "",'. |
|
| 14 | - '"Assignee": "'.$userassignee['fullname'].'",'. |
|
| 15 | - '"Status": "'.$ticket['ticketstatus'].'"},'; |
|
| 11 | + $userassignee = $users->userdata($ticket['assignee']); |
|
| 12 | + $json .= '{"Product": "",'. |
|
| 13 | + '"Company": "",'. |
|
| 14 | + '"Assignee": "'.$userassignee['fullname'].'",'. |
|
| 15 | + '"Status": "'.$ticket['ticketstatus'].'"},'; |
|
| 16 | 16 | } |
| 17 | 17 | echo substr($json, 0, -1).']'; |
@@ -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> |
@@ -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> |
@@ -6,33 +6,33 @@ discard block |
||
| 6 | 6 | $documentedby = $_SESSION['loginid']; |
| 7 | 7 | $user = $users->userdata($_SESSION['loginid']); |
| 8 | 8 | if (isset($_POST['submit'])) {
|
| 9 | - $lastticket = $tickets->get_last_ticket(); |
|
| 10 | - $id = $lastticket['id'] + 1; |
|
| 11 | - $ticketnumber = $id.'/SR/'.date('M').'/'.date('Y'); //format nomor tiket
|
|
| 12 | - $sla = $_POST['sla']; |
|
| 13 | - $reporteddate = strtotime($_POST['reporteddate']); |
|
| 14 | - $reportedby = $_POST['reportedby']; |
|
| 15 | - $telp = $_POST['telp']; |
|
| 16 | - $email = $_POST['email']; |
|
| 17 | - $problemsummary = $_POST['problemsummary']; |
|
| 18 | - $problemdetail = $_POST['problemdetail']; |
|
| 19 | - $ticketstatus = 'Assigned'; //ketika pertama kali dibuat, status="Assigned" ke salah satu teknisi |
|
| 20 | - $assignee = $_POST['idassignee']; |
|
| 21 | - $pro = $_POST['pro']; |
|
| 22 | - $changes = 'Create New Ticket'; |
|
| 23 | - $datasla = $slas->sla_data($sla); |
|
| 24 | - $resolutiontime = $datasla['resolutiontime']; |
|
| 25 | - $tickets->add_ticket($ticketnumber, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $documentedby, $pro); |
|
| 26 | - $assigneddate = ''; |
|
| 27 | - $pendingby = ''; |
|
| 28 | - $pendingdate = ''; |
|
| 29 | - $resolution = ''; |
|
| 30 | - $resolvedby = ''; |
|
| 31 | - $resolveddate = ''; |
|
| 32 | - $closedby = ''; |
|
| 33 | - $closeddate = ''; |
|
| 34 | - $tickets->log_tickets($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate, $changes, $changeby); |
|
| 35 | - header("Location: ticketread.php?id=$id");
|
|
| 9 | + $lastticket = $tickets->get_last_ticket(); |
|
| 10 | + $id = $lastticket['id'] + 1; |
|
| 11 | + $ticketnumber = $id.'/SR/'.date('M').'/'.date('Y'); //format nomor tiket
|
|
| 12 | + $sla = $_POST['sla']; |
|
| 13 | + $reporteddate = strtotime($_POST['reporteddate']); |
|
| 14 | + $reportedby = $_POST['reportedby']; |
|
| 15 | + $telp = $_POST['telp']; |
|
| 16 | + $email = $_POST['email']; |
|
| 17 | + $problemsummary = $_POST['problemsummary']; |
|
| 18 | + $problemdetail = $_POST['problemdetail']; |
|
| 19 | + $ticketstatus = 'Assigned'; //ketika pertama kali dibuat, status="Assigned" ke salah satu teknisi |
|
| 20 | + $assignee = $_POST['idassignee']; |
|
| 21 | + $pro = $_POST['pro']; |
|
| 22 | + $changes = 'Create New Ticket'; |
|
| 23 | + $datasla = $slas->sla_data($sla); |
|
| 24 | + $resolutiontime = $datasla['resolutiontime']; |
|
| 25 | + $tickets->add_ticket($ticketnumber, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $documentedby, $pro); |
|
| 26 | + $assigneddate = ''; |
|
| 27 | + $pendingby = ''; |
|
| 28 | + $pendingdate = ''; |
|
| 29 | + $resolution = ''; |
|
| 30 | + $resolvedby = ''; |
|
| 31 | + $resolveddate = ''; |
|
| 32 | + $closedby = ''; |
|
| 33 | + $closeddate = ''; |
|
| 34 | + $tickets->log_tickets($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate, $changes, $changeby); |
|
| 35 | + header("Location: ticketread.php?id=$id");
|
|
| 36 | 36 | } |
| 37 | 37 | ?> |
| 38 | 38 | <!DOCTYPE HTML> |
@@ -115,12 +115,12 @@ discard block |
||
| 115 | 115 | <td> Urgency (SLA)*</td><td> : </td> |
| 116 | 116 | <td><select name="sla"> |
| 117 | 117 | <?php |
| 118 | - $sla = $slas->get_sla(); |
|
| 119 | - echo '<option value="'.$slaval['slaid'].'" selected="selected">'.$slaval['namasla'].'</option>'; |
|
| 120 | - foreach ($sla as $slaval) {
|
|
| 121 | - echo '<option value="'.$slaval['slaid'].'">'.$slaval['namasla'].'</option>'; |
|
| 122 | - } |
|
| 123 | - ?> |
|
| 118 | + $sla = $slas->get_sla(); |
|
| 119 | + echo '<option value="'.$slaval['slaid'].'" selected="selected">'.$slaval['namasla'].'</option>'; |
|
| 120 | + foreach ($sla as $slaval) {
|
|
| 121 | + echo '<option value="'.$slaval['slaid'].'">'.$slaval['namasla'].'</option>'; |
|
| 122 | + } |
|
| 123 | + ?> |
|
| 124 | 124 | </select> |
| 125 | 125 | </td> |
| 126 | 126 | </tr> |
@@ -128,11 +128,11 @@ discard block |
||
| 128 | 128 | <td> Type</td><td> : </td> |
| 129 | 129 | <td><select name="pro"> |
| 130 | 130 | <?php |
| 131 | - //$pro = $slas->get_sla(); |
|
| 132 | - echo '<option value=""></option>'; |
|
| 133 | - echo '<option value="Hardware">Hardware</option>'; |
|
| 134 | - echo '<option value="Software">Software</option>'; |
|
| 135 | - ?> |
|
| 131 | + //$pro = $slas->get_sla(); |
|
| 132 | + echo '<option value=""></option>'; |
|
| 133 | + echo '<option value="Hardware">Hardware</option>'; |
|
| 134 | + echo '<option value="Software">Software</option>'; |
|
| 135 | + ?> |
|
| 136 | 136 | </select> |
| 137 | 137 | </td> |
| 138 | 138 | </tr> |
@@ -159,9 +159,9 @@ discard block |
||
| 159 | 159 | </form> |
| 160 | 160 | |
| 161 | 161 | <?php |
| 162 | - if (empty($errors) === false) {
|
|
| 163 | - echo '<p class=errormsg>'.implode('</p><p class=errormsg>', $errors).'</p>';
|
|
| 164 | - } |
|
| 165 | - ?> |
|
| 162 | + if (empty($errors) === false) {
|
|
| 163 | + echo '<p class=errormsg>'.implode('</p><p class=errormsg>', $errors).'</p>';
|
|
| 164 | + } |
|
| 165 | + ?> |
|
| 166 | 166 | </body> |
| 167 | 167 | </html> |
| 168 | 168 | \ No newline at end of file |
@@ -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=ticketedituser.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=ticketedituser.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,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> |
@@ -4,7 +4,7 @@ discard block |
||
| 4 | 4 | $user = $users->userdata($_SESSION['loginid']); |
| 5 | 5 | if ($user['level'] == 'Admin' || $user['level'] == 'Manager') {
|
| 6 | 6 | $akses = true; |
| 7 | -} else {
|
|
| 7 | +}else {
|
|
| 8 | 8 | $akses = false; |
| 9 | 9 | } |
| 10 | 10 | if ($akses = false) {
|
@@ -83,7 +83,7 @@ discard block |
||
| 83 | 83 | } elseif ($currenttime >= $slawarningtime) {
|
| 84 | 84 | $slabgcolor = '#FFFF00'; |
| 85 | 85 | $slatxtcolor = '#000000'; |
| 86 | - } else {
|
|
| 86 | + }else {
|
|
| 87 | 87 | $slabgcolor = '#00FF00'; |
| 88 | 88 | $slatxtcolor = '#000000'; |
| 89 | 89 | } |
@@ -3,276 +3,276 @@ discard block |
||
| 3 | 3 | date_default_timezone_set('Asia/Jakarta'); |
| 4 | 4 | class Tickets |
| 5 | 5 | { |
| 6 | - private $db; |
|
| 7 | - |
|
| 8 | - public function __construct($database) |
|
| 9 | - { |
|
| 10 | - $this->db = $database; |
|
| 11 | - } |
|
| 12 | - |
|
| 13 | - public function add_ticket($ticketnumber, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $documentedby, $pro) |
|
| 14 | - { |
|
| 15 | - $current = time(); |
|
| 16 | - $querystring = 'INSERT INTO `tickets` (`ticketnumber`,`sla`,`reporteddate`, `reportedby`, `telp`, `email`, `problemsummary`,`problemdetail`,`ticketstatus`,`assignee`,`documentedby`,`documenteddate`,`pro`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'; |
|
| 17 | - $query = $this->db->prepare($querystring); |
|
| 18 | - $query->bindValue(1, $ticketnumber); |
|
| 19 | - $query->bindValue(2, $sla); |
|
| 20 | - $query->bindValue(3, $reporteddate); |
|
| 21 | - $query->bindValue(4, $reportedby); |
|
| 22 | - $query->bindValue(5, $telp); |
|
| 23 | - $query->bindValue(6, $email); |
|
| 24 | - $query->bindValue(7, $problemsummary); |
|
| 25 | - $query->bindValue(8, $problemdetail); |
|
| 26 | - $query->bindValue(9, $ticketstatus); |
|
| 27 | - $query->bindValue(10, $assignee); |
|
| 28 | - $query->bindValue(11, $documentedby); |
|
| 29 | - $query->bindValue(12, $current); |
|
| 30 | - $query->bindValue(13, $pro); |
|
| 31 | - |
|
| 32 | - try { |
|
| 33 | - $query->execute(); |
|
| 34 | - } catch (PDOException $e) { |
|
| 35 | - die($e->getMessage()); |
|
| 36 | - } |
|
| 37 | - } |
|
| 38 | - |
|
| 39 | - public function update_ticket($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate) |
|
| 40 | - { |
|
| 41 | - $querystring = 'UPDATE `tickets` SET `sla` = ? , `reporteddate` = ? , `reportedby` = ? , `telp` = ? ,`email` = ? , `problemsummary` = ? , `problemdetail` = ? ,`ticketstatus` = ?, `assignee` = ? , `assigneddate` = ?, `pendingby` = ?,`pendingdate` = ?, `resolution` = ? ,`resolvedby` = ?,`resolveddate` = ?,`closedby` = ?,`closeddate` = ? WHERE `id` = ?'; |
|
| 42 | - $query = $this->db->prepare($querystring); |
|
| 43 | - $query->bindValue(1, $sla); |
|
| 44 | - $query->bindValue(2, $reporteddate); |
|
| 45 | - $query->bindValue(3, $reportedby); |
|
| 46 | - $query->bindValue(4, $telp); |
|
| 47 | - $query->bindValue(5, $email); |
|
| 48 | - $query->bindValue(6, $problemsummary); |
|
| 49 | - $query->bindValue(7, $problemdetail); |
|
| 50 | - $query->bindValue(8, $ticketstatus); |
|
| 51 | - $query->bindValue(9, $assignee); |
|
| 52 | - $query->bindValue(10, $assigneddate); |
|
| 53 | - $query->bindValue(11, $pendingby); |
|
| 54 | - $query->bindValue(12, $pendingdate); |
|
| 55 | - $query->bindValue(13, $resolution); |
|
| 56 | - $query->bindValue(14, $resolvedby); |
|
| 57 | - $query->bindValue(15, $resolveddate); |
|
| 58 | - $query->bindValue(16, $closedby); |
|
| 59 | - $query->bindValue(17, $closeddate); |
|
| 60 | - $query->bindValue(18, $id); |
|
| 61 | - |
|
| 62 | - try { |
|
| 63 | - $query->execute(); |
|
| 64 | - } catch (PDOException $e) { |
|
| 65 | - die($e->getMessage()); |
|
| 66 | - } |
|
| 67 | - } |
|
| 68 | - |
|
| 69 | - public function delete($id) |
|
| 70 | - { |
|
| 71 | - $sql = 'DELETE FROM `tickets` WHERE `id` = ?'; |
|
| 72 | - $query = $this->db->prepare($sql); |
|
| 73 | - $query->bindValue(1, $id); |
|
| 74 | - |
|
| 75 | - try { |
|
| 76 | - $query->execute(); |
|
| 77 | - } catch (PDOException $e) { |
|
| 78 | - die($e->getMessage()); |
|
| 79 | - } |
|
| 80 | - } |
|
| 81 | - |
|
| 82 | - public function ticket_data($id) |
|
| 83 | - { |
|
| 84 | - $query = $this->db->prepare('SELECT * FROM `tickets` WHERE `id`= ?'); |
|
| 85 | - $query->bindValue(1, $id); |
|
| 86 | - |
|
| 87 | - try { |
|
| 88 | - $query->execute(); |
|
| 89 | - |
|
| 90 | - return $query->fetch(); |
|
| 91 | - } catch (PDOException $e) { |
|
| 92 | - die($e->getMessage()); |
|
| 93 | - } |
|
| 94 | - } |
|
| 95 | - |
|
| 96 | - public function get_tickets() |
|
| 97 | - { |
|
| 98 | - $query = $this->db->prepare('SELECT * FROM `tickets` ORDER BY `ticketnumber` DESC'); |
|
| 99 | - |
|
| 100 | - try { |
|
| 101 | - $query->execute(); |
|
| 102 | - } catch (PDOException $e) { |
|
| 103 | - die($e->getMessage()); |
|
| 104 | - } |
|
| 105 | - |
|
| 106 | - return $query->fetchAll(); |
|
| 107 | - } |
|
| 108 | - |
|
| 109 | - public function get_pro() |
|
| 110 | - { |
|
| 111 | - $query = $this->db->prepare('SELECT pro FROM `tickets`'); |
|
| 112 | - |
|
| 113 | - try { |
|
| 114 | - $query->execute(); |
|
| 115 | - } catch (PDOException $e) { |
|
| 116 | - die($e->getMessage()); |
|
| 117 | - } |
|
| 118 | - |
|
| 119 | - return $query->fetchAll(); |
|
| 120 | - } |
|
| 121 | - |
|
| 122 | - public function get_opened_tickets() |
|
| 123 | - { |
|
| 124 | - $query = $this->db->prepare("SELECT * FROM `tickets` WHERE `ticketstatus` <> 'Closed' ORDER BY `ticketnumber` DESC"); |
|
| 125 | - |
|
| 126 | - try { |
|
| 127 | - $query->execute(); |
|
| 128 | - } catch (PDOException $e) { |
|
| 129 | - die($e->getMessage()); |
|
| 130 | - } |
|
| 131 | - |
|
| 132 | - return $query->fetchAll(); |
|
| 133 | - } |
|
| 134 | - |
|
| 135 | - public function get_tickets_by_requester($userid) |
|
| 136 | - { |
|
| 137 | - $query = $this->db->prepare('SELECT * FROM `tickets` WHERE `documentedby`= ? ORDER BY `ticketnumber` DESC'); |
|
| 138 | - $query->bindValue(1, $userid); |
|
| 139 | - |
|
| 140 | - try { |
|
| 141 | - $query->execute(); |
|
| 142 | - } catch (PDOException $e) { |
|
| 143 | - die($e->getMessage()); |
|
| 144 | - } |
|
| 145 | - |
|
| 146 | - return $query->fetchAll(); |
|
| 147 | - } |
|
| 148 | - |
|
| 149 | - public function get_tickets_by_assignee($userid) |
|
| 150 | - { |
|
| 151 | - $query = $this->db->prepare('SELECT * FROM `tickets` WHERE `assignee`= ? ORDER BY `ticketnumber` DESC'); |
|
| 152 | - $query->bindValue(1, $userid); |
|
| 153 | - |
|
| 154 | - try { |
|
| 155 | - $query->execute(); |
|
| 156 | - } catch (PDOException $e) { |
|
| 157 | - die($e->getMessage()); |
|
| 158 | - } |
|
| 159 | - |
|
| 160 | - return $query->fetchAll(); |
|
| 161 | - } |
|
| 162 | - |
|
| 163 | - public function get_tickets_by_resolver($username) |
|
| 164 | - { |
|
| 165 | - $query = $this->db->prepare('SELECT * FROM `tickets` WHERE `resolvedby`= ? ORDER BY `ticketnumber` DESC'); |
|
| 166 | - $query->bindValue(1, $username); |
|
| 167 | - |
|
| 168 | - try { |
|
| 169 | - $query->execute(); |
|
| 170 | - } catch (PDOException $e) { |
|
| 171 | - die($e->getMessage()); |
|
| 172 | - } |
|
| 173 | - |
|
| 174 | - return $query->fetchAll(); |
|
| 175 | - } |
|
| 176 | - |
|
| 177 | - public function get_tickets_by_resolver_not_closed($username) |
|
| 178 | - { |
|
| 179 | - $query = $this->db->prepare('SELECT * FROM `tickets` WHERE `resolvedby`=? and `ticketstatus` <> ? ORDER BY `ticketnumber` DESC'); |
|
| 180 | - $query->bindValue(1, $username); |
|
| 181 | - $query->bindValue(2, 'Closed'); |
|
| 182 | - |
|
| 183 | - try { |
|
| 184 | - $query->execute(); |
|
| 185 | - } catch (PDOException $e) { |
|
| 186 | - die($e->getMessage()); |
|
| 187 | - } |
|
| 188 | - |
|
| 189 | - return $query->fetchAll(); |
|
| 190 | - } |
|
| 191 | - |
|
| 192 | - public function get_tickets_by_status($ticketstatus) |
|
| 193 | - { |
|
| 194 | - $query = $this->db->prepare('SELECT * FROM `tickets` WHERE `ticketstatus`=? ORDER BY `ticketnumber` DESC'); |
|
| 195 | - $query->bindValue(1, $ticketstatus); |
|
| 196 | - |
|
| 197 | - try { |
|
| 198 | - $query->execute(); |
|
| 199 | - } catch (PDOException $e) { |
|
| 200 | - die($e->getMessage()); |
|
| 201 | - } |
|
| 202 | - |
|
| 203 | - return $query->fetchAll(); |
|
| 204 | - } |
|
| 205 | - |
|
| 206 | - public function search_closed_ticket($fromperiod, $toperiod) |
|
| 207 | - { |
|
| 208 | - $query = $this->db->prepare("SELECT * FROM `tickets` WHERE `documenteddate` >= ? AND `documenteddate` <= ? AND `ticketstatus` = 'Closed' ORDER BY `documenteddate` DESC"); |
|
| 209 | - $query->bindValue(1, $fromperiod); |
|
| 210 | - $query->bindValue(2, $toperiod); |
|
| 211 | - |
|
| 212 | - try { |
|
| 213 | - $query->execute(); |
|
| 214 | - } catch (PDOException $e) { |
|
| 215 | - die($e->getMessage()); |
|
| 216 | - } |
|
| 217 | - |
|
| 218 | - return $query->fetchAll(); |
|
| 219 | - } |
|
| 220 | - |
|
| 221 | - public function count_tickets_by_status() |
|
| 222 | - { |
|
| 223 | - $query = $this->db->prepare('SELECT ticketstatus, count(*) as total FROM `tickets` GROUP BY ticketstatus'); |
|
| 224 | - |
|
| 225 | - try { |
|
| 226 | - $query->execute(); |
|
| 227 | - } catch (PDOException $e) { |
|
| 228 | - die($e->getMessage()); |
|
| 229 | - } |
|
| 230 | - |
|
| 231 | - return $query->fetchAll(); |
|
| 232 | - } |
|
| 233 | - |
|
| 234 | - public function count_resolved_tickets_by_month() |
|
| 235 | - { |
|
| 236 | - $sql = "SELECT Month(FROM_UNIXTIME(`documenteddate`)) as Bulan, Count(*) as Total FROM `tickets` WHERE (`ticketstatus`='Resolved' OR `ticketstatus`='Closed') AND FROM_UNIXTIME(`documenteddate`) >= CURDATE() - INTERVAL 1 YEAR GROUP BY Month(FROM_UNIXTIME(`documenteddate`))"; |
|
| 237 | - $query = $this->db->prepare($sql); |
|
| 238 | - |
|
| 239 | - try { |
|
| 240 | - $query->execute(); |
|
| 241 | - } catch (PDOException $e) { |
|
| 242 | - die($e->getMessage()); |
|
| 243 | - } |
|
| 244 | - |
|
| 245 | - return $query->fetchAll(); |
|
| 246 | - } |
|
| 247 | - |
|
| 248 | - public function count_inprogress_tickets_by_month() |
|
| 249 | - { |
|
| 250 | - $sql = "SELECT Month(FROM_UNIXTIME(`documenteddate`)) as Bulan, Count(*) as Total FROM `tickets` WHERE (`ticketstatus`='Assigned' OR `ticketstatus`='Pending') AND FROM_UNIXTIME(`documenteddate`) >= CURDATE() - INTERVAL 1 YEAR GROUP BY Month(FROM_UNIXTIME(`documenteddate`))"; |
|
| 251 | - $query = $this->db->prepare($sql); |
|
| 252 | - |
|
| 253 | - try { |
|
| 254 | - $query->execute(); |
|
| 255 | - } catch (PDOException $e) { |
|
| 256 | - die($e->getMessage()); |
|
| 257 | - } |
|
| 258 | - |
|
| 259 | - return $query->fetchAll(); |
|
| 260 | - } |
|
| 261 | - |
|
| 262 | - public function get_last_ticket() |
|
| 263 | - { |
|
| 264 | - $query = $this->db->prepare('SELECT * FROM `tickets` ORDER BY id DESC LIMIT 1'); |
|
| 265 | - |
|
| 266 | - try { |
|
| 267 | - $query->execute(); |
|
| 268 | - |
|
| 269 | - return $query->fetch(); |
|
| 270 | - } catch (PDOException $e) { |
|
| 271 | - die($e->getMessage()); |
|
| 272 | - } |
|
| 273 | - } |
|
| 274 | - |
|
| 275 | - /* |
|
| 6 | + private $db; |
|
| 7 | + |
|
| 8 | + public function __construct($database) |
|
| 9 | + { |
|
| 10 | + $this->db = $database; |
|
| 11 | + } |
|
| 12 | + |
|
| 13 | + public function add_ticket($ticketnumber, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $documentedby, $pro) |
|
| 14 | + { |
|
| 15 | + $current = time(); |
|
| 16 | + $querystring = 'INSERT INTO `tickets` (`ticketnumber`,`sla`,`reporteddate`, `reportedby`, `telp`, `email`, `problemsummary`,`problemdetail`,`ticketstatus`,`assignee`,`documentedby`,`documenteddate`,`pro`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'; |
|
| 17 | + $query = $this->db->prepare($querystring); |
|
| 18 | + $query->bindValue(1, $ticketnumber); |
|
| 19 | + $query->bindValue(2, $sla); |
|
| 20 | + $query->bindValue(3, $reporteddate); |
|
| 21 | + $query->bindValue(4, $reportedby); |
|
| 22 | + $query->bindValue(5, $telp); |
|
| 23 | + $query->bindValue(6, $email); |
|
| 24 | + $query->bindValue(7, $problemsummary); |
|
| 25 | + $query->bindValue(8, $problemdetail); |
|
| 26 | + $query->bindValue(9, $ticketstatus); |
|
| 27 | + $query->bindValue(10, $assignee); |
|
| 28 | + $query->bindValue(11, $documentedby); |
|
| 29 | + $query->bindValue(12, $current); |
|
| 30 | + $query->bindValue(13, $pro); |
|
| 31 | + |
|
| 32 | + try { |
|
| 33 | + $query->execute(); |
|
| 34 | + } catch (PDOException $e) { |
|
| 35 | + die($e->getMessage()); |
|
| 36 | + } |
|
| 37 | + } |
|
| 38 | + |
|
| 39 | + public function update_ticket($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate) |
|
| 40 | + { |
|
| 41 | + $querystring = 'UPDATE `tickets` SET `sla` = ? , `reporteddate` = ? , `reportedby` = ? , `telp` = ? ,`email` = ? , `problemsummary` = ? , `problemdetail` = ? ,`ticketstatus` = ?, `assignee` = ? , `assigneddate` = ?, `pendingby` = ?,`pendingdate` = ?, `resolution` = ? ,`resolvedby` = ?,`resolveddate` = ?,`closedby` = ?,`closeddate` = ? WHERE `id` = ?'; |
|
| 42 | + $query = $this->db->prepare($querystring); |
|
| 43 | + $query->bindValue(1, $sla); |
|
| 44 | + $query->bindValue(2, $reporteddate); |
|
| 45 | + $query->bindValue(3, $reportedby); |
|
| 46 | + $query->bindValue(4, $telp); |
|
| 47 | + $query->bindValue(5, $email); |
|
| 48 | + $query->bindValue(6, $problemsummary); |
|
| 49 | + $query->bindValue(7, $problemdetail); |
|
| 50 | + $query->bindValue(8, $ticketstatus); |
|
| 51 | + $query->bindValue(9, $assignee); |
|
| 52 | + $query->bindValue(10, $assigneddate); |
|
| 53 | + $query->bindValue(11, $pendingby); |
|
| 54 | + $query->bindValue(12, $pendingdate); |
|
| 55 | + $query->bindValue(13, $resolution); |
|
| 56 | + $query->bindValue(14, $resolvedby); |
|
| 57 | + $query->bindValue(15, $resolveddate); |
|
| 58 | + $query->bindValue(16, $closedby); |
|
| 59 | + $query->bindValue(17, $closeddate); |
|
| 60 | + $query->bindValue(18, $id); |
|
| 61 | + |
|
| 62 | + try { |
|
| 63 | + $query->execute(); |
|
| 64 | + } catch (PDOException $e) { |
|
| 65 | + die($e->getMessage()); |
|
| 66 | + } |
|
| 67 | + } |
|
| 68 | + |
|
| 69 | + public function delete($id) |
|
| 70 | + { |
|
| 71 | + $sql = 'DELETE FROM `tickets` WHERE `id` = ?'; |
|
| 72 | + $query = $this->db->prepare($sql); |
|
| 73 | + $query->bindValue(1, $id); |
|
| 74 | + |
|
| 75 | + try { |
|
| 76 | + $query->execute(); |
|
| 77 | + } catch (PDOException $e) { |
|
| 78 | + die($e->getMessage()); |
|
| 79 | + } |
|
| 80 | + } |
|
| 81 | + |
|
| 82 | + public function ticket_data($id) |
|
| 83 | + { |
|
| 84 | + $query = $this->db->prepare('SELECT * FROM `tickets` WHERE `id`= ?'); |
|
| 85 | + $query->bindValue(1, $id); |
|
| 86 | + |
|
| 87 | + try { |
|
| 88 | + $query->execute(); |
|
| 89 | + |
|
| 90 | + return $query->fetch(); |
|
| 91 | + } catch (PDOException $e) { |
|
| 92 | + die($e->getMessage()); |
|
| 93 | + } |
|
| 94 | + } |
|
| 95 | + |
|
| 96 | + public function get_tickets() |
|
| 97 | + { |
|
| 98 | + $query = $this->db->prepare('SELECT * FROM `tickets` ORDER BY `ticketnumber` DESC'); |
|
| 99 | + |
|
| 100 | + try { |
|
| 101 | + $query->execute(); |
|
| 102 | + } catch (PDOException $e) { |
|
| 103 | + die($e->getMessage()); |
|
| 104 | + } |
|
| 105 | + |
|
| 106 | + return $query->fetchAll(); |
|
| 107 | + } |
|
| 108 | + |
|
| 109 | + public function get_pro() |
|
| 110 | + { |
|
| 111 | + $query = $this->db->prepare('SELECT pro FROM `tickets`'); |
|
| 112 | + |
|
| 113 | + try { |
|
| 114 | + $query->execute(); |
|
| 115 | + } catch (PDOException $e) { |
|
| 116 | + die($e->getMessage()); |
|
| 117 | + } |
|
| 118 | + |
|
| 119 | + return $query->fetchAll(); |
|
| 120 | + } |
|
| 121 | + |
|
| 122 | + public function get_opened_tickets() |
|
| 123 | + { |
|
| 124 | + $query = $this->db->prepare("SELECT * FROM `tickets` WHERE `ticketstatus` <> 'Closed' ORDER BY `ticketnumber` DESC"); |
|
| 125 | + |
|
| 126 | + try { |
|
| 127 | + $query->execute(); |
|
| 128 | + } catch (PDOException $e) { |
|
| 129 | + die($e->getMessage()); |
|
| 130 | + } |
|
| 131 | + |
|
| 132 | + return $query->fetchAll(); |
|
| 133 | + } |
|
| 134 | + |
|
| 135 | + public function get_tickets_by_requester($userid) |
|
| 136 | + { |
|
| 137 | + $query = $this->db->prepare('SELECT * FROM `tickets` WHERE `documentedby`= ? ORDER BY `ticketnumber` DESC'); |
|
| 138 | + $query->bindValue(1, $userid); |
|
| 139 | + |
|
| 140 | + try { |
|
| 141 | + $query->execute(); |
|
| 142 | + } catch (PDOException $e) { |
|
| 143 | + die($e->getMessage()); |
|
| 144 | + } |
|
| 145 | + |
|
| 146 | + return $query->fetchAll(); |
|
| 147 | + } |
|
| 148 | + |
|
| 149 | + public function get_tickets_by_assignee($userid) |
|
| 150 | + { |
|
| 151 | + $query = $this->db->prepare('SELECT * FROM `tickets` WHERE `assignee`= ? ORDER BY `ticketnumber` DESC'); |
|
| 152 | + $query->bindValue(1, $userid); |
|
| 153 | + |
|
| 154 | + try { |
|
| 155 | + $query->execute(); |
|
| 156 | + } catch (PDOException $e) { |
|
| 157 | + die($e->getMessage()); |
|
| 158 | + } |
|
| 159 | + |
|
| 160 | + return $query->fetchAll(); |
|
| 161 | + } |
|
| 162 | + |
|
| 163 | + public function get_tickets_by_resolver($username) |
|
| 164 | + { |
|
| 165 | + $query = $this->db->prepare('SELECT * FROM `tickets` WHERE `resolvedby`= ? ORDER BY `ticketnumber` DESC'); |
|
| 166 | + $query->bindValue(1, $username); |
|
| 167 | + |
|
| 168 | + try { |
|
| 169 | + $query->execute(); |
|
| 170 | + } catch (PDOException $e) { |
|
| 171 | + die($e->getMessage()); |
|
| 172 | + } |
|
| 173 | + |
|
| 174 | + return $query->fetchAll(); |
|
| 175 | + } |
|
| 176 | + |
|
| 177 | + public function get_tickets_by_resolver_not_closed($username) |
|
| 178 | + { |
|
| 179 | + $query = $this->db->prepare('SELECT * FROM `tickets` WHERE `resolvedby`=? and `ticketstatus` <> ? ORDER BY `ticketnumber` DESC'); |
|
| 180 | + $query->bindValue(1, $username); |
|
| 181 | + $query->bindValue(2, 'Closed'); |
|
| 182 | + |
|
| 183 | + try { |
|
| 184 | + $query->execute(); |
|
| 185 | + } catch (PDOException $e) { |
|
| 186 | + die($e->getMessage()); |
|
| 187 | + } |
|
| 188 | + |
|
| 189 | + return $query->fetchAll(); |
|
| 190 | + } |
|
| 191 | + |
|
| 192 | + public function get_tickets_by_status($ticketstatus) |
|
| 193 | + { |
|
| 194 | + $query = $this->db->prepare('SELECT * FROM `tickets` WHERE `ticketstatus`=? ORDER BY `ticketnumber` DESC'); |
|
| 195 | + $query->bindValue(1, $ticketstatus); |
|
| 196 | + |
|
| 197 | + try { |
|
| 198 | + $query->execute(); |
|
| 199 | + } catch (PDOException $e) { |
|
| 200 | + die($e->getMessage()); |
|
| 201 | + } |
|
| 202 | + |
|
| 203 | + return $query->fetchAll(); |
|
| 204 | + } |
|
| 205 | + |
|
| 206 | + public function search_closed_ticket($fromperiod, $toperiod) |
|
| 207 | + { |
|
| 208 | + $query = $this->db->prepare("SELECT * FROM `tickets` WHERE `documenteddate` >= ? AND `documenteddate` <= ? AND `ticketstatus` = 'Closed' ORDER BY `documenteddate` DESC"); |
|
| 209 | + $query->bindValue(1, $fromperiod); |
|
| 210 | + $query->bindValue(2, $toperiod); |
|
| 211 | + |
|
| 212 | + try { |
|
| 213 | + $query->execute(); |
|
| 214 | + } catch (PDOException $e) { |
|
| 215 | + die($e->getMessage()); |
|
| 216 | + } |
|
| 217 | + |
|
| 218 | + return $query->fetchAll(); |
|
| 219 | + } |
|
| 220 | + |
|
| 221 | + public function count_tickets_by_status() |
|
| 222 | + { |
|
| 223 | + $query = $this->db->prepare('SELECT ticketstatus, count(*) as total FROM `tickets` GROUP BY ticketstatus'); |
|
| 224 | + |
|
| 225 | + try { |
|
| 226 | + $query->execute(); |
|
| 227 | + } catch (PDOException $e) { |
|
| 228 | + die($e->getMessage()); |
|
| 229 | + } |
|
| 230 | + |
|
| 231 | + return $query->fetchAll(); |
|
| 232 | + } |
|
| 233 | + |
|
| 234 | + public function count_resolved_tickets_by_month() |
|
| 235 | + { |
|
| 236 | + $sql = "SELECT Month(FROM_UNIXTIME(`documenteddate`)) as Bulan, Count(*) as Total FROM `tickets` WHERE (`ticketstatus`='Resolved' OR `ticketstatus`='Closed') AND FROM_UNIXTIME(`documenteddate`) >= CURDATE() - INTERVAL 1 YEAR GROUP BY Month(FROM_UNIXTIME(`documenteddate`))"; |
|
| 237 | + $query = $this->db->prepare($sql); |
|
| 238 | + |
|
| 239 | + try { |
|
| 240 | + $query->execute(); |
|
| 241 | + } catch (PDOException $e) { |
|
| 242 | + die($e->getMessage()); |
|
| 243 | + } |
|
| 244 | + |
|
| 245 | + return $query->fetchAll(); |
|
| 246 | + } |
|
| 247 | + |
|
| 248 | + public function count_inprogress_tickets_by_month() |
|
| 249 | + { |
|
| 250 | + $sql = "SELECT Month(FROM_UNIXTIME(`documenteddate`)) as Bulan, Count(*) as Total FROM `tickets` WHERE (`ticketstatus`='Assigned' OR `ticketstatus`='Pending') AND FROM_UNIXTIME(`documenteddate`) >= CURDATE() - INTERVAL 1 YEAR GROUP BY Month(FROM_UNIXTIME(`documenteddate`))"; |
|
| 251 | + $query = $this->db->prepare($sql); |
|
| 252 | + |
|
| 253 | + try { |
|
| 254 | + $query->execute(); |
|
| 255 | + } catch (PDOException $e) { |
|
| 256 | + die($e->getMessage()); |
|
| 257 | + } |
|
| 258 | + |
|
| 259 | + return $query->fetchAll(); |
|
| 260 | + } |
|
| 261 | + |
|
| 262 | + public function get_last_ticket() |
|
| 263 | + { |
|
| 264 | + $query = $this->db->prepare('SELECT * FROM `tickets` ORDER BY id DESC LIMIT 1'); |
|
| 265 | + |
|
| 266 | + try { |
|
| 267 | + $query->execute(); |
|
| 268 | + |
|
| 269 | + return $query->fetch(); |
|
| 270 | + } catch (PDOException $e) { |
|
| 271 | + die($e->getMessage()); |
|
| 272 | + } |
|
| 273 | + } |
|
| 274 | + |
|
| 275 | + /* |
|
| 276 | 276 | public function notify_assignee($id,$ticketnumber,$email_assignee) |
| 277 | 277 | { if (substr(php_uname(), 0, 7) == "Windows"){ |
| 278 | 278 | $cmd = "D:\mowes_portable\www\helpdesk\batch\sendemail.bat"; |
@@ -286,51 +286,51 @@ discard block |
||
| 286 | 286 | } |
| 287 | 287 | }*/ |
| 288 | 288 | |
| 289 | - public function log_tickets($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate, $changes, $changeby) |
|
| 290 | - { |
|
| 291 | - $changedate = time(); |
|
| 292 | - $querystring = 'INSERT INTO `log_tickets` (`id`,`sla`,`reporteddate`, `reportedby`, `telp`, `email`, `problemsummary`,`problemdetail`,`ticketstatus`,`assignee`,`assigneddate`,`pendingby`,`pendingdate`,`resolution`,`resolvedby`,`resolveddate`,`closedby`,`closeddate`,`changes`,`changeby`,`changedate`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'; |
|
| 293 | - $query = $this->db->prepare($querystring); |
|
| 294 | - $query->bindValue(1, $id); |
|
| 295 | - $query->bindValue(2, $sla); |
|
| 296 | - $query->bindValue(3, $reporteddate); |
|
| 297 | - $query->bindValue(4, $reportedby); |
|
| 298 | - $query->bindValue(5, $telp); |
|
| 299 | - $query->bindValue(6, $email); |
|
| 300 | - $query->bindValue(7, $problemsummary); |
|
| 301 | - $query->bindValue(8, $problemdetail); |
|
| 302 | - $query->bindValue(9, $ticketstatus); |
|
| 303 | - $query->bindValue(10, $assignee); |
|
| 304 | - $query->bindValue(11, $assigneddate); |
|
| 305 | - $query->bindValue(12, $pendingby); |
|
| 306 | - $query->bindValue(13, $pendingdate); |
|
| 307 | - $query->bindValue(14, $resolution); |
|
| 308 | - $query->bindValue(15, $resolvedby); |
|
| 309 | - $query->bindValue(16, $resolveddate); |
|
| 310 | - $query->bindValue(17, $closedby); |
|
| 311 | - $query->bindValue(18, $closeddate); |
|
| 312 | - $query->bindValue(19, $changes); |
|
| 313 | - $query->bindValue(20, $changeby); |
|
| 314 | - $query->bindValue(21, $changedate); |
|
| 315 | - |
|
| 316 | - try { |
|
| 317 | - $query->execute(); |
|
| 318 | - } catch (PDOException $e) { |
|
| 319 | - die($e->getMessage()); |
|
| 320 | - } |
|
| 321 | - } |
|
| 322 | - |
|
| 323 | - public function get_audit_trail($id) |
|
| 324 | - { |
|
| 325 | - $query = $this->db->prepare('SELECT * FROM `log_tickets` WHERE `id`= ? ORDER BY `changedate` DESC'); |
|
| 326 | - $query->bindValue(1, $id); |
|
| 327 | - |
|
| 328 | - try { |
|
| 329 | - $query->execute(); |
|
| 330 | - } catch (PDOException $e) { |
|
| 331 | - die($e->getMessage()); |
|
| 332 | - } |
|
| 333 | - |
|
| 334 | - return $query->fetchAll(); |
|
| 335 | - } |
|
| 289 | + public function log_tickets($id, $sla, $reporteddate, $reportedby, $telp, $email, $problemsummary, $problemdetail, $ticketstatus, $assignee, $assigneddate, $pendingby, $pendingdate, $resolution, $resolvedby, $resolveddate, $closedby, $closeddate, $changes, $changeby) |
|
| 290 | + { |
|
| 291 | + $changedate = time(); |
|
| 292 | + $querystring = 'INSERT INTO `log_tickets` (`id`,`sla`,`reporteddate`, `reportedby`, `telp`, `email`, `problemsummary`,`problemdetail`,`ticketstatus`,`assignee`,`assigneddate`,`pendingby`,`pendingdate`,`resolution`,`resolvedby`,`resolveddate`,`closedby`,`closeddate`,`changes`,`changeby`,`changedate`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'; |
|
| 293 | + $query = $this->db->prepare($querystring); |
|
| 294 | + $query->bindValue(1, $id); |
|
| 295 | + $query->bindValue(2, $sla); |
|
| 296 | + $query->bindValue(3, $reporteddate); |
|
| 297 | + $query->bindValue(4, $reportedby); |
|
| 298 | + $query->bindValue(5, $telp); |
|
| 299 | + $query->bindValue(6, $email); |
|
| 300 | + $query->bindValue(7, $problemsummary); |
|
| 301 | + $query->bindValue(8, $problemdetail); |
|
| 302 | + $query->bindValue(9, $ticketstatus); |
|
| 303 | + $query->bindValue(10, $assignee); |
|
| 304 | + $query->bindValue(11, $assigneddate); |
|
| 305 | + $query->bindValue(12, $pendingby); |
|
| 306 | + $query->bindValue(13, $pendingdate); |
|
| 307 | + $query->bindValue(14, $resolution); |
|
| 308 | + $query->bindValue(15, $resolvedby); |
|
| 309 | + $query->bindValue(16, $resolveddate); |
|
| 310 | + $query->bindValue(17, $closedby); |
|
| 311 | + $query->bindValue(18, $closeddate); |
|
| 312 | + $query->bindValue(19, $changes); |
|
| 313 | + $query->bindValue(20, $changeby); |
|
| 314 | + $query->bindValue(21, $changedate); |
|
| 315 | + |
|
| 316 | + try { |
|
| 317 | + $query->execute(); |
|
| 318 | + } catch (PDOException $e) { |
|
| 319 | + die($e->getMessage()); |
|
| 320 | + } |
|
| 321 | + } |
|
| 322 | + |
|
| 323 | + public function get_audit_trail($id) |
|
| 324 | + { |
|
| 325 | + $query = $this->db->prepare('SELECT * FROM `log_tickets` WHERE `id`= ? ORDER BY `changedate` DESC'); |
|
| 326 | + $query->bindValue(1, $id); |
|
| 327 | + |
|
| 328 | + try { |
|
| 329 | + $query->execute(); |
|
| 330 | + } catch (PDOException $e) { |
|
| 331 | + die($e->getMessage()); |
|
| 332 | + } |
|
| 333 | + |
|
| 334 | + return $query->fetchAll(); |
|
| 335 | + } |
|
| 336 | 336 | } |
@@ -31,7 +31,7 @@ discard block |
||
| 31 | 31 | |
| 32 | 32 | try { |
| 33 | 33 | $query->execute(); |
| 34 | - } catch (PDOException $e) { |
|
| 34 | + }catch (PDOException $e) { |
|
| 35 | 35 | die($e->getMessage()); |
| 36 | 36 | } |
| 37 | 37 | } |
@@ -61,7 +61,7 @@ discard block |
||
| 61 | 61 | |
| 62 | 62 | try { |
| 63 | 63 | $query->execute(); |
| 64 | - } catch (PDOException $e) { |
|
| 64 | + }catch (PDOException $e) { |
|
| 65 | 65 | die($e->getMessage()); |
| 66 | 66 | } |
| 67 | 67 | } |
@@ -74,7 +74,7 @@ discard block |
||
| 74 | 74 | |
| 75 | 75 | try { |
| 76 | 76 | $query->execute(); |
| 77 | - } catch (PDOException $e) { |
|
| 77 | + }catch (PDOException $e) { |
|
| 78 | 78 | die($e->getMessage()); |
| 79 | 79 | } |
| 80 | 80 | } |
@@ -88,7 +88,7 @@ discard block |
||
| 88 | 88 | $query->execute(); |
| 89 | 89 | |
| 90 | 90 | return $query->fetch(); |
| 91 | - } catch (PDOException $e) { |
|
| 91 | + }catch (PDOException $e) { |
|
| 92 | 92 | die($e->getMessage()); |
| 93 | 93 | } |
| 94 | 94 | } |
@@ -99,7 +99,7 @@ discard block |
||
| 99 | 99 | |
| 100 | 100 | try { |
| 101 | 101 | $query->execute(); |
| 102 | - } catch (PDOException $e) { |
|
| 102 | + }catch (PDOException $e) { |
|
| 103 | 103 | die($e->getMessage()); |
| 104 | 104 | } |
| 105 | 105 | |
@@ -112,7 +112,7 @@ discard block |
||
| 112 | 112 | |
| 113 | 113 | try { |
| 114 | 114 | $query->execute(); |
| 115 | - } catch (PDOException $e) { |
|
| 115 | + }catch (PDOException $e) { |
|
| 116 | 116 | die($e->getMessage()); |
| 117 | 117 | } |
| 118 | 118 | |
@@ -125,7 +125,7 @@ discard block |
||
| 125 | 125 | |
| 126 | 126 | try { |
| 127 | 127 | $query->execute(); |
| 128 | - } catch (PDOException $e) { |
|
| 128 | + }catch (PDOException $e) { |
|
| 129 | 129 | die($e->getMessage()); |
| 130 | 130 | } |
| 131 | 131 | |
@@ -139,7 +139,7 @@ discard block |
||
| 139 | 139 | |
| 140 | 140 | try { |
| 141 | 141 | $query->execute(); |
| 142 | - } catch (PDOException $e) { |
|
| 142 | + }catch (PDOException $e) { |
|
| 143 | 143 | die($e->getMessage()); |
| 144 | 144 | } |
| 145 | 145 | |
@@ -153,7 +153,7 @@ discard block |
||
| 153 | 153 | |
| 154 | 154 | try { |
| 155 | 155 | $query->execute(); |
| 156 | - } catch (PDOException $e) { |
|
| 156 | + }catch (PDOException $e) { |
|
| 157 | 157 | die($e->getMessage()); |
| 158 | 158 | } |
| 159 | 159 | |
@@ -167,7 +167,7 @@ discard block |
||
| 167 | 167 | |
| 168 | 168 | try { |
| 169 | 169 | $query->execute(); |
| 170 | - } catch (PDOException $e) { |
|
| 170 | + }catch (PDOException $e) { |
|
| 171 | 171 | die($e->getMessage()); |
| 172 | 172 | } |
| 173 | 173 | |
@@ -182,7 +182,7 @@ discard block |
||
| 182 | 182 | |
| 183 | 183 | try { |
| 184 | 184 | $query->execute(); |
| 185 | - } catch (PDOException $e) { |
|
| 185 | + }catch (PDOException $e) { |
|
| 186 | 186 | die($e->getMessage()); |
| 187 | 187 | } |
| 188 | 188 | |
@@ -196,7 +196,7 @@ discard block |
||
| 196 | 196 | |
| 197 | 197 | try { |
| 198 | 198 | $query->execute(); |
| 199 | - } catch (PDOException $e) { |
|
| 199 | + }catch (PDOException $e) { |
|
| 200 | 200 | die($e->getMessage()); |
| 201 | 201 | } |
| 202 | 202 | |
@@ -211,7 +211,7 @@ discard block |
||
| 211 | 211 | |
| 212 | 212 | try { |
| 213 | 213 | $query->execute(); |
| 214 | - } catch (PDOException $e) { |
|
| 214 | + }catch (PDOException $e) { |
|
| 215 | 215 | die($e->getMessage()); |
| 216 | 216 | } |
| 217 | 217 | |
@@ -224,7 +224,7 @@ discard block |
||
| 224 | 224 | |
| 225 | 225 | try { |
| 226 | 226 | $query->execute(); |
| 227 | - } catch (PDOException $e) { |
|
| 227 | + }catch (PDOException $e) { |
|
| 228 | 228 | die($e->getMessage()); |
| 229 | 229 | } |
| 230 | 230 | |
@@ -238,7 +238,7 @@ discard block |
||
| 238 | 238 | |
| 239 | 239 | try { |
| 240 | 240 | $query->execute(); |
| 241 | - } catch (PDOException $e) { |
|
| 241 | + }catch (PDOException $e) { |
|
| 242 | 242 | die($e->getMessage()); |
| 243 | 243 | } |
| 244 | 244 | |
@@ -252,7 +252,7 @@ discard block |
||
| 252 | 252 | |
| 253 | 253 | try { |
| 254 | 254 | $query->execute(); |
| 255 | - } catch (PDOException $e) { |
|
| 255 | + }catch (PDOException $e) { |
|
| 256 | 256 | die($e->getMessage()); |
| 257 | 257 | } |
| 258 | 258 | |
@@ -267,7 +267,7 @@ discard block |
||
| 267 | 267 | $query->execute(); |
| 268 | 268 | |
| 269 | 269 | return $query->fetch(); |
| 270 | - } catch (PDOException $e) { |
|
| 270 | + }catch (PDOException $e) { |
|
| 271 | 271 | die($e->getMessage()); |
| 272 | 272 | } |
| 273 | 273 | } |
@@ -315,7 +315,7 @@ discard block |
||
| 315 | 315 | |
| 316 | 316 | try { |
| 317 | 317 | $query->execute(); |
| 318 | - } catch (PDOException $e) { |
|
| 318 | + }catch (PDOException $e) { |
|
| 319 | 319 | die($e->getMessage()); |
| 320 | 320 | } |
| 321 | 321 | } |
@@ -327,7 +327,7 @@ discard block |
||
| 327 | 327 | |
| 328 | 328 | try { |
| 329 | 329 | $query->execute(); |
| 330 | - } catch (PDOException $e) { |
|
| 330 | + }catch (PDOException $e) { |
|
| 331 | 331 | die($e->getMessage()); |
| 332 | 332 | } |
| 333 | 333 | |
