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