📄 submit.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/check_type.php" );
include_once( "inc/utility_all.php" );
echo "\r\n<html>\r\n<head>\r\n<title></title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
if ( $WORK_DATE != "" )
{
$TIME_OK = is_date( $WORK_DATE );
if ( !$TIME_OK )
{
message( "错误", "参加工作时间日期格式不对，应形如 1999-1-2" );
button_back( );
exit( );
}
$WORK_DATE = "'".$WORK_DATE."'";
}
else
{
$WORK_DATE = "null";
}
if ( $JOIN_DATE != "" )
{
$TIME_OK = is_date( $JOIN_DATE );
if ( !$TIME_OK )
{
message( "错误", "加入本单位时间日期格式不对，应形如 1999-1-2" );
button_back( );
exit( );
}
$JOIN_DATE = "'".$JOIN_DATE."'";
}
else
{
$JOIN_DATE = "null";
}
if ( $ATTACHMENT_NAME != "" )
{
$ATTACHMENT_NAME = str_replace( "\\'", "’", $ATTACHMENT_NAME );
$FILENAME = $ATTACH_PATH."hrms_pic/".$ATTACHMENT_NAME;
copy( $ATTACHMENT, $FILENAME );
unlink( $ATTACHMENT );
$PHOTO = $ATTACHMENT_NAME;
if ( !file_exists( $FILENAME ) )
{
message( "附件上传失败", "原因：附件文件为空或文件名太长，或附件大于30兆字节，或文件路径不存在！" );
button_back( );
exit( );
}
}
$connection = openconnection( );
if ( $OPERATION == 1 )
{
$query = "insert into HRMS(USER_ID,CARD_NO,MARRY,WORK_DATE,JOIN_DATE,EDUCATION,POLITICS,REWARD,CERTIFICATE,TRAIN,RESUME,PHOTO,NO,NATION,NATIVE_PLACE,SPECIALITY,SCHOOL,DEPARTMENT,POST,HOME_ADDR,HOME_TEL,EMAIL,EDU,WORK,SOCIATY) values ('{$USER_ID}','{$CARD_NO}','{$MARRY}',{$WORK_DATE},{$JOIN_DATE},'{$EDUCATION}','{$POLITICS}','{$REWARD}','{$CERTIFICATE}','{$TRAIN}','{$RESUME}','{$PHOTO}','{$NO}','{$NATION}','{$NATIVE_PLACE}','{$SPECIALITY}','{$SCHOOL}','{$DEPARTMENT}','{$POST}','{$HOME_ADDR}','{$HOME_TEL}','{$EMAIL}','{$EDU}','{$WORK}','{$SOCIATY}')";
}
else
{
$query = "update HRMS set CARD_NO='{$CARD_NO}',MARRY='{$MARRY}',WORK_DATE={$WORK_DATE},JOIN_DATE={$JOIN_DATE},EDUCATION='{$EDUCATION}',POLITICS='{$POLITICS}',REWARD='{$REWARD}',CERTIFICATE='{$CERTIFICATE}',TRAIN='{$TRAIN}',RESUME='{$RESUME}',NO='{$NO}',NATION='{$NATION}',NATIVE_PLACE='{$NATIVE_PLACE}',SPECIALITY='{$SPECIALITY}',SCHOOL='{$SCHOOL}',DEPARTMENT='{$DEPARTMENT}',POST='{$POST}',HOME_ADDR='{$HOME_ADDR}',HOME_TEL='{$HOME_TEL}',EMAIL='{$EMAIL}',EDU='{$EDU}',WORK='{$WORK}',SOCIATY='{$SOCIATY}'";
if ( $PHOTO != "" )
{
$query .= ",PHOTO='{$PHOTO}'";
}
$query .= " where USER_ID='{$USER_ID}'";
}
exequery( $connection, $query );
message( "提示", "员工 ".$USER_NAME." 的档案已保存<br><br>请继续选择其他员工" );
echo "\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -