📄 index.php
字号:
<?
include_once 'inc/auth.php';
echo '
<html>
<head>
<title>分组管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script>
function delete_group(GROUP_ID)
{
msg=\'确认要删除该分组么？\\n注意：该分组下的联系人将全部转入到默认分组中！\';
if(window.confirm(msg))
{
URL="delete.php?GROUP_ID=" + GROUP_ID;
window.location=URL;
}
}
function clear_group(GROUP_ID,GROUP_NAME)
{
msg=\'确认要清空[\'+GROUP_NAME+\']分组的联系人么？\';
if(window.confirm(msg))
{
URL="clear.php?GROUP_ID=" + GROUP_ID;
window.location=URL;
}
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_new.gif" align="absmiddle"><span class="big3"> 新建分组</span><br>
</td>
</tr>
</table>
<div align="center">
<input type="button" value="新建分组" class="BigButton" onClick="location=\'new.php\';" title="创建新的分组，录入相关信息">
</div>
<br>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_open.gif" align="absmiddle"><span class="big3"> 管理分组</span>
</td>
</tr>
</table>
<br>
<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableData">
<td nowrap align="center">默认</td>
<td nowrap align="center">全体部门</td>
<td nowrap align="center">全体角色</td>
<td nowrap align="center">全体人员</td>
<td>
<a href="javascript:clear_group(\'0\',\'默认\');"> 清空</a>
<a href="import.php?GROUP_ID=0"> 导入</a>
<a href="print.php?GROUP_ID=0" target="_blank"> 打印</a><br>
<a href="export.php?GROUP_ID=0&TYPE=0" target="_blank"> 导出Foxmail格式</a>
<a href="export.php?GROUP_ID=0&TYPE=1" target="_blank"> 导出OutLook格式</a>
</td>
</tr>
';
$query = 'SELECT * from ADDRESS_GROUP where USER_ID=\'\' order by GROUP_NAME asc';
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$GROUP_ID = $ROW['GROUP_ID'];
$GROUP_NAME = $ROW['GROUP_NAME'];
$PRIV_DEPT = $ROW['PRIV_DEPT'];
$PRIV_ROLE = $ROW['PRIV_ROLE'];
$PRIV_USER = $ROW['PRIV_USER'];
if ($PRIV_DEPT == 'ALL_DEPT')
{
$PRIV_DEPT_STR = '全体部门';
}
else
{
$PRIV_DEPT_STR = '';
$TOK = strtok ($PRIV_DEPT, ',');
while ($TOK != '')
{
if ($PRIV_DEPT_STR != '')
{
$PRIV_DEPT_STR .= ',';
}
$query1 = 'select * from DEPARTMENT where DEPT_ID=\'' . $TOK . '\'';
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$PRIV_DEPT_STR .= $ROW['DEPT_NAME'];
}
$TOK = strtok (',');
}
}
$PRIV_ROLE_STR = '';
$TOK = strtok ($PRIV_ROLE, ',');
while ($TOK != '')
{
if ($PRIV_ROLE_STR != '')
{
$PRIV_ROLE_STR .= ',';
}
$query1 = 'select * from USER_PRIV where USER_PRIV=\'' . $TOK . '\'';
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$PRIV_ROLE_STR .= $ROW['PRIV_NAME'];
}
$TOK = strtok (',');
}
$PRIV_USER_STR = '';
$TOK = strtok ($PRIV_USER, ',');
while ($TOK != '')
{
if ($PRIV_USER_STR != '')
{
$PRIV_USER_STR .= ',';
}
$query1 = 'select * from USER where USER_ID=\'' . $TOK . '\'';
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$PRIV_USER_STR .= $ROW['USER_NAME'];
}
$TOK = strtok (',');
}
echo ' <tr class="TableData">
<td nowrap align="center">';
echo $GROUP_NAME;
echo '</td>
<td align="center">';
echo $PRIV_DEPT_STR;
echo '</td>
<td align="center">';
echo $PRIV_ROLE_STR;
echo '</td>
<td align="center">';
echo $PRIV_USER_STR;
echo '</td>
<td>
<a href="edit.php?GROUP_ID=';
echo $GROUP_ID;
echo '"> 编辑</a>
<a href="javascript:delete_group(';
echo $GROUP_ID;
echo ');"> 删除</a>
<a href="javascript:clear_group(\'';
echo $GROUP_ID;
echo '\',\'';
echo $GROUP_NAME;
echo '\');"> 清空</a>
<a href="import.php?GROUP_ID=';
echo $GROUP_ID;
echo '"> 导入</a><br>
<a href="print.php?GROUP_ID=';
echo $GROUP_ID;
echo '" target="_blank"> 打印</a>
<a href="export.php?GROUP_ID=';
echo $GROUP_ID;
echo '&TYPE=0" target="_blank"> 导出Foxmail格式</a>
<a href="export.php?GROUP_ID=';
echo $GROUP_ID;
echo '&TYPE=1" target="_blank"> 导出OutLook格式</a>
</td>
</tr>
';
}
echo ' <thead class="TableHeader">
<td nowrap align="center">分组名称</td>
<td nowrap align="center">开放部门</td>
<td nowrap align="center">开放角色</td>
<td nowrap align="center">开放人员</td>
<td nowrap align="center" width="300">操作</td>
</thead>
</table>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -