⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 index.php

📁 通达OA2007SE源代码 非常好的
💻 PHP
字号:
<?
  include_once 'inc/auth.php';
  echo '
<html>
<head>
<title>分组管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript>
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;';
  echo '
     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">';
  echo '<s';
  echo 'pan 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">';
  echo '<s';
  echo 'pan 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_g';
  echo 'roup(\'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 + -