?>
"><?php
echo $row['users'];
?>
</a>
<?php
} else {
?>
0
<?php
}
?>
</td>
<td><?php
echo Format::db_date($row['created']);
?>
</td>
<td><?php
echo Format::db_datetime($row['updated']);
?>
</td>
</tr>
<?php
}
//end of while.
}
?>
<tfoot>
<tr>
<td colspan="7">
value="<?php echo $row['id']; ?>" <?php echo $sel?'checked="checked"':''; ?> >
</td>
<td>
<a class="userPreview"
href="users.php?id=<?php echo $row['id']; ?>"><?php
echo Format::htmlchars($name); ?></a>
<?php
if ($row['tickets'])
echo sprintf('<i class="icon-fixed-width icon-file-text-alt"></i>
<small>(%d)</small>', $row['tickets']);
?>
</td>
<td><?php echo Format::htmlchars($row['email']); ?></td>
<td><?php echo $status; ?></td>
<td><?php echo Format::db_date($row['created']); ?></td>
</tr>
<?php
} //end of while.
endif; ?>
</tbody>
<tfoot>
<tr>
<td colspan="5">
<?php
if ($res && $num) {
?>
<?php echo __('Select'); ?>:
<a id="selectAll" href="#ckb"><?php echo __('All'); ?></a>
<a id="selectNone" href="#ckb"><?php echo __('None'); ?></a>
<a id="selectToggle" href="#ckb"><?php echo __('Toggle'); ?></a>
?>
</a>
<?php
echo $row['attachments'] ? "<span class='Icon file'> </span>" : '';
?>
</td>
<td nowrap> <?php
echo Format::truncate($dept, 30);
?>
</td>
<td> <?php
echo Format::truncate($row['email'], 40);
?>
</td>
<td> <?php
echo Format::db_date($row['duedate'], 40);
?>
</td>
</tr>
<?php
$class = $class == 'row2' ? 'row1' : 'row2';
}
//end of while.
} else {
//not tickets found!!
?>
<tr class="<?php
echo $class;
?>
"><td colspan=7><b>NO tickets found.</b></td></tr>
<h2>Frequently Asked Questions</h2>
</div>
<div style="float:right;text-align:right;padding-top:5px;padding-right:5px;"> </div>
<div class="clear"></div>
<br>
<div>
<strong><?php
echo $category->getName();
?>
</strong>
<span>(<?php
echo $category->isPublic() ? 'Public' : 'Internal';
?>
)</span>
<time>Last updated <?php
echo Format::db_date($category->getUpdateDate());
?>
</time>
</div>
<div class="cat-desc">
<?php
echo Format::display($category->getDescription());
?>
</div>
<?php
if ($thisstaff->canManageFAQ()) {
echo sprintf('<div class="cat-manage-bar"><a href="categories.php?id=%d" class="Icon editCategory">Edit Category</a>
<a href="categories.php" class="Icon deleteCategory">Delete Category</a>
<a href="faq.php?cid=%d&a=add" class="Icon newFAQ">Add New FAQ</a></div>', $category->getId(), $category->getId());
} else {
?>
$subject = Format::truncate($row['subject'],40);
if(!strcasecmp($row['status'],'open') && !$row['isanswered'] && !$row['lock_id']) {
$tid=sprintf('<b>%s</b>',$tid);
//$subject=sprintf('<b>%s</b>',Format::truncate($row['subject'],40)); // Making the subject bold is too much for the eye
}
?>
<tr class="<?=$class?> " id="<?=$row['ticket_id']?>">
<?if($canDelete || $canClose) {?>
<td align="center" class="nohover">
<input type="checkbox" name="tids[]" value="<?=$row['ticket_id']?>" onClick="highLight(this.value,this.checked);">
</td>
<?}?>
<td align="center" title="<?=$row['email']?>" nowrap>
<a class="Icon <?=strtolower($row['source'])?>Ticket" title="<?=$row['source']?> Ticket: <?=$row['email']?>"
href="tickets.php?id=<?=$row['ticket_id']?>"><?=$tid?></a></td>
<td align="center" nowrap><?=Format::db_date($row['created'])?></td>
<td><a <?if($flag) { ?> class="Icon <?=$flag?>Ticket" title="<?=ucfirst($flag)?> Ticket" <?}?>
href="tickets.php?id=<?=$row['ticket_id']?>"><?=$subject?></a>
<?=$row['attachments']?"<span class='Icon file'> </span>":''?></td>
<td nowrap><?=Format::truncate($row['dept_name'],30)?></td>
<td class="nohover" align="center" style="background-color:<?=$row['priority_color']?>;"><?=$row['priority_desc']?></td>
<td nowrap><?=Format::truncate($row['name'],22,strpos($row['name'],'@'))?> </td>
</tr>
<?
$class = ($class =='row2') ?'row1':'row2';
} //end of while.
else: //not tickets found!! ?>
<tr class="<?=$class?>"><td colspan=8><b>Query returned 0 results.</b></td></tr>
<?
endif; ?>
</table>
?>
</a> </td>
<td><?php
echo Format::htmlchars($name);
?>
</td>
<td><?php
echo $row['client_organization'];
?>
</td>
<td><?php
echo $row['client_isactive'] ? _('Active') : '<b>' . _('Locked') . '</b>';
?>
</td>
<td><?php
echo Format::db_date($row['client_created']);
?>
</td>
<td><?php
echo Format::db_datetime($row['client_lastlogin']);
?>
</td>
</tr>
<?php
$class = $class == 'row2' ? 'row1' : 'row2';
}
//end of while.
} else {
?>
<tr class="<?php
?>
"><?php
echo $ticketID;
?>
</a></td>
<td align="center" nowrap><?php
echo Format::db_date($row['created']);
?>
</td>
<td align="center">
<?php
if ($row['status'] == 'closed') {
echo "<span class='Icon closedTicket' title='" . _('Closed on ') . Format::db_date($row['closed']) . "'> </span>";
} elseif ($row['isanswered'] && !strcasecmp($row['status'], 'open')) {
echo "<span class='Icon answeredTicket' title='" . _('Open - Answered on ') . Format::db_date($row['lastresponse']) . "'> </span>";
} else {
echo "<span class='Icon openTicket' title=" . _('Open') . "> </span>";
}
?>
</td>
<td nowrap> <?php
echo Format::truncate($dept, 30);
?>
</td>
<td>
<a href="tickets.php?id=<?php
echo $row['ticketID'];
?>
"><?php
echo $subject;
$sel=false;
if(($uids && in_array($row['staff_id'],$uids)) or ($uID && $uID==$row['staff_id'])){
$class="$class highlight";
$sel=true;
}
$name=ucfirst($row['firstname'].' '.$row['lastname']);
?>
<tr class="<?=$class?>" id="<?=$row['staff_id']?>">
<td width=7px>
<input type="checkbox" name="uids[]" value="<?=$row['staff_id']?>" <?=$sel?'checked':''?> onClick="highLight(this.value,this.checked);">
<td><a href="admin.php?t=staff&id=<?=$row['staff_id']?>"><?=Format::htmlchars($name)?></a> </td>
<td><?=$row['username']?></td>
<td><?=$row['isactive']?'Active':'<b>Locked</b>'?> <?=$row['onvacation']?'(<i>vacation</i>)':''?></td>
<td><a href="admin.php?t=grp&id=<?=$row['group_id']?>"><?=Format::htmlchars($row['group_name'])?></a></td>
<td><a href="admin.php?t=dept&id=<?=$row['dept_id']?>"><?=Format::htmlchars($row['dept_name'])?></a></td>
<td><?=Format::db_date($row['created'])?></td>
<td><?=Format::db_datetime($row['lastlogin'])?> </td>
</tr>
<?
$class = ($class =='row2') ?'row1':'row2';
} //end of while.
else: ?>
<tr class="<?=$class?>"><td colspan=8><b>Query returned 0 results</b></td></tr>
<?
endif; ?>
</table>
</td></tr>
<?
if(db_num_rows($users)>0): //Show options..
?>
<tr><td>
if($tickets_res && ($num=db_num_rows($tickets_res))):
$defaultDept=Dept::getDefaultDeptName();
while ($row = db_fetch_array($tickets_res)) {
$dept=$row['ispublic']?$row['dept_name']:$defaultDept; //Don't show hidden/non-public depts.
$subject=Format::htmlchars(Format::truncate($row['subject'],40));
$ticketID=$row['ticketID'];
if($row['isanswered'] && !strcasecmp($row['status'],'open')) {
$subject="<b>$subject</b>";
$ticketID="<b>$ticketID</b>";
}
?>
<tr class="<?=$class?> " id="<?=$row['ticketID']?>">
<td align="center" title="<?=$row['email']?>" nowrap>
<a class="Icon <?=strtolower($row['source'])?>Ticket" title="<?=$row['email']?>" href="view.php?id=<?=$row['ticketID']?>">
<?=$ticketID?></a></td>
<td nowrap> <?=Format::db_date($row['created'])?></td>
<td> <?=ucfirst($row['status'])?></td>
<td> <a href="view.php?id=<?=$row['ticketID']?>"><?=$subject?></a>
<?=$row['attachments']?"<span class='Icon file'> </span>":''?></td>
<td nowrap> <?=Format::truncate($dept,30)?></td>
<td> <?=Format::truncate($row['email'],40)?></td>
</tr>
<?
$class = ($class =='row2') ?'row1':'row2';
} //end of while.
else: //not tickets found!! ?>
<tr class="<?=$class?>"><td colspan=7><b>NO tickets found.</b></td></tr>
<?
endif; ?>
</table>
</td></tr>
