📄 import.php

📁 极限网络智能办公系统 - Office Automation 2.8 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 ( $FILE_NAME == "" )
{
	$query = "SELECT count(*) from SAL_DATA where FLOW_ID='{$FLOW_ID}'";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$ROW_COUNT = $ROW[0];
	}
	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";
	if ( $ROW_COUNT != 0 )
	{
		echo "  \t\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";
	}
	else
	{
		echo " \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";
	}
	echo "          \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?FLOW_ID=";
	echo $FLOW_ID;
	echo "\" 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  \r\n  <br>\r\n  <input type=\"button\" value=\"返回\" class=\"BigButton\" onclick=\"location='index.php'\">\r\n  ";
	if ( $FILE_NAME == "" )
	{
		message( "说明", "1)EXECL的工资报表的列顺序为姓名、工资项目，将部门、职务等列删除；<BR>2)将改好的EXECL工资报表另存为CSV格式的文件；" );
	}
	echo "  \r\n  </div>\r\n";
	exit( );
}
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;
$query = "SELECT ITEM_ID ,ITEM_NAME from SAL_ITEM";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$DATA_ITEM[$count] = $ROW['ITEM_NAME'];
	$DATA_ID[$count] = $ROW['ITEM_ID'];
	$DATA_INDEX[$count] = -1;
	++$count;
}
$query = "DELETE FROM `SAL_DATA` WHERE `FLOW_ID` = '{$FLOW_ID}'";
$cursor = exequery( $connection, $query );
while ( $DATA = fgetcsv( $handle, 10000, "," ) )
{
	$DATA_NUM = count( $DATA );
	if ( $ROW_COUNT == 0 )
	{
		$I = 1;
		for ( ;	$I < $DATA_NUM;	++$I	)
		{
			$Temp = 0;
			for ( ;	$Temp < $count;	++$Temp	)
			{
				if ( $DATA_ITEM[$Temp] == $DATA[$I] )
				{
					$DATA_INDEX[$Temp] = $I;
					break;
				}
			}
			if ( $Temp == $count )
			{
				echo "<font color=#FF6633><b>".$DATA[$I]."尚未在OA系统中的工资项目中定义！！</b></font><br>";
			}
		}
	}
	else
	{
		$query = "insert into SAL_DATA(FLOW_ID,USER_ID";
		$I = 1;
		for ( ;	$I <= $count;	++$I	)
		{
			$query .= ",S".$I;
		}
		$query1 = "SELECT USER_ID from USER where USER_NAME='{$DATA['0']}'";
		$cursor1 = exequery( $connection, $query1 );
		if ( !( $ROW = mysql_fetch_array( $cursor1 ) ) )
		{
			echo "<font color=#FF6633><b>员工".$DATA[0]."尚未在OA系统中注册！！</b></font><br>";
		}
		else
		{
			$query .= ") values ('{$FLOW_ID}','{$ROW['0']}'";
			$I = 1;
			for ( ;	$I <= $count;	++$I	)
			{
				if ( $DATA_INDEX[$I - 1] == -1 )
				{
					$query .= ",0";
				}
				else
				{
					$INDEX = $DATA_INDEX[$I - 1];
					$query .= ","."'{$DATA[$INDEX]}'";
				}
			}
			$query .= ")";
			echo "员工".$DATA[0]."的工资导入完成！！<br>";
			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 + -