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

📄 user_new.php

📁 通达OA官方提供的30源代码,感觉很实在
💻 PHP
字号:
🔍 
<?
include_once("inc/auth.php");
include_once("inc/utility_org.php");
?>
<html>
<head>
<title>人事档案管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language="JavaScript">
 function delete_all(DEPT_ID)
{
 msg='确定要删除该部门所有用户档案吗？';
 if(window.confirm(msg))
 {
   URL="delete_hrms.php?DEPT_ID=" + DEPT_ID;
   window.location=URL;
 }
}

function delete_user(USER_ID)
{
 msg='确认要删除该用户档案吗？';
 if(window.confirm(msg))
 {
  URL="delete_hrms.php?DEPT_ID=<?=$DEPT_ID?>&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;
   }     
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/notify_new.gif" align="absmiddle"><span class="big3"> 新建用户档案 （<?=$DEPT_NAME?>）</span>
    </td>
  </tr>
</table>
<div align="center">
  <input type="button" value="新建用户档案" class="BigButton" title="新建用户档案" onClick="location='new_hrms.php?DEPT_ID=<?=$DEPT_ID?>&SOURCE=new_hrms';">
</div>
<br>

<?
 $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;
    $HRMS_COUNT++;
  }
?>

<table width="95%" border="0" cellspacing="0" cellpadding="0" height="3">
 <tr>
   <td background="/images/dian1.gif" width="100%"></td>
 </tr>
</table>

<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/notify_open.gif" align="absmiddle"><span class="big3"> <a name="bottom">管理用户档案（<?=$DEPT_NAME?>）- <?=$HRMS_COUNT?>人</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;
   $HRMS_COUNT++;
   if($SEX=="0")
      $SEX_DESC="男";
   else if($SEX=="1")
      $SEX_DESC="女";
   else
      $SEX_DESC="";
   if($POLITICS==1) $POLITICS= "群众";
   elseif($POLITICS==2) $POLITICS= "团员";
   elseif($POLITICS==3) $POLITICS= "党员";
   elseif($POLITICS==4) $POLITICS= "预备党员";
   if($HR_BIRTHDAY=="0000-00-00"||$HR_BIRTHDAY=="1900-01-01")
      $HR_BIRTHDAY="";
   if($HRMS_COUNT==1)
   {
?>
<table width="100%" class="TableList">
  <tr class="TableHeader">
      <td nowrap align="center"><a href="user_new.php?DEPT_ID=<?=$DEPT_ID?>&ORDERFIELD=USER_NAME&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">姓名&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="USER_NAME"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="USER_NAME"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="user_new.php?DEPT_ID=<?=$DEPT_ID?>&ORDERFIELD=HRMS.SEX&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">性别&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="HRMS.SEX"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="HRMS.SEX"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="user_new.php?DEPT_ID=<?=$DEPT_ID?>&ORDERFIELD=HR_BIRTHDAY&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">出生年月&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="HR_BIRTHDAY"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="HR_BIRTHDAY"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="user_new.php?DEPT_ID=<?=$DEPT_ID?>&ORDERFIELD=NATION&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">民族&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="NATION"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="NATION"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="user_new.php?DEPT_ID=<?=$DEPT_ID?>&ORDERFIELD=NATIVE_PLACE&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">籍贯&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="NATIVE_PLACE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="NATIVE_PLACE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="user_new.php?DEPT_ID=<?=$DEPT_ID?>&ORDERFIELD=POLITICS&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">政治面貌&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="POLITICS"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="POLITICS"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="user_new.php?DEPT_ID=<?=$DEPT_ID?>&ORDERFIELD=CARD_NO&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else  echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">身份证号码&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="CARD_NO"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="CARD_NO"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center">操作</td>
    </tr>
<?
   }
?>
 <tr class="TableData">
      <td nowrap align="center"><?=$USER_NAME?></td>
      <td nowrap align="center"><?=$SEX_DESC?></td>
      <td nowrap align="center"><?=$HR_BIRTHDAY?></td>
      <td nowrap align="center"><?=$NATION?></a></td>
      <td nowrap align="left"><?=$NATIVE_PLACENAME?></td>
      <td nowrap align="center"><?=$POLITICS?></td>
      <td nowrap align="center"><?=$CARD_NO?></td>
      <td nowrap align="center">
        <a href="hrms.php?USER_ID=<?=$USER_ID?>&SOURCE=new_hrms&DEPT_ID=<?=$DEPT_ID?>"> 编辑</a>&nbsp;&nbsp;
        <a href="javascript:delete_user('<?=$USER_ID?>');"> 删除</a>
      </td>
    </tr>
<?
} //循环结束

	if (($HRMS_COUNT!="")&&($HRMS_COUNT!=0))
	{
?>
	<tfoot class="TableFooter">
     		<td colspan="9" nowrap align="center">
				<input type="button"  value="全部删除" class="BigButton" onClick="delete_all('<?=$DEPT_ID?>s')">
			</td>
    </tfoot>
<?
     }
if($HRMS_COUNT==0)
{
   Message("","该部门尚未定义人事档案信息");
}
?>
</table>
</body>
</html>

⌨️ 快捷键说明

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