📄 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"> 导入CSV通讯簿</span><br>
</td>
</tr>
</table>
<br>
<br>
<div align="center" class="Big1">
<b>请指定用于导入的CSV文件：</b>
<form name="form1" method="post" action="import.php" 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>
<input type="button" value="返回" class="BigButton" onclick="location='index.php'">
</div>
<?
exit;
}
if(strtolower(substr($FILE_NAME,-3))!="csv")
{
Message("错误","只能导入CSV文件!");
Button_Back();
exit;
}
$ID_STR="PSN_NAME,SEX,NICK_NAME,BIRTHDAY,MINISTRATION,MATE,CHILD,DEPT_NAME,ADD_DEPT,POST_NO_DEPT,TEL_NO_DEPT,FAX_NO_DEPT,ADD_HOME,POST_NO_HOME,TEL_NO_HOME,MOBIL_NO,BP_NO,EMAIL,OICQ_NO,ICQ_NO,NOTES";
$ROW_COUNT = 0;
$handle = fopen ($CSV_FILE,"r");
$TITLE = fgetcsv ($handle, 10000, ",");
if(!$handle || !$TITLE)
{
Message("错误","打开文件错误!");
Button_Back();
exit;
}
$TITLE_NUM = count ($TITLE);
while ($DATA = fgetcsv ($handle, 10000, ","))
{
$DATA_NUM = count ($DATA);
$ROW_COUNT++;
for ($I=0; $I < $DATA_NUM; $I++)
{
$ID=match($TITLE[$I]);
if(find_id($ID_STR,$ID))
{
$ADDRESS[$ID]=$DATA[$I];
if($ID=="SEX")
if($DATA[$I]=="女")
$ADDRESS[$ID]="1";
else
$ADDRESS[$ID]="0";
}
}
$query="insert into ADDRESS (USER_ID,GROUP_ID,".$ID_STR.") values ('$LOGIN_USER_ID',$GROUP_ID,'".$ADDRESS["PSN_NAME"]."','".$ADDRESS["SEX"]."','".$ADDRESS["NICK_NAME"]."','".$ADDRESS["BIRTHDAY"]."','".$ADDRESS["MINISTRATION"]."','".$ADDRESS["MATE"]."','".$ADDRESS["CHILD"]."','".$ADDRESS["DEPT_NAME"]."','".$ADDRESS["ADD_DEPT"]."','".$ADDRESS["POST_NO_DEPT"]."','".$ADDRESS["TEL_NO_DEPT"]."','".$ADDRESS["FAX_NO_DEPT"]."','".$ADDRESS["ADD_HOME"]."','".$ADDRESS["POST_NO_HOME"]."','".$ADDRESS["TEL_NO_HOME"]."','".$ADDRESS["MOBIL_NO"]."','".$ADDRESS["BP_NO"]."','".$ADDRESS["EMAIL"]."','".$ADDRESS["OICQ_NO"]."','".$ADDRESS["ICQ_NO"]."','".$ADDRESS["NOTES"]."');";
exequery($connection,$query);
}
fclose ($handle);
if(file_exists($CSV_FILE))
unlink($CSV_FILE);
Message("","共".$ROW_COUNT."条数据导入!");
?>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location='index.php';" title="返回">
</div>
</body>
</html>
<?
function match($TITLE_NAME)
{
switch($TITLE_NAME)
{
case "姓名":
return "PSN_NAME";
case "性别":
return "SEX";
case "昵称":
return "NICK_NAME";
case "电子邮件地址":
return "EMAIL";
case "电子邮件":
return "EMAIL";
case "住宅所在街道":
return "ADD_HOME";
case "家庭所在街道":
return "ADD_HOME";
case "手机":
return "MOBIL_NO";
case "移动电话":
return "MOBIL_NO";
case "小灵通":
return "BP_NO";
case "传呼机":
return "BP_NO";
case "QQ":
return "OICQ_NO";
case "ICQ":
return "ICQ_NO";
case "生日":
return "BIRTHDAY";
case "家庭所在地邮政编码":
return "POST_NO_HOME";
case "住宅所在地的邮政编码":
return "POST_NO_HOME";
case "家庭所在街道":
return "ADD_HOME";
case "住宅所在街道":
return "ADD_HOME";
case "家庭电话1":
case "住宅电话":
return "TEL_NO_HOME";
case "公司所在地邮政编码":
return "POST_NO_DEPT";
case "公司所在地的邮政编码":
return "POST_NO_DEPT";
case "公司所在街道":
return "ADD_DEPT";
case "职位":
return "MINISTRATION";
case "职务":
return "MINISTRATION";
case "办公电话1":
return "TEL_NO_DEPT";
case "业务电话":
return "TEL_NO_DEPT";
case "公司传真":
return "FAX_NO_DEPT";
case "业务传真":
return "FAX_NO_DEPT";
case "配偶":
return "MATE";
case "子女":
return "CHILD";
case "公司":
return "DEPT_NAME";
case "附注":
return "NOTES";
default:
return;
}
}
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -