Menambahkan Fitur Laporan Ticket Aging, Ticket Summary, dan Ticket untuk Staff ke dalam osTicket v1.6 RC5

Saya telah berhasil membuat sebuah fitur laporan baru ke dalam osTicket v1.6 RC5 yang mengandung tiga laporan baru. Mereka adalah:
1) Usia Tiket (<= 3 Hari, > 3 dan <= 7 Hari, > 7 dan <= 14 Hari, dan > 14 Hari),
2) Ringkasan Tiket (Staff yang bertanggung jawab:, Total Jumlah Tiket yang Aktif:, Total Jumlah Tiket yang Tertutup:, Total Jumlah dari Tiket yang Belum Ditugaskan: ), dan
3) Tiket untuk Staff (Staff yang bertanggung jawab dengan jumlah dan detil tiket yang ditugaskan kepada mereka).

Anda akan melihat bahwa ada tiga sub tab di bawah tab Dashboard di Panel Admin dari osTicket Anda.

Buka file /scp/admin.php Anda, dan cari kode ini:

    break;
    default:
        $errors['err']='Uknown command!';
    endswitch;
endif;

lalu timpa dengan kode berikut:

    break;
    case 'ticketaging':
 
    break;
    case 'ticketsummary':
 
    break;
    default:
        $errors['err']='Uknown command!';
    endswitch;
endif;

Cari lagi kode yang ini:

    case 'dashboard':
    case 'syslog':
        $nav->setTabActive('dashboard');
        $nav->addSubMenu(array('desc'=>'System Logs','href'=>'admin.php?t=syslog','iconclass'=>'syslogs'));
        $page='syslogs.inc.php';
        break;

lalu timpa dengan kode berikut:

    case 'dashboard':
    case 'syslog':
    case 'ticketaging':
    case 'ticketsummary':
    case 'ticketstaff':
        $nav->setTabActive('dashboard');
        $nav->addSubMenu(array('desc'=>'System Logs','href'=>'admin.php?t=syslog','iconclass'=>'syslogs'));
        $nav->addSubMenu(array('desc'=>'Ticket Aging','href'=>'admin.php?t=ticketaging','iconclass'=>'syslogs'));
        $nav->addSubMenu(array('desc'=>'Ticket Summary','href'=>'admin.php?t=ticketsummary','iconclass'=>'syslogs'));
        $nav->addSubMenu(array('desc'=>'Ticket for Staff','href'=>'admin.php?t=ticketstaff','iconclass'=>'syslogs'));
        switch($thistab):
        case 'dashboard':
        case 'syslog':
          $page='syslogs.inc.php';
          break;
        case 'ticketaging':
          $page='ticketaging.inc.php';
          break;
        case 'ticketsummary':
          $page='ticketsummary.inc.php';
          break;
        case 'ticketstaff':
          $page='ticketstaff.inc.php';
        endswitch;
        break;

Buat sebuah file baru yang bernama ticketaging.inc.php, lalu salin dan tempelkan kode berikut ini ke dalam file tadi, dan terakhir, letakkan file ini ke dalam sub direktori /include/staff/ dari osTicket Anda:

<?php
if(!defined('OSTSCPINC') || !@$thisuser->isStaff()) die('Access Denied');
 
if($_REQUEST['staffid']) {
  $staffid = $_REQUEST['staffid'];
}
 
echo '
<div class="msg">Ticket Aging</div>
';
 
$numtotalstaff=0;
$sqltotalstaff='SELECT DISTINCT(t.staff_id), s.username, s.firstname, s.lastname '.
               'FROM '.TICKET_TABLE.' t, '.STAFF_TABLE.' s '.
               'WHERE t.staff_id <> "0" AND t.staff_id=s.staff_id';
if(($restotalstaff=db_query($sqltotalstaff)) && ($numtotalstaff=db_num_rows($restotalstaff))) {
 $strtickettotalstaff = '';
 $itotalstaff = 1;
?>
<form action="admin.php?t=ticketaging" method="post">
 <input type=hidden name='a' value='staff'>
 Staff Name:&nbsp;<select name="staffid" >
  <option value="" selected >Select One</option>
<?
 while ($rowtotalstaff = db_fetch_array($restotalstaff)) {
   $selected = ($_REQUEST['staffid']==$rowtotalstaff['staff_id'])?'selected':''; ?>
   <option value="<?=$rowtotalstaff['staff_id']?>"<?=$selected?>><? echo $rowtotalstaff['username'].' ('.$rowtotalstaff['firstname'].' '.$rowtotalstaff['lastname'].')'; ?></option>
<?
 }
?>
 </select>
 <input class="button" type="submit" value="View">
</form>
<?
}
 
echo '
<div style="margin-bottom:20px; padding-top:0px;">';
echo '
<table width="100%" border="0" cellspacing=1 cellpadding=2>';
echo '
<tr>
<td>
<table width="100%" border="0" cellspacing=0 cellpadding=2 class="logs" align="center">
<tr>
<th>&nbsp;&nbsp;Ticket Aging and Its Count</th>
</tr>
';
 
$numtotal=0;
if ($staffid) {
  $sqltotal='SELECT * FROM '.TICKET_TABLE.' WHERE staff_id = '.$staffid.' AND status = "open"';
} else {
  $sqltotal='SELECT * FROM '.TICKET_TABLE.' WHERE staff_id <> "0" AND status = "open"';
}
if(($restotal=db_query($sqltotal)) && ($numtotal=db_num_rows($restotal))) {
 $strtickettotal = '';
 $itotal = 1;
 while ($rowtotal = db_fetch_array($restotal)) {
   if ($itotal<$numtotal) {
     $strtickettotal .= '<a href="tickets.php?id='.$rowtotal['ticket_id'].'" target="_blank">'.$rowtotal['ticketID'].'</a>, ';
   } elseif ($itotal>=$numtotal) {
     $strtickettotal .=  '<a href="tickets.php?id='.$rowtotal['ticket_id'].'" target="_blank">'.$rowtotal['ticketID'].'</a>';
   }
   $itotal++;
 }
}
?>
<tr class="row1" id="1">
<td>
<a href="javascript:toggleMessage('1');">
<img border="0" align="left" id="img_1" src="images/plus.gif">
<span style="color:000; float: left; width:350px;"><? echo "Total Number of Active Tickets: "; ?></span>
&nbsp;&nbsp;
 <span class="Icon <?=$icon?>" align="right"><? echo '<b>'.$numtotal.'</b>
'; ?></span></a>
<div id="msg_1" class="hide">
       <hr>
       <span style="text-align:left;float:left;">Ticket Item(s): <i><? echo ($strtickettotal)?$strtickettotal:'-'; ?></i></span></div></td>
</tr>
<?
$numact3days=0;
if ($staffid) {
  $sqlact3days='SELECT * FROM '.TICKET_TABLE.' '.
               'WHERE staff_id <> "0" AND 3 >= TIMESTAMPDIFF(DAY,created,NOW()) '.
               'AND status = "open" and staff_id = '.$staffid.'';
} else {
  $sqlact3days='SELECT * FROM '.TICKET_TABLE.' '.
               'WHERE staff_id <> "0" AND 3 >= TIMESTAMPDIFF(DAY,created,NOW()) '.
               'AND status = "open"';
}
if(($resact3days=db_query($sqlact3days)) && ($numact3days=db_num_rows($resact3days))) {
 $strticketact3days = '';
 $iact3days = 1;
 while ($rowact3days = db_fetch_array($resact3days)) {
   if ($iact3days<$numact3days) {
     $strticketact3days .= '<a href="tickets.php?id='.$rowact3days['ticket_id'].'" target="_blank">'.$rowact3days['ticketID'].'</a>, ';
   } elseif ($iact3days>=$numact3days) {
     $strticketact3days .=  '<a href="tickets.php?id='.$rowact3days['ticket_id'].'" target="_blank">'.$rowact3days['ticketID'].'</a>';
   }
   $iact3days++;
 }
}
?>
<tr class="row2" id="2">
<td>
<a href="javascript:toggleMessage('2');">
<img border="0" align="left" id="img_2" src="images/plus.gif">
<span style="color:000; float: left; width:350px;"><? echo "Total Number of Active Tickets (<= 3 Days): "; ?></span>
&nbsp;&nbsp;
 <span class="Icon <?=$icon?>" align="right"><? echo '<b><span align="right">'.$numact3days.'</span></b>
'; ?></span></a>
<div id="msg_2" class="hide">
       <hr>
       <span style="text-align:left;float:left;">Ticket Item(s): <i><? echo ($strticketact3days)?$strticketact3days:'-'; ?></i></span></div></td>
</tr>
<?
$numact7days=0;
if ($staffid) {
  $sqlact7days='SELECT * FROM '.TICKET_TABLE.' WHERE staff_id = '.$staffid.' AND (7 >= TIMESTAMPDIFF(DAY,created,NOW()) AND 3 < TIMESTAMPDIFF(DAY,created,NOW())) AND status = "open"';
} else {
  $sqlact7days='SELECT * FROM '.TICKET_TABLE.' WHERE staff_id <> "0" AND (7 >= TIMESTAMPDIFF(DAY,created,NOW()) AND 3 < TIMESTAMPDIFF(DAY,created,NOW())) AND status = "open"';
}
 
if(($resact7days=db_query($sqlact7days)) && ($numact7days=db_num_rows($resact7days))) {
 $strticketact7days = '';
 $iact7days = 1;
 while ($rowact7days = db_fetch_array($resact7days)) {
   if ($iact7days<$numact7days) {
     $strticketact7days .= '<a href="tickets.php?id='.$rowact7days['ticket_id'].'" target="_blank">'.$rowact7days['ticketID'].'</a>, ';
   } elseif ($iact7days>=$numact7days) {
     $strticketact7days .=  '<a href="tickets.php?id='.$rowact7days['ticket_id'].'" target="_blank">'.$rowact7days['ticketID'].'</a>';
   }
   $iact7days++;
 }
}
?>
<tr class="row1" id="3">
<td>
<a href="javascript:toggleMessage('3');">
<img border="0" align="left" id="img_3" src="images/plus.gif">
<span style="color:000; float: left; width:350px;"><? echo "Total Number of Active Tickets (> 3 Days and <= 7 Days): "; ?></span>
&nbsp;&nbsp;
 <span class="Icon <?=$icon?>" align="right"><? echo '<b><span align="right">'.$numact7days.'</span></b>
'; ?></span></a>
<div id="msg_3" class="hide">
       <hr>
       <span style="text-align:left;float:left;">Ticket Item(s): <i><? echo ($strticketact7days)?$strticketact7days:'-'; ?></i></span></div></td>
</tr>
<?
$numact14days=0;
if ($staffid) {
  $sqlact14days='SELECT * FROM '.TICKET_TABLE.' WHERE staff_id = '.$staffid.' AND (14 >= TIMESTAMPDIFF(DAY,created,NOW()) AND 7 < TIMESTAMPDIFF(DAY,created,NOW())) AND status = "open"';
} else {
  $sqlact14days='SELECT * FROM '.TICKET_TABLE.' WHERE staff_id <> "0" AND (14 >= TIMESTAMPDIFF(DAY,created,NOW()) AND 7 < TIMESTAMPDIFF(DAY,created,NOW())) AND status = "open"';
}
 
if(($resact14days=db_query($sqlact14days)) && ($numact14days=db_num_rows($resact14days))) {
 $strticketact14days = '';
 $iact14days = 1;
 while ($rowact14days = db_fetch_array($resact14days)) {
   if ($iact14days<$numact14days) {
     $strticketact14days .= '<a href="tickets.php?id='.$rowact14days['ticket_id'].'" target="_blank">'.$rowact14days['ticketID'].'</a>, ';
   } elseif ($iact14days>=$numact14days) {
     $strticketact14days .=  '<a href="tickets.php?id='.$rowact14days['ticket_id'].'" target="_blank">'.$rowact14days['ticketID'].'</a>';
   }
   $iact14days++;
 }
}
?>
<tr class="row2" id="4">
<td>
<a href="javascript:toggleMessage('4');">
<img border="0" align="left" id="img_4" src="images/plus.gif">
<span style="color:000; float: left; width:350px;"><? echo "Total Number of Active Tickets (> 7 Days and <= 14 Days): "; ?></span>
&nbsp;&nbsp;
 <span class="Icon <?=$icon?>" align="right"><? echo '<b><span align="right">'.$numact14days.'</span></b>
'; ?></span></a>
<div id="msg_4" class="hide">
       <hr>
       <span style="text-align:left;float:left;">Ticket Item(s): <i><? echo ($strticketact14days)?$strticketact14days:'-'; ?></i></span></div></td>
</tr>
<?
$numactmore14days=0;
if ($staffid) {
  $sqlactmore14days='SELECT * FROM '.TICKET_TABLE.' WHERE staff_id = '.$staffid.' AND 14 < TIMESTAMPDIFF(DAY,created,NOW()) AND status = "open"';
} else {
  $sqlactmore14days='SELECT * FROM '.TICKET_TABLE.' WHERE staff_id <> "0" AND 14 < TIMESTAMPDIFF(DAY,created,NOW()) AND status = "open"';
}
 
if(($resactmore14days=db_query($sqlactmore14days)) && ($numactmore14days=db_num_rows($resactmore14days))) {
 $strticketactmore14days = '';
 $iactmore14days = 1;
 while ($rowactmore14days = db_fetch_array($resactmore14days)) {
   if ($iactmore14days<$numactmore14days) {
     $strticketactmore14days .= '<a href="tickets.php?id='.$rowactmore14days['ticket_id'].'" target="_blank">'.$rowactmore14days['ticketID'].'</a>, ';
   } elseif ($iactmore14days>=$numactmore14days) {
     $strticketactmore14days .=  '<a href="tickets.php?id='.$rowactmore14days['ticket_id'].'" target="_blank">'.$rowactmore14days['ticketID'].'</a>';
   }
   $iactmore14days++;
 }
}
?>
<tr class="row1" id="5">
<td>
<a href="javascript:toggleMessage('5');">
<img border="0" align="left" id="img_5" src="images/plus.gif">
<span style="color:000; float: left; width:350px;"><? echo "Total Number of Active Tickets (> 14 Days): "; ?></span>
&nbsp;&nbsp;
 <span class="Icon <?=$icon?>" align="right"><? echo '<b><span align="right">'.$numactmore14days.'</span></b>
'; ?></span></a>
<div id="msg_5" class="hide">
       <hr>
       <span style="text-align:left;float:left;">Ticket Item(s): <i><? echo ($strticketactmore14days)?$strticketactmore14days:'-'; ?></i></span></div></td>
</tr>
</table>
</td>
</tr>
</table>

Ticket Aging Report
Ticket Aging Report for The Certain Staff
Ticket Aging for The Certain Staff with Detail Item Ticket

Buat sebuah file baru yang bernama ticketsummary.inc.php, lalu salin dan tempelkan kode berikut ke dalam file tadi, lalu letakkan file ini ke dalam sub direktori /include/staff/ dari osTicket Anda:

<?php
if(!defined('OSTSCPINC') || !@$thisuser->isStaff()) die('Access Denied');
 
if($_REQUEST['staffid']) {
  $staffid = $_REQUEST['staffid'];
}
 
echo '
<div class="msg">Ticket Summary</div>
';
 
$numtotalstaff=0;
$sqltotalstaff='SELECT DISTINCT(t.staff_id), s.username, s.firstname, s.lastname '.
               'FROM '.TICKET_TABLE.' t, '.STAFF_TABLE.' s '.
               'WHERE t.staff_id <> "0" AND t.staff_id=s.staff_id';
if(($restotalstaff=db_query($sqltotalstaff)) && ($numtotalstaff=db_num_rows($restotalstaff))) {
 $strtickettotalstaff = '';
 $itotalstaff = 1;
?>
<form action="admin.php?t=ticketsummary" method="post">
 <input type=hidden name='a' value='staff'>
 Staff Name:&nbsp;<select name="staffid" >
  <option value="" selected >Select One</option>
<?
 while ($rowtotalstaff = db_fetch_array($restotalstaff)) {
   $selected = ($_REQUEST['staffid']==$rowtotalstaff['staff_id'])?'selected':''; ?>
   <option value="<?=$rowtotalstaff['staff_id']?>"<?=$selected?>><? echo $rowtotalstaff['username'].' ('.$rowtotalstaff['firstname'].' '.$rowtotalstaff['lastname'].')'; ?></option>
<?
 }
?>
 </select>
 <input class="button" type="submit" value="View">
</form>
<?
}
 
echo '
<div style="margin-bottom:20px; padding-top:0px;">';
echo '
<table width="100%" border="0" cellspacing=1 cellpadding=2>';
echo '
<tr>
<td>
<table width="100%" border="0" cellspacing=0 cellpadding=2 class="logs" align="center">
<tr>
<th>&nbsp;&nbsp;Ticket Summary and Its Count</th>
</tr>
';
 
$numstaff=0;
if ($staffid) {
  $sqlstaff='SELECT DISTINCT(t.staff_id), s.username FROM '.TICKET_TABLE.' t, '.STAFF_TABLE.' s '.
          'WHERE t.staff_id = '.$staffid.' AND t.staff_id=s.staff_id';
} else {
  $sqlstaff='SELECT DISTINCT(t.staff_id), s.username FROM '.TICKET_TABLE.' t, '.STAFF_TABLE.' s '.
          'WHERE t.staff_id <> "0" AND t.staff_id=s.staff_id';
}
 
if(($resstaff=db_query($sqlstaff)) && ($numstaff=db_num_rows($resstaff))) {
 $strticketstaff = '';
 $istaff = 1;
 while ($rowstaff = db_fetch_array($resstaff)) {
   if ($istaff<$numstaff) {
     $strticketstaff .= '<a href="admin.php?t=staff&id='.$rowstaff['staff_id'].'" target="_blank">'.$rowstaff['username'].'</a>, ';
   } elseif ($istaff>=$numstaff) {
     $strticketstaff .=  '<a href="admin.php?t=staff&id='.$rowstaff['staff_id'].'" target="_blank">'.$rowstaff['username'].'</a>';
   }
   $istaff++;
 }
}
?>
<tr class="row1" id="1">
<td>
<a href="javascript:toggleMessage('1');">
<img border="0" align="left" id="img_1" src="images/plus.gif">
<span style="color:000; float: left; width:250px;"><? echo "Staff in Charge: "; ?></span>
&nbsp;&nbsp;
 <span class="Icon <?=$icon?>" align="right"><? echo '<b>'.$numstaff.'</b>
'; ?></span></a>
<div id="msg_1" class="hide">
       <hr>
       <span style="text-align:left;float:left;">Staff in Charge Username: <i><? echo ($strticketstaff)?$strticketstaff:'-'; ?></i></span></div></td>
</tr>
<?
$numtotal=0;
if ($staffid) {
  $sqltotal='SELECT * FROM '.TICKET_TABLE.' WHERE staff_id = '.$staffid.'';
} else {
  $sqltotal='SELECT * FROM '.TICKET_TABLE.' WHERE staff_id <> "0"';
}
if(($restotal=db_query($sqltotal)) && ($numtotal=db_num_rows($restotal))) {
 $strtickettotal = '';
 $itotal = 1;
 while ($rowtotal = db_fetch_array($restotal)) {
   if (($itotal<$numtotal)) {
     $strtickettotal .= '<a href="tickets.php?id='.$rowtotal['ticket_id'].'" target="_blank">'.$rowtotal['ticketID'].'</a>, ';
   } elseif ($itotal>=$numtotal) {
     $strtickettotal .=  '<a href="tickets.php?id='.$rowtotal['ticket_id'].'" target="_blank">'.$rowtotal['ticketID'].'</a>';
   }
   $itotal++;
 }
}
?>
<tr class="row2" id="2">
<td>
<a href="javascript:toggleMessage('2');">
<img border="0" align="left" id="img_2" src="images/plus.gif">
<span style="color:000; float: left; width:250px;"><? echo "Total Number of Active Tickets: "; ?></span>
&nbsp;&nbsp;
 <span class="Icon <?=$icon?>" align="right"><? echo '<b>'.$numtotal.'</b>
'; ?></span></a>
<div id="msg_2" class="hide">
       <hr>
       <span style="text-align:left;float:left;">Ticket Item(s): <i><? echo ($strtickettotal)?$strtickettotal:'-'; ?></i></span></div></td>
</tr>
<?
 
$numtotalclosed=0;
if ($staffid) {
  $sqltotalclosed='SELECT * FROM '.TICKET_TABLE.' WHERE status = "closed" and staff_id='.$staffid.'';
} else {
  $sqltotalclosed='SELECT * FROM '.TICKET_TABLE.' WHERE status = "closed"';
}
if(($restotalclosed=db_query($sqltotalclosed)) && ($numtotalclosed=db_num_rows($restotalclosed))) {
 $strtickettotalclosed = '';
 $itotalclosed = 1;
 while ($rowtotalclosed = db_fetch_array($restotalclosed)) {
   if ($itotalclosed<$numtotalclosed) {
     $strtickettotalclosed .= '<a href="tickets.php?id='.$rowtotalclosed['ticket_id'].'" target="_blank">'.$rowtotalclosed['ticketID'].'</a>, ';
   } elseif ($itotalclosed>=$numtotalclosed) {
     $strtickettotalclosed .=  '<a href="tickets.php?id='.$rowtotalclosed['ticket_id'].'" target="_blank">'.$rowtotalclosed['ticketID'].'</a>';
   }
   $itotalclosed++;
 }
}
?>
<tr class="row1" id="3">
<td>
<a href="javascript:toggleMessage('3');">
<img border="0" align="left" id="img_3" src="images/plus.gif">
<span style="color:000; float: left; width:250px;"><? echo "Total Number of Closed Tickets: "; ?></span>
&nbsp;&nbsp;
 <span class="Icon <?=$icon?>" align="right"><? echo '<b>'.$numtotalclosed.'</b>
'; ?></span></a>
<div id="msg_3" class="hide">
       <hr>
       <span style="text-align:left;float:left;">Ticket Item(s): <i><? echo ($strtickettotalclosed)?$strtickettotalclosed:'-'; ?></i></span></div></td>
</tr>
<?
 
$numtotalunassigned=0;
if ($staffid) {
  $sqltotalunassigned='SELECT * FROM '.TICKET_TABLE.' WHERE staff_id = "0" and staff_id = '.$staffid.'';
} else {
  $sqltotalunassigned='SELECT * FROM '.TICKET_TABLE.' WHERE staff_id = "0"';
}
if(($restotalunassigned=db_query($sqltotalunassigned)) && ($numtotalunassigned=db_num_rows($restotalunassigned))) {
 $strtickettotalunassigned = '';
 $itotalunassigned = 1;
 while ($rowtotalunassigned = db_fetch_array($restotalunassigned)) {
   if ($itotalunassigned<$numtotalunassigned) {
     $strtickettotalunassigned .= '<a href="tickets.php?id='.$rowtotalunassigned['ticket_id'].'" target="_blank">'.$rowtotalunassigned['ticketID'].'</a>, ';
   } elseif ($itotalunassigned>=$numtotalunassigned) {
     $strtickettotalunassigned .=  '<a href="tickets.php?id='.$rowtotalunassigned['ticket_id'].'" target="_blank">'.$rowtotalunassigned['ticketID'].'</a>';
   }
   $itotalunassigned++;
 }
}
?>
<tr class="row2" id="4">
<td>
<a href="javascript:toggleMessage('4');">
<img border="0" align="left" id="img_4" src="images/plus.gif">
<span style="color:000; float: left; width:250px;"><? echo "Total Number of Unassigned Tickets: "; ?></span>
&nbsp;&nbsp;
 <span class="Icon <?=$icon?>" align="right"><? echo '<b>'.$numtotalunassigned.'</b>
'; ?></span></a>
<div id="msg_4" class="hide">
       <hr>
       <span style="text-align:left;float:left;">Ticket Item(s): <i><? echo ($strtickettotalunassigned)?$strtickettotalunassigned:'-'; ?></i></span></div></td>
</tr>
</table>
</td>
</tr>
</table>

Ticket Summary

Buat sebuah file yang bernama ticketstaff.inc.php, lalu salin dan tempelkan kode berikut ke dalam file tersebut, dan terakhir, letakkan file ini ke dalam sub direktori /include/staff/ dari osTicket Anda:

<?php
if(!defined('OSTSCPINC') || !@$thisuser->isStaff()) die('Access Denied');
 
$qselect='SELECT DISTINCT(t.staff_id), s.username, s.firstname, s.lastname ';
$qfrom='FROM '.TICKET_TABLE.' t, '.STAFF_TABLE.' s ';
$qwhere=' WHERE t.staff_id <> "0" AND t.staff_id=s.staff_id ';
//get log count based on the query so far..
$total=db_count("SELECT count(*) $qfrom $qwhere");
$pagelimit=30;
//pagenate
$pageNav=new Pagenate($total,$page,$pagelimit);
$pageNav->setURL('admin.php',$qstr);
$query="$qselect $qfrom $qwhere ORDER BY t.created DESC LIMIT ".$pageNav->getStart().",".$pageNav->getLimit();
//echo $query;
$result = db_query($query);
$showing=db_num_rows($result)?$pageNav->showing():"";
?>
<div class="msg">Ticket for Staff</div>
<div style="margin-bottom:20px; padding-top:0px;">
<table width="100%" border="0" cellspacing=1 cellpadding=2>
    <form action="tickets.php" method="POST" name='tickets' onSubmit="return checkbox_checker(this,1,0);">
    <input type="hidden" name="a" value="mass_process" >
    <input type="hidden" name="status" value="<?=$statusss?>" >
<tr>
<td>
<table width="100%" border="0" cellspacing=0 cellpadding=2 class="logs" align="center">
<tr>
<th>&nbsp;&nbsp;Staff Name and Tickets Count</th>
</tr>
<?
        $class = "row1";
        $total=0;
        $i=1;
        if($result && ($num=db_num_rows($result))):
            while ($row = db_fetch_array($result)) {
                ?>
<tr class="<?=$class?> " id="<?=$i?>">
<td>
                  <a href="javascript:toggleMessage('<?=$i?>');">
                  <img border="0" align="left" id="img_<?=$i?>" src="images/plus.gif">
                  <span style="color:000; float: left; width:190px;"><?echo $row['username']." (".$row['firstname']." ".$row['lastname'].")";?></span>
 
                <?
                $sqln='SELECT * FROM '.TICKET_TABLE.' WHERE staff_id='.$row["staff_id"].'';
                if(($resn=db_query($sqln)) && ($numn=db_num_rows($resn))) {
 
                }
                ?>
                  &nbsp;&nbsp;
                  <span class="Icon <?=$icon?>"><b><?=$numn?></b></span></a>
<div id="msg_<?=$i?>" class="hide">
                        <hr>
 
                <?
 
                $sqlt='SELECT ticketID, ticket_id FROM '.TICKET_TABLE.' WHERE staff_id='.$row["staff_id"].'';
                if(($rest=db_query($sqlt)) && ($numt=db_num_rows($rest))) {
                    $strt='';
                    $it=1;
                    while ($rowt = db_fetch_array($rest)) {
                    if ($it<$numt) {
                        $strt.='<a href="tickets.php?id='.$rowt['ticket_id'].'" target="_blank">'.$rowt['ticketID'].'</a>, ';
                    } elseif ($it>=$numt) {
                        $strt.='<a href="tickets.php?id='.$rowt['ticket_id'].'" target="_blank">'.$rowt['ticketID'].'</a>';
                    }
                    $it++;
                    }
                }
 
                ?>
                  <span style="text-align:left;float:left;"><i><?=$strt?>&nbsp;&nbsp;</i></span></div></td>
</tr>
<?
            $class = ($class =='row2') ?'row1':'row2';
            $i++;
            } //end of while.
        else: //not tickets found!! ?>
<tr class="<?=$class?>">
<td><b>Query returned 0 results.</b></td>
</tr>
<?
        endif; ?></table>
</td>
</tr>
<?
    if($num>0){
    ?>
<tr>
<td style="padding-left:20px">page:<?=$pageNav->getPageLinks()?></td>
</tr>
<?} ?>
    </form></table>
</div>
<?

Ticket for Staff

Artikel Terkait:

Komentar

Thun Chropeckorn mengatakan:

Tuesday, 9 February 2010 pada 08:35:18

Hello Masino,
I’ve been looking for this kind of script for OSticket however I cannot decide if I should use RC5 or RC4. I’ve been using a reporting panel (http://osticket.com/forums/showthread.php?t=1537) to generate statistical data and it has worked well. But your work has lots of potential. Can you improve this script to display ticket summary per month of every staff and department? Also it would be better to include a statistical count of help topics. For example: Auto Paint Department Aug 2010, Paint chipping 3, Paint discoloration 14 etc.

Thanks and God Bless You.

Masino Sinaga mengatakan:

Tuesday, 9 February 2010 pada 11:56:54

@Thun Chropeckorn

Thanks for your feedback. I will try to implement it whenever I had enough time to do that. God bless you, too.

Shinshigumi mengatakan:

Monday, 22 February 2010 pada 08:52:36

Helo sir,

Thank you very much for this mod, as Thun Cropeckorr said, it has more potential so i haven’t try to apply that mod cause i’m waiting for your update which includes graphical representation of data. THANKS! kip safe!

Dale mengatakan:

Thursday, 1 April 2010 pada 00:26:56

Hi, I have implemented this and notice that any tickets that are assigned to somebody, show up under the active tickets in the ticket summary, even though they have been closed..

is that taken care of in the updated versions?

thanks..

and thanks again for your mods… makes osticket a lot more functional

Cuong mengatakan:

Friday, 28 May 2010 pada 10:06:53

Hi Masino,
Please add one more MOD such as ” Post Internal Note” to Dashboard?
Thank you for your help,
Cuong

Cuong mengatakan:

Saturday, 29 May 2010 pada 07:00:31

Corrections:
Hi Masino,
I need a Mod audit ticket and Dashboard to show under Dashboard. ( forget the “Post Internal Note”)
Thank you for your help,

Nino mengatakan:

Tuesday, 24 August 2010 pada 02:38:17

Masino,

I have tried to implement this, but get errors. I have noticed that the “lines” you indicate is different on my side. I do not know if this is because you have other mods done. Anyway, you specify ticket aging in terms of days… Is there a way I can have the aging options in hours? Example,
<=1 hour
<=2 hours
<=5 hours
<=8 hours
<= 24 hours
Select end date -> Preview or export to csv
Closed Tickets : Select start date -> Select end date -> Preview or export to csv
Stale Tickets : Select start date -> Select end date -> Preview or export to csv
etc.

This seems like a much easier option, because then the admin can select the dates/hours.

Your help on this one will be appreciated.

Regards,

Setia Budi Hartawan mengatakan:

Friday, 24 September 2010 pada 19:08:55

Dear Friends.

may I Help to create Report seem SQR Report then Print it. with Header,Column Etc…

Thanks GBU all,
Setia Budi Hartawan

Jack mengatakan:

Sunday, 31 October 2010 pada 02:56:26

Hi,Masino

I’m os 1.6 ST new user , i have try install this mod ,but the Ticket Aging and Ticket for Staff functions have no working ,may i know what the problem ?

Please help ,i have attach the print screen follows:
http://img263.imageshack.us/img263/1498/90355161.png
http://img713.imageshack.us/img713/2271/62536089.png

Have a nice day ,thank you.

Chung mengatakan:

Thursday, 3 March 2011 pada 09:22:41

Great Day Masino,
Have deployed the mod. Hassle free and really look great.
By the way, any mod to enable printing the entire historical thread and internal notes of a ticket with using print screen?

Thank you.

tony mengatakan:

Tuesday, 19 April 2011 pada 17:13:19

exellent easy to implemented worked first time.

Jorg mengatakan:

Friday, 27 May 2011 pada 15:07:13

I followed the instructions very carefully.
First it looked like it didn’t work.
Then I found that the tickets must be ASSIGNED to staff members, otherwise it looks like it doesn’t work…

GREAT MOD!
Thank you!

rashmani mengatakan:

Thursday, 21 July 2011 pada 21:48:11

Hi Masino,
first of all, good job. Then, article says this mod is for OT1.6 RC5: I want to use it with OT1.6, could you confirm nothing has changed since RC5 in setup info as posted?

Thanks,
rash*

rashmani mengatakan:

Thursday, 21 July 2011 pada 22:50:34

@rashmani
Well, I’ve simply tried and everything seems to work a treat!

Thanks again!
Cheers,
rash*

Alex mengatakan:

Tuesday, 26 July 2011 pada 07:59:19

Just installed this MOD. I have over 70 tickets that are OPEN and some are LATE. But the MOD works and only shows 4 active. AM I missing anything here?

Bruno Monteiro mengatakan:

Tuesday, 27 September 2011 pada 20:25:57

Good work and thanks for the MOD.

I have a litle problem on Ticket for Staff, it shows a blank page.

Why??? Can anyone help me?

Doug mengatakan:

Wednesday, 28 December 2011 pada 05:25:54

Thanks, this went in very easy, however, I can’t figure out why closed tickets are showing on the ‘unassigned’ Is there a way to modify the code so that closed tickets are not showed as part of the assigned tickets?

- Doug mengatakan:
  
  Wednesday, 28 December 2011 pada 05:27:22
  
  Typed too fast, sorry, I meant not having closed tickets show up as ‘unassigned’ in the Ticket Summary Report -> Total Number of Unassigned Tickets.
  
- Masino Sinaga mengatakan:
  
  Wednesday, 28 December 2011 pada 13:30:43
  Find this following code in /include/class.ticket.php file:
  $sql= 'UPDATE '.TICKET_TABLE.' SET status='.db_input('closed').',staff_id=0,isoverdue=0,duedate=NULL,updated=NOW(),closed=NOW() '. ' WHERE ticket_id='.db_input($this->getId());
  then replace it with the following:
  $sql= 'UPDATE '.TICKET_TABLE.' SET status='.db_input('closed').',isoverdue=0,duedate=NULL,updated=NOW(),closed=NOW() '. ' WHERE ticket_id='.db_input($this->getId());
  Hope it helps!

Menambahkan Fitur Laporan Ticket Aging, Ticket Summary, dan Ticket untuk Staff ke dalam osTicket v1.6 RC5

Komentar

Utarakan pikiran Anda Cancel reply

Iklan Anda

Bahasa

Referensi Anda

Tulisan Terakhir

Useful Resources

Useful Information

Istilah yang Paling Sering Dicari

Istilah yang Terakhir Dicari

Komentar Terakhir

Donate

Alexa & Page Rank

Blogroll