📄 hrms.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/utility_field.php" );
echo "<script>\r\nfunction myprint()\r\n{\r\n document.execCommand('Print');\r\n}\r\n</script>\r\n<html>\r\n<head>\r\n<title>人员基本信息</title>\r\n</head>\r\n<body leftmargin=\"0\" topmargin=\"0\">\r\n";
$query = "select * from USER where USER_ID='".$USER_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$USER_NAME = $ROW['USER_NAME'];
$SEX = $ROW['SEX'];
if ( $SEX == "0" )
{
$SEX_DESC = "男";
}
else if ( $SEX == "1" )
{
$SEX_DESC = "女";
}
else
{
$SEX_DESC = "";
}
}
$query = "select * from HRMS where USER_ID='".$USER_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$CARD_NO = $ROW['CARD_NO'];
$MARRY = $ROW['MARRY'];
$WORK_DATE = $ROW['WORK_DATE'];
$WORK_DATE = strtok( $WORK_DATE, " " );
$JOIN_DATE = $ROW['JOIN_DATE'];
$JOIN_DATE = strtok( $JOIN_DATE, " " );
$EDUCATION = $ROW['EDUCATION'];
$POLITICS = $ROW['POLITICS'];
$REWARD = $ROW['REWARD'];
$CERTIFICATE = $ROW['CERTIFICATE'];
$TRAIN = $ROW['TRAIN'];
$RESUME = $ROW['RESUME'];
$PHOTO = $ROW['PHOTO'];
$NO = $ROW['NO'];
$NATION = $ROW['NATION'];
$NATIVE_PLACE = $ROW['NATIVE_PLACE'];
$SPECIALITY = $ROW['SPECIALITY'];
$SCHOOL = $ROW['SCHOOL'];
$DEPARTMENT = $ROW['DEPARTMENT'];
$POST = $ROW['POST'];
$HOME_ADDR = $ROW['HOME_ADDR'];
$HOME_TEL = $ROW['HOME_TEL'];
$CONTRACTTYPE = $ROW['CONTRACTTYPE'];
$EMAIL = $ROW['EMAIL'];
$EDU = $ROW['EDU'];
$WORK = $ROW['WORK'];
$SOCIATY = $ROW['SOCIATY'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
$TECH_POST = $ROW['TECH_POST'];
$HUKOU_PLACE = $ROW['HUKOU_PLACE'];
$POST_CHANGE = $ROW['POST_CHANGE'];
$SURETY = $ROW['SURETY'];
$CONTRACT = $ROW['CONTRACT'];
$INSURE = $ROW['INSURE'];
$BODY_EXAMIM = $ROW['BODY_EXAMIM'];
$HR_BIRTHDAY = $ROW['HR_BIRTHDAY'];
$USERDEF11 = $ROW['USERDEF1'];
$USERDEF21 = $ROW['USERDEF2'];
$USERDEF31 = $ROW['USERDEF3'];
$USERDEF41 = $ROW['USERDEF4'];
$USERDEF51 = $ROW['USERDEF5'];
if ( $HR_BIRTHDAY == "0000-00-00" || $HR_BIRTHDAY == "1900-01-01" )
{
$HR_BIRTHDAY = "";
}
if ( $HR_BIRTHDAY != "" )
{
$AGE = date( "Y", time( ) ) - substr( $HR_BIRTHDAY, 0, 4 ) - 1;
if ( substr( $HR_BIRTHDAY, 5 ) <= date( "m-d", time( ) ) )
{
++$AGE;
}
}
if ( $JOIN_DATE == "1900-01-01" || $JOIN_DATE == "0000-00-00" )
{
$JOIN_DATE = "";
}
if ( $WORK_DATE == "1900-01-01" || $WORK_DATE == "0000-00-00" )
{
$WORK_DATE = "";
}
$OPERATION = 2;
$STATUS = "已建档";
}
else
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -