query.php

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

PHP
214 行
字号 
<?
  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 Language="JavaScript">
function CheckForm(form_action)
{
   document.form1.action=form_action;
   document.form1.submit();
}
</script>
</head>
<body class="bodycolor" topmargin="5" onload="document.form1.USER_ID.focus();">
<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>
    </td>
  </tr>
</table>
<table border="0" cellspacing="1" width="90%" class="small" bgcolor="#000000" cellpadding="3" align="center" >
  <form action="search.php" method="post" name="form1">
   <tr>
    <td nowrap class="TableData" width="120">用户名：</td>
    <td nowrap class="TableData">
        <input type="text" name="USER_ID" class="BigInput" size="20" ma';
  echo 'xlength="20">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">真实姓名：</td>
    <td nowrap class="TableData">
        <input type="text" name="USER_NAME" class="BigInput" size="10" maxlength="10">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">别名：</td>
    <td nowrap class="TableData">
        <input type="text" name="BYNAME" class="BigInput" size="10" maxle';
  echo 'ngth="10">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">性别：</td>
    <td nowrap class="TableData">
        ';
  echo '<s';
  echo 'elect name="SEX" class="BigSelect">
        <option value=""></option>
        <option value="0">男</option>
        <option value="1">女</option>
        </select>
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">部门：</td>
    <td nowrap class="TableData">
        ';
  echo '<s';
  echo 'elect name="DEPT_ID" class="BigSelect">
        <option value=""></option>
';
  echo my_dept_tree (0, $DEPT_ID, 1);
  if (($DEPT_ID == 0))
  {
    echo '          <option value="0">离职人员/外部人员</option>
';
  }
  echo '        </select>
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">角色：</td>
    <td nowrap class="TableData">
        ';
  echo '<s';
  echo 'elect name="USER_PRIV" class="BigSelect">
        <option value=""></option>
';
  $query = 'SELECT * from USER_PRIV order by PRIV_NO desc';
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $USER_PRIV1 = $ROW['USER_PRIV'];
    $PRIV_NAME = $ROW['PRIV_NAME'];
    echo '          <option value="';
    echo $USER_PRIV1;
    echo '">';
    echo $PRIV_NAME;
    echo '</option>
';
  }
  echo '        </select>
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">管理范围：</td>
    <td nowrap class="TableData">
        ';
  echo '<s';
  echo 'elect name="POST_PRIV" class="BigSelect">
          <option value=""></option>
          <option value="0">本部门</option>
          <option value="1">全体</option>
          <option value="2">指定部门</option>
        </select>
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">是否允许登录OA系统：</td>
    <td nowrap class="TableData">
    	  ';
  echo '<s';
  echo 'elect name="NOT_LOGIN" class="BigSelect">
          <option value="2"></option>
          <option value="0">允许</option>
          <option value="1">禁止</option>
        </select>
      </td>
   </tr>
   <tr>
    <td nowrap class="TableData">是否允许查看用户列表：</td>
    <td nowrap class="TableData">
    	  ';
  echo '<s';
  echo 'elect name="NOT_VIEW_USER" class="BigSelect">
          <option value="2"></option>
          <option value="0">允许</option>
          <option value="1">禁止</option>
        </select>
     </td>
   </tr>
   <tr>
    <td nowrap class="TableData">是否允许显示桌面：</td>
    <td nowrap class="TableData">
    	  ';
  echo '<s';
  echo 'elect name="NOT_VIEW_TABLE" class="BigSelect">
          <option value="2"></option>
          <option value="0">允许</option>
          <option value="1">禁止</option>
        </select>
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">考勤排班类型：</td>
    <td nowrap class="TableData">
        ';
  echo '<s';
  echo 'elect name="DUTY_TYPE" class="BigSelect">
        <option value=""></option>
';
  $query = 'SELECT * from ATTEND_CONFIG order by DUTY_TYPE';
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $DUTY_TYPE = $ROW['DUTY_TYPE'];
    $DUTY_NAME = $ROW['DUTY_NAME'];
    echo '          <option value="';
    echo $DUTY_TYPE;
    echo '">';
    echo $DUTY_NAME;
    echo '</option>
';
  }
  echo '        </select>
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">IMA广播权限：</td>
    <td nowrap class="TableData">
        ';
  echo '<s';
  echo 'elect name="CANBROADCAST" class="BigSelect">
          <option value=""></option>
          <option value="0">无</option>
          <option value="1">有</option>
        </select>
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">按最后登录时间排序：</td>
    <td nowrap class="TableData">
        ';
  echo '<s';
  echo 'elect name="LAST_VISIT_TIME" class="BigSelect">
          <option value=""></option>
          <option value="desc">降序</option>
          <option value="asc">升序</option>
        </select>
    </td>
   </tr>
   <tr>
    <td nowrap  class="TableControl" colspan="2" align="center">
        <input type="button" value="查询" class="BigButton" onclick="CheckForm(\'search.php\');" title="查询用户" name="b';
  echo 'utton">&nbsp;&nbsp;
        <input type="button" value="导出" class="BigButton" onclick="CheckForm(\'export.php\');" title="导出用户信息" name="button">
    </td>
  </form>
</table>
<br>
';
  message ('提示', '点击左侧部门后，可以新建用户');
  echo '</body>
</html>';
?>

query.php - 源码说明

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

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

⌨️ 快捷键说明

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