?> <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