📄 import.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';
}
default:
{
return '';
}
}
}
include_once 'inc/auth.php';
echo '<html>
<head>
<title>导入固定资产</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/asset.gif" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 导入固定资产</span><br></td>
</tr>
</table>
';
if (($FILE_NAME == ''))
{
echo '<s';
echo 'cript Language="JavaScript">
function CheckForm()
{
if(document.form1.CSV_FILE.value=="")
{
alert("请选择要导入的文件！");
return (false);
}
if (document.form1.CSV_FILE.value!="")
{
var file_temp=document.form1.CSV_FILE.value,file_name;
var Pos;
Pos=file_temp.lastIndexOf("\\\\");
file_name=file_temp.substring(Pos+1,file_temp.length);
';
echo ' document.form1.FILE_NAME.value=file_name;
}
return (true);
}
</script>
<br>
<br>
<div align="center" class="Big1">
<b>请指定用于导入的CSV文件：</b>
<form name="form1" method="post" action="import.php" enctype="multipart/form-data" onsubmit="return CheckForm();">
<input type="file" name="CSV_FILE" class="BigInput" size="30">
<input type="hidden" name="FILE_NAME">
<input type="';
echo 'hidden" name="GROUP_ID" value="';
echo $GROUP_ID;
echo '">
<input type="submit" value="导入" class="BigButton">
</form>
</div>
';
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 OR !$TITLE))
{
message ('错误', '打开文件错误!');
button_back ();
exit ();
}
$TITLE_NUM = count ($TITLE);
$I = 0;
while (true)
{
while (true)
{
while (true)
{
while ($DATA = fgetcsv ($handle, 10000, ','))
{
$DATA_NUM = count ($DATA);
for ($J = 0; ($J < $TITLE_NUM); ++$J)
{
$ID = match ($TITLE[$J]);
if (find_id ($ID_STR, $ID))
{
$DATA[$ID] = $DATA[$J];
$DATA_ARRAY[$I][$ID] = $DATA[$J];
continue;
}
}
$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'];
break;
}
$DATA_ARRAY[$I]['MSG_ERROR'] = (('导入失败，资产类别 '.$DATA['TYPE_ID']).' 不存在');
++$I;
}
break 3;
}
$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'];
break;
}
$DATA_ARRAY[$I]['MSG_ERROR'] = (('导入失败，增加类型 '.$DATA['PRCS_ID']).' 不存在');
++$I;
}
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'];
}
$DATA_ARRAY[$I]['MSG_ERROR'] = (('导入失败，减少类型 '.$DATA['DCR_PRCS_ID']).' 不存在');
++$I;
continue;
}
$DCR_PRCS_ID['DCR_PRCS_ID'] = '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>
<table align="center" border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
<thead class="TableHeader">
<td nowrap align="center">资产编号</td>
<td nowrap align="center">资产名称</td>
<td nowrap align="center">信息</td>
</thead>
';
for ($I = 0; ($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 '">
<td>';
echo $DATA_ARRAY[$I]['CPTL_NO'];
echo '</td>
<td>';
echo $DATA_ARRAY[$I]['CPTL_NAME'];
echo '</td>
<td align="left">';
echo $DATA_ARRAY[$I]['MSG_ERROR'];
echo '</td>
</tr>
';
}
echo '</table>
';
message ('信息', (('共'.$ROW_COUNT).'条数据导入!'));
echo '<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location=\'import.php\';" title="返回">
</div>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -