📄 import.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％源码
💻 PHP
字号:
<?
include_once("inc/auth.php");
include_once("inc/conn.php");
include_once("inc/utility.php");
?>
<html>
<head>
<title>导入数据</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("错误","只能导入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("错误","打开文件错误!");
   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)."条数据导入!");
?>
<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 "供应商名称":
         return "PROVIDER_NAME";
      case "供应商编码":
         return "PROVIDER_CODE";
      case "供应商简称":
         return "PROVIDER_SHORT";
      case "电话":
         return "TEL_NO";
      case "传真":
         return "FAX_NO";
      case "网址":
         return "PROVIDER_WWW";
      case "电子邮件":
         return "EMAIL";
      case "地区":
         return "PROVIDER_AREA";
      case "邮政编码":
         return "POSTALCODE";
      case "详细地址":
         return "PROVIDER_ADD";
      case "备注":
         return "MEMO";
      case "开户行":
         return "BANK";
      case "帐号":
         return "ACCOUNT";
      default:
         return;
   }
}
}
?>
⌨️ 快捷键说明

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