📄 import.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/conn.php");
include_once("inc/utility.php");
?>
<html>
<head>
<title>导入数据</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<?
if($FILE_NAME=="")
{
?>
<script Language="JavaScript">
function CheckForm()
{
if(document.form1.CSV_FILE.value=="")
{ alert("请选择要导入的文件！");
return (false);
}
if (document.form1.CSV_FILE.value!="")
{
var file_temp=document.form1.CSV_FILE.value,file_name;
var Pos;
Pos=file_temp.lastIndexOf("\\");
file_name=file_temp.substring(Pos+1,file_temp.length);
document.form1.FILE_NAME.value=file_name;
}
return (true);
}
</script>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/sys_config.gif" align="absmiddle"><span class="big3"> 导入人事数据</span><br>
</td>
</tr>
</table>
<br>
<br>
<div align="center" class="Big1">
<b>请指定用于导入的CSV文件：</b>
<form name="form1" method="post" action="import.php?FLOW_ID=<?=$FLOW_ID?>" enctype="multipart/form-data" onsubmit="return CheckForm();">
<input type="file" name="CSV_FILE" class="BigInput" size="30">
<input type="hidden" name="FILE_NAME">
<input type="hidden" name="GROUP_ID" value="<?=$GROUP_ID?>">
<input type="submit" value="导入" class="BigButton">
</form>
<br>
<?
if($FILE_NAME=="")
Message("说明","1)EXECL的人事报表的第一列必须为姓名,余下的列名称必须与人员档案基本信息相对应；<BR>2)将改好的EXECL工资报表另存为CSV格式的文件；");
?>
</div>
<?
exit;
}
if(strtolower(substr($FILE_NAME,-3))!="csv")
{
Message("错误","只能导入CSV文件!");
Button_Back();
exit;
}
$ROW_COUNT = 0;
$handle = fopen ($CSV_FILE,"r");
if(!$handle)
{
Message("错误","打开文件错误!");
Button_Back();
exit;
}
$count=0;
$FIELDMSG="USER_ID,NO,CARD_NO,MARRY,NATION,NATIVE_PLACE,HUKOU_PLACE,WORK_DATE,JOIN_DATE,EDUCATION,SPECIALITY,SCHOOL,POLITICS,POST,TECH_POST,HOME_ADDR,HOME_TEL,CERTIFICATE,REWARD,TRAIN,EDU,WORK,SOCIATY,POST_CHANGE,SURETY,CONTRACT,INSURE,BODY_EXAMIM,RESUME,HR_BIRTHDAY";
$FIELDMSGNAME="姓名,编号,身份证号码,婚姻状况,民族,籍贯,户口所在地,参加工作时间,加入本单位时间,学历,专业,毕业院校,政治面貌,职务,职称,家庭住址,家庭电话,职务情况,奖惩记录,培训记录,教育背景,工作简历,社会关系,岗位变动情况,担保记录,劳动合同签订情况,社保缴纳情况,体检记录,备 注,出生日期";
$DATA_ID=explode(",",$FIELDMSG);
$DATA_ITEM=explode(",",$FIELDMSGNAME);
$ARRAY_COUNT=sizeof($DATA_ID);
if($DATA_ID[$ARRAY_COUNT-1]=="")$ARRAY_COUNT--;
for($I=0;$I<$ARRAY_COUNT;$I++)
{
$DATA_INDEX[$I]=-1;
$count++;
}
while ($DATA = fgetcsv ($handle, 10000, ","))
{
$DATA_NUM = count ($DATA);
if ($ROW_COUNT==0)
{
for ($I=1; $I < $DATA_NUM; $I++)
{
for($Temp=0;$Temp< $count;$Temp++)
{
if($DATA_ITEM[$Temp]==$DATA[$I])
{
$UPDATA_ITEMID[$I]=$DATA_ID[$Temp];
$DATA_INDEX[$Temp]=$I;
BREAK;
}
}
if ($Temp==$count) { echo "<font color=#FF6633><b>".$DATA[$I]."尚未在OA系统中的人员档案基本信息中定义！！</b></font><br>"; $UPDATA_ITEMID[$I]="-1";}
}
}
else
{
$query="insert into HRMS (USER_ID ";
for ($I=1; $I < $DATA_NUM; $I++)
{
if($UPDATA_ITEMID[$I]=="-1")continue;
$query.=",".$UPDATA_ITEMID[$I];
}
$query1 = "SELECT USER_ID from USER where USER_NAME='$DATA[0]'";
$cursor1= exequery($connection,$query1);
if(!$ROW=mysql_fetch_array($cursor1))
{
echo "<font color=#FF6633><b>员工".$DATA[0]."尚未在OA系统中注册！！</b></font><br>";
continue;
}
$query.=") values ('$ROW[0]'";
for ($I=1; $I <=$count; $I++)
{
if ($DATA_INDEX[$I-1]==-1)
{$query.=" ";}
else
{
$INDEX=$DATA_INDEX[$I-1];
$query.=","."'$DATA[$INDEX]'";
}
}
$query.=")";
echo "员工".$DATA[0]."的人事档案导入完成！！<br>";
exequery($connection,$query);
}
$ROW_COUNT++;
}
fclose ($handle);
if(file_exists($CSV_FILE))
unlink($CSV_FILE);
Message("","共".($ROW_COUNT-1)."条数据导入!");
?>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location='index.php';" title="返回">
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -