📄 import.php

📁 通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含通达OA2008增強版接近完美破解补丁20081216集及最新通达OA2008ADV(

💻 PHP

字号:

<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_all.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( );
}
$title = array( "办公用品名称" => "PRO_NAME", "办公用品类别" => "OFFICE_PROTYPE", "单价" => "PRO_PRICE", "办公用品描述" => "PRO_DESC", "计量单位" => "PRO_UNIT", "供应商" => "PRO_SUPPLIER", "警戒库存" => "PRO_LOWSTOCK", "当前库存" => "PRO_STOCK", "创建人" => "PRO_CREATOR" );
$data = file_get_contents( $CSV_FILE );
$lines = csv2array( $data, $title );
if ( !$data )
{
	message( "错误", "打开文件错误!" );
	button_back( );
	exit( );
}
$ROW_COUNT = 0;
foreach ( $lines as $line )
{
	$DATA_NUM = count( $line );
	$STR_VALUE = "";
	$STR_KEY = "";
	foreach ( $line as $key => $value )
	{
		$STR_KEY .= $key.",";
		if ( $key != "OFFICE_PROTYPE" && $key != "PRO_CREATOR" )
		{
			$STR_VALUE .= "'".$value."',";
		}
		else
		{
			if ( $key == "PRO_CREATOR" )
			{
				$STR_VALUE .= "'".$LOGIN_USER_ID."',";
			}
			if ( $key == "OFFICE_PROTYPE" )
			{
				$Tquery = "SELECT CODE_NO FROM SYS_CODE WHERE CODE_NAME='".$value."' AND PARENT_NO='OFFICE_PROTYPE'";
				$Tcursor = exequery( $connection, $Tquery );
				if ( $TROW = mysql_fetch_array( $Tcursor ) )
				{
					$STR_VALUE .= "'".$TROW['0']."',";
				}
				else
				{
					$STR_VALUE .= "'".$value."',";
				}
			}
		}
	}
	if ( substr( $STR_KEY, -1 ) == "," )
	{
		$STR_KEY = substr( $STR_KEY, 0, -1 );
	}
	if ( substr( $STR_VALUE, -1 ) == "," )
	{
		$STR_VALUE = substr( $STR_VALUE, 0, -1 );
	}
	$query = "insert into OFFICE_PRODUCTS (".$STR_KEY.") values (".$STR_VALUE.")";
	exequery( $connection, $query );
	++$ROW_COUNT;
}
if ( file_exists( $CSV_FILE ) )
{
	@unlink( $CSV_FILE );
}
message( "", "共".$ROW_COUNT."条数据导入!" );
if ( 1 < $ROW_COUNT )
{
	echo "\t<script language=\"javascript\">\r\n\t\tparent.PRO_LIST.location=\"pro_list.php\";\r\n\t</script>\r\n";
}
echo "<div align=\"center\">\r\n<input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='pro_import.php';\" title=\"返回\">\r\n</div>\r\n</body>\r\n</html>\r\n";
?>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -