📄 import.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％源码
💻 PHP
字号:
<?
include_once("inc/auth.php");
include_once("inc/conn.php");
include_once("inc/utility.php");
include_once("inc/utility_all.php");

?>
<html>
<head>
<title>导入供应商</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<?
if($FILE_NAME=="")
{
?>
<script 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);
     document.form1.FILE_NAME.value=file_name;
   }

   return (true);
}
</script>

  <table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
    <tr>
      <td class="Big"><img src="/images/sys_config.gif" align="absmiddle"><span class="big3"> 导入供应商资料</span><br>
      </td>
    </tr>
  </table>
  <br>
  <br>
  <div align="center" class="Big1">
  <b>请指定用于导入的CSV文件：</b>
  <form name="form1" method="post" action="import.php?FLOW_ID=<?=$FLOW_ID?>" 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="hidden" name="GROUP_ID" value="<?=$GROUP_ID?>">
    <input type="submit" value="导入" class="BigButton">
  </form>
  <br>
  <input value="返回" type="button" class="BigButton" title="返回" name="button"  onclick="location='index.php'">&nbsp;&nbsp;
  </div>
<?
   exit;
}
if(strtolower(substr($FILE_NAME,-3))!="csv")
{
   Message("错误","只能导入CSV文件!");
   Button_Back();
   exit;
}
$ROW_COUNT = 0;
$handle = fopen ($CSV_FILE,"r");
if(!$handle)
{
   Message("错误","打开文件错误!");
   Button_Back();
   exit;
}
$count=0;
$FIELDMSG="PROVIDER_NAME,PROVIDER_SHORT,PROVIDER_CODE,PROVIDER_AREA,TEL_NO,FAX_NO,PROVIDER_WWW,EMAIL,PROVIDER_ADD,POSTALCODE,BANK,ACCOUNT,MEMO";
$FIELDMSGNAME="供应商名称,供应商简称,供应商编码,地区,电话,传真,网址,电子邮件,详细地址,邮政编码,开户行,帐号,备注";
$DATA_ID=explode(",",$FIELDMSG);
$DATA_ITEM=explode(",",$FIELDMSGNAME);
$ARRAY_COUNT=sizeof($DATA_ID);
if($DATA_ID[$ARRAY_COUNT-1]=="")$ARRAY_COUNT--;
for($I=0;$I<$ARRAY_COUNT;$I++)
{
  $DATA_INDEX[$I]=-1;
  $count++;
}
$ISNOT_COUNT=0;
while ($DATA = fgetcsv ($handle, 10000, ","))
{
    $DATA_NUM = count ($DATA);
    if ($ROW_COUNT==0)
    {
       for ($I=0; $I < $DATA_NUM; $I++)
       {
        for($Temp=0;$Temp< $count;$Temp++)
        {
         if($DATA_ITEM[$Temp]==$DATA[$I])
         {
         	  $UPDATA_ITEMID[$I]=$DATA_ID[$Temp];
            $DATA_INDEX[$I]=$Temp;
            BREAK;
         }
        }
        if ($Temp==$count) {
			$ISNOT_COUNT++;echo "<font color=#FF6633><b>".$DATA[$I]."尚未在OA系统中的供应商基本信息中定义！！</b></font><br>"; $UPDATA_ITEMID[$I]="-1";}
       }
    }
   else
     {
     	 $query="insert into PROVIDER (PROVIDER_RECORDER,";
       for ($I=0; $I < $DATA_NUM; $I++)
        {
          if($UPDATA_ITEMID[$I]=="-1")continue;
         if($I!=($DATA_NUM-$ISNOT_COUNT-1)){$query.=$UPDATA_ITEMID[$I].",";}
         else $query.=$UPDATA_ITEMID[$I];
        }
//		$query=substr($query,0,strlen($query)-1);
       $query.=") values ('$LOGIN_USER_ID',";
       for ($I=0; $I < $DATA_NUM; $I++)
       {
          if($UPDATA_ITEMID[$I]=="-1")
          {continue;}
          else
          {
          	if ($UPDATA_ITEMID[$I]=="PROVIDER_AREA")
          	{
          	  $query1="SELECT * from SYS_CODE WHERE PARENT_NO='AREA' and CODE_NAME='".$DATA[$I]."'";
              $cursor1= exequery($connection,$query1);
			  if($ROW=mysql_fetch_array($cursor1))
			  {
				 $DATA[$I]=$ROW["CODE_NO"];
			  }
			  else
				 $DATA[$I]=0;
          	}
          	 if ($UPDATA_ITEMID[$I]=="PROVIDER_NAME")
          	{
              $PROVIDER_NAME=$DATA[$I];
          	}
			
          	$DATA[$I]=format_cvs($DATA[$I]);  
         	  if($I!=($DATA_NUM-$ISNOT_COUNT-1))$query.="'$DATA[$I]'".",";
            else $query.="'$DATA[$I]'";
          }

       }
		//$query=substr($query,0,strlen($query)-1);
       $query.=")";
       echo "供应商".$PROVIDER_NAME."的资料导入完成！！<br>";
       exequery($connection,$query);

     }
  $ROW_COUNT++;
}
fclose ($handle);
if(file_exists($CSV_FILE))
   unlink($CSV_FILE);
Message("","共".($ROW_COUNT-1)."条数据导入!");
?>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location='index.php';" title="返回">
</div>
</body>
</html>
⌨️ 快捷键说明

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