?>
<a href="workgroup_list.php"><img src="/resources/cancel.png" border="0" alt="Return to workgroup list" title="Return to workgroup list"></a>
<?php
}
?>
<a href="project_add.php"><img src="/resources/add.png" border="0" alt="Add new project" title="Add new project"></a>
<?php
if ($dss_accessLevel > 0) {
?>
<a href="workgroup_edit.php?workgroupId=<?php
echo $dss_currentWorkgroup;
?>
"><img src="/resources/pencil.png" border="0" alt="Edit this workgroup" title="Edit this workgroup"></a>
<?php
}
$char = displayAlphaBar("project", "name", "WHERE workgroupId={$dss_currentWorkgroup}", $char, $dss_displayListSize);
?>
<table class="listing">
<tr><th> </th><th>Name</th><th>Last Updated</th></tr>
<?php
$where = "WHERE workgroupId={$dss_currentWorkgroup}";
if ($char == "#") {
$where .= " AND left(name,1)>='0' AND left(name,1)<='9'";
} elseif ($char != "all") {
$where .= " AND left(name,1)='{$char}'";
}
$projectQuery = db_query("SELECT id,name,lastUpdatedDate FROM project {$where} ORDER BY name");
$projectQuery = db_query("SELECT count(id) AS numItems FROM project {$where}");
$projectResult = db_fetch($projectQuery);
$numItems = $projectResult["numItems"];
$limit = "";
if (trim($_REQUEST["char"]) != "") {
superstore_save("workgroup_list", $dss_sessionCookie, "char", $_REQUEST["char"]);
}
$char = superstore_fetch("workgroup_list", $dss_sessionCookie, "char");
require "resources/header.php";
?>
<h2>Workgroups</h2>
<?php
displayMessages($_REQUEST["infoMessage"], $_REQUEST["errorMessage"], $required);
if ($dss_accessLevel > 0) {
?>
<a href="workgroup_edit.php"><img src="/resources/add.png" border="0" alt="Add new workgroup" title="Add new workgroup"></a>
<?php
$char = displayAlphaBar("workgroup", "name", "", $char, $dss_displayListSize);
} else {
$char = displayAlphaBar("workgroup a, workgroupUser b", "a.name", "WHERE b.userId={$dss_userId} AND b.workgroupId=a.id", $char, $dss_displayListSize);
}
?>
<table class="listing">
<tr><th>Name</th><th>Last Updated</th></tr>
<?php
if ($dss_accessLevel > 0) {
$where = "";
if ($char == "#") {
$where = "WHERE left(name,1)>='0' AND left(name,1)<='9'";
} elseif ($char != "all") {
$where = "WHERE left(name,1)='{$char}'";
}
$workgroupQuery = db_query("SELECT id,name,lastUpdatedDate FROM workgroup {$where} ORDER BY name");
} else {
$where = "";
}
/* Keep track of the char the user is viewing. */
if (trim($_REQUEST["char"]) != "") {
superstore_save("user_list.php", $dss_sessionCookie, "char", $_REQUEST["char"]);
}
$char = superstore_fetch("user_list.php", $dss_sessionCookie, "char");
require "resources/header.php";
?>
<h2>Users</h2>
<?php
displayMessages($_REQUEST["infoMessage"], $_REQUEST["errorMessage"], $required);
?>
<a href="admin.php"><img src="/resources/cancel.png" border="0" alt="Return to admin tools" title="Return to admin tools"></a>
<a href="user_edit.php"><img src="/resources/add.png" border="0" alt="Add new user" title="Add new user"></a>
<?php
$char = displayAlphaBar("user", "lastName", "", $char, $dss_displayListSize);
?>
<table class="listing">
<tr><th>Name</th><th>Access Level</th><th>Last Login</th></tr>
<?php
$where = "";
if ($char == "#") {
$where = " WHERE left(lastName,1)>='0' AND left(lastName,1)<='9'";
} elseif ($char != "all") {
$where = " WHERE left(lastName,1)='{$char}'";
}
$userQuery = db_query("SELECT id,active,accessLevel,lastName,firstName,lastLoginDate FROM user {$where} ORDER BY lastName,firstName");
while ($userResult = db_fetch($userQuery)) {
$name = $userResult["lastName"] . ", " . $userResult["firstName"];
if (!$userResult["active"]) {
$name = "<strike>" . $userResult["lastName"] . ", " . $userResult["firstName"] . "</strike>";
}
/* Keep track of the char the user is viewing. */
if (trim($_REQUEST["char"]) != "") {
superstore_save("group_list.php", $dss_sessionCookie, "char", $_REQUEST["char"]);
}
$char = superstore_fetch("group_list.php", $dss_sessionCookie, "char");
require "resources/header.php";
?>
<h2>Retention Groups</h2>
<?php
displayMessages($_REQUEST["infoMessage"], $_REQUEST["errorMessage"], $required);
?>
<a href="admin.php"><img src="/resources/cancel.png" border="0" alt="Return to admin tools" title="Return to admin tools"></a>
<a href="group_edit.php"><img src="/resources/add.png" border="0" alt="Add new retention group" title="Add new retention group"></a>
<?php
$char = displayAlphaBar("retention", "retentionGroup", "", $char, $dss_displayListSize);
?>
<table class="listing">
<tr><th>Retention Group</th><th>Retention Period</th></tr>
<?php
$where = "";
if ($char == "#") {
$where = " WHERE left(retentionGroup,1)>='0' AND left(retentionGroup,1)<='9'";
} elseif ($char != "all") {
$where = " WHERE left(retentionGroup,1)='{$char}'";
}
$groupQuery = db_query("SELECT id,retentionGroup,retentionPeriod FROM retention {$where} ORDER BY retentionGroup");
while ($groupResult = db_fetch($groupQuery)) {
if ($groupResult["retentionPeriod"] == 999) {
$retentionPeriod = "Indefinite";
} elseif ($groupResult["retentionPeriod"] == 1) {
?>
"><img src="/resources/zip.png" border="0" alt="Add a ZIP archive" title="Add a ZIP archive"></a>
<a href="project_edit.php?projectId=<?php
echo $dss_currentProject;
?>
"><img src="/resources/pencil.png" border="0" alt="Edit this project" title="Edit this project"></a>
<?php
if ($dss_accessLevel > 0) {
?>
<a href="project_sync.php?projectId=<?php
echo $dss_currentProject;
?>
"><img src="/resources/sync.png" border="0" alt="Sync this project" title="Sync this project"></a>
<?php
}
$char = displayAlphaBar("item", "title", "WHERE projectId={$dss_currentProject}", $char, $dss_displayListSize);
$where = "WHERE projectId={$dss_currentProject}";
if ($char == "#") {
$where .= " AND left(title,1)>='0' AND left(title,1)<='9'";
} elseif ($char != "all") {
$where .= " AND left(title,1)='{$char}'";
}
$itemQuery = db_query("SELECT count(id) AS numItems FROM item {$where}");
$itemResult = db_fetch($itemQuery);
$numItems = $itemResult["numItems"];
$limit = "";
if ($char != "all") {
displayPageBar($numItems, $dss_displayListSize, $currentPage);
$start = $currentPage * $dss_displayListSize;
$limit = "LIMIT {$start},{$dss_displayListSize}";
}
}
/* Keep track of the char the user is viewing. */
if (trim($_REQUEST["char"]) != "") {
superstore_save("filetype_list.php", $dss_sessionCookie, "char", $_REQUEST["char"]);
}
$char = superstore_fetch("filetype_list.php", $dss_sessionCookie, "char");
require "resources/header.php";
?>
<h2>Acceptable Filetypes</h2>
<?php
displayMessages($_REQUEST["infoMessage"], $_REQUEST["errorMessage"], $required);
?>
<a href="admin.php"><img src="/resources/cancel.png" border="0" alt="Return to admin tools" title="Return to admin tools"></a>
<a href="filetype_edit.php"><img src="/resources/add.png" border="0" alt="Add new filetype" title="Add new filetype"></a>
<?php
$char = displayAlphaBar("filetype", "extension", "", $char, $dss_displayListSize);
?>
<table class="listing">
<tr><th>Extension</th><th>MIME Type</th></tr>
<?php
$where = "";
if ($char == "#") {
$where = " WHERE left(extension,1)>='0' AND left(extension,1)<='9'";
} elseif ($char != "all") {
$where = " WHERE left(extension,1)='{$char}'";
}
$filetypeQuery = db_query("SELECT id,extension,mimeType FROM filetype {$where} ORDER BY extension");
while ($filetypeResult = db_fetch($filetypeQuery)) {
?>
<tr>
<td><a href="filetype_edit.php?filetypeId=<?php
