📄 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;
}

if ($FLAG==1)
	$ID_STR="PRODUCT_NAME,PRODUCT_CODE,PRODUCT_TYPE,PRODUCT_MODE,MEASURE_UNIT,COST_PRICE,STANDARD_PRICE,PROVIDER_ID,PRODUCT_DESC,MEMO,MEMO1";
else
	$ID_STR="SERVICE_NAME,PROVIDER_ID,SERVICE_DESC,STANDARD_PRICE,MEMO,MEMO1";

$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++)
    {
		if ($FLAG==1)
			$ID=match1($TITLE[$I]);
		else
			$ID=match2($TITLE[$I]);
        if(find_id($ID_STR,$ID))
        {
           $PRODUCT_INFO[$ID]=$DATA[$I];
           if($ID=="PROVIDER_ID")
			{
			 $query = "SELECT * from PROVIDER WHERE PROVIDER_NAME='".$DATA[$I]."'";
			 $cursor= exequery($connection,$query);
			 if($ROW=mysql_fetch_array($cursor))
			 {
				 $PRODUCT_INFO[$ID]=$ROW["PROVIDER_ID"];
			 }
			 else
				 $PRODUCT_INFO[$ID]=0;
			}

		   if($ID=="PRODUCT_MODE")
			{
			 $query = "SELECT * from SYS_CODE WHERE PARENT_NO='PRODUCT_MODE' 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;
			}
       }
    }

	if ($FLAG==1)
		$query="insert into PRODUCT (".$ID_STR.") values ('".$PRODUCT_INFO["PRODUCT_NAME"]."','".$PRODUCT_INFO["PRODUCT_CODE"]."','".$PRODUCT_INFO["PRODUCT_TYPE"]."','".$PRODUCT_INFO["PRODUCT_MODE"]."','".$PRODUCT_INFO["MEASURE_UNIT"]."','".$PRODUCT_INFO["COST_PRICE"]."','".$PRODUCT_INFO["STANDARD_PRICE"]."','".$PRODUCT_INFO["PROVIDER_ID"]."','".$PRODUCT_INFO["PRODUCT_DESC"]."','".$PRODUCT_INFO["MEMO"]."','".$PRODUCT_INFO["MEMO1"]."');";
	else
		$query="insert into SERVICE (".$ID_STR.") values ('".$PRODUCT_INFO["SERVICE_NAME"]."','".$PRODUCT_INFO["PROVIDER_ID"]."','".$PRODUCT_INFO["SERVICE_DESC"]."','".$PRODUCT_INFO["STANDARD_PRICE"]."','".$PRODUCT_INFO["MEMO"]."','".$PRODUCT_INFO["MEMO1"]."');";
	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 match1($TITLE_NAME)
{
	switch($TITLE_NAME)
   {
      case "产品名称":
         return "PRODUCT_NAME";
      case "产品编码":
         return "PRODUCT_CODE";
      case "产品型号":
         return "PRODUCT_TYPE";
      case "产品类别":
         return "PRODUCT_MODE";
      case "计量单位":
         return "MEASURE_UNIT";
      case "成本价":
         return "COST_PRICE";
      case "出售价":
         return "STANDARD_PRICE";
      case "供应商":
         return "PROVIDER_ID";
      case "产品描述":
         return "PRODUCT_DESC";
      case "备注1":
         return "MEMO";
      case "备注2":
         return "MEMO1";
      default:
         return;
   }
}
function match2($TITLE_NAME)
{
	switch($TITLE_NAME)
   {
      case "服务名称":
         return "SERVICE_NAME";
      case "服务提供商":
      case "供应商":
         return "PROVIDER_ID";
      case "服务描述":
         return "SERVICE_DESC";
      case "服务收费标准":
         return "STANDARD_PRICE";
      case "备注1":
         return "MEMO";
      case "备注2":
         return "MEMO1";
      default:
         return;
   }
}
?>
⌨️ 快捷键说明

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