📄 user_new.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_org.php" );
echo "<html>\r\n<head>\r\n<title>人事档案管理</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<script Language=\"JavaScript\">\r\n function delete_all(DEPT_ID)\r\n{\r\n msg='确定要删除该部门所有用户档案吗？';\r\n if(window.confirm(msg))\r\n {\r\n URL=\"delete_hrms.php?DEPT_ID=\" + DEPT_ID;\r\n window.location=URL;\r\n }\r\n}\r\n\r\nfunction delete_user(USER_ID)\r\n{\r\n msg='确认要删除该用户档案吗？';\r\n if(window.confirm(msg))\r\n {\r\n URL=\"delete_hrms.php?DEPT_ID=";
echo $DEPT_ID;
echo "&USER_ID=\" + USER_ID;\r\n window.location=URL;\r\n }\r\n}\r\n</script>\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n";
$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\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/notify_new.gif\" align=\"absmiddle\"><span class=\"big3\"> 新建用户档案 （";
echo $DEPT_NAME;
echo "）</span>\r\n </td>\r\n </tr>\r\n</table>\r\n<div align=\"center\">\r\n <input type=\"button\" value=\"新建用户档案\" class=\"BigButton\" title=\"新建用户档案\" onClick=\"location='new_hrms.php?DEPT_ID=";
echo $DEPT_ID;
echo "&SOURCE=new_hrms';\">\r\n</div>\r\n<br>\r\n\r\n";
$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 ) )
{
++$HRMS_COUNT;
}
}
echo "\r\n<table width=\"95%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" height=\"3\">\r\n <tr>\r\n <td background=\"/images/dian1.gif\" width=\"100%\"></td>\r\n </tr>\r\n</table>\r\n\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/notify_open.gif\" align=\"absmiddle\"><span class=\"big3\"> <a name=\"bottom\">管理用户档案（";
echo $DEPT_NAME;
echo "）- ";
echo $HRMS_COUNT;
echo "人</span>\r\n </td>\r\n </tr>\r\n</table>\r\n";
$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 .= $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 ) )
{
++$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" || $HR_BIRTHDAY == "1900-01-01" )
{
$HR_BIRTHDAY = "";
}
if ( $HRMS_COUNT == 1 )
{
echo "<table width=\"100%\" class=\"TableList\">\r\n <tr class=\"TableHeader\">\r\n <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 "\">姓名 ";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "USER_NAME" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "USER_NAME" )
{
echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n <td nowrap align=\"center\"><a href=\"user_new.php?DEPT_ID=";
echo $DEPT_ID;
echo "&ORDERFIELD=HRMS.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 "\">性别 ";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "HRMS.SEX" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "HRMS.SEX" )
{
echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n <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 "\">出生年月 ";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "HR_BIRTHDAY" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "HR_BIRTHDAY" )
{
echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n <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 "\">民族 ";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "NATION" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "NATION" )
{
echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n <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 "\">籍贯 ";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "NATIVE_PLACE" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "NATIVE_PLACE" )
{
echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n <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 "\">政治面貌 ";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "POLITICS" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "POLITICS" )
{
echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n <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 "\">身份证号码 ";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "CARD_NO" )
{
echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "CARD_NO" )
{
echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n <td nowrap align=\"center\">操作</td>\r\n </tr>\r\n";
}
echo " <tr class=\"TableData\">\r\n <td nowrap align=\"center\">";
echo $USER_NAME;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $SEX_DESC;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $HR_BIRTHDAY;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $NATION;
echo "</a></td>\r\n <td nowrap align=\"left\">";
echo $NATIVE_PLACENAME;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $POLITICS;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $CARD_NO;
echo "</td>\r\n <td nowrap align=\"center\">\r\n <a href=\"hrms.php?USER_ID=";
echo $USER_ID;
echo "&SOURCE=new_hrms&DEPT_ID=";
echo $DEPT_ID;
echo "\"> 编辑</a> \r\n <a href=\"javascript:delete_user('";
echo $USER_ID;
echo "');\"> 删除</a>\r\n </td>\r\n </tr>\r\n";
}
}
if ( $HRMS_COUNT != "" && $HRMS_COUNT != 0 )
{
echo "\t<tfoot class=\"TableFooter\">\r\n \t\t<td colspan=\"9\" nowrap align=\"center\">\r\n\t\t\t\t<input type=\"button\" value=\"全部删除\" class=\"BigButton\" onClick=\"delete_all('";
echo $DEPT_ID;
echo "s')\">\r\n\t\t\t</td>\r\n </tfoot>\r\n";
}
if ( $HRMS_COUNT == 0 )
{
message( "", "该部门尚未定义人事档案信息" );
}
echo "</table>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -