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']; ?> ">