add1.php
来自「极限网络智能办公系统 - Office Automation 2008 官方10」· PHP 代码 · 共 94 行
PHP
94 行
<?php
include_once( "inc/auth.php" );
include_once( "inc/check_type.php" );
include_once( "inc/utility_all.php" );
echo "<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<body class=\"bodycolor\" topmargin=\"5\">\r\n";
$query = "select USER_ID from USER where USER_NAME='".$USER_NAME."' and DEPT_ID='{$DEPT_ID}'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$USER_ID = $ROW['USER_ID'];
}
if ( $ATTACHMENT_NAME != "" && !strstr( $ATTACHMENT_NAME, ".php" ) )
{
$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( );
}
}
if ( $ATTACHMENT_NAME1 != "" )
{
$ATTACHMENT_ID = upload( $ATTACHMENT1, $ATTACHMENT_NAME1 );
$ATTACHMENT_ID = $ATTACHMENT_ID_OLD.$ATTACHMENT_ID.",";
$ATTACHMENT_NAME = $ATTACHMENT_NAME_OLD.$ATTACHMENT_NAME1."*";
}
else
{
$ATTACHMENT_ID = $ATTACHMENT_ID_OLD;
$ATTACHMENT_NAME = $ATTACHMENT_NAME_OLD;
}
$ATTACHMENT_ID .= copy_sel_attach( $ATTACH_NAME, $ATTACH_DIR, $DISK_ID );
$ATTACHMENT_NAME .= $ATTACH_NAME;
if ( $USER_ID != "" )
{
$query = "select * from HRMS where USER_ID='".$USER_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$OPERATION = 2;
}
else
{
$OPERATION = 1;
}
$query = "update USER set SEX='".$SEX."' where USER_ID='{$USER_ID}'";
exequery( $connection, $query );
if ( $OPERATION == 1 )
{
$query = "insert into HRMS(USER_ID,CARD_NO,MARRY,WORK_DATE,HR_BIRTHDAY,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,TECH_POST,CONTRACTTYPE,HUKOU_PLACE,POST_CHANGE,SURETY,CONTRACT,INSURE,BODY_EXAMIM,USERDEF1,USERDEF2,USERDEF3,USERDEF4,USERDEF5) values ('".$USER_ID."','{$CARD_NO}','{$MARRY}','{$WORK_DATE}','{$BIRTHDAY}','{$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}','{$TECH_POST}','{$CONTRACTTYPE}','{$HUKOU_PLACE}','{$POST_CHANGE}','{$SURETY}','{$CONTRACT}','{$INSURE}','{$BODY_EXAMIM}','{$USERDEF1}','{$USERDEF2}','{$USERDEF3}','{$USERDEF4}','{$USERDEF5}')";
}
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}',ATTACHMENT_ID='{$ATTACHMENT_ID}',ATTACHMENT_NAME='{$ATTACHMENT_NAME}',TECH_POST='{$TECH_POST}',CONTRACTTYPE='{$CONTRACTTYPE}',HUKOU_PLACE='{$HUKOU_PLACE}',POST_CHANGE='{$POST_CHANGE}',SURETY='{$SURETY}',CONTRACT='{$CONTRACT}',INSURE='{$INSURE}',BODY_EXAMIM='{$BODY_EXAMIM}',USERDEF1='{$USERDEF1}',USERDEF2='{$USERDEF2}',USERDEF3='{$USERDEF3}',USERDEF4='{$USERDEF4}',USERDEF5='{$USERDEF5}',HR_BIRTHDAY='{$BIRTHDAY}'";
if ( $PHOTO != "" )
{
$query .= ",PHOTO='".$PHOTO."'";
}
$query .= " where USER_ID='".$USER_ID."'";
}
exequery( $connection, $query );
save_field_data( "HRMS", $USER_ID, $_POST );
}
else
{
$query = "select USER_ID from USER where USER_ID='".$NEWUSER_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
message( "提示", "用户名 ".$NEWUSER_ID." 已经使用请选择其他用户名" );
button_back( );
return;
}
$PASSWORD = crypt( "" );
$query = "insert into USER (USER_ID,USER_NAME,SEX,PASSWORD,USER_PRIV,POST_PRIV,POST_DEPT,CANBROADCAST,DEPT_ID,AVATAR,CALL_SOUND,DUTY_TYPE,SMS_ON,MENU_HIDE,EMAIL_CAPACITY,FOLDER_CAPACITY,USER_PRIV_OTHER,USER_NO,NOT_LOGIN,NOT_VIEW_USER,NOT_VIEW_TABLE,BYNAME,BIRTHDAY,THEME,MOBIL_NO,MOBIL_NO_HIDDEN)\r\n values ('".$NEWUSER_ID."','{$USER_NAME}','{$SEX}','{$PASSWORD}','{$USER_PRIV}','0','','0','{$DEPT_ID}','1','1','1','1','2',0,0,'','{$USER_NO}','1','1','1','','{$BIRTHDAY}','1','','')";
exequery( $connection, $query );
add_log( 6, $USER_ID, $LOGIN_USER_ID );
$query = "insert into HRMS(USER_ID,CARD_NO,MARRY,WORK_DATE,HR_BIRTHDAY,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,TECH_POST,CONTRACTTYPE,HUKOU_PLACE,POST_CHANGE,SURETY,CONTRACT,INSURE,BODY_EXAMIM,USERDEF1,USERDEF2,USERDEF3,USERDEF4,USERDEF5) values ('".$NEWUSER_ID."','{$CARD_NO}','{$MARRY}','{$WORK_DATE}','{$BIRTHDAY}','{$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}','{$TECH_POST}','{$CONTRACTTYPE}','{$HUKOU_PLACE}','{$POST_CHANGE}','{$SURETY}','{$CONTRACT}','{$INSURE}','{$BODY_EXAMIM}','{$USERDEF1}','{$USERDEF2}','{$USERDEF3}','{$USERDEF4}','{$USERDEF5}')";
exequery( $connection, $query );
save_field_data( "HRMS", $NEWUSER_ID, $_POST );
echo "<script>\r\n URL=\"user_list.php\";\r\n parent.frames[\"user_list\"].location=URL;\r\n</script>\r\n";
}
echo "<script>\r\n URL=\"user_new.php?DEPT_ID=";
echo $DEPT_ID;
echo "\";\r\n window.location=URL;\r\n</script>\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?