📄 import_ok.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％源码
💻 PHP
字号:
<?php
 

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 ( 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 = "BOOK_NAME,TYPE_ID,AUTHOR,ISBN,PUB_HOUSE,PUB_DATE,AREA,PRICE,BRIEF,AMT,OPEN,LEND,MEMO,DEPT,BOOK_NO";
$FIELDMSGNAME = "书名,图书类别,作者,ISBN号,出版社,出版日期,存放地点,价格,内容简介,数量,借阅范围,借阅状态,备注,部门,图书编号";
$DATA_ID = explode( ",", $FIELDMSG );
$DATA_ITEM = explode( ",", $FIELDMSGNAME );
$ARRAY_COUNT = sizeof( $DATA_ID );
if ( $DATA_ID[$ARRAY_COUNT - 1] == "" )
{
	--$ARRAY_COUNT;
}
$I = 0;
for ( ;	$I < $ARRAY_COUNT;	++$I	)
{
	$DATA_INDEX[$I] = -1;
	++$count;
}
while ( $DATA = fgetcsv( $handle, 10000, "," ) )
{
	$DATA_NUM = count( $DATA );
	if ( $ROW_COUNT == 0 )
	{
		$I = 0;
		for ( ;	do
	{
	$I < $DATA_NUM;	++$I	)
			{
				$Temp = 0;
				for ( ;	$Temp < $count;	++$Temp	)
				{
					if ( !( $DATA_ITEM[$Temp] == $DATA[$I] ) )
					{
						continue;
					}
					$UPDATA_ITEMID[$I] = $DATA_ID[$Temp];
					$DATA_INDEX[$I] = $Temp;
					break;
				}
				if ( $Temp == $count )
				{
					echo "<font color=#FF6633><b>".$DATA[$I]."尚未在图书基本信息中定义！！</b></font><br>";
					$UPDATA_ITEMID[$I] = "-1";
				}
				break;
			}
		} while ( 1 );
	}
	else
	{
		$query = "insert into BOOK_INFO(BORR_PERSON,";
		$I = 0;
		for ( ;	$I < $DATA_NUM;	++$I	)
		{
			if ( !( $UPDATA_ITEMID[$I] == "-1" ) )
			{
				if ( $I != $DATA_NUM - 1 )
				{
					$query .= $UPDATA_ITEMID[$I].",";
				}
				else
				{
					$query .= $UPDATA_ITEMID[$I];
				}
			}
		}
		$query .= ") values ('".$LOGIN_USER_NAME."',";
		$I = 0;
		for ( ;	$I < $DATA_NUM;	++$I	)
		{
			if ( !( $UPDATA_ITEMID[$I] == "-1" ) )
			{
				if ( $UPDATA_ITEMID[$I] == "TYPE_ID" )
				{
					$query1 = "SELECT * from BOOK_TYPE where TYPE_NAME='".$DATA[$I]."'";
					$cursor1 = exequery( $connection, $query1 );
					if ( $ROW = mysql_fetch_array( $cursor1 ) )
					{
						$DATA[$I] = $ROW['TYPE_ID'];
					}
				}
				if ( $UPDATA_ITEMID[$I] == "DEPT" )
				{
					$query1 = "select DEPT_ID from DEPARTMENT where DEPT_NAME='".$DATA[$I]."'";
					$cursor1 = exequery( $connection, $query1 );
					if ( $ROW = mysql_fetch_array( $cursor1 ) )
					{
						$DATA[$I] = $ROW['DEPT_ID'];
					}
				}
				if ( $UPDATA_ITEMID[$I] == "OPEN" )
				{
					if ( $DATA[$I] == "本部门" )
					{
						$DATA[$I] = 0;
					}
					else
					{
						$DATA[$I] = 1;
					}
				}
				if ( $UPDATA_ITEMID[$I] == "LEND" )
				{
					if ( $DATA[$I] == "未借出" )
					{
						$DATA[$I] = 0;
					}
					else
					{
						$DATA[$I] = 1;
					}
				}
				if ( $I != $DATA_NUM - 1 )
				{
					$query .= "'".$DATA[$I]."',";
				}
				else
				{
					$query .= "'".$DATA[$I]."'";
				}
			}
		}
		$query .= ")";
		exequery( $connection, $query );
	}
	++$ROW_COUNT;
}
fclose( $handle );
if ( file_exists( $CSV_FILE ) )
{
	unlink( $CSV_FILE );
}
message( "", ( "共".( $ROW_COUNT - 1 ) )."条数据导入!" );
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";
?>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -