user_new.php

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

PHP
490 行
字号 
<?
  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 delete_user(USER_ID)
{
 msg=\'确认要删除该用户档案么？\';
 if(window.confirm(msg))
 {
  URL="delete_hrms.php?DEPT_ID=';
  echo $DEPT_ID;
  echo '&USER_ID=" + USER_ID;
  window.location=URL;
 }
}
</script>
</head>
<body class="bodycolor" topmargin="5">
';
  $query = (((''.'SELECT * from DEPARTMENT where DEPT_ID=\'').$DEPT_ID).'\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $DEPT_NAME = $ROW['DEPT_NAME'];
  }
  if (($DEPT_ID == 0))
  {
    $DEPT_NAME = '离职人员/外部人员';
  }
  if (($ORDERFIELD != ''))
  {
    if (($ORDERSIGN == 'DOWN'))
    {
      $ORDERTYPE = 'ASC';
    }
    if (($ORDERSIGN == 'UP'))
    {
      $ORDERTYPE = 'DESC';
    }
    $OREDERBY = (((' ORDER BY '.$ORDERFIELD).' ').$ORDERTYPE);
  }
  echo '<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"> 新建用户档案 （';
  echo $DEPT_NAME;
  echo '）</span>
    </td>
  </tr>
</table>
<div align="center">
  <input type="button" value="新建用户档案" class="BigButton" title="新建用户档案" onclick="location=\'new_hrms.php?DEPT_ID=';
  echo $DEPT_ID;
  echo '&SOURCE=new_hrms\';">
</div>
<br>
<table width="95%" border="0" cellspacing="0" cellpadding="0" height="3">
 <tr>
   <td background="/images/dian1.gif" width="100%"></td>
 </tr>
</table>
';
  $query1 = (((''.'select HRMS.USER_ID from HRMS,USER where HRMS.USER_ID=USER.USER_ID and  USER.DEPT_ID=\'').$DEPT_ID).'\'');
  $cursor = exequery ($connection, $query1);
  $HRMS_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $USER_ID = $ROW['USER_ID'];
    if ((is_dept_priv ($DEPT_ID) == 0))
    {
      continue;
    }
    else
    {
      ++$HRMS_COUNT;
      continue;
    }
  }
  echo '<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"> <a name="bottom">管理用户档案（';
  echo $DEPT_NAME;
  echo '）- ';
  echo $HRMS_COUNT;
  echo '人</span>
    </td>
  </tr>
</table>
';
  $HRMS_COUNT = 0;
  $query1 = 'select * from HRMS,USER,USER_PRIV';
  if (($DEPT_ID != '0'))
  {
    ($query1 .= ',DEPARTMENT');
  }
  ($query1 .= ' where HRMS.USER_ID=USER.USER_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV');
  if (($DEPT_ID != '0'))
  {
    ($query1 .= (((''.' and USER.DEPT_ID=DEPARTMENT.DEPT_ID and USER.DEPT_ID=\'').$DEPT_ID).'\''));
  }
  $query1 = ($query1.$OREDERBY);
  $cursor = exequery ($connection, $query1);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $NATIVE_PLACENAME = '';
    $USER_ID = $ROW['USER_ID'];
    $USER_NAME = $ROW['USER_NAME'];
    $DEPT_NAME = $ROW['DEPT_NAME'];
    $DEPT_ID = $ROW['DEPT_ID'];
    $SEX = $ROW['SEX'];
    $HR_BIRTHDAY = $ROW['HR_BIRTHDAY'];
    $CARD_NO = $ROW['CARD_NO'];
    $NO = $ROW['NO'];
    $NATION = $ROW['NATION'];
    $NATIVE_PLACE = $ROW['NATIVE_PLACE'];
    $TECH_POST = $ROW['TECH_POST'];
    $HUKOU_PLACE = $ROW['HUKOU_PLACE'];
    $POLITICS = $ROW['POLITICS'];
    $query1 = (((''.'SELECT CODE_NAME from SYS_CODE where PARENT_NO=\'AREA\' and CODE_NO=\'').$NATIVE_PLACE).'\'');
    $cursor1 = exequery ($connection, $query1);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $NATIVE_PLACENAME = $ROW['CODE_NAME'];
    }
    if ((is_dept_priv ($DEPT_ID) == 0))
    {
      continue;
    }
    else
    {
      ++$HRMS_COUNT;
      if (($SEX == '0'))
      {
        $SEX_DESC = '男';
      }
      else
      {
        if (($SEX == '1'))
        {
          $SEX_DESC = '女';
        }
        else
        {
          $SEX_DESC = '';
        }
      }
      if (($POLITICS == 1))
      {
        $POLITICS = '群众';
      }
      else
      {
        if (($POLITICS == 2))
        {
          $POLITICS = '团员';
        }
        else
        {
          if (($POLITICS == 3))
          {
            $POLITICS = '党员';
          }
          else
          {
            if (($POLITICS == 4))
            {
              $POLITICS = '预备党员';
            }
          }
        }
      }
      if ((($HR_BIRTHDAY == '0000-00-00') OR ($HR_BIRTHDAY == '1900-01-01')))
      {
        $HR_BIRTHDAY = '';
      }
      if (($HRMS_COUNT == 1))
      {
        echo '<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
  <tr class="TableHeader">
      <td nowrap align="center"><a href="user_new.php?DEPT_ID=';
        echo $DEPT_ID;
        echo '&ORDERFIELD=USER_NAME&ORDERSIGN=';
        if (($ORDERSIGN == 'DOWN'))
        {
          echo 'UP';
        }
        if (($ORDERSIGN == 'UP'))
        {
          echo 'DOWN';
        }
        if (($ORDERSIGN == ''))
        {
          if (($ORDERTYPE == 'ASC'))
          {
            echo 'UP';
          }
          else
          {
            echo 'DOWN';
          }
        }
        echo '&ORDERTYPE=';
        echo $ORDERTYPE;
        echo '&CUR_PAGE=';
        echo $CUR_PAGE;
        echo '">姓名&nbsp;';
        if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'USER_NAME')))
        {
          echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
        }
        if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'USER_NAME')))
        {
          echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
        }
        echo '</a></td>
      <td nowrap align="center"><a href="user_new.php?DEPT_ID=';
        echo $DEPT_ID;
        echo '&ORDERFIELD=SEX&ORDERSIGN=';
        if (($ORDERSIGN == 'DOWN'))
        {
          echo 'UP';
        }
        if (($ORDERSIGN == 'UP'))
        {
          echo 'DOWN';
        }
        if (($ORDERSIGN == ''))
        {
          if (($ORDERTYPE == 'ASC'))
          {
            echo 'UP';
          }
          else
          {
            echo 'DOWN';
          }
        }
        echo '&ORDERTYPE=';
        echo $ORDERTYPE;
        echo '&CUR_PAGE=';
        echo $CUR_PAGE;
        echo '">性别&nbsp;';
        if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'SEX')))
        {
          echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
        }
        if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'SEX')))
        {
          echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
        }
        echo '</a></td>
      <td nowrap align="center"><a href="user_new.php?DEPT_ID=';
        echo $DEPT_ID;
        echo '&ORDERFIELD=HR_BIRTHDAY&ORDERSIGN=';
        if (($ORDERSIGN == 'DOWN'))
        {
          echo 'UP';
        }
        if (($ORDERSIGN == 'UP'))
        {
          echo 'DOWN';
        }
        if (($ORDERSIGN == ''))
        {
          if (($ORDERTYPE == 'ASC'))
          {
            echo 'UP';
          }
          else
          {
            echo 'DOWN';
          }
        }
        echo '&ORDERTYPE=';
        echo $ORDERTYPE;
        echo '&CUR_PAGE=';
        echo $CUR_PAGE;
        echo '">出生年月&nbsp;';
        if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'HR_BIRTHDAY')))
        {
          echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
        }
        if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'HR_BIRTHDAY')))
        {
          echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
        }
        echo '</a></td>
      <td nowrap align="center"><a href="user_new.php?DEPT_ID=';
        echo $DEPT_ID;
        echo '&ORDERFIELD=NATION&ORDERSIGN=';
        if (($ORDERSIGN == 'DOWN'))
        {
          echo 'UP';
        }
        if (($ORDERSIGN == 'UP'))
        {
          echo 'DOWN';
        }
        if (($ORDERSIGN == ''))
        {
          if (($ORDERTYPE == 'ASC'))
          {
            echo 'UP';
          }
          else
          {
            echo 'DOWN';
          }
        }
        echo '&ORDERTYPE=';
        echo $ORDERTYPE;
        echo '&CUR_PAGE=';
        echo $CUR_PAGE;
        echo '">民族&nbsp;';
        if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'NATION')))
        {
          echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
        }
        if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'NATION')))
        {
          echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
        }
        echo '</a></td>
      <td nowrap align="center"><a href="user_new.php?DEPT_ID=';
        echo $DEPT_ID;
        echo '&ORDERFIELD=NATIVE_PLACE&ORDERSIGN=';
        if (($ORDERSIGN == 'DOWN'))
        {
          echo 'UP';
        }
        if (($ORDERSIGN == 'UP'))
        {
          echo 'DOWN';
        }
        if (($ORDERSIGN == ''))
        {
          if (($ORDERTYPE == 'ASC'))
          {
            echo 'UP';
          }
          else
          {
            echo 'DOWN';
          }
        }
        echo '&ORDERTYPE=';
        echo $ORDERTYPE;
        echo '&CUR_PAGE=';
        echo $CUR_PAGE;
        echo '">籍贯&nbsp;';
        if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'NATIVE_PLACE')))
        {
          echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
        }
        if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'NATIVE_PLACE')))
        {
          echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
        }
        echo '</a></td>
      <td nowrap align="center"><a href="user_new.php?DEPT_ID=';
        echo $DEPT_ID;
        echo '&ORDERFIELD=POLITICS&ORDERSIGN=';
        if (($ORDERSIGN == 'DOWN'))
        {
          echo 'UP';
        }
        if (($ORDERSIGN == 'UP'))
        {
          echo 'DOWN';
        }
        if (($ORDERSIGN == ''))
        {
          if (($ORDERTYPE == 'ASC'))
          {
            echo 'UP';
          }
          else
          {
            echo 'DOWN';
          }
        }
        echo '&ORDERTYPE=';
        echo $ORDERTYPE;
        echo '&CUR_PAGE=';
        echo $CUR_PAGE;
        echo '">政治面貌&nbsp;';
        if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'POLITICS')))
        {
          echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
        }
        if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'POLITICS')))
        {
          echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
        }
        echo '</a></td>
      <td nowrap align="center"><a href="user_new.php?DEPT_ID=';
        echo $DEPT_ID;
        echo '&ORDERFIELD=CARD_NO&ORDERSIGN=';
        if (($ORDERSIGN == 'DOWN'))
        {
          echo 'UP';
        }
        if (($ORDERSIGN == 'UP'))
        {
          echo 'DOWN';
        }
        if (($ORDERSIGN == ''))
        {
          if (($ORDERTYPE == 'ASC'))
          {
            echo 'UP';
          }
          else
          {
            echo 'DOWN';
          }
        }
        echo '&ORDERTYPE=';
        echo $ORDERTYPE;
        echo '&CUR_PAGE=';
        echo $CUR_PAGE;
        echo '">身份证号码&nbsp;';
        if ((($ORDERTYPE == 'DESC') AND ($ORDERFIELD == 'CARD_NO')))
        {
          echo '<img src="/images/arrow_down.gif" align="absmiddle" border=0>';
        }
        if ((($ORDERTYPE == 'ASC') AND ($ORDERFIELD == 'CARD_NO')))
        {
          echo '<img src="/images/arrow_up.gif" align="absmiddle" border=0>';
        }
        echo '</a></td>
      <td nowrap align="center">操作</td>
    </tr>
';
      }
      echo ' <tr class="TableData">
      <td nowrap align="center">';
      echo $USER_NAME;
      echo '</td>
      <td nowrap align="center">';
      echo $SEX_DESC;
      echo '</td>
      <td nowrap align="center">';
      echo $HR_BIRTHDAY;
      echo '</td>
      <td nowrap align="center">';
      echo $NATION;
      echo '</a></td>
      <td nowrap align="left">';
      echo $NATIVE_PLACENAME;
      echo '</td>
      <td nowrap align="center">';
      echo $POLITICS;
      echo '</td>
      <td nowrap align="center">';
      echo $CARD_NO;
      echo '</td>
      <td nowrap align="center">
        <a href="hrms.php?USER_ID=';
      echo $USER_ID;
      echo '&SOURCE=new_hrms&DEPT_ID=';
      echo $DEPT_ID;
      echo '"> 编辑</a>&nbsp;&nbsp;
        <a href="javascript:delete_user(\'';
      echo $USER_ID;
      echo '\');"> 删除</a>
      </td>
    </tr>
';
      continue;
    }
  }
  if (($HRMS_COUNT == 0))
  {
    message ('', '该部门尚未定义人事档案信息');
  }
  echo '</table>
</body>
</html>';
?>

user_new.php - 源码说明

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

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

⌨️ 快捷键说明

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