Don't know if this will help, but I modified \include\staff\tickets.inc.php to show Department name in the staff dashboard instead of 'Assignee', Closed by' etc.
It will also allow you to sort by Department name.
This is not an 'as well as' to the existing field, and only works if you allow the staff to see 'assigned', but fits our purpose.
Replace lines 360-378
original
if($showassigned ) {
//Closed by
if(!strcasecmp($status,'closed')) { ?>
<th width="150">
<a <?php echo $staff_sort; ?> href="tickets.php?sort=staff&order=<?php echo $negorder; ?><?php echo $qstr; ?>"
title="Sort By Closing Staff Name <?php echo $negorder; ?>">Closed By</a></th>
<?php
} else { //assigned to ?>
<th width="150">
<a <?php echo $assignee_sort; ?> href="tickets.php?sort=assignee&order=<?php echo $negorder; ?><?php echo $qstr; ?>"
title="Sort By Assignee <?php echo $negorder;?>">Assigned To</a></th>
<?php
}
} else { ?>
<th width="150">
<a <?php echo $dept_sort; ?> href="tickets.php?sort=dept&order=<?php echo $negorder;?><?php echo $qstr; ?>"
title="Sort By Department <?php echo $negorder; ?>">Department</a></th>
<?php
} ?>
replacement
if($showassigned ) {
//Closed by
if(!strcasecmp($status,'closed')) { ?>
<th width="150">
<a <?php echo $dept_sort; ?> href="tickets.php?sort=dept&order=<?php echo $negorder;?><?php echo $qstr; ?>"
title="Sort By Department <?php echo $negorder; ?>">Department</a></th>
<?php
} else { //assigned to ?>
<th width="150">
<a <?php echo $dept_sort; ?> href="tickets.php?sort=dept&order=<?php echo $negorder;?><?php echo $qstr; ?>"
title="Sort By Department <?php echo $negorder; ?>">Department</a></th>
<?php
}
} else { ?>
<th width="150">
<a <?php echo $dept_sort; ?> href="tickets.php?sort=dept&order=<?php echo $negorder;?><?php echo $qstr; ?>"
title="Sort By Department <?php echo $negorder; ?>">Department</a></th>
<?php
} ?>
edit, oh and lines 396 to 402
original
if($showassigned) {
if($row)
$lc=sprintf('<span class="Icon staffAssigned">%s</span>',Format:($row,40));
elseif($row)
$lc=sprintf('<span class="Icon teamAssigned">%s</span>',Format:($row,40));
else
$lc=' ';
replacement
if($showassigned) {
if($row)
$lc=sprintf(Format:($row,40));
elseif($row)
$lc=sprintf(Format:($row,40));
else
$lc=' ';
At least might give others somewhere to start (or if this is what you need like us, a solution).
