/**
* \brief Generate the text for this plugin.
*/
function Output()
{
global $PG_CONN;
global $SysConf;
if ($this->State != PLUGIN_STATE_READY) {
return;
}
$user_pk = $SysConf['auth']['UserId'];
/* Get array of groups that this user is an admin of */
$GroupArray = GetGroupArray($user_pk);
$V = "";
/* If this is a POST, then process the request. */
$Group = GetParm('grouppk', PARM_TEXT);
if (!empty($Group)) {
$rc = DeleteGroup($Group);
if (empty($rc)) {
/* Need to refresh the screen */
$text = _("Group");
$text1 = _("Deleted");
$V .= displayMessage("{$text} {$GroupArray[$Group]} {$text1}.");
} else {
$V .= displayMessage($rc);
}
}
/* Build HTML form */
$text = _("Delete a Group");
$V .= "<h4>{$text}</h4>\n";
$V .= "<form name='formy' method='POST' action=" . Traceback_uri() . "?mod=group_delete>\n";
/* Get array of users */
$UserArray = Table2Array('user_pk', 'user_name', 'users');
/* Remove from $GroupArray any active users. A user must always have a group by the same name */
foreach ($GroupArray as $group_fk => $group_name) {
if (array_search($group_name, $UserArray)) {
unset($GroupArray[$group_fk]);
}
}
if (empty($GroupArray)) {
$text = _("You have no groups you can delete.");
echo "<p>{$text}<p>";
return;
}
reset($GroupArray);
if (empty($group_pk)) {
$group_pk = key($GroupArray);
}
$text = _("Select the group to delete: \n");
$V .= "{$text}";
/*** Display group select list, on change request new page with group= in url ***/
$V .= Array2SingleSelect($GroupArray, "grouppk", $group_pk, false, false);
$text = _("Delete");
$V .= "<input type='submit' value='{$text}'>\n";
$V .= "</form>\n";
if (!$this->OutputToStdout) {
return $V;
}
print "{$V}";
return;
}
/**
* \brief Delete a user.
*
* \return NULL on success, string on failure.
*/
function Delete($UserId)
{
global $PG_CONN;
/* See if the user already exists */
$sql = "SELECT * FROM users WHERE user_pk = '{$UserId}' LIMIT 1;";
$result = pg_query($PG_CONN, $sql);
DBCheckResult($result, $sql, __FILE__, __LINE__);
$row = pg_fetch_assoc($result);
pg_free_result($result);
if (empty($row['user_name'])) {
$text = _("User does not exist.");
return $text;
}
/* Delete the users group
* First look up the users group_pk
*/
$sql = "SELECT group_pk FROM groups WHERE group_name = '{$row['user_name']}' LIMIT 1;";
$result = pg_query($PG_CONN, $sql);
DBCheckResult($result, $sql, __FILE__, __LINE__);
$GroupRow = pg_fetch_assoc($result);
pg_free_result($result);
/* Delete all the group user members for this user_pk */
$sql = "DELETE FROM group_user_member WHERE user_fk = '{$UserId}'";
$result = pg_query($PG_CONN, $sql);
DBCheckResult($result, $sql, __FILE__, __LINE__);
pg_free_result($result);
/* Delete the user */
$sql = "DELETE FROM users WHERE user_pk = '{$UserId}';";
$result = pg_query($PG_CONN, $sql);
DBCheckResult($result, $sql, __FILE__, __LINE__);
pg_free_result($result);
/* Now delete their group */
DeleteGroup($GroupRow['group_pk']);
/* Make sure it was deleted */
$sql = "SELECT * FROM users WHERE user_name = '{$UserId}' LIMIT 1;";
$result = pg_query($PG_CONN, $sql);
DBCheckResult($result, $sql, __FILE__, __LINE__);
$rowCount = pg_num_rows($result);
pg_free_result($result);
if ($rowCount != 0) {
$text = _("Failed to delete user.");
return $text;
}
return NULL;
}
exit;
}
if (isset($_GET["KavMilterGroupAddNewRule"])) {
echo GROUP_KAVMILTER_ADD_NEW_RULE($_GET["KavMilterGroupAddNewRule"]);
exit;
}
if (isset($_GET["DansGuardian_rules"])) {
GROUP_DANSGUARDIAN($_GET["DansGuardian_rules"]);
exit;
}
if (isset($_GET["save_dansguardian_rule"])) {
GROUP_DANSGUARDIAN_SAVE();
exit;
}
if (isset($_GET["delgroup"])) {
DeleteGroup();
exit;
}
if (isset($_GET["GetTreeFolders"])) {
browser();
exit;
}
if (isset($_GET["LoadMailingList-js"])) {
GROUP_MAILING_LIST_JS();
exit;
}
if (isset($_GET["LoadMailingList"])) {
GROUP_MAILING_LIST();
exit;
}
if (isset($_GET["RemoveMailingList"])) {
$uidids = GetVariable("uidids");
$seriesids = GetVariable("seriesid");
$studyids = GetVariable("studyid");
$modality = GetVariable("modality");
$itemid = GetVariable("itemid");
$measures = GetVariable("measures");
$columns = GetVariable("columns");
$groupmeasures = GetVariable("groupmeasures");
/* determine action */
switch ($action) {
case 'add':
AddGroup($groupname, $grouptype, $GLOBALS['username']);
DisplayGroupList();
break;
case 'delete': DeleteGroup($id); break;
case 'addsubjectstogroup':
AddSubjectsToGroup($subjectgroupid, $uids, $seriesids, $modality);
ViewGroup($subjectgroupid, $measures, $columns, $groupmeasures);
break;
case 'addstudiestogroup':
AddStudiesToGroup($studygroupid, $seriesids, $studyids, $modality);
ViewGroup($studygroupid, $measures, $columns, $groupmeasures);
break;
case 'addseriestogroup':
AddSeriesToGroup($seriesgroupid, $seriesids, $modality);
ViewGroup($seriesgroupid, $measures, $columns, $groupmeasures);
break;
case 'removegroupitem':
RemoveGroupItem($itemid);
ViewGroup($id, $measures, $columns, $groupmeasures);
exit;
}
if (isset($_GET["ChangeOrg"])) {
echo groupslist($_GET["ChangeOrg"]);
exit;
}
if (isset($_GET["LoadMembers"])) {
echo LoadMembers();
exit;
}
if (isset($_GET["LoadMembersNotAffected"])) {
echo LoadMembersNotAffected();
exit;
}
if (isset($_GET["DeleteGroup"])) {
echo DeleteGroup();
exit;
}
if (isset($_GET["ReloadOrgTable"])) {
echo groupslist($_GET["ReloadOrgTable"]);
exit;
}
if (isset($_GET["LoadDomainSettings"])) {
echo PopUp_DomainTransport();
exit;
}
if (isset($_GET["AddNewInternetDomain"])) {
AddNewInternetDomain();
exit;
}
if (isset($_GET["AddTransportToDomain"])) {
if(isset($_GET["ImportMembersFile"])){MEMBERS_IMPORT_FILE();exit;}
if(isset($_GET["DeleteMembersForGroup"])){GROUP_DELETE_MEMBERS($_GET["DeleteMembersForGroup"]);exit;}
if(isset($_GET["ForbiddenAttach"])){GROUP_ATTACHMENTS($_GET["ForbiddenAttach"]);exit();}
if(isset($_GET["SaveAttachmentGroup"])){FORBIDDEN_ATTACHMENTS_SAVE();exit;}
if(isset($_GET["LoadGroupSettings"])){GROUP_SETTINGS_PAGE();exit;}
if(isset($_GET["group_add_attach_rule"])){FORBIDDEN_ATTACHMENTS_ADDRULE();exit;}
if(isset($_GET["KavMilterGroupAddNewRule"])){echo GROUP_KAVMILTER_ADD_NEW_RULE($_GET["KavMilterGroupAddNewRule"]);exit;}
if(isset($_GET["DansGuardian_rules"])){GROUP_DANSGUARDIAN($_GET["DansGuardian_rules"]);exit;}
if(isset($_GET["save_dansguardian_rule"])){GROUP_DANSGUARDIAN_SAVE();exit;}
if(isset($_GET["delgroup"])){DeleteGroup();exit;}
if(isset($_GET["GetTreeFolders"])){browser();exit;}
if(isset($_GET["LoadMailingList-js"])){GROUP_MAILING_LIST_JS();exit();}
if(isset($_GET["LoadMailingList"])){GROUP_MAILING_LIST();exit();}
if(isset($_GET["RemoveMailingList"])){GROUP_MAILING_LIST_DEL();exit;}
if(isset($_GET["LoadComputerGroup"])){COMPUTERS_LIST();exit;}
if(isset($_GET["FORM_COMPUTER"])){COMPUTER_FORM_ADD();exit;}
if(isset($_GET["find_computer"])){COMPUTER_FIND();exit;}
if(isset($_GET["add_computer_to_group"])){COMPUTER_ADD_TO_GROUP();exit;}
if(isset($_GET["FORM_GROUP"])){GROUP_SAMBA_SETTINGS_TABS();exit;}
if(isset($_GET["FORM_GROUP2"])){GROUP_SAMBA_SETTINGS();exit;}
$uidids = GetVariable("uidids");
$seriesids = GetVariable("seriesid");
$studyids = GetVariable("studyid");
$modality = GetVariable("modality");
$itemid = GetVariable("itemid");
$measures = GetVariable("measures");
$columns = GetVariable("columns");
$groupmeasures = GetVariable("groupmeasures");
/* determine action */
switch ($action) {
case 'add':
AddGroup($groupname, $grouptype, $GLOBALS['username']);
DisplayGroupList();
break;
case 'delete':
DeleteGroup($id);
break;
case 'addsubjectstogroup':
AddSubjectsToGroup($subjectgroupid, $uids, $seriesids, $modality);
ViewGroup($subjectgroupid, $measures, $columns, $groupmeasures);
break;
case 'addstudiestogroup':
AddStudiesToGroup($studygroupid, $seriesids, $studyids, $modality);
ViewGroup($studygroupid, $measures, $columns, $groupmeasures);
break;
case 'addseriestogroup':
AddSeriesToGroup($seriesgroupid, $seriesids, $modality);
ViewGroup($seriesgroupid, $measures, $columns, $groupmeasures);
break;
case 'removegroupitem':
RemoveGroupItem($itemid);
if(!VerifyRights()){
$tpl=new templates();
echo "alert('". $tpl->javascript_parse_text("{ERROR_NO_PRIVS}")."');";
die();exit();
}
if(isset($_GET["groupware-list"])){organization_groupwares_list();exit;}
if(isset($_GET["ajaxmenu"])){echo "<div id='org_main'>";organization_sections();echo "</div>";exit;}
if(isset($_GET["Tree_group_Add_New"])){Tree_group_Add_New();exit;}
if(isset($_GET["ChangeOrg"])){echo groupslist($_GET["ChangeOrg"]);exit;}
if(isset($_GET["LoadMembers"])){echo LoadMembers();exit();}
if(isset($_GET["LoadMembersNotAffected"])){echo LoadMembersNotAffected();exit;}
if(isset($_GET["DeleteGroup"])){echo DeleteGroup();exit;}
if(isset($_GET["ReloadOrgTable"])){echo groupslist($_GET["ReloadOrgTable"]);exit;}
if(isset($_GET["LoadDomainSettings"])){echo PopUp_DomainTransport();exit;}
if(isset($_GET["AddNewInternetDomain"])){AddNewInternetDomain();exit;}
if(isset($_GET["AddTransportToDomain"])){AddTransportToDomain();exit;}
if(isset($_GET["DeleteInternetDomain"])){DeleteInternetDomain();exit;}
if(isset($_GET["SaveTransportDomain"])){SaveTransportDomain();exit;}
if(isset($_GET["LoadAjaxGroup"])){LoadGroupsAjax($_GET["LoadAjaxGroup"]);exit();}
if(isset($_GET["FillGroupTable"])){FillGroupTable();exit;}
if(isset($_GET["LoadDomainList"])){echo LoadDomainsOu($_GET["LoadDomainList"]);exit();}
if(isset($_GET["AddNewInternetDomainMTA"])){AddNewInternetDomainMTA();exit;}
if(isset($_GET["SaveAddNewInternetDomainMTA"])){SaveAddNewInternetDomainMTA();exit;}
if(isset($_GET["DeleteOU"])){DeleteOU();exit;}
if(isset($_GET["org_section"])){organization_sections();exit;}
if(isset($_GET["js"])){js();exit;}
if(isset($_GET["js-pop"])){popup_tabs();exit;}
{
//$e表名称 $f 列名称 $g 值名称 $h 关系表名 $i 关系表列名
$query = mysql_query("SELECT id FROM {$e} WHERE {$f}='{$g}'");
while ($row = mysql_fetch_array($query)) {
$id = $row['id'];
}
mysql_query("DELETE FROM {$h} WHERE {$i}='{$id}'");
mysql_query("DELETE FROM {$e} WHERE {$f}='{$g}'");
mysql_close();
echo "已成功删除" . $g . "分组";
}
switch ($type) {
case 'grade':
DeleteGroup("b_category_grade", "grade", $name, "b_rel_col_grade", "id_category_grade");
break;
case 'college':
DeleteGroup("b_category_college", "college", $name, "b_rel_maj_col", "id_category_college");
break;
case 'major':
DeleteGroup("b_category_major", "major", $name, "b_rel_pro_maj", "id_category_major");
break;
default:
break;
}
} else {
if ($certain == 'server') {
echo "对不起你没有权限";
} else {
echo "cookie保存到期请重新登录";
}
}
if (array_key_exists($selectedGroupID, $_POST)) {
$selectedGroup = $_POST[$selectedGroupID];
}
}
if (array_key_exists($sortDirectionID, $_GET)) {
$sortDirection = $_GET[$sortDirectionID];
} else {
if (array_key_exists($sortDirectionID, $_POST)) {
$sortDirection = $_POST[$sortDirectionID];
}
}
SetGroupSortDirection($sortDirection);
// Are we switching to another page?
CheckForPageSwitch();
// Are we deleting a group?
if (CheckForDeleteSelection() && DeleteGroup($selectedGroup)) {
$confirmationMsg = sprintf($confSuccessfulDeletion, $selectedGroup);
}
} catch (MgException $e) {
CheckForFatalMgException($e);
$errorMsg = $e->GetExceptionMessage();
} catch (Exception $e) {
$errorMsg = $e->getMessage();
}
$groups = GetGroups();
$groupCount = sizeof($groups);
$currPage = GetPageNumber($groups, $selectedGroup, $pageSize);
GetPageRange($currPage, $groupCount, $pageSize, $firstPageIndex, $lastPageIndex);
LoadGroupTable($groupTable, $firstPageIndex, $lastPageIndex, true);
if (!array_key_exists($selectedGroup, $groupTable) && $groupCount > 0) {
$selectedGroup = $groups[$firstPageIndex];
