function dashboard_holidays($dashletid)
{
global $sit, $CONFIG, $iconset;
global $dbUsers;
$user = $sit[2];
echo "<div class='windowbox' style='width: 95%;' id='{$dashletid}'>";
echo "<div class='windowtitle'>" . icon('holiday', 16) . " {$GLOBALS['strWhosAwayToday']}</div>";
echo "<div class='window'>";
$sql = "SELECT * FROM `{$dbUsers}` WHERE status!=0 AND status!=1 ";
// status=0 means left company
$result = mysql_query($sql);
if (mysql_error()) {
trigger_error("MySQL Query Error " . mysql_error(), E_USER_WARNING);
}
if (mysql_num_rows($result) >= 1) {
while ($users = mysql_fetch_array($result)) {
$title = userstatus_name($users['status']);
$title .= " - ";
if ($users['accepting'] == 'Yes') {
$title .= "{$GLOBALS['strAcceptingIncidents']}";
} else {
$title .= "{$GLOBALS['strNotAcceptingIncidents']}";
}
if (!empty($users['message'])) {
$title .= "\n(" . $users['message'] . ")";
}
echo "<strong>{$users['realname']}</strong>, {$title}";
echo "<br />";
}
} else {
echo "<p align='center'>{$GLOBALS['strNobody']}</p>\n";
}
echo "</div></div></div>";
}
show_dashboard_component(1, $a);
}
echo "</td><td width=\"33%\" valign=\"top\" id='col2'>";
$arr = explode(",", $cols2);
foreach ($arr as $a) {
show_dashboard_component(2, $a);
}
echo "</td></tr></table>\n";
// Users Login Details
echo "<div id='userbar'>";
if (user_accepting($sit[2]) != 'Yes') {
$userstatus = "<span class='error'>{$strNotAcceptingIncidents}</span>";
} else {
$userstatus = "<strong>{$strAcceptingIncidents}</strong>";
}
echo sprintf($strLoggedInAsXAndCurrentlyXAndX, "<strong>{$sit[0]}</strong>", "<strong>" . userstatus_name(user_status($sit[2])) . "</strong>", $userstatus);
if ($sit[3] == 'public') {
echo "- {$strPublicSharedComputerIncreasedSecurity}";
}
echo "</div>\n";
?>
<script type="text/javascript">
/* <![CDATA[ */
//var cols = [1,3,1];
var cols = [<?php
echo $colstr;
?>
];
var cols0 = [<?php
echo $cols0;
?>
} else {
echo "<td class='expired'> </td>";
}
echo "<td>";
// Have a look if this user has skills with this software
$ssql = "SELECT softwareid FROM `{$dbUserSoftware}` ";
$ssql .= "WHERE userid='{$userrow['id']}' AND softwareid='{$software}' ";
$sresult = mysql_query($ssql);
if (mysql_num_rows($sresult) >= 1) {
echo "<strong>{$userrow['realname']}</strong>";
} else {
echo $userrow['realname'];
}
echo "</td>";
echo "<td>" . $userrow['phone'] . "</td>";
echo "<td>" . user_online_icon($userrow['id']) . " " . userstatus_name($userrow['status']) . "</td>";
echo "<td>" . $userrow['message'] . "</td>";
echo "<td align='center'>";
$incpriority = user_incidents($userrow['id']);
$countincidents = $incpriority['1'] + $incpriority['2'] + $incpriority['3'] + $incpriority['4'];
if ($countincidents >= 1) {
$countactive = user_activeincidents($userrow['id']);
} else {
$countactive = 0;
}
$countdiff = $countincidents - $countactive;
echo "{$countactive} / {$countdiff}</td>";
echo "<td align='center'>" . $incpriority['4'] . "</td>";
echo "<td align='center'>" . $incpriority['3'] . "</td>";
echo "<td align='center'>" . $incpriority['2'] . "</td>";
echo "<td align='center'>" . $incpriority['1'] . "</td>";
// AWAY TODAY
if ($user == $sit[2]) {
// Only show when viewing your own holiday page
$sql = "SELECT * FROM `{$dbUsers}` ";
$sql .= "WHERE status!=" . USERSTATUS_ACCOUNT_DISABLED;
$sql .= " AND status!=" . USERSTATUS_IN_OFFICE . " ";
$result = mysql_query($sql);
if (mysql_error()) {
trigger_error("MySQL Query Error " . mysql_error(), E_USER_WARNING);
}
echo "<table align='center' width='450'>";
echo "<tr><th align='right'>{$strWhosAwayToday}</th></tr>\n";
if (mysql_num_rows($result) >= 1) {
while ($users = mysql_fetch_object($result)) {
echo "<tr><td class='shade2'>";
$title = userstatus_name($users->status);
$title .= " - ";
if ($users->accepting == 'Yes') {
$title .= "{$GLOBALS['strAcceptingIncidents']}";
} else {
$title .= "{$GLOBALS['strNotAcceptingIncidents']}";
}
if (!empty($users->message)) {
$title .= "\n({$users->message})";
}
echo "<strong>{$users->realname}</strong>, {$title}";
echo "</td></tr>\n";
}
} else {
echo "<tr class='shade2'><td><em>{$strNobody}</em></td></tr>\n";
}
while ($users = mysql_fetch_object($result)) {
echo "<tr class='{$shade}'>";
echo "<td><label><input type='radio' name='userid' value='{$users->id}' /> ";
// Have a look if this user has skills with this software
$ssql = "SELECT softwareid FROM `{$dbUserSoftware}` WHERE userid={$users->id} AND softwareid={$incident->softwareid} ";
$sresult = mysql_query($ssql);
if (mysql_error()) {
trigger_error("MySQL Query Error " . mysql_error(), E_USER_WARNING);
}
if (mysql_num_rows($sresult) >= 1) {
echo "<strong>{$users->realname}</strong>";
} else {
echo $users->realname;
}
echo "</label></td>";
echo "<td>" . user_online_icon($users->id) . userstatus_name($users->status) . "</td>";
$incpriority = user_incidents($users->id);
$countincidents = $incpriority['1'] + $incpriority['2'] + $incpriority['3'] + $incpriority['4'];
if ($countincidents >= 1) {
$countactive = user_activeincidents($users->id);
} else {
$countactive = 0;
}
$countdiff = $countincidents - $countactive;
echo "<td align='center'>{$countactive} / {$countdiff}</td>";
echo "<td align='center'>" . $incpriority['4'] . "</td>";
echo "<td align='center'>" . $incpriority['3'] . "</td>";
echo "<td align='center'>" . $incpriority['2'] . "</td>";
echo "<td align='center'>" . $incpriority['1'] . "</td>";
echo "<td align='center'>";
echo $users->accepting == 'Yes' ? $strYes : "<span class='error'>{$strNo}</span>";
echo $strNone;
} else {
echo $users->phone;
}
echo "</td>";
echo "<td align='center'>";
if ($users->mobile == '') {
echo $strNone;
} else {
echo $users->mobile;
}
echo "</td>";
echo "<td align='left'>";
//see if the users has been active in the last 30mins
echo user_online_icon($users->id) . " ";
echo userstatus_name($users->status);
echo "</td><td align='center'>";
if ($users->accepting == 'Yes') {
echo $strYes;
} else {
echo "<span class='error'>{$strNo}</span>";
}
echo "</td><td>";
echo "<a href='holidays.php?user={$users->id}' title='{$strHolidays}'>";
echo icon('holiday', 16, $strHolidays) . "</a> ";
echo "<a href='tasks.php?user={$users->id}' title='{$strTasks}'>";
echo icon('task', 16, $strTask) . "</a> ";
$sitesql = "SELECT COUNT(id) FROM `{$dbSites}` WHERE owner='{$users->id}'";
$siteresult = mysql_query($sitesql);
if (mysql_error()) {
trigger_error(mysql_error(), E_USER_WARNING);
$rhtml .= "<td>";
if ($backupid >= 1) {
$rhtml .= "<a href=\"javascript:wt_winpopup('incident_reassign.php?id={$assign->id}&reason={$reason}&backupid={$backupid}&asktemp=temporary&popup=yes','mini');\" title='{$strReassignTo} {$backupname}'>{$strAssignToBackup}</a> | ";
}
$rhtml .= "<a href=\"javascript:wt_winpopup('incident_reassign.php?id={$assign->id}&reason={$reason}&asktemp=temporary&popup=yes','mini');\" title='{$strReassign}'>{$strAssignToOther}</a> | <a href='set_user_status.php?mode=deleteassign&incidentid={$assign->incidentid}&originalowner={$assign->originalowner}' title='{$strIgnoreThisAndDelete}'>{$strIgnore}</a></td>";
$rhtml .= "</tr>\n";
} elseif ($assign->owner != $assign->originalowner and $useraccepting == 'yes') {
$show = TRUE;
// display a row to assign the incident back to the original owner
$rhtml .= "<tr class='shade2'>";
$rhtml .= "<td>" . ldate($CONFIG['dateformat_datetime'], $assign->lastupdated) . "</td>";
$rhtml .= "<td>" . user_realname($assign->owner, TRUE) . "</td>";
$rhtml .= "<td>[<a href=\"javascript:wt_winpopup('incident_details.php?id={$assign->id}&popup=yes', 'mini')\">{$assign->id}</a>] {$assign->title}</td>";
$userstatus = user_status($assign->originalowner);
$userstatusname = userstatus_name($userstatus);
$origstatus = userstatus_name($assign->userstatus);
$usermessage = user_message($assign->originalowner);
$username = user_realname($assign->owner, TRUE);
$rhtml .= "<td>" . sprintf($strOwnerXAcctingAgain, $userstatusname) . "<br />{$usermessage}</td>";
$originalname = user_realname($assign->originalowner, TRUE);
$reason = urlencode(trim("{$originalname} is now accepting incidents again. Previous status {$origstatus} and not accepting."));
// FIXME i18n
$rhtml .= "<td>";
$rhtml .= "<a href=\"javascript:wt_winpopup('incident_reassign.php?id={$assign->id}&reason={$reason}&originalid={$assign->originalowner}&popup=yes','mini');\" title='{$strReassignTo} {$originalname}'>{$strReturnToOriginalOwner}</a> | ";
$rhtml .= "<a href=\"javascript:wt_winpopup('incident_reassign.php?id={$assign->id}&reason={$reason}&asktemp=temporary&popup=yes','mini');\" title='{$strAssignToOther}'>{$strAssignToOther}</a> | <a href='set_user_status.php?mode=deleteassign&incidentid={$assign->incidentid}&originalowner={$assign->originalowner}' title='{$strIgnoreThisAndDelete}'>{$strIgnore}</a></td>";
$rhtml .= "</tr>\n";
}
}
$rhtml .= "</table>\n";
}
if ($show) {
trigger_error("MySQL Query Error " . mysql_error(), E_USER_WARNING);
}
$supportopen = mysql_num_rows($result);
mysql_free_result($result);
$sql = "SELECT * FROM `{$dbUsers}` WHERE var_monitor='true' ";
$result = mysql_query($sql);
if (mysql_error()) {
trigger_error("MySQL Query Error " . mysql_error(), E_USER_WARNING);
}
$row = 1;
$col = 1;
$count = 1;
echo "<table summary=\"users\" width=\"100%\" height=\"100%\" align='center'><tr>";
while ($users = mysql_fetch_array($result)) {
$outstanding = user_countincidents($users['id']);
$userstatus = userstatus_name($users['status']);
$useraccepting = strtolower($users['accepting']);
$waiting = count_incoming_updates();
$incidents_color = 'Blue';
if ($outstanding >= 10) {
$incidents_color = 'Red';
}
if ($outstanding < 5) {
$incidents_color = '#00BB00';
}
$name_color = 'Blue';
?>
<td><table summary="<?php
echo $users['realname'];
?>
">
