📄 import.php

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

function match( $TITLE_NAME )
{
	switch ( $TITLE_NAME )
	{
	case "资产编号" :
		return "CPTL_NO";
	case "资产名称" :
		return "CPTL_NAME";
	case "资产类别" :
		return "TYPE_ID";
	case "所属部门" :
		return "DEPT_ID";
	case "资产原值" :
		return "CPTL_VAL";
	case "残值(率)" :
		return "CPTL_BAL";
	case "折旧年限" :
		return "DPCT_YY";
	case "累计折旧" :
		return "SUM_DPCT";
	case "月折旧额" :
		return "MON_DPCT";
	case "资产性质" :
		return "CPTL_KIND";
	case "折旧提足" :
		return "FINISH_FLAG";
	case "增加日期" :
		return "CREATE_DATE";
	case "增加类型" :
		return "PRCS_ID";
	case "启用日期" :
		return "FROM_YYMM";
	case "减少日期" :
		return "DCR_DATE";
	case "减少类型" :
		return "DCR_PRCS_ID";
	case "保管人" :
		return "KEEPER";
	case "备注" :
		return "REMARK";
	}
	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<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n  <tr>\r\n    <td class=\"Big\"><img src=\"/images/menu/asset.gif\" align=\"absmiddle\"><span class=\"big3\"> 导入固定资产</span><br></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   {\r\n   \t  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 = "CPTL_NO,CPTL_NAME,TYPE_ID,DEPT_ID,CPTL_VAL,CPTL_BAL,DPCT_YY,SUM_DPCT,MON_DPCT,CPTL_KIND,FINISH_FLAG,CREATE_DATE,PRCS_ID,FROM_YYMM,DCR_DATE,DCR_PRCS_ID,KEEPER,REMARK";
$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];
		}
	}
	$query = "select * from CP_ASSET_TYPE  where TYPE_NAME='".$DATA['TYPE_ID']."'";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$DATA['TYPE_ID'] = $ROW['TYPE_ID'];
	}
	else
	{
		$DATA_ARRAY[$I]['MSG_ERROR'] = "导入失败，资产类别 ".$DATA['TYPE_ID']." 不存在";
		++$I;
		continue;
	}
	$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_ARRAY[$I]['MSG_ERROR'] = "导入失败，部门 ".$DATA['DEPT_ID']." 不存在";
		++$I;
		continue;
	}
	$query = "SELECT * from CP_PRCS_PROP where left(PRCS_CLASS,1)='A' and PRCS_LONG_DESC='".$DATA['PRCS_ID']."'";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$DATA['PRCS_ID'] = $ROW['PRCS_ID'];
	}
	else
	{
		$DATA_ARRAY[$I]['MSG_ERROR'] = "导入失败，增加类型 ".$DATA['PRCS_ID']." 不存在";
		++$I;
		continue;
	}
	if ( $DATA['DCR_PRCS_ID'] != "" )
	{
		$query = "SELECT * from CP_PRCS_PROP where left(PRCS_CLASS,1)='D' and PRCS_LONG_DESC='".$DATA['DCR_PRCS_ID']."'";
		$cursor = exequery( $connection, $query );
		if ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$DATA['DCR_PRCS_ID'] = $ROW['PRCS_ID'];
			break;
		}
		else
		{
			$DATA_ARRAY[$I]['MSG_ERROR'] = "导入失败，减少类型 ".$DATA['DCR_PRCS_ID']." 不存在";
			++$I;
		}
	}
	else
	{
		$DCR_PRCS_ID['DCR_PRCS_ID'] = "0";
		do
		{
		} while ( 0 );
		if ( $DATA['FINISH_FLAG'] == "提足" )
		{
			$DATA['FINISH_FLAG'] = "1";
		}
		if ( $DATA['FINISH_FLAG'] == "未提足" )
		{
			$DATA['FINISH_FLAG'] = "0";
		}
		if ( $DATA['CPTL_KIND'] == "资产" )
		{
			$DATA['CPTL_KIND'] = "01";
		}
		if ( $DATA['CPTL_KIND'] == "费用" )
		{
			$DATA['CPTL_KIND'] = "02";
		}
		$query = "insert into CP_CPTL_INFO (".$ID_STR.") values ('".$DATA['CPTL_NO']."','".$DATA['CPTL_NAME']."','".$DATA['TYPE_ID']."','".$DATA['DEPT_ID']."','".$DATA['CPTL_VAL']."','".$DATA['CPTL_BAL']."','".$DATA['DPCT_YY']."','".$DATA['SUM_DPCT']."','".$DATA['MON_DPCT']."','".$DATA['CPTL_KIND']."','".$DATA['FINISH_FLAG']."','".$DATA['CREATE_DATE']."','".$DATA['PRCS_ID']."','".$DATA['FROM_YYMM']."','".$DATA['DCR_DATE']."','".$DATA['DCR_PRCS_ID']."','".$DATA['KEEPER']."','".$DATA['REMARK']."');";
		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  </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]['CPTL_NO'];
	echo "</td>\r\n      <td>";
	echo $DATA_ARRAY[$I]['CPTL_NAME'];
	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";
?>
⌨️ 快捷键说明

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