📄 add.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/check_type.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/utility_sms1.php" );
include_once( "inc/utility_file.php" );
include_once( "inc/utility_field.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 ( 1 < count( $_FILES ) )
{
$ATTACHMENTS = upload( "ATTACHMENT1" );
$ATTACHMENT_ID = $ATTACHMENT_ID_OLD.$ATTACHMENTS['ID'];
$ATTACHMENT_NAME = $ATTACHMENT_NAME_OLD.$ATTACHMENTS['NAME'];
}
else
{
$ATTACHMENT_ID = $ATTACHMENT_ID_OLD;
$ATTACHMENT_NAME = $ATTACHMENT_NAME_OLD;
}
$ATTACHMENT_ID .= copy_sel_attach( $ATTACH_NAME1, $ATTACH_DIR1, $DISK_ID1 );
$ATTACHMENT_NAME .= $ATTACH_NAME1;
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 );
$CARD_NO = strtoupper( $CARD_NO );
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,SEX,USERDEF1,USERDEF2,USERDEF3,USERDEF4,USERDEF5,CONTRACT_DATE1,CONTRACT_DATE2,LEAVE_TYPE) 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}','{$SEX}','{$USERDEF1}','{$USERDEF2}','{$USERDEF3}','{$USERDEF4}','{$USERDEF5}','{$CONTRACT_DATE1}','{$CONTRACT_DATE2}','{$LEAVE_TYPE}')";
}
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}',SEX='{$SEX}',USERDEF1='{$USERDEF1}',USERDEF2='{$USERDEF2}',USERDEF3='{$USERDEF3}',USERDEF4='{$USERDEF4}',USERDEF5='{$USERDEF5}',HR_BIRTHDAY='{$BIRTHDAY}',CONTRACT_DATE1='{$CONTRACT_DATE1}',CONTRACT_DATE2='{$CONTRACT_DATE2}',LEAVE_TYPE='{$LEAVE_TYPE}'";
if ( $PHOTO != "" )
{
$query .= ",PHOTO='".$PHOTO."'";
}
$query .= " where USER_ID='".$USER_ID."'";
}
exequery( $connection, $query );
save_field_data( "HRMS", $USER_ID, $_POST );
$CUR_DATE = date( "Y-m-d", time( ) );
$DEPT_NAME = dept_long_name( $DEPT_ID );
$SMS_CONTENT = $DEPT_NAME."/".$USER_NAME." 劳动合同转正";
delete_remind_sms( 35, $LOGIN_USER_ID, $SMS_CONTENT );
if ( compare_date( $CONTRACT_DATE1, $CUR_DATE ) == "1" )
{
send_sms( $CONTRACT_DATE1, $LOGIN_USER_ID, $LOGIN_USER_ID, 35, $SMS_CONTENT, $REMIND_URL );
}
$SMS_CONTENT = $DEPT_NAME."/".$USER_NAME." 劳动合同到期";
delete_remind_sms( 5, $LOGIN_USER_ID, $SMS_CONTENT, $CAL_TIME );
$query = "delete from SMS_BODY where FROM_ID='".$LOGIN_USER_ID."' and CONTENT like '%{$SMS_CONTENT}%' and SMS_TYPE='35'";
exequery( $connection, $query );
if ( compare_date( $CONTRACT_DATE2, $CUR_DATE ) == "1" )
{
send_sms( $CONTRACT_DATE2, $LOGIN_USER_ID, $LOGIN_USER_ID, 35, $SMS_CONTENT, $REMIND_URL );
}
}
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_TYPE,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,SEX,USERDEF1,USERDEF2,USERDEF3,USERDEF4,USERDEF5,CONTRACT_DATE1,CONTRACT_DATE2,POSITIVE_DATE,EXPIRE_DATE,LEAVE_TYPE) 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}','{$SEX}','{$USERDEF1}','{$USERDEF2}','{$USERDEF3}','{$USERDEF4}','{$USERDEF5}','{$CONTRACT_DATE1}','{$CONTRACT_DATE2}','{$POSITIVE_DATE}','{$EXPIRE_DATE}','{$LEAVE_TYPE}')";
exequery( $connection, $query );
save_field_data( "HRMS", $NEWUSER_ID, $_POST );
$CUR_DATE = date( "Y-m-d", time( ) );
$DEPT_NAME = dept_long_name( $DEPT_ID );
if ( $NOTIFY == "on" )
{
$SMS_CONTENT = "新员工".$USER_NAME." 的人事档案已经建立。";
send_sms( "", $LOGIN_USER_ID, $TO_ID, 35, $SMS_CONTENT, "ipanel/user/user_info.php?USER_ID=".$NEWUSER_ID );
}
$SMS_CONTENT = $DEPT_NAME."/".$USER_NAME." 劳动合同转正";
delete_remind_sms( 5, $LOGIN_USER_ID, $SMS_CONTENT, $CAL_TIME );
$query = "delete from SMS_BODY where FROM_ID='".$LOGIN_USER_ID."' and CONTENT like '%{$SMS_CONTENT}%' and SMS_TYPE='35'";
exequery( $connection, $query );
if ( compare_date( $CONTRACT_DATE1, $CUR_DATE ) == "1" )
{
send_sms( $CONTRACT_DATE1, $LOGIN_USER_ID, $LOGIN_USER_ID, 35, $SMS_CONTENT, $REMIND_URL );
}
$SMS_CONTENT = $DEPT_NAME."/".$USER_NAME." 劳动合同到期";
delete_remind_sms( 5, $LOGIN_USER_ID, $SMS_CONTENT, $CAL_TIME );
$query = "delete from SMS_BODY where FROM_ID='".$LOGIN_USER_ID."' and CONTENT like '%{$SMS_CONTENT}%' and SMS_TYPE='35'";
exequery( $connection, $query );
if ( compare_date( $CONTRACT_DATE2, $CUR_DATE ) == "1" )
{
send_sms( $CONTRACT_DATE2, $LOGIN_USER_ID, $LOGIN_USER_ID, 35, $SMS_CONTENT, $REMIND_URL );
}
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 + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -