📄 import.php
字号:
<?php
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 :
break;
}
}
include_once( "inc/auth.php" );
include_once( "inc/conn.php" );
include_once( "inc/utility.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";
if ( $FILE_NAME == "" )
{
echo "<s";
echo "cript Language=\"JavaScript\">\r\nfunction CheckForm()\r\n{\r\n if(document.form1.CSV_FILE.value==\"\")\r\n { alert(\"请选择要导入的文件！\");\r\n return (false);\r\n }\r\n\r\n if (document.form1.CSV_FILE.value!=\"\")\r\n {\r\n var file_temp=document.form1.CSV_FILE.value,file_name;\r\n var Pos;\r\n Pos=file_temp.lastIndexOf(\"\\\\\");\r\n file_name=file_temp.substring(Pos+1,file_temp.length);\r\n docume";
echo "nt.form1.FILE_NAME.value=file_name;\r\n }\r\n \r\n return (true);\r\n}\r\n</script>\r\n\r\n <table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/sys_config.gif\" align=\"absmiddle\">";
echo "<s";
echo "pan class=\"big3\"> 导入CSV通讯簿</span><br>\r\n </td>\r\n </tr>\r\n </table>\r\n \r\n <br>\r\n <br>\r\n \r\n <div align=\"center\" class=\"Big1\">\r\n <b>请指定用于导入的CSV文件：</b>\r\n <form name=\"form1\" method=\"post\" action=\"import.php\" enctype=\"multipart/form-data\" onsubmit=\"return CheckForm();\">\r\n <input type=\"file\" name=\"CSV_FILE\" class=\"BigInput\" size=\"30\">\r\n <input type=\"hidden\" name=\"FILE_NAME\">\r\n <in";
echo "put type=\"hidden\" name=\"GROUP_ID\" value=\"";
echo $GROUP_ID;
echo "\">\r\n <input type=\"submit\" value=\"导入\" class=\"BigButton\">\r\n </form>\r\n <br>\r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onclick=\"location='index.php'\">\r\n </div>\r\n";
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;
$I = 0;
for ( ; $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 ('',{$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."条数据导入!" );
echo "<div align=\"center\">\r\n<input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='index.php';\" title=\"返回\">\r\n</div>\r\n\r\n</body>\r\n</html>\r\n\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -