user_all.php

来自「通达OA2007SE源代码非常好的」· PHP 代码 · 共 139 行

PHP

139 行

<?
  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 src="/inc/sort_table.js"></script>
</head>
<body class="bodycolor" topmargin="5" leftmargin="0" onload="SortTable(\'beSortTable\');">
<table id="beSortTable" border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
    <tr class="TableHeader" align="center">
      <td nowrap><b>部门</b></td>
      <td nowrap><b>角色</b></td>
      <td nowrap><b>姓名</b></td>
      <td n';
  echo 'owrap><b>小时</b></td>
      <td nowrap><b>性别</b></td>
      <td nowrap><b>单位电话</b></td>
      <td nowrap><b>手机</b></td>
      <td nowrap><b>电子邮件</b></td>
    </tr>
';
  $query = 'SELECT * from DEPARTMENT order by DEPT_NO';
  $cursor_10 = exequery ($connection, $query);
  $DEPT_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor_10))
  {
    ++$DEPT_COUNT;
    $DEPT_ID = $ROW['DEPT_ID'];
    $DEPT_NAME = $ROW['DEPT_NAME'];
    $DEPT_LONG_NAME = dept_long_name ($DEPT_ID);
    $query = (((''.'SELECT * from USER,USER_PRIV where DEPT_ID=').$DEPT_ID).' and USER.USER_PRIV=USER_PRIV.USER_PRIV and NOT_LOGIN!=1 order by PRIV_NO,USER_NO,USER_NAME');
    $cursor = exequery ($connection, $query);
    $USER_COUNT = 0;
    while ($ROW = mysql_fetch_array ($cursor))
    {
      ++$USER_COUNT;
      $USER_ID = $ROW['USER_ID'];
      $USER_NAME = $ROW['USER_NAME'];
      $USER_PRIV = $ROW['USER_PRIV'];
      $ONLINE = $ROW['ONLINE'];
      $SEX = $ROW['SEX'];
      $TEL_NO_DEPT = $ROW['TEL_NO_DEPT'];
      $MOBIL_NO = $ROW['MOBIL_NO'];
      $EMAIL = $ROW['EMAIL'];
      $MOBIL_NO_HIDDEN = $ROW['MOBIL_NO_HIDDEN'];
      $HOUR = round (($ONLINE / 3600), 1);
      $query1 = (((''.'SELECT * from USER_PRIV where USER_PRIV=\'').$USER_PRIV).'\'');
      $cursor1 = exequery ($connection, $query1);
      if ($ROW = mysql_fetch_array ($cursor1))
      {
        $USER_PRIV = $ROW['PRIV_NAME'];
      }
      if (($SEX == 0))
      {
        $SEX = '男';
      }
      else
      {
        $SEX = '女';
      }
      if ((($DEPT_COUNT % 2) == 1))
      {
        $TableLine = 'TableLine1';
      }
      else
      {
        $TableLine = 'TableContent';
      }
      echo '    <tr class="';
      echo $TableLine;
      echo '" align="center">
      <td nowrap title="';
      echo $DEPT_LONG_NAME;
      echo '">';
      echo $DEPT_NAME;
      echo '</td>
      <td nowrap>';
      echo $USER_PRIV;
      echo '</td>
      <td nowrap><a href="user.php?USER_ID=';
      echo $USER_ID;
      echo '" target="user_info">';
      echo $USER_NAME;
      echo '</a></td>
      <td nowrap align=right>';
      echo $HOUR;
      echo '</td>
      <td nowrap>';
      echo $SEX;
      echo '</td>
      <td nowrap>';
      echo $TEL_NO_DEPT;
      echo '</td>
      <td nowrap>
';
      if (($MOBIL_NO_HIDDEN != '1'))
      {
        echo '        <A href="/general/mobile_sms?TO_ID=';
        echo $USER_ID;
        echo ',&TO_NAME=';
        echo $USER_NAME;
        echo ',">';
        echo $MOBIL_NO;
        echo '</A>
';
      }
      else
      {
        echo '        ';
        echo '<s';
        echo 'pan title="不公开" style="cursor:hand">***********</span>
';
      }
      echo '      </td>
      <td nowrap><a href="mailto:';
      echo $EMAIL;
      echo '">';
      echo $EMAIL;
      echo '</a></td>
    </tr>
';
    }
    if (($USER_COUNT == 0))
    {
      --$DEPT_COUNT;
      continue;
    }
  }
  echo '
</table>
</body>
</html>';
?>

user_all.php - 源码说明

本页面展示了「通达OA2007SE源代码非常好的」中的 user_all.php 源码文件，采用 PHP 编程语言编写，共 139 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C

搜索代码Ctrl + F

全屏模式F11

增大字号Ctrl + =

减小字号Ctrl + -

显示快捷键?