?? import.php
字號:
<?
include_once("inc/auth.php");
include_once("inc/conn.php");
include_once("inc/utility.php");
?>
<html>
<head>
<title>導(dǎo)入數(shù)據(jù)</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<?
if(strtolower(substr($FILE_NAME,-3))!="csv")
{
Message("錯(cuò)誤","只能導(dǎo)入CSV文件!");
Button_Back();
exit;
}
$ID_STR="PROVIDER_NAME,PROVIDER_SHORT,PROVIDER_CODE,PROVIDER_AREA,PROVIDER_RECORDER,TEL_NO,FAX_NO,PROVIDER_WWW,EMAIL,PROVIDER_ADD,POSTALCODE,BANK,ACCOUNT,MEMO";
$handle = fopen ($CSV_FILE,"r");
$TITLE = fgetcsv ($handle, 10000, ",");
if(!$handle || !$TITLE)
{
Message("錯(cuò)誤","打開文件錯(cuò)誤!");
Button_Back();
exit;
}
$TITLE_NUM = count ($TITLE);
$query='';
$ROW_COUNT = 0;
while ($DATA = fgetcsv ($handle, 10000, ","))
{
$DATA_NUM = count ($DATA);
for ($I=0; $I < $DATA_NUM; $I++)
{
$ID=match($TITLE[$I]);
if(find_id($ID_STR,$ID))
{
$PRODUCT_INFO[$ID]=$DATA[$I];
if($ID=="PROVIDER_AREA")
{
$query = "SELECT * from SYS_CODE WHERE PARENT_NO='AREA' and CODE_NAME='".$DATA[$I]."'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$PRODUCT_INFO[$ID]=$ROW["CODE_NO"];
}
else
$PRODUCT_INFO[$ID]=0;
}
}
}
$query="insert into PROVIDER (".$ID_STR.") values ('".$PRODUCT_INFO["PROVIDER_NAME"]."','".$PRODUCT_INFO["PROVIDER_SHORT"]."','".$PRODUCT_INFO["PROVIDER_CODE"]."','".$PRODUCT_INFO["PROVIDER_AREA"]."','".$LOGIN_USER_ID."','".$PRODUCT_INFO["TEL_NO"]."','".$PRODUCT_INFO["FAX_NO"]."','".$PRODUCT_INFO["PROVIDER_WWW"]."','".$PRODUCT_INFO["EMAIL"]."','".$PRODUCT_INFO["PROVIDER_ADD"]."','".$PRODUCT_INFO["POSTALCODE"]."','".$PRODUCT_INFO["BANK"]."','".$PRODUCT_INFO["ACCOUNT"]."','".$PRODUCT_INFO["MEMO"]);";
exequery($connection,$query);
if ($PRODUCT_INFO['PRODUCT_NAME']=='' && $PRODUCT_INFO['SERVICE_NAME']=='') continue;
$ROW_COUNT++;
}
fclose ($handle);
if(file_exists($CSV_FILE))
unlink($CSV_FILE);
Message("","共".($ROW_COUNT)."條數(shù)據(jù)導(dǎo)入!");
?>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location='index.php';" title="返回">
</div>
</body>
</html>
<?
function match($TITLE_NAME)
{
switch($TITLE_NAME)
{
case "供應(yīng)商名稱":
return "PROVIDER_NAME";
case "供應(yīng)商編碼":
return "PROVIDER_CODE";
case "供應(yīng)商簡稱":
return "PROVIDER_SHORT";
case "電話":
return "TEL_NO";
case "傳真":
return "FAX_NO";
case "網(wǎng)址":
return "PROVIDER_WWW";
case "電子郵件":
return "EMAIL";
case "地區(qū)":
return "PROVIDER_AREA";
case "郵政編碼":
return "POSTALCODE";
case "詳細(xì)地址":
return "PROVIDER_ADD";
case "備注":
return "MEMO";
case "開戶行":
return "BANK";
case "帳號":
return "ACCOUNT";
default:
return;
}
}
}
?>?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -