📄 add.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");
?>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<?
$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(count($_FILES)>1)
{
$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)
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." 劳动合同转正";
//if($POSITIVE_DATE!="0000-00-00"&&$POSITIVE!="")
//{
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);
}
?>
<script>
URL="user_list.php";
parent.frames["user_list"].location=URL;
</script>
<?
}
?>
<script>
URL="user_new.php?DEPT_ID=<?=$DEPT_ID?>";
window.location=URL;
</script>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -