📄 submit.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。
💻 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<table border=\"0\" width=\"100%\" cellspacing=\"1\"  cellpadding=\"0\">\r\n  <tr class=\"tablehead1\">\r\n    <td ><img src=\"/images/menu/hrms.gif\" align=\"absmiddle\">员工档案\r\n      </td>\r\n  </tr>\r\n  <tr class=\"tablehead2\">\r\n    <td><a href=\"#\" onclick=\"location='blank.php";
echo "'\"><img src=\"../../../images/button/return.gif\" width=\"105\" height=\"20\" border=\"0\"></a></td>\r\n  </tr>\r\n</table>\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 ( $BIRTHDAY != "" )
{
	$TIME_OK = is_date( $BIRTHDAY );
	if ( !$TIME_OK )
	{
		message( "错误", "加入本单位时间日期格式不对，应形如 1999-1-2" );
		button_back( );
		exit( );
	}
	$BIRTHDAY = "'".$BIRTHDAY."'";
}
else
{
	$BIRTHDAY = "null";
}
if ( $ATTACHMENT_PIC_NAME != "" )
{
	$ATTACHMENT_PIC_NAME = str_replace( "\\'", "’", $ATTACHMENT_PIC_NAME );
	$FILENAME = $ATTACH_PATH."hrms_pic/".$ATTACHMENT_PIC_NAME;
	copy( $ATTACHMENT_PIC, $FILENAME );
	unlink( $ATTACHMENT_PIC );
	$PHOTO = $ATTACHMENT_PIC_NAME;
	if ( !file_exists( $FILENAME ) )
	{
		message( "附件上传失败", "原因：附件文件为空或文件名太长，或附件大于30兆字节，或文件路径不存在！" );
		button_back( );
		exit( );
	}
}
if ( $ATTACHMENT_NAME != "" )
{
	$ATTACHMENT_ID = upload( $ATTACHMENT, $ATTACHMENT_NAME );
	$ATTACHMENT_ID = $ATTACHMENT_ID_OLD.$ATTACHMENT_ID.",";
	$ATTACHMENT_NAME = $ATTACHMENT_NAME_OLD.$ATTACHMENT_NAME."*";
}
else
{
	$ATTACHMENT_ID = $ATTACHMENT_ID_OLD;
	$ATTACHMENT_NAME = $ATTACHMENT_NAME_OLD;
}
$connection = openconnection( );
if ( trim( $_REQUEST['USER_ID'] ) != "" )
{
	$sql = "SELECT ID,USER_ID FROM HRMS WHERE USER_ID = '".$_REQUEST['USER_ID']."'";
	$cursor = exequery( $connection, $query );
	if ( ( $ROW = mysql_fetch_array( $cursor ) ) && $ROW['ID'] != $_REQUEST['ID'] && $ROW['USER_ID'] == $_REQUEST['USER_ID'] )
	{
		message( "错误", "用户名不能重复" );
		button_back( );
		exit( );
	}
}
if ( $OPERATION == 1 )
{
	$query = "insert into HRMS(ID,USER_ID,CARD_NO,TRUE_NAME,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,ATTACHMENT_ID,ATTACHMENT_NAME,BIRTHDAY,OTHERS,SEX) values (0,'{$USER_ID}','{$CARD_NO}','".$_REQUEST['TRUE_NAME']."','{$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}','{$ATTACHMENT_ID}','{$ATTACHMENT_NAME}',{$BIRTHDAY},'{$OTHERS}','".$_REQUEST['sex']."')";
}
else
{
	if ( trim( $_REQUEST['id'] ) == "" )
	{
		header( "location:blank.php" );
		exit( );
	}
	$query = "update HRMS set USER_ID = '".$_REQUEST['USER_ID']."', CARD_NO='{$CARD_NO}',TRUE_NAME = '".$_REQUEST['TRUE_NAME']."',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}',ATTACHMENT_ID='{$ATTACHMENT_ID}',ATTACHMENT_NAME='{$ATTACHMENT_NAME}',BIRTHDAY={$BIRTHDAY},OTHERS='{$OTHERS}',SEX='".$_REQUEST['sex']."'";
	if ( $PHOTO != "" )
	{
		$query .= ",PHOTO='{$PHOTO}'";
	}
	if ( trim( $_REQUEST['id'] ) != "" )
	{
		$query .= " WHERE ID = ".$_REQUEST['id']."";
	}
}
if ( trim( $_REQUEST['USER_ID'] ) != "" && trim( $_REQUEST['TRUE_NAME'] ) != "" )
{
	if ( trim( $_REQUEST['dept_id'] ) != "" )
	{
		$sql = "UPDATE USER SET USER_NAME = '".$_REQUEST['TRUE_NAME']."',SEX='".$_REQUEST['sex']."'";
		$sql .= " ,DEPT_ID = ".$_REQUEST['dept_id']."";
		$sql .= " WHERE USER_ID = '".$_REQUEST['USER_ID']."'";
	}
	else
	{
		$sql = "UPDATE USER SET USER_NAME = '".$_REQUEST['TRUE_NAME']."',SEX='".$_REQUEST['sex']."'";
		$sql .= " WHERE USER_ID = '".$_REQUEST['USER_ID']."'";
	}
	exequery( $connection, $sql );
}
$id = $_REQUEST['id'];
exequery( $connection, $query );
message( "提示", "员工 ".$_REQUEST['TRUE_NAME']." 的档案已保存<br><br>请继续选择其他员工" );
if ( $id == "" && $_REQUEST['SAVE_FLAG'] == 1 )
{
	$id = mysql_insert_id( );
}
if ( $_REQUEST['SAVE_FLAG'] == 1 )
{
	header( "location:hrms.php?id=".$id );
	exit( );
}
header( "location:blank.php" );
echo "\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明

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