📄 import.php
字号:
<?php
function match( $TITLE_NAME )
{
switch ( $TITLE_NAME )
{
case "部门" :
return "DEPT_ID";
case "姓名" :
return "USER_NAME";
case "性别" :
return "SEX";
case "生日" :
return "BIRTHDAY";
case "角色" :
return "USER_PRIV";
case "用户名" :
return "USER_ID";
case "别名" :
return "BYNAME";
case "用户排序号" :
return "USER_NO";
case "管理范围" :
return "POST_PRIV";
case "手机" :
return "MOBIL_NO";
case "手机号" :
return "MOBIL_NO";
case "IP" :
return "BIND_IP";
case "IP地址" :
return "BIND_IP";
}
return "";
}
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\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\"><span class=\"big3\"> 导入用户</span><br>\r\n </td>\r\n </tr>\r\n </table>\r\n \r\n";
if ( $FILE_NAME == "" )
{
echo "<script 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 document.form1.FILE_NAME.value=file_name;\r\n }\r\n \r\n return (true);\r\n}\r\n</script>\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 <input type=\"hidden\" name=\"GROUP_ID\" value=\"";
echo $GROUP_ID;
echo "\">\r\n <input type=\"submit\" value=\"导入\" class=\"BigButton\">\r\n </form>\r\n </div>\r\n";
exit( );
}
if ( strtolower( substr( $FILE_NAME, -3 ) ) != "csv" )
{
message( "错误", "只能导入CSV文件!" );
button_back( );
exit( );
}
$ID_STR = "USER_ID,BYNAME,USER_NAME,USER_NO,DEPT_ID,USER_PRIV,POST_PRIV,SEX,BIRTHDAY,MOBIL_NO,BIND_IP";
$ROW_COUNT = 0;
$handle = fopen( $CSV_FILE, "r" );
$TITLE = fgetcsv( $handle, 10000, "," );
if ( !$handle && !$TITLE )
{
message( "错误", "打开文件错误!" );
button_back( );
exit( );
}
$TITLE_NUM = count( $TITLE );
$I = 0;
while ( $DATA = fgetcsv( $handle, 10000, "," ) )
{
$DATA_NUM = count( $DATA );
$J = 0;
for ( ; $J < $TITLE_NUM; ++$J )
{
$ID = match( $TITLE[$J] );
if ( find_id( $ID_STR, $ID ) )
{
$DATA[$ID] = $DATA[$J];
$DATA_ARRAY[$I][$ID] = $DATA[$J];
}
}
if ( $DATA['USER_ID'] == "" )
{
$DATA_ARRAY[$I]['MSG_ERROR'] = "导入失败,用户名为空";
++$I;
}
else
{
$query = "select * from USER_PRIV where PRIV_NAME='".$DATA['USER_PRIV']."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$DATA['USER_PRIV'] = $ROW['USER_PRIV'];
}
else
{
$DATA_ARRAY[$I]['MSG_ERROR'] = "导入失败，角色 ".$DATA['USER_PRIV']." 不存在";
++$I;
continue;
}
if ( $DATA['SEX'] == "女" )
{
$DATA['SEX'] = "1";
}
else
{
$DATA['SEX'] = "0";
}
if ( $DATA['POST_PRIV'] == "全体" )
{
$DATA['POST_PRIV'] = "1";
}
else if ( $DATA['POST_PRIV'] == "指定部门" )
{
$DATA['POST_PRIV'] = "2";
}
else
{
$DATA['POST_PRIV'] = "0";
}
$query = "select * from DEPARTMENT where DEPT_NAME='".$DATA['DEPT_ID']."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$DATA['DEPT_ID'] = $ROW['DEPT_ID'];
}
else
{
$DATA['DEPT_ID'] = 0;
}
$PASSWORD = crypt( "" );
$query = "insert into USER (".$ID_STR.",PASSWORD,AVATAR,CALL_SOUND,DUTY_TYPE,SMS_ON,THEME,MENU_HIDE,EMAIL_CAPACITY,FOLDER_CAPACITY) values ('".$DATA['USER_ID']."','".$DATA['BYNAME']."','".$DATA['USER_NAME']."','".$DATA['USER_NO']."','".$DATA['DEPT_ID']."','".$DATA['USER_PRIV']."','".$DATA['POST_PRIV']."','".$DATA['SEX']."','".$DATA['BIRTHDAY']."','".$DATA['MOBIL_NO']."','".$DATA['BIND_IP']."','".$PASSWORD."','1','1','1','1','1','2',100,100);";
exequery( $connection, $query );
if ( 0 < mysql_affected_rows( ) )
{
++$ROW_COUNT;
}
else
{
$DATA_ARRAY[$I]['MSG_ERROR'] = "导入失败，用户已存在";
}
++$I;
}
}
fclose( $handle );
if ( file_exists( $CSV_FILE ) )
{
unlink( $CSV_FILE );
}
echo "<br>\r\n<table align=\"center\" border=\"0\" cellspacing=\"1\" width=\"100%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n <thead class=\"TableHeader\">\r\n <td nowrap align=\"center\">部门</td>\r\n <td nowrap align=\"center\">用户名</td>\r\n <td nowrap align=\"center\">姓名</td>\r\n <td nowrap align=\"center\">角色</td>\r\n <td nowrap align=\"center\">排序号</td>\r\n <td nowrap align=\"center\">管理范围</td>\r\n <td nowrap align=\"center\">信息</td>\r\n </thead>\r\n";
$I = 0;
for ( ; $I < count( $DATA_ARRAY ); ++$I )
{
if ( $DATA_ARRAY[$I]['MSG_ERROR'] != "" )
{
$TR_STYLE = "color:#FF0000";
}
else
{
$TR_STYLE = "";
$DATA_ARRAY[$I]['MSG_ERROR'] = "成功";
}
echo " <tr class=\"TableData\" align=\"center\" style=\"";
echo $TR_STYLE;
echo "\">\r\n <td>";
echo $DATA_ARRAY[$I]['DEPT_ID'];
echo "</td>\r\n <td>";
echo $DATA_ARRAY[$I]['USER_ID'];
echo "</td>\r\n <td>";
echo $DATA_ARRAY[$I]['USER_NAME'];
echo "</td>\r\n <td>";
echo $DATA_ARRAY[$I]['USER_PRIV'];
echo "</td>\r\n <td>";
echo $DATA_ARRAY[$I]['USER_NO'];
echo "</td>\r\n <td>";
echo $DATA_ARRAY[$I]['POST_PRIV'];
echo "</td>\r\n <td align=\"left\">";
echo $DATA_ARRAY[$I]['MSG_ERROR'];
echo "</td>\r\n </tr>\r\n";
}
echo "</table>\r\n";
message( "信息", "共".$ROW_COUNT."条数据导入!" );
echo "<br>\r\n<div align=\"center\">\r\n<input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='import.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 + -