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

📄 show_reader.php

📁 通达OA2007SE源代码 非常好的
💻 PHP
字号:
<?
  function child_in_toid ($TO_ID, $DEPT_ID)
  {
    global $connection;
    $query = ((''.'SELECT DEPT_ID,DEPT_NAME from DEPARTMENT where DEPT_PARENT=').$DEPT_ID);
    $cursor = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor))
    {
      $DEPT_ID = $ROW['DEPT_ID'];
      $DEPT_NAME = $ROW['DEPT_NAME'];
      if (find_id ($TO_ID, $DEPT_ID))
      {
        return 1;
      }
      if (child_in_toid ($TO_ID, $DEPT_ID))
      {
        return 1;
        continue;
      }
    }
  }
  function dept_tree_list ($DEPT_ID, $PRIV_OP)
  {
    global $connection;
    global $DEEP_COUNT;
    global $READERS;
    global $TO_ID;
    global $READ_COUNT;
    global $UN_READ_COUNT;
    global $USER_ID_TO;
    global $PRIV_ID;
    global $TO_ID_REAL;
    global $DISPLAY_ALL;
    $query = (((''.'SELECT * from DEPARTMENT where DEPT_PARENT=').$DEPT_ID).' order by DEPT_NO');
    $cursor = exequery ($connection, $query);
    $OPTION_TEXT = '';
    $DEEP_COUNT1 = $DEEP_COUNT;
    ($DEEP_COUNT .= ' ');
    while ($ROW = mysql_fetch_array ($cursor))
    {
      ++$COUNT;
      $DEPT_ID = $ROW['DEPT_ID'];
      $DEPT_NAME = $ROW['DEPT_NAME'];
      $DEPT_PARENT = $ROW['DEPT_PARENT'];
      $TEL_NO = $ROW['TEL_NO'];
      $FAX_NO = $ROW['FAX_NO'];
      $DEPT_FUNC = $ROW['DEPT_FUNC'];
      if (((($TO_ID != 'ALL_DEPT') AND !find_id ($TO_ID, $DEPT_ID)) AND !child_in_toid ($TO_ID, $DEPT_ID)))
      {
        continue;
      }
      else
      {
        $DEPT_NAME = htmlspecialchars ($DEPT_NAME);
        $DEPT_PRIV = 1;
        $OPTION_TEXT_CHILD = dept_tree_list ($DEPT_ID, $PRIV_OP);
        $UN_USER = '';
        $USER_NAME_STR = '';
        if ((($TO_ID == 'ALL_DEPT') OR find_id ($TO_ID, $DEPT_ID)))
        {
          $query = (((''.'select USER_ID,USER_PRIV,USER_NAME from USER where DEPT_ID=').$DEPT_ID).' and NOT_LOGIN=\'0\' order by USER_NO,USER_NAME');
          $cursor1 = exequery ($connection, $query);
          while ($ROW1 = mysql_fetch_array ($cursor1))
          {
            $USER_ID = $ROW1['USER_ID'];
            $USER_PRIV = $ROW1['USER_PRIV'];
            $USER_NAME = $ROW1['USER_NAME'];
            if (find_id ($READERS, $USER_ID))
            {
              ($USER_NAME_STR .= ($USER_NAME.','));
              ++$READ_COUNT;
              continue;
            }
            else
            {
              if (((((($TO_ID == 'ALL_DEPT') OR find_id ($TO_ID_REAL, $DEPT_ID)) OR child_in_toid ($TO_ID_REAL, $DEPT_ID)) OR find_id ($PRIV_ID, $USER_PRIV)) OR find_id ($USER_ID_TO, $USER_ID)))
              {
                ($UN_USER .= ($USER_NAME.','));
                ++$UN_READ_COUNT;
                continue;
              }
              continue;
            }
          }
          $USER_NAME_STR = substr ($USER_NAME_STR, 0, -2);
          $UN_USER = substr ($UN_USER, 0, -2);
        }
        if (($DISPLAY_ALL == ''))
        {
          $READ_LEN = 30;
          $UNREAD_LEN = 30;
        }
        else
        {
          $READ_LEN = strlen ($USER_NAME_STR);
          $UNREAD_LEN = strlen ($UN_USER);
        }
        if (($DEPT_PRIV == 1))
        {
          ($OPTION_TEXT .= (((((((((('
  <tr class=TableData>
    <td class="TableContent">'.$DEEP_COUNT1).'├').$DEPT_NAME).(((''.'</td>
    <td style="cursor:hand" title="').$USER_NAME_STR).'">')).csubstr (strip_tags ($USER_NAME_STR), 0, $READ_LEN)).(($READ_LEN < strlen ($USER_NAME_STR)) ? '...' : '')).(((''.'</td>
    <td style="cursor:hand" title="').$UN_USER).'">')).csubstr (strip_tags ($UN_USER), 0, $UNREAD_LEN)).(($UNREAD_LEN < strlen ($UN_USER)) ? '...' : '')).'</td>
  </tr>'));
        }
        if (($OPTION_TEXT_CHILD != ''))
        {
          ($OPTION_TEXT .= $OPTION_TEXT_CHILD);
          continue;
        }
        continue;
      }
    }
    $DEEP_COUNT = $DEEP_COUNT1;
    return $OPTION_TEXT;
  }
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title>公告通知查阅情况</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript>
function delete_reader(NOTIFY_ID)
{
 msg=\'确认要清空查阅情况么?\';
 if(window.confirm(msg))
 {
  URL="delete_reader.php?NOTIFY_ID=" + NOTIFY_ID;
  window.location=URL;
 }
}
</script>
</head>
';
  $query = ((''.'SELECT * from NOTIFY where NOTIFY_ID=').$NOTIFY_ID);
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $SUBJECT = $ROW['SUBJECT'];
    $FROM_ID = $ROW['FROM_ID'];
    $TO_ID = $ROW['TO_ID'];
    $TO_ID_REAL = $ROW['TO_ID'];
    $PRIV_ID = $ROW['PRIV_ID'];
    $USER_ID_TO = $ROW['USER_ID'];
    $READERS = $ROW['READERS'];
    $BEGIN_DATE = $ROW['BEGIN_DATE'];
    $BEGIN_DATE = strtok ($BEGIN_DATE, ' ');
    $query1 = (((''.'SELECT * from USER where USER_ID=\'').$FROM_ID).'\'');
    $cursor1 = exequery ($connection, $query1);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $FROM_NAME = $ROW['USER_NAME'];
      $DEPT_ID = $ROW['DEPT_ID'];
      $DEPT_NAME = dept_long_name ($DEPT_ID);
    }
  }
  if (($TO_ID != 'ALL_DEPT'))
  {
    $TOK = strtok ($PRIV_ID, ',');
    while (($TOK != ''))
    {
      $query1 = (((''.'SELECT DEPT_ID from USER where USER_PRIV=\'').$TOK).'\' and NOT_LOGIN=\'0\'');
      $cursor1 = exequery ($connection, $query1);
      while ($ROW = mysql_fetch_array ($cursor1))
      {
        $DEPT_ID = $ROW['DEPT_ID'];
        if (!find_id ($TO_ID, $DEPT_ID))
        {
          ($TO_ID .= ($DEPT_ID.','));
          continue;
        }
      }
      $TOK = strtok (',');
    }
  }
  if (($TO_ID != 'ALL_DEPT'))
  {
    $TOK = strtok ($USER_ID_TO, ',');
    while (($TOK != ''))
    {
      $query1 = (((''.'SELECT DEPT_ID from USER where USER_ID=\'').$TOK).'\'');
      $cursor1 = exequery ($connection, $query1);
      if ($ROW = mysql_fetch_array ($cursor1))
      {
        $DEPT_ID = $ROW['DEPT_ID'];
        if (!find_id ($TO_ID, $DEPT_ID))
        {
          ($TO_ID .= ($DEPT_ID.','));
        }
      }
      $TOK = strtok (',');
    }
  }
  echo '<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/notify.gif" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3"> 查阅情况</span>
      &nbsp;&nbsp;&nbsp;<input type="button" value="清空查阅情况" class="SmallButton" onclick="delete_reader(';
  echo $NOTIFY_ID;
  echo ');">
      &nbsp;&nbsp;<input type="button" value="完整显示查阅情况" class="SmallButton" onclick="location=\'';
  echo $REQUEST_URI;
  echo '&DISPLAY_ALL=1\'">
    </td>
    </tr>
</table>
';
  $READ_COUNT = $UN_READ_COUNT = 0;
  $OPTION_TEXT = dept_tree_list (0, 0);
  if (($OPTION_TEXT == ''))
  {
    message ('提示', '无人查阅');
  }
  else
  {
    echo '  <table border="0" align="center" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
    <tr>
      <td class="TableHeader" align="center" colspan="3">';
    echo $SUBJECT;
    echo '</td>
    </tr>
    <tr>
      <td class="TableContent" align="right" colspan="3">
      <u title="部门:';
    echo $DEPT_NAME;
    echo '" style="cursor:hand">';
    echo $FROM_NAME;
    echo '</u>&nbsp;&nbsp;
      发布于:<i>';
    echo $BEGIN_DATE;
    echo '</i>
      </td>
    </tr>
    <tr class="TableHeader">
      <td nowrap align="center">部门/成员单位</td>
      <td nowrap align="center">已读人员</td>
      <td nowrap align="center">未读人员</td>
    </tr>
    ';
    echo $OPTION_TEXT;
    echo '    <tfoot class="TableControl">
      <td nowrap align="center"><b>合计:</b></td>
      <td nowrap align="center"><b>';
    echo $READ_COUNT;
    echo '</b></td>
      <td nowrap align="center"><b>';
    echo $UN_READ_COUNT;
    echo '</b></td>
    </tfoot>
  </table>
';
  }
  echo '
</body>
</html>';
?>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -